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.WMS_CONTROL_BOARD dependencies on DBMS_SQL

Line 101: l_CursorID := DBMS_SQL.OPEN_CURSOR;

97: ' HAVING count(rownum) > 0 ';
98: END IF;
99:
100: -- Open a cursor for processing.
101: l_CursorID := DBMS_SQL.OPEN_CURSOR;
102:
103: -- Parse the query
104: DBMS_SQL.PARSE(l_CursorID, l_CursorStmt, DBMS_SQL.V7);
105:

Line 104: DBMS_SQL.PARSE(l_CursorID, l_CursorStmt, DBMS_SQL.V7);

100: -- Open a cursor for processing.
101: l_CursorID := DBMS_SQL.OPEN_CURSOR;
102:
103: -- Parse the query
104: DBMS_SQL.PARSE(l_CursorID, l_CursorStmt, DBMS_SQL.V7);
105:
106: -- Define the output variables
107: DBMS_SQL.DEFINE_COLUMN(l_CursorID, 1, l_temp_status);
108: DBMS_SQL.DEFINE_COLUMN(l_CursorID, 2, l_temp_count);

Line 107: DBMS_SQL.DEFINE_COLUMN(l_CursorID, 1, l_temp_status);

103: -- Parse the query
104: DBMS_SQL.PARSE(l_CursorID, l_CursorStmt, DBMS_SQL.V7);
105:
106: -- Define the output variables
107: DBMS_SQL.DEFINE_COLUMN(l_CursorID, 1, l_temp_status);
108: DBMS_SQL.DEFINE_COLUMN(l_CursorID, 2, l_temp_count);
109:
110: -- Execute the statement. We don't care about the return value,
111: -- but we do need to declare a variable for it.

Line 108: DBMS_SQL.DEFINE_COLUMN(l_CursorID, 2, l_temp_count);

104: DBMS_SQL.PARSE(l_CursorID, l_CursorStmt, DBMS_SQL.V7);
105:
106: -- Define the output variables
107: DBMS_SQL.DEFINE_COLUMN(l_CursorID, 1, l_temp_status);
108: DBMS_SQL.DEFINE_COLUMN(l_CursorID, 2, l_temp_count);
109:
110: -- Execute the statement. We don't care about the return value,
111: -- but we do need to declare a variable for it.
112: l_Dummy := DBMS_SQL.EXECUTE(l_CursorID);

Line 112: l_Dummy := DBMS_SQL.EXECUTE(l_CursorID);

108: DBMS_SQL.DEFINE_COLUMN(l_CursorID, 2, l_temp_count);
109:
110: -- Execute the statement. We don't care about the return value,
111: -- but we do need to declare a variable for it.
112: l_Dummy := DBMS_SQL.EXECUTE(l_CursorID);
113:
114: -- This is the fetch loop
115: x_status_data_count := 0;
116: i := 0;

Line 121: IF DBMS_SQL.FETCH_ROWS(l_CursorID) = 0 THEN

117: x_return_status := fnd_api.g_ret_sts_success;
118: LOOP
119: -- Fetch the rows into the buffer, and also check for the exit
120: -- condition from the loop.
121: IF DBMS_SQL.FETCH_ROWS(l_CursorID) = 0 THEN
122: EXIT;
123: END IF;
124:
125: -- Retrieve the rows from the buffer into temp variables.

Line 126: DBMS_SQL.COLUMN_VALUE(l_CursorID, 1, l_temp_status);

122: EXIT;
123: END IF;
124:
125: -- Retrieve the rows from the buffer into temp variables.
126: DBMS_SQL.COLUMN_VALUE(l_CursorID, 1, l_temp_status);
127: DBMS_SQL.COLUMN_VALUE(l_CursorID, 2, l_temp_count);
128:
129: --mydebug('CBPT: Storing into temp table for status -->' || l_temp_status || ' = ' || l_temp_count );
130: -- Store these values in the task count table

Line 127: DBMS_SQL.COLUMN_VALUE(l_CursorID, 2, l_temp_count);

123: END IF;
124:
125: -- Retrieve the rows from the buffer into temp variables.
126: DBMS_SQL.COLUMN_VALUE(l_CursorID, 1, l_temp_status);
127: DBMS_SQL.COLUMN_VALUE(l_CursorID, 2, l_temp_count);
128:
129: --mydebug('CBPT: Storing into temp table for status -->' || l_temp_status || ' = ' || l_temp_count );
130: -- Store these values in the task count table
131: IF (l_status_count_table.EXISTS(l_temp_status)) THEN

Line 139: DBMS_SQL.CLOSE_CURSOR(l_CursorID);

135: END IF;
136:
137: END LOOP;
138: -- Close the cursor.
139: DBMS_SQL.CLOSE_CURSOR(l_CursorID);
140:
141:
142: -- Input in the status type and count information into the chart table
143: x_status_data_count := 0;

Line 163: DBMS_SQL.CLOSE_CURSOR(l_CursorID);

159: EXCEPTION
160: WHEN FND_API.G_EXC_ERROR THEN
161: x_return_status := FND_API.G_RET_STS_ERROR;
162: -- Close the cursor.
163: DBMS_SQL.CLOSE_CURSOR(l_CursorID);
164:
165: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
166: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
167: -- Close the cursor.

Line 168: DBMS_SQL.CLOSE_CURSOR(l_CursorID);

164:
165: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
166: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
167: -- Close the cursor.
168: DBMS_SQL.CLOSE_CURSOR(l_CursorID);
169:
170: WHEN OTHERS THEN
171: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
172: IF (FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)) THEN

Line 176: DBMS_SQL.CLOSE_CURSOR(l_CursorID);

172: IF (FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)) THEN
173: FND_MSG_PUB.ADD_EXC_MSG(g_pkg_name, c_api_name);
174: END IF;
175: -- Close the cursor.
176: DBMS_SQL.CLOSE_CURSOR(l_CursorID);
177:
178: END get_status_dist;
179:
180:

Line 265: l_CursorID := DBMS_SQL.OPEN_CURSOR;

261: ' WHERE ' || p_ccy_where || ' HAVING count(rownum) > 0 ';
262: END IF;
263:
264: -- Open a cursor for processing.
265: l_CursorID := DBMS_SQL.OPEN_CURSOR;
266:
267: -- Parse the query
268: DBMS_SQL.PARSE(l_CursorID, l_CursorStmt, DBMS_SQL.V7);
269:

Line 268: DBMS_SQL.PARSE(l_CursorID, l_CursorStmt, DBMS_SQL.V7);

264: -- Open a cursor for processing.
265: l_CursorID := DBMS_SQL.OPEN_CURSOR;
266:
267: -- Parse the query
268: DBMS_SQL.PARSE(l_CursorID, l_CursorStmt, DBMS_SQL.V7);
269:
270: -- Define the output variables
271: DBMS_SQL.DEFINE_COLUMN(l_CursorID, 1, l_temp_task);
272: DBMS_SQL.DEFINE_COLUMN(l_CursorID, 2, l_temp_count);

Line 271: DBMS_SQL.DEFINE_COLUMN(l_CursorID, 1, l_temp_task);

267: -- Parse the query
268: DBMS_SQL.PARSE(l_CursorID, l_CursorStmt, DBMS_SQL.V7);
269:
270: -- Define the output variables
271: DBMS_SQL.DEFINE_COLUMN(l_CursorID, 1, l_temp_task);
272: DBMS_SQL.DEFINE_COLUMN(l_CursorID, 2, l_temp_count);
273:
274: -- Execute the statement. We don't care about the return value,
275: -- but we do need to declare a variable for it.

Line 272: DBMS_SQL.DEFINE_COLUMN(l_CursorID, 2, l_temp_count);

268: DBMS_SQL.PARSE(l_CursorID, l_CursorStmt, DBMS_SQL.V7);
269:
270: -- Define the output variables
271: DBMS_SQL.DEFINE_COLUMN(l_CursorID, 1, l_temp_task);
272: DBMS_SQL.DEFINE_COLUMN(l_CursorID, 2, l_temp_count);
273:
274: -- Execute the statement. We don't care about the return value,
275: -- but we do need to declare a variable for it.
276: l_Dummy := DBMS_SQL.EXECUTE(l_CursorID);

Line 276: l_Dummy := DBMS_SQL.EXECUTE(l_CursorID);

272: DBMS_SQL.DEFINE_COLUMN(l_CursorID, 2, l_temp_count);
273:
274: -- Execute the statement. We don't care about the return value,
275: -- but we do need to declare a variable for it.
276: l_Dummy := DBMS_SQL.EXECUTE(l_CursorID);
277:
278: -- The dynamic sql cursor statement will return task types and count but is
279: -- not grouped together based on the task_type. This part will deal with
280: -- doing that while putting the aggregate count information in a table with

Line 285: IF DBMS_SQL.FETCH_ROWS(l_CursorID) = 0 THEN

281: -- the index being the task_type code. 7 refers to a NULL value for task_type
282: LOOP
283: -- Fetch the rows into the buffer, and also check for the exit
284: -- condition from the loop.
285: IF DBMS_SQL.FETCH_ROWS(l_CursorID) = 0 THEN
286: EXIT;
287: END IF;
288:
289: -- Retrieve the rows from the buffer into temp variables.

Line 290: DBMS_SQL.COLUMN_VALUE(l_CursorID, 1, l_temp_task);

286: EXIT;
287: END IF;
288:
289: -- Retrieve the rows from the buffer into temp variables.
290: DBMS_SQL.COLUMN_VALUE(l_CursorID, 1, l_temp_task);
291: DBMS_SQL.COLUMN_VALUE(l_CursorID, 2, l_temp_count);
292:
293: -- Store these values in the task count table
294: -- Changed for supporting new task types 5, 6

Line 291: DBMS_SQL.COLUMN_VALUE(l_CursorID, 2, l_temp_count);

287: END IF;
288:
289: -- Retrieve the rows from the buffer into temp variables.
290: DBMS_SQL.COLUMN_VALUE(l_CursorID, 1, l_temp_task);
291: DBMS_SQL.COLUMN_VALUE(l_CursorID, 2, l_temp_count);
292:
293: -- Store these values in the task count table
294: -- Changed for supporting new task types 5, 6
295: IF (l_task_count_table.EXISTS(NVL(l_temp_task, 7))) THEN

Line 305: DBMS_SQL.CLOSE_CURSOR(l_CursorID);

301:
302: END LOOP;
303:
304: -- Close the cursor.
305: DBMS_SQL.CLOSE_CURSOR(l_CursorID);
306:
307: -- Input in the task type and count information into the chart table
308: x_type_data_count := 0;
309: l_loop_index := l_task_count_table.FIRST;

Line 335: DBMS_SQL.CLOSE_CURSOR(l_CursorID);

331: EXCEPTION
332: WHEN FND_API.G_EXC_ERROR THEN
333: x_return_status := FND_API.G_RET_STS_ERROR;
334: -- Close the cursor.
335: DBMS_SQL.CLOSE_CURSOR(l_CursorID);
336:
337: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
338: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
339: -- Close the cursor.

Line 340: DBMS_SQL.CLOSE_CURSOR(l_CursorID);

336:
337: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
338: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
339: -- Close the cursor.
340: DBMS_SQL.CLOSE_CURSOR(l_CursorID);
341:
342: WHEN OTHERS THEN
343: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
344: IF (FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)) THEN

Line 348: DBMS_SQL.CLOSE_CURSOR(l_CursorID);

344: IF (FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)) THEN
345: FND_MSG_PUB.ADD_EXC_MSG(g_pkg_name, c_api_name);
346: END IF;
347: -- Close the cursor.
348: DBMS_SQL.CLOSE_CURSOR(l_CursorID);
349:
350: END get_type_dist;
351:
352: