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_TASKS_MAINT_PUB dependencies on PA_PROJ_ELEMENT_VERSIONS

Line 709: TYPE task_version_id_table_type IS TABLE OF PA_PROJ_ELEMENT_VERSIONS.element_version_id%TYPE INDEX BY BINARY_INTEGER;

705: ,x_msg_count OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
706: ,x_msg_data OUT NOCOPY VARCHAR2 ); --File.Sql.39 bug 4440895
707:
708: --Begin add by rtarway for FP.M development
709: TYPE task_version_id_table_type IS TABLE OF PA_PROJ_ELEMENT_VERSIONS.element_version_id%TYPE INDEX BY BINARY_INTEGER;
710:
711: PROCEDURE SET_FINANCIAL_FLAG_WRAPPER
712: (
713: p_api_version IN NUMBER := 1.0

Line 735: PROJECT_ID pa_proj_element_versions.project_id%type

731: --TYPE fin_tasks_temp_record_type IS RECORD ( PA_PREVIEW_FIN_TASKS_TEMP_ROW PA_PREVIEW_FIN_TASKS_TEMP%ROWTYPE );
732:
733: TYPE fin_tasks_temp_record_type IS RECORD
734: (
735: PROJECT_ID pa_proj_element_versions.project_id%type
736: , ELEMENT_VERSION_ID pa_proj_element_versions.element_version_id%type
737: , PARENT_STRUCTURE_VERSION_ID pa_proj_element_versions.parent_structure_version_id%type
738: , PARENT_ELEMENT_VERSION_ID pa_object_relationships.object_id_from1%type
739: , CHILD_ELEMENT_FLAG VARCHAR2(1)

Line 736: , ELEMENT_VERSION_ID pa_proj_element_versions.element_version_id%type

732:
733: TYPE fin_tasks_temp_record_type IS RECORD
734: (
735: PROJECT_ID pa_proj_element_versions.project_id%type
736: , ELEMENT_VERSION_ID pa_proj_element_versions.element_version_id%type
737: , PARENT_STRUCTURE_VERSION_ID pa_proj_element_versions.parent_structure_version_id%type
738: , PARENT_ELEMENT_VERSION_ID pa_object_relationships.object_id_from1%type
739: , CHILD_ELEMENT_FLAG VARCHAR2(1)
740: , TASK_NAME pa_proj_elements.name%type

Line 737: , PARENT_STRUCTURE_VERSION_ID pa_proj_element_versions.parent_structure_version_id%type

733: TYPE fin_tasks_temp_record_type IS RECORD
734: (
735: PROJECT_ID pa_proj_element_versions.project_id%type
736: , ELEMENT_VERSION_ID pa_proj_element_versions.element_version_id%type
737: , PARENT_STRUCTURE_VERSION_ID pa_proj_element_versions.parent_structure_version_id%type
738: , PARENT_ELEMENT_VERSION_ID pa_object_relationships.object_id_from1%type
739: , CHILD_ELEMENT_FLAG VARCHAR2(1)
740: , TASK_NAME pa_proj_elements.name%type
741: , TASK_NUMBER pa_proj_elements.element_number%type

Line 742: , OBJECT_TYPE pa_proj_element_versions.object_type%type

738: , PARENT_ELEMENT_VERSION_ID pa_object_relationships.object_id_from1%type
739: , CHILD_ELEMENT_FLAG VARCHAR2(1)
740: , TASK_NAME pa_proj_elements.name%type
741: , TASK_NUMBER pa_proj_elements.element_number%type
742: , OBJECT_TYPE pa_proj_element_versions.object_type%type
743: , DISPLAY_SEQUENCE pa_proj_element_versions.display_sequence%type
744: , WBS_NUMBER pa_proj_element_versions.wbs_number%type
745: , PROJ_ELEMENT_ID pa_proj_element_versions.proj_element_id%type
746: , FINANCIAL_TASK_FLAG pa_proj_element_versions.financial_task_flag%type

Line 743: , DISPLAY_SEQUENCE pa_proj_element_versions.display_sequence%type

739: , CHILD_ELEMENT_FLAG VARCHAR2(1)
740: , TASK_NAME pa_proj_elements.name%type
741: , TASK_NUMBER pa_proj_elements.element_number%type
742: , OBJECT_TYPE pa_proj_element_versions.object_type%type
743: , DISPLAY_SEQUENCE pa_proj_element_versions.display_sequence%type
744: , WBS_NUMBER pa_proj_element_versions.wbs_number%type
745: , PROJ_ELEMENT_ID pa_proj_element_versions.proj_element_id%type
746: , FINANCIAL_TASK_FLAG pa_proj_element_versions.financial_task_flag%type
747: );

Line 744: , WBS_NUMBER pa_proj_element_versions.wbs_number%type

740: , TASK_NAME pa_proj_elements.name%type
741: , TASK_NUMBER pa_proj_elements.element_number%type
742: , OBJECT_TYPE pa_proj_element_versions.object_type%type
743: , DISPLAY_SEQUENCE pa_proj_element_versions.display_sequence%type
744: , WBS_NUMBER pa_proj_element_versions.wbs_number%type
745: , PROJ_ELEMENT_ID pa_proj_element_versions.proj_element_id%type
746: , FINANCIAL_TASK_FLAG pa_proj_element_versions.financial_task_flag%type
747: );
748:

Line 745: , PROJ_ELEMENT_ID pa_proj_element_versions.proj_element_id%type

741: , TASK_NUMBER pa_proj_elements.element_number%type
742: , OBJECT_TYPE pa_proj_element_versions.object_type%type
743: , DISPLAY_SEQUENCE pa_proj_element_versions.display_sequence%type
744: , WBS_NUMBER pa_proj_element_versions.wbs_number%type
745: , PROJ_ELEMENT_ID pa_proj_element_versions.proj_element_id%type
746: , FINANCIAL_TASK_FLAG pa_proj_element_versions.financial_task_flag%type
747: );
748:
749: TYPE project_id_table_type IS TABLE OF pa_proj_element_versions.project_id%type INDEX BY BINARY_INTEGER;

Line 746: , FINANCIAL_TASK_FLAG pa_proj_element_versions.financial_task_flag%type

742: , OBJECT_TYPE pa_proj_element_versions.object_type%type
743: , DISPLAY_SEQUENCE pa_proj_element_versions.display_sequence%type
744: , WBS_NUMBER pa_proj_element_versions.wbs_number%type
745: , PROJ_ELEMENT_ID pa_proj_element_versions.proj_element_id%type
746: , FINANCIAL_TASK_FLAG pa_proj_element_versions.financial_task_flag%type
747: );
748:
749: TYPE project_id_table_type IS TABLE OF pa_proj_element_versions.project_id%type INDEX BY BINARY_INTEGER;
750: TYPE ELEMENT_VERSION_ID_table_type IS TABLE OF pa_proj_element_versions.element_version_id%type INDEX BY BINARY_INTEGER;

Line 749: TYPE project_id_table_type IS TABLE OF pa_proj_element_versions.project_id%type INDEX BY BINARY_INTEGER;

745: , PROJ_ELEMENT_ID pa_proj_element_versions.proj_element_id%type
746: , FINANCIAL_TASK_FLAG pa_proj_element_versions.financial_task_flag%type
747: );
748:
749: TYPE project_id_table_type IS TABLE OF pa_proj_element_versions.project_id%type INDEX BY BINARY_INTEGER;
750: TYPE ELEMENT_VERSION_ID_table_type IS TABLE OF pa_proj_element_versions.element_version_id%type INDEX BY BINARY_INTEGER;
751: TYPE PRNT_STRUCT_VER_ID_table_type IS TABLE OF pa_proj_element_versions.parent_structure_version_id%type INDEX BY BINARY_INTEGER;
752: TYPE PRNT_ELEM_VER_ID_table_type IS TABLE OF pa_object_relationships.object_id_from1%type INDEX BY BINARY_INTEGER;
753: TYPE CHILD_ELEMENT_FLAG_table_type IS TABLE OF VARCHAR2(1) INDEX BY BINARY_INTEGER;

Line 750: TYPE ELEMENT_VERSION_ID_table_type IS TABLE OF pa_proj_element_versions.element_version_id%type INDEX BY BINARY_INTEGER;

746: , FINANCIAL_TASK_FLAG pa_proj_element_versions.financial_task_flag%type
747: );
748:
749: TYPE project_id_table_type IS TABLE OF pa_proj_element_versions.project_id%type INDEX BY BINARY_INTEGER;
750: TYPE ELEMENT_VERSION_ID_table_type IS TABLE OF pa_proj_element_versions.element_version_id%type INDEX BY BINARY_INTEGER;
751: TYPE PRNT_STRUCT_VER_ID_table_type IS TABLE OF pa_proj_element_versions.parent_structure_version_id%type INDEX BY BINARY_INTEGER;
752: TYPE PRNT_ELEM_VER_ID_table_type IS TABLE OF pa_object_relationships.object_id_from1%type INDEX BY BINARY_INTEGER;
753: TYPE CHILD_ELEMENT_FLAG_table_type IS TABLE OF VARCHAR2(1) INDEX BY BINARY_INTEGER;
754: TYPE TASK_NAME_table_type IS TABLE OF pa_proj_elements.name%type INDEX BY BINARY_INTEGER;

Line 751: TYPE PRNT_STRUCT_VER_ID_table_type IS TABLE OF pa_proj_element_versions.parent_structure_version_id%type INDEX BY BINARY_INTEGER;

747: );
748:
749: TYPE project_id_table_type IS TABLE OF pa_proj_element_versions.project_id%type INDEX BY BINARY_INTEGER;
750: TYPE ELEMENT_VERSION_ID_table_type IS TABLE OF pa_proj_element_versions.element_version_id%type INDEX BY BINARY_INTEGER;
751: TYPE PRNT_STRUCT_VER_ID_table_type IS TABLE OF pa_proj_element_versions.parent_structure_version_id%type INDEX BY BINARY_INTEGER;
752: TYPE PRNT_ELEM_VER_ID_table_type IS TABLE OF pa_object_relationships.object_id_from1%type INDEX BY BINARY_INTEGER;
753: TYPE CHILD_ELEMENT_FLAG_table_type IS TABLE OF VARCHAR2(1) INDEX BY BINARY_INTEGER;
754: TYPE TASK_NAME_table_type IS TABLE OF pa_proj_elements.name%type INDEX BY BINARY_INTEGER;
755: TYPE TASK_NUMBER_table_type IS TABLE OF pa_proj_elements.element_number%type INDEX BY BINARY_INTEGER;

Line 756: TYPE OBJECT_TYPE_table_type IS TABLE OF pa_proj_element_versions.object_type%type INDEX BY BINARY_INTEGER;

752: TYPE PRNT_ELEM_VER_ID_table_type IS TABLE OF pa_object_relationships.object_id_from1%type INDEX BY BINARY_INTEGER;
753: TYPE CHILD_ELEMENT_FLAG_table_type IS TABLE OF VARCHAR2(1) INDEX BY BINARY_INTEGER;
754: TYPE TASK_NAME_table_type IS TABLE OF pa_proj_elements.name%type INDEX BY BINARY_INTEGER;
755: TYPE TASK_NUMBER_table_type IS TABLE OF pa_proj_elements.element_number%type INDEX BY BINARY_INTEGER;
756: TYPE OBJECT_TYPE_table_type IS TABLE OF pa_proj_element_versions.object_type%type INDEX BY BINARY_INTEGER;
757: TYPE DISPLAY_SEQUENCE_table_type IS TABLE OF pa_proj_element_versions.display_sequence%type INDEX BY BINARY_INTEGER;
758: TYPE WBS_NUMBER_table_type IS TABLE OF pa_proj_element_versions.wbs_number%type INDEX BY BINARY_INTEGER;
759: TYPE PROJ_ELEMENT_ID_table_type IS TABLE OF pa_proj_element_versions.proj_element_id%type INDEX BY BINARY_INTEGER;
760: TYPE FINANCIAL_TASK_FLAG_table_type IS TABLE OF pa_proj_element_versions.financial_task_flag%type INDEX BY BINARY_INTEGER;

Line 757: TYPE DISPLAY_SEQUENCE_table_type IS TABLE OF pa_proj_element_versions.display_sequence%type INDEX BY BINARY_INTEGER;

753: TYPE CHILD_ELEMENT_FLAG_table_type IS TABLE OF VARCHAR2(1) INDEX BY BINARY_INTEGER;
754: TYPE TASK_NAME_table_type IS TABLE OF pa_proj_elements.name%type INDEX BY BINARY_INTEGER;
755: TYPE TASK_NUMBER_table_type IS TABLE OF pa_proj_elements.element_number%type INDEX BY BINARY_INTEGER;
756: TYPE OBJECT_TYPE_table_type IS TABLE OF pa_proj_element_versions.object_type%type INDEX BY BINARY_INTEGER;
757: TYPE DISPLAY_SEQUENCE_table_type IS TABLE OF pa_proj_element_versions.display_sequence%type INDEX BY BINARY_INTEGER;
758: TYPE WBS_NUMBER_table_type IS TABLE OF pa_proj_element_versions.wbs_number%type INDEX BY BINARY_INTEGER;
759: TYPE PROJ_ELEMENT_ID_table_type IS TABLE OF pa_proj_element_versions.proj_element_id%type INDEX BY BINARY_INTEGER;
760: TYPE FINANCIAL_TASK_FLAG_table_type IS TABLE OF pa_proj_element_versions.financial_task_flag%type INDEX BY BINARY_INTEGER;
761:

Line 758: TYPE WBS_NUMBER_table_type IS TABLE OF pa_proj_element_versions.wbs_number%type INDEX BY BINARY_INTEGER;

754: TYPE TASK_NAME_table_type IS TABLE OF pa_proj_elements.name%type INDEX BY BINARY_INTEGER;
755: TYPE TASK_NUMBER_table_type IS TABLE OF pa_proj_elements.element_number%type INDEX BY BINARY_INTEGER;
756: TYPE OBJECT_TYPE_table_type IS TABLE OF pa_proj_element_versions.object_type%type INDEX BY BINARY_INTEGER;
757: TYPE DISPLAY_SEQUENCE_table_type IS TABLE OF pa_proj_element_versions.display_sequence%type INDEX BY BINARY_INTEGER;
758: TYPE WBS_NUMBER_table_type IS TABLE OF pa_proj_element_versions.wbs_number%type INDEX BY BINARY_INTEGER;
759: TYPE PROJ_ELEMENT_ID_table_type IS TABLE OF pa_proj_element_versions.proj_element_id%type INDEX BY BINARY_INTEGER;
760: TYPE FINANCIAL_TASK_FLAG_table_type IS TABLE OF pa_proj_element_versions.financial_task_flag%type INDEX BY BINARY_INTEGER;
761:
762: --TYPE fin_tasks_temp_table_type IS TABLE OF fin_tasks_temp_record_type INDEX BY BINARY_INTEGER;

Line 759: TYPE PROJ_ELEMENT_ID_table_type IS TABLE OF pa_proj_element_versions.proj_element_id%type INDEX BY BINARY_INTEGER;

755: TYPE TASK_NUMBER_table_type IS TABLE OF pa_proj_elements.element_number%type INDEX BY BINARY_INTEGER;
756: TYPE OBJECT_TYPE_table_type IS TABLE OF pa_proj_element_versions.object_type%type INDEX BY BINARY_INTEGER;
757: TYPE DISPLAY_SEQUENCE_table_type IS TABLE OF pa_proj_element_versions.display_sequence%type INDEX BY BINARY_INTEGER;
758: TYPE WBS_NUMBER_table_type IS TABLE OF pa_proj_element_versions.wbs_number%type INDEX BY BINARY_INTEGER;
759: TYPE PROJ_ELEMENT_ID_table_type IS TABLE OF pa_proj_element_versions.proj_element_id%type INDEX BY BINARY_INTEGER;
760: TYPE FINANCIAL_TASK_FLAG_table_type IS TABLE OF pa_proj_element_versions.financial_task_flag%type INDEX BY BINARY_INTEGER;
761:
762: --TYPE fin_tasks_temp_table_type IS TABLE OF fin_tasks_temp_record_type INDEX BY BINARY_INTEGER;
763:

Line 760: TYPE FINANCIAL_TASK_FLAG_table_type IS TABLE OF pa_proj_element_versions.financial_task_flag%type INDEX BY BINARY_INTEGER;

756: TYPE OBJECT_TYPE_table_type IS TABLE OF pa_proj_element_versions.object_type%type INDEX BY BINARY_INTEGER;
757: TYPE DISPLAY_SEQUENCE_table_type IS TABLE OF pa_proj_element_versions.display_sequence%type INDEX BY BINARY_INTEGER;
758: TYPE WBS_NUMBER_table_type IS TABLE OF pa_proj_element_versions.wbs_number%type INDEX BY BINARY_INTEGER;
759: TYPE PROJ_ELEMENT_ID_table_type IS TABLE OF pa_proj_element_versions.proj_element_id%type INDEX BY BINARY_INTEGER;
760: TYPE FINANCIAL_TASK_FLAG_table_type IS TABLE OF pa_proj_element_versions.financial_task_flag%type INDEX BY BINARY_INTEGER;
761:
762: --TYPE fin_tasks_temp_table_type IS TABLE OF fin_tasks_temp_record_type INDEX BY BINARY_INTEGER;
763:
764: PROCEDURE POPULATE_TEMP_TABLE