[Home] [Help]
820: lv_inv_gen_process_flag VARCHAR2(10);
821: lv_inv_gen_process_message VARCHAR2(2000);
822: ln_repository_id NUMBER;
823: lv_source_trx_type VARCHAR2(30):='RECEIVING';
824: table_rcv_transactions VARCHAR2(30):= 'JAI_MTL_TRXS';
825: lv_account_name VARCHAR2(50);
826: ln_code_combination_id NUMBER;
827: ln_interim_recovery_account NUMBER;
828: ln_entered_dr NUMBER;
957: pn_organization_id => p_organization_id,
958: pn_location_id => p_location_id,
959: pv_source => jai_constants.source_rcv,
960: pv_source_trx_type => lv_source_trx_type,
961: pv_source_table_name => table_rcv_transactions,
962: pn_source_id => p_transaction_temp_id,
963: pd_transaction_date => trunc(sysdate),
964: pv_account_name => lv_account_name,
965: pn_charge_account_id => ln_code_combination_id,
1029: pv_process_message => lv_process_message,
1030: pv_tax_type => rec_claims.tax_type,
1031: pv_source => jai_constants.source_rcv,
1032: pv_source_trx_type => lv_source_trx_type,
1033: pv_source_table_name => table_rcv_transactions,
1034: pn_source_id => p_transaction_temp_id,
1035: pv_reference_name => NULL,
1036: pn_reference_id => NULL
1037: );
1055: pv_process_message => lv_process_message,
1056: pv_tax_type => rec_claims.tax_type,
1057: pv_source => jai_constants.source_rcv,
1058: pv_source_trx_type => lv_source_trx_type,
1059: pv_source_table_name => table_rcv_transactions,
1060: pn_source_id => p_transaction_temp_id,
1061: pv_reference_name => NULL,
1062: pn_reference_id => NULL
1063: );
1089: cen.transaction_id ,
1090: rcv.excise_invoice_no ,
1091: rcv.excise_invoice_date
1092: from
1093: JAI_RCV_TRANSACTIONS rcv,
1094: JAI_RCV_CENVAT_CLAIMS cen
1095: where
1096: rcv.shipment_line_id=cen.shipment_line_id
1097: and rcv.item_class in ('CGIN','CGEX')
3569: SELECT * from JAI_RCV_LINE_TAXES
3570: WHERE shipment_line_id = cp_shipment_line_id;
3571:
3572: CURSOR c_trx (cp_transaction_id IN NUMBER) IS
3573: SELECT * from JAI_RCV_TRANSACTIONS
3574: WHERE transaction_id = cp_transaction_id ;
3575:
3576: CURSOR c_base_trx (cp_transaction_id IN NUMBER) IS
3577: SELECT vendor_id , vendor_site_id , transaction_id , shipment_line_id from rcv_transactions
3573: SELECT * from JAI_RCV_TRANSACTIONS
3574: WHERE transaction_id = cp_transaction_id ;
3575:
3576: CURSOR c_base_trx (cp_transaction_id IN NUMBER) IS
3577: SELECT vendor_id , vendor_site_id , transaction_id , shipment_line_id from rcv_transactions
3578: WHERE transaction_id = cp_transaction_id;
3579:
3580: CURSOR c_mtl_params(cp_organization_id IN NUMBER) IS
3581: SELECT * from mtl_parameters
3847: r_mtl_params.organization_code,
3848: lv_reference_10,
3849: 'India Localization Entry',
3850: 'jai_mtl_trxs_pkg.auto_claim',
3851: 'rcv_transactions',
3852: 'rcv_Transaction_id',
3853: r_Trx.transaction_id,
3854: r_trx.organization_id
3855: );
3961: r_mtl_params.organization_code,
3962: lv_reference_10,
3963: 'India Localization Entry',
3964: 'jai_mtl_trxs_pkg.auto_claim',
3965: 'rcv_transactions',
3966: 'rcv_Transaction_id',
3967: r_Trx.transaction_id,
3968: r_trx.organization_id
3969: );
4108: r_mtl_params.organization_code,
4109: lv_reference_10,
4110: 'India Localization Entry',
4111: 'jai_mtl_trxs_pkg.auto_claim',
4112: 'rcv_transactions',
4113: 'rcv_Transaction_id',
4114: r_Trx.transaction_id,
4115: r_trx.organization_id
4116: );
4223: r_mtl_params.organization_code,
4224: lv_reference_10,
4225: 'India Localization Entry',
4226: 'jai_mtl_trxs_pkg.auto_claim',
4227: 'rcv_transactions',
4228: 'rcv_Transaction_id',
4229: r_Trx.transaction_id,
4230: r_trx.organization_id
4231: );
4249: lv_inv_gen_process_flag VARCHAR2(10);
4250: lv_inv_gen_process_message VARCHAR2(2000);
4251: ln_repository_id NUMBER;
4252: lv_source_trx_type VARCHAR2(30):='RECEIVING';
4253: table_rcv_transactions VARCHAR2(30):= 'JAI_MTL_TRXS';
4254: lv_account_name VARCHAR2(50);
4255: ln_code_combination_id NUMBER;
4256: ln_interim_recovery_account NUMBER;
4257: ln_entered_dr NUMBER;
4306: pn_organization_id => p_organization_id,
4307: pn_location_id => p_location_id,
4308: pv_source => jai_constants.source_rcv,
4309: pv_source_trx_type => lv_source_trx_type,
4310: pv_source_table_name => table_rcv_transactions,
4311: pn_source_id => p_transaction_id,
4312: pd_transaction_date => trunc(sysdate),
4313: pv_account_name => lv_account_name,
4314: pn_charge_account_id => ln_code_combination_id,
4353: PROCEDURE claim_balance_cgvat(
4354: p_term_id IN jai_rgm_terms.term_id%TYPE DEFAULT NULL,
4355: p_shipment_header_id IN rcv_shipment_headers.shipment_header_id%TYPE DEFAULT NULL,
4356: p_shipment_line_id IN rcv_shipment_lines.shipment_line_id%TYPE DEFAULT NULL,
4357: p_transaction_id IN rcv_transactions.transaction_id%TYPE DEFAULT NULL,
4358: p_tax_type IN jai_cmn_taxes_all.tax_type%TYPE DEFAULT NULL,
4359: p_tax_id IN jai_cmn_taxes_all.tax_id%TYPE DEFAULT NULL,
4360: p_receipt_num IN VARCHAR2,
4361: P_applied_qty IN NUMBER,
4384: ORDER BY shipment_line_id;
4385:
4386:
4387: CURSOR cur_txns(cp_shipment_line_id IN rcv_shipment_lines.shipment_line_id%TYPE,
4388: cp_transaction_id IN rcv_transactions.transaction_id%TYPE)
4389: IS
4390: SELECT transaction_id,
4391: transaction_type,
4392: transaction_date,
4393: tax_transaction_id,
4394: parent_transaction_type,
4395: currency_conversion_rate,
4396: quantity
4397: FROM JAI_RCV_TRANSACTIONS
4398: WHERE shipment_line_id = NVL(cp_shipment_line_id, shipment_line_id)
4399: AND transaction_id = NVL(cp_transaction_id, transaction_id)
4400: and organization_id=p_organization_id
4401: and inventory_item_id=p_inventory_item_id
4409: ORDER BY transaction_id;
4410:
4411:
4412:
4413: CURSOR cur_tax(cp_shipment_line_id IN rcv_transactions.shipment_line_id%TYPE,
4414: cp_currency_conversion_rate IN JAI_RCV_TRANSACTIONS.currency_conversion_rate%TYPE)
4415: IS
4416: SELECT ROUND(
4417: DECODE(a.currency, jai_constants.func_curr, a.tax_amount, a.tax_amount*cp_currency_conversion_rate),
4410:
4411:
4412:
4413: CURSOR cur_tax(cp_shipment_line_id IN rcv_transactions.shipment_line_id%TYPE,
4414: cp_currency_conversion_rate IN JAI_RCV_TRANSACTIONS.currency_conversion_rate%TYPE)
4415: IS
4416: SELECT ROUND(
4417: DECODE(a.currency, jai_constants.func_curr, a.tax_amount, a.tax_amount*cp_currency_conversion_rate),
4418: NVL(b.rounding_factor, 0)
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);
4715: ln_regime_id jai_rgm_definitions.regime_id%TYPE;
4716: