APPS.PO_LINES_SV dependencies on PO_LINES_ALL

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

155: l_isucaenabled VARCHAR2(1) :='N';
156:
157: CURSOR C_LINE is
158: SELECT po_line_id
159: FROM po_lines_all /*Bug6632095: using base table instead of view */
160: WHERE po_header_id = X_po_header_id;
161:
162:
163: BEGIN

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

199: --Enhanced Pricing
200: PO_PRICE_ADJUSTMENTS_PKG.delete_price_adjustments(p_po_header_id => X_po_header_id );
201:
202: --dbms_output.put_line('Before delete all lines');
203: DELETE FROM PO_LINES_ALL /*Bug6632095: using base table instead of view */
204: WHERE po_header_id = X_po_header_id;
205: --Delete Line UCAS IF UCA Enabled Begin.
206:
207: SELECT Nvl(po_core_s.Retrieveoptionvalue(org_id,

Line 339: l_line_creation_date PO_LINES_ALL.creation_date%type;

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

Line 355: po_lines_all POL

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

Line 427: PO_LINES_ALL POL

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

Line 524: , PO_LINES_ALL POL

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

Line 534: FROM po_lines_all pol

530:
531: IF(l_type_lookup_code='BLANKET') THEN
532: SELECT Max('N')
533: INTO X_allow_delete
534: FROM po_lines_all pol
535: WHERE pol.from_line_id = X_po_line_id ;
536:
537: IF ( X_allow_delete = 'N' ) THEN
538: po_message_s.app_error('PO_PO_USE_CANCEL_ON_APRVD_PO3',p_token,p_token_value);