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_SERVICES_PKG dependencies on AP_SYSTEM_PARAMETERS_ALL

Line 1538: ap_system_parameters_all asp --Bug14779241

1534:
1535: CURSOR Invoice_Header (c_invoice_id NUMBER) IS
1536: SELECT ai.*
1537: FROM ap_invoices_all ai,
1538: ap_system_parameters_all asp --Bug14779241
1539: WHERE ai.invoice_id = c_invoice_id
1540: AND asp.org_id = ai.org_id /* Bug14779241: Start */
1541: AND ((asp.base_currency_code = ai.invoice_currency_code) OR
1542: (asp.base_currency_code <> ai.invoice_currency_code AND

Line 1550: ap_system_parameters_all asp --Bug14779241

1546: SELECT aid.*
1547: FROM ap_invoice_lines_all ail,
1548: ap_invoice_distributions_all aid,
1549: ap_invoices_all ai , --Bug14779241
1550: ap_system_parameters_all asp --Bug14779241
1551: WHERE ail.invoice_id = aid.invoice_id
1552: AND ail.line_number = aid.invoice_line_number
1553: AND ail.invoice_id = c_invoice_id
1554: AND ai.invoice_id = ail.invoice_id /* Bug14779241: Start */

Line 1584: ap_system_parameters_all asp --Bug14779241

1580: SELECT aid.*
1581: FROM ap_invoice_lines_all ail,
1582: ap_invoice_distributions_all aid,
1583: ap_invoices_all ai, --Bug14779241
1584: ap_system_parameters_all asp --Bug14779241
1585: WHERE ail.invoice_id = aid.invoice_id
1586: AND ail.line_number = aid.invoice_line_number
1587: AND ail.invoice_id = c_invoice_id
1588: AND ai.invoice_id = ail.invoice_id /* Bug14779241: Start */

Line 1612: ap_system_parameters_all asp --Bug14779241

1608: SELECT aid.*
1609: FROM ap_invoice_lines_all ail,
1610: ap_invoice_distributions_all aid,
1611: ap_invoices_all ai, --Bug14779241
1612: ap_system_parameters_all asp --Bug14779241
1613: WHERE ail.invoice_id = aid.invoice_id
1614: AND ail.line_number = aid.invoice_line_number
1615: AND ail.invoice_id = c_invoice_id
1616: AND ail.line_number = c_line_number

Line 1644: ap_system_parameters_all asp --Bug14779241

1640: SELECT aid.*
1641: FROM ap_invoice_lines_all ail,
1642: ap_invoice_distributions_all aid,
1643: ap_invoices_all ai, --Bug14779241
1644: ap_system_parameters_all asp --Bug14779241
1645: WHERE ail.invoice_id = aid.invoice_id
1646: AND ail.line_number = aid.invoice_line_number
1647: AND ail.invoice_id = c_invoice_id
1648: AND ail.line_number = c_line_number

Line 2240: ap_system_parameters_all asp

2236:
2237: CURSOR Invoice_ex_rate_check IS --Bug14779241
2238: SELECT ai.invoice_id
2239: FROM ap_invoices_all ai,
2240: ap_system_parameters_all asp
2241: WHERE ai.invoice_id = P_Invoice_Id
2242: AND asp.org_id = ai.org_id
2243: AND ((asp.base_currency_code = ai.invoice_currency_code) OR
2244: (asp.base_currency_code <> ai.invoice_currency_code AND

Line 3176: ap_system_parameters_all asp

3172:
3173: CURSOR Invoice_ex_rate_check IS --Bug14779241
3174: SELECT ai.invoice_id
3175: FROM ap_invoices_all ai,
3176: ap_system_parameters_all asp
3177: WHERE ai.invoice_id = P_Invoice_Id
3178: AND asp.org_id = ai.org_id
3179: AND ((asp.base_currency_code = ai.invoice_currency_code) OR
3180: (asp.base_currency_code <> ai.invoice_currency_code AND

Line 17338: ap_system_parameters_all asp --Bug14779241

17334: FROM ap_invoices_all ai,
17335: fnd_currencies cur,
17336: fnd_document_sequences doc,
17337: ap_invoices_all related_ai,
17338: ap_system_parameters_all asp --Bug14779241
17339: WHERE ai.invoice_currency_code = cur.currency_code
17340: AND ai.doc_sequence_id = doc.doc_sequence_id (+)
17341: AND ai.tax_related_invoice_id = related_ai.invoice_id (+)
17342: AND nvl(ai.quick_credit,'N') = 'N'

Line 18017: l_wfapproval_flag ap_system_parameters_all.approval_workflow_flag%TYPE;

18013: l_curr_calling_sequence VARCHAR2(4000);
18014:
18015: l_period_name gl_period_statuses.period_name%TYPE;
18016: l_gl_date ap_invoice_lines_all.accounting_date%TYPE;
18017: l_wfapproval_flag ap_system_parameters_all.approval_workflow_flag%TYPE;
18018: l_awt_include_tax_amt ap_system_parameters_all.awt_include_tax_amt%TYPE;
18019: l_base_currency_code ap_system_parameters_all.base_currency_code%TYPE;
18020: l_combined_filing_flag ap_system_parameters_all.combined_filing_flag%TYPE;
18021: l_income_tax_region_flag ap_system_parameters_all.income_tax_region_flag%TYPE;

Line 18018: l_awt_include_tax_amt ap_system_parameters_all.awt_include_tax_amt%TYPE;

18014:
18015: l_period_name gl_period_statuses.period_name%TYPE;
18016: l_gl_date ap_invoice_lines_all.accounting_date%TYPE;
18017: l_wfapproval_flag ap_system_parameters_all.approval_workflow_flag%TYPE;
18018: l_awt_include_tax_amt ap_system_parameters_all.awt_include_tax_amt%TYPE;
18019: l_base_currency_code ap_system_parameters_all.base_currency_code%TYPE;
18020: l_combined_filing_flag ap_system_parameters_all.combined_filing_flag%TYPE;
18021: l_income_tax_region_flag ap_system_parameters_all.income_tax_region_flag%TYPE;
18022: l_income_tax_region ap_system_parameters_all.income_tax_region%TYPE;

Line 18019: l_base_currency_code ap_system_parameters_all.base_currency_code%TYPE;

18015: l_period_name gl_period_statuses.period_name%TYPE;
18016: l_gl_date ap_invoice_lines_all.accounting_date%TYPE;
18017: l_wfapproval_flag ap_system_parameters_all.approval_workflow_flag%TYPE;
18018: l_awt_include_tax_amt ap_system_parameters_all.awt_include_tax_amt%TYPE;
18019: l_base_currency_code ap_system_parameters_all.base_currency_code%TYPE;
18020: l_combined_filing_flag ap_system_parameters_all.combined_filing_flag%TYPE;
18021: l_income_tax_region_flag ap_system_parameters_all.income_tax_region_flag%TYPE;
18022: l_income_tax_region ap_system_parameters_all.income_tax_region%TYPE;
18023: l_disc_is_inv_less_tax_flag ap_system_parameters_all.disc_is_inv_less_tax_flag%TYPE;

Line 18020: l_combined_filing_flag ap_system_parameters_all.combined_filing_flag%TYPE;

18016: l_gl_date ap_invoice_lines_all.accounting_date%TYPE;
18017: l_wfapproval_flag ap_system_parameters_all.approval_workflow_flag%TYPE;
18018: l_awt_include_tax_amt ap_system_parameters_all.awt_include_tax_amt%TYPE;
18019: l_base_currency_code ap_system_parameters_all.base_currency_code%TYPE;
18020: l_combined_filing_flag ap_system_parameters_all.combined_filing_flag%TYPE;
18021: l_income_tax_region_flag ap_system_parameters_all.income_tax_region_flag%TYPE;
18022: l_income_tax_region ap_system_parameters_all.income_tax_region%TYPE;
18023: l_disc_is_inv_less_tax_flag ap_system_parameters_all.disc_is_inv_less_tax_flag%TYPE;
18024: l_wfapproval_status ap_invoice_lines_all.wfapproval_status%TYPE;

Line 18021: l_income_tax_region_flag ap_system_parameters_all.income_tax_region_flag%TYPE;

18017: l_wfapproval_flag ap_system_parameters_all.approval_workflow_flag%TYPE;
18018: l_awt_include_tax_amt ap_system_parameters_all.awt_include_tax_amt%TYPE;
18019: l_base_currency_code ap_system_parameters_all.base_currency_code%TYPE;
18020: l_combined_filing_flag ap_system_parameters_all.combined_filing_flag%TYPE;
18021: l_income_tax_region_flag ap_system_parameters_all.income_tax_region_flag%TYPE;
18022: l_income_tax_region ap_system_parameters_all.income_tax_region%TYPE;
18023: l_disc_is_inv_less_tax_flag ap_system_parameters_all.disc_is_inv_less_tax_flag%TYPE;
18024: l_wfapproval_status ap_invoice_lines_all.wfapproval_status%TYPE;
18025: l_new_amt_applicable_to_disc ap_invoices_all.amount_applicable_to_discount%TYPE;

Line 18022: l_income_tax_region ap_system_parameters_all.income_tax_region%TYPE;

18018: l_awt_include_tax_amt ap_system_parameters_all.awt_include_tax_amt%TYPE;
18019: l_base_currency_code ap_system_parameters_all.base_currency_code%TYPE;
18020: l_combined_filing_flag ap_system_parameters_all.combined_filing_flag%TYPE;
18021: l_income_tax_region_flag ap_system_parameters_all.income_tax_region_flag%TYPE;
18022: l_income_tax_region ap_system_parameters_all.income_tax_region%TYPE;
18023: l_disc_is_inv_less_tax_flag ap_system_parameters_all.disc_is_inv_less_tax_flag%TYPE;
18024: l_wfapproval_status ap_invoice_lines_all.wfapproval_status%TYPE;
18025: l_new_amt_applicable_to_disc ap_invoices_all.amount_applicable_to_discount%TYPE;
18026: l_payment_priority ap_batches_all.payment_priority%TYPE;

Line 18023: l_disc_is_inv_less_tax_flag ap_system_parameters_all.disc_is_inv_less_tax_flag%TYPE;

18019: l_base_currency_code ap_system_parameters_all.base_currency_code%TYPE;
18020: l_combined_filing_flag ap_system_parameters_all.combined_filing_flag%TYPE;
18021: l_income_tax_region_flag ap_system_parameters_all.income_tax_region_flag%TYPE;
18022: l_income_tax_region ap_system_parameters_all.income_tax_region%TYPE;
18023: l_disc_is_inv_less_tax_flag ap_system_parameters_all.disc_is_inv_less_tax_flag%TYPE;
18024: l_wfapproval_status ap_invoice_lines_all.wfapproval_status%TYPE;
18025: l_new_amt_applicable_to_disc ap_invoices_all.amount_applicable_to_discount%TYPE;
18026: l_payment_priority ap_batches_all.payment_priority%TYPE;
18027:

Line 18079: FROM ap_system_parameters_all

18075: l_base_currency_code,
18076: l_combined_filing_flag,
18077: l_income_tax_region_flag,
18078: l_income_tax_region
18079: FROM ap_system_parameters_all
18080: WHERE org_id = P_Invoice_Header_Rec.org_id;
18081: END;
18082:
18083: -------------------------------------------------------------------