APPS.PA_PROJECT_SETS_PKG dependencies on PA_PROJECT_SET_LINES

Line 293: ( p_project_set_id IN pa_project_set_lines.project_set_id%TYPE

289: END Delete_Row;
290:
291:
292: PROCEDURE insert_row_lines
293: ( p_project_set_id IN pa_project_set_lines.project_set_id%TYPE
294: ,p_project_id IN pa_project_set_lines.project_id%TYPE
295: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
296: )
297: IS

Line 294: ,p_project_id IN pa_project_set_lines.project_id%TYPE

290:
291:
292: PROCEDURE insert_row_lines
293: ( p_project_set_id IN pa_project_set_lines.project_set_id%TYPE
294: ,p_project_id IN pa_project_set_lines.project_id%TYPE
295: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
296: )
297: IS
298: l_enable_log varchar2(1) := NVL(FND_PROFILE.value('PA_DEBUG_MODE'), 'N');

Line 311: INSERT INTO pa_project_set_lines(

307: ,x_msg => 'Beginning of insert row lines'
308: ,x_log_level => 5);
309: END IF;
310:
311: INSERT INTO pa_project_set_lines(
312: project_set_id
313: ,project_id
314: ,creation_date
315: ,created_by

Line 331: FND_MSG_PUB.add_exc_msg ( p_pkg_name => 'PA_PROJECT_SET_LINES_PKG.Insert_row_lines'

327: -- Put any message text from message stack into the Message ARRAY
328: EXCEPTION
329: WHEN OTHERS THEN
330: -- Set the exception Message and the stack
331: FND_MSG_PUB.add_exc_msg ( p_pkg_name => 'PA_PROJECT_SET_LINES_PKG.Insert_row_lines'
332: ,p_procedure_name => PA_DEBUG.G_Err_Stack );
333: --
334: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
335: RAISE;

Line 341: ( p_project_set_id IN pa_project_set_lines.project_set_id%TYPE

337: END Insert_Row_Lines;
338:
339:
340: PROCEDURE delete_row_lines
341: ( p_project_set_id IN pa_project_set_lines.project_set_id%TYPE
342: ,p_project_id IN pa_project_set_lines.project_id%TYPE
343: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
344: )
345: IS

Line 342: ,p_project_id IN pa_project_set_lines.project_id%TYPE

338:
339:
340: PROCEDURE delete_row_lines
341: ( p_project_set_id IN pa_project_set_lines.project_set_id%TYPE
342: ,p_project_id IN pa_project_set_lines.project_id%TYPE
343: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
344: )
345: IS
346: l_enable_log varchar2(1) := NVL(FND_PROFILE.value('PA_DEBUG_MODE'), 'N');

Line 359: DELETE FROM pa_project_set_lines

355: ,x_msg => 'Beginning of delete row lines'
356: ,x_log_level => 5);
357: END IF;
358:
359: DELETE FROM pa_project_set_lines
360: WHERE project_set_id = p_project_set_id
361: AND project_id = p_project_id;
362:
363:

Line 368: FND_MSG_PUB.add_exc_msg ( p_pkg_name => 'PA_PROJECT_SET_LINES_PKG.Delete_row_lines'

364: -- Put any message text from message stack into the Message ARRAY
365: EXCEPTION
366: WHEN OTHERS THEN
367: -- Set the exception Message and the stack
368: FND_MSG_PUB.add_exc_msg ( p_pkg_name => 'PA_PROJECT_SET_LINES_PKG.Delete_row_lines'
369: ,p_procedure_name => PA_DEBUG.G_Err_Stack );
370: --
371: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
372: RAISE;