DBA Data[Home] [Help]

APPS.OKL_VENDOR_REFUND_PVT dependencies on FND_GLOBAL

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

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,

Line 67: DECODE(Fnd_Global.PROG_APPL_ID, -1, NULL, Fnd_Global.PROG_APPL_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,

Line 68: DECODE(Fnd_Global.CONC_PROGRAM_ID, -1, NULL, Fnd_Global.CONC_PROGRAM_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,

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

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

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

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,

Line 242: DECODE(Fnd_Global.PROG_APPL_ID, -1, NULL, Fnd_Global.PROG_APPL_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,

Line 243: DECODE(Fnd_Global.CONC_PROGRAM_ID, -1, NULL, Fnd_Global.CONC_PROGRAM_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,

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

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