DBA Data[Home] [Help]

APPS.WSH_CC_SERVICE_SETUPS_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 service setup informations
24: --

Line 28: -- fnd_api.g_ret_sts_success;

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;

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

Line 32: -- fnd_api.g_ret_sts_unexp_error;

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

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

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:

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

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 ,

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

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,

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

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

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

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

Line 84: -- if set to FND_API.G_TRUE

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)

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

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

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

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

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

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

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 ,

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

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,

Line 120: p_ORGANIZATION_ID IN NUMBER default fnd_api.g_miss_num,

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,

Line 121: p_APPLICATION_USER_ID IN NUMBER default fnd_api.g_miss_num,

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,

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

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

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

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

Line 151: -- if set to FND_API.G_TRUE

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)

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

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

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

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)

Line 165: -- fnd_api.g_ret_sts_success;

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;

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

Line 169: -- fnd_api.g_ret_sts_unexp_error;

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

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

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

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

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 ,

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

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

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

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

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: -- Input parameters for clear cross service setups informations
208: --

Line 213: -- fnd_api.g_ret_sts_success;

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;

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

Line 217: -- fnd_api.g_ret_sts_unexp_error;

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

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

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

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

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 ,

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

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,

Line 236: p_ORGANIZATION_ID IN NUMBER default fnd_api.g_miss_num,

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,

Line 237: p_APPLICATION_USER_ID IN NUMBER default fnd_api.g_miss_num,

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,