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_PAYGROUP_PUB SQL Statements

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

Line: 36


           SELECT name,
                  period_set_name,
                  period_type,
                  start_date,
                  end_date,
                  pay_group_description,
                  attribute_category,
                  attribute1,
                  attribute2,
                  attribute3,
                  attribute4,
                  attribute5,
                  attribute6,
                  attribute7,
                  attribute8,
                  attribute9,
                  attribute10,
                  attribute11,
                  attribute12,
                  attribute13,
                  attribute14,
                  attribute15,
                  object_version_number,
                  org_id
           FROM cn_pay_groups
	     WHERE upper(name) like upper(p_search_name)
	     and (p_search_start_date is null
		  OR ( trunc(start_date) >= trunc(p_search_start_date)
		       AND
		       (p_search_end_date is null OR (nvl(end_date,p_search_end_date) <= p_search_end_date))
		       )
		  )

	     and upper(period_set_name) like upper(p_search_period_set_name)
	     and org_id = x_org_id
     ORDER BY name;

Line: 205


	 SELECT pay_group_id
	   FROM cn_pay_groups
	   WHERE name = p_PayGroup_rec.name
	   AND start_date = p_PayGroup_rec.start_date
	   AND end_date = p_PayGroup_rec.end_date
       and org_id= x_org_id;

Line: 225


      SELECT cn_pay_groups_s.nextval
        INTO x_pay_group_id
        FROM dual;

Line: 301


   x_loading_status := 'CN_INSERTED';

Line: 419


PROCEDURE  Update_PayGroup (
		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_Paygroup_rec     IN  PayGroup_rec_type,
		p_PayGroup_rec         IN OUT NOCOPY     PayGroup_rec_type,
		x_status               OUT NOCOPY 	VARCHAR2,
		x_loading_status       OUT NOCOPY 	VARCHAR2
		)  IS
L_PKG_NAME                  CONSTANT VARCHAR2(30) := 'CN_PayGroup_PUB';

Line: 433


L_LAST_UPDATE_DATE          DATE    := sysdate;

Line: 434


L_LAST_UPDATED_BY           NUMBER  := fnd_global.user_id;

Line: 437


L_LAST_UPDATE_LOGIN         NUMBER  := fnd_global.login_id;

Line: 442


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

Line: 444


   l_update_rec          cn_paygroup_pvt.PayGroup_rec_type;

Line: 451


   SAVEPOINT    Update_PayGroup;

Line: 472


   x_loading_status := 'CN_UPDATED';

Line: 478


                   'cn.plsql.cn_paygroup_pub.update_paygroup.org_validate',
                     'Validated org_id = ' || l_org_id || ' status = '||l_status);

Line: 483


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

Line: 486


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

Line: 491


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

Line: 513


     l_update_rec.pay_group_id := p_PayGroup_rec.pay_group_id;

Line: 514


     l_update_rec.name        :=	p_PayGroup_rec.name;

Line: 515


     l_update_rec.period_set_name := p_PayGroup_rec.period_set_name;

Line: 516


     l_update_rec.period_type	:= p_PayGroup_rec.period_type;

Line: 517


     l_update_rec.start_date :=		p_PayGroup_rec.start_date;

Line: 518


     l_update_rec.end_date	:=	p_PayGroup_rec.end_date;

Line: 519


     l_update_rec.pay_group_description := p_PayGroup_rec.pay_group_description;

Line: 520


     l_update_rec.attribute_category:= p_PayGroup_rec.attribute_category;

Line: 521


     l_update_rec.attribute1 := p_PayGroup_rec.attribute1;

Line: 522


     l_update_rec.attribute2 := p_PayGroup_rec.attribute2;

Line: 523


     l_update_rec.attribute3 := p_PayGroup_rec.attribute3;

Line: 524


     l_update_rec.attribute4 := p_PayGroup_rec.attribute4;

Line: 525


     l_update_rec.attribute5 := p_PayGroup_rec.attribute5;

Line: 526


     l_update_rec.attribute6 := p_PayGroup_rec.attribute6;

Line: 527


     l_update_rec.attribute7 := p_PayGroup_rec.attribute7;

Line: 528


     l_update_rec.attribute8 := p_PayGroup_rec.attribute8;

Line: 529


     l_update_rec.attribute9 := p_PayGroup_rec.attribute9;

Line: 530


     l_update_rec.attribute10 := p_PayGroup_rec.attribute10;

Line: 531


     l_update_rec.attribute11 := p_PayGroup_rec.attribute11;

Line: 532


     l_update_rec.attribute12 := p_PayGroup_rec.attribute12;

Line: 533


     l_update_rec.attribute13 := p_PayGroup_rec.attribute13;

Line: 534


     l_update_rec.attribute14 := p_PayGroup_rec.attribute14;

Line: 535


     l_update_rec.attribute15 := p_PayGroup_rec.attribute15;

Line: 536


     l_update_rec.object_version_number := p_PayGroup_rec.object_version_number;

Line: 537


     l_update_rec.org_id := p_PayGroup_rec.org_id;

Line: 539


     cn_paygroup_pvt.Update_PayGroup (
		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_PayGroup_rec => l_update_rec,
		x_status => x_status,
		x_loading_status => x_loading_status
		);

Line: 562


      ROLLBACK TO Update_PayGroup;

Line: 571


      ROLLBACK TO Update_PayGroup;

Line: 581


      ROLLBACK TO Update_PayGroup;

Line: 594


END Update_PayGroup;

Line: 600


PROCEDURE  Delete_PayGroup
  (    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_PayGroup_rec               IN  OUT NOCOPY PayGroup_rec_type ,
       x_status		                OUT NOCOPY 	VARCHAR2,
       x_loading_status    	        OUT NOCOPY 	VARCHAR2
       )  IS
L_PKG_NAME                  CONSTANT VARCHAR2(30) := 'CN_PayGroup_PUB';

Line: 613


L_LAST_UPDATE_DATE          DATE    := sysdate;

Line: 614


L_LAST_UPDATED_BY           NUMBER  := fnd_global.user_id;

Line: 617


L_LAST_UPDATE_LOGIN         NUMBER  := fnd_global.login_id;

Line: 622


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

Line: 624


	  l_delete_rec  cn_paygroup_pvt.PayGroup_rec_type;

Line: 631


   SAVEPOINT    Delete_PayGroup ;

Line: 652


   x_loading_status := 'CN_DELETED';

Line: 659


                   'cn.plsql.cn_paygroup_pub.delete_paygroup.org_validate',
                     'Validated org_id = ' || l_org_id || ' status = '||l_status);

Line: 678


     l_delete_rec.pay_group_id := p_PayGroup_rec.pay_group_id;

Line: 679


     l_delete_rec.name        :=	p_PayGroup_rec.name;

Line: 680


     l_delete_rec.period_set_name := p_PayGroup_rec.period_set_name;

Line: 681


     l_delete_rec.period_type	:= p_PayGroup_rec.period_type;

Line: 682


     l_delete_rec.start_date :=		p_PayGroup_rec.start_date;

Line: 683


     l_delete_rec.end_date	:=	p_PayGroup_rec.end_date;

Line: 684


     l_delete_rec.pay_group_description := p_PayGroup_rec.pay_group_description;

Line: 685


     l_delete_rec.attribute_category:= p_PayGroup_rec.attribute_category;

Line: 686


     l_delete_rec.attribute1 := p_PayGroup_rec.attribute1;

Line: 687


     l_delete_rec.attribute2 := p_PayGroup_rec.attribute2;

Line: 688


     l_delete_rec.attribute3 := p_PayGroup_rec.attribute3;

Line: 689


     l_delete_rec.attribute4 := p_PayGroup_rec.attribute4;

Line: 690


     l_delete_rec.attribute5 := p_PayGroup_rec.attribute5;

Line: 691


     l_delete_rec.attribute6 := p_PayGroup_rec.attribute6;

Line: 692


     l_delete_rec.attribute7 := p_PayGroup_rec.attribute7;

Line: 693


     l_delete_rec.attribute8 := p_PayGroup_rec.attribute8;

Line: 694


     l_delete_rec.attribute9 := p_PayGroup_rec.attribute9;

Line: 695


     l_delete_rec.attribute10 := p_PayGroup_rec.attribute10;

Line: 696


     l_delete_rec.attribute11 := p_PayGroup_rec.attribute11;

Line: 697


     l_delete_rec.attribute12 := p_PayGroup_rec.attribute12;

Line: 698


     l_delete_rec.attribute13 := p_PayGroup_rec.attribute13;

Line: 699


     l_delete_rec.attribute14 := p_PayGroup_rec.attribute14;

Line: 700


     l_delete_rec.attribute15 := p_PayGroup_rec.attribute15;

Line: 701


     l_delete_rec.object_version_number := p_PayGroup_rec.object_version_number;

Line: 702


     l_delete_rec.org_id := p_PayGroup_rec.org_id;

Line: 704


    cn_paygroup_pvt.Delete_PayGroup
  (    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_PayGroup_rec => l_delete_rec,
       x_status => x_status,
       x_loading_status => x_loading_status
       );

Line: 727


      ROLLBACK TO Delete_PayGroup;

Line: 736


      ROLLBACK TO Delete_PayGroup;

Line: 746


      ROLLBACK TO Delete_PayGroup;

Line: 760


END Delete_PayGroup;