APPS.AMS_WEBMARKETING_PVT dependencies on AMS_WEB_PLCE_MP_B

Line 692: SELECT AMS_WEB_PLCE_MP_B_S.NEXTVAL

688: l_publish_flag Varchar2(1);
689: l_placement_citem_id_tbl JTF_NUMBER_TABLE;
690:
691: CURSOR c_mp_id IS
692: SELECT AMS_WEB_PLCE_MP_B_S.NEXTVAL
693: FROM dual;
694:
695: CURSOR c_citem_assoc_id IS
696: SELECT AMS_WEB_PLCE_CITEM_ASSOC_S.NEXTVAL

Line 701: FROM AMS_WEB_PLCE_MP_B

697: FROM dual;
698:
699: CURSOR c_mp_id_exists (l_id IN NUMBER) IS
700: SELECT 1
701: FROM AMS_WEB_PLCE_MP_B
702: WHERE PLACEMENT_MP_ID = l_id;
703:
704: CURSOR c_citem_assoc_id_exists (l_id IN NUMBER) IS
705: SELECT 1

Line 996: FROM ams_web_plce_mp_b

992: l_placement_mp_id NUMBER;
993:
994: CURSOR c_ctype_code (l_placement_mp_id IN NUMBER) IS
995: SELECT content_type_code
996: FROM ams_web_plce_mp_b
997: WHERE placement_mp_id = l_placement_mp_id;
998:
999: CURSOR c_mp_id_exists (l_placement_mp_id IN NUMBER) IS
1000: SELECT 1

Line 1001: FROM AMS_WEB_PLCE_MP_B

997: WHERE placement_mp_id = l_placement_mp_id;
998:
999: CURSOR c_mp_id_exists (l_placement_mp_id IN NUMBER) IS
1000: SELECT 1
1001: FROM AMS_WEB_PLCE_MP_B
1002: WHERE PLACEMENT_MP_ID = l_placement_mp_id;
1003:
1004: -- Need to verify the Content Type Code Presence in IBC Schema Also
1005:

Line 1125: FROM AMS_CAMPAIGN_SCHEDULES_B SCHED, AMS_WEB_PLCE_MP_B MP

1121: l_media_id NUMBER;
1122:
1123: CURSOR c_campaign_activity_id_exists (l_campaign_activity_id IN NUMBER) IS
1124: SELECT sched.schedule_id
1125: FROM AMS_CAMPAIGN_SCHEDULES_B SCHED, AMS_WEB_PLCE_MP_B MP
1126: WHERE SCHED.SCHEDULE_ID = MP.OBJECT_USED_BY_ID AND SCHED.SCHEDULE_ID = L_CAMPAIGN_ACTIVITY_ID;
1127:
1128: CURSOR c_media_id_exists(l_schedule_id IN NUMBER) IS
1129: SELECT activity_id FROM ams_campaign_schedules_b where SCHEDULE_ID=l_schedule_id;