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 5066: FROM ams_campaign_schedules_b

5062: -- select budget amounts for campaign
5063: CURSOR c_get_csch_budget_amounts(l_obj_id NUMBER) IS
5064: SELECT budget_amount_tc, transaction_currency_code,
5065: budget_amount_fc, functional_currency_code
5066: FROM ams_campaign_schedules_b
5067: WHERE schedule_id = l_obj_id;
5068:
5069: -- select budget amounts for event offer
5070: CURSOR c_get_eveof_budget_amounts(l_obj_id NUMBER) IS

Line 7289: FROM ams_campaign_schedules_b

7285: WHERE campaign_id = id;
7286:
7287: CURSOR c_check_csch(id NUMBER) IS
7288: SELECT Fnd_Api.G_TRUE
7289: FROM ams_campaign_schedules_b
7290: WHERE schedule_id = id;
7291:
7292: CURSOR c_check_delv(id NUMBER) IS
7293: SELECT Fnd_Api.G_TRUE

Line 7503: l_table_name := 'AMS_CAMPAIGN_SCHEDULES_B';

7499: -- Initialize API return status to success.
7500: --
7501: x_return_status := Fnd_Api.G_RET_STS_SUCCESS;
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';

Line 7668: SELECT 1 FROM AMS_CAMPAIGN_SCHEDULES_B

7664: WHERE CAMPAIGN_ID = p_campaign_id;
7665:
7666:
7667: CURSOR c_campaign_schedule_metric(p_campaign_schedule_id number) IS
7668: SELECT 1 FROM AMS_CAMPAIGN_SCHEDULES_B
7669: WHERE schedule_ID = p_campaign_schedule_id;
7670:
7671: CURSOR c_deliverable_metric(p_deliverable_id number) IS
7672: SELECT 1 FROM AMS_DELIVERABLES_ALL_B