1 package JTF_LOC_HIERARCHIES_PKG AUTHID CURRENT_USER as
2 /* $Header: jtfllohs.pls 120.2 2005/11/07 14:04:13 cmehta ship $ */
3 procedure INSERT_ROW (
4 X_ROWID in out nocopy VARCHAR2,
5 X_LOCATION_HIERARCHY_ID in NUMBER,
6 X_OBJECT_VERSION_NUMBER in NUMBER,
7 X_REQUEST_ID in NUMBER,
8 X_PROGRAM_APPLICATION_ID in NUMBER,
9 X_PROGRAM_ID in NUMBER,
10 X_PROGRAM_UPDATE_DATE in DATE,
11 X_CREATED_BY_APPLICATION_ID in NUMBER,
12 X_LOCATION_TYPE_CODE in VARCHAR2,
13 X_START_DATE_ACTIVE in DATE,
14 X_END_DATE_ACTIVE in DATE,
15 X_AREA1_ID in NUMBER,
16 X_AREA1_CODE in VARCHAR2,
17 X_AREA2_ID in NUMBER,
18 X_AREA2_CODE in VARCHAR2,
19 X_COUNTRY_ID in NUMBER,
20 X_COUNTRY_CODE in VARCHAR2,
21 X_COUNTRY_REGION_ID in NUMBER,
22 X_COUNTRY_REGION_CODE in VARCHAR2,
23 X_STATE_ID in NUMBER,
24 X_STATE_CODE in VARCHAR2,
25 X_STATE_REGION_ID in NUMBER,
26 X_STATE_REGION_CODE in VARCHAR2,
27 X_CITY_ID in NUMBER,
28 X_CITY_CODE in VARCHAR2,
29 X_POSTAL_CODE_ID in NUMBER,
30 X_CREATION_DATE in DATE,
31 X_CREATED_BY in NUMBER,
32 X_LAST_UPDATE_DATE in DATE,
33 X_LAST_UPDATED_BY in NUMBER,
34 X_LAST_UPDATE_LOGIN in NUMBER
35 );
36
37 procedure UPDATE_ROW (
38 X_LOCATION_HIERARCHY_ID in NUMBER,
39 X_OBJECT_VERSION_NUMBER in NUMBER,
40 X_REQUEST_ID in NUMBER,
41 X_PROGRAM_APPLICATION_ID in NUMBER,
42 X_PROGRAM_ID in NUMBER,
43 X_PROGRAM_UPDATE_DATE in DATE,
44 X_CREATED_BY_APPLICATION_ID in NUMBER,
45 X_LOCATION_TYPE_CODE in VARCHAR2,
46 X_START_DATE_ACTIVE in DATE,
47 X_END_DATE_ACTIVE in DATE,
48 X_AREA1_ID in NUMBER,
49 X_AREA1_CODE in VARCHAR2,
50 X_AREA2_ID in NUMBER,
51 X_AREA2_CODE in VARCHAR2,
52 X_COUNTRY_ID in NUMBER,
53 X_COUNTRY_CODE in VARCHAR2,
54 X_COUNTRY_REGION_ID in NUMBER,
55 X_COUNTRY_REGION_CODE in VARCHAR2,
56 X_STATE_ID in NUMBER,
57 X_STATE_CODE in VARCHAR2,
58 X_STATE_REGION_ID in NUMBER,
59 X_STATE_REGION_CODE in VARCHAR2,
60 X_CITY_ID in NUMBER,
61 X_CITY_CODE in VARCHAR2,
62 X_POSTAL_CODE_ID in NUMBER,
63 X_LAST_UPDATE_DATE in DATE,
64 X_LAST_UPDATED_BY in NUMBER,
65 X_LAST_UPDATE_LOGIN in NUMBER
66 );
67
68 procedure DELETE_ROW (
69 X_LOCATION_HIERARCHY_ID in NUMBER
70 );
71
72 procedure LOAD_ROW(
73 X_LOCATION_HIERARCHY_ID in NUMBER,
74 X_REQUEST_ID in NUMBER,
75 X_PROGRAM_APPLICATION_ID in NUMBER,
76 X_PROGRAM_ID in NUMBER,
77 X_PROGRAM_UPDATE_DATE in DATE,
78 X_CREATED_BY_APPLICATION_ID in NUMBER,
79 X_LOCATION_TYPE_CODE in VARCHAR2,
80 X_START_DATE_ACTIVE in DATE,
81 X_END_DATE_ACTIVE in DATE,
82 X_AREA1_ID in NUMBER,
83 X_AREA1_CODE in VARCHAR2,
84 X_AREA2_ID in NUMBER,
85 X_AREA2_CODE in VARCHAR2,
86 X_COUNTRY_ID in NUMBER,
87 X_COUNTRY_CODE in VARCHAR2,
88 X_COUNTRY_REGION_ID in NUMBER,
89 X_COUNTRY_REGION_CODE in VARCHAR2,
90 X_STATE_ID in NUMBER,
91 X_STATE_CODE in VARCHAR2,
92 X_STATE_REGION_ID in NUMBER,
93 X_STATE_REGION_CODE in VARCHAR2,
94 X_CITY_ID in NUMBER,
95 X_CITY_CODE in VARCHAR2,
96 X_POSTAL_CODE_ID in NUMBER,
97 X_OWNER in VARCHAR2
98 );
99
100 end JTF_LOC_HIERARCHIES_PKG;