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 1746: l_new_system_person_type per_person_types.system_person_type%TYPE;

1742: ,p_old_person_type_id numeric
1743: ,p_business_group_id numeric)
1744: return boolean is
1745: --
1746: l_new_system_person_type per_person_types.system_person_type%TYPE;
1747: l_old_system_person_type per_person_types.system_person_type%TYPE;
1748: l_return_status boolean;
1749: l_proc varchar2(25) := 'emp_sys_per_type_change';
1750: --

Line 1747: l_old_system_person_type per_person_types.system_person_type%TYPE;

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

Line 1755: from per_person_types

1751: -- Cursor to get the system_person_type for the 'old' person_type_id
1752: --
1753: cursor get_old_sys_per_type is
1754: select system_person_type
1755: from per_person_types
1756: where person_type_id = p_old_person_type_id
1757: and business_group_id = p_business_group_id;
1758: --
1759: begin

Line 6298: l_system_person_type per_person_types.system_person_type%TYPE;

6294: --
6295: l_proc varchar2(72) := g_package||'chk_applicant_number';
6296: l_api_updating boolean;
6297: l_gen_method per_business_groups.method_of_generation_emp_num%TYPE;
6298: l_system_person_type per_person_types.system_person_type%TYPE;
6299: l_employee_number per_all_people_f.employee_number%TYPE;
6300: l_npw_number per_all_people_f.npw_number%TYPE;
6301: l_apl_sys boolean := false;
6302: --

Line 6319: l_new_system_person_type per_person_types.system_person_type%TYPE;

6315: ,p_old_person_type_id numeric
6316: ,p_business_group_id numeric)
6317: return boolean is
6318: --
6319: l_new_system_person_type per_person_types.system_person_type%TYPE;
6320: l_old_system_person_type per_person_types.system_person_type%TYPE;
6321: l_return_status boolean;
6322: l_proc varchar2(25) := 'apl_sys_per_type_change';
6323: --

Line 6320: l_old_system_person_type per_person_types.system_person_type%TYPE;

6316: ,p_business_group_id numeric)
6317: return boolean is
6318: --
6319: l_new_system_person_type per_person_types.system_person_type%TYPE;
6320: l_old_system_person_type per_person_types.system_person_type%TYPE;
6321: l_return_status boolean;
6322: l_proc varchar2(25) := 'apl_sys_per_type_change';
6323: --
6324: -- Cursor to get the system_person_type for the 'old' person_type_id

Line 6328: from per_person_types

6324: -- Cursor to get the system_person_type for the 'old' person_type_id
6325: --
6326: cursor get_old_sys_per_type is
6327: select system_person_type
6328: from per_person_types
6329: where person_type_id = p_old_person_type_id
6330: and business_group_id = p_business_group_id;
6331: --
6332: begin

Line 7140: (c_system_person_type per_person_types.system_person_type%TYPE

7136: --
7137: -- check if future changes to system person type exist
7138: --
7139: cursor csr_chk_future_changes
7140: (c_system_person_type per_person_types.system_person_type%TYPE
7141: )
7142: is
7143: select null
7144: from sys.dual

Line 7148: per_person_types ppt

7144: from sys.dual
7145: where exists
7146: (select null
7147: from per_all_people_f ppf,
7148: per_person_types ppt
7149: where ppf.effective_start_date > p_effective_date
7150: and ppf.person_id = p_person_id
7151: and ppt.person_type_id = ppf.person_type_id
7152: and ppt.system_person_type <> c_system_person_type

Line 9195: l_system_person_type per_person_types.system_person_type%type;

9191: (p_person_type_id in out nocopy number
9192: ,p_business_group_id in number
9193: ,p_expected_sys_type in varchar2) is
9194: --
9195: l_system_person_type per_person_types.system_person_type%type;
9196: l_active_flag per_person_types.active_flag%type;
9197: l_business_group_id per_person_types.business_group_id%type;
9198: l_proc varchar2(30);
9199: --

Line 9196: l_active_flag per_person_types.active_flag%type;

9192: ,p_business_group_id in number
9193: ,p_expected_sys_type in varchar2) is
9194: --
9195: l_system_person_type per_person_types.system_person_type%type;
9196: l_active_flag per_person_types.active_flag%type;
9197: l_business_group_id per_person_types.business_group_id%type;
9198: l_proc varchar2(30);
9199: --
9200: -- Bug fix 3632363. cursor modified to improve performance.

Line 9197: l_business_group_id per_person_types.business_group_id%type;

9193: ,p_expected_sys_type in varchar2) is
9194: --
9195: l_system_person_type per_person_types.system_person_type%type;
9196: l_active_flag per_person_types.active_flag%type;
9197: l_business_group_id per_person_types.business_group_id%type;
9198: l_proc varchar2(30);
9199: --
9200: -- Bug fix 3632363. cursor modified to improve performance.
9201: cursor csr_get_default is

Line 9203: from per_person_types pet

9199: --
9200: -- Bug fix 3632363. cursor modified to improve performance.
9201: cursor csr_get_default is
9202: select pet.person_type_id
9203: from per_person_types pet
9204: where pet.system_person_type = p_expected_sys_type
9205: and pet.business_group_id = p_business_group_id
9206: and pet.active_flag = 'Y'
9207: and pet.default_flag = 'Y';

Line 9213: from per_person_types pet

9209: cursor csr_person_type is
9210: select pet.system_person_type,
9211: pet.active_flag,
9212: pet.business_group_id
9213: from per_person_types pet
9214: where pet.person_type_id = p_person_type_id;
9215: --
9216: begin
9217: if g_debug then

Line 9401: , per_person_types ppt

9397: --
9398: cursor csr_get_system_person_type is
9399: select ppt.system_person_type
9400: from per_all_people_f ppf
9401: , per_person_types ppt
9402: where p_effective_date between ppf.effective_start_date
9403: and ppf.effective_end_date
9404: and ppf.person_id = p_person_id
9405: and ppt.person_type_id = ppf.person_type_id;

Line 9412: , per_person_types ppt

9408: select null
9409: from sys.dual
9410: where exists(select null
9411: from per_all_people_f ppf
9412: , per_person_types ppt
9413: where ppf.effective_start_date between
9414: p_validation_start_date
9415: and p_validation_end_date
9416: and ppf.person_id = p_person_id