DBA Data[Home] [Help]

PACKAGE: APPS.EDW_GL_ACCT_M_T

Source


1 PACKAGE EDW_GL_ACCT_M_T AS
2 /* $Header: EDWVBHCS.pls 120.0 2005/05/31 18:21:31 appldev noship $ */
3 
4 g_status boolean;
5 g_conc_program_id number:=0;
6 g_conc_program_name varchar2(200);
7 g_execute_flag boolean;
8 G_COMPLETION_STATUS integer;
9 g_dimension_name VARCHAR2(255);
10 g_vbh_temp_table_name  VARCHAR2(30);
11 g_global_temp_table varchar2(30);
12 
13 type t_acct_type_root_rec is record (
14 name  edw_vbh_temp1.parent%type,
15 type  edw_segment_classes.type%type);
16 
17 type t_acct_type_root_table is table of t_acct_type_root_rec
18 index by binary_integer;
19 
20 g_acct_type_root1 t_acct_type_root_table;
21 g_acct_type_root2 t_acct_type_root_table;
22 
23 
24 
25 Procedure Collect(Errbuf         out NOCOPY Varchar2,
26                   Retcode        out NOCOPY Varchar2,
27                   p_dimension_name   in Varchar2);
28 
29 -- added for bug 4124723
30 Procedure create_dim_levels_mv (p_dim_no IN varchar2);
31 
32 End EDW_GL_ACCT_M_T;