1 package body PQH_WORKSHEET_BUDGET_SETS_BK2 as
2 /* $Header: pqwstapi.pkb 115.3 2002/12/06 23:50:22 generated noship $ */
3 -- Code generated by the Oracle HRMS API Hook Pre-processor
4 -- Created on 2007/01/03 22:53:47 (YYYY/MM/DD HH24:MI:SS)
5 procedure UPDATE_WORKSHEET_BUDGET_SET_A
6 (P_WORKSHEET_BUDGET_SET_ID in NUMBER
7 ,P_DFLT_BUDGET_SET_ID in NUMBER
8 ,P_WORKSHEET_PERIOD_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_BUDGET_UNIT1_AVAILABLE in NUMBER
20 ,P_BUDGET_UNIT2_AVAILABLE in NUMBER
21 ,P_BUDGET_UNIT3_AVAILABLE in NUMBER
22 ,P_EFFECTIVE_DATE in DATE
23 )is
24 begin
25 hr_utility.set_location('Entering: PQH_WORKSHEET_BUDGET_SETS_BK2.UPDATE_WORKSHEET_BUDGET_SET_A', 10);
26 hr_utility.set_location(' Leaving: PQH_WORKSHEET_BUDGET_SETS_BK2.UPDATE_WORKSHEET_BUDGET_SET_A', 20);
27 end UPDATE_WORKSHEET_BUDGET_SET_A;
28 procedure UPDATE_WORKSHEET_BUDGET_SET_B
29 (P_WORKSHEET_BUDGET_SET_ID in NUMBER
30 ,P_DFLT_BUDGET_SET_ID in NUMBER
31 ,P_WORKSHEET_PERIOD_ID in NUMBER
32 ,P_BUDGET_UNIT1_PERCENT in NUMBER
33 ,P_BUDGET_UNIT2_PERCENT in NUMBER
34 ,P_BUDGET_UNIT3_PERCENT in NUMBER
35 ,P_BUDGET_UNIT1_VALUE in NUMBER
36 ,P_BUDGET_UNIT2_VALUE in NUMBER
37 ,P_BUDGET_UNIT3_VALUE in NUMBER
38 ,P_OBJECT_VERSION_NUMBER in NUMBER
39 ,P_BUDGET_UNIT1_VALUE_TYPE_CD in VARCHAR2
40 ,P_BUDGET_UNIT2_VALUE_TYPE_CD in VARCHAR2
41 ,P_BUDGET_UNIT3_VALUE_TYPE_CD in VARCHAR2
42 ,P_BUDGET_UNIT1_AVAILABLE in NUMBER
43 ,P_BUDGET_UNIT2_AVAILABLE in NUMBER
44 ,P_BUDGET_UNIT3_AVAILABLE in NUMBER
45 ,P_EFFECTIVE_DATE in DATE
46 )is
47 begin
48 hr_utility.set_location('Entering: PQH_WORKSHEET_BUDGET_SETS_BK2.UPDATE_WORKSHEET_BUDGET_SET_B', 10);
49 hr_utility.set_location(' Leaving: PQH_WORKSHEET_BUDGET_SETS_BK2.UPDATE_WORKSHEET_BUDGET_SET_B', 20);
50 end UPDATE_WORKSHEET_BUDGET_SET_B;
51 end PQH_WORKSHEET_BUDGET_SETS_BK2;
[Home] [Help]