APPS.PA_PROJ_TEMPLATE_SETUP_PVT dependencies on PA_TASKS

Line 938: PA_TASKS_PKG.Insert_Row(

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

Line 1073: --Creating tasks in pa_proj_elements from pa_tasks

1069: raise FND_API.G_EXC_ERROR;
1070: END IF;
1071:
1072: --Project Structures Changes
1073: --Creating tasks in pa_proj_elements from pa_tasks
1074: PA_PROJ_TASK_STRUC_PUB.CREATE_DEFAULT_TASK_STRUCTURE(
1075: p_project_id => l_template_id
1076: ,p_struc_type => 'FINANCIAL'
1077: ,x_msg_count => l_msg_count

Line 1295: CURSOR cur_pa_tasks IS

1291: ,auto_release_pwp_inv -- 7508661 : EnC
1292: FROM pa_projects_all
1293: WHERE project_id = p_project_id;
1294:
1295: CURSOR cur_pa_tasks IS
1296: SELECT Rev_ind_sch_fixed_date, Inv_ind_sch_fixed_date
1297: FROM pa_tasks
1298: WHERE project_id = p_project_id;
1299:

Line 1297: FROM pa_tasks

1293: WHERE project_id = p_project_id;
1294:
1295: CURSOR cur_pa_tasks IS
1296: SELECT Rev_ind_sch_fixed_date, Inv_ind_sch_fixed_date
1297: FROM pa_tasks
1298: WHERE project_id = p_project_id;
1299:
1300: CURSOR cur_project_type_class
1301: IS

Line 1437: OPEN cur_pa_tasks;

1433: ;
1434:
1435: CLOSE cur_project;
1436:
1437: OPEN cur_pa_tasks;
1438: FETCH cur_pa_tasks INTO l_Rev_ind_sch_fixed_date2, l_Inv_ind_sch_fixed_date2;
1439: CLOSE cur_pa_tasks;
1440:
1441: --Check for not null

Line 1438: FETCH cur_pa_tasks INTO l_Rev_ind_sch_fixed_date2, l_Inv_ind_sch_fixed_date2;

1434:
1435: CLOSE cur_project;
1436:
1437: OPEN cur_pa_tasks;
1438: FETCH cur_pa_tasks INTO l_Rev_ind_sch_fixed_date2, l_Inv_ind_sch_fixed_date2;
1439: CLOSE cur_pa_tasks;
1440:
1441: --Check for not null
1442: PA_PROJ_TEMPLATE_SETUP_UTILS.Check_Template_attr_req(

Line 1439: CLOSE cur_pa_tasks;

1435: CLOSE cur_project;
1436:
1437: OPEN cur_pa_tasks;
1438: FETCH cur_pa_tasks INTO l_Rev_ind_sch_fixed_date2, l_Inv_ind_sch_fixed_date2;
1439: CLOSE cur_pa_tasks;
1440:
1441: --Check for not null
1442: PA_PROJ_TEMPLATE_SETUP_UTILS.Check_Template_attr_req(
1443: p_project_number => p_project_number

Line 2073: UPDATE pa_tasks

2069: OPEN cur_bill_flag( l_work_type_id );
2070: FETCH cur_bill_flag INTO l_billable_flag;
2071: CLOSE cur_bill_flag;
2072:
2073: UPDATE pa_tasks
2074: SET work_type_id = l_work_type_id,
2075: billable_flag = l_billable_flag,
2076: emp_bill_rate_schedule_id = l_emp_bill_rate_schedule_id,
2077: job_bill_rate_schedule_id = l_job_bill_rate_schedule_id,