1 PACKAGE CS_CF_UPG_UTL_PKG AUTHID CURRENT_USER as
2 /* $Header: cscfutls.pls 120.0 2005/06/01 13:19:40 appldev noship $ */
3
4 TYPE RespRec IS RECORD (
5 respId FND_PROFILE_OPTION_VALUES.level_value%TYPE,
6 respApplId FND_PROFILE_OPTION_VALUES.level_value_application_id%TYPE
7 );
8
9 Type RespTable IS TABLE OF RespRec
10 INDEX BY BINARY_INTEGER;
11
12 Type ApplTable IS TABLE OF NUMBER
13 INDEX BY BINARY_INTEGER;
14
15 TYPE ProfileRec IS RECORD (
16 profileOptionName FND_PROFILE_OPTIONS.profile_option_name%TYPE,
17 profileOptionValue FND_PROFILE_OPTION_VALUES.profile_option_value%TYPE
18 );
19
20 Type ProfileTable IS TABLE OF ProfileRec
21 INDEX BY BINARY_INTEGER;
22
23
24 FUNCTION Eval_SR_Account_Option (p_resp_index IN OUT NOCOPY NUMBER,
25 p_respTable IN OUT NOCOPY RespTable,
26 p_appl_index IN OUT NOCOPY NUMBER,
27 p_applTable IN OUT NOCOPY ApplTable,
28 p_site_index IN OUT NOCOPY NUMBER,
29 p_siteProfilesTable IN OUT NOCOPY ProfileTable)
30 RETURN BOOLEAN;
31
32 FUNCTION Eval_SR_Problem_Code_Option (p_resp_index IN OUT NOCOPY NUMBER,
33 p_respTable IN OUT NOCOPY RespTable,
34 p_appl_index IN OUT NOCOPY NUMBER,
35 p_applTable IN OUT NOCOPY ApplTable,
36 p_site_index IN OUT NOCOPY NUMBER,
37 p_siteProfilesTable IN OUT NOCOPY ProfileTable)
38 RETURN BOOLEAN;
39
40
41
42 FUNCTION Eval_SR_Addr_Display (p_appl_index IN OUT NOCOPY NUMBER,
43 p_applTable IN OUT NOCOPY ApplTable,
44 p_resp_index IN OUT NOCOPY NUMBER,
45 p_respTable IN OUT NOCOPY RespTable,
46 p_site_index IN OUT NOCOPY NUMBER,
47 p_siteProfilesTable IN OUT NOCOPY ProfileTable)
48 RETURN BOOLEAN;
49
50 FUNCTION Eval_SR_Addr_Mandatory (p_appl_index IN OUT NOCOPY NUMBER,
51 p_applTable IN OUT NOCOPY ApplTable,
52 p_resp_index IN OUT NOCOPY NUMBER,
53 p_respTable IN OUT NOCOPY RespTable,
54 p_site_index IN OUT NOCOPY NUMBER,
55 p_siteProfilesTable IN OUT NOCOPY ProfileTable)
56 RETURN BOOLEAN;
57
58
59 FUNCTION Eval_SR_BillTo_Address_Option (p_resp_index IN OUT NOCOPY NUMBER,
60 p_respTable IN OUT NOCOPY RespTable,
61 p_appl_index IN OUT NOCOPY NUMBER,
62 p_applTable IN OUT NOCOPY ApplTable,
63 p_site_index IN OUT NOCOPY NUMBER,
64 p_siteProfilesTable IN OUT NOCOPY ProfileTable)
65 RETURN BOOLEAN;
66
67
68 FUNCTION Eval_SR_BillTo_Contact_Option (p_resp_index IN OUT NOCOPY NUMBER,
69 p_respTable IN OUT NOCOPY RespTable,
70 p_appl_index IN OUT NOCOPY NUMBER,
71 p_applTable IN OUT NOCOPY ApplTable,
72 p_site_index IN OUT NOCOPY NUMBER,
73 p_siteProfilesTable IN OUT NOCOPY ProfileTable)
74 RETURN BOOLEAN;
75
76
77 FUNCTION Eval_SR_Creation_Prod_Option (p_appl_index IN OUT NOCOPY NUMBER,
78 p_applTable IN OUT NOCOPY ApplTable,
79 p_resp_index IN OUT NOCOPY NUMBER,
80 p_respTable IN OUT NOCOPY RespTable,
81 p_site_index IN OUT NOCOPY NUMBER,
82 p_siteProfilesTable IN OUT NOCOPY ProfileTable)
83 RETURN BOOLEAN;
84
85 FUNCTION Eval_SR_ShipTo_Address_Option (p_resp_index IN OUT NOCOPY NUMBER,
86 p_respTable IN OUT NOCOPY RespTable,
87 p_appl_index IN OUT NOCOPY NUMBER,
88 p_applTable IN OUT NOCOPY ApplTable,
89 p_site_index IN OUT NOCOPY NUMBER,
90 p_siteProfilesTable IN OUT NOCOPY ProfileTable)
91 RETURN BOOLEAN;
92
93 FUNCTION Eval_SR_ShipTo_Contact_Option (p_resp_index IN OUT NOCOPY NUMBER,
94 p_respTable IN OUT NOCOPY RespTable,
95 p_appl_index IN OUT NOCOPY NUMBER,
96 p_applTable IN OUT NOCOPY ApplTable,
97 p_site_index IN OUT NOCOPY NUMBER,
98 p_siteProfilesTable IN OUT NOCOPY ProfileTable)
99 RETURN BOOLEAN;
100
101 FUNCTION Eval_SR_InstalledAt_Address (p_resp_index IN OUT NOCOPY NUMBER,
102 p_respTable IN OUT NOCOPY RespTable,
103 p_appl_index IN OUT NOCOPY NUMBER,
104 p_applTable IN OUT NOCOPY ApplTable,
105 p_site_index IN OUT NOCOPY NUMBER,
106 p_siteProfilesTable IN OUT NOCOPY ProfileTable)
107 RETURN BOOLEAN;
108
109
110 FUNCTION Eval_SR_Attachment_Option (p_resp_index IN OUT NOCOPY NUMBER,
111 p_respTable IN OUT NOCOPY RespTable,
112 p_appl_index IN OUT NOCOPY NUMBER,
113 p_applTable IN OUT NOCOPY ApplTable,
114 p_site_index IN OUT NOCOPY NUMBER,
115 p_siteProfilesTable IN OUT NOCOPY ProfileTable)
116 RETURN BOOLEAN;
117
118 FUNCTION Eval_SR_Task_Display (p_appl_index IN OUT NOCOPY NUMBER,
119 p_applTable IN OUT NOCOPY ApplTable,
120 p_resp_index IN OUT NOCOPY NUMBER,
121 p_respTable IN OUT NOCOPY RespTable,
122 p_site_index IN OUT NOCOPY NUMBER,
123 p_siteProfilesTable IN OUT NOCOPY ProfileTable)
124 RETURN BOOLEAN;
125
126 FUNCTION Eval_SR_Enable_Interact_Log (p_resp_index IN OUT NOCOPY NUMBER,
127 p_respTable IN OUT NOCOPY RespTable,
128 p_appl_index IN OUT NOCOPY NUMBER,
129 p_applTable IN OUT NOCOPY ApplTable,
130 p_site_index IN OUT NOCOPY NUMBER,
131 p_siteProfilesTable IN OUT NOCOPY ProfileTable)
132 RETURN BOOLEAN;
133
134
135 FUNCTION Eval_SR_KB_Option (p_appl_index IN OUT NOCOPY NUMBER,
136 p_applTable IN OUT NOCOPY ApplTable,
137 p_resp_index IN OUT NOCOPY NUMBER,
138 p_respTable IN OUT NOCOPY RespTable,
139 p_site_index IN OUT NOCOPY NUMBER,
140 p_siteProfilesTable IN OUT NOCOPY ProfileTable)
141 RETURN BOOLEAN;
142
143 FUNCTION Eval_SR_Enable_Template (p_appl_index IN OUT NOCOPY NUMBER,
144 p_applTable IN OUT NOCOPY ApplTable,
145 p_resp_index IN OUT NOCOPY NUMBER,
146 p_respTable IN OUT NOCOPY RespTable,
147 p_site_index IN OUT NOCOPY NUMBER,
148 p_siteProfilesTable IN OUT NOCOPY ProfileTable)
149 RETURN BOOLEAN;
150
151 FUNCTION Eval_SR_Product_Selection (p_appl_index IN OUT NOCOPY NUMBER,
152 p_applTable IN OUT NOCOPY ApplTable,
153 p_resp_index IN OUT NOCOPY NUMBER,
154 p_respTable IN OUT NOCOPY RespTable,
155 p_site_index IN OUT NOCOPY NUMBER,
156 p_siteProfilesTable IN OUT NOCOPY ProfileTable)
157 RETURN BOOLEAN;
158
159 FUNCTION Resp_Already_Exists(p_respTable IN RespTable,
160 p_level_value IN NUMBER,
161 p_level_value_application_id IN NUMBER)
162 RETURN BOOLEAN;
163
164 FUNCTION Appl_Already_Exists(p_applTable IN ApplTable,
165 p_level_value IN NUMBER)
166 RETURN BOOLEAN;
167
168
169 /*
170 * This procedure inserts a new row into CS_CF_SOURCE_CONTEXT_TARGETS
171 * table for the newly cloned regions
172 */
173
174 PROCEDURE Insert_New_Target(p_sourceCode IN VARCHAR2,
175 p_contextType IN VARCHAR2,
176 p_contextValue1 IN VARCHAR2,
177 p_contextValue2 IN VARCHAR2,
178 p_seedTargetValue1 IN VARCHAR2,
179 p_seedTargetValue2 IN VARCHAR2,
180 p_custTargetValue1 IN VARCHAR2,
181 p_custTargetValue2 IN VARCHAR2);
182
183 /*
184 * Wrapper function to call AK's api to clone regions
185 */
186 PROCEDURE Clone_Region(p_regionCode IN VARCHAR2,
187 p_regionApplId IN NUMBER,
188 p_newRegionCode IN VARCHAR2,
189 p_newRegionApplId IN NUMBER,
190 p_checkRegion IN BOOLEAN);
191
192
193 PROCEDURE UpdateRegionItems(p_regionCode IN VARCHAR2,
194 p_attributeCode IN VARCHAR2,
195 p_displayFlag IN VARCHAR2,
196 p_mandatoryFlag IN VARCHAR2,
197 p_subRegionCode IN VARCHAR2);
198
199 PROCEDURE getAddressProfileValues(p_ProfileTable IN CS_CF_UPG_UTL_PKG.ProfileTable,
200 p_displayBillToAddress IN OUT NOCOPY VARCHAR2,
201 p_displayBillToContact IN OUT NOCOPY VARCHAR2,
202 p_displayShipToAddress IN OUT NOCOPY VARCHAR2,
203 p_displayShipToContact IN OUT NOCOPY VARCHAR2,
204 p_displayInstalledAtAddr IN OUT NOCOPY VARCHAR2,
205 p_displayIncidentAddr IN OUT NOCOPY VARCHAR2,
206 p_mandatoryIncidentAddr IN OUT NOCOPY VARCHAR2);
207
208 PROCEDURE getAttachmentProbCodeValues(p_ProfileTable IN CS_CF_UPG_UTL_PKG.ProfileTable,
209 p_displayAttachment IN OUT NOCOPY VARCHAR2,
210 p_mandatoryProblemCode IN OUT NOCOPY VARCHAR2);
211
212 PROCEDURE setup_log(p_filename IN VARCHAR2);
213
214 PROCEDURE log_mesg(p_level IN NUMBER,
215 p_module IN VARCHAR2,
216 p_text IN VARCHAR2);
217
218 PROCEDURE wrapup(p_status IN VARCHAR2);
219
220 FUNCTION get_log_directory RETURN VARCHAR2;
221
222 FUNCTION Regions_Not_Already_Cloned(p_suffix IN VARCHAR2) RETURN BOOLEAN;
223
224 --mkcyee 02/25/2004 - added to check if a flow has already been cloned
225 FUNCTION Flows_Not_Already_Cloned(p_flowId IN NUMBER) RETURN BOOLEAN;
226
227 -- mkcyee 02/24/04 - added to check if config profile option has been customized
228 FUNCTION configProfileCustomized RETURN BOOLEAN;
229
230 -- mkcyee 02/24/04 - added to clone a flow
231 PROCEDURE Clone_Flow(p_newFlowId in NUMBER, p_flowId in NUMBER);
232
233 End CS_CF_UPG_UTL_PKG;