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

Line 285: FROM pa_proj_workplan_attr

281: /*Bug No 3489940 */
282: /* Modified get_flag cursor to check for workplan structure */
283: /*CURSOR get_flag IS
284: SELECT wp_enable_version_flag
285: FROM pa_proj_workplan_attr
286: WHERE project_id = p_project_id;*/
287: CURSOR get_flag IS
288: SELECT ppwa.wp_enable_version_flag
289: FROM pa_proj_workplan_attr ppwa,

Line 289: FROM pa_proj_workplan_attr ppwa,

285: FROM pa_proj_workplan_attr
286: WHERE project_id = p_project_id;*/
287: CURSOR get_flag IS
288: SELECT ppwa.wp_enable_version_flag
289: FROM pa_proj_workplan_attr ppwa,
290: pa_proj_elements ppe,
291: pa_proj_structure_types ppst,
292: pa_structure_types pst
293: WHERE ppwa.project_id = p_project_id

Line 329: from pa_proj_workplan_attr ppwa,

325: l_sync_enabled VARCHAR2(1);
326: --Jul 23rd Only Workplan
327: CURSOR get_sync_flag IS
328: select ppwa.AUTO_SYNC_TXN_DATE_FLAG
329: from pa_proj_workplan_attr ppwa,
330: pa_proj_elements ppe,
331: pa_proj_structure_types ppst,
332: pa_structure_types pst
333: WHERE ppwa.proj_element_id = p_proj_element_id

Line 340: from pa_proj_workplan_attr

336: AND ppe.proj_element_id = ppst.proj_element_id
337: AND ppst.structure_type_id = pst.structure_type_id
338: AND pst.structure_type_class_code = 'WORKPLAN';
339: /* select AUTO_SYNC_TXN_DATE_FLAG
340: from pa_proj_workplan_attr
341: Where proj_element_id = p_proj_element_id;*/
342: BEGIN
343: open get_sync_flag;
344: FETCH get_sync_flag into l_sync_enabled;

Line 366: from pa_proj_workplan_attr ppwa,

362: l_sync_days NUMBER;
363: --Jul 23rd Only Workplan
364: CURSOR get_sync_days IS
365: select ppwa.TXN_DATE_SYNC_BUF_DAYS
366: from pa_proj_workplan_attr ppwa,
367: pa_proj_elements ppe,
368: pa_proj_structure_types ppst,
369: pa_structure_types pst
370: WHERE ppwa.proj_element_id = p_proj_element_id

Line 377: from pa_proj_workplan_attr

373: AND ppe.proj_element_id = ppst.proj_element_id
374: AND ppst.structure_type_id = pst.structure_type_id
375: AND pst.structure_type_class_code = 'WORKPLAN';
376: /* select TXN_DATE_SYNC_BUF_DAYS
377: from pa_proj_workplan_attr
378: Where proj_element_id = p_proj_element_id; */
379: BEGIN
380: OPEN get_sync_days;
381: FETCH get_sync_days into l_sync_days;

Line 409: FROM pa_proj_workplan_attr

405: cur_lifecycle_version get_lifecycle_version%ROWTYPE;
406:
407: CURSOR c1(c_lifecycle_version_id IN NUMBER) IS
408: SELECT project_id
409: FROM pa_proj_workplan_attr
410: WHERE lifecycle_version_id = c_lifecycle_version_id;
411:
412: l_delete_lifecycle_error EXCEPTION;
413: l_msg_index_out NUMBER;

Line 548: from pa_proj_workplan_attr ppwa,

544: --Jul 23rd Only Workplan
545: CURSOR cur_wrkpln_attrs
546: IS
547: select ppwa.*
548: from pa_proj_workplan_attr ppwa,
549: pa_proj_elements ppe,
550: pa_proj_structure_types ppst,
551: pa_structure_types pst
552: WHERE ppwa.proj_element_id = p_proj_element_id

Line 559: FROM PA_PROJ_WORKPLAN_ATTR

555: AND ppe.proj_element_id = ppst.proj_element_id
556: AND ppst.structure_type_id = pst.structure_type_id
557: AND pst.structure_type_class_code = 'WORKPLAN';
558: /*SELECT *
559: FROM PA_PROJ_WORKPLAN_ATTR
560: WHERE proj_element_id = p_proj_element_id; */
561:
562: l_return_status VARCHAR2(1);
563: l_error_msg_code VARCHAR2(250);

Line 618: /* UPDATE PA_PROJ_WORKPLAN_ATTR

614:
615: END IF;
616: CLOSE cur_wrkpln_attrs;
617:
618: /* UPDATE PA_PROJ_WORKPLAN_ATTR
619: SET current_phase_version_id = p_lifecycle_phase_id
620: WHERE proj_element_id = p_proj_element_id;
621: */
622:

Line 650: from pa_proj_workplan_attr ppwa,

646: IS
647: --Jul 23rd Only Workplan
648: CURSOR get_flag IS
649: select ppwa.WP_APPROVAL_REQD_FLAG
650: from pa_proj_workplan_attr ppwa,
651: pa_proj_elements ppe,
652: pa_proj_structure_types ppst,
653: pa_structure_types pst
654: WHERE ppwa.project_id = p_project_id

Line 661: FROM pa_proj_workplan_attr

657: AND ppe.proj_element_id = ppst.proj_element_id
658: AND ppst.structure_type_id = pst.structure_type_id
659: AND pst.structure_type_class_code = 'WORKPLAN';
660: /* SELECT WP_APPROVAL_REQD_FLAG
661: FROM pa_proj_workplan_attr
662: WHERE project_id = p_project_id;*/
663:
664: l_flag VARCHAR2(1);
665: BEGIN

Line 681: from pa_proj_workplan_attr ppwa,

677: IS
678: --Jul 23rd Only Workplan
679: CURSOR get_flag IS
680: select ppwa.WP_AUTO_PUBLISH_FLAG
681: from pa_proj_workplan_attr ppwa,
682: pa_proj_elements ppe,
683: pa_proj_structure_types ppst,
684: pa_structure_types pst
685: WHERE ppwa.project_id = p_project_id

Line 692: FROM pa_proj_workplan_attr

688: AND ppe.proj_element_id = ppst.proj_element_id
689: AND ppst.structure_type_id = pst.structure_type_id
690: AND pst.structure_type_class_code = 'WORKPLAN';
691: /* SELECT WP_AUTO_PUBLISH_FLAG
692: FROM pa_proj_workplan_attr
693: WHERE project_id = p_project_id;*/
694:
695: l_flag VARCHAR2(1);
696: BEGIN

Line 712: from pa_proj_workplan_attr ppwa,

708: IS
709: --Jul 23rd Only Workplan
710: CURSOR get_flag IS
711: select ppwa.AUTO_PUB_UPON_CREATION_FLAG
712: from pa_proj_workplan_attr ppwa,
713: pa_proj_elements ppe,
714: pa_proj_structure_types ppst,
715: pa_structure_types pst
716: WHERE ppwa.project_id = p_template_id

Line 723: FROM pa_proj_workplan_attr

719: AND ppe.proj_element_id = ppst.proj_element_id
720: AND ppst.structure_type_id = pst.structure_type_id
721: AND pst.structure_type_class_code = 'WORKPLAN';
722: /* SELECT AUTO_PUB_UPON_CREATION_FLAG
723: FROM pa_proj_workplan_attr
724: WHERE project_id = p_template_id;*/
725:
726: l_flag VARCHAR2(1);
727: BEGIN