DBA Data[Home] [Help]

PACKAGE: APPS.JTF_CAL_SHIFT_CUHK

Source


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;