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 1010: p_object_type =>'PA_PROJECTS'

1006: -- Start of Bug 4705154
1007: -- Bug No 4705154:The Following API call is being added to delete entries of project from PA_OBJ_STATUS_CHANGES Table.
1008: PA_CONTROL_ITEMS_UTILS.DELETE_OBJ_STATUS_CHANGES
1009: (
1010: p_object_type =>'PA_PROJECTS'
1011: ,p_object_id => x_project_id
1012: ,x_msg_count =>x_msg_count
1013: ,x_msg_data =>x_msg_data
1014: ,x_return_status =>x_return_status);

Line 1028: delete pa_projects

1024: return;
1025: END IF;
1026: -- End of Bug no 4705154
1027: -- Delete project
1028: delete pa_projects
1029: where project_id = x_project_id;
1030:
1031: x_err_stack := old_stack;
1032:

Line 1225: FROM pa_projects P, pa_project_types PT

1221: P.inv_ind_rate_sch_id,
1222: P.inv_ind_sch_fixed_date,
1223: PT.service_type_code,
1224: PT.project_type_class_code
1225: FROM pa_projects P, pa_project_types PT
1226: WHERE P.project_id = x_project_id
1227: AND P.project_type = PT.project_type;
1228:
1229: begin

Line 1529: FROM pa_projects_all

1525:
1526: --Added for bug 3617393
1527: CURSOR get_template_flag(c_project_id IN NUMBER) IS
1528: SELECT template_flag
1529: FROM pa_projects_all
1530: WHERE project_id = c_project_id;
1531:
1532: cursor cc_task_id_csr(x_taskid number) ---- Bug 6629057
1533: is select cc_tax_task_id from pa_projects_all pj

Line 1533: is select cc_tax_task_id from pa_projects_all pj

1529: FROM pa_projects_all
1530: WHERE project_id = c_project_id;
1531:
1532: cursor cc_task_id_csr(x_taskid number) ---- Bug 6629057
1533: is select cc_tax_task_id from pa_projects_all pj
1534: where pj.project_id = l_project_id;
1535:
1536: l_template_flag VARCHAR2(1) := 'N';
1537: --Added for bug 3617393

Line 1591: update pa_projects_all

1587: if cc_task_id_csr%notfound then
1588: close cc_task_id_csr;
1589: end if;
1590: if(l_cc_tax_task_id = x_task_id) then
1591: update pa_projects_all
1592: set cc_tax_task_id = null
1593: where project_id = l_project_id;
1594: close cc_task_id_csr;
1595: end if;