APPS.PA_R_PROJECT_RESOURCES_PUB SQL Statements

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

Line: 31

        P_SELECTION_OPTION	IN  VARCHAR2    DEFAULT NULL,
        P_ORG_STR_VERSION_ID	IN  NUMBER      DEFAULT NULL,
        P_START_ORGANIZATION_ID IN  NUMBER      DEFAULT NULL,
        -- End of parameters added for PJR Resource Pull Enhancements - Bug 5130414
	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
	X_RESOURCE_ID	     OUT NOCOPY PA_RESOURCES.RESOURCE_ID%TYPE) --File.Sql.39 bug 4440895
 IS
	L_API_VERSION	CONSTANT NUMBER	:= 1.0;

Line: 147

			 P_SELECTION_OPTION       => P_SELECTION_OPTION,
			 P_ORG_STR_VERSION_ID     => P_ORG_STR_VERSION_ID,
			 P_START_ORGANIZATION_ID  => P_START_ORGANIZATION_ID,
			 -- End of parameters added for PJR Resource Pull Enhancements - Bug 5130414
			 X_RETURN_STATUS	  => L_RETURN_STATUS,
			 X_RESOURCE_ID		  => X_RESOURCE_ID );