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_NMF_SYNC dependencies on PER_ALL_PEOPLE_F

Line 404: Purpose : rebuilds the person names in per_all_people_f depending on

400: --
401: /* ========================================================================
402: Name : sync_person_names
403: ========================================================================
404: Purpose : rebuilds the person names in per_all_people_f depending on
405: parameters being passed.
406: Returns : nothing, it updates the table with newly constructed names.
407: -----------------------------------------------------------------------*/
408: procedure sync_person_names

Line 423: l_new_name per_all_people_f.full_name%TYPE;

419: l_pkg_name varchar2(80);
420: l_proc_name varchar2(80);
421:
422:
423: l_new_name per_all_people_f.full_name%TYPE;
424: l_full_name per_all_people_f.full_name%TYPE;
425: l_order_name per_all_people_f.order_name%TYPE;
426: l_local_name per_all_people_f.local_name%TYPE;
427: l_global_name per_all_people_f.global_name%TYPE;

Line 424: l_full_name per_all_people_f.full_name%TYPE;

420: l_proc_name varchar2(80);
421:
422:
423: l_new_name per_all_people_f.full_name%TYPE;
424: l_full_name per_all_people_f.full_name%TYPE;
425: l_order_name per_all_people_f.order_name%TYPE;
426: l_local_name per_all_people_f.local_name%TYPE;
427: l_global_name per_all_people_f.global_name%TYPE;
428: l_name_changed boolean;

Line 425: l_order_name per_all_people_f.order_name%TYPE;

421:
422:
423: l_new_name per_all_people_f.full_name%TYPE;
424: l_full_name per_all_people_f.full_name%TYPE;
425: l_order_name per_all_people_f.order_name%TYPE;
426: l_local_name per_all_people_f.local_name%TYPE;
427: l_global_name per_all_people_f.global_name%TYPE;
428: l_name_changed boolean;
429: --

Line 426: l_local_name per_all_people_f.local_name%TYPE;

422:
423: l_new_name per_all_people_f.full_name%TYPE;
424: l_full_name per_all_people_f.full_name%TYPE;
425: l_order_name per_all_people_f.order_name%TYPE;
426: l_local_name per_all_people_f.local_name%TYPE;
427: l_global_name per_all_people_f.global_name%TYPE;
428: l_name_changed boolean;
429: --
430: --

Line 427: l_global_name per_all_people_f.global_name%TYPE;

423: l_new_name per_all_people_f.full_name%TYPE;
424: l_full_name per_all_people_f.full_name%TYPE;
425: l_order_name per_all_people_f.order_name%TYPE;
426: l_local_name per_all_people_f.local_name%TYPE;
427: l_global_name per_all_people_f.global_name%TYPE;
428: l_name_changed boolean;
429: --
430: --
431: begin

Line 657: -- Update per_all_people_f table with new names

653: end loop;
654: end if;
655: end if; -- all stored names, all user format choice options
656: -- ---------------------------------------------------------------------
657: -- Update per_all_people_f table with new names
658: -- ---------------------------------------------------------------------
659: if nvl(l_full_name,'NULL') <> nvl(p_person_rec.full_name,'NULL') then
660: l_name_changed := TRUE;
661: elsif nvl(l_order_name,'NULL') <> nvl(p_person_rec.order_name,'NULL') then

Line 669: update per_all_people_f

665: elsif nvl(l_global_name,'NULL') <> nvl(p_person_rec.global_name,'NULL') then
666: l_name_changed := TRUE;
667: end if;
668: if l_name_changed then
669: update per_all_people_f
670: set full_name = l_full_name
671: ,order_name = l_order_name
672: ,local_name = l_local_name
673: ,global_name = l_global_name

Line 692: where trigger_name = 'PER_ALL_PEOPLE_F_WHO';

688: l_cmd varchar2(1000);
689: --
690: cursor csr_get_trigger_owner is
691: select table_owner from user_triggers
692: where trigger_name = 'PER_ALL_PEOPLE_F_WHO';
693: BEGIN
694: p_error := null;
695: open csr_get_trigger_owner;
696: fetch csr_get_trigger_owner into l_owner;

Line 699: l_cmd := 'ALTER TRIGGER PER_ALL_PEOPLE_F_WHO ';

695: open csr_get_trigger_owner;
696: fetch csr_get_trigger_owner into l_owner;
697: close csr_get_trigger_owner;
698: if l_owner is not null then
699: l_cmd := 'ALTER TRIGGER PER_ALL_PEOPLE_F_WHO ';
700: if p_action = 'DISABLE' then
701: l_cmd := l_cmd || 'DISABLE';
702: EXECUTE IMMEDIATE l_cmd;
703: elsif p_action = 'ENABLE' then

Line 744: from per_all_people_f per

740: /*
741: **scope is ALL_BUS_GRP
742: */
743: sqlstr := 'select distinct per.person_id
744: from per_all_people_f per
745: where :payroll_action_id > 0
746: order by per.person_id';
747: else
748: sqlstr := 'select distinct per.person_id

Line 749: from per_all_people_f per

745: where :payroll_action_id > 0
746: order by per.person_id';
747: else
748: sqlstr := 'select distinct per.person_id
749: from per_all_people_f per
750: ,per_business_groups_perf bg
751: where :payroll_action_id > 0
752: and bg.business_group_id = per.business_group_id
753: and bg.legislation_code = '||''''||l_leg_code||''''||

Line 773: l_temp_person_id per_all_people_f.person_id%TYPE;

769: stperson in number,
770: endperson in number,
771: chunk in number) is
772: --
773: l_temp_person_id per_all_people_f.person_id%TYPE;
774: l_lockingactid pay_assignment_actions.assignment_action_id%TYPE;
775: l_business_group_id number;
776: l_legislation_code per_business_groups_perf.legislation_code%TYPE;
777: --

Line 783: from per_all_people_f ppf

779: ,cp_stperson number
780: ,cp_endperson number
781: ,cp_leg_code varchar2) is -- #4571033
782: select distinct ppf.person_id
783: from per_all_people_f ppf
784: ,per_business_groups_perf bg
785: ,pay_payroll_actions ppa
786: where ppf.person_id between cp_stperson and cp_endperson
787: and ppa.payroll_action_id = cp_pactid

Line 795: from per_all_people_f ppf

791: cursor csr_actions_no_leg(cp_pactid number
792: ,cp_stperson number
793: ,cp_endperson number) is
794: select distinct ppf.person_id
795: from per_all_people_f ppf
796: ,pay_payroll_actions ppa
797: where ppf.person_id between cp_stperson and cp_endperson
798: and ppa.payroll_action_id = cp_pactid;
799: --

Line 811: -- Passed person_id/PER_ALL_PEOPLE_F as object_id/object_type, procedure

807: --
808: for people_rec in csr_actions_no_leg(pactid, stperson, endperson) loop
809: select pay_assignment_actions_s.nextval into l_lockingactid
810: from dual;
811: -- Passed person_id/PER_ALL_PEOPLE_F as object_id/object_type, procedure
812: -- archive_data needs it to process a person.
813: hr_nonrun_asact.insact(lockingactid => l_lockingactid,
814: assignid => -1,
815: pactid => pactid,

Line 819: object_type => 'PER_ALL_PEOPLE_F');

815: pactid => pactid,
816: chunk => chunk,
817: greid => null,
818: object_id => people_rec.person_id,
819: object_type => 'PER_ALL_PEOPLE_F');
820: end loop;
821: else
822: -- only process those belonging to a specific legislation
823: --

Line 827: -- Passed person_id/PER_ALL_PEOPLE_F as object_id/object_type, procedure

823: --
824: for people_rec in csr_actions(pactid, stperson, endperson, l_legislation_code) loop
825: select pay_assignment_actions_s.nextval into l_lockingactid
826: from dual;
827: -- Passed person_id/PER_ALL_PEOPLE_F as object_id/object_type, procedure
828: -- archive_data needs it to process a person.
829: hr_nonrun_asact.insact(lockingactid => l_lockingactid,
830: assignid => -1,
831: pactid => pactid,

Line 835: object_type => 'PER_ALL_PEOPLE_F');

831: pactid => pactid,
832: chunk => chunk,
833: greid => null,
834: object_id => people_rec.person_id,
835: object_type => 'PER_ALL_PEOPLE_F');
836: end loop;
837: end if;
838: --
839: END action_creation;

Line 918: l_person_id per_all_people_f.person_id%TYPE;

914: --
915: PROCEDURE archive_data(p_assactid in number,
916: p_effective_date in date) is
917: --
918: l_person_id per_all_people_f.person_id%TYPE;
919: l_legislation_code varchar2(80);
920: l_num_rows_processed number;
921: --
922: cursor csr_person is

Line 1006: from per_all_people_f

1002: ,ORDER_NAME
1003: ,LOCAL_NAME
1004: ,GLOBAL_NAME
1005: ,BUSINESS_GROUP_ID
1006: from per_all_people_f
1007: where person_id = cp_person_id
1008: for update nowait;
1009:
1010: BEGIN

Line 1050: l_person_id per_all_people_f.person_id%TYPE;

1046: --
1047: PROCEDURE sync_list_name(errbuf out NOCOPY varchar2
1048: ,retcode out NOCOPY number) is
1049: --
1050: l_person_id per_all_people_f.person_id%TYPE;
1051: l_legislation_code varchar2(80);
1052: l_limit natural := 100; -- Limiting the bulk collect, if not limited then bulk collect
1053: -- returns entire rows for the condition, it may affect memory
1054: l_prev_collect number := 0; -- Cumulative record count till previous fetch

Line 1148: from per_all_people_f

1144: ,ORDER_NAME
1145: ,LOCAL_NAME
1146: ,GLOBAL_NAME
1147: ,BUSINESS_GROUP_ID
1148: from per_all_people_f
1149: where rowid = cp_row_id
1150: for update nowait;
1151: --
1152: cursor csr_get_rows_toUpd is

Line 1154: from per_all_people_f peo

1150: for update nowait;
1151: --
1152: cursor csr_get_rows_toUpd is
1153: select peo.rowid, bg.legislation_code
1154: from per_all_people_f peo
1155: ,per_business_groups_perf bg
1156: where (peo.global_name is null or peo.local_name is null)
1157: and peo.business_group_id = bg.business_group_id;
1158: --