APPS.PA_STATUS_LIST_ITEMS_PVT SQL Statements

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

Line: 19

 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_LIST_ITEMS_PVT.CreateStatusListItem');

Line: 40

        PA_STATUS_LIST_ITEMS_PKG.INSERT_ROW
        (
	 X_RECORD_VERSION_NUMBER=>      P_RECORD_VERSION_NUMBER,
	 X_STATUS_LIST_ITEM_ID  =>	PX_STATUS_LIST_ITEM_ID,
	 X_STATUS_LIST_ID       =>      P_STATUS_LIST_ID,
	 X_PROJECT_STATUS_CODE  =>	P_PROJECT_STATUS_CODE,
	 X_LAST_UPDATE_DATE     =>	P_LAST_UPDATE_DATE,
	 X_LAST_UPDATED_BY      =>	P_LAST_UPDATED_BY,
	 X_CREATION_DATE        =>	P_CREATION_DATE,
	 X_CREATED_BY           =>	P_CREATED_BY,
	 X_LAST_UPDATE_LOGIN    =>	P_LAST_UPDATE_LOGIN
	 );

Line: 79

PROCEDURE UpdateStatusListItem (
 P_RECORD_VERSION_NUMBER        IN	   NUMBER,
 P_STATUS_LIST_ITEM_ID         IN	   NUMBER,
 P_STATUS_LIST_ID               IN	   NUMBER,
 P_PROJECT_STATUS_CODE          IN	   VARCHAR2,
 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_LIST_ITEMS_PVT.Update_Row');

Line: 105

           PA_STATUS_LIST_ITEMS_PKG.UPDATE_ROW
           (
	 X_RECORD_VERSION_NUMBER=>	P_RECORD_VERSION_NUMBER,
	 X_STATUS_LIST_ITEM_ID  =>	P_STATUS_LIST_ITEM_ID,
	 X_STATUS_LIST_ID       =>      P_STATUS_LIST_ID,
	 X_PROJECT_STATUS_CODE  =>	P_PROJECT_STATUS_CODE,
	 X_LAST_UPDATE_DATE     =>	P_LAST_UPDATE_DATE,
	 X_LAST_UPDATED_BY      =>	P_LAST_UPDATED_BY,
	 X_CREATION_DATE        =>	P_CREATION_DATE,
	 X_CREATED_BY           =>	P_CREATED_BY,
	 X_LAST_UPDATE_LOGIN    =>	P_LAST_UPDATE_LOGIN
           );

Line: 132

END UpdateStatusListItem;

Line: 148

PROCEDURE DeleteStatusListItem (
 P_STATUS_LIST_ITEM_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_LIST_ITEMS_PVT.Delete_Row');

Line: 170

        PA_STATUS_LIST_ITEMS_PKG.DELETE_ROW
        (
	X_STATUS_LIST_ITEM_ID         =>  P_STATUS_LIST_ITEM_ID ,
	X_RECORD_VERSION_NUMBER       =>  P_RECORD_VERSION_NUMBER
        );

Line: 190

END DeleteStatusListItem;