DBA Data[Home] [Help]

APPS.PO_WF_PO_VARIANCE_ACC SQL Statements

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

Line: 34

     /* DEBUG */  PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey,x_progress);
Line: 91

     /* DEBUG */  PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey,x_progress);
Line: 130

	  select invoice_price_var_account into x_account
	  from mtl_parameters
	  where organization_id     = x_dest_org_id;
Line: 278

    PO_WF_DEBUG_PKG.insert_debug(itemtype, itemkey,
         'PO_WF_PO_VARIANCE_ACC.is_dest_variance_acc_null '||
         'l_dest_variance_account_id='||l_dest_variance_account_id);
Line: 302

    PO_WF_DEBUG_PKG.insert_debug(itemtype, itemkey,
         'PO_WF_PO_VARIANCE_ACC.is_dest_variance_acc_null result= '||
         result);
Line: 309

      PO_WF_DEBUG_PKG.insert_debug(itemtype, itemkey,
         'PO_WF_PO_VARIANCE_ACC.is_dest_variance_acc_null EXCEPTION at '||
         l_progress);
Line: 366

    PO_WF_DEBUG_PKG.insert_debug(itemtype, itemkey,
         'PO_WF_PO_VARIANCE_ACC.get_destination_charge_account '||
         'l_dest_charge_account_id='||l_dest_charge_account_id);
Line: 387

    PO_WF_DEBUG_PKG.insert_debug(itemtype, itemkey,
         'PO_WF_PO_VARIANCE_ACC.get_destination_charge_account '||
         'result='||result);
Line: 394

      PO_WF_DEBUG_PKG.insert_debug(itemtype, itemkey,
         'PO_WF_PO_VARIANCE_ACC.get_destination_charge_account EXCEPTION at '||
         l_progress);
Line: 440

     /* DEBUG */  PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey,x_progress);
Line: 462

       select invoice_price_var_account into x_account
       from mtl_parameters
       where organization_id = x_dest_org_id;
Line: 477

        /* DEBUG */  PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey,x_progress);