eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.OKL_ARINTF_PVT dependencies on OKL_TRX_AR_INVOICES_B

Line 1201: FROM OKL_TRX_AR_INVOICES_B TAI,

1197: SELECT count(1)
1198: FROM OKL_TXD_AR_LN_DTLS_B TLD
1199: WHERE EXISTS
1200: (SELECT 1
1201: FROM OKL_TRX_AR_INVOICES_B TAI,
1202: OKL_TXL_AR_INV_LNS_B TIL
1203: WHERE TLD.TIL_ID_DETAILS = TIL.ID
1204: AND TIL.TAI_ID = TAI.ID
1205: AND TAI.trx_status_code = p_sts

Line 1220: processed_sts okl_trx_ar_invoices_b.trx_status_code%TYPE;

1216:
1217: -- ------------------------------------------------
1218: -- Bind variables to address issues in bug 3761940
1219: -- ------------------------------------------------
1220: processed_sts okl_trx_ar_invoices_b.trx_status_code%TYPE;
1221: error_sts okl_trx_ar_invoices_b.trx_status_code%TYPE;
1222:
1223: -- -------------------------
1224: -- Bulk Fetch Size

Line 1221: error_sts okl_trx_ar_invoices_b.trx_status_code%TYPE;

1217: -- ------------------------------------------------
1218: -- Bind variables to address issues in bug 3761940
1219: -- ------------------------------------------------
1220: processed_sts okl_trx_ar_invoices_b.trx_status_code%TYPE;
1221: error_sts okl_trx_ar_invoices_b.trx_status_code%TYPE;
1222:
1223: -- -------------------------
1224: -- Bulk Fetch Size
1225: -- -------------------------

Line 1234: lx_last_updated_by okl_trx_ar_invoices_b.last_updated_by%TYPE := Fnd_Global.USER_ID;

1230:
1231: -- ----------------------
1232: -- Std Who columns
1233: -- ----------------------
1234: lx_last_updated_by okl_trx_ar_invoices_b.last_updated_by%TYPE := Fnd_Global.USER_ID;
1235: lx_last_update_login okl_trx_ar_invoices_b.last_update_login%TYPE := Fnd_Global.LOGIN_ID;
1236: lx_request_id okl_trx_ar_invoices_b.request_id%TYPE := Fnd_Global.CONC_REQUEST_ID;
1237:
1238: lx_program_application_id

Line 1235: lx_last_update_login okl_trx_ar_invoices_b.last_update_login%TYPE := Fnd_Global.LOGIN_ID;

1231: -- ----------------------
1232: -- Std Who columns
1233: -- ----------------------
1234: lx_last_updated_by okl_trx_ar_invoices_b.last_updated_by%TYPE := Fnd_Global.USER_ID;
1235: lx_last_update_login okl_trx_ar_invoices_b.last_update_login%TYPE := Fnd_Global.LOGIN_ID;
1236: lx_request_id okl_trx_ar_invoices_b.request_id%TYPE := Fnd_Global.CONC_REQUEST_ID;
1237:
1238: lx_program_application_id
1239: okl_trx_ar_invoices_b.program_application_id%TYPE := Fnd_Global.PROG_APPL_ID;

Line 1236: lx_request_id okl_trx_ar_invoices_b.request_id%TYPE := Fnd_Global.CONC_REQUEST_ID;

1232: -- Std Who columns
1233: -- ----------------------
1234: lx_last_updated_by okl_trx_ar_invoices_b.last_updated_by%TYPE := Fnd_Global.USER_ID;
1235: lx_last_update_login okl_trx_ar_invoices_b.last_update_login%TYPE := Fnd_Global.LOGIN_ID;
1236: lx_request_id okl_trx_ar_invoices_b.request_id%TYPE := Fnd_Global.CONC_REQUEST_ID;
1237:
1238: lx_program_application_id
1239: okl_trx_ar_invoices_b.program_application_id%TYPE := Fnd_Global.PROG_APPL_ID;
1240: lx_program_id okl_trx_ar_invoices_b.program_id%TYPE := Fnd_Global.CONC_PROGRAM_ID;

Line 1239: okl_trx_ar_invoices_b.program_application_id%TYPE := Fnd_Global.PROG_APPL_ID;

1235: lx_last_update_login okl_trx_ar_invoices_b.last_update_login%TYPE := Fnd_Global.LOGIN_ID;
1236: lx_request_id okl_trx_ar_invoices_b.request_id%TYPE := Fnd_Global.CONC_REQUEST_ID;
1237:
1238: lx_program_application_id
1239: okl_trx_ar_invoices_b.program_application_id%TYPE := Fnd_Global.PROG_APPL_ID;
1240: lx_program_id okl_trx_ar_invoices_b.program_id%TYPE := Fnd_Global.CONC_PROGRAM_ID;
1241:
1242: -- ---------------------------
1243: -- Bulk Insert changes

Line 1240: lx_program_id okl_trx_ar_invoices_b.program_id%TYPE := Fnd_Global.CONC_PROGRAM_ID;

1236: lx_request_id okl_trx_ar_invoices_b.request_id%TYPE := Fnd_Global.CONC_REQUEST_ID;
1237:
1238: lx_program_application_id
1239: okl_trx_ar_invoices_b.program_application_id%TYPE := Fnd_Global.PROG_APPL_ID;
1240: lx_program_id okl_trx_ar_invoices_b.program_id%TYPE := Fnd_Global.CONC_PROGRAM_ID;
1241:
1242: -- ---------------------------
1243: -- Bulk Insert changes
1244: -- ---------------------------

Line 1403: l_error_tai_id okl_trx_ar_invoices_b.id%TYPE;

1399: error_tbl error_tbl_type;
1400:
1401: --start: | 15-FEB-07 cklee R12 Billing enhancement project
1402: --l_error_xsi_id okl_ext_sell_invs_v.id%TYPE;
1403: l_error_tai_id okl_trx_ar_invoices_b.id%TYPE;
1404: l_error_txd_id OKL_TXD_AR_LN_DTLS_B.id%TYPE;
1405: --end: | 15-FEB-07 cklee R12 Billing enhancement project
1406:
1407: hdr_cnt NUMBER;

Line 1885: UPDATE okl_trx_ar_invoices_b

1881: -- ----------------------------------
1882: IF l_hdr_id <> -9999 THEN
1883: --start: | 15-FEB-07 cklee R12 Billing enhancement project
1884: -- UPDATE OKL_EXT_SELL_INVS_B
1885: UPDATE okl_trx_ar_invoices_b
1886: --end: | 15-FEB-07 cklee R12 Billing enhancement project
1887: SET trx_status_code = 'PROCESSED',
1888: last_update_date = sysdate,
1889: last_updated_by = lx_last_updated_by,

Line 2962: UPDATE okl_trx_ar_invoices_b

2958: -- ----------------------------------
2959: --start: | 15-FEB-07 cklee R12 Billing enhancement project
2960: -- UPDATE OKL_EXT_SELL_INVS_B
2961: -- Update internal billing table instead
2962: UPDATE okl_trx_ar_invoices_b
2963: --end: | 15-FEB-07 cklee R12 Billing enhancement project
2964: SET trx_status_code = 'PROCESSED',
2965: last_update_date = sysdate,
2966: last_updated_by = lx_last_updated_by,

Line 3199: update okl_trx_ar_invoices_b tai

3195: fnd_log.STRING(fnd_log.level_statement,'okl.plsql.okl_arintf_pvt.get_rec_feeder.debug','** Exception ** error_txd_id: '||error_tbl(indx).id);
3196: END IF;
3197: End;
3198: -- update okl_ext_sell_invs_b
3199: update okl_trx_ar_invoices_b tai
3200: set tai.trx_status_code = 'WORKING'
3201: -- where id = l_error_xsi_id;
3202: where id = l_error_tai_id;
3203: --end: | 15-FEB-07 cklee R12 Billing enhancement project