APPS.PA_PROJECTS_PKG1 dependencies on PA_PROJECTS

Line 1: PACKAGE BODY PA_PROJECTS_PKG1 as

1: PACKAGE BODY PA_PROJECTS_PKG1 as
2: /* $Header: PAXPRO1B.pls 120.6 2011/03/21 10:53:42 pcheruvu ship $ */
3:
4: PROCEDURE Update_Row(X_Rowid VARCHAR2,
5: X_Project_Id NUMBER,

Line 203: UPDATE pa_projects

199:
200: l_return_status VARCHAR2(1);
201: BEGIN
202:
203: UPDATE pa_projects
204: SET
205: project_id = X_Project_Id,
206: name = X_Name,
207: long_name = X_Long_Name,

Line 413: FROM PA_PROJECTS_ALL

409: PROCEDURE Delete_Row(X_project_id NUMBER) IS
410:
411: CURSOR get_template_flag IS
412: SELECT template_flag
413: FROM PA_PROJECTS_ALL
414: WHERE project_id = x_project_id;
415:
416: l_template_flag VARCHAR2(1);
417: l_return_status VARCHAR2(1);

Line 432: DELETE FROM pa_projects

428: ,p_template_flag => l_template_flag
429: ,x_return_status => l_return_status );
430: -- anlee end of changes
431:
432: DELETE FROM pa_projects
433: WHERE project_id = X_project_id;
434:
435: if (SQL%NOTFOUND) then
436: Raise NO_DATA_FOUND;

Line 442: END PA_PROJECTS_PKG1;

438:
439: END Delete_Row;
440:
441:
442: END PA_PROJECTS_PKG1;