2: /* $Header: astvwuas.pls 115.3 2002/02/06 11:21:42 pkm ship $ */
3:
4: PROCEDURE INSERT_OUTCOME(
5: P_API_VERSION IN NUMBER,
6: P_INIT_MSG_LIST IN VARCHAR2 := FND_API.G_FALSE,
7: P_COMMIT IN VARCHAR2 := FND_API.G_FALSE,
8: P_VALIDATION_LEVEL IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
9: X_RETURN_STATUS OUT VARCHAR2,
10: X_MSG_COUNT OUT NUMBER,
3:
4: PROCEDURE INSERT_OUTCOME(
5: P_API_VERSION IN NUMBER,
6: P_INIT_MSG_LIST IN VARCHAR2 := FND_API.G_FALSE,
7: P_COMMIT IN VARCHAR2 := FND_API.G_FALSE,
8: P_VALIDATION_LEVEL IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
9: X_RETURN_STATUS OUT VARCHAR2,
10: X_MSG_COUNT OUT NUMBER,
11: X_MSG_DATA OUT VARCHAR2,
4: PROCEDURE INSERT_OUTCOME(
5: P_API_VERSION IN NUMBER,
6: P_INIT_MSG_LIST IN VARCHAR2 := FND_API.G_FALSE,
7: P_COMMIT IN VARCHAR2 := FND_API.G_FALSE,
8: P_VALIDATION_LEVEL IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
9: X_RETURN_STATUS OUT VARCHAR2,
10: X_MSG_COUNT OUT NUMBER,
11: X_MSG_DATA OUT VARCHAR2,
12: P_RESULT_REQUIRED IN VARCHAR2,
24: );
25:
26: PROCEDURE UPDATE_OUTCOME(
27: P_API_VERSION IN NUMBER,
28: P_INIT_MSG_LIST IN VARCHAR2 := FND_API.G_FALSE,
29: P_COMMIT IN VARCHAR2 := FND_API.G_FALSE,
30: P_VALIDATION_LEVEL IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
31: X_RETURN_STATUS OUT VARCHAR2,
32: X_MSG_COUNT OUT NUMBER,
25:
26: PROCEDURE UPDATE_OUTCOME(
27: P_API_VERSION IN NUMBER,
28: P_INIT_MSG_LIST IN VARCHAR2 := FND_API.G_FALSE,
29: P_COMMIT IN VARCHAR2 := FND_API.G_FALSE,
30: P_VALIDATION_LEVEL IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
31: X_RETURN_STATUS OUT VARCHAR2,
32: X_MSG_COUNT OUT NUMBER,
33: X_MSG_DATA OUT VARCHAR2,
26: PROCEDURE UPDATE_OUTCOME(
27: P_API_VERSION IN NUMBER,
28: P_INIT_MSG_LIST IN VARCHAR2 := FND_API.G_FALSE,
29: P_COMMIT IN VARCHAR2 := FND_API.G_FALSE,
30: P_VALIDATION_LEVEL IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
31: X_RETURN_STATUS OUT VARCHAR2,
32: X_MSG_COUNT OUT NUMBER,
33: X_MSG_DATA OUT VARCHAR2,
34: P_OUTCOME_ID IN NUMBER,
46: );
47:
48: PROCEDURE INSERT_RESULT(
49: P_API_VERSION IN NUMBER,
50: P_INIT_MSG_LIST IN VARCHAR2 := FND_API.G_FALSE,
51: P_COMMIT IN VARCHAR2 := FND_API.G_FALSE,
52: P_VALIDATION_LEVEL IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
53: X_RETURN_STATUS OUT VARCHAR2,
54: X_MSG_COUNT OUT NUMBER,
47:
48: PROCEDURE INSERT_RESULT(
49: P_API_VERSION IN NUMBER,
50: P_INIT_MSG_LIST IN VARCHAR2 := FND_API.G_FALSE,
51: P_COMMIT IN VARCHAR2 := FND_API.G_FALSE,
52: P_VALIDATION_LEVEL IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
53: X_RETURN_STATUS OUT VARCHAR2,
54: X_MSG_COUNT OUT NUMBER,
55: X_MSG_DATA OUT VARCHAR2,
48: PROCEDURE INSERT_RESULT(
49: P_API_VERSION IN NUMBER,
50: P_INIT_MSG_LIST IN VARCHAR2 := FND_API.G_FALSE,
51: P_COMMIT IN VARCHAR2 := FND_API.G_FALSE,
52: P_VALIDATION_LEVEL IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
53: X_RETURN_STATUS OUT VARCHAR2,
54: X_MSG_COUNT OUT NUMBER,
55: X_MSG_DATA OUT VARCHAR2,
56: P_REASON_REQUIRED IN VARCHAR2,
67: );
68:
69: PROCEDURE UPDATE_RESULT(
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: X_RETURN_STATUS OUT VARCHAR2,
75: X_MSG_COUNT OUT NUMBER,
68:
69: PROCEDURE UPDATE_RESULT(
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: X_RETURN_STATUS OUT VARCHAR2,
75: X_MSG_COUNT OUT NUMBER,
76: X_MSG_DATA OUT VARCHAR2,
69: PROCEDURE UPDATE_RESULT(
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: X_RETURN_STATUS OUT VARCHAR2,
75: X_MSG_COUNT OUT NUMBER,
76: X_MSG_DATA OUT VARCHAR2,
77: P_RESULT_ID IN NUMBER,
88: );
89:
90: PROCEDURE INSERT_REASON(
91: P_API_VERSION IN NUMBER,
92: P_INIT_MSG_LIST IN VARCHAR2 := FND_API.G_FALSE,
93: P_COMMIT IN VARCHAR2 := FND_API.G_FALSE,
94: P_VALIDATION_LEVEL IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
95: X_RETURN_STATUS OUT VARCHAR2,
96: X_MSG_COUNT OUT NUMBER,
89:
90: PROCEDURE INSERT_REASON(
91: P_API_VERSION IN NUMBER,
92: P_INIT_MSG_LIST IN VARCHAR2 := FND_API.G_FALSE,
93: P_COMMIT IN VARCHAR2 := FND_API.G_FALSE,
94: P_VALIDATION_LEVEL IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
95: X_RETURN_STATUS OUT VARCHAR2,
96: X_MSG_COUNT OUT NUMBER,
97: X_MSG_DATA OUT VARCHAR2,
90: PROCEDURE INSERT_REASON(
91: P_API_VERSION IN NUMBER,
92: P_INIT_MSG_LIST IN VARCHAR2 := FND_API.G_FALSE,
93: P_COMMIT IN VARCHAR2 := FND_API.G_FALSE,
94: P_VALIDATION_LEVEL IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
95: X_RETURN_STATUS OUT VARCHAR2,
96: X_MSG_COUNT OUT NUMBER,
97: X_MSG_DATA OUT VARCHAR2,
98: P_VERSATILITY_CODE IN NUMBER,
107: );
108:
109: PROCEDURE UPDATE_REASON(
110: P_API_VERSION IN NUMBER,
111: P_INIT_MSG_LIST IN VARCHAR2 := FND_API.G_FALSE,
112: P_COMMIT IN VARCHAR2 := FND_API.G_FALSE,
113: P_VALIDATION_LEVEL IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
114: X_RETURN_STATUS OUT VARCHAR2,
115: X_MSG_COUNT OUT NUMBER,
108:
109: PROCEDURE UPDATE_REASON(
110: P_API_VERSION IN NUMBER,
111: P_INIT_MSG_LIST IN VARCHAR2 := FND_API.G_FALSE,
112: P_COMMIT IN VARCHAR2 := FND_API.G_FALSE,
113: P_VALIDATION_LEVEL IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
114: X_RETURN_STATUS OUT VARCHAR2,
115: X_MSG_COUNT OUT NUMBER,
116: X_MSG_DATA OUT VARCHAR2,
109: PROCEDURE UPDATE_REASON(
110: P_API_VERSION IN NUMBER,
111: P_INIT_MSG_LIST IN VARCHAR2 := FND_API.G_FALSE,
112: P_COMMIT IN VARCHAR2 := FND_API.G_FALSE,
113: P_VALIDATION_LEVEL IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
114: X_RETURN_STATUS OUT VARCHAR2,
115: X_MSG_COUNT OUT NUMBER,
116: X_MSG_DATA OUT VARCHAR2,
117: P_REASON_ID IN NUMBER,
126: );
127:
128: PROCEDURE ALTER_OUTCOME_RESULT_LINK(
129: P_API_VERSION IN NUMBER,
130: P_INIT_MSG_LIST IN VARCHAR2 := FND_API.G_FALSE,
131: P_COMMIT IN VARCHAR2 := FND_API.G_FALSE,
132: P_VALIDATION_LEVEL IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
133: X_RETURN_STATUS OUT VARCHAR2,
134: X_MSG_COUNT OUT NUMBER,
127:
128: PROCEDURE ALTER_OUTCOME_RESULT_LINK(
129: P_API_VERSION IN NUMBER,
130: P_INIT_MSG_LIST IN VARCHAR2 := FND_API.G_FALSE,
131: P_COMMIT IN VARCHAR2 := FND_API.G_FALSE,
132: P_VALIDATION_LEVEL IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
133: X_RETURN_STATUS OUT VARCHAR2,
134: X_MSG_COUNT OUT NUMBER,
135: X_MSG_DATA OUT VARCHAR2,
128: PROCEDURE ALTER_OUTCOME_RESULT_LINK(
129: P_API_VERSION IN NUMBER,
130: P_INIT_MSG_LIST IN VARCHAR2 := FND_API.G_FALSE,
131: P_COMMIT IN VARCHAR2 := FND_API.G_FALSE,
132: P_VALIDATION_LEVEL IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
133: X_RETURN_STATUS OUT VARCHAR2,
134: X_MSG_COUNT OUT NUMBER,
135: X_MSG_DATA OUT VARCHAR2,
136: P_ACTION IN VARCHAR2,
139: );
140:
141: PROCEDURE ALTER_RESULT_REASON_LINK(
142: P_API_VERSION IN NUMBER,
143: P_INIT_MSG_LIST IN VARCHAR2 := FND_API.G_FALSE,
144: P_COMMIT IN VARCHAR2 := FND_API.G_FALSE,
145: P_VALIDATION_LEVEL IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
146: X_RETURN_STATUS OUT VARCHAR2,
147: X_MSG_COUNT OUT NUMBER,
140:
141: PROCEDURE ALTER_RESULT_REASON_LINK(
142: P_API_VERSION IN NUMBER,
143: P_INIT_MSG_LIST IN VARCHAR2 := FND_API.G_FALSE,
144: P_COMMIT IN VARCHAR2 := FND_API.G_FALSE,
145: P_VALIDATION_LEVEL IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
146: X_RETURN_STATUS OUT VARCHAR2,
147: X_MSG_COUNT OUT NUMBER,
148: X_MSG_DATA OUT VARCHAR2,
141: PROCEDURE ALTER_RESULT_REASON_LINK(
142: P_API_VERSION IN NUMBER,
143: P_INIT_MSG_LIST IN VARCHAR2 := FND_API.G_FALSE,
144: P_COMMIT IN VARCHAR2 := FND_API.G_FALSE,
145: P_VALIDATION_LEVEL IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
146: X_RETURN_STATUS OUT VARCHAR2,
147: X_MSG_COUNT OUT NUMBER,
148: X_MSG_DATA OUT VARCHAR2,
149: P_ACTION IN VARCHAR2,