1 PACKAGE GCS_CONS_IMPACT_ANALYSIS_PKG as
2 /* $Header: gcs_cons_impacts.pls 120.3 2007/10/09 07:15:12 smatam ship $ */
3
4 --
5 -- Procedure
6 -- hierarchy_altered()
7 -- Purpose
8 -- Tracks any changes made to the date effective relationship attributes
9 -- Arguments
10 -- p_pre_cons_relationship_id Original Relationship
11 -- p_post_cons_relationship_id New Relationship
12 -- p_trx_type_code A&D Transaction Type (NONE if Not Applicable)
13 -- p_trx_date_day Day of Transaction
14 -- p_trx_date_month Month of Transaction
15 -- p_trx_date_year Year of Transaction
16 -- p_hidden_flag Dictates wether or not to show the transaction
17 -- p_intermediate_trtmnt_id Intermediate Treatment
18 -- p_intermediate_pct_owned Intermediate Pct Ownership
19 -- Notes
20 --
21 FUNCTION hierarchy_altered(p_pre_cons_relationship_id IN NUMBER,
22 p_post_cons_relationship_id IN NUMBER,
23 p_trx_type_code IN VARCHAR2,
24 p_trx_date_day IN NUMBER,
25 p_trx_date_month IN NUMBER,
26 p_trx_date_year IN NUMBER,
27 p_hidden_flag IN VARCHAR2,
28 p_intermediate_trtmnt_id IN NUMBER,
29 p_intermediate_pct_owned IN NUMBER)
30 RETURN VARCHAR2;
31 --
32 -- Procedure
33 -- pristine_data_altered()
34 -- Purpose
35 -- Tracks any loads performed by data submission
36 -- Arguments
37 -- p_subscription_guid Standard Business Event Parameter
38 -- p_event Standard Business Event Parameter
39 -- Notes
40 -- Not yet implemented, since FEM has not published a business event
41
42 FUNCTION data_sub_load_executed(p_subscription_guid in raw,
43 p_event in out nocopy wf_event_t)
44 RETURN VARCHAR2;
45 --
46 -- Procedure
47 -- acqdisp_altered()
48 -- Purpose
49 -- Tracks any changes to A&D Transactions
50 -- Arguments
51 -- p_subscription_guid Standard Business Event Parameter
52 -- p_event Standard Business Event Parameter
53 -- Notes
54
55 FUNCTION acqdisp_altered(p_subscription_guid in raw,
56 p_event in out nocopy wf_event_t)
57 RETURN VARCHAR2;
58
59 --
60 -- Procedure
61 -- adjustment_altered()
62 -- Purpose
63 -- Tracks any changes to adjustments
64 -- Arguments
65 -- p_subscription_guid Standard Business Event Parameter
66 -- p_event Standard Business Event Parameter
67 -- Notes
68
69 FUNCTION adjustment_altered(p_subscription_guid in raw,
70 p_event in out nocopy wf_event_t)
71 RETURN VARCHAR2;
72 --
73 -- Procedure
74 -- daily_rates_altered()
75 -- Purpose
76 -- Tracks any changes to rates Period End/Average Rates
77 -- Arguments
78 -- p_subscription_guid Standard Business Event Parameter
79 -- p_event Standard Business Event Parameter
80 -- Notes
81
82 FUNCTION daily_rates_altered(p_subscription_guid in raw,
83 p_event in out nocopy wf_event_t)
84 RETURN VARCHAR2;
85
86 --
87 -- Procedure
88 -- historical_rates_altered()
89 -- Purpose
90 -- Tracks any changes to rates Period End/Average Rates
91 -- Arguments
92 -- p_subscription_guid Standard Business Event Parameter
93 -- p_event Standard Business Event Parameter
94 -- Notes
95
96 FUNCTION historical_rates_altered(p_subscription_guid in raw,
97 p_event in out nocopy wf_event_t)
98 RETURN VARCHAR2;
99
100 --
101 -- Procedure
102 -- consolidation_completed()
103 -- Purpose
104 -- Tracks if a prior period has been reconsolidated, or a sub has been reconsolidation
105 -- Arguments
106 -- p_run_name Process Identifier
107 -- p_run_entity_id Run Entity
108 -- p_cal_period_id Calendar Period
109 -- p_cal_period_end_date End Date of Calendar Period
110 -- p_hierarchy_id Hierarchy Identifier
111 -- p_balance_type_code Balance Type
112 -- Notes
113
114 PROCEDURE consolidation_completed(p_run_name IN VARCHAR2,
115 p_run_entity_id IN NUMBER,
116 p_cal_period_id IN NUMBER,
117 p_cal_period_end_date IN DATE,
118 p_hierarchy_id IN NUMBER,
119 p_balance_type_code IN VARCHAR2);
120
121 --
122 -- Procedure
123 -- value_set_map_updated()
124 -- Purpose
125 -- Tracks if a value set map has been updated post consolidation
126 -- Arguments
127 -- p_dimension_id Dimension Identifier
128 -- p_object_id Object Identifier
129 -- p_object_definition_id Object Definition Identifier
130 -- p_eff_start_date Effective Start Date
131 -- p_eff_end_date Effective End Date
132 -- Notes
133
134 PROCEDURE value_set_map_updated(p_dimension_id IN NUMBER,
135 p_eff_start_date IN DATE,
136 p_eff_end_date IN DATE,
137 p_consolidation_vs_id IN NUMBER);
138 --
139 -- Function
140 -- adjustment_disabled()
141 -- Purpose
142 -- Tracks disabling adjustments
143 -- Arguments
144 -- p_subscription_guid Standard Business Event Parameter
145 -- p_event Standard Business Event Parameter
146 -- Notes
147 -- Bugfix 5613302
148
149 FUNCTION adjustment_disabled(p_subscription_guid in raw,
150 p_event in out nocopy wf_event_t)
151 RETURN VARCHAR2;
152
153 END GCS_CONS_IMPACT_ANALYSIS_PKG;
154
[Home] [Help]