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.HR_PERSON_TYPE_USAGE_API dependencies on PER_PERSON_TYPE_USAGES_F

Line 57: l_object_version_number per_person_type_usages_f.object_version_number%TYPE;

53: --
54: -- Declare cursors and local variables
55: --
56: l_proc varchar2(72) := g_package||'update_person_type_usage';
57: l_object_version_number per_person_type_usages_f.object_version_number%TYPE;
58: l_effective_start_date per_person_type_usages_f.effective_start_date%TYPE;
59: l_effective_end_date per_person_type_usages_f.effective_end_date%TYPE;
60: l_effective_date date;
61: --

Line 58: l_effective_start_date per_person_type_usages_f.effective_start_date%TYPE;

54: -- Declare cursors and local variables
55: --
56: l_proc varchar2(72) := g_package||'update_person_type_usage';
57: l_object_version_number per_person_type_usages_f.object_version_number%TYPE;
58: l_effective_start_date per_person_type_usages_f.effective_start_date%TYPE;
59: l_effective_end_date per_person_type_usages_f.effective_end_date%TYPE;
60: l_effective_date date;
61: --
62: begin

Line 59: l_effective_end_date per_person_type_usages_f.effective_end_date%TYPE;

55: --
56: l_proc varchar2(72) := g_package||'update_person_type_usage';
57: l_object_version_number per_person_type_usages_f.object_version_number%TYPE;
58: l_effective_start_date per_person_type_usages_f.effective_start_date%TYPE;
59: l_effective_end_date per_person_type_usages_f.effective_end_date%TYPE;
60: l_effective_date date;
61: --
62: begin
63: --

Line 299: per_person_type_usages_f ptu

295: --
296: cursor current_person_type is
297: select 'Y'
298: from per_person_types ppt,
299: per_person_type_usages_f ptu
300: where ptu.person_id = p_person_id
301: and ptu.effective_start_date <= p_effective_date
302: and ptu.effective_end_date >= p_effective_date
303: and ptu.person_type_id = ppt.person_type_id

Line 388: per_person_type_usages_f ptu

384: --
385: cursor check_person_ex_type is
386: select 'Y'
387: from per_person_types ppt,
388: per_person_type_usages_f ptu
389: where ptu.person_id = p_person_id
390: and ppt.system_person_type = p_person_type
391: and ptu.effective_end_date < p_effective_date
392: and ptu.person_type_id = ppt.person_type_id

Line 394: per_person_type_usages_f ptu1

390: and ppt.system_person_type = p_person_type
391: and ptu.effective_end_date < p_effective_date
392: and ptu.person_type_id = ppt.person_type_id
393: and not exists (select 'Y' from per_person_types ppt1,
394: per_person_type_usages_f ptu1
395: where ptu1.person_id = p_person_id
396: and ppt1.system_person_type = p_person_type
397: and ptu1.effective_end_date >= p_effective_date
398: and ptu1.effective_start_date <= p_effective_date

Line 511: l_person_type_usage_id per_person_type_usages_f.person_type_usage_id%TYPE;

507: ,p_effective_end_date out nocopy date
508: ) is
509: l_proc varchar2(80) := g_package||'create_person_type_usage';
510: l_person_type per_person_types.system_person_type%TYPE;
511: l_person_type_usage_id per_person_type_usages_f.person_type_usage_id%TYPE;
512: l_effective_start_date per_person_type_usages_f.effective_start_date%TYPE;
513: l_effective_end_date per_person_type_usages_f.effective_end_date%TYPE;
514: l_object_version_number per_person_type_usages_f.object_version_number%TYPE;
515: --

Line 512: l_effective_start_date per_person_type_usages_f.effective_start_date%TYPE;

508: ) is
509: l_proc varchar2(80) := g_package||'create_person_type_usage';
510: l_person_type per_person_types.system_person_type%TYPE;
511: l_person_type_usage_id per_person_type_usages_f.person_type_usage_id%TYPE;
512: l_effective_start_date per_person_type_usages_f.effective_start_date%TYPE;
513: l_effective_end_date per_person_type_usages_f.effective_end_date%TYPE;
514: l_object_version_number per_person_type_usages_f.object_version_number%TYPE;
515: --
516: -- Setup cursor for valid person type check

Line 513: l_effective_end_date per_person_type_usages_f.effective_end_date%TYPE;

509: l_proc varchar2(80) := g_package||'create_person_type_usage';
510: l_person_type per_person_types.system_person_type%TYPE;
511: l_person_type_usage_id per_person_type_usages_f.person_type_usage_id%TYPE;
512: l_effective_start_date per_person_type_usages_f.effective_start_date%TYPE;
513: l_effective_end_date per_person_type_usages_f.effective_end_date%TYPE;
514: l_object_version_number per_person_type_usages_f.object_version_number%TYPE;
515: --
516: -- Setup cursor for valid person type check
517: --

Line 514: l_object_version_number per_person_type_usages_f.object_version_number%TYPE;

510: l_person_type per_person_types.system_person_type%TYPE;
511: l_person_type_usage_id per_person_type_usages_f.person_type_usage_id%TYPE;
512: l_effective_start_date per_person_type_usages_f.effective_start_date%TYPE;
513: l_effective_end_date per_person_type_usages_f.effective_end_date%TYPE;
514: l_object_version_number per_person_type_usages_f.object_version_number%TYPE;
515: --
516: -- Setup cursor for valid person type check
517: --
518: cursor csr_valid_person_type

Line 773: l_object_version_number per_person_type_usages_f.object_version_number%TYPE;

769: ) is
770:
771: l_proc varchar2(80) := g_package||'delete_person_type_usage';
772: l_system_person_type per_person_types.system_person_type%TYPE;
773: l_object_version_number per_person_type_usages_f.object_version_number%TYPE;
774: l_effective_start_date per_person_type_usages_f.effective_start_date%TYPE;
775: l_effective_end_date per_person_type_usages_f.effective_end_date%TYPE;
776:
777: cursor csr_ptu

Line 774: l_effective_start_date per_person_type_usages_f.effective_start_date%TYPE;

770:
771: l_proc varchar2(80) := g_package||'delete_person_type_usage';
772: l_system_person_type per_person_types.system_person_type%TYPE;
773: l_object_version_number per_person_type_usages_f.object_version_number%TYPE;
774: l_effective_start_date per_person_type_usages_f.effective_start_date%TYPE;
775: l_effective_end_date per_person_type_usages_f.effective_end_date%TYPE;
776:
777: cursor csr_ptu
778: is

Line 775: l_effective_end_date per_person_type_usages_f.effective_end_date%TYPE;

771: l_proc varchar2(80) := g_package||'delete_person_type_usage';
772: l_system_person_type per_person_types.system_person_type%TYPE;
773: l_object_version_number per_person_type_usages_f.object_version_number%TYPE;
774: l_effective_start_date per_person_type_usages_f.effective_start_date%TYPE;
775: l_effective_end_date per_person_type_usages_f.effective_end_date%TYPE;
776:
777: cursor csr_ptu
778: is
779: select ppt.system_person_type

Line 780: from per_person_type_usages_f ptu , per_person_types ppt

776:
777: cursor csr_ptu
778: is
779: select ppt.system_person_type
780: from per_person_type_usages_f ptu , per_person_types ppt
781: where ptu.person_type_usage_id = p_person_type_usage_id
782: and ptu.person_type_id = ppt.person_type_id
783: and ( p_effective_date between
784: ptu.effective_start_date and ptu.effective_end_date);