[Home] [Help]
PACKAGE: APPS.MRP_RESCHEDULE_CMRO_WO_PS
Source
1 PACKAGE MRP_RESCHEDULE_CMRO_WO_PS AUTHID CURRENT_USER AS
2 /* $Header: MRPPSRELS.pls 120.6 2011/05/12 14:27:31 vsiyer noship $ */
3
4 TYPE WO_ORG_REC IS RECORD( WIP_ENTITY_ID NUMBER ,ORGANIZATION_ID NUMBER) ;
5 TYPE JOBS_CUR_REC IS RECORD(
6 SOURCE_CODE VARCHAR2( 30 ),
7 SOURCE_LINE_ID NUMBER ,
8 ORGANIZATION_ID NUMBER ,
9 STATUS_TYPE NUMBER ,
10 FIRST_UNIT_START_DATE DATE ,
11 BOM_REVISION_DATE DATE ,
12 ROUTING_REVISION_DATE DATE ,
13 CLASS_CODE VARCHAR2( 10 ) ,
14 JOB_NAME VARCHAR2( 240 ) ,
15 FIRM_PLANNED_FLAG NUMBER,
16 ALTERNATE_ROUTING_DESIGNATOR VARCHAR2( 10 ),
17 ALTERNATE_BOM_DESIGNATOR VARCHAR2( 10 ) ,
18 START_QUANTITY NUMBER,
19 WIP_ENTITY_ID NUMBER ,
20 SCHEDULE_GROUP_ID NUMBER ,
21 PROJECT_ID NUMBER ,
22 TASK_ID NUMBER ,
23 END_ITEM_UNIT_NUMBER VARCHAR2( 30 ) ,
24 HEADER_ID NUMBER ,
25 LAST_UNIT_COMPLETION_DATE DATE,
26 ASSET_NUMBER VARCHAR2( 30 ) ,
27 ASSET_GROUP_ID NUMBER,
28 MAINTENANCE_OBJECT_ID NUMBER,
29 MAINTENANCE_OBJECT_TYPE NUMBER,
30 MAINTENANCE_OBJECT_SOURCE NUMBER,
31 DATE_RELEASED DATE,
32 OWNING_DEPARTMENT NUMBER
33 );
34
35 TYPE OP_CUR_REC IS RECORD(
36 PARENT_HEADER_ID NUMBER,
37 WIP_ENTITY_ID NUMBER,
38 ORGANIZATION_ID NUMBER,
39 OPERATION_SEQ_NUM NUMBER,
40 DEPARTMENT_ID NUMBER,
41 DESCRIPTION VARCHAR2( 240 ) ,
42 MINIMUM_TRANSFER_QUANTITY NUMBER,
43 COUNT_POINT_TYPE NUMBER,
44 BACKFLUSH_FLAG NUMBER,
45 START_DATE DATE,
46 COMPLETION_DATE DATE
47 );
48 TYPE RES_CUR_REC IS RECORD(
49 PARENT_HEADER_ID NUMBER,
50 BATCH_ID NUMBER ,
51 WIP_ENTITY_ID NUMBER,
52 ORGANIZATION_ID NUMBER,
53 OPERATION_SEQ_NUM NUMBER,
54 RESOURCE_SEQ_NUM NUMBER,
55 RESOURCE_ID_NEW NUMBER,
56 BASIS_TYPE NUMBER,
57 USAGE_RATE_OR_AMOUNT NUMBER,
58 SCHEDULED_FLAG NUMBER,
59 ASSIGNED_UNITS NUMBER,
60 AUTOCHARGE_TYPE NUMBER,
61 START_DATE DATE,
62 COMPLETION_DATE DATE,
63 DEPARTMENT_ID NUMBER,
64 FIRM_FLAG NUMBER
65 ) ;
66
67 TYPE MAT_CUR_REC IS RECORD(
68 PARENT_HEADER_ID NUMBER,
69 BATCH_ID NUMBER,
70 WIP_ENTITY_ID NUMBER,
71 ORGANIZATION_ID NUMBER,
72 OPERATION_SEQ_NUM NUMBER,
73 INVENTORY_ITEM_ID_NEW NUMBER,
74 DEPARTMENT_ID NUMBER,
75 WIP_SUPPLY_TYPE NUMBER,
76 DATE_REQUIRED DATE,
77 REQUIRED_QUANTITY NUMBER
78 );
79
80 TYPE MAT_SUB_CUR_REC IS RECORD(
81 PARENT_HEADER_ID NUMBER,
82 BATCH_ID NUMBER,
83 WIP_ENTITY_ID NUMBER,
84 ORGANIZATION_ID NUMBER,
85 OPERATION_SEQ_NUM NUMBER,
86 INVENTORY_ITEM_ID_OLD NUMBER,
87 INVENTORY_ITEM_ID_NEW NUMBER,
88 DEPARTMENT_ID NUMBER,
89 WIP_SUPPLY_TYPE NUMBER,
90 DATE_REQUIRED DATE,
91 REQUIRED_QUANTITY NUMBER,
92 TRANSACTION_TYPE NUMBER DEFAULT NULL
93 );
94
95 TYPE RES_INST_CUR_REC IS RECORD(
96 PARENT_HEADER_ID NUMBER,
97 BATCH_ID NUMBER,
98 WIP_ENTITY_ID NUMBER,
99 ORGANIZATION_ID NUMBER,
100 OPERATION_SEQ_NUM NUMBER,
101 RESOURCE_SEQ_NUM NUMBER,
102 RESOURCE_INSTANCE_ID NUMBER,
103 SERIAL_NUMBER VARCHAR2(30),
104 START_DATE DATE,
105 COMPLETION_DATE DATE);
106
107 TYPE RES_USAGE_CUR_REC IS RECORD(
108 PARENT_HEADER_ID NUMBER,
109 BATCH_ID NUMBER,
110 WIP_ENTITY_ID NUMBER,
111 ORGANIZATION_ID NUMBER,
112 OPERATION_SEQ_NUM NUMBER,
113 RESOURCE_SEQ_NUM NUMBER,
114 START_DATE DATE,
115 COMPLETION_DATE DATE,
116 ASSIGNED_UNITS NUMBER,
117 RESOURCE_INSTANCE_ID NUMBER,
118 SERIAL_NUMBER VARCHAR2(30));
119
120 TYPE REL_WO_CUR_REC IS RECORD(
121 WIP_ENTITY_ID NUMBER,
122 ORGANIZATION_ID NUMBER,
123 MAINTENANCE_OBJECT_SOURCE NUMBER,
124 PRIMARY_ITEM_ID NUMBER,
125 START_QUANTITY NUMBER,
126 UOM_CODE VARCHAR2(3),
127 FIRST_UNIT_START_DATE DATE);
128
129 TYPE REL_WO_CUR_TBL_TYPE IS TABLE OF REL_WO_CUR_REC INDEX BY BINARY_INTEGER ;
130 TYPE JOBS_CUR_TBL_TYPE IS TABLE OF JOBS_CUR_REC INDEX BY BINARY_INTEGER ;
131 TYPE WO_ORG_TBL IS TABLE OF WO_ORG_REC INDEX BY BINARY_INTEGER ;
132 TYPE OP_CUR_TBL_TYPE IS TABLE OF OP_CUR_REC INDEX BY BINARY_INTEGER ;
133 TYPE RES_CUR_TBL_TYPE IS TABLE OF RES_CUR_REC INDEX BY BINARY_INTEGER ;
134 TYPE MAT_CUR_TBL_TYPE IS TABLE OF MAT_CUR_REC INDEX BY BINARY_INTEGER ;
135 TYPE RES_INST_CUR_TBL_TYPE IS TABLE OF RES_INST_CUR_REC INDEX BY BINARY_INTEGER;
136 TYPE RES_USAGE_CUR_TBL_TYPE IS TABLE OF RES_USAGE_CUR_REC INDEX BY BINARY_INTEGER;
137 TYPE MAT_SUB_CUR_TBL_TYPE IS TABLE OF MAT_SUB_CUR_REC INDEX BY BINARY_INTEGER ;
138
139 TYPE CurTyp IS REF CURSOR; -- define weak REF CURSOR type
140
141 PROCEDURE RESCHEDULE_CMRO_WO
142 (
143 ERRBUF OUT NOCOPY VARCHAR2
144 ,RETCODE OUT NOCOPY VARCHAR2
145 ,P_DBLINK IN VARCHAR2
146 ,P_GROUP_ID IN NUMBER
147 ,P_SR_INSTANCE_ID IN NUMBER
148 );
149
150 PROCEDURE Process_Single_WO
151 (
152 V_WIP_ENTITY_ID IN NUMBER
153 ,V_ORGANIZATION_ID IN NUMBER
154 );
155 PROCEDURE RELEASE_CMRO_WO(
156 ERRBUF OUT NOCOPY VARCHAR2
157 ,RETCODE OUT NOCOPY VARCHAR2
158 ,P_DBLINK IN VARCHAR2
159 ,P_GROUP_ID IN Number
160 ,P_SR_INSTANCE_ID IN NUMBER
161 ,P_PLAN_COMPLETION_DATE IN DATE);
162
163
164 PROCEDURE Process_Single_WO_EAM
165 (
166 V_WIP_ENTITY_ID IN NUMBER
167 ,V_ORGANIZATION_ID IN NUMBER
168 );
169
170 PROCEDURE GET_WO_DETAIL
171 (
172 V_WIP_ENTITY_ID IN NUMBER, V_ORGANIZATION_ID IN NUMBER
173 ,L_EAM_WO_TBL OUT NOCOPY EAM_PROCESS_WO_PUB.EAM_WO_TBL_TYPE
174 );
175
176 PROCEDURE GET_OP_DETAIL (V_WIP_ENTITY_ID IN NUMBER ,
177 V_ORGANIZATION_ID IN NUMBER ,
178 L_EAM_OP_TBL OUT NOCOPY EAM_PROCESS_WO_PUB.EAM_OP_TBL_TYPE
179 );
180 PROCEDURE GET_RES_DETAIL(V_WIP_ENTITY_ID IN NUMBER ,
181 V_ORGANIZATION_ID IN NUMBER ,
182 L_EAM_RES_TBL OUT NOCOPY EAM_PROCESS_WO_PUB.EAM_RES_TBL_TYPE
183 );
184
185 PROCEDURE GET_MAT_DETAIL(V_WIP_ENTITY_ID IN NUMBER ,V_ORGANIZATION_ID IN NUMBER,
186 L_EAM_MAT_TBL OUT NOCOPY EAM_PROCESS_WO_PUB.EAM_MAT_REQ_TBL_TYPE ) ;
187
188 PROCEDURE GET_SUB_MAT_DETAIL(V_WIP_ENTITY_ID IN NUMBER ,V_ORGANIZATION_ID IN NUMBER,
189 L_EAM_MAT_TBL OUT NOCOPY EAM_PROCESS_WO_PUB.EAM_MAT_REQ_TBL_TYPE ) ;
190
191
192 PROCEDURE POPULATE_MISSING_DETAILS( V_WIP_ENTITY_ID IN NUMBER ,
193 V_ORGANIZATION_ID IN NUMBER,
194 P_JOB_START_DATE IN DATE
195 );
196
197
198 PROCEDURE GET_RES_INST_DETAIL(V_WIP_ENTITY_ID IN NUMBER ,
199 V_ORGANIZATION_ID IN NUMBER,
200 L_EAM_RES_INST_TBL OUT NOCOPY EAM_PROCESS_WO_PUB.EAM_RES_INST_TBL_TYPE);
201
202 PROCEDURE GET_RES_USAGE_DETAIL(V_WIP_ENTITY_ID IN NUMBER ,
203 V_ORGANIZATION_ID IN NUMBER,
204 L_EAM_RES_USAGE_TBL OUT NOCOPY EAM_PROCESS_WO_PUB.EAM_RES_USAGE_TBL_TYPE);
205
206 END MRP_RESCHEDULE_CMRO_WO_PS;