1 Reply Latest reply: Apr 9, 2011 10:33 AM by Hussein Sawwan-Oracle RSS

    Problem in pay_element_entryApi.update_element_entry

    TheThirdAngel
      Dear Friens, I need to update element Entry for bulk employees and using pay_element_entryApi.update_element_entry.
      I used a procedure that calls this API. when I compile the procedure it generates error

      PLS-00306: wrong number or types of arguments in call to
      'UPDATE_ELEMENT_ENTRY'.

      Please see the code following and Help me out to solve the problem


      CREATE OR REPLACE PROCEDURE ah_update_element_entry IS
      L_effective_start_date date;
      L_effective_end_date date;
      L_element_entry_id number;
      L_object_version_number number;
      L_update_warning boolean;
      L_validate boolean :=FALSE;
      L_bgid NUMBER;
      v_element_link_id number;
      v_element_pay_value_id number;
      v_object_version_number number;
      v_element_entry_id number;

      BEGIN
      fnd_profile.get('PER_BUSINESS_GROUP_ID',l_bgid);
      /*
      v_element_link_id := null;
      v_element_pay_value_id := null;
      v_object_version_number := null;
      v_element_entry_id := null;
      */
      select PEE.element_entry_id
      into v_element_entry_id
      from PAY_ELEMENT_ENTRIES_F PEE,
      PAY_ELEMENT_TYPES_F PET
      where assignment_id = 1422 --:p_assignment_id
      AND PET.ELEMENT_TYPE_ID = PEE.ELEMENT_TYPE_ID
      and to_date('05-04-2011','dd-mm-yyyy') between PEE.EFFECTIVE_start_DATE and PEE.EFFECTIVE_END_DATE
      and to_date('05-04-2011','dd-mm-yyyy') between PET.EFFECTIVE_start_DATE and PET.EFFECTIVE_END_DATE
      AND PET.ELEMENT_NAME = 'Loan Recovery';

      --v_element_pay_value_id := xx_element_hb.get_input_value_id(0,'Loan recovery','Skip This Month');


      select input_value_id
      into v_element_pay_value_id
      from pay_element_types_f pet,
      pay_input_values_f piv
      where pet.element_type_id= piv.element_type_id
      and pet.business_group_id = 0
      and upper(piv.name) like upper('Skip This Month')
      and upper(pet.element_name) = upper('Loan Recovery');



      select pt.object_version_number
      into v_object_version_number
      from pay_element_types_f pt,
      pay_element_links_f pl
      where pt.element_type_id = pl.element_type_id
      and pt.business_group_id = l_bgid
      and upper(pt.element_name) = upper('Loan Recovery');


      pAy_element_entry_api.update_element_entry
      (p_validate => FALSE
      ,p_datetrack_mode => 'UPDATE'
      ,p_effective_date => sysdate to_date('05-04-2011','dd-mm-yyyy')p_data.period
      ,p_business_group_id =>0-- l_bgid
      ,p_assignment_id => 1422--p_data.empno
      ,p_element_entry_id => 286--v_element_entry_id
      ,p_object_version_number => v_object_version_number
      ,p_input_value_id3 => v_element_pay_value_id
      ,p_entry_value3 => 'Y' --p_data.value
      ,p_effective_start_date => l_effective_start_date
      ,p_effective_end_date => l_effective_end_date
      ,p_update_warning => l_update_warning -- out nocopy boolean
      );


      EXCEPTION
      WHEN NO_DATA_FOUND THEN
      NULL;
      WHEN OTHERS THEN

      null;
      END ah_update_element_entry;


      Thanks and Anticipating a quick response
        • 1. Re: Problem in pay_element_entryApi.update_element_entry
          Hussein Sawwan-Oracle
          PLS-00306: wrong number or types of arguments in call to
          'UPDATE_ELEMENT_ENTRY'.
          Looks like you are not passing the correct number of argument (or not the correct type). Please see eTRM website for all the parameters you need to pass to this API -- http://etrm.oracle.com

          OERR: PLS-306 wrong number or types of arguments in call to '%s' [ID 27323.1]
          Troubleshooting Guide for HRMS API Errors - PLS-306 [ID 152253.1]

          Thanks,
          Hussein