APPS.PQP_GB_SWF_VALIDATIONS dependencies on HR_UTILITY

Line 72: hr_utility.trace('l_query = '|| l_query );

68: ' and business_group_id = ''' || p_business_group_id || '''' ||
69: ' and ' || p_information_column || ' = ''' || p_value || '''' ||
70: ' and ( ' || nvl(to_char(p_configuration_value_id),'null') || ' is null ' ||
71: ' or configuration_value_id <> ' || nvl(to_char(p_configuration_value_id),'null') || ' )';
72: hr_utility.trace('l_query = '|| l_query );
73:
74: execute immediate l_query into l_count;
75:
76: if l_count > 0 then

Line 128: hr_utility.trace('l_query = '|| l_query );

124: ' ) ' ||
125: ' and ( ' || nvl(to_char(p_configuration_value_id),'null') || ' is null ' ||
126: ' or configuration_value_id <> ' || nvl(to_char(p_configuration_value_id),'null') || ' )';
127:
128: hr_utility.trace('l_query = '|| l_query );
129:
130: execute immediate l_query into l_count;
131:
132: if l_count > 0 then

Line 164: hr_utility.trace('Spine Point mapping -- ');

160: l_query varchar2(4000) ;
161: l_updated_val_end varchar2(100);
162: l_updated_val_start varchar2(100);
163: begin
164: hr_utility.trace('Spine Point mapping -- ');
165: if p_value_start is null then
166: l_updated_val_start := 'null';
167: else
168: l_updated_val_start := ''''||p_value_start||'''';

Line 197: hr_utility.trace('l_query = '|| l_query );

193: ' ) ' ||
194: ' and ( ' || nvl(to_char(p_configuration_value_id),'null') || ' is null ' ||
195: ' or configuration_value_id <> ' || nvl(to_char(p_configuration_value_id),'null') || ' )';
196:
197: hr_utility.trace('l_query = '|| l_query );
198:
199: execute immediate l_query into l_count;
200:
201: if l_count > 0 then

Line 243: hr_utility.trace('l_query = '|| l_query );

239: ' ) ' ||
240: ' and ( ' || nvl(to_char(p_configuration_value_id),'null') || ' is null ' ||
241: ' or configuration_value_id <> ' || nvl(to_char(p_configuration_value_id),'null') || ' )';
242:
243: hr_utility.trace('l_query = '|| l_query );
244:
245: execute immediate l_query into l_count;
246:
247: if l_count > 0 then

Line 277: hr_utility.trace('l_query = '|| l_query );

273: ' and business_group_id = ''' || p_business_group_id || '''' ||
274: ' and ' || p_information_column || ' <> ''' || p_value || '''' ||
275: ' and (' || nvl(to_char(p_configuration_value_id),'null') || ' is null ' ||
276: ' or configuration_value_id <> ' || nvl(to_char(p_configuration_value_id),'null') || ' )';
277: hr_utility.trace('l_query = '|| l_query );
278:
279: execute immediate l_query into l_count;
280:
281: if l_count > 0 then