[Home] [Help]
PACKAGE: APPS.XNP_CVU_PKG
Source
1 Package XNP_CVU_PKG AUTHID CURRENT_USER AS
2 /* $Header: XNPCVUS.pls 120.0 2005/05/30 11:45:29 appldev noship $ */
3
4 gc_HTML VARCHAR2(40) := 'HTML';
5 g_display_type VARCHAR2(40) := gc_HTML;
6 gc_TH VARCHAR2(40) := '</TH><TH>';
7 gc_TD VARCHAR2(40) := '</TD><TD>';
8 gc_TRTH_open VARCHAR2(40) := '<TR><TH>';
9 gc_TRTH_close VARCHAR2(40) := '</TH></TR>';
10 gc_ERROR_TRTD_open VARCHAR2(40) := '<TR BGCOLOR="RED"><TD>';
11 gc_WARNING_TRTD_open VARCHAR2(40) := '<TR BGCOLOR="YELLOW"><TD>';
12 gc_TRTD_open VARCHAR2(40) := '<TR><TD>';
13 gc_TRTD_close VARCHAR2(40) := '</TD></TR>';
14 gc_TABLE_open VARCHAR2(40) := '<TABLE Border=1>';
15 gc_TABLE_close VARCHAR2(40) := '</TABLE>';
16
17 gc_RECORDS VARCHAR2(40) := 'RECORDS';
18
19 -- gc_DELIM VARCHAR2(15) default ' => ';
20
21
22 gc_max_date DATE default to_date('12/31/4000','MM/DD/YYYY');
23 gc_NULL VARCHAR2(15) default 'NULL';
24 gc_DATE_FORMAT VARCHAR2(20) default 'DD-MON-YYYY';
25
26 gc_GEO VARCHAR2(15) default 'GEO';
27 gc_PROV VARCHAR2(15) default 'PROV';
28
29 gc_FILE VARCHAR2(15) default 'FILE';
30 gc_SCRIPT VARCHAR2(15) default 'SCRIPT';
31 gc_JSCRIPT VARCHAR2(15) default 'JSCRIPT';
32 gc_INTERACTIVE VARCHAR2(15) default 'INTERACTIVE';
33
34
35 gc_DYNAMIC VARCHAR2(15) default 'DYNAMIC';
36 gc_STATIC VARCHAR2(15) default 'STATIC';
37
38 -- Message Types
39 gc_OK VARCHAR2(15) default 'OK';
40 gc_ERROR VARCHAR2(15) default 'ERROR';
41 gc_WARNING VARCHAR2(15) default 'WARNING';
42
43 -- Display
44 gc_ERROR_DISPLAY VARCHAR2(200) default gc_ERROR;
45 gc_WARNING_DISPLAY VARCHAR2(200) default gc_WARNING;
46 gc_OK_DISPLAY VARCHAR2(200) default gc_OK;
47
48
49 gc_HEADER VARCHAR2(15) default 'HEADER';
50 gc_HEADING VARCHAR2(15) default 'HEADING';
51 gc_DETAILS VARCHAR2(15) default 'DETAILS';
52 gc_MESSAGE VARCHAR2(15) default 'MESSAGE';
53 gc_CONTEXT VARCHAR2(15) default 'CONTEXT';
54 gc_SUB_CONTEXT VARCHAR2(15) default 'SUB_CONTEXT';
55
56 gc_ID VARCHAR2(15) default 'ID';
57 gc_NAME VARCHAR2(15) default 'NAME';
58 gc_VALID_DATE VARCHAR2(15) default 'VALID DATE';
59 gc_INVALID_DATE VARCHAR2(15) default 'INVALID DATE';
60
61
62
63 -- WF
64 gc_EVENT_TYPE VARCHAR2(15) := 'EVENT_TYPE';
65 gc_PARAM_LIST VARCHAR2(15) := 'PARAM_LIST';
66 gc_WORKFLOW VARCHAR2(15) := 'WORKFLOW';
67 gc_FE_NAME VARCHAR2(15) := 'FE_NAME';
68 gc_FA_NAME VARCHAR2(15) := 'FA_NAME';
69
70
71 -- Activities Names
72
73 gc_COMPLETE_WI_UPDATE_STATUS VARCHAR2(30) := 'COMPLETE_WI_UPDATE_STATUS';
74 gc_EXECUTE_FA VARCHAR2(30) := 'EXECUTE_FA';
75 gc_PROVISION_FE VARCHAR2(30) := 'PROVISION_FE';
76 gc_DEPROVISION_FE VARCHAR2(30) := 'DEPROVISION_FE';
77 gc_CREATE_SMS_PORTING_RECORD VARCHAR2(30) := 'CREATE_SMS_PORTING_RECORD';
78 gc_WAITFORFLOW VARCHAR2(30) := 'WAITFORFLOW';
79 gc_SUBSCRIBE_TO_ACKS VARCHAR2(30) := 'SUBSCRIBE_TO_ACKS';
80 gc_SUBSCRIBE_TO_BUSS_EVTS VARCHAR2(30) := 'SUBSCRIBE_TO_BUSINESS_EVENTS';
81 gc_END VARCHAR2(30) := 'END';
82 gc_XDP_END VARCHAR2(30) := 'XDP_END';
83
84 gc_FIRE VARCHAR2(30) := 'FIRE';
85 gc_REMOVE VARCHAR2(30) := 'REMOVE';
86
87 -- Report Types
88 gc_TERSE VARCHAR2(30) := 'TERSE';
89 gc_VERBOSE VARCHAR2(30) := 'VERBOSE';
90 -- gc_ERROR already defined
91 -- gc_WARNING already defined
92
93 -- Global Variables
94
95 g_report_type VARCHAR2(30) DEFAULT gc_TERSE;
96
97 -- Enter package declarations as shown below
98
99 PROCEDURE Print
100 ( p_text IN VARCHAR2,
101 p_text_indicator IN VARCHAR2 DEFAULT gc_OK,
102 p_text_type IN VARCHAR2 DEFAULT gc_RECORDS);
103
104 FUNCTION GetMsgTxt (v_msg_name IN VARCHAR2,
105 v_token_1 IN VARCHAR2 DEFAULT NULL,
106 v_value_1 IN VARCHAR2 DEFAULT NULL,
107 v_token_2 IN VARCHAR2 DEFAULT NULL,
108 v_value_2 IN VARCHAR2 DEFAULT NULL,
109 v_token_3 IN VARCHAR2 DEFAULT NULL,
110 v_value_3 IN VARCHAR2 DEFAULT NULL,
111 v_token_4 IN VARCHAR2 DEFAULT NULL,
112 v_value_4 IN VARCHAR2 DEFAULT NULL)
113 RETURN VARCHAR2;
114
115 FUNCTION GetGeoCode(id NUMBER)
116 RETURN VARCHAR2;
117
118 FUNCTION GetFeName(id NUMBER)
119 RETURN VARCHAR2;
120
121 PROCEDURE HandleError(p_custom_message IN VARCHAR2,
122 p_sqlcode IN NUMBER,
123 p_sqlerrm IN VARCHAR2);
124
125 PROCEDURE PrintReportDetails(
126 p_type VARCHAR2,
127 p_indicator VARCHAR2,
128 p_one VARCHAR2,
129 p_two VARCHAR2 Default NULL,
130 p_three VARCHAR2 Default NULL,
131 p_four VARCHAR2 Default NULL,
132 p_five VARCHAR2 Default NULL);
133
134 PROCEDURE LOCAL_SP_NAME;
135 PROCEDURE INITIAL_STATUS_OF_SV;
136 PROCEDURE PHASE_IND_NO_STAT_TYPE;
137
138 PROCEDURE SINGLE_GEO_TREE;
139
140 PROCEDURE FULFILL_ACTIONS;
141 PROCEDURE FULFILL_ELEMENT_VALIDITY;
142 PROCEDURE FULFILL_ELEMENT_REFERENCES;
143 PROCEDURE NEW_ADAPTER_TYPES;
144
145 PROCEDURE SERVICE_PROVIDERS;
146
147 PROCEDURE NUM_RANGE_GEO_AREA;
148 PROCEDURE INVALID_NUMBER_RANGES;
149 PROCEDURE POOLED_NUMBER_RANGES;
150 PROCEDURE NON_PORTED_PORTABLE_NUM_RANGES;
151 PROCEDURE SERVED_NUMBER_RANGES;
152 PROCEDURE ENABLE_NRC;
153
154 PROCEDURE SERVICE_VALIDATIONS;
155
156 PROCEDURE PACKAGE_VALIDATIONS;
157
158 PROCEDURE ACTIVITY_BASED_TIMERS;
159 PROCEDURE MESSAGE_COMPILATION;
160
161 PROCEDURE INVALID_FP;
162
163 PROCEDURE WORK_ITEMS;
164
165 PROCEDURE WF_PP_MSG_CROSS_VALIDATION;
166 PROCEDURE WF_NO_RQD_ITEM_ATT;
167 PROCEDURE WF_SPECIAL_ACTIVITIES;
168 PROCEDURE SUBSCRIBE_TO_BUSINESS_EVENTS;
169 PROCEDURE SUBSCRIBE_TO_ACKS;
170 PROCEDURE WF_LOOKUP_CODES;
171
172 PROCEDURE STARTUP;
173 END; -- Package spec
174
175