APPS.EDW_FLEX_SEG_MAPPING_LINES_PKG SQL Statements

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

Line: 3

procedure INSERT_ROW (
  X_ROWID in out VARCHAR2,
  X_SEG_MAPPING_LINE_ID in NUMBER,
  X_INSTANCE_CODE in VARCHAR2,
  X_STRUCTURE_NUM in NUMBER,
  X_STRUCTURE_NAME in VARCHAR2,
  X_VALUE_SET_ID in NUMBER,
  X_SEGMENT_NAME in VARCHAR2,
  X_APPLICATION_ID in NUMBER,
  X_ID_FLEX_CODE in VARCHAR2,
  X_APPLICATION_COLUMN_NAME in VARCHAR2,
  X_DIMENSION_ID in NUMBER,
  X_LEVEL_ID  in NUMBER,
  X_WH_DIMENSION_NAME in VARCHAR2,
  X_CREATION_DATE in DATE,
  X_CREATED_BY in NUMBER,
  X_LAST_UPDATE_DATE in DATE,
  X_LAST_UPDATED_BY in NUMBER,
  X_LAST_UPDATE_LOGIN in NUMBER
) is

 cursor C is select ROWID from BIS_FLEX_SEG_MAPPING_LINES
    where seg_mapping_line_id = X_seg_mapping_line_id;

Line: 29

  insert into BIS_FLEX_SEG_MAPPING_LINES (
    SEG_MAPPING_LINE_ID,
    INSTANCE_CODE,
    STRUCTURE_NUM,
    STRUCTURE_NAME,
    VALUE_SET_ID,
    SEGMENT_NAME,
    APPLICATION_ID,
    ID_FLEX_CODE,
    APPLICATION_COLUMN_NAME,
    DIMENSION_ID,
    LEVEL_ID,
    WH_DIMENSION_NAME,
    CREATION_DATE,
    CREATED_BY,
    LAST_UPDATE_DATE,
    LAST_UPDATED_BY,
    LAST_UPDATE_LOGIN
  ) values (
    X_SEG_MAPPING_LINE_ID,
    X_INSTANCE_CODE,
    X_STRUCTURE_NUM,
    X_STRUCTURE_NAME,
    X_VALUE_SET_ID,
    X_SEGMENT_NAME,
    X_APPLICATION_ID,
    X_ID_FLEX_CODE,
    X_APPLICATION_COLUMN_NAME,
    X_DIMENSION_ID ,
    X_LEVEL_ID  ,
    X_WH_DIMENSION_NAME ,
    X_CREATION_DATE,
    X_CREATED_BY,
    X_LAST_UPDATE_DATE,
    X_LAST_UPDATED_BY,
    X_LAST_UPDATE_LOGIN
  );

Line: 77

end INSERT_ROW;

Line: 93

  cursor c is select
      INSTANCE_CODE,
      STRUCTURE_NUM,
      STRUCTURE_NAME,
      VALUE_SET_ID,
      SEGMENT_NAME,
      APPLICATION_ID,
      ID_FLEX_CODE,
      DIMENSION_ID,
      LEVEL_ID,
      WH_DIMENSION_NAME
    from BIS_FLEX_SEG_MAPPING_LINES
    where seg_mapping_line_id = X_seg_mapping_line_id
    for update of SEG_MAPPING_LINE_ID nowait;

Line: 114

    fnd_message.set_name('FND', 'FORM_RECORD_DELETED');

Line: 138

procedure UPDATE_ROW (
  X_SEG_MAPPING_LINE_ID in NUMBER,
  X_INSTANCE_CODE in VARCHAR2,
  X_STRUCTURE_NUM in NUMBER,
  X_STRUCTURE_NAME in VARCHAR2,
  X_VALUE_SET_ID in NUMBER,
  X_SEGMENT_NAME in VARCHAR2,
  X_APPLICATION_ID in NUMBER,
  X_ID_FLEX_CODE in VARCHAR2,
  X_APPLICATION_COLUMN_NAME in VARCHAR2,
  X_DIMENSION_ID in NUMBER,
  X_LEVEL_ID  in NUMBER,
  X_WH_DIMENSION_NAME in VARCHAR2,
  X_LAST_UPDATE_DATE in DATE,
  X_LAST_UPDATED_BY in NUMBER,
  X_LAST_UPDATE_LOGIN in NUMBER
) is
begin
  update BIS_FLEX_SEG_MAPPING_LINES set
    INSTANCE_CODE = X_INSTANCE_CODE,
    STRUCTURE_NUM = X_STRUCTURE_NUM,
    STRUCTURE_NAME = X_STRUCTURE_NAME,
    VALUE_SET_ID = X_VALUE_SET_ID,
    SEGMENT_NAME = X_SEGMENT_NAME,
    APPLICATION_ID = X_APPLICATION_ID,
    ID_FLEX_CODE = X_ID_FLEX_CODE,
    LAST_UPDATE_DATE = X_LAST_UPDATE_DATE,
    LAST_UPDATED_BY = X_LAST_UPDATED_BY,
    LAST_UPDATE_LOGIN = X_LAST_UPDATE_LOGIN,
    APPLICATION_COLUMN_NAME = X_APPLICATION_COLUMN_NAME,
    DIMENSION_ID	 = X_DIMENSION_ID,
    LEVEL_ID		 = X_LEVEL_ID,
    WH_DIMENSION_NAME    = X_WH_DIMENSION_NAME
    where seg_mapping_line_id = X_seg_mapping_line_id;

Line: 179

end UPDATE_ROW;

Line: 181

procedure DELETE_ROW (
  X_SEG_MAPPING_LINE_ID in NUMBER
) is
begin
  delete from BIS_FLEX_SEG_MAPPING_LINES
    where seg_mapping_line_id = X_seg_mapping_line_id;

Line: 192

end DELETE_ROW;