DBA Data[Home] [Help]

APPS.PER_OSV_BUS dependencies on HR_API

Line 90: IF hr_api.not_exists_in_hrstanlookups

86: begin
87: hr_utility.set_location('Entering:'|| l_proc, 10);
88: --
89: --
90: IF hr_api.not_exists_in_hrstanlookups
91: (p_effective_date => p_effective_date
92: ,p_lookup_type => 'YES_NO'
93: ,p_lookup_code => p_flag
94: ) THEN

Line 129: hr_api.mandatory_arg_error

125: --
126: hr_utility.set_location('Entering:'|| l_proc, 10);
127: --
128: --
129: hr_api.mandatory_arg_error
130: (p_api_name => l_proc
131: ,p_argument => 'p_version_number'
132: ,p_argument_value => p_version_number
133: );

Line 246: hr_api.mandatory_arg_error

242: --
243: hr_utility.set_location('Entering:'|| l_proc, 10);
244: --
245: --
246: hr_api.mandatory_arg_error
247: (p_api_name => l_proc
248: ,p_argument => 'p_date_from'
249: ,p_argument_value => p_date_from
250: );

Line 261: or p_date_from < hr_api.g_sot

257: -- are before or after beginning/end of time
258: --
259:
260: if p_date_from > p_date_to
261: or p_date_from < hr_api.g_sot
262: or p_date_from > hr_api.g_eot then
263: hr_utility.set_message('801','HR_6021_ALL_START_END_DATE');
264: hr_utility.raise_error;
265: end if;

Line 262: or p_date_from > hr_api.g_eot then

258: --
259:
260: if p_date_from > p_date_to
261: or p_date_from < hr_api.g_sot
262: or p_date_from > hr_api.g_eot then
263: hr_utility.set_message('801','HR_6021_ALL_START_END_DATE');
264: hr_utility.raise_error;
265: end if;
266:

Line 305: where osv.date_from <= nvl(p_Date_To, hr_api.g_eot)

301: from dual
302: where exists
303: (select 1
304: from per_org_structure_versions osv
305: where osv.date_from <= nvl(p_Date_To, hr_api.g_eot)
306: and nvl(osv.date_to,hr_api.g_eot) >= p_Date_From
307: and osv.organization_structure_id = p_organization_structure_id
308: and osv.org_structure_version_id
309: <> nvl(p_org_structure_version_id,-1));

Line 306: and nvl(osv.date_to,hr_api.g_eot) >= p_Date_From

302: where exists
303: (select 1
304: from per_org_structure_versions osv
305: where osv.date_from <= nvl(p_Date_To, hr_api.g_eot)
306: and nvl(osv.date_to,hr_api.g_eot) >= p_Date_From
307: and osv.organization_structure_id = p_organization_structure_id
308: and osv.org_structure_version_id
309: <> nvl(p_org_structure_version_id,-1));
310: --

Line 352: hr_api.mandatory_arg_error

348: hr_utility.set_location('Entering:'|| l_proc, 10);
349: --
350: -- Ensure that all the mandatory parameter are not null
351: --
352: hr_api.mandatory_arg_error
353: (p_api_name => l_proc
354: ,p_argument => 'org_structure_version_id'
355: ,p_argument_value => p_org_structure_version_id
356: );

Line 375: hr_api.set_security_group_id

371: close csr_sec_grp;
372: --
373: -- Set the security_group_id in CLIENT_INFO
374: --
375: hr_api.set_security_group_id
376: (p_security_group_id => l_security_group_id
377: );
378: --
379: hr_utility.set_location(' Leaving:'|| l_proc, 20);

Line 412: hr_api.mandatory_arg_error

408: hr_utility.set_location('Entering:'|| l_proc, 10);
409: --
410: -- Ensure that all the mandatory parameter are not null
411: --
412: hr_api.mandatory_arg_error
413: (p_api_name => l_proc
414: ,p_argument => 'org_structure_version_id'
415: ,p_argument_value => p_org_structure_version_id
416: );

Line 418: if ( nvl(per_osv_bus.g_org_structure_version_id, hr_api.g_number)

414: ,p_argument => 'org_structure_version_id'
415: ,p_argument_value => p_org_structure_version_id
416: );
417: --
418: if ( nvl(per_osv_bus.g_org_structure_version_id, hr_api.g_number)
419: = p_org_structure_version_id) then
420: --
421: -- The legislation code has already been found with a previous
422: -- call to this function. Just return the value in the global

Line 512: hr_api.argument_changed_error

508: -- not been updated.
509: --
510: EXCEPTION
511: WHEN l_error THEN
512: hr_api.argument_changed_error
513: (p_api_name => l_proc
514: ,p_argument => l_argument);
515: WHEN OTHERS THEN
516: RAISE;

Line 534: hr_api.validate_bus_grp_id(p_rec.business_group_id); -- Validate Bus Grp

530: Begin
531: hr_utility.set_location('Entering:'||l_proc, 5);
532: --
533: if p_rec.business_group_id is not null then
534: hr_api.validate_bus_grp_id(p_rec.business_group_id); -- Validate Bus Grp
535: end if;
536:
537: chk_version_number
538: (p_org_structure_version_id => p_rec.org_structure_version_id,

Line 582: hr_api.validate_bus_grp_id(p_rec.business_group_id); -- Validate Bus Grp

578: Begin
579: hr_utility.set_location('Entering:'||l_proc, 5);
580: --
581: if p_rec.business_group_id is not null then
582: hr_api.validate_bus_grp_id(p_rec.business_group_id); -- Validate Bus Grp
583: end if;
584: --
585: chk_version_number
586: (p_org_structure_version_id => p_rec.org_structure_version_id,