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.PA_PROJECT_STRUCTURE_PVT1 dependencies on PA_PROJECTS_ALL

Line 145: from pa_projects_all

141: l_structure_description VARCHAR2(2000);
142:
143: cursor get_split_flag IS
144: select split_cost_from_workplan_flag, SPLIT_COST_FROM_BILL_FLAG
145: from pa_projects_all
146: where project_id = p_project_id;
147:
148: cursor get_licensed(p_workplan VARCHAR2,
149: p_financial VARCHAR2,

Line 637: l_project_id PA_PROJECTS_ALL.PROJECT_ID%TYPE;

633: ,x_msg_data OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
634: )
635: IS
636: l_rowid VARCHAR2(255);
637: l_project_id PA_PROJECTS_ALL.PROJECT_ID%TYPE;
638:
639: l_msg_count NUMBER;
640: l_msg_data VARCHAR2(250);
641: -- added ofr Bug Fix: 4537865

Line 932: l_project_id PA_PROJECTS_ALL.PROJECT_ID%TYPE;

928: )
929: IS
930:
931: l_rowid VARCHAR2(255);
932: l_project_id PA_PROJECTS_ALL.PROJECT_ID%TYPE;
933: l_proj_element_id PA_PROJ_ELEMENTS.PROJ_ELEMENT_ID%TYPE;
934: l_return_status VARCHAR2(1);
935: l_msg_count NUMBER;
936: l_msg_data VARCHAR2(250);

Line 1425: l_project_id PA_PROJECTS_ALL.PROJECT_ID%TYPE;

1421: )
1422: IS
1423:
1424: l_rowid VARCHAR2(255);
1425: l_project_id PA_PROJECTS_ALL.PROJECT_ID%TYPE;
1426: l_proj_element_id PA_PROJ_ELEMENTS.PROJ_ELEMENT_ID%TYPE;
1427: l_msg_count NUMBER;
1428: l_msg_data VARCHAR2(250);
1429:

Line 1829: , pa_projects_all ppa, pa_object_relationships por2 -- Bug # 4556844.

1825: cursor cur_relationship_ids(c_structure_version_id NUMBER, c_project_id NUMBER)
1826: is select por.object_relationship_id, por.record_version_number
1827: , por2.object_id_from1, por.object_id_from2, por.comments, ppa.name -- Bug # 4556844.
1828: from pa_object_relationships por, pa_proj_element_versions ppev, pa_proj_elem_ver_structure ppevs
1829: , pa_projects_all ppa, pa_object_relationships por2 -- Bug # 4556844.
1830: where ppevs.element_version_id = ppev.parent_structure_version_id
1831: and ppevs.project_id = ppev.project_id
1832: and ppev.element_version_id = por.object_id_to1
1833: and ppev.project_id = por.object_id_to2

Line 2305: from pa_projects_all ppa, pa_proj_elements ppe

2301: -- Begin fix for Bug # 4506308.
2302:
2303: cursor l_cur_projects_all(c_structure_id NUMBER) is
2304: select ppa.project_id, ppa.record_version_number
2305: from pa_projects_all ppa, pa_proj_elements ppe
2306: where ppa.project_id = ppe.project_id
2307: and ppe.proj_element_id = c_structure_id;
2308:
2309: l_project_id NUMBER;

Line 3015: FROM pa_projects_all

3011:
3012: CURSOR get_proj_rec_ver_number(c_project_id NUMBER)
3013: IS
3014: SELECT record_version_number
3015: FROM pa_projects_all
3016: WHERE project_id = c_project_id;
3017: -- End of changes
3018:
3019:

Line 5186: from pa_projects_all

5182: IF (l_financial_type = 'Y') THEN
5183:
5184: select start_date, completion_date
5185: into l_proj_start_date, l_proj_completion_date
5186: from pa_projects_all
5187: where project_id = l_project_id;
5188:
5189: --dbms_output.put_line('sycn up api');
5190: --Call sync-up API

Line 7236: SELECT 1 FROM PA_PROJECTS_ALL

7232: l_task_match_tbl task_match_tbl;
7233:
7234: CURSOR l_is_template (c_project_id NUMBER)
7235: IS
7236: SELECT 1 FROM PA_PROJECTS_ALL
7237: WHERE TEMPLATE_FLAG = 'Y'
7238: AND project_id = c_project_id;
7239: l_dummy NUMBER;
7240:

Line 7260: FROM PA_PROJECTS_ALL

7256: --Added for calculating delta using target date
7257: CURSOR get_target_dates
7258: IS
7259: SELECT target_start_date, target_finish_date
7260: FROM PA_PROJECTS_ALL
7261: WHERE PROJECT_ID = p_dest_project_id;
7262: l_target_start_date DATE;
7263: l_target_finish_date DATE;
7264: l_scheduled_start_date DATE;

Line 7348: from pa_projects_all

7344: l_progress_attr_rec get_progress_attr%ROWTYPE;
7345:
7346: CURSOR get_proj_rec_ver_number(c_project_id NUMBER) IS
7347: select record_version_number
7348: from pa_projects_all
7349: where project_id = c_project_id;
7350: l_proj_record_ver_number NUMBER;
7351: l_struc_scheduled_start_date DATE;
7352: l_struc_scheduled_finish_date DATE;

Line 7419: FROM PA_PROJECTS_ALL

7415:
7416: -- Check split_cost_from_workplan_flag for source project
7417: SELECT split_cost_from_workplan_flag
7418: INTO l_split_cost_workplan_flag
7419: FROM PA_PROJECTS_ALL
7420: WHERE project_id = p_src_project_id;
7421:
7422: if l_split_cost_workplan_flag = 'N' then
7423: OPEN l_get_structure_csr(p_src_project_id);

Line 7436: from pa_projects_all

7432: CLOSE l_get_structure_csr;
7433: */
7434:
7435: select name into l_project_name
7436: from pa_projects_all
7437: where project_id = p_dest_project_id;
7438:
7439: select meaning
7440: into l_suffix

Line 7461: -- FROM PA_PROJECTS_ALL

7457:
7458: --check if this is a split project
7459: -- SELECT split_cost_from_workplan_flag
7460: -- INTO l_split_cost_workplan_flag
7461: -- FROM PA_PROJECTS_ALL
7462: -- WHERE project_id = p_src_project_id;
7463:
7464: -- OPEN l_get_structure_type_csr(l_structure_rec.proj_element_id);
7465: -- FETCH l_get_structure_type_csr INTO l_structure_type;

Line 8424: FROM pa_projects_all

8420: -- Dates changes
8421: CURSOR c2 (c_project_id NUMBER)
8422: IS
8423: SELECT record_version_number
8424: FROM pa_projects_all
8425: WHERE project_id = c_project_id;
8426:
8427: l_proj_record_ver_number NUMBER;
8428: l_return_status VARCHAR2(1);

Line 8438: from pa_projects_all a, pa_proj_element_versions b

8434: l_duration NUMBER;
8435: l_duration_days NUMBER;
8436: cursor get_cal_id IS
8437: select a.calendar_id
8438: from pa_projects_all a, pa_proj_element_versions b
8439: where a.project_id = b.project_id
8440: and b.element_version_id = p_structure_version_id;
8441: BEGIN
8442: IF (p_debug_mode = 'Y') THEN

Line 9513: from pa_projects_all

9509: l_proj_prog_attr_id NUMBER;
9510:
9511: CURSOR get_project_info IS
9512: select name, target_start_date, target_finish_date
9513: from pa_projects_all
9514: where project_id = p_project_id;
9515:
9516: --bug 2843569: added record_version_number
9517: CURSOR get_template_flag IS

Line 9519: from pa_projects_all

9515:
9516: --bug 2843569: added record_version_number
9517: CURSOR get_template_flag IS
9518: select template_flag, record_version_number
9519: from pa_projects_all
9520: where project_id = p_project_id;
9521:
9522: CURSOR get_wp_attr_rvn IS
9523: select b.proj_element_id, a.record_version_number

Line 9650: from pa_projects_all

9646:
9647: --hsiu added for bug 2634029
9648: cursor sel_target_dates IS
9649: select target_start_date, target_finish_date, calendar_id
9650: from pa_projects_all
9651: where project_id = p_project_id;
9652:
9653: CURSOR get_top_tasks(c_structure_version_id NUMBER) IS
9654: select v.element_version_id

Line 10857: UPDATE PA_PROJECTS_ALL

10853: END IF;
10854: ELSE
10855: IF (l_status_code = 'STRUCTURE_WORKING') THEN
10856: --clear previously set dates
10857: UPDATE PA_PROJECTS_ALL
10858: SET baseline_start_date = NULL,
10859: baseline_finish_date = NULL,
10860: baseline_duration = NULL,
10861: baseline_as_of_date = NULL,

Line 10973: from pa_projects_all a,

10969: and a.LATEST_EFF_PUBLISHED_FLAG = 'Y';
10970:
10971: CURSOR get_template_flag IS
10972: select a.template_flag
10973: from pa_projects_all a,
10974: pa_proj_elements b
10975: where a.project_id = b.project_id
10976: and b.proj_element_id = p_proj_element_id;
10977:

Line 11341: from pa_projects_all where project_id = p_project_id;

11337: l_weight_basis pa_proj_progress_attr.task_weight_basis_code%TYPE;
11338:
11339: CURSOR c1 IS
11340: select template_flag
11341: from pa_projects_all where project_id = p_project_id;
11342:
11343: CURSOR c2 IS
11344: select SCHEDULED_START_DATE, SCHEDULED_FINISH_DATE
11345: from pa_projects_all where project_id = p_project_id;

Line 11345: from pa_projects_all where project_id = p_project_id;

11341: from pa_projects_all where project_id = p_project_id;
11342:
11343: CURSOR c2 IS
11344: select SCHEDULED_START_DATE, SCHEDULED_FINISH_DATE
11345: from pa_projects_all where project_id = p_project_id;
11346:
11347: CURSOR c3 IS
11348: select ACTUAL_START_DATE, ACTUAL_FINISH_DATE
11349: from pa_projects_all where project_id = p_project_id;

Line 11349: from pa_projects_all where project_id = p_project_id;

11345: from pa_projects_all where project_id = p_project_id;
11346:
11347: CURSOR c3 IS
11348: select ACTUAL_START_DATE, ACTUAL_FINISH_DATE
11349: from pa_projects_all where project_id = p_project_id;
11350:
11351: CURSOR c4 IS
11352: select BASELINE_START_DATE, BASELINE_FINISH_DATE
11353: from pa_projects_all where project_id = p_project_id;

Line 11353: from pa_projects_all where project_id = p_project_id;

11349: from pa_projects_all where project_id = p_project_id;
11350:
11351: CURSOR c4 IS
11352: select BASELINE_START_DATE, BASELINE_FINISH_DATE
11353: from pa_projects_all where project_id = p_project_id;
11354: --
11355: l_sch_dur NUMBER; -- Bug 3657808
11356: l_act_dur NUMBER; -- Bug 3657808
11357: l_bsl_dur NUMBER; -- Bug 3657808

Line 11477: update pa_projects_all

11473: END IF;*/
11474: END IF;
11475:
11476: --hsiu: removed record version number for Forms changes
11477: update pa_projects_all
11478: /*set SCHEDULED_DURATION = l_sch_hours,
11479: BASELINE_DURATION = l_bsl_hours,
11480: ACTUAL_DURATION = l_act_hours*/
11481: set SCHEDULED_DURATION = l_sch_dur,

Line 11521: update pa_projects_all

11517: END IF;*/
11518: END IF;
11519:
11520: --hsiu: removed record version number for Forms changes
11521: update pa_projects_all
11522: -- set SCHEDULED_DURATION = l_sch_hours
11523: set SCHEDULED_DURATION = l_sch_dur
11524: where project_id = p_project_id;
11525:

Line 11630: from pa_projects_all

11626: is
11627: Cursor c_calendar_projects
11628: IS
11629: Select project_id
11630: from pa_projects_all
11631: where calendar_id = p_calendar_id;
11632: BEGIN
11633: IF (p_debug_mode = 'Y') THEN
11634: pa_debug.debug('PA_PROJECT_STRUCTURE_PVT1.UPDATE_ALL_WP_CALENDAR BEGIN');

Line 12284: from pa_projects_all ppa,

12280:
12281: CURSOR get_project_info(c_project_id NUMBER) IS
12282: select ppa.name name, ppa.segment1,
12283: hou.name carrying_out_org_name, ppl.full_name
12284: from pa_projects_all ppa,
12285: hr_all_organization_units hou,
12286: per_all_people_f ppl,
12287: pa_project_parties ppp
12288: where ppa.carrying_out_organization_id = hou.organization_id

Line 13861: l_sys_program_flag PA_PROJECTS_ALL.sys_program_flag%TYPE;

13857: l_proj_completion_date DATE;
13858: l_proj_prog_attr_id NUMBER;
13859:
13860: -- FP.M Changes below
13861: l_sys_program_flag PA_PROJECTS_ALL.sys_program_flag%TYPE;
13862: l_allow_multi_program_rollup PA_PROJECTS_ALL.allow_multi_program_rollup%TYPE;
13863: l_proj_sys_program_flag PA_PROJECTS_ALL.sys_program_flag%TYPE;
13864: l_proj_allow_program_rollup PA_PROJECTS_ALL.allow_multi_program_rollup%TYPE;
13865: l_flag VARCHAR2(1);

Line 13862: l_allow_multi_program_rollup PA_PROJECTS_ALL.allow_multi_program_rollup%TYPE;

13858: l_proj_prog_attr_id NUMBER;
13859:
13860: -- FP.M Changes below
13861: l_sys_program_flag PA_PROJECTS_ALL.sys_program_flag%TYPE;
13862: l_allow_multi_program_rollup PA_PROJECTS_ALL.allow_multi_program_rollup%TYPE;
13863: l_proj_sys_program_flag PA_PROJECTS_ALL.sys_program_flag%TYPE;
13864: l_proj_allow_program_rollup PA_PROJECTS_ALL.allow_multi_program_rollup%TYPE;
13865: l_flag VARCHAR2(1);
13866:

Line 13863: l_proj_sys_program_flag PA_PROJECTS_ALL.sys_program_flag%TYPE;

13859:
13860: -- FP.M Changes below
13861: l_sys_program_flag PA_PROJECTS_ALL.sys_program_flag%TYPE;
13862: l_allow_multi_program_rollup PA_PROJECTS_ALL.allow_multi_program_rollup%TYPE;
13863: l_proj_sys_program_flag PA_PROJECTS_ALL.sys_program_flag%TYPE;
13864: l_proj_allow_program_rollup PA_PROJECTS_ALL.allow_multi_program_rollup%TYPE;
13865: l_flag VARCHAR2(1);
13866:
13867: -- NYU

Line 13864: l_proj_allow_program_rollup PA_PROJECTS_ALL.allow_multi_program_rollup%TYPE;

13860: -- FP.M Changes below
13861: l_sys_program_flag PA_PROJECTS_ALL.sys_program_flag%TYPE;
13862: l_allow_multi_program_rollup PA_PROJECTS_ALL.allow_multi_program_rollup%TYPE;
13863: l_proj_sys_program_flag PA_PROJECTS_ALL.sys_program_flag%TYPE;
13864: l_proj_allow_program_rollup PA_PROJECTS_ALL.allow_multi_program_rollup%TYPE;
13865: l_flag VARCHAR2(1);
13866:
13867: -- NYU
13868: l_del_trans_exist VARCHAR2(1);

Line 13872: from pa_projects_all

13868: l_del_trans_exist VARCHAR2(1);
13869:
13870: CURSOR get_project_info IS
13871: select name, target_start_date, target_finish_date, sys_program_flag, allow_multi_program_rollup
13872: from pa_projects_all
13873: where project_id = p_project_id;
13874:
13875: --bug 2843569: added record_version_number
13876: CURSOR get_template_flag IS

Line 13878: from pa_projects_all

13874:
13875: --bug 2843569: added record_version_number
13876: CURSOR get_template_flag IS
13877: select template_flag, record_version_number
13878: from pa_projects_all
13879: where project_id = p_project_id;
13880:
13881: CURSOR get_wp_attr_rvn IS
13882: select b.proj_element_id, a.record_version_number

Line 14015: from pa_projects_all

14011:
14012: --hsiu added for bug 2634029
14013: cursor sel_target_dates IS
14014: select target_start_date, target_finish_date, calendar_id
14015: from pa_projects_all
14016: where project_id = p_project_id;
14017:
14018: CURSOR get_top_tasks(c_structure_version_id NUMBER) IS
14019: select v.element_version_id

Line 14091: , pa_projects_all ppa

14087: , ppev.parent_structure_version_id src_str_ver_id
14088: , por1.record_version_number rec_ver_number
14089: from pa_object_relationships por1
14090: , pa_object_relationships por2
14091: , pa_projects_all ppa
14092: , pa_proj_element_versions ppev
14093: , pa_proj_elem_ver_structure ppevs
14094: where por1.object_id_to2 = c_project_id
14095: and por1.relationship_type in ('LW', 'LF')

Line 14119: , pa_projects_all ppa

14115: , ppev.parent_structure_version_id src_str_ver_id
14116: , por1.record_version_number rec_ver_number
14117: from pa_object_relationships por1
14118: , pa_object_relationships por2
14119: , pa_projects_all ppa
14120: , pa_proj_element_versions ppev
14121: , pa_proj_elem_ver_structure ppevs
14122: where por1.object_id_from2 = c_project_id
14123: and por1.relationship_type in ('LW', 'LF')

Line 17590: update pa_projects_all

17586: ELSE
17587: l_new_share_code := p_sharing_option_code;
17588: END IF;
17589:
17590: update pa_projects_all
17591: set structure_sharing_code = l_new_share_code
17592: where project_id = p_project_id;
17593:
17594: IF l_delv_enabled = 'Y' THEN

Line 17771: UPDATE pa_projects_all

17767: END IF;
17768: END IF;
17769:
17770: -- IF NOT FND_API.TO_BOOLEAN(p_validate_only) THEN
17771: UPDATE pa_projects_all
17772: SET
17773: sys_program_flag = nvl(l_sys_program_flag,'N'),
17774: allow_multi_program_rollup = nvl(l_allow_multi_program_rollup,'N')
17775: WHERE project_id = p_project_id;