APPS.AP_VENDORS_PKG dependencies on AP_SELECTED_INVOICES

Line 2009: -- will appear on check - denormalised into AP_SELECTED_INVOICES

2005: p_warning_flag in out NOCOPY varchar2,
2006: X_calling_sequence in varchar2) is
2007: --
2008: -- If invoices for this vendor have been selected, warn user, old name
2009: -- will appear on check - denormalised into AP_SELECTED_INVOICES
2010: -- join to sites so that index AP_SELECTED_INVOICES_N2 can be used
2011: -- there is no index on vendor_id in AP_SELECTED_INVOICES
2012: --
2013: l_overlap_count number;

Line 2010: -- join to sites so that index AP_SELECTED_INVOICES_N2 can be used

2006: X_calling_sequence in varchar2) is
2007: --
2008: -- If invoices for this vendor have been selected, warn user, old name
2009: -- will appear on check - denormalised into AP_SELECTED_INVOICES
2010: -- join to sites so that index AP_SELECTED_INVOICES_N2 can be used
2011: -- there is no index on vendor_id in AP_SELECTED_INVOICES
2012: --
2013: l_overlap_count number;
2014: current_calling_sequence VARCHAR2(2000);

Line 2011: -- there is no index on vendor_id in AP_SELECTED_INVOICES

2007: --
2008: -- If invoices for this vendor have been selected, warn user, old name
2009: -- will appear on check - denormalised into AP_SELECTED_INVOICES
2010: -- join to sites so that index AP_SELECTED_INVOICES_N2 can be used
2011: -- there is no index on vendor_id in AP_SELECTED_INVOICES
2012: --
2013: l_overlap_count number;
2014: current_calling_sequence VARCHAR2(2000);
2015: debug_info VARCHAR2(100);

Line 2027: ap_selected_invoices i

2023: debug_info := 'Count overlap count for the vendor_id and site_id';
2024: SELECT count(1)
2025: INTO L_overlap_count
2026: FROM po_vendor_sites s,
2027: ap_selected_invoices i
2028: WHERE s.vendor_id = p_vendor_id
2029: AND i.vendor_site_id = s.vendor_site_id;
2030: --
2031: --

Line 2127: debug_info := 'Count from AP_selected_invoices';

2123: --
2124: current_calling_sequence := 'AP_VENDORS_PKG.CHECK_SELECTED_INVOICES<-' ||
2125: X_calling_sequence;
2126:
2127: debug_info := 'Count from AP_selected_invoices';
2128: select count(1)
2129: into x_return_count
2130: from AP_selected_invoices
2131: where vendor_id = x_vendor_id;

Line 2130: from AP_selected_invoices

2126:
2127: debug_info := 'Count from AP_selected_invoices';
2128: select count(1)
2129: into x_return_count
2130: from AP_selected_invoices
2131: where vendor_id = x_vendor_id;
2132:
2133: EXCEPTION
2134: WHEN OTHERS THEN