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_POST_PROCESS_PKG dependencies on HZ_PARTIES

Line 122: UPDATE hz_parties set

118:
119: BEGIN
120: IF p_postprocess_status IS NULL THEN
121: FORALL i in 1..l_subject_id.count
122: UPDATE hz_parties set
123: competitor_flag = decode(l_comp_flag(i),'Y','Y',competitor_flag),
124: reference_use_flag = decode(l_ref_flag(i) ,'Y','Y',reference_use_flag),
125: third_party_flag = decode(l_par_flag(i) ,'Y','Y',third_party_flag)
126: WHERE party_id = l_subject_id(i)

Line 130: UPDATE hz_parties set

126: WHERE party_id = l_subject_id(i)
127: AND request_id = p_request_id;
128: ELSIF p_postprocess_status = 'U' THEN
129: FORALL i in 1..l_subject_id.count
130: UPDATE hz_parties set
131: competitor_flag = decode(l_comp_flag(i),'Y','Y',competitor_flag),
132: reference_use_flag = decode(l_ref_flag(i) ,'Y','Y',reference_use_flag),
133: third_party_flag = decode(l_par_flag(i) ,'Y','Y',third_party_flag)
134: WHERE party_id = l_subject_id(i)

Line 180: FROM HZ_PARTIES p, HZ_PERSON_PROFILES pf, HZ_IMP_PARTIES_SG ps

176: ,p.known_as
177: ,p.person_first_name_phonetic
178: ,pf.middle_name_phonetic
179: ,p.person_last_name_phonetic
180: FROM HZ_PARTIES p, HZ_PERSON_PROFILES pf, HZ_IMP_PARTIES_SG ps
181: WHERE p.request_id = :p_request_id
182: AND p.party_type = ''PERSON''
183: AND p.party_id = pf.party_id
184: AND pf.effective_end_date is NULL

Line 201: FROM HZ_PARTIES p, HZ_PERSON_PROFILES pf, HZ_IMP_PARTIES_SG ps, hz_imp_batch_details bd

197: ,p.known_as
198: ,p.person_first_name_phonetic
199: ,pf.middle_name_phonetic
200: ,p.person_last_name_phonetic
201: FROM HZ_PARTIES p, HZ_PERSON_PROFILES pf, HZ_IMP_PARTIES_SG ps, hz_imp_batch_details bd
202: WHERE p.request_id = bd.main_conc_req_id
203: AND bd.batch_id = ps.batch_id
204: AND p.party_type = ''PERSON''
205: AND p.party_id = pf.party_id

Line 213: l_person_name HZ_PARTIES.PARTY_NAME%TYPE;

209: AND ps.party_orig_system = :p_os
210: AND ps.party_orig_system_reference between :p_from_osr and :p_to_osr
211: AND ps.batch_mode_flag = :p_batch_mode_flag';
212:
213: l_person_name HZ_PARTIES.PARTY_NAME%TYPE;
214: c_person_name RefCurType;
215:
216: BEGIN
217:

Line 269: UPDATE hz_parties

265: SET person_name = l_person_name
266: WHERE party_id = l_party_id(i)
267: AND effective_end_date is NULL;
268:
269: UPDATE hz_parties
270: SET party_name = substrb(l_person_name,1,360)
271: WHERE party_id = l_party_id(i);
272:
273: EXCEPTION

Line 317: FROM hz_parties p, HZ_IMP_PARTIES_SG ps

313: ,p.person_last_name
314: ,null record_id
315: ,''PARTY'' entity
316: ,decode(ps.action_flag, ''I'', ''C'', ps.action_flag) operation_flag
317: FROM hz_parties p, HZ_IMP_PARTIES_SG ps
318: WHERE p.request_id = :p_request_id
319: AND p.party_type IN (''ORGANIZATION'',''PERSON'',''GROUP'')
320: AND p.party_id = ps.party_id
321: AND ps.batch_id = :p_batch_id

Line 334: FROM hz_parties p, HZ_IMP_PARTIES_SG ps, hz_imp_batch_details bd

330: ,p.person_last_name
331: ,null record_id
332: ,''PARTY'' entity
333: ,decode(ps.action_flag, ''I'', ''C'', ps.action_flag) operation_flag
334: FROM hz_parties p, HZ_IMP_PARTIES_SG ps, hz_imp_batch_details bd
335: WHERE p.request_id = bd.main_conc_req_id
336: AND bd.batch_id = ps.batch_id
337: AND p.party_type IN (''ORGANIZATION'',''PERSON'',''GROUP'')
338: AND p.party_id = ps.party_id

Line 398: UPDATE HZ_PARTIES

394: p_postal_code => NULL,
395: p_first_name => l_person_first_name(i),
396: p_last_name => l_person_last_name(i));
397:
398: UPDATE HZ_PARTIES
399: SET customer_key = l_key
400: WHERE party_id = l_party_id(i);
401: EXCEPTION
402: WHEN OTHERS THEN

Line 586: AND r.object_table_name = 'HZ_PARTIES'

582: AND r.relationship_type IN ('HEADQUARTERS/DIVISION','PARENT/SUBSIDIARY',
583: 'DOMESTIC_ULTIMATE','GLOBAL_ULTIMATE')
584: AND r.relationship_code IN ('PARENT_OF','HEADQUARTERS_OF',
585: 'DOMESTIC_ULTIMATE_OF','GLOBAL_ULTIMATE_OF')
586: AND r.object_table_name = 'HZ_PARTIES'
587: AND r.relationship_id = rs.relationship_id
588: AND r.directional_flag = 'F'
589: ORDER BY r.object_id;
590:

Line 1121: /* Denormalize the primary contact point type in hz_parties table */

1117: l_country_code(i)||l_phone_area_code(i)||l_phone_number(i))
1118: Where contact_point_id = l_contact_point_id(i);
1119: END IF;
1120:
1121: /* Denormalize the primary contact point type in hz_parties table */
1122: IF l_primary_flag(i) = 'Y' AND l_owner_table_name(i) = 'HZ_PARTIES' THEN
1123: UPDATE hz_parties set
1124: primary_phone_contact_pt_id = l_contact_point_id(i),
1125: primary_phone_purpose = l_primary_by_purpose(i),

Line 1122: IF l_primary_flag(i) = 'Y' AND l_owner_table_name(i) = 'HZ_PARTIES' THEN

1118: Where contact_point_id = l_contact_point_id(i);
1119: END IF;
1120:
1121: /* Denormalize the primary contact point type in hz_parties table */
1122: IF l_primary_flag(i) = 'Y' AND l_owner_table_name(i) = 'HZ_PARTIES' THEN
1123: UPDATE hz_parties set
1124: primary_phone_contact_pt_id = l_contact_point_id(i),
1125: primary_phone_purpose = l_primary_by_purpose(i),
1126: primary_phone_line_type = l_phone_line_type(i),

Line 1123: UPDATE hz_parties set

1119: END IF;
1120:
1121: /* Denormalize the primary contact point type in hz_parties table */
1122: IF l_primary_flag(i) = 'Y' AND l_owner_table_name(i) = 'HZ_PARTIES' THEN
1123: UPDATE hz_parties set
1124: primary_phone_contact_pt_id = l_contact_point_id(i),
1125: primary_phone_purpose = l_primary_by_purpose(i),
1126: primary_phone_line_type = l_phone_line_type(i),
1127: primary_phone_country_code = l_country_code(i),

Line 1277: /* HZ_PARTIES */

1273: IF (P_OS IS NULL) Then
1274: EXIT;
1275: END IF;
1276:
1277: /* HZ_PARTIES */
1278: fnd_file.put_line(fnd_file.log,' Post Processing for HZ_PARTIES entity ');
1279:
1280: if (l_run_format_person_name_flag) then
1281: fnd_file.put_line(fnd_file.log,' Format Person Name (+) ');

Line 1278: fnd_file.put_line(fnd_file.log,' Post Processing for HZ_PARTIES entity ');

1274: EXIT;
1275: END IF;
1276:
1277: /* HZ_PARTIES */
1278: fnd_file.put_line(fnd_file.log,' Post Processing for HZ_PARTIES entity ');
1279:
1280: if (l_run_format_person_name_flag) then
1281: fnd_file.put_line(fnd_file.log,' Format Person Name (+) ');
1282: pp_format_person_name(P_BATCH_MODE_FLAG,P_BATCH_ID,P_OS,P_FROM_OSR,P_TO_OSR,P_REQUEST_ID, NULL);

Line 1384: /* HZ_PARTIES */

1380: IF (P_OS IS NULL) Then
1381: EXIT;
1382: END IF;
1383:
1384: /* HZ_PARTIES */
1385: fnd_file.put_line(fnd_file.log,' Post Processing for HZ_PARTIES entity ');
1386:
1387: if (l_run_format_person_name_flag) then
1388: fnd_file.put_line(fnd_file.log,' Format Person Name (+) ');

Line 1385: fnd_file.put_line(fnd_file.log,' Post Processing for HZ_PARTIES entity ');

1381: EXIT;
1382: END IF;
1383:
1384: /* HZ_PARTIES */
1385: fnd_file.put_line(fnd_file.log,' Post Processing for HZ_PARTIES entity ');
1386:
1387: if (l_run_format_person_name_flag) then
1388: fnd_file.put_line(fnd_file.log,' Format Person Name (+) ');
1389: pp_format_person_name(P_BATCH_MODE_FLAG,P_BATCH_ID,P_OS,P_FROM_OSR,P_TO_OSR,P_REQUEST_ID, 'U');