[Home] [Help]
841: --start
842: CURSOR c_chk_rgm_trxs(cp_transaction_header_id in number,cp_transaction_temp_id in number,cp_tax_id in number) IS
843: SELECT 1
844: FROM
845: jai_rgm_trx_records jrtr
846: WHERE
847: jrtr.attribute1 = cp_transaction_header_id AND
848: jrtr.source_document_id = cp_transaction_temp_id AND
849: jrtr.reference_id = cp_tax_id AND
4687: DEBIT_AMOUNT,
4688: CREDIT_AMOUNT,
4689: ORGANIZATION_ID,
4690: LOCATION_ID
4691: FROM jai_rgm_trx_records
4692: WHERE repository_id = p_repository_id;
4693:
4694: CURSOR cur_regimes(cp_regime_code VARCHAR2)
4695: IS
4706: lv_currency_code VARCHAR2(10);
4707: ln_entered_dr NUMBER;
4708: ln_entered_cr NUMBER;
4709: ld_accounting_date DATE;
4710: ln_repository_id jai_rgm_trx_records.repository_id%TYPE;
4711: lv_destination VARCHAR2(10);
4712: lv_code_path JAI_RCV_TRANSACTIONS.codepath%TYPE;
4713: lv_process_status VARCHAR2(2);
4714: lv_process_message VARCHAR2(1000);
4729: lv_source_name := 'Purchasing';
4730: lv_category_name := 'Receiving India';
4731: lv_reference_10 := 'VAT claim accounting';
4732: lv_reference_23 := 'jai_mtl_trxs_pkg.process_vat_claim_acctg';
4733: lv_reference_24 := 'jai_rgm_trx_records';
4734: lv_reference_26 := 'repository_id';
4735: lv_currency_code := jai_constants.func_curr;
4736: ld_accounting_date := TRUNC(SYSDATE);
4737: lv_destination := 'G';