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.

[Home] [Help]

APPS.AMS_EVTREGS_PVT dependencies on AMS_EVENT_REGISTRATIONS

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 154: FROM ams_event_registrations

150: FROM dual
151: WHERE EXISTS (SELECT 1
152: -- FROM AMS_event_offers_all_B Modified by ptendulk on 12-Feb-2002
153: -- WHERE event_offer_id = l_id);
154: FROM ams_event_registrations
155: WHERE event_registration_id = l_id);
156:
157: CURSOR c_evt_reg_conf_seq IS
158: SELECT ams_event_reg_confirmation_s.nextval

Line 233: INSERT INTO AMS_EVENT_REGISTRATIONS(

229: l_date_reg_placed := sysdate;
230: END IF;
231: -- end update on Mar 12, 2003
232:
233: INSERT INTO AMS_EVENT_REGISTRATIONS(
234: EVENT_REGISTRATION_ID,
235: LAST_UPDATE_DATE,
236: LAST_UPDATED_BY,
237: CREATION_DATE,

Line 558: from AMS_EVENT_REGISTRATIONS

554: RETURN NUMBER
555: IS
556: cursor c_num_registered is
557: select count(*)
558: from AMS_EVENT_REGISTRATIONS
559: where event_offer_id = p_event_offer_id
560: and system_status_code = 'REGISTERED';
561:
562: l_num_registered NUMBER := 0;

Line 580: from AMS_EVENT_REGISTRATIONS

576: RETURN NUMBER
577: IS
578: cursor c_num_waitlisted is
579: select count(*)
580: from AMS_EVENT_REGISTRATIONS
581: where event_offer_id = p_event_offer_id
582: and system_status_code = 'WAITLISTED';
583:
584: l_num_waitlisted NUMBER := 0;

Line 635: from AMS_EVENT_REGISTRATIONS

631: IS
632:
633: cursor c_num_waitlist_done is
634: select count(*)
635: from AMS_EVENT_REGISTRATIONS
636: where event_offer_id = l_event_offer_id
637: and system_status_code = 'WAITLISTED';
638:
639: l_num_of_waitlist_done NUMBER := 0;

Line 964: FROM ams_event_registrations

960: last_notified_time, -- Hornet : added for imeeting integration
961: EVENT_JOIN_TIME, -- Hornet : added for imeeting integration
962: EVENT_EXIT_TIME, -- Hornet : added for imeeting integration
963: MEETING_ENCRYPTION_KEY_CODE -- Hornet : added for imeeting integration
964: FROM ams_event_registrations
965: WHERE confirmation_code = p_old_confirmation_code
966: and event_offer_id = p_old_offer_id;
967:
968: l_evt_regs_rec evt_regs_rec_type;

Line 1454: FROM ams_event_registrations

1450: );
1451:
1452: CURSOR c_reg IS
1453: SELECT *
1454: FROM ams_event_registrations
1455: WHERE event_registration_id = p_evt_regs_rec.event_registration_id;
1456:
1457: Cursor c_cancel_status_id is
1458: select user_status_id

Line 1673: from ams_event_registrations

1669: where event_offer_id = p_event_offer_id;
1670:
1671: cursor c_old_reg_status(p_reg_id NUMBER) is
1672: select system_status_code
1673: from ams_event_registrations
1674: where event_registration_id = p_reg_id;
1675:
1676: cursor c_event_details(p_event_id NUMBER) is
1677: select e.reg_effective_capacity,

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 2144: from ams_event_offers_all_b offers, ams_event_registrations reg, ams_user_statuses_vl usrsts

2140: offers.EVENT_END_DATE,
2141: offers.EVENT_END_DATE_TIME,
2142: offers.REG_END_DATE,
2143: offers.REG_END_TIME
2144: from ams_event_offers_all_b offers, ams_event_registrations reg, ams_user_statuses_vl usrsts
2145: where offers.EVENT_OFFER_ID = l_event_offer_id
2146: and reg.EVENT_OFFER_ID = l_event_offer_id
2147: and reg.CONFIRMATION_CODE = l_confirmation_code
2148: and nvl(l_registrant_party_id, reg.REGISTRANT_PARTY_ID) = reg.REGISTRANT_PARTY_ID

Line 2158: from ams_event_registrations

2154: is
2155: select
2156: REGISTRANT_PARTY_ID,
2157: CONFIRMATION_CODE
2158: from ams_event_registrations
2159: where EVENT_OFFER_ID = l_event_offer_id
2160: and REGISTRATION_GROUP_ID = l_registration_group_id;
2161:
2162: l_cancel_reg_conf_data cancel_reg_conf_details%ROWTYPE;

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 2844: FROM ams_event_registrations

2840: l_reg_id NUMBER := p_event_registration_id;
2841:
2842: CURSOR c_reg_b IS
2843: SELECT event_registration_id
2844: FROM ams_event_registrations
2845: WHERE event_registration_id = l_reg_id
2846: AND object_version_number = p_object_version
2847: FOR UPDATE OF event_registration_id NOWAIT;
2848:

Line 2994: UPDATE ams_event_registrations

2990:
2991: AMS_Utility_PVT.debug_message(l_full_name ||': delete');
2992: END IF;
2993:
2994: UPDATE ams_event_registrations
2995: SET active_flag = 'N'
2996: WHERE event_registration_id = p_event_registration_id
2997: AND object_version_number = p_object_version;
2998:

Line 3130: from ams_event_registrations

3126: --auto_register_flag,
3127: SALESREP_ID,
3128: ORDER_HEADER_ID,
3129: ORDER_LINE_ID
3130: from ams_event_registrations
3131: where event_offer_id = p_event_offer_id
3132: and system_status_code = 'WAITLISTED'
3133: and waitlisted_priority = (select min(waitlisted_priority)
3134: from ams_event_registrations

Line 3134: from ams_event_registrations

3130: from ams_event_registrations
3131: where event_offer_id = p_event_offer_id
3132: and system_status_code = 'WAITLISTED'
3133: and waitlisted_priority = (select min(waitlisted_priority)
3134: from ams_event_registrations
3135: where event_offer_id = p_event_offer_id
3136: and system_status_code = 'WAITLISTED'
3137: );
3138:

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),

Line 3736: from ams_event_registrations

3732: where event_offer_id = l_event_offer_id;
3733:
3734: Cursor get_registrant_status(p_confirmation_code VARCHAR2) IS
3735: select system_status_code
3736: from ams_event_registrations
3737: where confirmation_code = p_confirmation_code;
3738:
3739: BEGIN
3740:

Line 4204: from ams_event_registrations

4200: l_dummy NUMBER;
4201: cursor c_conf_code(conf_code_in IN VARCHAR2) IS
4202: SELECT 1 FROM DUAL
4203: WHERE EXISTS (select 1
4204: from ams_event_registrations
4205: where confirmation_code = conf_code_in
4206: );
4207:
4208: BEGIN

Line 4217: IF (AMS_Utility_PVT.check_uniqueness( 'ams_event_registrations'

4213: IF ( (p_validation_mode = JTF_PLSQL_API.g_create)
4214: AND (p_event_registration_id IS NOT NULL)
4215: )
4216: THEN
4217: IF (AMS_Utility_PVT.check_uniqueness( 'ams_event_registrations'
4218: , 'event_registration_id = ' || p_event_registration_id
4219: ) = FND_API.g_false
4220: )
4221: THEN

Line 4233: IF (AMS_Utility_PVT.check_uniqueness( 'ams_event_registrations'

4229: AND (p_confirmation_code IS NOT NULL)
4230: )
4231: THEN
4232: /* bug#1490374 commented OUT NOCOPY this piece
4233: IF (AMS_Utility_PVT.check_uniqueness( 'ams_event_registrations'
4234: , 'confirmation_code = ''' || p_confirmation_code || ''''
4235: ) = FND_API.g_false
4236: )
4237: */

Line 4591: from ams_event_registrations

4587: registrant_contact_id,
4588: attendant_party_id,
4589: attendant_contact_id,
4590: event_offer_id
4591: from ams_event_registrations
4592: where registrant_party_id = p_reg_party_id
4593: and registrant_contact_id = p_reg_contact_id
4594: and attendant_party_id = p_attendant_party_id
4595: and attendant_contact_id = p_attendant_contact_id

Line 4854: FROM ams_event_registrations

4850: IS
4851:
4852: CURSOR c_reg IS
4853: SELECT *
4854: FROM ams_event_registrations
4855: WHERE event_registration_id = p_evt_regs_rec.event_registration_id;
4856:
4857: l_reg_rec c_reg%ROWTYPE;
4858: