[Home] [Help]
PACKAGE: APPS.BSC_CALENDAR_PUB
Source
1 PACKAGE BSC_CALENDAR_PUB AS
2 /* $Header: BSCPCALS.pls 120.3 2007/12/18 06:48:03 lbodired ship $ */
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 | BSCPCALS.pls |
10 REM | |
11 REM | DESCRIPTION |
12 REM | Module: Public package for populating the calendar tables |
13 REM | NOTES |
14 REM | 07-JUN-2005 Krishna Created. |
15 REM | 06-JUL-07 psomesul Bug#6168487 - CHANGING CALENDAR DEF WHICH IS IN PRODUCTION IS NOT TRIGGERING TO USER |
16 REM +=======================================================================+
17 */
18
19 G_PKG_NAME CONSTANT VARCHAR2(30):= 'BSC_CALENDAR_PUB';
20
21 TYPE varchar2_tabletype IS TABLE OF VARCHAR2(32000) INDEX BY binary_integer;
22
23 TYPE Calendar_Type_Record IS record
24 (
25 Calendar_Id bsc_sys_calendars_b.calendar_id%TYPE
26 , Edw_Flag bsc_sys_calendars_b.edw_flag%TYPE
27 , Edw_Calendar_Id bsc_sys_calendars_b.edw_calendar_id%TYPE
28 , Edw_Calendar_Type_Id bsc_sys_calendars_b.edw_calendar_type_id%TYPE
29 , Fiscal_Year bsc_sys_calendars_b.fiscal_year%TYPE
30 , Fiscal_Change bsc_sys_calendars_b.fiscal_change%TYPE
31 , Range_Yr_Mod bsc_sys_calendars_b.range_yr_mod%TYPE
32 , Current_Year bsc_sys_calendars_b.current_year%TYPE
33 , Start_Month bsc_sys_calendars_b.start_month%TYPE
34 , Start_Day bsc_sys_calendars_b.start_day%TYPE
35 , Created_By bsc_sys_calendars_b.created_by%TYPE
36 , Creation_Date bsc_sys_calendars_b.creation_date%TYPE
37 , Last_Updated_By bsc_sys_calendars_b.last_updated_by%TYPE
38 , Last_Update_Date bsc_sys_calendars_b.last_update_date%TYPE
39 , Last_Update_Login bsc_sys_calendars_b.last_update_login%TYPE
40 , Name bsc_sys_calendars_tl.name%TYPE
41 , Help bsc_sys_calendars_tl.help%TYPE
42 , Dim_Short_Name bsc_sys_dim_groups_tl.short_name%TYPE
43 , Application_Id bis_dimensions.application_id%TYPE
44 , Language bsc_sys_calendars_tl.language%TYPE
45 , Source_Lang bsc_sys_calendars_tl.source_lang%TYPE
46 , Base_Periodicities_Ids VARCHAR2(32000)
47 );
48
49 PROCEDURE Create_Calendar
50 ( p_Api_Version IN NUMBER
51 , p_Commit IN VARCHAR2
52 , p_Calendar_Record IN BSC_CALENDAR_PUB.Calendar_Type_Record
53 , x_Return_Status OUT NOCOPY VARCHAR2
54 , x_Msg_Count OUT NOCOPY NUMBER
55 , x_Msg_Data OUT NOCOPY VARCHAR2
56 );
57
58 PROCEDURE Update_Calendar
59 ( p_Api_Version IN NUMBER
60 , p_Commit IN VARCHAR2
61 , p_Calendar_Record IN BSC_CALENDAR_PUB.Calendar_Type_Record
62 , x_Return_Status OUT NOCOPY VARCHAR2
63 , x_Msg_Count OUT NOCOPY NUMBER
64 , x_Msg_Data OUT NOCOPY VARCHAR2
65 );
66
67 PROCEDURE Delete_Calendar
68 ( p_Api_Version IN NUMBER
69 , p_Commit IN VARCHAR2
70 , p_Calendar_Record IN BSC_CALENDAR_PUB.Calendar_Type_Record
71 , x_Return_Status OUT NOCOPY VARCHAR2
72 , x_Msg_Count OUT NOCOPY NUMBER
73 , x_Msg_Data OUT NOCOPY VARCHAR2
74 );
75
76 PROCEDURE Validate_Calendar_Action
77 ( p_Api_Version IN NUMBER
78 , p_Commit IN VARCHAR2
79 , p_Calendar_Record IN BSC_CALENDAR_PUB.Calendar_Type_Record
80 , p_Action IN VARCHAR2
81 , x_Return_Status OUT NOCOPY VARCHAR2
82 , x_Msg_Count OUT NOCOPY NUMBER
83 , x_Msg_Data OUT NOCOPY VARCHAR2
84 );
85
86 PROCEDURE Retrieve_And_Populate_Cal_Rec
87 ( p_Api_Version IN NUMBER
88 , p_Commit IN VARCHAR2
89 , p_Calendar_Record IN BSC_CALENDAR_PUB.Calendar_Type_Record
90 , x_Calendar_Record OUT NOCOPY BSC_CALENDAR_PUB.Calendar_Type_Record
91 , x_Return_Status OUT NOCOPY VARCHAR2
92 , x_Msg_Count OUT NOCOPY NUMBER
93 , x_Msg_Data OUT NOCOPY VARCHAR2
94 );
95
96 PROCEDURE Fill_Default_Values_Create_Cal
97 ( p_Api_Version IN NUMBER
98 , p_Commit IN VARCHAR2
99 , p_Calendar_Record IN BSC_CALENDAR_PUB.Calendar_Type_Record
100 , x_Calendar_Record OUT NOCOPY BSC_CALENDAR_PUB.Calendar_Type_Record
101 , x_Return_Status OUT NOCOPY VARCHAR2
102 , x_Msg_Count OUT NOCOPY NUMBER
103 , x_Msg_Data OUT NOCOPY VARCHAR2
104 );
105
106 PROCEDURE Create_Calendar_Post_Action
107 ( p_Api_Version IN NUMBER
108 , p_Commit IN VARCHAR2
109 , p_Calendar_Record IN BSC_CALENDAR_PUB.Calendar_Type_Record
110 , x_Return_Status OUT NOCOPY VARCHAR2
111 , x_Msg_Count OUT NOCOPY NUMBER
112 , x_Msg_Data OUT NOCOPY VARCHAR2
113 );
114
115 PROCEDURE Update_Calendar_Post_Action
116 ( p_Api_Version IN NUMBER
117 , p_Commit IN VARCHAR2
118 , p_Calendar_Record IN BSC_CALENDAR_PUB.Calendar_Type_Record
119 , x_Return_Status OUT NOCOPY VARCHAR2
120 , x_Msg_Count OUT NOCOPY NUMBER
121 , x_Msg_Data OUT NOCOPY VARCHAR2
122 );
123 PROCEDURE Flag_Changes_For_Objectives
124 ( p_Api_Version IN NUMBER
125 , p_Commit IN VARCHAR2
126 , p_Calendar_Id IN NUMBER
127 , x_Return_Status OUT NOCOPY VARCHAR2
128 , x_Msg_Count OUT NOCOPY NUMBER
129 , x_Msg_Data OUT NOCOPY VARCHAR2
130 );
131
132 PROCEDURE Create_Periodicities_Calendar
133 ( p_Api_Version IN NUMBER
134 , p_Commit IN VARCHAR2
135 , p_Calendar_Record IN BSC_CALENDAR_PUB.Calendar_Type_Record
136 , x_Return_Status OUT NOCOPY VARCHAR2
137 , x_Msg_Count OUT NOCOPY NUMBER
138 , x_Msg_Data OUT NOCOPY VARCHAR2
139 );
140
141 FUNCTION get_production_obj_having_cal(
142 p_cal_id IN bsc_kpis_b.calendar_id%TYPE
143 )
144 RETURN VARCHAR2;
145
146
147 PROCEDURE comp_leapyear_prioryear(
148 p_calid IN NUMBER,
149 p_cyear IN NUMBER,
150 p_pyear IN NUMBER,
151 x_result OUT nocopy NUMBER
152 );
153
154 END BSC_CALENDAR_PUB;