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_DEPT_ID IN NUMBER REQUIRED
17: -- P_LAST_UPDATE_DATE IN DATE REQUIRED
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_DEPT_ID IN NUMBER REQUIRED
17: -- P_LAST_UPDATE_DATE IN DATE REQUIRED
18: -- P_LAST_UPDATED_BY IN NUMBER REQUIRED
19: -- P_CREATION_DATE IN DATE REQUIRED
34:
35:
36: PROCEDURE INSERT_ROW(
37: P_API_VERSION IN NUMBER,
38: P_INIT_MSG_LIST IN VARCHAR2 := FND_API.G_FALSE,
39: P_COMMIT IN VARCHAR2 := FND_API.G_FALSE,
40: P_VALIDATION_LEVEL IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
41: P_ROWID IN OUT NOCOPY VARCHAR2,
42: P_DEPT_ID NUMBER,
35:
36: PROCEDURE INSERT_ROW(
37: P_API_VERSION IN NUMBER,
38: P_INIT_MSG_LIST IN VARCHAR2 := FND_API.G_FALSE,
39: P_COMMIT IN VARCHAR2 := FND_API.G_FALSE,
40: P_VALIDATION_LEVEL IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
41: P_ROWID IN OUT NOCOPY VARCHAR2,
42: P_DEPT_ID NUMBER,
43: P_ORGANIZATION_ID NUMBER,
36: PROCEDURE INSERT_ROW(
37: P_API_VERSION IN NUMBER,
38: P_INIT_MSG_LIST IN VARCHAR2 := FND_API.G_FALSE,
39: P_COMMIT IN VARCHAR2 := FND_API.G_FALSE,
40: P_VALIDATION_LEVEL IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
41: P_ROWID IN OUT NOCOPY VARCHAR2,
42: P_DEPT_ID NUMBER,
43: P_ORGANIZATION_ID NUMBER,
44: P_LAST_UPDATE_DATE DATE,
54: X_MSG_DATA OUT NOCOPY VARCHAR2);
55:
56: PROCEDURE LOCK_ROW(
57: P_API_VERSION IN NUMBER,
58: P_INIT_MSG_LIST IN VARCHAR2 := FND_API.G_FALSE,
59: P_COMMIT IN VARCHAR2 := FND_API.G_FALSE,
60: P_VALIDATION_LEVEL IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
61: P_ROWID IN OUT NOCOPY VARCHAR2,
62: P_DEPT_ID NUMBER,
55:
56: PROCEDURE LOCK_ROW(
57: P_API_VERSION IN NUMBER,
58: P_INIT_MSG_LIST IN VARCHAR2 := FND_API.G_FALSE,
59: P_COMMIT IN VARCHAR2 := FND_API.G_FALSE,
60: P_VALIDATION_LEVEL IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
61: P_ROWID IN OUT NOCOPY VARCHAR2,
62: P_DEPT_ID NUMBER,
63: P_ORGANIZATION_ID NUMBER,
56: PROCEDURE LOCK_ROW(
57: P_API_VERSION IN NUMBER,
58: P_INIT_MSG_LIST IN VARCHAR2 := FND_API.G_FALSE,
59: P_COMMIT IN VARCHAR2 := FND_API.G_FALSE,
60: P_VALIDATION_LEVEL IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
61: P_ROWID IN OUT NOCOPY VARCHAR2,
62: P_DEPT_ID NUMBER,
63: P_ORGANIZATION_ID NUMBER,
64: P_LAST_UPDATE_DATE DATE,
73: X_MSG_DATA OUT NOCOPY VARCHAR2);
74:
75: PROCEDURE UPDATE_ROW(
76: P_API_VERSION IN NUMBER,
77: P_INIT_MSG_LIST IN VARCHAR2 := FND_API.G_FALSE,
78: P_COMMIT IN VARCHAR2 := FND_API.G_FALSE,
79: P_VALIDATION_LEVEL IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
80: P_ROWID IN OUT NOCOPY VARCHAR2,
81: P_DEPT_ID NUMBER,
74:
75: PROCEDURE UPDATE_ROW(
76: P_API_VERSION IN NUMBER,
77: P_INIT_MSG_LIST IN VARCHAR2 := FND_API.G_FALSE,
78: P_COMMIT IN VARCHAR2 := FND_API.G_FALSE,
79: P_VALIDATION_LEVEL IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
80: P_ROWID IN OUT NOCOPY VARCHAR2,
81: P_DEPT_ID NUMBER,
82: P_ORGANIZATION_ID NUMBER,
75: PROCEDURE UPDATE_ROW(
76: P_API_VERSION IN NUMBER,
77: P_INIT_MSG_LIST IN VARCHAR2 := FND_API.G_FALSE,
78: P_COMMIT IN VARCHAR2 := FND_API.G_FALSE,
79: P_VALIDATION_LEVEL IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
80: P_ROWID IN OUT NOCOPY VARCHAR2,
81: P_DEPT_ID NUMBER,
82: P_ORGANIZATION_ID NUMBER,
83: P_LAST_UPDATE_DATE DATE,