APPS.PA_PROJ_TEMPLATE_SETUP_PVT dependencies on PA_PROJECTS

Line 106: SELECT pa_projects_s.nextval

102: l_billable_flag VARCHAR2(1);
103:
104: CURSOR Cur_proj_id
105: IS
106: SELECT pa_projects_s.nextval
107: FROM sys.dual;
108:
109: CURSOR cur_currency
110: IS

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 591: PA_PROJECTS_PKG.INSERT_ROW(

587: END IF;
588: END IF;
589:
590:
591: PA_PROJECTS_PKG.INSERT_ROW(
592: X_Rowid => l_row_id
593: ,X_Project_Id => l_template_id
594: ,X_Name => p_project_name
595: ,X_Segment1 => p_project_number

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,

Line 2713: FROM pa_project_types ppt, pa_projects pp

2709: DECLARE
2710: CURSOR cur_pa_proj_type
2711: IS
2712: SELECT project_type_id
2713: FROM pa_project_types ppt, pa_projects pp
2714: WHERE project_id = p_project_id
2715: AND pp.project_type = ppt.project_type;
2716: l_project_type_id NUMBER;
2717: BEGIN

Line 2740: WHERE pvc.object_type = 'PA_PROJECTS'

2736: SELECT 'X'
2737: INTO l_dummy_char
2738: FROM pa_valid_categories_v pvc ,
2739: pa_lookups pl
2740: WHERE pvc.object_type = 'PA_PROJECTS'
2741: AND pvc.object_type_id = l_project_type_id
2742: AND 'CLASSIFICATION' = pl.lookup_code
2743: AND pl.lookup_type = 'OVERRIDE FIELD'
2744: AND pvc.class_category = p_limiting_value ;

Line 3009: FROM pa_project_types ppt, pa_projects pp

3005: DECLARE
3006: CURSOR cur_pa_proj_type
3007: IS
3008: SELECT project_type_id
3009: FROM pa_project_types ppt, pa_projects pp
3010: WHERE project_id = p_project_id
3011: AND pp.project_type = ppt.project_type;
3012: l_project_type_id NUMBER;
3013: BEGIN

Line 3036: WHERE pvc.object_type = 'PA_PROJECTS'

3032: SELECT 'X'
3033: INTO l_dummy_char
3034: FROM pa_valid_categories_v pvc ,
3035: pa_lookups pl
3036: WHERE pvc.object_type = 'PA_PROJECTS'
3037: AND pvc.object_type_id = l_project_type_id
3038: AND 'CLASSIFICATION' = pl.lookup_code
3039: AND pl.lookup_type = 'OVERRIDE FIELD'
3040: AND pvc.class_category = p_limiting_value ;