DBA Data[Home] [Help]

APPS.WIP_WICTPG dependencies on RCV_TRANSACTIONS_INTERFACE

Line 1542: x_purge_rec.table_name := 'RCV_TRANSACTIONS_INTERFACE';

1538: num_rows => x_num_rows);
1539: end if;
1540:
1541:
1542: x_purge_rec.table_name := 'RCV_TRANSACTIONS_INTERFACE';
1543:
1544: if (p_option = REPORT_ONLY) then
1545: SELECT COUNT(*) INTO x_num_rows
1546: FROM RCV_TRANSACTIONS_INTERFACE

Line 1546: FROM RCV_TRANSACTIONS_INTERFACE

1542: x_purge_rec.table_name := 'RCV_TRANSACTIONS_INTERFACE';
1543:
1544: if (p_option = REPORT_ONLY) then
1545: SELECT COUNT(*) INTO x_num_rows
1546: FROM RCV_TRANSACTIONS_INTERFACE
1547: WHERE WIP_ENTITY_ID = x_purge_rec.wip_entity_id;
1548: else
1549: DELETE FROM RCV_TRANSACTIONS_INTERFACE
1550: WHERE WIP_ENTITY_ID = x_purge_rec.wip_entity_id;

Line 1549: DELETE FROM RCV_TRANSACTIONS_INTERFACE

1545: SELECT COUNT(*) INTO x_num_rows
1546: FROM RCV_TRANSACTIONS_INTERFACE
1547: WHERE WIP_ENTITY_ID = x_purge_rec.wip_entity_id;
1548: else
1549: DELETE FROM RCV_TRANSACTIONS_INTERFACE
1550: WHERE WIP_ENTITY_ID = x_purge_rec.wip_entity_id;
1551:
1552: x_num_rows := SQL%ROWCOUNT ;
1553:

Line 2178: x_purge_rec.table_name := 'RCV_TRANSACTIONS_INTERFACE';

2174: p_purge_rec => x_purge_rec);
2175: l_num_rows := 0;
2176:
2177:
2178: x_purge_rec.table_name := 'RCV_TRANSACTIONS_INTERFACE';
2179:
2180: -- Bug 4880984
2181: -- Added wip_entity_id filter to these SQLs to improve performance
2182: -- since an index based on wip_entity_id is available for

Line 2183: -- table rcv_transactions_interface

2179:
2180: -- Bug 4880984
2181: -- Added wip_entity_id filter to these SQLs to improve performance
2182: -- since an index based on wip_entity_id is available for
2183: -- table rcv_transactions_interface
2184: if (p_option = REPORT_ONLY) then
2185: SELECT COUNT(*) INTO x_num_rows
2186: FROM RCV_TRANSACTIONS_INTERFACE
2187: WHERE WIP_REPETITIVE_SCHEDULE_ID = x_purge_rec.schedule_id

Line 2186: FROM RCV_TRANSACTIONS_INTERFACE

2182: -- since an index based on wip_entity_id is available for
2183: -- table rcv_transactions_interface
2184: if (p_option = REPORT_ONLY) then
2185: SELECT COUNT(*) INTO x_num_rows
2186: FROM RCV_TRANSACTIONS_INTERFACE
2187: WHERE WIP_REPETITIVE_SCHEDULE_ID = x_purge_rec.schedule_id
2188: AND WIP_ENTITY_ID = x_purge_rec.wip_entity_id;
2189: else
2190: DELETE FROM RCV_TRANSACTIONS_INTERFACE

Line 2190: DELETE FROM RCV_TRANSACTIONS_INTERFACE

2186: FROM RCV_TRANSACTIONS_INTERFACE
2187: WHERE WIP_REPETITIVE_SCHEDULE_ID = x_purge_rec.schedule_id
2188: AND WIP_ENTITY_ID = x_purge_rec.wip_entity_id;
2189: else
2190: DELETE FROM RCV_TRANSACTIONS_INTERFACE
2191: WHERE WIP_REPETITIVE_SCHEDULE_ID = x_purge_rec.schedule_id
2192: AND WIP_ENTITY_ID = x_purge_rec.wip_entity_id;
2193: x_num_rows := SQL%ROWCOUNT ;
2194: end if ;