PACKAGE: APPS.PMI_PRODUCTION_SUM

Source

1 PACKAGE PMI_PRODUCTION_SUM AUTHID CURRENT_USER AS
2 /* $Header: PMIPRDAS.pls 115.8 2002/12/05 17:07:45 skarimis ship $ */
3 
4                 PKG_VAR_ITEM_ID_V		ic_item_mst.item_id%TYPE := 0;
5 		PKG_VAR_LOT_ID_V		ic_lots_mst.lot_id%TYPE := 0;
6 		PKG_VAR_QC_GRADE_V		ic_TRAN_CMP.QC_GRADE%TYPE := NULL;
7                 PKG_VAR_BATCH_ID_V1		GME_BATCH_HEADER.BATCH_ID%TYPE := 0;
8                 PKG_VAR_BATCH_ID_V2		GME_BATCH_HEADER.BATCH_ID%TYPE := 0;
9                 PKG_VAR_BATCH_ID_V3		GME_BATCH_HEADER.BATCH_ID%TYPE := 0;
10                 PKG_VAR_BATCH_ID_V4		GME_BATCH_HEADER.BATCH_ID%TYPE := 0;
11                 PKG_VAR_NO_OF_SAMPLES_V		INTEGER := 0;
12                 PKG_VAR_NO_OF_SMPL_CMPLT_V	INTEGER := 0;
13                 PKG_VAR_PASSED_SAMPLES_V	INTEGER := 0;
14                 PKG_VAR_ADJUST_BATCH_V	        INTEGER := 0;
15 
16 
17   PROCEDURE POPULATE_BATCH_STATUS_SUM(errbuf OUT NOCOPY varchar2,retcode OUT NOCOPY VARCHAR2);
18 
19   FUNCTION FIND_PROD_GRADE(TRANS_ID_VI IN INTEGER,ITEM_ID_VI IN INTEGER,LOT_ID_VI IN INTEGER)
20            RETURN VARCHAR2;
21   FUNCTION NO_OF_SAMPLES_TAKEN(BATCH_ID_VI IN INTEGER) RETURN INTEGER;
22   FUNCTION NO_OF_SAMPLES_COMPLET(BATCH_ID_VI IN INTEGER) RETURN INTEGER;
23   FUNCTION NO_OF_SAMPLES_PASSED(BATCH_ID_VI IN INTEGER) RETURN INTEGER;
24   FUNCTION NO_OF_TIMES_ADJUSTED(BATCH_ID_VI IN INTEGER) RETURN INTEGER;
25   FUNCTION SCHD_WORK_HOUR(BATCH_ID_VI IN INTEGER, SCHEDULE_VI IN ps_schd_hdr.schedule%type)
26                     RETURN NUMBER;
27   FUNCTION PLAN_ING_VALUE(BATCH_ID_VI IN INTEGER) RETURN NUMBER;
28   FUNCTION ACTUAL_ING_VALUE(BATCH_ID_VI IN INTEGER) RETURN NUMBER;
29 
30 
31 END PMI_PRODUCTION_SUM;