APPS.PO_QUOTES_SV SQL Statements

The following lines contain the word 'select', 'insert', 'update' or 'delete':

Line: 8

  PROCEDURE NAME:	test_val_header_delete()

===========================================================================*/

PROCEDURE test_val_header_delete(X_po_header_id	  IN	NUMBER) IS

X_allow_delete		BOOLEAN;

Line: 20

  po_quotes_sv.val_header_delete(X_po_header_id, X_allow_delete);

Line: 24

  if (X_allow_delete) then
    dbms_output.put_line('Allow Delete = TRUE');

Line: 27

    dbms_output.put_line('Allow Delete = FALSE');

Line: 30

END test_val_header_delete;

Line: 34

  PROCEDURE NAME:	val_header_delete()

===========================================================================*/

PROCEDURE val_header_delete(X_po_header_id  IN		NUMBER,
			    X_allow_delete  IN OUT	NOCOPY BOOLEAN) IS

  x_progress 		VARCHAR2(3) := '';

Line: 42

  x_delete_test 	VARCHAR2(1) := 'Y';

Line: 54

  **   If it is, display message and prevent delete.
  */
  SELECT MAX('N')
  INTO   X_delete_test
  FROM   po_lines pol
  WHERE  pol.from_header_id = X_po_header_id;

Line: 63

  IF (nvl(X_delete_test,'Y') = 'Y') THEN
    /*
    ** Verify the Quotation is not used in autosource rules.
    **   If it is NOT, verify it is not on a req line.
    **   If it is, display message and prevent delete.
    **
    ** CMOK: If ASL installed, use po_asl_documents table.
    */


    SELECT MAX('N')
    INTO   X_delete_test
    FROM   po_asl_documents pad
    WHERE  pad.document_header_id = X_po_header_id;

Line: 78

    IF (nvl(X_delete_test,'Y') = 'Y') THEN
      /*
      ** Verify the Quotation is not referenced on a Requisition line.
      **   If it is NOT, allow the delete.
      **   If it is, display message and prevent delete.
      */
      SELECT MAX('N')
      INTO   X_delete_test
      FROM   po_requisition_lines prl
      WHERE  prl.blanket_po_header_id = X_po_header_id;

Line: 89

      IF (nvl(X_delete_test,'Y') = 'Y') THEN
        X_allow_delete := TRUE;

Line: 91

        dbms_output.put_line('Delete permitted');

Line: 93

        X_allow_delete := FALSE;

Line: 94

        po_message_s.app_error('PO_DELETE_QT_ON_REQ');

Line: 99

      X_allow_delete := FALSE;

Line: 100

      po_message_s.app_error('PO_QT_DELETE_SOURCE');

Line: 104

    X_allow_delete := FALSE;

Line: 105

    po_message_s.app_error('PO_DELETE_QT_ON_PO_NA');

Line: 112

    po_message_s.sql_error('val_header_delete', x_progress, sqlcode);

Line: 114

END val_header_delete;

Line: 118

  PROCEDURE NAME:	test_val_line_delete()

===========================================================================*/

PROCEDURE test_val_line_delete(X_po_line_id	  IN	NUMBER,
			       X_po_line_num	  IN	NUMBER,
			       X_po_header_id	  IN	NUMBER) IS

X_allow_delete		VARCHAR2(1) := '';

Line: 132

  po_quotes_sv.val_line_delete(X_po_line_id, X_po_line_num, X_po_header_id,
			       X_allow_delete);

Line: 136

  dbms_output.put_line('Allow Delete = '||X_allow_delete);

Line: 138

END test_val_line_delete;

Line: 142

  PROCEDURE NAME:	val_line_delete()

===========================================================================*/

PROCEDURE val_line_delete(X_po_line_id	  IN		NUMBER,
			  X_po_line_num	  IN		NUMBER,
			  X_po_header_id  IN		NUMBER,
			  X_allow_delete  IN OUT	NOCOPY VARCHAR2) IS

  x_progress 		 VARCHAR2(3) := '';

Line: 157

 	SELECT 	pol.po_line_id
	FROM	po_lines pol
	WHERE  	pol.from_header_id = X_po_header_id
	AND    	pol.from_line_id   = X_po_line_id;

Line: 163

	SELECT 	prl.blanket_po_line_num
	FROM 	po_requisition_lines prl
	WHERE 	prl.BLANKET_PO_HEADER_ID = X_po_header_id
	AND   	prl.BLANKET_PO_LINE_NUM  = X_po_line_num;

Line: 195

  **   if it is, display message and prevent delete.
  */
  IF C_ON_PO%NOTFOUND THEN

    /*
    ** check to see if the Quotation line is used in ASL.
    **   if it is NOT, verify it is not on a req line.
    **   if it is, display message and prevent delete.
    **
    */


    x_progress := '040';

Line: 208

    SELECT 	count(*)
    INTO    x_sourced
    FROM  	po_asl_documents pad
    WHERE 	pad.DOCUMENT_HEADER_ID = X_po_header_id
    AND   	pad.DOCUMENT_LINE_ID   = X_po_line_id;

Line: 220

      **   if it is NOT, allow the delete.
      **   if it is, display message and prevent delete.
      */

      IF C_ON_REQ%NOTFOUND THEN
        X_allow_delete := 'Y';

Line: 226

        dbms_output.put_line('Allow delete = '||X_allow_delete);

Line: 228

    	X_allow_delete := 'N';

Line: 229

        po_message_s.app_error('PO_DELETE_REQS');

Line: 230

    	dbms_output.put_line('Allow delete = '||X_allow_delete);

Line: 234

      X_allow_delete := 'N';

Line: 235

      po_message_s.app_error('PO_QT_LINE_DELETE_SOURCE');

Line: 236

      dbms_output.put_line('Allow delete = '||X_allow_delete);

Line: 240

    X_allow_delete := 'N';

Line: 241

    po_message_s.app_error('PO_QT_LINE_DELETE_NA');

Line: 242

    dbms_output.put_line('Allow delete = '||X_allow_delete);

Line: 254

    po_message_s.sql_error('val_line_delete', x_progress, sqlcode);

Line: 256

END val_line_delete;

Line: 302

  SELECT MAX('Y')
    INTO x_duplicate_reply
    FROM po_headers
   WHERE from_header_id    	= X_from_header_id
     AND vendor_id         	= X_vendor_id
     AND vendor_site_id    	= X_vendor_site_id
     AND from_type_lookup_code 	= 'RFQ';

Line: 364

  SELECT MAX('Y')
    INTO X_quote_referenced
    FROM po_lines pol
   WHERE pol.from_header_id = X_po_header_id;

Line: 378

    SELECT MAX('Y')
      INTO X_quote_referenced
      FROM po_autosource_documents pad
     WHERE pad.DOCUMENT_HEADER_ID = X_po_header_id;

Line: 449

    ** Get the defaults for the selected From RFQ number
    */
    SELECT poh.rfq_close_date,
           poh.type_lookup_code,
           poh.approval_required_flag
      INTO X_rfq_close_date,
           X_from_type_lookup_code,
           X_approval_required_flag
      FROM po_headers          poh
     WHERE poh.po_header_id = X_from_header_id;

Line: 497

  SELECT MAX('Y')
    INTO X_approval_status
    FROM po_quotation_approvals
   WHERE line_location_id = X_line_location_id
     AND sysdate BETWEEN nvl(start_date_active, sysdate-1)
     		 AND     nvl(end_date_active, sysdate+1);