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.CN_PMTPLAN_PUB SQL Statements

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

Line: 20


      L_LAST_UPDATE_DATE          DATE    := sysdate;

Line: 21


      L_LAST_UPDATED_BY           NUMBER  := fnd_global.user_id;

Line: 24


      L_LAST_UPDATE_LOGIN         NUMBER  := fnd_global.login_id;

Line: 30


	 SELECT pmt_plan_id
	   FROM cn_pmt_plans
	   WHERE name = p_PmtPlan_rec.name
	   AND start_date = p_PmtPlan_rec.start_date
	   AND end_date = p_PmtPlan_rec.end_date
	   AND org_id = p_PmtPlan_rec.org_id;

Line: 39


	 SELECT pmt_plan_id
	   FROM cn_pmt_plans
	   WHERE name = p_PmtPlan_rec.name
	   AND start_date = p_PmtPlan_rec.start_date
	   AND org_id = p_PmtPlan_rec.org_id;

Line: 63


         SELECT cn_pmt_plans_s.nextval
           INTO x_pmt_plan_id
           FROM dual;

Line: 78


         SELECT cn_pmt_plans_s.nextval
           INTO x_pmt_plan_id
           FROM dual;

Line: 209


PROCEDURE  Update_PmtPlan (
			       p_api_version		IN 	NUMBER,
			       p_init_msg_list		IN	VARCHAR2,
			       p_commit	    		IN  	VARCHAR2,
			       p_validation_level		IN  	NUMBER,
			       x_return_status        OUT NOCOPY 	VARCHAR2,
			       x_msg_count	         OUT NOCOPY 	NUMBER,
			       x_msg_data		 OUT NOCOPY 	VARCHAR2,
			       p_old_PmtPlan_rec          IN      PmtPlan_rec_type,
			       p_PmtPlan_rec              IN  OUT NOCOPY    PmtPlan_rec_type,
			       x_status             OUT NOCOPY 	VARCHAR2,
			       x_loading_status     OUT NOCOPY 	VARCHAR2
			       )  IS

				  l_api_name		CONSTANT VARCHAR2(30)  := 'Update_PmtPlan';

Line: 234


				  L_LAST_UPDATE_DATE          DATE    := sysdate;

Line: 235


				  L_LAST_UPDATED_BY           NUMBER  := fnd_global.user_id;

Line: 238


				  L_LAST_UPDATE_LOGIN         NUMBER  := fnd_global.login_id;

Line: 242


				  l_update_rec   cn_pmtplan_pvt.PmtPlan_rec_type;

Line: 243


				  l_update_old_rec   cn_pmtplan_pvt.PmtPlan_rec_type;

Line: 246


        select start_date from cn_pmt_plans
        where name = p_PmtPlan_rec.name
        and org_id = p_PmtPlan_rec.org_id;

Line: 252


   SAVEPOINT    Update_PmtPlan;

Line: 267


   x_loading_status := 'CN_UPDATED';

Line: 271


   g_mode := 'UPDATE';

Line: 274


   l_update_old_rec.org_id := p_old_PmtPlan_rec.org_id;

Line: 276


   l_update_old_rec.name := p_old_PmtPlan_rec.name;

Line: 277


   l_update_old_rec.minimum_amount := p_old_PmtPlan_rec.minimum_amount;

Line: 278


   l_update_old_rec.maximum_amount := p_old_PmtPlan_rec.maximum_amount;

Line: 279


   l_update_old_rec.min_rec_flag := p_old_PmtPlan_rec.min_rec_flag;

Line: 280


   l_update_old_rec.max_rec_flag := p_old_PmtPlan_rec.max_rec_flag;

Line: 281


   l_update_old_rec.max_recovery_amount := p_old_PmtPlan_rec.max_recovery_amount;

Line: 282


   l_update_old_rec.credit_type_name := p_old_PmtPlan_rec.credit_type_name;

Line: 283


   l_update_old_rec.pay_interval_type_name := p_old_PmtPlan_rec.pay_interval_type_name;

Line: 284


   l_update_old_rec.start_date := p_old_PmtPlan_rec.start_date;

Line: 285


   l_update_old_rec.end_date := p_old_PmtPlan_rec.end_date;

Line: 286


   l_update_old_rec.object_version_number := p_old_PmtPlan_rec.object_version_number;

Line: 287


   l_update_old_rec.recoverable_interval_type := p_old_PmtPlan_rec.recoverable_interval_type;

Line: 288


   l_update_old_rec.pay_against_commission := p_old_PmtPlan_rec.pay_against_commission;

Line: 289


   l_update_old_rec.payment_group_code := p_old_PmtPlan_rec.payment_group_code;

Line: 294


        FETCH get_start_date INTO l_update_old_rec.start_date;

Line: 308


    l_update_old_rec.pmt_plan_id := l_pmt_plan_id;

Line: 312


   l_update_rec.org_id := p_PmtPlan_rec.org_id;

Line: 313


   mo_global.validate_orgid_pub_api(org_id => l_update_rec.org_id,status =>l_status);

Line: 315


       FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,'cn.plsql.cn_pmtplan_pub.Update_PmtPlan.org_validate',
                      'Validated org_id = ' || l_update_rec.org_id || ' status ='||l_status);

Line: 319


   if (l_update_rec.org_id <> l_update_old_rec.org_id ) then
    FND_MESSAGE.SET_NAME ('FND' , 'FND_MO_OU_CANNOT_UPDATE');

Line: 323


                      'cn.plsql.cn_paygroup_pub.update_PmtPlan.error',
                      true);

Line: 328


      FND_MESSAGE.SET_NAME ('FND' , 'FND_MO_OU_CANNOT_UPDATE');

Line: 334


   l_update_rec.name := p_PmtPlan_rec.name;

Line: 335


   l_update_rec.minimum_amount := p_PmtPlan_rec.minimum_amount;

Line: 336


   l_update_rec.maximum_amount := p_PmtPlan_rec.maximum_amount;

Line: 337


   l_update_rec.min_rec_flag := p_PmtPlan_rec.min_rec_flag;

Line: 338


   l_update_rec.max_rec_flag := p_PmtPlan_rec.max_rec_flag;

Line: 339


   l_update_rec.max_recovery_amount := p_PmtPlan_rec.max_recovery_amount;

Line: 340


   l_update_rec.credit_type_name := p_PmtPlan_rec.credit_type_name;

Line: 341


   l_update_rec.pay_interval_type_name := p_PmtPlan_rec.pay_interval_type_name;

Line: 342


   l_update_rec.start_date := p_PmtPlan_rec.start_date;

Line: 343


   l_update_rec.end_date := p_PmtPlan_rec.end_date;

Line: 344


   l_update_rec.object_version_number := p_PmtPlan_rec.object_version_number;

Line: 345


   l_update_rec.recoverable_interval_type := p_PmtPlan_rec.recoverable_interval_type;

Line: 346


   l_update_rec.pay_against_commission := p_PmtPlan_rec.pay_against_commission;

Line: 347


   l_update_rec.payment_group_code := p_PmtPlan_rec.payment_group_code;

Line: 360


    l_update_rec.pmt_plan_id := l_pmt_plan_id;

Line: 361


   CN_PMTPLAN_PVT.Update_PmtPlan
     (p_api_version      => p_api_version,
      p_init_msg_list    => p_init_msg_list,
      p_commit           => p_commit,
      p_validation_level => p_validation_level,
      x_return_status    => x_return_status,
      x_msg_count        => x_msg_count,
      x_msg_data         => x_msg_data,
      p_old_PmtPlan_rec  => l_update_old_rec,
      p_PmtPlan_rec      => l_update_rec,
      x_status           => x_status,
      x_loading_status   => x_loading_status
      );

Line: 389


      ROLLBACK TO Update_PmtPlan;

Line: 398


      ROLLBACK TO Update_PmtPlan;

Line: 408


      ROLLBACK TO Update_PmtPlan;

Line: 421


END Update_PmtPlan;

Line: 426


PROCEDURE  Delete_PmtPlan
  (    p_api_version			IN 	NUMBER,
       p_init_msg_list		        IN	VARCHAR2,
       p_commit	    		IN  	VARCHAR2,
       p_validation_level		IN  	NUMBER,
       x_return_status       	 OUT NOCOPY 	VARCHAR2,
       x_msg_count	           OUT NOCOPY 	NUMBER,
       x_msg_data		   OUT NOCOPY 	VARCHAR2,
       p_PmtPlan_rec                  IN    PmtPlan_rec_type ,
       x_status		 OUT NOCOPY 	VARCHAR2,
       x_loading_status    	 OUT NOCOPY 	VARCHAR2
       )  IS

    l_api_name		CONSTANT VARCHAR2(30) := 'Delete_PmtPlan';

Line: 447


        select start_date from cn_pmt_plans
        where name = p_PmtPlan_rec.name
        and org_id = p_PmtPlan_rec.org_id;

Line: 457


       FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,'cn.plsql.cn_pmtplan_pub.delete_PmtPlan.org_validate',
                      'Validated org_id = ' || l_create_rec.org_id || ' status ='||l_status);

Line: 470


    CN_PMTPLAN_PVT.Delete_PmtPlan
     (p_api_version      => p_api_version,
      p_init_msg_list    => p_init_msg_list,
      p_commit           => p_commit,
      p_validation_level => p_validation_level,
      x_return_status    => x_return_status,
      x_msg_count        => x_msg_count,
      x_msg_data         => x_msg_data,
      p_PmtPlan_rec      => l_create_rec,
      x_status           => x_status,
      x_loading_status   => x_loading_status);

Line: 482


END Delete_PmtPlan;