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_PPR_BUS dependencies on HR_API

Line 47: hr_api.mandatory_arg_error

43: hr_utility.set_location('Entering:'|| l_proc, 10);
44: --
45: -- Ensure that all the mandatory parameter are not null
46: --
47: hr_api.mandatory_arg_error
48: (p_api_name => l_proc
49: ,p_argument => 'status_processing_rule_id'
50: ,p_argument_value => p_status_processing_rule_id
51: );

Line 74: hr_api.set_security_group_id

70: close csr_sec_grp;
71: --
72: -- Set the security_group_id in CLIENT_INFO
73: --
74: hr_api.set_security_group_id
75: (p_security_group_id => l_security_group_id
76: );
77: --
78: -- Set the sessions legislation context in HR_SESSION_DATA

Line 80: hr_api.set_legislation_context(l_legislation_code);

76: );
77: --
78: -- Set the sessions legislation context in HR_SESSION_DATA
79: --
80: hr_api.set_legislation_context(l_legislation_code);
81: end if;
82: --
83: hr_utility.set_location(' Leaving:'|| l_proc, 20);
84: --

Line 116: hr_api.mandatory_arg_error

112: hr_utility.set_location('Entering:'|| l_proc, 10);
113: --
114: -- Ensure that all the mandatory parameter are not null
115: --
116: hr_api.mandatory_arg_error
117: (p_api_name => l_proc
118: ,p_argument => 'status_processing_rule_id'
119: ,p_argument_value => p_status_processing_rule_id
120: );

Line 122: if ( nvl(pay_ppr_bus.g_status_processing_rule_id, hr_api.g_number)

118: ,p_argument => 'status_processing_rule_id'
119: ,p_argument_value => p_status_processing_rule_id
120: );
121: --
122: if ( nvl(pay_ppr_bus.g_status_processing_rule_id, hr_api.g_number)
123: = p_status_processing_rule_id) then
124: --
125: -- The legislation code has already been found with a previous
126: -- call to this function. Just return the value in the global

Line 217: If nvl(p_rec.business_group_id,hr_api.g_number) <>

213: hr_utility.set_location('Entering:'||l_proc, 10);
214: --
215: -- Ensure that the following attributes are not updated.
216: --
217: If nvl(p_rec.business_group_id,hr_api.g_number) <>
218: nvl(pay_ppr_shd.g_old_rec.business_group_id,hr_api.g_number) then
219: --
220: l_argument := 'business_group_id';
221: raise l_error;

Line 218: nvl(pay_ppr_shd.g_old_rec.business_group_id,hr_api.g_number) then

214: --
215: -- Ensure that the following attributes are not updated.
216: --
217: If nvl(p_rec.business_group_id,hr_api.g_number) <>
218: nvl(pay_ppr_shd.g_old_rec.business_group_id,hr_api.g_number) then
219: --
220: l_argument := 'business_group_id';
221: raise l_error;
222: --

Line 227: If nvl(p_rec.legislation_code,hr_api.g_varchar2) <>

223: End if;
224: --
225: hr_utility.set_location('Entering:'||l_proc, 15);
226: --
227: If nvl(p_rec.legislation_code,hr_api.g_varchar2) <>
228: nvl(pay_ppr_shd.g_old_rec.legislation_code,hr_api.g_varchar2) then
229: --
230: l_argument := 'legislation_code';
231: raise l_error;

Line 228: nvl(pay_ppr_shd.g_old_rec.legislation_code,hr_api.g_varchar2) then

224: --
225: hr_utility.set_location('Entering:'||l_proc, 15);
226: --
227: If nvl(p_rec.legislation_code,hr_api.g_varchar2) <>
228: nvl(pay_ppr_shd.g_old_rec.legislation_code,hr_api.g_varchar2) then
229: --
230: l_argument := 'legislation_code';
231: raise l_error;
232: --

Line 237: If nvl(p_rec.status_processing_rule_id,hr_api.g_number) <>

233: End if;
234: --
235: hr_utility.set_location('Entering:'||l_proc, 20);
236: --
237: If nvl(p_rec.status_processing_rule_id,hr_api.g_number) <>
238: nvl(pay_ppr_shd.g_old_rec.status_processing_rule_id,hr_api.g_number) then
239: --
240: l_argument := 'status_processing_rule_id';
241: raise l_error;

Line 238: nvl(pay_ppr_shd.g_old_rec.status_processing_rule_id,hr_api.g_number) then

234: --
235: hr_utility.set_location('Entering:'||l_proc, 20);
236: --
237: If nvl(p_rec.status_processing_rule_id,hr_api.g_number) <>
238: nvl(pay_ppr_shd.g_old_rec.status_processing_rule_id,hr_api.g_number) then
239: --
240: l_argument := 'status_processing_rule_id';
241: raise l_error;
242: --

Line 247: If nvl(p_rec.assignment_status_type_id,hr_api.g_number) <>

243: End if;
244: --
245: hr_utility.set_location('Entering:'||l_proc, 25);
246: --
247: If nvl(p_rec.assignment_status_type_id,hr_api.g_number) <>
248: nvl(pay_ppr_shd.g_old_rec.assignment_status_type_id,hr_api.g_number) then
249: --
250: l_argument := 'assignment_status_type_id';
251: raise l_error;

Line 248: nvl(pay_ppr_shd.g_old_rec.assignment_status_type_id,hr_api.g_number) then

244: --
245: hr_utility.set_location('Entering:'||l_proc, 25);
246: --
247: If nvl(p_rec.assignment_status_type_id,hr_api.g_number) <>
248: nvl(pay_ppr_shd.g_old_rec.assignment_status_type_id,hr_api.g_number) then
249: --
250: l_argument := 'assignment_status_type_id';
251: raise l_error;
252: --

Line 257: If nvl(p_rec.element_type_id,hr_api.g_number) <>

253: End if;
254: --
255: hr_utility.set_location('Entering:'||l_proc, 30);
256: --
257: If nvl(p_rec.element_type_id,hr_api.g_number) <>
258: nvl(pay_ppr_shd.g_old_rec.element_type_id,hr_api.g_number) then
259: --
260: l_argument := 'element_type_id';
261: raise l_error;

Line 258: nvl(pay_ppr_shd.g_old_rec.element_type_id,hr_api.g_number) then

254: --
255: hr_utility.set_location('Entering:'||l_proc, 30);
256: --
257: If nvl(p_rec.element_type_id,hr_api.g_number) <>
258: nvl(pay_ppr_shd.g_old_rec.element_type_id,hr_api.g_number) then
259: --
260: l_argument := 'element_type_id';
261: raise l_error;
262: --

Line 267: If nvl(p_rec.legislation_subgroup,hr_api.g_varchar2) <>

263: End if;
264: --
265: hr_utility.set_location('Entering:'||l_proc, 35);
266: --
267: If nvl(p_rec.legislation_subgroup,hr_api.g_varchar2) <>
268: nvl(pay_ppr_shd.g_old_rec.legislation_subgroup,hr_api.g_varchar2) then
269: --
270: l_argument := 'legislation_subgroup';
271: raise l_error;

Line 268: nvl(pay_ppr_shd.g_old_rec.legislation_subgroup,hr_api.g_varchar2) then

264: --
265: hr_utility.set_location('Entering:'||l_proc, 35);
266: --
267: If nvl(p_rec.legislation_subgroup,hr_api.g_varchar2) <>
268: nvl(pay_ppr_shd.g_old_rec.legislation_subgroup,hr_api.g_varchar2) then
269: --
270: l_argument := 'legislation_subgroup';
271: raise l_error;
272: --

Line 278: hr_api.argument_changed_error

274: --
275: hr_utility.set_location('Leaving :'||l_proc, 40);
276: EXCEPTION
277: WHEN l_error THEN
278: hr_api.argument_changed_error
279: (p_api_name => l_proc
280: ,p_argument => l_argument);
281: WHEN OTHERS THEN
282: RAISE;

Line 326: hr_api.mandatory_arg_error

322: Begin
323: --
324: -- Ensure that the p_datetrack_mode argument is not null
325: --
326: hr_api.mandatory_arg_error
327: (p_api_name => l_proc
328: ,p_argument => 'datetrack_mode'
329: ,p_argument_value => p_datetrack_mode
330: );

Line 336: hr_api.mandatory_arg_error

332: -- Mode will be valid, as this is checked at the start of the upd.
333: --
334: -- Ensure the arguments are not null
335: --
336: hr_api.mandatory_arg_error
337: (p_api_name => l_proc
338: ,p_argument => 'validation_start_date'
339: ,p_argument_value => p_validation_start_date
340: );

Line 342: hr_api.mandatory_arg_error

338: ,p_argument => 'validation_start_date'
339: ,p_argument_value => p_validation_start_date
340: );
341: --
342: hr_api.mandatory_arg_error
343: (p_api_name => l_proc
344: ,p_argument => 'validation_end_date'
345: ,p_argument_value => p_validation_end_date
346: );

Line 410: hr_api.mandatory_arg_error

406: Begin
407: --
408: -- Ensure that the p_datetrack_mode argument is not null
409: --
410: hr_api.mandatory_arg_error
411: (p_api_name => l_proc
412: ,p_argument => 'datetrack_mode'
413: ,p_argument_value => p_datetrack_mode
414: );

Line 419: If (p_datetrack_mode = hr_api.g_delete or

415: --
416: -- Only perform the validation if the datetrack mode is either
417: -- DELETE or ZAP
418: --
419: If (p_datetrack_mode = hr_api.g_delete or
420: p_datetrack_mode = hr_api.g_zap) then
421: --
422: --
423: -- Ensure the arguments are not null

Line 420: p_datetrack_mode = hr_api.g_zap) then

416: -- Only perform the validation if the datetrack mode is either
417: -- DELETE or ZAP
418: --
419: If (p_datetrack_mode = hr_api.g_delete or
420: p_datetrack_mode = hr_api.g_zap) then
421: --
422: --
423: -- Ensure the arguments are not null
424: --

Line 425: hr_api.mandatory_arg_error

421: --
422: --
423: -- Ensure the arguments are not null
424: --
425: hr_api.mandatory_arg_error
426: (p_api_name => l_proc
427: ,p_argument => 'validation_start_date'
428: ,p_argument_value => p_validation_start_date
429: );

Line 431: hr_api.mandatory_arg_error

427: ,p_argument => 'validation_start_date'
428: ,p_argument_value => p_validation_start_date
429: );
430: --
431: hr_api.mandatory_arg_error
432: (p_api_name => l_proc
433: ,p_argument => 'validation_end_date'
434: ,p_argument_value => p_validation_end_date
435: );

Line 437: hr_api.mandatory_arg_error

433: ,p_argument => 'validation_end_date'
434: ,p_argument_value => p_validation_end_date
435: );
436: --
437: hr_api.mandatory_arg_error
438: (p_api_name => l_proc
439: ,p_argument => 'status_processing_rule_id'
440: ,p_argument_value => p_status_processing_rule_id
441: );

Line 487: nvl(p_legislation_code,hr_api.return_legislation_code(p_business_group_id)))

483: SELECT '1'
484: FROM per_assignment_status_types astp
485: WHERE nvl(astp.assignment_status_type_id,-1) = nvl(p_assignment_status_type_id,-1)
486: and ((astp.legislation_code =
487: nvl(p_legislation_code,hr_api.return_legislation_code(p_business_group_id)))
488: or ( astp.legislation_code is null and
489: astp.business_group_id = p_business_group_id)
490: or ( astp.legislation_code is null and
491: astp.business_group_id is null));

Line 546: nvl(p_legislation_code,hr_api.return_legislation_code(p_business_group_id)))

542: SELECT astp.user_status
543: FROM pay_ass_status_types_plus_std astp
544: WHERE nvl(astp.assignment_status_type_id,-1) = nvl(p_assignment_status_type_id,-1)
545: and ((astp.legislation_code =
546: nvl(p_legislation_code,hr_api.return_legislation_code(p_business_group_id)))
547: or ( astp.legislation_code is null and
548: astp.business_group_id = p_business_group_id)
549: or ( astp.legislation_code is null and
550: astp.business_group_id is null));

Line 560: nvl(p_legislation_code,hr_api.return_legislation_code(p_business_group_id)))

556: from ff_formula_types ft, ff_formulas_f ff
557: where ff.formula_type_id = ft.formula_type_id
558: and ff.formula_id = p_formula_id
559: and ((ff.legislation_code =
560: nvl(p_legislation_code,hr_api.return_legislation_code(p_business_group_id)))
561: or ( ff.legislation_code is null and
562: ff.business_group_id = p_business_group_id)
563: or ( ff.legislation_code is null and
564: ff.business_group_id is null));

Line 684: and nvl(element.legislation_code, nvl(nvl(p_legislation_code,hr_api.return_legislation_code(p_business_group_id)), '~'))

680: and element.classification_id = classif.classification_id
681: and p_effective_date between element.effective_start_date
682: and element.effective_end_date
683: and nvl(element.business_group_id,nvl(p_business_group_id, 0)) = nvl(p_business_group_id,0)
684: and nvl(element.legislation_code, nvl(nvl(p_legislation_code,hr_api.return_legislation_code(p_business_group_id)), '~'))
685: = nvl(nvl(p_legislation_code,hr_api.return_legislation_code(p_business_group_id)),'~');
686:
687: --
688: Begin

Line 685: = nvl(nvl(p_legislation_code,hr_api.return_legislation_code(p_business_group_id)),'~');

681: and p_effective_date between element.effective_start_date
682: and element.effective_end_date
683: and nvl(element.business_group_id,nvl(p_business_group_id, 0)) = nvl(p_business_group_id,0)
684: and nvl(element.legislation_code, nvl(nvl(p_legislation_code,hr_api.return_legislation_code(p_business_group_id)), '~'))
685: = nvl(nvl(p_legislation_code,hr_api.return_legislation_code(p_business_group_id)),'~');
686:
687: --
688: Begin
689: hr_utility.set_location('Entering:'||l_proc, 5);

Line 694: hr_api.mandatory_arg_error

690: --
691: -- Check mandatory element_type_id exists
692: --
693: --
694: hr_api.mandatory_arg_error
695: (p_api_name => l_proc
696: ,p_argument => 'element_type_id'
697: ,p_argument_value => p_element_type_id
698: );

Line 943: hr_api.validate_bus_grp_id

939: NOT IN ('GENERIC','STARTUP') THEN
940: --
941: -- Validate Important Attributes
942: --
943: hr_api.validate_bus_grp_id
944: (p_business_group_id => p_rec.business_group_id
945: ,p_associated_column1 => pay_ppr_shd.g_tab_nam
946: || '.BUSINESS_GROUP_ID');
947: --

Line 1048: hr_api.validate_bus_grp_id

1044: NOT IN ('GENERIC','STARTUP') THEN
1045: --
1046: -- Validate Important Attributes
1047: --
1048: hr_api.validate_bus_grp_id
1049: (p_business_group_id => p_rec.business_group_id
1050: ,p_associated_column1 => pay_ppr_shd.g_tab_nam
1051: || '.BUSINESS_GROUP_ID');
1052: --