1 PACKAGE MSC_Rel_PS_Plan_PUB AUTHID CURRENT_USER AS
2 /* $Header: MSCPSRELS.pls 120.3.12010000.1 2008/05/02 19:06:57 appldev ship $ */
3
4 -- Start of Comments
5 -- API name MSC_Release_Plan_Sc
6 -- Type Public
7 -- Procedure
8 --
9 -- Pre-reqs
10 --
11 -- Parameters
12 --
13 -- Version Current version = 1.0
14 -- Initial version = 1.0
15 --
16 -- Notes
17 --
18 -- End of Comments
19
20 -- New Data Type
21
22 TYPE NumTblTyp IS TABLE OF NUMBER;
23
24 -- CONSTANTS --
25 SYS_YES CONSTANT INTEGER := 1;
26 SYS_NO CONSTANT INTEGER := 2;
27
28 REQ_GRP_ALL_ON_ONE CONSTANT INTEGER := 1; -- PO group by
29 REQ_GRP_ITEM CONSTANT INTEGER := 2;
30 REQ_GRP_BUYER CONSTANT INTEGER := 3;
31 REQ_GRP_PLANNER CONSTANT INTEGER := 4;
32 REQ_GRP_VENDOR CONSTANT INTEGER := 5;
33 REQ_GRP_ONE_EACH CONSTANT INTEGER := 6;
34 REQ_GRP_CATEGORY CONSTANT INTEGER := 7;
35 REQ_GRP_LOCATION CONSTANT INTEGER := 8;
36
37 WIP_DIS_MASS_LOAD CONSTANT INTEGER := 1;
38 WIP_REP_MASS_LOAD CONSTANT INTEGER := 2;
39 WIP_DIS_MASS_RESCHEDULE CONSTANT INTEGER := 4;
40 PO_MASS_LOAD CONSTANT INTEGER := 8;
41 PO_MASS_RESCHEDULE CONSTANT INTEGER := 16;
42
43 PURCHASE_ORDER CONSTANT INTEGER := 1; -- order type lookup
44 PURCH_REQ CONSTANT INTEGER := 2;
45 WORK_ORDER CONSTANT INTEGER := 3;
46 REPETITVE_SCHEDULE CONSTANT INTEGER := 4;
47 PLANNED_ORDER CONSTANT INTEGER := 5;
48 MATERIAL_TRANSFER CONSTANT INTEGER := 6;
49 NONSTD_JOB CONSTANT INTEGER := 7;
50 RECEIPT_PURCH_ORDER CONSTANT INTEGER := 8;
51 REQUIREMENT CONSTANT INTEGER := 9;
52 FPO_SUPPLY CONSTANT INTEGER := 10;
53
54 NOT_UNDER_REV_CONTROL CONSTANT INTEGER := 1;
55 UNDER_REV_CONTROL CONSTANT INTEGER := 2;
56
57 PURCHASING_BY_REV CONSTANT INTEGER := 1;
58 NOT_PURCHASING_BY_REV CONSTANT INTEGER := 2;
59
60
61 LT_RESOURCE CONSTANT INTEGER := 1; -- wip details load type
62 LT_COMPONENT CONSTANT INTEGER := 2;
63 LT_OPERATION CONSTANT INTEGER := 3;
64 LT_RESOURCE_USAGE CONSTANT INTEGER := 4;
65
66 SUBST_DELETE CONSTANT INTEGER := 1; -- wip details substitution
67 SUBST_ADD CONSTANT INTEGER := 2; -- type
68 SUBST_CHANGE CONSTANT INTEGER := 3;
69
70 -- Variables --
71 v_hour_uom VARCHAR2(4);
72 v_purchasing_by_rev NUMBER;
73 v_instance_code_length NUMBER;
74
75 -- Procedures --
76 PROCEDURE MSC_PS_RELEASE
77 ( p_plan_id IN NUMBER
78 , p_organization_id IN NUMBER
79 , p_instance_id IN NUMBER
80 , p_plan_name IN VARCHAR2
81 , p_user_id IN VARCHAR2
82 , p_loaded_jobs IN OUT NOCOPY NUMBER
83 , p_resched_jobs IN OUT NOCOPY NUMBER
84 , p_req_id IN OUT NOCOPY NUMBER );
85
86 PROCEDURE MSC_RELEASE_PLAN_SC
87 ( arg_plan_id IN NUMBER
88 , arg_log_org_id IN NUMBER
89 , arg_log_sr_instance IN NUMBER
90 , arg_org_id IN NUMBER
91 , arg_sr_instance IN NUMBER
92 , arg_compile_desig IN VARCHAR2
93 , arg_user_id IN NUMBER
94 , arg_po_group_by IN NUMBER
95 , arg_po_batch_number IN NUMBER
96 , arg_wip_group_id IN NUMBER
97 , arg_loaded_jobs IN OUT NOCOPY NumTblTyp
98 , arg_loaded_reqs IN OUT NOCOPY NumTblTyp
99 , arg_loaded_scheds IN OUT NOCOPY NumTblTyp
100 , arg_resched_jobs IN OUT NOCOPY NumTblTyp
101 , arg_resched_reqs IN OUT NOCOPY NumTblTyp
102 , arg_wip_req_id IN OUT NOCOPY NumTblTyp
103 , arg_req_load_id IN OUT NOCOPY NumTblTyp
104 , arg_req_resched_id IN OUT NOCOPY NumTblTyp
105 , arg_released_instance IN OUT NOCOPY NumTblTyp
106 , arg_mode IN VARCHAR2 DEFAULT NULL
107 , arg_transaction_id IN NUMBER DEFAULT NULL
108 , arg_loaded_lot_jobs IN OUT NOCOPY NumTblTyp
109 , arg_resched_lot_jobs IN OUT NOCOPY NumTblTyp
110 , arg_osfm_req_id IN OUT NOCOPY NumTblTyp
111 , arg_loaded_int_repair_orders IN OUT NOCOPY NumTblTyp
112 , arg_int_repair_orders_id IN OUT NOCOPY NumTblTyp
113 );
114
115
116 PROCEDURE LOAD_MSC_INTERFACE
117 ( arg_dblink IN VARCHAR2
118 , arg_plan_id IN NUMBER
119 , arg_log_org_id IN NUMBER
120 , arg_org_instance IN NUMBER
121 , arg_owning_org_id IN NUMBER
122 , arg_owning_instance IN NUMBER
123 , arg_compile_desig IN VARCHAR2
124 , arg_user_id IN NUMBER
125 , arg_po_group_by IN NUMBER
126 , arg_po_batch_number IN NUMBER
127 , arg_wip_group_id IN NUMBER
128 , arg_loaded_jobs IN OUT NOCOPY NUMBER
129 , arg_loaded_lot_jobs IN OUT NOCOPY NUMBER
130 , arg_resched_lot_jobs IN OUT NOCOPY NUMBER
131 , arg_loaded_reqs IN OUT NOCOPY NUMBER
132 , arg_loaded_scheds IN OUT NOCOPY NUMBER
133 , arg_resched_jobs IN OUT NOCOPY NUMBER
134 , arg_resched_reqs IN OUT NOCOPY NUMBER
135 , arg_wip_req_id IN OUT NOCOPY NUMBER
136 , arg_osfm_req_id IN OUT NOCOPY NUMBER
137 , arg_req_load_id IN OUT NOCOPY NUMBER
138 , arg_req_resched_id IN OUT NOCOPY NUMBER
139 , arg_mode IN VARCHAR2 DEFAULT NULL
140 , arg_transaction_id IN NUMBER DEFAULT NULL
141 , l_apps_ver IN VARCHAR2
142 , arg_loaded_int_repair_orders IN OUT NOCOPY Number
143 , arg_int_repair_orders_id IN OUT NOCOPY Number
144 );
145
146
147
148 FUNCTION load_wip_discr_jobs_ps
149 ( arg_plan_id IN NUMBER
150 , arg_log_org_id IN NUMBER
151 , arg_org_instance IN NUMBER
152 , arg_owning_org_id IN NUMBER
153 , arg_owning_instance IN NUMBER
154 , arg_user_id IN NUMBER
155 , arg_wip_group_id IN NUMBER
156 , l_apps_ver IN VARCHAR2
157 )RETURN NUMBER;
158
159 FUNCTION load_osfm_lot_jobs_ps
160 ( arg_plan_id IN NUMBER
161 , arg_log_org_id IN NUMBER
162 , arg_org_instance IN NUMBER
163 , arg_owning_org_id IN NUMBER
164 , arg_owning_instance IN NUMBER
165 , arg_user_id IN NUMBER
166 , arg_wip_group_id IN NUMBER
167 , arg_transaction_id IN NUMBER
168 , l_apps_ver IN VARCHAR2
169 )RETURN NUMBER;
170
171
172
173 FUNCTION reschedule_osfm_lot_jobs_ps
174 ( arg_plan_id IN NUMBER
175 , arg_log_org_id IN NUMBER
176 , arg_org_instance IN NUMBER
177 , arg_owning_org_id IN NUMBER
178 , arg_owning_instance IN NUMBER
179 , arg_user_id IN NUMBER
180 , arg_wip_group_id IN NUMBER
181 , arg_transaction_id IN NUMBER
182 )RETURN NUMBER;
183
184
185 FUNCTION reschedule_wip_discr_jobs_ps
186 ( arg_plan_id IN NUMBER
187 , arg_log_org_id IN NUMBER
188 , arg_org_instance IN NUMBER
189 , arg_owning_org_id IN NUMBER
190 , arg_owning_instance IN NUMBER
191 , arg_user_id IN NUMBER
192 , arg_wip_group_id IN NUMBER
193 , arg_transaction_id IN NUMBER
194 , l_apps_ver IN VARCHAR2
195 )RETURN NUMBER;
196
197
198 END MSC_Rel_PS_Plan_PUB;