APPS.PAY_DYNDBI_CHANGES_PKG SQL Statements

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

Line: 5

procedure insert_row
(p_id in varchar2
,p_type in varchar2
,p_language in varchar2
) is
begin
  insert into pay_dyndbi_changes
  (id
  ,type
  ,language
  )
  select p_id
  ,      p_type
  ,      p_language
  from   dual
  where  not exists
  (
    select null
    from   pay_dyndbi_changes pdc
    where  pdc.id = p_id
    and    pdc.type = p_type
    and    pdc.language = p_language
  );

Line: 28

end insert_row;

Line: 31

procedure insert_rows
(p_id in varchar2
,p_type in varchar2
,p_languages in dbms_sql.varchar2s
) is
begin
  for i in 1 .. p_languages.count loop
    insert into pay_dyndbi_changes
    (id
    ,type
    ,language
    )
    select p_id
    ,      p_type
    ,      p_languages(i)
    from   dual
    where  not exists
    (
      select null
      from   pay_dyndbi_changes pdc
      where  pdc.id = p_id
      and    pdc.type = p_type
      and    pdc.language = p_languages(i)
    );

Line: 56

end insert_rows;

Line: 71

select iv.input_value_id
from   pay_input_values_f iv
where  iv.element_type_id = p_element_type_id
and    iv.generate_db_items_flag = 'Y'
and    iv.effective_end_date =
       (
         select max(iv1.effective_end_date)
         from   pay_input_values_f iv1
         where  iv1.input_value_id = iv.input_value_id
       )
;

Line: 84

  insert_rows
  (p_id        => p_element_type_id
  ,p_type      => C_ELEMENT_TYPE
  ,p_languages => p_languages
  );

Line: 91

    insert_rows
    (p_id        => iv.input_value_id
    ,p_type      => C_INPUT_VALUE
    ,p_languages => p_languages
    );

Line: 107

select db.defined_balance_id
from   pay_defined_balances db
where  db.balance_type_id = p_balance_type_id
;

Line: 113

    insert_rows
    (p_id        => db.defined_balance_id
    ,p_type      => C_DEFINED_BALANCE
    ,p_languages => p_languages
    );

Line: 127

select null
from   pay_input_values_f iv
where  iv.input_value_id = p_input_value_id
and    iv.generate_db_items_flag = 'Y'
and    iv.effective_end_date =
       (
         select max(iv1.effective_end_date)
         from   pay_input_values_f iv1
         where  iv1.input_value_id = p_input_value_id
       )
;

Line: 145

    insert_rows
    (p_id        => p_input_value_id
    ,p_type      => C_INPUT_VALUE
    ,p_languages => p_languages
    );

Line: 162

select db.defined_balance_id
from   pay_defined_balances db
where  db.balance_dimension_id = p_balance_dimension_id
;

Line: 168

    insert_rows
    (p_id        => db.defined_balance_id
    ,p_type      => C_DEFINED_BALANCE
    ,p_languages => p_languages
    );

Line: 177

procedure delete_row
(p_id in varchar2
,p_type in varchar2
,p_language in varchar2
) is
begin
  delete from pay_dyndbi_changes pdc
  where  pdc.id = p_id
  and    pdc.type = p_type
  and    pdc.language = p_language
  ;

Line: 188

end delete_row;

Line: 191

procedure delete_rows
(p_id in number
,p_type in varchar2
) is
begin
  delete from pay_dyndbi_changes pdc
  where  pdc.id = p_id
  and    pdc.type = p_type
  ;

Line: 200

end delete_rows;