APPS.CS_EXP_TERMINATE_PVT SQL Statements

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

Line: 141

						 p_to.Last_Update_Date,
						 p_to.Last_Updated_By,
						 p_to.Last_Update_Login);

Line: 197

   SELECT
           CONTRACT_ID                    ,
           CONTRACT_NUMBER                ,
           PRICE_LIST_ID                  ,
           CURRENCY_CODE                  ,
           INVOICING_RULE_ID              ,
           ACCOUNTING_RULE_ID             ,
           BILL_TO_SITE_USE_ID            ,
           CONTRACT_STATUS_ID             ,
           CONTRACT_TYPE_ID               ,
           CUSTOMER_ID                    ,
           DURATION                       ,
           PERIOD_CODE                    ,
           START_DATE_ACTIVE              ,
           END_DATE_ACTIVE                ,
           AGREEMENT_ID                   ,
           BILLING_FREQUENCY_PERIOD       ,
           BILL_ON                        ,
           FIRST_BILL_DATE                ,
           NEXT_BILL_DATE                 ,
           SALESPERSON_ID                 ,
           ORDERED_BY_CONTACT_ID          ,
           CONTRACT_TEMPLATE_ID           ,
           CONTRACT_GROUP_ID              ,
           WORKFLOW                       ,
           WORKFLOW_PROCESS_ID            ,
           CREATE_SALES_ORDER             ,
           SHIP_TO_SITE_USE_ID            ,
           RENEWAL_RULE                   ,
           TERMINATION_RULE               ,
           CONVERSION_TYPE_CODE           ,
           CONVERSION_RATE                ,
           CONVERSION_DATE                ,
           SOURCE_CODE                    ,
           SOURCE_REFERENCE               ,
           TERMS_ID                       ,
           PO_NUMBER                      ,
           TAX_HANDLING                   ,
           TAX_EXEMPT_NUM                 ,
           TAX_EXEMPT_REASON_CODE         ,
           CONTRACT_AMOUNT                ,
           AUTO_RENEWAL_FLAG              ,
           ORIGINAL_END_DATE              ,
           TERMINATE_REASON_CODE          ,
           DISCOUNT_ID                    ,
           ATTRIBUTE1                     ,
           ATTRIBUTE2                     ,
           ATTRIBUTE3                     ,
           ATTRIBUTE4                     ,
           ATTRIBUTE5                     ,
           ATTRIBUTE6                     ,
           ATTRIBUTE7                     ,
           ATTRIBUTE8                     ,
           ATTRIBUTE9                     ,
           ATTRIBUTE10                    ,
           ATTRIBUTE11                    ,
           ATTRIBUTE12                    ,
           ATTRIBUTE13                    ,
           ATTRIBUTE14                    ,
           ATTRIBUTE15                    ,
           CONTEXT                        ,
           OBJECT_VERSION_NUMBER          ,
           PO_REQUIRED_TO_SERVICE         ,
           PRE_PAYMENT_REQUIRED
    FROM   CS_CONTRACTS
where exp_term_date < cs_contracts.end_date_active
AND cs_contracts.next_bill_date IS NULL;

Line: 282

	select count(*) into v_counter
	from cs_cp_services_all, cs_cp_service_transactions
	where lcontract_rec.contract_id = cs_cp_services_all.contract_id
	and cs_cp_services_all.cp_service_id = cs_cp_service_transactions.cp_service_id;

Line: 298

          FND_FILE.PUT_LINE(FND_FILE.LOG,'Update unsuccessful : The v_return_status is NULL');

Line: 312

  CS_CONTRACT_PVT.Update_Row
  (
    p_api_version                  => 1.0,
    p_init_msg_list                => 'T',
    p_validation_level             => 0,
    p_commit                       => 'T',
    x_return_status                => v_return_status,
    x_msg_count                    => v_msg_count,
    x_msg_data                     => v_msg_data,
    p_contract_val_rec             => contract_rec,
    x_object_version_number        => v_object_version_number
  );

Line: 332

          		FND_FILE.PUT_LINE(FND_FILE.LOG,'Update unsuccessful : The v_return_status is' || v_return_status);

Line: 338

          		FND_FILE.PUT_LINE( FND_FILE.LOG, 'Update successfully completed' );