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