APPS.AMS_ACTMETRICS_ENGINE_PVT dependencies on AMS_CAMPAIGN_SCHEDULES_B

Line 2625: FROM ams_campaign_schedules_b

2621: -- 06/23/2001 huili added
2622: --check the parent campaign for schedule
2623: CURSOR c_check_parent_schedule (l_act_metric_used_by_id NUMBER) IS
2624: SELECT campaign_id
2625: FROM ams_campaign_schedules_b
2626: WHERE schedule_id = l_act_metric_used_by_id;
2627:
2628: CURSOR c_check_parent_one_event(l_act_metric_used_by_id NUMBER) IS
2629: SELECT parent_id

Line 3650: FROM ams_campaign_schedules_b

3646: AND status_code = G_CANCELLED;
3647:
3648: CURSOR c_csch(id NUMBER) IS
3649: SELECT Fnd_Api.G_TRUE
3650: FROM ams_campaign_schedules_b
3651: WHERE schedule_id = id
3652: AND status_code = G_CANCELLED;
3653:
3654: CURSOR c_delv(id NUMBER) IS

Line 4220: FROM ams_campaign_schedules_b

4216: return object_detail_type IS
4217: SELECT G_CSCH, campaign_id, transaction_currency_code, G_CAMP, campaign_id,
4218: decode(status_code, G_CANCELLED, Fnd_Api.G_TRUE, Fnd_Api.G_FALSE) cancelled_flag,
4219: G_SHOW
4220: FROM ams_campaign_schedules_b
4221: WHERE schedule_id = l_act_metric_used_by_id;
4222:
4223: --check the event header
4224: -- BUG 3456849: Changed parent to be a program_id.

Line 4420: FROM ams_campaign_schedules_b

4416: CONNECT BY campaign_id = PRIOR PARENT_CAMPAIGN_ID
4417: UNION ALL
4418: SELECT SCHEDULE_ID obj_id, G_CSCH obj_type,
4419: TRANSACTION_CURRENCY_CODE currency
4420: FROM ams_campaign_schedules_b
4421: WHERE CAMPAIGN_ID = l_act_metric_used_by_id
4422: ORDER BY obj_type, obj_id;
4423:
4424: CURSOR c_get_event_family (l_act_metric_used_by_id number) IS

Line 4443: FROM ams_campaign_schedules_b

4439: ORDER BY obj_type, obj_id;
4440:
4441: CURSOR c_get_csch_family (l_act_metric_used_by_id number) IS
4442: SELECT schedule_id obj_id, G_CSCH obj_type,TRANSACTION_CURRENCY_CODE currency
4443: FROM ams_campaign_schedules_b
4444: WHERE schedule_id = l_act_metric_used_by_id
4445: UNION ALL
4446: SELECT campaign_id obj_id,
4447: decode(rollup_type,G_RCAM,G_RCAM,G_CAMP) obj_type,

Line 4450: START WITH campaign_id = (SELECT campaign_id FROM ams_campaign_schedules_b

4446: SELECT campaign_id obj_id,
4447: decode(rollup_type,G_RCAM,G_RCAM,G_CAMP) obj_type,
4448: TRANSACTION_CURRENCY_CODE currency
4449: FROM ams_campaigns_all_b
4450: START WITH campaign_id = (SELECT campaign_id FROM ams_campaign_schedules_b
4451: WHERE schedule_id = l_act_metric_used_by_id)
4452: CONNECT BY campaign_id = PRIOR PARENT_CAMPAIGN_ID
4453: ORDER BY obj_type, obj_id;
4454:

Line 4661: SELECT schedule_id INTO l_csch_id FROM ams_campaign_schedules_b

4657: write_object_list(l_object_list,l_output);
4658: p_output := p_output || l_output;
4659: l_object_list.delete;
4660:
4661: SELECT schedule_id INTO l_csch_id FROM ams_campaign_schedules_b
4662: WHERE campaign_id IS NOT NULL
4663: AND ROWNUM = 1;
4664: Get_Object_List(G_CSCH,l_csch_id,
4665: l_return_status, l_msg_count, l_msg_data, l_object_list);