APPS.PJI_FM_XBS_ACCUM_MAINT dependencies on PA_PROJECTS_ALL

Line 92: l_project pa_projects_all.segment1%TYPE; /* 4604355 */

88: return NUMBER
89: IS
90: pragma autonomous_transaction;
91: l_request_id NUMBER;
92: l_project pa_projects_all.segment1%TYPE; /* 4604355 */
93: begin
94: begin
95: select segment1
96: into l_project

Line 97: from pa_projects_all

93: begin
94: begin
95: select segment1
96: into l_project
97: from pa_projects_all
98: where project_id = p_project_id;
99: exception
100: when no_data_found then null;
101: end;

Line 1378: l_new_project_type pa_projects_all.project_type%TYPE;

1374: l_event_rec pa_pji_proj_events_log%ROWTYPE;
1375: l_project_id NUMBER := NULL;
1376: l_curr_bl_ver_id NUMBER := NULL;
1377: l_plan_type_id NUMBER := NULL;
1378: l_new_project_type pa_projects_all.project_type%TYPE;
1379: l_new_plan_type_code pa_budget_versions.budget_type_code%TYPE;
1380: l_plan_type_code CHAR(1);
1381: l_processing_code VARCHAR2(12000);
1382: l_wp_version_flag VARCHAR2(1) := NULL;

Line 1676: l_new_project_type pa_projects_all.project_type%TYPE;

1672: l_project_id NUMBER := NULL;
1673: l_curr_or_ver_id NUMBER := NULL;
1674: l_plan_type_id NUMBER := NULL;
1675: l_plan_type_code char(1);
1676: l_new_project_type pa_projects_all.project_type%TYPE;
1677: l_new_plan_type_code pa_budget_versions.budget_type_code%TYPE;
1678: l_processing_code VARCHAR2(1500) := NULL;
1679:
1680: BEGIN

Line 1802: l_new_project_type pa_projects_all.project_type%TYPE;

1798: l_project_id NUMBER := NULL;
1799: l_old_orig_ver_id NUMBER := NULL;
1800: l_new_orig_ver_id NUMBER := NULL;
1801: l_plan_type_id NUMBER := NULL;
1802: l_new_project_type pa_projects_all.project_type%TYPE;
1803: l_new_plan_type_code pa_budget_versions.budget_type_code%TYPE;
1804: l_original_exists NUMBER := NULL;
1805: l_processing_code VARCHAR2(1) := NULL;
1806:

Line 2031: from PA_PROJECTS_ALL

2027: AND (p_project_id IS NOT NULL) ) THEN -- RBS is associated with a project.
2028:
2029: select TEMPLATE_FLAG
2030: into l_template_flag
2031: from PA_PROJECTS_ALL
2032: where PROJECT_ID = p_project_id;
2033: if (l_template_flag = 'Y') then
2034: return;
2035: end if;

Line 2051: from PA_PROJECTS_ALL

2047: AND (p_project_id IS NOT NULL) ) THEN -- RBS is associated with a program.
2048:
2049: select TEMPLATE_FLAG
2050: into l_template_flag
2051: from PA_PROJECTS_ALL
2052: where PROJECT_ID = p_project_id;
2053: if (l_template_flag = 'Y') then
2054: return;
2055: end if;

Line 3787: l_struct_sharing_code pa_projects_all.structure_sharing_code%TYPE;

3783: l_chd_message VARCHAR2(2000);
3784: l_plan_version_id NUMBER;
3785:
3786: l_plan_version_id_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
3787: l_struct_sharing_code pa_projects_all.structure_sharing_code%TYPE;
3788: CURSOR c_pln_ver_list (p_old_struct_ver_id IN NUMBER) IS
3789: SELECT project_id, plan_version_id
3790: FROM pji_pjp_wbs_header
3791: WHERE 1 = 1

Line 4359: l_struct_sharing_code pa_projects_all.structure_sharing_code%TYPE;

4355:
4356: l_shared_flag VARCHAR2(1) := 'A'; --Default value implies value is null in source system
4357: l_versioned_flag VARCHAR2(1):='N';
4358: l_struct_type VARCHAR2(30);
4359: l_struct_sharing_code pa_projects_all.structure_sharing_code%TYPE;
4360: l_event_id NUMBER;
4361: l_return_status VARCHAR2(1);
4362: l_lock_mode VARCHAR2(1);
4363: l_working_version_id number;