1. Get rid of all advertisements and get unlimited access to documents by upgrading to Premium Membership. Upgrade to Premium Now and also get a Premium Badge!

wrong number or types of arguments in call to 'UPDATE_EMP_ASG_CRITERIA'

Discussion in 'Oracle Apps Technical' started by jagadekara, Oct 21, 2013.

  1. jagadekara

    jagadekara Forum Guru

    Messages:
    1,126
    Likes Received:
    145
    Trophy Points:
    1,805
    Location:
    Pulivendula
    Hi all, Help me on below error. i am using Oracle apps 11i.

    Error at line 1

    ORA-06550: line 61, column 7:

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

    ORA-06550: line 61, column 7:

    PL/SQL: Statement ignored



    declare

    ld_effective_date
    date;

    ln_datetrack_update_mode
    varchar2(200);

    lv_assignment_id
    varchar2(200):=88878;

    lb_validate
    boolean;

    lb_called_from_mass_update
    boolean;

    lv_grade_id
    varchar2(200);

    lv_position_id
    varchar2(200);

    lv_job_id
    varchar2(200):='19';

    lv_payroll_id
    varchar2(200);

    lv_location_id
    varchar2(200):='1';

    lv_organization_id
    varchar2(200):='0';

    lv_pay_basis_id
    varchar2(200);

    lv_segment1
    varchar2(200);

    lv_segment2
    varchar2(200);

    lv_segment3
    varchar2(200);

    lv_segment4
    varchar2(200);

    lv_segment5
    varchar2(200);

    lv_segment6
    varchar2(200);

    lv_segment7
    varchar2(200);

    lv_segment8
    varchar2(200);

    lv_segment9
    varchar2(200);

    lv_segment10
    varchar2(200);

    lv_segment11
    varchar2(200);

    lv_segment12
    varchar2(200);

    lv_segment13
    varchar2(200);

    lv_segment14
    varchar2(200);

    lv_segment15
    varchar2(200);

    lv_segment16
    varchar2(200);

    lv_segment17
    varchar2(200);

    lv_segment18
    varchar2(200);

    lv_segment19
    varchar2(200);

    lv_segment20
    varchar2(200);

    lv_segment21
    varchar2(200);

    lv_segment22
    varchar2(200);

    lv_segment23
    varchar2(200);

    lv_segment24
    varchar2(200);

    lv_segment25
    varchar2(200);

    lv_segment26
    varchar2(200);

    lv_segment27
    varchar2(200);

    lv_segment28
    varchar2(200);

    lv_segment29
    varchar2(200);

    lv_segment30
    varchar2(200);

    lv_employment_category
    varchar2(200);

    lv_concat_segments
    varchar2(200);

    lv_grade_ladder_pgm_id
    varchar2(200);

    lv_supervisor_assignment_id
    varchar2(200);

    --out variables

    p_people_group_id
    varchar2(200);

    p_object_version_number
    varchar2(200);

    p_special_ceiling_step_id
    varchar2(200);

    p_group_name
    varchar2(200);

    p_effective_start_date
    date;

    p_effective_end_date
    date;

    p_org_now_no_manager_warning
    boolean;

    p_other_manager_warning
    boolean;

    p_spp_delete_warning
    boolean;

    p_entries_changed_warning
    varchar2(200);

    p_tax_district_changed_warning
    boolean;

    begin

    hr_assignment_api.update_emp_asg_criteria(p_effective_date =>NULL

    ,p_datetrack_update_mode =>'CORRECTION'

    ,p_assignment_id =>lv_assignment_id

    ,p_validate =>'FALSE'

    ,p_called_from_mass_update =>NULL

    ,p_grade_id =>NULL

    ,p_position_id =>NULL

    ,p_job_id =>lv_job_id

    ,p_payroll_id =>NULL

    ,p_location_id =>lv_location_id

    ,p_organization_id =>lv_organization_id

    ,p_pay_basis_id =>NULL

    ,p_segment1 =>NULL

    ,p_segment2 =>NULL

    ,p_segment3 =>NULL

    ,p_segment4 =>NULL

    ,p_segment5 =>NULL

    ,p_segment6 =>NULL

    ,p_segment7 =>NULL

    ,p_segment8 =>NULL

    ,p_segment9 =>NULL

    ,p_segment10 =>NULL

    ,p_segment11 =>NULL

    ,p_segment12 =>NULL

    ,p_segment13 =>NULL

    ,p_segment14 =>NULL

    ,p_segment15 =>NULL

    ,p_segment16 =>NULL

    ,p_segment17 =>NULL

    ,p_segment18 =>NULL

    ,p_segment19 =>NULL

    ,p_segment20 =>NULL

    ,p_segment21 =>NULL

    ,p_segment22 =>NULL

    ,p_segment23 =>NULL

    ,p_segment24 =>NULL

    ,p_segment25 =>NULL

    ,p_segment26 =>NULL

    ,p_segment27 =>NULL

    ,p_segment28 =>NULL

    ,p_segment29 =>NULL

    ,p_segment30 =>NULL

    ,p_employment_category =>NULL

    ,p_concat_segments =>NULL

    ,p_grade_ladder_pgm_id =>NULL

    ,p_supervisor_assignment_id =>NULL

    ,p_people_group_id =>p_people_group_id

    ,p_object_version_number =>p_object_version_number

    ,p_special_ceiling_step_id =>p_special_ceiling_step_id

    ,p_group_name =>p_group_name

    ,p_effective_start_date =>p_effective_start_date

    ,p_effective_end_date => p_effective_end_date

    ,p_org_now_no_manager_warning =>p_org_now_no_manager_warning

    ,p_other_manager_warning =>p_other_manager_warning

    ,p_spp_delete_warning =>p_spp_delete_warning

    ,p_entries_changed_warning =>p_entries_changed_warning

    ,p_tax_district_changed_warning =>p_tax_district_changed_warning

    );

    commit;

    dbms_output.put_line
    ('success');

    dbms_output.put_line
    ('p_people_group_id-->'||p_people_group_id);

    dbms_output.put_line
    ('p_object_version_number-->'||p_object_version_number);

    dbms_output.put_line
    ('p_special_ceiling_step_id -->'||p_special_ceiling_step_id );

    exception

    when others then

    dbms_output.put_line
    ('Error-->'|| sqlerrm);

    end;
     
  2. DTSIGuy

    DTSIGuy Forum Advisor

    Messages:
    402
    Likes Received:
    58
    Trophy Points:
    410
    Location:
    Texas
    Are you aware you have a space in the middle of this :

    p_effect ive_date =>NULL



    Just wondering...


    CJ
     
  3. jagadekara

    jagadekara Forum Guru

    Messages:
    1,126
    Likes Received:
    145
    Trophy Points:
    1,805
    Location:
    Pulivendula
    Hi
    DTSIGuy,

    Actually there is no space. I don't know why it is showing like that? When click on edit post, that time it shows without space.
     
  4. DTSIGuy

    DTSIGuy Forum Advisor

    Messages:
    402
    Likes Received:
    58
    Trophy Points:
    410
    Location:
    Texas
    I suspect you'll have to pull the Tech Ref for that pkg/proc to look at the definition to ensure your call has the right number and types...as the message says.
     
  5. Bharat

    Bharat Community Moderator Forum Guru

    Messages:
    1,747
    Likes Received:
    147
    Trophy Points:
    1,805
    Location:
    Vijayawada, India
    Hi Jagadekara,

    which field you want to update using this api ?
     
  6. jagadekara

    jagadekara Forum Guru

    Messages:
    1,126
    Likes Received:
    145
    Trophy Points:
    1,805
    Location:
    Pulivendula
    Hi Bharath,

    I am updating job_id,location_id,organization_id fields by passing assignment_id.
     
  7. Bharat

    Bharat Community Moderator Forum Guru

    Messages:
    1,747
    Likes Received:
    147
    Trophy Points:
    1,805
    Location:
    Vijayawada, India
    Hi Jagadekara,

    Have you done with this API?
     
  8. jagadekara

    jagadekara Forum Guru

    Messages:
    1,126
    Likes Received:
    145
    Trophy Points:
    1,805
    Location:
    Pulivendula
    Yes Bharat I Done that API..