eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PO_CONTERMS_WF_PVT SQL Statements

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

Line: 48


   PO_WF_DEBUG_PKG.INSERT_DEBUG(ITEMTYPE, ITEMKEY,
            '10: Start show error');

Line: 50


   PO_WF_DEBUG_PKG.INSERT_DEBUG(ITEMTYPE, ITEMKEY,
            '20:Return status for '||p_api_name||':'||p_return_status);

Line: 53


      PO_WF_DEBUG_PKG.INSERT_DEBUG(ITEMTYPE, ITEMKEY,
            (20+i)||':Error-'||FND_MSG_PUB.Get(p_msg_index=>i,p_encoded =>'F' ));

Line: 56


   PO_WF_DEBUG_PKG.INSERT_DEBUG(ITEMTYPE, ITEMKEY,
            '100: End show error');

Line: 100


	    PO_WF_DEBUG_PKG.INSERT_DEBUG(ITEMTYPE, ITEMKEY,
  		                      '10:Start get_wf_params ');

Line: 119


	    PO_WF_DEBUG_PKG.INSERT_DEBUG(ITEMTYPE, ITEMKEY,
  		                      '30:po_header_id = '|| to_char(x_po_header_id));

Line: 121


	    PO_WF_DEBUG_PKG.INSERT_DEBUG(ITEMTYPE, ITEMKEY,
  		                     '40:po doc type= '|| x_po_doc_type);

Line: 123


	    PO_WF_DEBUG_PKG.INSERT_DEBUG(ITEMTYPE, ITEMKEY,
  		                     '50:po sub type= '|| x_po_doc_subtype);

Line: 125


        PO_WF_DEBUG_PKG.INSERT_DEBUG(ITEMTYPE, ITEMKEY,
  		                     '100:End get_wf_params ');

Line: 196


        SELECT start_date,
           end_date,
           revision_num
        INTO
           l_po_start_date,
           l_po_end_date,
           l_po_revision_num

        FROM po_headers_all
        WHERE po_header_id = p_po_header_id;

Line: 211


                              MESSAGE  =>'30: After Select.po found');

Line: 223


        ELSIF (p_action_code = 'U') then -- If call is for update of deliverables
              --SQL WHAT: Selects start date and end date from archive table for
              --          last but one archival since this is always called after
              --          archive of PO, the latest will have same value as working copy
              --SQL WHY: These values are used to send changed dates for update deliverables
              --SQl Join:None
              SELECT start_date,
                     end_date
              INTO
                   l_archive_start_date,
                   l_archive_end_date
              FROM po_headers_archive_all
              WHERE po_header_id = p_po_header_id
               AND  revision_num = (l_po_revision_num-1);

Line: 322


    PO_WF_DEBUG_PKG.INSERT_DEBUG(ITEMTYPE, ITEMKEY,
      '10: Start function contract_terms_Changed ');

Line: 351


       PO_WF_DEBUG_PKG.INSERT_DEBUG(ITEMTYPE, ITEMKEY,
                             '120:Previous version does not have terms');

Line: 366


       PO_WF_DEBUG_PKG.INSERT_DEBUG(ITEMTYPE, ITEMKEY,
                 '130: Return status before the call'||l_return_status);

Line: 368


       PO_WF_DEBUG_PKG.INSERT_DEBUG(ITEMTYPE, ITEMKEY,
                 '132: Call OKC_TERMS_UTIL_GRP.contract_terms_amended');

Line: 381


       PO_WF_DEBUG_PKG.INSERT_DEBUG(ITEMTYPE, ITEMKEY,
              '135: Return status  after call to CONTRACT_TERMS_AMENDED'||l_return_status);

Line: 392


           PO_WF_DEBUG_PKG.INSERT_DEBUG(ITEMTYPE, ITEMKEY,
                              '138: K contract terms changed: N'||l_k_terms_changed);

Line: 401


           PO_WF_DEBUG_PKG.INSERT_DEBUG(ITEMTYPE, ITEMKEY,
                    '140: Return status Before the call'||l_return_status);

Line: 403


           PO_WF_DEBUG_PKG.INSERT_DEBUG(ITEMTYPE, ITEMKEY,
                            '142:  Call OKC_TERMS_UTIl_GRP.IS_ARTICLE_AMENDED');

Line: 416


           PO_WF_DEBUG_PKG.INSERT_DEBUG(ITEMTYPE, ITEMKEY,
                '150: Return status  after call to IS_ARTICLE_AMENDED'||l_return_status);

Line: 425


               PO_WF_DEBUG_PKG.INSERT_DEBUG(ITEMTYPE, ITEMKEY,
                       '155: K Articles changed: N'||l_k_terms_changed);

Line: 427


               PO_WF_DEBUG_PKG.INSERT_DEBUG(ITEMTYPE, ITEMKEY,
                       '160:  Call OKC_TERMS_UTIl_GRP.Is_Deliverable_Amended');

Line: 429


               PO_WF_DEBUG_PKG.INSERT_DEBUG(ITEMTYPE, ITEMKEY,
                       '162: Return status Before the call'||l_return_status);

Line: 443


               PO_WF_DEBUG_PKG.INSERT_DEBUG(ITEMTYPE, ITEMKEY,
                       '165: Return status  after call to Is_Deliverable_Amended'||l_return_status);

Line: 451


                   PO_WF_DEBUG_PKG.INSERT_DEBUG(ITEMTYPE, ITEMKEY,
                           '170: K Deliverables changed: N'||l_k_terms_changed);

Line: 458


                   PO_WF_DEBUG_PKG.INSERT_DEBUG(ITEMTYPE, ITEMKEY,
                          '175:K deliverables Changed: Y'||l_k_terms_changed);

Line: 470


               PO_WF_DEBUG_PKG.INSERT_DEBUG(ITEMTYPE, ITEMKEY,
                                 '180:K Terms Changed: Y'||l_k_terms_changed);

Line: 486


           PO_WF_DEBUG_PKG.INSERT_DEBUG(ITEMTYPE, ITEMKEY,
                          '190:K Contract terms Changed: Y'||l_k_terms_changed);

Line: 500


       PO_WF_DEBUG_PKG.INSERT_DEBUG(ITEMTYPE, ITEMKEY,
                                 '120:Not a Procurement contract');

Line: 507


     PO_WF_DEBUG_PKG.INSERT_DEBUG(ITEMTYPE, ITEMKEY,
  		'200 End:  contract_terms_Changed ');

Line: 518


    PO_WF_DEBUG_PKG.INSERT_DEBUG(ITEMTYPE, ITEMKEY,
        '250: End contracts_call_exception: contract_terms_Changed ');

Line: 530


    PO_WF_DEBUG_PKG.INSERT_DEBUG(ITEMTYPE, ITEMKEY,
         '300: End IN Exception: contract_terms_Changed ');

Line: 575


PROCEDURE UPDATE_CONTERMS_DATES(p_po_header_id        IN NUMBER,
                             p_po_doc_type         IN VARCHAR2,
                             p_po_doc_subtype      IN VARCHAR2,
                             p_conterms_exist_flag IN VARCHAR2,
    		                 x_return_status       OUT NOCOPY VARCHAR2,
                             x_msg_data            OUT NOCOPY VARCHAR2,
                             x_msg_count           OUT NOCOPY NUMBER
                             ) IS

   l_articles_upd_date   DATE;

Line: 588


   l_api_name          CONSTANT VARCHAR(30) := 'UPDATE_CONTERMS_DATES';

Line: 596


                      MESSAGE  =>'10: Start UPDATE_CONTERMS_DATES');

Line: 622


         l_k_api_name:='OKC_TERMS_UTIl_GRP.Get_Last_Update_Date';

Line: 627


                              MESSAGE  =>'70: Before call to OKC_TERMS_UTIl_GRP.Get_Last_Update_Date');

Line: 630


         OKC_TERMS_UTIl_GRP.Get_Last_Update_Date(
                          p_api_version              => 1.0,
                          p_doc_id                   => p_po_header_id,
                          p_doc_type                 => PO_CONTERMS_UTL_GRP.Get_Po_Contract_Doctype(p_po_doc_subtype),
                          x_deliverable_changed_date => l_deliv_upd_date,
                          x_terms_changed_date       => l_articles_upd_date,
                          x_return_status            => x_return_status,
                          x_msg_data                 => x_msg_data,
                          x_msg_count                => x_msg_count);

Line: 643


                              MESSAGE  =>'80: After call to OKC_...Get_Last_Update_Date. Status'||x_return_status);

Line: 671


                              MESSAGE  =>'120: Before update of dates in po headers'||l_deliv_upd_date);

Line: 677


       UPDATE PO_HEADERS_ALL
          SET conterms_articles_upd_date      = l_articles_upd_date,
              conterms_deliv_upd_date         = l_deliv_upd_date,
              last_updated_by                 = FND_GLOBAL.user_id,
              last_update_login               = FND_GLOBAL.login_id,
              last_update_date                = sysdate
        WHERE po_header_id = p_po_header_id;

Line: 688


                              MESSAGE  =>'200: End: UPDATE_CONTERMS_DATES');

Line: 700


                              MESSAGE  =>'300: End Update_conTerms_dates.In Exception l_Contracts_call_exception');

Line: 710


                                   , VALUE => 'PO_CONTERMS_WF_PVT.UPDATE_CONTERMS_DATES');

Line: 732


                             MESSAGE  =>'400: End Update_conTerms_dates.In Exception OTHERS');

Line: 742


		        p_procedure_name  =>'UPDATE_CONTERMS_DATES');

Line: 762


END UPDATE_CONTERMS_DATES;

Line: 797


PROCEDURE UPDATE_CONTRACT_TERMS(p_po_header_id        IN NUMBER,
                                p_signed_date         IN DATE,
    		                    x_return_status       OUT NOCOPY VARCHAR2,
                                x_msg_data            OUT NOCOPY VARCHAR2,
                                x_msg_count           OUT NOCOPY NUMBER) IS

   l_conterms_exist_flag  PO_HEADERS_ALL.CONTERMS_EXIST_FLAG%TYPE;

Line: 813


   l_api_name          CONSTANT VARCHAR(30) := 'UPDATE_CONTRACT_TERMS';

Line: 824


                              MESSAGE  =>'10: Start: UPDATE_CONTRACT_TERMS');

Line: 832


    SELECT conterms_exist_flag,
           type_lookup_code,
           revision_num,
           cancel_flag,
           DECODE(type_lookup_code, 'STANDARD', 'PO', 'BLANKET', 'PA', 'CONTRACT', 'PA', NULL)
    INTO   l_conterms_exist_flag,
           l_po_doc_subtype,
           l_po_revision_num,
           l_cancel_flag,
           l_po_doc_type
    FROM po_headers_all
    WHERE po_header_id = p_po_header_id;

Line: 849


                              MESSAGE  =>'30: After Select. Conterms Exist'||l_conterms_exist_flag);

Line: 940


               l_k_api_name:='OKC_MANAGE_DELIVERABLES_GRP.updateDeliverables';

Line: 945


                              MESSAGE  =>'100:Count-event codes passed for OKC_MANAGE_DELIVERABLES_GRP.updateDeliverables:'||l_event_tbl.count);

Line: 962


                                    MESSAGE  =>'110: Before call to OKC_MANAGE_DELIVERABLES_GRP.updateDeliverables');

Line: 966


                  OKC_MANAGE_DELIVERABLES_GRP.updateDeliverables (
                      p_api_version                 => 1.0,
                      p_bus_doc_id                  => p_po_header_id,
                      p_bus_doc_type                => PO_CONTERMS_UTL_GRP.Get_Po_Contract_Doctype(l_po_doc_subtype),
                      p_bus_doc_version             => l_po_revision_num,
                      p_bus_doc_date_events_tbl     => l_event_tbl,
                      x_msg_data                    => x_msg_data,
                      x_msg_count                   => x_msg_count,
                      x_return_status               => x_return_status);

Line: 979


                                   MESSAGE  =>'120: After call to OKC_MANAGE_DELIVERABLES_GRP.updateDeliverables');

Line: 1115


                              MESSAGE  =>'210: End Update Contract Terms');

Line: 1125


                              MESSAGE  =>'300: End Update_contract Terms.In Exception l_Contracts_call_exception');

Line: 1134


                                   , VALUE => 'PO_CONTERMS_WF_PVT.UPDATE_CONTRACT_TERMS');

Line: 1158


		        p_procedure_name  =>'UPDATE_CONTRACT_TERMS');

Line: 1169


                              MESSAGE  =>'400: End Update_contract_terms.In Exception others');

Line: 1191


END UPDATE_CONTRACT_TERMS;

Line: 1258


              PO_WF_DEBUG_PKG.INSERT_DEBUG(ITEMTYPE, ITEMKEY,
  		                 '10: Start function IS_STANDARD_CONTRACT ');

Line: 1292


                        PO_WF_DEBUG_PKG.INSERT_DEBUG(ITEMTYPE, ITEMKEY,
                                 '100: returned value from Contracts'||result);

Line: 1303


                 PO_WF_DEBUG_PKG.INSERT_DEBUG(ITEMTYPE, ITEMKEY,
                                 '140:Not a Procurement contract');

Line: 1309


        PO_WF_DEBUG_PKG.INSERT_DEBUG(ITEMTYPE, ITEMKEY,
  		'200 End:  IS_STANDARD_CONTRACT ');

Line: 1318


                    PO_WF_DEBUG_PKG.INSERT_DEBUG(ITEMTYPE, ITEMKEY,
  		                  '250: End contracts_call_exception: IS_STANDARD_CONTRACT ');

Line: 1336


             PO_WF_DEBUG_PKG.INSERT_DEBUG(ITEMTYPE, ITEMKEY,
  		         '300: End IN Exception: IS_STANDARD_CONTRACT ');

Line: 1408


              PO_WF_DEBUG_PKG.INSERT_DEBUG(ITEMTYPE, ITEMKEY,
  		                 '10: Start function IS_CONTRACT_TEMPLATE_EXPIRED ');

Line: 1441


                        PO_WF_DEBUG_PKG.INSERT_DEBUG(ITEMTYPE, ITEMKEY,
                                 '100: returned value from Contracts'||result);

Line: 1452


                 PO_WF_DEBUG_PKG.INSERT_DEBUG(ITEMTYPE, ITEMKEY,
                                 '140:Not a Procurement contract');

Line: 1458


        PO_WF_DEBUG_PKG.INSERT_DEBUG(ITEMTYPE, ITEMKEY,
  		'200 End:  IS_CONTRACT_TEMPLATE_EXPIRED ');

Line: 1467


                    PO_WF_DEBUG_PKG.INSERT_DEBUG(ITEMTYPE, ITEMKEY,
  		                  '250: End contracts_call_exception: IS_CONTRACT_TEMPLATE_EXPIRED ');

Line: 1485


             PO_WF_DEBUG_PKG.INSERT_DEBUG(ITEMTYPE, ITEMKEY,
  		         '300: End IN Exception: IS_CONTRACT_TEMPLATE_EXPIRED ');

Line: 1559


              PO_WF_DEBUG_PKG.INSERT_DEBUG(ITEMTYPE, ITEMKEY,
  		                 '10: Start function IS_CONTRACT_ARTICLES_EXIST ');

Line: 1592


                        PO_WF_DEBUG_PKG.INSERT_DEBUG(ITEMTYPE, ITEMKEY,
                                 '100: returned value from Contracts'||result);

Line: 1603


                 PO_WF_DEBUG_PKG.INSERT_DEBUG(ITEMTYPE, ITEMKEY,
                                 '140:Not a Procurement contract');

Line: 1609


        PO_WF_DEBUG_PKG.INSERT_DEBUG(ITEMTYPE, ITEMKEY,
  		'200 End:  IS_CONTRACT_ARTICLES_EXIST ');

Line: 1618


                    PO_WF_DEBUG_PKG.INSERT_DEBUG(ITEMTYPE, ITEMKEY,
  		                  '250: End contracts_call_exception: IS_CONTRACT_ARTICLES_EXIST ');

Line: 1636


             PO_WF_DEBUG_PKG.INSERT_DEBUG(ITEMTYPE, ITEMKEY,
  		         '300: End IN Exception: IS_CONTRACT_ARTICLES_EXIST ');

Line: 1711


              PO_WF_DEBUG_PKG.INSERT_DEBUG(ITEMTYPE, ITEMKEY,
  		                 '10: Start function IS_CONTRACT_ARTICLES_AMENDED');

Line: 1744


                        PO_WF_DEBUG_PKG.INSERT_DEBUG(ITEMTYPE, ITEMKEY,
                                 '100: returned value from Contracts'||result);

Line: 1755


                 PO_WF_DEBUG_PKG.INSERT_DEBUG(ITEMTYPE, ITEMKEY,
                                 '140:Not a Procurement contract');

Line: 1761


        PO_WF_DEBUG_PKG.INSERT_DEBUG(ITEMTYPE, ITEMKEY,
  		'200 End:  IS_CONTRACT_ARTICLES_AMENDED ');

Line: 1770


                    PO_WF_DEBUG_PKG.INSERT_DEBUG(ITEMTYPE, ITEMKEY,
  		                  '250: End contracts_call_exception: IS_CONTRACT_ARTICLES_AMENDED ');

Line: 1788


             PO_WF_DEBUG_PKG.INSERT_DEBUG(ITEMTYPE, ITEMKEY,
  		         '300: End IN Exception: IS_CONTRACT_ARTICLES_AMENDED ');

Line: 1866


              PO_WF_DEBUG_PKG.INSERT_DEBUG(ITEMTYPE, ITEMKEY,
  		                 '10: Start function IS_CONTRACT_DELIVRABLS_EXIST');

Line: 1901


                        PO_WF_DEBUG_PKG.INSERT_DEBUG(ITEMTYPE, ITEMKEY,
                                 '100: returned value from Contracts'||result);

Line: 1912


                 PO_WF_DEBUG_PKG.INSERT_DEBUG(ITEMTYPE, ITEMKEY,
                                 '140:Not a Procurement contract');

Line: 1918


        PO_WF_DEBUG_PKG.INSERT_DEBUG(ITEMTYPE, ITEMKEY,
  		'200 End:  IS_CONTRACT_DELIVRABLS_EXIST ');

Line: 1927


                    PO_WF_DEBUG_PKG.INSERT_DEBUG(ITEMTYPE, ITEMKEY,
  		                  '250: End contracts_call_exception: IS_CONTRACT_DELIVRABLS_EXIST ');

Line: 1945


             PO_WF_DEBUG_PKG.INSERT_DEBUG(ITEMTYPE, ITEMKEY,
  		         '300: End IN Exception: IS_CONTRACT_DELIVRABLS_EXIST ');

Line: 2022


              PO_WF_DEBUG_PKG.INSERT_DEBUG(ITEMTYPE, ITEMKEY,
  		                 '10: Start function IS_CONTRACT_ARTICLES_AMENDED');

Line: 2057


                        PO_WF_DEBUG_PKG.INSERT_DEBUG(ITEMTYPE, ITEMKEY,
                                 '100: returned value from Contracts'||result);

Line: 2068


                 PO_WF_DEBUG_PKG.INSERT_DEBUG(ITEMTYPE, ITEMKEY,
                                 '140:Not a Procurement contract');

Line: 2074


        PO_WF_DEBUG_PKG.INSERT_DEBUG(ITEMTYPE, ITEMKEY,
  		'200 End:  IS_CONTRACT_DELIVRABLS_AMENDED ');

Line: 2083


                    PO_WF_DEBUG_PKG.INSERT_DEBUG(ITEMTYPE, ITEMKEY,
  		                  '250: End contracts_call_exception: IS_CONTRACT_DELIVRABLS_AMENDED ');

Line: 2101


             PO_WF_DEBUG_PKG.INSERT_DEBUG(ITEMTYPE, ITEMKEY,
  		         '300: End IN Exception: IS_CONTRACT_DELIVRABLS_AMENDED ');

Line: 2195


            SELECT revision_num
            INTO   l_bus_doc_version
            FROM   po_headers_all
            WHERE  po_header_id = p_bus_doc_id;