APPS.WIP_MOVPROC_PUB SQL Statements

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

Line: 15

  SELECT error_column,
         error_message
    FROM wip_txn_interface_errors
   WHERE transaction_id = p_transaction_id;

Line: 37

  SELECT group_id
    INTO l_groupID
    FROM wip_move_txn_interface
   WHERE transaction_id = p_txn_id
     AND process_phase = WIP_CONSTANTS.MOVE_VAL
     AND process_status = WIP_CONSTANTS.RUNNING
     AND group_id IS NOT NULL;

Line: 61

                               p_insertAssy    => fnd_api.g_true,
                               p_do_backflush  => l_do_backflush,
                               x_returnStatus  => x_returnStatus);

Line: 180

                               p_insertAssy    => fnd_api.g_true,
                               p_do_backflush  => l_do_backflush,
                               x_returnStatus  => x_returnStatus);