1 PACKAGE QA_INSPECTION_PKG AUTHID CURRENT_USER AS
2 /* $Header: qainsps.pls 120.0.12000000.1 2007/01/19 07:09:00 appldev ship $ */
3
4 --
5 -- This procedure initialize temp table
6 -- qa_insp_collections_temp and qa_insp_plans_temp
7 -- for the given collection id and plan id
8 -- These temp tables are used for both skip lot and
9 -- sampling project
10 --
11 PROCEDURE INIT_COLLECTION (
12 p_collection_id IN NUMBER,
13 p_lot_size IN NUMBER,
14 p_coll_plan_id IN NUMBER,
15 p_uom_name IN VARCHAR2);
16
17
18 --
19 -- This procedure dispatch action launching
20 -- logic based on sampling and skiplot flag
21 -- It does nothing for regular inspection
22 --
23 PROCEDURE LAUNCH_SHIPMENT_ACTION(
24 p_po_processor_mode IN VARCHAR2,
25 p_group_id IN NUMBER,
26 p_employee_id IN NUMBER);
27
28 --
29 -- This function returns fnd_api.g_false
30 -- if the collection is under either skiplot
31 -- or sampling control, fnd_api.g_true otherwise
32 --
33 FUNCTION IS_REGULAR_INSP (
34 p_collection_id IN NUMBER) RETURN VARCHAR2;
35
36 --
37 -- This function returns fnd_api.g_true
38 -- if the collection is under sampling control
39 -- fnd_api.g_false otherwise
40 --
41 FUNCTION IS_SAMPLING_INSP(
42 p_collection_id IN NUMBER) RETURN VARCHAR2;
43
44 --
45 -- This function returns fnd_api.g_true
46 -- if the collection is under skip lot control
47 -- fnd_api.g_false otherwise
48 --
49 FUNCTION IS_SKIPLOT_INSP(
50 p_collection_id IN NUMBER) RETURN VARCHAR2;
51
52 --
53 -- The function returns whether QA is installed
54 --
55 FUNCTION QA_INSTALLATION RETURN VARCHAR2;
56
57 --
58 -- The function returns whether QA_PO_INSPECTION profile
59 -- is set to Quality
60 --
61 FUNCTION QA_INSPECTION RETURN VARCHAR2;
62
63
64 END QA_INSPECTION_PKG;
65
[Home] [Help]