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.WIP_WICTPG dependencies on PO_REQUISITIONS_INTERFACE_ALL

Line 1520: x_purge_rec.table_name := 'PO_REQUISITIONS_INTERFACE_ALL';

1516: num_rows => x_num_rows);
1517: end if;
1518:
1519:
1520: x_purge_rec.table_name := 'PO_REQUISITIONS_INTERFACE_ALL';
1521:
1522: if (p_option = REPORT_ONLY) then
1523: SELECT COUNT(*) INTO x_num_rows
1524: FROM PO_REQUISITIONS_INTERFACE_ALL

Line 1524: FROM PO_REQUISITIONS_INTERFACE_ALL

1520: x_purge_rec.table_name := 'PO_REQUISITIONS_INTERFACE_ALL';
1521:
1522: if (p_option = REPORT_ONLY) then
1523: SELECT COUNT(*) INTO x_num_rows
1524: FROM PO_REQUISITIONS_INTERFACE_ALL
1525: WHERE WIP_ENTITY_ID = x_purge_rec.wip_entity_id;
1526: else
1527: DELETE FROM PO_REQUISITIONS_INTERFACE_ALL
1528: WHERE WIP_ENTITY_ID = x_purge_rec.wip_entity_id;

Line 1527: DELETE FROM PO_REQUISITIONS_INTERFACE_ALL

1523: SELECT COUNT(*) INTO x_num_rows
1524: FROM PO_REQUISITIONS_INTERFACE_ALL
1525: WHERE WIP_ENTITY_ID = x_purge_rec.wip_entity_id;
1526: else
1527: DELETE FROM PO_REQUISITIONS_INTERFACE_ALL
1528: WHERE WIP_ENTITY_ID = x_purge_rec.wip_entity_id;
1529:
1530: x_num_rows := SQL%ROWCOUNT ;
1531:

Line 2156: x_purge_rec.table_name := 'PO_REQUISITIONS_INTERFACE_ALL';

2152: p_purge_rec => x_purge_rec);
2153: l_num_rows := 0;
2154:
2155:
2156: x_purge_rec.table_name := 'PO_REQUISITIONS_INTERFACE_ALL';
2157:
2158: savepoint sched_header02;
2159:
2160: -- Bug 4880984

Line 2163: -- table PO_REQUISITIONS_INTERFACE_ALL.

2159:
2160: -- Bug 4880984
2161: -- Added wip_entity_id filter to this SQL to improve performance
2162: -- since an index based on wip_entity_id is available for
2163: -- table PO_REQUISITIONS_INTERFACE_ALL.
2164: DELETE FROM PO_REQUISITIONS_INTERFACE_ALL
2165: WHERE WIP_REPETITIVE_SCHEDULE_ID = x_purge_rec.schedule_id
2166: AND WIP_ENTITY_ID = x_purge_rec.wip_entity_id;
2167: l_num_rows := sql%rowcount;

Line 2164: DELETE FROM PO_REQUISITIONS_INTERFACE_ALL

2160: -- Bug 4880984
2161: -- Added wip_entity_id filter to this SQL to improve performance
2162: -- since an index based on wip_entity_id is available for
2163: -- table PO_REQUISITIONS_INTERFACE_ALL.
2164: DELETE FROM PO_REQUISITIONS_INTERFACE_ALL
2165: WHERE WIP_REPETITIVE_SCHEDULE_ID = x_purge_rec.schedule_id
2166: AND WIP_ENTITY_ID = x_purge_rec.wip_entity_id;
2167: l_num_rows := sql%rowcount;
2168: if ( p_option = REPORT_ONLY) then