21: p_rs_value_user_hook jtf_rs_values_user_hook;
22:
23: TYPE RS_PARAM_LIST_REC_TYPE IS RECORD
24: (
25: RESOURCE_PARAM_ID NUMBER := FND_API.G_MISS_NUM,
26: MEANING VARCHAR2(80) := FND_API.G_MISS_CHAR,
27: TYPE VARCHAR2(30) := FND_API.G_MISS_CHAR,
28: DOMAIN_LOOKUP_TYPE VARCHAR2(30) := FND_API.G_MISS_CHAR
29: );
22:
23: TYPE RS_PARAM_LIST_REC_TYPE IS RECORD
24: (
25: RESOURCE_PARAM_ID NUMBER := FND_API.G_MISS_NUM,
26: MEANING VARCHAR2(80) := FND_API.G_MISS_CHAR,
27: TYPE VARCHAR2(30) := FND_API.G_MISS_CHAR,
28: DOMAIN_LOOKUP_TYPE VARCHAR2(30) := FND_API.G_MISS_CHAR
29: );
30:
23: TYPE RS_PARAM_LIST_REC_TYPE IS RECORD
24: (
25: RESOURCE_PARAM_ID NUMBER := FND_API.G_MISS_NUM,
26: MEANING VARCHAR2(80) := FND_API.G_MISS_CHAR,
27: TYPE VARCHAR2(30) := FND_API.G_MISS_CHAR,
28: DOMAIN_LOOKUP_TYPE VARCHAR2(30) := FND_API.G_MISS_CHAR
29: );
30:
31: TYPE RS_PARAM_LIST_TBL_TYPE IS
24: (
25: RESOURCE_PARAM_ID NUMBER := FND_API.G_MISS_NUM,
26: MEANING VARCHAR2(80) := FND_API.G_MISS_CHAR,
27: TYPE VARCHAR2(30) := FND_API.G_MISS_CHAR,
28: DOMAIN_LOOKUP_TYPE VARCHAR2(30) := FND_API.G_MISS_CHAR
29: );
30:
31: TYPE RS_PARAM_LIST_TBL_TYPE IS
32: TABLE OF RS_PARAM_LIST_REC_TYPE
52: * @rep:displayname Create Resource Parameter Value
53: */
54: PROCEDURE CREATE_RS_RESOURCE_VALUES(
55: P_Api_Version IN NUMBER,
56: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
57: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
58: P_resource_id IN NUMBER,
59: p_resource_param_id IN NUMBER,
60: p_value IN VARCHAR2,
53: */
54: PROCEDURE CREATE_RS_RESOURCE_VALUES(
55: P_Api_Version IN NUMBER,
56: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
57: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
58: P_resource_id IN NUMBER,
59: p_resource_param_id IN NUMBER,
60: p_value IN VARCHAR2,
61: P_value_type IN VARCHAR2 DEFAULT NULL,
84: * @rep:displayname Update Resource Parameter Value
85: */
86: PROCEDURE UPDATE_RS_RESOURCE_VALUES(
87: P_Api_Version IN NUMBER,
88: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
89: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
90: p_resource_param_value_id IN NUMBER,
91: p_resource_id IN NUMBER,
92: p_resource_param_id IN NUMBER,
85: */
86: PROCEDURE UPDATE_RS_RESOURCE_VALUES(
87: P_Api_Version IN NUMBER,
88: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
89: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
90: p_resource_param_value_id IN NUMBER,
91: p_resource_id IN NUMBER,
92: p_resource_param_id IN NUMBER,
93: p_value IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
89: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
90: p_resource_param_value_id IN NUMBER,
91: p_resource_id IN NUMBER,
92: p_resource_param_id IN NUMBER,
93: p_value IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
94: p_value_type IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
95: p_object_version_number IN OUT NOCOPY JTF_RS_RESOURCE_VALUES.OBJECT_VERSION_NUMBER%TYPE,
96: X_Return_Status OUT NOCOPY VARCHAR2,
97: X_Msg_Count OUT NOCOPY NUMBER,
90: p_resource_param_value_id IN NUMBER,
91: p_resource_id IN NUMBER,
92: p_resource_param_id IN NUMBER,
93: p_value IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
94: p_value_type IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
95: p_object_version_number IN OUT NOCOPY JTF_RS_RESOURCE_VALUES.OBJECT_VERSION_NUMBER%TYPE,
96: X_Return_Status OUT NOCOPY VARCHAR2,
97: X_Msg_Count OUT NOCOPY NUMBER,
98: X_Msg_Data OUT NOCOPY VARCHAR2
112: * @rep:displayname Delete Resource Parameter Value
113: */
114: PROCEDURE DELETE_RS_RESOURCE_VALUES(
115: P_Api_Version IN NUMBER,
116: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
117: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
118: p_resource_param_value_id IN NUMBER,
119: p_object_version_number IN JTF_RS_RESOURCE_VALUES.OBJECT_VERSION_NUMBER%TYPE,
120: X_Return_Status OUT NOCOPY VARCHAR2,
113: */
114: PROCEDURE DELETE_RS_RESOURCE_VALUES(
115: P_Api_Version IN NUMBER,
116: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
117: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
118: p_resource_param_value_id IN NUMBER,
119: p_object_version_number IN JTF_RS_RESOURCE_VALUES.OBJECT_VERSION_NUMBER%TYPE,
120: X_Return_Status OUT NOCOPY VARCHAR2,
121: X_Msg_Count OUT NOCOPY NUMBER,
135: * @rep:displayname Delete Resource Parameter Values Of A Resource
136: */
137: PROCEDURE DELETE_ALL_RS_RESOURCE_VALUES(
138: P_Api_Version IN NUMBER,
139: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
140: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
141: p_resource_id IN NUMBER,
142: X_Return_Status OUT NOCOPY VARCHAR2,
143: X_Msg_Count OUT NOCOPY NUMBER,
136: */
137: PROCEDURE DELETE_ALL_RS_RESOURCE_VALUES(
138: P_Api_Version IN NUMBER,
139: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
140: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
141: p_resource_id IN NUMBER,
142: X_Return_Status OUT NOCOPY VARCHAR2,
143: X_Msg_Count OUT NOCOPY NUMBER,
144: X_Msg_Data OUT NOCOPY VARCHAR2
161: * @rep:displayname Get Resource Parameter Value
162: */
163: PROCEDURE GET_RS_RESOURCE_VALUES(
164: P_Api_Version IN NUMBER,
165: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
166: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
167: P_resource_id IN NUMBER,
168: P_value_type IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
169: p_resource_param_id IN NUMBER,
162: */
163: PROCEDURE GET_RS_RESOURCE_VALUES(
164: P_Api_Version IN NUMBER,
165: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
166: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
167: P_resource_id IN NUMBER,
168: P_value_type IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
169: p_resource_param_id IN NUMBER,
170: x_resource_param_value_id OUT NOCOPY NUMBER,
164: P_Api_Version IN NUMBER,
165: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
166: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
167: P_resource_id IN NUMBER,
168: P_value_type IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
169: p_resource_param_id IN NUMBER,
170: x_resource_param_value_id OUT NOCOPY NUMBER,
171: x_value OUT NOCOPY VARCHAR2,
172: X_Return_Status OUT NOCOPY VARCHAR2,
189: * @rep:displayname Get Resource Parameter List
190: */
191: PROCEDURE GET_RS_RESOURCE_PARAM_LIST(
192: P_Api_Version IN NUMBER,
193: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
194: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
195: P_APPLICATION_ID IN NUMBER,
196: X_Return_Status OUT NOCOPY VARCHAR2,
197: X_Msg_Count OUT NOCOPY NUMBER,
190: */
191: PROCEDURE GET_RS_RESOURCE_PARAM_LIST(
192: P_Api_Version IN NUMBER,
193: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
194: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
195: P_APPLICATION_ID IN NUMBER,
196: X_Return_Status OUT NOCOPY VARCHAR2,
197: X_Msg_Count OUT NOCOPY NUMBER,
198: X_Msg_Data OUT NOCOPY VARCHAR2,