DBA Data[Home] [Help]

APPS.OKL_AM_LEASE_LOAN_TRMNT_PVT dependencies on FND_GLOBAL

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

4122: l_tapv_rec.object_version_number := 1;
4123: --20-NOV-2006 ANSETHUR R12B - LEGAL ENTITY UPTAKE PROJECT
4124: l_tapv_rec.legal_entity_id :=OKL_LEGAL_ENTITY_UTIL.get_khr_le_id(p_term_rec.p_contract_id);
4125:
4126: SELECT DECODE(FND_GLOBAL.CONC_REQUEST_ID,-1,NULL,FND_GLOBAL.CONC_REQUEST_ID),
4127: DECODE(FND_GLOBAL.PROG_APPL_ID,-1,NULL,FND_GLOBAL.PROG_APPL_ID),
4128: DECODE(FND_GLOBAL.CONC_PROGRAM_ID,-1,NULL,FND_GLOBAL.CONC_PROGRAM_ID),
4129: DECODE(FND_GLOBAL.CONC_REQUEST_ID,-1,NULL,SYSDATE),
4130: mo_global.get_current_org_id() INTO l_tapv_rec.REQUEST_ID,

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

4123: --20-NOV-2006 ANSETHUR R12B - LEGAL ENTITY UPTAKE PROJECT
4124: l_tapv_rec.legal_entity_id :=OKL_LEGAL_ENTITY_UTIL.get_khr_le_id(p_term_rec.p_contract_id);
4125:
4126: SELECT DECODE(FND_GLOBAL.CONC_REQUEST_ID,-1,NULL,FND_GLOBAL.CONC_REQUEST_ID),
4127: DECODE(FND_GLOBAL.PROG_APPL_ID,-1,NULL,FND_GLOBAL.PROG_APPL_ID),
4128: DECODE(FND_GLOBAL.CONC_PROGRAM_ID,-1,NULL,FND_GLOBAL.CONC_PROGRAM_ID),
4129: DECODE(FND_GLOBAL.CONC_REQUEST_ID,-1,NULL,SYSDATE),
4130: mo_global.get_current_org_id() INTO l_tapv_rec.REQUEST_ID,
4131: l_tapv_rec.PROGRAM_APPLICATION_ID,

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

4124: l_tapv_rec.legal_entity_id :=OKL_LEGAL_ENTITY_UTIL.get_khr_le_id(p_term_rec.p_contract_id);
4125:
4126: SELECT DECODE(FND_GLOBAL.CONC_REQUEST_ID,-1,NULL,FND_GLOBAL.CONC_REQUEST_ID),
4127: DECODE(FND_GLOBAL.PROG_APPL_ID,-1,NULL,FND_GLOBAL.PROG_APPL_ID),
4128: DECODE(FND_GLOBAL.CONC_PROGRAM_ID,-1,NULL,FND_GLOBAL.CONC_PROGRAM_ID),
4129: DECODE(FND_GLOBAL.CONC_REQUEST_ID,-1,NULL,SYSDATE),
4130: mo_global.get_current_org_id() INTO l_tapv_rec.REQUEST_ID,
4131: l_tapv_rec.PROGRAM_APPLICATION_ID,
4132: l_tapv_rec.PROGRAM_ID,

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

4125:
4126: SELECT DECODE(FND_GLOBAL.CONC_REQUEST_ID,-1,NULL,FND_GLOBAL.CONC_REQUEST_ID),
4127: DECODE(FND_GLOBAL.PROG_APPL_ID,-1,NULL,FND_GLOBAL.PROG_APPL_ID),
4128: DECODE(FND_GLOBAL.CONC_PROGRAM_ID,-1,NULL,FND_GLOBAL.CONC_PROGRAM_ID),
4129: DECODE(FND_GLOBAL.CONC_REQUEST_ID,-1,NULL,SYSDATE),
4130: mo_global.get_current_org_id() INTO l_tapv_rec.REQUEST_ID,
4131: l_tapv_rec.PROGRAM_APPLICATION_ID,
4132: l_tapv_rec.PROGRAM_ID,
4133: l_tapv_rec.PROGRAM_UPDATE_DATE,

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

4639: -- END SMODUGA
4640:
4641: l_tapv_rec.object_version_number := 1;
4642:
4643: SELECT DECODE(FND_GLOBAL.CONC_REQUEST_ID,-1,NULL,FND_GLOBAL.CONC_REQUEST_ID),
4644: DECODE(FND_GLOBAL.PROG_APPL_ID,-1,NULL,FND_GLOBAL.PROG_APPL_ID),
4645: DECODE(FND_GLOBAL.CONC_PROGRAM_ID,-1,NULL,FND_GLOBAL.CONC_PROGRAM_ID),
4646: DECODE(FND_GLOBAL.CONC_REQUEST_ID,-1,NULL,SYSDATE),
4647: mo_global.get_current_org_id() INTO l_tapv_rec.REQUEST_ID,

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

4640:
4641: l_tapv_rec.object_version_number := 1;
4642:
4643: SELECT DECODE(FND_GLOBAL.CONC_REQUEST_ID,-1,NULL,FND_GLOBAL.CONC_REQUEST_ID),
4644: DECODE(FND_GLOBAL.PROG_APPL_ID,-1,NULL,FND_GLOBAL.PROG_APPL_ID),
4645: DECODE(FND_GLOBAL.CONC_PROGRAM_ID,-1,NULL,FND_GLOBAL.CONC_PROGRAM_ID),
4646: DECODE(FND_GLOBAL.CONC_REQUEST_ID,-1,NULL,SYSDATE),
4647: mo_global.get_current_org_id() INTO l_tapv_rec.REQUEST_ID,
4648: l_tapv_rec.PROGRAM_APPLICATION_ID,

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

4641: l_tapv_rec.object_version_number := 1;
4642:
4643: SELECT DECODE(FND_GLOBAL.CONC_REQUEST_ID,-1,NULL,FND_GLOBAL.CONC_REQUEST_ID),
4644: DECODE(FND_GLOBAL.PROG_APPL_ID,-1,NULL,FND_GLOBAL.PROG_APPL_ID),
4645: DECODE(FND_GLOBAL.CONC_PROGRAM_ID,-1,NULL,FND_GLOBAL.CONC_PROGRAM_ID),
4646: DECODE(FND_GLOBAL.CONC_REQUEST_ID,-1,NULL,SYSDATE),
4647: mo_global.get_current_org_id() INTO l_tapv_rec.REQUEST_ID,
4648: l_tapv_rec.PROGRAM_APPLICATION_ID,
4649: l_tapv_rec.PROGRAM_ID,

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

4642:
4643: SELECT DECODE(FND_GLOBAL.CONC_REQUEST_ID,-1,NULL,FND_GLOBAL.CONC_REQUEST_ID),
4644: DECODE(FND_GLOBAL.PROG_APPL_ID,-1,NULL,FND_GLOBAL.PROG_APPL_ID),
4645: DECODE(FND_GLOBAL.CONC_PROGRAM_ID,-1,NULL,FND_GLOBAL.CONC_PROGRAM_ID),
4646: DECODE(FND_GLOBAL.CONC_REQUEST_ID,-1,NULL,SYSDATE),
4647: mo_global.get_current_org_id() INTO l_tapv_rec.REQUEST_ID,
4648: l_tapv_rec.PROGRAM_APPLICATION_ID,
4649: l_tapv_rec.PROGRAM_ID,
4650: l_tapv_rec.PROGRAM_UPDATE_DATE,