APPS.IEC_VALIDATE_PVT dependencies on IEC_O_VALIDATION_REPORT_DETS

Line 4264: 'UPDATE IEC_O_VALIDATION_REPORT_DETS A

4260: BEGIN
4261:
4262: EXECUTE IMMEDIATE
4263:
4264: 'UPDATE IEC_O_VALIDATION_REPORT_DETS A
4265:
4266: SET
4267:
4268: ( DO_NOT_USE_REASON_S1

Line 4334: 'DELETE IEC_O_VALIDATION_REPORT_DETS

4330: BEGIN
4331:
4332: EXECUTE IMMEDIATE
4333:
4334: 'DELETE IEC_O_VALIDATION_REPORT_DETS
4335:
4336: WHERE LIST_HEADER_ID = :list_id
4337:
4338: AND LIST_ENTRY_ID IN (SELECT LIST_ENTRY_ID FROM IEC_VAL_ENTRY_CACHE)

Line 4376: 'INSERT INTO IEC_O_VALIDATION_REPORT_DETS

4372: BEGIN
4373:
4374: EXECUTE IMMEDIATE
4375:
4376: 'INSERT INTO IEC_O_VALIDATION_REPORT_DETS
4377:
4378: ( LIST_HEADER_ID
4379:
4380: , LIST_ENTRY_ID

Line 4432: WHERE LIST_ENTRY_ID NOT IN (SELECT LIST_ENTRY_ID FROM IEC_O_VALIDATION_REPORT_DETS WHERE LIST_HEADER_ID = :list_id)

4428: , :login_id
4429:
4430: FROM IEC_VAL_ENTRY_CACHE
4431:
4432: WHERE LIST_ENTRY_ID NOT IN (SELECT LIST_ENTRY_ID FROM IEC_O_VALIDATION_REPORT_DETS WHERE LIST_HEADER_ID = :list_id)
4433:
4434: AND ( DO_NOT_USE_REASON_S1 IS NOT NULL
4435:
4436: OR DO_NOT_USE_REASON_S2 IS NOT NULL

Line 8356: -- Delete IEC_O_VALIDATION_REPORT_DETS

8352: , IN l_returns_id_col;
8353:
8354:
8355:
8356: -- Delete IEC_O_VALIDATION_REPORT_DETS
8357:
8358: EXECUTE IMMEDIATE
8359:
8360: 'BEGIN

Line 8364: DELETE IEC_O_VALIDATION_REPORT_DETS

8360: 'BEGIN
8361:
8362: FORALL i IN :first .. :last
8363:
8364: DELETE IEC_O_VALIDATION_REPORT_DETS
8365:
8366: WHERE LIST_HEADER_ID = :list_id
8367:
8368: AND LIST_ENTRY_ID = :list_entry_id(i);

Line 8522: -- Also need to delete records from IEC_O_VALIDATION_REPORT_DETS

8518: END IF;
8519:
8520:
8521:
8522: -- Also need to delete records from IEC_O_VALIDATION_REPORT_DETS
8523:
8524: -- when all contact points were invalid and there is no corresponding
8525:
8526: -- entry in return entries

Line 8530: 'DELETE IEC_O_VALIDATION_REPORT_DETS

8526: -- entry in return entries
8527:
8528: EXECUTE IMMEDIATE
8529:
8530: 'DELETE IEC_O_VALIDATION_REPORT_DETS
8531:
8532: WHERE LIST_HEADER_ID = :list_id
8533:
8534: AND DO_NOT_USE_REASON_S1 IS NOT NULL

Line 10979: FROM IEC_O_VALIDATION_REPORT_DETS

10975: WHERE LIST_HEADER_ID = p_list_id; */
10976:
10977: SELECT COUNT(*) RECORDS_INVALID
10978: into l_record_invalid
10979: FROM IEC_O_VALIDATION_REPORT_DETS
10980: WHERE ( DO_NOT_USE_REASON_S1 IS NOT NULL AND
10981: DO_NOT_USE_REASON_S2 IS NOT NULL AND
10982: DO_NOT_USE_REASON_S3 IS NOT NULL AND
10983: DO_NOT_USE_REASON_S4 IS NOT NULL AND

Line 15098: FROM IEC_O_VALIDATION_REPORT_DETS

15094: EXECUTE IMMEDIATE
15095:
15096: 'SELECT DO_NOT_USE_REASON_S1
15097:
15098: FROM IEC_O_VALIDATION_REPORT_DETS
15099:
15100: WHERE LIST_HEADER_ID = :list_id
15101:
15102: AND LIST_ENTRY_ID = :list_entry_id'