APPS.AMS_EVHRULES_PVT dependencies on AMS_EVENT_HEADERS_ALL_B

Line 603: FROM AMS_EVENT_HEADERS_ALL_B

599: AND active_flag = 'Y';
600:
601: CURSOR c_setup_id IS
602: SELECT SETUP_TYPE_ID
603: FROM AMS_EVENT_HEADERS_ALL_B
604: WHERE EVENT_HEADER_ID = p_evh_id;
605: /*
606: CURSOR c_setup_id IS
607: SELECT custom_setup_id

Line 997: FROM ams_event_headers_all_b

993: l_new_status_code VARCHAR2(30); -- added as per enh # 3805347
994:
995: CURSOR c_old_status_EVEH (l_event_header_id IN NUMBER) IS
996: SELECT user_status_id, object_version_number, setup_type_id, program_id
997: FROM ams_event_headers_all_b
998: WHERE event_header_id = l_event_header_id;
999:
1000: -- Modified the cursor as per enh # 3805347
1001: CURSOR c_old_status_EVEO IS

Line 1235: /* UPDATE ams_event_headers_all_b

1231:
1232: -- Update header or offers table with the new status
1233:
1234: IF p_event_activity_type = 'EVEH' THEN
1235: /* UPDATE ams_event_headers_all_b
1236: SET user_status_id = l_new_status_id,
1237: system_status_code = AMS_Utility_PVT.get_system_status_code(l_new_status_id),
1238: last_status_date = SYSDATE
1239: WHERE event_header_id = p_event_id; */

Line 2023: FROM ams_event_headers_all_b

2019: PROCEDURE Cancel_RollupEvent(p_evh_id IN NUMBER) IS
2020:
2021: CURSOR c_evh IS
2022: SELECT event_header_id,object_version_number,system_status_code
2023: FROM ams_event_headers_all_b
2024: WHERE EVENT_HEADER_ID = p_evh_id
2025: AND system_status_code <> 'CANCELLED' ;
2026:
2027: l_event_header_id NUMBER ;

Line 2041: UPDATE ams_event_headers_all_b

2037: FETCH c_evh INTO l_event_header_id,l_obj_version,l_status_code ;
2038: EXIT WHEN c_evh%NOTFOUND ;
2039: IF FND_API.G_TRUE = AMS_Utility_PVT.Check_Status_Change('AMS_EVENT_STATUS',l_status_code,'CANCELLED') THEN
2040: -- Can cancel the schedule
2041: UPDATE ams_event_headers_all_b
2042: SET system_status_code = 'CANCELLED',
2043: last_status_date = SYSDATE,
2044: user_status_id = l_status_id,
2045: object_version_number = object_version_number + 1

Line 2227: FROM ams_event_headers_all_b

2223: IS
2224:
2225: CURSOR c_evh_list IS
2226: SELECT count(*)
2227: FROM ams_event_headers_all_b
2228: WHERE program_id = p_prog_id
2229: AND system_status_code NOT IN ('CANCELLED', 'ARCHIVED');
2230:
2231: CURSOR c_evo_list IS

Line 2277: FROM ams_event_headers_all_b

2273: PROCEDURE complete_RollupEvent(p_evh_id IN NUMBER) IS
2274:
2275: CURSOR c_evh IS
2276: SELECT event_header_id,object_version_number,system_status_code
2277: FROM ams_event_headers_all_b
2278: WHERE EVENT_HEADER_ID = p_evh_id
2279: AND system_status_code <> 'COMPLETED' ;
2280:
2281: l_event_header_id NUMBER ;

Line 2295: UPDATE ams_event_headers_all_b

2291: FETCH c_evh INTO l_event_header_id,l_obj_version,l_status_code ;
2292: EXIT WHEN c_evh%NOTFOUND ;
2293: IF FND_API.G_TRUE = AMS_Utility_PVT.Check_Status_Change('AMS_EVENT_STATUS',l_status_code,'COMPLETED') THEN
2294: -- Can complete the schedule
2295: UPDATE ams_event_headers_all_b
2296: SET system_status_code = 'COMPLETED',
2297: last_status_date = SYSDATE,
2298: user_status_id = l_status_id,
2299: object_version_number = object_version_number + 1

Line 2474: FROM ams_event_headers_all_b

2470: PROCEDURE complete_all_Event(p_prog_id IN NUMBER) IS
2471:
2472: CURSOR c_evh_list IS
2473: SELECT event_header_id,object_version_number,system_status_code
2474: FROM ams_event_headers_all_b
2475: WHERE program_id = p_prog_id;
2476:
2477: CURSOR c_evo_list IS
2478: SELECT event_offer_id,object_version_number,system_status_code

Line 2702: UPDATE ams_event_headers_all_b

2698:
2699: IF(p_new_status_code = 'ACTIVE') THEN
2700:
2701: /* updating the Event Header */
2702: UPDATE ams_event_headers_all_b
2703: SET user_status_id = p_new_status_id,
2704: system_status_code = p_new_status_code,
2705: last_status_date = SYSDATE,
2706: object_version_number = l_evh_obj_ver + 1

Line 2754: UPDATE ams_event_headers_all_b

2750: -- AND Fnd_Api.G_TRUE = Ams_Utility_Pvt.Check_Status_Change('AMS_EVENT_STATUS',l_status_code,'CANCELLED')
2751: )
2752: THEN
2753:
2754: UPDATE ams_event_headers_all_b
2755: SET user_status_id = p_new_status_id,
2756: system_status_code = p_new_status_code,
2757: last_status_date = SYSDATE,
2758: object_version_number = l_evh_obj_ver + 1

Line 2771: UPDATE ams_event_headers_all_b

2767:
2768: ELSE
2769: /* Bug #2250937 03/05/2002*/
2770:
2771: UPDATE ams_event_headers_all_b
2772: SET user_status_id = p_new_status_id,
2773: system_status_code = p_new_status_code,
2774: last_status_date = SYSDATE,
2775: object_version_number = l_evh_obj_ver + 1

Line 2853: FROM ams_event_headers_all_b

2849: p_owner_id IN NUMBER )
2850: IS
2851: CURSOR c_header_owner IS
2852: SELECT owner_user_id
2853: FROM ams_event_headers_all_b
2854: WHERE event_header_id = p_event_id ;
2855:
2856: CURSOR c_offer_owner IS
2857: SELECT owner_user_id