APPS.BNE_PARAMETER_UTILS SQL Statements

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

Line: 62

	INSERT INTO BNE_PARAM_LISTS_B (    APPLICATION_ID,
					  PARAM_LIST_CODE,
					  OBJECT_VERSION_NUMBER,
					  PERSISTENT_FLAG,
					  COMMENTS,
					  ATTRIBUTE_APP_ID,
					  ATTRIBUTE_CODE,
					  LIST_RESOLVER,
					  LAST_UPDATE_DATE,
					  LAST_UPDATED_BY,
					  CREATION_DATE,
					  CREATED_BY,
					  LAST_UPDATE_LOGIN  ) VALUES

					( P_APPLICATION_ID,
					  VV_PARAM_LIST_CODE,
					  VN_OBJECT_VERSION_NUM,
					  P_PERSISTENT,
					  P_COMMENTS,
					  P_ATTRIBUTE_APP_ID,
					  P_ATTRIBUTE_CODE,
					  P_LIST_RESOLVER,
					  SYSDATE,
					  FND_GLOBAL.USER_ID,
					  SYSDATE,
					  FND_GLOBAL.USER_ID,
					  NULL );

Line: 91

	INSERT INTO BNE_PARAM_LISTS_TL   (APPLICATION_ID,
					  PARAM_LIST_CODE,
					  LANGUAGE,
					  SOURCE_LANG,
					  USER_NAME,
					  USER_TIP,
					  PROMPT_LEFT,
					  PROMPT_ABOVE,
					  LAST_UPDATE_DATE,
					  LAST_UPDATED_BY,
					  CREATION_DATE,
					  CREATED_BY,
					  LAST_UPDATE_LOGIN ) VALUES

					( P_APPLICATION_ID,
					  VV_PARAM_LIST_CODE,
					  FND_GLOBAL.CURRENT_LANGUAGE,
					  FND_GLOBAL.CURRENT_LANGUAGE,
					  P_USER_NAME,
					  P_USER_TIP,
					  P_PROMPT_LEFT,
					  P_PROMPT_ABOVE,
					  SYSDATE,
					  FND_GLOBAL.USER_ID,
					  SYSDATE,
					  FND_GLOBAL.USER_ID,
					  NULL );

Line: 242

	INSERT INTO BNE_ATTRIBUTES (  	  APPLICATION_ID,
					  ATTRIBUTE_CODE,
					  OBJECT_VERSION_NUMBER,
					  ATTRIBUTE1,
					  ATTRIBUTE2,
					  ATTRIBUTE3,
					  ATTRIBUTE4,
					  ATTRIBUTE5,
					  ATTRIBUTE6,
					  ATTRIBUTE7,
					  ATTRIBUTE8,
					  ATTRIBUTE9,
					  ATTRIBUTE10,
					  ATTRIBUTE11,
					  ATTRIBUTE12,
					  ATTRIBUTE13,
					  ATTRIBUTE14,
					  ATTRIBUTE15,
					  ATTRIBUTE16,
					  ATTRIBUTE17,
					  ATTRIBUTE18,
					  ATTRIBUTE19,
					  ATTRIBUTE20,
					  ATTRIBUTE21,
					  ATTRIBUTE22,
					  ATTRIBUTE23,
					  ATTRIBUTE24,
					  ATTRIBUTE25,
					  ATTRIBUTE26,
					  ATTRIBUTE27,
					  ATTRIBUTE28,
					  ATTRIBUTE29,
					  ATTRIBUTE30,
					  LAST_UPDATE_DATE,
					  LAST_UPDATED_BY,
					  CREATION_DATE,
					  CREATED_BY,
					  LAST_UPDATE_LOGIN)

	VALUES (P_APPLICATION_ID, P_ATTRIBUTE_CODE, VN_OBJECT_VERSION_NUM, P_ATTRIBUTE1, P_ATTRIBUTE2, P_ATTRIBUTE3,
			P_ATTRIBUTE4 ,P_ATTRIBUTE5 , P_ATTRIBUTE6 ,P_ATTRIBUTE7 ,P_ATTRIBUTE8 ,P_ATTRIBUTE9,
			P_ATTRIBUTE10,P_ATTRIBUTE11,P_ATTRIBUTE12,P_ATTRIBUTE13,P_ATTRIBUTE14 ,P_ATTRIBUTE15,
			P_ATTRIBUTE16,P_ATTRIBUTE17,P_ATTRIBUTE18,P_ATTRIBUTE19,P_ATTRIBUTE20,P_ATTRIBUTE21,
			P_ATTRIBUTE22,P_ATTRIBUTE23,P_ATTRIBUTE24,P_ATTRIBUTE25 ,P_ATTRIBUTE26 ,P_ATTRIBUTE27,
			P_ATTRIBUTE28,P_ATTRIBUTE29,P_ATTRIBUTE30, SYSDATE,FND_GLOBAL.USER_ID,SYSDATE, FND_GLOBAL.USER_ID, NULL );

Line: 398

	INSERT INTO BNE_PARAM_LIST_ITEMS  (	APPLICATION_ID,
						PARAM_LIST_CODE,
						SEQUENCE_NUM,
						OBJECT_VERSION_NUMBER,
						PARAM_DEFN_APP_ID,
						PARAM_DEFN_CODE,
						PARAM_NAME ,
						ATTRIBUTE_APP_ID,
						ATTRIBUTE_CODE,
						STRING_VALUE,
						DATE_VALUE,
						NUMBER_VALUE,
						BOOLEAN_VALUE_FLAG ,
						FORMULA_VALUE,
						DESC_VALUE ,
						LAST_UPDATE_DATE,
						LAST_UPDATED_BY,
						CREATION_DATE,
						CREATED_BY,
						LAST_UPDATE_LOGIN )
				VALUES (P_APPLICATION_ID,
						VV_LIST_CODE,
						VN_SEQ_NUM,
						VN_OBJECT_VERSION_NUM,
						P_PARAM_DEFN_APP_ID,
						P_PARAM_DEFN_CODE,
						P_PARAM_NAME,
						P_ATTRIBUTE_APP_ID,
						P_ATTRIBUTE_CODE,
						P_STRING_VAL,
						P_DATE_VAL,
						P_NUMBER_VAL ,
						P_BOOLEAN_VAL ,
						P_FORMULA ,
						P_DESC_VAL ,
						SYSDATE,
						FND_GLOBAL.USER_ID,
						SYSDATE,
						FND_GLOBAL.USER_ID,
						NULL );

Line: 527

	SELECT 	APPLICATION_ID, PARAM_DEFN_CODE
	INTO 	VN_APPLICATION_ID, VV_DEFN_CODE
	FROM 	BNE_PARAM_DEFNS_B
	WHERE 	PARAM_NAME = P_PARAM_DEFN_NAME
	AND 	PARAM_SOURCE = P_PARAM_SOURCE
	AND		APPLICATION_ID = P_APPLICATION_ID;

Line: 613

	INSERT INTO BNE_PARAM_DEFNS_B (	  APPLICATION_ID,
            PARAM_DEFN_CODE,
            OBJECT_VERSION_NUMBER,
					  PARAM_NAME ,
					  PARAM_SOURCE,
					  PARAM_CATEGORY,
					  DATATYPE,
					  ATTRIBUTE_APP_ID,
					  ATTRIBUTE_CODE,
					  PARAM_RESOLVER,
					  DEFAULT_REQUIRED_FLAG,
					  DEFAULT_VISIBLE_FLAG,
					  DEFAULT_USER_MODIFYABLE_FLAG,
					  DEFAULT_STRING,
					  DEFAULT_DATE,
					  DEFAULT_NUMBER,
					  DEFAULT_BOOLEAN_FLAG,
					  DEFAULT_FORMULA,
					  VAL_TYPE,
					  VAL_VALUE,
					  MAX_SIZE,
					  DISPLAY_TYPE,
					  DISPLAY_STYLE,
					  DISPLAY_SIZE,
					  HELP_URL,
					  FORMAT_MASK,
					  LAST_UPDATE_DATE,
					  LAST_UPDATED_BY,
					  CREATION_DATE,
					  CREATED_BY,
					  LAST_UPDATE_LOGIN )
				VALUES (P_APPLICATION_ID,
					P_PARAM_CODE,
					VN_OBJECT_VERSION_NUM,
					P_PARAM_NAME,
					P_PARAM_SOURCE,
					P_CATEGORY,
					P_DATA_TYPE,
					P_ATTRIBUTE_APP_ID,
					P_ATTRIBUTE_CODE,
					P_PARAM_RESOLVER,
					P_REQUIRED,
					P_VISIBLE,
					P_MODIFYABLE,
					P_DEFAULT_STRING,
					P_DEFAULT_DATE,
					P_DEFAULT_NUM,
					P_DEFAULT_BOOLEAN,
					P_DEFAULT_FORMULA,
					P_VAL_TYPE,
					P_VAL_VALUE,
					P_MAXIMUM_SIZE,
					P_DISPLAY_TYPE,
					P_DISPLAY_STYLE,
					P_DISPLAY_SIZE,
					P_HELP_URL,
					P_FORMAT_MASK,
					SYSDATE,
					FND_GLOBAL.USER_ID,
					SYSDATE,
					FND_GLOBAL.USER_ID,
					NULL );

Line: 677

	INSERT INTO BNE_PARAM_DEFNS_TL (     APPLICATION_ID,
					     PARAM_DEFN_CODE,
					     LANGUAGE,
					     SOURCE_LANG,
					     DEFAULT_STRING,
					     DEFAULT_DESC,
					     PROMPT_LEFT,
					     PROMPT_ABOVE,
					     USER_NAME,
					     USER_TIP,
					     ACCESS_KEY,
					     LAST_UPDATE_DATE,
					     LAST_UPDATED_BY,
					     CREATION_DATE,
					     CREATED_BY,
					     LAST_UPDATE_LOGIN )
				VALUES (P_APPLICATION_ID,
					P_PARAM_CODE,
					FND_GLOBAL.CURRENT_LANGUAGE,
					FND_GLOBAL.CURRENT_LANGUAGE,
					P_DEFAULT_STRING,
					P_DEFAULT_DESC,
					P_PROMPT_LEFT,
					P_PROMPT_ABOVE,
					P_USER_NAME,
					P_USER_TIP,
					P_ACCESS_KEY,
					SYSDATE,
					FND_GLOBAL.USER_ID,
					SYSDATE,
					FND_GLOBAL.USER_ID,
					NULL );

Line: 790

	SELECT MAX(SEQUENCE_NUM)
	INTO VN_SEQ_NUM
	FROM BNE_PARAM_LIST_ITEMS
	WHERE PARAM_LIST_CODE = P_PARAM_LIST_CODE
	AND APPLICATION_ID = P_APPLICATION_ID;