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 7394: from pa_proj_workplan_attr

7390:
7391:
7392: CURSOR get_wp_attr(c_proj_element_id NUMBER) IS
7393: select *
7394: from pa_proj_workplan_attr
7395: where proj_element_id = c_proj_element_id;
7396: l_wp_attr_rec get_wp_attr%ROWTYPE;
7397:
7398: CURSOR get_progress_attr(c_proj_element_id NUMBER, c_project_id NUMBER) IS -- For Bug 3968095

Line 9185: select '1' from pa_proj_workplan_attr

9181: l_msg_data VARCHAR2(250);
9182: l_error_msg_code VARCHAR2(250);
9183:
9184: CURSOR checkAutoPub IS
9185: select '1' from pa_proj_workplan_attr
9186: where project_id = p_project_id
9187: and wp_auto_publish_flag = 'Y';
9188:
9189: CURSOR get_wp_info IS

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

9672: l_msg_count NUMBER;
9673: l_msg_data VARCHAR2(300);
9674:
9675: CURSOR check_approve_req IS
9676: select nvl(wp_approval_reqd_flag,'N') from pa_proj_workplan_attr
9677: where project_id = p_project_id;
9678:
9679: /* Bug 2680486 -- Performance changes -- Added the join of wf_type_code to avoid full table scan on pa_wf_processes*/
9680:

Line 9896: from pa_proj_workplan_attr a,

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
9896: from pa_proj_workplan_attr a,
9897: pa_proj_elements b,
9898: pa_proj_structure_types c,
9899: pa_structure_types d
9900: where a.project_id = b.project_id

Line 9960: from pa_proj_workplan_attr

9956: and element_version_id = c_struc_ver_id;
9957:
9958: cursor sel_proj_workplan_attr(c_struc_id NUMBER) is
9959: select *
9960: from pa_proj_workplan_attr
9961: where proj_element_id = c_struc_id;
9962: l_proj_workplan_attr_rec sel_proj_workplan_attr%ROWTYPE;
9963:
9964: cursor sel_proj_progress_attr(c_struc_id NUMBER) IS

Line 11390: l_curr_wp_ver_flag PA_PROJ_WORKPLAN_ATTR.WP_ENABLE_VERSION_FLAG%TYPE;

11386: l_dummy VARCHAR2(1);
11387: --end bug 4263266
11388:
11389: --BUG 4330926
11390: l_curr_wp_ver_flag PA_PROJ_WORKPLAN_ATTR.WP_ENABLE_VERSION_FLAG%TYPE;
11391:
11392: CURSOR get_curr_wp_flag (l_proj_element_id NUMBER, l_project_id NUMBER )IS
11393: SELECT WP_ENABLE_VERSION_FLAG
11394: FROM PA_PROJ_WORKPLAN_ATTR

Line 11394: FROM PA_PROJ_WORKPLAN_ATTR

11390: l_curr_wp_ver_flag PA_PROJ_WORKPLAN_ATTR.WP_ENABLE_VERSION_FLAG%TYPE;
11391:
11392: CURSOR get_curr_wp_flag (l_proj_element_id NUMBER, l_project_id NUMBER )IS
11393: SELECT WP_ENABLE_VERSION_FLAG
11394: FROM PA_PROJ_WORKPLAN_ATTR
11395: WHERE PROJ_ELEMENT_ID = l_proj_element_id
11396: AND PROJECT_ID = l_project_id;
11397:
11398: --BUG 4330926

Line 12306: from pa_proj_workplan_attr

12302: and r.object_type_from = 'PA_STRUCTURES';
12303:
12304: cursor sel_wp_attr(c_proj_element_id NUMBER) IS
12305: select record_version_number
12306: from pa_proj_workplan_attr
12307: where proj_element_id = c_proj_element_id;
12308:
12309: l_project_id PA_PROJ_ELEMENT_VERSIONS.PROJECT_ID%TYPE;
12310: l_proj_element_id PA_PROJ_ELEMENTS.PROJ_ELEMENT_ID%TYPE;

Line 12322: l_wp_attr_rvn PA_PROJ_WORKPLAN_ATTR.RECORD_VERSION_NUMBER%TYPE;

12318: l_pevsh_rowid VARCHAR2(255);
12319:
12320: l_task_version_id PA_PROJ_ELEMENT_VERSIONS.ELEMENT_VERSION_ID%TYPE;
12321: l_task_rvn PA_PROJ_ELEMENT_VERSIONS.RECORD_VERSION_NUMBER%TYPE;
12322: l_wp_attr_rvn PA_PROJ_WORKPLAN_ATTR.RECORD_VERSION_NUMBER%TYPE;
12323:
12324: l_parent_struc_ver_id PA_PROJ_ELEMENT_VERSIONS.PARENT_STRUCTURE_VERSION_ID%TYPE;
12325:
12326: BEGIN

Line 14257: from pa_proj_workplan_attr a,

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
14257: from pa_proj_workplan_attr a,
14258: pa_proj_elements b,
14259: pa_proj_structure_types c,
14260: pa_structure_types d
14261: where a.project_id = b.project_id

Line 14324: from pa_proj_workplan_attr

14320: and element_version_id = c_struc_ver_id;
14321:
14322: cursor sel_proj_workplan_attr(c_struc_id NUMBER) is
14323: select *
14324: from pa_proj_workplan_attr
14325: where proj_element_id = c_struc_id;
14326: l_proj_workplan_attr_rec sel_proj_workplan_attr%ROWTYPE;
14327:
14328: cursor sel_proj_progress_attr(c_struc_id NUMBER) IS

Line 14673: --create row in pa_proj_workplan_attr

14669: END IF;
14670: RAISE FND_API.G_EXC_ERROR;
14671: END IF;
14672:
14673: --create row in pa_proj_workplan_attr
14674: PA_PROJECT_STRUCTURE_PUB1.ENABLE_FINANCIAL_STRUCTURE
14675: (p_validate_only => FND_API.G_FALSE
14676: ,p_project_id => p_project_id
14677: ,p_proj_element_id => l_structure_id

Line 15035: --create row in pa_proj_workplan_attr

15031: END IF;
15032: RAISE FND_API.G_EXC_ERROR;
15033: END IF;
15034:
15035: --create row in pa_proj_workplan_attr
15036: PA_PROJECT_STRUCTURE_PUB1.ENABLE_FINANCIAL_STRUCTURE
15037: (p_validate_only => FND_API.G_FALSE
15038: ,p_project_id => p_project_id
15039: ,p_proj_element_id => l_structure_id

Line 15846: --create row in pa_proj_workplan_attr

15842: END IF;
15843: RAISE FND_API.G_EXC_ERROR;
15844: END IF;
15845:
15846: --create row in pa_proj_workplan_attr
15847: PA_PROJECT_STRUCTURE_PUB1.ENABLE_FINANCIAL_STRUCTURE
15848: (p_validate_only => FND_API.G_FALSE
15849: ,p_project_id => p_project_id
15850: ,p_proj_element_id => l_structure_id

Line 16152: --create row in pa_proj_workplan_attr

16148: END IF;
16149: RAISE FND_API.G_EXC_ERROR;
16150: END IF;
16151:
16152: --create row in pa_proj_workplan_attr
16153: PA_PROJECT_STRUCTURE_PUB1.ENABLE_FINANCIAL_STRUCTURE
16154: (p_validate_only => FND_API.G_FALSE
16155: ,p_project_id => p_project_id
16156: ,p_proj_element_id => l_structure_id

Line 16525: update pa_proj_workplan_attr

16521: END IF;
16522:
16523: --bug 3894059
16524: --set versioning disable for financial structure, and structure version as published if it is a project
16525: update pa_proj_workplan_attr
16526: set WP_ENABLE_VERSION_FLAG = 'N'
16527: where proj_element_id = l_structure_id;
16528:
16529: IF (l_template_flag <> 'Y') THEN

Line 16991: update pa_proj_workplan_attr

16987: END IF;
16988:
16989: --bug 3894059
16990: --set versioning disable for financial structure, and structure version as published if it is a project
16991: update pa_proj_workplan_attr
16992: set WP_ENABLE_VERSION_FLAG = 'N'
16993: where proj_element_id = l_structure_id;
16994:
16995: IF (l_template_flag <> 'Y') THEN

Line 17683: --remove financial structure row in pa_proj_workplan_attr

17679: END IF;
17680: END IF;
17681: ELSIF (p_workplan_enabled_flag = 'Y' and p_financial_enabled_flag = 'Y' and p_sharing_option_code IN ('SHARE_FULL','SHARE_PARTIAL')) THEN
17682: --partial share/full share
17683: --remove financial structure row in pa_proj_workplan_attr
17684: --delete all workplan dependencies
17685: --delete workplan structure
17686: --add schedule rows for financial structure and tasks
17687: --add workplan structure type