DBA Data[Home] [Help]

APPS.JAI_RCV_DELIVER_RTR_PKG dependencies on JAI_RCV_TRX_PROCESSING_PKG

Line 228: jai_rcv_trx_processing_pkg.get_ancestor_id

224: lv_statement_id := '1';
225: ln_receive_trx_id := r_trx.tax_transaction_id;
226:
227: /* Vijay Shankar for Bug#4068823
228: jai_rcv_trx_processing_pkg.get_ancestor_id
229: (
230: p_transaction_id => r_trx.transaction_id,
231: p_shipment_line_id => r_trx.shipment_line_id,
232: p_required_trx_type => 'RECEIVE'

Line 273: ln_dlry_trx_id := jai_rcv_trx_processing_pkg.get_ancestor_id

269: (r_trx.transaction_type ='CORRECT' AND r_trx.parent_transaction_type IN ('DELIVER', 'RETURN TO RECEIVING')) or
270: r_trx.transaction_type = 'RETURN TO RECEIVING'
271: then
272: p_codepath := jai_general_pkg.plot_codepath(5.2, p_codepath);
273: ln_dlry_trx_id := jai_rcv_trx_processing_pkg.get_ancestor_id
274: (
275: r_trx.transaction_id,
276: r_trx.shipment_line_id,
277: 'DELIVER'

Line 344: ln_apportion_factor := jai_rcv_trx_processing_pkg.get_apportion_factor

340: lv_statement_id := '5';
341: p_codepath := jai_general_pkg.plot_codepath(9, p_codepath); /* 9 */
342:
343: /* Apportion Factor */
344: ln_apportion_factor := jai_rcv_trx_processing_pkg.get_apportion_factor
345: (p_transaction_id => r_trx.transaction_id);
346:
347: if lv_debug ='Y' then
348: fnd_file.put_line( fnd_file.log, '1.1 ln_apportion_factor ' || ln_apportion_factor );

Line 487: ln_dlry_trx_id := jai_rcv_trx_processing_pkg.get_ancestor_id

483: (r_trx.transaction_type ='CORRECT' AND r_trx.parent_transaction_type IN ('DELIVER', 'RETURN TO RECEIVING')) or
484: r_trx.transaction_type = 'RETURN TO RECEIVING'
485: then
486:
487: ln_dlry_trx_id := jai_rcv_trx_processing_pkg.get_ancestor_id
488: (
489: r_trx.transaction_id,
490: r_trx.shipment_line_id,
491: 'DELIVER'

Line 776: * decode(nvl(rtl.currency, jai_rcv_trx_processing_pkg.gv_func_curr), jai_rcv_trx_processing_pkg.gv_func_curr, 1, p_currency_conversion_rate)

772: (
773: SELECT
774: sum(
775: rtl.tax_amount * (NVL(jtc.mod_cr_percentage, 0)/100)
776: * decode(nvl(rtl.currency, jai_rcv_trx_processing_pkg.gv_func_curr), jai_rcv_trx_processing_pkg.gv_func_curr, 1, p_currency_conversion_rate)
777: ) tax_amount,
778: jtc.tax_account_id
779: FROM JAI_RCV_LINE_TAXES rtl,
780: JAI_CMN_TAXES_ALL jtc

Line 852: p_currency_code => jai_rcv_trx_processing_pkg.gv_func_curr,

848: p_category_name => lv_category,
849: p_code_combination_id => tax_rec.tax_account_id,
850: p_entered_dr => ln_debit_amount,
851: p_entered_cr => ln_credit_amount,
852: p_currency_code => jai_rcv_trx_processing_pkg.gv_func_curr,
853: p_accounting_date => p_transaction_date,
854: p_reference_10 => lv_reference_10_desc, --Reference10
855: p_reference_23 => lv_reference23,
856: p_reference_24 => lv_reference24,

Line 908: p_currency_code => jai_rcv_trx_processing_pkg.gv_func_curr,

904: p_category_name => lv_category,
905: p_code_combination_id => p_receiving_account_id,
906: p_entered_dr => ln_debit_amount,
907: p_entered_cr => ln_credit_amount,
908: p_currency_code => jai_rcv_trx_processing_pkg.gv_func_curr,
909: p_accounting_date => p_transaction_date,
910: p_reference_10 => lv_reference_10_desc, --Reference10
911: p_reference_23 => lv_reference23,
912: p_reference_24 => lv_reference24,

Line 1006: if tax_rec.currency <> jai_rcv_trx_processing_pkg.gv_func_curr THEN

1002: )
1003: LOOP
1004:
1005: p_codepath := jai_general_pkg.plot_codepath(2, p_codepath); /* 2*/
1006: if tax_rec.currency <> jai_rcv_trx_processing_pkg.gv_func_curr THEN
1007: ln_conv_factor := NVL(p_curr_conv_rate, 1);
1008: p_codepath := jai_general_pkg.plot_codepath(3, p_codepath); /* 3*/
1009: ELSE
1010: ln_conv_factor := 1;

Line 1335: ln_apportion_factor := jai_rcv_trx_processing_pkg.get_apportion_factor

1331: /* above cost calculation is modified as belowe by Vijay Shankar for Bug#4229164 */
1332:
1333: /* Bug 7581494 : Porting Bug 6905807 from 120.2.12000000.5 to 12.1 Branch */
1334: ln_costing_amount := p_costing_amount / p_currency_conversion_rate;
1335: ln_apportion_factor := jai_rcv_trx_processing_pkg.get_apportion_factor
1336: ( p_transaction_id => p_transaction_id);
1337: ln_opm_costing_amount := p_costing_amount * ln_apportion_factor ;
1338:
1339: /* End Bug 7581494 : Porting Bug 6905807 from 120.2.12000000.5 to 12.1 Branch.*/

Line 1371: p_currency_code => jai_rcv_trx_processing_pkg.gv_func_curr,

1367: p_category_name => lv_category,
1368: p_code_combination_id => p_receiving_account_id,
1369: p_entered_dr => NULL,
1370: p_entered_cr => ln_opm_costing_amount,
1371: p_currency_code => jai_rcv_trx_processing_pkg.gv_func_curr,
1372: p_accounting_date => p_transaction_date,
1373: p_reference_10 => NULL,
1374: p_reference_23 => NULL,
1375: p_reference_24 => NULL,

Line 1416: p_currency_code => jai_rcv_trx_processing_pkg.gv_func_curr,

1412: p_category_name => lv_category,
1413: p_code_combination_id => ln_material_account_id,
1414: p_entered_dr => ln_opm_costing_amount,
1415: p_entered_cr => NULL,
1416: p_currency_code => jai_rcv_trx_processing_pkg.gv_func_curr,
1417: p_accounting_date => p_transaction_date,
1418: p_reference_10 => NULL,
1419: p_reference_23 => NULL,
1420: p_reference_24 => NULL,

Line 1588: p_currency_code => jai_rcv_trx_processing_pkg.gv_func_curr,

1584: p_category_name => lv_category,
1585: p_code_combination_id => p_receiving_account_id,
1586: p_entered_dr => ln_debit_amount,
1587: p_entered_cr => ln_credit_amount,
1588: p_currency_code => jai_rcv_trx_processing_pkg.gv_func_curr,
1589: p_accounting_date => p_transaction_date,
1590: p_reference_10 => lv_reference_10_desc || p_receipt_num ||lv_reference_10_desc1 ||p_transaction_type, --Reference10
1591: p_reference_23 => lv_reference23,
1592: p_reference_24 => lv_reference24,

Line 1635: p_currency_code => jai_rcv_trx_processing_pkg.gv_func_curr,

1631: p_category_name => lv_category,
1632: p_code_combination_id => ln_expense_account,
1633: p_entered_dr => ln_debit_amount,
1634: p_entered_cr => ln_credit_amount,
1635: p_currency_code => jai_rcv_trx_processing_pkg.gv_func_curr,
1636: p_accounting_date => p_transaction_date,
1637: p_reference_10 => lv_reference_10_desc || p_receipt_num ||lv_reference_10_desc1 ||p_transaction_type, --Reference10
1638: p_reference_23 => lv_reference23,
1639: p_reference_24 => lv_reference24,

Line 1806: p_currency_code => jai_rcv_trx_processing_pkg.gv_func_curr,

1802: p_category_name => lv_category,
1803: p_code_combination_id => p_receiving_account_id,
1804: p_entered_dr => NULL, /* This should never be changed to Zero */
1805: p_entered_cr => ln_costing_amount,
1806: p_currency_code => jai_rcv_trx_processing_pkg.gv_func_curr,
1807: p_accounting_date => p_transaction_date,
1808: p_reference_10 => NULL,
1809: p_reference_23 => NULL,
1810: p_reference_24 => NULL,

Line 1840: p_currency_code => jai_rcv_trx_processing_pkg.gv_func_curr,

1836: p_category_name => lv_category,
1837: p_code_combination_id => ln_material_account_id,
1838: p_entered_dr => ln_costing_amount,
1839: p_entered_cr => NULL, /* This should never be changed to Zero */
1840: p_currency_code => jai_rcv_trx_processing_pkg.gv_func_curr,
1841: p_accounting_date => p_transaction_date,
1842: p_reference_10 => NULL,
1843: p_reference_23 => NULL,
1844: p_reference_24 => NULL,

Line 1994: p_currency_code => jai_rcv_trx_processing_pkg.gv_func_curr,

1990: p_category_name => lv_category,
1991: p_code_combination_id => p_receiving_account_id,
1992: p_entered_dr => ln_debit_amount,
1993: p_entered_cr => ln_credit_amount,
1994: p_currency_code => jai_rcv_trx_processing_pkg.gv_func_curr,
1995: p_accounting_date => p_transaction_date,
1996: p_reference_10 => NULL,
1997: p_reference_23 => 'jai_rcv_deliver_rtr_pkg.standard_costing', --rchandan for bug#4473022
1998: p_reference_24 => 'rcv_transactions', --rchandan for bug#4473022

Line 2042: p_currency_code => jai_rcv_trx_processing_pkg.gv_func_curr,

2038: p_category_name => lv_category,
2039: p_code_combination_id => ln_ppv_account_id,
2040: p_entered_dr => ln_debit_amount,
2041: p_entered_cr => ln_credit_amount,
2042: p_currency_code => jai_rcv_trx_processing_pkg.gv_func_curr,
2043: p_accounting_date => p_transaction_date,
2044: p_reference_10 => NULL,
2045: p_reference_23 => 'jai_rcv_deliver_rtr_pkg.standard_costing', --rchandan for bug#4473022
2046: p_reference_24 => 'rcv_transactions', --rchandan for bug#4473022

Line 2472: ln_dlry_trx_id := jai_rcv_trx_processing_pkg.get_ancestor_id

2468:
2469: IF lv_transaction_type = 'RETURN TO RECEIVING' THEN
2470:
2471: p_codepath := jai_general_pkg.plot_codepath(4, p_codepath); /* 4 */
2472: ln_dlry_trx_id := jai_rcv_trx_processing_pkg.get_ancestor_id
2473: ( r_trx.transaction_id, r_trx.shipment_line_id, 'DELIVER');
2474:
2475: p_codepath := jai_general_pkg.plot_codepath(5, p_codepath); /* 5 */
2476: OPEN c_trx(ln_dlry_trx_id);

Line 2790: ln_rcv_trx_id := jai_rcv_trx_processing_pkg.get_ancestor_id

2786: OPEN c_trx;
2787: FETCH c_trx INTO r_trx;
2788: CLOSE c_trx;
2789:
2790: ln_rcv_trx_id := jai_rcv_trx_processing_pkg.get_ancestor_id
2791: (
2792: r_trx.transaction_id,
2793: r_trx.shipment_line_id,
2794: 'RECEIVE'