APPS.WIP_WICTPG dependencies on PO_DISTRIBUTIONS_ARCHIVE_ALL

Line 1145: x_purge_rec.table_name := 'PO_DISTRIBUTIONS_ARCHIVE_ALL';

1141: append_report(x_purge_rec, p_option);
1142: end if;
1143:
1144:
1145: x_purge_rec.table_name := 'PO_DISTRIBUTIONS_ARCHIVE_ALL';
1146:
1147: SELECT COUNT(*)
1148: into x_records_returned
1149: FROM DUAL

Line 1152: FROM PO_DISTRIBUTIONS_ARCHIVE_ALL

1148: into x_records_returned
1149: FROM DUAL
1150: WHERE EXISTS
1151: (SELECT 1
1152: FROM PO_DISTRIBUTIONS_ARCHIVE_ALL
1153: WHERE WIP_ENTITY_ID = x_purge_rec.wip_entity_id);
1154:
1155: x_records_found := x_records_found OR (x_records_returned > 0);
1156:

Line 2058: x_purge_rec.table_name := 'PO_DISTRIBUTIONS_ARCHIVE_ALL';

2054: append_report(x_purge_rec, p_option);
2055: end if;
2056: l_num_rows := 0;
2057:
2058: x_purge_rec.table_name := 'PO_DISTRIBUTIONS_ARCHIVE_ALL';
2059: SELECT COUNT(*) into l_num_rows
2060: FROM DUAL
2061: WHERE EXISTS (SELECT 1
2062: FROM PO_DISTRIBUTIONS_ARCHIVE_ALL

Line 2062: FROM PO_DISTRIBUTIONS_ARCHIVE_ALL

2058: x_purge_rec.table_name := 'PO_DISTRIBUTIONS_ARCHIVE_ALL';
2059: SELECT COUNT(*) into l_num_rows
2060: FROM DUAL
2061: WHERE EXISTS (SELECT 1
2062: FROM PO_DISTRIBUTIONS_ARCHIVE_ALL
2063: WHERE WIP_REPETITIVE_SCHEDULE_ID = x_purge_rec.schedule_id
2064: and WIP_ENTITY_ID = x_purge_rec.wip_entity_id);
2065: x_records_found := x_records_found OR (l_num_rows > 0);
2066: if ( l_num_rows > 0 ) then