CREATE OR REPLACE FUNCTION "USF_CALC_ROW_START"
(
PG_NUM_IN NUMBER,
TOTAL_REC_PER_PG_IN NUMBER
)
RETURN NUMBER
AS
BEGIN
RETURN ((PG_NUM_IN - 1) * TOTAL_REC_PER_PG_IN) + 1;
END;
CREATE OR REPLACE FUNCTION "USF_CALC_ROW_END"
(
PG_NUM_IN NUMBER,
TOTAL_REC_PER_PG_IN NUMBER
)
RETURN NUMBER
AS
BEGIN
RETURN (PG_NUM_IN * TOTAL_REC_PER_PG_IN) + 1;
END;
(
PG_NUM_IN NUMBER,
TOTAL_REC_PER_PG_IN NUMBER
)
RETURN NUMBER
AS
BEGIN
RETURN ((PG_NUM_IN - 1) * TOTAL_REC_PER_PG_IN) + 1;
END;
CREATE OR REPLACE FUNCTION "USF_CALC_ROW_END"
(
PG_NUM_IN NUMBER,
TOTAL_REC_PER_PG_IN NUMBER
)
RETURN NUMBER
AS
BEGIN
RETURN (PG_NUM_IN * TOTAL_REC_PER_PG_IN) + 1;
END;