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_INTERFACE_S dependencies on PO_ATTR_VALUES_INTERFACE

Line 137: TYPE interface_header_id_tbl IS TABLE OF PO_ATTR_VALUES_INTERFACE.interface_header_id%TYPE INDEX BY PLS_INTEGER;

133: acceptance_required_flag po_system_parameters.acceptance_required_flag%type); /* Bug 7518967 : Default Acceptance Required Check ER */
134:
135: --
136: TYPE po_line_id_tbl IS TABLE OF PO_LINES_ALL.po_line_id%TYPE INDEX BY PLS_INTEGER;
137: TYPE interface_header_id_tbl IS TABLE OF PO_ATTR_VALUES_INTERFACE.interface_header_id%TYPE INDEX BY PLS_INTEGER;
138: TYPE interface_line_id_tbl IS TABLE OF PO_ATTR_VALUES_INTERFACE.interface_line_id%TYPE INDEX BY PLS_INTEGER;
139: --
140:
141: /* ecso 5/14/97

Line 138: TYPE interface_line_id_tbl IS TABLE OF PO_ATTR_VALUES_INTERFACE.interface_line_id%TYPE INDEX BY PLS_INTEGER;

134:
135: --
136: TYPE po_line_id_tbl IS TABLE OF PO_LINES_ALL.po_line_id%TYPE INDEX BY PLS_INTEGER;
137: TYPE interface_header_id_tbl IS TABLE OF PO_ATTR_VALUES_INTERFACE.interface_header_id%TYPE INDEX BY PLS_INTEGER;
138: TYPE interface_line_id_tbl IS TABLE OF PO_ATTR_VALUES_INTERFACE.interface_line_id%TYPE INDEX BY PLS_INTEGER;
139: --
140:
141: /* ecso 5/14/97
142: * Add order by unit_price to interface_cursor.

Line 2617: -- Since we have the po_line_id available on po_attr_values_interface and tlp_interface

2613: END IF;
2614: --
2615:
2616: --
2617: -- Since we have the po_line_id available on po_attr_values_interface and tlp_interface
2618: -- we can move all records from interface to txn tables for all lines of a given blanket
2619: IF ((g_interface_source_code ='SOURCING') AND (g_document_subtype = 'BLANKET')) THEN
2620: IF g_debug_stmt THEN
2621: PO_DEBUG.debug_stmt(p_log_head => g_log_head||l_api_name,

Line 5586: -- po_attr_values_interface and po_attr_values_interface_tlp

5582: l_progress:='800';
5583: -- For intergration with Sourcing, during blanket creation from Renegotiate flow,
5584: -- we need to import all attributes for each line.
5585: -- to facilitate bulk update, we are storing the newly created po_line on
5586: -- po_attr_values_interface and po_attr_values_interface_tlp
5587: IF (g_document_subtype = 'BLANKET' AND g_interface_source_code = 'SOURCING') THEN
5588: l_progress:='810';
5589:
5590: IF g_debug_stmt THEN PO_DEBUG.debug_stmt(d_mod,l_progress,'Updating PO_LINE_IDs in attribute interface tables: '||l_po_line_id_tbl.COUNT);END IF;

Line 5592: --SQL What: Update the PO_LINE_ID on PO_ATTR_VALUES_INTERFACE table

5588: l_progress:='810';
5589:
5590: IF g_debug_stmt THEN PO_DEBUG.debug_stmt(d_mod,l_progress,'Updating PO_LINE_IDs in attribute interface tables: '||l_po_line_id_tbl.COUNT);END IF;
5591:
5592: --SQL What: Update the PO_LINE_ID on PO_ATTR_VALUES_INTERFACE table
5593: --SQL Why : To facilitate bulk update of attributes, later in the flow
5594: --SQL Join: interface_header_id, interface_line_id
5595: FORALL i IN INDICES OF l_po_line_id_tbl
5596: UPDATE PO_ATTR_VALUES_INTERFACE

Line 5596: UPDATE PO_ATTR_VALUES_INTERFACE

5592: --SQL What: Update the PO_LINE_ID on PO_ATTR_VALUES_INTERFACE table
5593: --SQL Why : To facilitate bulk update of attributes, later in the flow
5594: --SQL Join: interface_header_id, interface_line_id
5595: FORALL i IN INDICES OF l_po_line_id_tbl
5596: UPDATE PO_ATTR_VALUES_INTERFACE
5597: SET po_line_id = l_po_line_id_tbl(i),
5598: req_template_name = to_char(g_ATTR_VALUES_NULL_ID),
5599: req_template_line_num = to_char(g_ATTR_VALUES_NULL_ID),
5600: inventory_item_id = nvl(inventory_item_id, g_ATTR_VALUES_NULL_ID)

Line 5601: WHERE po_attr_values_interface.interface_header_id = l_interface_header_id_tbl(i)

5597: SET po_line_id = l_po_line_id_tbl(i),
5598: req_template_name = to_char(g_ATTR_VALUES_NULL_ID),
5599: req_template_line_num = to_char(g_ATTR_VALUES_NULL_ID),
5600: inventory_item_id = nvl(inventory_item_id, g_ATTR_VALUES_NULL_ID)
5601: WHERE po_attr_values_interface.interface_header_id = l_interface_header_id_tbl(i)
5602: AND po_attr_values_interface.interface_line_id = l_interface_line_id_tbl(i);
5603:
5604: IF g_debug_stmt THEN PO_DEBUG.debug_stmt(d_mod,l_progress,'Number of PO_ATTR_VALUES_INTERFACE rows updated='||SQL%rowcount);END IF;
5605:

Line 5602: AND po_attr_values_interface.interface_line_id = l_interface_line_id_tbl(i);

5598: req_template_name = to_char(g_ATTR_VALUES_NULL_ID),
5599: req_template_line_num = to_char(g_ATTR_VALUES_NULL_ID),
5600: inventory_item_id = nvl(inventory_item_id, g_ATTR_VALUES_NULL_ID)
5601: WHERE po_attr_values_interface.interface_header_id = l_interface_header_id_tbl(i)
5602: AND po_attr_values_interface.interface_line_id = l_interface_line_id_tbl(i);
5603:
5604: IF g_debug_stmt THEN PO_DEBUG.debug_stmt(d_mod,l_progress,'Number of PO_ATTR_VALUES_INTERFACE rows updated='||SQL%rowcount);END IF;
5605:
5606: l_progress:='820';

Line 5604: IF g_debug_stmt THEN PO_DEBUG.debug_stmt(d_mod,l_progress,'Number of PO_ATTR_VALUES_INTERFACE rows updated='||SQL%rowcount);END IF;

5600: inventory_item_id = nvl(inventory_item_id, g_ATTR_VALUES_NULL_ID)
5601: WHERE po_attr_values_interface.interface_header_id = l_interface_header_id_tbl(i)
5602: AND po_attr_values_interface.interface_line_id = l_interface_line_id_tbl(i);
5603:
5604: IF g_debug_stmt THEN PO_DEBUG.debug_stmt(d_mod,l_progress,'Number of PO_ATTR_VALUES_INTERFACE rows updated='||SQL%rowcount);END IF;
5605:
5606: l_progress:='820';
5607: --SQL What: Update the PO_LINE_ID on PO_ATTR_VALUES_TLP_INTERFACE table
5608: --SQL Why : To facilitate bulk update of attributes, later in the flow