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.HZ_IMP_LOAD_ADDRESSES_PKG dependencies on STANDARD

Line 145: l_accept_std_flag ACCEPT_STANDARDIZED_FLAG;

141: l_created_by_module CREATED_BY_MODULE;
142: --l_location_profile_id LOCATION_PROFILE_ID;
143: l_location_id LOCATION_ID;
144: l_new_loc_id LOCATION_ID;
145: l_accept_std_flag ACCEPT_STANDARDIZED_FLAG;
146: l_adptr_content_src ADAPTER_CONTENT_SRC;
147: l_corr_mv_ind CORRECT_MOVE_INDICATOR;
148: l_ident_addr_flag IDENT_ADDR_FLAG;
149:

Line 904: site_int.accept_standardized_flag accept_std_flag,

900: site_int.sales_tax_geocode,
901: site_int.sales_tax_inside_city_limits,
902: nvl(nullif(site_int.created_by_module, :2), ''HZ_IMPORT'') created_by_module,
903: site_int.last_updated_by,
904: site_int.accept_standardized_flag accept_std_flag,
905: site_int.adapter_content_source adapter_content_source,
906: site_int.attribute_category attr_category,
907: site_int.attribute1 attr1,
908: site_int.attribute2 attr2,

Line 928: nvl2(site_int.accept_standardized_flag, nvl2(nullif(site_int.address1_std, :2), ''Y'' ,null), ''Y'')

924: site_int.attribute18 attr18,
925: site_int.attribute19 attr19,
926: site_int.attribute20 attr20,
927: nvl2(nullif(site_int.address1, :2),
928: nvl2(site_int.accept_standardized_flag, nvl2(nullif(site_int.address1_std, :2), ''Y'' ,null), ''Y'')
929: , null) address_error,
930: nvl2(nullif(site_int.country, :2),
931: nvl2(fnd_terr.territory_code,
932: nvl2(site_int.accept_standardized_flag,

Line 932: nvl2(site_int.accept_standardized_flag,

928: nvl2(site_int.accept_standardized_flag, nvl2(nullif(site_int.address1_std, :2), ''Y'' ,null), ''Y'')
929: , null) address_error,
930: nvl2(nullif(site_int.country, :2),
931: nvl2(fnd_terr.territory_code,
932: nvl2(site_int.accept_standardized_flag,
933: nvl2(nullif(site_int.country_std, :2),
934: nvl2(fnd_terr2.territory_code, ''Y'', null),
935: null), ''Y''),
936: null), null) country_error,

Line 1364: site_int.ACCEPT_STANDARDIZED_FLAG,

1360: site_int.SALES_TAX_GEOCODE,
1361: site_int.SALES_TAX_INSIDE_CITY_LIMITS,
1362: site_int.CREATED_BY_MODULE,
1363: site_int.LAST_UPDATED_BY,
1364: site_int.ACCEPT_STANDARDIZED_FLAG,
1365: site_int.ADAPTER_CONTENT_SOURCE,
1366: site_int.attribute_category, site_int.attribute1, site_int.attribute2,
1367: site_int.attribute3, site_int.attribute4, site_int.attribute5,
1368: site_int.attribute6, site_int.attribute7, site_int.attribute8,

Line 1388: nvl2(site_int.accept_standardized_flag, nvl2(nullif(site_int.address1_std, :GMISS_CHAR), ''Y'' ,null), ''Y'')

1384: :GMISS_CHAR, decode(site_int.province, null, hz_loc.province, :GMISS_CHAR, null, site_int.province),
1385: site_int.state) ps_admin_code,
1386:
1387: nvl2(nullif(site_int.address1, :GMISS_CHAR),
1388: nvl2(site_int.accept_standardized_flag, nvl2(nullif(site_int.address1_std, :GMISS_CHAR), ''Y'' ,null), ''Y'')
1389: , null) address_error,
1390:
1391: nvl2(nullif(site_int.country, :GMISS_CHAR),
1392: nvl2(fnd_terr.territory_code,

Line 1393: nvl2(site_int.accept_standardized_flag,

1389: , null) address_error,
1390:
1391: nvl2(nullif(site_int.country, :GMISS_CHAR),
1392: nvl2(fnd_terr.territory_code,
1393: nvl2(site_int.accept_standardized_flag,
1394: nvl2(nullif(site_int.country_std, :GMISS_CHAR),
1395: nvl2(fnd_terr2.territory_code, ''Y'', null),
1396: null), ''Y''),
1397: null), null) country_error,

Line 1403: decode(site_int.ACCEPT_STANDARDIZED_FLAG, ''Y'',

1399: decode(site_int.language, null, ''Y'', :GMISS_CHAR, ''Y'', fnd_lang.language_code) lang_error,
1400: decode(site_int.timezone_code, null, ''Y'', :GMISS_CHAR, ''Y'', timezone.timezone_code) timezone_error,
1401: decode(nvl(site_int.insert_update_flag, site_sg.action_flag), site_sg.action_flag, ''Y'', null) action_mismatch_error,
1402: site_sg.error_flag,
1403: decode(site_int.ACCEPT_STANDARDIZED_FLAG, ''Y'',
1404: decode(hz_loc.country, site_int.country_std,
1405: decode(nvl(hz_loc.state,hz_loc.province), site_int.prov_state_admin_code_std,
1406: decode(hz_loc.county, site_int.county_std,
1407: decode(hz_loc.city, site_int.city_std,

Line 1435: decode(site_int.ACCEPT_STANDARDIZED_FLAG, ''Y'',

1431: decode(site_int.address3, :GMISS_CHAR, null, null, hz_loc.address3, site_int.address3),
1432: decode(hz_loc.address4,
1433: decode(site_int.address4, :GMISS_CHAR, null, null, hz_loc.address4, site_int.address4),
1434: null, ''Y''), ''Y''), ''Y''), ''Y''), ''Y''), ''Y''), ''Y''), ''Y''), ''Y''), ''Y'')) addr_ch_flag,
1435: decode(site_int.ACCEPT_STANDARDIZED_FLAG, ''Y'',
1436: decode(hz_loc.country, site_int.country_std,
1437: decode(nvl(hz_loc.state,hz_loc.province), site_int.prov_state_admin_code_std,
1438: decode(hz_loc.county, site_int.county_std,
1439: decode(hz_loc.city, site_int.city_std,

Line 1595: site_int.ACCEPT_STANDARDIZED_FLAG,

1591: site_int.SALES_TAX_GEOCODE,
1592: site_int.SALES_TAX_INSIDE_CITY_LIMITS,
1593: site_int.CREATED_BY_MODULE,
1594: site_int.LAST_UPDATED_BY,
1595: site_int.ACCEPT_STANDARDIZED_FLAG,
1596: site_int.ADAPTER_CONTENT_SOURCE,
1597: site_int.attribute_category, site_int.attribute1, site_int.attribute2,
1598: site_int.attribute3, site_int.attribute4, site_int.attribute5,
1599: site_int.attribute6, site_int.attribute7, site_int.attribute8,

Line 1619: nvl2(site_int.accept_standardized_flag, nvl2(nullif(site_int.address1_std, :GMISS_CHAR), ''Y'' ,null), ''Y'')

1615: :GMISS_CHAR, decode(site_int.province, null, hz_loc.province, :GMISS_CHAR, null, site_int.province),
1616: site_int.state) ps_admin_code,
1617:
1618: nvl2(nullif(site_int.address1, :GMISS_CHAR),
1619: nvl2(site_int.accept_standardized_flag, nvl2(nullif(site_int.address1_std, :GMISS_CHAR), ''Y'' ,null), ''Y'')
1620: , null) address_error,
1621:
1622: nvl2(nullif(site_int.country, :GMISS_CHAR),
1623: nvl2(fnd_terr.territory_code,

Line 1624: nvl2(site_int.accept_standardized_flag,

1620: , null) address_error,
1621:
1622: nvl2(nullif(site_int.country, :GMISS_CHAR),
1623: nvl2(fnd_terr.territory_code,
1624: nvl2(site_int.accept_standardized_flag,
1625: nvl2(nullif(site_int.country_std, :GMISS_CHAR),
1626: nvl2(fnd_terr2.territory_code, ''Y'', null),
1627: null), ''Y''),
1628: null), null) country_error,

Line 1634: decode(site_int.ACCEPT_STANDARDIZED_FLAG, ''Y'',

1630: decode(site_int.language, null, ''Y'', :GMISS_CHAR, ''Y'', fnd_lang.language_code) lang_error,
1631: decode(site_int.timezone_code, null, ''Y'', :GMISS_CHAR, ''Y'', timezone.timezone_code) timezone_error,
1632: decode(nvl(site_int.insert_update_flag, site_sg.action_flag), site_sg.action_flag, ''Y'', null) action_mismatch_error,
1633: site_sg.error_flag,
1634: decode(site_int.ACCEPT_STANDARDIZED_FLAG, ''Y'',
1635: decode(hz_loc.country, site_int.country_std,
1636: decode(nvl(hz_loc.state,hz_loc.province), site_int.prov_state_admin_code_std,
1637: decode(hz_loc.county, site_int.county_std,
1638: decode(hz_loc.city, site_int.city_std,

Line 1666: decode(site_int.ACCEPT_STANDARDIZED_FLAG, ''Y'',

1662: decode(site_int.address3, :GMISS_CHAR, null, null, hz_loc.address3, site_int.address3),
1663: decode(hz_loc.address4,
1664: decode(site_int.address4, :GMISS_CHAR, null, null, hz_loc.address4, site_int.address4),
1665: null, ''Y''), ''Y''), ''Y''), ''Y''), ''Y''), ''Y''), ''Y''), ''Y''), ''Y''), ''Y'')) addr_ch_flag,
1666: decode(site_int.ACCEPT_STANDARDIZED_FLAG, ''Y'',
1667: decode(hz_loc.country, site_int.country_std,
1668: decode(nvl(hz_loc.state,hz_loc.province), site_int.prov_state_admin_code_std,
1669: decode(hz_loc.county, site_int.county_std,
1670: decode(hz_loc.city, site_int.city_std,

Line 2340: /* for addr cols, update only if not standardized address or */

2336:
2337: /* update hz_locations if */
2338: /* a) address corrected, or */
2339: /* b) address updated directly */
2340: /* for addr cols, update only if not standardized address or */
2341: /* profile option allows update */
2342: forall j in 1..l_site_id.count
2343: update hz_locations
2344: set LAST_UPDATE_DATE = P_DML_RECORD.SYSDATE,

Line 2351: COUNTRY = decode(VALIDATION_STATUS_CODE, null, -- not standardized, alway ok to update

2347: REQUEST_ID = P_DML_RECORD.REQUEST_ID,
2348: PROGRAM_APPLICATION_ID = P_DML_RECORD.PROGRAM_APPLICATION_ID,
2349: PROGRAM_ID = P_DML_RECORD.PROGRAM_ID,
2350: PROGRAM_UPDATE_DATE = P_DML_RECORD.SYSDATE,
2351: COUNTRY = decode(VALIDATION_STATUS_CODE, null, -- not standardized, alway ok to update
2352: decode(l_accept_std_flag(j), 'Y', l_country_std(j),
2353: decode(l_country(j), null, COUNTRY, l_country(j))),
2354: decode(l_allow_std_update, 'N', COUNTRY,
2355: decode(l_accept_std_flag(j), 'Y', l_country_std(j),

Line 2357: ADDRESS1 = decode(VALIDATION_STATUS_CODE, null, -- not standardized, alway ok to update

2353: decode(l_country(j), null, COUNTRY, l_country(j))),
2354: decode(l_allow_std_update, 'N', COUNTRY,
2355: decode(l_accept_std_flag(j), 'Y', l_country_std(j),
2356: decode(l_country(j), null, COUNTRY, l_country(j))))),
2357: ADDRESS1 = decode(VALIDATION_STATUS_CODE, null, -- not standardized, alway ok to update
2358: decode(l_accept_std_flag(j), 'Y', l_addr1_std(j),
2359: decode(l_addr1(j), null, ADDRESS1, l_addr1(j))),
2360: decode(l_allow_std_update, 'N', ADDRESS1,
2361: decode(l_accept_std_flag(j), 'Y', l_addr1_std(j),

Line 2363: ADDRESS2 = decode(VALIDATION_STATUS_CODE, null, -- not standardized, alway ok to update

2359: decode(l_addr1(j), null, ADDRESS1, l_addr1(j))),
2360: decode(l_allow_std_update, 'N', ADDRESS1,
2361: decode(l_accept_std_flag(j), 'Y', l_addr1_std(j),
2362: decode(l_addr1(j), null, ADDRESS1, l_addr1(j))))),
2363: ADDRESS2 = decode(VALIDATION_STATUS_CODE, null, -- not standardized, alway ok to update
2364: decode(l_accept_std_flag(j), 'Y', l_addr2_std(j),
2365: decode(l_addr2(j), null, ADDRESS2, P_DML_RECORD.GMISS_CHAR, null, l_addr2(j))),
2366: decode(l_allow_std_update, 'N', ADDRESS2,
2367: decode(l_accept_std_flag(j), 'Y', l_addr2_std(j),

Line 2369: ADDRESS3 = decode(VALIDATION_STATUS_CODE, null, -- not standardized, alway ok to update

2365: decode(l_addr2(j), null, ADDRESS2, P_DML_RECORD.GMISS_CHAR, null, l_addr2(j))),
2366: decode(l_allow_std_update, 'N', ADDRESS2,
2367: decode(l_accept_std_flag(j), 'Y', l_addr2_std(j),
2368: decode(l_addr2(j), null, ADDRESS2, P_DML_RECORD.GMISS_CHAR, null, l_addr2(j))))),
2369: ADDRESS3 = decode(VALIDATION_STATUS_CODE, null, -- not standardized, alway ok to update
2370: decode(l_accept_std_flag(j), 'Y', l_addr3_std(j),
2371: decode(l_addr3(j), null, ADDRESS3, P_DML_RECORD.GMISS_CHAR, null, l_addr3(j))),
2372: decode(l_allow_std_update, 'N', ADDRESS3,
2373: decode(l_accept_std_flag(j), 'Y', l_addr3_std(j),

Line 2375: ADDRESS4 = decode(VALIDATION_STATUS_CODE, null, -- not standardized, alway ok to update

2371: decode(l_addr3(j), null, ADDRESS3, P_DML_RECORD.GMISS_CHAR, null, l_addr3(j))),
2372: decode(l_allow_std_update, 'N', ADDRESS3,
2373: decode(l_accept_std_flag(j), 'Y', l_addr3_std(j),
2374: decode(l_addr3(j), null, ADDRESS3, P_DML_RECORD.GMISS_CHAR, null, l_addr3(j))))),
2375: ADDRESS4 = decode(VALIDATION_STATUS_CODE, null, -- not standardized, alway ok to update
2376: decode(l_accept_std_flag(j), 'Y', l_addr4_std(j),
2377: decode(l_addr4(j), null, ADDRESS4, P_DML_RECORD.GMISS_CHAR, null, l_addr4(j))),
2378: decode(l_allow_std_update, 'N', ADDRESS4,
2379: decode(l_accept_std_flag(j), 'Y', l_addr4_std(j),

Line 2381: CITY = decode(VALIDATION_STATUS_CODE, null, -- not standardized, alway ok to update

2377: decode(l_addr4(j), null, ADDRESS4, P_DML_RECORD.GMISS_CHAR, null, l_addr4(j))),
2378: decode(l_allow_std_update, 'N', ADDRESS4,
2379: decode(l_accept_std_flag(j), 'Y', l_addr4_std(j),
2380: decode(l_addr4(j), null, ADDRESS4, P_DML_RECORD.GMISS_CHAR, null, l_addr4(j))))),
2381: CITY = decode(VALIDATION_STATUS_CODE, null, -- not standardized, alway ok to update
2382: decode(l_accept_std_flag(j), 'Y', l_city_std(j),
2383: decode(l_city(j), null, CITY, P_DML_RECORD.GMISS_CHAR, null, l_city(j))),
2384: decode(l_allow_std_update, 'N', CITY,
2385: decode(l_accept_std_flag(j), 'Y', l_city_std(j),

Line 2387: POSTAL_CODE = decode(VALIDATION_STATUS_CODE, null, -- not standardized, alway ok to update

2383: decode(l_city(j), null, CITY, P_DML_RECORD.GMISS_CHAR, null, l_city(j))),
2384: decode(l_allow_std_update, 'N', CITY,
2385: decode(l_accept_std_flag(j), 'Y', l_city_std(j),
2386: decode(l_city(j), null, CITY, P_DML_RECORD.GMISS_CHAR, null, l_city(j))))),
2387: POSTAL_CODE = decode(VALIDATION_STATUS_CODE, null, -- not standardized, alway ok to update
2388: decode(l_accept_std_flag(j), 'Y', l_postal_code_std(j),
2389: decode(l_postal_code(j), null, POSTAL_CODE, P_DML_RECORD.GMISS_CHAR, null, l_postal_code(j))),
2390: decode(l_allow_std_update, 'N', POSTAL_CODE,
2391: decode(l_accept_std_flag(j), 'Y', l_postal_code_std(j),

Line 2393: STATE = decode(VALIDATION_STATUS_CODE, null, -- not standardized, alway ok to update

2389: decode(l_postal_code(j), null, POSTAL_CODE, P_DML_RECORD.GMISS_CHAR, null, l_postal_code(j))),
2390: decode(l_allow_std_update, 'N', POSTAL_CODE,
2391: decode(l_accept_std_flag(j), 'Y', l_postal_code_std(j),
2392: decode(l_postal_code(j), null, POSTAL_CODE, P_DML_RECORD.GMISS_CHAR, null, l_postal_code(j))))),
2393: STATE = decode(VALIDATION_STATUS_CODE, null, -- not standardized, alway ok to update
2394: decode(l_accept_std_flag(j), 'Y', decode(l_province(j), null, l_ps_admin_std(j), null),
2395: decode(l_state(j), null, STATE, P_DML_RECORD.GMISS_CHAR, null, l_state(j))),
2396: decode(l_allow_std_update, 'N', STATE,
2397: decode(l_accept_std_flag(j), 'Y', decode(l_province(j), null, l_ps_admin_std(j), null),

Line 2399: PROVINCE = decode(VALIDATION_STATUS_CODE, null, -- not standardized, alway ok to update

2395: decode(l_state(j), null, STATE, P_DML_RECORD.GMISS_CHAR, null, l_state(j))),
2396: decode(l_allow_std_update, 'N', STATE,
2397: decode(l_accept_std_flag(j), 'Y', decode(l_province(j), null, l_ps_admin_std(j), null),
2398: decode(l_state(j), null, STATE, P_DML_RECORD.GMISS_CHAR, null, l_state(j))))),
2399: PROVINCE = decode(VALIDATION_STATUS_CODE, null, -- not standardized, alway ok to update
2400: decode(l_accept_std_flag(j), 'Y', decode(l_province(j), null, null, l_ps_admin_std(j)),
2401: decode(l_province(j), null, PROVINCE, P_DML_RECORD.GMISS_CHAR, null, l_province(j))),
2402: decode(l_allow_std_update, 'N', PROVINCE,
2403: decode(l_accept_std_flag(j), 'Y', decode(l_province(j), null, null, l_ps_admin_std(j)),

Line 2405: COUNTY = decode(VALIDATION_STATUS_CODE, null, -- not standardized, alway ok to update

2401: decode(l_province(j), null, PROVINCE, P_DML_RECORD.GMISS_CHAR, null, l_province(j))),
2402: decode(l_allow_std_update, 'N', PROVINCE,
2403: decode(l_accept_std_flag(j), 'Y', decode(l_province(j), null, null, l_ps_admin_std(j)),
2404: decode(l_province(j), null, PROVINCE, P_DML_RECORD.GMISS_CHAR, null, l_province(j))))),
2405: COUNTY = decode(VALIDATION_STATUS_CODE, null, -- not standardized, alway ok to update
2406: decode(l_accept_std_flag(j), 'Y', l_county_std(j),
2407: decode(l_county(j), null, COUNTY, P_DML_RECORD.GMISS_CHAR, null, l_county(j))),
2408: decode(l_allow_std_update, 'N', COUNTY,
2409: decode(l_accept_std_flag(j), 'Y', l_county_std(j),

Line 2426: /* if validation_status_code was null, the location was not standardized.

2422: --CREATED_BY_MODULE = nvl(CREATED_BY_MODULE, decode(l_created_by_module(j), P_DML_RECORD.GMISS_CHAR, CREATED_BY_MODULE, NULL, CREATED_BY_MODULE, l_created_by_module(j))),
2423: APPLICATION_ID = nvl(APPLICATION_ID, P_DML_RECORD.APPLICATION_ID),
2424: TIMEZONE_ID = DECODE(l_timezone_code(j), NULL, TIMEZONE_ID, P_DML_RECORD.GMISS_CHAR, NULL, l_timezone(j)),
2425: ACTUAL_CONTENT_SOURCE = P_DML_RECORD.ACTUAL_CONTENT_SRC,
2426: /* if validation_status_code was null, the location was not standardized.
2427: For standardized address, status would not change if not allowed to update
2428: standardized address.
2429: Otherwise, just set value according to accept standardized flag
2430: */

Line 2427: For standardized address, status would not change if not allowed to update

2423: APPLICATION_ID = nvl(APPLICATION_ID, P_DML_RECORD.APPLICATION_ID),
2424: TIMEZONE_ID = DECODE(l_timezone_code(j), NULL, TIMEZONE_ID, P_DML_RECORD.GMISS_CHAR, NULL, l_timezone(j)),
2425: ACTUAL_CONTENT_SOURCE = P_DML_RECORD.ACTUAL_CONTENT_SRC,
2426: /* if validation_status_code was null, the location was not standardized.
2427: For standardized address, status would not change if not allowed to update
2428: standardized address.
2429: Otherwise, just set value according to accept standardized flag
2430: */
2431: VALIDATION_STATUS_CODE = decode(VALIDATION_STATUS_CODE, null,

Line 2428: standardized address.

2424: TIMEZONE_ID = DECODE(l_timezone_code(j), NULL, TIMEZONE_ID, P_DML_RECORD.GMISS_CHAR, NULL, l_timezone(j)),
2425: ACTUAL_CONTENT_SOURCE = P_DML_RECORD.ACTUAL_CONTENT_SRC,
2426: /* if validation_status_code was null, the location was not standardized.
2427: For standardized address, status would not change if not allowed to update
2428: standardized address.
2429: Otherwise, just set value according to accept standardized flag
2430: */
2431: VALIDATION_STATUS_CODE = decode(VALIDATION_STATUS_CODE, null,
2432: decode(l_accept_std_flag(j), 'Y', l_valid_status_code(j), null),

Line 2429: Otherwise, just set value according to accept standardized flag

2425: ACTUAL_CONTENT_SOURCE = P_DML_RECORD.ACTUAL_CONTENT_SRC,
2426: /* if validation_status_code was null, the location was not standardized.
2427: For standardized address, status would not change if not allowed to update
2428: standardized address.
2429: Otherwise, just set value according to accept standardized flag
2430: */
2431: VALIDATION_STATUS_CODE = decode(VALIDATION_STATUS_CODE, null,
2432: decode(l_accept_std_flag(j), 'Y', l_valid_status_code(j), null),
2433: decode(l_allow_std_update, 'N', VALIDATION_STATUS_CODE,

Line 2536: --correct standardized address

2532: forall j in 1..l_site_id.count
2533: update hz_location_profiles
2534: set EFFECTIVE_END_DATE = decode(l_maintain_loc_hist, 'Y',
2535: --do not end-date if sst and not allowed to
2536: --correct standardized address
2537: decode(validation_sst_flag, 'Y',
2538: decode(l_allow_std_update, 'N', null, P_DML_RECORD.SYSDATE),
2539: P_DML_RECORD.SYSDATE),
2540: null),

Line 2543: --correct standardized address

2539: P_DML_RECORD.SYSDATE),
2540: null),
2541: address1 = decode(l_maintain_loc_hist, 'Y', address1,
2542: --do not update if sst and not allowed to
2543: --correct standardized address
2544: decode(validation_sst_flag, 'Y',
2545: decode(l_allow_std_update, 'N', address1, l_addr1_std(j)),
2546: l_addr1_std(j))),
2547: address2 = decode(l_maintain_loc_hist, 'Y', address2,

Line 2581: -- if not allowed to update standardized

2577: decode(l_allow_std_update, 'N', postal_code, l_postal_code_std(j)),
2578: l_postal_code_std(j))),
2579: validation_sst_flag = decode(l_maintain_loc_hist, 'Y', validation_sst_flag,
2580: decode(l_allow_std_update, 'Y', decode(l_accept_std_flag(j), 'Y', 'Y', 'N'),
2581: -- if not allowed to update standardized
2582: decode(l_val_status_code(j), null,
2583: -- not a standarized address
2584: decode(l_accept_std_flag(j), 'Y', 'Y', 'N'),
2585: validation_sst_flag))),

Line 2727: -- not a standardized address, don't end-date new profile

2723: nvl(l_old_profile_sst_flag(j), 'N'))),
2724: decode(l_move_count(j), 1,null,
2725: -- record corrected/moved
2726: decode(l_val_status_code(j), null,
2727: -- not a standardized address, don't end-date new profile
2728: null,
2729: -- a standardized address,
2730: -- if l_old_profile_sst_flag(j) is null, no old profile exists,
2731: -- don't end-date this one

Line 2729: -- a standardized address,

2725: -- record corrected/moved
2726: decode(l_val_status_code(j), null,
2727: -- not a standardized address, don't end-date new profile
2728: null,
2729: -- a standardized address,
2730: -- if l_old_profile_sst_flag(j) is null, no old profile exists,
2731: -- don't end-date this one
2732: -- of l_old_profile_sst_flag(j) = 'Y', old profile exists and is SST,
2733: -- end-date it

Line 2949: /* 2) it is not standarzed or allowed update to standardized address */

2945:
2946: /* DE-NORM */
2947: /* For corrected address, de-norm the value to hz_parties if */
2948: /* 1) it is primary address, and */
2949: /* 2) it is not standarzed or allowed update to standardized address */
2950:
2951: /* bug fix 3851810 */
2952: /* If DNB is not selected as a visible data soruce, we should not */
2953: /* denormalize it even it is the first active address created for the */