9: -- End of Comments
10: /*TYPE Param_Rec_Type IS RECORD
11: (
12:
13: MONDAY_FIRST_START DATE := FND_API.G_MISS_DATE,
14: MONDAY_FIRST_END DATE := FND_API.G_MISS_DATE,
15: TUESDAY_FIRST_START DATE := FND_API.G_MISS_DATE,
16: TUESDAY_FIRST_END DATE := FND_API.G_MISS_DATE,
17: WEDNESDAY_FIRST_START DATE := FND_API.G_MISS_DATE,
10: /*TYPE Param_Rec_Type IS RECORD
11: (
12:
13: MONDAY_FIRST_START DATE := FND_API.G_MISS_DATE,
14: MONDAY_FIRST_END DATE := FND_API.G_MISS_DATE,
15: TUESDAY_FIRST_START DATE := FND_API.G_MISS_DATE,
16: TUESDAY_FIRST_END DATE := FND_API.G_MISS_DATE,
17: WEDNESDAY_FIRST_START DATE := FND_API.G_MISS_DATE,
18: WEDNESDAY_FIRST_END DATE := FND_API.G_MISS_DATE,
11: (
12:
13: MONDAY_FIRST_START DATE := FND_API.G_MISS_DATE,
14: MONDAY_FIRST_END DATE := FND_API.G_MISS_DATE,
15: TUESDAY_FIRST_START DATE := FND_API.G_MISS_DATE,
16: TUESDAY_FIRST_END DATE := FND_API.G_MISS_DATE,
17: WEDNESDAY_FIRST_START DATE := FND_API.G_MISS_DATE,
18: WEDNESDAY_FIRST_END DATE := FND_API.G_MISS_DATE,
19: THURSDAY_FIRST_START DATE := FND_API.G_MISS_DATE,
12:
13: MONDAY_FIRST_START DATE := FND_API.G_MISS_DATE,
14: MONDAY_FIRST_END DATE := FND_API.G_MISS_DATE,
15: TUESDAY_FIRST_START DATE := FND_API.G_MISS_DATE,
16: TUESDAY_FIRST_END DATE := FND_API.G_MISS_DATE,
17: WEDNESDAY_FIRST_START DATE := FND_API.G_MISS_DATE,
18: WEDNESDAY_FIRST_END DATE := FND_API.G_MISS_DATE,
19: THURSDAY_FIRST_START DATE := FND_API.G_MISS_DATE,
20: THURSDAY_FIRST_END DATE := FND_API.G_MISS_DATE,
13: MONDAY_FIRST_START DATE := FND_API.G_MISS_DATE,
14: MONDAY_FIRST_END DATE := FND_API.G_MISS_DATE,
15: TUESDAY_FIRST_START DATE := FND_API.G_MISS_DATE,
16: TUESDAY_FIRST_END DATE := FND_API.G_MISS_DATE,
17: WEDNESDAY_FIRST_START DATE := FND_API.G_MISS_DATE,
18: WEDNESDAY_FIRST_END DATE := FND_API.G_MISS_DATE,
19: THURSDAY_FIRST_START DATE := FND_API.G_MISS_DATE,
20: THURSDAY_FIRST_END DATE := FND_API.G_MISS_DATE,
21: FRIDAY_FIRST_START DATE := FND_API.G_MISS_DATE,
14: MONDAY_FIRST_END DATE := FND_API.G_MISS_DATE,
15: TUESDAY_FIRST_START DATE := FND_API.G_MISS_DATE,
16: TUESDAY_FIRST_END DATE := FND_API.G_MISS_DATE,
17: WEDNESDAY_FIRST_START DATE := FND_API.G_MISS_DATE,
18: WEDNESDAY_FIRST_END DATE := FND_API.G_MISS_DATE,
19: THURSDAY_FIRST_START DATE := FND_API.G_MISS_DATE,
20: THURSDAY_FIRST_END DATE := FND_API.G_MISS_DATE,
21: FRIDAY_FIRST_START DATE := FND_API.G_MISS_DATE,
22: FRIDAY_FIRST_END DATE := FND_API.G_MISS_DATE,
15: TUESDAY_FIRST_START DATE := FND_API.G_MISS_DATE,
16: TUESDAY_FIRST_END DATE := FND_API.G_MISS_DATE,
17: WEDNESDAY_FIRST_START DATE := FND_API.G_MISS_DATE,
18: WEDNESDAY_FIRST_END DATE := FND_API.G_MISS_DATE,
19: THURSDAY_FIRST_START DATE := FND_API.G_MISS_DATE,
20: THURSDAY_FIRST_END DATE := FND_API.G_MISS_DATE,
21: FRIDAY_FIRST_START DATE := FND_API.G_MISS_DATE,
22: FRIDAY_FIRST_END DATE := FND_API.G_MISS_DATE,
23: SATURDAY_FIRST_START DATE := FND_API.G_MISS_DATE,
16: TUESDAY_FIRST_END DATE := FND_API.G_MISS_DATE,
17: WEDNESDAY_FIRST_START DATE := FND_API.G_MISS_DATE,
18: WEDNESDAY_FIRST_END DATE := FND_API.G_MISS_DATE,
19: THURSDAY_FIRST_START DATE := FND_API.G_MISS_DATE,
20: THURSDAY_FIRST_END DATE := FND_API.G_MISS_DATE,
21: FRIDAY_FIRST_START DATE := FND_API.G_MISS_DATE,
22: FRIDAY_FIRST_END DATE := FND_API.G_MISS_DATE,
23: SATURDAY_FIRST_START DATE := FND_API.G_MISS_DATE,
24: SATURDAY_FIRST_END DATE := FND_API.G_MISS_DATE,
17: WEDNESDAY_FIRST_START DATE := FND_API.G_MISS_DATE,
18: WEDNESDAY_FIRST_END DATE := FND_API.G_MISS_DATE,
19: THURSDAY_FIRST_START DATE := FND_API.G_MISS_DATE,
20: THURSDAY_FIRST_END DATE := FND_API.G_MISS_DATE,
21: FRIDAY_FIRST_START DATE := FND_API.G_MISS_DATE,
22: FRIDAY_FIRST_END DATE := FND_API.G_MISS_DATE,
23: SATURDAY_FIRST_START DATE := FND_API.G_MISS_DATE,
24: SATURDAY_FIRST_END DATE := FND_API.G_MISS_DATE,
25: SUNDAY_FIRST_START DATE := FND_API.G_MISS_DATE,
18: WEDNESDAY_FIRST_END DATE := FND_API.G_MISS_DATE,
19: THURSDAY_FIRST_START DATE := FND_API.G_MISS_DATE,
20: THURSDAY_FIRST_END DATE := FND_API.G_MISS_DATE,
21: FRIDAY_FIRST_START DATE := FND_API.G_MISS_DATE,
22: FRIDAY_FIRST_END DATE := FND_API.G_MISS_DATE,
23: SATURDAY_FIRST_START DATE := FND_API.G_MISS_DATE,
24: SATURDAY_FIRST_END DATE := FND_API.G_MISS_DATE,
25: SUNDAY_FIRST_START DATE := FND_API.G_MISS_DATE,
26: SUNDAY_FIRST_END DATE := FND_API.G_MISS_DATE,
19: THURSDAY_FIRST_START DATE := FND_API.G_MISS_DATE,
20: THURSDAY_FIRST_END DATE := FND_API.G_MISS_DATE,
21: FRIDAY_FIRST_START DATE := FND_API.G_MISS_DATE,
22: FRIDAY_FIRST_END DATE := FND_API.G_MISS_DATE,
23: SATURDAY_FIRST_START DATE := FND_API.G_MISS_DATE,
24: SATURDAY_FIRST_END DATE := FND_API.G_MISS_DATE,
25: SUNDAY_FIRST_START DATE := FND_API.G_MISS_DATE,
26: SUNDAY_FIRST_END DATE := FND_API.G_MISS_DATE,
27: MONDAY_SECOND_START DATE := FND_API.G_MISS_DATE,
20: THURSDAY_FIRST_END DATE := FND_API.G_MISS_DATE,
21: FRIDAY_FIRST_START DATE := FND_API.G_MISS_DATE,
22: FRIDAY_FIRST_END DATE := FND_API.G_MISS_DATE,
23: SATURDAY_FIRST_START DATE := FND_API.G_MISS_DATE,
24: SATURDAY_FIRST_END DATE := FND_API.G_MISS_DATE,
25: SUNDAY_FIRST_START DATE := FND_API.G_MISS_DATE,
26: SUNDAY_FIRST_END DATE := FND_API.G_MISS_DATE,
27: MONDAY_SECOND_START DATE := FND_API.G_MISS_DATE,
28: MONDAY_SECOND_END DATE := FND_API.G_MISS_DATE,
21: FRIDAY_FIRST_START DATE := FND_API.G_MISS_DATE,
22: FRIDAY_FIRST_END DATE := FND_API.G_MISS_DATE,
23: SATURDAY_FIRST_START DATE := FND_API.G_MISS_DATE,
24: SATURDAY_FIRST_END DATE := FND_API.G_MISS_DATE,
25: SUNDAY_FIRST_START DATE := FND_API.G_MISS_DATE,
26: SUNDAY_FIRST_END DATE := FND_API.G_MISS_DATE,
27: MONDAY_SECOND_START DATE := FND_API.G_MISS_DATE,
28: MONDAY_SECOND_END DATE := FND_API.G_MISS_DATE,
29: TUESDAY_SECOND_START DATE := FND_API.G_MISS_DATE,
22: FRIDAY_FIRST_END DATE := FND_API.G_MISS_DATE,
23: SATURDAY_FIRST_START DATE := FND_API.G_MISS_DATE,
24: SATURDAY_FIRST_END DATE := FND_API.G_MISS_DATE,
25: SUNDAY_FIRST_START DATE := FND_API.G_MISS_DATE,
26: SUNDAY_FIRST_END DATE := FND_API.G_MISS_DATE,
27: MONDAY_SECOND_START DATE := FND_API.G_MISS_DATE,
28: MONDAY_SECOND_END DATE := FND_API.G_MISS_DATE,
29: TUESDAY_SECOND_START DATE := FND_API.G_MISS_DATE,
30: TUESDAY_SECOND_END DATE := FND_API.G_MISS_DATE,
23: SATURDAY_FIRST_START DATE := FND_API.G_MISS_DATE,
24: SATURDAY_FIRST_END DATE := FND_API.G_MISS_DATE,
25: SUNDAY_FIRST_START DATE := FND_API.G_MISS_DATE,
26: SUNDAY_FIRST_END DATE := FND_API.G_MISS_DATE,
27: MONDAY_SECOND_START DATE := FND_API.G_MISS_DATE,
28: MONDAY_SECOND_END DATE := FND_API.G_MISS_DATE,
29: TUESDAY_SECOND_START DATE := FND_API.G_MISS_DATE,
30: TUESDAY_SECOND_END DATE := FND_API.G_MISS_DATE,
31: WEDNESDAY_SECOND_START DATE := FND_API.G_MISS_DATE,
24: SATURDAY_FIRST_END DATE := FND_API.G_MISS_DATE,
25: SUNDAY_FIRST_START DATE := FND_API.G_MISS_DATE,
26: SUNDAY_FIRST_END DATE := FND_API.G_MISS_DATE,
27: MONDAY_SECOND_START DATE := FND_API.G_MISS_DATE,
28: MONDAY_SECOND_END DATE := FND_API.G_MISS_DATE,
29: TUESDAY_SECOND_START DATE := FND_API.G_MISS_DATE,
30: TUESDAY_SECOND_END DATE := FND_API.G_MISS_DATE,
31: WEDNESDAY_SECOND_START DATE := FND_API.G_MISS_DATE,
32: WEDNESDAY_SECOND_END DATE := FND_API.G_MISS_DATE,
25: SUNDAY_FIRST_START DATE := FND_API.G_MISS_DATE,
26: SUNDAY_FIRST_END DATE := FND_API.G_MISS_DATE,
27: MONDAY_SECOND_START DATE := FND_API.G_MISS_DATE,
28: MONDAY_SECOND_END DATE := FND_API.G_MISS_DATE,
29: TUESDAY_SECOND_START DATE := FND_API.G_MISS_DATE,
30: TUESDAY_SECOND_END DATE := FND_API.G_MISS_DATE,
31: WEDNESDAY_SECOND_START DATE := FND_API.G_MISS_DATE,
32: WEDNESDAY_SECOND_END DATE := FND_API.G_MISS_DATE,
33: THURSDAY_SECOND_START DATE := FND_API.G_MISS_DATE,
26: SUNDAY_FIRST_END DATE := FND_API.G_MISS_DATE,
27: MONDAY_SECOND_START DATE := FND_API.G_MISS_DATE,
28: MONDAY_SECOND_END DATE := FND_API.G_MISS_DATE,
29: TUESDAY_SECOND_START DATE := FND_API.G_MISS_DATE,
30: TUESDAY_SECOND_END DATE := FND_API.G_MISS_DATE,
31: WEDNESDAY_SECOND_START DATE := FND_API.G_MISS_DATE,
32: WEDNESDAY_SECOND_END DATE := FND_API.G_MISS_DATE,
33: THURSDAY_SECOND_START DATE := FND_API.G_MISS_DATE,
34: THURSDAY_SECOND_END DATE := FND_API.G_MISS_DATE,
27: MONDAY_SECOND_START DATE := FND_API.G_MISS_DATE,
28: MONDAY_SECOND_END DATE := FND_API.G_MISS_DATE,
29: TUESDAY_SECOND_START DATE := FND_API.G_MISS_DATE,
30: TUESDAY_SECOND_END DATE := FND_API.G_MISS_DATE,
31: WEDNESDAY_SECOND_START DATE := FND_API.G_MISS_DATE,
32: WEDNESDAY_SECOND_END DATE := FND_API.G_MISS_DATE,
33: THURSDAY_SECOND_START DATE := FND_API.G_MISS_DATE,
34: THURSDAY_SECOND_END DATE := FND_API.G_MISS_DATE,
35: FRIDAY_SECOND_START DATE := FND_API.G_MISS_DATE,
28: MONDAY_SECOND_END DATE := FND_API.G_MISS_DATE,
29: TUESDAY_SECOND_START DATE := FND_API.G_MISS_DATE,
30: TUESDAY_SECOND_END DATE := FND_API.G_MISS_DATE,
31: WEDNESDAY_SECOND_START DATE := FND_API.G_MISS_DATE,
32: WEDNESDAY_SECOND_END DATE := FND_API.G_MISS_DATE,
33: THURSDAY_SECOND_START DATE := FND_API.G_MISS_DATE,
34: THURSDAY_SECOND_END DATE := FND_API.G_MISS_DATE,
35: FRIDAY_SECOND_START DATE := FND_API.G_MISS_DATE,
36: FRIDAY_SECOND_END DATE := FND_API.G_MISS_DATE,
29: TUESDAY_SECOND_START DATE := FND_API.G_MISS_DATE,
30: TUESDAY_SECOND_END DATE := FND_API.G_MISS_DATE,
31: WEDNESDAY_SECOND_START DATE := FND_API.G_MISS_DATE,
32: WEDNESDAY_SECOND_END DATE := FND_API.G_MISS_DATE,
33: THURSDAY_SECOND_START DATE := FND_API.G_MISS_DATE,
34: THURSDAY_SECOND_END DATE := FND_API.G_MISS_DATE,
35: FRIDAY_SECOND_START DATE := FND_API.G_MISS_DATE,
36: FRIDAY_SECOND_END DATE := FND_API.G_MISS_DATE,
37: SATURDAY_SECOND_START DATE := FND_API.G_MISS_DATE,
30: TUESDAY_SECOND_END DATE := FND_API.G_MISS_DATE,
31: WEDNESDAY_SECOND_START DATE := FND_API.G_MISS_DATE,
32: WEDNESDAY_SECOND_END DATE := FND_API.G_MISS_DATE,
33: THURSDAY_SECOND_START DATE := FND_API.G_MISS_DATE,
34: THURSDAY_SECOND_END DATE := FND_API.G_MISS_DATE,
35: FRIDAY_SECOND_START DATE := FND_API.G_MISS_DATE,
36: FRIDAY_SECOND_END DATE := FND_API.G_MISS_DATE,
37: SATURDAY_SECOND_START DATE := FND_API.G_MISS_DATE,
38: SATURDAY_SECOND_END DATE := FND_API.G_MISS_DATE,
31: WEDNESDAY_SECOND_START DATE := FND_API.G_MISS_DATE,
32: WEDNESDAY_SECOND_END DATE := FND_API.G_MISS_DATE,
33: THURSDAY_SECOND_START DATE := FND_API.G_MISS_DATE,
34: THURSDAY_SECOND_END DATE := FND_API.G_MISS_DATE,
35: FRIDAY_SECOND_START DATE := FND_API.G_MISS_DATE,
36: FRIDAY_SECOND_END DATE := FND_API.G_MISS_DATE,
37: SATURDAY_SECOND_START DATE := FND_API.G_MISS_DATE,
38: SATURDAY_SECOND_END DATE := FND_API.G_MISS_DATE,
39: SUNDAY_SECOND_START DATE := FND_API.G_MISS_DATE,
32: WEDNESDAY_SECOND_END DATE := FND_API.G_MISS_DATE,
33: THURSDAY_SECOND_START DATE := FND_API.G_MISS_DATE,
34: THURSDAY_SECOND_END DATE := FND_API.G_MISS_DATE,
35: FRIDAY_SECOND_START DATE := FND_API.G_MISS_DATE,
36: FRIDAY_SECOND_END DATE := FND_API.G_MISS_DATE,
37: SATURDAY_SECOND_START DATE := FND_API.G_MISS_DATE,
38: SATURDAY_SECOND_END DATE := FND_API.G_MISS_DATE,
39: SUNDAY_SECOND_START DATE := FND_API.G_MISS_DATE,
40: SUNDAY_SECOND_END DATE := FND_API.G_MISS_DATE
33: THURSDAY_SECOND_START DATE := FND_API.G_MISS_DATE,
34: THURSDAY_SECOND_END DATE := FND_API.G_MISS_DATE,
35: FRIDAY_SECOND_START DATE := FND_API.G_MISS_DATE,
36: FRIDAY_SECOND_END DATE := FND_API.G_MISS_DATE,
37: SATURDAY_SECOND_START DATE := FND_API.G_MISS_DATE,
38: SATURDAY_SECOND_END DATE := FND_API.G_MISS_DATE,
39: SUNDAY_SECOND_START DATE := FND_API.G_MISS_DATE,
40: SUNDAY_SECOND_END DATE := FND_API.G_MISS_DATE
41: );
34: THURSDAY_SECOND_END DATE := FND_API.G_MISS_DATE,
35: FRIDAY_SECOND_START DATE := FND_API.G_MISS_DATE,
36: FRIDAY_SECOND_END DATE := FND_API.G_MISS_DATE,
37: SATURDAY_SECOND_START DATE := FND_API.G_MISS_DATE,
38: SATURDAY_SECOND_END DATE := FND_API.G_MISS_DATE,
39: SUNDAY_SECOND_START DATE := FND_API.G_MISS_DATE,
40: SUNDAY_SECOND_END DATE := FND_API.G_MISS_DATE
41: );
42:
35: FRIDAY_SECOND_START DATE := FND_API.G_MISS_DATE,
36: FRIDAY_SECOND_END DATE := FND_API.G_MISS_DATE,
37: SATURDAY_SECOND_START DATE := FND_API.G_MISS_DATE,
38: SATURDAY_SECOND_END DATE := FND_API.G_MISS_DATE,
39: SUNDAY_SECOND_START DATE := FND_API.G_MISS_DATE,
40: SUNDAY_SECOND_END DATE := FND_API.G_MISS_DATE
41: );
42:
43: TYPE PARAM_REC_TBL_TYPE is table of Param_Rec_Type;
36: FRIDAY_SECOND_END DATE := FND_API.G_MISS_DATE,
37: SATURDAY_SECOND_START DATE := FND_API.G_MISS_DATE,
38: SATURDAY_SECOND_END DATE := FND_API.G_MISS_DATE,
39: SUNDAY_SECOND_START DATE := FND_API.G_MISS_DATE,
40: SUNDAY_SECOND_END DATE := FND_API.G_MISS_DATE
41: );
42:
43: TYPE PARAM_REC_TBL_TYPE is table of Param_Rec_Type;
44:
109: p_CREATION_DATE DATE default null,
110: p_LAST_UPDATED_BY NUMBER default null,
111: p_LAST_UPDATE_DATE DATE default null,
112: p_LAST_UPDATE_LOGIN NUMBER default null,
113: p_commit in varchar2 default fnd_api.g_true,
114: x_return_status OUT NOCOPY VARCHAR2,
115: x_msg_data OUT NOCOPY VARCHAR2,
116: x_msg_count OUT NOCOPY NUMBER
117: