APPS.AMS_AGENDAS_PVT dependencies on AMS_AGENDAS_B

Line 70: SELECT ams_agendas_b_s.NEXTVAL

66: l_coordinator_id NUMBER;
67:
68:
69: CURSOR c_agenda_seq IS
70: SELECT ams_agendas_b_s.NEXTVAL
71: FROM DUAL;
72:
73: CURSOR c_agenda_count(l_agenda_id IN NUMBER) IS
74: SELECT count(*)

Line 80: FROM ams_agendas_b

76: WHERE agenda_id = l_agenda_id;
77:
78: CURSOR c_general_track IS
79: SELECT *
80: FROM ams_agendas_b
81: WHERE default_track_flag = 'Y'
82: AND active_flag = 'Y'
83: AND parent_id = p_agenda_rec.parent_id;
84:

Line 303: INSERT INTO AMS_AGENDAS_B

299: END IF;
300: END IF;
301:
302: ----------------------------create----------------------------
303: INSERT INTO AMS_AGENDAS_B
304: (
305: agenda_id,
306: setup_type_id,
307: last_update_date,

Line 816: UPDATE AMS_AGENDAS_B

812:
813:
814: -------------- Perform the database operation UPDATE----------------------
815:
816: UPDATE AMS_AGENDAS_B
817: SET
818: setup_type_id = l_agenda_rec.setup_type_id
819: ,last_update_date = sysdate
820: ,last_updated_by = FND_GLOBAL.User_Id

Line 982: FROM ams_agendas_b

978: l_count NUMBER;
979:
980: CURSOR c_agenda IS
981: SELECT *
982: FROM ams_agendas_b
983: WHERE agenda_id = p_agenda_id;
984:
985: CURSOR c_resources(l_session_id IN NUMBER) IS
986: SELECT activity_resource_id,object_version_number

Line 1093: UPDATE ams_agendas_b

1089: FETCH c_sessions INTO l_agenda_id, l_obj_ver_num ;
1090:
1091: WHILE c_sessions%FOUND LOOP
1092: /* Deleting the Seesion */
1093: UPDATE ams_agendas_b
1094: SET active_flag = 'N',
1095: object_version_number = object_version_number + 1
1096: WHERE agenda_id = l_agenda_id
1097: AND object_version_number = l_obj_ver_num;

Line 1136: UPDATE ams_agendas_b

1132:
1133: END IF;
1134:
1135: /* Deleting the Object (Track/Session) passed in */
1136: UPDATE ams_agendas_b
1137: SET active_flag = 'N',
1138: object_version_number = object_version_number + 1
1139: WHERE agenda_id = p_agenda_id
1140: AND object_version_number = p_object_version;

Line 1917: FROM ams_agendas_b

1913: SELECT count(event_offer_id)
1914: FROM ams_event_offers_all_b
1915: WHERE system_status_code IN ('COMPLETED', 'CANCELLED', 'ON_HOLD','ARCHIVED','CLOSED')
1916: AND event_offer_id = ( SELECT parent_id
1917: FROM ams_agendas_b
1918: WHERE agenda_id = p_agenda_rec.parent_id);
1919:
1920:
1921:

Line 2359: -- Replaced ams_agendas_v to AMS_AGENDAS_B Sikalyan Perfomance BugFix

2355: p_agenda_rec IN agenda_rec_type,
2356: x_agenda_rec OUT NOCOPY agenda_rec_type
2357: ) IS
2358:
2359: -- Replaced ams_agendas_v to AMS_AGENDAS_B Sikalyan Perfomance BugFix
2360:
2361: CURSOR c_agenda IS
2362: SELECT *
2363: FROM AMS_AGENDAS_B

Line 2363: FROM AMS_AGENDAS_B

2359: -- Replaced ams_agendas_v to AMS_AGENDAS_B Sikalyan Perfomance BugFix
2360:
2361: CURSOR c_agenda IS
2362: SELECT *
2363: FROM AMS_AGENDAS_B
2364: WHERE agenda_id = p_agenda_rec.agenda_id;
2365:
2366: l_agenda_rec c_agenda%ROWTYPE;
2367:

Line 2564: UPDATE ams_agendas_b

2560: FETCH c_min_max_times INTO l_min_time, l_max_time;
2561: CLOSE c_min_max_times;
2562:
2563: /* Rolling up times to Track level */
2564: UPDATE ams_agendas_b
2565: SET start_date_time = l_min_time,
2566: end_date_time = l_max_time,
2567: object_version_number = object_version_number + 1
2568: WHERE agenda_id = l_parent_id;

Line 2624: from ams_agendas_b B

2620: begin
2621: delete from ams_agendas_tl T
2622: where not exists
2623: (select NULL
2624: from ams_agendas_b B
2625: where B.AGENDA_ID = T.AGENDA_ID
2626: );
2627:
2628: update ams_agendas_tl T set (