APPS.AMS_DM_MODELS_B_PKG dependencies on AMS_DM_MODELS_ALL_B

Line 90: INSERT INTO ams_dm_models_all_b(

86: IS
87: L_DEFAULT_SELECTION_TYPE CONSTANT VARCHAR2(30) := 'STANDARD';
88:
89: BEGIN
90: INSERT INTO ams_dm_models_all_b(
91: model_id,
92: last_update_date,
93: last_updated_by,
94: creation_date,

Line 287: Update ams_dm_models_all_b

283: p_attribute15 VARCHAR2
284: )
285: IS
286: BEGIN
287: Update ams_dm_models_all_b
288: SET
289: MODEL_ID = decode( p_MODEL_ID, FND_API.G_MISS_NUM, MODEL_ID, p_MODEL_ID),
290: LAST_UPDATE_DATE = decode( p_LAST_UPDATE_DATE, FND_API.G_MISS_DATE, LAST_UPDATE_DATE, p_LAST_UPDATE_DATE),
291: LAST_UPDATED_BY = decode( p_LAST_UPDATED_BY, FND_API.G_MISS_NUM, LAST_UPDATED_BY, p_LAST_UPDATED_BY),

Line 364: DELETE FROM ams_dm_models_all_b

360: PROCEDURE Delete_Row(
361: p_MODEL_ID NUMBER)
362: IS
363: BEGIN
364: DELETE FROM ams_dm_models_all_b
365: WHERE MODEL_ID = p_MODEL_ID;
366: If (SQL%NOTFOUND) then
367: RAISE NO_DATA_FOUND;
368: End If;

Line 420: FROM ams_dm_models_all_b

416:
417: IS
418: CURSOR C IS
419: SELECT *
420: FROM ams_dm_models_all_b
421: WHERE MODEL_ID = p_MODEL_ID
422: FOR UPDATE of MODEL_ID NOWAIT;
423: Recinfo C%ROWTYPE;
424: BEGIN

Line 495: from AMS_DM_MODELS_ALL_B B

491: BEGIN
492: delete from AMS_DM_MODELS_ALL_TL T
493: where not exists
494: (select NULL
495: from AMS_DM_MODELS_ALL_B B
496: where B.MODEL_ID = T.MODEL_ID
497: );
498:
499: update AMS_DM_MODELS_ALL_TL T set (

Line 635: from ams_dm_models_all_b

631: l_model_id number;
632:
633: cursor c_obj_verno is
634: select object_version_number
635: from ams_dm_models_all_b
636: where model_id = x_model_id;
637:
638: cursor c_chk_model_exists is
639: select 'x'

Line 640: from ams_dm_models_all_b

636: where model_id = x_model_id;
637:
638: cursor c_chk_model_exists is
639: select 'x'
640: from ams_dm_models_all_b
641: where model_id = x_model_id;
642:
643: cursor c_get_model_id is
644: select ams_dm_models_all_b_s.nextval

Line 644: select ams_dm_models_all_b_s.nextval

640: from ams_dm_models_all_b
641: where model_id = x_model_id;
642:
643: cursor c_get_model_id is
644: select ams_dm_models_all_b_s.nextval
645: from dual;
646: BEGIN
647: if X_OWNER = 'SEED' then
648: l_user_id := 1;