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 2324: from pa_projects_all ppa, pa_proj_elements ppe

2320: -- Begin fix for Bug # 4506308.
2321:
2322: cursor l_cur_projects_all(c_structure_id NUMBER) is
2323: select ppa.project_id, ppa.record_version_number
2324: from pa_projects_all ppa, pa_proj_elements ppe
2325: where ppa.project_id = ppe.project_id
2326: and ppe.proj_element_id = c_structure_id;
2327:
2328: l_project_id NUMBER;

Line 3045: FROM pa_projects_all

3041:
3042: CURSOR get_proj_rec_ver_number(c_project_id NUMBER)
3043: IS
3044: SELECT record_version_number
3045: FROM pa_projects_all
3046: WHERE project_id = c_project_id;
3047: -- End of changes
3048:
3049:

Line 5246: from pa_projects_all

5242: IF (l_financial_type = 'Y') THEN
5243:
5244: select start_date, completion_date
5245: into l_proj_start_date, l_proj_completion_date
5246: from pa_projects_all
5247: where project_id = l_project_id;
5248:
5249: --dbms_output.put_line('sycn up api');
5250: --Call sync-up API

Line 7296: SELECT 1 FROM PA_PROJECTS_ALL

7292: l_task_match_tbl task_match_tbl;
7293:
7294: CURSOR l_is_template (c_project_id NUMBER)
7295: IS
7296: SELECT 1 FROM PA_PROJECTS_ALL
7297: WHERE TEMPLATE_FLAG = 'Y'
7298: AND project_id = c_project_id;
7299: l_dummy NUMBER;
7300:

Line 7320: FROM PA_PROJECTS_ALL

7316: --Added for calculating delta using target date
7317: CURSOR get_target_dates
7318: IS
7319: SELECT target_start_date, target_finish_date
7320: FROM PA_PROJECTS_ALL
7321: WHERE PROJECT_ID = p_dest_project_id;
7322: l_target_start_date DATE;
7323: l_target_finish_date DATE;
7324: l_scheduled_start_date DATE;

Line 7408: from pa_projects_all

7404: l_progress_attr_rec get_progress_attr%ROWTYPE;
7405:
7406: CURSOR get_proj_rec_ver_number(c_project_id NUMBER) IS
7407: select record_version_number
7408: from pa_projects_all
7409: where project_id = c_project_id;
7410: l_proj_record_ver_number NUMBER;
7411: l_struc_scheduled_start_date DATE;
7412: l_struc_scheduled_finish_date DATE;

Line 7479: FROM PA_PROJECTS_ALL

7475:
7476: -- Check split_cost_from_workplan_flag for source project
7477: SELECT split_cost_from_workplan_flag
7478: INTO l_split_cost_workplan_flag
7479: FROM PA_PROJECTS_ALL
7480: WHERE project_id = p_src_project_id;
7481:
7482: if l_split_cost_workplan_flag = 'N' then
7483: OPEN l_get_structure_csr(p_src_project_id);

Line 7496: from pa_projects_all

7492: CLOSE l_get_structure_csr;
7493: */
7494:
7495: select name into l_project_name
7496: from pa_projects_all
7497: where project_id = p_dest_project_id;
7498:
7499: select meaning
7500: into l_suffix

Line 7521: -- FROM PA_PROJECTS_ALL

7517:
7518: --check if this is a split project
7519: -- SELECT split_cost_from_workplan_flag
7520: -- INTO l_split_cost_workplan_flag
7521: -- FROM PA_PROJECTS_ALL
7522: -- WHERE project_id = p_src_project_id;
7523:
7524: -- OPEN l_get_structure_type_csr(l_structure_rec.proj_element_id);
7525: -- FETCH l_get_structure_type_csr INTO l_structure_type;

Line 8755: PA_PROJECTS_ALL C

8751: IS
8752: SELECT B.SCHEDULED_START_DATE,
8753: B.SCHEDULED_FINISH_DATE, C.record_version_number
8754: FROM PA_PROJ_ELEMENT_VERSIONS A, PA_PROJ_ELEM_VER_SCHEDULE B,
8755: PA_PROJECTS_ALL C
8756: WHERE A.PARENT_STRUCTURE_VERSION_ID = p_structure_version_id
8757: AND A.ELEMENT_VERSION_ID = p_structure_version_id
8758: AND A.ELEMENT_VERSION_ID = B.ELEMENT_VERSION_ID
8759: AND A.PROJECT_ID = B.PROJECT_ID

Line 8767: FROM pa_projects_all

8763: l_scheduled_start_date DATE;
8764: l_scheduled_finish_date DATE;
8765: /* Commented for bug 13836957
8766: SELECT record_version_number
8767: FROM pa_projects_all
8768: WHERE project_id = c_project_id; */
8769:
8770: l_proj_record_ver_number NUMBER;
8771: l_return_status VARCHAR2(1);

Line 8781: from pa_projects_all a, pa_proj_element_versions b

8777: l_duration NUMBER;
8778: l_duration_days NUMBER;
8779: cursor get_cal_id IS
8780: select a.calendar_id
8781: from pa_projects_all a, pa_proj_element_versions b
8782: where a.project_id = b.project_id
8783: and b.element_version_id = p_structure_version_id;
8784: BEGIN
8785: IF (p_debug_mode = 'Y') THEN

Line 9885: from pa_projects_all

9881: l_proj_prog_attr_id NUMBER;
9882:
9883: CURSOR get_project_info IS
9884: select name, target_start_date, target_finish_date
9885: from pa_projects_all
9886: where project_id = p_project_id;
9887:
9888: --bug 2843569: added record_version_number
9889: CURSOR get_template_flag IS

Line 9891: from pa_projects_all

9887:
9888: --bug 2843569: added record_version_number
9889: CURSOR get_template_flag IS
9890: select template_flag, record_version_number
9891: from pa_projects_all
9892: where project_id = p_project_id;
9893:
9894: CURSOR get_wp_attr_rvn IS
9895: select b.proj_element_id, a.record_version_number

Line 10022: from pa_projects_all

10018:
10019: --hsiu added for bug 2634029
10020: cursor sel_target_dates IS
10021: select target_start_date, target_finish_date, calendar_id
10022: from pa_projects_all
10023: where project_id = p_project_id;
10024:
10025: CURSOR get_top_tasks(c_structure_version_id NUMBER) IS
10026: select v.element_version_id

Line 11229: UPDATE PA_PROJECTS_ALL

11225: END IF;
11226: ELSE
11227: IF (l_status_code = 'STRUCTURE_WORKING') THEN
11228: --clear previously set dates
11229: UPDATE PA_PROJECTS_ALL
11230: SET baseline_start_date = NULL,
11231: baseline_finish_date = NULL,
11232: baseline_duration = NULL,
11233: baseline_as_of_date = NULL,

Line 11345: from pa_projects_all a,

11341: and a.LATEST_EFF_PUBLISHED_FLAG = 'Y';
11342:
11343: CURSOR get_template_flag IS
11344: select a.template_flag
11345: from pa_projects_all a,
11346: pa_proj_elements b
11347: where a.project_id = b.project_id
11348: and b.proj_element_id = p_proj_element_id;
11349:

Line 11713: from pa_projects_all where project_id = p_project_id;

11709: l_weight_basis pa_proj_progress_attr.task_weight_basis_code%TYPE;
11710:
11711: CURSOR c1 IS
11712: select template_flag
11713: from pa_projects_all where project_id = p_project_id;
11714:
11715: CURSOR c2 IS
11716: select SCHEDULED_START_DATE, SCHEDULED_FINISH_DATE
11717: from pa_projects_all where project_id = p_project_id;

Line 11717: from pa_projects_all where project_id = p_project_id;

11713: from pa_projects_all where project_id = p_project_id;
11714:
11715: CURSOR c2 IS
11716: select SCHEDULED_START_DATE, SCHEDULED_FINISH_DATE
11717: from pa_projects_all where project_id = p_project_id;
11718:
11719: CURSOR c3 IS
11720: select ACTUAL_START_DATE, ACTUAL_FINISH_DATE
11721: from pa_projects_all where project_id = p_project_id;

Line 11721: from pa_projects_all where project_id = p_project_id;

11717: from pa_projects_all where project_id = p_project_id;
11718:
11719: CURSOR c3 IS
11720: select ACTUAL_START_DATE, ACTUAL_FINISH_DATE
11721: from pa_projects_all where project_id = p_project_id;
11722:
11723: CURSOR c4 IS
11724: select BASELINE_START_DATE, BASELINE_FINISH_DATE
11725: from pa_projects_all where project_id = p_project_id;

Line 11725: from pa_projects_all where project_id = p_project_id;

11721: from pa_projects_all where project_id = p_project_id;
11722:
11723: CURSOR c4 IS
11724: select BASELINE_START_DATE, BASELINE_FINISH_DATE
11725: from pa_projects_all where project_id = p_project_id;
11726: --
11727: l_sch_dur NUMBER; -- Bug 3657808
11728: l_act_dur NUMBER; -- Bug 3657808
11729: l_bsl_dur NUMBER; -- Bug 3657808

Line 11849: update pa_projects_all

11845: END IF;*/
11846: END IF;
11847:
11848: --hsiu: removed record version number for Forms changes
11849: update pa_projects_all
11850: /*set SCHEDULED_DURATION = l_sch_hours,
11851: BASELINE_DURATION = l_bsl_hours,
11852: ACTUAL_DURATION = l_act_hours*/
11853: set SCHEDULED_DURATION = l_sch_dur,

Line 11893: update pa_projects_all

11889: END IF;*/
11890: END IF;
11891:
11892: --hsiu: removed record version number for Forms changes
11893: update pa_projects_all
11894: -- set SCHEDULED_DURATION = l_sch_hours
11895: set SCHEDULED_DURATION = l_sch_dur
11896: where project_id = p_project_id;
11897:

Line 12002: from pa_projects_all

11998: is
11999: Cursor c_calendar_projects
12000: IS
12001: Select project_id
12002: from pa_projects_all
12003: where calendar_id = p_calendar_id;
12004: BEGIN
12005: IF (p_debug_mode = 'Y') THEN
12006: pa_debug.debug('PA_PROJECT_STRUCTURE_PVT1.UPDATE_ALL_WP_CALENDAR BEGIN');

Line 12656: from pa_projects_all ppa,

12652:
12653: CURSOR get_project_info(c_project_id NUMBER) IS
12654: select ppa.name name, ppa.segment1,
12655: hou.name carrying_out_org_name, ppl.full_name
12656: from pa_projects_all ppa,
12657: hr_all_organization_units hou,
12658: per_all_people_f ppl,
12659: pa_project_parties ppp
12660: where ppa.carrying_out_organization_id = hou.organization_id

Line 14235: l_sys_program_flag PA_PROJECTS_ALL.sys_program_flag%TYPE;

14231: l_proj_completion_date DATE;
14232: l_proj_prog_attr_id NUMBER;
14233:
14234: -- FP.M Changes below
14235: l_sys_program_flag PA_PROJECTS_ALL.sys_program_flag%TYPE;
14236: l_allow_multi_program_rollup PA_PROJECTS_ALL.allow_multi_program_rollup%TYPE;
14237: l_proj_sys_program_flag PA_PROJECTS_ALL.sys_program_flag%TYPE;
14238: l_proj_allow_program_rollup PA_PROJECTS_ALL.allow_multi_program_rollup%TYPE;
14239: l_flag VARCHAR2(1);

Line 14236: l_allow_multi_program_rollup PA_PROJECTS_ALL.allow_multi_program_rollup%TYPE;

14232: l_proj_prog_attr_id NUMBER;
14233:
14234: -- FP.M Changes below
14235: l_sys_program_flag PA_PROJECTS_ALL.sys_program_flag%TYPE;
14236: l_allow_multi_program_rollup PA_PROJECTS_ALL.allow_multi_program_rollup%TYPE;
14237: l_proj_sys_program_flag PA_PROJECTS_ALL.sys_program_flag%TYPE;
14238: l_proj_allow_program_rollup PA_PROJECTS_ALL.allow_multi_program_rollup%TYPE;
14239: l_flag VARCHAR2(1);
14240:

Line 14237: l_proj_sys_program_flag PA_PROJECTS_ALL.sys_program_flag%TYPE;

14233:
14234: -- FP.M Changes below
14235: l_sys_program_flag PA_PROJECTS_ALL.sys_program_flag%TYPE;
14236: l_allow_multi_program_rollup PA_PROJECTS_ALL.allow_multi_program_rollup%TYPE;
14237: l_proj_sys_program_flag PA_PROJECTS_ALL.sys_program_flag%TYPE;
14238: l_proj_allow_program_rollup PA_PROJECTS_ALL.allow_multi_program_rollup%TYPE;
14239: l_flag VARCHAR2(1);
14240:
14241: -- NYU

Line 14238: l_proj_allow_program_rollup PA_PROJECTS_ALL.allow_multi_program_rollup%TYPE;

14234: -- FP.M Changes below
14235: l_sys_program_flag PA_PROJECTS_ALL.sys_program_flag%TYPE;
14236: l_allow_multi_program_rollup PA_PROJECTS_ALL.allow_multi_program_rollup%TYPE;
14237: l_proj_sys_program_flag PA_PROJECTS_ALL.sys_program_flag%TYPE;
14238: l_proj_allow_program_rollup PA_PROJECTS_ALL.allow_multi_program_rollup%TYPE;
14239: l_flag VARCHAR2(1);
14240:
14241: -- NYU
14242: l_del_trans_exist VARCHAR2(1);

Line 14246: from pa_projects_all

14242: l_del_trans_exist VARCHAR2(1);
14243:
14244: CURSOR get_project_info IS
14245: select name, target_start_date, target_finish_date, sys_program_flag, allow_multi_program_rollup
14246: from pa_projects_all
14247: where project_id = p_project_id;
14248:
14249: --bug 2843569: added record_version_number
14250: CURSOR get_template_flag IS

Line 14252: from pa_projects_all

14248:
14249: --bug 2843569: added record_version_number
14250: CURSOR get_template_flag IS
14251: select template_flag, record_version_number
14252: from pa_projects_all
14253: where project_id = p_project_id;
14254:
14255: CURSOR get_wp_attr_rvn IS
14256: select b.proj_element_id, a.record_version_number

Line 14389: from pa_projects_all

14385:
14386: --hsiu added for bug 2634029
14387: cursor sel_target_dates IS
14388: select target_start_date, target_finish_date, calendar_id
14389: from pa_projects_all
14390: where project_id = p_project_id;
14391:
14392: CURSOR get_top_tasks(c_structure_version_id NUMBER) IS
14393: select v.element_version_id

Line 14465: , pa_projects_all ppa

14461: , ppev.parent_structure_version_id src_str_ver_id
14462: , por1.record_version_number rec_ver_number
14463: from pa_object_relationships por1
14464: , pa_object_relationships por2
14465: , pa_projects_all ppa
14466: , pa_proj_element_versions ppev
14467: , pa_proj_elem_ver_structure ppevs
14468: where por1.object_id_to2 = c_project_id
14469: and por1.relationship_type in ('LW', 'LF')

Line 14493: , pa_projects_all ppa

14489: , ppev.parent_structure_version_id src_str_ver_id
14490: , por1.record_version_number rec_ver_number
14491: from pa_object_relationships por1
14492: , pa_object_relationships por2
14493: , pa_projects_all ppa
14494: , pa_proj_element_versions ppev
14495: , pa_proj_elem_ver_structure ppevs
14496: where por1.object_id_from2 = c_project_id
14497: and por1.relationship_type in ('LW', 'LF')

Line 17966: update pa_projects_all

17962: ELSE
17963: l_new_share_code := p_sharing_option_code;
17964: END IF;
17965:
17966: update pa_projects_all
17967: set structure_sharing_code = l_new_share_code
17968: where project_id = p_project_id;
17969:
17970: IF l_delv_enabled = 'Y' THEN

Line 18147: UPDATE pa_projects_all

18143: END IF;
18144: END IF;
18145:
18146: -- IF NOT FND_API.TO_BOOLEAN(p_validate_only) THEN
18147: UPDATE pa_projects_all
18148: SET
18149: sys_program_flag = nvl(l_sys_program_flag,'N'),
18150: allow_multi_program_rollup = nvl(l_allow_multi_program_rollup,'N'),
18151: CBS_VERSION_ID=p_cbs_version_id , --added for CBS 15834912