eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.WSH_CC_REQUEST_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 request 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_REQUEST_SEQUENCE_ID - Clear Cross Request 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 79: -- p_init_msg_list (optional, default FND_API.G_FALSE)

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

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

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

Line 81: -- if set to FND_API.G_TRUE

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

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

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

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

81: -- if set to FND_API.G_TRUE
82: -- initialize error message list
83: -- if set to FND_API.G_FALSE - not initialize error
84: -- message list
85: -- p_commit (optional, default FND_API.G_FALSE)
86: -- whether or not to commit the changes to database
87: --
88: -- Input parameters for Clear Cross Request Setups Informations
89: --

Line 94: -- fnd_api.g_ret_sts_success;

90: --
91: -- Output Parameters
92: -- x_return_status
93: -- if the process succeeds, the value is
94: -- fnd_api.g_ret_sts_success;
95: -- if there is an expected error, the value is
96: -- fnd_api.g_ret_sts_error;
97: -- if there is an unexpected error, the value is
98: -- fnd_api.g_ret_sts_unexp_error;

Line 96: -- fnd_api.g_ret_sts_error;

92: -- x_return_status
93: -- if the process succeeds, the value is
94: -- fnd_api.g_ret_sts_success;
95: -- if there is an expected error, the value is
96: -- fnd_api.g_ret_sts_error;
97: -- if there is an unexpected error, the value is
98: -- fnd_api.g_ret_sts_unexp_error;
99: -- x_msg_count
100: -- if there is one or more errors, the number of error messages

Line 98: -- fnd_api.g_ret_sts_unexp_error;

94: -- fnd_api.g_ret_sts_success;
95: -- if there is an expected error, the value is
96: -- fnd_api.g_ret_sts_error;
97: -- if there is an unexpected error, the value is
98: -- fnd_api.g_ret_sts_unexp_error;
99: -- x_msg_count
100: -- if there is one or more errors, the number of error messages
101: -- in the buffer
102: -- x_msg_data

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

100: -- if there is one or more errors, the number of error messages
101: -- in the buffer
102: -- x_msg_data
103: -- if there is one and only one error, the error message
104: -- (See fnd_api package for more details about the above output parameters)
105: --*/
106:
107: PROCEDURE Update_Row
108: (

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

106:
107: PROCEDURE Update_Row
108: (
109: p_api_version IN NUMBER ,
110: p_init_msg_list IN VARCHAR2 := fnd_api.g_false ,
111: p_commit IN VARCHAR2 := fnd_api.g_false ,
112: x_return_status OUT VARCHAR2 ,
113: x_msg_count OUT NUMBER ,
114: x_msg_data OUT VARCHAR2 ,

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

107: PROCEDURE Update_Row
108: (
109: p_api_version IN NUMBER ,
110: p_init_msg_list IN VARCHAR2 := fnd_api.g_false ,
111: p_commit IN VARCHAR2 := fnd_api.g_false ,
112: x_return_status OUT VARCHAR2 ,
113: x_msg_count OUT NUMBER ,
114: x_msg_data OUT VARCHAR2 ,
115: p_APPLICATION_ID IN NUMBER,

Line 117: p_ORGANIZATION_ID IN NUMBER default fnd_api.g_miss_num,

113: x_msg_count OUT NUMBER ,
114: x_msg_data OUT VARCHAR2 ,
115: p_APPLICATION_ID IN NUMBER,
116: p_MASTER_ORGANIZATION_ID IN NUMBER,
117: p_ORGANIZATION_ID IN NUMBER default fnd_api.g_miss_num,
118: p_APPLICATION_USER_ID IN NUMBER default fnd_api.g_miss_num,
119: p_REQUEST_TYPE_CODE IN VARCHAR2,
120: p_REQUEST_VERSION IN VARCHAR2,
121: p_REQUEST_LANGUAGE IN VARCHAR2,

Line 118: p_APPLICATION_USER_ID IN NUMBER default fnd_api.g_miss_num,

114: x_msg_data OUT VARCHAR2 ,
115: p_APPLICATION_ID IN NUMBER,
116: p_MASTER_ORGANIZATION_ID IN NUMBER,
117: p_ORGANIZATION_ID IN NUMBER default fnd_api.g_miss_num,
118: p_APPLICATION_USER_ID IN NUMBER default fnd_api.g_miss_num,
119: p_REQUEST_TYPE_CODE IN VARCHAR2,
120: p_REQUEST_VERSION IN VARCHAR2,
121: p_REQUEST_LANGUAGE IN VARCHAR2,
122: p_REQUEST_DATE_FORMAT IN VARCHAR2,

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

139: --
140: -- Input Parameters
141: -- p_api_version
142: -- API version number (current version is 1.0)
143: -- p_init_msg_list (optional, default FND_API.G_FALSE)
144: -- Valid values: FND_API.G_FALSE or FND_API.G_TRUE.
145: -- if set to FND_API.G_TRUE
146: -- initialize error message list
147: -- if set to FND_API.G_FALSE - not initialize error

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

140: -- Input Parameters
141: -- p_api_version
142: -- API version number (current version is 1.0)
143: -- p_init_msg_list (optional, default FND_API.G_FALSE)
144: -- Valid values: FND_API.G_FALSE or FND_API.G_TRUE.
145: -- if set to FND_API.G_TRUE
146: -- initialize error message list
147: -- if set to FND_API.G_FALSE - not initialize error
148: -- message list

Line 145: -- if set to FND_API.G_TRUE

141: -- p_api_version
142: -- API version number (current version is 1.0)
143: -- p_init_msg_list (optional, default FND_API.G_FALSE)
144: -- Valid values: FND_API.G_FALSE or FND_API.G_TRUE.
145: -- if set to FND_API.G_TRUE
146: -- initialize error message list
147: -- if set to FND_API.G_FALSE - not initialize error
148: -- message list
149: -- p_commit (optional, default FND_API.G_FALSE)

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

143: -- p_init_msg_list (optional, default FND_API.G_FALSE)
144: -- Valid values: FND_API.G_FALSE or FND_API.G_TRUE.
145: -- if set to FND_API.G_TRUE
146: -- initialize error message list
147: -- if set to FND_API.G_FALSE - not initialize error
148: -- message list
149: -- p_commit (optional, default FND_API.G_FALSE)
150: -- whether or not to commit the changes to database
151: --

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

145: -- if set to FND_API.G_TRUE
146: -- initialize error message list
147: -- if set to FND_API.G_FALSE - not initialize error
148: -- message list
149: -- p_commit (optional, default FND_API.G_FALSE)
150: -- whether or not to commit the changes to database
151: --
152: -- Input parameters for Clear Cross Users Informations
153: -- p_CC_REQUEST_SEQUENCE_ID - Seq Id (PK)

Line 159: -- fnd_api.g_ret_sts_success;

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

Line 161: -- fnd_api.g_ret_sts_error;

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

Line 163: -- fnd_api.g_ret_sts_unexp_error;

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

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

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

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

171:
172: PROCEDURE Delete_Row
173: (
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: PROCEDURE Delete_Row
173: (
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_CC_REQUEST_SEQUENCE_ID IN NUMBER

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

188: --
189: -- Input Parameters
190: -- p_api_version
191: -- API version number (current version is 1.0)
192: -- p_init_msg_list (optional, default FND_API.G_FALSE)
193: -- Valid values: FND_API.G_FALSE or FND_API.G_TRUE.
194: -- if set to FND_API.G_TRUE
195: -- initialize error message list
196: -- if set to FND_API.G_FALSE - not initialize error

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

189: -- Input Parameters
190: -- p_api_version
191: -- API version number (current version is 1.0)
192: -- p_init_msg_list (optional, default FND_API.G_FALSE)
193: -- Valid values: FND_API.G_FALSE or FND_API.G_TRUE.
194: -- if set to FND_API.G_TRUE
195: -- initialize error message list
196: -- if set to FND_API.G_FALSE - not initialize error
197: -- message list

Line 194: -- if set to FND_API.G_TRUE

190: -- p_api_version
191: -- API version number (current version is 1.0)
192: -- p_init_msg_list (optional, default FND_API.G_FALSE)
193: -- Valid values: FND_API.G_FALSE or FND_API.G_TRUE.
194: -- if set to FND_API.G_TRUE
195: -- initialize error message list
196: -- if set to FND_API.G_FALSE - not initialize error
197: -- message list
198: -- p_commit (optional, default FND_API.G_FALSE)

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

192: -- p_init_msg_list (optional, default FND_API.G_FALSE)
193: -- Valid values: FND_API.G_FALSE or FND_API.G_TRUE.
194: -- if set to FND_API.G_TRUE
195: -- initialize error message list
196: -- if set to FND_API.G_FALSE - not initialize error
197: -- message list
198: -- p_commit (optional, default FND_API.G_FALSE)
199: -- whether or not to commit the changes to database
200: --

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

194: -- if set to FND_API.G_TRUE
195: -- initialize error message list
196: -- if set to FND_API.G_FALSE - not initialize error
197: -- message list
198: -- p_commit (optional, default FND_API.G_FALSE)
199: -- whether or not to commit the changes to database
200: --
201: -- Input parameters for clear cross request setups informations
202: --

Line 207: -- fnd_api.g_ret_sts_success;

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

Line 209: -- fnd_api.g_ret_sts_error;

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

Line 211: -- fnd_api.g_ret_sts_unexp_error;

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

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

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

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

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

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

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

Line 230: p_ORGANIZATION_ID IN NUMBER default fnd_api.g_miss_num,

226: x_msg_count OUT NUMBER ,
227: x_msg_data OUT VARCHAR2 ,
228: p_APPLICATION_ID IN NUMBER,
229: p_MASTER_ORGANIZATION_ID IN NUMBER,
230: p_ORGANIZATION_ID IN NUMBER default fnd_api.g_miss_num,
231: p_APPLICATION_USER_ID IN NUMBER default fnd_api.g_miss_num,
232: p_REQUEST_TYPE_CODE IN VARCHAR2,
233: p_REQUEST_VERSION IN VARCHAR2,
234: p_REQUEST_LANGUAGE IN VARCHAR2,

Line 231: p_APPLICATION_USER_ID IN NUMBER default fnd_api.g_miss_num,

227: x_msg_data OUT VARCHAR2 ,
228: p_APPLICATION_ID IN NUMBER,
229: p_MASTER_ORGANIZATION_ID IN NUMBER,
230: p_ORGANIZATION_ID IN NUMBER default fnd_api.g_miss_num,
231: p_APPLICATION_USER_ID IN NUMBER default fnd_api.g_miss_num,
232: p_REQUEST_TYPE_CODE IN VARCHAR2,
233: p_REQUEST_VERSION IN VARCHAR2,
234: p_REQUEST_LANGUAGE IN VARCHAR2,
235: p_REQUEST_DATE_FORMAT IN VARCHAR2,