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.AP_ETAX_UTILITY_PKG dependencies on AP_UTILITIES_PKG

Line 1575: l_period_name := AP_UTILITIES_PKG.get_current_gl_date (P_Invoice_Header_Rec.gl_date, P_Invoice_header_Rec.org_id);

1571: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,l_debug_info);
1572: END IF;
1573: -------------------------------------------------------------------
1574:
1575: l_period_name := AP_UTILITIES_PKG.get_current_gl_date (P_Invoice_Header_Rec.gl_date, P_Invoice_header_Rec.org_id);
1576:
1577: IF (l_period_name IS NULL) THEN
1578: AP_UTILITIES_PKG.get_open_gl_date(
1579: P_Date => P_Invoice_Header_Rec.gl_date,

Line 1578: AP_UTILITIES_PKG.get_open_gl_date(

1574:
1575: l_period_name := AP_UTILITIES_PKG.get_current_gl_date (P_Invoice_Header_Rec.gl_date, P_Invoice_header_Rec.org_id);
1576:
1577: IF (l_period_name IS NULL) THEN
1578: AP_UTILITIES_PKG.get_open_gl_date(
1579: P_Date => P_Invoice_Header_Rec.gl_date,
1580: P_Period_Name => l_period_name,
1581: P_GL_Date => l_gl_date,
1582: P_Org_Id => P_Invoice_Header_Rec.org_id);

Line 2470: ap_utilities_pkg.get_gl_period_name(zd.gl_date,ai.org_id) period_name,

2466: -- conditions are met before inserting the tax distribution.
2467: DECODE(NVL(zd.recoverable_flag, 'N'),
2468: 'Y', 'REC_TAX',
2469: 'N', 'NONREC_TAX') line_type_lookup_code,
2470: ap_utilities_pkg.get_gl_period_name(zd.gl_date,ai.org_id) period_name,
2471: -- included the decode as part of the prepayment changes.
2472: -- since for prepayment tax variances will not be created,
2473: -- the dist amount should be the total including variances
2474: -- bug 8317515: modify start

Line 2487: ap_utilities_pkg.ap_round_currency(

2483: nvl(zd.ref_doc_per_unit_nrec_tax_amt,0), zd.per_trx_curr_unit_nr_amt,
2484: zd.ref_per_trx_curr_unit_nr_amt, zd.price_diff, parent_tax_line.corrected_inv_id,
2485: parent_item_line.line_type_lookup_code, parent_item_line.line_source, ai.invoice_currency_code, --Bug10416960
2486: parent_item_line.match_type, zd.unit_price , zd.trx_line_dist_id , zd.ref_doc_unit_price , zd.rec_nrec_tax_dist_id ))))) amount, -- bug 9231678
2487: ap_utilities_pkg.ap_round_currency(
2488: DECODE(ai.invoice_type_lookup_code,'PREPAYMENT',zd.rec_nrec_tax_amt_funcl_curr,DECODE(parent_item_line.line_type_lookup_code,
2489: 'PREPAY', zd.rec_nrec_tax_amt_funcl_curr,
2490: decode(parent_taxable_dist.line_type_lookup_code, 'PREPAY', zd.rec_nrec_tax_amt_funcl_curr,
2491: decode(nvl(zd.recoverable_flag,'N'),

Line 2798: ap_utilities_pkg.get_gl_period_name(zd.gl_date,ai.org_id) period_name,

2794: WHEN 'TIPV' THEN 'TIPV'
2795: WHEN 'TERV' THEN 'TERV'
2796: WHEN 'TRV' THEN 'TRV'
2797: END) line_type_lookup_code,
2798: ap_utilities_pkg.get_gl_period_name(zd.gl_date,ai.org_id) period_name,
2799: (CASE dist.line_type
2800: WHEN 'TIPV' THEN -- bug 10291717
2801: ap_etax_utility_pkg.get_tipv(
2802: zd.rate_tax_factor, zd.trx_line_dist_qty,

Line 2830: ap_utilities_pkg.ap_round_currency( -- bug 10291717

2826: WHEN 'TERV' THEN 0
2827: END) amount,
2828: (CASE dist.line_type
2829: WHEN 'TIPV' THEN
2830: ap_utilities_pkg.ap_round_currency( -- bug 10291717
2831: ap_etax_utility_pkg.get_tipv_base(
2832: zd.rate_tax_factor, zd.trx_line_dist_qty,
2833: nvl2(parent_taxable_dist.rcv_transaction_id,
2834: ap_etax_utility_pkg.get_converted_price

Line 2843: ap_utilities_pkg.ap_round_currency(

2839: parent_item_line.line_source, ai.invoice_currency_code, asp.base_currency_code, --Bug10416960
2840: parent_item_line.match_type , zd.trx_line_dist_id , zd.ref_per_trx_curr_unit_nr_amt , zd.rec_nrec_tax_dist_id)
2841: ,asp.base_currency_code)
2842: WHEN 'TRV' THEN
2843: ap_utilities_pkg.ap_round_currency(
2844: (ap_etax_utility_pkg.get_tv_base(
2845: zd.rate_tax_factor, zd.trx_line_dist_qty, zd.per_unit_nrec_tax_amt,
2846: nvl(zd.ref_doc_per_unit_nrec_tax_amt,0), zd.per_trx_curr_unit_nr_amt,
2847: zd.ref_per_trx_curr_unit_nr_amt, nvl(zd.currency_conversion_rate,1),

Line 2870: ap_utilities_pkg.ap_round_currency

2866: parent_item_line.line_source, ai.invoice_currency_code, asp.base_currency_code, --Bug10416960
2867: parent_item_line.match_type , zd.trx_line_dist_id , zd.ref_per_trx_curr_unit_nr_amt , zd.rec_nrec_tax_dist_id)),
2868: asp.base_currency_code) -- bug 9231678
2869: WHEN 'TERV' THEN
2870: ap_utilities_pkg.ap_round_currency
2871: (ap_etax_utility_pkg.get_terv(
2872: zd.trx_line_dist_qty, zd.currency_conversion_rate, zd.ref_doc_curr_conv_rate,
2873: zd.applied_to_doc_curr_conv_rate, NULL, zd.per_unit_nrec_tax_amt,
2874: nvl(zd.ref_doc_per_unit_nrec_tax_amt,zd.per_unit_nrec_tax_amt),

Line 3152: ap_utilities_pkg.get_gl_period_name(zd.gl_date,ai.org_id) period_name,

3148: -- are met before inserting the tax distribution
3149: DECODE(NVL(zd.recoverable_flag, 'N'),
3150: 'Y', 'REC_TAX',
3151: 'N', 'NONREC_TAX') line_type_lookup_code,
3152: ap_utilities_pkg.get_gl_period_name(zd.gl_date,ai.org_id) period_name,
3153: -- bug 8317515: modify start
3154: --BUG11656125 START--
3155: DECODE(ai.invoice_type_lookup_code,'PREPAYMENT',zd.rec_nrec_tax_amt,DECODE(parent_item_line.line_type_lookup_code,
3156: 'PREPAY', zd.rec_nrec_tax_amt,

Line 3166: ap_utilities_pkg.ap_round_currency(

3162: nvl(zd.ref_doc_per_unit_nrec_tax_amt,0), zd.per_trx_curr_unit_nr_amt,
3163: zd.ref_per_trx_curr_unit_nr_amt, zd.price_diff, parent_tax_line.corrected_inv_id,
3164: parent_item_line.line_type_lookup_code, parent_item_line.line_source, ai.invoice_currency_code, --Bug10416960
3165: parent_item_line.match_type, zd.unit_price , zd.trx_line_dist_id , zd.ref_doc_unit_price , zd.rec_nrec_tax_dist_id)))))) amount, -- bug 9231678
3166: ap_utilities_pkg.ap_round_currency(
3167: DECODE(ai.invoice_type_lookup_code,'PREPAYMENT',zd.rec_nrec_tax_amt_funcl_curr,DECODE(parent_item_line.line_type_lookup_code,
3168: 'PREPAY', zd.rec_nrec_tax_amt_funcl_curr,
3169: decode(parent_taxable_dist.line_type_lookup_code, 'PREPAY', zd.rec_nrec_tax_amt_funcl_curr,
3170: decode(nvl(zd.recoverable_flag,'N'),

Line 3380: ap_utilities_pkg.get_gl_period_name(zd.gl_date,ai.org_id) period_name,

3376: WHEN 'TIPV' THEN 'TIPV'
3377: WHEN 'TERV' THEN 'TERV'
3378: WHEN 'TRV' THEN 'TRV'
3379: END) line_type_lookup_code,
3380: ap_utilities_pkg.get_gl_period_name(zd.gl_date,ai.org_id) period_name,
3381: (CASE aid.line_type_lookup_code
3382: WHEN 'TIPV' THEN -- bug 10291717
3383: ap_etax_utility_pkg.get_tipv(
3384: zd.rate_tax_factor, zd.trx_line_dist_qty,

Line 3412: ap_utilities_pkg.ap_round_currency(

3408: WHEN 'TERV' THEN 0
3409: END) amount,
3410: (CASE aid.line_type_lookup_code
3411: WHEN 'TIPV' THEN
3412: ap_utilities_pkg.ap_round_currency(
3413: ap_etax_utility_pkg.get_tipv_base(
3414: zd.rate_tax_factor, zd.trx_line_dist_qty,
3415: nvl2(parent_taxable_dist.rcv_transaction_id,
3416: ap_etax_utility_pkg.get_converted_price

Line 3425: ap_utilities_pkg.ap_round_currency(

3421: parent_item_line.line_source, ai.invoice_currency_code, asp.base_currency_code, --Bug10416960
3422: parent_item_line.match_type , zd.trx_line_dist_id , zd.ref_per_trx_curr_unit_nr_amt , zd.rec_nrec_tax_dist_id),
3423: asp.base_currency_code)
3424: WHEN 'TRV' THEN
3425: ap_utilities_pkg.ap_round_currency(
3426: (ap_etax_utility_pkg.get_tv_base(
3427: zd.rate_tax_factor, zd.trx_line_dist_qty, zd.per_unit_nrec_tax_amt,
3428: nvl(zd.ref_doc_per_unit_nrec_tax_amt,0), zd.per_trx_curr_unit_nr_amt,
3429: zd.ref_per_trx_curr_unit_nr_amt, nvl(zd.currency_conversion_rate,1),

Line 3452: ap_utilities_pkg.ap_round_currency

3448: parent_item_line.line_source, ai.invoice_currency_code, asp.base_currency_code, --Bug10416960
3449: parent_item_line.match_type , zd.trx_line_dist_id , zd.ref_per_trx_curr_unit_nr_amt , zd.rec_nrec_tax_dist_id)),
3450: asp.base_currency_code) -- bug 9231678
3451: WHEN 'TERV' THEN
3452: ap_utilities_pkg.ap_round_currency
3453: (ap_etax_utility_pkg.get_terv(
3454: zd.trx_line_dist_qty, zd.currency_conversion_rate, zd.ref_doc_curr_conv_rate,
3455: zd.applied_to_doc_curr_conv_rate, NULL, zd.per_unit_nrec_tax_amt,
3456: nvl(zd.ref_doc_per_unit_nrec_tax_amt,zd.per_unit_nrec_tax_amt),

Line 3621: ap_utilities_pkg.get_gl_period_name(zd.gl_date,ai.org_id) period_name,

3617: -- are met before inserting the tax distribution
3618: DECODE(NVL(zd.recoverable_flag, 'N'),
3619: 'Y', 'REC_TAX',
3620: 'N', 'NONREC_TAX') line_type_lookup_code,
3621: ap_utilities_pkg.get_gl_period_name(zd.gl_date,ai.org_id) period_name,
3622: zd.rec_nrec_tax_amt amount,
3623: ap_utilities_pkg.ap_round_currency
3624: (zd.rec_nrec_tax_amt_funcl_curr,asp.base_currency_code) base_amount,
3625: parent_item_line.description description,

Line 3623: ap_utilities_pkg.ap_round_currency

3619: 'Y', 'REC_TAX',
3620: 'N', 'NONREC_TAX') line_type_lookup_code,
3621: ap_utilities_pkg.get_gl_period_name(zd.gl_date,ai.org_id) period_name,
3622: zd.rec_nrec_tax_amt amount,
3623: ap_utilities_pkg.ap_round_currency
3624: (zd.rec_nrec_tax_amt_funcl_curr,asp.base_currency_code) base_amount,
3625: parent_item_line.description description,
3626: DECODE(parent_item_line.type_1099,
3627: NULL, NULL,

Line 3835: ap_utilities_pkg.get_gl_period_name(zd.gl_date,ai.org_id) period_name,

3831: -- are met before inserting the tax distribution
3832: DECODE(NVL(zd.recoverable_flag, 'N'),
3833: 'Y', 'REC_TAX',
3834: 'N', 'NONREC_TAX') line_type_lookup_code,
3835: ap_utilities_pkg.get_gl_period_name(zd.gl_date,ai.org_id) period_name,
3836: zd.rec_nrec_tax_amt amount,
3837: ap_utilities_pkg.ap_round_currency
3838: (zd.rec_nrec_tax_amt_funcl_curr,asp.base_currency_code) base_amount,
3839: -- included the decode as part of the prepayment changes.

Line 3837: ap_utilities_pkg.ap_round_currency

3833: 'Y', 'REC_TAX',
3834: 'N', 'NONREC_TAX') line_type_lookup_code,
3835: ap_utilities_pkg.get_gl_period_name(zd.gl_date,ai.org_id) period_name,
3836: zd.rec_nrec_tax_amt amount,
3837: ap_utilities_pkg.ap_round_currency
3838: (zd.rec_nrec_tax_amt_funcl_curr,asp.base_currency_code) base_amount,
3839: -- included the decode as part of the prepayment changes.
3840: -- since for prepayment applic tax variances will not be created,
3841: -- the base_amount should be the total including variances

Line 7483: p_tax_ipv := ap_utilities_pkg.ap_round_currency (p_tax_ipv, p_inv_currency_code);

7479: END IF; -- Normal Flow ends --bug10621602
7480:
7481: IF p_tax_ipv IS NOT NULL THEN
7482:
7483: p_tax_ipv := ap_utilities_pkg.ap_round_currency (p_tax_ipv, p_inv_currency_code);
7484:
7485: IF (G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL) THEN
7486:
7487: l_debug_info := 'TAX IPV AFTER ROUNDING IS '||p_tax_ipv;

Line 7752: p_tax_ipv_base := ap_utilities_pkg.ap_round_currency (p_tax_ipv_base, p_base_currency_code);

7748: END IF; -- Normal flow ends bug10621602
7749:
7750:
7751: IF p_tax_ipv_base IS NOT NULL THEN
7752: p_tax_ipv_base := ap_utilities_pkg.ap_round_currency (p_tax_ipv_base, p_base_currency_code);
7753:
7754: IF (G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL) THEN
7755:
7756: l_debug_info := 'TAX IPV BASE AFTER ROUNDING IS '||p_tax_ipv_base;

Line 7767: l_tax_ipv := ap_utilities_pkg.ap_round_currency (l_tax_ipv, p_inv_currency_code);

7763: END IF;
7764:
7765: -- Bug 5528375
7766: IF l_tax_ipv IS NOT NULL THEN
7767: l_tax_ipv := ap_utilities_pkg.ap_round_currency (l_tax_ipv, p_inv_currency_code);
7768:
7769: IF (G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL) THEN
7770:
7771: l_debug_info := 'l_tax_ipv AFTER ROUNDING IS '||l_tax_ipv;

Line 8000: p_tax_erv := ap_utilities_pkg.ap_round_currency (p_tax_erv, p_base_currency_code);

7996: END IF; -- Normal Flow ends bug 10621602
7997:
7998: IF p_tax_erv IS NOT NULL THEN
7999:
8000: p_tax_erv := ap_utilities_pkg.ap_round_currency (p_tax_erv, p_base_currency_code);
8001:
8002: IF (G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL) THEN
8003:
8004: l_debug_info := 'TAX ERV AFTER ROUNDING IS '||p_tax_erv;

Line 8238: p_tax_tv := ap_utilities_pkg.ap_round_currency (p_tax_tv, p_inv_currency_code);

8234:
8235: END IF; -- Normal flow ends bug10621602
8236:
8237: IF p_tax_tv IS NOT NULL THEN
8238: p_tax_tv := ap_utilities_pkg.ap_round_currency (p_tax_tv, p_inv_currency_code);
8239:
8240: IF (G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL) THEN
8241:
8242: l_debug_info := 'TAX VARIANCE AFTER ROUNDING IS '||p_tax_tv;

Line 8480: p_tax_tv_base := ap_utilities_pkg.ap_round_currency (p_tax_tv_base, p_base_currency_code);

8476: END IF;
8477: END IF; --Normal Flow ends bug10621602
8478:
8479: IF p_tax_tv_base IS NOT NULL THEN
8480: p_tax_tv_base := ap_utilities_pkg.ap_round_currency (p_tax_tv_base, p_base_currency_code);
8481:
8482: IF (G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL) THEN
8483:
8484: l_debug_info := 'TAX VARIANCE BASE AFTER ROUNDING IS '||p_tax_tv_base;

Line 10842: l_invoice_attribute_rec AP_UTILITIES_PKG.r_invoice_attribute_rec;

10838: l_dist_ccid AP_INVOICE_DISTRIBUTIONS.DIST_CODE_COMBINATION_ID%TYPE;
10839: debug_info VARCHAR2(2000);
10840: debug_context VARCHAR2(2000);
10841: l_dist_code_concat VARCHAR2(2000);
10842: l_invoice_attribute_rec AP_UTILITIES_PKG.r_invoice_attribute_rec;
10843: l_invoice_type_lookup_code ap_invoices_all.invoice_type_lookup_code%TYPE;
10844: l_invoice_currency ap_invoices_all.invoice_currency_code%TYPE;
10845: l_base_currency_code AP_SYSTEM_PARAMETERS.BASE_CURRENCY_CODE%TYPE;
10846: l_chart_of_accounts_id GL_SETS_OF_BOOKS.CHART_OF_ACCOUNTS_ID%TYPE;

Line 11257: IF ( NOT (AP_UTILITIES_PKG.pa_flexbuild(

11253: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||'GET_CCID_FROM_PROJECTS' ,debug_info);
11254: END IF;
11255: /*Bug13858818 end*/
11256:
11257: IF ( NOT (AP_UTILITIES_PKG.pa_flexbuild(
11258: p_vendor_id => l_vendor_id, --IN
11259: p_employee_id => l_employee_id, --IN
11260: p_set_of_books_id => l_invoice_line_rec.set_of_books_id, --IN
11261: p_chart_of_accounts_id => l_chart_of_accounts_id, --IN

Line 11304: IF ( NOT (AP_UTILITIES_PKG.IS_CCID_VALID(

11300: END IF;
11301: /*Bug13858818 end*/
11302:
11303: IF (l_pa_allows_overrides = 'N') then
11304: IF ( NOT (AP_UTILITIES_PKG.IS_CCID_VALID(
11305: l_dist_ccid,
11306: l_chart_of_accounts_id,
11307: l_invoice_line_rec.accounting_date,
11308: current_calling_sequence))) then

Line 11330: IF ( NOT (AP_UTILITIES_PKG.IS_CCID_VALID(

11326: l_invoice_line_rec.balancing_segment is NULL AND
11327: l_invoice_line_rec.account_segment is NULL AND
11328: l_invoice_line_rec.cost_center_segment is NULL) then
11329:
11330: IF ( NOT (AP_UTILITIES_PKG.IS_CCID_VALID(
11331: l_dist_ccid,
11332: l_chart_of_accounts_id,
11333: l_invoice_line_rec.accounting_date,
11334: current_calling_sequence))) then

Line 11343: IF ( NOT (AP_UTILITIES_PKG.OVERLAY_SEGMENTS (

11339:
11340: RETURN(FALSE);
11341: END IF;
11342: ELSE
11343: IF ( NOT (AP_UTILITIES_PKG.OVERLAY_SEGMENTS (
11344: l_invoice_line_rec.balancing_segment,
11345: l_invoice_line_rec.cost_center_segment,
11346: l_invoice_line_rec.account_segment,
11347: l_invoice_line_rec.overlay_dist_code_concat,