eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PJI_FM_XBS_ACCUM_MAINT dependencies on PA_PROJECTS_ALL

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

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

Line 99: from pa_projects_all

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

Line 470: from pa_budget_versions b , pa_projects_all p , pa_proj_fp_options fpo

466: for k in 1 .. p_fp_version_ids.count loop
467:
468: select p.pjt_rollup_enabled_flag , p.cbs_enable_flag, p.project_id , fpo.rbs_version_id , p.cbs_version_id
469: into l_pjt_rollup_enabled_flag , l_cbs_enabled_flag, l_project_id , l_rbs_version_id , l_cbs_version_id
470: from pa_budget_versions b , pa_projects_all p , pa_proj_fp_options fpo
471: where b.budget_version_id = p_fp_version_ids(k)
472: and b.project_id = p.project_id
473: AND b.fin_plan_type_id = fpo.fin_plan_type_id
474: AND b.budget_version_id = fpo.fin_plan_version_id

Line 591: from pa_budget_versions b , pa_projects_all p , pa_proj_fp_options fpo, pji_fm_extr_plan_lines extr

587: -- OLAP START CHANGE
588:
589: cursor plan_versions is
590: select extr.plan_version_id, p.pjt_rollup_enabled_flag , nvl(p.CBS_ENABLE_FLAG, 'N') cbs_enable_flag, p.project_id , fpo.rbs_version_id , p.cbs_version_id
591: from pa_budget_versions b , pa_projects_all p , pa_proj_fp_options fpo, pji_fm_extr_plan_lines extr
592: where b.budget_version_id = extr.plan_version_id
593: and b.project_id = p.project_id
594: AND b.fin_plan_type_id = fpo.fin_plan_type_id
595: AND b.budget_version_id = fpo.fin_plan_version_id

Line 709: from pa_budget_versions b , pa_projects_all p , pa_proj_fp_options fpo

705: END IF;
706:
707: select p.pjt_rollup_enabled_flag , p.CBS_ENABLE_FLAG, p.project_id , fpo.rbs_version_id , p.cbs_version_id
708: into l_pjt_rollup_enabled_flag , l_cbs_enable_flag, l_project_id , l_rbs_version_id , l_cbs_version_id
709: from pa_budget_versions b , pa_projects_all p , pa_proj_fp_options fpo
710: where b.budget_version_id = p_plan_version_id
711: and b.project_id = p.project_id
712: AND b.fin_plan_type_id = fpo.fin_plan_type_id
713: AND b.budget_version_id = fpo.fin_plan_version_id

Line 1493: from pa_budget_versions b , pa_projects_all p , pa_proj_fp_options fpo

1489: -- OLAP START CHANGE
1490:
1491: select p.pjt_rollup_enabled_flag , p.cbs_enable_flag, p.project_id , fpo.rbs_version_id , p.cbs_version_id
1492: into l_pjt_rollup_enabled_flag , l_cbs_enabled_flag, l_project_id , l_rbs_version_id , l_cbs_version_id
1493: from pa_budget_versions b , pa_projects_all p , pa_proj_fp_options fpo
1494: where b.budget_version_id = p_dest_fp_version_ids(i)
1495: and b.project_id = p.project_id
1496: AND b.fin_plan_type_id = fpo.fin_plan_type_id
1497: AND b.budget_version_id = fpo.fin_plan_version_id

Line 1708: l_new_project_type pa_projects_all.project_type%TYPE;

1704: l_event_rec pa_pji_proj_events_log%ROWTYPE;
1705: l_project_id NUMBER := NULL;
1706: l_curr_bl_ver_id NUMBER := NULL;
1707: l_plan_type_id NUMBER := NULL;
1708: l_new_project_type pa_projects_all.project_type%TYPE;
1709: l_new_plan_type_code pa_budget_versions.budget_type_code%TYPE;
1710: l_plan_type_code CHAR(1);
1711: l_processing_code VARCHAR2(12000);
1712: l_wp_version_flag VARCHAR2(1) := NULL;

Line 1798: from pa_budget_versions b , pa_projects_all p , pa_proj_fp_options fpo

1794: -- OLAP START CHANGE
1795:
1796: select p.pjt_rollup_enabled_flag , p.cbs_enable_flag, p.project_id , fpo.rbs_version_id , p.cbs_version_id
1797: into l_pjt_rollup_enabled_flag , l_cbs_enabled_flag, l_project_id , l_rbs_version_id , l_cbs_version_id
1798: from pa_budget_versions b , pa_projects_all p , pa_proj_fp_options fpo
1799: where b.budget_version_id = p_new_version_id
1800: and b.project_id = p.project_id
1801: AND b.fin_plan_type_id = fpo.fin_plan_type_id
1802: AND b.budget_version_id = fpo.fin_plan_version_id

Line 2052: l_new_project_type pa_projects_all.project_type%TYPE;

2048: l_project_id NUMBER := NULL;
2049: l_curr_or_ver_id NUMBER := NULL;
2050: l_plan_type_id NUMBER := NULL;
2051: l_plan_type_code char(1);
2052: l_new_project_type pa_projects_all.project_type%TYPE;
2053: l_new_plan_type_code pa_budget_versions.budget_type_code%TYPE;
2054: l_processing_code VARCHAR2(1500) := NULL;
2055:
2056: BEGIN

Line 2178: l_new_project_type pa_projects_all.project_type%TYPE;

2174: l_project_id NUMBER := NULL;
2175: l_old_orig_ver_id NUMBER := NULL;
2176: l_new_orig_ver_id NUMBER := NULL;
2177: l_plan_type_id NUMBER := NULL;
2178: l_new_project_type pa_projects_all.project_type%TYPE;
2179: l_new_plan_type_code pa_budget_versions.budget_type_code%TYPE;
2180: l_original_exists NUMBER := NULL;
2181: l_processing_code VARCHAR2(1) := NULL;
2182:

Line 2407: from PA_PROJECTS_ALL

2403: AND (p_project_id IS NOT NULL) ) THEN -- RBS is associated with a project.
2404:
2405: select TEMPLATE_FLAG
2406: into l_template_flag
2407: from PA_PROJECTS_ALL
2408: where PROJECT_ID = p_project_id;
2409: if (l_template_flag = 'Y') then
2410: return;
2411: end if;

Line 2427: from PA_PROJECTS_ALL

2423: AND (p_project_id IS NOT NULL) ) THEN -- RBS is associated with a program.
2424:
2425: select TEMPLATE_FLAG
2426: into l_template_flag
2427: from PA_PROJECTS_ALL
2428: where PROJECT_ID = p_project_id;
2429: if (l_template_flag = 'Y') then
2430: return;
2431: end if;

Line 4163: l_struct_sharing_code pa_projects_all.structure_sharing_code%TYPE;

4159: l_chd_message VARCHAR2(2000);
4160: l_plan_version_id NUMBER;
4161:
4162: l_plan_version_id_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
4163: l_struct_sharing_code pa_projects_all.structure_sharing_code%TYPE;
4164: CURSOR c_pln_ver_list (p_old_struct_ver_id IN NUMBER) IS
4165: SELECT project_id, plan_version_id
4166: FROM pji_pjp_wbs_header
4167: WHERE 1 = 1

Line 4737: l_struct_sharing_code pa_projects_all.structure_sharing_code%TYPE;

4733:
4734: l_shared_flag VARCHAR2(1) := 'A'; --Default value implies value is null in source system
4735: l_versioned_flag VARCHAR2(1):='N';
4736: l_struct_type VARCHAR2(30);
4737: l_struct_sharing_code pa_projects_all.structure_sharing_code%TYPE;
4738: l_event_id NUMBER;
4739: l_return_status VARCHAR2(1);
4740: l_lock_mode VARCHAR2(1);
4741: l_working_version_id number;

Line 5865: from pa_projects_all p

5861: -- OLAP START
5862:
5863: select p.pjt_rollup_enabled_flag
5864: into l_pjt_rollup_enabled_flag
5865: from pa_projects_all p
5866: where l_project_id = p.project_id ;
5867:
5868:
5869: -- OLAP END