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

Line 153: l_intf_hdr_id_list DBMS_SQL.NUMBER_TABLE;

149: l_log_head CONSTANT VARCHAR2(100) := g_module_prefix || l_api_name;
150: l_progress VARCHAR2(3) := '000';
151:
152: l_return_status VARCHAR2(100);
153: l_intf_hdr_id_list DBMS_SQL.NUMBER_TABLE;
154: l_count NUMBER;
155: BEGIN
156: l_progress := '010';
157: IF g_debug THEN PO_R12_CAT_UPG_DEBUG.log_stmt(l_log_head,l_progress,'START'); END IF;

Line 189: , p_interface_header_id => l_intf_hdr_id_list -- TABLE OF NUMBER IN DBMS_SQL.NUMBER_TABLE

185: , p_commit => FND_API.G_TRUE -- VARCHAR2 IN DEFAULT
186: , p_init_msg_list => FND_API.G_TRUE -- VARCHAR2 IN DEFAULT
187: , p_validation_level => FND_API.G_VALID_LEVEL_FULL -- VARCHAR2 IN DEFAULT
188: , x_return_status => l_return_status -- VARCHAR2 OUT
189: , p_interface_header_id => l_intf_hdr_id_list -- TABLE OF NUMBER IN DBMS_SQL.NUMBER_TABLE
190: );
191: END IF;
192: END IF;
193:

Line 232: l_intf_line_id_list DBMS_SQL.NUMBER_TABLE;

228: l_log_head CONSTANT VARCHAR2(100) := g_module_prefix || l_api_name;
229: l_progress VARCHAR2(3) := '000';
230:
231: l_return_status VARCHAR2(100);
232: l_intf_line_id_list DBMS_SQL.NUMBER_TABLE;
233: l_count NUMBER;
234: BEGIN
235: l_progress := '010';
236: IF g_debug THEN PO_R12_CAT_UPG_DEBUG.log_stmt(l_log_head,l_progress,'START'); END IF;

Line 268: , p_interface_line_id => l_intf_line_id_list -- TABLE OF NUMBER IN DBMS_SQL.NUMBER_TABLE

264: , p_commit => FND_API.G_TRUE -- VARCHAR2 IN DEFAULT
265: , p_init_msg_list => FND_API.G_TRUE -- VARCHAR2 IN DEFAULT
266: , p_validation_level => FND_API.G_VALID_LEVEL_FULL -- VARCHAR2 IN DEFAULT
267: , x_return_status => l_return_status -- VARCHAR2 OUT
268: , p_interface_line_id => l_intf_line_id_list -- TABLE OF NUMBER IN DBMS_SQL.NUMBER_TABLE
269: );
270: END IF;
271: END IF;
272:

Line 366: l_intf_hdr_id_list DBMS_SQL.NUMBER_TABLE;

362:
363: l_interface_header_ids PO_R12_CAT_UPG_TYPES.PO_TBL_NUMBER;
364: l_err_po_header_ids PO_R12_CAT_UPG_TYPES.PO_TBL_NUMBER;
365: l_return_status VARCHAR2(100);
366: l_intf_hdr_id_list DBMS_SQL.NUMBER_TABLE;
367: BEGIN
368: l_progress := '010';
369: IF g_debug THEN PO_R12_CAT_UPG_DEBUG.log_stmt(l_log_head,l_progress,'START'); END IF;
370: IF g_debug THEN PO_R12_CAT_UPG_DEBUG.log_stmt(l_log_head,l_progress,'g_processing_id='||g_processing_id); END IF;

Line 439: -- Copy the list into the DBMS_SQL.NUMBER_TABLE type required by IP

435: COMMIT;
436:
437: --
438: IF (l_interface_header_ids.COUNT > 0) THEN
439: -- Copy the list into the DBMS_SQL.NUMBER_TABLE type required by IP
440: FOR i IN 1.. l_interface_header_ids.COUNT LOOP
441: l_intf_hdr_id_list(i) := l_interface_header_ids(i);
442: END LOOP;
443:

Line 451: , p_interface_header_id => l_intf_hdr_id_list -- TABLE OF NUMBER IN DBMS_SQL.NUMBER_TABLE

447: , p_commit => FND_API.G_TRUE -- VARCHAR2 IN DEFAULT
448: , p_init_msg_list => FND_API.G_TRUE -- VARCHAR2 IN DEFAULT
449: , p_validation_level => FND_API.G_VALID_LEVEL_FULL -- VARCHAR2 IN DEFAULT
450: , x_return_status => l_return_status -- VARCHAR2 OUT
451: , p_interface_header_id => l_intf_hdr_id_list -- TABLE OF NUMBER IN DBMS_SQL.NUMBER_TABLE
452: );
453: END IF;
454: --
455: