APPS.AMS_EVENTOFFER_PVT dependencies on AMS_ACT_RESOURCES

Line 91: l_table_name := 'AMS_ACT_RESOURCES';

87: l_id_col := 'ACT_PRODUCT_USED_BY_ID';
88: end if;
89:
90: if (p_association_with = 'RESC') then
91: l_table_name := 'AMS_ACT_RESOURCES';
92: l_type_col := 'ARC_ACT_RESOURCE_USED_BY';
93: l_id_col := 'ACT_RESOURCE_USED_BY_ID';
94: end if;
95:

Line 1625: FROM ams_act_resources

1621: WHERE event_offer_id = p_evo_rec.event_offer_id;
1622:
1623: CURSOR c_resources IS
1624: SELECT activity_resource_id, object_version_number
1625: FROM ams_act_resources
1626: WHERE act_resource_used_by_id = p_evo_rec.event_offer_id;
1627:
1628: /*
1629: CURSOR c_venue_id IS

Line 1642: FROM ams_act_resources

1638: WHERE event_offer_id = p_evo_rec.event_offer_id;
1639:
1640: CURSOR C_get_event_resources(id_in IN NUMBER) IS
1641: SELECT activity_resource_id, object_version_number
1642: FROM ams_act_resources
1643: WHERE act_resource_used_by_id = id_in;
1644:
1645: CURSOR C_get_session_resources(id_in IN NUMBER) IS
1646: SELECT activity_resource_id, object_version_number

Line 1647: FROM ams_act_resources

1643: WHERE act_resource_used_by_id = id_in;
1644:
1645: CURSOR C_get_session_resources(id_in IN NUMBER) IS
1646: SELECT activity_resource_id, object_version_number
1647: FROM ams_act_resources
1648: WHERE arc_act_resource_used_by = 'SESSION'
1649: AND act_resource_used_by_id IN ( SELECT agenda_id
1650: FROM ams_agendas_b
1651: WHERE agenda_type = 'SESSION'

Line 2427: UPDATE ams_act_resources

2423: FETCH C_get_event_resources INTO l_actres_id, l_obj_ver;
2424:
2425: WHILE C_get_event_resources%FOUND LOOP
2426:
2427: UPDATE ams_act_resources
2428: SET object_version_number = l_obj_ver + 1,
2429: system_status_code = 'UNCONFIRMED',
2430: user_status_id = ( SELECT user_status_id
2431: FROM AMS_USER_STATUSES_B

Line 2450: UPDATE ams_act_resources

2446: FETCH C_get_session_resources INTO l_actres_id, l_obj_ver;
2447:
2448: WHILE C_get_session_resources%FOUND LOOP
2449:
2450: UPDATE ams_act_resources
2451: SET object_version_number = l_obj_ver + 1,
2452: system_status_code = 'UNCONFIRMED',
2453: user_status_id = ( SELECT user_status_id
2454: FROM AMS_USER_STATUSES_B

Line 2848: UPDATE ams_act_resources

2844: FETCH c_resources INTO l_resource_id, l_obj_num;
2845:
2846: WHILE c_resources%FOUND LOOP
2847:
2848: UPDATE ams_act_resources
2849: SET system_status_code = 'CANCELLED',
2850: object_version_number = l_obj_num+1,
2851: user_status_id = (SELECT user_status_id
2852: FROM ams_user_statuses_b

Line 2864: UPDATE ams_act_resources

2860:
2861: END LOOP; -- WHILE(c_resources%FOUND)
2862: CLOSE c_resources;
2863:
2864: UPDATE ams_act_resources
2865: SET system_status_code = 'CANCELLED',
2866: object_version_number = l_obj_num+1,
2867: user_status_id = (SELECT user_status_id
2868: FROM ams_user_statuses_b

Line 2874: FROM ams_act_resources

2870: AND system_status_code = 'CANCELLED'
2871: -- added by soagrawa on 25-feb-2003 for bug# 2820297
2872: AND DEFAULT_FLAG = 'Y')
2873: WHERE activity_resource_id IN (SELECT activity_resource_id
2874: FROM ams_act_resources
2875: WHERE act_resource_used_by_id IN ( SELECT agenda_id
2876: FROM ams_agendas_b
2877: WHERE parent_id IN (SELECT agenda_id
2878: FROM ams_agendas_b