[Home] [Help]
2: /* $Header: MSCGNTPB.pls 120.30 2006/09/20 00:28:24 pabram noship $ */
3:
4: -- Constants
5: --separators
6: FIELD_SEPERATOR constant varchar2(5) := msc_gantt_utils.FIELD_SEPERATOR;
7: RECORD_SEPERATOR constant varchar2(5) := msc_gantt_utils.RECORD_SEPERATOR;
8: RESOURCE_SEPERATOR constant varchar2(5) := msc_gantt_utils.RESOURCE_SEPERATOR;
9: FORMAT_MASK constant varchar2(20) := msc_gantt_utils.FORMAT_MASK;
10: COMMA_SEPARATOR constant varchar2(20) := msc_gantt_utils.COMMA_SEPARATOR;
3:
4: -- Constants
5: --separators
6: FIELD_SEPERATOR constant varchar2(5) := msc_gantt_utils.FIELD_SEPERATOR;
7: RECORD_SEPERATOR constant varchar2(5) := msc_gantt_utils.RECORD_SEPERATOR;
8: RESOURCE_SEPERATOR constant varchar2(5) := msc_gantt_utils.RESOURCE_SEPERATOR;
9: FORMAT_MASK constant varchar2(20) := msc_gantt_utils.FORMAT_MASK;
10: COMMA_SEPARATOR constant varchar2(20) := msc_gantt_utils.COMMA_SEPARATOR;
11: COLON_SEPARATOR constant varchar2(20) := msc_gantt_utils.COLON_SEPARATOR;
4: -- Constants
5: --separators
6: FIELD_SEPERATOR constant varchar2(5) := msc_gantt_utils.FIELD_SEPERATOR;
7: RECORD_SEPERATOR constant varchar2(5) := msc_gantt_utils.RECORD_SEPERATOR;
8: RESOURCE_SEPERATOR constant varchar2(5) := msc_gantt_utils.RESOURCE_SEPERATOR;
9: FORMAT_MASK constant varchar2(20) := msc_gantt_utils.FORMAT_MASK;
10: COMMA_SEPARATOR constant varchar2(20) := msc_gantt_utils.COMMA_SEPARATOR;
11: COLON_SEPARATOR constant varchar2(20) := msc_gantt_utils.COLON_SEPARATOR;
12:
5: --separators
6: FIELD_SEPERATOR constant varchar2(5) := msc_gantt_utils.FIELD_SEPERATOR;
7: RECORD_SEPERATOR constant varchar2(5) := msc_gantt_utils.RECORD_SEPERATOR;
8: RESOURCE_SEPERATOR constant varchar2(5) := msc_gantt_utils.RESOURCE_SEPERATOR;
9: FORMAT_MASK constant varchar2(20) := msc_gantt_utils.FORMAT_MASK;
10: COMMA_SEPARATOR constant varchar2(20) := msc_gantt_utils.COMMA_SEPARATOR;
11: COLON_SEPARATOR constant varchar2(20) := msc_gantt_utils.COLON_SEPARATOR;
12:
13: --view types
6: FIELD_SEPERATOR constant varchar2(5) := msc_gantt_utils.FIELD_SEPERATOR;
7: RECORD_SEPERATOR constant varchar2(5) := msc_gantt_utils.RECORD_SEPERATOR;
8: RESOURCE_SEPERATOR constant varchar2(5) := msc_gantt_utils.RESOURCE_SEPERATOR;
9: FORMAT_MASK constant varchar2(20) := msc_gantt_utils.FORMAT_MASK;
10: COMMA_SEPARATOR constant varchar2(20) := msc_gantt_utils.COMMA_SEPARATOR;
11: COLON_SEPARATOR constant varchar2(20) := msc_gantt_utils.COLON_SEPARATOR;
12:
13: --view types
14: DEMAND_VIEW CONSTANT INTEGER := msc_gantt_utils.DEMAND_VIEW;
7: RECORD_SEPERATOR constant varchar2(5) := msc_gantt_utils.RECORD_SEPERATOR;
8: RESOURCE_SEPERATOR constant varchar2(5) := msc_gantt_utils.RESOURCE_SEPERATOR;
9: FORMAT_MASK constant varchar2(20) := msc_gantt_utils.FORMAT_MASK;
10: COMMA_SEPARATOR constant varchar2(20) := msc_gantt_utils.COMMA_SEPARATOR;
11: COLON_SEPARATOR constant varchar2(20) := msc_gantt_utils.COLON_SEPARATOR;
12:
13: --view types
14: DEMAND_VIEW CONSTANT INTEGER := msc_gantt_utils.DEMAND_VIEW;
15: ORDER_VIEW CONSTANT INTEGER := msc_gantt_utils.ORDER_VIEW;
10: COMMA_SEPARATOR constant varchar2(20) := msc_gantt_utils.COMMA_SEPARATOR;
11: COLON_SEPARATOR constant varchar2(20) := msc_gantt_utils.COLON_SEPARATOR;
12:
13: --view types
14: DEMAND_VIEW CONSTANT INTEGER := msc_gantt_utils.DEMAND_VIEW;
15: ORDER_VIEW CONSTANT INTEGER := msc_gantt_utils.ORDER_VIEW;
16: RES_ACTIVITIES_VIEW CONSTANT INTEGER := msc_gantt_utils.RES_ACTIVITIES_VIEW;
17: RES_UNITS_VIEW CONSTANT INTEGER := msc_gantt_utils.RES_UNITS_VIEW;
18: RES_HOURS_VIEW CONSTANT INTEGER := msc_gantt_utils.RES_HOURS_VIEW;
11: COLON_SEPARATOR constant varchar2(20) := msc_gantt_utils.COLON_SEPARATOR;
12:
13: --view types
14: DEMAND_VIEW CONSTANT INTEGER := msc_gantt_utils.DEMAND_VIEW;
15: ORDER_VIEW CONSTANT INTEGER := msc_gantt_utils.ORDER_VIEW;
16: RES_ACTIVITIES_VIEW CONSTANT INTEGER := msc_gantt_utils.RES_ACTIVITIES_VIEW;
17: RES_UNITS_VIEW CONSTANT INTEGER := msc_gantt_utils.RES_UNITS_VIEW;
18: RES_HOURS_VIEW CONSTANT INTEGER := msc_gantt_utils.RES_HOURS_VIEW;
19: SUPPLIER_VIEW CONSTANT INTEGER := msc_gantt_utils.SUPPLIER_VIEW;
12:
13: --view types
14: DEMAND_VIEW CONSTANT INTEGER := msc_gantt_utils.DEMAND_VIEW;
15: ORDER_VIEW CONSTANT INTEGER := msc_gantt_utils.ORDER_VIEW;
16: RES_ACTIVITIES_VIEW CONSTANT INTEGER := msc_gantt_utils.RES_ACTIVITIES_VIEW;
17: RES_UNITS_VIEW CONSTANT INTEGER := msc_gantt_utils.RES_UNITS_VIEW;
18: RES_HOURS_VIEW CONSTANT INTEGER := msc_gantt_utils.RES_HOURS_VIEW;
19: SUPPLIER_VIEW CONSTANT INTEGER := msc_gantt_utils.SUPPLIER_VIEW;
20:
13: --view types
14: DEMAND_VIEW CONSTANT INTEGER := msc_gantt_utils.DEMAND_VIEW;
15: ORDER_VIEW CONSTANT INTEGER := msc_gantt_utils.ORDER_VIEW;
16: RES_ACTIVITIES_VIEW CONSTANT INTEGER := msc_gantt_utils.RES_ACTIVITIES_VIEW;
17: RES_UNITS_VIEW CONSTANT INTEGER := msc_gantt_utils.RES_UNITS_VIEW;
18: RES_HOURS_VIEW CONSTANT INTEGER := msc_gantt_utils.RES_HOURS_VIEW;
19: SUPPLIER_VIEW CONSTANT INTEGER := msc_gantt_utils.SUPPLIER_VIEW;
20:
21: --node types
14: DEMAND_VIEW CONSTANT INTEGER := msc_gantt_utils.DEMAND_VIEW;
15: ORDER_VIEW CONSTANT INTEGER := msc_gantt_utils.ORDER_VIEW;
16: RES_ACTIVITIES_VIEW CONSTANT INTEGER := msc_gantt_utils.RES_ACTIVITIES_VIEW;
17: RES_UNITS_VIEW CONSTANT INTEGER := msc_gantt_utils.RES_UNITS_VIEW;
18: RES_HOURS_VIEW CONSTANT INTEGER := msc_gantt_utils.RES_HOURS_VIEW;
19: SUPPLIER_VIEW CONSTANT INTEGER := msc_gantt_utils.SUPPLIER_VIEW;
20:
21: --node types
22: END_DEMAND_NODE constant INTEGER := msc_gantt_utils.END_DEMAND_NODE;
15: ORDER_VIEW CONSTANT INTEGER := msc_gantt_utils.ORDER_VIEW;
16: RES_ACTIVITIES_VIEW CONSTANT INTEGER := msc_gantt_utils.RES_ACTIVITIES_VIEW;
17: RES_UNITS_VIEW CONSTANT INTEGER := msc_gantt_utils.RES_UNITS_VIEW;
18: RES_HOURS_VIEW CONSTANT INTEGER := msc_gantt_utils.RES_HOURS_VIEW;
19: SUPPLIER_VIEW CONSTANT INTEGER := msc_gantt_utils.SUPPLIER_VIEW;
20:
21: --node types
22: END_DEMAND_NODE constant INTEGER := msc_gantt_utils.END_DEMAND_NODE;
23: JOB_NODE constant INTEGER := msc_gantt_utils.JOB_NODE;
18: RES_HOURS_VIEW CONSTANT INTEGER := msc_gantt_utils.RES_HOURS_VIEW;
19: SUPPLIER_VIEW CONSTANT INTEGER := msc_gantt_utils.SUPPLIER_VIEW;
20:
21: --node types
22: END_DEMAND_NODE constant INTEGER := msc_gantt_utils.END_DEMAND_NODE;
23: JOB_NODE constant INTEGER := msc_gantt_utils.JOB_NODE;
24: OP_NODE constant INTEGER := msc_gantt_utils.OP_NODE;
25: RES_NODE constant INTEGER := msc_gantt_utils.RES_NODE;
26: -- END_JOB_NODE CONSTANT INTEGER := msc_gantt_utils.END_JOB_NODE;
19: SUPPLIER_VIEW CONSTANT INTEGER := msc_gantt_utils.SUPPLIER_VIEW;
20:
21: --node types
22: END_DEMAND_NODE constant INTEGER := msc_gantt_utils.END_DEMAND_NODE;
23: JOB_NODE constant INTEGER := msc_gantt_utils.JOB_NODE;
24: OP_NODE constant INTEGER := msc_gantt_utils.OP_NODE;
25: RES_NODE constant INTEGER := msc_gantt_utils.RES_NODE;
26: -- END_JOB_NODE CONSTANT INTEGER := msc_gantt_utils.END_JOB_NODE;
27: COPROD_NODE constant INTEGER := msc_gantt_utils.COPROD_NODE;
20:
21: --node types
22: END_DEMAND_NODE constant INTEGER := msc_gantt_utils.END_DEMAND_NODE;
23: JOB_NODE constant INTEGER := msc_gantt_utils.JOB_NODE;
24: OP_NODE constant INTEGER := msc_gantt_utils.OP_NODE;
25: RES_NODE constant INTEGER := msc_gantt_utils.RES_NODE;
26: -- END_JOB_NODE CONSTANT INTEGER := msc_gantt_utils.END_JOB_NODE;
27: COPROD_NODE constant INTEGER := msc_gantt_utils.COPROD_NODE;
28: RES_INST_NODE CONSTANT INTEGER := msc_gantt_utils.RES_INST_NODE;
21: --node types
22: END_DEMAND_NODE constant INTEGER := msc_gantt_utils.END_DEMAND_NODE;
23: JOB_NODE constant INTEGER := msc_gantt_utils.JOB_NODE;
24: OP_NODE constant INTEGER := msc_gantt_utils.OP_NODE;
25: RES_NODE constant INTEGER := msc_gantt_utils.RES_NODE;
26: -- END_JOB_NODE CONSTANT INTEGER := msc_gantt_utils.END_JOB_NODE;
27: COPROD_NODE constant INTEGER := msc_gantt_utils.COPROD_NODE;
28: RES_INST_NODE CONSTANT INTEGER := msc_gantt_utils.RES_INST_NODE;
29:
22: END_DEMAND_NODE constant INTEGER := msc_gantt_utils.END_DEMAND_NODE;
23: JOB_NODE constant INTEGER := msc_gantt_utils.JOB_NODE;
24: OP_NODE constant INTEGER := msc_gantt_utils.OP_NODE;
25: RES_NODE constant INTEGER := msc_gantt_utils.RES_NODE;
26: -- END_JOB_NODE CONSTANT INTEGER := msc_gantt_utils.END_JOB_NODE;
27: COPROD_NODE constant INTEGER := msc_gantt_utils.COPROD_NODE;
28: RES_INST_NODE CONSTANT INTEGER := msc_gantt_utils.RES_INST_NODE;
29:
30: --orders view types
23: JOB_NODE constant INTEGER := msc_gantt_utils.JOB_NODE;
24: OP_NODE constant INTEGER := msc_gantt_utils.OP_NODE;
25: RES_NODE constant INTEGER := msc_gantt_utils.RES_NODE;
26: -- END_JOB_NODE CONSTANT INTEGER := msc_gantt_utils.END_JOB_NODE;
27: COPROD_NODE constant INTEGER := msc_gantt_utils.COPROD_NODE;
28: RES_INST_NODE CONSTANT INTEGER := msc_gantt_utils.RES_INST_NODE;
29:
30: --orders view types
31: PEG_ORDERS constant integer := msc_gantt_utils.PEG_ORDERS;
24: OP_NODE constant INTEGER := msc_gantt_utils.OP_NODE;
25: RES_NODE constant INTEGER := msc_gantt_utils.RES_NODE;
26: -- END_JOB_NODE CONSTANT INTEGER := msc_gantt_utils.END_JOB_NODE;
27: COPROD_NODE constant INTEGER := msc_gantt_utils.COPROD_NODE;
28: RES_INST_NODE CONSTANT INTEGER := msc_gantt_utils.RES_INST_NODE;
29:
30: --orders view types
31: PEG_ORDERS constant integer := msc_gantt_utils.PEG_ORDERS;
32: PEG_DOWN constant integer := msc_gantt_utils.PEG_DOWN;
27: COPROD_NODE constant INTEGER := msc_gantt_utils.COPROD_NODE;
28: RES_INST_NODE CONSTANT INTEGER := msc_gantt_utils.RES_INST_NODE;
29:
30: --orders view types
31: PEG_ORDERS constant integer := msc_gantt_utils.PEG_ORDERS;
32: PEG_DOWN constant integer := msc_gantt_utils.PEG_DOWN;
33: PEG_UP constant integer := msc_gantt_utils.PEG_UP;
34: PEG_UP_AND_DOWN constant integer := msc_gantt_utils.PEG_UP_AND_DOWN;
35: SHOW_CHILDREN constant integer := msc_gantt_utils.SHOW_CHILDREN;
28: RES_INST_NODE CONSTANT INTEGER := msc_gantt_utils.RES_INST_NODE;
29:
30: --orders view types
31: PEG_ORDERS constant integer := msc_gantt_utils.PEG_ORDERS;
32: PEG_DOWN constant integer := msc_gantt_utils.PEG_DOWN;
33: PEG_UP constant integer := msc_gantt_utils.PEG_UP;
34: PEG_UP_AND_DOWN constant integer := msc_gantt_utils.PEG_UP_AND_DOWN;
35: SHOW_CHILDREN constant integer := msc_gantt_utils.SHOW_CHILDREN;
36: SHOW_PARENT constant integer := msc_gantt_utils.SHOW_PARENT;
29:
30: --orders view types
31: PEG_ORDERS constant integer := msc_gantt_utils.PEG_ORDERS;
32: PEG_DOWN constant integer := msc_gantt_utils.PEG_DOWN;
33: PEG_UP constant integer := msc_gantt_utils.PEG_UP;
34: PEG_UP_AND_DOWN constant integer := msc_gantt_utils.PEG_UP_AND_DOWN;
35: SHOW_CHILDREN constant integer := msc_gantt_utils.SHOW_CHILDREN;
36: SHOW_PARENT constant integer := msc_gantt_utils.SHOW_PARENT;
37: SHOW_PARENT_CHILDREN constant integer := msc_gantt_utils.SHOW_PARENT_CHILDREN;
30: --orders view types
31: PEG_ORDERS constant integer := msc_gantt_utils.PEG_ORDERS;
32: PEG_DOWN constant integer := msc_gantt_utils.PEG_DOWN;
33: PEG_UP constant integer := msc_gantt_utils.PEG_UP;
34: PEG_UP_AND_DOWN constant integer := msc_gantt_utils.PEG_UP_AND_DOWN;
35: SHOW_CHILDREN constant integer := msc_gantt_utils.SHOW_CHILDREN;
36: SHOW_PARENT constant integer := msc_gantt_utils.SHOW_PARENT;
37: SHOW_PARENT_CHILDREN constant integer := msc_gantt_utils.SHOW_PARENT_CHILDREN;
38:
31: PEG_ORDERS constant integer := msc_gantt_utils.PEG_ORDERS;
32: PEG_DOWN constant integer := msc_gantt_utils.PEG_DOWN;
33: PEG_UP constant integer := msc_gantt_utils.PEG_UP;
34: PEG_UP_AND_DOWN constant integer := msc_gantt_utils.PEG_UP_AND_DOWN;
35: SHOW_CHILDREN constant integer := msc_gantt_utils.SHOW_CHILDREN;
36: SHOW_PARENT constant integer := msc_gantt_utils.SHOW_PARENT;
37: SHOW_PARENT_CHILDREN constant integer := msc_gantt_utils.SHOW_PARENT_CHILDREN;
38:
39: --diff peg vs same peg orders view
32: PEG_DOWN constant integer := msc_gantt_utils.PEG_DOWN;
33: PEG_UP constant integer := msc_gantt_utils.PEG_UP;
34: PEG_UP_AND_DOWN constant integer := msc_gantt_utils.PEG_UP_AND_DOWN;
35: SHOW_CHILDREN constant integer := msc_gantt_utils.SHOW_CHILDREN;
36: SHOW_PARENT constant integer := msc_gantt_utils.SHOW_PARENT;
37: SHOW_PARENT_CHILDREN constant integer := msc_gantt_utils.SHOW_PARENT_CHILDREN;
38:
39: --diff peg vs same peg orders view
40: SAME_PEG constant INTEGER := msc_gantt_utils.SAME_PEG;
33: PEG_UP constant integer := msc_gantt_utils.PEG_UP;
34: PEG_UP_AND_DOWN constant integer := msc_gantt_utils.PEG_UP_AND_DOWN;
35: SHOW_CHILDREN constant integer := msc_gantt_utils.SHOW_CHILDREN;
36: SHOW_PARENT constant integer := msc_gantt_utils.SHOW_PARENT;
37: SHOW_PARENT_CHILDREN constant integer := msc_gantt_utils.SHOW_PARENT_CHILDREN;
38:
39: --diff peg vs same peg orders view
40: SAME_PEG constant INTEGER := msc_gantt_utils.SAME_PEG;
41: ALL_PEG constant INTEGER := msc_gantt_utils.ALL_PEG;
36: SHOW_PARENT constant integer := msc_gantt_utils.SHOW_PARENT;
37: SHOW_PARENT_CHILDREN constant integer := msc_gantt_utils.SHOW_PARENT_CHILDREN;
38:
39: --diff peg vs same peg orders view
40: SAME_PEG constant INTEGER := msc_gantt_utils.SAME_PEG;
41: ALL_PEG constant INTEGER := msc_gantt_utils.ALL_PEG;
42:
43: --parent id
44: SUMMARY_DATA constant integer := msc_gantt_utils.SUMMARY_DATA;
37: SHOW_PARENT_CHILDREN constant integer := msc_gantt_utils.SHOW_PARENT_CHILDREN;
38:
39: --diff peg vs same peg orders view
40: SAME_PEG constant INTEGER := msc_gantt_utils.SAME_PEG;
41: ALL_PEG constant INTEGER := msc_gantt_utils.ALL_PEG;
42:
43: --parent id
44: SUMMARY_DATA constant integer := msc_gantt_utils.SUMMARY_DATA;
45: DETAIL_DATA constant integer := msc_gantt_utils.DETAIL_DATA;
40: SAME_PEG constant INTEGER := msc_gantt_utils.SAME_PEG;
41: ALL_PEG constant INTEGER := msc_gantt_utils.ALL_PEG;
42:
43: --parent id
44: SUMMARY_DATA constant integer := msc_gantt_utils.SUMMARY_DATA;
45: DETAIL_DATA constant integer := msc_gantt_utils.DETAIL_DATA;
46:
47: -- res firm types
48: NO_FIRM CONSTANT INTEGER := msc_gantt_utils.NO_FIRM;
41: ALL_PEG constant INTEGER := msc_gantt_utils.ALL_PEG;
42:
43: --parent id
44: SUMMARY_DATA constant integer := msc_gantt_utils.SUMMARY_DATA;
45: DETAIL_DATA constant integer := msc_gantt_utils.DETAIL_DATA;
46:
47: -- res firm types
48: NO_FIRM CONSTANT INTEGER := msc_gantt_utils.NO_FIRM;
49: FIRM_START CONSTANT INTEGER := msc_gantt_utils.FIRM_START;
44: SUMMARY_DATA constant integer := msc_gantt_utils.SUMMARY_DATA;
45: DETAIL_DATA constant integer := msc_gantt_utils.DETAIL_DATA;
46:
47: -- res firm types
48: NO_FIRM CONSTANT INTEGER := msc_gantt_utils.NO_FIRM;
49: FIRM_START CONSTANT INTEGER := msc_gantt_utils.FIRM_START;
50: FIRM_END CONSTANT INTEGER := msc_gantt_utils.FIRM_END;
51: FIRM_RESOURCE CONSTANT INTEGER := msc_gantt_utils.FIRM_RESOURCE;
52: FIRM_START_END CONSTANT INTEGER := msc_gantt_utils.FIRM_START_END;
45: DETAIL_DATA constant integer := msc_gantt_utils.DETAIL_DATA;
46:
47: -- res firm types
48: NO_FIRM CONSTANT INTEGER := msc_gantt_utils.NO_FIRM;
49: FIRM_START CONSTANT INTEGER := msc_gantt_utils.FIRM_START;
50: FIRM_END CONSTANT INTEGER := msc_gantt_utils.FIRM_END;
51: FIRM_RESOURCE CONSTANT INTEGER := msc_gantt_utils.FIRM_RESOURCE;
52: FIRM_START_END CONSTANT INTEGER := msc_gantt_utils.FIRM_START_END;
53: FIRM_START_RES CONSTANT INTEGER := msc_gantt_utils.FIRM_START_RES;
46:
47: -- res firm types
48: NO_FIRM CONSTANT INTEGER := msc_gantt_utils.NO_FIRM;
49: FIRM_START CONSTANT INTEGER := msc_gantt_utils.FIRM_START;
50: FIRM_END CONSTANT INTEGER := msc_gantt_utils.FIRM_END;
51: FIRM_RESOURCE CONSTANT INTEGER := msc_gantt_utils.FIRM_RESOURCE;
52: FIRM_START_END CONSTANT INTEGER := msc_gantt_utils.FIRM_START_END;
53: FIRM_START_RES CONSTANT INTEGER := msc_gantt_utils.FIRM_START_RES;
54: FIRM_END_RES CONSTANT INTEGER := msc_gantt_utils.FIRM_END_RES;
47: -- res firm types
48: NO_FIRM CONSTANT INTEGER := msc_gantt_utils.NO_FIRM;
49: FIRM_START CONSTANT INTEGER := msc_gantt_utils.FIRM_START;
50: FIRM_END CONSTANT INTEGER := msc_gantt_utils.FIRM_END;
51: FIRM_RESOURCE CONSTANT INTEGER := msc_gantt_utils.FIRM_RESOURCE;
52: FIRM_START_END CONSTANT INTEGER := msc_gantt_utils.FIRM_START_END;
53: FIRM_START_RES CONSTANT INTEGER := msc_gantt_utils.FIRM_START_RES;
54: FIRM_END_RES CONSTANT INTEGER := msc_gantt_utils.FIRM_END_RES;
55: FIRM_ALL CONSTANT INTEGER := msc_gantt_utils.FIRM_ALL;
48: NO_FIRM CONSTANT INTEGER := msc_gantt_utils.NO_FIRM;
49: FIRM_START CONSTANT INTEGER := msc_gantt_utils.FIRM_START;
50: FIRM_END CONSTANT INTEGER := msc_gantt_utils.FIRM_END;
51: FIRM_RESOURCE CONSTANT INTEGER := msc_gantt_utils.FIRM_RESOURCE;
52: FIRM_START_END CONSTANT INTEGER := msc_gantt_utils.FIRM_START_END;
53: FIRM_START_RES CONSTANT INTEGER := msc_gantt_utils.FIRM_START_RES;
54: FIRM_END_RES CONSTANT INTEGER := msc_gantt_utils.FIRM_END_RES;
55: FIRM_ALL CONSTANT INTEGER := msc_gantt_utils.FIRM_ALL;
56:
49: FIRM_START CONSTANT INTEGER := msc_gantt_utils.FIRM_START;
50: FIRM_END CONSTANT INTEGER := msc_gantt_utils.FIRM_END;
51: FIRM_RESOURCE CONSTANT INTEGER := msc_gantt_utils.FIRM_RESOURCE;
52: FIRM_START_END CONSTANT INTEGER := msc_gantt_utils.FIRM_START_END;
53: FIRM_START_RES CONSTANT INTEGER := msc_gantt_utils.FIRM_START_RES;
54: FIRM_END_RES CONSTANT INTEGER := msc_gantt_utils.FIRM_END_RES;
55: FIRM_ALL CONSTANT INTEGER := msc_gantt_utils.FIRM_ALL;
56:
57: --display types for res activities /hours view
50: FIRM_END CONSTANT INTEGER := msc_gantt_utils.FIRM_END;
51: FIRM_RESOURCE CONSTANT INTEGER := msc_gantt_utils.FIRM_RESOURCE;
52: FIRM_START_END CONSTANT INTEGER := msc_gantt_utils.FIRM_START_END;
53: FIRM_START_RES CONSTANT INTEGER := msc_gantt_utils.FIRM_START_RES;
54: FIRM_END_RES CONSTANT INTEGER := msc_gantt_utils.FIRM_END_RES;
55: FIRM_ALL CONSTANT INTEGER := msc_gantt_utils.FIRM_ALL;
56:
57: --display types for res activities /hours view
58: DISPLAY_NONE constant integer := msc_gantt_utils.DISPLAY_NONE;
51: FIRM_RESOURCE CONSTANT INTEGER := msc_gantt_utils.FIRM_RESOURCE;
52: FIRM_START_END CONSTANT INTEGER := msc_gantt_utils.FIRM_START_END;
53: FIRM_START_RES CONSTANT INTEGER := msc_gantt_utils.FIRM_START_RES;
54: FIRM_END_RES CONSTANT INTEGER := msc_gantt_utils.FIRM_END_RES;
55: FIRM_ALL CONSTANT INTEGER := msc_gantt_utils.FIRM_ALL;
56:
57: --display types for res activities /hours view
58: DISPLAY_NONE constant integer := msc_gantt_utils.DISPLAY_NONE;
59: DISPLAY_LATE constant integer := msc_gantt_utils.DISPLAY_LATE;
54: FIRM_END_RES CONSTANT INTEGER := msc_gantt_utils.FIRM_END_RES;
55: FIRM_ALL CONSTANT INTEGER := msc_gantt_utils.FIRM_ALL;
56:
57: --display types for res activities /hours view
58: DISPLAY_NONE constant integer := msc_gantt_utils.DISPLAY_NONE;
59: DISPLAY_LATE constant integer := msc_gantt_utils.DISPLAY_LATE;
60: DISPLAY_EARLY constant integer := msc_gantt_utils.DISPLAY_EARLY;
61: DISPLAY_FIRM constant integer := msc_gantt_utils.DISPLAY_FIRM;
62: DISPLAY_OVERLOAD constant integer := msc_gantt_utils.DISPLAY_OVERLOAD;
55: FIRM_ALL CONSTANT INTEGER := msc_gantt_utils.FIRM_ALL;
56:
57: --display types for res activities /hours view
58: DISPLAY_NONE constant integer := msc_gantt_utils.DISPLAY_NONE;
59: DISPLAY_LATE constant integer := msc_gantt_utils.DISPLAY_LATE;
60: DISPLAY_EARLY constant integer := msc_gantt_utils.DISPLAY_EARLY;
61: DISPLAY_FIRM constant integer := msc_gantt_utils.DISPLAY_FIRM;
62: DISPLAY_OVERLOAD constant integer := msc_gantt_utils.DISPLAY_OVERLOAD;
63:
56:
57: --display types for res activities /hours view
58: DISPLAY_NONE constant integer := msc_gantt_utils.DISPLAY_NONE;
59: DISPLAY_LATE constant integer := msc_gantt_utils.DISPLAY_LATE;
60: DISPLAY_EARLY constant integer := msc_gantt_utils.DISPLAY_EARLY;
61: DISPLAY_FIRM constant integer := msc_gantt_utils.DISPLAY_FIRM;
62: DISPLAY_OVERLOAD constant integer := msc_gantt_utils.DISPLAY_OVERLOAD;
63:
64: --res row types
57: --display types for res activities /hours view
58: DISPLAY_NONE constant integer := msc_gantt_utils.DISPLAY_NONE;
59: DISPLAY_LATE constant integer := msc_gantt_utils.DISPLAY_LATE;
60: DISPLAY_EARLY constant integer := msc_gantt_utils.DISPLAY_EARLY;
61: DISPLAY_FIRM constant integer := msc_gantt_utils.DISPLAY_FIRM;
62: DISPLAY_OVERLOAD constant integer := msc_gantt_utils.DISPLAY_OVERLOAD;
63:
64: --res row types
65: RES_REQ_ROW_TYPE constant INTEGER := msc_gantt_utils.RES_REQ_ROW_TYPE;
58: DISPLAY_NONE constant integer := msc_gantt_utils.DISPLAY_NONE;
59: DISPLAY_LATE constant integer := msc_gantt_utils.DISPLAY_LATE;
60: DISPLAY_EARLY constant integer := msc_gantt_utils.DISPLAY_EARLY;
61: DISPLAY_FIRM constant integer := msc_gantt_utils.DISPLAY_FIRM;
62: DISPLAY_OVERLOAD constant integer := msc_gantt_utils.DISPLAY_OVERLOAD;
63:
64: --res row types
65: RES_REQ_ROW_TYPE constant INTEGER := msc_gantt_utils.RES_REQ_ROW_TYPE;
66: RES_ACT_BATCHED_ROW_TYPE constant integer := msc_gantt_utils.RES_ACT_BATCHED_ROW_TYPE;
61: DISPLAY_FIRM constant integer := msc_gantt_utils.DISPLAY_FIRM;
62: DISPLAY_OVERLOAD constant integer := msc_gantt_utils.DISPLAY_OVERLOAD;
63:
64: --res row types
65: RES_REQ_ROW_TYPE constant INTEGER := msc_gantt_utils.RES_REQ_ROW_TYPE;
66: RES_ACT_BATCHED_ROW_TYPE constant integer := msc_gantt_utils.RES_ACT_BATCHED_ROW_TYPE;
67:
68: --critical vs non critical orders view
69: NON_CRITICAL_PATH constant integer := msc_gantt_utils.NON_CRITICAL_PATH;
62: DISPLAY_OVERLOAD constant integer := msc_gantt_utils.DISPLAY_OVERLOAD;
63:
64: --res row types
65: RES_REQ_ROW_TYPE constant INTEGER := msc_gantt_utils.RES_REQ_ROW_TYPE;
66: RES_ACT_BATCHED_ROW_TYPE constant integer := msc_gantt_utils.RES_ACT_BATCHED_ROW_TYPE;
67:
68: --critical vs non critical orders view
69: NON_CRITICAL_PATH constant integer := msc_gantt_utils.NON_CRITICAL_PATH;
70: CRITICAL_PATH constant integer := msc_gantt_utils.CRITICAL_PATH;
65: RES_REQ_ROW_TYPE constant INTEGER := msc_gantt_utils.RES_REQ_ROW_TYPE;
66: RES_ACT_BATCHED_ROW_TYPE constant integer := msc_gantt_utils.RES_ACT_BATCHED_ROW_TYPE;
67:
68: --critical vs non critical orders view
69: NON_CRITICAL_PATH constant integer := msc_gantt_utils.NON_CRITICAL_PATH;
70: CRITICAL_PATH constant integer := msc_gantt_utils.CRITICAL_PATH;
71:
72: --filter types
73: FILTER_TYPE_LIST constant integer := msc_gantt_utils.FILTER_TYPE_LIST;
66: RES_ACT_BATCHED_ROW_TYPE constant integer := msc_gantt_utils.RES_ACT_BATCHED_ROW_TYPE;
67:
68: --critical vs non critical orders view
69: NON_CRITICAL_PATH constant integer := msc_gantt_utils.NON_CRITICAL_PATH;
70: CRITICAL_PATH constant integer := msc_gantt_utils.CRITICAL_PATH;
71:
72: --filter types
73: FILTER_TYPE_LIST constant integer := msc_gantt_utils.FILTER_TYPE_LIST;
74: FILTER_TYPE_MFQ constant integer := msc_gantt_utils.FILTER_TYPE_MFQ;
69: NON_CRITICAL_PATH constant integer := msc_gantt_utils.NON_CRITICAL_PATH;
70: CRITICAL_PATH constant integer := msc_gantt_utils.CRITICAL_PATH;
71:
72: --filter types
73: FILTER_TYPE_LIST constant integer := msc_gantt_utils.FILTER_TYPE_LIST;
74: FILTER_TYPE_MFQ constant integer := msc_gantt_utils.FILTER_TYPE_MFQ;
75: FILTER_TYPE_FOLDER_ID constant integer := msc_gantt_utils.FILTER_TYPE_FOLDER_ID;
76: FILTER_TYPE_WHERE_STMT constant integer := msc_gantt_utils.FILTER_TYPE_WHERE_STMT;
77: FILTER_TYPE_AMONG constant integer := msc_gantt_utils.FILTER_TYPE_AMONG;
70: CRITICAL_PATH constant integer := msc_gantt_utils.CRITICAL_PATH;
71:
72: --filter types
73: FILTER_TYPE_LIST constant integer := msc_gantt_utils.FILTER_TYPE_LIST;
74: FILTER_TYPE_MFQ constant integer := msc_gantt_utils.FILTER_TYPE_MFQ;
75: FILTER_TYPE_FOLDER_ID constant integer := msc_gantt_utils.FILTER_TYPE_FOLDER_ID;
76: FILTER_TYPE_WHERE_STMT constant integer := msc_gantt_utils.FILTER_TYPE_WHERE_STMT;
77: FILTER_TYPE_AMONG constant integer := msc_gantt_utils.FILTER_TYPE_AMONG;
78:
71:
72: --filter types
73: FILTER_TYPE_LIST constant integer := msc_gantt_utils.FILTER_TYPE_LIST;
74: FILTER_TYPE_MFQ constant integer := msc_gantt_utils.FILTER_TYPE_MFQ;
75: FILTER_TYPE_FOLDER_ID constant integer := msc_gantt_utils.FILTER_TYPE_FOLDER_ID;
76: FILTER_TYPE_WHERE_STMT constant integer := msc_gantt_utils.FILTER_TYPE_WHERE_STMT;
77: FILTER_TYPE_AMONG constant integer := msc_gantt_utils.FILTER_TYPE_AMONG;
78:
79: --misc
72: --filter types
73: FILTER_TYPE_LIST constant integer := msc_gantt_utils.FILTER_TYPE_LIST;
74: FILTER_TYPE_MFQ constant integer := msc_gantt_utils.FILTER_TYPE_MFQ;
75: FILTER_TYPE_FOLDER_ID constant integer := msc_gantt_utils.FILTER_TYPE_FOLDER_ID;
76: FILTER_TYPE_WHERE_STMT constant integer := msc_gantt_utils.FILTER_TYPE_WHERE_STMT;
77: FILTER_TYPE_AMONG constant integer := msc_gantt_utils.FILTER_TYPE_AMONG;
78:
79: --misc
80: MBP_NULL_VALUE constant integer := msc_gantt_utils.MBP_NULL_VALUE;
73: FILTER_TYPE_LIST constant integer := msc_gantt_utils.FILTER_TYPE_LIST;
74: FILTER_TYPE_MFQ constant integer := msc_gantt_utils.FILTER_TYPE_MFQ;
75: FILTER_TYPE_FOLDER_ID constant integer := msc_gantt_utils.FILTER_TYPE_FOLDER_ID;
76: FILTER_TYPE_WHERE_STMT constant integer := msc_gantt_utils.FILTER_TYPE_WHERE_STMT;
77: FILTER_TYPE_AMONG constant integer := msc_gantt_utils.FILTER_TYPE_AMONG;
78:
79: --misc
80: MBP_NULL_VALUE constant integer := msc_gantt_utils.MBP_NULL_VALUE;
81: MBP_NULL_VALUE_CHAR constant varchar2(30) := msc_gantt_utils.MBP_NULL_VALUE_CHAR;
76: FILTER_TYPE_WHERE_STMT constant integer := msc_gantt_utils.FILTER_TYPE_WHERE_STMT;
77: FILTER_TYPE_AMONG constant integer := msc_gantt_utils.FILTER_TYPE_AMONG;
78:
79: --misc
80: MBP_NULL_VALUE constant integer := msc_gantt_utils.MBP_NULL_VALUE;
81: MBP_NULL_VALUE_CHAR constant varchar2(30) := msc_gantt_utils.MBP_NULL_VALUE_CHAR;
82: NULL_SPACE constant varchar2(1) := msc_gantt_utils.NULL_SPACE;
83:
84: SYS_YES constant INTEGER := msc_gantt_utils.SYS_YES;
77: FILTER_TYPE_AMONG constant integer := msc_gantt_utils.FILTER_TYPE_AMONG;
78:
79: --misc
80: MBP_NULL_VALUE constant integer := msc_gantt_utils.MBP_NULL_VALUE;
81: MBP_NULL_VALUE_CHAR constant varchar2(30) := msc_gantt_utils.MBP_NULL_VALUE_CHAR;
82: NULL_SPACE constant varchar2(1) := msc_gantt_utils.NULL_SPACE;
83:
84: SYS_YES constant INTEGER := msc_gantt_utils.SYS_YES;
85: SYS_NO constant INTEGER := msc_gantt_utils.SYS_NO;
78:
79: --misc
80: MBP_NULL_VALUE constant integer := msc_gantt_utils.MBP_NULL_VALUE;
81: MBP_NULL_VALUE_CHAR constant varchar2(30) := msc_gantt_utils.MBP_NULL_VALUE_CHAR;
82: NULL_SPACE constant varchar2(1) := msc_gantt_utils.NULL_SPACE;
83:
84: SYS_YES constant INTEGER := msc_gantt_utils.SYS_YES;
85: SYS_NO constant INTEGER := msc_gantt_utils.SYS_NO;
86:
80: MBP_NULL_VALUE constant integer := msc_gantt_utils.MBP_NULL_VALUE;
81: MBP_NULL_VALUE_CHAR constant varchar2(30) := msc_gantt_utils.MBP_NULL_VALUE_CHAR;
82: NULL_SPACE constant varchar2(1) := msc_gantt_utils.NULL_SPACE;
83:
84: SYS_YES constant INTEGER := msc_gantt_utils.SYS_YES;
85: SYS_NO constant INTEGER := msc_gantt_utils.SYS_NO;
86:
87:
88: TRANSFER_JOB_NODE constant integer := 1;
81: MBP_NULL_VALUE_CHAR constant varchar2(30) := msc_gantt_utils.MBP_NULL_VALUE_CHAR;
82: NULL_SPACE constant varchar2(1) := msc_gantt_utils.NULL_SPACE;
83:
84: SYS_YES constant INTEGER := msc_gantt_utils.SYS_YES;
85: SYS_NO constant INTEGER := msc_gantt_utils.SYS_NO;
86:
87:
88: TRANSFER_JOB_NODE constant integer := 1;
89: OP_JOB_NODE constant integer := 2;
149: cursor end_pegs_cur (x_plan_id number, x_demand_id number) is
150: select distinct ms.sr_instance_id,
151: ms.organization_id,
152: ms.transaction_id,
153: msc_gantt_utils.isCriticalSupply(x_plan_id, g_end_demand_id,
154: ms.transaction_id, ms.sr_instance_id) critical_supply
155: from msc_full_pegging mfp,
156: msc_supplies ms
157: where mfp.demand_id = x_demand_id
237: nvl(mrr.department_id, 0) department_id,
238: nvl(mrr.resource_id, 0) resource_id,
239: mrr.transaction_id,
240: decode(g_end_demand_id, null, 0,
241: msc_gantt_utils.isCriticalRes(x_plan_id,g_end_demand_id,
242: ms.transaction_id, ms.sr_instance_id,
243: mrr.operation_seq_num, mrr.routing_sequence_id)) critical_flag,
244: mrr.operation_seq_num,
245: mrr.resource_seq_num
268: mfq.number4,
269: mfq.number5,
270: mfq.number3,
271: decode(g_end_demand_id, null, 0,
272: msc_gantt_utils.isCriticalSupply(ms.plan_id, g_end_demand_id,
273: ms.transaction_id, ms.sr_instance_id)) critical_supply,
274: msc_gantt_utils.getActualStartDate(ms.order_type, msi.planning_make_buy_code,
275: ms.organization_id, ms.source_organization_id, ms.new_dock_date,
276: ms.new_wip_start_date, ms.new_ship_date,ms.new_schedule_date,
270: mfq.number3,
271: decode(g_end_demand_id, null, 0,
272: msc_gantt_utils.isCriticalSupply(ms.plan_id, g_end_demand_id,
273: ms.transaction_id, ms.sr_instance_id)) critical_supply,
274: msc_gantt_utils.getActualStartDate(ms.order_type, msi.planning_make_buy_code,
275: ms.organization_id, ms.source_organization_id, ms.new_dock_date,
276: ms.new_wip_start_date, ms.new_ship_date,ms.new_schedule_date,
277: ms.source_supplier_id) start_date,
278: ms.order_type
287: and ms.plan_id = msi.plan_id
288: and ms.organization_id = msi.organization_id
289: and ms.sr_instance_id = msi.sr_instance_id
290: and ms.inventory_item_id = msi.inventory_item_id
291: order by msc_gantt_utils.getActualStartDate(ms.order_type, msi.planning_make_buy_code,
292: ms.organization_id, ms.source_organization_id, ms.new_dock_date,
293: ms.new_wip_start_date, ms.new_ship_date,ms.new_schedule_date,
294: ms.source_supplier_id) desc;
295:
300: select distinct ms.sr_instance_id,
301: ms.organization_id,
302: ms.transaction_id,
303: decode(g_end_demand_id, null, 0,
304: msc_gantt_utils.isCriticalSupply(ms.plan_id, g_end_demand_id,
305: ms.transaction_id, ms.sr_instance_id)) critical_supply,
306: msc_gantt_utils.getActualStartDate(ms.order_type, msi.planning_make_buy_code,
307: ms.organization_id, ms.source_organization_id, ms.new_dock_date,
308: ms.new_wip_start_date, ms.new_ship_date,ms.new_schedule_date,
302: ms.transaction_id,
303: decode(g_end_demand_id, null, 0,
304: msc_gantt_utils.isCriticalSupply(ms.plan_id, g_end_demand_id,
305: ms.transaction_id, ms.sr_instance_id)) critical_supply,
306: msc_gantt_utils.getActualStartDate(ms.order_type, msi.planning_make_buy_code,
307: ms.organization_id, ms.source_organization_id, ms.new_dock_date,
308: ms.new_wip_start_date, ms.new_ship_date,ms.new_schedule_date,
309: ms.source_supplier_id) start_date,
310: ms.order_type
333: and ms.plan_id = msi.plan_id
334: and ms.organization_id = msi.organization_id
335: and ms.sr_instance_id = msi.sr_instance_id
336: and ms.inventory_item_id = msi.inventory_item_id
337: order by msc_gantt_utils.getActualStartDate(ms.order_type, msi.planning_make_buy_code,
338: ms.organization_id, ms.source_organization_id, ms.new_dock_date,
339: ms.new_wip_start_date, ms.new_ship_date,ms.new_schedule_date,
340: ms.source_supplier_id) desc;
341:
346: select distinct ms.sr_instance_id,
347: ms.organization_id,
348: ms.transaction_id,
349: decode(g_end_demand_id, null, 0,
350: msc_gantt_utils.isCriticalSupply(ms.plan_id, g_end_demand_id,
351: ms.transaction_id, ms.sr_instance_id)) critical_supply,
352: msc_gantt_utils.getActualStartDate(ms.order_type, msi.planning_make_buy_code,
353: ms.organization_id, ms.source_organization_id, ms.new_dock_date,
354: ms.new_wip_start_date, ms.new_ship_date,ms.new_schedule_date,
348: ms.transaction_id,
349: decode(g_end_demand_id, null, 0,
350: msc_gantt_utils.isCriticalSupply(ms.plan_id, g_end_demand_id,
351: ms.transaction_id, ms.sr_instance_id)) critical_supply,
352: msc_gantt_utils.getActualStartDate(ms.order_type, msi.planning_make_buy_code,
353: ms.organization_id, ms.source_organization_id, ms.new_dock_date,
354: ms.new_wip_start_date, ms.new_ship_date,ms.new_schedule_date,
355: ms.source_supplier_id) start_date,
356: ms.order_type
369: and ms.plan_id = msi.plan_id
370: and ms.organization_id = msi.organization_id
371: and ms.sr_instance_id = msi.sr_instance_id
372: and ms.inventory_item_id = msi.inventory_item_id
373: order by msc_gantt_utils.getActualStartDate(ms.order_type, msi.planning_make_buy_code,
374: ms.organization_id, ms.source_organization_id, ms.new_dock_date,
375: ms.new_wip_start_date, ms.new_ship_date,ms.new_schedule_date,
376: ms.source_supplier_id) desc;
377:
382: select distinct ms.sr_instance_id,
383: ms.organization_id,
384: ms.transaction_id,
385: decode(g_end_demand_id, null, 0,
386: msc_gantt_utils.isCriticalSupply(ms.plan_id, g_end_demand_id,
387: ms.transaction_id, ms.sr_instance_id)) critical_supply,
388: msc_gantt_utils.getActualStartDate(ms.order_type, msi.planning_make_buy_code,
389: ms.organization_id, ms.source_organization_id, ms.new_dock_date,
390: ms.new_wip_start_date, ms.new_ship_date,ms.new_schedule_date,
384: ms.transaction_id,
385: decode(g_end_demand_id, null, 0,
386: msc_gantt_utils.isCriticalSupply(ms.plan_id, g_end_demand_id,
387: ms.transaction_id, ms.sr_instance_id)) critical_supply,
388: msc_gantt_utils.getActualStartDate(ms.order_type, msi.planning_make_buy_code,
389: ms.organization_id, ms.source_organization_id, ms.new_dock_date,
390: ms.new_wip_start_date, ms.new_ship_date,ms.new_schedule_date,
391: ms.source_supplier_id) start_date,
392: ms.order_type
412: and ms.plan_id = msi.plan_id
413: and ms.organization_id = msi.organization_id
414: and ms.sr_instance_id = msi.sr_instance_id
415: and ms.inventory_item_id = msi.inventory_item_id
416: order by msc_gantt_utils.getActualStartDate(ms.order_type, msi.planning_make_buy_code,
417: ms.organization_id, ms.source_organization_id, ms.new_dock_date,
418: ms.new_wip_start_date, ms.new_ship_date,ms.new_schedule_date,
419: ms.source_supplier_id) desc;
420:
424: select distinct ms.sr_instance_id,
425: ms.organization_id,
426: ms.transaction_id,
427: decode(g_end_demand_id, null, 0,
428: msc_gantt_utils.isCriticalSupply(x_plan_id,g_end_demand_id,
429: ms.transaction_id, ms.sr_instance_id)) critical_supply,
430: ms.new_wip_start_date start_date,
431: ms.order_type
432: from msc_supplies ms
448: decode(md.op_seq_num, 1, x_first_op, md.op_seq_num),
449: ms.transaction_id,
450: ms.sr_instance_id,
451: ms.organization_id,
452: msc_gantt_utils.isCriticalSupply(ms.plan_id, g_end_demand_id,
453: ms.transaction_id, ms.sr_instance_id) critical_supply
454: from msc_full_pegging mfp1,
455: msc_full_pegging mfp2,
456: msc_supplies ms,
480: decode(md.op_seq_num, 1, x_first_op, md.op_seq_num),
481: ms.transaction_id,
482: ms.sr_instance_id,
483: ms.organization_id,
484: msc_gantt_utils.isCriticalSupply(ms.plan_id, g_end_demand_id,
485: ms.transaction_id, ms.sr_instance_id) critical_supply
486: from msc_full_pegging mfp1,
487: msc_full_pegging mfp2,
488: msc_supplies ms,
703:
704: if ( nvl(l_row_index, mbp_null_value) = mbp_null_value) then
705: g_node_index := g_node_index + g_peg_type;
706:
707: msc_gantt_utils.populateRowKeysIntoGantt(
708: p_query_id => g_order_query_id,
709: p_index => g_node_index,
710: p_node_path => g_node_index,
711: p_node_type => END_DEMAND_NODE,
727: procedure addResources(p_nodepath varchar2,
728: p_instance_id number, p_org_id number,
729: p_supply_id number, p_op_seq_id number) is
730:
731: l_trans_id msc_gantt_utils.number_arr;
732: l_dept_id msc_gantt_utils.number_arr;
733: l_res_id msc_gantt_utils.number_arr;
734: l_critical_flag msc_gantt_utils.number_arr;
735: l_op_seq_num msc_gantt_utils.number_arr;
728: p_instance_id number, p_org_id number,
729: p_supply_id number, p_op_seq_id number) is
730:
731: l_trans_id msc_gantt_utils.number_arr;
732: l_dept_id msc_gantt_utils.number_arr;
733: l_res_id msc_gantt_utils.number_arr;
734: l_critical_flag msc_gantt_utils.number_arr;
735: l_op_seq_num msc_gantt_utils.number_arr;
736: l_res_seq_num msc_gantt_utils.number_arr;
729: p_supply_id number, p_op_seq_id number) is
730:
731: l_trans_id msc_gantt_utils.number_arr;
732: l_dept_id msc_gantt_utils.number_arr;
733: l_res_id msc_gantt_utils.number_arr;
734: l_critical_flag msc_gantt_utils.number_arr;
735: l_op_seq_num msc_gantt_utils.number_arr;
736: l_res_seq_num msc_gantt_utils.number_arr;
737:
730:
731: l_trans_id msc_gantt_utils.number_arr;
732: l_dept_id msc_gantt_utils.number_arr;
733: l_res_id msc_gantt_utils.number_arr;
734: l_critical_flag msc_gantt_utils.number_arr;
735: l_op_seq_num msc_gantt_utils.number_arr;
736: l_res_seq_num msc_gantt_utils.number_arr;
737:
738: l_child_count number := 0;
731: l_trans_id msc_gantt_utils.number_arr;
732: l_dept_id msc_gantt_utils.number_arr;
733: l_res_id msc_gantt_utils.number_arr;
734: l_critical_flag msc_gantt_utils.number_arr;
735: l_op_seq_num msc_gantt_utils.number_arr;
736: l_res_seq_num msc_gantt_utils.number_arr;
737:
738: l_child_count number := 0;
739: begin
732: l_dept_id msc_gantt_utils.number_arr;
733: l_res_id msc_gantt_utils.number_arr;
734: l_critical_flag msc_gantt_utils.number_arr;
735: l_op_seq_num msc_gantt_utils.number_arr;
736: l_res_seq_num msc_gantt_utils.number_arr;
737:
738: l_child_count number := 0;
739: begin
740: open resources_cur (g_plan_id, p_instance_id, p_org_id, p_supply_id, p_op_seq_id);
749: else
750: g_node_index := g_node_index + g_peg_type;
751: end if;
752:
753: msc_gantt_utils.populateRowKeysIntoGantt(
754: p_query_id => g_order_query_id,
755: p_index => g_node_index,
756: p_node_path => p_nodepath||COLON_SEPARATOR||to_char(l_child_count),
757: p_node_type => RES_NODE,
827: else
828: g_node_index := g_node_index + g_peg_type;
829: end if;
830:
831: msc_gantt_utils.populateRowKeysIntoGantt(
832: p_query_id => g_order_query_id,
833: p_index => g_node_index,
834: p_node_path => p_nodepath||COLON_SEPARATOR||to_char(l_child_count),
835: p_node_type => OP_NODE,
875: select distinct
876: g_op_query_id,
877: trunc(sysdate), -1, trunc(sysdate), -1, -1,
878: p_supply_id, mrr.operation_seq_num,
879: msc_gantt_utils.isCriticalRes(g_plan_id, g_end_demand_id,
880: mrr.supply_id, mrr.sr_instance_id,
881: mrr.operation_seq_num, mrr.routing_sequence_id) critical_flag,
882: mro.operation_description op_desc,
883: mrr.start_date
899:
900: procedure insertOpJobFromMDIntoMFQ (p_first_op number,
901: p_instance_id number, p_org_id number, p_supply_id number) is
902:
903: l_inst_id msc_gantt_utils.number_arr;
904: l_org_id msc_gantt_utils.number_arr;
905: l_trans_id msc_gantt_utils.number_arr;
906: l_op_seq_num msc_gantt_utils.number_arr;
907: l_critical_flag msc_gantt_utils.number_arr;
900: procedure insertOpJobFromMDIntoMFQ (p_first_op number,
901: p_instance_id number, p_org_id number, p_supply_id number) is
902:
903: l_inst_id msc_gantt_utils.number_arr;
904: l_org_id msc_gantt_utils.number_arr;
905: l_trans_id msc_gantt_utils.number_arr;
906: l_op_seq_num msc_gantt_utils.number_arr;
907: l_critical_flag msc_gantt_utils.number_arr;
908: begin
901: p_instance_id number, p_org_id number, p_supply_id number) is
902:
903: l_inst_id msc_gantt_utils.number_arr;
904: l_org_id msc_gantt_utils.number_arr;
905: l_trans_id msc_gantt_utils.number_arr;
906: l_op_seq_num msc_gantt_utils.number_arr;
907: l_critical_flag msc_gantt_utils.number_arr;
908: begin
909: if ( g_same_peg = SAME_PEG ) then -- {
902:
903: l_inst_id msc_gantt_utils.number_arr;
904: l_org_id msc_gantt_utils.number_arr;
905: l_trans_id msc_gantt_utils.number_arr;
906: l_op_seq_num msc_gantt_utils.number_arr;
907: l_critical_flag msc_gantt_utils.number_arr;
908: begin
909: if ( g_same_peg = SAME_PEG ) then -- {
910: open op_supp_same_down_cur (g_plan_id, p_instance_id, p_supply_id,
903: l_inst_id msc_gantt_utils.number_arr;
904: l_org_id msc_gantt_utils.number_arr;
905: l_trans_id msc_gantt_utils.number_arr;
906: l_op_seq_num msc_gantt_utils.number_arr;
907: l_critical_flag msc_gantt_utils.number_arr;
908: begin
909: if ( g_same_peg = SAME_PEG ) then -- {
910: open op_supp_same_down_cur (g_plan_id, p_instance_id, p_supply_id,
911: g_end_peg_query_id, p_first_op);
938: -- if op exists in msc_demand but not in msc_resource_requirements,
939: -- show the op in the closest next op or prev op
940: procedure moveDmdOp(p_supply_id number) is
941:
942: v_op msc_gantt_utils.number_arr;
943: v_new_op msc_gantt_utils.number_arr;
944: v_dummy number;
945:
946: begin
939: -- show the op in the closest next op or prev op
940: procedure moveDmdOp(p_supply_id number) is
941:
942: v_op msc_gantt_utils.number_arr;
943: v_new_op msc_gantt_utils.number_arr;
944: v_dummy number;
945:
946: begin
947: select distinct mfq.number2, mfq.number2
1019:
1020: procedure addCoProdNodes(p_parent_index number,
1021: p_instance_id number, p_org_id number, p_supply_id number) is
1022:
1023: l_inst_id msc_gantt_utils.number_arr;
1024: l_org_id msc_gantt_utils.number_arr;
1025: l_trans_id msc_gantt_utils.number_arr;
1026: l_op_seq_num msc_gantt_utils.number_arr;
1027: l_critical_flag msc_gantt_utils.number_arr;
1020: procedure addCoProdNodes(p_parent_index number,
1021: p_instance_id number, p_org_id number, p_supply_id number) is
1022:
1023: l_inst_id msc_gantt_utils.number_arr;
1024: l_org_id msc_gantt_utils.number_arr;
1025: l_trans_id msc_gantt_utils.number_arr;
1026: l_op_seq_num msc_gantt_utils.number_arr;
1027: l_critical_flag msc_gantt_utils.number_arr;
1028: l_start_date msc_gantt_utils.char_arr;
1021: p_instance_id number, p_org_id number, p_supply_id number) is
1022:
1023: l_inst_id msc_gantt_utils.number_arr;
1024: l_org_id msc_gantt_utils.number_arr;
1025: l_trans_id msc_gantt_utils.number_arr;
1026: l_op_seq_num msc_gantt_utils.number_arr;
1027: l_critical_flag msc_gantt_utils.number_arr;
1028: l_start_date msc_gantt_utils.char_arr;
1029: l_ordertype msc_gantt_utils.number_arr;
1022:
1023: l_inst_id msc_gantt_utils.number_arr;
1024: l_org_id msc_gantt_utils.number_arr;
1025: l_trans_id msc_gantt_utils.number_arr;
1026: l_op_seq_num msc_gantt_utils.number_arr;
1027: l_critical_flag msc_gantt_utils.number_arr;
1028: l_start_date msc_gantt_utils.char_arr;
1029: l_ordertype msc_gantt_utils.number_arr;
1030:
1023: l_inst_id msc_gantt_utils.number_arr;
1024: l_org_id msc_gantt_utils.number_arr;
1025: l_trans_id msc_gantt_utils.number_arr;
1026: l_op_seq_num msc_gantt_utils.number_arr;
1027: l_critical_flag msc_gantt_utils.number_arr;
1028: l_start_date msc_gantt_utils.char_arr;
1029: l_ordertype msc_gantt_utils.number_arr;
1030:
1031: cursor c_order_type (p_plan number, p_inst number, p_trx number) is
1024: l_org_id msc_gantt_utils.number_arr;
1025: l_trans_id msc_gantt_utils.number_arr;
1026: l_op_seq_num msc_gantt_utils.number_arr;
1027: l_critical_flag msc_gantt_utils.number_arr;
1028: l_start_date msc_gantt_utils.char_arr;
1029: l_ordertype msc_gantt_utils.number_arr;
1030:
1031: cursor c_order_type (p_plan number, p_inst number, p_trx number) is
1032: select ms.order_type, ms.disposition_id
1025: l_trans_id msc_gantt_utils.number_arr;
1026: l_op_seq_num msc_gantt_utils.number_arr;
1027: l_critical_flag msc_gantt_utils.number_arr;
1028: l_start_date msc_gantt_utils.char_arr;
1029: l_ordertype msc_gantt_utils.number_arr;
1030:
1031: cursor c_order_type (p_plan number, p_inst number, p_trx number) is
1032: select ms.order_type, ms.disposition_id
1033: from msc_supplies ms
1069: end if;
1070:
1071: put_line('addcoprodnodes p_supply_id '|| p_supply_id ||' l_trans_id '||l_trans_id(i) );
1072:
1073: msc_gantt_utils.populateRowKeysIntoGantt(
1074: p_query_id => g_order_query_id,
1075: p_index => g_node_index,
1076: p_node_path => g_node_index,
1077: p_node_type => l_node_type,
1091:
1092: l_parent_link msc_gantt_query.parent_link%type;
1093: l_first_op number;
1094:
1095: l_inst_id msc_gantt_utils.number_arr;
1096: l_org_id msc_gantt_utils.number_arr;
1097: l_trans_id msc_gantt_utils.number_arr;
1098: l_critical_flag msc_gantt_utils.number_arr;
1099: l_start_date msc_gantt_utils.char_arr;
1092: l_parent_link msc_gantt_query.parent_link%type;
1093: l_first_op number;
1094:
1095: l_inst_id msc_gantt_utils.number_arr;
1096: l_org_id msc_gantt_utils.number_arr;
1097: l_trans_id msc_gantt_utils.number_arr;
1098: l_critical_flag msc_gantt_utils.number_arr;
1099: l_start_date msc_gantt_utils.char_arr;
1100: l_order_type msc_gantt_utils.number_arr;
1093: l_first_op number;
1094:
1095: l_inst_id msc_gantt_utils.number_arr;
1096: l_org_id msc_gantt_utils.number_arr;
1097: l_trans_id msc_gantt_utils.number_arr;
1098: l_critical_flag msc_gantt_utils.number_arr;
1099: l_start_date msc_gantt_utils.char_arr;
1100: l_order_type msc_gantt_utils.number_arr;
1101:
1094:
1095: l_inst_id msc_gantt_utils.number_arr;
1096: l_org_id msc_gantt_utils.number_arr;
1097: l_trans_id msc_gantt_utils.number_arr;
1098: l_critical_flag msc_gantt_utils.number_arr;
1099: l_start_date msc_gantt_utils.char_arr;
1100: l_order_type msc_gantt_utils.number_arr;
1101:
1102: l_row_type number;
1095: l_inst_id msc_gantt_utils.number_arr;
1096: l_org_id msc_gantt_utils.number_arr;
1097: l_trans_id msc_gantt_utils.number_arr;
1098: l_critical_flag msc_gantt_utils.number_arr;
1099: l_start_date msc_gantt_utils.char_arr;
1100: l_order_type msc_gantt_utils.number_arr;
1101:
1102: l_row_type number;
1103: l_row_index number;
1096: l_org_id msc_gantt_utils.number_arr;
1097: l_trans_id msc_gantt_utils.number_arr;
1098: l_critical_flag msc_gantt_utils.number_arr;
1099: l_start_date msc_gantt_utils.char_arr;
1100: l_order_type msc_gantt_utils.number_arr;
1101:
1102: l_row_type number;
1103: l_row_index number;
1104: begin
1124: if (nvl(l_row_index, mbp_null_value) = mbp_null_value) then
1125:
1126: g_node_index := g_node_index + g_peg_type;
1127:
1128: msc_gantt_utils.populateRowKeysIntoGantt(
1129: p_query_id => g_order_query_id,
1130: p_index => g_node_index,
1131: p_node_path => g_node_index,
1132: p_node_type => JOB_NODE,
1184: p_supply_id number, p_fetch_type number) is
1185:
1186: l_parent_link msc_gantt_query.parent_link%type;
1187:
1188: l_inst_id msc_gantt_utils.number_arr;
1189: l_org_id msc_gantt_utils.number_arr;
1190: l_trans_id msc_gantt_utils.number_arr;
1191: l_op_seq_num msc_gantt_utils.number_arr;
1192: l_critical_flag msc_gantt_utils.number_arr;
1185:
1186: l_parent_link msc_gantt_query.parent_link%type;
1187:
1188: l_inst_id msc_gantt_utils.number_arr;
1189: l_org_id msc_gantt_utils.number_arr;
1190: l_trans_id msc_gantt_utils.number_arr;
1191: l_op_seq_num msc_gantt_utils.number_arr;
1192: l_critical_flag msc_gantt_utils.number_arr;
1193: l_start_date msc_gantt_utils.char_arr;
1186: l_parent_link msc_gantt_query.parent_link%type;
1187:
1188: l_inst_id msc_gantt_utils.number_arr;
1189: l_org_id msc_gantt_utils.number_arr;
1190: l_trans_id msc_gantt_utils.number_arr;
1191: l_op_seq_num msc_gantt_utils.number_arr;
1192: l_critical_flag msc_gantt_utils.number_arr;
1193: l_start_date msc_gantt_utils.char_arr;
1194: l_order_type msc_gantt_utils.number_arr;
1187:
1188: l_inst_id msc_gantt_utils.number_arr;
1189: l_org_id msc_gantt_utils.number_arr;
1190: l_trans_id msc_gantt_utils.number_arr;
1191: l_op_seq_num msc_gantt_utils.number_arr;
1192: l_critical_flag msc_gantt_utils.number_arr;
1193: l_start_date msc_gantt_utils.char_arr;
1194: l_order_type msc_gantt_utils.number_arr;
1195:
1188: l_inst_id msc_gantt_utils.number_arr;
1189: l_org_id msc_gantt_utils.number_arr;
1190: l_trans_id msc_gantt_utils.number_arr;
1191: l_op_seq_num msc_gantt_utils.number_arr;
1192: l_critical_flag msc_gantt_utils.number_arr;
1193: l_start_date msc_gantt_utils.char_arr;
1194: l_order_type msc_gantt_utils.number_arr;
1195:
1196: l_node_type number;
1189: l_org_id msc_gantt_utils.number_arr;
1190: l_trans_id msc_gantt_utils.number_arr;
1191: l_op_seq_num msc_gantt_utils.number_arr;
1192: l_critical_flag msc_gantt_utils.number_arr;
1193: l_start_date msc_gantt_utils.char_arr;
1194: l_order_type msc_gantt_utils.number_arr;
1195:
1196: l_node_type number;
1197:
1190: l_trans_id msc_gantt_utils.number_arr;
1191: l_op_seq_num msc_gantt_utils.number_arr;
1192: l_critical_flag msc_gantt_utils.number_arr;
1193: l_start_date msc_gantt_utils.char_arr;
1194: l_order_type msc_gantt_utils.number_arr;
1195:
1196: l_node_type number;
1197:
1198: l_dup_row_index number;
1251: else
1252: l_node_type := JOB_NODE;
1253: end if;
1254:
1255: msc_gantt_utils.populateRowKeysIntoGantt(
1256: p_query_id => g_order_query_id,
1257: p_index => g_node_index,
1258: p_node_path => g_node_index,
1259: p_node_type => l_node_type,
1408: END ordersPegging;
1409:
1410: procedure demandView (p_list varchar2) is
1411:
1412: l_inst_id msc_gantt_utils.number_arr;
1413: l_org_id msc_gantt_utils.number_arr;
1414: l_trans_id msc_gantt_utils.number_arr;
1415: l_op_seq_num msc_gantt_utils.number_arr;
1416: l_critical_flag msc_gantt_utils.number_arr;
1409:
1410: procedure demandView (p_list varchar2) is
1411:
1412: l_inst_id msc_gantt_utils.number_arr;
1413: l_org_id msc_gantt_utils.number_arr;
1414: l_trans_id msc_gantt_utils.number_arr;
1415: l_op_seq_num msc_gantt_utils.number_arr;
1416: l_critical_flag msc_gantt_utils.number_arr;
1417:
1410: procedure demandView (p_list varchar2) is
1411:
1412: l_inst_id msc_gantt_utils.number_arr;
1413: l_org_id msc_gantt_utils.number_arr;
1414: l_trans_id msc_gantt_utils.number_arr;
1415: l_op_seq_num msc_gantt_utils.number_arr;
1416: l_critical_flag msc_gantt_utils.number_arr;
1417:
1418: s_inst_id number;
1411:
1412: l_inst_id msc_gantt_utils.number_arr;
1413: l_org_id msc_gantt_utils.number_arr;
1414: l_trans_id msc_gantt_utils.number_arr;
1415: l_op_seq_num msc_gantt_utils.number_arr;
1416: l_critical_flag msc_gantt_utils.number_arr;
1417:
1418: s_inst_id number;
1419: s_org_id number;
1412: l_inst_id msc_gantt_utils.number_arr;
1413: l_org_id msc_gantt_utils.number_arr;
1414: l_trans_id msc_gantt_utils.number_arr;
1415: l_op_seq_num msc_gantt_utils.number_arr;
1416: l_critical_flag msc_gantt_utils.number_arr;
1417:
1418: s_inst_id number;
1419: s_org_id number;
1420: s_trans_id number;
1437: open demand_cur(g_plan_id, g_end_demand_id);
1438: fetch demand_cur into s_inst_id, s_org_id, s_trans_id ;
1439: close demand_cur;
1440:
1441: msc_gantt_utils.populateRowKeysIntoGantt(
1442: p_query_id => g_order_query_id,
1443: p_index => g_node_index,
1444: p_node_path => g_node_index,
1445: p_node_type => END_DEMAND_NODE,
1460: for a in 1.. l_org_id.count
1461: loop -- {
1462: g_node_index := g_node_index + PEG_DOWN;
1463:
1464: msc_gantt_utils.populateRowKeysIntoGantt(
1465: p_query_id => g_order_query_id,
1466: p_index => g_node_index,
1467: p_node_path => g_node_index,
1468: p_node_type => JOB_NODE,
1478: end loop; -- }
1479:
1480: g_node_level := g_node_level + PEG_DOWN;
1481:
1482: g_end_peg_query_id := msc_gantt_utils.getMFQSequence(g_end_peg_query_id);
1483: msc_gantt_utils.populateEndPegsMFQ(g_plan_id, g_end_demand_id, g_end_peg_query_id);
1484:
1485: ordersPegging(1);
1486:
1479:
1480: g_node_level := g_node_level + PEG_DOWN;
1481:
1482: g_end_peg_query_id := msc_gantt_utils.getMFQSequence(g_end_peg_query_id);
1483: msc_gantt_utils.populateEndPegsMFQ(g_plan_id, g_end_demand_id, g_end_peg_query_id);
1484:
1485: ordersPegging(1);
1486:
1487: put_line('demandView out');
1568: g_peg_up_and_down := p_peg_type;
1569:
1570: g_plan_info := getPlanInfo(p_plan_id);
1571: if (p_query_id is null) then
1572: g_order_query_id := msc_gantt_utils.getGanttSequence();
1573: else
1574: g_order_query_id := p_query_id;
1575: end if;
1576:
1579: g_peg_type := PEG_DOWN;
1580: -- g_same_peg := SAME_PEG;
1581: g_same_peg := ALL_PEG; -- 3863300 bug fix...
1582:
1583: g_op_query_id := msc_gantt_utils.getMFQSequence(g_op_query_id);
1584: g_dem_op_query_id := msc_gantt_utils.getMFQSequence(g_dem_op_query_id);
1585:
1586: demandView(p_list);
1587:
1580: -- g_same_peg := SAME_PEG;
1581: g_same_peg := ALL_PEG; -- 3863300 bug fix...
1582:
1583: g_op_query_id := msc_gantt_utils.getMFQSequence(g_op_query_id);
1584: g_dem_op_query_id := msc_gantt_utils.getMFQSequence(g_dem_op_query_id);
1585:
1586: demandView(p_list);
1587:
1588: linkQueries(p_query_id, g_order_query_id, p_view_type, p_list);
1591: return g_order_query_id;
1592: end if; -- }
1593:
1594: if (p_query_id is null) then
1595: msc_gantt_utils.populateListIntoGantt(g_order_query_id, p_plan_id,
1596: p_list, p_filter_type, ORDER_VIEW);
1597: end if;
1598:
1599: if ( g_peg_type = PEG_UP_AND_DOWN ) then -- {
1597: end if;
1598:
1599: if ( g_peg_type = PEG_UP_AND_DOWN ) then -- {
1600: g_peg_type := PEG_DOWN;
1601: g_op_query_id := msc_gantt_utils.getMFQSequence(g_op_query_id);
1602: g_dem_op_query_id := msc_gantt_utils.getMFQSequence(g_dem_op_query_id);
1603: ordersPegging();
1604:
1605: g_peg_type := PEG_UP;
1598:
1599: if ( g_peg_type = PEG_UP_AND_DOWN ) then -- {
1600: g_peg_type := PEG_DOWN;
1601: g_op_query_id := msc_gantt_utils.getMFQSequence(g_op_query_id);
1602: g_dem_op_query_id := msc_gantt_utils.getMFQSequence(g_dem_op_query_id);
1603: ordersPegging();
1604:
1605: g_peg_type := PEG_UP;
1606: g_node_index := 0;
1603: ordersPegging();
1604:
1605: g_peg_type := PEG_UP;
1606: g_node_index := 0;
1607: g_op_query_id := msc_gantt_utils.getMFQSequence(g_op_query_id);
1608: g_dem_op_query_id := msc_gantt_utils.getMFQSequence(g_dem_op_query_id);
1609: ordersPegging();
1610: elsif ( g_peg_type in (PEG_UP, PEG_DOWN) ) then
1611: g_op_query_id := msc_gantt_utils.getMFQSequence(g_op_query_id);
1604:
1605: g_peg_type := PEG_UP;
1606: g_node_index := 0;
1607: g_op_query_id := msc_gantt_utils.getMFQSequence(g_op_query_id);
1608: g_dem_op_query_id := msc_gantt_utils.getMFQSequence(g_dem_op_query_id);
1609: ordersPegging();
1610: elsif ( g_peg_type in (PEG_UP, PEG_DOWN) ) then
1611: g_op_query_id := msc_gantt_utils.getMFQSequence(g_op_query_id);
1612: g_dem_op_query_id := msc_gantt_utils.getMFQSequence(g_dem_op_query_id);
1607: g_op_query_id := msc_gantt_utils.getMFQSequence(g_op_query_id);
1608: g_dem_op_query_id := msc_gantt_utils.getMFQSequence(g_dem_op_query_id);
1609: ordersPegging();
1610: elsif ( g_peg_type in (PEG_UP, PEG_DOWN) ) then
1611: g_op_query_id := msc_gantt_utils.getMFQSequence(g_op_query_id);
1612: g_dem_op_query_id := msc_gantt_utils.getMFQSequence(g_dem_op_query_id);
1613: ordersPegging();
1614: elsif ( g_peg_type = PEG_ORDERS ) then
1615: open c_max_index_cur(g_order_query_id);
1608: g_dem_op_query_id := msc_gantt_utils.getMFQSequence(g_dem_op_query_id);
1609: ordersPegging();
1610: elsif ( g_peg_type in (PEG_UP, PEG_DOWN) ) then
1611: g_op_query_id := msc_gantt_utils.getMFQSequence(g_op_query_id);
1612: g_dem_op_query_id := msc_gantt_utils.getMFQSequence(g_dem_op_query_id);
1613: ordersPegging();
1614: elsif ( g_peg_type = PEG_ORDERS ) then
1615: open c_max_index_cur(g_order_query_id);
1616: fetch c_max_index_cur into g_node_index;
1614: elsif ( g_peg_type = PEG_ORDERS ) then
1615: open c_max_index_cur(g_order_query_id);
1616: fetch c_max_index_cur into g_node_index;
1617: close c_max_index_cur;
1618: g_op_query_id := msc_gantt_utils.getMFQSequence(g_op_query_id);
1619: g_dem_op_query_id := msc_gantt_utils.getMFQSequence(g_dem_op_query_id);
1620: ordersPegging();
1621: end if; -- }
1622:
1615: open c_max_index_cur(g_order_query_id);
1616: fetch c_max_index_cur into g_node_index;
1617: close c_max_index_cur;
1618: g_op_query_id := msc_gantt_utils.getMFQSequence(g_op_query_id);
1619: g_dem_op_query_id := msc_gantt_utils.getMFQSequence(g_dem_op_query_id);
1620: ordersPegging();
1621: end if; -- }
1622:
1623: if ( g_peg_type in (PEG_UP, PEG_UP_AND_DOWN) ) then
1633: END orderView;
1634:
1635: function getResult(p_query_id number,
1636: p_from_index number, p_to_index number,
1637: p_out_data IN OUT NOCOPY msc_gantt_utils.maxCharTbl,
1638: p_node_level number default null,
1639: p_sort_node number default null,
1640: p_sort_column varchar2 default null,
1641: p_sort_order varchar2 default null,
1640: p_sort_column varchar2 default null,
1641: p_sort_order varchar2 default null,
1642: p_res_nodes_only varchar2 default null) return number is
1643: begin
1644: return msc_gantt_utils.getResult(p_query_id, p_from_index, p_to_index,
1645: g_plan_id, p_out_data, p_node_level, p_sort_node, p_sort_column, p_sort_order,
1646: p_res_nodes_only);
1647: end getResult;
1648:
1647: end getResult;
1648:
1649: --p_trx_list is (inst_id, trx id),(inst_id, trx_id)
1650: procedure resCharges(p_query_id number,
1651: p_trx_list varchar2, p_out_data IN OUT NOCOPY msc_gantt_utils.maxCharTbl) is
1652: begin
1653: msc_gantt_utils.resCharges(p_query_id, g_plan_id, p_trx_list, p_out_data);
1654: end resCharges;
1655:
1649: --p_trx_list is (inst_id, trx id),(inst_id, trx_id)
1650: procedure resCharges(p_query_id number,
1651: p_trx_list varchar2, p_out_data IN OUT NOCOPY msc_gantt_utils.maxCharTbl) is
1652: begin
1653: msc_gantt_utils.resCharges(p_query_id, g_plan_id, p_trx_list, p_out_data);
1654: end resCharges;
1655:
1656: --p_trx_list is (inst_id, node_type, trx id),(inst_id, node_type, trx_id)
1657: procedure segmentPegging(p_query_id number,
1654: end resCharges;
1655:
1656: --p_trx_list is (inst_id, node_type, trx id),(inst_id, node_type, trx_id)
1657: procedure segmentPegging(p_query_id number,
1658: p_trx_list varchar2, p_out_data IN OUT NOCOPY msc_gantt_utils.maxCharTbl) is
1659: begin
1660: msc_gantt_utils.segmentPegging(p_query_id, g_plan_id, p_trx_list, p_out_data);
1661: end segmentPegging;
1662:
1656: --p_trx_list is (inst_id, node_type, trx id),(inst_id, node_type, trx_id)
1657: procedure segmentPegging(p_query_id number,
1658: p_trx_list varchar2, p_out_data IN OUT NOCOPY msc_gantt_utils.maxCharTbl) is
1659: begin
1660: msc_gantt_utils.segmentPegging(p_query_id, g_plan_id, p_trx_list, p_out_data);
1661: end segmentPegging;
1662:
1663: function addSimuAltResToView(p_query_id number, p_view_type number,
1664: p_node_type number, p_node_list varchar2, p_out out nocopy varchar2) return number is
1692:
1693: l_one_record := substr(p_node_list,instr(p_node_list,'(',1,1)+1,
1694: instr(p_node_list,')',1,1)-instr(p_node_list,'(',1,1)-1);
1695:
1696: msc_gantt_utils.parseResString(l_one_record, l_inst_id, l_org_id, l_dept_id, l_res_id,
1697: l_res_instance_id, l_serial_number);
1698: l_one_record := null;
1699:
1700: l_row_count := msc_gantt_utils.isResRowInGantt(p_query_id, g_plan_id, l_inst_id, l_org_id, l_dept_id,
1696: msc_gantt_utils.parseResString(l_one_record, l_inst_id, l_org_id, l_dept_id, l_res_id,
1697: l_res_instance_id, l_serial_number);
1698: l_one_record := null;
1699:
1700: l_row_count := msc_gantt_utils.isResRowInGantt(p_query_id, g_plan_id, l_inst_id, l_org_id, l_dept_id,
1701: l_res_id, mbp_null_value, mbp_null_value_char);
1702:
1703: if ( l_row_count = sys_no ) then
1704: msc_gantt_utils.populateResIntoGantt(p_query_id, l_row_index, l_one_record,
1700: l_row_count := msc_gantt_utils.isResRowInGantt(p_query_id, g_plan_id, l_inst_id, l_org_id, l_dept_id,
1701: l_res_id, mbp_null_value, mbp_null_value_char);
1702:
1703: if ( l_row_count = sys_no ) then
1704: msc_gantt_utils.populateResIntoGantt(p_query_id, l_row_index, l_one_record,
1705: g_plan_id, l_inst_id, l_org_id, l_dept_id, l_res_id, MBP_NULL_VALUE, MBP_NULL_VALUE_CHAR, sys_no);
1706: end if;
1707:
1708: for c_res_inst_row in c_res_inst
1706: end if;
1707:
1708: for c_res_inst_row in c_res_inst
1709: loop -- {
1710: l_row_count := msc_gantt_utils.isResRowInGantt(p_query_id, g_plan_id, l_inst_id, l_org_id,
1711: l_dept_id, l_res_id, c_res_inst_row.res_instance_id, c_res_inst_row.serial_number);
1712:
1713: if (l_row_count = sys_no ) then
1714: --l_row_index := l_row_index + 1;
1711: l_dept_id, l_res_id, c_res_inst_row.res_instance_id, c_res_inst_row.serial_number);
1712:
1713: if (l_row_count = sys_no ) then
1714: --l_row_index := l_row_index + 1;
1715: msc_gantt_utils.populateResIntoGantt(p_query_id, l_row_index, l_one_record,
1716: g_plan_id, l_inst_id, l_org_id, l_dept_id, l_res_id,
1717: c_res_inst_row.res_instance_id, c_res_inst_row.serial_number, sys_no);
1718: end if;
1719: end loop; -- }
1734: l_node_path varchar2(250);
1735: l_row_index number;
1736: l_one_record varchar2(250);
1737:
1738: v_inst_id msc_gantt_utils.number_arr;
1739: v_org_id msc_gantt_utils.number_arr;
1740: v_dept_id msc_gantt_utils.number_arr;
1741: v_res_id msc_gantt_utils.number_arr;
1742:
1735: l_row_index number;
1736: l_one_record varchar2(250);
1737:
1738: v_inst_id msc_gantt_utils.number_arr;
1739: v_org_id msc_gantt_utils.number_arr;
1740: v_dept_id msc_gantt_utils.number_arr;
1741: v_res_id msc_gantt_utils.number_arr;
1742:
1743: l_row_found number := sys_no;
1736: l_one_record varchar2(250);
1737:
1738: v_inst_id msc_gantt_utils.number_arr;
1739: v_org_id msc_gantt_utils.number_arr;
1740: v_dept_id msc_gantt_utils.number_arr;
1741: v_res_id msc_gantt_utils.number_arr;
1742:
1743: l_row_found number := sys_no;
1744: checkRow boolean := false;
1737:
1738: v_inst_id msc_gantt_utils.number_arr;
1739: v_org_id msc_gantt_utils.number_arr;
1740: v_dept_id msc_gantt_utils.number_arr;
1741: v_res_id msc_gantt_utils.number_arr;
1742:
1743: l_row_found number := sys_no;
1744: checkRow boolean := false;
1745:
1748: fetch c_node_type_cur into l_node_type, l_node_path;
1749: close c_node_type_cur;
1750:
1751: if ( p_to_query_id is null ) then -- {
1752: p_to_query_id := msc_gantt_utils.getGanttSequence();
1753: l_row_index := 1;
1754: else
1755: select nvl(max(row_index),0)
1756: into l_row_index
1780:
1781: for i in 1..v_inst_id.count
1782: loop -- {
1783: if ( checkRow ) then
1784: l_row_found := msc_gantt_utils.isResRowInGantt(p_to_query_id, g_plan_id,
1785: v_inst_id(i), v_org_id(i), v_dept_id(i), v_res_id(i), MBP_NULL_VALUE, MBP_NULL_VALUE_CHAR);
1786: end if;
1787:
1788: if ( l_row_found = sys_no ) then
1785: v_inst_id(i), v_org_id(i), v_dept_id(i), v_res_id(i), MBP_NULL_VALUE, MBP_NULL_VALUE_CHAR);
1786: end if;
1787:
1788: if ( l_row_found = sys_no ) then
1789: msc_gantt_utils.populateResIntoGantt(p_to_query_id, l_row_index, l_one_record,
1790: g_plan_id, v_inst_id(i), v_org_id(i), v_dept_id(i), v_res_id(i),
1791: mbp_null_value, MBP_NULL_VALUE_CHAR, sys_yes); --5521235 will add res instances too
1792: l_row_index := l_row_index + 1;
1793: end if;
1809: l_node_path varchar2(250);
1810: l_row_index number;
1811: l_one_record varchar2(250);
1812:
1813: v_inst_id msc_gantt_utils.number_arr;
1814: v_org_id msc_gantt_utils.number_arr;
1815: v_item_id msc_gantt_utils.number_arr;
1816: v_supp_id msc_gantt_utils.number_arr;
1817: v_supp_site_id msc_gantt_utils.number_arr;
1810: l_row_index number;
1811: l_one_record varchar2(250);
1812:
1813: v_inst_id msc_gantt_utils.number_arr;
1814: v_org_id msc_gantt_utils.number_arr;
1815: v_item_id msc_gantt_utils.number_arr;
1816: v_supp_id msc_gantt_utils.number_arr;
1817: v_supp_site_id msc_gantt_utils.number_arr;
1818:
1811: l_one_record varchar2(250);
1812:
1813: v_inst_id msc_gantt_utils.number_arr;
1814: v_org_id msc_gantt_utils.number_arr;
1815: v_item_id msc_gantt_utils.number_arr;
1816: v_supp_id msc_gantt_utils.number_arr;
1817: v_supp_site_id msc_gantt_utils.number_arr;
1818:
1819: l_row_found number := 0;
1812:
1813: v_inst_id msc_gantt_utils.number_arr;
1814: v_org_id msc_gantt_utils.number_arr;
1815: v_item_id msc_gantt_utils.number_arr;
1816: v_supp_id msc_gantt_utils.number_arr;
1817: v_supp_site_id msc_gantt_utils.number_arr;
1818:
1819: l_row_found number := 0;
1820: checkRow boolean := false;
1813: v_inst_id msc_gantt_utils.number_arr;
1814: v_org_id msc_gantt_utils.number_arr;
1815: v_item_id msc_gantt_utils.number_arr;
1816: v_supp_id msc_gantt_utils.number_arr;
1817: v_supp_site_id msc_gantt_utils.number_arr;
1818:
1819: l_row_found number := 0;
1820: checkRow boolean := false;
1821: begin
1827: return 0;
1828: end if;
1829:
1830: if ( p_to_query_id is null ) then -- {
1831: p_to_query_id := msc_gantt_utils.getGanttSequence();
1832: l_row_index := 1;
1833: else
1834: select nvl(max(row_index),0) + 1
1835: into l_row_index
1862: close check_supp_row_cur;
1863: end if;
1864:
1865: if ( l_row_found = 0 ) then
1866: msc_gantt_utils.populateSuppIntoGantt(p_to_query_id, l_row_index, l_one_record,
1867: g_plan_id, v_inst_id(i), v_org_id(i),v_item_id(i), v_supp_id(i), v_supp_site_id(i));
1868: l_row_index := l_row_index + 1;
1869: end if;
1870: end loop; -- }
1877: p_from_index number, p_from_view_type number,
1878: p_context_value varchar2, p_context_value2 varchar2 default null) return number is
1879: l_row_index number;
1880:
1881: v_inst_id msc_gantt_utils.number_arr;
1882: v_org_id msc_gantt_utils.number_arr;
1883: v_trx_id msc_gantt_utils.number_arr;
1884:
1885: l_row_found number := 0;
1878: p_context_value varchar2, p_context_value2 varchar2 default null) return number is
1879: l_row_index number;
1880:
1881: v_inst_id msc_gantt_utils.number_arr;
1882: v_org_id msc_gantt_utils.number_arr;
1883: v_trx_id msc_gantt_utils.number_arr;
1884:
1885: l_row_found number := 0;
1886: checkRow boolean := false;
1879: l_row_index number;
1880:
1881: v_inst_id msc_gantt_utils.number_arr;
1882: v_org_id msc_gantt_utils.number_arr;
1883: v_trx_id msc_gantt_utils.number_arr;
1884:
1885: l_row_found number := 0;
1886: checkRow boolean := false;
1887: l_temp_query_id number;
1896: and mgq.row_index = ll_index;
1897:
1898: begin
1899: if ( p_to_query_id is null ) then -- {
1900: p_to_query_id := msc_gantt_utils.getGanttSequence();
1901: g_order_query_id := p_to_query_id;
1902: g_node_level := 1;
1903: l_row_index := 1;
1904: else
1969: and mrr.sr_instance_id = mgq.sr_instance_id
1970: and mrr.organization_id = mgq.organization_id
1971: and mrr.department_id = mgq.department_id
1972: and mrr.resource_id = mgq.resource_id
1973: and ( msc_gantt_utils.getResReqStartDate(nvl(mrr.firm_flag,0), mrr.start_date,
1974: mrr.end_date, mrr.firm_start_date, mrr.firm_end_date, mrr.status, mrr.applied)
1975: between to_date(p_context_value,FORMAT_MASK) and to_date(p_context_value2,FORMAT_MASK)
1976: or msc_gantt_utils.getResReqEndDate(nvl(mrr.firm_flag,0), mrr.start_date,
1977: mrr.end_date, mrr.firm_start_date, mrr.firm_end_date, mrr.status, mrr.applied)
1972: and mrr.resource_id = mgq.resource_id
1973: and ( msc_gantt_utils.getResReqStartDate(nvl(mrr.firm_flag,0), mrr.start_date,
1974: mrr.end_date, mrr.firm_start_date, mrr.firm_end_date, mrr.status, mrr.applied)
1975: between to_date(p_context_value,FORMAT_MASK) and to_date(p_context_value2,FORMAT_MASK)
1976: or msc_gantt_utils.getResReqEndDate(nvl(mrr.firm_flag,0), mrr.start_date,
1977: mrr.end_date, mrr.firm_start_date, mrr.firm_end_date, mrr.status, mrr.applied)
1978: between to_date(p_context_value,FORMAT_MASK) and to_date(p_context_value2,FORMAT_MASK))
1979: and mrr.parent_id = 2;
1980:
2006: close check_job_row_cur;
2007: end if;
2008:
2009: if ( l_row_found = 0) then
2010: msc_gantt_utils.populateRowKeysIntoGantt(
2011: p_query_id => g_order_query_id,
2012: p_index => l_row_index,
2013: p_node_path => l_row_index,
2014: p_node_type => JOB_NODE,
2048: function resourceView (p_query_id in out nocopy number,
2049: p_plan_id number, p_list varchar2,
2050: p_filter_type number, p_view_type number,
2051: p_from_index number, p_to_index number,
2052: p_name_data IN OUT NOCOPY msc_gantt_utils.maxCharTbl,
2053: p_require_data IN OUT NOCOPY msc_gantt_utils.maxCharTbl,
2054: p_avail_data IN OUT NOCOPY msc_gantt_utils.maxCharTbl,
2055: p_batched_res_act number default null,
2056: p_display_type number default null,
2049: p_plan_id number, p_list varchar2,
2050: p_filter_type number, p_view_type number,
2051: p_from_index number, p_to_index number,
2052: p_name_data IN OUT NOCOPY msc_gantt_utils.maxCharTbl,
2053: p_require_data IN OUT NOCOPY msc_gantt_utils.maxCharTbl,
2054: p_avail_data IN OUT NOCOPY msc_gantt_utils.maxCharTbl,
2055: p_batched_res_act number default null,
2056: p_display_type number default null,
2057: p_refresh boolean default false,
2050: p_filter_type number, p_view_type number,
2051: p_from_index number, p_to_index number,
2052: p_name_data IN OUT NOCOPY msc_gantt_utils.maxCharTbl,
2053: p_require_data IN OUT NOCOPY msc_gantt_utils.maxCharTbl,
2054: p_avail_data IN OUT NOCOPY msc_gantt_utils.maxCharTbl,
2055: p_batched_res_act number default null,
2056: p_display_type number default null,
2057: p_refresh boolean default false,
2058: p_sort_column varchar2 default null,
2063: put_line('resourceView in');
2064:
2065: if ( p_query_id is null ) then -- {
2066: g_plan_info := getPlanInfo(p_plan_id);
2067: p_query_id := msc_gantt_utils.getGanttSequence();
2068:
2069: msc_gantt_utils.populateListIntoGantt(p_query_id, p_plan_id, p_list,
2070: p_filter_type, p_view_type, p_folder_id);
2071:
2065: if ( p_query_id is null ) then -- {
2066: g_plan_info := getPlanInfo(p_plan_id);
2067: p_query_id := msc_gantt_utils.getGanttSequence();
2068:
2069: msc_gantt_utils.populateListIntoGantt(p_query_id, p_plan_id, p_list,
2070: p_filter_type, p_view_type, p_folder_id);
2071:
2072: elsif ( p_refresh ) then
2073:
2089: where query_id = p_query_id;
2090:
2091: end if; -- }
2092:
2093: msc_gantt_utils.sendResourceNames(p_query_id, p_from_index, p_to_index,
2094: p_name_data, p_sort_column, p_sort_order);
2095:
2096: if ( p_view_type = RES_HOURS_VIEW ) then -- {
2097:
2094: p_name_data, p_sort_column, p_sort_order);
2095:
2096: if ( p_view_type = RES_HOURS_VIEW ) then -- {
2097:
2098: msc_gantt_utils.populateResReqGanttNew(p_query_id,
2099: g_plan_start_date, g_cutoff_date, nvl(p_display_type, display_none));
2100:
2101: msc_gantt_utils.populateResAvailGantt(p_query_id, g_plan_start_date, g_cutoff_date);
2102: msc_gantt_utils.prepareResHoursGantt(p_query_id, p_plan_id, g_plan_start_date,
2097:
2098: msc_gantt_utils.populateResReqGanttNew(p_query_id,
2099: g_plan_start_date, g_cutoff_date, nvl(p_display_type, display_none));
2100:
2101: msc_gantt_utils.populateResAvailGantt(p_query_id, g_plan_start_date, g_cutoff_date);
2102: msc_gantt_utils.prepareResHoursGantt(p_query_id, p_plan_id, g_plan_start_date,
2103: g_cutoff_date, nvl(p_display_type, display_none));
2104:
2105: msc_gantt_utils.sendResourceGantt(p_query_id, p_view_type, SYS_YES,
2098: msc_gantt_utils.populateResReqGanttNew(p_query_id,
2099: g_plan_start_date, g_cutoff_date, nvl(p_display_type, display_none));
2100:
2101: msc_gantt_utils.populateResAvailGantt(p_query_id, g_plan_start_date, g_cutoff_date);
2102: msc_gantt_utils.prepareResHoursGantt(p_query_id, p_plan_id, g_plan_start_date,
2103: g_cutoff_date, nvl(p_display_type, display_none));
2104:
2105: msc_gantt_utils.sendResourceGantt(p_query_id, p_view_type, SYS_YES,
2106: p_require_data, p_avail_data, false, nvl(p_display_type, display_none));
2101: msc_gantt_utils.populateResAvailGantt(p_query_id, g_plan_start_date, g_cutoff_date);
2102: msc_gantt_utils.prepareResHoursGantt(p_query_id, p_plan_id, g_plan_start_date,
2103: g_cutoff_date, nvl(p_display_type, display_none));
2104:
2105: msc_gantt_utils.sendResourceGantt(p_query_id, p_view_type, SYS_YES,
2106: p_require_data, p_avail_data, false, nvl(p_display_type, display_none));
2107:
2108: elsif ( p_view_type = RES_UNITS_VIEW ) then
2109:
2106: p_require_data, p_avail_data, false, nvl(p_display_type, display_none));
2107:
2108: elsif ( p_view_type = RES_UNITS_VIEW ) then
2109:
2110: msc_gantt_utils.populateResReqGanttNew(p_query_id, g_plan_start_date, g_day_bkt_start_date);
2111: msc_gantt_utils.populateResAvailGantt(p_query_id, g_plan_start_date, g_day_bkt_start_date);
2112:
2113: msc_gantt_utils.sendResourceGantt(p_query_id, p_view_type, SYS_NO, p_require_data,
2114: p_avail_data, false, DISPLAY_NONE);
2107:
2108: elsif ( p_view_type = RES_UNITS_VIEW ) then
2109:
2110: msc_gantt_utils.populateResReqGanttNew(p_query_id, g_plan_start_date, g_day_bkt_start_date);
2111: msc_gantt_utils.populateResAvailGantt(p_query_id, g_plan_start_date, g_day_bkt_start_date);
2112:
2113: msc_gantt_utils.sendResourceGantt(p_query_id, p_view_type, SYS_NO, p_require_data,
2114: p_avail_data, false, DISPLAY_NONE);
2115:
2109:
2110: msc_gantt_utils.populateResReqGanttNew(p_query_id, g_plan_start_date, g_day_bkt_start_date);
2111: msc_gantt_utils.populateResAvailGantt(p_query_id, g_plan_start_date, g_day_bkt_start_date);
2112:
2113: msc_gantt_utils.sendResourceGantt(p_query_id, p_view_type, SYS_NO, p_require_data,
2114: p_avail_data, false, DISPLAY_NONE);
2115:
2116: elsif (p_view_type = RES_ACTIVITIES_VIEW ) then
2117:
2114: p_avail_data, false, DISPLAY_NONE);
2115:
2116: elsif (p_view_type = RES_ACTIVITIES_VIEW ) then
2117:
2118: msc_gantt_utils.populateResActGantt(p_query_id, g_plan_start_date, g_day_bkt_start_date,
2119: nvl(p_batched_res_act, RES_REQ_ROW_TYPE), p_require_data, nvl(p_display_type, display_none));
2120:
2121: msc_gantt_utils.populateResAvailGantt(p_query_id, g_plan_start_date, g_day_bkt_start_date);
2122: msc_gantt_utils.sendResourceGantt(p_query_id, p_view_type, SYS_NO, p_require_data,
2117:
2118: msc_gantt_utils.populateResActGantt(p_query_id, g_plan_start_date, g_day_bkt_start_date,
2119: nvl(p_batched_res_act, RES_REQ_ROW_TYPE), p_require_data, nvl(p_display_type, display_none));
2120:
2121: msc_gantt_utils.populateResAvailGantt(p_query_id, g_plan_start_date, g_day_bkt_start_date);
2122: msc_gantt_utils.sendResourceGantt(p_query_id, p_view_type, SYS_NO, p_require_data,
2123: p_avail_data, true, nvl(p_display_type, display_none));
2124:
2125: end if; -- }
2118: msc_gantt_utils.populateResActGantt(p_query_id, g_plan_start_date, g_day_bkt_start_date,
2119: nvl(p_batched_res_act, RES_REQ_ROW_TYPE), p_require_data, nvl(p_display_type, display_none));
2120:
2121: msc_gantt_utils.populateResAvailGantt(p_query_id, g_plan_start_date, g_day_bkt_start_date);
2122: msc_gantt_utils.sendResourceGantt(p_query_id, p_view_type, SYS_NO, p_require_data,
2123: p_avail_data, true, nvl(p_display_type, display_none));
2124:
2125: end if; -- }
2126:
2138: function supplierView(p_query_id in out nocopy number,
2139: p_plan_id number, p_list varchar2,
2140: p_filter_type number, p_view_type number,
2141: p_from_index number, p_to_index number,
2142: p_name_data IN OUT NOCOPY msc_gantt_utils.maxCharTbl,
2143: p_supp_data IN OUT NOCOPY msc_gantt_utils.maxCharTbl,
2144: p_refresh boolean default false,
2145: p_sort_column varchar2 default null,
2146: p_sort_order varchar2 default null) return number is
2139: p_plan_id number, p_list varchar2,
2140: p_filter_type number, p_view_type number,
2141: p_from_index number, p_to_index number,
2142: p_name_data IN OUT NOCOPY msc_gantt_utils.maxCharTbl,
2143: p_supp_data IN OUT NOCOPY msc_gantt_utils.maxCharTbl,
2144: p_refresh boolean default false,
2145: p_sort_column varchar2 default null,
2146: p_sort_order varchar2 default null) return number is
2147: begin
2148: put_line('supplierView in');
2149:
2150: if ( p_query_id is null ) then -- {
2151: g_plan_info := getPlanInfo(p_plan_id);
2152: p_query_id := msc_gantt_utils.getGanttSequence();
2153:
2154: msc_gantt_utils.populateListIntoGantt(p_query_id,
2155: p_plan_id, p_list, p_filter_type, p_view_type);
2156:
2150: if ( p_query_id is null ) then -- {
2151: g_plan_info := getPlanInfo(p_plan_id);
2152: p_query_id := msc_gantt_utils.getGanttSequence();
2153:
2154: msc_gantt_utils.populateListIntoGantt(p_query_id,
2155: p_plan_id, p_list, p_filter_type, p_view_type);
2156:
2157: elsif ( p_refresh ) then
2158: update msc_gantt_query
2171: delete from msc_gantt_dtl_query
2172: where query_id = p_query_id;
2173: end if; -- }
2174:
2175: msc_gantt_utils.sendSupplierNames(p_query_id, p_from_index, p_to_index, p_name_data,
2176: p_sort_column, p_sort_order);
2177:
2178: msc_gantt_utils.populateSupplierGantt(p_query_id, g_plan_id, g_plan_start_date, g_cutoff_date);
2179: msc_gantt_utils.prepareSupplierGantt(p_query_id, p_plan_id, g_plan_start_date, g_cutoff_date);
2174:
2175: msc_gantt_utils.sendSupplierNames(p_query_id, p_from_index, p_to_index, p_name_data,
2176: p_sort_column, p_sort_order);
2177:
2178: msc_gantt_utils.populateSupplierGantt(p_query_id, g_plan_id, g_plan_start_date, g_cutoff_date);
2179: msc_gantt_utils.prepareSupplierGantt(p_query_id, p_plan_id, g_plan_start_date, g_cutoff_date);
2180: msc_gantt_utils.sendSupplierGantt(p_query_id, p_supp_data);
2181:
2182: -- set the is_fetched to SYS_YES
2175: msc_gantt_utils.sendSupplierNames(p_query_id, p_from_index, p_to_index, p_name_data,
2176: p_sort_column, p_sort_order);
2177:
2178: msc_gantt_utils.populateSupplierGantt(p_query_id, g_plan_id, g_plan_start_date, g_cutoff_date);
2179: msc_gantt_utils.prepareSupplierGantt(p_query_id, p_plan_id, g_plan_start_date, g_cutoff_date);
2180: msc_gantt_utils.sendSupplierGantt(p_query_id, p_supp_data);
2181:
2182: -- set the is_fetched to SYS_YES
2183: update msc_gantt_query
2176: p_sort_column, p_sort_order);
2177:
2178: msc_gantt_utils.populateSupplierGantt(p_query_id, g_plan_id, g_plan_start_date, g_cutoff_date);
2179: msc_gantt_utils.prepareSupplierGantt(p_query_id, p_plan_id, g_plan_start_date, g_cutoff_date);
2180: msc_gantt_utils.sendSupplierGantt(p_query_id, p_supp_data);
2181:
2182: -- set the is_fetched to SYS_YES
2183: update msc_gantt_query
2184: set is_fetched = SYS_YES
2190: end supplierView;
2191:
2192: procedure sortResSuppView(p_query_id number,
2193: p_view_type number, p_from_index number, p_to_index number,
2194: p_name_data IN OUT NOCOPY msc_gantt_utils.maxCharTbl,
2195: p_sort_column varchar2 default null,
2196: p_sort_order varchar2 default null) is
2197: begin
2198: if ( p_view_type = SUPPLIER_VIEW ) then
2195: p_sort_column varchar2 default null,
2196: p_sort_order varchar2 default null) is
2197: begin
2198: if ( p_view_type = SUPPLIER_VIEW ) then
2199: msc_gantt_utils.sendSupplierNames(p_query_id, p_from_index, p_to_index,
2200: p_name_data, p_sort_column, p_sort_order);
2201: elsif (p_view_type in (RES_ACTIVITIES_VIEW, RES_UNITS_VIEW, RES_HOURS_VIEW) ) then
2202: msc_gantt_utils.sendResourceNames(p_query_id, p_from_index, p_to_index,
2203: p_name_data, p_sort_column, p_sort_order);
2198: if ( p_view_type = SUPPLIER_VIEW ) then
2199: msc_gantt_utils.sendSupplierNames(p_query_id, p_from_index, p_to_index,
2200: p_name_data, p_sort_column, p_sort_order);
2201: elsif (p_view_type in (RES_ACTIVITIES_VIEW, RES_UNITS_VIEW, RES_HOURS_VIEW) ) then
2202: msc_gantt_utils.sendResourceNames(p_query_id, p_from_index, p_to_index,
2203: p_name_data, p_sort_column, p_sort_order);
2204: end if;
2205: end sortResSuppView;
2206:
2210: p_start_date date, p_end_date date,
2211: p_trx_list varchar2,
2212: p_return_status OUT NOCOPY varchar2,
2213: p_out OUT NOCOPY varchar2,
2214: p_out_data IN OUT NOCOPY msc_gantt_utils.maxCharTbl,
2215: p_validate_flag boolean default true,
2216: p_res_firm_seq boolean default false,
2217: p_batched_res_act boolean default false) is
2218:
2233: i :=1;
2234:
2235: if ( p_node_type in (RES_NODE, RES_INST_NODE) ) then -- {
2236: if (p_res_firm_seq) then -- {
2237: msc_gantt_utils.firmResourceSeqPub(g_plan_id, p_trx_list, p_firm_type,
2238: p_return_status, p_out, p_node_type);
2239: elsif (p_batched_res_act) then
2240: l_one_record := substr(p_trx_list,
2241: instr(p_trx_list,'(',1,i)+1,instr(p_trx_list,')',1,i) - instr(p_trx_list,'(',1,i)-1);
2241: instr(p_trx_list,'(',1,i)+1,instr(p_trx_list,')',1,i) - instr(p_trx_list,'(',1,i)-1);
2242: l_inst_id := to_number(substr(l_one_record,1,instr(l_one_record,',')-1));
2243: l_trx_id := to_number(substr(l_one_record,instr(l_one_record,',')+1));
2244: -- no firming of a batch...client should not call this..
2245: -- msc_gantt_utils.firmResourceBatchPub(g_plan_id, l_trx_id, l_inst_id, p_firm_type,
2246: -- p_return_status, p_out, p_node_type);
2247: else
2248: v_len := length(p_trx_list);
2249: i :=1;
2252: instr(p_trx_list,'(',1,i)+1,instr(p_trx_list,')',1,i) - instr(p_trx_list,'(',1,i)-1);
2253: l_inst_id := to_number(substr(l_one_record,1,instr(l_one_record,',')-1));
2254: l_trx_id := to_number(substr(l_one_record,instr(l_one_record,',')+1));
2255:
2256: msc_gantt_utils.firmResourcePub(g_plan_id, l_trx_id, l_inst_id, p_firm_type,
2257: p_return_status, p_out, p_node_type);
2258: i := i+1;
2259: v_len := v_len - length(l_one_record)-3;
2260: end loop;
2267: instr(p_trx_list,'(',1,i)+1,instr(p_trx_list,')',1,i) - instr(p_trx_list,'(',1,i)-1);
2268: l_inst_id := to_number(substr(l_one_record,1,instr(l_one_record,',')-1));
2269: l_trx_id := to_number(substr(l_one_record,instr(l_one_record,',')+1));
2270:
2271: msc_gantt_utils.firmSupplyPub(g_plan_id, l_trx_id, l_inst_id,
2272: p_firm_type, p_start_date, p_end_date, g_plan_start_date, g_cutoff_date,
2273: p_return_status, p_out, p_validate_flag, p_node_type);
2274:
2275: i := i+1;
2283: p_trx_list varchar2, p_to_trx_list varchar2,
2284: p_start_date date, p_end_date date, p_duration varchar2,
2285: p_return_status OUT NOCOPY varchar2,
2286: p_out OUT NOCOPY varchar2,
2287: p_out_data IN OUT NOCOPY msc_gantt_utils.maxCharTbl,
2288: p_validate_flag boolean default true,
2289: p_res_firm_seq boolean default false,
2290: p_batched_res_act boolean default false) is
2291:
2337:
2338: put_line(' from_node '|| l_inst_id ||' '||l_trx_id);
2339:
2340: if ( p_batched_res_act ) then -- {
2341: msc_gantt_utils.loadAltResourceBatch(g_plan_id,
2342: l_trx_id, l_inst_id, l_to_res_id, l_to_res_instance_id, l_to_serial_number,
2343: l_to_alt_num, p_node_type, p_to_node_type, p_return_trx_id,
2344: p_return_status, p_out);
2345: else
2342: l_trx_id, l_inst_id, l_to_res_id, l_to_res_instance_id, l_to_serial_number,
2343: l_to_alt_num, p_node_type, p_to_node_type, p_return_trx_id,
2344: p_return_status, p_out);
2345: else
2346: msc_gantt_utils.loadAltResource(g_plan_id,
2347: l_trx_id, l_inst_id, l_to_res_id, l_to_res_instance_id, l_to_serial_number,
2348: l_to_alt_num, p_node_type, p_to_node_type, p_return_trx_id,
2349: p_return_status, p_out);
2350: end if; -- }
2356: end if; -- }
2357:
2358: put_line(' offloading done .now move the trx '||p_return_trx_id);
2359:
2360: msc_gantt_utils.moveResourcePub(g_plan_id, p_return_trx_id, l_inst_id,
2361: p_start_date, p_end_date, p_duration, g_plan_start_date, g_cutoff_date,
2362: p_return_status, p_out, p_validate_flag, p_res_firm_seq, p_batched_res_act, p_node_type);
2363:
2364: else
2373: l_trx_id := to_number(substr(l_one_record,instr(l_one_record,',')+1));
2374:
2375: put_line(' move inst trx '||l_inst_id||' - '||l_trx_id);
2376:
2377: msc_gantt_utils.moveResourcePub(g_plan_id, l_trx_id, l_inst_id, p_start_date, p_end_date,
2378: p_duration, g_plan_start_date, g_cutoff_date, p_return_status, p_out,
2379: p_validate_flag, p_res_firm_seq, p_batched_res_act, p_node_type);
2380: i := i+1;
2381: v_len := v_len - length(l_one_record)-3;
2394: l_trx_id := to_number(substr(l_one_record,instr(l_one_record,',')+1));
2395:
2396: put_line(' move inst trx '||l_inst_id||' - '||l_trx_id);
2397:
2398: msc_gantt_utils.moveSupplyPub (g_plan_id, l_trx_id, p_start_date, p_end_date,
2399: g_plan_start_date, g_cutoff_date, p_return_status, p_out);
2400:
2401: i := i+1;
2402: v_len := v_len - length(l_one_record)-3;
2409: procedure moveAndFirm(p_node_type number, p_to_node_type number,
2410: p_firm_type number, p_trx_list varchar2, p_to_trx_list varchar2,
2411: p_start_date date, p_end_date date, p_duration varchar2,
2412: p_return_status OUT NOCOPY varchar2, p_out OUT NOCOPY varchar2,
2413: p_out_data IN OUT NOCOPY msc_gantt_utils.maxCharTbl,
2414: p_validate_flag boolean default true,
2415: p_res_firm_seq boolean default false) is
2416: begin
2417:
2546: if (g_plan_id = p_plan_id) then
2547: return g_plan_info ;
2548: end if ;
2549:
2550: g_plan_info := msc_gantt_utils.getPlanInfo(p_plan_id,
2551: g_first_date, g_last_date,
2552: g_hour_bkt_start_date, g_day_bkt_start_date,
2553: g_plan_start_date, g_cutoff_date, g_plan_type);
2554:
2557: end getPlanInfo;
2558:
2559: procedure getUserPref(p_pref_id number) is
2560: begin
2561: msc_gantt_utils.getUserPref(p_pref_id);
2562: end getUserPref;
2563:
2564: procedure getSimuResource(p_plan_id number,
2565: p_transaction_id number, p_instance_id number,
2565: p_transaction_id number, p_instance_id number,
2566: p_name OUT NOCOPY varchar2, p_id OUT NOCOPY varchar2,
2567: p_node_type number default null) is
2568: begin
2569: msc_gantt_utils.getSimuResource(p_plan_id,
2570: p_transaction_id, p_instance_id, p_name, p_id, p_node_type);
2571: end getSimuResource;
2572:
2573: procedure getAltResource(p_plan_id number,
2575: p_name OUT NOCOPY varchar2, p_id OUT NOCOPY varchar2,
2576: p_node_type number default null,
2577: p_from_form number default null) is
2578: begin
2579: msc_gantt_utils.getAltResource(p_plan_id,
2580: p_transaction_id, p_instance_id, p_name, p_id, p_node_type, p_from_form);
2581: end getAltResource;
2582:
2583: function isPlanGanttEnabled(p_plan_id number) return boolean is
2641: l_res_instance_id number;
2642: l_serial_number varchar2(30);
2643:
2644: begin
2645: v_mfq_from_query_id := msc_gantt_utils.getMFQSequence();
2646: v_mfq_to_query_id := msc_gantt_utils.getMFQSequence();
2647:
2648: if ( p_view_type in (RES_ACTIVITIES_VIEW, DEMAND_VIEW, ORDER_VIEW) ) then -- {
2649: v_len := length(p_trx_list);
2642: l_serial_number varchar2(30);
2643:
2644: begin
2645: v_mfq_from_query_id := msc_gantt_utils.getMFQSequence();
2646: v_mfq_to_query_id := msc_gantt_utils.getMFQSequence();
2647:
2648: if ( p_view_type in (RES_ACTIVITIES_VIEW, DEMAND_VIEW, ORDER_VIEW) ) then -- {
2649: v_len := length(p_trx_list);
2650: while v_len > 1 loop
2650: while v_len > 1 loop
2651: v_one_record := substr(p_trx_list,instr(p_trx_list,
2652: '(',1,i)+1, instr(p_trx_list,')',1,i)-instr(p_trx_list,'(',1,i)-1);
2653:
2654: msc_gantt_utils.populateOrdersIntoMFQ(null, null, v_mfq_from_query_id, v_one_record);
2655:
2656: i := i+1;
2657: v_len := v_len - length(v_one_record)-3;
2658: end loop;
2706:
2707: v_one_record := substr(p_trx_list,instr(p_trx_list,
2708: '(',1,i)+1, instr(p_trx_list,')',1,i)-instr(p_trx_list,'(',1,i)-1);
2709:
2710: msc_gantt_utils.parseResString(v_one_record, l_inst_id, l_org_id,
2711: l_dept_id, l_res_id, l_res_instance_id, l_serial_number);
2712:
2713: if ( p_node_type = RES_NODE ) then -- {
2714:
2871: p_transaction_id number, p_type number, p_view_type number,
2872: v_pro out NOCOPY varchar2, v_demand out NOCOPY varchar2) is
2873: l_end_demand_id number;
2874: begin
2875: msc_gantt_utils.getProperty(p_plan_id, p_instance_id, p_transaction_id,
2876: p_type, p_view_type, l_end_demand_id, v_pro, v_demand);
2877: end getProperty;
2878:
2879: function getDebugProfile return varchar2 is