DBA Data[Home] [Help]

APPS.OKL_CURE_CALC_PVT dependencies on FND_GLOBAL

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

853: x_cures_in_possession =>l_cures_in_possession,
854: x_outstanding_amount =>l_outstanding_amount,
855: x_delinquent_amount =>l_delinquent_amount);
856:
857: SELECT DECODE(Fnd_Global.CONC_REQUEST_ID, -1, NULL, Fnd_Global.CONC_REQUEST_ID),
858: DECODE(Fnd_Global.PROG_APPL_ID, -1, NULL, Fnd_Global.PROG_APPL_ID),
859: DECODE(Fnd_Global.CONC_PROGRAM_ID, -1, NULL, Fnd_Global.CONC_PROGRAM_ID),
860: DECODE(Fnd_Global.CONC_REQUEST_ID, -1, NULL, SYSDATE)
861: INTO l_camv_rec.request_id,

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

854: x_outstanding_amount =>l_outstanding_amount,
855: x_delinquent_amount =>l_delinquent_amount);
856:
857: SELECT DECODE(Fnd_Global.CONC_REQUEST_ID, -1, NULL, Fnd_Global.CONC_REQUEST_ID),
858: DECODE(Fnd_Global.PROG_APPL_ID, -1, NULL, Fnd_Global.PROG_APPL_ID),
859: DECODE(Fnd_Global.CONC_PROGRAM_ID, -1, NULL, Fnd_Global.CONC_PROGRAM_ID),
860: DECODE(Fnd_Global.CONC_REQUEST_ID, -1, NULL, SYSDATE)
861: INTO l_camv_rec.request_id,
862: l_camv_rec.program_application_id,

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

855: x_delinquent_amount =>l_delinquent_amount);
856:
857: SELECT DECODE(Fnd_Global.CONC_REQUEST_ID, -1, NULL, Fnd_Global.CONC_REQUEST_ID),
858: DECODE(Fnd_Global.PROG_APPL_ID, -1, NULL, Fnd_Global.PROG_APPL_ID),
859: DECODE(Fnd_Global.CONC_PROGRAM_ID, -1, NULL, Fnd_Global.CONC_PROGRAM_ID),
860: DECODE(Fnd_Global.CONC_REQUEST_ID, -1, NULL, SYSDATE)
861: INTO l_camv_rec.request_id,
862: l_camv_rec.program_application_id,
863: l_camv_rec.program_id,

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

856:
857: SELECT DECODE(Fnd_Global.CONC_REQUEST_ID, -1, NULL, Fnd_Global.CONC_REQUEST_ID),
858: DECODE(Fnd_Global.PROG_APPL_ID, -1, NULL, Fnd_Global.PROG_APPL_ID),
859: DECODE(Fnd_Global.CONC_PROGRAM_ID, -1, NULL, Fnd_Global.CONC_PROGRAM_ID),
860: DECODE(Fnd_Global.CONC_REQUEST_ID, -1, NULL, SYSDATE)
861: INTO l_camv_rec.request_id,
862: l_camv_rec.program_application_id,
863: l_camv_rec.program_id,
864: l_camv_rec.program_update_date