APPS.PSB_FLEX_MAPPING_PVT SQL Statements

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

Line: 11

 |                       PROCEDURE Insert_Row                            |
 +=======================================================================*/

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_Flex_Mapping_Set_ID       IN       NUMBER,
  p_Flex_Mapping_Value_ID     IN       NUMBER,
  p_Budget_Year_Type_ID       IN       NUMBER,
  p_Application_Column_Name   IN       VARCHAR2,
  p_Flex_Value_Set_ID         IN       NUMBER,
  p_Flex_Value_ID             IN       NUMBER,
  p_From_Flex_Value_ID        IN       NUMBER,

  p_mode                      in varchar2

)
IS

  CURSOR C IS
    SELECT rowid
    FROM   psb_flex_mapping_set_values
    WHERE  flex_mapping_value_id = p_flex_mapping_value_id ;

Line: 44

    P_LAST_UPDATE_DATE DATE;

Line: 45

    P_LAST_UPDATED_BY NUMBER;

Line: 46

    P_LAST_UPDATE_LOGIN NUMBER;

Line: 49

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

Line: 55

  SAVEPOINT Insert_Row_Pvt ;

Line: 72

  P_LAST_UPDATE_DATE := SYSDATE;

Line: 74

    P_LAST_UPDATED_BY := 1;

Line: 75

    P_LAST_UPDATE_LOGIN := 0;

Line: 77

    P_LAST_UPDATED_BY := FND_GLOBAL.USER_ID;

Line: 78

    if P_LAST_UPDATED_BY is NULL then
      P_LAST_UPDATED_BY := -1;

Line: 81

    P_LAST_UPDATE_LOGIN :=FND_GLOBAL.LOGIN_ID;

Line: 82

    if P_LAST_UPDATE_LOGIN is NULL then
      P_LAST_UPDATE_LOGIN := -1;

Line: 92

  INSERT INTO psb_flex_mapping_set_values
	 (    flex_mapping_set_id,
	      flex_mapping_value_id,
	      budget_year_type_id,
	      application_column_name,
	      flex_value_set_id,
	      flex_value_id ,
	      from_flex_value_id ,
	      creation_date,
	      created_by,
	      last_update_date,
	      last_updated_by,
	      last_update_login
	 )
	 VALUES
	 (    p_flex_mapping_set_id,
	      p_flex_mapping_value_id,
	      p_budget_year_type_id,
	      p_application_column_name,
	      p_flex_value_set_id,
	      p_flex_value_id  ,
	      p_from_flex_value_id  ,
	      p_last_update_date,
	      p_last_updated_by,
	      p_last_update_date,
	      p_last_updated_by,
	      p_last_update_login


	 );

Line: 143

    ROLLBACK TO Insert_Row_Pvt ;

Line: 150

    ROLLBACK TO Insert_Row_Pvt ;

Line: 157

    ROLLBACK TO Insert_Row_Pvt ;

Line: 168

END Insert_Row;

Line: 206

       SELECT Flex_Mapping_Set_ID,
	      Flex_Mapping_Value_ID,
	      Budget_Year_Type_ID ,
	      Application_Column_Name,
	      Flex_Value_Set_ID,
	      Flex_Value_ID,
	      From_Flex_Value_ID
       FROM   psb_flex_mapping_set_values
       WHERE  Flex_Mapping_Value_ID = p_Flex_Mapping_Value_ID
       FOR UPDATE of Flex_Mapping_Value_ID NOWAIT;

Line: 243

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

Line: 326

 |                       PROCEDURE Update_Row                               |
 +==========================================================================*/

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_Flex_Mapping_Set_ID       IN       NUMBER,
  p_Flex_Mapping_Value_ID     IN       NUMBER,
  p_Budget_Year_Type_ID       IN       NUMBER,
  p_Application_Column_Name   IN       VARCHAR2,
  p_Flex_Value_Set_ID         IN      NUMBER,
  p_Flex_Value_ID             IN       NUMBER,
  p_From_Flex_Value_ID        IN       NUMBER,
  --
  p_mode        in varchar2

)
IS
    P_LAST_UPDATE_DATE DATE;

Line: 352

    P_LAST_UPDATED_BY NUMBER;

Line: 353

    P_LAST_UPDATE_LOGIN NUMBER;

Line: 355

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

Line: 361

  SAVEPOINT Update_Row_Pvt ;

Line: 379

  P_LAST_UPDATE_DATE := SYSDATE;

Line: 381

    P_LAST_UPDATED_BY := 1;

Line: 382

    P_LAST_UPDATE_LOGIN := 0;

Line: 384

    P_LAST_UPDATED_BY := FND_GLOBAL.USER_ID;

Line: 385

    if P_LAST_UPDATED_BY is NULL then
      P_LAST_UPDATED_BY := -1;

Line: 388

    P_LAST_UPDATE_LOGIN :=FND_GLOBAL.LOGIN_ID;

Line: 389

    if P_LAST_UPDATE_LOGIN is NULL then
      P_LAST_UPDATE_LOGIN := -1;

Line: 398

  UPDATE psb_flex_mapping_set_values
  SET
	Flex_Mapping_Set_ID   =  p_Flex_Mapping_Set_ID,
	Flex_Mapping_Value_ID        =  p_Flex_Mapping_Value_ID      ,
	Budget_Year_Type_ID        = p_Budget_Year_Type_ID            ,
	Application_Column_Name = p_Application_Column_Name  ,
	Flex_Value_Set_ID          = p_Flex_Value_Set_ID              ,
	Flex_Value_ID   = p_Flex_Value_ID ,
	From_Flex_Value_ID   = p_From_Flex_Value_ID ,
	last_update_date = p_last_update_date,
	last_updated_by = p_last_updated_by,
	last_update_login = p_last_update_login
  WHERE Flex_Mapping_Value_ID = p_Flex_Mapping_Value_ID;

Line: 432

    ROLLBACK TO Update_Row_Pvt ;

Line: 439

    ROLLBACK TO Update_Row_Pvt ;

Line: 446

    ROLLBACK TO Update_Row_Pvt ;

Line: 457

END Update_Row;

Line: 464

 |                       PROCEDURE Delete_Row                               |
 +==========================================================================*/

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_Flex_Mapping_Value_ID     IN       NUMBER
)
IS
  --
  l_api_name            CONSTANT VARCHAR2(30)   := 'Delete_Row';

Line: 486

  SAVEPOINT Delete_Row_Pvt ;

Line: 507

  DELETE psb_flex_mapping_set_values
  WHERE  Flex_Mapping_Value_ID  = p_Flex_Mapping_Value_ID;

Line: 526

    ROLLBACK TO Delete_Row_Pvt ;

Line: 533

    ROLLBACK TO Delete_Row_Pvt ;

Line: 540

    ROLLBACK TO Delete_Row_Pvt ;

Line: 551

END Delete_Row;

Line: 561

PROCEDURE Sets_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_Flex_Mapping_Set_ID       IN       NUMBER,
  p_Name                      IN       VARCHAR2,
  p_Description               IN       VARCHAR2,
  p_set_of_books_id           IN       NUMBER,
  --
  p_mode                      in varchar2

)
IS

  CURSOR C IS
    SELECT rowid
    FROM   psb_flex_mapping_sets
    WHERE  Flex_Mapping_Set_ID = p_Flex_Mapping_Set_ID ;

Line: 587

    P_LAST_UPDATE_DATE DATE;

Line: 588

    P_LAST_UPDATED_BY NUMBER;

Line: 589

    P_LAST_UPDATE_LOGIN NUMBER;

Line: 591

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

Line: 598

  SAVEPOINT Sets_Insert_Row_Pvt ;

Line: 615

  P_LAST_UPDATE_DATE := SYSDATE;

Line: 617

    P_LAST_UPDATED_BY := 1;

Line: 618

    P_LAST_UPDATE_LOGIN := 0;

Line: 620

    P_LAST_UPDATED_BY := FND_GLOBAL.USER_ID;

Line: 621

    if P_LAST_UPDATED_BY is NULL then
      P_LAST_UPDATED_BY := -1;

Line: 624

    P_LAST_UPDATE_LOGIN :=FND_GLOBAL.LOGIN_ID;

Line: 625

    if P_LAST_UPDATE_LOGIN is NULL then
      P_LAST_UPDATE_LOGIN := -1;

Line: 635

  INSERT INTO psb_flex_mapping_sets
	 (    Flex_Mapping_Set_ID ,
	      Name,
	      Description,
	      set_of_books_id,
	      creation_date,
	      created_by,
	      last_update_date,
	      last_updated_by,
	      last_update_login
	 )
	 VALUES
	 (    p_Flex_Mapping_Set_ID,
	      p_Name,
	      p_Description,
	      p_Set_of_Books_ID,
	      p_last_update_date,
	      p_last_updated_by,
	      p_last_update_date,
	      p_last_updated_by,
	      p_last_update_login

	 );

Line: 679

    ROLLBACK TO Sets_Insert_Row_Pvt ;

Line: 686

    ROLLBACK TO Sets_Insert_Row_Pvt ;

Line: 693

    ROLLBACK TO Sets_Insert_Row_Pvt ;

Line: 704

END Sets_Insert_Row;

Line: 706

 |                       PROCEDURE Delete_Row                               |
 +==========================================================================*/

PROCEDURE Sets_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_Flex_Mapping_Set_ID       IN       NUMBER
)
IS
  --
  l_api_name            CONSTANT VARCHAR2(30)   := 'Delete_Row';

Line: 729

  SAVEPOINT Sets_Delete_Row_Pvt ;

Line: 746

  DELETE psb_flex_mapping_set_values
    WHERE  flex_mapping_set_id   = p_flex_mapping_set_id ;

Line: 749

  DELETE psb_flex_mapping_sets
    WHERE flex_mapping_set_id  = p_flex_mapping_set_id;

Line: 768

    ROLLBACK TO Sets_Delete_Row_Pvt ;

Line: 775

    ROLLBACK TO Sets_Delete_Row_Pvt ;

Line: 782

    ROLLBACK TO Sets_Delete_Row_Pvt ;

Line: 793

END Sets_Delete_Row;

Line: 825

       SELECT Flex_Mapping_Set_ID,
	      Name,
	      description ,
	      set_of_books_id
       FROM   psb_flex_mapping_sets
       WHERE  Flex_Mapping_Set_Id = p_Flex_Mapping_Set_Id
       FOR UPDATE of Flex_Mapping_Set_Id NOWAIT;

Line: 859

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

Line: 927

 |                       PROCEDURE Update_Row                               |
 +==========================================================================*/

PROCEDURE Sets_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_Flex_Mapping_Set_ID       IN       NUMBER,
  p_Name                      IN       VARCHAR2,
  p_Description               IN       VARCHAR2,
  p_set_of_books_id           IN       NUMBER,

  --
  p_mode        in varchar2

)
IS
    P_LAST_UPDATE_DATE DATE;

Line: 951

    P_LAST_UPDATED_BY NUMBER;

Line: 952

    P_LAST_UPDATE_LOGIN NUMBER;

Line: 954

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

Line: 960

  SAVEPOINT Update_Row_Pvt ;

Line: 978

  P_LAST_UPDATE_DATE := SYSDATE;

Line: 980

    P_LAST_UPDATED_BY := 1;

Line: 981

    P_LAST_UPDATE_LOGIN := 0;

Line: 983

    P_LAST_UPDATED_BY := FND_GLOBAL.USER_ID;

Line: 984

    if P_LAST_UPDATED_BY is NULL then
      P_LAST_UPDATED_BY := -1;

Line: 987

    P_LAST_UPDATE_LOGIN :=FND_GLOBAL.LOGIN_ID;

Line: 988

    if P_LAST_UPDATE_LOGIN is NULL then
      P_LAST_UPDATE_LOGIN := -1;

Line: 997

  UPDATE psb_flex_mapping_sets
  SET
	Flex_Mapping_Set_ID   =  p_Flex_Mapping_Set_ID,
	Name                  =  p_Name      ,
	Description           = p_Description            ,
	Set_of_Books_ID       = p_Set_of_Books_ID  ,
	last_update_date      = p_last_update_date,
	last_updated_by       = p_last_updated_by,
	last_update_login     = p_last_update_login
  WHERE Flex_Mapping_Set_ID   = p_Flex_Mapping_Set_ID;

Line: 1028

    ROLLBACK TO Update_Row_Pvt ;

Line: 1035

    ROLLBACK TO Update_Row_Pvt ;

Line: 1042

    ROLLBACK TO Update_Row_Pvt ;

Line: 1053

END Sets_Update_Row;

Line: 1092

     SELECT s.chart_of_accounts_id
       FROM psb_flex_mapping_sets   f,
	    gl_sets_of_books    s
      WHERE flex_mapping_set_id = p_flexfield_mapping_set_id AND
	    f.set_of_books_id = s.set_of_books_id ;

Line: 1103

    select fval.flex_value to_val ,
	   fromval.flex_value from_val
      from fnd_flex_values_vl fval,
	   fnd_flex_values_vl fromval,
	   psb_flex_mapping_set_values map,
	   fnd_id_flex_segments seg
     where flex_mapping_set_id =  p_flexfield_mapping_set_id
       and budget_year_type_id = p_budget_year_type_id
       and map.flex_value_id = fval.flex_value_id(+)
       and map.from_flex_value_id = fromval.flex_value_id
       and seg.application_id = 101
       and seg.id_flex_code = 'GL#'
       and seg.id_flex_num = l_flex_code
       and seg.enabled_flag = 'Y'
       and seg.application_column_name = map.application_column_name
       and map.application_column_name = g_seg_name(l_segment_num)
       and ( fval.flex_value is  null
       or  fromval.flex_value =  l_seg_val(l_segment_num)  )
       order by fromval.flex_value

      ;

Line: 1133

    select fval.flex_value from_val , seg.application_column_name
      from fnd_flex_values_vl fval,
	   psb_flex_mapping_set_values map,
	   fnd_id_flex_segments seg
     where flex_mapping_set_id = p_flexfield_mapping_set_id
       and budget_year_type_id = l_cy_budget_year_type_id
       and map.from_flex_value_id = fval.flex_value_id
       and seg.application_id = 101
       and seg.id_flex_code = 'GL#'
       and seg.id_flex_num = l_flex_code
       and seg.enabled_flag = 'Y'
       and seg.application_column_name = map.application_column_name ;

Line: 1147

    select fval.flex_value curr_val
      from fnd_flex_values_vl fval,
	   psb_flex_mapping_set_values map,
	   fnd_id_flex_segments seg
     where flex_mapping_set_id = p_flexfield_mapping_set_id
       and budget_year_type_id = l_cy_budget_year_type_id
       and map.from_flex_value_id = fval.flex_value_id
       and seg.application_id = 101
       and seg.id_flex_code = 'GL#'
       and seg.id_flex_num = l_flex_code
       and seg.enabled_flag = 'Y'
       and seg.application_column_name = map.application_column_name
       and map.application_column_name = g_seg_name(l_segment_num)
     ;

Line: 1163

    select fval.flex_value curr_val
      from fnd_flex_values_vl fval,
	   psb_flex_mapping_set_values map,
	   fnd_id_flex_segments seg
     where flex_mapping_set_id = p_flexfield_mapping_set_id
       and budget_year_type_id = l_py_budget_year_type_id
       and map.from_flex_value_id = fval.flex_value_id
       and seg.application_id = 101
       and seg.id_flex_code = 'GL#'
       and seg.id_flex_num = l_flex_code
       and seg.enabled_flag = 'Y'
       and seg.application_column_name = map.application_column_name
       and map.application_column_name = g_seg_name(l_segment_num)
     ;

Line: 1179

    select budget_year_type_id
      from psb_budget_year_types_vl
     where year_category_type = 'CY';

Line: 1184

    select budget_year_type_id
      from psb_budget_year_types_vl y
     where year_category_type = 'PY'
       and budget_year_type_id = p_budget_year_type_id
  ;

Line: 1429

     SELECT s.chart_of_accounts_id,fnd.concatenated_segment_delimiter
       FROM psb_flex_mapping_sets   f,
	    gl_sets_of_books    s,
	    fnd_id_flex_structures_vl fnd
      WHERE flex_mapping_set_id = p_flexfield_mapping_set_id AND
	    f.set_of_books_id = s.set_of_books_id AND
	    s.chart_of_accounts_id = fnd.id_flex_num AND
	    application_id = 101 AND
	    id_flex_code = 'GL#'

      ;

Line: 1447

    select fval.flex_value to_val ,
	   fromval.flex_value from_val
      from fnd_flex_values_vl fval,
	   fnd_flex_values_vl fromval,
	   psb_flex_mapping_set_values map,
	   fnd_id_flex_segments seg
     where flex_mapping_set_id =  p_flexfield_mapping_set_id
       and budget_year_type_id = p_budget_year_type_id
       and map.flex_value_id = fval.flex_value_id(+)
       and map.from_flex_value_id = fromval.flex_value_id
       and seg.application_id = 101
       and seg.id_flex_code = 'GL#'
       and seg.id_flex_num = l_flex_code
       and seg.enabled_flag = 'Y'
       and seg.application_column_name = map.application_column_name
       and map.application_column_name = g_seg_name(l_segment_num)
       and ( fval.flex_value is  null
       or  fromval.flex_value =  l_seg_val(l_segment_num)  )
       order by fromval.flex_value

      ;

Line: 1476

    select fval.flex_value curr_val
      from fnd_flex_values_vl fval,
	   psb_flex_mapping_set_values map,
	   fnd_id_flex_segments seg
     where flex_mapping_set_id = p_flexfield_mapping_set_id
       and budget_year_type_id = l_cy_budget_year_type_id
       and map.from_flex_value_id = fval.flex_value_id
       and seg.application_id = 101
       and seg.id_flex_code = 'GL#'
       and seg.id_flex_num = l_flex_code
       and seg.enabled_flag = 'Y'
       and seg.application_column_name = map.application_column_name
       and map.application_column_name = g_seg_name(l_segment_num)
     ;

Line: 1493

    select budget_year_type_id
      from psb_budget_year_types_vl
     where year_category_type = 'CY'
   ;

Line: 1499

    select 'Exists'
      from dual
     where exists
	  (select 1
      from psb_budget_year_types_vl
     where budget_year_type_id = p_Budget_Year_Type_ID
       and year_category_type = 'PY'
	  );

Line: 1671

    select application_column_name,segment_num
      from fnd_id_flex_segments
     where application_id = 101
       and id_flex_code = 'GL#'
       and id_flex_num = p_flex_code
       and enabled_flag = 'Y'
     order by segment_num;