APPS.PA_SCHEDULE_PUB dependencies on PA_WORK_PATTERN_TEMP_TABLE

Line 11: l_PROJECT_ID PA_WORK_PATTERN_TEMP_TABLE.project_id%TYPE ,

7: -- Unilog Enhancement BEGIN
8:
9: TYPE WORK_PATTERN_REC_TYPE
10: IS RECORD (
11: l_PROJECT_ID PA_WORK_PATTERN_TEMP_TABLE.project_id%TYPE ,
12: l_PROJECT_NAME PA_WORK_PATTERN_TEMP_TABLE.project_name%TYPE ,
13: l_ASSIGNMENT_NAME PA_WORK_PATTERN_TEMP_TABLE.assignment_name%TYPE ,
14: l_START_DATE PA_WORK_PATTERN_TEMP_TABLE.start_date%TYPE ,
15: l_END_DATE PA_WORK_PATTERN_TEMP_TABLE.end_date%TYPE ,

Line 12: l_PROJECT_NAME PA_WORK_PATTERN_TEMP_TABLE.project_name%TYPE ,

8:
9: TYPE WORK_PATTERN_REC_TYPE
10: IS RECORD (
11: l_PROJECT_ID PA_WORK_PATTERN_TEMP_TABLE.project_id%TYPE ,
12: l_PROJECT_NAME PA_WORK_PATTERN_TEMP_TABLE.project_name%TYPE ,
13: l_ASSIGNMENT_NAME PA_WORK_PATTERN_TEMP_TABLE.assignment_name%TYPE ,
14: l_START_DATE PA_WORK_PATTERN_TEMP_TABLE.start_date%TYPE ,
15: l_END_DATE PA_WORK_PATTERN_TEMP_TABLE.end_date%TYPE ,
16: l_STATUS_NAME PA_WORK_PATTERN_TEMP_TABLE.status_name%TYPE ,

Line 13: l_ASSIGNMENT_NAME PA_WORK_PATTERN_TEMP_TABLE.assignment_name%TYPE ,

9: TYPE WORK_PATTERN_REC_TYPE
10: IS RECORD (
11: l_PROJECT_ID PA_WORK_PATTERN_TEMP_TABLE.project_id%TYPE ,
12: l_PROJECT_NAME PA_WORK_PATTERN_TEMP_TABLE.project_name%TYPE ,
13: l_ASSIGNMENT_NAME PA_WORK_PATTERN_TEMP_TABLE.assignment_name%TYPE ,
14: l_START_DATE PA_WORK_PATTERN_TEMP_TABLE.start_date%TYPE ,
15: l_END_DATE PA_WORK_PATTERN_TEMP_TABLE.end_date%TYPE ,
16: l_STATUS_NAME PA_WORK_PATTERN_TEMP_TABLE.status_name%TYPE ,
17: l_ASSIGNMENT_ID PA_WORK_PATTERN_TEMP_TABLE.assignment_id%TYPE ,

Line 14: l_START_DATE PA_WORK_PATTERN_TEMP_TABLE.start_date%TYPE ,

10: IS RECORD (
11: l_PROJECT_ID PA_WORK_PATTERN_TEMP_TABLE.project_id%TYPE ,
12: l_PROJECT_NAME PA_WORK_PATTERN_TEMP_TABLE.project_name%TYPE ,
13: l_ASSIGNMENT_NAME PA_WORK_PATTERN_TEMP_TABLE.assignment_name%TYPE ,
14: l_START_DATE PA_WORK_PATTERN_TEMP_TABLE.start_date%TYPE ,
15: l_END_DATE PA_WORK_PATTERN_TEMP_TABLE.end_date%TYPE ,
16: l_STATUS_NAME PA_WORK_PATTERN_TEMP_TABLE.status_name%TYPE ,
17: l_ASSIGNMENT_ID PA_WORK_PATTERN_TEMP_TABLE.assignment_id%TYPE ,
18: l_RESOURCE_ID PA_WORK_PATTERN_TEMP_TABLE.resource_id%TYPE ,

Line 15: l_END_DATE PA_WORK_PATTERN_TEMP_TABLE.end_date%TYPE ,

11: l_PROJECT_ID PA_WORK_PATTERN_TEMP_TABLE.project_id%TYPE ,
12: l_PROJECT_NAME PA_WORK_PATTERN_TEMP_TABLE.project_name%TYPE ,
13: l_ASSIGNMENT_NAME PA_WORK_PATTERN_TEMP_TABLE.assignment_name%TYPE ,
14: l_START_DATE PA_WORK_PATTERN_TEMP_TABLE.start_date%TYPE ,
15: l_END_DATE PA_WORK_PATTERN_TEMP_TABLE.end_date%TYPE ,
16: l_STATUS_NAME PA_WORK_PATTERN_TEMP_TABLE.status_name%TYPE ,
17: l_ASSIGNMENT_ID PA_WORK_PATTERN_TEMP_TABLE.assignment_id%TYPE ,
18: l_RESOURCE_ID PA_WORK_PATTERN_TEMP_TABLE.resource_id%TYPE ,
19: l_STATUS_CODE PA_WORK_PATTERN_TEMP_TABLE.status_code%TYPE ,

Line 16: l_STATUS_NAME PA_WORK_PATTERN_TEMP_TABLE.status_name%TYPE ,

12: l_PROJECT_NAME PA_WORK_PATTERN_TEMP_TABLE.project_name%TYPE ,
13: l_ASSIGNMENT_NAME PA_WORK_PATTERN_TEMP_TABLE.assignment_name%TYPE ,
14: l_START_DATE PA_WORK_PATTERN_TEMP_TABLE.start_date%TYPE ,
15: l_END_DATE PA_WORK_PATTERN_TEMP_TABLE.end_date%TYPE ,
16: l_STATUS_NAME PA_WORK_PATTERN_TEMP_TABLE.status_name%TYPE ,
17: l_ASSIGNMENT_ID PA_WORK_PATTERN_TEMP_TABLE.assignment_id%TYPE ,
18: l_RESOURCE_ID PA_WORK_PATTERN_TEMP_TABLE.resource_id%TYPE ,
19: l_STATUS_CODE PA_WORK_PATTERN_TEMP_TABLE.status_code%TYPE ,
20: l_RECORD_VERSION_NUMBER PA_WORK_PATTERN_TEMP_TABLE.record_version_number%TYPE ,

Line 17: l_ASSIGNMENT_ID PA_WORK_PATTERN_TEMP_TABLE.assignment_id%TYPE ,

13: l_ASSIGNMENT_NAME PA_WORK_PATTERN_TEMP_TABLE.assignment_name%TYPE ,
14: l_START_DATE PA_WORK_PATTERN_TEMP_TABLE.start_date%TYPE ,
15: l_END_DATE PA_WORK_PATTERN_TEMP_TABLE.end_date%TYPE ,
16: l_STATUS_NAME PA_WORK_PATTERN_TEMP_TABLE.status_name%TYPE ,
17: l_ASSIGNMENT_ID PA_WORK_PATTERN_TEMP_TABLE.assignment_id%TYPE ,
18: l_RESOURCE_ID PA_WORK_PATTERN_TEMP_TABLE.resource_id%TYPE ,
19: l_STATUS_CODE PA_WORK_PATTERN_TEMP_TABLE.status_code%TYPE ,
20: l_RECORD_VERSION_NUMBER PA_WORK_PATTERN_TEMP_TABLE.record_version_number%TYPE ,
21: l_ASSIGNMENT_TYPE PA_WORK_PATTERN_TEMP_TABLE.assignment_type%TYPE ,

Line 18: l_RESOURCE_ID PA_WORK_PATTERN_TEMP_TABLE.resource_id%TYPE ,

14: l_START_DATE PA_WORK_PATTERN_TEMP_TABLE.start_date%TYPE ,
15: l_END_DATE PA_WORK_PATTERN_TEMP_TABLE.end_date%TYPE ,
16: l_STATUS_NAME PA_WORK_PATTERN_TEMP_TABLE.status_name%TYPE ,
17: l_ASSIGNMENT_ID PA_WORK_PATTERN_TEMP_TABLE.assignment_id%TYPE ,
18: l_RESOURCE_ID PA_WORK_PATTERN_TEMP_TABLE.resource_id%TYPE ,
19: l_STATUS_CODE PA_WORK_PATTERN_TEMP_TABLE.status_code%TYPE ,
20: l_RECORD_VERSION_NUMBER PA_WORK_PATTERN_TEMP_TABLE.record_version_number%TYPE ,
21: l_ASSIGNMENT_TYPE PA_WORK_PATTERN_TEMP_TABLE.assignment_type%TYPE ,
22: l_CALENDAR_ID PA_WORK_PATTERN_TEMP_TABLE.calendar_id%TYPE ,

Line 19: l_STATUS_CODE PA_WORK_PATTERN_TEMP_TABLE.status_code%TYPE ,

15: l_END_DATE PA_WORK_PATTERN_TEMP_TABLE.end_date%TYPE ,
16: l_STATUS_NAME PA_WORK_PATTERN_TEMP_TABLE.status_name%TYPE ,
17: l_ASSIGNMENT_ID PA_WORK_PATTERN_TEMP_TABLE.assignment_id%TYPE ,
18: l_RESOURCE_ID PA_WORK_PATTERN_TEMP_TABLE.resource_id%TYPE ,
19: l_STATUS_CODE PA_WORK_PATTERN_TEMP_TABLE.status_code%TYPE ,
20: l_RECORD_VERSION_NUMBER PA_WORK_PATTERN_TEMP_TABLE.record_version_number%TYPE ,
21: l_ASSIGNMENT_TYPE PA_WORK_PATTERN_TEMP_TABLE.assignment_type%TYPE ,
22: l_CALENDAR_ID PA_WORK_PATTERN_TEMP_TABLE.calendar_id%TYPE ,
23: l_CALENDAR_TYPE PA_WORK_PATTERN_TEMP_TABLE.calendar_type%TYPE ,

Line 20: l_RECORD_VERSION_NUMBER PA_WORK_PATTERN_TEMP_TABLE.record_version_number%TYPE ,

16: l_STATUS_NAME PA_WORK_PATTERN_TEMP_TABLE.status_name%TYPE ,
17: l_ASSIGNMENT_ID PA_WORK_PATTERN_TEMP_TABLE.assignment_id%TYPE ,
18: l_RESOURCE_ID PA_WORK_PATTERN_TEMP_TABLE.resource_id%TYPE ,
19: l_STATUS_CODE PA_WORK_PATTERN_TEMP_TABLE.status_code%TYPE ,
20: l_RECORD_VERSION_NUMBER PA_WORK_PATTERN_TEMP_TABLE.record_version_number%TYPE ,
21: l_ASSIGNMENT_TYPE PA_WORK_PATTERN_TEMP_TABLE.assignment_type%TYPE ,
22: l_CALENDAR_ID PA_WORK_PATTERN_TEMP_TABLE.calendar_id%TYPE ,
23: l_CALENDAR_TYPE PA_WORK_PATTERN_TEMP_TABLE.calendar_type%TYPE ,
24: l_PROJECT_ROLE_NAME PA_WORK_PATTERN_TEMP_TABLE.project_role_name%TYPE ,

Line 21: l_ASSIGNMENT_TYPE PA_WORK_PATTERN_TEMP_TABLE.assignment_type%TYPE ,

17: l_ASSIGNMENT_ID PA_WORK_PATTERN_TEMP_TABLE.assignment_id%TYPE ,
18: l_RESOURCE_ID PA_WORK_PATTERN_TEMP_TABLE.resource_id%TYPE ,
19: l_STATUS_CODE PA_WORK_PATTERN_TEMP_TABLE.status_code%TYPE ,
20: l_RECORD_VERSION_NUMBER PA_WORK_PATTERN_TEMP_TABLE.record_version_number%TYPE ,
21: l_ASSIGNMENT_TYPE PA_WORK_PATTERN_TEMP_TABLE.assignment_type%TYPE ,
22: l_CALENDAR_ID PA_WORK_PATTERN_TEMP_TABLE.calendar_id%TYPE ,
23: l_CALENDAR_TYPE PA_WORK_PATTERN_TEMP_TABLE.calendar_type%TYPE ,
24: l_PROJECT_ROLE_NAME PA_WORK_PATTERN_TEMP_TABLE.project_role_name%TYPE ,
25: l_APPRVL_STATUS_NAME PA_WORK_PATTERN_TEMP_TABLE.apprvl_status_name%TYPE ,

Line 22: l_CALENDAR_ID PA_WORK_PATTERN_TEMP_TABLE.calendar_id%TYPE ,

18: l_RESOURCE_ID PA_WORK_PATTERN_TEMP_TABLE.resource_id%TYPE ,
19: l_STATUS_CODE PA_WORK_PATTERN_TEMP_TABLE.status_code%TYPE ,
20: l_RECORD_VERSION_NUMBER PA_WORK_PATTERN_TEMP_TABLE.record_version_number%TYPE ,
21: l_ASSIGNMENT_TYPE PA_WORK_PATTERN_TEMP_TABLE.assignment_type%TYPE ,
22: l_CALENDAR_ID PA_WORK_PATTERN_TEMP_TABLE.calendar_id%TYPE ,
23: l_CALENDAR_TYPE PA_WORK_PATTERN_TEMP_TABLE.calendar_type%TYPE ,
24: l_PROJECT_ROLE_NAME PA_WORK_PATTERN_TEMP_TABLE.project_role_name%TYPE ,
25: l_APPRVL_STATUS_NAME PA_WORK_PATTERN_TEMP_TABLE.apprvl_status_name%TYPE ,
26: l_ASSIGNMENT_EFFORT PA_WORK_PATTERN_TEMP_TABLE.assignment_effort%TYPE ,

Line 23: l_CALENDAR_TYPE PA_WORK_PATTERN_TEMP_TABLE.calendar_type%TYPE ,

19: l_STATUS_CODE PA_WORK_PATTERN_TEMP_TABLE.status_code%TYPE ,
20: l_RECORD_VERSION_NUMBER PA_WORK_PATTERN_TEMP_TABLE.record_version_number%TYPE ,
21: l_ASSIGNMENT_TYPE PA_WORK_PATTERN_TEMP_TABLE.assignment_type%TYPE ,
22: l_CALENDAR_ID PA_WORK_PATTERN_TEMP_TABLE.calendar_id%TYPE ,
23: l_CALENDAR_TYPE PA_WORK_PATTERN_TEMP_TABLE.calendar_type%TYPE ,
24: l_PROJECT_ROLE_NAME PA_WORK_PATTERN_TEMP_TABLE.project_role_name%TYPE ,
25: l_APPRVL_STATUS_NAME PA_WORK_PATTERN_TEMP_TABLE.apprvl_status_name%TYPE ,
26: l_ASSIGNMENT_EFFORT PA_WORK_PATTERN_TEMP_TABLE.assignment_effort%TYPE ,
27: l_ASSIGNMENT_DURATION PA_WORK_PATTERN_TEMP_TABLE.assignment_duration%TYPE ,

Line 24: l_PROJECT_ROLE_NAME PA_WORK_PATTERN_TEMP_TABLE.project_role_name%TYPE ,

20: l_RECORD_VERSION_NUMBER PA_WORK_PATTERN_TEMP_TABLE.record_version_number%TYPE ,
21: l_ASSIGNMENT_TYPE PA_WORK_PATTERN_TEMP_TABLE.assignment_type%TYPE ,
22: l_CALENDAR_ID PA_WORK_PATTERN_TEMP_TABLE.calendar_id%TYPE ,
23: l_CALENDAR_TYPE PA_WORK_PATTERN_TEMP_TABLE.calendar_type%TYPE ,
24: l_PROJECT_ROLE_NAME PA_WORK_PATTERN_TEMP_TABLE.project_role_name%TYPE ,
25: l_APPRVL_STATUS_NAME PA_WORK_PATTERN_TEMP_TABLE.apprvl_status_name%TYPE ,
26: l_ASSIGNMENT_EFFORT PA_WORK_PATTERN_TEMP_TABLE.assignment_effort%TYPE ,
27: l_ASSIGNMENT_DURATION PA_WORK_PATTERN_TEMP_TABLE.assignment_duration%TYPE ,
28: l_PROJECT_SYSTEM_STATUS_CODE PA_WORK_PATTERN_TEMP_TABLE.PROJECT_SYSTEM_STATUS_CODE%TYPE ,

Line 25: l_APPRVL_STATUS_NAME PA_WORK_PATTERN_TEMP_TABLE.apprvl_status_name%TYPE ,

21: l_ASSIGNMENT_TYPE PA_WORK_PATTERN_TEMP_TABLE.assignment_type%TYPE ,
22: l_CALENDAR_ID PA_WORK_PATTERN_TEMP_TABLE.calendar_id%TYPE ,
23: l_CALENDAR_TYPE PA_WORK_PATTERN_TEMP_TABLE.calendar_type%TYPE ,
24: l_PROJECT_ROLE_NAME PA_WORK_PATTERN_TEMP_TABLE.project_role_name%TYPE ,
25: l_APPRVL_STATUS_NAME PA_WORK_PATTERN_TEMP_TABLE.apprvl_status_name%TYPE ,
26: l_ASSIGNMENT_EFFORT PA_WORK_PATTERN_TEMP_TABLE.assignment_effort%TYPE ,
27: l_ASSIGNMENT_DURATION PA_WORK_PATTERN_TEMP_TABLE.assignment_duration%TYPE ,
28: l_PROJECT_SYSTEM_STATUS_CODE PA_WORK_PATTERN_TEMP_TABLE.PROJECT_SYSTEM_STATUS_CODE%TYPE ,
29: l_QTY1 PA_WORK_PATTERN_TEMP_TABLE.QTY1%TYPE ,

Line 26: l_ASSIGNMENT_EFFORT PA_WORK_PATTERN_TEMP_TABLE.assignment_effort%TYPE ,

22: l_CALENDAR_ID PA_WORK_PATTERN_TEMP_TABLE.calendar_id%TYPE ,
23: l_CALENDAR_TYPE PA_WORK_PATTERN_TEMP_TABLE.calendar_type%TYPE ,
24: l_PROJECT_ROLE_NAME PA_WORK_PATTERN_TEMP_TABLE.project_role_name%TYPE ,
25: l_APPRVL_STATUS_NAME PA_WORK_PATTERN_TEMP_TABLE.apprvl_status_name%TYPE ,
26: l_ASSIGNMENT_EFFORT PA_WORK_PATTERN_TEMP_TABLE.assignment_effort%TYPE ,
27: l_ASSIGNMENT_DURATION PA_WORK_PATTERN_TEMP_TABLE.assignment_duration%TYPE ,
28: l_PROJECT_SYSTEM_STATUS_CODE PA_WORK_PATTERN_TEMP_TABLE.PROJECT_SYSTEM_STATUS_CODE%TYPE ,
29: l_QTY1 PA_WORK_PATTERN_TEMP_TABLE.QTY1%TYPE ,
30: l_QTY2 PA_WORK_PATTERN_TEMP_TABLE.QTY2%TYPE ,

Line 27: l_ASSIGNMENT_DURATION PA_WORK_PATTERN_TEMP_TABLE.assignment_duration%TYPE ,

23: l_CALENDAR_TYPE PA_WORK_PATTERN_TEMP_TABLE.calendar_type%TYPE ,
24: l_PROJECT_ROLE_NAME PA_WORK_PATTERN_TEMP_TABLE.project_role_name%TYPE ,
25: l_APPRVL_STATUS_NAME PA_WORK_PATTERN_TEMP_TABLE.apprvl_status_name%TYPE ,
26: l_ASSIGNMENT_EFFORT PA_WORK_PATTERN_TEMP_TABLE.assignment_effort%TYPE ,
27: l_ASSIGNMENT_DURATION PA_WORK_PATTERN_TEMP_TABLE.assignment_duration%TYPE ,
28: l_PROJECT_SYSTEM_STATUS_CODE PA_WORK_PATTERN_TEMP_TABLE.PROJECT_SYSTEM_STATUS_CODE%TYPE ,
29: l_QTY1 PA_WORK_PATTERN_TEMP_TABLE.QTY1%TYPE ,
30: l_QTY2 PA_WORK_PATTERN_TEMP_TABLE.QTY2%TYPE ,
31: l_QTY3 PA_WORK_PATTERN_TEMP_TABLE.QTY3%TYPE ,

Line 28: l_PROJECT_SYSTEM_STATUS_CODE PA_WORK_PATTERN_TEMP_TABLE.PROJECT_SYSTEM_STATUS_CODE%TYPE ,

24: l_PROJECT_ROLE_NAME PA_WORK_PATTERN_TEMP_TABLE.project_role_name%TYPE ,
25: l_APPRVL_STATUS_NAME PA_WORK_PATTERN_TEMP_TABLE.apprvl_status_name%TYPE ,
26: l_ASSIGNMENT_EFFORT PA_WORK_PATTERN_TEMP_TABLE.assignment_effort%TYPE ,
27: l_ASSIGNMENT_DURATION PA_WORK_PATTERN_TEMP_TABLE.assignment_duration%TYPE ,
28: l_PROJECT_SYSTEM_STATUS_CODE PA_WORK_PATTERN_TEMP_TABLE.PROJECT_SYSTEM_STATUS_CODE%TYPE ,
29: l_QTY1 PA_WORK_PATTERN_TEMP_TABLE.QTY1%TYPE ,
30: l_QTY2 PA_WORK_PATTERN_TEMP_TABLE.QTY2%TYPE ,
31: l_QTY3 PA_WORK_PATTERN_TEMP_TABLE.QTY3%TYPE ,
32: l_QTY4 PA_WORK_PATTERN_TEMP_TABLE.QTY4%TYPE ,

Line 29: l_QTY1 PA_WORK_PATTERN_TEMP_TABLE.QTY1%TYPE ,

25: l_APPRVL_STATUS_NAME PA_WORK_PATTERN_TEMP_TABLE.apprvl_status_name%TYPE ,
26: l_ASSIGNMENT_EFFORT PA_WORK_PATTERN_TEMP_TABLE.assignment_effort%TYPE ,
27: l_ASSIGNMENT_DURATION PA_WORK_PATTERN_TEMP_TABLE.assignment_duration%TYPE ,
28: l_PROJECT_SYSTEM_STATUS_CODE PA_WORK_PATTERN_TEMP_TABLE.PROJECT_SYSTEM_STATUS_CODE%TYPE ,
29: l_QTY1 PA_WORK_PATTERN_TEMP_TABLE.QTY1%TYPE ,
30: l_QTY2 PA_WORK_PATTERN_TEMP_TABLE.QTY2%TYPE ,
31: l_QTY3 PA_WORK_PATTERN_TEMP_TABLE.QTY3%TYPE ,
32: l_QTY4 PA_WORK_PATTERN_TEMP_TABLE.QTY4%TYPE ,
33: l_QTY5 PA_WORK_PATTERN_TEMP_TABLE.QTY5%TYPE ,

Line 30: l_QTY2 PA_WORK_PATTERN_TEMP_TABLE.QTY2%TYPE ,

26: l_ASSIGNMENT_EFFORT PA_WORK_PATTERN_TEMP_TABLE.assignment_effort%TYPE ,
27: l_ASSIGNMENT_DURATION PA_WORK_PATTERN_TEMP_TABLE.assignment_duration%TYPE ,
28: l_PROJECT_SYSTEM_STATUS_CODE PA_WORK_PATTERN_TEMP_TABLE.PROJECT_SYSTEM_STATUS_CODE%TYPE ,
29: l_QTY1 PA_WORK_PATTERN_TEMP_TABLE.QTY1%TYPE ,
30: l_QTY2 PA_WORK_PATTERN_TEMP_TABLE.QTY2%TYPE ,
31: l_QTY3 PA_WORK_PATTERN_TEMP_TABLE.QTY3%TYPE ,
32: l_QTY4 PA_WORK_PATTERN_TEMP_TABLE.QTY4%TYPE ,
33: l_QTY5 PA_WORK_PATTERN_TEMP_TABLE.QTY5%TYPE ,
34: l_QTY6 PA_WORK_PATTERN_TEMP_TABLE.QTY6%TYPE ,

Line 31: l_QTY3 PA_WORK_PATTERN_TEMP_TABLE.QTY3%TYPE ,

27: l_ASSIGNMENT_DURATION PA_WORK_PATTERN_TEMP_TABLE.assignment_duration%TYPE ,
28: l_PROJECT_SYSTEM_STATUS_CODE PA_WORK_PATTERN_TEMP_TABLE.PROJECT_SYSTEM_STATUS_CODE%TYPE ,
29: l_QTY1 PA_WORK_PATTERN_TEMP_TABLE.QTY1%TYPE ,
30: l_QTY2 PA_WORK_PATTERN_TEMP_TABLE.QTY2%TYPE ,
31: l_QTY3 PA_WORK_PATTERN_TEMP_TABLE.QTY3%TYPE ,
32: l_QTY4 PA_WORK_PATTERN_TEMP_TABLE.QTY4%TYPE ,
33: l_QTY5 PA_WORK_PATTERN_TEMP_TABLE.QTY5%TYPE ,
34: l_QTY6 PA_WORK_PATTERN_TEMP_TABLE.QTY6%TYPE ,
35: l_QTY7 PA_WORK_PATTERN_TEMP_TABLE.QTY7%TYPE ,

Line 32: l_QTY4 PA_WORK_PATTERN_TEMP_TABLE.QTY4%TYPE ,

28: l_PROJECT_SYSTEM_STATUS_CODE PA_WORK_PATTERN_TEMP_TABLE.PROJECT_SYSTEM_STATUS_CODE%TYPE ,
29: l_QTY1 PA_WORK_PATTERN_TEMP_TABLE.QTY1%TYPE ,
30: l_QTY2 PA_WORK_PATTERN_TEMP_TABLE.QTY2%TYPE ,
31: l_QTY3 PA_WORK_PATTERN_TEMP_TABLE.QTY3%TYPE ,
32: l_QTY4 PA_WORK_PATTERN_TEMP_TABLE.QTY4%TYPE ,
33: l_QTY5 PA_WORK_PATTERN_TEMP_TABLE.QTY5%TYPE ,
34: l_QTY6 PA_WORK_PATTERN_TEMP_TABLE.QTY6%TYPE ,
35: l_QTY7 PA_WORK_PATTERN_TEMP_TABLE.QTY7%TYPE ,
36: l_QTY8 PA_WORK_PATTERN_TEMP_TABLE.QTY8%TYPE ,

Line 33: l_QTY5 PA_WORK_PATTERN_TEMP_TABLE.QTY5%TYPE ,

29: l_QTY1 PA_WORK_PATTERN_TEMP_TABLE.QTY1%TYPE ,
30: l_QTY2 PA_WORK_PATTERN_TEMP_TABLE.QTY2%TYPE ,
31: l_QTY3 PA_WORK_PATTERN_TEMP_TABLE.QTY3%TYPE ,
32: l_QTY4 PA_WORK_PATTERN_TEMP_TABLE.QTY4%TYPE ,
33: l_QTY5 PA_WORK_PATTERN_TEMP_TABLE.QTY5%TYPE ,
34: l_QTY6 PA_WORK_PATTERN_TEMP_TABLE.QTY6%TYPE ,
35: l_QTY7 PA_WORK_PATTERN_TEMP_TABLE.QTY7%TYPE ,
36: l_QTY8 PA_WORK_PATTERN_TEMP_TABLE.QTY8%TYPE ,
37: l_QTY9 PA_WORK_PATTERN_TEMP_TABLE.QTY9%TYPE ,

Line 34: l_QTY6 PA_WORK_PATTERN_TEMP_TABLE.QTY6%TYPE ,

30: l_QTY2 PA_WORK_PATTERN_TEMP_TABLE.QTY2%TYPE ,
31: l_QTY3 PA_WORK_PATTERN_TEMP_TABLE.QTY3%TYPE ,
32: l_QTY4 PA_WORK_PATTERN_TEMP_TABLE.QTY4%TYPE ,
33: l_QTY5 PA_WORK_PATTERN_TEMP_TABLE.QTY5%TYPE ,
34: l_QTY6 PA_WORK_PATTERN_TEMP_TABLE.QTY6%TYPE ,
35: l_QTY7 PA_WORK_PATTERN_TEMP_TABLE.QTY7%TYPE ,
36: l_QTY8 PA_WORK_PATTERN_TEMP_TABLE.QTY8%TYPE ,
37: l_QTY9 PA_WORK_PATTERN_TEMP_TABLE.QTY9%TYPE ,
38: l_QTY10 PA_WORK_PATTERN_TEMP_TABLE.QTY10%TYPE ,

Line 35: l_QTY7 PA_WORK_PATTERN_TEMP_TABLE.QTY7%TYPE ,

31: l_QTY3 PA_WORK_PATTERN_TEMP_TABLE.QTY3%TYPE ,
32: l_QTY4 PA_WORK_PATTERN_TEMP_TABLE.QTY4%TYPE ,
33: l_QTY5 PA_WORK_PATTERN_TEMP_TABLE.QTY5%TYPE ,
34: l_QTY6 PA_WORK_PATTERN_TEMP_TABLE.QTY6%TYPE ,
35: l_QTY7 PA_WORK_PATTERN_TEMP_TABLE.QTY7%TYPE ,
36: l_QTY8 PA_WORK_PATTERN_TEMP_TABLE.QTY8%TYPE ,
37: l_QTY9 PA_WORK_PATTERN_TEMP_TABLE.QTY9%TYPE ,
38: l_QTY10 PA_WORK_PATTERN_TEMP_TABLE.QTY10%TYPE ,
39: l_QTY11 PA_WORK_PATTERN_TEMP_TABLE.QTY11%TYPE ,

Line 36: l_QTY8 PA_WORK_PATTERN_TEMP_TABLE.QTY8%TYPE ,

32: l_QTY4 PA_WORK_PATTERN_TEMP_TABLE.QTY4%TYPE ,
33: l_QTY5 PA_WORK_PATTERN_TEMP_TABLE.QTY5%TYPE ,
34: l_QTY6 PA_WORK_PATTERN_TEMP_TABLE.QTY6%TYPE ,
35: l_QTY7 PA_WORK_PATTERN_TEMP_TABLE.QTY7%TYPE ,
36: l_QTY8 PA_WORK_PATTERN_TEMP_TABLE.QTY8%TYPE ,
37: l_QTY9 PA_WORK_PATTERN_TEMP_TABLE.QTY9%TYPE ,
38: l_QTY10 PA_WORK_PATTERN_TEMP_TABLE.QTY10%TYPE ,
39: l_QTY11 PA_WORK_PATTERN_TEMP_TABLE.QTY11%TYPE ,
40: l_QTY12 PA_WORK_PATTERN_TEMP_TABLE.QTY12%TYPE ,

Line 37: l_QTY9 PA_WORK_PATTERN_TEMP_TABLE.QTY9%TYPE ,

33: l_QTY5 PA_WORK_PATTERN_TEMP_TABLE.QTY5%TYPE ,
34: l_QTY6 PA_WORK_PATTERN_TEMP_TABLE.QTY6%TYPE ,
35: l_QTY7 PA_WORK_PATTERN_TEMP_TABLE.QTY7%TYPE ,
36: l_QTY8 PA_WORK_PATTERN_TEMP_TABLE.QTY8%TYPE ,
37: l_QTY9 PA_WORK_PATTERN_TEMP_TABLE.QTY9%TYPE ,
38: l_QTY10 PA_WORK_PATTERN_TEMP_TABLE.QTY10%TYPE ,
39: l_QTY11 PA_WORK_PATTERN_TEMP_TABLE.QTY11%TYPE ,
40: l_QTY12 PA_WORK_PATTERN_TEMP_TABLE.QTY12%TYPE ,
41: l_QTY13 PA_WORK_PATTERN_TEMP_TABLE.QTY13%TYPE ,

Line 38: l_QTY10 PA_WORK_PATTERN_TEMP_TABLE.QTY10%TYPE ,

34: l_QTY6 PA_WORK_PATTERN_TEMP_TABLE.QTY6%TYPE ,
35: l_QTY7 PA_WORK_PATTERN_TEMP_TABLE.QTY7%TYPE ,
36: l_QTY8 PA_WORK_PATTERN_TEMP_TABLE.QTY8%TYPE ,
37: l_QTY9 PA_WORK_PATTERN_TEMP_TABLE.QTY9%TYPE ,
38: l_QTY10 PA_WORK_PATTERN_TEMP_TABLE.QTY10%TYPE ,
39: l_QTY11 PA_WORK_PATTERN_TEMP_TABLE.QTY11%TYPE ,
40: l_QTY12 PA_WORK_PATTERN_TEMP_TABLE.QTY12%TYPE ,
41: l_QTY13 PA_WORK_PATTERN_TEMP_TABLE.QTY13%TYPE ,
42: l_QTY14 PA_WORK_PATTERN_TEMP_TABLE.QTY14%TYPE ,

Line 39: l_QTY11 PA_WORK_PATTERN_TEMP_TABLE.QTY11%TYPE ,

35: l_QTY7 PA_WORK_PATTERN_TEMP_TABLE.QTY7%TYPE ,
36: l_QTY8 PA_WORK_PATTERN_TEMP_TABLE.QTY8%TYPE ,
37: l_QTY9 PA_WORK_PATTERN_TEMP_TABLE.QTY9%TYPE ,
38: l_QTY10 PA_WORK_PATTERN_TEMP_TABLE.QTY10%TYPE ,
39: l_QTY11 PA_WORK_PATTERN_TEMP_TABLE.QTY11%TYPE ,
40: l_QTY12 PA_WORK_PATTERN_TEMP_TABLE.QTY12%TYPE ,
41: l_QTY13 PA_WORK_PATTERN_TEMP_TABLE.QTY13%TYPE ,
42: l_QTY14 PA_WORK_PATTERN_TEMP_TABLE.QTY14%TYPE ,
43: l_DAY1 PA_WORK_PATTERN_TEMP_TABLE.day1%TYPE ,

Line 40: l_QTY12 PA_WORK_PATTERN_TEMP_TABLE.QTY12%TYPE ,

36: l_QTY8 PA_WORK_PATTERN_TEMP_TABLE.QTY8%TYPE ,
37: l_QTY9 PA_WORK_PATTERN_TEMP_TABLE.QTY9%TYPE ,
38: l_QTY10 PA_WORK_PATTERN_TEMP_TABLE.QTY10%TYPE ,
39: l_QTY11 PA_WORK_PATTERN_TEMP_TABLE.QTY11%TYPE ,
40: l_QTY12 PA_WORK_PATTERN_TEMP_TABLE.QTY12%TYPE ,
41: l_QTY13 PA_WORK_PATTERN_TEMP_TABLE.QTY13%TYPE ,
42: l_QTY14 PA_WORK_PATTERN_TEMP_TABLE.QTY14%TYPE ,
43: l_DAY1 PA_WORK_PATTERN_TEMP_TABLE.day1%TYPE ,
44: l_DAY2 PA_WORK_PATTERN_TEMP_TABLE.day2%TYPE ,

Line 41: l_QTY13 PA_WORK_PATTERN_TEMP_TABLE.QTY13%TYPE ,

37: l_QTY9 PA_WORK_PATTERN_TEMP_TABLE.QTY9%TYPE ,
38: l_QTY10 PA_WORK_PATTERN_TEMP_TABLE.QTY10%TYPE ,
39: l_QTY11 PA_WORK_PATTERN_TEMP_TABLE.QTY11%TYPE ,
40: l_QTY12 PA_WORK_PATTERN_TEMP_TABLE.QTY12%TYPE ,
41: l_QTY13 PA_WORK_PATTERN_TEMP_TABLE.QTY13%TYPE ,
42: l_QTY14 PA_WORK_PATTERN_TEMP_TABLE.QTY14%TYPE ,
43: l_DAY1 PA_WORK_PATTERN_TEMP_TABLE.day1%TYPE ,
44: l_DAY2 PA_WORK_PATTERN_TEMP_TABLE.day2%TYPE ,
45: l_DAY3 PA_WORK_PATTERN_TEMP_TABLE.day3%TYPE ,

Line 42: l_QTY14 PA_WORK_PATTERN_TEMP_TABLE.QTY14%TYPE ,

38: l_QTY10 PA_WORK_PATTERN_TEMP_TABLE.QTY10%TYPE ,
39: l_QTY11 PA_WORK_PATTERN_TEMP_TABLE.QTY11%TYPE ,
40: l_QTY12 PA_WORK_PATTERN_TEMP_TABLE.QTY12%TYPE ,
41: l_QTY13 PA_WORK_PATTERN_TEMP_TABLE.QTY13%TYPE ,
42: l_QTY14 PA_WORK_PATTERN_TEMP_TABLE.QTY14%TYPE ,
43: l_DAY1 PA_WORK_PATTERN_TEMP_TABLE.day1%TYPE ,
44: l_DAY2 PA_WORK_PATTERN_TEMP_TABLE.day2%TYPE ,
45: l_DAY3 PA_WORK_PATTERN_TEMP_TABLE.day3%TYPE ,
46: l_DAY4 PA_WORK_PATTERN_TEMP_TABLE.day4%TYPE ,

Line 43: l_DAY1 PA_WORK_PATTERN_TEMP_TABLE.day1%TYPE ,

39: l_QTY11 PA_WORK_PATTERN_TEMP_TABLE.QTY11%TYPE ,
40: l_QTY12 PA_WORK_PATTERN_TEMP_TABLE.QTY12%TYPE ,
41: l_QTY13 PA_WORK_PATTERN_TEMP_TABLE.QTY13%TYPE ,
42: l_QTY14 PA_WORK_PATTERN_TEMP_TABLE.QTY14%TYPE ,
43: l_DAY1 PA_WORK_PATTERN_TEMP_TABLE.day1%TYPE ,
44: l_DAY2 PA_WORK_PATTERN_TEMP_TABLE.day2%TYPE ,
45: l_DAY3 PA_WORK_PATTERN_TEMP_TABLE.day3%TYPE ,
46: l_DAY4 PA_WORK_PATTERN_TEMP_TABLE.day4%TYPE ,
47: l_DAY5 PA_WORK_PATTERN_TEMP_TABLE.day5%TYPE ,

Line 44: l_DAY2 PA_WORK_PATTERN_TEMP_TABLE.day2%TYPE ,

40: l_QTY12 PA_WORK_PATTERN_TEMP_TABLE.QTY12%TYPE ,
41: l_QTY13 PA_WORK_PATTERN_TEMP_TABLE.QTY13%TYPE ,
42: l_QTY14 PA_WORK_PATTERN_TEMP_TABLE.QTY14%TYPE ,
43: l_DAY1 PA_WORK_PATTERN_TEMP_TABLE.day1%TYPE ,
44: l_DAY2 PA_WORK_PATTERN_TEMP_TABLE.day2%TYPE ,
45: l_DAY3 PA_WORK_PATTERN_TEMP_TABLE.day3%TYPE ,
46: l_DAY4 PA_WORK_PATTERN_TEMP_TABLE.day4%TYPE ,
47: l_DAY5 PA_WORK_PATTERN_TEMP_TABLE.day5%TYPE ,
48: l_DAY6 PA_WORK_PATTERN_TEMP_TABLE.day6%TYPE ,

Line 45: l_DAY3 PA_WORK_PATTERN_TEMP_TABLE.day3%TYPE ,

41: l_QTY13 PA_WORK_PATTERN_TEMP_TABLE.QTY13%TYPE ,
42: l_QTY14 PA_WORK_PATTERN_TEMP_TABLE.QTY14%TYPE ,
43: l_DAY1 PA_WORK_PATTERN_TEMP_TABLE.day1%TYPE ,
44: l_DAY2 PA_WORK_PATTERN_TEMP_TABLE.day2%TYPE ,
45: l_DAY3 PA_WORK_PATTERN_TEMP_TABLE.day3%TYPE ,
46: l_DAY4 PA_WORK_PATTERN_TEMP_TABLE.day4%TYPE ,
47: l_DAY5 PA_WORK_PATTERN_TEMP_TABLE.day5%TYPE ,
48: l_DAY6 PA_WORK_PATTERN_TEMP_TABLE.day6%TYPE ,
49: l_DAY7 PA_WORK_PATTERN_TEMP_TABLE.day7%TYPE ,

Line 46: l_DAY4 PA_WORK_PATTERN_TEMP_TABLE.day4%TYPE ,

42: l_QTY14 PA_WORK_PATTERN_TEMP_TABLE.QTY14%TYPE ,
43: l_DAY1 PA_WORK_PATTERN_TEMP_TABLE.day1%TYPE ,
44: l_DAY2 PA_WORK_PATTERN_TEMP_TABLE.day2%TYPE ,
45: l_DAY3 PA_WORK_PATTERN_TEMP_TABLE.day3%TYPE ,
46: l_DAY4 PA_WORK_PATTERN_TEMP_TABLE.day4%TYPE ,
47: l_DAY5 PA_WORK_PATTERN_TEMP_TABLE.day5%TYPE ,
48: l_DAY6 PA_WORK_PATTERN_TEMP_TABLE.day6%TYPE ,
49: l_DAY7 PA_WORK_PATTERN_TEMP_TABLE.day7%TYPE ,
50: l_DAY8 PA_WORK_PATTERN_TEMP_TABLE.day8%TYPE ,

Line 47: l_DAY5 PA_WORK_PATTERN_TEMP_TABLE.day5%TYPE ,

43: l_DAY1 PA_WORK_PATTERN_TEMP_TABLE.day1%TYPE ,
44: l_DAY2 PA_WORK_PATTERN_TEMP_TABLE.day2%TYPE ,
45: l_DAY3 PA_WORK_PATTERN_TEMP_TABLE.day3%TYPE ,
46: l_DAY4 PA_WORK_PATTERN_TEMP_TABLE.day4%TYPE ,
47: l_DAY5 PA_WORK_PATTERN_TEMP_TABLE.day5%TYPE ,
48: l_DAY6 PA_WORK_PATTERN_TEMP_TABLE.day6%TYPE ,
49: l_DAY7 PA_WORK_PATTERN_TEMP_TABLE.day7%TYPE ,
50: l_DAY8 PA_WORK_PATTERN_TEMP_TABLE.day8%TYPE ,
51: l_DAY9 PA_WORK_PATTERN_TEMP_TABLE.day9%TYPE ,

Line 48: l_DAY6 PA_WORK_PATTERN_TEMP_TABLE.day6%TYPE ,

44: l_DAY2 PA_WORK_PATTERN_TEMP_TABLE.day2%TYPE ,
45: l_DAY3 PA_WORK_PATTERN_TEMP_TABLE.day3%TYPE ,
46: l_DAY4 PA_WORK_PATTERN_TEMP_TABLE.day4%TYPE ,
47: l_DAY5 PA_WORK_PATTERN_TEMP_TABLE.day5%TYPE ,
48: l_DAY6 PA_WORK_PATTERN_TEMP_TABLE.day6%TYPE ,
49: l_DAY7 PA_WORK_PATTERN_TEMP_TABLE.day7%TYPE ,
50: l_DAY8 PA_WORK_PATTERN_TEMP_TABLE.day8%TYPE ,
51: l_DAY9 PA_WORK_PATTERN_TEMP_TABLE.day9%TYPE ,
52: l_DAY10 PA_WORK_PATTERN_TEMP_TABLE.day10%TYPE ,

Line 49: l_DAY7 PA_WORK_PATTERN_TEMP_TABLE.day7%TYPE ,

45: l_DAY3 PA_WORK_PATTERN_TEMP_TABLE.day3%TYPE ,
46: l_DAY4 PA_WORK_PATTERN_TEMP_TABLE.day4%TYPE ,
47: l_DAY5 PA_WORK_PATTERN_TEMP_TABLE.day5%TYPE ,
48: l_DAY6 PA_WORK_PATTERN_TEMP_TABLE.day6%TYPE ,
49: l_DAY7 PA_WORK_PATTERN_TEMP_TABLE.day7%TYPE ,
50: l_DAY8 PA_WORK_PATTERN_TEMP_TABLE.day8%TYPE ,
51: l_DAY9 PA_WORK_PATTERN_TEMP_TABLE.day9%TYPE ,
52: l_DAY10 PA_WORK_PATTERN_TEMP_TABLE.day10%TYPE ,
53: l_DAY11 PA_WORK_PATTERN_TEMP_TABLE.day11%TYPE ,

Line 50: l_DAY8 PA_WORK_PATTERN_TEMP_TABLE.day8%TYPE ,

46: l_DAY4 PA_WORK_PATTERN_TEMP_TABLE.day4%TYPE ,
47: l_DAY5 PA_WORK_PATTERN_TEMP_TABLE.day5%TYPE ,
48: l_DAY6 PA_WORK_PATTERN_TEMP_TABLE.day6%TYPE ,
49: l_DAY7 PA_WORK_PATTERN_TEMP_TABLE.day7%TYPE ,
50: l_DAY8 PA_WORK_PATTERN_TEMP_TABLE.day8%TYPE ,
51: l_DAY9 PA_WORK_PATTERN_TEMP_TABLE.day9%TYPE ,
52: l_DAY10 PA_WORK_PATTERN_TEMP_TABLE.day10%TYPE ,
53: l_DAY11 PA_WORK_PATTERN_TEMP_TABLE.day11%TYPE ,
54: l_DAY12 PA_WORK_PATTERN_TEMP_TABLE.day12%TYPE ,

Line 51: l_DAY9 PA_WORK_PATTERN_TEMP_TABLE.day9%TYPE ,

47: l_DAY5 PA_WORK_PATTERN_TEMP_TABLE.day5%TYPE ,
48: l_DAY6 PA_WORK_PATTERN_TEMP_TABLE.day6%TYPE ,
49: l_DAY7 PA_WORK_PATTERN_TEMP_TABLE.day7%TYPE ,
50: l_DAY8 PA_WORK_PATTERN_TEMP_TABLE.day8%TYPE ,
51: l_DAY9 PA_WORK_PATTERN_TEMP_TABLE.day9%TYPE ,
52: l_DAY10 PA_WORK_PATTERN_TEMP_TABLE.day10%TYPE ,
53: l_DAY11 PA_WORK_PATTERN_TEMP_TABLE.day11%TYPE ,
54: l_DAY12 PA_WORK_PATTERN_TEMP_TABLE.day12%TYPE ,
55: l_DAY13 PA_WORK_PATTERN_TEMP_TABLE.day13%TYPE ,

Line 52: l_DAY10 PA_WORK_PATTERN_TEMP_TABLE.day10%TYPE ,

48: l_DAY6 PA_WORK_PATTERN_TEMP_TABLE.day6%TYPE ,
49: l_DAY7 PA_WORK_PATTERN_TEMP_TABLE.day7%TYPE ,
50: l_DAY8 PA_WORK_PATTERN_TEMP_TABLE.day8%TYPE ,
51: l_DAY9 PA_WORK_PATTERN_TEMP_TABLE.day9%TYPE ,
52: l_DAY10 PA_WORK_PATTERN_TEMP_TABLE.day10%TYPE ,
53: l_DAY11 PA_WORK_PATTERN_TEMP_TABLE.day11%TYPE ,
54: l_DAY12 PA_WORK_PATTERN_TEMP_TABLE.day12%TYPE ,
55: l_DAY13 PA_WORK_PATTERN_TEMP_TABLE.day13%TYPE ,
56: l_DAY14 PA_WORK_PATTERN_TEMP_TABLE.day14%TYPE ,

Line 53: l_DAY11 PA_WORK_PATTERN_TEMP_TABLE.day11%TYPE ,

49: l_DAY7 PA_WORK_PATTERN_TEMP_TABLE.day7%TYPE ,
50: l_DAY8 PA_WORK_PATTERN_TEMP_TABLE.day8%TYPE ,
51: l_DAY9 PA_WORK_PATTERN_TEMP_TABLE.day9%TYPE ,
52: l_DAY10 PA_WORK_PATTERN_TEMP_TABLE.day10%TYPE ,
53: l_DAY11 PA_WORK_PATTERN_TEMP_TABLE.day11%TYPE ,
54: l_DAY12 PA_WORK_PATTERN_TEMP_TABLE.day12%TYPE ,
55: l_DAY13 PA_WORK_PATTERN_TEMP_TABLE.day13%TYPE ,
56: l_DAY14 PA_WORK_PATTERN_TEMP_TABLE.day14%TYPE ,
57: l_row_type_code PA_WORK_PATTERN_TEMP_TABLE.row_type_code%TYPE ,

Line 54: l_DAY12 PA_WORK_PATTERN_TEMP_TABLE.day12%TYPE ,

50: l_DAY8 PA_WORK_PATTERN_TEMP_TABLE.day8%TYPE ,
51: l_DAY9 PA_WORK_PATTERN_TEMP_TABLE.day9%TYPE ,
52: l_DAY10 PA_WORK_PATTERN_TEMP_TABLE.day10%TYPE ,
53: l_DAY11 PA_WORK_PATTERN_TEMP_TABLE.day11%TYPE ,
54: l_DAY12 PA_WORK_PATTERN_TEMP_TABLE.day12%TYPE ,
55: l_DAY13 PA_WORK_PATTERN_TEMP_TABLE.day13%TYPE ,
56: l_DAY14 PA_WORK_PATTERN_TEMP_TABLE.day14%TYPE ,
57: l_row_type_code PA_WORK_PATTERN_TEMP_TABLE.row_type_code%TYPE ,
58: l_read_only_flag PA_WORK_PATTERN_TEMP_TABLE.read_only_flag%TYPE

Line 55: l_DAY13 PA_WORK_PATTERN_TEMP_TABLE.day13%TYPE ,

51: l_DAY9 PA_WORK_PATTERN_TEMP_TABLE.day9%TYPE ,
52: l_DAY10 PA_WORK_PATTERN_TEMP_TABLE.day10%TYPE ,
53: l_DAY11 PA_WORK_PATTERN_TEMP_TABLE.day11%TYPE ,
54: l_DAY12 PA_WORK_PATTERN_TEMP_TABLE.day12%TYPE ,
55: l_DAY13 PA_WORK_PATTERN_TEMP_TABLE.day13%TYPE ,
56: l_DAY14 PA_WORK_PATTERN_TEMP_TABLE.day14%TYPE ,
57: l_row_type_code PA_WORK_PATTERN_TEMP_TABLE.row_type_code%TYPE ,
58: l_read_only_flag PA_WORK_PATTERN_TEMP_TABLE.read_only_flag%TYPE
59: );

Line 56: l_DAY14 PA_WORK_PATTERN_TEMP_TABLE.day14%TYPE ,

52: l_DAY10 PA_WORK_PATTERN_TEMP_TABLE.day10%TYPE ,
53: l_DAY11 PA_WORK_PATTERN_TEMP_TABLE.day11%TYPE ,
54: l_DAY12 PA_WORK_PATTERN_TEMP_TABLE.day12%TYPE ,
55: l_DAY13 PA_WORK_PATTERN_TEMP_TABLE.day13%TYPE ,
56: l_DAY14 PA_WORK_PATTERN_TEMP_TABLE.day14%TYPE ,
57: l_row_type_code PA_WORK_PATTERN_TEMP_TABLE.row_type_code%TYPE ,
58: l_read_only_flag PA_WORK_PATTERN_TEMP_TABLE.read_only_flag%TYPE
59: );
60:

Line 57: l_row_type_code PA_WORK_PATTERN_TEMP_TABLE.row_type_code%TYPE ,

53: l_DAY11 PA_WORK_PATTERN_TEMP_TABLE.day11%TYPE ,
54: l_DAY12 PA_WORK_PATTERN_TEMP_TABLE.day12%TYPE ,
55: l_DAY13 PA_WORK_PATTERN_TEMP_TABLE.day13%TYPE ,
56: l_DAY14 PA_WORK_PATTERN_TEMP_TABLE.day14%TYPE ,
57: l_row_type_code PA_WORK_PATTERN_TEMP_TABLE.row_type_code%TYPE ,
58: l_read_only_flag PA_WORK_PATTERN_TEMP_TABLE.read_only_flag%TYPE
59: );
60:
61: TYPE WORK_PATTERN_TAB_TYPE IS TABLE OF WORK_PATTERN_REC_TYPE

Line 58: l_read_only_flag PA_WORK_PATTERN_TEMP_TABLE.read_only_flag%TYPE

54: l_DAY12 PA_WORK_PATTERN_TEMP_TABLE.day12%TYPE ,
55: l_DAY13 PA_WORK_PATTERN_TEMP_TABLE.day13%TYPE ,
56: l_DAY14 PA_WORK_PATTERN_TEMP_TABLE.day14%TYPE ,
57: l_row_type_code PA_WORK_PATTERN_TEMP_TABLE.row_type_code%TYPE ,
58: l_read_only_flag PA_WORK_PATTERN_TEMP_TABLE.read_only_flag%TYPE
59: );
60:
61: TYPE WORK_PATTERN_TAB_TYPE IS TABLE OF WORK_PATTERN_REC_TYPE
62: INDEX BY BINARY_INTEGER;

Line 121: -- : pa_work_pattern_temp_table for the given assignment start date and assignment

117:
118:
119: -- Procedure : populate_work_pattern_table
120: -- Purpose : This procedure is called from self service for populating the global temp table
121: -- : pa_work_pattern_temp_table for the given assignment start date and assignment
122: -- : end date. The data will be populated for 14 days starting with Global week start day
123: -- : <= p_display_start_date. p_status_code is optional, if it is not given then it will
124: -- : fetch all the assignments irrespective of the assignment schedule status.
125: -- : Finally it returns the actual start date depending on the global week start date