APPS.PO_LINES_SV dependencies on PO_HEADERS_ALL

Line 292: l_type_lookup_code PO_HEADERS_ALL.type_lookup_code%TYPE;

288: x_message_text OUT NOCOPY VARCHAR2)
289: IS
290: x_progress VARCHAR2(3) := '';
291:
292: l_type_lookup_code PO_HEADERS_ALL.type_lookup_code%TYPE;
293: l_some_dists_reserved_flag VARCHAR2(1);
294:
295: l_approved_flag PO_HEADERS_ALL.approved_flag%type;
296: l_po_header_id PO_HEADERS_ALL.po_header_id%type;

Line 295: l_approved_flag PO_HEADERS_ALL.approved_flag%type;

291:
292: l_type_lookup_code PO_HEADERS_ALL.type_lookup_code%TYPE;
293: l_some_dists_reserved_flag VARCHAR2(1);
294:
295: l_approved_flag PO_HEADERS_ALL.approved_flag%type;
296: l_po_header_id PO_HEADERS_ALL.po_header_id%type;
297: l_approved_date PO_HEADERS_ALL.approved_date%type;
298:
299: l_line_creation_date PO_LINES_ALL.creation_date%type;

Line 296: l_po_header_id PO_HEADERS_ALL.po_header_id%type;

292: l_type_lookup_code PO_HEADERS_ALL.type_lookup_code%TYPE;
293: l_some_dists_reserved_flag VARCHAR2(1);
294:
295: l_approved_flag PO_HEADERS_ALL.approved_flag%type;
296: l_po_header_id PO_HEADERS_ALL.po_header_id%type;
297: l_approved_date PO_HEADERS_ALL.approved_date%type;
298:
299: l_line_creation_date PO_LINES_ALL.creation_date%type;
300: BEGIN

Line 297: l_approved_date PO_HEADERS_ALL.approved_date%type;

293: l_some_dists_reserved_flag VARCHAR2(1);
294:
295: l_approved_flag PO_HEADERS_ALL.approved_flag%type;
296: l_po_header_id PO_HEADERS_ALL.po_header_id%type;
297: l_approved_date PO_HEADERS_ALL.approved_date%type;
298:
299: l_line_creation_date PO_LINES_ALL.creation_date%type;
300: BEGIN
301: x_progress := '010';

Line 314: FROM po_headers_all POH,

310: l_approved_flag,
311: l_po_header_id,
312: l_approved_date,
313: l_line_creation_date
314: FROM po_headers_all POH,
315: po_lines_all POL
316: WHERE POH.po_header_id = POL.po_header_id
317: AND POL.po_line_id = X_po_line_id;
318:

Line 386: FROM PO_HEADERS_ALL POH,

382: --
383:
384: SELECT POH.type_lookup_code
385: INTO l_type_lookup_code
386: FROM PO_HEADERS_ALL POH,
387: PO_LINES_ALL POL
388: WHERE POH.po_header_id = POL.po_header_id
389: AND POL.po_line_id = x_po_line_id;
390:

Line 452: l_type_lookup_code PO_HEADERS_ALL.type_lookup_code%TYPE;

448: IS
449: x_progress VARCHAR2(3) := '';
450:
451: --
452: l_type_lookup_code PO_HEADERS_ALL.type_lookup_code%TYPE;
453: l_some_dists_reserved_flag VARCHAR2(1);
454:
455: BEGIN
456: x_progress := '010';

Line 483: FROM PO_HEADERS_ALL POH

479: -- Only check for reserved distributions for Standard and Planned PO lines.
480:
481: SELECT POH.type_lookup_code
482: INTO l_type_lookup_code
483: FROM PO_HEADERS_ALL POH
484: , PO_LINES_ALL POL
485: WHERE POH.po_header_id = POL.po_header_id
486: AND POL.po_line_id = x_po_line_id
487: ;