132: PROCEDURE populate_dependency_matrix IS
133:
134: BEGIN
135:
136: g_dependency_matrix(1).element_id := qa_ss_const.item;
137: g_dependency_matrix(1).parent := qa_ss_const.production_line;
138:
139: g_dependency_matrix(2).element_id := qa_ss_const.to_op_seq_num;
140: g_dependency_matrix(2).parent := qa_ss_const.job_name;
133:
134: BEGIN
135:
136: g_dependency_matrix(1).element_id := qa_ss_const.item;
137: g_dependency_matrix(1).parent := qa_ss_const.production_line;
138:
139: g_dependency_matrix(2).element_id := qa_ss_const.to_op_seq_num;
140: g_dependency_matrix(2).parent := qa_ss_const.job_name;
141:
135:
136: g_dependency_matrix(1).element_id := qa_ss_const.item;
137: g_dependency_matrix(1).parent := qa_ss_const.production_line;
138:
139: g_dependency_matrix(2).element_id := qa_ss_const.to_op_seq_num;
140: g_dependency_matrix(2).parent := qa_ss_const.job_name;
141:
142: g_dependency_matrix(3).element_id := qa_ss_const.to_op_seq_num;
143: g_dependency_matrix(3).parent := qa_ss_const.production_line;
136: g_dependency_matrix(1).element_id := qa_ss_const.item;
137: g_dependency_matrix(1).parent := qa_ss_const.production_line;
138:
139: g_dependency_matrix(2).element_id := qa_ss_const.to_op_seq_num;
140: g_dependency_matrix(2).parent := qa_ss_const.job_name;
141:
142: g_dependency_matrix(3).element_id := qa_ss_const.to_op_seq_num;
143: g_dependency_matrix(3).parent := qa_ss_const.production_line;
144:
138:
139: g_dependency_matrix(2).element_id := qa_ss_const.to_op_seq_num;
140: g_dependency_matrix(2).parent := qa_ss_const.job_name;
141:
142: g_dependency_matrix(3).element_id := qa_ss_const.to_op_seq_num;
143: g_dependency_matrix(3).parent := qa_ss_const.production_line;
144:
145: g_dependency_matrix(4).element_id := qa_ss_const.from_op_seq_num;
146: g_dependency_matrix(4).parent := qa_ss_const.job_name;
139: g_dependency_matrix(2).element_id := qa_ss_const.to_op_seq_num;
140: g_dependency_matrix(2).parent := qa_ss_const.job_name;
141:
142: g_dependency_matrix(3).element_id := qa_ss_const.to_op_seq_num;
143: g_dependency_matrix(3).parent := qa_ss_const.production_line;
144:
145: g_dependency_matrix(4).element_id := qa_ss_const.from_op_seq_num;
146: g_dependency_matrix(4).parent := qa_ss_const.job_name;
147:
141:
142: g_dependency_matrix(3).element_id := qa_ss_const.to_op_seq_num;
143: g_dependency_matrix(3).parent := qa_ss_const.production_line;
144:
145: g_dependency_matrix(4).element_id := qa_ss_const.from_op_seq_num;
146: g_dependency_matrix(4).parent := qa_ss_const.job_name;
147:
148: g_dependency_matrix(5).element_id := qa_ss_const.from_op_seq_num;
149: g_dependency_matrix(5).parent := qa_ss_const.production_line;
142: g_dependency_matrix(3).element_id := qa_ss_const.to_op_seq_num;
143: g_dependency_matrix(3).parent := qa_ss_const.production_line;
144:
145: g_dependency_matrix(4).element_id := qa_ss_const.from_op_seq_num;
146: g_dependency_matrix(4).parent := qa_ss_const.job_name;
147:
148: g_dependency_matrix(5).element_id := qa_ss_const.from_op_seq_num;
149: g_dependency_matrix(5).parent := qa_ss_const.production_line;
150:
144:
145: g_dependency_matrix(4).element_id := qa_ss_const.from_op_seq_num;
146: g_dependency_matrix(4).parent := qa_ss_const.job_name;
147:
148: g_dependency_matrix(5).element_id := qa_ss_const.from_op_seq_num;
149: g_dependency_matrix(5).parent := qa_ss_const.production_line;
150:
151: g_dependency_matrix(6).element_id := qa_ss_const.to_intraoperation_step;
152: g_dependency_matrix(6).parent := qa_ss_const.to_op_seq_num;
145: g_dependency_matrix(4).element_id := qa_ss_const.from_op_seq_num;
146: g_dependency_matrix(4).parent := qa_ss_const.job_name;
147:
148: g_dependency_matrix(5).element_id := qa_ss_const.from_op_seq_num;
149: g_dependency_matrix(5).parent := qa_ss_const.production_line;
150:
151: g_dependency_matrix(6).element_id := qa_ss_const.to_intraoperation_step;
152: g_dependency_matrix(6).parent := qa_ss_const.to_op_seq_num;
153:
147:
148: g_dependency_matrix(5).element_id := qa_ss_const.from_op_seq_num;
149: g_dependency_matrix(5).parent := qa_ss_const.production_line;
150:
151: g_dependency_matrix(6).element_id := qa_ss_const.to_intraoperation_step;
152: g_dependency_matrix(6).parent := qa_ss_const.to_op_seq_num;
153:
154: g_dependency_matrix(7).element_id := qa_ss_const.from_intraoperation_step;
155: g_dependency_matrix(7).parent := qa_ss_const.from_op_seq_num;
148: g_dependency_matrix(5).element_id := qa_ss_const.from_op_seq_num;
149: g_dependency_matrix(5).parent := qa_ss_const.production_line;
150:
151: g_dependency_matrix(6).element_id := qa_ss_const.to_intraoperation_step;
152: g_dependency_matrix(6).parent := qa_ss_const.to_op_seq_num;
153:
154: g_dependency_matrix(7).element_id := qa_ss_const.from_intraoperation_step;
155: g_dependency_matrix(7).parent := qa_ss_const.from_op_seq_num;
156:
150:
151: g_dependency_matrix(6).element_id := qa_ss_const.to_intraoperation_step;
152: g_dependency_matrix(6).parent := qa_ss_const.to_op_seq_num;
153:
154: g_dependency_matrix(7).element_id := qa_ss_const.from_intraoperation_step;
155: g_dependency_matrix(7).parent := qa_ss_const.from_op_seq_num;
156:
157: g_dependency_matrix(8).element_id := qa_ss_const.uom;
158: g_dependency_matrix(8).parent := qa_ss_const.item;
151: g_dependency_matrix(6).element_id := qa_ss_const.to_intraoperation_step;
152: g_dependency_matrix(6).parent := qa_ss_const.to_op_seq_num;
153:
154: g_dependency_matrix(7).element_id := qa_ss_const.from_intraoperation_step;
155: g_dependency_matrix(7).parent := qa_ss_const.from_op_seq_num;
156:
157: g_dependency_matrix(8).element_id := qa_ss_const.uom;
158: g_dependency_matrix(8).parent := qa_ss_const.item;
159:
153:
154: g_dependency_matrix(7).element_id := qa_ss_const.from_intraoperation_step;
155: g_dependency_matrix(7).parent := qa_ss_const.from_op_seq_num;
156:
157: g_dependency_matrix(8).element_id := qa_ss_const.uom;
158: g_dependency_matrix(8).parent := qa_ss_const.item;
159:
160: g_dependency_matrix(9).element_id := qa_ss_const.revision;
161: g_dependency_matrix(9).parent := qa_ss_const.item;
154: g_dependency_matrix(7).element_id := qa_ss_const.from_intraoperation_step;
155: g_dependency_matrix(7).parent := qa_ss_const.from_op_seq_num;
156:
157: g_dependency_matrix(8).element_id := qa_ss_const.uom;
158: g_dependency_matrix(8).parent := qa_ss_const.item;
159:
160: g_dependency_matrix(9).element_id := qa_ss_const.revision;
161: g_dependency_matrix(9).parent := qa_ss_const.item;
162:
156:
157: g_dependency_matrix(8).element_id := qa_ss_const.uom;
158: g_dependency_matrix(8).parent := qa_ss_const.item;
159:
160: g_dependency_matrix(9).element_id := qa_ss_const.revision;
161: g_dependency_matrix(9).parent := qa_ss_const.item;
162:
163: g_dependency_matrix(10).element_id := qa_ss_const.subinventory;
164: g_dependency_matrix(10).parent := qa_ss_const.item;
157: g_dependency_matrix(8).element_id := qa_ss_const.uom;
158: g_dependency_matrix(8).parent := qa_ss_const.item;
159:
160: g_dependency_matrix(9).element_id := qa_ss_const.revision;
161: g_dependency_matrix(9).parent := qa_ss_const.item;
162:
163: g_dependency_matrix(10).element_id := qa_ss_const.subinventory;
164: g_dependency_matrix(10).parent := qa_ss_const.item;
165:
159:
160: g_dependency_matrix(9).element_id := qa_ss_const.revision;
161: g_dependency_matrix(9).parent := qa_ss_const.item;
162:
163: g_dependency_matrix(10).element_id := qa_ss_const.subinventory;
164: g_dependency_matrix(10).parent := qa_ss_const.item;
165:
166: g_dependency_matrix(11).element_id := qa_ss_const.locator;
167: g_dependency_matrix(11).parent := qa_ss_const.subinventory;
160: g_dependency_matrix(9).element_id := qa_ss_const.revision;
161: g_dependency_matrix(9).parent := qa_ss_const.item;
162:
163: g_dependency_matrix(10).element_id := qa_ss_const.subinventory;
164: g_dependency_matrix(10).parent := qa_ss_const.item;
165:
166: g_dependency_matrix(11).element_id := qa_ss_const.locator;
167: g_dependency_matrix(11).parent := qa_ss_const.subinventory;
168:
162:
163: g_dependency_matrix(10).element_id := qa_ss_const.subinventory;
164: g_dependency_matrix(10).parent := qa_ss_const.item;
165:
166: g_dependency_matrix(11).element_id := qa_ss_const.locator;
167: g_dependency_matrix(11).parent := qa_ss_const.subinventory;
168:
169: g_dependency_matrix(12).element_id := qa_ss_const.lot_number;
170: g_dependency_matrix(12).parent := qa_ss_const.item;
163: g_dependency_matrix(10).element_id := qa_ss_const.subinventory;
164: g_dependency_matrix(10).parent := qa_ss_const.item;
165:
166: g_dependency_matrix(11).element_id := qa_ss_const.locator;
167: g_dependency_matrix(11).parent := qa_ss_const.subinventory;
168:
169: g_dependency_matrix(12).element_id := qa_ss_const.lot_number;
170: g_dependency_matrix(12).parent := qa_ss_const.item;
171:
165:
166: g_dependency_matrix(11).element_id := qa_ss_const.locator;
167: g_dependency_matrix(11).parent := qa_ss_const.subinventory;
168:
169: g_dependency_matrix(12).element_id := qa_ss_const.lot_number;
170: g_dependency_matrix(12).parent := qa_ss_const.item;
171:
172: g_dependency_matrix(13).element_id := qa_ss_const.serial_number;
173: g_dependency_matrix(13).parent := qa_ss_const.item;
166: g_dependency_matrix(11).element_id := qa_ss_const.locator;
167: g_dependency_matrix(11).parent := qa_ss_const.subinventory;
168:
169: g_dependency_matrix(12).element_id := qa_ss_const.lot_number;
170: g_dependency_matrix(12).parent := qa_ss_const.item;
171:
172: g_dependency_matrix(13).element_id := qa_ss_const.serial_number;
173: g_dependency_matrix(13).parent := qa_ss_const.item;
174:
168:
169: g_dependency_matrix(12).element_id := qa_ss_const.lot_number;
170: g_dependency_matrix(12).parent := qa_ss_const.item;
171:
172: g_dependency_matrix(13).element_id := qa_ss_const.serial_number;
173: g_dependency_matrix(13).parent := qa_ss_const.item;
174:
175: g_dependency_matrix(14).element_id := qa_ss_const.comp_uom;
176: g_dependency_matrix(14).parent := qa_ss_const.comp_item;
169: g_dependency_matrix(12).element_id := qa_ss_const.lot_number;
170: g_dependency_matrix(12).parent := qa_ss_const.item;
171:
172: g_dependency_matrix(13).element_id := qa_ss_const.serial_number;
173: g_dependency_matrix(13).parent := qa_ss_const.item;
174:
175: g_dependency_matrix(14).element_id := qa_ss_const.comp_uom;
176: g_dependency_matrix(14).parent := qa_ss_const.comp_item;
177:
171:
172: g_dependency_matrix(13).element_id := qa_ss_const.serial_number;
173: g_dependency_matrix(13).parent := qa_ss_const.item;
174:
175: g_dependency_matrix(14).element_id := qa_ss_const.comp_uom;
176: g_dependency_matrix(14).parent := qa_ss_const.comp_item;
177:
178: g_dependency_matrix(15).element_id := qa_ss_const.comp_revision;
179: g_dependency_matrix(15).parent := qa_ss_const.comp_item;
172: g_dependency_matrix(13).element_id := qa_ss_const.serial_number;
173: g_dependency_matrix(13).parent := qa_ss_const.item;
174:
175: g_dependency_matrix(14).element_id := qa_ss_const.comp_uom;
176: g_dependency_matrix(14).parent := qa_ss_const.comp_item;
177:
178: g_dependency_matrix(15).element_id := qa_ss_const.comp_revision;
179: g_dependency_matrix(15).parent := qa_ss_const.comp_item;
180:
174:
175: g_dependency_matrix(14).element_id := qa_ss_const.comp_uom;
176: g_dependency_matrix(14).parent := qa_ss_const.comp_item;
177:
178: g_dependency_matrix(15).element_id := qa_ss_const.comp_revision;
179: g_dependency_matrix(15).parent := qa_ss_const.comp_item;
180:
181: g_dependency_matrix(16).element_id := qa_ss_const.po_line_num;
182: g_dependency_matrix(16).parent := qa_ss_const.po_number;
175: g_dependency_matrix(14).element_id := qa_ss_const.comp_uom;
176: g_dependency_matrix(14).parent := qa_ss_const.comp_item;
177:
178: g_dependency_matrix(15).element_id := qa_ss_const.comp_revision;
179: g_dependency_matrix(15).parent := qa_ss_const.comp_item;
180:
181: g_dependency_matrix(16).element_id := qa_ss_const.po_line_num;
182: g_dependency_matrix(16).parent := qa_ss_const.po_number;
183:
177:
178: g_dependency_matrix(15).element_id := qa_ss_const.comp_revision;
179: g_dependency_matrix(15).parent := qa_ss_const.comp_item;
180:
181: g_dependency_matrix(16).element_id := qa_ss_const.po_line_num;
182: g_dependency_matrix(16).parent := qa_ss_const.po_number;
183:
184: g_dependency_matrix(17).element_id := qa_ss_const.po_shipment_num;
185: g_dependency_matrix(17).parent := qa_ss_const.po_line_num;
178: g_dependency_matrix(15).element_id := qa_ss_const.comp_revision;
179: g_dependency_matrix(15).parent := qa_ss_const.comp_item;
180:
181: g_dependency_matrix(16).element_id := qa_ss_const.po_line_num;
182: g_dependency_matrix(16).parent := qa_ss_const.po_number;
183:
184: g_dependency_matrix(17).element_id := qa_ss_const.po_shipment_num;
185: g_dependency_matrix(17).parent := qa_ss_const.po_line_num;
186:
180:
181: g_dependency_matrix(16).element_id := qa_ss_const.po_line_num;
182: g_dependency_matrix(16).parent := qa_ss_const.po_number;
183:
184: g_dependency_matrix(17).element_id := qa_ss_const.po_shipment_num;
185: g_dependency_matrix(17).parent := qa_ss_const.po_line_num;
186:
187: g_dependency_matrix(18).element_id := qa_ss_const.po_release_num;
188: g_dependency_matrix(18).parent := qa_ss_const.po_number;
181: g_dependency_matrix(16).element_id := qa_ss_const.po_line_num;
182: g_dependency_matrix(16).parent := qa_ss_const.po_number;
183:
184: g_dependency_matrix(17).element_id := qa_ss_const.po_shipment_num;
185: g_dependency_matrix(17).parent := qa_ss_const.po_line_num;
186:
187: g_dependency_matrix(18).element_id := qa_ss_const.po_release_num;
188: g_dependency_matrix(18).parent := qa_ss_const.po_number;
189:
183:
184: g_dependency_matrix(17).element_id := qa_ss_const.po_shipment_num;
185: g_dependency_matrix(17).parent := qa_ss_const.po_line_num;
186:
187: g_dependency_matrix(18).element_id := qa_ss_const.po_release_num;
188: g_dependency_matrix(18).parent := qa_ss_const.po_number;
189:
190: g_dependency_matrix(19).element_id := qa_ss_const.order_line;
191: g_dependency_matrix(19).parent := qa_ss_const.sales_order;
184: g_dependency_matrix(17).element_id := qa_ss_const.po_shipment_num;
185: g_dependency_matrix(17).parent := qa_ss_const.po_line_num;
186:
187: g_dependency_matrix(18).element_id := qa_ss_const.po_release_num;
188: g_dependency_matrix(18).parent := qa_ss_const.po_number;
189:
190: g_dependency_matrix(19).element_id := qa_ss_const.order_line;
191: g_dependency_matrix(19).parent := qa_ss_const.sales_order;
192:
186:
187: g_dependency_matrix(18).element_id := qa_ss_const.po_release_num;
188: g_dependency_matrix(18).parent := qa_ss_const.po_number;
189:
190: g_dependency_matrix(19).element_id := qa_ss_const.order_line;
191: g_dependency_matrix(19).parent := qa_ss_const.sales_order;
192:
193: g_dependency_matrix(20).element_id := qa_ss_const.task_number;
194: g_dependency_matrix(20).parent := qa_ss_const.project_number;
187: g_dependency_matrix(18).element_id := qa_ss_const.po_release_num;
188: g_dependency_matrix(18).parent := qa_ss_const.po_number;
189:
190: g_dependency_matrix(19).element_id := qa_ss_const.order_line;
191: g_dependency_matrix(19).parent := qa_ss_const.sales_order;
192:
193: g_dependency_matrix(20).element_id := qa_ss_const.task_number;
194: g_dependency_matrix(20).parent := qa_ss_const.project_number;
195:
189:
190: g_dependency_matrix(19).element_id := qa_ss_const.order_line;
191: g_dependency_matrix(19).parent := qa_ss_const.sales_order;
192:
193: g_dependency_matrix(20).element_id := qa_ss_const.task_number;
194: g_dependency_matrix(20).parent := qa_ss_const.project_number;
195:
196: g_dependency_matrix(21).element_id := qa_ss_const.serial_number;
197: g_dependency_matrix(21).parent := qa_ss_const.lot_number;
190: g_dependency_matrix(19).element_id := qa_ss_const.order_line;
191: g_dependency_matrix(19).parent := qa_ss_const.sales_order;
192:
193: g_dependency_matrix(20).element_id := qa_ss_const.task_number;
194: g_dependency_matrix(20).parent := qa_ss_const.project_number;
195:
196: g_dependency_matrix(21).element_id := qa_ss_const.serial_number;
197: g_dependency_matrix(21).parent := qa_ss_const.lot_number;
198:
192:
193: g_dependency_matrix(20).element_id := qa_ss_const.task_number;
194: g_dependency_matrix(20).parent := qa_ss_const.project_number;
195:
196: g_dependency_matrix(21).element_id := qa_ss_const.serial_number;
197: g_dependency_matrix(21).parent := qa_ss_const.lot_number;
198:
199: g_dependency_matrix(22).element_id := qa_ss_const.contract_line_number;
200: g_dependency_matrix(22).parent := qa_ss_const.contract_number;
193: g_dependency_matrix(20).element_id := qa_ss_const.task_number;
194: g_dependency_matrix(20).parent := qa_ss_const.project_number;
195:
196: g_dependency_matrix(21).element_id := qa_ss_const.serial_number;
197: g_dependency_matrix(21).parent := qa_ss_const.lot_number;
198:
199: g_dependency_matrix(22).element_id := qa_ss_const.contract_line_number;
200: g_dependency_matrix(22).parent := qa_ss_const.contract_number;
201:
195:
196: g_dependency_matrix(21).element_id := qa_ss_const.serial_number;
197: g_dependency_matrix(21).parent := qa_ss_const.lot_number;
198:
199: g_dependency_matrix(22).element_id := qa_ss_const.contract_line_number;
200: g_dependency_matrix(22).parent := qa_ss_const.contract_number;
201:
202: g_dependency_matrix(23).element_id := qa_ss_const.deliverable_number;
203: g_dependency_matrix(23).parent := qa_ss_const.contract_line_number;
196: g_dependency_matrix(21).element_id := qa_ss_const.serial_number;
197: g_dependency_matrix(21).parent := qa_ss_const.lot_number;
198:
199: g_dependency_matrix(22).element_id := qa_ss_const.contract_line_number;
200: g_dependency_matrix(22).parent := qa_ss_const.contract_number;
201:
202: g_dependency_matrix(23).element_id := qa_ss_const.deliverable_number;
203: g_dependency_matrix(23).parent := qa_ss_const.contract_line_number;
204:
198:
199: g_dependency_matrix(22).element_id := qa_ss_const.contract_line_number;
200: g_dependency_matrix(22).parent := qa_ss_const.contract_number;
201:
202: g_dependency_matrix(23).element_id := qa_ss_const.deliverable_number;
203: g_dependency_matrix(23).parent := qa_ss_const.contract_line_number;
204:
205: g_dependency_matrix(24).element_id := qa_ss_const.asset_number;
206: g_dependency_matrix(24).parent := qa_ss_const.asset_group;
199: g_dependency_matrix(22).element_id := qa_ss_const.contract_line_number;
200: g_dependency_matrix(22).parent := qa_ss_const.contract_number;
201:
202: g_dependency_matrix(23).element_id := qa_ss_const.deliverable_number;
203: g_dependency_matrix(23).parent := qa_ss_const.contract_line_number;
204:
205: g_dependency_matrix(24).element_id := qa_ss_const.asset_number;
206: g_dependency_matrix(24).parent := qa_ss_const.asset_group;
207:
201:
202: g_dependency_matrix(23).element_id := qa_ss_const.deliverable_number;
203: g_dependency_matrix(23).parent := qa_ss_const.contract_line_number;
204:
205: g_dependency_matrix(24).element_id := qa_ss_const.asset_number;
206: g_dependency_matrix(24).parent := qa_ss_const.asset_group;
207:
208: --
209: -- See Bug 2588213
202: g_dependency_matrix(23).element_id := qa_ss_const.deliverable_number;
203: g_dependency_matrix(23).parent := qa_ss_const.contract_line_number;
204:
205: g_dependency_matrix(24).element_id := qa_ss_const.asset_number;
206: g_dependency_matrix(24).parent := qa_ss_const.asset_group;
207:
208: --
209: -- See Bug 2588213
210: -- To support the element Maintenance Op Seq Number
210: -- To support the element Maintenance Op Seq Number
211: -- to be used along with Maintenance Workorder
212: -- rkunchal Mon Sep 23 23:46:28 PDT 2002
213: --
214: g_dependency_matrix(25).element_id := qa_ss_const.maintenance_op_seq;
215: g_dependency_matrix(25).parent := qa_ss_const.work_order;
216:
217: -- Start of inclusions for NCM Hardcode Elements.
218: -- suramasw Thu Oct 31 10:48:59 PST 2002.
211: -- to be used along with Maintenance Workorder
212: -- rkunchal Mon Sep 23 23:46:28 PDT 2002
213: --
214: g_dependency_matrix(25).element_id := qa_ss_const.maintenance_op_seq;
215: g_dependency_matrix(25).parent := qa_ss_const.work_order;
216:
217: -- Start of inclusions for NCM Hardcode Elements.
218: -- suramasw Thu Oct 31 10:48:59 PST 2002.
219: -- Bug 2449067.
217: -- Start of inclusions for NCM Hardcode Elements.
218: -- suramasw Thu Oct 31 10:48:59 PST 2002.
219: -- Bug 2449067.
220:
221: g_dependency_matrix(26).element_id := qa_ss_const.to_subinventory;
222: g_dependency_matrix(26).parent := qa_ss_const.item;
223:
224: g_dependency_matrix(27).element_id := qa_ss_const.to_locator;
225: g_dependency_matrix(27).parent := qa_ss_const.to_subinventory;
218: -- suramasw Thu Oct 31 10:48:59 PST 2002.
219: -- Bug 2449067.
220:
221: g_dependency_matrix(26).element_id := qa_ss_const.to_subinventory;
222: g_dependency_matrix(26).parent := qa_ss_const.item;
223:
224: g_dependency_matrix(27).element_id := qa_ss_const.to_locator;
225: g_dependency_matrix(27).parent := qa_ss_const.to_subinventory;
226:
220:
221: g_dependency_matrix(26).element_id := qa_ss_const.to_subinventory;
222: g_dependency_matrix(26).parent := qa_ss_const.item;
223:
224: g_dependency_matrix(27).element_id := qa_ss_const.to_locator;
225: g_dependency_matrix(27).parent := qa_ss_const.to_subinventory;
226:
227: -- R12 OPM Deviations. Bug 4345503 Start
228: g_dependency_matrix(28).element_id := qa_ss_const.process_batchstep_num;
221: g_dependency_matrix(26).element_id := qa_ss_const.to_subinventory;
222: g_dependency_matrix(26).parent := qa_ss_const.item;
223:
224: g_dependency_matrix(27).element_id := qa_ss_const.to_locator;
225: g_dependency_matrix(27).parent := qa_ss_const.to_subinventory;
226:
227: -- R12 OPM Deviations. Bug 4345503 Start
228: g_dependency_matrix(28).element_id := qa_ss_const.process_batchstep_num;
229: g_dependency_matrix(28).parent := qa_ss_const.process_batch_num;
224: g_dependency_matrix(27).element_id := qa_ss_const.to_locator;
225: g_dependency_matrix(27).parent := qa_ss_const.to_subinventory;
226:
227: -- R12 OPM Deviations. Bug 4345503 Start
228: g_dependency_matrix(28).element_id := qa_ss_const.process_batchstep_num;
229: g_dependency_matrix(28).parent := qa_ss_const.process_batch_num;
230:
231: g_dependency_matrix(29).element_id := qa_ss_const.process_operation;
232: g_dependency_matrix(29).parent := qa_ss_const.process_batch_num;
225: g_dependency_matrix(27).parent := qa_ss_const.to_subinventory;
226:
227: -- R12 OPM Deviations. Bug 4345503 Start
228: g_dependency_matrix(28).element_id := qa_ss_const.process_batchstep_num;
229: g_dependency_matrix(28).parent := qa_ss_const.process_batch_num;
230:
231: g_dependency_matrix(29).element_id := qa_ss_const.process_operation;
232: g_dependency_matrix(29).parent := qa_ss_const.process_batch_num;
233:
227: -- R12 OPM Deviations. Bug 4345503 Start
228: g_dependency_matrix(28).element_id := qa_ss_const.process_batchstep_num;
229: g_dependency_matrix(28).parent := qa_ss_const.process_batch_num;
230:
231: g_dependency_matrix(29).element_id := qa_ss_const.process_operation;
232: g_dependency_matrix(29).parent := qa_ss_const.process_batch_num;
233:
234: g_dependency_matrix(30).element_id := qa_ss_const.process_activity;
235: g_dependency_matrix(30).parent := qa_ss_const.process_batch_num;
228: g_dependency_matrix(28).element_id := qa_ss_const.process_batchstep_num;
229: g_dependency_matrix(28).parent := qa_ss_const.process_batch_num;
230:
231: g_dependency_matrix(29).element_id := qa_ss_const.process_operation;
232: g_dependency_matrix(29).parent := qa_ss_const.process_batch_num;
233:
234: g_dependency_matrix(30).element_id := qa_ss_const.process_activity;
235: g_dependency_matrix(30).parent := qa_ss_const.process_batch_num;
236:
230:
231: g_dependency_matrix(29).element_id := qa_ss_const.process_operation;
232: g_dependency_matrix(29).parent := qa_ss_const.process_batch_num;
233:
234: g_dependency_matrix(30).element_id := qa_ss_const.process_activity;
235: g_dependency_matrix(30).parent := qa_ss_const.process_batch_num;
236:
237: g_dependency_matrix(31).element_id := qa_ss_const.process_resource;
238: g_dependency_matrix(31).parent := qa_ss_const.process_batch_num;
231: g_dependency_matrix(29).element_id := qa_ss_const.process_operation;
232: g_dependency_matrix(29).parent := qa_ss_const.process_batch_num;
233:
234: g_dependency_matrix(30).element_id := qa_ss_const.process_activity;
235: g_dependency_matrix(30).parent := qa_ss_const.process_batch_num;
236:
237: g_dependency_matrix(31).element_id := qa_ss_const.process_resource;
238: g_dependency_matrix(31).parent := qa_ss_const.process_batch_num;
239:
233:
234: g_dependency_matrix(30).element_id := qa_ss_const.process_activity;
235: g_dependency_matrix(30).parent := qa_ss_const.process_batch_num;
236:
237: g_dependency_matrix(31).element_id := qa_ss_const.process_resource;
238: g_dependency_matrix(31).parent := qa_ss_const.process_batch_num;
239:
240: g_dependency_matrix(32).element_id := qa_ss_const.process_parameter;
241: g_dependency_matrix(32).parent := qa_ss_const.process_batch_num;
234: g_dependency_matrix(30).element_id := qa_ss_const.process_activity;
235: g_dependency_matrix(30).parent := qa_ss_const.process_batch_num;
236:
237: g_dependency_matrix(31).element_id := qa_ss_const.process_resource;
238: g_dependency_matrix(31).parent := qa_ss_const.process_batch_num;
239:
240: g_dependency_matrix(32).element_id := qa_ss_const.process_parameter;
241: g_dependency_matrix(32).parent := qa_ss_const.process_batch_num;
242: -- R12 OPM Deviations. Bug 4345503 End
236:
237: g_dependency_matrix(31).element_id := qa_ss_const.process_resource;
238: g_dependency_matrix(31).parent := qa_ss_const.process_batch_num;
239:
240: g_dependency_matrix(32).element_id := qa_ss_const.process_parameter;
241: g_dependency_matrix(32).parent := qa_ss_const.process_batch_num;
242: -- R12 OPM Deviations. Bug 4345503 End
243:
244: --dgupta: Start R12 EAM Integration. Bug 4345492
237: g_dependency_matrix(31).element_id := qa_ss_const.process_resource;
238: g_dependency_matrix(31).parent := qa_ss_const.process_batch_num;
239:
240: g_dependency_matrix(32).element_id := qa_ss_const.process_parameter;
241: g_dependency_matrix(32).parent := qa_ss_const.process_batch_num;
242: -- R12 OPM Deviations. Bug 4345503 End
243:
244: --dgupta: Start R12 EAM Integration. Bug 4345492
245: --Ensure that sequence number (within brackets) is unique when merged
242: -- R12 OPM Deviations. Bug 4345503 End
243:
244: --dgupta: Start R12 EAM Integration. Bug 4345492
245: --Ensure that sequence number (within brackets) is unique when merged
246: g_dependency_matrix(33).element_id := qa_ss_const.asset_instance_number;
247: g_dependency_matrix(33).parent := qa_ss_const.asset_group;
248: --dgupta: End R12 EAM Integration. Bug 4345492
249:
250: END populate_dependency_matrix;
243:
244: --dgupta: Start R12 EAM Integration. Bug 4345492
245: --Ensure that sequence number (within brackets) is unique when merged
246: g_dependency_matrix(33).element_id := qa_ss_const.asset_instance_number;
247: g_dependency_matrix(33).parent := qa_ss_const.asset_group;
248: --dgupta: End R12 EAM Integration. Bug 4345492
249:
250: END populate_dependency_matrix;
251:
542: revision_flag NUMBER;
543:
544: BEGIN
545:
546: IF (element_id = qa_ss_const.revision) THEN
547: revision_flag := g_revision_qty_cntrl_code;
548:
549: ELSIF (element_id = qa_ss_const.comp_revision) THEN
550: revision_flag := g_comp_revision_qty_cntrl_code;
545:
546: IF (element_id = qa_ss_const.revision) THEN
547: revision_flag := g_revision_qty_cntrl_code;
548:
549: ELSIF (element_id = qa_ss_const.comp_revision) THEN
550: revision_flag := g_comp_revision_qty_cntrl_code;
551: END IF;
552:
553: IF ( revision_flag = 1) and (value is not NULL) THEN
579: revision_flag NUMBER;
580:
581: BEGIN
582:
583: IF (element_id = qa_ss_const.revision) THEN
584: revision_flag := g_revision_qty_cntrl_code;
585:
586: ELSIF (element_id = qa_ss_const.comp_revision) THEN
587: revision_flag := g_comp_revision_qty_cntrl_code;
582:
583: IF (element_id = qa_ss_const.revision) THEN
584: revision_flag := g_revision_qty_cntrl_code;
585:
586: ELSIF (element_id = qa_ss_const.comp_revision) THEN
587: revision_flag := g_comp_revision_qty_cntrl_code;
588: END IF;
589:
590: IF ( revision_flag = 1) and (value is not NULL) THEN
652: m_flag NUMBER;
653:
654: BEGIN
655:
656: IF (element_id = qa_ss_const.revision) or
657: (element_id = qa_ss_const.comp_revision) THEN
658:
659: RETURN validate_mandatory_revision(row_record.plan_id, element_id,
660: value);
653:
654: BEGIN
655:
656: IF (element_id = qa_ss_const.revision) or
657: (element_id = qa_ss_const.comp_revision) THEN
658:
659: RETURN validate_mandatory_revision(row_record.plan_id, element_id,
660: value);
661:
665: -- when History Relationship is present.
666: -- Bug 2700230.suramasw Mon Dec 23 03:06:30 PST 2002.
667:
668: /*
669: IF (element_id = qa_ss_const.locator) or
670: (element_name = qa_ss_const.comp_locator) THEN
671: */
672:
673: IF (element_id IN( qa_ss_const.locator,qa_ss_const.to_locator,
666: -- Bug 2700230.suramasw Mon Dec 23 03:06:30 PST 2002.
667:
668: /*
669: IF (element_id = qa_ss_const.locator) or
670: (element_name = qa_ss_const.comp_locator) THEN
671: */
672:
673: IF (element_id IN( qa_ss_const.locator,qa_ss_const.to_locator,
674: qa_ss_const.comp_locator)) THEN
669: IF (element_id = qa_ss_const.locator) or
670: (element_name = qa_ss_const.comp_locator) THEN
671: */
672:
673: IF (element_id IN( qa_ss_const.locator,qa_ss_const.to_locator,
674: qa_ss_const.comp_locator)) THEN
675:
676: RETURN validate_mandatory_locator(row_record.plan_id, element_id,
677: value);
670: (element_name = qa_ss_const.comp_locator) THEN
671: */
672:
673: IF (element_id IN( qa_ss_const.locator,qa_ss_const.to_locator,
674: qa_ss_const.comp_locator)) THEN
675:
676: RETURN validate_mandatory_locator(row_record.plan_id, element_id,
677: value);
678: END IF;
743: -- x_where_clause := NULL;
744: --
745:
746: IF (qa_plan_element_api.element_in_plan(row_record.plan_id,
747: qa_ss_const.production_line) AND
748: row_elements.exists(qa_ss_const.production_line) AND
749: row_elements(qa_ss_const.production_line).value IS NOT NULL) THEN
750:
751: x_where_clause :=
744: --
745:
746: IF (qa_plan_element_api.element_in_plan(row_record.plan_id,
747: qa_ss_const.production_line) AND
748: row_elements.exists(qa_ss_const.production_line) AND
749: row_elements(qa_ss_const.production_line).value IS NOT NULL) THEN
750:
751: x_where_clause :=
752: 'inventory_item_id IN ' ||
745:
746: IF (qa_plan_element_api.element_in_plan(row_record.plan_id,
747: qa_ss_const.production_line) AND
748: row_elements.exists(qa_ss_const.production_line) AND
749: row_elements(qa_ss_const.production_line).value IS NOT NULL) THEN
750:
751: x_where_clause :=
752: 'inventory_item_id IN ' ||
753: '((SELECT primary_item_id ' ||
753: '((SELECT primary_item_id ' ||
754: 'FROM wip_repetitive_items_v ' ||
755: 'WHERE organization_id = ' || g_org_id || ' AND ' ||
756: 'line_code = ''' ||
757: row_elements(qa_ss_const.production_line).value ||
758: ''') ' ||
759: 'UNION ALL ' ||
760: '(SELECT assembly_item_id '||
761: 'FROM bom_operational_routings_v '||
760: '(SELECT assembly_item_id '||
761: 'FROM bom_operational_routings_v '||
762: 'WHERE organization_id = ' || g_org_id || ' AND ' ||
763: 'line_code = ''' ||
764: row_elements(qa_ss_const.production_line).value ||
765: '''))';
766:
767: ELSE
768: x_where_clause := NULL;
1506:
1507: -- added the following to include new hardcoded element followup activity
1508: -- saugupta
1509:
1510: IF element_id IN (qa_ss_const.item, qa_ss_const.comp_item,
1511: qa_ss_const.asset_group, qa_ss_const.asset_activity, qa_ss_const.followup_activity) THEN
1512: g_item_id := row_elements(element_id).id;
1513: END IF;
1514:
1507: -- added the following to include new hardcoded element followup activity
1508: -- saugupta
1509:
1510: IF element_id IN (qa_ss_const.item, qa_ss_const.comp_item,
1511: qa_ss_const.asset_group, qa_ss_const.asset_activity, qa_ss_const.followup_activity) THEN
1512: g_item_id := row_elements(element_id).id;
1513: END IF;
1514:
1515: ELSIF (element_id = qa_ss_const.item) THEN
1511: qa_ss_const.asset_group, qa_ss_const.asset_activity, qa_ss_const.followup_activity) THEN
1512: g_item_id := row_elements(element_id).id;
1513: END IF;
1514:
1515: ELSIF (element_id = qa_ss_const.item) THEN
1516: error_code := validate_kf_item(row_elements, row_record, element_id,
1517: value, result_holder);
1518:
1519: ELSIF (element_id = qa_ss_const.comp_item) THEN
1515: ELSIF (element_id = qa_ss_const.item) THEN
1516: error_code := validate_kf_item(row_elements, row_record, element_id,
1517: value, result_holder);
1518:
1519: ELSIF (element_id = qa_ss_const.comp_item) THEN
1520: error_code := validate_kf_comp_item(row_elements, row_record,
1521: element_id, value, result_holder);
1522:
1523: ELSIF (element_id = qa_ss_const.locator) THEN
1519: ELSIF (element_id = qa_ss_const.comp_item) THEN
1520: error_code := validate_kf_comp_item(row_elements, row_record,
1521: element_id, value, result_holder);
1522:
1523: ELSIF (element_id = qa_ss_const.locator) THEN
1524: error_code := validate_kf_locator(row_elements, row_record, element_id,
1525: value, result_holder);
1526:
1527: ELSIF (element_id = qa_ss_const.comp_locator) THEN
1523: ELSIF (element_id = qa_ss_const.locator) THEN
1524: error_code := validate_kf_locator(row_elements, row_record, element_id,
1525: value, result_holder);
1526:
1527: ELSIF (element_id = qa_ss_const.comp_locator) THEN
1528: error_code := validate_kf_comp_locator(row_elements, row_record,
1529: element_id, value, result_holder);
1530:
1531: -- Bug 5248191. Modified check for Asset Group to call new function
1529: element_id, value, result_holder);
1530:
1531: -- Bug 5248191. Modified check for Asset Group to call new function
1532: -- saugupta Wed, 02 Aug 2006 01:44:07 -0700 PDT
1533: ELSIF (element_id = qa_ss_const.asset_group) THEN
1534: error_code := validate_kf_asset_group(row_elements, row_record,
1535: element_id, value, result_holder);
1536:
1537: ELSIF (element_id = qa_ss_const.asset_activity) THEN
1533: ELSIF (element_id = qa_ss_const.asset_group) THEN
1534: error_code := validate_kf_asset_group(row_elements, row_record,
1535: element_id, value, result_holder);
1536:
1537: ELSIF (element_id = qa_ss_const.asset_activity) THEN
1538: error_code := validate_kf_item(row_elements, row_record,
1539: element_id, value, result_holder);
1540:
1541: -- added the following to include new hardcoded element followup activity
1540:
1541: -- added the following to include new hardcoded element followup activity
1542: -- saugupta
1543:
1544: ELSIF (element_id = qa_ss_const.followup_activity) THEN
1545: error_code := validate_kf_item(row_elements, row_record,
1546: element_id, value, result_holder);
1547:
1548:
1549: -- Added the following for NCM Hardcode Elements.
1550: -- suramasw Thu Oct 31 10:48:59 PST 2002.
1551: -- Bug 2449067.
1552:
1553: ELSIF (element_id = qa_ss_const.bill_reference) THEN
1554: error_code := validate_kf_bill_reference(row_elements, row_record,
1555: element_id, value, result_holder);
1556:
1557: ELSIF (element_id = qa_ss_const.routing_reference) THEN
1553: ELSIF (element_id = qa_ss_const.bill_reference) THEN
1554: error_code := validate_kf_bill_reference(row_elements, row_record,
1555: element_id, value, result_holder);
1556:
1557: ELSIF (element_id = qa_ss_const.routing_reference) THEN
1558: error_code := validate_kf_routing_reference(row_elements, row_record,
1559: element_id, value, result_holder);
1560:
1561: ELSIF (element_id = qa_ss_const.to_locator) THEN
1557: ELSIF (element_id = qa_ss_const.routing_reference) THEN
1558: error_code := validate_kf_routing_reference(row_elements, row_record,
1559: element_id, value, result_holder);
1560:
1561: ELSIF (element_id = qa_ss_const.to_locator) THEN
1562: error_code := validate_kf_to_locator(row_elements, row_record,
1563: element_id, value, result_holder);
1564:
1565: -- End of inclusions for NCM Hardcode Elements.
1588: id NUMBER;
1589:
1590: BEGIN
1591:
1592: IF (element_id = qa_ss_const.department)
1593: OR (element_id = qa_ss_const.to_department) THEN
1594: id := qa_plan_element_api.get_department_id(x_org_id, value);
1595:
1596: ELSIF (element_id = qa_ss_const.job_name) THEN
1589:
1590: BEGIN
1591:
1592: IF (element_id = qa_ss_const.department)
1593: OR (element_id = qa_ss_const.to_department) THEN
1594: id := qa_plan_element_api.get_department_id(x_org_id, value);
1595:
1596: ELSIF (element_id = qa_ss_const.job_name) THEN
1597: id := qa_plan_element_api.get_job_id(x_org_id, value);
1592: IF (element_id = qa_ss_const.department)
1593: OR (element_id = qa_ss_const.to_department) THEN
1594: id := qa_plan_element_api.get_department_id(x_org_id, value);
1595:
1596: ELSIF (element_id = qa_ss_const.job_name) THEN
1597: id := qa_plan_element_api.get_job_id(x_org_id, value);
1598:
1599: ELSIF (element_id = qa_ss_const.production_line) THEN
1600: id := qa_plan_element_api.get_production_line_id(x_org_id, value);
1595:
1596: ELSIF (element_id = qa_ss_const.job_name) THEN
1597: id := qa_plan_element_api.get_job_id(x_org_id, value);
1598:
1599: ELSIF (element_id = qa_ss_const.production_line) THEN
1600: id := qa_plan_element_api.get_production_line_id(x_org_id, value);
1601:
1602: ELSIF (element_id = qa_ss_const.resource_code) THEN
1603: id := qa_plan_element_api.get_resource_code_id(x_org_id, value);
1598:
1599: ELSIF (element_id = qa_ss_const.production_line) THEN
1600: id := qa_plan_element_api.get_production_line_id(x_org_id, value);
1601:
1602: ELSIF (element_id = qa_ss_const.resource_code) THEN
1603: id := qa_plan_element_api.get_resource_code_id(x_org_id, value);
1604:
1605: ELSIF (element_id = qa_ss_const.vendor_name) THEN
1606: id := qa_plan_element_api.get_supplier_id(value);
1601:
1602: ELSIF (element_id = qa_ss_const.resource_code) THEN
1603: id := qa_plan_element_api.get_resource_code_id(x_org_id, value);
1604:
1605: ELSIF (element_id = qa_ss_const.vendor_name) THEN
1606: id := qa_plan_element_api.get_supplier_id(value);
1607:
1608: ELSIF (element_id = qa_ss_const.po_number) THEN
1609: id := qa_plan_element_api.get_po_number_id(value);
1604:
1605: ELSIF (element_id = qa_ss_const.vendor_name) THEN
1606: id := qa_plan_element_api.get_supplier_id(value);
1607:
1608: ELSIF (element_id = qa_ss_const.po_number) THEN
1609: id := qa_plan_element_api.get_po_number_id(value);
1610:
1611: ELSIF (element_id = qa_ss_const.customer_name) THEN
1612: id := qa_plan_element_api.get_customer_id(value);
1607:
1608: ELSIF (element_id = qa_ss_const.po_number) THEN
1609: id := qa_plan_element_api.get_po_number_id(value);
1610:
1611: ELSIF (element_id = qa_ss_const.customer_name) THEN
1612: id := qa_plan_element_api.get_customer_id(value);
1613:
1614: ELSIF (element_id = qa_ss_const.sales_order) THEN
1615: id := qa_plan_element_api.get_so_number_id(value);
1610:
1611: ELSIF (element_id = qa_ss_const.customer_name) THEN
1612: id := qa_plan_element_api.get_customer_id(value);
1613:
1614: ELSIF (element_id = qa_ss_const.sales_order) THEN
1615: id := qa_plan_element_api.get_so_number_id(value);
1616:
1617: -- bug 16214422
1618: g_sales_order_id := id;
1616:
1617: -- bug 16214422
1618: g_sales_order_id := id;
1619:
1620: ELSIF (element_id = qa_ss_const.order_line) THEN
1621: -- bug 16214422
1622: -- Get the SO line id based on the SO header Id as well
1623: --
1624: --id := qa_plan_element_api.get_so_line_number_id(value);
1623: --
1624: --id := qa_plan_element_api.get_so_line_number_id(value);
1625: id := qa_plan_element_api.get_so_line_number_id(value, g_sales_order_id);
1626:
1627: ELSIF (element_id = qa_ss_const.po_release_num) THEN
1628: id := qa_plan_element_api.get_po_release_number_id(value,
1629: g_po_header_id);
1630:
1631: ELSIF (element_id = qa_ss_const.project_number) THEN
1627: ELSIF (element_id = qa_ss_const.po_release_num) THEN
1628: id := qa_plan_element_api.get_po_release_number_id(value,
1629: g_po_header_id);
1630:
1631: ELSIF (element_id = qa_ss_const.project_number) THEN
1632: id := qa_plan_element_api.get_project_number_id(value);
1633: --
1634: -- Bug 2672396. Need to keep a cache of the returned project ID
1635: -- bso Mon Nov 25 17:29:56 PST 2002
1635: -- bso Mon Nov 25 17:29:56 PST 2002
1636: --
1637: g_project_id := id;
1638:
1639: ELSIF (element_id = qa_ss_const.task_number) THEN
1640: --
1641: -- Bug 2672396. Added g_project_id because task is a dependent element.
1642: -- bso Mon Nov 25 17:29:56 PST 2002
1643: --
1642: -- bso Mon Nov 25 17:29:56 PST 2002
1643: --
1644: id := qa_plan_element_api.get_task_number_id(value, g_project_id);
1645:
1646: ELSIF (element_id = qa_ss_const.rma_number) THEN
1647: id := qa_plan_element_api.get_rma_number_id(value);
1648:
1649: ELSIF (element_id = qa_ss_const.license_plate_number) THEN
1650: id := qa_plan_element_api.get_lpn_id(value);
1645:
1646: ELSIF (element_id = qa_ss_const.rma_number) THEN
1647: id := qa_plan_element_api.get_rma_number_id(value);
1648:
1649: ELSIF (element_id = qa_ss_const.license_plate_number) THEN
1650: id := qa_plan_element_api.get_lpn_id(value);
1651:
1652: -- added the following to include new hardcoded element Transfer license plate number
1653: -- saugupta
1651:
1652: -- added the following to include new hardcoded element Transfer license plate number
1653: -- saugupta
1654:
1655: ELSIF (element_id = qa_ss_const.xfr_license_plate_number) THEN
1656: id := qa_plan_element_api.get_xfr_lpn_id(value);
1657:
1658:
1659: ELSIF (element_id = qa_ss_const.contract_number) THEN
1655: ELSIF (element_id = qa_ss_const.xfr_license_plate_number) THEN
1656: id := qa_plan_element_api.get_xfr_lpn_id(value);
1657:
1658:
1659: ELSIF (element_id = qa_ss_const.contract_number) THEN
1660: id := qa_plan_element_api.get_contract_id(value);
1661:
1662: ELSIF (element_id = qa_ss_const.contract_line_number) THEN
1663: id := qa_plan_element_api.get_contract_line_id(value);
1658:
1659: ELSIF (element_id = qa_ss_const.contract_number) THEN
1660: id := qa_plan_element_api.get_contract_id(value);
1661:
1662: ELSIF (element_id = qa_ss_const.contract_line_number) THEN
1663: id := qa_plan_element_api.get_contract_line_id(value);
1664:
1665: ELSIF (element_id = qa_ss_const.deliverable_number) THEN
1666: id := qa_plan_element_api.get_deliverable_id(value);
1661:
1662: ELSIF (element_id = qa_ss_const.contract_line_number) THEN
1663: id := qa_plan_element_api.get_contract_line_id(value);
1664:
1665: ELSIF (element_id = qa_ss_const.deliverable_number) THEN
1666: id := qa_plan_element_api.get_deliverable_id(value);
1667:
1668: ELSIF (element_id = qa_ss_const.work_order) THEN
1669: id := qa_plan_element_api.get_work_order_id(x_org_id, value);
1664:
1665: ELSIF (element_id = qa_ss_const.deliverable_number) THEN
1666: id := qa_plan_element_api.get_deliverable_id(value);
1667:
1668: ELSIF (element_id = qa_ss_const.work_order) THEN
1669: id := qa_plan_element_api.get_work_order_id(x_org_id, value);
1670:
1671: --dgupta: Start R12 EAM Integration. Bug 4345492
1672: ELSIF (element_id = qa_ss_const.asset_instance_number) THEN
1668: ELSIF (element_id = qa_ss_const.work_order) THEN
1669: id := qa_plan_element_api.get_work_order_id(x_org_id, value);
1670:
1671: --dgupta: Start R12 EAM Integration. Bug 4345492
1672: ELSIF (element_id = qa_ss_const.asset_instance_number) THEN
1673: id := qa_plan_element_api.get_asset_instance_id(value);
1674: --dgupta: End R12 EAM Integration. Bug 4345492
1675:
1676: ELSIF (element_id = qa_ss_const.party_name) THEN
1672: ELSIF (element_id = qa_ss_const.asset_instance_number) THEN
1673: id := qa_plan_element_api.get_asset_instance_id(value);
1674: --dgupta: End R12 EAM Integration. Bug 4345492
1675:
1676: ELSIF (element_id = qa_ss_const.party_name) THEN
1677: id := qa_plan_element_api.get_party_id(value);
1678:
1679: ELSIF (element_id = qa_ss_const.item_instance) THEN
1680: id := qa_plan_element_api.get_item_instance_id(value);
1675:
1676: ELSIF (element_id = qa_ss_const.party_name) THEN
1677: id := qa_plan_element_api.get_party_id(value);
1678:
1679: ELSIF (element_id = qa_ss_const.item_instance) THEN
1680: id := qa_plan_element_api.get_item_instance_id(value);
1681:
1682: ELSIF (element_id = qa_ss_const.service_request) THEN
1683: id := qa_plan_element_api.get_service_request_id(value);
1678:
1679: ELSIF (element_id = qa_ss_const.item_instance) THEN
1680: id := qa_plan_element_api.get_item_instance_id(value);
1681:
1682: ELSIF (element_id = qa_ss_const.service_request) THEN
1683: id := qa_plan_element_api.get_service_request_id(value);
1684:
1685: ELSIF (element_id = qa_ss_const.maintenance_requirement) THEN
1686: id := qa_plan_element_api.get_maintenance_req_id(value);
1681:
1682: ELSIF (element_id = qa_ss_const.service_request) THEN
1683: id := qa_plan_element_api.get_service_request_id(value);
1684:
1685: ELSIF (element_id = qa_ss_const.maintenance_requirement) THEN
1686: id := qa_plan_element_api.get_maintenance_req_id(value);
1687:
1688: ELSIF (element_id = qa_ss_const.rework_job) THEN
1689: id := qa_plan_element_api.get_rework_job_id(x_org_id, value);
1684:
1685: ELSIF (element_id = qa_ss_const.maintenance_requirement) THEN
1686: id := qa_plan_element_api.get_maintenance_req_id(value);
1687:
1688: ELSIF (element_id = qa_ss_const.rework_job) THEN
1689: id := qa_plan_element_api.get_rework_job_id(x_org_id, value);
1690:
1691: ELSIF (element_id = qa_ss_const.counter_name) THEN
1692: id := qa_plan_element_api.get_counter_name_id(value);
1687:
1688: ELSIF (element_id = qa_ss_const.rework_job) THEN
1689: id := qa_plan_element_api.get_rework_job_id(x_org_id, value);
1690:
1691: ELSIF (element_id = qa_ss_const.counter_name) THEN
1692: id := qa_plan_element_api.get_counter_name_id(value);
1693:
1694: -- Added the following for NCM Hardcode Elements.
1695: -- suramasw Thu Oct 31 10:48:59 PST 2002.
1694: -- Added the following for NCM Hardcode Elements.
1695: -- suramasw Thu Oct 31 10:48:59 PST 2002.
1696: -- Bug 2449067.
1697:
1698: ELSIF (element_id = qa_ss_const.lot_status) THEN
1699: id := qa_plan_element_api.get_lot_status_id(value);
1700:
1701: ELSIF (element_id = qa_ss_const.serial_status) THEN
1702: id := qa_plan_element_api.get_serial_status_id(value);
1697:
1698: ELSIF (element_id = qa_ss_const.lot_status) THEN
1699: id := qa_plan_element_api.get_lot_status_id(value);
1700:
1701: ELSIF (element_id = qa_ss_const.serial_status) THEN
1702: id := qa_plan_element_api.get_serial_status_id(value);
1703:
1704: -- End of inclusions for NCM Hardcode Elements.
1705:
1703:
1704: -- End of inclusions for NCM Hardcode Elements.
1705:
1706: -- R12 OPM Deviations. Bug 4345503 Start
1707: ELSIF (element_id = qa_ss_const.process_batch_num) THEN
1708: id := qa_plan_element_api.get_process_batch_id(value, x_org_id);
1709: g_process_batch_id := id;
1710:
1711: ELSIF (element_id = qa_ss_const.process_batchstep_num) THEN
1707: ELSIF (element_id = qa_ss_const.process_batch_num) THEN
1708: id := qa_plan_element_api.get_process_batch_id(value, x_org_id);
1709: g_process_batch_id := id;
1710:
1711: ELSIF (element_id = qa_ss_const.process_batchstep_num) THEN
1712: id := qa_plan_element_api.get_process_batchstep_id
1713: (value,g_process_batch_id);
1714: g_process_batchstep_id := id;
1715:
1712: id := qa_plan_element_api.get_process_batchstep_id
1713: (value,g_process_batch_id);
1714: g_process_batchstep_id := id;
1715:
1716: ELSIF (element_id = qa_ss_const.process_operation) THEN
1717: id := qa_plan_element_api.get_process_operation_id
1718: (value,g_process_batch_id,g_process_batchstep_id);
1719:
1720: ELSIF (element_id = qa_ss_const.process_activity) THEN
1716: ELSIF (element_id = qa_ss_const.process_operation) THEN
1717: id := qa_plan_element_api.get_process_operation_id
1718: (value,g_process_batch_id,g_process_batchstep_id);
1719:
1720: ELSIF (element_id = qa_ss_const.process_activity) THEN
1721: id := qa_plan_element_api.get_process_activity_id
1722: (value,g_process_batch_id,g_process_batchstep_id);
1723: g_process_activity_id := id;
1724:
1721: id := qa_plan_element_api.get_process_activity_id
1722: (value,g_process_batch_id,g_process_batchstep_id);
1723: g_process_activity_id := id;
1724:
1725: ELSIF (element_id = qa_ss_const.process_resource) THEN
1726: id := qa_plan_element_api.get_process_resource_id
1727: (value,g_process_batch_id,
1728: g_process_batchstep_id, g_process_activity_id);
1729: g_process_resource_id := id;
1726: id := qa_plan_element_api.get_process_resource_id
1727: (value,g_process_batch_id,
1728: g_process_batchstep_id, g_process_activity_id);
1729: g_process_resource_id := id;
1730: ELSIF (element_id = qa_ss_const.process_parameter) THEN
1731: id := qa_plan_element_api.get_process_parameter_id
1732: (value,g_process_resource_id);
1733:
1734: -- R12 OPM Deviations. Bug 4345503 End
1732: (value,g_process_resource_id);
1733:
1734: -- R12 OPM Deviations. Bug 4345503 End
1735: --R12 DR Integration . Bug 4345489 start
1736: ELSIF (element_id = qa_ss_const.repair_order_number) THEN
1737: id := qa_plan_element_api.get_repair_line_id
1738: (value);
1739: ELSIF (element_id = qa_ss_const.jtf_task_number) THEN
1740: id := qa_plan_element_api.get_jtf_task_id(value);
1735: --R12 DR Integration . Bug 4345489 start
1736: ELSIF (element_id = qa_ss_const.repair_order_number) THEN
1737: id := qa_plan_element_api.get_repair_line_id
1738: (value);
1739: ELSIF (element_id = qa_ss_const.jtf_task_number) THEN
1740: id := qa_plan_element_api.get_jtf_task_id(value);
1741: --R12 Dr Integration. Bug 4345489 end
1742: END IF;
1743:
1787: -- to be used along with Maintenance Workorder
1788: -- rkunchal Mon Sep 23 23:46:28 PDT 2002
1789: -- Added to the IF ladder for Maintenance Workorder
1790: --
1791: IF (element_id = qa_ss_const.job_name) THEN
1792: g_wip_entity_id := id;
1793: ELSIF (element_id = qa_ss_const.po_number) THEN
1794: g_po_header_id := id;
1795: ELSIF (element_id = qa_ss_const.production_line) THEN
1789: -- Added to the IF ladder for Maintenance Workorder
1790: --
1791: IF (element_id = qa_ss_const.job_name) THEN
1792: g_wip_entity_id := id;
1793: ELSIF (element_id = qa_ss_const.po_number) THEN
1794: g_po_header_id := id;
1795: ELSIF (element_id = qa_ss_const.production_line) THEN
1796: g_line_id := id;
1797: ELSIF (element_id = qa_ss_const.work_order) THEN
1791: IF (element_id = qa_ss_const.job_name) THEN
1792: g_wip_entity_id := id;
1793: ELSIF (element_id = qa_ss_const.po_number) THEN
1794: g_po_header_id := id;
1795: ELSIF (element_id = qa_ss_const.production_line) THEN
1796: g_line_id := id;
1797: ELSIF (element_id = qa_ss_const.work_order) THEN
1798: g_work_order_id := id;
1799: ELSIF (element_id = qa_ss_const.rma_number) THEN
1793: ELSIF (element_id = qa_ss_const.po_number) THEN
1794: g_po_header_id := id;
1795: ELSIF (element_id = qa_ss_const.production_line) THEN
1796: g_line_id := id;
1797: ELSIF (element_id = qa_ss_const.work_order) THEN
1798: g_work_order_id := id;
1799: ELSIF (element_id = qa_ss_const.rma_number) THEN
1800: -- Bug 9773026. Assign RMA Header Id to the global variable.
1801: -- skolluku
1795: ELSIF (element_id = qa_ss_const.production_line) THEN
1796: g_line_id := id;
1797: ELSIF (element_id = qa_ss_const.work_order) THEN
1798: g_work_order_id := id;
1799: ELSIF (element_id = qa_ss_const.rma_number) THEN
1800: -- Bug 9773026. Assign RMA Header Id to the global variable.
1801: -- skolluku
1802: g_rma_header_id := id;
1803: --
1804: -- Bug 11659488
1805: -- Cache the Sales_order_id in the Global variable so that it can be used
1806: -- to filter the SO_line_numbers
1807: --
1808: ELSIF (element_id = qa_ss_const.sales_order) THEN
1809: g_sales_order_id := id;
1810: END IF;
1811:
1812:
1828: BEGIN
1829:
1830: -- Transaction Date is validated only in PO Inspection Transaction
1831:
1832: IF (element_id = qa_ss_const.transaction_date) THEN
1833: result := qa_plan_element_api.validate_transaction_date(
1834: g_transaction_number);
1835: --
1836: -- Bug 8690822
1837: -- Separating the condition for UOM and Comp UOM,
1838: -- as Comp Item Id would have to be used for Comp UOM.
1839: -- skolluku
1840: --
1841: ELSIF (element_id = qa_ss_const.uom) THEN
1842: --OR (element_id = qa_ss_const.comp_uom) THEN
1843: result := qa_plan_element_api.validate_uom(
1844: x_org_id, g_item_id, x_value);
1845: --
1838: -- as Comp Item Id would have to be used for Comp UOM.
1839: -- skolluku
1840: --
1841: ELSIF (element_id = qa_ss_const.uom) THEN
1842: --OR (element_id = qa_ss_const.comp_uom) THEN
1843: result := qa_plan_element_api.validate_uom(
1844: x_org_id, g_item_id, x_value);
1845: --
1846: -- Bug 8690822
1847: -- Pass g_comp_item_id to validate_uom, as the validation has
1848: -- to be done for Comp UOM and not UOM.
1849: -- skolluku
1850: --
1851: ELSIF (element_id = qa_ss_const.comp_uom) THEN
1852: result := qa_plan_element_api.validate_uom(
1853: x_org_id, g_comp_item_id, x_value);
1854:
1855: ELSIF (element_id = qa_ss_const.revision)
1851: ELSIF (element_id = qa_ss_const.comp_uom) THEN
1852: result := qa_plan_element_api.validate_uom(
1853: x_org_id, g_comp_item_id, x_value);
1854:
1855: ELSIF (element_id = qa_ss_const.revision)
1856: OR (element_id = qa_ss_const.comp_revision) THEN
1857: result := qa_plan_element_api.validate_revision(
1858: x_org_id, g_item_id, x_value);
1859:
1852: result := qa_plan_element_api.validate_uom(
1853: x_org_id, g_comp_item_id, x_value);
1854:
1855: ELSIF (element_id = qa_ss_const.revision)
1856: OR (element_id = qa_ss_const.comp_revision) THEN
1857: result := qa_plan_element_api.validate_revision(
1858: x_org_id, g_item_id, x_value);
1859:
1860: ELSIF (element_id = qa_ss_const.subinventory)
1856: OR (element_id = qa_ss_const.comp_revision) THEN
1857: result := qa_plan_element_api.validate_revision(
1858: x_org_id, g_item_id, x_value);
1859:
1860: ELSIF (element_id = qa_ss_const.subinventory)
1861: OR (element_id = qa_ss_const.comp_subinventory) THEN
1862: result := qa_plan_element_api.validate_subinventory(
1863: x_org_id, x_value);
1864:
1857: result := qa_plan_element_api.validate_revision(
1858: x_org_id, g_item_id, x_value);
1859:
1860: ELSIF (element_id = qa_ss_const.subinventory)
1861: OR (element_id = qa_ss_const.comp_subinventory) THEN
1862: result := qa_plan_element_api.validate_subinventory(
1863: x_org_id, x_value);
1864:
1865: -- Bug 4558205. OA Framewok Integration UT bug fix.
1866: -- Lot and serial numbers are not validated in server
1867: -- side for stand alone QWB.
1868: -- srhariha. Tue Sep 27 03:14:23 PDT 2005.
1869:
1870: ELSIF (element_id = qa_ss_const.lot_number) THEN
1871: IF(g_transaction_number is null) OR (g_transaction_number = -1) THEN
1872: result := qa_plan_element_api.validate_lot_num(x_org_id,
1873: g_item_id ,
1874: x_value);
1877: g_transaction_id,
1878: x_value);
1879: END IF;
1880:
1881: ELSIF (element_id = qa_ss_const.serial_number) THEN
1882:
1883: IF(g_transaction_number is null) OR (g_transaction_number = -1) THEN
1884:
1885: result := qa_plan_element_api.validate_serial_num(x_org_id,
1895: END IF;
1896:
1897: -- End. Bug 4558205.
1898:
1899: ELSIF (element_id = qa_ss_const.to_op_seq_num)
1900: OR (element_id = qa_ss_const.from_op_seq_num) THEN
1901: result := qa_plan_element_api.validate_op_seq_number(
1902: x_org_id, g_line_id,
1903: g_wip_entity_id, x_value);
1896:
1897: -- End. Bug 4558205.
1898:
1899: ELSIF (element_id = qa_ss_const.to_op_seq_num)
1900: OR (element_id = qa_ss_const.from_op_seq_num) THEN
1901: result := qa_plan_element_api.validate_op_seq_number(
1902: x_org_id, g_line_id,
1903: g_wip_entity_id, x_value);
1904:
1908: -- to be used along with Maintenance Workorder
1909: -- rkunchal Mon Sep 23 23:46:28 PDT 2002
1910: --
1911:
1912: ELSIF (element_id = qa_ss_const.maintenance_op_seq) THEN
1913: result := qa_plan_element_api.validate_maintenance_op_seq(
1914: x_org_id, g_work_order_id, x_value);
1915: --
1916: -- End of inclusions for Bug 2588213
1916: -- End of inclusions for Bug 2588213
1917: --
1918:
1919:
1920: ELSIF (element_id = qa_ss_const.po_line_num) THEN
1921:
1922: g_po_line_number := x_value;
1923: result := qa_plan_element_api.validate_po_line_number(
1924: g_po_header_id, x_value);
1922: g_po_line_number := x_value;
1923: result := qa_plan_element_api.validate_po_line_number(
1924: g_po_header_id, x_value);
1925:
1926: ELSIF (element_id = qa_ss_const.po_shipment_num) THEN
1927: result := qa_plan_element_api.validate_po_shipments(
1928: g_po_line_number,
1929: g_po_header_id, x_value);
1930:
1927: result := qa_plan_element_api.validate_po_shipments(
1928: g_po_line_number,
1929: g_po_header_id, x_value);
1930:
1931: ELSIF (element_id = qa_ss_const.receipt_num) THEN
1932: result := qa_plan_element_api.validate_receipt_number(x_value);
1933:
1934: /*
1935: ELSIF (element_id = qa_ss_const.comp_serial_number) THEN
1931: ELSIF (element_id = qa_ss_const.receipt_num) THEN
1932: result := qa_plan_element_api.validate_receipt_number(x_value);
1933:
1934: /*
1935: ELSIF (element_id = qa_ss_const.comp_serial_number) THEN
1936: result := TRUE;
1937:
1938: ELSIF (element_id = qa_ss_const.comp_lot_number) THEN
1939: result := TRUE;
1934: /*
1935: ELSIF (element_id = qa_ss_const.comp_serial_number) THEN
1936: result := TRUE;
1937:
1938: ELSIF (element_id = qa_ss_const.comp_lot_number) THEN
1939: result := TRUE;
1940:
1941: ELSIF (element_id = qa_ss_const.quantity) THEN
1942: result := TRUE;
1937:
1938: ELSIF (element_id = qa_ss_const.comp_lot_number) THEN
1939: result := TRUE;
1940:
1941: ELSIF (element_id = qa_ss_const.quantity) THEN
1942: result := TRUE;
1943:
1944: ELSIF (element_id = qa_ss_const.asset_number) THEN
1945: result := TRUE;
1940:
1941: ELSIF (element_id = qa_ss_const.quantity) THEN
1942: result := TRUE;
1943:
1944: ELSIF (element_id = qa_ss_const.asset_number) THEN
1945: result := TRUE;
1946: */
1947: -- Added the following for NCM Hardcode Elements.
1948: -- suramasw Thu Oct 31 10:48:59 PST 2002.
1947: -- Added the following for NCM Hardcode Elements.
1948: -- suramasw Thu Oct 31 10:48:59 PST 2002.
1949: -- Bug 2449067.
1950:
1951: ELSIF (element_id = qa_ss_const.to_subinventory) THEN
1952: result := qa_plan_element_api.validate_to_subinventory(
1953: x_org_id, x_value);
1954:
1955: /*
1952: result := qa_plan_element_api.validate_to_subinventory(
1953: x_org_id, x_value);
1954:
1955: /*
1956: ELSIF (element_id = qa_ss_const.lot_status) THEN
1957: result := qa_plan_element_api.validate_lot_status(x_value);
1958:
1959: ELSIF (element_id = qa_ss_const.concurrent_request_id) THEN
1960: result := TRUE;
1955: /*
1956: ELSIF (element_id = qa_ss_const.lot_status) THEN
1957: result := qa_plan_element_api.validate_lot_status(x_value);
1958:
1959: ELSIF (element_id = qa_ss_const.concurrent_request_id) THEN
1960: result := TRUE;
1961:
1962: ELSIF (element_id = qa_ss_const.nonconformance_code) THEN
1963: result := TRUE;
1958:
1959: ELSIF (element_id = qa_ss_const.concurrent_request_id) THEN
1960: result := TRUE;
1961:
1962: ELSIF (element_id = qa_ss_const.nonconformance_code) THEN
1963: result := TRUE;
1964:
1965: ELSIF (element_id = qa_ss_const.date_opened) THEN
1966: result := TRUE;
1961:
1962: ELSIF (element_id = qa_ss_const.nonconformance_code) THEN
1963: result := TRUE;
1964:
1965: ELSIF (element_id = qa_ss_const.date_opened) THEN
1966: result := TRUE;
1967:
1968: ELSIF (element_id = qa_ss_const.date_closed) THEN
1969: result := TRUE;
1964:
1965: ELSIF (element_id = qa_ss_const.date_opened) THEN
1966: result := TRUE;
1967:
1968: ELSIF (element_id = qa_ss_const.date_closed) THEN
1969: result := TRUE;
1970:
1971: ELSIF (element_id = qa_ss_const.days_to_close) THEN
1972: result := TRUE;
1967:
1968: ELSIF (element_id = qa_ss_const.date_closed) THEN
1969: result := TRUE;
1970:
1971: ELSIF (element_id = qa_ss_const.days_to_close) THEN
1972: result := TRUE;
1973: */
1974: -- the above code and the code above to_subinventory procedure was commented
1975: -- out to directly put an else clause which validates to TRUE since there is no
2034: PROCEDURE copy_primitive_to_global(p_element_id IN NUMBER, p_value IN VARCHAR2) IS
2035:
2036: BEGIN
2037:
2038: IF (p_element_id = qa_ss_const.subinventory) THEN
2039: g_subinventory := p_value;
2040:
2041: ELSIF (p_element_id = qa_ss_const.lot_number) THEN
2042: g_lot_number := p_value;
2037:
2038: IF (p_element_id = qa_ss_const.subinventory) THEN
2039: g_subinventory := p_value;
2040:
2041: ELSIF (p_element_id = qa_ss_const.lot_number) THEN
2042: g_lot_number := p_value;
2043:
2044: -- Added the following condition to enable History Records
2045: -- to be created when History Relationship is present.
2044: -- Added the following condition to enable History Records
2045: -- to be created when History Relationship is present.
2046: -- Bug 2700230.suramasw Mon Dec 23 03:06:30 PST 2002.
2047:
2048: ELSIF (p_element_id = qa_ss_const.to_subinventory) THEN
2049: g_to_subinventory := p_value;
2050:
2051: -- Bug 4558205. OA Framewok Integration UT bug fix.
2052: -- Lot and serial numbers are not validated in server
2053: -- side for stand alone QWB. Adding revision for serial
2054: -- number validation.
2055: -- srhariha. Tue Sep 27 03:14:23 PDT 2005.
2056:
2057: ELSIF (p_element_id = qa_ss_const.revision) THEN
2058: g_revision := p_value;
2059: --
2060: -- Bug 6126260
2061: -- Added the extra condition to assign the value of the
2062: -- component subinventory to the global variable which
2063: -- would later be used to validate the comp subinventory locator.
2064: -- bhsankar Thu Jan 4 20:58:23 PST 2007
2065: --
2066: ELSIF (p_element_id = qa_ss_const.comp_subinventory) THEN
2067: g_comp_subinventory := p_value;
2068:
2069: END IF;
2070:
2094: END IF;
2095:
2096: /*
2097: IF element_id IN (
2098: qa_ss_const.disposition,
2099: qa_ss_const.disposition_action,
2100: qa_ss_const.disposition_source,
2101: qa_ss_const.disposition_status,
2102: qa_ss_const.nonconformance_source,
2095:
2096: /*
2097: IF element_id IN (
2098: qa_ss_const.disposition,
2099: qa_ss_const.disposition_action,
2100: qa_ss_const.disposition_source,
2101: qa_ss_const.disposition_status,
2102: qa_ss_const.nonconformance_source,
2103: qa_ss_const.nonconform_severity,
2096: /*
2097: IF element_id IN (
2098: qa_ss_const.disposition,
2099: qa_ss_const.disposition_action,
2100: qa_ss_const.disposition_source,
2101: qa_ss_const.disposition_status,
2102: qa_ss_const.nonconformance_source,
2103: qa_ss_const.nonconform_severity,
2104: qa_ss_const.nonconform_priority,
2097: IF element_id IN (
2098: qa_ss_const.disposition,
2099: qa_ss_const.disposition_action,
2100: qa_ss_const.disposition_source,
2101: qa_ss_const.disposition_status,
2102: qa_ss_const.nonconformance_source,
2103: qa_ss_const.nonconform_severity,
2104: qa_ss_const.nonconform_priority,
2105: qa_ss_const.nonconformance_type,
2098: qa_ss_const.disposition,
2099: qa_ss_const.disposition_action,
2100: qa_ss_const.disposition_source,
2101: qa_ss_const.disposition_status,
2102: qa_ss_const.nonconformance_source,
2103: qa_ss_const.nonconform_severity,
2104: qa_ss_const.nonconform_priority,
2105: qa_ss_const.nonconformance_type,
2106: qa_ss_const.nonconformance_status) THEN
2099: qa_ss_const.disposition_action,
2100: qa_ss_const.disposition_source,
2101: qa_ss_const.disposition_status,
2102: qa_ss_const.nonconformance_source,
2103: qa_ss_const.nonconform_severity,
2104: qa_ss_const.nonconform_priority,
2105: qa_ss_const.nonconformance_type,
2106: qa_ss_const.nonconformance_status) THEN
2107:
2100: qa_ss_const.disposition_source,
2101: qa_ss_const.disposition_status,
2102: qa_ss_const.nonconformance_source,
2103: qa_ss_const.nonconform_severity,
2104: qa_ss_const.nonconform_priority,
2105: qa_ss_const.nonconformance_type,
2106: qa_ss_const.nonconformance_status) THEN
2107:
2108: RETURN validate_values(plan_id, element_id, value);
2101: qa_ss_const.disposition_status,
2102: qa_ss_const.nonconformance_source,
2103: qa_ss_const.nonconform_severity,
2104: qa_ss_const.nonconform_priority,
2105: qa_ss_const.nonconformance_type,
2106: qa_ss_const.nonconformance_status) THEN
2107:
2108: RETURN validate_values(plan_id, element_id, value);
2109: END IF;
2102: qa_ss_const.nonconformance_source,
2103: qa_ss_const.nonconform_severity,
2104: qa_ss_const.nonconform_priority,
2105: qa_ss_const.nonconformance_type,
2106: qa_ss_const.nonconformance_status) THEN
2107:
2108: RETURN validate_values(plan_id, element_id, value);
2109: END IF;
2110: */
2159: --
2160: -- Bug 11659488
2161: -- For So_line_number, the LOV has to be pruned by the SO_Header_id
2162: --
2163: IF (element_id IN (qa_ss_const.rma_line_num, qa_ss_const.order_line)) THEN -- add more elements if needed.
2164: sql_string := qa_chars_api.remove_order_by_from_sql(sql_string);
2165: IF (element_id = qa_ss_const.rma_line_num AND g_rma_header_id IS NOT NULL) THEN
2166: sql_string := sql_string || ' AND SH.HEADER_ID = ' || g_rma_header_id;
2167: END IF;
2161: -- For So_line_number, the LOV has to be pruned by the SO_Header_id
2162: --
2163: IF (element_id IN (qa_ss_const.rma_line_num, qa_ss_const.order_line)) THEN -- add more elements if needed.
2164: sql_string := qa_chars_api.remove_order_by_from_sql(sql_string);
2165: IF (element_id = qa_ss_const.rma_line_num AND g_rma_header_id IS NOT NULL) THEN
2166: sql_string := sql_string || ' AND SH.HEADER_ID = ' || g_rma_header_id;
2167: END IF;
2168:
2169: IF (element_id = qa_ss_const.order_line AND g_sales_order_id IS NOT NULL) THEN
2165: IF (element_id = qa_ss_const.rma_line_num AND g_rma_header_id IS NOT NULL) THEN
2166: sql_string := sql_string || ' AND SH.HEADER_ID = ' || g_rma_header_id;
2167: END IF;
2168:
2169: IF (element_id = qa_ss_const.order_line AND g_sales_order_id IS NOT NULL) THEN
2170: sql_string := sql_string || ' AND OEHA.HEADER_ID IN (SELECT oe.header_id FROM mtl_sales_orders mso, '
2171: || ' oe_order_headers_all oe, oe_transaction_types_tl ot '
2172: || ' WHERE mso.segment1 = oe.order_number AND oe.order_type_id = ot.transaction_type_id '
2173: || ' AND mso.segment2 = ot.name AND mso.sales_order_id = '|| g_sales_order_id || ')';
2397:
2398: precision := nvl(qa_plan_element_api.decimal_precision(plan_id, element_id),
2399: qa_chars_api.decimal_precision(element_id));
2400:
2401: IF (data_type = qa_ss_const.date_datatype) THEN
2402: error_code := validate_date(value, result_holder);
2403:
2404: ELSIF (data_type = qa_ss_const.datetime_datatype) THEN
2405: val_len := length(value);
2400:
2401: IF (data_type = qa_ss_const.date_datatype) THEN
2402: error_code := validate_date(value, result_holder);
2403:
2404: ELSIF (data_type = qa_ss_const.datetime_datatype) THEN
2405: val_len := length(value);
2406: if substr(value, val_len - 1, 2) = '.0' then
2407: -- all hardcoded datetimes in self service come here.
2408: -- When coming from Self service, a '.0' is appended to the value
2422: -- real datatype of the element. If it is character than call validate_datetime
2423: -- else its hardcoded so calling validate_date.
2424: -- saugupta Wed, 14 Jan 2004 04:40:08 -0800 PDT
2425:
2426: IF (actual_datatype = qa_ss_const.character_datatype) THEN
2427: error_code := validate_datetime(value, result_holder);
2428:
2429: -- Bug 3318462. From ss and mobile softcoded datetime elements are
2430: -- in server timezone. Above call will throw and exception. Returned
2439: error_code := validate_date(value, result_holder);
2440: END IF;
2441: end if;
2442:
2443: ELSIF (data_type = qa_ss_const.number_datatype) THEN
2444: error_code := validate_number(value, len, precision,
2445: result_holder);
2446: --
2447: -- Bug 3402251. In order to use the round-up values in
2455:
2456: -- Bug 2427337. Added following elsif condition for longcomment datatype
2457: -- rponnusa Tue Jun 25 06:15:48 PDT 2002
2458:
2459: ELSIF (data_type = qa_ss_const.comment_datatype) THEN
2460: error_code := validate_comment(value, result_holder);
2461:
2462: ELSE
2463: error_code := validate_char(value, result_holder);
2749: -- Binding the value of the Global parameter Org Id set in the function
2750: -- validate_row
2751: -- ntungare Mon Oct 10 01:14:31 PDT 2005
2752: --
2753: IF INSTR(final_stmt, QA_SS_CONST.bindvar_param_org_id, 1)<> 0 THEN
2754: dbms_sql.bind_variable(c1, QA_SS_CONST.bindvar_param_org_id, g_org_id);
2755: END IF;
2756:
2757: --
2750: -- validate_row
2751: -- ntungare Mon Oct 10 01:14:31 PDT 2005
2752: --
2753: IF INSTR(final_stmt, QA_SS_CONST.bindvar_param_org_id, 1)<> 0 THEN
2754: dbms_sql.bind_variable(c1, QA_SS_CONST.bindvar_param_org_id, g_org_id);
2755: END IF;
2756:
2757: --
2758: -- Bug 4635316
2759: -- Binding the value of the Global parameter User Id set in the function
2760: -- validate_row
2761: -- ntungare Mon Oct 10 01:14:31 PDT 2005
2762: --
2763: IF INSTR(final_stmt, QA_SS_CONST.bindvar_param_user_id, 1) <> 0 THEN
2764: dbms_sql.bind_variable(c1, QA_SS_CONST.bindvar_param_user_id, g_user_id);
2765: END IF;
2766:
2767: --set up the type of the output we expect
2760: -- validate_row
2761: -- ntungare Mon Oct 10 01:14:31 PDT 2005
2762: --
2763: IF INSTR(final_stmt, QA_SS_CONST.bindvar_param_user_id, 1) <> 0 THEN
2764: dbms_sql.bind_variable(c1, QA_SS_CONST.bindvar_param_user_id, g_user_id);
2765: END IF;
2766:
2767: --set up the type of the output we expect
2768:
2906: -- If it is backward assignment then we must modify the
2907: -- return_results_array to indicate the change, but this value
2908: -- will NOT be validated.
2909:
2910: IF (action_id = qa_ss_const.display_message_action) THEN
2911:
2912: message_index := message_array.count;
2913: message_array(message_index).element_id := element_id;
2914: message_array(message_index).action_type :=
2911:
2912: message_index := message_array.count;
2913: message_array(message_index).element_id := element_id;
2914: message_array(message_index).action_type :=
2915: qa_ss_const.display_message_action;
2916: message_array(message_index).message := message;
2917:
2918: ELSIF (action_id = qa_ss_const.reject_input_action) THEN
2919:
2914: message_array(message_index).action_type :=
2915: qa_ss_const.display_message_action;
2916: message_array(message_index).message := message;
2917:
2918: ELSIF (action_id = qa_ss_const.reject_input_action) THEN
2919:
2920: message_index := message_array.count;
2921: message_array(message_index).element_id := element_id;
2922: message_array(message_index).action_type :=
2919:
2920: message_index := message_array.count;
2921: message_array(message_index).element_id := element_id;
2922: message_array(message_index).action_type :=
2923: qa_ss_const.reject_input_action;
2924: message_array(message_index).message := message;
2925:
2926: -- This can be used in self service, and if the action
2927: -- is fired, this will be consiidered an error. Therrfore,
2928: -- we should return reject_an_entry_error.
2929:
2930: RETURN reject_an_entry_error;
2931:
2932: ELSIF (action_id = qa_ss_const.assign_value_action) THEN
2933:
2934: target_element := qa_plan_element_api.get_target_element(
2935: plan_char_action_id);
2936:
2961: -- is then used in the subsequent calls.
2962: -- ntungare Sun Oct 16 20:36:17 PDT 2005
2963: --
2964: altered_message := QLTTRAFB.REPLACE_TOKEN(X_STRING => message,
2965: X_OLD_TOKEN => QA_SS_CONST.global_param_org_id ,
2966: X_NEW_TOKEN => QA_SS_CONST.bindvar_param_org_id);
2967:
2968: altered_message := QLTTRAFB.REPLACE_TOKEN(X_STRING => altered_message,
2969: X_OLD_TOKEN => QA_SS_CONST.global_param_user_id,
2962: -- ntungare Sun Oct 16 20:36:17 PDT 2005
2963: --
2964: altered_message := QLTTRAFB.REPLACE_TOKEN(X_STRING => message,
2965: X_OLD_TOKEN => QA_SS_CONST.global_param_org_id ,
2966: X_NEW_TOKEN => QA_SS_CONST.bindvar_param_org_id);
2967:
2968: altered_message := QLTTRAFB.REPLACE_TOKEN(X_STRING => altered_message,
2969: X_OLD_TOKEN => QA_SS_CONST.global_param_user_id,
2970: X_NEW_TOKEN => QA_SS_CONST.bindvar_param_user_id);
2965: X_OLD_TOKEN => QA_SS_CONST.global_param_org_id ,
2966: X_NEW_TOKEN => QA_SS_CONST.bindvar_param_org_id);
2967:
2968: altered_message := QLTTRAFB.REPLACE_TOKEN(X_STRING => altered_message,
2969: X_OLD_TOKEN => QA_SS_CONST.global_param_user_id,
2970: X_NEW_TOKEN => QA_SS_CONST.bindvar_param_user_id);
2971:
2972: assigned_value := get_assigned_value(plan_char_action_id, altered_message,
2973: row_elements);
2966: X_NEW_TOKEN => QA_SS_CONST.bindvar_param_org_id);
2967:
2968: altered_message := QLTTRAFB.REPLACE_TOKEN(X_STRING => altered_message,
2969: X_OLD_TOKEN => QA_SS_CONST.global_param_user_id,
2970: X_NEW_TOKEN => QA_SS_CONST.bindvar_param_user_id);
2971:
2972: assigned_value := get_assigned_value(plan_char_action_id, altered_message,
2973: row_elements);
2974:
3030: END IF;
3031:
3032: message_index := message_array.count;
3033: message_array(message_index).element_id := element_id;
3034: message_array(message_index).action_type := qa_ss_const.assign_value_action;
3035: assigned_element := qa_chars_api.prompt(target_element);
3036:
3037: -- bug 3178307. rkaza. 10/07/2003. Timezone Support.
3038: If qa_chars_api.datatype(target_element) = qa_ss_const.datetime_datatype then
3034: message_array(message_index).action_type := qa_ss_const.assign_value_action;
3035: assigned_element := qa_chars_api.prompt(target_element);
3036:
3037: -- bug 3178307. rkaza. 10/07/2003. Timezone Support.
3038: If qa_chars_api.datatype(target_element) = qa_ss_const.datetime_datatype then
3039: assigned_value :=
3040: fnd_date.date_to_displayDT(fnd_date.canonical_to_date(assigned_value), calendar_aware=> FND_DATE.calendar_aware_alt);
3041: End if;
3042:
3048: --ilawler - bug #3340004 - Mon Feb 16 18:53:29 2004
3049: --According to bso, the message should always be
3050: /*
3051: message_array(message_index).message := assigned_value || ' Has Been Assigned To: ' || assigned_element || ' As Per The Assign A Value Action Of ' || trigger_element;
3052: IF (action_id <> qa_ss_const.assign_value_action) THEN
3053: startText := trigger_element || ': ' ;
3054: END IF;
3055:
3056: message_array(message_index).message := startText || assigned_element || ' = ' || replace(assigned_value,'@','@@');
3133:
3134: -- rkaza. bug 3248836. 11/11/2003. tz bug.
3135: datatype := qa_chars_api.datatype(element_id);
3136:
3137: IF (datatype = qa_ss_const.datetime_datatype) THEN
3138: val_len := length(value);
3139: if substr(value, val_len - 1, 2) = '.0' then
3140: -- Sometimes when coming from Self service, a '.0'
3141: -- is appended to the value
3384: -- Transaction type element was erroring out for WIP transactions.
3385: -- "Transaction Type" will be treated as one of a kind.
3386: -- srhariha.Tue Aug 2 00:43:07 PDT 2005.
3387:
3388: ELSIF element_id = qa_ss_const.transaction_type THEN
3389: error_list(4).error_code := validate_transaction_type(element_value,
3390: g_org_id,row_record.user_id);
3391:
3392: ELSIF qa_plan_element_api.values_exist(row_record.plan_id, element_id) THEN
3879: x_elements(i).validation_flag :=
3880: x_elements(i).validation_flag ||
3881: qa_validation_api.action_fired;
3882:
3883: IF i = qa_ss_const.transaction_type THEN
3884: x_elements(i).validation_flag :=
3885: x_elements(i).validation_flag ||
3886: qa_validation_api.valid_element;
3887: END IF;
3955:
3956: --
3957: -- Step 2. Set additional valid elements.
3958: --
3959: IF x_elements.EXISTS(qa_ss_const.lot_number) THEN
3960: x_elements(qa_ss_const.lot_number).validation_flag :=
3961: x_elements(qa_ss_const.lot_number).validation_flag ||
3962: qa_validation_api.valid_element;
3963: END IF;
3956: --
3957: -- Step 2. Set additional valid elements.
3958: --
3959: IF x_elements.EXISTS(qa_ss_const.lot_number) THEN
3960: x_elements(qa_ss_const.lot_number).validation_flag :=
3961: x_elements(qa_ss_const.lot_number).validation_flag ||
3962: qa_validation_api.valid_element;
3963: END IF;
3964:
3957: -- Step 2. Set additional valid elements.
3958: --
3959: IF x_elements.EXISTS(qa_ss_const.lot_number) THEN
3960: x_elements(qa_ss_const.lot_number).validation_flag :=
3961: x_elements(qa_ss_const.lot_number).validation_flag ||
3962: qa_validation_api.valid_element;
3963: END IF;
3964:
3965: IF x_elements.EXISTS(qa_ss_const.serial_number) THEN
3961: x_elements(qa_ss_const.lot_number).validation_flag ||
3962: qa_validation_api.valid_element;
3963: END IF;
3964:
3965: IF x_elements.EXISTS(qa_ss_const.serial_number) THEN
3966: x_elements(qa_ss_const.serial_number).validation_flag :=
3967: x_elements(qa_ss_const.serial_number).validation_flag ||
3968: qa_validation_api.valid_element;
3969: END IF;
3962: qa_validation_api.valid_element;
3963: END IF;
3964:
3965: IF x_elements.EXISTS(qa_ss_const.serial_number) THEN
3966: x_elements(qa_ss_const.serial_number).validation_flag :=
3967: x_elements(qa_ss_const.serial_number).validation_flag ||
3968: qa_validation_api.valid_element;
3969: END IF;
3970:
3963: END IF;
3964:
3965: IF x_elements.EXISTS(qa_ss_const.serial_number) THEN
3966: x_elements(qa_ss_const.serial_number).validation_flag :=
3967: x_elements(qa_ss_const.serial_number).validation_flag ||
3968: qa_validation_api.valid_element;
3969: END IF;
3970:
3971: IF x_elements.EXISTS(qa_ss_const.transaction_type) THEN
3967: x_elements(qa_ss_const.serial_number).validation_flag ||
3968: qa_validation_api.valid_element;
3969: END IF;
3970:
3971: IF x_elements.EXISTS(qa_ss_const.transaction_type) THEN
3972: x_elements(qa_ss_const.transaction_type).validation_flag :=
3973: x_elements(qa_ss_const.transaction_type).validation_flag ||
3974: qa_validation_api.valid_element;
3975: END IF;
3968: qa_validation_api.valid_element;
3969: END IF;
3970:
3971: IF x_elements.EXISTS(qa_ss_const.transaction_type) THEN
3972: x_elements(qa_ss_const.transaction_type).validation_flag :=
3973: x_elements(qa_ss_const.transaction_type).validation_flag ||
3974: qa_validation_api.valid_element;
3975: END IF;
3976:
3969: END IF;
3970:
3971: IF x_elements.EXISTS(qa_ss_const.transaction_type) THEN
3972: x_elements(qa_ss_const.transaction_type).validation_flag :=
3973: x_elements(qa_ss_const.transaction_type).validation_flag ||
3974: qa_validation_api.valid_element;
3975: END IF;
3976:
3977: --