APPS.AMS_AGENDAS_PVT dependencies on AMS_ACT_RESOURCES

Line 520: FROM ams_act_resources

516:
517:
518: CURSOR c_resources(l_session_id IN NUMBER) IS
519: SELECT activity_resource_id,object_version_number
520: FROM ams_act_resources
521: WHERE ACT_RESOURCE_USED_BY_ID = p_agenda_rec.agenda_id
522: AND role_cd = 'COORDINATOR'
523: AND resource_id = p_agenda_rec.coordinator_id;
524:

Line 700: UPDATE ams_act_resources

696:
697: IF( ABS(l_dateDiff) > 0)
698: THEN
699:
700: UPDATE ams_act_resources
701: SET system_status_code = 'UNCONFIRMED',
702: object_version_number = object_version_number + 1,
703: user_status_id = ( SELECT user_status_id
704: FROM AMS_USER_STATUSES_B

Line 724: UPDATE ams_act_resources

720: (p_agenda_rec.start_date_time > l_oldStdate
721: AND p_agenda_rec.end_date_time = l_oldEddate)
722: )
723: THEN
724: UPDATE ams_act_resources
725: SET object_version_number = object_version_number + 1,
726: start_date_time = p_agenda_rec.start_date_time,
727: end_date_time = p_agenda_rec.end_date_time
728: WHERE act_resource_used_by_id = p_agenda_rec.agenda_id

Line 748: UPDATE ams_act_resources

744:
745: AMS_Utility_PVT.debug_message('Entered for both dates');
746: END IF;
747:
748: UPDATE ams_act_resources
749: SET object_version_number = object_version_number + 1,
750: -- start_date_time = p_agenda_rec.start_date_time,
751: -- end_date_time = p_agenda_rec.end_date_time,
752: system_status_code = 'UNCONFIRMED',

Line 773: UPDATE ams_act_resources

769:
770: AMS_Utility_PVT.debug_message('Entered for end date change');
771: END IF;
772:
773: UPDATE ams_act_resources
774: SET object_version_number = object_version_number + 1,
775: -- end_date_time = p_agenda_rec.end_date_time,
776: system_status_code = 'UNCONFIRMED',
777: user_status_id = ( SELECT user_status_id

Line 795: UPDATE ams_act_resources

791:
792: AMS_Utility_PVT.debug_message('Entered for start date change');
793: END IF;
794:
795: UPDATE ams_act_resources
796: SET object_version_number = object_version_number + 1,
797: -- start_date_time = p_agenda_rec.start_date_time,
798: system_status_code = 'UNCONFIRMED',
799: user_status_id = ( SELECT user_status_id

Line 987: FROM ams_act_resources

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
987: FROM ams_act_resources
988: WHERE act_resource_used_by_id = l_session_id;
989:
990: CURSOR c_event_status IS
991: SELECT count(event_offer_id)

Line 1901: FROM ams_act_resources

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)
1901: FROM ams_act_resources
1902: WHERE act_resource_used_by_id = id_in
1903: and arc_act_resource_used_by = 'SESSION'
1904: and system_status_code = 'CONFIRMED';
1905: