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.

[Home] [Help]

APPS.PA_RELATIONSHIP_PVT dependencies on PA_PROJ_ELEMENTS

Line 124: pa_proj_elements pe,

120: CURSOR Get_Latest_Pub_Ver(c_struc_type VARCHAR2, c_project_id NUMBER) IS
121: select pevs.element_version_id
122: from pa_proj_structure_types s,
123: pa_structure_types t,
124: pa_proj_elements pe,
125: pa_proj_elem_ver_structure pevs
126: where pe.object_type = 'PA_STRUCTURES'
127: and pe.project_id = c_project_id
128: and pe.proj_element_id = s.proj_element_id

Line 3074: /* Creating linking task in the pa_proj_elements table*/

3070: pa_debug.debug('PA_TASK_PUB1.CREATE_TASK Src Structure Elem Ver Id => '||p_src_struc_elem_ver_id);
3071: pa_debug.debug('Before PA_TASK_PUB1.CREATE_TASK Linking Task Name Number => '||p_lnk_task_name_number);
3072: END IF;
3073: --
3074: /* Creating linking task in the pa_proj_elements table*/
3075: PA_TASK_PUB1.CREATE_TASK
3076: ( p_validate_only => FND_API.G_FALSE
3077: ,p_object_type => 'PA_TASKS'
3078: ,p_project_id => p_src_proj_id

Line 3110: UPDATE PA_PROJ_ELEMENTS

3106: END IF;
3107: --
3108: --Added the following code
3109: -- Modified from substr(x_lnk_task_elem_id,-1,1) to x_lnk_task_elem_id for bug #4480013
3110: UPDATE PA_PROJ_ELEMENTS
3111: SET ELEMENT_NUMBER = substr(p_lnk_task_name_number,0,25)||x_lnk_task_elem_id
3112: WHERE PROJ_ELEMENT_ID = x_lnk_task_elem_id;
3113: IF SQL%NOTFOUND THEN
3114: x_return_status:=FND_API.G_RET_STS_ERROR;

Line 3463: -- 03-DEC-2008 rkartha Bug#7427161: Modified the declaration of l_task_name with PA_PROJ_ELEMENTS.NAME%TYPE

3459: -- -Created this procedure for subproject association
3460: --
3461: -- FPM bug 3450684
3462: --
3463: -- 03-DEC-2008 rkartha Bug#7427161: Modified the declaration of l_task_name with PA_PROJ_ELEMENTS.NAME%TYPE
3464: -- so as to avoid the numeric or value error.
3465: --
3466: Procedure Create_Subproject_Association(p_api_version IN NUMBER :=1.0,
3467: p_init_msg_list IN VARCHAR2 :=FND_API.G_TRUE,

Line 3487: l_src_struc_elem_id pa_proj_elements.proj_element_id%type;

3483: IS
3484: l_src_proj_sharing_code pa_projects_all.structure_sharing_code%type;
3485: l_dest_proj_sharing_code pa_projects_all.structure_sharing_code%type;
3486: --
3487: l_src_struc_elem_id pa_proj_elements.proj_element_id%type;
3488: l_src_struc_elem_ver_id pa_proj_element_versions.element_version_id%type;
3489: l_src_task_elem_id pa_proj_elements.proj_element_id%type;
3490: l_src_task_financial_flag pa_proj_element_versions.financial_task_flag%type;
3491: --

Line 3489: l_src_task_elem_id pa_proj_elements.proj_element_id%type;

3485: l_dest_proj_sharing_code pa_projects_all.structure_sharing_code%type;
3486: --
3487: l_src_struc_elem_id pa_proj_elements.proj_element_id%type;
3488: l_src_struc_elem_ver_id pa_proj_element_versions.element_version_id%type;
3489: l_src_task_elem_id pa_proj_elements.proj_element_id%type;
3490: l_src_task_financial_flag pa_proj_element_versions.financial_task_flag%type;
3491: --
3492: l_dest_fin_str_ver_id pa_proj_element_versions.element_version_id%type:=0;
3493: l_dest_wp_str_ver_id pa_proj_element_versions.element_version_id%type:=0;

Line 3494: l_dest_wp_struct_element_id pa_proj_elements.proj_element_id%type:=0;

3490: l_src_task_financial_flag pa_proj_element_versions.financial_task_flag%type;
3491: --
3492: l_dest_fin_str_ver_id pa_proj_element_versions.element_version_id%type:=0;
3493: l_dest_wp_str_ver_id pa_proj_element_versions.element_version_id%type:=0;
3494: l_dest_wp_struct_element_id pa_proj_elements.proj_element_id%type:=0;
3495: l_dest_fin_struct_element_id pa_proj_elements.proj_element_id%type:=0;
3496: --
3497: l_parent_strucutre_version_id pa_proj_element_versions.element_version_id%type;
3498: --

Line 3495: l_dest_fin_struct_element_id pa_proj_elements.proj_element_id%type:=0;

3491: --
3492: l_dest_fin_str_ver_id pa_proj_element_versions.element_version_id%type:=0;
3493: l_dest_wp_str_ver_id pa_proj_element_versions.element_version_id%type:=0;
3494: l_dest_wp_struct_element_id pa_proj_elements.proj_element_id%type:=0;
3495: l_dest_fin_struct_element_id pa_proj_elements.proj_element_id%type:=0;
3496: --
3497: l_parent_strucutre_version_id pa_proj_element_versions.element_version_id%type;
3498: --
3499: l_src_str_fin_enable_fl CHAR(1):='N';

Line 3551: from pa_proj_elements ppe, pa_proj_element_versions ppev

3547: where ppa.project_id = c_project_id;
3548:
3549: cursor cur_task_name (c_task_ver_id NUMBER) is
3550: select ppe.name
3551: from pa_proj_elements ppe, pa_proj_element_versions ppev
3552: where ppe.project_id = ppev.project_id
3553: and ppe.proj_element_id = ppev.proj_element_id
3554: and ppev.element_version_id = c_task_ver_id;
3555:

Line 3560: l_task_name PA_PROJ_ELEMENTS.NAME%TYPE := NULL; /* Bug#7427161 */

3556: l_proj_name VARCHAR2(30);
3557: l_prog_name VARCHAR2(30);
3558: -- l_task_name VARCHAR2(30); /* Bug#7427161 */
3559:
3560: l_task_name PA_PROJ_ELEMENTS.NAME%TYPE := NULL; /* Bug#7427161 */
3561:
3562: -- Bug # 4329284.
3563:
3564: BEGIN

Line 4506: pa_proj_elements ppe

4502: , porb.record_version_number lnk_record_ver_number -- Bug # 5072032.
4503: FROM pa_proj_element_versions ppev,
4504: pa_object_relationships pora,
4505: pa_object_relationships porb,
4506: pa_proj_elements ppe
4507: WHERE pora.relationship_type = 'S'
4508: AND ppev.project_id = cp_src_project_id
4509: AND pora.OBJECT_ID_FROM1 = cp_src_Task_ver_id
4510: AND pora.object_type_from = 'PA_TASKS'

Line 4909: FROM pa_proj_elements ppe,

4905: /* Cursor to get the linking task information present on that src structure version id*/
4906: CURSOR get_linking_task_info(cp_src_str_ver_id NUMBER) IS
4907: SELECT ppev.element_version_id lnk_task_ver_id,
4908: ppe.proj_element_id lnk_task_id
4909: FROM pa_proj_elements ppe,
4910: pa_proj_element_versions ppev
4911: WHERE ppe.proj_element_id = ppev.proj_element_id
4912: AND ppe.link_task_flag = 'Y'
4913: AND ppev.parent_structure_version_id = cp_src_str_ver_id