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 5073: FROM ams_event_offers_all_b

5069: -- select budget amounts for event offer
5070: CURSOR c_get_eveof_budget_amounts(l_obj_id NUMBER) IS
5071: SELECT fund_amount_tc, currency_code_tc,
5072: fund_amount_fc, currency_code_fc
5073: FROM ams_event_offers_all_b
5074: WHERE event_offer_id = l_obj_id;
5075:
5076: -- select budget amounts for event header
5077: CURSOR c_get_evehd_budget_amounts(l_obj_id NUMBER) IS

Line 7304: FROM ams_event_offers_all_b

7300: WHERE event_header_id = id;
7301:
7302: CURSOR c_check_eveo(id NUMBER) IS
7303: SELECT Fnd_Api.G_TRUE
7304: FROM ams_event_offers_all_b
7305: WHERE event_offer_id = id;
7306:
7307: BEGIN
7308:

Line 7509: l_table_name := 'AMS_EVENT_OFFERS_ALL_B';

7505: ELSIF (p_arc_act_metric_used_by ='CAMP') THEN
7506: l_table_name := 'AMS_CAMPAIGNS_ALL_B';
7507: l_pk_name := 'CAMPAIGN_ID';
7508: ELSIF (p_arc_act_metric_used_by ='EVEO') THEN
7509: l_table_name := 'AMS_EVENT_OFFERS_ALL_B';
7510: l_pk_name := 'EVENT_OFFER_ID';
7511: ELSIF (p_arc_act_metric_used_by ='EONE') THEN
7512: l_table_name := 'AMS_EVENT_OFFERS_ALL_B';
7513: l_pk_name := 'EVENT_OFFER_ID';

Line 7512: l_table_name := 'AMS_EVENT_OFFERS_ALL_B';

7508: ELSIF (p_arc_act_metric_used_by ='EVEO') THEN
7509: l_table_name := 'AMS_EVENT_OFFERS_ALL_B';
7510: l_pk_name := 'EVENT_OFFER_ID';
7511: ELSIF (p_arc_act_metric_used_by ='EONE') THEN
7512: l_table_name := 'AMS_EVENT_OFFERS_ALL_B';
7513: l_pk_name := 'EVENT_OFFER_ID';
7514: ELSIF (p_arc_act_metric_used_by ='EVEH') THEN
7515: l_table_name := 'AMS_EVENT_HEADERS_ALL_B';
7516: l_pk_name := 'EVENT_HEADER_ID';

Line 7676: SELECT 1 FROM AMS_EVENT_OFFERS_ALL_B

7672: SELECT 1 FROM AMS_DELIVERABLES_ALL_B
7673: WHERE deliverable_ID = p_deliverable_id;
7674:
7675: CURSOR c_event_schedule_metric(p_event_schedule_id number) IS
7676: SELECT 1 FROM AMS_EVENT_OFFERS_ALL_B
7677: WHERE EVENT_OFFER_ID = p_event_schedule_id
7678: and event_object_type = 'EVEO';
7679:
7680: CURSOR c_one_off_metric(p_one_off_id number) IS

Line 7681: SELECT 1 FROM AMS_EVENT_OFFERS_ALL_B

7677: WHERE EVENT_OFFER_ID = p_event_schedule_id
7678: and event_object_type = 'EVEO';
7679:
7680: CURSOR c_one_off_metric(p_one_off_id number) IS
7681: SELECT 1 FROM AMS_EVENT_OFFERS_ALL_B
7682: WHERE EVENT_OFFER_ID = p_one_off_id
7683: and event_object_type = 'EONE';
7684:
7685: