APPS.GME_DEBUG SQL Statements

The following lines contain the word 'select', 'insert', 'update' or 'delete':

Line: 28

REM *        As part of this bug removed the AND delete_mark = V_delete_mark
REM *        From the cursor for display_inventory_txns_gtmp
REM *        Also added subinventory field in the actual put_line statement
REM *        in the above procedure, as it contains the original trans_id
REM *
REM *
REM *
REM **********************************************************************
*/

   --========================================================================
-- PROCEDURE : Log_Initialize             PUBLIC
-- COMMENT   : Initializes the log facility. It should be called from
--             the top level procedure of each concurrent program
--=======================================================================--
   PROCEDURE log_initialize (
      p_file_name   IN   VARCHAR2 DEFAULT '0'
     ,p_override    IN   NUMBER DEFAULT 0)
   IS
      l_location            VARCHAR2 (500);

Line: 53

         SELECT NVL (SUBSTRB (VALUE, 1, INSTR (VALUE, ',') - 1), VALUE)
           FROM v$parameter
          WHERE NAME = 'utl_file_dir';

Line: 132

         SELECT NVL (SUBSTR (VALUE, 1, INSTR (VALUE, ',') - 1), VALUE)
           FROM v$parameter
          WHERE NAME = 'utl_file_dir';

Line: 190

     ,p_delete_mark             IN   NUMBER DEFAULT 0)
   IS
      l_resource_ids        gme_common_pvt.number_tab;

Line: 199

         SELECT   batchstep_resource_id
             FROM gme_batch_step_resources
            WHERE batchstep_id = v_batchstep_id
         ORDER BY 1;

Line: 207

        ,v_delete_mark   IN   NUMBER)
      IS
         SELECT   *
             FROM gme_resource_txns_gtmp
            WHERE (doc_id = v_doc_id OR v_doc_id IS NULL)
              AND (line_id = v_line_id OR v_line_id IS NULL)
              AND delete_mark = v_delete_mark
         ORDER BY doc_id, line_id, resources, poc_trans_id;

Line: 242

                                   ,p_delete_mark) LOOP
            gme_debug.put_line (rec.organization_id ||'/'
                                || rec.line_id
                                || '/'
                                || rec.poc_trans_id
                                || '/'
                                || TO_CHAR (rec.trans_date
                                           ,'MM/DD/YYYY HH24:MI:SS')
                                || '/'
                                || rec.resources
                                || '/'
                                || rec.resource_usage
                                || '/'
                                || rec.trans_um
                                || '/'
                                || rec.overrided_protected_ind
                                || '/'
                                || rec.completed_ind
                                || '/'
                                || rec.action_code
                                || '/'
                                || rec.reason_id);

Line: 287

         SELECT   *
             FROM gme_exceptions_gtmp
            WHERE organization_id = v_organization_id
              AND (batch_id = v_batch_id OR v_batch_id IS NULL)
              AND (   material_detail_id = v_material_detail_id
                   OR v_material_detail_id IS NULL)
         ORDER BY batch_id, material_detail_id;

Line: 328

 ,p_delete_mark       	        IN NUMBER DEFAULT 0
) IS

	BEGIN
		NULL ;

Line: 348

      FOR get_rec IN (SELECT * FROM mtl_material_transactions_temp WHERE transaction_header_id = gme_common_pvt.g_transaction_header_id) LOOP
        gme_debug.put_line('Batch_id = '||get_rec.transaction_source_id||' material_detail_id = '||get_rec.trx_source_line_id||
                           ' inventory_item_id = '||get_rec.inventory_item_id||' revision = '||get_rec.revision||
                           ' subinventory = '||get_rec.subinventory_code||' locator_id = '||get_rec.locator_id||
                           ' transaction_quantity = '||get_rec.transaction_quantity||' transaction_uom = '||get_rec.transaction_uom||
                           ' sec_transaction_qty  = '||get_rec.secondary_transaction_quantity);

Line: 357

      FOR get_rec IN (SELECT * FROM gme_exceptions_gtmp) LOOP
        gme_debug.put_line('Batch_id = '||get_rec.batch_id||' material_detail_id = '||get_rec.material_detail_id||
                           ' transacted_qty = '||get_rec.transacted_qty||' exception_qty = '||get_rec.exception_qty||
                           ' pending_move_order = '||get_rec.pending_move_order_ind||' pending_rsv_ind = '||get_rec.pending_reservations_ind);