DBA Data[Home] [Help]

APPS.INV_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_ROWID IN OUT VARCHAR2 REQUIRED
17: -- P_INVENTORY_ITEM_ID IN NUMBER

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

Line 75: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,

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,

Line 76: p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,

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,

Line 77: p_validation_level IN NUMBER DEFAULT FND_API.G_VALID_LEVEL_FULL,

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,

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

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,

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

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,

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

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,

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

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,

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

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,

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

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,

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

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,

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

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,

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

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,