APPS.AMS_ACTMETRICS_ENGINE_PVT dependencies on AMS_EVENT_HEADERS_ALL_B

Line 2605: FROM ams_event_headers_all_b

2601: --check for the parent event
2602: -- BUG 3456849: Changed parent to be a program_id.
2603: CURSOR c_check_parent_event_h(l_act_metric_used_by_id NUMBER) IS
2604: SELECT program_id
2605: FROM ams_event_headers_all_b
2606: WHERE event_header_id = l_act_metric_used_by_id;
2607:
2608: -- 06/23/2001 huili changed the "c_check_event_camp"
2609: -- 06/07/2001 huili added two cursors

Line 2613: FROM ams_event_headers_all_b

2609: -- 06/07/2001 huili added two cursors
2610: --check another type of parent event: execution campaign
2611: CURSOR c_check_event_camp (l_act_metric_used_by_id NUMBER) IS
2612: SELECT program_id
2613: FROM ams_event_headers_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

Line 3662: FROM ams_event_headers_all_b

3658: AND status_code = G_CANCELLED;
3659:
3660: CURSOR c_eveh(id NUMBER) IS
3661: SELECT Fnd_Api.G_TRUE
3662: FROM ams_event_headers_all_b
3663: WHERE event_header_id = id
3664: AND system_status_code = G_CANCELLED;
3665:
3666: CURSOR c_eveo(id NUMBER) IS

Line 4230: FROM ams_event_headers_all_b

4226: return object_detail_type IS
4227: SELECT G_EVEH, event_header_id, currency_code_tc, G_RCAM, program_id,
4228: decode(system_status_code, G_CANCELLED, Fnd_Api.G_TRUE, Fnd_Api.G_FALSE) cancelled_flag,
4229: G_SHOW
4230: FROM ams_event_headers_all_b
4231: WHERE event_header_id = l_act_metric_used_by_id;
4232:
4233: --check for the parent event
4234: CURSOR c_check_event_o(l_act_metric_used_by_id NUMBER)

Line 4402: FROM ams_event_headers_all_b

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
4403: WHERE PROGRAM_ID = l_act_metric_used_by_id
4404: UNION ALL
4405: SELECT EVENT_OFFER_ID obj_id, G_EONE obj_type, CURRENCY_CODE_TC currency
4406: FROM ams_event_offers_all_b

Line 4428: START WITH campaign_id = (SELECT PROGRAM_ID FROM ams_event_headers_all_b

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
4432: SELECT EVENT_HEADER_ID obj_id, G_EVEH obj_type, CURRENCY_CODE_TC currency

Line 4433: 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
4432: SELECT EVENT_HEADER_ID obj_id, G_EVEH obj_type, CURRENCY_CODE_TC currency
4433: FROM ams_event_headers_all_b
4434: WHERE EVENT_HEADER_ID = l_act_metric_used_by_id
4435: UNION ALL
4436: SELECT EVENT_OFFER_ID obj_id, G_EVEO obj_type, CURRENCY_CODE_TC currency
4437: FROM ams_event_offers_all_b

Line 4461: FROM ams_event_headers_all_b

4457: FROM ams_event_offers_all_b
4458: WHERE EVENT_OFFER_ID = l_act_metric_used_by_id
4459: UNION ALL
4460: SELECT EVENT_HEADER_ID obj_id, G_EVEH obj_type, CURRENCY_CODE_TC currency
4461: FROM ams_event_headers_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

Line 4467: START WITH campaign_id = (SELECT PROGRAM_ID FROM ams_event_headers_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
4471: ORDER BY obj_type, obj_id;

Line 4672: SELECT event_header_id INTO l_eveh_id FROM ams_event_headers_all_b

4668: write_object_list(l_object_list,l_output);
4669: p_output := p_output || l_output;
4670: l_object_list.delete;
4671:
4672: SELECT event_header_id INTO l_eveh_id FROM ams_event_headers_all_b
4673: WHERE PROGRAM_ID IS NOT NULL
4674: AND ROWNUM = 1;
4675: Get_Object_List(G_EVEH,l_eveh_id,
4676: l_return_status, l_msg_count, l_msg_data, l_object_list);