eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.AMS_ACTMETRICS_ENGINE_PVT dependencies on AMS_CAMPAIGNS_ALL_B

Line 2591: FROM ams_campaigns_all_b

2587: /**
2588: --check for the parent campaign
2589: CURSOR c_check_parent_campaign(l_act_metric_used_by_id NUMBER) IS
2590: SELECT parent_campaign_id
2591: FROM ams_campaigns_all_b
2592: WHERE campaign_id = l_act_metric_used_by_id
2593: AND UPPER(show_campaign_flag) = 'Y';
2594:
2595: --check for the parent event

Line 2618: FROM ams_campaigns_all_b

2614: WHERE event_header_id = l_act_metric_used_by_id;
2615:
2616: CURSOR c_check_camp_type (l_camp_id NUMBER) IS
2617: SELECT rollup_type
2618: FROM ams_campaigns_all_b
2619: WHERE campaign_id = l_camp_id;
2620:
2621: -- 06/23/2001 huili added
2622: --check the parent campaign for schedule

Line 3644: FROM ams_campaigns_all_b

3640: IS
3641: /**
3642: CURSOR c_camp(id NUMBER) IS
3643: SELECT Fnd_Api.G_TRUE
3644: FROM ams_campaigns_all_b
3645: WHERE campaign_id = id
3646: AND status_code = G_CANCELLED;
3647:
3648: CURSOR c_csch(id NUMBER) IS

Line 4211: FROM ams_campaigns_all_b

4207: return object_detail_type IS
4208: SELECT decode(rollup_type,G_RCAM,G_RCAM,G_CAMP), campaign_id, transaction_currency_code, G_RCAM, parent_campaign_id,
4209: decode(status_code, G_CANCELLED, Fnd_Api.G_TRUE, Fnd_Api.G_FALSE) cancelled_flag,
4210: upper(show_campaign_flag)
4211: FROM ams_campaigns_all_b
4212: WHERE campaign_id = l_act_metric_used_by_id;
4213: -- AND UPPER(show_campaign_flag) = 'Y';
4214:
4215: CURSOR c_check_schedule (l_act_metric_used_by_id NUMBER)

Line 4391: FROM ams_campaigns_all_b

4387: IS
4388: CURSOR c_get_program_family (l_act_metric_used_by_id number) IS
4389: SELECT campaign_id obj_id, G_RCAM obj_type,
4390: TRANSACTION_CURRENCY_CODE currency
4391: FROM ams_campaigns_all_b
4392: START WITH campaign_id = l_act_metric_used_by_id
4393: CONNECT BY campaign_id = PRIOR PARENT_CAMPAIGN_ID
4394: UNION ALL
4395: SELECT campaign_id obj_id,

Line 4398: FROM ams_campaigns_all_b

4394: UNION ALL
4395: SELECT campaign_id obj_id,
4396: decode(rollup_type,G_RCAM,G_RCAM,G_CAMP) obj_type,
4397: TRANSACTION_CURRENCY_CODE currency
4398: FROM ams_campaigns_all_b
4399: WHERE parent_campaign_id = l_act_metric_used_by_id
4400: UNION ALL
4401: SELECT EVENT_HEADER_ID obj_id, G_EVEH obj_type, CURRENCY_CODE_TC currency
4402: FROM ams_event_headers_all_b

Line 4414: FROM ams_campaigns_all_b

4410: CURSOR c_get_campaign_family (l_act_metric_used_by_id number) IS
4411: SELECT campaign_id obj_id,
4412: decode(rollup_type,G_RCAM,G_RCAM,G_CAMP) obj_type,
4413: TRANSACTION_CURRENCY_CODE currency
4414: FROM ams_campaigns_all_b
4415: START WITH campaign_id = l_act_metric_used_by_id
4416: CONNECT BY campaign_id = PRIOR PARENT_CAMPAIGN_ID
4417: UNION ALL
4418: SELECT SCHEDULE_ID obj_id, G_CSCH obj_type,

Line 4427: FROM ams_campaigns_all_b

4423:
4424: CURSOR c_get_event_family (l_act_metric_used_by_id number) IS
4425: SELECT campaign_id obj_id, G_RCAM obj_type,
4426: TRANSACTION_CURRENCY_CODE currency
4427: FROM ams_campaigns_all_b
4428: START WITH campaign_id = (SELECT PROGRAM_ID FROM ams_event_headers_all_b
4429: WHERE event_header_id = l_act_metric_used_by_id)
4430: CONNECT BY campaign_id = PRIOR PARENT_CAMPAIGN_ID
4431: UNION ALL

Line 4449: FROM ams_campaigns_all_b

4445: UNION ALL
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;

Line 4466: FROM ams_campaigns_all_b

4462: WHERE EVENT_HEADER_ID = (SELECT event_header_id FROM ams_event_offers_all_b
4463: WHERE event_offer_id = l_act_metric_used_by_id)
4464: UNION ALL
4465: SELECT campaign_id obj_id, G_RCAM obj_type, TRANSACTION_CURRENCY_CODE currency
4466: FROM ams_campaigns_all_b
4467: START WITH campaign_id = (SELECT PROGRAM_ID FROM ams_event_headers_all_b
4468: WHERE event_header_id = (SELECT event_header_id FROM ams_event_offers_all_b
4469: WHERE event_offer_id = l_act_metric_used_by_id))
4470: CONNECT BY campaign_id = PRIOR PARENT_CAMPAIGN_ID

Line 4476: FROM ams_campaigns_all_b

4472:
4473: CURSOR c_get_eone_family (l_act_metric_used_by_id number) IS
4474: SELECT campaign_id obj_id, G_RCAM obj_type,
4475: TRANSACTION_CURRENCY_CODE currency
4476: FROM ams_campaigns_all_b
4477: START WITH campaign_id = (SELECT PARENT_ID FROM ams_event_offers_all_b
4478: WHERE event_offer_id = l_act_metric_used_by_id)
4479: CONNECT BY campaign_id = PRIOR PARENT_CAMPAIGN_ID
4480: UNION ALL

Line 4638: SELECT campaign_id INTO l_RCAM_id FROM ams_campaigns_all_b

4634: l_eveo_id number;
4635: l_eone_id number;
4636: l_output varchar2(4000);
4637: BEGIN
4638: SELECT campaign_id INTO l_RCAM_id FROM ams_campaigns_all_b
4639: WHERE rollup_type = G_RCAM
4640: AND parent_campaign_id IS NOT NULL
4641: AND ROWNUM = 1;
4642: Get_Object_List(G_RCAM,l_RCAM_id,

Line 4650: SELECT campaign_id into l_camp_id FROM ams_campaigns_all_b

4646: write_object_list(l_object_list,l_output);
4647: p_output := p_output || l_output;
4648: l_object_list.delete;
4649:
4650: SELECT campaign_id into l_camp_id FROM ams_campaigns_all_b
4651: WHERE PARENT_CAMPAIGN_ID IS NOT NULL
4652: AND ROWNUM = 1;
4653: Get_Object_List(G_CAMP,l_camp_id,
4654: l_return_status, l_msg_count, l_msg_data, l_object_list);