DBA Data[Home] [Help]

APPS.PER_HRTCA_MERGE dependencies on PER_ALL_PEOPLE_F

Line 7: g_old_email_address per_all_people_f.email_address%type;

3: --
4: g_prev_last_name_len number default null;
5: --
6: --bug no 5546586 starts here
7: g_old_email_address per_all_people_f.email_address%type;
8: --bug no 5546586 ends here
9:
10: TYPE g_party_id_type IS TABLE OF NUMBER(15) index by binary_integer;
11: --

Line 25: (p_rec in out nocopy per_all_people_f%rowtype);

21: (p_number_of_workers in number default 1,
22: p_current_worker in number default 1);
23: --
24: procedure create_tca_person
25: (p_rec in out nocopy per_all_people_f%rowtype);
26: --
27: procedure update_tca_person
28: (p_rec in out nocopy per_all_people_f%rowtype,
29: p_overwrite_data in varchar2 default 'Y');

Line 28: (p_rec in out nocopy per_all_people_f%rowtype,

24: procedure create_tca_person
25: (p_rec in out nocopy per_all_people_f%rowtype);
26: --
27: procedure update_tca_person
28: (p_rec in out nocopy per_all_people_f%rowtype,
29: p_overwrite_data in varchar2 default 'Y');
30: --
31: procedure replicate_person_across_bg
32: (p_rec in out nocopy per_all_people_f%rowtype,

Line 32: (p_rec in out nocopy per_all_people_f%rowtype,

28: (p_rec in out nocopy per_all_people_f%rowtype,
29: p_overwrite_data in varchar2 default 'Y');
30: --
31: procedure replicate_person_across_bg
32: (p_rec in out nocopy per_all_people_f%rowtype,
33: p_overwrite_data in varchar2 default 'Y');
34: --
35: procedure create_update_contact_point
36: (p_rec in out nocopy per_all_people_f%rowtype);

Line 36: (p_rec in out nocopy per_all_people_f%rowtype);

32: (p_rec in out nocopy per_all_people_f%rowtype,
33: p_overwrite_data in varchar2 default 'Y');
34: --
35: procedure create_update_contact_point
36: (p_rec in out nocopy per_all_people_f%rowtype);
37: --
38: procedure per_party_merge
39: (p_entity_name in varchar2,
40: p_from_id in number,

Line 94: -- A valid record should be existing in per_all_people_f table for the

90: -- This function will return a single record for a given party id and
91: -- effective date
92: --
93: -- Prerequisites:
94: -- A valid record should be existing in per_all_people_f table for the
95: -- given party id and effective date
96: --
97: -- In Parameters:
98: -- Name Reqd Type Description

Line 133: -- A valid record should be existing in per_all_people_f table for the

129: -- 'PARTY VALID'
130: -- 'PARTY INVALID'
131: --
132: -- Prerequisites:
133: -- A valid record should be existing in per_all_people_f table for the
134: -- given party id and effective date
135: --
136: -- In Parameters:
137: -- Name Reqd Type Description

Line 172: -- A valid record should be existing in per_all_people_f table for the

168: -- This function will return a single record for a given party id, person_id and
169: -- effective date
170: --
171: -- Prerequisites:
172: -- A valid record should be existing in per_all_people_f table for the
173: -- given party id,person id and effective date
174: --
175: -- In Parameters:
176: -- Name Reqd Type Description