APPS.BEN_CWB_AUDIT_API dependencies on BEN_PER_IN_LER

Line 23: l_created_by ben_per_in_ler.created_by%type;

19: l_object_version_number ben_cwb_audit.object_version_number%type;
20: l_proc varchar2(72) := g_package||'create_per_record';
21: l_lf_evt_ocrd_dt ben_cwb_audit.lf_evt_ocrd_dt%type;
22: /*
23: l_created_by ben_per_in_ler.created_by%type;
24: */
25: l_creation_date ben_per_in_ler.creation_date%type;
26: l_last_updated_by ben_per_in_ler.last_updated_by%type;
27: l_change_made_by_person_id ben_cwb_audit.change_made_by_person_id%type;

Line 25: l_creation_date ben_per_in_ler.creation_date%type;

21: l_lf_evt_ocrd_dt ben_cwb_audit.lf_evt_ocrd_dt%type;
22: /*
23: l_created_by ben_per_in_ler.created_by%type;
24: */
25: l_creation_date ben_per_in_ler.creation_date%type;
26: l_last_updated_by ben_per_in_ler.last_updated_by%type;
27: l_change_made_by_person_id ben_cwb_audit.change_made_by_person_id%type;
28: l_group_pl_id ben_cwb_audit.group_pl_id%type;
29: l_person_id fnd_user.employee_id%type;

Line 26: l_last_updated_by ben_per_in_ler.last_updated_by%type;

22: /*
23: l_created_by ben_per_in_ler.created_by%type;
24: */
25: l_creation_date ben_per_in_ler.creation_date%type;
26: l_last_updated_by ben_per_in_ler.last_updated_by%type;
27: l_change_made_by_person_id ben_cwb_audit.change_made_by_person_id%type;
28: l_group_pl_id ben_cwb_audit.group_pl_id%type;
29: l_person_id fnd_user.employee_id%type;
30:

Line 40: from ben_per_in_ler

36: begin
37: /*
38: select created_by, creation_date, group_pl_id, lf_evt_ocrd_dt
39: into l_created_by, l_creation_date, l_group_pl_id, l_lf_evt_ocrd_dt
40: from ben_per_in_ler
41: where per_in_ler_id = p_per_in_ler_id;
42: */
43: select last_updated_by, group_pl_id, lf_evt_ocrd_dt,creation_date
44: into l_last_updated_by, l_group_pl_id, l_lf_evt_ocrd_dt, l_creation_date

Line 45: from ben_per_in_ler

41: where per_in_ler_id = p_per_in_ler_id;
42: */
43: select last_updated_by, group_pl_id, lf_evt_ocrd_dt,creation_date
44: into l_last_updated_by, l_group_pl_id, l_lf_evt_ocrd_dt, l_creation_date
45: from ben_per_in_ler
46: where per_in_ler_id = p_per_in_ler_id;
47:
48: -- if record exists
49:

Line 95: (p_per_in_ler_id in ben_per_in_ler.per_in_ler_id%type

91: -- -----------------------------------------------------------------------
92: -- |--------------------------< update_per_record >----------------------|
93: -- -----------------------------------------------------------------------
94: procedure update_per_record
95: (p_per_in_ler_id in ben_per_in_ler.per_in_ler_id%type
96: ) is
97: --
98: begin
99: update_per_record(p_per_in_ler_id => p_per_in_ler_id

Line 115: l_per_record_new ben_per_in_ler%rowtype;

111: --
112: l_cwb_audit_id ben_cwb_audit.cwb_audit_id%type;
113: l_object_version_number ben_cwb_audit.object_version_number%type;
114: l_proc varchar2(72) := g_package||'update_per_record';
115: l_per_record_new ben_per_in_ler%rowtype;
116: l_person_id fnd_user.employee_id%type;
117:
118: begin
119: if g_debug then

Line 127: from ben_per_in_ler

123: begin
124:
125: select *
126: into l_per_record_new
127: from ben_per_in_ler
128: where per_in_ler_id = p_group_per_in_ler_id;
129:
130: -- if record exists
131:

Line 294: l_ws_mgr_id ben_per_in_ler.ws_mgr_id%type;

290: ,p_audit_type_cd in varchar2
291: ) is
292: --
293: l_proc varchar2(72) := g_package||'update_per_record';
294: l_ws_mgr_id ben_per_in_ler.ws_mgr_id%type;
295: l_old_ws_mgr_name ben_cwb_person_info.full_name%type;
296: l_new_ws_mgr_name ben_cwb_person_info.full_name%type;
297: l_per_record_new ben_per_in_ler%rowtype;
298: l_person_id fnd_user.employee_id%type;

Line 297: l_per_record_new ben_per_in_ler%rowtype;

293: l_proc varchar2(72) := g_package||'update_per_record';
294: l_ws_mgr_id ben_per_in_ler.ws_mgr_id%type;
295: l_old_ws_mgr_name ben_cwb_person_info.full_name%type;
296: l_new_ws_mgr_name ben_cwb_person_info.full_name%type;
297: l_per_record_new ben_per_in_ler%rowtype;
298: l_person_id fnd_user.employee_id%type;
299: l_cwb_audit_id ben_cwb_audit.cwb_audit_id%type;
300: l_object_version_number ben_cwb_audit.object_version_number%type;
301: l_personid ben_per_in_ler.ws_mgr_id%type;

Line 301: l_personid ben_per_in_ler.ws_mgr_id%type;

297: l_per_record_new ben_per_in_ler%rowtype;
298: l_person_id fnd_user.employee_id%type;
299: l_cwb_audit_id ben_cwb_audit.cwb_audit_id%type;
300: l_object_version_number ben_cwb_audit.object_version_number%type;
301: l_personid ben_per_in_ler.ws_mgr_id%type;
302:
303:
304: begin
305:

Line 324: from ben_per_in_ler

320: begin
321:
322: select *
323: into l_per_record_new
324: from ben_per_in_ler
325: where per_in_ler_id = p_per_in_ler_id;
326:
327: -- if record exists
328:

Line 366: ,ben_per_in_ler pil

362: ppf.full_name),
363: ppf.full_name)
364: into l_personid, l_old_ws_mgr_name
365: from per_all_people_f ppf
366: ,ben_per_in_ler pil
367: ,per_all_assignments_f paf
368: ,per_business_groups bg
369: where ppf.person_id = l_ws_mgr_id
370: and sysdate between ppf.effective_start_date and

Line 399: ,ben_per_in_ler pil

395: ppf.full_name),
396: ppf.full_name)
397: into l_personid, l_new_ws_mgr_name
398: from per_all_people_f ppf
399: ,ben_per_in_ler pil
400: ,per_all_assignments_f paf
401: ,per_business_groups bg
402: where ppf.person_id = l_per_record_new.ws_mgr_id
403: and sysdate between ppf.effective_start_date and