APPS.AMS_CAL_CRT_PKG dependencies on AMS_CALENDAR_CRITERIA

Line 72: INSERT INTO ams_calendar_criteria(

68:
69: px_object_version_number := nvl(px_object_version_number, 1);
70:
71:
72: INSERT INTO ams_calendar_criteria(
73: criteria_id,
74: object_type_code,
75: custom_setup_id,
76: activity_type_code,

Line 148: Update ams_calendar_criteria

144: p_object_version_number IN NUMBER)
145:
146: IS
147: BEGIN
148: Update ams_calendar_criteria
149: SET
150: criteria_id = DECODE( p_criteria_id, null, criteria_id, FND_API.G_MISS_NUM, null, p_criteria_id),
151: object_type_code = DECODE( p_object_type_code, null, object_type_code, FND_API.g_miss_char, null, p_object_type_code),
152: custom_setup_id = DECODE( p_custom_setup_id, null, custom_setup_id, FND_API.G_MISS_NUM, null, p_custom_setup_id),

Line 197: DELETE FROM ams_calendar_criteria

193: p_criteria_id NUMBER,
194: p_object_version_number NUMBER)
195: IS
196: BEGIN
197: DELETE FROM ams_calendar_criteria
198: WHERE criteria_id = p_criteria_id
199: AND object_version_number = p_object_version_number;
200: If (SQL%NOTFOUND) then
201: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 227: FROM ams_calendar_criteria

223: p_object_version_number NUMBER)
224: IS
225: CURSOR C IS
226: SELECT *
227: FROM ams_calendar_criteria
228: WHERE criteria_id = p_criteria_id
229: AND object_version_number = p_object_version_number
230: FOR UPDATE OF criteria_id NOWAIT;
231: Recinfo C%ROWTYPE;