APPS.PAY_CONTACT_PKG dependencies on PER_ASSIGNMENT_EXTRA_INFO

Line 21: FROM per_assignment_extra_info aei

17: SELECT aei.assignment_extra_info_id
18: , aei.aei_information1
19: , aei.aei_information2
20: , aei.aei_information3
21: FROM per_assignment_extra_info aei
22: , per_all_assignments_f paf
23: WHERE aei.assignment_id = p_asg_id
24: AND aei.information_type = 'PAYROLL_CONTACT'
25: AND aei.aei_information_category = 'PAYROLL_CONTACT'

Line 31: l_extra_info_id per_assignment_extra_info.ASSIGNMENT_EXTRA_INFO_ID%type;

27: AND paf.business_group_id = p_bg_id
28: AND p_eff_date between paf.effective_start_date
29: and paf.effective_end_date;
30: --
31: l_extra_info_id per_assignment_extra_info.ASSIGNMENT_EXTRA_INFO_ID%type;
32: l_aei_name per_assignment_extra_info.aei_information1%type;
33: l_aei_phone per_assignment_extra_info.aei_information2%type;
34: l_aei_emial per_assignment_extra_info.aei_information3%type;
35: --

Line 32: l_aei_name per_assignment_extra_info.aei_information1%type;

28: AND p_eff_date between paf.effective_start_date
29: and paf.effective_end_date;
30: --
31: l_extra_info_id per_assignment_extra_info.ASSIGNMENT_EXTRA_INFO_ID%type;
32: l_aei_name per_assignment_extra_info.aei_information1%type;
33: l_aei_phone per_assignment_extra_info.aei_information2%type;
34: l_aei_emial per_assignment_extra_info.aei_information3%type;
35: --
36: BEGIN

Line 33: l_aei_phone per_assignment_extra_info.aei_information2%type;

29: and paf.effective_end_date;
30: --
31: l_extra_info_id per_assignment_extra_info.ASSIGNMENT_EXTRA_INFO_ID%type;
32: l_aei_name per_assignment_extra_info.aei_information1%type;
33: l_aei_phone per_assignment_extra_info.aei_information2%type;
34: l_aei_emial per_assignment_extra_info.aei_information3%type;
35: --
36: BEGIN
37: hr_utility.trace('p_ass_id: '||to_char(p_assignment_id));

Line 34: l_aei_emial per_assignment_extra_info.aei_information3%type;

30: --
31: l_extra_info_id per_assignment_extra_info.ASSIGNMENT_EXTRA_INFO_ID%type;
32: l_aei_name per_assignment_extra_info.aei_information1%type;
33: l_aei_phone per_assignment_extra_info.aei_information2%type;
34: l_aei_emial per_assignment_extra_info.aei_information3%type;
35: --
36: BEGIN
37: hr_utility.trace('p_ass_id: '||to_char(p_assignment_id));
38: hr_utility.trace('pbg_id: '||to_char(p_business_group_id));

Line 51: insert into per_assignment_extra_info

47:
48: --
49: -- insert details
50: --
51: insert into per_assignment_extra_info
52: (ASSIGNMENT_EXTRA_INFO_ID
53: ,ASSIGNMENT_ID
54: ,INFORMATION_TYPE
55: ,AEI_INFORMATION_CATEGORY

Line 59: select per_assignment_extra_info_s.nextval

55: ,AEI_INFORMATION_CATEGORY
56: ,AEI_INFORMATION1
57: ,AEI_INFORMATION2
58: ,AEI_INFORMATION3)
59: select per_assignment_extra_info_s.nextval
60: , p_assignment_id
61: , 'PAYROLL_CONTACT'
62: , 'PAYROLL_CONTACT'
63: , p_contact_name

Line 69: , per_assignment_extra_info aei

65: , p_email
66: from dual
67: where not exists (select 1
68: from per_all_assignments_f paf
69: , per_assignment_extra_info aei
70: where paf.assignment_id = aei.assignment_id
71: and paf.business_group_id = p_business_group_id
72: and paf.assignment_id = p_assignment_id
73: and aei.aei_information_category = 'PAYROLL_CONTACT');

Line 75: select per_assignment_extra_info_s.currval

71: and paf.business_group_id = p_business_group_id
72: and paf.assignment_id = p_assignment_id
73: and aei.aei_information_category = 'PAYROLL_CONTACT');
74: --
75: select per_assignment_extra_info_s.currval
76: into l_extra_info_id
77: from dual;
78: --
79: ELSE

Line 91: update per_assignment_extra_info

87: or p_email <> l_aei_phone then
88: --
89: -- a change in details so update
90: --
91: update per_assignment_extra_info
92: set aei_information1 = p_contact_name
93: , aei_information2 = p_phone
94: , aei_information3 = p_email
95: where assignment_extra_info_id = l_extra_info_id