eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PA_PROJ_TEMPLATE_SETUP_PUB SQL Statements

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

Line: 244


PROCEDURE Update_Project_Template(
 p_api_version        IN    NUMBER  :=1.0,
 p_init_msg_list          IN    VARCHAR2    :=FND_API.G_TRUE,
 p_commit               IN  VARCHAR2    :=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_max_msg_count          IN    NUMBER  :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM,
 p_project_id           IN    NUMBER,
 p_project_number       IN    VARCHAR2    := 'JUNK_CHARS',
 p_project_name       IN    VARCHAR2    := 'JUNK_CHARS',
 p_project_type       IN    VARCHAR2    := 'JUNK_CHARS',
 p_organization_id  IN    NUMBER      := -9999,
 p_organization_name    IN    VARCHAR2    := 'JUNK_CHARS',
 p_effective_from_date  IN    DATE        := TO_DATE( '01-01-1000', 'DD-MM-YYYY' ),
 p_effective_to_date    IN    DATE        := TO_DATE( '01-01-1000', 'DD-MM-YYYY' ),
 p_description        IN    VARCHAR2    := 'JUNK_CHARS',
 p_security_level     IN    NUMBER := 0,
-- anlee
-- Project Long Name changes
 p_long_name          IN    VARCHAR2  DEFAULT NULL,
-- End of changes
 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
   l_api_name                      CONSTANT VARCHAR(30) := 'Update_Project_Template';

Line: 290


    pa_debug.init_err_stack ('PA_PROJ_TEMPLATE_SETUP_PUB.Update_Project_Template');

Line: 293


      pa_debug.debug('PA_PROJ_TEMPLATE_SETUP_PUB.Update_Project_Template begin');

Line: 297


      savepoint Update_Project_Template;

Line: 370


           SELECT 'x' INTO l_dummy_char
           FROM  pa_projects_all
           WHERE project_id             = p_project_id
           AND record_version_number  = p_record_version_number
           FOR UPDATE OF record_version_number NOWAIT;

Line: 404


           SELECT 'x' INTO l_dummy_char
           FROM  pa_projects_all
           WHERE project_id             = p_project_id
           AND record_version_number  = p_record_version_number;

Line: 439


    PA_PROJ_TEMPLATE_SETUP_PVT.Update_Project_Template(
         p_api_version         => p_api_version
        ,p_init_msg_list     => p_init_msg_list
        ,p_commit                => p_commit
        ,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_max_msg_count     => p_max_msg_count
        ,p_project_id          => p_project_id
        ,p_project_number      => p_project_number
        ,p_project_name        => p_project_name
        ,p_project_type        => p_project_type
        ,p_organization_id   => l_organization_id
        ,p_effective_from_date => p_effective_from_date
        ,p_effective_to_date     => p_effective_to_date
        ,p_description         => p_description
        ,p_security_level      => p_security_level
-- anlee
-- Project Long Name changes
        ,p_long_name             => p_long_name
-- End of changes
        ,p_record_version_number => p_record_version_number
        ,x_return_status     => l_return_status
        ,x_msg_count           => l_msg_count
        ,x_msg_data        => l_msg_data );

Line: 488


      pa_debug.debug('PA_PROJ_TEMPLATE_SETUP_PUB.Update_Project_Template END');

Line: 493


         rollback to Update_Project_Template;

Line: 498


         rollback to Update_Project_Template;

Line: 502


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

Line: 506


         rollback to Update_Project_Template;

Line: 510


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

Line: 513


END Update_Project_Template;

Line: 529


PROCEDURE Delete_Project_Template(
 p_api_version        IN    NUMBER  :=1.0,
 p_init_msg_list          IN    VARCHAR2    :=FND_API.G_TRUE,
 p_commit               IN  VARCHAR2    :=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_max_msg_count          IN    NUMBER  :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM,
 p_project_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
   l_api_name                      CONSTANT VARCHAR(30) := 'Delete_Project_Template';

Line: 557


    pa_debug.init_err_stack ('PA_PROJ_TEMPLATE_SETUP_PUB.Delete_Project_Template');

Line: 560


      pa_debug.debug('PA_PROJ_TEMPLATE_SETUP_PUB.Delete_Project_Template begin');

Line: 564


      savepoint Delete_Project_Template;

Line: 579


           SELECT 'x' INTO l_dummy_char
           FROM  pa_projects_all
           WHERE project_id             = p_project_id
           AND record_version_number  = p_record_version_number
           FOR UPDATE OF record_version_number NOWAIT;

Line: 613


           SELECT 'x' INTO l_dummy_char
           FROM  pa_projects_all
           WHERE project_id             = p_project_id
           AND record_version_number  = p_record_version_number;

Line: 646


    PA_PROJ_TEMPLATE_SETUP_PVT.Delete_Project_Template(
         p_api_version         => p_api_version
        ,p_init_msg_list     => p_init_msg_list
        ,p_commit                => p_commit
        ,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_max_msg_count     => p_max_msg_count
        ,p_project_id          => p_project_id
        ,p_record_version_number => p_record_version_number
        ,x_return_status     => l_return_status
        ,x_msg_count           => l_msg_count
        ,x_msg_data        => l_msg_data );

Line: 683


      pa_debug.debug('PA_PROJ_TEMPLATE_SETUP_PUB.Delete_Project_Template END');

Line: 688


         rollback to Delete_Project_Template;

Line: 693


         rollback to Delete_Project_Template;

Line: 697


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

Line: 701


         rollback to Delete_Project_Template;

Line: 705


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

Line: 708


END Delete_Project_Template;

Line: 854


PROCEDURE Delete_Project_Options(
 p_api_version        IN    NUMBER  :=1.0,
 p_init_msg_list          IN    VARCHAR2    :=FND_API.G_TRUE,
 p_commit               IN  VARCHAR2    :=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_max_msg_count          IN    NUMBER  :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM,
 p_project_id           IN    NUMBER,
 p_option_code          IN    VARCHAR2,
 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
   l_api_name                      CONSTANT VARCHAR(30) := 'Delete_Project_Options';

Line: 881


    pa_debug.init_err_stack ('PA_PROJ_TEMPLATE_SETUP_PUB.Delete_Project_Options');

Line: 884


      pa_debug.debug('PA_PROJ_TEMPLATE_SETUP_PUB.Delete_Project_Options');

Line: 888


      savepoint Delete_Project_Options;

Line: 900


    PA_PROJ_TEMPLATE_SETUP_PVT.Delete_Project_Options(
         p_api_version         => p_api_version
        ,p_init_msg_list     => p_init_msg_list
        ,p_commit                => p_commit
        ,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_max_msg_count     => p_max_msg_count
        ,p_project_id          => p_project_id
        ,p_option_code         => p_option_code
        ,x_return_status     => l_return_status
        ,x_msg_count           => l_msg_count
        ,x_msg_data        => l_msg_data );

Line: 937


      pa_debug.debug('PA_PROJ_TEMPLATE_SETUP_PUB.Delete_Project_Options END');

Line: 942


         rollback to Delete_Project_Options;

Line: 947


         rollback to Delete_Project_Options;

Line: 951


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

Line: 955


         rollback to Delete_Project_Options;

Line: 959


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

Line: 962


END Delete_Project_Options;

Line: 1195


PROCEDURE Update_Quick_Entry_Field(
 p_api_version        IN    NUMBER  :=1.0,
 p_init_msg_list          IN    VARCHAR2    :=FND_API.G_TRUE,
 p_commit               IN  VARCHAR2    :=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_max_msg_count          IN    NUMBER  :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM,
 p_project_id         IN    NUMBER  ,
 p_row_id               IN    VARCHAR2    ,
 p_sort_order         IN    NUMBER  ,
 p_field_name         IN    VARCHAR2    := 'JUNK_CHARS',
 p_field_meaning          IN    VARCHAR2    := 'JUNK_CHARS',
 p_specification          IN    VARCHAR2    := 'JUNK_CHARS',
 p_limiting_value         IN    VARCHAR2    := 'JUNK_CHARS',
 p_prompt               IN  VARCHAR2    ,
 p_required_flag          IN    VARCHAR2    := 'N',
 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
   l_api_name                      CONSTANT VARCHAR(30) := 'Update_Quick_Entry_Field';

Line: 1237


     SELECT field_name
       FROM pa_project_copy_overrides
      WHERE rowid = p_row_id;

Line: 1243


    pa_debug.init_err_stack ('PA_PROJ_TEMPLATE_SETUP_PUB.Update_Quick_Entry_Field');

Line: 1246


      pa_debug.debug('PA_PROJ_TEMPLATE_SETUP_PUB.Update_Quick_Entry_Field');

Line: 1250


      savepoint Update_Quick_Entry_Field;

Line: 1355


           SELECT 'x' INTO l_dummy_char
           FROM  pa_project_copy_overrides
           WHERE project_id             = p_project_id
           AND record_version_number  = p_record_version_number
           AND rowid = p_row_id
           FOR UPDATE OF record_version_number NOWAIT;

Line: 1390


           SELECT 'x' INTO l_dummy_char
           FROM  pa_project_copy_overrides
           WHERE project_id             = p_project_id
           AND rowid = p_row_id
           AND record_version_number  = p_record_version_number;

Line: 1424


    PA_PROJ_TEMPLATE_SETUP_PVT.Update_Quick_Entry_Field(
         p_api_version         => p_api_version
        ,p_init_msg_list     => p_init_msg_list
        ,p_commit                => p_commit
        ,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_max_msg_count     => p_max_msg_count
        ,p_project_id          => p_project_id
        ,p_row_id              => p_row_id
        ,p_sort_order          => p_sort_order
        ,p_field_name          => l_field_name
        ,p_limiting_value    => l_limiting_value
        ,p_prompt                => p_prompt
        ,p_required_flag     => p_required_flag
        ,p_record_version_number => p_record_version_number
        ,x_return_status     => l_return_status
        ,x_msg_count           => l_msg_count
        ,x_msg_data        => l_msg_data );

Line: 1467


      pa_debug.debug('PA_PROJ_TEMPLATE_SETUP_PUB.Update_Quick_Entry_Field END');

Line: 1472


         rollback to Update_Quick_Entry_Field;

Line: 1477


         rollback to Update_Quick_Entry_Field;

Line: 1481


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

Line: 1485


         rollback to Update_Quick_Entry_Field;

Line: 1489


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

Line: 1492


END Update_Quick_Entry_Field;

Line: 1511


PROCEDURE Delete_Quick_Entry_Field(
 p_api_version        IN    NUMBER  :=1.0,
 p_init_msg_list          IN    VARCHAR2    :=FND_API.G_TRUE,
 p_commit               IN  VARCHAR2    :=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_max_msg_count          IN    NUMBER  :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM,
 p_project_id         IN    NUMBER,
 p_row_id               IN    VARCHAR2,
 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
   l_api_name                      CONSTANT VARCHAR(30) := 'Delete_Quick_Entry_Field';

Line: 1540


    pa_debug.init_err_stack ('PA_PROJ_TEMPLATE_SETUP_PUB.Delete_Quick_Entry_Field');

Line: 1543


      pa_debug.debug('PA_PROJ_TEMPLATE_SETUP_PUB.Delete_Quick_Entry_Field');

Line: 1547


      savepoint Delete_Quick_Entry_Field;

Line: 1562


           SELECT 'x' INTO l_dummy_char
           FROM  pa_project_copy_overrides
           WHERE project_id             = p_project_id
           AND record_version_number  = p_record_version_number
           AND rowid = p_row_id
           FOR UPDATE OF record_version_number NOWAIT;

Line: 1597


           SELECT 'x' INTO l_dummy_char
           FROM  pa_project_copy_overrides
           WHERE project_id             = p_project_id
           AND rowid = p_row_id
           AND record_version_number  = p_record_version_number;

Line: 1631


    PA_PROJ_TEMPLATE_SETUP_PVT.Delete_Quick_Entry_Field(
         p_api_version         => p_api_version
        ,p_init_msg_list     => p_init_msg_list
        ,p_commit                => p_commit
        ,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_max_msg_count     => p_max_msg_count
        ,p_project_id          => p_project_id
        ,p_row_id              => p_row_id
        ,p_record_version_number => p_record_version_number
        ,x_return_status     => l_return_status
        ,x_msg_count           => l_msg_count
        ,x_msg_data        => l_msg_data );

Line: 1669


      pa_debug.debug('PA_PROJ_TEMPLATE_SETUP_PUB.Delete_Quick_Entry_Field END');

Line: 1674


         rollback to Delete_Quick_Entry_Field;

Line: 1679


         rollback to Delete_Quick_Entry_Field;

Line: 1683


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

Line: 1687


         rollback to Delete_Quick_Entry_Field;

Line: 1691


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

Line: 1694


END Delete_Quick_Entry_Field;