APPS.PO_MOD_UTIL_PVT SQL Statements

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

Line: 93

      SELECT category_id into l_category_id from fnd_document_categories
      where name = 'CUSTOM2446' ;

Line: 97

      FND_DOCUMENTS_PKG.Insert_Row(
                                   row_id_tmp,
                                   document_id_tmp,
                                   SYSDATE,
                                   1, --NVL(X_created_by,0),
                                   SYSDATE,
                                   1, --NVL(X_created_by,0),
                                   1, --X_last_update_login,
                                   6,
                                   l_category_id, --Get the value for the category id 'PO Documents'
                                   1, --null,--security_type,
                                   null, --security_id,
                                   'Y', --null,--publish_flag,
                                   null, --image_type,
                                   null, --storage_type,
                                   'O', --usage_type,
                                   sysdate, --start_date_active,
                                   null, --end_date_active,
                                   null,--X_request_id, --null
                                   null,--X_program_application_id, --null
                                   null, --X_program_id,--null
                                   SYSDATE,
                                   null, --language,
                                   null, --description,
                                   l_file_name,
                                   x_media_id);

Line: 126

      INSERT INTO fnd_lobs (
         file_id,
         File_name,
         file_content_type,
         upload_date,
         expiration_date,
         program_name,
         program_tag,
         file_data,
         language,
         oracle_charset,
         file_format)
         VALUES
          (x_media_id,
         l_file_name, -- Changed p_file_name to l_file_name
         l_file_content_type, -- Changed hardcoded value to l_file_content_type
         sysdate,
         null,
         null,
         null,
         l_blob_data,
         null,
         null,
               'binary');

Line: 153

      INSERT INTO fnd_attached_documents (attached_document_id,
      document_id,
      creation_date,
       created_by,
       last_update_date,
      last_updated_by,
        last_update_login,
      seq_num,
       entity_name,
      pk1_value,
       pk2_value,
      pk3_value,
      pk4_value,
       pk5_value,
      automatically_added_flag,
      program_application_id,
       program_id,
       program_update_date,
      request_id,
      attribute_category,
       attribute1,
      attribute2,
      attribute3,
      attribute4,
      attribute5,
      attribute6,
      attribute7,
      attribute8,
       attribute9,
       attribute10,
      attribute11,
      attribute12,
       attribute13,
      attribute14,
       attribute15,
       column1)
      VALUES
       (fnd_attached_documents_s.nextval,
      document_id_tmp,
      sysdate,
      1, --NVL(X_created_by,0),
      sysdate,
      1, --NVL(X_created_by,0),
      null,-- X_last_update_login,
      10,
       p_entity_name,
       pk1_value,
       pk2_value,
       pk3_value,
       pk4_value,
       pk5_value,
       'N',
      null,
      null,
      sysdate,
      null,
      null,
      null,
      null,
      null,
      null,
      null,
      null,
      null,
      null,
      null,
      null,
      null,
      null,
      null,
      null,
      null,
      null);

Line: 247

    SELECT file_data,file_content_type
    INTO   l_output,l_contenttype
    FROM
    (
    SELECT file_data,file_content_type
    from   fnd_attached_documents fad,
           fnd_documents fd,
           fnd_documents_tl fdl,
           fnd_lobs fl
    WHERE fdl.document_id = fad.document_id
    and   fd.document_id= fdl.document_id
    and   fd.media_id = fl.file_id
    and   fl.file_name LIKE l_filename
    and   fdl.language= p_language
    and   fad.pk1_value = p_draft_id
    and   fad.entity_name = p_entity_name
    ORDER BY file_id DESC)
    WHERE rownum = 1;

Line: 293

    UPDATE pon_auction_headers_all
    SET    CHANGEDESCRIPTION_DATA = p_changedescription,
           CD_EDITBYUSER_FLAG = p_editbyuserflag,
           CD_GENERATED_DATE = SYSDATE,
           CD_GENERATED_FLAG = p_changeDescGenerated,
	   CONCURRENT_REQID = NULL
    WHERE  auction_header_id=l_auction_header_id;

Line: 303

    UPDATE pon_auction_headers_all
    SET    CHANGEDESCRIPTION_DATA = p_changedescription,
           CD_EDITBYUSER_FLAG = p_editbyuserflag
    WHERE  auction_header_id=l_auction_header_id;

Line: 316

    UPDATE PO_DRAFTS
    SET    CHANGEDESCRIPTION_DATA = p_changedescription,
           CD_EDITBYUSER_FLAG = p_editbyuserflag,
           CD_GENERATED_DATE = SYSDATE,
           CD_GENERATED_FLAG = p_changeDescGenerated,
	   CONCURRENT_REQID = NULL
    WHERE  DRAFT_ID=l_dradt_id;

Line: 326

    UPDATE PO_DRAFTS
    SET    CHANGEDESCRIPTION_DATA = p_changedescription,
           CD_EDITBYUSER_FLAG = p_editbyuserflag
    WHERE  DRAFT_ID=l_dradt_id;

Line: 342

FUNCTION isDocUpdatedAfterCDGenerated(p_doc_id IN NUMBER,p_sourceApp IN VARCHAR)
RETURN varchar
IS
   l_count NUMBER;

Line: 346

   l_ismodupdated varchar2(1) := NULL;

Line: 349

   l_isAmendupdated varchar2(1) := NULL;

Line: 363

  SELECT MODUPDATED_AFTERCDGENERATED
  INTO l_ismodupdated
  FROM po_drafts WHERE draft_id = l_dradt_id;

Line: 367

  IF(l_ismodupdated IS NOT NULL) THEN
      RETURN l_ismodupdated;

Line: 370

    SELECT Count(*)
    INTO l_count
    FROM
    po_drafts
    WHERE draft_id = l_dradt_id
    AND CD_GENERATED_DATE IS NOT NULL
    AND po_core_s.get_last_update_date_for_mod(draft_id) > CD_GENERATED_DATE;

Line: 391

  SELECT AMENDUPDATED_AFTERCDGENERATED
  INTO l_isAmendupdated
  FROM pon_auction_headers_all WHERE auction_header_id = l_auction_header_id;

Line: 401

  IF(l_isAmendupdated IS NOT NULL) THEN
      RETURN l_isAmendupdated;

Line: 404

    SELECT Count(*)
    INTO l_count
    FROM pon_auction_headers_all
    WHERE auction_header_id = l_auction_header_id
    AND CD_GENERATED_DATE IS NOT NULL
    AND last_update_date > CD_GENERATED_DATE;

Line: 423

END isDocUpdatedAfterCDGenerated;

Line: 434

 SELECT AUCTION_HEADER_ID_PREV_AMEND
  INTO l_prv_auction_header_id
  FROM pon_auction_headers_all WHERE AUCTION_HEADER_ID = p_auction_hdr_id;

Line: 468

select       KAV.cat_id   ,
            KAB.article_version_id ,
            OAV.variable_code ,
            decode(validation_type,
                   'I', OKC_TERMS_UTIL_PVT.GET_VALUE_SET_VARIABLE_VALUE(validation_type, BVB.value_set_id, KAV.variable_value_id),
                   'N', Decode(FVS.format_type , 'X',to_char(To_Date(SubStr(KAV.variable_value,1,11), 'RRRR/MM/DD'),
                         nvl(FND_PROFILE.VALUE('ICX_DATE_FORMAT_MASK'),'DD-MON-RRRR'))  ,KAV.variable_value ),
     KAV.variable_value) as value

     from  okc_k_articles_b KAB ,
           okc_article_Variables OAV,
           okc_k_art_variables KAV,
           okc_bus_variables_b BVB,
           FND_FLEX_VALUE_SETS FVS
      where KAB.document_id = p_doc_id
             and KAB.document_type = p_doc_type
             and OAV.article_version_id = KAB.article_version_id
            and OAV.Variable_code = KAV.variable_code
             and BVB.variable_code = OAV.variable_code
             and BVB.variable_type = 'U'
             and BVB.variable_source = 'M'
             and KAV.cat_id = KAB.id
             and BVB.value_set_id = FVS.flex_value_set_id (+);

Line: 506

  insert into PO_OKC_VARS_GT(DOC_TYPE,
                              DOC_ID,
                              ARTICLE_VERSION_ID,
                              cat_id,
                              VARIABLE_CODE
                              ) (select kart.document_type, kart.document_id,  kart.article_version_id, var.cat_id, var.variable_code
          from okc_k_art_variables var, okc_k_articles_b kart
            where var.cat_id = kart.id
            and var.variable_type = 'S'
            and kart.document_type = p_mod_doc_type
            and kart.document_id = p_mod_doc_id);

Line: 519

      update PO_OKC_VARS_GT set VARIABLE_VALUE = p_sys_var_val_tbl(i).variable_value_id
      where doc_type = p_mod_doc_type
      and doc_id = p_mod_doc_id
      and variable_code = p_sys_var_val_tbl(i).variable_code;

Line: 536

         insert into PO_OKC_VARS_GT(DOC_TYPE,
                              DOC_ID,
                              ARTICLE_VERSION_ID,
                              cat_id,
                              VARIABLE_CODE
                              ) (select kart.document_type, kart.document_id,  kart.article_version_id, var.cat_id, var.variable_code
          from okc_k_art_variables var, okc_k_articles_b kart
            where var.cat_id = kart.id
            and var.variable_type = 'S'
            and kart.document_type = p_base_doc_type
            and kart.document_id = p_base_doc_id);

Line: 549

              update PO_OKC_VARS_GT set VARIABLE_VALUE = p_bsys_var_val_tbl(i).variable_value_id
              where doc_type = p_base_doc_type
              and doc_id = p_base_doc_id
              and variable_code = p_bsys_var_val_tbl(i).variable_code;

Line: 564

    insert into PO_OKC_VARS_GT(DOC_TYPE,
                              DOC_ID,
                              ARTICLE_VERSION_ID,
                              cat_id,
                              VARIABLE_CODE,
                              VARIABLE_VALUE)
                values(p_mod_doc_type,
                        p_mod_doc_id,
                        t_artVerId(i),
                        t_catId(i),
                        t_varCode(i),
                        t_varval(i));

Line: 585

    insert into PO_OKC_VARS_GT(DOC_TYPE,
                              DOC_ID,
                              ARTICLE_VERSION_ID,
                              cat_id,
                              VARIABLE_CODE,
                              VARIABLE_VALUE)
                values(p_base_doc_type,
                        p_base_doc_id,
                        t_artVerId(i),
                        t_catId(i),
                        t_varCode(i),
                        t_varval(i));