eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

[Home] [Help]

APPS.IEC_VALIDATE_PVT dependencies on IEC_O_VALIDATION_REPORT_DETS

Line 4242: 'UPDATE IEC_O_VALIDATION_REPORT_DETS A

4238: BEGIN
4239:
4240: EXECUTE IMMEDIATE
4241:
4242: 'UPDATE IEC_O_VALIDATION_REPORT_DETS A
4243:
4244: SET
4245:
4246: ( DO_NOT_USE_REASON_S1

Line 4312: 'DELETE IEC_O_VALIDATION_REPORT_DETS

4308: BEGIN
4309:
4310: EXECUTE IMMEDIATE
4311:
4312: 'DELETE IEC_O_VALIDATION_REPORT_DETS
4313:
4314: WHERE LIST_HEADER_ID = :list_id
4315:
4316: AND LIST_ENTRY_ID IN (SELECT LIST_ENTRY_ID FROM IEC_VAL_ENTRY_CACHE)

Line 4354: 'INSERT INTO IEC_O_VALIDATION_REPORT_DETS

4350: BEGIN
4351:
4352: EXECUTE IMMEDIATE
4353:
4354: 'INSERT INTO IEC_O_VALIDATION_REPORT_DETS
4355:
4356: ( LIST_HEADER_ID
4357:
4358: , LIST_ENTRY_ID

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

4406: , :login_id
4407:
4408: FROM IEC_VAL_ENTRY_CACHE
4409:
4410: WHERE LIST_ENTRY_ID NOT IN (SELECT LIST_ENTRY_ID FROM IEC_O_VALIDATION_REPORT_DETS WHERE LIST_HEADER_ID = :list_id)
4411:
4412: AND ( DO_NOT_USE_REASON_S1 IS NOT NULL
4413:
4414: OR DO_NOT_USE_REASON_S2 IS NOT NULL

Line 8334: -- Delete IEC_O_VALIDATION_REPORT_DETS

8330: , IN l_returns_id_col;
8331:
8332:
8333:
8334: -- Delete IEC_O_VALIDATION_REPORT_DETS
8335:
8336: EXECUTE IMMEDIATE
8337:
8338: 'BEGIN

Line 8342: DELETE IEC_O_VALIDATION_REPORT_DETS

8338: 'BEGIN
8339:
8340: FORALL i IN :first .. :last
8341:
8342: DELETE IEC_O_VALIDATION_REPORT_DETS
8343:
8344: WHERE LIST_HEADER_ID = :list_id
8345:
8346: AND LIST_ENTRY_ID = :list_entry_id(i);

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

8496: END IF;
8497:
8498:
8499:
8500: -- Also need to delete records from IEC_O_VALIDATION_REPORT_DETS
8501:
8502: -- when all contact points were invalid and there is no corresponding
8503:
8504: -- entry in return entries

Line 8508: 'DELETE IEC_O_VALIDATION_REPORT_DETS

8504: -- entry in return entries
8505:
8506: EXECUTE IMMEDIATE
8507:
8508: 'DELETE IEC_O_VALIDATION_REPORT_DETS
8509:
8510: WHERE LIST_HEADER_ID = :list_id
8511:
8512: AND DO_NOT_USE_REASON_S1 IS NOT NULL

Line 10957: FROM IEC_O_VALIDATION_REPORT_DETS

10953: WHERE LIST_HEADER_ID = p_list_id; */
10954:
10955: SELECT COUNT(*) RECORDS_INVALID
10956: into l_record_invalid
10957: FROM IEC_O_VALIDATION_REPORT_DETS
10958: WHERE ( DO_NOT_USE_REASON_S1 IS NOT NULL AND
10959: DO_NOT_USE_REASON_S2 IS NOT NULL AND
10960: DO_NOT_USE_REASON_S3 IS NOT NULL AND
10961: DO_NOT_USE_REASON_S4 IS NOT NULL AND

Line 15076: FROM IEC_O_VALIDATION_REPORT_DETS

15072: EXECUTE IMMEDIATE
15073:
15074: 'SELECT DO_NOT_USE_REASON_S1
15075:
15076: FROM IEC_O_VALIDATION_REPORT_DETS
15077:
15078: WHERE LIST_HEADER_ID = :list_id
15079:
15080: AND LIST_ENTRY_ID = :list_entry_id'