[Home] [Help]
1: package body PER_APPLICANT_PKG as
2: /* $Header: peper02t.pkb 120.1 2005/11/10 13:07:05 kramajey noship $ */
3: --
4: -- PRIVATE PROCEDURES
5: --
385: begin
386: --
387: --Create the PERSON record
388: --
389: hr_utility.set_location('PER_APPLICANT_PKG.INSERT_ROW' , 1 ) ;
390: if ( p_method_of_apl_num_gen = 'A' and p_applicant_number is null) then
391: hr_person.generate_number( p_current_employee => 'N',
392: p_current_applicant => 'Y',
393: p_current_npw => 'N',
731: -- **************************
732: -- Create the ADDRESS record
733: -- **************************
734: l_dummy_number := NULL ;
735: hr_utility.set_location('PER_APPLICANT_PKG.INSERT_ROW' , 2 ) ;
736: per_addresses_pkg.insert_row(
737: p_row_id => l_dummy_varchar2
738: ,p_address_id => l_dummy_number
739: ,p_business_group_id => p_business_group_id
811: end if ;
812: --
813: l_application_id := NULL ;
814: l_dummy_varchar2 := NULL ;
815: hr_utility.set_location('PER_APPLICANT_PKG.INSERT_ROW' , 3 ) ;
816: per_applications_pkg.Insert_Row(p_Rowid => l_dummy_varchar2,
817: p_Application_Id => l_application_id,
818: p_Business_Group_Id => p_business_group_id,
819: p_Person_Id => p_person_id,
854: --
855: -- Create the ASSIGNMENT record
856: --
857: --
858: hr_utility.set_location('PER_APPLICANT_PKG.INSERT_ROW' , 4 ) ;
859: l_dummy_number := NULL ;
860: l_dummy_varchar2 := NULL ;
861: --
862: -- Set the end date of the assignment if the status is TERM_APL
1002: l_assignment_id,
1003: p_effective_start_date => p_date_received,
1004: p_effective_end_date => l_asg_end_date) ;
1005: --
1006: hr_utility.set_location('PER_APPLICANT_PKG.INSERT_ROW' , 5 ) ;
1007: update_group ( p_people_group_id,
1008: p_people_group_name ) ;
1009: --
1010: -- Create letter request
1403: from per_business_groups pbg
1404: where business_group_id = p_business_group_id ;
1405: begin
1406: --
1407: hr_utility.set_location('PER_APPLICANT_PKG.GET_DB_DEFAULT_VALUES' , 1 ) ;
1408: -- Retrieve the person type for a system person type of APL
1409: open c1 ;
1410: fetch c1 into p_person_type_id,
1411: p_system_person_type ;
1773: and P_GROUP_NAME is not null; -- 4103321
1774: --
1775: if sql%rowcount = 0 then
1776: fnd_message.set_name('PAY','HR_6153_ALL_PROCEDURE_FAIL' );
1777: fnd_message.set_token('PROCEDURE','PER_APPLICANT_PKG.UPDATE_GROUP');
1778: fnd_message.set_token('STEP','1' ) ;
1779: fnd_message.raise_error ;
1780: end if ;
1781: end if;
2208: return(l_return_value);
2209: --
2210: end get_style_name;
2211: --
2212: end PER_APPLICANT_PKG ;