[Home] [Help]
224: -- End of fix 3056424.
225:
226: CURSOR c_awd_project is
227: Select project_id
228: from PA_PROJECTS_ALL
229: where project_type = 'AWARD_PROJECT'
230: and template_flag = 'Y'
231: and (segment1 = 'AWD_PROJ_-999'
232: or segment1 = 'AWD_PROJ_'||TO_CHAR(L_org_id))
1302: Project_Check NUMBER(2) := 0;
1303:
1304: CURSOR C1 is
1305: select decode(NAME, g_award_rec.award_number,1,2)
1306: from PA_PROJECTS
1307: where ( NAME = g_award_rec.award_number
1308: OR SEGMENT1 = g_award_rec.award_number) ;
1309:
1310: cursor C_AWDNUM_DUP is
1981: PROCEDURE CREATE_AWD_PROJ_TEMPLATE_STRUC(X_award_project_id IN Number,
1982: X_return_status OUT NOCOPY VARCHAR2 ) IS
1983:
1984: l_struct_exists varchar2(1) := 'N';
1985: l_awd_proj_temp pa_projects_all%rowtype;
1986: l_msg_count NUMBER;
1987: l_msg_data VARCHAR2(2000);
1988: l_return_status VARCHAR2(1);
1989:
1988: l_return_status VARCHAR2(1);
1989:
1990:
1991: CURSOR c_awd_proj_temp is
1992: Select * from pa_projects_all
1993: where project_id = x_award_project_id;
1994:
1995: CURSOR c_struc_exists is
1996: Select 'Y' from pa_proj_elements
2292: -- Update projects for additional informations.
2293:
2294: --
2295:
2296: Update PA_PROJECTS_ALL
2297: set cost_ind_rate_sch_id = g_award_rec.IDC_Schedule_Id,
2298: cost_ind_sch_fixed_date = g_award_rec.cost_ind_sch_fixed_date,
2299: labor_invoice_format_id = g_award_rec.Labor_Invoice_Format_Id,
2300: non_labor_invoice_format_Id = g_award_rec.Non_Labor_Invoice_Format_Id,
3683: , P_VALIDATE_ONLY => NULL
3684: , P_VALIDATION_LEVEL => 100
3685: , P_DEBUG_MODE => 'N'
3686: , P_OBJECT_ID => l_award_project_id
3687: , P_OBJECT_TYPE => 'PA_PROJECTS'
3688: , P_PROJECT_ROLE_ID => 1
3689: , P_PROJECT_ROLE_TYPE => 'PROJECT MANAGER'
3690: , P_RESOURCE_TYPE_ID => 101
3691: , P_RESOURCE_SOURCE_ID => G_personnel_rec.person_id
5148: pt.sponsored_flag,
5149: p.template_flag,
5150: p.start_date,
5151: p.closed_date
5152: FROM pa_projects_all p,
5153: pa_project_types_all pt
5154: WHERE p.project_id = P_PROJECT_ID
5155: AND pt.project_type = p.project_type
5156: And p.org_id = pt.org_id /* For Bug 5414832*/