10: --
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 service setup informations
24: --
24: --
25: -- Output Parameters
26: -- x_return_status
27: -- if the process succeeds, the value is
28: -- fnd_api.g_ret_sts_success;
29: -- if there is an expected error, the value is
30: -- fnd_api.g_ret_sts_error;
31: -- if there is an unexpected error, the value is
32: -- fnd_api.g_ret_sts_unexp_error;
26: -- x_return_status
27: -- if the process succeeds, the value is
28: -- fnd_api.g_ret_sts_success;
29: -- if there is an expected error, the value is
30: -- fnd_api.g_ret_sts_error;
31: -- if there is an unexpected error, the value is
32: -- fnd_api.g_ret_sts_unexp_error;
33: -- x_msg_count
34: -- if there is one or more errors, the number of error messages
28: -- fnd_api.g_ret_sts_success;
29: -- if there is an expected error, the value is
30: -- fnd_api.g_ret_sts_error;
31: -- if there is an unexpected error, the value is
32: -- fnd_api.g_ret_sts_unexp_error;
33: -- x_msg_count
34: -- if there is one or more errors, the number of error messages
35: -- in the buffer
36: -- x_msg_data
34: -- if there is one or more errors, the number of error messages
35: -- in the buffer
36: -- x_msg_data
37: -- if there is one and only one error, the error message
38: -- (See fnd_api package for more details about the above output parameters)
39: -- p_CC_SERVICE_SEQUENCE_ID - Clear Cross Service sequence Id ( PK)
40:
41: --*/
42:
42:
43: PROCEDURE Insert_Row
44: (
45: p_api_version IN NUMBER ,
46: p_init_msg_list IN VARCHAR2 := fnd_api.g_false ,
47: p_commit IN VARCHAR2 := fnd_api.g_false ,
48: x_return_status OUT VARCHAR2 ,
49: x_msg_count OUT NUMBER ,
50: x_msg_data OUT VARCHAR2 ,
43: PROCEDURE Insert_Row
44: (
45: p_api_version IN NUMBER ,
46: p_init_msg_list IN VARCHAR2 := fnd_api.g_false ,
47: p_commit IN VARCHAR2 := fnd_api.g_false ,
48: x_return_status OUT VARCHAR2 ,
49: x_msg_count OUT NUMBER ,
50: x_msg_data OUT VARCHAR2 ,
51: p_APPLICATION_ID IN NUMBER,
78: --
79: -- Input Parameters
80: -- p_api_version
81: -- API version number (current version is 1.0)
82: -- p_init_msg_list (optional, default FND_API.G_FALSE)
83: -- Valid values: FND_API.G_FALSE or FND_API.G_TRUE.
84: -- if set to FND_API.G_TRUE
85: -- initialize error message list
86: -- if set to FND_API.G_FALSE - not initialize error
79: -- Input Parameters
80: -- p_api_version
81: -- API version number (current version is 1.0)
82: -- p_init_msg_list (optional, default FND_API.G_FALSE)
83: -- Valid values: FND_API.G_FALSE or FND_API.G_TRUE.
84: -- if set to FND_API.G_TRUE
85: -- initialize error message list
86: -- if set to FND_API.G_FALSE - not initialize error
87: -- message list
80: -- p_api_version
81: -- API version number (current version is 1.0)
82: -- p_init_msg_list (optional, default FND_API.G_FALSE)
83: -- Valid values: FND_API.G_FALSE or FND_API.G_TRUE.
84: -- if set to FND_API.G_TRUE
85: -- initialize error message list
86: -- if set to FND_API.G_FALSE - not initialize error
87: -- message list
88: -- p_commit (optional, default FND_API.G_FALSE)
82: -- p_init_msg_list (optional, default FND_API.G_FALSE)
83: -- Valid values: FND_API.G_FALSE or FND_API.G_TRUE.
84: -- if set to FND_API.G_TRUE
85: -- initialize error message list
86: -- if set to FND_API.G_FALSE - not initialize error
87: -- message list
88: -- p_commit (optional, default FND_API.G_FALSE)
89: -- whether or not to commit the changes to database
90: --
84: -- if set to FND_API.G_TRUE
85: -- initialize error message list
86: -- if set to FND_API.G_FALSE - not initialize error
87: -- message list
88: -- p_commit (optional, default FND_API.G_FALSE)
89: -- whether or not to commit the changes to database
90: --
91: -- Input parameters for Clear Cross Service Setups Informations
92: --
93: --
94: -- Output Parameters
95: -- x_return_status
96: -- if the process succeeds, the value is
97: -- fnd_api.g_ret_sts_success;
98: -- if there is an expected error, the value is
99: -- fnd_api.g_ret_sts_error;
100: -- if there is an unexpected error, the value is
101: -- fnd_api.g_ret_sts_unexp_error;
95: -- x_return_status
96: -- if the process succeeds, the value is
97: -- fnd_api.g_ret_sts_success;
98: -- if there is an expected error, the value is
99: -- fnd_api.g_ret_sts_error;
100: -- if there is an unexpected error, the value is
101: -- fnd_api.g_ret_sts_unexp_error;
102: -- x_msg_count
103: -- if there is one or more errors, the number of error messages
97: -- fnd_api.g_ret_sts_success;
98: -- if there is an expected error, the value is
99: -- fnd_api.g_ret_sts_error;
100: -- if there is an unexpected error, the value is
101: -- fnd_api.g_ret_sts_unexp_error;
102: -- x_msg_count
103: -- if there is one or more errors, the number of error messages
104: -- in the buffer
105: -- x_msg_data
103: -- if there is one or more errors, the number of error messages
104: -- in the buffer
105: -- x_msg_data
106: -- if there is one and only one error, the error message
107: -- (See fnd_api package for more details about the above output parameters)
108: --*/
109:
110: PROCEDURE Update_Row
111: (
109:
110: PROCEDURE Update_Row
111: (
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: PROCEDURE Update_Row
111: (
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_APPLICATION_ID IN NUMBER,
116: x_msg_count OUT NUMBER ,
117: x_msg_data OUT VARCHAR2 ,
118: p_APPLICATION_ID IN NUMBER,
119: p_MASTER_ORGANIZATION_ID IN NUMBER,
120: p_ORGANIZATION_ID IN NUMBER default fnd_api.g_miss_num,
121: p_APPLICATION_USER_ID IN NUMBER default fnd_api.g_miss_num,
122: p_SERVICE_TYPE_CODE IN VARCHAR2,
123: p_SERVICE_VERSION IN VARCHAR2 default null,
124: p_SERVICE_HANDLER IN VARCHAR2,
117: x_msg_data OUT VARCHAR2 ,
118: p_APPLICATION_ID IN NUMBER,
119: p_MASTER_ORGANIZATION_ID IN NUMBER,
120: p_ORGANIZATION_ID IN NUMBER default fnd_api.g_miss_num,
121: p_APPLICATION_USER_ID IN NUMBER default fnd_api.g_miss_num,
122: p_SERVICE_TYPE_CODE IN VARCHAR2,
123: p_SERVICE_VERSION IN VARCHAR2 default null,
124: p_SERVICE_HANDLER IN VARCHAR2,
125: p_SERVICE_DEFAULT_THRESHOLD IN NUMBER,
145: --
146: -- Input Parameters
147: -- p_api_version
148: -- API version number (current version is 1.0)
149: -- p_init_msg_list (optional, default FND_API.G_FALSE)
150: -- Valid values: FND_API.G_FALSE or FND_API.G_TRUE.
151: -- if set to FND_API.G_TRUE
152: -- initialize error message list
153: -- if set to FND_API.G_FALSE - not initialize error
146: -- Input Parameters
147: -- p_api_version
148: -- API version number (current version is 1.0)
149: -- p_init_msg_list (optional, default FND_API.G_FALSE)
150: -- Valid values: FND_API.G_FALSE or FND_API.G_TRUE.
151: -- if set to FND_API.G_TRUE
152: -- initialize error message list
153: -- if set to FND_API.G_FALSE - not initialize error
154: -- message list
147: -- p_api_version
148: -- API version number (current version is 1.0)
149: -- p_init_msg_list (optional, default FND_API.G_FALSE)
150: -- Valid values: FND_API.G_FALSE or FND_API.G_TRUE.
151: -- if set to FND_API.G_TRUE
152: -- initialize error message list
153: -- if set to FND_API.G_FALSE - not initialize error
154: -- message list
155: -- p_commit (optional, default FND_API.G_FALSE)
149: -- p_init_msg_list (optional, default FND_API.G_FALSE)
150: -- Valid values: FND_API.G_FALSE or FND_API.G_TRUE.
151: -- if set to FND_API.G_TRUE
152: -- initialize error message list
153: -- if set to FND_API.G_FALSE - not initialize error
154: -- message list
155: -- p_commit (optional, default FND_API.G_FALSE)
156: -- whether or not to commit the changes to database
157: --
151: -- if set to FND_API.G_TRUE
152: -- initialize error message list
153: -- if set to FND_API.G_FALSE - not initialize error
154: -- message list
155: -- p_commit (optional, default FND_API.G_FALSE)
156: -- whether or not to commit the changes to database
157: --
158: -- Input parameters for Clear Cross Users Informations
159: -- p_CC_SERVICE_SEQUENCE_ID - Seq Id (PK)
161: --
162: -- Output Parameters
163: -- x_return_status
164: -- if the process succeeds, the value is
165: -- fnd_api.g_ret_sts_success;
166: -- if there is an expected error, the value is
167: -- fnd_api.g_ret_sts_error;
168: -- if there is an unexpected error, the value is
169: -- fnd_api.g_ret_sts_unexp_error;
163: -- x_return_status
164: -- if the process succeeds, the value is
165: -- fnd_api.g_ret_sts_success;
166: -- if there is an expected error, the value is
167: -- fnd_api.g_ret_sts_error;
168: -- if there is an unexpected error, the value is
169: -- fnd_api.g_ret_sts_unexp_error;
170: -- x_msg_count
171: -- if there is one or more errors, the number of error messages
165: -- fnd_api.g_ret_sts_success;
166: -- if there is an expected error, the value is
167: -- fnd_api.g_ret_sts_error;
168: -- if there is an unexpected error, the value is
169: -- fnd_api.g_ret_sts_unexp_error;
170: -- x_msg_count
171: -- if there is one or more errors, the number of error messages
172: -- in the buffer
173: -- x_msg_data
171: -- if there is one or more errors, the number of error messages
172: -- in the buffer
173: -- x_msg_data
174: -- if there is one and only one error, the error message
175: -- (See fnd_api package for more details about the above output parameters)
176: --*/
177:
178: PROCEDURE Delete_Row
179: (
177:
178: PROCEDURE Delete_Row
179: (
180: p_api_version IN NUMBER ,
181: p_init_msg_list IN VARCHAR2 := fnd_api.g_false ,
182: p_commit IN VARCHAR2 := fnd_api.g_false ,
183: x_return_status OUT VARCHAR2 ,
184: x_msg_count OUT NUMBER ,
185: x_msg_data OUT VARCHAR2 ,
178: PROCEDURE Delete_Row
179: (
180: p_api_version IN NUMBER ,
181: p_init_msg_list IN VARCHAR2 := fnd_api.g_false ,
182: p_commit IN VARCHAR2 := fnd_api.g_false ,
183: x_return_status OUT VARCHAR2 ,
184: x_msg_count OUT NUMBER ,
185: x_msg_data OUT VARCHAR2 ,
186: p_CC_SERVICE_SEQUENCE_ID IN NUMBER
194: --
195: -- Input Parameters
196: -- p_api_version
197: -- API version number (current version is 1.0)
198: -- p_init_msg_list (optional, default FND_API.G_FALSE)
199: -- Valid values: FND_API.G_FALSE or FND_API.G_TRUE.
200: -- if set to FND_API.G_TRUE
201: -- initialize error message list
202: -- if set to FND_API.G_FALSE - not initialize error
195: -- Input Parameters
196: -- p_api_version
197: -- API version number (current version is 1.0)
198: -- p_init_msg_list (optional, default FND_API.G_FALSE)
199: -- Valid values: FND_API.G_FALSE or FND_API.G_TRUE.
200: -- if set to FND_API.G_TRUE
201: -- initialize error message list
202: -- if set to FND_API.G_FALSE - not initialize error
203: -- message list
196: -- p_api_version
197: -- API version number (current version is 1.0)
198: -- p_init_msg_list (optional, default FND_API.G_FALSE)
199: -- Valid values: FND_API.G_FALSE or FND_API.G_TRUE.
200: -- if set to FND_API.G_TRUE
201: -- initialize error message list
202: -- if set to FND_API.G_FALSE - not initialize error
203: -- message list
204: -- p_commit (optional, default FND_API.G_FALSE)
198: -- p_init_msg_list (optional, default FND_API.G_FALSE)
199: -- Valid values: FND_API.G_FALSE or FND_API.G_TRUE.
200: -- if set to FND_API.G_TRUE
201: -- initialize error message list
202: -- if set to FND_API.G_FALSE - not initialize error
203: -- message list
204: -- p_commit (optional, default FND_API.G_FALSE)
205: -- whether or not to commit the changes to database
206: --
200: -- if set to FND_API.G_TRUE
201: -- initialize error message list
202: -- if set to FND_API.G_FALSE - not initialize error
203: -- message list
204: -- p_commit (optional, default FND_API.G_FALSE)
205: -- whether or not to commit the changes to database
206: --
207: -- Input parameters for clear cross service setups informations
208: --
209: --
210: -- Output Parameters
211: -- x_return_status
212: -- if the process succeeds, the value is
213: -- fnd_api.g_ret_sts_success;
214: -- if there is an expected error, the value is
215: -- fnd_api.g_ret_sts_error;
216: -- if there is an unexpected error, the value is
217: -- fnd_api.g_ret_sts_unexp_error;
211: -- x_return_status
212: -- if the process succeeds, the value is
213: -- fnd_api.g_ret_sts_success;
214: -- if there is an expected error, the value is
215: -- fnd_api.g_ret_sts_error;
216: -- if there is an unexpected error, the value is
217: -- fnd_api.g_ret_sts_unexp_error;
218: -- x_msg_count
219: -- if there is one or more errors, the number of error messages
213: -- fnd_api.g_ret_sts_success;
214: -- if there is an expected error, the value is
215: -- fnd_api.g_ret_sts_error;
216: -- if there is an unexpected error, the value is
217: -- fnd_api.g_ret_sts_unexp_error;
218: -- x_msg_count
219: -- if there is one or more errors, the number of error messages
220: -- in the buffer
221: -- x_msg_data
219: -- if there is one or more errors, the number of error messages
220: -- in the buffer
221: -- x_msg_data
222: -- if there is one and only one error, the error message
223: -- (See fnd_api package for more details about the above output parameters)
224:
225: --*/
226: PROCEDURE Lock_Row
227: (
225: --*/
226: PROCEDURE Lock_Row
227: (
228: p_api_version IN NUMBER ,
229: p_init_msg_list IN VARCHAR2 := fnd_api.g_false ,
230: p_commit IN VARCHAR2 := fnd_api.g_false ,
231: x_return_status OUT VARCHAR2 ,
232: x_msg_count OUT NUMBER ,
233: x_msg_data OUT VARCHAR2 ,
226: PROCEDURE Lock_Row
227: (
228: p_api_version IN NUMBER ,
229: p_init_msg_list IN VARCHAR2 := fnd_api.g_false ,
230: p_commit IN VARCHAR2 := fnd_api.g_false ,
231: x_return_status OUT VARCHAR2 ,
232: x_msg_count OUT NUMBER ,
233: x_msg_data OUT VARCHAR2 ,
234: p_APPLICATION_ID IN NUMBER,
232: x_msg_count OUT NUMBER ,
233: x_msg_data OUT VARCHAR2 ,
234: p_APPLICATION_ID IN NUMBER,
235: p_MASTER_ORGANIZATION_ID IN NUMBER,
236: p_ORGANIZATION_ID IN NUMBER default fnd_api.g_miss_num,
237: p_APPLICATION_USER_ID IN NUMBER default fnd_api.g_miss_num,
238: p_SERVICE_TYPE_CODE IN VARCHAR2,
239: p_SERVICE_VERSION IN VARCHAR2 default null,
240: p_SERVICE_HANDLER IN VARCHAR2,
233: x_msg_data OUT VARCHAR2 ,
234: p_APPLICATION_ID IN NUMBER,
235: p_MASTER_ORGANIZATION_ID IN NUMBER,
236: p_ORGANIZATION_ID IN NUMBER default fnd_api.g_miss_num,
237: p_APPLICATION_USER_ID IN NUMBER default fnd_api.g_miss_num,
238: p_SERVICE_TYPE_CODE IN VARCHAR2,
239: p_SERVICE_VERSION IN VARCHAR2 default null,
240: p_SERVICE_HANDLER IN VARCHAR2,
241: p_SERVICE_DEFAULT_THRESHOLD IN NUMBER,