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 2291: -- Since we have the po_line_id available on po_attr_values_interface and tlp_interface

2287: END IF;
2288: --
2289:
2290: --
2291: -- Since we have the po_line_id available on po_attr_values_interface and tlp_interface
2292: -- we can move all records from interface to txn tables for all lines of a given blanket
2293: IF ((g_interface_source_code ='SOURCING') AND (g_document_subtype = 'BLANKET')) THEN
2294: IF g_debug_stmt THEN
2295: PO_DEBUG.debug_stmt(p_log_head => g_log_head||l_api_name,

Line 5126: -- po_attr_values_interface and po_attr_values_interface_tlp

5122: l_progress:='800';
5123: -- For intergration with Sourcing, during blanket creation from Renegotiate flow,
5124: -- we need to import all attributes for each line.
5125: -- to facilitate bulk update, we are storing the newly created po_line on
5126: -- po_attr_values_interface and po_attr_values_interface_tlp
5127: IF (g_document_subtype = 'BLANKET' AND g_interface_source_code = 'SOURCING') THEN
5128: l_progress:='810';
5129:
5130: 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 5132: --SQL What: Update the PO_LINE_ID on PO_ATTR_VALUES_INTERFACE table

5128: l_progress:='810';
5129:
5130: 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;
5131:
5132: --SQL What: Update the PO_LINE_ID on PO_ATTR_VALUES_INTERFACE table
5133: --SQL Why : To facilitate bulk update of attributes, later in the flow
5134: --SQL Join: interface_header_id, interface_line_id
5135: FORALL i IN INDICES OF l_po_line_id_tbl
5136: UPDATE PO_ATTR_VALUES_INTERFACE

Line 5136: UPDATE PO_ATTR_VALUES_INTERFACE

5132: --SQL What: Update the PO_LINE_ID on PO_ATTR_VALUES_INTERFACE table
5133: --SQL Why : To facilitate bulk update of attributes, later in the flow
5134: --SQL Join: interface_header_id, interface_line_id
5135: FORALL i IN INDICES OF l_po_line_id_tbl
5136: UPDATE PO_ATTR_VALUES_INTERFACE
5137: SET po_line_id = l_po_line_id_tbl(i),
5138: req_template_name = to_char(g_ATTR_VALUES_NULL_ID),
5139: req_template_line_num = to_char(g_ATTR_VALUES_NULL_ID),
5140: inventory_item_id = nvl(inventory_item_id, g_ATTR_VALUES_NULL_ID)

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

5137: SET po_line_id = l_po_line_id_tbl(i),
5138: req_template_name = to_char(g_ATTR_VALUES_NULL_ID),
5139: req_template_line_num = to_char(g_ATTR_VALUES_NULL_ID),
5140: inventory_item_id = nvl(inventory_item_id, g_ATTR_VALUES_NULL_ID)
5141: WHERE po_attr_values_interface.interface_header_id = l_interface_header_id_tbl(i)
5142: AND po_attr_values_interface.interface_line_id = l_interface_line_id_tbl(i);
5143:
5144: 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;
5145:

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

5138: req_template_name = to_char(g_ATTR_VALUES_NULL_ID),
5139: req_template_line_num = to_char(g_ATTR_VALUES_NULL_ID),
5140: inventory_item_id = nvl(inventory_item_id, g_ATTR_VALUES_NULL_ID)
5141: WHERE po_attr_values_interface.interface_header_id = l_interface_header_id_tbl(i)
5142: AND po_attr_values_interface.interface_line_id = l_interface_line_id_tbl(i);
5143:
5144: 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;
5145:
5146: l_progress:='820';

Line 5144: 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;

5140: inventory_item_id = nvl(inventory_item_id, g_ATTR_VALUES_NULL_ID)
5141: WHERE po_attr_values_interface.interface_header_id = l_interface_header_id_tbl(i)
5142: AND po_attr_values_interface.interface_line_id = l_interface_line_id_tbl(i);
5143:
5144: 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;
5145:
5146: l_progress:='820';
5147: --SQL What: Update the PO_LINE_ID on PO_ATTR_VALUES_TLP_INTERFACE table
5148: --SQL Why : To facilitate bulk update of attributes, later in the flow