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_ACTIVITY_ASSOCIATION_ID IN OUT 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_ACTIVITY_ASSOCIATION_ID IN OUT NUMBER REQUIRED
18: -- P_ORGANIZATION_ID IN NUMBER REQUIRED
19: -- P_ASSET_ACTIVITY_ID IN NUMBER REQUIRED
62:
63:
64: PROCEDURE INSERT_ROW(
65: P_API_VERSION IN NUMBER,
66: P_INIT_MSG_LIST IN VARCHAR2 := FND_API.G_FALSE,
67: P_COMMIT IN VARCHAR2 := FND_API.G_FALSE,
68: P_VALIDATION_LEVEL IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
69: P_ROWID IN OUT NOCOPY VARCHAR2,
70: P_ACTIVITY_ASSOCIATION_ID IN OUT NOCOPY NUMBER,
63:
64: PROCEDURE INSERT_ROW(
65: P_API_VERSION IN NUMBER,
66: P_INIT_MSG_LIST IN VARCHAR2 := FND_API.G_FALSE,
67: P_COMMIT IN VARCHAR2 := FND_API.G_FALSE,
68: P_VALIDATION_LEVEL IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
69: P_ROWID IN OUT NOCOPY VARCHAR2,
70: P_ACTIVITY_ASSOCIATION_ID IN OUT NOCOPY NUMBER,
71: P_ORGANIZATION_ID NUMBER,
64: PROCEDURE INSERT_ROW(
65: P_API_VERSION IN NUMBER,
66: P_INIT_MSG_LIST IN VARCHAR2 := FND_API.G_FALSE,
67: P_COMMIT IN VARCHAR2 := FND_API.G_FALSE,
68: P_VALIDATION_LEVEL IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
69: P_ROWID IN OUT NOCOPY VARCHAR2,
70: P_ACTIVITY_ASSOCIATION_ID IN OUT NOCOPY NUMBER,
71: P_ORGANIZATION_ID NUMBER,
72: P_ASSET_ACTIVITY_ID NUMBER,
123:
124:
125: PROCEDURE LOCK_ROW(
126: P_API_VERSION IN NUMBER,
127: P_INIT_MSG_LIST IN VARCHAR2 := FND_API.G_FALSE,
128: P_COMMIT IN VARCHAR2 := FND_API.G_FALSE,
129: P_VALIDATION_LEVEL IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
130: P_ROWID VARCHAR2,
131: P_ACTIVITY_ASSOCIATION_ID NUMBER,
124:
125: PROCEDURE LOCK_ROW(
126: P_API_VERSION IN NUMBER,
127: P_INIT_MSG_LIST IN VARCHAR2 := FND_API.G_FALSE,
128: P_COMMIT IN VARCHAR2 := FND_API.G_FALSE,
129: P_VALIDATION_LEVEL IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
130: P_ROWID VARCHAR2,
131: P_ACTIVITY_ASSOCIATION_ID NUMBER,
132: P_ORGANIZATION_ID NUMBER,
125: PROCEDURE LOCK_ROW(
126: P_API_VERSION IN NUMBER,
127: P_INIT_MSG_LIST IN VARCHAR2 := FND_API.G_FALSE,
128: P_COMMIT IN VARCHAR2 := FND_API.G_FALSE,
129: P_VALIDATION_LEVEL IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
130: P_ROWID VARCHAR2,
131: P_ACTIVITY_ASSOCIATION_ID NUMBER,
132: P_ORGANIZATION_ID NUMBER,
133: P_ASSET_ACTIVITY_ID NUMBER,
171:
172:
173: PROCEDURE UPDATE_ROW(
174: P_API_VERSION IN NUMBER,
175: P_INIT_MSG_LIST IN VARCHAR2 := FND_API.G_FALSE,
176: P_COMMIT IN VARCHAR2 := FND_API.G_FALSE,
177: P_VALIDATION_LEVEL IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
178: P_ROWID VARCHAR2,
179: P_ACTIVITY_ASSOCIATION_ID NUMBER,
172:
173: PROCEDURE UPDATE_ROW(
174: P_API_VERSION IN NUMBER,
175: P_INIT_MSG_LIST IN VARCHAR2 := FND_API.G_FALSE,
176: P_COMMIT IN VARCHAR2 := FND_API.G_FALSE,
177: P_VALIDATION_LEVEL IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
178: P_ROWID VARCHAR2,
179: P_ACTIVITY_ASSOCIATION_ID NUMBER,
180: P_ORGANIZATION_ID NUMBER,
173: PROCEDURE UPDATE_ROW(
174: P_API_VERSION IN NUMBER,
175: P_INIT_MSG_LIST IN VARCHAR2 := FND_API.G_FALSE,
176: P_COMMIT IN VARCHAR2 := FND_API.G_FALSE,
177: P_VALIDATION_LEVEL IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
178: P_ROWID VARCHAR2,
179: P_ACTIVITY_ASSOCIATION_ID NUMBER,
180: P_ORGANIZATION_ID NUMBER,
181: P_ASSET_ACTIVITY_ID NUMBER,