eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.AMS_DM_MODEL_PVT dependencies on AMS_DM_MODELS_ALL_B

Line 16: -- 08-Feb-2001 choang Modified ams_dm_models_b to ams_dm_models_all_b in

12: -- 26-Jan-2001 choang Added increment of object ver num in update api.
13: -- 29-Jan-2001 choang Removed return statements from req item validation.
14: -- 29-Jan-2001 choang Removed return statements from all item validation.
15: -- 02-Feb-2001 choang Added new columns.
16: -- 08-Feb-2001 choang Modified ams_dm_models_b to ams_dm_models_all_b in
17: -- update api.
18: -- 08-Feb-2001 choang Changed callout to table handler to remove IN/OUT params.
19: -- 16-Feb-2001 choang Replaced top_down_flag with row_selection_type.
20: -- 21-Feb-2001 choang 1) Added callouts to access apis in create. 2) Added check_access

Line 388: FROM ams_dm_models_all_b

384: l_MODEL_ID NUMBER;
385:
386: CURSOR c_dm_model_b IS
387: SELECT MODEL_ID
388: FROM ams_dm_models_all_b
389: WHERE MODEL_ID = p_MODEL_ID
390: AND object_version_number = p_object_version
391: FOR UPDATE NOWAIT;
392:

Line 532: SELECT ams_dm_models_all_b_s.NEXTVAL

528:
529: l_access_rec AMS_Access_PVT.access_rec_type;
530:
531: CURSOR c_dm_model_seq IS
532: SELECT ams_dm_models_all_b_s.NEXTVAL
533: FROM DUAL;
534:
535: CURSOR c_dm_model_count(p_model_id IN NUMBER) IS
536: SELECT 1

Line 1580: -- Purpose : Validate forgein key for table ams_dm_models_all_b

1576: End Delete_dm_model;
1577:
1578: -----------------------------------------------------------------------
1579: -- Procedure name : check_dm_model_fk_items
1580: -- Purpose : Validate forgein key for table ams_dm_models_all_b
1581: -----------------------------------------------------------------------
1582: PROCEDURE check_dm_model_fk_items(
1583: p_dm_model_rec IN dm_model_rec_type,
1584: x_return_status OUT NOCOPY VARCHAR2)

Line 1635: -- Purpose : Validate Look up for table ams_dm_models_all_b

1631: END check_dm_model_fk_items;
1632:
1633: -----------------------------------------------------------------------
1634: -- Procedure name : check_dm_model_lookup_items
1635: -- Purpose : Validate Look up for table ams_dm_models_all_b
1636: -----------------------------------------------------------------------
1637: PROCEDURE check_dm_model_lookup_items(
1638: p_dm_model_rec IN dm_model_rec_type,
1639: x_return_status OUT NOCOPY VARCHAR2

Line 1708: -- Purpose : Validate Uniqueness for table ams_dm_models_all_b

1704: END check_dm_model_lookup_items;
1705:
1706: -----------------------------------------------------------------------
1707: -- Procedure name : check_dm_model_uk_items
1708: -- Purpose : Validate Uniqueness for table ams_dm_models_all_b
1709: -----------------------------------------------------------------------
1710: PROCEDURE check_dm_model_uk_items(
1711: p_DM_MODEL_rec IN DM_MODEL_Rec_Type,
1712: p_validation_mode IN VARCHAR2 := JTF_PLSQL_API.g_create,

Line 1739: 'ams_dm_models_all_b',

1735:
1736: --Validate unique model_id
1737: IF p_validation_mode = JTF_PLSQL_API.g_create THEN
1738: l_valid_flag := AMS_Utility_PVT.check_uniqueness(
1739: 'ams_dm_models_all_b',
1740: 'MODEL_ID = ''' || p_dm_model_rec.model_id ||'''');
1741: ELSE
1742: l_valid_flag := AMS_Utility_PVT.check_uniqueness(
1743: 'ams_dm_models_all_b',

Line 1743: 'ams_dm_models_all_b',

1739: 'ams_dm_models_all_b',
1740: 'MODEL_ID = ''' || p_dm_model_rec.model_id ||'''');
1741: ELSE
1742: l_valid_flag := AMS_Utility_PVT.check_uniqueness(
1743: 'ams_dm_models_all_b',
1744: 'MODEL_ID = ''' || p_dm_model_rec.model_id ||
1745: ''' AND MODEL_ID <> ' || p_dm_model_rec.model_id);
1746: END IF;
1747:

Line 1780: -- Purpose : Validate Required/NOT NULL column for table ams_dm_models_all_b

1776: END check_dm_model_uk_items;
1777:
1778: ------------------------------------------------------------------------------------
1779: -- Procedure name : check_dm_model_req_items
1780: -- Purpose : Validate Required/NOT NULL column for table ams_dm_models_all_b
1781: -- History
1782: -- 21-Feb-2001 choang Added check for g_miss_num on model_id and object_version_number.
1783: -- 13-Feb-2003 nyostos Added check for missing or NULL Model Name. Also added check for NULL
1784: -- values in Create.

Line 1962: -- Purpose : Validate items for table ams_dm_models_all_b

1958: END check_dm_model_req_items;
1959:
1960: ---------------------------------------------------------------------------------------
1961: -- Procedure name : Check_DM_MODEL_Items
1962: -- Purpose : Validate items for table ams_dm_models_all_b
1963: -- It contains uniqueness, forgein key, required, look up checking
1964: ---------------------------------------------------------------------------------------
1965: PROCEDURE Check_dm_model_items (
1966: P_DM_MODEL_Rec IN DM_MODEL_Rec_Type,

Line 2066: -- Purpose : Validate records for table ams_dm_models_all_b

2062: END Check_DM_MODEL_Items;
2063:
2064: ---------------------------------------------------------------------------------------
2065: -- Procedure name : Check_DM_MODEL_Items
2066: -- Purpose : Validate records for table ams_dm_models_all_b
2067: -- History
2068: -- 21-Feb-2001 choang Added p_validation_mode to params. Added
2069: -- callout to check_access.
2070: ---------------------------------------------------------------------------------------

Line 2087: FROM ams_dm_models_all_b

2083:
2084: -- add to select list as needed
2085: CURSOR c_reference (p_model_id IN NUMBER) IS
2086: SELECT owner_user_id
2087: FROM ams_dm_models_all_b
2088: WHERE model_id = p_model_id;
2089: l_reference_rec c_reference%ROWTYPE;
2090: BEGIN
2091: -- Initialize message list if p_init_msg_list is set to TRUE.

Line 2524: -- Purpose : Validate for table ams_dm_models_all_b

2520: END Complete_dm_model_rec;
2521:
2522: -------------------------------------------------------------------------------------
2523: -- Procedure name : Validate_dm_model
2524: -- Purpose : Validate for table ams_dm_models_all_b
2525: -- It contains items checking and records checking
2526: -- History
2527: -- 21-Feb-2001 choang Added p_validation_mode to validate_rec callout.
2528: -------------------------------------------------------------------------------------

Line 2702: FROM ams_dm_models_all_b

2698: l_new_status_id VARCHAR2(30);
2699:
2700: CURSOR c_expired_models IS
2701: SELECT model_id, status_code
2702: FROM ams_dm_models_all_b
2703: WHERE status_code <> 'EXPIRED'
2704: AND expiration_date <= SYSDATE
2705: ;
2706:

Line 2721: UPDATE ams_dm_models_all_b

2717: OPEN c_user_status_id;
2718: FETCH c_user_status_id INTO l_new_status_id;
2719: CLOSE c_user_status_id;
2720:
2721: UPDATE ams_dm_models_all_b
2722: SET user_status_id = l_new_status_id
2723: , status_code = G_MODEL_STATUS_EXPIRED
2724: , status_date = SYSDATE
2725: , object_version_number = object_version_number + 1

Line 2757: UPDATE ams_dm_models_all_b

2753: OPEN c_user_status_id (G_MODEL_STATUS_TYPE, p_status_code);
2754: FETCH c_user_status_id INTO l_user_status_id;
2755: CLOSE c_user_status_id;
2756:
2757: UPDATE ams_dm_models_all_b
2758: SET last_update_date = SYSDATE
2759: , last_updated_by = FND_GLOBAL.user_id
2760: , last_update_login = FND_GLOBAL.conc_login_id
2761: , object_version_number = object_version_number + 1

Line 2790: UPDATE ams_dm_models_all_b

2786: OPEN c_user_status_id (G_MODEL_STATUS_TYPE, G_MODEL_STATUS_AVAILABLE);
2787: FETCH c_user_status_id INTO l_user_status_id;
2788: CLOSE c_user_status_id;
2789:
2790: UPDATE ams_dm_models_all_b
2791: SET object_version_number = object_version_number + 1
2792: , last_update_date = SYSDATE
2793: , last_updated_by = FND_GLOBAL.user_id
2794: , status_date = SYSDATE

Line 2816: UPDATE ams_dm_models_all_b

2812: OPEN c_user_status_id (G_MODEL_STATUS_TYPE, p_status_code);
2813: FETCH c_user_status_id INTO l_user_status_id;
2814: CLOSE c_user_status_id;
2815:
2816: UPDATE ams_dm_models_all_b
2817: SET object_version_number = object_version_number + 1
2818: , last_update_date = SYSDATE
2819: , last_updated_by = FND_GLOBAL.user_id
2820: , status_date = SYSDATE

Line 2951: UPDATE ams_dm_models_all_b

2947: END IF;
2948:
2949:
2950: -- update the Model record with new status code and id and with NULL wf_itemkey
2951: UPDATE ams_dm_models_all_b
2952: SET object_version_number = object_version_number + 1,
2953: last_update_date = SYSDATE,
2954: last_updated_by = FND_GLOBAL.user_id,
2955: status_date = SYSDATE,

Line 3131: UPDATE ams_dm_models_all_b

3127: x_monitor_url := wf_monitor.geturl(wf_core.TRANSLATE('WF_WEB_AGENT'), AMS_WFMOD_PVT.G_DEFAULT_ITEMTYPE, l_tar_model_rec.wf_itemkey, 'NO');
3128:
3129: -- Update the Model record with the new status code (PREVIEWING) and Id
3130: -- and also with the WF Item Key
3131: UPDATE ams_dm_models_all_b
3132: SET logs_flag = 'Y',
3133: object_version_number = object_version_number + 1,
3134: last_update_date = SYSDATE,
3135: last_updated_by = FND_GLOBAL.user_id,

Line 3231: FROM ams_dm_models_all_b m,ams_dm_targets_b t

3227: ;
3228: --start changes rosharma 20-aug-2003 bug 3104201
3229: CURSOR c_data_source (p_model_id IN NUMBER) IS
3230: SELECT t.DATA_SOURCE_ID
3231: FROM ams_dm_models_all_b m,ams_dm_targets_b t
3232: WHERE m.model_id = p_model_id
3233: AND m.target_id = t.target_id
3234: ;
3235:

Line 3517: UPDATE ams_dm_models_all_b

3513: OPEN c_user_status_id (G_MODEL_STATUS_TYPE, G_MODEL_STATUS_BUILDING);
3514: FETCH c_user_status_id INTO l_user_status_id;
3515: CLOSE c_user_status_id;
3516:
3517: UPDATE ams_dm_models_all_b
3518: SET last_update_date = SYSDATE
3519: , last_updated_by = FND_GLOBAL.user_id
3520: , last_update_login = FND_GLOBAL.conc_login_id
3521: , object_version_number = object_version_number + 1

Line 3688: UPDATE ams_dm_models_all_b

3684: DELETE FROM ams_dm_imp_attributes
3685: WHERE MODEL_ID = p_MODEL_ID;
3686:
3687: -- Set the results_flag to 'N'
3688: UPDATE ams_dm_models_all_b
3689: SET results_flag = 'N'
3690: WHERE MODEL_ID = p_MODEL_ID;
3691:
3692: -- Debug Message

Line 3771: FROM ams_dm_models_all_b m

3767: AND action_used_by_id = p_model_id;
3768:
3769: CURSOR c_model_type(p_model_id IN NUMBER) IS
3770: SELECT m.model_type
3771: FROM ams_dm_models_all_b m
3772: WHERE m.model_id = p_model_id
3773: ;
3774:
3775: CURSOR c_prodSelectionExist(p_model_id IN NUMBER) IS

Line 3920: FROM ams_dm_models_all_b

3916: L_API_NAME CONSTANT VARCHAR2(30) := 'seededDataSource';
3917:
3918: CURSOR l_datasource (p_model_id IN NUMBER) IS
3919: SELECT target_id
3920: FROM ams_dm_models_all_b
3921: WHERE model_id = p_model_id;
3922: BEGIN
3923:
3924: -- Debug Message

Line 4073: -- UPDATE ams_dm_models_all_b

4069: FETCH c_user_status_id INTO l_status_id;
4070: CLOSE c_user_status_id;
4071:
4072: -- update the Scoring Run record with new status code and id and with NULL wf_itemkey
4073: -- UPDATE ams_dm_models_all_b
4074: -- SET object_version_number = object_version_number + 1,
4075: -- last_update_date = SYSDATE,
4076: -- last_updated_by = FND_GLOBAL.user_id,
4077: -- status_date = SYSDATE,

Line 4082: UPDATE ams_dm_models_all_b

4078: -- status_code = G_MODEL_STATUS_INVALID,
4079: -- user_status_id = l_status_id
4080: -- WHERE model_id = p_model_id;
4081:
4082: UPDATE ams_dm_models_all_b
4083: SET last_update_date = SYSDATE,
4084: last_updated_by = FND_GLOBAL.user_id,
4085: status_date = SYSDATE,
4086: status_code = G_MODEL_STATUS_INVALID,

Line 4124: FROM ams_dm_models_all_b m, ams_dm_targets_b t

4120: L_API_NAME CONSTANT VARCHAR2(30) := 'handle_data_source_changes';
4121:
4122: CURSOR c_models_using_datasource IS
4123: SELECT m.model_id, m.status_code
4124: FROM ams_dm_models_all_b m, ams_dm_targets_b t
4125: WHERE m.target_id = t.target_id
4126: AND t.data_source_id = p_datasource_id
4127: UNION
4128: SELECT m.model_id, m.status_code

Line 4129: FROM ams_dm_models_all_b m, ams_dm_targets_b t, ams_dm_target_sources s

4125: WHERE m.target_id = t.target_id
4126: AND t.data_source_id = p_datasource_id
4127: UNION
4128: SELECT m.model_id, m.status_code
4129: FROM ams_dm_models_all_b m, ams_dm_targets_b t, ams_dm_target_sources s
4130: WHERE m.target_id = t.target_id
4131: AND s.target_id = t.target_id
4132: AND s.data_source_id = p_datasource_id;
4133:

Line 4154: UPDATE ams_dm_models_all_b

4150: FOR l_models IN c_models_using_datasource LOOP
4151:
4152: -- If the model is AVAILABLE, then INVALIDate the model
4153: IF l_models.status_code = G_MODEL_STATUS_AVAILABLE THEN
4154: UPDATE ams_dm_models_all_b
4155: SET object_version_number = object_version_number + 1,
4156: last_update_date = SYSDATE,
4157: last_updated_by = FND_GLOBAL.user_id,
4158: status_date = SYSDATE,