APPS.PQH_TAT_SHD SQL Statements

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

Line: 69

    select
		required_flag,
	view_flag,
	edit_flag,
	template_attribute_id,
	attribute_id,
	template_id,
	object_version_number
    from	pqh_template_attributes
    where	template_attribute_id = p_template_attribute_id;

Line: 146

    select 	required_flag,
	view_flag,
	edit_flag,
	template_attribute_id,
	attribute_id,
	template_id,
	object_version_number
    from	pqh_template_attributes
    where	template_attribute_id = p_template_attribute_id
    for	update nowait;

Line: 249

  ,p_last_update_date			    in  varchar2
  )  is
  l_object_version_number       number(15);

Line: 259

 l_last_updated_by            pqh_templates.last_updated_by%TYPE;

Line: 261

 l_last_update_date           pqh_templates.last_update_date%TYPE;

Line: 262

 l_last_update_login          pqh_templates.last_update_login%TYPE;

Line: 265

  select attribute_id
  from pqh_attributes a,pqh_table_route t
  where a.key_column_name = p_att_column_name
  and a.master_table_route_id= t.table_route_id(+)
  and nvl(t.table_alias,'$$$$$') = nvl(p_att_master_table_alias_name,'$$$$$')
  and nvl(a.legislation_code,'$$$$$') = nvl(p_legislation_code,'$$$$$');

Line: 273

  select template_id, transaction_category_id
  from pqh_templates_vl
  where short_name = p_template_short_name;

Line: 278

  select transaction_category_id
  from pqh_txn_category_attributes
  where attribute_id = p_attribute_id
  and transaction_category_id = p_tem_txn_category_id;

Line: 284

  select template_attribute_id
  from pqh_template_attributes
  where template_id = p_template_id
    and attribute_id = p_attribute_id;

Line: 301

    l_last_updated_by := -1;

Line: 304

    l_last_updated_by := 0;

Line: 309

  l_last_updated_by := fnd_load_util.owner_id(p_owner);

Line: 312

  l_last_update_date := sysdate;

Line: 314

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

Line: 315

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

Line: 316

  l_last_update_login := 0;

Line: 338

          update PQH_TEMPLATE_ATTRIBUTES
          set required_flag = p_required_flag,
              view_flag = p_view_flag,
              edit_flag = p_edit_flag,
              last_update_date = l_last_update_date,
              last_updated_by = l_last_updated_by,
              last_update_login = l_last_update_login
          where attribute_id = l_attribute_id
            and template_id = l_template_id;

Line: 351

          insert into pqh_template_attributes
          (required_flag, view_flag, edit_flag, template_attribute_id, attribute_id,
          template_id, object_version_number, last_update_date, last_updated_by, last_update_login,
          created_by, creation_date)
          values
          (p_required_flag, p_view_flag, p_edit_flag, pqh_template_attributes_s.nextval, l_attribute_id,
          l_template_id, 1, l_last_update_date, l_last_updated_by, l_last_update_login,
          l_created_by, l_creation_date);