DBA Data[Home] [Help]

APPS.AP_ETAX_UTILITY_PKG dependencies on AP_SYSTEM_PARAMETERS

Line 114: allow_flex_override_flag ap_system_parameters_all.allow_flex_override_flag%TYPE,

110: extra_po_erv ap_invoice_distributions_all.extra_po_erv%TYPE,
111: taxable_amount ap_invoice_distributions_all.taxable_amount%TYPE,
112: taxable_base_amount ap_invoice_distributions_all.taxable_base_amount%TYPE,
113: accrue_on_receipt_flag po_distributions_all.accrue_on_receipt_flag%TYPE,
114: allow_flex_override_flag ap_system_parameters_all.allow_flex_override_flag%TYPE,
115: purch_encumbrance_flag financials_system_params_all.purch_encumbrance_flag%TYPE,
116: org_id ap_invoice_distributions_all.org_id%TYPE,
117: tax_regime_id zx_rec_nrec_dist.tax_regime_id%TYPE,
118: tax_id zx_rec_nrec_dist.tax_id%TYPE,

Line 1174: l_wfapproval_flag ap_system_parameters_all.approval_workflow_flag%TYPE;

1170: l_curr_calling_sequence VARCHAR2(4000);
1171:
1172: l_period_name gl_period_statuses.period_name%TYPE;
1173: l_gl_date ap_invoice_lines_all.accounting_date%TYPE;
1174: l_wfapproval_flag ap_system_parameters_all.approval_workflow_flag%TYPE;
1175: l_awt_include_tax_amt ap_system_parameters_all.awt_include_tax_amt%TYPE;
1176: l_base_currency_code ap_system_parameters_all.base_currency_code%TYPE;
1177: l_combined_filing_flag ap_system_parameters_all.combined_filing_flag%TYPE;
1178: l_income_tax_region_flag ap_system_parameters_all.income_tax_region_flag%TYPE;

Line 1175: l_awt_include_tax_amt ap_system_parameters_all.awt_include_tax_amt%TYPE;

1171:
1172: l_period_name gl_period_statuses.period_name%TYPE;
1173: l_gl_date ap_invoice_lines_all.accounting_date%TYPE;
1174: l_wfapproval_flag ap_system_parameters_all.approval_workflow_flag%TYPE;
1175: l_awt_include_tax_amt ap_system_parameters_all.awt_include_tax_amt%TYPE;
1176: l_base_currency_code ap_system_parameters_all.base_currency_code%TYPE;
1177: l_combined_filing_flag ap_system_parameters_all.combined_filing_flag%TYPE;
1178: l_income_tax_region_flag ap_system_parameters_all.income_tax_region_flag%TYPE;
1179: l_income_tax_region ap_system_parameters_all.income_tax_region%TYPE;

Line 1176: l_base_currency_code ap_system_parameters_all.base_currency_code%TYPE;

1172: l_period_name gl_period_statuses.period_name%TYPE;
1173: l_gl_date ap_invoice_lines_all.accounting_date%TYPE;
1174: l_wfapproval_flag ap_system_parameters_all.approval_workflow_flag%TYPE;
1175: l_awt_include_tax_amt ap_system_parameters_all.awt_include_tax_amt%TYPE;
1176: l_base_currency_code ap_system_parameters_all.base_currency_code%TYPE;
1177: l_combined_filing_flag ap_system_parameters_all.combined_filing_flag%TYPE;
1178: l_income_tax_region_flag ap_system_parameters_all.income_tax_region_flag%TYPE;
1179: l_income_tax_region ap_system_parameters_all.income_tax_region%TYPE;
1180: l_disc_is_inv_less_tax_flag ap_system_parameters_all.disc_is_inv_less_tax_flag%TYPE;

Line 1177: l_combined_filing_flag ap_system_parameters_all.combined_filing_flag%TYPE;

1173: l_gl_date ap_invoice_lines_all.accounting_date%TYPE;
1174: l_wfapproval_flag ap_system_parameters_all.approval_workflow_flag%TYPE;
1175: l_awt_include_tax_amt ap_system_parameters_all.awt_include_tax_amt%TYPE;
1176: l_base_currency_code ap_system_parameters_all.base_currency_code%TYPE;
1177: l_combined_filing_flag ap_system_parameters_all.combined_filing_flag%TYPE;
1178: l_income_tax_region_flag ap_system_parameters_all.income_tax_region_flag%TYPE;
1179: l_income_tax_region ap_system_parameters_all.income_tax_region%TYPE;
1180: l_disc_is_inv_less_tax_flag ap_system_parameters_all.disc_is_inv_less_tax_flag%TYPE;
1181: l_wfapproval_status ap_invoice_lines_all.wfapproval_status%TYPE;

Line 1178: l_income_tax_region_flag ap_system_parameters_all.income_tax_region_flag%TYPE;

1174: l_wfapproval_flag ap_system_parameters_all.approval_workflow_flag%TYPE;
1175: l_awt_include_tax_amt ap_system_parameters_all.awt_include_tax_amt%TYPE;
1176: l_base_currency_code ap_system_parameters_all.base_currency_code%TYPE;
1177: l_combined_filing_flag ap_system_parameters_all.combined_filing_flag%TYPE;
1178: l_income_tax_region_flag ap_system_parameters_all.income_tax_region_flag%TYPE;
1179: l_income_tax_region ap_system_parameters_all.income_tax_region%TYPE;
1180: l_disc_is_inv_less_tax_flag ap_system_parameters_all.disc_is_inv_less_tax_flag%TYPE;
1181: l_wfapproval_status ap_invoice_lines_all.wfapproval_status%TYPE;
1182: l_new_amt_applicable_to_disc ap_invoices_all.amount_applicable_to_discount%TYPE;

Line 1179: l_income_tax_region ap_system_parameters_all.income_tax_region%TYPE;

1175: l_awt_include_tax_amt ap_system_parameters_all.awt_include_tax_amt%TYPE;
1176: l_base_currency_code ap_system_parameters_all.base_currency_code%TYPE;
1177: l_combined_filing_flag ap_system_parameters_all.combined_filing_flag%TYPE;
1178: l_income_tax_region_flag ap_system_parameters_all.income_tax_region_flag%TYPE;
1179: l_income_tax_region ap_system_parameters_all.income_tax_region%TYPE;
1180: l_disc_is_inv_less_tax_flag ap_system_parameters_all.disc_is_inv_less_tax_flag%TYPE;
1181: l_wfapproval_status ap_invoice_lines_all.wfapproval_status%TYPE;
1182: l_new_amt_applicable_to_disc ap_invoices_all.amount_applicable_to_discount%TYPE;
1183: l_payment_priority ap_batches_all.payment_priority%TYPE;

Line 1180: l_disc_is_inv_less_tax_flag ap_system_parameters_all.disc_is_inv_less_tax_flag%TYPE;

1176: l_base_currency_code ap_system_parameters_all.base_currency_code%TYPE;
1177: l_combined_filing_flag ap_system_parameters_all.combined_filing_flag%TYPE;
1178: l_income_tax_region_flag ap_system_parameters_all.income_tax_region_flag%TYPE;
1179: l_income_tax_region ap_system_parameters_all.income_tax_region%TYPE;
1180: l_disc_is_inv_less_tax_flag ap_system_parameters_all.disc_is_inv_less_tax_flag%TYPE;
1181: l_wfapproval_status ap_invoice_lines_all.wfapproval_status%TYPE;
1182: l_new_amt_applicable_to_disc ap_invoices_all.amount_applicable_to_discount%TYPE;
1183: l_payment_priority ap_batches_all.payment_priority%TYPE;
1184:

Line 1338: l_debug_info := 'Get ap_system_parameters data';

1334: END IF;
1335:
1336:
1337: -------------------------------------------------------------------
1338: l_debug_info := 'Get ap_system_parameters data';
1339: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
1340: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,l_debug_info);
1341: END IF;
1342: -------------------------------------------------------------------

Line 1361: FROM ap_system_parameters_all

1357: l_base_currency_code,
1358: l_combined_filing_flag,
1359: l_income_tax_region_flag,
1360: l_income_tax_region
1361: FROM ap_system_parameters_all
1362: WHERE org_id = P_Invoice_Header_Rec.org_id;
1363: END;
1364:
1365: -------------------------------------------------------------------

Line 2701: ap_system_parameters_all asp,

2697: zx_rec_nrec_dist zd,
2698: zx_lines zl,
2699: ap_invoices_all ai,
2700: ap_supplier_sites_all pvs,
2701: ap_system_parameters_all asp,
2702: financials_system_params_all fsp,
2703: po_distributions_all pd,
2704: ap_invoice_lines_all parent_tax_line,
2705: ap_invoice_lines_all parent_item_line,

Line 3048: ap_system_parameters_all asp,

3044: zx_rec_nrec_dist zd,
3045: zx_lines zl,
3046: ap_invoices_all ai,
3047: ap_supplier_sites_all pvs,
3048: ap_system_parameters_all asp,
3049: financials_system_params_all fsp,
3050: po_distributions_all pd,
3051: ap_invoice_lines_all parent_tax_line,
3052: ap_invoice_lines_all parent_item_line,

Line 3327: ap_system_parameters_all asp,

3323: zx_lines zl,
3324: ap_invoices_all ai,
3325: ap_invoice_distributions_all aid,
3326: ap_supplier_sites_all pvs,
3327: ap_system_parameters_all asp,
3328: financials_system_params_all fsp,
3329: po_distributions_all pd,
3330: ap_invoice_lines_all parent_tax_line,
3331: ap_invoice_lines_all parent_item_line,

Line 3568: ap_system_parameters_all asp,

3564: zx_lines zl,
3565: ap_invoices_all ai,
3566: ap_invoice_distributions_all aid,
3567: ap_supplier_sites_all pvs,
3568: ap_system_parameters_all asp,
3569: financials_system_params_all fsp,
3570: po_distributions_all pd,
3571: ap_invoice_lines_all parent_tax_line,
3572: ap_invoice_lines_all parent_item_line,

Line 3787: ap_system_parameters_all asp,

3783: zx_rec_nrec_dist zd,
3784: zx_lines zl,
3785: ap_invoices_all ai,
3786: ap_supplier_sites_all pvs,
3787: ap_system_parameters_all asp,
3788: financials_system_params_all fsp,
3789: po_distributions_all pd,
3790: ap_invoice_lines_all parent_item_line,
3791: ap_invoice_distributions_all parent_taxable_dist

Line 3987: ap_system_parameters_all asp,

3983: zx_lines zl,
3984: ap_invoices_all ai,
3985: ap_self_assessed_tax_dist_all aid,
3986: ap_supplier_sites_all pvs,
3987: ap_system_parameters_all asp,
3988: financials_system_params_all fsp,
3989: po_distributions_all pd,
3990: ap_invoice_lines_all parent_tax_line,
3991: ap_invoice_lines_all parent_item_line,

Line 10845: l_base_currency_code AP_SYSTEM_PARAMETERS.BASE_CURRENCY_CODE%TYPE;

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;
10847: l_error_found VARCHAR2(1) := 'N';
10848: l_pa_allows_overrides VARCHAR2(1) := 'N';
10849: l_employee_id NUMBER;

Line 10970: FROM ap_system_parameters ap, gl_sets_of_books gsob

10966:
10967: BEGIN
10968: SELECT gsob.chart_of_accounts_id, ap.base_currency_code
10969: INTO l_chart_of_accounts_id, l_base_currency_code
10970: FROM ap_system_parameters ap, gl_sets_of_books gsob
10971: WHERE ap.set_of_books_id = gsob.set_of_books_id
10972: AND ap.set_of_books_id = l_invoice_line_rec.set_of_books_id
10973: AND ap.org_id = l_invoice_line_rec.org_id; -- Bug 13858818;
10974: