eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.JTF_CAL_SHIFT_CUHK dependencies on FND_API

Line 6: X_SHIFT_ID in NUMBER DEFAULT fnd_api.g_miss_num,

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,

Line 8: X_START_DATE_ACTIVE in DATE DEFAULT fnd_api.g_miss_date,

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,

Line 9: X_END_DATE_ACTIVE in DATE DEFAULT fnd_api.g_miss_date,

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,

Line 10: X_ATTRIBUTE1 in VARCHAR2 DEFAULT fnd_api.g_miss_char,

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,

Line 11: X_ATTRIBUTE2 in VARCHAR2 DEFAULT fnd_api.g_miss_char,

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,

Line 12: X_ATTRIBUTE3 in VARCHAR2 DEFAULT fnd_api.g_miss_char,

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,

Line 13: X_ATTRIBUTE4 in VARCHAR2 DEFAULT fnd_api.g_miss_char,

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,

Line 14: X_ATTRIBUTE5 in VARCHAR2 DEFAULT fnd_api.g_miss_char,

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,

Line 15: X_ATTRIBUTE6 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,

Line 16: X_ATTRIBUTE7 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,

Line 17: X_ATTRIBUTE8 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,

Line 18: X_ATTRIBUTE9 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,

Line 19: X_ATTRIBUTE10 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,

Line 20: X_ATTRIBUTE11 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,

Line 21: X_ATTRIBUTE12 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,

Line 22: X_ATTRIBUTE13 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,

Line 23: X_ATTRIBUTE14 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,

Line 24: X_ATTRIBUTE15 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,

Line 25: X_ATTRIBUTE_CATEGORY 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,

Line 26: X_SHIFT_NAME 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

Line 27: X_DESCRIPTION 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: );

Line 28: X_LAST_UPDATE_DATE in DATE DEFAULT fnd_api.g_miss_date,

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:

Line 29: X_LAST_UPDATED_BY in NUMBER DEFAULT fnd_api.g_miss_num,

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 (

Line 30: X_LAST_UPDATE_LOGIN in NUMBER DEFAULT fnd_api.g_miss_num

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,

Line 37: X_OBJECT_VERSION_NUMBER in NUMBER DEFAULT fnd_api.g_miss_num,

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,

Line 38: X_START_DATE_ACTIVE in DATE DEFAULT fnd_api.g_miss_date,

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,

Line 39: X_END_DATE_ACTIVE in DATE DEFAULT fnd_api.g_miss_date,

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,

Line 40: X_ATTRIBUTE1 in VARCHAR2 DEFAULT fnd_api.g_miss_char,

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,

Line 41: X_ATTRIBUTE2 in VARCHAR2 DEFAULT fnd_api.g_miss_char,

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,

Line 42: X_ATTRIBUTE3 in VARCHAR2 DEFAULT fnd_api.g_miss_char,

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,

Line 43: X_ATTRIBUTE4 in VARCHAR2 DEFAULT fnd_api.g_miss_char,

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,

Line 44: X_ATTRIBUTE5 in VARCHAR2 DEFAULT fnd_api.g_miss_char,

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,

Line 45: X_ATTRIBUTE6 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,

Line 46: X_ATTRIBUTE7 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,

Line 47: X_ATTRIBUTE8 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,

Line 48: X_ATTRIBUTE9 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,

Line 49: X_ATTRIBUTE10 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,

Line 50: X_ATTRIBUTE11 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,

Line 51: X_ATTRIBUTE12 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,

Line 52: X_ATTRIBUTE13 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,

Line 53: X_ATTRIBUTE14 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,

Line 54: X_ATTRIBUTE15 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,

Line 55: X_ATTRIBUTE_CATEGORY 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,

Line 56: X_SHIFT_NAME 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,

Line 57: X_DESCRIPTION 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,

Line 58: X_CREATION_DATE in DATE DEFAULT fnd_api.g_miss_date,

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

Line 59: X_CREATED_BY in NUMBER DEFAULT fnd_api.g_miss_num,

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: );

Line 60: X_LAST_UPDATE_DATE in DATE DEFAULT fnd_api.g_miss_date,

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:

Line 61: X_LAST_UPDATED_BY in NUMBER DEFAULT fnd_api.g_miss_num,

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 (

Line 62: X_LAST_UPDATE_LOGIN in NUMBER DEFAULT fnd_api.g_miss_num

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

Line 66: X_SHIFT_ID 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: (

Line 74: X_SHIFT_ID in NUMBER DEFAULT fnd_api.g_miss_num,

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,

Line 75: X_UNIT_OF_TIME_VALUE in VARCHAR2 DEFAULT fnd_api.g_miss_char,

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,

Line 76: X_BEGIN_TIME in DATE DEFAULT fnd_api.g_miss_date,

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,

Line 77: X_END_TIME in DATE DEFAULT fnd_api.g_miss_date,

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,

Line 78: X_START_DATE_ACTIVE in DATE DEFAULT fnd_api.g_miss_date,

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,

Line 79: X_END_DATE_ACTIVE in DATE DEFAULT fnd_api.g_miss_date,

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,

Line 80: X_AVAILABILITY_TYPE_CODE 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,

Line 81: X_ATTRIBUTE1 in VARCHAR2 DEFAULT fnd_api.g_miss_char,

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,

Line 82: X_ATTRIBUTE2 in VARCHAR2 DEFAULT fnd_api.g_miss_char,

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,

Line 83: X_ATTRIBUTE3 in VARCHAR2 DEFAULT fnd_api.g_miss_char,

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,

Line 84: X_ATTRIBUTE4 in VARCHAR2 DEFAULT fnd_api.g_miss_char,

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,

Line 85: X_ATTRIBUTE5 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,

Line 86: X_ATTRIBUTE6 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,

Line 87: X_ATTRIBUTE7 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,

Line 88: X_ATTRIBUTE8 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,

Line 89: X_ATTRIBUTE9 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,

Line 90: X_ATTRIBUTE10 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,

Line 91: X_ATTRIBUTE11 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,

Line 92: X_ATTRIBUTE12 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,

Line 93: X_ATTRIBUTE13 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,

Line 94: X_ATTRIBUTE14 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,

Line 95: X_ATTRIBUTE15 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,

Line 96: X_ATTRIBUTE_CATEGORY 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,

Line 97: X_CREATION_DATE in DATE DEFAULT fnd_api.g_miss_date,

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

Line 98: X_CREATED_BY in NUMBER DEFAULT fnd_api.g_miss_num,

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: );

Line 99: X_LAST_UPDATE_DATE in DATE DEFAULT fnd_api.g_miss_date,

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:

Line 100: X_LAST_UPDATED_BY in NUMBER DEFAULT fnd_api.g_miss_num,

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 (

Line 101: X_LAST_UPDATE_LOGIN in NUMBER DEFAULT fnd_api.g_miss_num

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

Line 105: X_SHIFT_CONSTRUCT_ID 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;