APPS.WSH_VENDOR_PARTY_MERGE_PKG dependencies on WSH_CALENDAR_ASSIGNMENTS

Line 1120: FROM wsh_calendar_assignments a

1116: calendar_assignment_id,
1117: vendor_site_id,
1118: association_type,
1119: freight_code
1120: FROM wsh_calendar_assignments a
1121: WHERE vendor_id = p_from_id
1122: AND vendor_site_id IS NULL;
1123:
1124: CURSOR check_site_calendar IS

Line 1132: FROM wsh_calendar_assignments a,

1128: a.association_type,
1129: a.freight_code,
1130: b.vendor_site_code,
1131: a.calendar_code
1132: FROM wsh_calendar_assignments a,
1133: po_vendor_sites_all b
1134: WHERE a.vendor_id = p_from_id
1135: AND a.vendor_site_id = p_from_site_id
1136: AND b.vendor_site_id = a.vendor_site_id;

Line 1145: FROM wsh_calendar_assignments

1141: p_association_type VARCHAR2,
1142: p_freight_code VARCHAR2 )
1143: IS
1144: SELECT 1
1145: FROM wsh_calendar_assignments
1146: WHERE vendor_id = p_vendor_id
1147: AND calendar_type=p_calendar_type
1148: AND nvl( vendor_site_id,-999999 ) = nvl( p_vendor_site_id,-999999 )
1149: AND association_type = p_association_type

Line 1180: FROM wsh_calendar_assignments

1176: CURSOR c_VendorLvlCalAsg(p_vendorID NUMBER,
1177: p_assnType VARCHAR2,
1178: p_caltype VARCHAR2) IS
1179: SELECT 1
1180: FROM wsh_calendar_assignments
1181: WHERE vendor_id = p_vendorID
1182: AND association_type = p_assnType
1183: AND calendar_type = p_calType
1184: AND vendor_site_id IS NULL;

Line 1295: UPDATE wsh_calendar_assignments

1291:
1292: IF (check_dup_assignment%NOTFOUND) THEN
1293: --{
1294: -- Update vendor site level assignments
1295: UPDATE wsh_calendar_assignments
1296: SET vendor_id = p_to_id,
1297: vendor_site_id = p_to_site_id,
1298: last_update_date = sysdate,
1299: last_updated_by = fnd_global.user_id,

Line 1307: WSH_DEBUG_SV.logmsg(l_module_name,'Updated wsh_calendar_assignments. Number of Rows updated is ' || sql%rowcount, WSH_DEBUG_SV.C_STMT_LEVEL);

1303: IF l_debug_on THEN
1304: --{
1305: WSH_DEBUG_SV.log(l_module_name, 'Calendar Assgn ID updated',
1306: check_site_calendar_rec.calendar_assignment_id);
1307: WSH_DEBUG_SV.logmsg(l_module_name,'Updated wsh_calendar_assignments. Number of Rows updated is ' || sql%rowcount, WSH_DEBUG_SV.C_STMT_LEVEL);
1308: --}
1309: END IF;
1310: --
1311: -- Is there a vendor level calendar assignment ? If not, create one

Line 1366: DELETE wsh_calendar_assignments

1362:
1363: --}
1364: ELSE
1365: --{
1366: DELETE wsh_calendar_assignments
1367: WHERE calendar_assignment_id = check_site_calendar_rec.calendar_assignment_id;
1368: IF l_debug_on THEN
1369: --{
1370: WSH_DEBUG_SV.log(l_module_name, 'Calendar Assgn ID deleted',

Line 1372: WSH_DEBUG_SV.logmsg(l_module_name,'Deleted record(s) from wsh_calendar_assignments. Number of Rows deleted is ' || sql%rowcount, WSH_DEBUG_SV.C_STMT_LEVEL);

1368: IF l_debug_on THEN
1369: --{
1370: WSH_DEBUG_SV.log(l_module_name, 'Calendar Assgn ID deleted',
1371: check_site_calendar_rec.calendar_assignment_id);
1372: WSH_DEBUG_SV.logmsg(l_module_name,'Deleted record(s) from wsh_calendar_assignments. Number of Rows deleted is ' || sql%rowcount, WSH_DEBUG_SV.C_STMT_LEVEL);
1373: --}
1374: END IF;
1375:
1376: IF check_site_calendar_rec.freight_code IS NULL THEN