1 package FND_PROFILE_OPTION_VALUES_PKG as
2 /* $Header: AFPOMPVS.pls 120.1.12010000.2 2008/10/29 18:13:23 pdeluna ship $ */
3 /*#
4 * Table Handler to Insert and Update data into FND_PROFILE_OPTION_VALUES table.
5 * * @rep:scope public
6 * @rep:product FND
7 * @rep:displayname Profile Table Handler
8 * @rep:category BUSINESS_ENTITY FND_PROFILE
9 * @rep:compatibility S
10 * @rep:lifecycle active
11 */
12
13 /**
14 * This procedure is used to insert a row into fnd_profile_option_values.
15 * Due to the nature of profile option values having levels and granular
16 * values associated to its levels, this routine distinguishes between
17 * these levels to ensure data integrity.
18 * @param X_ROWID variable to store unique rowid
19 * @param X_APPLICATION_ID application ID of profile option
20 * @param X_PROFILE_OPTION_ID ID of profile option
21 * @param X_LEVEL_ID numeric ID of level where profile is being inserted
22 * @param X_LEVEL_VALUE numeric context value to save profile at, e.g. user_id
23 * @param X_CREATION_DATE date the record created
24 * @param X_CREATED_BY user that created the record
25 * @param X_LAST_UPDATE_DATE date the record was last updated
26 * @param X_LAST_UPDATED_BY user that last updated the record
27 * @param X_LAST_UPDATE_LOGIN login ID of user that last updated the record
28 * @param X_PROFILE_OPTION_VALUE profile value being saved
29 * @param X_LEVEL_VALUE_APPLICATION_ID context value of RESP-sensitive profiles
30 * @param X_LEVEL_VALUE2 second context value used for SERVRESP profiles
31 * @rep:scope public
32 * @rep:product fnd
33 * @rep:lifecycle active
34 * @rep:displayname Insert Row
35 */
36 procedure INSERT_ROW (
37 X_ROWID in out nocopy VARCHAR2,
38 X_APPLICATION_ID in NUMBER,
39 X_PROFILE_OPTION_ID in NUMBER,
40 X_LEVEL_ID in NUMBER,
41 X_LEVEL_VALUE in NUMBER,
42 X_CREATION_DATE in DATE,
43 X_CREATED_BY in NUMBER,
44 X_LAST_UPDATE_DATE in DATE,
45 X_LAST_UPDATED_BY in NUMBER,
46 X_LAST_UPDATE_LOGIN in NUMBER,
47 X_PROFILE_OPTION_VALUE in VARCHAR2,
48 X_LEVEL_VALUE_APPLICATION_ID in NUMBER,
49 X_LEVEL_VALUE2 in NUMBER
50 );
51
52 /**
53 * This procedure is used to update a row into fnd_profile_option_values.
54 * Due to the nature of profile option values having levels and granular
55 * values associated to its levels, this routine distinguishes between
56 * these levels to ensure data integrity. This is overloaded and provides
57 * support to the SERVRESP profile option hierarchy.
58 * @param X_APPLICATION_ID application ID of profile option
59 * @param X_PROFILE_OPTION_ID ID of profile option
60 * @param X_LEVEL_ID numeric ID of level where profile is being inserted
61 * @param X_LEVEL_VALUE numeric context value to save profile at, e.g. user_id
62 * @param X_LEVEL_VALUE_APPLICATION_ID context value of RESP-sensitive profiles
63 * @param X_LEVEL_VALUE2 second context value used for SERVRESP profiles
64 * @param X_PROFILE_OPTION_VALUE profile value being saved
65 * @param X_LAST_UPDATE_DATE date the record was last updated
66 * @param X_LAST_UPDATED_BY user that last updated the record
67 * @param X_LAST_UPDATE_LOGIN login ID of user that last updated the record
68 * @rep:scope public
69 * @rep:product fnd
70 * @rep:lifecycle active
71 * @rep:displayname Update Row
72 */
73 procedure UPDATE_ROW (
74 X_APPLICATION_ID in NUMBER,
75 X_PROFILE_OPTION_ID in NUMBER,
76 X_LEVEL_ID in NUMBER,
77 X_LEVEL_VALUE in NUMBER,
78 X_LEVEL_VALUE_APPLICATION_ID in NUMBER,
79 X_LEVEL_VALUE2 in NUMBER,
80 X_PROFILE_OPTION_VALUE in VARCHAR2,
81 X_LAST_UPDATE_DATE in DATE,
82 X_LAST_UPDATED_BY in NUMBER,
83 X_LAST_UPDATE_LOGIN in NUMBER
84 );
85
86 /**
87 * This procedure is used to update a row into fnd_profile_option_values.
88 * Due to the nature of profile option values having levels and granular
89 * values associated to its levels, this routine distinguishes between
90 * these levels to ensure data integrity.
91 * @param X_APPLICATION_ID application ID of pThis is overloaded and provides
92 * support to the SERVRESP profile option hierarchy.rofile option
93 * @param X_PROFILE_OPTION_ID ID of profile option
94 * @param X_LEVEL_ID numeric ID of level where profile is being inserted
95 * @param X_LEVEL_VALUE numeric context value to save profile at, e.g. user_id
96 * @param X_LEVEL_VALUE_APPLICATION_ID context value of RESP-sensitive profiles
97 * @param X_PROFILE_OPTION_VALUE profile value being saved
98 * @param X_LAST_UPDATE_DATE date the record was last updated
99 * @param X_LAST_UPDATED_BY user that last updated the record
100 * @param X_LAST_UPDATE_LOGIN login ID of user that last updated the record
101 * @rep:scope public
102 * @rep:product fnd
103 * @rep:lifecycle active
104 * @rep:displayname Update Row
105 */
106 procedure UPDATE_ROW (
107 X_APPLICATION_ID in NUMBER,
108 X_PROFILE_OPTION_ID in NUMBER,
109 X_LEVEL_ID in NUMBER,
110 X_LEVEL_VALUE in NUMBER,
111 X_LEVEL_VALUE_APPLICATION_ID in NUMBER,
112 X_PROFILE_OPTION_VALUE in VARCHAR2,
113 X_LAST_UPDATE_DATE in DATE,
114 X_LAST_UPDATED_BY in NUMBER,
115 X_LAST_UPDATE_LOGIN in NUMBER
116 );
117
118 /**
119 * This procedure is used to delete profile option values at a given level,
120 * (if it applies). This is overloaded and provides support to the SERVRESP
121 * profile option hierarchy.
122 * @param X_APPLICATION_ID application ID of profile option
123 * @param X_PROFILE_OPTION_ID ID of profile option
124 * @param X_LEVEL_ID numeric ID of level where profile is being inserted
125 * @param X_LEVEL_VALUE numeric context value to save profile at, e.g. user_id
126 * @param X_LEVEL_VALUE_APPLICATION_ID context value of RESP-sensitive profiles
127 * @param X_LEVEL_VALUE2 second context value used for SERVRESP profiles
128 * @rep:scope public
129 * @rep:product fnd
130 * @rep:lifecycle active
131 * @rep:displayname Delete Row
132 */
133 procedure DELETE_ROW (
134 X_APPLICATION_ID in NUMBER,
135 X_PROFILE_OPTION_ID in NUMBER,
136 X_LEVEL_ID in NUMBER,
137 X_LEVEL_VALUE in NUMBER,
138 X_LEVEL_VALUE_APPLICATION_ID in NUMBER,
139 X_LEVEL_VALUE2 in NUMBER
140 );
141
142 /**
143 * This procedure is used to delete profile option values at a given level,
144 * (if it applies).
145 * @param X_APPLICATION_ID application ID of profile option
146 * @param X_PROFILE_OPTION_ID ID of profile option
147 * @param X_LEVEL_ID numeric ID of level where profile is being inserted
148 * @param X_LEVEL_VALUE numeric context value to save profile at, e.g. user_id
149 * @param X_LEVEL_VALUE_APPLICATION_ID context value of RESP-sensitive profiles
150 * @rep:scope public
151 * @rep:product fnd
152 * @rep:lifecycle active
153 * @rep:displayname Delete Row
154 */
155 procedure DELETE_ROW (
156 X_APPLICATION_ID in NUMBER,
157 X_PROFILE_OPTION_ID in NUMBER,
158 X_LEVEL_ID in NUMBER,
159 X_LEVEL_VALUE in NUMBER,
160 X_LEVEL_VALUE_APPLICATION_ID in NUMBER
161 );
162
163 /**
164 * This procedure is only going to be called from
165 * FND_PROFILE_OPTIONS_PKG.DELETE_ROW which deletes profile option
166 * definitions. This procedure ensures that there will be no dangling
167 * references in FND_PROFILE_OPTION_VALUES to the profile option being
168 * deleted, i.e. if a profile is being deleted, it should have no rows
169 * for profile option values.
170 * Please note that it is not recommended that this API be used outside of
171 * FND_PROFILE_OPTIONS_PKG.DELETE_ROW as it is only meant to be called when a
172 * profile option is being deleted. Should it be used for purposes other
173 * than described, the risks involved with a blanket deletion of profile
174 * option values are assumed by the caller, not FND.
175 * @param X_PROFILE_OPTION_NAME Unique name of profile option
176 * @rep:scope public
177 * @rep:product fnd
178 * @rep:lifecycle active
179 * @rep:displayname Delete Profile Option Values
180 */
181 procedure DELETE_PROFILE_OPTION_VALUES (X_PROFILE_OPTION_NAME in VARCHAR2);
182
183 end FND_PROFILE_OPTION_VALUES_PKG;