APPS.PA_STATUSES_PVT dependencies on PA_PROJECT_STATUSES

Line 5: -- Purpose : Private Package for table PA_PROJECT_STATUSES

1: PACKAGE BODY PA_STATUSES_PVT as
2: /* $Header: PARSTAVB.pls 120.1 2005/08/19 17:00:43 mwasowic noship $ */
3: -- Start of Comments
4: -- Package name : PA_STATUSES_PVT
5: -- Purpose : Private Package for table PA_PROJECT_STATUSES
6: -- History : 07-JUL-2000 Mohnish Created
7: -- 11-OCT-2000 Partha serveroutput is removed
8: -- 14-FEB-2003 mrajput Bug2778408 : Added api Process_Phase_Code_Delete
9: --

Line 95: from pa_project_statuses

91:
92: -- get the status_type for the current status_code
93: select status_type
94: into l_status_type
95: from pa_project_statuses
96: where project_status_code=p_pa_project_status_code;
97:
98: -- check if the status is deletable, ie. not being used anywhere
99: pa_project_stus_utils.allow_status_deletion(

Line 107: -- call the table handler of PA_PROJECT_STATUSES, PA_PROJECT_STATUS_CONTROLS

103: , x_err_stage
104: , x_err_stack
105: , x_allow_deletion_flag);
106:
107: -- call the table handler of PA_PROJECT_STATUSES, PA_PROJECT_STATUS_CONTROLS
108: -- and PA_NEXT_ALLOW_STATUSES for delete if there is no error in the above call
109: IF (x_allow_deletion_flag = 'Y') THEN
110: /* Start Changes for Bug 2778408 */
111: IF (l_status_type='PHASE') THEN

Line 143: PA_PROJECT_STATUSES_PKG.delete_row(p_pa_project_status_code);

139: RAISE FND_API.G_EXC_ERROR;
140: END IF;
141: End IF;
142: /* End of Changes for Bug 2778408 */
143: PA_PROJECT_STATUSES_PKG.delete_row(p_pa_project_status_code);
144: PA_PROJECT_STATUS_CONTROLS_PKG.delete_row(p_pa_project_status_code);
145: PA_NEXT_ALLOW_STATUSES_PKG.delete_row(p_pa_project_status_code);
146: ELSE
147: x_msg_data := x_err_stage;