[Home] [Help]
943: lv_inv_gen_process_flag VARCHAR2(10);
944: lv_inv_gen_process_message VARCHAR2(2000);
945: ln_repository_id NUMBER;
946: lv_source_trx_type VARCHAR2(30):='RECEIVING';
947: table_rcv_transactions VARCHAR2(30):= 'JAI_MTL_TRXS';
948: lv_account_name VARCHAR2(50);
949: ln_code_combination_id NUMBER;
950: ln_interim_recovery_account NUMBER;
951: ln_entered_dr NUMBER;
1080: pn_organization_id => p_organization_id,
1081: pn_location_id => p_location_id,
1082: pv_source => jai_constants.source_rcv,
1083: pv_source_trx_type => lv_source_trx_type,
1084: pv_source_table_name => table_rcv_transactions,
1085: pn_source_id => p_transaction_temp_id,
1086: pd_transaction_date => trunc(sysdate),
1087: pv_account_name => lv_account_name,
1088: pn_charge_account_id => ln_code_combination_id,
1157: pv_process_message => lv_process_message,
1158: pv_tax_type => rec_claims.tax_type,
1159: pv_source => jai_constants.source_rcv,
1160: pv_source_trx_type => lv_source_trx_type,
1161: pv_source_table_name => table_rcv_transactions,
1162: pn_source_id => p_transaction_temp_id,
1163: pv_reference_name => NULL,
1164: pn_reference_id => NULL
1165: );
1183: pv_process_message => lv_process_message,
1184: pv_tax_type => rec_claims.tax_type,
1185: pv_source => jai_constants.source_rcv,
1186: pv_source_trx_type => lv_source_trx_type,
1187: pv_source_table_name => table_rcv_transactions,
1188: pn_source_id => p_transaction_temp_id,
1189: pv_reference_name => NULL,
1190: pn_reference_id => NULL
1191: );
1217: cen.transaction_id ,
1218: rcv.excise_invoice_no ,
1219: rcv.excise_invoice_date
1220: from
1221: JAI_RCV_TRANSACTIONS rcv,
1222: JAI_RCV_CENVAT_CLAIMS cen
1223: where
1224: rcv.shipment_line_id=cen.shipment_line_id
1225: and rcv.item_class in ('CGIN','CGEX')
3733: SELECT * from JAI_RCV_LINE_TAXES
3734: WHERE shipment_line_id = cp_shipment_line_id;
3735:
3736: CURSOR c_trx (cp_transaction_id IN NUMBER) IS
3737: SELECT * from JAI_RCV_TRANSACTIONS
3738: WHERE transaction_id = cp_transaction_id ;
3739:
3740: CURSOR c_base_trx (cp_transaction_id IN NUMBER) IS
3741: SELECT vendor_id , vendor_site_id , transaction_id , shipment_line_id from rcv_transactions
3737: SELECT * from JAI_RCV_TRANSACTIONS
3738: WHERE transaction_id = cp_transaction_id ;
3739:
3740: CURSOR c_base_trx (cp_transaction_id IN NUMBER) IS
3741: SELECT vendor_id , vendor_site_id , transaction_id , shipment_line_id from rcv_transactions
3742: WHERE transaction_id = cp_transaction_id;
3743:
3744: CURSOR c_mtl_params(cp_organization_id IN NUMBER) IS
3745: SELECT * from mtl_parameters
4024: r_mtl_params.organization_code,
4025: lv_reference_10,
4026: 'India Localization Entry',
4027: 'jai_mtl_trxs_pkg.auto_claim',
4028: 'rcv_transactions',
4029: 'rcv_Transaction_id',
4030: r_Trx.transaction_id,
4031: r_trx.organization_id
4032: );
4138: r_mtl_params.organization_code,
4139: lv_reference_10,
4140: 'India Localization Entry',
4141: 'jai_mtl_trxs_pkg.auto_claim',
4142: 'rcv_transactions',
4143: 'rcv_Transaction_id',
4144: r_Trx.transaction_id,
4145: r_trx.organization_id
4146: );
4316: r_mtl_params.organization_code,
4317: lv_reference_10,
4318: 'India Localization Entry',
4319: 'jai_mtl_trxs_pkg.auto_claim',
4320: 'rcv_transactions',
4321: 'rcv_Transaction_id',
4322: r_Trx.transaction_id,
4323: r_trx.organization_id
4324: );
4431: r_mtl_params.organization_code,
4432: lv_reference_10,
4433: 'India Localization Entry',
4434: 'jai_mtl_trxs_pkg.auto_claim',
4435: 'rcv_transactions',
4436: 'rcv_Transaction_id',
4437: r_Trx.transaction_id,
4438: r_trx.organization_id
4439: );
4547: r_mtl_params.organization_code,
4548: lv_reference_10,
4549: 'India Localization Entry',
4550: 'jai_mtl_trxs_pkg.auto_claim',
4551: 'rcv_transactions',
4552: 'rcv_Transaction_id',
4553: r_Trx.transaction_id,
4554: r_trx.organization_id
4555: );
4662: r_mtl_params.organization_code,
4663: lv_reference_10,
4664: 'India Localization Entry',
4665: 'jai_mtl_trxs_pkg.auto_claim',
4666: 'rcv_transactions',
4667: 'rcv_Transaction_id',
4668: r_Trx.transaction_id,
4669: r_trx.organization_id
4670: );
4689: lv_inv_gen_process_flag VARCHAR2(10);
4690: lv_inv_gen_process_message VARCHAR2(2000);
4691: ln_repository_id NUMBER;
4692: lv_source_trx_type VARCHAR2(30):='RECEIVING';
4693: table_rcv_transactions VARCHAR2(30):= 'JAI_MTL_TRXS';
4694: lv_account_name VARCHAR2(50);
4695: ln_code_combination_id NUMBER;
4696: ln_interim_recovery_account NUMBER;
4697: ln_entered_dr NUMBER;
4746: pn_organization_id => p_organization_id,
4747: pn_location_id => p_location_id,
4748: pv_source => jai_constants.source_rcv,
4749: pv_source_trx_type => lv_source_trx_type,
4750: pv_source_table_name => table_rcv_transactions,
4751: pn_source_id => p_transaction_id,
4752: pd_transaction_date => trunc(sysdate),
4753: pv_account_name => lv_account_name,
4754: pn_charge_account_id => ln_code_combination_id,
4798: PROCEDURE claim_balance_cgvat(
4799: p_term_id IN jai_rgm_terms.term_id%TYPE DEFAULT NULL,
4800: p_shipment_header_id IN rcv_shipment_headers.shipment_header_id%TYPE DEFAULT NULL,
4801: p_shipment_line_id IN rcv_shipment_lines.shipment_line_id%TYPE DEFAULT NULL,
4802: p_transaction_id IN rcv_transactions.transaction_id%TYPE DEFAULT NULL,
4803: p_tax_type IN jai_cmn_taxes_all.tax_type%TYPE DEFAULT NULL,
4804: p_tax_id IN jai_cmn_taxes_all.tax_id%TYPE DEFAULT NULL,
4805: p_receipt_num IN VARCHAR2,
4806: P_applied_qty IN NUMBER,
4829: ORDER BY shipment_line_id;
4830:
4831:
4832: CURSOR cur_txns(cp_shipment_line_id IN rcv_shipment_lines.shipment_line_id%TYPE,
4833: cp_transaction_id IN rcv_transactions.transaction_id%TYPE)
4834: IS
4835: SELECT transaction_id,
4836: transaction_type,
4837: transaction_date,
4838: tax_transaction_id,
4839: parent_transaction_type,
4840: currency_conversion_rate,
4841: quantity
4842: FROM JAI_RCV_TRANSACTIONS
4843: WHERE shipment_line_id = NVL(cp_shipment_line_id, shipment_line_id)
4844: AND transaction_id = NVL(cp_transaction_id, transaction_id)
4845: and organization_id=p_organization_id
4846: and inventory_item_id=p_inventory_item_id
4854: ORDER BY transaction_id;
4855:
4856:
4857:
4858: CURSOR cur_tax(cp_shipment_line_id IN rcv_transactions.shipment_line_id%TYPE,
4859: cp_currency_conversion_rate IN JAI_RCV_TRANSACTIONS.currency_conversion_rate%TYPE)
4860: IS
4861: SELECT DECODE(a.currency, jai_constants.func_curr, a.tax_amount, a.tax_amount*cp_currency_conversion_rate) tax_amount, --Removed Round condition by Bgowrava for Bug#8414075
4862: a.tax_type,
4855:
4856:
4857:
4858: CURSOR cur_tax(cp_shipment_line_id IN rcv_transactions.shipment_line_id%TYPE,
4859: cp_currency_conversion_rate IN JAI_RCV_TRANSACTIONS.currency_conversion_rate%TYPE)
4860: IS
4861: SELECT DECODE(a.currency, jai_constants.func_curr, a.tax_amount, a.tax_amount*cp_currency_conversion_rate) tax_amount, --Removed Round condition by Bgowrava for Bug#8414075
4862: a.tax_type,
4863: a.tax_id,
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);
5158: ln_regime_id jai_rgm_definitions.regime_id%TYPE;
5159: