APPS.WSH_VENDOR_PARTY_MERGE_PKG dependencies on WSH_CALENDAR_ASSIGNMENTS

Line 1127: FROM wsh_calendar_assignments a

1123: calendar_assignment_id,
1124: vendor_site_id,
1125: association_type,
1126: freight_code
1127: FROM wsh_calendar_assignments a
1128: WHERE vendor_id = p_from_id
1129: AND vendor_site_id IS NULL;
1130:
1131: CURSOR check_site_calendar IS

Line 1139: FROM wsh_calendar_assignments a,

1135: a.association_type,
1136: a.freight_code,
1137: b.vendor_site_code,
1138: a.calendar_code
1139: FROM wsh_calendar_assignments a,
1140: po_vendor_sites_all b
1141: WHERE a.vendor_id = p_from_id
1142: AND a.vendor_site_id = p_from_site_id
1143: AND b.vendor_site_id = a.vendor_site_id;

Line 1152: FROM wsh_calendar_assignments

1148: p_association_type VARCHAR2,
1149: p_freight_code VARCHAR2 )
1150: IS
1151: SELECT 1
1152: FROM wsh_calendar_assignments
1153: WHERE vendor_id = p_vendor_id
1154: AND calendar_type=p_calendar_type
1155: AND nvl( vendor_site_id,-999999 ) = nvl( p_vendor_site_id,-999999 )
1156: AND association_type = p_association_type

Line 1187: FROM wsh_calendar_assignments

1183: CURSOR c_VendorLvlCalAsg(p_vendorID NUMBER,
1184: p_assnType VARCHAR2,
1185: p_caltype VARCHAR2) IS
1186: SELECT 1
1187: FROM wsh_calendar_assignments
1188: WHERE vendor_id = p_vendorID
1189: AND association_type = p_assnType
1190: AND calendar_type = p_calType
1191: AND vendor_site_id IS NULL;

Line 1302: UPDATE wsh_calendar_assignments

1298:
1299: IF (check_dup_assignment%NOTFOUND) THEN
1300: --{
1301: -- Update vendor site level assignments
1302: UPDATE wsh_calendar_assignments
1303: SET vendor_id = p_to_id,
1304: vendor_site_id = p_to_site_id,
1305: last_update_date = sysdate,
1306: last_updated_by = fnd_global.user_id,

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

1310: IF l_debug_on THEN
1311: --{
1312: WSH_DEBUG_SV.log(l_module_name, 'Calendar Assgn ID updated',
1313: check_site_calendar_rec.calendar_assignment_id);
1314: WSH_DEBUG_SV.logmsg(l_module_name,'Updated wsh_calendar_assignments. Number of Rows updated is ' || sql%rowcount, WSH_DEBUG_SV.C_STMT_LEVEL);
1315: --}
1316: END IF;
1317: --
1318: -- Is there a vendor level calendar assignment ? If not, create one

Line 1373: DELETE wsh_calendar_assignments

1369:
1370: --}
1371: ELSE
1372: --{
1373: DELETE wsh_calendar_assignments
1374: WHERE calendar_assignment_id = check_site_calendar_rec.calendar_assignment_id;
1375: IF l_debug_on THEN
1376: --{
1377: WSH_DEBUG_SV.log(l_module_name, 'Calendar Assgn ID deleted',

Line 1379: 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);

1375: IF l_debug_on THEN
1376: --{
1377: WSH_DEBUG_SV.log(l_module_name, 'Calendar Assgn ID deleted',
1378: check_site_calendar_rec.calendar_assignment_id);
1379: 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);
1380: --}
1381: END IF;
1382:
1383: IF check_site_calendar_rec.freight_code IS NULL THEN