APPS.WIP_WICTPG dependencies on RCV_TRANSACTIONS

Line 1181: x_purge_rec.table_name := 'RCV_TRANSACTIONS';

1177: end if;
1178:
1179:
1180:
1181: x_purge_rec.table_name := 'RCV_TRANSACTIONS';
1182:
1183: SELECT COUNT(*)
1184: into x_records_returned
1185: FROM DUAL

Line 1188: FROM RCV_TRANSACTIONS

1184: into x_records_returned
1185: FROM DUAL
1186: WHERE EXISTS
1187: (SELECT 1
1188: FROM RCV_TRANSACTIONS
1189: WHERE WIP_ENTITY_ID = x_purge_rec.wip_entity_id );
1190:
1191: x_records_found := x_records_found OR (x_records_returned > 0);
1192:

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 2085: x_purge_rec.table_name := 'RCV_TRANSACTIONS';

2081: end if;
2082: l_num_rows := 0;
2083:
2084:
2085: x_purge_rec.table_name := 'RCV_TRANSACTIONS';
2086: SELECT COUNT(*) into l_num_rows
2087: FROM DUAL
2088: WHERE EXISTS (SELECT 1
2089: FROM RCV_TRANSACTIONS

Line 2089: FROM RCV_TRANSACTIONS

2085: x_purge_rec.table_name := 'RCV_TRANSACTIONS';
2086: SELECT COUNT(*) into l_num_rows
2087: FROM DUAL
2088: WHERE EXISTS (SELECT 1
2089: FROM RCV_TRANSACTIONS
2090: WHERE WIP_REPETITIVE_SCHEDULE_ID = x_purge_rec.schedule_id
2091: AND WIP_ENTITY_ID = x_purge_rec.wip_entity_id);
2092: x_records_found := x_records_found OR (l_num_rows > 0);
2093: if ( l_num_rows > 0 ) then

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 ;