62: l_camv_tbl(next_row).STATUS :='MOVED_TO_REFUNDS';
63:
64: okl_debug_pub.logmessage('OKL_VENDOR_REFUND_PVT : Update_cure_amounts : l_camv_tbl(next_row).cure_amount_id : '||l_camv_tbl(next_row).cure_amount_id);
65:
66: SELECT DECODE(Fnd_Global.CONC_REQUEST_ID, -1, NULL, Fnd_Global.CONC_REQUEST_ID),
67: DECODE(Fnd_Global.PROG_APPL_ID, -1, NULL, Fnd_Global.PROG_APPL_ID),
68: DECODE(Fnd_Global.CONC_PROGRAM_ID, -1, NULL, Fnd_Global.CONC_PROGRAM_ID),
69: DECODE(Fnd_Global.CONC_REQUEST_ID, -1, NULL, SYSDATE)
70: INTO l_camv_tbl(next_row).request_id,
63:
64: okl_debug_pub.logmessage('OKL_VENDOR_REFUND_PVT : Update_cure_amounts : l_camv_tbl(next_row).cure_amount_id : '||l_camv_tbl(next_row).cure_amount_id);
65:
66: SELECT DECODE(Fnd_Global.CONC_REQUEST_ID, -1, NULL, Fnd_Global.CONC_REQUEST_ID),
67: DECODE(Fnd_Global.PROG_APPL_ID, -1, NULL, Fnd_Global.PROG_APPL_ID),
68: DECODE(Fnd_Global.CONC_PROGRAM_ID, -1, NULL, Fnd_Global.CONC_PROGRAM_ID),
69: DECODE(Fnd_Global.CONC_REQUEST_ID, -1, NULL, SYSDATE)
70: INTO l_camv_tbl(next_row).request_id,
71: l_camv_tbl(next_row).program_application_id,
64: okl_debug_pub.logmessage('OKL_VENDOR_REFUND_PVT : Update_cure_amounts : l_camv_tbl(next_row).cure_amount_id : '||l_camv_tbl(next_row).cure_amount_id);
65:
66: SELECT DECODE(Fnd_Global.CONC_REQUEST_ID, -1, NULL, Fnd_Global.CONC_REQUEST_ID),
67: DECODE(Fnd_Global.PROG_APPL_ID, -1, NULL, Fnd_Global.PROG_APPL_ID),
68: DECODE(Fnd_Global.CONC_PROGRAM_ID, -1, NULL, Fnd_Global.CONC_PROGRAM_ID),
69: DECODE(Fnd_Global.CONC_REQUEST_ID, -1, NULL, SYSDATE)
70: INTO l_camv_tbl(next_row).request_id,
71: l_camv_tbl(next_row).program_application_id,
72: l_camv_tbl(next_row).program_id,
65:
66: SELECT DECODE(Fnd_Global.CONC_REQUEST_ID, -1, NULL, Fnd_Global.CONC_REQUEST_ID),
67: DECODE(Fnd_Global.PROG_APPL_ID, -1, NULL, Fnd_Global.PROG_APPL_ID),
68: DECODE(Fnd_Global.CONC_PROGRAM_ID, -1, NULL, Fnd_Global.CONC_PROGRAM_ID),
69: DECODE(Fnd_Global.CONC_REQUEST_ID, -1, NULL, SYSDATE)
70: INTO l_camv_tbl(next_row).request_id,
71: l_camv_tbl(next_row).program_application_id,
72: l_camv_tbl(next_row).program_id,
73: l_camv_tbl(next_row).program_update_date
237: l_crsv_rec.received_amount := l_received_amount;
238: l_crsv_rec.vendor_id := p_vendor_id;
239: l_crsv_rec.object_version_number := 1.0;
240:
241: SELECT DECODE(Fnd_Global.CONC_REQUEST_ID, -1, NULL, Fnd_Global.CONC_REQUEST_ID),
242: DECODE(Fnd_Global.PROG_APPL_ID, -1, NULL, Fnd_Global.PROG_APPL_ID),
243: DECODE(Fnd_Global.CONC_PROGRAM_ID, -1, NULL, Fnd_Global.CONC_PROGRAM_ID),
244: DECODE(Fnd_Global.CONC_REQUEST_ID, -1, NULL, SYSDATE)
245: INTO l_crsv_rec.request_id,
238: l_crsv_rec.vendor_id := p_vendor_id;
239: l_crsv_rec.object_version_number := 1.0;
240:
241: SELECT DECODE(Fnd_Global.CONC_REQUEST_ID, -1, NULL, Fnd_Global.CONC_REQUEST_ID),
242: DECODE(Fnd_Global.PROG_APPL_ID, -1, NULL, Fnd_Global.PROG_APPL_ID),
243: DECODE(Fnd_Global.CONC_PROGRAM_ID, -1, NULL, Fnd_Global.CONC_PROGRAM_ID),
244: DECODE(Fnd_Global.CONC_REQUEST_ID, -1, NULL, SYSDATE)
245: INTO l_crsv_rec.request_id,
246: l_crsv_rec.program_application_id,
239: l_crsv_rec.object_version_number := 1.0;
240:
241: SELECT DECODE(Fnd_Global.CONC_REQUEST_ID, -1, NULL, Fnd_Global.CONC_REQUEST_ID),
242: DECODE(Fnd_Global.PROG_APPL_ID, -1, NULL, Fnd_Global.PROG_APPL_ID),
243: DECODE(Fnd_Global.CONC_PROGRAM_ID, -1, NULL, Fnd_Global.CONC_PROGRAM_ID),
244: DECODE(Fnd_Global.CONC_REQUEST_ID, -1, NULL, SYSDATE)
245: INTO l_crsv_rec.request_id,
246: l_crsv_rec.program_application_id,
247: l_crsv_rec.program_id,
240:
241: SELECT DECODE(Fnd_Global.CONC_REQUEST_ID, -1, NULL, Fnd_Global.CONC_REQUEST_ID),
242: DECODE(Fnd_Global.PROG_APPL_ID, -1, NULL, Fnd_Global.PROG_APPL_ID),
243: DECODE(Fnd_Global.CONC_PROGRAM_ID, -1, NULL, Fnd_Global.CONC_PROGRAM_ID),
244: DECODE(Fnd_Global.CONC_REQUEST_ID, -1, NULL, SYSDATE)
245: INTO l_crsv_rec.request_id,
246: l_crsv_rec.program_application_id,
247: l_crsv_rec.program_id,
248: l_crsv_rec.program_update_date