1 package BNE_GRAPH_COLUMNS_PKG as
2 /* $Header: bnegraphcolumns.pls 120.0 2005/08/18 06:33:24 dagroves noship $ */
3
4 procedure INSERT_ROW (
5 X_ROWID in out NOCOPY VARCHAR2,
6 X_APPLICATION_ID in NUMBER,
7 X_INTEGRATOR_CODE in VARCHAR2,
8 X_GRAPH_SEQ_NUM in NUMBER,
9 X_SEQUENCE_NUM in NUMBER,
10 X_OBJECT_VERSION_NUMBER in NUMBER,
11 X_INTERFACE_APP_ID in NUMBER,
12 X_INTERFACE_CODE in VARCHAR2,
13 X_INTERFACE_SEQ_NUM in NUMBER,
14 X_LOCATION_CODE in VARCHAR2,
15 X_CREATION_DATE in DATE,
16 X_CREATED_BY in NUMBER,
17 X_LAST_UPDATE_DATE in DATE,
18 X_LAST_UPDATED_BY in NUMBER,
19 X_LAST_UPDATE_LOGIN in NUMBER
20 );
21 procedure LOCK_ROW (
22 X_APPLICATION_ID in NUMBER,
23 X_INTEGRATOR_CODE in VARCHAR2,
24 X_GRAPH_SEQ_NUM in NUMBER,
25 X_SEQUENCE_NUM in NUMBER,
26 X_OBJECT_VERSION_NUMBER in NUMBER,
27 X_INTERFACE_APP_ID in NUMBER,
28 X_INTERFACE_CODE in VARCHAR2,
29 X_INTERFACE_SEQ_NUM in NUMBER,
30 X_LOCATION_CODE in VARCHAR2
31 );
32 procedure UPDATE_ROW (
33 X_APPLICATION_ID in NUMBER,
34 X_INTEGRATOR_CODE in VARCHAR2,
35 X_GRAPH_SEQ_NUM in NUMBER,
36 X_SEQUENCE_NUM in NUMBER,
37 X_OBJECT_VERSION_NUMBER in NUMBER,
38 X_INTERFACE_APP_ID in NUMBER,
39 X_INTERFACE_CODE in VARCHAR2,
40 X_INTERFACE_SEQ_NUM in NUMBER,
41 X_LOCATION_CODE in VARCHAR2,
42 X_LAST_UPDATE_DATE in DATE,
43 X_LAST_UPDATED_BY in NUMBER,
44 X_LAST_UPDATE_LOGIN in NUMBER
45 );
46 procedure DELETE_ROW (
47 X_APPLICATION_ID in NUMBER,
48 X_INTEGRATOR_CODE in VARCHAR2,
49 X_GRAPH_SEQ_NUM in NUMBER,
50 X_SEQUENCE_NUM in NUMBER
51 );
52 procedure ADD_LANGUAGE;
53 procedure LOAD_ROW (
54 x_integrator_asn in VARCHAR2,
55 x_integrator_code in VARCHAR2,
56 x_graph_seq_num in VARCHAR2,
57 x_sequence_num in VARCHAR2,
58 x_object_version_number in VARCHAR2,
59 x_interface_asn in VARCHAR2,
60 x_interface_code in VARCHAR2,
61 x_interface_seq_num in VARCHAR2,
62 x_location_code in VARCHAR2,
63 x_owner in VARCHAR2,
64 x_last_update_date in VARCHAR2,
65 x_custom_mode in VARCHAR2
66 );
67
68 end BNE_GRAPH_COLUMNS_PKG;