1 package JTF_CAL_SHIFT_CUHK AUTHID CURRENT_USER as
2 /* $Header: jtfcluhs.pls 115.2 2002/04/09 10:52:04 pkm ship $ */
3
4 PROCEDURE update_shift_pre
5 (X_ERROR out VARCHAR2,
6 X_SHIFT_ID in NUMBER DEFAULT fnd_api.g_miss_num,
7 X_OBJECT_VERSION_NUMBER in OUT NUMBER,
8 X_START_DATE_ACTIVE in DATE DEFAULT fnd_api.g_miss_date,
9 X_END_DATE_ACTIVE in DATE DEFAULT fnd_api.g_miss_date,
10 X_ATTRIBUTE1 in VARCHAR2 DEFAULT fnd_api.g_miss_char,
11 X_ATTRIBUTE2 in VARCHAR2 DEFAULT fnd_api.g_miss_char,
12 X_ATTRIBUTE3 in VARCHAR2 DEFAULT fnd_api.g_miss_char,
13 X_ATTRIBUTE4 in VARCHAR2 DEFAULT fnd_api.g_miss_char,
14 X_ATTRIBUTE5 in VARCHAR2 DEFAULT fnd_api.g_miss_char,
15 X_ATTRIBUTE6 in VARCHAR2 DEFAULT fnd_api.g_miss_char,
16 X_ATTRIBUTE7 in VARCHAR2 DEFAULT fnd_api.g_miss_char,
17 X_ATTRIBUTE8 in VARCHAR2 DEFAULT fnd_api.g_miss_char,
18 X_ATTRIBUTE9 in VARCHAR2 DEFAULT fnd_api.g_miss_char,
19 X_ATTRIBUTE10 in VARCHAR2 DEFAULT fnd_api.g_miss_char,
20 X_ATTRIBUTE11 in VARCHAR2 DEFAULT fnd_api.g_miss_char,
21 X_ATTRIBUTE12 in VARCHAR2 DEFAULT fnd_api.g_miss_char,
22 X_ATTRIBUTE13 in VARCHAR2 DEFAULT fnd_api.g_miss_char,
23 X_ATTRIBUTE14 in VARCHAR2 DEFAULT fnd_api.g_miss_char,
24 X_ATTRIBUTE15 in VARCHAR2 DEFAULT fnd_api.g_miss_char,
25 X_ATTRIBUTE_CATEGORY in VARCHAR2 DEFAULT fnd_api.g_miss_char,
26 X_SHIFT_NAME in VARCHAR2 DEFAULT fnd_api.g_miss_char,
27 X_DESCRIPTION in VARCHAR2 DEFAULT fnd_api.g_miss_char,
28 X_LAST_UPDATE_DATE in DATE DEFAULT fnd_api.g_miss_date,
29 X_LAST_UPDATED_BY in NUMBER DEFAULT fnd_api.g_miss_num,
30 X_LAST_UPDATE_LOGIN in NUMBER DEFAULT fnd_api.g_miss_num
31 );
32
33 PROCEDURE insert_shift_pre (
34 X_ERROR out VARCHAR2,
35 X_ROWID in out VARCHAR2,
36 X_SHIFT_ID in out NUMBER,
37 X_OBJECT_VERSION_NUMBER in NUMBER DEFAULT fnd_api.g_miss_num,
38 X_START_DATE_ACTIVE in DATE DEFAULT fnd_api.g_miss_date,
39 X_END_DATE_ACTIVE in DATE DEFAULT fnd_api.g_miss_date,
40 X_ATTRIBUTE1 in VARCHAR2 DEFAULT fnd_api.g_miss_char,
41 X_ATTRIBUTE2 in VARCHAR2 DEFAULT fnd_api.g_miss_char,
42 X_ATTRIBUTE3 in VARCHAR2 DEFAULT fnd_api.g_miss_char,
43 X_ATTRIBUTE4 in VARCHAR2 DEFAULT fnd_api.g_miss_char,
44 X_ATTRIBUTE5 in VARCHAR2 DEFAULT fnd_api.g_miss_char,
45 X_ATTRIBUTE6 in VARCHAR2 DEFAULT fnd_api.g_miss_char,
46 X_ATTRIBUTE7 in VARCHAR2 DEFAULT fnd_api.g_miss_char,
47 X_ATTRIBUTE8 in VARCHAR2 DEFAULT fnd_api.g_miss_char,
48 X_ATTRIBUTE9 in VARCHAR2 DEFAULT fnd_api.g_miss_char,
49 X_ATTRIBUTE10 in VARCHAR2 DEFAULT fnd_api.g_miss_char,
50 X_ATTRIBUTE11 in VARCHAR2 DEFAULT fnd_api.g_miss_char,
51 X_ATTRIBUTE12 in VARCHAR2 DEFAULT fnd_api.g_miss_char,
52 X_ATTRIBUTE13 in VARCHAR2 DEFAULT fnd_api.g_miss_char,
53 X_ATTRIBUTE14 in VARCHAR2 DEFAULT fnd_api.g_miss_char,
54 X_ATTRIBUTE15 in VARCHAR2 DEFAULT fnd_api.g_miss_char,
55 X_ATTRIBUTE_CATEGORY in VARCHAR2 DEFAULT fnd_api.g_miss_char,
56 X_SHIFT_NAME in VARCHAR2 DEFAULT fnd_api.g_miss_char,
57 X_DESCRIPTION in VARCHAR2 DEFAULT fnd_api.g_miss_char,
58 X_CREATION_DATE in DATE DEFAULT fnd_api.g_miss_date,
59 X_CREATED_BY in NUMBER DEFAULT fnd_api.g_miss_num,
60 X_LAST_UPDATE_DATE in DATE DEFAULT fnd_api.g_miss_date,
61 X_LAST_UPDATED_BY in NUMBER DEFAULT fnd_api.g_miss_num,
62 X_LAST_UPDATE_LOGIN in NUMBER DEFAULT fnd_api.g_miss_num
63 );
64
65 PROCEDURE delete_shift_pre (
66 X_SHIFT_ID in NUMBER DEFAULT fnd_api.g_miss_num
67 );
68
69 PROCEDURE insert_shift_constructs_pre
70 (
71 X_ERROR out VARCHAR2,
72 X_ROWID in out VARCHAR2,
73 X_SHIFT_CONSTRUCT_ID in out NUMBER,
74 X_SHIFT_ID in NUMBER DEFAULT fnd_api.g_miss_num,
75 X_UNIT_OF_TIME_VALUE in VARCHAR2 DEFAULT fnd_api.g_miss_char,
76 X_BEGIN_TIME in DATE DEFAULT fnd_api.g_miss_date,
77 X_END_TIME in DATE DEFAULT fnd_api.g_miss_date,
78 X_START_DATE_ACTIVE in DATE DEFAULT fnd_api.g_miss_date,
79 X_END_DATE_ACTIVE in DATE DEFAULT fnd_api.g_miss_date,
80 X_AVAILABILITY_TYPE_CODE in VARCHAR2 DEFAULT fnd_api.g_miss_char,
81 X_ATTRIBUTE1 in VARCHAR2 DEFAULT fnd_api.g_miss_char,
82 X_ATTRIBUTE2 in VARCHAR2 DEFAULT fnd_api.g_miss_char,
83 X_ATTRIBUTE3 in VARCHAR2 DEFAULT fnd_api.g_miss_char,
84 X_ATTRIBUTE4 in VARCHAR2 DEFAULT fnd_api.g_miss_char,
85 X_ATTRIBUTE5 in VARCHAR2 DEFAULT fnd_api.g_miss_char,
86 X_ATTRIBUTE6 in VARCHAR2 DEFAULT fnd_api.g_miss_char,
87 X_ATTRIBUTE7 in VARCHAR2 DEFAULT fnd_api.g_miss_char,
88 X_ATTRIBUTE8 in VARCHAR2 DEFAULT fnd_api.g_miss_char,
89 X_ATTRIBUTE9 in VARCHAR2 DEFAULT fnd_api.g_miss_char,
90 X_ATTRIBUTE10 in VARCHAR2 DEFAULT fnd_api.g_miss_char,
91 X_ATTRIBUTE11 in VARCHAR2 DEFAULT fnd_api.g_miss_char,
92 X_ATTRIBUTE12 in VARCHAR2 DEFAULT fnd_api.g_miss_char,
93 X_ATTRIBUTE13 in VARCHAR2 DEFAULT fnd_api.g_miss_char,
94 X_ATTRIBUTE14 in VARCHAR2 DEFAULT fnd_api.g_miss_char,
95 X_ATTRIBUTE15 in VARCHAR2 DEFAULT fnd_api.g_miss_char,
96 X_ATTRIBUTE_CATEGORY in VARCHAR2 DEFAULT fnd_api.g_miss_char,
97 X_CREATION_DATE in DATE DEFAULT fnd_api.g_miss_date,
98 X_CREATED_BY in NUMBER DEFAULT fnd_api.g_miss_num,
99 X_LAST_UPDATE_DATE in DATE DEFAULT fnd_api.g_miss_date,
100 X_LAST_UPDATED_BY in NUMBER DEFAULT fnd_api.g_miss_num,
101 X_LAST_UPDATE_LOGIN in NUMBER DEFAULT fnd_api.g_miss_num
102 );
103
104 PROCEDURE delete_shift_constructs_pre (
105 X_SHIFT_CONSTRUCT_ID in NUMBER DEFAULT fnd_api.g_miss_num
106 );
107
108 END JTF_CAL_SHIFT_CUHK;