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;