1 package bsc_dimension_edit as
2 /* $Header: BSCEDITS.pls 120.0 2005/06/01 16:27:47 appldev noship $*/
3
4 procedure security_sync;
5 procedure deleteNormalRow( l_dim_table IN VARCHAR2,
6 l_deleted_code IN NUMBER);
7 procedure deleteMNRow( l_dim_table IN VARCHAR2,
8 l_key_column1 IN VARCHAR2,
9 l_key_column2 IN VARCHAR2,
10 l_rowid IN VARCHAR2);
11 procedure markKPI( l_dim_table IN VARCHAR2);
12
13 procedure saveNormalRowNW(l_dim_table in varchar2, l_fk in varchar2,
14 l_fk_user in varchar2, l_code in number, l_user_code in varchar2,
15 l_name in varchar2, l_fkcode in number, l_fkusercode in varchar2,
16 l_message out nocopy varchar2);
17
18 procedure saveNormalRowNO(l_dim_table in varchar2, l_code in varchar2,
19 l_user_code in varchar2, l_name in varchar2, l_message out nocopy varchar2);
20
21 procedure saveMNRow(l_dim_table in varchar2,
22 l_key_column1 in varchar2, l_key_column2 in varchar2,
23 l_code1 in number, l_code2 in number, l_rowid in varchar2,
24 l_message out nocopy varchar2 );
25
26 procedure updateNormalRowNO(l_dim_table in varchar2, l_code in number,
27 l_user_code in varchar2, l_name in varchar2,l_message out nocopy varchar2);
28 procedure insertNormalRowNO(l_dim_table in varchar2,
29 l_user_code in varchar2, l_name in varchar2, l_message out nocopy varchar2);
30 procedure updateNormalRowNW(l_dim_table in varchar2, l_fk in varchar2,
31 l_fk_user in varchar2, l_code in number, l_user_code in varchar2,
32 l_name in varchar2, l_fkcode in number, l_fkusercode in varchar2,
33 l_message out nocopy varchar2);
34 procedure insertNormalRowNW(l_dim_table in varchar2, l_fk in varchar2,
35 l_fk_user in varchar2, l_user_code in varchar2,
36 l_name in varchar2, l_fkcode in number, l_fkusercode in varchar2,
37 l_message out nocopy varchar2);
38 FUNCTION checkrecord(l_dim_table in varchar2, l_user_code in varchar2,
39 l_name in varchar2) return boolean;
40 FUNCTION checkrecord(l_dim_table in varchar2, l_user_code in varchar2,
41 l_name in varchar2, l_code in number) return boolean;
42 FUNCTION checkMNrecord(l_dim_table in varchar2,
43 l_key_column1 in varchar2, l_key_column2 in varchar2,
44 l_code1 in number, l_code2 in number) return boolean;
45 FUNCTION checkMNrecord(l_dim_table in varchar2,
46 l_key_column1 in varchar2, l_key_column2 in varchar2,
47 l_code1 in number, l_code2 in number,l_rowid in varchar2) return boolean;
48 function removeComma(l_name varchar2) return varchar2;
49 FUNCTION Delete_Codes_CascadeMN(
50 x_dim_table IN VARCHAR2,
51 x_key_column1 IN VARCHAR2,
52 x_key_column2 IN VARCHAR2,
53 x_deleted_codes1 IN number,
54 x_deleted_codes2 IN number
55 ) RETURN BOOLEAN;
56 FUNCTION checkMVnot(l_table in varchar2) return boolean;
57
58 procedure saveNormalRowNWM(l_dim_table in varchar2, l_code in number,
59 l_user_code in varchar2, l_name in varchar2, l_parentcount in number,
60 l_fklist in BSC_EDIT_VLIST,
61 l_fkvaluelist in BSC_EDIT_VLIST, l_fkuservaluelist in BSC_EDIT_VLIST,
62 l_message out nocopy varchar2
63 );
64
65 procedure updateNormalRowNWM(l_dim_table in varchar2, l_code in number,
66 l_user_code in varchar2, l_name in varchar2,l_parentcount in number,
67 l_fklist in BSC_EDIT_VLIST,
68 l_fkvaluelist in BSC_EDIT_VLIST, l_fkuservaluelist in BSC_EDIT_VLIST,
69 l_message out nocopy varchar2
70 );
71
72 procedure insertNormalRowNWM(l_dim_table in varchar2,
73 l_user_code in varchar2, l_name in varchar2, l_parentcount in number,
74 l_fklist in BSC_EDIT_VLIST,
75 l_fkvaluelist in BSC_EDIT_VLIST, l_fkuservaluelist in BSC_EDIT_VLIST,
76 l_message out nocopy varchar2);
77
78 FUNCTION checkUsercodeChange(l_dim_table in varchar2, l_code in number,
79 l_user_code in varchar2) return boolean;
80
81 Function checkChild(l_dim_table in varchar2) return number;
82
83 procedure cascadeUsercodeChange(l_dim_table in varchar2, l_code in number,
84 l_user_code in varchar2);
85
86
87 procedure checkViewExist(p_view_name varchar2,l_message out nocopy varchar2);
88
89 procedure checkMetadata(p_table_name varchar2,p_query varchar2, l_message out nocopy varchar2);
90
91 End bsc_dimension_edit;