DBA Data[Home] [Help]

APPS.PER_MX_DATA_PUMP dependencies on HR_UTILITY

Line 67: hr_utility.trace('Entering '||l_proc_name);

63: l_proc_name varchar2(100);
64: BEGIN
65:
66: l_proc_name := g_proc_name||'GET_TAX_UNIT_ID';
67: hr_utility.trace('Entering '||l_proc_name);
68:
69: OPEN csr_tax_unit_id;
70: FETCH csr_tax_unit_id INTO l_org_id;
71: CLOSE csr_tax_unit_id;

Line 73: hr_utility.trace('Leaving '||l_proc_name);

69: OPEN csr_tax_unit_id;
70: FETCH csr_tax_unit_id INTO l_org_id;
71: CLOSE csr_tax_unit_id;
72:
73: hr_utility.trace('Leaving '||l_proc_name);
74:
75: RETURN (l_org_id);
76: EXCEPTION
77: WHEN others THEN

Line 107: hr_utility.trace('Entering '||l_proc_name);

103: l_user_column_id pay_user_columns.user_column_id%type;
104: l_proc_name varchar2(100);
105: BEGIN
106: l_proc_name := g_proc_name || 'GET_WORK_SCHEDULE';
107: hr_utility.trace('Entering '||l_proc_name);
108:
109: OPEN csr_get_work_schedule;
110: FETCH csr_get_work_schedule INTO l_user_column_id;
111: CLOSE csr_get_work_schedule;

Line 113: hr_utility.trace('Leaving '||l_proc_name);

109: OPEN csr_get_work_schedule;
110: FETCH csr_get_work_schedule INTO l_user_column_id;
111: CLOSE csr_get_work_schedule;
112:
113: hr_utility.trace('Leaving '||l_proc_name);
114: RETURN (l_user_column_id);
115: EXCEPTION
116: WHEN others THEN
117: hr_data_pump.fail('GET_WORK_SCHEDULE',