7: -- Pre-reqs : None.
8: -- Parameters :
9: -- IN P_API_VERSION IN NUMBER REQUIRED
10: -- P_INIT_MSG_LIST IN VARCHAR2 OPTIONAL
11: -- DEFAULT = FND_API.G_FALSE
12: -- P_COMMIT IN VARCHAR2 OPTIONAL
13: -- DEFAULT = FND_API.G_FALSE
14: -- P_VALIDATION_LEVEL IN NUMBER OPTIONAL
15: -- DEFAULT = FND_API.G_VALID_LEVEL_FULL
9: -- IN P_API_VERSION IN NUMBER REQUIRED
10: -- P_INIT_MSG_LIST IN VARCHAR2 OPTIONAL
11: -- DEFAULT = FND_API.G_FALSE
12: -- P_COMMIT IN VARCHAR2 OPTIONAL
13: -- DEFAULT = FND_API.G_FALSE
14: -- P_VALIDATION_LEVEL IN NUMBER OPTIONAL
15: -- DEFAULT = FND_API.G_VALID_LEVEL_FULL
16: -- P_ROWID IN OUT VARCHAR2 REQUIRED
17: -- P_INVENTORY_ITEM_ID IN NUMBER
11: -- DEFAULT = FND_API.G_FALSE
12: -- P_COMMIT IN VARCHAR2 OPTIONAL
13: -- DEFAULT = FND_API.G_FALSE
14: -- P_VALIDATION_LEVEL IN NUMBER OPTIONAL
15: -- DEFAULT = FND_API.G_VALID_LEVEL_FULL
16: -- P_ROWID IN OUT VARCHAR2 REQUIRED
17: -- P_INVENTORY_ITEM_ID IN NUMBER
18: -- P_SERIAL_NUMBER IN VARCHAR2
19: -- P_START_DATE_ACTIVE IN DATE
71: -- End of comments
72:
73: PROCEDURE SERIAL_CHECK(
74: p_api_version IN NUMBER,
75: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
76: p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
77: p_validation_level IN NUMBER DEFAULT FND_API.G_VALID_LEVEL_FULL,
78: x_return_status OUT NOCOPY VARCHAR2,
79: x_msg_count OUT NOCOPY NUMBER,
72:
73: PROCEDURE SERIAL_CHECK(
74: p_api_version IN NUMBER,
75: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
76: p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
77: p_validation_level IN NUMBER DEFAULT FND_API.G_VALID_LEVEL_FULL,
78: x_return_status OUT NOCOPY VARCHAR2,
79: x_msg_count OUT NOCOPY NUMBER,
80: x_msg_data OUT NOCOPY VARCHAR2,
73: PROCEDURE SERIAL_CHECK(
74: p_api_version IN NUMBER,
75: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
76: p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
77: p_validation_level IN NUMBER DEFAULT FND_API.G_VALID_LEVEL_FULL,
78: x_return_status OUT NOCOPY VARCHAR2,
79: x_msg_count OUT NOCOPY NUMBER,
80: x_msg_data OUT NOCOPY VARCHAR2,
81: x_errorcode OUT NOCOPY NUMBER,
89: -- of 'serial integration with wip' project
90:
91: PROCEDURE INSERT_ROW(
92: P_API_VERSION IN NUMBER,
93: P_INIT_MSG_LIST IN VARCHAR2 := FND_API.G_FALSE,
94: P_COMMIT IN VARCHAR2 := FND_API.G_FALSE,
95: P_VALIDATION_LEVEL IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
96: P_ROWID IN OUT NOCOPY VARCHAR2,
97: P_INVENTORY_ITEM_ID NUMBER,
90:
91: PROCEDURE INSERT_ROW(
92: P_API_VERSION IN NUMBER,
93: P_INIT_MSG_LIST IN VARCHAR2 := FND_API.G_FALSE,
94: P_COMMIT IN VARCHAR2 := FND_API.G_FALSE,
95: P_VALIDATION_LEVEL IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
96: P_ROWID IN OUT NOCOPY VARCHAR2,
97: P_INVENTORY_ITEM_ID NUMBER,
98: P_SERIAL_NUMBER VARCHAR2,
91: PROCEDURE INSERT_ROW(
92: P_API_VERSION IN NUMBER,
93: P_INIT_MSG_LIST IN VARCHAR2 := FND_API.G_FALSE,
94: P_COMMIT IN VARCHAR2 := FND_API.G_FALSE,
95: P_VALIDATION_LEVEL IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
96: P_ROWID IN OUT NOCOPY VARCHAR2,
97: P_INVENTORY_ITEM_ID NUMBER,
98: P_SERIAL_NUMBER VARCHAR2,
99: P_INITIALIZATION_DATE DATE,
234:
235:
236: PROCEDURE UPDATE_ROW(
237: P_API_VERSION IN NUMBER,
238: P_INIT_MSG_LIST IN VARCHAR2 := FND_API.G_FALSE,
239: P_COMMIT IN VARCHAR2 := FND_API.G_FALSE,
240: P_VALIDATION_LEVEL IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
241: P_ROWID VARCHAR2,
242: P_DESCRIPTIVE_TEXT VARCHAR2,
235:
236: PROCEDURE UPDATE_ROW(
237: P_API_VERSION IN NUMBER,
238: P_INIT_MSG_LIST IN VARCHAR2 := FND_API.G_FALSE,
239: P_COMMIT IN VARCHAR2 := FND_API.G_FALSE,
240: P_VALIDATION_LEVEL IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
241: P_ROWID VARCHAR2,
242: P_DESCRIPTIVE_TEXT VARCHAR2,
243: P_CATEGORY_ID NUMBER,
236: PROCEDURE UPDATE_ROW(
237: P_API_VERSION IN NUMBER,
238: P_INIT_MSG_LIST IN VARCHAR2 := FND_API.G_FALSE,
239: P_COMMIT IN VARCHAR2 := FND_API.G_FALSE,
240: P_VALIDATION_LEVEL IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
241: P_ROWID VARCHAR2,
242: P_DESCRIPTIVE_TEXT VARCHAR2,
243: P_CATEGORY_ID NUMBER,
244: P_PROD_ORGANIZATION_ID NUMBER,
369:
370:
371: PROCEDURE LOCK_ROW(
372: P_API_VERSION IN NUMBER,
373: P_INIT_MSG_LIST IN VARCHAR2 := FND_API.G_FALSE,
374: P_COMMIT IN VARCHAR2 := FND_API.G_FALSE,
375: P_VALIDATION_LEVEL IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
376: P_ROWID VARCHAR2,
377: P_INVENTORY_ITEM_ID NUMBER,
370:
371: PROCEDURE LOCK_ROW(
372: P_API_VERSION IN NUMBER,
373: P_INIT_MSG_LIST IN VARCHAR2 := FND_API.G_FALSE,
374: P_COMMIT IN VARCHAR2 := FND_API.G_FALSE,
375: P_VALIDATION_LEVEL IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
376: P_ROWID VARCHAR2,
377: P_INVENTORY_ITEM_ID NUMBER,
378: P_SERIAL_NUMBER VARCHAR2,
371: PROCEDURE LOCK_ROW(
372: P_API_VERSION IN NUMBER,
373: P_INIT_MSG_LIST IN VARCHAR2 := FND_API.G_FALSE,
374: P_COMMIT IN VARCHAR2 := FND_API.G_FALSE,
375: P_VALIDATION_LEVEL IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
376: P_ROWID VARCHAR2,
377: P_INVENTORY_ITEM_ID NUMBER,
378: P_SERIAL_NUMBER VARCHAR2,
379: P_START_DATE_ACTIVE DATE,