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 users informations
24: -- p_APPLICATION_ID --Application ID added
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:
46: --*/
47:
48: PROCEDURE Insert_Row
47:
48: PROCEDURE Insert_Row
49: (
50: p_api_version IN NUMBER ,
51: p_init_msg_list IN VARCHAR2 := fnd_api.g_false ,
52: p_commit IN VARCHAR2 := fnd_api.g_false ,
53: x_return_status OUT NOCOPY VARCHAR2 ,
54: x_msg_count OUT NOCOPY NUMBER ,
55: x_msg_data OUT NOCOPY VARCHAR2 ,
48: PROCEDURE Insert_Row
49: (
50: p_api_version IN NUMBER ,
51: p_init_msg_list IN VARCHAR2 := fnd_api.g_false ,
52: p_commit IN VARCHAR2 := fnd_api.g_false ,
53: x_return_status OUT NOCOPY VARCHAR2 ,
54: x_msg_count OUT NOCOPY NUMBER ,
55: x_msg_data OUT NOCOPY VARCHAR2 ,
56: p_VENDOR_ID IN NUMBER,
72: --
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 users informations
86: -- p_VENDOR_ID
95: --
96: -- Output Parameters
97: -- x_return_status
98: -- if the process succeeds, the value is
99: -- fnd_api.g_ret_sts_success;
100: -- if there is an expected error, the value is
101: -- fnd_api.g_ret_sts_error;
102: -- if there is an unexpected error, the value is
103: -- fnd_api.g_ret_sts_unexp_error;
97: -- x_return_status
98: -- if the process succeeds, the value is
99: -- fnd_api.g_ret_sts_success;
100: -- if there is an expected error, the value is
101: -- fnd_api.g_ret_sts_error;
102: -- if there is an unexpected error, the value is
103: -- fnd_api.g_ret_sts_unexp_error;
104: -- x_msg_count
105: -- if there is one or more errors, the number of error messages
99: -- fnd_api.g_ret_sts_success;
100: -- if there is an expected error, the value is
101: -- fnd_api.g_ret_sts_error;
102: -- if there is an unexpected error, the value is
103: -- fnd_api.g_ret_sts_unexp_error;
104: -- x_msg_count
105: -- if there is one or more errors, the number of error messages
106: -- in the buffer
107: -- x_msg_data
105: -- if there is one or more errors, the number of error messages
106: -- in the buffer
107: -- x_msg_data
108: -- if there is one and only one error, the error message
109: -- (See fnd_api package for more details about the above output parameters)
110:
111: --*/
112: PROCEDURE Update_Row
113: (
111: --*/
112: PROCEDURE Update_Row
113: (
114: p_api_version IN NUMBER ,
115: p_init_msg_list IN VARCHAR2 := fnd_api.g_false ,
116: p_commit IN VARCHAR2 := fnd_api.g_false ,
117: x_return_status OUT NOCOPY VARCHAR2 ,
118: x_msg_count OUT NOCOPY NUMBER ,
119: x_msg_data OUT NOCOPY VARCHAR2 ,
112: PROCEDURE Update_Row
113: (
114: p_api_version IN NUMBER ,
115: p_init_msg_list IN VARCHAR2 := fnd_api.g_false ,
116: p_commit IN VARCHAR2 := fnd_api.g_false ,
117: x_return_status OUT NOCOPY VARCHAR2 ,
118: x_msg_count OUT NOCOPY NUMBER ,
119: x_msg_data OUT NOCOPY VARCHAR2 ,
120: p_VENDOR_ID IN NUMBER,
136: --
137: -- Input Parameters
138: -- p_api_version
139: -- API version number (current version is 1.0)
140: -- p_init_msg_list (optional, default FND_API.G_FALSE)
141: -- Valid values: FND_API.G_FALSE or FND_API.G_TRUE.
142: -- if set to FND_API.G_TRUE
143: -- initialize error message list
144: -- if set to FND_API.G_FALSE - not initialize error
137: -- Input Parameters
138: -- p_api_version
139: -- API version number (current version is 1.0)
140: -- p_init_msg_list (optional, default FND_API.G_FALSE)
141: -- Valid values: FND_API.G_FALSE or FND_API.G_TRUE.
142: -- if set to FND_API.G_TRUE
143: -- initialize error message list
144: -- if set to FND_API.G_FALSE - not initialize error
145: -- message list
138: -- p_api_version
139: -- API version number (current version is 1.0)
140: -- p_init_msg_list (optional, default FND_API.G_FALSE)
141: -- Valid values: FND_API.G_FALSE or FND_API.G_TRUE.
142: -- if set to FND_API.G_TRUE
143: -- initialize error message list
144: -- if set to FND_API.G_FALSE - not initialize error
145: -- message list
146: -- p_commit (optional, default FND_API.G_FALSE)
140: -- p_init_msg_list (optional, default FND_API.G_FALSE)
141: -- Valid values: FND_API.G_FALSE or FND_API.G_TRUE.
142: -- if set to FND_API.G_TRUE
143: -- initialize error message list
144: -- if set to FND_API.G_FALSE - not initialize error
145: -- message list
146: -- p_commit (optional, default FND_API.G_FALSE)
147: -- whether or not to commit the changes to database
148: --
142: -- if set to FND_API.G_TRUE
143: -- initialize error message list
144: -- if set to FND_API.G_FALSE - not initialize error
145: -- message list
146: -- p_commit (optional, default FND_API.G_FALSE)
147: -- whether or not to commit the changes to database
148: --
149: -- Input parameters for clear cross users informations
150: -- p_ITM_USER_SEQUENCE_ID -- ITM Seq Id
152: --
153: -- Output Parameters
154: -- x_return_status
155: -- if the process succeeds, the value is
156: -- fnd_api.g_ret_sts_success;
157: -- if there is an expected error, the value is
158: -- fnd_api.g_ret_sts_error;
159: -- if there is an unexpected error, the value is
160: -- fnd_api.g_ret_sts_unexp_error;
154: -- x_return_status
155: -- if the process succeeds, the value is
156: -- fnd_api.g_ret_sts_success;
157: -- if there is an expected error, the value is
158: -- fnd_api.g_ret_sts_error;
159: -- if there is an unexpected error, the value is
160: -- fnd_api.g_ret_sts_unexp_error;
161: -- x_msg_count
162: -- if there is one or more errors, the number of error messages
156: -- fnd_api.g_ret_sts_success;
157: -- if there is an expected error, the value is
158: -- fnd_api.g_ret_sts_error;
159: -- if there is an unexpected error, the value is
160: -- fnd_api.g_ret_sts_unexp_error;
161: -- x_msg_count
162: -- if there is one or more errors, the number of error messages
163: -- in the buffer
164: -- x_msg_data
162: -- if there is one or more errors, the number of error messages
163: -- in the buffer
164: -- x_msg_data
165: -- if there is one and only one error, the error message
166: -- (See fnd_api package for more details about the above output parameters)
167:
168: --*/
169: PROCEDURE Delete_Row
170: (
168: --*/
169: PROCEDURE Delete_Row
170: (
171: p_api_version IN NUMBER ,
172: p_init_msg_list IN VARCHAR2 := fnd_api.g_false ,
173: p_commit IN VARCHAR2 := fnd_api.g_false ,
174: x_return_status OUT NOCOPY VARCHAR2 ,
175: x_msg_count OUT NOCOPY NUMBER ,
176: x_msg_data OUT NOCOPY VARCHAR2 ,
169: PROCEDURE Delete_Row
170: (
171: p_api_version IN NUMBER ,
172: p_init_msg_list IN VARCHAR2 := fnd_api.g_false ,
173: p_commit IN VARCHAR2 := fnd_api.g_false ,
174: x_return_status OUT NOCOPY VARCHAR2 ,
175: x_msg_count OUT NOCOPY NUMBER ,
176: x_msg_data OUT NOCOPY VARCHAR2 ,
177: p_ITM_USER_SEQUENCE_ID IN NUMBER
187: --
188: -- Input Parameters
189: -- p_api_version
190: -- API version number (current version is 1.0)
191: -- p_init_msg_list (optional, default FND_API.G_FALSE)
192: -- Valid values: FND_API.G_FALSE or FND_API.G_TRUE.
193: -- if set to FND_API.G_TRUE
194: -- initialize error message list
195: -- if set to FND_API.G_FALSE - not initialize error
188: -- Input Parameters
189: -- p_api_version
190: -- API version number (current version is 1.0)
191: -- p_init_msg_list (optional, default FND_API.G_FALSE)
192: -- Valid values: FND_API.G_FALSE or FND_API.G_TRUE.
193: -- if set to FND_API.G_TRUE
194: -- initialize error message list
195: -- if set to FND_API.G_FALSE - not initialize error
196: -- message list
189: -- p_api_version
190: -- API version number (current version is 1.0)
191: -- p_init_msg_list (optional, default FND_API.G_FALSE)
192: -- Valid values: FND_API.G_FALSE or FND_API.G_TRUE.
193: -- if set to FND_API.G_TRUE
194: -- initialize error message list
195: -- if set to FND_API.G_FALSE - not initialize error
196: -- message list
197: -- p_commit (optional, default FND_API.G_FALSE)
191: -- p_init_msg_list (optional, default FND_API.G_FALSE)
192: -- Valid values: FND_API.G_FALSE or FND_API.G_TRUE.
193: -- if set to FND_API.G_TRUE
194: -- initialize error message list
195: -- if set to FND_API.G_FALSE - not initialize error
196: -- message list
197: -- p_commit (optional, default FND_API.G_FALSE)
198: -- whether or not to commit the changes to database
199: --
193: -- if set to FND_API.G_TRUE
194: -- initialize error message list
195: -- if set to FND_API.G_FALSE - not initialize error
196: -- message list
197: -- p_commit (optional, default FND_API.G_FALSE)
198: -- whether or not to commit the changes to database
199: --
200: -- Input parameters for clear cross users informations
201: -- p_VENDOR_ID --Vendor Id
210: --
211: -- Output Parameters
212: -- x_return_status
213: -- if the process succeeds, the value is
214: -- fnd_api.g_ret_sts_success;
215: -- if there is an expected error, the value is
216: -- fnd_api.g_ret_sts_error;
217: -- if there is an unexpected error, the value is
218: -- fnd_api.g_ret_sts_unexp_error;
212: -- x_return_status
213: -- if the process succeeds, the value is
214: -- fnd_api.g_ret_sts_success;
215: -- if there is an expected error, the value is
216: -- fnd_api.g_ret_sts_error;
217: -- if there is an unexpected error, the value is
218: -- fnd_api.g_ret_sts_unexp_error;
219: -- x_msg_count
220: -- if there is one or more errors, the number of error messages
214: -- fnd_api.g_ret_sts_success;
215: -- if there is an expected error, the value is
216: -- fnd_api.g_ret_sts_error;
217: -- if there is an unexpected error, the value is
218: -- fnd_api.g_ret_sts_unexp_error;
219: -- x_msg_count
220: -- if there is one or more errors, the number of error messages
221: -- in the buffer
222: -- x_msg_data
220: -- if there is one or more errors, the number of error messages
221: -- in the buffer
222: -- x_msg_data
223: -- if there is one and only one error, the error message
224: -- (See fnd_api package for more details about the above output parameters)
225:
226: --*/
227: PROCEDURE Lock_Row
228: (
226: --*/
227: PROCEDURE Lock_Row
228: (
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 NOCOPY VARCHAR2 ,
233: x_msg_count OUT NOCOPY NUMBER ,
234: x_msg_data OUT NOCOPY VARCHAR2 ,
227: PROCEDURE Lock_Row
228: (
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 NOCOPY VARCHAR2 ,
233: x_msg_count OUT NOCOPY NUMBER ,
234: x_msg_data OUT NOCOPY VARCHAR2 ,
235: p_VENDOR_ID IN NUMBER,