eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.AMS_EVHRULES_PVT dependencies on AMS_EVENT_OFFERS_ALL_B

Line 66: FROM ams_event_offers_all_b

62:
63: -- Modified the cursor to select event_object_type, as per enh # 3805347
64: CURSOR c_ev_schedule IS
65: SELECT event_offer_id, object_version_number, system_status_code, event_object_type
66: FROM ams_event_offers_all_b
67: WHERE event_header_id = p_eveh_id
68: AND system_status_code <> 'COMPLETED' ;
69:
70: l_event_offer_id NUMBER ;

Line 85: UPDATE ams_event_offers_all_b

81: INTO l_event_offer_id, l_obj_version, l_status_code, l_obj_type;
82: EXIT WHEN c_ev_schedule%NOTFOUND ;
83: IF FND_API.G_TRUE = AMS_Utility_PVT.Check_Status_Change('AMS_EVENT_STATUS',l_status_code,'COMPLETED') THEN
84: -- Can cancel the event offer
85: UPDATE ams_event_offers_all_b
86: SET system_status_code = 'COMPLETED',
87: last_status_date = SYSDATE,
88: user_status_id = l_status_id,
89: object_version_number = object_version_number + 1

Line 730: FROM AMS_EVENT_OFFERS_ALL_B

726: AND active_flag = 'Y';
727:
728: CURSOR c_setup_id IS
729: SELECT SETUP_TYPE_ID
730: FROM AMS_EVENT_OFFERS_ALL_B
731: WHERE EVENT_HEADER_ID = p_evo_id;
732: /*
733: CURSOR c_setup_id IS
734: SELECT custom_setup_id

Line 860: FROM AMS_EVENT_OFFERS_ALL_B

856: AND active_flag = 'Y';
857:
858: CURSOR c_setup_id IS
859: SELECT SETUP_TYPE_ID
860: FROM AMS_EVENT_OFFERS_ALL_B
861: WHERE EVENT_HEADER_ID = p_evo_id;
862: /*
863: CURSOR c_setup_id IS
864: SELECT custom_setup_id

Line 1003: FROM ams_event_offers_all_b

999:
1000: -- Modified the cursor as per enh # 3805347
1001: CURSOR c_old_status_EVEO IS
1002: SELECT user_status_id, object_version_number, setup_type_id, event_header_id, system_status_code
1003: FROM ams_event_offers_all_b
1004: WHERE event_offer_id = p_event_id;
1005:
1006: -- Modified the cursor as per enh # 3805347
1007: CURSOR c_old_status_EONE IS

Line 1009: FROM ams_event_offers_all_b

1005:
1006: -- Modified the cursor as per enh # 3805347
1007: CURSOR c_old_status_EONE IS
1008: SELECT user_status_id, object_version_number, setup_type_id, parent_id, system_status_code
1009: FROM ams_event_offers_all_b
1010: WHERE event_offer_id = p_event_id;
1011:
1012: /* Cursor to get the user status id of program */
1013: CURSOR c_PROGRAM_status (l_event_offer_id IN NUMBER) IS

Line 1247: UPDATE ams_event_offers_all_b

1243: p_new_status_code => AMS_Utility_PVT.get_system_status_code(l_new_status_id)
1244: );
1245:
1246: ELSIF p_event_activity_type ='EVEO' THEN
1247: UPDATE ams_event_offers_all_b
1248: SET user_status_id = l_new_status_id,
1249: system_status_code = AMS_Utility_PVT.get_system_status_code(l_new_status_id),
1250: last_status_date = SYSDATE
1251: WHERE event_offer_id = p_event_id;

Line 1264: UPDATE ams_event_offers_all_b

1260:
1261:
1262:
1263: ELSIF p_event_activity_type ='EONE' THEN
1264: UPDATE ams_event_offers_all_b
1265: SET user_status_id = l_new_status_id,
1266: system_status_code = AMS_Utility_PVT.get_system_status_code(l_new_status_id),
1267: last_status_date = SYSDATE
1268: WHERE event_offer_id = p_event_id;

Line 1331: l_reg_lead_flag VARCHAR2(1); --Value of CREATE_REGISTRANT_LEAD_FLAG from ams_event_offers_all_b.

1327: , p_obj_srccd IN VARCHAR2 := NULL
1328: )
1329: IS
1330: l_lit_batch_id NUMBER; --Batch ID of this Lead Import process for the lead interface tabel.
1331: l_reg_lead_flag VARCHAR2(1); --Value of CREATE_REGISTRANT_LEAD_FLAG from ams_event_offers_all_b.
1332: l_atnd_lead_flag VARCHAR2(1); --Value of CREATE_ATTENDANT_LEAD_FLAG from ams_event_offers_all_b.
1333: l_evnt_sched_src_cd VARCHAR2(30); --Value of the source code for event schedule.
1334: l_loaded_rows NUMBER; --holds the count of rows that were inserted in the import interface table for this batch.
1335: l_request_id NUMBER; --request id. Used when we call the concurrent program.

Line 1332: l_atnd_lead_flag VARCHAR2(1); --Value of CREATE_ATTENDANT_LEAD_FLAG from ams_event_offers_all_b.

1328: )
1329: IS
1330: l_lit_batch_id NUMBER; --Batch ID of this Lead Import process for the lead interface tabel.
1331: l_reg_lead_flag VARCHAR2(1); --Value of CREATE_REGISTRANT_LEAD_FLAG from ams_event_offers_all_b.
1332: l_atnd_lead_flag VARCHAR2(1); --Value of CREATE_ATTENDANT_LEAD_FLAG from ams_event_offers_all_b.
1333: l_evnt_sched_src_cd VARCHAR2(30); --Value of the source code for event schedule.
1334: l_loaded_rows NUMBER; --holds the count of rows that were inserted in the import interface table for this batch.
1335: l_request_id NUMBER; --request id. Used when we call the concurrent program.
1336: l_return_status VARCHAR2(1); --holds the status coming back from other procedure calls.

Line 1344: FROM ams_event_offers_all_b

1340: FROM DUAL;
1341:
1342: CURSOR c_get_evnt_sched_src_cd(event_id_in IN NUMBER) IS
1343: SELECT source_code
1344: FROM ams_event_offers_all_b
1345: WHERE event_offer_id = event_id_in;
1346:
1347: CURSOR c_get_reg_lead_flag(event_id_in IN NUMBER) IS
1348: SELECT create_registrant_lead_flag

Line 1349: FROM ams_event_offers_all_b

1345: WHERE event_offer_id = event_id_in;
1346:
1347: CURSOR c_get_reg_lead_flag(event_id_in IN NUMBER) IS
1348: SELECT create_registrant_lead_flag
1349: FROM ams_event_offers_all_b
1350: WHERE event_offer_id = event_id_in;
1351:
1352: CURSOR c_get_atnd_lead_flag(event_id_in IN NUMBER) IS
1353: SELECT create_attendant_lead_flag

Line 1354: FROM ams_event_offers_all_b

1350: WHERE event_offer_id = event_id_in;
1351:
1352: CURSOR c_get_atnd_lead_flag(event_id_in IN NUMBER) IS
1353: SELECT create_attendant_lead_flag
1354: FROM ams_event_offers_all_b
1355: WHERE event_offer_id = event_id_in;
1356:
1357: -- following cursor added by soagrawa on 22-oct-2002
1358: -- to merge the above 3 cursors into 1 single cursor

Line 1362: FROM ams_event_offers_all_b

1358: -- to merge the above 3 cursors into 1 single cursor
1359: -- while fixing bug# 2594717
1360: CURSOR c_get_evnt_details(event_id_in IN NUMBER) IS
1361: SELECT source_code, create_registrant_lead_flag, create_attendant_lead_flag
1362: FROM ams_event_offers_all_b
1363: WHERE event_offer_id = event_id_in;
1364:
1365:
1366: -- The following is actually : create leads for enrollees.

Line 1411: ams_event_offers_all_b event

1407: CURSOR c_get_reg_att_for_lead (event_id_in IN NUMBER) IS
1408: SELECT reg.registrant_party_id party_id
1409: , reg.registrant_contact_id contact_id
1410: FROM ams_event_registrations reg,
1411: ams_event_offers_all_b event
1412: WHERE reg.event_offer_id = event_id_in
1413: AND reg.system_status_code = 'REGISTERED' -- In future when we kill the REGISTERED status and leave ENROLLED, change this to ENROLLED.
1414: AND reg.active_flag = 'Y'
1415: AND event.event_offer_id = reg.event_offer_id

Line 1421: ams_event_offers_all_b event

1417: UNION
1418: SELECT reg.attendant_party_id party_id
1419: , reg.attendant_contact_id contact_id
1420: FROM ams_event_registrations reg,
1421: ams_event_offers_all_b event
1422: WHERE reg.event_offer_id = event_id_in
1423: AND reg.system_status_code = 'REGISTERED' -- In future when we kill the REGISTERED status and leave ENROLLED, change this to ENROLLED.
1424: AND reg.active_flag = 'Y'
1425: AND reg.attended_flag = 'Y'

Line 2085: FROM ams_event_offers_all_b

2081:
2082: -- Modified the select statement of the cursor to get event_object_type, as per enh # 3805347
2083: CURSOR c_evo_list IS
2084: SELECT event_offer_id,object_version_number,system_status_code, event_object_type
2085: FROM ams_event_offers_all_b
2086: WHERE event_header_id = p_evh_id
2087: AND system_status_code <> 'CANCELLED' ;
2088:
2089: l_event_offer_id NUMBER ;

Line 2103: UPDATE ams_event_offers_all_b

2099: FETCH c_evo_list INTO l_event_offer_id,l_obj_version,l_status_code,l_obj_type ; -- modified as per enh # 3805347
2100: EXIT WHEN c_evo_list%NOTFOUND ;
2101: IF FND_API.G_TRUE = AMS_Utility_PVT.Check_Status_Change('AMS_EVENT_STATUS',l_status_code,'CANCELLED') THEN
2102: -- Can cancel the schedule
2103: UPDATE ams_event_offers_all_b
2104: SET system_status_code = 'CANCELLED',
2105: last_status_date = SYSDATE,
2106: user_status_id = l_status_id,
2107: object_version_number = object_version_number + 1

Line 2154: FROM ams_event_offers_all_b

2150:
2151: -- Modified the select statement of the cursor to get event_object_type, as per enh # 3805347
2152: CURSOR c_evo_list IS
2153: SELECT event_offer_id,object_version_number,system_status_code, event_object_type
2154: FROM ams_event_offers_all_b
2155: WHERE event_offer_id = p_offer_id
2156: AND system_status_code <> 'CANCELLED' ;
2157:
2158: l_event_offer_id NUMBER ;

Line 2172: UPDATE ams_event_offers_all_b

2168: FETCH c_evo_list INTO l_event_offer_id,l_obj_version,l_status_code, l_obj_type; -- Modified as per enh # 3805347
2169: EXIT WHEN c_evo_list%NOTFOUND ;
2170: IF FND_API.G_TRUE = AMS_Utility_PVT.Check_Status_Change('AMS_EVENT_STATUS',l_status_code,'CANCELLED') THEN
2171: -- Can cancel the schedule
2172: UPDATE ams_event_offers_all_b
2173: SET system_status_code = 'CANCELLED',
2174: last_status_date = SYSDATE,
2175: user_status_id = l_status_id,
2176: object_version_number = object_version_number + 1

Line 2233: FROM ams_event_offers_all_b

2229: AND system_status_code NOT IN ('CANCELLED', 'ARCHIVED');
2230:
2231: CURSOR c_evo_list IS
2232: SELECT count(*)
2233: FROM ams_event_offers_all_b
2234: WHERE parent_id = p_prog_id
2235: AND event_object_type = 'EONE'
2236: AND parent_type = 'RCAM'
2237: AND system_status_code NOT IN ('CANCELLED', 'ARCHIVED');

Line 2338: FROM ams_event_offers_all_b

2334:
2335: -- Modified the select statement of the cursor to get event_object_type, as per enh # 3805347
2336: CURSOR c_evo_list IS
2337: SELECT event_offer_id,object_version_number,system_status_code, event_object_type
2338: FROM ams_event_offers_all_b
2339: WHERE event_header_id = p_evh_id
2340: AND system_status_code <> 'COMPLETED' ;
2341:
2342: l_event_offer_id NUMBER ;

Line 2356: UPDATE ams_event_offers_all_b

2352: FETCH c_evo_list INTO l_event_offer_id,l_obj_version,l_status_code, l_obj_type; -- Modified as per enh # 3805347.
2353: EXIT WHEN c_evo_list%NOTFOUND ;
2354: IF FND_API.G_TRUE = AMS_Utility_PVT.Check_Status_Change('AMS_EVENT_STATUS',l_status_code,'COMPLETED') THEN
2355: -- Can complete the schedule
2356: UPDATE ams_event_offers_all_b
2357: SET system_status_code = 'COMPLETED',
2358: last_status_date = SYSDATE,
2359: user_status_id = l_status_id,
2360: object_version_number = object_version_number + 1

Line 2406: FROM ams_event_offers_all_b

2402:
2403: -- Modified the select statement of the cursor to get event_object_type, as per enh # 3805347
2404: CURSOR c_evo_list IS
2405: SELECT event_offer_id,object_version_number,system_status_code, event_object_type
2406: FROM ams_event_offers_all_b
2407: WHERE event_offer_id = p_offer_id
2408: AND system_status_code <> 'COMPLETED';
2409:
2410: l_event_offer_id NUMBER ;

Line 2424: UPDATE ams_event_offers_all_b

2420: FETCH c_evo_list INTO l_event_offer_id,l_obj_version,l_status_code, l_obj_type; -- Modified as per enh # 3805347
2421: EXIT WHEN c_evo_list%NOTFOUND ;
2422: IF FND_API.G_TRUE = AMS_Utility_PVT.Check_Status_Change('AMS_EVENT_STATUS',l_status_code,'COMPLETED') THEN
2423: -- Can complete the schedule
2424: UPDATE ams_event_offers_all_b
2425: SET system_status_code = 'COMPLETED',
2426: last_status_date = SYSDATE,
2427: user_status_id = l_status_id,
2428: object_version_number = object_version_number + 1

Line 2479: FROM ams_event_offers_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
2479: FROM ams_event_offers_all_b
2480: WHERE parent_id = p_prog_id
2481: AND event_object_type = 'EONE'
2482: AND parent_type = 'RCAM';
2483:

Line 2715: UPDATE ams_event_offers_all_b

2711: LOOP
2712: FETCH c_schedule INTO l_schedule_id, l_obj_version, l_obj_type; -- Modified the fetch, as per enh # 3805347
2713: EXIT WHEN c_schedule%NOTFOUND ;
2714:
2715: UPDATE ams_event_offers_all_b
2716: SET system_status_code = 'ACTIVE',
2717: last_status_date = SYSDATE ,
2718: user_status_id = p_new_status_id,
2719: object_version_number = l_obj_version + 1

Line 2797: FROM ams_event_offers_all_b

2793:
2794: -- declare cursor for enh # 3805347
2795: CURSOR c_eve_det IS
2796: SELECT system_status_code, event_object_type
2797: FROM ams_event_offers_all_b
2798: WHERE event_offer_id = p_event_offer_id;
2799:
2800: l_old_status_code VARCHAR2(30); -- added as per enh # 3805347
2801: l_obj_type VARCHAR2(4); -- added as per enh # 3805347

Line 2810: UPDATE ams_event_offers_all_b

2806: OPEN c_eve_det;
2807: FETCH c_eve_det INTO l_old_status_code, l_obj_type;
2808: CLOSE c_eve_det;
2809:
2810: UPDATE ams_event_offers_all_b
2811: SET user_status_id = p_new_status_id,
2812: system_status_code = p_new_status_code,
2813: last_status_date = SYSDATE
2814: WHERE event_offer_id = p_event_offer_id;

Line 2858: FROM ams_event_offers_all_b

2854: WHERE event_header_id = p_event_id ;
2855:
2856: CURSOR c_offer_owner IS
2857: SELECT owner_user_id
2858: FROM ams_event_offers_all_b
2859: WHERE event_offer_id = p_event_id ;
2860:
2861: l_old_owner NUMBER ;
2862:

Line 2970: FROM ams_event_offers_all_b

2966:
2967: -- soagrawa 03-feb-2003 bug# 2781219
2968: CURSOR c_get_parent_type IS
2969: SELECT parent_type, owner_user_id
2970: FROM ams_event_offers_all_b
2971: WHERE event_offer_id = p_object_id;
2972:
2973: CURSOR c_csch_id IS
2974: SELECT schedule_id