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