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_PER_BUS dependencies on PER_PERSON_TYPES

Line 93: -- Checks that the person_type_id exists in per_person_types for the

89: -- |----------------------< return_system_person_type >--------------------|
90: -- ---------------------------------------------------------------------------
91: --
92: -- Description:
93: -- Checks that the person_type_id exists in per_person_types for the
94: -- business group and returns the value of system_person_type
95: --
96: -- Pre-conditions:
97: -- None

Line 104: -- If the person_type exists in PER_PERSON_TYPES for the business

100: -- p_person_type_id
101: -- p_business_group_id
102: --
103: -- Post Success:
104: -- If the person_type exists in PER_PERSON_TYPES for the business
105: -- group then
106: -- the value of system person type is returned and processing continues
107: --
108: -- Post Failure:

Line 109: -- If the person_type does not exist in PER_PERSON_TYPES for the business

105: -- group then
106: -- the value of system person type is returned and processing continues
107: --
108: -- Post Failure:
109: -- If the person_type does not exist in PER_PERSON_TYPES for the business
110: -- group then
111: -- an application error will be raised and processing is terminated
112: --
113: -- Access Status:

Line 126: from per_person_types pet

122: l_proc varchar2(72) := g_package||'return_system_person_type';
123: --
124: cursor csr_chk_person_type is
125: select pet.system_person_type
126: from per_person_types pet
127: where p_person_type_id = pet.person_type_id
128: and p_business_group_id = pet.business_group_id + 0;
129: --
130: begin

Line 155: -- Check that the person_type exists in PER_PERSON_TYPES for the business

151: -- if so select it from the database before returning it.
152: --
153: if g_previous_sys_per_type is null then
154: --
155: -- Check that the person_type exists in PER_PERSON_TYPES for the business
156: -- group and return the system person type
157: --
158: open csr_chk_person_type;
159: fetch csr_chk_person_type into g_previous_sys_per_type;

Line 427: -- a) person_type_id exists in per_person_types for the business group

423: --
424: -- Post Success:
425: -- If the following cases are true then processing continues
426: --
427: -- a) person_type_id exists in per_person_types for the business group
428: --
429: -- b) system_person_type is one of:
430: -- APL, APL_EX_APL, EMP, EMP_APL, EX_APL, EX_EMP, EX_EMP_APL, OTHER
431: --

Line 455: -- a) person_type_id does not exist in per_person_types for the business

451: -- Post Failure:
452: -- If any of the following cases are true then
453: -- an application error will be raised and processing is terminated
454: --
455: -- a) person_type_id does not exist in per_person_types for the business
456: -- group, or is not active
457: --
458: -- b) system_person_type is not as specified in (b) above.
459: --

Line 494: l_business_group_id per_person_types.business_group_id%type;

490: l_api_updating boolean;
491: l_current_employee_flag varchar2(1);
492: l_current_applicant_flag varchar2(1);
493: l_current_emp_or_apl_flag varchar2(1);
494: l_business_group_id per_person_types.business_group_id%type;
495: l_active_flag per_person_types.active_flag%type;
496: l_discard_varchar2 varchar2(100);
497: l_discard_number number;
498: l_original_sys_type per_person_types.system_person_type%type;

Line 495: l_active_flag per_person_types.active_flag%type;

491: l_current_employee_flag varchar2(1);
492: l_current_applicant_flag varchar2(1);
493: l_current_emp_or_apl_flag varchar2(1);
494: l_business_group_id per_person_types.business_group_id%type;
495: l_active_flag per_person_types.active_flag%type;
496: l_discard_varchar2 varchar2(100);
497: l_discard_number number;
498: l_original_sys_type per_person_types.system_person_type%type;
499: --

Line 498: l_original_sys_type per_person_types.system_person_type%type;

494: l_business_group_id per_person_types.business_group_id%type;
495: l_active_flag per_person_types.active_flag%type;
496: l_discard_varchar2 varchar2(100);
497: l_discard_number number;
498: l_original_sys_type per_person_types.system_person_type%type;
499: --
500: cursor
501: csr_person_type(l_person_type_id in per_all_people_f.person_type_id%type) is
502: select pet.system_person_type,

Line 505: from per_person_types pet

501: csr_person_type(l_person_type_id in per_all_people_f.person_type_id%type) is
502: select pet.system_person_type,
503: pet.business_group_id,
504: pet.active_flag
505: from per_person_types pet
506: where l_person_type_id = pet.person_type_id;
507: --
508: /*
509: cursor csr_system_type(l_start_date in date) is

Line 512: per_person_types pet

508: /*
509: cursor csr_system_type(l_start_date in date) is
510: select pet.system_person_type
511: from per_all_people_f per,
512: per_person_types pet
513: where per.person_id = p_person_id
514: and l_start_date between per.effective_start_date
515: and per.effective_end_date
516: and pet.person_type_id = per.person_type_id;

Line 580: -- Check if the person type id exists in per_person_types for the business

576: (NOT l_api_updating)) then
577: --
578: -- Perform Insert/Update Checks
579: --
580: -- Check if the person type id exists in per_person_types for the business
581: -- group
582: --
583: open csr_person_type(p_person_type_id);
584: fetch csr_person_type

Line 1750: l_new_system_person_type per_person_types.system_person_type%TYPE;

1746: ,p_old_person_type_id numeric
1747: ,p_business_group_id numeric)
1748: return boolean is
1749: --
1750: l_new_system_person_type per_person_types.system_person_type%TYPE;
1751: l_old_system_person_type per_person_types.system_person_type%TYPE;
1752: l_return_status boolean;
1753: l_proc varchar2(25) := 'emp_sys_per_type_change';
1754: --

Line 1751: l_old_system_person_type per_person_types.system_person_type%TYPE;

1747: ,p_business_group_id numeric)
1748: return boolean is
1749: --
1750: l_new_system_person_type per_person_types.system_person_type%TYPE;
1751: l_old_system_person_type per_person_types.system_person_type%TYPE;
1752: l_return_status boolean;
1753: l_proc varchar2(25) := 'emp_sys_per_type_change';
1754: --
1755: -- Cursor to get the system_person_type for the 'old' person_type_id

Line 1759: from per_person_types

1755: -- Cursor to get the system_person_type for the 'old' person_type_id
1756: --
1757: cursor get_old_sys_per_type is
1758: select system_person_type
1759: from per_person_types
1760: where person_type_id = p_old_person_type_id
1761: and business_group_id = p_business_group_id;
1762: --
1763: begin

Line 6309: l_system_person_type per_person_types.system_person_type%TYPE;

6305: --
6306: l_proc varchar2(72) := g_package||'chk_applicant_number';
6307: l_api_updating boolean;
6308: l_gen_method per_business_groups.method_of_generation_emp_num%TYPE;
6309: l_system_person_type per_person_types.system_person_type%TYPE;
6310: l_employee_number per_all_people_f.employee_number%TYPE;
6311: l_npw_number per_all_people_f.npw_number%TYPE;
6312: l_apl_sys boolean := false;
6313: --

Line 6330: l_new_system_person_type per_person_types.system_person_type%TYPE;

6326: ,p_old_person_type_id numeric
6327: ,p_business_group_id numeric)
6328: return boolean is
6329: --
6330: l_new_system_person_type per_person_types.system_person_type%TYPE;
6331: l_old_system_person_type per_person_types.system_person_type%TYPE;
6332: l_return_status boolean;
6333: l_proc varchar2(25) := 'apl_sys_per_type_change';
6334: --

Line 6331: l_old_system_person_type per_person_types.system_person_type%TYPE;

6327: ,p_business_group_id numeric)
6328: return boolean is
6329: --
6330: l_new_system_person_type per_person_types.system_person_type%TYPE;
6331: l_old_system_person_type per_person_types.system_person_type%TYPE;
6332: l_return_status boolean;
6333: l_proc varchar2(25) := 'apl_sys_per_type_change';
6334: --
6335: -- Cursor to get the system_person_type for the 'old' person_type_id

Line 6339: from per_person_types

6335: -- Cursor to get the system_person_type for the 'old' person_type_id
6336: --
6337: cursor get_old_sys_per_type is
6338: select system_person_type
6339: from per_person_types
6340: where person_type_id = p_old_person_type_id
6341: and business_group_id = p_business_group_id;
6342: --
6343: begin

Line 7151: (c_system_person_type per_person_types.system_person_type%TYPE

7147: --
7148: -- check if future changes to system person type exist
7149: --
7150: cursor csr_chk_future_changes
7151: (c_system_person_type per_person_types.system_person_type%TYPE
7152: )
7153: is
7154: select null
7155: from sys.dual

Line 7159: per_person_types ppt

7155: from sys.dual
7156: where exists
7157: (select null
7158: from per_all_people_f ppf,
7159: per_person_types ppt
7160: where ppf.effective_start_date > p_effective_date
7161: and ppf.person_id = p_person_id
7162: and ppt.person_type_id = ppf.person_type_id
7163: and ppt.system_person_type <> c_system_person_type

Line 9206: l_system_person_type per_person_types.system_person_type%type;

9202: (p_person_type_id in out nocopy number
9203: ,p_business_group_id in number
9204: ,p_expected_sys_type in varchar2) is
9205: --
9206: l_system_person_type per_person_types.system_person_type%type;
9207: l_active_flag per_person_types.active_flag%type;
9208: l_business_group_id per_person_types.business_group_id%type;
9209: l_proc varchar2(30);
9210: --

Line 9207: l_active_flag per_person_types.active_flag%type;

9203: ,p_business_group_id in number
9204: ,p_expected_sys_type in varchar2) is
9205: --
9206: l_system_person_type per_person_types.system_person_type%type;
9207: l_active_flag per_person_types.active_flag%type;
9208: l_business_group_id per_person_types.business_group_id%type;
9209: l_proc varchar2(30);
9210: --
9211: -- Bug fix 3632363. cursor modified to improve performance.

Line 9208: l_business_group_id per_person_types.business_group_id%type;

9204: ,p_expected_sys_type in varchar2) is
9205: --
9206: l_system_person_type per_person_types.system_person_type%type;
9207: l_active_flag per_person_types.active_flag%type;
9208: l_business_group_id per_person_types.business_group_id%type;
9209: l_proc varchar2(30);
9210: --
9211: -- Bug fix 3632363. cursor modified to improve performance.
9212: cursor csr_get_default is

Line 9214: from per_person_types pet

9210: --
9211: -- Bug fix 3632363. cursor modified to improve performance.
9212: cursor csr_get_default is
9213: select pet.person_type_id
9214: from per_person_types pet
9215: where pet.system_person_type = p_expected_sys_type
9216: and pet.business_group_id = p_business_group_id
9217: and pet.active_flag = 'Y'
9218: and pet.default_flag = 'Y';

Line 9224: from per_person_types pet

9220: cursor csr_person_type is
9221: select pet.system_person_type,
9222: pet.active_flag,
9223: pet.business_group_id
9224: from per_person_types pet
9225: where pet.person_type_id = p_person_type_id;
9226: --
9227: begin
9228: if g_debug then

Line 9415: , per_person_types ppt

9411: --
9412: cursor csr_get_system_person_type is
9413: select ppt.system_person_type
9414: from per_all_people_f ppf
9415: , per_person_types ppt
9416: where p_effective_date between ppf.effective_start_date
9417: and ppf.effective_end_date
9418: and ppf.person_id = p_person_id
9419: and ppt.person_type_id = ppf.person_type_id;

Line 9426: , per_person_types ppt

9422: select null
9423: from sys.dual
9424: where exists(select null
9425: from per_all_people_f ppf
9426: , per_person_types ppt
9427: where ppf.effective_start_date between
9428: p_validation_start_date
9429: and p_validation_end_date
9430: and ppf.person_id = p_person_id