[Home] [Help]
The following lines contain the word 'select', 'insert', 'update' or 'delete':
l_delete_project_allowed VARCHAR2(1);
l_update_proj_num_allowed VARCHAR2(1);
l_update_proj_name_allowed VARCHAR2(1);
l_update_proj_desc_allowed VARCHAR2(1);
l_update_proj_dates_allowed VARCHAR2(1);
l_update_proj_status_allowed VARCHAR2(1);
l_update_proj_manager_allowed VARCHAR2(1);
l_update_proj_org_allowed VARCHAR2(1);
l_delete_task_allowed VARCHAR2(1);
l_update_task_num_allowed VARCHAR2(1);
l_update_task_name_allowed VARCHAR2(1);
l_update_task_dates_allowed VARCHAR2(1);
l_update_task_desc_allowed VARCHAR2(1);
l_update_parent_task_allowed VARCHAR2(1);
l_update_task_org_allowed VARCHAR2(1);
SELECT TASK_ID,
TOP_TASK_ID,
PARENT_TASK_ID,
ADDRESS_ID,
'N', -- READY_TO_BILL_FLAG
'N', -- READY_TO_DISTRIBUTE_FLAG
CARRYING_OUT_ORGANIZATION_ID,
SERVICE_TYPE_CODE,
TASK_MANAGER_PERSON_ID,
'Y', -- CHARGEABLE_FLAG
BILLABLE_FLAG,
'N', -- LIMIT_TO_TXN_CONTROLS_FLAG
START_DATE,
COMPLETION_DATE,
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,
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_TYPE,
PROJECT_RATE_DATE,
CC_PROCESS_LABOR_FLAG,
LABOR_TP_SCHEDULE_ID,
LABOR_TP_FIXED_DATE,
CC_PROCESS_NL_FLAG,
NL_TP_SCHEDULE_ID,
NL_TP_FIXED_DATE,
'N', -- RECEIVE_PROJECT_INVOICE_FLAG
WORK_TYPE_ID,
JOB_BILL_RATE_SCHEDULE_ID,
EMP_BILL_RATE_SCHEDULE_ID,
-- HY TASK_TYPE_CODE,
-- HY PRIORITY_CODE,
-- HY CRITICAL_FLAG,
-- HY MILESTONE_FLAG,
-- HY ESTIMATED_START_DATE,
-- HY ESTIMATED_END_DATE,
SCHEDULED_START_DATE,
SCHEDULED_FINISH_DATE,
-- HY ESTIMATE_TO_COMPLETE_WORK,
-- HY SCHEDULED_WORK,
-- HY WORK_UNIT_CODE,
-- HY PROGRESS_STATUS_CODE,
WBS_LEVEL,
-- HY inc_proj_progress_flag,
taskfunc_cost_rate_type,
taskfunc_cost_rate_date,
non_lab_std_bill_rt_sch_id,
labor_disc_reason_code,
non_labor_disc_reason_code,
--PA L Capital Project changes 2872708
retirement_cost_flag,
cint_eligible_flag,
cint_stop_date,
--End PA L Capital Project changes 2872708
/*FPM development for Project Setup */
customer_id,
revenue_accrual_method,
invoice_method,
GEN_ETC_SOURCE_CODE
FROM PA_TASKS
WHERE TASK_ID = p_reference_task_id;
SELECT T.TASK_ID,
T.TOP_TASK_ID,
T.PARENT_TASK_ID,
T.ADDRESS_ID,
'N',
'N',
T.CARRYING_OUT_ORGANIZATION_ID,
T.SERVICE_TYPE_CODE,
T.TASK_MANAGER_PERSON_ID,
'Y', -- CHARGEABLE_FLAG
T.BILLABLE_FLAG,
'N', -- LIMIT_TO_TXN_CONTROLS_FLAG
T.START_DATE,
T.COMPLETION_DATE,
T.LABOR_BILL_RATE_ORG_ID,
T.LABOR_STD_BILL_RATE_SCHDL,
T.LABOR_SCHEDULE_FIXED_DATE,
T.LABOR_SCHEDULE_DISCOUNT,
T.NON_LABOR_BILL_RATE_ORG_ID,
T.NON_LABOR_STD_BILL_RATE_SCHDL,
T.NON_LABOR_SCHEDULE_FIXED_DATE,
T.NON_LABOR_SCHEDULE_DISCOUNT,
T.COST_IND_RATE_SCH_ID,
T.REV_IND_RATE_SCH_ID,
T.INV_IND_RATE_SCH_ID,
T.COST_IND_SCH_FIXED_DATE,
T.REV_IND_SCH_FIXED_DATE,
T.INV_IND_SCH_FIXED_DATE,
T.LABOR_SCH_TYPE,
T.NON_LABOR_SCH_TYPE,
T.ALLOW_CROSS_CHARGE_FLAG,
T.PROJECT_RATE_TYPE,
T.PROJECT_RATE_DATE,
T.CC_PROCESS_LABOR_FLAG,
T.LABOR_TP_SCHEDULE_ID,
T.LABOR_TP_FIXED_DATE,
T.CC_PROCESS_NL_FLAG,
T.NL_TP_SCHEDULE_ID,
T.NL_TP_FIXED_DATE,
'N', -- RECEIVE_PROJECT_INVOICE_FLAG
T.WORK_TYPE_ID,
T.JOB_BILL_RATE_SCHEDULE_ID,
T.EMP_BILL_RATE_SCHEDULE_ID,
-- HY T.TASK_TYPE_CODE,
-- HY T.PRIORITY_CODE,
-- HY T.CRITICAL_FLAG,
-- HY T.MILESTONE_FLAG,
-- HY T.ESTIMATED_START_DATE,
-- HY T.ESTIMATED_END_DATE,
T.SCHEDULED_START_DATE,
T.SCHEDULED_FINISH_DATE,
-- HY T.ESTIMATE_TO_COMPLETE_WORK,
-- HY T.SCHEDULED_WORK,
-- HY T.WORK_UNIT_CODE,
-- HY T.PROGRESS_STATUS_CODE,
T.WBS_LEVEL,
-- HY T.inc_proj_progress_flag,
T.taskfunc_cost_rate_type,
T.taskfunc_cost_rate_date,
T.non_lab_std_bill_rt_sch_id,
T.labor_disc_reason_code,
T.non_labor_disc_reason_code,
--bug 3032842
--PA L Capital Project changes 2872708
retirement_cost_flag,
cint_eligible_flag,
cint_stop_date,
--End PA L Capital Project changes 2872708
--end bug 3032842
/*FPM development for Project Setup */
T.customer_id,
T.revenue_accrual_method,
T.invoice_method,
T.GEN_ETC_SOURCE_CODE
FROM PA_TASKS T
WHERE T.TASK_ID =
(SELECT T2.PARENT_TASK_ID
FROM PA_TASKS T2
WHERE T2.TASK_ID = p_reference_task_id);
select
NULL,
NULL,
NULL,
NULL,
'Y',
'Y',
pa.carrying_out_organization_id,
pt.SERVICE_TYPE_CODE,--service_type_code,
pt.project_type_class_code, -- Project Type class code
NULL,
'Y',
'N',
'N',
pa.start_date,
pa.completion_date,
pa.labor_bill_rate_org_id,
pa.labor_std_bill_rate_schdl,
pa.labor_schedule_fixed_date,
pa.labor_schedule_discount,
pa.non_labor_bill_rate_org_id,
pa.non_labor_std_bill_rate_schdl,
pa.non_labor_schedule_fixed_date,
pa.non_labor_schedule_discount,
pa.cost_ind_rate_sch_id,
pa.rev_ind_rate_sch_id,
pa.inv_ind_rate_sch_id,
pa.cost_ind_sch_fixed_date,
pa.rev_ind_sch_fixed_date,
pa.inv_ind_sch_fixed_date,
pa.labor_sch_type,
pa.non_labor_sch_type,
pa.allow_cross_charge_flag,
pa.project_rate_type,
pa.project_rate_date,
pa.cc_process_labor_flag,
pa.labor_tp_schedule_id,
pa.labor_tp_fixed_date,
pa.cc_process_nl_flag,
pa.nl_tp_schedule_id,
nl_tp_fixed_date,
'N',
pa.work_type_id,
pa.job_bill_rate_schedule_id,
pa.emp_bill_rate_schedule_id,
NULL,
NULL,
'N',
'N',
NULL,
NULL,
NULL,
NULL,
NULL,
NULL,
NULL,
NULL,
1, --WBS_LEVEL
--bug 3032842
--PA L Capital Project changes 2872708
'N', --retirment_flag
decode( template_flag, 'N', 'N', 'Y' ), --cint_eligible_flag
/*FPM development for Project Setup */
pa.revenue_accrual_method,
pa.Invoice_method,
--End PA L Capital Project changes 2872708
NULL,
--end bug 3032842
pa.Non_lab_std_bill_rt_sch_id -- Added for bug 4963525.
FROM PA_PROJECTS_ALL pa,
PA_PROJECT_TYPES_ALL pt
WHERE pa.PROJECT_ID = p_project_id and
pa.PROJECT_TYPE = pt.PROJECT_TYPE and
pa.ORG_ID = pt.ORG_ID;--MOAC Changes: Bug 4363092 : removed nvl usage with org_id
SELECT WORK_TYPE_ID, PROJECT_TYPE, CARRYING_OUT_ORGANIZATION_ID
FROM PA_PROJECTS_ALL
WHERE PROJECT_ID = p_project_id;
SELECT WORK_TYPE_ID
FROM PA_PROJECT_TYPES
WHERE PROJECT_TYPE = v_project_type; */
SELECT PT.WORK_TYPE_ID
FROM PA_PROJECT_TYPES_ALL PT, PA_PROJECTS_ALL PA
WHERE PT.PROJECT_TYPE = v_project_type
and PA.PROJECT_ID = p_project_id
and PA.ORG_ID = PT.ORG_ID;
SELECT BILLABLE_CAPITALIZABLE_FLAG
FROM PA_WORK_TYPES_VL
WHERE WORK_TYPE_ID = v_work_type_id;
SELECT customer_id from pa_project_customers
where project_id=p_project_id
and default_top_task_cust_flag ='Y';
p_delete_project_allowed => l_delete_project_allowed,
p_update_proj_num_allowed => l_update_proj_num_allowed,
p_update_proj_name_allowed => l_update_proj_name_allowed,
p_update_proj_desc_allowed => l_update_proj_desc_allowed,
p_update_proj_dates_allowed => l_update_proj_dates_allowed,
p_update_proj_status_allowed => l_update_proj_status_allowed,
p_update_proj_manager_allowed => l_update_proj_manager_allowed,
p_update_proj_org_allowed => l_update_proj_org_allowed,
p_add_task_allowed => l_add_task_allowed,
p_delete_task_allowed => l_delete_task_allowed,
p_update_task_num_allowed => l_update_task_num_allowed,
p_update_task_name_allowed => l_update_task_name_allowed,
p_update_task_dates_allowed => l_update_task_dates_allowed,
p_update_task_desc_allowed => l_update_task_desc_allowed,
p_update_parent_task_allowed => l_update_parent_task_allowed,
p_update_task_org_allowed => l_update_task_org_allowed,
p_error_code => l_err_code,
p_error_stack => l_err_stack,
p_error_stage => l_err_stage
);
p_update_start_date_flag => l_f1,
p_update_end_date_flag => l_f2,
p_return_status => l_ret);
select PA_TASKS_S.NEXTVAL INTO l_new_task_id from sys.dual;
/* select adj_on_std_inv into l_adj_on_std_inv from pa_projects_all where project_id =p_project_id;
select adj_on_std_inv into l_adj_on_std_inv from pa_tasks where task_id =l_top_task_id;
PA_TASKS_PKG.insert_row(
l_rowid,
l_new_task_id,
p_project_id,
p_task_number,
sysdate,
FND_GLOBAL.USER_ID, -- created_by
sysdate,
FND_GLOBAL.USER_ID, -- Last_Updated_By
FND_GLOBAL.USER_ID, -- Last_Update_Login
p_task_name,
p_long_task_name,
l_top_task_id,
TWBS_LEVEL,
TREADY_TO_BILL_FLAG,
TREADY_TO_DISTRIBUTE_FLAG,
l_parent_task_Id,
TDESCRIPTION,
TCARRYING_OUT_ORG_ID,
TSERVICE_TYPE_CODE,
p_task_manager_person_id,
TCHARGEABLE,
TBILLABLE,
TLIMIT_TO_TXN_CONTROLS_FLAG,
TSTART_DATE,
TCOMPLETION_DATE,
TADDRESS_ID,
TLABOR_BILL_RATE_ORG_ID,
TLABOR_STD_BILL_RATE_SCHDL,
TLABOR_SCHEDULE_FIXED_DATE,
TLABOR_SCHEDULE_DISCOUNT,
TNLR_BILL_RATE_ORG_ID,
TNLR_STD_BILL_RATE_SCHDL,
TNLR_SCHEDULE_FIXED_DATE,
TNLR_SCHEDULE_DISCOUNT,
TLABOR_COST_MULTIPLIER_NAME, -- Labor_Cost_Multiplier_Name
TATTRIBUTE_CATEGORY, -- Attribute_Category
TATTRIBUTE1, -- Attribute1
TATTRIBUTE2, -- Attribute2
TATTRIBUTE3, -- Attribute3
TATTRIBUTE4, -- Attribute4
TATTRIBUTE5, -- Attribute5
TATTRIBUTE6, -- Attribute6
TATTRIBUTE7, -- Attribute7
TATTRIBUTE8, -- Attribute8
TATTRIBUTE9, -- Attribute9
TATTRIBUTE10, -- Attribute10
TCOST_IND_RATE_SCH_ID,
TREV_IND_RATE_SCH_ID,
TINV_IND_RATE_SCH_ID,
TCOST_IND_SCH_FIXED_DATE,
TREV_IND_SCH_FIXED_DATE,
TINV_IND_SCH_FIXED_DATE,
TLABOR_SCH_TYPE,
TNLR_SCH_TYPE,
TALLOW_CROSS_CHARGE_FLAG,
TPROJECT_RATE_DATE,
TPROJECT_RATE_TYPE,
TCC_PROCESS_LABOR_FLAG,
TLABOR_TP_SCHEDULE_ID,
TLABOR_TP_FIXED_DATE,
TCC_PROCESS_NL_FLAG,
TNL_TP_SCHEDULE_ID,
TNL_TP_FIXED_DATE,
TRECEIVE_PROJECT_INVOICE_FLAG,
TWORK_TYPE_ID,
TJOB_BILL_RATE_SCHEDULE_ID,
TEMP_BILL_RATE_SCHEDULE_ID,
/*TTASK_TYPE_CODE,
l_sequence_number, --DISPLAY SEQUENCE
TPRIORITY_CODE,
TCRITICAL_FLAG,
TMILESTONE_FLAG,
TSCHEDULED_START_DATE,
TSCHEDULED_FINISH_DATE,
TACTUAL_START_DATE, -- Actual Start Date
TACTUAL_FINISH_DATE, -- Actual Finish Date
TESTIMATED_START_DATE,
TESTIMATED_END_DATE,
TBASELINE_START_DATE,
TBASELINE_END_DATE,
TOBLIGATION_START_DATE,
TOBLIGATION_END_DATE,
TESTIMATE_TO_COMPLETE_WORK,
TBASELINE_WORK,
TSCHEDULED_WORK,
TACTUAL_WORK_TO_DATE,
TWORK_UNIT_CODE,
TPROGRESS_STATUS_CODE,
Tinc_proj_progress_flag,
1, --Record version Number */
ttaskfunc_cost_rate_type,
ttaskfunc_cost_rate_date,
tnon_lab_std_bill_rt_sch_id,
Tlabor_disc_reason_code,
Tnon_labor_disc_reason_code,
--PA L Capital Project Changes 2872708
NVL( tretirement_cost_flag, 'N'),
NVL( tcint_eligible_flag, 'N'),
tcint_stop_date,
--End PA L Capital Project Changes 2872708
/*FPM development for Project Setup */
l_customer_id,
l_revenue_accrual_method,
l_invoice_method,
TGEN_ETC_SOURCE_CODE,
l_adj_on_std_inv /* Added for 12.2Payroll billing ER 11899223 */
);
UPDATE PA_TASKS
SET
CHARGEABLE_FLAG = 'N',
RECEIVE_PROJECT_INVOICE_FLAG = 'N',
RECORD_VERSION_NUMBER = nvl(RECORD_VERSION_NUMBER,0)+1,
last_updated_by = FND_GLOBAL.USER_ID,
last_update_login = FND_GLOBAL.USER_ID,
last_update_date = sysdate
WHERE TASK_ID = l_parent_task_Id;
procedure UPDATE_TASK
(
p_api_version IN NUMBER := 1.0
,p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE
,p_commit IN VARCHAR2 := FND_API.G_FALSE
,p_validate_only IN VARCHAR2 := FND_API.G_TRUE
,p_validation_level IN VARCHAR2 := 100
,p_calling_module IN VARCHAR2 := 'SELF_SERVICE'
,p_debug_mode IN VARCHAR2 := 'N'
,p_project_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
,p_task_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
,p_task_number IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
,p_task_name IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
,p_long_task_name IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
,p_task_description IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
,p_task_manager_person_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
,p_carrying_out_organization_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
,p_task_type_code IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
,p_priority_code IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
,p_work_type_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
,p_service_type_code IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
,p_milestone_flag IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
,p_critical_flag IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
,p_chargeable_flag IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
,p_billable_flag IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
,p_receive_project_invoice_flag IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
,p_scheduled_start_date IN DATE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE
,p_scheduled_finish_date IN DATE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE
,p_estimated_start_date IN DATE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE
,p_estimated_end_date IN DATE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE
,p_actual_start_date IN DATE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE
,p_actual_finish_date IN DATE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE
,p_task_start_date IN DATE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE
,p_task_completion_date IN DATE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE
,p_baseline_start_date IN DATE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE
,p_baseline_end_date IN DATE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE
,p_obligation_start_date IN DATE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE
,p_obligation_end_date IN DATE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE
,p_estimate_to_complete_work IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
,p_baseline_work IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
,p_scheduled_work IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
,p_actual_work_to_date IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
,p_work_unit IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
,p_progress_status_code IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
,p_job_bill_rate_schedule_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
,p_emp_bill_rate_schedule_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
,p_pm_product_code IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
,p_pm_project_reference IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
,p_pm_task_reference IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
,p_pm_parent_task_reference IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
,p_top_task_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
,p_wbs_level IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
,p_parent_task_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
,p_display_sequence IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
,p_address_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
,p_ready_to_bill_flag IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
,p_ready_to_distribute_flag IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
,p_limit_to_txn_controls_flag IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
,p_labor_bill_rate_org_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
,p_labor_std_bill_rate_schdl IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
,p_labor_schedule_fixed_date IN DATE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE
,p_labor_schedule_discount IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
,p_nl_bill_rate_org_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
,p_nl_std_bill_rate_schdl IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
,p_nl_schedule_fixed_date IN DATE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE
,p_nl_schedule_discount IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
,p_labor_cost_multiplier_name IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
,p_cost_ind_rate_sch_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
,p_rev_ind_rate_sch_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
,p_inv_ind_rate_sch_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
,p_cost_ind_sch_fixed_date IN DATE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE
,p_rev_ind_sch_fixed_date IN DATE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE
,p_inv_ind_sch_fixed_date IN DATE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE
,p_labor_sch_type IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
,p_nl_sch_type IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
,p_early_start_date IN DATE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE
,p_early_finish_date IN DATE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE
,p_late_start_date IN DATE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE
,p_late_finish_date IN DATE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE
,p_attribute_category IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
,p_attribute1 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
,p_attribute2 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
,p_attribute3 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
,p_attribute4 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
,p_attribute5 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
,p_attribute6 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
,p_attribute7 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
,p_attribute8 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
,p_attribute9 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
,p_attribute10 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
,p_allow_cross_charge_flag IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
,p_project_rate_date IN DATE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE
,p_project_rate_type IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
,p_cc_process_labor_flag IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
,p_labor_tp_schedule_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
,p_labor_tp_fixed_date IN DATE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE
,p_cc_process_nl_flag IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
,p_nl_tp_schedule_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
,p_nl_tp_fixed_date IN DATE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE
,p_inc_proj_progress_flag IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
,p_taskfunc_cost_rate_type IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
,p_taskfunc_cost_rate_date IN DATE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE
,p_non_lab_std_bill_rt_sch_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
,p_record_version_number IN NUMBER
,p_comments IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
,p_labor_disc_reason_code IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
,p_non_labor_disc_reason_code IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
--PA L Capital Project Changes 2872708
,p_retirement_cost_flag IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
,p_cint_eligible_flag IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
,p_cint_stop_date IN DATE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE
--End PA L Capital Project Changes 2872708
,p_gen_etc_src_code IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
,p_dates_check IN VARCHAR2 := 'Y' --bug 5665772
,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
,x_msg_count OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
,x_msg_data OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
)
IS
l_rowid VARCHAR2(50);
l_api_name CONSTANT VARCHAR2(30) := 'UPDATE_TASK';
l_delete_project_allowed VARCHAR2(1);
l_update_proj_num_allowed VARCHAR2(1);
l_update_proj_name_allowed VARCHAR2(1);
l_update_proj_desc_allowed VARCHAR2(1);
l_update_proj_dates_allowed VARCHAR2(1);
l_update_proj_status_allowed VARCHAR2(1);
l_update_proj_manager_allowed VARCHAR2(1);
l_update_proj_org_allowed VARCHAR2(1);
l_delete_task_allowed VARCHAR2(1);
l_update_task_num_allowed VARCHAR2(1);
l_update_task_name_allowed VARCHAR2(1);
l_update_task_dates_allowed VARCHAR2(1);
l_update_task_desc_allowed VARCHAR2(1);
l_update_parent_task_allowed VARCHAR2(1);
l_update_task_org_allowed VARCHAR2(1);
SELECT rowid,
TASK_ID,
TASK_NAME, --new
LONG_TASK_NAME, --new
TASK_NUMBER, --new
DESCRIPTION, --new
TOP_TASK_ID,
PARENT_TASK_ID,
ADDRESS_ID,
READY_TO_BILL_FLAG,
READY_TO_DISTRIBUTE_FLAG,
CARRYING_OUT_ORGANIZATION_ID,
SERVICE_TYPE_CODE,
TASK_MANAGER_PERSON_ID,
CHARGEABLE_FLAG,
BILLABLE_FLAG,
LIMIT_TO_TXN_CONTROLS_FLAG,
START_DATE,
COMPLETION_DATE,
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,
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_TYPE,
PROJECT_RATE_DATE,
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,
-- HY TASK_TYPE_CODE,
-- HY PRIORITY_CODE,
-- HY CRITICAL_FLAG,
-- HY MILESTONE_FLAG,
-- HY ESTIMATED_START_DATE,
-- HY ESTIMATED_END_DATE,
SCHEDULED_START_DATE,
SCHEDULED_FINISH_DATE,
-- HY ESTIMATE_TO_COMPLETE_WORK,
-- HY SCHEDULED_WORK,
-- HY WORK_UNIT_CODE,
-- HY PROGRESS_STATUS_CODE,
WBS_LEVEL,
LABOR_COST_MULTIPLIER_NAME,
ATTRIBUTE_CATEGORY,
ATTRIBUTE1,
ATTRIBUTE2,
ATTRIBUTE3,
ATTRIBUTE4,
ATTRIBUTE5,
ATTRIBUTE6,
ATTRIBUTE7,
ATTRIBUTE8,
ATTRIBUTE9,
ATTRIBUTE10,
-- HY inc_proj_progress_flag,
-- HY comments,
-- HY DISPLAY_SEQUENCE
taskfunc_cost_rate_type,
taskfunc_cost_rate_date,
non_lab_std_bill_rt_sch_id,
labor_disc_reason_code,
non_labor_disc_reason_code,
--PA L Capital Project changes 2872708
retirement_cost_flag,
cint_eligible_flag,
cint_stop_date,
--End PA L Capital Project changes 2872708
GEN_ETC_SOURCE_CODE
FROM PA_TASKS
WHERE TASK_ID = p_task_id;
pa_debug.debug('PA_TASKS_MAINT_PVT.UPDATE_TASK BEGIN');
savepoint UPDATE_TASK_PRIVATE;
select PM_PRODUCT_CODE
into t_pm_product_code
from pa_tasks
where task_id = p_task_id;
p_delete_project_allowed => l_delete_project_allowed,
p_update_proj_num_allowed => l_update_proj_num_allowed,
p_update_proj_name_allowed => l_update_proj_name_allowed,
p_update_proj_desc_allowed => l_update_proj_desc_allowed,
p_update_proj_dates_allowed => l_update_proj_dates_allowed,
p_update_proj_status_allowed => l_update_proj_status_allowed,
p_update_proj_manager_allowed => l_update_proj_manager_allowed,
p_update_proj_org_allowed => l_update_proj_org_allowed,
p_add_task_allowed => l_add_task_allowed,
p_delete_task_allowed => l_delete_task_allowed,
p_update_task_num_allowed => l_update_task_num_allowed,
p_update_task_name_allowed => l_update_task_name_allowed,
p_update_task_dates_allowed => l_update_task_dates_allowed,
p_update_task_desc_allowed => l_update_task_desc_allowed,
p_update_parent_task_allowed => l_update_parent_task_allowed,
p_update_task_org_allowed => l_update_task_org_allowed,
p_error_code => l_err_code,
p_error_stack => l_err_stack,
p_error_stage => l_err_stage
);
p_update_start_date_flag => l_f1,
p_update_end_date_flag => l_f2,
p_return_status => l_ret);
select project_type INTO TPROJECT_TYPE
from pa_projects_all
where project_id = p_project_id;
PA_TASKS_PKG.update_row(
l_rowid,
p_task_id,
p_project_id,
TTASK_NUMBER,
sysdate,
FND_GLOBAL.USER_ID,
FND_GLOBAL.USER_ID,
TTASK_NAME,
TLONG_TASK_NAME, --new
TTOP_TASK_ID,
TWBS_LEVEL,
TREADY_TO_BILL_FLAG,
TREADY_TO_DISTRIBUTE_FLAG,
TPARENT_TASK_ID,
TDESCRIPTION,
TCARRYING_OUT_ORG_ID,
TSERVICE_TYPE_CODE,
TTASK_MANAGER_PERSON_ID,
TCHARGEABLE,
TBILLABLE,
TLIMIT_TO_TXN_CONTROLS_FLAG,
TSTART_DATE,
TCOMPLETION_DATE,
TADDRESS_ID,
TLABOR_BILL_RATE_ORG_ID,
TLABOR_STD_BILL_RATE_SCHDL,
TLABOR_SCHEDULE_FIXED_DATE,
TLABOR_SCHEDULE_DISCOUNT,
TNLR_BILL_RATE_ORG_ID,
TNLR_STD_BILL_RATE_SCHDL,
TNLR_SCHEDULE_FIXED_DATE,
TNLR_SCHEDULE_DISCOUNT,
TLABOR_COST_MULTIPLIER_NAME,
TATTRIBUTE_CATEGORY,
TATTRIBUTE1,
TATTRIBUTE2,
TATTRIBUTE3,
TATTRIBUTE4,
TATTRIBUTE5,
TATTRIBUTE6,
TATTRIBUTE7,
TATTRIBUTE8,
TATTRIBUTE9,
TATTRIBUTE10,
TCOST_IND_RATE_SCH_ID,
TREV_IND_RATE_SCH_ID,
TINV_IND_RATE_SCH_ID,
TCOST_IND_SCH_FIXED_DATE,
TREV_IND_SCH_FIXED_DATE,
TINV_IND_SCH_FIXED_DATE,
TLABOR_SCH_TYPE,
TNLR_SCH_TYPE,
TALLOW_CROSS_CHARGE_FLAG,
TPROJECT_RATE_DATE,
TPROJECT_RATE_TYPE,
TCC_PROCESS_LABOR_FLAG,
TLABOR_TP_SCHEDULE_ID,
TLABOR_TP_FIXED_DATE,
TCC_PROCESS_NL_FLAG,
TNL_TP_SCHEDULE_ID,
TNL_TP_FIXED_DATE,
TRECEIVE_PROJECT_INVOICE_FLAG,
TWORK_TYPE_ID,
TJOB_BILL_RATE_SCHEDULE_ID,
TEMP_BILL_RATE_SCHEDULE_ID,
/*TTASK_TYPE_CODE,
TDISPLAY_SEQUENCE, --DISPLAY SEQUENCE
TPRIORITY_CODE,
TCRITICAL_FLAG,
TMILESTONE_FLAG,
TSCHEDULED_START_DATE,
TSCHEDULED_FINISH_DATE,
TACTUAL_START_DATE, -- Actual Start Date
TACTUAL_FINISH_DATE, -- Actual Finish Date
TESTIMATED_START_DATE,
TESTIMATED_END_DATE,
TBASELINE_START_DATE,
TBASELINE_END_DATE,
TOBLIGATION_START_DATE,
TOBLIGATION_END_DATE,
TESTIMATE_TO_COMPLETE_WORK,
TBASELINE_WORK,
TSCHEDULED_WORK,
TACTUAL_WORK_TO_DATE,
TWORK_UNIT_CODE,
TPROGRESS_STATUS_CODE,
Tinc_proj_progress_flag,
Tcomments,
p_record_version_number --Record version Number*/
ttaskfunc_cost_rate_type,
ttaskfunc_cost_rate_date,
tnon_lab_std_bill_rt_sch_id,
Tlabor_disc_reason_code,
Tnon_labor_disc_reason_code,
--PA L Capital Project Changes 2872708
tretirement_cost_flag ,
tcint_eligible_flag ,
tcint_stop_date ,
--End PA L Capital Project Changes 2872708
tGEN_ETC_SOURCE_CODE
);
ROLLBACK to UPDATE_TASK_PRIVATE;
ROLLBACK to UPDATE_TASK_PRIVATE;
ROLLBACK to UPDATE_TASK_PRIVATE;
p_procedure_name => 'UPDATE_TASK',
p_error_text => SUBSTRB(SQLERRM,1,240));
END UPDATE_TASK;
procedure DELETE_TASK
(
p_api_version IN NUMBER := 1.0
,p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE
,p_commit IN VARCHAR2 := FND_API.G_FALSE
,p_validate_only IN VARCHAR2 := FND_API.G_TRUE
,p_validation_level IN VARCHAR2 := 100
,p_calling_module IN VARCHAR2 := 'SELF_SERVICE'
,p_debug_mode IN VARCHAR2 := 'N'
,p_task_id IN NUMBER
,p_record_version_number IN NUMBER
,p_called_from_api IN VARCHAR2 := 'ABCD'
,p_bulk_flag IN VARCHAR2 := 'N' -- 4201927
,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
,x_msg_count OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
,x_msg_data OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
)
IS
l_msg_count NUMBER := 0;
l_delete_project_allowed VARCHAR2(1);
l_update_proj_num_allowed VARCHAR2(1);
l_update_proj_name_allowed VARCHAR2(1);
l_update_proj_desc_allowed VARCHAR2(1);
l_update_proj_dates_allowed VARCHAR2(1);
l_update_proj_status_allowed VARCHAR2(1);
l_update_proj_manager_allowed VARCHAR2(1);
l_update_proj_org_allowed VARCHAR2(1);
l_delete_task_allowed VARCHAR2(1);
l_update_task_num_allowed VARCHAR2(1);
l_update_task_name_allowed VARCHAR2(1);
l_update_task_dates_allowed VARCHAR2(1);
l_update_task_desc_allowed VARCHAR2(1);
l_update_parent_task_allowed VARCHAR2(1);
l_update_task_org_allowed VARCHAR2(1);
pa_debug.debug('PA_TASKS_MAINT_PVT.DELETE_TASK BEGIN');
savepoint DELETE_TASK_PRIVATE;
select PM_PRODUCT_CODE, PARENT_TASK_ID
into t_pm_product_code, t_parent_task_id
from pa_tasks
where task_id = p_task_id;
p_delete_project_allowed => l_delete_project_allowed,
p_update_proj_num_allowed => l_update_proj_num_allowed,
p_update_proj_name_allowed => l_update_proj_name_allowed,
p_update_proj_desc_allowed => l_update_proj_desc_allowed,
p_update_proj_dates_allowed => l_update_proj_dates_allowed,
p_update_proj_status_allowed => l_update_proj_status_allowed,
p_update_proj_manager_allowed => l_update_proj_manager_allowed,
p_update_proj_org_allowed => l_update_proj_org_allowed,
p_add_task_allowed => l_add_task_allowed,
p_delete_task_allowed => l_delete_task_allowed,
p_update_task_num_allowed => l_update_task_num_allowed,
p_update_task_name_allowed => l_update_task_name_allowed,
p_update_task_dates_allowed => l_update_task_dates_allowed,
p_update_task_desc_allowed => l_update_task_desc_allowed,
p_update_parent_task_allowed => l_update_parent_task_allowed,
p_update_task_org_allowed => l_update_task_org_allowed,
p_error_code => l_err_code,
p_error_stack => l_err_stack,
p_error_stage => l_err_stage
);
IF (t_pm_product_code IS NOT NULL) AND (l_delete_task_allowed = 'N') THEN
PA_UTILS.ADD_MESSAGE('PA', 'PA_PR_PM_CANNOT_DELETE');
p_msg_name => 'PA_TK_CANT_DELETE_LAST_TASK');
PA_TASK_UTILS.CHECK_DELETE_TASK_OK(x_task_id => p_task_id,
x_err_code => l_err_code,
x_err_stage => l_err_stage,
x_err_stack => l_err_stack);
PA_PROJECT_CORE.Delete_Task(
x_task_id => p_task_id,
x_bulk_flag => p_bulk_flag,
x_err_code => l_err_code,
x_err_stage => l_err_stage,
x_err_stack => l_err_stack);
UPDATE Pa_tasks
SET Chargeable_Flag = 'Y',
RECORD_VERSION_NUMBER = nvl(RECORD_VERSION_NUMBER,0) + 1,
last_updated_by = FND_GLOBAL.USER_ID,
last_update_login = FND_GLOBAL.USER_ID,
last_update_date = sysdate
WHERE TASK_ID = t_parent_task_id;
ROLLBACK to DELETE_TASK_PRIVATE;
ROLLBACK to DELETE_TASK_PRIVATE;
p_procedure_name => 'DELETE_TASK',
p_error_text => SUBSTRB(SQLERRM,1,240));
END DELETE_TASK;
select 'x'
from PA_TASKS
where project_id = p_project_id
for update of record_version_number NOWAIT;
select 'x'
from PA_TASKS
where project_id = p_project_id;
SELECT task_id, wbs_level, record_version_number
FROM pa_tasks
START WITH task_id = p_task_id
CONNECT BY PRIOR task_id = parent_task_id;
/* SELECT task_id, top_task_id
FROM pa_tasks
WHERE wbs_level = p_wbs_level
AND top_task_id = p_top_task_id_above
AND display_sequence = ( SELECT max( display_sequence )
FROM pa_tasks
WHERE top_task_id = p_top_task_id_above
AND wbs_level = p_wbs_level
AND display_sequence < p_display_sequence );*/
SELECT task_id, top_task_id
FROM pa_tasks pt, pa_proj_element_versions ppev
WHERE pt.wbs_level = p_wbs_level
AND top_task_id = p_top_task_id_above
AND pt.task_id = ppev.proj_element_id
AND ppev.display_sequence = ( SELECT max( ppev.display_sequence )
FROM pa_tasks pt, pa_proj_element_versions ppev
WHERE top_task_id = p_top_task_id_above
AND pt.wbs_level = p_wbs_level
AND ppev.proj_element_id = pt.task_id
AND ppev.display_sequence < p_display_sequence );
PA_TASKS_MAINT_PVT.UPDATE_TASK
(
p_commit => p_commit
,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_project_id => p_project_id
,p_task_id => p_task_id
,p_parent_task_id => l_task_id_above
,p_record_version_number => p_record_version_number
,x_return_status => x_return_status
,x_msg_count => x_msg_count
,x_msg_data => x_msg_data );
UPDATE PA_TASKS SET CHARGEABLE_FLAG='N'
WHERE TASK_ID = l_task_id_above;
PA_TASKS_MAINT_PVT.UPDATE_TASK
(
p_commit => p_commit
,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_project_id => p_project_id
,p_task_id => cur_task_heirarchy_rec.task_id
,p_wbs_level => cur_task_heirarchy_rec.wbs_level + 1
--3) update the top task id of the indenting task including its children with the top task id of the task above.
,p_top_task_id => l_top_task_id_above
,p_record_version_number => cur_task_heirarchy_rec.record_version_number
,x_return_status => x_return_status
,x_msg_count => x_msg_count
,x_msg_data => x_msg_data );
PA_TASKS_MAINT_PVT.UPDATE_TASK
(
p_commit => p_commit
,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_project_id => p_project_id
,p_task_id => p_task_id
,p_parent_task_id => l_new_parent_id
,p_record_version_number => p_record_version_number
,x_return_status => x_return_status
,x_msg_count => x_msg_count
,x_msg_data => x_msg_data );
PA_TASKS_MAINT_PVT.UPDATE_TASK
(
p_commit => p_commit
,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_project_id => p_project_id
,p_task_id => cur_task_heirarchy_rec.task_id
,p_wbs_level => cur_task_heirarchy_rec.wbs_level + 1
,p_top_task_id => l_top_task_id_above
,p_record_version_number => cur_task_heirarchy_rec.record_version_number
,x_return_status => x_return_status
,x_msg_count => x_msg_count
,x_msg_data => x_msg_data );
select 'x'
from PA_TASKS
where project_id = p_project_id
for update of record_version_number NOWAIT;
select 'x'
from PA_TASKS
where project_id = p_project_id;
SELECT task_id, wbs_level, record_version_number
FROM pa_tasks
START WITH task_id = p_task_id
CONNECT BY PRIOR task_id = parent_task_id;
/*SELECT task_id, record_version_number
FROM pa_tasks
WHERE top_task_id = p_top_task_id
AND display_sequence > p_display_sequence;*/
SELECT pt.task_id, pt.record_version_number
FROM pa_tasks pt, pa_proj_element_versions ppev
WHERE top_task_id = p_top_task_id
AND pt.task_id = ppev.proj_element_id
AND ppev.display_sequence >= p_display_sequence; --bug 2968468
/* SELECT task_id, record_version_number
FROM pa_tasks
WHERE wbs_level = p_wbs_level
AND parent_task_id = l_parent_task_id
AND project_id = p_project_id
AND display_sequence > p_display_sequence;*/
SELECT pt.task_id, pt.record_version_number
FROM pa_tasks pt, pa_proj_element_versions ppev
WHERE pt.wbs_level = p_wbs_level
AND parent_task_id = l_parent_task_id
AND pt.project_id = p_project_id
AND pt.task_id = ppev.proj_element_id
AND ppev.display_sequence > p_display_sequence;
SELECT parent_task_id, top_task_id
FROM pa_tasks
WHERE wbs_level = p_wbs_level
AND project_id = p_project_id
AND top_task_id = p_top_task_id_above;
PA_TASKS_MAINT_PVT.UPDATE_TASK
(
p_commit => p_commit
,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_project_id => p_project_id
,p_task_id => p_task_id
,p_parent_task_id => l_parent_task_id_above
,p_record_version_number => p_record_version_number
,x_return_status => x_return_status
,x_msg_count => x_msg_count
,x_msg_data => x_msg_data );
PA_TASKS_MAINT_PVT.UPDATE_TASK
(
p_commit => p_commit
,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_project_id => p_project_id
,p_task_id => cur_task_heirarchy_rec.task_id
,p_wbs_level => cur_task_heirarchy_rec.wbs_level - 1
,p_record_version_number => cur_task_heirarchy_rec.record_version_number
,x_return_status => x_return_status
,x_msg_count => x_msg_count
,x_msg_data => x_msg_data );
PA_TASKS_MAINT_PVT.UPDATE_TASK
(
p_commit => p_commit
,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_project_id => p_project_id
,p_task_id => cur_all_tasks_rec.task_id
,p_top_task_id => p_task_id
,p_record_version_number => cur_all_tasks_rec.record_version_number
,x_return_status => x_return_status
,x_msg_count => x_msg_count
,x_msg_data => x_msg_data );
PA_TASKS_MAINT_PVT.UPDATE_TASK
(
p_commit => p_commit
,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_project_id => p_project_id
,p_task_id => cur_new_child_task_rec.task_id
,p_parent_task_id => p_task_id
,p_record_version_number => cur_new_child_task_rec.record_version_number
,x_return_status => x_return_status
,x_msg_count => x_msg_count
,x_msg_data => x_msg_data );
PA_TASKS_MAINT_PVT.UPDATE_TASK
(
p_commit => p_commit
,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_project_id => p_project_id
,p_task_id => p_task_id
,p_parent_task_id => l_new_parent_id
,p_top_task_id => l_new_top_id
,p_record_version_number => p_record_version_number
,x_return_status => x_return_status
,x_msg_count => x_msg_count
,x_msg_data => x_msg_data );
PA_TASKS_MAINT_PVT.UPDATE_TASK
(
p_commit => p_commit
,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_project_id => p_project_id
,p_task_id => cur_task_heirarchy_rec.task_id
,p_wbs_level => cur_task_heirarchy_rec.wbs_level - 1
,p_record_version_number => cur_task_heirarchy_rec.record_version_number
,x_return_status => x_return_status
,x_msg_count => x_msg_count
,x_msg_data => x_msg_data );
PA_TASKS_MAINT_PVT.UPDATE_TASK
(
p_commit => p_commit
,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_project_id => p_project_id
,p_task_id => cur_new_child_task_rec.task_id
,p_parent_task_id => p_task_id
,p_top_task_id => l_new_top_id
,p_record_version_number => cur_new_child_task_rec.record_version_number
,x_return_status => x_return_status
,x_msg_count => x_msg_count
,x_msg_data => x_msg_data );
PA_TASKS_MAINT_PVT.UPDATE_TASK
(
p_commit => p_commit
,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_project_id => p_project_id
,p_task_id => p_task_id
,p_parent_task_id => l_new_parent_id
,p_record_version_number => p_record_version_number
,x_return_status => x_return_status
,x_msg_count => x_msg_count
,x_msg_data => x_msg_data );
PA_TASKS_MAINT_PVT.UPDATE_TASK
(
p_commit => p_commit
,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_project_id => p_project_id
,p_task_id => cur_task_heirarchy_rec.task_id
,p_wbs_level => cur_task_heirarchy_rec.wbs_level - 1
,p_record_version_number => cur_task_heirarchy_rec.record_version_number
,x_return_status => x_return_status
,x_msg_count => x_msg_count
,x_msg_data => x_msg_data );
PA_TASKS_MAINT_PVT.UPDATE_TASK
(
p_commit => p_commit
,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_project_id => p_project_id
,p_task_id => cur_new_child_task_rec.task_id
,p_parent_task_id => p_task_id
,p_record_version_number => cur_new_child_task_rec.record_version_number
,x_return_status => x_return_status
,x_msg_count => x_msg_count
,x_msg_data => x_msg_data );
PA_TASKS_MAINT_PVT.UPDATE_TASK
(
p_commit => p_commit
,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_project_id => p_project_id
,p_task_id => p_task_id
,p_parent_task_id => null
-- updating the outdenting top task with p_task id
,p_top_task_id => p_task_id
,p_record_version_number => p_record_version_number
,x_return_status => x_return_status
,x_msg_count => x_msg_count
,x_msg_data => x_msg_data );
PA_TASKS_MAINT_PVT.UPDATE_TASK
(
p_commit => p_commit
,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_project_id => p_project_id
,p_task_id => cur_new_child_task_rec.task_id
,p_parent_task_id => p_task_id
-- updating the new child top tas with p_task id
,p_top_task_id => p_task_id
,p_record_version_number => cur_new_child_task_rec.record_version_number
,x_return_status => x_return_status
,x_msg_count => x_msg_count
,x_msg_data => x_msg_data );
PA_TASKS_MAINT_PVT.UPDATE_TASK
(
p_commit => p_commit
,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_project_id => p_project_id
,p_task_id => cur_task_heirarchy_rec.task_id
,p_top_task_id => p_task_id
,p_record_version_number => cur_task_heirarchy_rec.record_version_number
,x_return_status => x_return_status
,x_msg_count => x_msg_count
,x_msg_data => x_msg_data );
PA_TASKS_MAINT_PVT.UPDATE_TASK
(
p_commit => p_commit
,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_project_id => p_project_id
,p_task_id => cur_task_heirarchy_rec.task_id
,p_wbs_level => cur_task_heirarchy_rec.wbs_level - 1
,p_record_version_number => cur_task_heirarchy_rec.record_version_number
,x_return_status => x_return_status
,x_msg_count => x_msg_count
,x_msg_data => x_msg_data );
PA_TASKS_MAINT_PVT.UPDATE_TASK
(
p_commit => p_commit
,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_project_id => p_project_id
,p_task_id => cur_task_heirarchy_rec.task_id
,p_top_task_id => p_task_id
,p_record_version_number => cur_task_heirarchy_rec.record_version_number
,x_return_status => x_return_status
,x_msg_count => x_msg_count
,x_msg_data => x_msg_data );
/* SELECT *
FROM pa_tasks pt
WHERE project_id = p_project_id
ORDER BY display_sequence;*/
SELECT pt.task_number, pt.task_name, pt.long_task_name, pt.description, pt.carrying_out_organization_id,
pt.work_type_id, pt.service_type_code,
pt.chargeable_flag, pt.billable_flag, pt.receive_project_invoice_flag,
pt.scheduled_start_date, pt.scheduled_finish_date, pt.start_date,
pt.wbs_level, pt.task_id, ppev.display_sequence
FROM pa_tasks pt, pa_proj_element_versions ppev
WHERE pt.project_id = p_project_id
AND pt.task_id = ppev.proj_element_id
ORDER BY ppev.display_sequence;
SELECT *
FROM pa_tasks
WHERE project_id = p_reference_project_id
AND task_id = p_reference_task_id;
SELECT column_name, data_length
FROM user_synonyms syn, all_tab_columns col
WHERE col.table_name = 'PA_TASKS'
and col.owner = syn.table_owner
and col.table_name = syn.table_name
AND col.owner = c_pa_schema_name
AND column_name IN ( 'TASK_NAME', 'LONG_TASK_NAME', 'TASK_NUMBER' );
/* --Call Update statement to update display order
************************************************************
THIS FUNCTIONALITY IS MOVED TO PA_TASK_PUB1.COPY_TASK API.
************************************************************
BEGIN
-- Need to get max number
SELECT max(display_sequence)
INTO l_max_seq
FROM PA_TASKS
WHERE project_id = p_reference_project_id;
UPDATE PA_TASKS
SET display_sequence =
PA_TASKS_MAINT_UTILS.REARRANGE_DISPLAY_SEQ(display_sequence, l_max_seq, i, 'INSERT', null),
record_version_number = record_version_number + 1
WHERE project_id = p_reference_project_id
AND ( display_sequence > -( l_first_seq + 1 ) or display_sequence < 0 );
PROCEDURE Copy_Selected_Task(
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_reference_project_id IN NUMBER
,p_reference_task_id IN NUMBER
,p_task_id IN NUMBER
,p_peer_or_sub IN VARCHAR2
,p_task_prefix IN VARCHAR2
,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 ) AS --File.Sql.39 bug 4440895
CURSOR cur_select_task
IS
SELECT *
FROM pa_tasks
WHERE task_id = p_task_id;
SELECT *
FROM pa_tasks
WHERE project_id = p_reference_project_id
AND task_id = p_reference_task_id;
SELECT column_name, data_length
FROM user_synonyms syn, all_tab_columns col
WHERE col.table_name = 'PA_TASKS'
and col.owner = syn.table_owner
and col.table_name = syn.table_name
AND col.owner = c_pa_schema_name
AND col.column_name IN ( 'TASK_NAME', 'LONG_TASK_NAME', 'TASK_NUMBER' );
FOR cur_select_task_rec IN cur_select_task LOOP
IF p_peer_or_sub = 'PEER' AND
l_rec_cur_ref_info.wbs_level > 1 ---Not a Top level
THEN
--l_estimated_start_date := cur_select_task_rec.estimated_start_date;
l_estimated_start_date := cur_select_task_rec.scheduled_start_date;
l_estimated_end_date := cur_select_task_rec.scheduled_finish_date;
l_estimated_start_date := cur_select_task_rec.scheduled_start_date;
l_estimated_end_date := cur_select_task_rec.scheduled_finish_date;
IF length( p_task_prefix||cur_select_task_rec.task_number ) > l_task_number_len OR
length( p_task_prefix||cur_select_task_rec.task_name ) > l_task_name_len OR
length( p_task_prefix||cur_select_task_rec.long_task_name ) > l_long_task_name_len
THEN
PA_UTILS.ADD_MESSAGE(p_app_short_name => 'PA',
p_msg_name => 'PA_TASK_PREFIX_TOO_LARGE' );
,p_task_number => p_task_prefix||cur_select_task_rec.task_number
,p_task_name => p_task_prefix||cur_select_task_rec.task_name
,p_long_task_name => p_task_prefix||cur_select_task_rec.long_task_name
,p_task_description => cur_select_task_rec.description
,p_task_manager_person_id => null
,p_carrying_out_organization_id => cur_select_task_rec.carrying_out_organization_id
--,p_task_type_code => cur_select_task_rec.task_type_code
--,p_priority_code => cur_select_task_rec.priority_code
,p_work_type_id => cur_select_task_rec.work_type_id
,p_service_type_code => cur_select_task_rec.service_type_code
--,p_milestone_flag => cur_select_task_rec.milestone_flag
--,p_critical_flag => null
,p_chargeable_flag => cur_select_task_rec.chargeable_flag
,p_billable_flag => cur_select_task_rec.billable_flag
,p_receive_project_invoice_flag => cur_select_task_rec.receive_project_invoice_flag
,p_scheduled_start_date => cur_select_task_rec.scheduled_start_date
,p_scheduled_finish_date => cur_select_task_rec.scheduled_finish_date
,p_estimated_start_date => l_estimated_start_date
,p_estimated_end_date => l_estimated_end_date
,p_actual_start_date => null
,p_actual_finish_date => null
,p_task_start_date => cur_select_task_rec.start_date
--,p_task_completion_date => cur_select_task_rec.end_date
,p_baseline_start_date => null
,p_baseline_end_date => null
,p_estimate_to_complete_work => null
,p_baseline_work => null
-- ,p_scheduled_work => cur_select_task_rec.scheduled_work
,p_actual_work_to_date => null
,p_work_unit => 'Hours'
,p_task_id => l_task_id
,x_display_seq => l_display_seq
,x_return_status => x_return_status
,x_msg_count => x_msg_count
,x_msg_data => x_msg_data );
SELECT max(display_sequence)
INTO l_max_seq
FROM PA_TASKS
WHERE project_id = p_reference_project_id;
UPDATE PA_TASKS
SET display_sequence =
PA_TASKS_MAINT_UTILS.REARRANGE_DISPLAY_SEQ(display_sequence, l_max_seq, 1, 'INSERT', null),
record_version_number = record_version_number + 1
WHERE project_id = p_reference_project_id
AND ( display_sequence > -( l_display_seq + 1 ) or display_sequence < 0 );
p_procedure_name => 'Copy_Selected_Task',
p_error_text => SUBSTRB(SQLERRM,1,240));
p_procedure_name => 'Copy_Selected_Task',
p_error_text => SUBSTRB(SQLERRM,1,240));
END Copy_Selected_Task;
/*SELECT *
FROM pa_tasks
WHERE project_id = p_project_id
START WITH task_id = p_task_id
CONNECT BY PRIOR task_id = parent_task_id
ORDER BY display_sequence; */
SELECT pt.task_number, pt.task_name, pt.long_task_name, pt.description, pt.carrying_out_organization_id,
pt.work_type_id, pt.service_type_code,
pt.chargeable_flag, pt.billable_flag, pt.receive_project_invoice_flag,
pt.scheduled_start_date, pt.scheduled_finish_date, pt.start_date,
pt.wbs_level, pt.task_id, ppev.display_sequence
FROM
( SELECT task_id, task_number, task_name, long_task_name, description,carrying_out_organization_id,
work_type_id, service_type_code,
chargeable_flag, billable_flag, receive_project_invoice_flag,
scheduled_start_date, scheduled_finish_date, start_date,
wbs_level
FROM pa_tasks
WHERE project_id = p_project_id
START WITH task_id = p_task_id
CONNECT BY PRIOR task_id = parent_task_id ) pt,
pa_proj_element_versions ppev
WHERE pt.task_id = ppev.proj_element_id
ORDER BY ppev.display_sequence;
SELECT *
FROM pa_tasks
WHERE project_id = p_reference_project_id
AND task_id = p_reference_task_id;
SELECT column_name, data_length
FROM user_synonyms syn, all_tab_columns col
WHERE col.table_name = 'PA_TASKS'
and col.owner = syn.table_owner
and col.table_name = syn.table_name
AND col.owner = c_pa_schema_name
AND col.column_name IN ( 'TASK_NAME', 'LONG_TASK_NAME', 'TASK_NUMBER' );
SELECT max(display_sequence)
INTO l_max_seq
FROM PA_TASKS
WHERE project_id = p_reference_project_id;
UPDATE PA_TASKS
SET display_sequence =
PA_TASKS_MAINT_UTILS.REARRANGE_DISPLAY_SEQ(display_sequence, l_max_seq, i, 'INSERT', null),
record_version_number = record_version_number + 1
WHERE project_id = p_reference_project_id
AND ( display_sequence > -( l_first_seq + 1 ) or display_sequence < 0 );
/* SELECT task_id, display_sequence, top_task_id, parent_task_id, wbs_level, record_version_number
FROM pa_tasks
WHERE project_id = p_project_id
START WITH task_id = p_task_id
CONNECT BY PRIOR task_id = parent_task_id
ORDER BY display_sequence;*/
SELECT pt.task_id, ppev.display_sequence, pt.top_task_id, pt.parent_task_id, pt.wbs_level, pt.record_version_number
FROM
( SELECT task_id, top_task_id, parent_task_id, wbs_level, record_version_number
FROM pa_tasks
WHERE project_id = p_project_id
START WITH task_id = p_task_id
CONNECT BY PRIOR task_id = parent_task_id ) pt, pa_proj_element_versions ppev
WHERE pt.task_id = ppev.proj_element_id
ORDER BY ppev.display_sequence;
/* SELECT *
FROM pa_tasks
WHERE project_id = p_reference_project_id
START WITH task_id = p_reference_task_id
CONNECT BY PRIOR task_id = parent_task_id
ORDER BY display_sequence;*/
SELECT pt.top_task_id, pt.parent_task_id, pt.wbs_level, ppev.display_sequence
FROM
( SELECT task_id, top_task_id, parent_task_id, wbs_level
FROM pa_tasks
WHERE project_id = p_reference_project_id
START WITH task_id = p_reference_task_id
CONNECT BY PRIOR task_id = parent_task_id ) pt, pa_proj_element_versions ppev
WHERE pt.task_id = ppev.proj_element_id
ORDER BY ppev.display_sequence;
SELECT pt.task_id, ppev.display_sequence, pt.top_task_id, pt.parent_task_id, pt.wbs_level, pt.record_version_number
FROM
( SELECT task_id, top_task_id, parent_task_id, wbs_level, record_version_number
FROM pa_tasks
WHERE project_id = p_project_id and task_id = p_task_id ) pt, pa_proj_element_versions ppev
WHERE pt.task_id = ppev.proj_element_id
ORDER BY ppev.display_sequence;
PA_TASKS_MAINT_PVT.UPDATE_TASK
(
p_commit => p_commit
,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_project_id => p_reference_project_id
,p_task_id => cur_tasks_rec.task_id
,p_parent_task_id => l_parent_task_id
,p_top_task_id => l_top_task_id
,p_wbs_level => l_wbs_level
,p_display_sequence => l_display_sequence
,p_record_version_number => cur_tasks_rec.record_version_number
,x_return_status => x_return_status
,x_msg_count => x_msg_count
,x_msg_data => x_msg_data );
UPDATE Pa_tasks
SET Chargeable_Flag = 'N',
RECORD_VERSION_NUMBER = nvl(RECORD_VERSION_NUMBER,0) + 1,
last_updated_by = FND_GLOBAL.USER_ID,
last_update_login = FND_GLOBAL.USER_ID,
last_update_date = sysdate
WHERE TASK_ID = p_reference_task_id;
SELECT max(display_sequence)
INTO l_max_seq
FROM PA_TASKS
WHERE project_id = p_reference_project_id;
UPDATE PA_TASKS
SET display_sequence =
PA_TASKS_MAINT_UTILS.REARRANGE_DISPLAY_SEQ(display_sequence, l_max_seq, i, 'MOVE', l_move_direction ),
record_version_number = record_version_number + 1
WHERE project_id = p_reference_project_id
AND ( ( display_sequence > l_min_display_sequence and
display_sequence <= l_max_display_sequence ) or display_sequence < 0 );
SELECT
proj_element_id
FROM
pa_proj_element_versions
WHERE
project_id = l_project_id
AND
element_version_id = l_task_version_id;
SELECT task_number,task_name --task_number and task_name added for the Bug 14640666
from pa_tasks
WHERE task_id = c_task_id
and project_id = p_project_id;
SELECT proj_element_id
FROM pa_proj_element_versions ppev,
pa_object_relationships por
WHERE ppev.element_version_id=por.object_id_from1
AND por.relationship_type ='S'
AND por.relationship_subtype ='TASK_TO_TASK'
AND por.object_id_to1 = l_object_id_to1;
UPDATE
PA_PROJ_ELEMENT_VERSIONS
SET
financial_task_flag = p_checked_flag
WHERE
element_version_id = p_task_version_id
AND
project_id = p_project_id;
SELECT
proj_element_id
FROM
pa_proj_element_versions
WHERE
element_version_id = l_element_version_id
AND
project_id = l_project_id;
SELECT
name, element_number
FROM
pa_proj_elements
WHERE
proj_element_id = l_element_id
AND
project_id = l_project_id;
SELECT
elever.proj_element_id
FROM
pa_proj_element_versions elever
, pa_object_relationships obRel
WHERE
obRel.relationship_type ='S'
AND
obRel.relationship_subtype ='TASK_TO_TASK'
AND
obRel.OBJECT_ID_TO1 = l_object_id_to1
AND
elever.element_version_id=obRel.OBJECT_ID_FROM1
AND
elever.project_id = l_project_id;
SELECT
elements.name
, elements.element_number
FROM
pa_proj_elements elements
, pa_proj_element_versions elever
WHERE
elever.element_version_id = l_element_version_id
AND
elever.project_id = l_project_id
AND
elements.proj_element_id = elever.proj_element_id
AND
elements.project_id = elever.project_id;
SELECT
record_version_number
FROM
PA_TASKS
WHERE
task_id = l_task_id
AND
project_id = l_project_id;
SELECT
element_version_id
,financial_task_flag
FROM
pa_proj_element_versions
WHERE
parent_structure_version_id = l_structure_version_id
AND
object_type='PA_TASKS'
AND
project_id = l_project_id;
PA_TASKS_MAINT_PUB.DELETE_TASK
(
p_commit => p_commit
, p_init_msg_list => FND_API.G_FALSE
, p_calling_module => p_calling_module
, p_debug_mode => l_debug_mode
, p_project_id => p_project_id
, p_task_id => l_task_id
, p_record_version_number => p_patask_record_version_number
, p_wbs_record_version_number => 1 --parameter not used anywhere in PA_TASKS_MAINT_PUB.DELETE_TASK,pass any dummy value
, x_return_status => x_return_status
, x_msg_count => x_msg_count
, x_msg_data => x_msg_data
);
,p_wbs_record_version_number => 1--parameter not used anywhere in PA_TASKS_MAINT_PUB.DELETE_TASK,pass any dummy value
,p_carrying_out_organization_id => l_carrying_out_organization_id
--,x_display_seq => l_display_seq
,x_return_status => x_return_status
,x_msg_count => x_msg_count
,x_msg_data => x_msg_data
);
PA_TASKS_MAINT_PUB.DELETE_TASK
(
p_commit => p_commit
, p_calling_module => p_calling_module
, p_init_msg_list => FND_API.G_FALSE
, p_debug_mode => l_debug_mode
, p_project_id => p_project_id
, p_task_id => l_task_id
, p_record_version_number => l_patask_record_version_number
--, p_called_from_api => p_called_from_api
, p_wbs_record_version_number => 1 --parameter not used anywhere in PA_TASKS_MAINT_PUB.DELETE_TASK,pass any dummy value
, x_return_status => x_return_status
, x_msg_count => x_msg_count
, x_msg_data => x_msg_data
);
,p_wbs_record_version_number => 1--parameter not used anywhere in PA_TASKS_MAINT_PUB.DELETE_TASK,pass any dummy value
,p_carrying_out_organization_id => l_carrying_out_organization_id
--,x_display_seq => l_display_seq
,x_return_status =>x_return_status
,x_msg_count =>x_msg_count
,x_msg_data =>x_msg_data
);