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 1162: from ams_event_offers_all_b

1158: REG_REQUIRED_FLAG,
1159: REG_FROZEN_FLAG,
1160: REG_EFFECTIVE_CAPACITY,
1161: REG_WAITLIST_PCT
1162: from ams_event_offers_all_b
1163: where EVENT_OFFER_ID = l_event_offer_id;
1164:
1165:
1166: BEGIN

Line 1668: from ams_event_offers_all_b

1664: CURSOR c_get_object_type(p_event_offer_id IN NUMBER) IS
1665: SELECT event_object_type,
1666: trunc(event_end_date) + 1,
1667: parent_type
1668: from ams_event_offers_all_b
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

Line 1680: from ams_event_offers_all_b e,

1676: cursor c_event_details(p_event_id NUMBER) is
1677: select e.reg_effective_capacity,
1678: e.system_status_code,
1679: u.name
1680: from ams_event_offers_all_b e,
1681: ams_user_statuses_vl u
1682: where e.event_offer_id = p_event_id
1683: and e.user_status_id = u.user_status_id;
1684:

Line 2104: from ams_event_offers_all_b

2100: l_owner_user_id NUMBER;
2101:
2102: CURSOR c_get_object_type(p_event_offer_id IN NUMBER) IS
2103: SELECT event_object_type, parent_type
2104: from ams_event_offers_all_b
2105: where event_offer_id = p_event_offer_id;
2106:
2107:
2108: /* what to do with registrant_party_id...not validating coz transfer calls

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

3114: t.EVENT_OFFER_NAME,
3115: b.waitlist_action_type_code,
3116: b.parent_type
3117: from
3118: ams_event_offers_all_b b,
3119: AMS_EVENT_OFFERS_ALL_TL t
3120: where b.event_offer_id = p_event_offer_id
3121: and t.event_offer_id = p_event_offer_id;
3122:

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

3181: l_return_status := FND_API.g_ret_sts_error;
3182: END IF; -- p_event_offer_id
3183:
3184: /* check Offer id's fk .....*/
3185: IF (AMS_Utility_PVT.check_fk_exists( 'ams_event_offers_all_b'
3186: , 'event_offer_id'
3187: , p_event_offer_id
3188: ) = FND_API.g_false
3189: )

Line 3731: from ams_event_offers_all_b

3727: REG_REQUIRED_FLAG,
3728: REG_FROZEN_FLAG,
3729: REG_EFFECTIVE_CAPACITY,
3730: REG_WAITLIST_PCT
3731: from ams_event_offers_all_b
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

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

3775: RAISE FND_API.g_exc_error;
3776: END IF; -- null ids
3777:
3778: -- check Offer id's fk .....
3779: IF (AMS_Utility_PVT.check_fk_exists( 'ams_event_offers_all_b'
3780: , 'event_offer_id'
3781: , p_old_offer_id
3782: ) = FND_API.g_false
3783: )

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

3786: x_return_status := FND_API.g_ret_sts_error;
3787: RAISE FND_API.g_exc_error;
3788: END IF; -- check_fk_exists
3789:
3790: IF (AMS_Utility_PVT.check_fk_exists( 'ams_event_offers_all_b'
3791: , 'event_offer_id'
3792: , p_new_offer_id
3793: ) = FND_API.g_false
3794: )

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

4262:
4263: ------------------- EVENT OFFER ID ----------------
4264: IF (p_evt_regs_rec.event_offer_id <> FND_API.g_miss_num)
4265: THEN
4266: IF (AMS_Utility_PVT.check_fk_exists( 'ams_event_offers_all_b'
4267: , 'event_offer_id'
4268: , p_evt_regs_rec.event_offer_id
4269: ) = FND_API.g_false
4270: )

Line 5236: FROM ams_event_offers_all_b

5232: source_code,
5233: reg_start_date,
5234: event_end_date,
5235: owner_user_id
5236: FROM ams_event_offers_all_b
5237: WHERE event_offer_id = p_event_offer_id;
5238:
5239: CURSOR c_media_item_id IS
5240: SELECT JTF_IH_MEDIA_ITEMS_S1.NEXTVAL