[Home] [Help]
PACKAGE: APPS.MSD_CS_DFN_UTL
Source
1 package msd_cs_dfn_utl AUTHID CURRENT_USER as
2 /* $Header: msdcsuts.pls 115.11 2003/09/10 18:08:15 dkang ship $ */
3 --
4 Type G_TYP_CS_DEFN_CLMN_MAP is
5 RECORD ( source_view_column_name msd_cs_defn_column_dtls_v.source_view_column_name%TYPE,
6 /* planning_view_column_name msd_cs_defn_column_dtls_v.planning_view_column_name%TYPE, */
7 column_identifier msd_cs_defn_column_dtls_v.column_identifier%TYPE,
8 table_column msd_cs_defn_column_dtls_v.table_column%type,
9 /* alt_key_flag msd_cs_defn_column_dtls_v.alt_key_flag%type,
10 data_type msd_cs_defn_column_dtls_v.data_type%type,
11 */
12 index_cntr number);
13
14 Type G_TYP_CS_DEFN_CLMN_MAP_LIST is TABLE of G_TYP_CS_DEFN_CLMN_MAP;
15
16 Type G_TYP_ARRAY_VARCHAR is VARRAY(255) of msd_cs_data.attribute_1%type;
17
18 Type G_TYP_SOURCE_STREAM is RECORD (
19 pk_id number,
20 instance Varchar2(255),
21 prd_level_id Varchar2(255),
22 prd_sr_level_value_pk Varchar2(255),
23 prd_level_value Varchar2(255),
24 prd_level_value_pk Varchar2(255),
25 geo_level_id Varchar2(255),
26 geo_sr_level_value_pk Varchar2(255),
27 geo_level_value Varchar2(255),
28 geo_level_value_pk Varchar2(255),
29 org_level_id Varchar2(255),
30 org_sr_level_value_pk Varchar2(255),
31 org_level_value Varchar2(255),
32 org_level_value_pk Varchar2(255),
33 prd_parent_level_id Varchar2(255),
34 prd_parent_sr_level_value_pk Varchar2(255),
35 prd_parent_level_value Varchar2(255),
36 prd_parent_level_value_pk Varchar2(255),
37 rep_level_id Varchar2(255),
38 rep_sr_level_value_pk Varchar2(255),
39 rep_level_value Varchar2(255),
40 rep_level_value_pk Varchar2(255),
41 chn_level_id Varchar2(255),
42 chn_sr_level_value_pk Varchar2(255),
43 chn_level_value Varchar2(255),
44 chn_level_value_pk Varchar2(255),
45 ud1_level_id Varchar2(255),
46 ud1_sr_level_value_pk Varchar2(255),
47 ud1_level_value Varchar2(255),
48 ud1_level_value_pk Varchar2(255),
49 ud2_level_id Varchar2(255),
50 ud2_sr_level_value_pk Varchar2(255),
51 ud2_level_value Varchar2(255),
52 ud2_level_value_pk Varchar2(255),
53 tim_level_id Varchar2(255),
54 attribute_35 Varchar2(255),
55 attribute_36 Varchar2(255),
56 attribute_37 Varchar2(255),
57 attribute_38 Varchar2(255),
58 attribute_39 Varchar2(255),
59 attribute_40 Varchar2(255),
60 attribute_41 Varchar2(255),
61 attribute_42 Varchar2(255),
62 attribute_43 Varchar2(255),
63 attribute_44 Varchar2(255),
64 attribute_45 Varchar2(255),
65 attribute_46 Varchar2(255),
66 attribute_47 Varchar2(255),
67 attribute_48 Varchar2(255),
68 attribute_49 Varchar2(255),
69 dcs_level_id Varchar2(255),
70 dcs_sr_level_value_pk Varchar2(255),
71 dcs_level_value Varchar2(255),
72 dcs_level_value_pk Varchar2(255),
73 attribute_54 Varchar2(255),
74 attribute_55 Varchar2(255),
75 attribute_56 Varchar2(255),
76 attribute_57 Varchar2(255),
77 attribute_58 Varchar2(255),
78 attribute_59 Varchar2(255),
79 attribute_60 Varchar2(255),
80 designator Varchar2(255));
81
82 /* Constants */
83 C_PRD_LEVEL_ID number:=1;
84 C_ORG_LEVEL_ID number:=2;
85 C_GEO_LEVEL_ID number:=3;
86 C_REP_LEVEL_ID number:=4;
87 C_CHN_LEVEL_ID number:=5;
88 C_PRD_PARENT_LEVEL_ID number:=6;
89
90
91 Procedure populate_column_defn_array (p_cs_definition_id in number, p_cs_dfn_clmn_map_list out nocopy G_TYP_CS_DEFN_CLMN_MAP_LIST);
92
93 Procedure conv_cs_rec_to_array(
94 p_cs_rec in out nocopy G_TYP_ARRAY_VARCHAR,
95 p_attribute1 in varchar2, p_attribute2 in varchar2,
96 p_attribute3 in varchar2, p_attribute4 in varchar2,
97 p_attribute5 in varchar2, p_attribute6 in varchar2,
98 p_attribute7 in varchar2, p_attribute8 in varchar2,
99 p_attribute9 in varchar2, p_attribute10 in varchar2,
100 p_attribute11 in varchar2, p_attribute12 in varchar2,
101 p_attribute13 in varchar2, p_attribute14 in varchar2,
102 p_attribute15 in varchar2, p_attribute16 in varchar2,
103 p_attribute17 in varchar2, p_attribute18 in varchar2,
104 p_attribute19 in varchar2, p_attribute20 in varchar2,
105 p_attribute21 in varchar2, p_attribute22 in varchar2,
106 p_attribute23 in varchar2, p_attribute24 in varchar2,
107 p_attribute25 in varchar2, p_attribute26 in varchar2,
108 p_attribute27 in varchar2, p_attribute28 in varchar2,
109 p_attribute29 in varchar2, p_attribute30 in varchar2,
110 p_attribute31 in varchar2, p_attribute32 in varchar2,
111 p_attribute33 in varchar2, p_attribute34 in varchar2,
112 p_attribute35 in varchar2, p_attribute36 in varchar2,
113 p_attribute37 in varchar2, p_attribute38 in varchar2,
114 p_attribute39 in varchar2, p_attribute40 in varchar2,
115 p_attribute41 in varchar2, p_attribute42 in varchar2,
116 p_attribute43 in varchar2, p_attribute44 in varchar2,
117 p_attribute45 in varchar2, p_attribute46 in varchar2,
118 p_attribute47 in varchar2, p_attribute48 in varchar2,
119 p_attribute49 in varchar2, p_attribute50 in varchar2,
120 p_attribute51 in varchar2, p_attribute52 in varchar2,
121 p_attribute53 in varchar2, p_attribute54 in varchar2,
122 p_attribute55 in varchar2, p_attribute56 in varchar2,
123 p_attribute57 in varchar2, p_attribute58 in varchar2,
124 p_attribute59 in varchar2, p_attribute60 in varchar2);
125
126 Function get_dim_desc ( p_dim_code in varchar2) return varchar2;
127
128 Function get_level_id ( p_dim_code in varchar2, p_level_name varchar2) return number;
129 Function get_level_name ( p_dim_code in varchar2, p_level_id varchar2) return varchar2;
130 Function get_level_desc ( p_dim_code in varchar2, p_level_id varchar2) return varchar2;
131
132
133 Function get_planning_server_clmn ( p_cs_definition_id in varchar2, p_column_identifier in varchar2) return varchar2;
134 PRAGMA RESTRICT_REFERENCES(get_planning_server_clmn, WNDS);
135
136
137 End;