APPS.AMS_ACTMETRIC_PVT dependencies on AMS_CAMPAIGNS_ALL_B

Line 310: FROM ams_campaigns_all_b

306: --campaign and program
307: CURSOR c_check_camp_prog_status (p_camp_id IN NUMBER)
308: IS
309: SELECT NVL (transaction_currency_code, functional_currency_code) AS currency_code, status_code
310: FROM ams_campaigns_all_b
311: WHERE campaign_id = p_camp_id;
312: --AND UPPER(status_code) IN ('COMPLETED', 'ACTIVE', 'CANCELLED', 'SUBMITTED_BA');
313:
314: --campaign schedule

Line 434: FROM ams_campaigns_all_b

430: --campaign and program
431: CURSOR c_check_camp_prog_status (p_camp_id IN NUMBER)
432: IS
433: SELECT 1
434: FROM ams_campaigns_all_b
435: WHERE campaign_id = p_camp_id
436: AND UPPER(status_code) IN ('ACTIVE', 'AVAILABLE', 'CANCELLED', 'PLANNING');
437:
438: --campaign schedule

Line 823: FROM ams_campaigns_all_b

819: IS
820: -- select transaction_currency_code for campaign
821: CURSOR c_get_camp_trans_curr(l_obj_id NUMBER) IS
822: SELECT transaction_currency_code
823: FROM ams_campaigns_all_b
824: WHERE campaign_id = l_obj_id;
825:
826: -- select transaction_currency_code for campaign schedule
827: CURSOR c_get_csch_trans_curr(l_obj_id NUMBER) IS

Line 1363: FROM ams_campaigns_all_b

1359: -- Cursors for checking of statuses when the object is active.
1360: -- Relevant in Update.
1361: CURSOR c_camp_active(id NUMBER) IS
1362: SELECT Fnd_Api.G_TRUE
1363: FROM ams_campaigns_all_b
1364: WHERE campaign_id = id
1365: AND status_code IN ('SUBMITTED_BA', 'ACTIVE');
1366:
1367: CURSOR c_csch_active(id NUMBER) IS

Line 1396: FROM ams_campaigns_all_b

1392: -- Added cursors for checking of statuses when the object is active,
1393: -- completed or cancelled. Relevant in delete.
1394: CURSOR c_camp_delete(id NUMBER) IS
1395: SELECT Fnd_Api.G_TRUE
1396: FROM ams_campaigns_all_b
1397: WHERE campaign_id = id
1398: AND status_code IN ('SUBMITTED_BA', 'ACTIVE', 'COMPLETED', 'CANCELLED');
1399:
1400: CURSOR c_csch_delete(id NUMBER) IS

Line 5067: FROM ams_campaigns_all_b

5063: -- select budget amounts for campaign
5064: CURSOR c_get_camp_budget_amounts(l_obj_id NUMBER) IS
5065: SELECT budget_amount_tc, transaction_currency_code,
5066: budget_amount_fc, functional_currency_code
5067: FROM ams_campaigns_all_b
5068: WHERE campaign_id = l_obj_id;
5069:
5070: -- select budget amounts for campaign
5071: CURSOR c_get_csch_budget_amounts(l_obj_id NUMBER) IS

Line 7292: FROM ams_campaigns_all_b

7288: l_object_name AMS_LOOKUPS.MEANING%TYPE;
7289: --cursors to check for existance of various objects.
7290: CURSOR c_check_camp(id NUMBER) IS
7291: SELECT Fnd_Api.G_TRUE
7292: FROM ams_campaigns_all_b
7293: WHERE campaign_id = id;
7294:
7295: CURSOR c_check_csch(id NUMBER) IS
7296: SELECT Fnd_Api.G_TRUE

Line 7514: l_table_name := 'AMS_CAMPAIGNS_ALL_B';

7510: IF (p_arc_act_metric_used_by ='CSCH') THEN
7511: l_table_name := 'AMS_CAMPAIGN_SCHEDULES_B';
7512: l_pk_name := 'SCHEDULE_ID';
7513: ELSIF (p_arc_act_metric_used_by ='CAMP') THEN
7514: l_table_name := 'AMS_CAMPAIGNS_ALL_B';
7515: l_pk_name := 'CAMPAIGN_ID';
7516: ELSIF (p_arc_act_metric_used_by ='EVEO') THEN
7517: l_table_name := 'AMS_EVENT_OFFERS_ALL_B';
7518: l_pk_name := 'EVENT_OFFER_ID';

Line 7529: l_table_name := 'AMS_CAMPAIGNS_ALL_B';

7525: ELSIF (p_arc_act_metric_used_by ='DELV') THEN
7526: l_table_name := 'AMS_DELIVERABLES_ALL_B';
7527: l_pk_name := 'DELIVERABLE_ID';
7528: ELSIF (p_arc_act_metric_used_by = 'RCAM') THEN
7529: l_table_name := 'AMS_CAMPAIGNS_ALL_B';
7530: l_pk_name := 'CAMPAIGN_ID';
7531: ELSIF (p_arc_act_metric_used_by = 'ALIST') THEN
7532: l_table_name := 'AMS_ACT_LISTS';
7533: l_pk_name := 'ACT_LIST_HEADER_ID';

Line 7671: SELECT 1 FROM AMS_CAMPAIGNS_ALL_B

7667: RETURN VARCHAR2
7668: IS
7669:
7670: CURSOR c_campaign_metric(p_campaign_id number) IS
7671: SELECT 1 FROM AMS_CAMPAIGNS_ALL_B
7672: WHERE CAMPAIGN_ID = p_campaign_id;
7673:
7674:
7675: CURSOR c_campaign_schedule_metric(p_campaign_schedule_id number) IS