APPS.PA_PROJECT_CTX_SEARCH_PKG SQL Statements

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

Line: 4

PROCEDURE INSERT_ROW(p_project_id            in NUMBER,
                     p_ctx_description       in VARCHAR2,
                     x_return_status         OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
)
IS
BEGIN

  INSERT INTO PA_PROJECT_CTX_SEARCH
       (PROJECT_ID,
        CTX_DESCRIPTION,
        PROGRAM_REQUEST_ID,
        PROGRAM_APPLICATION_ID,
        PROGRAM_ID,
        PROGRAM_UPDATE_DATE,
        CREATED_BY,
        CREATION_DATE,
        LAST_UPDATED_BY,
        LAST_UPDATE_DATE,
        LAST_UPDATE_LOGIN)
   VALUES
       (p_project_id,
        p_ctx_description,
        null,
        null,
        null,
        null,
        fnd_global.user_id,
        sysdate,
        fnd_global.user_id,
        sysdate,
        fnd_global.login_id);

Line: 42

                                 p_procedure_name => 'INSERT_ROW' );

Line: 45

END INSERT_ROW;

Line: 47

PROCEDURE UPDATE_ROW(p_project_id            IN  NUMBER,
                     p_ctx_description       IN  VARCHAR2,
                     x_return_status         OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
                     )

IS
BEGIN

  UPDATE PA_PROJECT_CTX_SEARCH
  SET CTX_DESCRIPTION     = p_ctx_description,
      LAST_UPDATE_DATE    = sysdate,
      LAST_UPDATED_BY     = fnd_global.user_id,
      LAST_UPDATE_LOGIN   = fnd_global.login_id
  WHERE project_id = p_project_id;

Line: 68

                                 p_procedure_name => 'UPDATE_ROW' );

Line: 71

END UPDATE_ROW;

Line: 73

PROCEDURE DELETE_ROW(p_project_id       IN NUMBER,
                     x_return_status   OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
)
IS
BEGIN

  DELETE FROM pa_project_ctx_search
  WHERE project_id = p_project_id;

Line: 88

                                 p_procedure_name => 'DELETE_ROW' );

Line: 91

END DELETE_ROW;