eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.AMS_ACTRESOURCE_PVT dependencies on AMS_ACT_RESOURCES

Line 81: SELECT ams_act_resources_s.NEXTVAL

77: l_strTime VARCHAR2(30);
78: l_strDate VARCHAR2(30);
79:
80: CURSOR C_act_resource_id IS
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

Line 191: INSERT INTO AMS_ACT_RESOURCES

187: CLOSE c_act_resource_id;
188:
189:
190:
191: INSERT INTO AMS_ACT_RESOURCES
192: (
193: activity_resource_id,
194: last_update_date,
195: last_updated_by,

Line 466: update AMS_ACT_RESOURCES

462: END IF;
463:
464: -------------- Perform the database operation UPDATE----------------------
465:
466: update AMS_ACT_RESOURCES
467: set
468: last_update_date = sysdate
469: ,last_updated_by = FND_GLOBAL.User_Id
470: ,last_update_login = FND_GLOBAL.Conc_Login_Id

Line 615: DELETE FROM ams_act_resources

611: x_return_status := FND_API.G_RET_STS_SUCCESS;
612:
613: ------------------------------- Perform the database operation---------------
614:
615: DELETE FROM ams_act_resources
616: WHERE ACTIVITY_RESOURCE_ID = p_act_Resource_id
617: AND p_object_version = p_object_version;
618:
619: IF (SQL%NOTFOUND) THEN

Line 706: FROM AMS_ACT_RESOURCES

702: l_act_resource_id NUMBER;
703:
704: CURSOR c_act_resource IS
705: SELECT activity_resource_id
706: FROM AMS_ACT_RESOURCES
707: WHERE activity_resource_id = p_act_resource_id
708: AND object_version_number = p_object_version
709: FOR UPDATE of activity_resource_id NOWAIT;
710:

Line 953: 'ams_act_resources_v',

949: IF p_validation_mode = JTF_PLSQL_API.g_create
950: AND p_act_Resource_rec.activity_resource_id IS NOT NULL
951: THEN
952: IF AMS_Utility_PVT.check_uniqueness(
953: 'ams_act_resources_v',
954: 'activity_resource_id = ' || p_act_Resource_rec.activity_resource_id
955: ) = FND_API.g_false
956: THEN
957: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN

Line 1691: FROM ams_act_resources_v

1687: THEN
1688: BEGIN
1689:
1690: SELECT 1 into l_count
1691: FROM ams_act_resources_v
1692: WHERE act_resource_used_by_id = p_act_Resource_rec.act_resource_used_by_id
1693: AND arc_act_resource_used_by = p_act_Resource_rec.arc_act_resource_used_by
1694: AND resource_id = p_act_Resource_rec.resource_id
1695: AND system_status_code = 'CONFIRMED'

Line 1788: FROM ams_act_resources

1784: x_act_Resource_rec OUT NOCOPY act_Resource_rec_type
1785: ) IS
1786: CURSOR c_resource IS
1787: SELECT *
1788: FROM ams_act_resources
1789: WHERE activity_resource_id = p_act_Resource_rec.activity_resource_id;
1790: l_act_Resource_rec c_resource%ROWTYPE;
1791:
1792: BEGIN

Line 1981: FROM ams_act_resources

1977:
1978:
1979: CURSOR C_check_sessions_create(id_in IN NUMBER) IS
1980: SELECT count(*)
1981: FROM ams_act_resources
1982: WHERE resource_id = id_in
1983: AND arc_act_resource_used_by = 'SESSION'
1984: AND system_status_code = 'CONFIRMED'
1985: AND role_cd <> 'COORDINATOR'

Line 1992: FROM ams_act_resources

1988: OR start_date_time BETWEEN p_act_Resource_rec.start_date_time AND p_act_Resource_rec.end_date_time);
1989:
1990: CURSOR C_check_sessions_update IS
1991: SELECT count(*)
1992: FROM ams_act_resources
1993: WHERE resource_id = p_act_Resource_rec.resource_id
1994: AND activity_resource_id <> p_act_Resource_rec.activity_resource_id
1995: AND arc_act_resource_used_by = 'SESSION'
1996: AND system_status_code = 'CONFIRMED'

Line 2004: FROM ams_act_resources

2000: OR start_date_time BETWEEN p_act_Resource_rec.start_date_time AND p_act_Resource_rec.end_date_time);
2001:
2002: CURSOR C_check_events_session IS
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

Line 2021: FROM ams_act_resources

2017:
2018:
2019: CURSOR C_check_events_create IS
2020: SELECT count(*)
2021: FROM ams_act_resources
2022: WHERE resource_id = p_act_Resource_rec.resource_id
2023: AND arc_act_resource_used_by IN ('EVEO', 'EONE')
2024: AND system_status_code = 'CONFIRMED'
2025: AND role_cd <> 'COORDINATOR'

Line 2032: FROM ams_act_resources

2028: OR start_date_time BETWEEN p_act_Resource_rec.start_date_time AND p_act_Resource_rec.end_date_time);
2029:
2030: CURSOR C_check_events_update IS
2031: SELECT count(*)
2032: FROM ams_act_resources
2033: WHERE resource_id = p_act_Resource_rec.resource_id
2034: AND arc_act_resource_used_by IN ('EVEO', 'EONE')
2035: AND activity_resource_id <> p_act_Resource_rec.activity_resource_id
2036: AND system_status_code = 'CONFIRMED'

Line 2045: FROM ams_act_resources

2041:
2042:
2043: CURSOR C_check_other_sessions(id_in IN NUMBER) IS
2044: SELECT count(*)
2045: FROM ams_act_resources
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