DBA Data[Home] [Help]

PACKAGE BODY: APPS.BEN_CWB_PERSON_GROUPS_BK2

Source


1 package body BEN_CWB_PERSON_GROUPS_BK2 as
2 /* $Header: becpgapi.pkb 120.5.12000000.1 2007/01/19 02:23:07 generated noship $ */
3 -- Code generated by the Oracle HRMS API Hook Pre-processor
4 -- Created on 2007/10/22 06:49:52 (YYYY/MM/DD HH24:MI:SS)
5 procedure UPDATE_GROUP_BUDGET_A
6 (P_GROUP_PER_IN_LER_ID in NUMBER
7 ,P_GROUP_PL_ID in NUMBER
8 ,P_GROUP_OIPL_ID in NUMBER
9 ,P_LF_EVT_OCRD_DT in DATE
10 ,P_BDGT_POP_CD in VARCHAR2
11 ,P_DUE_DT in DATE
12 ,P_ACCESS_CD in VARCHAR2
13 ,P_APPROVAL_CD in VARCHAR2
14 ,P_APPROVAL_DATE in DATE
15 ,P_APPROVAL_COMMENTS in VARCHAR2
16 ,P_DIST_BDGT_VAL in NUMBER
17 ,P_WS_BDGT_VAL in NUMBER
18 ,P_RSRV_VAL in NUMBER
19 ,P_DIST_BDGT_MN_VAL in NUMBER
20 ,P_DIST_BDGT_MX_VAL in NUMBER
21 ,P_DIST_BDGT_INCR_VAL in NUMBER
22 ,P_WS_BDGT_MN_VAL in NUMBER
23 ,P_WS_BDGT_MX_VAL in NUMBER
24 ,P_WS_BDGT_INCR_VAL in NUMBER
25 ,P_RSRV_MN_VAL in NUMBER
26 ,P_RSRV_MX_VAL in NUMBER
27 ,P_RSRV_INCR_VAL in NUMBER
28 ,P_DIST_BDGT_ISS_VAL in NUMBER
29 ,P_WS_BDGT_ISS_VAL in NUMBER
30 ,P_DIST_BDGT_ISS_DATE in DATE
31 ,P_WS_BDGT_ISS_DATE in DATE
32 ,P_WS_BDGT_VAL_LAST_UPD_DATE in DATE
33 ,P_DIST_BDGT_VAL_LAST_UPD_DATE in DATE
34 ,P_RSRV_VAL_LAST_UPD_DATE in DATE
35 ,P_WS_BDGT_VAL_LAST_UPD_BY in NUMBER
36 ,P_DIST_BDGT_VAL_LAST_UPD_BY in NUMBER
37 ,P_RSRV_VAL_LAST_UPD_BY in NUMBER
38 ,P_SUBMIT_CD in VARCHAR2
39 ,P_SUBMIT_DATE in DATE
40 ,P_SUBMIT_COMMENTS in VARCHAR2
41 ,P_OBJECT_VERSION_NUMBER in NUMBER
42 )is
43 begin
44 hr_utility.set_location('Entering: BEN_CWB_PERSON_GROUPS_BK2.UPDATE_GROUP_BUDGET_A', 10);
45 hr_utility.set_location(' Leaving: BEN_CWB_PERSON_GROUPS_BK2.UPDATE_GROUP_BUDGET_A', 20);
46 end UPDATE_GROUP_BUDGET_A;
47 procedure UPDATE_GROUP_BUDGET_B
48 (P_GROUP_PER_IN_LER_ID in NUMBER
49 ,P_GROUP_PL_ID in NUMBER
50 ,P_GROUP_OIPL_ID in NUMBER
51 ,P_LF_EVT_OCRD_DT in DATE
52 ,P_BDGT_POP_CD in VARCHAR2
53 ,P_DUE_DT in DATE
54 ,P_ACCESS_CD in VARCHAR2
55 ,P_APPROVAL_CD in VARCHAR2
56 ,P_APPROVAL_DATE in DATE
57 ,P_APPROVAL_COMMENTS in VARCHAR2
58 ,P_DIST_BDGT_VAL in NUMBER
59 ,P_WS_BDGT_VAL in NUMBER
60 ,P_RSRV_VAL in NUMBER
61 ,P_DIST_BDGT_MN_VAL in NUMBER
62 ,P_DIST_BDGT_MX_VAL in NUMBER
63 ,P_DIST_BDGT_INCR_VAL in NUMBER
64 ,P_WS_BDGT_MN_VAL in NUMBER
65 ,P_WS_BDGT_MX_VAL in NUMBER
66 ,P_WS_BDGT_INCR_VAL in NUMBER
67 ,P_RSRV_MN_VAL in NUMBER
68 ,P_RSRV_MX_VAL in NUMBER
69 ,P_RSRV_INCR_VAL in NUMBER
70 ,P_DIST_BDGT_ISS_VAL in NUMBER
71 ,P_WS_BDGT_ISS_VAL in NUMBER
72 ,P_DIST_BDGT_ISS_DATE in DATE
73 ,P_WS_BDGT_ISS_DATE in DATE
74 ,P_WS_BDGT_VAL_LAST_UPD_DATE in DATE
75 ,P_DIST_BDGT_VAL_LAST_UPD_DATE in DATE
76 ,P_RSRV_VAL_LAST_UPD_DATE in DATE
77 ,P_WS_BDGT_VAL_LAST_UPD_BY in NUMBER
78 ,P_DIST_BDGT_VAL_LAST_UPD_BY in NUMBER
79 ,P_RSRV_VAL_LAST_UPD_BY in NUMBER
80 ,P_SUBMIT_CD in VARCHAR2
81 ,P_SUBMIT_DATE in DATE
82 ,P_SUBMIT_COMMENTS in VARCHAR2
83 ,P_OBJECT_VERSION_NUMBER in NUMBER
84 )is
85 begin
86 hr_utility.set_location('Entering: BEN_CWB_PERSON_GROUPS_BK2.UPDATE_GROUP_BUDGET_B', 10);
87 hr_utility.set_location(' Leaving: BEN_CWB_PERSON_GROUPS_BK2.UPDATE_GROUP_BUDGET_B', 20);
88 end UPDATE_GROUP_BUDGET_B;
89 end BEN_CWB_PERSON_GROUPS_BK2;