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.JAI_MTL_TRXS_PKG dependencies on JAI_MTL_TRXS

Line 1: PACKAGE BODY JAI_MTL_TRXS_PKG AS

1: PACKAGE BODY JAI_MTL_TRXS_PKG AS
2: /* $Header: jai_mtl_trxs_pkg.plb 120.15.12010000.2 2008/11/19 12:10:26 mbremkum ship $ */
3:
4: /*----------------------------------------------------------------------------------------------------------------------
5: CHANGE HISTORY: FILENAME: jai_mtl_trxs_pkg.plb

Line 2: /* $Header: jai_mtl_trxs_pkg.plb 120.15.12010000.2 2008/11/19 12:10:26 mbremkum ship $ */

1: PACKAGE BODY JAI_MTL_TRXS_PKG AS
2: /* $Header: jai_mtl_trxs_pkg.plb 120.15.12010000.2 2008/11/19 12:10:26 mbremkum ship $ */
3:
4: /*----------------------------------------------------------------------------------------------------------------------
5: CHANGE HISTORY: FILENAME: jai_mtl_trxs_pkg.plb
6: S.No Date Author and Details

Line 5: CHANGE HISTORY: FILENAME: jai_mtl_trxs_pkg.plb

1: PACKAGE BODY JAI_MTL_TRXS_PKG AS
2: /* $Header: jai_mtl_trxs_pkg.plb 120.15.12010000.2 2008/11/19 12:10:26 mbremkum ship $ */
3:
4: /*----------------------------------------------------------------------------------------------------------------------
5: CHANGE HISTORY: FILENAME: jai_mtl_trxs_pkg.plb
6: S.No Date Author and Details
7: ------------------------------------------------------------------------------------------------------------------------
8: 1 24-Jan-2007 rchandan for #2942973 for File Version 115.6 (INTER ORG Impl.)
9: The parameter p_receipt_num in claim_balance_cgvat was defined as NUMBER and

Line 105: The above mentioned issue is happening because of the deadlock on jai_mtl_trxs table.

101: Issue:
102: When trying to save the IL interorg transfer a error message pops up and also
103: not allowing close the form. Which makes to close the application and login again.
104:
105: The above mentioned issue is happening because of the deadlock on jai_mtl_trxs table.
106: 1.on the key commit trigger of mtl_trx_line in interorg form(JAINVMTX.fmb),there is an update stmt on jai_mtl_trxs table.
107: If any error occurs in this trigger and the user tries to comeout of the form there is a call to sync_with_base_trx
108: which will delete the error record in jai_mtl_trxs table.
109: since it is trying to delete the same record which has been locked by the update stmt,deadlock error occurs waiting for the resource .

Line 106: 1.on the key commit trigger of mtl_trx_line in interorg form(JAINVMTX.fmb),there is an update stmt on jai_mtl_trxs table.

102: When trying to save the IL interorg transfer a error message pops up and also
103: not allowing close the form. Which makes to close the application and login again.
104:
105: The above mentioned issue is happening because of the deadlock on jai_mtl_trxs table.
106: 1.on the key commit trigger of mtl_trx_line in interorg form(JAINVMTX.fmb),there is an update stmt on jai_mtl_trxs table.
107: If any error occurs in this trigger and the user tries to comeout of the form there is a call to sync_with_base_trx
108: which will delete the error record in jai_mtl_trxs table.
109: since it is trying to delete the same record which has been locked by the update stmt,deadlock error occurs waiting for the resource .
110:

Line 108: which will delete the error record in jai_mtl_trxs table.

104:
105: The above mentioned issue is happening because of the deadlock on jai_mtl_trxs table.
106: 1.on the key commit trigger of mtl_trx_line in interorg form(JAINVMTX.fmb),there is an update stmt on jai_mtl_trxs table.
107: If any error occurs in this trigger and the user tries to comeout of the form there is a call to sync_with_base_trx
108: which will delete the error record in jai_mtl_trxs table.
109: since it is trying to delete the same record which has been locked by the update stmt,deadlock error occurs waiting for the resource .
110:
111: Fix:
112: changes are done in cenvat_process procedure

Line 342: FROM jai_mtl_trxs trx,

338: trx.creation_date,
339: trx.created_by,
340: trx.last_update_date,
341: trx.last_update_login
342: FROM jai_mtl_trxs trx,
343: JAI_INV_SUBINV_DTLS subinv,
344: JAI_INV_ITM_SETUPS itm
345: WHERE subinv.organization_id = trx.to_organization
346: AND itm.organization_id = trx.to_organization

Line 367: jai_mtl_trxs trx

363: SUM(decode(tax_type, 'Other Excise', round(tax_amt), 0)) other_ed,
364: SUM(decode(tax_type, jai_constants.tax_type_exc_edu_cess, round(tax_amt), 0)) other_cess,
365: sum(decode(tax_type, jai_constants.tax_type_sh_exc_edu_cess, round(tax_amt), 0)) other_sh_cess --Added higher education cess constants by vkaranam for bug#5907436
366: FROM jai_cmn_document_taxes tax,
367: jai_mtl_trxs trx
368: WHERE tax.source_doc_line_id = trx.transaction_temp_id
369: AND trx.transaction_header_id = tax.source_doc_id
370: AND trx.transaction_temp_id = trx_temp_id;
371:

Line 824: table_rcv_transactions VARCHAR2(30):= 'JAI_MTL_TRXS';

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;

Line 871: jai_mtl_trxs jmt,

867: jmt.transaction_header_id,
868: --jmt.creation_date,
869: sum(jcdt.tax_amt) tax_amt
870: FROM
871: jai_mtl_trxs jmt,
872: jai_cmn_document_taxes jcdt,
873: jai_cmn_taxes_all jtc,
874: jai_rgm_registrations jrg,
875: jai_rgm_definitions jrr

Line 991: jai_mtl_trxs_pkg.do_cenvat_Acctg(

987: p_process_message := lv_process_message;
988: RETURN;
989: END IF;
990: begin
991: jai_mtl_trxs_pkg.do_cenvat_Acctg(
992: p_set_of_books_id => p_set_of_books_id ,
993: p_transaction_temp_id =>p_transaction_temp_id ,
994: p_je_source_name =>v_source_name ,
995: p_je_category_name =>v_category_name,

Line 1171: 'jai_mtl_trxs',

1167: null,
1168: p_params(i).organization_code, -- From mtl_parameters
1169: 'India Localization Entry for Interorg-XFER ',
1170: 'jai_mtl_trx_pkg.do_cenvat_Acctg',
1171: 'jai_mtl_trxs',
1172: p_transaction_temp_id,
1173: 'transaction_temp_id',
1174: to_char(p_params(i).organization_id),
1175: 'India Localization Entry' -- bug 6487405

Line 1231: 'jai_mtl_trxs',

1227: null,
1228: p_params(i).organization_code, -- From mtl_parameters
1229: 'India Localization Entry for Interorg-XFER ',
1230: 'jai_mtl_trx_pkg.do_cenvat_Acctg',
1231: 'jai_mtl_trxs',
1232: p_transaction_temp_id,
1233: 'transaction_temp_id',
1234: to_char(p_params(i).organization_id),
1235: sysdate,

Line 1290: 'jai_mtl_trxs',

1286: null,
1287: p_params(i).organization_code,
1288: 'India Localization Entry for Interorg-XFER ',
1289: 'jai_mtl_trx_pkg.do_cenvat_Acctg',
1290: 'jai_mtl_trxs',
1291: p_transaction_temp_id,
1292: 'transaction_temp_id',
1293: to_char(p_params(i).organization_id),
1294: 'India Localization Entry' -- bug 6487405

Line 1349: 'jai_mtl_trxs',

1345: null,
1346: p_params(i).organization_code,
1347: 'India Localization Entry for Interorg-XFER ',
1348: 'jai_mtl_trx_pkg.do_cenvat_Acctg',
1349: 'jai_mtl_trxs',
1350: p_transaction_temp_id,
1351: 'transaction_temp_id',
1352: to_char(p_params(i).organization_id),
1353: sysdate,

Line 1403: jai_mtl_trxs D,

1399: d.location_id,
1400: d.inventory_item_id
1401: FROM Jai_cmn_document_Taxes A,
1402: jai_cmn_taxes_all B,
1403: jai_mtl_trxs D,
1404: jai_regime_tax_types_v aa
1405: WHERE source_doc_line_id = p_transaction_temp_id
1406: AND d.transaction_temp_id = p_transaction_temp_id
1407: AND a.source_doc_type = 'INTERORG_XFER'

Line 1460: SELECT * FROM jai_mtl_trxs

1456: WHERE from_organization_id = p_from_organization_id
1457: AND to_organization_id = p_to_organization_id ;
1458:
1459: CURSOR c_get_trx_info IS
1460: SELECT * FROM jai_mtl_trxs
1461: WHERE transaction_temp_id = p_transaction_temp_id;
1462:
1463: CURSOR c_rcv_params (p_organization_id IN NUMBER) IS
1464: select receiving_account_id

Line 2700: CURSOR c_jai_mtl_Trxs ( cp_Trx_temp_id IN NUMBER ) is

2696: SELECT *
2697: FROM mtl_parameters
2698: WHERE organization_id = cp_organization_id;
2699:
2700: CURSOR c_jai_mtl_Trxs ( cp_Trx_temp_id IN NUMBER ) is
2701: SELECT * from jai_mtl_Trxs
2702: WHERE transaction_Temp_id = cp_Trx_temp_id;
2703:
2704:

Line 2701: SELECT * from jai_mtl_Trxs

2697: FROM mtl_parameters
2698: WHERE organization_id = cp_organization_id;
2699:
2700: CURSOR c_jai_mtl_Trxs ( cp_Trx_temp_id IN NUMBER ) is
2701: SELECT * from jai_mtl_Trxs
2702: WHERE transaction_Temp_id = cp_Trx_temp_id;
2703:
2704:
2705: CURSOR c_proc_exists(cp_object_name user_procedures.object_name%type ,

Line 2745: r_mtl_Trxs c_jai_mtl_Trxs%ROWTYPE;

2741: r_Rcv_params c_rcv_params%ROWTYPE;
2742: r_mtl_params c_mtl_params%Rowtype;
2743: ln_costing_grp_id NUMBER;
2744: lv_trx_type_name VARCHAR2(30);
2745: r_mtl_Trxs c_jai_mtl_Trxs%ROWTYPE;
2746:
2747: ln_Excise_amt NUMBER;
2748: ln_non_modvat_amt NUMBER;
2749: ln_oth_modvat_amt NUMBER;

Line 2766: FROM jai_mtl_trxs jmt,

2762:
2763: cursor cur_item_class /*6501436*/
2764: IS
2765: SELECT jiis.item_class
2766: FROM jai_mtl_trxs jmt,
2767: JAI_INV_ITM_SETUPS jiis
2768: WHERE jmt.inventory_item_id = jiis.inventory_item_id
2769: AND jmt.transaction_temp_id = p_trx_temp_id;
2770:

Line 2776: OPEN c_jai_mtl_Trxs(p_trx_temp_id);

2772: BEGIN
2773:
2774: lv_trx_type_name := 'Average cost update' ;--'Direct Org Transfer';
2775:
2776: OPEN c_jai_mtl_Trxs(p_trx_temp_id);
2777: FETCH c_jai_mtl_Trxs INTO r_mtl_Trxs;
2778: CLOSE c_jai_mtl_Trxs;
2779:
2780: Open c_mtl_types(lv_trx_type_name);

Line 2777: FETCH c_jai_mtl_Trxs INTO r_mtl_Trxs;

2773:
2774: lv_trx_type_name := 'Average cost update' ;--'Direct Org Transfer';
2775:
2776: OPEN c_jai_mtl_Trxs(p_trx_temp_id);
2777: FETCH c_jai_mtl_Trxs INTO r_mtl_Trxs;
2778: CLOSE c_jai_mtl_Trxs;
2779:
2780: Open c_mtl_types(lv_trx_type_name);
2781: FETCH c_mtl_types INTO r_mtl_types;

Line 2778: CLOSE c_jai_mtl_Trxs;

2774: lv_trx_type_name := 'Average cost update' ;--'Direct Org Transfer';
2775:
2776: OPEN c_jai_mtl_Trxs(p_trx_temp_id);
2777: FETCH c_jai_mtl_Trxs INTO r_mtl_Trxs;
2778: CLOSE c_jai_mtl_Trxs;
2779:
2780: Open c_mtl_types(lv_trx_type_name);
2781: FETCH c_mtl_types INTO r_mtl_types;
2782: CLOSE c_mtl_types;

Line 3298: lv_reference_23:='jai_mtl_trxs_pkg.std_cost_entry';

3294: lv_source_name := 'Purchasing India';
3295: lv_category_name:='MMT';/*6504150*/
3296: lv_reference_10 :='India Local Standard Cost Entry For INTERORG_XFER and Organization_code= '|| lv_organization_code ;
3297: lv_reference_entry := 'India Localization Entry';
3298: lv_reference_23:='jai_mtl_trxs_pkg.std_cost_entry';
3299: lv_reference_24:='jai_mtl_trxs';
3300: lv_reference_26:='transaction_id';
3301: lv_currency_code :='INR';
3302:

Line 3299: lv_reference_24:='jai_mtl_trxs';

3295: lv_category_name:='MMT';/*6504150*/
3296: lv_reference_10 :='India Local Standard Cost Entry For INTERORG_XFER and Organization_code= '|| lv_organization_code ;
3297: lv_reference_entry := 'India Localization Entry';
3298: lv_reference_23:='jai_mtl_trxs_pkg.std_cost_entry';
3299: lv_reference_24:='jai_mtl_trxs';
3300: lv_reference_26:='transaction_id';
3301: lv_currency_code :='INR';
3302:
3303: OPEN cur_rcv_accnt(p_organization_id);

Line 3850: 'jai_mtl_trxs_pkg.auto_claim',

3846: NULL,
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

Line 3964: 'jai_mtl_trxs_pkg.auto_claim',

3960: NULL,
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

Line 4111: 'jai_mtl_trxs_pkg.auto_claim',

4107: NULL,
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

Line 4226: 'jai_mtl_trxs_pkg.auto_claim',

4222: NULL,
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

Line 4253: table_rcv_transactions VARCHAR2(30):= 'JAI_MTL_TRXS';

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;

Line 4732: lv_reference_23 := 'jai_mtl_trxs_pkg.process_vat_claim_acctg';

4728: lv_account_nature := 'VAT CLAIM';
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);

Line 4856: FROM jai_mtl_trxs

4852: DELETE jai_mtl_match_receipts
4853: WHERE transaction_temp_id in
4854: (
4855: SELECT transaction_temp_id
4856: FROM jai_mtl_trxs
4857: WHERE transaction_header_id = p_transaction_header_id
4858: AND transaction_temp_id = nvl(p_transaction_temp_id, transaction_temp_id )
4859: AND transaction_commit_date is null
4860: );

Line 4868: FROM jai_mtl_trxs

4864: and source_table_name = 'MTL_MATERIAL_TRANSACTIONS_TEMP'
4865: AND source_doc_line_id IN
4866: (
4867: SELECT transaction_temp_id
4868: FROM jai_mtl_trxs
4869: WHERE transaction_header_id = p_transaction_header_id
4870: AND transaction_temp_id = nvl(p_transaction_temp_id, transaction_temp_id )
4871: AND transaction_commit_date is null
4872: );

Line 4878: FROM jai_mtl_trxs

4874: DELETE JAI_CMN_MATCH_TAXES
4875: WHERE ref_line_id IN
4876: (
4877: SELECT transaction_temp_id
4878: FROM jai_mtl_trxs
4879: WHERE transaction_header_id = p_transaction_header_id
4880: AND transaction_temp_id = nvl(p_transaction_temp_id, transaction_temp_id )
4881: AND transaction_commit_date is null
4882: )

Line 4889: FROM jai_mtl_trxs

4885: DELETE JAI_CMN_MATCH_RECEIPTS
4886: WHERE ref_line_id IN
4887: (
4888: SELECT transaction_temp_id
4889: FROM jai_mtl_trxs
4890: WHERE transaction_header_id = p_transaction_header_id
4891: AND transaction_temp_id = nvl(p_transaction_temp_id, transaction_temp_id )
4892: AND transaction_commit_date is null
4893: )

Line 4896: DELETE jai_mtl_trxs

4892: AND transaction_commit_date is null
4893: )
4894: AND order_invoice='X';
4895:
4896: DELETE jai_mtl_trxs
4897: WHERE transaction_header_id = p_transaction_header_id
4898: AND transaction_temp_id = nvl(p_transaction_temp_id, transaction_temp_id )
4899: AND transaction_commit_date is null;
4900:

Line 4943: cursor c_jai_mtl_trxs is

4939: AND su.site_use_code = 'SHIP_TO'
4940: AND RTRIM(Ltrim(hrl.location_code)) = LTRIM(Rtrim(p_to_location_code))
4941: AND hrl.inventory_organization_id = p_to_organization_id ; -- bug 6444945
4942:
4943: cursor c_jai_mtl_trxs is
4944: SELECT to_subinventory ,
4945: inventory_item_id ,
4946: quantity ,
4947: transaction_uom

Line 4948: FROM jai_mtl_trxs

4944: SELECT to_subinventory ,
4945: inventory_item_id ,
4946: quantity ,
4947: transaction_uom
4948: FROM jai_mtl_trxs
4949: WHERE transaction_header_id = p_header_id
4950: AND transaction_temp_id = p_line_id;
4951:
4952: r_jai_mtl_trxs c_jai_mtl_trxs%ROWTYPE;

Line 4952: r_jai_mtl_trxs c_jai_mtl_trxs%ROWTYPE;

4948: FROM jai_mtl_trxs
4949: WHERE transaction_header_id = p_header_id
4950: AND transaction_temp_id = p_line_id;
4951:
4952: r_jai_mtl_trxs c_jai_mtl_trxs%ROWTYPE;
4953: ln_site_use_id number(15);
4954: ln_cust_account_id number(15);
4955: ln_tax_category_id number(15);
4956: ln_user_id number(15);

Line 4965: open c_jai_mtl_trxs;

4961: BEGIN
4962:
4963: ln_user_id := fnd_global.user_id;
4964:
4965: open c_jai_mtl_trxs;
4966: fetch c_jai_mtl_trxs into r_jai_mtl_trxs;
4967: close c_jai_mtl_trxs;
4968:
4969: /*

Line 4966: fetch c_jai_mtl_trxs into r_jai_mtl_trxs;

4962:
4963: ln_user_id := fnd_global.user_id;
4964:
4965: open c_jai_mtl_trxs;
4966: fetch c_jai_mtl_trxs into r_jai_mtl_trxs;
4967: close c_jai_mtl_trxs;
4968:
4969: /*
4970: ||The following condition is to see if only quantity is changed

Line 4967: close c_jai_mtl_trxs;

4963: ln_user_id := fnd_global.user_id;
4964:
4965: open c_jai_mtl_trxs;
4966: fetch c_jai_mtl_trxs into r_jai_mtl_trxs;
4967: close c_jai_mtl_trxs;
4968:
4969: /*
4970: ||The following condition is to see if only quantity is changed
4971: ||In this scenario the taxes need to be recalculated and not redefaulted.

Line 4974: IF r_jai_mtl_trxs.quantity <> p_line_quantity THEN

4970: ||The following condition is to see if only quantity is changed
4971: ||In this scenario the taxes need to be recalculated and not redefaulted.
4972: ||If any match information is present this would also be deleted
4973: */
4974: IF r_jai_mtl_trxs.quantity <> p_line_quantity THEN
4975:
4976: IF r_jai_mtl_trxs.inventory_item_id = p_inventory_item_id AND
4977: r_jai_mtl_trxs.transaction_uom = p_uom_code AND
4978: r_jai_mtl_trxs.to_subinventory = p_transfer_subinventory THEN

Line 4976: IF r_jai_mtl_trxs.inventory_item_id = p_inventory_item_id AND

4972: ||If any match information is present this would also be deleted
4973: */
4974: IF r_jai_mtl_trxs.quantity <> p_line_quantity THEN
4975:
4976: IF r_jai_mtl_trxs.inventory_item_id = p_inventory_item_id AND
4977: r_jai_mtl_trxs.transaction_uom = p_uom_code AND
4978: r_jai_mtl_trxs.to_subinventory = p_transfer_subinventory THEN
4979:
4980: UPDATE jai_cmn_document_taxes

Line 4977: r_jai_mtl_trxs.transaction_uom = p_uom_code AND

4973: */
4974: IF r_jai_mtl_trxs.quantity <> p_line_quantity THEN
4975:
4976: IF r_jai_mtl_trxs.inventory_item_id = p_inventory_item_id AND
4977: r_jai_mtl_trxs.transaction_uom = p_uom_code AND
4978: r_jai_mtl_trxs.to_subinventory = p_transfer_subinventory THEN
4979:
4980: UPDATE jai_cmn_document_taxes
4981: SET tax_amt = ( p_line_quantity / r_jai_mtl_trxs.quantity ) * tax_amt,

Line 4978: r_jai_mtl_trxs.to_subinventory = p_transfer_subinventory THEN

4974: IF r_jai_mtl_trxs.quantity <> p_line_quantity THEN
4975:
4976: IF r_jai_mtl_trxs.inventory_item_id = p_inventory_item_id AND
4977: r_jai_mtl_trxs.transaction_uom = p_uom_code AND
4978: r_jai_mtl_trxs.to_subinventory = p_transfer_subinventory THEN
4979:
4980: UPDATE jai_cmn_document_taxes
4981: SET tax_amt = ( p_line_quantity / r_jai_mtl_trxs.quantity ) * tax_amt,
4982: FUNC_TAX_AMT = ( p_line_quantity / r_jai_mtl_trxs.quantity ) * func_tax_amt,

Line 4981: SET tax_amt = ( p_line_quantity / r_jai_mtl_trxs.quantity ) * tax_amt,

4977: r_jai_mtl_trxs.transaction_uom = p_uom_code AND
4978: r_jai_mtl_trxs.to_subinventory = p_transfer_subinventory THEN
4979:
4980: UPDATE jai_cmn_document_taxes
4981: SET tax_amt = ( p_line_quantity / r_jai_mtl_trxs.quantity ) * tax_amt,
4982: FUNC_TAX_AMT = ( p_line_quantity / r_jai_mtl_trxs.quantity ) * func_tax_amt,
4983: last_update_date = sysdate,
4984: last_updated_by = ln_user_id
4985: WHERE source_doc_id = p_header_id

Line 4982: FUNC_TAX_AMT = ( p_line_quantity / r_jai_mtl_trxs.quantity ) * func_tax_amt,

4978: r_jai_mtl_trxs.to_subinventory = p_transfer_subinventory THEN
4979:
4980: UPDATE jai_cmn_document_taxes
4981: SET tax_amt = ( p_line_quantity / r_jai_mtl_trxs.quantity ) * tax_amt,
4982: FUNC_TAX_AMT = ( p_line_quantity / r_jai_mtl_trxs.quantity ) * func_tax_amt,
4983: last_update_date = sysdate,
4984: last_updated_by = ln_user_id
4985: WHERE source_doc_id = p_header_id
4986: AND source_doc_line_id = p_line_id;

Line 4988: UPDATE jai_mtl_trxs

4984: last_updated_by = ln_user_id
4985: WHERE source_doc_id = p_header_id
4986: AND source_doc_line_id = p_line_id;
4987:
4988: UPDATE jai_mtl_trxs
4989: SET quantity = p_line_quantity,
4990: last_update_date = sysdate,
4991: last_updated_by = ln_user_id
4992: WHERE transaction_header_id = p_header_id

Line 5066: INSERT INTO jai_mtl_trxs(

5062: ln_vat_assessable_value := nvl(ln_vat_assessable_value,0) * p_line_quantity;
5063:
5064: -- copy(ln_vat_assessable_value,'MTL_TRX_LINE.VAT_ASSESSABLE_VALUE');
5065:
5066: INSERT INTO jai_mtl_trxs(
5067: transaction_id,
5068: transaction_header_id ,
5069: transaction_temp_id ,
5070: transaction_type_id ,

Line 5090: jai_mtl_trxs_s.nextval,

5086: last_update_date,
5087: last_updated_by,
5088: last_update_login
5089: ) VALUES (
5090: jai_mtl_trxs_s.nextval,
5091: p_header_id, -- :mtl_trx_line.transaction_header_id,
5092: p_line_id, -- :mtl_trx_line.transaction_temp_id,
5093: p_transaction_type_id, -- :mtl_trx_line.transaction_type_id,
5094: p_organization_id, -- :mtl_trx_line.organization_id,