DBA Data[Home] [Help]

APPS.GL_CONS_SEGMENT_ACTIONS_PKG SQL Statements

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

Line: 4

PROCEDURE Insert_Row(X_Rowid                        IN OUT NOCOPY VARCHAR2,
                     X_Segment_Map_Id               IN OUT NOCOPY NUMBER,
                     X_Coa_Mapping_Id                      NUMBER,
                     X_Last_Update_Date                    DATE,
                     X_Last_Updated_By                     NUMBER,
                     X_To_Value_Set_Id                     NUMBER,
                     X_To_Application_Column_Name          VARCHAR2,
                     X_Segment_Map_Type                    VARCHAR2,
                     X_Creation_Date                       DATE,
                     X_Created_By                          NUMBER,
                     X_Last_Update_Login                   NUMBER,
                     X_From_Value_Set_Id                   NUMBER,
                     X_From_Application_Column_Name        VARCHAR2,
                     X_Single_Value                        VARCHAR2,
                     X_Attribute1                          VARCHAR2,
                     X_Attribute2                          VARCHAR2,
                     X_Attribute3                          VARCHAR2,
                     X_Attribute4                          VARCHAR2,
                     X_Attribute5                          VARCHAR2,
                     X_Context                             VARCHAR2,
                     X_Parent_Rollup_Value                 VARCHAR2
 ) IS
   CURSOR C IS SELECT rowid FROM gl_cons_segment_map

             WHERE segment_map_id = X_Segment_Map_Id;
Line: 30

    CURSOR C2 IS SELECT gl_cons_segment_map_s.nextval FROM dual;
Line: 38

  INSERT INTO gl_cons_segment_map(
          segment_map_id,
          coa_mapping_id,
          last_update_date,
          last_updated_by,
          to_value_set_id,
          to_application_column_name,
          segment_map_type,
          creation_date,
          created_by,
          last_update_login,
          from_value_set_id,
          from_application_column_name,
          single_value,
          attribute1,
          attribute2,
          attribute3,
          attribute4,
          attribute5,
          context,
	  parent_rollup_value
         ) VALUES (
          X_Segment_Map_Id,
          X_Coa_Mapping_Id,
          X_Last_Update_Date,
          X_Last_Updated_By,
          X_To_Value_Set_Id,
          X_To_Application_Column_Name,
          X_Segment_Map_Type,
          X_Creation_Date,
          X_Created_By,
          X_Last_Update_Login,
          X_From_Value_Set_Id,
          X_From_Application_Column_Name,
          X_Single_Value,
          X_Attribute1,
          X_Attribute2,
          X_Attribute3,
          X_Attribute4,
          X_Attribute5,
          X_Context,
	  X_Parent_Rollup_Value
  );
Line: 89

END Insert_Row;
Line: 95

      SELECT *
      FROM   gl_cons_segment_map
      WHERE  rowid = X_Rowid
      FOR UPDATE of Segment_Map_Id NOWAIT;
Line: 120

PROCEDURE Update_Row(X_Rowid                               VARCHAR2,
                     X_Segment_Map_Id                      NUMBER,
                     X_Coa_Mapping_Id                      NUMBER,
                     X_Last_Update_Date                    DATE,
                     X_Last_Updated_By                     NUMBER,
                     X_To_Value_Set_Id                     NUMBER,
                     X_To_Application_Column_Name          VARCHAR2,
                     X_Segment_Map_Type                    VARCHAR2,
                     X_Last_Update_Login                   NUMBER,
                     X_From_Value_Set_Id                   NUMBER,
                     X_From_Application_Column_Name        VARCHAR2,
                     X_Single_Value                        VARCHAR2,
		     X_attribute1                          VARCHAR2,
		     X_attribute2                          VARCHAR2,
		     X_attribute3                          VARCHAR2,
		     X_attribute4                          VARCHAR2,
		     X_attribute5                          VARCHAR2,
		     X_context                             VARCHAR2,
		     X_parent_rollup_value                 VARCHAR2
) IS
BEGIN

  UPDATE gl_cons_segment_map
  SET
    segment_map_id                            =    X_Segment_Map_Id,
    coa_mapping_id                            =    X_Coa_Mapping_Id,
    last_update_date                          =    X_Last_Update_Date,
    last_updated_by                           =    X_Last_Updated_By,
    to_value_set_id                           =    X_To_Value_Set_Id,
    to_application_column_name                =    X_To_Application_Column_Name,
    segment_map_type                          =    X_Segment_Map_Type,
    last_update_login                         =    X_Last_Update_Login,
    from_value_set_id                         =    X_From_Value_Set_Id,
    from_application_column_name              =    X_From_Application_Column_Name,
    single_value                              =    X_Single_Value,
    attribute1                                =    X_Attribute1,
    attribute2                                =    X_Attribute2,
    attribute3                                =    X_Attribute3,
    attribute4                                =    X_Attribute4,
    attribute5                                =    X_Attribute5,
    context                                   =    X_Context,
    parent_rollup_value                       =    X_Parent_Rollup_Value
  WHERE rowid = X_rowid;
Line: 168

END Update_Row;
Line: 170

PROCEDURE Delete_Row(X_Coa_Mapping_Id NUMBER, X_to_application_column_name VARCHAR2 ) IS
BEGIN

  DELETE FROM GL_CONS_FLEX_HIERARCHIES
  WHERE SEGMENT_MAP_ID IN ( SELECT segment_map_id
			  FROM   GL_CONS_SEGMENT_MAP
			  WHERE  coa_mapping_id = X_Coa_Mapping_id
			  AND    to_application_column_name = X_to_application_column_name
                        );
Line: 180

  DELETE FROM gl_cons_segment_map
  WHERE  coa_mapping_id = X_Coa_Mapping_Id
  AND    to_application_column_name = X_to_application_column_name;
Line: 187

END Delete_Row;
Line: 199

  select 'x' from gl_cons_segment_map
  where  coa_mapping_id = X_Coa_Mapping_id
  and    to_application_column_name = X_To_Application_Column_Name
  and    to_value_set_id = X_To_Value_Set_Id
  and    segment_map_type in ('S', 'C')
  and    (rowid <> X_Rowid OR X_Rowid is NULL);
Line: 207

   select 'x' from gl_cons_segment_map
   where  coa_mapping_id = X_Coa_Mapping_id
   and    to_application_column_name = X_To_Application_Column_Name
   and    to_value_set_id = X_To_Value_Set_Id
   and    segment_map_type NOT IN ('S', 'C')
   and    (rowid <> X_Rowid OR X_Rowid is NULL);
Line: 215

  select 'x' from gl_cons_segment_map
  where  coa_mapping_id = X_Coa_Mapping_id
  and    to_application_column_name = X_To_Application_Column_Name
  and    to_value_set_id = X_To_Value_Set_Id
  and    single_value = X_Single_Value
  and    from_application_column_name = X_from_Application_Column_Name
  and    from_value_set_id = X_From_Value_Set_Id
  and    parent_rollup_value = X_Parent_Rollup_Value
  and    segment_map_type = 'P'
  and    (rowid <> X_Rowid OR X_Rowid is NULL);
Line: 270

  SELECT validation_type
  FROM   fnd_flex_value_sets
  WHERE  flex_value_set_id = X_To_Value_Set_Id;
Line: 300

  SELECT maximum_size
  INTO from_vs_max_size
  FROM FND_FLEX_VALUE_SETS
  WHERE flex_value_set_id = X_from_value_set_id;
Line: 305

  SELECT maximum_size
  INTO to_vs_max_size
  FROM FND_FLEX_VALUE_SETS
  WHERE flex_value_set_id = X_to_value_set_id;