719: FORALL updCnt in l_deliveryDetailRowidTab.FIRST..l_deliveryDetailRowidTab.LAST
720: UPDATE Wsh_Delivery_Details Wdd
721: SET Customer_Id = l_customerIdTab(updCnt),
722: last_update_date = SYSDATE,
723: last_updated_by = fnd_global.user_id,
724: last_update_login = fnd_global.conc_login_id,
725: program_application_id = fnd_global.prog_appl_id,
726: program_id = fnd_global.conc_program_id,
727: program_update_date = SYSDATE
720: UPDATE Wsh_Delivery_Details Wdd
721: SET Customer_Id = l_customerIdTab(updCnt),
722: last_update_date = SYSDATE,
723: last_updated_by = fnd_global.user_id,
724: last_update_login = fnd_global.conc_login_id,
725: program_application_id = fnd_global.prog_appl_id,
726: program_id = fnd_global.conc_program_id,
727: program_update_date = SYSDATE
728: WHERE rowid = l_deliveryDetailRowidTab(updCnt);
721: SET Customer_Id = l_customerIdTab(updCnt),
722: last_update_date = SYSDATE,
723: last_updated_by = fnd_global.user_id,
724: last_update_login = fnd_global.conc_login_id,
725: program_application_id = fnd_global.prog_appl_id,
726: program_id = fnd_global.conc_program_id,
727: program_update_date = SYSDATE
728: WHERE rowid = l_deliveryDetailRowidTab(updCnt);
729:
722: last_update_date = SYSDATE,
723: last_updated_by = fnd_global.user_id,
724: last_update_login = fnd_global.conc_login_id,
725: program_application_id = fnd_global.prog_appl_id,
726: program_id = fnd_global.conc_program_id,
727: program_update_date = SYSDATE
728: WHERE rowid = l_deliveryDetailRowidTab(updCnt);
729:
730: --
796: UPDATE WSH_DELIVERY_ASSIGNMENTS
797: SET parent_delivery_detail_id = null,
798: delivery_id = null,
799: last_update_date = SYSDATE,
800: last_updated_by = fnd_global.user_id,
801: last_update_login = fnd_global.conc_login_id,
802: program_application_id = fnd_global.prog_appl_id,
803: program_id = fnd_global.conc_program_id,
804: program_update_date = SYSDATE
797: SET parent_delivery_detail_id = null,
798: delivery_id = null,
799: last_update_date = SYSDATE,
800: last_updated_by = fnd_global.user_id,
801: last_update_login = fnd_global.conc_login_id,
802: program_application_id = fnd_global.prog_appl_id,
803: program_id = fnd_global.conc_program_id,
804: program_update_date = SYSDATE
805: WHERE rowid = l_deliveryAssgRowidTab(unassignDelCnt);
798: delivery_id = null,
799: last_update_date = SYSDATE,
800: last_updated_by = fnd_global.user_id,
801: last_update_login = fnd_global.conc_login_id,
802: program_application_id = fnd_global.prog_appl_id,
803: program_id = fnd_global.conc_program_id,
804: program_update_date = SYSDATE
805: WHERE rowid = l_deliveryAssgRowidTab(unassignDelCnt);
806:
799: last_update_date = SYSDATE,
800: last_updated_by = fnd_global.user_id,
801: last_update_login = fnd_global.conc_login_id,
802: program_application_id = fnd_global.prog_appl_id,
803: program_id = fnd_global.conc_program_id,
804: program_update_date = SYSDATE
805: WHERE rowid = l_deliveryAssgRowidTab(unassignDelCnt);
806:
807: setARMessageRowCount( 'WSH_DELIVERY_ASSIGNMENTS', SQL%ROWCOUNT );
1018: x_exception_id => l_exception_id,
1019: p_exception_location_id => G_TO_LOCATION_ID,
1020: p_logged_at_location_id => G_TO_LOCATION_ID,
1021: p_logging_entity => 'SHIPPER',
1022: p_logging_entity_id => Fnd_Global.user_id,
1023: p_exception_name => 'WSH_CUSTOMER_MERGE_CHANGE',
1024: p_message => l_message_text,
1025: p_severity => 'LOW',
1026: p_manually_logged => 'N',
2026: x_exception_id => l_exception_id,
2027: p_exception_location_id => G_TO_LOCATION_ID,
2028: p_logged_at_location_id => G_TO_LOCATION_ID,
2029: p_logging_entity => 'SHIPPER',
2030: p_logging_entity_id => Fnd_Global.user_id,
2031: p_exception_name => 'WSH_CUSTOMER_MERGE_CHANGE',
2032: p_message => l_message_text,
2033: p_severity => 'LOW',
2034: p_manually_logged => 'N',
2759: x_exception_id => l_exception_id,
2760: p_exception_location_id => G_TO_LOCATION_ID,
2761: p_logged_at_location_id => G_TO_LOCATION_ID,
2762: p_logging_entity => 'SHIPPER',
2763: p_logging_entity_id => Fnd_Global.user_id,
2764: p_exception_name => 'WSH_CUSTOMER_MERGE_CHANGE',
2765: p_message => l_message_text,
2766: p_severity => 'LOW',
2767: p_manually_logged => 'N',