1 PACKAGE EAM_WO_SCHEDULE_PVT AS
2 /* $Header: EAMVSCDS.pls 120.2 2005/08/08 07:49:39 cboppana noship $ */
3 /***************************************************************************
4 --
5 -- Copyright (c) 2002 Oracle Corporation, Redwood Shores, CA, USA
6 -- All rights reserved.
7 --
8 -- FILENAME
9 --
10 -- EAMVSCDS.pls
11 --
12 -- DESCRIPTION
13 --
14 -- Spec of package EAM_WO_SCHEDULE_PVT
15 --
16 -- NOTES
17 --
18 -- HISTORY
19 --
20 -- 12-JUN-2002 Kenichi Nagumo Initial Creation
21 ***************************************************************************/
22
23 TYPE shift_date_rec IS RECORD
24 ( shift_date DATE,
25 shift_num NUMBER,
26 seq_num NUMBER,
27 calendar_code VARCHAR2(10));
28
29 TYPE shift_date_tab IS TABLE OF shift_date_rec
30 INDEX BY BINARY_INTEGER;
31 shift_date_tbl shift_date_tab;
32
33 TYPE op_res_info_rec IS RECORD
34 ( op_seq_num NUMBER,
35 op_seq_id NUMBER,
36 op_start_date DATE,
37 op_completion_date DATE,
38 op_completed VARCHAR2(1),
39 res_seq_num NUMBER,
40 res_sch_num NUMBER,
41 res_id NUMBER,
42 res_start_date DATE,
43 res_completion_date DATE,
44 assigned_units NUMBER,
45 capacity_units NUMBER,
46 usage_rate NUMBER,
47 scheduled_flag NUMBER,
48 avail_24_hrs_flag NUMBER
49 );
50
51 TYPE op_scd_seq_rec IS RECORD
52 ( level NUMBER,
53 op_seq_num NUMBER,
54 op_start_date DATE,
55 op_completion_date DATE
56 );
57
58 TYPE op_res_sft_rec IS RECORD
59 (op_seq_num NUMBER,
60 res_seq_num NUMBER,
61 shift_num NUMBER,
62 from_time NUMBER,
63 to_time NUMBER
64 );
65
66 TYPE op_res_info_tab IS TABLE OF op_res_info_rec
67 INDEX BY BINARY_INTEGER;
68
69 op_res_info_tbl op_res_info_tab;
70
71 TYPE op_scd_seq_tab IS TABLE OF op_scd_seq_rec
72
73 INDEX BY BINARY_INTEGER;
74
75 op_scd_seq_tbl op_scd_seq_tab;
76
77 TYPE dep_op_seq_num_tab is TABLE OF wip_operations.operation_seq_num%TYPE
78 INDEX BY BINARY_INTEGER;
79
80 dep_op_seq_num_tbl dep_op_seq_num_tab;
81
82 TYPE op_res_sft_tab IS TABLE OF op_res_sft_rec
83 INDEX BY BINARY_INTEGER;
84
85 op_res_sft_tbl op_res_sft_tab;
86
87 TYPE res_sft_rec IS RECORD
88 (shift_num NUMBER,
89 from_time NUMBER,
90 to_time NUMBER
91 );
92
93 TYPE l_res_sft_tab IS TABLE OF res_sft_rec
94 INDEX BY BINARY_INTEGER;
95 l_res_sft_tbl l_res_sft_tab;
96
97 /* procedure for identifying that current date is workday or not */
98 PROCEDURE EAM_GET_SHIFT_WKDAYS
99 ( p_curr_date IN DATE,
100 p_calendar_code IN VARCHAR2,
101 p_shift_num IN NUMBER,
102 p_schedule_dir IN NUMBER,
103 x_wkday_flag OUT NOCOPY NUMBER,
104 x_error_message OUT NOCOPY VARCHAR2,
105 x_return_status OUT NOCOPY VARCHAR2
106 );
107
108 /* Procedure SCHEDULE_OPERATIONS is for scheduling the operations cosidering the prior and next
109 dependencies for forward and backward schedule. */
110 PROCEDURE SCHEDULE_OPERATIONS
111 ( p_organization_id IN NUMBER,
112 p_wip_entity_id IN NUMBER,
113 p_start_date IN OUT NOCOPY DATE,
114 p_completion_date IN OUT NOCOPY DATE,
115 p_hour_conv IN NUMBER,
116 p_calendar_code IN VARCHAR2,
117 p_excetion_set_id IN NUMBER,
118 p_validation_level IN NUMBER,
119 p_res_usage_tbl IN OUT NOCOPY EAM_PROCESS_WO_PUB.eam_res_usage_tbl_type,
120 p_commit IN VARCHAR2,
121 x_error_message OUT NOCOPY VARCHAR2,
122 x_return_status OUT NOCOPY VARCHAR2
123 );
124
125 PROCEDURE SCHEDULE_WO
126 ( p_organization_id IN NUMBER,
127 p_wip_entity_id IN NUMBER,
128 p_start_date IN OUT NOCOPY DATE,
129 p_completion_date IN OUT NOCOPY DATE,
130 p_validation_level IN NUMBER DEFAULT 0,
131 p_commit IN VARCHAR2 := FND_API.G_FALSE,
132 x_error_message OUT NOCOPY VARCHAR2,
133 x_return_status OUT NOCOPY VARCHAR2
134 );
135
136 END EAM_WO_SCHEDULE_PVT;
137