APPS.PON_CLO_RENUMBER_PKG dependencies on PO_LINES_INTERFACE

Line 1317: FROM PO_LINES_INTERFACE

1313: x_status := NULL;
1314:
1315: SELECT INTERFACE_LINE_ID
1316: INTO l_group_line_id
1317: FROM PO_LINES_INTERFACE
1318: WHERE INTERFACE_HEADER_ID = p_interface_header_id AND
1319: LINE_NUM_DISPLAY = p_clinnumber;
1320:
1321: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN

Line 1334: FROM PO_LINES_INTERFACE

1330:
1331:
1332: l_slin_query := 'SELECT INTERFACE_LINE_ID,
1333: CLM_INFO_FLAG
1334: FROM PO_LINES_INTERFACE
1335: WHERE GROUP_LINE_ID = ' || l_group_line_id || ' AND
1336: INTERFACE_HEADER_ID = ' || p_interface_header_id ||
1337: ' ORDER BY INTERFACE_LINE_ID';
1338: OPEN all_slins FOR l_slin_query;

Line 1356: l_updt_query := ' UPDATE PO_LINES_INTERFACE

1352: END IF;
1353: -- If the slin is a priced Slin then
1354: IF Nvl(slnInfoFlg,'N') = 'N' THEN
1355: -- Assign the to this slin and call = INCREMENT_PRICED_SLIN_NUM()
1356: l_updt_query := ' UPDATE PO_LINES_INTERFACE
1357: SET LINE_NUM_DISPLAY = ''' || lastPricedSlin || '''' ||
1358: ' WHERE INTERFACE_HEADER_ID = ' || p_interface_header_id ||
1359: ' AND INTERFACE_LINE_ID = ' || slnLineId;
1360: BEGIN

Line 1372: l_updt_query := ' UPDATE PO_LINES_INTERFACE

1368: module => 'pon.plsql.pon_clo_renumber_pkg',
1369: message => substr('lastPricedSlin : '||lastPricedSlin, 0, 4000));
1370: END IF;
1371: ELSE
1372: l_updt_query := ' UPDATE PO_LINES_INTERFACE
1373: SET LINE_NUM_DISPLAY = ''' || lastInfoSlin || '''' ||
1374: ' WHERE INTERFACE_HEADER_ID = ' || p_interface_header_id ||
1375: ' AND INTERFACE_LINE_ID = ' || slnLineId;
1376: BEGIN