[Home] [Help]
PACKAGE: APPS.RG_REPORT_DISPLAYS_PKG
Source
1 PACKAGE RG_REPORT_DISPLAYS_PKG AS
2 /* $Header: rgirdsps.pls 120.2 2002/11/14 03:01:29 djogg ship $ */
3 --
4 -- Package
5 -- RG_REPORT_DISPLAYS_PKG
6 -- Purpose
7 -- To create RG_REPORT_DISPLAYS_PKG package.
8 -- History
9 -- 01.12.94 A. Chen Created
10 --
11
12 --
13 -- Procedure
14 -- check_unique
15 -- Purpose
16 -- Ensure new display sets name is unique.
17 -- History
18 -- 01.12.94 A. Chen Created
19 -- Arguments
20 -- X_rowid The ID of the row to be checked
21 -- X_report_display_set_id The report display set id
22 -- X_name The display sets name to be checked
23 -- Example
24 -- RG_REPORT_DISPLAYS_PKG.check_unique( :displays.row_id, '12345', 'Display Set 1' );
25 -- Notes
26 --
27 PROCEDURE check_unique( X_rowid VARCHAR2,
28 X_report_display_set_id NUMBER,
29 X_sequence NUMBER );
30
31 --
32 -- Procedure
33 -- get_unique_id
34 -- Purpose
35 -- Gets a new sequence unique id for a new display option.
36 -- History
37 -- 01.12.94 A. Chen Created
38 -- Arguments
39 -- none
40 -- Example
41 -- :displays.report_display_id := RG_REPORT_DISPLAYS_PKG.get_unique_id;
42 -- Notes
43 --
44 FUNCTION get_unique_id RETURN NUMBER;
45
46
47 -- The following procedures are necessary to handle the base view form.
48
49 PROCEDURE insert_row(X_rowid IN OUT NOCOPY VARCHAR2,
50 X_report_display_id NUMBER,
51 X_report_display_set_id NUMBER,
52 X_sequence NUMBER,
53 X_display_flag VARCHAR2,
54 X_row_group_id NUMBER,
55 X_column_group_id NUMBER,
56 X_description VARCHAR2,
57 X_creation_date DATE,
58 X_created_by NUMBER,
59 X_last_update_date DATE,
60 X_last_updated_by NUMBER,
61 X_last_update_login NUMBER,
62 X_context VARCHAR2,
63 X_attribute1 VARCHAR2,
64 X_attribute2 VARCHAR2,
65 X_attribute3 VARCHAR2,
66 X_attribute4 VARCHAR2,
67 X_attribute5 VARCHAR2,
68 X_attribute6 VARCHAR2,
69 X_attribute7 VARCHAR2,
70 X_attribute8 VARCHAR2,
71 X_attribute9 VARCHAR2,
72 X_attribute10 VARCHAR2,
73 X_attribute11 VARCHAR2,
74 X_attribute12 VARCHAR2,
75 X_attribute13 VARCHAR2,
76 X_attribute14 VARCHAR2,
77 X_attribute15 VARCHAR2
78 );
79
80 PROCEDURE update_row(X_rowid IN OUT NOCOPY VARCHAR2,
81 X_report_display_id NUMBER,
82 X_report_display_set_id NUMBER,
83 X_sequence NUMBER,
84 X_display_flag VARCHAR2,
85 X_row_group_id NUMBER,
86 X_column_group_id NUMBER,
87 X_description VARCHAR2,
88 X_last_update_date DATE,
89 X_last_updated_by NUMBER,
90 X_last_update_login NUMBER,
91 X_context VARCHAR2,
92 X_attribute1 VARCHAR2,
93 X_attribute2 VARCHAR2,
94 X_attribute3 VARCHAR2,
95 X_attribute4 VARCHAR2,
96 X_attribute5 VARCHAR2,
97 X_attribute6 VARCHAR2,
98 X_attribute7 VARCHAR2,
99 X_attribute8 VARCHAR2,
100 X_attribute9 VARCHAR2,
101 X_attribute10 VARCHAR2,
102 X_attribute11 VARCHAR2,
103 X_attribute12 VARCHAR2,
104 X_attribute13 VARCHAR2,
105 X_attribute14 VARCHAR2,
106 X_attribute15 VARCHAR2
107 );
108
109 PROCEDURE lock_row(X_rowid IN OUT NOCOPY VARCHAR2,
110 X_report_display_id NUMBER,
111 X_report_display_set_id NUMBER,
112 X_sequence NUMBER,
113 X_display_flag VARCHAR2,
114 X_row_group_id NUMBER,
115 X_column_group_id NUMBER,
116 X_description VARCHAR2,
117 X_context VARCHAR2,
118 X_attribute1 VARCHAR2,
119 X_attribute2 VARCHAR2,
120 X_attribute3 VARCHAR2,
121 X_attribute4 VARCHAR2,
122 X_attribute5 VARCHAR2,
123 X_attribute6 VARCHAR2,
124 X_attribute7 VARCHAR2,
125 X_attribute8 VARCHAR2,
126 X_attribute9 VARCHAR2,
127 X_attribute10 VARCHAR2,
128 X_attribute11 VARCHAR2,
129 X_attribute12 VARCHAR2,
130 X_attribute13 VARCHAR2,
131 X_attribute14 VARCHAR2,
132 X_attribute15 VARCHAR2
133 );
134
135 PROCEDURE delete_row(X_rowid VARCHAR2);
136
137 END RG_REPORT_DISPLAYS_PKG;