1177: IF p_master_type = 'EVEH'
1178: THEN l_foreign_table := 'AMS_EVENT_HEADERS_ALL_B';
1179: l_foreign_table_id := 'EVENT_HEADER_ID';
1180: ELSIF p_master_type = 'EVEO'
1181: THEN l_foreign_table := 'AMS_EVENT_OFFERS_ALL_B';
1182: l_foreign_table_id := 'EVENT_OFFER_ID';
1183: ELSIF p_master_type = 'EONE'
1184: THEN l_foreign_table := 'AMS_EVENT_OFFERS_ALL_B';
1185: l_foreign_table_id := 'EVENT_OFFER_ID';
1180: ELSIF p_master_type = 'EVEO'
1181: THEN l_foreign_table := 'AMS_EVENT_OFFERS_ALL_B';
1182: l_foreign_table_id := 'EVENT_OFFER_ID';
1183: ELSIF p_master_type = 'EONE'
1184: THEN l_foreign_table := 'AMS_EVENT_OFFERS_ALL_B';
1185: l_foreign_table_id := 'EVENT_OFFER_ID';
1186: ELSIF p_master_type = 'CAMP'
1187: THEN l_foreign_table := 'AMS_CAMPAIGNS_ALL_B';
1188: l_foreign_table_id := 'CAMPAIGN_ID';
1213: IF p_using_type = 'EVEH'
1214: THEN l_foreign_table := 'AMS_EVENT_HEADERS_ALL_B';
1215: l_foreign_table_id := 'EVENT_HEADER_ID';
1216: ELSIF p_using_type = 'EVEO'
1217: THEN l_foreign_table := 'AMS_EVENT_OFFERS_ALL_B';
1218: l_foreign_table_id := 'EVENT_OFFER_ID';
1219:
1220: ELSIF p_using_type = 'EONE'
1221: THEN l_foreign_table := 'AMS_EVENT_OFFERS_ALL_B';
1217: THEN l_foreign_table := 'AMS_EVENT_OFFERS_ALL_B';
1218: l_foreign_table_id := 'EVENT_OFFER_ID';
1219:
1220: ELSIF p_using_type = 'EONE'
1221: THEN l_foreign_table := 'AMS_EVENT_OFFERS_ALL_B';
1222: l_foreign_table_id := 'EVENT_OFFER_ID';
1223:
1224: ELSIF p_using_type = 'CAMP'
1225: THEN l_foreign_table := 'AMS_CAMPAIGNS_ALL_B';
1628:
1629: CURSOR c_eveo_end_date(l_event_offer_id IN NUMBER)
1630: IS
1631: SELECT event_end_date
1632: FROM ams_event_offers_all_b
1633: WHERE event_offer_id = l_event_offer_id;
1634:
1635: CURSOR c_camp_end_date(l_camp_id IN NUMBER)
1636: IS