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_EVENTOFFER_PVT dependencies on AMS_EVENT_OFFERS_ALL_B

Line 329: SELECT ams_event_offers_all_b_s.NEXTVAL

325: FROM ams_jtf_rs_emp_v
326: WHERE user_id = l_user_id;
327:
328: CURSOR c_evo_seq IS
329: SELECT ams_event_offers_all_b_s.NEXTVAL
330: FROM DUAL;
331:
332: CURSOR c_evo_count(evo_id IN NUMBER) IS
333: SELECT count(*)

Line 334: FROM ams_event_offers_all_b

330: FROM DUAL;
331:
332: CURSOR c_evo_count(evo_id IN NUMBER) IS
333: SELECT count(*)
334: FROM ams_event_offers_all_b
335: WHERE event_offer_id = evo_id;
336:
337: CURSOR c_evo_status_evagd(ust_id IN NUMBER) IS
338: SELECT system_status_code

Line 678: insert into ams_event_offers_all_b(

674: IF l_evo_rec.object_version_number = 2 THEN -- copy
675: l_ovn := 2;
676: END IF;
677:
678: insert into ams_event_offers_all_b(
679: event_offer_id
680: ,setup_type_id
681: ,last_update_date
682: ,last_updated_by

Line 1173: FROM AMS_EVENT_OFFERS_ALL_B

1169: l_object_type VARCHAR2(30);
1170:
1171: CURSOR get_event_object_type(id_in in NUMBER) is
1172: SELECT event_object_type
1173: FROM AMS_EVENT_OFFERS_ALL_B
1174: WHERE EVENT_OFFER_ID = id_in;
1175:
1176: CURSOR get_res_id(l_user_id IN NUMBER) IS
1177: SELECT resource_id

Line 1183: FROM ams_event_offers_all_b

1179: WHERE user_id = l_user_id;
1180:
1181: CURSOR get_parent_offer_info(l_evo_id IN NUMBER) IS
1182: SELECT event_level,parent_event_offer_id
1183: FROM ams_event_offers_all_b
1184: WHERE event_offer_id = l_evo_id
1185: and event_level = 'SUB';
1186:
1187: BEGIN

Line 1252: UPDATE ams_event_offers_all_b

1248:
1249: AMS_Utility_PVT.debug_message(l_full_name ||': delete');
1250: END IF;
1251:
1252: UPDATE ams_event_offers_all_b
1253: SET active_flag = 'N'
1254: WHERE event_offer_id = p_evo_id
1255: AND object_version_number = p_object_version;
1256:

Line 1351: FROM ams_event_offers_all_b

1347: l_evo_id NUMBER;
1348:
1349: CURSOR c_evo_b IS
1350: SELECT event_offer_id
1351: FROM ams_event_offers_all_b
1352: WHERE event_offer_id = p_evo_id
1353: AND object_version_number = p_object_version
1354: FOR UPDATE OF event_offer_id NOWAIT;
1355:

Line 1590: FROM Ams_act_delivery_methods dlv, ams_event_offers_all_b off

1586: AND system_status_type = 'AMS_EVENT_STATUS';
1587:
1588: CURSOR c_evo_dlv_mthd IS
1589: SELECT dlv.delivery_media_type_code, dlv.activity_delivery_method_id, dlv.object_version_number
1590: FROM Ams_act_delivery_methods dlv, ams_event_offers_all_b off
1591: WHERE dlv.activity_delivery_method_id = off.event_delivery_method_id
1592: and off.event_offer_id = p_evo_rec.event_offer_id;
1593:
1594: CURSOR c_pricelist_header_id(curr_code IN VARCHAR2) IS

Line 1596: FROM ams_event_offers_all_b evo, qp_price_lists_v qph

1592: and off.event_offer_id = p_evo_rec.event_offer_id;
1593:
1594: CURSOR c_pricelist_header_id(curr_code IN VARCHAR2) IS
1595: SELECT distinct(pricelist_header_id)
1596: FROM ams_event_offers_all_b evo, qp_price_lists_v qph
1597: WHERE evo.pricelist_header_id = qph.price_list_id
1598: AND qph.currency_code = curr_code;
1599:
1600: CURSOR get_res_id(l_user_id IN NUMBER) IS

Line 1607: FROM hz_locations loc, ams_event_offers_all_b evo

1603: WHERE user_id = l_user_id;
1604:
1605: CURSOR c_location(id_in IN NUMBER) IS
1606: SELECT loc.address1, loc.address2, loc.city, loc.state, loc.country
1607: FROM hz_locations loc, ams_event_offers_all_b evo
1608: WHERE loc.location_id = evo.event_location_id
1609: and evo.event_offer_id = id_in;
1610:
1611:

Line 1620: FROM ams_event_offers_all_b

1616: AND act_budget_used_by_id =id_in;
1617:
1618: CURSOR c_evo IS
1619: SELECT global_flag,source_code
1620: FROM ams_event_offers_all_b
1621: WHERE event_offer_id = p_evo_rec.event_offer_id;
1622:
1623: CURSOR c_resources IS
1624: SELECT activity_resource_id, object_version_number

Line 1631: FROM ams_event_offers_all_b

1627:
1628: /*
1629: CURSOR c_venue_id IS
1630: SELECT event_venue_id, event_start_date, event_end_date, system_status_code
1631: FROM ams_event_offers_all_b
1632: WHERE event_offer_id = p_evo_rec.event_offer_id;
1633: */
1634:
1635: CURSOR c_old_dates IS

Line 1637: FROM ams_event_offers_all_b

1633: */
1634:
1635: CURSOR c_old_dates IS
1636: SELECT event_start_date_time, event_end_date_time
1637: FROM ams_event_offers_all_b
1638: WHERE event_offer_id = p_evo_rec.event_offer_id;
1639:
1640: CURSOR C_get_event_resources(id_in IN NUMBER) IS
1641: SELECT activity_resource_id, object_version_number

Line 2505: UPDATE ams_event_offers_all_b SET

2501: -- The other update statement is needed for the Agenda items for which the status change
2502: -- is straight-forward.
2503:
2504: IF l_evo_rec.event_level = 'MAIN' THEN
2505: UPDATE ams_event_offers_all_b SET
2506: last_update_date = SYSDATE,
2507: last_updated_by = FND_GLOBAL.user_id,
2508: last_update_login = FND_GLOBAL.conc_login_id,
2509: object_version_number = l_evo_rec.object_version_number + 1,

Line 2626: UPDATE ams_event_offers_all_b SET

2622: ,EVENT_PURPOSE_CODE = l_evo_rec.EVENT_PURPOSE_CODE /* Hornet */
2623: WHERE event_offer_id = l_evo_rec.event_offer_id
2624: AND object_version_number = l_evo_rec.object_version_number;
2625: ELSIF l_evo_rec.event_level = 'SUB' THEN
2626: UPDATE ams_event_offers_all_b SET
2627: last_update_date = SYSDATE,
2628: last_updated_by = FND_GLOBAL.user_id,
2629: last_update_login = FND_GLOBAL.conc_login_id,
2630: object_version_number = l_evo_rec.object_version_number + 1,

Line 2787: UPDATE ams_event_offers_all_b SET

2783: ELSIF l_return_status = FND_API.g_ret_sts_error THEN
2784: RAISE FND_API.g_exc_error;
2785: END IF;
2786:
2787: UPDATE ams_event_offers_all_b SET
2788: event_start_date = l_evo_rec.event_start_date,
2789: event_end_date = l_evo_rec.event_end_date,
2790: event_venue_id = l_evo_rec.event_venue_id
2791: WHERE event_offer_id = l_evo_rec.event_offer_id;

Line 3234: 'ams_event_offers_all_b',

3230: IF p_validation_mode = JTF_PLSQL_API.g_create
3231: AND p_evo_rec.event_offer_id IS NOT NULL
3232: THEN
3233: IF AMS_Utility_PVT.check_uniqueness(
3234: 'ams_event_offers_all_b',
3235: 'event_offer_id = ' || p_evo_rec.event_offer_id
3236: ) = FND_API.g_false
3237: THEN
3238: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN

Line 3382: 'ams_event_offers_all_b',

3378: IF p_evo_rec.parent_event_offer_id <> FND_API.g_miss_num
3379: AND p_evo_rec.parent_event_offer_id IS NOT NULL THEN
3380: IF p_evo_rec.EVENT_STANDALONE_FLAG = 'Y'THEN
3381: IF AMS_Utility_PVT.check_fk_exists(
3382: 'ams_event_offers_all_b',
3383: 'event_offer_id',
3384: p_evo_rec.parent_event_offer_id
3385: ) = FND_API.g_false
3386: THEN

Line 4771: select source_code from ams_event_offers_all_b

4767: l_dummy number;
4768: l_src_code varchar2(30);
4769:
4770: /* cursor c_src_code(id_in) IS
4771: select source_code from ams_event_offers_all_b
4772: where event_offer_id = id_in;
4773: */
4774: BEGIN
4775:

Line 6803: l_evo_id AMS_event_offers_all_b.event_offer_id%type;

6799: l_evo_rec AMS_EVENTOFFER_PVT.evo_rec_type;
6800: l_return_status VARCHAR2(1);
6801: l_msg_count NUMBER;
6802: l_msg_data VARCHAR2(200);
6803: l_evo_id AMS_event_offers_all_b.event_offer_id%type;
6804:
6805: BEGIN
6806: --AMS_EVENTOFFER_PVT.init_evo_rec(l_evo_rec);
6807: -- l_evo_rec.source_code:= 'CAMP101';

Line 6871: FROM ams_event_offers_all_b evo, qp_price_lists_v qph

6867:
6868:
6869: CURSOR c_pricelist_header_id(curr_code IN VARCHAR2) IS
6870: SELECT distinct(pricelist_header_id)
6871: FROM ams_event_offers_all_b evo, qp_price_lists_v qph
6872: WHERE evo.pricelist_header_id = qph.price_list_id
6873: AND qph.currency_code = curr_code;
6874:
6875: BEGIN

Line 7012: FROM ams_event_offers_all_b

7008:
7009: CURSOR c_event_schedule IS
7010: -- SELECT event_start_date, event_end_date FROM ams_event_offers_v
7011: SELECT event_start_date, event_end_date
7012: FROM ams_event_offers_all_b
7013: WHERE event_offer_id = p_evo_rec.parent_event_offer_id and system_status_code<> 'CANCELLED';--implemented ER2381975 by anchaudh.
7014:
7015:
7016: BEGIN

Line 7251: FROM ams_event_offers_all_b

7247: AND system_status_type = 'AMS_EVENT_STATUS';
7248:
7249: CURSOR c_details IS
7250: SELECT event_venue_id, event_start_date, event_end_date, system_status_code
7251: FROM ams_event_offers_all_b
7252: WHERE event_offer_id = p_evo_rec.event_offer_id;
7253:
7254: l_return_status VARCHAR2(1);
7255: l_fulfilment VARCHAR2(30);