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_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 1469: FROM ams_event_registrations

1465: );
1466:
1467: CURSOR c_reg IS
1468: SELECT *
1469: FROM ams_event_registrations
1470: WHERE event_registration_id = p_evt_regs_rec.event_registration_id;
1471:
1472: Cursor c_cancel_status_id is
1473: select user_status_id

Line 1688: from ams_event_registrations

1684: where event_offer_id = p_event_offer_id;
1685:
1686: cursor c_old_reg_status(p_reg_id NUMBER) is
1687: select system_status_code
1688: from ams_event_registrations
1689: where event_registration_id = p_reg_id;
1690:
1691: cursor c_event_details(p_event_id NUMBER) is
1692: select e.reg_effective_capacity,

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

2155: offers.EVENT_END_DATE,
2156: offers.EVENT_END_DATE_TIME,
2157: offers.REG_END_DATE,
2158: offers.REG_END_TIME
2159: from ams_event_offers_all_b offers, ams_event_registrations reg, ams_user_statuses_vl usrsts
2160: where offers.EVENT_OFFER_ID = l_event_offer_id
2161: and reg.EVENT_OFFER_ID = l_event_offer_id
2162: and reg.CONFIRMATION_CODE = l_confirmation_code
2163: and nvl(l_registrant_party_id, reg.REGISTRANT_PARTY_ID) = reg.REGISTRANT_PARTY_ID

Line 2173: from ams_event_registrations

2169: is
2170: select
2171: REGISTRANT_PARTY_ID,
2172: CONFIRMATION_CODE
2173: from ams_event_registrations
2174: where EVENT_OFFER_ID = l_event_offer_id
2175: and REGISTRATION_GROUP_ID = l_registration_group_id;
2176:
2177: l_cancel_reg_conf_data cancel_reg_conf_details%ROWTYPE;

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

2855: l_reg_id NUMBER := p_event_registration_id;
2856:
2857: CURSOR c_reg_b IS
2858: SELECT event_registration_id
2859: FROM ams_event_registrations
2860: WHERE event_registration_id = l_reg_id
2861: AND object_version_number = p_object_version
2862: FOR UPDATE OF event_registration_id NOWAIT;
2863:

Line 3009: UPDATE ams_event_registrations

3005:
3006: AMS_Utility_PVT.debug_message(l_full_name ||': delete');
3007: END IF;
3008:
3009: UPDATE ams_event_registrations
3010: SET active_flag = 'N'
3011: WHERE event_registration_id = p_event_registration_id
3012: AND object_version_number = p_object_version;
3013:

Line 3145: from ams_event_registrations

3141: --auto_register_flag,
3142: SALESREP_ID,
3143: ORDER_HEADER_ID,
3144: ORDER_LINE_ID
3145: from ams_event_registrations
3146: where event_offer_id = p_event_offer_id
3147: and system_status_code = 'WAITLISTED'
3148: and waitlisted_priority = (select min(waitlisted_priority)
3149: from ams_event_registrations

Line 3149: from ams_event_registrations

3145: from ams_event_registrations
3146: where event_offer_id = p_event_offer_id
3147: and system_status_code = 'WAITLISTED'
3148: and waitlisted_priority = (select min(waitlisted_priority)
3149: from ams_event_registrations
3150: where event_offer_id = p_event_offer_id
3151: and system_status_code = 'WAITLISTED'
3152: );
3153:

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

Line 3751: from ams_event_registrations

3747: where event_offer_id = l_event_offer_id;
3748:
3749: Cursor get_registrant_status(p_confirmation_code VARCHAR2) IS
3750: select system_status_code
3751: from ams_event_registrations
3752: where confirmation_code = p_confirmation_code;
3753:
3754: BEGIN
3755:

Line 4219: from ams_event_registrations

4215: l_dummy NUMBER;
4216: cursor c_conf_code(conf_code_in IN VARCHAR2) IS
4217: SELECT 1 FROM DUAL
4218: WHERE EXISTS (select 1
4219: from ams_event_registrations
4220: where confirmation_code = conf_code_in
4221: );
4222:
4223: BEGIN

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

4228: IF ( (p_validation_mode = JTF_PLSQL_API.g_create)
4229: AND (p_event_registration_id IS NOT NULL)
4230: )
4231: THEN
4232: IF (AMS_Utility_PVT.check_uniqueness( 'ams_event_registrations'
4233: , 'event_registration_id = ' || p_event_registration_id
4234: ) = FND_API.g_false
4235: )
4236: THEN

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

4244: AND (p_confirmation_code IS NOT NULL)
4245: )
4246: THEN
4247: /* bug#1490374 commented OUT NOCOPY this piece
4248: IF (AMS_Utility_PVT.check_uniqueness( 'ams_event_registrations'
4249: , 'confirmation_code = ''' || p_confirmation_code || ''''
4250: ) = FND_API.g_false
4251: )
4252: */

Line 4606: from ams_event_registrations

4602: registrant_contact_id,
4603: attendant_party_id,
4604: attendant_contact_id,
4605: event_offer_id
4606: from ams_event_registrations
4607: where registrant_party_id = p_reg_party_id
4608: and registrant_contact_id = p_reg_contact_id
4609: and attendant_party_id = p_attendant_party_id
4610: and attendant_contact_id = p_attendant_contact_id

Line 4869: FROM ams_event_registrations

4865: IS
4866:
4867: CURSOR c_reg IS
4868: SELECT *
4869: FROM ams_event_registrations
4870: WHERE event_registration_id = p_evt_regs_rec.event_registration_id;
4871:
4872: l_reg_rec c_reg%ROWTYPE;
4873: