APPS.HXC_PROJ_PAY_DEP_VALIDATION dependencies on HXC_PAY_PA_LINK_ALL

Line 82: -- check if timecard data exists in hxc_pay_pa_link_all table

78: END IF;
79:
80:
81: IF p_proj_pay_integration = 'Y' THEN
82: -- check if timecard data exists in hxc_pay_pa_link_all table
83: -- if timecard exists return
84: -- if timecard not exists , check whether data has ever retrieved
85: -- if timecard data is transferred to any receipient application raise an error or else return.
86: BEGIN

Line 90: FROM hxc_pay_pa_link_all

86: BEGIN
87:
88: SELECT 1
89: INTO l_count
90: FROM hxc_pay_pa_link_all
91: WHERE timecard_id = p_timecard_id
92: AND rownum < 2 ;
93:
94: EXCEPTION

Line 101: hr_utility.trace('PA-PAY> Number of records exists in hxc_pay_pa_link_all table ::'||l_count);

97: END;
98:
99: IF g_debug THEN
100: hr_utility.trace('PA-PAY> Projects Payroll integration is enabled ::'||p_proj_pay_integration);
101: hr_utility.trace('PA-PAY> Number of records exists in hxc_pay_pa_link_all table ::'||l_count);
102: END IF;
103:
104: IF l_count > 0 THEN
105: RETURN;

Line 183: -- need to check whether data exists in hxc_pay_pa_link_all , if exists raise an error

179: , p_time_attribute_id => NULL
180: , p_time_attribute_ovn => NULL );
181: END IF;
182: ELSE
183: -- need to check whether data exists in hxc_pay_pa_link_all , if exists raise an error
184:
185: BEGIN
186:
187: SELECT 1

Line 189: FROM hxc_pay_pa_link_all

185: BEGIN
186:
187: SELECT 1
188: INTO l_count
189: FROM hxc_pay_pa_link_all
190: WHERE timecard_id = p_timecard_id
191: AND rownum < 2 ;
192:
193: EXCEPTION

Line 201: hr_utility.trace('PA-PAY> Number of records exists in hxc_pay_pa_link_all table ::'||l_count);

197:
198:
199: IF g_debug THEN
200: hr_utility.trace('PA-PAY> Projects Payroll integration is enabled ::'||p_proj_pay_integration);
201: hr_utility.trace('PA-PAY> Number of records exists in hxc_pay_pa_link_all table ::'||l_count);
202: END IF;
203:
204: IF l_count > 0 THEN
205: hxc_timecard_message_helper.adderrortocollection (