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_ACT_DELIVERY_METHODS

Line 571: -- AMS_ACT_DELIVERY_METHODS table and returns delivery_method_id which is then

567:
568: /****************EVENT_DELIVERY_METHOD_ID**********************/
569: -- l_evo_rec will bring in delivery_method_code.. a l_dlv_rec record type is
570: -- constructed and passed to Create_Act_DelvMethod which creates a row in
571: -- AMS_ACT_DELIVERY_METHODS table and returns delivery_method_id which is then
572: -- inserted into ams_event_offers table.
573: -- Caution is advised that while retrieving records from event offers table,
574: -- delivery_method_id is retrieved and not delivery_method_code..
575: -- ams_event_offers_v takes care of that and returns delivery_method_code though

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