APPS.AMS_EVENTHEADER_PVT dependencies on AMS_USER_STATUSES_B

Line 88: FROM ams_user_statuses_b

84: WHERE event_header_id = evh_id;
85:
86: CURSOR c_evh_status_evagd(ust_id IN NUMBER) IS
87: SELECT system_status_code
88: FROM ams_user_statuses_b
89: WHERE user_status_id = ust_id
90: AND system_status_type = 'AMS_EVENT_AGENDA_STATUS';
91:
92: CURSOR get_res_id(l_user_id IN NUMBER) IS

Line 1002: -- from ams_user_statuses_b table. The UI will

998: -- HISTORY
999: -- 11/17/1999 gdeodhar Created
1000: -- 01/17/2000 gdeodhar Fixed the time formats.
1001: -- 01/21/2000 gdeodhar Added code to pick up the system_status_code
1002: -- from ams_user_statuses_b table. The UI will
1003: -- never pass this code.
1004: ----------------------------------------------------------------------
1005: PROCEDURE update_event_header(
1006: p_api_version IN NUMBER,

Line 1036: FROM ams_user_statuses_b

1032: l_dummy_source_code VARCHAR2(30);
1033:
1034: CURSOR c_evh_status_evh IS
1035: SELECT system_status_code
1036: FROM ams_user_statuses_b
1037: WHERE user_status_id = p_evh_rec.user_status_id
1038: AND system_status_type = 'AMS_EVENT_STATUS';
1039:
1040: CURSOR c_evh_status_evagd IS

Line 1042: FROM ams_user_statuses_b

1038: AND system_status_type = 'AMS_EVENT_STATUS';
1039:
1040: CURSOR c_evh_status_evagd IS
1041: SELECT system_status_code
1042: FROM ams_user_statuses_b
1043: WHERE user_status_id = p_evh_rec.user_status_id
1044: AND system_status_type = 'AMS_EVENT_AGENDA_STATUS';
1045:
1046: CURSOR get_res_id(l_user_id IN NUMBER) IS

Line 2423: 'ams_user_statuses_b',

2419: END IF;
2420: ----------------------- user_status_id ------------------------
2421: IF p_evh_rec.user_status_id <> FND_API.g_miss_num THEN
2422: IF AMS_Utility_PVT.check_fk_exists(
2423: 'ams_user_statuses_b',
2424: 'user_status_id',
2425: p_evh_rec.user_status_id
2426: ) = FND_API.g_false
2427: THEN

Line 2518: p_lookup_table_name => 'AMS_USER_STATUSES_B',

2514: /*
2515: ----------------------- system_status_code ------------------------
2516: IF p_evh_rec.system_status_code <> FND_API.g_miss_char THEN
2517: IF AMS_Utility_PVT.check_lookup_exists(
2518: p_lookup_table_name => 'AMS_USER_STATUSES_B',
2519: p_lookup_type => 'AMS_EVENT_STATUS',
2520: p_lookup_code => p_evh_rec.system_status_code
2521: ) = FND_API.g_false
2522: THEN