Results 1 to 2 of 2
  1. #1
    Join Date
    Oct 2005
    Posts
    24

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

    hi everyone!


    when i try and run the pl sql package i ahve created i get the error in thet subject line and cannot figure it out.

    heres my code
    Code:
    CREATE OR REPLACE PACKAGE BODY APPS.xxhccWFFindReqMan AS
    
    
    PROCEDURE xxhccFindReqMan(   p_item_type            IN  VARCHAR2,
                                 p_item_key             IN  VARCHAR2,
                                 p_manager              OUT NOCOPY NUMBER) IS
    
     l_debug_mesg               varchar2(240);
     l_parent_pos            varchar2(250);
     l_employee_id            number(38);
     l_man_id                number(15);
    
    
      cursor posifinder is
     SELECT hrfg_position_hierarchies.parent_position_name
      FROM hrfg_employee_assignments hrfg_employee_assignments,
           hrfg_position_hierarchies hrfg_position_hierarchies
     WHERE ((hrfg_employee_assignments.position_id = hrfg_position_hierarchies.child_position_id(+)))
       AND (    hrfg_employee_assignments.user_assignment_status IN
                   ('Active Assignment', 'Maternity Leave', 'On Secondment',
                    'Suspend Assignment', 'Suspended')
            AND 1 = 1
           ) 
        AND hrfg_employee_assignments.person_id = l_employee_id;
        
    Cursor manfinder is
        SELECT hrfg_employee_assignments.person_id
      FROM hrfg_employee_assignments hrfg_employee_assignments,
           hrfg_position_hierarchies hrfg_position_hierarchies
     WHERE ((hrfg_employee_assignments.position_id = hrfg_position_hierarchies.child_position_id(+)))
       AND (    hrfg_employee_assignments.user_assignment_status IN
                   ('Active Assignment', 'Maternity Leave', 'On Secondment',
                    'Suspend Assignment', 'Suspended')
            AND 1 = 1
           ) 
        AND hrfg_position_hierarchies.parent_position_name =  l_parent_pos ;
    
    begin
    
         ------------------------------------------------------------
         l_debug_mesg := 'finding requestors managers position';
         ------------------------------------------------------------
            
         WF_ENGINE.SetItemAttrNumber(p_item_type,
                                     p_item_key,
                                     'REQUESTOR_ID',
                                     l_employee_id);
          open posifinder;
          fetch posifinder into l_parent_pos ;
          close posifinder;
          open manfinder;
          fetch manfinder into l_man_id;
          close manfinder;
          p_manager := l_man_id;
          return;
    
    --exception
     -- when others then
        -- The line below records this function call in the error system
        -- in the case of an exception.
       -- wf_core.context('ARP_CMREQ_WF', 'xxhccFindReqMan',
                --        null, null, null, l_debug_mesg);
       -- raise;
    end xxhccFindReqMan;
    end xxhccWFFindReqMan;

  2. #2
    Join Date
    Mar 2007
    Posts
    623
    Hi,
    Quote Originally Posted by dan_mason
    when i try and run the pl sql package i ahve created i get the error in thet subject line and cannot figure it out.
    it is nice you posted the code of package body, but the error may be spotted from the code that calls the package. The error is self-explanatory - you should call it with two VARCHAR2 constants/variables and one NUMBER variable.
    By the way, it would be sufficient to post package specification instead of its body. Also posting its entire execution from sqlplus (copy/paste) would be welcome as it directly shows Oracle response.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •