1 package WSM_WLT_VALIDATE_PVT as
2 /* $Header: WSMVVLDS.pls 120.4 2006/03/28 21:56:33 sthangad noship $ */
3
4 -- ***data types for LBJ code-remove later when LBJ API coded
5 type weid_tbl_type is table of number index by binary_integer;
6 type job_name_tbl_type is table of varchar2(240) index by binary_integer;
7
8 g_job_name_tbl job_name_tbl_type;
9 g_wip_entity_id_tbl weid_tbl_type;
10 -- ***end data types for LBJ code-remove later when LBJ API is coded
11
12 -- Inserts the data into the base tables...
13 Procedure insert_txn_data ( p_transaction_id IN NUMBER,
14 p_wltx_header IN WSM_WIP_LOT_TXN_PVT.WLTX_TRANSACTIONS_REC_TYPE,
15 p_wltx_starting_jobs_tbl IN WSM_WIP_LOT_TXN_PVT.WLTX_STARTING_JOBS_TBL_TYPE,
16 p_wltx_resulting_jobs_tbl IN WSM_WIP_LOT_TXN_PVT.WLTX_RESULTING_JOBS_TBL_TYPE,
17 x_return_status OUT NOCOPY VARCHAR2,
18 x_msg_count OUT NOCOPY NUMBER,
19 x_msg_data OUT NOCOPY VARCHAR2
20 );
21
22
23 -- Validate the txn details passed
24 Procedure validate_txn_header ( p_wltx_header IN OUT NOCOPY WSM_WIP_LOT_TXN_PVT.WLTX_TRANSACTIONS_REC_TYPE,
25 x_return_status OUT NOCOPY VARCHAR2,
26 x_msg_count OUT NOCOPY NUMBER,
27 x_msg_data OUT NOCOPY VARCHAR2
28 );
29
30 -- ST : Fix for bug 4351071 --
31 -- Added this procedure to validate the date information..
32 -- i) Txn date >= released_date
33 -- ii) Txn date > last wip lot txn performed on this job...
34 Procedure validate_sj_txn_date ( p_txn_date IN DATE ,
35 p_sj_wip_entity_id IN NUMBER ,
36 p_sj_wip_entity_name IN VARCHAR2,
37 p_sj_date_released IN DATE ,
38 x_return_status OUT NOCOPY VARCHAR2,
39 x_msg_count OUT NOCOPY NUMBER ,
40 x_msg_data OUT NOCOPY VARCHAR2
41 );
42
43 -- derive Validate the starting job info
44 Procedure derive_val_st_job_details( p_txn_org_id IN NUMBER,
45 p_txn_type IN NUMBER,
46 -- ST : Added Txn date for bug 4351071
47 p_txn_date IN DATE,
48 p_starting_job_rec IN OUT NOCOPY WSM_WIP_LOT_TXN_PVT.WLTX_STARTING_JOBS_REC_TYPE,
49 x_return_status OUT NOCOPY VARCHAR2,
50 x_msg_count OUT NOCOPY NUMBER,
51 x_msg_data OUT NOCOPY VARCHAR2
52 );
53 -- derive Validate the starting job info ( overloaded for merge ) --
54 Procedure derive_val_st_job_details( p_txn_org_id IN NUMBER,
55 p_txn_type IN NUMBER,
56 -- ST : Added Txn date for bug 4351071
57 p_txn_date IN DATE,
58 p_starting_jobs_tbl IN OUT NOCOPY WSM_WIP_LOT_TXN_PVT.WLTX_STARTING_JOBS_TBL_TYPE,
59 p_rep_job_index OUT NOCOPY NUMBER,
60 p_total_avail_quantity OUT NOCOPY NUMBER,
61 p_total_net_quantity OUT NOCOPY NUMBER,
62 x_job_serial_code OUT NOCOPY NUMBER,
63 x_return_status OUT NOCOPY VARCHAR2,
64 x_msg_count OUT NOCOPY NUMBER,
65 x_msg_data OUT NOCOPY VARCHAR2
66 );
67
68 -- Default resulting job details for merge txn --
69 Procedure derive_val_res_job_details( p_txn_type IN NUMBER,
70 p_txn_org_id IN NUMBER,
71 p_starting_job_rec IN WSM_WIP_LOT_TXN_PVT.WLTX_STARTING_JOBS_REC_TYPE,
72 p_job_quantity IN NUMBER,
73 p_job_net_quantity IN NUMBER,
74 -- ST : Serial Support : Added the below parameter..
75 p_job_serial_code IN NUMBER,
76 p_resulting_job_rec IN OUT NOCOPY WSM_WIP_LOT_TXN_PVT.WLTX_RESULTING_JOBS_REC_TYPE,
77 x_return_status OUT NOCOPY VARCHAR2,
78 x_msg_count OUT NOCOPY NUMBER,
79 x_msg_data OUT NOCOPY VARCHAR2
80 );
81
82 -- Default resulting job details for bonus txn --
83 Procedure derive_val_res_job_details( p_txn_type IN NUMBER,
84 p_txn_org_id IN NUMBER,
85 p_transaction_date IN DATE,
86 p_resulting_job_rec IN OUT NOCOPY WSM_WIP_LOT_TXN_PVT.WLTX_RESULTING_JOBS_REC_TYPE,
87 x_return_status OUT NOCOPY VARCHAR2,
88 x_msg_count OUT NOCOPY NUMBER,
89 x_msg_data OUT NOCOPY VARCHAR2
90 );
91
92 -- for non-split non-merge transactions.... --
93 Procedure derive_val_res_job_details( p_txn_type IN NUMBER,
94 p_txn_org_id IN NUMBER,
95 p_transaction_date IN DATE,
96 p_starting_job_rec IN WSM_WIP_LOT_TXN_PVT.WLTX_STARTING_JOBS_REC_TYPE,
97 p_resulting_job_rec IN OUT NOCOPY WSM_WIP_LOT_TXN_PVT.WLTX_RESULTING_JOBS_REC_TYPE,
98 x_return_status OUT NOCOPY VARCHAR2,
99 x_msg_count OUT NOCOPY NUMBER,
100 x_msg_data OUT NOCOPY VARCHAR2
101 );
102
103
104 -- Default resulting job details from the starting job for appropriate fields depending on txn ( overloaded for split) --
105 Procedure derive_val_res_job_details( p_txn_type IN NUMBER,
106 p_txn_org_id IN NUMBER,
107 p_starting_job_rec IN WSM_WIP_LOT_TXN_PVT.WLTX_STARTING_JOBS_REC_TYPE,
108 p_resulting_jobs_tbl IN OUT NOCOPY WSM_WIP_LOT_TXN_PVT.WLTX_RESULTING_JOBS_TBL_TYPE,
109 x_return_status OUT NOCOPY VARCHAR2,
110 x_msg_count OUT NOCOPY NUMBER,
111 x_msg_data OUT NOCOPY VARCHAR2
112 );
113
114 -- routing procedure..... --
115 Procedure derive_val_routing_info (p_txn_org_id IN NUMBER,
116 p_sj_job_type IN NUMBER,
117 p_rj_primary_item_id IN NUMBER,
118 p_rj_rtg_reference_item IN VARCHAR2,
119 p_rj_rtg_reference_id IN OUT NOCOPY NUMBER,
120 p_rj_alternate_rtg_desig IN OUT NOCOPY VARCHAR2,
121 p_rj_common_rtg_seq_id IN OUT NOCOPY NUMBER,
122 p_rj_rtg_revision IN OUT NOCOPY VARCHAR2,
123 p_rj_rtg_revision_date IN OUT NOCOPY DATE,
124 x_return_status OUT NOCOPY VARCHAR2,
125 x_msg_count OUT NOCOPY NUMBER,
126 x_msg_data OUT NOCOPY VARCHAR2
127 );
128
129 -- BOM procedure...... --
130 Procedure derive_val_bom_info ( p_txn_org_id IN NUMBER,
131 p_sj_job_type IN NUMBER,
132 p_rj_primary_item_id IN NUMBER,
133 p_rj_bom_reference_item IN OUT NOCOPY VARCHAR2,
134 p_rj_bom_reference_id IN OUT NOCOPY NUMBER,
135 p_rj_alternate_bom_desig IN OUT NOCOPY VARCHAR2,
136 p_rj_common_bom_seq_id IN OUT NOCOPY NUMBER,
137 p_rj_bom_revision IN OUT NOCOPY VARCHAR2,
138 p_rj_bom_revision_date IN OUT NOCOPY DATE,
139 x_return_status OUT NOCOPY VARCHAR2,
140 x_msg_count OUT NOCOPY NUMBER,
141 x_msg_data OUT NOCOPY VARCHAR2
142 );
143
144 -- Validate the completion subinventory details.... --
145 Procedure derive_val_compl_subinv(
146 p_job_type IN NUMBER,
147 p_old_rtg_seq_id IN NUMBER,
148 p_new_rtg_seq_id IN NUMBER,
149 p_organization_id IN NUMBER,
150 p_primary_item_id IN NUMBER,
151 p_sj_completion_subinventory IN VARCHAR2,
152 p_sj_completion_locator_id IN NUMBER,
153 p_rj_alt_rtg_designator IN VARCHAR2, -- Added for the bug 5094555
154 p_rj_rtg_reference_item_id IN NUMBER, -- Added for the bug 5094555
155 p_rj_completion_subinventory IN OUT NOCOPY VARCHAR2,
156 p_rj_completion_locator_id IN OUT NOCOPY NUMBER,
157 p_rj_completion_locator IN OUT NOCOPY VARCHAR2,
158 x_return_status OUT NOCOPY VARCHAR2,
159 x_msg_count OUT NOCOPY NUMBER,
160 x_msg_data OUT NOCOPY VARCHAR2
161 );
162
163 Procedure derive_val_starting_op ( p_txn_org_id IN NUMBER,
164 p_curr_op_seq_id IN NUMBER,
165 p_curr_op_code IN VARCHAR2,
166 p_curr_std_op_id IN NUMBER,
167 p_curr_intra_op_step IN NUMBER,
168 p_new_comm_rtg_seq_id IN NUMBER,
169 p_new_rtg_rev_date IN DATE,
170 p_new_op_seq_num IN OUT NOCOPY NUMBER,
171 p_new_op_seq_id IN OUT NOCOPY NUMBER,
172 p_new_std_op_id IN OUT NOCOPY NUMBER,
173 p_new_op_seq_code IN OUT NOCOPY VARCHAR2,
174 p_new_dept_id IN OUT NOCOPY NUMBER,
175 x_return_status OUT NOCOPY VARCHAR2,
176 x_msg_count OUT NOCOPY NUMBER,
177 x_msg_data OUT NOCOPY VARCHAR2
178 );
179
180
181
182 Procedure derive_val_primary_item ( p_txn_org_id IN NUMBER,
183 p_old_item_id IN NUMBER,
184 p_new_item_name IN VARCHAR2,
185 p_new_item_id IN OUT NOCOPY NUMBER,
186 x_return_status OUT NOCOPY VARCHAR2,
187 x_msg_count OUT NOCOPY NUMBER,
188 x_msg_data OUT NOCOPY VARCHAR2
189 );
190
191 Procedure validate_network( p_txn_org_id IN NUMBER ,
192 p_rtg_seq_id IN NUMBER ,
193 p_revision_date IN DATE ,
194 p_start_op_seq_num IN OUT NOCOPY NUMBER ,
195 p_start_op_seq_id IN OUT NOCOPY NUMBER ,
196 p_start_op_seq_code IN OUT NOCOPY VARCHAR2,
197 p_dept_id IN OUT NOCOPY NUMBER ,
198 x_return_status OUT NOCOPY varchar2 ,
199 x_msg_count OUT NOCOPY NUMBER ,
200 x_msg_data OUT NOCOPY VARCHAR2
201 );
202
203 end WSM_WLT_VALIDATE_PVT;
|
|
|