APPS.AMS_ACTMETRIC_PVT dependencies on AMS_CAMPAIGN_SCHEDULES_B

Line 318: FROM ams_campaign_schedules_b

314: --campaign schedule
315: CURSOR c_check_campsch_status (p_schedule_id IN NUMBER)
316: IS
317: SELECT NVL (transaction_currency_code, functional_currency_code) AS currency_code, status_code
318: FROM ams_campaign_schedules_b
319: WHERE schedule_id = p_schedule_id;
320: --AND UPPER(status_code) IN ('ACTIVE', 'CANCELLED', 'COMPLETED');
321:
322: --deliverable

Line 442: FROM ams_campaign_schedules_b

438: --campaign schedule
439: CURSOR c_check_campsch_status (p_schedule_id IN NUMBER)
440: IS
441: SELECT 1
442: FROM ams_campaign_schedules_b
443: WHERE schedule_id = p_schedule_id
444: AND UPPER(status_code) IN ('ACTIVE', 'AVAILABLE', 'CANCELLED', 'PLANNING');
445:
446: --deliverable

Line 829: FROM ams_campaign_schedules_b

825:
826: -- select transaction_currency_code for campaign schedule
827: CURSOR c_get_csch_trans_curr(l_obj_id NUMBER) IS
828: SELECT transaction_currency_code
829: FROM ams_campaign_schedules_b
830: WHERE schedule_id = l_obj_id;
831:
832: -- select transaction_currency_code for event offer
833: CURSOR c_get_eveo_trans_curr(l_obj_id NUMBER) IS

Line 1369: FROM ams_campaign_schedules_b

1365: AND status_code IN ('SUBMITTED_BA', 'ACTIVE');
1366:
1367: CURSOR c_csch_active(id NUMBER) IS
1368: SELECT Fnd_Api.G_TRUE
1369: FROM ams_campaign_schedules_b
1370: WHERE schedule_id = id
1371: AND status_code = 'ACTIVE';
1372:
1373: CURSOR c_delv_active(id NUMBER) IS

Line 1402: FROM ams_campaign_schedules_b

1398: AND status_code IN ('SUBMITTED_BA', 'ACTIVE', 'COMPLETED', 'CANCELLED');
1399:
1400: CURSOR c_csch_delete(id NUMBER) IS
1401: SELECT Fnd_Api.G_TRUE
1402: FROM ams_campaign_schedules_b
1403: WHERE schedule_id = id
1404: AND status_code IN ('SUBMITTED_BA', 'ACTIVE', 'COMPLETED', 'CANCELLED');
1405:
1406: CURSOR c_delv_delete(id NUMBER) IS

Line 5074: FROM ams_campaign_schedules_b

5070: -- select budget amounts for campaign
5071: CURSOR c_get_csch_budget_amounts(l_obj_id NUMBER) IS
5072: SELECT budget_amount_tc, transaction_currency_code,
5073: budget_amount_fc, functional_currency_code
5074: FROM ams_campaign_schedules_b
5075: WHERE schedule_id = l_obj_id;
5076:
5077: -- select budget amounts for event offer
5078: CURSOR c_get_eveof_budget_amounts(l_obj_id NUMBER) IS

Line 7297: FROM ams_campaign_schedules_b

7293: WHERE campaign_id = id;
7294:
7295: CURSOR c_check_csch(id NUMBER) IS
7296: SELECT Fnd_Api.G_TRUE
7297: FROM ams_campaign_schedules_b
7298: WHERE schedule_id = id;
7299:
7300: CURSOR c_check_delv(id NUMBER) IS
7301: SELECT Fnd_Api.G_TRUE

Line 7511: l_table_name := 'AMS_CAMPAIGN_SCHEDULES_B';

7507: -- Initialize API return status to success.
7508: --
7509: x_return_status := Fnd_Api.G_RET_STS_SUCCESS;
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';

Line 7676: SELECT 1 FROM AMS_CAMPAIGN_SCHEDULES_B

7672: WHERE CAMPAIGN_ID = p_campaign_id;
7673:
7674:
7675: CURSOR c_campaign_schedule_metric(p_campaign_schedule_id number) IS
7676: SELECT 1 FROM AMS_CAMPAIGN_SCHEDULES_B
7677: WHERE schedule_ID = p_campaign_schedule_id;
7678:
7679: CURSOR c_deliverable_metric(p_deliverable_id number) IS
7680: SELECT 1 FROM AMS_DELIVERABLES_ALL_B