1 PACKAGE AST_WRAPUP_ADM_PVT AUTHID CURRENT_USER AS
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,
11 X_MSG_DATA OUT VARCHAR2,
12 P_RESULT_REQUIRED IN VARCHAR2,
13 P_VERSATILITY_CODE IN NUMBER,
14 P_GENERATE_PUBLIC_CALLBACK IN VARCHAR2,
15 P_GENERATE_PRIVATE_CALLBACK IN VARCHAR2,
16 P_SCORE IN NUMBER,
17 P_POSITIVE_OUTCOME_FLAG IN VARCHAR2,
18 P_LANGUAGE IN VARCHAR2,
19 P_LONG_DESCRIPTION IN VARCHAR2,
20 P_SHORT_DESCRIPTION IN VARCHAR2,
21 P_OUTCOME_CODE IN VARCHAR2,
22 P_MEDIA_TYPE IN VARCHAR2,
23 X_OUTCOME_ID OUT NUMBER
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,
33 X_MSG_DATA OUT VARCHAR2,
34 P_OUTCOME_ID IN NUMBER,
35 P_RESULT_REQUIRED IN VARCHAR2,
36 P_VERSATILITY_CODE IN NUMBER,
37 P_GENERATE_PUBLIC_CALLBACK IN VARCHAR2,
38 P_GENERATE_PRIVATE_CALLBACK IN VARCHAR2,
39 P_SCORE IN NUMBER,
40 P_POSITIVE_OUTCOME_FLAG IN VARCHAR2,
41 P_LANGUAGE IN VARCHAR2,
42 P_LONG_DESCRIPTION IN VARCHAR2,
43 P_SHORT_DESCRIPTION IN VARCHAR2,
44 P_OUTCOME_CODE IN VARCHAR2,
45 P_MEDIA_TYPE IN VARCHAR2
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,
55 X_MSG_DATA OUT VARCHAR2,
56 P_REASON_REQUIRED IN VARCHAR2,
57 P_VERSATILITY_CODE IN NUMBER,
58 P_GENERATE_PUBLIC_CALLBACK IN VARCHAR2,
59 P_GENERATE_PRIVATE_CALLBACK IN VARCHAR2,
60 P_POSITIVE_RESULT_FLAG IN VARCHAR2,
61 P_LANGUAGE IN VARCHAR2,
62 P_LONG_DESCRIPTION IN VARCHAR2,
63 P_SHORT_DESCRIPTION IN VARCHAR2,
64 P_RESULT_CODE IN VARCHAR2,
65 P_MEDIA_TYPE IN VARCHAR2,
66 X_RESULT_ID OUT NUMBER
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,
76 X_MSG_DATA OUT VARCHAR2,
77 P_RESULT_ID IN NUMBER,
78 P_REASON_REQUIRED IN VARCHAR2,
79 P_VERSATILITY_CODE IN NUMBER,
80 P_GENERATE_PUBLIC_CALLBACK IN VARCHAR2,
81 P_GENERATE_PRIVATE_CALLBACK IN VARCHAR2,
82 P_POSITIVE_RESULT_FLAG IN VARCHAR2,
83 P_LANGUAGE IN VARCHAR2,
84 P_LONG_DESCRIPTION IN VARCHAR2,
85 P_SHORT_DESCRIPTION IN VARCHAR2,
86 P_RESULT_CODE IN VARCHAR2,
87 P_MEDIA_TYPE IN VARCHAR2
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,
97 X_MSG_DATA OUT VARCHAR2,
98 P_VERSATILITY_CODE IN NUMBER,
99 P_GENERATE_PUBLIC_CALLBACK IN VARCHAR2,
100 P_GENERATE_PRIVATE_CALLBACK IN VARCHAR2,
101 P_LANGUAGE IN VARCHAR2,
102 P_LONG_DESCRIPTION IN VARCHAR2,
103 P_SHORT_DESCRIPTION IN VARCHAR2,
104 P_REASON_CODE IN VARCHAR2,
105 P_MEDIA_TYPE IN VARCHAR2,
106 X_REASON_ID OUT 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,
116 X_MSG_DATA OUT VARCHAR2,
117 P_REASON_ID IN NUMBER,
118 P_VERSATILITY_CODE IN NUMBER,
119 P_GENERATE_PUBLIC_CALLBACK IN VARCHAR2,
120 P_GENERATE_PRIVATE_CALLBACK IN VARCHAR2,
121 P_LANGUAGE IN VARCHAR2,
122 P_LONG_DESCRIPTION IN VARCHAR2,
123 P_SHORT_DESCRIPTION IN VARCHAR2,
124 P_REASON_CODE IN VARCHAR2,
125 P_MEDIA_TYPE IN VARCHAR2
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,
135 X_MSG_DATA OUT VARCHAR2,
136 P_ACTION IN VARCHAR2,
137 P_OUTCOME_ID IN NUMBER,
138 P_RESULT_ID IN NUMBER
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,
148 X_MSG_DATA OUT VARCHAR2,
149 P_ACTION IN VARCHAR2,
150 P_RESULT_ID IN NUMBER,
151 P_REASON_ID IN NUMBER
152 );
153
154 END;