[Home] [Help]
PACKAGE: APPS.CSF_ACCESS_HOURS_PVT
Source
1 PACKAGE CSF_ACCESS_HOURS_PVT as
2 /* $Header: CSFVACHS.pls 120.0 2005/05/25 11:15:12 appldev noship $ */
3 -- Start of Comments
4 -- PLEASE NOTE THIS IS A PRIVATE FILE
5 -- Package name : CSF_ACCESS_HOURS_PVT
6 -- Purpose :
7 -- History :
8 -- 17-AUG-2004 : Changed the name of the package from CSF_ACCESS_HOURS_PKG to CSF_ACCESS_HOURS_PVT
9 -- :
10 -- NOTE :
11 -- End of Comments
12 /*TYPE Access_Hours_Rec_Type IS RECORD
13 (
14 ACCESS_HOUR_ID NUMBER := FND_API.G_MISS_NUM,
15 TASK_ID NUMBER := FND_API.G_MISS_NUM,
16 CREATED_BY NUMBER := FND_API.G_MISS_NUM,
17 CREATION_DATE DATE := FND_API.G_MISS_DATE,
18 LAST_UPDATED_BY NUMBER := FND_API.G_MISS_NUM,
19 LAST_UPDATE_DATE DATE := FND_API.G_MISS_DATE,
20 LAST_UPDATE_LOGIN NUMBER := FND_API.G_MISS_NUM,
21 ACCESS_HOUR_REQD VARCHAR2(2) := FND_API.G_MISS_CHAR,
22 AFTER_HOURS_FLAG VARCHAR2(2) := FND_API.G_MISS_CHAR,
23 MONDAY_FIRST_START DATE := FND_API.G_MISS_DATE,
24 MONDAY_FIRST_END DATE := FND_API.G_MISS_DATE,
25 TUESDAY_FIRST_START DATE := FND_API.G_MISS_DATE,
26 TUESDAY_FIRST_END DATE := FND_API.G_MISS_DATE,
27 WEDNESDAY_FIRST_START DATE := FND_API.G_MISS_DATE,
28 WEDNESDAY_FIRST_END DATE := FND_API.G_MISS_DATE,
29 THURSDAY_FIRST_START DATE := FND_API.G_MISS_DATE,
30 THURSDAY_FIRST_END DATE := FND_API.G_MISS_DATE,
31 FRIDAY_FIRST_START DATE := FND_API.G_MISS_DATE,
32 FRIDAY_FIRST_END DATE := FND_API.G_MISS_DATE,
33 SATURDAY_FIRST_START DATE := FND_API.G_MISS_DATE,
34 SATURDAY_FIRST_END DATE := FND_API.G_MISS_DATE,
35 SUNDAY_FIRST_START DATE := FND_API.G_MISS_DATE,
36 SUNDAY_FIRST_END DATE := FND_API.G_MISS_DATE,
37 MONDAY_SECOND_START DATE := FND_API.G_MISS_DATE,
38 MONDAY_SECOND_END DATE := FND_API.G_MISS_DATE,
39 TUESDAY_SECOND_START DATE := FND_API.G_MISS_DATE,
40 TUESDAY_SECOND_END DATE := FND_API.G_MISS_DATE,
41 WEDNESDAY_SECOND_START DATE := FND_API.G_MISS_DATE,
42 WEDNESDAY_SECOND_END DATE := FND_API.G_MISS_DATE,
43 THURSDAY_SECOND_START DATE := FND_API.G_MISS_DATE,
44 THURSDAY_SECOND_END DATE := FND_API.G_MISS_DATE,
45 FRIDAY_SECOND_START DATE := FND_API.G_MISS_DATE,
46 FRIDAY_SECOND_END DATE := FND_API.G_MISS_DATE,
47 SATURDAY_SECOND_START DATE := FND_API.G_MISS_DATE,
48 SATURDAY_SECOND_END DATE := FND_API.G_MISS_DATE,
49 SUNDAY_SECOND_START DATE := FND_API.G_MISS_DATE,
50 SUNDAY_SECOND_END DATE := FND_API.G_MISS_DATE
51 );
52
53 */
54
55 PROCEDURE CREATE_ACCESS_HOURS(
56 p_API_VERSION IN NUMBER,
57 p_INIT_MSG_LIST IN VARCHAR2,
58 x_ACCESS_HOUR_ID OUT NOCOPY NUMBER,
59 p_TASK_ID NUMBER,
60 p_ACCESS_HOUR_REQD VARCHAR2 default NULL,
61 p_AFTER_HOURS_FLAG VARCHAR2 default NULL,
62 p_MONDAY_FIRST_START DATE default TO_DATE(NULL) ,--null,
63 p_MONDAY_FIRST_END DATE default TO_DATE(NULL), --null,
64 p_TUESDAY_FIRST_START DATE default TO_DATE(NULL),
65 p_TUESDAY_FIRST_END DATE default TO_DATE(NULL) ,
66 p_WEDNESDAY_FIRST_START DATE default TO_DATE(NULL),
67 p_WEDNESDAY_FIRST_END DATE default TO_DATE(NULL),
68 p_THURSDAY_FIRST_START DATE default TO_DATE(NULL),
69 p_THURSDAY_FIRST_END DATE default TO_DATE(NULL),
70 p_FRIDAY_FIRST_START DATE default TO_DATE(NULL),
71 p_FRIDAY_FIRST_END DATE default TO_DATE(NULL),
72 p_SATURDAY_FIRST_START DATE default TO_DATE(NULL),
73 p_SATURDAY_FIRST_END DATE default TO_DATE(NULL),
74 p_SUNDAY_FIRST_START DATE default TO_DATE(NULL),
75 p_SUNDAY_FIRST_END DATE default TO_DATE(NULL),
76 p_MONDAY_SECOND_START DATE default TO_DATE(NULL) ,--null,
77 p_MONDAY_SECOND_END DATE default TO_DATE(NULL), --null,
78 p_TUESDAY_SECOND_START DATE default TO_DATE(NULL),
79 p_TUESDAY_SECOND_END DATE default TO_DATE(NULL) ,
80 p_WEDNESDAY_SECOND_START DATE default TO_DATE(NULL),
81 p_WEDNESDAY_SECOND_END DATE default TO_DATE(NULL),
82 p_THURSDAY_SECOND_START DATE default TO_DATE(NULL),
83 p_THURSDAY_SECOND_END DATE default TO_DATE(NULL),
84 p_FRIDAY_SECOND_START DATE default TO_DATE(NULL),
85 p_FRIDAY_SECOND_END DATE default TO_DATE(NULL),
86 p_SATURDAY_SECOND_START DATE default TO_DATE(NULL),
87 p_SATURDAY_SECOND_END DATE default TO_DATE(NULL),
88 p_SUNDAY_SECOND_START DATE default TO_DATE(NULL),
89 p_SUNDAY_SECOND_END DATE default TO_DATE(NULL),
90 p_DESCRIPTION VARCHAR2 DEFAULT null,
91 px_object_version_number in out nocopy number,
92 p_CREATED_BY NUMBER default null,
93 p_CREATION_DATE DATE default null,
94 p_LAST_UPDATED_BY NUMBER default null,
95 p_LAST_UPDATE_DATE DATE default null,
96 p_LAST_UPDATE_LOGIN NUMBER default null,
97 p_commit in varchar2 default null,
98 x_return_status OUT NOCOPY VARCHAR2,
99 x_msg_data OUT NOCOPY VARCHAR2,
100 x_msg_count OUT NOCOPY NUMBER);
101
102
103 PROCEDURE Update_Access_Hours(
104 p_API_VERSION IN NUMBER,
105 p_INIT_MSG_LIST IN VARCHAR2 default NULL,
106 p_ACCESS_HOUR_ID IN NUMBER,
107 p_TASK_ID NUMBER,
108 p_ACCESS_HOUR_REQD VARCHAR2 default null,
109 p_AFTER_HOURS_FLAG VARCHAR2 default null,
110 p_MONDAY_FIRST_START DATE default TO_DATE(NULL), --null,
111 p_MONDAY_FIRST_END DATE default TO_DATE(NULL), --null,
112 p_TUESDAY_FIRST_START DATE default TO_DATE(NULL),
113 p_TUESDAY_FIRST_END DATE default TO_DATE(NULL) ,
114 p_WEDNESDAY_FIRST_START DATE default TO_DATE(NULL),
115 p_WEDNESDAY_FIRST_END DATE default TO_DATE(NULL),
116 p_THURSDAY_FIRST_START DATE default TO_DATE(NULL),
117 p_THURSDAY_FIRST_END DATE default TO_DATE(NULL),
118 p_FRIDAY_FIRST_START DATE default TO_DATE(NULL),
119 p_FRIDAY_FIRST_END DATE default TO_DATE(NULL),
120 p_SATURDAY_FIRST_START DATE default TO_DATE(NULL),
121 p_SATURDAY_FIRST_END DATE default TO_DATE(NULL),
122 p_SUNDAY_FIRST_START DATE default TO_DATE(NULL),
123 p_SUNDAY_FIRST_END DATE default TO_DATE(NULL),
124 p_MONDAY_SECOND_START DATE default TO_DATE(NULL), --null,
125 p_MONDAY_SECOND_END DATE default TO_DATE(NULL), --null,
126 p_TUESDAY_SECOND_START DATE default TO_DATE(NULL),
127 p_TUESDAY_SECOND_END DATE default TO_DATE(NULL) ,
128 p_WEDNESDAY_SECOND_START DATE default TO_DATE(NULL),
129 p_WEDNESDAY_SECOND_END DATE default TO_DATE(NULL),
130 p_THURSDAY_SECOND_START DATE default TO_DATE(NULL),
131 p_THURSDAY_SECOND_END DATE default TO_DATE(NULL),
132 p_FRIDAY_SECOND_START DATE default TO_DATE(NULL),
133 p_FRIDAY_SECOND_END DATE default TO_DATE(NULL),
134 p_SATURDAY_SECOND_START DATE default TO_DATE(NULL),
135 p_SATURDAY_SECOND_END DATE default TO_DATE(NULL),
136 p_SUNDAY_SECOND_START DATE default TO_DATE(NULL),
137 p_SUNDAY_SECOND_END DATE default TO_DATE(NULL),
138 p_DESCRIPTION VARCHAR2 DEFAULT null,
139 px_object_version_number in out nocopy number,
140 p_CREATED_BY NUMBER default null,
141 p_CREATION_DATE DATE default null,
142 p_LAST_UPDATED_BY NUMBER default null,
143 p_LAST_UPDATE_DATE DATE default null,
144 p_LAST_UPDATE_LOGIN NUMBER default null,
145 p_commit in varchar2 default null,
146 x_return_status OUT NOCOPY VARCHAR2,
147 x_msg_data OUT NOCOPY VARCHAR2,
148 x_msg_count OUT NOCOPY NUMBER
149 );
150
151 PROCEDURE lock_Access_Hours(
152 p_API_VERSION IN NUMBER,
153 p_INIT_MSG_LIST IN VARCHAR2 default NULL,
154 p_access_hour_id number,
155 p_object_version_number number,
156 x_return_status OUT NOCOPY VARCHAR2,
157 x_msg_data OUT NOCOPY VARCHAR2,
158 x_msg_count OUT NOCOPY NUMBER
159 );
160 PROCEDURE Delete_Access_Hours(
161 p_API_VERSION IN NUMBER,
162 p_INIT_MSG_LIST IN VARCHAR2 default NULL,
163 p_ACCESS_HOUR_ID NUMBER,
164 p_commit in varchar2 default null,
165 x_return_status OUT NOCOPY VARCHAR2,
166 x_msg_data OUT NOCOPY VARCHAR2,
167 x_msg_count OUT NOCOPY NUMBER
168 );
169
170 END CSF_ACCESS_HOURS_PVT;