APPS.AP_UTILITIES_PKG dependencies on AP_INVOICE_DISTRIBUTIONS

Line 2001: FROM ap_invoice_distributions_all

1997: -- (NULL). The status should be needs reapproval (N).
1998: --
1999: CURSOR approval_cursor IS
2000: SELECT match_status_flag
2001: FROM ap_invoice_distributions_all
2002: WHERE invoice_id = p_invoice_id
2003: UNION
2004: SELECT 'N'
2005: FROM ap_invoice_distributions_all

Line 2005: FROM ap_invoice_distributions_all

2001: FROM ap_invoice_distributions_all
2002: WHERE invoice_id = p_invoice_id
2003: UNION
2004: SELECT 'N'
2005: FROM ap_invoice_distributions_all
2006: WHERE invoice_id = p_invoice_id
2007: AND match_status_flag IS NULL
2008: AND EXISTS
2009: (SELECT 'There are both untested and tested lines'

Line 2010: FROM ap_invoice_distributions_all

2006: WHERE invoice_id = p_invoice_id
2007: AND match_status_flag IS NULL
2008: AND EXISTS
2009: (SELECT 'There are both untested and tested lines'
2010: FROM ap_invoice_distributions_all
2011: WHERE invoice_id = p_invoice_id
2012: AND match_status_flag IN ('T','A'))
2013: UNION -- Bug 6866672
2014: SELECT 'N'

Line 2021: FROM ap_invoice_distributions_all

2017: AND ai.invoice_id = ail.invoice_id
2018: AND ai.cancelled_date is NULL
2019: AND NOT EXISTS
2020: (SELECT 1
2021: FROM ap_invoice_distributions_all
2022: WHERE invoice_id = p_invoice_id
2023: AND invoice_line_number = ail.line_number)
2024: AND ail.amount <> 0; -- Bug 6911199. Should ignore 0 Line Amounts.(Also one test case is an open issue)
2025:

Line 2831: P_project_id IN AP_INVOICE_DISTRIBUTIONS.PROJECT_ID%TYPE,

2827: p_chart_of_accounts_id IN NUMBER,
2828: p_base_currency_code IN VARCHAR2,
2829: p_Accounting_date IN DATE,
2830: p_award_id IN NUMBER,
2831: P_project_id IN AP_INVOICE_DISTRIBUTIONS.PROJECT_ID%TYPE,
2832: p_task_id IN AP_INVOICE_DISTRIBUTIONS.TASK_ID%TYPE,
2833: p_expenditure_type IN
2834: AP_INVOICE_DISTRIBUTIONS.EXPENDITURE_TYPE%TYPE,
2835: p_expenditure_org_id IN

Line 2832: p_task_id IN AP_INVOICE_DISTRIBUTIONS.TASK_ID%TYPE,

2828: p_base_currency_code IN VARCHAR2,
2829: p_Accounting_date IN DATE,
2830: p_award_id IN NUMBER,
2831: P_project_id IN AP_INVOICE_DISTRIBUTIONS.PROJECT_ID%TYPE,
2832: p_task_id IN AP_INVOICE_DISTRIBUTIONS.TASK_ID%TYPE,
2833: p_expenditure_type IN
2834: AP_INVOICE_DISTRIBUTIONS.EXPENDITURE_TYPE%TYPE,
2835: p_expenditure_org_id IN
2836: AP_INVOICE_DISTRIBUTIONS.EXPENDITURE_ORGANIZATION_ID%TYPE,

Line 2834: AP_INVOICE_DISTRIBUTIONS.EXPENDITURE_TYPE%TYPE,

2830: p_award_id IN NUMBER,
2831: P_project_id IN AP_INVOICE_DISTRIBUTIONS.PROJECT_ID%TYPE,
2832: p_task_id IN AP_INVOICE_DISTRIBUTIONS.TASK_ID%TYPE,
2833: p_expenditure_type IN
2834: AP_INVOICE_DISTRIBUTIONS.EXPENDITURE_TYPE%TYPE,
2835: p_expenditure_org_id IN
2836: AP_INVOICE_DISTRIBUTIONS.EXPENDITURE_ORGANIZATION_ID%TYPE,
2837: p_expenditure_item_date IN
2838: AP_INVOICE_DISTRIBUTIONS.EXPENDITURE_ITEM_DATE%TYPE,

Line 2836: AP_INVOICE_DISTRIBUTIONS.EXPENDITURE_ORGANIZATION_ID%TYPE,

2832: p_task_id IN AP_INVOICE_DISTRIBUTIONS.TASK_ID%TYPE,
2833: p_expenditure_type IN
2834: AP_INVOICE_DISTRIBUTIONS.EXPENDITURE_TYPE%TYPE,
2835: p_expenditure_org_id IN
2836: AP_INVOICE_DISTRIBUTIONS.EXPENDITURE_ORGANIZATION_ID%TYPE,
2837: p_expenditure_item_date IN
2838: AP_INVOICE_DISTRIBUTIONS.EXPENDITURE_ITEM_DATE%TYPE,
2839: p_employee_ccid IN NUMBER, --Bug5003249
2840: p_web_parameter_id IN NUMBER, --Bug5003249

Line 2838: AP_INVOICE_DISTRIBUTIONS.EXPENDITURE_ITEM_DATE%TYPE,

2834: AP_INVOICE_DISTRIBUTIONS.EXPENDITURE_TYPE%TYPE,
2835: p_expenditure_org_id IN
2836: AP_INVOICE_DISTRIBUTIONS.EXPENDITURE_ORGANIZATION_ID%TYPE,
2837: p_expenditure_item_date IN
2838: AP_INVOICE_DISTRIBUTIONS.EXPENDITURE_ITEM_DATE%TYPE,
2839: p_employee_ccid IN NUMBER, --Bug5003249
2840: p_web_parameter_id IN NUMBER, --Bug5003249
2841: p_invoice_type_lookup_code IN VARCHAR2, --Bug5003249
2842: p_default_last_updated_by IN NUMBER,

Line 3380: FROM AP_INVOICE_DISTRIBUTIONS aid,

3376: l_total_unencumbered_amount NUMBER;
3377:
3378: CURSOR po_enc_reversed_cur IS
3379: SELECT sum(nvl(ael.accounted_cr,0) - nvl(ael.accounted_dr,0) )
3380: FROM AP_INVOICE_DISTRIBUTIONS aid,
3381: AP_ENCUMBRANCE_LINES ael,
3382: financials_system_parameters fsp
3383: WHERE aid.po_distribution_id = P_po_distribution_id
3384: AND aid.invoice_distribution_id = ael.invoice_distribution_id

Line 3404: FROM ap_invoice_distributions aid,

3400: SELECT sum (nvl(nvl(aid.base_amount,aid.amount),0) -
3401: nvl(aid.base_invoice_price_variance ,0) -
3402: nvl(aid.exchange_rate_variance,0) -
3403: nvl(aid.base_quantity_variance,0))
3404: FROM ap_invoice_distributions aid,
3405: po_distributions pd,
3406: financials_system_parameters fs
3407: where aid.po_distribution_id = p_po_distribution_id
3408: and aid.po_distribution_id = pd.po_distribution_id