1 PACKAGE pa_project_subteam_utils AS
2 /*$Header: PARTSTUS.pls 120.1 2005/08/19 17:02:04 mwasowic noship $*/
3
4 /**************************************************************
5 PROCEDURE
6 Check_Subteam_Name_Or_Id
7 PURPOSE
8 This procedure does the following
9 1. If the subteam_id and check_id_flag is passed as 'Y'
10 then it checks the passed subteam_id is a valid one.
11 If object_type,object_id and subteam name is passed,
12 returns the subteam_id if teher exists one
13 In both the cases the x_return_status will be
14 success - FND_API.G_RET_STS_SUCCESS
15 failure - FND_API.G_RET_STS_ERRORS
16 **************************************************************/
17
18 procedure Check_Subteam_Name_Or_Id (
19 p_subteam_name IN VARCHAR2 :=FND_API.G_MISS_CHAR,
20 p_object_type IN VARCHAR2 := FND_API.G_MISS_CHAR,
21 p_object_id IN NUMBER := FND_API.G_MISS_NUM,
22 p_check_id_flag IN VARCHAR2 := 'A',
23 x_subteam_id IN OUT NOCOPY NUMBER , --File.Sql.39 bug 4440895
24 x_return_status OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
25 x_error_message_code OUT NOCOPY VARCHAR2 ); --File.Sql.39 bug 4440895
26
27 procedure get_object_id(p_object_type IN varchar2
28 ,p_object_id IN OUT NOCOPY number --File.Sql.39 bug 4440895
29 ,p_object_name IN varchar2
30 ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
31 ,x_error_message_code OUT NOCOPY VARCHAR2); --File.Sql.39 bug 4440895
32
33 END pa_project_subteam_utils;