[Home] [Help]
259: zx_on_fly_trx_upgrade_pkg.upgrade_trx_on_fly_blk(x_return_status);
260:
261: -- Bug # 4697301
262: delete from ZX_VALIDATION_ERRORS_GT err where EXISTS
263: (Select 1 from ZX_LINES_DET_FACTORS linedet where
264: linedet.application_id = err.other_doc_application_id and
265: linedet.entity_code = err.other_doc_entity_code and
266: linedet.event_class_code = err.other_doc_event_class_code and
267: linedet.trx_id = err.other_doc_trx_id and
7134: lines_gt.adjusted_doc_entity_code adj_doc_entity_code,
7135: lines_gt.adjusted_doc_event_class_code adj_doc_event_class_code,
7136: lines_gt.adjusted_doc_trx_id adj_doc_trx_id,
7137:
7138: -- Check for existence of related documents in zx lines det factors table
7139: -- Since the Selection is at the granularity of the transaction lines, also check for existence of
7140: -- error record in validaiton errors gt to avoid inserting header level errors multiple times
7141: -- Also check in zx trx headers gt if this doc is already present
7142: nvl2( header.related_doc_trx_id,
7140: -- error record in validaiton errors gt to avoid inserting header level errors multiple times
7141: -- Also check in zx trx headers gt if this doc is already present
7142: nvl2( header.related_doc_trx_id,
7143: CASE WHEN ((NOT EXISTS
7144: (SELECT 1 FROM ZX_LINES_DET_FACTORS
7145: WHERE application_id = header.related_doc_application_id
7146: AND entity_code = header.related_doc_entity_code
7147: AND event_class_code = header.related_doc_event_class_code
7148: AND trx_id = header.related_doc_trx_id))
7163: THEN 'Y'
7164: ELSE NULL END,
7165: NULL) ZX_REL_DOC_MISSING,
7166:
7167: -- Check for existence of reference documents in zx lines det factors table and zx trx lines gt
7168: nvl2( lines_gt.ref_doc_trx_id,
7169: CASE WHEN ((NOT EXISTS
7170: (SELECT 1 FROM ZX_LINES_DET_FACTORS
7171: WHERE application_id = lines_gt.ref_doc_application_id
7166:
7167: -- Check for existence of reference documents in zx lines det factors table and zx trx lines gt
7168: nvl2( lines_gt.ref_doc_trx_id,
7169: CASE WHEN ((NOT EXISTS
7170: (SELECT 1 FROM ZX_LINES_DET_FACTORS
7171: WHERE application_id = lines_gt.ref_doc_application_id
7172: AND entity_code = lines_gt.ref_doc_entity_code
7173: AND event_class_code = lines_gt.ref_doc_event_class_code
7174: AND trx_id = lines_gt.ref_doc_trx_id
7185: THEN 'Y'
7186: ELSE NULL END,
7187: NULL) ZX_REF_DOC_MISSING,
7188:
7189: -- Check for applied from documents in zx lines det factors table and zx trx lines gt
7190: nvl2( lines_gt.applied_from_trx_id,
7191: CASE WHEN ((NOT EXISTS
7192: (SELECT 1 FROM ZX_LINES_DET_FACTORS
7193: WHERE application_id = lines_gt.applied_from_application_id
7188:
7189: -- Check for applied from documents in zx lines det factors table and zx trx lines gt
7190: nvl2( lines_gt.applied_from_trx_id,
7191: CASE WHEN ((NOT EXISTS
7192: (SELECT 1 FROM ZX_LINES_DET_FACTORS
7193: WHERE application_id = lines_gt.applied_from_application_id
7194: AND entity_code = lines_gt.applied_from_entity_code
7195: AND event_class_code = lines_gt.applied_from_event_class_code
7196: AND trx_id = lines_gt.applied_from_trx_id
7207: THEN 'Y'
7208: ELSE NULL END,
7209: NULL) ZX_APP_FROM_DOC_MISSING,
7210:
7211: -- Check for adjusted document in zx lines det factors table and zx trx lines gt
7212: nvl2( lines_gt.adjusted_doc_trx_id,
7213: CASE WHEN ((NOT EXISTS
7214: (SELECT 1 FROM ZX_LINES_DET_FACTORS
7215: WHERE application_id = lines_gt.adjusted_doc_application_id
7210:
7211: -- Check for adjusted document in zx lines det factors table and zx trx lines gt
7212: nvl2( lines_gt.adjusted_doc_trx_id,
7213: CASE WHEN ((NOT EXISTS
7214: (SELECT 1 FROM ZX_LINES_DET_FACTORS
7215: WHERE application_id = lines_gt.adjusted_doc_application_id
7216: AND entity_code = lines_gt.adjusted_doc_entity_code
7217: AND event_class_code = lines_gt.adjusted_doc_event_class_code
7218: AND trx_id = lines_gt.adjusted_doc_trx_id
7229: THEN 'Y'
7230: ELSE NULL END,
7231: NULL) ZX_ADJ_DOC_MISSING,
7232:
7233: -- Check for applied to documents in zx lines det factors table and zx trx lines gt
7234:
7235: /* Since we do not store applied to document (receipt), we should
7236: not check whether the doc exists in eTax repository
7237:
7236: not check whether the doc exists in eTax repository
7237:
7238: nvl2( lines_gt.applied_to_trx_id,
7239: CASE WHEN ((NOT EXISTS
7240: (SELECT 1 FROM ZX_LINES_DET_FACTORS
7241: WHERE application_id = lines_gt.applied_to_application_id
7242: AND entity_code = lines_gt.applied_to_entity_code
7243: AND event_class_code = lines_gt.applied_to_event_class_code
7244: AND trx_id = lines_gt.applied_to_trx_id
7256: ELSE NULL END,
7257: NULL) ZX_APP_TO_DOC_MISSING,
7258: */
7259:
7260: -- Check for source documents in zx lines det factors table and zx trx lines gt
7261: nvl2( lines_gt.source_trx_id,
7262: CASE WHEN ((NOT EXISTS
7263: (SELECT 1
7264: FROM ZX_LINES_DET_FACTORS line,
7260: -- Check for source documents in zx lines det factors table and zx trx lines gt
7261: nvl2( lines_gt.source_trx_id,
7262: CASE WHEN ((NOT EXISTS
7263: (SELECT 1
7264: FROM ZX_LINES_DET_FACTORS line,
7265: ZX_EVNT_CLS_MAPPINGS map
7266: WHERE lines_gt.application_id = map.application_id
7267: AND lines_gt.entity_code = map.entity_code
7268: AND lines_gt.event_class_code = map.event_class_code