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 1811: update AMS_EVENT_REGISTRATIONS set

1807:
1808: AMS_Utility_PVT.debug_message(l_full_name || ': update');
1809: END IF;
1810:
1811: update AMS_EVENT_REGISTRATIONS set
1812: LAST_UPDATE_DATE = sysdate,
1813: LAST_UPDATED_BY = FND_GLOBAL.user_id,
1814: LAST_UPDATE_LOGIN = FND_GLOBAL.conc_login_id,
1815: OBJECT_VERSION_NUMBER = l_evt_regs_Rec.OBJECT_VERSION_NUMBER + 1,

Line 2302: UPDATE ams_event_registrations SET

2298: CLOSE c_evtregs_cancel_seq;
2299: END IF; -- l_cancellation_code
2300: l_cancellation_code := to_char(l_cancellation_id);
2301:
2302: UPDATE ams_event_registrations SET
2303: system_status_code = 'CANCELLED',
2304: USER_STATUS_ID = l_user_stat_id,
2305: cancellation_code = l_cancellation_code,
2306: cancellation_reason_code = l_cancellation_reason_code,

Line 2409: UPDATE ams_event_registrations SET

2405: INTO l_cancellation_id;
2406: CLOSE c_evtregs_cancel_seq;
2407: END IF; -- l_cancellation_code
2408: l_cancellation_code := to_char(l_cancellation_id);
2409: UPDATE ams_event_registrations SET
2410: system_status_code = 'CANCELLED',
2411: USER_STATUS_ID = l_user_stat_id,
2412: cancellation_code = l_cancellation_code,
2413: cancellation_reason_code = l_cancellation_reason_code,

Line 2559: UPDATE ams_event_registrations SET

2555: CLOSE c_evtregs_cancel_seq;
2556: END IF; -- l_cancellation_code
2557: l_cancellation_code := to_char(l_cancellation_id);
2558:
2559: UPDATE ams_event_registrations SET
2560: system_status_code = 'CANCELLED',
2561: USER_STATUS_ID = l_user_stat_id,
2562: cancellation_code = l_cancellation_code,
2563: cancellation_reason_code = l_cancellation_reason_code,

Line 2673: UPDATE ams_event_registrations SET

2669: CLOSE c_evtregs_cancel_seq;
2670: END IF; -- l_cancellation_code
2671: l_cancellation_code := to_char(l_cancellation_id);
2672:
2673: UPDATE ams_event_registrations SET
2674: system_status_code = 'CANCELLED',
2675: USER_STATUS_ID = l_user_stat_id,
2676: cancellation_code = l_cancellation_code,
2677: cancellation_reason_code = l_cancellation_reason_code,

Line 3362: update ams_event_registrations set

3358: RAISE FND_API.g_exc_unexpected_error;
3359: END IF; -- l_return_status
3360: ELSE -- l_e_auto_register_flag
3361: */
3362: update ams_event_registrations set
3363: system_status_code = 'REGISTERED',
3364: waitlisted_priority = null,
3365: user_status_id = (select user_status_id
3366: from ams_user_statuses_vl

Line 3596: update AMS_EVENT_REGISTRATIONS set

3592:
3593: AMS_Utility_PVT.debug_message(l_full_name || ': update');
3594: END IF;
3595:
3596: update AMS_EVENT_REGISTRATIONS set
3597: ATTENDANT_PARTY_ID = p_attendant_party_id,
3598: ATTENDANT_CONTACT_ID = p_attendant_contact_id,
3599: ATTENDANT_ACCOUNT_ID = nvl(p_attendant_account_id,attendant_account_id),
3600: REGISTRANT_PARTY_ID = nvl(p_registrant_party_id, registrant_party_id),