APPS.WIP_CFMPROC_PRIV SQL Statements

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

Line: 48

    select completion_transaction_id,
           transaction_source_id,
           kanban_card_id,
           qa_collection_id,
           primary_quantity,
           transaction_header_id,
           nvl(lpn_id, content_lpn_id)
      into l_cplTxnID,
           l_wipEntityID,
           l_kanbanCardID,
           l_qaCollectionID,
           l_primaryQty,
           l_txnHeaderID,
           l_lpnID
      from mtl_material_transactions_temp
     where transaction_temp_id = p_txnTempID;

Line: 108

    wip_flowUtil_priv.updateFlowSchedule(p_txnTempID,
                                         l_returnStatus);

Line: 119

        wip_logger.log(p_msg => 'Calling inv_kanban_pvt.update_card_supply_status',
                       x_returnStatus => l_returnStatus);

Line: 123

      inv_kanban_pvt.update_card_supply_status(
        p_kanban_card_id     => l_kanbanCardID,
        p_supply_status      => inv_kanban_pvt.g_supply_status_full,
        p_document_type      => inv_kanban_pvt.g_doc_type_flow_schedule,
        p_document_header_id => l_wipEntityID,
        p_document_detail_id => null,
        p_replenish_quantity => l_primaryQty,
        x_return_status      => l_returnStatus);

Line: 133

        wip_logger.log(p_msg => 'inv_kanban_pvt.update_card_supply_status returns ' ||
                                'with status ' || l_returnStatus,
                       x_returnStatus => l_returnStatus);

Line: 215

   * This procedure processes a single flow/work orderless transaction inserted
   * by the mobile application.
   */
  procedure processMobile(p_txnHdrID    in  number,
                          p_txnTmpID    in number,
                          p_processInv   in  varchar2,
                          x_returnStatus out nocopy varchar2,
                          x_errorMessage out nocopy varchar2) is
    l_params wip_logger.param_tbl_t;

Line: 294

                                        p_delete_stack => fnd_api.g_false);