APPS.CSM_PAGE_PERZ_PKG SQL Statements

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

Line: 4

PROCEDURE INSERT_ROW
                   (
                   X_FILE_NAME                VARCHAR2,
                   X_PAGE_NAME                VARCHAR2,
                   X_UIX_PAGE_SERVER_VERSION  VARCHAR2,
                   X_UIX_PAGE_CLIENT_VERSION  VARCHAR2,
                   X_MESSAGE_NAME             VARCHAR2,
                   X_OWNER                    VARCHAR2
                   )
IS

BEGIN
        --Insert
	INSERT INTO CSM_PAGE_PERZ
                (PAGE_PERZ_ID,
		 FILE_NAME,
                 PAGE_NAME,
                 UIX_PAGE_SERVER_VERSION,
                 UIX_PAGE_CLIENT_VERSION,
                 MESSAGE_NAME,
                 LAST_UPDATED_BY,
                 CREATION_DATE,
                 CREATED_BY,
                 LAST_UPDATE_DATE)
          VALUES(CSM_PAGE_PERZ_S.NEXTVAL,
                 X_FILE_NAME,
                 X_PAGE_NAME,
                 X_UIX_PAGE_SERVER_VERSION,
                 X_UIX_PAGE_CLIENT_VERSION,
                 X_MESSAGE_NAME,
                 DECODE(X_OWNER,'SEED',1,0),
                 SYSDATE,
                 DECODE(X_OWNER,'SEED',1,0),
                 SYSDATE);

Line: 39

END Insert_Row;

Line: 41

PROCEDURE UPDATE_ROW(
                   X_FILE_NAME                VARCHAR2,
                   X_PAGE_NAME                VARCHAR2,
                   X_UIX_PAGE_SERVER_VERSION  VARCHAR2,
                   X_UIX_PAGE_CLIENT_VERSION  VARCHAR2,
                   X_MESSAGE_NAME             VARCHAR2,
                   X_OWNER                    VARCHAR2
                    )

IS

BEGIN
        --Update
	UPDATE CSM_PAGE_PERZ
   	SET PAGE_NAME                = X_PAGE_NAME,
            UIX_PAGE_SERVER_VERSION  = X_UIX_PAGE_SERVER_VERSION,
            UIX_PAGE_CLIENT_VERSION  = X_UIX_PAGE_CLIENT_VERSION,
            MESSAGE_NAME             = X_MESSAGE_NAME,
            LAST_UPDATED_BY          = DECODE(X_OWNER,'SEED',1,0),
            LAST_UPDATE_DATE         = SYSDATE
	WHERE  FILE_NAME = X_FILE_NAME;

Line: 63

END Update_Row;

Line: 78

 SELECT 1
 FROM  CSM_PAGE_PERZ CPP
 WHERE CPP.FILE_NAME      = b_file_name;

Line: 92

          Insert_Row(
                   X_FILE_NAME,
                   X_PAGE_NAME,
                   X_UIX_PAGE_SERVER_VERSION,
                   X_UIX_PAGE_CLIENT_VERSION,
                   X_MESSAGE_NAME,
                   X_OWNER);

Line: 102

          Update_Row(
                   X_FILE_NAME,
                   X_PAGE_NAME,
                   X_UIX_PAGE_SERVER_VERSION,
                   X_UIX_PAGE_CLIENT_VERSION,
                   X_MESSAGE_NAME,
                   X_OWNER);