APPS.HZ_IMP_LOAD_ADDRESSES_PKG dependencies on HZ_PARTIES

Line 186: TYPE OWNING_PARTY_ID_LIST IS TABLE OF HZ_PARTIES.PARTY_ID%TYPE;

182: l_allow_std_update VARCHAR2(1);
183:
184: l_third_party_update_error FLAG_ERROR; /* bug 4079902 */
185:
186: TYPE OWNING_PARTY_ID_LIST IS TABLE OF HZ_PARTIES.PARTY_ID%TYPE;
187: l_owning_party_id OWNING_PARTY_ID_LIST;
188:
189: --------------------------------------
190: -- forward declaration of private procedures and functions

Line 959: HZ_PARTIES hp,

955: (select language_code
956: from FND_LANGUAGES
957: where installed_flag in (''B'', ''I'')) fnd_lang,
958: fnd_timezones_b timezone,
959: HZ_PARTIES hp,
960: fnd_lookup_values createdby_l
961: WHERE hp.party_id (+) = site_sg.party_id
962: AND hp.status (+) = ''A''
963: AND site_sg.action_flag = ''I''

Line 1072: update hz_parties hz_pty

1068: l_error_party_id, l_error_site_id;
1069: close primary_flag_err_cursor;
1070:
1071: forall i in 1..l_error_party_id.count
1072: update hz_parties hz_pty
1073: set ( address1, address2, address3, address4,
1074: country, county, city, state, province,
1075: postal_code ) =
1076: ( select address1, address2, address3, address4,

Line 1155: update hz_parties hz_pty

1151: l_update_party_id, l_update_site_id;
1152: close de_norm_cursor;
1153:
1154: forall i in 1..l_update_party_id.count
1155: update hz_parties hz_pty
1156: set ( address1, address2, address3, address4,
1157: country, county, city, state, province,
1158: postal_code
1159: ) =

Line 1493: AND mosr.owner_table_name (+) = ''HZ_PARTIES''

1489:
1490: WHERE mosr.orig_system (+) = site_sg.party_orig_system
1491: AND mosr.orig_system_reference (+) = site_sg.party_orig_system_reference
1492: AND mosr.status (+) = ''A''
1493: AND mosr.owner_table_name (+) = ''HZ_PARTIES''
1494: AND mosr.owner_table_id (+) = site_sg.party_id
1495: AND site_sg.action_flag = ''U''
1496: AND site_int.batch_id = :CP_BATCH_ID
1497: AND site_sg.batch_id = :CP_BATCH_ID

Line 1723: AND mosr.owner_table_name (+) = ''HZ_PARTIES''

1719: fnd_lookup_values createdby_l
1720: WHERE mosr.orig_system (+) = site_sg.party_orig_system
1721: AND mosr.orig_system_reference (+) = site_sg.party_orig_system_reference
1722: AND mosr.status (+) = ''A''
1723: AND mosr.owner_table_name (+) = ''HZ_PARTIES''
1724: AND mosr.owner_table_id (+) = site_sg.party_id
1725: AND site_sg.action_flag = ''U''
1726: AND site_int.batch_id = :CP_BATCH_ID
1727: AND site_sg.batch_id = :CP_BATCH_ID

Line 2947: /* For corrected address, de-norm the value to hz_parties if */

2943: and (l_allow_std_update = 'Y' or l_val_status_code(j) is null);
2944:
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 */

Line 2976: update hz_parties

2972:
2973: IF g_pst_is_datasource_selected = 'Y' THEN
2974: */
2975: forall j in 1..l_site_id.count
2976: update hz_parties
2977: set country = decode(l_accept_std_flag(j), 'Y', l_country_std(j),
2978: decode(l_country(j), null, COUNTRY, l_country(j))),
2979: address1 = decode(l_accept_std_flag(j), 'Y', l_addr1_std(j),
2980: decode(l_addr1(j), null, ADDRESS1, l_addr1(j))),