APPS.AMS_ACTRESOURCE_PVT dependencies on AMS_AGENDAS_B

Line 85: SELECT start_date_time FROM ams_agendas_b

81: SELECT ams_act_resources_s.NEXTVAL
82: FROM dual;
83:
84: CURSOR c_get_object_date(id_in IN NUMBER, type_in IN VARCHAR2) is
85: SELECT start_date_time FROM ams_agendas_b
86: WHERE agenda_id = id_in
87: AND agenda_type = type_in;
88:
89: CURSOR c_get_sys_stat_code(id_in IN NUMBER) is

Line 348: SELECT start_date_time FROM ams_agendas_b

344: l_strTime VARCHAR2(30);
345: l_strDate VARCHAR2(30);
346:
347: CURSOR c_get_object_date(id_in IN NUMBER, type_in IN VARCHAR2) is
348: SELECT start_date_time FROM ams_agendas_b
349: WHERE agenda_id = id_in
350: AND agenda_type = type_in;
351:
352: CURSOR c_get_sys_stat_code(id_in IN NUMBER) is

Line 1183: l_table_name := 'AMS_AGENDAS_B';

1179: IF p_act_resource_rec.ACT_RESOURCE_USED_BY_ID <> FND_API.g_miss_num
1180: THEN
1181: IF p_act_Resource_rec.arc_act_resource_used_by ='SESSION'
1182: THEN
1183: l_table_name := 'AMS_AGENDAS_B';
1184: l_pk_name := 'AGENDA_ID';
1185: ELSIF (p_act_Resource_rec.arc_act_resource_used_by = 'EVEO' OR p_act_Resource_rec.arc_act_resource_used_by = 'EONE')
1186: THEN
1187: l_table_name := 'AMS_EVENT_OFFERS_ALL_B';

Line 1363: FROM AMS_agendas_b

1359: */
1360:
1361: CURSOR get_session_date (id_in in NUMBER,type_in IN VARCHAR2)is
1362: SELECT start_date_time, end_date_time
1363: FROM AMS_agendas_b
1364: WHERE agenda_id = id_in
1365: AND agenda_TYPE = type_in;
1366:
1367: CURSOR get_event_date (id_in in NUMBER,type_in IN VARCHAR2)is

Line 1384: FROM ams_agendas_b

1380: SELECT count(event_offer_id)
1381: FROM ams_event_offers_all_b
1382: WHERE system_status_code IN ('COMPLETED', 'CANCELLED', 'ON_HOLD','ARCHIVED','CLOSED')
1383: AND event_offer_id = ( SELECT parent_id
1384: FROM ams_agendas_b
1385: WHERE agenda_id = ( SELECT parent_id
1386: FROM ams_agendas_b
1387: WHERE agenda_id = p_act_Resource_rec.act_resource_used_by_id));
1388:

Line 1386: FROM ams_agendas_b

1382: WHERE system_status_code IN ('COMPLETED', 'CANCELLED', 'ON_HOLD','ARCHIVED','CLOSED')
1383: AND event_offer_id = ( SELECT parent_id
1384: FROM ams_agendas_b
1385: WHERE agenda_id = ( SELECT parent_id
1386: FROM ams_agendas_b
1387: WHERE agenda_id = p_act_Resource_rec.act_resource_used_by_id));
1388:
1389:
1390: BEGIN

Line 2007: FROM ams_agendas_b

2003: SELECT count(*)
2004: FROM ams_act_resources
2005: WHERE resource_id = p_act_Resource_rec.resource_id
2006: AND act_resource_used_by_id <> ( SELECT parent_id
2007: FROM ams_agendas_b
2008: WHERE agenda_id = (SELECT parent_id
2009: FROM ams_agendas_b
2010: WHERE agenda_id = p_act_Resource_rec.act_resource_used_by_id))
2011: AND arc_act_resource_used_by IN ('EVEO', 'EONE')

Line 2009: FROM ams_agendas_b

2005: WHERE resource_id = p_act_Resource_rec.resource_id
2006: AND act_resource_used_by_id <> ( SELECT parent_id
2007: FROM ams_agendas_b
2008: WHERE agenda_id = (SELECT parent_id
2009: FROM ams_agendas_b
2010: WHERE agenda_id = p_act_Resource_rec.act_resource_used_by_id))
2011: AND arc_act_resource_used_by IN ('EVEO', 'EONE')
2012: AND system_status_code = 'CONFIRMED'
2013: AND role_cd <> 'COORDINATOR'

Line 2050: FROM ams_agendas_b

2046: WHERE arc_act_resource_used_by = 'SESSION'
2047: AND system_status_code = 'CONFIRMED'
2048: AND role_cd <> 'COORDINATOR'
2049: AND act_resource_used_by_id IN ( SELECT agenda_id
2050: FROM ams_agendas_b
2051: WHERE parent_id <> p_act_Resource_rec.act_resource_used_by_id
2052: AND parent_type IN ('EVEO', 'EONE'))
2053: AND( p_act_Resource_rec.start_date_time BETWEEN start_date_time AND end_date_time
2054: OR p_act_Resource_rec.end_date_time BETWEEN start_date_time AND end_date_time