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: 996


	      --signed revision fails as PDOI does not track action updates to
	      --PO_ACTION_HISTORY table.Instead of checking the revision at PO
	      --and disabling the deliverables at OKC,by this fix trying to disable
	      --the deliverables which are for those document revisions which is less
	      --than the current revision number -1.
               /*
               -- Bug 3652222 START
               IF g_fnd_debug = 'Y' then
                 PO_DEBUG.debug_stmt(g_module_prefix||l_api_name, '133',
		    'Before call Get_Last_Signed_Revision');

Line: 1134


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

Line: 1144


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

Line: 1153


                                   , VALUE => 'PO_CONTERMS_WF_PVT.UPDATE_CONTRACT_TERMS');

Line: 1177


		        p_procedure_name  =>'UPDATE_CONTRACT_TERMS');

Line: 1188


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

Line: 1210


END UPDATE_CONTRACT_TERMS;

Line: 1277


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

Line: 1311


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

Line: 1322


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

Line: 1328


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

Line: 1337


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

Line: 1355


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

Line: 1427


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

Line: 1460


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

Line: 1471


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

Line: 1477


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

Line: 1486


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

Line: 1504


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

Line: 1578


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

Line: 1611


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

Line: 1622


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

Line: 1628


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

Line: 1637


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

Line: 1655


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

Line: 1730


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

Line: 1763


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

Line: 1774


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

Line: 1780


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

Line: 1789


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

Line: 1807


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

Line: 1885


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

Line: 1920


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

Line: 1931


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

Line: 1937


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

Line: 1946


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

Line: 1964


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

Line: 2041


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

Line: 2076


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

Line: 2087


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

Line: 2093


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

Line: 2102


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

Line: 2120


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

Line: 2214


            SELECT revision_num
            INTO   l_bus_doc_version
            FROM   po_headers_all
            WHERE  po_header_id = p_bus_doc_id;