DBA Data[Home] [Help]

APPS.JAI_MTL_TRXS_PKG dependencies on JAI_RGM_TRX_RECORDS

Line 968: jai_rgm_trx_records jrtr

964: --start
965: CURSOR c_chk_rgm_trxs(cp_transaction_header_id in number,cp_transaction_temp_id in number,cp_tax_id in number) IS
966: SELECT 1
967: FROM
968: jai_rgm_trx_records jrtr
969: WHERE
970: jrtr.attribute1 = cp_transaction_header_id AND
971: jrtr.source_document_id = cp_transaction_temp_id AND
972: jrtr.reference_id = cp_tax_id AND

Line 5134: FROM jai_rgm_trx_records

5130: DEBIT_AMOUNT,
5131: CREDIT_AMOUNT,
5132: ORGANIZATION_ID,
5133: LOCATION_ID
5134: FROM jai_rgm_trx_records
5135: WHERE repository_id = p_repository_id;
5136:
5137: CURSOR cur_regimes(cp_regime_code VARCHAR2)
5138: IS

Line 5153: ln_repository_id jai_rgm_trx_records.repository_id%TYPE;

5149: lv_currency_code VARCHAR2(10);
5150: ln_entered_dr NUMBER;
5151: ln_entered_cr NUMBER;
5152: ld_accounting_date DATE;
5153: ln_repository_id jai_rgm_trx_records.repository_id%TYPE;
5154: lv_destination VARCHAR2(10);
5155: lv_code_path JAI_RCV_TRANSACTIONS.codepath%TYPE;
5156: lv_process_status VARCHAR2(2);
5157: lv_process_message VARCHAR2(1000);

Line 5176: lv_reference_24 := 'jai_rgm_trx_records';

5172: lv_source_name := 'Purchasing';
5173: lv_category_name := 'Receiving India';
5174: lv_reference_10 := 'VAT claim accounting';
5175: lv_reference_23 := 'jai_mtl_trxs_pkg.process_vat_claim_acctg';
5176: lv_reference_24 := 'jai_rgm_trx_records';
5177: lv_reference_26 := 'repository_id';
5178: lv_currency_code := jai_constants.func_curr;
5179: ld_accounting_date := TRUNC(SYSDATE);
5180: lv_destination := 'G';