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