10: -- Insert a row into WSH_CC_PARAMETER_SETUPS_TL entity.
11: -- Input Parameters
12: -- p_api_version
13: -- API version number (current version is 1.0)
14: -- p_init_msg_list (optional, default FND_API.G_FALSE)
15: -- Valid values: FND_API.G_FALSE or FND_API.G_TRUE.
16: -- if set to FND_API.G_TRUE
17: -- initialize error message list
18: -- if set to FND_API.G_FALSE - not initialize error
11: -- Input Parameters
12: -- p_api_version
13: -- API version number (current version is 1.0)
14: -- p_init_msg_list (optional, default FND_API.G_FALSE)
15: -- Valid values: FND_API.G_FALSE or FND_API.G_TRUE.
16: -- if set to FND_API.G_TRUE
17: -- initialize error message list
18: -- if set to FND_API.G_FALSE - not initialize error
19: -- message list
12: -- p_api_version
13: -- API version number (current version is 1.0)
14: -- p_init_msg_list (optional, default FND_API.G_FALSE)
15: -- Valid values: FND_API.G_FALSE or FND_API.G_TRUE.
16: -- if set to FND_API.G_TRUE
17: -- initialize error message list
18: -- if set to FND_API.G_FALSE - not initialize error
19: -- message list
20: -- p_commit (optional, default FND_API.G_FALSE)
14: -- p_init_msg_list (optional, default FND_API.G_FALSE)
15: -- Valid values: FND_API.G_FALSE or FND_API.G_TRUE.
16: -- if set to FND_API.G_TRUE
17: -- initialize error message list
18: -- if set to FND_API.G_FALSE - not initialize error
19: -- message list
20: -- p_commit (optional, default FND_API.G_FALSE)
21: -- whether or not to commit the changes to database
22: --
16: -- if set to FND_API.G_TRUE
17: -- initialize error message list
18: -- if set to FND_API.G_FALSE - not initialize error
19: -- message list
20: -- p_commit (optional, default FND_API.G_FALSE)
21: -- whether or not to commit the changes to database
22: --
23: -- Input parameters for clear cross parameters information
24: -- P_PARAMETER_NAME Internal Name for the Parameter.
30: --
31: -- Output Parameters
32: -- x_return_status
33: -- if the process succeeds, the value is
34: -- fnd_api.g_ret_sts_success;
35: -- if there is an expected error, the value is
36: -- fnd_api.g_ret_sts_error;
37: -- if there is an unexpected error, the value is
38: -- fnd_api.g_ret_sts_unexp_error;
32: -- x_return_status
33: -- if the process succeeds, the value is
34: -- fnd_api.g_ret_sts_success;
35: -- if there is an expected error, the value is
36: -- fnd_api.g_ret_sts_error;
37: -- if there is an unexpected error, the value is
38: -- fnd_api.g_ret_sts_unexp_error;
39: -- x_msg_count
40: -- if there is one or more errors, the number of error messages
34: -- fnd_api.g_ret_sts_success;
35: -- if there is an expected error, the value is
36: -- fnd_api.g_ret_sts_error;
37: -- if there is an unexpected error, the value is
38: -- fnd_api.g_ret_sts_unexp_error;
39: -- x_msg_count
40: -- if there is one or more errors, the number of error messages
41: -- in the buffer
42: -- x_msg_data
40: -- if there is one or more errors, the number of error messages
41: -- in the buffer
42: -- x_msg_data
43: -- if there is one and only one error, the error message
44: -- (See fnd_api package for more details about the above output parameters)
45: -- p_PARAMETER_ID - Clear Cross sequence Id ( PK)
46:
47: --*/
48:
48:
49:
50: procedure INSERT_ROW (
51: p_api_version IN NUMBER ,
52: p_init_msg_list IN VARCHAR2 := fnd_api.g_false ,
53: p_commit IN VARCHAR2 := fnd_api.g_false ,
54: x_return_status OUT VARCHAR2 ,
55: x_msg_count OUT NUMBER ,
56: x_msg_data OUT VARCHAR2 ,
49:
50: procedure INSERT_ROW (
51: p_api_version IN NUMBER ,
52: p_init_msg_list IN VARCHAR2 := fnd_api.g_false ,
53: p_commit IN VARCHAR2 := fnd_api.g_false ,
54: x_return_status OUT VARCHAR2 ,
55: x_msg_count OUT NUMBER ,
56: x_msg_data OUT VARCHAR2 ,
57: P_PARAMETER_ID OUT NUMBER ,
72: -- Check Lock a row of WSH_CC_PARAMETER_SETUPS_TL entity.
73: -- Input Parameters
74: -- p_api_version
75: -- API version number (current version is 1.0)
76: -- p_init_msg_list (optional, default FND_API.G_FALSE)
77: -- Valid values: FND_API.G_FALSE or FND_API.G_TRUE.
78: -- if set to FND_API.G_TRUE
79: -- initialize error message list
80: -- if set to FND_API.G_FALSE - not initialize error
73: -- Input Parameters
74: -- p_api_version
75: -- API version number (current version is 1.0)
76: -- p_init_msg_list (optional, default FND_API.G_FALSE)
77: -- Valid values: FND_API.G_FALSE or FND_API.G_TRUE.
78: -- if set to FND_API.G_TRUE
79: -- initialize error message list
80: -- if set to FND_API.G_FALSE - not initialize error
81: -- message list
74: -- p_api_version
75: -- API version number (current version is 1.0)
76: -- p_init_msg_list (optional, default FND_API.G_FALSE)
77: -- Valid values: FND_API.G_FALSE or FND_API.G_TRUE.
78: -- if set to FND_API.G_TRUE
79: -- initialize error message list
80: -- if set to FND_API.G_FALSE - not initialize error
81: -- message list
82: -- p_commit (optional, default FND_API.G_FALSE)
76: -- p_init_msg_list (optional, default FND_API.G_FALSE)
77: -- Valid values: FND_API.G_FALSE or FND_API.G_TRUE.
78: -- if set to FND_API.G_TRUE
79: -- initialize error message list
80: -- if set to FND_API.G_FALSE - not initialize error
81: -- message list
82: -- p_commit (optional, default FND_API.G_FALSE)
83: -- whether or not to commit the changes to database
84: --
78: -- if set to FND_API.G_TRUE
79: -- initialize error message list
80: -- if set to FND_API.G_FALSE - not initialize error
81: -- message list
82: -- p_commit (optional, default FND_API.G_FALSE)
83: -- whether or not to commit the changes to database
84: --
85: -- Input parameters for clear cross parameter setups information
86: --
94: --
95: -- Output Parameters
96: -- x_return_status
97: -- if the process succeeds, the value is
98: -- fnd_api.g_ret_sts_success;
99: -- if there is an expected error, the value is
100: -- fnd_api.g_ret_sts_error;
101: -- if there is an unexpected error, the value is
102: -- fnd_api.g_ret_sts_unexp_error;
96: -- x_return_status
97: -- if the process succeeds, the value is
98: -- fnd_api.g_ret_sts_success;
99: -- if there is an expected error, the value is
100: -- fnd_api.g_ret_sts_error;
101: -- if there is an unexpected error, the value is
102: -- fnd_api.g_ret_sts_unexp_error;
103: -- x_msg_count
104: -- if there is one or more errors, the number of error messages
98: -- fnd_api.g_ret_sts_success;
99: -- if there is an expected error, the value is
100: -- fnd_api.g_ret_sts_error;
101: -- if there is an unexpected error, the value is
102: -- fnd_api.g_ret_sts_unexp_error;
103: -- x_msg_count
104: -- if there is one or more errors, the number of error messages
105: -- in the buffer
106: -- x_msg_data
104: -- if there is one or more errors, the number of error messages
105: -- in the buffer
106: -- x_msg_data
107: -- if there is one and only one error, the error message
108: -- (See fnd_api package for more details about the above output parameters)
109:
110: --*/
111: procedure LOCK_ROW (
112: p_api_version IN NUMBER ,
109:
110: --*/
111: procedure LOCK_ROW (
112: p_api_version IN NUMBER ,
113: p_init_msg_list IN VARCHAR2 := fnd_api.g_false ,
114: p_commit IN VARCHAR2 := fnd_api.g_false ,
115: x_return_status OUT VARCHAR2 ,
116: x_msg_count OUT NUMBER ,
117: x_msg_data OUT VARCHAR2 ,
110: --*/
111: procedure LOCK_ROW (
112: p_api_version IN NUMBER ,
113: p_init_msg_list IN VARCHAR2 := fnd_api.g_false ,
114: p_commit IN VARCHAR2 := fnd_api.g_false ,
115: x_return_status OUT VARCHAR2 ,
116: x_msg_count OUT NUMBER ,
117: x_msg_data OUT VARCHAR2 ,
118: P_PARAMETER_ID IN NUMBER,
133: -- Update a row into wsh_cc_parameter_setups_tl entity
134: -- Input Parameters
135: -- p_api_version
136: -- API version number (current version is 1.0)
137: -- p_init_msg_list (optional, default FND_API.G_FALSE)
138: -- Valid values: FND_API.G_FALSE or FND_API.G_TRUE.
139: -- if set to FND_API.G_TRUE
140: -- initialize error message list
141: -- if set to FND_API.G_FALSE - not initialize error
134: -- Input Parameters
135: -- p_api_version
136: -- API version number (current version is 1.0)
137: -- p_init_msg_list (optional, default FND_API.G_FALSE)
138: -- Valid values: FND_API.G_FALSE or FND_API.G_TRUE.
139: -- if set to FND_API.G_TRUE
140: -- initialize error message list
141: -- if set to FND_API.G_FALSE - not initialize error
142: -- message list
135: -- p_api_version
136: -- API version number (current version is 1.0)
137: -- p_init_msg_list (optional, default FND_API.G_FALSE)
138: -- Valid values: FND_API.G_FALSE or FND_API.G_TRUE.
139: -- if set to FND_API.G_TRUE
140: -- initialize error message list
141: -- if set to FND_API.G_FALSE - not initialize error
142: -- message list
143: -- p_commit (optional, default FND_API.G_FALSE)
137: -- p_init_msg_list (optional, default FND_API.G_FALSE)
138: -- Valid values: FND_API.G_FALSE or FND_API.G_TRUE.
139: -- if set to FND_API.G_TRUE
140: -- initialize error message list
141: -- if set to FND_API.G_FALSE - not initialize error
142: -- message list
143: -- p_commit (optional, default FND_API.G_FALSE)
144: -- whether or not to commit the changes to database
145: --
139: -- if set to FND_API.G_TRUE
140: -- initialize error message list
141: -- if set to FND_API.G_FALSE - not initialize error
142: -- message list
143: -- p_commit (optional, default FND_API.G_FALSE)
144: -- whether or not to commit the changes to database
145: --
146: -- Input parameters for Clear Cross Parameter Setups Informations
147: -- P_PARAMETER_ID Parameter ID.
154: --
155: -- Output Parameters
156: -- x_return_status
157: -- if the process succeeds, the value is
158: -- fnd_api.g_ret_sts_success;
159: -- if there is an expected error, the value is
160: -- fnd_api.g_ret_sts_error;
161: -- if there is an unexpected error, the value is
162: -- fnd_api.g_ret_sts_unexp_error;
156: -- x_return_status
157: -- if the process succeeds, the value is
158: -- fnd_api.g_ret_sts_success;
159: -- if there is an expected error, the value is
160: -- fnd_api.g_ret_sts_error;
161: -- if there is an unexpected error, the value is
162: -- fnd_api.g_ret_sts_unexp_error;
163: -- x_msg_count
164: -- if there is one or more errors, the number of error messages
158: -- fnd_api.g_ret_sts_success;
159: -- if there is an expected error, the value is
160: -- fnd_api.g_ret_sts_error;
161: -- if there is an unexpected error, the value is
162: -- fnd_api.g_ret_sts_unexp_error;
163: -- x_msg_count
164: -- if there is one or more errors, the number of error messages
165: -- in the buffer
166: -- x_msg_data
164: -- if there is one or more errors, the number of error messages
165: -- in the buffer
166: -- x_msg_data
167: -- if there is one and only one error, the error message
168: -- (See fnd_api package for more details about the above output parameters)
169: --*/
170:
171:
172:
171:
172:
173: procedure UPDATE_ROW (
174: p_api_version IN NUMBER ,
175: p_init_msg_list IN VARCHAR2 := fnd_api.g_false,
176: p_commit IN VARCHAR2 := fnd_api.g_false,
177: x_return_status OUT VARCHAR2 ,
178: x_msg_count OUT NUMBER ,
179: x_msg_data OUT VARCHAR2 ,
172:
173: procedure UPDATE_ROW (
174: p_api_version IN NUMBER ,
175: p_init_msg_list IN VARCHAR2 := fnd_api.g_false,
176: p_commit IN VARCHAR2 := fnd_api.g_false,
177: x_return_status OUT VARCHAR2 ,
178: x_msg_count OUT NUMBER ,
179: x_msg_data OUT VARCHAR2 ,
180: P_PARAMETER_ID IN NUMBER ,
195: -- Delete a row from wsh_cc_parameter_setups_tl entity
196: -- Input Parameters
197: -- p_api_version
198: -- API version number (current version is 1.0)
199: -- p_init_msg_list (optional, default FND_API.G_FALSE)
200: -- Valid values: FND_API.G_FALSE or FND_API.G_TRUE.
201: -- if set to FND_API.G_TRUE
202: -- initialize error message list
203: -- if set to FND_API.G_FALSE - not initialize error
196: -- Input Parameters
197: -- p_api_version
198: -- API version number (current version is 1.0)
199: -- p_init_msg_list (optional, default FND_API.G_FALSE)
200: -- Valid values: FND_API.G_FALSE or FND_API.G_TRUE.
201: -- if set to FND_API.G_TRUE
202: -- initialize error message list
203: -- if set to FND_API.G_FALSE - not initialize error
204: -- message list
197: -- p_api_version
198: -- API version number (current version is 1.0)
199: -- p_init_msg_list (optional, default FND_API.G_FALSE)
200: -- Valid values: FND_API.G_FALSE or FND_API.G_TRUE.
201: -- if set to FND_API.G_TRUE
202: -- initialize error message list
203: -- if set to FND_API.G_FALSE - not initialize error
204: -- message list
205: -- p_commit (optional, default FND_API.G_FALSE)
199: -- p_init_msg_list (optional, default FND_API.G_FALSE)
200: -- Valid values: FND_API.G_FALSE or FND_API.G_TRUE.
201: -- if set to FND_API.G_TRUE
202: -- initialize error message list
203: -- if set to FND_API.G_FALSE - not initialize error
204: -- message list
205: -- p_commit (optional, default FND_API.G_FALSE)
206: -- whether or not to commit the changes to database
207: --
201: -- if set to FND_API.G_TRUE
202: -- initialize error message list
203: -- if set to FND_API.G_FALSE - not initialize error
204: -- message list
205: -- p_commit (optional, default FND_API.G_FALSE)
206: -- whether or not to commit the changes to database
207: --
208: -- Input parameters for Clear Cross Parameters Informations
209: -- P_PARAMETER_ID - Seq Id (PK)
211: --
212: -- Output Parameters
213: -- x_return_status
214: -- if the process succeeds, the value is
215: -- fnd_api.g_ret_sts_success;
216: -- if there is an expected error, the value is
217: -- fnd_api.g_ret_sts_error;
218: -- if there is an unexpected error, the value is
219: -- fnd_api.g_ret_sts_unexp_error;
213: -- x_return_status
214: -- if the process succeeds, the value is
215: -- fnd_api.g_ret_sts_success;
216: -- if there is an expected error, the value is
217: -- fnd_api.g_ret_sts_error;
218: -- if there is an unexpected error, the value is
219: -- fnd_api.g_ret_sts_unexp_error;
220: -- x_msg_count
221: -- if there is one or more errors, the number of error messages
215: -- fnd_api.g_ret_sts_success;
216: -- if there is an expected error, the value is
217: -- fnd_api.g_ret_sts_error;
218: -- if there is an unexpected error, the value is
219: -- fnd_api.g_ret_sts_unexp_error;
220: -- x_msg_count
221: -- if there is one or more errors, the number of error messages
222: -- in the buffer
223: -- x_msg_data
221: -- if there is one or more errors, the number of error messages
222: -- in the buffer
223: -- x_msg_data
224: -- if there is one and only one error, the error message
225: -- (See fnd_api package for more details about the above output parameters)
226: --*/
227:
228: procedure DELETE_ROW (
229: p_api_version IN NUMBER ,
226: --*/
227:
228: procedure DELETE_ROW (
229: p_api_version IN NUMBER ,
230: p_init_msg_list IN VARCHAR2 := fnd_api.g_false ,
231: p_commit IN VARCHAR2 := fnd_api.g_false ,
232: x_return_status OUT VARCHAR2 ,
233: x_msg_count OUT NUMBER ,
234: x_msg_data OUT VARCHAR2 ,
227:
228: procedure DELETE_ROW (
229: p_api_version IN NUMBER ,
230: p_init_msg_list IN VARCHAR2 := fnd_api.g_false ,
231: p_commit IN VARCHAR2 := fnd_api.g_false ,
232: x_return_status OUT VARCHAR2 ,
233: x_msg_count OUT NUMBER ,
234: x_msg_data OUT VARCHAR2 ,
235: P_PARAMETER_ID IN NUMBER