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_ATTRIBUTE_ASSOCIATION_ID IN NUMBER 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_ROWID IN OUT VARCHAR2 REQUIRED
17: -- P_ATTRIBUTE_ASSOCIATION_ID IN NUMBER REQUIRED
18: -- P_APPLICATION_ID IN NUMBER REQUIRED
19: -- P_FLEXFIELD_NAME IN VARCHAR2(40) REQUIRED
42:
43:
44: PROCEDURE INSERT_ROW(
45: P_API_VERSION IN NUMBER,
46: P_INIT_MSG_LIST IN VARCHAR2 := FND_API.G_FALSE,
47: P_COMMIT IN VARCHAR2 := FND_API.G_FALSE,
48: P_VALIDATION_LEVEL IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
49: P_ROWID IN OUT NOCOPY VARCHAR2,
50: P_ATTRIBUTE_ASSOCIATION_ID IN OUT NOCOPY NUMBER,
43:
44: PROCEDURE INSERT_ROW(
45: P_API_VERSION IN NUMBER,
46: P_INIT_MSG_LIST IN VARCHAR2 := FND_API.G_FALSE,
47: P_COMMIT IN VARCHAR2 := FND_API.G_FALSE,
48: P_VALIDATION_LEVEL IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
49: P_ROWID IN OUT NOCOPY VARCHAR2,
50: P_ATTRIBUTE_ASSOCIATION_ID IN OUT NOCOPY NUMBER,
51: P_APPLICATION_ID NUMBER,
44: PROCEDURE INSERT_ROW(
45: P_API_VERSION IN NUMBER,
46: P_INIT_MSG_LIST IN VARCHAR2 := FND_API.G_FALSE,
47: P_COMMIT IN VARCHAR2 := FND_API.G_FALSE,
48: P_VALIDATION_LEVEL IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
49: P_ROWID IN OUT NOCOPY VARCHAR2,
50: P_ATTRIBUTE_ASSOCIATION_ID IN OUT NOCOPY NUMBER,
51: P_APPLICATION_ID NUMBER,
52: P_FLEXFIELD_NAME VARCHAR2,
67:
68:
69: PROCEDURE LOCK_ROW(
70: P_API_VERSION IN NUMBER,
71: P_INIT_MSG_LIST IN VARCHAR2 := FND_API.G_FALSE,
72: P_COMMIT IN VARCHAR2 := FND_API.G_FALSE,
73: P_VALIDATION_LEVEL IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
74: P_ROWID VARCHAR2,
75: P_ATTRIBUTE_ASSOCIATION_ID IN OUT NOCOPY NUMBER,
68:
69: PROCEDURE LOCK_ROW(
70: P_API_VERSION IN NUMBER,
71: P_INIT_MSG_LIST IN VARCHAR2 := FND_API.G_FALSE,
72: P_COMMIT IN VARCHAR2 := FND_API.G_FALSE,
73: P_VALIDATION_LEVEL IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
74: P_ROWID VARCHAR2,
75: P_ATTRIBUTE_ASSOCIATION_ID IN OUT NOCOPY NUMBER,
76: P_APPLICATION_ID NUMBER,
69: PROCEDURE LOCK_ROW(
70: P_API_VERSION IN NUMBER,
71: P_INIT_MSG_LIST IN VARCHAR2 := FND_API.G_FALSE,
72: P_COMMIT IN VARCHAR2 := FND_API.G_FALSE,
73: P_VALIDATION_LEVEL IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
74: P_ROWID VARCHAR2,
75: P_ATTRIBUTE_ASSOCIATION_ID IN OUT NOCOPY NUMBER,
76: P_APPLICATION_ID NUMBER,
77: P_FLEXFIELD_NAME VARCHAR2,
85:
86:
87: PROCEDURE UPDATE_ROW(
88: P_API_VERSION IN NUMBER,
89: P_INIT_MSG_LIST IN VARCHAR2 := FND_API.G_FALSE,
90: P_COMMIT IN VARCHAR2 := FND_API.G_FALSE,
91: P_VALIDATION_LEVEL IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
92: P_ROWID VARCHAR2,
93: P_ENABLED_FLAG VARCHAR2,
86:
87: PROCEDURE UPDATE_ROW(
88: P_API_VERSION IN NUMBER,
89: P_INIT_MSG_LIST IN VARCHAR2 := FND_API.G_FALSE,
90: P_COMMIT IN VARCHAR2 := FND_API.G_FALSE,
91: P_VALIDATION_LEVEL IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
92: P_ROWID VARCHAR2,
93: P_ENABLED_FLAG VARCHAR2,
94: P_LAST_UPDATE_DATE DATE,
87: PROCEDURE UPDATE_ROW(
88: P_API_VERSION IN NUMBER,
89: P_INIT_MSG_LIST IN VARCHAR2 := FND_API.G_FALSE,
90: P_COMMIT IN VARCHAR2 := FND_API.G_FALSE,
91: P_VALIDATION_LEVEL IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
92: P_ROWID VARCHAR2,
93: P_ENABLED_FLAG VARCHAR2,
94: P_LAST_UPDATE_DATE DATE,
95: P_LAST_UPDATED_BY NUMBER,