DBA Data[Home] [Help]

APPS.PA_PROJECT_CORE1 dependencies on PA_PROJECT_CTX_SEARCH_PVT

Line 1741: x_err_stage := 'Calling PA_PROJECT_CTX_SEARCH_PVT.Insert_Row API ...';

1737: -- 4199336 end
1738:
1739: -- anlee
1740: -- Added for intermedia search
1741: x_err_stage := 'Calling PA_PROJECT_CTX_SEARCH_PVT.Insert_Row API ...';
1742: DECLARE
1743: l_return_status VARCHAR2(1);
1744: CURSOR get_proj_attr
1745: IS

Line 1760: PA_PROJECT_CTX_SEARCH_PVT.INSERT_ROW (

1756: OPEN get_proj_attr;
1757: FETCH get_proj_attr INTO l_name, l_long_name, l_number, l_description, l_template_flag;
1758: CLOSE get_proj_attr;
1759:
1760: PA_PROJECT_CTX_SEARCH_PVT.INSERT_ROW (
1761: p_project_id => x_new_project_id
1762: ,p_template_flag => l_template_flag
1763: ,p_project_name => l_name
1764: ,p_project_number => l_number

Line 1771: x_err_stage := 'API: '||'PA_PROJECT_CTX_SEARCH_PVT.INSERT_ROW'||

1767: ,x_return_status => l_return_status );
1768:
1769: EXCEPTION WHEN OTHERS THEN
1770: x_err_code := 114;
1771: x_err_stage := 'API: '||'PA_PROJECT_CTX_SEARCH_PVT.INSERT_ROW'||
1772: ' SQL error message: '||SUBSTR( SQLERRM,1,1900);
1773: rollback to copy_project;
1774: revert_proj_number(x_proj_number_gen_mode,x_new_project_number); -- Added for Bug# 7445534
1775: return;