DBA Data[Home] [Help]

APPS.EAM_ASSET_NUMBER_PVT dependencies on FND_API

Line 11: -- DEFAULT = FND_API.G_FALSE

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

Line 13: -- DEFAULT = FND_API.G_FALSE

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_INVENTORY_ITEM_ID IN NUMBER
17: -- P_SERIAL_NUMBER IN VARCHAR2

Line 15: -- DEFAULT = FND_API.G_VALID_LEVEL_FULL

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_INVENTORY_ITEM_ID IN NUMBER
17: -- P_SERIAL_NUMBER IN VARCHAR2
18: -- P_INSTANCE_NUMBER VARCHAR2,
19: -- P_START_DATE_ACTIVE IN DATE

Line 70: P_INIT_MSG_LIST IN VARCHAR2 := FND_API.G_FALSE,

66: /* Create a Row for an Asset Number in CSI_ITEM_INSTANCES */
67:
68: PROCEDURE INSERT_ROW(
69: P_API_VERSION IN NUMBER,
70: P_INIT_MSG_LIST IN VARCHAR2 := FND_API.G_FALSE,
71: P_COMMIT IN VARCHAR2 := FND_API.G_FALSE,
72: P_VALIDATION_LEVEL IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
73: P_INVENTORY_ITEM_ID NUMBER,
74: P_SERIAL_NUMBER VARCHAR2,

Line 71: P_COMMIT IN VARCHAR2 := FND_API.G_FALSE,

67:
68: PROCEDURE INSERT_ROW(
69: P_API_VERSION IN NUMBER,
70: P_INIT_MSG_LIST IN VARCHAR2 := FND_API.G_FALSE,
71: P_COMMIT IN VARCHAR2 := FND_API.G_FALSE,
72: P_VALIDATION_LEVEL IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
73: P_INVENTORY_ITEM_ID NUMBER,
74: P_SERIAL_NUMBER VARCHAR2,
75: P_INSTANCE_NUMBER VARCHAR2,

Line 72: P_VALIDATION_LEVEL IN NUMBER := FND_API.G_VALID_LEVEL_FULL,

68: PROCEDURE INSERT_ROW(
69: P_API_VERSION IN NUMBER,
70: P_INIT_MSG_LIST IN VARCHAR2 := FND_API.G_FALSE,
71: P_COMMIT IN VARCHAR2 := FND_API.G_FALSE,
72: P_VALIDATION_LEVEL IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
73: P_INVENTORY_ITEM_ID NUMBER,
74: P_SERIAL_NUMBER VARCHAR2,
75: P_INSTANCE_NUMBER VARCHAR2,
76: P_INSTANCE_DESCRIPTION VARCHAR2,

Line 144: P_INIT_MSG_LIST IN VARCHAR2 := FND_API.G_FALSE,

140:
141: /* Update an Asset Row in CSI_ITEM_INSTANCES */
142: PROCEDURE UPDATE_ROW(
143: P_API_VERSION IN NUMBER,
144: P_INIT_MSG_LIST IN VARCHAR2 := FND_API.G_FALSE,
145: P_COMMIT IN VARCHAR2 := FND_API.G_FALSE,
146: P_VALIDATION_LEVEL IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
147: p_instance_id IN NUMBER,
148: P_INSTANCE_DESCRIPTION VARCHAR2,

Line 145: P_COMMIT IN VARCHAR2 := FND_API.G_FALSE,

141: /* Update an Asset Row in CSI_ITEM_INSTANCES */
142: PROCEDURE UPDATE_ROW(
143: P_API_VERSION IN NUMBER,
144: P_INIT_MSG_LIST IN VARCHAR2 := FND_API.G_FALSE,
145: P_COMMIT IN VARCHAR2 := FND_API.G_FALSE,
146: P_VALIDATION_LEVEL IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
147: p_instance_id IN NUMBER,
148: P_INSTANCE_DESCRIPTION VARCHAR2,
149: P_CATEGORY_ID NUMBER,

Line 146: P_VALIDATION_LEVEL IN NUMBER := FND_API.G_VALID_LEVEL_FULL,

142: PROCEDURE UPDATE_ROW(
143: P_API_VERSION IN NUMBER,
144: P_INIT_MSG_LIST IN VARCHAR2 := FND_API.G_FALSE,
145: P_COMMIT IN VARCHAR2 := FND_API.G_FALSE,
146: P_VALIDATION_LEVEL IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
147: p_instance_id IN NUMBER,
148: P_INSTANCE_DESCRIPTION VARCHAR2,
149: P_CATEGORY_ID NUMBER,
150: P_PN_LOCATION_ID NUMBER,

Line 215: P_INIT_MSG_LIST IN VARCHAR2 := FND_API.G_FALSE,

211:
212: PROCEDURE LOCK_ROW(
213:
214: P_API_VERSION IN NUMBER,
215: P_INIT_MSG_LIST IN VARCHAR2 := FND_API.G_FALSE,
216: P_COMMIT IN VARCHAR2 := FND_API.G_FALSE,
217: P_VALIDATION_LEVEL IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
218: P_ROWID VARCHAR2,
219: P_INSTANCE_ID IN NUMBER,

Line 216: P_COMMIT IN VARCHAR2 := FND_API.G_FALSE,

212: PROCEDURE LOCK_ROW(
213:
214: P_API_VERSION IN NUMBER,
215: P_INIT_MSG_LIST IN VARCHAR2 := FND_API.G_FALSE,
216: P_COMMIT IN VARCHAR2 := FND_API.G_FALSE,
217: P_VALIDATION_LEVEL IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
218: P_ROWID VARCHAR2,
219: P_INSTANCE_ID IN NUMBER,
220: P_INSTANCE_NUMBER VARCHAR2 DEFAULT NULL,

Line 217: P_VALIDATION_LEVEL IN NUMBER := FND_API.G_VALID_LEVEL_FULL,

213:
214: P_API_VERSION IN NUMBER,
215: P_INIT_MSG_LIST IN VARCHAR2 := FND_API.G_FALSE,
216: P_COMMIT IN VARCHAR2 := FND_API.G_FALSE,
217: P_VALIDATION_LEVEL IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
218: P_ROWID VARCHAR2,
219: P_INSTANCE_ID IN NUMBER,
220: P_INSTANCE_NUMBER VARCHAR2 DEFAULT NULL,
221: P_INSTANCE_DESCRIPTION VARCHAR2,

Line 281: ,P_INIT_MSG_LIST IN VARCHAR2 := FND_API.G_FALSE

277:
278: /* Create an Asset Number along with its maintenance Attributes */
279: PROCEDURE CREATE_ASSET(
280: P_API_VERSION IN NUMBER
281: ,P_INIT_MSG_LIST IN VARCHAR2 := FND_API.G_FALSE
282: ,P_COMMIT IN VARCHAR2 := FND_API.G_FALSE
283: ,P_VALIDATION_LEVEL IN NUMBER := FND_API.G_VALID_LEVEL_FULL
284: ,P_INVENTORY_ITEM_ID NUMBER
285: ,P_SERIAL_NUMBER VARCHAR2

Line 282: ,P_COMMIT IN VARCHAR2 := FND_API.G_FALSE

278: /* Create an Asset Number along with its maintenance Attributes */
279: PROCEDURE CREATE_ASSET(
280: P_API_VERSION IN NUMBER
281: ,P_INIT_MSG_LIST IN VARCHAR2 := FND_API.G_FALSE
282: ,P_COMMIT IN VARCHAR2 := FND_API.G_FALSE
283: ,P_VALIDATION_LEVEL IN NUMBER := FND_API.G_VALID_LEVEL_FULL
284: ,P_INVENTORY_ITEM_ID NUMBER
285: ,P_SERIAL_NUMBER VARCHAR2
286: ,P_INSTANCE_NUMBER VARCHAR2

Line 283: ,P_VALIDATION_LEVEL IN NUMBER := FND_API.G_VALID_LEVEL_FULL

279: PROCEDURE CREATE_ASSET(
280: P_API_VERSION IN NUMBER
281: ,P_INIT_MSG_LIST IN VARCHAR2 := FND_API.G_FALSE
282: ,P_COMMIT IN VARCHAR2 := FND_API.G_FALSE
283: ,P_VALIDATION_LEVEL IN NUMBER := FND_API.G_VALID_LEVEL_FULL
284: ,P_INVENTORY_ITEM_ID NUMBER
285: ,P_SERIAL_NUMBER VARCHAR2
286: ,P_INSTANCE_NUMBER VARCHAR2
287: ,P_INSTANCE_DESCRIPTION VARCHAR2

Line 357: ,P_INIT_MSG_LIST IN VARCHAR2 := FND_API.G_FALSE

353:
354: /* Update an Asset Number along with its maintenance Attributes */
355: procedure update_asset(
356: P_API_VERSION IN NUMBER
357: ,P_INIT_MSG_LIST IN VARCHAR2 := FND_API.G_FALSE
358: ,P_COMMIT IN VARCHAR2 := FND_API.G_FALSE
359: ,P_VALIDATION_LEVEL IN NUMBER := FND_API.G_VALID_LEVEL_FULL
360: ,p_instance_id IN NUMBER DEFAULT NULL
361: ,P_INSTANCE_DESCRIPTION VARCHAR2 DEFAULT NULL

Line 358: ,P_COMMIT IN VARCHAR2 := FND_API.G_FALSE

354: /* Update an Asset Number along with its maintenance Attributes */
355: procedure update_asset(
356: P_API_VERSION IN NUMBER
357: ,P_INIT_MSG_LIST IN VARCHAR2 := FND_API.G_FALSE
358: ,P_COMMIT IN VARCHAR2 := FND_API.G_FALSE
359: ,P_VALIDATION_LEVEL IN NUMBER := FND_API.G_VALID_LEVEL_FULL
360: ,p_instance_id IN NUMBER DEFAULT NULL
361: ,P_INSTANCE_DESCRIPTION VARCHAR2 DEFAULT NULL
362: ,P_INVENTORY_ITEM_ID NUMBER

Line 359: ,P_VALIDATION_LEVEL IN NUMBER := FND_API.G_VALID_LEVEL_FULL

355: procedure update_asset(
356: P_API_VERSION IN NUMBER
357: ,P_INIT_MSG_LIST IN VARCHAR2 := FND_API.G_FALSE
358: ,P_COMMIT IN VARCHAR2 := FND_API.G_FALSE
359: ,P_VALIDATION_LEVEL IN NUMBER := FND_API.G_VALID_LEVEL_FULL
360: ,p_instance_id IN NUMBER DEFAULT NULL
361: ,P_INSTANCE_DESCRIPTION VARCHAR2 DEFAULT NULL
362: ,P_INVENTORY_ITEM_ID NUMBER
363: ,P_SERIAL_NUMBER VARCHAR2

Line 432: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,

428: );
429:
430: PROCEDURE SERIAL_CHECK(
431: p_api_version IN NUMBER,
432: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
433: p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
434: p_validation_level IN NUMBER DEFAULT FND_API.G_VALID_LEVEL_FULL,
435: x_return_status OUT NOCOPY VARCHAR2,
436: x_msg_count OUT NOCOPY NUMBER,

Line 433: p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,

429:
430: PROCEDURE SERIAL_CHECK(
431: p_api_version IN NUMBER,
432: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
433: p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
434: p_validation_level IN NUMBER DEFAULT FND_API.G_VALID_LEVEL_FULL,
435: x_return_status OUT NOCOPY VARCHAR2,
436: x_msg_count OUT NOCOPY NUMBER,
437: x_msg_data OUT NOCOPY VARCHAR2,

Line 434: p_validation_level IN NUMBER DEFAULT FND_API.G_VALID_LEVEL_FULL,

430: PROCEDURE SERIAL_CHECK(
431: p_api_version IN NUMBER,
432: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
433: p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
434: p_validation_level IN NUMBER DEFAULT FND_API.G_VALID_LEVEL_FULL,
435: x_return_status OUT NOCOPY VARCHAR2,
436: x_msg_count OUT NOCOPY NUMBER,
437: x_msg_data OUT NOCOPY VARCHAR2,
438: x_errorcode OUT NOCOPY NUMBER,