DBA Data[Home] [Help]

APPS.GMDQC_RESULTS dependencies on QC_SPEC_MST

Line 4: p_item_id qc_spec_mst.item_id%type,

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,

Line 6: P_orgn_code qc_spec_mst.orgn_code%type,

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,

Line 7: P_CUST_ID qc_spec_mst.CUST_ID%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,

Line 8: P_VENDOR_ID qc_spec_mst.VENDOR_ID%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,

Line 9: P_LOT_ID qc_spec_mst.LOT_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,

Line 10: P_WHSE_CODE qc_spec_mst.WHSE_CODE%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,

Line 11: P_LOCATION qc_spec_mst.LOCATION%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,

Line 12: P_BATCH_ID qc_spec_mst.BATCH_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;

Line 13: P_FORMULA_ID qc_spec_mst.FORMULA_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:

Line 14: P_ROUTING_ID qc_spec_mst.ROUTING_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);

Line 15: P_OPRN_ID qc_spec_mst.OPRN_ID%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:

Line 16: p_routingstep_id qc_spec_mst.routingstep_id%type default NULL) return varchar2;

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;