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 1292: FROM pa_projects_all

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

Line 1931: UPDATE pa_projects_all

1927:
1928:
1929:
1930: --I cant use table handler for update; It may update the unwanted columns as well wih null
1931: UPDATE pa_projects_all
1932: SET SEGMENT1 = p_project_number,
1933: NAME = p_project_name,
1934: description = p_description,
1935: PROJECT_TYPE = p_project_type,