[Home] [Help]
PACKAGE: APPS.FEM_WEBADI_HIER_UTILS_PVT
Source
1 PACKAGE FEM_WEBADI_HIER_UTILS_PVT AS
2 /* $Header: FEMVADIHIERUTILS.pls 120.0.12000000.2 2007/08/08 05:49:12 lkiran ship $ */
3 --
4 --------------------------
5 -- Declare Object types --
6 --------------------------
7 -- Table types
8 TYPE g_number_tbl_type IS TABLE OF NUMBER INDEX BY PLS_INTEGER ;
9 TYPE g_char_tbl_type IS TABLE OF VARCHAR2(30) INDEX BY PLS_INTEGER ;
10 TYPE g_date_tbl_type IS TABLE OF DATE INDEX BY PLS_INTEGER ;
11 --
12 -- Define a record to hold Dimension Metadata global variables.
13 -- Bug#5959140: Match variable size to db col size.
14 TYPE g_global_val_rec_type
15 IS
16 RECORD
17 ( dimension_id NUMBER
18 , dimension_varchar_label VARCHAR2(30)
19 , intf_member_b_table_name VARCHAR2(30)
20 , intf_member_tl_table_name VARCHAR2(30)
21 , intf_attribute_table_name VARCHAR2(30)
22 , member_b_table_name VARCHAR2(30)
23 , member_display_code_col VARCHAR2(30)
24 , member_display_code VARCHAR2(150)
25 , calendar_display_code VARCHAR2(150)
26 , member_name_col VARCHAR2(30)
27 , member_name VARCHAR2(150)
28 , member_description VARCHAR2(255)
29 , hierarchy_intf_table_name VARCHAR2(30)
30 , dimension_type_code VARCHAR2(30)
31 , group_use_code VARCHAR2(30)
32 , value_set_required_flag VARCHAR2(1)
33 , value_set_display_code VARCHAR2(150)
34 , dim_grp_disp_code VARCHAR2(150)
35 , ledger_id NUMBER
36 ) ;
37 --
38 TYPE g_global_val_tbl_type
39 IS
40 TABLE OF g_global_val_rec_type
41 INDEX BY PLS_INTEGER ;
42 --
43 g_global_val_tbl g_global_val_tbl_type ;
44 --
45 ------------------------------
46 -- Declare Global variables --
47 ------------------------------
48 G_LIMIT_BULK_NUMROWS CONSTANT NUMBER := 100 ; -- Limit to hold number of rows
49 --
50 -- Declare variables to hold Map table column values.
51 g_dim_varchar_label_tbl g_char_tbl_type ;
52 g_interface_col_name_tbl g_char_tbl_type ;
53 g_attribute_name_tbl g_char_tbl_type ;
54 g_attribute_data_type_tbl g_char_tbl_type ;
55 --
56 ------------------------
57 -- Declare Procedures --
58 ------------------------
59
60 /*===========================================================================+
61 Procedure name : Upload_Hierarchy_Interface
62 Parameters :
63 IN : p_folder_name VARCHAR2
64 p_dimension_varchar_label VARCHAR2
65 p_hierarchy_object_name VARCHAR2
66 p_hierarchy_obj_def_disp_name VARCHAR2
67 p_ledger_id NUMBER
68 p_calendar_display_code VARCHAR2
69 p_group_seq_enforced_code VARCHAR2
70 p_effective_start_date DATE
71 p_effective_end_date DATE
72 p_hierarchy_usage_code VARCHAR2
73 p_hierarchy_type_code VARCHAR2
74 p_multi_top_flag VARCHAR2
75 p_multi_value_set_flag VARCHAR2
76 p_parent_display_code VARCHAR2
77 p_child_display_code VARCHAR2
78 OUT :
79
80 Description : This procedure populates Hierarchy details
81
82 Modification History :
83 Date Name Desc
84 ---------- --------- -------------------------------------------------------
85 09/22/2005 SHTRIPAT Created.
86 ---------- --------- -------------------------------------------------------
87 +===========================================================================*/
88
89 PROCEDURE Upload_Hierarchy_Interface
90 ( p_folder_name IN VARCHAR2
91 , p_dimension_varchar_label IN VARCHAR2
92 , p_hierarchy_object_name IN VARCHAR2
93 , p_hierarchy_obj_def_disp_name IN VARCHAR2
94 , p_ledger_id IN NUMBER
95 , p_calendar_display_code IN VARCHAR2
96 , p_group_seq_enforced_code IN VARCHAR2
97 , p_effective_start_date IN DATE
98 , p_effective_end_date IN DATE
99 , p_hierarchy_usage_code IN VARCHAR2
100 , p_hierarchy_type_code IN VARCHAR2
101 , p_multi_top_flag IN VARCHAR2
102 , p_multi_value_set_flag IN VARCHAR2
103 , p_parent_display_code IN VARCHAR2
104 , p_child_display_code IN VARCHAR2
105 ) ;
106
107 END FEM_WEBADI_HIER_UTILS_PVT ;