eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.GL_PARENT_SEGMENT_PKG dependencies on DBMS_SQL

Line 138: DBMS_SQL.CLOSE_CURSOR(v_CursorID);

134: WHERE rowid = p_old_rowid;
135: END IF; -- IF p_changed_flag = 'Y' THEN
136:
137: -- Close the detail_value cursor
138: DBMS_SQL.CLOSE_CURSOR(v_CursorID);
139:
140: END IF; -- IF (p_old_child_fv_high IS NOT NULL) THEN
141:
142: -- Initialize the variables for the new parent value

Line 159: v_CursorID := DBMS_SQL.OPEN_CURSOR;

155: p_max_flex_val);
156:
157: IF p_rec_count > 0 THEN
158: -- Open the cursor for processing
159: v_CursorID := DBMS_SQL.OPEN_CURSOR;
160:
161: -- Parse the query
162: DBMS_SQL.PARSE(v_CursorID, v_CursorSQL, DBMS_SQL.v7);
163:

Line 162: DBMS_SQL.PARSE(v_CursorID, v_CursorSQL, DBMS_SQL.v7);

158: -- Open the cursor for processing
159: v_CursorID := DBMS_SQL.OPEN_CURSOR;
160:
161: -- Parse the query
162: DBMS_SQL.PARSE(v_CursorID, v_CursorSQL, DBMS_SQL.v7);
163:
164: -- Bind varibales
165: DBMS_SQL.BIND_VARIABLE(v_CursorID, ':low', p_min_flex_val);
166: DBMS_SQL.BIND_VARIABLE(v_CursorID, ':high', p_max_flex_val);

Line 165: DBMS_SQL.BIND_VARIABLE(v_CursorID, ':low', p_min_flex_val);

161: -- Parse the query
162: DBMS_SQL.PARSE(v_CursorID, v_CursorSQL, DBMS_SQL.v7);
163:
164: -- Bind varibales
165: DBMS_SQL.BIND_VARIABLE(v_CursorID, ':low', p_min_flex_val);
166: DBMS_SQL.BIND_VARIABLE(v_CursorID, ':high', p_max_flex_val);
167: DBMS_SQL.BIND_VARIABLE(v_CursorID, ':l_summary_flag', p_summary_flag);
168:
169: -- Define output variable

Line 166: DBMS_SQL.BIND_VARIABLE(v_CursorID, ':high', p_max_flex_val);

162: DBMS_SQL.PARSE(v_CursorID, v_CursorSQL, DBMS_SQL.v7);
163:
164: -- Bind varibales
165: DBMS_SQL.BIND_VARIABLE(v_CursorID, ':low', p_min_flex_val);
166: DBMS_SQL.BIND_VARIABLE(v_CursorID, ':high', p_max_flex_val);
167: DBMS_SQL.BIND_VARIABLE(v_CursorID, ':l_summary_flag', p_summary_flag);
168:
169: -- Define output variable
170: DBMS_SQL.DEFINE_COLUMN(v_CursorID, 1, v_detail_value, 150);

Line 167: DBMS_SQL.BIND_VARIABLE(v_CursorID, ':l_summary_flag', p_summary_flag);

163:
164: -- Bind varibales
165: DBMS_SQL.BIND_VARIABLE(v_CursorID, ':low', p_min_flex_val);
166: DBMS_SQL.BIND_VARIABLE(v_CursorID, ':high', p_max_flex_val);
167: DBMS_SQL.BIND_VARIABLE(v_CursorID, ':l_summary_flag', p_summary_flag);
168:
169: -- Define output variable
170: DBMS_SQL.DEFINE_COLUMN(v_CursorID, 1, v_detail_value, 150);
171:

Line 170: DBMS_SQL.DEFINE_COLUMN(v_CursorID, 1, v_detail_value, 150);

166: DBMS_SQL.BIND_VARIABLE(v_CursorID, ':high', p_max_flex_val);
167: DBMS_SQL.BIND_VARIABLE(v_CursorID, ':l_summary_flag', p_summary_flag);
168:
169: -- Define output variable
170: DBMS_SQL.DEFINE_COLUMN(v_CursorID, 1, v_detail_value, 150);
171:
172: -- Execute the query
173: v_Dummy := DBMS_SQL.EXECUTE(v_CursorID);
174:

Line 173: v_Dummy := DBMS_SQL.EXECUTE(v_CursorID);

169: -- Define output variable
170: DBMS_SQL.DEFINE_COLUMN(v_CursorID, 1, v_detail_value, 150);
171:
172: -- Execute the query
173: v_Dummy := DBMS_SQL.EXECUTE(v_CursorID);
174:
175: ELSE
176: IF g_debug_mode = 'Y' THEN
177: debug_msg('merge_child_ranges', 'No child ranges are found');

Line 230: IF DBMS_SQL.FETCH_ROWS(v_CursorID) = 0 THEN

226: debug_msg('merge_child_ranges', 'Fetch detail value');
227: END IF;
228:
229: -- Fetch detail value from the cursor if it is NULL
230: IF DBMS_SQL.FETCH_ROWS(v_CursorID) = 0 THEN
231: IF g_debug_mode = 'Y' THEN
232: debug_msg('merge_child_ranges', 'No more detail value');
233: END IF;
234: -- No more detail value for this parent value

Line 263: END IF; -- IF DBMS_SQL.FETCH_ROWS(v_CursorID) = 0 THEN

259:
260: -- Exit the detail_value loop and proceed for the next range
261: EXIT;
262:
263: END IF; -- IF DBMS_SQL.FETCH_ROWS(v_CursorID) = 0 THEN
264:
265: -- Retrieve the detail value from the cursor
266: DBMS_SQL.COLUMN_VALUE(v_CursorID, 1, v_detail_value);
267:

Line 266: DBMS_SQL.COLUMN_VALUE(v_CursorID, 1, v_detail_value);

262:
263: END IF; -- IF DBMS_SQL.FETCH_ROWS(v_CursorID) = 0 THEN
264:
265: -- Retrieve the detail value from the cursor
266: DBMS_SQL.COLUMN_VALUE(v_CursorID, 1, v_detail_value);
267:
268: END IF; -- IF (v_detail_value IS NULL) THEN
269:
270: IF (v_detail_value < p_old_child_fv_low) THEN

Line 367: DBMS_SQL.CLOSE_CURSOR(v_CursorID);

363: WHERE rowid = p_old_rowid;
364: END IF; -- IF p_changed_flag = 'Y' THEN
365:
366: -- Close the detail_value cursor
367: DBMS_SQL.CLOSE_CURSOR(v_CursorID);
368:
369: END IF; -- IF (p_old_child_fv_high IS NOT NULL) THEN
370:
371: CLOSE child_range_c;