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.JTF_RS_RESOURCE_VALUES_PVT dependencies on JTF_RESOURCE_UTL

Line 78: -- added to handle NOCOPY of JTF_RESOURCE_UTL package

74: L_ATTRIBUTE14 JTF_RS_RESOURCE_VALUES.ATTRIBUTE14%TYPE := p_attribute14;
75: L_ATTRIBUTE15 JTF_RS_RESOURCE_VALUES.ATTRIBUTE15%TYPE := p_attribute15;
76: L_ATTRIBUTE_CATEGORY JTF_RS_RESOURCE_VALUES.ATTRIBUTE_CATEGORY%TYPE := p_attribute_category;
77:
78: -- added to handle NOCOPY of JTF_RESOURCE_UTL package
79: l_resource_id_out NUMBER;
80:
81:
82: l_resource_param_value_id NUMBER;

Line 196: jtf_resource_utl.validate_resource_number(

192:
193: --Put in all the Validations here
194:
195: --Validate the Resource Id
196: jtf_resource_utl.validate_resource_number(
197: p_resource_id => l_resource_id,
198: p_resource_number => null,
199: x_return_status => x_return_status,
200: x_resource_id => l_resource_id_out

Line 212: jtf_resource_utl.validate_resource_param_id(

208: END IF;
209: --End of Resource Id Validation
210:
211: --Validate the Resource Param Id
212: jtf_resource_utl.validate_resource_param_id(
213: p_resource_param_id => l_resource_param_id,
214: x_return_status => x_return_status
215: );
216: IF NOT (x_return_status = fnd_api.g_ret_sts_success) THEN

Line 224: jtf_resource_utl.validate_rs_value_type(

220: --End of Resource Param Id Validation
221:
222: --Validate Resource Value Type
223: IF l_value_type IS NOT NULL THEN
224: jtf_resource_utl.validate_rs_value_type(
225: p_resource_param_id => l_resource_param_id,
226: p_value_type => l_value_type,
227: x_return_status => x_return_status
228: );

Line 238: jtf_resource_utl.validate_resource_value(

234: END IF;
235: --End of Resource Value Type Validation
236:
237: --Validate Resource Value
238: jtf_resource_utl.validate_resource_value(
239: p_resource_param_id => l_resource_param_id,
240: p_value => l_value,
241: x_return_status => x_return_status
242: );

Line 301: X_CREATED_BY => jtf_resource_utl.created_by,

297: X_ATTRIBUTE15 => l_attribute15,
298: X_ATTRIBUTE_CATEGORY => l_attribute_category,
299: X_ATTRIBUTE1 => l_attribute1,
300: X_CREATION_DATE => sysdate,
301: X_CREATED_BY => jtf_resource_utl.created_by,
302: X_LAST_UPDATE_DATE => sysdate,
303: X_LAST_UPDATED_BY => jtf_resource_utl.updated_by,
304: X_LAST_UPDATE_LOGIN => jtf_resource_utl.login_id
305: );

Line 303: X_LAST_UPDATED_BY => jtf_resource_utl.updated_by,

299: X_ATTRIBUTE1 => l_attribute1,
300: X_CREATION_DATE => sysdate,
301: X_CREATED_BY => jtf_resource_utl.created_by,
302: X_LAST_UPDATE_DATE => sysdate,
303: X_LAST_UPDATED_BY => jtf_resource_utl.updated_by,
304: X_LAST_UPDATE_LOGIN => jtf_resource_utl.login_id
305: );
306:
307: IF NOT (x_return_status = fnd_api.g_ret_sts_success) THEN

Line 304: X_LAST_UPDATE_LOGIN => jtf_resource_utl.login_id

300: X_CREATION_DATE => sysdate,
301: X_CREATED_BY => jtf_resource_utl.created_by,
302: X_LAST_UPDATE_DATE => sysdate,
303: X_LAST_UPDATED_BY => jtf_resource_utl.updated_by,
304: X_LAST_UPDATE_LOGIN => jtf_resource_utl.login_id
305: );
306:
307: IF NOT (x_return_status = fnd_api.g_ret_sts_success) THEN
308: --dbms_output.put_line('Failed status from call to table handler');

Line 659: jtf_resource_utl.validate_resource_value(

655: WHERE resource_param_value_id = l_resource_param_value_id;
656:
657: --Validate Resource Value
658: IF p_value <> FND_API.G_MISS_CHAR THEN
659: jtf_resource_utl.validate_resource_value(
660: p_resource_param_id => l_resource_param_id,
661: p_value => resource_param_value_rec.l_value,
662: x_return_status => x_return_status
663: );

Line 717: X_LAST_UPDATED_BY => jtf_resource_utl.updated_by,

713: X_ATTRIBUTE15 => resource_param_value_rec.l_attribute15,
714: X_ATTRIBUTE_CATEGORY => resource_param_value_rec.l_attribute_category,
715: X_ATTRIBUTE1 => resource_param_value_rec.l_attribute1,
716: X_LAST_UPDATE_DATE => sysdate,
717: X_LAST_UPDATED_BY => jtf_resource_utl.updated_by,
718: X_LAST_UPDATE_LOGIN => jtf_resource_utl.login_id
719: );
720: p_object_version_number := l_object_version_number;
721:

Line 718: X_LAST_UPDATE_LOGIN => jtf_resource_utl.login_id

714: X_ATTRIBUTE_CATEGORY => resource_param_value_rec.l_attribute_category,
715: X_ATTRIBUTE1 => resource_param_value_rec.l_attribute1,
716: X_LAST_UPDATE_DATE => sysdate,
717: X_LAST_UPDATED_BY => jtf_resource_utl.updated_by,
718: X_LAST_UPDATE_LOGIN => jtf_resource_utl.login_id
719: );
720: p_object_version_number := l_object_version_number;
721:
722: IF NOT (x_return_status = fnd_api.g_ret_sts_success) THEN

Line 1119: -- added to handle NOCOPY for JTF_RESOURCE_UTL package

1115: l_resource_id NUMBER := p_resource_id;
1116: l_resource_param_value_id NUMBER;
1117: l_object_version_number JTF_RS_RESOURCE_VALUES.OBJECT_VERSION_NUMBER%TYPE;
1118: l_bind_data_id NUMBER;
1119: -- added to handle NOCOPY for JTF_RESOURCE_UTL package
1120: l_resource_id_out NUMBER;
1121:
1122: CURSOR c_resource_param_value_id (l_resource_id IN NUMBER ) IS
1123: SELECT jrv.resource_param_value_id, jrv.object_version_number

Line 1208: jtf_resource_utl.validate_resource_number(

1204:
1205: --Put all Validations here
1206:
1207: --Validate Resource Id that was passed to the Procedure
1208: jtf_resource_utl.validate_resource_number(
1209: p_resource_id => l_resource_id,
1210: p_resource_number => null,
1211: x_return_status => x_return_status,
1212: x_resource_id => l_resource_id_out

Line 1383: jtf_resource_utl.validate_resource_number(

1379: --Initialize API return status to success
1380: x_return_status := FND_API.G_RET_STS_SUCCESS;
1381:
1382: --Validate the Resource Id
1383: jtf_resource_utl.validate_resource_number(
1384: p_resource_id => l_resource_id,
1385: p_resource_number => null,
1386: x_return_status => x_return_status,
1387: x_resource_id => l_resource_id_out

Line 1399: jtf_resource_utl.validate_resource_param_id(

1395: END IF;
1396: --End of Resource Id Validation
1397:
1398: --Validate the Resource Param Id
1399: jtf_resource_utl.validate_resource_param_id(
1400: p_resource_param_id => l_resource_param_id,
1401: x_return_status => x_return_status
1402: );
1403: IF NOT (x_return_status = fnd_api.g_ret_sts_success) THEN

Line 1412: jtf_resource_utl.validate_rs_value_type(

1408:
1409: --Validate the Value Type
1410: IF l_value_type <> FND_API.G_MISS_CHAR THEN
1411: IF l_value_type IS NOT NULL THEN
1412: jtf_resource_utl.validate_rs_value_type(
1413: p_resource_param_id => l_resource_param_id,
1414: p_value_type => l_value_type,
1415: x_return_status => x_return_status
1416: );