[Home] [Help]
603: :3,
604: :8,
605: :7,
606: :5)
607: into hz_locations (
608: actual_content_source,
609: application_id,
610: content_source_type,
611: created_by,
1076: ( select address1, address2, address3, address4,
1077: country, county, city, state, province,
1078: postal_code
1079: from hz_party_sites hz_ps,
1080: hz_locations hz_loc
1081: where hz_ps.location_id = hz_loc.location_id
1082: and hz_ps.party_site_id = l_error_site_id(i)
1083: union -- nullify if no next available address
1084: select null,null,null,null,null,
1117: /* Commented the code for bug 4079902. */
1118:
1119: /*
1120: HZ_MIXNM_UTILITY.LoadDataSources(
1121: p_entity_name => 'HZ_LOCATIONS',
1122: p_entity_attr_id => g_pst_entity_attr_id,
1123: p_mixnmatch_enabled => g_pst_mixnmatch_enabled,
1124: p_selected_datasources => g_pst_selected_datasources );
1125:
1160: ( select address1, address2, address3, address4,
1161: country, county, city, state, province,
1162: postal_code
1163: from hz_party_sites hz_ps,
1164: hz_locations hz_loc
1165: where hz_ps.location_id = hz_loc.location_id
1166: and hz_ps.party_site_id = l_update_site_id(i)
1167: ),
1168: object_version_number = object_version_number + 1,
1479: where installed_flag in (''B'', ''I'')
1480: ) fnd_lang,
1481: fnd_timezones_b timezone,
1482: hz_party_sites hz_ps,
1483: hz_locations hz_loc,
1484: HZ_ORIG_SYS_REFERENCES mosr,
1485: HZ_ORIG_SYSTEMS_B hos,
1486: hz_party_sites hz_ps1,
1487: HZ_ORIG_SYS_REFERENCES mosr2,
1710: where installed_flag in (''B'', ''I'')
1711: ) fnd_lang,
1712: fnd_timezones_b timezone,
1713: hz_party_sites hz_ps,
1714: hz_locations hz_loc,
1715: HZ_ORIG_SYS_REFERENCES mosr,
1716: HZ_ORIG_SYSTEMS_B hos,
1717: hz_party_sites hz_ps1,
1718: HZ_ORIG_SYS_REFERENCES mosr2,
2333: end loop;
2334:
2335: report_errors(P_DML_RECORD, l_dml_exception);
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 */
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,
2345: LAST_UPDATED_BY = P_DML_RECORD.USER_ID,
2346: LAST_UPDATE_LOGIN = P_DML_RECORD.LAST_UPDATE_LOGIN,
2347: REQUEST_ID = P_DML_RECORD.REQUEST_ID,
2764: and ( l_move_count(j) = 1 or
2765: (l_corr_upd_count(j) = 1 and
2766: l_site_orig_system_reference(j) <> l_old_site_osr(j)));
2767:
2768: /* insert into hz_locations with user or std data based on accept std flag */
2769: /* insert if move */
2770: forall j in 1..l_site_id.count
2771: insert into hz_locations
2772: ( LOCATION_ID,
2767:
2768: /* insert into hz_locations with user or std data based on accept std flag */
2769: /* insert if move */
2770: forall j in 1..l_site_id.count
2771: insert into hz_locations
2772: ( LOCATION_ID,
2773: LAST_UPDATE_DATE, LAST_UPDATED_BY, CREATION_DATE, CREATED_BY, LAST_UPDATE_LOGIN,
2774: CONTENT_SOURCE_TYPE,
2775: ACTUAL_CONTENT_SOURCE,
2963: /* Commented the code for bug 4079902. */
2964:
2965: /*
2966: HZ_MIXNM_UTILITY.LoadDataSources(
2967: p_entity_name => 'HZ_LOCATIONS',
2968: p_entity_attr_id => g_pst_entity_attr_id,
2969: p_mixnmatch_enabled => g_pst_mixnmatch_enabled,
2970: p_selected_datasources => g_pst_selected_datasources );
2971:
3249: FND_GLOBAL.User_ID CREATED_BY,
3250: SYSDATE LAST_UPDATE_DATE,
3251: FND_GLOBAL.User_ID LAST_UPDATED_BY,
3252: FND_GLOBAL.Login_ID LAST_UPDATE_LOGIN
3253: FROM HZ_PARTY_SITES ps, HZ_IMP_ADDRESSES_SG pssg,HZ_LOCATIONS loc, --4742586
3254: HZ_IMP_ADDRESSES_INT psint
3255: WHERE loc.request_id = p_request_id --Bug No.4956874.SQLID:14455142
3256: AND ps.party_site_id = pssg.party_site_id -- Bug 5210879.
3257: AND loc.location_id = ps.location_id --4742586