APPS.PA_PROJ_TEMPLATE_SETUP_PVT dependencies on PA_PROJECTS_ALL

Line 450: --Call table handler for pa_projects_all

446:
447: --default public sector flag from profile options.
448: l_public_sector_flag := fnd_profile.value ('PA_DEFAULT_PUBLIC_SECTOR');
449:
450: --Call table handler for pa_projects_all
451: OPEN Cur_proj_id;
452: FETCH Cur_proj_id INTO l_template_id;
453: CLOSE Cur_proj_id;
454: x_template_id := l_template_id;

Line 1297: FROM pa_projects_all

1293: ,nvl(date_eff_funds_consumption,'N') --federal bug#5511353
1294: ,enable_top_task_customer_flag --federal bug#5511353
1295: ,ar_rec_notify_flag -- 7508661 : EnC
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

Line 1936: UPDATE pa_projects_all

1932:
1933:
1934:
1935: --I cant use table handler for update; It may update the unwanted columns as well wih null
1936: UPDATE pa_projects_all
1937: SET SEGMENT1 = p_project_number,
1938: NAME = p_project_name,
1939: description = p_description,
1940: PROJECT_TYPE = p_project_type,