1 PACKAGE BSC_CALENDAR_WRAPPER AS
2 /* $Header: BSCWCALS.pls 120.0 2005/07/21 23:36:57 appldev noship $ */
3 /*
4 REM +=======================================================================+
5 REM | Copyright (c) 2004 Oracle Corporation, Redwood Shores, CA, USA |
6 REM | All rights reserved. |
7 REM +=======================================================================+
8 REM | FILENAME |
9 REM | BSCWCALS.pls |
10 REM | |
11 REM | DESCRIPTION |
12 REM | Module: This is Wrapper Packages which takes the Values from UI |
13 REM | and populates calendar record with these values |
14 REM | NOTES |
15 REM | 07-JUN-2005 Krishna Created. |
16 REM | 29-JUN-2005 Aditya Rao added parameter p_Base_Per_Ids |
17 REM | 07-JUL-2005 Aditya Rao added Locking APIs |
18 REM +=======================================================================+
19 */
20
21 G_PKG_NAME CONSTANT VARCHAR2(30):= 'BSC_CALENDAR_WRAPPER';
22
23 /***********************************************************************
24 This function is called from JAVA UI Layer for creating calendar
25 which populates the Calendar Record and calls create public API
26 /***********************************************************************/
27
28 PROCEDURE Create_Calendar_UI
29 ( p_Api_Version IN NUMBER
30 , p_Commit IN VARCHAR2
31 , p_Calendar_Id IN NUMBER
32 , p_Edw_Flag IN NUMBER
33 , p_Edw_Calendar_Id IN NUMBER
34 , p_Edw_Calendar_Type_Id IN NUMBER
35 , p_Fiscal_Year IN NUMBER
36 , p_Fiscal_Change IN NUMBER
37 , p_Range_Yr_Mod IN NUMBER
38 , p_Current_Year IN NUMBER
39 , p_Start_Month IN NUMBER
40 , p_Start_Day IN NUMBER
41 , p_Name IN VARCHAR2
42 , p_Help IN VARCHAR2
43 , p_Dim_Short_Name IN VARCHAR2
44 , p_Application_Id IN NUMBER
45 , p_Base_Per_Ids IN VARCHAR2
46 , p_Created_By IN NUMBER
47 , p_Creation_Date IN DATE
48 , p_Last_Updated_By IN NUMBER
49 , p_Last_Update_Date IN DATE
50 , p_Last_Update_Login IN NUMBER
51 , x_Return_Status OUT NOCOPY VARCHAR2
52 , x_Msg_Count OUT NOCOPY NUMBER
53 , x_Msg_Data OUT NOCOPY VARCHAR2
54 );
55
56 /***********************************************************************
57 This function is called from JAVA UI Layer for update calendar
58 which populates the Calendar Record and calls update public API
59 /***********************************************************************/
60
61 PROCEDURE Update_Calendar_UI
62 ( p_Api_Version IN NUMBER
63 , p_Commit IN VARCHAR2
64 , p_Calendar_Id IN NUMBER
65 , p_Edw_Flag IN NUMBER
66 , p_Edw_Calendar_Id IN NUMBER
67 , p_Edw_Calendar_Type_Id IN NUMBER
68 , p_Fiscal_Year IN NUMBER
69 , p_Fiscal_Change IN NUMBER
70 , p_Range_Yr_Mod IN NUMBER
71 , p_Current_Year IN NUMBER
72 , p_Start_Month IN NUMBER
73 , p_Start_Day IN NUMBER
74 , p_Name IN VARCHAR2
75 , p_Help IN VARCHAR2
76 , p_Dim_Short_Name IN VARCHAR2
77 , p_Application_Id IN NUMBER
78 , p_Time_Stamp IN VARCHAR2 := NULL
79 , p_Created_By IN NUMBER
80 , p_Creation_Date IN DATE
81 , p_Last_Updated_By IN NUMBER
82 , p_Last_Update_Date IN DATE
83 , p_Last_Update_Login IN NUMBER
84 , x_Return_Status OUT NOCOPY VARCHAR2
85 , x_Msg_Count OUT NOCOPY NUMBER
86 , x_Msg_Data OUT NOCOPY VARCHAR2
87 );
88
89 /***********************************************************************
90 This function is called from JAVA UI Layer for Delete calendar
91 which populates the Calendar Record and calls Delete public API
92 /***********************************************************************/
93
94 PROCEDURE Delete_Calendar_UI
95 ( p_Api_Version IN NUMBER
96 , p_Commit IN VARCHAR2
97 , p_Calendar_Id IN NUMBER
98 , p_Time_Stamp IN VARCHAR2 := NULL
99 , x_Return_Status OUT NOCOPY VARCHAR2
100 , x_Msg_Count OUT NOCOPY NUMBER
101 , x_Msg_Data OUT NOCOPY VARCHAR2
102 );
103 /************************************************************************
104 This function is used to check whether DBI Calendar is setup by BIA
105 ************************************************************************/
106 FUNCTION Is_Dbi_Calendar_Enabled RETURN VARCHAR2;
107
108 END BSC_CALENDAR_WRAPPER;