APPS.AR_BPA_TEMPLATES_PKG SQL Statements

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

Line: 3

procedure INSERT_ROW (
  X_ROWID in out nocopy VARCHAR2,
  X_TEMPLATE_ID in NUMBER,
  X_REF_TEMPLATE_ID in NUMBER,
  X_PRIMARY_APP_ID in NUMBER,
  X_SECONDARY_APP_ID in NUMBER,
  X_CONTRACT_LINE_TYPE in VARCHAR2,
  X_SHOW_LINE_DETAILS_FLAG in VARCHAR2,
  X_SHOW_LINE_GROUPING_FLAG in VARCHAR2,
  X_SHOW_SEQUENCE_FLAG in VARCHAR2,
  X_SHOW_ITEMIZED_TAX_FLAG in VARCHAR2,
  X_USE_AR_TAXOPTION_FLAG in VARCHAR2,
  X_TAX_SUMMARY_GRPBY in VARCHAR2,
  X_COMPLETED_FLAG in VARCHAR2,
  X_SEEDED_FLAG in VARCHAR2,
  X_HEADER_HEIGHT in NUMBER,
  X_FOOTER_HEIGHT in NUMBER,
  X_HEADER_SHOW_TYPE in VARCHAR2,
  X_FOOTER_SHOW_TYPE in VARCHAR2,
  X_PAGE_WIDTH in NUMBER,
  X_PAGE_HEIGHT in NUMBER,
  X_TOP_MARGIN in NUMBER,
  X_BOTTOM_MARGIN in NUMBER,
  X_LEFT_MARGIN in NUMBER,
  X_RIGHT_MARGIN in NUMBER,
  X_PAGE_NUMBER_LOC in VARCHAR2,
  X_PAGE_SETUP_ID in NUMBER,
  X_SECONDARY_HEADER_HEIGHT in NUMBER,
  X_EXTERNAL_TEMPLATE_FLAG IN VARCHAR2,
  X_PRINT_LINES_FLAG IN VARCHAR2,
  X_TEMPLATE_TYPE  IN VARCHAR2,
  X_TEMPLATE_NAME in VARCHAR2,
  X_TEMPLATE_DESCRIPTION in VARCHAR2,
  X_PRINT_FONT_FAMILY in VARCHAR2,
  X_PRINT_FONT_SIZE  in VARCHAR2,
	X_TRX_CLASS  in VARCHAR2,
	X_TEMPLATE_FORMAT  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 AR_BPA_TEMPLATES_B
    where TEMPLATE_ID = X_TEMPLATE_ID
    ;

Line: 50

  insert into AR_BPA_TEMPLATES_B (
    TEMPLATE_ID,
    REF_TEMPLATE_ID,
    PRIMARY_APP_ID,
    SECONDARY_APP_ID,
    CONTRACT_LINE_TYPE,
    SHOW_LINE_DETAILS_FLAG,
    SHOW_LINE_GROUPING_FLAG,
    SHOW_SEQUENCE_FLAG,
    SHOW_ITEMIZED_TAX_FLAG,
    USE_AR_TAXOPTION_FLAG,
    TAX_SUMMARY_GRPBY,
    COMPLETED_FLAG,
    SEEDED_FLAG,
    HEADER_HEIGHT,
    FOOTER_HEIGHT,
    HEADER_SHOW_TYPE,
    FOOTER_SHOW_TYPE,
    PAGE_WIDTH,
    PAGE_HEIGHT,
    TOP_MARGIN,
    BOTTOM_MARGIN,
    LEFT_MARGIN,
    RIGHT_MARGIN,
    PAGE_NUMBER_LOC,
    PAGE_SETUP_ID,
    SECONDARY_HEADER_HEIGHT,
    EXTERNAL_TEMPLATE_FLAG,
    PRINT_LINES_FLAG,
    TEMPLATE_TYPE,
    PRINT_FONT_FAMILY,
    PRINT_FONT_SIZE,
    TRX_CLASS,
		TEMPLATE_FORMAT,
    CREATION_DATE,
    CREATED_BY,
    LAST_UPDATE_DATE,
    LAST_UPDATED_BY,
    LAST_UPDATE_LOGIN
  ) values (
    X_TEMPLATE_ID,
    X_REF_TEMPLATE_ID,
    X_PRIMARY_APP_ID,
    X_SECONDARY_APP_ID,
    X_CONTRACT_LINE_TYPE,
    X_SHOW_LINE_DETAILS_FLAG,
    X_SHOW_LINE_GROUPING_FLAG,
    X_SHOW_SEQUENCE_FLAG,
    X_SHOW_ITEMIZED_TAX_FLAG,
    X_USE_AR_TAXOPTION_FLAG,
    X_TAX_SUMMARY_GRPBY,
    X_COMPLETED_FLAG,
    X_SEEDED_FLAG,
    X_HEADER_HEIGHT,
    X_FOOTER_HEIGHT,
    X_HEADER_SHOW_TYPE,
    X_FOOTER_SHOW_TYPE,
    X_PAGE_WIDTH,
    X_PAGE_HEIGHT,
    X_TOP_MARGIN,
    X_BOTTOM_MARGIN,
    X_LEFT_MARGIN,
    X_RIGHT_MARGIN,
    X_PAGE_NUMBER_LOC,
    X_PAGE_SETUP_ID,
    X_SECONDARY_HEADER_HEIGHT,
    X_EXTERNAL_TEMPLATE_FLAG,
    X_PRINT_LINES_FLAG,
    X_TEMPLATE_TYPE,
    X_PRINT_FONT_FAMILY,
    X_PRINT_FONT_SIZE,
    X_TRX_CLASS,
		X_TEMPLATE_FORMAT,
    X_CREATION_DATE,
    X_CREATED_BY,
    X_LAST_UPDATE_DATE,
    X_LAST_UPDATED_BY,
    X_LAST_UPDATE_LOGIN
  );

Line: 130

  insert into AR_BPA_TEMPLATES_TL (
    TEMPLATE_ID,
    TEMPLATE_NAME,
    TEMPLATE_DESCRIPTION,
    CREATED_BY,
    CREATION_DATE,
    LAST_UPDATED_BY,
    LAST_UPDATE_DATE,
    LAST_UPDATE_LOGIN,
    LANGUAGE,
    SOURCE_LANG
  ) select
    X_TEMPLATE_ID,
    X_TEMPLATE_NAME,
    X_TEMPLATE_DESCRIPTION,
    X_CREATED_BY,
    X_CREATION_DATE,
    X_LAST_UPDATED_BY,
    X_LAST_UPDATE_DATE,
    X_LAST_UPDATE_LOGIN,
    L.LANGUAGE_CODE,
    userenv('LANG')
  from FND_LANGUAGES L
  where L.INSTALLED_FLAG in ('I', 'B')
  and not exists
    (select NULL
    from AR_BPA_TEMPLATES_TL T
    where T.TEMPLATE_ID = X_TEMPLATE_ID
    and T.LANGUAGE = L.LANGUAGE_CODE);

Line: 168

end INSERT_ROW;

Line: 207

  cursor c is select
      REF_TEMPLATE_ID,
      PRIMARY_APP_ID,
      SECONDARY_APP_ID,
      CONTRACT_LINE_TYPE,
      SHOW_LINE_DETAILS_FLAG,
      SHOW_LINE_GROUPING_FLAG,
      SHOW_SEQUENCE_FLAG,
      SHOW_ITEMIZED_TAX_FLAG,
      USE_AR_TAXOPTION_FLAG,
      TAX_SUMMARY_GRPBY,
      COMPLETED_FLAG,
      SEEDED_FLAG,
      HEADER_HEIGHT,
      FOOTER_HEIGHT,
      HEADER_SHOW_TYPE,
      FOOTER_SHOW_TYPE,
      PAGE_WIDTH,
      PAGE_HEIGHT,
      TOP_MARGIN,
      BOTTOM_MARGIN,
      LEFT_MARGIN,
      RIGHT_MARGIN,
      PAGE_NUMBER_LOC,
      PAGE_SETUP_ID,
      SECONDARY_HEADER_HEIGHT,
      EXTERNAL_TEMPLATE_FLAG,
      PRINT_LINES_FLAG,
      TEMPLATE_TYPE,
      PRINT_FONT_FAMILY,
      PRINT_FONT_SIZE,
      TRX_CLASS,
      TEMPLATE_FORMAT
    from AR_BPA_TEMPLATES_B
    where TEMPLATE_ID = X_TEMPLATE_ID
    for update of TEMPLATE_ID nowait;

Line: 245

  cursor c1 is select
      TEMPLATE_NAME,
      TEMPLATE_DESCRIPTION,
      decode(LANGUAGE, userenv('LANG'), 'Y', 'N') BASELANG
    from AR_BPA_TEMPLATES_TL
    where TEMPLATE_ID = X_TEMPLATE_ID
    and userenv('LANG') in (LANGUAGE, SOURCE_LANG)
    for update of TEMPLATE_ID nowait;

Line: 258

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

Line: 348

procedure UPDATE_ROW (
  X_TEMPLATE_ID in NUMBER,
  X_REF_TEMPLATE_ID in NUMBER,
  X_PRIMARY_APP_ID in NUMBER,
  X_SECONDARY_APP_ID in NUMBER,
  X_CONTRACT_LINE_TYPE in VARCHAR2,
  X_SHOW_LINE_DETAILS_FLAG in VARCHAR2,
  X_SHOW_LINE_GROUPING_FLAG in VARCHAR2,
  X_SHOW_SEQUENCE_FLAG in VARCHAR2,
  X_SHOW_ITEMIZED_TAX_FLAG in VARCHAR2,
  X_USE_AR_TAXOPTION_FLAG in VARCHAR2,
  X_TAX_SUMMARY_GRPBY in VARCHAR2,
  X_COMPLETED_FLAG in VARCHAR2,
  X_SEEDED_FLAG in VARCHAR2,
  X_HEADER_HEIGHT in NUMBER,
  X_FOOTER_HEIGHT in NUMBER,
  X_HEADER_SHOW_TYPE in VARCHAR2,
  X_FOOTER_SHOW_TYPE in VARCHAR2,
  X_PAGE_WIDTH in NUMBER,
  X_PAGE_HEIGHT in NUMBER,
  X_TOP_MARGIN in NUMBER,
  X_BOTTOM_MARGIN in NUMBER,
  X_LEFT_MARGIN in NUMBER,
  X_RIGHT_MARGIN in NUMBER,
  X_PAGE_NUMBER_LOC in VARCHAR2,
  X_PAGE_SETUP_ID in NUMBER,
  X_SECONDARY_HEADER_HEIGHT in NUMBER,
  X_EXTERNAL_TEMPLATE_FLAG IN VARCHAR2,
  X_PRINT_LINES_FLAG IN VARCHAR2,
  X_TEMPLATE_TYPE  IN VARCHAR2,
  X_TEMPLATE_NAME in VARCHAR2,
  X_TEMPLATE_DESCRIPTION in VARCHAR2,
  X_PRINT_FONT_FAMILY in VARCHAR2,
  X_PRINT_FONT_SIZE in VARCHAR2,
  X_TRX_CLASS in VARCHAR2,
  X_TEMPLATE_FORMAT in VARCHAR2,
  X_LAST_UPDATE_DATE in DATE,
  X_LAST_UPDATED_BY in NUMBER,
  X_LAST_UPDATE_LOGIN in NUMBER
) is
begin
  update AR_BPA_TEMPLATES_B set
    REF_TEMPLATE_ID = X_REF_TEMPLATE_ID,
    PRIMARY_APP_ID = X_PRIMARY_APP_ID,
    SECONDARY_APP_ID = X_SECONDARY_APP_ID,
    CONTRACT_LINE_TYPE = X_CONTRACT_LINE_TYPE,
    SHOW_LINE_DETAILS_FLAG = X_SHOW_LINE_DETAILS_FLAG,
    SHOW_LINE_GROUPING_FLAG = X_SHOW_LINE_GROUPING_FLAG,
    SHOW_SEQUENCE_FLAG = X_SHOW_SEQUENCE_FLAG,
    SHOW_ITEMIZED_TAX_FLAG = X_SHOW_ITEMIZED_TAX_FLAG,
    USE_AR_TAXOPTION_FLAG = X_USE_AR_TAXOPTION_FLAG,
    TAX_SUMMARY_GRPBY = X_TAX_SUMMARY_GRPBY,
    COMPLETED_FLAG = X_COMPLETED_FLAG,
    SEEDED_FLAG = X_SEEDED_FLAG,
    HEADER_HEIGHT = X_HEADER_HEIGHT,
    FOOTER_HEIGHT = X_FOOTER_HEIGHT,
    HEADER_SHOW_TYPE = X_HEADER_SHOW_TYPE,
    FOOTER_SHOW_TYPE = X_FOOTER_SHOW_TYPE,
    PAGE_WIDTH = X_PAGE_WIDTH,
    PAGE_HEIGHT = X_PAGE_HEIGHT,
    TOP_MARGIN = X_TOP_MARGIN,
    BOTTOM_MARGIN = X_BOTTOM_MARGIN,
    LEFT_MARGIN = X_LEFT_MARGIN,
    RIGHT_MARGIN = X_RIGHT_MARGIN,
    PAGE_NUMBER_LOC = X_PAGE_NUMBER_LOC,
    PAGE_SETUP_ID = X_PAGE_SETUP_ID,
    SECONDARY_HEADER_HEIGHT = X_SECONDARY_HEADER_HEIGHT,
    EXTERNAL_TEMPLATE_FLAG = X_EXTERNAL_TEMPLATE_FLAG,
    PRINT_LINES_FLAG = X_PRINT_LINES_FLAG ,
    TEMPLATE_TYPE  = X_TEMPLATE_TYPE,
    PRINT_FONT_FAMILY = X_PRINT_FONT_FAMILY,
    PRINT_FONT_SIZE = X_PRINT_FONT_SIZE,
    TRX_CLASS = X_TRX_CLASS,
    TEMPLATE_FORMAT = X_TEMPLATE_FORMAT,
    LAST_UPDATE_DATE = X_LAST_UPDATE_DATE,
    LAST_UPDATED_BY = X_LAST_UPDATED_BY,
    LAST_UPDATE_LOGIN = X_LAST_UPDATE_LOGIN
  where TEMPLATE_ID = X_TEMPLATE_ID;

Line: 431

  update AR_BPA_TEMPLATES_TL set
    TEMPLATE_NAME = X_TEMPLATE_NAME,
    TEMPLATE_DESCRIPTION = X_TEMPLATE_DESCRIPTION,
    LAST_UPDATE_DATE = X_LAST_UPDATE_DATE,
    LAST_UPDATED_BY = X_LAST_UPDATED_BY,
    LAST_UPDATE_LOGIN = X_LAST_UPDATE_LOGIN,
    SOURCE_LANG = userenv('LANG')
  where TEMPLATE_ID = X_TEMPLATE_ID
  and userenv('LANG') in (LANGUAGE, SOURCE_LANG);

Line: 444

end UPDATE_ROW;

Line: 446

procedure DELETE_ROW (
  X_TEMPLATE_ID in NUMBER
) is
begin

  /* First delete from content areas. Used by UI while deleting template to speed
     up content area deletion. In any case without a template, it's content areas (detail)
     mustn't exist
  */
  delete from AR_BPA_CONTENT_AREAS_TL
  where content_area_id in (select content_area_id from ar_bpa_content_areas_b
                               where template_id = X_TEMPLATE_ID);

Line: 459

  delete from AR_BPA_CONTENT_AREAS_B
  where TEMPLATE_ID = X_TEMPLATE_ID;

Line: 462

  delete from AR_BPA_AREA_ITEMS
  where TEMPLATE_ID = X_TEMPLATE_ID;

Line: 465

  delete from AR_BPA_TEMPLATE_FILES
  where TEMPLATE_ID = X_TEMPLATE_ID;

Line: 468

  delete from AR_BPA_TEMPLATE_FIELDS
  where TEMPLATE_ID = X_TEMPLATE_ID;

Line: 471

  delete from AR_BPA_TEMPLATES_TL
  where TEMPLATE_ID = X_TEMPLATE_ID;

Line: 478

  delete from AR_BPA_TEMPLATES_B
  where TEMPLATE_ID = X_TEMPLATE_ID;

Line: 484

end DELETE_ROW;

Line: 489

  delete from AR_BPA_TEMPLATES_TL T
  where not exists
    (select NULL
    from AR_BPA_TEMPLATES_B B
    where B.TEMPLATE_ID = T.TEMPLATE_ID
    );

Line: 496

  update AR_BPA_TEMPLATES_TL T set (
      TEMPLATE_NAME,
      TEMPLATE_DESCRIPTION
    ) = (select
      B.TEMPLATE_NAME,
      B.TEMPLATE_DESCRIPTION
    from AR_BPA_TEMPLATES_TL B
    where B.TEMPLATE_ID = T.TEMPLATE_ID
    and B.LANGUAGE = T.SOURCE_LANG)
  where (
      T.TEMPLATE_ID,
      T.LANGUAGE
  ) in (select
      SUBT.TEMPLATE_ID,
      SUBT.LANGUAGE
    from AR_BPA_TEMPLATES_TL SUBB, AR_BPA_TEMPLATES_TL SUBT
    where SUBB.TEMPLATE_ID = SUBT.TEMPLATE_ID
    and SUBB.LANGUAGE = SUBT.SOURCE_LANG
    and (SUBB.TEMPLATE_NAME <> SUBT.TEMPLATE_NAME
      or SUBB.TEMPLATE_DESCRIPTION <> SUBT.TEMPLATE_DESCRIPTION
      or (SUBB.TEMPLATE_DESCRIPTION is null and SUBT.TEMPLATE_DESCRIPTION is not null)
      or (SUBB.TEMPLATE_DESCRIPTION is not null and SUBT.TEMPLATE_DESCRIPTION is null)
  ));

Line: 520

  insert into AR_BPA_TEMPLATES_TL (
    TEMPLATE_ID,
    TEMPLATE_NAME,
    TEMPLATE_DESCRIPTION,
    CREATED_BY,
    CREATION_DATE,
    LAST_UPDATED_BY,
    LAST_UPDATE_DATE,
    LAST_UPDATE_LOGIN,
    LANGUAGE,
    SOURCE_LANG
  ) select /*+ ORDERED */
    B.TEMPLATE_ID,
    B.TEMPLATE_NAME,
    B.TEMPLATE_DESCRIPTION,
    B.CREATED_BY,
    B.CREATION_DATE,
    B.LAST_UPDATED_BY,
    B.LAST_UPDATE_DATE,
    B.LAST_UPDATE_LOGIN,
    L.LANGUAGE_CODE,
    B.SOURCE_LANG
  from AR_BPA_TEMPLATES_TL B, FND_LANGUAGES L
  where L.INSTALLED_FLAG in ('I', 'B')
  and B.LANGUAGE = userenv('LANG')
  and not exists
    (select NULL
    from AR_BPA_TEMPLATES_TL T
    where T.TEMPLATE_ID = B.TEMPLATE_ID
    and T.LANGUAGE = L.LANGUAGE_CODE);

Line: 599

    AR_BPA_TEMPLATES_PKG.UPDATE_ROW (
		X_TEMPLATE_ID 			=> X_TEMPLATE_ID,
		X_REF_TEMPLATE_ID 		=> X_REF_TEMPLATE_ID,
		X_PRIMARY_APP_ID 		=> X_PRIMARY_APP_ID,
		X_SECONDARY_APP_ID 		=> X_SECONDARY_APP_ID,
		X_CONTRACT_LINE_TYPE 		=> X_CONTRACT_LINE_TYPE,
		X_SHOW_LINE_DETAILS_FLAG 	=> X_SHOW_LINE_DETAILS_FLAG,
		X_SHOW_LINE_GROUPING_FLAG 	=> X_SHOW_LINE_GROUPING_FLAG,
		X_SHOW_SEQUENCE_FLAG 		=> X_SHOW_SEQUENCE_FLAG,
		X_SHOW_ITEMIZED_TAX_FLAG 	=> X_SHOW_ITEMIZED_TAX_FLAG,
		X_USE_AR_TAXOPTION_FLAG 	=> X_USE_AR_TAXOPTION_FLAG,
		X_TAX_SUMMARY_GRPBY 		=> X_TAX_SUMMARY_GRPBY,
		X_COMPLETED_FLAG 		=> X_COMPLETED_FLAG,
		X_SEEDED_FLAG 			=> X_SEEDED_FLAG,
		X_TEMPLATE_NAME 		=> X_TEMPLATE_NAME,
		X_TEMPLATE_DESCRIPTION 	=> X_TEMPLATE_DESCRIPTION,
    	      X_HEADER_HEIGHT                  	=>  X_HEADER_HEIGHT                  ,
	      X_FOOTER_HEIGHT                  	=>  X_FOOTER_HEIGHT                  ,
	      X_HEADER_SHOW_TYPE               	=>  X_HEADER_SHOW_TYPE               ,
	      X_FOOTER_SHOW_TYPE               	=>  X_FOOTER_SHOW_TYPE               ,
	      X_PAGE_WIDTH                     	=>  X_PAGE_WIDTH                     ,
	      X_PAGE_HEIGHT                    	=>  X_PAGE_HEIGHT                    ,
	      X_TOP_MARGIN                     	=>  X_TOP_MARGIN                     ,
	      X_BOTTOM_MARGIN                  	=>  X_BOTTOM_MARGIN                  ,
	      X_LEFT_MARGIN                    	=>  X_LEFT_MARGIN                    ,
	      X_RIGHT_MARGIN                   	=>  X_RIGHT_MARGIN                   ,
	      X_PAGE_NUMBER_LOC                	=>  X_PAGE_NUMBER_LOC                ,
	      X_PAGE_SETUP_ID                  	=>  X_PAGE_SETUP_ID                  ,
	      X_SECONDARY_HEADER_HEIGHT        	=>  X_SECONDARY_HEADER_HEIGHT        ,
            X_EXTERNAL_TEMPLATE_FLAG            =>  X_EXTERNAL_TEMPLATE_FLAG  ,
            X_PRINT_LINES_FLAG               =>  X_PRINT_LINES_FLAG ,
            X_TEMPLATE_TYPE                     =>  X_TEMPLATE_TYPE ,
		X_PRINT_FONT_FAMILY                 =>  X_PRINT_FONT_FAMILY,
            X_PRINT_FONT_SIZE                   =>  X_PRINT_FONT_SIZE,
            X_TRX_CLASS => X_TRX_CLASS,
            X_TEMPLATE_FORMAT => X_TEMPLATE_FORMAT,
		X_LAST_UPDATE_DATE 	=> sysdate,
		X_LAST_UPDATED_BY 	=> user_id,
		X_LAST_UPDATE_LOGIN 	=> 0);

Line: 640

           AR_BPA_TEMPLATES_PKG.INSERT_ROW (
  		X_ROWID 			=> row_id,
		X_TEMPLATE_ID 			=> X_TEMPLATE_ID,
		X_REF_TEMPLATE_ID 		=> X_REF_TEMPLATE_ID,
		X_PRIMARY_APP_ID 		=> X_PRIMARY_APP_ID,
		X_SECONDARY_APP_ID 		=> X_SECONDARY_APP_ID,
		X_CONTRACT_LINE_TYPE 		=> X_CONTRACT_LINE_TYPE,
		X_SHOW_LINE_DETAILS_FLAG 	=> X_SHOW_LINE_DETAILS_FLAG,
		X_SHOW_LINE_GROUPING_FLAG 	=> X_SHOW_LINE_GROUPING_FLAG,
		X_SHOW_SEQUENCE_FLAG 		=> X_SHOW_SEQUENCE_FLAG,
		X_SHOW_ITEMIZED_TAX_FLAG 	=> X_SHOW_ITEMIZED_TAX_FLAG,
		X_USE_AR_TAXOPTION_FLAG 	=> X_USE_AR_TAXOPTION_FLAG,
		X_TAX_SUMMARY_GRPBY 		=> X_TAX_SUMMARY_GRPBY,
		X_COMPLETED_FLAG 		=> X_COMPLETED_FLAG,
		X_SEEDED_FLAG 			=> X_SEEDED_FLAG,
		X_TEMPLATE_NAME 		=> X_TEMPLATE_NAME,
		X_TEMPLATE_DESCRIPTION 		=> X_TEMPLATE_DESCRIPTION,
    	      X_HEADER_HEIGHT                  	=>  X_HEADER_HEIGHT                  ,
	      X_FOOTER_HEIGHT                  	=>  X_FOOTER_HEIGHT                  ,
	      X_HEADER_SHOW_TYPE               	=>  X_HEADER_SHOW_TYPE               ,
	      X_FOOTER_SHOW_TYPE               	=>  X_FOOTER_SHOW_TYPE               ,
	      X_PAGE_WIDTH                     	=>  X_PAGE_WIDTH                     ,
	      X_PAGE_HEIGHT                    	=>  X_PAGE_HEIGHT                    ,
	      X_TOP_MARGIN                     	=>  X_TOP_MARGIN                     ,
	      X_BOTTOM_MARGIN                  	=>  X_BOTTOM_MARGIN                  ,
	      X_LEFT_MARGIN                    	=>  X_LEFT_MARGIN                    ,
	      X_RIGHT_MARGIN                   	=>  X_RIGHT_MARGIN                   ,
	      X_PAGE_NUMBER_LOC                	=>  X_PAGE_NUMBER_LOC                ,
	      X_PAGE_SETUP_ID                  	=>  X_PAGE_SETUP_ID                  ,
	      X_SECONDARY_HEADER_HEIGHT        	=>  X_SECONDARY_HEADER_HEIGHT        ,
            X_EXTERNAL_TEMPLATE_FLAG            =>  X_EXTERNAL_TEMPLATE_FLAG  ,
            X_PRINT_LINES_FLAG               =>  X_PRINT_LINES_FLAG ,
            X_TEMPLATE_TYPE                     =>  X_TEMPLATE_TYPE ,
		X_PRINT_FONT_FAMILY                 =>  X_PRINT_FONT_FAMILY,
            X_PRINT_FONT_SIZE                   =>  X_PRINT_FONT_SIZE,
            X_TRX_CLASS => X_TRX_CLASS,
            X_TEMPLATE_FORMAT => X_TEMPLATE_FORMAT,
		X_CREATION_DATE 	=> sysdate,
                X_CREATED_BY 		=> user_id,
                X_LAST_UPDATE_DATE 	=> sysdate,
                X_LAST_UPDATED_BY 	=> user_id,
                X_LAST_UPDATE_LOGIN 	=> 0);

Line: 692

    update AR_BPA_TEMPLATES_TL
      set TEMPLATE_NAME = X_TEMPLATE_NAME,
          TEMPLATE_DESCRIPTION = X_TEMPLATE_DESCRIPTION,
          source_lang = userenv('LANG'),
          last_update_date = sysdate,
          last_updated_by = decode(X_OWNER, 'SEED', 1, 0),
          last_update_login = 0
    where template_id = X_TEMPLATE_ID
    and   userenv('LANG') in (language, source_lang);