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_UTL dependencies on PO_R12_CAT_UPG_TYPES

Line 243: , p_id_tbl IN PO_R12_CAT_UPG_TYPES.PO_TBL_NUMBER

239: --------------------------------------------------------------------------------
240: PROCEDURE reject_headers_intf
241: (
242: p_id_param_type IN VARCHAR2
243: , p_id_tbl IN PO_R12_CAT_UPG_TYPES.PO_TBL_NUMBER
244: , p_cascade IN VARCHAR2
245: )
246: IS
247: l_api_name CONSTANT VARCHAR2(30) := 'reject_headers_intf';

Line 319: , p_id_tbl IN PO_R12_CAT_UPG_TYPES.PO_TBL_NUMBER

315: --------------------------------------------------------------------------------
316: PROCEDURE reject_lines_intf
317: (
318: p_id_param_type IN VARCHAR2
319: , p_id_tbl IN PO_R12_CAT_UPG_TYPES.PO_TBL_NUMBER
320: , p_cascade IN VARCHAR2
321: )
322: IS
323: l_api_name CONSTANT VARCHAR2(30) := 'reject_lines_intf';

Line 327: l_intf_line_id_tbl PO_R12_CAT_UPG_TYPES.PO_TBL_NUMBER;

323: l_api_name CONSTANT VARCHAR2(30) := 'reject_lines_intf';
324: l_log_head CONSTANT VARCHAR2(100) := g_module_prefix || l_api_name;
325: l_progress VARCHAR2(3) := '000';
326:
327: l_intf_line_id_tbl PO_R12_CAT_UPG_TYPES.PO_TBL_NUMBER;
328: l_processed_intf_hdr_id_tbl PO_R12_CAT_UPG_TYPES.PO_TBL_NUMBER;
329: BEGIN
330: l_progress := '010';
331: IF g_debug THEN PO_R12_CAT_UPG_DEBUG.log_stmt(l_log_head,l_progress,'START'); END IF;

Line 328: l_processed_intf_hdr_id_tbl PO_R12_CAT_UPG_TYPES.PO_TBL_NUMBER;

324: l_log_head CONSTANT VARCHAR2(100) := g_module_prefix || l_api_name;
325: l_progress VARCHAR2(3) := '000';
326:
327: l_intf_line_id_tbl PO_R12_CAT_UPG_TYPES.PO_TBL_NUMBER;
328: l_processed_intf_hdr_id_tbl PO_R12_CAT_UPG_TYPES.PO_TBL_NUMBER;
329: BEGIN
330: l_progress := '010';
331: IF g_debug THEN PO_R12_CAT_UPG_DEBUG.log_stmt(l_log_head,l_progress,'START'); END IF;
332: IF g_debug THEN PO_R12_CAT_UPG_DEBUG.log_stmt(l_log_head,l_progress,'p_id_param_type='||p_id_param_type); END IF;

Line 435: , p_id_tbl IN PO_R12_CAT_UPG_TYPES.PO_TBL_NUMBER

431: --------------------------------------------------------------------------------
432: PROCEDURE reject_attr_values_intf
433: (
434: p_id_param_type IN VARCHAR2
435: , p_id_tbl IN PO_R12_CAT_UPG_TYPES.PO_TBL_NUMBER
436: )
437: IS
438: l_api_name CONSTANT VARCHAR2(30) := 'reject_attr_values_intf';
439: l_log_head CONSTANT VARCHAR2(100) := g_module_prefix || l_api_name;

Line 525: , p_id_tbl IN PO_R12_CAT_UPG_TYPES.PO_TBL_NUMBER

521: --------------------------------------------------------------------------------
522: PROCEDURE reject_attr_values_tlp_intf
523: (
524: p_id_param_type IN VARCHAR2
525: , p_id_tbl IN PO_R12_CAT_UPG_TYPES.PO_TBL_NUMBER
526: )
527: IS
528: l_api_name CONSTANT VARCHAR2(30) := 'reject_attr_values_tlp_intf';
529: l_log_head CONSTANT VARCHAR2(100) := g_module_prefix || l_api_name;

Line 614: RETURN PO_R12_CAT_UPG_TYPES.PO_TBL_NUMBER

610: FUNCTION construct_subscript_array
611: (
612: p_size IN NUMBER
613: )
614: RETURN PO_R12_CAT_UPG_TYPES.PO_TBL_NUMBER
615: IS
616: l_api_name CONSTANT VARCHAR2(30) := 'construct_subscript_array';
617: l_log_head CONSTANT VARCHAR2(100) := g_module_prefix || l_api_name;
618: l_progress VARCHAR2(3) := '000';

Line 620: l_subscript_array PO_R12_CAT_UPG_TYPES.PO_TBL_NUMBER;

616: l_api_name CONSTANT VARCHAR2(30) := 'construct_subscript_array';
617: l_log_head CONSTANT VARCHAR2(100) := g_module_prefix || l_api_name;
618: l_progress VARCHAR2(3) := '000';
619:
620: l_subscript_array PO_R12_CAT_UPG_TYPES.PO_TBL_NUMBER;
621: i NUMBER;
622: BEGIN
623: l_progress := '010';
624: IF g_debug THEN PO_R12_CAT_UPG_DEBUG.log_stmt(l_log_head,l_progress,'START'); END IF;

Line 686: l_intf_header_id_tbl PO_R12_CAT_UPG_TYPES.PO_TBL_NUMBER;

682: PO_R12_CAT_UPG_PVT.g_job.org_id IS NULL)
683: AND PHI.processing_id IS NULL
684: AND PHI.process_code = PO_R12_CAT_UPG_PVT.g_PROCESS_CODE_NEW;
685:
686: l_intf_header_id_tbl PO_R12_CAT_UPG_TYPES.PO_TBL_NUMBER;
687: l_intf_line_id_tbl PO_R12_CAT_UPG_TYPES.PO_TBL_NUMBER;
688:
689: l_processed_intf_hdr_id_tbl PO_R12_CAT_UPG_TYPES.PO_TBL_NUMBER;
690: BEGIN

Line 687: l_intf_line_id_tbl PO_R12_CAT_UPG_TYPES.PO_TBL_NUMBER;

683: AND PHI.processing_id IS NULL
684: AND PHI.process_code = PO_R12_CAT_UPG_PVT.g_PROCESS_CODE_NEW;
685:
686: l_intf_header_id_tbl PO_R12_CAT_UPG_TYPES.PO_TBL_NUMBER;
687: l_intf_line_id_tbl PO_R12_CAT_UPG_TYPES.PO_TBL_NUMBER;
688:
689: l_processed_intf_hdr_id_tbl PO_R12_CAT_UPG_TYPES.PO_TBL_NUMBER;
690: BEGIN
691: l_progress := '010';

Line 689: l_processed_intf_hdr_id_tbl PO_R12_CAT_UPG_TYPES.PO_TBL_NUMBER;

685:
686: l_intf_header_id_tbl PO_R12_CAT_UPG_TYPES.PO_TBL_NUMBER;
687: l_intf_line_id_tbl PO_R12_CAT_UPG_TYPES.PO_TBL_NUMBER;
688:
689: l_processed_intf_hdr_id_tbl PO_R12_CAT_UPG_TYPES.PO_TBL_NUMBER;
690: BEGIN
691: l_progress := '010';
692: IF g_debug THEN PO_R12_CAT_UPG_DEBUG.log_stmt(l_log_head,l_progress,'START'); END IF;
693: