| how can i use of HR_POSITION_API.create_position [message #168772] |
Sat, 22 April 2006 08:22 |
azadehfar
Messages: 10
Registered: April 2006
Location: iran
|
Junior Member |
|
|
i writed this code for enddate before position and create a new line by same position name
i want change old position (enddate) and create a new line by same values(some attribute change)
but give me error "ORA-06550: line 7, column 1:
PLS-00306: wrong number or types of arguments in call to 'CREATE_POSITION'
ORA-06550: line 7, column 1:
PL/SQL: Statement ignored
"
code:
declare
v_position_id number;
v_object_version_number number;
v_position_definition_id NUMBER;
v_name varchar2(50);
begin
HR_POSITION_API.create_position(p_validate =>false, p_job_id =>72 , p_organization_id=>286 , p_date_effective=>to_date('1/1/1900','MM/DD/RRRR'), p_position_definition_id=> 2801,
p_position_id => v_position_id , p_object_version_number =>v_object_version_number , p_position_definition_id=>v_position_definition_id , p_name=> v_name );
commit;
dbms_output.put_line(v_name);
end;
can do u please help me?
tnx
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
