[Home] [Help]
The following lines contain the word 'select', 'insert', 'update' or 'delete':
PROCEDURE Insert_Row(X_Rowid IN OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
X_Task_Id IN OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895
X_Project_Id NUMBER,
X_Task_Number VARCHAR2,
X_Creation_Date DATE,
X_Created_By NUMBER,
X_Last_Update_Date DATE,
X_Last_Updated_By NUMBER,
X_Last_Update_Login NUMBER,
X_Task_Name VARCHAR2,
-- Long Task Name change by xxlu
X_Long_Task_Name VARCHAR2,
X_Top_Task_Id NUMBER,
X_Wbs_Level NUMBER,
X_Ready_To_Bill_Flag VARCHAR2,
X_Ready_To_Distribute_Flag VARCHAR2,
X_Parent_Task_Id NUMBER,
X_Description VARCHAR2,
X_Carrying_Out_Organization_Id NUMBER,
X_Service_Type_Code VARCHAR2,
X_Task_Manager_Person_Id NUMBER,
X_Chargeable_Flag VARCHAR2,
X_Billable_Flag VARCHAR2,
X_Limit_To_Txn_Controls_Flag VARCHAR2,
X_Start_Date DATE,
X_Completion_Date DATE,
X_Address_Id NUMBER,
X_Labor_Bill_Rate_Org_Id NUMBER,
X_Labor_Std_Bill_Rate_Schdl VARCHAR2,
X_Labor_Schedule_Fixed_Date DATE,
X_Labor_Schedule_Discount NUMBER,
X_Non_Labor_Bill_Rate_Org_Id NUMBER,
X_NL_Std_Bill_Rate_Schdl VARCHAR2,
X_NL_Schedule_Fixed_Date DATE,
X_Non_Labor_Schedule_Discount NUMBER,
X_Labor_Cost_Multiplier_Name VARCHAR2,
X_Attribute_Category VARCHAR2,
X_Attribute1 VARCHAR2,
X_Attribute2 VARCHAR2,
X_Attribute3 VARCHAR2,
X_Attribute4 VARCHAR2,
X_Attribute5 VARCHAR2,
X_Attribute6 VARCHAR2,
X_Attribute7 VARCHAR2,
X_Attribute8 VARCHAR2,
X_Attribute9 VARCHAR2,
X_Attribute10 VARCHAR2,
X_Cost_Ind_Rate_Sch_Id NUMBER,
X_Rev_Ind_Rate_Sch_Id NUMBER,
X_Inv_Ind_Rate_Sch_Id NUMBER,
X_Cost_Ind_Sch_Fixed_Date DATE,
X_Rev_Ind_Sch_Fixed_Date DATE,
X_Inv_Ind_Sch_Fixed_Date DATE,
X_Labor_Sch_Type VARCHAR2,
X_Non_Labor_Sch_Type VARCHAR2,
X_Allow_Cross_Charge_Flag VARCHAR2,
X_Project_Rate_Date DATE,
X_Project_Rate_Type VARCHAR2,
X_CC_Process_Labor_Flag VARCHAR2,
X_Labor_Tp_Schedule_Id NUMBER,
X_Labor_Tp_Fixed_Date DATE,
X_CC_Process_NL_Flag VARCHAR2,
X_Nl_Tp_Schedule_Id NUMBER,
X_Nl_Tp_Fixed_Date DATE,
X_receive_project_invoice_flag VARCHAR2,
X_work_type_id NUMBER,
-- 21-MAR-2001 anlee
-- added job_bill_rate_schedule_id,
-- emp_bill_rate_schedule_id for
-- PRM forecasting changes
X_job_bill_rate_schedule_id NUMBER,
X_emp_bill_rate_schedule_id NUMBER,
--MCA Sakthi for MultiAgreementCurreny Project
X_taskfunc_cost_rate_type VARCHAR2,
X_taskfunc_cost_rate_date DATE,
X_non_lab_std_bill_rt_sch_id NUMBER,
--MCA Sakthi for MultiAgreementCurreny Project
-- FP.K Setup changes by msundare
X_labor_disc_reason_code VARCHAR2,
X_non_labor_disc_reason_code VARCHAR2,
--PA L Dev
x_retirement_cost_flag VARCHAR2,
x_cint_eligible_flag VARCHAR2,
x_cint_stop_date DATE,
/*Added for FPM Changes */
x_customer_id Number default NULL,
x_revenue_accrual_method varchar2 default null,
x_invoice_method varchar2 default null,
x_gen_etc_src_code VARCHAR2 default NULL,
x_ADJ_ON_STD_INV VARCHAR2 default 'N' /* Added for 12.2 Payroll billing ER 11847616 */
) IS
CURSOR C IS SELECT rowid FROM PA_TASKS
WHERE task_id = X_Task_Id;
CURSOR C2 IS SELECT pa_tasks_s.nextval FROM sys.dual;
INSERT INTO PA_TASKS(
task_id,
project_id,
task_number,
creation_date,
created_by,
last_update_date,
last_updated_by,
last_update_login,
task_name,
long_task_name,
top_task_id,
wbs_level,
ready_to_bill_flag,
ready_to_distribute_flag,
parent_task_id,
description,
carrying_out_organization_id,
service_type_code,
task_manager_person_id,
chargeable_flag,
billable_flag,
limit_to_txn_controls_flag,
start_date,
completion_date,
address_id,
labor_bill_rate_org_id,
labor_std_bill_rate_schdl,
labor_schedule_fixed_date,
labor_schedule_discount,
non_labor_bill_rate_org_id,
non_labor_std_bill_rate_schdl,
non_labor_schedule_fixed_date,
non_labor_schedule_discount,
labor_cost_multiplier_name,
attribute_category,
attribute1,
attribute2,
attribute3,
attribute4,
attribute5,
attribute6,
attribute7,
attribute8,
attribute9,
attribute10,
cost_ind_rate_sch_id,
rev_ind_rate_sch_id,
inv_ind_rate_sch_id,
cost_ind_sch_fixed_date,
rev_ind_sch_fixed_date,
inv_ind_sch_fixed_date,
labor_sch_type,
non_labor_sch_type,
Allow_Cross_Charge_Flag,
Project_Rate_Date,
Project_Rate_Type,
CC_Process_Labor_Flag,
Labor_Tp_Schedule_Id,
Labor_Tp_Fixed_Date,
CC_Process_NL_Flag,
Nl_Tp_Schedule_Id,
Nl_Tp_Fixed_Date,
receive_project_invoice_flag,
work_type_id,
job_bill_rate_schedule_id,
emp_bill_rate_schedule_id,
taskfunc_cost_rate_type,
taskfunc_cost_rate_date,
non_lab_std_bill_rt_sch_id,
labor_disc_reason_code,
non_labor_disc_reason_code,
retirement_cost_flag ,
cint_eligible_flag ,
cint_stop_date ,
record_version_number,
customer_id,
revenue_accrual_method,
invoice_method,
GEN_ETC_SOURCE_CODE,
ADJ_ON_STD_INV /* Added for 12.2 Payroll billing ER 11847616 */
) VALUES (
X_Task_Id,
X_Project_Id,
SUBSTRB( X_Task_Number, 1, 25 ), --Bug 4297289
X_Creation_Date,
X_Created_By,
X_Last_Update_Date,
X_Last_Updated_By,
X_Last_Update_Login,
SUBSTRB( X_Task_Name, 1, 20 ), --Bug 4297289
X_Long_Task_Name,
nvl(X_Top_Task_Id, X_Task_id),
X_Wbs_Level,
X_Ready_To_Bill_Flag,
X_Ready_To_Distribute_Flag,
X_Parent_Task_Id,
X_Description,
X_Carrying_Out_Organization_Id,
X_Service_Type_Code,
X_Task_Manager_Person_Id,
X_Chargeable_Flag,
X_Billable_Flag,
X_Limit_To_Txn_Controls_Flag,
X_Start_Date,
X_Completion_Date,
X_Address_Id,
X_Labor_Bill_Rate_Org_Id,
X_Labor_Std_Bill_Rate_Schdl,
X_Labor_Schedule_Fixed_Date,
X_Labor_Schedule_Discount,
X_Non_Labor_Bill_Rate_Org_Id,
X_NL_Std_Bill_Rate_Schdl,
X_NL_Schedule_Fixed_Date,
X_Non_Labor_Schedule_Discount,
X_Labor_Cost_Multiplier_Name,
X_Attribute_Category,
X_Attribute1,
X_Attribute2,
X_Attribute3,
X_Attribute4,
X_Attribute5,
X_Attribute6,
X_Attribute7,
X_Attribute8,
X_Attribute9,
X_Attribute10,
X_Cost_Ind_Rate_Sch_Id,
X_Rev_Ind_Rate_Sch_Id,
X_Inv_Ind_Rate_Sch_Id,
X_Cost_Ind_Sch_Fixed_Date,
X_Rev_Ind_Sch_Fixed_Date,
X_Inv_Ind_Sch_Fixed_Date,
X_Labor_Sch_Type,
X_Non_Labor_Sch_Type,
X_Allow_Cross_Charge_Flag,
X_Project_Rate_Date,
X_Project_Rate_Type,
X_CC_Process_Labor_Flag,
X_Labor_Tp_Schedule_Id,
X_Labor_Tp_Fixed_Date,
X_CC_Process_NL_Flag,
X_Nl_Tp_Schedule_Id,
X_Nl_Tp_Fixed_Date,
X_Receive_Project_Invoice_Flag,
X_work_type_id,
X_job_bill_rate_schedule_id,
X_emp_bill_rate_schedule_id,
X_taskfunc_cost_rate_type,
X_taskfunc_cost_rate_date,
X_non_lab_std_bill_rt_sch_id,
X_labor_disc_reason_code,
X_non_labor_disc_reason_code,
--PA L Changes 2872708
x_retirement_cost_flag ,
x_cint_eligible_flag ,
x_cint_stop_date ,
1,
x_customer_id,
x_revenue_accrual_method,
x_invoice_method,
x_gen_etc_src_code,
x_ADJ_ON_STD_INV /* Added for 12.2 Payroll billing ER 11847616 */
);
p_procedure_name => 'Insert_Row',
p_error_text => SUBSTRB(SQLERRM,1,240));
END Insert_Row;
SELECT *
FROM PA_TASKS
WHERE rowid = X_Rowid
FOR UPDATE of Task_Id NOWAIT;
FND_MESSAGE.Set_Name('FND', 'FORM_RECORD_DELETED');
PROCEDURE Update_Row(X_Rowid VARCHAR2,
X_Task_Id NUMBER,
X_Project_Id NUMBER,
X_Task_Number VARCHAR2,
X_Last_Update_Date DATE,
X_Last_Updated_By NUMBER,
X_Last_Update_Login NUMBER,
X_Task_Name VARCHAR2,
-- Long Task Name change by xxlu
X_Long_Task_Name VARCHAR2,
X_Top_Task_Id NUMBER,
X_Wbs_Level NUMBER,
X_Ready_To_Bill_Flag VARCHAR2,
X_Ready_To_Distribute_Flag VARCHAR2,
X_Parent_Task_Id NUMBER,
X_Description VARCHAR2,
X_Carrying_Out_Organization_Id NUMBER,
X_Service_Type_Code VARCHAR2,
X_Task_Manager_Person_Id NUMBER,
X_Chargeable_Flag VARCHAR2,
X_Billable_Flag VARCHAR2,
X_Limit_To_Txn_Controls_Flag VARCHAR2,
X_Start_Date DATE,
X_Completion_Date DATE,
X_Address_Id NUMBER,
X_Labor_Bill_Rate_Org_Id NUMBER,
X_Labor_Std_Bill_Rate_Schdl VARCHAR2,
X_Labor_Schedule_Fixed_Date DATE,
X_Labor_Schedule_Discount NUMBER,
X_Non_Labor_Bill_Rate_Org_Id NUMBER,
X_NL_Std_Bill_Rate_Schdl VARCHAR2,
X_NL_Schedule_Fixed_Date DATE,
X_Non_Labor_Schedule_Discount NUMBER,
X_Labor_Cost_Multiplier_Name VARCHAR2,
X_Attribute_Category VARCHAR2,
X_Attribute1 VARCHAR2,
X_Attribute2 VARCHAR2,
X_Attribute3 VARCHAR2,
X_Attribute4 VARCHAR2,
X_Attribute5 VARCHAR2,
X_Attribute6 VARCHAR2,
X_Attribute7 VARCHAR2,
X_Attribute8 VARCHAR2,
X_Attribute9 VARCHAR2,
X_Attribute10 VARCHAR2,
X_Cost_Ind_Rate_Sch_Id NUMBER,
X_Rev_Ind_Rate_Sch_Id NUMBER,
X_Inv_Ind_Rate_Sch_Id NUMBER,
X_Cost_Ind_Sch_Fixed_Date DATE,
X_Rev_Ind_Sch_Fixed_Date DATE,
X_Inv_Ind_Sch_Fixed_Date DATE,
X_Labor_Sch_Type VARCHAR2,
X_Non_Labor_Sch_Type VARCHAR2,
X_Allow_Cross_Charge_Flag VARCHAR2,
X_Project_Rate_Date DATE,
X_Project_Rate_Type VARCHAR2,
X_CC_Process_Labor_Flag VARCHAR2,
X_Labor_Tp_Schedule_Id NUMBER,
X_Labor_Tp_Fixed_Date DATE,
X_CC_Process_NL_Flag VARCHAR2,
X_Nl_Tp_Schedule_Id NUMBER,
X_Nl_Tp_Fixed_Date DATE,
X_receive_project_invoice_flag VARCHAR2,
X_work_type_id NUMBER,
-- 21-MAR-2001 anlee
-- added job_bill_rate_schedule_id,
-- emp_bill_rate_schedule_id for
-- PRM forecasting changes
X_job_bill_rate_schedule_id NUMBER,
X_emp_bill_rate_schedule_id NUMBER,
--MCA Sakthi for MultiAgreementCurreny Project
X_taskfunc_cost_rate_type VARCHAR2,
X_taskfunc_cost_rate_date DATE,
X_non_lab_std_bill_rt_sch_id NUMBER,
--MCA Sakthi for MultiAgreementCurreny Project
-- FP.K Setup changes by msundare
X_labor_disc_reason_code VARCHAR2,
X_non_labor_disc_reason_code VARCHAR2,
--PA L Dev
x_retirement_cost_flag VARCHAR2,
x_cint_eligible_flag VARCHAR2,
x_cint_stop_date DATE,
x_gen_etc_src_code VARCHAR2
) IS
BEGIN
UPDATE PA_TASKS
SET
task_id = X_Task_Id,
project_id = X_Project_Id,
task_number = SUBSTRB( X_Task_Number, 1, 25 ), -- 4537865 : Replaced SUBSTR with SUBSTRB
last_update_date = X_Last_Update_Date,
last_updated_by = X_Last_Updated_By,
last_update_login = X_Last_Update_Login,
task_name = SUBSTRB( X_Task_Name, 1, 20 ),-- 4537865 : Replaced SUBSTR with SUBSTRB
long_task_name = X_Long_Task_Name,
top_task_id = X_Top_Task_Id,
wbs_level = X_Wbs_Level,
ready_to_bill_flag = X_Ready_To_Bill_Flag,
ready_to_distribute_flag = X_Ready_To_Distribute_Flag,
parent_task_id = X_Parent_Task_Id,
description = X_Description,
carrying_out_organization_id = X_Carrying_Out_Organization_Id,
service_type_code = X_Service_Type_Code,
task_manager_person_id = X_Task_Manager_Person_Id,
chargeable_flag = X_Chargeable_Flag,
billable_flag = X_Billable_Flag,
limit_to_txn_controls_flag = X_Limit_To_Txn_Controls_Flag,
start_date = X_Start_Date,
completion_date = X_Completion_Date,
address_id = X_Address_Id,
labor_bill_rate_org_id = X_Labor_Bill_Rate_Org_Id,
labor_std_bill_rate_schdl = X_Labor_Std_Bill_Rate_Schdl,
labor_schedule_fixed_date = X_Labor_Schedule_Fixed_Date,
labor_schedule_discount = X_Labor_Schedule_Discount,
non_labor_bill_rate_org_id = X_Non_Labor_Bill_Rate_Org_Id,
non_labor_std_bill_rate_schdl = X_NL_Std_Bill_Rate_Schdl,
non_labor_schedule_fixed_date = X_NL_Schedule_Fixed_Date,
non_labor_schedule_discount = X_Non_Labor_Schedule_Discount,
labor_cost_multiplier_name = X_Labor_Cost_Multiplier_Name,
attribute_category = X_Attribute_Category,
attribute1 = X_Attribute1,
attribute2 = X_Attribute2,
attribute3 = X_Attribute3,
attribute4 = X_Attribute4,
attribute5 = X_Attribute5,
attribute6 = X_Attribute6,
attribute7 = X_Attribute7,
attribute8 = X_Attribute8,
attribute9 = X_Attribute9,
attribute10 = X_Attribute10,
cost_ind_rate_sch_id = X_Cost_Ind_Rate_Sch_Id,
rev_ind_rate_sch_id = X_Rev_Ind_Rate_Sch_Id,
inv_ind_rate_sch_id = X_Inv_Ind_Rate_Sch_Id,
cost_ind_sch_fixed_date = X_Cost_Ind_Sch_Fixed_Date,
rev_ind_sch_fixed_date = X_Rev_Ind_Sch_Fixed_Date,
inv_ind_sch_fixed_date = X_Inv_Ind_Sch_Fixed_Date,
labor_sch_type = X_Labor_Sch_Type,
non_labor_sch_type = X_Non_Labor_Sch_Type,
Allow_Cross_Charge_Flag = X_Allow_Cross_Charge_Flag,
Project_Rate_Date = X_Project_Rate_Date,
Project_Rate_Type = X_Project_Rate_Type,
CC_Process_Labor_Flag = X_CC_Process_Labor_Flag,
Labor_Tp_Schedule_Id = X_Labor_Tp_Schedule_Id,
Labor_Tp_Fixed_Date = X_Labor_Tp_Fixed_Date,
CC_Process_NL_Flag = X_CC_Process_NL_Flag,
Nl_Tp_Schedule_Id = X_Nl_Tp_Schedule_Id,
Nl_Tp_Fixed_Date = X_Nl_Tp_Fixed_Date,
Receive_Project_Invoice_Flag = X_Receive_Project_Invoice_Flag,
Work_Type_ID = X_Work_Type_ID,
job_bill_rate_schedule_id = X_job_bill_rate_schedule_id,
emp_bill_rate_schedule_id = X_emp_bill_rate_schedule_id,
--MCA Sakthi for MultiAgreementCurreny Project
taskfunc_cost_rate_type = X_taskfunc_cost_rate_type,
taskfunc_cost_rate_date = X_taskfunc_cost_rate_date,
non_lab_std_bill_rt_sch_id = X_non_lab_std_bill_rt_sch_id,
--msundare
labor_disc_reason_code = X_labor_disc_reason_code,
non_labor_disc_reason_code = X_non_labor_disc_reason_code,
--PA_L
retirement_cost_flag = x_retirement_cost_flag,
cint_eligible_flag = x_cint_eligible_flag,
cint_stop_date = x_cint_stop_date,
GEN_ETC_SOURCE_CODE = x_gen_etc_src_code,
record_version_number = nvl( record_version_number, 1 ) + 1
--MCA Sakthi for MultiAgreementCurreny Project
WHERE rowid = X_Rowid;
END Update_Row;
PROCEDURE Delete_Row(X_Rowid VARCHAR2) IS
BEGIN
DELETE FROM PA_TASKS
WHERE rowid = X_Rowid;
END Delete_Row;
select task_id
into x_dummy
from pa_tasks t1
where not exists
(select *
from pa_tasks t2
where t1.task_id = t2.parent_task_id)
and t1.task_id = x_task_id;