2131: l_request_id NUMBER;
2132:
2133: CURSOR req_id_csr IS
2134: SELECT
2135: DECODE(Fnd_Global.CONC_REQUEST_ID,-1,NULL,Fnd_Global.CONC_REQUEST_ID)
2136: FROM dual;
2137:
2138: ------------------------------------------------------------
2139: -- Operating Unit
2196:
2197: -- ----------------------
2198: -- Std Who columns
2199: -- ----------------------
2200: lx_last_updated_by okl_trx_ar_invoices_b.last_updated_by%TYPE := Fnd_Global.USER_ID;
2201: lx_last_update_login okl_trx_ar_invoices_b.last_update_login%TYPE := Fnd_Global.LOGIN_ID;
2202: lx_request_id okl_trx_ar_invoices_b.request_id%TYPE := Fnd_Global.CONC_REQUEST_ID;
2203:
2204: lx_program_application_id
2197: -- ----------------------
2198: -- Std Who columns
2199: -- ----------------------
2200: lx_last_updated_by okl_trx_ar_invoices_b.last_updated_by%TYPE := Fnd_Global.USER_ID;
2201: lx_last_update_login okl_trx_ar_invoices_b.last_update_login%TYPE := Fnd_Global.LOGIN_ID;
2202: lx_request_id okl_trx_ar_invoices_b.request_id%TYPE := Fnd_Global.CONC_REQUEST_ID;
2203:
2204: lx_program_application_id
2205: okl_trx_ar_invoices_b.program_application_id%TYPE := Fnd_Global.PROG_APPL_ID;
2198: -- Std Who columns
2199: -- ----------------------
2200: lx_last_updated_by okl_trx_ar_invoices_b.last_updated_by%TYPE := Fnd_Global.USER_ID;
2201: lx_last_update_login okl_trx_ar_invoices_b.last_update_login%TYPE := Fnd_Global.LOGIN_ID;
2202: lx_request_id okl_trx_ar_invoices_b.request_id%TYPE := Fnd_Global.CONC_REQUEST_ID;
2203:
2204: lx_program_application_id
2205: okl_trx_ar_invoices_b.program_application_id%TYPE := Fnd_Global.PROG_APPL_ID;
2206: lx_program_id okl_trx_ar_invoices_b.program_id%TYPE := Fnd_Global.CONC_PROGRAM_ID;
2201: lx_last_update_login okl_trx_ar_invoices_b.last_update_login%TYPE := Fnd_Global.LOGIN_ID;
2202: lx_request_id okl_trx_ar_invoices_b.request_id%TYPE := Fnd_Global.CONC_REQUEST_ID;
2203:
2204: lx_program_application_id
2205: okl_trx_ar_invoices_b.program_application_id%TYPE := Fnd_Global.PROG_APPL_ID;
2206: lx_program_id okl_trx_ar_invoices_b.program_id%TYPE := Fnd_Global.CONC_PROGRAM_ID;
2207:
2208: -- ---------------------------
2209: -- Bulk Insert changes
2202: lx_request_id okl_trx_ar_invoices_b.request_id%TYPE := Fnd_Global.CONC_REQUEST_ID;
2203:
2204: lx_program_application_id
2205: okl_trx_ar_invoices_b.program_application_id%TYPE := Fnd_Global.PROG_APPL_ID;
2206: lx_program_id okl_trx_ar_invoices_b.program_id%TYPE := Fnd_Global.CONC_PROGRAM_ID;
2207:
2208: -- ---------------------------
2209: -- Bulk Insert changes
2210: -- ---------------------------