eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PER_PEOPLE3_PKG dependencies on PER_PEOPLE3_PKG

Line 1: PACKAGE BODY PER_PEOPLE3_PKG AS

1: PACKAGE BODY PER_PEOPLE3_PKG AS
2: /* $Header: peper03t.pkb 120.3.12020000.2 2013/01/18 07:11:34 srannama ship $ */
3: --
4: --
5: procedure get_number_generation_property(p_business_group_id NUMBER

Line 31: ,'per_people3_pkg.get_number_generation_property');

27: exception
28: when no_data_found then
29: hr_utility.set_message('801','HR_6153_ALL_PROCEDURE_FAIL');
30: hr_utility.set_message_token('PROCEDURE'
31: ,'per_people3_pkg.get_number_generation_property');
32: hr_utility.set_message_token('STEP','2');
33: when too_many_rows then
34: hr_utility.set_message('801','HR_6153_ALL_PROCEDURE_FAIL');
35: hr_utility.set_message_token('PROCEDURE'

Line 36: ,'per_people3_pkg.get_number_generation_property');

32: hr_utility.set_message_token('STEP','2');
33: when too_many_rows then
34: hr_utility.set_message('801','HR_6153_ALL_PROCEDURE_FAIL');
35: hr_utility.set_message_token('PROCEDURE'
36: ,'per_people3_pkg.get_number_generation_property');
37: hr_utility.set_message_token('STEP','2');
38: end get_number_generation_property;
39: --
40: procedure get_legislative_ages(p_business_group_id NUMBER

Line 56: ,'per_people3_pkg.get_legislative_ages');

52: exception
53: when no_data_found then
54: hr_utility.set_message('801','HR_6153_ALL_PROCEDURE_FAIL');
55: hr_utility.set_message_token('PROCEDURE'
56: ,'per_people3_pkg.get_legislative_ages');
57: hr_utility.set_message_token('STEP','1');
58: when too_many_rows then
59: hr_utility.set_message('801','HR_6153_ALL_PROCEDURE_FAIL');
60: hr_utility.set_message_token('PROCEDURE'

Line 61: ,'per_people3_pkg.get_legislative_ages');

57: hr_utility.set_message_token('STEP','1');
58: when too_many_rows then
59: hr_utility.set_message('801','HR_6153_ALL_PROCEDURE_FAIL');
60: hr_utility.set_message_token('PROCEDURE'
61: ,'per_people3_pkg.get_legislative_ages');
62: hr_utility.set_message_token('STEP','2');
63: end get_legislative_ages;
64: --
65:

Line 154: per_people3_pkg.initialize(p_business_group_id

150: ,p_maximum_age IN OUT NOCOPY NUMBER) is
151: l_people_ddf_exists varchar2(1);
152: begin
153:
154: per_people3_pkg.initialize(p_business_group_id
155: ,p_legislation_code
156: ,p_ddf_exists
157: ,p_property_on
158: ,p_property_off

Line 184: per_people3_pkg.initialize(p_business_group_id

180: ,p_app_person_type IN OUT NOCOPY NUMBER) is
181: l_minimum_age NUMBER;
182: l_maximum_age NUMBER;
183: begin
184: per_people3_pkg.initialize(p_business_group_id
185: ,p_legislation_code
186: ,p_ddf_exists
187: ,p_property_on
188: ,p_property_off

Line 218: per_people3_pkg.get_number_generation_property(

214: begin
215: --
216: -- Get the item properties for employee and applicant number
217: --
218: per_people3_pkg.get_number_generation_property(
219: p_business_group_id => p_business_group_id
220: ,p_property_on => p_property_on
221: ,p_property_off => p_property_off
222: ,p_employee_property => p_employee_property

Line 225: per_people3_pkg.get_legislative_ages(p_business_group_id

221: ,p_property_off => p_property_off
222: ,p_employee_property => p_employee_property
223: ,p_applicant_property => p_applicant_property);
224: --
225: per_people3_pkg.get_legislative_ages(p_business_group_id
226: ,p_minimum_age
227: ,p_maximum_age);
228: --
229: -- Get the default person_type_id's for employee.

Line 231: per_people3_pkg.get_default_person_type(p_required_type => p_required_emp_type

227: ,p_maximum_age);
228: --
229: -- Get the default person_type_id's for employee.
230: --
231: per_people3_pkg.get_default_person_type(p_required_type => p_required_emp_type
232: ,p_business_group_id => p_business_group_id
233: ,p_legislation_code => p_legislation_code
234: ,p_person_type => p_emp_person_type);
235: --

Line 238: per_people3_pkg.get_default_person_type(p_required_type => p_required_app_type

234: ,p_person_type => p_emp_person_type);
235: --
236: -- Get the default person_type_id for applicant.
237: --
238: per_people3_pkg.get_default_person_type(p_required_type => p_required_app_type
239: ,p_business_group_id => p_business_group_id
240: ,p_legislation_code => p_legislation_code
241: ,p_person_type => p_app_person_type);
242: --

Line 245: per_people3_pkg.get_ddf_exists(p_legislation_code => p_legislation_code

241: ,p_person_type => p_app_person_type);
242: --
243: -- Does a ddf exisrts for this legislation?
244: --
245: per_people3_pkg.get_ddf_exists(p_legislation_code => p_legislation_code
246: ,p_ddf_exists => p_ddf_exists);
247: --
248: -- #1799586
249: per_people3_pkg.get_people_ddf_exists

Line 249: per_people3_pkg.get_people_ddf_exists

245: per_people3_pkg.get_ddf_exists(p_legislation_code => p_legislation_code
246: ,p_ddf_exists => p_ddf_exists);
247: --
248: -- #1799586
249: per_people3_pkg.get_people_ddf_exists
250: (p_legislation_code => p_legislation_code
251: ,p_people_ddf_exists => p_people_ddf_exists);
252: end initialize;
253: --

Line 461: hr_utility.set_message_token('PROCEDURE','per_people3_pkg.UPDATE_PERIOD');

457: end loop pps_loop;
458: --
459: if pps%rowcount <>1 then
460: hr_utility.set_message('801','HR_6153_ALL_PROCEDURE_FAIL');
461: hr_utility.set_message_token('PROCEDURE','per_people3_pkg.UPDATE_PERIOD');
462: hr_utility.raise_error;
463: end if;
464: --
465: close pps;

Line 852: per_people3_pkg.form_post_query(

848: l_reason_for_meaning VARCHAR2(80);
849: l_ethnic_disc_code VARCHAR2(30);
850: l_ethnic_disc_meaning VARCHAR2(80);
851: begin
852: per_people3_pkg.form_post_query(
853: p_ethnic_code
854: ,p_ethnic_meaning
855: ,p_visa_code
856: ,p_visa_meaning

Line 888: per_people3_pkg.form_post_query(

884: IS
885: l_ethnic_disc_code VARCHAR2(30);
886: l_ethnic_disc_meaning VARCHAR2(80);
887: begin
888: per_people3_pkg.form_post_query(
889: p_ethnic_code
890: ,p_ethnic_meaning
891: ,p_visa_code
892: ,p_visa_meaning

Line 926: per_people3_pkg.form_post_query(

922: ) is
923: l_vets100A_code VARCHAR2(30);
924: l_vets100A_meaning VARCHAR2(80);
925: begin
926: per_people3_pkg.form_post_query(
927: p_ethnic_code
928: ,p_ethnic_meaning
929: ,p_visa_code
930: ,p_visa_meaning

Line 1073: END per_people3_pkg;

1069: return false;
1070: end chk_events_exist;
1071: --
1072: --
1073: END per_people3_pkg;