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_CONTROL_ITEMS_PUB SQL Statements

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

Line: 19


        SELECT DISTINCT ppp.resource_source_id party_id
        INTO l_party_id
        FROM hz_parties hzp,
 	     pa_project_parties ppp
        WHERE hzp.party_name = p_name
          AND hzp.party_type = 'PERSON'
          AND ppp.resource_source_id = hzp.party_id
          AND ppp.resource_type_id = 112
          AND ppp.project_id = p_project_id
          AND (TRUNC(SYSDATE) BETWEEN TRUNC(ppp.start_date_active)
                                  AND TRUNC(NVL(ppp.end_date_active, SYSDATE)));

Line: 46


         SELECT DISTINCT ppf.party_id party_id
         INTO l_party_id
         FROM pa_project_parties ppp,
              per_all_people_f ppf
         WHERE ppf.full_name = p_name
	   AND (TRUNC(SYSDATE) BETWEEN TRUNC(ppf.effective_start_date)
                                   AND TRUNC(ppf.effective_end_date))
	   AND ppp.resource_source_id = ppf.person_id
           AND ppp.resource_type_id = 101
           AND ppp.project_id = p_project_id
           AND (TRUNC(SYSDATE) BETWEEN TRUNC(ppp.start_date_active)
                                   AND TRUNC(NVL(ppp.end_date_active, SYSDATE)));

Line: 225


       select proj_element_id
          into l_object_id
          from PA_FIN_LATEST_PUB_TASKS_V
          where element_name = p_object_name
          and project_id     = p_project_id;

Line: 367


procedure UPDATE_CONTROL_ITEM (
         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_max_msg_count        IN     NUMBER := FND_API.g_miss_num
        ,p_ci_id                IN  NUMBER
        ,p_ci_type_id           IN  NUMBER
        ,p_summary              IN  VARCHAR2
        ,p_status_code          IN  VARCHAR2  := NULL

        ,p_owner_id             IN  NUMBER    := NULL
        ,p_owner_name           IN  VARCHAR2  := NULL
        ,p_highlighted_flag     IN  VARCHAR2  := 'N'
        ,p_progress_status_code IN  VARCHAR2
        ,p_progress_as_of_date  IN  DATE
        ,p_classification_code  IN  NUMBER
        ,p_reason_code          IN  NUMBER
        ,p_record_version_number IN  NUMBER
        ,p_project_id           IN  NUMBER
        ,p_object_type          IN  VARCHAR2   := NULL
        ,p_object_id            IN  NUMBER     := NULL
        ,p_object_name          IN  VARCHAR2   := NULL
        ,p_ci_number            IN  VARCHAR2   := NULL
        ,p_date_required        IN  DATE       := NULL
        ,p_date_closed          IN  DATE       := NULL
        ,p_closed_by_id         IN  NUMBER     := NULL

        ,p_description          IN  VARCHAR2   := NULL
        ,p_status_overview      IN  VARCHAR2   := NULL
        ,p_resolution           IN  VARCHAR2   := NULL
        ,p_resolution_code      IN  NUMBER     := NULL
        ,p_priority_code        IN  VARCHAR2   := NULL
        ,p_effort_level_code    IN  VARCHAR2   := NULL
        ,p_open_action_num      IN  NUMBER    := NULL
        ,p_price                IN  NUMBER         := NULL
        ,p_price_currency_code  IN  VARCHAR2   := NULL
        ,p_source_type_code     IN  VARCHAR2   := NULL
        ,p_source_comment       IN  VARCHAR2   := NULL
        ,p_source_number        IN  VARCHAR2   := NULL
        ,p_source_date_received IN  DATE           := NULL
        ,p_source_organization  IN  VARCHAR2  := NULL
        ,p_source_person        IN  VARCHAR2       := NULL

        ,p_attribute_category    IN  VARCHAR2 := NULL

        ,p_attribute1            IN  VARCHAR2 := NULL
        ,p_attribute2            IN  VARCHAR2 := NULL
        ,p_attribute3            IN  VARCHAR2 := NULL
        ,p_attribute4            IN  VARCHAR2 := NULL
        ,p_attribute5            IN  VARCHAR2 := NULL
        ,p_attribute6            IN  VARCHAR2 := NULL
        ,p_attribute7            IN  VARCHAR2 := NULL
        ,p_attribute8            IN  VARCHAR2 := NULL
        ,p_attribute9            IN  VARCHAR2 := NULL
        ,p_attribute10           IN  VARCHAR2 := NULL
        ,p_attribute11           IN  VARCHAR2 := NULL
        ,p_attribute12           IN  VARCHAR2 := NULL
        ,p_attribute13           IN  VARCHAR2 := NULL
        ,p_attribute14           IN  VARCHAR2 := NULL
        ,p_attribute15           IN  VARCHAR2 := NULL

-- start: 26-Jun-2009    cklee     Modified for the Bug# 8633676
        ,p_PCO_STATUS_CODE         IN  VARCHAR2 := NULL
        ,p_APPROVAL_TYPE_CODE      IN  VARCHAR2 := NULL
        ,p_LOCKED_FLAG             IN  VARCHAR2 := 'N'
-- end: 26-Jun-2009    cklee     Modified for the Bug# 8633676

        ,p_Version_number        IN number    := null
        ,p_Current_Version_flag  IN varchar2 := 'Y'
        ,p_Version_Comments      IN varchar2 := NULL
        ,p_Original_ci_id        IN number := NULL
        ,p_Source_ci_id          IN number := NULL
		,p_change_approver       IN varchar2 := NULL
        ,x_return_status         OUT NOCOPY VARCHAR2
        ,x_msg_count             OUT NOCOPY NUMBER
        ,x_msg_data              OUT NOCOPY VARCHAR2
) is

   l_msg_index_out        NUMBER;

Line: 459


     select owner_id from pa_control_items
      where ci_id = p_ci_id;

Line: 464


  PA_DEBUG.init_err_stack('PA_CONTROL_ITEMS_PUB.UPDATE_CONTROL_ITEM');

Line: 548


       select proj_element_id
          into l_object_id
          from PA_FIN_LATEST_PUB_TASKS_V
          where element_name = p_object_name
          and project_id     = p_project_id;

Line: 569


      PA_CONTROL_ITEMS_PVT.UPDATE_CONTROL_ITEM(
         p_api_version
        ,p_init_msg_list
        ,p_commit
        ,p_validate_only
        ,p_max_msg_count

        ,p_ci_id
        ,p_ci_type_id
        ,p_summary
        ,p_status_code
        ,l_owner_id
        ,nvl(p_highlighted_flag,'N')
        ,p_progress_status_code
        ,p_progress_as_of_date
        ,p_classification_code
        ,p_reason_code
        ,p_record_version_number
        ,p_project_id
        ,l_last_modified_by_id
        ,p_object_type
        ,l_object_id
        ,p_ci_number
        ,p_date_required
        ,p_date_closed
        ,p_closed_by_id

        ,p_description
        ,p_status_overview
        ,p_resolution
        ,p_resolution_code
        ,p_priority_code
        ,p_effort_level_code
        ,p_open_action_num
        ,p_price
        ,p_price_currency_code
        ,p_source_type_code
        ,p_source_comment
        ,p_source_number
        ,p_source_date_received
        ,p_source_organization
        ,p_source_person

        ,p_attribute_category

        ,p_attribute1
        ,p_attribute2
        ,p_attribute3
        ,p_attribute4
        ,p_attribute5
        ,p_attribute6
        ,p_attribute7
        ,p_attribute8
        ,p_attribute9
        ,p_attribute10
        ,p_attribute11
        ,p_attribute12
        ,p_attribute13
        ,p_attribute14
        ,p_attribute15

-- start: 26-Jun-2009    cklee     Modified for the Bug# 8633676
        ,p_PCO_STATUS_CODE
        ,p_APPROVAL_TYPE_CODE
        ,p_LOCKED_FLAG
-- end: 26-Jun-2009    cklee     Modified for the Bug# 8633676

        ,p_Version_number
        ,p_Current_Version_flag
        ,p_Version_Comments
        ,p_Original_ci_id
        ,p_Source_ci_id
        ,p_change_approver
        ,x_return_status
        ,x_msg_count
        ,x_msg_data
       );

Line: 667


       FND_MSG_PUB.add_exc_msg ( p_pkg_name => 'PA_CONTROL_ITEMS_PUB.UPDATE_CONTROL_ITEM'
                                ,p_procedure_name => PA_DEBUG.G_Err_Stack );

Line: 672


end UPDATE_CONTROL_ITEM;

Line: 676


procedure DELETE_CONTROL_ITEM (
         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_max_msg_count        IN     NUMBER := FND_API.g_miss_num

  	,p_ci_id                IN  NUMBER
        ,p_record_version_number       IN     NUMBER
  	,x_return_status               OUT NOCOPY    VARCHAR2
  	,x_msg_count                   OUT NOCOPY    NUMBER
  	,x_msg_data                    OUT NOCOPY    VARCHAR2

) is

   l_msg_index_out        NUMBER;

Line: 702


  PA_DEBUG.init_err_stack('PA_CONTROL_ITEMS_PUB.DELETE_CONTROL_ITEM');

Line: 733


   PA_CONTROL_ITEMS_PVT.DELETE_CONTROL_ITEM(
         p_api_version
        ,p_init_msg_list
        ,p_commit
        ,p_validate_only
        ,p_max_msg_count

        ,p_ci_id
        ,p_record_version_number
        ,x_return_status
        ,x_msg_count
        ,x_msg_data
       );

Line: 768


       FND_MSG_PUB.add_exc_msg ( p_pkg_name => 'PA_CONTROL_ITEMS_PUB.DELETE_CONTROL_ITEM'
                                ,p_procedure_name => PA_DEBUG.G_Err_Stack );

Line: 774


end DELETE_CONTROL_ITEM;