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.PAY_CONTACT_PKG dependencies on HR_UTILITY

Line 37: hr_utility.trace('p_ass_id: '||to_char(p_assignment_id));

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));
39: hr_utility.trace('eff-date: '||to_char(p_effective_date,'yyyy/mm/dd'));
40: --
41: OPEN c_contact_details(p_assignment_id, p_business_group_id, p_effective_date);

Line 38: hr_utility.trace('pbg_id: '||to_char(p_business_group_id));

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));
39: hr_utility.trace('eff-date: '||to_char(p_effective_date,'yyyy/mm/dd'));
40: --
41: OPEN c_contact_details(p_assignment_id, p_business_group_id, p_effective_date);
42: FETCH c_contact_details into l_extra_info_id, l_aei_name, l_aei_phone,

Line 39: hr_utility.trace('eff-date: '||to_char(p_effective_date,'yyyy/mm/dd'));

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));
39: hr_utility.trace('eff-date: '||to_char(p_effective_date,'yyyy/mm/dd'));
40: --
41: OPEN c_contact_details(p_assignment_id, p_business_group_id, p_effective_date);
42: FETCH c_contact_details into l_extra_info_id, l_aei_name, l_aei_phone,
43: l_aei_emial;

Line 45: hr_utility.trace('row not found so insert');

41: OPEN c_contact_details(p_assignment_id, p_business_group_id, p_effective_date);
42: FETCH c_contact_details into l_extra_info_id, l_aei_name, l_aei_phone,
43: l_aei_emial;
44: IF c_contact_details%NOTFOUND THEN
45: hr_utility.trace('row not found so insert');
46: CLOSE c_contact_details;
47:
48: --
49: -- insert details

Line 80: hr_utility.trace('row found so update');

76: into l_extra_info_id
77: from dual;
78: --
79: ELSE
80: hr_utility.trace('row found so update');
81: CLOSE c_contact_details;
82: --
83: -- contact details exist, check if any changes
84: --