APPS.PA_USER_ATTR_PUB SQL Statements

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

Line: 35

  SELECT project_id
  FROM PA_PROJ_ELEMENTS
  WHERE proj_element_id = c_task_id;

Line: 41

  SELECT proj_element_id
  FROM PA_PROJ_ELEMENTS
  WHERE project_id = c_project_id;

Line: 47

  SELECT ppe2.proj_element_id
  FROM PA_PROJ_ELEMENTS ppe, PA_PROJ_ELEMENTS ppe2
  WHERE ppe.project_id = c_old_project_id
  AND ppe.proj_element_id = c_old_proj_element_id
  AND ppe.element_number = ppe2.element_number
  AND ppe2.project_id = c_new_project_id;

Line: 56

  SELECT DISTINCT limiting_value
  FROM pa_project_copy_overrides
  WHERE project_id = c_project_id
  AND field_name = 'CLASSIFICATION';

Line: 63

  SELECT class_category
  FROM PA_PROJECT_CLASSES
  WHERE project_id = c_old_project_id
  AND class_category = c_category
  AND class_category NOT IN
  (SELECT class_category
   FROM PA_PROJECT_CLASSES
   where project_id = c_new_project_id);

Line: 74

  SELECT class_code
  FROM PA_PROJECT_CLASSES
  WHERE project_id = c_old_project_id
  AND class_category = c_category
  MINUS
  SELECT class_code
  FROM PA_PROJECT_CLASSES
  WHERE project_id = c_new_project_id
  AND class_category = c_category;

Line: 86

  SELECT class_category_id
  FROM PA_CLASS_CATEGORIES
  WHERE class_category = c_category;

Line: 92

  SELECT class_code_id
  FROM PA_CLASS_CODES
  WHERE class_category = c_category
  AND class_code = c_code;

Line: 104

  l_deleted_category              VARCHAR2(30);

Line: 227

      FETCH check_category_removed INTO l_deleted_category;

Line: 233

        PA_USER_ATTR_PUB.DELETE_USER_ATTRS_DATA (
         p_validate_only             => FND_API.G_FALSE
        ,p_project_id                => p_object_id_to
        ,p_old_classification_id     => l_category_id
        ,p_classification_type       => 'CLASS_CATEGORY'
        ,x_return_status             => l_return_status
        ,x_msg_count                 => l_msg_count
        ,x_msg_data                  => l_msg_data );

Line: 268

        PA_USER_ATTR_PUB.DELETE_USER_ATTRS_DATA (
         p_validate_only             => FND_API.G_FALSE
        ,p_project_id                => p_object_id_to
        ,p_old_classification_id     => l_code_id
        ,p_classification_type       => 'CLASS_CODE'
        ,x_return_status             => l_return_status
        ,x_msg_count                 => l_msg_count
        ,x_msg_data                  => l_msg_data );

Line: 343

PROCEDURE DELETE_USER_ATTRS_DATA
( p_api_version                   IN NUMBER   := 1.0
 ,p_init_msg_list                 IN VARCHAR2 := FND_API.G_TRUE
 ,p_commit                        IN VARCHAR2 DEFAULT FND_API.G_FALSE
 ,p_validate_only                 IN VARCHAR2 := FND_API.G_TRUE
 ,p_validation_level              IN NUMBER   := FND_API.G_VALID_LEVEL_FULL
 ,p_calling_module                IN VARCHAR2 := 'SELF_SERVICE'
 ,p_debug_mode                    IN VARCHAR2 := 'N'
 ,p_project_id                    IN NUMBER
 ,p_proj_element_id               IN NUMBER DEFAULT NULL
 ,p_old_classification_id         IN NUMBER
 ,p_new_classification_id         IN NUMBER DEFAULT NULL
 ,p_classification_type           IN VARCHAR2
 ,x_return_status                 OUT NOCOPY VARCHAR2
 ,x_msg_count                     OUT NOCOPY NUMBER
 ,x_msg_data                      OUT NOCOPY VARCHAR2
)
IS
  l_api_name                      CONSTANT VARCHAR(30) := 'Delete_User_Attrs_Data';

Line: 372

  pa_debug.init_err_stack('PA_USER_ATTR_PUB.Delete_User_Attrs_Data');

Line: 375

    pa_debug.debug('PA_USER_ATTR_PUB.Delete_User_Attrs_Data BEGIN');

Line: 383

     savepoint delete_user_attrs_data;

Line: 390

  PA_USER_ATTR_PVT.DELETE_USER_ATTRS_DATA (
   p_commit                      => FND_API.G_FALSE
  ,p_validate_only               => p_validate_only
  ,p_validation_level            => p_validation_level
  ,p_calling_module              => p_calling_module
  ,p_debug_mode                  => p_debug_mode
  ,p_project_id                  => p_project_id
  ,p_proj_element_id             => p_proj_element_id
  ,p_old_classification_id       => p_old_classification_id
  ,p_new_classification_id       => p_new_classification_id
  ,p_classification_type         => p_classification_type
  ,x_return_status               => l_return_status
  ,x_msg_count                   => l_msg_count
  ,x_msg_data                    => l_msg_data );

Line: 427

    pa_debug.debug('PA_USER_ATTR_PUB.Delete_User_Attrs_Data END');

Line: 433

         rollback to delete_user_attrs_data;

Line: 438

         rollback to delete_user_attrs_data;

Line: 442

                              p_procedure_name => 'Delete_User_Attrs_Data',
                              p_error_text     => SUBSTRB(SQLERRM,1,240));

Line: 446

         rollback to delete_user_attrs_data;

Line: 450

                              p_procedure_name => 'Delete_User_Attrs_Data',
                              p_error_text     => SUBSTRB(SQLERRM,1,240));

Line: 453

END DELETE_USER_ATTRS_DATA;

Line: 461

PROCEDURE CHECK_DELETE_ASSOC_OK
( p_api_version                   IN NUMBER   := 1.0
 ,p_association_id                IN NUMBER
 ,p_classification_code           IN VARCHAR2
 ,p_data_level                    IN VARCHAR2
 ,p_attr_group_id                 IN NUMBER
 ,p_application_id                IN NUMBER
 ,p_attr_group_type               IN VARCHAR2
 ,p_attr_group_name               IN VARCHAR2
 ,p_enabled_code                  IN VARCHAR2
 ,x_ok_to_delete                  OUT NOCOPY VARCHAR2
 ,x_return_status                 OUT NOCOPY VARCHAR2
 ,x_errorcode                     OUT NOCOPY NUMBER
 ,x_msg_count                     OUT NOCOPY NUMBER
 ,x_msg_data                      OUT NOCOPY VARCHAR2
)
IS
  l_api_name                      CONSTANT VARCHAR(30) := 'Check_Delete_Assoc_Ok';

Line: 481

  l_ok_to_delete                  VARCHAR2(250);

Line: 495

  SELECT 'Y'
  FROM PA_PROJECTS_ERP_EXT_B
  WHERE attr_group_id = p_attr_group_id;

Line: 501

  SELECT creation_date
  FROM EGO_OBJ_AG_ASSOCS_B
  WHERE association_id = p_association_id;

Line: 507

  SELECT max(creation_date)
  FROM PA_PROJECTS_ERP_EXT_B
  WHERE attr_group_id = p_attr_group_id;

Line: 521

    x_ok_to_delete := FND_API.G_TRUE;

Line: 532

      x_ok_to_delete := FND_API.G_TRUE;

Line: 534

      x_ok_to_delete := FND_API.G_FALSE;

Line: 563

                             p_procedure_name => 'Check_Delete_Assoc_Ok',
                             p_error_text     => SUBSTRB(SQLERRM,1,240));

Line: 565

     x_ok_to_delete := FND_API.G_FALSE;

Line: 567

END CHECK_DELETE_ASSOC_OK;

Line: 575

PROCEDURE DELETE_ALL_USER_ATTRS_DATA
( p_api_version                   IN NUMBER   := 1.0
 ,p_init_msg_list                 IN VARCHAR2 := FND_API.G_TRUE
 ,p_commit                        IN VARCHAR2 DEFAULT FND_API.G_FALSE
 ,p_validate_only                 IN VARCHAR2 := FND_API.G_TRUE
 ,p_validation_level              IN NUMBER   := FND_API.G_VALID_LEVEL_FULL
 ,p_calling_module                IN VARCHAR2 := 'SELF_SERVICE'
 ,p_debug_mode                    IN VARCHAR2 := 'N'
 ,p_project_id                    IN NUMBER
 ,p_proj_element_id               IN NUMBER DEFAULT NULL
 ,x_return_status                 OUT NOCOPY VARCHAR2
 ,x_msg_count                     OUT NOCOPY NUMBER
 ,x_msg_data                      OUT NOCOPY VARCHAR2
)
IS
  l_api_name                      CONSTANT VARCHAR(30) := 'Delete_All_User_Attrs_Data';

Line: 601

  pa_debug.init_err_stack('PA_USER_ATTR_PUB.Delete_All_User_Attrs_Data');

Line: 604

    pa_debug.debug('PA_USER_ATTR_PUB.Delete_All_User_Attrs_Data BEGIN');

Line: 612

     savepoint delete_all_user_attrs_data;

Line: 619

  PA_USER_ATTR_PVT.DELETE_ALL_USER_ATTRS_DATA (
   p_commit                      => FND_API.G_FALSE
  ,p_validate_only               => p_validate_only
  ,p_validation_level            => p_validation_level
  ,p_calling_module              => p_calling_module
  ,p_debug_mode                  => p_debug_mode
  ,p_project_id                  => p_project_id
  ,p_proj_element_id             => p_proj_element_id
  ,x_return_status               => l_return_status
  ,x_msg_count                   => l_msg_count
  ,x_msg_data                    => l_msg_data );

Line: 653

    pa_debug.debug('PA_USER_ATTR_PUB.Delete_All_User_Attrs_Data END');

Line: 659

         rollback to delete_all_user_attrs_data;

Line: 664

         rollback to delete_all_user_attrs_data;

Line: 668

                              p_procedure_name => 'Delete_All_User_Attrs_Data',
                              p_error_text     => SUBSTRB(SQLERRM,1,240));

Line: 672

         rollback to delete_all_user_attrs_data;

Line: 676

                              p_procedure_name => 'Delete_All_User_Attrs_Data',
                              p_error_text     => SUBSTRB(SQLERRM,1,240));

Line: 679

END DELETE_ALL_USER_ATTRS_DATA;

Line: 968

  SELECT class_category, class_code
  FROM PA_PROJECT_CLASSES
  WHERE rowid = p_row_id;

Line: 985

  SELECT class_category_id
  FROM PA_CLASS_CATEGORIES
  WHERE class_category = c_class_category;

Line: 991

  SELECT class_code_id
  FROM PA_CLASS_CODES
  WHERE class_category = c_class_category
  AND   class_code = c_class_code;

Line: 998

  SELECT 'Y'
  FROM DUAL
  WHERE EXISTS
    (SELECT classification_code
     FROM EGO_OBJ_AG_ASSOCS_B assocs,
          FND_OBJECTS obj
     WHERE assocs.classification_code = 'CLASS_CATEGORY:'||to_char(c_class_category_id)
     AND   assocs.object_id = obj.object_id
     AND obj.obj_name = 'PA_PROJECTS');

Line: 1010

  SELECT 'Y'
  FROM DUAL
  WHERE EXISTS
    (SELECT classification_code
     FROM EGO_OBJ_AG_ASSOCS_B assocs,
          FND_OBJECTS obj
     WHERE assocs.classification_code = 'CLASS_CODE:'||to_char(c_class_code_id)
     AND   assocs.object_id = obj.object_id
     AND obj.obj_name = 'PA_PROJECTS');

Line: 1024

  if p_mode = 'DELETE' then
    OPEN C1;

Line: 1053

  elsif p_mode = 'UPDATE' then
    OPEN C1;

Line: 1136

  SELECT 'Y'
  FROM DUAL
  WHERE EXISTS
    (SELECT classification_code
     FROM EGO_OBJ_AG_ASSOCS_B assocs,
          FND_OBJECTS obj
     WHERE assocs.classification_code = 'PROJECT_TYPE:'||to_char(c_project_type_id)
     AND   assocs.object_id = obj.object_id
     AND obj.obj_name = 'PA_PROJECTS');

Line: 1148

  SELECT PTT.project_type_id
  FROM pa_project_types PTT, pa_projects_all PPA
  WHERE PPA.project_id = p_project_id
  AND   PPA.project_type = PTT.project_type;

Line: 1155

  SELECT project_type_id
  FROM pa_project_types
  WHERE project_type = p_new_project_type;