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_OFFERS_ALL_B

Line 139: from ams_event_offers_all_b

135: CURSOR c_get_object_type(p_event_offer_id IN NUMBER) IS
136: SELECT event_object_type,
137: trunc(event_end_date) + 1,
138: parent_type
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

Line 152: -- FROM AMS_event_offers_all_B Modified by ptendulk on 12-Feb-2002

148: CURSOR c_id_exists (l_id IN NUMBER) IS
149: SELECT 1
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:

Line 610: from AMS_event_offers_all_B

606:
607: if (p_effective_capacity = 0)
608: then
609: select reg_maximum_capacity into l_max_capacity --anchaudh added for bug#3119915.
610: from AMS_event_offers_all_B
611: where event_offer_id = p_event_offer_id;
612:
613: if(l_max_capacity is null) then --anchaudh added for bug#3119915.
614: l_availability := 1;

Line 1165: from ams_event_offers_all_b

1161: REG_EFFECTIVE_CAPACITY,
1162: REG_WAITLIST_PCT,
1163: reg_start_date,
1164: reg_end_date
1165: from ams_event_offers_all_b
1166: where EVENT_OFFER_ID = l_event_offer_id;
1167:
1168:
1169: BEGIN

Line 1683: from ams_event_offers_all_b

1679: CURSOR c_get_object_type(p_event_offer_id IN NUMBER) IS
1680: SELECT event_object_type,
1681: trunc(event_end_date) + 1,
1682: parent_type
1683: from ams_event_offers_all_b
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

Line 1695: from ams_event_offers_all_b e,

1691: cursor c_event_details(p_event_id NUMBER) is
1692: select e.reg_effective_capacity,
1693: e.system_status_code,
1694: u.name
1695: from ams_event_offers_all_b e,
1696: ams_user_statuses_vl u
1697: where e.event_offer_id = p_event_id
1698: and e.user_status_id = u.user_status_id;
1699:

Line 2119: from ams_event_offers_all_b

2115: l_owner_user_id NUMBER;
2116:
2117: CURSOR c_get_object_type(p_event_offer_id IN NUMBER) IS
2118: SELECT event_object_type, parent_type
2119: from ams_event_offers_all_b
2120: where event_offer_id = p_event_offer_id;
2121:
2122:
2123: /* what to do with registrant_party_id...not validating coz transfer calls

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 3133: ams_event_offers_all_b b,

3129: t.EVENT_OFFER_NAME,
3130: b.waitlist_action_type_code,
3131: b.parent_type
3132: from
3133: ams_event_offers_all_b b,
3134: AMS_EVENT_OFFERS_ALL_TL t
3135: where b.event_offer_id = p_event_offer_id
3136: and t.event_offer_id = p_event_offer_id;
3137:

Line 3200: IF (AMS_Utility_PVT.check_fk_exists( 'ams_event_offers_all_b'

3196: l_return_status := FND_API.g_ret_sts_error;
3197: END IF; -- p_event_offer_id
3198:
3199: /* check Offer id's fk .....*/
3200: IF (AMS_Utility_PVT.check_fk_exists( 'ams_event_offers_all_b'
3201: , 'event_offer_id'
3202: , p_event_offer_id
3203: ) = FND_API.g_false
3204: )

Line 3746: from ams_event_offers_all_b

3742: REG_REQUIRED_FLAG,
3743: REG_FROZEN_FLAG,
3744: REG_EFFECTIVE_CAPACITY,
3745: REG_WAITLIST_PCT
3746: from ams_event_offers_all_b
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

Line 3794: IF (AMS_Utility_PVT.check_fk_exists( 'ams_event_offers_all_b'

3790: RAISE FND_API.g_exc_error;
3791: END IF; -- null ids
3792:
3793: -- check Offer id's fk .....
3794: IF (AMS_Utility_PVT.check_fk_exists( 'ams_event_offers_all_b'
3795: , 'event_offer_id'
3796: , p_old_offer_id
3797: ) = FND_API.g_false
3798: )

Line 3805: IF (AMS_Utility_PVT.check_fk_exists( 'ams_event_offers_all_b'

3801: x_return_status := FND_API.g_ret_sts_error;
3802: RAISE FND_API.g_exc_error;
3803: END IF; -- check_fk_exists
3804:
3805: IF (AMS_Utility_PVT.check_fk_exists( 'ams_event_offers_all_b'
3806: , 'event_offer_id'
3807: , p_new_offer_id
3808: ) = FND_API.g_false
3809: )

Line 4281: IF (AMS_Utility_PVT.check_fk_exists( 'ams_event_offers_all_b'

4277:
4278: ------------------- EVENT OFFER ID ----------------
4279: IF (p_evt_regs_rec.event_offer_id <> FND_API.g_miss_num)
4280: THEN
4281: IF (AMS_Utility_PVT.check_fk_exists( 'ams_event_offers_all_b'
4282: , 'event_offer_id'
4283: , p_evt_regs_rec.event_offer_id
4284: ) = FND_API.g_false
4285: )

Line 5251: FROM ams_event_offers_all_b

5247: source_code,
5248: reg_start_date,
5249: event_end_date,
5250: owner_user_id
5251: FROM ams_event_offers_all_b
5252: WHERE event_offer_id = p_event_offer_id;
5253:
5254: CURSOR c_media_item_id IS
5255: SELECT JTF_IH_MEDIA_ITEMS_S1.NEXTVAL