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 727: --x_table_name := 'AMS_CAMPAIGNS_VL';

723: x_table_name := 'AMS_CAMPAIGN_SCHEDULES_B';
724: x_pk_name := 'SCHEDULE_ID';
725: ELSIF (p_sys_qual ='CAMP') THEN
726: -- Start of code modified by ptendulk on 30-Jan-2001
727: --x_table_name := 'AMS_CAMPAIGNS_VL';
728: -- End of code modified by ptendulk on 30-Jan-2001
729: x_table_name := 'AMS_CAMPAIGNS_ALL_B';
730: x_pk_name := 'CAMPAIGN_ID';
731: ELSIF (p_sys_qual ='EVEO') THEN

Line 871: FROM ams_campaigns_vl

867: l_object_name VARCHAR2(1000);
868:
869: CURSOR c_campaign(p_object_id IN NUMBER) IS
870: SELECT campaign_name
871: FROM ams_campaigns_vl
872: WHERE campaign_id = p_object_id;
873:
874: --added 11/16/99 tdonohoe
875: CURSOR c_campaign_sched(p_object_id IN NUMBER) IS

Line 877: FROM ams_campaigns_vl c,

873:
874: --added 11/16/99 tdonohoe
875: CURSOR c_campaign_sched(p_object_id IN NUMBER) IS
876: SELECT c.campaign_name
877: FROM ams_campaigns_vl c,
878: ams_campaign_schedules s
879: WHERE s.campaign_schedule_id = p_object_id
880: AND s.campaign_id = c.campaign_id;
881:

Line 1357: -- FROM ams_campaigns_vl;

1353: -- get_lookup_meaning
1354: -- USAGE
1355: -- Example:
1356: -- SELECT OZF_Utility_PVT.get_lookup_meaning ('AMS_CAMPAIGN_STATUS', status_code)
1357: -- FROM ams_campaigns_vl;
1358: -- HISTORY
1359: -- 28-Apr-2000 choang Created.
1360: ---------------------------------------------------------------------
1361: FUNCTION get_lookup_meaning (

Line 1389: -- FROM ams_campaigns_vl

1385: -- get_resource_name
1386: -- USAGE
1387: -- Example:
1388: -- SELECT OZF_Utility_PVT.get_resource_name (owner_user_id)
1389: -- FROM ams_campaigns_vl
1390: -- HISTORY
1391: -- 28-Apr-2000 choang Created.
1392: ---------------------------------------------------------------------
1393: FUNCTION get_resource_name (

Line 1442: FROM ams_campaigns_vl A, jtf_loc_hierarchies_vl B

1438: WHERE location_hierarchy_id = p_country_id;
1439:
1440: CURSOR c_camp_area2 IS
1441: SELECT B.area2_code
1442: FROM ams_campaigns_vl A, jtf_loc_hierarchies_vl B
1443: WHERE A.campaign_id = p_object_id
1444: AND A.city_id = B.location_hierarchy_id;
1445:
1446: BEGIN