290: , l_already_shipped
291: , l_f_shipped_qty
292: , l_f_unit_code
293: , SYSDATE
294: , FND_GLOBAL.USER_ID
295: , SYSDATE
296: , FND_GLOBAL.USER_ID);
297:
298: -- For this picking line, add the order line to temp table if it hasn't
292: , l_f_unit_code
293: , SYSDATE
294: , FND_GLOBAL.USER_ID
295: , SYSDATE
296: , FND_GLOBAL.USER_ID);
297:
298: -- For this picking line, add the order line to temp table if it hasn't
299: -- already been added
300: --
584: , NSLINE.component_ratio
585: , NSLINE.component_sequence_id
586: , NSLINE.unit_code
587: , SYSDATE
588: , FND_GLOBAL.USER_ID
589: , SYSDATE
590: , FND_GLOBAL.USER_ID);
591:
592: END LOOP;
586: , NSLINE.unit_code
587: , SYSDATE
588: , FND_GLOBAL.USER_ID
589: , SYSDATE
590: , FND_GLOBAL.USER_ID);
591:
592: END LOOP;
593:
594: EXCEPTION WHEN OTHERS THEN
882: , l_ordered_quantity
883: , l_selling_price
884: , l_unit_code
885: , SYSDATE
886: , FND_GLOBAL.user_id
887: , SYSDATE
888: , FND_GLOBAL.user_id
889: FROM DUAL
890: WHERE NOT EXISTS
884: , l_unit_code
885: , SYSDATE
886: , FND_GLOBAL.user_id
887: , SYSDATE
888: , FND_GLOBAL.user_id
889: FROM DUAL
890: WHERE NOT EXISTS
891: (SELECT 'ALREADY EXISTS IN TEMP TABLE'
892: FROM WSH_REPORT_TEMP
1029: , l_ordered_quantity
1030: , l_selling_price
1031: , l_unit_code
1032: , SYSDATE
1033: , FND_GLOBAL.user_id
1034: , SYSDATE
1035: , FND_GLOBAL.user_id
1036: FROM DUAL
1037: WHERE NOT EXISTS
1031: , l_unit_code
1032: , SYSDATE
1033: , FND_GLOBAL.user_id
1034: , SYSDATE
1035: , FND_GLOBAL.user_id
1036: FROM DUAL
1037: WHERE NOT EXISTS
1038: (SELECT 'ALREADY EXISTS IN TEMP TABLE'
1039: FROM WSH_REPORT_TEMP