APPS.PA_PROJ_TEMPLATE_SETUP_PVT dependencies on PA_TASKS

Line 943: PA_TASKS_PKG.Insert_Row(

939:
940: /* From FPM we will not be creating any default task or structure at the time of template creation
941: Please refer Financial structures in HTML Technical Architecture on files online
942: --bug 3301192
943: PA_TASKS_PKG.Insert_Row(
944: X_Rowid => l_row_id,
945: X_task_id => l_task_id,
946: X_Project_id => l_template_id,
947: X_Task_Number => '1',

Line 1078: --Creating tasks in pa_proj_elements from pa_tasks

1074: raise FND_API.G_EXC_ERROR;
1075: END IF;
1076:
1077: --Project Structures Changes
1078: --Creating tasks in pa_proj_elements from pa_tasks
1079: PA_PROJ_TASK_STRUC_PUB.CREATE_DEFAULT_TASK_STRUCTURE(
1080: p_project_id => l_template_id
1081: ,p_struc_type => 'FINANCIAL'
1082: ,x_msg_count => l_msg_count

Line 1300: CURSOR cur_pa_tasks IS

1296: ,auto_release_pwp_inv -- 7508661 : EnC
1297: FROM pa_projects_all
1298: WHERE project_id = p_project_id;
1299:
1300: CURSOR cur_pa_tasks IS
1301: SELECT Rev_ind_sch_fixed_date, Inv_ind_sch_fixed_date
1302: FROM pa_tasks
1303: WHERE project_id = p_project_id;
1304:

Line 1302: FROM pa_tasks

1298: WHERE project_id = p_project_id;
1299:
1300: CURSOR cur_pa_tasks IS
1301: SELECT Rev_ind_sch_fixed_date, Inv_ind_sch_fixed_date
1302: FROM pa_tasks
1303: WHERE project_id = p_project_id;
1304:
1305: CURSOR cur_project_type_class
1306: IS

Line 1442: OPEN cur_pa_tasks;

1438: ;
1439:
1440: CLOSE cur_project;
1441:
1442: OPEN cur_pa_tasks;
1443: FETCH cur_pa_tasks INTO l_Rev_ind_sch_fixed_date2, l_Inv_ind_sch_fixed_date2;
1444: CLOSE cur_pa_tasks;
1445:
1446: --Check for not null

Line 1443: FETCH cur_pa_tasks INTO l_Rev_ind_sch_fixed_date2, l_Inv_ind_sch_fixed_date2;

1439:
1440: CLOSE cur_project;
1441:
1442: OPEN cur_pa_tasks;
1443: FETCH cur_pa_tasks INTO l_Rev_ind_sch_fixed_date2, l_Inv_ind_sch_fixed_date2;
1444: CLOSE cur_pa_tasks;
1445:
1446: --Check for not null
1447: PA_PROJ_TEMPLATE_SETUP_UTILS.Check_Template_attr_req(

Line 1444: CLOSE cur_pa_tasks;

1440: CLOSE cur_project;
1441:
1442: OPEN cur_pa_tasks;
1443: FETCH cur_pa_tasks INTO l_Rev_ind_sch_fixed_date2, l_Inv_ind_sch_fixed_date2;
1444: CLOSE cur_pa_tasks;
1445:
1446: --Check for not null
1447: PA_PROJ_TEMPLATE_SETUP_UTILS.Check_Template_attr_req(
1448: p_project_number => p_project_number

Line 2078: UPDATE pa_tasks

2074: OPEN cur_bill_flag( l_work_type_id );
2075: FETCH cur_bill_flag INTO l_billable_flag;
2076: CLOSE cur_bill_flag;
2077:
2078: UPDATE pa_tasks
2079: SET work_type_id = l_work_type_id,
2080: billable_flag = l_billable_flag,
2081: emp_bill_rate_schedule_id = l_emp_bill_rate_schedule_id,
2082: job_bill_rate_schedule_id = l_job_bill_rate_schedule_id,