APPS.HR_CAED_SS SQL Statements

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

Line: 121

    p_deleted_emp_name    VARCHAR2 DEFAULT NULL ,
    p_deleted_emp_id      NUMBER   DEFAULT NULL ,
    p_deleted_emp_user_id NUMBER   DEFAULT NULL ,
    p_review_proc_call    VARCHAR2 DEFAULT NULL ) IS

    l_proc varchar2(200) := g_package || 'write_transaction';

Line: 160

        p_name => 'p_deleted_emp_name' ,
        p_value =>p_deleted_emp_name ) ;

Line: 192

        p_name => 'p_deleted_emp_id' ,
        p_value =>p_deleted_emp_id ) ;

Line: 198

        p_name => 'p_deleted_emp_user_id' ,
        p_value =>p_deleted_emp_user_id ) ;

Line: 228

        select hats.transaction_step_id
        from    hr_api_transaction_steps   hats
        where   hats.item_type = p_item_type
        and     hats.transaction_id = p_transaction_id
        and     hats.item_key = p_item_key ;

Line: 348

   ,p_deleted_emp_name      in   varchar2  default null
   ,p_deleted_emp_id        in   number default null
   ,p_deleted_emp_user_id   in   number default null
   ,p_review_proc_call      in   varchar2 default null
   ,p_transaction_id        out nocopy  number
   ,p_transaction_step_id   out nocopy  number)
 IS

  l_proc varchar2(200) := g_package || 'revoke_access';

Line: 398

      ,p_deleted_emp_name    => p_deleted_emp_name
      ,p_deleted_emp_id      => p_deleted_emp_id
      ,p_deleted_emp_user_id => p_deleted_emp_user_id
      ,p_review_proc_call    => p_review_proc_call
    );

Line: 430

    ln_deleted_emp_id  NUMBER ;

Line: 431

    ln_deleted_emp_user_id NUMBER ;

Line: 452

    ln_deleted_emp_id := hr_transaction_api.get_number_value(
                           p_transaction_step_id => p_transaction_step_id,
                           p_name =>'p_deleted_emp_id');

Line: 456

    ln_deleted_emp_user_id :=  hr_transaction_api.get_number_value(
                                 p_transaction_step_id =>
                                   p_transaction_step_id,
                                 p_name =>'p_deleted_emp_user_id');

Line: 464

    IF lv_action_type = 'Insert'
    THEN
       IF p_validate
       THEN
          hr_utility.set_location(l_proc,10);

Line: 484

    IF lv_action_type = 'Delete'
    THEN
       IF p_validate
       THEN
          hr_utility.set_location(l_proc,25);

Line: 495

            p_granted_user_id => ln_deleted_emp_user_id) ;