[Home] [Help]
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;