53: UPDATE csd_repairs
54: SET repair_mode = 'WIP',
55: auto_process_rma = 'N',
56: last_update_date = sysdate,
57: last_updated_by = fnd_global.user_id,
58: last_update_login = fnd_global.login_id
59: WHERE rowid = rowid_mig(j);
60: IF SQL%NOTFOUND then
61: Raise error_process;
54: SET repair_mode = 'WIP',
55: auto_process_rma = 'N',
56: last_update_date = sysdate,
57: last_updated_by = fnd_global.user_id,
58: last_update_login = fnd_global.login_id
59: WHERE rowid = rowid_mig(j);
60: IF SQL%NOTFOUND then
61: Raise error_process;
62: End If;
377: ,l_prod_txn_status
378: ,l_prod_txn_code
379: ,sysdate
380: ,l_creation_date
381: ,FND_GLOBAL.USER_ID
382: ,FND_GLOBAL.USER_ID
383: ,FND_GLOBAL.LOGIN_ID
384: ,NULL
385: ,NULL
378: ,l_prod_txn_code
379: ,sysdate
380: ,l_creation_date
381: ,FND_GLOBAL.USER_ID
382: ,FND_GLOBAL.USER_ID
383: ,FND_GLOBAL.LOGIN_ID
384: ,NULL
385: ,NULL
386: ,NULL
379: ,sysdate
380: ,l_creation_date
381: ,FND_GLOBAL.USER_ID
382: ,FND_GLOBAL.USER_ID
383: ,FND_GLOBAL.LOGIN_ID
384: ,NULL
385: ,NULL
386: ,NULL
387: ,NULL
620: ,l_work_summary
621: ,l_lead_time
622: ,l_lead_time_uom
623: ,l_estimate_date
624: ,FND_GLOBAL.USER_ID
625: ,FND_GLOBAL.USER_ID
626: ,sysdate
627: ,FND_GLOBAL.LOGIN_ID
628: ,1
621: ,l_lead_time
622: ,l_lead_time_uom
623: ,l_estimate_date
624: ,FND_GLOBAL.USER_ID
625: ,FND_GLOBAL.USER_ID
626: ,sysdate
627: ,FND_GLOBAL.LOGIN_ID
628: ,1
629: ,l_estimate_freeze_flag);
623: ,l_estimate_date
624: ,FND_GLOBAL.USER_ID
625: ,FND_GLOBAL.USER_ID
626: ,sysdate
627: ,FND_GLOBAL.LOGIN_ID
628: ,1
629: ,l_estimate_freeze_flag);
630:
631: EXCEPTION
787: VALUES (
788: CSD_REPAIR_ESTIMATE_LINES_S1.nextval
789: ,l_repair_estimate_id
790: ,l_creation_date
791: ,FND_GLOBAL.USER_ID
792: ,FND_GLOBAL.USER_ID
793: ,sysdate
794: ,FND_GLOBAL.LOGIN_ID
795: ,1
788: CSD_REPAIR_ESTIMATE_LINES_S1.nextval
789: ,l_repair_estimate_id
790: ,l_creation_date
791: ,FND_GLOBAL.USER_ID
792: ,FND_GLOBAL.USER_ID
793: ,sysdate
794: ,FND_GLOBAL.LOGIN_ID
795: ,1
796: ,l_estimate_detail_id
790: ,l_creation_date
791: ,FND_GLOBAL.USER_ID
792: ,FND_GLOBAL.USER_ID
793: ,sysdate
794: ,FND_GLOBAL.LOGIN_ID
795: ,1
796: ,l_estimate_detail_id
797: ,l_item_cost);
798: EXCEPTION
893: BEGIN
894: UPDATE csd_repair_job_xref
895: SET inventory_item_id = inventory_item_id_mig(j),
896: last_update_date = sysdate,
897: last_update_login = fnd_global.login_id,
898: last_updated_by = fnd_global.user_id
899: WHERE rowid = rowid_mig(j);
900: EXCEPTION
901: WHEN OTHERS THEN
894: UPDATE csd_repair_job_xref
895: SET inventory_item_id = inventory_item_id_mig(j),
896: last_update_date = sysdate,
897: last_update_login = fnd_global.login_id,
898: last_updated_by = fnd_global.user_id
899: WHERE rowid = rowid_mig(j);
900: EXCEPTION
901: WHEN OTHERS THEN
902: -- when errored rollback and insert the message into
1000: book_sales_order_flag = l_book_sales_order_flag,
1001: release_sales_order_flag = l_release_sales_order_flag,
1002: seeded_flag = l_seeded_flag,
1003: last_update_date = sysdate,
1004: last_update_login = fnd_global.login_id,
1005: last_updated_by = fnd_global.user_id
1006: WHERE rowid = rowid_mig(j);
1007: EXCEPTION
1008: WHEN OTHERS THEN
1001: release_sales_order_flag = l_release_sales_order_flag,
1002: seeded_flag = l_seeded_flag,
1003: last_update_date = sysdate,
1004: last_update_login = fnd_global.login_id,
1005: last_updated_by = fnd_global.user_id
1006: WHERE rowid = rowid_mig(j);
1007: EXCEPTION
1008: WHEN OTHERS THEN
1009: -- when errored rollback and insert the message into