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_PROJ_TASK_STRUC_PUB dependencies on PA_PROJ_WORKPLAN_ATTR

Line 1175: from pa_proj_workplan_attr

1171:
1172: CURSOR cur_proj_wrk_attr
1173: IS
1174: select AUTO_PUB_UPON_CREATION_FLAG
1175: from pa_proj_workplan_attr
1176: where project_id = p_project_id;
1177: l_auto_pub_flag VARCHAR2(1);
1178: --proj conn
1179: --bug 2736392

Line 3974: and pa_proj_workplan_attr. */

3970: DELETE FROM pa_proj_elem_ver_schedule where project_id = p_project_id;
3971: DELETE FROM pa_proj_elem_ver_structure where project_id = p_project_id;
3972:
3973: /* Code to delete project records from tables: pa_progress_rollup, pa_proj_progress_attr
3974: and pa_proj_workplan_attr. */
3975:
3976: BEGIN
3977:
3978: PA_PROGRESS_PUB.delete_working_wp_progress (

Line 5220: from pa_proj_workplan_attr

5216: and c.structure_type = p_structure_type;
5217:
5218: cursor c3 is
5219: select wp_enable_version_flag
5220: from pa_proj_workplan_attr
5221: where project_id = p_project_id;
5222:
5223: cursor c4(c_proj_elem_id NUMBER) is
5224: select '1' from pa_proj_elem_ver_structure

Line 6592: FROM pa_proj_workplan_attr ppwa

6588: ) IS
6589: --This cursor fetches the workplan structure attributes
6590: CURSOR cur_get_wp_attr IS
6591: SELECT ppwa.WP_ENABLE_VERSION_FLAG
6592: FROM pa_proj_workplan_attr ppwa
6593: ,pa_proj_structure_types ppst
6594: ,pa_structure_types pst
6595: WHERE ppwa.project_id = p_src_project_id
6596: AND ppwa.proj_element_id = ppst.proj_element_id

Line 7856: FROM pa_proj_workplan_attr ppwa

7852:
7853: --This cursor fetches the workplan structure attributes
7854: CURSOR cur_get_wp_attr IS
7855: SELECT ppwa.WP_ENABLE_VERSION_FLAG
7856: FROM pa_proj_workplan_attr ppwa
7857: ,pa_proj_structure_types ppst
7858: ,pa_structure_types pst
7859: WHERE ppwa.project_id = p_src_project_id
7860: AND ppwa.proj_element_id = ppst.proj_element_id

Line 8068: FROM PA_PROJ_WORKPLAN_ATTR ppwa

8064:
8065: --3916763 Begin
8066: CURSOR c_get_approval_options IS
8067: SELECT wp_approval_reqd_flag, wp_auto_publish_flag, wp_approver_source_id
8068: FROM PA_PROJ_WORKPLAN_ATTR ppwa
8069: , PA_PROJ_STRUCTURE_TYPES ppst
8070: , PA_STRUCTURE_TYPES pst
8071: WHERE ppwa.PROJECT_ID = p_src_project_id
8072: AND ppwa.PROJ_ELEMENT_ID = ppst.PROJ_ELEMENT_ID

Line 8537: INSERT INTO pa_proj_workplan_attr(

8533: AND pst.structure_type IN ('WORKPLAN','FINANCIAL') )
8534: AND ppe.attribute15 = ppst.proj_element_id ; --proj_element_id is unique in pa_proj_structure_types
8535:
8536: --Copy workplan attributes for financial and workplan structures
8537: INSERT INTO pa_proj_workplan_attr(
8538: PROJ_ELEMENT_ID
8539: ,PROJECT_ID
8540: ,LAST_UPDATE_DATE
8541: ,LAST_UPDATED_BY

Line 8599: pa_proj_workplan_attr ppwa

8595: -- gboomina added for bug 8586393 - start
8596: ,ppwa.use_task_schedule_flag
8597: -- gboomina added for bug 8586393 - end
8598: FROM pa_proj_elements ppe,
8599: pa_proj_workplan_attr ppwa
8600: WHERE ppwa.project_id = p_src_project_id
8601: AND ppe.attribute15 = ppwa.proj_element_id
8602: AND PA_PROJ_ELEMENTS_UTILS.check_fin_or_wp_structure( ppe.proj_element_id ) = 'Y'
8603: AND ppe.project_id = p_dest_project_id --bug 3939786

Line 10909: from pa_proj_workplan_attr

10905:
10906: /*bug 3737444 : The below code commented */
10907: /* CURSOR get_wp_attr IS
10908: select *
10909: from pa_proj_workplan_attr
10910: where project_id = p_src_project_id; */
10911:
10912: /* Code Addition starts for bug 3737444 */
10913: CURSOR get_wp_attr IS

Line 10914: select * from pa_proj_workplan_attr pppa where pppa.project_id=p_src_project_id

10910: where project_id = p_src_project_id; */
10911:
10912: /* Code Addition starts for bug 3737444 */
10913: CURSOR get_wp_attr IS
10914: select * from pa_proj_workplan_attr pppa where pppa.project_id=p_src_project_id
10915: and exists (select null from pa_proj_structure_types pst, pa_structure_types ps
10916: where pst.structure_type_id=ps.structure_type_id
10917: and ps. STRUCTURE_TYPE ='WORKPLAN'
10918: and pst.proj_element_id=pppa.proj_element_id);

Line 11843: INSERT INTO pa_proj_workplan_attr(

11839: AND pst.structure_type in ('WORKPLAN','FINANCIAL'));
11840: --Added by rtarway for BUG 3951701
11841: --Copy workplan attributes for financial only structures
11842:
11843: INSERT INTO pa_proj_workplan_attr(
11844: PROJ_ELEMENT_ID
11845: ,PROJECT_ID
11846: ,LAST_UPDATE_DATE
11847: ,LAST_UPDATED_BY

Line 11903: pa_proj_workplan_attr ppwa

11899: -- gboomina Bug 8586393 - start
11900: ,ppwa.use_task_schedule_flag
11901: -- gboomina Bug 8586393 - end
11902: FROM pa_proj_elements ppe,
11903: pa_proj_workplan_attr ppwa
11904: WHERE ppwa.project_id = p_src_project_id
11905: AND ppe.attribute15 = ppwa.proj_element_id
11906: AND ppe.project_id = p_dest_project_id
11907: AND ppe.object_type='PA_STRUCTURES';

Line 12335: INSERT INTO pa_proj_workplan_attr(

12331: WHERE proj_element_id = ppe.proj_element_id
12332: AND structure_type_id = 1 );
12333: END IF;
12334:
12335: INSERT INTO pa_proj_workplan_attr(
12336: PROJ_ELEMENT_ID
12337: ,PROJECT_ID
12338: ,LAST_UPDATE_DATE
12339: ,LAST_UPDATED_BY

Line 12397: pa_proj_workplan_attr ppwa

12393: -- gboomina bug 8586393 - start
12394: ,ppwa.use_task_schedule_flag
12395: -- gboomina bug 8586393 - end
12396: /*FROM pa_proj_elements ppe,
12397: pa_proj_workplan_attr ppwa
12398: WHERE ppe.project_id = p_dest_project_id
12399: and object_type = 'PA_STRUCTURES'
12400: and ppwa.project_id = p_src_project_id
12401: and ppwa.proj_element_id = ppe.attribute15;*//*Commented below query and following criteria by SMUKKA */

Line 12403: pa_proj_workplan_attr ppwa

12399: and object_type = 'PA_STRUCTURES'
12400: and ppwa.project_id = p_src_project_id
12401: and ppwa.proj_element_id = ppe.attribute15;*//*Commented below query and following criteria by SMUKKA */
12402: FROM pa_proj_elements ppe,
12403: pa_proj_workplan_attr ppwa
12404: WHERE ppwa.project_id = p_src_project_id
12405: AND ppe.project_id = p_dest_project_id
12406: AND ppe.object_type ='PA_STRUCTURES'
12407: AND ppe.attribute15 = ppwa.proj_element_id

Line 13639: FROM pa_proj_workplan_attr

13635: /* Bug 2955589. This cursor is no longer used.
13636: CURSOR cur_auto_pub_flag(c_project_id pa_projects_all.project_id%TYPE)
13637: IS
13638: SELECT AUTO_PUB_UPON_CREATION_FLAG
13639: FROM pa_proj_workplan_attr
13640: WHERE project_id = c_project_id;
13641: */
13642: -- This cursor is used to get the structure id given the structure type and project_id
13643: CURSOR get_structure(c_project_id pa_projects_all.project_id%TYPE, c_struc_type pa_structure_types.structure_type_class_code%TYPE) IS

Line 14022: pa_proj_workplan_attr ppwa,

14018: pa_projects_all ppa,
14019: pa_proj_elements ppe,
14020: pa_proj_element_versions ppv,
14021: pa_proj_elem_ver_structure ppvs,
14022: pa_proj_workplan_attr ppwa,
14023: pa_progress_rollup ppr,
14024: pji_xbs_plans_v pxpv
14025: WHERE
14026: ppv.project_id = ppa.project_id

Line 22143: from pa_proj_workplan_attr ppwa,

22139: ppwa.lifecycle_version_id,
22140: -- gboomina Bug 8586393 - start
22141: ppwa.use_task_schedule_flag
22142: -- gboomina Bug 8586393 - end
22143: from pa_proj_workplan_attr ppwa,
22144: pa_proj_elements ppe,
22145: pa_proj_structure_types ppst
22146: where ppwa.project_id = c_project_id
22147: and ppwa.project_id = ppe.project_id