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 360: -- , decode(source_document_code, 'RMA', jai_rcv_trx_processing_pkg.india_rma_receipt,

356: -- attribute5, Vijay Shankar for Bug#4346453. RCV DFF Elim. Enh.
357: vendor_id
358: -- Vijay Shankar for Bug#4346453. RCV DFF Elim. Enh. , upper(attribute_category) attribute_category
359: -- , source_document_code
360: -- , decode(source_document_code, 'RMA', jai_rcv_trx_processing_pkg.india_rma_receipt,
361: -- jai_rcv_trx_processing_pkg.india_receipt) attribute_category
362: from rcv_transactions
363: where transaction_id = cp_transaction_id;
364:

Line 361: -- jai_rcv_trx_processing_pkg.india_receipt) attribute_category

357: vendor_id
358: -- Vijay Shankar for Bug#4346453. RCV DFF Elim. Enh. , upper(attribute_category) attribute_category
359: -- , source_document_code
360: -- , decode(source_document_code, 'RMA', jai_rcv_trx_processing_pkg.india_rma_receipt,
361: -- jai_rcv_trx_processing_pkg.india_receipt) attribute_category
362: from rcv_transactions
363: where transaction_id = cp_transaction_id;
364:
365: cursor c_rcv_shipment_lines(cp_shipment_line_id number) is

Line 503: jai_rcv_trx_processing_pkg.get_accrue_on_receipt

499: --commented the above by Sanjikum for Bug#4474501
500:
501: p_codepath := jai_general_pkg.plot_codepath(4.12, p_codepath); /* 4.12 */
502: lv_accrue_on_receipt_flag :=
503: jai_rcv_trx_processing_pkg.get_accrue_on_receipt
504: (p_po_distribution_id => r_rcv_transactions.po_distribution_id,
505: -- added by Vijay Shankar for Bug#4215402
506: p_po_line_location_id => r_rcv_transactions.po_line_location_id
507: );

Line 1434: jai_rcv_trx_processing_pkg.get_apportion_factor(p_transaction_id);

1430:
1431: p_codepath := jai_general_pkg.plot_codepath(1, p_codepath, 'jai_rcv_rcv_rtv_pkg.get_tax_breakup', 'START'); /* 1 */
1432:
1433: ln_tax_apportion_factor :=
1434: jai_rcv_trx_processing_pkg.get_apportion_factor(p_transaction_id);
1435: --start additions by vkaranam for bug#10167393
1436: open c_ja_in_rcv_transactions(p_transaction_id);
1437: fetch c_ja_in_rcv_transactions into r_ja_in_rcv_transactions;
1438: close c_ja_in_rcv_transactions;

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

1509:
1510: /* apportionment for uom and quantity change wrt the parent RECEIVE
1511: line for which taxes exist */
1512: p_codepath := jai_general_pkg.plot_codepath(6, p_codepath); /* 6 */
1513: if nvl(cur_rec.currency, jai_rcv_trx_processing_pkg.gv_func_curr) <>
1514: jai_rcv_trx_processing_pkg.gv_func_curr
1515: then
1516: /* Tax not in functional currency, need to convert*/
1517: ln_tax_amount := ln_tax_amount * p_currency_conversion_rate;

Line 1514: jai_rcv_trx_processing_pkg.gv_func_curr

1510: /* apportionment for uom and quantity change wrt the parent RECEIVE
1511: line for which taxes exist */
1512: p_codepath := jai_general_pkg.plot_codepath(6, p_codepath); /* 6 */
1513: if nvl(cur_rec.currency, jai_rcv_trx_processing_pkg.gv_func_curr) <>
1514: jai_rcv_trx_processing_pkg.gv_func_curr
1515: then
1516: /* Tax not in functional currency, need to convert*/
1517: ln_tax_amount := ln_tax_amount * p_currency_conversion_rate;
1518: end if;

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

2810: ptr_jv(1).category_name := lv_category_name;
2811: ptr_jv(1).ccid := p_receiving_account_id;
2812: ptr_jv(1).entered_dr := round(ln_debit, gn_currency_precision);
2813: ptr_jv(1).entered_cr := round(ln_credit, gn_currency_precision);
2814: ptr_jv(1).currency_code := jai_rcv_trx_processing_pkg.gv_func_curr;
2815: ptr_jv(1).accounting_date := p_transaction_date;
2816: ptr_jv(1).reference_10 := lv_reference_10;
2817: ptr_jv(1).reference_23 := lv_reference_23;
2818: ptr_jv(1).reference_24 := lv_reference_24;

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

2948: ptr_jv(2).category_name := lv_category_name;
2949: ptr_jv(2).ccid := p_ap_accrual_account;/*6488406*/
2950: ptr_jv(2).entered_dr := round(ln_debit, gn_currency_precision);
2951: ptr_jv(2).entered_cr := round(ln_credit, gn_currency_precision);
2952: ptr_jv(2).currency_code := jai_rcv_trx_processing_pkg.gv_func_curr;
2953: ptr_jv(2).accounting_date := p_transaction_date;
2954: ptr_jv(2).reference_10 := lv_reference_10;
2955: ptr_jv(2).reference_23 := lv_reference_23;
2956: ptr_jv(2).reference_24 := lv_reference_24;

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

3038: ptr_jv(3).category_name := lv_category_name;
3039: ptr_jv(3).ccid := p_boe_account_id;
3040: ptr_jv(3).entered_dr := round(ln_debit, gn_currency_precision);
3041: ptr_jv(3).entered_cr := round(ln_credit, gn_currency_precision);
3042: ptr_jv(3).currency_code := jai_rcv_trx_processing_pkg.gv_func_curr;
3043: ptr_jv(3).accounting_date := p_transaction_date;
3044: ptr_jv(3).reference_10 := lv_reference_10;
3045: ptr_jv(3).reference_23 := lv_reference_23;
3046: ptr_jv(3).reference_24 := lv_reference_24;

Line 3092: ptr_jv(7).currency_code := jai_rcv_trx_processing_pkg.gv_func_curr;

3088: ptr_jv(7).category_name := lv_category_name;
3089: ptr_jv(7).ccid := ln_boe_account_id;
3090: ptr_jv(7).entered_dr := round(ln_debit, gn_currency_precision);
3091: ptr_jv(7).entered_cr := round(ln_credit, gn_currency_precision);
3092: ptr_jv(7).currency_code := jai_rcv_trx_processing_pkg.gv_func_curr;
3093: ptr_jv(7).accounting_date := p_transaction_date;
3094: ptr_jv(7).reference_10 := lv_reference_10;
3095: ptr_jv(7).reference_23 := lv_reference_23;
3096: ptr_jv(7).reference_24 := lv_reference_24;

Line 3129: ptr_jv(8).currency_code := jai_rcv_trx_processing_pkg.gv_func_curr;

3125: ptr_jv(8).category_name := lv_category_name;
3126: ptr_jv(8).ccid := ln_boe_account_id;
3127: ptr_jv(8).entered_dr := round(ln_debit, gn_currency_precision);
3128: ptr_jv(8).entered_cr := round(ln_credit, gn_currency_precision);
3129: ptr_jv(8).currency_code := jai_rcv_trx_processing_pkg.gv_func_curr;
3130: ptr_jv(8).accounting_date := p_transaction_date;
3131: ptr_jv(8).reference_10 := lv_reference_10;
3132: ptr_jv(8).reference_23 := lv_reference_23;
3133: ptr_jv(8).reference_24 := lv_reference_24;

Line 3167: ptr_jv(9).currency_code := jai_rcv_trx_processing_pkg.gv_func_curr;

3163: ptr_jv(9).category_name := lv_category_name;
3164: ptr_jv(9).ccid := ln_boe_account_id;
3165: ptr_jv(9).entered_dr := round(ln_debit, gn_currency_precision);
3166: ptr_jv(9).entered_cr := round(ln_credit, gn_currency_precision);
3167: ptr_jv(9).currency_code := jai_rcv_trx_processing_pkg.gv_func_curr;
3168: ptr_jv(9).accounting_date := p_transaction_date;
3169: ptr_jv(9).reference_10 := lv_reference_10;
3170: ptr_jv(9).reference_23 := lv_reference_23;
3171: ptr_jv(9).reference_24 := lv_reference_24;

Line 3204: ptr_jv(10).currency_code := jai_rcv_trx_processing_pkg.gv_func_curr;

3200: ptr_jv(10).category_name := lv_category_name;
3201: ptr_jv(10).ccid := ln_boe_account_id;
3202: ptr_jv(10).entered_dr := round(ln_debit, gn_currency_precision);
3203: ptr_jv(10).entered_cr := round(ln_credit, gn_currency_precision);
3204: ptr_jv(10).currency_code := jai_rcv_trx_processing_pkg.gv_func_curr;
3205: ptr_jv(10).accounting_date := p_transaction_date;
3206: ptr_jv(10).reference_10 := lv_reference_10;
3207: ptr_jv(10).reference_23 := lv_reference_23;
3208: ptr_jv(10).reference_24 := lv_reference_24;

Line 3244: ptr_jv(11).currency_code := jai_rcv_trx_processing_pkg.gv_func_curr;

3240: ptr_jv(11).category_name := lv_category_name;
3241: ptr_jv(11).ccid := ln_boe_account_id;
3242: ptr_jv(11).entered_dr := round(ln_debit, gn_currency_precision);
3243: ptr_jv(11).entered_cr := round(ln_credit, gn_currency_precision);
3244: ptr_jv(11).currency_code := jai_rcv_trx_processing_pkg.gv_func_curr;
3245: ptr_jv(11).accounting_date := p_transaction_date;
3246: ptr_jv(11).reference_10 := lv_reference_10;
3247: ptr_jv(11).reference_23 := lv_reference_23;
3248: ptr_jv(11).reference_24 := lv_reference_24;

Line 3280: ptr_jv(12).currency_code := jai_rcv_trx_processing_pkg.gv_func_curr;

3276: ptr_jv(12).category_name := lv_category_name;
3277: ptr_jv(12).ccid := ln_boe_account_id;
3278: ptr_jv(12).entered_dr := round(ln_debit, gn_currency_precision);
3279: ptr_jv(12).entered_cr := round(ln_credit, gn_currency_precision);
3280: ptr_jv(12).currency_code := jai_rcv_trx_processing_pkg.gv_func_curr;
3281: ptr_jv(12).accounting_date := p_transaction_date;
3282: ptr_jv(12).reference_10 := lv_reference_10;
3283: ptr_jv(12).reference_23 := lv_reference_23;
3284: ptr_jv(12).reference_24 := lv_reference_24;

Line 3317: ptr_jv(13).currency_code := jai_rcv_trx_processing_pkg.gv_func_curr;

3313: ptr_jv(13).category_name := lv_category_name;
3314: ptr_jv(13).ccid := ln_boe_account_id;
3315: ptr_jv(13).entered_dr := round(ln_debit, gn_currency_precision);
3316: ptr_jv(13).entered_cr := round(ln_credit, gn_currency_precision);
3317: ptr_jv(13).currency_code := jai_rcv_trx_processing_pkg.gv_func_curr;
3318: ptr_jv(13).accounting_date := p_transaction_date;
3319: ptr_jv(13).reference_10 := lv_reference_10;
3320: ptr_jv(13).reference_23 := lv_reference_23;
3321: ptr_jv(13).reference_24 := lv_reference_24;

Line 3354: ptr_jv(14).currency_code := jai_rcv_trx_processing_pkg.gv_func_curr;

3350: ptr_jv(14).category_name := lv_category_name;
3351: ptr_jv(14).ccid := ln_boe_account_id;
3352: ptr_jv(14).entered_dr := round(ln_debit, gn_currency_precision);
3353: ptr_jv(14).entered_cr := round(ln_credit, gn_currency_precision);
3354: ptr_jv(14).currency_code := jai_rcv_trx_processing_pkg.gv_func_curr;
3355: ptr_jv(14).accounting_date := p_transaction_date;
3356: ptr_jv(14).reference_10 := lv_reference_10;
3357: ptr_jv(14).reference_23 := lv_reference_23;
3358: ptr_jv(14).reference_24 := lv_reference_24;

Line 3390: ptr_jv(15).currency_code := jai_rcv_trx_processing_pkg.gv_func_curr;

3386: ptr_jv(15).category_name := lv_category_name;
3387: ptr_jv(15).ccid := ln_boe_account_id;
3388: ptr_jv(15).entered_dr := round(ln_debit, gn_currency_precision);
3389: ptr_jv(15).entered_cr := round(ln_credit, gn_currency_precision);
3390: ptr_jv(15).currency_code := jai_rcv_trx_processing_pkg.gv_func_curr;
3391: ptr_jv(15).accounting_date := p_transaction_date;
3392: ptr_jv(15).reference_10 := lv_reference_10;
3393: ptr_jv(15).reference_23 := lv_reference_23;
3394: ptr_jv(15).reference_24 := lv_reference_24;

Line 3427: ptr_jv(16).currency_code := jai_rcv_trx_processing_pkg.gv_func_curr;

3423: ptr_jv(16).category_name := lv_category_name;
3424: ptr_jv(16).ccid := ln_boe_account_id;
3425: ptr_jv(16).entered_dr := round(ln_debit, gn_currency_precision);
3426: ptr_jv(16).entered_cr := round(ln_credit, gn_currency_precision);
3427: ptr_jv(16).currency_code := jai_rcv_trx_processing_pkg.gv_func_curr;
3428: ptr_jv(16).accounting_date := p_transaction_date;
3429: ptr_jv(16).reference_10 := lv_reference_10;
3430: ptr_jv(16).reference_23 := lv_reference_23;
3431: ptr_jv(16).reference_24 := lv_reference_24;

Line 3464: ptr_jv(17).currency_code := jai_rcv_trx_processing_pkg.gv_func_curr;

3460: ptr_jv(17).category_name := lv_category_name;
3461: ptr_jv(17).ccid := ln_boe_account_id;
3462: ptr_jv(17).entered_dr := round(ln_debit, gn_currency_precision);
3463: ptr_jv(17).entered_cr := round(ln_credit, gn_currency_precision);
3464: ptr_jv(17).currency_code := jai_rcv_trx_processing_pkg.gv_func_curr;
3465: ptr_jv(17).accounting_date := p_transaction_date;
3466: ptr_jv(17).reference_10 := lv_reference_10;
3467: ptr_jv(17).reference_23 := lv_reference_23;
3468: ptr_jv(17).reference_24 := lv_reference_24;

Line 3502: ptr_jv(18).currency_code := jai_rcv_trx_processing_pkg.gv_func_curr;

3498: ptr_jv(18).category_name := lv_category_name;
3499: ptr_jv(18).ccid := ln_boe_account_id;
3500: ptr_jv(18).entered_dr := round(ln_debit, gn_currency_precision);
3501: ptr_jv(18).entered_cr := round(ln_credit, gn_currency_precision);
3502: ptr_jv(18).currency_code := jai_rcv_trx_processing_pkg.gv_func_curr;
3503: ptr_jv(18).accounting_date := p_transaction_date;
3504: ptr_jv(18).reference_10 := lv_reference_10;
3505: ptr_jv(18).reference_23 := lv_reference_23;
3506: ptr_jv(18).reference_24 := lv_reference_24;

Line 3539: ptr_jv(19).currency_code := jai_rcv_trx_processing_pkg.gv_func_curr;

3535: ptr_jv(19).category_name := lv_category_name;
3536: ptr_jv(19).ccid := ln_boe_account_id;
3537: ptr_jv(19).entered_dr := round(ln_debit, gn_currency_precision);
3538: ptr_jv(19).entered_cr := round(ln_credit, gn_currency_precision);
3539: ptr_jv(19).currency_code := jai_rcv_trx_processing_pkg.gv_func_curr;
3540: ptr_jv(19).accounting_date := p_transaction_date;
3541: ptr_jv(19).reference_10 := lv_reference_10;
3542: ptr_jv(19).reference_23 := lv_reference_23;
3543: ptr_jv(19).reference_24 := lv_reference_24;

Line 3577: ptr_jv(20).currency_code := jai_rcv_trx_processing_pkg.gv_func_curr;

3573: ptr_jv(20).category_name := lv_category_name;
3574: ptr_jv(20).ccid := ln_boe_account_id;
3575: ptr_jv(20).entered_dr := round(ln_debit, gn_currency_precision);
3576: ptr_jv(20).entered_cr := round(ln_credit, gn_currency_precision);
3577: ptr_jv(20).currency_code := jai_rcv_trx_processing_pkg.gv_func_curr;
3578: ptr_jv(20).accounting_date := p_transaction_date;
3579: ptr_jv(20).reference_10 := lv_reference_10;
3580: ptr_jv(20).reference_23 := lv_reference_23;
3581: ptr_jv(20).reference_24 := lv_reference_24;

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

3635: ptr_jv(4).category_name := lv_category_name;
3636: ptr_jv(4).ccid := p_rtv_expense_account_id;
3637: ptr_jv(4).entered_dr := round(ln_debit, gn_currency_precision);
3638: ptr_jv(4).entered_cr := round(ln_credit, gn_currency_precision);
3639: ptr_jv(4).currency_code := jai_rcv_trx_processing_pkg.gv_func_curr;
3640: ptr_jv(4).accounting_date := p_transaction_date;
3641: ptr_jv(4).reference_10 := lv_reference_10;
3642: ptr_jv(4).reference_23 := lv_reference_23;
3643: ptr_jv(4).reference_24 := lv_reference_24;

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

3703: ptr_jv(5).category_name := lv_category_name;
3704: ptr_jv(5).ccid := p_interorg_receivables_account;
3705: ptr_jv(5).entered_dr := round(ln_debit, gn_currency_precision);
3706: ptr_jv(5).entered_cr := round(ln_credit, gn_currency_precision);
3707: ptr_jv(5).currency_code := jai_rcv_trx_processing_pkg.gv_func_curr;
3708: ptr_jv(5).accounting_date := p_transaction_date;
3709: ptr_jv(5).reference_10 := lv_reference_10;
3710: ptr_jv(5).reference_23 := lv_reference_23;
3711: ptr_jv(5).reference_24 := lv_reference_24;

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

3736: ptr_jv(6).category_name := lv_category_name;
3737: ptr_jv(6).ccid := p_intransit_inv_account;
3738: ptr_jv(6).entered_dr := round(ln_debit, gn_currency_precision);
3739: ptr_jv(6).entered_cr := round(ln_credit, gn_currency_precision);
3740: ptr_jv(6).currency_code := jai_rcv_trx_processing_pkg.gv_func_curr;
3741: ptr_jv(6).accounting_date := p_transaction_date;
3742: ptr_jv(6).reference_10 := lv_reference_10;
3743: ptr_jv(6).reference_23 := lv_reference_23;
3744: ptr_jv(6).reference_24 := lv_reference_24;

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

3959: end if;
3960:
3961: lv_reference_26 := to_char(p_transaction_id);
3962:
3963: ln_tax_apportion_factor := jai_rcv_trx_processing_pkg.get_apportion_factor(p_transaction_id);
3964:
3965: open c_jai_regimes(p_regime_code);
3966: fetch c_jai_regimes into r_jai_regimes;
3967: close c_jai_regimes;

Line 4001: jai_rcv_trx_processing_pkg.gv_func_curr,

3997: lv_organization_type,
3998: ln_organization_id,
3999: ln_location_id,
4000: jai_constants.recovery_interim,
4001: jai_rcv_trx_processing_pkg.gv_func_curr,
4002: ln_tax_apportion_factor,
4003: p_currency_conversion_rate
4004: )
4005: loop

Line 4059: p_currency_code => jai_rcv_trx_processing_pkg.gv_func_curr,

4055: p_category_name => lv_category_name,
4056: p_code_combination_id => ln_regime_recovery_interim,
4057: p_entered_dr => ln_debit,
4058: p_entered_cr => ln_credit,
4059: p_currency_code => jai_rcv_trx_processing_pkg.gv_func_curr,
4060: p_accounting_date => p_transaction_date,
4061: p_reference_10 => lv_reference_10,
4062: p_reference_23 => lv_reference_23,
4063: p_reference_24 => lv_reference_24,

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

4077: ptr_jv(l_jv_line_num_generator).category_name := lv_category_name;
4078: ptr_jv(l_jv_line_num_generator).ccid := ln_regime_recovery_interim;
4079: ptr_jv(l_jv_line_num_generator).entered_dr := round(ln_debit, gn_currency_precision);
4080: ptr_jv(l_jv_line_num_generator).entered_cr := round(ln_credit, gn_currency_precision);
4081: ptr_jv(l_jv_line_num_generator).currency_code := jai_rcv_trx_processing_pkg.gv_func_curr;
4082: ptr_jv(l_jv_line_num_generator).accounting_date := p_transaction_date;
4083: ptr_jv(l_jv_line_num_generator).reference_10 := lv_reference_10;
4084: ptr_jv(l_jv_line_num_generator).reference_23 := lv_reference_23;
4085: ptr_jv(l_jv_line_num_generator).reference_24 := lv_reference_24;