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.AME_ACTION_SWI SQL Statements

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

Line: 692


PROCEDURE update_ame_action_type
  (p_validate                     in     number    default hr_api.g_false_num
  ,p_language_code                in     varchar2  default hr_api.userenv_lang
  ,p_action_type_id               in     number
  ,p_procedure_name               in     varchar2  default hr_api.g_varchar2
  ,p_description                  in     varchar2  default hr_api.g_varchar2
  ,p_description_query            in     varchar2  default hr_api.g_varchar2
  ,p_object_version_number        in out nocopy number
  ,p_start_date                      out nocopy date
  ,p_end_date                        out nocopy date
  ,p_return_status                   out nocopy varchar2
  ) is
  --
  -- Variables for API Boolean parameters
  l_validate                      boolean;

Line: 712


  l_proc    varchar2(72) := g_package ||'update_ame_action_type';

Line: 718


  savepoint update_ame_act_type_swi;

Line: 739


  ame_action_api.update_ame_action_type
    (p_validate                     => l_validate
    ,p_language_code                => p_language_code
    ,p_action_type_id               => p_action_type_id
    ,p_procedure_name               => p_procedure_name
    ,p_description                  => p_description
    ,p_description_query            => p_description_query
    ,p_object_version_number        => p_object_version_number
    ,p_start_date                   => p_start_date
    ,p_end_date                     => p_end_date
    );

Line: 772


    rollback to update_ame_act_type_swi;

Line: 789


    rollback to update_ame_act_type_swi;

Line: 802


end update_ame_action_type;

Line: 806


PROCEDURE update_ame_action_type_conf
  (p_validate                     in     number    default hr_api.g_false_num
  ,p_action_type_id               in     number
  ,p_application_id               in     number
  ,p_voting_regime                in     varchar2  default hr_api.g_varchar2
  ,p_chain_ordering_mode          in     varchar2  default hr_api.g_varchar2
  ,p_order_number                 in     number    default hr_api.g_number
  ,p_object_version_number        in out nocopy number
  ,p_start_date                      out nocopy date
  ,p_end_date                        out nocopy date
  ,p_return_status                   out nocopy varchar2
  ) is
  --
  -- Variables for API Boolean parameters
  l_validate                      boolean;

Line: 826


  l_proc    varchar2(72) := g_package ||'update_ame_action_type_conf';

Line: 832


  savepoint update_ame_act_type_conf_swi;

Line: 853


  ame_action_api.update_ame_action_type_conf
    (p_validate                     => l_validate
    ,p_action_type_id               => p_action_type_id
    ,p_application_id               => p_application_id
    ,p_voting_regime                => p_voting_regime
    ,p_chain_ordering_mode          => p_chain_ordering_mode
    ,p_order_number                 => p_order_number
    ,p_object_version_number        => p_object_version_number
    ,p_start_date                   => p_start_date
    ,p_end_date                     => p_end_date
    );

Line: 886


    rollback to update_ame_act_type_conf_swi;

Line: 903


    rollback to update_ame_act_type_conf_swi;

Line: 916


end update_ame_action_type_conf;

Line: 920


PROCEDURE update_ame_action
  (p_validate                     in     number    default hr_api.g_false_num
  ,p_language_code                in     varchar2  default hr_api.userenv_lang
  ,p_action_id                    in     number
  ,p_action_type_id               in     number
  ,p_parameter                    in     varchar2  default hr_api.g_varchar2
  ,p_parameter_two                in     varchar2  default hr_api.g_varchar2
  ,p_description                  in     varchar2  default hr_api.g_varchar2
  ,p_object_version_number        in out nocopy number
  ,p_start_date                      out nocopy date
  ,p_end_date                        out nocopy date
  ,p_return_status                   out nocopy varchar2
  ) is
  --
  -- Variables for API Boolean parameters
  l_validate                      boolean;

Line: 941


  l_proc    varchar2(72) := g_package ||'update_ame_action';

Line: 947


  savepoint update_ame_action_swi;

Line: 968


  ame_action_api.update_ame_action
    (p_validate                     => l_validate
    ,p_language_code                => p_language_code
    ,p_action_id                    => p_action_id
    ,p_action_type_id               => p_action_type_id
    ,p_parameter                    => p_parameter
    ,p_parameter_two                => p_parameter_two
    ,p_description                  => p_description
    ,p_object_version_number        => p_object_version_number
    ,p_start_date                   => p_start_date
    ,p_end_date                     => p_end_date
    );

Line: 1002


    rollback to update_ame_action_swi;

Line: 1019


    rollback to update_ame_action_swi;

Line: 1032


end update_ame_action;

Line: 1036


PROCEDURE delete_ame_action_type
  (p_validate                     in     number    default hr_api.g_false_num
  ,p_action_type_id               in     number
  ,p_object_version_number        in out nocopy number
  ,p_start_date                      out nocopy date
  ,p_end_date                        out nocopy date
  ,p_return_status                   out nocopy varchar2
  ) is
  --
  -- Variables for API Boolean parameters
  l_validate                      boolean;

Line: 1052


  l_proc    varchar2(72) := g_package ||'delete_ame_action_type';

Line: 1058


  savepoint delete_ame_act_type_swi;

Line: 1079


  ame_action_api.delete_ame_action_type
    (p_validate                     => l_validate
    ,p_action_type_id               => p_action_type_id
    ,p_object_version_number        => p_object_version_number
    ,p_start_date                   => p_start_date
    ,p_end_date                     => p_end_date
    );

Line: 1108


    rollback to delete_ame_act_type_swi;

Line: 1125


    rollback to delete_ame_act_type_swi;

Line: 1138


end delete_ame_action_type;

Line: 1142


PROCEDURE delete_ame_action_type_conf
  (p_validate                     in     number    default hr_api.g_false_num
  ,p_action_type_id               in     number
  ,p_application_id               in     number
  ,p_object_version_number        in out nocopy number
  ,p_start_date                      out nocopy date
  ,p_end_date                        out nocopy date
  ,p_return_status                   out nocopy varchar2
  ) is
  --
  -- Variables for API Boolean parameters
  l_validate                      boolean;

Line: 1159


  l_proc    varchar2(72) := g_package ||'delete_ame_action_type_conf';

Line: 1165


  savepoint delete_ame_act_type_conf_swi;

Line: 1186


  ame_action_api.delete_ame_action_type_conf
    (p_validate                     => l_validate
    ,p_action_type_id               => p_action_type_id
    ,p_application_id               => p_application_id
    ,p_object_version_number        => p_object_version_number
    ,p_start_date                   => p_start_date
    ,p_end_date                     => p_end_date
    );

Line: 1216


    rollback to delete_ame_act_type_conf_swi;

Line: 1233


    rollback to delete_ame_act_type_conf_swi;

Line: 1246


end delete_ame_action_type_conf;

Line: 1250


PROCEDURE delete_ame_action_type_usage
  (p_validate                     in     number    default hr_api.g_false_num
  ,p_action_type_id               in     number
  ,p_rule_type                    in     number
  ,p_object_version_number        in out nocopy number
  ,p_start_date                      out nocopy date
  ,p_end_date                        out nocopy date
  ,p_return_status                   out nocopy varchar2
  ) is
  --
  -- Variables for API Boolean parameters
  l_validate                      boolean;

Line: 1267


  l_proc    varchar2(72) := g_package ||'delete_ame_action_type_usage';

Line: 1273


  savepoint delete_ame_act_type_usg_swi;

Line: 1294


  ame_action_api.delete_ame_action_type_usage
    (p_validate                     => l_validate
    ,p_action_type_id               => p_action_type_id
    ,p_rule_type                    => p_rule_type
    ,p_object_version_number        => p_object_version_number
    ,p_start_date                   => p_start_date
    ,p_end_date                     => p_end_date
    );

Line: 1324


    rollback to delete_ame_act_type_usg_swi;

Line: 1341


    rollback to delete_ame_act_type_usg_swi;

Line: 1354


end delete_ame_action_type_usage;

Line: 1358


PROCEDURE delete_ame_appr_type_usage
  (p_validate                     in     number    default hr_api.g_false_num
  ,p_action_type_id               in     number
  ,p_approver_type_id             in     number
  ,p_object_version_number        in out nocopy number
  ,p_start_date                      out nocopy date
  ,p_end_date                        out nocopy date
  ,p_return_status                   out nocopy varchar2
  ) is
  --
  -- Variables for API Boolean parameters
  l_validate                      boolean;

Line: 1375


  l_proc    varchar2(72) := g_package ||'delete_ame_appr_type_usage';

Line: 1381


  savepoint delete_ame_appr_type_usage_swi;

Line: 1402


  ame_action_api.delete_ame_appr_type_usage
    (p_validate                     => l_validate
    ,p_action_type_id               => p_action_type_id
    ,p_approver_type_id             => p_approver_type_id
    ,p_object_version_number        => p_object_version_number
    ,p_start_date                   => p_start_date
    ,p_end_date                     => p_end_date
    );

Line: 1432


    rollback to delete_ame_appr_type_usage_swi;

Line: 1449


    rollback to delete_ame_appr_type_usage_swi;

Line: 1462


end delete_ame_appr_type_usage;

Line: 1466


PROCEDURE delete_ame_req_attribute
  (p_validate                     in     number    default hr_api.g_false_num
  ,p_action_type_id               in     number
  ,p_attribute_id                 in     number
  ,p_object_version_number        in out nocopy number
  ,p_start_date                      out nocopy date
  ,p_end_date                        out nocopy date
  ,p_return_status                   out nocopy varchar2
  ) is
  --
  -- Variables for API Boolean parameters
  l_validate                      boolean;

Line: 1483


  l_proc    varchar2(72) := g_package ||'delete_ame_req_attribute';

Line: 1489


  savepoint delete_ame_req_attribute_swi;

Line: 1510


  ame_action_api.delete_ame_req_attribute
    (p_validate                     => l_validate
    ,p_action_type_id               => p_action_type_id
    ,p_attribute_id                 => p_attribute_id
    ,p_object_version_number        => p_object_version_number
    ,p_start_date                   => p_start_date
    ,p_end_date                     => p_end_date
    );

Line: 1540


    rollback to delete_ame_req_attribute_swi;

Line: 1557


    rollback to delete_ame_req_attribute_swi;

Line: 1570


end delete_ame_req_attribute;

Line: 1574


PROCEDURE delete_ame_action
  (p_validate                     in     number    default hr_api.g_false_num
  ,p_action_id                    in     number
  ,p_action_type_id               in     number
  ,p_object_version_number        in out nocopy number
  ,p_start_date                      out nocopy date
  ,p_end_date                        out nocopy date
  ,p_return_status                   out nocopy varchar2
  ) is
  --
  -- Variables for API Boolean parameters
  l_validate                      boolean;

Line: 1591


  l_proc    varchar2(72) := g_package ||'delete_ame_action';

Line: 1597


  savepoint delete_ame_action_swi;

Line: 1618


  ame_action_api.delete_ame_action
    (p_validate                     => l_validate
    ,p_action_id                    => p_action_id
    ,p_action_type_id               => p_action_type_id
    ,p_object_version_number        => p_object_version_number
    ,p_start_date                   => p_start_date
    ,p_end_date                     => p_end_date
    );

Line: 1648


    rollback to delete_ame_action_swi;

Line: 1665


    rollback to delete_ame_action_swi;

Line: 1678


end delete_ame_action;