DBA Data[Home] [Help]

APPS.WSH_CC_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: -- p_CC_USER_SEQUENCE_ID - Clear Cross sequence Id ( PK)
46:
47: --*/
48:

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

48:
49: PROCEDURE Insert_Row
50: (
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: PROCEDURE Insert_Row
50: (
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_APPLICATION_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_APPLICATION_ID --Application_id added.

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

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

110:
111: PROCEDURE Update_Row
112: (
113: p_api_version IN NUMBER ,
114: p_init_msg_list IN VARCHAR2 := fnd_api.g_false ,
115: p_commit IN VARCHAR2 := fnd_api.g_false ,
116: x_return_status OUT VARCHAR2 ,
117: x_msg_count OUT NUMBER ,
118: x_msg_data OUT VARCHAR2 ,

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

111: PROCEDURE Update_Row
112: (
113: p_api_version IN NUMBER ,
114: p_init_msg_list IN VARCHAR2 := fnd_api.g_false ,
115: p_commit IN VARCHAR2 := fnd_api.g_false ,
116: x_return_status OUT VARCHAR2 ,
117: x_msg_count OUT NUMBER ,
118: x_msg_data OUT VARCHAR2 ,
119: p_APPLICATION_ID IN NUMBER,

Line 121: p_ORGANIZATION_ID IN NUMBER default fnd_api.g_miss_num,

117: x_msg_count OUT NUMBER ,
118: x_msg_data OUT VARCHAR2 ,
119: p_APPLICATION_ID IN NUMBER,
120: p_MASTER_ORGANIZATION_ID IN NUMBER,
121: p_ORGANIZATION_ID IN NUMBER default fnd_api.g_miss_num,
122: p_APPLICATION_USER_ID IN NUMBER default fnd_api.g_miss_num,
123: p_CC_USER_ID IN VARCHAR2,
124: p_ENCRYPTED_USER_PASSWORD IN VARCHAR2,
125: p_CC_USER_SEQUENCE_ID IN NUMBER

Line 122: p_APPLICATION_USER_ID IN NUMBER default fnd_api.g_miss_num,

118: x_msg_data OUT VARCHAR2 ,
119: p_APPLICATION_ID IN NUMBER,
120: p_MASTER_ORGANIZATION_ID IN NUMBER,
121: p_ORGANIZATION_ID IN NUMBER default fnd_api.g_miss_num,
122: p_APPLICATION_USER_ID IN NUMBER default fnd_api.g_miss_num,
123: p_CC_USER_ID IN VARCHAR2,
124: p_ENCRYPTED_USER_PASSWORD IN VARCHAR2,
125: p_CC_USER_SEQUENCE_ID IN NUMBER
126: ) ;

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

133: --
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 Users Informations
147: -- p_CC_USER_SEQUENCE_ID - Seq Id (PK)

Line 153: -- fnd_api.g_ret_sts_success;

149: --
150: -- Output Parameters
151: -- x_return_status
152: -- if the process succeeds, the value is
153: -- fnd_api.g_ret_sts_success;
154: -- if there is an expected error, the value is
155: -- fnd_api.g_ret_sts_error;
156: -- if there is an unexpected error, the value is
157: -- fnd_api.g_ret_sts_unexp_error;

Line 155: -- fnd_api.g_ret_sts_error;

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

Line 157: -- fnd_api.g_ret_sts_unexp_error;

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

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

159: -- if there is one or more errors, the number of error messages
160: -- in the buffer
161: -- x_msg_data
162: -- if there is one and only one error, the error message
163: -- (See fnd_api package for more details about the above output parameters)
164: --*/
165:
166: PROCEDURE Delete_Row
167: (

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

165:
166: PROCEDURE Delete_Row
167: (
168: p_api_version IN NUMBER ,
169: p_init_msg_list IN VARCHAR2 := fnd_api.g_false ,
170: p_commit IN VARCHAR2 := fnd_api.g_false ,
171: x_return_status OUT VARCHAR2 ,
172: x_msg_count OUT NUMBER ,
173: x_msg_data OUT VARCHAR2 ,

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

166: PROCEDURE Delete_Row
167: (
168: p_api_version IN NUMBER ,
169: p_init_msg_list IN VARCHAR2 := fnd_api.g_false ,
170: p_commit IN VARCHAR2 := fnd_api.g_false ,
171: x_return_status OUT VARCHAR2 ,
172: x_msg_count OUT NUMBER ,
173: x_msg_data OUT VARCHAR2 ,
174: p_CC_USER_SEQUENCE_ID IN NUMBER

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

182: --
183: -- Input Parameters
184: -- p_api_version
185: -- API version number (current version is 1.0)
186: -- p_init_msg_list (optional, default FND_API.G_FALSE)
187: -- Valid values: FND_API.G_FALSE or FND_API.G_TRUE.
188: -- if set to FND_API.G_TRUE
189: -- initialize error message list
190: -- if set to FND_API.G_FALSE - not initialize error

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

183: -- Input Parameters
184: -- p_api_version
185: -- API version number (current version is 1.0)
186: -- p_init_msg_list (optional, default FND_API.G_FALSE)
187: -- Valid values: FND_API.G_FALSE or FND_API.G_TRUE.
188: -- if set to FND_API.G_TRUE
189: -- initialize error message list
190: -- if set to FND_API.G_FALSE - not initialize error
191: -- message list

Line 188: -- if set to FND_API.G_TRUE

184: -- p_api_version
185: -- API version number (current version is 1.0)
186: -- p_init_msg_list (optional, default FND_API.G_FALSE)
187: -- Valid values: FND_API.G_FALSE or FND_API.G_TRUE.
188: -- if set to FND_API.G_TRUE
189: -- initialize error message list
190: -- if set to FND_API.G_FALSE - not initialize error
191: -- message list
192: -- p_commit (optional, default FND_API.G_FALSE)

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

186: -- p_init_msg_list (optional, default FND_API.G_FALSE)
187: -- Valid values: FND_API.G_FALSE or FND_API.G_TRUE.
188: -- if set to FND_API.G_TRUE
189: -- initialize error message list
190: -- if set to FND_API.G_FALSE - not initialize error
191: -- message list
192: -- p_commit (optional, default FND_API.G_FALSE)
193: -- whether or not to commit the changes to database
194: --

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

188: -- if set to FND_API.G_TRUE
189: -- initialize error message list
190: -- if set to FND_API.G_FALSE - not initialize error
191: -- message list
192: -- p_commit (optional, default FND_API.G_FALSE)
193: -- whether or not to commit the changes to database
194: --
195: -- Input parameters for clear cross users informations
196: -- p_APPLICATION_ID --Application ID added.

Line 208: -- fnd_api.g_ret_sts_success;

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

Line 210: -- fnd_api.g_ret_sts_error;

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

Line 212: -- fnd_api.g_ret_sts_unexp_error;

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

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

214: -- if there is one or more errors, the number of error messages
215: -- in the buffer
216: -- x_msg_data
217: -- if there is one and only one error, the error message
218: -- (See fnd_api package for more details about the above output parameters)
219:
220: --*/
221: PROCEDURE Lock_Row
222: (

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

220: --*/
221: PROCEDURE Lock_Row
222: (
223: p_api_version IN NUMBER ,
224: p_init_msg_list IN VARCHAR2 := fnd_api.g_false ,
225: p_commit IN VARCHAR2 := fnd_api.g_false ,
226: x_return_status OUT VARCHAR2 ,
227: x_msg_count OUT NUMBER ,
228: x_msg_data OUT VARCHAR2 ,

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

221: PROCEDURE Lock_Row
222: (
223: p_api_version IN NUMBER ,
224: p_init_msg_list IN VARCHAR2 := fnd_api.g_false ,
225: p_commit IN VARCHAR2 := fnd_api.g_false ,
226: x_return_status OUT VARCHAR2 ,
227: x_msg_count OUT NUMBER ,
228: x_msg_data OUT VARCHAR2 ,
229: p_APPLICATION_ID IN NUMBER,

Line 231: p_ORGANIZATION_ID IN NUMBER default fnd_api.g_miss_num,

227: x_msg_count OUT NUMBER ,
228: x_msg_data OUT VARCHAR2 ,
229: p_APPLICATION_ID IN NUMBER,
230: p_MASTER_ORGANIZATION_ID IN NUMBER,
231: p_ORGANIZATION_ID IN NUMBER default fnd_api.g_miss_num,
232: p_APPLICATION_USER_ID IN NUMBER default fnd_api.g_miss_num,
233: p_CC_USER_ID IN VARCHAR2,
234: p_ENCRYPTED_USER_PASSWORD IN VARCHAR2,
235: p_CC_USER_SEQUENCE_ID IN NUMBER,

Line 232: p_APPLICATION_USER_ID IN NUMBER default fnd_api.g_miss_num,

228: x_msg_data OUT VARCHAR2 ,
229: p_APPLICATION_ID IN NUMBER,
230: p_MASTER_ORGANIZATION_ID IN NUMBER,
231: p_ORGANIZATION_ID IN NUMBER default fnd_api.g_miss_num,
232: p_APPLICATION_USER_ID IN NUMBER default fnd_api.g_miss_num,
233: p_CC_USER_ID IN VARCHAR2,
234: p_ENCRYPTED_USER_PASSWORD IN VARCHAR2,
235: p_CC_USER_SEQUENCE_ID IN NUMBER,
236: p_rowid IN VARCHAR2