1 package body PQH_WORKSHEET_PERIODS_BK2 as
2 /* $Header: pqwprapi.pkb 115.3 2002/12/06 23:50:10 generated noship $ */
3 -- Code generated by the Oracle HRMS API Hook Pre-processor
4 -- Created on 2007/01/03 22:53:46 (YYYY/MM/DD HH24:MI:SS)
5 procedure UPDATE_WORKSHEET_PERIOD_A
6 (P_WORKSHEET_PERIOD_ID in NUMBER
7 ,P_END_TIME_PERIOD_ID in NUMBER
8 ,P_WORKSHEET_DETAIL_ID in NUMBER
9 ,P_BUDGET_UNIT1_PERCENT in NUMBER
10 ,P_BUDGET_UNIT2_PERCENT in NUMBER
11 ,P_BUDGET_UNIT3_PERCENT in NUMBER
12 ,P_BUDGET_UNIT1_VALUE in NUMBER
13 ,P_BUDGET_UNIT2_VALUE in NUMBER
14 ,P_BUDGET_UNIT3_VALUE in NUMBER
15 ,P_OBJECT_VERSION_NUMBER in NUMBER
16 ,P_BUDGET_UNIT1_VALUE_TYPE_CD in VARCHAR2
17 ,P_BUDGET_UNIT2_VALUE_TYPE_CD in VARCHAR2
18 ,P_BUDGET_UNIT3_VALUE_TYPE_CD in VARCHAR2
19 ,P_START_TIME_PERIOD_ID in NUMBER
20 ,P_BUDGET_UNIT3_AVAILABLE in NUMBER
21 ,P_BUDGET_UNIT2_AVAILABLE in NUMBER
22 ,P_BUDGET_UNIT1_AVAILABLE in NUMBER
23 ,P_EFFECTIVE_DATE in DATE
24 )is
25 begin
26 hr_utility.set_location('Entering: PQH_WORKSHEET_PERIODS_BK2.UPDATE_WORKSHEET_PERIOD_A', 10);
27 hr_utility.set_location(' Leaving: PQH_WORKSHEET_PERIODS_BK2.UPDATE_WORKSHEET_PERIOD_A', 20);
28 end UPDATE_WORKSHEET_PERIOD_A;
29 procedure UPDATE_WORKSHEET_PERIOD_B
30 (P_WORKSHEET_PERIOD_ID in NUMBER
31 ,P_END_TIME_PERIOD_ID in NUMBER
32 ,P_WORKSHEET_DETAIL_ID in NUMBER
33 ,P_BUDGET_UNIT1_PERCENT in NUMBER
34 ,P_BUDGET_UNIT2_PERCENT in NUMBER
35 ,P_BUDGET_UNIT3_PERCENT in NUMBER
36 ,P_BUDGET_UNIT1_VALUE in NUMBER
37 ,P_BUDGET_UNIT2_VALUE in NUMBER
38 ,P_BUDGET_UNIT3_VALUE in NUMBER
39 ,P_OBJECT_VERSION_NUMBER in NUMBER
40 ,P_BUDGET_UNIT1_VALUE_TYPE_CD in VARCHAR2
41 ,P_BUDGET_UNIT2_VALUE_TYPE_CD in VARCHAR2
42 ,P_BUDGET_UNIT3_VALUE_TYPE_CD in VARCHAR2
43 ,P_START_TIME_PERIOD_ID in NUMBER
44 ,P_BUDGET_UNIT3_AVAILABLE in NUMBER
45 ,P_BUDGET_UNIT2_AVAILABLE in NUMBER
46 ,P_BUDGET_UNIT1_AVAILABLE in NUMBER
47 ,P_EFFECTIVE_DATE in DATE
48 )is
49 begin
50 hr_utility.set_location('Entering: PQH_WORKSHEET_PERIODS_BK2.UPDATE_WORKSHEET_PERIOD_B', 10);
51 hr_utility.set_location(' Leaving: PQH_WORKSHEET_PERIODS_BK2.UPDATE_WORKSHEET_PERIOD_B', 20);
52 end UPDATE_WORKSHEET_PERIOD_B;
53 end PQH_WORKSHEET_PERIODS_BK2;
[Home] [Help]