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_PROJ_WORKPLAN_ATTR

Line 422: --Add pa_proj_workplan_attr row

418: RAISE FND_API.G_EXC_ERROR;
419: END IF;
420:
421: IF (l_structure_type IN ('WORKPLAN','DELIVERABLE')) THEN
422: --Add pa_proj_workplan_attr row
423: PA_WORKPLAN_ATTR_PVT.CREATE_PROJ_WORKPLAN_ATTRS(
424: p_validate_only => FND_API.G_FALSE
425: ,p_project_id => p_project_id
426: ,p_proj_element_id => l_proj_element_id

Line 7334: from pa_proj_workplan_attr

7330:
7331:
7332: CURSOR get_wp_attr(c_proj_element_id NUMBER) IS
7333: select *
7334: from pa_proj_workplan_attr
7335: where proj_element_id = c_proj_element_id;
7336: l_wp_attr_rec get_wp_attr%ROWTYPE;
7337:
7338: CURSOR get_progress_attr(c_proj_element_id NUMBER, c_project_id NUMBER) IS -- For Bug 3968095

Line 8813: select '1' from pa_proj_workplan_attr

8809: l_msg_data VARCHAR2(250);
8810: l_error_msg_code VARCHAR2(250);
8811:
8812: CURSOR checkAutoPub IS
8813: select '1' from pa_proj_workplan_attr
8814: where project_id = p_project_id
8815: and wp_auto_publish_flag = 'Y';
8816:
8817: CURSOR get_wp_info IS

Line 9304: select nvl(wp_approval_reqd_flag,'N') from pa_proj_workplan_attr

9300: l_msg_count NUMBER;
9301: l_msg_data VARCHAR2(300);
9302:
9303: CURSOR check_approve_req IS
9304: select nvl(wp_approval_reqd_flag,'N') from pa_proj_workplan_attr
9305: where project_id = p_project_id;
9306:
9307: /* Bug 2680486 -- Performance changes -- Added the join of wf_type_code to avoid full table scan on pa_wf_processes*/
9308:

Line 9524: from pa_proj_workplan_attr a,

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
9524: from pa_proj_workplan_attr a,
9525: pa_proj_elements b,
9526: pa_proj_structure_types c,
9527: pa_structure_types d
9528: where a.project_id = b.project_id

Line 9588: from pa_proj_workplan_attr

9584: and element_version_id = c_struc_ver_id;
9585:
9586: cursor sel_proj_workplan_attr(c_struc_id NUMBER) is
9587: select *
9588: from pa_proj_workplan_attr
9589: where proj_element_id = c_struc_id;
9590: l_proj_workplan_attr_rec sel_proj_workplan_attr%ROWTYPE;
9591:
9592: cursor sel_proj_progress_attr(c_struc_id NUMBER) IS

Line 11018: l_curr_wp_ver_flag PA_PROJ_WORKPLAN_ATTR.WP_ENABLE_VERSION_FLAG%TYPE;

11014: l_dummy VARCHAR2(1);
11015: --end bug 4263266
11016:
11017: --BUG 4330926
11018: l_curr_wp_ver_flag PA_PROJ_WORKPLAN_ATTR.WP_ENABLE_VERSION_FLAG%TYPE;
11019:
11020: CURSOR get_curr_wp_flag (l_proj_element_id NUMBER, l_project_id NUMBER )IS
11021: SELECT WP_ENABLE_VERSION_FLAG
11022: FROM PA_PROJ_WORKPLAN_ATTR

Line 11022: FROM PA_PROJ_WORKPLAN_ATTR

11018: l_curr_wp_ver_flag PA_PROJ_WORKPLAN_ATTR.WP_ENABLE_VERSION_FLAG%TYPE;
11019:
11020: CURSOR get_curr_wp_flag (l_proj_element_id NUMBER, l_project_id NUMBER )IS
11021: SELECT WP_ENABLE_VERSION_FLAG
11022: FROM PA_PROJ_WORKPLAN_ATTR
11023: WHERE PROJ_ELEMENT_ID = l_proj_element_id
11024: AND PROJECT_ID = l_project_id;
11025:
11026: --BUG 4330926

Line 11934: from pa_proj_workplan_attr

11930: and r.object_type_from = 'PA_STRUCTURES';
11931:
11932: cursor sel_wp_attr(c_proj_element_id NUMBER) IS
11933: select record_version_number
11934: from pa_proj_workplan_attr
11935: where proj_element_id = c_proj_element_id;
11936:
11937: l_project_id PA_PROJ_ELEMENT_VERSIONS.PROJECT_ID%TYPE;
11938: l_proj_element_id PA_PROJ_ELEMENTS.PROJ_ELEMENT_ID%TYPE;

Line 11950: l_wp_attr_rvn PA_PROJ_WORKPLAN_ATTR.RECORD_VERSION_NUMBER%TYPE;

11946: l_pevsh_rowid VARCHAR2(255);
11947:
11948: l_task_version_id PA_PROJ_ELEMENT_VERSIONS.ELEMENT_VERSION_ID%TYPE;
11949: l_task_rvn PA_PROJ_ELEMENT_VERSIONS.RECORD_VERSION_NUMBER%TYPE;
11950: l_wp_attr_rvn PA_PROJ_WORKPLAN_ATTR.RECORD_VERSION_NUMBER%TYPE;
11951:
11952: l_parent_struc_ver_id PA_PROJ_ELEMENT_VERSIONS.PARENT_STRUCTURE_VERSION_ID%TYPE;
11953:
11954: BEGIN

Line 13883: from pa_proj_workplan_attr a,

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
13883: from pa_proj_workplan_attr a,
13884: pa_proj_elements b,
13885: pa_proj_structure_types c,
13886: pa_structure_types d
13887: where a.project_id = b.project_id

Line 13950: from pa_proj_workplan_attr

13946: and element_version_id = c_struc_ver_id;
13947:
13948: cursor sel_proj_workplan_attr(c_struc_id NUMBER) is
13949: select *
13950: from pa_proj_workplan_attr
13951: where proj_element_id = c_struc_id;
13952: l_proj_workplan_attr_rec sel_proj_workplan_attr%ROWTYPE;
13953:
13954: cursor sel_proj_progress_attr(c_struc_id NUMBER) IS

Line 14297: --create row in pa_proj_workplan_attr

14293: END IF;
14294: RAISE FND_API.G_EXC_ERROR;
14295: END IF;
14296:
14297: --create row in pa_proj_workplan_attr
14298: PA_PROJECT_STRUCTURE_PUB1.ENABLE_FINANCIAL_STRUCTURE
14299: (p_validate_only => FND_API.G_FALSE
14300: ,p_project_id => p_project_id
14301: ,p_proj_element_id => l_structure_id

Line 14659: --create row in pa_proj_workplan_attr

14655: END IF;
14656: RAISE FND_API.G_EXC_ERROR;
14657: END IF;
14658:
14659: --create row in pa_proj_workplan_attr
14660: PA_PROJECT_STRUCTURE_PUB1.ENABLE_FINANCIAL_STRUCTURE
14661: (p_validate_only => FND_API.G_FALSE
14662: ,p_project_id => p_project_id
14663: ,p_proj_element_id => l_structure_id

Line 15470: --create row in pa_proj_workplan_attr

15466: END IF;
15467: RAISE FND_API.G_EXC_ERROR;
15468: END IF;
15469:
15470: --create row in pa_proj_workplan_attr
15471: PA_PROJECT_STRUCTURE_PUB1.ENABLE_FINANCIAL_STRUCTURE
15472: (p_validate_only => FND_API.G_FALSE
15473: ,p_project_id => p_project_id
15474: ,p_proj_element_id => l_structure_id

Line 15776: --create row in pa_proj_workplan_attr

15772: END IF;
15773: RAISE FND_API.G_EXC_ERROR;
15774: END IF;
15775:
15776: --create row in pa_proj_workplan_attr
15777: PA_PROJECT_STRUCTURE_PUB1.ENABLE_FINANCIAL_STRUCTURE
15778: (p_validate_only => FND_API.G_FALSE
15779: ,p_project_id => p_project_id
15780: ,p_proj_element_id => l_structure_id

Line 16149: update pa_proj_workplan_attr

16145: END IF;
16146:
16147: --bug 3894059
16148: --set versioning disable for financial structure, and structure version as published if it is a project
16149: update pa_proj_workplan_attr
16150: set WP_ENABLE_VERSION_FLAG = 'N'
16151: where proj_element_id = l_structure_id;
16152:
16153: IF (l_template_flag <> 'Y') THEN

Line 16615: update pa_proj_workplan_attr

16611: END IF;
16612:
16613: --bug 3894059
16614: --set versioning disable for financial structure, and structure version as published if it is a project
16615: update pa_proj_workplan_attr
16616: set WP_ENABLE_VERSION_FLAG = 'N'
16617: where proj_element_id = l_structure_id;
16618:
16619: IF (l_template_flag <> 'Y') THEN

Line 17307: --remove financial structure row in pa_proj_workplan_attr

17303: END IF;
17304: END IF;
17305: ELSIF (p_workplan_enabled_flag = 'Y' and p_financial_enabled_flag = 'Y' and p_sharing_option_code IN ('SHARE_FULL','SHARE_PARTIAL')) THEN
17306: --partial share/full share
17307: --remove financial structure row in pa_proj_workplan_attr
17308: --delete all workplan dependencies
17309: --delete workplan structure
17310: --add schedule rows for financial structure and tasks
17311: --add workplan structure type