1 package BNE_GRAPHS_PKG as
2 /* $Header: bnegraphs.pls 120.1 2005/08/30 03:18:47 dagroves noship $ */
3
4
5 procedure INSERT_ROW (
6 X_ROWID in out NOCOPY VARCHAR2,
7 X_APPLICATION_ID in NUMBER,
8 X_INTEGRATOR_CODE in VARCHAR2,
9 X_SEQUENCE_NUM in NUMBER,
10 X_OBJECT_VERSION_NUMBER in NUMBER,
11 X_LAYOUT_APP_ID in NUMBER,
12 X_LAYOUT_CODE in VARCHAR2,
13 X_GRAPH_DIMENSION_CODE in VARCHAR2,
14 X_GRAPH_TYPE_CODE in VARCHAR2,
15 X_AUTO_GRAPH_FLAG in VARCHAR2,
16 X_CHART_TITLE in VARCHAR2,
17 X_X_AXIS_LABEL in VARCHAR2,
18 X_Y_AXIS_LABEL in VARCHAR2,
19 X_Z_AXIS_LABEL in VARCHAR2,
20 X_CREATION_DATE in DATE,
21 X_CREATED_BY in NUMBER,
22 X_LAST_UPDATED_BY in NUMBER,
23 X_LAST_UPDATE_LOGIN in NUMBER,
24 X_LAST_UPDATE_DATE in DATE
25 );
26 procedure LOCK_ROW (
27 X_APPLICATION_ID in NUMBER,
28 X_INTEGRATOR_CODE in VARCHAR2,
29 X_SEQUENCE_NUM in NUMBER,
30 X_OBJECT_VERSION_NUMBER in NUMBER,
31 X_LAYOUT_APP_ID in NUMBER,
32 X_LAYOUT_CODE in VARCHAR2,
33 X_GRAPH_DIMENSION_CODE in VARCHAR2,
34 X_GRAPH_TYPE_CODE in VARCHAR2,
35 X_AUTO_GRAPH_FLAG in VARCHAR2,
36 X_CHART_TITLE in VARCHAR2,
37 X_X_AXIS_LABEL in VARCHAR2,
38 X_Y_AXIS_LABEL in VARCHAR2,
39 X_Z_AXIS_LABEL in VARCHAR2,
40 X_CREATION_DATE in DATE,
41 X_CREATED_BY in NUMBER,
42 X_LAST_UPDATED_BY in NUMBER,
43 X_LAST_UPDATE_LOGIN in NUMBER,
44 X_LAST_UPDATE_DATE in DATE
45 );
46 procedure UPDATE_ROW (
47 X_APPLICATION_ID in NUMBER,
48 X_INTEGRATOR_CODE in VARCHAR2,
49 X_SEQUENCE_NUM in NUMBER,
50 X_OBJECT_VERSION_NUMBER in NUMBER,
51 X_LAYOUT_APP_ID in NUMBER,
52 X_LAYOUT_CODE in VARCHAR2,
53 X_GRAPH_DIMENSION_CODE in VARCHAR2,
54 X_GRAPH_TYPE_CODE in VARCHAR2,
55 X_AUTO_GRAPH_FLAG in VARCHAR2,
56 X_CHART_TITLE in VARCHAR2,
57 X_X_AXIS_LABEL in VARCHAR2,
58 X_Y_AXIS_LABEL in VARCHAR2,
59 X_Z_AXIS_LABEL in VARCHAR2,
60 X_LAST_UPDATED_BY in NUMBER,
61 X_LAST_UPDATE_LOGIN in NUMBER,
62 X_LAST_UPDATE_DATE in DATE
63 );
64 procedure DELETE_ROW (
65 X_APPLICATION_ID in NUMBER,
66 X_INTEGRATOR_CODE in VARCHAR2,
67 X_SEQUENCE_NUM in NUMBER
68 );
69 procedure ADD_LANGUAGE;
70
71 procedure TRANSLATE_ROW(
72 x_integrator_asn in VARCHAR2,
73 x_integrator_code in VARCHAR2,
74 x_sequence_num in VARCHAR2,
75 x_chart_title in VARCHAR2,
76 x_x_axis_label in VARCHAR2,
77 x_y_axis_label in VARCHAR2,
78 x_z_axis_label in VARCHAR2,
79 x_owner in VARCHAR2,
80 x_last_update_date in VARCHAR2,
81 x_custom_mode in VARCHAR2
82 );
83 procedure LOAD_ROW(
84 x_integrator_asn in VARCHAR2,
85 x_integrator_code in VARCHAR2,
86 x_sequence_num in VARCHAR2,
87 x_object_version_number in VARCHAR2,
88 x_layout_asn in VARCHAR2,
89 x_layout_code in VARCHAR2,
90 x_graph_dimension_code in VARCHAR2,
91 x_graph_type_code in VARCHAR2,
92 x_auto_graph_flag in VARCHAR2,
93 x_chart_title in VARCHAR2,
94 x_x_axis_label in VARCHAR2,
95 x_y_axis_label in VARCHAR2,
96 x_z_axis_label in VARCHAR2,
97 x_last_update_date in VARCHAR2,
98 x_owner in VARCHAR2,
99 x_custom_mode in VARCHAR2
100 );
101
102
103 end BNE_GRAPHS_PKG;