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_ORG_CONTACT_PKG dependencies on DUAL

Line 314: * Error is caught individually, it's reported individually

310: * P_ACTION IN VARCHAR2,
311: * P_DML_EXCEPTION IN VARCHAR2,
312: *
313: * NOTES Used by update procedure.
314: * Error is caught individually, it's reported individually
315: *
316: * MODIFICATION HISTORY
317: *
318: * 07-10-03 Kate Shan o Created

Line 440: from dual

436: l_start_date_errors(j),
437: 'Y',
438: 'Y',
439: l_exception_exists(j)
440: from dual
441: where l_num_row_processed(j) = 0
442: );
443:
444: -- FND_FILE.PUT_LINE(FND_FILE.LOG, 'report_errors (-)');

Line 1158: (select 0 a from dual union all select 1 a from dual) tc,

1154: nvl2(nullif(ocint.created_by_module, :p_gmiss_char), nvl2(createdby_l.lookup_code, ''Y'', null), ''Y'') createdby_error
1155:
1156: from hz_imp_contacts_sg ocsg,
1157: hz_imp_contacts_int ocint,
1158: (select 0 a from dual union all select 1 a from dual) tc,
1159: hz_parties sp,
1160: hz_parties op,
1161: fnd_lookup_values party_rel_type_l,
1162: fnd_lookup_values dept_l,

Line 1567: (select 0 a from dual union all select 1 a from dual) tc

1563: AR_LOOKUPS title_l,
1564: AR_LOOKUPS decision_l,
1565: AR_LOOKUPS job_title_code_l,
1566: AR_LOOKUPS reference_use_l,
1567: (select 0 a from dual union all select 1 a from dual) tc
1568: WHERE
1569: ci.rowid = cs.int_row_id
1570: AND cs.contact_id = oc.org_contact_id
1571: AND oc.party_relationship_id = r.relationship_id