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.

[Home] [Help]

APPS.HR_SUMMARY_API2 SQL Statements

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

Line: 4


procedure update_item_type (p_item_type_id           in number
                           ,p_business_group_id      in number
                           ,p_object_version_number  in out  nocopy number
                           ,p_name                   in varchar2
                           ,p_units                  in varchar2
                           ,p_datatype               in varchar2
                           ,p_count_clause1          in varchar2
                           ,p_count_clause2          in varchar2
                           ,p_where_clause           in varchar2
                           ,p_seeded_data            in varchar2
                           ,p_allowed                in varchar2) is
begin
--
hr_utility.set_location('Entering: hr_summary_api2.update_item_type', 10);

Line: 41


hr_utility.set_location('Leaving: hr_summary_api2.update_item_type', 20);

Line: 43


end update_item_type;

Line: 45


procedure update_key_type  (p_key_type_id           in number
                           ,p_business_group_id     in number
                           ,p_object_version_number in out  nocopy number
                           ,p_name                  in varchar2
                           ,p_key_function          in varchar2
                           ,p_seeded_data           in varchar2
                           ,p_allowed               in varchar2) is
begin
--
hr_utility.set_location('Entering: hr_summary_api2.update_key_type', 10);

Line: 74


hr_utility.set_location('Leaving: hr_summary_api2.update_key_type', 20);

Line: 76


end update_key_type;

Line: 78


procedure update_key_value (p_key_value_id          in number
                           ,p_business_group_id     in number
                           ,p_object_version_number in out  nocopy number
                           ,p_key_type_id           in number
                           ,p_item_value_id         in number
                           ,p_name                  in varchar2 ) is
begin
--
hr_utility.set_location('Entering: hr_summary_api2.update_key_value', 10);

Line: 97


hr_utility.set_location('Leaving: hr_summary_api2.update_key_value', 20);

Line: 99


end update_key_value;

Line: 101


procedure update_item_value (p_item_value_id          in number
                            ,p_business_group_id      in number
                            ,p_object_version_number  in out  nocopy number
                            ,p_process_run_id         in number
                            ,p_item_type_usage_id     in number
                            ,p_textvalue              in varchar2
                            ,p_numvalue1              in number
                            ,p_numvalue2              in number
                            ,p_datevalue              in date ) is
begin
--
hr_utility.set_location('Entering: hr_summary_api2.update_item_value', 10);

Line: 126


hr_utility.set_location('Leaving: hr_summary_api2.update_item_value', 20);

Line: 128


end update_item_value;

Line: 130


procedure update_valid_restriction (p_valid_restriction_id  in number
                                   ,p_business_group_id     in number
                                   ,p_object_version_number in out  nocopy number
                                   ,p_item_type_id          in number
                                   ,p_restriction_type_id   in number
                                   ,p_seeded_data           in varchar2
                                   ,p_allowed               in varchar2) is
begin
--
hr_utility.set_location('Entering: hr_summary_api2.update_valid_restriction', 10);

Line: 159


hr_utility.set_location('Leaving: hr_summary_api2.update_valid_restriction', 20);

Line: 161


end update_valid_restriction;

Line: 163


procedure update_restriction_type  (p_restriction_type_id   in number
                                   ,p_business_group_id     in number
                                   ,p_object_version_number in out  nocopy number
                                   ,p_name                  in varchar2
                                   ,p_data_type             in varchar2
                                   ,p_restriction_clause    in varchar2
                                   ,p_restriction_sql       in varchar2
                                   ,p_seeded_data           in varchar2
                                   ,p_allowed               in varchar2) is
begin
--
hr_utility.set_location('Entering: hr_summary_api2.update_restriction_type', 10);

Line: 196


hr_utility.set_location('Leaving: hr_summary_api2.update_restriction_type', 20);

Line: 198


end update_restriction_type;

Line: 200


procedure update_restriction_usage (p_restriction_usage_id    in number
                                   ,p_business_group_id       in number
                                   ,p_object_version_number   in out  nocopy number
                                   ,p_item_type_usage_id      in number
                                   ,p_valid_restriction_id    in number
                                   ,p_restriction_type        in varchar2
                                   ,p_seeded_data             in varchar2
                                   ,p_allowed                 in varchar2) is
begin
--
hr_utility.set_location('Entering: hr_summary_api2.update_restriction_usage', 10);

Line: 231


hr_utility.set_location('Leaving: hr_summary_api2.update_restriction_usage', 20);

Line: 233


end update_restriction_usage;

Line: 235


procedure update_restriction_value ( p_restriction_value_id  in number
                                    ,p_business_group_id     in number
                                    ,p_object_version_number in out  nocopy number
                                    ,p_restriction_usage_id  in number
                                    ,p_value                 in varchar2
                                    ,p_seeded_data           in varchar2
                                    ,p_allowed               in varchar2) is
begin
--
hr_utility.set_location('Entering: hr_summary_api2.update_restriction_value', 10);

Line: 263


hr_utility.set_location('Leaving: hr_summary_api2.update_restriction_value', 20);

Line: 265


end update_restriction_value;

Line: 267


procedure update_item_type_usage ( p_item_type_usage_id     in number
                                  ,p_business_group_id      in number
                                  ,p_object_version_number  in out  nocopy number
                                  ,p_sequence_number        in number
                                  ,p_name                   in varchar2
                                  ,p_template_id            in number
                                  ,p_item_type_id           in number
                                  ,p_seeded_data            in varchar2
                                  ,p_allowed                in varchar2) is
begin
--
hr_utility.set_location('Entering: hr_summary_api2.update_item_type_usage', 10);

Line: 300


hr_utility.set_location('Leaving: hr_summary_api2.update_item_type_usage', 20);

Line: 302


end update_item_type_usage;

Line: 304


procedure update_valid_key_type (p_valid_key_type_id      in number
                                ,p_business_group_id      in number
                                ,p_object_version_number  in out  nocopy number
                                ,p_item_type_id           in number
                                ,p_key_type_id            in number
                                ,p_seeded_data            in varchar2
                                ,p_allowed                in varchar2) is
begin
--
hr_utility.set_location('Entering: hr_summary_api2.update_valid_key_type', 10);

Line: 333


hr_utility.set_location('Entering: hr_summary_api2.update_valid_key_type', 20);

Line: 335


end update_valid_key_type;

Line: 337


procedure update_key_type_usage (p_key_type_usage_id      in number
                                ,p_business_group_id      in number
                                ,p_object_version_number  in out  nocopy number
                                ,p_item_type_usage_id     in number
                                ,p_valid_key_type_id      in number
                                ,p_seeded_data            in varchar2
                                ,p_allowed                in varchar2) is
begin
--
hr_utility.set_location('Entering: hr_summary_api2.update_key_type_usage', 10);

Line: 366


hr_utility.set_location('Entering: hr_summary_api2.update_key_type_usage', 20);

Line: 368


end update_key_type_usage;

Line: 370


procedure update_template (p_template_id            in number
                          ,p_business_group_id      in number
                          ,p_object_version_number  in out  nocopy number
                          ,p_name                   in varchar2
                          ,p_seeded_data            in varchar2
                          ,p_allowed                in varchar2) is
begin
--
hr_utility.set_location('Entering: hr_summary_api2.update_template', 10);

Line: 397


hr_utility.set_location('Entering: hr_summary_api2.update_template', 20);

Line: 399


end update_template;

Line: 401


procedure update_process_run (p_process_run_id         in  number
                             ,p_business_group_id      in  number
                             ,p_object_version_number  in  out  nocopy number
                             ,p_name                   in  varchar2
                             ,p_template_id            in  varchar2
                             ,p_process_type           in  varchar2) is
begin
--
hr_utility.set_location('Entering: hr_summary_api2.update_process_run', 10);

Line: 420


hr_utility.set_location('Leaving: hr_summary_api2.update_process_run', 20);

Line: 422


end update_process_run;

Line: 424


procedure update_parameter (p_parameter_id           in  number
                           ,p_business_group_id      in  number
                           ,p_object_version_number  in  out  nocopy number
                           ,p_process_run_id         in  number
                           ,p_name                   in  varchar2
                           ,p_value                  in  varchar2) is
begin
--
hr_utility.set_location('Entering: hr_summary_api2.update_parameter', 10);

Line: 443


hr_utility.set_location('Leaving: hr_summary_api2.update_parameter', 20);

Line: 445


end update_parameter;