APPS.CSP_PP_UTIL SQL Statements

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

Line: 16

PROCEDURE insert_mtlt
  (
    x_return_status  OUT NOCOPY VARCHAR2
   ,p_mtlt_tbl       IN  g_mtlt_tbl_type
   ,p_mtlt_tbl_size  IN  INTEGER
   )
  IS
     l_api_name  CONSTANT VARCHAR2(30) := 'insert_mtlt';

Line: 36

   SELECT Sysdate INTO l_today FROM dual;

Line: 40

      INSERT INTO mtl_transaction_lots_temp
    (
      transaction_temp_id
     ,last_update_date
     ,last_updated_by
     ,creation_date
     ,created_by
     ,last_update_login
     ,request_id
     ,program_application_id
     ,program_id
     ,program_update_date
     ,transaction_quantity
     ,primary_quantity
     ,lot_number
     ,lot_expiration_date
     ,error_code
     ,serial_transaction_temp_id
     ,group_header_id
     ,put_away_rule_id
     ,pick_rule_id
     )
    VALUES
    (
      p_mtlt_tbl(l_counter).transaction_temp_id
     ,l_today
     ,l_user_id
     ,l_today
     ,l_user_id
     ,l_login_id
     ,p_mtlt_tbl(l_counter).request_id
     ,p_mtlt_tbl(l_counter).program_application_id
     ,p_mtlt_tbl(l_counter).program_id
     ,p_mtlt_tbl(l_counter).program_update_date
     ,p_mtlt_tbl(l_counter).transaction_quantity
     ,p_mtlt_tbl(l_counter).primary_quantity
     ,p_mtlt_tbl(l_counter).lot_number
     ,p_mtlt_tbl(l_counter).lot_expiration_date
     ,p_mtlt_tbl(l_counter).error_code
     ,p_mtlt_tbl(l_counter).serial_transaction_temp_id
     ,p_mtlt_tbl(l_counter).group_header_id
     ,p_mtlt_tbl(l_counter).put_away_rule_id
     ,p_mtlt_tbl(l_counter).pick_rule_id
     );

Line: 100

END insert_mtlt;

Line: 103

PROCEDURE insert_msnt
  (
    x_return_status  OUT NOCOPY VARCHAR2
   ,p_msnt_tbl       IN  g_msnt_tbl_type
   ,p_msnt_tbl_size  IN  INTEGER
   )
  IS
     l_api_name  CONSTANT VARCHAR2(30) := 'Insert_MSNT';

Line: 123

   SELECT Sysdate INTO l_today FROM dual;

Line: 127

      INSERT INTO mtl_serial_numbers_temp
    (
      transaction_temp_id
     ,last_update_date
     ,last_updated_by
     ,creation_date
     ,created_by
     ,last_update_login
     ,request_id
     ,program_application_id
     ,program_id
     ,program_update_date
     ,vendor_serial_number
     ,vendor_lot_number
     ,fm_serial_number
     ,to_serial_number
     ,serial_prefix
     ,error_code
     ,group_header_id
     ,parent_serial_number
     ,end_item_unit_number
     )
    VALUES
    (
      p_msnt_tbl(l_counter).transaction_temp_id
     ,l_today
     ,l_user_id
     ,l_today
     ,l_user_id
     ,l_login_id
     ,p_msnt_tbl(l_counter).request_id
     ,p_msnt_tbl(l_counter).program_application_id
     ,p_msnt_tbl(l_counter).program_id
     ,p_msnt_tbl(l_counter).program_update_date
     ,p_msnt_tbl(l_counter).vendor_serial_number
     ,p_msnt_tbl(l_counter).vendor_lot_number
     ,p_msnt_tbl(l_counter).fm_serial_number
     ,p_msnt_tbl(l_counter).to_serial_number
     ,p_msnt_tbl(l_counter).serial_prefix
     ,p_msnt_tbl(l_counter).error_code
     ,p_msnt_tbl(l_counter).group_header_id
     ,p_msnt_tbl(l_counter).parent_serial_number
     ,p_msnt_tbl(l_counter).end_item_unit_number
     );

Line: 184

END insert_msnt;

Line: 253

    SELECT distinct concatenated_segments INTO l_item_name
    FROM mtl_system_items_kfv
    WHERE inventory_item_id = p_item_id;