DBA Data[Home] [Help]

APPS.JAI_RCV_DELIVER_RTR_PKG dependencies on JAI_RCV_TRX_PROCESSING_PKG

Line 197: jai_rcv_trx_processing_pkg.get_ancestor_id

193: lv_statement_id := '1';
194: ln_receive_trx_id := r_trx.tax_transaction_id;
195:
196: /* Vijay Shankar for Bug#4068823
197: jai_rcv_trx_processing_pkg.get_ancestor_id
198: (
199: p_transaction_id => r_trx.transaction_id,
200: p_shipment_line_id => r_trx.shipment_line_id,
201: p_required_trx_type => 'RECEIVE'

Line 267: ln_apportion_factor := jai_rcv_trx_processing_pkg.get_apportion_factor

263: lv_statement_id := '5';
264: p_codepath := jai_general_pkg.plot_codepath(9, p_codepath); /* 9 */
265:
266: /* Apportion Factor */
267: ln_apportion_factor := jai_rcv_trx_processing_pkg.get_apportion_factor
268: (p_transaction_id => r_trx.transaction_id);
269:
270: if lv_debug ='Y' then
271: fnd_file.put_line( fnd_file.log, '1.1 ln_apportion_factor ' || ln_apportion_factor );

Line 410: ln_dlry_trx_id := jai_rcv_trx_processing_pkg.get_ancestor_id

406: (r_trx.transaction_type ='CORRECT' AND r_trx.parent_transaction_type IN ('DELIVER', 'RETURN TO RECEIVING')) or
407: r_trx.transaction_type = 'RETURN TO RECEIVING'
408: then
409:
410: ln_dlry_trx_id := jai_rcv_trx_processing_pkg.get_ancestor_id
411: (
412: r_trx.transaction_id,
413: r_trx.shipment_line_id,
414: 'DELIVER'

Line 689: * 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)

685: (
686: SELECT
687: sum(
688: rtl.tax_amount * (NVL(jtc.mod_cr_percentage, 0)/100)
689: * 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)
690: ) tax_amount,
691: jtc.tax_account_id
692: FROM JAI_RCV_LINE_TAXES rtl,
693: JAI_CMN_TAXES_ALL jtc

Line 757: p_currency_code => jai_rcv_trx_processing_pkg.gv_func_curr,

753: p_category_name => lv_category,
754: p_code_combination_id => tax_rec.tax_account_id,
755: p_entered_dr => ln_debit_amount,
756: p_entered_cr => ln_credit_amount,
757: p_currency_code => jai_rcv_trx_processing_pkg.gv_func_curr,
758: p_accounting_date => p_transaction_date,
759: p_reference_10 => lv_reference_10_desc, --Reference10
760: p_reference_23 => lv_reference23,
761: p_reference_24 => lv_reference24,

Line 813: p_currency_code => jai_rcv_trx_processing_pkg.gv_func_curr,

809: p_category_name => lv_category,
810: p_code_combination_id => p_receiving_account_id,
811: p_entered_dr => ln_debit_amount,
812: p_entered_cr => ln_credit_amount,
813: p_currency_code => jai_rcv_trx_processing_pkg.gv_func_curr,
814: p_accounting_date => p_transaction_date,
815: p_reference_10 => lv_reference_10_desc, --Reference10
816: p_reference_23 => lv_reference23,
817: p_reference_24 => lv_reference24,

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

905: )
906: LOOP
907:
908: p_codepath := jai_general_pkg.plot_codepath(2, p_codepath); /* 2*/
909: if tax_rec.currency <> jai_rcv_trx_processing_pkg.gv_func_curr THEN
910: ln_conv_factor := NVL(p_curr_conv_rate, 1);
911: p_codepath := jai_general_pkg.plot_codepath(3, p_codepath); /* 3*/
912: ELSE
913: ln_conv_factor := 1;

Line 1185: ln_apportion_factor := jai_rcv_trx_processing_pkg.get_apportion_factor

1181: /* above cost calculation is modified as belowe by Vijay Shankar for Bug#4229164 */
1182:
1183: /* Bug 7581494 : Porting Bug 6905807 from 120.2.12000000.5 to 12.1 Branch */
1184: ln_costing_amount := p_costing_amount / p_currency_conversion_rate;
1185: ln_apportion_factor := jai_rcv_trx_processing_pkg.get_apportion_factor
1186: ( p_transaction_id => p_transaction_id);
1187: ln_opm_costing_amount := p_costing_amount * ln_apportion_factor ;
1188:
1189: /* End Bug 7581494 : Porting Bug 6905807 from 120.2.12000000.5 to 12.1 Branch.*/

Line 1217: p_currency_code => jai_rcv_trx_processing_pkg.gv_func_curr,

1213: /* Bug 7581494 : Porting Bug 6905807 from 120.2.12000000.5 to 12.1 Branch
1214: * Changed from ln_costing_amount to ln_opm_costing_amount.
1215: */
1216: p_entered_cr => ln_opm_costing_amount,
1217: p_currency_code => jai_rcv_trx_processing_pkg.gv_func_curr,
1218: p_accounting_date => p_transaction_date,
1219: p_reference_10 => NULL,
1220: p_reference_23 => NULL,
1221: p_reference_24 => NULL,

Line 1256: p_currency_code => jai_rcv_trx_processing_pkg.gv_func_curr,

1252: * Changed from ln_costing_amount to ln_opm_costing_amount.
1253: */
1254: p_entered_dr => ln_opm_costing_amount,
1255: p_entered_cr => NULL, /* This should never be changed to Zero */
1256: p_currency_code => jai_rcv_trx_processing_pkg.gv_func_curr,
1257: p_accounting_date => p_transaction_date,
1258: p_reference_10 => NULL,
1259: p_reference_23 => NULL,
1260: p_reference_24 => NULL,

Line 1424: p_currency_code => jai_rcv_trx_processing_pkg.gv_func_curr,

1420: p_category_name => lv_category,
1421: p_code_combination_id => p_receiving_account_id,
1422: p_entered_dr => ln_debit_amount,
1423: p_entered_cr => ln_credit_amount,
1424: p_currency_code => jai_rcv_trx_processing_pkg.gv_func_curr,
1425: p_accounting_date => p_transaction_date,
1426: p_reference_10 => lv_reference_10_desc || p_receipt_num ||lv_reference_10_desc1 ||p_transaction_type, --Reference10
1427: p_reference_23 => lv_reference23,
1428: p_reference_24 => lv_reference24,

Line 1471: p_currency_code => jai_rcv_trx_processing_pkg.gv_func_curr,

1467: p_category_name => lv_category,
1468: p_code_combination_id => ln_expense_account,
1469: p_entered_dr => ln_debit_amount,
1470: p_entered_cr => ln_credit_amount,
1471: p_currency_code => jai_rcv_trx_processing_pkg.gv_func_curr,
1472: p_accounting_date => p_transaction_date,
1473: p_reference_10 => lv_reference_10_desc || p_receipt_num ||lv_reference_10_desc1 ||p_transaction_type, --Reference10
1474: p_reference_23 => lv_reference23,
1475: p_reference_24 => lv_reference24,

Line 1642: p_currency_code => jai_rcv_trx_processing_pkg.gv_func_curr,

1638: p_category_name => lv_category,
1639: p_code_combination_id => p_receiving_account_id,
1640: p_entered_dr => NULL, /* This should never be changed to Zero */
1641: p_entered_cr => ln_costing_amount,
1642: p_currency_code => jai_rcv_trx_processing_pkg.gv_func_curr,
1643: p_accounting_date => p_transaction_date,
1644: p_reference_10 => NULL,
1645: p_reference_23 => NULL,
1646: p_reference_24 => NULL,

Line 1676: p_currency_code => jai_rcv_trx_processing_pkg.gv_func_curr,

1672: p_category_name => lv_category,
1673: p_code_combination_id => ln_material_account_id,
1674: p_entered_dr => ln_costing_amount,
1675: p_entered_cr => NULL, /* This should never be changed to Zero */
1676: p_currency_code => jai_rcv_trx_processing_pkg.gv_func_curr,
1677: p_accounting_date => p_transaction_date,
1678: p_reference_10 => NULL,
1679: p_reference_23 => NULL,
1680: p_reference_24 => NULL,

Line 1830: p_currency_code => jai_rcv_trx_processing_pkg.gv_func_curr,

1826: p_category_name => lv_category,
1827: p_code_combination_id => p_receiving_account_id,
1828: p_entered_dr => ln_debit_amount,
1829: p_entered_cr => ln_credit_amount,
1830: p_currency_code => jai_rcv_trx_processing_pkg.gv_func_curr,
1831: p_accounting_date => p_transaction_date,
1832: p_reference_10 => NULL,
1833: p_reference_23 => 'jai_rcv_deliver_rtr_pkg.standard_costing', --rchandan for bug#4473022
1834: p_reference_24 => 'rcv_transactions', --rchandan for bug#4473022

Line 1878: p_currency_code => jai_rcv_trx_processing_pkg.gv_func_curr,

1874: p_category_name => lv_category,
1875: p_code_combination_id => ln_ppv_account_id,
1876: p_entered_dr => ln_debit_amount,
1877: p_entered_cr => ln_credit_amount,
1878: p_currency_code => jai_rcv_trx_processing_pkg.gv_func_curr,
1879: p_accounting_date => p_transaction_date,
1880: p_reference_10 => NULL,
1881: p_reference_23 => 'jai_rcv_deliver_rtr_pkg.standard_costing', --rchandan for bug#4473022
1882: p_reference_24 => 'rcv_transactions', --rchandan for bug#4473022

Line 2308: ln_dlry_trx_id := jai_rcv_trx_processing_pkg.get_ancestor_id

2304:
2305: IF lv_transaction_type = 'RETURN TO RECEIVING' THEN
2306:
2307: p_codepath := jai_general_pkg.plot_codepath(4, p_codepath); /* 4 */
2308: ln_dlry_trx_id := jai_rcv_trx_processing_pkg.get_ancestor_id
2309: ( r_trx.transaction_id, r_trx.shipment_line_id, 'DELIVER');
2310:
2311: p_codepath := jai_general_pkg.plot_codepath(5, p_codepath); /* 5 */
2312: OPEN c_trx(ln_dlry_trx_id);