APPS.PQH_DE_INS_END_REASONS_API dependencies on PQH_DE_INS_END_REASONS

Line 1: Package Body PQH_DE_ins_END_REASONS_API as

1: Package Body PQH_DE_ins_END_REASONS_API as
2: /* $Header: pqpreapi.pkb 115.1 2002/12/03 20:42:04 rpasapul noship $ */
3: --
4: -- Package Variables
5: --

Line 6: g_package varchar2(33) := 'PQH_DE_iNs_END_REASONS_API.';

2: /* $Header: pqpreapi.pkb 115.1 2002/12/03 20:42:04 rpasapul noship $ */
3: --
4: -- Package Variables
5: --
6: g_package varchar2(33) := 'PQH_DE_iNs_END_REASONS_API.';
7: --
8: -- ----------------------------------------------------------------------------
9: -- |--------------------------< Insert_PENSION_END_REASONS >------------------|
10: -- ----------------------------------------------------------------------------

Line 28: l_object_Version_Number PQH_DE_INS_END_REASONS.OBJECT_VERSION_NUMBER%TYPE;

24: -- Declare cursors and local variables
25: --
26:
27: l_proc varchar2(72) := g_package||'Insert_PENSION_END_REASONS';
28: l_object_Version_Number PQH_DE_INS_END_REASONS.OBJECT_VERSION_NUMBER%TYPE;
29: L_Effective_Date Date;
30: l_INS_end_reason_id PQH_DE_INS_END_REASONS.INS_end_reason_id%TYPE;
31:
32: begin

Line 30: l_INS_end_reason_id PQH_DE_INS_END_REASONS.INS_end_reason_id%TYPE;

26:
27: l_proc varchar2(72) := g_package||'Insert_PENSION_END_REASONS';
28: l_object_Version_Number PQH_DE_INS_END_REASONS.OBJECT_VERSION_NUMBER%TYPE;
29: L_Effective_Date Date;
30: l_INS_end_reason_id PQH_DE_INS_END_REASONS.INS_end_reason_id%TYPE;
31:
32: begin
33: hr_utility.set_location('Entering:'|| l_proc, 10);
34: --

Line 48: PQH_DE_ins_END_REASONS_BK1.Insert_PENSION_END_REASONS_b

44: --
45: begin
46:
47:
48: PQH_DE_ins_END_REASONS_BK1.Insert_PENSION_END_REASONS_b
49: (p_effective_date => L_Effective_Date
50: ,p_business_group_id => p_business_group_id
51: ,P_provider_organization_id => P_provider_organization_id
52: ,p_end_reason_number => p_end_reason_number

Line 87: PQH_DE_ins_END_REASONS_BK1.Insert_PENSION_END_REASONS_a

83: --
84: begin
85:
86:
87: PQH_DE_ins_END_REASONS_BK1.Insert_PENSION_END_REASONS_a
88: (p_effective_date => L_Effective_Date
89: ,p_business_group_id => p_business_group_id
90: ,P_provider_organization_id => P_provider_organization_id
91: ,p_end_reason_number => p_end_reason_number

Line 164: l_object_Version_Number PQH_DE_INS_END_REASONS.OBJECT_VERSION_NUMBER%TYPE := P_Object_version_Number;

160: ,p_end_reason_description in varchar2 default hr_api.g_varchar2
161: ) Is
162:
163: l_proc varchar2(72) := g_package||'Update_PENSION_END_REASONS';
164: l_object_Version_Number PQH_DE_INS_END_REASONS.OBJECT_VERSION_NUMBER%TYPE := P_Object_version_Number;
165: L_Effective_Date Date;
166:
167: Begin
168: hr_utility.set_location('Entering:'|| l_proc, 10);

Line 183: PQH_DE_ins_END_REASONS_BK2.Update_PENSION_END_REASONS_b

179: --
180: begin
181:
182:
183: PQH_DE_ins_END_REASONS_BK2.Update_PENSION_END_REASONS_b
184: (p_effective_date => L_Effective_Date
185: ,p_business_group_id => p_business_group_id
186: ,P_provider_organization_id => P_provider_organization_id
187: ,p_end_reason_number => p_end_reason_number

Line 221: PQH_DE_ins_END_REASONS_BK2.Update_PENSION_END_REASONS_a

217: --
218: begin
219:
220:
221: PQH_DE_ins_END_REASONS_BK2.Update_PENSION_END_REASONS_a
222: (p_effective_date => L_Effective_Date
223: ,p_business_group_id => p_business_group_id
224: ,P_provider_organization_id => P_provider_organization_id
225: ,p_end_reason_number => p_end_reason_number

Line 301: PQH_DE_ins_END_REASONS_BK3.Delete_PENSION_END_REASONS_b

297: --
298: -- Call Before Process User Hook
299: --
300: begin
301: PQH_DE_ins_END_REASONS_BK3.Delete_PENSION_END_REASONS_b
302: (p_InS_end_reason_id => p_INS_END_REASON_Id
303: ,p_object_version_number => p_object_version_number);
304: exception
305: when hr_api.cannot_find_prog_unit then

Line 322: PQH_DE_ins_END_REASONS_BK3.Delete_PENSION_END_REASONS_a

318: -- Call After Process User Hook
319: --
320: begin
321:
322: PQH_DE_ins_END_REASONS_BK3.Delete_PENSION_END_REASONS_a
323: (p_InS_end_reason_id => p_iNs_END_REASON_Id
324: ,p_object_version_number => p_object_version_number);
325:
326: exception

Line 364: end PQH_DE_ins_END_REASONS_API;

360: hr_utility.set_location(' Leaving:'||l_proc, 90);
361: raise;
362: end delete_PENSION_END_REASONS;
363:
364: end PQH_DE_ins_END_REASONS_API;