APPS.PA_STATUS_LISTS_PUB SQL Statements

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

Line: 22

 P_LAST_UPDATE_DATE             IN         DATE,
 P_LAST_UPDATED_BY              IN         NUMBER,
 P_CREATION_DATE                IN         DATE,
 P_CREATED_BY                   IN         NUMBER,
 P_LAST_UPDATE_LOGIN            IN         NUMBER,
 X_RETURN_STATUS                OUT        NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
 X_MSG_COUNT                    OUT        NOCOPY NUMBER, --File.Sql.39 bug 4440895
 X_MSG_DATA                     OUT        NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
) IS

BEGIN

  -- Initialize the Error Stack
        PA_DEBUG.init_err_stack('PA_STATUS_LISTS_PUB.Insert_Row');

Line: 53

         P_LAST_UPDATE_DATE => P_LAST_UPDATE_DATE,
         P_LAST_UPDATED_BY => P_LAST_UPDATED_BY,
         P_LAST_UPDATE_LOGIN => P_LAST_UPDATE_LOGIN,
         X_RETURN_STATUS  => X_RETURN_STATUS,
         X_MSG_COUNT => X_MSG_COUNT,
         X_MSG_DATA => X_MSG_DATA
        );

Line: 87

PROCEDURE UpdateStatusList (
 P_RECORD_VERSION_NUMBER	IN         NUMBER,
 P_STATUS_LIST_ID               IN         NUMBER,
 P_STATUS_TYPE                  IN         VARCHAR2,
 P_NAME                         IN         VARCHAR2,
 P_START_DATE_ACTIVE            IN         DATE,
 P_END_DATE_ACTIVE              IN         DATE,
 P_DESCRIPTION                  IN         VARCHAR2,
 P_LAST_UPDATE_DATE             IN         DATE,
 P_LAST_UPDATED_BY              IN         NUMBER,
 P_LAST_UPDATE_LOGIN            IN         NUMBER,
 X_RETURN_STATUS                OUT        NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
 X_MSG_COUNT                    OUT        NOCOPY NUMBER, --File.Sql.39 bug 4440895
 X_MSG_DATA                     OUT        NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
) IS

BEGIN

  -- Initialize the Error Stack
        PA_DEBUG.init_err_stack('PA_STATUS_LISTS_PUB.Update_Row');

Line: 113

        PA_STATUS_LISTS_PVT.UpdateStatusList
        (
	 P_RECORD_VERSION_NUMBER => P_RECORD_VERSION_NUMBER,
         P_STATUS_LIST_ID => P_STATUS_LIST_ID,
         P_STATUS_TYPE => P_STATUS_TYPE,
         P_NAME => P_NAME,
         P_START_DATE_ACTIVE => P_START_DATE_ACTIVE,
         P_END_DATE_ACTIVE => P_END_DATE_ACTIVE,
         P_DESCRIPTION => P_DESCRIPTION,
         P_LAST_UPDATE_DATE => P_LAST_UPDATE_DATE,
         P_LAST_UPDATED_BY => P_LAST_UPDATED_BY,
         P_LAST_UPDATE_LOGIN => P_LAST_UPDATE_LOGIN,
         X_RETURN_STATUS  => X_RETURN_STATUS,
         X_MSG_COUNT => X_MSG_COUNT,
         X_MSG_DATA => X_MSG_DATA
        );

Line: 144

END UpdateStatusList;

Line: 160

PROCEDURE DeleteStatusList (
 P_STATUS_LIST_ID               IN         NUMBER,
 P_RECORD_VERSION_NUMBER	IN         NUMBER,
 X_RETURN_STATUS                OUT        NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
 X_MSG_COUNT                    OUT        NOCOPY NUMBER, --File.Sql.39 bug 4440895
 X_MSG_DATA                     OUT        NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
)
IS
BEGIN


  -- Initialize the Error Stack
        PA_DEBUG.init_err_stack('PA_STATUS_LISTS_PUB.Delete_Row');

Line: 181

        PA_STATUS_LISTS_PVT.DeleteStatusList
        ( P_STATUS_LIST_ID =>  P_STATUS_LIST_ID,
	  P_RECORD_VERSION_NUMBER => P_RECORD_VERSION_NUMBER,
          X_RETURN_STATUS  => X_RETURN_STATUS,
          X_MSG_COUNT      => X_MSG_COUNT,
          X_MSG_DATA       => X_MSG_DATA
        );

Line: 203

END DeleteStatusList;