APPS.JTF_RS_RESOURCE_VALUES_PUB dependencies on JTF_RS_RESOURCE_VALUES

Line 1: PACKAGE BODY jtf_rs_resource_values_pub AS

1: PACKAGE BODY jtf_rs_resource_values_pub AS
2: /* $Header: jtfrspcb.pls 120.0 2005/05/11 08:21:05 appldev ship $ */
3:
4: /*****************************************************************************************
5: This is a public API that caller will invoke.

Line 15: Calls to these procedures will invoke procedures from jtf_rs_resource_values_pvt

11: Delete Resource Values
12: Delete All Resource Values
13: Get Resource Values
14: Get Resource Param List
15: Calls to these procedures will invoke procedures from jtf_rs_resource_values_pvt
16: to do business validations and to do actual inserts, updates and deletes into tables.
17: ******************************************************************************************/
18:
19: --Package variables

Line 91: jtf_rs_resource_values_pvt.create_rs_resource_values(

87: END IF;
88: --End of Resource Param Id Validation
89:
90: --Call the Private API for create_rs_resource_values
91: jtf_rs_resource_values_pvt.create_rs_resource_values(
92: P_API_VERSION => 1,
93: P_INIT_MSG_LIST => fnd_api.g_false,
94: P_COMMIT => fnd_api.g_false,
95: P_resource_id => l_resource_id,

Line 144: p_object_version_number IN OUT NOCOPY JTF_RS_RESOURCE_VALUES.OBJECT_VERSION_NUMBER%TYPE,

140: p_resource_id IN NUMBER,
141: p_resource_param_id IN NUMBER,
142: p_value IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
143: p_value_type IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
144: p_object_version_number IN OUT NOCOPY JTF_RS_RESOURCE_VALUES.OBJECT_VERSION_NUMBER%TYPE,
145: X_Return_Status OUT NOCOPY VARCHAR2,
146: X_Msg_Count OUT NOCOPY NUMBER,
147: X_Msg_Data OUT NOCOPY VARCHAR2
148: )IS

Line 222: FROM jtf_rs_resource_values

218:
219: --Get Resource Param Value Id from the database
220: SELECT resource_param_value_id
221: INTO l_resource_param_value_id
222: FROM jtf_rs_resource_values
223: WHERE resource_id = l_resource_id
224: AND resource_param_id = l_resource_param_id
225: AND value_type = l_value_type;
226:

Line 228: jtf_rs_resource_values_pvt.update_rs_resource_values(

224: AND resource_param_id = l_resource_param_id
225: AND value_type = l_value_type;
226:
227: --Call the private procedure for update
228: jtf_rs_resource_values_pvt.update_rs_resource_values(
229: P_API_VERSION => 1,
230: P_INIT_MSG_LIST => fnd_api.g_false,
231: P_COMMIT => fnd_api.g_false,
232: p_resource_param_value_id => l_resource_param_value_id,

Line 274: p_object_version_number IN JTF_RS_RESOURCE_VALUES.OBJECT_VERSION_NUMBER%TYPE,

270: P_Api_Version IN NUMBER,
271: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
272: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
273: p_resource_param_value_id IN NUMBER,
274: p_object_version_number IN JTF_RS_RESOURCE_VALUES.OBJECT_VERSION_NUMBER%TYPE,
275: X_Return_Status OUT NOCOPY VARCHAR2,
276: X_Msg_Count OUT NOCOPY NUMBER,
277: X_Msg_Data OUT NOCOPY VARCHAR2
278: )IS

Line 302: jtf_rs_resource_values_pvt.delete_rs_resource_values(

298: --Put all Validations here
299:
300: --Call the private procedure for delete
301:
302: jtf_rs_resource_values_pvt.delete_rs_resource_values(
303: P_API_VERSION => 1,
304: P_INIT_MSG_LIST => fnd_api.g_false,
305: P_COMMIT => fnd_api.g_false,
306: P_RESOURCE_PARAM_VALUE_ID => l_resource_param_value_id,

Line 375: jtf_rs_resource_values_pvt.delete_all_rs_resource_values(

371: --Put all Validations here
372:
373: --Call the private procedure for delete
374:
375: jtf_rs_resource_values_pvt.delete_all_rs_resource_values(
376: P_API_VERSION => 1,
377: P_INIT_MSG_LIST => fnd_api.g_false,
378: P_COMMIT => fnd_api.g_false,
379: P_RESOURCE_ID => l_resource_id,

Line 482: jtf_rs_resource_values_pvt.get_rs_resource_values

478: /* End of Resource Param Id Validation */
479:
480: --Call the private procedure for get
481:
482: jtf_rs_resource_values_pvt.get_rs_resource_values
483: (P_API_VERSION => 1,
484: P_INIT_MSG_LIST => fnd_api.g_false,
485: P_COMMIT => fnd_api.g_false,
486: P_resource_id => l_resource_id,

Line 557: jtf_rs_resource_values_pvt.get_rs_resource_param_list

553: --Put all Validations here
554:
555: --Call the private procedure for get
556:
557: jtf_rs_resource_values_pvt.get_rs_resource_param_list
558: (P_API_VERSION => 1,
559: P_INIT_MSG_LIST => fnd_api.g_false,
560: P_COMMIT => fnd_api.g_false,
561: P_APPLICATION_ID => l_application_id,

Line 595: End JTF_RS_RESOURCE_VALUES_PUB;

591: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
592:
593: END get_rs_resource_param_list;
594:
595: End JTF_RS_RESOURCE_VALUES_PUB;