DBA Data[Home] [Help]

APPS.WIP_WICTPG dependencies on PO_REQUISITION_LINES_ALL

Line 1163: x_purge_rec.table_name := 'PO_REQUISITION_LINES_ALL';

1159: end if;
1160:
1161:
1162:
1163: x_purge_rec.table_name := 'PO_REQUISITION_LINES_ALL';
1164:
1165: SELECT COUNT(*)
1166: into x_records_returned
1167: FROM DUAL

Line 1170: FROM PO_REQUISITION_LINES_ALL

1166: into x_records_returned
1167: FROM DUAL
1168: WHERE EXISTS
1169: (SELECT 1
1170: FROM PO_REQUISITION_LINES_ALL
1171: WHERE WIP_ENTITY_ID = x_purge_rec.wip_entity_id );
1172:
1173: x_records_found := x_records_found OR (x_records_returned > 0);
1174:

Line 2071: x_purge_rec.table_name := 'PO_REQUISITION_LINES_ALL';

2067: append_report(x_purge_rec, p_option);
2068: end if;
2069: l_num_rows := 0;
2070:
2071: x_purge_rec.table_name := 'PO_REQUISITION_LINES_ALL';
2072: SELECT COUNT(*) into l_num_rows
2073: FROM DUAL
2074: WHERE EXISTS (SELECT 1
2075: FROM PO_REQUISITION_LINES_ALL

Line 2075: FROM PO_REQUISITION_LINES_ALL

2071: x_purge_rec.table_name := 'PO_REQUISITION_LINES_ALL';
2072: SELECT COUNT(*) into l_num_rows
2073: FROM DUAL
2074: WHERE EXISTS (SELECT 1
2075: FROM PO_REQUISITION_LINES_ALL
2076: WHERE WIP_REPETITIVE_SCHEDULE_ID = x_purge_rec.schedule_id
2077: AND WIP_ENTITY_ID = x_purge_rec.wip_entity_id);
2078: x_records_found := x_records_found OR (l_num_rows > 0);
2079: if ( l_num_rows > 0 ) then