eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.CSC_RESPONSE_CENTER_PKG_V2 dependencies on CSC_RESPONSE_CENTER_PKG_V2

Line 1: PACKAGE BODY CSC_RESPONSE_CENTER_PKG_V2 AS

1: PACKAGE BODY CSC_RESPONSE_CENTER_PKG_V2 AS
2: /* $Header: CSCV2RCB.pls 120.1.12010000.2 2008/08/11 06:29:24 mpathani ship $ */
3:
4: -- Local Function. Returns the Value of the Constant FND_API.G_MISS_NUM
5: FUNCTION G_MISS_NUM RETURN NUMBER IS

Line 170: FUNCTION GET_ADDRESS_REC_TYPE RETURN CSC_RESPONSE_CENTER_PKG_V2.ADDRESS_REC_TYPE IS

166: BEGIN
167: RETURN TMP_CONTACT_POINTS_REC_TYPE;
168: END GET_CONT_POINTS_PREF_REC_TYPE;
169:
170: FUNCTION GET_ADDRESS_REC_TYPE RETURN CSC_RESPONSE_CENTER_PKG_V2.ADDRESS_REC_TYPE IS
171: TMP_ADDRESS_REC_TYPE CSC_RESPONSE_CENTER_PKG_V2.ADDRESS_REC_TYPE;
172: BEGIN
173: RETURN TMP_ADDRESS_REC_TYPE;
174: END GET_ADDRESS_REC_TYPE;

Line 171: TMP_ADDRESS_REC_TYPE CSC_RESPONSE_CENTER_PKG_V2.ADDRESS_REC_TYPE;

167: RETURN TMP_CONTACT_POINTS_REC_TYPE;
168: END GET_CONT_POINTS_PREF_REC_TYPE;
169:
170: FUNCTION GET_ADDRESS_REC_TYPE RETURN CSC_RESPONSE_CENTER_PKG_V2.ADDRESS_REC_TYPE IS
171: TMP_ADDRESS_REC_TYPE CSC_RESPONSE_CENTER_PKG_V2.ADDRESS_REC_TYPE;
172: BEGIN
173: RETURN TMP_ADDRESS_REC_TYPE;
174: END GET_ADDRESS_REC_TYPE;
175:

Line 272: l_location_rec.address1 := Nvl(p_address_rec.address1, CSC_RESPONSE_CENTER_PKG_V2.g_miss_char);

268: l_return_status VARCHAR2(1);
269: l_msg_count NUMBER;
270: l_msg_data VARCHAR2(2000);
271: BEGIN
272: l_location_rec.address1 := Nvl(p_address_rec.address1, CSC_RESPONSE_CENTER_PKG_V2.g_miss_char);
273: l_location_rec.address2 := Nvl(p_address_rec.address2, CSC_RESPONSE_CENTER_PKG_V2.g_miss_char);
274: l_location_rec.address3 := Nvl(p_address_rec.address3, CSC_RESPONSE_CENTER_PKG_V2.g_miss_char);
275: l_location_rec.address4 := Nvl(p_address_rec.address4, CSC_RESPONSE_CENTER_PKG_V2.g_miss_char);
276: l_location_rec.address_lines_phonetic := Nvl(p_address_rec.address_lines_phonetic, CSC_RESPONSE_CENTER_PKG_V2.g_miss_char);

Line 273: l_location_rec.address2 := Nvl(p_address_rec.address2, CSC_RESPONSE_CENTER_PKG_V2.g_miss_char);

269: l_msg_count NUMBER;
270: l_msg_data VARCHAR2(2000);
271: BEGIN
272: l_location_rec.address1 := Nvl(p_address_rec.address1, CSC_RESPONSE_CENTER_PKG_V2.g_miss_char);
273: l_location_rec.address2 := Nvl(p_address_rec.address2, CSC_RESPONSE_CENTER_PKG_V2.g_miss_char);
274: l_location_rec.address3 := Nvl(p_address_rec.address3, CSC_RESPONSE_CENTER_PKG_V2.g_miss_char);
275: l_location_rec.address4 := Nvl(p_address_rec.address4, CSC_RESPONSE_CENTER_PKG_V2.g_miss_char);
276: l_location_rec.address_lines_phonetic := Nvl(p_address_rec.address_lines_phonetic, CSC_RESPONSE_CENTER_PKG_V2.g_miss_char);
277: l_location_rec.city := Nvl(p_address_rec.city, CSC_RESPONSE_CENTER_PKG_V2.g_miss_char);

Line 274: l_location_rec.address3 := Nvl(p_address_rec.address3, CSC_RESPONSE_CENTER_PKG_V2.g_miss_char);

270: l_msg_data VARCHAR2(2000);
271: BEGIN
272: l_location_rec.address1 := Nvl(p_address_rec.address1, CSC_RESPONSE_CENTER_PKG_V2.g_miss_char);
273: l_location_rec.address2 := Nvl(p_address_rec.address2, CSC_RESPONSE_CENTER_PKG_V2.g_miss_char);
274: l_location_rec.address3 := Nvl(p_address_rec.address3, CSC_RESPONSE_CENTER_PKG_V2.g_miss_char);
275: l_location_rec.address4 := Nvl(p_address_rec.address4, CSC_RESPONSE_CENTER_PKG_V2.g_miss_char);
276: l_location_rec.address_lines_phonetic := Nvl(p_address_rec.address_lines_phonetic, CSC_RESPONSE_CENTER_PKG_V2.g_miss_char);
277: l_location_rec.city := Nvl(p_address_rec.city, CSC_RESPONSE_CENTER_PKG_V2.g_miss_char);
278: l_location_rec.state := Nvl(p_address_rec.state, CSC_RESPONSE_CENTER_PKG_V2.g_miss_char);

Line 275: l_location_rec.address4 := Nvl(p_address_rec.address4, CSC_RESPONSE_CENTER_PKG_V2.g_miss_char);

271: BEGIN
272: l_location_rec.address1 := Nvl(p_address_rec.address1, CSC_RESPONSE_CENTER_PKG_V2.g_miss_char);
273: l_location_rec.address2 := Nvl(p_address_rec.address2, CSC_RESPONSE_CENTER_PKG_V2.g_miss_char);
274: l_location_rec.address3 := Nvl(p_address_rec.address3, CSC_RESPONSE_CENTER_PKG_V2.g_miss_char);
275: l_location_rec.address4 := Nvl(p_address_rec.address4, CSC_RESPONSE_CENTER_PKG_V2.g_miss_char);
276: l_location_rec.address_lines_phonetic := Nvl(p_address_rec.address_lines_phonetic, CSC_RESPONSE_CENTER_PKG_V2.g_miss_char);
277: l_location_rec.city := Nvl(p_address_rec.city, CSC_RESPONSE_CENTER_PKG_V2.g_miss_char);
278: l_location_rec.state := Nvl(p_address_rec.state, CSC_RESPONSE_CENTER_PKG_V2.g_miss_char);
279: l_location_rec.county := Nvl(p_address_rec.county, CSC_RESPONSE_CENTER_PKG_V2.g_miss_char);

Line 276: l_location_rec.address_lines_phonetic := Nvl(p_address_rec.address_lines_phonetic, CSC_RESPONSE_CENTER_PKG_V2.g_miss_char);

272: l_location_rec.address1 := Nvl(p_address_rec.address1, CSC_RESPONSE_CENTER_PKG_V2.g_miss_char);
273: l_location_rec.address2 := Nvl(p_address_rec.address2, CSC_RESPONSE_CENTER_PKG_V2.g_miss_char);
274: l_location_rec.address3 := Nvl(p_address_rec.address3, CSC_RESPONSE_CENTER_PKG_V2.g_miss_char);
275: l_location_rec.address4 := Nvl(p_address_rec.address4, CSC_RESPONSE_CENTER_PKG_V2.g_miss_char);
276: l_location_rec.address_lines_phonetic := Nvl(p_address_rec.address_lines_phonetic, CSC_RESPONSE_CENTER_PKG_V2.g_miss_char);
277: l_location_rec.city := Nvl(p_address_rec.city, CSC_RESPONSE_CENTER_PKG_V2.g_miss_char);
278: l_location_rec.state := Nvl(p_address_rec.state, CSC_RESPONSE_CENTER_PKG_V2.g_miss_char);
279: l_location_rec.county := Nvl(p_address_rec.county, CSC_RESPONSE_CENTER_PKG_V2.g_miss_char);
280: l_location_rec.country := Nvl(p_address_rec.country, CSC_RESPONSE_CENTER_PKG_V2.g_miss_char);

Line 277: l_location_rec.city := Nvl(p_address_rec.city, CSC_RESPONSE_CENTER_PKG_V2.g_miss_char);

273: l_location_rec.address2 := Nvl(p_address_rec.address2, CSC_RESPONSE_CENTER_PKG_V2.g_miss_char);
274: l_location_rec.address3 := Nvl(p_address_rec.address3, CSC_RESPONSE_CENTER_PKG_V2.g_miss_char);
275: l_location_rec.address4 := Nvl(p_address_rec.address4, CSC_RESPONSE_CENTER_PKG_V2.g_miss_char);
276: l_location_rec.address_lines_phonetic := Nvl(p_address_rec.address_lines_phonetic, CSC_RESPONSE_CENTER_PKG_V2.g_miss_char);
277: l_location_rec.city := Nvl(p_address_rec.city, CSC_RESPONSE_CENTER_PKG_V2.g_miss_char);
278: l_location_rec.state := Nvl(p_address_rec.state, CSC_RESPONSE_CENTER_PKG_V2.g_miss_char);
279: l_location_rec.county := Nvl(p_address_rec.county, CSC_RESPONSE_CENTER_PKG_V2.g_miss_char);
280: l_location_rec.country := Nvl(p_address_rec.country, CSC_RESPONSE_CENTER_PKG_V2.g_miss_char);
281: l_location_rec.postal_code := Nvl(p_address_rec.postal_code, CSC_RESPONSE_CENTER_PKG_V2.g_miss_char);

Line 278: l_location_rec.state := Nvl(p_address_rec.state, CSC_RESPONSE_CENTER_PKG_V2.g_miss_char);

274: l_location_rec.address3 := Nvl(p_address_rec.address3, CSC_RESPONSE_CENTER_PKG_V2.g_miss_char);
275: l_location_rec.address4 := Nvl(p_address_rec.address4, CSC_RESPONSE_CENTER_PKG_V2.g_miss_char);
276: l_location_rec.address_lines_phonetic := Nvl(p_address_rec.address_lines_phonetic, CSC_RESPONSE_CENTER_PKG_V2.g_miss_char);
277: l_location_rec.city := Nvl(p_address_rec.city, CSC_RESPONSE_CENTER_PKG_V2.g_miss_char);
278: l_location_rec.state := Nvl(p_address_rec.state, CSC_RESPONSE_CENTER_PKG_V2.g_miss_char);
279: l_location_rec.county := Nvl(p_address_rec.county, CSC_RESPONSE_CENTER_PKG_V2.g_miss_char);
280: l_location_rec.country := Nvl(p_address_rec.country, CSC_RESPONSE_CENTER_PKG_V2.g_miss_char);
281: l_location_rec.postal_code := Nvl(p_address_rec.postal_code, CSC_RESPONSE_CENTER_PKG_V2.g_miss_char);
282: l_location_rec.province := Nvl(p_address_rec.province, CSC_RESPONSE_CENTER_PKG_V2.g_miss_char);

Line 279: l_location_rec.county := Nvl(p_address_rec.county, CSC_RESPONSE_CENTER_PKG_V2.g_miss_char);

275: l_location_rec.address4 := Nvl(p_address_rec.address4, CSC_RESPONSE_CENTER_PKG_V2.g_miss_char);
276: l_location_rec.address_lines_phonetic := Nvl(p_address_rec.address_lines_phonetic, CSC_RESPONSE_CENTER_PKG_V2.g_miss_char);
277: l_location_rec.city := Nvl(p_address_rec.city, CSC_RESPONSE_CENTER_PKG_V2.g_miss_char);
278: l_location_rec.state := Nvl(p_address_rec.state, CSC_RESPONSE_CENTER_PKG_V2.g_miss_char);
279: l_location_rec.county := Nvl(p_address_rec.county, CSC_RESPONSE_CENTER_PKG_V2.g_miss_char);
280: l_location_rec.country := Nvl(p_address_rec.country, CSC_RESPONSE_CENTER_PKG_V2.g_miss_char);
281: l_location_rec.postal_code := Nvl(p_address_rec.postal_code, CSC_RESPONSE_CENTER_PKG_V2.g_miss_char);
282: l_location_rec.province := Nvl(p_address_rec.province, CSC_RESPONSE_CENTER_PKG_V2.g_miss_char);
283: l_location_rec.county := Nvl(p_address_rec.county, CSC_RESPONSE_CENTER_PKG_V2.g_miss_char);

Line 280: l_location_rec.country := Nvl(p_address_rec.country, CSC_RESPONSE_CENTER_PKG_V2.g_miss_char);

276: l_location_rec.address_lines_phonetic := Nvl(p_address_rec.address_lines_phonetic, CSC_RESPONSE_CENTER_PKG_V2.g_miss_char);
277: l_location_rec.city := Nvl(p_address_rec.city, CSC_RESPONSE_CENTER_PKG_V2.g_miss_char);
278: l_location_rec.state := Nvl(p_address_rec.state, CSC_RESPONSE_CENTER_PKG_V2.g_miss_char);
279: l_location_rec.county := Nvl(p_address_rec.county, CSC_RESPONSE_CENTER_PKG_V2.g_miss_char);
280: l_location_rec.country := Nvl(p_address_rec.country, CSC_RESPONSE_CENTER_PKG_V2.g_miss_char);
281: l_location_rec.postal_code := Nvl(p_address_rec.postal_code, CSC_RESPONSE_CENTER_PKG_V2.g_miss_char);
282: l_location_rec.province := Nvl(p_address_rec.province, CSC_RESPONSE_CENTER_PKG_V2.g_miss_char);
283: l_location_rec.county := Nvl(p_address_rec.county, CSC_RESPONSE_CENTER_PKG_V2.g_miss_char);
284: l_location_rec.language := Nvl(p_address_rec.language, CSC_RESPONSE_CENTER_PKG_V2.g_miss_char);

Line 281: l_location_rec.postal_code := Nvl(p_address_rec.postal_code, CSC_RESPONSE_CENTER_PKG_V2.g_miss_char);

277: l_location_rec.city := Nvl(p_address_rec.city, CSC_RESPONSE_CENTER_PKG_V2.g_miss_char);
278: l_location_rec.state := Nvl(p_address_rec.state, CSC_RESPONSE_CENTER_PKG_V2.g_miss_char);
279: l_location_rec.county := Nvl(p_address_rec.county, CSC_RESPONSE_CENTER_PKG_V2.g_miss_char);
280: l_location_rec.country := Nvl(p_address_rec.country, CSC_RESPONSE_CENTER_PKG_V2.g_miss_char);
281: l_location_rec.postal_code := Nvl(p_address_rec.postal_code, CSC_RESPONSE_CENTER_PKG_V2.g_miss_char);
282: l_location_rec.province := Nvl(p_address_rec.province, CSC_RESPONSE_CENTER_PKG_V2.g_miss_char);
283: l_location_rec.county := Nvl(p_address_rec.county, CSC_RESPONSE_CENTER_PKG_V2.g_miss_char);
284: l_location_rec.language := Nvl(p_address_rec.language, CSC_RESPONSE_CENTER_PKG_V2.g_miss_char);
285: l_location_rec.po_box_number := Nvl(p_address_rec.po_box_number, CSC_RESPONSE_CENTER_PKG_V2.g_miss_char);

Line 282: l_location_rec.province := Nvl(p_address_rec.province, CSC_RESPONSE_CENTER_PKG_V2.g_miss_char);

278: l_location_rec.state := Nvl(p_address_rec.state, CSC_RESPONSE_CENTER_PKG_V2.g_miss_char);
279: l_location_rec.county := Nvl(p_address_rec.county, CSC_RESPONSE_CENTER_PKG_V2.g_miss_char);
280: l_location_rec.country := Nvl(p_address_rec.country, CSC_RESPONSE_CENTER_PKG_V2.g_miss_char);
281: l_location_rec.postal_code := Nvl(p_address_rec.postal_code, CSC_RESPONSE_CENTER_PKG_V2.g_miss_char);
282: l_location_rec.province := Nvl(p_address_rec.province, CSC_RESPONSE_CENTER_PKG_V2.g_miss_char);
283: l_location_rec.county := Nvl(p_address_rec.county, CSC_RESPONSE_CENTER_PKG_V2.g_miss_char);
284: l_location_rec.language := Nvl(p_address_rec.language, CSC_RESPONSE_CENTER_PKG_V2.g_miss_char);
285: l_location_rec.po_box_number := Nvl(p_address_rec.po_box_number, CSC_RESPONSE_CENTER_PKG_V2.g_miss_char);
286: l_location_rec.street := Nvl(p_address_rec.street, CSC_RESPONSE_CENTER_PKG_V2.g_miss_char);

Line 283: l_location_rec.county := Nvl(p_address_rec.county, CSC_RESPONSE_CENTER_PKG_V2.g_miss_char);

279: l_location_rec.county := Nvl(p_address_rec.county, CSC_RESPONSE_CENTER_PKG_V2.g_miss_char);
280: l_location_rec.country := Nvl(p_address_rec.country, CSC_RESPONSE_CENTER_PKG_V2.g_miss_char);
281: l_location_rec.postal_code := Nvl(p_address_rec.postal_code, CSC_RESPONSE_CENTER_PKG_V2.g_miss_char);
282: l_location_rec.province := Nvl(p_address_rec.province, CSC_RESPONSE_CENTER_PKG_V2.g_miss_char);
283: l_location_rec.county := Nvl(p_address_rec.county, CSC_RESPONSE_CENTER_PKG_V2.g_miss_char);
284: l_location_rec.language := Nvl(p_address_rec.language, CSC_RESPONSE_CENTER_PKG_V2.g_miss_char);
285: l_location_rec.po_box_number := Nvl(p_address_rec.po_box_number, CSC_RESPONSE_CENTER_PKG_V2.g_miss_char);
286: l_location_rec.street := Nvl(p_address_rec.street, CSC_RESPONSE_CENTER_PKG_V2.g_miss_char);
287: l_location_rec.house_number := Nvl(p_address_rec.house_number, CSC_RESPONSE_CENTER_PKG_V2.g_miss_char);

Line 284: l_location_rec.language := Nvl(p_address_rec.language, CSC_RESPONSE_CENTER_PKG_V2.g_miss_char);

280: l_location_rec.country := Nvl(p_address_rec.country, CSC_RESPONSE_CENTER_PKG_V2.g_miss_char);
281: l_location_rec.postal_code := Nvl(p_address_rec.postal_code, CSC_RESPONSE_CENTER_PKG_V2.g_miss_char);
282: l_location_rec.province := Nvl(p_address_rec.province, CSC_RESPONSE_CENTER_PKG_V2.g_miss_char);
283: l_location_rec.county := Nvl(p_address_rec.county, CSC_RESPONSE_CENTER_PKG_V2.g_miss_char);
284: l_location_rec.language := Nvl(p_address_rec.language, CSC_RESPONSE_CENTER_PKG_V2.g_miss_char);
285: l_location_rec.po_box_number := Nvl(p_address_rec.po_box_number, CSC_RESPONSE_CENTER_PKG_V2.g_miss_char);
286: l_location_rec.street := Nvl(p_address_rec.street, CSC_RESPONSE_CENTER_PKG_V2.g_miss_char);
287: l_location_rec.house_number := Nvl(p_address_rec.house_number, CSC_RESPONSE_CENTER_PKG_V2.g_miss_char);
288: l_location_rec.position := Nvl(p_address_rec.position, CSC_RESPONSE_CENTER_PKG_V2.g_miss_char);

Line 285: l_location_rec.po_box_number := Nvl(p_address_rec.po_box_number, CSC_RESPONSE_CENTER_PKG_V2.g_miss_char);

281: l_location_rec.postal_code := Nvl(p_address_rec.postal_code, CSC_RESPONSE_CENTER_PKG_V2.g_miss_char);
282: l_location_rec.province := Nvl(p_address_rec.province, CSC_RESPONSE_CENTER_PKG_V2.g_miss_char);
283: l_location_rec.county := Nvl(p_address_rec.county, CSC_RESPONSE_CENTER_PKG_V2.g_miss_char);
284: l_location_rec.language := Nvl(p_address_rec.language, CSC_RESPONSE_CENTER_PKG_V2.g_miss_char);
285: l_location_rec.po_box_number := Nvl(p_address_rec.po_box_number, CSC_RESPONSE_CENTER_PKG_V2.g_miss_char);
286: l_location_rec.street := Nvl(p_address_rec.street, CSC_RESPONSE_CENTER_PKG_V2.g_miss_char);
287: l_location_rec.house_number := Nvl(p_address_rec.house_number, CSC_RESPONSE_CENTER_PKG_V2.g_miss_char);
288: l_location_rec.position := Nvl(p_address_rec.position, CSC_RESPONSE_CENTER_PKG_V2.g_miss_char);
289: l_location_rec.address_key := Nvl(p_address_rec.address_key, CSC_RESPONSE_CENTER_PKG_V2.g_miss_char);

Line 286: l_location_rec.street := Nvl(p_address_rec.street, CSC_RESPONSE_CENTER_PKG_V2.g_miss_char);

282: l_location_rec.province := Nvl(p_address_rec.province, CSC_RESPONSE_CENTER_PKG_V2.g_miss_char);
283: l_location_rec.county := Nvl(p_address_rec.county, CSC_RESPONSE_CENTER_PKG_V2.g_miss_char);
284: l_location_rec.language := Nvl(p_address_rec.language, CSC_RESPONSE_CENTER_PKG_V2.g_miss_char);
285: l_location_rec.po_box_number := Nvl(p_address_rec.po_box_number, CSC_RESPONSE_CENTER_PKG_V2.g_miss_char);
286: l_location_rec.street := Nvl(p_address_rec.street, CSC_RESPONSE_CENTER_PKG_V2.g_miss_char);
287: l_location_rec.house_number := Nvl(p_address_rec.house_number, CSC_RESPONSE_CENTER_PKG_V2.g_miss_char);
288: l_location_rec.position := Nvl(p_address_rec.position, CSC_RESPONSE_CENTER_PKG_V2.g_miss_char);
289: l_location_rec.address_key := Nvl(p_address_rec.address_key, CSC_RESPONSE_CENTER_PKG_V2.g_miss_char);
290: l_location_rec.street_suffix := Nvl(p_address_rec.street_suffix, CSC_RESPONSE_CENTER_PKG_V2.g_miss_char);

Line 287: l_location_rec.house_number := Nvl(p_address_rec.house_number, CSC_RESPONSE_CENTER_PKG_V2.g_miss_char);

283: l_location_rec.county := Nvl(p_address_rec.county, CSC_RESPONSE_CENTER_PKG_V2.g_miss_char);
284: l_location_rec.language := Nvl(p_address_rec.language, CSC_RESPONSE_CENTER_PKG_V2.g_miss_char);
285: l_location_rec.po_box_number := Nvl(p_address_rec.po_box_number, CSC_RESPONSE_CENTER_PKG_V2.g_miss_char);
286: l_location_rec.street := Nvl(p_address_rec.street, CSC_RESPONSE_CENTER_PKG_V2.g_miss_char);
287: l_location_rec.house_number := Nvl(p_address_rec.house_number, CSC_RESPONSE_CENTER_PKG_V2.g_miss_char);
288: l_location_rec.position := Nvl(p_address_rec.position, CSC_RESPONSE_CENTER_PKG_V2.g_miss_char);
289: l_location_rec.address_key := Nvl(p_address_rec.address_key, CSC_RESPONSE_CENTER_PKG_V2.g_miss_char);
290: l_location_rec.street_suffix := Nvl(p_address_rec.street_suffix, CSC_RESPONSE_CENTER_PKG_V2.g_miss_char);
291: l_location_rec.street_number := Nvl(p_address_rec.street_number, CSC_RESPONSE_CENTER_PKG_V2.g_miss_char);

Line 288: l_location_rec.position := Nvl(p_address_rec.position, CSC_RESPONSE_CENTER_PKG_V2.g_miss_char);

284: l_location_rec.language := Nvl(p_address_rec.language, CSC_RESPONSE_CENTER_PKG_V2.g_miss_char);
285: l_location_rec.po_box_number := Nvl(p_address_rec.po_box_number, CSC_RESPONSE_CENTER_PKG_V2.g_miss_char);
286: l_location_rec.street := Nvl(p_address_rec.street, CSC_RESPONSE_CENTER_PKG_V2.g_miss_char);
287: l_location_rec.house_number := Nvl(p_address_rec.house_number, CSC_RESPONSE_CENTER_PKG_V2.g_miss_char);
288: l_location_rec.position := Nvl(p_address_rec.position, CSC_RESPONSE_CENTER_PKG_V2.g_miss_char);
289: l_location_rec.address_key := Nvl(p_address_rec.address_key, CSC_RESPONSE_CENTER_PKG_V2.g_miss_char);
290: l_location_rec.street_suffix := Nvl(p_address_rec.street_suffix, CSC_RESPONSE_CENTER_PKG_V2.g_miss_char);
291: l_location_rec.street_number := Nvl(p_address_rec.street_number, CSC_RESPONSE_CENTER_PKG_V2.g_miss_char);
292: l_location_rec.floor := Nvl(p_address_rec.floor, CSC_RESPONSE_CENTER_PKG_V2.g_miss_char);

Line 289: l_location_rec.address_key := Nvl(p_address_rec.address_key, CSC_RESPONSE_CENTER_PKG_V2.g_miss_char);

285: l_location_rec.po_box_number := Nvl(p_address_rec.po_box_number, CSC_RESPONSE_CENTER_PKG_V2.g_miss_char);
286: l_location_rec.street := Nvl(p_address_rec.street, CSC_RESPONSE_CENTER_PKG_V2.g_miss_char);
287: l_location_rec.house_number := Nvl(p_address_rec.house_number, CSC_RESPONSE_CENTER_PKG_V2.g_miss_char);
288: l_location_rec.position := Nvl(p_address_rec.position, CSC_RESPONSE_CENTER_PKG_V2.g_miss_char);
289: l_location_rec.address_key := Nvl(p_address_rec.address_key, CSC_RESPONSE_CENTER_PKG_V2.g_miss_char);
290: l_location_rec.street_suffix := Nvl(p_address_rec.street_suffix, CSC_RESPONSE_CENTER_PKG_V2.g_miss_char);
291: l_location_rec.street_number := Nvl(p_address_rec.street_number, CSC_RESPONSE_CENTER_PKG_V2.g_miss_char);
292: l_location_rec.floor := Nvl(p_address_rec.floor, CSC_RESPONSE_CENTER_PKG_V2.g_miss_char);
293: l_location_rec.suite := Nvl(p_address_rec.suite, CSC_RESPONSE_CENTER_PKG_V2.g_miss_char);

Line 290: l_location_rec.street_suffix := Nvl(p_address_rec.street_suffix, CSC_RESPONSE_CENTER_PKG_V2.g_miss_char);

286: l_location_rec.street := Nvl(p_address_rec.street, CSC_RESPONSE_CENTER_PKG_V2.g_miss_char);
287: l_location_rec.house_number := Nvl(p_address_rec.house_number, CSC_RESPONSE_CENTER_PKG_V2.g_miss_char);
288: l_location_rec.position := Nvl(p_address_rec.position, CSC_RESPONSE_CENTER_PKG_V2.g_miss_char);
289: l_location_rec.address_key := Nvl(p_address_rec.address_key, CSC_RESPONSE_CENTER_PKG_V2.g_miss_char);
290: l_location_rec.street_suffix := Nvl(p_address_rec.street_suffix, CSC_RESPONSE_CENTER_PKG_V2.g_miss_char);
291: l_location_rec.street_number := Nvl(p_address_rec.street_number, CSC_RESPONSE_CENTER_PKG_V2.g_miss_char);
292: l_location_rec.floor := Nvl(p_address_rec.floor, CSC_RESPONSE_CENTER_PKG_V2.g_miss_char);
293: l_location_rec.suite := Nvl(p_address_rec.suite, CSC_RESPONSE_CENTER_PKG_V2.g_miss_char);
294: l_location_rec.postal_plus4_code := Nvl(p_address_rec.postal_plus4_code, CSC_RESPONSE_CENTER_PKG_V2.g_miss_char);

Line 291: l_location_rec.street_number := Nvl(p_address_rec.street_number, CSC_RESPONSE_CENTER_PKG_V2.g_miss_char);

287: l_location_rec.house_number := Nvl(p_address_rec.house_number, CSC_RESPONSE_CENTER_PKG_V2.g_miss_char);
288: l_location_rec.position := Nvl(p_address_rec.position, CSC_RESPONSE_CENTER_PKG_V2.g_miss_char);
289: l_location_rec.address_key := Nvl(p_address_rec.address_key, CSC_RESPONSE_CENTER_PKG_V2.g_miss_char);
290: l_location_rec.street_suffix := Nvl(p_address_rec.street_suffix, CSC_RESPONSE_CENTER_PKG_V2.g_miss_char);
291: l_location_rec.street_number := Nvl(p_address_rec.street_number, CSC_RESPONSE_CENTER_PKG_V2.g_miss_char);
292: l_location_rec.floor := Nvl(p_address_rec.floor, CSC_RESPONSE_CENTER_PKG_V2.g_miss_char);
293: l_location_rec.suite := Nvl(p_address_rec.suite, CSC_RESPONSE_CENTER_PKG_V2.g_miss_char);
294: l_location_rec.postal_plus4_code := Nvl(p_address_rec.postal_plus4_code, CSC_RESPONSE_CENTER_PKG_V2.g_miss_char);
295: l_location_rec.delivery_point_code := Nvl(p_address_rec.delivery_point_code, CSC_RESPONSE_CENTER_PKG_V2.g_miss_char);

Line 292: l_location_rec.floor := Nvl(p_address_rec.floor, CSC_RESPONSE_CENTER_PKG_V2.g_miss_char);

288: l_location_rec.position := Nvl(p_address_rec.position, CSC_RESPONSE_CENTER_PKG_V2.g_miss_char);
289: l_location_rec.address_key := Nvl(p_address_rec.address_key, CSC_RESPONSE_CENTER_PKG_V2.g_miss_char);
290: l_location_rec.street_suffix := Nvl(p_address_rec.street_suffix, CSC_RESPONSE_CENTER_PKG_V2.g_miss_char);
291: l_location_rec.street_number := Nvl(p_address_rec.street_number, CSC_RESPONSE_CENTER_PKG_V2.g_miss_char);
292: l_location_rec.floor := Nvl(p_address_rec.floor, CSC_RESPONSE_CENTER_PKG_V2.g_miss_char);
293: l_location_rec.suite := Nvl(p_address_rec.suite, CSC_RESPONSE_CENTER_PKG_V2.g_miss_char);
294: l_location_rec.postal_plus4_code := Nvl(p_address_rec.postal_plus4_code, CSC_RESPONSE_CENTER_PKG_V2.g_miss_char);
295: l_location_rec.delivery_point_code := Nvl(p_address_rec.delivery_point_code, CSC_RESPONSE_CENTER_PKG_V2.g_miss_char);
296: l_location_rec.location_directions := Nvl(p_address_rec.location_directions, CSC_RESPONSE_CENTER_PKG_V2.g_miss_char);

Line 293: l_location_rec.suite := Nvl(p_address_rec.suite, CSC_RESPONSE_CENTER_PKG_V2.g_miss_char);

289: l_location_rec.address_key := Nvl(p_address_rec.address_key, CSC_RESPONSE_CENTER_PKG_V2.g_miss_char);
290: l_location_rec.street_suffix := Nvl(p_address_rec.street_suffix, CSC_RESPONSE_CENTER_PKG_V2.g_miss_char);
291: l_location_rec.street_number := Nvl(p_address_rec.street_number, CSC_RESPONSE_CENTER_PKG_V2.g_miss_char);
292: l_location_rec.floor := Nvl(p_address_rec.floor, CSC_RESPONSE_CENTER_PKG_V2.g_miss_char);
293: l_location_rec.suite := Nvl(p_address_rec.suite, CSC_RESPONSE_CENTER_PKG_V2.g_miss_char);
294: l_location_rec.postal_plus4_code := Nvl(p_address_rec.postal_plus4_code, CSC_RESPONSE_CENTER_PKG_V2.g_miss_char);
295: l_location_rec.delivery_point_code := Nvl(p_address_rec.delivery_point_code, CSC_RESPONSE_CENTER_PKG_V2.g_miss_char);
296: l_location_rec.location_directions := Nvl(p_address_rec.location_directions, CSC_RESPONSE_CENTER_PKG_V2.g_miss_char);
297: l_location_rec.clli_code := Nvl(p_address_rec.clli_code, CSC_RESPONSE_CENTER_PKG_V2.g_miss_char);

Line 294: l_location_rec.postal_plus4_code := Nvl(p_address_rec.postal_plus4_code, CSC_RESPONSE_CENTER_PKG_V2.g_miss_char);

290: l_location_rec.street_suffix := Nvl(p_address_rec.street_suffix, CSC_RESPONSE_CENTER_PKG_V2.g_miss_char);
291: l_location_rec.street_number := Nvl(p_address_rec.street_number, CSC_RESPONSE_CENTER_PKG_V2.g_miss_char);
292: l_location_rec.floor := Nvl(p_address_rec.floor, CSC_RESPONSE_CENTER_PKG_V2.g_miss_char);
293: l_location_rec.suite := Nvl(p_address_rec.suite, CSC_RESPONSE_CENTER_PKG_V2.g_miss_char);
294: l_location_rec.postal_plus4_code := Nvl(p_address_rec.postal_plus4_code, CSC_RESPONSE_CENTER_PKG_V2.g_miss_char);
295: l_location_rec.delivery_point_code := Nvl(p_address_rec.delivery_point_code, CSC_RESPONSE_CENTER_PKG_V2.g_miss_char);
296: l_location_rec.location_directions := Nvl(p_address_rec.location_directions, CSC_RESPONSE_CENTER_PKG_V2.g_miss_char);
297: l_location_rec.clli_code := Nvl(p_address_rec.clli_code, CSC_RESPONSE_CENTER_PKG_V2.g_miss_char);
298: l_location_rec.short_description := Nvl(p_address_rec.short_description, CSC_RESPONSE_CENTER_PKG_V2.g_miss_char);

Line 295: l_location_rec.delivery_point_code := Nvl(p_address_rec.delivery_point_code, CSC_RESPONSE_CENTER_PKG_V2.g_miss_char);

291: l_location_rec.street_number := Nvl(p_address_rec.street_number, CSC_RESPONSE_CENTER_PKG_V2.g_miss_char);
292: l_location_rec.floor := Nvl(p_address_rec.floor, CSC_RESPONSE_CENTER_PKG_V2.g_miss_char);
293: l_location_rec.suite := Nvl(p_address_rec.suite, CSC_RESPONSE_CENTER_PKG_V2.g_miss_char);
294: l_location_rec.postal_plus4_code := Nvl(p_address_rec.postal_plus4_code, CSC_RESPONSE_CENTER_PKG_V2.g_miss_char);
295: l_location_rec.delivery_point_code := Nvl(p_address_rec.delivery_point_code, CSC_RESPONSE_CENTER_PKG_V2.g_miss_char);
296: l_location_rec.location_directions := Nvl(p_address_rec.location_directions, CSC_RESPONSE_CENTER_PKG_V2.g_miss_char);
297: l_location_rec.clli_code := Nvl(p_address_rec.clli_code, CSC_RESPONSE_CENTER_PKG_V2.g_miss_char);
298: l_location_rec.short_description := Nvl(p_address_rec.short_description, CSC_RESPONSE_CENTER_PKG_V2.g_miss_char);
299: l_location_rec.description := Nvl(p_address_rec.description, CSC_RESPONSE_CENTER_PKG_V2.g_miss_char);

Line 296: l_location_rec.location_directions := Nvl(p_address_rec.location_directions, CSC_RESPONSE_CENTER_PKG_V2.g_miss_char);

292: l_location_rec.floor := Nvl(p_address_rec.floor, CSC_RESPONSE_CENTER_PKG_V2.g_miss_char);
293: l_location_rec.suite := Nvl(p_address_rec.suite, CSC_RESPONSE_CENTER_PKG_V2.g_miss_char);
294: l_location_rec.postal_plus4_code := Nvl(p_address_rec.postal_plus4_code, CSC_RESPONSE_CENTER_PKG_V2.g_miss_char);
295: l_location_rec.delivery_point_code := Nvl(p_address_rec.delivery_point_code, CSC_RESPONSE_CENTER_PKG_V2.g_miss_char);
296: l_location_rec.location_directions := Nvl(p_address_rec.location_directions, CSC_RESPONSE_CENTER_PKG_V2.g_miss_char);
297: l_location_rec.clli_code := Nvl(p_address_rec.clli_code, CSC_RESPONSE_CENTER_PKG_V2.g_miss_char);
298: l_location_rec.short_description := Nvl(p_address_rec.short_description, CSC_RESPONSE_CENTER_PKG_V2.g_miss_char);
299: l_location_rec.description := Nvl(p_address_rec.description, CSC_RESPONSE_CENTER_PKG_V2.g_miss_char);
300: l_location_rec.sales_tax_geocode := Nvl(p_address_rec.sales_tax_geocode, CSC_RESPONSE_CENTER_PKG_V2.g_miss_char);

Line 297: l_location_rec.clli_code := Nvl(p_address_rec.clli_code, CSC_RESPONSE_CENTER_PKG_V2.g_miss_char);

293: l_location_rec.suite := Nvl(p_address_rec.suite, CSC_RESPONSE_CENTER_PKG_V2.g_miss_char);
294: l_location_rec.postal_plus4_code := Nvl(p_address_rec.postal_plus4_code, CSC_RESPONSE_CENTER_PKG_V2.g_miss_char);
295: l_location_rec.delivery_point_code := Nvl(p_address_rec.delivery_point_code, CSC_RESPONSE_CENTER_PKG_V2.g_miss_char);
296: l_location_rec.location_directions := Nvl(p_address_rec.location_directions, CSC_RESPONSE_CENTER_PKG_V2.g_miss_char);
297: l_location_rec.clli_code := Nvl(p_address_rec.clli_code, CSC_RESPONSE_CENTER_PKG_V2.g_miss_char);
298: l_location_rec.short_description := Nvl(p_address_rec.short_description, CSC_RESPONSE_CENTER_PKG_V2.g_miss_char);
299: l_location_rec.description := Nvl(p_address_rec.description, CSC_RESPONSE_CENTER_PKG_V2.g_miss_char);
300: l_location_rec.sales_tax_geocode := Nvl(p_address_rec.sales_tax_geocode, CSC_RESPONSE_CENTER_PKG_V2.g_miss_char);
301: l_location_rec.sales_tax_inside_city_limits := Nvl(p_address_rec.sales_tax_inside_city_limits, CSC_RESPONSE_CENTER_PKG_V2.g_miss_char);

Line 298: l_location_rec.short_description := Nvl(p_address_rec.short_description, CSC_RESPONSE_CENTER_PKG_V2.g_miss_char);

294: l_location_rec.postal_plus4_code := Nvl(p_address_rec.postal_plus4_code, CSC_RESPONSE_CENTER_PKG_V2.g_miss_char);
295: l_location_rec.delivery_point_code := Nvl(p_address_rec.delivery_point_code, CSC_RESPONSE_CENTER_PKG_V2.g_miss_char);
296: l_location_rec.location_directions := Nvl(p_address_rec.location_directions, CSC_RESPONSE_CENTER_PKG_V2.g_miss_char);
297: l_location_rec.clli_code := Nvl(p_address_rec.clli_code, CSC_RESPONSE_CENTER_PKG_V2.g_miss_char);
298: l_location_rec.short_description := Nvl(p_address_rec.short_description, CSC_RESPONSE_CENTER_PKG_V2.g_miss_char);
299: l_location_rec.description := Nvl(p_address_rec.description, CSC_RESPONSE_CENTER_PKG_V2.g_miss_char);
300: l_location_rec.sales_tax_geocode := Nvl(p_address_rec.sales_tax_geocode, CSC_RESPONSE_CENTER_PKG_V2.g_miss_char);
301: l_location_rec.sales_tax_inside_city_limits := Nvl(p_address_rec.sales_tax_inside_city_limits, CSC_RESPONSE_CENTER_PKG_V2.g_miss_char);
302: --Begin Fix for Bug 7033623 by spamujul

Line 299: l_location_rec.description := Nvl(p_address_rec.description, CSC_RESPONSE_CENTER_PKG_V2.g_miss_char);

295: l_location_rec.delivery_point_code := Nvl(p_address_rec.delivery_point_code, CSC_RESPONSE_CENTER_PKG_V2.g_miss_char);
296: l_location_rec.location_directions := Nvl(p_address_rec.location_directions, CSC_RESPONSE_CENTER_PKG_V2.g_miss_char);
297: l_location_rec.clli_code := Nvl(p_address_rec.clli_code, CSC_RESPONSE_CENTER_PKG_V2.g_miss_char);
298: l_location_rec.short_description := Nvl(p_address_rec.short_description, CSC_RESPONSE_CENTER_PKG_V2.g_miss_char);
299: l_location_rec.description := Nvl(p_address_rec.description, CSC_RESPONSE_CENTER_PKG_V2.g_miss_char);
300: l_location_rec.sales_tax_geocode := Nvl(p_address_rec.sales_tax_geocode, CSC_RESPONSE_CENTER_PKG_V2.g_miss_char);
301: l_location_rec.sales_tax_inside_city_limits := Nvl(p_address_rec.sales_tax_inside_city_limits, CSC_RESPONSE_CENTER_PKG_V2.g_miss_char);
302: --Begin Fix for Bug 7033623 by spamujul
303: -- l_location_rec.timezone_id := Nvl(p_address_rec.timezone_id, CSC_RESPONSE_CENTER_PKG_V2.g_miss_num);

Line 300: l_location_rec.sales_tax_geocode := Nvl(p_address_rec.sales_tax_geocode, CSC_RESPONSE_CENTER_PKG_V2.g_miss_char);

296: l_location_rec.location_directions := Nvl(p_address_rec.location_directions, CSC_RESPONSE_CENTER_PKG_V2.g_miss_char);
297: l_location_rec.clli_code := Nvl(p_address_rec.clli_code, CSC_RESPONSE_CENTER_PKG_V2.g_miss_char);
298: l_location_rec.short_description := Nvl(p_address_rec.short_description, CSC_RESPONSE_CENTER_PKG_V2.g_miss_char);
299: l_location_rec.description := Nvl(p_address_rec.description, CSC_RESPONSE_CENTER_PKG_V2.g_miss_char);
300: l_location_rec.sales_tax_geocode := Nvl(p_address_rec.sales_tax_geocode, CSC_RESPONSE_CENTER_PKG_V2.g_miss_char);
301: l_location_rec.sales_tax_inside_city_limits := Nvl(p_address_rec.sales_tax_inside_city_limits, CSC_RESPONSE_CENTER_PKG_V2.g_miss_char);
302: --Begin Fix for Bug 7033623 by spamujul
303: -- l_location_rec.timezone_id := Nvl(p_address_rec.timezone_id, CSC_RESPONSE_CENTER_PKG_V2.g_miss_num);
304: if l_location_rec.timezone_id <> CSC_RESPONSE_CENTER_PKG_V2.g_miss_num then

Line 301: l_location_rec.sales_tax_inside_city_limits := Nvl(p_address_rec.sales_tax_inside_city_limits, CSC_RESPONSE_CENTER_PKG_V2.g_miss_char);

297: l_location_rec.clli_code := Nvl(p_address_rec.clli_code, CSC_RESPONSE_CENTER_PKG_V2.g_miss_char);
298: l_location_rec.short_description := Nvl(p_address_rec.short_description, CSC_RESPONSE_CENTER_PKG_V2.g_miss_char);
299: l_location_rec.description := Nvl(p_address_rec.description, CSC_RESPONSE_CENTER_PKG_V2.g_miss_char);
300: l_location_rec.sales_tax_geocode := Nvl(p_address_rec.sales_tax_geocode, CSC_RESPONSE_CENTER_PKG_V2.g_miss_char);
301: l_location_rec.sales_tax_inside_city_limits := Nvl(p_address_rec.sales_tax_inside_city_limits, CSC_RESPONSE_CENTER_PKG_V2.g_miss_char);
302: --Begin Fix for Bug 7033623 by spamujul
303: -- l_location_rec.timezone_id := Nvl(p_address_rec.timezone_id, CSC_RESPONSE_CENTER_PKG_V2.g_miss_num);
304: if l_location_rec.timezone_id <> CSC_RESPONSE_CENTER_PKG_V2.g_miss_num then
305: l_location_rec.timezone_id := p_address_rec.timezone_id;

Line 303: -- l_location_rec.timezone_id := Nvl(p_address_rec.timezone_id, CSC_RESPONSE_CENTER_PKG_V2.g_miss_num);

299: l_location_rec.description := Nvl(p_address_rec.description, CSC_RESPONSE_CENTER_PKG_V2.g_miss_char);
300: l_location_rec.sales_tax_geocode := Nvl(p_address_rec.sales_tax_geocode, CSC_RESPONSE_CENTER_PKG_V2.g_miss_char);
301: l_location_rec.sales_tax_inside_city_limits := Nvl(p_address_rec.sales_tax_inside_city_limits, CSC_RESPONSE_CENTER_PKG_V2.g_miss_char);
302: --Begin Fix for Bug 7033623 by spamujul
303: -- l_location_rec.timezone_id := Nvl(p_address_rec.timezone_id, CSC_RESPONSE_CENTER_PKG_V2.g_miss_num);
304: if l_location_rec.timezone_id <> CSC_RESPONSE_CENTER_PKG_V2.g_miss_num then
305: l_location_rec.timezone_id := p_address_rec.timezone_id;
306: else
307: l_location_rec.timezone_id := null;

Line 304: if l_location_rec.timezone_id <> CSC_RESPONSE_CENTER_PKG_V2.g_miss_num then

300: l_location_rec.sales_tax_geocode := Nvl(p_address_rec.sales_tax_geocode, CSC_RESPONSE_CENTER_PKG_V2.g_miss_char);
301: l_location_rec.sales_tax_inside_city_limits := Nvl(p_address_rec.sales_tax_inside_city_limits, CSC_RESPONSE_CENTER_PKG_V2.g_miss_char);
302: --Begin Fix for Bug 7033623 by spamujul
303: -- l_location_rec.timezone_id := Nvl(p_address_rec.timezone_id, CSC_RESPONSE_CENTER_PKG_V2.g_miss_num);
304: if l_location_rec.timezone_id <> CSC_RESPONSE_CENTER_PKG_V2.g_miss_num then
305: l_location_rec.timezone_id := p_address_rec.timezone_id;
306: else
307: l_location_rec.timezone_id := null;
308: end if;

Line 325: END CSC_RESPONSE_CENTER_PKG_V2;

321: x_msg_data := l_msg_data;
322:
323: End Update_Address;
324:
325: END CSC_RESPONSE_CENTER_PKG_V2;
326: