[Home] [Help]
PACKAGE: APPS.BSC_PERIODS_PUB
Source
1 PACKAGE BSC_PERIODS_PUB AS
2 /* $Header: BSCPPITS.pls 120.2.12000000.2 2007/01/31 09:35:07 ashankar 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 | BSCPPCTS.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 | 12-AUG-2005 Aditya Rao added API Get_Period_List |
16 REM | 07-FEB-2006 ashankar Fix for the bug4695330 |
17 REM | 17-JAN-2007 ashankar Fix for the bug5654559 |
18 REM +=======================================================================+
19 */
20
21 G_PKG_NAME CONSTANT VARCHAR2(30):= 'BSC_PERIODS_PUB';
22 C_MONTH_WEEK CONSTANT NUMBER := 11;
23 C_MONTH_DAY CONSTANT NUMBER := 12;
24
25
26 TYPE Start_End_Period_Record IS record
27 (
28 Start_Period VARCHAR2(32000)
29 , End_Period VARCHAR2(32000)
30 );
31 TYPE Start_End_Period_Varray IS VARRAY(365) OF Start_End_Period_Record;
32
33 period_Varray Start_End_Period_Varray;
34
35 TYPE Period_Record IS record
36 (
37 Periodicity_Id bsc_sys_periods.periodicity_id%TYPE
38 , Base_Periodicity_Id bsc_sys_periods.periodicity_id%TYPE
39 , Calendar_Id bsc_sys_calendars_b.calendar_id%TYPE
40 , Year bsc_sys_periods.year%TYPE
41 , Periodicity_Type bsc_sys_periodicities.periodicity_type%TYPE
42 , Periods VARCHAR2(32000)
43 , period_Varry Start_End_Period_Varray
44 , No_Of_Periods bsc_sys_periodicities.num_of_periods%TYPE
45 , Created_By bsc_sys_periods.created_by%TYPE
46 , Creation_Date bsc_sys_periods.creation_date%TYPE
47 , Last_Updated_By bsc_sys_periods.last_updated_by%TYPE
48 , Last_Update_Date bsc_sys_periods.last_update_date%TYPE
49 , Last_Update_Login bsc_sys_periods.last_update_login%TYPE
50 , Time_Fk bsc_sys_periods.time_fk%TYPE
51 );
52
53 PROCEDURE Create_Periods
54 ( p_Api_Version IN NUMBER
55 , p_Commit IN VARCHAR2 := FND_API.G_FALSE
56 , p_Period_Record IN BSC_PERIODS_PUB.Period_Record
57 , p_disable_period_val_flag IN VARCHAR2
58 , x_Return_Status OUT NOCOPY VARCHAR2
59 , x_Msg_Count OUT NOCOPY NUMBER
60 , x_Msg_Data OUT NOCOPY VARCHAR2
61 );
62
63 PROCEDURE Update_Periods
64 ( p_Api_Version IN NUMBER
65 , p_Commit IN VARCHAR2
66 , p_Period_Record IN BSC_PERIODS_PUB.Period_Record
67 , x_Structual_Change OUT NOCOPY BOOLEAN
68 , p_disable_period_val_flag IN VARCHAR2
69 , x_Return_Status OUT NOCOPY VARCHAR2
70 , x_Msg_Count OUT NOCOPY NUMBER
71 , x_Msg_Data OUT NOCOPY VARCHAR2
72 );
73
74
75 PROCEDURE Delete_Periods
76 ( p_Api_Version IN NUMBER
77 , p_Commit IN VARCHAR2 := FND_API.G_FALSE
78 , p_Period_Record IN BSC_PERIODS_PUB.Period_Record
79 , x_Return_Status OUT NOCOPY VARCHAR2
80 , x_Msg_Count OUT NOCOPY NUMBER
81 , x_Msg_Data OUT NOCOPY VARCHAR2
82 );
83
84 PROCEDURE Validate_Periods_Action
85 ( p_Api_Version IN NUMBER
86 , p_Commit IN VARCHAR2 := FND_API.G_FALSE
87 , p_Period_Record IN BSC_PERIODS_PUB.Period_Record
88 , p_Action IN VARCHAR2
89 , x_Start_Period IN VARCHAR2
90 , x_End_Period IN VARCHAR2
91 , x_Return_Status OUT NOCOPY VARCHAR2
92 , x_Msg_Count OUT NOCOPY NUMBER
93 , x_Msg_Data OUT NOCOPY VARCHAR2
94 );
95
96 FUNCTION Is_Period_Modified
97 (p_Period_Record IN BSC_PERIODS_PUB.Period_Record
98 )RETURN VARCHAR2;
99
100 PROCEDURE Create_Periodicity_View
101 ( p_Periodicity_Id IN NUMBER
102 , p_Short_Name IN VARCHAR2
103 , p_Calendar_Id IN NUMBER
104 , x_Periodicity_View_Name OUT NOCOPY VARCHAR2
105 , x_Return_Status OUT NOCOPY VARCHAR2
106 , x_Msg_Count OUT NOCOPY NUMBER
107 , x_Msg_Data OUT NOCOPY VARCHAR2
108 );
109
110 PROCEDURE Drop_Periodicity_View
111 ( p_Periodicity_View IN VARCHAR2
112 , x_Return_Status OUT NOCOPY VARCHAR2
113 , x_Msg_Count OUT NOCOPY NUMBER
114 , x_Msg_Data OUT NOCOPY VARCHAR2
115 );
116
117 FUNCTION Get_Period_List (p_Periodicity_Id IN NUMBER) RETURN VARCHAR2;
118
119 PROCEDURE Create_Periodicity_View
120 (
121 p_Periodicity_Id IN NUMBER
122 , p_Short_Name IN VARCHAR2
123 , p_Calendar_Id IN NUMBER
124 , p_periodicity_Type IN BSC_SYS_PERIODICITIES.periodicity_type%TYPE
125 , x_Periodicity_View_Name OUT NOCOPY VARCHAR2
126 , x_Return_Status OUT NOCOPY VARCHAR2
127 , x_Msg_Count OUT NOCOPY NUMBER
128 , x_Msg_Data OUT NOCOPY VARCHAR2
129 );
130 END BSC_PERIODS_PUB;