1 PACKAGE GCS_TRANS_HRATES_DYNAMIC_PKG AUTHID CURRENT_USER AS
2 /* $Header: gcsxldhratesps.pls 120.2 2007/06/28 12:28:07 vkosuri noship $ */
3 --
4 -- Procedure
5 -- Roll_Forward_Historical_Rates
6 -- Purpose
7 -- Roll forward historical rates from prior periods.
8 -- Arguments
9 -- p_dataset_code The dataset code in FEM_BALANCES.
10 -- p_source_system_code GCS source system code.
11 -- p_ledger_id The ledger in FEM_BALANCES.
12 -- p_cal_period_id The current period's cal_period_id.
13 -- p_prev_period_id The previous period's cal_period_id.
14 -- p_entity_id Entity on which the translation is being performed.
15 -- p_hierarchy_id Hierarchy in which the entity resides.
16 -- p_from_ccy From currency code.
17 -- p_to_ccy To currency code.
18 -- p_eq_xlate_mode Equity translation mode (YTD or PTD).
19 -- p_hier_li_id Line Item Id of retained earnings selected for the hierarchy.
20 -- Example
21 -- GCS_TRANS_HRATES_DYNAMIC_PKG.Roll_Forward_Historical_Rates;
22 -- Notes
23 --
24 PROCEDURE Roll_Forward_Historical_Rates
25 (p_hier_dataset_code NUMBER,
26 p_source_system_code NUMBER,
27 p_ledger_id NUMBER,
28 p_cal_period_id NUMBER,
29 p_prev_period_id NUMBER,
30 p_entity_id NUMBER,
31 p_hierarchy_id NUMBER,
32 p_from_ccy VARCHAR2,
33 p_to_ccy VARCHAR2,
34 p_eq_xlate_mode VARCHAR2,
35 p_hier_li_id NUMBER);
36 --
37 -- Procedure
38 -- Trans_HRates_First_Per
39 -- Purpose
40 -- Translate balances for historical rates for a period which is the first period ever
41 -- to be translated.
42 -- Arguments
43 -- p_dataset_code The dataset code of the translation source.
44 -- p_source_system_code The source system code for GCS.
45 -- p_ledger_id The ledger of the translation source.
46 -- p_cal_period_id The period for translation.
47 -- p_entity_id Entity on which translation is being run.
48 -- p_hierarchy_id Hierarchy in which the entity resides.
49 -- p_from_ccy From currency code.
50 -- p_to_ccy To currency code.
51 -- p_eq_xlate_mode Equity translation mode (YTD or PTD).
52 -- p_is_xlate_mode Income statement translation mode (YTD or PTD).
53 -- p_avg_rate Period average rate for this period.
54 -- p_end_rate Period end rate for this period.
55 -- p_group_by_flag Whether a group by must be performed in the SQL
56 -- p_round_factor Minimum accountable unit or precision.
57 -- p_hier_li_id Line Item Id of retained earnings selected for the hierarchy.
58 -- Example
59 -- GCS_TRANS_HRATES_DYNAMIC_PKG.Trans_HRates_First_Per;
60 -- Notes
61 --
62 PROCEDURE Trans_HRates_First_Per
63 (p_hier_dataset_code NUMBER,
64 p_source_system_code NUMBER,
65 p_ledger_id NUMBER,
66 p_cal_period_id NUMBER,
67 p_entity_id NUMBER,
68 p_hierarchy_id NUMBER,
69 p_from_ccy VARCHAR2,
70 p_to_ccy VARCHAR2,
71 p_eq_xlate_mode VARCHAR2,
72 p_is_xlate_mode VARCHAR2,
73 p_avg_rate NUMBER,
74 p_end_rate NUMBER,
75 p_group_by_flag VARCHAR2,
76 p_round_factor NUMBER,
77 p_hier_li_id NUMBER);
78 --
79 -- Procedure
80 -- Trans_HRates_Subseq_Per
81 -- Purpose
82 -- Translate balances for historical rates for a period which is not the first period ever
83 -- to be translated.
84 -- Arguments
85 -- p_dataset_code The dataset for which translation is being run.
86 -- p_cal_period_id The period for translation.
87 -- p_prev_period_id The period just prior to this translation.
88 -- p_entity_id Entity on which translation is being run.
89 -- p_hierarchy_id Hierarchy in which the entity resides.
90 -- p_ledger_id The ledger for the translation.
91 -- p_from_ccy From currency code.
92 -- p_to_ccy To currency code.
93 -- p_eq_xlate_mode Equity translation mode (YTD or PTD).
94 -- p_is_xlate_mode Income statement translation mode (YTD or PTD).
95 -- p_avg_rate Period average rate for this period.
96 -- p_end_rate Period end rate for this period.
97 -- p_group_by_flag Whether a group by must be performed in the SQL
98 -- p_round_factor Minimum accountable unit or precision.
99 -- p_source_system_code Source System Code for GCS.
100 -- p_hier_li_id Line Item Id of retained earnings selected for the hierarchy.
101 -- Example
102 -- GCS_TRANS_HRATES_DYNAMIC_PKG.Trans_Subseq_Period;
103 -- Notes
104 --
105 PROCEDURE Trans_HRates_Subseq_Per
106 (p_hier_dataset_code NUMBER,
107 p_cal_period_id NUMBER,
108 p_prev_period_id NUMBER,
109 p_entity_id NUMBER,
110 p_hierarchy_id NUMBER,
111 p_ledger_id NUMBER,
112 p_from_ccy VARCHAR2,
113 p_to_ccy VARCHAR2,
114 p_eq_xlate_mode VARCHAR2,
115 p_is_xlate_mode VARCHAR2,
116 p_avg_rate NUMBER,
117 p_end_rate NUMBER,
118 p_group_by_flag VARCHAR2,
119 p_round_factor NUMBER,
120 p_source_system_code NUMBER,
121 p_hier_li_id NUMBER);
122
123 END GCS_TRANS_HRATES_DYNAMIC_PKG;
124