APPS.AMS_WEBMARKETING_PVT dependencies on AMS_WEB_PLCE_CITEM_ASSOC

Line 148: SELECT AMS_WEB_PLCE_CITEM_ASSOC_S.NEXTVAL

144: l_simple VARCHAR2(1) := 'Y';
145:
146:
147: CURSOR c_citem_assoc_id IS
148: SELECT AMS_WEB_PLCE_CITEM_ASSOC_S.NEXTVAL
149: FROM dual;
150:
151: CURSOR c_citem_assoc_id_exists (l_id IN NUMBER) IS
152: SELECT 1

Line 153: FROM AMS_WEB_PLCE_CITEM_ASSOC

149: FROM dual;
150:
151: CURSOR c_citem_assoc_id_exists (l_id IN NUMBER) IS
152: SELECT 1
153: FROM AMS_WEB_PLCE_CITEM_ASSOC
154: WHERE PLACEMENT_CITEM_ID = l_id;
155:
156:
157: CURSOR c_plce_citems(l_citem_version_id IN NUMBER) IS

Line 220: -- Call Table Handlers (AMS_WEB_PLCE_CITEM_ASSOC )

216: x_placement_citem_id_tbl := JTF_NUMBER_TABLE();
217: FOR citem_rec IN c_plce_citems ( l_citem_ver_id)
218: LOOP
219: -- Populate the Tables Now
220: -- Call Table Handlers (AMS_WEB_PLCE_CITEM_ASSOC )
221: -- Invoke table handler(AMS_WEB_PLCE_CITEM_ASSOC_PKG.INSERT_ROW)
222:
223: l_simple := 'N';
224: IF (p_web_mp_rec.placement_citem_id IS NULL OR p_web_mp_rec.placement_citem_id = FND_API.g_miss_num) THEN

Line 221: -- Invoke table handler(AMS_WEB_PLCE_CITEM_ASSOC_PKG.INSERT_ROW)

217: FOR citem_rec IN c_plce_citems ( l_citem_ver_id)
218: LOOP
219: -- Populate the Tables Now
220: -- Call Table Handlers (AMS_WEB_PLCE_CITEM_ASSOC )
221: -- Invoke table handler(AMS_WEB_PLCE_CITEM_ASSOC_PKG.INSERT_ROW)
222:
223: l_simple := 'N';
224: IF (p_web_mp_rec.placement_citem_id IS NULL OR p_web_mp_rec.placement_citem_id = FND_API.g_miss_num) THEN
225:

Line 696: SELECT AMS_WEB_PLCE_CITEM_ASSOC_S.NEXTVAL

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
697: FROM dual;
698:
699: CURSOR c_mp_id_exists (l_id IN NUMBER) IS
700: SELECT 1

Line 706: FROM AMS_WEB_PLCE_CITEM_ASSOC

702: WHERE PLACEMENT_MP_ID = l_id;
703:
704: CURSOR c_citem_assoc_id_exists (l_id IN NUMBER) IS
705: SELECT 1
706: FROM AMS_WEB_PLCE_CITEM_ASSOC
707: WHERE PLACEMENT_CITEM_ID = l_id;
708:
709: CURSOR c_media_id (l_id IN NUMBER) IS
710: SELECT 1