APPS.AMS_UTILITY_PVT dependencies on AMS_CAMPAIGNS_VL

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

667: x_table_name := 'AMS_CAMPAIGN_SCHEDULES_B';
668: x_pk_name := 'SCHEDULE_ID';
669: ELSIF (p_sys_qual ='CAMP') THEN
670: -- Start of code modified by ptendulk on 30-Jan-2001
671: --x_table_name := 'AMS_CAMPAIGNS_VL';
672: -- End of code modified by ptendulk on 30-Jan-2001
673: x_table_name := 'AMS_CAMPAIGNS_ALL_B';
674: x_pk_name := 'CAMPAIGN_ID';
675: ELSIF (p_sys_qual ='EVEO') THEN

Line 817: FROM ams_campaigns_vl

813: l_object_name VARCHAR2(1000);
814:
815: CURSOR c_campaign(p_object_id IN NUMBER) IS
816: SELECT campaign_name
817: FROM ams_campaigns_vl
818: WHERE campaign_id = p_object_id;
819:
820: --added 11/16/99 tdonohoe
821: CURSOR c_campaign_sched(p_object_id IN NUMBER) IS

Line 823: FROM ams_campaigns_vl c,

819:
820: --added 11/16/99 tdonohoe
821: CURSOR c_campaign_sched(p_object_id IN NUMBER) IS
822: SELECT c.campaign_name
823: FROM ams_campaigns_vl c,
824: ams_campaign_schedules s
825: WHERE s.campaign_schedule_id = p_object_id
826: AND s.campaign_id = c.campaign_id;
827:

Line 1297: -- FROM ams_campaigns_vl;

1293: -- get_lookup_meaning
1294: -- USAGE
1295: -- Example:
1296: -- SELECT AMS_Utility_PVT.get_lookup_meaning ('AMS_CAMPAIGN_STATUS', status_code)
1297: -- FROM ams_campaigns_vl;
1298: -- HISTORY
1299: -- 28-Apr-2000 choang Created.
1300: ---------------------------------------------------------------------
1301: FUNCTION get_lookup_meaning (

Line 1329: -- FROM ams_campaigns_vl

1325: -- get_resource_name
1326: -- USAGE
1327: -- Example:
1328: -- SELECT AMS_Utility_PVT.get_resource_name (owner_user_id)
1329: -- FROM ams_campaigns_vl
1330: -- HISTORY
1331: -- 28-Apr-2000 choang Created.
1332: ---------------------------------------------------------------------
1333: FUNCTION get_resource_name (

Line 1382: FROM ams_campaigns_vl A, jtf_loc_hierarchies_vl B

1378: WHERE location_hierarchy_id = p_country_id;
1379:
1380: CURSOR c_camp_area2 IS
1381: SELECT B.area2_code
1382: FROM ams_campaigns_vl A, jtf_loc_hierarchies_vl B
1383: WHERE A.campaign_id = p_object_id
1384: AND A.city_id = B.location_hierarchy_id;
1385:
1386: BEGIN

Line 2651: FROM ams_campaigns_vl

2647:
2648: CURSOR Cur_Camp(p_camp_id IN NUMBER)
2649: IS
2650: SELECT campaign_name
2651: FROM ams_campaigns_vl
2652: WHERE campaign_id = p_camp_id;
2653:
2654: CURSOR Cur_Csch(p_csch_id IN NUMBER)
2655: IS