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,
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,
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,
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