[Home] [Help]
PACKAGE: APPS.BSC_COPY_INDICATOR_PUB
Source
1 PACKAGE BSC_COPY_INDICATOR_PUB AS
2 /* $Header: BSCPCINS.pls 120.2.12000000.1 2007/07/17 07:43:43 appldev noship $ */
3 /*=======================================================================+
4 | Copyright (c) 1997 Oracle Corporation Redwood Shores, California, USA|
5 | All rights reserved. |
6 +=======================================================================+
7 | FILENAME |
8 | BSCPCINS.pls |
9 | |
10 | Creation Date: |
11 | March 21, 2007 |
12 | |
13 | Creator: |
14 | Ajitha Koduri |
15 | |
16 | Description: |
17 | Public version. |
18 | This package contains all the APIs related to copy and move |
19 | indicators |
20 | |
21 | History: |
22 | 21-MAR-2007 akoduri Copy Indicator Enh#5943238 |
23 | 06-JUN-2007 akoduri Bug 5958688 Enable YTD as default at KPI |
24 *=======================================================================*/
25
26
27 INDICATOR_BESIDE_NAME CONSTANT NUMBER := 0;
28 INDICATOR_BELOW_NAME CONSTANT NUMBER := 1;
29
30 PROCEDURE Move_Indicator_UI_Wrap (
31 p_commit IN VARCHAR2 := FND_API.G_FALSE
32 , p_Indicator IN NUMBER
33 , p_New_Indicator_Group IN NUMBER
34 , p_New_Position IN NUMBER
35 , p_Time_Stamp IN VARCHAR2 := NULL
36 , x_return_status OUT NOCOPY VARCHAR2
37 , x_msg_count OUT NOCOPY NUMBER
38 , x_msg_data OUT NOCOPY VARCHAR2
39 );
40
41 PROCEDURE CopyNew_Indicator_UI_Wrap (
42 p_commit IN VARCHAR2 := FND_API.G_FALSE
43 , p_DbLink_Name IN VARCHAR2
44 , p_Name IN VARCHAR2 := NULL
45 , p_Description IN VARCHAR2 := NULL
46 , p_Source_Indicator IN NUMBER
47 , p_Target_Group IN NUMBER
48 , p_New_Position IN NUMBER
49 , p_Old_Dim_Levels IN FND_TABLE_OF_NUMBER
50 , p_New_Dim_Levels IN FND_TABLE_OF_NUMBER
51 , p_Old_Dim_Groups IN FND_TABLE_OF_NUMBER
52 , p_New_Dim_Groups IN FND_TABLE_OF_NUMBER
53 , p_Old_DataSet_Map IN FND_TABLE_OF_NUMBER
54 , p_New_DataSet_Map IN FND_TABLE_OF_NUMBER
55 , p_Target_Calendar IN NUMBER
56 , p_Old_Periodicities IN FND_TABLE_OF_NUMBER
57 , p_New_Periodicities IN FND_TABLE_OF_NUMBER
58 , p_Time_Stamp IN VARCHAR2 := NULL
59 , x_return_status OUT NOCOPY VARCHAR2
60 , x_msg_count OUT NOCOPY NUMBER
61 , x_msg_data OUT NOCOPY VARCHAR2
62 );
63
64 PROCEDURE Move_Indicator (
65 p_commit IN VARCHAR2 := FND_API.G_FALSE
66 , p_Indicator IN NUMBER
67 , p_New_Indicator_Group IN NUMBER
68 , p_Assign_Group_To_Tab IN VARCHAR2 := FND_API.G_TRUE
69 , x_return_status OUT NOCOPY VARCHAR2
70 , x_msg_count OUT NOCOPY NUMBER
71 , x_msg_data OUT NOCOPY VARCHAR2
72 );
73
74 PROCEDURE Create_Kpi_Access_Wrap(
75 p_commit IN VARCHAR2 := FND_API.G_FALSE
76 ,p_Comma_Sep_Resposibility_Key IN VARCHAR2
77 ,p_Indicator_Id IN NUMBER
78 ,x_return_status OUT NOCOPY VARCHAR2
79 ,x_msg_count OUT NOCOPY NUMBER
80 ,x_msg_data OUT NOCOPY VARCHAR2
81 );
82
83 FUNCTION Is_Numeric_Field_Equal(
84 p_Old_Value NUMBER
85 ,p_New_Value NUMBER
86 ) RETURN BOOLEAN;
87
88 FUNCTION Is_Varchar2_Field_Equal(
89 p_Old_Value VARCHAR2
90 ,p_New_Value VARCHAR2
91 ) RETURN BOOLEAN;
92
93 END BSC_COPY_INDICATOR_PUB;