[Home] [Help]
PACKAGE: APPS.CSC_RESPONSE_CENTER_PKG
Source
1 PACKAGE CSC_RESPONSE_CENTER_PKG AUTHID CURRENT_USER AS
2 /* $Header: CSCCCRCS.pls 120.6 2010/07/13 09:21:20 spamujul ship $ */
3
4 FUNCTION G_MISS_NUM RETURN NUMBER;
5 FUNCTION G_MISS_CHAR RETURN VARCHAR2;
6 FUNCTION G_MISS_DATE RETURN DATE;
7 FUNCTION G_VALID_LEVEL(p_level varchar2) RETURN NUMBER;
8 FUNCTION G_BOOLEAN(p_flag varchar2) RETURN VARCHAR2;
9 FUNCTION GET_ERROR_CONSTANT(err_msg VARCHAR2) RETURN VARCHAR2;
10
11 --end of commenting out V1 references
12
13 -- Define record type which will be used to transfer data between Contact Center form and
14 -- Service Request form
15
16 TYPE CC_SR_INT IS RECORD (
17 party_id NUMBER,
18 party_number VARCHAR2(30),
19 party_relationship_id NUMBER,
20 relation VARCHAR2(30),
21 object_id NUMBER,
22 obj_party_type VARCHAR2(30),
23 obj_company_name VARCHAR2(255),
24 obj_group_name VARCHAR2(255),
25 obj_group_type VARCHAR2(30),
26 obj_first_name VARCHAR2(150),
27 obj_middle_name VARCHAR2(60),
28 obj_last_name VARCHAR2(150),
29 obj_title VARCHAR2(60),
30 subject_id NUMBER,
31 sub_party_type VARCHAR2(30),
32 sub_first_name VARCHAR2(150),
33 sub_middle_name VARCHAR2(60),
34 sub_last_name VARCHAR2(150),
35 sub_title VARCHAR2(60),
36 location_id NUMBER,
37 type VARCHAR2(60),
38 address VARCHAR2(963),
39 address1 VARCHAR2(240),
40 address2 VARCHAR2(240),
41 address3 VARCHAR2(240),
42 address4 VARCHAR2(240),
43 city VARCHAR2(60),
44 state VARCHAR2(60),
45 province VARCHAR2(60),
46 postal_code VARCHAR2(60),
47 county VARCHAR2(60),
48 country VARCHAR2(60),
49 cust_account_org_id NUMBER,
50 cust_account_id NUMBER,
51 account_number VARCHAR2(30),
52 contact_point_id NUMBER,
53 country_code VARCHAR2(10),
54 area_code VARCHAR2(10),
55 extension VARCHAR2(20),
56 phone_number VARCHAR2(40),
57 contact_point_type VARCHAR2(30),
58 phone_line_type VARCHAR2(30),
59 email_contact_point_id NUMBER,
60 email_address VARCHAR2(2000),
61 ins_upd_flag VARCHAR2(1),
62 dir_flag VARCHAR2(2),
63 default_tab VARCHAR2(100),
64 rel_last_update_date DATE,
65 obj_last_update_date DATE,
66 sub_last_update_date DATE,
67 loc_last_update_date DATE,
68 acct_last_update_date DATE,
69 phone_last_update_date DATE,
70 email_last_update_date DATE,
71 incident_id NUMBER,
72 incident_number VARCHAR2(64),
73 interaction_id NUMBER);
74
75 -- Initialization function for the record type
76 FUNCTION INIT_CC_SR_INT RETURN CC_SR_INT;
77
78 G_MISS_CC_SR_INT CC_SR_INT;
79
80 -- wh_update_date is addded in the record. This is used as last update date in
81 -- Update address proc. Fix for bug #1567159
82
83 TYPE address_rec_type IS RECORD(
84 location_id NUMBER := FND_API.G_MISS_NUM,
85 address1 VARCHAR2(240) := FND_API.G_MISS_CHAR,
86 address2 VARCHAR2(240) := FND_API.G_MISS_CHAR,
87 address3 VARCHAR2(240) := FND_API.G_MISS_CHAR,
88 address4 VARCHAR2(240) := FND_API.G_MISS_CHAR,
89 address_lines_phonetic VARCHAR2(560) := FND_API.G_MISS_CHAR,
90 city VARCHAR2(60) := FND_API.G_MISS_CHAR,
91 state VARCHAR2(60) := FND_API.G_MISS_CHAR,
92 postal_code VARCHAR2(60) := FND_API.G_MISS_CHAR,
93 province VARCHAR2(60) := FND_API.G_MISS_CHAR,
94 county VARCHAR2(60) := FND_API.G_MISS_CHAR,
95 country VARCHAR2(60) := FND_API.G_MISS_CHAR,
96 language VARCHAR2(4) := FND_API.G_MISS_CHAR,
97 street VARCHAR2(50) := FND_API.G_MISS_CHAR,
98 house_number VARCHAR2(50) := FND_API.G_MISS_CHAR,
99 apartment_number VARCHAR2(50) := FND_API.G_MISS_CHAR,
100 building VARCHAR2(50) := FND_API.G_MISS_CHAR,
101 position VARCHAR2(50) := FND_API.G_MISS_CHAR,
102 po_box_number VARCHAR2(50) := FND_API.G_MISS_CHAR,
103 address_key VARCHAR2(500) := FND_API.G_MISS_CHAR,
104 apartment_flag VARCHAR2(1) := FND_API.G_MISS_CHAR,
105 street_suffix VARCHAR2(50) := FND_API.G_MISS_CHAR,
106 secondary_suffix_element VARCHAR2(240) := FND_API.G_MISS_CHAR,
107 rural_route_type VARCHAR2(50) := FND_API.G_MISS_CHAR,
108 rural_route_number VARCHAR2(50) := FND_API.G_MISS_CHAR,
109 street_number VARCHAR2(50) := FND_API.G_MISS_CHAR,
110 floor VARCHAR2(50) := FND_API.G_MISS_CHAR,
111 suite VARCHAR2(50) := FND_API.G_MISS_CHAR,
112 room VARCHAR2(50) := FND_API.G_MISS_CHAR,
113 postal_plus4_code VARCHAR2(10) := FND_API.G_MISS_CHAR,
114 time_zone VARCHAR2(50) := FND_API.G_MISS_CHAR,
115 post_office VARCHAR2(50) := FND_API.G_MISS_CHAR,
116 delivery_point_code VARCHAR2(50) := FND_API.G_MISS_CHAR,
117 location_directions VARCHAR2(640) := FND_API.G_MISS_CHAR,
118 address_error_code VARCHAR2(50) := FND_API.G_MISS_CHAR,
119 clli_code VARCHAR2(60) := FND_API.G_MISS_CHAR,
120 dodaac VARCHAR2(6) := FND_API.G_MISS_CHAR,
121 trailing_directory_code VARCHAR2(60) := FND_API.G_MISS_CHAR,
122 life_cycle_status VARCHAR2(30) := FND_API.G_MISS_CHAR,
123 short_description VARCHAR2(240) := FND_API.G_MISS_CHAR,
124 description VARCHAR2(2000) := FND_API.G_MISS_CHAR,
125 sales_tax_geocode VARCHAR2(30) := FND_API.G_MISS_CHAR,
126 sales_tax_inside_city_limits VARCHAR2(30) := FND_API.G_MISS_CHAR,
127 timezone_id NUMBER := FND_API.G_MISS_NUM,
128 address_effective_date DATE := FND_API.G_MISS_DATE,
129 address_expiration_date DATE := FND_API.G_MISS_DATE,
130 address_style VARCHAR2(30) := FND_API.G_MISS_CHAR,
131 wh_update_date DATE := FND_API.G_MISS_DATE);
132
133 FUNCTION GET_ADDRESS_REC_TYPE RETURN CSC_RESPONSE_CENTER_PKG.ADDRESS_REC_TYPE;
134
135
136 -- Buffer to store data for successful transfer from Contact Center to SR and vice versa
137 CC_SR_BUFFER CC_SR_INT := G_MISS_CC_SR_INT;
138
139 -- To populate data into CC-SR buffer
140 PROCEDURE Put_in_CC_SR_Buffer (
141 p_cc_sr_int_rec IN CC_SR_INT);
142
143 -- To retrieve data from CC-SR buffer
144 PROCEDURE Get_from_CC_SR_Buffer (
145 x_cc_sr_int_rec OUT NOCOPY CC_SR_INT);
146
147 -- To initialise CC-SR buffer
148 PROCEDURE Init_CC_SR_Buffer;
149
150 -- Wrapper for HZ procedure : phone_format for phone number globalization
151 FUNCTION phone_format_Wrap( p_phone_country_code IN VARCHAR2,
152 p_phone_area_code IN VARCHAR2,
153 p_phone_number IN VARCHAR2)
154 RETURN varchar2;
155
156 -- Here are objects relation to New Search window
157 TYPE AccountRecType IS RECORD (
158 party_id NUMBER,
159 Account_Name VARCHAR2(240),
160 Account_Number VARCHAR2(30),
161 Cust_Account_id NUMBER,
162 object_version_number NUMBER);
163
164 TYPE PhoneRecType IS RECORD (
165 Party_id NUMBER,
166 Full_Phone VARCHAR2(60),
167 Phone_country_code VARCHAR2(10),
168 Phone_Area_Code VARCHAR2(10),
169 Phone_number VARCHAR2(40),
170 Phone_line_Type VARCHAR2(80),
171 Phone_Line_Code VARCHAR2(30),
172 Phone_id NUMBER,
173 Phone_Extension VARCHAR2(20),
174 object_version_number NUMBER);
175
176 TYPE AccountRecTabType IS TABLE OF AccountRecType INDEX BY BINARY_INTEGER;
177 TYPE PhoneRecTabType IS TABLE OF PhoneRecType INDEX BY BINARY_INTEGER;
178 TYPE SiteIDRecTabType IS TABLE OF NUMBER INDEX BY BINARY_INTEGER; -- added for NCR ER# 8606060 by mpathani
179
180 PROCEDURE get_account_details(x_account_rec IN OUT NOCOPY AccountRecTabType);
181 PROCEDURE get_phone_details(x_phone_rec IN OUT NOCOPY PhoneRecTabType);
182
183 -- added get_sitephone_details for NCR ER# 8606060 by mpathani
184 PROCEDURE get_sitephone_details(p_site_id IN SiteIDRecTabType,
185 x_phone_rec IN OUT NOCOPY PhoneRecTabType);
186
187 PROCEDURE start_media_item( p_resp_appl_id in number,
188 p_resp_id in number,
189 p_user_id in number,
190 p_login_id in number,
191 x_return_status out nocopy varchar2,
192 x_msg_count out nocopy number,
193 x_msg_data out nocopy varchar2,
194 x_media_id out nocopy number
195 ,x_outbound_dnis in varchar2 DEFAULT NULL -- added by spamujul for 9370084
196 ,x_outbound_ani in varchar2 DEFAULT NULL -- added by spamujul for 9370084
197 ,p_media_direction in varchar2 DEFAULT 'OUTBOUND' -- added by spamujul for 9470243
198 );
199
200
201 END CSC_RESPONSE_CENTER_PKG;