APPS.CSTPLCIN SQL Statements

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

Line: 82

  SELECT MOD(SUM(DECODE(process_enabled_flag,'Y',1,2)), 2)
    INTO l_pd_txfr_ind
    FROM MTL_PARAMETERS MP
   WHERE MP.ORGANIZATION_ID = i_txn_org_id
      OR MP.ORGANIZATION_ID = i_txfr_org_id;

Line: 90

  SELECT
    transaction_date,
    transaction_source_id,
    source_code,
    encumbrance_amount
  INTO
    l_trx_info.TRANSACTION_DATE,
    l_txn_source_id,
    l_txn_source_code,
    l_encumbrance_amount
  FROM   MTL_MATERIAL_TRANSACTIONS
  WHERE  TRANSACTION_ID = i_txn_id;

Line: 121

    SELECT count(*)
    INTO l_layer_cost_org
    FROM MTL_PARAMETERS
    WHERE ORGANIZATION_ID = i_txn_org_id
    AND PRIMARY_COST_METHOD in (5,6);

Line: 164

        SELECT count(*)
        INTO l_layer_cost_org
        FROM MTL_PARAMETERS
        WHERE ORGANIZATION_ID = i_txfr_org_id
        AND PRIMARY_COST_METHOD in (5,6);

Line: 206

    SELECT count(*)
    INTO l_layer_cost_org
    FROM MTL_PARAMETERS
    WHERE ORGANIZATION_ID = i_txn_org_id
    AND PRIMARY_COST_METHOD in (5,6);

Line: 262

    SELECT count(*)
    INTO l_layer_cost_org
    FROM MTL_PARAMETERS
    WHERE ORGANIZATION_ID = i_txn_org_id
    AND PRIMARY_COST_METHOD in (5,6);

Line: 344

     a layer cost update transaction.  This type of transaction
     has call its own distribution procedure.
  */

  if (i_txn_action_id = 24 ) then /*Removed i_txn_src_type_id = 15 for bug 6030287*/
     CSTPLENG.layer_cost_update_dist(i_org_id,
                    i_txn_id,
                    l_layer_id,
                    i_exp_item,
                    i_user_id,
                    i_login_id,
                    i_request_id,
                    i_prog_appl_id,
                    i_prog_id,
                    l_err_num,
                    l_err_code,
                    l_err_msg);

Line: 394

     update EAM Elemental costs */

     if (i_citw_flag = 1) then
           select entity_type
           into l_entity_type
           from wip_entities
           where wip_entity_id = l_txn_source_id;

Line: 449

      SELECT 'Y'
      INTO   l_std_txfr_flag
      FROM   MTL_PARAMETERS
      WHERE  ORGANIZATION_ID IN ( i_txn_org_id, i_txfr_org_id )
      AND    PRIMARY_COST_METHOD = 1;

Line: 465

    SELECT
      encumbrance_reversal_flag
    INTO
      l_enc_reversal_flag
    FROM
      MTL_PARAMETERS
    WHERE
      organization_id = i_txn_org_id;