APPS.AP_PURGE_PKG dependencies on AP_SUPPLIERS

Line 1727: from ap_suppliers vnd

1723: double_check_flag)
1724: select vnd.vendor_id,
1725: p_purge_name,
1726: 'Y'
1727: from ap_suppliers vnd
1728: where vnd.end_date_active <= g_activity_date
1729: and not exists (select 'vnd.vendor is a parent of
1730: another vendor'
1731: from ap_suppliers v

Line 1731: from ap_suppliers v

1727: from ap_suppliers vnd
1728: where vnd.end_date_active <= g_activity_date
1729: and not exists (select 'vnd.vendor is a parent of
1730: another vendor'
1731: from ap_suppliers v
1732: where v.parent_vendor_id =
1733: vnd.vendor_id)
1734: --Bug 2653578
1735: and PO_THIRD_PARTY_STOCK_GRP.validate_supplier_purge(

Line 2546: ap_suppliers vnd

2542: vnd.segment1,
2543: vnd.vendor_type_lookup_code,
2544: p_purge_name
2545: from po_purge_vendor_list pvl,
2546: ap_suppliers vnd
2547: where pvl.vendor_id = vnd.vendor_id
2548: and pvl.double_check_flag = 'Y';
2549:
2550: COMMIT;

Line 3943: from ap_suppliers vnd

3939: update po_purge_vendor_list pvl
3940: set double_check_flag = 'N'
3941: where pvl.double_check_flag = 'Y'
3942: and not exists (select null
3943: from ap_suppliers vnd
3944: where vnd.vendor_id = pvl.vendor_id
3945: --and nvl(vnd.vendor_type_lookup_code, 'VENDOR') <> 'EMPLOYEE'
3946: and nvl(vnd.end_date_active,sysdate) <=
3947: g_activity_date);

Line 6546: debug_info := 'ap_suppliers';

6542: current_calling_sequence := 'Purge_Vendors<-'||P_Calling_Sequence;
6543:
6544: --
6545:
6546: debug_info := 'ap_suppliers';
6547: IF g_debug_switch in ('y','Y') THEN
6548: Print('(Purge_Vendors)'||debug_info);
6549: END IF;
6550:

Line 6551: -- delete_ap_suppliers

6547: IF g_debug_switch in ('y','Y') THEN
6548: Print('(Purge_Vendors)'||debug_info);
6549: END IF;
6550:
6551: -- delete_ap_suppliers
6552: delete from ap_suppliers vnd
6553: where exists
6554: (select null
6555: from po_purge_vendor_list pvl

Line 6552: delete from ap_suppliers vnd

6548: Print('(Purge_Vendors)'||debug_info);
6549: END IF;
6550:
6551: -- delete_ap_suppliers
6552: delete from ap_suppliers vnd
6553: where exists
6554: (select null
6555: from po_purge_vendor_list pvl
6556: where pvl.vendor_id = vnd.vendor_id

Line 6649: from ap_suppliers vnd

6645:
6646: delete from po_vendor_list_entries pvle
6647: where not exists
6648: (select null
6649: from ap_suppliers vnd
6650: where vnd.vendor_id = pvle.vendor_id);
6651:
6652: debug_info := 'po_vendor_list_headers';
6653: IF g_debug_switch in ('y','Y') THEN