[Home] [Help]
1468: IF(p_service_type_code = 'DERIVE_HDR_ATTRS') THEN
1469: BEGIN
1470: SELECT 1
1471: INTO l_dummy
1472: FROM ZX_PRVDR_HDR_EXTNS_GT
1473: WHERE application_id = p_event_class_rec.application_id
1474: AND entity_code = p_event_class_rec.entity_code
1475: AND event_class_code = p_event_class_rec.event_class_code
1476: AND trx_id = p_event_class_rec.trx_id;
1476: AND trx_id = p_event_class_rec.trx_id;
1477:
1478: EXCEPTION
1479: WHEN NO_DATA_FOUND THEN
1480: INSERT INTO ZX_PRVDR_HDR_EXTNS_GT(event_class_code,
1481: application_id,
1482: entity_code,
1483: trx_id,
1484: provider_id,