APPS.PON_SOURCING_OPENAPI_GRP dependencies on PO_LINE_LOCATIONS_ALL

Line 1592: select line_location_id bulk collect into l_lineloc_list from po_line_locations_all where po_header_id = g_header_rec.source_doc_id and po_line_id = l_poline_id;

1588:
1589:
1590: --copy SHIP_INFO UDA from po_line_locations
1591: IF ( v_return_status <> 'E' ) THEN
1592: select line_location_id bulk collect into l_lineloc_list from po_line_locations_all where po_header_id = g_header_rec.source_doc_id and po_line_id = l_poline_id;
1593: for j in 1..l_lineloc_list.count
1594: loop
1595: v_debug_status := 'COPY_SHIP_UDA';
1596: if ( j = 1 ) THEN

Line 1597: select uda_template_id into l_shp_template_id from po_line_locations_all where line_location_id = l_lineloc_list(j) and rownum<2;

1593: for j in 1..l_lineloc_list.count
1594: loop
1595: v_debug_status := 'COPY_SHIP_UDA';
1596: if ( j = 1 ) THEN
1597: select uda_template_id into l_shp_template_id from po_line_locations_all where line_location_id = l_lineloc_list(j) and rownum<2;
1598: end if;
1599: l_src_pkey := GET_PKEY(l_lineloc_list(j),-1);
1600: l_tar_pkey := GET_PKEY(x_document_number,l_lineno_list(i));
1601: