APPS.CSTPSCHK SQL Statements

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

Line: 59

FUNCTION std_cost_update_hook(
  i_org_id              IN      NUMBER,
  i_cost_update_id      IN      NUMBER,
  i_user_id             IN      NUMBER,
  i_login_id            IN      NUMBER,
  i_req_id              IN      NUMBER,
  i_prg_appl_id         IN      NUMBER,
  i_prg_id              IN      NUMBER,
  o_err_num             OUT NOCOPY     NUMBER,
  o_err_code            OUT NOCOPY     VARCHAR2,
  o_err_msg             OUT NOCOPY     VARCHAR2
)
RETURN integer  IS
BEGIN
  o_err_code := '';

Line: 83

    o_err_msg := 'CSTPSCHK.STD_COST_UPDATE_HOOK:' || substrb(SQLERRM,1,150);

Line: 86

END std_cost_update_hook;

Line: 133

  SELECT transaction_type_id,
         transaction_action_id,
         transaction_source_type_id,
         inventory_item_id
  INTO   l_txn_type_id,
         l_txn_act_id,
         l_txn_src_type_id,
         l_item_id
  FROM   MTL_MATERIAL_TRANSACTIONS
  WHERE  transaction_id = I_TXN_ID;

Line: 177

function std_get_update_acct_id(
  I_ORG_ID		IN	NUMBER,
  I_TXN_ID            	IN      NUMBER,
  I_TXN_TYPE_ID	        IN      NUMBER,
  I_TXN_ACT_ID          IN      NUMBER,
  I_TXN_SRC_TYPE_ID     IN      NUMBER,
  I_ITEM_ID	        IN      NUMBER,
  I_UPDATE_ID		IN 	NUMBER,
  I_DEBIT_CREDIT	IN	NUMBER,
  I_ACCT_LINE_TYPE	IN	NUMBER,
  I_COST_ELEMENT_ID	IN	NUMBER,
  I_RESOURCE_ID		IN	NUMBER,
  I_SUBINV		IN	VARCHAR2,
  I_CG_ID		IN	NUMBER,
  I_EXP			IN	NUMBER,
  I_SND_RCV_ORG		IN	NUMBER,
  O_Err_Num		OUT NOCOPY	NUMBER,
  O_Err_Code		OUT NOCOPY	VARCHAR2,
  O_Err_Msg		OUT NOCOPY	VARCHAR2
)
return integer  IS

l_account_num number := -1;

Line: 235

    o_err_msg := 'CSTPSCHK.STD_GET_UPDATE_ACCT_ID:' || substrb(SQLERRM,1,150);

Line: 238

END std_get_update_acct_id;

Line: 264

function std_get_update_scrap_acct_id(
   I_ORG_ID             IN      NUMBER,
   I_UPDATE_ID          IN      NUMBER,
   I_WIP_ENTITY_ID      IN      NUMBER,
   I_DEPT_ID            IN      NUMBER,
   I_OPERATION_SEQ_NUM  IN      NUMBER
)
return integer IS
   l_err_num                    NUMBER := 0;

Line: 287

      SELECT WDJ.std_cost_adjustment_account
      INTO   l_cost_adj_acct
      FROM   wip_discrete_jobs WDJ
      WHERE  WDJ.wip_entity_id          = I_WIP_ENTITY_ID
      AND    WDJ.organization_id        = I_ORG_ID;

Line: 301

END std_get_update_scrap_acct_id;