eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PA_PROJECT_SUBTEAM_UTILS dependencies on FND_API

Line 15: p_subteam_name IN VARCHAR2 :=FND_API.G_MISS_CHAR,

11: validates it
12: ***************************************************************/
13:
14: procedure Check_Subteam_Name_Or_Id (
15: p_subteam_name IN VARCHAR2 :=FND_API.G_MISS_CHAR,
16: p_object_type IN VARCHAR2 := FND_API.G_MISS_CHAR,
17: p_object_id IN NUMBER := FND_API.G_MISS_NUM,
18: p_check_id_flag IN VARCHAR2 := 'A',
19: x_subteam_id IN OUT NOCOPY NUMBER , --File.Sql.39 bug 4440895

Line 16: p_object_type IN VARCHAR2 := FND_API.G_MISS_CHAR,

12: ***************************************************************/
13:
14: procedure Check_Subteam_Name_Or_Id (
15: p_subteam_name IN VARCHAR2 :=FND_API.G_MISS_CHAR,
16: p_object_type IN VARCHAR2 := FND_API.G_MISS_CHAR,
17: p_object_id IN NUMBER := FND_API.G_MISS_NUM,
18: p_check_id_flag IN VARCHAR2 := 'A',
19: x_subteam_id IN OUT NOCOPY NUMBER , --File.Sql.39 bug 4440895
20: x_return_status OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895

Line 17: p_object_id IN NUMBER := FND_API.G_MISS_NUM,

13:
14: procedure Check_Subteam_Name_Or_Id (
15: p_subteam_name IN VARCHAR2 :=FND_API.G_MISS_CHAR,
16: p_object_type IN VARCHAR2 := FND_API.G_MISS_CHAR,
17: p_object_id IN NUMBER := FND_API.G_MISS_NUM,
18: p_check_id_flag IN VARCHAR2 := 'A',
19: x_subteam_id IN OUT NOCOPY NUMBER , --File.Sql.39 bug 4440895
20: x_return_status OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
21: x_error_message_code OUT NOCOPY VARCHAR2 ) --File.Sql.39 bug 4440895

Line 32: AND object_type = decode(p_object_type, FND_API.G_MISS_CHAR, object_type, null, object_type, p_object_type) -- 5130421

28: SELECT project_subteam_id
29: INTO x_subteam_id
30: FROM pa_project_subteams
31: WHERE project_subteam_id = x_subteam_id
32: AND object_type = decode(p_object_type, FND_API.G_MISS_CHAR, object_type, null, object_type, p_object_type) -- 5130421
33: AND object_id = decode(p_object_id, FND_API.G_MISS_NUM, object_id, null, object_id, p_object_id) -- 5130421
34: ;
35: elsif (p_check_id_flag = 'N') then
36: -- No ID validation is required

Line 33: AND object_id = decode(p_object_id, FND_API.G_MISS_NUM, object_id, null, object_id, p_object_id) -- 5130421

29: INTO x_subteam_id
30: FROM pa_project_subteams
31: WHERE project_subteam_id = x_subteam_id
32: AND object_type = decode(p_object_type, FND_API.G_MISS_CHAR, object_type, null, object_type, p_object_type) -- 5130421
33: AND object_id = decode(p_object_id, FND_API.G_MISS_NUM, object_id, null, object_id, p_object_id) -- 5130421
34: ;
35: elsif (p_check_id_flag = 'N') then
36: -- No ID validation is required
37: x_subteam_id := x_subteam_id;

Line 64: x_return_status := FND_API.G_RET_STS_SUCCESS;

60: x_subteam_id := null;
61: end if;
62: END IF;
63:
64: x_return_status := FND_API.G_RET_STS_SUCCESS;
65:
66: EXCEPTION
67: WHEN NO_DATA_FOUND THEN
68: x_return_status := FND_API.G_RET_STS_ERROR;

Line 68: x_return_status := FND_API.G_RET_STS_ERROR;

64: x_return_status := FND_API.G_RET_STS_SUCCESS;
65:
66: EXCEPTION
67: WHEN NO_DATA_FOUND THEN
68: x_return_status := FND_API.G_RET_STS_ERROR;
69: x_error_message_code := 'PA_SBT_ID_INV';
70: WHEN TOO_MANY_ROWS THEN
71: x_return_status := FND_API.G_RET_STS_ERROR;
72: x_error_message_code := 'PA_SBT_ID_INV';

Line 71: x_return_status := FND_API.G_RET_STS_ERROR;

67: WHEN NO_DATA_FOUND THEN
68: x_return_status := FND_API.G_RET_STS_ERROR;
69: x_error_message_code := 'PA_SBT_ID_INV';
70: WHEN TOO_MANY_ROWS THEN
71: x_return_status := FND_API.G_RET_STS_ERROR;
72: x_error_message_code := 'PA_SBT_ID_INV';
73: WHEN OTHERS THEN
74: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
75:

Line 74: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

70: WHEN TOO_MANY_ROWS THEN
71: x_return_status := FND_API.G_RET_STS_ERROR;
72: x_error_message_code := 'PA_SBT_ID_INV';
73: WHEN OTHERS THEN
74: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
75:
76: END Check_Subteam_Name_Or_Id;
77:
78: procedure get_object_id(p_object_type IN varchar2

Line 98: x_return_status := FND_API.G_RET_STS_ERROR;

94: if (p_object_type = 'PA_PROJECTS') then
95: open c_project;
96: fetch c_project into p_object_id;
97: if (c_project%NOTFOUND) then
98: x_return_status := FND_API.G_RET_STS_ERROR;
99: x_error_message_code := 'PA_SBT_PRJID_INV';
100: close c_project;
101: return;
102: end if;

Line 108: x_return_status := FND_API.G_RET_STS_ERROR;

104: elsif (p_object_type = 'PA_TEAM_TEMPLATES') then
105: open c_team_template;
106: fetch c_team_template into p_object_id;
107: if (c_team_template%NOTFOUND) then
108: x_return_status := FND_API.G_RET_STS_ERROR;
109: x_error_message_code := 'PA_SBT_TEAMTEMPLID_INV';
110: close c_team_template;
111: return;
112: end if;

Line 114: x_return_status := FND_API.G_RET_STS_SUCCESS;

110: close c_team_template;
111: return;
112: end if;
113: close c_team_template;
114: x_return_status := FND_API.G_RET_STS_SUCCESS;
115: end if;
116: END get_object_id;
117: end pa_project_subteam_utils;