DBA Data[Home] [Help]

APPS.PQP_VRE_BUS dependencies on PQP_VRE_BUS

Line 1: Package Body pqp_vre_bus as

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

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

4: -- ----------------------------------------------------------------------------
5: -- | Private Global Definitions |
6: -- ----------------------------------------------------------------------------
7: --
8: g_package varchar2(33) := ' pqp_vre_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 123: IF ( nvl(pqp_vre_bus.g_vehicle_repository_id, hr_api.g_number)

119: ,p_argument => 'vehicle_repository_id'
120: ,p_argument_value => p_vehicle_repository_id
121: );
122: --
123: IF ( nvl(pqp_vre_bus.g_vehicle_repository_id, hr_api.g_number)
124: = p_vehicle_repository_id) THEN
125: --
126: -- The legislation code has already been found with a previous
127: -- call to this function. Just return the value in the global

Line 130: l_legislation_code := pqp_vre_bus.g_legislation_code;

126: -- The legislation code has already been found with a previous
127: -- call to this function. Just return the value in the global
128: -- variable.
129: --
130: l_legislation_code := pqp_vre_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

Line 154: pqp_vre_bus.g_vehicle_repository_id := p_vehicle_repository_id;

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: pqp_vre_bus.g_vehicle_repository_id := p_vehicle_repository_id;
155: pqp_vre_bus.g_legislation_code := l_legislation_code;
156: END IF;
157: hr_utility.set_location(' Leaving:'|| l_proc, 40);
158: return l_legislation_code;

Line 155: pqp_vre_bus.g_legislation_code := l_legislation_code;

151: -- available for the next call to this function.
152: --
153: CLOSE csr_leg_code;
154: pqp_vre_bus.g_vehicle_repository_id := p_vehicle_repository_id;
155: pqp_vre_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;

Line 911: pqp_vre_bus.get_legislation_code(p_business_group_id);

907: Begin
908:
909: --Getting the legislationId for business groupId
910: l_legislation_code :=
911: pqp_vre_bus.get_legislation_code(p_business_group_id);
912: --setting the lg context
913: hr_api.set_legislation_context(l_legislation_code);
914: OPEN fiscal_cursor;
915: FETCH fiscal_cursor INTO l_meaning;

Line 1825: pqp_vre_bus.chk_ddf(p_rec);

1821: --
1822: -- Validate Dependent Attributes
1823: --
1824: --
1825: pqp_vre_bus.chk_ddf(p_rec);
1826: --
1827: pqp_vre_bus.chk_df(p_rec);
1828: --
1829: hr_utility.set_location(' Leaving:'||l_proc, 10);

Line 1827: pqp_vre_bus.chk_df(p_rec);

1823: --
1824: --
1825: pqp_vre_bus.chk_ddf(p_rec);
1826: --
1827: pqp_vre_bus.chk_df(p_rec);
1828: --
1829: hr_utility.set_location(' Leaving:'||l_proc, 10);
1830: End insert_validate;
1831: --

Line 2243: pqp_vre_bus.chk_ddf(p_rec);

2239: --
2240: -- Call the datetrack update integrity operation
2241: --
2242:
2243: pqp_vre_bus.chk_ddf(p_rec);
2244: --
2245: pqp_vre_bus.chk_df(p_rec);
2246: --
2247: hr_utility.set_location(' Leaving:'||l_proc, 10);

Line 2245: pqp_vre_bus.chk_df(p_rec);

2241: --
2242:
2243: pqp_vre_bus.chk_ddf(p_rec);
2244: --
2245: pqp_vre_bus.chk_df(p_rec);
2246: --
2247: hr_utility.set_location(' Leaving:'||l_proc, 10);
2248: End update_validate;
2249: --

Line 2332: end pqp_vre_bus;

2328: -- one error has been found then abort further validation.
2329: hr_multi_message.end_validation_set;
2330: End delete_validate;
2331: --
2332: end pqp_vre_bus;