PACKAGE: APPS.EDW_VBH_SETUP

Source

1 package edw_vbh_setup as
2 /* $Header: EDWVBHSS.pls 120.1 2006/02/27 03:37:12 rkumar noship $ */
3 procedure LOOKUP_DB_LINK(P_INSTANCE IN VARCHAR2,
4                          p_status out nocopy boolean,
5                          p_errMsg out nocopy varchar2,
6                          p_db_link out nocopy varchar2) ;
7 PROCEDURE INSERT_INTO_EDW_SET_OF_BOOKS(p_status out nocopy boolean,
8                                        p_errMsg out nocopy varchar2) ;
9 PROCEDURE insert_source (p_status out nocopy boolean,p_errMsg out nocopy varchar2) ;
10 PROCEDURE insert_cons_to_source(p_status out nocopy boolean,p_errMsg out nocopy varchar2)  ;
11 PROCEDURE insert_equi_to_source(p_status out nocopy boolean,p_errMsg out nocopy varchar2)  ;
12  procedure lookup_sob_coa_id(
13     p_db_link in varchar2,
14     p_sob_name in varchar2,
15     p_sob_id out nocopy number,
16     p_coa_id out nocopy number,
17     p_description out nocopy varchar2,
18     p_status out nocopy boolean,
19     p_errMsg out nocopy varchar2);
20   procedure lookup_wh_dimension_name(
21                  p_instance in varchar2,
22                  p_segment_name in varchar2,
23                  p_coa_id in number,
24                  p_wh_dimension_name out nocopy varchar2,
25                  p_status out nocopy boolean,
26                  p_errMsg out nocopy varchar2) ;
27   FUNCTION check_db_status_all(x_instance_code OUT nocopy VARCHAR2)
28      return boolean ;
29 procedure check_valid_consolidation
30 (p_instance in varchar2,p_from_ledger_id in number,
31  p_to_ledger_id in number,p_result out nocopy boolean,
32  p_status out nocopy boolean,p_error_mesg out nocopy varchar2);
33 procedure get_consolidation_id
34 (p_instance in varchar2,
35  p_from_ledger_id in number,
36  p_to_ledger_id in number,
37  p_consolidation_name in varchar2,
38  p_consolidation_id out nocopy number,
39  p_status out nocopy boolean,
40  p_error_mesg out nocopy varchar2);
41 
42 procedure check_root_all
43 (p_status out nocopy boolean,
44  p_problem_sob_id out nocopy integer,
45  p_problem_sob_id2 out nocopy integer,
46  p_hierarchy_no out nocopy integer,
47  p_segment_name out nocopy varchar2);
48 
49 procedure check_vbh_root_setup
50 (p_edw_sob_id in integer,
51  p_segment_name in varchar2,
52  p_instance in varchar2,
53  p_hierarchy_no in number,
54  p_status out nocopy boolean,
55  p_problem_sob_id out nocopy integer) ;
56 
57  FUNCTION check_sob_exist(p_status out nocopy	 BOOLEAN,
58 			  p_errMsg out nocopy	 VARCHAR2,
59 			  p_set_of_books_id IN  NUMBER )
60      return boolean ;
61 
62  procedure insert_set_of_books(
63 			p_status out nocopy	 BOOLEAN,
64 			p_errMsg out nocopy	 VARCHAR2,
65 			p_edw_set_of_books_id	 NUMBER,
66 			p_instance		 VARCHAR2,
67 		        p_set_of_books_id	 NUMBER,
68 			p_set_of_books_name	 VARCHAR2,
69 			p_chart_of_accounts_id	 NUMBER,
70 			p_description		 VARCHAR2,
71 			p_creation_date		 DATE,
72 			p_created_by		 NUMBER,
73 			p_last_update_date	 DATE,
74 			p_last_updated_by	 NUMBER ,
75 			p_last_update_login	 NUMBER) ;
76 
77 end;