DBA Data[Home] [Help]

APPS.PA_PAGE_TYPE_REGION_PKG SQL Statements

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

Line: 5

procedure INSERT_PAGE_TYPE_REGION_ROW (
  P_PAGE_TYPE_CODE in VARCHAR2,
  P_REGION_SOURCE_TYPE in VARCHAR2,
  P_REGION_SOURCE_CODE in VARCHAR2,

  P_VIEW_REGION_CODE in VARCHAR2,
  P_EDIT_REGION_CODE in VARCHAR2,
  P_REGION_STYLE in VARCHAR2,
  P_DISPLAY_ORDER in NUMBER,
  P_MANDATORY_FLAG in VARCHAR2,

  P_DEFAULT_REGION_POSITION in VARCHAR2,
  P_PLACEHOLDER_REGION_FLAG in VARCHAR2,
  P_START_DATE_ACTIVE in DATE,
  P_END_DATE_ACTIVE in DATE,
  P_DOCUMENT_SOURCE in VARCHAR2,
  P_PAGE_FUNCTION_NAME in VARCHAR2,
  P_SECURITY_FUNCTION_NAME in VARCHAR2
)
  IS

   l_row_id ROWID;
Line: 29

      SELECT rowid
	FROM   pa_page_type_regions
	WHERE  page_type_code = p_page_type_code
	AND region_source_type = p_region_source_type
	AND region_source_code = p_region_source_code;
Line: 37

  insert into PA_PAGE_TYPE_REGIONS (
				    PAGE_TYPE_CODE,
				    VIEW_REGION_CODE,
				    EDIT_REGION_CODE,
				    DISPLAY_ORDER,
				    MANDATORY_FLAG,
				    LAST_UPDATED_BY,
				    CREATED_BY ,
				    CREATION_DATE ,
				    LAST_UPDATE_DATE ,
				    LAST_UPDATE_LOGIN ,
				    DEFAULT_REGION_POSITION ,
				    PLACEHOLDER_REGION_FLAG ,
  				    REGION_SOURCE_TYPE,
				    REGION_SOURCE_CODE,
				    region_style,
				    START_DATE_ACTIVE ,
				    end_date_active,
				    DOCUMENT_SOURCE,
                                    page_function_name,
                                    security_function_name)
				    VALUES
				    (
				     P_PAGE_TYPE_CODE,
				     P_VIEW_REGION_CODE,
				     P_EDIT_REGION_CODE,
				     P_DISPLAY_ORDER,
				     P_MANDATORY_FLAG,

				     fnd_global.user_id,
				     fnd_global.user_id,
				     sysdate,
				     sysdate,
				     fnd_global.user_id,

				     P_DEFAULT_REGION_POSITION ,
				     P_PLACEHOLDER_REGION_FLAG ,
				     P_REGION_SOURCE_TYPE,
				     P_REGION_SOURCE_CODE,
				     P_region_style,
				     Nvl(p_start_date_active, Sysdate) ,
				     p_end_date_active,
				     P_DOCUMENT_SOURCE,
                                     p_page_function_name,
                                     p_security_function_name);
Line: 98

end INSERT_PAGE_TYPE_REGION_ROW;
Line: 101

procedure UPDATE_PAGE_TYPE_REGION_ROW (
  P_PAGE_TYPE_CODE in VARCHAR2,
  P_REGION_SOURCE_TYPE in VARCHAR2,
  P_REGION_SOURCE_CODE in VARCHAR2,

  P_VIEW_REGION_CODE in VARCHAR2,
  P_EDIT_REGION_CODE in VARCHAR2,
  P_REGION_STYLE in VARCHAR2,
  P_DISPLAY_ORDER in NUMBER,
  P_MANDATORY_FLAG in VARCHAR2,

  P_DEFAULT_REGION_POSITION in VARCHAR2,
  P_PLACEHOLDER_REGION_FLAG in VARCHAR2,
  P_START_DATE_ACTIVE in DATE,
  P_END_DATE_ACTIVE in DATE,
  p_document_source IN varchar2,
  p_page_function_name IN varchar2,
  p_security_function_name IN varchar2)
  IS

   l_row_id ROWID;
Line: 124

      SELECT rowid
	FROM   pa_page_type_regions
	WHERE  page_type_code = p_page_type_code
	AND region_source_type = p_region_source_type
	AND region_source_code = p_region_source_code;
Line: 132

  UPDATE PA_PAGE_TYPE_REGIONS SET
    view_region_code = P_VIEW_REGION_CODE,
    edit_region_code = P_EDIT_REGION_CODE,
    display_order = Decode(p_display_order, 1.7e20, display_order, p_display_order),
    mandatory_flag = Decode(p_mandatory_flag, '^', mandatory_flag,p_mandatory_flag ),
    default_region_position = Decode(p_default_region_position,'^', default_region_position, p_default_region_position ) ,
    placeholder_region_flag = Decode(p_placeholder_region_flag,'^', placeholder_region_flag, p_placeholder_region_flag ) ,
    region_style = Decode(P_region_style, '^', region_style, p_region_style),
    start_date_active = P_START_DATE_ACTIVE ,
    end_date_active = p_end_date_active,
    LAST_UPDATED_BY =  fnd_global.user_id,
    LAST_UPDATE_DATE = sysdate,
    LAST_UPDATE_LOGIN = fnd_global.login_id,
    document_source = p_document_source,
    page_function_name = p_page_function_name,
    security_function_name = p_security_function_name
    WHERE
    page_type_code = p_page_type_code
    AND region_source_type = p_region_source_type
    AND region_source_code = p_region_source_code;
Line: 167

end UPDATE_PAGE_TYPE_REGION_ROW;
Line: 170

procedure delete_page_type_REGION_ROW (
				       p_rowid IN VARCHAR2 := NULL,
				       P_PAGE_TYPE_CODE in VARCHAR2 := NULL ,
				       P_REGION_SOURCE_TYPE in VARCHAR2 := NULL ,
				       P_REGION_SOURCE_CODE in VARCHAR2  := NULL
) is
BEGIN

   IF p_rowid IS NOT NULL THEN
 delete from PA_PAGE_TYPE_REGIONS
    where rowid = p_rowid;
Line: 183

  delete from PA_PAGE_TYPE_REGIONS
    where PAGE_TYPE_CODE = p_page_type_code
    AND region_source_type = p_region_source_type
    AND region_source_code = p_region_source_code;
Line: 196

end DELETE_PAGE_TYPE_REGION_ROW;