APPS.PQH_SEED_BEN_CRITERIA SQL Statements

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

Line: 26

                        ,p_last_update_date               in varchar2
                        ) is

   l_ovn                     number := 1;

Line: 31

   l_last_updated_by         ben_eligy_criteria.last_updated_by%type;

Line: 33

   l_last_update_date        ben_eligy_criteria.last_update_date%type;

Line: 34

   l_last_update_login       ben_eligy_criteria.last_update_login%type;

Line: 43

  select flex_value_set_id
    from fnd_flex_value_sets
   where flex_value_set_name = p_valset_name;

Line: 48

  select eligy_criteria_id
    from ben_eligy_criteria
   where short_code = p_short_code and business_group_id is null and criteria_type='STD';

Line: 53

  select eligy_criteria_id
    from ben_eligy_criteria
   where short_code = p_short_code and business_group_id is not null and criteria_type='STD';

Line: 64

  l_last_updated_by := fnd_load_util.owner_id(p_owner);

Line: 66

  l_creation_date := nvl(to_date(p_last_update_date,'YYYY/MM/DD'),trunc(sysdate));

Line: 67

  l_last_update_date := nvl(to_date(p_last_update_date,'YYYY/MM/DD'),trunc(sysdate));

Line: 70

  l_last_update_date := sysdate;

Line: 72

  l_last_update_login := 0;

Line: 88

   update ben_eligy_criteria set
   name = p_name,
   description = p_description,
   crit_col1_val_type_cd = p_crit_col1_val_type_cd,
   crit_col1_datatype = p_crit_col1_datatype,
   col1_lookup_type = p_col1_lookup_type,
   col1_value_set_id = l_col1_value_set_id,
   access_table_name1 = p_access_table_name1 ,
   access_column_name1 = p_access_column_name1,
   crit_col2_val_type_cd = p_crit_col2_val_type_cd,
   crit_col2_datatype = p_crit_col2_datatype,
   col2_lookup_type = p_col2_lookup_type,
   col2_value_set_id = l_col2_value_set_id,
   access_table_name2 = p_access_table_name2,
   access_column_name2 = p_access_column_name2,
   allow_range_validation_flag = p_allow_range_validation_flag,
   allow_range_validation_flag2 = p_allow_range_validation_flag2,
   user_defined_flag = p_user_defined_flag,
   business_group_id = to_number(p_business_group_id),
   legislation_code = p_legislation_code,
   criteria_type = 'STD',
   last_updated_by        = l_last_updated_by,
   last_update_date       = l_last_update_date,
   last_update_login      = l_last_update_login
   where eligy_criteria_id = l_eligy_criteria_id;

Line: 118

   update ben_eligy_criteria set
   name = p_name,
   description = p_description,
   crit_col1_val_type_cd = p_crit_col1_val_type_cd,
   crit_col1_datatype = p_crit_col1_datatype,
   col1_lookup_type = p_col1_lookup_type,
   col1_value_set_id = l_col1_value_set_id,
   access_table_name1 = p_access_table_name1 ,
   access_column_name1 = p_access_column_name1,
   crit_col2_val_type_cd = p_crit_col2_val_type_cd,
   crit_col2_datatype = p_crit_col2_datatype,
   col2_lookup_type = p_col2_lookup_type,
   col2_value_set_id = l_col2_value_set_id,
   access_table_name2 = p_access_table_name2,
   access_column_name2 = p_access_column_name2,
   allow_range_validation_flag = p_allow_range_validation_flag,
   allow_range_validation_flag2 = p_allow_range_validation_flag2,
   user_defined_flag = p_user_defined_flag,
   legislation_code = p_legislation_code,
   criteria_type = 'STD',
   last_updated_by        = l_last_updated_by,
   last_update_date       = l_last_update_date,
   last_update_login      = l_last_update_login
   where eligy_criteria_id = bg_crit_rec.eligy_criteria_id;

Line: 147

    insert into ben_eligy_criteria
    (
    eligy_criteria_id,
    short_code,
    name,
    description,
    crit_col1_val_type_cd,
    crit_col1_datatype,
    col1_lookup_type,
    col1_value_set_id,
    access_table_name1,
    access_column_name1,
    crit_col2_val_type_cd,
    crit_col2_datatype,
    col2_lookup_type,
    col2_value_set_id,
    access_table_name2,
    access_column_name2,
    allow_range_validation_flag,
    allow_range_validation_flag2,
    user_defined_flag,
    business_group_id,
    legislation_code,
    criteria_type,
    created_by,
    creation_date,
    last_updated_by,
    last_update_date,
    last_update_login,
    object_version_number
    )
    values
    (
    ben_eligy_criteria_s.nextval,
    p_short_code,
    p_name,
    p_description,
    p_crit_col1_val_type_cd,
    p_crit_col1_datatype,
    p_col1_lookup_type,
    l_col1_value_set_id,
    p_access_table_name1,
    p_access_column_name1,
    p_crit_col2_val_type_cd,
    p_crit_col2_datatype,
    p_col2_lookup_type,
    l_col2_value_set_id,
    p_access_table_name2,
    p_access_column_name2,
    p_allow_range_validation_flag,
    p_allow_range_validation_flag2,
    p_user_defined_flag,
    null,
    p_legislation_code,
    'STD',
    l_created_by,
    l_creation_date,
    l_last_updated_by,
    l_last_update_date,
    l_last_update_login,
    l_ovn
    );