The following lines contain the word 'select', 'insert', 'update' or 'delete':
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;
l_api_name CONSTANT VARCHAR(30) := 'Update_Project_Task_Bill_Info';
pa_debug.debug('Update Bill Info PUB : Checking the api version number.');
pa_debug.debug('Update Bill Info PUB : Initializing message stack.');
pa_debug.init_err_stack('PA_BILLING_SCHEDULE_PUB.Update_Project_Task_Bill_Info');
pa_debug.debug('Update Billing Info PUB : Checking Carrying out organization');
pa_debug.debug('Update Billing Info PUB : Checking Emp bill rate schedule id');
pa_debug.debug('Update Billing Info PUB : Checking Job bill rate schedule id');
SELECT bill_job_group_id
INTO l_job_group_id
FROM pa_projects_prm_v
WHERE project_id = p_project_id;
pa_debug.debug('Update Billing Info PUB : Checking schedule ');
pa_debug.debug('Update Billing Info PUB : Checking Emp bill rate schedule id');
pa_debug.debug('Update Billing Info PUB : Checking Job bill rate schedule id');
pa_debug.debug('Update Billing Info PUB : Checking Revenue schedule');
pa_debug.debug('Update Billing Info PUB : Checking Invoice schedule');
pa_debug.debug('Update Billing Info PUB : Checking Revenue schedule');
pa_debug.debug('Update Billing Info PUB : Checking Invoice schedule');
pa_debug.debug('Update Billing Info PUB : Checking Carrying out organization');
pa_debug.debug('Update Billing Info PUB : Checking schedule ');
pa_debug.debug('Update Billing Info PUB : Checking Revenue schedule');
pa_debug.debug('Update Billing Info PUB : Checking Invoice schedule');
pa_debug.debug('Update Bill Info PUB : checking message count');
pa_debug.debug('Update Bill Info PUB : Calling private api Update Bill Info');
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
);
pa_debug.debug('Update Bill Info PUB : checking message count');
ROLLBACK TO Update_Bill_Info;
p_procedure_name => 'Update_Project_Task_Bill_Info',
p_error_text => SUBSTRB(SQLERRM,1,240));
ROLLBACK TO Update_Bill_Info;
ROLLBACK TO Update_Bill_Info;
p_procedure_name => 'Update_Project_Task_Bill_Info',
p_error_text => SUBSTRB(SQLERRM,1,240));
END Update_Project_Task_Bill_Info;
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';
pa_debug.debug('update_billing_schedule_type PUB : Checking the api version number.');
pa_debug.debug('update_billing_schedule_type PUB : Initializing message stack.');
pa_debug.init_err_stack('PA_BILLING_SCHEDULE_PUB.UPDATE_LABOR_MULTIPLIER');
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
);
pa_debug.debug('update_billing_schedule_type PUB : checking message count');
p_procedure_name => 'update_billing_schedule_type',
p_error_text => SUBSTRB(SQLERRM,1,240));
p_procedure_name => 'update_billing_schedule_type',
p_error_text => SUBSTRB(SQLERRM,1,240));
END update_billing_schedule_type;
l_api_name CONSTANT VARCHAR(30) := 'Update_Project_Task_Bill_Info';
pa_debug.debug('Update Bill Info PUB : Checking the api version number.');
pa_debug.debug('Update Bill Info PUB : Initializing message stack.');
pa_debug.debug('Update Bill Info PUB : checking message count');
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';
pa_debug.debug('Update Bill Info PUB : Checking the api version number.');
pa_debug.debug('Update Bill Info PUB : Initializing message stack.');
pa_debug.init_err_stack('PA_BILLING_SCHEDULE_PUB.UPDATE_LABOR_MULTIPLIER');
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
);
pa_debug.debug('Update Bill Info PUB : checking message count');
p_procedure_name => 'update_labor_multiplier',
p_error_text => SUBSTRB(SQLERRM,1,240));
p_procedure_name => 'update_labor_multiplier',
p_error_text => SUBSTRB(SQLERRM,1,240));
END Update_Labor_Multiplier;
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';
pa_debug.debug('Update Bill Info PUB : Checking the api version number.');
pa_debug.debug('Update Bill Info PUB : Initializing message stack.');
pa_debug.init_err_stack('PA_BILLING_SCHEDULE_PUB.DELETE_LABOR_MULTIPLIER');
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
);
pa_debug.debug('Update Bill Info PUB : checking message count');
p_procedure_name => 'Delete_labor_multiplier',
p_error_text => SUBSTRB(SQLERRM,1,240));
p_procedure_name => 'delete_labor_multiplier',
p_error_text => SUBSTRB(SQLERRM,1,240));
END Delete_Labor_Multiplier;