APPS.PSB_POSITION_ATTRIBUTES_PVT SQL Statements

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

Line: 8

PROCEDURE INSERT_ROW
( p_api_version                 IN      NUMBER,
  p_init_msg_list               IN      VARCHAR2 := FND_API.G_FALSE,
  p_commit                      IN      VARCHAR2 := FND_API.G_FALSE,
  p_validation_level            IN      NUMBER  := FND_API.G_VALID_LEVEL_FULL,
  p_return_status               OUT  NOCOPY     VARCHAR2,
  p_msg_count                   OUT  NOCOPY     NUMBER,
  p_msg_data                    OUT  NOCOPY     VARCHAR2,
  --
  p_ROW_ID                      IN OUT  NOCOPY  VARCHAR2,
  p_ATTRIBUTE_ID                IN      NUMBER,
  p_BUSINESS_GROUP_ID           IN      NUMBER,
  p_NAME                        IN      VARCHAR2,
  p_DISPLAY_IN_WORKSHEET        IN      VARCHAR2,
  p_DISPLAY_SEQUENCE            IN      NUMBER,
  p_DISPLAY_PROMPT              IN      VARCHAR2,
  p_REQUIRED_FOR_IMPORT_FLAG    IN      VARCHAR2,
  p_REQUIRED_FOR_POSITIONS_FLAG IN      VARCHAR2,
  p_ALLOW_IN_POSITION_SET_FLAG  IN      VARCHAR2,
  p_VALUE_TABLE_FLAG            IN      VARCHAR2,
  p_PROTECTED_FLAG              IN      VARCHAR2,
  p_DEFINITION_TYPE             IN      VARCHAR2,
  p_DEFINITION_STRUCTURE        IN      VARCHAR2,
  p_DEFINITION_TABLE            IN      VARCHAR2,
  p_DEFINITION_COLUMN           IN      VARCHAR2,
  p_ATTRIBUTE_TYPE_ID           IN      NUMBER,
  p_DATA_TYPE                   IN      VARCHAR2,
  p_APPLICATION_ID              IN      NUMBER,
  p_SYSTEM_ATTRIBUTE_TYPE       IN      VARCHAR2,
  p_LAST_UPDATE_DATE            IN      DATE,
  p_LAST_UPDATED_BY             IN      NUMBER,
  p_LAST_UPDATE_LOGIN           IN      NUMBER,
  p_CREATED_BY                  IN      NUMBER,
  p_CREATION_DATE               IN      DATE
) AS

  l_api_name            CONSTANT VARCHAR2(30)   := 'INSERT_ROW';

Line: 49

     select row_id from psb_attributes_VL
     where attribute_id = p_attribute_id;

Line: 56

  SAVEPOINT     INSERT_ROW_PVT;

Line: 80

  INSERT INTO psb_attributes
  (ATTRIBUTE_ID                             ,
   BUSINESS_GROUP_ID                        ,
   NAME                                     ,
   DISPLAY_IN_WORKSHEET                     ,
   DISPLAY_SEQUENCE                         ,
   DISPLAY_PROMPT                           ,
   REQUIRED_FOR_IMPORT_FLAG                 ,
   REQUIRED_FOR_POSITIONS_FLAG              ,
   ALLOW_IN_POSITION_SET_FLAG               ,
   VALUE_TABLE_FLAG                         ,
   PROTECTED_FLAG                           ,
   DEFINITION_TYPE                          ,
   DEFINITION_STRUCTURE                     ,
   DEFINITION_TABLE                         ,
   DEFINITION_COLUMN                        ,
   ATTRIBUTE_TYPE_ID                        ,
   DATA_TYPE                                ,
   APPLICATION_ID                           ,
   SYSTEM_ATTRIBUTE_TYPE                    ,
   LAST_UPDATE_DATE                         ,
   LAST_UPDATED_BY                          ,
   LAST_UPDATE_LOGIN                        ,
   CREATED_BY                               ,
   CREATION_DATE
  )
  VALUES
  (
  p_attribute_id				,
  p_BUSINESS_GROUP_ID           ,
  p_NAME                        ,
  p_DISPLAY_IN_WORKSHEET        ,
  p_DISPLAY_SEQUENCE            ,
  p_DISPLAY_PROMPT              ,
  p_REQUIRED_FOR_IMPORT_FLAG    ,
  p_REQUIRED_FOR_POSITIONS_FLAG ,
  p_ALLOW_IN_POSITION_SET_FLAG  ,
  p_VALUE_TABLE_FLAG            ,
  p_PROTECTED_FLAG              ,
  p_DEFINITION_TYPE             ,
  p_DEFINITION_STRUCTURE        ,
  p_DEFINITION_TABLE            ,
  p_DEFINITION_COLUMN           ,
  p_ATTRIBUTE_TYPE_ID           ,
  p_DATA_TYPE                   ,
  p_APPLICATION_ID              ,
  P_SYSTEM_ATTRIBUTE_TYPE       ,
  p_LAST_UPDATE_DATE            ,
  p_LAST_UPDATED_BY             ,
  p_LAST_UPDATE_LOGIN           ,
  p_CREATED_BY                  ,
  p_CREATION_DATE
  );

Line: 134

    insert into PSB_ATTRIBUTES_TL (
      ATTRIBUTE_ID,
      NAME,
      DISPLAY_PROMPT,
      LAST_UPDATE_DATE,
      LAST_UPDATED_BY,
      LAST_UPDATE_LOGIN,
      CREATED_BY,
      CREATION_DATE,
      LANGUAGE,
      SOURCE_LANG
    ) select
      P_ATTRIBUTE_ID,
      P_NAME,
      P_DISPLAY_PROMPT,
      P_LAST_UPDATE_DATE,
      P_LAST_UPDATED_BY,
      P_LAST_UPDATE_LOGIN,
      P_CREATED_BY,
      P_CREATION_DATE,
      L.LANGUAGE_CODE,
      userenv('LANG')
    from FND_LANGUAGES L
    where L.INSTALLED_FLAG in ('I', 'B')
    and not exists
    (select NULL
     from PSB_ATTRIBUTES_TL T
     where T.ATTRIBUTE_ID = P_ATTRIBUTE_ID
     and T.LANGUAGE = L.LANGUAGE_CODE);

Line: 188

     rollback to INSERT_ROW_PVT;

Line: 198

     rollback to INSERT_ROW_PVT;

Line: 208

     rollback to INSERT_ROW_PVT;

Line: 221

END INSERT_ROW;

Line: 223

PROCEDURE UPDATE_ROW
( p_api_version                 IN      NUMBER,
  p_init_msg_list               IN      VARCHAR2 := FND_API.G_FALSE,
  p_commit                      IN      VARCHAR2 := FND_API.G_FALSE,
  p_validation_level            IN      NUMBER  := FND_API.G_VALID_LEVEL_FULL,
  p_return_status               OUT  NOCOPY     VARCHAR2,
  p_msg_count                   OUT  NOCOPY     NUMBER,
  p_msg_data                    OUT  NOCOPY     VARCHAR2,
  --
  p_ATTRIBUTE_ID                IN      NUMBER,
  p_BUSINESS_GROUP_ID           IN      NUMBER,
  p_NAME                        IN      VARCHAR2,
  p_DISPLAY_IN_WORKSHEET        IN      VARCHAR2,
  p_DISPLAY_SEQUENCE            IN      NUMBER,
  p_DISPLAY_PROMPT              IN      VARCHAR2,
  p_REQUIRED_FOR_IMPORT_FLAG    IN      VARCHAR2,
  p_REQUIRED_FOR_POSITIONS_FLAG IN      VARCHAR2,
  p_ALLOW_IN_POSITION_SET_FLAG  IN      VARCHAR2,
  p_VALUE_TABLE_FLAG            IN      VARCHAR2,
  p_PROTECTED_FLAG              IN      VARCHAR2,
  p_DEFINITION_TYPE             IN      VARCHAR2,
  p_DEFINITION_STRUCTURE        IN      VARCHAR2,
  p_DEFINITION_TABLE            IN      VARCHAR2,
  p_DEFINITION_COLUMN           IN      VARCHAR2,
  p_ATTRIBUTE_TYPE_ID           IN      NUMBER,
  p_DATA_TYPE                   IN      VARCHAR2,
  p_APPLICATION_ID              IN      NUMBER,
  p_SYSTEM_ATTRIBUTE_TYPE       IN      VARCHAR2,
  p_LAST_UPDATE_DATE            IN      DATE,
  p_LAST_UPDATED_BY             IN      NUMBER,
  p_LAST_UPDATE_LOGIN           IN      NUMBER
) AS

  l_api_name            CONSTANT VARCHAR2(30)   := 'UPDATE_ROW';

Line: 263

  SAVEPOINT     UPDATE_ROW_PVT;

Line: 286

  UPDATE psb_attributes SET
    ATTRIBUTE_ID                = p_ATTRIBUTE_ID,
    BUSINESS_GROUP_ID           = p_BUSINESS_GROUP_ID ,
    NAME                        = p_NAME ,
    DISPLAY_IN_WORKSHEET        = p_DISPLAY_IN_WORKSHEET,
    DISPLAY_SEQUENCE            = p_DISPLAY_SEQUENCE,
    DISPLAY_PROMPT              = p_DISPLAY_PROMPT,
    REQUIRED_FOR_IMPORT_FLAG    = p_REQUIRED_FOR_IMPORT_FLAG,
    REQUIRED_FOR_POSITIONS_FLAG = p_REQUIRED_FOR_POSITIONS_FLAG,
    ALLOW_IN_POSITION_SET_FLAG  = p_ALLOW_IN_POSITION_SET_FLAG,
    VALUE_TABLE_FLAG            = p_VALUE_TABLE_FLAG,
    PROTECTED_FLAG              = p_PROTECTED_FLAG,
    DEFINITION_TYPE             = p_DEFINITION_TYPE,
    DEFINITION_STRUCTURE        = p_DEFINITION_STRUCTURE,
    DEFINITION_TABLE            = p_DEFINITION_TABLE,
    DEFINITION_COLUMN           = p_DEFINITION_COLUMN,
    ATTRIBUTE_TYPE_ID           = p_ATTRIBUTE_TYPE_ID,
    DATA_TYPE                   = p_DATA_TYPE,
    APPLICATION_ID              = P_APPLICATION_ID,
    SYSTEM_ATTRIBUTE_TYPE       = P_SYSTEM_ATTRIBUTE_TYPE
  WHERE attribute_id = p_attribute_id;

Line: 312

  update PSB_ATTRIBUTES_TL set
    NAME = P_NAME,
    DISPLAY_PROMPT = P_DISPLAY_PROMPT,
    LAST_UPDATE_DATE = P_LAST_UPDATE_DATE,
    LAST_UPDATED_BY = P_LAST_UPDATED_BY,
    LAST_UPDATE_LOGIN = P_LAST_UPDATE_LOGIN,
    SOURCE_LANG = userenv('LANG')
  where ATTRIBUTE_ID = P_ATTRIBUTE_ID
  and userenv('LANG') in (LANGUAGE, SOURCE_LANG);

Line: 343

     rollback to UPDATE_ROW_PVT;

Line: 353

     rollback to UPDATE_ROW_PVT;

Line: 363

     rollback to UPDATE_ROW_PVT;

Line: 376

END UPDATE_ROW;

Line: 378

PROCEDURE DELETE_ROW
( p_api_version         IN      NUMBER,
  p_init_msg_list       IN      VARCHAR2 := FND_API.G_FALSE,
  p_commit              IN      VARCHAR2 := FND_API.G_FALSE,
  p_validation_level    IN      NUMBER  := FND_API.G_VALID_LEVEL_FULL,
  p_return_status       OUT  NOCOPY     VARCHAR2,
  p_msg_count           OUT  NOCOPY     NUMBER,
  p_msg_data            OUT  NOCOPY     VARCHAR2,
  --
  p_ATTRIBUTE_ID        IN      NUMBER
) AS

  l_api_name            CONSTANT VARCHAR2(30)   := 'DELETE_ROW';

Line: 397

  SAVEPOINT     DELETE_ROW_PVT;

Line: 417

  delete from PSB_ATTRIBUTES_TL
  where ATTRIBUTE_ID = P_ATTRIBUTE_ID;

Line: 424

  DELETE FROM psb_attributes WHERE attribute_id = p_attribute_id;

Line: 447

     rollback to DELETE_ROW_PVT;

Line: 457

     rollback to DELETE_ROW_PVT;

Line: 467

     rollback to DELETE_ROW_PVT;

Line: 480

END DELETE_ROW;

Line: 520

  cursor c is select
      ALLOW_IN_POSITION_SET_FLAG,
      VALUE_TABLE_FLAG,
      APPLICATION_ID,
      DEFINITION_TYPE,
      ATTRIBUTE_TYPE_ID,
      DATA_TYPE,
      SYSTEM_ATTRIBUTE_TYPE,
      BUSINESS_GROUP_ID,
      REQUIRED_FOR_POSITIONS_FLAG,
      REQUIRED_FOR_IMPORT_FLAG,
      PROTECTED_FLAG,
      DEFINITION_STRUCTURE,
      DEFINITION_TABLE,
      DEFINITION_COLUMN,
      DISPLAY_SEQUENCE,
      DISPLAY_IN_WORKSHEET
    from PSB_ATTRIBUTES
    where ATTRIBUTE_ID = p_ATTRIBUTE_ID
    for update of ATTRIBUTE_ID nowait;

Line: 542

  cursor c1 is select
      NAME,
      DISPLAY_PROMPT,
      decode(LANGUAGE, userenv('LANG'), 'Y', 'N') BASELANG
    from PSB_ATTRIBUTES_TL
    where ATTRIBUTE_ID = p_ATTRIBUTE_ID
    and userenv('LANG') in (LANGUAGE, SOURCE_LANG)
    for update of ATTRIBUTE_ID nowait;

Line: 576

    FND_MESSAGE.Set_Name('FND', 'FORM_RECORD_DELETED');

Line: 707

    SELECT '1'
    FROM psb_attributes_VL
    WHERE name = p_name
    AND   business_group_id = p_business_group_id
    AND   ( (p_Row_Id IS NULL)
	     OR (row_id <> p_Row_Id) );

Line: 805

    SELECT '1'
    FROM psb_position_assignments
    WHERE attribute_id = p_attribute_Id;

Line: 810

   SELECT '1'
   FROM   psb_account_position_set_lines
   WHERE  attribute_id = p_attribute_Id;

Line: 921

    SELECT '1'
    FROM psb_attribute_values
    WHERE attribute_id = p_attribute_Id;

Line: 997

PROCEDURE Insert_System_Attributes
(
  p_api_version                 IN      NUMBER,
  p_init_msg_list               IN      VARCHAR2 := FND_API.G_FALSE,
  p_commit                      IN      VARCHAR2 := FND_API.G_FALSE,
  p_validation_level            IN      NUMBER   := FND_API.G_VALID_LEVEL_FULL,
  p_return_status               OUT  NOCOPY     VARCHAR2,
  p_msg_count                   OUT  NOCOPY     NUMBER,
  p_msg_data                    OUT  NOCOPY     VARCHAR2,
  --
  p_business_group_id   IN      NUMBER
)
AS

  l_api_name            CONSTANT VARCHAR2(30)   := 'Insert_System_Attributes';

Line: 1049

  SAVEPOINT Insert_System_Attributes ;

Line: 1152

      (SELECT system_attribute_type,
	      attribute_id
       FROM  psb_attributes
       WHERE system_attribute_type =
              l_sys_attributes_tbl(l_rec).l_sys_attribute_type
       AND   business_group_id = p_business_group_id)
    LOOP
      --update statement as the system attribute statement already exists
      l_exists_attribute := TRUE;

Line: 1162

      UPDATE psb_attributes
      SET definition_type   = null,
	  last_update_date  = sysdate,
	  last_updated_by   = 1,
	  last_update_login = null
      WHERE attribute_id = l_sys_attribute_exist.attribute_id;

Line: 1175

          (SELECT attribute_id
           FROM psb_attributes
           WHERE name = l_sys_attributes_tbl(l_rec).l_attribute_name
           AND business_group_id = p_business_group_id
           )
        LOOP
          -- update the psb_attributes_tl table
	  UPDATE psb_attributes_tl
	  SET name = name || '_X',
	      last_update_date = sysdate,
	      last_updated_by  = 1,
	      last_update_login = null
	  WHERE attribute_id = l_org_rec.attribute_id;

Line: 1191

	  UPDATE psb_attributes
	  SET
	    name              = name || '_X'
	  , last_update_date  = SYSDATE
	  , last_updated_by   = 1
	  , last_update_login = NULL
	  WHERE
	    attribute_id = l_org_rec.attribute_id ;

Line: 1205

        (SELECT psb_attributes_s.nextval attribute_id
         FROM dual)
      LOOP
        l_attribute_id := l_attribute_id_rec.attribute_id;

Line: 1211

      PSB_POSITION_ATTRIBUTES_PVT.INSERT_ROW
      ( p_api_version 	    => 1.0,
        p_return_status     => p_return_status,
        p_msg_count 	    => l_msg_count,
        p_msg_data          => l_msg_data,
        p_row_id            => l_rowid,
        p_attribute_id      => l_attribute_id,
        p_business_group_id => p_business_group_id,
        p_name
          => l_sys_attributes_tbl(l_rec).l_attribute_name,
        p_display_in_worksheet
          => l_sys_attributes_tbl(l_rec).l_display_worksheet,
        p_display_sequence
          => l_sys_attributes_tbl(l_rec).l_display_seq,
        p_display_prompt
          => l_sys_attributes_tbl(l_rec).l_attribute_name,
        p_required_for_import_flag
          => l_sys_attributes_tbl(l_rec).L_req_import_flg,
        p_required_for_positions_flag
          => l_sys_attributes_tbl(l_rec).l_req_position_flg,
        p_allow_in_position_set_flag
          => l_sys_attributes_tbl(l_rec).l_allow_pos_set_flg,
        p_value_table_flag
          => l_sys_attributes_tbl(l_rec).l_value_table_flg,
        p_protected_flag    => null,
        p_definition_type   => null,
        p_definition_structure
          => null,
        p_definition_table  => null,
        p_definition_column => null,
        p_attribute_type_id => null,
        p_data_type
          => l_sys_attributes_tbl(l_rec).l_data_type,
        p_application_id
          => l_sys_attributes_tbl(l_rec).l_application_id,
        p_system_attribute_type
          => l_sys_attributes_tbl(l_rec).l_sys_attribute_type,
        p_last_update_date  => sysdate,
        p_last_updated_by   => 1,
        p_last_update_login => null,
        p_created_by        => 1,
        p_creation_date     => sysdate
       );

Line: 1278

    select SYSTEM_ATTRIBUTE_TYPE,
	   ATTRIBUTE_ID
      into Temp_Type
	 , Temp_ID
      from PSB_ATTRIBUTES
     where SYSTEM_ATTRIBUTE_TYPE = 'JOB_CLASS'
       and BUSINESS_GROUP_ID     = p_business_group_id;

Line: 1293

    select psb_attributes_s.nextval
      into Temp_ID
      from dual;

Line: 1297

    INSERT INTO PSB_ATTRIBUTES (
	ATTRIBUTE_ID,
	BUSINESS_GROUP_ID,
	NAME,
	DISPLAY_IN_WORKSHEET,
	DISPLAY_SEQUENCE,
	DISPLAY_PROMPT,
	REQUIRED_FOR_IMPORT_FLAG,
	REQUIRED_FOR_POSITIONS_FLAG,
	VALUE_TABLE_FLAG,
	APPLICATION_ID,
	DATA_TYPE,
	SYSTEM_ATTRIBUTE_TYPE,
	LAST_UPDATE_DATE,
	LAST_UPDATED_BY,
	LAST_UPDATE_LOGIN,
	CREATED_BY,
	CREATION_DATE,
	ALLOW_IN_POSITION_SET_FLAG)
    VALUES (
	Temp_ID,
	p_business_group_id,
	l_attribute_name,
	'Y',
	1,
	l_attribute_name,
	'Y',
	'Y',
	'Y',
	NULL,
	'C',
	'JOB_CLASS',
	sysdate,
	1,
	NULL,
	1,
	sysdate,
	'Y'
	);

Line: 1337

    INSERT INTO PSB_ATTRIBUTES_TL(
	ATTRIBUTE_ID,
	NAME,
	DISPLAY_PROMPT,
	LANGUAGE,
	SOURCE_LANG,
	LAST_UPDATE_DATE,
	LAST_UPDATED_BY,
	LAST_UPDATE_LOGIN,
	CREATED_BY,
	CREATION_DATE)
    VALUES (
	Temp_ID,
	l_attribute_name,
	l_attribute_name,
--Bug No 2740368 Start
--	'US',
--	userenv('LANG'),
-- Bug No 2740368 End
	'US',
	sysdate,
	1,
	NULL,
	1,
	sysdate
	);

Line: 1364

     Update psb_attributes
	set definition_type   = null
	  , last_update_date  = sysdate
	  , last_updated_by   = 1
	  , last_update_login = null
      where attribute_id = Temp_ID;

Line: 1384

    select SYSTEM_ATTRIBUTE_TYPE
	 , ATTRIBUTE_ID
      into Temp_Type
	 , Temp_ID
      from PSB_ATTRIBUTES
     where SYSTEM_ATTRIBUTE_TYPE = 'FTE'
       and BUSINESS_GROUP_ID     = p_business_group_id;

Line: 1398

    select psb_attributes_s.nextval
      into Temp_ID
      from dual;

Line: 1402

  INSERT INTO PSB_ATTRIBUTES (
	ATTRIBUTE_ID,
	BUSINESS_GROUP_ID,
	NAME,
	DISPLAY_IN_WORKSHEET,
	DISPLAY_SEQUENCE,
	DISPLAY_PROMPT,
	REQUIRED_FOR_IMPORT_FLAG,
	REQUIRED_FOR_POSITIONS_FLAG,
	VALUE_TABLE_FLAG,
	APPLICATION_ID,
	DATA_TYPE,
	SYSTEM_ATTRIBUTE_TYPE,
	LAST_UPDATE_DATE,
	LAST_UPDATED_BY,
	LAST_UPDATE_LOGIN,
	CREATED_BY,
	CREATION_DATE,
	ALLOW_IN_POSITION_SET_FLAG)
  VALUES (
	Temp_ID,
	p_business_group_id,
	l_attribute_name,
	'Y',
	2,
	l_attribute_name,
-- Bug No 2549894 Start
--	NULL,
--	'Y',
-- Bug No 2549894 End
	'Y',
	'N',
	NULL,
	'N',
	'FTE',
	sysdate,
	1,
	NULL,
	1,
	sysdate,
	NULL
	);

Line: 1445

    INSERT INTO PSB_ATTRIBUTES_TL(
	ATTRIBUTE_ID,
	NAME,
	DISPLAY_PROMPT,
	LANGUAGE,
	SOURCE_LANG,
	LAST_UPDATE_DATE,
	LAST_UPDATED_BY,
	LAST_UPDATE_LOGIN,
	CREATED_BY,
	CREATION_DATE)
    VALUES (
	Temp_ID,
	l_attribute_name,
	l_attribute_name,
-- Bug No 2740368 Start
--	'US',
--	userenv('LANG'),
-- Bug No 2740368 End
	'US',
	sysdate,
	1,
	NULL,
	1,
	sysdate
	);

Line: 1472

     Update psb_attributes
	set definition_type   = null
	  , last_update_date  = sysdate
	  , last_updated_by   = 1
	  , last_update_login = null
      where attribute_id = Temp_ID;

Line: 1490

    select SYSTEM_ATTRIBUTE_TYPE
	 , ATTRIBUTE_ID
      into Temp_Type
	 , Temp_ID
      from PSB_ATTRIBUTES
     where SYSTEM_ATTRIBUTE_TYPE = 'ORG'
       and BUSINESS_GROUP_ID     = p_business_group_id;

Line: 1506

	 ( Select attribute_id
	     From psb_attributes
	    where upper(name) = upper(l_attribute_name)
	      and business_group_id = p_business_group_id
	 )
     Loop
	update psb_attributes
	   set name = name || '_X'
	     , last_update_date = sysdate
	     , last_updated_by  = 1
	     , last_update_login = null
	 where attribute_id = c_org_rec.attribute_id;

Line: 1519

	update psb_attributes_tl
	   set name = name || '_X'
	     , last_update_date = sysdate
	     , last_updated_by  = 1
	     , last_update_login = null
	 where attribute_id = c_org_rec.attribute_id;

Line: 1527

    select psb_attributes_s.nextval
      into Temp_ID
      from dual;

Line: 1531

  INSERT INTO PSB_ATTRIBUTES (
	ATTRIBUTE_ID,
	BUSINESS_GROUP_ID,
	NAME,
	DISPLAY_IN_WORKSHEET,
	DISPLAY_SEQUENCE,
	DISPLAY_PROMPT,
	REQUIRED_FOR_IMPORT_FLAG,
	REQUIRED_FOR_POSITIONS_FLAG,
	VALUE_TABLE_FLAG,
	APPLICATION_ID,
	DATA_TYPE,
	SYSTEM_ATTRIBUTE_TYPE,
	LAST_UPDATE_DATE,
	LAST_UPDATED_BY,
	LAST_UPDATE_LOGIN,
	CREATED_BY,
	CREATION_DATE,
	ALLOW_IN_POSITION_SET_FLAG)
  VALUES (
	Temp_ID,
	p_business_group_id,
	l_attribute_name,
	'Y',
	6,
	l_attribute_name,
	NULL,
	'Y',
	'Y',
	NULL,
	'C',
	'ORG',
	sysdate,
	1,
	NULL,
	1,
	sysdate,
-- Bug No 2549894 Start
--	NULL,
--	'Y'
-- Bug No 2549894 End
	);

Line: 1574

    INSERT INTO PSB_ATTRIBUTES_TL(
	ATTRIBUTE_ID,
	NAME,
	DISPLAY_PROMPT,
	LANGUAGE,
	SOURCE_LANG,
	LAST_UPDATE_DATE,
	LAST_UPDATED_BY,
	LAST_UPDATE_LOGIN,
	CREATED_BY,
	CREATION_DATE)
    VALUES (
	Temp_ID,
	l_attribute_name,
	l_attribute_name,
-- Bug No 2740368 Start
--	'US',
--	userenv('LANG'),
-- Bug No 2740368 End
	'US',
	sysdate,
	1,
	NULL,
	1,
	sysdate
	);

Line: 1601

     Update psb_attributes
	set definition_type   = null
	  , last_update_date  = sysdate
	  , last_updated_by   = 1
	  , last_update_login = null
      where attribute_id = Temp_ID;

Line: 1619

    select SYSTEM_ATTRIBUTE_TYPE
	 , ATTRIBUTE_ID
      into Temp_Type
	 , Temp_ID
      from PSB_ATTRIBUTES
     where SYSTEM_ATTRIBUTE_TYPE = 'HIREDATE'
       and BUSINESS_GROUP_ID     = p_business_group_id;

Line: 1633

    select psb_attributes_s.nextval
      into Temp_ID
      from dual;

Line: 1638

  INSERT INTO PSB_ATTRIBUTES (
	ATTRIBUTE_ID,
	BUSINESS_GROUP_ID,
	NAME,
	DISPLAY_IN_WORKSHEET,
	DISPLAY_SEQUENCE,
	DISPLAY_PROMPT,
	REQUIRED_FOR_IMPORT_FLAG,
	REQUIRED_FOR_POSITIONS_FLAG,
	VALUE_TABLE_FLAG,
	APPLICATION_ID,
	DATA_TYPE,
	SYSTEM_ATTRIBUTE_TYPE,
	LAST_UPDATE_DATE,
	LAST_UPDATED_BY,
	LAST_UPDATE_LOGIN,
	CREATED_BY,
	CREATION_DATE,
	ALLOW_IN_POSITION_SET_FLAG)
  VALUES (
	Temp_ID,
	p_business_group_id,
	l_attribute_name,
	NULL,
	NULL,
	l_attribute_name,
	NULL,
	NULL,
	NULL,
	NULL,
	'D',
	'HIREDATE',
	sysdate,
	1,
	NULL,
	1,
	sysdate,
	NULL
	);

Line: 1678

    INSERT INTO PSB_ATTRIBUTES_TL(
	ATTRIBUTE_ID,
	NAME,
	DISPLAY_PROMPT,
	LANGUAGE,
	SOURCE_LANG,
	LAST_UPDATE_DATE,
	LAST_UPDATED_BY,
	LAST_UPDATE_LOGIN,
	CREATED_BY,
	CREATION_DATE)
    VALUES (
	Temp_ID,
	l_attribute_name,
	l_attribute_name,
-- Bug No 2740368 Start
--	'US',
--	userenv('LANG'),
-- Bug No 2740368 End
	'US',
	sysdate,
	1,
	NULL,
	1,
	sysdate
	);

Line: 1705

     Update psb_attributes
	set definition_type   = null
	  , last_update_date  = sysdate
	  , last_updated_by   = 1
	  , last_update_login = null
      where attribute_id = Temp_ID;

Line: 1724

    select SYSTEM_ATTRIBUTE_TYPE
      into Temp_Type
      from PSB_ATTRIBUTES
     where SYSTEM_ATTRIBUTE_TYPE = 'ADJUSTMENT_DATE'
       and BUSINESS_GROUP_ID     = p_business_group_id;

Line: 1735

    select psb_attributes_s.nextval
      into Temp_ID
      from dual;

Line: 1740

  INSERT INTO PSB_ATTRIBUTES (
	ATTRIBUTE_ID,
	BUSINESS_GROUP_ID,
	NAME,
	DISPLAY_IN_WORKSHEET,
	DISPLAY_SEQUENCE,
	DISPLAY_PROMPT,
	REQUIRED_FOR_IMPORT_FLAG,
	REQUIRED_FOR_POSITIONS_FLAG,
	VALUE_TABLE_FLAG,
	APPLICATION_ID,
	DATA_TYPE,
	SYSTEM_ATTRIBUTE_TYPE,
	LAST_UPDATE_DATE,
	LAST_UPDATED_BY,
	LAST_UPDATE_LOGIN,
	CREATED_BY,
	CREATION_DATE,
	ALLOW_IN_POSITION_SET_FLAG)
  VALUES (
	Temp_ID,
	p_business_group_id,
	l_attribute_name,
	NULL,
	NULL,
	l_attribute_name,
	NULL,
	NULL,
	NULL,
	NULL,
	'D',
	'ADJUSTMENT_DATE',
	sysdate,
	1,
	NULL,
	1,
	sysdate,
	NULL
	);

Line: 1780

    INSERT INTO PSB_ATTRIBUTES_TL(
	ATTRIBUTE_ID,
	NAME,
	DISPLAY_PROMPT,
	LANGUAGE,
	SOURCE_LANG,
	LAST_UPDATE_DATE,
	LAST_UPDATED_BY,
	LAST_UPDATE_LOGIN,
	CREATED_BY,
	CREATION_DATE)
    VALUES (
	Temp_ID,
	l_attribute_name,
	l_attribute_name,
-- Bug No 2740368 Start
--	'US',
--	userenv('LANG'),
-- Bug No 2740368 End
	'US',
	sysdate,
	1,
	NULL,
	1,
	sysdate
	);

Line: 1820

    select SYSTEM_ATTRIBUTE_TYPE
	 , ATTRIBUTE_ID
      into Temp_Type
	 , Temp_ID
      from PSB_ATTRIBUTES
     where SYSTEM_ATTRIBUTE_TYPE = 'DEFAULT_WEEKLY_HOURS'
       and BUSINESS_GROUP_ID     = p_business_group_id;

Line: 1834

    select psb_attributes_s.nextval
      into Temp_ID
      from dual;

Line: 1839

  INSERT INTO PSB_ATTRIBUTES (
	ATTRIBUTE_ID,
	BUSINESS_GROUP_ID,
	NAME,
	DISPLAY_IN_WORKSHEET,
	DISPLAY_SEQUENCE,
	DISPLAY_PROMPT,
	REQUIRED_FOR_IMPORT_FLAG,
	REQUIRED_FOR_POSITIONS_FLAG,
	VALUE_TABLE_FLAG,
	APPLICATION_ID,
	DATA_TYPE,
	SYSTEM_ATTRIBUTE_TYPE,
	LAST_UPDATE_DATE,
	LAST_UPDATED_BY,
	LAST_UPDATE_LOGIN,
	CREATED_BY,
	CREATION_DATE,
	ALLOW_IN_POSITION_SET_FLAG)
  VALUES (
	Temp_ID,
	p_business_group_id,
	l_attribute_name,
	NULL,
	NULL,
	l_attribute_name,
-- Bug No 2549894 Start
--	NULL,
--	'Y',
-- Bug No 2549894 End
	NULL,
	NULL,
	NULL,
	'N',
	'DEFAULT_WEEKLY_HOURS',
	sysdate,
	1,
	NULL,
	1,
	sysdate,
	NULL
	);

Line: 1882

    INSERT INTO PSB_ATTRIBUTES_TL(
	ATTRIBUTE_ID,
	NAME,
	DISPLAY_PROMPT,
	LANGUAGE,
	SOURCE_LANG,
	LAST_UPDATE_DATE,
	LAST_UPDATED_BY,
	LAST_UPDATE_LOGIN,
	CREATED_BY,
	CREATION_DATE)
    VALUES (
	Temp_ID,
	l_attribute_name,
	l_attribute_name,
-- Bug No 2740368 Start
--	'US',
--	userenv('LANG'),
-- Bug No 2740368 End
	'US',
	sysdate,
	1,
	NULL,
	1,
	sysdate
	);

Line: 1909

     Update psb_attributes
	set definition_type   = null
	  , last_update_date  = sysdate
	  , last_updated_by   = 1
	  , last_update_login = null
      where attribute_id = Temp_ID;

Line: 1932

    ROLLBACK TO Insert_System_Attributes ;

Line: 1939

    ROLLBACK TO Insert_System_Attributes ;

Line: 1946

    ROLLBACK TO Insert_System_Attributes ;

Line: 1957

END Insert_System_Attributes ;

Line: 2003

  delete from PSB_ATTRIBUTES_TL T
  where not exists
    (select NULL
    from PSB_ATTRIBUTES B
    where B.ATTRIBUTE_ID = T.ATTRIBUTE_ID
    );

Line: 2010

  update PSB_ATTRIBUTES_TL T set (
      NAME
    ) = (select
      B.NAME
    from PSB_ATTRIBUTES_TL B
    where B.ATTRIBUTE_ID = T.ATTRIBUTE_ID
    and B.LANGUAGE = T.SOURCE_LANG)
  where (
      T.ATTRIBUTE_ID,
      T.LANGUAGE
  ) in (select
      SUBT.ATTRIBUTE_ID,
      SUBT.LANGUAGE
    from PSB_ATTRIBUTES_TL SUBB, PSB_ATTRIBUTES_TL SUBT
    where SUBB.ATTRIBUTE_ID = SUBT.ATTRIBUTE_ID
    and SUBB.LANGUAGE = SUBT.SOURCE_LANG
    and (SUBB.NAME <> SUBT.NAME
  ));

Line: 2031

   insert data for only the current session language */

  insert into PSB_ATTRIBUTES_TL (
    ATTRIBUTE_ID,
    NAME,
/* Bug No 2777757 Start */
    DISPLAY_PROMPT,
/* Bug No 2777757 End */
    LAST_UPDATE_DATE,
    LAST_UPDATED_BY,
    LAST_UPDATE_LOGIN,
    CREATED_BY,
    CREATION_DATE,
    LANGUAGE,
    SOURCE_LANG
  ) select
    B.ATTRIBUTE_ID,
    NVL(PSB_POSITION_ATTRIBUTES_PVT.get_translated_name(
                                         S.SYSTEM_ATTRIBUTE_TYPE),B.NAME),
    NVL(PSB_POSITION_ATTRIBUTES_PVT.get_translated_name(
                                   S.SYSTEM_ATTRIBUTE_TYPE),B.DISPLAY_PROMPT),
    B.LAST_UPDATE_DATE,
    B.LAST_UPDATED_BY,
    B.LAST_UPDATE_LOGIN,
    B.CREATED_BY,
    B.CREATION_DATE,
    USERENV('LANG'),
    USERENV('LANG')
  from PSB_ATTRIBUTES_TL B, FND_LANGUAGES L,PSB_ATTRIBUTES S
  where L.INSTALLED_FLAG = 'B'
  and B.LANGUAGE = L.LANGUAGE_CODE
  and S.attribute_id=B.attribute_id
  and not exists
    (select NULL
    from PSB_ATTRIBUTES_TL T
    where T.ATTRIBUTE_ID = B.ATTRIBUTE_ID
    and T.LANGUAGE = USERENV('LANG'));