[Home] [Help]
PACKAGE: APPS.JTF_RS_RESOURCE_VALUES_PVT
Source
1 PACKAGE jtf_rs_resource_values_pvt AUTHID CURRENT_USER AS
2 /* $Header: jtfrsvcs.pls 120.0 2005/05/11 08:22:54 appldev ship $ */
3
4 PROCEDURE CREATE_RS_RESOURCE_VALUES(
5 P_Api_Version IN NUMBER,
6 P_Init_Msg_List IN VARCHAR2 DEFAULT FND_API.G_FALSE,
7 P_Commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
8 P_resource_id IN NUMBER,
9 p_resource_param_id IN NUMBER,
10 p_value IN VARCHAR2,
11 P_value_type IN VARCHAR2 DEFAULT NULL,
12 P_ATTRIBUTE1 IN VARCHAR2 DEFAULT NULL,
13 P_ATTRIBUTE2 IN VARCHAR2 DEFAULT NULL,
14 P_ATTRIBUTE3 IN VARCHAR2 DEFAULT NULL,
15 P_ATTRIBUTE4 IN VARCHAR2 DEFAULT NULL,
16 P_ATTRIBUTE5 IN VARCHAR2 DEFAULT NULL,
17 P_ATTRIBUTE6 IN VARCHAR2 DEFAULT NULL,
18 P_ATTRIBUTE7 IN VARCHAR2 DEFAULT NULL,
19 P_ATTRIBUTE8 IN VARCHAR2 DEFAULT NULL,
20 P_ATTRIBUTE9 IN VARCHAR2 DEFAULT NULL,
21 P_ATTRIBUTE10 IN VARCHAR2 DEFAULT NULL,
22 P_ATTRIBUTE11 IN VARCHAR2 DEFAULT NULL,
23 P_ATTRIBUTE12 IN VARCHAR2 DEFAULT NULL,
24 P_ATTRIBUTE13 IN VARCHAR2 DEFAULT NULL,
25 P_ATTRIBUTE14 IN VARCHAR2 DEFAULT NULL,
26 P_ATTRIBUTE15 IN VARCHAR2 DEFAULT NULL,
27 P_ATTRIBUTE_CATEGORY IN VARCHAR2 DEFAULT NULL,
28 X_Return_Status OUT NOCOPY VARCHAR2,
29 X_Msg_Count OUT NOCOPY NUMBER,
30 X_Msg_Data OUT NOCOPY VARCHAR2,
31 X_resource_param_value_id OUT NOCOPY NUMBER
32 );
33
34
35 PROCEDURE UPDATE_RS_RESOURCE_VALUES(
36 P_Api_Version IN NUMBER,
37 P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
38 P_Commit IN VARCHAR2 := FND_API.G_FALSE,
39 p_resource_param_value_id IN NUMBER,
40 p_value IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
41 P_ATTRIBUTE1 IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
42 P_ATTRIBUTE2 IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
43 P_ATTRIBUTE3 IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
44 P_ATTRIBUTE4 IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
45 P_ATTRIBUTE5 IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
46 P_ATTRIBUTE6 IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
47 P_ATTRIBUTE7 IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
48 P_ATTRIBUTE8 IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
49 P_ATTRIBUTE9 IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
50 P_ATTRIBUTE10 IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
51 P_ATTRIBUTE11 IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
52 P_ATTRIBUTE12 IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
53 P_ATTRIBUTE13 IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
54 P_ATTRIBUTE14 IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
55 P_ATTRIBUTE15 IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
56 P_ATTRIBUTE_CATEGORY IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
57 p_object_version_number IN OUT NOCOPY JTF_RS_RESOURCE_VALUES.OBJECT_VERSION_NUMBER%TYPE,
58 X_Return_Status OUT NOCOPY VARCHAR2,
59 X_Msg_Count OUT NOCOPY NUMBER,
60 X_Msg_Data OUT NOCOPY VARCHAR2
61 );
62
63 PROCEDURE DELETE_RS_RESOURCE_VALUES(
64 P_Api_Version IN NUMBER,
65 P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
66 P_Commit IN VARCHAR2 := FND_API.G_FALSE,
67 p_resource_param_value_id IN NUMBER,
68 p_object_version_number IN JTF_RS_RESOURCE_VALUES.OBJECT_VERSION_NUMBER%TYPE,
69 X_Return_Status OUT NOCOPY VARCHAR2,
70 X_Msg_Count OUT NOCOPY NUMBER,
71 X_Msg_Data OUT NOCOPY VARCHAR2
72 );
73
74 PROCEDURE DELETE_ALL_RS_RESOURCE_VALUES(
75 P_Api_Version IN NUMBER,
76 P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
77 P_Commit IN VARCHAR2 := FND_API.G_FALSE,
78 p_resource_id IN NUMBER,
79 X_Return_Status OUT NOCOPY VARCHAR2,
80 X_Msg_Count OUT NOCOPY NUMBER,
81 X_Msg_Data OUT NOCOPY VARCHAR2
82 );
83
84 PROCEDURE GET_RS_RESOURCE_VALUES(
85 P_Api_Version IN NUMBER,
86 P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
87 P_Commit IN VARCHAR2 := FND_API.G_FALSE,
88 P_resource_id IN NUMBER,
89 P_value_type IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
90 p_resource_param_id IN NUMBER,
91 x_resource_param_value_id OUT NOCOPY NUMBER,
92 x_value OUT NOCOPY VARCHAR2,
93 X_Return_Status OUT NOCOPY VARCHAR2,
94 X_Msg_Count OUT NOCOPY NUMBER,
95 X_Msg_Data OUT NOCOPY VARCHAR2
96 );
97
98 PROCEDURE GET_RS_RESOURCE_PARAM_LIST(
99 P_Api_Version IN NUMBER,
100 P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
101 P_Commit IN VARCHAR2 := FND_API.G_FALSE,
102 P_APPLICATION_ID IN NUMBER,
103 X_Return_Status OUT NOCOPY VARCHAR2,
104 X_Msg_Count OUT NOCOPY NUMBER,
105 X_Msg_Data OUT NOCOPY VARCHAR2,
106 X_RS_PARAM_Table OUT NOCOPY JTF_RS_RESOURCE_VALUES_PUB.RS_PARAM_LIST_TBL_TYPE,
107 X_No_Record OUT NOCOPY NUMBER
108 );
109
110 End JTF_RS_RESOURCE_VALUES_PVT;