APPS.WIP_MTLTEMPPROC_PRIV SQL Statements

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

Line: 26

    select transaction_temp_id
      from mtl_material_transactions_temp
     where transaction_header_id = p_txnHdrID;

Line: 74

                                      p_delete_stack => fnd_api.g_false);

Line: 78

                                      p_delete_stack => fnd_api.g_false);

Line: 102

                                     p_delete_stack => fnd_api.g_false,
                                     p_separator => ' ');

Line: 120

                                     p_delete_stack => fnd_api.g_false,
                                     p_separator => ' ');

Line: 125

      update mtl_material_transactions_temp
         set process_flag = 'E',
             error_code = substr(l_errCode,1,240),
             error_explanation = substr(x_errorMsg,1,240)
       where transaction_header_id = p_txnHdrID
         and process_flag in ('Y', 'W')
         and transaction_source_type_id = 5
         and transaction_action_id in (wip_constants.isscomp_action,
                                       wip_constants.retcomp_action,
                                       wip_constants.issnegc_action,
                                       wip_constants.retnegc_action);

Line: 194

    select transaction_action_id,
           transaction_header_id,   /*Added for bug 6417742(FP of 6342851)*/
           transaction_type_id,     /*Added for bug 6417742(FP of 6342851)*/
           decode(flow_schedule, --treat wol cpls as flow
                  'Y', wip_constants.flow,
                  wip_entity_type),
           nvl(content_lpn_id, lpn_id),
           transaction_source_id,
           organization_id,
           posting_flag,
           flow_schedule,
           operation_seq_num,
           wip_supply_type
      into l_txnActionID,
           l_transaction_header_id,   /*Added for bug 6417742(FP of 6342851)*/
           l_transaction_type_id,     /*Added for bug 6417742(FP of 6342851)*/
           l_wipEntityType,
           l_lpnID,
           l_wipEntityID,
           l_orgID,
           l_postingFlag,
           l_flowSchedule,
           l_opSeq,
           l_supplyType
      from mtl_material_transactions_temp
     where transaction_temp_id = p_txnTmpID
       and transaction_source_type_id = 5;

Line: 225

        delete mtl_material_transactions_temp
        where transaction_temp_id = p_txnTmpID;

Line: 231

                             p_msg              => 'success: phantom record deleted without any action',
                             x_returnStatus     => l_retStatus);

Line: 242

      select entity_type
        into l_wipEntityType
        from wip_entities
       where wip_entity_id = l_wipEntityID
         and organization_id = l_orgID;

Line: 361

                                       p_delete_stack => fnd_api.g_false);

Line: 378

                                      p_delete_stack => fnd_api.g_false);

Line: 433

      select count(*)
        into l_numIntRows
        from mtl_transactions_interface
       where transaction_header_id = p_txnHdrID
         and process_flag = wip_constants.mti_inventory;

Line: 463

    select count(*)
      into l_numErrRows
      from mtl_transactions_interface
     where transaction_header_id = p_txnHdrID;

Line: 468

    select count(*)
      into l_numTempRows
      from mtl_material_transactions_temp
     where transaction_header_id = p_txnHdrID;

Line: 500

      select msik.concatenated_segments,
             mti.error_explanation
        bulk collect into l_itemNameTbl,
                          l_errExplTbl
        from mtl_transactions_interface mti,
             mtl_system_items_kfv msik
       where mti.transaction_header_id = p_txnHdrID
         and mti.error_explanation is not null
         and mti.inventory_item_id = msik.inventory_item_id
         and mti.organization_id = msik.organization_id;

Line: 512

        fnd_message.set_name('WIP', 'WIP_TMPINSERT_ERR');

Line: 543

                                        p_delete_stack => fnd_api.g_false);

Line: 545

        update mtl_transactions_interface
           set last_update_date = sysdate,
               last_update_login = fnd_global.login_id,
               program_application_id = fnd_global.prog_appl_id,
               program_id = fnd_global.conc_program_id,
               program_update_date = sysdate,
               request_id = fnd_global.conc_request_id,
               process_flag = wip_constants.mti_error,
               error_code = substrb(g_pkgName || '.' || l_procName, 1, 240),
               error_explanation = substrb(l_msgData, 1, 240)
         where transaction_header_id = p_txnHdrID;

Line: 582

                                        p_delete_stack => fnd_api.g_false);

Line: 584

        update mtl_transactions_interface
           set last_update_date = sysdate,
               last_update_login = fnd_global.login_id,
               program_application_id = fnd_global.prog_appl_id,
               program_id = fnd_global.conc_program_id,
               program_update_date = sysdate,
               request_id = fnd_global.conc_request_id,
               process_flag = wip_constants.mti_error,
               error_code = substrb(g_pkgName || '.' || l_procName, 1, 240),
               error_explanation = substrb(l_msgData, 1, 240)
         where transaction_header_id = p_txnHdrID;