1 package body BEN_EXT_WHERE_CLAUSE_BK2 as
2 /* $Header: bexwcapi.pkb 120.2 2005/10/11 06:44:36 generated noship $ */
3 -- Code generated by the Oracle HRMS API Hook Pre-processor
4 -- Created on 2007/01/03 21:34:30 (YYYY/MM/DD HH24:MI:SS)
5 procedure UPDATE_EXT_WHERE_CLAUSE_A
6 (P_EXT_WHERE_CLAUSE_ID in NUMBER
7 ,P_SEQ_NUM in NUMBER
8 ,P_OPER_CD in VARCHAR2
9 ,P_VAL in VARCHAR2
10 ,P_AND_OR_CD in VARCHAR2
11 ,P_EXT_DATA_ELMT_ID in NUMBER
12 ,P_COND_EXT_DATA_ELMT_ID in NUMBER
13 ,P_EXT_RCD_IN_FILE_ID in NUMBER
14 ,P_EXT_DATA_ELMT_IN_RCD_ID in NUMBER
15 ,P_BUSINESS_GROUP_ID in NUMBER
16 ,P_LEGISLATION_CODE in VARCHAR2
17 ,P_OBJECT_VERSION_NUMBER in NUMBER
18 ,P_COND_EXT_DATA_ELMT_IN_RCD_ID in NUMBER
19 ,P_EFFECTIVE_DATE in DATE
20 )is
21 begin
22 hr_utility.set_location('Entering: BEN_EXT_WHERE_CLAUSE_BK2.UPDATE_EXT_WHERE_CLAUSE_A', 10);
23 hr_utility.set_location(' Leaving: BEN_EXT_WHERE_CLAUSE_BK2.UPDATE_EXT_WHERE_CLAUSE_A', 20);
24 end UPDATE_EXT_WHERE_CLAUSE_A;
25 procedure UPDATE_EXT_WHERE_CLAUSE_B
26 (P_EXT_WHERE_CLAUSE_ID in NUMBER
27 ,P_SEQ_NUM in NUMBER
28 ,P_OPER_CD in VARCHAR2
29 ,P_VAL in VARCHAR2
30 ,P_AND_OR_CD in VARCHAR2
31 ,P_EXT_DATA_ELMT_ID in NUMBER
32 ,P_COND_EXT_DATA_ELMT_ID in NUMBER
33 ,P_EXT_RCD_IN_FILE_ID in NUMBER
34 ,P_EXT_DATA_ELMT_IN_RCD_ID in NUMBER
35 ,P_BUSINESS_GROUP_ID in NUMBER
36 ,P_LEGISLATION_CODE in VARCHAR2
37 ,P_OBJECT_VERSION_NUMBER in NUMBER
38 ,P_COND_EXT_DATA_ELMT_IN_RCD_ID in NUMBER
39 ,P_EFFECTIVE_DATE in DATE
40 )is
41 begin
42 hr_utility.set_location('Entering: BEN_EXT_WHERE_CLAUSE_BK2.UPDATE_EXT_WHERE_CLAUSE_B', 10);
43 hr_utility.set_location(' Leaving: BEN_EXT_WHERE_CLAUSE_BK2.UPDATE_EXT_WHERE_CLAUSE_B', 20);
44 end UPDATE_EXT_WHERE_CLAUSE_B;
45 end BEN_EXT_WHERE_CLAUSE_BK2;
[Home] [Help]