APPS.WSH_CAL_ASG_PKG dependencies on WSH_CALENDAR_ASSIGNMENTS

Line 36: SELECT WSH_CALENDAR_ASSIGNMENTS_S.NextVal

32: l_api_version_number CONSTANT NUMBER := 1.0;
33: l_api_name CONSTANT VARCHAR2(30):= 'Create_Cal_Asg';
34:
35: CURSOR get_cal_id IS
36: SELECT WSH_CALENDAR_ASSIGNMENTS_S.NextVal
37: FROM sys.dual;
38:
39: l_cal_id NUMBER;
40:

Line 103: INSERT INTO WSH_CALENDAR_ASSIGNMENTS

99: CLOSE get_cal_id;
100:
101: x_Calendar_Aassignment_Id := l_cal_id;
102:
103: INSERT INTO WSH_CALENDAR_ASSIGNMENTS
104: (CALENDAR_ASSIGNMENT_ID,
105: CALENDAR_CODE,
106: CALENDAR_TYPE,
107: ASSOCIATION_TYPE,

Line 322: UPDATE WSH_CALENDAR_ASSIGNMENTS

318: FND_MSG_PUB.initialize;
319: END IF;
320:
321: --
322: UPDATE WSH_CALENDAR_ASSIGNMENTS
323: SET ENABLED_FLAG = p_cal_asg_info.enabled_flag
324: , CALENDAR_CODE = p_cal_asg_info.calendar_code
325: , ATTRIBUTE_CATEGORY = p_cal_asg_info.ATTRIBUTE_CATEGORY
326: , ATTRIBUTE1 = p_cal_asg_info.ATTRIBUTE1

Line 450: FROM wsh_calendar_assignments

446: ATTRIBUTE12,
447: ATTRIBUTE13,
448: ATTRIBUTE14,
449: ATTRIBUTE15
450: FROM wsh_calendar_assignments
451: WHERE calendar_assignment_id = p_calendar_assignment_id
452: FOR UPDATE OF calendar_assignment_id NOWAIT;
453:
454: Recinfo lock_row%ROWTYPE;

Line 614: DELETE FROM wsh_calendar_assignments

610: WSH_DEBUG_SV.log(l_module_name,'P_CALENDAR_ASSIGNMENT_ID',P_CALENDAR_ASSIGNMENT_ID);
611: END IF;
612: --
613: IF p_calendar_assignment_id IS NOT NULL THEN
614: DELETE FROM wsh_calendar_assignments
615: WHERE calendar_assignment_id = p_calendar_assignment_id;
616: END IF;
617: --
618: -- Debug Statements