Home > Ora 20001 System > Hr_assignment_api.update_emp_asg Error

Hr_assignment_api.update_emp_asg Error

Technology and Trends Enterprise Architecture and EAI ERP Hardware IT Management and Strategy Java Knowledge Management Linux Networking Oracle PeopleSoft Project and Portfolio Management hr_assignment_api.update_emp_asg_criteria example SAP SCM Security Siebel Storage UNIX Visual Basic Web Design and Development

Hr_assignment_api.update_emp_asg_criteria Mandatory Parameters

Windows < Back CHOOSE A DISCUSSION GROUP Research Directory TOPICS Database Hardware Networking SAP Security Web Design MEMBERS Paul_Pedant

Hr_assignment_api.update_emp_asg Parameters

DACREE MarkDeVries MacProTX Inside-ERP VoIP_News Inside-CRM I_am_the_dragon maxwellarnold Michael Meyers-Jouan TerryCurran Chris_Day Ramnath.Awate JoeTorre Andrew.S.Baker bracke Locutus Dennis Stevenson Craig Borysowich Richard DukeGanote mircea_luca iudithm Clinton Jones Nikki Klein AbhaiTripathi

Ora-20001: System Error: Procedure Hr_assignment_api.validate_scl At Step 6

Iqbalyk bluesguyAZ59 blrvenkat jakarman COMPANIES Compuware SendGrid Webroot Evault View All Topics View All Members View All Companies Toolbox for IT Topics Oracle Groups Ask a New Question Oracle Applications Your premier resource for objective technical discussion and peer-to-peer support on Oracle Applications. Home | Invite Peers | More Oracle Groups Your account is ready. You're now being signed in. ora-20001: system error: procedure at step 40 Solve problems - It's Free Create your account in seconds E-mail address is taken If this is your account,sign in here Email address Username Between 5 and 30 characters. No spaces please The Profile Name is already in use Password Notify me of new activity in this group: Real Time Daily Never Keep me informed of the latest: White Papers Newsletter Jobs By clicking "Join Now", you agree to Toolbox for Technology terms of use, and have read and understand our privacy policy. hr assignment api.update emp asg criteria error DURANCE asked Nov 14, 2009 | Replies (14) Hi all, I am trying to update the emp assignment using the api. But i get the error, ORA-06550: line 18, column 4: PLS-00306: wrong number or types of arguments in call to 'UPDATE_EMP_ASG_CRITERIA' ORA-06550: line 18, column 4: PL/SQL: Statement ignored This is my code, what is wrong i couldnt find what is wrong in these, Please help. DECLARE l_people_group_id number; l_object_version_number number; l_special_ceiling_step_id number; l_group_name varchar2(50); l_effective_start_date date; l_effective_end_date date; l_org_now_no_manager_warning boolean; l_other_manager_warning boolean; l_spp_delete_warning boolean; l_entries_changed_warning varchar2(50); l_tax_district_changed_warning boole

Help Who's Online 0 registered (), 7 Guests and 17 Spiders online. Key: Admin, Global Mod, Mod Newest Members donkey, Reydin ora-20001: you must enter a legal employer for this assignment Cardenas, Azam, HRSOFTWARE, Ade 1208 Registered Users Recent Posts Help plz update ora-20001 the supervisor should be an employee delegate userhook issue by Ahmed Helmy Today at 12:02 PM Element Attribution by CT 12/10/16 12:57 PM ora-20001: the primary key specified is invalid RTI Starter Date for PAYE change records by ClanGowland 12/10/16 12:07 PM Custom Security Profile by bcooper 04/10/16 02:04 PM Who to contact reference pay/tax issues by Ade 01/10/16 http://oracle.ittoolbox.com/groups/technical-functional/oracle-apps-l/hr_assignment_apiupdate_emp_asg_criteria-error-3123266 09:05 AM Vacation Rule For Leave of absence notification by shaheryar 30/09/16 09:55 AM BEE enter absence no time_start / time_end fields by Alex 23/09/16 10:43 AM Online Payslips in PDF format by delboy 20/09/16 01:04 PM National Minimum Wage by Vigneswar Battu 20/09/16 10:18 AM HMRC migrating from EDI to XML for RTI by BRIAN_D 20/09/16 09:39 AM http://www.hcmaces.com/forums/ubbthreads7/ubbthreads.php/topics/8678/hr_assignment_api.update_emp_a Top Posters (30 Days) bcooper 3 Bobin 3 ClanGowland 3 Vigneswar Battu 2 Ade 2 BRIAN_D 2 delboy 2 CT 2 Ahmed Helmy 1 SBi 1 (Views)Popular Topics Pension Auto Enrolment 3,555,715 PAYE RTI 332,622 New PCSPS regime for 2015 - Alpha, Compendia etc 94,654 Family Pack K issues thread 66,312 CREATE_GRADE api returns:PLS-00306: wrong number o 55,118 Enhanced Retro & Release 12 53,697 Still trying to locate... 47,244 Creating hr jobs ORA-20001: HR_289477_JOB_GROUP_ID 46,417 Adding a taskflow button to a form 45,141 HR_PF.K RUP4 42,217 Topic Options Rate This Topic #8678 - 01/10/12 09:18 AM hr_assignment_api.update_emp_asg dan newbie Registered: 03/06/11 Posts: 12 Hi,we are looking at setting up supervisors for our staff. currently we do not have supervisors loaded for any assignments but have a table with this information in. I have the loop to go through the assignments but cannot get the hr_assignment_api.update_emp_asg to work. it gives me an error saying invalid arguments. do i have to pass something for every paramenter when all i want to do is insert a

Schedule, Normal Hours, Frequency, Time Normal Finish, Time Normal Start, Default Code Combination, Set of Books Id API --hr_assignment_api.update_emp_asg To Update Employee -------------------------- Grade, Location, Job, Payroll, Organization, Employee Category, People Group API --hr_assignment_api.update_emp_asg_criteria Staging Table ----------------- CREATE TABLE APPS.XXAT_EMP_ASSIGNMENTS ( EMP_NUM NUMBER, ORG_NAME VARCHAR2(2000 BYTE), GCC_GROUP http://sajshan.blogspot.com/2014/03/oracle-hrms-api-update-employee.html VARCHAR2(1000 BYTE), POSITION VARCHAR2(2000 BYTE), JOB VARCHAR2(2000 BYTE), PAYROLL VARCHAR2(2000 BYTE), LOCATION VARCHAR2(2000 BYTE), STATUS VARCHAR2(2000 BYTE), SAL_BASIS VARCHAR2(2000 BYTE), SUPERVISOR_NUM NUMBER, GOSI_EMP VARCHAR2(1000 BYTE), PROCESS_FLAG VARCHAR2(1 BYTE), ERROR_MSG VARCHAR2(3000 BYTE) ); Flat File Format ------------------------------ Emp Num Organization GCC Group Position Job Payroll Location Status ora-20001: system Salary Basis Supervisor Number GOSI - Employer Process Flag Error Message 3 Chief Business Support Office No.No.Yes Chief Business Support Officer.Chief Business Support Office Chief Business Support Officer EATC Payroll Riyadh Head Office Active Assignment EATC Monthly Salary 911 Etihad Atheeb Telecommunication Company N Sample Code - Example ------------------------------ Package Specification -------------------------- CREATE OR REPLACE PACKAGE APPS.xxat_emp_assign_pkg AS PROCEDURE xxxat_emp_assign_update; END xxat_emp_assign_pkg; Package Body ---------------- CREATE OR REPLACE PACKAGE BODY APPS.xxat_emp_assign_pkg AS PROCEDURE xxxat_emp_assign_update IS -- lc_c_emp_assg ora-20001: system error: c_emp_assg%ROWTYPE; l_object_version_number NUMBER; l_special_ceiling_step_id NUMBER; l_people_group_id NUMBER; l_soft_coding_keyflex_id NUMBER; l_supervisor_id NUMBER; l_assg_id NUMBER; l_group_name VARCHAR2 (100); l_effective_start_date DATE; l_effective_end_date DATE; l_org_now_no_manager_warning BOOLEAN; l_other_manager_warning BOOLEAN; l_no_managers_warning BOOLEAN; l_spp_delete_warning BOOLEAN; l_entries_changed_warning VARCHAR2 (100); l_tax_district_changed_warning BOOLEAN; l_concatenated_segments VARCHAR2 (100); l_gsp_post_process_warning VARCHAR2 (100); l_job_id VARCHAR2 (20); l_position_id VARCHAR2 (20); l_grade_id VARCHAR2 (20); l_org_id VARCHAR2 (20); l_loc_id VARCHA

 
No related pages.