[Home] [Help]
PACKAGE: APPS.GMD_SPEC_VRS_GRP
Source
1 PACKAGE GMD_SPEC_VRS_GRP AUTHID CURRENT_USER AS
2 /* $Header: GMDGSVRS.pls 120.2.12010000.2 2009/03/18 21:59:21 plowe 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 --|RLNAGARA LPN ME 7027149 08-May-2008 Added new function check_wms_enabled |
23 --| and signature of check_VR_controls procedure|
24 --+==========================================================================+
25 -- End of comments
26
27 PROCEDURE validate_mon_vr
28 (
29 p_mon_vr IN GMD_MONITORING_SPEC_VRS%ROWTYPE
30 , p_called_from IN VARCHAR2 DEFAULT 'API'
31 , p_operation IN VARCHAR2
32 , x_mon_vr OUT NOCOPY GMD_MONITORING_SPEC_VRS%ROWTYPE
33 , x_return_status OUT NOCOPY VARCHAR2
34 );
35
36 PROCEDURE check_for_null_and_fks_in_mvr
37 (
38 p_mon_vr IN GMD_MONITORING_SPEC_VRS%ROWTYPE
39 , p_spec IN GMD_SPECIFICATIONS%ROWTYPE
40 , x_mon_vr OUT NOCOPY GMD_MONITORING_SPEC_VRS%ROWTYPE
41 , x_return_status OUT NOCOPY VARCHAR2
42 );
43
44 FUNCTION mon_vr_exist(p_mon_vr GMD_MONITORING_SPEC_VRS%ROWTYPE,
45 p_spec GMD_SPECIFICATIONS%ROWTYPE)
46 RETURN BOOLEAN;
47
48 PROCEDURE validate_inv_vr
49 (
50 p_inv_vr IN GMD_INVENTORY_SPEC_VRS%ROWTYPE
51 , p_called_from IN VARCHAR2 DEFAULT 'API'
52 , p_operation IN VARCHAR2
53 , x_inv_vr OUT NOCOPY GMD_INVENTORY_SPEC_VRS%ROWTYPE
54 , x_return_status OUT NOCOPY VARCHAR2
55 );
56
57 PROCEDURE check_for_null_and_fks_in_ivr
58 (
59 p_inv_vr IN GMD_INVENTORY_SPEC_VRS%ROWTYPE
60 , p_spec IN GMD_SPECIFICATIONS%ROWTYPE
61 , x_inv_vr OUT NOCOPY GMD_INVENTORY_SPEC_VRS%ROWTYPE
62 , x_return_status OUT NOCOPY VARCHAR2
63 );
64
65 FUNCTION inv_vr_exist(p_inv_vr GMD_INVENTORY_SPEC_VRS%ROWTYPE,
66 p_spec GMD_SPECIFICATIONS%ROWTYPE)
67 RETURN BOOLEAN;
68
69
70
71 PROCEDURE validate_wip_vr
72 (
73 p_wip_vr IN GMD_WIP_SPEC_VRS%ROWTYPE
74 , p_called_from IN VARCHAR2 DEFAULT 'API'
75 , p_operation IN VARCHAR2
76 , x_wip_vr OUT NOCOPY GMD_WIP_SPEC_VRS%ROWTYPE
77 , x_return_status OUT NOCOPY VARCHAR2
78 );
79
80 PROCEDURE check_for_null_and_fks_in_wvr
81 (
82 p_wip_vr IN GMD_WIP_SPEC_VRS%ROWTYPE
83 , p_spec IN GMD_SPECIFICATIONS%ROWTYPE
84 , x_wip_vr OUT NOCOPY GMD_WIP_SPEC_VRS%ROWTYPE
85 , x_return_status OUT NOCOPY VARCHAR2
86 );
87
88 FUNCTION wip_vr_exist(p_wip_vr GMD_WIP_SPEC_VRS%ROWTYPE,
89 p_spec GMD_SPECIFICATIONS%ROWTYPE)
90 RETURN BOOLEAN;
91
92
93
94 PROCEDURE validate_cust_vr
95 (
96 p_cust_vr IN GMD_CUSTOMER_SPEC_VRS%ROWTYPE
97 , p_called_from IN VARCHAR2 DEFAULT 'API'
98 , p_operation IN VARCHAR2
99 , x_return_status OUT NOCOPY VARCHAR2
100 );
101
102 PROCEDURE check_for_null_and_fks_in_cvr
103 (
104 p_cust_vr IN gmd_customer_spec_vrs%ROWTYPE
105 , p_spec IN gmd_specifications%ROWTYPE
106 , x_return_status OUT NOCOPY VARCHAR2
107 );
108
109 FUNCTION cust_vr_exist(p_cust_vr GMD_CUSTOMER_SPEC_VRS%ROWTYPE,
110 p_spec GMD_SPECIFICATIONS%ROWTYPE)
111 RETURN BOOLEAN;
112
113
114
115 PROCEDURE validate_supp_vr
116 (
117 p_supp_vr IN GMD_SUPPLIER_SPEC_VRS%ROWTYPE
118 , p_called_from IN VARCHAR2 DEFAULT 'API'
119 , p_operation IN VARCHAR2
120 , x_return_status OUT NOCOPY VARCHAR2
121 );
122
123 PROCEDURE check_for_null_and_fks_in_svr
124 (
125 p_supp_vr IN gmd_supplier_spec_vrs%ROWTYPE
126 , p_spec IN gmd_specifications%ROWTYPE
127 , x_return_status OUT NOCOPY VARCHAR2
128 );
129
130 FUNCTION supp_vr_exist(p_supp_vr GMD_SUPPLIER_SPEC_VRS%ROWTYPE,
131 p_spec GMD_SPECIFICATIONS%ROWTYPE)
132 RETURN BOOLEAN;
133
134 PROCEDURE VALIDATE_BEFORE_DELETE_INV_VRS(
135 p_spec_id IN NUMBER,
136 p_spec_vr_id IN NUMBER,
137 x_return_status OUT NOCOPY VARCHAR2,
138 x_message_data OUT NOCOPY VARCHAR2);
139
140 PROCEDURE VALIDATE_BEFORE_DELETE_WIP_VRS(
141 p_spec_id IN NUMBER,
142 p_spec_vr_id IN NUMBER,
143 x_return_status OUT NOCOPY VARCHAR2,
144 x_message_data OUT NOCOPY VARCHAR2);
145
146 PROCEDURE VALIDATE_BEFORE_DELETE_CST_VRS(
147 p_spec_id IN NUMBER,
148 p_spec_vr_id IN NUMBER,
149 x_return_status OUT NOCOPY VARCHAR2,
150 x_message_data OUT NOCOPY VARCHAR2);
151
152 PROCEDURE VALIDATE_BEFORE_DELETE_SUP_VRS(
153 p_spec_id IN NUMBER,
154 p_spec_vr_id IN NUMBER,
155 x_return_status OUT NOCOPY VARCHAR2,
156 x_message_data OUT NOCOPY VARCHAR2);
157
158 PROCEDURE check_who( p_user_id IN NUMBER);
159
160
161 PROCEDURE check_COA( p_coa_type IN VARCHAR2
162 , p_coa_at_ship_ind IN VARCHAR2
163 , p_coa_at_invoice_ind IN VARCHAR2
164 , p_coa_req_from_supl_ind IN VARCHAR2);
165
166 PROCEDURE check_VR_Controls
167 ( p_VR_type IN VARCHAR2
168 , p_lot_optional_on_sample IN VARCHAR2
169 , p_delayed_lot_entry IN VARCHAR2 DEFAULT NULL
170 , p_sample_inv_trans_ind IN VARCHAR2
171 , p_lot_ctl IN NUMBER
172 , p_status_ctl IN VARCHAR2
173 , p_control_lot_attrib_ind IN VARCHAR2
174 , p_in_spec_lot_status_id IN NUMBER
175 , p_out_of_spec_lot_status_id IN NUMBER
176 , p_control_batch_step_ind IN VARCHAR2
177 , p_auto_complete_batch_step IN VARCHAR2 DEFAULT NULL -- Bug# 5440347
178 , p_delayed_lpn_entry IN VARCHAR2 DEFAULT NULL); --RLNAGARA LPN ME 7027149
179
180 --RLNAGARA LPN ME 7027149
181 FUNCTION check_wms_enabled(p_organization_id IN NUMBER)
182 RETURN BOOLEAN;
183
184 END GMD_SPEC_VRS_GRP;
185