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 HZ_LOCATION_PROFILES

Line 692: into hz_location_profiles (

688: decode(accept_std_flag, ''Y'', addr_valid_status_code, null),
689: decode(accept_std_flag, ''Y'', date_validated, null),
690: created_by_module)
691: -- insert ino location profile with user data
692: into hz_location_profiles (
693: actual_content_source,
694: created_by,
695: creation_date,
696: last_updated_by,

Line 725: hz_location_profiles_s.nextval,

721: :4,
722: :5,
723: :6,
724: hr_locations_s.NextVal,
725: hz_location_profiles_s.nextval,
726: address1,
727: address2,
728: address3,
729: address4,

Line 752: into hz_location_profiles (

748: and owner_table_id is not null
749: and accept_std_flag is not null -- if validated data present
750: and flex_val_error is not null
751: ) then
752: into hz_location_profiles (
753: actual_content_source,
754: created_by,
755: creation_date,
756: last_updated_by,

Line 787: hz_location_profiles_s.nextval+1,

783: :4,
784: :5,
785: :6,
786: hr_locations_s.NextVal,
787: hz_location_profiles_s.nextval+1,
788: address1_std,
789: address2_std,
790: address3_std,
791: address4_std,

Line 1530: from hz_location_profiles hz_loc_prf

1526:
1527: l_sql_query_w_prf VARCHAR2(20000) :=
1528: 'SELECT --hz_loc_prf.validation_status_code,
1529: ( select validation_sst_flag
1530: from hz_location_profiles hz_loc_prf
1531: where hz_loc_prf.actual_content_source = site_int.ADAPTER_CONTENT_SOURCE
1532: and hz_loc_prf.location_id = hz_loc.location_id
1533: and nullif(EFFECTIVE_END_DATE, :CP_END_DATE) is null
1534: ) old_prf_sst,

Line 2163: update hz_location_profiles

2159: /* update location profile for user data */
2160: /* if profile Maintain Location History = 'Y', end-date old one */
2161: /* otherwise, update the entry directly */
2162: forall j in 1..l_site_id.count save exceptions
2163: update hz_location_profiles
2164: set effective_end_date = decode(l_maintain_loc_hist, 'Y', P_DML_RECORD.SYSDATE, null),
2165: address1 = decode(l_maintain_loc_hist, 'Y', address1, decode(l_addr1(j), P_DML_RECORD.GMISS_CHAR, null, null, address1, l_addr1(j))),
2166: address2 = decode(l_maintain_loc_hist, 'Y', address2, decode(l_addr2(j), P_DML_RECORD.GMISS_CHAR, null, null, address2, l_addr2(j))),
2167: address3 = decode(l_maintain_loc_hist, 'Y', address3, decode(l_addr3(j), P_DML_RECORD.GMISS_CHAR, null, null, address3, l_addr3(j))),

Line 2469: /* insert into hz_location_profiles with user data if maintaining old record */

2465: where hz_party_sites.party_site_id = l_site_id(j)
2466: and l_corr_upd_count(j) = 1;
2467:
2468:
2469: /* insert into hz_location_profiles with user data if maintaining old record */
2470: /* insert if */
2471: /* 1) record moved, or */
2472: /* 2) record corrected, and maintaining history and old record exist,or */
2473: /* 3) record update, and maintaining historyand old record exist, */

Line 2475: insert into HZ_LOCATION_PROFILES

2471: /* 1) record moved, or */
2472: /* 2) record corrected, and maintaining history and old record exist,or */
2473: /* 3) record update, and maintaining historyand old record exist, */
2474: ForAll j in 1..l_site_id.count
2475: insert into HZ_LOCATION_PROFILES
2476: ( LOCATION_ID, LOCATION_PROFILE_ID,
2477: ADDRESS1, ADDRESS2, ADDRESS3, ADDRESS4,
2478: CITY, PROV_STATE_ADMIN_CODE,
2479: COUNTY, COUNTRY, POSTAL_CODE,

Line 2496: hz_location_profiles_s.NextVal,

2492: PROGRAM_UPDATE_DATE
2493: )
2494: ( select
2495: decode(l_move_count(j), 1, l_new_loc_id(j), l_location_id(j)),
2496: hz_location_profiles_s.NextVal,
2497: nvl(l_addr1(j), l_old_addr1(j)),
2498: nullif(nvl(l_addr2(j), l_old_addr2(j)), P_DML_RECORD.GMISS_CHAR),
2499: nullif(nvl(l_addr3(j), l_old_addr3(j)), P_DML_RECORD.GMISS_CHAR),
2500: nullif(nvl(l_addr4(j), l_old_addr4(j)), P_DML_RECORD.GMISS_CHAR),

Line 2533: update hz_location_profiles

2529: /* 1) record corrected, or */
2530: /* 2) record update */
2531: /* If maitaining history, end-date eixisting one. Otherwise update it. */
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',

Line 2603: /* insert into hz_location_profiles with std data */

2599: FOR k IN 1..l_site_id.count LOOP
2600: l_temp_upd_count(k) := SQL%BULK_ROWCOUNT(k);
2601: end loop;
2602:
2603: /* insert into hz_location_profiles with std data */
2604: /* insert if std data available and the location record is */
2605: /* 1) record moved or */
2606: /* 2) record corrected, and maintaining history ,or */
2607: /* 3) record update, and maintaining history , or */

Line 2608: /* 4) record corrected, but no existing hz_location_profiles (l_temp_upd_count(k) = 0), or */

2604: /* insert if std data available and the location record is */
2605: /* 1) record moved or */
2606: /* 2) record corrected, and maintaining history ,or */
2607: /* 3) record update, and maintaining history , or */
2608: /* 4) record corrected, but no existing hz_location_profiles (l_temp_upd_count(k) = 0), or */
2609: /* 5) record update, but no existing hz_location_profiles (l_temp_upd_count(k) = 0) */
2610: if l_allow_std_update = 'Y' then
2611: ForAll j in 1..l_site_id.count
2612: insert into HZ_LOCATION_PROFILES

Line 2609: /* 5) record update, but no existing hz_location_profiles (l_temp_upd_count(k) = 0) */

2605: /* 1) record moved or */
2606: /* 2) record corrected, and maintaining history ,or */
2607: /* 3) record update, and maintaining history , or */
2608: /* 4) record corrected, but no existing hz_location_profiles (l_temp_upd_count(k) = 0), or */
2609: /* 5) record update, but no existing hz_location_profiles (l_temp_upd_count(k) = 0) */
2610: if l_allow_std_update = 'Y' then
2611: ForAll j in 1..l_site_id.count
2612: insert into HZ_LOCATION_PROFILES
2613: ( LOCATION_PROFILE_ID, LOCATION_ID,

Line 2612: insert into HZ_LOCATION_PROFILES

2608: /* 4) record corrected, but no existing hz_location_profiles (l_temp_upd_count(k) = 0), or */
2609: /* 5) record update, but no existing hz_location_profiles (l_temp_upd_count(k) = 0) */
2610: if l_allow_std_update = 'Y' then
2611: ForAll j in 1..l_site_id.count
2612: insert into HZ_LOCATION_PROFILES
2613: ( LOCATION_PROFILE_ID, LOCATION_ID,
2614: ADDRESS1, ADDRESS2, ADDRESS3, ADDRESS4,
2615: CITY, PROV_STATE_ADMIN_CODE,
2616: COUNTY, COUNTRY, POSTAL_CODE,

Line 2634: hz_location_profiles_s.NextVal,

2630: PROGRAM_ID,
2631: PROGRAM_UPDATE_DATE
2632: )
2633: ( select
2634: hz_location_profiles_s.NextVal,
2635: decode(l_move_count(j), 1, l_new_loc_id(j), l_location_id(j)),
2636: l_addr1_std(j),
2637: l_addr2_std(j),
2638: l_addr3_std(j),

Line 2670: insert into HZ_LOCATION_PROFILES

2666: or l_maintain_loc_hist = 'Y' -- to maintain history
2667: ))));
2668: else
2669: ForAll j in 1..l_site_id.count
2670: insert into HZ_LOCATION_PROFILES
2671: ( LOCATION_PROFILE_ID, LOCATION_ID,
2672: ADDRESS1, ADDRESS2, ADDRESS3, ADDRESS4,
2673: CITY, PROV_STATE_ADMIN_CODE,
2674: COUNTY, COUNTRY, POSTAL_CODE,

Line 2693: hz_location_profiles_s.NextVal,

2689: PROGRAM_ID,
2690: PROGRAM_UPDATE_DATE
2691: )
2692: ( select
2693: hz_location_profiles_s.NextVal,
2694: decode(l_move_count(j), 1, l_new_loc_id(j), l_location_id(j)),
2695: l_addr1_std(j),
2696: l_addr2_std(j),
2697: l_addr3_std(j),

Line 2936: update hz_location_profiles

2932: and l_move_count(j) = 1;
2933:
2934: /* Reset SST flag of other profiles of other actual content source */
2935: forall j in 1..l_site_id.count
2936: update hz_location_profiles
2937: set validation_sst_flag = 'N',
2938: object_version_number = object_version_number + 1,
2939: last_update_date = P_DML_RECORD.SYSDATE,
2940: last_updated_by = P_DML_RECORD.USER_ID,