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_ADVICE_PKG dependencies on DBMS_SQL

Line 351: v_cursorid := DBMS_SQL.Open_Cursor;

347: WSH_DEBUG_SV.log(l_module_name, 'Transaction Query', l_transaction_query);
348: END IF;
349: --
350:
351: v_cursorid := DBMS_SQL.Open_Cursor;
352: --
353: IF l_debug_on THEN
354: WSH_DEBUG_SV.log(l_module_name, 'Opended cursor successfully', v_cursorid);
355: END IF;

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

353: IF l_debug_on THEN
354: WSH_DEBUG_SV.log(l_module_name, 'Opended cursor successfully', v_cursorid);
355: END IF;
356: --
357: DBMS_SQL.Parse(v_cursorid, l_transaction_query, DBMS_SQL.v7 );
358:
359: --
360: IF l_debug_on THEN
361: WSH_DEBUG_SV.logmsg(l_module_name, 'Parsed cursor successfully');

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

360: IF l_debug_on THEN
361: WSH_DEBUG_SV.logmsg(l_module_name, 'Parsed cursor successfully');
362: END IF;
363: --
364: DBMS_SQL.Define_Column(v_cursorid, 1, l_transaction_rec.Transaction_ID);
365: DBMS_SQL.Define_Column(v_cursorid, 2, l_transaction_rec.Document_Type, 30);
366: DBMS_SQL.Define_Column(v_cursorid, 3, l_transaction_rec.Document_Direction, 1);
367: DBMS_SQL.Define_Column(v_cursorid, 4, l_transaction_rec.Document_Number, 120);
368: DBMS_SQL.Define_Column(v_cursorid, 5, l_transaction_rec.Orig_Document_Number, 120);

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

361: WSH_DEBUG_SV.logmsg(l_module_name, 'Parsed cursor successfully');
362: END IF;
363: --
364: DBMS_SQL.Define_Column(v_cursorid, 1, l_transaction_rec.Transaction_ID);
365: DBMS_SQL.Define_Column(v_cursorid, 2, l_transaction_rec.Document_Type, 30);
366: DBMS_SQL.Define_Column(v_cursorid, 3, l_transaction_rec.Document_Direction, 1);
367: DBMS_SQL.Define_Column(v_cursorid, 4, l_transaction_rec.Document_Number, 120);
368: DBMS_SQL.Define_Column(v_cursorid, 5, l_transaction_rec.Orig_Document_Number, 120);
369: DBMS_SQL.Define_Column(v_cursorid, 6, l_transaction_rec.Entity_Number, 30);

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

362: END IF;
363: --
364: DBMS_SQL.Define_Column(v_cursorid, 1, l_transaction_rec.Transaction_ID);
365: DBMS_SQL.Define_Column(v_cursorid, 2, l_transaction_rec.Document_Type, 30);
366: DBMS_SQL.Define_Column(v_cursorid, 3, l_transaction_rec.Document_Direction, 1);
367: DBMS_SQL.Define_Column(v_cursorid, 4, l_transaction_rec.Document_Number, 120);
368: DBMS_SQL.Define_Column(v_cursorid, 5, l_transaction_rec.Orig_Document_Number, 120);
369: DBMS_SQL.Define_Column(v_cursorid, 6, l_transaction_rec.Entity_Number, 30);
370: DBMS_SQL.Define_Column(v_cursorid, 7, l_transaction_rec.Entity_Type, 30);

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

363: --
364: DBMS_SQL.Define_Column(v_cursorid, 1, l_transaction_rec.Transaction_ID);
365: DBMS_SQL.Define_Column(v_cursorid, 2, l_transaction_rec.Document_Type, 30);
366: DBMS_SQL.Define_Column(v_cursorid, 3, l_transaction_rec.Document_Direction, 1);
367: DBMS_SQL.Define_Column(v_cursorid, 4, l_transaction_rec.Document_Number, 120);
368: DBMS_SQL.Define_Column(v_cursorid, 5, l_transaction_rec.Orig_Document_Number, 120);
369: DBMS_SQL.Define_Column(v_cursorid, 6, l_transaction_rec.Entity_Number, 30);
370: DBMS_SQL.Define_Column(v_cursorid, 7, l_transaction_rec.Entity_Type, 30);
371: DBMS_SQL.Define_Column(v_cursorid, 8, l_transaction_rec.Trading_Partner_ID);

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

364: DBMS_SQL.Define_Column(v_cursorid, 1, l_transaction_rec.Transaction_ID);
365: DBMS_SQL.Define_Column(v_cursorid, 2, l_transaction_rec.Document_Type, 30);
366: DBMS_SQL.Define_Column(v_cursorid, 3, l_transaction_rec.Document_Direction, 1);
367: DBMS_SQL.Define_Column(v_cursorid, 4, l_transaction_rec.Document_Number, 120);
368: DBMS_SQL.Define_Column(v_cursorid, 5, l_transaction_rec.Orig_Document_Number, 120);
369: DBMS_SQL.Define_Column(v_cursorid, 6, l_transaction_rec.Entity_Number, 30);
370: DBMS_SQL.Define_Column(v_cursorid, 7, l_transaction_rec.Entity_Type, 30);
371: DBMS_SQL.Define_Column(v_cursorid, 8, l_transaction_rec.Trading_Partner_ID);
372: DBMS_SQL.Define_Column(v_cursorid, 9, l_transaction_rec.Action_Type, 30);

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

365: DBMS_SQL.Define_Column(v_cursorid, 2, l_transaction_rec.Document_Type, 30);
366: DBMS_SQL.Define_Column(v_cursorid, 3, l_transaction_rec.Document_Direction, 1);
367: DBMS_SQL.Define_Column(v_cursorid, 4, l_transaction_rec.Document_Number, 120);
368: DBMS_SQL.Define_Column(v_cursorid, 5, l_transaction_rec.Orig_Document_Number, 120);
369: DBMS_SQL.Define_Column(v_cursorid, 6, l_transaction_rec.Entity_Number, 30);
370: DBMS_SQL.Define_Column(v_cursorid, 7, l_transaction_rec.Entity_Type, 30);
371: DBMS_SQL.Define_Column(v_cursorid, 8, l_transaction_rec.Trading_Partner_ID);
372: DBMS_SQL.Define_Column(v_cursorid, 9, l_transaction_rec.Action_Type, 30);
373: DBMS_SQL.Define_Column(v_cursorid, 10, l_transaction_rec.Transaction_Status, 2);

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

366: DBMS_SQL.Define_Column(v_cursorid, 3, l_transaction_rec.Document_Direction, 1);
367: DBMS_SQL.Define_Column(v_cursorid, 4, l_transaction_rec.Document_Number, 120);
368: DBMS_SQL.Define_Column(v_cursorid, 5, l_transaction_rec.Orig_Document_Number, 120);
369: DBMS_SQL.Define_Column(v_cursorid, 6, l_transaction_rec.Entity_Number, 30);
370: DBMS_SQL.Define_Column(v_cursorid, 7, l_transaction_rec.Entity_Type, 30);
371: DBMS_SQL.Define_Column(v_cursorid, 8, l_transaction_rec.Trading_Partner_ID);
372: DBMS_SQL.Define_Column(v_cursorid, 9, l_transaction_rec.Action_Type, 30);
373: DBMS_SQL.Define_Column(v_cursorid, 10, l_transaction_rec.Transaction_Status, 2);
374: DBMS_SQL.Define_Column_Raw(v_cursorid, 11, l_transaction_rec.ecx_message_id, 16);

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

367: DBMS_SQL.Define_Column(v_cursorid, 4, l_transaction_rec.Document_Number, 120);
368: DBMS_SQL.Define_Column(v_cursorid, 5, l_transaction_rec.Orig_Document_Number, 120);
369: DBMS_SQL.Define_Column(v_cursorid, 6, l_transaction_rec.Entity_Number, 30);
370: DBMS_SQL.Define_Column(v_cursorid, 7, l_transaction_rec.Entity_Type, 30);
371: DBMS_SQL.Define_Column(v_cursorid, 8, l_transaction_rec.Trading_Partner_ID);
372: DBMS_SQL.Define_Column(v_cursorid, 9, l_transaction_rec.Action_Type, 30);
373: DBMS_SQL.Define_Column(v_cursorid, 10, l_transaction_rec.Transaction_Status, 2);
374: DBMS_SQL.Define_Column_Raw(v_cursorid, 11, l_transaction_rec.ecx_message_id, 16);
375: DBMS_SQL.Define_Column(v_cursorid, 12, l_transaction_rec.Event_Name, 240);

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

368: DBMS_SQL.Define_Column(v_cursorid, 5, l_transaction_rec.Orig_Document_Number, 120);
369: DBMS_SQL.Define_Column(v_cursorid, 6, l_transaction_rec.Entity_Number, 30);
370: DBMS_SQL.Define_Column(v_cursorid, 7, l_transaction_rec.Entity_Type, 30);
371: DBMS_SQL.Define_Column(v_cursorid, 8, l_transaction_rec.Trading_Partner_ID);
372: DBMS_SQL.Define_Column(v_cursorid, 9, l_transaction_rec.Action_Type, 30);
373: DBMS_SQL.Define_Column(v_cursorid, 10, l_transaction_rec.Transaction_Status, 2);
374: DBMS_SQL.Define_Column_Raw(v_cursorid, 11, l_transaction_rec.ecx_message_id, 16);
375: DBMS_SQL.Define_Column(v_cursorid, 12, l_transaction_rec.Event_Name, 240);
376: DBMS_SQL.Define_Column(v_cursorid, 13, l_transaction_rec.Event_Key, 240);

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

369: DBMS_SQL.Define_Column(v_cursorid, 6, l_transaction_rec.Entity_Number, 30);
370: DBMS_SQL.Define_Column(v_cursorid, 7, l_transaction_rec.Entity_Type, 30);
371: DBMS_SQL.Define_Column(v_cursorid, 8, l_transaction_rec.Trading_Partner_ID);
372: DBMS_SQL.Define_Column(v_cursorid, 9, l_transaction_rec.Action_Type, 30);
373: DBMS_SQL.Define_Column(v_cursorid, 10, l_transaction_rec.Transaction_Status, 2);
374: DBMS_SQL.Define_Column_Raw(v_cursorid, 11, l_transaction_rec.ecx_message_id, 16);
375: DBMS_SQL.Define_Column(v_cursorid, 12, l_transaction_rec.Event_Name, 240);
376: DBMS_SQL.Define_Column(v_cursorid, 13, l_transaction_rec.Event_Key, 240);
377: DBMS_SQL.Define_Column(v_cursorid, 14, l_transaction_rec.Item_Type, 8);

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

370: DBMS_SQL.Define_Column(v_cursorid, 7, l_transaction_rec.Entity_Type, 30);
371: DBMS_SQL.Define_Column(v_cursorid, 8, l_transaction_rec.Trading_Partner_ID);
372: DBMS_SQL.Define_Column(v_cursorid, 9, l_transaction_rec.Action_Type, 30);
373: DBMS_SQL.Define_Column(v_cursorid, 10, l_transaction_rec.Transaction_Status, 2);
374: DBMS_SQL.Define_Column_Raw(v_cursorid, 11, l_transaction_rec.ecx_message_id, 16);
375: DBMS_SQL.Define_Column(v_cursorid, 12, l_transaction_rec.Event_Name, 240);
376: DBMS_SQL.Define_Column(v_cursorid, 13, l_transaction_rec.Event_Key, 240);
377: DBMS_SQL.Define_Column(v_cursorid, 14, l_transaction_rec.Item_Type, 8);
378: DBMS_SQL.Define_Column(v_cursorid, 15, l_transaction_rec.Internal_Control_Number);

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

371: DBMS_SQL.Define_Column(v_cursorid, 8, l_transaction_rec.Trading_Partner_ID);
372: DBMS_SQL.Define_Column(v_cursorid, 9, l_transaction_rec.Action_Type, 30);
373: DBMS_SQL.Define_Column(v_cursorid, 10, l_transaction_rec.Transaction_Status, 2);
374: DBMS_SQL.Define_Column_Raw(v_cursorid, 11, l_transaction_rec.ecx_message_id, 16);
375: DBMS_SQL.Define_Column(v_cursorid, 12, l_transaction_rec.Event_Name, 240);
376: DBMS_SQL.Define_Column(v_cursorid, 13, l_transaction_rec.Event_Key, 240);
377: DBMS_SQL.Define_Column(v_cursorid, 14, l_transaction_rec.Item_Type, 8);
378: DBMS_SQL.Define_Column(v_cursorid, 15, l_transaction_rec.Internal_Control_Number);
379: DBMS_SQL.Define_Column(v_cursorid, 16, l_transaction_rec.Attribute_Category, 150);

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

372: DBMS_SQL.Define_Column(v_cursorid, 9, l_transaction_rec.Action_Type, 30);
373: DBMS_SQL.Define_Column(v_cursorid, 10, l_transaction_rec.Transaction_Status, 2);
374: DBMS_SQL.Define_Column_Raw(v_cursorid, 11, l_transaction_rec.ecx_message_id, 16);
375: DBMS_SQL.Define_Column(v_cursorid, 12, l_transaction_rec.Event_Name, 240);
376: DBMS_SQL.Define_Column(v_cursorid, 13, l_transaction_rec.Event_Key, 240);
377: DBMS_SQL.Define_Column(v_cursorid, 14, l_transaction_rec.Item_Type, 8);
378: DBMS_SQL.Define_Column(v_cursorid, 15, l_transaction_rec.Internal_Control_Number);
379: DBMS_SQL.Define_Column(v_cursorid, 16, l_transaction_rec.Attribute_Category, 150);
380: DBMS_SQL.Define_Column(v_cursorid, 17, l_transaction_rec.Attribute1, 150);

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

373: DBMS_SQL.Define_Column(v_cursorid, 10, l_transaction_rec.Transaction_Status, 2);
374: DBMS_SQL.Define_Column_Raw(v_cursorid, 11, l_transaction_rec.ecx_message_id, 16);
375: DBMS_SQL.Define_Column(v_cursorid, 12, l_transaction_rec.Event_Name, 240);
376: DBMS_SQL.Define_Column(v_cursorid, 13, l_transaction_rec.Event_Key, 240);
377: DBMS_SQL.Define_Column(v_cursorid, 14, l_transaction_rec.Item_Type, 8);
378: DBMS_SQL.Define_Column(v_cursorid, 15, l_transaction_rec.Internal_Control_Number);
379: DBMS_SQL.Define_Column(v_cursorid, 16, l_transaction_rec.Attribute_Category, 150);
380: DBMS_SQL.Define_Column(v_cursorid, 17, l_transaction_rec.Attribute1, 150);
381: DBMS_SQL.Define_Column(v_cursorid, 18, l_transaction_rec.Attribute2, 150);

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

374: DBMS_SQL.Define_Column_Raw(v_cursorid, 11, l_transaction_rec.ecx_message_id, 16);
375: DBMS_SQL.Define_Column(v_cursorid, 12, l_transaction_rec.Event_Name, 240);
376: DBMS_SQL.Define_Column(v_cursorid, 13, l_transaction_rec.Event_Key, 240);
377: DBMS_SQL.Define_Column(v_cursorid, 14, l_transaction_rec.Item_Type, 8);
378: DBMS_SQL.Define_Column(v_cursorid, 15, l_transaction_rec.Internal_Control_Number);
379: DBMS_SQL.Define_Column(v_cursorid, 16, l_transaction_rec.Attribute_Category, 150);
380: DBMS_SQL.Define_Column(v_cursorid, 17, l_transaction_rec.Attribute1, 150);
381: DBMS_SQL.Define_Column(v_cursorid, 18, l_transaction_rec.Attribute2, 150);
382: DBMS_SQL.Define_Column(v_cursorid, 19, l_transaction_rec.Attribute3, 150);

Line 379: DBMS_SQL.Define_Column(v_cursorid, 16, l_transaction_rec.Attribute_Category, 150);

375: DBMS_SQL.Define_Column(v_cursorid, 12, l_transaction_rec.Event_Name, 240);
376: DBMS_SQL.Define_Column(v_cursorid, 13, l_transaction_rec.Event_Key, 240);
377: DBMS_SQL.Define_Column(v_cursorid, 14, l_transaction_rec.Item_Type, 8);
378: DBMS_SQL.Define_Column(v_cursorid, 15, l_transaction_rec.Internal_Control_Number);
379: DBMS_SQL.Define_Column(v_cursorid, 16, l_transaction_rec.Attribute_Category, 150);
380: DBMS_SQL.Define_Column(v_cursorid, 17, l_transaction_rec.Attribute1, 150);
381: DBMS_SQL.Define_Column(v_cursorid, 18, l_transaction_rec.Attribute2, 150);
382: DBMS_SQL.Define_Column(v_cursorid, 19, l_transaction_rec.Attribute3, 150);
383: DBMS_SQL.Define_Column(v_cursorid, 20, l_transaction_rec.Attribute4, 150);

Line 380: DBMS_SQL.Define_Column(v_cursorid, 17, l_transaction_rec.Attribute1, 150);

376: DBMS_SQL.Define_Column(v_cursorid, 13, l_transaction_rec.Event_Key, 240);
377: DBMS_SQL.Define_Column(v_cursorid, 14, l_transaction_rec.Item_Type, 8);
378: DBMS_SQL.Define_Column(v_cursorid, 15, l_transaction_rec.Internal_Control_Number);
379: DBMS_SQL.Define_Column(v_cursorid, 16, l_transaction_rec.Attribute_Category, 150);
380: DBMS_SQL.Define_Column(v_cursorid, 17, l_transaction_rec.Attribute1, 150);
381: DBMS_SQL.Define_Column(v_cursorid, 18, l_transaction_rec.Attribute2, 150);
382: DBMS_SQL.Define_Column(v_cursorid, 19, l_transaction_rec.Attribute3, 150);
383: DBMS_SQL.Define_Column(v_cursorid, 20, l_transaction_rec.Attribute4, 150);
384: DBMS_SQL.Define_Column(v_cursorid, 21, l_transaction_rec.Attribute5, 150);

Line 381: DBMS_SQL.Define_Column(v_cursorid, 18, l_transaction_rec.Attribute2, 150);

377: DBMS_SQL.Define_Column(v_cursorid, 14, l_transaction_rec.Item_Type, 8);
378: DBMS_SQL.Define_Column(v_cursorid, 15, l_transaction_rec.Internal_Control_Number);
379: DBMS_SQL.Define_Column(v_cursorid, 16, l_transaction_rec.Attribute_Category, 150);
380: DBMS_SQL.Define_Column(v_cursorid, 17, l_transaction_rec.Attribute1, 150);
381: DBMS_SQL.Define_Column(v_cursorid, 18, l_transaction_rec.Attribute2, 150);
382: DBMS_SQL.Define_Column(v_cursorid, 19, l_transaction_rec.Attribute3, 150);
383: DBMS_SQL.Define_Column(v_cursorid, 20, l_transaction_rec.Attribute4, 150);
384: DBMS_SQL.Define_Column(v_cursorid, 21, l_transaction_rec.Attribute5, 150);
385: DBMS_SQL.Define_Column(v_cursorid, 22, l_transaction_rec.Attribute6, 150);

Line 382: DBMS_SQL.Define_Column(v_cursorid, 19, l_transaction_rec.Attribute3, 150);

378: DBMS_SQL.Define_Column(v_cursorid, 15, l_transaction_rec.Internal_Control_Number);
379: DBMS_SQL.Define_Column(v_cursorid, 16, l_transaction_rec.Attribute_Category, 150);
380: DBMS_SQL.Define_Column(v_cursorid, 17, l_transaction_rec.Attribute1, 150);
381: DBMS_SQL.Define_Column(v_cursorid, 18, l_transaction_rec.Attribute2, 150);
382: DBMS_SQL.Define_Column(v_cursorid, 19, l_transaction_rec.Attribute3, 150);
383: DBMS_SQL.Define_Column(v_cursorid, 20, l_transaction_rec.Attribute4, 150);
384: DBMS_SQL.Define_Column(v_cursorid, 21, l_transaction_rec.Attribute5, 150);
385: DBMS_SQL.Define_Column(v_cursorid, 22, l_transaction_rec.Attribute6, 150);
386: DBMS_SQL.Define_Column(v_cursorid, 23, l_transaction_rec.Attribute7, 150);

Line 383: DBMS_SQL.Define_Column(v_cursorid, 20, l_transaction_rec.Attribute4, 150);

379: DBMS_SQL.Define_Column(v_cursorid, 16, l_transaction_rec.Attribute_Category, 150);
380: DBMS_SQL.Define_Column(v_cursorid, 17, l_transaction_rec.Attribute1, 150);
381: DBMS_SQL.Define_Column(v_cursorid, 18, l_transaction_rec.Attribute2, 150);
382: DBMS_SQL.Define_Column(v_cursorid, 19, l_transaction_rec.Attribute3, 150);
383: DBMS_SQL.Define_Column(v_cursorid, 20, l_transaction_rec.Attribute4, 150);
384: DBMS_SQL.Define_Column(v_cursorid, 21, l_transaction_rec.Attribute5, 150);
385: DBMS_SQL.Define_Column(v_cursorid, 22, l_transaction_rec.Attribute6, 150);
386: DBMS_SQL.Define_Column(v_cursorid, 23, l_transaction_rec.Attribute7, 150);
387: DBMS_SQL.Define_Column(v_cursorid, 24, l_transaction_rec.Attribute8, 150);

Line 384: DBMS_SQL.Define_Column(v_cursorid, 21, l_transaction_rec.Attribute5, 150);

380: DBMS_SQL.Define_Column(v_cursorid, 17, l_transaction_rec.Attribute1, 150);
381: DBMS_SQL.Define_Column(v_cursorid, 18, l_transaction_rec.Attribute2, 150);
382: DBMS_SQL.Define_Column(v_cursorid, 19, l_transaction_rec.Attribute3, 150);
383: DBMS_SQL.Define_Column(v_cursorid, 20, l_transaction_rec.Attribute4, 150);
384: DBMS_SQL.Define_Column(v_cursorid, 21, l_transaction_rec.Attribute5, 150);
385: DBMS_SQL.Define_Column(v_cursorid, 22, l_transaction_rec.Attribute6, 150);
386: DBMS_SQL.Define_Column(v_cursorid, 23, l_transaction_rec.Attribute7, 150);
387: DBMS_SQL.Define_Column(v_cursorid, 24, l_transaction_rec.Attribute8, 150);
388: DBMS_SQL.Define_Column(v_cursorid, 25, l_transaction_rec.Attribute9, 150);

Line 385: DBMS_SQL.Define_Column(v_cursorid, 22, l_transaction_rec.Attribute6, 150);

381: DBMS_SQL.Define_Column(v_cursorid, 18, l_transaction_rec.Attribute2, 150);
382: DBMS_SQL.Define_Column(v_cursorid, 19, l_transaction_rec.Attribute3, 150);
383: DBMS_SQL.Define_Column(v_cursorid, 20, l_transaction_rec.Attribute4, 150);
384: DBMS_SQL.Define_Column(v_cursorid, 21, l_transaction_rec.Attribute5, 150);
385: DBMS_SQL.Define_Column(v_cursorid, 22, l_transaction_rec.Attribute6, 150);
386: DBMS_SQL.Define_Column(v_cursorid, 23, l_transaction_rec.Attribute7, 150);
387: DBMS_SQL.Define_Column(v_cursorid, 24, l_transaction_rec.Attribute8, 150);
388: DBMS_SQL.Define_Column(v_cursorid, 25, l_transaction_rec.Attribute9, 150);
389: DBMS_SQL.Define_Column(v_cursorid, 26, l_transaction_rec.Attribute10, 150);

Line 386: DBMS_SQL.Define_Column(v_cursorid, 23, l_transaction_rec.Attribute7, 150);

382: DBMS_SQL.Define_Column(v_cursorid, 19, l_transaction_rec.Attribute3, 150);
383: DBMS_SQL.Define_Column(v_cursorid, 20, l_transaction_rec.Attribute4, 150);
384: DBMS_SQL.Define_Column(v_cursorid, 21, l_transaction_rec.Attribute5, 150);
385: DBMS_SQL.Define_Column(v_cursorid, 22, l_transaction_rec.Attribute6, 150);
386: DBMS_SQL.Define_Column(v_cursorid, 23, l_transaction_rec.Attribute7, 150);
387: DBMS_SQL.Define_Column(v_cursorid, 24, l_transaction_rec.Attribute8, 150);
388: DBMS_SQL.Define_Column(v_cursorid, 25, l_transaction_rec.Attribute9, 150);
389: DBMS_SQL.Define_Column(v_cursorid, 26, l_transaction_rec.Attribute10, 150);
390: DBMS_SQL.Define_Column(v_cursorid, 27, l_transaction_rec.Attribute11, 150);

Line 387: DBMS_SQL.Define_Column(v_cursorid, 24, l_transaction_rec.Attribute8, 150);

383: DBMS_SQL.Define_Column(v_cursorid, 20, l_transaction_rec.Attribute4, 150);
384: DBMS_SQL.Define_Column(v_cursorid, 21, l_transaction_rec.Attribute5, 150);
385: DBMS_SQL.Define_Column(v_cursorid, 22, l_transaction_rec.Attribute6, 150);
386: DBMS_SQL.Define_Column(v_cursorid, 23, l_transaction_rec.Attribute7, 150);
387: DBMS_SQL.Define_Column(v_cursorid, 24, l_transaction_rec.Attribute8, 150);
388: DBMS_SQL.Define_Column(v_cursorid, 25, l_transaction_rec.Attribute9, 150);
389: DBMS_SQL.Define_Column(v_cursorid, 26, l_transaction_rec.Attribute10, 150);
390: DBMS_SQL.Define_Column(v_cursorid, 27, l_transaction_rec.Attribute11, 150);
391: DBMS_SQL.Define_Column(v_cursorid, 28, l_transaction_rec.Attribute12, 150);

Line 388: DBMS_SQL.Define_Column(v_cursorid, 25, l_transaction_rec.Attribute9, 150);

384: DBMS_SQL.Define_Column(v_cursorid, 21, l_transaction_rec.Attribute5, 150);
385: DBMS_SQL.Define_Column(v_cursorid, 22, l_transaction_rec.Attribute6, 150);
386: DBMS_SQL.Define_Column(v_cursorid, 23, l_transaction_rec.Attribute7, 150);
387: DBMS_SQL.Define_Column(v_cursorid, 24, l_transaction_rec.Attribute8, 150);
388: DBMS_SQL.Define_Column(v_cursorid, 25, l_transaction_rec.Attribute9, 150);
389: DBMS_SQL.Define_Column(v_cursorid, 26, l_transaction_rec.Attribute10, 150);
390: DBMS_SQL.Define_Column(v_cursorid, 27, l_transaction_rec.Attribute11, 150);
391: DBMS_SQL.Define_Column(v_cursorid, 28, l_transaction_rec.Attribute12, 150);
392: DBMS_SQL.Define_Column(v_cursorid, 29, l_transaction_rec.Attribute13, 150);

Line 389: DBMS_SQL.Define_Column(v_cursorid, 26, l_transaction_rec.Attribute10, 150);

385: DBMS_SQL.Define_Column(v_cursorid, 22, l_transaction_rec.Attribute6, 150);
386: DBMS_SQL.Define_Column(v_cursorid, 23, l_transaction_rec.Attribute7, 150);
387: DBMS_SQL.Define_Column(v_cursorid, 24, l_transaction_rec.Attribute8, 150);
388: DBMS_SQL.Define_Column(v_cursorid, 25, l_transaction_rec.Attribute9, 150);
389: DBMS_SQL.Define_Column(v_cursorid, 26, l_transaction_rec.Attribute10, 150);
390: DBMS_SQL.Define_Column(v_cursorid, 27, l_transaction_rec.Attribute11, 150);
391: DBMS_SQL.Define_Column(v_cursorid, 28, l_transaction_rec.Attribute12, 150);
392: DBMS_SQL.Define_Column(v_cursorid, 29, l_transaction_rec.Attribute13, 150);
393: DBMS_SQL.Define_Column(v_cursorid, 30, l_transaction_rec.Attribute14, 150);

Line 390: DBMS_SQL.Define_Column(v_cursorid, 27, l_transaction_rec.Attribute11, 150);

386: DBMS_SQL.Define_Column(v_cursorid, 23, l_transaction_rec.Attribute7, 150);
387: DBMS_SQL.Define_Column(v_cursorid, 24, l_transaction_rec.Attribute8, 150);
388: DBMS_SQL.Define_Column(v_cursorid, 25, l_transaction_rec.Attribute9, 150);
389: DBMS_SQL.Define_Column(v_cursorid, 26, l_transaction_rec.Attribute10, 150);
390: DBMS_SQL.Define_Column(v_cursorid, 27, l_transaction_rec.Attribute11, 150);
391: DBMS_SQL.Define_Column(v_cursorid, 28, l_transaction_rec.Attribute12, 150);
392: DBMS_SQL.Define_Column(v_cursorid, 29, l_transaction_rec.Attribute13, 150);
393: DBMS_SQL.Define_Column(v_cursorid, 30, l_transaction_rec.Attribute14, 150);
394: DBMS_SQL.Define_Column(v_cursorid, 31, l_transaction_rec.Attribute15, 150);

Line 391: DBMS_SQL.Define_Column(v_cursorid, 28, l_transaction_rec.Attribute12, 150);

387: DBMS_SQL.Define_Column(v_cursorid, 24, l_transaction_rec.Attribute8, 150);
388: DBMS_SQL.Define_Column(v_cursorid, 25, l_transaction_rec.Attribute9, 150);
389: DBMS_SQL.Define_Column(v_cursorid, 26, l_transaction_rec.Attribute10, 150);
390: DBMS_SQL.Define_Column(v_cursorid, 27, l_transaction_rec.Attribute11, 150);
391: DBMS_SQL.Define_Column(v_cursorid, 28, l_transaction_rec.Attribute12, 150);
392: DBMS_SQL.Define_Column(v_cursorid, 29, l_transaction_rec.Attribute13, 150);
393: DBMS_SQL.Define_Column(v_cursorid, 30, l_transaction_rec.Attribute14, 150);
394: DBMS_SQL.Define_Column(v_cursorid, 31, l_transaction_rec.Attribute15, 150);
395: --

Line 392: DBMS_SQL.Define_Column(v_cursorid, 29, l_transaction_rec.Attribute13, 150);

388: DBMS_SQL.Define_Column(v_cursorid, 25, l_transaction_rec.Attribute9, 150);
389: DBMS_SQL.Define_Column(v_cursorid, 26, l_transaction_rec.Attribute10, 150);
390: DBMS_SQL.Define_Column(v_cursorid, 27, l_transaction_rec.Attribute11, 150);
391: DBMS_SQL.Define_Column(v_cursorid, 28, l_transaction_rec.Attribute12, 150);
392: DBMS_SQL.Define_Column(v_cursorid, 29, l_transaction_rec.Attribute13, 150);
393: DBMS_SQL.Define_Column(v_cursorid, 30, l_transaction_rec.Attribute14, 150);
394: DBMS_SQL.Define_Column(v_cursorid, 31, l_transaction_rec.Attribute15, 150);
395: --
396: IF l_debug_on THEN

Line 393: DBMS_SQL.Define_Column(v_cursorid, 30, l_transaction_rec.Attribute14, 150);

389: DBMS_SQL.Define_Column(v_cursorid, 26, l_transaction_rec.Attribute10, 150);
390: DBMS_SQL.Define_Column(v_cursorid, 27, l_transaction_rec.Attribute11, 150);
391: DBMS_SQL.Define_Column(v_cursorid, 28, l_transaction_rec.Attribute12, 150);
392: DBMS_SQL.Define_Column(v_cursorid, 29, l_transaction_rec.Attribute13, 150);
393: DBMS_SQL.Define_Column(v_cursorid, 30, l_transaction_rec.Attribute14, 150);
394: DBMS_SQL.Define_Column(v_cursorid, 31, l_transaction_rec.Attribute15, 150);
395: --
396: IF l_debug_on THEN
397: WSH_DEBUG_SV.logmsg(l_module_name, 'Defined Columns successfully');

Line 394: DBMS_SQL.Define_Column(v_cursorid, 31, l_transaction_rec.Attribute15, 150);

390: DBMS_SQL.Define_Column(v_cursorid, 27, l_transaction_rec.Attribute11, 150);
391: DBMS_SQL.Define_Column(v_cursorid, 28, l_transaction_rec.Attribute12, 150);
392: DBMS_SQL.Define_Column(v_cursorid, 29, l_transaction_rec.Attribute13, 150);
393: DBMS_SQL.Define_Column(v_cursorid, 30, l_transaction_rec.Attribute14, 150);
394: DBMS_SQL.Define_Column(v_cursorid, 31, l_transaction_rec.Attribute15, 150);
395: --
396: IF l_debug_on THEN
397: WSH_DEBUG_SV.logmsg(l_module_name, 'Defined Columns successfully');
398: END IF;

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

400:
401: --Start assigning BIND values
402: IF p_from_document_number is not null and p_to_document_number is not null
403: THEN
404: DBMS_SQL.BIND_VARIABLE(v_cursorid,':x_from_document_number', p_from_document_number);
405: DBMS_SQL.BIND_VARIABLE(v_cursorid,':x_to_document_number', p_to_document_number);
406: ELSIF p_from_document_number is not null and p_to_document_number is null
407: THEN
408: DBMS_SQL.BIND_VARIABLE(v_cursorid,':x_from_document_number', p_from_document_number);

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

401: --Start assigning BIND values
402: IF p_from_document_number is not null and p_to_document_number is not null
403: THEN
404: DBMS_SQL.BIND_VARIABLE(v_cursorid,':x_from_document_number', p_from_document_number);
405: DBMS_SQL.BIND_VARIABLE(v_cursorid,':x_to_document_number', p_to_document_number);
406: ELSIF p_from_document_number is not null and p_to_document_number is null
407: THEN
408: DBMS_SQL.BIND_VARIABLE(v_cursorid,':x_from_document_number', p_from_document_number);
409: ELSIF p_from_document_number is null and p_to_document_number is not null

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

404: DBMS_SQL.BIND_VARIABLE(v_cursorid,':x_from_document_number', p_from_document_number);
405: DBMS_SQL.BIND_VARIABLE(v_cursorid,':x_to_document_number', p_to_document_number);
406: ELSIF p_from_document_number is not null and p_to_document_number is null
407: THEN
408: DBMS_SQL.BIND_VARIABLE(v_cursorid,':x_from_document_number', p_from_document_number);
409: ELSIF p_from_document_number is null and p_to_document_number is not null
410: THEN
411: DBMS_SQL.BIND_VARIABLE(v_cursorid,':x_to_document_number', p_to_document_number);
412: END IF;

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

407: THEN
408: DBMS_SQL.BIND_VARIABLE(v_cursorid,':x_from_document_number', p_from_document_number);
409: ELSIF p_from_document_number is null and p_to_document_number is not null
410: THEN
411: DBMS_SQL.BIND_VARIABLE(v_cursorid,':x_to_document_number', p_to_document_number);
412: END IF;
413:
414: IF p_transaction_status is not null
415: THEN

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

412: END IF;
413:
414: IF p_transaction_status is not null
415: THEN
416: DBMS_SQL.BIND_VARIABLE(v_cursorid,':x_transaction_status', p_transaction_status);
417: END IF;
418:
419: IF l_from_creation_date is not null and l_to_creation_date is not null
420: THEN

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

417: END IF;
418:
419: IF l_from_creation_date is not null and l_to_creation_date is not null
420: THEN
421: DBMS_SQL.BIND_VARIABLE(v_cursorid,':x_from_creation_date', l_from_creation_date);
422: DBMS_SQL.BIND_VARIABLE(v_cursorid,':x_to_creation_date', l_to_creation_date);
423: ELSIF l_from_creation_date is not null and l_to_creation_date is null
424: THEN
425: DBMS_SQL.BIND_VARIABLE(v_cursorid,':x_from_creation_date', l_from_creation_date);

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

418:
419: IF l_from_creation_date is not null and l_to_creation_date is not null
420: THEN
421: DBMS_SQL.BIND_VARIABLE(v_cursorid,':x_from_creation_date', l_from_creation_date);
422: DBMS_SQL.BIND_VARIABLE(v_cursorid,':x_to_creation_date', l_to_creation_date);
423: ELSIF l_from_creation_date is not null and l_to_creation_date is null
424: THEN
425: DBMS_SQL.BIND_VARIABLE(v_cursorid,':x_from_creation_date', l_from_creation_date);
426: ELSIF l_from_creation_date is null and l_to_creation_date is not null

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

421: DBMS_SQL.BIND_VARIABLE(v_cursorid,':x_from_creation_date', l_from_creation_date);
422: DBMS_SQL.BIND_VARIABLE(v_cursorid,':x_to_creation_date', l_to_creation_date);
423: ELSIF l_from_creation_date is not null and l_to_creation_date is null
424: THEN
425: DBMS_SQL.BIND_VARIABLE(v_cursorid,':x_from_creation_date', l_from_creation_date);
426: ELSIF l_from_creation_date is null and l_to_creation_date is not null
427: THEN
428: DBMS_SQL.BIND_VARIABLE(v_cursorid,':x_to_creation_date', l_to_creation_date);
429: END IF;

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

424: THEN
425: DBMS_SQL.BIND_VARIABLE(v_cursorid,':x_from_creation_date', l_from_creation_date);
426: ELSIF l_from_creation_date is null and l_to_creation_date is not null
427: THEN
428: DBMS_SQL.BIND_VARIABLE(v_cursorid,':x_to_creation_date', l_to_creation_date);
429: END IF;
430: --End assigning BIND values
431: --
432: IF l_debug_on THEN

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

433: WSH_DEBUG_SV.logmsg(l_module_name, 'Bind values successfully');
434: END IF;
435: --
436:
437: v_ignore := DBMS_SQL.Execute(v_cursorid);
438: --
439: IF l_debug_on THEN
440: WSH_DEBUG_SV.log(l_module_name, 'Cursor executed successfully', v_ignore);
441: END IF;

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

446: IF p_transaction_id is not null THEN
447: FETCH C_Get_One_Transactions INTO l_transaction_rec;
448: EXIT WHEN C_Get_One_Transactions%NOTFOUND;
449: ELSE
450: v_ignore := DBMS_SQL.Fetch_Rows(v_cursorid);
451: --
452: IF l_debug_on THEN
453: WSH_DEBUG_SV.log(l_module_name, 'Fetched successfully', v_ignore);
454: END IF;

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

456: IF v_ignore = 0 THEN
457: EXIT;
458: END IF;
459:
460: DBMS_SQL.Column_Value(v_cursorid, 1, l_transaction_rec.Transaction_ID);
461: DBMS_SQL.Column_Value(v_cursorid, 2, l_transaction_rec.Document_Type);
462: DBMS_SQL.Column_Value(v_cursorid, 3, l_transaction_rec.Document_Direction);
463: DBMS_SQL.Column_Value(v_cursorid, 4, l_transaction_rec.Document_Number);
464: DBMS_SQL.Column_Value(v_cursorid, 5, l_transaction_rec.Orig_Document_Number);

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

457: EXIT;
458: END IF;
459:
460: DBMS_SQL.Column_Value(v_cursorid, 1, l_transaction_rec.Transaction_ID);
461: DBMS_SQL.Column_Value(v_cursorid, 2, l_transaction_rec.Document_Type);
462: DBMS_SQL.Column_Value(v_cursorid, 3, l_transaction_rec.Document_Direction);
463: DBMS_SQL.Column_Value(v_cursorid, 4, l_transaction_rec.Document_Number);
464: DBMS_SQL.Column_Value(v_cursorid, 5, l_transaction_rec.Orig_Document_Number);
465: DBMS_SQL.Column_Value(v_cursorid, 6, l_transaction_rec.Entity_Number);

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

458: END IF;
459:
460: DBMS_SQL.Column_Value(v_cursorid, 1, l_transaction_rec.Transaction_ID);
461: DBMS_SQL.Column_Value(v_cursorid, 2, l_transaction_rec.Document_Type);
462: DBMS_SQL.Column_Value(v_cursorid, 3, l_transaction_rec.Document_Direction);
463: DBMS_SQL.Column_Value(v_cursorid, 4, l_transaction_rec.Document_Number);
464: DBMS_SQL.Column_Value(v_cursorid, 5, l_transaction_rec.Orig_Document_Number);
465: DBMS_SQL.Column_Value(v_cursorid, 6, l_transaction_rec.Entity_Number);
466: DBMS_SQL.Column_Value(v_cursorid, 7, l_transaction_rec.Entity_Type);

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

459:
460: DBMS_SQL.Column_Value(v_cursorid, 1, l_transaction_rec.Transaction_ID);
461: DBMS_SQL.Column_Value(v_cursorid, 2, l_transaction_rec.Document_Type);
462: DBMS_SQL.Column_Value(v_cursorid, 3, l_transaction_rec.Document_Direction);
463: DBMS_SQL.Column_Value(v_cursorid, 4, l_transaction_rec.Document_Number);
464: DBMS_SQL.Column_Value(v_cursorid, 5, l_transaction_rec.Orig_Document_Number);
465: DBMS_SQL.Column_Value(v_cursorid, 6, l_transaction_rec.Entity_Number);
466: DBMS_SQL.Column_Value(v_cursorid, 7, l_transaction_rec.Entity_Type);
467: DBMS_SQL.Column_Value(v_cursorid, 8, l_transaction_rec.Trading_Partner_ID);

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

460: DBMS_SQL.Column_Value(v_cursorid, 1, l_transaction_rec.Transaction_ID);
461: DBMS_SQL.Column_Value(v_cursorid, 2, l_transaction_rec.Document_Type);
462: DBMS_SQL.Column_Value(v_cursorid, 3, l_transaction_rec.Document_Direction);
463: DBMS_SQL.Column_Value(v_cursorid, 4, l_transaction_rec.Document_Number);
464: DBMS_SQL.Column_Value(v_cursorid, 5, l_transaction_rec.Orig_Document_Number);
465: DBMS_SQL.Column_Value(v_cursorid, 6, l_transaction_rec.Entity_Number);
466: DBMS_SQL.Column_Value(v_cursorid, 7, l_transaction_rec.Entity_Type);
467: DBMS_SQL.Column_Value(v_cursorid, 8, l_transaction_rec.Trading_Partner_ID);
468: DBMS_SQL.Column_Value(v_cursorid, 9, l_transaction_rec.Action_Type);

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

461: DBMS_SQL.Column_Value(v_cursorid, 2, l_transaction_rec.Document_Type);
462: DBMS_SQL.Column_Value(v_cursorid, 3, l_transaction_rec.Document_Direction);
463: DBMS_SQL.Column_Value(v_cursorid, 4, l_transaction_rec.Document_Number);
464: DBMS_SQL.Column_Value(v_cursorid, 5, l_transaction_rec.Orig_Document_Number);
465: DBMS_SQL.Column_Value(v_cursorid, 6, l_transaction_rec.Entity_Number);
466: DBMS_SQL.Column_Value(v_cursorid, 7, l_transaction_rec.Entity_Type);
467: DBMS_SQL.Column_Value(v_cursorid, 8, l_transaction_rec.Trading_Partner_ID);
468: DBMS_SQL.Column_Value(v_cursorid, 9, l_transaction_rec.Action_Type);
469: DBMS_SQL.Column_Value(v_cursorid, 10, l_transaction_rec.Transaction_Status);

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

462: DBMS_SQL.Column_Value(v_cursorid, 3, l_transaction_rec.Document_Direction);
463: DBMS_SQL.Column_Value(v_cursorid, 4, l_transaction_rec.Document_Number);
464: DBMS_SQL.Column_Value(v_cursorid, 5, l_transaction_rec.Orig_Document_Number);
465: DBMS_SQL.Column_Value(v_cursorid, 6, l_transaction_rec.Entity_Number);
466: DBMS_SQL.Column_Value(v_cursorid, 7, l_transaction_rec.Entity_Type);
467: DBMS_SQL.Column_Value(v_cursorid, 8, l_transaction_rec.Trading_Partner_ID);
468: DBMS_SQL.Column_Value(v_cursorid, 9, l_transaction_rec.Action_Type);
469: DBMS_SQL.Column_Value(v_cursorid, 10, l_transaction_rec.Transaction_Status);
470: DBMS_SQL.Column_Value_Raw(v_cursorid, 11, l_transaction_rec.ecx_message_id);

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

463: DBMS_SQL.Column_Value(v_cursorid, 4, l_transaction_rec.Document_Number);
464: DBMS_SQL.Column_Value(v_cursorid, 5, l_transaction_rec.Orig_Document_Number);
465: DBMS_SQL.Column_Value(v_cursorid, 6, l_transaction_rec.Entity_Number);
466: DBMS_SQL.Column_Value(v_cursorid, 7, l_transaction_rec.Entity_Type);
467: DBMS_SQL.Column_Value(v_cursorid, 8, l_transaction_rec.Trading_Partner_ID);
468: DBMS_SQL.Column_Value(v_cursorid, 9, l_transaction_rec.Action_Type);
469: DBMS_SQL.Column_Value(v_cursorid, 10, l_transaction_rec.Transaction_Status);
470: DBMS_SQL.Column_Value_Raw(v_cursorid, 11, l_transaction_rec.ecx_message_id);
471: DBMS_SQL.Column_Value(v_cursorid, 12, l_transaction_rec.Event_Name);

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

464: DBMS_SQL.Column_Value(v_cursorid, 5, l_transaction_rec.Orig_Document_Number);
465: DBMS_SQL.Column_Value(v_cursorid, 6, l_transaction_rec.Entity_Number);
466: DBMS_SQL.Column_Value(v_cursorid, 7, l_transaction_rec.Entity_Type);
467: DBMS_SQL.Column_Value(v_cursorid, 8, l_transaction_rec.Trading_Partner_ID);
468: DBMS_SQL.Column_Value(v_cursorid, 9, l_transaction_rec.Action_Type);
469: DBMS_SQL.Column_Value(v_cursorid, 10, l_transaction_rec.Transaction_Status);
470: DBMS_SQL.Column_Value_Raw(v_cursorid, 11, l_transaction_rec.ecx_message_id);
471: DBMS_SQL.Column_Value(v_cursorid, 12, l_transaction_rec.Event_Name);
472: DBMS_SQL.Column_Value(v_cursorid, 13, l_transaction_rec.Event_Key);

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

465: DBMS_SQL.Column_Value(v_cursorid, 6, l_transaction_rec.Entity_Number);
466: DBMS_SQL.Column_Value(v_cursorid, 7, l_transaction_rec.Entity_Type);
467: DBMS_SQL.Column_Value(v_cursorid, 8, l_transaction_rec.Trading_Partner_ID);
468: DBMS_SQL.Column_Value(v_cursorid, 9, l_transaction_rec.Action_Type);
469: DBMS_SQL.Column_Value(v_cursorid, 10, l_transaction_rec.Transaction_Status);
470: DBMS_SQL.Column_Value_Raw(v_cursorid, 11, l_transaction_rec.ecx_message_id);
471: DBMS_SQL.Column_Value(v_cursorid, 12, l_transaction_rec.Event_Name);
472: DBMS_SQL.Column_Value(v_cursorid, 13, l_transaction_rec.Event_Key);
473: DBMS_SQL.Column_Value(v_cursorid, 14, l_transaction_rec.Item_Type);

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

466: DBMS_SQL.Column_Value(v_cursorid, 7, l_transaction_rec.Entity_Type);
467: DBMS_SQL.Column_Value(v_cursorid, 8, l_transaction_rec.Trading_Partner_ID);
468: DBMS_SQL.Column_Value(v_cursorid, 9, l_transaction_rec.Action_Type);
469: DBMS_SQL.Column_Value(v_cursorid, 10, l_transaction_rec.Transaction_Status);
470: DBMS_SQL.Column_Value_Raw(v_cursorid, 11, l_transaction_rec.ecx_message_id);
471: DBMS_SQL.Column_Value(v_cursorid, 12, l_transaction_rec.Event_Name);
472: DBMS_SQL.Column_Value(v_cursorid, 13, l_transaction_rec.Event_Key);
473: DBMS_SQL.Column_Value(v_cursorid, 14, l_transaction_rec.Item_Type);
474: DBMS_SQL.Column_Value(v_cursorid, 15, l_transaction_rec.Internal_Control_Number);

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

467: DBMS_SQL.Column_Value(v_cursorid, 8, l_transaction_rec.Trading_Partner_ID);
468: DBMS_SQL.Column_Value(v_cursorid, 9, l_transaction_rec.Action_Type);
469: DBMS_SQL.Column_Value(v_cursorid, 10, l_transaction_rec.Transaction_Status);
470: DBMS_SQL.Column_Value_Raw(v_cursorid, 11, l_transaction_rec.ecx_message_id);
471: DBMS_SQL.Column_Value(v_cursorid, 12, l_transaction_rec.Event_Name);
472: DBMS_SQL.Column_Value(v_cursorid, 13, l_transaction_rec.Event_Key);
473: DBMS_SQL.Column_Value(v_cursorid, 14, l_transaction_rec.Item_Type);
474: DBMS_SQL.Column_Value(v_cursorid, 15, l_transaction_rec.Internal_Control_Number);
475: DBMS_SQL.Column_Value(v_cursorid, 16, l_transaction_rec.Attribute_Category);

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

468: DBMS_SQL.Column_Value(v_cursorid, 9, l_transaction_rec.Action_Type);
469: DBMS_SQL.Column_Value(v_cursorid, 10, l_transaction_rec.Transaction_Status);
470: DBMS_SQL.Column_Value_Raw(v_cursorid, 11, l_transaction_rec.ecx_message_id);
471: DBMS_SQL.Column_Value(v_cursorid, 12, l_transaction_rec.Event_Name);
472: DBMS_SQL.Column_Value(v_cursorid, 13, l_transaction_rec.Event_Key);
473: DBMS_SQL.Column_Value(v_cursorid, 14, l_transaction_rec.Item_Type);
474: DBMS_SQL.Column_Value(v_cursorid, 15, l_transaction_rec.Internal_Control_Number);
475: DBMS_SQL.Column_Value(v_cursorid, 16, l_transaction_rec.Attribute_Category);
476: DBMS_SQL.Column_Value(v_cursorid, 17, l_transaction_rec.Attribute1);

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

469: DBMS_SQL.Column_Value(v_cursorid, 10, l_transaction_rec.Transaction_Status);
470: DBMS_SQL.Column_Value_Raw(v_cursorid, 11, l_transaction_rec.ecx_message_id);
471: DBMS_SQL.Column_Value(v_cursorid, 12, l_transaction_rec.Event_Name);
472: DBMS_SQL.Column_Value(v_cursorid, 13, l_transaction_rec.Event_Key);
473: DBMS_SQL.Column_Value(v_cursorid, 14, l_transaction_rec.Item_Type);
474: DBMS_SQL.Column_Value(v_cursorid, 15, l_transaction_rec.Internal_Control_Number);
475: DBMS_SQL.Column_Value(v_cursorid, 16, l_transaction_rec.Attribute_Category);
476: DBMS_SQL.Column_Value(v_cursorid, 17, l_transaction_rec.Attribute1);
477: DBMS_SQL.Column_Value(v_cursorid, 18, l_transaction_rec.Attribute2);

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

470: DBMS_SQL.Column_Value_Raw(v_cursorid, 11, l_transaction_rec.ecx_message_id);
471: DBMS_SQL.Column_Value(v_cursorid, 12, l_transaction_rec.Event_Name);
472: DBMS_SQL.Column_Value(v_cursorid, 13, l_transaction_rec.Event_Key);
473: DBMS_SQL.Column_Value(v_cursorid, 14, l_transaction_rec.Item_Type);
474: DBMS_SQL.Column_Value(v_cursorid, 15, l_transaction_rec.Internal_Control_Number);
475: DBMS_SQL.Column_Value(v_cursorid, 16, l_transaction_rec.Attribute_Category);
476: DBMS_SQL.Column_Value(v_cursorid, 17, l_transaction_rec.Attribute1);
477: DBMS_SQL.Column_Value(v_cursorid, 18, l_transaction_rec.Attribute2);
478: DBMS_SQL.Column_Value(v_cursorid, 19, l_transaction_rec.Attribute3);

Line 475: DBMS_SQL.Column_Value(v_cursorid, 16, l_transaction_rec.Attribute_Category);

471: DBMS_SQL.Column_Value(v_cursorid, 12, l_transaction_rec.Event_Name);
472: DBMS_SQL.Column_Value(v_cursorid, 13, l_transaction_rec.Event_Key);
473: DBMS_SQL.Column_Value(v_cursorid, 14, l_transaction_rec.Item_Type);
474: DBMS_SQL.Column_Value(v_cursorid, 15, l_transaction_rec.Internal_Control_Number);
475: DBMS_SQL.Column_Value(v_cursorid, 16, l_transaction_rec.Attribute_Category);
476: DBMS_SQL.Column_Value(v_cursorid, 17, l_transaction_rec.Attribute1);
477: DBMS_SQL.Column_Value(v_cursorid, 18, l_transaction_rec.Attribute2);
478: DBMS_SQL.Column_Value(v_cursorid, 19, l_transaction_rec.Attribute3);
479: DBMS_SQL.Column_Value(v_cursorid, 20, l_transaction_rec.Attribute4);

Line 476: DBMS_SQL.Column_Value(v_cursorid, 17, l_transaction_rec.Attribute1);

472: DBMS_SQL.Column_Value(v_cursorid, 13, l_transaction_rec.Event_Key);
473: DBMS_SQL.Column_Value(v_cursorid, 14, l_transaction_rec.Item_Type);
474: DBMS_SQL.Column_Value(v_cursorid, 15, l_transaction_rec.Internal_Control_Number);
475: DBMS_SQL.Column_Value(v_cursorid, 16, l_transaction_rec.Attribute_Category);
476: DBMS_SQL.Column_Value(v_cursorid, 17, l_transaction_rec.Attribute1);
477: DBMS_SQL.Column_Value(v_cursorid, 18, l_transaction_rec.Attribute2);
478: DBMS_SQL.Column_Value(v_cursorid, 19, l_transaction_rec.Attribute3);
479: DBMS_SQL.Column_Value(v_cursorid, 20, l_transaction_rec.Attribute4);
480: DBMS_SQL.Column_Value(v_cursorid, 21, l_transaction_rec.Attribute5);

Line 477: DBMS_SQL.Column_Value(v_cursorid, 18, l_transaction_rec.Attribute2);

473: DBMS_SQL.Column_Value(v_cursorid, 14, l_transaction_rec.Item_Type);
474: DBMS_SQL.Column_Value(v_cursorid, 15, l_transaction_rec.Internal_Control_Number);
475: DBMS_SQL.Column_Value(v_cursorid, 16, l_transaction_rec.Attribute_Category);
476: DBMS_SQL.Column_Value(v_cursorid, 17, l_transaction_rec.Attribute1);
477: DBMS_SQL.Column_Value(v_cursorid, 18, l_transaction_rec.Attribute2);
478: DBMS_SQL.Column_Value(v_cursorid, 19, l_transaction_rec.Attribute3);
479: DBMS_SQL.Column_Value(v_cursorid, 20, l_transaction_rec.Attribute4);
480: DBMS_SQL.Column_Value(v_cursorid, 21, l_transaction_rec.Attribute5);
481: DBMS_SQL.Column_Value(v_cursorid, 22, l_transaction_rec.Attribute6);

Line 478: DBMS_SQL.Column_Value(v_cursorid, 19, l_transaction_rec.Attribute3);

474: DBMS_SQL.Column_Value(v_cursorid, 15, l_transaction_rec.Internal_Control_Number);
475: DBMS_SQL.Column_Value(v_cursorid, 16, l_transaction_rec.Attribute_Category);
476: DBMS_SQL.Column_Value(v_cursorid, 17, l_transaction_rec.Attribute1);
477: DBMS_SQL.Column_Value(v_cursorid, 18, l_transaction_rec.Attribute2);
478: DBMS_SQL.Column_Value(v_cursorid, 19, l_transaction_rec.Attribute3);
479: DBMS_SQL.Column_Value(v_cursorid, 20, l_transaction_rec.Attribute4);
480: DBMS_SQL.Column_Value(v_cursorid, 21, l_transaction_rec.Attribute5);
481: DBMS_SQL.Column_Value(v_cursorid, 22, l_transaction_rec.Attribute6);
482: DBMS_SQL.Column_Value(v_cursorid, 23, l_transaction_rec.Attribute7);

Line 479: DBMS_SQL.Column_Value(v_cursorid, 20, l_transaction_rec.Attribute4);

475: DBMS_SQL.Column_Value(v_cursorid, 16, l_transaction_rec.Attribute_Category);
476: DBMS_SQL.Column_Value(v_cursorid, 17, l_transaction_rec.Attribute1);
477: DBMS_SQL.Column_Value(v_cursorid, 18, l_transaction_rec.Attribute2);
478: DBMS_SQL.Column_Value(v_cursorid, 19, l_transaction_rec.Attribute3);
479: DBMS_SQL.Column_Value(v_cursorid, 20, l_transaction_rec.Attribute4);
480: DBMS_SQL.Column_Value(v_cursorid, 21, l_transaction_rec.Attribute5);
481: DBMS_SQL.Column_Value(v_cursorid, 22, l_transaction_rec.Attribute6);
482: DBMS_SQL.Column_Value(v_cursorid, 23, l_transaction_rec.Attribute7);
483: DBMS_SQL.Column_Value(v_cursorid, 24, l_transaction_rec.Attribute8);

Line 480: DBMS_SQL.Column_Value(v_cursorid, 21, l_transaction_rec.Attribute5);

476: DBMS_SQL.Column_Value(v_cursorid, 17, l_transaction_rec.Attribute1);
477: DBMS_SQL.Column_Value(v_cursorid, 18, l_transaction_rec.Attribute2);
478: DBMS_SQL.Column_Value(v_cursorid, 19, l_transaction_rec.Attribute3);
479: DBMS_SQL.Column_Value(v_cursorid, 20, l_transaction_rec.Attribute4);
480: DBMS_SQL.Column_Value(v_cursorid, 21, l_transaction_rec.Attribute5);
481: DBMS_SQL.Column_Value(v_cursorid, 22, l_transaction_rec.Attribute6);
482: DBMS_SQL.Column_Value(v_cursorid, 23, l_transaction_rec.Attribute7);
483: DBMS_SQL.Column_Value(v_cursorid, 24, l_transaction_rec.Attribute8);
484: DBMS_SQL.Column_Value(v_cursorid, 25, l_transaction_rec.Attribute9);

Line 481: DBMS_SQL.Column_Value(v_cursorid, 22, l_transaction_rec.Attribute6);

477: DBMS_SQL.Column_Value(v_cursorid, 18, l_transaction_rec.Attribute2);
478: DBMS_SQL.Column_Value(v_cursorid, 19, l_transaction_rec.Attribute3);
479: DBMS_SQL.Column_Value(v_cursorid, 20, l_transaction_rec.Attribute4);
480: DBMS_SQL.Column_Value(v_cursorid, 21, l_transaction_rec.Attribute5);
481: DBMS_SQL.Column_Value(v_cursorid, 22, l_transaction_rec.Attribute6);
482: DBMS_SQL.Column_Value(v_cursorid, 23, l_transaction_rec.Attribute7);
483: DBMS_SQL.Column_Value(v_cursorid, 24, l_transaction_rec.Attribute8);
484: DBMS_SQL.Column_Value(v_cursorid, 25, l_transaction_rec.Attribute9);
485: DBMS_SQL.Column_Value(v_cursorid, 26, l_transaction_rec.Attribute10);

Line 482: DBMS_SQL.Column_Value(v_cursorid, 23, l_transaction_rec.Attribute7);

478: DBMS_SQL.Column_Value(v_cursorid, 19, l_transaction_rec.Attribute3);
479: DBMS_SQL.Column_Value(v_cursorid, 20, l_transaction_rec.Attribute4);
480: DBMS_SQL.Column_Value(v_cursorid, 21, l_transaction_rec.Attribute5);
481: DBMS_SQL.Column_Value(v_cursorid, 22, l_transaction_rec.Attribute6);
482: DBMS_SQL.Column_Value(v_cursorid, 23, l_transaction_rec.Attribute7);
483: DBMS_SQL.Column_Value(v_cursorid, 24, l_transaction_rec.Attribute8);
484: DBMS_SQL.Column_Value(v_cursorid, 25, l_transaction_rec.Attribute9);
485: DBMS_SQL.Column_Value(v_cursorid, 26, l_transaction_rec.Attribute10);
486: DBMS_SQL.Column_Value(v_cursorid, 27, l_transaction_rec.Attribute11);

Line 483: DBMS_SQL.Column_Value(v_cursorid, 24, l_transaction_rec.Attribute8);

479: DBMS_SQL.Column_Value(v_cursorid, 20, l_transaction_rec.Attribute4);
480: DBMS_SQL.Column_Value(v_cursorid, 21, l_transaction_rec.Attribute5);
481: DBMS_SQL.Column_Value(v_cursorid, 22, l_transaction_rec.Attribute6);
482: DBMS_SQL.Column_Value(v_cursorid, 23, l_transaction_rec.Attribute7);
483: DBMS_SQL.Column_Value(v_cursorid, 24, l_transaction_rec.Attribute8);
484: DBMS_SQL.Column_Value(v_cursorid, 25, l_transaction_rec.Attribute9);
485: DBMS_SQL.Column_Value(v_cursorid, 26, l_transaction_rec.Attribute10);
486: DBMS_SQL.Column_Value(v_cursorid, 27, l_transaction_rec.Attribute11);
487: DBMS_SQL.Column_Value(v_cursorid, 28, l_transaction_rec.Attribute12);

Line 484: DBMS_SQL.Column_Value(v_cursorid, 25, l_transaction_rec.Attribute9);

480: DBMS_SQL.Column_Value(v_cursorid, 21, l_transaction_rec.Attribute5);
481: DBMS_SQL.Column_Value(v_cursorid, 22, l_transaction_rec.Attribute6);
482: DBMS_SQL.Column_Value(v_cursorid, 23, l_transaction_rec.Attribute7);
483: DBMS_SQL.Column_Value(v_cursorid, 24, l_transaction_rec.Attribute8);
484: DBMS_SQL.Column_Value(v_cursorid, 25, l_transaction_rec.Attribute9);
485: DBMS_SQL.Column_Value(v_cursorid, 26, l_transaction_rec.Attribute10);
486: DBMS_SQL.Column_Value(v_cursorid, 27, l_transaction_rec.Attribute11);
487: DBMS_SQL.Column_Value(v_cursorid, 28, l_transaction_rec.Attribute12);
488: DBMS_SQL.Column_Value(v_cursorid, 29, l_transaction_rec.Attribute13);

Line 485: DBMS_SQL.Column_Value(v_cursorid, 26, l_transaction_rec.Attribute10);

481: DBMS_SQL.Column_Value(v_cursorid, 22, l_transaction_rec.Attribute6);
482: DBMS_SQL.Column_Value(v_cursorid, 23, l_transaction_rec.Attribute7);
483: DBMS_SQL.Column_Value(v_cursorid, 24, l_transaction_rec.Attribute8);
484: DBMS_SQL.Column_Value(v_cursorid, 25, l_transaction_rec.Attribute9);
485: DBMS_SQL.Column_Value(v_cursorid, 26, l_transaction_rec.Attribute10);
486: DBMS_SQL.Column_Value(v_cursorid, 27, l_transaction_rec.Attribute11);
487: DBMS_SQL.Column_Value(v_cursorid, 28, l_transaction_rec.Attribute12);
488: DBMS_SQL.Column_Value(v_cursorid, 29, l_transaction_rec.Attribute13);
489: DBMS_SQL.Column_Value(v_cursorid, 30, l_transaction_rec.Attribute14);

Line 486: DBMS_SQL.Column_Value(v_cursorid, 27, l_transaction_rec.Attribute11);

482: DBMS_SQL.Column_Value(v_cursorid, 23, l_transaction_rec.Attribute7);
483: DBMS_SQL.Column_Value(v_cursorid, 24, l_transaction_rec.Attribute8);
484: DBMS_SQL.Column_Value(v_cursorid, 25, l_transaction_rec.Attribute9);
485: DBMS_SQL.Column_Value(v_cursorid, 26, l_transaction_rec.Attribute10);
486: DBMS_SQL.Column_Value(v_cursorid, 27, l_transaction_rec.Attribute11);
487: DBMS_SQL.Column_Value(v_cursorid, 28, l_transaction_rec.Attribute12);
488: DBMS_SQL.Column_Value(v_cursorid, 29, l_transaction_rec.Attribute13);
489: DBMS_SQL.Column_Value(v_cursorid, 30, l_transaction_rec.Attribute14);
490: DBMS_SQL.Column_Value(v_cursorid, 31, l_transaction_rec.Attribute15);

Line 487: DBMS_SQL.Column_Value(v_cursorid, 28, l_transaction_rec.Attribute12);

483: DBMS_SQL.Column_Value(v_cursorid, 24, l_transaction_rec.Attribute8);
484: DBMS_SQL.Column_Value(v_cursorid, 25, l_transaction_rec.Attribute9);
485: DBMS_SQL.Column_Value(v_cursorid, 26, l_transaction_rec.Attribute10);
486: DBMS_SQL.Column_Value(v_cursorid, 27, l_transaction_rec.Attribute11);
487: DBMS_SQL.Column_Value(v_cursorid, 28, l_transaction_rec.Attribute12);
488: DBMS_SQL.Column_Value(v_cursorid, 29, l_transaction_rec.Attribute13);
489: DBMS_SQL.Column_Value(v_cursorid, 30, l_transaction_rec.Attribute14);
490: DBMS_SQL.Column_Value(v_cursorid, 31, l_transaction_rec.Attribute15);
491: --

Line 488: DBMS_SQL.Column_Value(v_cursorid, 29, l_transaction_rec.Attribute13);

484: DBMS_SQL.Column_Value(v_cursorid, 25, l_transaction_rec.Attribute9);
485: DBMS_SQL.Column_Value(v_cursorid, 26, l_transaction_rec.Attribute10);
486: DBMS_SQL.Column_Value(v_cursorid, 27, l_transaction_rec.Attribute11);
487: DBMS_SQL.Column_Value(v_cursorid, 28, l_transaction_rec.Attribute12);
488: DBMS_SQL.Column_Value(v_cursorid, 29, l_transaction_rec.Attribute13);
489: DBMS_SQL.Column_Value(v_cursorid, 30, l_transaction_rec.Attribute14);
490: DBMS_SQL.Column_Value(v_cursorid, 31, l_transaction_rec.Attribute15);
491: --
492: IF l_debug_on THEN

Line 489: DBMS_SQL.Column_Value(v_cursorid, 30, l_transaction_rec.Attribute14);

485: DBMS_SQL.Column_Value(v_cursorid, 26, l_transaction_rec.Attribute10);
486: DBMS_SQL.Column_Value(v_cursorid, 27, l_transaction_rec.Attribute11);
487: DBMS_SQL.Column_Value(v_cursorid, 28, l_transaction_rec.Attribute12);
488: DBMS_SQL.Column_Value(v_cursorid, 29, l_transaction_rec.Attribute13);
489: DBMS_SQL.Column_Value(v_cursorid, 30, l_transaction_rec.Attribute14);
490: DBMS_SQL.Column_Value(v_cursorid, 31, l_transaction_rec.Attribute15);
491: --
492: IF l_debug_on THEN
493: WSH_DEBUG_SV.logmsg(l_module_name, 'Fetched from cursor successfully');

Line 490: DBMS_SQL.Column_Value(v_cursorid, 31, l_transaction_rec.Attribute15);

486: DBMS_SQL.Column_Value(v_cursorid, 27, l_transaction_rec.Attribute11);
487: DBMS_SQL.Column_Value(v_cursorid, 28, l_transaction_rec.Attribute12);
488: DBMS_SQL.Column_Value(v_cursorid, 29, l_transaction_rec.Attribute13);
489: DBMS_SQL.Column_Value(v_cursorid, 30, l_transaction_rec.Attribute14);
490: DBMS_SQL.Column_Value(v_cursorid, 31, l_transaction_rec.Attribute15);
491: --
492: IF l_debug_on THEN
493: WSH_DEBUG_SV.logmsg(l_module_name, 'Fetched from cursor successfully');
494: END IF;

Line 569: IF DBMS_SQL.Is_Open(v_cursorid) THEN

565: IF C_Get_One_Transactions%ISOPEN THEN
566: CLOSE C_Get_One_Transactions;
567: END IF;
568: ELSE
569: IF DBMS_SQL.Is_Open(v_cursorid) THEN
570: --
571: IF l_debug_on THEN
572: WSH_DEBUG_SV.logmsg(l_module_name, 'Closing cursor');
573: END IF;

Line 575: DBMS_SQL.Close_Cursor(v_cursorid);

571: IF l_debug_on THEN
572: WSH_DEBUG_SV.logmsg(l_module_name, 'Closing cursor');
573: END IF;
574: --
575: DBMS_SQL.Close_Cursor(v_cursorid);
576: v_cursorid := null;
577: END IF;
578: END IF;
579:

Line 615: IF DBMS_SQL.Is_Open(v_cursorid) THEN

611: IF C_Get_One_Transactions%ISOPEN THEN
612: CLOSE C_Get_One_Transactions;
613: END IF;
614: ELSE
615: IF DBMS_SQL.Is_Open(v_cursorid) THEN
616: DBMS_SQL.Close_Cursor(v_cursorid);
617: v_cursorid := null;
618: END IF;
619: END IF;

Line 616: DBMS_SQL.Close_Cursor(v_cursorid);

612: CLOSE C_Get_One_Transactions;
613: END IF;
614: ELSE
615: IF DBMS_SQL.Is_Open(v_cursorid) THEN
616: DBMS_SQL.Close_Cursor(v_cursorid);
617: v_cursorid := null;
618: END IF;
619: END IF;
620: --

Line 634: IF DBMS_SQL.Is_Open(v_cursorid) THEN

630: IF C_Get_One_Transactions%ISOPEN THEN
631: CLOSE C_Get_One_Transactions;
632: END IF;
633: ELSE
634: IF DBMS_SQL.Is_Open(v_cursorid) THEN
635: DBMS_SQL.Close_Cursor(v_cursorid);
636: v_cursorid := null;
637: END IF;
638: END IF;

Line 635: DBMS_SQL.Close_Cursor(v_cursorid);

631: CLOSE C_Get_One_Transactions;
632: END IF;
633: ELSE
634: IF DBMS_SQL.Is_Open(v_cursorid) THEN
635: DBMS_SQL.Close_Cursor(v_cursorid);
636: v_cursorid := null;
637: END IF;
638: END IF;
639: --

Line 653: IF DBMS_SQL.Is_Open(v_cursorid) THEN

649: IF C_Get_One_Transactions%ISOPEN THEN
650: CLOSE C_Get_One_Transactions;
651: END IF;
652: ELSE
653: IF DBMS_SQL.Is_Open(v_cursorid) THEN
654: DBMS_SQL.Close_Cursor(v_cursorid);
655: v_cursorid := null;
656: END IF;
657: END IF;

Line 654: DBMS_SQL.Close_Cursor(v_cursorid);

650: CLOSE C_Get_One_Transactions;
651: END IF;
652: ELSE
653: IF DBMS_SQL.Is_Open(v_cursorid) THEN
654: DBMS_SQL.Close_Cursor(v_cursorid);
655: v_cursorid := null;
656: END IF;
657: END IF;
658: --