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
237: * Use this procedure to validate and insert a range of Serial Numbers
238: * based on Start Serial Number and End Serial Number.
239: * @param p_api_version API version is passed as input in this variable
240: * @paraminfo {@rep:required}
241: * @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
242: * @paraminfo {@rep:required}
243: * @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
244: * @paraminfo {@rep:required}
245: * @param p_validation_level Validation level is passed as input in this variable
239: * @param p_api_version API version is passed as input in this variable
240: * @paraminfo {@rep:required}
241: * @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
242: * @paraminfo {@rep:required}
243: * @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
244: * @paraminfo {@rep:required}
245: * @param p_validation_level Validation level is passed as input in this variable
246: * @paraminfo {@rep:required}
247: * @param p_inventory_item_id Inventory Item id is passed as input in this variable
319: * @rep:displayname Insert Range of Serial Numbers
320: */
321: PROCEDURE insert_range_serial(
322: p_api_version IN NUMBER
323: , p_init_msg_list IN VARCHAR2 := fnd_api.g_false
324: , p_commit IN VARCHAR2 := fnd_api.g_false
325: , p_validation_level IN NUMBER := fnd_api.g_valid_level_full
326: , p_inventory_item_id IN NUMBER
327: , p_organization_id IN NUMBER
320: */
321: PROCEDURE insert_range_serial(
322: p_api_version IN NUMBER
323: , p_init_msg_list IN VARCHAR2 := fnd_api.g_false
324: , p_commit IN VARCHAR2 := fnd_api.g_false
325: , p_validation_level IN NUMBER := fnd_api.g_valid_level_full
326: , p_inventory_item_id IN NUMBER
327: , p_organization_id IN NUMBER
328: , p_from_serial_number IN VARCHAR2
321: PROCEDURE insert_range_serial(
322: p_api_version IN NUMBER
323: , p_init_msg_list IN VARCHAR2 := fnd_api.g_false
324: , p_commit IN VARCHAR2 := fnd_api.g_false
325: , p_validation_level IN NUMBER := fnd_api.g_valid_level_full
326: , p_inventory_item_id IN NUMBER
327: , p_organization_id IN NUMBER
328: , p_from_serial_number IN VARCHAR2
329: , p_to_serial_number IN VARCHAR2
368: /*#
369: * Use this procedure to update a given Serial Number
370: * @param p_api_version API version is passed as input in this variable
371: * @paraminfo {@rep:required}
372: * @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
373: * @paraminfo {@rep:required}
374: * @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
375: * @paraminfo {@rep:required}
376: * @param p_validation_level Validation level is passed as input in this variable
370: * @param p_api_version API version is passed as input in this variable
371: * @paraminfo {@rep:required}
372: * @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
373: * @paraminfo {@rep:required}
374: * @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
375: * @paraminfo {@rep:required}
376: * @param p_validation_level Validation level is passed as input in this variable
377: * @paraminfo {@rep:required}
378: * @param p_inventory_item_id Inventory Item id is passed as input in this variable
446: * @rep:displayname Update Serial Number
447: */
448: PROCEDURE updateserial(
449: p_api_version IN NUMBER
450: , p_init_msg_list IN VARCHAR2 := fnd_api.g_false
451: , p_commit IN VARCHAR2 := fnd_api.g_false
452: , p_validation_level IN NUMBER := fnd_api.g_valid_level_full
453: , p_inventory_item_id IN NUMBER
454: , p_organization_id IN NUMBER
447: */
448: PROCEDURE updateserial(
449: p_api_version IN NUMBER
450: , p_init_msg_list IN VARCHAR2 := fnd_api.g_false
451: , p_commit IN VARCHAR2 := fnd_api.g_false
452: , p_validation_level IN NUMBER := fnd_api.g_valid_level_full
453: , p_inventory_item_id IN NUMBER
454: , p_organization_id IN NUMBER
455: , p_serial_number IN VARCHAR2
448: PROCEDURE updateserial(
449: p_api_version IN NUMBER
450: , p_init_msg_list IN VARCHAR2 := fnd_api.g_false
451: , p_commit IN VARCHAR2 := fnd_api.g_false
452: , p_validation_level IN NUMBER := fnd_api.g_valid_level_full
453: , p_inventory_item_id IN NUMBER
454: , p_organization_id IN NUMBER
455: , p_serial_number IN VARCHAR2
456: , p_initialization_date IN DATE
494: /*#
495: * Use this procedure to create Transactions of serialized units.
496: * @param p_api_version API version is passed as input in this variable
497: * @paraminfo {@rep:required}
498: * @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
499: * @paraminfo {@rep:required}
500: * @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
501: * @paraminfo {@rep:required}
502: * @param p_validation_level Validation level is passed as input in this variable
496: * @param p_api_version API version is passed as input in this variable
497: * @paraminfo {@rep:required}
498: * @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
499: * @paraminfo {@rep:required}
500: * @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
501: * @paraminfo {@rep:required}
502: * @param p_validation_level Validation level is passed as input in this variable
503: * @paraminfo {@rep:required}
504: * @param p_inventory_item_id Inventory Item id is passed as input in this variable
544: * @rep:displayname Insert Unit Transactions
545: */
546: PROCEDURE insertunittrx(
547: p_api_version IN NUMBER
548: , p_init_msg_list IN VARCHAR2 := fnd_api.g_false
549: , p_commit IN VARCHAR2 := fnd_api.g_false
550: , p_validation_level IN NUMBER := fnd_api.g_valid_level_full
551: , p_inventory_item_id IN NUMBER
552: , p_organization_id IN NUMBER
545: */
546: PROCEDURE insertunittrx(
547: p_api_version IN NUMBER
548: , p_init_msg_list IN VARCHAR2 := fnd_api.g_false
549: , p_commit IN VARCHAR2 := fnd_api.g_false
550: , p_validation_level IN NUMBER := fnd_api.g_valid_level_full
551: , p_inventory_item_id IN NUMBER
552: , p_organization_id IN NUMBER
553: , p_serial_number IN VARCHAR2
546: PROCEDURE insertunittrx(
547: p_api_version IN NUMBER
548: , p_init_msg_list IN VARCHAR2 := fnd_api.g_false
549: , p_commit IN VARCHAR2 := fnd_api.g_false
550: , p_validation_level IN NUMBER := fnd_api.g_valid_level_full
551: , p_inventory_item_id IN NUMBER
552: , p_organization_id IN NUMBER
553: , p_serial_number IN VARCHAR2
554: , p_current_locator_id IN NUMBER
1005: --pragma restrict_references(valsn, WNDS, WNPS, RNDS, RNPS);
1006:
1007: PROCEDURE insertRangeUnitTrx(
1008: p_api_version IN NUMBER,
1009: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
1010: p_commit IN VARCHAR2 := FND_API.G_FALSE,
1011: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
1012: p_inventory_item_id IN NUMBER,
1013: p_organization_id IN NUMBER,
1006:
1007: PROCEDURE insertRangeUnitTrx(
1008: p_api_version IN NUMBER,
1009: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
1010: p_commit IN VARCHAR2 := FND_API.G_FALSE,
1011: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
1012: p_inventory_item_id IN NUMBER,
1013: p_organization_id IN NUMBER,
1014: p_fm_serial_number IN VARCHAR2,
1007: PROCEDURE insertRangeUnitTrx(
1008: p_api_version IN NUMBER,
1009: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
1010: p_commit IN VARCHAR2 := FND_API.G_FALSE,
1011: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
1012: p_inventory_item_id IN NUMBER,
1013: p_organization_id IN NUMBER,
1014: p_fm_serial_number IN VARCHAR2,
1015: p_to_serial_number IN VARCHAR2,