1810: ) RETURN bchv_rec_type IS
1811: l_bchv_rec bchv_rec_type := p_bchv_rec;
1812: BEGIN
1813: l_bchv_rec.CREATION_DATE := SYSDATE;
1814: l_bchv_rec.CREATED_BY := Fnd_Global.USER_ID;
1815: l_bchv_rec.LAST_UPDATE_DATE := l_bchv_rec.CREATION_DATE;
1816: l_bchv_rec.LAST_UPDATED_BY := Fnd_Global.USER_ID;
1817: l_bchv_rec.LAST_UPDATE_LOGIN := Fnd_Global.LOGIN_ID;
1818: RETURN(l_bchv_rec);
1812: BEGIN
1813: l_bchv_rec.CREATION_DATE := SYSDATE;
1814: l_bchv_rec.CREATED_BY := Fnd_Global.USER_ID;
1815: l_bchv_rec.LAST_UPDATE_DATE := l_bchv_rec.CREATION_DATE;
1816: l_bchv_rec.LAST_UPDATED_BY := Fnd_Global.USER_ID;
1817: l_bchv_rec.LAST_UPDATE_LOGIN := Fnd_Global.LOGIN_ID;
1818: RETURN(l_bchv_rec);
1819: END fill_who_columns;
1820: ----------------------------------------------
1813: l_bchv_rec.CREATION_DATE := SYSDATE;
1814: l_bchv_rec.CREATED_BY := Fnd_Global.USER_ID;
1815: l_bchv_rec.LAST_UPDATE_DATE := l_bchv_rec.CREATION_DATE;
1816: l_bchv_rec.LAST_UPDATED_BY := Fnd_Global.USER_ID;
1817: l_bchv_rec.LAST_UPDATE_LOGIN := Fnd_Global.LOGIN_ID;
1818: RETURN(l_bchv_rec);
1819: END fill_who_columns;
1820: ----------------------------------------------
1821: -- Set_Attributes for:OKL_BILLING_CHARGES_V --
1830: x_bchv_rec.OBJECT_VERSION_NUMBER := 1;
1831: x_bchv_rec.SFWT_FLAG := 'N';
1832: -- Begin Post-Generation Change
1833: SELECT
1834: DECODE(Fnd_Global.CONC_REQUEST_ID,-1,NULL,Fnd_Global.CONC_REQUEST_ID),
1835: DECODE(Fnd_Global.PROG_APPL_ID, -1,NULL,Fnd_Global.PROG_APPL_ID),
1836: DECODE(Fnd_Global.CONC_PROGRAM_ID,-1,NULL,Fnd_Global.CONC_PROGRAM_ID),
1837: DECODE(Fnd_Global.CONC_REQUEST_ID,-1,NULL,SYSDATE)
1838: INTO
1831: x_bchv_rec.SFWT_FLAG := 'N';
1832: -- Begin Post-Generation Change
1833: SELECT
1834: DECODE(Fnd_Global.CONC_REQUEST_ID,-1,NULL,Fnd_Global.CONC_REQUEST_ID),
1835: DECODE(Fnd_Global.PROG_APPL_ID, -1,NULL,Fnd_Global.PROG_APPL_ID),
1836: DECODE(Fnd_Global.CONC_PROGRAM_ID,-1,NULL,Fnd_Global.CONC_PROGRAM_ID),
1837: DECODE(Fnd_Global.CONC_REQUEST_ID,-1,NULL,SYSDATE)
1838: INTO
1839: x_bchv_rec.request_id,
1832: -- Begin Post-Generation Change
1833: SELECT
1834: DECODE(Fnd_Global.CONC_REQUEST_ID,-1,NULL,Fnd_Global.CONC_REQUEST_ID),
1835: DECODE(Fnd_Global.PROG_APPL_ID, -1,NULL,Fnd_Global.PROG_APPL_ID),
1836: DECODE(Fnd_Global.CONC_PROGRAM_ID,-1,NULL,Fnd_Global.CONC_PROGRAM_ID),
1837: DECODE(Fnd_Global.CONC_REQUEST_ID,-1,NULL,SYSDATE)
1838: INTO
1839: x_bchv_rec.request_id,
1840: x_bchv_rec.program_application_id,
1833: SELECT
1834: DECODE(Fnd_Global.CONC_REQUEST_ID,-1,NULL,Fnd_Global.CONC_REQUEST_ID),
1835: DECODE(Fnd_Global.PROG_APPL_ID, -1,NULL,Fnd_Global.PROG_APPL_ID),
1836: DECODE(Fnd_Global.CONC_PROGRAM_ID,-1,NULL,Fnd_Global.CONC_PROGRAM_ID),
1837: DECODE(Fnd_Global.CONC_REQUEST_ID,-1,NULL,SYSDATE)
1838: INTO
1839: x_bchv_rec.request_id,
1840: x_bchv_rec.program_application_id,
1841: x_bchv_rec.program_id,
3003: ) RETURN bchv_rec_type IS
3004: l_bchv_rec bchv_rec_type := p_bchv_rec;
3005: BEGIN
3006: l_bchv_rec.LAST_UPDATE_DATE := SYSDATE;
3007: l_bchv_rec.LAST_UPDATED_BY := Fnd_Global.USER_ID;
3008: l_bchv_rec.LAST_UPDATE_LOGIN := Fnd_Global.LOGIN_ID;
3009: RETURN(l_bchv_rec);
3010: END fill_who_columns;
3011: ----------------------------------
3004: l_bchv_rec bchv_rec_type := p_bchv_rec;
3005: BEGIN
3006: l_bchv_rec.LAST_UPDATE_DATE := SYSDATE;
3007: l_bchv_rec.LAST_UPDATED_BY := Fnd_Global.USER_ID;
3008: l_bchv_rec.LAST_UPDATE_LOGIN := Fnd_Global.LOGIN_ID;
3009: RETURN(l_bchv_rec);
3010: END fill_who_columns;
3011: ----------------------------------
3012: -- FUNCTION populate_new_record --
3275: x_bchv_rec := p_bchv_rec;
3276: x_bchv_rec.OBJECT_VERSION_NUMBER := NVL(x_bchv_rec.OBJECT_VERSION_NUMBER, 0) + 1;
3277: -- Begin Post-Generation Change
3278: SELECT
3279: NVL(DECODE(Fnd_Global.CONC_REQUEST_ID,-1,NULL,Fnd_Global.CONC_REQUEST_ID),
3280: x_bchv_rec.request_id),
3281: NVL(DECODE(Fnd_Global.PROG_APPL_ID, -1,NULL,Fnd_Global.PROG_APPL_ID),
3282: x_bchv_rec.program_application_id),
3283: NVL(DECODE(Fnd_Global.CONC_PROGRAM_ID,-1,NULL,Fnd_Global.CONC_PROGRAM_ID),
3277: -- Begin Post-Generation Change
3278: SELECT
3279: NVL(DECODE(Fnd_Global.CONC_REQUEST_ID,-1,NULL,Fnd_Global.CONC_REQUEST_ID),
3280: x_bchv_rec.request_id),
3281: NVL(DECODE(Fnd_Global.PROG_APPL_ID, -1,NULL,Fnd_Global.PROG_APPL_ID),
3282: x_bchv_rec.program_application_id),
3283: NVL(DECODE(Fnd_Global.CONC_PROGRAM_ID,-1,NULL,Fnd_Global.CONC_PROGRAM_ID),
3284: x_bchv_rec.program_id),
3285: DECODE(DECODE(Fnd_Global.CONC_REQUEST_ID,-1,NULL,SYSDATE),
3279: NVL(DECODE(Fnd_Global.CONC_REQUEST_ID,-1,NULL,Fnd_Global.CONC_REQUEST_ID),
3280: x_bchv_rec.request_id),
3281: NVL(DECODE(Fnd_Global.PROG_APPL_ID, -1,NULL,Fnd_Global.PROG_APPL_ID),
3282: x_bchv_rec.program_application_id),
3283: NVL(DECODE(Fnd_Global.CONC_PROGRAM_ID,-1,NULL,Fnd_Global.CONC_PROGRAM_ID),
3284: x_bchv_rec.program_id),
3285: DECODE(DECODE(Fnd_Global.CONC_REQUEST_ID,-1,NULL,SYSDATE),
3286: NULL,x_bchv_rec.program_update_date,SYSDATE)
3287: INTO
3281: NVL(DECODE(Fnd_Global.PROG_APPL_ID, -1,NULL,Fnd_Global.PROG_APPL_ID),
3282: x_bchv_rec.program_application_id),
3283: NVL(DECODE(Fnd_Global.CONC_PROGRAM_ID,-1,NULL,Fnd_Global.CONC_PROGRAM_ID),
3284: x_bchv_rec.program_id),
3285: DECODE(DECODE(Fnd_Global.CONC_REQUEST_ID,-1,NULL,SYSDATE),
3286: NULL,x_bchv_rec.program_update_date,SYSDATE)
3287: INTO
3288: x_bchv_rec.request_id,
3289: x_bchv_rec.program_application_id,