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

Line 455: v_cursorid := DBMS_SQL.Open_Cursor;

451: WSH_DEBUG_SV.log(l_module_name, 'Transaction Query', l_transaction_query);
452: END IF;
453: --
454:
455: v_cursorid := DBMS_SQL.Open_Cursor;
456: --
457: IF l_debug_on THEN
458: WSH_DEBUG_SV.log(l_module_name, 'Opended cursor successfully', v_cursorid);
459: END IF;

Line 461: DBMS_SQL.Parse(v_cursorid, l_transaction_query, DBMS_SQL.v7 );

457: IF l_debug_on THEN
458: WSH_DEBUG_SV.log(l_module_name, 'Opended cursor successfully', v_cursorid);
459: END IF;
460: --
461: DBMS_SQL.Parse(v_cursorid, l_transaction_query, DBMS_SQL.v7 );
462:
463: --
464: IF l_debug_on THEN
465: WSH_DEBUG_SV.logmsg(l_module_name, 'Parsed cursor successfully');

Line 468: DBMS_SQL.Define_Column(v_cursorid, 1, l_transaction_rec.Transaction_ID);

464: IF l_debug_on THEN
465: WSH_DEBUG_SV.logmsg(l_module_name, 'Parsed cursor successfully');
466: END IF;
467: --
468: DBMS_SQL.Define_Column(v_cursorid, 1, l_transaction_rec.Transaction_ID);
469: DBMS_SQL.Define_Column(v_cursorid, 2, l_transaction_rec.Document_Type, 30);
470: DBMS_SQL.Define_Column(v_cursorid, 3, l_transaction_rec.Document_Direction, 1);
471: DBMS_SQL.Define_Column(v_cursorid, 4, l_transaction_rec.Document_Number, 120);
472: DBMS_SQL.Define_Column(v_cursorid, 5, l_transaction_rec.Orig_Document_Number, 120);

Line 469: DBMS_SQL.Define_Column(v_cursorid, 2, l_transaction_rec.Document_Type, 30);

465: WSH_DEBUG_SV.logmsg(l_module_name, 'Parsed cursor successfully');
466: END IF;
467: --
468: DBMS_SQL.Define_Column(v_cursorid, 1, l_transaction_rec.Transaction_ID);
469: DBMS_SQL.Define_Column(v_cursorid, 2, l_transaction_rec.Document_Type, 30);
470: DBMS_SQL.Define_Column(v_cursorid, 3, l_transaction_rec.Document_Direction, 1);
471: DBMS_SQL.Define_Column(v_cursorid, 4, l_transaction_rec.Document_Number, 120);
472: DBMS_SQL.Define_Column(v_cursorid, 5, l_transaction_rec.Orig_Document_Number, 120);
473: DBMS_SQL.Define_Column(v_cursorid, 6, l_transaction_rec.Entity_Number, 30);

Line 470: DBMS_SQL.Define_Column(v_cursorid, 3, l_transaction_rec.Document_Direction, 1);

466: END IF;
467: --
468: DBMS_SQL.Define_Column(v_cursorid, 1, l_transaction_rec.Transaction_ID);
469: DBMS_SQL.Define_Column(v_cursorid, 2, l_transaction_rec.Document_Type, 30);
470: DBMS_SQL.Define_Column(v_cursorid, 3, l_transaction_rec.Document_Direction, 1);
471: DBMS_SQL.Define_Column(v_cursorid, 4, l_transaction_rec.Document_Number, 120);
472: DBMS_SQL.Define_Column(v_cursorid, 5, l_transaction_rec.Orig_Document_Number, 120);
473: DBMS_SQL.Define_Column(v_cursorid, 6, l_transaction_rec.Entity_Number, 30);
474: DBMS_SQL.Define_Column(v_cursorid, 7, l_transaction_rec.Entity_Type, 30);

Line 471: DBMS_SQL.Define_Column(v_cursorid, 4, l_transaction_rec.Document_Number, 120);

467: --
468: DBMS_SQL.Define_Column(v_cursorid, 1, l_transaction_rec.Transaction_ID);
469: DBMS_SQL.Define_Column(v_cursorid, 2, l_transaction_rec.Document_Type, 30);
470: DBMS_SQL.Define_Column(v_cursorid, 3, l_transaction_rec.Document_Direction, 1);
471: DBMS_SQL.Define_Column(v_cursorid, 4, l_transaction_rec.Document_Number, 120);
472: DBMS_SQL.Define_Column(v_cursorid, 5, l_transaction_rec.Orig_Document_Number, 120);
473: DBMS_SQL.Define_Column(v_cursorid, 6, l_transaction_rec.Entity_Number, 30);
474: DBMS_SQL.Define_Column(v_cursorid, 7, l_transaction_rec.Entity_Type, 30);
475: DBMS_SQL.Define_Column(v_cursorid, 8, l_transaction_rec.Trading_Partner_ID);

Line 472: DBMS_SQL.Define_Column(v_cursorid, 5, l_transaction_rec.Orig_Document_Number, 120);

468: DBMS_SQL.Define_Column(v_cursorid, 1, l_transaction_rec.Transaction_ID);
469: DBMS_SQL.Define_Column(v_cursorid, 2, l_transaction_rec.Document_Type, 30);
470: DBMS_SQL.Define_Column(v_cursorid, 3, l_transaction_rec.Document_Direction, 1);
471: DBMS_SQL.Define_Column(v_cursorid, 4, l_transaction_rec.Document_Number, 120);
472: DBMS_SQL.Define_Column(v_cursorid, 5, l_transaction_rec.Orig_Document_Number, 120);
473: DBMS_SQL.Define_Column(v_cursorid, 6, l_transaction_rec.Entity_Number, 30);
474: DBMS_SQL.Define_Column(v_cursorid, 7, l_transaction_rec.Entity_Type, 30);
475: DBMS_SQL.Define_Column(v_cursorid, 8, l_transaction_rec.Trading_Partner_ID);
476: DBMS_SQL.Define_Column(v_cursorid, 9, l_transaction_rec.Action_Type, 30);

Line 473: DBMS_SQL.Define_Column(v_cursorid, 6, l_transaction_rec.Entity_Number, 30);

469: DBMS_SQL.Define_Column(v_cursorid, 2, l_transaction_rec.Document_Type, 30);
470: DBMS_SQL.Define_Column(v_cursorid, 3, l_transaction_rec.Document_Direction, 1);
471: DBMS_SQL.Define_Column(v_cursorid, 4, l_transaction_rec.Document_Number, 120);
472: DBMS_SQL.Define_Column(v_cursorid, 5, l_transaction_rec.Orig_Document_Number, 120);
473: DBMS_SQL.Define_Column(v_cursorid, 6, l_transaction_rec.Entity_Number, 30);
474: DBMS_SQL.Define_Column(v_cursorid, 7, l_transaction_rec.Entity_Type, 30);
475: DBMS_SQL.Define_Column(v_cursorid, 8, l_transaction_rec.Trading_Partner_ID);
476: DBMS_SQL.Define_Column(v_cursorid, 9, l_transaction_rec.Action_Type, 30);
477: DBMS_SQL.Define_Column(v_cursorid, 10, l_transaction_rec.Transaction_Status, 2);

Line 474: DBMS_SQL.Define_Column(v_cursorid, 7, l_transaction_rec.Entity_Type, 30);

470: DBMS_SQL.Define_Column(v_cursorid, 3, l_transaction_rec.Document_Direction, 1);
471: DBMS_SQL.Define_Column(v_cursorid, 4, l_transaction_rec.Document_Number, 120);
472: DBMS_SQL.Define_Column(v_cursorid, 5, l_transaction_rec.Orig_Document_Number, 120);
473: DBMS_SQL.Define_Column(v_cursorid, 6, l_transaction_rec.Entity_Number, 30);
474: DBMS_SQL.Define_Column(v_cursorid, 7, l_transaction_rec.Entity_Type, 30);
475: DBMS_SQL.Define_Column(v_cursorid, 8, l_transaction_rec.Trading_Partner_ID);
476: DBMS_SQL.Define_Column(v_cursorid, 9, l_transaction_rec.Action_Type, 30);
477: DBMS_SQL.Define_Column(v_cursorid, 10, l_transaction_rec.Transaction_Status, 2);
478: DBMS_SQL.Define_Column_Raw(v_cursorid, 11, l_transaction_rec.ecx_message_id, 16);

Line 475: DBMS_SQL.Define_Column(v_cursorid, 8, l_transaction_rec.Trading_Partner_ID);

471: DBMS_SQL.Define_Column(v_cursorid, 4, l_transaction_rec.Document_Number, 120);
472: DBMS_SQL.Define_Column(v_cursorid, 5, l_transaction_rec.Orig_Document_Number, 120);
473: DBMS_SQL.Define_Column(v_cursorid, 6, l_transaction_rec.Entity_Number, 30);
474: DBMS_SQL.Define_Column(v_cursorid, 7, l_transaction_rec.Entity_Type, 30);
475: DBMS_SQL.Define_Column(v_cursorid, 8, l_transaction_rec.Trading_Partner_ID);
476: DBMS_SQL.Define_Column(v_cursorid, 9, l_transaction_rec.Action_Type, 30);
477: DBMS_SQL.Define_Column(v_cursorid, 10, l_transaction_rec.Transaction_Status, 2);
478: DBMS_SQL.Define_Column_Raw(v_cursorid, 11, l_transaction_rec.ecx_message_id, 16);
479: DBMS_SQL.Define_Column(v_cursorid, 12, l_transaction_rec.Event_Name, 240);

Line 476: DBMS_SQL.Define_Column(v_cursorid, 9, l_transaction_rec.Action_Type, 30);

472: DBMS_SQL.Define_Column(v_cursorid, 5, l_transaction_rec.Orig_Document_Number, 120);
473: DBMS_SQL.Define_Column(v_cursorid, 6, l_transaction_rec.Entity_Number, 30);
474: DBMS_SQL.Define_Column(v_cursorid, 7, l_transaction_rec.Entity_Type, 30);
475: DBMS_SQL.Define_Column(v_cursorid, 8, l_transaction_rec.Trading_Partner_ID);
476: DBMS_SQL.Define_Column(v_cursorid, 9, l_transaction_rec.Action_Type, 30);
477: DBMS_SQL.Define_Column(v_cursorid, 10, l_transaction_rec.Transaction_Status, 2);
478: DBMS_SQL.Define_Column_Raw(v_cursorid, 11, l_transaction_rec.ecx_message_id, 16);
479: DBMS_SQL.Define_Column(v_cursorid, 12, l_transaction_rec.Event_Name, 240);
480: DBMS_SQL.Define_Column(v_cursorid, 13, l_transaction_rec.Event_Key, 240);

Line 477: DBMS_SQL.Define_Column(v_cursorid, 10, l_transaction_rec.Transaction_Status, 2);

473: DBMS_SQL.Define_Column(v_cursorid, 6, l_transaction_rec.Entity_Number, 30);
474: DBMS_SQL.Define_Column(v_cursorid, 7, l_transaction_rec.Entity_Type, 30);
475: DBMS_SQL.Define_Column(v_cursorid, 8, l_transaction_rec.Trading_Partner_ID);
476: DBMS_SQL.Define_Column(v_cursorid, 9, l_transaction_rec.Action_Type, 30);
477: DBMS_SQL.Define_Column(v_cursorid, 10, l_transaction_rec.Transaction_Status, 2);
478: DBMS_SQL.Define_Column_Raw(v_cursorid, 11, l_transaction_rec.ecx_message_id, 16);
479: DBMS_SQL.Define_Column(v_cursorid, 12, l_transaction_rec.Event_Name, 240);
480: DBMS_SQL.Define_Column(v_cursorid, 13, l_transaction_rec.Event_Key, 240);
481: DBMS_SQL.Define_Column(v_cursorid, 14, l_transaction_rec.Item_Type, 8);

Line 478: DBMS_SQL.Define_Column_Raw(v_cursorid, 11, l_transaction_rec.ecx_message_id, 16);

474: DBMS_SQL.Define_Column(v_cursorid, 7, l_transaction_rec.Entity_Type, 30);
475: DBMS_SQL.Define_Column(v_cursorid, 8, l_transaction_rec.Trading_Partner_ID);
476: DBMS_SQL.Define_Column(v_cursorid, 9, l_transaction_rec.Action_Type, 30);
477: DBMS_SQL.Define_Column(v_cursorid, 10, l_transaction_rec.Transaction_Status, 2);
478: DBMS_SQL.Define_Column_Raw(v_cursorid, 11, l_transaction_rec.ecx_message_id, 16);
479: DBMS_SQL.Define_Column(v_cursorid, 12, l_transaction_rec.Event_Name, 240);
480: DBMS_SQL.Define_Column(v_cursorid, 13, l_transaction_rec.Event_Key, 240);
481: DBMS_SQL.Define_Column(v_cursorid, 14, l_transaction_rec.Item_Type, 8);
482: DBMS_SQL.Define_Column(v_cursorid, 15, l_transaction_rec.Internal_Control_Number);

Line 479: DBMS_SQL.Define_Column(v_cursorid, 12, l_transaction_rec.Event_Name, 240);

475: DBMS_SQL.Define_Column(v_cursorid, 8, l_transaction_rec.Trading_Partner_ID);
476: DBMS_SQL.Define_Column(v_cursorid, 9, l_transaction_rec.Action_Type, 30);
477: DBMS_SQL.Define_Column(v_cursorid, 10, l_transaction_rec.Transaction_Status, 2);
478: DBMS_SQL.Define_Column_Raw(v_cursorid, 11, l_transaction_rec.ecx_message_id, 16);
479: DBMS_SQL.Define_Column(v_cursorid, 12, l_transaction_rec.Event_Name, 240);
480: DBMS_SQL.Define_Column(v_cursorid, 13, l_transaction_rec.Event_Key, 240);
481: DBMS_SQL.Define_Column(v_cursorid, 14, l_transaction_rec.Item_Type, 8);
482: DBMS_SQL.Define_Column(v_cursorid, 15, l_transaction_rec.Internal_Control_Number);
483: DBMS_SQL.Define_Column(v_cursorid, 16, l_transaction_rec.document_revision);

Line 480: DBMS_SQL.Define_Column(v_cursorid, 13, l_transaction_rec.Event_Key, 240);

476: DBMS_SQL.Define_Column(v_cursorid, 9, l_transaction_rec.Action_Type, 30);
477: DBMS_SQL.Define_Column(v_cursorid, 10, l_transaction_rec.Transaction_Status, 2);
478: DBMS_SQL.Define_Column_Raw(v_cursorid, 11, l_transaction_rec.ecx_message_id, 16);
479: DBMS_SQL.Define_Column(v_cursorid, 12, l_transaction_rec.Event_Name, 240);
480: DBMS_SQL.Define_Column(v_cursorid, 13, l_transaction_rec.Event_Key, 240);
481: DBMS_SQL.Define_Column(v_cursorid, 14, l_transaction_rec.Item_Type, 8);
482: DBMS_SQL.Define_Column(v_cursorid, 15, l_transaction_rec.Internal_Control_Number);
483: DBMS_SQL.Define_Column(v_cursorid, 16, l_transaction_rec.document_revision);
484: DBMS_SQL.Define_Column(v_cursorid, 17, l_transaction_rec.Attribute_Category, 150);

Line 481: DBMS_SQL.Define_Column(v_cursorid, 14, l_transaction_rec.Item_Type, 8);

477: DBMS_SQL.Define_Column(v_cursorid, 10, l_transaction_rec.Transaction_Status, 2);
478: DBMS_SQL.Define_Column_Raw(v_cursorid, 11, l_transaction_rec.ecx_message_id, 16);
479: DBMS_SQL.Define_Column(v_cursorid, 12, l_transaction_rec.Event_Name, 240);
480: DBMS_SQL.Define_Column(v_cursorid, 13, l_transaction_rec.Event_Key, 240);
481: DBMS_SQL.Define_Column(v_cursorid, 14, l_transaction_rec.Item_Type, 8);
482: DBMS_SQL.Define_Column(v_cursorid, 15, l_transaction_rec.Internal_Control_Number);
483: DBMS_SQL.Define_Column(v_cursorid, 16, l_transaction_rec.document_revision);
484: DBMS_SQL.Define_Column(v_cursorid, 17, l_transaction_rec.Attribute_Category, 150);
485: DBMS_SQL.Define_Column(v_cursorid, 18, l_transaction_rec.Attribute1, 150);

Line 482: DBMS_SQL.Define_Column(v_cursorid, 15, l_transaction_rec.Internal_Control_Number);

478: DBMS_SQL.Define_Column_Raw(v_cursorid, 11, l_transaction_rec.ecx_message_id, 16);
479: DBMS_SQL.Define_Column(v_cursorid, 12, l_transaction_rec.Event_Name, 240);
480: DBMS_SQL.Define_Column(v_cursorid, 13, l_transaction_rec.Event_Key, 240);
481: DBMS_SQL.Define_Column(v_cursorid, 14, l_transaction_rec.Item_Type, 8);
482: DBMS_SQL.Define_Column(v_cursorid, 15, l_transaction_rec.Internal_Control_Number);
483: DBMS_SQL.Define_Column(v_cursorid, 16, l_transaction_rec.document_revision);
484: DBMS_SQL.Define_Column(v_cursorid, 17, l_transaction_rec.Attribute_Category, 150);
485: DBMS_SQL.Define_Column(v_cursorid, 18, l_transaction_rec.Attribute1, 150);
486: DBMS_SQL.Define_Column(v_cursorid, 19, l_transaction_rec.Attribute2, 150);

Line 483: DBMS_SQL.Define_Column(v_cursorid, 16, l_transaction_rec.document_revision);

479: DBMS_SQL.Define_Column(v_cursorid, 12, l_transaction_rec.Event_Name, 240);
480: DBMS_SQL.Define_Column(v_cursorid, 13, l_transaction_rec.Event_Key, 240);
481: DBMS_SQL.Define_Column(v_cursorid, 14, l_transaction_rec.Item_Type, 8);
482: DBMS_SQL.Define_Column(v_cursorid, 15, l_transaction_rec.Internal_Control_Number);
483: DBMS_SQL.Define_Column(v_cursorid, 16, l_transaction_rec.document_revision);
484: DBMS_SQL.Define_Column(v_cursorid, 17, l_transaction_rec.Attribute_Category, 150);
485: DBMS_SQL.Define_Column(v_cursorid, 18, l_transaction_rec.Attribute1, 150);
486: DBMS_SQL.Define_Column(v_cursorid, 19, l_transaction_rec.Attribute2, 150);
487: DBMS_SQL.Define_Column(v_cursorid, 20, l_transaction_rec.Attribute3, 150);

Line 484: DBMS_SQL.Define_Column(v_cursorid, 17, l_transaction_rec.Attribute_Category, 150);

480: DBMS_SQL.Define_Column(v_cursorid, 13, l_transaction_rec.Event_Key, 240);
481: DBMS_SQL.Define_Column(v_cursorid, 14, l_transaction_rec.Item_Type, 8);
482: DBMS_SQL.Define_Column(v_cursorid, 15, l_transaction_rec.Internal_Control_Number);
483: DBMS_SQL.Define_Column(v_cursorid, 16, l_transaction_rec.document_revision);
484: DBMS_SQL.Define_Column(v_cursorid, 17, l_transaction_rec.Attribute_Category, 150);
485: DBMS_SQL.Define_Column(v_cursorid, 18, l_transaction_rec.Attribute1, 150);
486: DBMS_SQL.Define_Column(v_cursorid, 19, l_transaction_rec.Attribute2, 150);
487: DBMS_SQL.Define_Column(v_cursorid, 20, l_transaction_rec.Attribute3, 150);
488: DBMS_SQL.Define_Column(v_cursorid, 21, l_transaction_rec.Attribute4, 150);

Line 485: DBMS_SQL.Define_Column(v_cursorid, 18, l_transaction_rec.Attribute1, 150);

481: DBMS_SQL.Define_Column(v_cursorid, 14, l_transaction_rec.Item_Type, 8);
482: DBMS_SQL.Define_Column(v_cursorid, 15, l_transaction_rec.Internal_Control_Number);
483: DBMS_SQL.Define_Column(v_cursorid, 16, l_transaction_rec.document_revision);
484: DBMS_SQL.Define_Column(v_cursorid, 17, l_transaction_rec.Attribute_Category, 150);
485: DBMS_SQL.Define_Column(v_cursorid, 18, l_transaction_rec.Attribute1, 150);
486: DBMS_SQL.Define_Column(v_cursorid, 19, l_transaction_rec.Attribute2, 150);
487: DBMS_SQL.Define_Column(v_cursorid, 20, l_transaction_rec.Attribute3, 150);
488: DBMS_SQL.Define_Column(v_cursorid, 21, l_transaction_rec.Attribute4, 150);
489: DBMS_SQL.Define_Column(v_cursorid, 22, l_transaction_rec.Attribute5, 150);

Line 486: DBMS_SQL.Define_Column(v_cursorid, 19, l_transaction_rec.Attribute2, 150);

482: DBMS_SQL.Define_Column(v_cursorid, 15, l_transaction_rec.Internal_Control_Number);
483: DBMS_SQL.Define_Column(v_cursorid, 16, l_transaction_rec.document_revision);
484: DBMS_SQL.Define_Column(v_cursorid, 17, l_transaction_rec.Attribute_Category, 150);
485: DBMS_SQL.Define_Column(v_cursorid, 18, l_transaction_rec.Attribute1, 150);
486: DBMS_SQL.Define_Column(v_cursorid, 19, l_transaction_rec.Attribute2, 150);
487: DBMS_SQL.Define_Column(v_cursorid, 20, l_transaction_rec.Attribute3, 150);
488: DBMS_SQL.Define_Column(v_cursorid, 21, l_transaction_rec.Attribute4, 150);
489: DBMS_SQL.Define_Column(v_cursorid, 22, l_transaction_rec.Attribute5, 150);
490: DBMS_SQL.Define_Column(v_cursorid, 23, l_transaction_rec.Attribute6, 150);

Line 487: DBMS_SQL.Define_Column(v_cursorid, 20, l_transaction_rec.Attribute3, 150);

483: DBMS_SQL.Define_Column(v_cursorid, 16, l_transaction_rec.document_revision);
484: DBMS_SQL.Define_Column(v_cursorid, 17, l_transaction_rec.Attribute_Category, 150);
485: DBMS_SQL.Define_Column(v_cursorid, 18, l_transaction_rec.Attribute1, 150);
486: DBMS_SQL.Define_Column(v_cursorid, 19, l_transaction_rec.Attribute2, 150);
487: DBMS_SQL.Define_Column(v_cursorid, 20, l_transaction_rec.Attribute3, 150);
488: DBMS_SQL.Define_Column(v_cursorid, 21, l_transaction_rec.Attribute4, 150);
489: DBMS_SQL.Define_Column(v_cursorid, 22, l_transaction_rec.Attribute5, 150);
490: DBMS_SQL.Define_Column(v_cursorid, 23, l_transaction_rec.Attribute6, 150);
491: DBMS_SQL.Define_Column(v_cursorid, 24, l_transaction_rec.Attribute7, 150);

Line 488: DBMS_SQL.Define_Column(v_cursorid, 21, l_transaction_rec.Attribute4, 150);

484: DBMS_SQL.Define_Column(v_cursorid, 17, l_transaction_rec.Attribute_Category, 150);
485: DBMS_SQL.Define_Column(v_cursorid, 18, l_transaction_rec.Attribute1, 150);
486: DBMS_SQL.Define_Column(v_cursorid, 19, l_transaction_rec.Attribute2, 150);
487: DBMS_SQL.Define_Column(v_cursorid, 20, l_transaction_rec.Attribute3, 150);
488: DBMS_SQL.Define_Column(v_cursorid, 21, l_transaction_rec.Attribute4, 150);
489: DBMS_SQL.Define_Column(v_cursorid, 22, l_transaction_rec.Attribute5, 150);
490: DBMS_SQL.Define_Column(v_cursorid, 23, l_transaction_rec.Attribute6, 150);
491: DBMS_SQL.Define_Column(v_cursorid, 24, l_transaction_rec.Attribute7, 150);
492: DBMS_SQL.Define_Column(v_cursorid, 25, l_transaction_rec.Attribute8, 150);

Line 489: DBMS_SQL.Define_Column(v_cursorid, 22, l_transaction_rec.Attribute5, 150);

485: DBMS_SQL.Define_Column(v_cursorid, 18, l_transaction_rec.Attribute1, 150);
486: DBMS_SQL.Define_Column(v_cursorid, 19, l_transaction_rec.Attribute2, 150);
487: DBMS_SQL.Define_Column(v_cursorid, 20, l_transaction_rec.Attribute3, 150);
488: DBMS_SQL.Define_Column(v_cursorid, 21, l_transaction_rec.Attribute4, 150);
489: DBMS_SQL.Define_Column(v_cursorid, 22, l_transaction_rec.Attribute5, 150);
490: DBMS_SQL.Define_Column(v_cursorid, 23, l_transaction_rec.Attribute6, 150);
491: DBMS_SQL.Define_Column(v_cursorid, 24, l_transaction_rec.Attribute7, 150);
492: DBMS_SQL.Define_Column(v_cursorid, 25, l_transaction_rec.Attribute8, 150);
493: DBMS_SQL.Define_Column(v_cursorid, 26, l_transaction_rec.Attribute9, 150);

Line 490: DBMS_SQL.Define_Column(v_cursorid, 23, l_transaction_rec.Attribute6, 150);

486: DBMS_SQL.Define_Column(v_cursorid, 19, l_transaction_rec.Attribute2, 150);
487: DBMS_SQL.Define_Column(v_cursorid, 20, l_transaction_rec.Attribute3, 150);
488: DBMS_SQL.Define_Column(v_cursorid, 21, l_transaction_rec.Attribute4, 150);
489: DBMS_SQL.Define_Column(v_cursorid, 22, l_transaction_rec.Attribute5, 150);
490: DBMS_SQL.Define_Column(v_cursorid, 23, l_transaction_rec.Attribute6, 150);
491: DBMS_SQL.Define_Column(v_cursorid, 24, l_transaction_rec.Attribute7, 150);
492: DBMS_SQL.Define_Column(v_cursorid, 25, l_transaction_rec.Attribute8, 150);
493: DBMS_SQL.Define_Column(v_cursorid, 26, l_transaction_rec.Attribute9, 150);
494: DBMS_SQL.Define_Column(v_cursorid, 27, l_transaction_rec.Attribute10, 150);

Line 491: DBMS_SQL.Define_Column(v_cursorid, 24, l_transaction_rec.Attribute7, 150);

487: DBMS_SQL.Define_Column(v_cursorid, 20, l_transaction_rec.Attribute3, 150);
488: DBMS_SQL.Define_Column(v_cursorid, 21, l_transaction_rec.Attribute4, 150);
489: DBMS_SQL.Define_Column(v_cursorid, 22, l_transaction_rec.Attribute5, 150);
490: DBMS_SQL.Define_Column(v_cursorid, 23, l_transaction_rec.Attribute6, 150);
491: DBMS_SQL.Define_Column(v_cursorid, 24, l_transaction_rec.Attribute7, 150);
492: DBMS_SQL.Define_Column(v_cursorid, 25, l_transaction_rec.Attribute8, 150);
493: DBMS_SQL.Define_Column(v_cursorid, 26, l_transaction_rec.Attribute9, 150);
494: DBMS_SQL.Define_Column(v_cursorid, 27, l_transaction_rec.Attribute10, 150);
495: DBMS_SQL.Define_Column(v_cursorid, 28, l_transaction_rec.Attribute11, 150);

Line 492: DBMS_SQL.Define_Column(v_cursorid, 25, l_transaction_rec.Attribute8, 150);

488: DBMS_SQL.Define_Column(v_cursorid, 21, l_transaction_rec.Attribute4, 150);
489: DBMS_SQL.Define_Column(v_cursorid, 22, l_transaction_rec.Attribute5, 150);
490: DBMS_SQL.Define_Column(v_cursorid, 23, l_transaction_rec.Attribute6, 150);
491: DBMS_SQL.Define_Column(v_cursorid, 24, l_transaction_rec.Attribute7, 150);
492: DBMS_SQL.Define_Column(v_cursorid, 25, l_transaction_rec.Attribute8, 150);
493: DBMS_SQL.Define_Column(v_cursorid, 26, l_transaction_rec.Attribute9, 150);
494: DBMS_SQL.Define_Column(v_cursorid, 27, l_transaction_rec.Attribute10, 150);
495: DBMS_SQL.Define_Column(v_cursorid, 28, l_transaction_rec.Attribute11, 150);
496: DBMS_SQL.Define_Column(v_cursorid, 29, l_transaction_rec.Attribute12, 150);

Line 493: DBMS_SQL.Define_Column(v_cursorid, 26, l_transaction_rec.Attribute9, 150);

489: DBMS_SQL.Define_Column(v_cursorid, 22, l_transaction_rec.Attribute5, 150);
490: DBMS_SQL.Define_Column(v_cursorid, 23, l_transaction_rec.Attribute6, 150);
491: DBMS_SQL.Define_Column(v_cursorid, 24, l_transaction_rec.Attribute7, 150);
492: DBMS_SQL.Define_Column(v_cursorid, 25, l_transaction_rec.Attribute8, 150);
493: DBMS_SQL.Define_Column(v_cursorid, 26, l_transaction_rec.Attribute9, 150);
494: DBMS_SQL.Define_Column(v_cursorid, 27, l_transaction_rec.Attribute10, 150);
495: DBMS_SQL.Define_Column(v_cursorid, 28, l_transaction_rec.Attribute11, 150);
496: DBMS_SQL.Define_Column(v_cursorid, 29, l_transaction_rec.Attribute12, 150);
497: DBMS_SQL.Define_Column(v_cursorid, 30, l_transaction_rec.Attribute13, 150);

Line 494: DBMS_SQL.Define_Column(v_cursorid, 27, l_transaction_rec.Attribute10, 150);

490: DBMS_SQL.Define_Column(v_cursorid, 23, l_transaction_rec.Attribute6, 150);
491: DBMS_SQL.Define_Column(v_cursorid, 24, l_transaction_rec.Attribute7, 150);
492: DBMS_SQL.Define_Column(v_cursorid, 25, l_transaction_rec.Attribute8, 150);
493: DBMS_SQL.Define_Column(v_cursorid, 26, l_transaction_rec.Attribute9, 150);
494: DBMS_SQL.Define_Column(v_cursorid, 27, l_transaction_rec.Attribute10, 150);
495: DBMS_SQL.Define_Column(v_cursorid, 28, l_transaction_rec.Attribute11, 150);
496: DBMS_SQL.Define_Column(v_cursorid, 29, l_transaction_rec.Attribute12, 150);
497: DBMS_SQL.Define_Column(v_cursorid, 30, l_transaction_rec.Attribute13, 150);
498: DBMS_SQL.Define_Column(v_cursorid, 31, l_transaction_rec.Attribute14, 150);

Line 495: DBMS_SQL.Define_Column(v_cursorid, 28, l_transaction_rec.Attribute11, 150);

491: DBMS_SQL.Define_Column(v_cursorid, 24, l_transaction_rec.Attribute7, 150);
492: DBMS_SQL.Define_Column(v_cursorid, 25, l_transaction_rec.Attribute8, 150);
493: DBMS_SQL.Define_Column(v_cursorid, 26, l_transaction_rec.Attribute9, 150);
494: DBMS_SQL.Define_Column(v_cursorid, 27, l_transaction_rec.Attribute10, 150);
495: DBMS_SQL.Define_Column(v_cursorid, 28, l_transaction_rec.Attribute11, 150);
496: DBMS_SQL.Define_Column(v_cursorid, 29, l_transaction_rec.Attribute12, 150);
497: DBMS_SQL.Define_Column(v_cursorid, 30, l_transaction_rec.Attribute13, 150);
498: DBMS_SQL.Define_Column(v_cursorid, 31, l_transaction_rec.Attribute14, 150);
499: DBMS_SQL.Define_Column(v_cursorid, 32, l_transaction_rec.Attribute15, 150);

Line 496: DBMS_SQL.Define_Column(v_cursorid, 29, l_transaction_rec.Attribute12, 150);

492: DBMS_SQL.Define_Column(v_cursorid, 25, l_transaction_rec.Attribute8, 150);
493: DBMS_SQL.Define_Column(v_cursorid, 26, l_transaction_rec.Attribute9, 150);
494: DBMS_SQL.Define_Column(v_cursorid, 27, l_transaction_rec.Attribute10, 150);
495: DBMS_SQL.Define_Column(v_cursorid, 28, l_transaction_rec.Attribute11, 150);
496: DBMS_SQL.Define_Column(v_cursorid, 29, l_transaction_rec.Attribute12, 150);
497: DBMS_SQL.Define_Column(v_cursorid, 30, l_transaction_rec.Attribute13, 150);
498: DBMS_SQL.Define_Column(v_cursorid, 31, l_transaction_rec.Attribute14, 150);
499: DBMS_SQL.Define_Column(v_cursorid, 32, l_transaction_rec.Attribute15, 150);
500: --

Line 497: DBMS_SQL.Define_Column(v_cursorid, 30, l_transaction_rec.Attribute13, 150);

493: DBMS_SQL.Define_Column(v_cursorid, 26, l_transaction_rec.Attribute9, 150);
494: DBMS_SQL.Define_Column(v_cursorid, 27, l_transaction_rec.Attribute10, 150);
495: DBMS_SQL.Define_Column(v_cursorid, 28, l_transaction_rec.Attribute11, 150);
496: DBMS_SQL.Define_Column(v_cursorid, 29, l_transaction_rec.Attribute12, 150);
497: DBMS_SQL.Define_Column(v_cursorid, 30, l_transaction_rec.Attribute13, 150);
498: DBMS_SQL.Define_Column(v_cursorid, 31, l_transaction_rec.Attribute14, 150);
499: DBMS_SQL.Define_Column(v_cursorid, 32, l_transaction_rec.Attribute15, 150);
500: --
501: IF l_debug_on THEN

Line 498: DBMS_SQL.Define_Column(v_cursorid, 31, l_transaction_rec.Attribute14, 150);

494: DBMS_SQL.Define_Column(v_cursorid, 27, l_transaction_rec.Attribute10, 150);
495: DBMS_SQL.Define_Column(v_cursorid, 28, l_transaction_rec.Attribute11, 150);
496: DBMS_SQL.Define_Column(v_cursorid, 29, l_transaction_rec.Attribute12, 150);
497: DBMS_SQL.Define_Column(v_cursorid, 30, l_transaction_rec.Attribute13, 150);
498: DBMS_SQL.Define_Column(v_cursorid, 31, l_transaction_rec.Attribute14, 150);
499: DBMS_SQL.Define_Column(v_cursorid, 32, l_transaction_rec.Attribute15, 150);
500: --
501: IF l_debug_on THEN
502: WSH_DEBUG_SV.logmsg(l_module_name, 'Defined Columns successfully');

Line 499: DBMS_SQL.Define_Column(v_cursorid, 32, l_transaction_rec.Attribute15, 150);

495: DBMS_SQL.Define_Column(v_cursorid, 28, l_transaction_rec.Attribute11, 150);
496: DBMS_SQL.Define_Column(v_cursorid, 29, l_transaction_rec.Attribute12, 150);
497: DBMS_SQL.Define_Column(v_cursorid, 30, l_transaction_rec.Attribute13, 150);
498: DBMS_SQL.Define_Column(v_cursorid, 31, l_transaction_rec.Attribute14, 150);
499: DBMS_SQL.Define_Column(v_cursorid, 32, l_transaction_rec.Attribute15, 150);
500: --
501: IF l_debug_on THEN
502: WSH_DEBUG_SV.logmsg(l_module_name, 'Defined Columns successfully');
503: END IF;

Line 509: DBMS_SQL.BIND_VARIABLE(v_cursorid,':x_from_document_number', p_from_document_number);

505:
506: --Start assigning BIND values
507: IF p_from_document_number is not null and p_to_document_number is not null
508: THEN
509: DBMS_SQL.BIND_VARIABLE(v_cursorid,':x_from_document_number', p_from_document_number);
510: DBMS_SQL.BIND_VARIABLE(v_cursorid,':x_to_document_number', p_to_document_number);
511: ELSIF p_from_document_number is not null and p_to_document_number is null
512: THEN
513: DBMS_SQL.BIND_VARIABLE(v_cursorid,':x_from_document_number', p_from_document_number);

Line 510: DBMS_SQL.BIND_VARIABLE(v_cursorid,':x_to_document_number', p_to_document_number);

506: --Start assigning BIND values
507: IF p_from_document_number is not null and p_to_document_number is not null
508: THEN
509: DBMS_SQL.BIND_VARIABLE(v_cursorid,':x_from_document_number', p_from_document_number);
510: DBMS_SQL.BIND_VARIABLE(v_cursorid,':x_to_document_number', p_to_document_number);
511: ELSIF p_from_document_number is not null and p_to_document_number is null
512: THEN
513: DBMS_SQL.BIND_VARIABLE(v_cursorid,':x_from_document_number', p_from_document_number);
514: ELSIF p_from_document_number is null and p_to_document_number is not null

Line 513: DBMS_SQL.BIND_VARIABLE(v_cursorid,':x_from_document_number', p_from_document_number);

509: DBMS_SQL.BIND_VARIABLE(v_cursorid,':x_from_document_number', p_from_document_number);
510: DBMS_SQL.BIND_VARIABLE(v_cursorid,':x_to_document_number', p_to_document_number);
511: ELSIF p_from_document_number is not null and p_to_document_number is null
512: THEN
513: DBMS_SQL.BIND_VARIABLE(v_cursorid,':x_from_document_number', p_from_document_number);
514: ELSIF p_from_document_number is null and p_to_document_number is not null
515: THEN
516: DBMS_SQL.BIND_VARIABLE(v_cursorid,':x_to_document_number', p_to_document_number);
517: END IF;

Line 516: DBMS_SQL.BIND_VARIABLE(v_cursorid,':x_to_document_number', p_to_document_number);

512: THEN
513: DBMS_SQL.BIND_VARIABLE(v_cursorid,':x_from_document_number', p_from_document_number);
514: ELSIF p_from_document_number is null and p_to_document_number is not null
515: THEN
516: DBMS_SQL.BIND_VARIABLE(v_cursorid,':x_to_document_number', p_to_document_number);
517: END IF;
518:
519: IF p_transaction_status is not null
520: THEN

Line 521: DBMS_SQL.BIND_VARIABLE(v_cursorid,':x_transaction_status', p_transaction_status);

517: END IF;
518:
519: IF p_transaction_status is not null
520: THEN
521: DBMS_SQL.BIND_VARIABLE(v_cursorid,':x_transaction_status', p_transaction_status);
522: END IF;
523:
524: IF l_from_creation_date is not null and l_to_creation_date is not null
525: THEN

Line 526: DBMS_SQL.BIND_VARIABLE(v_cursorid,':x_from_creation_date', l_from_creation_date);

522: END IF;
523:
524: IF l_from_creation_date is not null and l_to_creation_date is not null
525: THEN
526: DBMS_SQL.BIND_VARIABLE(v_cursorid,':x_from_creation_date', l_from_creation_date);
527: DBMS_SQL.BIND_VARIABLE(v_cursorid,':x_to_creation_date', l_to_creation_date);
528: ELSIF l_from_creation_date is not null and l_to_creation_date is null
529: THEN
530: DBMS_SQL.BIND_VARIABLE(v_cursorid,':x_from_creation_date', l_from_creation_date);

Line 527: DBMS_SQL.BIND_VARIABLE(v_cursorid,':x_to_creation_date', l_to_creation_date);

523:
524: IF l_from_creation_date is not null and l_to_creation_date is not null
525: THEN
526: DBMS_SQL.BIND_VARIABLE(v_cursorid,':x_from_creation_date', l_from_creation_date);
527: DBMS_SQL.BIND_VARIABLE(v_cursorid,':x_to_creation_date', l_to_creation_date);
528: ELSIF l_from_creation_date is not null and l_to_creation_date is null
529: THEN
530: DBMS_SQL.BIND_VARIABLE(v_cursorid,':x_from_creation_date', l_from_creation_date);
531: ELSIF l_from_creation_date is null and l_to_creation_date is not null

Line 530: DBMS_SQL.BIND_VARIABLE(v_cursorid,':x_from_creation_date', l_from_creation_date);

526: DBMS_SQL.BIND_VARIABLE(v_cursorid,':x_from_creation_date', l_from_creation_date);
527: DBMS_SQL.BIND_VARIABLE(v_cursorid,':x_to_creation_date', l_to_creation_date);
528: ELSIF l_from_creation_date is not null and l_to_creation_date is null
529: THEN
530: DBMS_SQL.BIND_VARIABLE(v_cursorid,':x_from_creation_date', l_from_creation_date);
531: ELSIF l_from_creation_date is null and l_to_creation_date is not null
532: THEN
533: DBMS_SQL.BIND_VARIABLE(v_cursorid,':x_to_creation_date', l_to_creation_date);
534: END IF;

Line 533: DBMS_SQL.BIND_VARIABLE(v_cursorid,':x_to_creation_date', l_to_creation_date);

529: THEN
530: DBMS_SQL.BIND_VARIABLE(v_cursorid,':x_from_creation_date', l_from_creation_date);
531: ELSIF l_from_creation_date is null and l_to_creation_date is not null
532: THEN
533: DBMS_SQL.BIND_VARIABLE(v_cursorid,':x_to_creation_date', l_to_creation_date);
534: END IF;
535: /*Modified R12.1.1 LSP PROJECT */
536: IF p_client_code is not null
537: THEN

Line 538: DBMS_SQL.BIND_VARIABLE(v_cursorid,':x_client_code', p_client_code); --Modified R12.1.1 LSP PROJECT

534: END IF;
535: /*Modified R12.1.1 LSP PROJECT */
536: IF p_client_code is not null
537: THEN
538: DBMS_SQL.BIND_VARIABLE(v_cursorid,':x_client_code', p_client_code); --Modified R12.1.1 LSP PROJECT
539: END IF;
540: /*Modified R12.1.1 LSP PROJECT */
541: --End assigning BIND values
542: --

Line 548: v_ignore := DBMS_SQL.Execute(v_cursorid);

544: WSH_DEBUG_SV.logmsg(l_module_name, 'Bind values successfully');
545: END IF;
546: --
547:
548: v_ignore := DBMS_SQL.Execute(v_cursorid);
549: --
550: IF l_debug_on THEN
551: WSH_DEBUG_SV.log(l_module_name, 'Cursor executed successfully', v_ignore);
552: END IF;

Line 561: v_ignore := DBMS_SQL.Fetch_Rows(v_cursorid);

557: IF p_transaction_id is not null THEN
558: FETCH C_Get_One_Transactions INTO l_transaction_rec;
559: EXIT WHEN C_Get_One_Transactions%NOTFOUND;
560: ELSE
561: v_ignore := DBMS_SQL.Fetch_Rows(v_cursorid);
562: --
563: IF l_debug_on THEN
564: WSH_DEBUG_SV.log(l_module_name, 'Fetched successfully', v_ignore);
565: END IF;

Line 571: DBMS_SQL.Column_Value(v_cursorid, 1, l_transaction_rec.Transaction_ID);

567: IF v_ignore = 0 THEN
568: EXIT;
569: END IF;
570:
571: DBMS_SQL.Column_Value(v_cursorid, 1, l_transaction_rec.Transaction_ID);
572: DBMS_SQL.Column_Value(v_cursorid, 2, l_transaction_rec.Document_Type);
573: DBMS_SQL.Column_Value(v_cursorid, 3, l_transaction_rec.Document_Direction);
574: DBMS_SQL.Column_Value(v_cursorid, 4, l_transaction_rec.Document_Number);
575: DBMS_SQL.Column_Value(v_cursorid, 5, l_transaction_rec.Orig_Document_Number);

Line 572: DBMS_SQL.Column_Value(v_cursorid, 2, l_transaction_rec.Document_Type);

568: EXIT;
569: END IF;
570:
571: DBMS_SQL.Column_Value(v_cursorid, 1, l_transaction_rec.Transaction_ID);
572: DBMS_SQL.Column_Value(v_cursorid, 2, l_transaction_rec.Document_Type);
573: DBMS_SQL.Column_Value(v_cursorid, 3, l_transaction_rec.Document_Direction);
574: DBMS_SQL.Column_Value(v_cursorid, 4, l_transaction_rec.Document_Number);
575: DBMS_SQL.Column_Value(v_cursorid, 5, l_transaction_rec.Orig_Document_Number);
576: DBMS_SQL.Column_Value(v_cursorid, 6, l_transaction_rec.Entity_Number);

Line 573: DBMS_SQL.Column_Value(v_cursorid, 3, l_transaction_rec.Document_Direction);

569: END IF;
570:
571: DBMS_SQL.Column_Value(v_cursorid, 1, l_transaction_rec.Transaction_ID);
572: DBMS_SQL.Column_Value(v_cursorid, 2, l_transaction_rec.Document_Type);
573: DBMS_SQL.Column_Value(v_cursorid, 3, l_transaction_rec.Document_Direction);
574: DBMS_SQL.Column_Value(v_cursorid, 4, l_transaction_rec.Document_Number);
575: DBMS_SQL.Column_Value(v_cursorid, 5, l_transaction_rec.Orig_Document_Number);
576: DBMS_SQL.Column_Value(v_cursorid, 6, l_transaction_rec.Entity_Number);
577: DBMS_SQL.Column_Value(v_cursorid, 7, l_transaction_rec.Entity_Type);

Line 574: DBMS_SQL.Column_Value(v_cursorid, 4, l_transaction_rec.Document_Number);

570:
571: DBMS_SQL.Column_Value(v_cursorid, 1, l_transaction_rec.Transaction_ID);
572: DBMS_SQL.Column_Value(v_cursorid, 2, l_transaction_rec.Document_Type);
573: DBMS_SQL.Column_Value(v_cursorid, 3, l_transaction_rec.Document_Direction);
574: DBMS_SQL.Column_Value(v_cursorid, 4, l_transaction_rec.Document_Number);
575: DBMS_SQL.Column_Value(v_cursorid, 5, l_transaction_rec.Orig_Document_Number);
576: DBMS_SQL.Column_Value(v_cursorid, 6, l_transaction_rec.Entity_Number);
577: DBMS_SQL.Column_Value(v_cursorid, 7, l_transaction_rec.Entity_Type);
578: DBMS_SQL.Column_Value(v_cursorid, 8, l_transaction_rec.Trading_Partner_ID);

Line 575: DBMS_SQL.Column_Value(v_cursorid, 5, l_transaction_rec.Orig_Document_Number);

571: DBMS_SQL.Column_Value(v_cursorid, 1, l_transaction_rec.Transaction_ID);
572: DBMS_SQL.Column_Value(v_cursorid, 2, l_transaction_rec.Document_Type);
573: DBMS_SQL.Column_Value(v_cursorid, 3, l_transaction_rec.Document_Direction);
574: DBMS_SQL.Column_Value(v_cursorid, 4, l_transaction_rec.Document_Number);
575: DBMS_SQL.Column_Value(v_cursorid, 5, l_transaction_rec.Orig_Document_Number);
576: DBMS_SQL.Column_Value(v_cursorid, 6, l_transaction_rec.Entity_Number);
577: DBMS_SQL.Column_Value(v_cursorid, 7, l_transaction_rec.Entity_Type);
578: DBMS_SQL.Column_Value(v_cursorid, 8, l_transaction_rec.Trading_Partner_ID);
579: DBMS_SQL.Column_Value(v_cursorid, 9, l_transaction_rec.Action_Type);

Line 576: DBMS_SQL.Column_Value(v_cursorid, 6, l_transaction_rec.Entity_Number);

572: DBMS_SQL.Column_Value(v_cursorid, 2, l_transaction_rec.Document_Type);
573: DBMS_SQL.Column_Value(v_cursorid, 3, l_transaction_rec.Document_Direction);
574: DBMS_SQL.Column_Value(v_cursorid, 4, l_transaction_rec.Document_Number);
575: DBMS_SQL.Column_Value(v_cursorid, 5, l_transaction_rec.Orig_Document_Number);
576: DBMS_SQL.Column_Value(v_cursorid, 6, l_transaction_rec.Entity_Number);
577: DBMS_SQL.Column_Value(v_cursorid, 7, l_transaction_rec.Entity_Type);
578: DBMS_SQL.Column_Value(v_cursorid, 8, l_transaction_rec.Trading_Partner_ID);
579: DBMS_SQL.Column_Value(v_cursorid, 9, l_transaction_rec.Action_Type);
580: DBMS_SQL.Column_Value(v_cursorid, 10, l_transaction_rec.Transaction_Status);

Line 577: DBMS_SQL.Column_Value(v_cursorid, 7, l_transaction_rec.Entity_Type);

573: DBMS_SQL.Column_Value(v_cursorid, 3, l_transaction_rec.Document_Direction);
574: DBMS_SQL.Column_Value(v_cursorid, 4, l_transaction_rec.Document_Number);
575: DBMS_SQL.Column_Value(v_cursorid, 5, l_transaction_rec.Orig_Document_Number);
576: DBMS_SQL.Column_Value(v_cursorid, 6, l_transaction_rec.Entity_Number);
577: DBMS_SQL.Column_Value(v_cursorid, 7, l_transaction_rec.Entity_Type);
578: DBMS_SQL.Column_Value(v_cursorid, 8, l_transaction_rec.Trading_Partner_ID);
579: DBMS_SQL.Column_Value(v_cursorid, 9, l_transaction_rec.Action_Type);
580: DBMS_SQL.Column_Value(v_cursorid, 10, l_transaction_rec.Transaction_Status);
581: DBMS_SQL.Column_Value_Raw(v_cursorid, 11, l_transaction_rec.ecx_message_id);

Line 578: DBMS_SQL.Column_Value(v_cursorid, 8, l_transaction_rec.Trading_Partner_ID);

574: DBMS_SQL.Column_Value(v_cursorid, 4, l_transaction_rec.Document_Number);
575: DBMS_SQL.Column_Value(v_cursorid, 5, l_transaction_rec.Orig_Document_Number);
576: DBMS_SQL.Column_Value(v_cursorid, 6, l_transaction_rec.Entity_Number);
577: DBMS_SQL.Column_Value(v_cursorid, 7, l_transaction_rec.Entity_Type);
578: DBMS_SQL.Column_Value(v_cursorid, 8, l_transaction_rec.Trading_Partner_ID);
579: DBMS_SQL.Column_Value(v_cursorid, 9, l_transaction_rec.Action_Type);
580: DBMS_SQL.Column_Value(v_cursorid, 10, l_transaction_rec.Transaction_Status);
581: DBMS_SQL.Column_Value_Raw(v_cursorid, 11, l_transaction_rec.ecx_message_id);
582: DBMS_SQL.Column_Value(v_cursorid, 12, l_transaction_rec.Event_Name);

Line 579: DBMS_SQL.Column_Value(v_cursorid, 9, l_transaction_rec.Action_Type);

575: DBMS_SQL.Column_Value(v_cursorid, 5, l_transaction_rec.Orig_Document_Number);
576: DBMS_SQL.Column_Value(v_cursorid, 6, l_transaction_rec.Entity_Number);
577: DBMS_SQL.Column_Value(v_cursorid, 7, l_transaction_rec.Entity_Type);
578: DBMS_SQL.Column_Value(v_cursorid, 8, l_transaction_rec.Trading_Partner_ID);
579: DBMS_SQL.Column_Value(v_cursorid, 9, l_transaction_rec.Action_Type);
580: DBMS_SQL.Column_Value(v_cursorid, 10, l_transaction_rec.Transaction_Status);
581: DBMS_SQL.Column_Value_Raw(v_cursorid, 11, l_transaction_rec.ecx_message_id);
582: DBMS_SQL.Column_Value(v_cursorid, 12, l_transaction_rec.Event_Name);
583: DBMS_SQL.Column_Value(v_cursorid, 13, l_transaction_rec.Event_Key);

Line 580: DBMS_SQL.Column_Value(v_cursorid, 10, l_transaction_rec.Transaction_Status);

576: DBMS_SQL.Column_Value(v_cursorid, 6, l_transaction_rec.Entity_Number);
577: DBMS_SQL.Column_Value(v_cursorid, 7, l_transaction_rec.Entity_Type);
578: DBMS_SQL.Column_Value(v_cursorid, 8, l_transaction_rec.Trading_Partner_ID);
579: DBMS_SQL.Column_Value(v_cursorid, 9, l_transaction_rec.Action_Type);
580: DBMS_SQL.Column_Value(v_cursorid, 10, l_transaction_rec.Transaction_Status);
581: DBMS_SQL.Column_Value_Raw(v_cursorid, 11, l_transaction_rec.ecx_message_id);
582: DBMS_SQL.Column_Value(v_cursorid, 12, l_transaction_rec.Event_Name);
583: DBMS_SQL.Column_Value(v_cursorid, 13, l_transaction_rec.Event_Key);
584: DBMS_SQL.Column_Value(v_cursorid, 14, l_transaction_rec.Item_Type);

Line 581: DBMS_SQL.Column_Value_Raw(v_cursorid, 11, l_transaction_rec.ecx_message_id);

577: DBMS_SQL.Column_Value(v_cursorid, 7, l_transaction_rec.Entity_Type);
578: DBMS_SQL.Column_Value(v_cursorid, 8, l_transaction_rec.Trading_Partner_ID);
579: DBMS_SQL.Column_Value(v_cursorid, 9, l_transaction_rec.Action_Type);
580: DBMS_SQL.Column_Value(v_cursorid, 10, l_transaction_rec.Transaction_Status);
581: DBMS_SQL.Column_Value_Raw(v_cursorid, 11, l_transaction_rec.ecx_message_id);
582: DBMS_SQL.Column_Value(v_cursorid, 12, l_transaction_rec.Event_Name);
583: DBMS_SQL.Column_Value(v_cursorid, 13, l_transaction_rec.Event_Key);
584: DBMS_SQL.Column_Value(v_cursorid, 14, l_transaction_rec.Item_Type);
585: DBMS_SQL.Column_Value(v_cursorid, 15, l_transaction_rec.Internal_Control_Number);

Line 582: DBMS_SQL.Column_Value(v_cursorid, 12, l_transaction_rec.Event_Name);

578: DBMS_SQL.Column_Value(v_cursorid, 8, l_transaction_rec.Trading_Partner_ID);
579: DBMS_SQL.Column_Value(v_cursorid, 9, l_transaction_rec.Action_Type);
580: DBMS_SQL.Column_Value(v_cursorid, 10, l_transaction_rec.Transaction_Status);
581: DBMS_SQL.Column_Value_Raw(v_cursorid, 11, l_transaction_rec.ecx_message_id);
582: DBMS_SQL.Column_Value(v_cursorid, 12, l_transaction_rec.Event_Name);
583: DBMS_SQL.Column_Value(v_cursorid, 13, l_transaction_rec.Event_Key);
584: DBMS_SQL.Column_Value(v_cursorid, 14, l_transaction_rec.Item_Type);
585: DBMS_SQL.Column_Value(v_cursorid, 15, l_transaction_rec.Internal_Control_Number);
586: DBMS_SQL.Column_Value(v_cursorid, 16, l_transaction_rec.document_revision);

Line 583: DBMS_SQL.Column_Value(v_cursorid, 13, l_transaction_rec.Event_Key);

579: DBMS_SQL.Column_Value(v_cursorid, 9, l_transaction_rec.Action_Type);
580: DBMS_SQL.Column_Value(v_cursorid, 10, l_transaction_rec.Transaction_Status);
581: DBMS_SQL.Column_Value_Raw(v_cursorid, 11, l_transaction_rec.ecx_message_id);
582: DBMS_SQL.Column_Value(v_cursorid, 12, l_transaction_rec.Event_Name);
583: DBMS_SQL.Column_Value(v_cursorid, 13, l_transaction_rec.Event_Key);
584: DBMS_SQL.Column_Value(v_cursorid, 14, l_transaction_rec.Item_Type);
585: DBMS_SQL.Column_Value(v_cursorid, 15, l_transaction_rec.Internal_Control_Number);
586: DBMS_SQL.Column_Value(v_cursorid, 16, l_transaction_rec.document_revision);
587: DBMS_SQL.Column_Value(v_cursorid, 17, l_transaction_rec.Attribute_Category);

Line 584: DBMS_SQL.Column_Value(v_cursorid, 14, l_transaction_rec.Item_Type);

580: DBMS_SQL.Column_Value(v_cursorid, 10, l_transaction_rec.Transaction_Status);
581: DBMS_SQL.Column_Value_Raw(v_cursorid, 11, l_transaction_rec.ecx_message_id);
582: DBMS_SQL.Column_Value(v_cursorid, 12, l_transaction_rec.Event_Name);
583: DBMS_SQL.Column_Value(v_cursorid, 13, l_transaction_rec.Event_Key);
584: DBMS_SQL.Column_Value(v_cursorid, 14, l_transaction_rec.Item_Type);
585: DBMS_SQL.Column_Value(v_cursorid, 15, l_transaction_rec.Internal_Control_Number);
586: DBMS_SQL.Column_Value(v_cursorid, 16, l_transaction_rec.document_revision);
587: DBMS_SQL.Column_Value(v_cursorid, 17, l_transaction_rec.Attribute_Category);
588: DBMS_SQL.Column_Value(v_cursorid, 18, l_transaction_rec.Attribute1);

Line 585: DBMS_SQL.Column_Value(v_cursorid, 15, l_transaction_rec.Internal_Control_Number);

581: DBMS_SQL.Column_Value_Raw(v_cursorid, 11, l_transaction_rec.ecx_message_id);
582: DBMS_SQL.Column_Value(v_cursorid, 12, l_transaction_rec.Event_Name);
583: DBMS_SQL.Column_Value(v_cursorid, 13, l_transaction_rec.Event_Key);
584: DBMS_SQL.Column_Value(v_cursorid, 14, l_transaction_rec.Item_Type);
585: DBMS_SQL.Column_Value(v_cursorid, 15, l_transaction_rec.Internal_Control_Number);
586: DBMS_SQL.Column_Value(v_cursorid, 16, l_transaction_rec.document_revision);
587: DBMS_SQL.Column_Value(v_cursorid, 17, l_transaction_rec.Attribute_Category);
588: DBMS_SQL.Column_Value(v_cursorid, 18, l_transaction_rec.Attribute1);
589: DBMS_SQL.Column_Value(v_cursorid, 19, l_transaction_rec.Attribute2);

Line 586: DBMS_SQL.Column_Value(v_cursorid, 16, l_transaction_rec.document_revision);

582: DBMS_SQL.Column_Value(v_cursorid, 12, l_transaction_rec.Event_Name);
583: DBMS_SQL.Column_Value(v_cursorid, 13, l_transaction_rec.Event_Key);
584: DBMS_SQL.Column_Value(v_cursorid, 14, l_transaction_rec.Item_Type);
585: DBMS_SQL.Column_Value(v_cursorid, 15, l_transaction_rec.Internal_Control_Number);
586: DBMS_SQL.Column_Value(v_cursorid, 16, l_transaction_rec.document_revision);
587: DBMS_SQL.Column_Value(v_cursorid, 17, l_transaction_rec.Attribute_Category);
588: DBMS_SQL.Column_Value(v_cursorid, 18, l_transaction_rec.Attribute1);
589: DBMS_SQL.Column_Value(v_cursorid, 19, l_transaction_rec.Attribute2);
590: DBMS_SQL.Column_Value(v_cursorid, 20, l_transaction_rec.Attribute3);

Line 587: DBMS_SQL.Column_Value(v_cursorid, 17, l_transaction_rec.Attribute_Category);

583: DBMS_SQL.Column_Value(v_cursorid, 13, l_transaction_rec.Event_Key);
584: DBMS_SQL.Column_Value(v_cursorid, 14, l_transaction_rec.Item_Type);
585: DBMS_SQL.Column_Value(v_cursorid, 15, l_transaction_rec.Internal_Control_Number);
586: DBMS_SQL.Column_Value(v_cursorid, 16, l_transaction_rec.document_revision);
587: DBMS_SQL.Column_Value(v_cursorid, 17, l_transaction_rec.Attribute_Category);
588: DBMS_SQL.Column_Value(v_cursorid, 18, l_transaction_rec.Attribute1);
589: DBMS_SQL.Column_Value(v_cursorid, 19, l_transaction_rec.Attribute2);
590: DBMS_SQL.Column_Value(v_cursorid, 20, l_transaction_rec.Attribute3);
591: DBMS_SQL.Column_Value(v_cursorid, 21, l_transaction_rec.Attribute4);

Line 588: DBMS_SQL.Column_Value(v_cursorid, 18, l_transaction_rec.Attribute1);

584: DBMS_SQL.Column_Value(v_cursorid, 14, l_transaction_rec.Item_Type);
585: DBMS_SQL.Column_Value(v_cursorid, 15, l_transaction_rec.Internal_Control_Number);
586: DBMS_SQL.Column_Value(v_cursorid, 16, l_transaction_rec.document_revision);
587: DBMS_SQL.Column_Value(v_cursorid, 17, l_transaction_rec.Attribute_Category);
588: DBMS_SQL.Column_Value(v_cursorid, 18, l_transaction_rec.Attribute1);
589: DBMS_SQL.Column_Value(v_cursorid, 19, l_transaction_rec.Attribute2);
590: DBMS_SQL.Column_Value(v_cursorid, 20, l_transaction_rec.Attribute3);
591: DBMS_SQL.Column_Value(v_cursorid, 21, l_transaction_rec.Attribute4);
592: DBMS_SQL.Column_Value(v_cursorid, 22, l_transaction_rec.Attribute5);

Line 589: DBMS_SQL.Column_Value(v_cursorid, 19, l_transaction_rec.Attribute2);

585: DBMS_SQL.Column_Value(v_cursorid, 15, l_transaction_rec.Internal_Control_Number);
586: DBMS_SQL.Column_Value(v_cursorid, 16, l_transaction_rec.document_revision);
587: DBMS_SQL.Column_Value(v_cursorid, 17, l_transaction_rec.Attribute_Category);
588: DBMS_SQL.Column_Value(v_cursorid, 18, l_transaction_rec.Attribute1);
589: DBMS_SQL.Column_Value(v_cursorid, 19, l_transaction_rec.Attribute2);
590: DBMS_SQL.Column_Value(v_cursorid, 20, l_transaction_rec.Attribute3);
591: DBMS_SQL.Column_Value(v_cursorid, 21, l_transaction_rec.Attribute4);
592: DBMS_SQL.Column_Value(v_cursorid, 22, l_transaction_rec.Attribute5);
593: DBMS_SQL.Column_Value(v_cursorid, 23, l_transaction_rec.Attribute6);

Line 590: DBMS_SQL.Column_Value(v_cursorid, 20, l_transaction_rec.Attribute3);

586: DBMS_SQL.Column_Value(v_cursorid, 16, l_transaction_rec.document_revision);
587: DBMS_SQL.Column_Value(v_cursorid, 17, l_transaction_rec.Attribute_Category);
588: DBMS_SQL.Column_Value(v_cursorid, 18, l_transaction_rec.Attribute1);
589: DBMS_SQL.Column_Value(v_cursorid, 19, l_transaction_rec.Attribute2);
590: DBMS_SQL.Column_Value(v_cursorid, 20, l_transaction_rec.Attribute3);
591: DBMS_SQL.Column_Value(v_cursorid, 21, l_transaction_rec.Attribute4);
592: DBMS_SQL.Column_Value(v_cursorid, 22, l_transaction_rec.Attribute5);
593: DBMS_SQL.Column_Value(v_cursorid, 23, l_transaction_rec.Attribute6);
594: DBMS_SQL.Column_Value(v_cursorid, 24, l_transaction_rec.Attribute7);

Line 591: DBMS_SQL.Column_Value(v_cursorid, 21, l_transaction_rec.Attribute4);

587: DBMS_SQL.Column_Value(v_cursorid, 17, l_transaction_rec.Attribute_Category);
588: DBMS_SQL.Column_Value(v_cursorid, 18, l_transaction_rec.Attribute1);
589: DBMS_SQL.Column_Value(v_cursorid, 19, l_transaction_rec.Attribute2);
590: DBMS_SQL.Column_Value(v_cursorid, 20, l_transaction_rec.Attribute3);
591: DBMS_SQL.Column_Value(v_cursorid, 21, l_transaction_rec.Attribute4);
592: DBMS_SQL.Column_Value(v_cursorid, 22, l_transaction_rec.Attribute5);
593: DBMS_SQL.Column_Value(v_cursorid, 23, l_transaction_rec.Attribute6);
594: DBMS_SQL.Column_Value(v_cursorid, 24, l_transaction_rec.Attribute7);
595: DBMS_SQL.Column_Value(v_cursorid, 25, l_transaction_rec.Attribute8);

Line 592: DBMS_SQL.Column_Value(v_cursorid, 22, l_transaction_rec.Attribute5);

588: DBMS_SQL.Column_Value(v_cursorid, 18, l_transaction_rec.Attribute1);
589: DBMS_SQL.Column_Value(v_cursorid, 19, l_transaction_rec.Attribute2);
590: DBMS_SQL.Column_Value(v_cursorid, 20, l_transaction_rec.Attribute3);
591: DBMS_SQL.Column_Value(v_cursorid, 21, l_transaction_rec.Attribute4);
592: DBMS_SQL.Column_Value(v_cursorid, 22, l_transaction_rec.Attribute5);
593: DBMS_SQL.Column_Value(v_cursorid, 23, l_transaction_rec.Attribute6);
594: DBMS_SQL.Column_Value(v_cursorid, 24, l_transaction_rec.Attribute7);
595: DBMS_SQL.Column_Value(v_cursorid, 25, l_transaction_rec.Attribute8);
596: DBMS_SQL.Column_Value(v_cursorid, 26, l_transaction_rec.Attribute9);

Line 593: DBMS_SQL.Column_Value(v_cursorid, 23, l_transaction_rec.Attribute6);

589: DBMS_SQL.Column_Value(v_cursorid, 19, l_transaction_rec.Attribute2);
590: DBMS_SQL.Column_Value(v_cursorid, 20, l_transaction_rec.Attribute3);
591: DBMS_SQL.Column_Value(v_cursorid, 21, l_transaction_rec.Attribute4);
592: DBMS_SQL.Column_Value(v_cursorid, 22, l_transaction_rec.Attribute5);
593: DBMS_SQL.Column_Value(v_cursorid, 23, l_transaction_rec.Attribute6);
594: DBMS_SQL.Column_Value(v_cursorid, 24, l_transaction_rec.Attribute7);
595: DBMS_SQL.Column_Value(v_cursorid, 25, l_transaction_rec.Attribute8);
596: DBMS_SQL.Column_Value(v_cursorid, 26, l_transaction_rec.Attribute9);
597: DBMS_SQL.Column_Value(v_cursorid, 27, l_transaction_rec.Attribute10);

Line 594: DBMS_SQL.Column_Value(v_cursorid, 24, l_transaction_rec.Attribute7);

590: DBMS_SQL.Column_Value(v_cursorid, 20, l_transaction_rec.Attribute3);
591: DBMS_SQL.Column_Value(v_cursorid, 21, l_transaction_rec.Attribute4);
592: DBMS_SQL.Column_Value(v_cursorid, 22, l_transaction_rec.Attribute5);
593: DBMS_SQL.Column_Value(v_cursorid, 23, l_transaction_rec.Attribute6);
594: DBMS_SQL.Column_Value(v_cursorid, 24, l_transaction_rec.Attribute7);
595: DBMS_SQL.Column_Value(v_cursorid, 25, l_transaction_rec.Attribute8);
596: DBMS_SQL.Column_Value(v_cursorid, 26, l_transaction_rec.Attribute9);
597: DBMS_SQL.Column_Value(v_cursorid, 27, l_transaction_rec.Attribute10);
598: DBMS_SQL.Column_Value(v_cursorid, 28, l_transaction_rec.Attribute11);

Line 595: DBMS_SQL.Column_Value(v_cursorid, 25, l_transaction_rec.Attribute8);

591: DBMS_SQL.Column_Value(v_cursorid, 21, l_transaction_rec.Attribute4);
592: DBMS_SQL.Column_Value(v_cursorid, 22, l_transaction_rec.Attribute5);
593: DBMS_SQL.Column_Value(v_cursorid, 23, l_transaction_rec.Attribute6);
594: DBMS_SQL.Column_Value(v_cursorid, 24, l_transaction_rec.Attribute7);
595: DBMS_SQL.Column_Value(v_cursorid, 25, l_transaction_rec.Attribute8);
596: DBMS_SQL.Column_Value(v_cursorid, 26, l_transaction_rec.Attribute9);
597: DBMS_SQL.Column_Value(v_cursorid, 27, l_transaction_rec.Attribute10);
598: DBMS_SQL.Column_Value(v_cursorid, 28, l_transaction_rec.Attribute11);
599: DBMS_SQL.Column_Value(v_cursorid, 29, l_transaction_rec.Attribute12);

Line 596: DBMS_SQL.Column_Value(v_cursorid, 26, l_transaction_rec.Attribute9);

592: DBMS_SQL.Column_Value(v_cursorid, 22, l_transaction_rec.Attribute5);
593: DBMS_SQL.Column_Value(v_cursorid, 23, l_transaction_rec.Attribute6);
594: DBMS_SQL.Column_Value(v_cursorid, 24, l_transaction_rec.Attribute7);
595: DBMS_SQL.Column_Value(v_cursorid, 25, l_transaction_rec.Attribute8);
596: DBMS_SQL.Column_Value(v_cursorid, 26, l_transaction_rec.Attribute9);
597: DBMS_SQL.Column_Value(v_cursorid, 27, l_transaction_rec.Attribute10);
598: DBMS_SQL.Column_Value(v_cursorid, 28, l_transaction_rec.Attribute11);
599: DBMS_SQL.Column_Value(v_cursorid, 29, l_transaction_rec.Attribute12);
600: DBMS_SQL.Column_Value(v_cursorid, 30, l_transaction_rec.Attribute13);

Line 597: DBMS_SQL.Column_Value(v_cursorid, 27, l_transaction_rec.Attribute10);

593: DBMS_SQL.Column_Value(v_cursorid, 23, l_transaction_rec.Attribute6);
594: DBMS_SQL.Column_Value(v_cursorid, 24, l_transaction_rec.Attribute7);
595: DBMS_SQL.Column_Value(v_cursorid, 25, l_transaction_rec.Attribute8);
596: DBMS_SQL.Column_Value(v_cursorid, 26, l_transaction_rec.Attribute9);
597: DBMS_SQL.Column_Value(v_cursorid, 27, l_transaction_rec.Attribute10);
598: DBMS_SQL.Column_Value(v_cursorid, 28, l_transaction_rec.Attribute11);
599: DBMS_SQL.Column_Value(v_cursorid, 29, l_transaction_rec.Attribute12);
600: DBMS_SQL.Column_Value(v_cursorid, 30, l_transaction_rec.Attribute13);
601: DBMS_SQL.Column_Value(v_cursorid, 31, l_transaction_rec.Attribute14);

Line 598: DBMS_SQL.Column_Value(v_cursorid, 28, l_transaction_rec.Attribute11);

594: DBMS_SQL.Column_Value(v_cursorid, 24, l_transaction_rec.Attribute7);
595: DBMS_SQL.Column_Value(v_cursorid, 25, l_transaction_rec.Attribute8);
596: DBMS_SQL.Column_Value(v_cursorid, 26, l_transaction_rec.Attribute9);
597: DBMS_SQL.Column_Value(v_cursorid, 27, l_transaction_rec.Attribute10);
598: DBMS_SQL.Column_Value(v_cursorid, 28, l_transaction_rec.Attribute11);
599: DBMS_SQL.Column_Value(v_cursorid, 29, l_transaction_rec.Attribute12);
600: DBMS_SQL.Column_Value(v_cursorid, 30, l_transaction_rec.Attribute13);
601: DBMS_SQL.Column_Value(v_cursorid, 31, l_transaction_rec.Attribute14);
602: DBMS_SQL.Column_Value(v_cursorid, 32, l_transaction_rec.Attribute15);

Line 599: DBMS_SQL.Column_Value(v_cursorid, 29, l_transaction_rec.Attribute12);

595: DBMS_SQL.Column_Value(v_cursorid, 25, l_transaction_rec.Attribute8);
596: DBMS_SQL.Column_Value(v_cursorid, 26, l_transaction_rec.Attribute9);
597: DBMS_SQL.Column_Value(v_cursorid, 27, l_transaction_rec.Attribute10);
598: DBMS_SQL.Column_Value(v_cursorid, 28, l_transaction_rec.Attribute11);
599: DBMS_SQL.Column_Value(v_cursorid, 29, l_transaction_rec.Attribute12);
600: DBMS_SQL.Column_Value(v_cursorid, 30, l_transaction_rec.Attribute13);
601: DBMS_SQL.Column_Value(v_cursorid, 31, l_transaction_rec.Attribute14);
602: DBMS_SQL.Column_Value(v_cursorid, 32, l_transaction_rec.Attribute15);
603: --

Line 600: DBMS_SQL.Column_Value(v_cursorid, 30, l_transaction_rec.Attribute13);

596: DBMS_SQL.Column_Value(v_cursorid, 26, l_transaction_rec.Attribute9);
597: DBMS_SQL.Column_Value(v_cursorid, 27, l_transaction_rec.Attribute10);
598: DBMS_SQL.Column_Value(v_cursorid, 28, l_transaction_rec.Attribute11);
599: DBMS_SQL.Column_Value(v_cursorid, 29, l_transaction_rec.Attribute12);
600: DBMS_SQL.Column_Value(v_cursorid, 30, l_transaction_rec.Attribute13);
601: DBMS_SQL.Column_Value(v_cursorid, 31, l_transaction_rec.Attribute14);
602: DBMS_SQL.Column_Value(v_cursorid, 32, l_transaction_rec.Attribute15);
603: --
604: IF l_debug_on THEN

Line 601: DBMS_SQL.Column_Value(v_cursorid, 31, l_transaction_rec.Attribute14);

597: DBMS_SQL.Column_Value(v_cursorid, 27, l_transaction_rec.Attribute10);
598: DBMS_SQL.Column_Value(v_cursorid, 28, l_transaction_rec.Attribute11);
599: DBMS_SQL.Column_Value(v_cursorid, 29, l_transaction_rec.Attribute12);
600: DBMS_SQL.Column_Value(v_cursorid, 30, l_transaction_rec.Attribute13);
601: DBMS_SQL.Column_Value(v_cursorid, 31, l_transaction_rec.Attribute14);
602: DBMS_SQL.Column_Value(v_cursorid, 32, l_transaction_rec.Attribute15);
603: --
604: IF l_debug_on THEN
605: WSH_DEBUG_SV.logmsg(l_module_name, 'Fetched from cursor successfully');

Line 602: DBMS_SQL.Column_Value(v_cursorid, 32, l_transaction_rec.Attribute15);

598: DBMS_SQL.Column_Value(v_cursorid, 28, l_transaction_rec.Attribute11);
599: DBMS_SQL.Column_Value(v_cursorid, 29, l_transaction_rec.Attribute12);
600: DBMS_SQL.Column_Value(v_cursorid, 30, l_transaction_rec.Attribute13);
601: DBMS_SQL.Column_Value(v_cursorid, 31, l_transaction_rec.Attribute14);
602: DBMS_SQL.Column_Value(v_cursorid, 32, l_transaction_rec.Attribute15);
603: --
604: IF l_debug_on THEN
605: WSH_DEBUG_SV.logmsg(l_module_name, 'Fetched from cursor successfully');
606: END IF;

Line 679: IF DBMS_SQL.Is_Open(v_cursorid) THEN

675: IF C_Get_One_Transactions%ISOPEN THEN
676: CLOSE C_Get_One_Transactions;
677: END IF;
678: ELSE
679: IF DBMS_SQL.Is_Open(v_cursorid) THEN
680: --
681: IF l_debug_on THEN
682: WSH_DEBUG_SV.logmsg(l_module_name, 'Closing cursor');
683: END IF;

Line 685: DBMS_SQL.Close_Cursor(v_cursorid);

681: IF l_debug_on THEN
682: WSH_DEBUG_SV.logmsg(l_module_name, 'Closing cursor');
683: END IF;
684: --
685: DBMS_SQL.Close_Cursor(v_cursorid);
686: v_cursorid := null;
687: END IF;
688: END IF;
689:

Line 731: IF DBMS_SQL.Is_Open(v_cursorid) THEN

727: IF C_Get_One_Transactions%ISOPEN THEN
728: CLOSE C_Get_One_Transactions;
729: END IF;
730: ELSE
731: IF DBMS_SQL.Is_Open(v_cursorid) THEN
732: DBMS_SQL.Close_Cursor(v_cursorid);
733: v_cursorid := null;
734: END IF;
735: END IF;

Line 732: DBMS_SQL.Close_Cursor(v_cursorid);

728: CLOSE C_Get_One_Transactions;
729: END IF;
730: ELSE
731: IF DBMS_SQL.Is_Open(v_cursorid) THEN
732: DBMS_SQL.Close_Cursor(v_cursorid);
733: v_cursorid := null;
734: END IF;
735: END IF;
736: --

Line 750: IF DBMS_SQL.Is_Open(v_cursorid) THEN

746: IF C_Get_One_Transactions%ISOPEN THEN
747: CLOSE C_Get_One_Transactions;
748: END IF;
749: ELSE
750: IF DBMS_SQL.Is_Open(v_cursorid) THEN
751: DBMS_SQL.Close_Cursor(v_cursorid);
752: v_cursorid := null;
753: END IF;
754: END IF;

Line 751: DBMS_SQL.Close_Cursor(v_cursorid);

747: CLOSE C_Get_One_Transactions;
748: END IF;
749: ELSE
750: IF DBMS_SQL.Is_Open(v_cursorid) THEN
751: DBMS_SQL.Close_Cursor(v_cursorid);
752: v_cursorid := null;
753: END IF;
754: END IF;
755: --