[Home] [Help]
PACKAGE: APPS.CSF_ACCESS_HOURS_PVT
Source
1 PACKAGE CSF_ACCESS_HOURS_PVT AUTHID CURRENT_USER as
2 /* $Header: CSFVACHS.pls 120.2 2011/04/26 11:03:00 vakulkar ship $ */
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 p_data_chg_frm_ui IN VARCHAR2 DEFAULT null);
102
103
104 PROCEDURE Update_Access_Hours(
105 p_API_VERSION IN NUMBER,
106 p_INIT_MSG_LIST IN VARCHAR2 DEFAULT NULL,
107 p_ACCESS_HOUR_ID IN NUMBER,
108 p_TASK_ID NUMBER,
109 p_ACCESS_HOUR_REQD VARCHAR2 DEFAULT null,
110 p_AFTER_HOURS_FLAG VARCHAR2 DEFAULT null,
111 p_MONDAY_FIRST_START DATE DEFAULT TO_DATE(NULL), --null,
112 p_MONDAY_FIRST_END DATE DEFAULT TO_DATE(NULL), --null,
113 p_TUESDAY_FIRST_START DATE DEFAULT TO_DATE(NULL),
114 p_TUESDAY_FIRST_END DATE DEFAULT TO_DATE(NULL) ,
115 p_WEDNESDAY_FIRST_START DATE DEFAULT TO_DATE(NULL),
116 p_WEDNESDAY_FIRST_END DATE DEFAULT TO_DATE(NULL),
117 p_THURSDAY_FIRST_START DATE DEFAULT TO_DATE(NULL),
118 p_THURSDAY_FIRST_END DATE DEFAULT TO_DATE(NULL),
119 p_FRIDAY_FIRST_START DATE DEFAULT TO_DATE(NULL),
120 p_FRIDAY_FIRST_END DATE DEFAULT TO_DATE(NULL),
121 p_SATURDAY_FIRST_START DATE DEFAULT TO_DATE(NULL),
122 p_SATURDAY_FIRST_END DATE DEFAULT TO_DATE(NULL),
123 p_SUNDAY_FIRST_START DATE DEFAULT TO_DATE(NULL),
124 p_SUNDAY_FIRST_END DATE DEFAULT TO_DATE(NULL),
125 p_MONDAY_SECOND_START DATE DEFAULT TO_DATE(NULL), --null,
126 p_MONDAY_SECOND_END DATE DEFAULT TO_DATE(NULL), --null,
127 p_TUESDAY_SECOND_START DATE DEFAULT TO_DATE(NULL),
128 p_TUESDAY_SECOND_END DATE DEFAULT TO_DATE(NULL) ,
129 p_WEDNESDAY_SECOND_START DATE DEFAULT TO_DATE(NULL),
130 p_WEDNESDAY_SECOND_END DATE DEFAULT TO_DATE(NULL),
131 p_THURSDAY_SECOND_START DATE DEFAULT TO_DATE(NULL),
132 p_THURSDAY_SECOND_END DATE DEFAULT TO_DATE(NULL),
133 p_FRIDAY_SECOND_START DATE DEFAULT TO_DATE(NULL),
134 p_FRIDAY_SECOND_END DATE DEFAULT TO_DATE(NULL),
135 p_SATURDAY_SECOND_START DATE DEFAULT TO_DATE(NULL),
136 p_SATURDAY_SECOND_END DATE DEFAULT TO_DATE(NULL),
137 p_SUNDAY_SECOND_START DATE DEFAULT TO_DATE(NULL),
138 p_SUNDAY_SECOND_END DATE DEFAULT TO_DATE(NULL),
139 p_DESCRIPTION VARCHAR2 DEFAULT null,
140 px_object_version_number in out nocopy NUMBER,
141 p_CREATED_BY NUMBER DEFAULT null,
142 p_CREATION_DATE DATE DEFAULT null,
143 p_LAST_UPDATED_BY NUMBER DEFAULT null,
144 p_LAST_UPDATE_DATE DATE DEFAULT null,
145 p_LAST_UPDATE_LOGIN NUMBER DEFAULT null,
146 p_commit in VARCHAR2 DEFAULT null,
147 x_return_status OUT NOCOPY VARCHAR2,
148 x_msg_data OUT NOCOPY VARCHAR2,
149 x_msg_count OUT NOCOPY NUMBER,
150 p_data_chg_frm_ui IN VARCHAR2 DEFAULT null);
151
152
153 PROCEDURE lock_Access_Hours(
154 p_API_VERSION IN NUMBER,
155 p_INIT_MSG_LIST IN VARCHAR2 default NULL,
156 p_access_hour_id NUMBER,
157 p_object_version_number NUMBER,
158 x_return_status OUT NOCOPY VARCHAR2,
159 x_msg_data OUT NOCOPY VARCHAR2,
160 x_msg_count OUT NOCOPY NUMBER
161 );
162 PROCEDURE Delete_Access_Hours(
163 p_API_VERSION IN NUMBER,
164 p_INIT_MSG_LIST IN VARCHAR2 default NULL,
165 p_ACCESS_HOUR_ID NUMBER,
166 p_commit in VARCHAR2 default null,
167 x_return_status OUT NOCOPY VARCHAR2,
168 x_msg_data OUT NOCOPY VARCHAR2,
169 x_msg_count OUT NOCOPY NUMBER
170 );
171
172 END CSF_ACCESS_HOURS_PVT;