131: cursor c1 is select per_people_s.nextval
132: from sys.dual;
133: --
134: cursor c2 is select rowid
135: from per_people_f
136: where effective_start_date = p_effective_start_date
137: and effective_end_date = p_effective_end_date
138: and person_id = p_person_id;
139: cursor c_person is
279: p_global_name => l_global_name,
280: p_local_name => l_local_name,
281: p_duplicate_flag => l_duplicate_flag);
282: --
283: insert into PER_PEOPLE_F
284: (person_id
285: ,party_id
286: ,effective_start_date
287: ,effective_end_date
544: --
545: -- Now assign the resulting party id back to the record.
546: --
547: if p_party_id is null then
548: update per_people_f
549: set party_id = l_person.party_id
550: where person_id = p_person_id;
551: end if;
552: --
680: --
681: procedure delete_row(p_rowid VARCHAR2) is
682: begin
683: --
684: delete from per_people_f
685: where rowid=chartorowid(p_rowid);
686: --
687: end delete_row;
688: --
783: --
784: -- Define cursor.
785: --
786: cursor per is select *
787: from per_people_f
788: where rowid = chartorowid(p_rowid)
789: for update nowait;
790: --
791: -- Local variables.
1676: end if; -- End of HIRE.
1677: end if; -- Of Person type change checks.
1678: --
1679: hr_utility.set_location('update_row - b4 update',1);
1680: update per_people_f ppf
1681: set ppf.person_id = p_person_id
1682: ,ppf.effective_start_date = p_effective_start_date
1683: ,ppf.effective_end_date = p_effective_end_date
1684: ,ppf.business_group_id = p_business_group_id