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.PQP_VAI_BUS dependencies on PQP_VAI_BUS

Line 1: Package Body pqp_vai_bus as

1: Package Body pqp_vai_bus as
2: /* $Header: pqvairhi.pkb 120.0.12010000.2 2008/08/08 07:19:09 ubhat ship $ */
3: --
4: -- ----------------------------------------------------------------------------
5: -- | Private Global Definitions |

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

4: -- ----------------------------------------------------------------------------
5: -- | Private Global Definitions |
6: -- ----------------------------------------------------------------------------
7: --
8: g_package varchar2(33) := ' pqp_vai_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 130: if ( nvl(pqp_vai_bus.g_vehicle_allocation_id, hr_api.g_number)

126: ,p_argument => 'vehicle_allocation_id'
127: ,p_argument_value => p_vehicle_allocation_id
128: );
129: --
130: if ( nvl(pqp_vai_bus.g_vehicle_allocation_id, hr_api.g_number)
131: = p_vehicle_allocation_id) then
132: --
133: -- The legislation code has already been found with a previous
134: -- call to this function. Just return the value in the global

Line 137: l_legislation_code := pqp_vai_bus.g_legislation_code;

133: -- The legislation code has already been found with a previous
134: -- call to this function. Just return the value in the global
135: -- variable.
136: --
137: l_legislation_code := pqp_vai_bus.g_legislation_code;
138: hr_utility.set_location(l_proc, 20);
139: else
140: --
141: -- The ID is different to the last call to this function

Line 161: pqp_vai_bus.g_vehicle_allocation_id := p_vehicle_allocation_id;

157: -- Set the global variables so the values are
158: -- available for the next call to this function.
159: --
160: close csr_leg_code;
161: pqp_vai_bus.g_vehicle_allocation_id := p_vehicle_allocation_id;
162: pqp_vai_bus.g_legislation_code := l_legislation_code;
163: end if;
164: hr_utility.set_location(' Leaving:'|| l_proc, 40);
165: return l_legislation_code;

Line 162: pqp_vai_bus.g_legislation_code := l_legislation_code;

158: -- available for the next call to this function.
159: --
160: close csr_leg_code;
161: pqp_vai_bus.g_vehicle_allocation_id := p_vehicle_allocation_id;
162: pqp_vai_bus.g_legislation_code := l_legislation_code;
163: end if;
164: hr_utility.set_location(' Leaving:'|| l_proc, 40);
165: return l_legislation_code;
166: end return_legislation_code;

Line 204: if ( nvl(pqp_vai_bus.g_vehicle_allocation_id, hr_api.g_number)

200: ,p_argument => 'vehicle_allocation_id'
201: ,p_argument_value => p_vehicle_allocation_id
202: );
203: --
204: if ( nvl(pqp_vai_bus.g_vehicle_allocation_id, hr_api.g_number)
205: = p_vehicle_allocation_id) then
206: --
207: -- The legislation code has already been found with a previous
208: -- call to this function. Just return the value in the global

Line 211: l_legislation_code := pqp_vai_bus.g_legislation_code;

207: -- The legislation code has already been found with a previous
208: -- call to this function. Just return the value in the global
209: -- variable.
210: --
211: l_legislation_code := pqp_vai_bus.g_legislation_code;
212: hr_utility.set_location(l_proc, 20);
213: else
214: --
215: -- The ID is different to the last call to this function

Line 235: pqp_vai_bus.g_vehicle_allocation_id := p_vehicle_allocation_id;

231: -- Set the global variables so the values are
232: -- available for the next call to this function.
233: --
234: close csr_leg_code;
235: pqp_vai_bus.g_vehicle_allocation_id := p_vehicle_allocation_id;
236: pqp_vai_bus.g_legislation_code := l_legislation_code;
237: end if;
238: hr_utility.set_location(' Leaving:'|| l_proc, 40);
239: return l_legislation_code;

Line 236: pqp_vai_bus.g_legislation_code := l_legislation_code;

232: -- available for the next call to this function.
233: --
234: close csr_leg_code;
235: pqp_vai_bus.g_vehicle_allocation_id := p_vehicle_allocation_id;
236: pqp_vai_bus.g_legislation_code := l_legislation_code;
237: end if;
238: hr_utility.set_location(' Leaving:'|| l_proc, 40);
239: return l_legislation_code;
240: end return_alloc_legislation_code;

Line 640: pqp_vai_bus.chk_ddf(p_rec);

636: --
637: -- Validate Dependent Attributes
638: --
639: --
640: pqp_vai_bus.chk_ddf(p_rec);
641: --
642: -- pqp_vai_bus.chk_df(p_rec);
643: --
644: hr_utility.set_location(' Leaving:'||l_proc, 10);

Line 642: -- pqp_vai_bus.chk_df(p_rec);

638: --
639: --
640: pqp_vai_bus.chk_ddf(p_rec);
641: --
642: -- pqp_vai_bus.chk_df(p_rec);
643: --
644: hr_utility.set_location(' Leaving:'||l_proc, 10);
645: End insert_validate;
646: --

Line 676: pqp_vai_bus.chk_ddf(p_rec);

672: (p_rec => p_rec
673: );
674: --
675: --
676: pqp_vai_bus.chk_ddf(p_rec);
677: --
678: pqp_vai_bus.chk_df(p_rec);
679: --
680: hr_utility.set_location(' Leaving:'||l_proc, 10);

Line 678: pqp_vai_bus.chk_df(p_rec);

674: --
675: --
676: pqp_vai_bus.chk_ddf(p_rec);
677: --
678: pqp_vai_bus.chk_df(p_rec);
679: --
680: hr_utility.set_location(' Leaving:'||l_proc, 10);
681: End update_validate;
682: --

Line 700: end pqp_vai_bus;

696: --
697: hr_utility.set_location(' Leaving:'||l_proc, 10);
698: End delete_validate;
699: --
700: end pqp_vai_bus;