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.QA_DEVICE_PUB dependencies on FND_API

Line 46: -- Default is fnd_api.g_false.

42: --
43: -- p_init_msg_list VARCHAR2
44: -- Standard api parameter. Indicates whether to
45: -- re-initialize the message list.
46: -- Default is fnd_api.g_false.
47: --
48: -- p_validation_level NUMBER
49: -- Standard api parameter. Indicates validation level.
50: -- Use the default fnd_api.g_valid_level_full.

Line 50: -- Use the default fnd_api.g_valid_level_full.

46: -- Default is fnd_api.g_false.
47: --
48: -- p_validation_level NUMBER
49: -- Standard api parameter. Indicates validation level.
50: -- Use the default fnd_api.g_valid_level_full.
51: --
52: -- p_user_name VARCHAR2(100)
53: -- The user's name, as defined in fnd_user table.
54: -- This is used to record audit info in the WHO columns.

Line 76: -- database commit. Specify fnd_api.g_true or

72: -- 192(0xC0) or 216(0xD8) will be accepted
73: --
74: -- p_commit VARCHAR2
75: -- Indicates whether the API shall perform a
76: -- database commit. Specify fnd_api.g_true or
77: -- fnd_api.g_false.
78: -- Default is fnd_api.g_true.
79: --
80: -- x_msg_count OUT NUMBER

Line 77: -- fnd_api.g_false.

73: --
74: -- p_commit VARCHAR2
75: -- Indicates whether the API shall perform a
76: -- database commit. Specify fnd_api.g_true or
77: -- fnd_api.g_false.
78: -- Default is fnd_api.g_true.
79: --
80: -- x_msg_count OUT NUMBER
81: -- Standard api parameter. Indicates no. of messages

Line 78: -- Default is fnd_api.g_true.

74: -- p_commit VARCHAR2
75: -- Indicates whether the API shall perform a
76: -- database commit. Specify fnd_api.g_true or
77: -- fnd_api.g_false.
78: -- Default is fnd_api.g_true.
79: --
80: -- x_msg_count OUT NUMBER
81: -- Standard api parameter. Indicates no. of messages
82: -- put into the message stack.

Line 89: -- Values: fnd_api.g_ret_sts_success,

85: -- Standard api parameter. Messages returned.
86: --
87: -- x_return_status OUT VARCHAR2
88: -- Standard api return status parameter.
89: -- Values: fnd_api.g_ret_sts_success,
90: -- fnd_api.g_ret_sts_error,
91: -- fnd_api.g_ret_sts_unexp_error.
92: --
93: /*#

Line 90: -- fnd_api.g_ret_sts_error,

86: --
87: -- x_return_status OUT VARCHAR2
88: -- Standard api return status parameter.
89: -- Values: fnd_api.g_ret_sts_success,
90: -- fnd_api.g_ret_sts_error,
91: -- fnd_api.g_ret_sts_unexp_error.
92: --
93: /*#
94: * API to set device data value for a single device.

Line 91: -- fnd_api.g_ret_sts_unexp_error.

87: -- x_return_status OUT VARCHAR2
88: -- Standard api return status parameter.
89: -- Values: fnd_api.g_ret_sts_success,
90: -- fnd_api.g_ret_sts_error,
91: -- fnd_api.g_ret_sts_unexp_error.
92: --
93: /*#
94: * API to set device data value for a single device.
95: * @param p_api_version Current version is 1.0

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

108: * @rep:displayname Set device value
109: */
110: PROCEDURE set_device_data(
111: p_api_version IN NUMBER,
112: p_init_msg_list IN VARCHAR2 := fnd_api.g_false,
113: p_validation_level IN NUMBER := fnd_api.g_valid_level_full,
114: p_user_name IN VARCHAR2 := NULL,
115: p_device_source IN VARCHAR2,
116: p_device_name IN VARCHAR2,

Line 113: p_validation_level IN NUMBER := fnd_api.g_valid_level_full,

109: */
110: PROCEDURE set_device_data(
111: p_api_version IN NUMBER,
112: p_init_msg_list IN VARCHAR2 := fnd_api.g_false,
113: p_validation_level IN NUMBER := fnd_api.g_valid_level_full,
114: p_user_name IN VARCHAR2 := NULL,
115: p_device_source IN VARCHAR2,
116: p_device_name IN VARCHAR2,
117: p_device_data IN VARCHAR2,

Line 120: p_commit IN VARCHAR2 := fnd_api.g_true,

116: p_device_name IN VARCHAR2,
117: p_device_data IN VARCHAR2,
118: p_device_event_time IN DATE,
119: p_quality_code IN NUMBER,
120: p_commit IN VARCHAR2 := fnd_api.g_true,
121: x_msg_count OUT NOCOPY NUMBER,
122: x_msg_data OUT NOCOPY VARCHAR2,
123: x_return_status OUT NOCOPY VARCHAR2);
124:

Line 147: -- Default is fnd_api.g_false.

143: --
144: -- p_init_msg_list VARCHAR2
145: -- Standard api parameter. Indicates whether to
146: -- re-initialize the message list.
147: -- Default is fnd_api.g_false.
148: --
149: -- p_validation_level NUMBER
150: -- Standard api parameter. Indicates validation level.
151: -- Use the default fnd_api.g_valid_level_full.

Line 151: -- Use the default fnd_api.g_valid_level_full.

147: -- Default is fnd_api.g_false.
148: --
149: -- p_validation_level NUMBER
150: -- Standard api parameter. Indicates validation level.
151: -- Use the default fnd_api.g_valid_level_full.
152: --
153: -- p_user_name VARCHAR2(100)
154: -- The user's name, as defined in fnd_user table.
155: -- This is used to record audit info in the WHO columns.

Line 177: -- database commit. Specify fnd_api.g_true or

173: -- 192(0xC0) or 216(0xD8) will be accepted.
174: --
175: -- p_commit VARCHAR2
176: -- Indicates whether the API shall perform a
177: -- database commit. Specify fnd_api.g_true or
178: -- fnd_api.g_false.
179: -- Default is fnd_api.g_true.
180: --
181: -- x_msg_count OUT NUMBER

Line 178: -- fnd_api.g_false.

174: --
175: -- p_commit VARCHAR2
176: -- Indicates whether the API shall perform a
177: -- database commit. Specify fnd_api.g_true or
178: -- fnd_api.g_false.
179: -- Default is fnd_api.g_true.
180: --
181: -- x_msg_count OUT NUMBER
182: -- Standard api parameter. Indicates no. of messages

Line 179: -- Default is fnd_api.g_true.

175: -- p_commit VARCHAR2
176: -- Indicates whether the API shall perform a
177: -- database commit. Specify fnd_api.g_true or
178: -- fnd_api.g_false.
179: -- Default is fnd_api.g_true.
180: --
181: -- x_msg_count OUT NUMBER
182: -- Standard api parameter. Indicates no. of messages
183: -- put into the message stack.

Line 190: -- Values: fnd_api.g_ret_sts_success,

186: -- Standard api parameter. Messages returned.
187: --
188: -- x_return_status OUT VARCHAR2
189: -- Standard api return status parameter.
190: -- Values: fnd_api.g_ret_sts_success,
191: -- fnd_api.g_ret_sts_error,
192: -- fnd_api.g_ret_sts_unexp_error.
193: --
194: /*#

Line 191: -- fnd_api.g_ret_sts_error,

187: --
188: -- x_return_status OUT VARCHAR2
189: -- Standard api return status parameter.
190: -- Values: fnd_api.g_ret_sts_success,
191: -- fnd_api.g_ret_sts_error,
192: -- fnd_api.g_ret_sts_unexp_error.
193: --
194: /*#
195: * API to set device data values for multiple devices.

Line 192: -- fnd_api.g_ret_sts_unexp_error.

188: -- x_return_status OUT VARCHAR2
189: -- Standard api return status parameter.
190: -- Values: fnd_api.g_ret_sts_success,
191: -- fnd_api.g_ret_sts_error,
192: -- fnd_api.g_ret_sts_unexp_error.
193: --
194: /*#
195: * API to set device data values for multiple devices.
196: * @param p_api_version Current version is 1.0

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

209: * @rep:displayname Set multiple device values by bulk operation
210: */
211: PROCEDURE set_device_data_bulk(
212: p_api_version IN NUMBER,
213: p_init_msg_list IN VARCHAR2 := fnd_api.g_false,
214: p_validation_level IN NUMBER := fnd_api.g_valid_level_full,
215: p_user_name IN VARCHAR2 := NULL,
216: p_device_source IN VARCHAR2,
217: p_device_name IN VARCHAR2_TABLE,

Line 214: p_validation_level IN NUMBER := fnd_api.g_valid_level_full,

210: */
211: PROCEDURE set_device_data_bulk(
212: p_api_version IN NUMBER,
213: p_init_msg_list IN VARCHAR2 := fnd_api.g_false,
214: p_validation_level IN NUMBER := fnd_api.g_valid_level_full,
215: p_user_name IN VARCHAR2 := NULL,
216: p_device_source IN VARCHAR2,
217: p_device_name IN VARCHAR2_TABLE,
218: p_device_data IN VARCHAR2_TABLE,

Line 221: p_commit IN VARCHAR2 := fnd_api.g_true,

217: p_device_name IN VARCHAR2_TABLE,
218: p_device_data IN VARCHAR2_TABLE,
219: p_device_event_time IN DATE_TABLE,
220: p_quality_code IN NUMBER_TABLE,
221: p_commit IN VARCHAR2 := fnd_api.g_true,
222: x_msg_count OUT NOCOPY NUMBER,
223: x_msg_data OUT NOCOPY VARCHAR2,
224: x_return_status OUT NOCOPY VARCHAR2);
225:

Line 249: -- Default is fnd_api.g_false.

245: --
246: -- p_init_msg_list VARCHAR2
247: -- Standard api parameter. Indicates whether to
248: -- re-initialize the message list.
249: -- Default is fnd_api.g_false.
250: --
251: -- p_validation_level NUMBER
252: -- Standard api parameter. Indicates validation level.
253: -- Use the default fnd_api.g_valid_level_full.

Line 253: -- Use the default fnd_api.g_valid_level_full.

249: -- Default is fnd_api.g_false.
250: --
251: -- p_validation_level NUMBER
252: -- Standard api parameter. Indicates validation level.
253: -- Use the default fnd_api.g_valid_level_full.
254: --
255: -- p_user_name VARCHAR2(100)
256: -- The user's name, as defined in fnd_user table.
257: -- This is used to record audit info in the WHO columns.

Line 277: -- database commit. Specify fnd_api.g_true or

273: -- will be rejected.
274: --
275: -- p_commit VARCHAR2
276: -- Indicates whether the API shall perform a
277: -- database commit. Specify fnd_api.g_true or
278: -- fnd_api.g_false.
279: -- Default is fnd_api.g_true.
280: --
281: -- x_msg_count OUT NUMBER

Line 278: -- fnd_api.g_false.

274: --
275: -- p_commit VARCHAR2
276: -- Indicates whether the API shall perform a
277: -- database commit. Specify fnd_api.g_true or
278: -- fnd_api.g_false.
279: -- Default is fnd_api.g_true.
280: --
281: -- x_msg_count OUT NUMBER
282: -- Standard api parameter. Indicates no. of messages

Line 279: -- Default is fnd_api.g_true.

275: -- p_commit VARCHAR2
276: -- Indicates whether the API shall perform a
277: -- database commit. Specify fnd_api.g_true or
278: -- fnd_api.g_false.
279: -- Default is fnd_api.g_true.
280: --
281: -- x_msg_count OUT NUMBER
282: -- Standard api parameter. Indicates no. of messages
283: -- put into the message stack.

Line 290: -- Values: fnd_api.g_ret_sts_success,

286: -- Standard api parameter. Messages returned.
287: --
288: -- x_return_status OUT VARCHAR2
289: -- Standard api return status parameter.
290: -- Values: fnd_api.g_ret_sts_success,
291: -- fnd_api.g_ret_sts_error,
292: -- fnd_api.g_ret_sts_unexp_error.
293: --
294: /*#

Line 291: -- fnd_api.g_ret_sts_error,

287: --
288: -- x_return_status OUT VARCHAR2
289: -- Standard api return status parameter.
290: -- Values: fnd_api.g_ret_sts_success,
291: -- fnd_api.g_ret_sts_error,
292: -- fnd_api.g_ret_sts_unexp_error.
293: --
294: /*#
295: * API to add device setup info in bulk to Oracle Quality internal table.

Line 292: -- fnd_api.g_ret_sts_unexp_error.

288: -- x_return_status OUT VARCHAR2
289: -- Standard api return status parameter.
290: -- Values: fnd_api.g_ret_sts_success,
291: -- fnd_api.g_ret_sts_error,
292: -- fnd_api.g_ret_sts_unexp_error.
293: --
294: /*#
295: * API to add device setup info in bulk to Oracle Quality internal table.
296: * @param p_api_version Current version is 1.0

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

308: * @rep:displayname Add multiple devices by bulk operation
309: */
310: PROCEDURE add_device_info_bulk(
311: p_api_version IN NUMBER,
312: p_init_msg_list IN VARCHAR2 := fnd_api.g_false,
313: p_validation_level IN NUMBER := fnd_api.g_valid_level_full,
314: p_user_name IN VARCHAR2 := NULL,
315: p_device_source IN VARCHAR2,
316: p_device_name IN VARCHAR2_TABLE,

Line 313: p_validation_level IN NUMBER := fnd_api.g_valid_level_full,

309: */
310: PROCEDURE add_device_info_bulk(
311: p_api_version IN NUMBER,
312: p_init_msg_list IN VARCHAR2 := fnd_api.g_false,
313: p_validation_level IN NUMBER := fnd_api.g_valid_level_full,
314: p_user_name IN VARCHAR2 := NULL,
315: p_device_source IN VARCHAR2,
316: p_device_name IN VARCHAR2_TABLE,
317: p_device_desc IN VARCHAR2000_TABLE,

Line 319: p_commit IN VARCHAR2 := fnd_api.g_true,

315: p_device_source IN VARCHAR2,
316: p_device_name IN VARCHAR2_TABLE,
317: p_device_desc IN VARCHAR2000_TABLE,
318: p_expiration IN NUMBER_TABLE,
319: p_commit IN VARCHAR2 := fnd_api.g_true,
320: x_msg_count OUT NOCOPY NUMBER,
321: x_msg_data OUT NOCOPY VARCHAR2,
322: x_return_status OUT NOCOPY VARCHAR2);
323:

Line 345: -- Default is fnd_api.g_false.

341: --
342: -- p_init_msg_list VARCHAR2
343: -- Standard api parameter. Indicates whether to
344: -- re-initialize the message list.
345: -- Default is fnd_api.g_false.
346: --
347: -- p_validation_level NUMBER
348: -- Standard api parameter. Indicates validation level.
349: -- Use the default fnd_api.g_valid_level_full.

Line 349: -- Use the default fnd_api.g_valid_level_full.

345: -- Default is fnd_api.g_false.
346: --
347: -- p_validation_level NUMBER
348: -- Standard api parameter. Indicates validation level.
349: -- Use the default fnd_api.g_valid_level_full.
350: --
351: -- p_user_name VARCHAR2(100)
352: -- The user's name, as defined in fnd_user table.
353: -- This is used to record audit info in the WHO columns.

Line 366: -- database commit. Specify fnd_api.g_true or

362: -- Name of device to be deleted.
363: --
364: -- p_commit VARCHAR2
365: -- Indicates whether the API shall perform a
366: -- database commit. Specify fnd_api.g_true or
367: -- fnd_api.g_false.
368: -- Default is fnd_api.g_true.
369: --
370: -- x_msg_count OUT NUMBER

Line 367: -- fnd_api.g_false.

363: --
364: -- p_commit VARCHAR2
365: -- Indicates whether the API shall perform a
366: -- database commit. Specify fnd_api.g_true or
367: -- fnd_api.g_false.
368: -- Default is fnd_api.g_true.
369: --
370: -- x_msg_count OUT NUMBER
371: -- Standard api parameter. Indicates no. of messages

Line 368: -- Default is fnd_api.g_true.

364: -- p_commit VARCHAR2
365: -- Indicates whether the API shall perform a
366: -- database commit. Specify fnd_api.g_true or
367: -- fnd_api.g_false.
368: -- Default is fnd_api.g_true.
369: --
370: -- x_msg_count OUT NUMBER
371: -- Standard api parameter. Indicates no. of messages
372: -- put into the message stack.

Line 379: -- Values: fnd_api.g_ret_sts_success,

375: -- Standard api parameter. Messages returned.
376: --
377: -- x_return_status OUT VARCHAR2
378: -- Standard api return status parameter.
379: -- Values: fnd_api.g_ret_sts_success,
380: -- fnd_api.g_ret_sts_error,
381: -- fnd_api.g_ret_sts_unexp_error.
382: --
383: /*#

Line 380: -- fnd_api.g_ret_sts_error,

376: --
377: -- x_return_status OUT VARCHAR2
378: -- Standard api return status parameter.
379: -- Values: fnd_api.g_ret_sts_success,
380: -- fnd_api.g_ret_sts_error,
381: -- fnd_api.g_ret_sts_unexp_error.
382: --
383: /*#
384: * API to delete one or more devices from Oracle Quality's

Line 381: -- fnd_api.g_ret_sts_unexp_error.

377: -- x_return_status OUT VARCHAR2
378: -- Standard api return status parameter.
379: -- Values: fnd_api.g_ret_sts_success,
380: -- fnd_api.g_ret_sts_error,
381: -- fnd_api.g_ret_sts_unexp_error.
382: --
383: /*#
384: * API to delete one or more devices from Oracle Quality's
385: * internal table - qa_device_info.

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

396: * @rep:displayname Delete multiple devices by bulk operation
397: */
398: PROCEDURE delete_device_info_bulk(
399: p_api_version IN NUMBER,
400: p_init_msg_list IN VARCHAR2 := fnd_api.g_false,
401: p_validation_level IN NUMBER := fnd_api.g_valid_level_full,
402: p_user_name IN VARCHAR2 := NULL,
403: p_device_source IN VARCHAR2,
404: p_device_name IN VARCHAR2_TABLE,

Line 401: p_validation_level IN NUMBER := fnd_api.g_valid_level_full,

397: */
398: PROCEDURE delete_device_info_bulk(
399: p_api_version IN NUMBER,
400: p_init_msg_list IN VARCHAR2 := fnd_api.g_false,
401: p_validation_level IN NUMBER := fnd_api.g_valid_level_full,
402: p_user_name IN VARCHAR2 := NULL,
403: p_device_source IN VARCHAR2,
404: p_device_name IN VARCHAR2_TABLE,
405: p_commit IN VARCHAR2 := fnd_api.g_true,

Line 405: p_commit IN VARCHAR2 := fnd_api.g_true,

401: p_validation_level IN NUMBER := fnd_api.g_valid_level_full,
402: p_user_name IN VARCHAR2 := NULL,
403: p_device_source IN VARCHAR2,
404: p_device_name IN VARCHAR2_TABLE,
405: p_commit IN VARCHAR2 := fnd_api.g_true,
406: x_msg_count OUT NOCOPY NUMBER,
407: x_msg_data OUT NOCOPY VARCHAR2,
408: x_return_status OUT NOCOPY VARCHAR2);
409: