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_PURGE_PKG dependencies on PO_PURGE_VENDOR_LIST

Line 226: from po_purge_vendor_list

222:
223: -- count_vendors
224: select count(1)
225: into vendor_count
226: from po_purge_vendor_list
227: where double_check_flag = 'Y';
228:
229: if (vendor_count = 0) then
230:

Line 234: debug_info := 'The PO_PURGE_VENDOR_LIST table contains records. ';

230:
231: null;
232: else
233:
234: debug_info := 'The PO_PURGE_VENDOR_LIST table contains records. ';
235: Print('(Check_no_purge_in_process)' || debug_info);
236: Print(' Please make sure no purges are running and clear');
237: Print(' this table. Process terminating.');
238:

Line 1478: insert into po_purge_vendor_list

1474: Print('(Seed_Vendors)' ||debug_info);
1475: END IF;
1476:
1477: --
1478: insert into po_purge_vendor_list
1479: (vendor_id,
1480: purge_name,
1481: double_check_flag)
1482: select vnd.vendor_id,

Line 1506: delete from po_purge_vendor_list pvl

1502: END IF;
1503:
1504:
1505: -- test fa vendors
1506: delete from po_purge_vendor_list pvl
1507: where exists
1508: (select null
1509: from fa_mass_additions fma
1510: where fma.po_vendor_id = pvl.vendor_id)

Line 1524: delete from po_purge_vendor_list pvl

1520: END IF;
1521:
1522:
1523: -- test ap vendors
1524: delete from po_purge_vendor_list pvl
1525: where exists
1526: (select null
1527: from ap_invoices_all ai
1528: where ai.vendor_id = pvl.vendor_id)

Line 1551: delete from po_purge_vendor_list pvl

1547: END IF;
1548:
1549:
1550: -- test_po_vendors
1551: delete from po_purge_vendor_list pvl
1552: where exists (select null
1553: from po_headers_all ph
1554: where ph.vendor_id =
1555: pvl.vendor_id)

Line 1617: delete from po_purge_vendor_list pvl

1613: Print('(Test_Vendors)' ||debug_info);
1614: END IF;
1615:
1616: -- test_fa_vendors
1617: delete from po_purge_vendor_list pvl
1618: where exists (select null
1619: from fa_mass_additions fma
1620: where fma.po_vendor_id =
1621: pvl.vendor_id)

Line 1631: delete from po_purge_vendor_list pvl

1627:
1628: -- test_ap_vendors
1629:
1630:
1631: delete from po_purge_vendor_list pvl
1632: where exists (select null
1633: from ap_invoices_all ai
1634: where ai.vendor_id = pvl.vendor_id)
1635: or exists (select null

Line 1655: delete from po_purge_vendor_list pvl

1651: IF g_debug_switch in ('y','Y') THEN
1652: Print('(Test_Vendors)' ||debug_info);
1653: END IF;
1654:
1655: delete from po_purge_vendor_list pvl
1656: where exists (select null
1657: from po_headers_all ph
1658: where ph.vendor_id = pvl.vendor_id)
1659: or exists (select null

Line 1683: delete from po_purge_vendor_list pvl

1679: IF g_debug_switch in ('y','Y') THEN
1680: Print('(Test_Vendors)' ||debug_info);
1681: END IF;
1682:
1683: delete from po_purge_vendor_list pvl
1684: where exists (select null
1685: from chv_schedule_headers csh
1686: where csh.vendor_id = pvl.vendor_id);
1687: end if;

Line 1697: delete from po_purge_vendor_list pvl

1693: IF g_debug_switch in ('y','Y') THEN
1694: Print('(Test_Vendors)' ||debug_info);
1695: END IF;
1696:
1697: delete from po_purge_vendor_list pvl
1698: where exists (select null
1699: from ece_tp_details etd,
1700: ap_supplier_sites_all pvs
1701: where etd.tp_header_id = pvs.tp_header_id

Line 1723: delete from po_purge_vendor_list pvl

1719: --1700943, removing the code below that checks for activity
1720: --dates of the sourcing rules. we should not purge the
1721: --vendor if it is tied to an inactive rule
1722:
1723: delete from po_purge_vendor_list pvl
1724: where exists (select null
1725: from mrp_sr_source_org msso
1726: where msso.vendor_id = pvl.vendor_id);
1727:

Line 2290: from po_purge_vendor_list pvl,

2286: vnd.vendor_name,
2287: vnd.segment1,
2288: vnd.vendor_type_lookup_code,
2289: p_purge_name
2290: from po_purge_vendor_list pvl,
2291: ap_suppliers vnd
2292: where pvl.vendor_id = vnd.vendor_id
2293: and pvl.double_check_flag = 'Y';
2294:

Line 3435: update po_purge_vendor_list pvl

3431: IF g_debug_switch in ('y','Y') THEN
3432: Print('(Retest_Seeded_Vendors)'||debug_info);
3433: END IF;
3434:
3435: update po_purge_vendor_list pvl
3436: set double_check_flag = 'N'
3437: where pvl.double_check_flag = 'Y'
3438: and not exists (select null
3439: from ap_suppliers vnd

Line 3493: update po_purge_vendor_list pvl

3489: Print('(Retest_Vendors)'||debug_info);
3490: END IF;
3491:
3492: -- retest_fa_vendors
3493: update po_purge_vendor_list pvl
3494: set double_check_flag = 'N'
3495: where pvl.double_check_flag = 'Y'
3496: and (exists (select null
3497: from fa_mass_additions fma

Line 3511: update po_purge_vendor_list pvl

3507: Print('(Retest_Vendors)'||debug_info);
3508: END IF;
3509:
3510: -- retest_ap_vendors
3511: update po_purge_vendor_list pvl
3512: set double_check_flag = 'N'
3513: where pvl.double_check_flag = 'Y'
3514: and (exists (select null
3515: from ap_invoices_all ai

Line 3538: update po_purge_vendor_list pvl

3534: END IF;
3535:
3536:
3537: -- retest_po_vendors
3538: update po_purge_vendor_list pvl
3539: set double_check_flag = 'N'
3540: where pvl.double_check_flag = 'Y'
3541: and (exists (select null
3542: from po_headers_all ph

Line 3572: update po_purge_vendor_list pvl

3568:
3569:
3570: -- retest_chv_vendors
3571:
3572: update po_purge_vendor_list pvl
3573: set double_check_flag = 'N'
3574: where pvl.double_check_flag = 'Y'
3575: and (exists (select null
3576: from chv_schedule_headers csh

Line 3593: update po_purge_vendor_list pvl

3589: -- retest_mrp_vendors
3590:
3591: --1796376, removed check for inactivity dates on sql below
3592:
3593: update po_purge_vendor_list pvl
3594: set double_check_flag = 'N'
3595: where pvl.double_check_flag = 'Y'
3596: and (exists (select null
3597: from mrp_sr_source_org msso

Line 3613: update po_purge_vendor_list pvl

3609:
3610:
3611: -- retest_edi_vendors
3612:
3613: update po_purge_vendor_list pvl
3614: set double_check_flag = 'N'
3615: where pvl.double_check_flag = 'Y'
3616: and (exists (select null
3617: from ece_tp_details etd,

Line 5966: from po_purge_vendor_list pvl

5962: l_po_return_status VARCHAR2(1);
5963:
5964: cursor c_purge_vendors IS
5965: select vendor_id
5966: from po_purge_vendor_list pvl
5967: where pvl.double_check_flag = 'Y';
5968:
5969: cursor c_purge_vendor_sites IS
5970: select vendor_id,

Line 5974: from po_purge_vendor_list pvl

5970: select vendor_id,
5971: vendor_site_id
5972: from po_vendor_sites_all
5973: where vendor_id in (select vendor_id
5974: from po_purge_vendor_list pvl
5975: where pvl.double_check_flag = 'Y');
5976:
5977: BEGIN
5978:

Line 5995: from po_purge_vendor_list pvl

5991: -- delete_ap_suppliers
5992: delete from ap_suppliers vnd
5993: where exists
5994: (select null
5995: from po_purge_vendor_list pvl
5996: where pvl.vendor_id = vnd.vendor_id
5997: and pvl.double_check_flag = 'Y');
5998:
5999: /* Bug 4602105: Commented out the call to etax preupgrade control packages

Line 6031: from po_purge_vendor_list pvl

6027: -- delete_ap_supplier_sites
6028: delete from ap_supplier_sites_all vnd
6029: where exists
6030: (select null
6031: from po_purge_vendor_list pvl
6032: where pvl.vendor_id = vnd.vendor_id
6033: and pvl.double_check_flag = 'Y');
6034:
6035: debug_info := 'ap_supplier_contacts';

Line 6057: from po_purge_vendor_list pvl

6053:
6054: delete from ap_bank_account_uses_all abau
6055: where exists
6056: (select null
6057: from po_purge_vendor_list pvl
6058: where pvl.vendor_id = abau.vendor_id
6059: and pvl.double_check_flag = 'Y');
6060: */
6061: COMMIT;

Line 6097: po_purge_vendor_list pvl

6093: -- delete po_asl_docments
6094:
6095: delete from po_asl_documents pad where
6096: exists (select null from po_asl_attributes paa,
6097: po_purge_vendor_list pvl
6098: where pvl.vendor_id = paa.vendor_id
6099: and pvl.double_check_flag = 'Y'
6100: and paa.using_organization_id = pad.using_organization_id
6101: and paa.asl_id = pad.asl_id);

Line 6108: from po_purge_vendor_list pvl

6104:
6105: delete from po_asl_attributes paa
6106: where exists
6107: (select null
6108: from po_purge_vendor_list pvl
6109: where pvl.vendor_id = paa.vendor_id
6110: and pvl.double_check_flag = 'Y');
6111:
6112: debug_info := 'po_approved_supplier_list';

Line 6122: from po_purge_vendor_list pvl

6118:
6119: delete from po_approved_supplier_list pasl
6120: where exists
6121: (select null
6122: from po_purge_vendor_list pvl
6123: where pvl.vendor_id = pasl.vendor_id
6124: and pvl.double_check_flag = 'Y');
6125:
6126:

Line 6167: from po_purge_vendor_list pvl,

6163: IF g_mrp_status = 'Y' THEN
6164: update mrp_sourcing_rules msr
6165: set planning_active = 2
6166: where exists (select null
6167: from po_purge_vendor_list pvl,
6168: mrp_sr_source_org msso,
6169: mrp_sr_receipt_org msro
6170: where pvl.vendor_id = msso.vendor_id
6171: and msso.sr_receipt_id = msro.sr_receipt_id

Line 6178: from po_purge_vendor_list pvl

6174:
6175: update mrp_recommendations mr
6176: set source_vendor_id = null, source_vendor_site_id = null
6177: where exists (select null
6178: from po_purge_vendor_list pvl
6179: where pvl.vendor_id = mr.source_vendor_id
6180: and pvl.double_check_flag = 'Y');
6181:
6182: delete from mrp_sr_source_org msso

Line 6184: from po_purge_vendor_list pvl

6180: and pvl.double_check_flag = 'Y');
6181:
6182: delete from mrp_sr_source_org msso
6183: where exists (select null
6184: from po_purge_vendor_list pvl
6185: where pvl.vendor_id = msso.vendor_id
6186: and pvl.double_check_flag = 'Y');
6187:
6188: delete from mrp_item_sourcing mis

Line 6190: from po_purge_vendor_list pvl

6186: and pvl.double_check_flag = 'Y');
6187:
6188: delete from mrp_item_sourcing mis
6189: where exists (select null
6190: from po_purge_vendor_list pvl
6191: where pvl.vendor_id = mis.vendor_id
6192: and pvl.double_check_flag = 'Y');
6193:
6194: COMMIT;

Line 6560: delete from po_purge_vendor_list;

6556: x_msg_data => l_po_msg,
6557: p_purge_name => p_purge_name);
6558:
6559: -- clear_vendor_purge_list
6560: delete from po_purge_vendor_list;
6561:
6562: -- clear_schedule_list
6563: delete from chv_purge_schedule_list;
6564:

Line 6788: delete from po_purge_vendor_list;

6784: FUNCTION clear_vendor_purge_list RETURN BOOLEAN IS
6785:
6786: BEGIN
6787:
6788: delete from po_purge_vendor_list;
6789:
6790: RETURN (TRUE);
6791:
6792: RETURN NULL; EXCEPTION