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

Line 1384: from PA_proj_elem_ver_structure

1380:
1381: PROCEDURE lock_version( p_project_id IN NUMBER, p_structure_version_id IN NUMBER) IS
1382: cursor version_info IS
1383: select pev_structure_id, record_version_number,name
1384: from PA_proj_elem_ver_structure
1385: where element_version_id = p_structure_version_id
1386: and project_id = p_project_id;
1387:
1388: l_api_name CONSTANT VARCHAR2(30) := 'lock_version';

Line 1390: l_record_version_number pa_proj_elem_ver_structure.record_version_number%type;

1386: and project_id = p_project_id;
1387:
1388: l_api_name CONSTANT VARCHAR2(30) := 'lock_version';
1389:
1390: l_record_version_number pa_proj_elem_ver_structure.record_version_number%type;
1391: l_name pa_proj_elem_ver_structure.name%type;
1392: x_return_status VARCHAR2(1);
1393: x_msg_data VARCHAR2(2000);
1394: x_msg_count NUMBER;

Line 1391: l_name pa_proj_elem_ver_structure.name%type;

1387:
1388: l_api_name CONSTANT VARCHAR2(30) := 'lock_version';
1389:
1390: l_record_version_number pa_proj_elem_ver_structure.record_version_number%type;
1391: l_name pa_proj_elem_ver_structure.name%type;
1392: x_return_status VARCHAR2(1);
1393: x_msg_data VARCHAR2(2000);
1394: x_msg_count NUMBER;
1395: str version_info%ROWTYPE;

Line 1573: pa_proj_elem_ver_structure evs

1569: CURSOR get_budget_version_id IS
1570: SELECT bv.budget_version_id
1571: FROM pa_budget_versions bv,
1572: pa_proj_element_versions ev,
1573: pa_proj_elem_ver_structure evs
1574: WHERE bv.project_id = p_project_id
1575: AND bv.wp_version_flag = 'Y'
1576: AND bv.project_structure_version_id = evs.element_version_id
1577: AND ev.project_id = p_project_id

Line 1851: p_old_structure_version_id IN PA_PROJ_ELEM_VER_STRUCTURE.ELEMENT_VERSION_ID%TYPE,

1847:
1848: PROCEDURE Copy_Missing_Unplanned_Asgmts
1849: (
1850: p_project_id IN PA_PROJECTS_ALL.PROJECT_ID%TYPE,
1851: p_old_structure_version_id IN PA_PROJ_ELEM_VER_STRUCTURE.ELEMENT_VERSION_ID%TYPE,
1852: p_new_structure_version_id IN PA_PROJ_ELEM_VER_STRUCTURE.ELEMENT_VERSION_ID%TYPE,
1853: p_new_budget_version_id IN PA_BUDGET_VERSIONS.BUDGET_VERSION_ID%TYPE DEFAULT NULL,
1854: x_msg_count OUT NOCOPY NUMBER,
1855: x_msg_data OUT NOCOPY VARCHAR2,

Line 1852: p_new_structure_version_id IN PA_PROJ_ELEM_VER_STRUCTURE.ELEMENT_VERSION_ID%TYPE,

1848: PROCEDURE Copy_Missing_Unplanned_Asgmts
1849: (
1850: p_project_id IN PA_PROJECTS_ALL.PROJECT_ID%TYPE,
1851: p_old_structure_version_id IN PA_PROJ_ELEM_VER_STRUCTURE.ELEMENT_VERSION_ID%TYPE,
1852: p_new_structure_version_id IN PA_PROJ_ELEM_VER_STRUCTURE.ELEMENT_VERSION_ID%TYPE,
1853: p_new_budget_version_id IN PA_BUDGET_VERSIONS.BUDGET_VERSION_ID%TYPE DEFAULT NULL,
1854: x_msg_count OUT NOCOPY NUMBER,
1855: x_msg_data OUT NOCOPY VARCHAR2,
1856: x_return_status OUT NOCOPY VARCHAR2

Line 1878: CURSOR c_get_budget_version_id(structure_version_id PA_PROJ_ELEM_VER_STRUCTURE.ELEMENT_VERSION_ID%TYPE) IS

1874: l_ta_display_flag_tbl SYSTEM.PA_VARCHAR2_1_TBL_TYPE := SYSTEM.PA_VARCHAR2_1_TBL_TYPE();
1875:
1876: k NUMBER;
1877:
1878: CURSOR c_get_budget_version_id(structure_version_id PA_PROJ_ELEM_VER_STRUCTURE.ELEMENT_VERSION_ID%TYPE) IS
1879: SELECT budget_version_id
1880: FROM pa_budget_versions
1881: WHERE project_structure_version_id = structure_version_id
1882: AND wp_version_flag = 'Y';

Line 1884: CURSOR c_get_missing_asgmts(old_structure_version_id PA_PROJ_ELEM_VER_STRUCTURE.ELEMENT_VERSION_ID%TYPE,

1880: FROM pa_budget_versions
1881: WHERE project_structure_version_id = structure_version_id
1882: AND wp_version_flag = 'Y';
1883:
1884: CURSOR c_get_missing_asgmts(old_structure_version_id PA_PROJ_ELEM_VER_STRUCTURE.ELEMENT_VERSION_ID%TYPE,
1885: new_structure_version_id PA_PROJ_ELEM_VER_STRUCTURE.ELEMENT_VERSION_ID%TYPE,
1886: old_budget_version_id PA_BUDGET_VERSIONS.BUDGET_VERSION_ID%TYPE,
1887: new_budget_version_id PA_BUDGET_VERSIONS.BUDGET_VERSION_ID%TYPE) IS
1888: SELECT

Line 1885: new_structure_version_id PA_PROJ_ELEM_VER_STRUCTURE.ELEMENT_VERSION_ID%TYPE,

1881: WHERE project_structure_version_id = structure_version_id
1882: AND wp_version_flag = 'Y';
1883:
1884: CURSOR c_get_missing_asgmts(old_structure_version_id PA_PROJ_ELEM_VER_STRUCTURE.ELEMENT_VERSION_ID%TYPE,
1885: new_structure_version_id PA_PROJ_ELEM_VER_STRUCTURE.ELEMENT_VERSION_ID%TYPE,
1886: old_budget_version_id PA_BUDGET_VERSIONS.BUDGET_VERSION_ID%TYPE,
1887: new_budget_version_id PA_BUDGET_VERSIONS.BUDGET_VERSION_ID%TYPE) IS
1888: SELECT
1889: pev.element_version_id,