1 PACKAGE GCS_TRANS_DYN_BUILD_PKG AS
2 /* $Header: gcsxltds.pls 120.4 2007/06/28 12:30:06 vkosuri noship $ */
3
4 --
5 -- Package
6 -- gcs_trans_dyn_build_pkg
7 -- Purpose
8 -- Dynamically created package procedures for the Translation Program
9 -- History
10 -- 07-JAN-03 M Ward Created
11 --
12
13
14 -- Bugfix 5725759: Made the req variables as global variables.
15 -- Store whether a dimension is used by GCS
16 -- Bugfix 5707630: Add global variables for company_cost_center_org_id and
17 -- intercompany_id as they can also be disabled now.
18 g_cctr_req VARCHAR2(1);
19 g_ic_req VARCHAR2(1);
20 g_fe_req VARCHAR2(1);
21 g_prd_req VARCHAR2(1);
22 g_na_req VARCHAR2(1);
23 g_chl_req VARCHAR2(1);
24 g_prj_req VARCHAR2(1);
25 g_cst_req VARCHAR2(1);
26 g_tsk_req VARCHAR2(1);
27 g_ud1_req VARCHAR2(1);
28 g_ud2_req VARCHAR2(1);
29 g_ud3_req VARCHAR2(1);
30 g_ud4_req VARCHAR2(1);
31 g_ud5_req VARCHAR2(1);
32 g_ud6_req VARCHAR2(1);
33 g_ud7_req VARCHAR2(1);
34 g_ud8_req VARCHAR2(1);
35 g_ud9_req VARCHAR2(1);
36 g_ud10_req VARCHAR2(1);
37
38 -- Bugfix 5707630: Store variables for all dimensions that determine whether it
39 -- is enabled or disbaled for historical rates.
40 g_cctr_hrate_req VARCHAR2(1);
41 g_ic_hrate_req VARCHAR2(1);
42 g_fe_hrate_req VARCHAR2(1);
43 g_prd_hrate_req VARCHAR2(1);
44 g_na_hrate_req VARCHAR2(1);
45 g_chl_hrate_req VARCHAR2(1);
46 g_prj_hrate_req VARCHAR2(1);
47 g_cst_hrate_req VARCHAR2(1);
48 g_tsk_hrate_req VARCHAR2(1);
49 g_ud1_hrate_req VARCHAR2(1);
50 g_ud2_hrate_req VARCHAR2(1);
51 g_ud3_hrate_req VARCHAR2(1);
52 g_ud4_hrate_req VARCHAR2(1);
53 g_ud5_hrate_req VARCHAR2(1);
54 g_ud6_hrate_req VARCHAR2(1);
55 g_ud7_hrate_req VARCHAR2(1);
56 g_ud8_hrate_req VARCHAR2(1);
57 g_ud9_hrate_req VARCHAR2(1);
58 g_ud10_hrate_req VARCHAR2(1);
59
60
61 -- Bugfix 5707630: Made this procedure public as it will be invoked from the
62 -- GCS_TRANS_HRATES_DYN_BUILD_PKG and GCS_TRANS_RE_DYN_BUILD_PKG
63 -- The enabled for historical rates flag and the hrate type is also passed to build_dimension_row.
64 -- Added cttr and ic dimensions as well.
65 --
66 -- Procedure
67 -- Build_Comma_List
68 -- Purpose
69 -- Build a list of the dimensions, delimited by commas. Use null if
70 -- the dimension is not used.
71 -- Arguments
72 -- p_prefix The prefix to put on the dimensions
73 -- p_suffix The suffix to put on the dimensions
74 -- p_null_text The text to be inserted for the null case
75 -- p_first_rownum The first row number to use for ad_ddl
76 -- p_key Whether Historical rates keys or FCH processing keys.
77 -- Example
78 -- GCS_TRANS_DYN_BUILD_PKG.Build_Comma_List
79 -- Notes
80 --
81 FUNCTION Build_Comma_List( p_prefix VARCHAR2,
82 p_suffix VARCHAR2,
83 p_null_text VARCHAR2,
84 p_first_rownum NUMBER,
85 p_key VARCHAR2) RETURN NUMBER;
86
87
88
89 -- Bugfix 5707630: Made this procedure public as it will be invoked from the
90 -- GCS_TRANS_HRATES_DYN_BUILD_PKG and GCS_TRANS_RE_DYN_BUILD_PKG
91 --
92 -- Procedure
93 -- Build_Join_List
94 -- Purpose
95 -- Build a list of the dimensions, delimited by commas. Use null if
96 -- the dimension is not used.
97 -- Arguments
98 -- p_left The text to put before the left dimension
99 -- p_middle The text to put between the two dimensions
100 -- p_right The text to put after the right dimension
101 -- p_first_rownum The first row number to use for ad_ddl
102 -- p_key Whether Historical rates keys or FCH processing keys.
103 -- Example
104 -- GCS_TRANS_DYN_BUILD_PKG.Build_Join_List
105 -- Notes
106 --
107 FUNCTION Build_Join_List( p_left VARCHAR2,
108 p_middle VARCHAR2,
109 p_right VARCHAR2,
110 p_first_rownum NUMBER,
111 p_key VARCHAR2) RETURN NUMBER;
112
113
114 --
115 -- Procedure
116 -- Create_Package
117 -- Purpose
118 -- Create the dynamic portion of the translation program
119 -- Example
120 -- GCS_TRANS_DYN_BUILD_PKG.Create_Package
121 -- Notes
122 --
123 PROCEDURE Create_Package(
124 x_errbuf OUT NOCOPY VARCHAR2,
125 x_retcode OUT NOCOPY VARCHAR2);
126
127
128 -- Bugfix : 5725759
129 -- Procedure
130 -- Initialize_Dimensions
131 -- Purpose
132 -- Initializes the historical rates and fem dimension required variables.
133 -- Example
134 -- GCS_TRANS_DYN_BUILD_PKG.Initialize_Dimensions
135 -- Notes
136 --
137 PROCEDURE Initialize_Dimensions;
138
139
140 END GCS_TRANS_DYN_BUILD_PKG;
[Home] [Help]