APPS.PA_ADW_DIMENSION_STATUS_PKG SQL Statements

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

Line: 3

procedure INSERT_ROW (
 X_DIMENSION_CODE                 IN VARCHAR2,
 X_DIMENSION_NAME                  IN VARCHAR2,
 X_STATUS_CODE                     IN VARCHAR2,
 X_UPDATE_ALLOWED                  IN VARCHAR2,
 X_LAST_UPDATE_DATE                IN DATE,
 X_LAST_UPDATED_BY                 IN NUMBER,
 X_CREATION_DATE                   IN DATE,
 X_CREATED_BY                      IN NUMBER,
 X_LAST_UPDATE_LOGIN               IN  NUMBER
) is
begin
  insert into PA_ADW_DIMENSION_STATUS(
 DIMENSION_CODE                 ,
 DIMENSION_NAME                  ,
 STATUS_CODE                     ,
 UPDATE_ALLOWED                  ,
 LAST_UPDATE_DATE                ,
 LAST_UPDATED_BY                 ,
 CREATION_DATE                   ,
 CREATED_BY                      ,
 LAST_UPDATE_LOGIN
 ) values (
 X_DIMENSION_CODE                 ,
 X_DIMENSION_NAME                  ,
 X_STATUS_CODE                     ,
 X_UPDATE_ALLOWED                  ,
 X_LAST_UPDATE_DATE                ,
 X_LAST_UPDATED_BY                 ,
 X_CREATION_DATE                   ,
 X_CREATED_BY                      ,
 X_LAST_UPDATE_LOGIN
 );

Line: 41

end INSERT_ROW;

Line: 49

  update PA_ADW_DIMENSION_STATUS set
    DIMENSION_NAME      = X_DIMENSION_NAME,
    LAST_UPDATE_DATE  = sysdate,
    LAST_UPDATED_BY   = decode(X_OWNER, 'SEED', 1, 0),
    LAST_UPDATE_LOGIN = 0
  where DIMENSION_CODE      = X_DIMENSION_CODE
  and userenv('LANG') =
         (select LANGUAGE_CODE from FND_LANGUAGES where INSTALLED_FLAG = 'B');

Line: 70

procedure UPDATE_ROW (
X_DIMENSION_CODE                  IN VARCHAR2,
 X_DIMENSION_NAME                  IN VARCHAR2,
 X_STATUS_CODE                     IN VARCHAR2,
 X_UPDATE_ALLOWED                  IN VARCHAR2,
 X_LAST_UPDATE_DATE                IN DATE,
 X_LAST_UPDATED_BY                 IN NUMBER,
 X_LAST_UPDATE_LOGIN               IN  NUMBER
) is
begin
  update PA_ADW_DIMENSION_STATUS set
	DIMENSION_NAME = X_DIMENSION_NAME,
	STATUS_CODE = X_STATUS_CODE,
	UPDATE_ALLOWED = X_UPDATE_ALLOWED,
    	LAST_UPDATE_DATE    = X_LAST_UPDATE_DATE,
   	LAST_UPDATED_BY     = X_LAST_UPDATED_BY,
    	LAST_UPDATE_LOGIN   = X_LAST_UPDATE_LOGIN
  where DIMENSION_CODE      = X_DIMENSION_CODE ;

Line: 97

end UPDATE_ROW;