[Home] [Help]
PACKAGE: APPS.GMD_SPEC_VRS_GRP
Source
1 PACKAGE GMD_SPEC_VRS_GRP AS
2 /* $Header: GMDGSVRS.pls 120.2.12010000.1 2008/07/24 09:54:38 appldev ship $ */
3
4 -- Start of comments
5 --+==========================================================================+
6 --| Copyright (c) 1998 Oracle Corporation |
7 --| Redwood Shores, CA, USA |
8 --| All rights reserved. |
9 --+==========================================================================+
10 --| File Name : GMDGSVRS.pls |
11 --| Package Name : GMD_SPEC_VRS_GRP |
12 --| Type : Group |
13 --| |
14 --| Notes |
15 --| This package contains group layer APIs for Specification Entity |
16 --| |
17 --| HISTORY |
18 --| Chetan Nagar 26-Jul-2002 Created. |
19 --| SaiKiran 05-May-2004 Added 'Delayed Lot Entry' to the |
20 --| signatures of 'get_orgn_quality_details' |
21 --| and 'check_VR_controls' procedures |
22 --+==========================================================================+
23 -- End of comments
24
25 PROCEDURE validate_mon_vr
26 (
27 p_mon_vr IN GMD_MONITORING_SPEC_VRS%ROWTYPE
28 , p_called_from IN VARCHAR2 DEFAULT 'API'
29 , p_operation IN VARCHAR2
30 , x_mon_vr OUT NOCOPY GMD_MONITORING_SPEC_VRS%ROWTYPE
31 , x_return_status OUT NOCOPY VARCHAR2
32 );
33
34 PROCEDURE check_for_null_and_fks_in_mvr
35 (
36 p_mon_vr IN GMD_MONITORING_SPEC_VRS%ROWTYPE
37 , p_spec IN GMD_SPECIFICATIONS%ROWTYPE
38 , x_mon_vr OUT NOCOPY GMD_MONITORING_SPEC_VRS%ROWTYPE
39 , x_return_status OUT NOCOPY VARCHAR2
40 );
41
42 FUNCTION mon_vr_exist(p_mon_vr GMD_MONITORING_SPEC_VRS%ROWTYPE,
43 p_spec GMD_SPECIFICATIONS%ROWTYPE)
44 RETURN BOOLEAN;
45
46 PROCEDURE validate_inv_vr
47 (
48 p_inv_vr IN GMD_INVENTORY_SPEC_VRS%ROWTYPE
49 , p_called_from IN VARCHAR2 DEFAULT 'API'
50 , p_operation IN VARCHAR2
51 , x_inv_vr OUT NOCOPY GMD_INVENTORY_SPEC_VRS%ROWTYPE
52 , x_return_status OUT NOCOPY VARCHAR2
53 );
54
55 PROCEDURE check_for_null_and_fks_in_ivr
56 (
57 p_inv_vr IN GMD_INVENTORY_SPEC_VRS%ROWTYPE
58 , p_spec IN GMD_SPECIFICATIONS%ROWTYPE
59 , x_inv_vr OUT NOCOPY GMD_INVENTORY_SPEC_VRS%ROWTYPE
60 , x_return_status OUT NOCOPY VARCHAR2
61 );
62
63 FUNCTION inv_vr_exist(p_inv_vr GMD_INVENTORY_SPEC_VRS%ROWTYPE,
64 p_spec GMD_SPECIFICATIONS%ROWTYPE)
65 RETURN BOOLEAN;
66
67
68
69 PROCEDURE validate_wip_vr
70 (
71 p_wip_vr IN GMD_WIP_SPEC_VRS%ROWTYPE
72 , p_called_from IN VARCHAR2 DEFAULT 'API'
73 , p_operation IN VARCHAR2
74 , x_wip_vr OUT NOCOPY GMD_WIP_SPEC_VRS%ROWTYPE
75 , x_return_status OUT NOCOPY VARCHAR2
76 );
77
78 PROCEDURE check_for_null_and_fks_in_wvr
79 (
80 p_wip_vr IN GMD_WIP_SPEC_VRS%ROWTYPE
81 , p_spec IN GMD_SPECIFICATIONS%ROWTYPE
82 , x_wip_vr OUT NOCOPY GMD_WIP_SPEC_VRS%ROWTYPE
83 , x_return_status OUT NOCOPY VARCHAR2
84 );
85
86 FUNCTION wip_vr_exist(p_wip_vr GMD_WIP_SPEC_VRS%ROWTYPE,
87 p_spec GMD_SPECIFICATIONS%ROWTYPE)
88 RETURN BOOLEAN;
89
90
91
92 PROCEDURE validate_cust_vr
93 (
94 p_cust_vr IN GMD_CUSTOMER_SPEC_VRS%ROWTYPE
95 , p_called_from IN VARCHAR2 DEFAULT 'API'
96 , p_operation IN VARCHAR2
97 , x_return_status OUT NOCOPY VARCHAR2
98 );
99
100 PROCEDURE check_for_null_and_fks_in_cvr
101 (
102 p_cust_vr IN gmd_customer_spec_vrs%ROWTYPE
103 , p_spec IN gmd_specifications%ROWTYPE
104 , x_return_status OUT NOCOPY VARCHAR2
105 );
106
107 FUNCTION cust_vr_exist(p_cust_vr GMD_CUSTOMER_SPEC_VRS%ROWTYPE,
108 p_spec GMD_SPECIFICATIONS%ROWTYPE)
109 RETURN BOOLEAN;
110
111
112
113 PROCEDURE validate_supp_vr
114 (
115 p_supp_vr IN GMD_SUPPLIER_SPEC_VRS%ROWTYPE
116 , p_called_from IN VARCHAR2 DEFAULT 'API'
117 , p_operation IN VARCHAR2
118 , x_return_status OUT NOCOPY VARCHAR2
119 );
120
121 PROCEDURE check_for_null_and_fks_in_svr
122 (
123 p_supp_vr IN gmd_supplier_spec_vrs%ROWTYPE
124 , p_spec IN gmd_specifications%ROWTYPE
125 , x_return_status OUT NOCOPY VARCHAR2
126 );
127
128 FUNCTION supp_vr_exist(p_supp_vr GMD_SUPPLIER_SPEC_VRS%ROWTYPE,
129 p_spec GMD_SPECIFICATIONS%ROWTYPE)
130 RETURN BOOLEAN;
131
132 PROCEDURE VALIDATE_BEFORE_DELETE_INV_VRS(
133 p_spec_id IN NUMBER,
134 p_spec_vr_id IN NUMBER,
135 x_return_status OUT NOCOPY VARCHAR2,
136 x_message_data OUT NOCOPY VARCHAR2);
137
138 PROCEDURE VALIDATE_BEFORE_DELETE_WIP_VRS(
139 p_spec_id IN NUMBER,
140 p_spec_vr_id IN NUMBER,
141 x_return_status OUT NOCOPY VARCHAR2,
142 x_message_data OUT NOCOPY VARCHAR2);
143
144 PROCEDURE VALIDATE_BEFORE_DELETE_CST_VRS(
145 p_spec_id IN NUMBER,
146 p_spec_vr_id IN NUMBER,
147 x_return_status OUT NOCOPY VARCHAR2,
148 x_message_data OUT NOCOPY VARCHAR2);
149
150 PROCEDURE VALIDATE_BEFORE_DELETE_SUP_VRS(
151 p_spec_id IN NUMBER,
152 p_spec_vr_id IN NUMBER,
153 x_return_status OUT NOCOPY VARCHAR2,
154 x_message_data OUT NOCOPY VARCHAR2);
155
156 PROCEDURE check_who( p_user_id IN NUMBER);
157
158
159 PROCEDURE check_COA( p_coa_type IN VARCHAR2
160 , p_coa_at_ship_ind IN VARCHAR2
161 , p_coa_at_invoice_ind IN VARCHAR2
162 , p_coa_req_from_supl_ind IN VARCHAR2);
163
164 PROCEDURE check_VR_Controls
165 ( p_VR_type IN VARCHAR2
166 , p_lot_optional_on_sample IN VARCHAR2
167 , p_delayed_lot_entry IN VARCHAR2 DEFAULT NULL
168 , p_sample_inv_trans_ind IN VARCHAR2
169 , p_lot_ctl IN NUMBER
170 , p_status_ctl IN VARCHAR2
171 , p_control_lot_attrib_ind IN VARCHAR2
172 , p_in_spec_lot_status_id IN NUMBER
173 , p_out_of_spec_lot_status_id IN NUMBER
174 , p_control_batch_step_ind IN VARCHAR2
175 , p_auto_complete_batch_step IN VARCHAR2 DEFAULT NULL); -- Bug# 5440347
176
177 END GMD_SPEC_VRS_GRP;
178