1: package body OTA_ACTIVITY_CATEGORY_BK2 as
2: /* $Header: otaciapi.pkb 120.0 2005/05/29 06:50:49 generated noship $ */
3: -- Code generated by the Oracle HRMS API Hook Pre-processor
4: -- Created on 2007/01/03 22:29:06 (YYYY/MM/DD HH24:MI:SS)
5: procedure UPDATE_ACT_CAT_INCLUSION_A
34: ,P_PRIMARY_FLAG in VARCHAR2
35: ,P_CATEGORY_USAGE_ID in NUMBER
36: )is
37: begin
38: hr_utility.set_location('Entering: OTA_ACTIVITY_CATEGORY_BK2.UPDATE_ACT_CAT_INCLUSION_A', 10);
39: hr_utility.set_location(' Leaving: OTA_ACTIVITY_CATEGORY_BK2.UPDATE_ACT_CAT_INCLUSION_A', 20);
40: end UPDATE_ACT_CAT_INCLUSION_A;
41: procedure UPDATE_ACT_CAT_INCLUSION_B
42: (P_EFFECTIVE_DATE in DATE
35: ,P_CATEGORY_USAGE_ID in NUMBER
36: )is
37: begin
38: hr_utility.set_location('Entering: OTA_ACTIVITY_CATEGORY_BK2.UPDATE_ACT_CAT_INCLUSION_A', 10);
39: hr_utility.set_location(' Leaving: OTA_ACTIVITY_CATEGORY_BK2.UPDATE_ACT_CAT_INCLUSION_A', 20);
40: end UPDATE_ACT_CAT_INCLUSION_A;
41: procedure UPDATE_ACT_CAT_INCLUSION_B
42: (P_EFFECTIVE_DATE in DATE
43: ,P_ACTIVITY_VERSION_ID in NUMBER
70: ,P_PRIMARY_FLAG in VARCHAR2
71: ,P_CATEGORY_USAGE_ID in NUMBER
72: )is
73: begin
74: hr_utility.set_location('Entering: OTA_ACTIVITY_CATEGORY_BK2.UPDATE_ACT_CAT_INCLUSION_B', 10);
75: hr_utility.set_location(' Leaving: OTA_ACTIVITY_CATEGORY_BK2.UPDATE_ACT_CAT_INCLUSION_B', 20);
76: end UPDATE_ACT_CAT_INCLUSION_B;
77: end OTA_ACTIVITY_CATEGORY_BK2;
71: ,P_CATEGORY_USAGE_ID in NUMBER
72: )is
73: begin
74: hr_utility.set_location('Entering: OTA_ACTIVITY_CATEGORY_BK2.UPDATE_ACT_CAT_INCLUSION_B', 10);
75: hr_utility.set_location(' Leaving: OTA_ACTIVITY_CATEGORY_BK2.UPDATE_ACT_CAT_INCLUSION_B', 20);
76: end UPDATE_ACT_CAT_INCLUSION_B;
77: end OTA_ACTIVITY_CATEGORY_BK2;
73: begin
74: hr_utility.set_location('Entering: OTA_ACTIVITY_CATEGORY_BK2.UPDATE_ACT_CAT_INCLUSION_B', 10);
75: hr_utility.set_location(' Leaving: OTA_ACTIVITY_CATEGORY_BK2.UPDATE_ACT_CAT_INCLUSION_B', 20);
76: end UPDATE_ACT_CAT_INCLUSION_B;
77: end OTA_ACTIVITY_CATEGORY_BK2;