DBA Data[Home] [Help]

APPS.OKL_ADJ_PVT dependencies on FND_GLOBAL

Line 1787: l_adjv_rec.CREATED_BY := FND_GLOBAL.USER_ID;

1783: ) RETURN adjv_rec_type IS
1784: l_adjv_rec adjv_rec_type := p_adjv_rec;
1785: BEGIN
1786: l_adjv_rec.CREATION_DATE := SYSDATE;
1787: l_adjv_rec.CREATED_BY := FND_GLOBAL.USER_ID;
1788: l_adjv_rec.LAST_UPDATE_DATE := l_adjv_rec.CREATION_DATE;
1789: l_adjv_rec.LAST_UPDATED_BY := FND_GLOBAL.USER_ID;
1790: l_adjv_rec.LAST_UPDATE_LOGIN := FND_GLOBAL.LOGIN_ID;
1791: RETURN(l_adjv_rec);

Line 1789: l_adjv_rec.LAST_UPDATED_BY := FND_GLOBAL.USER_ID;

1785: BEGIN
1786: l_adjv_rec.CREATION_DATE := SYSDATE;
1787: l_adjv_rec.CREATED_BY := FND_GLOBAL.USER_ID;
1788: l_adjv_rec.LAST_UPDATE_DATE := l_adjv_rec.CREATION_DATE;
1789: l_adjv_rec.LAST_UPDATED_BY := FND_GLOBAL.USER_ID;
1790: l_adjv_rec.LAST_UPDATE_LOGIN := FND_GLOBAL.LOGIN_ID;
1791: RETURN(l_adjv_rec);
1792: END fill_who_columns;
1793: --------------------------------------------

Line 1790: l_adjv_rec.LAST_UPDATE_LOGIN := FND_GLOBAL.LOGIN_ID;

1786: l_adjv_rec.CREATION_DATE := SYSDATE;
1787: l_adjv_rec.CREATED_BY := FND_GLOBAL.USER_ID;
1788: l_adjv_rec.LAST_UPDATE_DATE := l_adjv_rec.CREATION_DATE;
1789: l_adjv_rec.LAST_UPDATED_BY := FND_GLOBAL.USER_ID;
1790: l_adjv_rec.LAST_UPDATE_LOGIN := FND_GLOBAL.LOGIN_ID;
1791: RETURN(l_adjv_rec);
1792: END fill_who_columns;
1793: --------------------------------------------
1794: -- Set_Attributes for:OKL_TRX_AR_ADJSTS_V --

Line 1806: DECODE(Fnd_Global.CONC_REQUEST_ID,-1,NULL,Fnd_Global.CONC_REQUEST_ID),

1802: x_adjv_rec := p_adjv_rec;
1803: x_adjv_rec.OBJECT_VERSION_NUMBER := 1;
1804: -- Begin Post-Generation Change
1805: SELECT
1806: DECODE(Fnd_Global.CONC_REQUEST_ID,-1,NULL,Fnd_Global.CONC_REQUEST_ID),
1807: DECODE(Fnd_Global.PROG_APPL_ID, -1,NULL,Fnd_Global.PROG_APPL_ID),
1808: DECODE(Fnd_Global.CONC_PROGRAM_ID,-1,NULL,Fnd_Global.CONC_PROGRAM_ID),
1809: DECODE(Fnd_Global.CONC_REQUEST_ID,-1,NULL,SYSDATE)
1810: INTO

Line 1807: DECODE(Fnd_Global.PROG_APPL_ID, -1,NULL,Fnd_Global.PROG_APPL_ID),

1803: x_adjv_rec.OBJECT_VERSION_NUMBER := 1;
1804: -- Begin Post-Generation Change
1805: SELECT
1806: DECODE(Fnd_Global.CONC_REQUEST_ID,-1,NULL,Fnd_Global.CONC_REQUEST_ID),
1807: DECODE(Fnd_Global.PROG_APPL_ID, -1,NULL,Fnd_Global.PROG_APPL_ID),
1808: DECODE(Fnd_Global.CONC_PROGRAM_ID,-1,NULL,Fnd_Global.CONC_PROGRAM_ID),
1809: DECODE(Fnd_Global.CONC_REQUEST_ID,-1,NULL,SYSDATE)
1810: INTO
1811: x_adjv_rec.request_id,

Line 1808: DECODE(Fnd_Global.CONC_PROGRAM_ID,-1,NULL,Fnd_Global.CONC_PROGRAM_ID),

1804: -- Begin Post-Generation Change
1805: SELECT
1806: DECODE(Fnd_Global.CONC_REQUEST_ID,-1,NULL,Fnd_Global.CONC_REQUEST_ID),
1807: DECODE(Fnd_Global.PROG_APPL_ID, -1,NULL,Fnd_Global.PROG_APPL_ID),
1808: DECODE(Fnd_Global.CONC_PROGRAM_ID,-1,NULL,Fnd_Global.CONC_PROGRAM_ID),
1809: DECODE(Fnd_Global.CONC_REQUEST_ID,-1,NULL,SYSDATE)
1810: INTO
1811: x_adjv_rec.request_id,
1812: x_adjv_rec.program_application_id,

Line 1809: DECODE(Fnd_Global.CONC_REQUEST_ID,-1,NULL,SYSDATE)

1805: SELECT
1806: DECODE(Fnd_Global.CONC_REQUEST_ID,-1,NULL,Fnd_Global.CONC_REQUEST_ID),
1807: DECODE(Fnd_Global.PROG_APPL_ID, -1,NULL,Fnd_Global.PROG_APPL_ID),
1808: DECODE(Fnd_Global.CONC_PROGRAM_ID,-1,NULL,Fnd_Global.CONC_PROGRAM_ID),
1809: DECODE(Fnd_Global.CONC_REQUEST_ID,-1,NULL,SYSDATE)
1810: INTO
1811: x_adjv_rec.request_id,
1812: x_adjv_rec.program_application_id,
1813: x_adjv_rec.program_id,

Line 2897: l_adjv_rec.CREATED_BY := Fnd_Global.USER_ID;

2893: ) RETURN adjv_rec_type IS
2894: l_adjv_rec adjv_rec_type := p_adjv_rec;
2895: BEGIN
2896: l_adjv_rec.CREATION_DATE := SYSDATE;
2897: l_adjv_rec.CREATED_BY := Fnd_Global.USER_ID;
2898: l_adjv_rec.LAST_UPDATE_DATE := SYSDATE;
2899: l_adjv_rec.LAST_UPDATED_BY := FND_GLOBAL.USER_ID;
2900: l_adjv_rec.LAST_UPDATE_LOGIN := FND_GLOBAL.LOGIN_ID;
2901: RETURN(l_adjv_rec);

Line 2899: l_adjv_rec.LAST_UPDATED_BY := FND_GLOBAL.USER_ID;

2895: BEGIN
2896: l_adjv_rec.CREATION_DATE := SYSDATE;
2897: l_adjv_rec.CREATED_BY := Fnd_Global.USER_ID;
2898: l_adjv_rec.LAST_UPDATE_DATE := SYSDATE;
2899: l_adjv_rec.LAST_UPDATED_BY := FND_GLOBAL.USER_ID;
2900: l_adjv_rec.LAST_UPDATE_LOGIN := FND_GLOBAL.LOGIN_ID;
2901: RETURN(l_adjv_rec);
2902: END fill_who_columns;
2903: ----------------------------------

Line 2900: l_adjv_rec.LAST_UPDATE_LOGIN := FND_GLOBAL.LOGIN_ID;

2896: l_adjv_rec.CREATION_DATE := SYSDATE;
2897: l_adjv_rec.CREATED_BY := Fnd_Global.USER_ID;
2898: l_adjv_rec.LAST_UPDATE_DATE := SYSDATE;
2899: l_adjv_rec.LAST_UPDATED_BY := FND_GLOBAL.USER_ID;
2900: l_adjv_rec.LAST_UPDATE_LOGIN := FND_GLOBAL.LOGIN_ID;
2901: RETURN(l_adjv_rec);
2902: END fill_who_columns;
2903: ----------------------------------
2904: -- FUNCTION populate_new_record --

Line 3088: NVL(DECODE(Fnd_Global.CONC_REQUEST_ID,-1,NULL,Fnd_Global.CONC_REQUEST_ID),

3084: x_adjv_rec := p_adjv_rec;
3085: x_adjv_rec.OBJECT_VERSION_NUMBER := NVL(x_adjv_rec.OBJECT_VERSION_NUMBER, 0) + 1;
3086: -- Begin Post-Generation Change
3087: SELECT
3088: NVL(DECODE(Fnd_Global.CONC_REQUEST_ID,-1,NULL,Fnd_Global.CONC_REQUEST_ID),
3089: x_adjv_rec.request_id),
3090: NVL(DECODE(Fnd_Global.PROG_APPL_ID, -1,NULL,Fnd_Global.PROG_APPL_ID),
3091: x_adjv_rec.program_application_id),
3092: NVL(DECODE(Fnd_Global.CONC_PROGRAM_ID,-1,NULL,Fnd_Global.CONC_PROGRAM_ID),

Line 3090: NVL(DECODE(Fnd_Global.PROG_APPL_ID, -1,NULL,Fnd_Global.PROG_APPL_ID),

3086: -- Begin Post-Generation Change
3087: SELECT
3088: NVL(DECODE(Fnd_Global.CONC_REQUEST_ID,-1,NULL,Fnd_Global.CONC_REQUEST_ID),
3089: x_adjv_rec.request_id),
3090: NVL(DECODE(Fnd_Global.PROG_APPL_ID, -1,NULL,Fnd_Global.PROG_APPL_ID),
3091: x_adjv_rec.program_application_id),
3092: NVL(DECODE(Fnd_Global.CONC_PROGRAM_ID,-1,NULL,Fnd_Global.CONC_PROGRAM_ID),
3093: x_adjv_rec.program_id),
3094: DECODE(DECODE(Fnd_Global.CONC_REQUEST_ID,-1,NULL,SYSDATE),

Line 3092: NVL(DECODE(Fnd_Global.CONC_PROGRAM_ID,-1,NULL,Fnd_Global.CONC_PROGRAM_ID),

3088: NVL(DECODE(Fnd_Global.CONC_REQUEST_ID,-1,NULL,Fnd_Global.CONC_REQUEST_ID),
3089: x_adjv_rec.request_id),
3090: NVL(DECODE(Fnd_Global.PROG_APPL_ID, -1,NULL,Fnd_Global.PROG_APPL_ID),
3091: x_adjv_rec.program_application_id),
3092: NVL(DECODE(Fnd_Global.CONC_PROGRAM_ID,-1,NULL,Fnd_Global.CONC_PROGRAM_ID),
3093: x_adjv_rec.program_id),
3094: DECODE(DECODE(Fnd_Global.CONC_REQUEST_ID,-1,NULL,SYSDATE),
3095: NULL,x_adjv_rec.program_update_date,SYSDATE)
3096: INTO

Line 3094: DECODE(DECODE(Fnd_Global.CONC_REQUEST_ID,-1,NULL,SYSDATE),

3090: NVL(DECODE(Fnd_Global.PROG_APPL_ID, -1,NULL,Fnd_Global.PROG_APPL_ID),
3091: x_adjv_rec.program_application_id),
3092: NVL(DECODE(Fnd_Global.CONC_PROGRAM_ID,-1,NULL,Fnd_Global.CONC_PROGRAM_ID),
3093: x_adjv_rec.program_id),
3094: DECODE(DECODE(Fnd_Global.CONC_REQUEST_ID,-1,NULL,SYSDATE),
3095: NULL,x_adjv_rec.program_update_date,SYSDATE)
3096: INTO
3097: x_adjv_rec.request_id,
3098: x_adjv_rec.program_application_id,