eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.QA_RESULTS_INTERFACE_PKG dependencies on QA_SS_CONST

Line 128: IF element.char_id = qa_ss_const.item THEN

124: first := 1;
125:
126: FOR element in CES LOOP
127:
128: IF element.char_id = qa_ss_const.item THEN
129: column_name := 'qa_flex_util.item(organization_id , item_id) ITEM';
130: ELSIF element.char_id = qa_ss_const.comp_item THEN
131: column_name := 'qa_flex_util.item(organization_id , comp_item_id) COMP_ITEM';
132:

Line 130: ELSIF element.char_id = qa_ss_const.comp_item THEN

126: FOR element in CES LOOP
127:
128: IF element.char_id = qa_ss_const.item THEN
129: column_name := 'qa_flex_util.item(organization_id , item_id) ITEM';
130: ELSIF element.char_id = qa_ss_const.comp_item THEN
131: column_name := 'qa_flex_util.item(organization_id , comp_item_id) COMP_ITEM';
132:
133: -- anagarwa Fri Feb 7 14:38:21 PST 2003
134: -- Bug 2792353

Line 143: ELSIF element.char_id = qa_ss_const.bill_reference THEN

139: -- value comes from concatenated segments.
140: -- Therefore there is no need to write a separate function for these
141: -- 2 elements.
142:
143: ELSIF element.char_id = qa_ss_const.bill_reference THEN
144: column_name := 'qa_flex_util.item(organization_id, bill_reference_id) BILL_REFERENCE';
145:
146: ELSIF element.char_id = qa_ss_const.routing_reference THEN
147: column_name := 'qa_flex_util.item(organization_id, routing_reference_id) ROUTING_REFERENCE';

Line 146: ELSIF element.char_id = qa_ss_const.routing_reference THEN

142:
143: ELSIF element.char_id = qa_ss_const.bill_reference THEN
144: column_name := 'qa_flex_util.item(organization_id, bill_reference_id) BILL_REFERENCE';
145:
146: ELSIF element.char_id = qa_ss_const.routing_reference THEN
147: column_name := 'qa_flex_util.item(organization_id, routing_reference_id) ROUTING_REFERENCE';
148:
149: ELSIF element.char_id = qa_ss_const.locator THEN
150: column_name := 'qa_flex_util.locator(organization_id, locator_id)

Line 149: ELSIF element.char_id = qa_ss_const.locator THEN

145:
146: ELSIF element.char_id = qa_ss_const.routing_reference THEN
147: column_name := 'qa_flex_util.item(organization_id, routing_reference_id) ROUTING_REFERENCE';
148:
149: ELSIF element.char_id = qa_ss_const.locator THEN
150: column_name := 'qa_flex_util.locator(organization_id, locator_id)
151: LOCATOR';
152:
153: ELSIF element.char_id = qa_ss_const.comp_locator THEN

Line 153: ELSIF element.char_id = qa_ss_const.comp_locator THEN

149: ELSIF element.char_id = qa_ss_const.locator THEN
150: column_name := 'qa_flex_util.locator(organization_id, locator_id)
151: LOCATOR';
152:
153: ELSIF element.char_id = qa_ss_const.comp_locator THEN
154: column_name := 'qa_flex_util.locator(organization_id, comp_locator_id)
155: COMP_LOCATOR';
156:
157: ELSIF element.char_id = qa_ss_const.to_locator THEN

Line 157: ELSIF element.char_id = qa_ss_const.to_locator THEN

153: ELSIF element.char_id = qa_ss_const.comp_locator THEN
154: column_name := 'qa_flex_util.locator(organization_id, comp_locator_id)
155: COMP_LOCATOR';
156:
157: ELSIF element.char_id = qa_ss_const.to_locator THEN
158: column_name := 'qa_flex_util.locator(organization_id, to_locator_id)
159: TO_LOCATOR';
160:
161: -- end of changes by anagarwa

Line 174: ELSIF element.char_id = qa_ss_const.asset_group THEN

170: setupStandAloneQuery in QaVqrDataTopCO.java to know the details on
171: why ASSET_GROUP_ID should also be assigned to column_name.
172: */
173: --dgupta: Start R12 EAM Integration. Bug 4345492
174: ELSIF element.char_id = qa_ss_const.asset_group THEN
175: column_name := 'qa_flex_util.get_asset_group_name(organization_id,
176: asset_group_id) ASSET_GROUP, ASSET_GROUP_ID';
177: --dgupta: End R12 EAM Integration. Bug 4345492
178: ELSIF element.char_id = qa_ss_const.asset_activity THEN

Line 178: ELSIF element.char_id = qa_ss_const.asset_activity THEN

174: ELSIF element.char_id = qa_ss_const.asset_group THEN
175: column_name := 'qa_flex_util.get_asset_group_name(organization_id,
176: asset_group_id) ASSET_GROUP, ASSET_GROUP_ID';
177: --dgupta: End R12 EAM Integration. Bug 4345492
178: ELSIF element.char_id = qa_ss_const.asset_activity THEN
179: column_name := 'qa_flex_util.item(organization_id,
180: asset_activity_id) ASSET_ACTIVITY';
181:
182: -- added the following to include new hardcoded element followup activity

Line 185: ELSIF element.char_id = qa_ss_const.followup_activity THEN

181:
182: -- added the following to include new hardcoded element followup activity
183: -- saugupta
184:
185: ELSIF element.char_id = qa_ss_const.followup_activity THEN
186: column_name := 'qa_flex_util.item(organization_id,
187: followup_activity_id) FOLLOWUP_ACTIVITY';
188:
189: ELSIF element.char_id = qa_ss_const.work_order THEN

Line 189: ELSIF element.char_id = qa_ss_const.work_order THEN

185: ELSIF element.char_id = qa_ss_const.followup_activity THEN
186: column_name := 'qa_flex_util.item(organization_id,
187: followup_activity_id) FOLLOWUP_ACTIVITY';
188:
189: ELSIF element.char_id = qa_ss_const.work_order THEN
190: column_name := 'qa_flex_util.work_order(organization_id, work_order_id) WORK_ORDER';
191:
192: ELSIF not qa_plan_element_api.hardcoded(element.char_id) and
193: element.datatype in (qa_ss_const.date_datatype ,

Line 193: element.datatype in (qa_ss_const.date_datatype ,

189: ELSIF element.char_id = qa_ss_const.work_order THEN
190: column_name := 'qa_flex_util.work_order(organization_id, work_order_id) WORK_ORDER';
191:
192: ELSIF not qa_plan_element_api.hardcoded(element.char_id) and
193: element.datatype in (qa_ss_const.date_datatype ,
194: qa_ss_const.datetime_datatype) then
195: column_name := upper(QA_CORE_PKG.get_result_column_name(element.char_id, p_plan_id));
196: column_name := 'fnd_date.canonical_to_date(' || column_name || ') ' || column_name;
197: ELSE

Line 194: qa_ss_const.datetime_datatype) then

190: column_name := 'qa_flex_util.work_order(organization_id, work_order_id) WORK_ORDER';
191:
192: ELSIF not qa_plan_element_api.hardcoded(element.char_id) and
193: element.datatype in (qa_ss_const.date_datatype ,
194: qa_ss_const.datetime_datatype) then
195: column_name := upper(QA_CORE_PKG.get_result_column_name(element.char_id, p_plan_id));
196: column_name := 'fnd_date.canonical_to_date(' || column_name || ') ' || column_name;
197: ELSE
198: column_name := upper(QA_CORE_PKG.get_result_column_name(

Line 219: NUMBER, p_values_table IN qa_ss_const.ctx_table)

215: END build_select_clause;
216:
217:
218: FUNCTION get_txn_specific_where_clause(p_txn_number IN NUMBER, p_plan_id IN
219: NUMBER, p_values_table IN qa_ss_const.ctx_table)
220: RETURN VARCHAR2 IS
221:
222: CURSOR c1 IS
223: SELECT collection_trigger_id

Line 243: IF element_id IN (qa_ss_const.item, qa_ss_const.comp_item) then

239: EXIT WHEN c1%NOTFOUND;
240:
241: IF qa_plan_element_api.element_in_plan(p_plan_id, element_id) THEN
242:
243: IF element_id IN (qa_ss_const.item, qa_ss_const.comp_item) then
244: column_name := 'qa_flex_util.item(organization_id , item_id)';
245:
246: ELSIF element_id IN (qa_ss_const.locator,
247: qa_ss_const.comp_locator) THEN

Line 246: ELSIF element_id IN (qa_ss_const.locator,

242:
243: IF element_id IN (qa_ss_const.item, qa_ss_const.comp_item) then
244: column_name := 'qa_flex_util.item(organization_id , item_id)';
245:
246: ELSIF element_id IN (qa_ss_const.locator,
247: qa_ss_const.comp_locator) THEN
248: column_name := 'qa_flex_util.locator(organization_id,
249: locator_id)';
250: --dgupta: Start R12 EAM Integration. Bug 4345492

Line 247: qa_ss_const.comp_locator) THEN

243: IF element_id IN (qa_ss_const.item, qa_ss_const.comp_item) then
244: column_name := 'qa_flex_util.item(organization_id , item_id)';
245:
246: ELSIF element_id IN (qa_ss_const.locator,
247: qa_ss_const.comp_locator) THEN
248: column_name := 'qa_flex_util.locator(organization_id,
249: locator_id)';
250: --dgupta: Start R12 EAM Integration. Bug 4345492
251: ELSIF element_id IN (qa_ss_const.asset_group) then

Line 251: ELSIF element_id IN (qa_ss_const.asset_group) then

247: qa_ss_const.comp_locator) THEN
248: column_name := 'qa_flex_util.locator(organization_id,
249: locator_id)';
250: --dgupta: Start R12 EAM Integration. Bug 4345492
251: ELSIF element_id IN (qa_ss_const.asset_group) then
252: column_name := 'qa_flex_util.get_asset_group_name(organization_id,
253: asset_group_id)';
254: --dgupta: End R12 EAM Integration. Bug 4345492
255: ELSIF element_id = qa_ss_const.asset_activity THEN

Line 255: ELSIF element_id = qa_ss_const.asset_activity THEN

251: ELSIF element_id IN (qa_ss_const.asset_group) then
252: column_name := 'qa_flex_util.get_asset_group_name(organization_id,
253: asset_group_id)';
254: --dgupta: End R12 EAM Integration. Bug 4345492
255: ELSIF element_id = qa_ss_const.asset_activity THEN
256: column_name := 'qa_flex_util.item(organization_id,
257: asset_activity_id)';
258:
259: -- added the following to include new hardcoded element followup activity

Line 262: ELSIF element_id = qa_ss_const.followup_activity THEN

258:
259: -- added the following to include new hardcoded element followup activity
260: -- saugupta
261:
262: ELSIF element_id = qa_ss_const.followup_activity THEN
263: column_name := 'qa_flex_util.item(organization_id,
264: followup_activity_id)';
265:
266:

Line 267: ELSIF element_id = qa_ss_const.work_order THEN

263: column_name := 'qa_flex_util.item(organization_id,
264: followup_activity_id)';
265:
266:
267: ELSIF element_id = qa_ss_const.work_order THEN
268: column_name := 'qa_flex_util.work_order(organization_id, work_order_id)';
269:
270: ELSE
271: column_name := upper(QA_CORE_PKG.get_result_column_name(

Line 316: values_table qa_ss_const.ctx_table;

312: select_clause VARCHAR2(32000);
313: from_clause VARCHAR2(1000);
314: where_clause VARCHAR2(1000);
315: order_by_clause VARCHAR2(100);
316: values_table qa_ss_const.ctx_table;
317:
318: BEGIN
319:
320: values_table.delete();

Line 322: values_table(qa_ss_const.item) := p_item;

318: BEGIN
319:
320: values_table.delete();
321:
322: values_table(qa_ss_const.item) := p_item;
323: values_table(qa_ss_const.revision) := p_revision;
324: values_table(qa_ss_const.job_name) := p_job_name;
325: values_table(qa_ss_const.from_op_seq_num) := p_from_op_seq_num;
326: values_table(qa_ss_const.vendor_name) := p_vendor_name;

Line 323: values_table(qa_ss_const.revision) := p_revision;

319:
320: values_table.delete();
321:
322: values_table(qa_ss_const.item) := p_item;
323: values_table(qa_ss_const.revision) := p_revision;
324: values_table(qa_ss_const.job_name) := p_job_name;
325: values_table(qa_ss_const.from_op_seq_num) := p_from_op_seq_num;
326: values_table(qa_ss_const.vendor_name) := p_vendor_name;
327: values_table(qa_ss_const.po_number) := p_po_number;

Line 324: values_table(qa_ss_const.job_name) := p_job_name;

320: values_table.delete();
321:
322: values_table(qa_ss_const.item) := p_item;
323: values_table(qa_ss_const.revision) := p_revision;
324: values_table(qa_ss_const.job_name) := p_job_name;
325: values_table(qa_ss_const.from_op_seq_num) := p_from_op_seq_num;
326: values_table(qa_ss_const.vendor_name) := p_vendor_name;
327: values_table(qa_ss_const.po_number) := p_po_number;
328: values_table(qa_ss_const.ordered_quantity) := p_ordered_quantity;

Line 325: values_table(qa_ss_const.from_op_seq_num) := p_from_op_seq_num;

321:
322: values_table(qa_ss_const.item) := p_item;
323: values_table(qa_ss_const.revision) := p_revision;
324: values_table(qa_ss_const.job_name) := p_job_name;
325: values_table(qa_ss_const.from_op_seq_num) := p_from_op_seq_num;
326: values_table(qa_ss_const.vendor_name) := p_vendor_name;
327: values_table(qa_ss_const.po_number) := p_po_number;
328: values_table(qa_ss_const.ordered_quantity) := p_ordered_quantity;
329: values_table(qa_ss_const.vendor_item_number) := p_vendor_item_number;

Line 326: values_table(qa_ss_const.vendor_name) := p_vendor_name;

322: values_table(qa_ss_const.item) := p_item;
323: values_table(qa_ss_const.revision) := p_revision;
324: values_table(qa_ss_const.job_name) := p_job_name;
325: values_table(qa_ss_const.from_op_seq_num) := p_from_op_seq_num;
326: values_table(qa_ss_const.vendor_name) := p_vendor_name;
327: values_table(qa_ss_const.po_number) := p_po_number;
328: values_table(qa_ss_const.ordered_quantity) := p_ordered_quantity;
329: values_table(qa_ss_const.vendor_item_number) := p_vendor_item_number;
330: values_table(qa_ss_const.po_release_num) := p_po_release_num;

Line 327: values_table(qa_ss_const.po_number) := p_po_number;

323: values_table(qa_ss_const.revision) := p_revision;
324: values_table(qa_ss_const.job_name) := p_job_name;
325: values_table(qa_ss_const.from_op_seq_num) := p_from_op_seq_num;
326: values_table(qa_ss_const.vendor_name) := p_vendor_name;
327: values_table(qa_ss_const.po_number) := p_po_number;
328: values_table(qa_ss_const.ordered_quantity) := p_ordered_quantity;
329: values_table(qa_ss_const.vendor_item_number) := p_vendor_item_number;
330: values_table(qa_ss_const.po_release_num) := p_po_release_num;
331: values_table(qa_ss_const.uom_name) := p_uom_name;

Line 328: values_table(qa_ss_const.ordered_quantity) := p_ordered_quantity;

324: values_table(qa_ss_const.job_name) := p_job_name;
325: values_table(qa_ss_const.from_op_seq_num) := p_from_op_seq_num;
326: values_table(qa_ss_const.vendor_name) := p_vendor_name;
327: values_table(qa_ss_const.po_number) := p_po_number;
328: values_table(qa_ss_const.ordered_quantity) := p_ordered_quantity;
329: values_table(qa_ss_const.vendor_item_number) := p_vendor_item_number;
330: values_table(qa_ss_const.po_release_num) := p_po_release_num;
331: values_table(qa_ss_const.uom_name) := p_uom_name;
332: values_table(qa_ss_const.production_line) := p_production_line;

Line 329: values_table(qa_ss_const.vendor_item_number) := p_vendor_item_number;

325: values_table(qa_ss_const.from_op_seq_num) := p_from_op_seq_num;
326: values_table(qa_ss_const.vendor_name) := p_vendor_name;
327: values_table(qa_ss_const.po_number) := p_po_number;
328: values_table(qa_ss_const.ordered_quantity) := p_ordered_quantity;
329: values_table(qa_ss_const.vendor_item_number) := p_vendor_item_number;
330: values_table(qa_ss_const.po_release_num) := p_po_release_num;
331: values_table(qa_ss_const.uom_name) := p_uom_name;
332: values_table(qa_ss_const.production_line) := p_production_line;
333:

Line 330: values_table(qa_ss_const.po_release_num) := p_po_release_num;

326: values_table(qa_ss_const.vendor_name) := p_vendor_name;
327: values_table(qa_ss_const.po_number) := p_po_number;
328: values_table(qa_ss_const.ordered_quantity) := p_ordered_quantity;
329: values_table(qa_ss_const.vendor_item_number) := p_vendor_item_number;
330: values_table(qa_ss_const.po_release_num) := p_po_release_num;
331: values_table(qa_ss_const.uom_name) := p_uom_name;
332: values_table(qa_ss_const.production_line) := p_production_line;
333:
334: select_clause := 'SELECT ';

Line 331: values_table(qa_ss_const.uom_name) := p_uom_name;

327: values_table(qa_ss_const.po_number) := p_po_number;
328: values_table(qa_ss_const.ordered_quantity) := p_ordered_quantity;
329: values_table(qa_ss_const.vendor_item_number) := p_vendor_item_number;
330: values_table(qa_ss_const.po_release_num) := p_po_release_num;
331: values_table(qa_ss_const.uom_name) := p_uom_name;
332: values_table(qa_ss_const.production_line) := p_production_line;
333:
334: select_clause := 'SELECT ';
335: from_clause := ' FROM qa_results_v' ;

Line 332: values_table(qa_ss_const.production_line) := p_production_line;

328: values_table(qa_ss_const.ordered_quantity) := p_ordered_quantity;
329: values_table(qa_ss_const.vendor_item_number) := p_vendor_item_number;
330: values_table(qa_ss_const.po_release_num) := p_po_release_num;
331: values_table(qa_ss_const.uom_name) := p_uom_name;
332: values_table(qa_ss_const.production_line) := p_production_line;
333:
334: select_clause := 'SELECT ';
335: from_clause := ' FROM qa_results_v' ;
336: where_clause := ' WHERE plan_id = ' || p_plan_id ||

Line 355: qa_ss_const.ss_outside_processing_txn, p_plan_id, values_table);

351: IF (p_po_header_id IS NULL) THEN
352: where_clause := ' WHERE 1 = 2 ';
353: ELSE
354: where_clause := where_clause || get_txn_specific_where_clause(
355: qa_ss_const.ss_outside_processing_txn, p_plan_id, values_table);
356: where_clause := where_clause ||
357: ' AND PO_HEADER_ID = ' || p_po_header_id;
358: END IF;
359:

Line 395: values_table qa_ss_const.ctx_table;

391: from_clause VARCHAR2(1000);
392: where_clause VARCHAR2(1000);
393: order_by_clause VARCHAR2(100);
394: table_name VARCHAR2(240);
395: values_table qa_ss_const.ctx_table;
396:
397: BEGIN
398:
399: values_table.delete();

Line 401: values_table(qa_ss_const.item) := p_item;

397: BEGIN
398:
399: values_table.delete();
400:
401: values_table(qa_ss_const.item) := p_item;
402: values_table(qa_ss_const.item_category) := p_item_category;
403: values_table(qa_ss_const.revision) := p_revision;
404: values_table(qa_ss_const.vendor_name) := p_supplier;
405: values_table(qa_ss_const.po_number) := p_po_number;

Line 402: values_table(qa_ss_const.item_category) := p_item_category;

398:
399: values_table.delete();
400:
401: values_table(qa_ss_const.item) := p_item;
402: values_table(qa_ss_const.item_category) := p_item_category;
403: values_table(qa_ss_const.revision) := p_revision;
404: values_table(qa_ss_const.vendor_name) := p_supplier;
405: values_table(qa_ss_const.po_number) := p_po_number;
406: values_table(qa_ss_const.po_line_num) := p_po_line_num;

Line 403: values_table(qa_ss_const.revision) := p_revision;

399: values_table.delete();
400:
401: values_table(qa_ss_const.item) := p_item;
402: values_table(qa_ss_const.item_category) := p_item_category;
403: values_table(qa_ss_const.revision) := p_revision;
404: values_table(qa_ss_const.vendor_name) := p_supplier;
405: values_table(qa_ss_const.po_number) := p_po_number;
406: values_table(qa_ss_const.po_line_num) := p_po_line_num;
407: values_table(qa_ss_const.po_shipment_num) := p_po_shipment_num;

Line 404: values_table(qa_ss_const.vendor_name) := p_supplier;

400:
401: values_table(qa_ss_const.item) := p_item;
402: values_table(qa_ss_const.item_category) := p_item_category;
403: values_table(qa_ss_const.revision) := p_revision;
404: values_table(qa_ss_const.vendor_name) := p_supplier;
405: values_table(qa_ss_const.po_number) := p_po_number;
406: values_table(qa_ss_const.po_line_num) := p_po_line_num;
407: values_table(qa_ss_const.po_shipment_num) := p_po_shipment_num;
408: values_table(qa_ss_const.ship_to) := p_ship_to;

Line 405: values_table(qa_ss_const.po_number) := p_po_number;

401: values_table(qa_ss_const.item) := p_item;
402: values_table(qa_ss_const.item_category) := p_item_category;
403: values_table(qa_ss_const.revision) := p_revision;
404: values_table(qa_ss_const.vendor_name) := p_supplier;
405: values_table(qa_ss_const.po_number) := p_po_number;
406: values_table(qa_ss_const.po_line_num) := p_po_line_num;
407: values_table(qa_ss_const.po_shipment_num) := p_po_shipment_num;
408: values_table(qa_ss_const.ship_to) := p_ship_to;
409: values_table(qa_ss_const.ordered_quantity) := p_ordered_quantity;

Line 406: values_table(qa_ss_const.po_line_num) := p_po_line_num;

402: values_table(qa_ss_const.item_category) := p_item_category;
403: values_table(qa_ss_const.revision) := p_revision;
404: values_table(qa_ss_const.vendor_name) := p_supplier;
405: values_table(qa_ss_const.po_number) := p_po_number;
406: values_table(qa_ss_const.po_line_num) := p_po_line_num;
407: values_table(qa_ss_const.po_shipment_num) := p_po_shipment_num;
408: values_table(qa_ss_const.ship_to) := p_ship_to;
409: values_table(qa_ss_const.ordered_quantity) := p_ordered_quantity;
410: values_table(qa_ss_const.vendor_item_number) := p_vendor_item_number;

Line 407: values_table(qa_ss_const.po_shipment_num) := p_po_shipment_num;

403: values_table(qa_ss_const.revision) := p_revision;
404: values_table(qa_ss_const.vendor_name) := p_supplier;
405: values_table(qa_ss_const.po_number) := p_po_number;
406: values_table(qa_ss_const.po_line_num) := p_po_line_num;
407: values_table(qa_ss_const.po_shipment_num) := p_po_shipment_num;
408: values_table(qa_ss_const.ship_to) := p_ship_to;
409: values_table(qa_ss_const.ordered_quantity) := p_ordered_quantity;
410: values_table(qa_ss_const.vendor_item_number) := p_vendor_item_number;
411: values_table(qa_ss_const.po_release_num) := p_po_release_num;

Line 408: values_table(qa_ss_const.ship_to) := p_ship_to;

404: values_table(qa_ss_const.vendor_name) := p_supplier;
405: values_table(qa_ss_const.po_number) := p_po_number;
406: values_table(qa_ss_const.po_line_num) := p_po_line_num;
407: values_table(qa_ss_const.po_shipment_num) := p_po_shipment_num;
408: values_table(qa_ss_const.ship_to) := p_ship_to;
409: values_table(qa_ss_const.ordered_quantity) := p_ordered_quantity;
410: values_table(qa_ss_const.vendor_item_number) := p_vendor_item_number;
411: values_table(qa_ss_const.po_release_num) := p_po_release_num;
412: values_table(qa_ss_const.uom_name) := p_uom_name;

Line 409: values_table(qa_ss_const.ordered_quantity) := p_ordered_quantity;

405: values_table(qa_ss_const.po_number) := p_po_number;
406: values_table(qa_ss_const.po_line_num) := p_po_line_num;
407: values_table(qa_ss_const.po_shipment_num) := p_po_shipment_num;
408: values_table(qa_ss_const.ship_to) := p_ship_to;
409: values_table(qa_ss_const.ordered_quantity) := p_ordered_quantity;
410: values_table(qa_ss_const.vendor_item_number) := p_vendor_item_number;
411: values_table(qa_ss_const.po_release_num) := p_po_release_num;
412: values_table(qa_ss_const.uom_name) := p_uom_name;
413: values_table(qa_ss_const.vendor_site_code) := p_supplier_site;

Line 410: values_table(qa_ss_const.vendor_item_number) := p_vendor_item_number;

406: values_table(qa_ss_const.po_line_num) := p_po_line_num;
407: values_table(qa_ss_const.po_shipment_num) := p_po_shipment_num;
408: values_table(qa_ss_const.ship_to) := p_ship_to;
409: values_table(qa_ss_const.ordered_quantity) := p_ordered_quantity;
410: values_table(qa_ss_const.vendor_item_number) := p_vendor_item_number;
411: values_table(qa_ss_const.po_release_num) := p_po_release_num;
412: values_table(qa_ss_const.uom_name) := p_uom_name;
413: values_table(qa_ss_const.vendor_site_code) := p_supplier_site;
414: values_table(qa_ss_const.ship_to_location) := p_ship_to_location;

Line 411: values_table(qa_ss_const.po_release_num) := p_po_release_num;

407: values_table(qa_ss_const.po_shipment_num) := p_po_shipment_num;
408: values_table(qa_ss_const.ship_to) := p_ship_to;
409: values_table(qa_ss_const.ordered_quantity) := p_ordered_quantity;
410: values_table(qa_ss_const.vendor_item_number) := p_vendor_item_number;
411: values_table(qa_ss_const.po_release_num) := p_po_release_num;
412: values_table(qa_ss_const.uom_name) := p_uom_name;
413: values_table(qa_ss_const.vendor_site_code) := p_supplier_site;
414: values_table(qa_ss_const.ship_to_location) := p_ship_to_location;
415:

Line 412: values_table(qa_ss_const.uom_name) := p_uom_name;

408: values_table(qa_ss_const.ship_to) := p_ship_to;
409: values_table(qa_ss_const.ordered_quantity) := p_ordered_quantity;
410: values_table(qa_ss_const.vendor_item_number) := p_vendor_item_number;
411: values_table(qa_ss_const.po_release_num) := p_po_release_num;
412: values_table(qa_ss_const.uom_name) := p_uom_name;
413: values_table(qa_ss_const.vendor_site_code) := p_supplier_site;
414: values_table(qa_ss_const.ship_to_location) := p_ship_to_location;
415:
416: select_clause := 'SELECT ';

Line 413: values_table(qa_ss_const.vendor_site_code) := p_supplier_site;

409: values_table(qa_ss_const.ordered_quantity) := p_ordered_quantity;
410: values_table(qa_ss_const.vendor_item_number) := p_vendor_item_number;
411: values_table(qa_ss_const.po_release_num) := p_po_release_num;
412: values_table(qa_ss_const.uom_name) := p_uom_name;
413: values_table(qa_ss_const.vendor_site_code) := p_supplier_site;
414: values_table(qa_ss_const.ship_to_location) := p_ship_to_location;
415:
416: select_clause := 'SELECT ';
417: from_clause := ' FROM qa_results_v' ;

Line 414: values_table(qa_ss_const.ship_to_location) := p_ship_to_location;

410: values_table(qa_ss_const.vendor_item_number) := p_vendor_item_number;
411: values_table(qa_ss_const.po_release_num) := p_po_release_num;
412: values_table(qa_ss_const.uom_name) := p_uom_name;
413: values_table(qa_ss_const.vendor_site_code) := p_supplier_site;
414: values_table(qa_ss_const.ship_to_location) := p_ship_to_location;
415:
416: select_clause := 'SELECT ';
417: from_clause := ' FROM qa_results_v' ;
418: where_clause := ' WHERE plan_id = ' || p_plan_id ||

Line 436: qa_ss_const.ss_shipments_txn, p_plan_id, values_table);

432: IF (p_po_header_id IS NULL) THEN
433: where_clause := ' WHERE 1 = 2 ';
434: ELSE
435: where_clause := where_clause || get_txn_specific_where_clause(
436: qa_ss_const.ss_shipments_txn, p_plan_id, values_table);
437: where_clause := where_clause ||
438: ' AND PO_HEADER_ID = ' || p_po_header_id;
439: END IF;
440: