DBA Data[Home] [Help]

APPS.INV_SERIAL_NUMBER_PUB dependencies on FND_API

Line 42: * @param p_init_msg_list fnd_api.g_false or fnd_api.g_true is passed as input in this variable to determine whether to Initialize message list or not

38: /*#
39: * Use this procedure to validate and insert a given Serial Number.
40: * @param p_api_version API version is passed as input in this variable
41: * @paraminfo {@rep:required}
42: * @param p_init_msg_list fnd_api.g_false or fnd_api.g_true is passed as input in this variable to determine whether to Initialize message list or not
43: * @paraminfo {@rep:required}
44: * @param p_commit fnd_api.g_false or fnd_api.g_true is passed as input in this variable to determine whether to commit or not
45: * @paraminfo {@rep:required}
46: * @param p_validation_level Validation level is passed as input in this variable

Line 44: * @param p_commit fnd_api.g_false or fnd_api.g_true is passed as input in this variable to determine whether to commit or not

40: * @param p_api_version API version is passed as input in this variable
41: * @paraminfo {@rep:required}
42: * @param p_init_msg_list fnd_api.g_false or fnd_api.g_true is passed as input in this variable to determine whether to Initialize message list or not
43: * @paraminfo {@rep:required}
44: * @param p_commit fnd_api.g_false or fnd_api.g_true is passed as input in this variable to determine whether to commit or not
45: * @paraminfo {@rep:required}
46: * @param p_validation_level Validation level is passed as input in this variable
47: * @paraminfo {@rep:required}
48: * @param p_inventory_item_id Inventory Item id is passed as input in this variable

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

74: * @rep:displayname Insert Serial Number
75: */
76: PROCEDURE insertserial(
77: p_api_version IN NUMBER
78: , p_init_msg_list IN VARCHAR2 := fnd_api.g_false
79: , p_commit IN VARCHAR2 := fnd_api.g_false
80: , p_validation_level IN NUMBER := fnd_api.g_valid_level_full
81: , p_inventory_item_id IN NUMBER
82: , p_organization_id IN NUMBER

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

75: */
76: PROCEDURE insertserial(
77: p_api_version IN NUMBER
78: , p_init_msg_list IN VARCHAR2 := fnd_api.g_false
79: , p_commit IN VARCHAR2 := fnd_api.g_false
80: , p_validation_level IN NUMBER := fnd_api.g_valid_level_full
81: , p_inventory_item_id IN NUMBER
82: , p_organization_id IN NUMBER
83: , p_serial_number IN VARCHAR2

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

76: PROCEDURE insertserial(
77: p_api_version IN NUMBER
78: , p_init_msg_list IN VARCHAR2 := fnd_api.g_false
79: , p_commit IN VARCHAR2 := fnd_api.g_false
80: , p_validation_level IN NUMBER := fnd_api.g_valid_level_full
81: , p_inventory_item_id IN NUMBER
82: , p_organization_id IN NUMBER
83: , p_serial_number IN VARCHAR2
84: , p_current_status IN NUMBER

Line 104: * @param p_init_msg_list fnd_api.g_false or fnd_api.g_true is passed as input in this variable to determine whether to Initialize message list or not

100: /*#
101: * Use this procedure to validate and insert a given Serial Number.
102: * @param p_api_version API version is passed as input in this variable
103: * @paraminfo {@rep:required}
104: * @param p_init_msg_list fnd_api.g_false or fnd_api.g_true is passed as input in this variable to determine whether to Initialize message list or not
105: * @paraminfo {@rep:required}
106: * @param p_commit fnd_api.g_false or fnd_api.g_true is passed as input in this variable to determine whether to commit or not
107: * @paraminfo {@rep:required}
108: * @param p_validation_level Validation level is passed as input in this variable

Line 106: * @param p_commit fnd_api.g_false or fnd_api.g_true is passed as input in this variable to determine whether to commit or not

102: * @param p_api_version API version is passed as input in this variable
103: * @paraminfo {@rep:required}
104: * @param p_init_msg_list fnd_api.g_false or fnd_api.g_true is passed as input in this variable to determine whether to Initialize message list or not
105: * @paraminfo {@rep:required}
106: * @param p_commit fnd_api.g_false or fnd_api.g_true is passed as input in this variable to determine whether to commit or not
107: * @paraminfo {@rep:required}
108: * @param p_validation_level Validation level is passed as input in this variable
109: * @paraminfo {@rep:required}
110: * @param p_inventory_item_id Inventory Item id is passed as input in this variable

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

181: * @rep:displayname Insert Serial Number
182: */
183: PROCEDURE insertserial(
184: p_api_version IN NUMBER
185: , p_init_msg_list IN VARCHAR2 := fnd_api.g_false
186: , p_commit IN VARCHAR2 := fnd_api.g_false
187: , p_validation_level IN NUMBER := fnd_api.g_valid_level_full
188: , p_inventory_item_id IN NUMBER
189: , p_organization_id IN NUMBER

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

182: */
183: PROCEDURE insertserial(
184: p_api_version IN NUMBER
185: , p_init_msg_list IN VARCHAR2 := fnd_api.g_false
186: , p_commit IN VARCHAR2 := fnd_api.g_false
187: , p_validation_level IN NUMBER := fnd_api.g_valid_level_full
188: , p_inventory_item_id IN NUMBER
189: , p_organization_id IN NUMBER
190: , p_serial_number IN VARCHAR2

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

183: PROCEDURE insertserial(
184: p_api_version IN NUMBER
185: , p_init_msg_list IN VARCHAR2 := fnd_api.g_false
186: , p_commit IN VARCHAR2 := fnd_api.g_false
187: , p_validation_level IN NUMBER := fnd_api.g_valid_level_full
188: , p_inventory_item_id IN NUMBER
189: , p_organization_id IN NUMBER
190: , p_serial_number IN VARCHAR2
191: , p_initialization_date IN DATE

Line 233: * @param p_init_msg_list fnd_api.g_false or fnd_api.g_true is passed as input in this variable to determine whether to Initialize message list or not

229: /*#
230: * Use this procedure to validate and insert a given Range Serial Number .
231: * @param p_api_version API version is passed as input in this variable
232: * @paraminfo {@rep:required}
233: * @param p_init_msg_list fnd_api.g_false or fnd_api.g_true is passed as input in this variable to determine whether to Initialize message list or not
234: * @paraminfo {@rep:required}
235: * @param p_commit fnd_api.g_false or fnd_api.g_true is passed as input in this variable to determine whether to commit or not
236: * @paraminfo {@rep:required}
237: * @param p_validation_level Validation level is passed as input in this variable

Line 235: * @param p_commit fnd_api.g_false or fnd_api.g_true is passed as input in this variable to determine whether to commit or not

231: * @param p_api_version API version is passed as input in this variable
232: * @paraminfo {@rep:required}
233: * @param p_init_msg_list fnd_api.g_false or fnd_api.g_true is passed as input in this variable to determine whether to Initialize message list or not
234: * @paraminfo {@rep:required}
235: * @param p_commit fnd_api.g_false or fnd_api.g_true is passed as input in this variable to determine whether to commit or not
236: * @paraminfo {@rep:required}
237: * @param p_validation_level Validation level is passed as input in this variable
238: * @paraminfo {@rep:required}
239: * @param p_inventory_item_id Inventory Item id is passed as input in this variable

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

265: * @rep:displayname Insert Serial Number
266: */
267: PROCEDURE insert_range_serial(
268: p_api_version IN NUMBER
269: , p_init_msg_list IN VARCHAR2 := fnd_api.g_false
270: , p_commit IN VARCHAR2 := fnd_api.g_false
271: , p_validation_level IN NUMBER := fnd_api.g_valid_level_full
272: , p_inventory_item_id IN NUMBER
273: , p_organization_id IN NUMBER

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

266: */
267: PROCEDURE insert_range_serial(
268: p_api_version IN NUMBER
269: , p_init_msg_list IN VARCHAR2 := fnd_api.g_false
270: , p_commit IN VARCHAR2 := fnd_api.g_false
271: , p_validation_level IN NUMBER := fnd_api.g_valid_level_full
272: , p_inventory_item_id IN NUMBER
273: , p_organization_id IN NUMBER
274: , p_fm_serial_number IN VARCHAR2

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

267: PROCEDURE insert_range_serial(
268: p_api_version IN NUMBER
269: , p_init_msg_list IN VARCHAR2 := fnd_api.g_false
270: , p_commit IN VARCHAR2 := fnd_api.g_false
271: , p_validation_level IN NUMBER := fnd_api.g_valid_level_full
272: , p_inventory_item_id IN NUMBER
273: , p_organization_id IN NUMBER
274: , p_fm_serial_number IN VARCHAR2
275: , p_to_serial_number IN VARCHAR2

Line 304: * @param p_init_msg_list fnd_api.g_false or fnd_api.g_true is passed as input in this variable to determine whether to Initialize message list or not

300: * Use this procedure to validate and insert a range of Serial Numbers
301: * based on Start Serial Number and End Serial Number.
302: * @param p_api_version API version is passed as input in this variable
303: * @paraminfo {@rep:required}
304: * @param p_init_msg_list fnd_api.g_false or fnd_api.g_true is passed as input in this variable to determine whether to Initialize message list or not
305: * @paraminfo {@rep:required}
306: * @param p_commit fnd_api.g_false or fnd_api.g_true is passed as input in this variable to determine whether to commit or not
307: * @paraminfo {@rep:required}
308: * @param p_validation_level Validation level is passed as input in this variable

Line 306: * @param p_commit fnd_api.g_false or fnd_api.g_true is passed as input in this variable to determine whether to commit or not

302: * @param p_api_version API version is passed as input in this variable
303: * @paraminfo {@rep:required}
304: * @param p_init_msg_list fnd_api.g_false or fnd_api.g_true is passed as input in this variable to determine whether to Initialize message list or not
305: * @paraminfo {@rep:required}
306: * @param p_commit fnd_api.g_false or fnd_api.g_true is passed as input in this variable to determine whether to commit or not
307: * @paraminfo {@rep:required}
308: * @param p_validation_level Validation level is passed as input in this variable
309: * @paraminfo {@rep:required}
310: * @param p_inventory_item_id Inventory Item id is passed as input in this variable

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

382: * @rep:displayname Insert Range of Serial Numbers
383: */
384: PROCEDURE insert_range_serial(
385: p_api_version IN NUMBER
386: , p_init_msg_list IN VARCHAR2 := fnd_api.g_false
387: , p_commit IN VARCHAR2 := fnd_api.g_false
388: , p_validation_level IN NUMBER := fnd_api.g_valid_level_full
389: , p_inventory_item_id IN NUMBER
390: , p_organization_id IN NUMBER

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

383: */
384: PROCEDURE insert_range_serial(
385: p_api_version IN NUMBER
386: , p_init_msg_list IN VARCHAR2 := fnd_api.g_false
387: , p_commit IN VARCHAR2 := fnd_api.g_false
388: , p_validation_level IN NUMBER := fnd_api.g_valid_level_full
389: , p_inventory_item_id IN NUMBER
390: , p_organization_id IN NUMBER
391: , p_from_serial_number IN VARCHAR2

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

384: PROCEDURE insert_range_serial(
385: p_api_version IN NUMBER
386: , p_init_msg_list IN VARCHAR2 := fnd_api.g_false
387: , p_commit IN VARCHAR2 := fnd_api.g_false
388: , p_validation_level IN NUMBER := fnd_api.g_valid_level_full
389: , p_inventory_item_id IN NUMBER
390: , p_organization_id IN NUMBER
391: , p_from_serial_number IN VARCHAR2
392: , p_to_serial_number IN VARCHAR2

Line 435: * @param p_init_msg_list fnd_api.g_false or fnd_api.g_true is passed as input in this variable to determine whether to Initialize message list or not

431: /*#
432: * Use this procedure to update a given Serial Number
433: * @param p_api_version API version is passed as input in this variable
434: * @paraminfo {@rep:required}
435: * @param p_init_msg_list fnd_api.g_false or fnd_api.g_true is passed as input in this variable to determine whether to Initialize message list or not
436: * @paraminfo {@rep:required}
437: * @param p_commit fnd_api.g_false or fnd_api.g_true is passed as input in this variable to determine whether to commit or not
438: * @paraminfo {@rep:required}
439: * @param p_validation_level Validation level is passed as input in this variable

Line 437: * @param p_commit fnd_api.g_false or fnd_api.g_true is passed as input in this variable to determine whether to commit or not

433: * @param p_api_version API version is passed as input in this variable
434: * @paraminfo {@rep:required}
435: * @param p_init_msg_list fnd_api.g_false or fnd_api.g_true is passed as input in this variable to determine whether to Initialize message list or not
436: * @paraminfo {@rep:required}
437: * @param p_commit fnd_api.g_false or fnd_api.g_true is passed as input in this variable to determine whether to commit or not
438: * @paraminfo {@rep:required}
439: * @param p_validation_level Validation level is passed as input in this variable
440: * @paraminfo {@rep:required}
441: * @param p_inventory_item_id Inventory Item id is passed as input in this variable

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

509: * @rep:displayname Update Serial Number
510: */
511: PROCEDURE updateserial(
512: p_api_version IN NUMBER
513: , p_init_msg_list IN VARCHAR2 := fnd_api.g_false
514: , p_commit IN VARCHAR2 := fnd_api.g_false
515: , p_validation_level IN NUMBER := fnd_api.g_valid_level_full
516: , p_inventory_item_id IN NUMBER
517: , p_organization_id IN NUMBER

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

510: */
511: PROCEDURE updateserial(
512: p_api_version IN NUMBER
513: , p_init_msg_list IN VARCHAR2 := fnd_api.g_false
514: , p_commit IN VARCHAR2 := fnd_api.g_false
515: , p_validation_level IN NUMBER := fnd_api.g_valid_level_full
516: , p_inventory_item_id IN NUMBER
517: , p_organization_id IN NUMBER
518: , p_serial_number IN VARCHAR2

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

511: PROCEDURE updateserial(
512: p_api_version IN NUMBER
513: , p_init_msg_list IN VARCHAR2 := fnd_api.g_false
514: , p_commit IN VARCHAR2 := fnd_api.g_false
515: , p_validation_level IN NUMBER := fnd_api.g_valid_level_full
516: , p_inventory_item_id IN NUMBER
517: , p_organization_id IN NUMBER
518: , p_serial_number IN VARCHAR2
519: , p_initialization_date IN DATE

Line 561: * @param p_init_msg_list fnd_api.g_false or fnd_api.g_true is passed as input in this variable to determine whether to Initialize message list or not

557: /*#
558: * Use this procedure to create Transactions of serialized units.
559: * @param p_api_version API version is passed as input in this variable
560: * @paraminfo {@rep:required}
561: * @param p_init_msg_list fnd_api.g_false or fnd_api.g_true is passed as input in this variable to determine whether to Initialize message list or not
562: * @paraminfo {@rep:required}
563: * @param p_commit fnd_api.g_false or fnd_api.g_true is passed as input in this variable to determine whether to commit or not
564: * @paraminfo {@rep:required}
565: * @param p_validation_level Validation level is passed as input in this variable

Line 563: * @param p_commit fnd_api.g_false or fnd_api.g_true is passed as input in this variable to determine whether to commit or not

559: * @param p_api_version API version is passed as input in this variable
560: * @paraminfo {@rep:required}
561: * @param p_init_msg_list fnd_api.g_false or fnd_api.g_true is passed as input in this variable to determine whether to Initialize message list or not
562: * @paraminfo {@rep:required}
563: * @param p_commit fnd_api.g_false or fnd_api.g_true is passed as input in this variable to determine whether to commit or not
564: * @paraminfo {@rep:required}
565: * @param p_validation_level Validation level is passed as input in this variable
566: * @paraminfo {@rep:required}
567: * @param p_inventory_item_id Inventory Item id is passed as input in this variable

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

607: * @rep:displayname Insert Unit Transactions
608: */
609: PROCEDURE insertunittrx(
610: p_api_version IN NUMBER
611: , p_init_msg_list IN VARCHAR2 := fnd_api.g_false
612: , p_commit IN VARCHAR2 := fnd_api.g_false
613: , p_validation_level IN NUMBER := fnd_api.g_valid_level_full
614: , p_inventory_item_id IN NUMBER
615: , p_organization_id IN NUMBER

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

608: */
609: PROCEDURE insertunittrx(
610: p_api_version IN NUMBER
611: , p_init_msg_list IN VARCHAR2 := fnd_api.g_false
612: , p_commit IN VARCHAR2 := fnd_api.g_false
613: , p_validation_level IN NUMBER := fnd_api.g_valid_level_full
614: , p_inventory_item_id IN NUMBER
615: , p_organization_id IN NUMBER
616: , p_serial_number IN VARCHAR2

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

609: PROCEDURE insertunittrx(
610: p_api_version IN NUMBER
611: , p_init_msg_list IN VARCHAR2 := fnd_api.g_false
612: , p_commit IN VARCHAR2 := fnd_api.g_false
613: , p_validation_level IN NUMBER := fnd_api.g_valid_level_full
614: , p_inventory_item_id IN NUMBER
615: , p_organization_id IN NUMBER
616: , p_serial_number IN VARCHAR2
617: , p_current_locator_id IN NUMBER

Line 1081: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,

1077: --pragma restrict_references(valsn, WNDS, WNPS, RNDS, RNPS);
1078:
1079: PROCEDURE insertRangeUnitTrx(
1080: p_api_version IN NUMBER,
1081: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
1082: p_commit IN VARCHAR2 := FND_API.G_FALSE,
1083: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
1084: p_inventory_item_id IN NUMBER,
1085: p_organization_id IN NUMBER,

Line 1082: p_commit IN VARCHAR2 := FND_API.G_FALSE,

1078:
1079: PROCEDURE insertRangeUnitTrx(
1080: p_api_version IN NUMBER,
1081: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
1082: p_commit IN VARCHAR2 := FND_API.G_FALSE,
1083: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
1084: p_inventory_item_id IN NUMBER,
1085: p_organization_id IN NUMBER,
1086: p_fm_serial_number IN VARCHAR2,

Line 1083: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,

1079: PROCEDURE insertRangeUnitTrx(
1080: p_api_version IN NUMBER,
1081: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
1082: p_commit IN VARCHAR2 := FND_API.G_FALSE,
1083: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
1084: p_inventory_item_id IN NUMBER,
1085: p_organization_id IN NUMBER,
1086: p_fm_serial_number IN VARCHAR2,
1087: p_to_serial_number IN VARCHAR2,