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.12 2011/08/19 05:07:06 spamujul 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 329: l_location_rec.address1 := Nvl(p_address_rec.address1, CSC_RESPONSE_CENTER_PKG_V2.g_miss_char);

325: l_addr_warn_msg VARCHAR2(2000);
326: /* End of NCR July'09 Bug 8435112 */
327:
328: BEGIN
329: l_location_rec.address1 := Nvl(p_address_rec.address1, CSC_RESPONSE_CENTER_PKG_V2.g_miss_char);
330: l_location_rec.address2 := Nvl(p_address_rec.address2, CSC_RESPONSE_CENTER_PKG_V2.g_miss_char);
331: l_location_rec.address3 := Nvl(p_address_rec.address3, CSC_RESPONSE_CENTER_PKG_V2.g_miss_char);
332: l_location_rec.address4 := Nvl(p_address_rec.address4, CSC_RESPONSE_CENTER_PKG_V2.g_miss_char);
333: l_location_rec.address_lines_phonetic := Nvl(p_address_rec.address_lines_phonetic, CSC_RESPONSE_CENTER_PKG_V2.g_miss_char);

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

326: /* End of NCR July'09 Bug 8435112 */
327:
328: BEGIN
329: l_location_rec.address1 := Nvl(p_address_rec.address1, CSC_RESPONSE_CENTER_PKG_V2.g_miss_char);
330: l_location_rec.address2 := Nvl(p_address_rec.address2, CSC_RESPONSE_CENTER_PKG_V2.g_miss_char);
331: l_location_rec.address3 := Nvl(p_address_rec.address3, CSC_RESPONSE_CENTER_PKG_V2.g_miss_char);
332: l_location_rec.address4 := Nvl(p_address_rec.address4, CSC_RESPONSE_CENTER_PKG_V2.g_miss_char);
333: l_location_rec.address_lines_phonetic := Nvl(p_address_rec.address_lines_phonetic, CSC_RESPONSE_CENTER_PKG_V2.g_miss_char);
334: l_location_rec.city := Nvl(p_address_rec.city, CSC_RESPONSE_CENTER_PKG_V2.g_miss_char);

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

327:
328: BEGIN
329: l_location_rec.address1 := Nvl(p_address_rec.address1, CSC_RESPONSE_CENTER_PKG_V2.g_miss_char);
330: l_location_rec.address2 := Nvl(p_address_rec.address2, CSC_RESPONSE_CENTER_PKG_V2.g_miss_char);
331: l_location_rec.address3 := Nvl(p_address_rec.address3, CSC_RESPONSE_CENTER_PKG_V2.g_miss_char);
332: l_location_rec.address4 := Nvl(p_address_rec.address4, CSC_RESPONSE_CENTER_PKG_V2.g_miss_char);
333: l_location_rec.address_lines_phonetic := Nvl(p_address_rec.address_lines_phonetic, CSC_RESPONSE_CENTER_PKG_V2.g_miss_char);
334: l_location_rec.city := Nvl(p_address_rec.city, CSC_RESPONSE_CENTER_PKG_V2.g_miss_char);
335: l_location_rec.state := Nvl(p_address_rec.state, CSC_RESPONSE_CENTER_PKG_V2.g_miss_char);

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

328: BEGIN
329: l_location_rec.address1 := Nvl(p_address_rec.address1, CSC_RESPONSE_CENTER_PKG_V2.g_miss_char);
330: l_location_rec.address2 := Nvl(p_address_rec.address2, CSC_RESPONSE_CENTER_PKG_V2.g_miss_char);
331: l_location_rec.address3 := Nvl(p_address_rec.address3, CSC_RESPONSE_CENTER_PKG_V2.g_miss_char);
332: l_location_rec.address4 := Nvl(p_address_rec.address4, CSC_RESPONSE_CENTER_PKG_V2.g_miss_char);
333: l_location_rec.address_lines_phonetic := Nvl(p_address_rec.address_lines_phonetic, CSC_RESPONSE_CENTER_PKG_V2.g_miss_char);
334: l_location_rec.city := Nvl(p_address_rec.city, CSC_RESPONSE_CENTER_PKG_V2.g_miss_char);
335: l_location_rec.state := Nvl(p_address_rec.state, CSC_RESPONSE_CENTER_PKG_V2.g_miss_char);
336: l_location_rec.county := Nvl(p_address_rec.county, CSC_RESPONSE_CENTER_PKG_V2.g_miss_char);

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

329: l_location_rec.address1 := Nvl(p_address_rec.address1, CSC_RESPONSE_CENTER_PKG_V2.g_miss_char);
330: l_location_rec.address2 := Nvl(p_address_rec.address2, CSC_RESPONSE_CENTER_PKG_V2.g_miss_char);
331: l_location_rec.address3 := Nvl(p_address_rec.address3, CSC_RESPONSE_CENTER_PKG_V2.g_miss_char);
332: l_location_rec.address4 := Nvl(p_address_rec.address4, CSC_RESPONSE_CENTER_PKG_V2.g_miss_char);
333: l_location_rec.address_lines_phonetic := Nvl(p_address_rec.address_lines_phonetic, CSC_RESPONSE_CENTER_PKG_V2.g_miss_char);
334: l_location_rec.city := Nvl(p_address_rec.city, CSC_RESPONSE_CENTER_PKG_V2.g_miss_char);
335: l_location_rec.state := Nvl(p_address_rec.state, CSC_RESPONSE_CENTER_PKG_V2.g_miss_char);
336: l_location_rec.county := Nvl(p_address_rec.county, CSC_RESPONSE_CENTER_PKG_V2.g_miss_char);
337: l_location_rec.country := Nvl(p_address_rec.country, CSC_RESPONSE_CENTER_PKG_V2.g_miss_char);

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

330: l_location_rec.address2 := Nvl(p_address_rec.address2, CSC_RESPONSE_CENTER_PKG_V2.g_miss_char);
331: l_location_rec.address3 := Nvl(p_address_rec.address3, CSC_RESPONSE_CENTER_PKG_V2.g_miss_char);
332: l_location_rec.address4 := Nvl(p_address_rec.address4, CSC_RESPONSE_CENTER_PKG_V2.g_miss_char);
333: l_location_rec.address_lines_phonetic := Nvl(p_address_rec.address_lines_phonetic, CSC_RESPONSE_CENTER_PKG_V2.g_miss_char);
334: l_location_rec.city := Nvl(p_address_rec.city, CSC_RESPONSE_CENTER_PKG_V2.g_miss_char);
335: l_location_rec.state := Nvl(p_address_rec.state, CSC_RESPONSE_CENTER_PKG_V2.g_miss_char);
336: l_location_rec.county := Nvl(p_address_rec.county, CSC_RESPONSE_CENTER_PKG_V2.g_miss_char);
337: l_location_rec.country := Nvl(p_address_rec.country, CSC_RESPONSE_CENTER_PKG_V2.g_miss_char);
338: l_location_rec.postal_code := Nvl(p_address_rec.postal_code, CSC_RESPONSE_CENTER_PKG_V2.g_miss_char);

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

331: l_location_rec.address3 := Nvl(p_address_rec.address3, CSC_RESPONSE_CENTER_PKG_V2.g_miss_char);
332: l_location_rec.address4 := Nvl(p_address_rec.address4, CSC_RESPONSE_CENTER_PKG_V2.g_miss_char);
333: l_location_rec.address_lines_phonetic := Nvl(p_address_rec.address_lines_phonetic, CSC_RESPONSE_CENTER_PKG_V2.g_miss_char);
334: l_location_rec.city := Nvl(p_address_rec.city, CSC_RESPONSE_CENTER_PKG_V2.g_miss_char);
335: l_location_rec.state := Nvl(p_address_rec.state, CSC_RESPONSE_CENTER_PKG_V2.g_miss_char);
336: l_location_rec.county := Nvl(p_address_rec.county, CSC_RESPONSE_CENTER_PKG_V2.g_miss_char);
337: l_location_rec.country := Nvl(p_address_rec.country, CSC_RESPONSE_CENTER_PKG_V2.g_miss_char);
338: l_location_rec.postal_code := Nvl(p_address_rec.postal_code, CSC_RESPONSE_CENTER_PKG_V2.g_miss_char);
339: l_location_rec.province := Nvl(p_address_rec.province, CSC_RESPONSE_CENTER_PKG_V2.g_miss_char);

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

332: l_location_rec.address4 := Nvl(p_address_rec.address4, CSC_RESPONSE_CENTER_PKG_V2.g_miss_char);
333: l_location_rec.address_lines_phonetic := Nvl(p_address_rec.address_lines_phonetic, CSC_RESPONSE_CENTER_PKG_V2.g_miss_char);
334: l_location_rec.city := Nvl(p_address_rec.city, CSC_RESPONSE_CENTER_PKG_V2.g_miss_char);
335: l_location_rec.state := Nvl(p_address_rec.state, CSC_RESPONSE_CENTER_PKG_V2.g_miss_char);
336: l_location_rec.county := Nvl(p_address_rec.county, CSC_RESPONSE_CENTER_PKG_V2.g_miss_char);
337: l_location_rec.country := Nvl(p_address_rec.country, CSC_RESPONSE_CENTER_PKG_V2.g_miss_char);
338: l_location_rec.postal_code := Nvl(p_address_rec.postal_code, CSC_RESPONSE_CENTER_PKG_V2.g_miss_char);
339: l_location_rec.province := Nvl(p_address_rec.province, CSC_RESPONSE_CENTER_PKG_V2.g_miss_char);
340: l_location_rec.county := Nvl(p_address_rec.county, CSC_RESPONSE_CENTER_PKG_V2.g_miss_char);

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

333: l_location_rec.address_lines_phonetic := Nvl(p_address_rec.address_lines_phonetic, CSC_RESPONSE_CENTER_PKG_V2.g_miss_char);
334: l_location_rec.city := Nvl(p_address_rec.city, CSC_RESPONSE_CENTER_PKG_V2.g_miss_char);
335: l_location_rec.state := Nvl(p_address_rec.state, CSC_RESPONSE_CENTER_PKG_V2.g_miss_char);
336: l_location_rec.county := Nvl(p_address_rec.county, CSC_RESPONSE_CENTER_PKG_V2.g_miss_char);
337: l_location_rec.country := Nvl(p_address_rec.country, CSC_RESPONSE_CENTER_PKG_V2.g_miss_char);
338: l_location_rec.postal_code := Nvl(p_address_rec.postal_code, CSC_RESPONSE_CENTER_PKG_V2.g_miss_char);
339: l_location_rec.province := Nvl(p_address_rec.province, CSC_RESPONSE_CENTER_PKG_V2.g_miss_char);
340: l_location_rec.county := Nvl(p_address_rec.county, CSC_RESPONSE_CENTER_PKG_V2.g_miss_char);
341: l_location_rec.language := Nvl(p_address_rec.language, CSC_RESPONSE_CENTER_PKG_V2.g_miss_char);

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

334: l_location_rec.city := Nvl(p_address_rec.city, CSC_RESPONSE_CENTER_PKG_V2.g_miss_char);
335: l_location_rec.state := Nvl(p_address_rec.state, CSC_RESPONSE_CENTER_PKG_V2.g_miss_char);
336: l_location_rec.county := Nvl(p_address_rec.county, CSC_RESPONSE_CENTER_PKG_V2.g_miss_char);
337: l_location_rec.country := Nvl(p_address_rec.country, CSC_RESPONSE_CENTER_PKG_V2.g_miss_char);
338: l_location_rec.postal_code := Nvl(p_address_rec.postal_code, CSC_RESPONSE_CENTER_PKG_V2.g_miss_char);
339: l_location_rec.province := Nvl(p_address_rec.province, CSC_RESPONSE_CENTER_PKG_V2.g_miss_char);
340: l_location_rec.county := Nvl(p_address_rec.county, CSC_RESPONSE_CENTER_PKG_V2.g_miss_char);
341: l_location_rec.language := Nvl(p_address_rec.language, CSC_RESPONSE_CENTER_PKG_V2.g_miss_char);
342: l_location_rec.po_box_number := Nvl(p_address_rec.po_box_number, CSC_RESPONSE_CENTER_PKG_V2.g_miss_char);

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

335: l_location_rec.state := Nvl(p_address_rec.state, CSC_RESPONSE_CENTER_PKG_V2.g_miss_char);
336: l_location_rec.county := Nvl(p_address_rec.county, CSC_RESPONSE_CENTER_PKG_V2.g_miss_char);
337: l_location_rec.country := Nvl(p_address_rec.country, CSC_RESPONSE_CENTER_PKG_V2.g_miss_char);
338: l_location_rec.postal_code := Nvl(p_address_rec.postal_code, CSC_RESPONSE_CENTER_PKG_V2.g_miss_char);
339: l_location_rec.province := Nvl(p_address_rec.province, CSC_RESPONSE_CENTER_PKG_V2.g_miss_char);
340: l_location_rec.county := Nvl(p_address_rec.county, CSC_RESPONSE_CENTER_PKG_V2.g_miss_char);
341: l_location_rec.language := Nvl(p_address_rec.language, CSC_RESPONSE_CENTER_PKG_V2.g_miss_char);
342: l_location_rec.po_box_number := Nvl(p_address_rec.po_box_number, CSC_RESPONSE_CENTER_PKG_V2.g_miss_char);
343: l_location_rec.street := Nvl(p_address_rec.street, CSC_RESPONSE_CENTER_PKG_V2.g_miss_char);

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

336: l_location_rec.county := Nvl(p_address_rec.county, CSC_RESPONSE_CENTER_PKG_V2.g_miss_char);
337: l_location_rec.country := Nvl(p_address_rec.country, CSC_RESPONSE_CENTER_PKG_V2.g_miss_char);
338: l_location_rec.postal_code := Nvl(p_address_rec.postal_code, CSC_RESPONSE_CENTER_PKG_V2.g_miss_char);
339: l_location_rec.province := Nvl(p_address_rec.province, CSC_RESPONSE_CENTER_PKG_V2.g_miss_char);
340: l_location_rec.county := Nvl(p_address_rec.county, CSC_RESPONSE_CENTER_PKG_V2.g_miss_char);
341: l_location_rec.language := Nvl(p_address_rec.language, CSC_RESPONSE_CENTER_PKG_V2.g_miss_char);
342: l_location_rec.po_box_number := Nvl(p_address_rec.po_box_number, CSC_RESPONSE_CENTER_PKG_V2.g_miss_char);
343: l_location_rec.street := Nvl(p_address_rec.street, CSC_RESPONSE_CENTER_PKG_V2.g_miss_char);
344: l_location_rec.house_number := Nvl(p_address_rec.house_number, CSC_RESPONSE_CENTER_PKG_V2.g_miss_char);

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

337: l_location_rec.country := Nvl(p_address_rec.country, CSC_RESPONSE_CENTER_PKG_V2.g_miss_char);
338: l_location_rec.postal_code := Nvl(p_address_rec.postal_code, CSC_RESPONSE_CENTER_PKG_V2.g_miss_char);
339: l_location_rec.province := Nvl(p_address_rec.province, CSC_RESPONSE_CENTER_PKG_V2.g_miss_char);
340: l_location_rec.county := Nvl(p_address_rec.county, CSC_RESPONSE_CENTER_PKG_V2.g_miss_char);
341: l_location_rec.language := Nvl(p_address_rec.language, CSC_RESPONSE_CENTER_PKG_V2.g_miss_char);
342: l_location_rec.po_box_number := Nvl(p_address_rec.po_box_number, CSC_RESPONSE_CENTER_PKG_V2.g_miss_char);
343: l_location_rec.street := Nvl(p_address_rec.street, CSC_RESPONSE_CENTER_PKG_V2.g_miss_char);
344: l_location_rec.house_number := Nvl(p_address_rec.house_number, CSC_RESPONSE_CENTER_PKG_V2.g_miss_char);
345: l_location_rec.position := Nvl(p_address_rec.position, CSC_RESPONSE_CENTER_PKG_V2.g_miss_char);

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

338: l_location_rec.postal_code := Nvl(p_address_rec.postal_code, CSC_RESPONSE_CENTER_PKG_V2.g_miss_char);
339: l_location_rec.province := Nvl(p_address_rec.province, CSC_RESPONSE_CENTER_PKG_V2.g_miss_char);
340: l_location_rec.county := Nvl(p_address_rec.county, CSC_RESPONSE_CENTER_PKG_V2.g_miss_char);
341: l_location_rec.language := Nvl(p_address_rec.language, CSC_RESPONSE_CENTER_PKG_V2.g_miss_char);
342: l_location_rec.po_box_number := Nvl(p_address_rec.po_box_number, CSC_RESPONSE_CENTER_PKG_V2.g_miss_char);
343: l_location_rec.street := Nvl(p_address_rec.street, CSC_RESPONSE_CENTER_PKG_V2.g_miss_char);
344: l_location_rec.house_number := Nvl(p_address_rec.house_number, CSC_RESPONSE_CENTER_PKG_V2.g_miss_char);
345: l_location_rec.position := Nvl(p_address_rec.position, CSC_RESPONSE_CENTER_PKG_V2.g_miss_char);
346: l_location_rec.address_key := Nvl(p_address_rec.address_key, CSC_RESPONSE_CENTER_PKG_V2.g_miss_char);

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

339: l_location_rec.province := Nvl(p_address_rec.province, CSC_RESPONSE_CENTER_PKG_V2.g_miss_char);
340: l_location_rec.county := Nvl(p_address_rec.county, CSC_RESPONSE_CENTER_PKG_V2.g_miss_char);
341: l_location_rec.language := Nvl(p_address_rec.language, CSC_RESPONSE_CENTER_PKG_V2.g_miss_char);
342: l_location_rec.po_box_number := Nvl(p_address_rec.po_box_number, CSC_RESPONSE_CENTER_PKG_V2.g_miss_char);
343: l_location_rec.street := Nvl(p_address_rec.street, CSC_RESPONSE_CENTER_PKG_V2.g_miss_char);
344: l_location_rec.house_number := Nvl(p_address_rec.house_number, CSC_RESPONSE_CENTER_PKG_V2.g_miss_char);
345: l_location_rec.position := Nvl(p_address_rec.position, CSC_RESPONSE_CENTER_PKG_V2.g_miss_char);
346: l_location_rec.address_key := Nvl(p_address_rec.address_key, CSC_RESPONSE_CENTER_PKG_V2.g_miss_char);
347: l_location_rec.street_suffix := Nvl(p_address_rec.street_suffix, CSC_RESPONSE_CENTER_PKG_V2.g_miss_char);

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

340: l_location_rec.county := Nvl(p_address_rec.county, CSC_RESPONSE_CENTER_PKG_V2.g_miss_char);
341: l_location_rec.language := Nvl(p_address_rec.language, CSC_RESPONSE_CENTER_PKG_V2.g_miss_char);
342: l_location_rec.po_box_number := Nvl(p_address_rec.po_box_number, CSC_RESPONSE_CENTER_PKG_V2.g_miss_char);
343: l_location_rec.street := Nvl(p_address_rec.street, CSC_RESPONSE_CENTER_PKG_V2.g_miss_char);
344: l_location_rec.house_number := Nvl(p_address_rec.house_number, CSC_RESPONSE_CENTER_PKG_V2.g_miss_char);
345: l_location_rec.position := Nvl(p_address_rec.position, CSC_RESPONSE_CENTER_PKG_V2.g_miss_char);
346: l_location_rec.address_key := Nvl(p_address_rec.address_key, CSC_RESPONSE_CENTER_PKG_V2.g_miss_char);
347: l_location_rec.street_suffix := Nvl(p_address_rec.street_suffix, CSC_RESPONSE_CENTER_PKG_V2.g_miss_char);
348: l_location_rec.street_number := Nvl(p_address_rec.street_number, CSC_RESPONSE_CENTER_PKG_V2.g_miss_char);

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

341: l_location_rec.language := Nvl(p_address_rec.language, CSC_RESPONSE_CENTER_PKG_V2.g_miss_char);
342: l_location_rec.po_box_number := Nvl(p_address_rec.po_box_number, CSC_RESPONSE_CENTER_PKG_V2.g_miss_char);
343: l_location_rec.street := Nvl(p_address_rec.street, CSC_RESPONSE_CENTER_PKG_V2.g_miss_char);
344: l_location_rec.house_number := Nvl(p_address_rec.house_number, CSC_RESPONSE_CENTER_PKG_V2.g_miss_char);
345: l_location_rec.position := Nvl(p_address_rec.position, CSC_RESPONSE_CENTER_PKG_V2.g_miss_char);
346: l_location_rec.address_key := Nvl(p_address_rec.address_key, CSC_RESPONSE_CENTER_PKG_V2.g_miss_char);
347: l_location_rec.street_suffix := Nvl(p_address_rec.street_suffix, CSC_RESPONSE_CENTER_PKG_V2.g_miss_char);
348: l_location_rec.street_number := Nvl(p_address_rec.street_number, CSC_RESPONSE_CENTER_PKG_V2.g_miss_char);
349: l_location_rec.floor := Nvl(p_address_rec.floor, CSC_RESPONSE_CENTER_PKG_V2.g_miss_char);

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

342: l_location_rec.po_box_number := Nvl(p_address_rec.po_box_number, CSC_RESPONSE_CENTER_PKG_V2.g_miss_char);
343: l_location_rec.street := Nvl(p_address_rec.street, CSC_RESPONSE_CENTER_PKG_V2.g_miss_char);
344: l_location_rec.house_number := Nvl(p_address_rec.house_number, CSC_RESPONSE_CENTER_PKG_V2.g_miss_char);
345: l_location_rec.position := Nvl(p_address_rec.position, CSC_RESPONSE_CENTER_PKG_V2.g_miss_char);
346: l_location_rec.address_key := Nvl(p_address_rec.address_key, CSC_RESPONSE_CENTER_PKG_V2.g_miss_char);
347: l_location_rec.street_suffix := Nvl(p_address_rec.street_suffix, CSC_RESPONSE_CENTER_PKG_V2.g_miss_char);
348: l_location_rec.street_number := Nvl(p_address_rec.street_number, CSC_RESPONSE_CENTER_PKG_V2.g_miss_char);
349: l_location_rec.floor := Nvl(p_address_rec.floor, CSC_RESPONSE_CENTER_PKG_V2.g_miss_char);
350: l_location_rec.suite := Nvl(p_address_rec.suite, CSC_RESPONSE_CENTER_PKG_V2.g_miss_char);

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

343: l_location_rec.street := Nvl(p_address_rec.street, CSC_RESPONSE_CENTER_PKG_V2.g_miss_char);
344: l_location_rec.house_number := Nvl(p_address_rec.house_number, CSC_RESPONSE_CENTER_PKG_V2.g_miss_char);
345: l_location_rec.position := Nvl(p_address_rec.position, CSC_RESPONSE_CENTER_PKG_V2.g_miss_char);
346: l_location_rec.address_key := Nvl(p_address_rec.address_key, CSC_RESPONSE_CENTER_PKG_V2.g_miss_char);
347: l_location_rec.street_suffix := Nvl(p_address_rec.street_suffix, CSC_RESPONSE_CENTER_PKG_V2.g_miss_char);
348: l_location_rec.street_number := Nvl(p_address_rec.street_number, CSC_RESPONSE_CENTER_PKG_V2.g_miss_char);
349: l_location_rec.floor := Nvl(p_address_rec.floor, CSC_RESPONSE_CENTER_PKG_V2.g_miss_char);
350: l_location_rec.suite := Nvl(p_address_rec.suite, CSC_RESPONSE_CENTER_PKG_V2.g_miss_char);
351: l_location_rec.postal_plus4_code := Nvl(p_address_rec.postal_plus4_code, CSC_RESPONSE_CENTER_PKG_V2.g_miss_char);

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

344: l_location_rec.house_number := Nvl(p_address_rec.house_number, CSC_RESPONSE_CENTER_PKG_V2.g_miss_char);
345: l_location_rec.position := Nvl(p_address_rec.position, CSC_RESPONSE_CENTER_PKG_V2.g_miss_char);
346: l_location_rec.address_key := Nvl(p_address_rec.address_key, CSC_RESPONSE_CENTER_PKG_V2.g_miss_char);
347: l_location_rec.street_suffix := Nvl(p_address_rec.street_suffix, CSC_RESPONSE_CENTER_PKG_V2.g_miss_char);
348: l_location_rec.street_number := Nvl(p_address_rec.street_number, CSC_RESPONSE_CENTER_PKG_V2.g_miss_char);
349: l_location_rec.floor := Nvl(p_address_rec.floor, CSC_RESPONSE_CENTER_PKG_V2.g_miss_char);
350: l_location_rec.suite := Nvl(p_address_rec.suite, CSC_RESPONSE_CENTER_PKG_V2.g_miss_char);
351: l_location_rec.postal_plus4_code := Nvl(p_address_rec.postal_plus4_code, CSC_RESPONSE_CENTER_PKG_V2.g_miss_char);
352: l_location_rec.delivery_point_code := Nvl(p_address_rec.delivery_point_code, CSC_RESPONSE_CENTER_PKG_V2.g_miss_char);

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

345: l_location_rec.position := Nvl(p_address_rec.position, CSC_RESPONSE_CENTER_PKG_V2.g_miss_char);
346: l_location_rec.address_key := Nvl(p_address_rec.address_key, CSC_RESPONSE_CENTER_PKG_V2.g_miss_char);
347: l_location_rec.street_suffix := Nvl(p_address_rec.street_suffix, CSC_RESPONSE_CENTER_PKG_V2.g_miss_char);
348: l_location_rec.street_number := Nvl(p_address_rec.street_number, CSC_RESPONSE_CENTER_PKG_V2.g_miss_char);
349: l_location_rec.floor := Nvl(p_address_rec.floor, CSC_RESPONSE_CENTER_PKG_V2.g_miss_char);
350: l_location_rec.suite := Nvl(p_address_rec.suite, CSC_RESPONSE_CENTER_PKG_V2.g_miss_char);
351: l_location_rec.postal_plus4_code := Nvl(p_address_rec.postal_plus4_code, CSC_RESPONSE_CENTER_PKG_V2.g_miss_char);
352: l_location_rec.delivery_point_code := Nvl(p_address_rec.delivery_point_code, CSC_RESPONSE_CENTER_PKG_V2.g_miss_char);
353: l_location_rec.location_directions := Nvl(p_address_rec.location_directions, CSC_RESPONSE_CENTER_PKG_V2.g_miss_char);

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

346: l_location_rec.address_key := Nvl(p_address_rec.address_key, CSC_RESPONSE_CENTER_PKG_V2.g_miss_char);
347: l_location_rec.street_suffix := Nvl(p_address_rec.street_suffix, CSC_RESPONSE_CENTER_PKG_V2.g_miss_char);
348: l_location_rec.street_number := Nvl(p_address_rec.street_number, CSC_RESPONSE_CENTER_PKG_V2.g_miss_char);
349: l_location_rec.floor := Nvl(p_address_rec.floor, CSC_RESPONSE_CENTER_PKG_V2.g_miss_char);
350: l_location_rec.suite := Nvl(p_address_rec.suite, CSC_RESPONSE_CENTER_PKG_V2.g_miss_char);
351: l_location_rec.postal_plus4_code := Nvl(p_address_rec.postal_plus4_code, CSC_RESPONSE_CENTER_PKG_V2.g_miss_char);
352: l_location_rec.delivery_point_code := Nvl(p_address_rec.delivery_point_code, CSC_RESPONSE_CENTER_PKG_V2.g_miss_char);
353: l_location_rec.location_directions := Nvl(p_address_rec.location_directions, CSC_RESPONSE_CENTER_PKG_V2.g_miss_char);
354: l_location_rec.clli_code := Nvl(p_address_rec.clli_code, CSC_RESPONSE_CENTER_PKG_V2.g_miss_char);

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

347: l_location_rec.street_suffix := Nvl(p_address_rec.street_suffix, CSC_RESPONSE_CENTER_PKG_V2.g_miss_char);
348: l_location_rec.street_number := Nvl(p_address_rec.street_number, CSC_RESPONSE_CENTER_PKG_V2.g_miss_char);
349: l_location_rec.floor := Nvl(p_address_rec.floor, CSC_RESPONSE_CENTER_PKG_V2.g_miss_char);
350: l_location_rec.suite := Nvl(p_address_rec.suite, CSC_RESPONSE_CENTER_PKG_V2.g_miss_char);
351: l_location_rec.postal_plus4_code := Nvl(p_address_rec.postal_plus4_code, CSC_RESPONSE_CENTER_PKG_V2.g_miss_char);
352: l_location_rec.delivery_point_code := Nvl(p_address_rec.delivery_point_code, CSC_RESPONSE_CENTER_PKG_V2.g_miss_char);
353: l_location_rec.location_directions := Nvl(p_address_rec.location_directions, CSC_RESPONSE_CENTER_PKG_V2.g_miss_char);
354: l_location_rec.clli_code := Nvl(p_address_rec.clli_code, CSC_RESPONSE_CENTER_PKG_V2.g_miss_char);
355: l_location_rec.short_description := Nvl(p_address_rec.short_description, CSC_RESPONSE_CENTER_PKG_V2.g_miss_char);

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

348: l_location_rec.street_number := Nvl(p_address_rec.street_number, CSC_RESPONSE_CENTER_PKG_V2.g_miss_char);
349: l_location_rec.floor := Nvl(p_address_rec.floor, CSC_RESPONSE_CENTER_PKG_V2.g_miss_char);
350: l_location_rec.suite := Nvl(p_address_rec.suite, CSC_RESPONSE_CENTER_PKG_V2.g_miss_char);
351: l_location_rec.postal_plus4_code := Nvl(p_address_rec.postal_plus4_code, CSC_RESPONSE_CENTER_PKG_V2.g_miss_char);
352: l_location_rec.delivery_point_code := Nvl(p_address_rec.delivery_point_code, CSC_RESPONSE_CENTER_PKG_V2.g_miss_char);
353: l_location_rec.location_directions := Nvl(p_address_rec.location_directions, CSC_RESPONSE_CENTER_PKG_V2.g_miss_char);
354: l_location_rec.clli_code := Nvl(p_address_rec.clli_code, CSC_RESPONSE_CENTER_PKG_V2.g_miss_char);
355: l_location_rec.short_description := Nvl(p_address_rec.short_description, CSC_RESPONSE_CENTER_PKG_V2.g_miss_char);
356: l_location_rec.description := Nvl(p_address_rec.description, CSC_RESPONSE_CENTER_PKG_V2.g_miss_char);

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

349: l_location_rec.floor := Nvl(p_address_rec.floor, CSC_RESPONSE_CENTER_PKG_V2.g_miss_char);
350: l_location_rec.suite := Nvl(p_address_rec.suite, CSC_RESPONSE_CENTER_PKG_V2.g_miss_char);
351: l_location_rec.postal_plus4_code := Nvl(p_address_rec.postal_plus4_code, CSC_RESPONSE_CENTER_PKG_V2.g_miss_char);
352: l_location_rec.delivery_point_code := Nvl(p_address_rec.delivery_point_code, CSC_RESPONSE_CENTER_PKG_V2.g_miss_char);
353: l_location_rec.location_directions := Nvl(p_address_rec.location_directions, CSC_RESPONSE_CENTER_PKG_V2.g_miss_char);
354: l_location_rec.clli_code := Nvl(p_address_rec.clli_code, CSC_RESPONSE_CENTER_PKG_V2.g_miss_char);
355: l_location_rec.short_description := Nvl(p_address_rec.short_description, CSC_RESPONSE_CENTER_PKG_V2.g_miss_char);
356: l_location_rec.description := Nvl(p_address_rec.description, CSC_RESPONSE_CENTER_PKG_V2.g_miss_char);
357: l_location_rec.sales_tax_geocode := Nvl(p_address_rec.sales_tax_geocode, CSC_RESPONSE_CENTER_PKG_V2.g_miss_char);

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

350: l_location_rec.suite := Nvl(p_address_rec.suite, CSC_RESPONSE_CENTER_PKG_V2.g_miss_char);
351: l_location_rec.postal_plus4_code := Nvl(p_address_rec.postal_plus4_code, CSC_RESPONSE_CENTER_PKG_V2.g_miss_char);
352: l_location_rec.delivery_point_code := Nvl(p_address_rec.delivery_point_code, CSC_RESPONSE_CENTER_PKG_V2.g_miss_char);
353: l_location_rec.location_directions := Nvl(p_address_rec.location_directions, CSC_RESPONSE_CENTER_PKG_V2.g_miss_char);
354: l_location_rec.clli_code := Nvl(p_address_rec.clli_code, CSC_RESPONSE_CENTER_PKG_V2.g_miss_char);
355: l_location_rec.short_description := Nvl(p_address_rec.short_description, CSC_RESPONSE_CENTER_PKG_V2.g_miss_char);
356: l_location_rec.description := Nvl(p_address_rec.description, CSC_RESPONSE_CENTER_PKG_V2.g_miss_char);
357: l_location_rec.sales_tax_geocode := Nvl(p_address_rec.sales_tax_geocode, CSC_RESPONSE_CENTER_PKG_V2.g_miss_char);
358: 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 355: l_location_rec.short_description := Nvl(p_address_rec.short_description, CSC_RESPONSE_CENTER_PKG_V2.g_miss_char);

351: l_location_rec.postal_plus4_code := Nvl(p_address_rec.postal_plus4_code, CSC_RESPONSE_CENTER_PKG_V2.g_miss_char);
352: l_location_rec.delivery_point_code := Nvl(p_address_rec.delivery_point_code, CSC_RESPONSE_CENTER_PKG_V2.g_miss_char);
353: l_location_rec.location_directions := Nvl(p_address_rec.location_directions, CSC_RESPONSE_CENTER_PKG_V2.g_miss_char);
354: l_location_rec.clli_code := Nvl(p_address_rec.clli_code, CSC_RESPONSE_CENTER_PKG_V2.g_miss_char);
355: l_location_rec.short_description := Nvl(p_address_rec.short_description, CSC_RESPONSE_CENTER_PKG_V2.g_miss_char);
356: l_location_rec.description := Nvl(p_address_rec.description, CSC_RESPONSE_CENTER_PKG_V2.g_miss_char);
357: l_location_rec.sales_tax_geocode := Nvl(p_address_rec.sales_tax_geocode, CSC_RESPONSE_CENTER_PKG_V2.g_miss_char);
358: 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);
359: --Begin Fix for Bug 7033623 by spamujul

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

352: l_location_rec.delivery_point_code := Nvl(p_address_rec.delivery_point_code, CSC_RESPONSE_CENTER_PKG_V2.g_miss_char);
353: l_location_rec.location_directions := Nvl(p_address_rec.location_directions, CSC_RESPONSE_CENTER_PKG_V2.g_miss_char);
354: l_location_rec.clli_code := Nvl(p_address_rec.clli_code, CSC_RESPONSE_CENTER_PKG_V2.g_miss_char);
355: l_location_rec.short_description := Nvl(p_address_rec.short_description, CSC_RESPONSE_CENTER_PKG_V2.g_miss_char);
356: l_location_rec.description := Nvl(p_address_rec.description, CSC_RESPONSE_CENTER_PKG_V2.g_miss_char);
357: l_location_rec.sales_tax_geocode := Nvl(p_address_rec.sales_tax_geocode, CSC_RESPONSE_CENTER_PKG_V2.g_miss_char);
358: 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);
359: --Begin Fix for Bug 7033623 by spamujul
360: -- l_location_rec.timezone_id := Nvl(p_address_rec.timezone_id, CSC_RESPONSE_CENTER_PKG_V2.g_miss_num);

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

353: l_location_rec.location_directions := Nvl(p_address_rec.location_directions, CSC_RESPONSE_CENTER_PKG_V2.g_miss_char);
354: l_location_rec.clli_code := Nvl(p_address_rec.clli_code, CSC_RESPONSE_CENTER_PKG_V2.g_miss_char);
355: l_location_rec.short_description := Nvl(p_address_rec.short_description, CSC_RESPONSE_CENTER_PKG_V2.g_miss_char);
356: l_location_rec.description := Nvl(p_address_rec.description, CSC_RESPONSE_CENTER_PKG_V2.g_miss_char);
357: l_location_rec.sales_tax_geocode := Nvl(p_address_rec.sales_tax_geocode, CSC_RESPONSE_CENTER_PKG_V2.g_miss_char);
358: 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);
359: --Begin Fix for Bug 7033623 by spamujul
360: -- l_location_rec.timezone_id := Nvl(p_address_rec.timezone_id, CSC_RESPONSE_CENTER_PKG_V2.g_miss_num);
361: -- Added the following condition by spamujul for Bug 10276829

Line 358: 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);

354: l_location_rec.clli_code := Nvl(p_address_rec.clli_code, CSC_RESPONSE_CENTER_PKG_V2.g_miss_char);
355: l_location_rec.short_description := Nvl(p_address_rec.short_description, CSC_RESPONSE_CENTER_PKG_V2.g_miss_char);
356: l_location_rec.description := Nvl(p_address_rec.description, CSC_RESPONSE_CENTER_PKG_V2.g_miss_char);
357: l_location_rec.sales_tax_geocode := Nvl(p_address_rec.sales_tax_geocode, CSC_RESPONSE_CENTER_PKG_V2.g_miss_char);
358: 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);
359: --Begin Fix for Bug 7033623 by spamujul
360: -- l_location_rec.timezone_id := Nvl(p_address_rec.timezone_id, CSC_RESPONSE_CENTER_PKG_V2.g_miss_num);
361: -- Added the following condition by spamujul for Bug 10276829
362: IF NVL(p_address_rec.timezone_id,CSC_RESPONSE_CENTER_PKG_V2.g_miss_num) <> CSC_RESPONSE_CENTER_PKG_V2.g_miss_num THEN

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

356: l_location_rec.description := Nvl(p_address_rec.description, CSC_RESPONSE_CENTER_PKG_V2.g_miss_char);
357: l_location_rec.sales_tax_geocode := Nvl(p_address_rec.sales_tax_geocode, CSC_RESPONSE_CENTER_PKG_V2.g_miss_char);
358: 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);
359: --Begin Fix for Bug 7033623 by spamujul
360: -- l_location_rec.timezone_id := Nvl(p_address_rec.timezone_id, CSC_RESPONSE_CENTER_PKG_V2.g_miss_num);
361: -- Added the following condition by spamujul for Bug 10276829
362: IF NVL(p_address_rec.timezone_id,CSC_RESPONSE_CENTER_PKG_V2.g_miss_num) <> CSC_RESPONSE_CENTER_PKG_V2.g_miss_num THEN
363: -- if l_location_rec.timezone_id <> CSC_RESPONSE_CENTER_PKG_V2.g_miss_num then -- Commented it by spamujul for Bug 9375543
364: l_location_rec.timezone_id := p_address_rec.timezone_id;

Line 362: IF NVL(p_address_rec.timezone_id,CSC_RESPONSE_CENTER_PKG_V2.g_miss_num) <> CSC_RESPONSE_CENTER_PKG_V2.g_miss_num THEN

358: 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);
359: --Begin Fix for Bug 7033623 by spamujul
360: -- l_location_rec.timezone_id := Nvl(p_address_rec.timezone_id, CSC_RESPONSE_CENTER_PKG_V2.g_miss_num);
361: -- Added the following condition by spamujul for Bug 10276829
362: IF NVL(p_address_rec.timezone_id,CSC_RESPONSE_CENTER_PKG_V2.g_miss_num) <> CSC_RESPONSE_CENTER_PKG_V2.g_miss_num THEN
363: -- if l_location_rec.timezone_id <> CSC_RESPONSE_CENTER_PKG_V2.g_miss_num then -- Commented it by spamujul for Bug 9375543
364: l_location_rec.timezone_id := p_address_rec.timezone_id;
365: else
366: l_location_rec.timezone_id := CSC_RESPONSE_CENTER_PKG_V2.g_miss_num;

Line 363: -- if l_location_rec.timezone_id <> CSC_RESPONSE_CENTER_PKG_V2.g_miss_num then -- Commented it by spamujul for Bug 9375543

359: --Begin Fix for Bug 7033623 by spamujul
360: -- l_location_rec.timezone_id := Nvl(p_address_rec.timezone_id, CSC_RESPONSE_CENTER_PKG_V2.g_miss_num);
361: -- Added the following condition by spamujul for Bug 10276829
362: IF NVL(p_address_rec.timezone_id,CSC_RESPONSE_CENTER_PKG_V2.g_miss_num) <> CSC_RESPONSE_CENTER_PKG_V2.g_miss_num THEN
363: -- if l_location_rec.timezone_id <> CSC_RESPONSE_CENTER_PKG_V2.g_miss_num then -- Commented it by spamujul for Bug 9375543
364: l_location_rec.timezone_id := p_address_rec.timezone_id;
365: else
366: l_location_rec.timezone_id := CSC_RESPONSE_CENTER_PKG_V2.g_miss_num;
367: end if;

Line 366: l_location_rec.timezone_id := CSC_RESPONSE_CENTER_PKG_V2.g_miss_num;

362: IF NVL(p_address_rec.timezone_id,CSC_RESPONSE_CENTER_PKG_V2.g_miss_num) <> CSC_RESPONSE_CENTER_PKG_V2.g_miss_num THEN
363: -- if l_location_rec.timezone_id <> CSC_RESPONSE_CENTER_PKG_V2.g_miss_num then -- Commented it by spamujul for Bug 9375543
364: l_location_rec.timezone_id := p_address_rec.timezone_id;
365: else
366: l_location_rec.timezone_id := CSC_RESPONSE_CENTER_PKG_V2.g_miss_num;
367: end if;
368: --End Fix for Bug 7033623 by spamujul
369: l_location_rec.location_id := p_address_rec.location_id;
370:

Line 381: l_location_rec.attribute1 := Nvl(p_address_rec.attribute1, CSC_RESPONSE_CENTER_PKG_V2.g_miss_char);

377: /* End of NCR Jul'09 Bug 8435112 */
378: --End Fix for Bug 7033623 by spamujul
379: l_location_rec.location_id := p_address_rec.location_id;
380: -- Begin fix by spamujul for Bug 12849575
381: l_location_rec.attribute1 := Nvl(p_address_rec.attribute1, CSC_RESPONSE_CENTER_PKG_V2.g_miss_char);
382: l_location_rec.attribute2 := Nvl(p_address_rec.attribute2, CSC_RESPONSE_CENTER_PKG_V2.g_miss_char);
383: l_location_rec.attribute3 := Nvl(p_address_rec.attribute3, CSC_RESPONSE_CENTER_PKG_V2.g_miss_char);
384: l_location_rec.attribute4 := Nvl(p_address_rec.attribute4, CSC_RESPONSE_CENTER_PKG_V2.g_miss_char);
385: l_location_rec.attribute5 := Nvl(p_address_rec.attribute5, CSC_RESPONSE_CENTER_PKG_V2.g_miss_char);

Line 382: l_location_rec.attribute2 := Nvl(p_address_rec.attribute2, CSC_RESPONSE_CENTER_PKG_V2.g_miss_char);

378: --End Fix for Bug 7033623 by spamujul
379: l_location_rec.location_id := p_address_rec.location_id;
380: -- Begin fix by spamujul for Bug 12849575
381: l_location_rec.attribute1 := Nvl(p_address_rec.attribute1, CSC_RESPONSE_CENTER_PKG_V2.g_miss_char);
382: l_location_rec.attribute2 := Nvl(p_address_rec.attribute2, CSC_RESPONSE_CENTER_PKG_V2.g_miss_char);
383: l_location_rec.attribute3 := Nvl(p_address_rec.attribute3, CSC_RESPONSE_CENTER_PKG_V2.g_miss_char);
384: l_location_rec.attribute4 := Nvl(p_address_rec.attribute4, CSC_RESPONSE_CENTER_PKG_V2.g_miss_char);
385: l_location_rec.attribute5 := Nvl(p_address_rec.attribute5, CSC_RESPONSE_CENTER_PKG_V2.g_miss_char);
386: l_location_rec.attribute6 := Nvl(p_address_rec.attribute6, CSC_RESPONSE_CENTER_PKG_V2.g_miss_char);

Line 383: l_location_rec.attribute3 := Nvl(p_address_rec.attribute3, CSC_RESPONSE_CENTER_PKG_V2.g_miss_char);

379: l_location_rec.location_id := p_address_rec.location_id;
380: -- Begin fix by spamujul for Bug 12849575
381: l_location_rec.attribute1 := Nvl(p_address_rec.attribute1, CSC_RESPONSE_CENTER_PKG_V2.g_miss_char);
382: l_location_rec.attribute2 := Nvl(p_address_rec.attribute2, CSC_RESPONSE_CENTER_PKG_V2.g_miss_char);
383: l_location_rec.attribute3 := Nvl(p_address_rec.attribute3, CSC_RESPONSE_CENTER_PKG_V2.g_miss_char);
384: l_location_rec.attribute4 := Nvl(p_address_rec.attribute4, CSC_RESPONSE_CENTER_PKG_V2.g_miss_char);
385: l_location_rec.attribute5 := Nvl(p_address_rec.attribute5, CSC_RESPONSE_CENTER_PKG_V2.g_miss_char);
386: l_location_rec.attribute6 := Nvl(p_address_rec.attribute6, CSC_RESPONSE_CENTER_PKG_V2.g_miss_char);
387: l_location_rec.attribute7 := Nvl(p_address_rec.attribute7, CSC_RESPONSE_CENTER_PKG_V2.g_miss_char);

Line 384: l_location_rec.attribute4 := Nvl(p_address_rec.attribute4, CSC_RESPONSE_CENTER_PKG_V2.g_miss_char);

380: -- Begin fix by spamujul for Bug 12849575
381: l_location_rec.attribute1 := Nvl(p_address_rec.attribute1, CSC_RESPONSE_CENTER_PKG_V2.g_miss_char);
382: l_location_rec.attribute2 := Nvl(p_address_rec.attribute2, CSC_RESPONSE_CENTER_PKG_V2.g_miss_char);
383: l_location_rec.attribute3 := Nvl(p_address_rec.attribute3, CSC_RESPONSE_CENTER_PKG_V2.g_miss_char);
384: l_location_rec.attribute4 := Nvl(p_address_rec.attribute4, CSC_RESPONSE_CENTER_PKG_V2.g_miss_char);
385: l_location_rec.attribute5 := Nvl(p_address_rec.attribute5, CSC_RESPONSE_CENTER_PKG_V2.g_miss_char);
386: l_location_rec.attribute6 := Nvl(p_address_rec.attribute6, CSC_RESPONSE_CENTER_PKG_V2.g_miss_char);
387: l_location_rec.attribute7 := Nvl(p_address_rec.attribute7, CSC_RESPONSE_CENTER_PKG_V2.g_miss_char);
388: l_location_rec.attribute8 := Nvl(p_address_rec.attribute8, CSC_RESPONSE_CENTER_PKG_V2.g_miss_char);

Line 385: l_location_rec.attribute5 := Nvl(p_address_rec.attribute5, CSC_RESPONSE_CENTER_PKG_V2.g_miss_char);

381: l_location_rec.attribute1 := Nvl(p_address_rec.attribute1, CSC_RESPONSE_CENTER_PKG_V2.g_miss_char);
382: l_location_rec.attribute2 := Nvl(p_address_rec.attribute2, CSC_RESPONSE_CENTER_PKG_V2.g_miss_char);
383: l_location_rec.attribute3 := Nvl(p_address_rec.attribute3, CSC_RESPONSE_CENTER_PKG_V2.g_miss_char);
384: l_location_rec.attribute4 := Nvl(p_address_rec.attribute4, CSC_RESPONSE_CENTER_PKG_V2.g_miss_char);
385: l_location_rec.attribute5 := Nvl(p_address_rec.attribute5, CSC_RESPONSE_CENTER_PKG_V2.g_miss_char);
386: l_location_rec.attribute6 := Nvl(p_address_rec.attribute6, CSC_RESPONSE_CENTER_PKG_V2.g_miss_char);
387: l_location_rec.attribute7 := Nvl(p_address_rec.attribute7, CSC_RESPONSE_CENTER_PKG_V2.g_miss_char);
388: l_location_rec.attribute8 := Nvl(p_address_rec.attribute8, CSC_RESPONSE_CENTER_PKG_V2.g_miss_char);
389: l_location_rec.attribute9 := Nvl(p_address_rec.attribute9, CSC_RESPONSE_CENTER_PKG_V2.g_miss_char);

Line 386: l_location_rec.attribute6 := Nvl(p_address_rec.attribute6, CSC_RESPONSE_CENTER_PKG_V2.g_miss_char);

382: l_location_rec.attribute2 := Nvl(p_address_rec.attribute2, CSC_RESPONSE_CENTER_PKG_V2.g_miss_char);
383: l_location_rec.attribute3 := Nvl(p_address_rec.attribute3, CSC_RESPONSE_CENTER_PKG_V2.g_miss_char);
384: l_location_rec.attribute4 := Nvl(p_address_rec.attribute4, CSC_RESPONSE_CENTER_PKG_V2.g_miss_char);
385: l_location_rec.attribute5 := Nvl(p_address_rec.attribute5, CSC_RESPONSE_CENTER_PKG_V2.g_miss_char);
386: l_location_rec.attribute6 := Nvl(p_address_rec.attribute6, CSC_RESPONSE_CENTER_PKG_V2.g_miss_char);
387: l_location_rec.attribute7 := Nvl(p_address_rec.attribute7, CSC_RESPONSE_CENTER_PKG_V2.g_miss_char);
388: l_location_rec.attribute8 := Nvl(p_address_rec.attribute8, CSC_RESPONSE_CENTER_PKG_V2.g_miss_char);
389: l_location_rec.attribute9 := Nvl(p_address_rec.attribute9, CSC_RESPONSE_CENTER_PKG_V2.g_miss_char);
390: l_location_rec.attribute10 := Nvl(p_address_rec.attribute10, CSC_RESPONSE_CENTER_PKG_V2.g_miss_char);

Line 387: l_location_rec.attribute7 := Nvl(p_address_rec.attribute7, CSC_RESPONSE_CENTER_PKG_V2.g_miss_char);

383: l_location_rec.attribute3 := Nvl(p_address_rec.attribute3, CSC_RESPONSE_CENTER_PKG_V2.g_miss_char);
384: l_location_rec.attribute4 := Nvl(p_address_rec.attribute4, CSC_RESPONSE_CENTER_PKG_V2.g_miss_char);
385: l_location_rec.attribute5 := Nvl(p_address_rec.attribute5, CSC_RESPONSE_CENTER_PKG_V2.g_miss_char);
386: l_location_rec.attribute6 := Nvl(p_address_rec.attribute6, CSC_RESPONSE_CENTER_PKG_V2.g_miss_char);
387: l_location_rec.attribute7 := Nvl(p_address_rec.attribute7, CSC_RESPONSE_CENTER_PKG_V2.g_miss_char);
388: l_location_rec.attribute8 := Nvl(p_address_rec.attribute8, CSC_RESPONSE_CENTER_PKG_V2.g_miss_char);
389: l_location_rec.attribute9 := Nvl(p_address_rec.attribute9, CSC_RESPONSE_CENTER_PKG_V2.g_miss_char);
390: l_location_rec.attribute10 := Nvl(p_address_rec.attribute10, CSC_RESPONSE_CENTER_PKG_V2.g_miss_char);
391: l_location_rec.attribute11 := Nvl(p_address_rec.attribute11, CSC_RESPONSE_CENTER_PKG_V2.g_miss_char);

Line 388: l_location_rec.attribute8 := Nvl(p_address_rec.attribute8, CSC_RESPONSE_CENTER_PKG_V2.g_miss_char);

384: l_location_rec.attribute4 := Nvl(p_address_rec.attribute4, CSC_RESPONSE_CENTER_PKG_V2.g_miss_char);
385: l_location_rec.attribute5 := Nvl(p_address_rec.attribute5, CSC_RESPONSE_CENTER_PKG_V2.g_miss_char);
386: l_location_rec.attribute6 := Nvl(p_address_rec.attribute6, CSC_RESPONSE_CENTER_PKG_V2.g_miss_char);
387: l_location_rec.attribute7 := Nvl(p_address_rec.attribute7, CSC_RESPONSE_CENTER_PKG_V2.g_miss_char);
388: l_location_rec.attribute8 := Nvl(p_address_rec.attribute8, CSC_RESPONSE_CENTER_PKG_V2.g_miss_char);
389: l_location_rec.attribute9 := Nvl(p_address_rec.attribute9, CSC_RESPONSE_CENTER_PKG_V2.g_miss_char);
390: l_location_rec.attribute10 := Nvl(p_address_rec.attribute10, CSC_RESPONSE_CENTER_PKG_V2.g_miss_char);
391: l_location_rec.attribute11 := Nvl(p_address_rec.attribute11, CSC_RESPONSE_CENTER_PKG_V2.g_miss_char);
392: l_location_rec.attribute12 := Nvl(p_address_rec.attribute12, CSC_RESPONSE_CENTER_PKG_V2.g_miss_char);

Line 389: l_location_rec.attribute9 := Nvl(p_address_rec.attribute9, CSC_RESPONSE_CENTER_PKG_V2.g_miss_char);

385: l_location_rec.attribute5 := Nvl(p_address_rec.attribute5, CSC_RESPONSE_CENTER_PKG_V2.g_miss_char);
386: l_location_rec.attribute6 := Nvl(p_address_rec.attribute6, CSC_RESPONSE_CENTER_PKG_V2.g_miss_char);
387: l_location_rec.attribute7 := Nvl(p_address_rec.attribute7, CSC_RESPONSE_CENTER_PKG_V2.g_miss_char);
388: l_location_rec.attribute8 := Nvl(p_address_rec.attribute8, CSC_RESPONSE_CENTER_PKG_V2.g_miss_char);
389: l_location_rec.attribute9 := Nvl(p_address_rec.attribute9, CSC_RESPONSE_CENTER_PKG_V2.g_miss_char);
390: l_location_rec.attribute10 := Nvl(p_address_rec.attribute10, CSC_RESPONSE_CENTER_PKG_V2.g_miss_char);
391: l_location_rec.attribute11 := Nvl(p_address_rec.attribute11, CSC_RESPONSE_CENTER_PKG_V2.g_miss_char);
392: l_location_rec.attribute12 := Nvl(p_address_rec.attribute12, CSC_RESPONSE_CENTER_PKG_V2.g_miss_char);
393: l_location_rec.attribute13 := Nvl(p_address_rec.attribute13, CSC_RESPONSE_CENTER_PKG_V2.g_miss_char);

Line 390: l_location_rec.attribute10 := Nvl(p_address_rec.attribute10, CSC_RESPONSE_CENTER_PKG_V2.g_miss_char);

386: l_location_rec.attribute6 := Nvl(p_address_rec.attribute6, CSC_RESPONSE_CENTER_PKG_V2.g_miss_char);
387: l_location_rec.attribute7 := Nvl(p_address_rec.attribute7, CSC_RESPONSE_CENTER_PKG_V2.g_miss_char);
388: l_location_rec.attribute8 := Nvl(p_address_rec.attribute8, CSC_RESPONSE_CENTER_PKG_V2.g_miss_char);
389: l_location_rec.attribute9 := Nvl(p_address_rec.attribute9, CSC_RESPONSE_CENTER_PKG_V2.g_miss_char);
390: l_location_rec.attribute10 := Nvl(p_address_rec.attribute10, CSC_RESPONSE_CENTER_PKG_V2.g_miss_char);
391: l_location_rec.attribute11 := Nvl(p_address_rec.attribute11, CSC_RESPONSE_CENTER_PKG_V2.g_miss_char);
392: l_location_rec.attribute12 := Nvl(p_address_rec.attribute12, CSC_RESPONSE_CENTER_PKG_V2.g_miss_char);
393: l_location_rec.attribute13 := Nvl(p_address_rec.attribute13, CSC_RESPONSE_CENTER_PKG_V2.g_miss_char);
394: l_location_rec.attribute14 := Nvl(p_address_rec.attribute14, CSC_RESPONSE_CENTER_PKG_V2.g_miss_char);

Line 391: l_location_rec.attribute11 := Nvl(p_address_rec.attribute11, CSC_RESPONSE_CENTER_PKG_V2.g_miss_char);

387: l_location_rec.attribute7 := Nvl(p_address_rec.attribute7, CSC_RESPONSE_CENTER_PKG_V2.g_miss_char);
388: l_location_rec.attribute8 := Nvl(p_address_rec.attribute8, CSC_RESPONSE_CENTER_PKG_V2.g_miss_char);
389: l_location_rec.attribute9 := Nvl(p_address_rec.attribute9, CSC_RESPONSE_CENTER_PKG_V2.g_miss_char);
390: l_location_rec.attribute10 := Nvl(p_address_rec.attribute10, CSC_RESPONSE_CENTER_PKG_V2.g_miss_char);
391: l_location_rec.attribute11 := Nvl(p_address_rec.attribute11, CSC_RESPONSE_CENTER_PKG_V2.g_miss_char);
392: l_location_rec.attribute12 := Nvl(p_address_rec.attribute12, CSC_RESPONSE_CENTER_PKG_V2.g_miss_char);
393: l_location_rec.attribute13 := Nvl(p_address_rec.attribute13, CSC_RESPONSE_CENTER_PKG_V2.g_miss_char);
394: l_location_rec.attribute14 := Nvl(p_address_rec.attribute14, CSC_RESPONSE_CENTER_PKG_V2.g_miss_char);
395: l_location_rec.attribute15 := Nvl(p_address_rec.attribute15, CSC_RESPONSE_CENTER_PKG_V2.g_miss_char);

Line 392: l_location_rec.attribute12 := Nvl(p_address_rec.attribute12, CSC_RESPONSE_CENTER_PKG_V2.g_miss_char);

388: l_location_rec.attribute8 := Nvl(p_address_rec.attribute8, CSC_RESPONSE_CENTER_PKG_V2.g_miss_char);
389: l_location_rec.attribute9 := Nvl(p_address_rec.attribute9, CSC_RESPONSE_CENTER_PKG_V2.g_miss_char);
390: l_location_rec.attribute10 := Nvl(p_address_rec.attribute10, CSC_RESPONSE_CENTER_PKG_V2.g_miss_char);
391: l_location_rec.attribute11 := Nvl(p_address_rec.attribute11, CSC_RESPONSE_CENTER_PKG_V2.g_miss_char);
392: l_location_rec.attribute12 := Nvl(p_address_rec.attribute12, CSC_RESPONSE_CENTER_PKG_V2.g_miss_char);
393: l_location_rec.attribute13 := Nvl(p_address_rec.attribute13, CSC_RESPONSE_CENTER_PKG_V2.g_miss_char);
394: l_location_rec.attribute14 := Nvl(p_address_rec.attribute14, CSC_RESPONSE_CENTER_PKG_V2.g_miss_char);
395: l_location_rec.attribute15 := Nvl(p_address_rec.attribute15, CSC_RESPONSE_CENTER_PKG_V2.g_miss_char);
396: l_location_rec.attribute16 := Nvl(p_address_rec.attribute16, CSC_RESPONSE_CENTER_PKG_V2.g_miss_char);

Line 393: l_location_rec.attribute13 := Nvl(p_address_rec.attribute13, CSC_RESPONSE_CENTER_PKG_V2.g_miss_char);

389: l_location_rec.attribute9 := Nvl(p_address_rec.attribute9, CSC_RESPONSE_CENTER_PKG_V2.g_miss_char);
390: l_location_rec.attribute10 := Nvl(p_address_rec.attribute10, CSC_RESPONSE_CENTER_PKG_V2.g_miss_char);
391: l_location_rec.attribute11 := Nvl(p_address_rec.attribute11, CSC_RESPONSE_CENTER_PKG_V2.g_miss_char);
392: l_location_rec.attribute12 := Nvl(p_address_rec.attribute12, CSC_RESPONSE_CENTER_PKG_V2.g_miss_char);
393: l_location_rec.attribute13 := Nvl(p_address_rec.attribute13, CSC_RESPONSE_CENTER_PKG_V2.g_miss_char);
394: l_location_rec.attribute14 := Nvl(p_address_rec.attribute14, CSC_RESPONSE_CENTER_PKG_V2.g_miss_char);
395: l_location_rec.attribute15 := Nvl(p_address_rec.attribute15, CSC_RESPONSE_CENTER_PKG_V2.g_miss_char);
396: l_location_rec.attribute16 := Nvl(p_address_rec.attribute16, CSC_RESPONSE_CENTER_PKG_V2.g_miss_char);
397: l_location_rec.attribute17 := Nvl(p_address_rec.attribute17, CSC_RESPONSE_CENTER_PKG_V2.g_miss_char);

Line 394: l_location_rec.attribute14 := Nvl(p_address_rec.attribute14, CSC_RESPONSE_CENTER_PKG_V2.g_miss_char);

390: l_location_rec.attribute10 := Nvl(p_address_rec.attribute10, CSC_RESPONSE_CENTER_PKG_V2.g_miss_char);
391: l_location_rec.attribute11 := Nvl(p_address_rec.attribute11, CSC_RESPONSE_CENTER_PKG_V2.g_miss_char);
392: l_location_rec.attribute12 := Nvl(p_address_rec.attribute12, CSC_RESPONSE_CENTER_PKG_V2.g_miss_char);
393: l_location_rec.attribute13 := Nvl(p_address_rec.attribute13, CSC_RESPONSE_CENTER_PKG_V2.g_miss_char);
394: l_location_rec.attribute14 := Nvl(p_address_rec.attribute14, CSC_RESPONSE_CENTER_PKG_V2.g_miss_char);
395: l_location_rec.attribute15 := Nvl(p_address_rec.attribute15, CSC_RESPONSE_CENTER_PKG_V2.g_miss_char);
396: l_location_rec.attribute16 := Nvl(p_address_rec.attribute16, CSC_RESPONSE_CENTER_PKG_V2.g_miss_char);
397: l_location_rec.attribute17 := Nvl(p_address_rec.attribute17, CSC_RESPONSE_CENTER_PKG_V2.g_miss_char);
398: l_location_rec.attribute18 := Nvl(p_address_rec.attribute18, CSC_RESPONSE_CENTER_PKG_V2.g_miss_char);

Line 395: l_location_rec.attribute15 := Nvl(p_address_rec.attribute15, CSC_RESPONSE_CENTER_PKG_V2.g_miss_char);

391: l_location_rec.attribute11 := Nvl(p_address_rec.attribute11, CSC_RESPONSE_CENTER_PKG_V2.g_miss_char);
392: l_location_rec.attribute12 := Nvl(p_address_rec.attribute12, CSC_RESPONSE_CENTER_PKG_V2.g_miss_char);
393: l_location_rec.attribute13 := Nvl(p_address_rec.attribute13, CSC_RESPONSE_CENTER_PKG_V2.g_miss_char);
394: l_location_rec.attribute14 := Nvl(p_address_rec.attribute14, CSC_RESPONSE_CENTER_PKG_V2.g_miss_char);
395: l_location_rec.attribute15 := Nvl(p_address_rec.attribute15, CSC_RESPONSE_CENTER_PKG_V2.g_miss_char);
396: l_location_rec.attribute16 := Nvl(p_address_rec.attribute16, CSC_RESPONSE_CENTER_PKG_V2.g_miss_char);
397: l_location_rec.attribute17 := Nvl(p_address_rec.attribute17, CSC_RESPONSE_CENTER_PKG_V2.g_miss_char);
398: l_location_rec.attribute18 := Nvl(p_address_rec.attribute18, CSC_RESPONSE_CENTER_PKG_V2.g_miss_char);
399: l_location_rec.attribute19 := Nvl(p_address_rec.attribute19, CSC_RESPONSE_CENTER_PKG_V2.g_miss_char);

Line 396: l_location_rec.attribute16 := Nvl(p_address_rec.attribute16, CSC_RESPONSE_CENTER_PKG_V2.g_miss_char);

392: l_location_rec.attribute12 := Nvl(p_address_rec.attribute12, CSC_RESPONSE_CENTER_PKG_V2.g_miss_char);
393: l_location_rec.attribute13 := Nvl(p_address_rec.attribute13, CSC_RESPONSE_CENTER_PKG_V2.g_miss_char);
394: l_location_rec.attribute14 := Nvl(p_address_rec.attribute14, CSC_RESPONSE_CENTER_PKG_V2.g_miss_char);
395: l_location_rec.attribute15 := Nvl(p_address_rec.attribute15, CSC_RESPONSE_CENTER_PKG_V2.g_miss_char);
396: l_location_rec.attribute16 := Nvl(p_address_rec.attribute16, CSC_RESPONSE_CENTER_PKG_V2.g_miss_char);
397: l_location_rec.attribute17 := Nvl(p_address_rec.attribute17, CSC_RESPONSE_CENTER_PKG_V2.g_miss_char);
398: l_location_rec.attribute18 := Nvl(p_address_rec.attribute18, CSC_RESPONSE_CENTER_PKG_V2.g_miss_char);
399: l_location_rec.attribute19 := Nvl(p_address_rec.attribute19, CSC_RESPONSE_CENTER_PKG_V2.g_miss_char);
400: l_location_rec.attribute20 := Nvl(p_address_rec.attribute20, CSC_RESPONSE_CENTER_PKG_V2.g_miss_char);

Line 397: l_location_rec.attribute17 := Nvl(p_address_rec.attribute17, CSC_RESPONSE_CENTER_PKG_V2.g_miss_char);

393: l_location_rec.attribute13 := Nvl(p_address_rec.attribute13, CSC_RESPONSE_CENTER_PKG_V2.g_miss_char);
394: l_location_rec.attribute14 := Nvl(p_address_rec.attribute14, CSC_RESPONSE_CENTER_PKG_V2.g_miss_char);
395: l_location_rec.attribute15 := Nvl(p_address_rec.attribute15, CSC_RESPONSE_CENTER_PKG_V2.g_miss_char);
396: l_location_rec.attribute16 := Nvl(p_address_rec.attribute16, CSC_RESPONSE_CENTER_PKG_V2.g_miss_char);
397: l_location_rec.attribute17 := Nvl(p_address_rec.attribute17, CSC_RESPONSE_CENTER_PKG_V2.g_miss_char);
398: l_location_rec.attribute18 := Nvl(p_address_rec.attribute18, CSC_RESPONSE_CENTER_PKG_V2.g_miss_char);
399: l_location_rec.attribute19 := Nvl(p_address_rec.attribute19, CSC_RESPONSE_CENTER_PKG_V2.g_miss_char);
400: l_location_rec.attribute20 := Nvl(p_address_rec.attribute20, CSC_RESPONSE_CENTER_PKG_V2.g_miss_char);
401: -- End fix by spamujul for Bug 12849575

Line 398: l_location_rec.attribute18 := Nvl(p_address_rec.attribute18, CSC_RESPONSE_CENTER_PKG_V2.g_miss_char);

394: l_location_rec.attribute14 := Nvl(p_address_rec.attribute14, CSC_RESPONSE_CENTER_PKG_V2.g_miss_char);
395: l_location_rec.attribute15 := Nvl(p_address_rec.attribute15, CSC_RESPONSE_CENTER_PKG_V2.g_miss_char);
396: l_location_rec.attribute16 := Nvl(p_address_rec.attribute16, CSC_RESPONSE_CENTER_PKG_V2.g_miss_char);
397: l_location_rec.attribute17 := Nvl(p_address_rec.attribute17, CSC_RESPONSE_CENTER_PKG_V2.g_miss_char);
398: l_location_rec.attribute18 := Nvl(p_address_rec.attribute18, CSC_RESPONSE_CENTER_PKG_V2.g_miss_char);
399: l_location_rec.attribute19 := Nvl(p_address_rec.attribute19, CSC_RESPONSE_CENTER_PKG_V2.g_miss_char);
400: l_location_rec.attribute20 := Nvl(p_address_rec.attribute20, CSC_RESPONSE_CENTER_PKG_V2.g_miss_char);
401: -- End fix by spamujul for Bug 12849575
402:

Line 399: l_location_rec.attribute19 := Nvl(p_address_rec.attribute19, CSC_RESPONSE_CENTER_PKG_V2.g_miss_char);

395: l_location_rec.attribute15 := Nvl(p_address_rec.attribute15, CSC_RESPONSE_CENTER_PKG_V2.g_miss_char);
396: l_location_rec.attribute16 := Nvl(p_address_rec.attribute16, CSC_RESPONSE_CENTER_PKG_V2.g_miss_char);
397: l_location_rec.attribute17 := Nvl(p_address_rec.attribute17, CSC_RESPONSE_CENTER_PKG_V2.g_miss_char);
398: l_location_rec.attribute18 := Nvl(p_address_rec.attribute18, CSC_RESPONSE_CENTER_PKG_V2.g_miss_char);
399: l_location_rec.attribute19 := Nvl(p_address_rec.attribute19, CSC_RESPONSE_CENTER_PKG_V2.g_miss_char);
400: l_location_rec.attribute20 := Nvl(p_address_rec.attribute20, CSC_RESPONSE_CENTER_PKG_V2.g_miss_char);
401: -- End fix by spamujul for Bug 12849575
402:
403: --HZ_LOCATION_V2PUB.update_location ( p_init_msg_list => FND_API.G_FALSE, -- commented to fix bug# 9570086 by mpathani

Line 400: l_location_rec.attribute20 := Nvl(p_address_rec.attribute20, CSC_RESPONSE_CENTER_PKG_V2.g_miss_char);

396: l_location_rec.attribute16 := Nvl(p_address_rec.attribute16, CSC_RESPONSE_CENTER_PKG_V2.g_miss_char);
397: l_location_rec.attribute17 := Nvl(p_address_rec.attribute17, CSC_RESPONSE_CENTER_PKG_V2.g_miss_char);
398: l_location_rec.attribute18 := Nvl(p_address_rec.attribute18, CSC_RESPONSE_CENTER_PKG_V2.g_miss_char);
399: l_location_rec.attribute19 := Nvl(p_address_rec.attribute19, CSC_RESPONSE_CENTER_PKG_V2.g_miss_char);
400: l_location_rec.attribute20 := Nvl(p_address_rec.attribute20, CSC_RESPONSE_CENTER_PKG_V2.g_miss_char);
401: -- End fix by spamujul for Bug 12849575
402:
403: --HZ_LOCATION_V2PUB.update_location ( p_init_msg_list => FND_API.G_FALSE, -- commented to fix bug# 9570086 by mpathani
404: HZ_LOCATION_V2PUB.update_location ( p_init_msg_list => FND_API.G_TRUE, -- To initialize the Message List on each call

Line 425: END CSC_RESPONSE_CENTER_PKG_V2;

421: /* End of NCR Jul'09 Bug 8435112 */
422:
423: End Update_Address;
424:
425: END CSC_RESPONSE_CENTER_PKG_V2;
426: