[Home] [Help]
41: l_proc varchar2(72) := g_package||'set_security_group_id';
42: --
43: begin
44: --
45: hr_utility.set_location('Entering:'|| l_proc, 10);
46: --
47: -- Ensure that all the mandatory parameter are not null
48: --
49: hr_api.mandatory_arg_error
76: (p_security_group_id => l_security_group_id
77: );
78: end if;
79: --
80: hr_utility.set_location(' Leaving:'|| l_proc, 20);
81: --
82: end set_security_group_id;
83: --
84: -- ---------------------------------------------------------------------------
109: l_proc varchar2(72) := g_package||'return_legislation_code';
110: --
111: Begin
112: --
113: hr_utility.set_location('Entering:'|| l_proc, 10);
114: --
115: -- Ensure that all the mandatory parameter are not null
116: --
117: hr_api.mandatory_arg_error
127: -- call to this function. Just return the value in the global
128: -- variable.
129: --
130: l_legislation_code := pqh_doc_bus.g_legislation_code;
131: hr_utility.set_location(l_proc, 20);
132: else
133: --
134: -- The ID is different to the last call to this function
135: -- or this is the first call to this function.
144: close csr_leg_code;
145: fnd_message.set_name('PAY','HR_7220_INVALID_PRIMARY_KEY');
146: fnd_message.raise_error;
147: end if;
148: hr_utility.set_location(l_proc,30);
149: --
150: -- Set the global variables so the values are
151: -- available for the next call to this function.
152: --
153: close csr_leg_code;
154: pqh_doc_bus.g_document_id := p_document_id;
155: pqh_doc_bus.g_legislation_code := l_legislation_code;
156: end if;
157: hr_utility.set_location(' Leaving:'|| l_proc, 40);
158: return l_legislation_code;
159: end return_legislation_code;
160: --
161: -- ----------------------------------------------------------------------------
419: WHERE short_name = p_short_name;
420: --
421: l_short_name varchar2(10);
422: Begin
423: hr_utility.set_location('Entering:'||l_proc, 5);
424: --
425: -- Call all supporting business operations
426: --
427: OPEN cur_is_duplicate_name(p_rec.short_name);
436: --
437: -- "-- No business group context. HR_STANDARD_LOOKUPS used for validation."
438: --
439: --
440: hr_utility.set_location(' Leaving:'||l_proc, 10);
441: End insert_validate;
442: --
443: -- ----------------------------------------------------------------------------
444: -- |---------------------------< update_validate >----------------------------|
463: --
464: l_short_name varchar2(10);
465:
466: Begin
467: hr_utility.set_location('Entering:'||l_proc, 5);
468: --
469: -- Call all supporting business operations
470: OPEN cur_is_duplicate_name(p_rec.short_name);
471: FETCH cur_is_duplicate_name INTO l_short_name;
493: ,p_rec => p_rec
494: );
495: --
496: --
497: hr_utility.set_location(' Leaving:'||l_proc, 10);
498: End update_validate;
499: --
500: -- ----------------------------------------------------------------------------
501: -- |---------------------------< delete_validate >----------------------------|
510: --
511: l_proc varchar2(72) := g_package||'delete_validate';
512: --
513: Begin
514: hr_utility.set_location('Entering:'||l_proc, 5);
515: --
516: -- Call all supporting business operations
517: --
518: dt_delete_validate
521: ,p_validation_end_date => p_validation_end_date
522: ,p_document_id => p_rec.document_id
523: );
524: --
525: hr_utility.set_location(' Leaving:'||l_proc, 10);
526: End delete_validate;
527: --
528: end pqh_doc_bus;