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

Line 3574: -- po_attr_values_interface and po_attr_values_interface_tlp

3570: --
3571: -- For intergration with Sourcing, during blanket creation from Renegotiate flow,
3572: -- we need to import all attributes for each line.
3573: -- to facilitate bulk update, we are storing the newly created po_line on
3574: -- po_attr_values_interface and po_attr_values_interface_tlp
3575:
3576: IF(PO_AUTOCREATE_PARAMS.g_document_subtype = 'BLANKET' AND PO_AUTOCREATE_PARAMS.g_interface_source_code = 'SOURCING') THEN
3577:
3578: l_progress:='001';

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

3581: PO_DEBUG.debug_stmt(p_log_head => g_log_head||l_api_name, p_token => l_progress,
3582: p_message =>'Updating PO_LINE_IDs in attribute interface tables: '||p_lines.po_line_id_tbl.COUNT);
3583: END IF;
3584:
3585: --SQL What: Update the PO_LINE_ID on PO_ATTR_VALUES_INTERFACE table
3586: --SQL Why : To facilitate bulk update of attributes, later in the flow
3587: --SQL Join: interface_header_id, interface_line_id
3588:
3589: FORALL i IN p_lines.po_line_id_tbl.FIRST.. p_lines.po_line_id_tbl.LAST

Line 3590: UPDATE PO_ATTR_VALUES_INTERFACE

3586: --SQL Why : To facilitate bulk update of attributes, later in the flow
3587: --SQL Join: interface_header_id, interface_line_id
3588:
3589: FORALL i IN p_lines.po_line_id_tbl.FIRST.. p_lines.po_line_id_tbl.LAST
3590: UPDATE PO_ATTR_VALUES_INTERFACE
3591: SET po_line_id = p_lines.po_line_id_tbl(i),
3592: req_template_name = TO_CHAR(g_ATTR_VALUES_NULL_ID),
3593: req_template_line_num = TO_CHAR(g_ATTR_VALUES_NULL_ID),
3594: inventory_item_id = NVL(inventory_item_id, g_ATTR_VALUES_NULL_ID)

Line 3595: WHERE po_attr_values_interface.interface_header_id = p_lines.intf_header_id_tbl(i)

3591: SET po_line_id = p_lines.po_line_id_tbl(i),
3592: req_template_name = TO_CHAR(g_ATTR_VALUES_NULL_ID),
3593: req_template_line_num = TO_CHAR(g_ATTR_VALUES_NULL_ID),
3594: inventory_item_id = NVL(inventory_item_id, g_ATTR_VALUES_NULL_ID)
3595: WHERE po_attr_values_interface.interface_header_id = p_lines.intf_header_id_tbl(i)
3596: AND po_attr_values_interface.interface_line_id = p_lines.intf_line_id_tbl(i);
3597:
3598: IF g_debug_stmt THEN
3599: PO_DEBUG.debug_stmt(p_log_head=>g_log_head||l_api_name,p_token=>l_progress,p_message=>'Number of PO_ATTR_VALUES_INTERFACE rows updated='||SQL% rowcount);

Line 3596: AND po_attr_values_interface.interface_line_id = p_lines.intf_line_id_tbl(i);

3592: req_template_name = TO_CHAR(g_ATTR_VALUES_NULL_ID),
3593: req_template_line_num = TO_CHAR(g_ATTR_VALUES_NULL_ID),
3594: inventory_item_id = NVL(inventory_item_id, g_ATTR_VALUES_NULL_ID)
3595: WHERE po_attr_values_interface.interface_header_id = p_lines.intf_header_id_tbl(i)
3596: AND po_attr_values_interface.interface_line_id = p_lines.intf_line_id_tbl(i);
3597:
3598: IF g_debug_stmt THEN
3599: PO_DEBUG.debug_stmt(p_log_head=>g_log_head||l_api_name,p_token=>l_progress,p_message=>'Number of PO_ATTR_VALUES_INTERFACE rows updated='||SQL% rowcount);
3600: END IF;

Line 3599: PO_DEBUG.debug_stmt(p_log_head=>g_log_head||l_api_name,p_token=>l_progress,p_message=>'Number of PO_ATTR_VALUES_INTERFACE rows updated='||SQL% rowcount);

3595: WHERE po_attr_values_interface.interface_header_id = p_lines.intf_header_id_tbl(i)
3596: AND po_attr_values_interface.interface_line_id = p_lines.intf_line_id_tbl(i);
3597:
3598: IF g_debug_stmt THEN
3599: PO_DEBUG.debug_stmt(p_log_head=>g_log_head||l_api_name,p_token=>l_progress,p_message=>'Number of PO_ATTR_VALUES_INTERFACE rows updated='||SQL% rowcount);
3600: END IF;
3601:
3602: l_progress:='010';
3603: --SQL What: Update the PO_LINE_ID on PO_ATTR_VALUES_TLP_INTERFACE table

Line 4279: FROM PO_ATTR_VALUES_INTERFACE

4275: TEXT_CAT_ATTRIBUTE9,
4276: THUMBNAIL_IMAGE,
4277: UNSPSC,
4278: 'AUTOCREATE_BACKEND_FOR_SOURCING'
4279: FROM PO_ATTR_VALUES_INTERFACE
4280: WHERE interface_header_id = PO_AUTOCREATE_PARAMS.x_interface_header_id;
4281:
4282: IF g_debug_stmt THEN
4283: PO_DEBUG.debug_stmt(p_log_head=>g_log_head||l_api_name ,p_token=>l_progress ,p_message=>'Number of rows inserted in PO_ATTRIBUTE_VALUES table='||SQL%ROWCOUNT );