APPS.JTF_AUTH_BULKLOAD_PKG SQL Statements

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

Line: 22

  select count(*) into cnt
  from fnd_user
  where user_name=U_USER_NAME;

Line: 31

  select count(*) into cnt
  from jtf_auth_principals_b
  where principal_name=U_ROLE_NAME and is_user_flag=0;

Line: 40

  select count(*) into cnt
  from jtf_auth_principals_b
  where principal_name=U_USER_NAME and is_user_flag=1;

Line: 46

	select jtf_auth_s1.nextval into seq from dual;

Line: 47

	JTF_AUTH_PRINCIPALS_PKG.INSERT_ROW(seq,seq,1,U_USER_NAME,690,null,1,0,U_USER_NAME, null, SYSDATE, 0, SYSDATE, 0, null);

Line: 51

  select count(*) into count1
  from jtf_auth_principal_maps c,
       jtf_auth_principals_b a,
       jtf_auth_domains_b d,
       jtf_auth_principals_b b
  where a.principal_name=U_USER_NAME and a.is_user_flag=1
    and a.jtf_auth_principal_id=c.jtf_auth_principal_id
    and b.principal_name=U_ROLE_NAME and b.is_user_flag=0
    and b.jtf_auth_principal_id=c.jtf_auth_parent_principal_id
    and d.domain_name='CRM_DOMAIN'
    and d.jtf_auth_domain_id=c.jtf_auth_domain_id;

Line: 63

  select jtf_auth_principal_id into p_id
  from jtf_auth_principals_b
  where principal_name=U_USER_NAME and is_user_flag=1;

Line: 67

  select jtf_auth_principal_id into r_id
  from jtf_auth_principals_b
  where principal_name=U_ROLE_NAME and is_user_flag=0;

Line: 71

  select jtf_auth_domain_id into d_id
  from jtf_auth_domains_b where
  domain_name='CRM_DOMAIN';

Line: 76

	  insert into jtf_auth_principal_maps (jtf_auth_principal_id,
		jtf_auth_parent_principal_id, jtf_auth_domain_id,
		created_by, creation_date, last_updated_by, last_update_date,
		application_id, object_version_number) values
		(p_id, r_id, d_id,
		 0,SYSDATE,0,SYSDATE,690,1);

Line: 84

   select jtf_auth_s1.nextval into source_id from dual;

Line: 86

   select jtf_auth_principal_mapping_id into mapping_id
   from jtf_auth_principal_maps
   where jtf_auth_principal_id = p_id
     and jtf_auth_parent_principal_id = r_id
     and jtf_auth_domain_id = d_id;

Line: 92

  select count(*) into maps_sources
  from jtf_auth_maps_sources a
  where a.jtf_auth_principal_mapping_id = mapping_id
  and a.ownertable_name = 'JTF_AUTH_PRINCIPALS_B'
  and a.ownertable_key = TO_CHAR(p_id);

Line: 99

   	insert into jtf_auth_maps_sources (JTF_AUTH_MAPS_SOURCE_ID,
   	JTF_AUTH_PRINCIPAL_MAPPING_ID, OWNERTABLE_NAME, OWNERTABLE_KEY,
	CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE,
	APPLICATION_ID, OBJECT_VERSION_NUMBER) VALUES
	(source_id, mapping_id,	'JTF_AUTH_PRINCIPALS_B',
          TO_CHAR(p_id), 0, SYSDATE, 0, SYSDATE, 690, 1);

Line: 139

  select count(*) into count2
  from fnd_lookups
  where lookup_type = 'JTF_AUTH_OWNERTABLE_NAME'
    and lookup_code = U_OWNERTABLE_NAME;

Line: 150

  select count(*) into cnt
  from fnd_user
  where user_name=U_USER_NAME;

Line: 159

  select count(*) into cnt
  from jtf_auth_principals_b
  where principal_name=U_ROLE_NAME and is_user_flag=0;

Line: 169

  select count(*) into cnt
  from jtf_auth_principals_b
  where principal_name=U_USER_NAME and is_user_flag=1;

Line: 175

	select jtf_auth_s1.nextval into seq from dual;

Line: 176

	JTF_AUTH_PRINCIPALS_PKG.INSERT_ROW(seq,seq,1,U_USER_NAME,690,null,1,0,U_USER_NAME, null, SYSDATE, 0, SYSDATE, 0, null);

Line: 180

  select count(*) into count1
  from jtf_auth_principal_maps c,
       jtf_auth_principals_b a,
       jtf_auth_domains_b d,
       jtf_auth_principals_b b
  where a.principal_name=U_USER_NAME and a.is_user_flag=1
    and a.jtf_auth_principal_id=c.jtf_auth_principal_id
    and b.principal_name=U_ROLE_NAME and b.is_user_flag=0
    and b.jtf_auth_principal_id=c.jtf_auth_parent_principal_id
    and d.domain_name='CRM_DOMAIN'
    and d.jtf_auth_domain_id=c.jtf_auth_domain_id;

Line: 192

  select jtf_auth_principal_id into p_id
  from jtf_auth_principals_b
  where principal_name=U_USER_NAME and is_user_flag=1;

Line: 196

  select jtf_auth_principal_id into r_id
  from jtf_auth_principals_b
  where principal_name=U_ROLE_NAME and is_user_flag=0;

Line: 200

  select jtf_auth_domain_id into d_id
  from jtf_auth_domains_b where
  domain_name='CRM_DOMAIN';

Line: 206

	insert into jtf_auth_principal_maps (jtf_auth_principal_id,
		jtf_auth_parent_principal_id, jtf_auth_domain_id,
		created_by, creation_date, last_updated_by, last_update_date,
		application_id, object_version_number) values
		(p_id, r_id, d_id,
		 0,SYSDATE,0,SYSDATE,690,1);

Line: 215

  select jtf_auth_s1.nextval into source_id from dual;

Line: 217

  select jtf_auth_principal_mapping_id into mapping_id
  from jtf_auth_principal_maps
  where jtf_auth_principal_id = p_id
    and jtf_auth_parent_principal_id = r_id
    and jtf_auth_domain_id = d_id;

Line: 223

  select count(*) into maps_sources
  from jtf_auth_maps_sources a
  where a.jtf_auth_principal_mapping_id = mapping_id
  and a.ownertable_name = U_OWNERTABLE_NAME
  and a.ownertable_key = key;

Line: 230

	  insert into jtf_auth_maps_sources (JTF_AUTH_MAPS_SOURCE_ID,
   	JTF_AUTH_PRINCIPAL_MAPPING_ID, OWNERTABLE_NAME, OWNERTABLE_KEY,
	CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE,
	APPLICATION_ID, OBJECT_VERSION_NUMBER) VALUES
	(source_id, mapping_id,	U_OWNERTABLE_NAME,
          key, 0, SYSDATE, 0, SYSDATE, 690, 1);

Line: 267

  select count(*) into cnt
  from fnd_user
  where user_name=U_USER_NAME;

Line: 276

  select count(*) into cnt
  from jtf_auth_principals_b
  where principal_name=U_ROLE_NAME and is_user_flag=0;

Line: 286

  select count(*) into cnt
  from jtf_auth_principals_b
  where principal_name=U_USER_NAME and is_user_flag=1;

Line: 292

	select jtf_auth_s1.nextval into seq from dual;

Line: 293

	JTF_AUTH_PRINCIPALS_PKG.INSERT_ROW(seq,seq,1,U_USER_NAME,APP_ID,null,1,0,U_USER_NAME, null, SYSDATE, 0, SYSDATE, 0, null);

Line: 297

  select count(*) into count1
  from jtf_auth_principal_maps c,
       jtf_auth_principals_b a,
       jtf_auth_domains_b d,
       jtf_auth_principals_b b
  where a.principal_name=U_USER_NAME and a.is_user_flag=1
    and a.jtf_auth_principal_id=c.jtf_auth_principal_id
    and b.principal_name=U_ROLE_NAME and b.is_user_flag=0
    and b.jtf_auth_principal_id=c.jtf_auth_parent_principal_id
    and d.domain_name='CRM_DOMAIN'
    and d.jtf_auth_domain_id=c.jtf_auth_domain_id;

Line: 309

  select jtf_auth_principal_id into p_id
  from jtf_auth_principals_b
  where principal_name=U_USER_NAME and is_user_flag=1;

Line: 313

  select jtf_auth_principal_id into r_id
  from jtf_auth_principals_b
  where principal_name=U_ROLE_NAME and is_user_flag=0;

Line: 317

  select jtf_auth_domain_id into d_id
  from jtf_auth_domains_b where
  domain_name='CRM_DOMAIN';

Line: 322

	  insert into jtf_auth_principal_maps (jtf_auth_principal_id,
		jtf_auth_parent_principal_id, jtf_auth_domain_id,
		created_by, creation_date, last_updated_by, last_update_date,
		application_id, object_version_number) values
		(p_id, r_id, d_id,
		 0,SYSDATE,0,SYSDATE,APP_ID,1);

Line: 330

   select jtf_auth_s1.nextval into source_id from dual;

Line: 332

   select jtf_auth_principal_mapping_id into mapping_id
   from jtf_auth_principal_maps
   where jtf_auth_principal_id = p_id
     and jtf_auth_parent_principal_id = r_id
     and jtf_auth_domain_id = d_id;

Line: 338

  select count(*) into maps_sources
  from jtf_auth_maps_sources a
  where a.jtf_auth_principal_mapping_id = mapping_id
  and a.ownertable_name = 'JTF_AUTH_PRINCIPALS_B'
  and a.ownertable_key = TO_CHAR(p_id);

Line: 345

   	insert into jtf_auth_maps_sources (JTF_AUTH_MAPS_SOURCE_ID,
   	JTF_AUTH_PRINCIPAL_MAPPING_ID, OWNERTABLE_NAME, OWNERTABLE_KEY,
	CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE,
	APPLICATION_ID, OBJECT_VERSION_NUMBER) VALUES
	(source_id, mapping_id,	'JTF_AUTH_PRINCIPALS_B',
          TO_CHAR(p_id), 0, SYSDATE, 0, SYSDATE, APP_ID, 1);

Line: 386

  select count(*) into count2
  from fnd_lookups
  where lookup_type = 'JTF_AUTH_OWNERTABLE_NAME'
    and lookup_code = U_OWNERTABLE_NAME;

Line: 397

  select count(*) into cnt
  from fnd_user
  where user_name=U_USER_NAME;

Line: 406

  select count(*) into cnt
  from jtf_auth_principals_b
  where principal_name=U_ROLE_NAME and is_user_flag=0;

Line: 416

  select count(*) into cnt
  from jtf_auth_principals_b
  where principal_name=U_USER_NAME and is_user_flag=1;

Line: 422

	select jtf_auth_s1.nextval into seq from dual;

Line: 423

	JTF_AUTH_PRINCIPALS_PKG.INSERT_ROW(seq,seq,1,U_USER_NAME,APP_ID,null,1,0,U_USER_NAME, null, SYSDATE, 0, SYSDATE, 0, null);

Line: 427

  select count(*) into count1
  from jtf_auth_principal_maps c,
       jtf_auth_principals_b a,
       jtf_auth_domains_b d,
       jtf_auth_principals_b b
  where a.principal_name=U_USER_NAME and a.is_user_flag=1
    and a.jtf_auth_principal_id=c.jtf_auth_principal_id
    and b.principal_name=U_ROLE_NAME and b.is_user_flag=0
    and b.jtf_auth_principal_id=c.jtf_auth_parent_principal_id
    and d.domain_name='CRM_DOMAIN'
    and d.jtf_auth_domain_id=c.jtf_auth_domain_id;

Line: 439

  select jtf_auth_principal_id into p_id
  from jtf_auth_principals_b
  where principal_name=U_USER_NAME and is_user_flag=1;

Line: 443

  select jtf_auth_principal_id into r_id
  from jtf_auth_principals_b
  where principal_name=U_ROLE_NAME and is_user_flag=0;

Line: 447

  select jtf_auth_domain_id into d_id
  from jtf_auth_domains_b where
  domain_name='CRM_DOMAIN';

Line: 453

	insert into jtf_auth_principal_maps (jtf_auth_principal_id,
		jtf_auth_parent_principal_id, jtf_auth_domain_id,
		created_by, creation_date, last_updated_by, last_update_date,
		application_id, object_version_number) values
		(p_id, r_id, d_id,
		 0,SYSDATE,0,SYSDATE,APP_ID,1);

Line: 462

  select jtf_auth_s1.nextval into source_id from dual;

Line: 464

  select jtf_auth_principal_mapping_id into mapping_id
  from jtf_auth_principal_maps
  where jtf_auth_principal_id = p_id
    and jtf_auth_parent_principal_id = r_id
    and jtf_auth_domain_id = d_id;

Line: 470

  select count(*) into maps_sources
  from jtf_auth_maps_sources a
  where a.jtf_auth_principal_mapping_id = mapping_id
  and a.ownertable_name = U_OWNERTABLE_NAME
  and a.ownertable_key = key;

Line: 477

  	insert into jtf_auth_maps_sources (JTF_AUTH_MAPS_SOURCE_ID,
   	JTF_AUTH_PRINCIPAL_MAPPING_ID, OWNERTABLE_NAME, OWNERTABLE_KEY,
	CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE,
	APPLICATION_ID, OBJECT_VERSION_NUMBER) VALUES
	(source_id, mapping_id,	U_OWNERTABLE_NAME,
          key, 0, SYSDATE, 0, SYSDATE, APP_ID, 1);