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
68:
69:
70: PROCEDURE INSERT_ROW(
71: P_API_VERSION IN NUMBER,
72: P_INIT_MSG_LIST IN VARCHAR2 := FND_API.G_FALSE,
73: P_COMMIT IN VARCHAR2 := FND_API.G_FALSE,
74: P_VALIDATION_LEVEL IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
75: P_ROWID IN OUT NOCOPY VARCHAR2,
76: P_ASSOCIATION_ID NUMBER,
69:
70: PROCEDURE INSERT_ROW(
71: P_API_VERSION IN NUMBER,
72: P_INIT_MSG_LIST IN VARCHAR2 := FND_API.G_FALSE,
73: P_COMMIT IN VARCHAR2 := FND_API.G_FALSE,
74: P_VALIDATION_LEVEL IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
75: P_ROWID IN OUT NOCOPY VARCHAR2,
76: P_ASSOCIATION_ID NUMBER,
77: P_APPLICATION_ID NUMBER,
70: PROCEDURE INSERT_ROW(
71: P_API_VERSION IN NUMBER,
72: P_INIT_MSG_LIST IN VARCHAR2 := FND_API.G_FALSE,
73: P_COMMIT IN VARCHAR2 := FND_API.G_FALSE,
74: P_VALIDATION_LEVEL IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
75: P_ROWID IN OUT NOCOPY VARCHAR2,
76: P_ASSOCIATION_ID NUMBER,
77: P_APPLICATION_ID NUMBER,
78: P_DESCRIPTIVE_FLEXFIELD_NAME VARCHAR2,
139:
140:
141: PROCEDURE LOCK_ROW(
142: P_API_VERSION IN NUMBER,
143: P_INIT_MSG_LIST IN VARCHAR2 := FND_API.G_FALSE,
144: P_COMMIT IN VARCHAR2 := FND_API.G_FALSE,
145: P_VALIDATION_LEVEL IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
146: P_ROWID IN OUT NOCOPY VARCHAR2,
147: P_ASSOCIATION_ID NUMBER,
140:
141: PROCEDURE LOCK_ROW(
142: P_API_VERSION IN NUMBER,
143: P_INIT_MSG_LIST IN VARCHAR2 := FND_API.G_FALSE,
144: P_COMMIT IN VARCHAR2 := FND_API.G_FALSE,
145: P_VALIDATION_LEVEL IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
146: P_ROWID IN OUT NOCOPY VARCHAR2,
147: P_ASSOCIATION_ID NUMBER,
148: P_APPLICATION_ID NUMBER,
141: PROCEDURE LOCK_ROW(
142: P_API_VERSION IN NUMBER,
143: P_INIT_MSG_LIST IN VARCHAR2 := FND_API.G_FALSE,
144: P_COMMIT IN VARCHAR2 := FND_API.G_FALSE,
145: P_VALIDATION_LEVEL IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
146: P_ROWID IN OUT NOCOPY VARCHAR2,
147: P_ASSOCIATION_ID NUMBER,
148: P_APPLICATION_ID NUMBER,
149: P_DESCRIPTIVE_FLEXFIELD_NAME VARCHAR2,
204:
205:
206: PROCEDURE UPDATE_ROW(
207: P_API_VERSION IN NUMBER,
208: P_INIT_MSG_LIST IN VARCHAR2 := FND_API.G_FALSE,
209: P_COMMIT IN VARCHAR2 := FND_API.G_FALSE,
210: P_VALIDATION_LEVEL IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
211: P_ROWID IN OUT NOCOPY VARCHAR2,
212: P_C_ATTRIBUTE1 VARCHAR2,
205:
206: PROCEDURE UPDATE_ROW(
207: P_API_VERSION IN NUMBER,
208: P_INIT_MSG_LIST IN VARCHAR2 := FND_API.G_FALSE,
209: P_COMMIT IN VARCHAR2 := FND_API.G_FALSE,
210: P_VALIDATION_LEVEL IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
211: P_ROWID IN OUT NOCOPY VARCHAR2,
212: P_C_ATTRIBUTE1 VARCHAR2,
213: P_C_ATTRIBUTE2 VARCHAR2,
206: PROCEDURE UPDATE_ROW(
207: P_API_VERSION IN NUMBER,
208: P_INIT_MSG_LIST IN VARCHAR2 := FND_API.G_FALSE,
209: P_COMMIT IN VARCHAR2 := FND_API.G_FALSE,
210: P_VALIDATION_LEVEL IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
211: P_ROWID IN OUT NOCOPY VARCHAR2,
212: P_C_ATTRIBUTE1 VARCHAR2,
213: P_C_ATTRIBUTE2 VARCHAR2,
214: P_C_ATTRIBUTE3 VARCHAR2,
267:
268:
269: PROCEDURE DELETE_ROW(
270: P_API_VERSION IN NUMBER,
271: P_INIT_MSG_LIST IN VARCHAR2 := FND_API.G_FALSE,
272: P_COMMIT IN VARCHAR2 := FND_API.G_FALSE,
273: P_VALIDATION_LEVEL IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
274: P_ROWID IN OUT NOCOPY VARCHAR2,
275: X_RETURN_STATUS OUT NOCOPY VARCHAR2,
268:
269: PROCEDURE DELETE_ROW(
270: P_API_VERSION IN NUMBER,
271: P_INIT_MSG_LIST IN VARCHAR2 := FND_API.G_FALSE,
272: P_COMMIT IN VARCHAR2 := FND_API.G_FALSE,
273: P_VALIDATION_LEVEL IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
274: P_ROWID IN OUT NOCOPY VARCHAR2,
275: X_RETURN_STATUS OUT NOCOPY VARCHAR2,
276: X_MSG_COUNT OUT NOCOPY NUMBER,
269: PROCEDURE DELETE_ROW(
270: P_API_VERSION IN NUMBER,
271: P_INIT_MSG_LIST IN VARCHAR2 := FND_API.G_FALSE,
272: P_COMMIT IN VARCHAR2 := FND_API.G_FALSE,
273: P_VALIDATION_LEVEL IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
274: P_ROWID IN OUT NOCOPY VARCHAR2,
275: X_RETURN_STATUS OUT NOCOPY VARCHAR2,
276: X_MSG_COUNT OUT NOCOPY NUMBER,
277: X_MSG_DATA OUT NOCOPY VARCHAR2);
279:
280:
281: PROCEDURE COPY_ATTRIBUTE(
282: P_API_VERSION IN NUMBER,
283: P_INIT_MSG_LIST IN VARCHAR2 := FND_API.G_FALSE,
284: P_COMMIT IN VARCHAR2 := FND_API.G_FALSE,
285: P_VALIDATION_LEVEL IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
286: P_INVENTORY_ITEM_ID IN NUMBER,
287: P_ORGANIZATION_ID IN NUMBER,
280:
281: PROCEDURE COPY_ATTRIBUTE(
282: P_API_VERSION IN NUMBER,
283: P_INIT_MSG_LIST IN VARCHAR2 := FND_API.G_FALSE,
284: P_COMMIT IN VARCHAR2 := FND_API.G_FALSE,
285: P_VALIDATION_LEVEL IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
286: P_INVENTORY_ITEM_ID IN NUMBER,
287: P_ORGANIZATION_ID IN NUMBER,
288: P_SERIAL_NUMBER_FROM IN VARCHAR2,
281: PROCEDURE COPY_ATTRIBUTE(
282: P_API_VERSION IN NUMBER,
283: P_INIT_MSG_LIST IN VARCHAR2 := FND_API.G_FALSE,
284: P_COMMIT IN VARCHAR2 := FND_API.G_FALSE,
285: P_VALIDATION_LEVEL IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
286: P_INVENTORY_ITEM_ID IN NUMBER,
287: P_ORGANIZATION_ID IN NUMBER,
288: P_SERIAL_NUMBER_FROM IN VARCHAR2,
289: P_SERIAL_NUMBER_TO IN VARCHAR2,