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_TASK_PUB1 dependencies on PA_PROJ_ELEM_VER_STRUCTURE

Line 3557: FROM pa_proj_elem_ver_structure

3553:
3554: CURSOR cur_struc_id( x_structure_version_id NUMBER, x_project_id NUMBER )
3555: IS
3556: SELECT proj_element_id
3557: FROM pa_proj_elem_ver_structure
3558: WHERE element_version_id = x_structure_version_id
3559: AND project_id = x_project_id;
3560:
3561:

Line 3585: from pa_proj_elem_ver_structure

3581: We should check a structure version is and not structure id to
3582: find out a structure version is publised or not */
3583: /* CURSOR cur_pub_versions( c_structure_id NUMBER, c_project_id NUMBER ) is
3584: select 'Y'
3585: from pa_proj_elem_ver_structure
3586: where proj_element_id = c_structure_id
3587: AND project_id = c_project_id
3588: and STATUS_CODE = 'STRUCTURE_PUBLISHED';
3589: */

Line 3595: from pa_proj_elem_ver_structure

3591: --bug 3074706
3592: --added project_id
3593: CURSOR cur_pub_versions( c_structure_version_id NUMBER, c_project_id NUMBER ) is
3594: select 'Y'
3595: from pa_proj_elem_ver_structure
3596: where element_version_id = c_structure_version_id
3597: and project_id = c_project_id
3598: and STATUS_CODE = 'STRUCTURE_PUBLISHED';
3599: --end bug 3074706

Line 5427: from pa_proj_elem_ver_structure

5423: AND pst.structure_type_class_code IN( 'FINANCIAL' );
5424:
5425: CURSOR cur_pub_versions( c_structure_id NUMBER, c_project_id NUMBER ) is
5426: select 'Y'
5427: from pa_proj_elem_ver_structure
5428: where proj_element_id = c_structure_id
5429: AND project_id = c_project_id
5430: and STATUS_CODE = 'STRUCTURE_PUBLISHED';
5431:

Line 6032: pa_proj_elem_ver_structure ppa,

6028: --hsiu Fixed parent_structure_version_id condition
6029: SELECT ppev.proj_element_id, pt.record_version_number, ppa.wbs_record_version_number, ppev.project_id
6030: INTO l_task_id, l_task_record_version_number, l_wbs_record_version_number, l_project_id
6031: FROM PA_TASKS pt,
6032: pa_proj_elem_ver_structure ppa,
6033: PA_PROJ_ELEMENT_VERSIONS ppev
6034: WHERE ppev.element_version_id = p_task_version_id
6035: AND ppev.project_id = ppa.project_id
6036: AND ppev.parent_structure_version_id = ppa.element_version_id

Line 6610: from pa_proj_elem_ver_structure

6606: AND pst.structure_type_class_code IN( 'FINANCIAL' );
6607:
6608: CURSOR cur_pub_versions( c_structure_id NUMBER, c_project_id NUMBER ) is
6609: select 'Y'
6610: from pa_proj_elem_ver_structure
6611: where proj_element_id = c_structure_id
6612: AND project_id = c_project_id
6613: and STATUS_CODE = 'STRUCTURE_PUBLISHED';
6614:

Line 6929: pa_proj_elem_ver_structure ppa,

6925:
6926: SELECT ppev.proj_element_id, pt.record_version_number, ppa.wbs_record_version_number, ppev.project_id
6927: INTO l_task_id, l_task_record_version_number, l_wbs_record_version_number, l_project_id
6928: FROM PA_TASKS pt,
6929: pa_proj_elem_ver_structure ppa,
6930: PA_PROJ_ELEMENT_VERSIONS ppev
6931: WHERE ppev.element_version_id = p_task_version_id
6932: AND ppev.parent_structure_version_id = ppa.element_version_id
6933: AND ppev.project_id = ppa.project_id

Line 7157: from pa_proj_elem_ver_structure

7153: AND pst.structure_type_class_code IN( 'FINANCIAL' );
7154:
7155: CURSOR cur_pub_versions( c_structure_id NUMBER, c_project_id NUMBER ) is
7156: select 'Y'
7157: from pa_proj_elem_ver_structure
7158: where proj_element_id = c_structure_id
7159: AND project_id = c_project_id
7160: and STATUS_CODE = 'STRUCTURE_PUBLISHED';
7161:

Line 7410: pa_proj_elem_ver_structure ppa,

7406:
7407: SELECT ppev.proj_element_id, pt.record_version_number, ppa.wbs_record_version_number, ppev.project_id
7408: INTO l_task_id, l_task_record_version_number, l_wbs_record_version_number, l_project_id
7409: FROM PA_TASKS pt,
7410: pa_proj_elem_ver_structure ppa,
7411: PA_PROJ_ELEMENT_VERSIONS ppev
7412: WHERE ppev.element_version_id = p_task_version_id
7413: AND ppev.parent_structure_version_id = ppa.element_version_id
7414: AND ppev.project_id = ppa.project_id

Line 9109: FROM pa_proj_elem_ver_structure

9105: SELECT 'Y'
9106: FROM dual
9107: WHERE EXISTS(
9108: SELECT 'xyz'
9109: FROM pa_proj_elem_ver_structure
9110: WHERE proj_element_id = c_structure_id
9111: AND project_id = c_project_id
9112: AND STATUS_CODE = 'STRUCTURE_PUBLISHED'
9113: );

Line 10119: pa_proj_elem_ver_structure ppa,

10115:
10116: SELECT ppev.proj_element_id, pt.record_version_number, ppa.wbs_record_version_number, ppev.project_id
10117: INTO l_task_id, l_task_record_version_number, l_wbs_record_version_number, l_project_id
10118: FROM PA_TASKS pt,
10119: pa_proj_elem_ver_structure ppa,
10120: PA_PROJ_ELEMENT_VERSIONS ppev
10121: WHERE ppev.element_version_id = p_task_version_id
10122: AND ppev.parent_structure_version_id = ppa.element_version_id
10123: AND ppev.project_id = ppa.project_id

Line 10577: FROM pa_proj_elem_ver_structure

10573: SELECT 'Y'
10574: FROM dual
10575: WHERE EXISTS(
10576: SELECT 'xyz'
10577: FROM pa_proj_elem_ver_structure
10578: WHERE proj_element_id = c_structure_id
10579: AND project_id = c_project_id
10580: AND STATUS_CODE = 'STRUCTURE_PUBLISHED'
10581: );

Line 11700: pa_proj_elem_ver_structure ppa,

11696:
11697: SELECT ppev.proj_element_id, pt.record_version_number, ppa.wbs_record_version_number, ppev.project_id
11698: INTO l_task_id, l_task_record_version_number, l_wbs_record_version_number, l_project_id
11699: FROM PA_TASKS pt,
11700: pa_proj_elem_ver_structure ppa,
11701: PA_PROJ_ELEMENT_VERSIONS ppev
11702: WHERE ppev.element_version_id = p_task_version_id
11703: AND ppev.parent_structure_version_id = ppa.element_version_id
11704: AND ppev.project_id = ppa.project_id

Line 14726: FROM pa_proj_elem_ver_structure

14722:
14723: CURSOR cur_struc_id( x_structure_version_id NUMBER, x_project_id NUMBER )
14724: IS
14725: SELECT proj_element_id
14726: FROM pa_proj_elem_ver_structure
14727: WHERE element_version_id = x_structure_version_id
14728: AND project_id = x_project_id;
14729:
14730: CURSOR get_product_code ( c_project_id NUMBER ) IS

Line 15189: from pa_proj_elem_ver_structure

15185: AND pst.structure_type_class_code = 'FINANCIAL' ;
15186:
15187: CURSOR cur_pub_versions( c_structure_id NUMBER, c_project_id NUMBER ) is
15188: select 'Y'
15189: from pa_proj_elem_ver_structure
15190: where proj_element_id = c_structure_id
15191: AND project_id = c_project_id
15192: and STATUS_CODE = 'STRUCTURE_PUBLISHED';
15193:

Line 15719: -- 4533534 : Included join of pa_proj_elem_ver_structure too

15715: l_debug_mode VARCHAR2(1);
15716: l_module_name VARCHAR2(100):= 'PA_TASK_PUB1.CANCEL_TASK';
15717: l_error_message_code VARCHAR2(32);
15718:
15719: -- 4533534 : Included join of pa_proj_elem_ver_structure too
15720: CURSOR c_get_all_task_versions(c_task_id NUMBER, c_project_id NUMBER) IS
15721: SELECT ver.element_version_id, str.status_code
15722: FROM pa_proj_element_versions ver
15723: , pa_proj_elem_ver_structure str

Line 15723: , pa_proj_elem_ver_structure str

15719: -- 4533534 : Included join of pa_proj_elem_ver_structure too
15720: CURSOR c_get_all_task_versions(c_task_id NUMBER, c_project_id NUMBER) IS
15721: SELECT ver.element_version_id, str.status_code
15722: FROM pa_proj_element_versions ver
15723: , pa_proj_elem_ver_structure str
15724: WHERE ver.project_id = c_project_id
15725: AND ver.proj_element_id = c_task_id
15726: AND ver.project_id = str.project_id
15727: and ver.parent_structure_version_id = str.element_version_id