APPS.CSTPACLM SQL Statements

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

Line: 21

  select layer_id
  into retval
  from cst_quantity_layers
  where organization_id = i_org_id
  and inventory_item_id = i_item_id
  and cost_group_id     = i_cost_group_id;

Line: 59

  SELECT distinct LAYER_ID
  INTO   retval
  FROM   CST_LAYER_COST_DETAILS
  WHERE  LAYER_ID =
    (SELECT LAYER_ID
     FROM   CST_QUANTITY_LAYERS
     WHERE  ORGANIZATION_ID = i_org_id
     AND    INVENTORY_ITEM_ID = i_item_id
     AND    COST_GROUP_ID = i_cost_group_id);

Line: 120

    select cst_quantity_layers_s.nextval
    into l_layer_id
    from dual;

Line: 125

    insert into cst_quantity_layers (
      layer_id,
      organization_id,
      inventory_item_id,
      cost_group_id,
      layer_quantity,
      last_update_date,
      last_updated_by,
      creation_date,
      created_by,
      request_id,
      program_id,
      program_application_id,
      PL_MATERIAL,
      PL_MATERIAL_OVERHEAD,
      PL_RESOURCE,
      PL_OUTSIDE_PROCESSING,
      PL_OVERHEAD,
      TL_MATERIAL,
      TL_MATERIAL_OVERHEAD,
      TL_RESOURCE,
      TL_OUTSIDE_PROCESSING,
      TL_OVERHEAD,
      MATERIAL_COST,
      MATERIAL_OVERHEAD_COST ,
      RESOURCE_COST,
      OUTSIDE_PROCESSING_COST,
      OVERHEAD_COST,
      PL_ITEM_COST,
      TL_ITEM_COST,
      ITEM_COST,
      UNBURDENED_COST,
      BURDEN_COST,
      CREATE_TRANSACTION_ID
      )
    values (
      l_layer_id,
      i_org_id,
      i_item_id,
      i_cost_group_id,
      0,
      SYSDATE,
      i_user_id,
      SYSDATE,
      i_user_id,
      i_request_id,
      i_prog_id,
      i_prog_appl_id,
      0,
      0,
      0,
      0,
      0,
      0,
      0,
      0,
      0,
      0,
      0,
      0,
      0,
      0,
      0,
      0,
      0,
      0,
      0,
      0,
      i_txn_id
    );