PACKAGE BODY: APPS.ZX_TAXEVENT_PUB

Source

1 PACKAGE BODY zx_taxevent_pub AS
2 /* $Header: zxifvaldevntpubb.pls 120.6 2006/03/01 20:01:49 appradha ship $ */
3 
4 /* ==============================================================================*
5  | FUNCTION is_event_type_valid : Returns true if event type is mapped in TSRM |
6  * ==============================================================================*/
7 
8  FUNCTION is_event_type_valid
9    (
10      p_application_id     IN  NUMBER,
11      p_entity_code        IN  VARCHAR2,
12      p_event_class_code   IN  VARCHAR2,
13      p_event_type_code    IN  VARCHAR2
14    )
15  RETURN BOOLEAN IS
16      dummy NUMBER;
17  BEGIN
18      SELECT 1
19      INTO dummy
20      FROM zx_evnt_typ_mappings
21      WHERE application_id = p_application_id
22        AND entity_code = p_entity_code
23        AND event_class_code = p_event_class_code
24        AND event_type_code = p_event_type_code;
25 
26      RETURN TRUE;
27 
28      EXCEPTION
29      WHEN NO_DATA_FOUND THEN
30        RETURN FALSE;
31 
32  END is_event_type_valid;
33 END zx_taxevent_pub;