APPS.PO_PDOI_ERR_UTL SQL Statements

The following lines contain the word 'select', 'insert', 'update' or 'delete':

Line: 625

    INSERT INTO po_session_gt
    ( key, index_num1, num1 )
    VALUES
    (l_key, l_seq(i), p_table_id_tbl(i));

Line: 636

    SELECT PHI.interface_header_id
    BULK COLLECT
    INTO x_intf_header_id_tbl
    FROM po_session_gt PSG,
         po_headers_interface PHI
    WHERE PSG.key = l_key AND
          PSG.num1 = PHI.interface_header_id
    ORDER BY PSG.index_num1;

Line: 649

    SELECT PLI.interface_header_id,
           PLI.interface_line_id
    BULK COLLECT
    INTO  x_intf_header_id_tbl,
          x_intf_line_id_tbl
    FROM po_session_gt PSG,
         po_lines_interface PLI
    WHERE PSG.key = l_key
    AND PSG.num1 = PLI.interface_line_id
    ORDER BY PSG.index_num1;

Line: 664

    SELECT PLLI.interface_header_id,
           PLLI.interface_line_id,
           PLLI.interface_line_location_id
    BULK COLLECT
    INTO x_intf_header_id_tbl,
         x_intf_line_id_tbl,
         x_intf_line_loc_id_tbl
    FROM po_session_gt PSG,
         po_line_locations_interface PLLI
    WHERE PSG.key = l_key
    AND PSG.num1 = PLLI.interface_line_location_id
    ORDER BY PSG.index_num1;

Line: 681

    SELECT PDI.interface_header_id,
           PDI.interface_line_id,
           PDI.interface_line_location_id,
           PDI.interface_distribution_id
    BULK COLLECT
    INTO x_intf_header_id_tbl,
         x_intf_line_id_tbl,
         x_intf_line_loc_id_tbl,
         x_intf_dist_id_tbl
    FROM po_session_gt PSG,
         po_distributions_interface PDI
    WHERE PSG.key = l_key
    AND PSG.num1 = PDI.interface_distribution_id
    ORDER BY PSG.index_num1;

Line: 700

    SELECT PPDI.interface_header_id,
           PPDI.interface_line_id,
           PPDI.interface_line_location_id,
           PPDI.price_diff_interface_id
    BULK COLLECT
    INTO x_intf_header_id_tbl,
         x_intf_line_id_tbl,
         x_intf_line_loc_id_tbl,
         x_intf_price_diff_id_tbl
    FROM po_session_gt PSG,
         po_price_diff_interface PPDI
    WHERE PSG.key = l_key
    AND PSG.num1 = PPDI.price_diff_interface_id
    ORDER BY PSG.index_num1;