APPS.AMS_CAMPAIGNRULES_PVT dependencies on AMS_CAMPAIGNS_VL

Line 107: FROM ams_campaigns_vl

103: l_rollup_type VARCHAR2(30);
104:
105: CURSOR c_parent IS
106: SELECT rollup_type
107: FROM ams_campaigns_vl
108: WHERE campaign_id = p_parent_id;
109:
110: BEGIN
111:

Line 584: FROM ams_campaigns_vl

580: SELECT 1
581: FROM DUAL
582: WHERE EXISTS(
583: SELECT campaign_id
584: FROM ams_campaigns_vl
585: WHERE parent_campaign_id = p_camp_rec.campaign_id);
586:
587: CURSOR c_camp IS
588: SELECT *

Line 589: FROM ams_campaigns_vl

585: WHERE parent_campaign_id = p_camp_rec.campaign_id);
586:
587: CURSOR c_camp IS
588: SELECT *
589: FROM ams_campaigns_vl
590: WHERE campaign_id = p_camp_rec.campaign_id;
591:
592: l_camp_rec c_camp%ROWTYPE;
593: l_dummy NUMBER;

Line 803: FROM ams_campaigns_vl

799: l_template_flag VARCHAR2(1);
800:
801: CURSOR c_parent IS
802: SELECT template_flag
803: FROM ams_campaigns_vl
804: WHERE campaign_id = p_parent_id;
805:
806: BEGIN
807:

Line 896: FROM ams_campaigns_vl

892: SELECT 1
893: FROM DUAL
894: WHERE EXISTS(
895: SELECT campaign_id
896: FROM ams_campaigns_vl
897: WHERE media_type_code = 'EVENTS'
898: AND arc_channel_from = p_arc_channel_from
899: AND channel_id = p_channel_id
900: AND (campaign_id <> p_campaign_id OR p_campaign_id IS NULL));

Line 1027: FROM ams_campaigns_vl

1023: l_dummy NUMBER;
1024:
1025: CURSOR c_camp IS
1026: SELECT 1
1027: FROM ams_campaigns_vl
1028: WHERE campaign_id = p_fund_source_id;
1029:
1030: CURSOR c_eveh IS
1031: SELECT 1

Line 1244: FROM ams_campaigns_vl

1240: l_duplicate NUMBER;
1241:
1242: CURSOR c_active_end_date IS
1243: SELECT actual_exec_end_date
1244: FROM ams_campaigns_vl
1245: WHERE campaign_name = p_campaign_name
1246: -- AND (city_id = p_city_id OR city_id IS NULL AND p_city_id IS NULL)
1247: AND status_code = 'ACTIVE'
1248: --AND (campaign_id <> p_campaign_id OR p_campaign_id IS NULL);

Line 1257: FROM ams_campaigns_vl

1253: SELECT 1
1254: FROM DUAL
1255: WHERE EXISTS(
1256: SELECT 1
1257: FROM ams_campaigns_vl
1258: WHERE campaign_name = p_campaign_name
1259: -- AND (city_id = p_city_id OR city_id IS NULL AND p_city_id IS NULL)
1260: AND show_campaign_flag = 'Y'
1261: --AND actual_exec_end_date < SYSDATE

Line 1272: FROM ams_campaigns_vl

1268: SELECT 1
1269: FROM DUAL
1270: WHERE EXISTS(
1271: SELECT 1
1272: FROM ams_campaigns_vl
1273: WHERE campaign_name = p_campaign_name
1274: AND (city_id = p_city_id OR city_id IS NULL AND p_city_id IS NULL)
1275: -- 25-Aug-2005 mayjain version is no longer supported from R12
1276: --AND version_no = p_version_no

Line 1383: FROM ams_campaigns_vl

1379:
1380: CURSOR c_parent_camp IS
1381: SELECT actual_exec_start_date,
1382: actual_exec_end_date
1383: FROM ams_campaigns_vl
1384: WHERE campaign_id = p_parent_id;
1385:
1386: l_parent_start_date DATE;
1387: l_parent_end_date DATE;

Line 1517: FROM ams_campaigns_vl

1513: CURSOR c_sub_camp IS
1514: SELECT campaign_name AS campaign_name,
1515: actual_exec_start_date AS start_date,
1516: actual_exec_end_date AS end_date
1517: FROM ams_campaigns_vl
1518: WHERE parent_campaign_id = p_camp_id;
1519:
1520: BEGIN
1521:

Line 1602: FROM ams_campaigns_vl

1598:
1599: CURSOR c_sub_camp IS
1600: SELECT campaign_name AS campaign_name,
1601: business_unit_id
1602: FROM ams_campaigns_vl
1603: WHERE parent_campaign_id = p_camp_id;
1604:
1605: BEGIN
1606:

Line 1923: FROM ams_campaigns_vl

1919: SELECT cascade_source_code_flag,
1920: source_code,
1921: custom_setup_id,
1922: global_flag
1923: FROM ams_campaigns_vl
1924: WHERE campaign_id = p_camp_id;
1925:
1926: l_cascade_flag VARCHAR2(1);
1927: l_source_code VARCHAR2(30);

Line 2004: -- FROM ams_campaigns_vl

2000: -- WHERE campaign_schedule_id = p_csch_rec.campaign_schedule_id;
2001:
2002: -- CURSOR c_camp IS
2003: -- SELECT cascade_source_code_flag
2004: -- FROM ams_campaigns_vl
2005: -- WHERE campaign_id = l_camp_id;
2006:
2007: -- CURSOR c_list_header IS
2008: -- SELECT 1

Line 2129: FROM ams_campaigns_vl

2125: IS
2126:
2127: CURSOR c_camp IS
2128: SELECT rollup_type, media_type_code
2129: FROM ams_campaigns_vl
2130: WHERE campaign_id = p_camp_id
2131: AND active_flag = 'Y';
2132:
2133: l_rollup_type VARCHAR2(30);

Line 2260: FROM ams_campaigns_vl

2256:
2257: CURSOR c_camp IS
2258: SELECT actual_exec_start_date,
2259: actual_exec_end_date
2260: FROM ams_campaigns_vl
2261: WHERE campaign_id = p_camp_id;
2262:
2263: l_camp_start_date DATE;
2264: l_camp_end_date DATE;

Line 2332: FROM ams_campaigns_vl A, ams_campaigns_vl B

2328: )
2329: IS
2330: CURSOR c_camp_det IS
2331: SELECT A.campaign_id,DECODE(a.rollup_type,'RCAM','RCAM','CAMP')
2332: FROM ams_campaigns_vl A, ams_campaigns_vl B
2333: WHERE B.campaign_id = p_campaign_id
2334: AND A.campaign_name = B.campaign_name
2335: -- AND (A.city_id = B.city_id OR A.city_id IS NULL AND B.city_id IS NULL)
2336: AND A.show_campaign_flag = 'Y'

Line 2376: FROM ams_campaigns_vl A, ams_campaigns_vl B

2372: UPDATE ams_campaigns_all_b
2373: SET show_campaign_flag = 'N'
2374: WHERE campaign_id IN(
2375: SELECT A.campaign_id
2376: FROM ams_campaigns_vl A, ams_campaigns_vl B
2377: WHERE B.campaign_id = p_campaign_id
2378: AND A.campaign_name = B.campaign_name
2379: AND (A.city_id = B.city_id OR A.city_id IS NULL AND B.city_id IS NULL)
2380: AND A.show_campaign_flag = 'Y'

Line 2870: FROM ams_campaigns_vl

2866:
2867: CURSOR c_parent IS
2868: SELECT parent_campaign_id,
2869: media_type_code
2870: FROM ams_campaigns_vl
2871: WHERE campaign_id = l_parent_id;
2872:
2873: BEGIN
2874:

Line 2909: FROM ams_campaigns_vl

2905: l_camp_id NUMBER;
2906:
2907: CURSOR c_parent IS
2908: SELECT parent_campaign_id
2909: FROM ams_campaigns_vl
2910: WHERE campaign_id = l_camp_id;
2911:
2912: BEGIN
2913:

Line 3031: FROM ams_campaigns_vl

3027: l_count NUMBER ;
3028:
3029: CURSOR c_child IS
3030: SELECT COUNT(campaign_id)
3031: FROM ams_campaigns_vl
3032: WHERE parent_campaign_id = p_campaign_id
3033: AND active_flag = 'Y'
3034: AND private_flag = 'N'
3035: AND show_campaign_flag = 'Y' ;