[Home] [Help]
PACKAGE: APPS.RG_ROW_SEGMENT_SEQUENCES_PKG
Source
1 PACKAGE RG_ROW_SEGMENT_SEQUENCES_PKG AS
2 /* $Header: rgirssqs.pls 120.3 2005/02/14 23:52:28 ticheng ship $ */
3
4 --
5 -- NAME
6 -- new_row_segment_sequence_id
7 --
8 -- DESCRIPTION
9 -- get a new row_segment_sequence_id from rg_row_segment_sequences_s
10 --
11 -- PARAMETERS
12 -- *None*
13 --
14
15 FUNCTION new_row_segment_sequence_id
16 RETURN NUMBER;
17
18 --
19 -- NAME
20 -- check_dup_sequence
21 --
22 -- DESCRIPTION
23 -- Check whether a particular sequence already existed in
24 -- in current report set
25 --
26 -- PARAMETERS
27 -- 1. Current Row Order ID
28 -- 2. Current Row segment sequence ID
29 -- 3. New sequence number
30 --
31 -- EXAMPLE
32 -- IF you want to check whether 1 is already a sequence number
33 -- in a differrent segment sequence in current row order with
34 -- row_order_id = 100. Assume the current segment_sequence_id is 2000
35 -- rg_row_segment_sequences_pkg.check_dup_sequence(100,2000,1);
36 -- Return TURE is it is exist, Otherwise FALSE.
37 --
38
39 FUNCTION check_dup_sequence(cur_row_order_id IN NUMBER,
40 cur_row_segment_sequence_id IN NUMBER,
41 new_sequence IN NUMBER)
42 RETURN BOOLEAN;
43
44
45 --
46 -- NAME
47 -- check_dup_appl_col_name
48 --
49 -- DESCRIPTION
50 -- Check whether a particular application column name already existed in
51 -- in current row order
52 --
53 -- PARAMETERS
54 -- 1. Current Row Order ID
55 -- 2. Current Row Segment Sequence ID
56 -- 3. New application column name
57 --
58 -- EXAMPLE
59 -- IF you want to check SEGMENT1 is already used by the same
60 -- row order and the current row order id is 2000 and
61 -- row_segment_sequence_id is 1000, the follwing will check
62 -- whether this particular segment is used in the same row order.
63 -- rg_row_segment_sequences_pkg.check_dup_appl_col_name(2000,1000,
64 -- 'SEGMENT1');
65 --
66 -- Return TURE if it is exist, Otherwise FALSE.
67 --
68
69 FUNCTION check_dup_appl_col_name(cur_row_order_id IN NUMBER,
70 cur_row_segment_sequence_id IN NUMBER,
71 new_application_column_name IN VARCHAR2)
72 RETURN BOOLEAN;
73
74 -- *********************************************************************
75 -- The following procedures are necessary to handle the base view form.
76
77 PROCEDURE insert_row(X_rowid IN OUT NOCOPY VARCHAR2,
78 X_application_id NUMBER,
79 X_row_order_id NUMBER,
80 X_row_segment_sequence_id NUMBER,
81 X_segment_sequence NUMBER,
82 X_seg_order_type VARCHAR2,
83 X_seg_display_type VARCHAR2,
84 X_structure_id NUMBER,
85 X_application_column_name VARCHAR2,
86 X_segment_width NUMBER,
87 X_creation_date DATE,
88 X_created_by NUMBER,
89 X_last_update_date DATE,
90 X_last_updated_by NUMBER,
91 X_last_update_login NUMBER,
92 X_context VARCHAR2,
93 X_attribute1 VARCHAR2,
94 X_attribute2 VARCHAR2,
95 X_attribute3 VARCHAR2,
96 X_attribute4 VARCHAR2,
97 X_attribute5 VARCHAR2,
98 X_attribute6 VARCHAR2,
99 X_attribute7 VARCHAR2,
100 X_attribute8 VARCHAR2,
101 X_attribute9 VARCHAR2,
102 X_attribute10 VARCHAR2,
103 X_attribute11 VARCHAR2,
104 X_attribute12 VARCHAR2,
105 X_attribute13 VARCHAR2,
106 X_attribute14 VARCHAR2,
107 X_attribute15 VARCHAR2
108 );
109
110 PROCEDURE update_row(X_rowid IN OUT NOCOPY VARCHAR2,
111 X_application_id NUMBER,
112 X_row_order_id NUMBER,
113 X_row_segment_sequence_id NUMBER,
114 X_segment_sequence NUMBER,
115 X_seg_order_type VARCHAR2,
116 X_seg_display_type VARCHAR2,
117 X_structure_id NUMBER,
118 X_application_column_name VARCHAR2,
119 X_segment_width NUMBER,
120 X_last_update_date DATE,
121 X_last_updated_by NUMBER,
122 X_last_update_login NUMBER,
123 X_context VARCHAR2,
124 X_attribute1 VARCHAR2,
125 X_attribute2 VARCHAR2,
126 X_attribute3 VARCHAR2,
127 X_attribute4 VARCHAR2,
128 X_attribute5 VARCHAR2,
129 X_attribute6 VARCHAR2,
130 X_attribute7 VARCHAR2,
131 X_attribute8 VARCHAR2,
132 X_attribute9 VARCHAR2,
133 X_attribute10 VARCHAR2,
134 X_attribute11 VARCHAR2,
135 X_attribute12 VARCHAR2,
136 X_attribute13 VARCHAR2,
137 X_attribute14 VARCHAR2,
138 X_attribute15 VARCHAR2
139 );
140
141 PROCEDURE lock_row(X_rowid IN OUT NOCOPY VARCHAR2,
142 X_application_id NUMBER,
143 X_row_order_id NUMBER,
144 X_row_segment_sequence_id NUMBER,
145 X_segment_sequence NUMBER,
146 X_seg_order_type VARCHAR2,
147 X_seg_display_type VARCHAR2,
148 X_structure_id NUMBER,
149 X_application_column_name VARCHAR2,
150 X_segment_width NUMBER,
151 X_context VARCHAR2,
152 X_attribute1 VARCHAR2,
153 X_attribute2 VARCHAR2,
154 X_attribute3 VARCHAR2,
155 X_attribute4 VARCHAR2,
156 X_attribute5 VARCHAR2,
157 X_attribute6 VARCHAR2,
158 X_attribute7 VARCHAR2,
159 X_attribute8 VARCHAR2,
160 X_attribute9 VARCHAR2,
161 X_attribute10 VARCHAR2,
162 X_attribute11 VARCHAR2,
163 X_attribute12 VARCHAR2,
164 X_attribute13 VARCHAR2,
165 X_attribute14 VARCHAR2,
166 X_attribute15 VARCHAR2
167 );
168
169 PROCEDURE delete_row(X_rowid VARCHAR2);
170
171 END RG_ROW_SEGMENT_SEQUENCES_PKG;