APPS.PA_PROJECT_CORE1 dependencies on PA_PROJECT_SUBTEAMS

Line 1801: x_err_stage := 'Calling PA_PROJECT_SUBTEAMS_PUB.Create_Subteam API ...';

1797: end if;
1798:
1799: -- anlee
1800: -- Copying Subteams
1801: x_err_stage := 'Calling PA_PROJECT_SUBTEAMS_PUB.Create_Subteam API ...';
1802:
1803: DECLARE
1804: CURSOR get_subteams_csr(c_project_id NUMBER) IS
1805: SELECT name, description

Line 1806: FROM pa_project_subteams

1802:
1803: DECLARE
1804: CURSOR get_subteams_csr(c_project_id NUMBER) IS
1805: SELECT name, description
1806: FROM pa_project_subteams
1807: WHERE object_type = 'PA_PROJECTS'
1808: AND object_id = c_project_id;
1809:
1810: l_name PA_PROJECT_SUBTEAMS.name%TYPE;

Line 1810: l_name PA_PROJECT_SUBTEAMS.name%TYPE;

1806: FROM pa_project_subteams
1807: WHERE object_type = 'PA_PROJECTS'
1808: AND object_id = c_project_id;
1809:
1810: l_name PA_PROJECT_SUBTEAMS.name%TYPE;
1811: l_description PA_PROJECT_SUBTEAMS.description%TYPE;
1812: l_new_subteam_id NUMBER;
1813: l_subteam_row_id ROWID;
1814: l_return_status VARCHAR2(1);

Line 1811: l_description PA_PROJECT_SUBTEAMS.description%TYPE;

1807: WHERE object_type = 'PA_PROJECTS'
1808: AND object_id = c_project_id;
1809:
1810: l_name PA_PROJECT_SUBTEAMS.name%TYPE;
1811: l_description PA_PROJECT_SUBTEAMS.description%TYPE;
1812: l_new_subteam_id NUMBER;
1813: l_subteam_row_id ROWID;
1814: l_return_status VARCHAR2(1);
1815: l_msg_count NUMBER;

Line 1824: PA_PROJECT_SUBTEAMS_PUB.Create_Subteam(

1820: LOOP
1821: FETCH get_subteams_csr INTO l_name, l_description;
1822: EXIT WHEN get_subteams_csr%NOTFOUND;
1823:
1824: PA_PROJECT_SUBTEAMS_PUB.Create_Subteam(
1825: p_subteam_name => l_name
1826: ,p_object_type => 'PA_PROJECTS'
1827: ,p_object_id => x_new_project_id
1828: ,p_description => l_description

Line 1855: x_err_stage := 'API: '||'PA_PROJECT_SUBTEAMS_PUB.CREATE_SUBTEAM'||

1851: x_err_code := 102;
1852: -- x_err_stage := pa_project_core1.get_message_from_stack( null );
1853: -- IF x_err_stage IS NULL
1854: -- THEN
1855: x_err_stage := 'API: '||'PA_PROJECT_SUBTEAMS_PUB.CREATE_SUBTEAM'||
1856: ' SQL error message: '||SUBSTR( SQLERRM,1,1900);
1857: -- END IF;
1858: rollback to copy_project;
1859: revert_proj_number(x_proj_number_gen_mode,x_new_project_number); -- Added for Bug# 7445534