1: package body PQH_DE_INS_END_REASONS_BK2 as
2: /* $Header: pqpreapi.pkb 115.1 2002/12/03 20:42:04 generated noship $ */
3: -- Code generated by the Oracle HRMS API Hook Pre-processor
4: -- Created on 2007/01/03 22:53:14 (YYYY/MM/DD HH24:MI:SS)
5: procedure UPDATE_PENSION_END_REASONS_A
12: ,P_END_REASON_SHORT_NAME in VARCHAR2
13: ,P_END_REASON_DESCRIPTION in VARCHAR2
14: )is
15: begin
16: hr_utility.set_location('Entering: PQH_DE_INS_END_REASONS_BK2.UPDATE_PENSION_END_REASONS_A', 10);
17: hr_utility.set_location(' Leaving: PQH_DE_INS_END_REASONS_BK2.UPDATE_PENSION_END_REASONS_A', 20);
18: end UPDATE_PENSION_END_REASONS_A;
19: procedure UPDATE_PENSION_END_REASONS_B
20: (P_EFFECTIVE_DATE in DATE
13: ,P_END_REASON_DESCRIPTION in VARCHAR2
14: )is
15: begin
16: hr_utility.set_location('Entering: PQH_DE_INS_END_REASONS_BK2.UPDATE_PENSION_END_REASONS_A', 10);
17: hr_utility.set_location(' Leaving: PQH_DE_INS_END_REASONS_BK2.UPDATE_PENSION_END_REASONS_A', 20);
18: end UPDATE_PENSION_END_REASONS_A;
19: procedure UPDATE_PENSION_END_REASONS_B
20: (P_EFFECTIVE_DATE in DATE
21: ,P_INS_END_REASON_ID in NUMBER
26: ,P_END_REASON_SHORT_NAME in VARCHAR2
27: ,P_END_REASON_DESCRIPTION in VARCHAR2
28: )is
29: begin
30: hr_utility.set_location('Entering: PQH_DE_INS_END_REASONS_BK2.UPDATE_PENSION_END_REASONS_B', 10);
31: hr_utility.set_location(' Leaving: PQH_DE_INS_END_REASONS_BK2.UPDATE_PENSION_END_REASONS_B', 20);
32: end UPDATE_PENSION_END_REASONS_B;
33: end PQH_DE_INS_END_REASONS_BK2;
27: ,P_END_REASON_DESCRIPTION in VARCHAR2
28: )is
29: begin
30: hr_utility.set_location('Entering: PQH_DE_INS_END_REASONS_BK2.UPDATE_PENSION_END_REASONS_B', 10);
31: hr_utility.set_location(' Leaving: PQH_DE_INS_END_REASONS_BK2.UPDATE_PENSION_END_REASONS_B', 20);
32: end UPDATE_PENSION_END_REASONS_B;
33: end PQH_DE_INS_END_REASONS_BK2;
29: begin
30: hr_utility.set_location('Entering: PQH_DE_INS_END_REASONS_BK2.UPDATE_PENSION_END_REASONS_B', 10);
31: hr_utility.set_location(' Leaving: PQH_DE_INS_END_REASONS_BK2.UPDATE_PENSION_END_REASONS_B', 20);
32: end UPDATE_PENSION_END_REASONS_B;
33: end PQH_DE_INS_END_REASONS_BK2;