DBA Data[Home] [Help]

APPS.WSH_ITM_USERS_PKG dependencies on FND_API

Line 14: -- p_init_msg_list (optional, default FND_API.G_FALSE)

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

Line 15: -- Valid values: FND_API.G_FALSE or FND_API.G_TRUE.

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

Line 16: -- if set to FND_API.G_TRUE

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)

Line 18: -- if set to FND_API.G_FALSE - not initialize error

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: --

Line 20: -- p_commit (optional, default FND_API.G_FALSE)

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

Line 34: -- fnd_api.g_ret_sts_success;

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;

Line 36: -- fnd_api.g_ret_sts_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

Line 38: -- fnd_api.g_ret_sts_unexp_error;

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

Line 44: -- (See fnd_api package for more details about the above output parameters)

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

Line 51: p_init_msg_list IN VARCHAR2 := fnd_api.g_false ,

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 ,

Line 52: p_commit IN VARCHAR2 := fnd_api.g_false ,

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,

Line 76: -- p_init_msg_list (optional, default FND_API.G_FALSE)

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

Line 77: -- Valid values: FND_API.G_FALSE or FND_API.G_TRUE.

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

Line 78: -- if set to FND_API.G_TRUE

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)

Line 80: -- if set to FND_API.G_FALSE - not initialize error

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: --

Line 82: -- p_commit (optional, default FND_API.G_FALSE)

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

Line 99: -- fnd_api.g_ret_sts_success;

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;

Line 101: -- fnd_api.g_ret_sts_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

Line 103: -- fnd_api.g_ret_sts_unexp_error;

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

Line 109: -- (See fnd_api package for more details about the above output parameters)

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: (

Line 115: p_init_msg_list IN VARCHAR2 := fnd_api.g_false ,

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 ,

Line 116: p_commit IN VARCHAR2 := fnd_api.g_false ,

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,

Line 140: -- p_init_msg_list (optional, default FND_API.G_FALSE)

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

Line 141: -- Valid values: FND_API.G_FALSE or FND_API.G_TRUE.

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

Line 142: -- if set to FND_API.G_TRUE

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)

Line 144: -- if set to FND_API.G_FALSE - not initialize error

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: --

Line 146: -- p_commit (optional, default FND_API.G_FALSE)

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

Line 156: -- fnd_api.g_ret_sts_success;

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;

Line 158: -- fnd_api.g_ret_sts_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

Line 160: -- fnd_api.g_ret_sts_unexp_error;

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

Line 166: -- (See fnd_api package for more details about the above output parameters)

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: (

Line 172: p_init_msg_list IN VARCHAR2 := fnd_api.g_false ,

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 ,

Line 173: p_commit IN VARCHAR2 := fnd_api.g_false ,

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

Line 191: -- p_init_msg_list (optional, default FND_API.G_FALSE)

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

Line 192: -- Valid values: FND_API.G_FALSE or FND_API.G_TRUE.

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

Line 193: -- if set to FND_API.G_TRUE

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)

Line 195: -- if set to FND_API.G_FALSE - not initialize error

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: --

Line 197: -- p_commit (optional, default FND_API.G_FALSE)

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

Line 214: -- fnd_api.g_ret_sts_success;

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;

Line 216: -- fnd_api.g_ret_sts_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

Line 218: -- fnd_api.g_ret_sts_unexp_error;

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

Line 224: -- (See fnd_api package for more details about the above output parameters)

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: (

Line 230: p_init_msg_list IN VARCHAR2 := fnd_api.g_false ,

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 ,

Line 231: p_commit IN VARCHAR2 := fnd_api.g_false ,

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,