APPS.PER_REQ_BUS dependencies on PER_REQ_BUS

Line 1: Package Body per_req_bus as

1: Package Body per_req_bus as
2: /* $Header: pereqrhi.pkb 120.0.12000000.2 2007/07/10 05:22:20 mkjayara noship $ */
3: --
4: -- ----------------------------------------------------------------------------
5: -- | Private Global Definitions |

Line 8: g_package varchar2(33) := ' per_req_bus.'; -- Global package name

4: -- ----------------------------------------------------------------------------
5: -- | Private Global Definitions |
6: -- ----------------------------------------------------------------------------
7: --
8: g_package varchar2(33) := ' per_req_bus.'; -- Global package name
9: --
10: -- The following two global variables are only to be
11: -- used by the return_legislation_code function.
12: --

Line 110: if ( nvl(per_req_bus.g_requisition_id, hr_api.g_number)

106: ,p_argument => 'requisition_id'
107: ,p_argument_value => p_requisition_id
108: );
109: --
110: if ( nvl(per_req_bus.g_requisition_id, hr_api.g_number)
111: = p_requisition_id) then
112: --
113: -- The legislation code has already been found with a previous
114: -- call to this function. Just return the value in the global

Line 117: l_legislation_code := per_req_bus.g_legislation_code;

113: -- The legislation code has already been found with a previous
114: -- call to this function. Just return the value in the global
115: -- variable.
116: --
117: l_legislation_code := per_req_bus.g_legislation_code;
118: hr_utility.set_location(l_proc, 20);
119: else
120: --
121: -- The ID is different to the last call to this function

Line 141: per_req_bus.g_requisition_id := p_requisition_id;

137: -- Set the global variables so the values are
138: -- available for the next call to this function.
139: --
140: close csr_leg_code;
141: per_req_bus.g_requisition_id := p_requisition_id;
142: per_req_bus.g_legislation_code := l_legislation_code;
143: end if;
144: hr_utility.set_location(' Leaving:'|| l_proc, 40);
145: return l_legislation_code;

Line 142: per_req_bus.g_legislation_code := l_legislation_code;

138: -- available for the next call to this function.
139: --
140: close csr_leg_code;
141: per_req_bus.g_requisition_id := p_requisition_id;
142: per_req_bus.g_legislation_code := l_legislation_code;
143: end if;
144: hr_utility.set_location(' Leaving:'|| l_proc, 40);
145: return l_legislation_code;
146: end return_legislation_code;

Line 622: per_req_bus.chk_name

618: --
619: hr_api.validate_bus_grp_id(p_rec.business_group_id); -- Validate Bus Grp
620: hr_utility.set_location(l_proc, 20);
621: --
622: per_req_bus.chk_name
623: (p_name => p_rec.name
624: );
625: hr_utility.set_location(l_proc, 30);
626: --

Line 627: per_req_bus.chk_requisition_dates

623: (p_name => p_rec.name
624: );
625: hr_utility.set_location(l_proc, 30);
626: --
627: per_req_bus.chk_requisition_dates
628: (p_date_from => p_rec.date_from
629: ,p_date_to => p_rec.date_to
630: ,p_requisition_id => p_rec.requisition_id
631: ,p_object_version_number => p_rec.object_version_number

Line 635: per_req_bus.chk_person_id

631: ,p_object_version_number => p_rec.object_version_number
632: );
633: hr_utility.set_location(l_proc, 40);
634: --
635: per_req_bus.chk_person_id
636: (p_person_id => p_rec.person_id
637: ,p_requisition_id => p_rec.requisition_id
638: ,p_object_version_number => p_rec.object_version_number
639: ,p_date_from => p_rec.date_from

Line 644: per_req_bus.chk_df

640: ,p_date_to => p_rec.date_to
641: );
642: hr_utility.set_location(l_proc, 50);
643: --
644: per_req_bus.chk_df
645: (p_rec => p_rec
646: );
647: hr_multi_message.end_validation_set();
648: --

Line 674: per_req_bus.chk_requisition_dates

670: );
671: hr_api.validate_bus_grp_id(p_rec.business_group_id); -- Validate Bus Grp
672: hr_utility.set_location(l_proc, 30);
673: --
674: per_req_bus.chk_requisition_dates
675: (p_date_from => p_rec.date_from
676: ,p_date_to => p_rec.date_to
677: ,p_requisition_id => p_rec.requisition_id
678: ,p_object_version_number => p_rec.object_version_number

Line 682: per_req_bus.chk_person_id

678: ,p_object_version_number => p_rec.object_version_number
679: );
680: hr_utility.set_location(l_proc, 40);
681: --
682: per_req_bus.chk_person_id
683: (p_person_id => p_rec.person_id
684: ,p_requisition_id => p_rec.requisition_id
685: ,p_object_version_number => p_rec.object_version_number
686: ,p_date_from => p_rec.date_from

Line 691: per_req_bus.chk_df

687: ,p_date_to => p_rec.date_to
688: );
689: hr_utility.set_location(l_proc, 50);
690: --
691: per_req_bus.chk_df
692: (p_rec => p_rec
693: );
694: hr_multi_message.end_validation_set();
695: --

Line 716: end per_req_bus;

712: --
713: hr_utility.set_location(' Leaving:'||l_proc, 10);
714: End delete_validate;
715: --
716: end per_req_bus;