[Home] [Help]
71: FROM DUAL;
72:
73: CURSOR c_agenda_count(l_agenda_id IN NUMBER) IS
74: SELECT count(*)
75: FROM ams_agendas_v
76: WHERE agenda_id = l_agenda_id;
77:
78: CURSOR c_general_track IS
79: SELECT *
91: WHERE event_offer_id = id_in;
92:
93: CURSOR c_event_id(id_in IN NUMBER) IS
94: SELECT parent_id
95: FROM ams_agendas_v
96: WHERE agenda_id = id_in ;
97:
98:
99: CURSOR c_track_coordinator IS
97:
98:
99: CURSOR c_track_coordinator IS
100: SELECT coordinator_id
101: FROM ams_agendas_v
102: WHERE agenda_id = p_agenda_rec.parent_id;
103:
104: CURSOR c_event_timezone(id_in IN NUMBER) IS
105: SELECT timezone_id
523: AND resource_id = p_agenda_rec.coordinator_id;
524:
525: CURSOR c_olddate IS
526: SELECT start_date_time, end_date_time
527: FROM ams_agendas_v
528: WHERE agenda_id = p_agenda_rec.agenda_id;
529:
530:
531: BEGIN
991: SELECT count(event_offer_id)
992: FROM ams_event_offers_vl
993: WHERE system_status_code IN ('COMPLETED', 'CANCELLED', 'ON_HOLD','ARCHIVED','CLOSED')
994: AND event_offer_id = ( SELECT parent_id
995: FROM ams_agendas_v
996: WHERE agenda_id = ( SELECT parent_id
997: FROM ams_agendas_v
998: WHERE agenda_id = p_agenda_id));
999:
993: WHERE system_status_code IN ('COMPLETED', 'CANCELLED', 'ON_HOLD','ARCHIVED','CLOSED')
994: AND event_offer_id = ( SELECT parent_id
995: FROM ams_agendas_v
996: WHERE agenda_id = ( SELECT parent_id
997: FROM ams_agendas_v
998: WHERE agenda_id = p_agenda_id));
999:
1000: CURSOR c_sessions IS
1001: SELECT agenda_id, object_version_number
998: WHERE agenda_id = p_agenda_id));
999:
1000: CURSOR c_sessions IS
1001: SELECT agenda_id, object_version_number
1002: FROM ams_agendas_v
1003: WHERE parent_id = p_agenda_id;
1004:
1005: l_agenda_row c_agenda%ROWTYPE;
1006:
1250:
1251:
1252: CURSOR c_agenda IS
1253: SELECT agenda_id
1254: FROM AMS_AGENDAS_V
1255: WHERE agenda_id = p_agenda_id
1256: AND object_version_number = p_object_version
1257: FOR UPDATE of agenda_id NOWAIT;
1258:
1562: l_dummy NUMBER;
1563:
1564: cursor c_track_name IS
1565: SELECT 1 FROM DUAL
1566: WHERE EXISTS (SELECT 1 from ams_agendas_v
1567: WHERE agenda_name = p_agenda_rec.agenda_name
1568: AND parent_id = p_agenda_rec.parent_id);
1569:
1570:
1577: IF p_validation_mode = JTF_PLSQL_API.g_create
1578: AND p_agenda_rec.agenda_id IS NOT NULL
1579: THEN
1580: IF AMS_Utility_PVT.check_uniqueness(
1581: 'ams_agendas_v',
1582: 'agenda_id = ' || p_agenda_rec.agenda_id
1583: ) = FND_API.g_false
1584: THEN
1585: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
1678: THEN
1679: IF p_agenda_rec.parent_id <> FND_API.g_miss_num
1680: AND p_agenda_rec.parent_id IS NOT NULL THEN
1681: IF AMS_Utility_PVT.check_fk_exists(
1682: 'ams_agendas_v',
1683: 'agenda_id',
1684: p_agenda_rec.parent_id
1685: ) = FND_API.g_false
1686: THEN
1892: WHERE event_offer_id = l_offer_id;
1893:
1894: CURSOR c_get_event_id(id_in IN NUMBER) IS
1895: SELECT parent_id
1896: FROM ams_agendas_v
1897: WHERE agenda_id = id_in;
1898:
1899: CURSOR c_get_resource_dates(id_in IN NUMBER) IS
1900: SELECT min(start_date_time), max(end_date_time)
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
2531: l_max_time DATE;
2532:
2533: cursor c_parent_id(id_in IN NUMBER) is
2534: select parent_id
2535: from ams_agendas_v
2536: where agenda_id = id_in;
2537:
2538: cursor c_min_max_times(id_in IN NUMBER) is
2539: SELECT MIN(start_date_time), MAX(end_date_time)
2536: where agenda_id = id_in;
2537:
2538: cursor c_min_max_times(id_in IN NUMBER) is
2539: SELECT MIN(start_date_time), MAX(end_date_time)
2540: from ams_agendas_v
2541: where parent_id = id_in
2542: and active_flag = 'Y';
2543:
2544: BEGIN