DBA Data[Home] [Help]

APPS.JAI_RCV_RCV_RTV_PKG dependencies on JAI_RCV_TRX_PROCESSING_PKG

Line 82: jai_rcv_trx_processing_pkg.get_accrue_on_receipt function

78: 03-Mar-2005 Vijay Shankar for Bug#4215402, Version:115.3
79: po_distribution_id is populated as null in rcv_Transactions for non inventory items.
80: so to get accrue_on_receipt_flag from PO, we need line_location_id instead of
81: po_distribution_id. So changes are made to pass line_location_id also to
82: jai_rcv_trx_processing_pkg.get_accrue_on_receipt function
83:
84:
85: 19/03/2005 Vijay Shankar for Bug#4250236(4245089). FileVersion: 116.0(115.5)
86: .Modified regime_tax_accounting_interim to work for any regime taxes based on regime setup

Line 284: -- , decode(source_document_code, 'RMA', jai_rcv_trx_processing_pkg.india_rma_receipt,

280: -- attribute5, Vijay Shankar for Bug#4346453. RCV DFF Elim. Enh.
281: vendor_id
282: -- Vijay Shankar for Bug#4346453. RCV DFF Elim. Enh. , upper(attribute_category) attribute_category
283: -- , source_document_code
284: -- , decode(source_document_code, 'RMA', jai_rcv_trx_processing_pkg.india_rma_receipt,
285: -- jai_rcv_trx_processing_pkg.india_receipt) attribute_category
286: from rcv_transactions
287: where transaction_id = cp_transaction_id;
288:

Line 285: -- jai_rcv_trx_processing_pkg.india_receipt) attribute_category

281: vendor_id
282: -- Vijay Shankar for Bug#4346453. RCV DFF Elim. Enh. , upper(attribute_category) attribute_category
283: -- , source_document_code
284: -- , decode(source_document_code, 'RMA', jai_rcv_trx_processing_pkg.india_rma_receipt,
285: -- jai_rcv_trx_processing_pkg.india_receipt) attribute_category
286: from rcv_transactions
287: where transaction_id = cp_transaction_id;
288:
289: cursor c_rcv_shipment_lines(cp_shipment_line_id number) is

Line 414: jai_rcv_trx_processing_pkg.get_accrue_on_receipt

410: --commented the above by Sanjikum for Bug#4474501
411:
412: p_codepath := jai_general_pkg.plot_codepath(4.12, p_codepath); /* 4.12 */
413: lv_accrue_on_receipt_flag :=
414: jai_rcv_trx_processing_pkg.get_accrue_on_receipt
415: (p_po_distribution_id => r_rcv_transactions.po_distribution_id,
416: -- added by Vijay Shankar for Bug#4215402
417: p_po_line_location_id => r_rcv_transactions.po_line_location_id
418: );

Line 1248: jai_rcv_trx_processing_pkg.get_apportion_factor(p_transaction_id);

1244:
1245: p_codepath := jai_general_pkg.plot_codepath(1, p_codepath, 'jai_rcv_rcv_rtv_pkg.get_tax_breakup', 'START'); /* 1 */
1246:
1247: ln_tax_apportion_factor :=
1248: jai_rcv_trx_processing_pkg.get_apportion_factor(p_transaction_id);
1249:
1250: p_codepath := jai_general_pkg.plot_codepath(2, p_codepath); /* 2 */
1251: p_all_taxes := 0;
1252: p_tds_taxes := 0;

Line 1293: if nvl(cur_rec.currency, jai_rcv_trx_processing_pkg.gv_func_curr) <>

1289: ln_tax_amount := ln_tax_amount * ln_tax_apportion_factor;
1290: /* apportionment for uom and quantity change wrt the parent RECEIVE
1291: line for which taxes exist */
1292: p_codepath := jai_general_pkg.plot_codepath(6, p_codepath); /* 6 */
1293: if nvl(cur_rec.currency, jai_rcv_trx_processing_pkg.gv_func_curr) <>
1294: jai_rcv_trx_processing_pkg.gv_func_curr
1295: then
1296: /* Tax not in functional currency, need to convert*/
1297: ln_tax_amount := ln_tax_amount * p_currency_conversion_rate;

Line 1294: jai_rcv_trx_processing_pkg.gv_func_curr

1290: /* apportionment for uom and quantity change wrt the parent RECEIVE
1291: line for which taxes exist */
1292: p_codepath := jai_general_pkg.plot_codepath(6, p_codepath); /* 6 */
1293: if nvl(cur_rec.currency, jai_rcv_trx_processing_pkg.gv_func_curr) <>
1294: jai_rcv_trx_processing_pkg.gv_func_curr
1295: then
1296: /* Tax not in functional currency, need to convert*/
1297: ln_tax_amount := ln_tax_amount * p_currency_conversion_rate;
1298: end if;

Line 2449: ptr_jv(1).currency_code := jai_rcv_trx_processing_pkg.gv_func_curr;

2445: ptr_jv(1).category_name := lv_category_name;
2446: ptr_jv(1).ccid := p_receiving_account_id;
2447: ptr_jv(1).entered_dr := round(ln_debit, gn_currency_precision);
2448: ptr_jv(1).entered_cr := round(ln_credit, gn_currency_precision);
2449: ptr_jv(1).currency_code := jai_rcv_trx_processing_pkg.gv_func_curr;
2450: ptr_jv(1).accounting_date := p_transaction_date;
2451: ptr_jv(1).reference_10 := lv_reference_10;
2452: ptr_jv(1).reference_23 := lv_reference_23;
2453: ptr_jv(1).reference_24 := lv_reference_24;

Line 2557: ptr_jv(2).currency_code := jai_rcv_trx_processing_pkg.gv_func_curr;

2553: ptr_jv(2).category_name := lv_category_name;
2554: ptr_jv(2).ccid := p_ap_accrual_account;/*6488406*/
2555: ptr_jv(2).entered_dr := round(ln_debit, gn_currency_precision);
2556: ptr_jv(2).entered_cr := round(ln_credit, gn_currency_precision);
2557: ptr_jv(2).currency_code := jai_rcv_trx_processing_pkg.gv_func_curr;
2558: ptr_jv(2).accounting_date := p_transaction_date;
2559: ptr_jv(2).reference_10 := lv_reference_10;
2560: ptr_jv(2).reference_23 := lv_reference_23;
2561: ptr_jv(2).reference_24 := lv_reference_24;

Line 2645: ptr_jv(3).currency_code := jai_rcv_trx_processing_pkg.gv_func_curr;

2641: ptr_jv(3).category_name := lv_category_name;
2642: ptr_jv(3).ccid := p_boe_account_id;
2643: ptr_jv(3).entered_dr := round(ln_debit, gn_currency_precision);
2644: ptr_jv(3).entered_cr := round(ln_credit, gn_currency_precision);
2645: ptr_jv(3).currency_code := jai_rcv_trx_processing_pkg.gv_func_curr;
2646: ptr_jv(3).accounting_date := p_transaction_date;
2647: ptr_jv(3).reference_10 := lv_reference_10;
2648: ptr_jv(3).reference_23 := lv_reference_23;
2649: ptr_jv(3).reference_24 := lv_reference_24;

Line 2708: ptr_jv(4).currency_code := jai_rcv_trx_processing_pkg.gv_func_curr;

2704: ptr_jv(4).category_name := lv_category_name;
2705: ptr_jv(4).ccid := p_rtv_expense_account_id;
2706: ptr_jv(4).entered_dr := round(ln_debit, gn_currency_precision);
2707: ptr_jv(4).entered_cr := round(ln_credit, gn_currency_precision);
2708: ptr_jv(4).currency_code := jai_rcv_trx_processing_pkg.gv_func_curr;
2709: ptr_jv(4).accounting_date := p_transaction_date;
2710: ptr_jv(4).reference_10 := lv_reference_10;
2711: ptr_jv(4).reference_23 := lv_reference_23;
2712: ptr_jv(4).reference_24 := lv_reference_24;

Line 2776: ptr_jv(5).currency_code := jai_rcv_trx_processing_pkg.gv_func_curr;

2772: ptr_jv(5).category_name := lv_category_name;
2773: ptr_jv(5).ccid := p_interorg_receivables_account;
2774: ptr_jv(5).entered_dr := round(ln_debit, gn_currency_precision);
2775: ptr_jv(5).entered_cr := round(ln_credit, gn_currency_precision);
2776: ptr_jv(5).currency_code := jai_rcv_trx_processing_pkg.gv_func_curr;
2777: ptr_jv(5).accounting_date := p_transaction_date;
2778: ptr_jv(5).reference_10 := lv_reference_10;
2779: ptr_jv(5).reference_23 := lv_reference_23;
2780: ptr_jv(5).reference_24 := lv_reference_24;

Line 2809: ptr_jv(6).currency_code := jai_rcv_trx_processing_pkg.gv_func_curr;

2805: ptr_jv(6).category_name := lv_category_name;
2806: ptr_jv(6).ccid := p_intransit_inv_account;
2807: ptr_jv(6).entered_dr := round(ln_debit, gn_currency_precision);
2808: ptr_jv(6).entered_cr := round(ln_credit, gn_currency_precision);
2809: ptr_jv(6).currency_code := jai_rcv_trx_processing_pkg.gv_func_curr;
2810: ptr_jv(6).accounting_date := p_transaction_date;
2811: ptr_jv(6).reference_10 := lv_reference_10;
2812: ptr_jv(6).reference_23 := lv_reference_23;
2813: ptr_jv(6).reference_24 := lv_reference_24;

Line 3027: ln_tax_apportion_factor := jai_rcv_trx_processing_pkg.get_apportion_factor(p_transaction_id);

3023: end if;
3024:
3025: lv_reference_26 := to_char(p_transaction_id);
3026:
3027: ln_tax_apportion_factor := jai_rcv_trx_processing_pkg.get_apportion_factor(p_transaction_id);
3028:
3029: open c_jai_regimes(p_regime_code);
3030: fetch c_jai_regimes into r_jai_regimes;
3031: close c_jai_regimes;

Line 3065: jai_rcv_trx_processing_pkg.gv_func_curr,

3061: lv_organization_type,
3062: ln_organization_id,
3063: ln_location_id,
3064: jai_constants.recovery_interim,
3065: jai_rcv_trx_processing_pkg.gv_func_curr,
3066: ln_tax_apportion_factor,
3067: p_currency_conversion_rate
3068: )
3069: loop

Line 3123: p_currency_code => jai_rcv_trx_processing_pkg.gv_func_curr,

3119: p_category_name => lv_category_name,
3120: p_code_combination_id => ln_regime_recovery_interim,
3121: p_entered_dr => ln_debit,
3122: p_entered_cr => ln_credit,
3123: p_currency_code => jai_rcv_trx_processing_pkg.gv_func_curr,
3124: p_accounting_date => p_transaction_date,
3125: p_reference_10 => lv_reference_10,
3126: p_reference_23 => lv_reference_23,
3127: p_reference_24 => lv_reference_24,

Line 3145: ptr_jv(l_jv_line_num_generator).currency_code := jai_rcv_trx_processing_pkg.gv_func_curr;

3141: ptr_jv(l_jv_line_num_generator).category_name := lv_category_name;
3142: ptr_jv(l_jv_line_num_generator).ccid := ln_regime_recovery_interim;
3143: ptr_jv(l_jv_line_num_generator).entered_dr := round(ln_debit, gn_currency_precision);
3144: ptr_jv(l_jv_line_num_generator).entered_cr := round(ln_credit, gn_currency_precision);
3145: ptr_jv(l_jv_line_num_generator).currency_code := jai_rcv_trx_processing_pkg.gv_func_curr;
3146: ptr_jv(l_jv_line_num_generator).accounting_date := p_transaction_date;
3147: ptr_jv(l_jv_line_num_generator).reference_10 := lv_reference_10;
3148: ptr_jv(l_jv_line_num_generator).reference_23 := lv_reference_23;
3149: ptr_jv(l_jv_line_num_generator).reference_24 := lv_reference_24;