DBA Data[Home] [Help]

APPS.WSH_CC_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_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

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 parameters information
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: -- p_PARAMETER_ID - Clear Cross sequence Id ( PK)
46:
47: --*/
48:

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

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 ,

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

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 ,

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

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

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 parameter setups information
86: --

Line 98: -- fnd_api.g_ret_sts_success;

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;

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

Line 102: -- fnd_api.g_ret_sts_unexp_error;

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

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

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 ,

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

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 ,

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

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,

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

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

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

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

Line 139: -- if set to FND_API.G_TRUE

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)

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

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

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

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.

Line 158: -- fnd_api.g_ret_sts_success;

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;

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

Line 162: -- fnd_api.g_ret_sts_unexp_error;

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

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

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:

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

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 ,

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

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 ,

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

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

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

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

Line 201: -- if set to FND_API.G_TRUE

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)

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

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

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

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)

Line 215: -- fnd_api.g_ret_sts_success;

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;

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

Line 219: -- fnd_api.g_ret_sts_unexp_error;

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

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

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 ,

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

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 ,

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

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