1 package AK_LOV_RELATIONS_PKG AUTHID CURRENT_USER as
2 /* $Header: AKDRLOVS.pls 120.2 2005/09/29 14:00:04 tshort ship $ */
3
4 procedure INSERT_ROW (
5 X_ROWID in out NOCOPY VARCHAR2,
6 X_REGION_APPLICATION_ID in NUMBER,
7 X_REGION_CODE in VARCHAR2,
8 X_ATTRIBUTE_APPLICATION_ID in NUMBER,
9 X_ATTRIBUTE_CODE in VARCHAR2,
10 X_LOV_REGION_APPL_ID in NUMBER,
11 X_LOV_REGION_CODE in VARCHAR2,
12 X_LOV_ATTRIBUTE_APPL_ID in NUMBER,
13 X_LOV_ATTRIBUTE_CODE in VARCHAR2,
14 X_BASE_REGION_APPL_ID in NUMBER default null,
15 X_BASE_REGION_CODE in VARCHAR2 default null,
16 X_BASE_ATTRIBUTE_APPL_ID in NUMBER,
17 X_BASE_ATTRIBUTE_CODE in VARCHAR2,
18 X_DIRECTION_FLAG in VARCHAR2,
19 X_REQUIRED_FLAG in VARCHAR2,
20 X_LAST_UPDATE_DATE in DATE,
21 X_LAST_UPDATED_BY in NUMBER,
22 X_CREATION_DATE in DATE,
23 X_CREATED_BY in NUMBER,
24 X_LAST_UPDATE_LOGIN in NUMBER
25 );
26
27 procedure DELETE_ROW (
28 X_REGION_APPLICATION_ID in NUMBER,
29 X_REGION_CODE in VARCHAR2,
30 X_ATTRIBUTE_APPLICATION_ID in NUMBER,
31 X_ATTRIBUTE_CODE in VARCHAR2,
32 X_LOV_REGION_APPL_ID in NUMBER,
33 X_LOV_REGION_CODE in VARCHAR2,
34 X_LOV_ATTRIBUTE_APPL_ID in NUMBER,
35 X_LOV_ATTRIBUTE_CODE in VARCHAR2,
36 X_BASE_REGION_APPL_ID in NUMBER default null,
37 X_BASE_REGION_CODE in VARCHAR2 default null,
38 X_BASE_ATTRIBUTE_APPL_ID in NUMBER,
39 X_BASE_ATTRIBUTE_CODE in VARCHAR2,
40 X_DIRECTION_FLAG in VARCHAR2
41 );
42
43 procedure LOCK_ROW (
44 X_REGION_APPLICATION_ID in NUMBER,
45 X_REGION_CODE in VARCHAR2,
46 X_ATTRIBUTE_APPLICATION_ID in NUMBER,
47 X_ATTRIBUTE_CODE in VARCHAR2,
48 X_LOV_REGION_APPL_ID in NUMBER,
49 X_LOV_REGION_CODE in VARCHAR2,
50 X_LOV_ATTRIBUTE_APPL_ID in NUMBER,
51 X_LOV_ATTRIBUTE_CODE in VARCHAR2,
52 X_BASE_REGION_APPL_ID in NUMBER default null,
53 X_BASE_REGION_CODE in VARCHAR2 default null,
54 X_BASE_ATTRIBUTE_APPL_ID in NUMBER,
55 X_BASE_ATTRIBUTE_CODE in VARCHAR2,
56 X_DIRECTION_FLAG in VARCHAR2,
57 X_REQUIRED_FLAG in VARCHAR2
58 );
59
60 procedure UPDATE_ROW (
61 X_REGION_APPLICATION_ID in NUMBER,
62 X_REGION_CODE in VARCHAR2,
63 X_ATTRIBUTE_APPLICATION_ID in NUMBER,
64 X_ATTRIBUTE_CODE in VARCHAR2,
65 X_LOV_REGION_APPL_ID in NUMBER,
66 X_LOV_REGION_CODE in VARCHAR2,
67 X_LOV_ATTRIBUTE_APPL_ID in NUMBER,
68 X_LOV_ATTRIBUTE_CODE in VARCHAR2,
69 X_BASE_REGION_APPL_ID in NUMBER default null,
70 X_BASE_REGION_CODE in VARCHAR2 default null,
71 X_BASE_ATTRIBUTE_APPL_ID in NUMBER,
72 X_BASE_ATTRIBUTE_CODE in VARCHAR2,
73 X_DIRECTION_FLAG in VARCHAR2,
74 X_REQUIRED_FLAG in VARCHAR2,
75 X_LAST_UPDATE_DATE in DATE,
76 X_LAST_UPDATED_BY in NUMBER,
77 X_LAST_UPDATE_LOGIN in NUMBER
78 );
79
80 end AK_LOV_RELATIONS_PKG;
[Home] [Help]