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

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

Line: 51


 PROCEDURE  Update_Project_Task_Bill_Info(
   p_api_version	       	 IN	 NUMBER     DEFAULT 1.0,
   p_init_msg_list	 	 IN	 VARCHAR2   DEFAULT FND_API.G_TRUE,
   p_commit	         	 IN	 VARCHAR2   DEFAULT FND_API.G_FALSE,
   p_validate_only	 	 IN	 VARCHAR2   DEFAULT FND_API.G_TRUE,
   p_validation_level	         IN	 NUMBER     DEFAULT FND_API.G_VALID_LEVEL_FULL,
   p_calling_module	 	 IN 	 VARCHAR2   DEFAULT 'SELF_SERVICE',
   p_debug_mode	                 IN	 VARCHAR2   DEFAULT 'N',
   p_max_msg_count	 	 IN	 NUMBER     DEFAULT FND_API.G_MISS_NUM,
   p_project_id	                 IN	 NUMBER    ,
   p_task_id	         	 IN	 NUMBER     DEFAULT FND_API.G_MISS_NUM,
   p_lbr_schedule_type	       IN	 VARCHAR2   DEFAULT FND_API.G_MISS_CHAR,
   p_non_lbr_schedule_type     IN	 VARCHAR2   DEFAULT FND_API.G_MISS_CHAR,
   p_emp_bill_rate_sch_name    IN	 VARCHAR2   DEFAULT FND_API.G_MISS_CHAR  ,
   p_emp_bill_rate_sch_id      IN	 NUMBER     DEFAULT FND_API.G_MISS_NUM,
   p_job_bill_rate_sch_name    IN	 VARCHAR2   DEFAULT FND_API.G_MISS_CHAR   ,
   p_job_bill_rate_sch_id      IN	 NUMBER     DEFAULT FND_API.G_MISS_NUM,
   p_lbr_sch_fxd_date	       IN	 DATE       DEFAULT FND_API.G_MISS_DATE,
   p_lbr_sch_discount	       IN	 NUMBER     DEFAULT FND_API.G_MISS_NUM,
   p_rev_schedule	       IN	 VARCHAR2   DEFAULT FND_API.G_MISS_CHAR  ,
   p_rev_schedule_id	       IN	 NUMBER     DEFAULT FND_API.G_MISS_NUM,
   p_inv_schedule	         IN	 VARCHAR2   DEFAULT FND_API.G_MISS_CHAR  ,
   p_inv_schedule_id	 	 IN	 NUMBER     DEFAULT FND_API.G_MISS_NUM,
   p_rev_ind_sch_fxd_date	 IN	 DATE       DEFAULT FND_API.G_MISS_DATE,
   p_inv_ind_sch_fxd_date 	 IN	 DATE       DEFAULT FND_API.G_MISS_DATE,
   p_nlbr_bill_rate_org	 	 IN	 VARCHAR2   DEFAULT FND_API.G_MISS_CHAR  ,
   p_nlbr_bill_rate_org_id	 IN	 NUMBER     DEFAULT FND_API.G_MISS_NUM,
   p_nlbr_std_bill_rate_sch	 IN	 VARCHAR2   DEFAULT FND_API.G_MISS_CHAR  ,
   p_nlbr_sch_fxd_date	         IN	 DATE       DEFAULT FND_API.G_MISS_DATE,
   p_nlbr_sch_discount	 	 IN	 NUMBER     DEFAULT FND_API.G_MISS_NUM,
   p_record_version_number	 IN	 NUMBER     DEFAULT 1,
   x_return_status	         OUT 	 NOCOPY VARCHAR2   , --File.Sql.39 bug 4440895
   x_msg_count	                 OUT 	 NOCOPY VARCHAR2  , --File.Sql.39 bug 4440895
   x_msg_data	                 OUT 	 NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
 )  IS

            --Derive bill_job_group_id from pa_projects_prm_v using project-task id.
  CURSOR cur_job_group IS
         SELECT bill_job_group_id
           FROM pa_projects_prm_v
          WHERE project_id = p_project_id;

Line: 94


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

Line: 125


       pa_debug.debug('Update Bill Info PUB : Checking the api version number.');

Line: 142


       pa_debug.debug('Update Bill Info PUB : Initializing message stack.');

Line: 145


   pa_debug.init_err_stack('PA_BILLING_SCHEDULE_PUB.Update_Project_Task_Bill_Info');

Line: 178


                pa_debug.debug('Update Billing Info PUB : Checking Carrying out organization');

Line: 202


                pa_debug.debug('Update Billing Info PUB : Checking Emp bill rate schedule id');

Line: 227


                pa_debug.debug('Update Billing Info PUB : Checking Job bill rate schedule id');

Line: 231


            SELECT bill_job_group_id
                            INTO l_job_group_id
              FROM pa_projects_prm_v
             WHERE project_id = p_project_id;

Line: 263


                pa_debug.debug('Update Billing Info PUB : Checking  schedule ');

Line: 305


                pa_debug.debug('Update Billing Info PUB : Checking Emp bill rate schedule id');

Line: 330


                pa_debug.debug('Update Billing Info PUB : Checking Job bill rate schedule id');

Line: 361


                pa_debug.debug('Update Billing Info PUB : Checking Revenue schedule');

Line: 385


                pa_debug.debug('Update Billing Info PUB : Checking Invoice schedule');

Line: 426


                pa_debug.debug('Update Billing Info PUB : Checking Revenue schedule');

Line: 450


                pa_debug.debug('Update Billing Info PUB : Checking Invoice schedule');

Line: 474


                pa_debug.debug('Update Billing Info PUB : Checking Carrying out organization');

Line: 497


                pa_debug.debug('Update Billing Info PUB : Checking  schedule ');

Line: 536


                pa_debug.debug('Update Billing Info PUB : Checking Revenue schedule');

Line: 560


                pa_debug.debug('Update Billing Info PUB : Checking Invoice schedule');

Line: 581


            pa_debug.debug('Update Bill Info PUB : checking message count');

Line: 601


            pa_debug.debug('Update Bill Info PUB : Calling private api Update Bill Info');

Line: 604


         PA_BILLING_SCHEDULE_PVT.Update_Project_Task_Bill_Info(
                p_commit                           => FND_API.G_FALSE,
                p_validate_only                    => p_validate_only,
                p_validation_level	               => p_validation_level,
                p_calling_module	               => p_calling_module,
                p_debug_mode	                     => p_debug_mode,
                p_max_msg_count                    => p_max_msg_count,
                p_project_id                       => p_project_id,
                p_task_id                          => p_task_id,
                p_lbr_schedule_type	 	         => p_lbr_schedule_type,
                p_non_lbr_schedule_type 	         => p_non_lbr_schedule_type,
                p_emp_bill_rate_sch_id             => l_emp_bill_rate_sch_id,
                p_job_bill_rate_sch_id             => l_job_bill_rate_sch_id,
                p_lbr_sch_fxd_date	               => l_lbr_sch_fxd_date,
                p_lbr_sch_discount	               => l_lbr_sch_discount,
                p_rev_schedule_id	               => l_rev_schedule_id,
                p_inv_schedule_id                  => l_inv_schedule_id,
                p_rev_ind_sch_fxd_date             => l_rev_ind_sch_fxd_date,
                p_inv_ind_sch_fxd_date 	         => l_inv_ind_sch_fxd_date,
                p_nlbr_bill_rate_org_id	         => l_nlbr_bill_rate_org_id,
                p_nlbr_std_bill_rate_sch	         => l_nlbr_std_bill_rate_sch,
                p_nlbr_sch_fxd_date	               => l_nlbr_sch_fxd_date,
                p_nlbr_sch_discount	               => l_nlbr_sch_discount,
                p_record_version_number	         => p_record_version_number,
                x_return_status	               => l_return_status,
                x_msg_count	                     => l_msg_count,
                x_msg_data	                     => l_msg_data
            );

Line: 634


            pa_debug.debug('Update Bill Info PUB : checking message count');

Line: 661


          ROLLBACK TO Update_Bill_Info;

Line: 665


                               p_procedure_name => 'Update_Project_Task_Bill_Info',
                               p_error_text     => SUBSTRB(SQLERRM,1,240));

Line: 672


          ROLLBACK TO Update_Bill_Info;

Line: 679


          ROLLBACK TO Update_Bill_Info;

Line: 683


                               p_procedure_name => 'Update_Project_Task_Bill_Info',
                               p_error_text     => SUBSTRB(SQLERRM,1,240));

Line: 687


END Update_Project_Task_Bill_Info;

Line: 717


 PROCEDURE  update_billing_schedule_type(
 p_api_version	                 IN	 NUMBER     DEFAULT 1.0,
 p_init_msg_list	 	 IN	 VARCHAR2   DEFAULT FND_API.G_TRUE,
 p_commit	         	 IN	 VARCHAR2   DEFAULT FND_API.G_FALSE,
 p_validate_only	 	 IN	 VARCHAR2   DEFAULT FND_API.G_TRUE,
 p_validation_level	 IN	 NUMBER     DEFAULT FND_API.G_VALID_LEVEL_FULL,
 p_calling_module	 	 IN 	 VARCHAR2   DEFAULT 'SELF_SERVICE',
 p_debug_mode	       IN	 VARCHAR2   DEFAULT 'N',
 p_max_msg_count	 	 IN	 NUMBER     DEFAULT FND_API.G_MISS_NUM,
 p_project_id	       IN	 NUMBER     ,
 p_task_id	         	 IN	 NUMBER     DEFAULT FND_API.G_MISS_NUM,
 p_lbr_schedule_type   IN    VARCHAR2,
 p_non_lbr_schedule_type   IN    VARCHAR2,
 p_record_version_number         IN	 NUMBER     DEFAULT 1,
 x_return_status	         OUT 	 NOCOPY VARCHAR2   , --File.Sql.39 bug 4440895
 x_msg_count	                 OUT 	 NOCOPY VARCHAR2   , --File.Sql.39 bug 4440895
 x_msg_data	                 OUT 	 NOCOPY VARCHAR2    --File.Sql.39 bug 4440895
)IS

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

Line: 754


       pa_debug.debug('update_billing_schedule_type PUB : Checking the api version number.');

Line: 771


       pa_debug.debug('update_billing_schedule_type PUB : Initializing message stack.');

Line: 774


   pa_debug.init_err_stack('PA_BILLING_SCHEDULE_PUB.UPDATE_LABOR_MULTIPLIER');

Line: 792


        PA_BILLING_SCHEDULE_PVT.update_billing_schedule_type(
                                        p_commit	        => FND_API.G_FALSE,
                                        p_validate_only       => p_validate_only,
                                        p_validation_level	  => p_validation_level,
                                        p_calling_module	  => p_calling_module,
                                        p_debug_mode	        => p_debug_mode,
                                        p_max_msg_count	  => p_max_msg_count,
                                        p_project_id	        => p_project_id,
                                        p_task_id	        => l_task_id,
                                        p_lbr_schedule_type => p_lbr_schedule_type,
                                        p_non_lbr_schedule_type   => p_non_lbr_schedule_type,
                                        p_record_version_number   => p_record_version_number,
                                        x_return_status	  => l_return_status,
                                        x_msg_count	        => l_msg_count,
                                        x_msg_data	        => l_msg_data
                                  );

Line: 811


        pa_debug.debug('update_billing_schedule_type PUB : checking message count');

Line: 842


                               p_procedure_name => 'update_billing_schedule_type',
                               p_error_text     => SUBSTRB(SQLERRM,1,240));

Line: 860


                               p_procedure_name => 'update_billing_schedule_type',
                               p_error_text     => SUBSTRB(SQLERRM,1,240));

Line: 864


END update_billing_schedule_type;

Line: 916


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

Line: 936


       pa_debug.debug('Update Bill Info PUB : Checking the api version number.');

Line: 953


       pa_debug.debug('Update Bill Info PUB : Initializing message stack.');

Line: 1001


        pa_debug.debug('Update Bill Info PUB : checking message count');

Line: 1086


 PROCEDURE  Update_Labor_Multiplier(
 p_api_version	                 IN	 NUMBER     DEFAULT 1.0,
 p_init_msg_list	 	 IN	 VARCHAR2   DEFAULT FND_API.G_TRUE,
 p_commit	         	 IN	 VARCHAR2   DEFAULT FND_API.G_FALSE,
 p_validate_only	 	 IN	 VARCHAR2   DEFAULT FND_API.G_TRUE,
 p_validation_level	         IN	 NUMBER     DEFAULT FND_API.G_VALID_LEVEL_FULL,
 p_calling_module	 	 IN 	 VARCHAR2   DEFAULT 'SELF_SERVICE',
 p_debug_mode	                 IN	 VARCHAR2   DEFAULT 'N',
 p_max_msg_count	 	 IN	 NUMBER     DEFAULT FND_API.G_MISS_NUM,
 p_labor_multiplier_id       IN    NUMBER,
 p_project_id	                 IN	 NUMBER     ,
 p_task_id	         	 IN	 NUMBER     DEFAULT FND_API.G_MISS_NUM,
 p_labor_multiplier	         IN	 NUMBER	,
 p_effective_from_date	         IN	 DATE	      ,
 p_effective_to_date	         IN	 DATE	      DEFAULT FND_API.G_MISS_DATE,
 p_record_version_number         IN	 NUMBER     DEFAULT 1,
 x_return_status	         OUT 	 NOCOPY VARCHAR2   , --File.Sql.39 bug 4440895
 x_msg_count	                 OUT 	 NOCOPY VARCHAR2   , --File.Sql.39 bug 4440895
 x_msg_data	                 OUT 	 NOCOPY VARCHAR2    --File.Sql.39 bug 4440895
)IS

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

Line: 1125


       pa_debug.debug('Update Bill Info PUB : Checking the api version number.');

Line: 1142


       pa_debug.debug('Update Bill Info PUB : Initializing message stack.');

Line: 1145


   pa_debug.init_err_stack('PA_BILLING_SCHEDULE_PUB.UPDATE_LABOR_MULTIPLIER');

Line: 1170


        PA_BILLING_SCHEDULE_PVT.Update_Labor_Multiplier(
                                        p_commit	        => FND_API.G_FALSE,
                                        p_validate_only       => p_validate_only,
                                        p_validation_level	  => p_validation_level,
                                        p_calling_module	  => p_calling_module,
                                        p_debug_mode	        => p_debug_mode,
                                        p_max_msg_count	  => p_max_msg_count,
                                        p_labor_multiplier_id => p_labor_multiplier_id,
                                        p_project_id	        => p_project_id,
                                        p_task_id	        => l_task_id,
                                        p_labor_multiplier	  => p_labor_multiplier,
                                        p_effective_from_date => p_effective_from_date,
                                        p_effective_to_date	  => l_effective_to_date,
                                        p_record_version_number   => p_record_version_number,
                                        x_return_status	  => l_return_status,
                                        x_msg_count	        => l_msg_count,
                                        x_msg_data	        => l_msg_data
                                  );

Line: 1191


        pa_debug.debug('Update Bill Info PUB : checking message count');

Line: 1222


                               p_procedure_name => 'update_labor_multiplier',
                               p_error_text     => SUBSTRB(SQLERRM,1,240));

Line: 1240


                               p_procedure_name => 'update_labor_multiplier',
                               p_error_text     => SUBSTRB(SQLERRM,1,240));

Line: 1244


END Update_Labor_Multiplier;

Line: 1274


 PROCEDURE  delete_Labor_Multiplier(
 p_api_version	                 IN	 NUMBER     DEFAULT 1.0,
 p_init_msg_list	 	 IN	 VARCHAR2   DEFAULT FND_API.G_TRUE,
 p_commit	         	 IN	 VARCHAR2   DEFAULT FND_API.G_FALSE,
 p_validate_only	 	 IN	 VARCHAR2   DEFAULT FND_API.G_TRUE,
 p_validation_level	         IN	 NUMBER     DEFAULT FND_API.G_VALID_LEVEL_FULL,
 p_calling_module	 	 IN 	 VARCHAR2   DEFAULT 'SELF_SERVICE',
 p_debug_mode	                 IN	 VARCHAR2   DEFAULT 'N',
 p_max_msg_count	 	 IN	 NUMBER     DEFAULT FND_API.G_MISS_NUM,
 p_labor_multiplier_id       IN    NUMBER,
 p_project_id	                 IN	 NUMBER     ,
 p_task_id	         	 IN	 NUMBER     DEFAULT FND_API.G_MISS_NUM,
 p_labor_multiplier	         IN	 NUMBER	,
 p_effective_from_date	         IN	 DATE	      ,
 p_record_version_number         IN	 NUMBER     DEFAULT 1,
 x_return_status	         OUT 	 NOCOPY VARCHAR2   , --File.Sql.39 bug 4440895
 x_msg_count	                 OUT 	 NOCOPY VARCHAR2   , --File.Sql.39 bug 4440895
 x_msg_data	                 OUT 	 NOCOPY VARCHAR2    --File.Sql.39 bug 4440895
)IS

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

Line: 1310


       pa_debug.debug('Update Bill Info PUB : Checking the api version number.');

Line: 1327


       pa_debug.debug('Update Bill Info PUB : Initializing message stack.');

Line: 1330


   pa_debug.init_err_stack('PA_BILLING_SCHEDULE_PUB.DELETE_LABOR_MULTIPLIER');

Line: 1348


        PA_BILLING_SCHEDULE_PVT.Delete_Labor_Multiplier(
                                        p_commit	        => FND_API.G_FALSE,
                                        p_validate_only       => p_validate_only,
                                        p_validation_level	  => p_validation_level,
                                        p_calling_module	  => p_calling_module,
                                        P_labor_multiplier       => p_labor_multiplier,
                                        p_debug_mode	        => p_debug_mode,
                                        p_max_msg_count	  => p_max_msg_count,
                                        p_labor_multiplier_id => p_labor_multiplier_id,
                                        p_project_id	        => p_project_id,
                                        p_task_id	        => l_task_id,
                                        p_effective_from_date => p_effective_from_date,
                                        p_record_version_number => p_record_version_number,
                                        x_return_status	  => l_return_status,
                                        x_msg_count	        => l_msg_count,
                                        x_msg_data	        => l_msg_data
                                  );

Line: 1368


        pa_debug.debug('Update Bill Info PUB : checking message count');

Line: 1399


                               p_procedure_name => 'Delete_labor_multiplier',
                               p_error_text     => SUBSTRB(SQLERRM,1,240));

Line: 1417


                               p_procedure_name => 'delete_labor_multiplier',
                               p_error_text     => SUBSTRB(SQLERRM,1,240));

Line: 1421


END Delete_Labor_Multiplier;