APPS.AMS_ACTMETRIC_PVT dependencies on AMS_EVENT_OFFERS_ALL_B

Line 344: FROM ams_event_offers_all_b

340: --event schedule and one-off event
341: CURSOR c_check_eventsch_status (p_ev_id IN NUMBER)
342: IS
343: SELECT currency_code_tc AS currency_code, system_status_code
344: FROM ams_event_offers_all_b
345: WHERE event_offer_id = p_ev_id;
346: --AND UPPER(system_status_code) IN ('ACTIVE', 'SUBMITTED_BA', 'CLOSED', 'CANCELLED');
347:
348: l_status_code VARCHAR2(2000);

Line 470: FROM ams_event_offers_all_b

466: --event schedule and one-off event
467: CURSOR c_check_eventsch_status (p_ev_id IN NUMBER)
468: IS
469: SELECT 1
470: FROM ams_event_offers_all_b
471: WHERE event_offer_id = p_ev_id
472: AND UPPER(system_status_code) IN
473: ('ACTIVE', 'AVAILABLE', 'CANCELLED', 'PLANNING');
474:

Line 835: FROM ams_event_offers_all_b

831:
832: -- select transaction_currency_code for event offer
833: CURSOR c_get_eveo_trans_curr(l_obj_id NUMBER) IS
834: SELECT currency_code_tc
835: FROM ams_event_offers_all_b
836: WHERE event_offer_id = l_obj_id;
837:
838: -- select transaction_currency_code for event header
839: CURSOR c_get_eveh_trans_curr(l_obj_id NUMBER) IS

Line 1387: FROM ams_event_offers_all_b

1383: AND system_status_code IN ('ACTIVE', 'SUBMITTED_BA');
1384:
1385: CURSOR c_eveo_active(id NUMBER) IS
1386: SELECT Fnd_Api.G_TRUE
1387: FROM ams_event_offers_all_b
1388: WHERE event_offer_id = id
1389: AND system_status_code IN ('SUBMITTED_BA', 'ACTIVE');
1390:
1391: --sunkumar 04/30/2003

Line 1420: FROM ams_event_offers_all_b

1416: AND system_status_code IN ('ACTIVE', 'CANCELLED', 'SUBMITTED_BA','COMPLETED');
1417:
1418: CURSOR c_eveo_delete(id NUMBER) IS
1419: SELECT Fnd_Api.G_TRUE
1420: FROM ams_event_offers_all_b
1421: WHERE event_offer_id = id
1422: AND system_status_code IN ('SUBMITTED_BA', 'ACTIVE', 'CANCELLED', 'COMPLETED');
1423:
1424: l_return_value VARCHAR2(1) := Fnd_Api.G_FALSE;

Line 5081: FROM ams_event_offers_all_b

5077: -- select budget amounts for event offer
5078: CURSOR c_get_eveof_budget_amounts(l_obj_id NUMBER) IS
5079: SELECT fund_amount_tc, currency_code_tc,
5080: fund_amount_fc, currency_code_fc
5081: FROM ams_event_offers_all_b
5082: WHERE event_offer_id = l_obj_id;
5083:
5084: -- select budget amounts for event header
5085: CURSOR c_get_evehd_budget_amounts(l_obj_id NUMBER) IS

Line 7312: FROM ams_event_offers_all_b

7308: WHERE event_header_id = id;
7309:
7310: CURSOR c_check_eveo(id NUMBER) IS
7311: SELECT Fnd_Api.G_TRUE
7312: FROM ams_event_offers_all_b
7313: WHERE event_offer_id = id;
7314:
7315: BEGIN
7316:

Line 7517: l_table_name := 'AMS_EVENT_OFFERS_ALL_B';

7513: ELSIF (p_arc_act_metric_used_by ='CAMP') THEN
7514: l_table_name := 'AMS_CAMPAIGNS_ALL_B';
7515: l_pk_name := 'CAMPAIGN_ID';
7516: ELSIF (p_arc_act_metric_used_by ='EVEO') THEN
7517: l_table_name := 'AMS_EVENT_OFFERS_ALL_B';
7518: l_pk_name := 'EVENT_OFFER_ID';
7519: ELSIF (p_arc_act_metric_used_by ='EONE') THEN
7520: l_table_name := 'AMS_EVENT_OFFERS_ALL_B';
7521: l_pk_name := 'EVENT_OFFER_ID';

Line 7520: l_table_name := 'AMS_EVENT_OFFERS_ALL_B';

7516: ELSIF (p_arc_act_metric_used_by ='EVEO') THEN
7517: l_table_name := 'AMS_EVENT_OFFERS_ALL_B';
7518: l_pk_name := 'EVENT_OFFER_ID';
7519: ELSIF (p_arc_act_metric_used_by ='EONE') THEN
7520: l_table_name := 'AMS_EVENT_OFFERS_ALL_B';
7521: l_pk_name := 'EVENT_OFFER_ID';
7522: ELSIF (p_arc_act_metric_used_by ='EVEH') THEN
7523: l_table_name := 'AMS_EVENT_HEADERS_ALL_B';
7524: l_pk_name := 'EVENT_HEADER_ID';

Line 7684: SELECT 1 FROM AMS_EVENT_OFFERS_ALL_B

7680: SELECT 1 FROM AMS_DELIVERABLES_ALL_B
7681: WHERE deliverable_ID = p_deliverable_id;
7682:
7683: CURSOR c_event_schedule_metric(p_event_schedule_id number) IS
7684: SELECT 1 FROM AMS_EVENT_OFFERS_ALL_B
7685: WHERE EVENT_OFFER_ID = p_event_schedule_id
7686: and event_object_type = 'EVEO';
7687:
7688: CURSOR c_one_off_metric(p_one_off_id number) IS

Line 7689: SELECT 1 FROM AMS_EVENT_OFFERS_ALL_B

7685: WHERE EVENT_OFFER_ID = p_event_schedule_id
7686: and event_object_type = 'EVEO';
7687:
7688: CURSOR c_one_off_metric(p_one_off_id number) IS
7689: SELECT 1 FROM AMS_EVENT_OFFERS_ALL_B
7690: WHERE EVENT_OFFER_ID = p_one_off_id
7691: and event_object_type = 'EONE';
7692:
7693: