[Home] [Help]
121: PROCEDURE populate_dependency_matrix IS
122:
123: BEGIN
124:
125: g_dependency_matrix(1).element_id := qa_ss_const.item;
126: g_dependency_matrix(1).parent := qa_ss_const.production_line;
127:
128: g_dependency_matrix(2).element_id := qa_ss_const.to_op_seq_num;
129: g_dependency_matrix(2).parent := qa_ss_const.job_name;
122:
123: BEGIN
124:
125: g_dependency_matrix(1).element_id := qa_ss_const.item;
126: g_dependency_matrix(1).parent := qa_ss_const.production_line;
127:
128: g_dependency_matrix(2).element_id := qa_ss_const.to_op_seq_num;
129: g_dependency_matrix(2).parent := qa_ss_const.job_name;
130:
124:
125: g_dependency_matrix(1).element_id := qa_ss_const.item;
126: g_dependency_matrix(1).parent := qa_ss_const.production_line;
127:
128: g_dependency_matrix(2).element_id := qa_ss_const.to_op_seq_num;
129: g_dependency_matrix(2).parent := qa_ss_const.job_name;
130:
131: g_dependency_matrix(3).element_id := qa_ss_const.to_op_seq_num;
132: g_dependency_matrix(3).parent := qa_ss_const.production_line;
125: g_dependency_matrix(1).element_id := qa_ss_const.item;
126: g_dependency_matrix(1).parent := qa_ss_const.production_line;
127:
128: g_dependency_matrix(2).element_id := qa_ss_const.to_op_seq_num;
129: g_dependency_matrix(2).parent := qa_ss_const.job_name;
130:
131: g_dependency_matrix(3).element_id := qa_ss_const.to_op_seq_num;
132: g_dependency_matrix(3).parent := qa_ss_const.production_line;
133:
127:
128: g_dependency_matrix(2).element_id := qa_ss_const.to_op_seq_num;
129: g_dependency_matrix(2).parent := qa_ss_const.job_name;
130:
131: g_dependency_matrix(3).element_id := qa_ss_const.to_op_seq_num;
132: g_dependency_matrix(3).parent := qa_ss_const.production_line;
133:
134: g_dependency_matrix(4).element_id := qa_ss_const.from_op_seq_num;
135: g_dependency_matrix(4).parent := qa_ss_const.job_name;
128: g_dependency_matrix(2).element_id := qa_ss_const.to_op_seq_num;
129: g_dependency_matrix(2).parent := qa_ss_const.job_name;
130:
131: g_dependency_matrix(3).element_id := qa_ss_const.to_op_seq_num;
132: g_dependency_matrix(3).parent := qa_ss_const.production_line;
133:
134: g_dependency_matrix(4).element_id := qa_ss_const.from_op_seq_num;
135: g_dependency_matrix(4).parent := qa_ss_const.job_name;
136:
130:
131: g_dependency_matrix(3).element_id := qa_ss_const.to_op_seq_num;
132: g_dependency_matrix(3).parent := qa_ss_const.production_line;
133:
134: g_dependency_matrix(4).element_id := qa_ss_const.from_op_seq_num;
135: g_dependency_matrix(4).parent := qa_ss_const.job_name;
136:
137: g_dependency_matrix(5).element_id := qa_ss_const.from_op_seq_num;
138: g_dependency_matrix(5).parent := qa_ss_const.production_line;
131: g_dependency_matrix(3).element_id := qa_ss_const.to_op_seq_num;
132: g_dependency_matrix(3).parent := qa_ss_const.production_line;
133:
134: g_dependency_matrix(4).element_id := qa_ss_const.from_op_seq_num;
135: g_dependency_matrix(4).parent := qa_ss_const.job_name;
136:
137: g_dependency_matrix(5).element_id := qa_ss_const.from_op_seq_num;
138: g_dependency_matrix(5).parent := qa_ss_const.production_line;
139:
133:
134: g_dependency_matrix(4).element_id := qa_ss_const.from_op_seq_num;
135: g_dependency_matrix(4).parent := qa_ss_const.job_name;
136:
137: g_dependency_matrix(5).element_id := qa_ss_const.from_op_seq_num;
138: g_dependency_matrix(5).parent := qa_ss_const.production_line;
139:
140: g_dependency_matrix(6).element_id := qa_ss_const.to_intraoperation_step;
141: g_dependency_matrix(6).parent := qa_ss_const.to_op_seq_num;
134: g_dependency_matrix(4).element_id := qa_ss_const.from_op_seq_num;
135: g_dependency_matrix(4).parent := qa_ss_const.job_name;
136:
137: g_dependency_matrix(5).element_id := qa_ss_const.from_op_seq_num;
138: g_dependency_matrix(5).parent := qa_ss_const.production_line;
139:
140: g_dependency_matrix(6).element_id := qa_ss_const.to_intraoperation_step;
141: g_dependency_matrix(6).parent := qa_ss_const.to_op_seq_num;
142:
136:
137: g_dependency_matrix(5).element_id := qa_ss_const.from_op_seq_num;
138: g_dependency_matrix(5).parent := qa_ss_const.production_line;
139:
140: g_dependency_matrix(6).element_id := qa_ss_const.to_intraoperation_step;
141: g_dependency_matrix(6).parent := qa_ss_const.to_op_seq_num;
142:
143: g_dependency_matrix(7).element_id := qa_ss_const.from_intraoperation_step;
144: g_dependency_matrix(7).parent := qa_ss_const.from_op_seq_num;
137: g_dependency_matrix(5).element_id := qa_ss_const.from_op_seq_num;
138: g_dependency_matrix(5).parent := qa_ss_const.production_line;
139:
140: g_dependency_matrix(6).element_id := qa_ss_const.to_intraoperation_step;
141: g_dependency_matrix(6).parent := qa_ss_const.to_op_seq_num;
142:
143: g_dependency_matrix(7).element_id := qa_ss_const.from_intraoperation_step;
144: g_dependency_matrix(7).parent := qa_ss_const.from_op_seq_num;
145:
139:
140: g_dependency_matrix(6).element_id := qa_ss_const.to_intraoperation_step;
141: g_dependency_matrix(6).parent := qa_ss_const.to_op_seq_num;
142:
143: g_dependency_matrix(7).element_id := qa_ss_const.from_intraoperation_step;
144: g_dependency_matrix(7).parent := qa_ss_const.from_op_seq_num;
145:
146: g_dependency_matrix(8).element_id := qa_ss_const.uom;
147: g_dependency_matrix(8).parent := qa_ss_const.item;
140: g_dependency_matrix(6).element_id := qa_ss_const.to_intraoperation_step;
141: g_dependency_matrix(6).parent := qa_ss_const.to_op_seq_num;
142:
143: g_dependency_matrix(7).element_id := qa_ss_const.from_intraoperation_step;
144: g_dependency_matrix(7).parent := qa_ss_const.from_op_seq_num;
145:
146: g_dependency_matrix(8).element_id := qa_ss_const.uom;
147: g_dependency_matrix(8).parent := qa_ss_const.item;
148:
142:
143: g_dependency_matrix(7).element_id := qa_ss_const.from_intraoperation_step;
144: g_dependency_matrix(7).parent := qa_ss_const.from_op_seq_num;
145:
146: g_dependency_matrix(8).element_id := qa_ss_const.uom;
147: g_dependency_matrix(8).parent := qa_ss_const.item;
148:
149: g_dependency_matrix(9).element_id := qa_ss_const.revision;
150: g_dependency_matrix(9).parent := qa_ss_const.item;
143: g_dependency_matrix(7).element_id := qa_ss_const.from_intraoperation_step;
144: g_dependency_matrix(7).parent := qa_ss_const.from_op_seq_num;
145:
146: g_dependency_matrix(8).element_id := qa_ss_const.uom;
147: g_dependency_matrix(8).parent := qa_ss_const.item;
148:
149: g_dependency_matrix(9).element_id := qa_ss_const.revision;
150: g_dependency_matrix(9).parent := qa_ss_const.item;
151:
145:
146: g_dependency_matrix(8).element_id := qa_ss_const.uom;
147: g_dependency_matrix(8).parent := qa_ss_const.item;
148:
149: g_dependency_matrix(9).element_id := qa_ss_const.revision;
150: g_dependency_matrix(9).parent := qa_ss_const.item;
151:
152: g_dependency_matrix(10).element_id := qa_ss_const.subinventory;
153: g_dependency_matrix(10).parent := qa_ss_const.item;
146: g_dependency_matrix(8).element_id := qa_ss_const.uom;
147: g_dependency_matrix(8).parent := qa_ss_const.item;
148:
149: g_dependency_matrix(9).element_id := qa_ss_const.revision;
150: g_dependency_matrix(9).parent := qa_ss_const.item;
151:
152: g_dependency_matrix(10).element_id := qa_ss_const.subinventory;
153: g_dependency_matrix(10).parent := qa_ss_const.item;
154:
148:
149: g_dependency_matrix(9).element_id := qa_ss_const.revision;
150: g_dependency_matrix(9).parent := qa_ss_const.item;
151:
152: g_dependency_matrix(10).element_id := qa_ss_const.subinventory;
153: g_dependency_matrix(10).parent := qa_ss_const.item;
154:
155: g_dependency_matrix(11).element_id := qa_ss_const.locator;
156: g_dependency_matrix(11).parent := qa_ss_const.subinventory;
149: g_dependency_matrix(9).element_id := qa_ss_const.revision;
150: g_dependency_matrix(9).parent := qa_ss_const.item;
151:
152: g_dependency_matrix(10).element_id := qa_ss_const.subinventory;
153: g_dependency_matrix(10).parent := qa_ss_const.item;
154:
155: g_dependency_matrix(11).element_id := qa_ss_const.locator;
156: g_dependency_matrix(11).parent := qa_ss_const.subinventory;
157:
151:
152: g_dependency_matrix(10).element_id := qa_ss_const.subinventory;
153: g_dependency_matrix(10).parent := qa_ss_const.item;
154:
155: g_dependency_matrix(11).element_id := qa_ss_const.locator;
156: g_dependency_matrix(11).parent := qa_ss_const.subinventory;
157:
158: g_dependency_matrix(12).element_id := qa_ss_const.lot_number;
159: g_dependency_matrix(12).parent := qa_ss_const.item;
152: g_dependency_matrix(10).element_id := qa_ss_const.subinventory;
153: g_dependency_matrix(10).parent := qa_ss_const.item;
154:
155: g_dependency_matrix(11).element_id := qa_ss_const.locator;
156: g_dependency_matrix(11).parent := qa_ss_const.subinventory;
157:
158: g_dependency_matrix(12).element_id := qa_ss_const.lot_number;
159: g_dependency_matrix(12).parent := qa_ss_const.item;
160:
154:
155: g_dependency_matrix(11).element_id := qa_ss_const.locator;
156: g_dependency_matrix(11).parent := qa_ss_const.subinventory;
157:
158: g_dependency_matrix(12).element_id := qa_ss_const.lot_number;
159: g_dependency_matrix(12).parent := qa_ss_const.item;
160:
161: g_dependency_matrix(13).element_id := qa_ss_const.serial_number;
162: g_dependency_matrix(13).parent := qa_ss_const.item;
155: g_dependency_matrix(11).element_id := qa_ss_const.locator;
156: g_dependency_matrix(11).parent := qa_ss_const.subinventory;
157:
158: g_dependency_matrix(12).element_id := qa_ss_const.lot_number;
159: g_dependency_matrix(12).parent := qa_ss_const.item;
160:
161: g_dependency_matrix(13).element_id := qa_ss_const.serial_number;
162: g_dependency_matrix(13).parent := qa_ss_const.item;
163:
157:
158: g_dependency_matrix(12).element_id := qa_ss_const.lot_number;
159: g_dependency_matrix(12).parent := qa_ss_const.item;
160:
161: g_dependency_matrix(13).element_id := qa_ss_const.serial_number;
162: g_dependency_matrix(13).parent := qa_ss_const.item;
163:
164: g_dependency_matrix(14).element_id := qa_ss_const.comp_uom;
165: g_dependency_matrix(14).parent := qa_ss_const.comp_item;
158: g_dependency_matrix(12).element_id := qa_ss_const.lot_number;
159: g_dependency_matrix(12).parent := qa_ss_const.item;
160:
161: g_dependency_matrix(13).element_id := qa_ss_const.serial_number;
162: g_dependency_matrix(13).parent := qa_ss_const.item;
163:
164: g_dependency_matrix(14).element_id := qa_ss_const.comp_uom;
165: g_dependency_matrix(14).parent := qa_ss_const.comp_item;
166:
160:
161: g_dependency_matrix(13).element_id := qa_ss_const.serial_number;
162: g_dependency_matrix(13).parent := qa_ss_const.item;
163:
164: g_dependency_matrix(14).element_id := qa_ss_const.comp_uom;
165: g_dependency_matrix(14).parent := qa_ss_const.comp_item;
166:
167: g_dependency_matrix(15).element_id := qa_ss_const.comp_revision;
168: g_dependency_matrix(15).parent := qa_ss_const.comp_item;
161: g_dependency_matrix(13).element_id := qa_ss_const.serial_number;
162: g_dependency_matrix(13).parent := qa_ss_const.item;
163:
164: g_dependency_matrix(14).element_id := qa_ss_const.comp_uom;
165: g_dependency_matrix(14).parent := qa_ss_const.comp_item;
166:
167: g_dependency_matrix(15).element_id := qa_ss_const.comp_revision;
168: g_dependency_matrix(15).parent := qa_ss_const.comp_item;
169:
163:
164: g_dependency_matrix(14).element_id := qa_ss_const.comp_uom;
165: g_dependency_matrix(14).parent := qa_ss_const.comp_item;
166:
167: g_dependency_matrix(15).element_id := qa_ss_const.comp_revision;
168: g_dependency_matrix(15).parent := qa_ss_const.comp_item;
169:
170: g_dependency_matrix(16).element_id := qa_ss_const.po_line_num;
171: g_dependency_matrix(16).parent := qa_ss_const.po_number;
164: g_dependency_matrix(14).element_id := qa_ss_const.comp_uom;
165: g_dependency_matrix(14).parent := qa_ss_const.comp_item;
166:
167: g_dependency_matrix(15).element_id := qa_ss_const.comp_revision;
168: g_dependency_matrix(15).parent := qa_ss_const.comp_item;
169:
170: g_dependency_matrix(16).element_id := qa_ss_const.po_line_num;
171: g_dependency_matrix(16).parent := qa_ss_const.po_number;
172:
166:
167: g_dependency_matrix(15).element_id := qa_ss_const.comp_revision;
168: g_dependency_matrix(15).parent := qa_ss_const.comp_item;
169:
170: g_dependency_matrix(16).element_id := qa_ss_const.po_line_num;
171: g_dependency_matrix(16).parent := qa_ss_const.po_number;
172:
173: g_dependency_matrix(17).element_id := qa_ss_const.po_shipment_num;
174: g_dependency_matrix(17).parent := qa_ss_const.po_line_num;
167: g_dependency_matrix(15).element_id := qa_ss_const.comp_revision;
168: g_dependency_matrix(15).parent := qa_ss_const.comp_item;
169:
170: g_dependency_matrix(16).element_id := qa_ss_const.po_line_num;
171: g_dependency_matrix(16).parent := qa_ss_const.po_number;
172:
173: g_dependency_matrix(17).element_id := qa_ss_const.po_shipment_num;
174: g_dependency_matrix(17).parent := qa_ss_const.po_line_num;
175:
169:
170: g_dependency_matrix(16).element_id := qa_ss_const.po_line_num;
171: g_dependency_matrix(16).parent := qa_ss_const.po_number;
172:
173: g_dependency_matrix(17).element_id := qa_ss_const.po_shipment_num;
174: g_dependency_matrix(17).parent := qa_ss_const.po_line_num;
175:
176: g_dependency_matrix(18).element_id := qa_ss_const.po_release_num;
177: g_dependency_matrix(18).parent := qa_ss_const.po_number;
170: g_dependency_matrix(16).element_id := qa_ss_const.po_line_num;
171: g_dependency_matrix(16).parent := qa_ss_const.po_number;
172:
173: g_dependency_matrix(17).element_id := qa_ss_const.po_shipment_num;
174: g_dependency_matrix(17).parent := qa_ss_const.po_line_num;
175:
176: g_dependency_matrix(18).element_id := qa_ss_const.po_release_num;
177: g_dependency_matrix(18).parent := qa_ss_const.po_number;
178:
172:
173: g_dependency_matrix(17).element_id := qa_ss_const.po_shipment_num;
174: g_dependency_matrix(17).parent := qa_ss_const.po_line_num;
175:
176: g_dependency_matrix(18).element_id := qa_ss_const.po_release_num;
177: g_dependency_matrix(18).parent := qa_ss_const.po_number;
178:
179: g_dependency_matrix(19).element_id := qa_ss_const.order_line;
180: g_dependency_matrix(19).parent := qa_ss_const.sales_order;
173: g_dependency_matrix(17).element_id := qa_ss_const.po_shipment_num;
174: g_dependency_matrix(17).parent := qa_ss_const.po_line_num;
175:
176: g_dependency_matrix(18).element_id := qa_ss_const.po_release_num;
177: g_dependency_matrix(18).parent := qa_ss_const.po_number;
178:
179: g_dependency_matrix(19).element_id := qa_ss_const.order_line;
180: g_dependency_matrix(19).parent := qa_ss_const.sales_order;
181:
175:
176: g_dependency_matrix(18).element_id := qa_ss_const.po_release_num;
177: g_dependency_matrix(18).parent := qa_ss_const.po_number;
178:
179: g_dependency_matrix(19).element_id := qa_ss_const.order_line;
180: g_dependency_matrix(19).parent := qa_ss_const.sales_order;
181:
182: g_dependency_matrix(20).element_id := qa_ss_const.task_number;
183: g_dependency_matrix(20).parent := qa_ss_const.project_number;
176: g_dependency_matrix(18).element_id := qa_ss_const.po_release_num;
177: g_dependency_matrix(18).parent := qa_ss_const.po_number;
178:
179: g_dependency_matrix(19).element_id := qa_ss_const.order_line;
180: g_dependency_matrix(19).parent := qa_ss_const.sales_order;
181:
182: g_dependency_matrix(20).element_id := qa_ss_const.task_number;
183: g_dependency_matrix(20).parent := qa_ss_const.project_number;
184:
178:
179: g_dependency_matrix(19).element_id := qa_ss_const.order_line;
180: g_dependency_matrix(19).parent := qa_ss_const.sales_order;
181:
182: g_dependency_matrix(20).element_id := qa_ss_const.task_number;
183: g_dependency_matrix(20).parent := qa_ss_const.project_number;
184:
185: g_dependency_matrix(21).element_id := qa_ss_const.serial_number;
186: g_dependency_matrix(21).parent := qa_ss_const.lot_number;
179: g_dependency_matrix(19).element_id := qa_ss_const.order_line;
180: g_dependency_matrix(19).parent := qa_ss_const.sales_order;
181:
182: g_dependency_matrix(20).element_id := qa_ss_const.task_number;
183: g_dependency_matrix(20).parent := qa_ss_const.project_number;
184:
185: g_dependency_matrix(21).element_id := qa_ss_const.serial_number;
186: g_dependency_matrix(21).parent := qa_ss_const.lot_number;
187:
181:
182: g_dependency_matrix(20).element_id := qa_ss_const.task_number;
183: g_dependency_matrix(20).parent := qa_ss_const.project_number;
184:
185: g_dependency_matrix(21).element_id := qa_ss_const.serial_number;
186: g_dependency_matrix(21).parent := qa_ss_const.lot_number;
187:
188: g_dependency_matrix(22).element_id := qa_ss_const.contract_line_number;
189: g_dependency_matrix(22).parent := qa_ss_const.contract_number;
182: g_dependency_matrix(20).element_id := qa_ss_const.task_number;
183: g_dependency_matrix(20).parent := qa_ss_const.project_number;
184:
185: g_dependency_matrix(21).element_id := qa_ss_const.serial_number;
186: g_dependency_matrix(21).parent := qa_ss_const.lot_number;
187:
188: g_dependency_matrix(22).element_id := qa_ss_const.contract_line_number;
189: g_dependency_matrix(22).parent := qa_ss_const.contract_number;
190:
184:
185: g_dependency_matrix(21).element_id := qa_ss_const.serial_number;
186: g_dependency_matrix(21).parent := qa_ss_const.lot_number;
187:
188: g_dependency_matrix(22).element_id := qa_ss_const.contract_line_number;
189: g_dependency_matrix(22).parent := qa_ss_const.contract_number;
190:
191: g_dependency_matrix(23).element_id := qa_ss_const.deliverable_number;
192: g_dependency_matrix(23).parent := qa_ss_const.contract_line_number;
185: g_dependency_matrix(21).element_id := qa_ss_const.serial_number;
186: g_dependency_matrix(21).parent := qa_ss_const.lot_number;
187:
188: g_dependency_matrix(22).element_id := qa_ss_const.contract_line_number;
189: g_dependency_matrix(22).parent := qa_ss_const.contract_number;
190:
191: g_dependency_matrix(23).element_id := qa_ss_const.deliverable_number;
192: g_dependency_matrix(23).parent := qa_ss_const.contract_line_number;
193:
187:
188: g_dependency_matrix(22).element_id := qa_ss_const.contract_line_number;
189: g_dependency_matrix(22).parent := qa_ss_const.contract_number;
190:
191: g_dependency_matrix(23).element_id := qa_ss_const.deliverable_number;
192: g_dependency_matrix(23).parent := qa_ss_const.contract_line_number;
193:
194: g_dependency_matrix(24).element_id := qa_ss_const.asset_number;
195: g_dependency_matrix(24).parent := qa_ss_const.asset_group;
188: g_dependency_matrix(22).element_id := qa_ss_const.contract_line_number;
189: g_dependency_matrix(22).parent := qa_ss_const.contract_number;
190:
191: g_dependency_matrix(23).element_id := qa_ss_const.deliverable_number;
192: g_dependency_matrix(23).parent := qa_ss_const.contract_line_number;
193:
194: g_dependency_matrix(24).element_id := qa_ss_const.asset_number;
195: g_dependency_matrix(24).parent := qa_ss_const.asset_group;
196:
190:
191: g_dependency_matrix(23).element_id := qa_ss_const.deliverable_number;
192: g_dependency_matrix(23).parent := qa_ss_const.contract_line_number;
193:
194: g_dependency_matrix(24).element_id := qa_ss_const.asset_number;
195: g_dependency_matrix(24).parent := qa_ss_const.asset_group;
196:
197: --
198: -- See Bug 2588213
191: g_dependency_matrix(23).element_id := qa_ss_const.deliverable_number;
192: g_dependency_matrix(23).parent := qa_ss_const.contract_line_number;
193:
194: g_dependency_matrix(24).element_id := qa_ss_const.asset_number;
195: g_dependency_matrix(24).parent := qa_ss_const.asset_group;
196:
197: --
198: -- See Bug 2588213
199: -- To support the element Maintenance Op Seq Number
199: -- To support the element Maintenance Op Seq Number
200: -- to be used along with Maintenance Workorder
201: -- rkunchal Mon Sep 23 23:46:28 PDT 2002
202: --
203: g_dependency_matrix(25).element_id := qa_ss_const.maintenance_op_seq;
204: g_dependency_matrix(25).parent := qa_ss_const.work_order;
205:
206: -- Start of inclusions for NCM Hardcode Elements.
207: -- suramasw Thu Oct 31 10:48:59 PST 2002.
200: -- to be used along with Maintenance Workorder
201: -- rkunchal Mon Sep 23 23:46:28 PDT 2002
202: --
203: g_dependency_matrix(25).element_id := qa_ss_const.maintenance_op_seq;
204: g_dependency_matrix(25).parent := qa_ss_const.work_order;
205:
206: -- Start of inclusions for NCM Hardcode Elements.
207: -- suramasw Thu Oct 31 10:48:59 PST 2002.
208: -- Bug 2449067.
206: -- Start of inclusions for NCM Hardcode Elements.
207: -- suramasw Thu Oct 31 10:48:59 PST 2002.
208: -- Bug 2449067.
209:
210: g_dependency_matrix(26).element_id := qa_ss_const.to_subinventory;
211: g_dependency_matrix(26).parent := qa_ss_const.item;
212:
213: g_dependency_matrix(27).element_id := qa_ss_const.to_locator;
214: g_dependency_matrix(27).parent := qa_ss_const.to_subinventory;
207: -- suramasw Thu Oct 31 10:48:59 PST 2002.
208: -- Bug 2449067.
209:
210: g_dependency_matrix(26).element_id := qa_ss_const.to_subinventory;
211: g_dependency_matrix(26).parent := qa_ss_const.item;
212:
213: g_dependency_matrix(27).element_id := qa_ss_const.to_locator;
214: g_dependency_matrix(27).parent := qa_ss_const.to_subinventory;
215:
209:
210: g_dependency_matrix(26).element_id := qa_ss_const.to_subinventory;
211: g_dependency_matrix(26).parent := qa_ss_const.item;
212:
213: g_dependency_matrix(27).element_id := qa_ss_const.to_locator;
214: g_dependency_matrix(27).parent := qa_ss_const.to_subinventory;
215:
216: -- R12 OPM Deviations. Bug 4345503 Start
217: g_dependency_matrix(28).element_id := qa_ss_const.process_batchstep_num;
210: g_dependency_matrix(26).element_id := qa_ss_const.to_subinventory;
211: g_dependency_matrix(26).parent := qa_ss_const.item;
212:
213: g_dependency_matrix(27).element_id := qa_ss_const.to_locator;
214: g_dependency_matrix(27).parent := qa_ss_const.to_subinventory;
215:
216: -- R12 OPM Deviations. Bug 4345503 Start
217: g_dependency_matrix(28).element_id := qa_ss_const.process_batchstep_num;
218: g_dependency_matrix(28).parent := qa_ss_const.process_batch_num;
213: g_dependency_matrix(27).element_id := qa_ss_const.to_locator;
214: g_dependency_matrix(27).parent := qa_ss_const.to_subinventory;
215:
216: -- R12 OPM Deviations. Bug 4345503 Start
217: g_dependency_matrix(28).element_id := qa_ss_const.process_batchstep_num;
218: g_dependency_matrix(28).parent := qa_ss_const.process_batch_num;
219:
220: g_dependency_matrix(29).element_id := qa_ss_const.process_operation;
221: g_dependency_matrix(29).parent := qa_ss_const.process_batch_num;
214: g_dependency_matrix(27).parent := qa_ss_const.to_subinventory;
215:
216: -- R12 OPM Deviations. Bug 4345503 Start
217: g_dependency_matrix(28).element_id := qa_ss_const.process_batchstep_num;
218: g_dependency_matrix(28).parent := qa_ss_const.process_batch_num;
219:
220: g_dependency_matrix(29).element_id := qa_ss_const.process_operation;
221: g_dependency_matrix(29).parent := qa_ss_const.process_batch_num;
222:
216: -- R12 OPM Deviations. Bug 4345503 Start
217: g_dependency_matrix(28).element_id := qa_ss_const.process_batchstep_num;
218: g_dependency_matrix(28).parent := qa_ss_const.process_batch_num;
219:
220: g_dependency_matrix(29).element_id := qa_ss_const.process_operation;
221: g_dependency_matrix(29).parent := qa_ss_const.process_batch_num;
222:
223: g_dependency_matrix(30).element_id := qa_ss_const.process_activity;
224: g_dependency_matrix(30).parent := qa_ss_const.process_batch_num;
217: g_dependency_matrix(28).element_id := qa_ss_const.process_batchstep_num;
218: g_dependency_matrix(28).parent := qa_ss_const.process_batch_num;
219:
220: g_dependency_matrix(29).element_id := qa_ss_const.process_operation;
221: g_dependency_matrix(29).parent := qa_ss_const.process_batch_num;
222:
223: g_dependency_matrix(30).element_id := qa_ss_const.process_activity;
224: g_dependency_matrix(30).parent := qa_ss_const.process_batch_num;
225:
219:
220: g_dependency_matrix(29).element_id := qa_ss_const.process_operation;
221: g_dependency_matrix(29).parent := qa_ss_const.process_batch_num;
222:
223: g_dependency_matrix(30).element_id := qa_ss_const.process_activity;
224: g_dependency_matrix(30).parent := qa_ss_const.process_batch_num;
225:
226: g_dependency_matrix(31).element_id := qa_ss_const.process_resource;
227: g_dependency_matrix(31).parent := qa_ss_const.process_batch_num;
220: g_dependency_matrix(29).element_id := qa_ss_const.process_operation;
221: g_dependency_matrix(29).parent := qa_ss_const.process_batch_num;
222:
223: g_dependency_matrix(30).element_id := qa_ss_const.process_activity;
224: g_dependency_matrix(30).parent := qa_ss_const.process_batch_num;
225:
226: g_dependency_matrix(31).element_id := qa_ss_const.process_resource;
227: g_dependency_matrix(31).parent := qa_ss_const.process_batch_num;
228:
222:
223: g_dependency_matrix(30).element_id := qa_ss_const.process_activity;
224: g_dependency_matrix(30).parent := qa_ss_const.process_batch_num;
225:
226: g_dependency_matrix(31).element_id := qa_ss_const.process_resource;
227: g_dependency_matrix(31).parent := qa_ss_const.process_batch_num;
228:
229: g_dependency_matrix(32).element_id := qa_ss_const.process_parameter;
230: g_dependency_matrix(32).parent := qa_ss_const.process_batch_num;
223: g_dependency_matrix(30).element_id := qa_ss_const.process_activity;
224: g_dependency_matrix(30).parent := qa_ss_const.process_batch_num;
225:
226: g_dependency_matrix(31).element_id := qa_ss_const.process_resource;
227: g_dependency_matrix(31).parent := qa_ss_const.process_batch_num;
228:
229: g_dependency_matrix(32).element_id := qa_ss_const.process_parameter;
230: g_dependency_matrix(32).parent := qa_ss_const.process_batch_num;
231: -- R12 OPM Deviations. Bug 4345503 End
225:
226: g_dependency_matrix(31).element_id := qa_ss_const.process_resource;
227: g_dependency_matrix(31).parent := qa_ss_const.process_batch_num;
228:
229: g_dependency_matrix(32).element_id := qa_ss_const.process_parameter;
230: g_dependency_matrix(32).parent := qa_ss_const.process_batch_num;
231: -- R12 OPM Deviations. Bug 4345503 End
232:
233: --dgupta: Start R12 EAM Integration. Bug 4345492
226: g_dependency_matrix(31).element_id := qa_ss_const.process_resource;
227: g_dependency_matrix(31).parent := qa_ss_const.process_batch_num;
228:
229: g_dependency_matrix(32).element_id := qa_ss_const.process_parameter;
230: g_dependency_matrix(32).parent := qa_ss_const.process_batch_num;
231: -- R12 OPM Deviations. Bug 4345503 End
232:
233: --dgupta: Start R12 EAM Integration. Bug 4345492
234: --Ensure that sequence number (within brackets) is unique when merged
231: -- R12 OPM Deviations. Bug 4345503 End
232:
233: --dgupta: Start R12 EAM Integration. Bug 4345492
234: --Ensure that sequence number (within brackets) is unique when merged
235: g_dependency_matrix(33).element_id := qa_ss_const.asset_instance_number;
236: g_dependency_matrix(33).parent := qa_ss_const.asset_group;
237: --dgupta: End R12 EAM Integration. Bug 4345492
238:
239: END populate_dependency_matrix;
232:
233: --dgupta: Start R12 EAM Integration. Bug 4345492
234: --Ensure that sequence number (within brackets) is unique when merged
235: g_dependency_matrix(33).element_id := qa_ss_const.asset_instance_number;
236: g_dependency_matrix(33).parent := qa_ss_const.asset_group;
237: --dgupta: End R12 EAM Integration. Bug 4345492
238:
239: END populate_dependency_matrix;
240:
531: revision_flag NUMBER;
532:
533: BEGIN
534:
535: IF (element_id = qa_ss_const.revision) THEN
536: revision_flag := g_revision_qty_cntrl_code;
537:
538: ELSIF (element_id = qa_ss_const.comp_revision) THEN
539: revision_flag := g_comp_revision_qty_cntrl_code;
534:
535: IF (element_id = qa_ss_const.revision) THEN
536: revision_flag := g_revision_qty_cntrl_code;
537:
538: ELSIF (element_id = qa_ss_const.comp_revision) THEN
539: revision_flag := g_comp_revision_qty_cntrl_code;
540: END IF;
541:
542: IF ( revision_flag = 1) and (value is not NULL) THEN
568: revision_flag NUMBER;
569:
570: BEGIN
571:
572: IF (element_id = qa_ss_const.revision) THEN
573: revision_flag := g_revision_qty_cntrl_code;
574:
575: ELSIF (element_id = qa_ss_const.comp_revision) THEN
576: revision_flag := g_comp_revision_qty_cntrl_code;
571:
572: IF (element_id = qa_ss_const.revision) THEN
573: revision_flag := g_revision_qty_cntrl_code;
574:
575: ELSIF (element_id = qa_ss_const.comp_revision) THEN
576: revision_flag := g_comp_revision_qty_cntrl_code;
577: END IF;
578:
579: IF ( revision_flag = 1) and (value is not NULL) THEN
641: m_flag NUMBER;
642:
643: BEGIN
644:
645: IF (element_id = qa_ss_const.revision) or
646: (element_id = qa_ss_const.comp_revision) THEN
647:
648: RETURN validate_mandatory_revision(row_record.plan_id, element_id,
649: value);
642:
643: BEGIN
644:
645: IF (element_id = qa_ss_const.revision) or
646: (element_id = qa_ss_const.comp_revision) THEN
647:
648: RETURN validate_mandatory_revision(row_record.plan_id, element_id,
649: value);
650:
654: -- when History Relationship is present.
655: -- Bug 2700230.suramasw Mon Dec 23 03:06:30 PST 2002.
656:
657: /*
658: IF (element_id = qa_ss_const.locator) or
659: (element_name = qa_ss_const.comp_locator) THEN
660: */
661:
662: IF (element_id IN( qa_ss_const.locator,qa_ss_const.to_locator,
655: -- Bug 2700230.suramasw Mon Dec 23 03:06:30 PST 2002.
656:
657: /*
658: IF (element_id = qa_ss_const.locator) or
659: (element_name = qa_ss_const.comp_locator) THEN
660: */
661:
662: IF (element_id IN( qa_ss_const.locator,qa_ss_const.to_locator,
663: qa_ss_const.comp_locator)) THEN
658: IF (element_id = qa_ss_const.locator) or
659: (element_name = qa_ss_const.comp_locator) THEN
660: */
661:
662: IF (element_id IN( qa_ss_const.locator,qa_ss_const.to_locator,
663: qa_ss_const.comp_locator)) THEN
664:
665: RETURN validate_mandatory_locator(row_record.plan_id, element_id,
666: value);
659: (element_name = qa_ss_const.comp_locator) THEN
660: */
661:
662: IF (element_id IN( qa_ss_const.locator,qa_ss_const.to_locator,
663: qa_ss_const.comp_locator)) THEN
664:
665: RETURN validate_mandatory_locator(row_record.plan_id, element_id,
666: value);
667: END IF;
732: -- x_where_clause := NULL;
733: --
734:
735: IF (qa_plan_element_api.element_in_plan(row_record.plan_id,
736: qa_ss_const.production_line) AND
737: row_elements.exists(qa_ss_const.production_line) AND
738: row_elements(qa_ss_const.production_line).value IS NOT NULL) THEN
739:
740: x_where_clause :=
733: --
734:
735: IF (qa_plan_element_api.element_in_plan(row_record.plan_id,
736: qa_ss_const.production_line) AND
737: row_elements.exists(qa_ss_const.production_line) AND
738: row_elements(qa_ss_const.production_line).value IS NOT NULL) THEN
739:
740: x_where_clause :=
741: 'inventory_item_id IN ' ||
734:
735: IF (qa_plan_element_api.element_in_plan(row_record.plan_id,
736: qa_ss_const.production_line) AND
737: row_elements.exists(qa_ss_const.production_line) AND
738: row_elements(qa_ss_const.production_line).value IS NOT NULL) THEN
739:
740: x_where_clause :=
741: 'inventory_item_id IN ' ||
742: '((SELECT primary_item_id ' ||
742: '((SELECT primary_item_id ' ||
743: 'FROM wip_repetitive_items_v ' ||
744: 'WHERE organization_id = ' || g_org_id || ' AND ' ||
745: 'line_code = ''' ||
746: row_elements(qa_ss_const.production_line).value ||
747: ''') ' ||
748: 'UNION ALL ' ||
749: '(SELECT assembly_item_id '||
750: 'FROM bom_operational_routings_v '||
749: '(SELECT assembly_item_id '||
750: 'FROM bom_operational_routings_v '||
751: 'WHERE organization_id = ' || g_org_id || ' AND ' ||
752: 'line_code = ''' ||
753: row_elements(qa_ss_const.production_line).value ||
754: '''))';
755:
756: ELSE
757: x_where_clause := NULL;
1495:
1496: -- added the following to include new hardcoded element followup activity
1497: -- saugupta
1498:
1499: IF element_id IN (qa_ss_const.item, qa_ss_const.comp_item,
1500: qa_ss_const.asset_group, qa_ss_const.asset_activity, qa_ss_const.followup_activity) THEN
1501: g_item_id := row_elements(element_id).id;
1502: END IF;
1503:
1496: -- added the following to include new hardcoded element followup activity
1497: -- saugupta
1498:
1499: IF element_id IN (qa_ss_const.item, qa_ss_const.comp_item,
1500: qa_ss_const.asset_group, qa_ss_const.asset_activity, qa_ss_const.followup_activity) THEN
1501: g_item_id := row_elements(element_id).id;
1502: END IF;
1503:
1504: ELSIF (element_id = qa_ss_const.item) THEN
1500: qa_ss_const.asset_group, qa_ss_const.asset_activity, qa_ss_const.followup_activity) THEN
1501: g_item_id := row_elements(element_id).id;
1502: END IF;
1503:
1504: ELSIF (element_id = qa_ss_const.item) THEN
1505: error_code := validate_kf_item(row_elements, row_record, element_id,
1506: value, result_holder);
1507:
1508: ELSIF (element_id = qa_ss_const.comp_item) THEN
1504: ELSIF (element_id = qa_ss_const.item) THEN
1505: error_code := validate_kf_item(row_elements, row_record, element_id,
1506: value, result_holder);
1507:
1508: ELSIF (element_id = qa_ss_const.comp_item) THEN
1509: error_code := validate_kf_comp_item(row_elements, row_record,
1510: element_id, value, result_holder);
1511:
1512: ELSIF (element_id = qa_ss_const.locator) THEN
1508: ELSIF (element_id = qa_ss_const.comp_item) THEN
1509: error_code := validate_kf_comp_item(row_elements, row_record,
1510: element_id, value, result_holder);
1511:
1512: ELSIF (element_id = qa_ss_const.locator) THEN
1513: error_code := validate_kf_locator(row_elements, row_record, element_id,
1514: value, result_holder);
1515:
1516: ELSIF (element_id = qa_ss_const.comp_locator) THEN
1512: ELSIF (element_id = qa_ss_const.locator) THEN
1513: error_code := validate_kf_locator(row_elements, row_record, element_id,
1514: value, result_holder);
1515:
1516: ELSIF (element_id = qa_ss_const.comp_locator) THEN
1517: error_code := validate_kf_comp_locator(row_elements, row_record,
1518: element_id, value, result_holder);
1519:
1520: -- Bug 5248191. Modified check for Asset Group to call new function
1518: element_id, value, result_holder);
1519:
1520: -- Bug 5248191. Modified check for Asset Group to call new function
1521: -- saugupta Wed, 02 Aug 2006 01:44:07 -0700 PDT
1522: ELSIF (element_id = qa_ss_const.asset_group) THEN
1523: error_code := validate_kf_asset_group(row_elements, row_record,
1524: element_id, value, result_holder);
1525:
1526: ELSIF (element_id = qa_ss_const.asset_activity) THEN
1522: ELSIF (element_id = qa_ss_const.asset_group) THEN
1523: error_code := validate_kf_asset_group(row_elements, row_record,
1524: element_id, value, result_holder);
1525:
1526: ELSIF (element_id = qa_ss_const.asset_activity) THEN
1527: error_code := validate_kf_item(row_elements, row_record,
1528: element_id, value, result_holder);
1529:
1530: -- added the following to include new hardcoded element followup activity
1529:
1530: -- added the following to include new hardcoded element followup activity
1531: -- saugupta
1532:
1533: ELSIF (element_id = qa_ss_const.followup_activity) THEN
1534: error_code := validate_kf_item(row_elements, row_record,
1535: element_id, value, result_holder);
1536:
1537:
1538: -- Added the following for NCM Hardcode Elements.
1539: -- suramasw Thu Oct 31 10:48:59 PST 2002.
1540: -- Bug 2449067.
1541:
1542: ELSIF (element_id = qa_ss_const.bill_reference) THEN
1543: error_code := validate_kf_bill_reference(row_elements, row_record,
1544: element_id, value, result_holder);
1545:
1546: ELSIF (element_id = qa_ss_const.routing_reference) THEN
1542: ELSIF (element_id = qa_ss_const.bill_reference) THEN
1543: error_code := validate_kf_bill_reference(row_elements, row_record,
1544: element_id, value, result_holder);
1545:
1546: ELSIF (element_id = qa_ss_const.routing_reference) THEN
1547: error_code := validate_kf_routing_reference(row_elements, row_record,
1548: element_id, value, result_holder);
1549:
1550: ELSIF (element_id = qa_ss_const.to_locator) THEN
1546: ELSIF (element_id = qa_ss_const.routing_reference) THEN
1547: error_code := validate_kf_routing_reference(row_elements, row_record,
1548: element_id, value, result_holder);
1549:
1550: ELSIF (element_id = qa_ss_const.to_locator) THEN
1551: error_code := validate_kf_to_locator(row_elements, row_record,
1552: element_id, value, result_holder);
1553:
1554: -- End of inclusions for NCM Hardcode Elements.
1577: id NUMBER;
1578:
1579: BEGIN
1580:
1581: IF (element_id = qa_ss_const.department)
1582: OR (element_id = qa_ss_const.to_department) THEN
1583: id := qa_plan_element_api.get_department_id(x_org_id, value);
1584:
1585: ELSIF (element_id = qa_ss_const.job_name) THEN
1578:
1579: BEGIN
1580:
1581: IF (element_id = qa_ss_const.department)
1582: OR (element_id = qa_ss_const.to_department) THEN
1583: id := qa_plan_element_api.get_department_id(x_org_id, value);
1584:
1585: ELSIF (element_id = qa_ss_const.job_name) THEN
1586: id := qa_plan_element_api.get_job_id(x_org_id, value);
1581: IF (element_id = qa_ss_const.department)
1582: OR (element_id = qa_ss_const.to_department) THEN
1583: id := qa_plan_element_api.get_department_id(x_org_id, value);
1584:
1585: ELSIF (element_id = qa_ss_const.job_name) THEN
1586: id := qa_plan_element_api.get_job_id(x_org_id, value);
1587:
1588: ELSIF (element_id = qa_ss_const.production_line) THEN
1589: id := qa_plan_element_api.get_production_line_id(x_org_id, value);
1584:
1585: ELSIF (element_id = qa_ss_const.job_name) THEN
1586: id := qa_plan_element_api.get_job_id(x_org_id, value);
1587:
1588: ELSIF (element_id = qa_ss_const.production_line) THEN
1589: id := qa_plan_element_api.get_production_line_id(x_org_id, value);
1590:
1591: ELSIF (element_id = qa_ss_const.resource_code) THEN
1592: id := qa_plan_element_api.get_resource_code_id(x_org_id, value);
1587:
1588: ELSIF (element_id = qa_ss_const.production_line) THEN
1589: id := qa_plan_element_api.get_production_line_id(x_org_id, value);
1590:
1591: ELSIF (element_id = qa_ss_const.resource_code) THEN
1592: id := qa_plan_element_api.get_resource_code_id(x_org_id, value);
1593:
1594: ELSIF (element_id = qa_ss_const.vendor_name) THEN
1595: id := qa_plan_element_api.get_supplier_id(value);
1590:
1591: ELSIF (element_id = qa_ss_const.resource_code) THEN
1592: id := qa_plan_element_api.get_resource_code_id(x_org_id, value);
1593:
1594: ELSIF (element_id = qa_ss_const.vendor_name) THEN
1595: id := qa_plan_element_api.get_supplier_id(value);
1596:
1597: ELSIF (element_id = qa_ss_const.po_number) THEN
1598: id := qa_plan_element_api.get_po_number_id(value);
1593:
1594: ELSIF (element_id = qa_ss_const.vendor_name) THEN
1595: id := qa_plan_element_api.get_supplier_id(value);
1596:
1597: ELSIF (element_id = qa_ss_const.po_number) THEN
1598: id := qa_plan_element_api.get_po_number_id(value);
1599:
1600: ELSIF (element_id = qa_ss_const.customer_name) THEN
1601: id := qa_plan_element_api.get_customer_id(value);
1596:
1597: ELSIF (element_id = qa_ss_const.po_number) THEN
1598: id := qa_plan_element_api.get_po_number_id(value);
1599:
1600: ELSIF (element_id = qa_ss_const.customer_name) THEN
1601: id := qa_plan_element_api.get_customer_id(value);
1602:
1603: ELSIF (element_id = qa_ss_const.sales_order) THEN
1604: id := qa_plan_element_api.get_so_number_id(value);
1599:
1600: ELSIF (element_id = qa_ss_const.customer_name) THEN
1601: id := qa_plan_element_api.get_customer_id(value);
1602:
1603: ELSIF (element_id = qa_ss_const.sales_order) THEN
1604: id := qa_plan_element_api.get_so_number_id(value);
1605:
1606: ELSIF (element_id = qa_ss_const.order_line) THEN
1607: id := qa_plan_element_api.get_so_line_number_id(value);
1602:
1603: ELSIF (element_id = qa_ss_const.sales_order) THEN
1604: id := qa_plan_element_api.get_so_number_id(value);
1605:
1606: ELSIF (element_id = qa_ss_const.order_line) THEN
1607: id := qa_plan_element_api.get_so_line_number_id(value);
1608:
1609: ELSIF (element_id = qa_ss_const.po_release_num) THEN
1610: id := qa_plan_element_api.get_po_release_number_id(value,
1605:
1606: ELSIF (element_id = qa_ss_const.order_line) THEN
1607: id := qa_plan_element_api.get_so_line_number_id(value);
1608:
1609: ELSIF (element_id = qa_ss_const.po_release_num) THEN
1610: id := qa_plan_element_api.get_po_release_number_id(value,
1611: g_po_header_id);
1612:
1613: ELSIF (element_id = qa_ss_const.project_number) THEN
1609: ELSIF (element_id = qa_ss_const.po_release_num) THEN
1610: id := qa_plan_element_api.get_po_release_number_id(value,
1611: g_po_header_id);
1612:
1613: ELSIF (element_id = qa_ss_const.project_number) THEN
1614: id := qa_plan_element_api.get_project_number_id(value);
1615: --
1616: -- Bug 2672396. Need to keep a cache of the returned project ID
1617: -- bso Mon Nov 25 17:29:56 PST 2002
1617: -- bso Mon Nov 25 17:29:56 PST 2002
1618: --
1619: g_project_id := id;
1620:
1621: ELSIF (element_id = qa_ss_const.task_number) THEN
1622: --
1623: -- Bug 2672396. Added g_project_id because task is a dependent element.
1624: -- bso Mon Nov 25 17:29:56 PST 2002
1625: --
1624: -- bso Mon Nov 25 17:29:56 PST 2002
1625: --
1626: id := qa_plan_element_api.get_task_number_id(value, g_project_id);
1627:
1628: ELSIF (element_id = qa_ss_const.rma_number) THEN
1629: id := qa_plan_element_api.get_rma_number_id(value);
1630:
1631: ELSIF (element_id = qa_ss_const.license_plate_number) THEN
1632: id := qa_plan_element_api.get_lpn_id(value);
1627:
1628: ELSIF (element_id = qa_ss_const.rma_number) THEN
1629: id := qa_plan_element_api.get_rma_number_id(value);
1630:
1631: ELSIF (element_id = qa_ss_const.license_plate_number) THEN
1632: id := qa_plan_element_api.get_lpn_id(value);
1633:
1634: -- added the following to include new hardcoded element Transfer license plate number
1635: -- saugupta
1633:
1634: -- added the following to include new hardcoded element Transfer license plate number
1635: -- saugupta
1636:
1637: ELSIF (element_id = qa_ss_const.xfr_license_plate_number) THEN
1638: id := qa_plan_element_api.get_xfr_lpn_id(value);
1639:
1640:
1641: ELSIF (element_id = qa_ss_const.contract_number) THEN
1637: ELSIF (element_id = qa_ss_const.xfr_license_plate_number) THEN
1638: id := qa_plan_element_api.get_xfr_lpn_id(value);
1639:
1640:
1641: ELSIF (element_id = qa_ss_const.contract_number) THEN
1642: id := qa_plan_element_api.get_contract_id(value);
1643:
1644: ELSIF (element_id = qa_ss_const.contract_line_number) THEN
1645: id := qa_plan_element_api.get_contract_line_id(value);
1640:
1641: ELSIF (element_id = qa_ss_const.contract_number) THEN
1642: id := qa_plan_element_api.get_contract_id(value);
1643:
1644: ELSIF (element_id = qa_ss_const.contract_line_number) THEN
1645: id := qa_plan_element_api.get_contract_line_id(value);
1646:
1647: ELSIF (element_id = qa_ss_const.deliverable_number) THEN
1648: id := qa_plan_element_api.get_deliverable_id(value);
1643:
1644: ELSIF (element_id = qa_ss_const.contract_line_number) THEN
1645: id := qa_plan_element_api.get_contract_line_id(value);
1646:
1647: ELSIF (element_id = qa_ss_const.deliverable_number) THEN
1648: id := qa_plan_element_api.get_deliverable_id(value);
1649:
1650: ELSIF (element_id = qa_ss_const.work_order) THEN
1651: id := qa_plan_element_api.get_work_order_id(x_org_id, value);
1646:
1647: ELSIF (element_id = qa_ss_const.deliverable_number) THEN
1648: id := qa_plan_element_api.get_deliverable_id(value);
1649:
1650: ELSIF (element_id = qa_ss_const.work_order) THEN
1651: id := qa_plan_element_api.get_work_order_id(x_org_id, value);
1652:
1653: --dgupta: Start R12 EAM Integration. Bug 4345492
1654: ELSIF (element_id = qa_ss_const.asset_instance_number) THEN
1650: ELSIF (element_id = qa_ss_const.work_order) THEN
1651: id := qa_plan_element_api.get_work_order_id(x_org_id, value);
1652:
1653: --dgupta: Start R12 EAM Integration. Bug 4345492
1654: ELSIF (element_id = qa_ss_const.asset_instance_number) THEN
1655: id := qa_plan_element_api.get_asset_instance_id(value);
1656: --dgupta: End R12 EAM Integration. Bug 4345492
1657:
1658: ELSIF (element_id = qa_ss_const.party_name) THEN
1654: ELSIF (element_id = qa_ss_const.asset_instance_number) THEN
1655: id := qa_plan_element_api.get_asset_instance_id(value);
1656: --dgupta: End R12 EAM Integration. Bug 4345492
1657:
1658: ELSIF (element_id = qa_ss_const.party_name) THEN
1659: id := qa_plan_element_api.get_party_id(value);
1660:
1661: ELSIF (element_id = qa_ss_const.item_instance) THEN
1662: id := qa_plan_element_api.get_item_instance_id(value);
1657:
1658: ELSIF (element_id = qa_ss_const.party_name) THEN
1659: id := qa_plan_element_api.get_party_id(value);
1660:
1661: ELSIF (element_id = qa_ss_const.item_instance) THEN
1662: id := qa_plan_element_api.get_item_instance_id(value);
1663:
1664: ELSIF (element_id = qa_ss_const.service_request) THEN
1665: id := qa_plan_element_api.get_service_request_id(value);
1660:
1661: ELSIF (element_id = qa_ss_const.item_instance) THEN
1662: id := qa_plan_element_api.get_item_instance_id(value);
1663:
1664: ELSIF (element_id = qa_ss_const.service_request) THEN
1665: id := qa_plan_element_api.get_service_request_id(value);
1666:
1667: ELSIF (element_id = qa_ss_const.maintenance_requirement) THEN
1668: id := qa_plan_element_api.get_maintenance_req_id(value);
1663:
1664: ELSIF (element_id = qa_ss_const.service_request) THEN
1665: id := qa_plan_element_api.get_service_request_id(value);
1666:
1667: ELSIF (element_id = qa_ss_const.maintenance_requirement) THEN
1668: id := qa_plan_element_api.get_maintenance_req_id(value);
1669:
1670: ELSIF (element_id = qa_ss_const.rework_job) THEN
1671: id := qa_plan_element_api.get_rework_job_id(x_org_id, value);
1666:
1667: ELSIF (element_id = qa_ss_const.maintenance_requirement) THEN
1668: id := qa_plan_element_api.get_maintenance_req_id(value);
1669:
1670: ELSIF (element_id = qa_ss_const.rework_job) THEN
1671: id := qa_plan_element_api.get_rework_job_id(x_org_id, value);
1672:
1673: ELSIF (element_id = qa_ss_const.counter_name) THEN
1674: id := qa_plan_element_api.get_counter_name_id(value);
1669:
1670: ELSIF (element_id = qa_ss_const.rework_job) THEN
1671: id := qa_plan_element_api.get_rework_job_id(x_org_id, value);
1672:
1673: ELSIF (element_id = qa_ss_const.counter_name) THEN
1674: id := qa_plan_element_api.get_counter_name_id(value);
1675:
1676: -- Added the following for NCM Hardcode Elements.
1677: -- suramasw Thu Oct 31 10:48:59 PST 2002.
1676: -- Added the following for NCM Hardcode Elements.
1677: -- suramasw Thu Oct 31 10:48:59 PST 2002.
1678: -- Bug 2449067.
1679:
1680: ELSIF (element_id = qa_ss_const.lot_status) THEN
1681: id := qa_plan_element_api.get_lot_status_id(value);
1682:
1683: ELSIF (element_id = qa_ss_const.serial_status) THEN
1684: id := qa_plan_element_api.get_serial_status_id(value);
1679:
1680: ELSIF (element_id = qa_ss_const.lot_status) THEN
1681: id := qa_plan_element_api.get_lot_status_id(value);
1682:
1683: ELSIF (element_id = qa_ss_const.serial_status) THEN
1684: id := qa_plan_element_api.get_serial_status_id(value);
1685:
1686: -- End of inclusions for NCM Hardcode Elements.
1687:
1685:
1686: -- End of inclusions for NCM Hardcode Elements.
1687:
1688: -- R12 OPM Deviations. Bug 4345503 Start
1689: ELSIF (element_id = qa_ss_const.process_batch_num) THEN
1690: id := qa_plan_element_api.get_process_batch_id(value, x_org_id);
1691: g_process_batch_id := id;
1692:
1693: ELSIF (element_id = qa_ss_const.process_batchstep_num) THEN
1689: ELSIF (element_id = qa_ss_const.process_batch_num) THEN
1690: id := qa_plan_element_api.get_process_batch_id(value, x_org_id);
1691: g_process_batch_id := id;
1692:
1693: ELSIF (element_id = qa_ss_const.process_batchstep_num) THEN
1694: id := qa_plan_element_api.get_process_batchstep_id
1695: (value,g_process_batch_id);
1696: g_process_batchstep_id := id;
1697:
1694: id := qa_plan_element_api.get_process_batchstep_id
1695: (value,g_process_batch_id);
1696: g_process_batchstep_id := id;
1697:
1698: ELSIF (element_id = qa_ss_const.process_operation) THEN
1699: id := qa_plan_element_api.get_process_operation_id
1700: (value,g_process_batch_id,g_process_batchstep_id);
1701:
1702: ELSIF (element_id = qa_ss_const.process_activity) THEN
1698: ELSIF (element_id = qa_ss_const.process_operation) THEN
1699: id := qa_plan_element_api.get_process_operation_id
1700: (value,g_process_batch_id,g_process_batchstep_id);
1701:
1702: ELSIF (element_id = qa_ss_const.process_activity) THEN
1703: id := qa_plan_element_api.get_process_activity_id
1704: (value,g_process_batch_id,g_process_batchstep_id);
1705: g_process_activity_id := id;
1706:
1703: id := qa_plan_element_api.get_process_activity_id
1704: (value,g_process_batch_id,g_process_batchstep_id);
1705: g_process_activity_id := id;
1706:
1707: ELSIF (element_id = qa_ss_const.process_resource) THEN
1708: id := qa_plan_element_api.get_process_resource_id
1709: (value,g_process_batch_id,
1710: g_process_batchstep_id, g_process_activity_id);
1711: g_process_resource_id := id;
1708: id := qa_plan_element_api.get_process_resource_id
1709: (value,g_process_batch_id,
1710: g_process_batchstep_id, g_process_activity_id);
1711: g_process_resource_id := id;
1712: ELSIF (element_id = qa_ss_const.process_parameter) THEN
1713: id := qa_plan_element_api.get_process_parameter_id
1714: (value,g_process_resource_id);
1715:
1716: -- R12 OPM Deviations. Bug 4345503 End
1714: (value,g_process_resource_id);
1715:
1716: -- R12 OPM Deviations. Bug 4345503 End
1717: --R12 DR Integration . Bug 4345489 start
1718: ELSIF (element_id = qa_ss_const.repair_order_number) THEN
1719: id := qa_plan_element_api.get_repair_line_id
1720: (value);
1721: ELSIF (element_id = qa_ss_const.jtf_task_number) THEN
1722: id := qa_plan_element_api.get_jtf_task_id(value);
1717: --R12 DR Integration . Bug 4345489 start
1718: ELSIF (element_id = qa_ss_const.repair_order_number) THEN
1719: id := qa_plan_element_api.get_repair_line_id
1720: (value);
1721: ELSIF (element_id = qa_ss_const.jtf_task_number) THEN
1722: id := qa_plan_element_api.get_jtf_task_id(value);
1723: --R12 Dr Integration. Bug 4345489 end
1724: END IF;
1725:
1769: -- to be used along with Maintenance Workorder
1770: -- rkunchal Mon Sep 23 23:46:28 PDT 2002
1771: -- Added to the IF ladder for Maintenance Workorder
1772: --
1773: IF (element_id = qa_ss_const.job_name) THEN
1774: g_wip_entity_id := id;
1775: ELSIF (element_id = qa_ss_const.po_number) THEN
1776: g_po_header_id := id;
1777: ELSIF (element_id = qa_ss_const.production_line) THEN
1771: -- Added to the IF ladder for Maintenance Workorder
1772: --
1773: IF (element_id = qa_ss_const.job_name) THEN
1774: g_wip_entity_id := id;
1775: ELSIF (element_id = qa_ss_const.po_number) THEN
1776: g_po_header_id := id;
1777: ELSIF (element_id = qa_ss_const.production_line) THEN
1778: g_line_id := id;
1779: ELSIF (element_id = qa_ss_const.work_order) THEN
1773: IF (element_id = qa_ss_const.job_name) THEN
1774: g_wip_entity_id := id;
1775: ELSIF (element_id = qa_ss_const.po_number) THEN
1776: g_po_header_id := id;
1777: ELSIF (element_id = qa_ss_const.production_line) THEN
1778: g_line_id := id;
1779: ELSIF (element_id = qa_ss_const.work_order) THEN
1780: g_work_order_id := id;
1781: END IF;
1775: ELSIF (element_id = qa_ss_const.po_number) THEN
1776: g_po_header_id := id;
1777: ELSIF (element_id = qa_ss_const.production_line) THEN
1778: g_line_id := id;
1779: ELSIF (element_id = qa_ss_const.work_order) THEN
1780: g_work_order_id := id;
1781: END IF;
1782:
1783:
1799: BEGIN
1800:
1801: -- Transaction Date is validated only in PO Inspection Transaction
1802:
1803: IF (element_id = qa_ss_const.transaction_date) THEN
1804: result := qa_plan_element_api.validate_transaction_date(
1805: g_transaction_number);
1806:
1807: ELSIF (element_id = qa_ss_const.uom)
1803: IF (element_id = qa_ss_const.transaction_date) THEN
1804: result := qa_plan_element_api.validate_transaction_date(
1805: g_transaction_number);
1806:
1807: ELSIF (element_id = qa_ss_const.uom)
1808: OR (element_id = qa_ss_const.comp_uom) THEN
1809: result := qa_plan_element_api.validate_uom(
1810: x_org_id, g_item_id, x_value);
1811:
1804: result := qa_plan_element_api.validate_transaction_date(
1805: g_transaction_number);
1806:
1807: ELSIF (element_id = qa_ss_const.uom)
1808: OR (element_id = qa_ss_const.comp_uom) THEN
1809: result := qa_plan_element_api.validate_uom(
1810: x_org_id, g_item_id, x_value);
1811:
1812: ELSIF (element_id = qa_ss_const.revision)
1808: OR (element_id = qa_ss_const.comp_uom) THEN
1809: result := qa_plan_element_api.validate_uom(
1810: x_org_id, g_item_id, x_value);
1811:
1812: ELSIF (element_id = qa_ss_const.revision)
1813: OR (element_id = qa_ss_const.comp_revision) THEN
1814: result := qa_plan_element_api.validate_revision(
1815: x_org_id, g_item_id, x_value);
1816:
1809: result := qa_plan_element_api.validate_uom(
1810: x_org_id, g_item_id, x_value);
1811:
1812: ELSIF (element_id = qa_ss_const.revision)
1813: OR (element_id = qa_ss_const.comp_revision) THEN
1814: result := qa_plan_element_api.validate_revision(
1815: x_org_id, g_item_id, x_value);
1816:
1817: ELSIF (element_id = qa_ss_const.subinventory)
1813: OR (element_id = qa_ss_const.comp_revision) THEN
1814: result := qa_plan_element_api.validate_revision(
1815: x_org_id, g_item_id, x_value);
1816:
1817: ELSIF (element_id = qa_ss_const.subinventory)
1818: OR (element_id = qa_ss_const.comp_subinventory) THEN
1819: result := qa_plan_element_api.validate_subinventory(
1820: x_org_id, x_value);
1821:
1814: result := qa_plan_element_api.validate_revision(
1815: x_org_id, g_item_id, x_value);
1816:
1817: ELSIF (element_id = qa_ss_const.subinventory)
1818: OR (element_id = qa_ss_const.comp_subinventory) THEN
1819: result := qa_plan_element_api.validate_subinventory(
1820: x_org_id, x_value);
1821:
1822: -- Bug 4558205. OA Framewok Integration UT bug fix.
1823: -- Lot and serial numbers are not validated in server
1824: -- side for stand alone QWB.
1825: -- srhariha. Tue Sep 27 03:14:23 PDT 2005.
1826:
1827: ELSIF (element_id = qa_ss_const.lot_number) THEN
1828: IF(g_transaction_number is null) OR (g_transaction_number = -1) THEN
1829: result := qa_plan_element_api.validate_lot_num(x_org_id,
1830: g_item_id ,
1831: x_value);
1834: g_transaction_id,
1835: x_value);
1836: END IF;
1837:
1838: ELSIF (element_id = qa_ss_const.serial_number) THEN
1839:
1840: IF(g_transaction_number is null) OR (g_transaction_number = -1) THEN
1841:
1842: result := qa_plan_element_api.validate_serial_num(x_org_id,
1852: END IF;
1853:
1854: -- End. Bug 4558205.
1855:
1856: ELSIF (element_id = qa_ss_const.to_op_seq_num)
1857: OR (element_id = qa_ss_const.from_op_seq_num) THEN
1858: result := qa_plan_element_api.validate_op_seq_number(
1859: x_org_id, g_line_id,
1860: g_wip_entity_id, x_value);
1853:
1854: -- End. Bug 4558205.
1855:
1856: ELSIF (element_id = qa_ss_const.to_op_seq_num)
1857: OR (element_id = qa_ss_const.from_op_seq_num) THEN
1858: result := qa_plan_element_api.validate_op_seq_number(
1859: x_org_id, g_line_id,
1860: g_wip_entity_id, x_value);
1861:
1865: -- to be used along with Maintenance Workorder
1866: -- rkunchal Mon Sep 23 23:46:28 PDT 2002
1867: --
1868:
1869: ELSIF (element_id = qa_ss_const.maintenance_op_seq) THEN
1870: result := qa_plan_element_api.validate_maintenance_op_seq(
1871: x_org_id, g_work_order_id, x_value);
1872: --
1873: -- End of inclusions for Bug 2588213
1873: -- End of inclusions for Bug 2588213
1874: --
1875:
1876:
1877: ELSIF (element_id = qa_ss_const.po_line_num) THEN
1878:
1879: g_po_line_number := x_value;
1880: result := qa_plan_element_api.validate_po_line_number(
1881: g_po_header_id, x_value);
1879: g_po_line_number := x_value;
1880: result := qa_plan_element_api.validate_po_line_number(
1881: g_po_header_id, x_value);
1882:
1883: ELSIF (element_id = qa_ss_const.po_shipment_num) THEN
1884: result := qa_plan_element_api.validate_po_shipments(
1885: g_po_line_number,
1886: g_po_header_id, x_value);
1887:
1884: result := qa_plan_element_api.validate_po_shipments(
1885: g_po_line_number,
1886: g_po_header_id, x_value);
1887:
1888: ELSIF (element_id = qa_ss_const.receipt_num) THEN
1889: result := qa_plan_element_api.validate_receipt_number(x_value);
1890:
1891: /*
1892: ELSIF (element_id = qa_ss_const.comp_serial_number) THEN
1888: ELSIF (element_id = qa_ss_const.receipt_num) THEN
1889: result := qa_plan_element_api.validate_receipt_number(x_value);
1890:
1891: /*
1892: ELSIF (element_id = qa_ss_const.comp_serial_number) THEN
1893: result := TRUE;
1894:
1895: ELSIF (element_id = qa_ss_const.comp_lot_number) THEN
1896: result := TRUE;
1891: /*
1892: ELSIF (element_id = qa_ss_const.comp_serial_number) THEN
1893: result := TRUE;
1894:
1895: ELSIF (element_id = qa_ss_const.comp_lot_number) THEN
1896: result := TRUE;
1897:
1898: ELSIF (element_id = qa_ss_const.quantity) THEN
1899: result := TRUE;
1894:
1895: ELSIF (element_id = qa_ss_const.comp_lot_number) THEN
1896: result := TRUE;
1897:
1898: ELSIF (element_id = qa_ss_const.quantity) THEN
1899: result := TRUE;
1900:
1901: ELSIF (element_id = qa_ss_const.asset_number) THEN
1902: result := TRUE;
1897:
1898: ELSIF (element_id = qa_ss_const.quantity) THEN
1899: result := TRUE;
1900:
1901: ELSIF (element_id = qa_ss_const.asset_number) THEN
1902: result := TRUE;
1903: */
1904: -- Added the following for NCM Hardcode Elements.
1905: -- suramasw Thu Oct 31 10:48:59 PST 2002.
1904: -- Added the following for NCM Hardcode Elements.
1905: -- suramasw Thu Oct 31 10:48:59 PST 2002.
1906: -- Bug 2449067.
1907:
1908: ELSIF (element_id = qa_ss_const.to_subinventory) THEN
1909: result := qa_plan_element_api.validate_to_subinventory(
1910: x_org_id, x_value);
1911:
1912: /*
1909: result := qa_plan_element_api.validate_to_subinventory(
1910: x_org_id, x_value);
1911:
1912: /*
1913: ELSIF (element_id = qa_ss_const.lot_status) THEN
1914: result := qa_plan_element_api.validate_lot_status(x_value);
1915:
1916: ELSIF (element_id = qa_ss_const.concurrent_request_id) THEN
1917: result := TRUE;
1912: /*
1913: ELSIF (element_id = qa_ss_const.lot_status) THEN
1914: result := qa_plan_element_api.validate_lot_status(x_value);
1915:
1916: ELSIF (element_id = qa_ss_const.concurrent_request_id) THEN
1917: result := TRUE;
1918:
1919: ELSIF (element_id = qa_ss_const.nonconformance_code) THEN
1920: result := TRUE;
1915:
1916: ELSIF (element_id = qa_ss_const.concurrent_request_id) THEN
1917: result := TRUE;
1918:
1919: ELSIF (element_id = qa_ss_const.nonconformance_code) THEN
1920: result := TRUE;
1921:
1922: ELSIF (element_id = qa_ss_const.date_opened) THEN
1923: result := TRUE;
1918:
1919: ELSIF (element_id = qa_ss_const.nonconformance_code) THEN
1920: result := TRUE;
1921:
1922: ELSIF (element_id = qa_ss_const.date_opened) THEN
1923: result := TRUE;
1924:
1925: ELSIF (element_id = qa_ss_const.date_closed) THEN
1926: result := TRUE;
1921:
1922: ELSIF (element_id = qa_ss_const.date_opened) THEN
1923: result := TRUE;
1924:
1925: ELSIF (element_id = qa_ss_const.date_closed) THEN
1926: result := TRUE;
1927:
1928: ELSIF (element_id = qa_ss_const.days_to_close) THEN
1929: result := TRUE;
1924:
1925: ELSIF (element_id = qa_ss_const.date_closed) THEN
1926: result := TRUE;
1927:
1928: ELSIF (element_id = qa_ss_const.days_to_close) THEN
1929: result := TRUE;
1930: */
1931: -- the above code and the code above to_subinventory procedure was commented
1932: -- out to directly put an else clause which validates to TRUE since there is no
1991: PROCEDURE copy_primitive_to_global(p_element_id IN NUMBER, p_value IN VARCHAR2) IS
1992:
1993: BEGIN
1994:
1995: IF (p_element_id = qa_ss_const.subinventory) THEN
1996: g_subinventory := p_value;
1997:
1998: ELSIF (p_element_id = qa_ss_const.lot_number) THEN
1999: g_lot_number := p_value;
1994:
1995: IF (p_element_id = qa_ss_const.subinventory) THEN
1996: g_subinventory := p_value;
1997:
1998: ELSIF (p_element_id = qa_ss_const.lot_number) THEN
1999: g_lot_number := p_value;
2000:
2001: -- Added the following condition to enable History Records
2002: -- to be created when History Relationship is present.
2001: -- Added the following condition to enable History Records
2002: -- to be created when History Relationship is present.
2003: -- Bug 2700230.suramasw Mon Dec 23 03:06:30 PST 2002.
2004:
2005: ELSIF (p_element_id = qa_ss_const.to_subinventory) THEN
2006: g_to_subinventory := p_value;
2007:
2008: -- Bug 4558205. OA Framewok Integration UT bug fix.
2009: -- Lot and serial numbers are not validated in server
2010: -- side for stand alone QWB. Adding revision for serial
2011: -- number validation.
2012: -- srhariha. Tue Sep 27 03:14:23 PDT 2005.
2013:
2014: ELSIF (p_element_id = qa_ss_const.revision) THEN
2015: g_revision := p_value;
2016: --
2017: -- Bug 6126260
2018: -- Added the extra condition to assign the value of the
2019: -- component subinventory to the global variable which
2020: -- would later be used to validate the comp subinventory locator.
2021: -- bhsankar Thu Jan 4 20:58:23 PST 2007
2022: --
2023: ELSIF (p_element_id = qa_ss_const.comp_subinventory) THEN
2024: g_comp_subinventory := p_value;
2025:
2026: END IF;
2027:
2051: END IF;
2052:
2053: /*
2054: IF element_id IN (
2055: qa_ss_const.disposition,
2056: qa_ss_const.disposition_action,
2057: qa_ss_const.disposition_source,
2058: qa_ss_const.disposition_status,
2059: qa_ss_const.nonconformance_source,
2052:
2053: /*
2054: IF element_id IN (
2055: qa_ss_const.disposition,
2056: qa_ss_const.disposition_action,
2057: qa_ss_const.disposition_source,
2058: qa_ss_const.disposition_status,
2059: qa_ss_const.nonconformance_source,
2060: qa_ss_const.nonconform_severity,
2053: /*
2054: IF element_id IN (
2055: qa_ss_const.disposition,
2056: qa_ss_const.disposition_action,
2057: qa_ss_const.disposition_source,
2058: qa_ss_const.disposition_status,
2059: qa_ss_const.nonconformance_source,
2060: qa_ss_const.nonconform_severity,
2061: qa_ss_const.nonconform_priority,
2054: IF element_id IN (
2055: qa_ss_const.disposition,
2056: qa_ss_const.disposition_action,
2057: qa_ss_const.disposition_source,
2058: qa_ss_const.disposition_status,
2059: qa_ss_const.nonconformance_source,
2060: qa_ss_const.nonconform_severity,
2061: qa_ss_const.nonconform_priority,
2062: qa_ss_const.nonconformance_type,
2055: qa_ss_const.disposition,
2056: qa_ss_const.disposition_action,
2057: qa_ss_const.disposition_source,
2058: qa_ss_const.disposition_status,
2059: qa_ss_const.nonconformance_source,
2060: qa_ss_const.nonconform_severity,
2061: qa_ss_const.nonconform_priority,
2062: qa_ss_const.nonconformance_type,
2063: qa_ss_const.nonconformance_status) THEN
2056: qa_ss_const.disposition_action,
2057: qa_ss_const.disposition_source,
2058: qa_ss_const.disposition_status,
2059: qa_ss_const.nonconformance_source,
2060: qa_ss_const.nonconform_severity,
2061: qa_ss_const.nonconform_priority,
2062: qa_ss_const.nonconformance_type,
2063: qa_ss_const.nonconformance_status) THEN
2064:
2057: qa_ss_const.disposition_source,
2058: qa_ss_const.disposition_status,
2059: qa_ss_const.nonconformance_source,
2060: qa_ss_const.nonconform_severity,
2061: qa_ss_const.nonconform_priority,
2062: qa_ss_const.nonconformance_type,
2063: qa_ss_const.nonconformance_status) THEN
2064:
2065: RETURN validate_values(plan_id, element_id, value);
2058: qa_ss_const.disposition_status,
2059: qa_ss_const.nonconformance_source,
2060: qa_ss_const.nonconform_severity,
2061: qa_ss_const.nonconform_priority,
2062: qa_ss_const.nonconformance_type,
2063: qa_ss_const.nonconformance_status) THEN
2064:
2065: RETURN validate_values(plan_id, element_id, value);
2066: END IF;
2059: qa_ss_const.nonconformance_source,
2060: qa_ss_const.nonconform_severity,
2061: qa_ss_const.nonconform_priority,
2062: qa_ss_const.nonconformance_type,
2063: qa_ss_const.nonconformance_status) THEN
2064:
2065: RETURN validate_values(plan_id, element_id, value);
2066: END IF;
2067: */
2330:
2331: precision := nvl(qa_plan_element_api.decimal_precision(plan_id, element_id),
2332: qa_chars_api.decimal_precision(element_id));
2333:
2334: IF (data_type = qa_ss_const.date_datatype) THEN
2335: error_code := validate_date(value, result_holder);
2336:
2337: ELSIF (data_type = qa_ss_const.datetime_datatype) THEN
2338: val_len := length(value);
2333:
2334: IF (data_type = qa_ss_const.date_datatype) THEN
2335: error_code := validate_date(value, result_holder);
2336:
2337: ELSIF (data_type = qa_ss_const.datetime_datatype) THEN
2338: val_len := length(value);
2339: if substr(value, val_len - 1, 2) = '.0' then
2340: -- all hardcoded datetimes in self service come here.
2341: -- When coming from Self service, a '.0' is appended to the value
2355: -- real datatype of the element. If it is character than call validate_datetime
2356: -- else its hardcoded so calling validate_date.
2357: -- saugupta Wed, 14 Jan 2004 04:40:08 -0800 PDT
2358:
2359: IF (actual_datatype = qa_ss_const.character_datatype) THEN
2360: error_code := validate_datetime(value, result_holder);
2361:
2362: -- Bug 3318462. From ss and mobile softcoded datetime elements are
2363: -- in server timezone. Above call will throw and exception. Returned
2372: error_code := validate_date(value, result_holder);
2373: END IF;
2374: end if;
2375:
2376: ELSIF (data_type = qa_ss_const.number_datatype) THEN
2377: error_code := validate_number(value, len, precision,
2378: result_holder);
2379: --
2380: -- Bug 3402251. In order to use the round-up values in
2388:
2389: -- Bug 2427337. Added following elsif condition for longcomment datatype
2390: -- rponnusa Tue Jun 25 06:15:48 PDT 2002
2391:
2392: ELSIF (data_type = qa_ss_const.comment_datatype) THEN
2393: error_code := validate_comment(value, result_holder);
2394:
2395: ELSE
2396: error_code := validate_char(value, result_holder);
2682: -- Binding the value of the Global parameter Org Id set in the function
2683: -- validate_row
2684: -- ntungare Mon Oct 10 01:14:31 PDT 2005
2685: --
2686: IF INSTR(final_stmt, QA_SS_CONST.bindvar_param_org_id, 1)<> 0 THEN
2687: dbms_sql.bind_variable(c1, QA_SS_CONST.bindvar_param_org_id, g_org_id);
2688: END IF;
2689:
2690: --
2683: -- validate_row
2684: -- ntungare Mon Oct 10 01:14:31 PDT 2005
2685: --
2686: IF INSTR(final_stmt, QA_SS_CONST.bindvar_param_org_id, 1)<> 0 THEN
2687: dbms_sql.bind_variable(c1, QA_SS_CONST.bindvar_param_org_id, g_org_id);
2688: END IF;
2689:
2690: --
2691: -- Bug 4635316
2692: -- Binding the value of the Global parameter User Id set in the function
2693: -- validate_row
2694: -- ntungare Mon Oct 10 01:14:31 PDT 2005
2695: --
2696: IF INSTR(final_stmt, QA_SS_CONST.bindvar_param_user_id, 1) <> 0 THEN
2697: dbms_sql.bind_variable(c1, QA_SS_CONST.bindvar_param_user_id, g_user_id);
2698: END IF;
2699:
2700: --set up the type of the output we expect
2693: -- validate_row
2694: -- ntungare Mon Oct 10 01:14:31 PDT 2005
2695: --
2696: IF INSTR(final_stmt, QA_SS_CONST.bindvar_param_user_id, 1) <> 0 THEN
2697: dbms_sql.bind_variable(c1, QA_SS_CONST.bindvar_param_user_id, g_user_id);
2698: END IF;
2699:
2700: --set up the type of the output we expect
2701:
2839: -- If it is backward assignment then we must modify the
2840: -- return_results_array to indicate the change, but this value
2841: -- will NOT be validated.
2842:
2843: IF (action_id = qa_ss_const.display_message_action) THEN
2844:
2845: message_index := message_array.count;
2846: message_array(message_index).element_id := element_id;
2847: message_array(message_index).action_type :=
2844:
2845: message_index := message_array.count;
2846: message_array(message_index).element_id := element_id;
2847: message_array(message_index).action_type :=
2848: qa_ss_const.display_message_action;
2849: message_array(message_index).message := message;
2850:
2851: ELSIF (action_id = qa_ss_const.reject_input_action) THEN
2852:
2847: message_array(message_index).action_type :=
2848: qa_ss_const.display_message_action;
2849: message_array(message_index).message := message;
2850:
2851: ELSIF (action_id = qa_ss_const.reject_input_action) THEN
2852:
2853: message_index := message_array.count;
2854: message_array(message_index).element_id := element_id;
2855: message_array(message_index).action_type :=
2852:
2853: message_index := message_array.count;
2854: message_array(message_index).element_id := element_id;
2855: message_array(message_index).action_type :=
2856: qa_ss_const.reject_input_action;
2857: message_array(message_index).message := message;
2858:
2859: -- This can be used in self service, and if the action
2860: -- is fired, this will be consiidered an error. Therrfore,
2861: -- we should return reject_an_entry_error.
2862:
2863: RETURN reject_an_entry_error;
2864:
2865: ELSIF (action_id = qa_ss_const.assign_value_action) THEN
2866:
2867: target_element := qa_plan_element_api.get_target_element(
2868: plan_char_action_id);
2869:
2894: -- is then used in the subsequent calls.
2895: -- ntungare Sun Oct 16 20:36:17 PDT 2005
2896: --
2897: altered_message := QLTTRAFB.REPLACE_TOKEN(X_STRING => message,
2898: X_OLD_TOKEN => QA_SS_CONST.global_param_org_id ,
2899: X_NEW_TOKEN => QA_SS_CONST.bindvar_param_org_id);
2900:
2901: altered_message := QLTTRAFB.REPLACE_TOKEN(X_STRING => altered_message,
2902: X_OLD_TOKEN => QA_SS_CONST.global_param_user_id,
2895: -- ntungare Sun Oct 16 20:36:17 PDT 2005
2896: --
2897: altered_message := QLTTRAFB.REPLACE_TOKEN(X_STRING => message,
2898: X_OLD_TOKEN => QA_SS_CONST.global_param_org_id ,
2899: X_NEW_TOKEN => QA_SS_CONST.bindvar_param_org_id);
2900:
2901: altered_message := QLTTRAFB.REPLACE_TOKEN(X_STRING => altered_message,
2902: X_OLD_TOKEN => QA_SS_CONST.global_param_user_id,
2903: X_NEW_TOKEN => QA_SS_CONST.bindvar_param_user_id);
2898: X_OLD_TOKEN => QA_SS_CONST.global_param_org_id ,
2899: X_NEW_TOKEN => QA_SS_CONST.bindvar_param_org_id);
2900:
2901: altered_message := QLTTRAFB.REPLACE_TOKEN(X_STRING => altered_message,
2902: X_OLD_TOKEN => QA_SS_CONST.global_param_user_id,
2903: X_NEW_TOKEN => QA_SS_CONST.bindvar_param_user_id);
2904:
2905: assigned_value := get_assigned_value(plan_char_action_id, altered_message,
2906: row_elements);
2899: X_NEW_TOKEN => QA_SS_CONST.bindvar_param_org_id);
2900:
2901: altered_message := QLTTRAFB.REPLACE_TOKEN(X_STRING => altered_message,
2902: X_OLD_TOKEN => QA_SS_CONST.global_param_user_id,
2903: X_NEW_TOKEN => QA_SS_CONST.bindvar_param_user_id);
2904:
2905: assigned_value := get_assigned_value(plan_char_action_id, altered_message,
2906: row_elements);
2907:
2963: END IF;
2964:
2965: message_index := message_array.count;
2966: message_array(message_index).element_id := element_id;
2967: message_array(message_index).action_type := qa_ss_const.assign_value_action;
2968: assigned_element := qa_chars_api.prompt(target_element);
2969:
2970: -- bug 3178307. rkaza. 10/07/2003. Timezone Support.
2971: If qa_chars_api.datatype(target_element) = qa_ss_const.datetime_datatype then
2967: message_array(message_index).action_type := qa_ss_const.assign_value_action;
2968: assigned_element := qa_chars_api.prompt(target_element);
2969:
2970: -- bug 3178307. rkaza. 10/07/2003. Timezone Support.
2971: If qa_chars_api.datatype(target_element) = qa_ss_const.datetime_datatype then
2972: assigned_value :=
2973: fnd_date.date_to_displayDT(fnd_date.canonical_to_date(assigned_value));
2974: End if;
2975:
2981: --ilawler - bug #3340004 - Mon Feb 16 18:53:29 2004
2982: --According to bso, the message should always be
2983: /*
2984: message_array(message_index).message := assigned_value || ' Has Been Assigned To: ' || assigned_element || ' As Per The Assign A Value Action Of ' || trigger_element;
2985: IF (action_id <> qa_ss_const.assign_value_action) THEN
2986: startText := trigger_element || ': ' ;
2987: END IF;
2988:
2989: message_array(message_index).message := startText || assigned_element || ' = ' || replace(assigned_value,'@','@@');
3066:
3067: -- rkaza. bug 3248836. 11/11/2003. tz bug.
3068: datatype := qa_chars_api.datatype(element_id);
3069:
3070: IF (datatype = qa_ss_const.datetime_datatype) THEN
3071: val_len := length(value);
3072: if substr(value, val_len - 1, 2) = '.0' then
3073: -- Sometimes when coming from Self service, a '.0'
3074: -- is appended to the value
3317: -- Transaction type element was erroring out for WIP transactions.
3318: -- "Transaction Type" will be treated as one of a kind.
3319: -- srhariha.Tue Aug 2 00:43:07 PDT 2005.
3320:
3321: ELSIF element_id = qa_ss_const.transaction_type THEN
3322: error_list(4).error_code := validate_transaction_type(element_value,
3323: g_org_id,row_record.user_id);
3324:
3325: ELSIF qa_plan_element_api.values_exist(row_record.plan_id, element_id) THEN
3781: x_elements(i).validation_flag :=
3782: x_elements(i).validation_flag ||
3783: qa_validation_api.action_fired;
3784:
3785: IF i = qa_ss_const.transaction_type THEN
3786: x_elements(i).validation_flag :=
3787: x_elements(i).validation_flag ||
3788: qa_validation_api.valid_element;
3789: END IF;
3857:
3858: --
3859: -- Step 2. Set additional valid elements.
3860: --
3861: IF x_elements.EXISTS(qa_ss_const.lot_number) THEN
3862: x_elements(qa_ss_const.lot_number).validation_flag :=
3863: x_elements(qa_ss_const.lot_number).validation_flag ||
3864: qa_validation_api.valid_element;
3865: END IF;
3858: --
3859: -- Step 2. Set additional valid elements.
3860: --
3861: IF x_elements.EXISTS(qa_ss_const.lot_number) THEN
3862: x_elements(qa_ss_const.lot_number).validation_flag :=
3863: x_elements(qa_ss_const.lot_number).validation_flag ||
3864: qa_validation_api.valid_element;
3865: END IF;
3866:
3859: -- Step 2. Set additional valid elements.
3860: --
3861: IF x_elements.EXISTS(qa_ss_const.lot_number) THEN
3862: x_elements(qa_ss_const.lot_number).validation_flag :=
3863: x_elements(qa_ss_const.lot_number).validation_flag ||
3864: qa_validation_api.valid_element;
3865: END IF;
3866:
3867: IF x_elements.EXISTS(qa_ss_const.serial_number) THEN
3863: x_elements(qa_ss_const.lot_number).validation_flag ||
3864: qa_validation_api.valid_element;
3865: END IF;
3866:
3867: IF x_elements.EXISTS(qa_ss_const.serial_number) THEN
3868: x_elements(qa_ss_const.serial_number).validation_flag :=
3869: x_elements(qa_ss_const.serial_number).validation_flag ||
3870: qa_validation_api.valid_element;
3871: END IF;
3864: qa_validation_api.valid_element;
3865: END IF;
3866:
3867: IF x_elements.EXISTS(qa_ss_const.serial_number) THEN
3868: x_elements(qa_ss_const.serial_number).validation_flag :=
3869: x_elements(qa_ss_const.serial_number).validation_flag ||
3870: qa_validation_api.valid_element;
3871: END IF;
3872:
3865: END IF;
3866:
3867: IF x_elements.EXISTS(qa_ss_const.serial_number) THEN
3868: x_elements(qa_ss_const.serial_number).validation_flag :=
3869: x_elements(qa_ss_const.serial_number).validation_flag ||
3870: qa_validation_api.valid_element;
3871: END IF;
3872:
3873: IF x_elements.EXISTS(qa_ss_const.transaction_type) THEN
3869: x_elements(qa_ss_const.serial_number).validation_flag ||
3870: qa_validation_api.valid_element;
3871: END IF;
3872:
3873: IF x_elements.EXISTS(qa_ss_const.transaction_type) THEN
3874: x_elements(qa_ss_const.transaction_type).validation_flag :=
3875: x_elements(qa_ss_const.transaction_type).validation_flag ||
3876: qa_validation_api.valid_element;
3877: END IF;
3870: qa_validation_api.valid_element;
3871: END IF;
3872:
3873: IF x_elements.EXISTS(qa_ss_const.transaction_type) THEN
3874: x_elements(qa_ss_const.transaction_type).validation_flag :=
3875: x_elements(qa_ss_const.transaction_type).validation_flag ||
3876: qa_validation_api.valid_element;
3877: END IF;
3878:
3871: END IF;
3872:
3873: IF x_elements.EXISTS(qa_ss_const.transaction_type) THEN
3874: x_elements(qa_ss_const.transaction_type).validation_flag :=
3875: x_elements(qa_ss_const.transaction_type).validation_flag ||
3876: qa_validation_api.valid_element;
3877: END IF;
3878:
3879: --