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

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

Line 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

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

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

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

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

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

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

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

Line 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

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

Line 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

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

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

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

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

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

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

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

Line 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

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

Line 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

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

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

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

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

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

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

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

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

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,

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

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,

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

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,