APPS.AMS_CAL_CRT_PVT dependencies on AMS_CALENDAR_CRITERIA

Line 86: SELECT ams_calendar_criteria_s.NEXTVAL

82: l_dummy NUMBER;
83: l_cal_crt_rec_rec cal_crt_rec_rec_type := p_cal_crt_rec_rec;
84:
85: CURSOR c_id IS
86: SELECT ams_calendar_criteria_s.NEXTVAL
87: FROM dual;
88: CURSOR c_id_exists (l_id IN NUMBER) IS
89: SELECT 1
90: FROM ams_calendar_criteria

Line 90: FROM ams_calendar_criteria

86: SELECT ams_calendar_criteria_s.NEXTVAL
87: FROM dual;
88: CURSOR c_id_exists (l_id IN NUMBER) IS
89: SELECT 1
90: FROM ams_calendar_criteria
91: WHERE criteria_id = l_id;
92: BEGIN
93: -- Standard Start of API savepoint
94: SAVEPOINT create_cal_crt_pvt;

Line 303: FROM ams_calendar_criteria

299: )
300: IS
301: CURSOR c_get_cal_crt(criteria_id NUMBER) IS
302: SELECT *
303: FROM ams_calendar_criteria
304: WHERE criteria_id = p_cal_crt_rec_rec.criteria_id;
305: -- Hint: Developer need to provide Where clause
306: L_API_NAME CONSTANT VARCHAR2(30) := 'Update_Cal_Crt';
307: L_API_VERSION_NUMBER CONSTANT NUMBER := 1.0;

Line 780: FROM ams_calendar_criteria

776: x_return_status OUT NOCOPY VARCHAR2)
777: IS
778: CURSOR c_criteria IS
779: SELECT 'X'
780: FROM ams_calendar_criteria
781: WHERE ( criteria_deleted = 'N'
782: AND object_type_code = p_cal_crt_rec_rec.object_type_code
783: AND DECODE(custom_setup_id, null, 1,
784: DECODE(p_cal_crt_rec_rec.custom_setup_id, null, 0, p_cal_crt_rec_rec.custom_setup_id)) =

Line 841: 'ams_calendar_criteria',

837: IF p_validation_mode = JTF_PLSQL_API.g_create
838: AND p_cal_crt_rec_rec.criteria_id IS NOT NULL
839: THEN
840: l_valid_flag := AMS_Utility_PVT.check_uniqueness(
841: 'ams_calendar_criteria',
842: 'criteria_id = ''' || p_cal_crt_rec_rec.criteria_id ||''''
843: );
844: END IF;
845:

Line 982: FROM ams_calendar_criteria

978: IS
979: l_return_status VARCHAR2(1);
980: CURSOR c_complete IS
981: SELECT *
982: FROM ams_calendar_criteria
983: WHERE criteria_id = p_cal_crt_rec_rec.criteria_id;
984: l_cal_crt_rec_rec c_complete%ROWTYPE;
985: BEGIN
986: x_complete_rec := p_cal_crt_rec_rec;