PACKAGE: APPS.GMDQC_RESULTS

Source

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,
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 
18  PRAGMA RESTRICT_REFERENCES (qc_find_spec,WNDS,WNPS,RNPS);
19 
20 END gmdqc_results;