APPS.AMS_EVENTOFFER_PVT dependencies on AMS_EVENT_OFFERS_ALL_B_S

Line 329: SELECT ams_event_offers_all_b_s.NEXTVAL

325: FROM ams_jtf_rs_emp_v
326: WHERE user_id = l_user_id;
327:
328: CURSOR c_evo_seq IS
329: SELECT ams_event_offers_all_b_s.NEXTVAL
330: FROM DUAL;
331:
332: CURSOR c_evo_count(evo_id IN NUMBER) IS
333: SELECT count(*)

Line 2505: UPDATE ams_event_offers_all_b SET

2501: -- The other update statement is needed for the Agenda items for which the status change
2502: -- is straight-forward.
2503:
2504: IF l_evo_rec.event_level = 'MAIN' THEN
2505: UPDATE ams_event_offers_all_b SET
2506: last_update_date = SYSDATE,
2507: last_updated_by = FND_GLOBAL.user_id,
2508: last_update_login = FND_GLOBAL.conc_login_id,
2509: object_version_number = l_evo_rec.object_version_number + 1,

Line 2626: UPDATE ams_event_offers_all_b SET

2622: ,EVENT_PURPOSE_CODE = l_evo_rec.EVENT_PURPOSE_CODE /* Hornet */
2623: WHERE event_offer_id = l_evo_rec.event_offer_id
2624: AND object_version_number = l_evo_rec.object_version_number;
2625: ELSIF l_evo_rec.event_level = 'SUB' THEN
2626: UPDATE ams_event_offers_all_b SET
2627: last_update_date = SYSDATE,
2628: last_updated_by = FND_GLOBAL.user_id,
2629: last_update_login = FND_GLOBAL.conc_login_id,
2630: object_version_number = l_evo_rec.object_version_number + 1,

Line 2787: UPDATE ams_event_offers_all_b SET

2783: ELSIF l_return_status = FND_API.g_ret_sts_error THEN
2784: RAISE FND_API.g_exc_error;
2785: END IF;
2786:
2787: UPDATE ams_event_offers_all_b SET
2788: event_start_date = l_evo_rec.event_start_date,
2789: event_end_date = l_evo_rec.event_end_date,
2790: event_venue_id = l_evo_rec.event_venue_id
2791: WHERE event_offer_id = l_evo_rec.event_offer_id;