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 1597: from PA_proj_elem_ver_structure

1593:
1594: PROCEDURE lock_version( p_project_id IN NUMBER, p_structure_version_id IN NUMBER) IS
1595: cursor version_info IS
1596: select pev_structure_id, record_version_number,name
1597: from PA_proj_elem_ver_structure
1598: where element_version_id = p_structure_version_id
1599: and project_id = p_project_id;
1600:
1601: l_api_name CONSTANT VARCHAR2(30) := 'lock_version';

Line 1603: l_record_version_number pa_proj_elem_ver_structure.record_version_number%type;

1599: and project_id = p_project_id;
1600:
1601: l_api_name CONSTANT VARCHAR2(30) := 'lock_version';
1602:
1603: l_record_version_number pa_proj_elem_ver_structure.record_version_number%type;
1604: l_name pa_proj_elem_ver_structure.name%type;
1605: x_return_status VARCHAR2(1);
1606: x_msg_data VARCHAR2(2000);
1607: x_msg_count NUMBER;

Line 1604: l_name pa_proj_elem_ver_structure.name%type;

1600:
1601: l_api_name CONSTANT VARCHAR2(30) := 'lock_version';
1602:
1603: l_record_version_number pa_proj_elem_ver_structure.record_version_number%type;
1604: l_name pa_proj_elem_ver_structure.name%type;
1605: x_return_status VARCHAR2(1);
1606: x_msg_data VARCHAR2(2000);
1607: x_msg_count NUMBER;
1608: str version_info%ROWTYPE;

Line 1797: pa_proj_elem_ver_structure evs

1793: CURSOR get_budget_version_id IS
1794: SELECT bv.budget_version_id
1795: FROM pa_budget_versions bv,
1796: pa_proj_element_versions ev,
1797: pa_proj_elem_ver_structure evs
1798: WHERE bv.project_id = p_project_id
1799: AND bv.wp_version_flag = 'Y'
1800: AND bv.project_structure_version_id = evs.element_version_id
1801: AND ev.project_id = p_project_id

Line 2086: p_old_structure_version_id IN PA_PROJ_ELEM_VER_STRUCTURE.ELEMENT_VERSION_ID%TYPE,

2082:
2083: PROCEDURE Copy_Missing_Unplanned_Asgmts
2084: (
2085: p_project_id IN PA_PROJECTS_ALL.PROJECT_ID%TYPE,
2086: p_old_structure_version_id IN PA_PROJ_ELEM_VER_STRUCTURE.ELEMENT_VERSION_ID%TYPE,
2087: p_new_structure_version_id IN PA_PROJ_ELEM_VER_STRUCTURE.ELEMENT_VERSION_ID%TYPE,
2088: p_new_budget_version_id IN PA_BUDGET_VERSIONS.BUDGET_VERSION_ID%TYPE DEFAULT NULL,
2089: x_msg_count OUT NOCOPY NUMBER,
2090: x_msg_data OUT NOCOPY VARCHAR2,

Line 2087: p_new_structure_version_id IN PA_PROJ_ELEM_VER_STRUCTURE.ELEMENT_VERSION_ID%TYPE,

2083: PROCEDURE Copy_Missing_Unplanned_Asgmts
2084: (
2085: p_project_id IN PA_PROJECTS_ALL.PROJECT_ID%TYPE,
2086: p_old_structure_version_id IN PA_PROJ_ELEM_VER_STRUCTURE.ELEMENT_VERSION_ID%TYPE,
2087: p_new_structure_version_id IN PA_PROJ_ELEM_VER_STRUCTURE.ELEMENT_VERSION_ID%TYPE,
2088: p_new_budget_version_id IN PA_BUDGET_VERSIONS.BUDGET_VERSION_ID%TYPE DEFAULT NULL,
2089: x_msg_count OUT NOCOPY NUMBER,
2090: x_msg_data OUT NOCOPY VARCHAR2,
2091: x_return_status OUT NOCOPY VARCHAR2

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

2110: l_cbs_element_id_tbl SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE(); -- Added for 16200605
2111:
2112: k NUMBER;
2113:
2114: CURSOR c_get_budget_version_id(structure_version_id PA_PROJ_ELEM_VER_STRUCTURE.ELEMENT_VERSION_ID%TYPE) IS
2115: SELECT budget_version_id
2116: FROM pa_budget_versions
2117: WHERE project_structure_version_id = structure_version_id
2118: AND wp_version_flag = 'Y';

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

2116: FROM pa_budget_versions
2117: WHERE project_structure_version_id = structure_version_id
2118: AND wp_version_flag = 'Y';
2119:
2120: CURSOR c_get_missing_asgmts(old_structure_version_id PA_PROJ_ELEM_VER_STRUCTURE.ELEMENT_VERSION_ID%TYPE,
2121: new_structure_version_id PA_PROJ_ELEM_VER_STRUCTURE.ELEMENT_VERSION_ID%TYPE,
2122: old_budget_version_id PA_BUDGET_VERSIONS.BUDGET_VERSION_ID%TYPE,
2123: new_budget_version_id PA_BUDGET_VERSIONS.BUDGET_VERSION_ID%TYPE) IS
2124: SELECT

Line 2121: new_structure_version_id PA_PROJ_ELEM_VER_STRUCTURE.ELEMENT_VERSION_ID%TYPE,

2117: WHERE project_structure_version_id = structure_version_id
2118: AND wp_version_flag = 'Y';
2119:
2120: CURSOR c_get_missing_asgmts(old_structure_version_id PA_PROJ_ELEM_VER_STRUCTURE.ELEMENT_VERSION_ID%TYPE,
2121: new_structure_version_id PA_PROJ_ELEM_VER_STRUCTURE.ELEMENT_VERSION_ID%TYPE,
2122: old_budget_version_id PA_BUDGET_VERSIONS.BUDGET_VERSION_ID%TYPE,
2123: new_budget_version_id PA_BUDGET_VERSIONS.BUDGET_VERSION_ID%TYPE) IS
2124: SELECT
2125: pev.element_version_id,