APPS.POS_EXCELASN_GRP dependencies on PO_LINES_ALL

Line 22: l_po_line_num PO_LINES_ALL.LINE_NUM_DISPLAY%TYPE;

18: l_operating_unit VARCHAR2(240);
19: l_org_id NUMBER;
20: l_po_number PO_HEADERS_ALL.CLM_DOCUMENT_NUMBER%TYPE;
21: l_segment1 PO_HEADERS_ALL.CLM_DOCUMENT_NUMBER%TYPE;
22: l_po_line_num PO_LINES_ALL.LINE_NUM_DISPLAY%TYPE;
23: l_line_number PO_LINES_ALL.LINE_NUM_DISPLAY%TYPE;
24: l_clm_flag VARCHAR2(1) := 'N';
25: l_po_header_id NUMBER;
26: BEGIN

Line 23: l_line_number PO_LINES_ALL.LINE_NUM_DISPLAY%TYPE;

19: l_org_id NUMBER;
20: l_po_number PO_HEADERS_ALL.CLM_DOCUMENT_NUMBER%TYPE;
21: l_segment1 PO_HEADERS_ALL.CLM_DOCUMENT_NUMBER%TYPE;
22: l_po_line_num PO_LINES_ALL.LINE_NUM_DISPLAY%TYPE;
23: l_line_number PO_LINES_ALL.LINE_NUM_DISPLAY%TYPE;
24: l_clm_flag VARCHAR2(1) := 'N';
25: l_po_header_id NUMBER;
26: BEGIN
27:

Line 177: FROM PO_LINES_ALL POL

173: IF(l_clm_flag = 'Y' AND l_po_header_id IS NOT null) THEN
174: BEGIN
175: SELECT POL.LINE_NUM
176: INTO l_line_number
177: FROM PO_LINES_ALL POL
178: WHERE POL.PO_HEADER_ID = l_po_header_id AND
179: POL.LINE_NUM_DISPLAY = l_po_line_num;
180: EXCEPTION WHEN OTHERS THEN
181: l_line_number := p_lines_tbl.PO_Line(i);