DBA Data[Home] [Help]

APPS.AP_UTILITIES_PKG dependencies on AP_INVOICE_DISTRIBUTIONS

Line 2005: FROM ap_invoice_distributions_all

2001: -- (NULL). The status should be needs reapproval (N).
2002: --
2003: CURSOR approval_cursor IS
2004: SELECT match_status_flag
2005: FROM ap_invoice_distributions_all
2006: WHERE invoice_id = p_invoice_id
2007: UNION
2008: SELECT 'N'
2009: FROM ap_invoice_distributions_all

Line 2009: FROM ap_invoice_distributions_all

2005: FROM ap_invoice_distributions_all
2006: WHERE invoice_id = p_invoice_id
2007: UNION
2008: SELECT 'N'
2009: FROM ap_invoice_distributions_all
2010: WHERE invoice_id = p_invoice_id
2011: AND match_status_flag IS NULL
2012: AND EXISTS
2013: (SELECT 'There are both untested and tested lines'

Line 2014: FROM ap_invoice_distributions_all

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

Line 2025: FROM ap_invoice_distributions_all

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

Line 2836: P_project_id IN AP_INVOICE_DISTRIBUTIONS.PROJECT_ID%TYPE,

2832: p_chart_of_accounts_id IN NUMBER,
2833: p_base_currency_code IN VARCHAR2,
2834: p_Accounting_date IN DATE,
2835: p_award_id IN NUMBER,
2836: P_project_id IN AP_INVOICE_DISTRIBUTIONS.PROJECT_ID%TYPE,
2837: p_task_id IN AP_INVOICE_DISTRIBUTIONS.TASK_ID%TYPE,
2838: p_expenditure_type IN
2839: AP_INVOICE_DISTRIBUTIONS.EXPENDITURE_TYPE%TYPE,
2840: p_expenditure_org_id IN

Line 2837: p_task_id IN AP_INVOICE_DISTRIBUTIONS.TASK_ID%TYPE,

2833: p_base_currency_code IN VARCHAR2,
2834: p_Accounting_date IN DATE,
2835: p_award_id IN NUMBER,
2836: P_project_id IN AP_INVOICE_DISTRIBUTIONS.PROJECT_ID%TYPE,
2837: p_task_id IN AP_INVOICE_DISTRIBUTIONS.TASK_ID%TYPE,
2838: p_expenditure_type IN
2839: AP_INVOICE_DISTRIBUTIONS.EXPENDITURE_TYPE%TYPE,
2840: p_expenditure_org_id IN
2841: AP_INVOICE_DISTRIBUTIONS.EXPENDITURE_ORGANIZATION_ID%TYPE,

Line 2839: AP_INVOICE_DISTRIBUTIONS.EXPENDITURE_TYPE%TYPE,

2835: p_award_id IN NUMBER,
2836: P_project_id IN AP_INVOICE_DISTRIBUTIONS.PROJECT_ID%TYPE,
2837: p_task_id IN AP_INVOICE_DISTRIBUTIONS.TASK_ID%TYPE,
2838: p_expenditure_type IN
2839: AP_INVOICE_DISTRIBUTIONS.EXPENDITURE_TYPE%TYPE,
2840: p_expenditure_org_id IN
2841: AP_INVOICE_DISTRIBUTIONS.EXPENDITURE_ORGANIZATION_ID%TYPE,
2842: p_expenditure_item_date IN
2843: AP_INVOICE_DISTRIBUTIONS.EXPENDITURE_ITEM_DATE%TYPE,

Line 2841: AP_INVOICE_DISTRIBUTIONS.EXPENDITURE_ORGANIZATION_ID%TYPE,

2837: p_task_id IN AP_INVOICE_DISTRIBUTIONS.TASK_ID%TYPE,
2838: p_expenditure_type IN
2839: AP_INVOICE_DISTRIBUTIONS.EXPENDITURE_TYPE%TYPE,
2840: p_expenditure_org_id IN
2841: AP_INVOICE_DISTRIBUTIONS.EXPENDITURE_ORGANIZATION_ID%TYPE,
2842: p_expenditure_item_date IN
2843: AP_INVOICE_DISTRIBUTIONS.EXPENDITURE_ITEM_DATE%TYPE,
2844: p_invoice_attribute_rec IN AP_UTILITIES_PKG.r_invoice_attribute_rec, --bug 8713737
2845: p_billable_flag IN VARCHAR2, --Bug6523162

Line 2843: AP_INVOICE_DISTRIBUTIONS.EXPENDITURE_ITEM_DATE%TYPE,

2839: AP_INVOICE_DISTRIBUTIONS.EXPENDITURE_TYPE%TYPE,
2840: p_expenditure_org_id IN
2841: AP_INVOICE_DISTRIBUTIONS.EXPENDITURE_ORGANIZATION_ID%TYPE,
2842: p_expenditure_item_date IN
2843: AP_INVOICE_DISTRIBUTIONS.EXPENDITURE_ITEM_DATE%TYPE,
2844: p_invoice_attribute_rec IN AP_UTILITIES_PKG.r_invoice_attribute_rec, --bug 8713737
2845: p_billable_flag IN VARCHAR2, --Bug6523162
2846: p_employee_ccid IN NUMBER, --Bug5003249
2847: p_web_parameter_id IN NUMBER, --Bug5003249

Line 3411: FROM AP_INVOICE_DISTRIBUTIONS dist

3407:
3408: CURSOR po_enc_reversed_cur IS
3409: SELECT sum(nvl(ael.accounted_cr,0) - nvl(ael.accounted_dr,0) )
3410: FROM (SELECT DISTINCT old_distribution_id, encumbered_flag, org_id
3411: FROM AP_INVOICE_DISTRIBUTIONS dist
3412: WHERE po_distribution_id = p_po_distribution_id
3413: ) aid,
3414: AP_ENCUMBRANCE_LINES ael,
3415: financials_system_parameters fsp