APPS.PA_PROJECT_CORE dependencies on PA_PROJECTS

Line 110: and object_type = 'PA_PROJECTS');

106: from dual
107: where exists (select object_id
108: from pa_project_parties
109: where object_id = t_project_id
110: and object_type = 'PA_PROJECTS');
111:
112: CURSOR get_template_flag IS
113: SELECT template_flag
114: FROM PA_PROJECTS_ALL

Line 114: FROM PA_PROJECTS_ALL

110: and object_type = 'PA_PROJECTS');
111:
112: CURSOR get_template_flag IS
113: SELECT template_flag
114: FROM PA_PROJECTS_ALL
115: WHERE project_id = x_project_id;
116:
117: -- added for bug#3693197
118: CURSOR get_all_tasks IS

Line 245: WHERE object_type = 'PA_PROJECTS'

241: -- Delete project subteams
242: FOR i IN (SELECT rowid row_id
243: ,project_subteam_id
244: FROM pa_project_subteams
245: WHERE object_type = 'PA_PROJECTS'
246: AND object_id = x_project_id)
247: LOOP
248:
249: PA_PROJECT_SUBTEAMS_PVT.Delete_Subteam

Line 560: ( p_object_type => 'PA_PROJECTS'

556:
557: /* Bug#3480409 : FP.M Changes: Added code for deleting object exceptions, starts here */
558: BEGIN
559: PA_PERF_EXCP_UTILS.delete_object_exceptions
560: ( p_object_type => 'PA_PROJECTS'
561: ,p_object_id => x_project_id
562: ,x_return_status => x_return_status
563: ,x_msg_count => x_msg_count
564: ,x_msg_data => x_msg_data );

Line 909: p_object_type =>'PA_PROJECTS'

905: /* --SMukka Added this plsql block of code
906: BEGIN
907: PA_PERF_EXCP_UTILS.delete_object_exceptions
908: (
909: p_object_type =>'PA_PROJECTS'
910: ,p_object_id =>x_project_id
911: ,x_msg_count =>x_msg_count
912: ,x_msg_data =>x_msg_data
913: ,x_return_status =>x_return_status

Line 1020: p_object_type =>'PA_PROJECTS'

1016: -- Start of Bug 4705154
1017: -- Bug No 4705154:The Following API call is being added to delete entries of project from PA_OBJ_STATUS_CHANGES Table.
1018: PA_CONTROL_ITEMS_UTILS.DELETE_OBJ_STATUS_CHANGES
1019: (
1020: p_object_type =>'PA_PROJECTS'
1021: ,p_object_id => x_project_id
1022: ,x_msg_count =>x_msg_count
1023: ,x_msg_data =>x_msg_data
1024: ,x_return_status =>x_return_status);

Line 1038: delete pa_projects

1034: return;
1035: END IF;
1036: -- End of Bug no 4705154
1037: -- Delete project
1038: delete pa_projects
1039: where project_id = x_project_id;
1040:
1041: x_err_stack := old_stack;
1042:

Line 1237: FROM pa_projects P, pa_project_types PT

1233: P.inv_ind_sch_fixed_date,
1234: PT.service_type_code,
1235: PT.project_type_class_code ,
1236: p.adj_on_std_inv /* Added for 12.2 Payroll billing ER 11847616 */
1237: FROM pa_projects P, pa_project_types PT
1238: WHERE P.project_id = x_project_id
1239: AND P.project_type = PT.project_type;
1240:
1241: begin

Line 1545: FROM pa_projects_all

1541:
1542: --Added for bug 3617393
1543: CURSOR get_template_flag(c_project_id IN NUMBER) IS
1544: SELECT template_flag
1545: FROM pa_projects_all
1546: WHERE project_id = c_project_id;
1547:
1548: cursor cc_task_id_csr(x_taskid number) ---- Bug 6629057
1549: is select cc_tax_task_id from pa_projects_all pj

Line 1549: is select cc_tax_task_id from pa_projects_all pj

1545: FROM pa_projects_all
1546: WHERE project_id = c_project_id;
1547:
1548: cursor cc_task_id_csr(x_taskid number) ---- Bug 6629057
1549: is select cc_tax_task_id from pa_projects_all pj
1550: where pj.project_id = l_project_id;
1551:
1552: l_template_flag VARCHAR2(1) := 'N';
1553: --Added for bug 3617393

Line 1607: update pa_projects_all

1603: if cc_task_id_csr%notfound then
1604: close cc_task_id_csr;
1605: end if;
1606: if(l_cc_tax_task_id = x_task_id) then
1607: update pa_projects_all
1608: set cc_tax_task_id = null
1609: where project_id = l_project_id;
1610: close cc_task_id_csr;
1611: end if;