APPS.WSH_PARTY_MERGE dependencies on WSH_CALENDAR_ASSIGNMENTS

Line 96: -- delete from wsh_calendar_assignments

92: -- (b) Check if both parties are Vendors
93: -- (c) If both from and to parties are vendors, then call
94: -- Update_Entities_During_Merge
95: -- (d) Else If fromVendor ID is not NULL, then
96: -- delete from wsh_calendar_assignments
97: --
98: OPEN c_GetVendorId(p_from_id);
99: FETCH c_GetVendorId INTO l_fromVendorID, l_fromSupName;
100: CLOSE c_GetVendorId;

Line 125: DELETE wsh_calendar_assignments

121: x_return_status := l_return_status;
122: --
123: ELSIF l_fromVendorID IS NOT NULL THEN
124: --
125: DELETE wsh_calendar_assignments
126: WHERE vendor_id = l_fromVendorID
127: AND vendor_site_id IS NULL;
128: --
129: END IF;

Line 721: FROM wsh_calendar_assignments a

717: calendar_assignment_id,
718: vendor_site_id,
719: association_type,
720: freight_code
721: FROM wsh_calendar_assignments a
722: WHERE vendor_id = p_from_id
723: AND vendor_site_id IS NULL;
724: --
725: CURSOR check_dup_assignment(p_vendor_id NUMBER,

Line 732: FROM wsh_calendar_assignments

728: p_association_type VARCHAR2,
729: p_freight_code VARCHAR2 )
730: IS
731: SELECT 1
732: FROM wsh_calendar_assignments
733: WHERE vendor_id = p_vendor_id
734: AND calendar_type=p_calendar_type
735: AND nvl( vendor_site_id,-999999 ) = nvl( p_vendor_site_id,-999999 )
736: AND association_type = p_association_type

Line 811: UPDATE wsh_calendar_assignments

807: IF (check_dup_assignment%NOTFOUND) THEN
808: --{
809: -- Update vendor level assignments
810: --
811: UPDATE wsh_calendar_assignments
812: SET vendor_id = p_to_id,
813: last_update_date = sysdate,
814: last_updated_by = fnd_global.user_id,
815: last_update_login = fnd_global.login_id

Line 828: DELETE wsh_calendar_assignments

824: --}
825: ELSE
826: --{
827: --
828: DELETE wsh_calendar_assignments
829: WHERE calendar_assignment_id = check_calendar_rec.calendar_assignment_id;
830: --
831: IF l_debug_on THEN
832: --