1: PACKAGE BODY GCS_TRANSLATION_PKG as
2: /* $Header: gcsxlatb.pls 120.7 2007/06/28 12:27:36 vkosuri noship $ */
3:
4: --
5: -- PRIVATE TYPES
9: --
10: -- PRIVATE GLOBAL VARIABLES
11: --
12: -- The API name
13: g_api CONSTANT VARCHAR2(40) := 'gcs.plsql.GCS_TRANSLATION_PKG';
14:
15: -- The dimension information table
16: g_dims gcs_utility_pkg.t_hash_gcs_dimension_info;
17:
70: -- Arguments
71: -- p_module Name of the module
72: -- p_action_type Entered, Exited Successfully, or Exited with Failure
73: -- Example
74: -- GCS_TRANSLATION_PKG.Module_Log_Write
75: -- Notes
76: --
77: PROCEDURE Module_Log_Write
78: (p_module VARCHAR2,
98: -- p_module Name of the module
99: -- p_level Logging level
100: -- p_text Text to write
101: -- Example
102: -- GCS_TRANSLATION_PKG.Write_To_Log
103: -- Notes
104: --
105: PROCEDURE Write_To_Log
106: (p_module VARCHAR2,
131: -- Set_Globals
132: -- Purpose
133: -- Sets all the global variables necessary for GCS Translation.
134: -- Example
135: -- GCS_TRANSLATION_PKG.Set_Globals;
136: -- Notes
137: --
138: PROCEDURE Set_Globals IS
139: module VARCHAR2(30);
221: -- x_group_by_flag Whether or not a group by is needed in the
222: -- SQL statements for translation.
223: -- x_hier_li_id Retained earnings' line item id.
224: -- Example
225: -- GCS_TRANSLATION_PKG.Get_Setup_Data;
226: -- Notes
227: --
228: PROCEDURE Get_Setup_Data
229: (p_cal_period_id NUMBER,
868: -- p_sec_dim Secondary tracking dimension column.
869: -- p_curr_dim Current dimension column being looked at.
870: -- p_template_id Template value to use.
871: -- Example
872: -- GCS_TRANSLATION_PKG.Create_RE_Sec_Tracking_Text;
873: -- Notes
874: --
875: PROCEDURE Create_RE_Sec_Tracking_Text
876: (p_re_acct IN OUT NOCOPY VARCHAR2,
933: -- p_sec_dim Secondary tracking dimension column.
934: -- p_curr_dim Current dimension column being looked at.
935: -- p_template_id Template value to use.
936: -- Example
937: -- GCS_TRANSLATION_PKG.Create_RE_Rate_Sec_Track_Text
938: -- Notes
939: --
940: PROCEDURE Create_RE_Rate_Sec_Track_Text
941: (p_amt_text IN OUT NOCOPY VARCHAR2,
1005: -- p_relationship_id Relationship on which the translation is being run.
1006: -- p_specific_interco_id Specific intercomany id if applicable.
1007: -- p_re_template Retained earnings template to use.
1008: -- Example
1009: -- GCS_TRANSLATION_PKG.Create_All_RE_Tracking_Text;
1010: -- Notes
1011: --
1012: PROCEDURE Create_All_RE_Tracking_Text
1013: (p_re_acct IN OUT NOCOPY VARCHAR2,
1124: -- p_relationship_id Relationship on which the translation is being run.
1125: -- p_specific_interco_id Specific intercomany id if applicable.
1126: -- p_re_template Retained earnings template to use.
1127: -- Example
1128: -- GCS_TRANSLATION_PKG.Create_All_RE_Rate_Track_Text;
1129: -- Notes
1130: --
1131: PROCEDURE Create_All_RE_Rate_Track_Text
1132: (p_amt_text IN OUT NOCOPY VARCHAR2,
1252: -- p_re_template Retained earnings template.
1253: -- p_source_system_code Source System Code for GCS.
1254: -- p_specific_interco_id Specific intercomany id if applicable.
1255: -- Example
1256: -- GCS_TRANSLATION_PKG.Calculate_RE_Amt;
1257: -- Notes
1258: --
1259: PROCEDURE Calculate_RE_Amt
1260: (p_relationship_id NUMBER,
1674: -- p_source_system_code Source System Code for GCS.
1675: -- p_specific_interco_id Specific intercomany id if applicable.
1676: -- p_entry_id The translation entry created.
1677: -- Example
1678: -- GCS_TRANSLATION_PKG.Calculate_RE_Rate;
1679: -- Notes
1680: --
1681: PROCEDURE Calculate_RE_Rate
1682: (p_relationship_id NUMBER,
2078: -- Purpose
2079: -- Calculate the PTD or YTD balances for YTD or PTD translations,
2080: -- respectively.
2081: -- Example
2082: -- GCS_TRANSLATION_PKG.Calculate_Xlated_PTD_YTD;
2083: -- Notes
2084: --
2085: PROCEDURE Calculate_Xlated_PTD_YTD IS
2086: module VARCHAR2(30);
2549: x_retcode := '2';
2550: module_log_write(module, g_module_failure);
2551: END Translate;
2552:
2553: END GCS_TRANSLATION_PKG;