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.WMS_PACKING_WORKBENCH_PVT dependencies on DBMS_SQL

Line 415: l_cursor := dbms_sql.open_cursor;

411: END IF;
412: p_n := p_n +255;
413: END LOOP;
414:
415: l_cursor := dbms_sql.open_cursor;
416:
417: BEGIN
418: dbms_sql.parse(l_cursor,l_query_sql,dbms_sql.v7);
419: EXCEPTION

Line 418: dbms_sql.parse(l_cursor,l_query_sql,dbms_sql.v7);

414:
415: l_cursor := dbms_sql.open_cursor;
416:
417: BEGIN
418: dbms_sql.parse(l_cursor,l_query_sql,dbms_sql.v7);
419: EXCEPTION
420: WHEN OTHERS THEN
421: l_last_error_pos := dbms_sql.last_error_position();
422: l_temp_str := Substr(l_query_sql, l_last_error_pos-5, 50);

Line 421: l_last_error_pos := dbms_sql.last_error_position();

417: BEGIN
418: dbms_sql.parse(l_cursor,l_query_sql,dbms_sql.v7);
419: EXCEPTION
420: WHEN OTHERS THEN
421: l_last_error_pos := dbms_sql.last_error_position();
422: l_temp_str := Substr(l_query_sql, l_last_error_pos-5, 50);
423: IF l_debug = 1 THEN
424: trace('Error in parse sql statement, at '||l_temp_str);
425: END IF;

Line 434: dbms_sql.bind_variable(l_cursor, ':org_id', p_mol_rec.organization_id);

430: trace('Binding variables');
431: END IF;
432:
433: l_progress := '005';
434: dbms_sql.bind_variable(l_cursor, ':org_id', p_mol_rec.organization_id);
435: l_progress := '010';
436: dbms_sql.bind_variable(l_cursor, ':inventory_item_id', p_mol_rec.inventory_item_id);
437: l_progress := '011';
438: dbms_sql.bind_variable(l_cursor, ':revision', p_mol_rec.revision);

Line 436: dbms_sql.bind_variable(l_cursor, ':inventory_item_id', p_mol_rec.inventory_item_id);

432:
433: l_progress := '005';
434: dbms_sql.bind_variable(l_cursor, ':org_id', p_mol_rec.organization_id);
435: l_progress := '010';
436: dbms_sql.bind_variable(l_cursor, ':inventory_item_id', p_mol_rec.inventory_item_id);
437: l_progress := '011';
438: dbms_sql.bind_variable(l_cursor, ':revision', p_mol_rec.revision);
439: l_progress := '012';
440: dbms_sql.bind_variable(l_cursor, ':project_id', p_mol_rec.project_id);

Line 438: dbms_sql.bind_variable(l_cursor, ':revision', p_mol_rec.revision);

434: dbms_sql.bind_variable(l_cursor, ':org_id', p_mol_rec.organization_id);
435: l_progress := '010';
436: dbms_sql.bind_variable(l_cursor, ':inventory_item_id', p_mol_rec.inventory_item_id);
437: l_progress := '011';
438: dbms_sql.bind_variable(l_cursor, ':revision', p_mol_rec.revision);
439: l_progress := '012';
440: dbms_sql.bind_variable(l_cursor, ':project_id', p_mol_rec.project_id);
441: l_progress := '013';
442: dbms_sql.bind_variable(l_cursor, ':task_id', p_mol_rec.task_id);

Line 440: dbms_sql.bind_variable(l_cursor, ':project_id', p_mol_rec.project_id);

436: dbms_sql.bind_variable(l_cursor, ':inventory_item_id', p_mol_rec.inventory_item_id);
437: l_progress := '011';
438: dbms_sql.bind_variable(l_cursor, ':revision', p_mol_rec.revision);
439: l_progress := '012';
440: dbms_sql.bind_variable(l_cursor, ':project_id', p_mol_rec.project_id);
441: l_progress := '013';
442: dbms_sql.bind_variable(l_cursor, ':task_id', p_mol_rec.task_id);
443: l_progress := '014';
444:

Line 442: dbms_sql.bind_variable(l_cursor, ':task_id', p_mol_rec.task_id);

438: dbms_sql.bind_variable(l_cursor, ':revision', p_mol_rec.revision);
439: l_progress := '012';
440: dbms_sql.bind_variable(l_cursor, ':project_id', p_mol_rec.project_id);
441: l_progress := '013';
442: dbms_sql.bind_variable(l_cursor, ':task_id', p_mol_rec.task_id);
443: l_progress := '014';
444:
445: IF p_mol_rec.subinventory IS NOT NULL THEN
446: dbms_sql.bind_variable(l_cursor, ':subinventory_code', p_mol_rec.subinventory);

Line 446: dbms_sql.bind_variable(l_cursor, ':subinventory_code', p_mol_rec.subinventory);

442: dbms_sql.bind_variable(l_cursor, ':task_id', p_mol_rec.task_id);
443: l_progress := '014';
444:
445: IF p_mol_rec.subinventory IS NOT NULL THEN
446: dbms_sql.bind_variable(l_cursor, ':subinventory_code', p_mol_rec.subinventory);
447: END IF;
448: l_progress := '015';
449: IF p_mol_rec.locator_id IS NOT NULL THEN
450: dbms_sql.bind_variable(l_cursor, ':locator_id', p_mol_rec.locator_id);

Line 450: dbms_sql.bind_variable(l_cursor, ':locator_id', p_mol_rec.locator_id);

446: dbms_sql.bind_variable(l_cursor, ':subinventory_code', p_mol_rec.subinventory);
447: END IF;
448: l_progress := '015';
449: IF p_mol_rec.locator_id IS NOT NULL THEN
450: dbms_sql.bind_variable(l_cursor, ':locator_id', p_mol_rec.locator_id);
451: END IF;
452: l_progress := '016';
453:
454: IF p_mol_rec.lpn_id IS NOT NULL THEN

Line 455: dbms_sql.bind_variable(l_cursor, ':lpn_id', p_mol_rec.lpn_id);

451: END IF;
452: l_progress := '016';
453:
454: IF p_mol_rec.lpn_id IS NOT NULL THEN
455: dbms_sql.bind_variable(l_cursor, ':lpn_id', p_mol_rec.lpn_id);
456: END IF;
457:
458: l_progress := '017';
459: IF p_document_id IS NOT NULL THEN

Line 460: dbms_sql.bind_variable(l_cursor, ':document_id', p_document_id);

456: END IF;
457:
458: l_progress := '017';
459: IF p_document_id IS NOT NULL THEN
460: dbms_sql.bind_variable(l_cursor, ':document_id', p_document_id);
461: END IF;
462: l_progress := '018';
463:
464: IF p_document_line_id IS NOT NULL THEN

Line 465: dbms_sql.bind_variable(l_cursor, ':document_line_id', p_document_line_id);

461: END IF;
462: l_progress := '018';
463:
464: IF p_document_line_id IS NOT NULL THEN
465: dbms_sql.bind_variable(l_cursor, ':document_line_id', p_document_line_id);
466: END IF;
467: l_progress := '019';
468:
469: IF p_mol_rec.reference_id IS NOT NULL THEN

Line 470: dbms_sql.bind_variable(l_cursor, ':reference_id',p_mol_rec.reference_id);

466: END IF;
467: l_progress := '019';
468:
469: IF p_mol_rec.reference_id IS NOT NULL THEN
470: dbms_sql.bind_variable(l_cursor, ':reference_id',p_mol_rec.reference_id);
471: END IF;
472:
473: --14274513
474: IF p_receipt_num IS NOT NULL and p_document_type IN ('PO', 'ASN', 'INTSHIP') THEN

Line 475: dbms_sql.bind_variable(l_cursor, ':p_receipt_num', p_receipt_num);

471: END IF;
472:
473: --14274513
474: IF p_receipt_num IS NOT NULL and p_document_type IN ('PO', 'ASN', 'INTSHIP') THEN
475: dbms_sql.bind_variable(l_cursor, ':p_receipt_num', p_receipt_num);
476: dbms_sql.bind_variable(l_cursor, ':p_uom_code', p_mol_rec.uom);
477: END IF;
478:
479: l_progress := '020';

Line 476: dbms_sql.bind_variable(l_cursor, ':p_uom_code', p_mol_rec.uom);

472:
473: --14274513
474: IF p_receipt_num IS NOT NULL and p_document_type IN ('PO', 'ASN', 'INTSHIP') THEN
475: dbms_sql.bind_variable(l_cursor, ':p_receipt_num', p_receipt_num);
476: dbms_sql.bind_variable(l_cursor, ':p_uom_code', p_mol_rec.uom);
477: END IF;
478:
479: l_progress := '020';
480:

Line 482: dbms_sql.define_column(l_cursor, 1, l_receipt_num, 30);

478:
479: l_progress := '020';
480:
481:
482: dbms_sql.define_column(l_cursor, 1, l_receipt_num, 30);
483: l_progress := '020.5';
484: dbms_sql.define_column(l_cursor, 2, l_location_id);
485: dbms_sql.define_column(l_cursor, 3, l_vendor_id);
486: dbms_sql.define_column(l_cursor, 4, l_from_organization_id);

Line 484: dbms_sql.define_column(l_cursor, 2, l_location_id);

480:
481:
482: dbms_sql.define_column(l_cursor, 1, l_receipt_num, 30);
483: l_progress := '020.5';
484: dbms_sql.define_column(l_cursor, 2, l_location_id);
485: dbms_sql.define_column(l_cursor, 3, l_vendor_id);
486: dbms_sql.define_column(l_cursor, 4, l_from_organization_id);
487: dbms_sql.define_column(l_cursor, 5, l_rcv_transaction_id);
488:

Line 485: dbms_sql.define_column(l_cursor, 3, l_vendor_id);

481:
482: dbms_sql.define_column(l_cursor, 1, l_receipt_num, 30);
483: l_progress := '020.5';
484: dbms_sql.define_column(l_cursor, 2, l_location_id);
485: dbms_sql.define_column(l_cursor, 3, l_vendor_id);
486: dbms_sql.define_column(l_cursor, 4, l_from_organization_id);
487: dbms_sql.define_column(l_cursor, 5, l_rcv_transaction_id);
488:
489: --14274513

Line 486: dbms_sql.define_column(l_cursor, 4, l_from_organization_id);

482: dbms_sql.define_column(l_cursor, 1, l_receipt_num, 30);
483: l_progress := '020.5';
484: dbms_sql.define_column(l_cursor, 2, l_location_id);
485: dbms_sql.define_column(l_cursor, 3, l_vendor_id);
486: dbms_sql.define_column(l_cursor, 4, l_from_organization_id);
487: dbms_sql.define_column(l_cursor, 5, l_rcv_transaction_id);
488:
489: --14274513
490: dbms_sql.define_column(l_cursor, 6, l_receipt_qty);

Line 487: dbms_sql.define_column(l_cursor, 5, l_rcv_transaction_id);

483: l_progress := '020.5';
484: dbms_sql.define_column(l_cursor, 2, l_location_id);
485: dbms_sql.define_column(l_cursor, 3, l_vendor_id);
486: dbms_sql.define_column(l_cursor, 4, l_from_organization_id);
487: dbms_sql.define_column(l_cursor, 5, l_rcv_transaction_id);
488:
489: --14274513
490: dbms_sql.define_column(l_cursor, 6, l_receipt_qty);
491: dbms_sql.define_column(l_cursor, 7, l_receipt_secondary_qty);

Line 490: dbms_sql.define_column(l_cursor, 6, l_receipt_qty);

486: dbms_sql.define_column(l_cursor, 4, l_from_organization_id);
487: dbms_sql.define_column(l_cursor, 5, l_rcv_transaction_id);
488:
489: --14274513
490: dbms_sql.define_column(l_cursor, 6, l_receipt_qty);
491: dbms_sql.define_column(l_cursor, 7, l_receipt_secondary_qty);
492: dbms_sql.define_column(l_cursor, 8, l_uom, 30);
493:
494: l_progress := '021';

Line 491: dbms_sql.define_column(l_cursor, 7, l_receipt_secondary_qty);

487: dbms_sql.define_column(l_cursor, 5, l_rcv_transaction_id);
488:
489: --14274513
490: dbms_sql.define_column(l_cursor, 6, l_receipt_qty);
491: dbms_sql.define_column(l_cursor, 7, l_receipt_secondary_qty);
492: dbms_sql.define_column(l_cursor, 8, l_uom, 30);
493:
494: l_progress := '021';
495:

Line 492: dbms_sql.define_column(l_cursor, 8, l_uom, 30);

488:
489: --14274513
490: dbms_sql.define_column(l_cursor, 6, l_receipt_qty);
491: dbms_sql.define_column(l_cursor, 7, l_receipt_secondary_qty);
492: dbms_sql.define_column(l_cursor, 8, l_uom, 30);
493:
494: l_progress := '021';
495:
496: IF (l_debug = 1) THEN

Line 499: l_return := dbms_sql.execute(l_cursor);

495:
496: IF (l_debug = 1) THEN
497: trace('Excute query');
498: END IF;
499: l_return := dbms_sql.execute(l_cursor);
500: IF (l_debug = 1) THEN
501: trace('Executed query');
502: END IF;
503: l_progress := '022';

Line 513: IF DBMS_SQL.FETCH_ROWS(l_cursor) = 0 THEN

509: l_partner_exists := 0;
510: l_partner_unique := 1;
511:
512: LOOP
513: IF DBMS_SQL.FETCH_ROWS(l_cursor) = 0 THEN
514: EXIT;
515: END IF;
516:
517: x_valid := 'Y';

Line 519: dbms_sql.column_value(l_cursor, 1, l_receipt_num);

515: END IF;
516:
517: x_valid := 'Y';
518:
519: dbms_sql.column_value(l_cursor, 1, l_receipt_num);
520: dbms_sql.column_value(l_cursor, 2, l_location_id);
521: dbms_sql.column_value(l_cursor, 3, l_vendor_id);
522: dbms_sql.column_value(l_cursor, 4, l_from_organization_id);
523: dbms_sql.column_value(l_cursor, 5, l_rcv_transaction_id);

Line 520: dbms_sql.column_value(l_cursor, 2, l_location_id);

516:
517: x_valid := 'Y';
518:
519: dbms_sql.column_value(l_cursor, 1, l_receipt_num);
520: dbms_sql.column_value(l_cursor, 2, l_location_id);
521: dbms_sql.column_value(l_cursor, 3, l_vendor_id);
522: dbms_sql.column_value(l_cursor, 4, l_from_organization_id);
523: dbms_sql.column_value(l_cursor, 5, l_rcv_transaction_id);
524:

Line 521: dbms_sql.column_value(l_cursor, 3, l_vendor_id);

517: x_valid := 'Y';
518:
519: dbms_sql.column_value(l_cursor, 1, l_receipt_num);
520: dbms_sql.column_value(l_cursor, 2, l_location_id);
521: dbms_sql.column_value(l_cursor, 3, l_vendor_id);
522: dbms_sql.column_value(l_cursor, 4, l_from_organization_id);
523: dbms_sql.column_value(l_cursor, 5, l_rcv_transaction_id);
524:
525: --14274513

Line 522: dbms_sql.column_value(l_cursor, 4, l_from_organization_id);

518:
519: dbms_sql.column_value(l_cursor, 1, l_receipt_num);
520: dbms_sql.column_value(l_cursor, 2, l_location_id);
521: dbms_sql.column_value(l_cursor, 3, l_vendor_id);
522: dbms_sql.column_value(l_cursor, 4, l_from_organization_id);
523: dbms_sql.column_value(l_cursor, 5, l_rcv_transaction_id);
524:
525: --14274513
526: dbms_sql.column_value(l_cursor, 6, l_receipt_qty);

Line 523: dbms_sql.column_value(l_cursor, 5, l_rcv_transaction_id);

519: dbms_sql.column_value(l_cursor, 1, l_receipt_num);
520: dbms_sql.column_value(l_cursor, 2, l_location_id);
521: dbms_sql.column_value(l_cursor, 3, l_vendor_id);
522: dbms_sql.column_value(l_cursor, 4, l_from_organization_id);
523: dbms_sql.column_value(l_cursor, 5, l_rcv_transaction_id);
524:
525: --14274513
526: dbms_sql.column_value(l_cursor, 6, l_receipt_qty);
527: dbms_sql.column_value(l_cursor, 7, l_receipt_secondary_qty);

Line 526: dbms_sql.column_value(l_cursor, 6, l_receipt_qty);

522: dbms_sql.column_value(l_cursor, 4, l_from_organization_id);
523: dbms_sql.column_value(l_cursor, 5, l_rcv_transaction_id);
524:
525: --14274513
526: dbms_sql.column_value(l_cursor, 6, l_receipt_qty);
527: dbms_sql.column_value(l_cursor, 7, l_receipt_secondary_qty);
528: dbms_sql.column_value(l_cursor, 8, l_uom);
529:
530: IF (l_debug = 1) THEN

Line 527: dbms_sql.column_value(l_cursor, 7, l_receipt_secondary_qty);

523: dbms_sql.column_value(l_cursor, 5, l_rcv_transaction_id);
524:
525: --14274513
526: dbms_sql.column_value(l_cursor, 6, l_receipt_qty);
527: dbms_sql.column_value(l_cursor, 7, l_receipt_secondary_qty);
528: dbms_sql.column_value(l_cursor, 8, l_uom);
529:
530: IF (l_debug = 1) THEN
531: trace('rcv_transaction_id:'||l_rcv_transaction_id||

Line 528: dbms_sql.column_value(l_cursor, 8, l_uom);

524:
525: --14274513
526: dbms_sql.column_value(l_cursor, 6, l_receipt_qty);
527: dbms_sql.column_value(l_cursor, 7, l_receipt_secondary_qty);
528: dbms_sql.column_value(l_cursor, 8, l_uom);
529:
530: IF (l_debug = 1) THEN
531: trace('rcv_transaction_id:'||l_rcv_transaction_id||
532: ' receipt_num:'||l_receipt_num||

Line 622: dbms_sql.close_cursor(l_cursor);

618:
619:
620: END LOOP;
621:
622: dbms_sql.close_cursor(l_cursor);
623:
624: IF (l_debug = 1) THEN
625: trace('l_location_exists:'||l_location_exists||
626: ' l_location_unique:'||l_location_unique||

Line 701: dbms_sql.close_cursor(l_cursor);

697: trace('Error in query_inbound_material(), progress='||l_progress);
698: trace('ERROR CODE = ' || SQLCODE);
699: trace('ERROR MESSAGE = ' || SQLERRM);
700: END IF;
701: dbms_sql.close_cursor(l_cursor);
702:
703: x_valid := 'N';
704: END check_against_rcv;
705:

Line 1059: l_cursor := dbms_sql.open_cursor;

1055: /* Step 2, Build Cusor, Bind variables */
1056: IF l_debug =1 THEN
1057: trace('Finished building SQL, start build cursor');
1058: END IF;
1059: l_cursor := dbms_sql.open_cursor;
1060: l_progress := '030';
1061: BEGIN
1062: dbms_sql.parse(l_cursor,l_query_sql,dbms_sql.v7);
1063: EXCEPTION

Line 1062: dbms_sql.parse(l_cursor,l_query_sql,dbms_sql.v7);

1058: END IF;
1059: l_cursor := dbms_sql.open_cursor;
1060: l_progress := '030';
1061: BEGIN
1062: dbms_sql.parse(l_cursor,l_query_sql,dbms_sql.v7);
1063: EXCEPTION
1064: WHEN OTHERS THEN
1065: l_last_error_pos := dbms_sql.last_error_position();
1066: l_temp_str := Substr(l_query_sql, l_last_error_pos-5, 50);

Line 1065: l_last_error_pos := dbms_sql.last_error_position();

1061: BEGIN
1062: dbms_sql.parse(l_cursor,l_query_sql,dbms_sql.v7);
1063: EXCEPTION
1064: WHEN OTHERS THEN
1065: l_last_error_pos := dbms_sql.last_error_position();
1066: l_temp_str := Substr(l_query_sql, l_last_error_pos-5, 50);
1067: IF l_debug = 1 THEN
1068: trace('Error in parse sql statement, at '||l_temp_str);
1069: END IF;

Line 1078: dbms_sql.bind_variable(l_cursor, ':org_id', p_organization_id);

1074: IF l_debug =1 THEN
1075: trace('Binding variables');
1076: END IF;
1077: -- Bind variables
1078: dbms_sql.bind_variable(l_cursor, ':org_id', p_organization_id);
1079: dbms_sql.bind_variable(l_cursor, ':org_code', p_organization_code);
1080: dbms_sql.bind_variable(l_cursor, ':inventory_item_id', p_inventory_item_id);
1081: dbms_sql.bind_variable(l_cursor, ':item', p_item);
1082: dbms_sql.bind_variable(l_cursor, ':project_id', p_project_id);

Line 1079: dbms_sql.bind_variable(l_cursor, ':org_code', p_organization_code);

1075: trace('Binding variables');
1076: END IF;
1077: -- Bind variables
1078: dbms_sql.bind_variable(l_cursor, ':org_id', p_organization_id);
1079: dbms_sql.bind_variable(l_cursor, ':org_code', p_organization_code);
1080: dbms_sql.bind_variable(l_cursor, ':inventory_item_id', p_inventory_item_id);
1081: dbms_sql.bind_variable(l_cursor, ':item', p_item);
1082: dbms_sql.bind_variable(l_cursor, ':project_id', p_project_id);
1083: dbms_sql.bind_variable(l_cursor, ':project', p_project);

Line 1080: dbms_sql.bind_variable(l_cursor, ':inventory_item_id', p_inventory_item_id);

1076: END IF;
1077: -- Bind variables
1078: dbms_sql.bind_variable(l_cursor, ':org_id', p_organization_id);
1079: dbms_sql.bind_variable(l_cursor, ':org_code', p_organization_code);
1080: dbms_sql.bind_variable(l_cursor, ':inventory_item_id', p_inventory_item_id);
1081: dbms_sql.bind_variable(l_cursor, ':item', p_item);
1082: dbms_sql.bind_variable(l_cursor, ':project_id', p_project_id);
1083: dbms_sql.bind_variable(l_cursor, ':project', p_project);
1084: dbms_sql.bind_variable(l_cursor, ':task_id', p_task_id);

Line 1081: dbms_sql.bind_variable(l_cursor, ':item', p_item);

1077: -- Bind variables
1078: dbms_sql.bind_variable(l_cursor, ':org_id', p_organization_id);
1079: dbms_sql.bind_variable(l_cursor, ':org_code', p_organization_code);
1080: dbms_sql.bind_variable(l_cursor, ':inventory_item_id', p_inventory_item_id);
1081: dbms_sql.bind_variable(l_cursor, ':item', p_item);
1082: dbms_sql.bind_variable(l_cursor, ':project_id', p_project_id);
1083: dbms_sql.bind_variable(l_cursor, ':project', p_project);
1084: dbms_sql.bind_variable(l_cursor, ':task_id', p_task_id);
1085: dbms_sql.bind_variable(l_cursor, ':task', p_task);

Line 1082: dbms_sql.bind_variable(l_cursor, ':project_id', p_project_id);

1078: dbms_sql.bind_variable(l_cursor, ':org_id', p_organization_id);
1079: dbms_sql.bind_variable(l_cursor, ':org_code', p_organization_code);
1080: dbms_sql.bind_variable(l_cursor, ':inventory_item_id', p_inventory_item_id);
1081: dbms_sql.bind_variable(l_cursor, ':item', p_item);
1082: dbms_sql.bind_variable(l_cursor, ':project_id', p_project_id);
1083: dbms_sql.bind_variable(l_cursor, ':project', p_project);
1084: dbms_sql.bind_variable(l_cursor, ':task_id', p_task_id);
1085: dbms_sql.bind_variable(l_cursor, ':task', p_task);
1086: l_progress := '050';

Line 1083: dbms_sql.bind_variable(l_cursor, ':project', p_project);

1079: dbms_sql.bind_variable(l_cursor, ':org_code', p_organization_code);
1080: dbms_sql.bind_variable(l_cursor, ':inventory_item_id', p_inventory_item_id);
1081: dbms_sql.bind_variable(l_cursor, ':item', p_item);
1082: dbms_sql.bind_variable(l_cursor, ':project_id', p_project_id);
1083: dbms_sql.bind_variable(l_cursor, ':project', p_project);
1084: dbms_sql.bind_variable(l_cursor, ':task_id', p_task_id);
1085: dbms_sql.bind_variable(l_cursor, ':task', p_task);
1086: l_progress := '050';
1087: IF p_subinventory_code IS NOT NULL THEN

Line 1084: dbms_sql.bind_variable(l_cursor, ':task_id', p_task_id);

1080: dbms_sql.bind_variable(l_cursor, ':inventory_item_id', p_inventory_item_id);
1081: dbms_sql.bind_variable(l_cursor, ':item', p_item);
1082: dbms_sql.bind_variable(l_cursor, ':project_id', p_project_id);
1083: dbms_sql.bind_variable(l_cursor, ':project', p_project);
1084: dbms_sql.bind_variable(l_cursor, ':task_id', p_task_id);
1085: dbms_sql.bind_variable(l_cursor, ':task', p_task);
1086: l_progress := '050';
1087: IF p_subinventory_code IS NOT NULL THEN
1088: dbms_sql.bind_variable(l_cursor, ':subinventory', p_subinventory_code);

Line 1085: dbms_sql.bind_variable(l_cursor, ':task', p_task);

1081: dbms_sql.bind_variable(l_cursor, ':item', p_item);
1082: dbms_sql.bind_variable(l_cursor, ':project_id', p_project_id);
1083: dbms_sql.bind_variable(l_cursor, ':project', p_project);
1084: dbms_sql.bind_variable(l_cursor, ':task_id', p_task_id);
1085: dbms_sql.bind_variable(l_cursor, ':task', p_task);
1086: l_progress := '050';
1087: IF p_subinventory_code IS NOT NULL THEN
1088: dbms_sql.bind_variable(l_cursor, ':subinventory', p_subinventory_code);
1089: END IF;

Line 1088: dbms_sql.bind_variable(l_cursor, ':subinventory', p_subinventory_code);

1084: dbms_sql.bind_variable(l_cursor, ':task_id', p_task_id);
1085: dbms_sql.bind_variable(l_cursor, ':task', p_task);
1086: l_progress := '050';
1087: IF p_subinventory_code IS NOT NULL THEN
1088: dbms_sql.bind_variable(l_cursor, ':subinventory', p_subinventory_code);
1089: END IF;
1090: IF p_locator_id IS NOT NULL THEN
1091: dbms_sql.bind_variable(l_cursor, ':locator_id', p_locator_id);
1092: END IF;

Line 1091: dbms_sql.bind_variable(l_cursor, ':locator_id', p_locator_id);

1087: IF p_subinventory_code IS NOT NULL THEN
1088: dbms_sql.bind_variable(l_cursor, ':subinventory', p_subinventory_code);
1089: END IF;
1090: IF p_locator_id IS NOT NULL THEN
1091: dbms_sql.bind_variable(l_cursor, ':locator_id', p_locator_id);
1092: END IF;
1093: dbms_sql.bind_variable(l_cursor, ':locator', p_locator);
1094: IF p_from_lpn_id IS NOT NULL THEN
1095: dbms_sql.bind_variable(l_cursor, ':from_lpn_id', p_from_lpn_id);

Line 1093: dbms_sql.bind_variable(l_cursor, ':locator', p_locator);

1089: END IF;
1090: IF p_locator_id IS NOT NULL THEN
1091: dbms_sql.bind_variable(l_cursor, ':locator_id', p_locator_id);
1092: END IF;
1093: dbms_sql.bind_variable(l_cursor, ':locator', p_locator);
1094: IF p_from_lpn_id IS NOT NULL THEN
1095: dbms_sql.bind_variable(l_cursor, ':from_lpn_id', p_from_lpn_id);
1096: END IF;
1097:

Line 1095: dbms_sql.bind_variable(l_cursor, ':from_lpn_id', p_from_lpn_id);

1091: dbms_sql.bind_variable(l_cursor, ':locator_id', p_locator_id);
1092: END IF;
1093: dbms_sql.bind_variable(l_cursor, ':locator', p_locator);
1094: IF p_from_lpn_id IS NOT NULL THEN
1095: dbms_sql.bind_variable(l_cursor, ':from_lpn_id', p_from_lpn_id);
1096: END IF;
1097:
1098: IF p_document_id IS NOT NULL AND l_doc_num_used = 1 THEN
1099: dbms_sql.bind_variable(l_cursor, ':doc_num_id', p_document_id);

Line 1099: dbms_sql.bind_variable(l_cursor, ':doc_num_id', p_document_id);

1095: dbms_sql.bind_variable(l_cursor, ':from_lpn_id', p_from_lpn_id);
1096: END IF;
1097:
1098: IF p_document_id IS NOT NULL AND l_doc_num_used = 1 THEN
1099: dbms_sql.bind_variable(l_cursor, ':doc_num_id', p_document_id);
1100: END IF;
1101:
1102: IF p_document_line_id IS NOT NULL AND l_doc_line_used = 1 THEN
1103: dbms_sql.bind_variable(l_cursor, ':doc_line_id', p_document_line_id);

Line 1103: dbms_sql.bind_variable(l_cursor, ':doc_line_id', p_document_line_id);

1099: dbms_sql.bind_variable(l_cursor, ':doc_num_id', p_document_id);
1100: END IF;
1101:
1102: IF p_document_line_id IS NOT NULL AND l_doc_line_used = 1 THEN
1103: dbms_sql.bind_variable(l_cursor, ':doc_line_id', p_document_line_id);
1104: END IF;
1105:
1106: IF (p_receipt_number IS NOT NULL AND l_receipt_used = 1) THEN
1107: dbms_sql.bind_variable(l_cursor, ':receipt_num', p_receipt_number);

Line 1107: dbms_sql.bind_variable(l_cursor, ':receipt_num', p_receipt_number);

1103: dbms_sql.bind_variable(l_cursor, ':doc_line_id', p_document_line_id);
1104: END IF;
1105:
1106: IF (p_receipt_number IS NOT NULL AND l_receipt_used = 1) THEN
1107: dbms_sql.bind_variable(l_cursor, ':receipt_num', p_receipt_number);
1108: END IF;
1109:
1110: l_progress := '060';
1111:

Line 1117: dbms_sql.define_column(l_cursor, 1, l_mol_header_id);

1113: IF l_debug = 1 THEN
1114: trace('Execute the query');
1115: END IF;
1116: --Define output parameters
1117: dbms_sql.define_column(l_cursor, 1, l_mol_header_id);
1118: dbms_sql.define_column(l_cursor, 2, l_mol_line_id);
1119: dbms_sql.define_column(l_cursor, 3, l_reference,240);
1120: dbms_sql.define_column(l_cursor, 4, l_reference_id);
1121: dbms_sql.define_column(l_cursor, 5, l_txn_source_id);

Line 1118: dbms_sql.define_column(l_cursor, 2, l_mol_line_id);

1114: trace('Execute the query');
1115: END IF;
1116: --Define output parameters
1117: dbms_sql.define_column(l_cursor, 1, l_mol_header_id);
1118: dbms_sql.define_column(l_cursor, 2, l_mol_line_id);
1119: dbms_sql.define_column(l_cursor, 3, l_reference,240);
1120: dbms_sql.define_column(l_cursor, 4, l_reference_id);
1121: dbms_sql.define_column(l_cursor, 5, l_txn_source_id);
1122: dbms_sql.define_column(l_cursor, 6, l_organization_id);

Line 1119: dbms_sql.define_column(l_cursor, 3, l_reference,240);

1115: END IF;
1116: --Define output parameters
1117: dbms_sql.define_column(l_cursor, 1, l_mol_header_id);
1118: dbms_sql.define_column(l_cursor, 2, l_mol_line_id);
1119: dbms_sql.define_column(l_cursor, 3, l_reference,240);
1120: dbms_sql.define_column(l_cursor, 4, l_reference_id);
1121: dbms_sql.define_column(l_cursor, 5, l_txn_source_id);
1122: dbms_sql.define_column(l_cursor, 6, l_organization_id);
1123: dbms_sql.define_column(l_cursor, 7, l_organization_code,3);

Line 1120: dbms_sql.define_column(l_cursor, 4, l_reference_id);

1116: --Define output parameters
1117: dbms_sql.define_column(l_cursor, 1, l_mol_header_id);
1118: dbms_sql.define_column(l_cursor, 2, l_mol_line_id);
1119: dbms_sql.define_column(l_cursor, 3, l_reference,240);
1120: dbms_sql.define_column(l_cursor, 4, l_reference_id);
1121: dbms_sql.define_column(l_cursor, 5, l_txn_source_id);
1122: dbms_sql.define_column(l_cursor, 6, l_organization_id);
1123: dbms_sql.define_column(l_cursor, 7, l_organization_code,3);
1124: dbms_sql.define_column(l_cursor, 8, l_subinventory,10);

Line 1121: dbms_sql.define_column(l_cursor, 5, l_txn_source_id);

1117: dbms_sql.define_column(l_cursor, 1, l_mol_header_id);
1118: dbms_sql.define_column(l_cursor, 2, l_mol_line_id);
1119: dbms_sql.define_column(l_cursor, 3, l_reference,240);
1120: dbms_sql.define_column(l_cursor, 4, l_reference_id);
1121: dbms_sql.define_column(l_cursor, 5, l_txn_source_id);
1122: dbms_sql.define_column(l_cursor, 6, l_organization_id);
1123: dbms_sql.define_column(l_cursor, 7, l_organization_code,3);
1124: dbms_sql.define_column(l_cursor, 8, l_subinventory,10);
1125: dbms_sql.define_column(l_cursor, 9, l_locator_id);

Line 1122: dbms_sql.define_column(l_cursor, 6, l_organization_id);

1118: dbms_sql.define_column(l_cursor, 2, l_mol_line_id);
1119: dbms_sql.define_column(l_cursor, 3, l_reference,240);
1120: dbms_sql.define_column(l_cursor, 4, l_reference_id);
1121: dbms_sql.define_column(l_cursor, 5, l_txn_source_id);
1122: dbms_sql.define_column(l_cursor, 6, l_organization_id);
1123: dbms_sql.define_column(l_cursor, 7, l_organization_code,3);
1124: dbms_sql.define_column(l_cursor, 8, l_subinventory,10);
1125: dbms_sql.define_column(l_cursor, 9, l_locator_id);
1126: dbms_sql.define_column(l_cursor, 10,l_locator,204);

Line 1123: dbms_sql.define_column(l_cursor, 7, l_organization_code,3);

1119: dbms_sql.define_column(l_cursor, 3, l_reference,240);
1120: dbms_sql.define_column(l_cursor, 4, l_reference_id);
1121: dbms_sql.define_column(l_cursor, 5, l_txn_source_id);
1122: dbms_sql.define_column(l_cursor, 6, l_organization_id);
1123: dbms_sql.define_column(l_cursor, 7, l_organization_code,3);
1124: dbms_sql.define_column(l_cursor, 8, l_subinventory,10);
1125: dbms_sql.define_column(l_cursor, 9, l_locator_id);
1126: dbms_sql.define_column(l_cursor, 10,l_locator,204);
1127: dbms_sql.define_column(l_cursor, 11, l_project_id);

Line 1124: dbms_sql.define_column(l_cursor, 8, l_subinventory,10);

1120: dbms_sql.define_column(l_cursor, 4, l_reference_id);
1121: dbms_sql.define_column(l_cursor, 5, l_txn_source_id);
1122: dbms_sql.define_column(l_cursor, 6, l_organization_id);
1123: dbms_sql.define_column(l_cursor, 7, l_organization_code,3);
1124: dbms_sql.define_column(l_cursor, 8, l_subinventory,10);
1125: dbms_sql.define_column(l_cursor, 9, l_locator_id);
1126: dbms_sql.define_column(l_cursor, 10,l_locator,204);
1127: dbms_sql.define_column(l_cursor, 11, l_project_id);
1128: dbms_sql.define_column(l_cursor, 12, l_project,30);

Line 1125: dbms_sql.define_column(l_cursor, 9, l_locator_id);

1121: dbms_sql.define_column(l_cursor, 5, l_txn_source_id);
1122: dbms_sql.define_column(l_cursor, 6, l_organization_id);
1123: dbms_sql.define_column(l_cursor, 7, l_organization_code,3);
1124: dbms_sql.define_column(l_cursor, 8, l_subinventory,10);
1125: dbms_sql.define_column(l_cursor, 9, l_locator_id);
1126: dbms_sql.define_column(l_cursor, 10,l_locator,204);
1127: dbms_sql.define_column(l_cursor, 11, l_project_id);
1128: dbms_sql.define_column(l_cursor, 12, l_project,30);
1129: dbms_sql.define_column(l_cursor, 13, l_task_id);

Line 1126: dbms_sql.define_column(l_cursor, 10,l_locator,204);

1122: dbms_sql.define_column(l_cursor, 6, l_organization_id);
1123: dbms_sql.define_column(l_cursor, 7, l_organization_code,3);
1124: dbms_sql.define_column(l_cursor, 8, l_subinventory,10);
1125: dbms_sql.define_column(l_cursor, 9, l_locator_id);
1126: dbms_sql.define_column(l_cursor, 10,l_locator,204);
1127: dbms_sql.define_column(l_cursor, 11, l_project_id);
1128: dbms_sql.define_column(l_cursor, 12, l_project,30);
1129: dbms_sql.define_column(l_cursor, 13, l_task_id);
1130: dbms_sql.define_column(l_cursor, 14, l_task,30);

Line 1127: dbms_sql.define_column(l_cursor, 11, l_project_id);

1123: dbms_sql.define_column(l_cursor, 7, l_organization_code,3);
1124: dbms_sql.define_column(l_cursor, 8, l_subinventory,10);
1125: dbms_sql.define_column(l_cursor, 9, l_locator_id);
1126: dbms_sql.define_column(l_cursor, 10,l_locator,204);
1127: dbms_sql.define_column(l_cursor, 11, l_project_id);
1128: dbms_sql.define_column(l_cursor, 12, l_project,30);
1129: dbms_sql.define_column(l_cursor, 13, l_task_id);
1130: dbms_sql.define_column(l_cursor, 14, l_task,30);
1131: dbms_sql.define_column(l_cursor, 15, l_inventory_item_id);

Line 1128: dbms_sql.define_column(l_cursor, 12, l_project,30);

1124: dbms_sql.define_column(l_cursor, 8, l_subinventory,10);
1125: dbms_sql.define_column(l_cursor, 9, l_locator_id);
1126: dbms_sql.define_column(l_cursor, 10,l_locator,204);
1127: dbms_sql.define_column(l_cursor, 11, l_project_id);
1128: dbms_sql.define_column(l_cursor, 12, l_project,30);
1129: dbms_sql.define_column(l_cursor, 13, l_task_id);
1130: dbms_sql.define_column(l_cursor, 14, l_task,30);
1131: dbms_sql.define_column(l_cursor, 15, l_inventory_item_id);
1132: dbms_sql.define_column(l_cursor, 16, l_item,40);

Line 1129: dbms_sql.define_column(l_cursor, 13, l_task_id);

1125: dbms_sql.define_column(l_cursor, 9, l_locator_id);
1126: dbms_sql.define_column(l_cursor, 10,l_locator,204);
1127: dbms_sql.define_column(l_cursor, 11, l_project_id);
1128: dbms_sql.define_column(l_cursor, 12, l_project,30);
1129: dbms_sql.define_column(l_cursor, 13, l_task_id);
1130: dbms_sql.define_column(l_cursor, 14, l_task,30);
1131: dbms_sql.define_column(l_cursor, 15, l_inventory_item_id);
1132: dbms_sql.define_column(l_cursor, 16, l_item,40);
1133: dbms_sql.define_column(l_cursor, 17, l_lpn_id);

Line 1130: dbms_sql.define_column(l_cursor, 14, l_task,30);

1126: dbms_sql.define_column(l_cursor, 10,l_locator,204);
1127: dbms_sql.define_column(l_cursor, 11, l_project_id);
1128: dbms_sql.define_column(l_cursor, 12, l_project,30);
1129: dbms_sql.define_column(l_cursor, 13, l_task_id);
1130: dbms_sql.define_column(l_cursor, 14, l_task,30);
1131: dbms_sql.define_column(l_cursor, 15, l_inventory_item_id);
1132: dbms_sql.define_column(l_cursor, 16, l_item,40);
1133: dbms_sql.define_column(l_cursor, 17, l_lpn_id);
1134: dbms_sql.define_column(l_cursor, 18, l_revision,3);

Line 1131: dbms_sql.define_column(l_cursor, 15, l_inventory_item_id);

1127: dbms_sql.define_column(l_cursor, 11, l_project_id);
1128: dbms_sql.define_column(l_cursor, 12, l_project,30);
1129: dbms_sql.define_column(l_cursor, 13, l_task_id);
1130: dbms_sql.define_column(l_cursor, 14, l_task,30);
1131: dbms_sql.define_column(l_cursor, 15, l_inventory_item_id);
1132: dbms_sql.define_column(l_cursor, 16, l_item,40);
1133: dbms_sql.define_column(l_cursor, 17, l_lpn_id);
1134: dbms_sql.define_column(l_cursor, 18, l_revision,3);
1135: dbms_sql.define_column(l_cursor, 19, l_uom,3);

Line 1132: dbms_sql.define_column(l_cursor, 16, l_item,40);

1128: dbms_sql.define_column(l_cursor, 12, l_project,30);
1129: dbms_sql.define_column(l_cursor, 13, l_task_id);
1130: dbms_sql.define_column(l_cursor, 14, l_task,30);
1131: dbms_sql.define_column(l_cursor, 15, l_inventory_item_id);
1132: dbms_sql.define_column(l_cursor, 16, l_item,40);
1133: dbms_sql.define_column(l_cursor, 17, l_lpn_id);
1134: dbms_sql.define_column(l_cursor, 18, l_revision,3);
1135: dbms_sql.define_column(l_cursor, 19, l_uom,3);
1136: dbms_sql.define_column(l_cursor, 20, l_qty);

Line 1133: dbms_sql.define_column(l_cursor, 17, l_lpn_id);

1129: dbms_sql.define_column(l_cursor, 13, l_task_id);
1130: dbms_sql.define_column(l_cursor, 14, l_task,30);
1131: dbms_sql.define_column(l_cursor, 15, l_inventory_item_id);
1132: dbms_sql.define_column(l_cursor, 16, l_item,40);
1133: dbms_sql.define_column(l_cursor, 17, l_lpn_id);
1134: dbms_sql.define_column(l_cursor, 18, l_revision,3);
1135: dbms_sql.define_column(l_cursor, 19, l_uom,3);
1136: dbms_sql.define_column(l_cursor, 20, l_qty);
1137: dbms_sql.define_column(l_cursor, 21, l_lot, 30);

Line 1134: dbms_sql.define_column(l_cursor, 18, l_revision,3);

1130: dbms_sql.define_column(l_cursor, 14, l_task,30);
1131: dbms_sql.define_column(l_cursor, 15, l_inventory_item_id);
1132: dbms_sql.define_column(l_cursor, 16, l_item,40);
1133: dbms_sql.define_column(l_cursor, 17, l_lpn_id);
1134: dbms_sql.define_column(l_cursor, 18, l_revision,3);
1135: dbms_sql.define_column(l_cursor, 19, l_uom,3);
1136: dbms_sql.define_column(l_cursor, 20, l_qty);
1137: dbms_sql.define_column(l_cursor, 21, l_lot, 30);
1138: --INVCONV kkillams

Line 1135: dbms_sql.define_column(l_cursor, 19, l_uom,3);

1131: dbms_sql.define_column(l_cursor, 15, l_inventory_item_id);
1132: dbms_sql.define_column(l_cursor, 16, l_item,40);
1133: dbms_sql.define_column(l_cursor, 17, l_lpn_id);
1134: dbms_sql.define_column(l_cursor, 18, l_revision,3);
1135: dbms_sql.define_column(l_cursor, 19, l_uom,3);
1136: dbms_sql.define_column(l_cursor, 20, l_qty);
1137: dbms_sql.define_column(l_cursor, 21, l_lot, 30);
1138: --INVCONV kkillams
1139: dbms_sql.define_column(l_cursor, 22, l_sec_qty);

Line 1136: dbms_sql.define_column(l_cursor, 20, l_qty);

1132: dbms_sql.define_column(l_cursor, 16, l_item,40);
1133: dbms_sql.define_column(l_cursor, 17, l_lpn_id);
1134: dbms_sql.define_column(l_cursor, 18, l_revision,3);
1135: dbms_sql.define_column(l_cursor, 19, l_uom,3);
1136: dbms_sql.define_column(l_cursor, 20, l_qty);
1137: dbms_sql.define_column(l_cursor, 21, l_lot, 30);
1138: --INVCONV kkillams
1139: dbms_sql.define_column(l_cursor, 22, l_sec_qty);
1140: dbms_sql.define_column(l_cursor, 23, l_sec_uom,3);

Line 1137: dbms_sql.define_column(l_cursor, 21, l_lot, 30);

1133: dbms_sql.define_column(l_cursor, 17, l_lpn_id);
1134: dbms_sql.define_column(l_cursor, 18, l_revision,3);
1135: dbms_sql.define_column(l_cursor, 19, l_uom,3);
1136: dbms_sql.define_column(l_cursor, 20, l_qty);
1137: dbms_sql.define_column(l_cursor, 21, l_lot, 30);
1138: --INVCONV kkillams
1139: dbms_sql.define_column(l_cursor, 22, l_sec_qty);
1140: dbms_sql.define_column(l_cursor, 23, l_sec_uom,3);
1141: dbms_sql.define_column(l_cursor, 24, l_grade,150);

Line 1139: dbms_sql.define_column(l_cursor, 22, l_sec_qty);

1135: dbms_sql.define_column(l_cursor, 19, l_uom,3);
1136: dbms_sql.define_column(l_cursor, 20, l_qty);
1137: dbms_sql.define_column(l_cursor, 21, l_lot, 30);
1138: --INVCONV kkillams
1139: dbms_sql.define_column(l_cursor, 22, l_sec_qty);
1140: dbms_sql.define_column(l_cursor, 23, l_sec_uom,3);
1141: dbms_sql.define_column(l_cursor, 24, l_grade,150);
1142: --END INVCONV kkillams
1143: dbms_sql.define_column(l_cursor, 25, l_rcv_location_id);

Line 1140: dbms_sql.define_column(l_cursor, 23, l_sec_uom,3);

1136: dbms_sql.define_column(l_cursor, 20, l_qty);
1137: dbms_sql.define_column(l_cursor, 21, l_lot, 30);
1138: --INVCONV kkillams
1139: dbms_sql.define_column(l_cursor, 22, l_sec_qty);
1140: dbms_sql.define_column(l_cursor, 23, l_sec_uom,3);
1141: dbms_sql.define_column(l_cursor, 24, l_grade,150);
1142: --END INVCONV kkillams
1143: dbms_sql.define_column(l_cursor, 25, l_rcv_location_id);
1144: dbms_sql.define_column(l_cursor, 26, l_rcv_location,60);

Line 1141: dbms_sql.define_column(l_cursor, 24, l_grade,150);

1137: dbms_sql.define_column(l_cursor, 21, l_lot, 30);
1138: --INVCONV kkillams
1139: dbms_sql.define_column(l_cursor, 22, l_sec_qty);
1140: dbms_sql.define_column(l_cursor, 23, l_sec_uom,3);
1141: dbms_sql.define_column(l_cursor, 24, l_grade,150);
1142: --END INVCONV kkillams
1143: dbms_sql.define_column(l_cursor, 25, l_rcv_location_id);
1144: dbms_sql.define_column(l_cursor, 26, l_rcv_location,60);
1145: dbms_sql.define_column(l_cursor, 27, l_vendor_id);

Line 1143: dbms_sql.define_column(l_cursor, 25, l_rcv_location_id);

1139: dbms_sql.define_column(l_cursor, 22, l_sec_qty);
1140: dbms_sql.define_column(l_cursor, 23, l_sec_uom,3);
1141: dbms_sql.define_column(l_cursor, 24, l_grade,150);
1142: --END INVCONV kkillams
1143: dbms_sql.define_column(l_cursor, 25, l_rcv_location_id);
1144: dbms_sql.define_column(l_cursor, 26, l_rcv_location,60);
1145: dbms_sql.define_column(l_cursor, 27, l_vendor_id);
1146: dbms_sql.define_column(l_cursor, 28, l_src_org_id);
1147: dbms_sql.define_column(l_cursor, 29, l_partner_name,240);

Line 1144: dbms_sql.define_column(l_cursor, 26, l_rcv_location,60);

1140: dbms_sql.define_column(l_cursor, 23, l_sec_uom,3);
1141: dbms_sql.define_column(l_cursor, 24, l_grade,150);
1142: --END INVCONV kkillams
1143: dbms_sql.define_column(l_cursor, 25, l_rcv_location_id);
1144: dbms_sql.define_column(l_cursor, 26, l_rcv_location,60);
1145: dbms_sql.define_column(l_cursor, 27, l_vendor_id);
1146: dbms_sql.define_column(l_cursor, 28, l_src_org_id);
1147: dbms_sql.define_column(l_cursor, 29, l_partner_name,240);
1148: dbms_sql.define_column(l_cursor, 30, l_doc_type,20);

Line 1145: dbms_sql.define_column(l_cursor, 27, l_vendor_id);

1141: dbms_sql.define_column(l_cursor, 24, l_grade,150);
1142: --END INVCONV kkillams
1143: dbms_sql.define_column(l_cursor, 25, l_rcv_location_id);
1144: dbms_sql.define_column(l_cursor, 26, l_rcv_location,60);
1145: dbms_sql.define_column(l_cursor, 27, l_vendor_id);
1146: dbms_sql.define_column(l_cursor, 28, l_src_org_id);
1147: dbms_sql.define_column(l_cursor, 29, l_partner_name,240);
1148: dbms_sql.define_column(l_cursor, 30, l_doc_type,20);
1149: dbms_sql.define_column(l_cursor, 31, l_doc_num_id);

Line 1146: dbms_sql.define_column(l_cursor, 28, l_src_org_id);

1142: --END INVCONV kkillams
1143: dbms_sql.define_column(l_cursor, 25, l_rcv_location_id);
1144: dbms_sql.define_column(l_cursor, 26, l_rcv_location,60);
1145: dbms_sql.define_column(l_cursor, 27, l_vendor_id);
1146: dbms_sql.define_column(l_cursor, 28, l_src_org_id);
1147: dbms_sql.define_column(l_cursor, 29, l_partner_name,240);
1148: dbms_sql.define_column(l_cursor, 30, l_doc_type,20);
1149: dbms_sql.define_column(l_cursor, 31, l_doc_num_id);
1150: dbms_sql.define_column(l_cursor, 32, l_document_number,50);

Line 1147: dbms_sql.define_column(l_cursor, 29, l_partner_name,240);

1143: dbms_sql.define_column(l_cursor, 25, l_rcv_location_id);
1144: dbms_sql.define_column(l_cursor, 26, l_rcv_location,60);
1145: dbms_sql.define_column(l_cursor, 27, l_vendor_id);
1146: dbms_sql.define_column(l_cursor, 28, l_src_org_id);
1147: dbms_sql.define_column(l_cursor, 29, l_partner_name,240);
1148: dbms_sql.define_column(l_cursor, 30, l_doc_type,20);
1149: dbms_sql.define_column(l_cursor, 31, l_doc_num_id);
1150: dbms_sql.define_column(l_cursor, 32, l_document_number,50);
1151: dbms_sql.define_column(l_cursor, 33, l_receipt_num,30);

Line 1148: dbms_sql.define_column(l_cursor, 30, l_doc_type,20);

1144: dbms_sql.define_column(l_cursor, 26, l_rcv_location,60);
1145: dbms_sql.define_column(l_cursor, 27, l_vendor_id);
1146: dbms_sql.define_column(l_cursor, 28, l_src_org_id);
1147: dbms_sql.define_column(l_cursor, 29, l_partner_name,240);
1148: dbms_sql.define_column(l_cursor, 30, l_doc_type,20);
1149: dbms_sql.define_column(l_cursor, 31, l_doc_num_id);
1150: dbms_sql.define_column(l_cursor, 32, l_document_number,50);
1151: dbms_sql.define_column(l_cursor, 33, l_receipt_num,30);
1152: dbms_sql.define_column(l_cursor, 34, l_doc_line_id);

Line 1149: dbms_sql.define_column(l_cursor, 31, l_doc_num_id);

1145: dbms_sql.define_column(l_cursor, 27, l_vendor_id);
1146: dbms_sql.define_column(l_cursor, 28, l_src_org_id);
1147: dbms_sql.define_column(l_cursor, 29, l_partner_name,240);
1148: dbms_sql.define_column(l_cursor, 30, l_doc_type,20);
1149: dbms_sql.define_column(l_cursor, 31, l_doc_num_id);
1150: dbms_sql.define_column(l_cursor, 32, l_document_number,50);
1151: dbms_sql.define_column(l_cursor, 33, l_receipt_num,30);
1152: dbms_sql.define_column(l_cursor, 34, l_doc_line_id);
1153: dbms_sql.define_column(l_cursor, 35, l_doc_line_num,10);--CLM Changes, Line number to be alphanumeric

Line 1150: dbms_sql.define_column(l_cursor, 32, l_document_number,50);

1146: dbms_sql.define_column(l_cursor, 28, l_src_org_id);
1147: dbms_sql.define_column(l_cursor, 29, l_partner_name,240);
1148: dbms_sql.define_column(l_cursor, 30, l_doc_type,20);
1149: dbms_sql.define_column(l_cursor, 31, l_doc_num_id);
1150: dbms_sql.define_column(l_cursor, 32, l_document_number,50);
1151: dbms_sql.define_column(l_cursor, 33, l_receipt_num,30);
1152: dbms_sql.define_column(l_cursor, 34, l_doc_line_id);
1153: dbms_sql.define_column(l_cursor, 35, l_doc_line_num,10);--CLM Changes, Line number to be alphanumeric
1154:

Line 1151: dbms_sql.define_column(l_cursor, 33, l_receipt_num,30);

1147: dbms_sql.define_column(l_cursor, 29, l_partner_name,240);
1148: dbms_sql.define_column(l_cursor, 30, l_doc_type,20);
1149: dbms_sql.define_column(l_cursor, 31, l_doc_num_id);
1150: dbms_sql.define_column(l_cursor, 32, l_document_number,50);
1151: dbms_sql.define_column(l_cursor, 33, l_receipt_num,30);
1152: dbms_sql.define_column(l_cursor, 34, l_doc_line_id);
1153: dbms_sql.define_column(l_cursor, 35, l_doc_line_num,10);--CLM Changes, Line number to be alphanumeric
1154:
1155:

Line 1152: dbms_sql.define_column(l_cursor, 34, l_doc_line_id);

1148: dbms_sql.define_column(l_cursor, 30, l_doc_type,20);
1149: dbms_sql.define_column(l_cursor, 31, l_doc_num_id);
1150: dbms_sql.define_column(l_cursor, 32, l_document_number,50);
1151: dbms_sql.define_column(l_cursor, 33, l_receipt_num,30);
1152: dbms_sql.define_column(l_cursor, 34, l_doc_line_id);
1153: dbms_sql.define_column(l_cursor, 35, l_doc_line_num,10);--CLM Changes, Line number to be alphanumeric
1154:
1155:
1156: l_progress := '070';

Line 1153: dbms_sql.define_column(l_cursor, 35, l_doc_line_num,10);--CLM Changes, Line number to be alphanumeric

1149: dbms_sql.define_column(l_cursor, 31, l_doc_num_id);
1150: dbms_sql.define_column(l_cursor, 32, l_document_number,50);
1151: dbms_sql.define_column(l_cursor, 33, l_receipt_num,30);
1152: dbms_sql.define_column(l_cursor, 34, l_doc_line_id);
1153: dbms_sql.define_column(l_cursor, 35, l_doc_line_num,10);--CLM Changes, Line number to be alphanumeric
1154:
1155:
1156: l_progress := '070';
1157: l_return := dbms_sql.execute(l_cursor);

Line 1157: l_return := dbms_sql.execute(l_cursor);

1153: dbms_sql.define_column(l_cursor, 35, l_doc_line_num,10);--CLM Changes, Line number to be alphanumeric
1154:
1155:
1156: l_progress := '070';
1157: l_return := dbms_sql.execute(l_cursor);
1158: l_progress := '080';
1159: IF l_debug = 1 THEN
1160: trace('Executed query');
1161: END IF;

Line 1170: IF DBMS_SQL.FETCH_ROWS(l_cursor) = 0 THEN

1166: l_rec_count := 0;
1167: LOOP
1168: -- Fetch the rows into the buffer, and also check for the exit
1169: -- condition from the loop.
1170: IF DBMS_SQL.FETCH_ROWS(l_cursor) = 0 THEN
1171: EXIT;
1172: END IF;
1173: l_material_rec := l_null_material;
1174: -- Retrieve the rows from the buffer into temp variables.

Line 1175: dbms_sql.column_value(l_cursor, 1, l_material_rec.move_order_header_id);

1171: EXIT;
1172: END IF;
1173: l_material_rec := l_null_material;
1174: -- Retrieve the rows from the buffer into temp variables.
1175: dbms_sql.column_value(l_cursor, 1, l_material_rec.move_order_header_id);
1176: dbms_sql.column_value(l_cursor, 2, l_material_rec.move_order_line_id);
1177: dbms_sql.column_value(l_cursor, 3, l_material_rec.reference);
1178: dbms_sql.column_value(l_cursor, 4, l_material_rec.reference_id);
1179: dbms_sql.column_value(l_cursor, 5, l_material_rec.txn_source_id);

Line 1176: dbms_sql.column_value(l_cursor, 2, l_material_rec.move_order_line_id);

1172: END IF;
1173: l_material_rec := l_null_material;
1174: -- Retrieve the rows from the buffer into temp variables.
1175: dbms_sql.column_value(l_cursor, 1, l_material_rec.move_order_header_id);
1176: dbms_sql.column_value(l_cursor, 2, l_material_rec.move_order_line_id);
1177: dbms_sql.column_value(l_cursor, 3, l_material_rec.reference);
1178: dbms_sql.column_value(l_cursor, 4, l_material_rec.reference_id);
1179: dbms_sql.column_value(l_cursor, 5, l_material_rec.txn_source_id);
1180: dbms_sql.column_value(l_cursor, 6, l_material_rec.organization_id);

Line 1177: dbms_sql.column_value(l_cursor, 3, l_material_rec.reference);

1173: l_material_rec := l_null_material;
1174: -- Retrieve the rows from the buffer into temp variables.
1175: dbms_sql.column_value(l_cursor, 1, l_material_rec.move_order_header_id);
1176: dbms_sql.column_value(l_cursor, 2, l_material_rec.move_order_line_id);
1177: dbms_sql.column_value(l_cursor, 3, l_material_rec.reference);
1178: dbms_sql.column_value(l_cursor, 4, l_material_rec.reference_id);
1179: dbms_sql.column_value(l_cursor, 5, l_material_rec.txn_source_id);
1180: dbms_sql.column_value(l_cursor, 6, l_material_rec.organization_id);
1181: dbms_sql.column_value(l_cursor, 7, l_material_rec.organization_code);

Line 1178: dbms_sql.column_value(l_cursor, 4, l_material_rec.reference_id);

1174: -- Retrieve the rows from the buffer into temp variables.
1175: dbms_sql.column_value(l_cursor, 1, l_material_rec.move_order_header_id);
1176: dbms_sql.column_value(l_cursor, 2, l_material_rec.move_order_line_id);
1177: dbms_sql.column_value(l_cursor, 3, l_material_rec.reference);
1178: dbms_sql.column_value(l_cursor, 4, l_material_rec.reference_id);
1179: dbms_sql.column_value(l_cursor, 5, l_material_rec.txn_source_id);
1180: dbms_sql.column_value(l_cursor, 6, l_material_rec.organization_id);
1181: dbms_sql.column_value(l_cursor, 7, l_material_rec.organization_code);
1182: dbms_sql.column_value(l_cursor, 8, l_material_rec.subinventory);

Line 1179: dbms_sql.column_value(l_cursor, 5, l_material_rec.txn_source_id);

1175: dbms_sql.column_value(l_cursor, 1, l_material_rec.move_order_header_id);
1176: dbms_sql.column_value(l_cursor, 2, l_material_rec.move_order_line_id);
1177: dbms_sql.column_value(l_cursor, 3, l_material_rec.reference);
1178: dbms_sql.column_value(l_cursor, 4, l_material_rec.reference_id);
1179: dbms_sql.column_value(l_cursor, 5, l_material_rec.txn_source_id);
1180: dbms_sql.column_value(l_cursor, 6, l_material_rec.organization_id);
1181: dbms_sql.column_value(l_cursor, 7, l_material_rec.organization_code);
1182: dbms_sql.column_value(l_cursor, 8, l_material_rec.subinventory);
1183: dbms_sql.column_value(l_cursor, 9, l_material_rec.locator_id);

Line 1180: dbms_sql.column_value(l_cursor, 6, l_material_rec.organization_id);

1176: dbms_sql.column_value(l_cursor, 2, l_material_rec.move_order_line_id);
1177: dbms_sql.column_value(l_cursor, 3, l_material_rec.reference);
1178: dbms_sql.column_value(l_cursor, 4, l_material_rec.reference_id);
1179: dbms_sql.column_value(l_cursor, 5, l_material_rec.txn_source_id);
1180: dbms_sql.column_value(l_cursor, 6, l_material_rec.organization_id);
1181: dbms_sql.column_value(l_cursor, 7, l_material_rec.organization_code);
1182: dbms_sql.column_value(l_cursor, 8, l_material_rec.subinventory);
1183: dbms_sql.column_value(l_cursor, 9, l_material_rec.locator_id);
1184: dbms_sql.column_value(l_cursor, 10,l_material_rec.locator);

Line 1181: dbms_sql.column_value(l_cursor, 7, l_material_rec.organization_code);

1177: dbms_sql.column_value(l_cursor, 3, l_material_rec.reference);
1178: dbms_sql.column_value(l_cursor, 4, l_material_rec.reference_id);
1179: dbms_sql.column_value(l_cursor, 5, l_material_rec.txn_source_id);
1180: dbms_sql.column_value(l_cursor, 6, l_material_rec.organization_id);
1181: dbms_sql.column_value(l_cursor, 7, l_material_rec.organization_code);
1182: dbms_sql.column_value(l_cursor, 8, l_material_rec.subinventory);
1183: dbms_sql.column_value(l_cursor, 9, l_material_rec.locator_id);
1184: dbms_sql.column_value(l_cursor, 10,l_material_rec.locator);
1185: dbms_sql.column_value(l_cursor, 11, l_material_rec.project_id);

Line 1182: dbms_sql.column_value(l_cursor, 8, l_material_rec.subinventory);

1178: dbms_sql.column_value(l_cursor, 4, l_material_rec.reference_id);
1179: dbms_sql.column_value(l_cursor, 5, l_material_rec.txn_source_id);
1180: dbms_sql.column_value(l_cursor, 6, l_material_rec.organization_id);
1181: dbms_sql.column_value(l_cursor, 7, l_material_rec.organization_code);
1182: dbms_sql.column_value(l_cursor, 8, l_material_rec.subinventory);
1183: dbms_sql.column_value(l_cursor, 9, l_material_rec.locator_id);
1184: dbms_sql.column_value(l_cursor, 10,l_material_rec.locator);
1185: dbms_sql.column_value(l_cursor, 11, l_material_rec.project_id);
1186: dbms_sql.column_value(l_cursor, 12, l_material_rec.project);

Line 1183: dbms_sql.column_value(l_cursor, 9, l_material_rec.locator_id);

1179: dbms_sql.column_value(l_cursor, 5, l_material_rec.txn_source_id);
1180: dbms_sql.column_value(l_cursor, 6, l_material_rec.organization_id);
1181: dbms_sql.column_value(l_cursor, 7, l_material_rec.organization_code);
1182: dbms_sql.column_value(l_cursor, 8, l_material_rec.subinventory);
1183: dbms_sql.column_value(l_cursor, 9, l_material_rec.locator_id);
1184: dbms_sql.column_value(l_cursor, 10,l_material_rec.locator);
1185: dbms_sql.column_value(l_cursor, 11, l_material_rec.project_id);
1186: dbms_sql.column_value(l_cursor, 12, l_material_rec.project);
1187: dbms_sql.column_value(l_cursor, 13, l_material_rec.task_id);

Line 1184: dbms_sql.column_value(l_cursor, 10,l_material_rec.locator);

1180: dbms_sql.column_value(l_cursor, 6, l_material_rec.organization_id);
1181: dbms_sql.column_value(l_cursor, 7, l_material_rec.organization_code);
1182: dbms_sql.column_value(l_cursor, 8, l_material_rec.subinventory);
1183: dbms_sql.column_value(l_cursor, 9, l_material_rec.locator_id);
1184: dbms_sql.column_value(l_cursor, 10,l_material_rec.locator);
1185: dbms_sql.column_value(l_cursor, 11, l_material_rec.project_id);
1186: dbms_sql.column_value(l_cursor, 12, l_material_rec.project);
1187: dbms_sql.column_value(l_cursor, 13, l_material_rec.task_id);
1188: dbms_sql.column_value(l_cursor, 14, l_material_rec.task_number);

Line 1185: dbms_sql.column_value(l_cursor, 11, l_material_rec.project_id);

1181: dbms_sql.column_value(l_cursor, 7, l_material_rec.organization_code);
1182: dbms_sql.column_value(l_cursor, 8, l_material_rec.subinventory);
1183: dbms_sql.column_value(l_cursor, 9, l_material_rec.locator_id);
1184: dbms_sql.column_value(l_cursor, 10,l_material_rec.locator);
1185: dbms_sql.column_value(l_cursor, 11, l_material_rec.project_id);
1186: dbms_sql.column_value(l_cursor, 12, l_material_rec.project);
1187: dbms_sql.column_value(l_cursor, 13, l_material_rec.task_id);
1188: dbms_sql.column_value(l_cursor, 14, l_material_rec.task_number);
1189: dbms_sql.column_value(l_cursor, 15, l_material_rec.inventory_item_id);

Line 1186: dbms_sql.column_value(l_cursor, 12, l_material_rec.project);

1182: dbms_sql.column_value(l_cursor, 8, l_material_rec.subinventory);
1183: dbms_sql.column_value(l_cursor, 9, l_material_rec.locator_id);
1184: dbms_sql.column_value(l_cursor, 10,l_material_rec.locator);
1185: dbms_sql.column_value(l_cursor, 11, l_material_rec.project_id);
1186: dbms_sql.column_value(l_cursor, 12, l_material_rec.project);
1187: dbms_sql.column_value(l_cursor, 13, l_material_rec.task_id);
1188: dbms_sql.column_value(l_cursor, 14, l_material_rec.task_number);
1189: dbms_sql.column_value(l_cursor, 15, l_material_rec.inventory_item_id);
1190: dbms_sql.column_value(l_cursor, 16, l_material_rec.item);

Line 1187: dbms_sql.column_value(l_cursor, 13, l_material_rec.task_id);

1183: dbms_sql.column_value(l_cursor, 9, l_material_rec.locator_id);
1184: dbms_sql.column_value(l_cursor, 10,l_material_rec.locator);
1185: dbms_sql.column_value(l_cursor, 11, l_material_rec.project_id);
1186: dbms_sql.column_value(l_cursor, 12, l_material_rec.project);
1187: dbms_sql.column_value(l_cursor, 13, l_material_rec.task_id);
1188: dbms_sql.column_value(l_cursor, 14, l_material_rec.task_number);
1189: dbms_sql.column_value(l_cursor, 15, l_material_rec.inventory_item_id);
1190: dbms_sql.column_value(l_cursor, 16, l_material_rec.item);
1191: dbms_sql.column_value(l_cursor, 17, l_material_rec.lpn_id);

Line 1188: dbms_sql.column_value(l_cursor, 14, l_material_rec.task_number);

1184: dbms_sql.column_value(l_cursor, 10,l_material_rec.locator);
1185: dbms_sql.column_value(l_cursor, 11, l_material_rec.project_id);
1186: dbms_sql.column_value(l_cursor, 12, l_material_rec.project);
1187: dbms_sql.column_value(l_cursor, 13, l_material_rec.task_id);
1188: dbms_sql.column_value(l_cursor, 14, l_material_rec.task_number);
1189: dbms_sql.column_value(l_cursor, 15, l_material_rec.inventory_item_id);
1190: dbms_sql.column_value(l_cursor, 16, l_material_rec.item);
1191: dbms_sql.column_value(l_cursor, 17, l_material_rec.lpn_id);
1192: dbms_sql.column_value(l_cursor, 18, l_material_rec.revision);

Line 1189: dbms_sql.column_value(l_cursor, 15, l_material_rec.inventory_item_id);

1185: dbms_sql.column_value(l_cursor, 11, l_material_rec.project_id);
1186: dbms_sql.column_value(l_cursor, 12, l_material_rec.project);
1187: dbms_sql.column_value(l_cursor, 13, l_material_rec.task_id);
1188: dbms_sql.column_value(l_cursor, 14, l_material_rec.task_number);
1189: dbms_sql.column_value(l_cursor, 15, l_material_rec.inventory_item_id);
1190: dbms_sql.column_value(l_cursor, 16, l_material_rec.item);
1191: dbms_sql.column_value(l_cursor, 17, l_material_rec.lpn_id);
1192: dbms_sql.column_value(l_cursor, 18, l_material_rec.revision);
1193: dbms_sql.column_value(l_cursor, 19, l_material_rec.uom);

Line 1190: dbms_sql.column_value(l_cursor, 16, l_material_rec.item);

1186: dbms_sql.column_value(l_cursor, 12, l_material_rec.project);
1187: dbms_sql.column_value(l_cursor, 13, l_material_rec.task_id);
1188: dbms_sql.column_value(l_cursor, 14, l_material_rec.task_number);
1189: dbms_sql.column_value(l_cursor, 15, l_material_rec.inventory_item_id);
1190: dbms_sql.column_value(l_cursor, 16, l_material_rec.item);
1191: dbms_sql.column_value(l_cursor, 17, l_material_rec.lpn_id);
1192: dbms_sql.column_value(l_cursor, 18, l_material_rec.revision);
1193: dbms_sql.column_value(l_cursor, 19, l_material_rec.uom);
1194: dbms_sql.column_value(l_cursor, 20, l_material_rec.quantity);

Line 1191: dbms_sql.column_value(l_cursor, 17, l_material_rec.lpn_id);

1187: dbms_sql.column_value(l_cursor, 13, l_material_rec.task_id);
1188: dbms_sql.column_value(l_cursor, 14, l_material_rec.task_number);
1189: dbms_sql.column_value(l_cursor, 15, l_material_rec.inventory_item_id);
1190: dbms_sql.column_value(l_cursor, 16, l_material_rec.item);
1191: dbms_sql.column_value(l_cursor, 17, l_material_rec.lpn_id);
1192: dbms_sql.column_value(l_cursor, 18, l_material_rec.revision);
1193: dbms_sql.column_value(l_cursor, 19, l_material_rec.uom);
1194: dbms_sql.column_value(l_cursor, 20, l_material_rec.quantity);
1195: dbms_sql.column_value(l_cursor, 21, l_material_rec.lot_number);

Line 1192: dbms_sql.column_value(l_cursor, 18, l_material_rec.revision);

1188: dbms_sql.column_value(l_cursor, 14, l_material_rec.task_number);
1189: dbms_sql.column_value(l_cursor, 15, l_material_rec.inventory_item_id);
1190: dbms_sql.column_value(l_cursor, 16, l_material_rec.item);
1191: dbms_sql.column_value(l_cursor, 17, l_material_rec.lpn_id);
1192: dbms_sql.column_value(l_cursor, 18, l_material_rec.revision);
1193: dbms_sql.column_value(l_cursor, 19, l_material_rec.uom);
1194: dbms_sql.column_value(l_cursor, 20, l_material_rec.quantity);
1195: dbms_sql.column_value(l_cursor, 21, l_material_rec.lot_number);
1196: --INVCONV kkillams

Line 1193: dbms_sql.column_value(l_cursor, 19, l_material_rec.uom);

1189: dbms_sql.column_value(l_cursor, 15, l_material_rec.inventory_item_id);
1190: dbms_sql.column_value(l_cursor, 16, l_material_rec.item);
1191: dbms_sql.column_value(l_cursor, 17, l_material_rec.lpn_id);
1192: dbms_sql.column_value(l_cursor, 18, l_material_rec.revision);
1193: dbms_sql.column_value(l_cursor, 19, l_material_rec.uom);
1194: dbms_sql.column_value(l_cursor, 20, l_material_rec.quantity);
1195: dbms_sql.column_value(l_cursor, 21, l_material_rec.lot_number);
1196: --INVCONV kkillams
1197: dbms_sql.column_value(l_cursor, 22, l_material_rec.secondary_quantity);

Line 1194: dbms_sql.column_value(l_cursor, 20, l_material_rec.quantity);

1190: dbms_sql.column_value(l_cursor, 16, l_material_rec.item);
1191: dbms_sql.column_value(l_cursor, 17, l_material_rec.lpn_id);
1192: dbms_sql.column_value(l_cursor, 18, l_material_rec.revision);
1193: dbms_sql.column_value(l_cursor, 19, l_material_rec.uom);
1194: dbms_sql.column_value(l_cursor, 20, l_material_rec.quantity);
1195: dbms_sql.column_value(l_cursor, 21, l_material_rec.lot_number);
1196: --INVCONV kkillams
1197: dbms_sql.column_value(l_cursor, 22, l_material_rec.secondary_quantity);
1198: dbms_sql.column_value(l_cursor, 23, l_material_rec.secondary_uom_code);

Line 1195: dbms_sql.column_value(l_cursor, 21, l_material_rec.lot_number);

1191: dbms_sql.column_value(l_cursor, 17, l_material_rec.lpn_id);
1192: dbms_sql.column_value(l_cursor, 18, l_material_rec.revision);
1193: dbms_sql.column_value(l_cursor, 19, l_material_rec.uom);
1194: dbms_sql.column_value(l_cursor, 20, l_material_rec.quantity);
1195: dbms_sql.column_value(l_cursor, 21, l_material_rec.lot_number);
1196: --INVCONV kkillams
1197: dbms_sql.column_value(l_cursor, 22, l_material_rec.secondary_quantity);
1198: dbms_sql.column_value(l_cursor, 23, l_material_rec.secondary_uom_code);
1199: dbms_sql.column_value(l_cursor, 24, l_material_rec.grade_code);

Line 1197: dbms_sql.column_value(l_cursor, 22, l_material_rec.secondary_quantity);

1193: dbms_sql.column_value(l_cursor, 19, l_material_rec.uom);
1194: dbms_sql.column_value(l_cursor, 20, l_material_rec.quantity);
1195: dbms_sql.column_value(l_cursor, 21, l_material_rec.lot_number);
1196: --INVCONV kkillams
1197: dbms_sql.column_value(l_cursor, 22, l_material_rec.secondary_quantity);
1198: dbms_sql.column_value(l_cursor, 23, l_material_rec.secondary_uom_code);
1199: dbms_sql.column_value(l_cursor, 24, l_material_rec.grade_code);
1200: --END INVCONV kkillams
1201: dbms_sql.column_value(l_cursor, 25, l_material_rec.receiving_location_id);

Line 1198: dbms_sql.column_value(l_cursor, 23, l_material_rec.secondary_uom_code);

1194: dbms_sql.column_value(l_cursor, 20, l_material_rec.quantity);
1195: dbms_sql.column_value(l_cursor, 21, l_material_rec.lot_number);
1196: --INVCONV kkillams
1197: dbms_sql.column_value(l_cursor, 22, l_material_rec.secondary_quantity);
1198: dbms_sql.column_value(l_cursor, 23, l_material_rec.secondary_uom_code);
1199: dbms_sql.column_value(l_cursor, 24, l_material_rec.grade_code);
1200: --END INVCONV kkillams
1201: dbms_sql.column_value(l_cursor, 25, l_material_rec.receiving_location_id);
1202: dbms_sql.column_value(l_cursor, 26, l_material_rec.receiving_location);

Line 1199: dbms_sql.column_value(l_cursor, 24, l_material_rec.grade_code);

1195: dbms_sql.column_value(l_cursor, 21, l_material_rec.lot_number);
1196: --INVCONV kkillams
1197: dbms_sql.column_value(l_cursor, 22, l_material_rec.secondary_quantity);
1198: dbms_sql.column_value(l_cursor, 23, l_material_rec.secondary_uom_code);
1199: dbms_sql.column_value(l_cursor, 24, l_material_rec.grade_code);
1200: --END INVCONV kkillams
1201: dbms_sql.column_value(l_cursor, 25, l_material_rec.receiving_location_id);
1202: dbms_sql.column_value(l_cursor, 26, l_material_rec.receiving_location);
1203: dbms_sql.column_value(l_cursor, 27, l_material_rec.vendor_id);

Line 1201: dbms_sql.column_value(l_cursor, 25, l_material_rec.receiving_location_id);

1197: dbms_sql.column_value(l_cursor, 22, l_material_rec.secondary_quantity);
1198: dbms_sql.column_value(l_cursor, 23, l_material_rec.secondary_uom_code);
1199: dbms_sql.column_value(l_cursor, 24, l_material_rec.grade_code);
1200: --END INVCONV kkillams
1201: dbms_sql.column_value(l_cursor, 25, l_material_rec.receiving_location_id);
1202: dbms_sql.column_value(l_cursor, 26, l_material_rec.receiving_location);
1203: dbms_sql.column_value(l_cursor, 27, l_material_rec.vendor_id);
1204: dbms_sql.column_value(l_cursor, 28, l_material_rec.source_org_id);
1205: dbms_sql.column_value(l_cursor, 29, l_material_rec.trading_partner);

Line 1202: dbms_sql.column_value(l_cursor, 26, l_material_rec.receiving_location);

1198: dbms_sql.column_value(l_cursor, 23, l_material_rec.secondary_uom_code);
1199: dbms_sql.column_value(l_cursor, 24, l_material_rec.grade_code);
1200: --END INVCONV kkillams
1201: dbms_sql.column_value(l_cursor, 25, l_material_rec.receiving_location_id);
1202: dbms_sql.column_value(l_cursor, 26, l_material_rec.receiving_location);
1203: dbms_sql.column_value(l_cursor, 27, l_material_rec.vendor_id);
1204: dbms_sql.column_value(l_cursor, 28, l_material_rec.source_org_id);
1205: dbms_sql.column_value(l_cursor, 29, l_material_rec.trading_partner);
1206: dbms_sql.column_value(l_cursor, 30, l_material_rec.document_type);

Line 1203: dbms_sql.column_value(l_cursor, 27, l_material_rec.vendor_id);

1199: dbms_sql.column_value(l_cursor, 24, l_material_rec.grade_code);
1200: --END INVCONV kkillams
1201: dbms_sql.column_value(l_cursor, 25, l_material_rec.receiving_location_id);
1202: dbms_sql.column_value(l_cursor, 26, l_material_rec.receiving_location);
1203: dbms_sql.column_value(l_cursor, 27, l_material_rec.vendor_id);
1204: dbms_sql.column_value(l_cursor, 28, l_material_rec.source_org_id);
1205: dbms_sql.column_value(l_cursor, 29, l_material_rec.trading_partner);
1206: dbms_sql.column_value(l_cursor, 30, l_material_rec.document_type);
1207: dbms_sql.column_value(l_cursor, 31, l_material_rec.document_id);

Line 1204: dbms_sql.column_value(l_cursor, 28, l_material_rec.source_org_id);

1200: --END INVCONV kkillams
1201: dbms_sql.column_value(l_cursor, 25, l_material_rec.receiving_location_id);
1202: dbms_sql.column_value(l_cursor, 26, l_material_rec.receiving_location);
1203: dbms_sql.column_value(l_cursor, 27, l_material_rec.vendor_id);
1204: dbms_sql.column_value(l_cursor, 28, l_material_rec.source_org_id);
1205: dbms_sql.column_value(l_cursor, 29, l_material_rec.trading_partner);
1206: dbms_sql.column_value(l_cursor, 30, l_material_rec.document_type);
1207: dbms_sql.column_value(l_cursor, 31, l_material_rec.document_id);
1208: dbms_sql.column_value(l_cursor, 32, l_material_rec.document_number);

Line 1205: dbms_sql.column_value(l_cursor, 29, l_material_rec.trading_partner);

1201: dbms_sql.column_value(l_cursor, 25, l_material_rec.receiving_location_id);
1202: dbms_sql.column_value(l_cursor, 26, l_material_rec.receiving_location);
1203: dbms_sql.column_value(l_cursor, 27, l_material_rec.vendor_id);
1204: dbms_sql.column_value(l_cursor, 28, l_material_rec.source_org_id);
1205: dbms_sql.column_value(l_cursor, 29, l_material_rec.trading_partner);
1206: dbms_sql.column_value(l_cursor, 30, l_material_rec.document_type);
1207: dbms_sql.column_value(l_cursor, 31, l_material_rec.document_id);
1208: dbms_sql.column_value(l_cursor, 32, l_material_rec.document_number);
1209: dbms_sql.column_value(l_cursor, 33, l_material_rec.receipt_num);

Line 1206: dbms_sql.column_value(l_cursor, 30, l_material_rec.document_type);

1202: dbms_sql.column_value(l_cursor, 26, l_material_rec.receiving_location);
1203: dbms_sql.column_value(l_cursor, 27, l_material_rec.vendor_id);
1204: dbms_sql.column_value(l_cursor, 28, l_material_rec.source_org_id);
1205: dbms_sql.column_value(l_cursor, 29, l_material_rec.trading_partner);
1206: dbms_sql.column_value(l_cursor, 30, l_material_rec.document_type);
1207: dbms_sql.column_value(l_cursor, 31, l_material_rec.document_id);
1208: dbms_sql.column_value(l_cursor, 32, l_material_rec.document_number);
1209: dbms_sql.column_value(l_cursor, 33, l_material_rec.receipt_num);
1210: dbms_sql.column_value(l_cursor, 34, l_material_rec.document_line_id);

Line 1207: dbms_sql.column_value(l_cursor, 31, l_material_rec.document_id);

1203: dbms_sql.column_value(l_cursor, 27, l_material_rec.vendor_id);
1204: dbms_sql.column_value(l_cursor, 28, l_material_rec.source_org_id);
1205: dbms_sql.column_value(l_cursor, 29, l_material_rec.trading_partner);
1206: dbms_sql.column_value(l_cursor, 30, l_material_rec.document_type);
1207: dbms_sql.column_value(l_cursor, 31, l_material_rec.document_id);
1208: dbms_sql.column_value(l_cursor, 32, l_material_rec.document_number);
1209: dbms_sql.column_value(l_cursor, 33, l_material_rec.receipt_num);
1210: dbms_sql.column_value(l_cursor, 34, l_material_rec.document_line_id);
1211: dbms_sql.column_value(l_cursor, 35, l_material_rec.document_line_num);

Line 1208: dbms_sql.column_value(l_cursor, 32, l_material_rec.document_number);

1204: dbms_sql.column_value(l_cursor, 28, l_material_rec.source_org_id);
1205: dbms_sql.column_value(l_cursor, 29, l_material_rec.trading_partner);
1206: dbms_sql.column_value(l_cursor, 30, l_material_rec.document_type);
1207: dbms_sql.column_value(l_cursor, 31, l_material_rec.document_id);
1208: dbms_sql.column_value(l_cursor, 32, l_material_rec.document_number);
1209: dbms_sql.column_value(l_cursor, 33, l_material_rec.receipt_num);
1210: dbms_sql.column_value(l_cursor, 34, l_material_rec.document_line_id);
1211: dbms_sql.column_value(l_cursor, 35, l_material_rec.document_line_num);
1212:

Line 1209: dbms_sql.column_value(l_cursor, 33, l_material_rec.receipt_num);

1205: dbms_sql.column_value(l_cursor, 29, l_material_rec.trading_partner);
1206: dbms_sql.column_value(l_cursor, 30, l_material_rec.document_type);
1207: dbms_sql.column_value(l_cursor, 31, l_material_rec.document_id);
1208: dbms_sql.column_value(l_cursor, 32, l_material_rec.document_number);
1209: dbms_sql.column_value(l_cursor, 33, l_material_rec.receipt_num);
1210: dbms_sql.column_value(l_cursor, 34, l_material_rec.document_line_id);
1211: dbms_sql.column_value(l_cursor, 35, l_material_rec.document_line_num);
1212:
1213: l_rec_count := l_rec_count + 1;

Line 1210: dbms_sql.column_value(l_cursor, 34, l_material_rec.document_line_id);

1206: dbms_sql.column_value(l_cursor, 30, l_material_rec.document_type);
1207: dbms_sql.column_value(l_cursor, 31, l_material_rec.document_id);
1208: dbms_sql.column_value(l_cursor, 32, l_material_rec.document_number);
1209: dbms_sql.column_value(l_cursor, 33, l_material_rec.receipt_num);
1210: dbms_sql.column_value(l_cursor, 34, l_material_rec.document_line_id);
1211: dbms_sql.column_value(l_cursor, 35, l_material_rec.document_line_num);
1212:
1213: l_rec_count := l_rec_count + 1;
1214:

Line 1211: dbms_sql.column_value(l_cursor, 35, l_material_rec.document_line_num);

1207: dbms_sql.column_value(l_cursor, 31, l_material_rec.document_id);
1208: dbms_sql.column_value(l_cursor, 32, l_material_rec.document_number);
1209: dbms_sql.column_value(l_cursor, 33, l_material_rec.receipt_num);
1210: dbms_sql.column_value(l_cursor, 34, l_material_rec.document_line_id);
1211: dbms_sql.column_value(l_cursor, 35, l_material_rec.document_line_num);
1212:
1213: l_rec_count := l_rec_count + 1;
1214:
1215: trace('Calling check_against_rcv');

Line 1749: dbms_sql.close_cursor(l_cursor);

1745: <>
1746: NULL;
1747: END LOOP;
1748:
1749: dbms_sql.close_cursor(l_cursor);
1750:
1751: IF l_debug = 1 THEN
1752: trace('Found eligible material records '||l_rec_count);
1753: END IF;

Line 1823: dbms_sql.close_cursor(l_cursor);

1819: trace('Error in query_inbound_material(), progress='||l_progress);
1820: trace('ERROR CODE = ' || SQLCODE);
1821: trace('ERROR MESSAGE = ' || SQLERRM);
1822: END IF;
1823: dbms_sql.close_cursor(l_cursor);
1824:
1825: x_return_status := fnd_api.G_RET_STS_UNEXP_ERROR;
1826:
1827: END query_inbound_material;