DBA Data[Home] [Help]

APPS.OKL_TPL_PVT dependencies on FND_GLOBAL

Line 2740: l_tplv_rec.CREATED_BY := FND_GLOBAL.USER_ID;

2736: ) RETURN tplv_rec_type IS
2737: l_tplv_rec tplv_rec_type := p_tplv_rec;
2738: BEGIN
2739: l_tplv_rec.CREATION_DATE := SYSDATE;
2740: l_tplv_rec.CREATED_BY := FND_GLOBAL.USER_ID;
2741: l_tplv_rec.LAST_UPDATE_DATE := l_tplv_rec.CREATION_DATE; -- PostGen-10
2742: l_tplv_rec.LAST_UPDATED_BY := FND_GLOBAL.USER_ID;
2743: l_tplv_rec.LAST_UPDATE_LOGIN := FND_GLOBAL.LOGIN_ID;
2744: RETURN(l_tplv_rec);

Line 2742: l_tplv_rec.LAST_UPDATED_BY := FND_GLOBAL.USER_ID;

2738: BEGIN
2739: l_tplv_rec.CREATION_DATE := SYSDATE;
2740: l_tplv_rec.CREATED_BY := FND_GLOBAL.USER_ID;
2741: l_tplv_rec.LAST_UPDATE_DATE := l_tplv_rec.CREATION_DATE; -- PostGen-10
2742: l_tplv_rec.LAST_UPDATED_BY := FND_GLOBAL.USER_ID;
2743: l_tplv_rec.LAST_UPDATE_LOGIN := FND_GLOBAL.LOGIN_ID;
2744: RETURN(l_tplv_rec);
2745: END fill_who_columns;
2746: ---------------------------------------------

Line 2743: l_tplv_rec.LAST_UPDATE_LOGIN := FND_GLOBAL.LOGIN_ID;

2739: l_tplv_rec.CREATION_DATE := SYSDATE;
2740: l_tplv_rec.CREATED_BY := FND_GLOBAL.USER_ID;
2741: l_tplv_rec.LAST_UPDATE_DATE := l_tplv_rec.CREATION_DATE; -- PostGen-10
2742: l_tplv_rec.LAST_UPDATED_BY := FND_GLOBAL.USER_ID;
2743: l_tplv_rec.LAST_UPDATE_LOGIN := FND_GLOBAL.LOGIN_ID;
2744: RETURN(l_tplv_rec);
2745: END fill_who_columns;
2746: ---------------------------------------------
2747: -- Set_Attributes for:OKL_TXL_AP_INV_LNS_V --

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

2757: x_tplv_rec.SFWT_FLAG := 'N';
2758:
2759: -- Start PostGen-7
2760: SELECT
2761: DECODE(Fnd_Global.CONC_REQUEST_ID,-1,NULL,Fnd_Global.CONC_REQUEST_ID),
2762: DECODE(Fnd_Global.PROG_APPL_ID, -1,NULL,Fnd_Global.PROG_APPL_ID),
2763: DECODE(Fnd_Global.CONC_PROGRAM_ID,-1,NULL,Fnd_Global.CONC_PROGRAM_ID),
2764: DECODE(Fnd_Global.CONC_REQUEST_ID,-1,NULL,SYSDATE)
2765: INTO

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

2758:
2759: -- Start PostGen-7
2760: SELECT
2761: DECODE(Fnd_Global.CONC_REQUEST_ID,-1,NULL,Fnd_Global.CONC_REQUEST_ID),
2762: DECODE(Fnd_Global.PROG_APPL_ID, -1,NULL,Fnd_Global.PROG_APPL_ID),
2763: DECODE(Fnd_Global.CONC_PROGRAM_ID,-1,NULL,Fnd_Global.CONC_PROGRAM_ID),
2764: DECODE(Fnd_Global.CONC_REQUEST_ID,-1,NULL,SYSDATE)
2765: INTO
2766: x_tplv_rec.request_id,

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

2759: -- Start PostGen-7
2760: SELECT
2761: DECODE(Fnd_Global.CONC_REQUEST_ID,-1,NULL,Fnd_Global.CONC_REQUEST_ID),
2762: DECODE(Fnd_Global.PROG_APPL_ID, -1,NULL,Fnd_Global.PROG_APPL_ID),
2763: DECODE(Fnd_Global.CONC_PROGRAM_ID,-1,NULL,Fnd_Global.CONC_PROGRAM_ID),
2764: DECODE(Fnd_Global.CONC_REQUEST_ID,-1,NULL,SYSDATE)
2765: INTO
2766: x_tplv_rec.request_id,
2767: x_tplv_rec.program_application_id,

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

2760: SELECT
2761: DECODE(Fnd_Global.CONC_REQUEST_ID,-1,NULL,Fnd_Global.CONC_REQUEST_ID),
2762: DECODE(Fnd_Global.PROG_APPL_ID, -1,NULL,Fnd_Global.PROG_APPL_ID),
2763: DECODE(Fnd_Global.CONC_PROGRAM_ID,-1,NULL,Fnd_Global.CONC_PROGRAM_ID),
2764: DECODE(Fnd_Global.CONC_REQUEST_ID,-1,NULL,SYSDATE)
2765: INTO
2766: x_tplv_rec.request_id,
2767: x_tplv_rec.program_application_id,
2768: x_tplv_rec.program_id,

Line 3902: l_tplv_rec.LAST_UPDATED_BY := FND_GLOBAL.USER_ID;

3898: ) RETURN tplv_rec_type IS
3899: l_tplv_rec tplv_rec_type := p_tplv_rec;
3900: BEGIN
3901: l_tplv_rec.LAST_UPDATE_DATE := SYSDATE;
3902: l_tplv_rec.LAST_UPDATED_BY := FND_GLOBAL.USER_ID;
3903: l_tplv_rec.LAST_UPDATE_LOGIN := FND_GLOBAL.LOGIN_ID;
3904: RETURN(l_tplv_rec);
3905: END fill_who_columns;
3906: ----------------------------------

Line 3903: l_tplv_rec.LAST_UPDATE_LOGIN := FND_GLOBAL.LOGIN_ID;

3899: l_tplv_rec tplv_rec_type := p_tplv_rec;
3900: BEGIN
3901: l_tplv_rec.LAST_UPDATE_DATE := SYSDATE;
3902: l_tplv_rec.LAST_UPDATED_BY := FND_GLOBAL.USER_ID;
3903: l_tplv_rec.LAST_UPDATE_LOGIN := FND_GLOBAL.LOGIN_ID;
3904: RETURN(l_tplv_rec);
3905: END fill_who_columns;
3906: ----------------------------------
3907: -- FUNCTION populate_new_record --

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

4151: x_tplv_rec.OBJECT_VERSION_NUMBER := NVL(x_tplv_rec.OBJECT_VERSION_NUMBER, 0) + 1;
4152:
4153: -- Begin PostGen-7
4154: SELECT
4155: NVL(DECODE(Fnd_Global.CONC_REQUEST_ID,-1,NULL,Fnd_Global.CONC_REQUEST_ID),
4156: x_tplv_rec.request_id),
4157: NVL(DECODE(Fnd_Global.PROG_APPL_ID, -1,NULL,Fnd_Global.PROG_APPL_ID),
4158: x_tplv_rec.program_application_id),
4159: NVL(DECODE(Fnd_Global.CONC_PROGRAM_ID,-1,NULL,Fnd_Global.CONC_PROGRAM_ID),

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

4153: -- Begin PostGen-7
4154: SELECT
4155: NVL(DECODE(Fnd_Global.CONC_REQUEST_ID,-1,NULL,Fnd_Global.CONC_REQUEST_ID),
4156: x_tplv_rec.request_id),
4157: NVL(DECODE(Fnd_Global.PROG_APPL_ID, -1,NULL,Fnd_Global.PROG_APPL_ID),
4158: x_tplv_rec.program_application_id),
4159: NVL(DECODE(Fnd_Global.CONC_PROGRAM_ID,-1,NULL,Fnd_Global.CONC_PROGRAM_ID),
4160: x_tplv_rec.program_id),
4161: DECODE(DECODE(Fnd_Global.CONC_REQUEST_ID,-1,NULL,SYSDATE),

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

4155: NVL(DECODE(Fnd_Global.CONC_REQUEST_ID,-1,NULL,Fnd_Global.CONC_REQUEST_ID),
4156: x_tplv_rec.request_id),
4157: NVL(DECODE(Fnd_Global.PROG_APPL_ID, -1,NULL,Fnd_Global.PROG_APPL_ID),
4158: x_tplv_rec.program_application_id),
4159: NVL(DECODE(Fnd_Global.CONC_PROGRAM_ID,-1,NULL,Fnd_Global.CONC_PROGRAM_ID),
4160: x_tplv_rec.program_id),
4161: DECODE(DECODE(Fnd_Global.CONC_REQUEST_ID,-1,NULL,SYSDATE),
4162: NULL,x_tplv_rec.program_update_date,SYSDATE)
4163: INTO

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

4157: NVL(DECODE(Fnd_Global.PROG_APPL_ID, -1,NULL,Fnd_Global.PROG_APPL_ID),
4158: x_tplv_rec.program_application_id),
4159: NVL(DECODE(Fnd_Global.CONC_PROGRAM_ID,-1,NULL,Fnd_Global.CONC_PROGRAM_ID),
4160: x_tplv_rec.program_id),
4161: DECODE(DECODE(Fnd_Global.CONC_REQUEST_ID,-1,NULL,SYSDATE),
4162: NULL,x_tplv_rec.program_update_date,SYSDATE)
4163: INTO
4164: x_tplv_rec.request_id,
4165: x_tplv_rec.program_application_id,