1: package body OTA_CATEGORY_USAGE_BK2 as
2: /* $Header: otctuapi.pkb 120.0 2005/05/29 07:10:13 generated noship $ */
3: -- Code generated by the Oracle HRMS API Hook Pre-processor
4: -- Created on 2007/01/03 22:29:27 (YYYY/MM/DD HH24:MI:SS)
5: procedure UPDATE_CATEGORY_A
37: ,P_END_DATE_ACTIVE in DATE
38: ,P_COMMENTS in VARCHAR2
39: )is
40: begin
41: hr_utility.set_location('Entering: OTA_CATEGORY_USAGE_BK2.UPDATE_CATEGORY_A', 10);
42: hr_utility.set_location(' Leaving: OTA_CATEGORY_USAGE_BK2.UPDATE_CATEGORY_A', 20);
43: end UPDATE_CATEGORY_A;
44: procedure UPDATE_CATEGORY_B
45: (P_EFFECTIVE_DATE in DATE
38: ,P_COMMENTS in VARCHAR2
39: )is
40: begin
41: hr_utility.set_location('Entering: OTA_CATEGORY_USAGE_BK2.UPDATE_CATEGORY_A', 10);
42: hr_utility.set_location(' Leaving: OTA_CATEGORY_USAGE_BK2.UPDATE_CATEGORY_A', 20);
43: end UPDATE_CATEGORY_A;
44: procedure UPDATE_CATEGORY_B
45: (P_EFFECTIVE_DATE in DATE
46: ,P_CATEGORY_USAGE_ID in NUMBER
76: ,P_END_DATE_ACTIVE in DATE
77: ,P_COMMENTS in VARCHAR2
78: )is
79: begin
80: hr_utility.set_location('Entering: OTA_CATEGORY_USAGE_BK2.UPDATE_CATEGORY_B', 10);
81: hr_utility.set_location(' Leaving: OTA_CATEGORY_USAGE_BK2.UPDATE_CATEGORY_B', 20);
82: end UPDATE_CATEGORY_B;
83: end OTA_CATEGORY_USAGE_BK2;
77: ,P_COMMENTS in VARCHAR2
78: )is
79: begin
80: hr_utility.set_location('Entering: OTA_CATEGORY_USAGE_BK2.UPDATE_CATEGORY_B', 10);
81: hr_utility.set_location(' Leaving: OTA_CATEGORY_USAGE_BK2.UPDATE_CATEGORY_B', 20);
82: end UPDATE_CATEGORY_B;
83: end OTA_CATEGORY_USAGE_BK2;
79: begin
80: hr_utility.set_location('Entering: OTA_CATEGORY_USAGE_BK2.UPDATE_CATEGORY_B', 10);
81: hr_utility.set_location(' Leaving: OTA_CATEGORY_USAGE_BK2.UPDATE_CATEGORY_B', 20);
82: end UPDATE_CATEGORY_B;
83: end OTA_CATEGORY_USAGE_BK2;