1 package PER_CAL_ENTRY_VALUES_LOAD_PKG as
2 /* $Header: peenvlct.pkh 120.0 2005/05/31 08:10 appldev noship $ */
3
4 procedure INSERT_ROW (
5 X_CAL_ENTRY_VALUE_ID in NUMBER,
6 X_CALENDAR_ENTRY_ID in NUMBER,
7 X_HIERARCHY_NODE_ID in NUMBER,
8 X_IDVALUE in VARCHAR2,
9 X_ORG_STRUCTURE_ELEMENT_ID in NUMBER,
10 X_ORGANIZATION_ID in NUMBER,
11 X_OVERRIDE_NAME in VARCHAR2,
12 X_OVERRIDE_TYPE in VARCHAR2,
13 X_PARENT_ENTRY_VALUE_ID in NUMBER,
14 X_USAGE_FLAG in VARCHAR2,
15 X_CREATED_BY in NUMBER,
16 X_LAST_UPDATE_DATE in DATE,
17 X_LAST_UPDATED_BY in NUMBER,
18 X_LAST_UPDATE_LOGIN in NUMBER,
19 X_CREATION_DATE in DATE,
20 X_IDENTIFIER_KEY in VARCHAR2);
21
22 procedure LOAD_ROW (
23 X_VALUE_IDENTIFIER_KEY in VARCHAR2,
24 X_PARENT_VALUE_IDENTIFIER_KEY in VARCHAR2,
25 X_ENTRY_IDENTIFIER_KEY in VARCHAR2,
26 X_HIERARCHY_NODE_NAME in VARCHAR2,
27 X_IDVALUE in VARCHAR2,
28 X_ORG_HIER_NAME in VARCHAR2,
29 X_ORG_HIER_VERSION in NUMBER,
30 X_ORG_HIER_ELEMENT_PARENT in VARCHAR2,
31 X_ORG_HIER_ELEMENT_CHILD in VARCHAR2,
32 X_ORG_HIER_NODE_NAME in VARCHAR2,
33 X_OVERRIDE_NAME in VARCHAR2,
34 X_OVERRIDE_TYPE in VARCHAR2,
35 X_USAGE_FLAG in VARCHAR2,
36 X_OWNER in VARCHAR2,
37 X_LAST_UPDATE_DATE in VARCHAR2);
38
39 procedure UPDATE_ROW (
40 X_CAL_ENTRY_VALUE_ID in NUMBER,
41 X_HIERARCHY_NODE_ID in NUMBER,
42 X_IDVALUE in VARCHAR2,
43 X_ORG_STRUCTURE_ELEMENT_ID in NUMBER,
44 X_ORGANIZATION_ID in NUMBER,
45 X_OVERRIDE_NAME in VARCHAR2,
46 X_OVERRIDE_TYPE in VARCHAR2,
47 X_USAGE_FLAG in VARCHAR2,
48 X_LAST_UPDATE_DATE in DATE,
49 X_LAST_UPDATED_BY in NUMBER,
50 X_LAST_UPDATE_LOGIN in NUMBER);
51
52 end PER_CAL_ENTRY_VALUES_LOAD_PKG;