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 FND_GLOBAL

Line 119: G_USER_ID NUMBER := FND_GLOBAL.USER_ID;

115:
116:
117: G_SEEDED_ID_THRESHOLD CONSTANT NUMBER := 10000;
118: /***
119: G_USER_ID NUMBER := FND_GLOBAL.USER_ID;
120: G_LOGIN_ID NUMBER := FND_GLOBAL.CONC_LOGIN_ID;
121: ***/
122:
123: -- global cursors

Line 120: G_LOGIN_ID NUMBER := FND_GLOBAL.CONC_LOGIN_ID;

116:
117: G_SEEDED_ID_THRESHOLD CONSTANT NUMBER := 10000;
118: /***
119: G_USER_ID NUMBER := FND_GLOBAL.USER_ID;
120: G_LOGIN_ID NUMBER := FND_GLOBAL.CONC_LOGIN_ID;
121: ***/
122:
123: -- global cursors
124:

Line 582: IF FND_GLOBAL.User_Id IS NULL THEN

578:
579: -- ******************************************************************
580: -- Validate Environment
581: -- ******************************************************************
582: IF FND_GLOBAL.User_Id IS NULL THEN
583: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
584: FND_MESSAGE.Set_Name('AMS', 'USER_PROFILE_MISSING');
585: FND_MSG_PUB.ADD;
586: END IF;

Line 675: p_last_updated_by => FND_GLOBAL.USER_ID,

671: -- Invoke table handler(ams_dm_models_b_PKG.Insert_Row)
672: AMS_DM_MODELS_B_PKG.Insert_Row(
673: p_model_id => l_dm_model_rec.model_id,
674: p_last_update_date => sysdate,
675: p_last_updated_by => FND_GLOBAL.USER_ID,
676: p_creation_date => sysdate,
677: p_created_by => FND_GLOBAL.USER_ID,
678: p_last_update_login => FND_GLOBAL.CONC_LOGIN_ID,
679: p_object_version_number => l_object_version_number,

Line 677: p_created_by => FND_GLOBAL.USER_ID,

673: p_model_id => l_dm_model_rec.model_id,
674: p_last_update_date => sysdate,
675: p_last_updated_by => FND_GLOBAL.USER_ID,
676: p_creation_date => sysdate,
677: p_created_by => FND_GLOBAL.USER_ID,
678: p_last_update_login => FND_GLOBAL.CONC_LOGIN_ID,
679: p_object_version_number => l_object_version_number,
680: p_model_type => l_dm_model_rec.model_type,
681: p_user_status_id => l_dm_model_rec.user_status_id,

Line 678: p_last_update_login => FND_GLOBAL.CONC_LOGIN_ID,

674: p_last_update_date => sysdate,
675: p_last_updated_by => FND_GLOBAL.USER_ID,
676: p_creation_date => sysdate,
677: p_created_by => FND_GLOBAL.USER_ID,
678: p_last_update_login => FND_GLOBAL.CONC_LOGIN_ID,
679: p_object_version_number => l_object_version_number,
680: p_model_type => l_dm_model_rec.model_type,
681: p_user_status_id => l_dm_model_rec.user_status_id,
682: p_status_code => l_dm_model_rec.status_code,

Line 1298: p_last_updated_by => FND_GLOBAL.USER_ID,

1294: -- Invoke table handler(AMS_DM_MODELS_B_PKG.Update_Row)
1295: AMS_DM_MODELS_B_PKG.Update_Row(
1296: p_model_id => l_tar_model_rec.model_id,
1297: p_last_update_date => sysdate,
1298: p_last_updated_by => FND_GLOBAL.USER_ID,
1299: p_last_update_login => FND_GLOBAL.CONC_LOGIN_ID,
1300: p_object_version_number => l_tar_model_rec.object_version_number,
1301: p_model_type => l_tar_model_rec.model_type,
1302: p_user_status_id => l_tar_model_rec.user_status_id,

Line 1299: p_last_update_login => FND_GLOBAL.CONC_LOGIN_ID,

1295: AMS_DM_MODELS_B_PKG.Update_Row(
1296: p_model_id => l_tar_model_rec.model_id,
1297: p_last_update_date => sysdate,
1298: p_last_updated_by => FND_GLOBAL.USER_ID,
1299: p_last_update_login => FND_GLOBAL.CONC_LOGIN_ID,
1300: p_object_version_number => l_tar_model_rec.object_version_number,
1301: p_model_type => l_tar_model_rec.model_type,
1302: p_user_status_id => l_tar_model_rec.user_status_id,
1303: p_status_code => l_tar_model_rec.status_code,

Line 2105: l_context_resource_id := AMS_Utility_PVT.get_resource_id(FND_GLOBAL.user_id);

2101: -- THEN
2102: -- x_return_status := FND_API.G_RET_STS_ERROR;
2103:
2104: IF p_validation_mode = JTF_PLSQL_API.G_UPDATE THEN
2105: l_context_resource_id := AMS_Utility_PVT.get_resource_id(FND_GLOBAL.user_id);
2106:
2107: OPEN c_reference(p_dm_model_rec.model_id);
2108: FETCH c_reference INTO l_reference_rec;
2109: CLOSE c_reference;

Line 2668: l_owner_user_id NUMBER := AMS_Utility_PVT.get_resource_id (FND_GLOBAL.user_id);

2664: L_MODEL_QUALIFIER CONSTANT VARCHAR2(30) := 'MODL';
2665: L_ACCESS_TYPE_USER CONSTANT VARCHAR2(30) := 'USER';
2666:
2667: -- user id of the currently logged in user.
2668: l_owner_user_id NUMBER := AMS_Utility_PVT.get_resource_id (FND_GLOBAL.user_id);
2669: BEGIN
2670: -- Initialize API return status to SUCCESS
2671: x_return_status := FND_API.G_RET_STS_SUCCESS;
2672:

Line 2727: , last_updated_by = FND_GLOBAL.user_id

2723: , status_code = G_MODEL_STATUS_EXPIRED
2724: , status_date = SYSDATE
2725: , object_version_number = object_version_number + 1
2726: , last_update_date = SYSDATE
2727: , last_updated_by = FND_GLOBAL.user_id
2728: WHERE model_id = l_expired_models_rec.model_id;
2729: END LOOP;
2730: EXCEPTION
2731: WHEN OTHERS THEN

Line 2759: , last_updated_by = FND_GLOBAL.user_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
2762: , status_code = p_status_code
2763: , user_status_id = l_user_status_id

Line 2760: , last_update_login = FND_GLOBAL.conc_login_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
2762: , status_code = p_status_code
2763: , user_status_id = l_user_status_id
2764: , status_date = SYSDATE

Line 2793: , last_updated_by = FND_GLOBAL.user_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
2795: , status_code = G_MODEL_STATUS_AVAILABLE
2796: , user_status_id = l_user_status_id
2797: WHERE model_id = p_model_id;

Line 2819: , last_updated_by = FND_GLOBAL.user_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
2821: , status_code = p_status_code
2822: , user_status_id = l_user_status_id
2823: , last_build_date = SYSDATE

Line 2954: last_updated_by = FND_GLOBAL.user_id,

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,
2956: status_code = l_ref_model_rec.status_code,
2957: user_status_id = l_ref_model_rec.user_status_id,
2958: wf_itemkey = l_ref_model_rec.wf_itemkey,

Line 3014: l_owner_user_id NUMBER := AMS_Utility_PVT.get_resource_id (FND_GLOBAL.user_id);

3010: )
3011: IS
3012: L_MODEL_QUALIFIER CONSTANT VARCHAR2(30) := 'MODL';
3013: L_ACCESS_TYPE_USER CONSTANT VARCHAR2(30) := 'USER';
3014: l_owner_user_id NUMBER := AMS_Utility_PVT.get_resource_id (FND_GLOBAL.user_id);
3015:
3016: l_proceedWithPreviewFlag VARCHAR2(1);
3017: l_data_exists_flag VARCHAR2(1);
3018: l_target_id NUMBER;

Line 3135: last_updated_by = FND_GLOBAL.user_id,

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,
3136: status_date = SYSDATE,
3137: status_code = l_tar_model_rec.status_code,
3138: user_status_id = l_tar_model_rec.user_status_id,
3139: wf_itemkey = l_tar_model_rec.wf_itemkey

Line 3519: , last_updated_by = FND_GLOBAL.user_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
3522: , status_code = G_MODEL_STATUS_BUILDING
3523: , user_status_id = l_user_status_id

Line 3520: , last_update_login = FND_GLOBAL.conc_login_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
3522: , status_code = G_MODEL_STATUS_BUILDING
3523: , user_status_id = l_user_status_id
3524: , status_date = SYSDATE

Line 4076: -- last_updated_by = FND_GLOBAL.user_id,

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,
4078: -- status_code = G_MODEL_STATUS_INVALID,
4079: -- user_status_id = l_status_id
4080: -- WHERE model_id = p_model_id;

Line 4084: last_updated_by = FND_GLOBAL.user_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,
4087: user_status_id = l_status_id
4088: WHERE model_id = p_model_id;

Line 4157: last_updated_by = FND_GLOBAL.user_id,

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,
4159: status_code = G_MODEL_STATUS_INVALID,
4160: user_status_id = l_status_id
4161: WHERE model_id = l_models.model_id;