eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PO_DIFF_CONFIG_PKG SQL Statements

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

Line: 4


PROCEDURE INSERT_ROW (
  P_DIFF_CONFIG_ID          IN NUMBER,
  P_DOCUMENT_TYPE           IN VARCHAR2,
  P_ENTITY_NAME             IN VARCHAR2,
  P_SUB_ENTITY_NAME         IN VARCHAR2,
  P_BASE_DOC_SOURCE_NAME    IN VARCHAR2,
  P_MOD_DOC_SOURCE_NAME     IN VARCHAR2,
  P_COLUMN_NAME             IN VARCHAR2,
  P_CMP_FILTER_PRED_FLAG    IN VARCHAR2,
  P_IS_PRINTABLE_FLAG       IN VARCHAR2,
  P_ROLLUP_ELIGIBILITY_FLAG IN VARCHAR2,
  P_DISPLAY_SEQ_NUMBER      IN NUMBER,
  P_DISP_DATA_TYPE          IN VARCHAR2,
  P_LABEL_MESSAGE_CODE      IN VARCHAR2,
  P_IGNORE_SOURCE_FLAG      IN VARCHAR2,
  P_CREATION_DATE           IN DATE,
  P_CREATED_BY              IN NUMBER,
  P_LAST_UPDATE_DATE        IN DATE,
  P_LAST_UPDATED_BY         IN NUMBER,
  P_LAST_UPDATE_LOGIN		IN NUMBER
 ) is
 begin

 insert into PO_DIFF_CONFIG(
			DIFF_CONFIG_ID,
			DOCUMENT_TYPE,
			ENTITY_NAME,
			SUB_ENTITY_NAME,
			BASE_DOC_SOURCE_NAME,
			MOD_DOC_SOURCE_NAME,
			COLUMN_NAME,
			CMP_FILTER_PRED_FLAG,
			IS_PRINTABLE_FLAG,
			ROLLUP_ELIGIBILITY_FLAG,
			DISPLAY_SEQ_NUMBER,
			DISP_DATA_TYPE,
			LABEL_MESSAGE_CODE,
			IGNORE_SOURCE_FLAG,
			CREATION_DATE,
			CREATED_BY,
			LAST_UPDATE_DATE,
			LAST_UPDATED_BY,
			LAST_UPDATE_LOGIN)
values(
		P_DIFF_CONFIG_ID,
		P_DOCUMENT_TYPE,
		P_ENTITY_NAME,
		P_SUB_ENTITY_NAME,
		P_BASE_DOC_SOURCE_NAME,
		P_MOD_DOC_SOURCE_NAME,
		P_COLUMN_NAME,
		P_CMP_FILTER_PRED_FLAG,
		P_IS_PRINTABLE_FLAG,
		P_ROLLUP_ELIGIBILITY_FLAG,
		P_DISPLAY_SEQ_NUMBER,
		P_DISP_DATA_TYPE,
		P_LABEL_MESSAGE_CODE,
		P_IGNORE_SOURCE_FLAG,
		P_CREATION_DATE,
		P_CREATED_BY,
		P_LAST_UPDATE_DATE,
		P_LAST_UPDATED_BY,
		P_LAST_UPDATE_LOGIN);

Line: 70


			'Row cannot be inserted - ' || 'DIFF_CONFIG_ID = ' || P_DIFF_CONFIG_ID);

Line: 73


PROCEDURE UPDATE_ROW(
  P_DIFF_CONFIG_ID          IN NUMBER,
  P_DOCUMENT_TYPE           IN VARCHAR2,
  P_ENTITY_NAME             IN VARCHAR2,
  P_SUB_ENTITY_NAME         IN VARCHAR2,
  P_BASE_DOC_SOURCE_NAME    IN VARCHAR2,
  P_MOD_DOC_SOURCE_NAME     IN VARCHAR2,
  P_COLUMN_NAME             IN VARCHAR2,
  P_CMP_FILTER_PRED_FLAG    IN VARCHAR2,
  P_IS_PRINTABLE_FLAG       IN VARCHAR2,
  P_ROLLUP_ELIGIBILITY_FLAG IN VARCHAR2,
  P_DISPLAY_SEQ_NUMBER      IN NUMBER,
  P_DISP_DATA_TYPE          IN VARCHAR2,
  P_LABEL_MESSAGE_CODE      IN VARCHAR2,
  P_IGNORE_SOURCE_FLAG      IN VARCHAR2,
  P_LAST_UPDATE_DATE        IN DATE,
  P_LAST_UPDATED_BY         IN NUMBER,
  P_LAST_UPDATE_LOGIN		IN NUMBER
) is
begin
	update PO_DIFF_CONFIG set
		DOCUMENT_TYPE = P_DOCUMENT_TYPE,
		ENTITY_NAME = P_ENTITY_NAME,
		SUB_ENTITY_NAME = P_SUB_ENTITY_NAME,
		BASE_DOC_SOURCE_NAME = P_BASE_DOC_SOURCE_NAME,
		MOD_DOC_SOURCE_NAME = P_MOD_DOC_SOURCE_NAME,
		COLUMN_NAME = P_COLUMN_NAME,
		CMP_FILTER_PRED_FLAG = P_CMP_FILTER_PRED_FLAG,
		IS_PRINTABLE_FLAG = P_IS_PRINTABLE_FLAG,
		ROLLUP_ELIGIBILITY_FLAG = P_ROLLUP_ELIGIBILITY_FLAG,
		DISPLAY_SEQ_NUMBER = P_DISPLAY_SEQ_NUMBER,
		DISP_DATA_TYPE = P_DISP_DATA_TYPE,
		LABEL_MESSAGE_CODE = P_LABEL_MESSAGE_CODE,
		LAST_UPDATE_DATE = P_LAST_UPDATE_DATE,
		LAST_UPDATED_BY = P_LAST_UPDATED_BY,
		LAST_UPDATE_LOGIN = P_LAST_UPDATE_LOGIN
	where DIFF_CONFIG_ID = P_DIFF_CONFIG_ID;

Line: 114


			'Row cannot be updated - ' || 'DIFF_CONFIG_ID = ' || P_DIFF_CONFIG_ID);

Line: 117


PROCEDURE FORCE_UPDATE_ROW(
  P_DIFF_CONFIG_ID          IN NUMBER,
  P_DOCUMENT_TYPE           IN VARCHAR2,
  P_ENTITY_NAME             IN VARCHAR2,
  P_SUB_ENTITY_NAME         IN VARCHAR2,
  P_BASE_DOC_SOURCE_NAME    IN VARCHAR2,
  P_MOD_DOC_SOURCE_NAME     IN VARCHAR2,
  P_COLUMN_NAME             IN VARCHAR2,
  P_CMP_FILTER_PRED_FLAG    IN VARCHAR2,
  P_IS_PRINTABLE_FLAG       IN VARCHAR2,
  P_ROLLUP_ELIGIBILITY_FLAG IN VARCHAR2,
  P_DISPLAY_SEQ_NUMBER      IN NUMBER,
  P_DISP_DATA_TYPE          IN VARCHAR2,
  P_LABEL_MESSAGE_CODE      IN VARCHAR2,
  P_IGNORE_SOURCE_FLAG      IN VARCHAR2,
  P_LAST_UPDATE_DATE        IN DATE,
  P_LAST_UPDATED_BY         IN NUMBER,
  P_LAST_UPDATE_LOGIN		IN NUMBER
) is
begin
	update PO_DIFF_CONFIG set
		DOCUMENT_TYPE = P_DOCUMENT_TYPE,
		ENTITY_NAME = P_ENTITY_NAME,
		SUB_ENTITY_NAME = P_SUB_ENTITY_NAME,
		BASE_DOC_SOURCE_NAME = P_BASE_DOC_SOURCE_NAME,
		MOD_DOC_SOURCE_NAME = P_MOD_DOC_SOURCE_NAME,
		COLUMN_NAME = P_COLUMN_NAME,
		CMP_FILTER_PRED_FLAG = P_CMP_FILTER_PRED_FLAG,
		IS_PRINTABLE_FLAG = P_IS_PRINTABLE_FLAG,
		ROLLUP_ELIGIBILITY_FLAG = P_ROLLUP_ELIGIBILITY_FLAG,
		IGNORE_SOURCE_FLAG = P_IGNORE_SOURCE_FLAG,
		DISPLAY_SEQ_NUMBER = P_DISPLAY_SEQ_NUMBER,
		DISP_DATA_TYPE = P_DISP_DATA_TYPE,
		LABEL_MESSAGE_CODE = P_LABEL_MESSAGE_CODE,
		LAST_UPDATE_DATE = P_LAST_UPDATE_DATE,
		LAST_UPDATED_BY = P_LAST_UPDATED_BY,
		LAST_UPDATE_LOGIN = P_LAST_UPDATE_LOGIN
	where DIFF_CONFIG_ID = P_DIFF_CONFIG_ID;

Line: 159


			'Row cannot be updated - ' || 'DIFF_CONFIG_ID = ' || P_DIFF_CONFIG_ID);

Line: 165


  L_LAST_UPDATE_DATE		IN VARCHAR2,
  L_DOCUMENT_TYPE           IN VARCHAR2,
  L_ENTITY_NAME             IN VARCHAR2,
  L_MOD_DOC_SOURCE_NAME     IN VARCHAR2,
  L_COLUMN_NAME             IN VARCHAR2,
  L_BASE_DOC_SOURCE_NAME    IN VARCHAR2,
  L_SUB_ENTITY_NAME         IN VARCHAR2,
  L_CMP_FILTER_PRED_FLAG    IN VARCHAR2,
  L_IS_PRINTABLE_FLAG       IN VARCHAR2,
  L_ROLLUP_ELIGIBILITY_FLAG IN VARCHAR2,
  L_DISPLAY_SEQ_NUMBER      IN NUMBER,
  L_DISP_DATA_TYPE          IN VARCHAR2,
  L_LABEL_MESSAGE_CODE      IN VARCHAR2,
  L_IGNORE_SOURCE_FLAG      IN VARCHAR2,
  L_CUSTOM_MODE				IN VARCHAR2
 ) is
  F_LUBY     NUMBER; -- entity owner in file

Line: 182


  F_LUDATE   DATE; -- entity update in file

Line: 184


  DB_LUDATE  DATE; -- entity update in db

Line: 190


    F_LUDATE := NVL(TO_DATE(L_LAST_UPDATE_DATE,'YYYY/MM/DD'), SYSDATE);

Line: 192


  /* If the record already exists within the 10000 limit of the seeded data and no personilisation, update it. Else Insert the new record */

	begin
		SELECT LAST_UPDATED_BY,
			   LAST_UPDATE_DATE
		INTO   DB_LUBY,
			   DB_LUDATE
		FROM PO_DIFF_CONFIG
		WHERE DIFF_CONFIG_ID = L_DIFF_CONFIG_ID
		and DIFF_CONFIG_ID < 10000;

Line: 209


				/* this will update all columns including ignore_source_flag */
				PO_DIFF_CONFIG_PKG.FORCE_UPDATE_ROW(
					  P_DIFF_CONFIG_ID       => L_DIFF_CONFIG_ID,
					  P_DOCUMENT_TYPE        => L_DOCUMENT_TYPE,
					  P_ENTITY_NAME          => L_ENTITY_NAME,
					  P_SUB_ENTITY_NAME      => L_SUB_ENTITY_NAME,
					  P_BASE_DOC_SOURCE_NAME  => L_BASE_DOC_SOURCE_NAME,
					  P_MOD_DOC_SOURCE_NAME   => L_MOD_DOC_SOURCE_NAME,
					  P_COLUMN_NAME           => L_COLUMN_NAME,
					  P_CMP_FILTER_PRED_FLAG  => L_CMP_FILTER_PRED_FLAG,
					  P_IS_PRINTABLE_FLAG      => L_IS_PRINTABLE_FLAG,
					  P_ROLLUP_ELIGIBILITY_FLAG => L_ROLLUP_ELIGIBILITY_FLAG,
					  P_DISPLAY_SEQ_NUMBER      => L_DISPLAY_SEQ_NUMBER,
					  P_DISP_DATA_TYPE          => L_DISP_DATA_TYPE,
					  P_LABEL_MESSAGE_CODE      => L_LABEL_MESSAGE_CODE,
					  P_IGNORE_SOURCE_FLAG      => p_ignore_source_flag,
					  P_LAST_UPDATE_DATE        => sysdate,
					  P_LAST_UPDATED_BY         => F_LUBY,
					  P_LAST_UPDATE_LOGIN		=> 0
					  );

Line: 230


			/* UPDATE If the the record found with the above criteria  */
				PO_DIFF_CONFIG_PKG.UPDATE_ROW(
					  P_DIFF_CONFIG_ID       => L_DIFF_CONFIG_ID,
					  P_DOCUMENT_TYPE        => L_DOCUMENT_TYPE,
					  P_ENTITY_NAME          => L_ENTITY_NAME,
					  P_SUB_ENTITY_NAME      => L_SUB_ENTITY_NAME,
					  P_BASE_DOC_SOURCE_NAME  => L_BASE_DOC_SOURCE_NAME,
					  P_MOD_DOC_SOURCE_NAME   => L_MOD_DOC_SOURCE_NAME,
					  P_COLUMN_NAME           => L_COLUMN_NAME,
					  P_CMP_FILTER_PRED_FLAG  => L_CMP_FILTER_PRED_FLAG,
					  P_IS_PRINTABLE_FLAG      => L_IS_PRINTABLE_FLAG,
					  P_ROLLUP_ELIGIBILITY_FLAG => L_ROLLUP_ELIGIBILITY_FLAG,
					  P_DISPLAY_SEQ_NUMBER      => L_DISPLAY_SEQ_NUMBER,
					  P_DISP_DATA_TYPE          => L_DISP_DATA_TYPE,
					  P_LABEL_MESSAGE_CODE      => L_LABEL_MESSAGE_CODE,
					  P_IGNORE_SOURCE_FLAG      => p_ignore_source_flag,
					  P_LAST_UPDATE_DATE        => sysdate,
					  P_LAST_UPDATED_BY         => F_LUBY,
					  P_LAST_UPDATE_LOGIN		=> 0
					  );

Line: 254


			/* If data does not exist, insert the new record */
				  PO_DIFF_CONFIG_PKG.INSERT_ROW (
					  P_DIFF_CONFIG_ID       => L_DIFF_CONFIG_ID,
					  P_DOCUMENT_TYPE        => L_DOCUMENT_TYPE,
					  P_ENTITY_NAME          => L_ENTITY_NAME,
					  P_SUB_ENTITY_NAME      => L_SUB_ENTITY_NAME,
					  P_BASE_DOC_SOURCE_NAME  => L_BASE_DOC_SOURCE_NAME,
					  P_MOD_DOC_SOURCE_NAME   => L_MOD_DOC_SOURCE_NAME,
					  P_COLUMN_NAME           => L_COLUMN_NAME,
					  P_CMP_FILTER_PRED_FLAG  => L_CMP_FILTER_PRED_FLAG,
					  P_IS_PRINTABLE_FLAG      => L_IS_PRINTABLE_FLAG,
					  P_ROLLUP_ELIGIBILITY_FLAG => L_ROLLUP_ELIGIBILITY_FLAG,
					  P_DISPLAY_SEQ_NUMBER      => L_DISPLAY_SEQ_NUMBER,
					  P_DISP_DATA_TYPE          => L_DISP_DATA_TYPE,
					  P_LABEL_MESSAGE_CODE      => L_LABEL_MESSAGE_CODE,
					  P_IGNORE_SOURCE_FLAG      => L_IGNORE_SOURCE_FLAG,
					  P_CREATION_DATE           => sysdate,
					  P_CREATED_BY              => F_LUBY,
					  P_LAST_UPDATE_DATE        => sysdate,
					  P_LAST_UPDATED_BY         => F_LUBY,
					  P_LAST_UPDATE_LOGIN		=> 0
					  );

Line: 281


		'Row cannot be updated - ' || 'DIFF_CONFIG_ID = ' || L_DIFF_CONFIG_ID);