DBA Data[Home] [Help]

APPS.PO_LINES_SV dependencies on PO_LINES_ALL

Line 151: FROM po_lines_all /*Bug6632095: using base table instead of view */

147: X_po_line_id NUMBER := '';
148:
149: CURSOR C_LINE is
150: SELECT po_line_id
151: FROM po_lines_all /*Bug6632095: using base table instead of view */
152: WHERE po_header_id = X_po_header_id;
153:
154:
155: BEGIN

Line 192: DELETE FROM PO_LINES_ALL /*Bug6632095: using base table instead of view */

188: );
189: --
190:
191: --dbms_output.put_line('Before delete all lines');
192: DELETE FROM PO_LINES_ALL /*Bug6632095: using base table instead of view */
193: WHERE po_header_id = X_po_header_id;
194:
195: EXCEPTION
196: WHEN OTHERS THEN

Line 299: l_line_creation_date PO_LINES_ALL.creation_date%type;

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';
302:
303: -- Get type lookup code and approval status. Variables are used in later checks

Line 315: po_lines_all POL

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:
319: -- Following check is in key_delrec and not in val_line_delete

Line 387: PO_LINES_ALL POL

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:
391: X_allow_delete := 'Y';

Line 484: , PO_LINES_ALL POL

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: ;
488: