APPS.JTF_RS_RESOURCE_VALUES_PVT dependencies on JTF_RS_RESOURCE_VALUES_PKG

Line 277: jtf_rs_resource_values_pkg.insert_row(

273: INTO l_resource_param_value_id
274: FROM dual;
275:
276: --Call the Table Handler to Insert Values
277: jtf_rs_resource_values_pkg.insert_row(
278: X_ROWID => l_rowid,
279: X_RESOURCE_PARAM_VALUE_ID => l_resource_param_value_id,
280: X_RESOURCE_ID => l_resource_id,
281: X_RESOURCE_PARAM_ID => l_resource_param_id,

Line 672: jtf_rs_resource_values_pkg.lock_row(

668: END IF;
669: --End of Resource Value Validation
670:
671: --Lock the row in the table by calling the table handler
672: jtf_rs_resource_values_pkg.lock_row(
673: X_RESOURCE_PARAM_VALUE_ID => l_resource_param_value_id,
674: X_OBJECT_VERSION_NUMBER => l_object_version_number
675: );
676:

Line 693: jtf_rs_resource_values_pkg.update_row(

689: l_value1 := resource_param_value_rec.l_value;
690: END IF;
691:
692: --Call the Table Handler to Update Values
693: jtf_rs_resource_values_pkg.update_row(
694: X_RESOURCE_PARAM_VALUE_ID => l_resource_param_value_id,
695: X_RESOURCE_ID => l_resource_id,
696: X_RESOURCE_PARAM_ID => l_resource_param_id,
697: X_VALUE => l_value1,

Line 970: jtf_rs_resource_values_pkg.lock_row(

966: END IF;
967:
968:
969: --Lock the row in the table before delete, by calling the table handler. */
970: jtf_rs_resource_values_pkg.lock_row(
971: X_RESOURCE_PARAM_VALUE_ID => l_resource_param_value_id,
972: X_OBJECT_VERSION_NUMBER => l_object_version_number
973: );
974:

Line 976: jtf_rs_resource_values_pkg.delete_row(

972: X_OBJECT_VERSION_NUMBER => l_object_version_number
973: );
974:
975: --Call Table Handler to Delete the Record
976: jtf_rs_resource_values_pkg.delete_row(
977: X_RESOURCE_PARAM_VALUE_ID => l_resource_param_value_id
978: );
979: IF NOT (x_return_status = fnd_api.g_ret_sts_success) THEN
980: --dbms_output.put_line('Failed status from call to table handler');

Line 1226: jtf_rs_resource_values_pkg.lock_row(

1222: --Loop through the Cursor and Delete all the entries for the given Resource ID
1223: FOR i IN c_resource_param_value_id (l_resource_id) LOOP
1224: --Call to the Lock_Row Table Handlers to lock the record before deleting it
1225: BEGIN
1226: jtf_rs_resource_values_pkg.lock_row(
1227: X_RESOURCE_PARAM_VALUE_ID => i.resource_param_value_id,
1228: X_OBJECT_VERSION_NUMBER => i.object_version_number
1229: );
1230: EXCEPTION

Line 1240: jtf_rs_resource_values_pkg.delete_row(

1236: RAISE fnd_api.g_exc_unexpected_error;
1237: END;
1238: --Call Table Handler to Delete the Selected Records
1239: BEGIN
1240: jtf_rs_resource_values_pkg.delete_row(
1241: X_RESOURCE_PARAM_VALUE_ID => i.resource_param_value_id
1242: );
1243: EXCEPTION
1244: WHEN NO_DATA_FOUND THEN