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 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,

Line 2718: FROM pa_project_types ppt, pa_projects pp

2714: DECLARE
2715: CURSOR cur_pa_proj_type
2716: IS
2717: SELECT project_type_id
2718: FROM pa_project_types ppt, pa_projects pp
2719: WHERE project_id = p_project_id
2720: AND pp.project_type = ppt.project_type;
2721: l_project_type_id NUMBER;
2722: BEGIN

Line 2745: WHERE pvc.object_type = 'PA_PROJECTS'

2741: SELECT 'X'
2742: INTO l_dummy_char
2743: FROM pa_valid_categories_v pvc ,
2744: pa_lookups pl
2745: WHERE pvc.object_type = 'PA_PROJECTS'
2746: AND pvc.object_type_id = l_project_type_id
2747: AND 'CLASSIFICATION' = pl.lookup_code
2748: AND pl.lookup_type = 'OVERRIDE FIELD'
2749: AND pvc.class_category = p_limiting_value ;

Line 3014: FROM pa_project_types ppt, pa_projects pp

3010: DECLARE
3011: CURSOR cur_pa_proj_type
3012: IS
3013: SELECT project_type_id
3014: FROM pa_project_types ppt, pa_projects pp
3015: WHERE project_id = p_project_id
3016: AND pp.project_type = ppt.project_type;
3017: l_project_type_id NUMBER;
3018: BEGIN

Line 3041: WHERE pvc.object_type = 'PA_PROJECTS'

3037: SELECT 'X'
3038: INTO l_dummy_char
3039: FROM pa_valid_categories_v pvc ,
3040: pa_lookups pl
3041: WHERE pvc.object_type = 'PA_PROJECTS'
3042: AND pvc.object_type_id = l_project_type_id
3043: AND 'CLASSIFICATION' = pl.lookup_code
3044: AND pl.lookup_type = 'OVERRIDE FIELD'
3045: AND pvc.class_category = p_limiting_value ;