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 384: l_cursor := dbms_sql.open_cursor;

380: END IF;
381: p_n := p_n +255;
382: END LOOP;
383:
384: l_cursor := dbms_sql.open_cursor;
385:
386: BEGIN
387: dbms_sql.parse(l_cursor,l_query_sql,dbms_sql.v7);
388: EXCEPTION

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

383:
384: l_cursor := dbms_sql.open_cursor;
385:
386: BEGIN
387: dbms_sql.parse(l_cursor,l_query_sql,dbms_sql.v7);
388: EXCEPTION
389: WHEN OTHERS THEN
390: l_last_error_pos := dbms_sql.last_error_position();
391: l_temp_str := Substr(l_query_sql, l_last_error_pos-5, 50);

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

386: BEGIN
387: dbms_sql.parse(l_cursor,l_query_sql,dbms_sql.v7);
388: EXCEPTION
389: WHEN OTHERS THEN
390: l_last_error_pos := dbms_sql.last_error_position();
391: l_temp_str := Substr(l_query_sql, l_last_error_pos-5, 50);
392: IF l_debug = 1 THEN
393: trace('Error in parse sql statement, at '||l_temp_str);
394: END IF;

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

399: trace('Binding variables');
400: END IF;
401:
402: l_progress := '005';
403: dbms_sql.bind_variable(l_cursor, ':org_id', p_mol_rec.organization_id);
404: l_progress := '010';
405: dbms_sql.bind_variable(l_cursor, ':inventory_item_id', p_mol_rec.inventory_item_id);
406: l_progress := '011';
407: dbms_sql.bind_variable(l_cursor, ':revision', p_mol_rec.revision);

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

401:
402: l_progress := '005';
403: dbms_sql.bind_variable(l_cursor, ':org_id', p_mol_rec.organization_id);
404: l_progress := '010';
405: dbms_sql.bind_variable(l_cursor, ':inventory_item_id', p_mol_rec.inventory_item_id);
406: l_progress := '011';
407: dbms_sql.bind_variable(l_cursor, ':revision', p_mol_rec.revision);
408: l_progress := '012';
409: dbms_sql.bind_variable(l_cursor, ':project_id', p_mol_rec.project_id);

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

403: dbms_sql.bind_variable(l_cursor, ':org_id', p_mol_rec.organization_id);
404: l_progress := '010';
405: dbms_sql.bind_variable(l_cursor, ':inventory_item_id', p_mol_rec.inventory_item_id);
406: l_progress := '011';
407: dbms_sql.bind_variable(l_cursor, ':revision', p_mol_rec.revision);
408: l_progress := '012';
409: dbms_sql.bind_variable(l_cursor, ':project_id', p_mol_rec.project_id);
410: l_progress := '013';
411: dbms_sql.bind_variable(l_cursor, ':task_id', p_mol_rec.task_id);

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

405: dbms_sql.bind_variable(l_cursor, ':inventory_item_id', p_mol_rec.inventory_item_id);
406: l_progress := '011';
407: dbms_sql.bind_variable(l_cursor, ':revision', p_mol_rec.revision);
408: l_progress := '012';
409: dbms_sql.bind_variable(l_cursor, ':project_id', p_mol_rec.project_id);
410: l_progress := '013';
411: dbms_sql.bind_variable(l_cursor, ':task_id', p_mol_rec.task_id);
412: l_progress := '014';
413:

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

407: dbms_sql.bind_variable(l_cursor, ':revision', p_mol_rec.revision);
408: l_progress := '012';
409: dbms_sql.bind_variable(l_cursor, ':project_id', p_mol_rec.project_id);
410: l_progress := '013';
411: dbms_sql.bind_variable(l_cursor, ':task_id', p_mol_rec.task_id);
412: l_progress := '014';
413:
414: IF p_mol_rec.subinventory IS NOT NULL THEN
415: dbms_sql.bind_variable(l_cursor, ':subinventory_code', p_mol_rec.subinventory);

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

411: dbms_sql.bind_variable(l_cursor, ':task_id', p_mol_rec.task_id);
412: l_progress := '014';
413:
414: IF p_mol_rec.subinventory IS NOT NULL THEN
415: dbms_sql.bind_variable(l_cursor, ':subinventory_code', p_mol_rec.subinventory);
416: END IF;
417: l_progress := '015';
418: IF p_mol_rec.locator_id IS NOT NULL THEN
419: dbms_sql.bind_variable(l_cursor, ':locator_id', p_mol_rec.locator_id);

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

415: dbms_sql.bind_variable(l_cursor, ':subinventory_code', p_mol_rec.subinventory);
416: END IF;
417: l_progress := '015';
418: IF p_mol_rec.locator_id IS NOT NULL THEN
419: dbms_sql.bind_variable(l_cursor, ':locator_id', p_mol_rec.locator_id);
420: END IF;
421: l_progress := '016';
422:
423: IF p_mol_rec.lpn_id IS NOT NULL THEN

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

420: END IF;
421: l_progress := '016';
422:
423: IF p_mol_rec.lpn_id IS NOT NULL THEN
424: dbms_sql.bind_variable(l_cursor, ':lpn_id', p_mol_rec.lpn_id);
425: END IF;
426:
427: l_progress := '017';
428: IF p_document_id IS NOT NULL THEN

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

425: END IF;
426:
427: l_progress := '017';
428: IF p_document_id IS NOT NULL THEN
429: dbms_sql.bind_variable(l_cursor, ':document_id', p_document_id);
430: END IF;
431: l_progress := '018';
432:
433: IF p_document_line_id IS NOT NULL THEN

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

430: END IF;
431: l_progress := '018';
432:
433: IF p_document_line_id IS NOT NULL THEN
434: dbms_sql.bind_variable(l_cursor, ':document_line_id', p_document_line_id);
435: END IF;
436: l_progress := '019';
437:
438: IF p_mol_rec.reference_id IS NOT NULL THEN

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

435: END IF;
436: l_progress := '019';
437:
438: IF p_mol_rec.reference_id IS NOT NULL THEN
439: dbms_sql.bind_variable(l_cursor, ':reference_id',p_mol_rec.reference_id);
440: END IF;
441: l_progress := '020';
442:
443:

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

440: END IF;
441: l_progress := '020';
442:
443:
444: dbms_sql.define_column(l_cursor, 1, l_receipt_num, 30);
445: l_progress := '020.5';
446: dbms_sql.define_column(l_cursor, 2, l_location_id);
447: dbms_sql.define_column(l_cursor, 3, l_vendor_id);
448: dbms_sql.define_column(l_cursor, 4, l_from_organization_id);

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

442:
443:
444: dbms_sql.define_column(l_cursor, 1, l_receipt_num, 30);
445: l_progress := '020.5';
446: dbms_sql.define_column(l_cursor, 2, l_location_id);
447: dbms_sql.define_column(l_cursor, 3, l_vendor_id);
448: dbms_sql.define_column(l_cursor, 4, l_from_organization_id);
449: dbms_sql.define_column(l_cursor, 5, l_rcv_transaction_id);
450:

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

443:
444: dbms_sql.define_column(l_cursor, 1, l_receipt_num, 30);
445: l_progress := '020.5';
446: dbms_sql.define_column(l_cursor, 2, l_location_id);
447: dbms_sql.define_column(l_cursor, 3, l_vendor_id);
448: dbms_sql.define_column(l_cursor, 4, l_from_organization_id);
449: dbms_sql.define_column(l_cursor, 5, l_rcv_transaction_id);
450:
451: l_progress := '021';

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

444: dbms_sql.define_column(l_cursor, 1, l_receipt_num, 30);
445: l_progress := '020.5';
446: dbms_sql.define_column(l_cursor, 2, l_location_id);
447: dbms_sql.define_column(l_cursor, 3, l_vendor_id);
448: dbms_sql.define_column(l_cursor, 4, l_from_organization_id);
449: dbms_sql.define_column(l_cursor, 5, l_rcv_transaction_id);
450:
451: l_progress := '021';
452:

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

445: l_progress := '020.5';
446: dbms_sql.define_column(l_cursor, 2, l_location_id);
447: dbms_sql.define_column(l_cursor, 3, l_vendor_id);
448: dbms_sql.define_column(l_cursor, 4, l_from_organization_id);
449: dbms_sql.define_column(l_cursor, 5, l_rcv_transaction_id);
450:
451: l_progress := '021';
452:
453: IF (l_debug = 1) THEN

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

452:
453: IF (l_debug = 1) THEN
454: trace('Excute query');
455: END IF;
456: l_return := dbms_sql.execute(l_cursor);
457: IF (l_debug = 1) THEN
458: trace('Executed query');
459: END IF;
460: l_progress := '022';

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

466: l_partner_exists := 0;
467: l_partner_unique := 1;
468:
469: LOOP
470: IF DBMS_SQL.FETCH_ROWS(l_cursor) = 0 THEN
471: EXIT;
472: END IF;
473:
474: x_valid := 'Y';

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

472: END IF;
473:
474: x_valid := 'Y';
475:
476: dbms_sql.column_value(l_cursor, 1, l_receipt_num);
477: dbms_sql.column_value(l_cursor, 2, l_location_id);
478: dbms_sql.column_value(l_cursor, 3, l_vendor_id);
479: dbms_sql.column_value(l_cursor, 4, l_from_organization_id);
480: dbms_sql.column_value(l_cursor, 5, l_rcv_transaction_id);

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

473:
474: x_valid := 'Y';
475:
476: dbms_sql.column_value(l_cursor, 1, l_receipt_num);
477: dbms_sql.column_value(l_cursor, 2, l_location_id);
478: dbms_sql.column_value(l_cursor, 3, l_vendor_id);
479: dbms_sql.column_value(l_cursor, 4, l_from_organization_id);
480: dbms_sql.column_value(l_cursor, 5, l_rcv_transaction_id);
481:

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

474: x_valid := 'Y';
475:
476: dbms_sql.column_value(l_cursor, 1, l_receipt_num);
477: dbms_sql.column_value(l_cursor, 2, l_location_id);
478: dbms_sql.column_value(l_cursor, 3, l_vendor_id);
479: dbms_sql.column_value(l_cursor, 4, l_from_organization_id);
480: dbms_sql.column_value(l_cursor, 5, l_rcv_transaction_id);
481:
482: IF (l_debug = 1) THEN

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

475:
476: dbms_sql.column_value(l_cursor, 1, l_receipt_num);
477: dbms_sql.column_value(l_cursor, 2, l_location_id);
478: dbms_sql.column_value(l_cursor, 3, l_vendor_id);
479: dbms_sql.column_value(l_cursor, 4, l_from_organization_id);
480: dbms_sql.column_value(l_cursor, 5, l_rcv_transaction_id);
481:
482: IF (l_debug = 1) THEN
483: trace('rcv_transaction_id:'||l_rcv_transaction_id||

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

476: dbms_sql.column_value(l_cursor, 1, l_receipt_num);
477: dbms_sql.column_value(l_cursor, 2, l_location_id);
478: dbms_sql.column_value(l_cursor, 3, l_vendor_id);
479: dbms_sql.column_value(l_cursor, 4, l_from_organization_id);
480: dbms_sql.column_value(l_cursor, 5, l_rcv_transaction_id);
481:
482: IF (l_debug = 1) THEN
483: trace('rcv_transaction_id:'||l_rcv_transaction_id||
484: ' receipt_num:'||l_receipt_num||

Line 565: dbms_sql.close_cursor(l_cursor);

561:
562:
563: END LOOP;
564:
565: dbms_sql.close_cursor(l_cursor);
566:
567: IF (l_debug = 1) THEN
568: trace('l_location_exists:'||l_location_exists||
569: ' l_location_unique:'||l_location_unique||

Line 644: dbms_sql.close_cursor(l_cursor);

640: trace('Error in query_inbound_material(), progress='||l_progress);
641: trace('ERROR CODE = ' || SQLCODE);
642: trace('ERROR MESSAGE = ' || SQLERRM);
643: END IF;
644: dbms_sql.close_cursor(l_cursor);
645:
646: x_valid := 'N';
647: END check_against_rcv;
648:

Line 998: l_cursor := dbms_sql.open_cursor;

994: /* Step 2, Build Cusor, Bind variables */
995: IF l_debug =1 THEN
996: trace('Finished building SQL, start build cursor');
997: END IF;
998: l_cursor := dbms_sql.open_cursor;
999: l_progress := '030';
1000: BEGIN
1001: dbms_sql.parse(l_cursor,l_query_sql,dbms_sql.v7);
1002: EXCEPTION

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

997: END IF;
998: l_cursor := dbms_sql.open_cursor;
999: l_progress := '030';
1000: BEGIN
1001: dbms_sql.parse(l_cursor,l_query_sql,dbms_sql.v7);
1002: EXCEPTION
1003: WHEN OTHERS THEN
1004: l_last_error_pos := dbms_sql.last_error_position();
1005: l_temp_str := Substr(l_query_sql, l_last_error_pos-5, 50);

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

1000: BEGIN
1001: dbms_sql.parse(l_cursor,l_query_sql,dbms_sql.v7);
1002: EXCEPTION
1003: WHEN OTHERS THEN
1004: l_last_error_pos := dbms_sql.last_error_position();
1005: l_temp_str := Substr(l_query_sql, l_last_error_pos-5, 50);
1006: IF l_debug = 1 THEN
1007: trace('Error in parse sql statement, at '||l_temp_str);
1008: END IF;

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

1013: IF l_debug =1 THEN
1014: trace('Binding variables');
1015: END IF;
1016: -- Bind variables
1017: dbms_sql.bind_variable(l_cursor, ':org_id', p_organization_id);
1018: dbms_sql.bind_variable(l_cursor, ':org_code', p_organization_code);
1019: dbms_sql.bind_variable(l_cursor, ':inventory_item_id', p_inventory_item_id);
1020: dbms_sql.bind_variable(l_cursor, ':item', p_item);
1021: dbms_sql.bind_variable(l_cursor, ':project_id', p_project_id);

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

1014: trace('Binding variables');
1015: END IF;
1016: -- Bind variables
1017: dbms_sql.bind_variable(l_cursor, ':org_id', p_organization_id);
1018: dbms_sql.bind_variable(l_cursor, ':org_code', p_organization_code);
1019: dbms_sql.bind_variable(l_cursor, ':inventory_item_id', p_inventory_item_id);
1020: dbms_sql.bind_variable(l_cursor, ':item', p_item);
1021: dbms_sql.bind_variable(l_cursor, ':project_id', p_project_id);
1022: dbms_sql.bind_variable(l_cursor, ':project', p_project);

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

1015: END IF;
1016: -- Bind variables
1017: dbms_sql.bind_variable(l_cursor, ':org_id', p_organization_id);
1018: dbms_sql.bind_variable(l_cursor, ':org_code', p_organization_code);
1019: dbms_sql.bind_variable(l_cursor, ':inventory_item_id', p_inventory_item_id);
1020: dbms_sql.bind_variable(l_cursor, ':item', p_item);
1021: dbms_sql.bind_variable(l_cursor, ':project_id', p_project_id);
1022: dbms_sql.bind_variable(l_cursor, ':project', p_project);
1023: dbms_sql.bind_variable(l_cursor, ':task_id', p_task_id);

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

1016: -- Bind variables
1017: dbms_sql.bind_variable(l_cursor, ':org_id', p_organization_id);
1018: dbms_sql.bind_variable(l_cursor, ':org_code', p_organization_code);
1019: dbms_sql.bind_variable(l_cursor, ':inventory_item_id', p_inventory_item_id);
1020: dbms_sql.bind_variable(l_cursor, ':item', p_item);
1021: dbms_sql.bind_variable(l_cursor, ':project_id', p_project_id);
1022: dbms_sql.bind_variable(l_cursor, ':project', p_project);
1023: dbms_sql.bind_variable(l_cursor, ':task_id', p_task_id);
1024: dbms_sql.bind_variable(l_cursor, ':task', p_task);

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

1017: dbms_sql.bind_variable(l_cursor, ':org_id', p_organization_id);
1018: dbms_sql.bind_variable(l_cursor, ':org_code', p_organization_code);
1019: dbms_sql.bind_variable(l_cursor, ':inventory_item_id', p_inventory_item_id);
1020: dbms_sql.bind_variable(l_cursor, ':item', p_item);
1021: dbms_sql.bind_variable(l_cursor, ':project_id', p_project_id);
1022: dbms_sql.bind_variable(l_cursor, ':project', p_project);
1023: dbms_sql.bind_variable(l_cursor, ':task_id', p_task_id);
1024: dbms_sql.bind_variable(l_cursor, ':task', p_task);
1025: l_progress := '050';

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

1018: dbms_sql.bind_variable(l_cursor, ':org_code', p_organization_code);
1019: dbms_sql.bind_variable(l_cursor, ':inventory_item_id', p_inventory_item_id);
1020: dbms_sql.bind_variable(l_cursor, ':item', p_item);
1021: dbms_sql.bind_variable(l_cursor, ':project_id', p_project_id);
1022: dbms_sql.bind_variable(l_cursor, ':project', p_project);
1023: dbms_sql.bind_variable(l_cursor, ':task_id', p_task_id);
1024: dbms_sql.bind_variable(l_cursor, ':task', p_task);
1025: l_progress := '050';
1026: IF p_subinventory_code IS NOT NULL THEN

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

1019: dbms_sql.bind_variable(l_cursor, ':inventory_item_id', p_inventory_item_id);
1020: dbms_sql.bind_variable(l_cursor, ':item', p_item);
1021: dbms_sql.bind_variable(l_cursor, ':project_id', p_project_id);
1022: dbms_sql.bind_variable(l_cursor, ':project', p_project);
1023: dbms_sql.bind_variable(l_cursor, ':task_id', p_task_id);
1024: dbms_sql.bind_variable(l_cursor, ':task', p_task);
1025: l_progress := '050';
1026: IF p_subinventory_code IS NOT NULL THEN
1027: dbms_sql.bind_variable(l_cursor, ':subinventory', p_subinventory_code);

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

1020: dbms_sql.bind_variable(l_cursor, ':item', p_item);
1021: dbms_sql.bind_variable(l_cursor, ':project_id', p_project_id);
1022: dbms_sql.bind_variable(l_cursor, ':project', p_project);
1023: dbms_sql.bind_variable(l_cursor, ':task_id', p_task_id);
1024: dbms_sql.bind_variable(l_cursor, ':task', p_task);
1025: l_progress := '050';
1026: IF p_subinventory_code IS NOT NULL THEN
1027: dbms_sql.bind_variable(l_cursor, ':subinventory', p_subinventory_code);
1028: END IF;

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

1023: dbms_sql.bind_variable(l_cursor, ':task_id', p_task_id);
1024: dbms_sql.bind_variable(l_cursor, ':task', p_task);
1025: l_progress := '050';
1026: IF p_subinventory_code IS NOT NULL THEN
1027: dbms_sql.bind_variable(l_cursor, ':subinventory', p_subinventory_code);
1028: END IF;
1029: IF p_locator_id IS NOT NULL THEN
1030: dbms_sql.bind_variable(l_cursor, ':locator_id', p_locator_id);
1031: END IF;

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

1026: IF p_subinventory_code IS NOT NULL THEN
1027: dbms_sql.bind_variable(l_cursor, ':subinventory', p_subinventory_code);
1028: END IF;
1029: IF p_locator_id IS NOT NULL THEN
1030: dbms_sql.bind_variable(l_cursor, ':locator_id', p_locator_id);
1031: END IF;
1032: dbms_sql.bind_variable(l_cursor, ':locator', p_locator);
1033: IF p_from_lpn_id IS NOT NULL THEN
1034: dbms_sql.bind_variable(l_cursor, ':from_lpn_id', p_from_lpn_id);

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

1028: END IF;
1029: IF p_locator_id IS NOT NULL THEN
1030: dbms_sql.bind_variable(l_cursor, ':locator_id', p_locator_id);
1031: END IF;
1032: dbms_sql.bind_variable(l_cursor, ':locator', p_locator);
1033: IF p_from_lpn_id IS NOT NULL THEN
1034: dbms_sql.bind_variable(l_cursor, ':from_lpn_id', p_from_lpn_id);
1035: END IF;
1036:

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

1030: dbms_sql.bind_variable(l_cursor, ':locator_id', p_locator_id);
1031: END IF;
1032: dbms_sql.bind_variable(l_cursor, ':locator', p_locator);
1033: IF p_from_lpn_id IS NOT NULL THEN
1034: dbms_sql.bind_variable(l_cursor, ':from_lpn_id', p_from_lpn_id);
1035: END IF;
1036:
1037: IF p_document_id IS NOT NULL AND l_doc_num_used = 1 THEN
1038: dbms_sql.bind_variable(l_cursor, ':doc_num_id', p_document_id);

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

1034: dbms_sql.bind_variable(l_cursor, ':from_lpn_id', p_from_lpn_id);
1035: END IF;
1036:
1037: IF p_document_id IS NOT NULL AND l_doc_num_used = 1 THEN
1038: dbms_sql.bind_variable(l_cursor, ':doc_num_id', p_document_id);
1039: END IF;
1040:
1041: IF p_document_line_id IS NOT NULL AND l_doc_line_used = 1 THEN
1042: dbms_sql.bind_variable(l_cursor, ':doc_line_id', p_document_line_id);

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

1038: dbms_sql.bind_variable(l_cursor, ':doc_num_id', p_document_id);
1039: END IF;
1040:
1041: IF p_document_line_id IS NOT NULL AND l_doc_line_used = 1 THEN
1042: dbms_sql.bind_variable(l_cursor, ':doc_line_id', p_document_line_id);
1043: END IF;
1044:
1045: IF (p_receipt_number IS NOT NULL AND l_receipt_used = 1) THEN
1046: dbms_sql.bind_variable(l_cursor, ':receipt_num', p_receipt_number);

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

1042: dbms_sql.bind_variable(l_cursor, ':doc_line_id', p_document_line_id);
1043: END IF;
1044:
1045: IF (p_receipt_number IS NOT NULL AND l_receipt_used = 1) THEN
1046: dbms_sql.bind_variable(l_cursor, ':receipt_num', p_receipt_number);
1047: END IF;
1048:
1049: l_progress := '060';
1050:

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

1052: IF l_debug = 1 THEN
1053: trace('Execute the query');
1054: END IF;
1055: --Define output parameters
1056: dbms_sql.define_column(l_cursor, 1, l_mol_header_id);
1057: dbms_sql.define_column(l_cursor, 2, l_mol_line_id);
1058: dbms_sql.define_column(l_cursor, 3, l_reference,240);
1059: dbms_sql.define_column(l_cursor, 4, l_reference_id);
1060: dbms_sql.define_column(l_cursor, 5, l_txn_source_id);

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

1053: trace('Execute the query');
1054: END IF;
1055: --Define output parameters
1056: dbms_sql.define_column(l_cursor, 1, l_mol_header_id);
1057: dbms_sql.define_column(l_cursor, 2, l_mol_line_id);
1058: dbms_sql.define_column(l_cursor, 3, l_reference,240);
1059: dbms_sql.define_column(l_cursor, 4, l_reference_id);
1060: dbms_sql.define_column(l_cursor, 5, l_txn_source_id);
1061: dbms_sql.define_column(l_cursor, 6, l_organization_id);

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

1054: END IF;
1055: --Define output parameters
1056: dbms_sql.define_column(l_cursor, 1, l_mol_header_id);
1057: dbms_sql.define_column(l_cursor, 2, l_mol_line_id);
1058: dbms_sql.define_column(l_cursor, 3, l_reference,240);
1059: dbms_sql.define_column(l_cursor, 4, l_reference_id);
1060: dbms_sql.define_column(l_cursor, 5, l_txn_source_id);
1061: dbms_sql.define_column(l_cursor, 6, l_organization_id);
1062: dbms_sql.define_column(l_cursor, 7, l_organization_code,3);

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

1055: --Define output parameters
1056: dbms_sql.define_column(l_cursor, 1, l_mol_header_id);
1057: dbms_sql.define_column(l_cursor, 2, l_mol_line_id);
1058: dbms_sql.define_column(l_cursor, 3, l_reference,240);
1059: dbms_sql.define_column(l_cursor, 4, l_reference_id);
1060: dbms_sql.define_column(l_cursor, 5, l_txn_source_id);
1061: dbms_sql.define_column(l_cursor, 6, l_organization_id);
1062: dbms_sql.define_column(l_cursor, 7, l_organization_code,3);
1063: dbms_sql.define_column(l_cursor, 8, l_subinventory,10);

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

1056: dbms_sql.define_column(l_cursor, 1, l_mol_header_id);
1057: dbms_sql.define_column(l_cursor, 2, l_mol_line_id);
1058: dbms_sql.define_column(l_cursor, 3, l_reference,240);
1059: dbms_sql.define_column(l_cursor, 4, l_reference_id);
1060: dbms_sql.define_column(l_cursor, 5, l_txn_source_id);
1061: dbms_sql.define_column(l_cursor, 6, l_organization_id);
1062: dbms_sql.define_column(l_cursor, 7, l_organization_code,3);
1063: dbms_sql.define_column(l_cursor, 8, l_subinventory,10);
1064: dbms_sql.define_column(l_cursor, 9, l_locator_id);

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

1057: dbms_sql.define_column(l_cursor, 2, l_mol_line_id);
1058: dbms_sql.define_column(l_cursor, 3, l_reference,240);
1059: dbms_sql.define_column(l_cursor, 4, l_reference_id);
1060: dbms_sql.define_column(l_cursor, 5, l_txn_source_id);
1061: dbms_sql.define_column(l_cursor, 6, l_organization_id);
1062: dbms_sql.define_column(l_cursor, 7, l_organization_code,3);
1063: dbms_sql.define_column(l_cursor, 8, l_subinventory,10);
1064: dbms_sql.define_column(l_cursor, 9, l_locator_id);
1065: dbms_sql.define_column(l_cursor, 10,l_locator,204);

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

1058: dbms_sql.define_column(l_cursor, 3, l_reference,240);
1059: dbms_sql.define_column(l_cursor, 4, l_reference_id);
1060: dbms_sql.define_column(l_cursor, 5, l_txn_source_id);
1061: dbms_sql.define_column(l_cursor, 6, l_organization_id);
1062: dbms_sql.define_column(l_cursor, 7, l_organization_code,3);
1063: dbms_sql.define_column(l_cursor, 8, l_subinventory,10);
1064: dbms_sql.define_column(l_cursor, 9, l_locator_id);
1065: dbms_sql.define_column(l_cursor, 10,l_locator,204);
1066: dbms_sql.define_column(l_cursor, 11, l_project_id);

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

1059: dbms_sql.define_column(l_cursor, 4, l_reference_id);
1060: dbms_sql.define_column(l_cursor, 5, l_txn_source_id);
1061: dbms_sql.define_column(l_cursor, 6, l_organization_id);
1062: dbms_sql.define_column(l_cursor, 7, l_organization_code,3);
1063: dbms_sql.define_column(l_cursor, 8, l_subinventory,10);
1064: dbms_sql.define_column(l_cursor, 9, l_locator_id);
1065: dbms_sql.define_column(l_cursor, 10,l_locator,204);
1066: dbms_sql.define_column(l_cursor, 11, l_project_id);
1067: dbms_sql.define_column(l_cursor, 12, l_project,30);

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

1060: dbms_sql.define_column(l_cursor, 5, l_txn_source_id);
1061: dbms_sql.define_column(l_cursor, 6, l_organization_id);
1062: dbms_sql.define_column(l_cursor, 7, l_organization_code,3);
1063: dbms_sql.define_column(l_cursor, 8, l_subinventory,10);
1064: dbms_sql.define_column(l_cursor, 9, l_locator_id);
1065: dbms_sql.define_column(l_cursor, 10,l_locator,204);
1066: dbms_sql.define_column(l_cursor, 11, l_project_id);
1067: dbms_sql.define_column(l_cursor, 12, l_project,30);
1068: dbms_sql.define_column(l_cursor, 13, l_task_id);

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

1061: dbms_sql.define_column(l_cursor, 6, l_organization_id);
1062: dbms_sql.define_column(l_cursor, 7, l_organization_code,3);
1063: dbms_sql.define_column(l_cursor, 8, l_subinventory,10);
1064: dbms_sql.define_column(l_cursor, 9, l_locator_id);
1065: dbms_sql.define_column(l_cursor, 10,l_locator,204);
1066: dbms_sql.define_column(l_cursor, 11, l_project_id);
1067: dbms_sql.define_column(l_cursor, 12, l_project,30);
1068: dbms_sql.define_column(l_cursor, 13, l_task_id);
1069: dbms_sql.define_column(l_cursor, 14, l_task,30);

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

1062: dbms_sql.define_column(l_cursor, 7, l_organization_code,3);
1063: dbms_sql.define_column(l_cursor, 8, l_subinventory,10);
1064: dbms_sql.define_column(l_cursor, 9, l_locator_id);
1065: dbms_sql.define_column(l_cursor, 10,l_locator,204);
1066: dbms_sql.define_column(l_cursor, 11, l_project_id);
1067: dbms_sql.define_column(l_cursor, 12, l_project,30);
1068: dbms_sql.define_column(l_cursor, 13, l_task_id);
1069: dbms_sql.define_column(l_cursor, 14, l_task,30);
1070: dbms_sql.define_column(l_cursor, 15, l_inventory_item_id);

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

1063: dbms_sql.define_column(l_cursor, 8, l_subinventory,10);
1064: dbms_sql.define_column(l_cursor, 9, l_locator_id);
1065: dbms_sql.define_column(l_cursor, 10,l_locator,204);
1066: dbms_sql.define_column(l_cursor, 11, l_project_id);
1067: dbms_sql.define_column(l_cursor, 12, l_project,30);
1068: dbms_sql.define_column(l_cursor, 13, l_task_id);
1069: dbms_sql.define_column(l_cursor, 14, l_task,30);
1070: dbms_sql.define_column(l_cursor, 15, l_inventory_item_id);
1071: dbms_sql.define_column(l_cursor, 16, l_item,40);

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

1064: dbms_sql.define_column(l_cursor, 9, l_locator_id);
1065: dbms_sql.define_column(l_cursor, 10,l_locator,204);
1066: dbms_sql.define_column(l_cursor, 11, l_project_id);
1067: dbms_sql.define_column(l_cursor, 12, l_project,30);
1068: dbms_sql.define_column(l_cursor, 13, l_task_id);
1069: dbms_sql.define_column(l_cursor, 14, l_task,30);
1070: dbms_sql.define_column(l_cursor, 15, l_inventory_item_id);
1071: dbms_sql.define_column(l_cursor, 16, l_item,40);
1072: dbms_sql.define_column(l_cursor, 17, l_lpn_id);

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

1065: dbms_sql.define_column(l_cursor, 10,l_locator,204);
1066: dbms_sql.define_column(l_cursor, 11, l_project_id);
1067: dbms_sql.define_column(l_cursor, 12, l_project,30);
1068: dbms_sql.define_column(l_cursor, 13, l_task_id);
1069: dbms_sql.define_column(l_cursor, 14, l_task,30);
1070: dbms_sql.define_column(l_cursor, 15, l_inventory_item_id);
1071: dbms_sql.define_column(l_cursor, 16, l_item,40);
1072: dbms_sql.define_column(l_cursor, 17, l_lpn_id);
1073: dbms_sql.define_column(l_cursor, 18, l_revision,3);

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

1066: dbms_sql.define_column(l_cursor, 11, l_project_id);
1067: dbms_sql.define_column(l_cursor, 12, l_project,30);
1068: dbms_sql.define_column(l_cursor, 13, l_task_id);
1069: dbms_sql.define_column(l_cursor, 14, l_task,30);
1070: dbms_sql.define_column(l_cursor, 15, l_inventory_item_id);
1071: dbms_sql.define_column(l_cursor, 16, l_item,40);
1072: dbms_sql.define_column(l_cursor, 17, l_lpn_id);
1073: dbms_sql.define_column(l_cursor, 18, l_revision,3);
1074: dbms_sql.define_column(l_cursor, 19, l_uom,3);

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

1067: dbms_sql.define_column(l_cursor, 12, l_project,30);
1068: dbms_sql.define_column(l_cursor, 13, l_task_id);
1069: dbms_sql.define_column(l_cursor, 14, l_task,30);
1070: dbms_sql.define_column(l_cursor, 15, l_inventory_item_id);
1071: dbms_sql.define_column(l_cursor, 16, l_item,40);
1072: dbms_sql.define_column(l_cursor, 17, l_lpn_id);
1073: dbms_sql.define_column(l_cursor, 18, l_revision,3);
1074: dbms_sql.define_column(l_cursor, 19, l_uom,3);
1075: dbms_sql.define_column(l_cursor, 20, l_qty);

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

1068: dbms_sql.define_column(l_cursor, 13, l_task_id);
1069: dbms_sql.define_column(l_cursor, 14, l_task,30);
1070: dbms_sql.define_column(l_cursor, 15, l_inventory_item_id);
1071: dbms_sql.define_column(l_cursor, 16, l_item,40);
1072: dbms_sql.define_column(l_cursor, 17, l_lpn_id);
1073: dbms_sql.define_column(l_cursor, 18, l_revision,3);
1074: dbms_sql.define_column(l_cursor, 19, l_uom,3);
1075: dbms_sql.define_column(l_cursor, 20, l_qty);
1076: dbms_sql.define_column(l_cursor, 21, l_lot, 30);

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

1069: dbms_sql.define_column(l_cursor, 14, l_task,30);
1070: dbms_sql.define_column(l_cursor, 15, l_inventory_item_id);
1071: dbms_sql.define_column(l_cursor, 16, l_item,40);
1072: dbms_sql.define_column(l_cursor, 17, l_lpn_id);
1073: dbms_sql.define_column(l_cursor, 18, l_revision,3);
1074: dbms_sql.define_column(l_cursor, 19, l_uom,3);
1075: dbms_sql.define_column(l_cursor, 20, l_qty);
1076: dbms_sql.define_column(l_cursor, 21, l_lot, 30);
1077: --INVCONV kkillams

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

1070: dbms_sql.define_column(l_cursor, 15, l_inventory_item_id);
1071: dbms_sql.define_column(l_cursor, 16, l_item,40);
1072: dbms_sql.define_column(l_cursor, 17, l_lpn_id);
1073: dbms_sql.define_column(l_cursor, 18, l_revision,3);
1074: dbms_sql.define_column(l_cursor, 19, l_uom,3);
1075: dbms_sql.define_column(l_cursor, 20, l_qty);
1076: dbms_sql.define_column(l_cursor, 21, l_lot, 30);
1077: --INVCONV kkillams
1078: dbms_sql.define_column(l_cursor, 22, l_sec_qty);

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

1071: dbms_sql.define_column(l_cursor, 16, l_item,40);
1072: dbms_sql.define_column(l_cursor, 17, l_lpn_id);
1073: dbms_sql.define_column(l_cursor, 18, l_revision,3);
1074: dbms_sql.define_column(l_cursor, 19, l_uom,3);
1075: dbms_sql.define_column(l_cursor, 20, l_qty);
1076: dbms_sql.define_column(l_cursor, 21, l_lot, 30);
1077: --INVCONV kkillams
1078: dbms_sql.define_column(l_cursor, 22, l_sec_qty);
1079: dbms_sql.define_column(l_cursor, 23, l_sec_uom,3);

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

1072: dbms_sql.define_column(l_cursor, 17, l_lpn_id);
1073: dbms_sql.define_column(l_cursor, 18, l_revision,3);
1074: dbms_sql.define_column(l_cursor, 19, l_uom,3);
1075: dbms_sql.define_column(l_cursor, 20, l_qty);
1076: dbms_sql.define_column(l_cursor, 21, l_lot, 30);
1077: --INVCONV kkillams
1078: dbms_sql.define_column(l_cursor, 22, l_sec_qty);
1079: dbms_sql.define_column(l_cursor, 23, l_sec_uom,3);
1080: dbms_sql.define_column(l_cursor, 24, l_grade,150);

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

1074: dbms_sql.define_column(l_cursor, 19, l_uom,3);
1075: dbms_sql.define_column(l_cursor, 20, l_qty);
1076: dbms_sql.define_column(l_cursor, 21, l_lot, 30);
1077: --INVCONV kkillams
1078: dbms_sql.define_column(l_cursor, 22, l_sec_qty);
1079: dbms_sql.define_column(l_cursor, 23, l_sec_uom,3);
1080: dbms_sql.define_column(l_cursor, 24, l_grade,150);
1081: --END INVCONV kkillams
1082: dbms_sql.define_column(l_cursor, 25, l_rcv_location_id);

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

1075: dbms_sql.define_column(l_cursor, 20, l_qty);
1076: dbms_sql.define_column(l_cursor, 21, l_lot, 30);
1077: --INVCONV kkillams
1078: dbms_sql.define_column(l_cursor, 22, l_sec_qty);
1079: dbms_sql.define_column(l_cursor, 23, l_sec_uom,3);
1080: dbms_sql.define_column(l_cursor, 24, l_grade,150);
1081: --END INVCONV kkillams
1082: dbms_sql.define_column(l_cursor, 25, l_rcv_location_id);
1083: dbms_sql.define_column(l_cursor, 26, l_rcv_location,60);

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

1076: dbms_sql.define_column(l_cursor, 21, l_lot, 30);
1077: --INVCONV kkillams
1078: dbms_sql.define_column(l_cursor, 22, l_sec_qty);
1079: dbms_sql.define_column(l_cursor, 23, l_sec_uom,3);
1080: dbms_sql.define_column(l_cursor, 24, l_grade,150);
1081: --END INVCONV kkillams
1082: dbms_sql.define_column(l_cursor, 25, l_rcv_location_id);
1083: dbms_sql.define_column(l_cursor, 26, l_rcv_location,60);
1084: dbms_sql.define_column(l_cursor, 27, l_vendor_id);

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

1078: dbms_sql.define_column(l_cursor, 22, l_sec_qty);
1079: dbms_sql.define_column(l_cursor, 23, l_sec_uom,3);
1080: dbms_sql.define_column(l_cursor, 24, l_grade,150);
1081: --END INVCONV kkillams
1082: dbms_sql.define_column(l_cursor, 25, l_rcv_location_id);
1083: dbms_sql.define_column(l_cursor, 26, l_rcv_location,60);
1084: dbms_sql.define_column(l_cursor, 27, l_vendor_id);
1085: dbms_sql.define_column(l_cursor, 28, l_src_org_id);
1086: dbms_sql.define_column(l_cursor, 29, l_partner_name,240);

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

1079: dbms_sql.define_column(l_cursor, 23, l_sec_uom,3);
1080: dbms_sql.define_column(l_cursor, 24, l_grade,150);
1081: --END INVCONV kkillams
1082: dbms_sql.define_column(l_cursor, 25, l_rcv_location_id);
1083: dbms_sql.define_column(l_cursor, 26, l_rcv_location,60);
1084: dbms_sql.define_column(l_cursor, 27, l_vendor_id);
1085: dbms_sql.define_column(l_cursor, 28, l_src_org_id);
1086: dbms_sql.define_column(l_cursor, 29, l_partner_name,240);
1087: dbms_sql.define_column(l_cursor, 30, l_doc_type,20);

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

1080: dbms_sql.define_column(l_cursor, 24, l_grade,150);
1081: --END INVCONV kkillams
1082: dbms_sql.define_column(l_cursor, 25, l_rcv_location_id);
1083: dbms_sql.define_column(l_cursor, 26, l_rcv_location,60);
1084: dbms_sql.define_column(l_cursor, 27, l_vendor_id);
1085: dbms_sql.define_column(l_cursor, 28, l_src_org_id);
1086: dbms_sql.define_column(l_cursor, 29, l_partner_name,240);
1087: dbms_sql.define_column(l_cursor, 30, l_doc_type,20);
1088: dbms_sql.define_column(l_cursor, 31, l_doc_num_id);

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

1081: --END INVCONV kkillams
1082: dbms_sql.define_column(l_cursor, 25, l_rcv_location_id);
1083: dbms_sql.define_column(l_cursor, 26, l_rcv_location,60);
1084: dbms_sql.define_column(l_cursor, 27, l_vendor_id);
1085: dbms_sql.define_column(l_cursor, 28, l_src_org_id);
1086: dbms_sql.define_column(l_cursor, 29, l_partner_name,240);
1087: dbms_sql.define_column(l_cursor, 30, l_doc_type,20);
1088: dbms_sql.define_column(l_cursor, 31, l_doc_num_id);
1089: dbms_sql.define_column(l_cursor, 32, l_document_number,50);

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

1082: dbms_sql.define_column(l_cursor, 25, l_rcv_location_id);
1083: dbms_sql.define_column(l_cursor, 26, l_rcv_location,60);
1084: dbms_sql.define_column(l_cursor, 27, l_vendor_id);
1085: dbms_sql.define_column(l_cursor, 28, l_src_org_id);
1086: dbms_sql.define_column(l_cursor, 29, l_partner_name,240);
1087: dbms_sql.define_column(l_cursor, 30, l_doc_type,20);
1088: dbms_sql.define_column(l_cursor, 31, l_doc_num_id);
1089: dbms_sql.define_column(l_cursor, 32, l_document_number,50);
1090: dbms_sql.define_column(l_cursor, 33, l_receipt_num,30);

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

1083: dbms_sql.define_column(l_cursor, 26, l_rcv_location,60);
1084: dbms_sql.define_column(l_cursor, 27, l_vendor_id);
1085: dbms_sql.define_column(l_cursor, 28, l_src_org_id);
1086: dbms_sql.define_column(l_cursor, 29, l_partner_name,240);
1087: dbms_sql.define_column(l_cursor, 30, l_doc_type,20);
1088: dbms_sql.define_column(l_cursor, 31, l_doc_num_id);
1089: dbms_sql.define_column(l_cursor, 32, l_document_number,50);
1090: dbms_sql.define_column(l_cursor, 33, l_receipt_num,30);
1091: dbms_sql.define_column(l_cursor, 34, l_doc_line_id);

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

1084: dbms_sql.define_column(l_cursor, 27, l_vendor_id);
1085: dbms_sql.define_column(l_cursor, 28, l_src_org_id);
1086: dbms_sql.define_column(l_cursor, 29, l_partner_name,240);
1087: dbms_sql.define_column(l_cursor, 30, l_doc_type,20);
1088: dbms_sql.define_column(l_cursor, 31, l_doc_num_id);
1089: dbms_sql.define_column(l_cursor, 32, l_document_number,50);
1090: dbms_sql.define_column(l_cursor, 33, l_receipt_num,30);
1091: dbms_sql.define_column(l_cursor, 34, l_doc_line_id);
1092: dbms_sql.define_column(l_cursor, 35, l_doc_line_num);

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

1085: dbms_sql.define_column(l_cursor, 28, l_src_org_id);
1086: dbms_sql.define_column(l_cursor, 29, l_partner_name,240);
1087: dbms_sql.define_column(l_cursor, 30, l_doc_type,20);
1088: dbms_sql.define_column(l_cursor, 31, l_doc_num_id);
1089: dbms_sql.define_column(l_cursor, 32, l_document_number,50);
1090: dbms_sql.define_column(l_cursor, 33, l_receipt_num,30);
1091: dbms_sql.define_column(l_cursor, 34, l_doc_line_id);
1092: dbms_sql.define_column(l_cursor, 35, l_doc_line_num);
1093:

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

1086: dbms_sql.define_column(l_cursor, 29, l_partner_name,240);
1087: dbms_sql.define_column(l_cursor, 30, l_doc_type,20);
1088: dbms_sql.define_column(l_cursor, 31, l_doc_num_id);
1089: dbms_sql.define_column(l_cursor, 32, l_document_number,50);
1090: dbms_sql.define_column(l_cursor, 33, l_receipt_num,30);
1091: dbms_sql.define_column(l_cursor, 34, l_doc_line_id);
1092: dbms_sql.define_column(l_cursor, 35, l_doc_line_num);
1093:
1094:

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

1087: dbms_sql.define_column(l_cursor, 30, l_doc_type,20);
1088: dbms_sql.define_column(l_cursor, 31, l_doc_num_id);
1089: dbms_sql.define_column(l_cursor, 32, l_document_number,50);
1090: dbms_sql.define_column(l_cursor, 33, l_receipt_num,30);
1091: dbms_sql.define_column(l_cursor, 34, l_doc_line_id);
1092: dbms_sql.define_column(l_cursor, 35, l_doc_line_num);
1093:
1094:
1095: l_progress := '070';

Line 1092: dbms_sql.define_column(l_cursor, 35, l_doc_line_num);

1088: dbms_sql.define_column(l_cursor, 31, l_doc_num_id);
1089: dbms_sql.define_column(l_cursor, 32, l_document_number,50);
1090: dbms_sql.define_column(l_cursor, 33, l_receipt_num,30);
1091: dbms_sql.define_column(l_cursor, 34, l_doc_line_id);
1092: dbms_sql.define_column(l_cursor, 35, l_doc_line_num);
1093:
1094:
1095: l_progress := '070';
1096: l_return := dbms_sql.execute(l_cursor);

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

1092: dbms_sql.define_column(l_cursor, 35, l_doc_line_num);
1093:
1094:
1095: l_progress := '070';
1096: l_return := dbms_sql.execute(l_cursor);
1097: l_progress := '080';
1098: IF l_debug = 1 THEN
1099: trace('Executed query');
1100: END IF;

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

1105: l_rec_count := 0;
1106: LOOP
1107: -- Fetch the rows into the buffer, and also check for the exit
1108: -- condition from the loop.
1109: IF DBMS_SQL.FETCH_ROWS(l_cursor) = 0 THEN
1110: EXIT;
1111: END IF;
1112: l_material_rec := l_null_material;
1113: -- Retrieve the rows from the buffer into temp variables.

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

1110: EXIT;
1111: END IF;
1112: l_material_rec := l_null_material;
1113: -- Retrieve the rows from the buffer into temp variables.
1114: dbms_sql.column_value(l_cursor, 1, l_material_rec.move_order_header_id);
1115: dbms_sql.column_value(l_cursor, 2, l_material_rec.move_order_line_id);
1116: dbms_sql.column_value(l_cursor, 3, l_material_rec.reference);
1117: dbms_sql.column_value(l_cursor, 4, l_material_rec.reference_id);
1118: dbms_sql.column_value(l_cursor, 5, l_material_rec.txn_source_id);

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

1111: END IF;
1112: l_material_rec := l_null_material;
1113: -- Retrieve the rows from the buffer into temp variables.
1114: dbms_sql.column_value(l_cursor, 1, l_material_rec.move_order_header_id);
1115: dbms_sql.column_value(l_cursor, 2, l_material_rec.move_order_line_id);
1116: dbms_sql.column_value(l_cursor, 3, l_material_rec.reference);
1117: dbms_sql.column_value(l_cursor, 4, l_material_rec.reference_id);
1118: dbms_sql.column_value(l_cursor, 5, l_material_rec.txn_source_id);
1119: dbms_sql.column_value(l_cursor, 6, l_material_rec.organization_id);

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

1112: l_material_rec := l_null_material;
1113: -- Retrieve the rows from the buffer into temp variables.
1114: dbms_sql.column_value(l_cursor, 1, l_material_rec.move_order_header_id);
1115: dbms_sql.column_value(l_cursor, 2, l_material_rec.move_order_line_id);
1116: dbms_sql.column_value(l_cursor, 3, l_material_rec.reference);
1117: dbms_sql.column_value(l_cursor, 4, l_material_rec.reference_id);
1118: dbms_sql.column_value(l_cursor, 5, l_material_rec.txn_source_id);
1119: dbms_sql.column_value(l_cursor, 6, l_material_rec.organization_id);
1120: dbms_sql.column_value(l_cursor, 7, l_material_rec.organization_code);

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

1113: -- Retrieve the rows from the buffer into temp variables.
1114: dbms_sql.column_value(l_cursor, 1, l_material_rec.move_order_header_id);
1115: dbms_sql.column_value(l_cursor, 2, l_material_rec.move_order_line_id);
1116: dbms_sql.column_value(l_cursor, 3, l_material_rec.reference);
1117: dbms_sql.column_value(l_cursor, 4, l_material_rec.reference_id);
1118: dbms_sql.column_value(l_cursor, 5, l_material_rec.txn_source_id);
1119: dbms_sql.column_value(l_cursor, 6, l_material_rec.organization_id);
1120: dbms_sql.column_value(l_cursor, 7, l_material_rec.organization_code);
1121: dbms_sql.column_value(l_cursor, 8, l_material_rec.subinventory);

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

1114: dbms_sql.column_value(l_cursor, 1, l_material_rec.move_order_header_id);
1115: dbms_sql.column_value(l_cursor, 2, l_material_rec.move_order_line_id);
1116: dbms_sql.column_value(l_cursor, 3, l_material_rec.reference);
1117: dbms_sql.column_value(l_cursor, 4, l_material_rec.reference_id);
1118: dbms_sql.column_value(l_cursor, 5, l_material_rec.txn_source_id);
1119: dbms_sql.column_value(l_cursor, 6, l_material_rec.organization_id);
1120: dbms_sql.column_value(l_cursor, 7, l_material_rec.organization_code);
1121: dbms_sql.column_value(l_cursor, 8, l_material_rec.subinventory);
1122: dbms_sql.column_value(l_cursor, 9, l_material_rec.locator_id);

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

1115: dbms_sql.column_value(l_cursor, 2, l_material_rec.move_order_line_id);
1116: dbms_sql.column_value(l_cursor, 3, l_material_rec.reference);
1117: dbms_sql.column_value(l_cursor, 4, l_material_rec.reference_id);
1118: dbms_sql.column_value(l_cursor, 5, l_material_rec.txn_source_id);
1119: dbms_sql.column_value(l_cursor, 6, l_material_rec.organization_id);
1120: dbms_sql.column_value(l_cursor, 7, l_material_rec.organization_code);
1121: dbms_sql.column_value(l_cursor, 8, l_material_rec.subinventory);
1122: dbms_sql.column_value(l_cursor, 9, l_material_rec.locator_id);
1123: dbms_sql.column_value(l_cursor, 10,l_material_rec.locator);

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

1116: dbms_sql.column_value(l_cursor, 3, l_material_rec.reference);
1117: dbms_sql.column_value(l_cursor, 4, l_material_rec.reference_id);
1118: dbms_sql.column_value(l_cursor, 5, l_material_rec.txn_source_id);
1119: dbms_sql.column_value(l_cursor, 6, l_material_rec.organization_id);
1120: dbms_sql.column_value(l_cursor, 7, l_material_rec.organization_code);
1121: dbms_sql.column_value(l_cursor, 8, l_material_rec.subinventory);
1122: dbms_sql.column_value(l_cursor, 9, l_material_rec.locator_id);
1123: dbms_sql.column_value(l_cursor, 10,l_material_rec.locator);
1124: dbms_sql.column_value(l_cursor, 11, l_material_rec.project_id);

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

1117: dbms_sql.column_value(l_cursor, 4, l_material_rec.reference_id);
1118: dbms_sql.column_value(l_cursor, 5, l_material_rec.txn_source_id);
1119: dbms_sql.column_value(l_cursor, 6, l_material_rec.organization_id);
1120: dbms_sql.column_value(l_cursor, 7, l_material_rec.organization_code);
1121: dbms_sql.column_value(l_cursor, 8, l_material_rec.subinventory);
1122: dbms_sql.column_value(l_cursor, 9, l_material_rec.locator_id);
1123: dbms_sql.column_value(l_cursor, 10,l_material_rec.locator);
1124: dbms_sql.column_value(l_cursor, 11, l_material_rec.project_id);
1125: dbms_sql.column_value(l_cursor, 12, l_material_rec.project);

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

1118: dbms_sql.column_value(l_cursor, 5, l_material_rec.txn_source_id);
1119: dbms_sql.column_value(l_cursor, 6, l_material_rec.organization_id);
1120: dbms_sql.column_value(l_cursor, 7, l_material_rec.organization_code);
1121: dbms_sql.column_value(l_cursor, 8, l_material_rec.subinventory);
1122: dbms_sql.column_value(l_cursor, 9, l_material_rec.locator_id);
1123: dbms_sql.column_value(l_cursor, 10,l_material_rec.locator);
1124: dbms_sql.column_value(l_cursor, 11, l_material_rec.project_id);
1125: dbms_sql.column_value(l_cursor, 12, l_material_rec.project);
1126: dbms_sql.column_value(l_cursor, 13, l_material_rec.task_id);

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

1119: dbms_sql.column_value(l_cursor, 6, l_material_rec.organization_id);
1120: dbms_sql.column_value(l_cursor, 7, l_material_rec.organization_code);
1121: dbms_sql.column_value(l_cursor, 8, l_material_rec.subinventory);
1122: dbms_sql.column_value(l_cursor, 9, l_material_rec.locator_id);
1123: dbms_sql.column_value(l_cursor, 10,l_material_rec.locator);
1124: dbms_sql.column_value(l_cursor, 11, l_material_rec.project_id);
1125: dbms_sql.column_value(l_cursor, 12, l_material_rec.project);
1126: dbms_sql.column_value(l_cursor, 13, l_material_rec.task_id);
1127: dbms_sql.column_value(l_cursor, 14, l_material_rec.task_number);

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

1120: dbms_sql.column_value(l_cursor, 7, l_material_rec.organization_code);
1121: dbms_sql.column_value(l_cursor, 8, l_material_rec.subinventory);
1122: dbms_sql.column_value(l_cursor, 9, l_material_rec.locator_id);
1123: dbms_sql.column_value(l_cursor, 10,l_material_rec.locator);
1124: dbms_sql.column_value(l_cursor, 11, l_material_rec.project_id);
1125: dbms_sql.column_value(l_cursor, 12, l_material_rec.project);
1126: dbms_sql.column_value(l_cursor, 13, l_material_rec.task_id);
1127: dbms_sql.column_value(l_cursor, 14, l_material_rec.task_number);
1128: dbms_sql.column_value(l_cursor, 15, l_material_rec.inventory_item_id);

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

1121: dbms_sql.column_value(l_cursor, 8, l_material_rec.subinventory);
1122: dbms_sql.column_value(l_cursor, 9, l_material_rec.locator_id);
1123: dbms_sql.column_value(l_cursor, 10,l_material_rec.locator);
1124: dbms_sql.column_value(l_cursor, 11, l_material_rec.project_id);
1125: dbms_sql.column_value(l_cursor, 12, l_material_rec.project);
1126: dbms_sql.column_value(l_cursor, 13, l_material_rec.task_id);
1127: dbms_sql.column_value(l_cursor, 14, l_material_rec.task_number);
1128: dbms_sql.column_value(l_cursor, 15, l_material_rec.inventory_item_id);
1129: dbms_sql.column_value(l_cursor, 16, l_material_rec.item);

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

1122: dbms_sql.column_value(l_cursor, 9, l_material_rec.locator_id);
1123: dbms_sql.column_value(l_cursor, 10,l_material_rec.locator);
1124: dbms_sql.column_value(l_cursor, 11, l_material_rec.project_id);
1125: dbms_sql.column_value(l_cursor, 12, l_material_rec.project);
1126: dbms_sql.column_value(l_cursor, 13, l_material_rec.task_id);
1127: dbms_sql.column_value(l_cursor, 14, l_material_rec.task_number);
1128: dbms_sql.column_value(l_cursor, 15, l_material_rec.inventory_item_id);
1129: dbms_sql.column_value(l_cursor, 16, l_material_rec.item);
1130: dbms_sql.column_value(l_cursor, 17, l_material_rec.lpn_id);

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

1123: dbms_sql.column_value(l_cursor, 10,l_material_rec.locator);
1124: dbms_sql.column_value(l_cursor, 11, l_material_rec.project_id);
1125: dbms_sql.column_value(l_cursor, 12, l_material_rec.project);
1126: dbms_sql.column_value(l_cursor, 13, l_material_rec.task_id);
1127: dbms_sql.column_value(l_cursor, 14, l_material_rec.task_number);
1128: dbms_sql.column_value(l_cursor, 15, l_material_rec.inventory_item_id);
1129: dbms_sql.column_value(l_cursor, 16, l_material_rec.item);
1130: dbms_sql.column_value(l_cursor, 17, l_material_rec.lpn_id);
1131: dbms_sql.column_value(l_cursor, 18, l_material_rec.revision);

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

1124: dbms_sql.column_value(l_cursor, 11, l_material_rec.project_id);
1125: dbms_sql.column_value(l_cursor, 12, l_material_rec.project);
1126: dbms_sql.column_value(l_cursor, 13, l_material_rec.task_id);
1127: dbms_sql.column_value(l_cursor, 14, l_material_rec.task_number);
1128: dbms_sql.column_value(l_cursor, 15, l_material_rec.inventory_item_id);
1129: dbms_sql.column_value(l_cursor, 16, l_material_rec.item);
1130: dbms_sql.column_value(l_cursor, 17, l_material_rec.lpn_id);
1131: dbms_sql.column_value(l_cursor, 18, l_material_rec.revision);
1132: dbms_sql.column_value(l_cursor, 19, l_material_rec.uom);

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

1125: dbms_sql.column_value(l_cursor, 12, l_material_rec.project);
1126: dbms_sql.column_value(l_cursor, 13, l_material_rec.task_id);
1127: dbms_sql.column_value(l_cursor, 14, l_material_rec.task_number);
1128: dbms_sql.column_value(l_cursor, 15, l_material_rec.inventory_item_id);
1129: dbms_sql.column_value(l_cursor, 16, l_material_rec.item);
1130: dbms_sql.column_value(l_cursor, 17, l_material_rec.lpn_id);
1131: dbms_sql.column_value(l_cursor, 18, l_material_rec.revision);
1132: dbms_sql.column_value(l_cursor, 19, l_material_rec.uom);
1133: dbms_sql.column_value(l_cursor, 20, l_material_rec.quantity);

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

1126: dbms_sql.column_value(l_cursor, 13, l_material_rec.task_id);
1127: dbms_sql.column_value(l_cursor, 14, l_material_rec.task_number);
1128: dbms_sql.column_value(l_cursor, 15, l_material_rec.inventory_item_id);
1129: dbms_sql.column_value(l_cursor, 16, l_material_rec.item);
1130: dbms_sql.column_value(l_cursor, 17, l_material_rec.lpn_id);
1131: dbms_sql.column_value(l_cursor, 18, l_material_rec.revision);
1132: dbms_sql.column_value(l_cursor, 19, l_material_rec.uom);
1133: dbms_sql.column_value(l_cursor, 20, l_material_rec.quantity);
1134: dbms_sql.column_value(l_cursor, 21, l_material_rec.lot_number);

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

1127: dbms_sql.column_value(l_cursor, 14, l_material_rec.task_number);
1128: dbms_sql.column_value(l_cursor, 15, l_material_rec.inventory_item_id);
1129: dbms_sql.column_value(l_cursor, 16, l_material_rec.item);
1130: dbms_sql.column_value(l_cursor, 17, l_material_rec.lpn_id);
1131: dbms_sql.column_value(l_cursor, 18, l_material_rec.revision);
1132: dbms_sql.column_value(l_cursor, 19, l_material_rec.uom);
1133: dbms_sql.column_value(l_cursor, 20, l_material_rec.quantity);
1134: dbms_sql.column_value(l_cursor, 21, l_material_rec.lot_number);
1135: --INVCONV kkillams

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

1128: dbms_sql.column_value(l_cursor, 15, l_material_rec.inventory_item_id);
1129: dbms_sql.column_value(l_cursor, 16, l_material_rec.item);
1130: dbms_sql.column_value(l_cursor, 17, l_material_rec.lpn_id);
1131: dbms_sql.column_value(l_cursor, 18, l_material_rec.revision);
1132: dbms_sql.column_value(l_cursor, 19, l_material_rec.uom);
1133: dbms_sql.column_value(l_cursor, 20, l_material_rec.quantity);
1134: dbms_sql.column_value(l_cursor, 21, l_material_rec.lot_number);
1135: --INVCONV kkillams
1136: dbms_sql.column_value(l_cursor, 22, l_material_rec.secondary_quantity);

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

1129: dbms_sql.column_value(l_cursor, 16, l_material_rec.item);
1130: dbms_sql.column_value(l_cursor, 17, l_material_rec.lpn_id);
1131: dbms_sql.column_value(l_cursor, 18, l_material_rec.revision);
1132: dbms_sql.column_value(l_cursor, 19, l_material_rec.uom);
1133: dbms_sql.column_value(l_cursor, 20, l_material_rec.quantity);
1134: dbms_sql.column_value(l_cursor, 21, l_material_rec.lot_number);
1135: --INVCONV kkillams
1136: dbms_sql.column_value(l_cursor, 22, l_material_rec.secondary_quantity);
1137: dbms_sql.column_value(l_cursor, 23, l_material_rec.secondary_uom_code);

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

1130: dbms_sql.column_value(l_cursor, 17, l_material_rec.lpn_id);
1131: dbms_sql.column_value(l_cursor, 18, l_material_rec.revision);
1132: dbms_sql.column_value(l_cursor, 19, l_material_rec.uom);
1133: dbms_sql.column_value(l_cursor, 20, l_material_rec.quantity);
1134: dbms_sql.column_value(l_cursor, 21, l_material_rec.lot_number);
1135: --INVCONV kkillams
1136: dbms_sql.column_value(l_cursor, 22, l_material_rec.secondary_quantity);
1137: dbms_sql.column_value(l_cursor, 23, l_material_rec.secondary_uom_code);
1138: dbms_sql.column_value(l_cursor, 24, l_material_rec.grade_code);

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

1132: dbms_sql.column_value(l_cursor, 19, l_material_rec.uom);
1133: dbms_sql.column_value(l_cursor, 20, l_material_rec.quantity);
1134: dbms_sql.column_value(l_cursor, 21, l_material_rec.lot_number);
1135: --INVCONV kkillams
1136: dbms_sql.column_value(l_cursor, 22, l_material_rec.secondary_quantity);
1137: dbms_sql.column_value(l_cursor, 23, l_material_rec.secondary_uom_code);
1138: dbms_sql.column_value(l_cursor, 24, l_material_rec.grade_code);
1139: --END INVCONV kkillams
1140: dbms_sql.column_value(l_cursor, 25, l_material_rec.receiving_location_id);

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

1133: dbms_sql.column_value(l_cursor, 20, l_material_rec.quantity);
1134: dbms_sql.column_value(l_cursor, 21, l_material_rec.lot_number);
1135: --INVCONV kkillams
1136: dbms_sql.column_value(l_cursor, 22, l_material_rec.secondary_quantity);
1137: dbms_sql.column_value(l_cursor, 23, l_material_rec.secondary_uom_code);
1138: dbms_sql.column_value(l_cursor, 24, l_material_rec.grade_code);
1139: --END INVCONV kkillams
1140: dbms_sql.column_value(l_cursor, 25, l_material_rec.receiving_location_id);
1141: dbms_sql.column_value(l_cursor, 26, l_material_rec.receiving_location);

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

1134: dbms_sql.column_value(l_cursor, 21, l_material_rec.lot_number);
1135: --INVCONV kkillams
1136: dbms_sql.column_value(l_cursor, 22, l_material_rec.secondary_quantity);
1137: dbms_sql.column_value(l_cursor, 23, l_material_rec.secondary_uom_code);
1138: dbms_sql.column_value(l_cursor, 24, l_material_rec.grade_code);
1139: --END INVCONV kkillams
1140: dbms_sql.column_value(l_cursor, 25, l_material_rec.receiving_location_id);
1141: dbms_sql.column_value(l_cursor, 26, l_material_rec.receiving_location);
1142: dbms_sql.column_value(l_cursor, 27, l_material_rec.vendor_id);

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

1136: dbms_sql.column_value(l_cursor, 22, l_material_rec.secondary_quantity);
1137: dbms_sql.column_value(l_cursor, 23, l_material_rec.secondary_uom_code);
1138: dbms_sql.column_value(l_cursor, 24, l_material_rec.grade_code);
1139: --END INVCONV kkillams
1140: dbms_sql.column_value(l_cursor, 25, l_material_rec.receiving_location_id);
1141: dbms_sql.column_value(l_cursor, 26, l_material_rec.receiving_location);
1142: dbms_sql.column_value(l_cursor, 27, l_material_rec.vendor_id);
1143: dbms_sql.column_value(l_cursor, 28, l_material_rec.source_org_id);
1144: dbms_sql.column_value(l_cursor, 29, l_material_rec.trading_partner);

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

1137: dbms_sql.column_value(l_cursor, 23, l_material_rec.secondary_uom_code);
1138: dbms_sql.column_value(l_cursor, 24, l_material_rec.grade_code);
1139: --END INVCONV kkillams
1140: dbms_sql.column_value(l_cursor, 25, l_material_rec.receiving_location_id);
1141: dbms_sql.column_value(l_cursor, 26, l_material_rec.receiving_location);
1142: dbms_sql.column_value(l_cursor, 27, l_material_rec.vendor_id);
1143: dbms_sql.column_value(l_cursor, 28, l_material_rec.source_org_id);
1144: dbms_sql.column_value(l_cursor, 29, l_material_rec.trading_partner);
1145: dbms_sql.column_value(l_cursor, 30, l_material_rec.document_type);

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

1138: dbms_sql.column_value(l_cursor, 24, l_material_rec.grade_code);
1139: --END INVCONV kkillams
1140: dbms_sql.column_value(l_cursor, 25, l_material_rec.receiving_location_id);
1141: dbms_sql.column_value(l_cursor, 26, l_material_rec.receiving_location);
1142: dbms_sql.column_value(l_cursor, 27, l_material_rec.vendor_id);
1143: dbms_sql.column_value(l_cursor, 28, l_material_rec.source_org_id);
1144: dbms_sql.column_value(l_cursor, 29, l_material_rec.trading_partner);
1145: dbms_sql.column_value(l_cursor, 30, l_material_rec.document_type);
1146: dbms_sql.column_value(l_cursor, 31, l_material_rec.document_id);

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

1139: --END INVCONV kkillams
1140: dbms_sql.column_value(l_cursor, 25, l_material_rec.receiving_location_id);
1141: dbms_sql.column_value(l_cursor, 26, l_material_rec.receiving_location);
1142: dbms_sql.column_value(l_cursor, 27, l_material_rec.vendor_id);
1143: dbms_sql.column_value(l_cursor, 28, l_material_rec.source_org_id);
1144: dbms_sql.column_value(l_cursor, 29, l_material_rec.trading_partner);
1145: dbms_sql.column_value(l_cursor, 30, l_material_rec.document_type);
1146: dbms_sql.column_value(l_cursor, 31, l_material_rec.document_id);
1147: dbms_sql.column_value(l_cursor, 32, l_material_rec.document_number);

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

1140: dbms_sql.column_value(l_cursor, 25, l_material_rec.receiving_location_id);
1141: dbms_sql.column_value(l_cursor, 26, l_material_rec.receiving_location);
1142: dbms_sql.column_value(l_cursor, 27, l_material_rec.vendor_id);
1143: dbms_sql.column_value(l_cursor, 28, l_material_rec.source_org_id);
1144: dbms_sql.column_value(l_cursor, 29, l_material_rec.trading_partner);
1145: dbms_sql.column_value(l_cursor, 30, l_material_rec.document_type);
1146: dbms_sql.column_value(l_cursor, 31, l_material_rec.document_id);
1147: dbms_sql.column_value(l_cursor, 32, l_material_rec.document_number);
1148: dbms_sql.column_value(l_cursor, 33, l_material_rec.receipt_num);

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

1141: dbms_sql.column_value(l_cursor, 26, l_material_rec.receiving_location);
1142: dbms_sql.column_value(l_cursor, 27, l_material_rec.vendor_id);
1143: dbms_sql.column_value(l_cursor, 28, l_material_rec.source_org_id);
1144: dbms_sql.column_value(l_cursor, 29, l_material_rec.trading_partner);
1145: dbms_sql.column_value(l_cursor, 30, l_material_rec.document_type);
1146: dbms_sql.column_value(l_cursor, 31, l_material_rec.document_id);
1147: dbms_sql.column_value(l_cursor, 32, l_material_rec.document_number);
1148: dbms_sql.column_value(l_cursor, 33, l_material_rec.receipt_num);
1149: dbms_sql.column_value(l_cursor, 34, l_material_rec.document_line_id);

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

1142: dbms_sql.column_value(l_cursor, 27, l_material_rec.vendor_id);
1143: dbms_sql.column_value(l_cursor, 28, l_material_rec.source_org_id);
1144: dbms_sql.column_value(l_cursor, 29, l_material_rec.trading_partner);
1145: dbms_sql.column_value(l_cursor, 30, l_material_rec.document_type);
1146: dbms_sql.column_value(l_cursor, 31, l_material_rec.document_id);
1147: dbms_sql.column_value(l_cursor, 32, l_material_rec.document_number);
1148: dbms_sql.column_value(l_cursor, 33, l_material_rec.receipt_num);
1149: dbms_sql.column_value(l_cursor, 34, l_material_rec.document_line_id);
1150: dbms_sql.column_value(l_cursor, 35, l_material_rec.document_line_num);

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

1143: dbms_sql.column_value(l_cursor, 28, l_material_rec.source_org_id);
1144: dbms_sql.column_value(l_cursor, 29, l_material_rec.trading_partner);
1145: dbms_sql.column_value(l_cursor, 30, l_material_rec.document_type);
1146: dbms_sql.column_value(l_cursor, 31, l_material_rec.document_id);
1147: dbms_sql.column_value(l_cursor, 32, l_material_rec.document_number);
1148: dbms_sql.column_value(l_cursor, 33, l_material_rec.receipt_num);
1149: dbms_sql.column_value(l_cursor, 34, l_material_rec.document_line_id);
1150: dbms_sql.column_value(l_cursor, 35, l_material_rec.document_line_num);
1151:

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

1144: dbms_sql.column_value(l_cursor, 29, l_material_rec.trading_partner);
1145: dbms_sql.column_value(l_cursor, 30, l_material_rec.document_type);
1146: dbms_sql.column_value(l_cursor, 31, l_material_rec.document_id);
1147: dbms_sql.column_value(l_cursor, 32, l_material_rec.document_number);
1148: dbms_sql.column_value(l_cursor, 33, l_material_rec.receipt_num);
1149: dbms_sql.column_value(l_cursor, 34, l_material_rec.document_line_id);
1150: dbms_sql.column_value(l_cursor, 35, l_material_rec.document_line_num);
1151:
1152: l_rec_count := l_rec_count + 1;

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

1145: dbms_sql.column_value(l_cursor, 30, l_material_rec.document_type);
1146: dbms_sql.column_value(l_cursor, 31, l_material_rec.document_id);
1147: dbms_sql.column_value(l_cursor, 32, l_material_rec.document_number);
1148: dbms_sql.column_value(l_cursor, 33, l_material_rec.receipt_num);
1149: dbms_sql.column_value(l_cursor, 34, l_material_rec.document_line_id);
1150: dbms_sql.column_value(l_cursor, 35, l_material_rec.document_line_num);
1151:
1152: l_rec_count := l_rec_count + 1;
1153:

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

1146: dbms_sql.column_value(l_cursor, 31, l_material_rec.document_id);
1147: dbms_sql.column_value(l_cursor, 32, l_material_rec.document_number);
1148: dbms_sql.column_value(l_cursor, 33, l_material_rec.receipt_num);
1149: dbms_sql.column_value(l_cursor, 34, l_material_rec.document_line_id);
1150: dbms_sql.column_value(l_cursor, 35, l_material_rec.document_line_num);
1151:
1152: l_rec_count := l_rec_count + 1;
1153:
1154: trace('Calling check_against_rcv');

Line 1678: dbms_sql.close_cursor(l_cursor);

1674: <>
1675: NULL;
1676: END LOOP;
1677:
1678: dbms_sql.close_cursor(l_cursor);
1679:
1680: IF l_debug = 1 THEN
1681: trace('Found eligible material records '||l_rec_count);
1682: END IF;

Line 1752: dbms_sql.close_cursor(l_cursor);

1748: trace('Error in query_inbound_material(), progress='||l_progress);
1749: trace('ERROR CODE = ' || SQLCODE);
1750: trace('ERROR MESSAGE = ' || SQLERRM);
1751: END IF;
1752: dbms_sql.close_cursor(l_cursor);
1753:
1754: x_return_status := fnd_api.G_RET_STS_UNEXP_ERROR;
1755:
1756: END query_inbound_material;