eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.OKL_INS_QUOTE_PVT dependencies on FND_GLOBAL

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

3431: l_inav_rec.ATTRIBUTE13 := l_okl_inav_pk_csr.ATTRIBUTE13 ;
3432: l_inav_rec.ATTRIBUTE14 := l_okl_inav_pk_csr.ATTRIBUTE14 ;
3433: l_inav_rec.ATTRIBUTE15 := l_okl_inav_pk_csr.ATTRIBUTE15 ;
3434:
3435: SELECT DECODE(FND_GLOBAL.CONC_REQUEST_ID,-1,NULL,FND_GLOBAL.CONC_REQUEST_ID),
3436: DECODE(FND_GLOBAL.PROG_APPL_ID,-1,NULL,FND_GLOBAL.PROG_APPL_ID),
3437: DECODE(FND_GLOBAL.CONC_PROGRAM_ID,-1,NULL,FND_GLOBAL.CONC_PROGRAM_ID),
3438: DECODE(FND_GLOBAL.CONC_REQUEST_ID,-1,NULL,SYSDATE),
3439: MO_GLOBAL.GET_CURRENT_ORG_ID()

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

3432: l_inav_rec.ATTRIBUTE14 := l_okl_inav_pk_csr.ATTRIBUTE14 ;
3433: l_inav_rec.ATTRIBUTE15 := l_okl_inav_pk_csr.ATTRIBUTE15 ;
3434:
3435: SELECT DECODE(FND_GLOBAL.CONC_REQUEST_ID,-1,NULL,FND_GLOBAL.CONC_REQUEST_ID),
3436: DECODE(FND_GLOBAL.PROG_APPL_ID,-1,NULL,FND_GLOBAL.PROG_APPL_ID),
3437: DECODE(FND_GLOBAL.CONC_PROGRAM_ID,-1,NULL,FND_GLOBAL.CONC_PROGRAM_ID),
3438: DECODE(FND_GLOBAL.CONC_REQUEST_ID,-1,NULL,SYSDATE),
3439: MO_GLOBAL.GET_CURRENT_ORG_ID()
3440: INTO l_inav_rec.REQUEST_ID,

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

3433: l_inav_rec.ATTRIBUTE15 := l_okl_inav_pk_csr.ATTRIBUTE15 ;
3434:
3435: SELECT DECODE(FND_GLOBAL.CONC_REQUEST_ID,-1,NULL,FND_GLOBAL.CONC_REQUEST_ID),
3436: DECODE(FND_GLOBAL.PROG_APPL_ID,-1,NULL,FND_GLOBAL.PROG_APPL_ID),
3437: DECODE(FND_GLOBAL.CONC_PROGRAM_ID,-1,NULL,FND_GLOBAL.CONC_PROGRAM_ID),
3438: DECODE(FND_GLOBAL.CONC_REQUEST_ID,-1,NULL,SYSDATE),
3439: MO_GLOBAL.GET_CURRENT_ORG_ID()
3440: INTO l_inav_rec.REQUEST_ID,
3441: l_inav_rec.PROGRAM_APPLICATION_ID,

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

3434:
3435: SELECT DECODE(FND_GLOBAL.CONC_REQUEST_ID,-1,NULL,FND_GLOBAL.CONC_REQUEST_ID),
3436: DECODE(FND_GLOBAL.PROG_APPL_ID,-1,NULL,FND_GLOBAL.PROG_APPL_ID),
3437: DECODE(FND_GLOBAL.CONC_PROGRAM_ID,-1,NULL,FND_GLOBAL.CONC_PROGRAM_ID),
3438: DECODE(FND_GLOBAL.CONC_REQUEST_ID,-1,NULL,SYSDATE),
3439: MO_GLOBAL.GET_CURRENT_ORG_ID()
3440: INTO l_inav_rec.REQUEST_ID,
3441: l_inav_rec.PROGRAM_APPLICATION_ID,
3442: l_inav_rec.PROGRAM_ID,

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

3522: l_ipyv_rec.ISS_CODE := 'ACCEPTED';
3523: l_ipyv_rec.QUOTE_YN := 'N' ;
3524: l_ipyv_rec.DATE_QUOTED := OKC_API.G_MISS_DATE ;
3525: l_ipyv_rec.DATE_QUOTE_EXPIRY := OKC_API.G_MISS_DATE ;
3526: SELECT DECODE(FND_GLOBAL.CONC_REQUEST_ID,-1,NULL,FND_GLOBAL.CONC_REQUEST_ID),
3527: DECODE(FND_GLOBAL.PROG_APPL_ID,-1,NULL,FND_GLOBAL.PROG_APPL_ID),
3528: DECODE(FND_GLOBAL.CONC_PROGRAM_ID,-1,NULL,FND_GLOBAL.CONC_PROGRAM_ID),
3529: DECODE(FND_GLOBAL.CONC_REQUEST_ID,-1,NULL,SYSDATE),
3530: MO_GLOBAL.GET_CURRENT_ORG_ID()

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

3523: l_ipyv_rec.QUOTE_YN := 'N' ;
3524: l_ipyv_rec.DATE_QUOTED := OKC_API.G_MISS_DATE ;
3525: l_ipyv_rec.DATE_QUOTE_EXPIRY := OKC_API.G_MISS_DATE ;
3526: SELECT DECODE(FND_GLOBAL.CONC_REQUEST_ID,-1,NULL,FND_GLOBAL.CONC_REQUEST_ID),
3527: DECODE(FND_GLOBAL.PROG_APPL_ID,-1,NULL,FND_GLOBAL.PROG_APPL_ID),
3528: DECODE(FND_GLOBAL.CONC_PROGRAM_ID,-1,NULL,FND_GLOBAL.CONC_PROGRAM_ID),
3529: DECODE(FND_GLOBAL.CONC_REQUEST_ID,-1,NULL,SYSDATE),
3530: MO_GLOBAL.GET_CURRENT_ORG_ID()
3531: INTO l_ipyv_rec.REQUEST_ID,

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

3524: l_ipyv_rec.DATE_QUOTED := OKC_API.G_MISS_DATE ;
3525: l_ipyv_rec.DATE_QUOTE_EXPIRY := OKC_API.G_MISS_DATE ;
3526: SELECT DECODE(FND_GLOBAL.CONC_REQUEST_ID,-1,NULL,FND_GLOBAL.CONC_REQUEST_ID),
3527: DECODE(FND_GLOBAL.PROG_APPL_ID,-1,NULL,FND_GLOBAL.PROG_APPL_ID),
3528: DECODE(FND_GLOBAL.CONC_PROGRAM_ID,-1,NULL,FND_GLOBAL.CONC_PROGRAM_ID),
3529: DECODE(FND_GLOBAL.CONC_REQUEST_ID,-1,NULL,SYSDATE),
3530: MO_GLOBAL.GET_CURRENT_ORG_ID()
3531: INTO l_ipyv_rec.REQUEST_ID,
3532: l_ipyv_rec.PROGRAM_APPLICATION_ID,

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

3525: l_ipyv_rec.DATE_QUOTE_EXPIRY := OKC_API.G_MISS_DATE ;
3526: SELECT DECODE(FND_GLOBAL.CONC_REQUEST_ID,-1,NULL,FND_GLOBAL.CONC_REQUEST_ID),
3527: DECODE(FND_GLOBAL.PROG_APPL_ID,-1,NULL,FND_GLOBAL.PROG_APPL_ID),
3528: DECODE(FND_GLOBAL.CONC_PROGRAM_ID,-1,NULL,FND_GLOBAL.CONC_PROGRAM_ID),
3529: DECODE(FND_GLOBAL.CONC_REQUEST_ID,-1,NULL,SYSDATE),
3530: MO_GLOBAL.GET_CURRENT_ORG_ID()
3531: INTO l_ipyv_rec.REQUEST_ID,
3532: l_ipyv_rec.PROGRAM_APPLICATION_ID,
3533: l_ipyv_rec.PROGRAM_ID,

Line 6108: Fnd_File.PUT_LINE(Fnd_File.OUTPUT,'--Request: '|| FND_GLOBAL.CONC_REQUEST_ID|| ' ---------Date: '||TO_CHAR(SYSDATE)||' ---');

6104: -- Bug 3742614 Formatted Output
6105: Fnd_File.PUT_LINE(Fnd_File.OUTPUT,'-------------------------------------------------------------');
6106: Fnd_File.PUT_LINE(Fnd_File.OUTPUT,'--- Automatic Insurance Activation Start ---');
6107: Fnd_File.PUT_LINE(Fnd_File.OUTPUT,'-------------------------------------------------------------');
6108: Fnd_File.PUT_LINE(Fnd_File.OUTPUT,'--Request: '|| FND_GLOBAL.CONC_REQUEST_ID|| ' ---------Date: '||TO_CHAR(SYSDATE)||' ---');
6109: Fnd_File.PUT_LINE(Fnd_File.OUTPUT,'-------------------------------------------------------------');
6110:
6111: -- Get values from system profile
6112: l_afterlease_criteria := fnd_profile.value('OKLINDAYSFORACTIVATION');