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.OZF_UTILITY_PVT dependencies on AMS_CAMPAIGNS_VL

Line 710: --x_table_name := 'AMS_CAMPAIGNS_VL';

706: x_table_name := 'AMS_CAMPAIGN_SCHEDULES_B';
707: x_pk_name := 'SCHEDULE_ID';
708: ELSIF (p_sys_qual ='CAMP') THEN
709: -- Start of code modified by ptendulk on 30-Jan-2001
710: --x_table_name := 'AMS_CAMPAIGNS_VL';
711: -- End of code modified by ptendulk on 30-Jan-2001
712: x_table_name := 'AMS_CAMPAIGNS_ALL_B';
713: x_pk_name := 'CAMPAIGN_ID';
714: ELSIF (p_sys_qual ='EVEO') THEN

Line 854: FROM ams_campaigns_vl

850: l_object_name VARCHAR2(1000);
851:
852: CURSOR c_campaign(p_object_id IN NUMBER) IS
853: SELECT campaign_name
854: FROM ams_campaigns_vl
855: WHERE campaign_id = p_object_id;
856:
857: --added 11/16/99 tdonohoe
858: CURSOR c_campaign_sched(p_object_id IN NUMBER) IS

Line 860: FROM ams_campaigns_vl c,

856:
857: --added 11/16/99 tdonohoe
858: CURSOR c_campaign_sched(p_object_id IN NUMBER) IS
859: SELECT c.campaign_name
860: FROM ams_campaigns_vl c,
861: ams_campaign_schedules s
862: WHERE s.campaign_schedule_id = p_object_id
863: AND s.campaign_id = c.campaign_id;
864:

Line 1332: -- FROM ams_campaigns_vl;

1328: -- get_lookup_meaning
1329: -- USAGE
1330: -- Example:
1331: -- SELECT OZF_Utility_PVT.get_lookup_meaning ('AMS_CAMPAIGN_STATUS', status_code)
1332: -- FROM ams_campaigns_vl;
1333: -- HISTORY
1334: -- 28-Apr-2000 choang Created.
1335: ---------------------------------------------------------------------
1336: FUNCTION get_lookup_meaning (

Line 1364: -- FROM ams_campaigns_vl

1360: -- get_resource_name
1361: -- USAGE
1362: -- Example:
1363: -- SELECT OZF_Utility_PVT.get_resource_name (owner_user_id)
1364: -- FROM ams_campaigns_vl
1365: -- HISTORY
1366: -- 28-Apr-2000 choang Created.
1367: ---------------------------------------------------------------------
1368: FUNCTION get_resource_name (

Line 1417: FROM ams_campaigns_vl A, jtf_loc_hierarchies_vl B

1413: WHERE location_hierarchy_id = p_country_id;
1414:
1415: CURSOR c_camp_area2 IS
1416: SELECT B.area2_code
1417: FROM ams_campaigns_vl A, jtf_loc_hierarchies_vl B
1418: WHERE A.campaign_id = p_object_id
1419: AND A.city_id = B.location_hierarchy_id;
1420:
1421: BEGIN