DBA Data[Home] [Help]

APPS.OKL_AM_LEASE_LOAN_TRMNT_PVT dependencies on FND_GLOBAL

Line 4148: SELECT DECODE(FND_GLOBAL.CONC_REQUEST_ID,-1,NULL,FND_GLOBAL.CONC_REQUEST_ID),

4144: l_tapv_rec.object_version_number := 1;
4145: --20-NOV-2006 ANSETHUR R12B - LEGAL ENTITY UPTAKE PROJECT
4146: l_tapv_rec.legal_entity_id :=OKL_LEGAL_ENTITY_UTIL.get_khr_le_id(p_term_rec.p_contract_id);
4147:
4148: SELECT DECODE(FND_GLOBAL.CONC_REQUEST_ID,-1,NULL,FND_GLOBAL.CONC_REQUEST_ID),
4149: DECODE(FND_GLOBAL.PROG_APPL_ID,-1,NULL,FND_GLOBAL.PROG_APPL_ID),
4150: DECODE(FND_GLOBAL.CONC_PROGRAM_ID,-1,NULL,FND_GLOBAL.CONC_PROGRAM_ID),
4151: DECODE(FND_GLOBAL.CONC_REQUEST_ID,-1,NULL,SYSDATE),
4152: mo_global.get_current_org_id() INTO l_tapv_rec.REQUEST_ID,

Line 4149: DECODE(FND_GLOBAL.PROG_APPL_ID,-1,NULL,FND_GLOBAL.PROG_APPL_ID),

4145: --20-NOV-2006 ANSETHUR R12B - LEGAL ENTITY UPTAKE PROJECT
4146: l_tapv_rec.legal_entity_id :=OKL_LEGAL_ENTITY_UTIL.get_khr_le_id(p_term_rec.p_contract_id);
4147:
4148: SELECT DECODE(FND_GLOBAL.CONC_REQUEST_ID,-1,NULL,FND_GLOBAL.CONC_REQUEST_ID),
4149: DECODE(FND_GLOBAL.PROG_APPL_ID,-1,NULL,FND_GLOBAL.PROG_APPL_ID),
4150: DECODE(FND_GLOBAL.CONC_PROGRAM_ID,-1,NULL,FND_GLOBAL.CONC_PROGRAM_ID),
4151: DECODE(FND_GLOBAL.CONC_REQUEST_ID,-1,NULL,SYSDATE),
4152: mo_global.get_current_org_id() INTO l_tapv_rec.REQUEST_ID,
4153: l_tapv_rec.PROGRAM_APPLICATION_ID,

Line 4150: DECODE(FND_GLOBAL.CONC_PROGRAM_ID,-1,NULL,FND_GLOBAL.CONC_PROGRAM_ID),

4146: l_tapv_rec.legal_entity_id :=OKL_LEGAL_ENTITY_UTIL.get_khr_le_id(p_term_rec.p_contract_id);
4147:
4148: SELECT DECODE(FND_GLOBAL.CONC_REQUEST_ID,-1,NULL,FND_GLOBAL.CONC_REQUEST_ID),
4149: DECODE(FND_GLOBAL.PROG_APPL_ID,-1,NULL,FND_GLOBAL.PROG_APPL_ID),
4150: DECODE(FND_GLOBAL.CONC_PROGRAM_ID,-1,NULL,FND_GLOBAL.CONC_PROGRAM_ID),
4151: DECODE(FND_GLOBAL.CONC_REQUEST_ID,-1,NULL,SYSDATE),
4152: mo_global.get_current_org_id() INTO l_tapv_rec.REQUEST_ID,
4153: l_tapv_rec.PROGRAM_APPLICATION_ID,
4154: l_tapv_rec.PROGRAM_ID,

Line 4151: DECODE(FND_GLOBAL.CONC_REQUEST_ID,-1,NULL,SYSDATE),

4147:
4148: SELECT DECODE(FND_GLOBAL.CONC_REQUEST_ID,-1,NULL,FND_GLOBAL.CONC_REQUEST_ID),
4149: DECODE(FND_GLOBAL.PROG_APPL_ID,-1,NULL,FND_GLOBAL.PROG_APPL_ID),
4150: DECODE(FND_GLOBAL.CONC_PROGRAM_ID,-1,NULL,FND_GLOBAL.CONC_PROGRAM_ID),
4151: DECODE(FND_GLOBAL.CONC_REQUEST_ID,-1,NULL,SYSDATE),
4152: mo_global.get_current_org_id() INTO l_tapv_rec.REQUEST_ID,
4153: l_tapv_rec.PROGRAM_APPLICATION_ID,
4154: l_tapv_rec.PROGRAM_ID,
4155: l_tapv_rec.PROGRAM_UPDATE_DATE,

Line 4665: SELECT DECODE(FND_GLOBAL.CONC_REQUEST_ID,-1,NULL,FND_GLOBAL.CONC_REQUEST_ID),

4661: -- END SMODUGA
4662:
4663: l_tapv_rec.object_version_number := 1;
4664:
4665: SELECT DECODE(FND_GLOBAL.CONC_REQUEST_ID,-1,NULL,FND_GLOBAL.CONC_REQUEST_ID),
4666: DECODE(FND_GLOBAL.PROG_APPL_ID,-1,NULL,FND_GLOBAL.PROG_APPL_ID),
4667: DECODE(FND_GLOBAL.CONC_PROGRAM_ID,-1,NULL,FND_GLOBAL.CONC_PROGRAM_ID),
4668: DECODE(FND_GLOBAL.CONC_REQUEST_ID,-1,NULL,SYSDATE),
4669: mo_global.get_current_org_id() INTO l_tapv_rec.REQUEST_ID,

Line 4666: DECODE(FND_GLOBAL.PROG_APPL_ID,-1,NULL,FND_GLOBAL.PROG_APPL_ID),

4662:
4663: l_tapv_rec.object_version_number := 1;
4664:
4665: SELECT DECODE(FND_GLOBAL.CONC_REQUEST_ID,-1,NULL,FND_GLOBAL.CONC_REQUEST_ID),
4666: DECODE(FND_GLOBAL.PROG_APPL_ID,-1,NULL,FND_GLOBAL.PROG_APPL_ID),
4667: DECODE(FND_GLOBAL.CONC_PROGRAM_ID,-1,NULL,FND_GLOBAL.CONC_PROGRAM_ID),
4668: DECODE(FND_GLOBAL.CONC_REQUEST_ID,-1,NULL,SYSDATE),
4669: mo_global.get_current_org_id() INTO l_tapv_rec.REQUEST_ID,
4670: l_tapv_rec.PROGRAM_APPLICATION_ID,

Line 4667: DECODE(FND_GLOBAL.CONC_PROGRAM_ID,-1,NULL,FND_GLOBAL.CONC_PROGRAM_ID),

4663: l_tapv_rec.object_version_number := 1;
4664:
4665: SELECT DECODE(FND_GLOBAL.CONC_REQUEST_ID,-1,NULL,FND_GLOBAL.CONC_REQUEST_ID),
4666: DECODE(FND_GLOBAL.PROG_APPL_ID,-1,NULL,FND_GLOBAL.PROG_APPL_ID),
4667: DECODE(FND_GLOBAL.CONC_PROGRAM_ID,-1,NULL,FND_GLOBAL.CONC_PROGRAM_ID),
4668: DECODE(FND_GLOBAL.CONC_REQUEST_ID,-1,NULL,SYSDATE),
4669: mo_global.get_current_org_id() INTO l_tapv_rec.REQUEST_ID,
4670: l_tapv_rec.PROGRAM_APPLICATION_ID,
4671: l_tapv_rec.PROGRAM_ID,

Line 4668: DECODE(FND_GLOBAL.CONC_REQUEST_ID,-1,NULL,SYSDATE),

4664:
4665: SELECT DECODE(FND_GLOBAL.CONC_REQUEST_ID,-1,NULL,FND_GLOBAL.CONC_REQUEST_ID),
4666: DECODE(FND_GLOBAL.PROG_APPL_ID,-1,NULL,FND_GLOBAL.PROG_APPL_ID),
4667: DECODE(FND_GLOBAL.CONC_PROGRAM_ID,-1,NULL,FND_GLOBAL.CONC_PROGRAM_ID),
4668: DECODE(FND_GLOBAL.CONC_REQUEST_ID,-1,NULL,SYSDATE),
4669: mo_global.get_current_org_id() INTO l_tapv_rec.REQUEST_ID,
4670: l_tapv_rec.PROGRAM_APPLICATION_ID,
4671: l_tapv_rec.PROGRAM_ID,
4672: l_tapv_rec.PROGRAM_UPDATE_DATE,