844: , null
845: , null
846: , null
847: , sysdate
848: , FND_GLOBAL.user_id
849: , sysdate
850: , FND_GLOBAL.user_id
851: , FND_GLOBAL.user_id
852: , null
846: , null
847: , sysdate
848: , FND_GLOBAL.user_id
849: , sysdate
850: , FND_GLOBAL.user_id
851: , FND_GLOBAL.user_id
852: , null
853: , null
854: , null
847: , sysdate
848: , FND_GLOBAL.user_id
849: , sysdate
850: , FND_GLOBAL.user_id
851: , FND_GLOBAL.user_id
852: , null
853: , null
854: , null
855: , null
2114: END IF;
2115:
2116: update wsh_delivery_details dd
2117: set inv_interfaced_flag = 'Y',
2118: program_application_id = FND_GLOBAL.Prog_Appl_Id,
2119: program_id = FND_GLOBAL.Conc_Program_Id,
2120: request_id = FND_GLOBAL.Conc_Request_Id,
2121: program_update_date = sysdate,
2122: last_update_date = sysdate,
2115:
2116: update wsh_delivery_details dd
2117: set inv_interfaced_flag = 'Y',
2118: program_application_id = FND_GLOBAL.Prog_Appl_Id,
2119: program_id = FND_GLOBAL.Conc_Program_Id,
2120: request_id = FND_GLOBAL.Conc_Request_Id,
2121: program_update_date = sysdate,
2122: last_update_date = sysdate,
2123: last_updated_by = fnd_global.user_id,
2116: update wsh_delivery_details dd
2117: set inv_interfaced_flag = 'Y',
2118: program_application_id = FND_GLOBAL.Prog_Appl_Id,
2119: program_id = FND_GLOBAL.Conc_Program_Id,
2120: request_id = FND_GLOBAL.Conc_Request_Id,
2121: program_update_date = sysdate,
2122: last_update_date = sysdate,
2123: last_updated_by = fnd_global.user_id,
2124: last_update_login = fnd_global.login_id
2119: program_id = FND_GLOBAL.Conc_Program_Id,
2120: request_id = FND_GLOBAL.Conc_Request_Id,
2121: program_update_date = sysdate,
2122: last_update_date = sysdate,
2123: last_updated_by = fnd_global.user_id,
2124: last_update_login = fnd_global.login_id
2125: where delivery_detail_id = p_detail_rows(i)
2126: and source_code NOT IN ('OE','OKE', 'WSH');
2127:
2120: request_id = FND_GLOBAL.Conc_Request_Id,
2121: program_update_date = sysdate,
2122: last_update_date = sysdate,
2123: last_updated_by = fnd_global.user_id,
2124: last_update_login = fnd_global.login_id
2125: where delivery_detail_id = p_detail_rows(i)
2126: and source_code NOT IN ('OE','OKE', 'WSH');
2127:
2128: END LOOP;