APPS.WIP_WICTPG dependencies on WIP_ENTITIES

Line 1941: x_purge_rec.table_name := 'WIP_ENTITIES';

1937: end if;
1938:
1939:
1940:
1941: x_purge_rec.table_name := 'WIP_ENTITIES';
1942:
1943: if (p_option = REPORT_ONLY) then
1944: SELECT COUNT(*) INTO x_num_rows
1945: FROM WIP_ENTITIES

Line 1945: FROM WIP_ENTITIES

1941: x_purge_rec.table_name := 'WIP_ENTITIES';
1942:
1943: if (p_option = REPORT_ONLY) then
1944: SELECT COUNT(*) INTO x_num_rows
1945: FROM WIP_ENTITIES
1946: WHERE WIP_ENTITY_ID = x_purge_rec.wip_entity_id;
1947: else
1948: DELETE FROM WIP_ENTITIES
1949: WHERE WIP_ENTITY_ID = x_purge_rec.wip_entity_id;

Line 1948: DELETE FROM WIP_ENTITIES

1944: SELECT COUNT(*) INTO x_num_rows
1945: FROM WIP_ENTITIES
1946: WHERE WIP_ENTITY_ID = x_purge_rec.wip_entity_id;
1947: else
1948: DELETE FROM WIP_ENTITIES
1949: WHERE WIP_ENTITY_ID = x_purge_rec.wip_entity_id;
1950: x_num_rows := SQL%ROWCOUNT ;
1951: end if ;
1952:

Line 2326: ' wip_entities we ' ||

2322: ' wdj.date_closed, ' ||
2323: ' wdj.status_type, ' ||
2324: ' wdj.organization_id ' ||
2325: ' from wip_discrete_jobs wdj, ' ||
2326: ' wip_entities we ' ||
2327: /* Fix for bug#4902938 - Convert Literal to Bind variable*/
2328: ' where we.organization_id = :l_organization_id' ||
2329: ' and we.organization_id = wdj.organization_id ' ||
2330: ' and wdj.status_type = 12 ' || -- WIP_CONSTANTS.CLOSED