APPS.PO_CLM_CLO_UTIL SQL Statements

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

Line: 139

      SELECT  Nvl(clm_info_flag,'N'),clm_funded_flag
      INTO    x_clm_info_flag, x_clm_funded_flag
      FROM   po_lines_merge_v
      WHERE  po_line_id = p_line_id AND draft_id = -1;

Line: 144

      SELECT  Nvl(clm_info_flag,'N'),clm_funded_flag
      INTO    x_clm_info_flag, x_clm_funded_flag
      FROM   po_requisition_lines_all
      WHERE  requisition_line_id = p_line_id;

Line: 149

       SELECT  Nvl(clm_info_flag,'N'),clm_funded_flag
       INTO   x_clm_info_flag, x_clm_funded_flag
       FROM   pon_auction_item_prices_all
             WHERE  line_number = p_line_id
             AND auction_header_id = p_document_id;

Line: 157

        SELECT Nvl(clm_info_flag,'N'),clm_funded_flag
         INTO   x_clm_info_flag, x_clm_funded_flag
        FROM   pon_bid_item_prices
        WHERE  BID_NUMBER = p_line_id
        AND auction_header_id = p_document_id;

Line: 178

      SELECT LINE_NUM        --line_num_display
      INTO    l_line_num
      FROM   po_lines_merge_v
      WHERE  po_line_id = p_line_id AND draft_id = -1;

Line: 183

      SELECT  LINE_NUM
      INTO     l_line_num
      FROM   po_requisition_lines_all
      WHERE  requisition_line_id = p_line_id;

Line: 188

       /*SELECT LINE_NUM_DISPLAY
       INTO   l_line_num
       FROM   pon.pon_auction_item_prices_all
             WHERE  line_number = p_line_id
             AND auction_header_id = p_document_id;*/

Line: 196

       /* SELECT LINE_NUM_DISPLAY
         INTO   l_line_num
        FROM   pon_bid_item_prices
        WHERE  BID_NUMBER = p_line_id
        AND auction_header_id = p_document_id;*/

Line: 221

      SELECT 'Y'
      INTO   l_flag
      FROM   dual
      WHERE  EXISTS (SELECT 'x'
                         FROM   po_lines_merge_v
                         WHERE  CLM_BASE_LINE_NUM = p_line_id AND draft_id = -1
                         AND PO_HEADER_ID=Nvl(p_document_id,PO_HEADER_ID));

Line: 231

      SELECT 'Y'
      INTO   l_flag
      FROM   dual
      WHERE  EXISTS (SELECT 'x'
                         FROM   po_requisition_lines_all
                         WHERE  CLM_BASE_LINE_NUM = p_line_id
                         AND    REQUISITION_HEADER_ID=Nvl(p_document_id,REQUISITION_HEADER_ID));

Line: 240

      SELECT 'Y'
      INTO   l_flag
      FROM   dual
      WHERE  EXISTS (SELECT 'x'
                         FROM   pon_auction_item_prices_all
                         WHERE  1=1
                         AND CLM_BASE_LINE_NUM = p_line_id
                         AND auction_header_id = p_document_id);

Line: 251

      /*SELECT 'Y'
      INTO   l_flag
      FROM   dual
      WHERE  EXISTS (SELECT 'x'
                         FROM   pon_bid_item_prices
                         WHERE  CLM_BASE_LINE_NUM = p_line_id
                                AND auction_header_id = p_document_id);*/

Line: 280

      SELECT 'Y'
      INTO   l_flag
      FROM   dual
      WHERE  NOT EXISTS (SELECT 'x'
                         FROM   po_lines_merge_v
                         WHERE  group_line_id = p_line_id AND draft_id = -1);

Line: 289

      SELECT 'Y'
      INTO   l_flag
      FROM   dual
      WHERE  NOT EXISTS (SELECT 'x'
                         FROM   po_requisition_lines_all
                         WHERE  group_line_id = p_line_id);

Line: 300

      SELECT 'Y'
      INTO   l_flag
      FROM   dual
      WHERE  NOT EXISTS (SELECT 'x'
                         FROM   pon_auction_item_prices_all
                         WHERE  group_line_id = p_line_id
                                AND auction_header_id = p_document_id);

Line: 311

      SELECT 'Y'
      INTO   l_flag
      FROM   dual
      WHERE  NOT EXISTS (SELECT 'x'
                         FROM   pon_bid_item_prices
                         WHERE  bid_number = p_document_id
                         AND    group_line_id = p_line_id);

Line: 339

      SELECT group_line_id
      INTO   l_group_line_id
      FROM   po_lines_merge_v
      WHERE  po_line_id = p_group_line_id AND draft_id = -1;

Line: 344

      SELECT group_line_id
      INTO   l_group_line_id
      FROM   po_requisition_lines_all
      WHERE  requisition_line_id = p_group_line_id;

Line: 349

      SELECT group_line_id
      INTO   l_group_line_id
      FROM   pon_auction_item_prices_all
      WHERE  auction_header_id = p_document_id
             AND line_number = p_group_line_id;

Line: 355

      SELECT group_line_id
      INTO   l_group_line_id
      FROM   pon_bid_item_prices
      WHERE  auction_header_id = p_document_id
             AND bid_number = p_group_line_id;

Line: 390

    SELECT NVL(CLM_FLAG, 'N')
    INTO   x_enabled_flag
    FROM   PO_DOC_STYLE_HEADERS
    WHERE  STYLE_ID =  p_document_style_id;

Line: 747

     SELECT Nvl(employee_id,-999) INTO p_emp_id FROM fnd_user WHERE user_id = p_user_id;

Line: 765

         return ' EXISTS (SELECT REF.STYLE_ID FROM PO_DOC_STYLE_HEADERS REF WHERE
                  REF.STYLE_ID = PO_HEADERS_ALL_SEC.STYLE_ID AND REF.CLM_FLAG=''Y'') ';

Line: 768

         return ' EXISTS (SELECT REF.STYLE_ID FROM PO_DOC_STYLE_HEADERS REF WHERE
                  REF.STYLE_ID = PO_HEADERS_ALL_SEC.STYLE_ID AND NVL(REF.CLM_FLAG,''N'') = ''N'') ';

Line: 792

     SELECT Nvl(employee_id,-999) INTO p_emp_id FROM fnd_user WHERE user_id = p_user_id;

Line: 845

     SELECT Nvl(employee_id,-999) INTO p_emp_id FROM fnd_user WHERE user_id = p_user_id;

Line: 863

           return ' EXISTS (SELECT POH.PO_HEADER_ID FROM PO_HEADERS_ALL_SEC POH
                    WHERE POH.PO_HEADER_ID = OKC_DELIVERABLES_SEC.BUSINESS_DOCUMENT_ID) ';

Line: 866

           return ' exists ( SELECT PAH.AUCTION_HEADER_ID FROM PON_AUCTION_HEADERS_ALL PAH
                    WHERE PAH.AUCTION_HEADER_ID = OKC_DELIVERABLES_SEC.BUSINESS_DOCUMENT_ID) ';

Line: 894

   SELECT line_num_display,group_line_id
   INTO  l_from_disp_line_num,l_from_group_line_id
   FROM pon_auction_item_prices_all
   WHERE line_number = p_from_line_id
   AND auction_header_id = p_document_id;

Line: 901

   SELECT line_num_display,group_line_id
   INTO  l_to_disp_line_num ,l_to_group_line_id
   FROM pon_auction_item_prices_all
   WHERE line_number = p_to_line_id
   AND auction_header_id = p_document_id;

Line: 908

    SELECT line_num_display
    INTO l_succ_line_id
    FROM

      (SELECT line_num_display
      FROM pon_auction_item_prices_all
      WHERE auction_header_id = p_document_id
      AND Nvl(l_from_GROUP_LINE_ID,-1) = Nvl(GROUP_LINE_ID,-1)
      AND line_num_display > l_from_disp_line_num

      ORDER BY line_num_display)

    WHERE  ROWNUM = 1;

Line: 932

    SELECT line_num_display
    INTO l_pred_line_id
    FROM

      (SELECT line_num_display
      FROM pon_auction_item_prices_all
      WHERE auction_header_id = p_document_id
      AND Nvl(l_from_GROUP_LINE_ID,-1) = Nvl(group_line_id,-1)
      AND line_num_display < l_from_disp_line_num

      ORDER BY line_num_display DESC)

    WHERE  ROWNUM = 1;

Line: 974

   SELECT line_num_display,group_line_id
   INTO  l_from_disp_line_num,l_from_group_line_id
   FROM  pon_bid_item_prices
   WHERE bid_number = p_document_id
   AND   line_number = p_from_line_id
   AND   auction_line_number = -1;

Line: 982

   SELECT line_num_display,group_line_id
   INTO   l_to_disp_line_num ,l_to_group_line_id
   FROM   pon_bid_item_prices
   WHERE bid_number = p_document_id
   AND   line_number = p_to_line_id
   AND   auction_line_number = -1;

Line: 990

    SELECT line_num_display
    INTO l_succ_line_id
    FROM

      (SELECT line_num_display
      FROM pon_bid_item_prices
      WHERE bid_number = p_document_id
      AND auction_line_number = -1
      AND Nvl(l_from_GROUP_LINE_ID,-1) = Nvl(GROUP_LINE_ID,-1)
      AND line_num_display > l_from_disp_line_num

      ORDER BY line_num_display)

    WHERE  ROWNUM = 1;

Line: 1015

    SELECT line_num_display
    INTO l_pred_line_id
    FROM

      (SELECT line_num_display
      FROM pon_bid_item_prices
      WHERE bid_number = p_document_id
      AND auction_line_number = -1
      AND Nvl(l_from_GROUP_LINE_ID,-1) = Nvl(group_line_id,-1)
      AND line_num_display < l_from_disp_line_num

      ORDER BY line_num_display DESC)

    WHERE  ROWNUM = 1;