1: PACKAGE gmdqc_results AUTHID CURRENT_USER AS
2: /*$Header : $ */
3: function QC_FIND_SPEC (
4: p_item_id qc_spec_mst.item_id%type,
5: p_sample_date qc_smpl_mst.sample_date%type,
6: P_orgn_code qc_spec_mst.orgn_code%type,
7: P_CUST_ID qc_spec_mst.CUST_ID%type default NULL,
8: P_VENDOR_ID qc_spec_mst.VENDOR_ID%type default NULL,
2: /*$Header : $ */
3: function QC_FIND_SPEC (
4: p_item_id qc_spec_mst.item_id%type,
5: p_sample_date qc_smpl_mst.sample_date%type,
6: P_orgn_code qc_spec_mst.orgn_code%type,
7: P_CUST_ID qc_spec_mst.CUST_ID%type default NULL,
8: P_VENDOR_ID qc_spec_mst.VENDOR_ID%type default NULL,
9: P_LOT_ID qc_spec_mst.LOT_ID%type default NULL,
10: P_WHSE_CODE qc_spec_mst.WHSE_CODE%type default NULL,
3: function QC_FIND_SPEC (
4: p_item_id qc_spec_mst.item_id%type,
5: p_sample_date qc_smpl_mst.sample_date%type,
6: P_orgn_code qc_spec_mst.orgn_code%type,
7: P_CUST_ID qc_spec_mst.CUST_ID%type default NULL,
8: P_VENDOR_ID qc_spec_mst.VENDOR_ID%type default NULL,
9: P_LOT_ID qc_spec_mst.LOT_ID%type default NULL,
10: P_WHSE_CODE qc_spec_mst.WHSE_CODE%type default NULL,
11: P_LOCATION qc_spec_mst.LOCATION%type default NULL,
4: p_item_id qc_spec_mst.item_id%type,
5: p_sample_date qc_smpl_mst.sample_date%type,
6: P_orgn_code qc_spec_mst.orgn_code%type,
7: P_CUST_ID qc_spec_mst.CUST_ID%type default NULL,
8: P_VENDOR_ID qc_spec_mst.VENDOR_ID%type default NULL,
9: P_LOT_ID qc_spec_mst.LOT_ID%type default NULL,
10: P_WHSE_CODE qc_spec_mst.WHSE_CODE%type default NULL,
11: P_LOCATION qc_spec_mst.LOCATION%type default NULL,
12: P_BATCH_ID qc_spec_mst.BATCH_ID%type default NULL,
5: p_sample_date qc_smpl_mst.sample_date%type,
6: P_orgn_code qc_spec_mst.orgn_code%type,
7: P_CUST_ID qc_spec_mst.CUST_ID%type default NULL,
8: P_VENDOR_ID qc_spec_mst.VENDOR_ID%type default NULL,
9: P_LOT_ID qc_spec_mst.LOT_ID%type default NULL,
10: P_WHSE_CODE qc_spec_mst.WHSE_CODE%type default NULL,
11: P_LOCATION qc_spec_mst.LOCATION%type default NULL,
12: P_BATCH_ID qc_spec_mst.BATCH_ID%type default NULL,
13: P_FORMULA_ID qc_spec_mst.FORMULA_ID%type default NULL,
6: P_orgn_code qc_spec_mst.orgn_code%type,
7: P_CUST_ID qc_spec_mst.CUST_ID%type default NULL,
8: P_VENDOR_ID qc_spec_mst.VENDOR_ID%type default NULL,
9: P_LOT_ID qc_spec_mst.LOT_ID%type default NULL,
10: P_WHSE_CODE qc_spec_mst.WHSE_CODE%type default NULL,
11: P_LOCATION qc_spec_mst.LOCATION%type default NULL,
12: P_BATCH_ID qc_spec_mst.BATCH_ID%type default NULL,
13: P_FORMULA_ID qc_spec_mst.FORMULA_ID%type default NULL,
14: P_ROUTING_ID qc_spec_mst.ROUTING_ID%type default NULL,
7: P_CUST_ID qc_spec_mst.CUST_ID%type default NULL,
8: P_VENDOR_ID qc_spec_mst.VENDOR_ID%type default NULL,
9: P_LOT_ID qc_spec_mst.LOT_ID%type default NULL,
10: P_WHSE_CODE qc_spec_mst.WHSE_CODE%type default NULL,
11: P_LOCATION qc_spec_mst.LOCATION%type default NULL,
12: P_BATCH_ID qc_spec_mst.BATCH_ID%type default NULL,
13: P_FORMULA_ID qc_spec_mst.FORMULA_ID%type default NULL,
14: P_ROUTING_ID qc_spec_mst.ROUTING_ID%type default NULL,
15: P_OPRN_ID qc_spec_mst.OPRN_ID%type default NULL,
8: P_VENDOR_ID qc_spec_mst.VENDOR_ID%type default NULL,
9: P_LOT_ID qc_spec_mst.LOT_ID%type default NULL,
10: P_WHSE_CODE qc_spec_mst.WHSE_CODE%type default NULL,
11: P_LOCATION qc_spec_mst.LOCATION%type default NULL,
12: P_BATCH_ID qc_spec_mst.BATCH_ID%type default NULL,
13: P_FORMULA_ID qc_spec_mst.FORMULA_ID%type default NULL,
14: P_ROUTING_ID qc_spec_mst.ROUTING_ID%type default NULL,
15: P_OPRN_ID qc_spec_mst.OPRN_ID%type default NULL,
16: p_routingstep_id qc_spec_mst.routingstep_id%type default NULL) return varchar2;
9: P_LOT_ID qc_spec_mst.LOT_ID%type default NULL,
10: P_WHSE_CODE qc_spec_mst.WHSE_CODE%type default NULL,
11: P_LOCATION qc_spec_mst.LOCATION%type default NULL,
12: P_BATCH_ID qc_spec_mst.BATCH_ID%type default NULL,
13: P_FORMULA_ID qc_spec_mst.FORMULA_ID%type default NULL,
14: P_ROUTING_ID qc_spec_mst.ROUTING_ID%type default NULL,
15: P_OPRN_ID qc_spec_mst.OPRN_ID%type default NULL,
16: p_routingstep_id qc_spec_mst.routingstep_id%type default NULL) return varchar2;
17:
10: P_WHSE_CODE qc_spec_mst.WHSE_CODE%type default NULL,
11: P_LOCATION qc_spec_mst.LOCATION%type default NULL,
12: P_BATCH_ID qc_spec_mst.BATCH_ID%type default NULL,
13: P_FORMULA_ID qc_spec_mst.FORMULA_ID%type default NULL,
14: P_ROUTING_ID qc_spec_mst.ROUTING_ID%type default NULL,
15: P_OPRN_ID qc_spec_mst.OPRN_ID%type default NULL,
16: p_routingstep_id qc_spec_mst.routingstep_id%type default NULL) return varchar2;
17:
18: PRAGMA RESTRICT_REFERENCES (qc_find_spec,WNDS,WNPS,RNPS);
11: P_LOCATION qc_spec_mst.LOCATION%type default NULL,
12: P_BATCH_ID qc_spec_mst.BATCH_ID%type default NULL,
13: P_FORMULA_ID qc_spec_mst.FORMULA_ID%type default NULL,
14: P_ROUTING_ID qc_spec_mst.ROUTING_ID%type default NULL,
15: P_OPRN_ID qc_spec_mst.OPRN_ID%type default NULL,
16: p_routingstep_id qc_spec_mst.routingstep_id%type default NULL) return varchar2;
17:
18: PRAGMA RESTRICT_REFERENCES (qc_find_spec,WNDS,WNPS,RNPS);
19:
12: P_BATCH_ID qc_spec_mst.BATCH_ID%type default NULL,
13: P_FORMULA_ID qc_spec_mst.FORMULA_ID%type default NULL,
14: P_ROUTING_ID qc_spec_mst.ROUTING_ID%type default NULL,
15: P_OPRN_ID qc_spec_mst.OPRN_ID%type default NULL,
16: p_routingstep_id qc_spec_mst.routingstep_id%type default NULL) return varchar2;
17:
18: PRAGMA RESTRICT_REFERENCES (qc_find_spec,WNDS,WNPS,RNPS);
19:
20: END gmdqc_results;