PACKAGE: APPS.RG_REPORT_CALCULATIONS_PKG

Source

1 PACKAGE RG_REPORT_CALCULATIONS_PKG AS
2 -- $Header: rgiracls.pls 120.2 2004/07/16 18:38:50 ticheng ship $
3 --
4 -- Name
5 --   RG_REPORT_CALCULATIONS_PKG
6 -- Purpose
7 --   to include all sever side procedures and packages for table
8 --   RG_REPORT_CALCULATIONS
9 -- Notes
10 --
11 -- History
12 --   11/01/93	A Chen	Created
13 --
14 --
15 -- Procedures
16 
17 -- Name
18 --   check_existence
19 -- Purpose
20 --   Check whether a axis has calculations defined.
21 -- Arguments
22 --   axis_set_id
23 --   axis_seq
24 --
25 FUNCTION check_existence(X_axis_set_id NUMBER,
26                          X_axis_seq NUMBER) RETURN BOOLEAN;
27 
28 -- Name
29 --   delete_rows
30 -- Purpose
31 --   delete all calculations from a row or a column
32 -- Arguments
33 --   axis_set_id
34 --   axis_seq
35 --
36 PROCEDURE delete_rows(X_axis_set_id NUMBER,
37                       X_axis_seq NUMBER);
38 
39 -- Name
40 --   check_unique
41 -- Purpose
42 --   Check whether the sequence number of the calculation is unique.
43 -- Arguments
44 --   X_rowid
45 --   X_axis_set_id
46 --   X_axis_seq
47 --
48 PROCEDURE check_unique(X_rowid VARCHAR2, X_axis_set_id NUMBER,
49                        X_axis_seq NUMBER, X_calculation_seq NUMBER);
50 
51 -- Name
52 --   Load_Row
53 -- Purpose
54 --   Called by the loader config file.
55 --
56 PROCEDURE Load_Row(X_application_id       NUMBER,
57                    X_axis_set_id          NUMBER,
58                    X_axis_seq             NUMBER,
59                    X_calculation_seq      NUMBER,
60                    X_operator             VARCHAR2,
61                    X_axis_seq_low         NUMBER,
62                    X_axis_seq_high        NUMBER,
63                    X_axis_name_low        VARCHAR2,
64                    X_axis_name_high       VARCHAR2,
65                    X_constant             NUMBER,
66                    X_context              VARCHAR2,
67                    X_attribute1           VARCHAR2,
68                    X_attribute2           VARCHAR2,
69                    X_attribute3           VARCHAR2,
70                    X_attribute4           VARCHAR2,
71                    X_attribute5           VARCHAR2,
72                    X_attribute6           VARCHAR2,
73                    X_attribute7           VARCHAR2,
74                    X_attribute8           VARCHAR2,
75                    X_attribute9           VARCHAR2,
76                    X_attribute10          VARCHAR2,
77                    X_attribute11          VARCHAR2,
78                    X_attribute12          VARCHAR2,
79                    X_attribute13          VARCHAR2,
80                    X_attribute14          VARCHAR2,
81                    X_attribute15          VARCHAR2,
82                    X_owner                VARCHAR2,
83                    X_force_edits          VARCHAR2);
84 
85 -- Name
86 --   Translate_Row
87 -- Purpose
88 --   Called by the loader config file.
89 --
90 PROCEDURE Translate_Row(X_axis_set_id          NUMBER,
91                         X_axis_seq             NUMBER,
92                         X_calculation_seq      NUMBER,
93                         X_axis_name_low        VARCHAR2,
94                         X_axis_name_high       VARCHAR2,
95                         X_owner                VARCHAR2,
96                         X_force_edits          VARCHAR2);
97 
98 END RG_REPORT_CALCULATIONS_PKG;