[Home] [Help]
PACKAGE: APPS.MRP_RELEASE_EAM_WO
Source
1 PACKAGE MRP_RELEASE_EAM_WO AUTHID CURRENT_USER AS
2 /* $Header: MSCERELS.pls */
3
4 TYPE WO_ORG_REC IS RECORD( SOURCE_LINE_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 REBUILD_ITEM_ID NUMBER,
12 -- BOM_REVISION_DATE DATE ,
13 -- ROUTING_REVISION_DATE DATE ,
14 CLASS_CODE VARCHAR2( 10 ) ,
15 JOB_NAME VARCHAR2( 240 ) ,
16 FIRM_PLANNED_FLAG NUMBER,
17 ALTERNATE_ROUTING_DESIGNATOR VARCHAR2( 10 ),
18 ALTERNATE_BOM_DESIGNATOR VARCHAR2( 10 ) ,
19 START_QUANTITY NUMBER,
20 WIP_ENTITY_ID NUMBER ,
21 SCHEDULE_GROUP_ID NUMBER ,
22 PROJECT_ID NUMBER ,
23 TASK_ID NUMBER ,
24 END_ITEM_UNIT_NUMBER VARCHAR2( 30 ) ,
25 HEADER_ID NUMBER ,
26 LAST_UNIT_COMPLETION_DATE DATE,
27 ACTIVITY_TYPE 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 TYPE JOBS_CUR_TBL_TYPE IS TABLE OF JOBS_CUR_REC INDEX BY BINARY_INTEGER ;
35 TYPE WO_ORG_TBL IS TABLE OF WO_ORG_REC INDEX BY BINARY_INTEGER ;
36 TYPE CurTyp IS REF CURSOR; -- define weak REF CURSOR type
37
38 PROCEDURE RELEASE_EAM_WO( ERRBUF OUT NOCOPY VARCHAR2
39 ,RETCODE OUT NOCOPY VARCHAR2
40 ,P_DBLINK IN VARCHAR2
41 ,P_GROUP_ID IN Number
42 ,P_SR_INSTANCE_ID IN NUMBER) ;
43
44 PROCEDURE Process_Single_WO (
45 V_SOURCE_LINE_ID IN NUMBER
46 ,V_ORGANIZATION_ID IN NUMBER );
47
48 PROCEDURE GET_WO_DETAIL (V_SOURCE_LINE_ID IN NUMBER, V_ORGANIZATION_ID IN NUMBER,
49 L_EAM_WO_TBL OUT NOCOPY EAM_PROCESS_WO_PUB.EAM_WO_TBL_TYPE,
50 L_START_QUANTITY OUT NOCOPY NUMBER);
51
52 END MRP_RElEASE_EAM_WO;