[Home] [Help]
335: WHERE event_offer_id = evo_id;
336:
337: CURSOR c_evo_status_evagd(ust_id IN NUMBER) IS
338: SELECT system_status_code
339: FROM ams_user_statuses_b
340: WHERE user_status_id = ust_id
341: AND system_status_type = 'AMS_EVENT_AGENDA_STATUS';
342:
343: CURSOR c_list_YN(id_in IN NUMBER) IS
1472: --
1473: -- HISTORY
1474: -- 11/23/1999 sugupta Created
1475: -- 01/25/2000 gdeodhar Added code to pick up the system_status_code
1476: -- from ams_user_statuses_b table. The UI will
1477: -- never pass this code.
1478: -- 07/07/2000 sugupta modified call inv and pricing api's based on profile option
1479: -- 08/01/2000 sugupta added access code
1480: -- 11-feb-2003 soagrawa fixed access related bug for INTERNAL bug# 2795823
1567: -- appid, ev_header_id, source_code cannot not be updated by the user.
1568:
1569: CURSOR c_evo_status_evo IS
1570: SELECT system_status_code
1571: FROM ams_user_statuses_b
1572: WHERE user_status_id = p_evo_rec.user_status_id
1573: AND system_status_type = 'AMS_EVENT_STATUS';
1574:
1575: CURSOR c_evo_status_evagd IS
1573: AND system_status_type = 'AMS_EVENT_STATUS';
1574:
1575: CURSOR c_evo_status_evagd IS
1576: SELECT system_status_code
1577: FROM ams_user_statuses_b
1578: WHERE user_status_id = p_evo_rec.user_status_id
1579: AND system_status_type = 'AMS_EVENT_AGENDA_STATUS';
1580:
1581: -- dbiswas modified cursor for bug# 2983031 on 02-jun-2003
1580:
1581: -- dbiswas modified cursor for bug# 2983031 on 02-jun-2003
1582: CURSOR c_evo_status IS
1583: SELECT system_status_code
1584: FROM ams_user_statuses_b
1585: WHERE user_status_id = l_evo_rec.user_status_id --p_evo_rec.user_status_id
1586: AND system_status_type = 'AMS_EVENT_STATUS';
1587:
1588: CURSOR c_evo_dlv_mthd IS
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
2432: WHERE SYSTEM_STATUS_CODE = 'UNCONFIRMED'
2433: AND SYSTEM_STATUS_TYPE = 'AMS_EVENT_AGENDA_STATUS'
2434: -- added by soagrawa on 25-feb-2003 for bug# 2820297
2435: AND DEFAULT_FLAG = 'Y')
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
2455: WHERE SYSTEM_STATUS_CODE = 'UNCONFIRMED'
2456: AND SYSTEM_STATUS_TYPE = 'AMS_EVENT_AGENDA_STATUS'
2457: -- added by soagrawa on 25-feb-2003 for bug# 2820297
2458: AND DEFAULT_FLAG = 'Y')
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
2853: WHERE system_status_type = 'AMS_EVENT_AGENDA_STATUS'
2854: AND system_status_code = 'CANCELLED'
2855: -- added by soagrawa on 25-feb-2003 for bug# 2820297
2856: AND DEFAULT_FLAG = 'Y')
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
2869: WHERE system_status_type = 'AMS_EVENT_AGENDA_STATUS'
2870: AND system_status_code = 'CANCELLED'
2871: -- added by soagrawa on 25-feb-2003 for bug# 2820297
2872: AND DEFAULT_FLAG = 'Y')
3586: ----------------------- user_status_id ------------------------
3587: IF p_evo_rec.user_status_id <> FND_API.g_miss_num
3588: AND p_evo_rec.user_status_id IS NOT NULL THEN
3589: IF AMS_Utility_PVT.check_fk_exists(
3590: 'ams_user_statuses_b',
3591: 'user_status_id',
3592: p_evo_rec.user_status_id
3593: ) = FND_API.g_false
3594: THEN
7241: )
7242: IS
7243: CURSOR c_status IS
7244: SELECT system_status_code
7245: FROM ams_user_statuses_b
7246: WHERE user_status_id = p_evo_rec.user_status_id
7247: AND system_status_type = 'AMS_EVENT_STATUS';
7248:
7249: CURSOR c_details IS