APPS.AMS_EVTREGS_PVT dependencies on AMS_EVENT_REGISTRATIONS_S

Line 143: SELECT ams_event_registrations_s.NEXTVAL

139: from ams_event_offers_all_b
140: where event_offer_id = p_event_offer_id;
141:
142: CURSOR c_evt_regs_seq IS
143: SELECT ams_event_registrations_s.NEXTVAL
144: FROM DUAL;
145:
146: -- added by soagrawa on 24-oct-2002 for uniqueness sake
147: -- needed so as to not conflict with ids generated in migration

Line 1826: update AMS_EVENT_REGISTRATIONS set

1822:
1823: AMS_Utility_PVT.debug_message(l_full_name || ': update');
1824: END IF;
1825:
1826: update AMS_EVENT_REGISTRATIONS set
1827: LAST_UPDATE_DATE = sysdate,
1828: LAST_UPDATED_BY = FND_GLOBAL.user_id,
1829: LAST_UPDATE_LOGIN = FND_GLOBAL.conc_login_id,
1830: OBJECT_VERSION_NUMBER = l_evt_regs_Rec.OBJECT_VERSION_NUMBER + 1,

Line 2317: UPDATE ams_event_registrations SET

2313: CLOSE c_evtregs_cancel_seq;
2314: END IF; -- l_cancellation_code
2315: l_cancellation_code := to_char(l_cancellation_id);
2316:
2317: UPDATE ams_event_registrations SET
2318: system_status_code = 'CANCELLED',
2319: USER_STATUS_ID = l_user_stat_id,
2320: cancellation_code = l_cancellation_code,
2321: cancellation_reason_code = l_cancellation_reason_code,

Line 2424: UPDATE ams_event_registrations SET

2420: INTO l_cancellation_id;
2421: CLOSE c_evtregs_cancel_seq;
2422: END IF; -- l_cancellation_code
2423: l_cancellation_code := to_char(l_cancellation_id);
2424: UPDATE ams_event_registrations SET
2425: system_status_code = 'CANCELLED',
2426: USER_STATUS_ID = l_user_stat_id,
2427: cancellation_code = l_cancellation_code,
2428: cancellation_reason_code = l_cancellation_reason_code,

Line 2574: UPDATE ams_event_registrations SET

2570: CLOSE c_evtregs_cancel_seq;
2571: END IF; -- l_cancellation_code
2572: l_cancellation_code := to_char(l_cancellation_id);
2573:
2574: UPDATE ams_event_registrations SET
2575: system_status_code = 'CANCELLED',
2576: USER_STATUS_ID = l_user_stat_id,
2577: cancellation_code = l_cancellation_code,
2578: cancellation_reason_code = l_cancellation_reason_code,

Line 2688: UPDATE ams_event_registrations SET

2684: CLOSE c_evtregs_cancel_seq;
2685: END IF; -- l_cancellation_code
2686: l_cancellation_code := to_char(l_cancellation_id);
2687:
2688: UPDATE ams_event_registrations SET
2689: system_status_code = 'CANCELLED',
2690: USER_STATUS_ID = l_user_stat_id,
2691: cancellation_code = l_cancellation_code,
2692: cancellation_reason_code = l_cancellation_reason_code,

Line 3377: update ams_event_registrations set

3373: RAISE FND_API.g_exc_unexpected_error;
3374: END IF; -- l_return_status
3375: ELSE -- l_e_auto_register_flag
3376: */
3377: update ams_event_registrations set
3378: system_status_code = 'REGISTERED',
3379: waitlisted_priority = null,
3380: user_status_id = (select user_status_id
3381: from ams_user_statuses_vl

Line 3611: update AMS_EVENT_REGISTRATIONS set

3607:
3608: AMS_Utility_PVT.debug_message(l_full_name || ': update');
3609: END IF;
3610:
3611: update AMS_EVENT_REGISTRATIONS set
3612: ATTENDANT_PARTY_ID = p_attendant_party_id,
3613: ATTENDANT_CONTACT_ID = p_attendant_contact_id,
3614: ATTENDANT_ACCOUNT_ID = nvl(p_attendant_account_id,attendant_account_id),
3615: REGISTRANT_PARTY_ID = nvl(p_registrant_party_id, registrant_party_id),