DBA Data[Home] [Help]

APPS.WSH_ITM_PARAMETER_SETUPS_PKG dependencies on FND_API

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

10: -- Insert a row into WSH_ITM_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

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
24: -- P_PARAMETER_NAME Internal Name for the Parameter.

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:

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

47:
48:
49: procedure INSERT_ROW (
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:
49: procedure INSERT_ROW (
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_PARAMETER_ID OUT NOCOPY NUMBER ,

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

71: -- Check Lock a row of WSH_ITM_PARAMETER_SETUPS_TL entity.
72: -- Input Parameters
73: -- p_api_version
74: -- API version number (current version is 1.0)
75: -- p_init_msg_list (optional, default FND_API.G_FALSE)
76: -- Valid values: FND_API.G_FALSE or FND_API.G_TRUE.
77: -- if set to FND_API.G_TRUE
78: -- initialize error message list
79: -- if set to FND_API.G_FALSE - not initialize error

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

72: -- Input Parameters
73: -- p_api_version
74: -- API version number (current version is 1.0)
75: -- p_init_msg_list (optional, default FND_API.G_FALSE)
76: -- Valid values: FND_API.G_FALSE or FND_API.G_TRUE.
77: -- if set to FND_API.G_TRUE
78: -- initialize error message list
79: -- if set to FND_API.G_FALSE - not initialize error
80: -- message list

Line 77: -- if set to FND_API.G_TRUE

73: -- p_api_version
74: -- API version number (current version is 1.0)
75: -- p_init_msg_list (optional, default FND_API.G_FALSE)
76: -- Valid values: FND_API.G_FALSE or FND_API.G_TRUE.
77: -- if set to FND_API.G_TRUE
78: -- initialize error message list
79: -- if set to FND_API.G_FALSE - not initialize error
80: -- message list
81: -- p_commit (optional, default FND_API.G_FALSE)

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

75: -- p_init_msg_list (optional, default FND_API.G_FALSE)
76: -- Valid values: FND_API.G_FALSE or FND_API.G_TRUE.
77: -- if set to FND_API.G_TRUE
78: -- initialize error message list
79: -- if set to FND_API.G_FALSE - not initialize error
80: -- message list
81: -- p_commit (optional, default FND_API.G_FALSE)
82: -- whether or not to commit the changes to database
83: --

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

77: -- if set to FND_API.G_TRUE
78: -- initialize error message list
79: -- if set to FND_API.G_FALSE - not initialize error
80: -- message list
81: -- p_commit (optional, default FND_API.G_FALSE)
82: -- whether or not to commit the changes to database
83: --
84: -- Input parameters
85: --

Line 97: -- fnd_api.g_ret_sts_success;

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;

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

Line 101: -- fnd_api.g_ret_sts_unexp_error;

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

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

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 LOCK_ROW (
111: p_api_version IN NUMBER ,

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

108:
109: --*/
110: procedure LOCK_ROW (
111: p_api_version IN NUMBER ,
112: p_init_msg_list IN VARCHAR2 := fnd_api.g_false ,
113: p_commit IN VARCHAR2 := fnd_api.g_false ,
114: x_return_status OUT NOCOPY VARCHAR2 ,
115: x_msg_count OUT NOCOPY NUMBER ,
116: x_msg_data OUT NOCOPY VARCHAR2 ,

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

109: --*/
110: procedure LOCK_ROW (
111: p_api_version IN NUMBER ,
112: p_init_msg_list IN VARCHAR2 := fnd_api.g_false ,
113: p_commit IN VARCHAR2 := fnd_api.g_false ,
114: x_return_status OUT NOCOPY VARCHAR2 ,
115: x_msg_count OUT NOCOPY NUMBER ,
116: x_msg_data OUT NOCOPY VARCHAR2 ,
117: P_PARAMETER_ID IN NUMBER,

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

132: -- Update a row into WSH_ITM_parameter_setups_tl entity
133: -- Input Parameters
134: -- p_api_version
135: -- API version number (current version is 1.0)
136: -- p_init_msg_list (optional, default FND_API.G_FALSE)
137: -- Valid values: FND_API.G_FALSE or FND_API.G_TRUE.
138: -- if set to FND_API.G_TRUE
139: -- initialize error message list
140: -- if set to FND_API.G_FALSE - not initialize error

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

133: -- Input Parameters
134: -- p_api_version
135: -- API version number (current version is 1.0)
136: -- p_init_msg_list (optional, default FND_API.G_FALSE)
137: -- Valid values: FND_API.G_FALSE or FND_API.G_TRUE.
138: -- if set to FND_API.G_TRUE
139: -- initialize error message list
140: -- if set to FND_API.G_FALSE - not initialize error
141: -- message list

Line 138: -- if set to FND_API.G_TRUE

134: -- p_api_version
135: -- API version number (current version is 1.0)
136: -- p_init_msg_list (optional, default FND_API.G_FALSE)
137: -- Valid values: FND_API.G_FALSE or FND_API.G_TRUE.
138: -- if set to FND_API.G_TRUE
139: -- initialize error message list
140: -- if set to FND_API.G_FALSE - not initialize error
141: -- message list
142: -- p_commit (optional, default FND_API.G_FALSE)

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

136: -- p_init_msg_list (optional, default FND_API.G_FALSE)
137: -- Valid values: FND_API.G_FALSE or FND_API.G_TRUE.
138: -- if set to FND_API.G_TRUE
139: -- initialize error message list
140: -- if set to FND_API.G_FALSE - not initialize error
141: -- message list
142: -- p_commit (optional, default FND_API.G_FALSE)
143: -- whether or not to commit the changes to database
144: --

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

138: -- if set to FND_API.G_TRUE
139: -- initialize error message list
140: -- if set to FND_API.G_FALSE - not initialize error
141: -- message list
142: -- p_commit (optional, default FND_API.G_FALSE)
143: -- whether or not to commit the changes to database
144: --
145: -- Input parameters
146: -- P_PARAMETER_ID Parameter ID.

Line 157: -- fnd_api.g_ret_sts_success;

153: --
154: -- Output Parameters
155: -- x_return_status
156: -- if the process succeeds, the value is
157: -- fnd_api.g_ret_sts_success;
158: -- if there is an expected error, the value is
159: -- fnd_api.g_ret_sts_error;
160: -- if there is an unexpected error, the value is
161: -- fnd_api.g_ret_sts_unexp_error;

Line 159: -- fnd_api.g_ret_sts_error;

155: -- x_return_status
156: -- if the process succeeds, the value is
157: -- fnd_api.g_ret_sts_success;
158: -- if there is an expected error, the value is
159: -- fnd_api.g_ret_sts_error;
160: -- if there is an unexpected error, the value is
161: -- fnd_api.g_ret_sts_unexp_error;
162: -- x_msg_count
163: -- if there is one or more errors, the number of error messages

Line 161: -- fnd_api.g_ret_sts_unexp_error;

157: -- fnd_api.g_ret_sts_success;
158: -- if there is an expected error, the value is
159: -- fnd_api.g_ret_sts_error;
160: -- if there is an unexpected error, the value is
161: -- fnd_api.g_ret_sts_unexp_error;
162: -- x_msg_count
163: -- if there is one or more errors, the number of error messages
164: -- in the buffer
165: -- x_msg_data

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

163: -- if there is one or more errors, the number of error messages
164: -- in the buffer
165: -- x_msg_data
166: -- if there is one and only one error, the error message
167: -- (See fnd_api package for more details about the above output parameters)
168: --*/
169:
170:
171:

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

170:
171:
172: procedure UPDATE_ROW (
173: p_api_version IN NUMBER ,
174: p_init_msg_list IN VARCHAR2 := fnd_api.g_false,
175: p_commit IN VARCHAR2 := fnd_api.g_false,
176: x_return_status OUT NOCOPY VARCHAR2 ,
177: x_msg_count OUT NOCOPY NUMBER ,
178: x_msg_data OUT NOCOPY VARCHAR2 ,

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

171:
172: procedure UPDATE_ROW (
173: p_api_version IN NUMBER ,
174: p_init_msg_list IN VARCHAR2 := fnd_api.g_false,
175: p_commit IN VARCHAR2 := fnd_api.g_false,
176: x_return_status OUT NOCOPY VARCHAR2 ,
177: x_msg_count OUT NOCOPY NUMBER ,
178: x_msg_data OUT NOCOPY VARCHAR2 ,
179: P_PARAMETER_ID IN NUMBER ,

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

194: -- Delete a row from WSH_ITM_parameter_setups_tl entity
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

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

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

Line 200: -- if set to FND_API.G_TRUE

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)

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

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

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

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: --
208: -- Output Parameters

Line 211: -- fnd_api.g_ret_sts_success;

207: --
208: -- Output Parameters
209: -- x_return_status
210: -- if the process succeeds, the value is
211: -- fnd_api.g_ret_sts_success;
212: -- if there is an expected error, the value is
213: -- fnd_api.g_ret_sts_error;
214: -- if there is an unexpected error, the value is
215: -- fnd_api.g_ret_sts_unexp_error;

Line 213: -- fnd_api.g_ret_sts_error;

209: -- x_return_status
210: -- if the process succeeds, the value is
211: -- fnd_api.g_ret_sts_success;
212: -- if there is an expected error, the value is
213: -- fnd_api.g_ret_sts_error;
214: -- if there is an unexpected error, the value is
215: -- fnd_api.g_ret_sts_unexp_error;
216: -- x_msg_count
217: -- if there is one or more errors, the number of error messages

Line 215: -- fnd_api.g_ret_sts_unexp_error;

211: -- fnd_api.g_ret_sts_success;
212: -- if there is an expected error, the value is
213: -- fnd_api.g_ret_sts_error;
214: -- if there is an unexpected error, the value is
215: -- fnd_api.g_ret_sts_unexp_error;
216: -- x_msg_count
217: -- if there is one or more errors, the number of error messages
218: -- in the buffer
219: -- x_msg_data

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

217: -- if there is one or more errors, the number of error messages
218: -- in the buffer
219: -- x_msg_data
220: -- if there is one and only one error, the error message
221: -- (See fnd_api package for more details about the above output parameters)
222: --*/
223:
224: procedure DELETE_ROW (
225: p_api_version IN NUMBER ,

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

222: --*/
223:
224: procedure DELETE_ROW (
225: p_api_version IN NUMBER ,
226: p_init_msg_list IN VARCHAR2 := fnd_api.g_false ,
227: p_commit IN VARCHAR2 := fnd_api.g_false ,
228: x_return_status OUT NOCOPY VARCHAR2 ,
229: x_msg_count OUT NOCOPY NUMBER ,
230: x_msg_data OUT NOCOPY VARCHAR2 ,

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

223:
224: procedure DELETE_ROW (
225: p_api_version IN NUMBER ,
226: p_init_msg_list IN VARCHAR2 := fnd_api.g_false ,
227: p_commit IN VARCHAR2 := fnd_api.g_false ,
228: x_return_status OUT NOCOPY VARCHAR2 ,
229: x_msg_count OUT NOCOPY NUMBER ,
230: x_msg_data OUT NOCOPY VARCHAR2 ,
231: P_PARAMETER_ID IN NUMBER