1 package BSC_KPI_GROUP_PUB as
2 /* $Header: BSCPKGPS.pls 120.0 2005/06/01 16:10:28 appldev noship $ */
3
4 TYPE Bsc_Kpi_Group_Rec is RECORD(
5 Bsc_Csf_Id NUMBER
6 ,Bsc_Group_Height NUMBER
7 ,Bsc_Group_Width NUMBER
8 ,Bsc_Kpi_Group_Help BSC_TAB_IND_GROUPS_TL.HELP%TYPE
9 ,Bsc_Kpi_Group_Id NUMBER
10 ,Bsc_Kpi_Group_Name BSC_TAB_IND_GROUPS_TL.NAME%TYPE
11 ,Bsc_Kpi_Group_Type NUMBER
12 ,Bsc_Language BSC_TAB_IND_GROUPS_TL.LANGUAGE%TYPE
13 ,Bsc_Left_Position_In_Tab NUMBER
14 ,Bsc_Name_Justif_In_Tab NUMBER
15 ,Bsc_Name_Pos_In_Tab NUMBER
16 ,Bsc_Source_Language BSC_TAB_IND_GROUPS_TL.SOURCE_LANG%TYPE
17 ,Bsc_Tab_Id NUMBER
18 ,Bsc_Top_Position_In_Tab NUMBER
19 ,Bsc_Kpi_Group_Short_Name BSC_TAB_IND_GROUPS_B.SHORT_NAME%TYPE
20 );
21
22 TYPE Bsc_Kpi_Group_Tbl IS TABLE OF Bsc_Kpi_Group_Rec
23 INDEX BY BINARY_INTEGER;
24
25 --new procedure. Initializing the kpi group record.
26 procedure Initialize_Kpi_Group_Rec(
27 p_Bsc_Kpi_Group_Rec IN BSC_KPI_GROUP_PUB.Bsc_Kpi_Group_Rec
28 ,x_Bsc_Kpi_Group_Rec OUT NOCOPY BSC_KPI_GROUP_PUB.Bsc_Kpi_Group_Rec
29 ,x_return_status OUT NOCOPY varchar2
30 ,x_msg_count OUT NOCOPY number
31 ,x_msg_data OUT NOCOPY varchar2
32 );
33
34 procedure Create_Kpi_Group(
35 p_commit IN varchar2 := FND_API.G_FALSE
36 ,p_Bsc_Kpi_Group_Rec IN BSC_KPI_GROUP_PUB.Bsc_Kpi_Group_Rec
37 ,x_return_status OUT NOCOPY varchar2
38 ,x_msg_count OUT NOCOPY number
39 ,x_msg_data OUT NOCOPY varchar2
40 );
41
42 procedure Create_Kpi_Group(
43 p_commit IN varchar2 := FND_API.G_FALSE
44 ,p_Bsc_Kpi_Group_Rec IN BSC_KPI_GROUP_PUB.Bsc_Kpi_Group_Rec
45 ,x_Bsc_Kpi_Group_Rec OUT NOCOPY BSC_KPI_GROUP_PUB.Bsc_Kpi_Group_Rec
46 ,x_return_status OUT NOCOPY varchar2
47 ,x_msg_count OUT NOCOPY number
48 ,x_msg_data OUT NOCOPY varchar2
49 );
50
51 procedure Retrieve_Kpi_Group(
52 p_commit IN varchar2 := FND_API.G_FALSE
53 ,p_Bsc_Kpi_Group_Rec IN BSC_KPI_GROUP_PUB.Bsc_Kpi_Group_Rec
54 ,x_Bsc_Kpi_Group_Rec IN OUT NOCOPY BSC_KPI_GROUP_PUB.Bsc_Kpi_Group_Rec
55 ,x_return_status OUT NOCOPY varchar2
56 ,x_msg_count OUT NOCOPY number
57 ,x_msg_data OUT NOCOPY varchar2
58 );
59
60 procedure Update_Kpi_Group(
61 p_commit IN varchar2 := FND_API.G_FALSE
62 ,p_Bsc_Kpi_Group_Rec IN BSC_KPI_GROUP_PUB.Bsc_Kpi_Group_Rec
63 ,x_return_status OUT NOCOPY varchar2
64 ,x_msg_count OUT NOCOPY number
65 ,x_msg_data OUT NOCOPY varchar2
66 );
67
68 procedure Delete_Kpi_Group(
69 p_commit IN varchar2 := FND_API.G_FALSE
70 ,p_Bsc_Kpi_Group_Rec IN BSC_KPI_GROUP_PUB.Bsc_Kpi_Group_Rec
71 ,x_return_status OUT NOCOPY varchar2
72 ,x_msg_count OUT NOCOPY number
73 ,x_msg_data OUT NOCOPY varchar2
74 );
75
76 end BSC_KPI_GROUP_PUB;