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

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

Line: 20


  ,p_appl_update_process            in      varchar2 default NULL
  ,p_appl_validation_process        in      varchar2 default NULL
  ,p_appl_period_function           in      varchar2 default NULL
  ,p_appl_dyn_template_process      in      varchar2 default NULL
  ,p_extension_function1            in      varchar2 default NULL
  ,p_extension_function2            in      varchar2 default NULL
  ) is
  --
  -- Declare cursors and local variables
  --
	l_proc varchar2(72);

Line: 60


          ,p_appl_update_process        => p_appl_update_process
          ,p_appl_validation_process    => p_appl_validation_process
          ,p_appl_period_function       => p_appl_period_function
          ,p_appl_dyn_template_process  => p_appl_dyn_template_process
          ,p_extension_function1        => p_extension_function1
          ,p_extension_function2        => p_extension_function2
  );

Line: 92


  ,p_appl_update_process        => p_appl_update_process
  ,p_appl_validation_process    => p_appl_validation_process
  ,p_appl_period_function       => p_appl_period_function
  ,p_appl_dyn_template_process  => p_appl_dyn_template_process
  ,p_extension_function1        => p_extension_function1
  ,p_extension_function2        => p_extension_function2
  ,p_time_recipient_id          => l_time_recipient_id
  ,p_application_id             => p_application_id
  ,p_object_version_number      => l_object_version_number );

Line: 115


          ,p_appl_update_process        => p_appl_update_process
          ,p_appl_validation_process    => p_appl_validation_process
          ,p_appl_period_function       => p_appl_period_function
          ,p_appl_dyn_template_process  => p_appl_dyn_template_process
          ,p_extension_function1        => p_extension_function1
          ,p_extension_function2        => p_extension_function2
  );

Line: 185


procedure update_time_recipient
  (p_validate                       in      boolean   default false
  ,p_time_recipient_id              in      hxc_time_recipients.time_recipient_id%TYPE
  ,p_application_id                 in      hxc_time_recipients.application_id%TYPE
  ,p_object_version_number          in  out nocopy hxc_time_recipients.object_version_number%TYPE
  ,p_name                           in      hxc_time_recipients.name%TYPE
  ,p_appl_retrieval_function        in      varchar2 default NULL
  ,p_appl_update_process            in      varchar2 default NULL
  ,p_appl_validation_process        in      varchar2 default NULL
  ,p_appl_period_function           in      varchar2 default NULL
  ,p_appl_dyn_template_process      in      varchar2 default NULL
  ,p_extension_function1            in      varchar2 default NULL
  ,p_extension_function2            in      varchar2 default NULL
  ) is
  --
  -- Declare cursors and local variables
  --
	l_proc varchar2(72);

Line: 209


  	l_proc := g_package||' update_time_recipient';

Line: 215


  savepoint update_time_recipient;

Line: 224


    hxc_time_recipient_BK_2.update_time_recipient_b
	  (p_time_recipient_id          => p_time_recipient_id
	  ,p_application_id             => p_application_id
	  ,p_object_version_number      => p_object_version_number
	  ,p_name                       => p_name
          ,p_appl_retrieval_function    => p_appl_retrieval_function
          ,p_appl_update_process        => p_appl_update_process
          ,p_appl_validation_process    => p_appl_validation_process
          ,p_appl_period_function       => p_appl_period_function
          ,p_appl_dyn_template_process  => p_appl_dyn_template_process
          ,p_extension_function1        => p_extension_function1
          ,p_extension_function2        => p_extension_function2
  );

Line: 240


        (p_module_name => 'update_time_recipient'
        ,p_hook_type   => 'BP'
        );

Line: 257


  ,p_appl_update_process        => p_appl_update_process
  ,p_appl_validation_process    => p_appl_validation_process
  ,p_appl_period_function       => p_appl_period_function
  ,p_appl_dyn_template_process  => p_appl_dyn_template_process
  ,p_extension_function1        => p_extension_function1
  ,p_extension_function2        => p_extension_function2
  ,p_time_recipient_id          => p_time_recipient_id
  ,p_application_id             => p_application_id
  ,p_object_version_number      => l_object_version_number );

Line: 275


    hxc_time_recipient_BK_2.update_time_recipient_a
	  (p_time_recipient_id          => p_time_recipient_id
	  ,p_application_id             => p_application_id
	  ,p_object_version_number      => l_object_version_number
	  ,p_name                       => p_name
          ,p_appl_retrieval_function    => p_appl_retrieval_function
          ,p_appl_update_process        => p_appl_update_process
          ,p_appl_validation_process    => p_appl_validation_process
          ,p_appl_period_function       => p_appl_period_function
          ,p_appl_dyn_template_process  => p_appl_dyn_template_process
          ,p_extension_function1        => p_extension_function1
          ,p_extension_function2        => p_extension_function2
  );

Line: 291


        (p_module_name => 'update_time_recipient'
        ,p_hook_type   => 'AP'
        );

Line: 321


    ROLLBACK TO update_time_recipient;

Line: 340


    ROLLBACK TO update_time_recipient;

Line: 343


END update_time_recipient;

Line: 349


procedure delete_time_recipient
  (p_validate                       in  boolean  default false
  ,p_time_recipient_id              in  hxc_time_recipients.time_recipient_id%TYPE
  ,p_object_version_number          in  hxc_time_recipients.object_version_number%TYPE
  ) is
  --
  -- Declare cursors and local variables
  --
  l_proc varchar2(72);

Line: 363


  	l_proc := g_package||'delete_time_recipient';

Line: 369


  savepoint delete_time_recipient;

Line: 379


    hxc_time_recipient_BK_3.delete_time_recipient_b
	  (p_time_recipient_id            => p_time_recipient_id
	  ,p_object_version_number => p_object_version_number
	  );

Line: 386


        (p_module_name => 'delete_time_recipient_b'
        ,p_hook_type   => 'BP'
        );

Line: 411


  hxc_time_recipient_BK_3.delete_time_recipient_a
	  (p_time_recipient_id            => p_time_recipient_id
	  ,p_object_version_number => p_object_version_number
	  );

Line: 418


        (p_module_name => 'delete_time_recipient_a'
        ,p_hook_type   => 'AP'
        );

Line: 440


    ROLLBACK TO delete_time_recipient;

Line: 446


    ROLLBACK TO delete_time_recipient;

Line: 449


end delete_time_recipient;