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 5059: FROM ams_campaigns_all_b

5055: -- select budget amounts for campaign
5056: CURSOR c_get_camp_budget_amounts(l_obj_id NUMBER) IS
5057: SELECT budget_amount_tc, transaction_currency_code,
5058: budget_amount_fc, functional_currency_code
5059: FROM ams_campaigns_all_b
5060: WHERE campaign_id = l_obj_id;
5061:
5062: -- select budget amounts for campaign
5063: CURSOR c_get_csch_budget_amounts(l_obj_id NUMBER) IS

Line 7284: FROM ams_campaigns_all_b

7280: l_object_name AMS_LOOKUPS.MEANING%TYPE;
7281: --cursors to check for existance of various objects.
7282: CURSOR c_check_camp(id NUMBER) IS
7283: SELECT Fnd_Api.G_TRUE
7284: FROM ams_campaigns_all_b
7285: WHERE campaign_id = id;
7286:
7287: CURSOR c_check_csch(id NUMBER) IS
7288: SELECT Fnd_Api.G_TRUE

Line 7506: l_table_name := 'AMS_CAMPAIGNS_ALL_B';

7502: IF (p_arc_act_metric_used_by ='CSCH') THEN
7503: l_table_name := 'AMS_CAMPAIGN_SCHEDULES_B';
7504: l_pk_name := 'SCHEDULE_ID';
7505: ELSIF (p_arc_act_metric_used_by ='CAMP') THEN
7506: l_table_name := 'AMS_CAMPAIGNS_ALL_B';
7507: l_pk_name := 'CAMPAIGN_ID';
7508: ELSIF (p_arc_act_metric_used_by ='EVEO') THEN
7509: l_table_name := 'AMS_EVENT_OFFERS_ALL_B';
7510: l_pk_name := 'EVENT_OFFER_ID';

Line 7521: l_table_name := 'AMS_CAMPAIGNS_ALL_B';

7517: ELSIF (p_arc_act_metric_used_by ='DELV') THEN
7518: l_table_name := 'AMS_DELIVERABLES_ALL_B';
7519: l_pk_name := 'DELIVERABLE_ID';
7520: ELSIF (p_arc_act_metric_used_by = 'RCAM') THEN
7521: l_table_name := 'AMS_CAMPAIGNS_ALL_B';
7522: l_pk_name := 'CAMPAIGN_ID';
7523: ELSIF (p_arc_act_metric_used_by = 'ALIST') THEN
7524: l_table_name := 'AMS_ACT_LISTS';
7525: l_pk_name := 'ACT_LIST_HEADER_ID';

Line 7663: SELECT 1 FROM AMS_CAMPAIGNS_ALL_B

7659: RETURN VARCHAR2
7660: IS
7661:
7662: CURSOR c_campaign_metric(p_campaign_id number) IS
7663: SELECT 1 FROM AMS_CAMPAIGNS_ALL_B
7664: WHERE CAMPAIGN_ID = p_campaign_id;
7665:
7666:
7667: CURSOR c_campaign_schedule_metric(p_campaign_schedule_id number) IS