APPS.PO_LINES_SV dependencies on PO_HEADERS_ALL

Line 210: FROM po_headers_all

206:
207: SELECT Nvl(po_core_s.Retrieveoptionvalue(org_id,
208: po_core_s.g_undef_cont_act_col), 'N')
209: INTO l_isucaenabled
210: FROM po_headers_all
211: WHERE po_header_id = X_po_header_id;
212:
213: IF l_isucaenabled = 'Y' THEN
214: DELETE FROM po_line_ucas

Line 332: l_type_lookup_code PO_HEADERS_ALL.type_lookup_code%TYPE;

328: x_message_text OUT NOCOPY VARCHAR2)
329: IS
330: x_progress VARCHAR2(3) := '';
331:
332: l_type_lookup_code PO_HEADERS_ALL.type_lookup_code%TYPE;
333: l_some_dists_reserved_flag VARCHAR2(1);
334:
335: l_approved_flag PO_HEADERS_ALL.approved_flag%type;
336: l_po_header_id PO_HEADERS_ALL.po_header_id%type;

Line 335: l_approved_flag PO_HEADERS_ALL.approved_flag%type;

331:
332: l_type_lookup_code PO_HEADERS_ALL.type_lookup_code%TYPE;
333: l_some_dists_reserved_flag VARCHAR2(1);
334:
335: l_approved_flag PO_HEADERS_ALL.approved_flag%type;
336: l_po_header_id PO_HEADERS_ALL.po_header_id%type;
337: l_approved_date PO_HEADERS_ALL.approved_date%type;
338:
339: l_line_creation_date PO_LINES_ALL.creation_date%type;

Line 336: l_po_header_id PO_HEADERS_ALL.po_header_id%type;

332: l_type_lookup_code PO_HEADERS_ALL.type_lookup_code%TYPE;
333: l_some_dists_reserved_flag VARCHAR2(1);
334:
335: l_approved_flag PO_HEADERS_ALL.approved_flag%type;
336: l_po_header_id PO_HEADERS_ALL.po_header_id%type;
337: l_approved_date PO_HEADERS_ALL.approved_date%type;
338:
339: l_line_creation_date PO_LINES_ALL.creation_date%type;
340: BEGIN

Line 337: l_approved_date PO_HEADERS_ALL.approved_date%type;

333: l_some_dists_reserved_flag VARCHAR2(1);
334:
335: l_approved_flag PO_HEADERS_ALL.approved_flag%type;
336: l_po_header_id PO_HEADERS_ALL.po_header_id%type;
337: l_approved_date PO_HEADERS_ALL.approved_date%type;
338:
339: l_line_creation_date PO_LINES_ALL.creation_date%type;
340: BEGIN
341: x_progress := '010';

Line 354: FROM po_headers_all POH,

350: l_approved_flag,
351: l_po_header_id,
352: l_approved_date,
353: l_line_creation_date
354: FROM po_headers_all POH,
355: po_lines_all POL
356: WHERE POH.po_header_id = POL.po_header_id
357: AND POL.po_line_id = X_po_line_id;
358:

Line 426: FROM PO_HEADERS_ALL POH,

422: --
423:
424: SELECT POH.type_lookup_code
425: INTO l_type_lookup_code
426: FROM PO_HEADERS_ALL POH,
427: PO_LINES_ALL POL
428: WHERE POH.po_header_id = POL.po_header_id
429: AND POL.po_line_id = x_po_line_id;
430:

Line 492: l_type_lookup_code PO_HEADERS_ALL.type_lookup_code%TYPE;

488: IS
489: x_progress VARCHAR2(3) := '';
490:
491: --
492: l_type_lookup_code PO_HEADERS_ALL.type_lookup_code%TYPE;
493: l_some_dists_reserved_flag VARCHAR2(1);
494:
495: BEGIN
496: x_progress := '010';

Line 523: FROM PO_HEADERS_ALL POH

519: -- Only check for reserved distributions for Standard and Planned PO lines.
520:
521: SELECT POH.type_lookup_code
522: INTO l_type_lookup_code
523: FROM PO_HEADERS_ALL POH
524: , PO_LINES_ALL POL
525: WHERE POH.po_header_id = POL.po_header_id
526: AND POL.po_line_id = x_po_line_id
527: ;