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

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

114: * P_ACTION IN VARCHAR2,
115: * P_DML_EXCEPTION IN VARCHAR2,
116: *
117: * NOTES Used by update procedure.
118: * Error is caught individually, it's reported individually
119: *
120: * MODIFICATION HISTORY
121: *
122: * 07-10-03 Kate Shan o Created

Line 237: from dual

233: l_start_date_errors(j),
234: decode(l_dss_security_errors(j), FND_API.G_TRUE,'Y',null),
235: 'Y',
236: l_exception_exists(j)
237: from dual
238: where l_num_row_processed(j) = 0
239: );
240:
241: -- FND_FILE.PUT_LINE(FND_FILE.LOG, 'report_errors (-)');

Line 486: with tc as (select 0 a from dual union all select 1 a from dual)

482: multi_assign_error,
483: leaf_node_error,
484: ''Y'', ''Y'',
485: createdby_error)
486: with tc as (select 0 a from dual union all select 1 a from dual)
487: select /*+ ordered push_subq index(cas) use_nl(cai) use_nl(class_code_lookups) */ cai.rowid row_id,
488: cas.code_assignment_id,
489: hp.party_id party_id,
490: cai.class_category,

Line 882: check for 'SIC' instead of the individual SIC code type as this is how

878: close primary_flag_err_cursor;
879:
880: -- nullify denorm column in hz_parties
881: /* Bug 409189: when checking class_category in hz_imp_classifics_sg,
882: check for 'SIC' instead of the individual SIC code type as this is how
883: matching populates the column */
884: forall i in 1..l_error_party_id.count
885: update hz_parties hz_pty
886: set category_code = decode(l_error_class_category(i), 'CUSTOMER_CATEGORY', null, category_code),

Line 1108: (select 0 a from dual union all select 1 a from dual) tc1,

1104: decode(tc1.a, 0, ''Y'') identical_classcode_error,
1105: decode(tc2.a, 0, ''Y'') multi_assign_error
1106: FROM HZ_IMP_CLASSIFICS_INT cai,
1107: HZ_IMP_CLASSIFICS_SG cas,
1108: (select 0 a from dual union all select 1 a from dual) tc1,
1109: (select 0 a from dual union all select 1 a from dual) tc2
1110: WHERE
1111: cas.batch_id = :P_BATCH_ID
1112: AND cas.batch_mode_flag = :P_BATCH_MODE_FLAG

Line 1109: (select 0 a from dual union all select 1 a from dual) tc2

1105: decode(tc2.a, 0, ''Y'') multi_assign_error
1106: FROM HZ_IMP_CLASSIFICS_INT cai,
1107: HZ_IMP_CLASSIFICS_SG cas,
1108: (select 0 a from dual union all select 1 a from dual) tc1,
1109: (select 0 a from dual union all select 1 a from dual) tc2
1110: WHERE
1111: cas.batch_id = :P_BATCH_ID
1112: AND cas.batch_mode_flag = :P_BATCH_MODE_FLAG
1113: AND cas.party_orig_system = :P_WU_OS