1 PACKAGE xla_extract_integrity_pkg AUTHID CURRENT_USER AS
2 /* $Header: xlaamext.pkh 120.4 2005/05/04 12:22:15 ksvenkat ship $ */
3 /*===========================================================================+
4 | Copyright (c) 2001-2002 Oracle Corporation |
5 | Redwood Shores, CA, USA |
6 | All rights reserved. |
7 +============================================================================+
8 | PACKAGE NAME |
9 | xla_extract_integrity_pkg |
10 | |
11 | DESCRIPTION |
12 | This is the specification of the package that validates that the |
13 | extract is valid for an event class and creates sources and |
14 | source assignments for the event class |
15 | |
16 | HISTORY |
17 | 12/16/2003 Dimple Shah Created |
18 | |
19 +===========================================================================*/
20
21 -------------------------------------------------------------------------------
22 -- public routines
23 -------------------------------------------------------------------------------
24
25 /*======================================================================+
26 | |
27 | Public Function |
28 | |
29 | Check_extract_integrity |
30 | |
31 | This routine is called by the Create and Assign Sources program |
32 | to do all validations for an event class |
33 | |
34 +======================================================================*/
35 FUNCTION Check_extract_integrity
36 (p_application_id IN NUMBER
37 ,p_entity_code IN VARCHAR2
38 ,p_event_class_code IN VARCHAR2
39 ,p_processing_mode IN VARCHAR2)
40 RETURN BOOLEAN;
41
42 /*======================================================================+
43 | |
44 | Public Function |
45 | |
46 | Validate_extract_objects |
47 | |
48 | This routine is called to validate the extract objects |
49 | |
50 +======================================================================*/
51 FUNCTION Validate_extract_objects
52 (p_application_id IN NUMBER
53 ,p_entity_code IN VARCHAR2 DEFAULT NULL
54 ,p_event_class_code IN VARCHAR2 DEFAULT NULL
55 ,p_amb_context_code IN VARCHAR2 DEFAULT NULL
56 ,p_product_rule_type_code IN VARCHAR2 DEFAULT NULL
57 ,p_product_rule_code IN VARCHAR2 DEFAULT NULL)
58 RETURN BOOLEAN;
59
60 /*======================================================================+
61 | |
62 | Public Function |
63 | |
64 | Validate_sources |
65 | |
66 | This routine is called to insert all sources for an event class into |
67 | a global temporary table before calling validate_sources_with_extract |
68 | |
69 +======================================================================*/
70 FUNCTION Validate_sources
71 (p_application_id IN NUMBER
72 ,p_entity_code IN VARCHAR2
73 ,p_event_class_code IN VARCHAR2)
74 RETURN BOOLEAN;
75
76 /*======================================================================+
77 | |
78 | Public Function |
79 | |
80 | Validate_sources_with_extract |
81 | |
82 | This routine is called to validate the sources with extract objects |
83 | |
84 +======================================================================*/
85 FUNCTION Validate_sources_with_extract
86 (p_application_id IN NUMBER
87 ,p_entity_code IN VARCHAR2
88 ,p_event_class_code IN VARCHAR2
89 ,p_amb_context_code IN VARCHAR2 DEFAULT NULL
90 ,p_product_rule_type_code IN VARCHAR2 DEFAULT NULL
91 ,p_product_rule_code IN VARCHAR2 DEFAULT NULL)
92 RETURN BOOLEAN;
93
94 /*======================================================================+
95 | |
96 | Public Procedure |
97 | |
98 | Set_extract_object_owner |
99 | |
100 | This routine is called to get the owner for extract objects and |
101 | store it in a GT table |
102 | |
103 +======================================================================*/
104 PROCEDURE Set_extract_object_owner
105 (p_application_id IN NUMBER
106 ,p_amb_context_code IN VARCHAR2 DEFAULT NULL
107 ,p_product_rule_type_code IN VARCHAR2 DEFAULT NULL
108 ,p_product_rule_code IN VARCHAR2 DEFAULT NULL
109 ,p_entity_code IN VARCHAR2 DEFAULT NULL
110 ,p_event_class_code IN VARCHAR2 DEFAULT NULL);
111
112 END xla_extract_integrity_pkg;