APPS.PA_PROJECT_SUBTEAM_PARTIES_PKG dependencies on PA_PROJECT_SUBTEAMS

Line 6: p_project_subteam_id IN pa_project_subteams.Project_subteam_id%TYPE := FND_API.g_miss_num,

2: --$Header: PARTSPHB.pls 120.1 2005/08/19 17:01:37 mwasowic noship $
3:
4: PROCEDURE Insert_Row
5: (
6: p_project_subteam_id IN pa_project_subteams.Project_subteam_id%TYPE := FND_API.g_miss_num,
7:
8: p_object_type IN pa_project_subteam_parties.object_type%TYPE := FND_API.g_miss_char,
9:
10: p_object_id IN pa_project_subteam_parties.object_id%TYPE := fnd_api.g_miss_num,

Line 39: --SELECT pa_project_subteams_s.NEXTVAL

35:
36: x_return_status := FND_API.G_RET_STS_SUCCESS;
37:
38: --Fetch the next sequence number for subteam
39: --SELECT pa_project_subteams_s.NEXTVAL
40: --INTO l_subteam_party_id
41: --FROM dual;
42:
43: if p_primary_subteam_flag is NULL or p_primary_subteam_flag = FND_API.g_miss_char then

Line 64: pa_project_subteams_s.NEXTVAL,

60: last_update_login )
61: VALUES
62: (
63: --l_subteam_party_id,
64: pa_project_subteams_s.NEXTVAL,
65: DECODE(p_project_subteam_id, FND_API.G_MISS_NUM, NULL, p_project_subteam_id),
66: 1,
67: DECODE(p_object_type, FND_API.G_MISS_CHAR, NULL, p_object_type),
68: DECODE(p_object_id, FND_API.G_MISS_NUM, NULL, p_object_id),

Line 92: -- PA_Error_Utils.Set_Error_Stack('PA_PROJECT_SUBTEAMS_PKG.Insert_Row');

88: --
89: EXCEPTION
90: WHEN OTHERS THEN -- catch the exceptions here
91: -- Set the current program unit name in the error stack
92: -- PA_Error_Utils.Set_Error_Stack('PA_PROJECT_SUBTEAMS_PKG.Insert_Row');
93: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
94: RAISE;
95: END Insert_Row;
96:

Line 103: p_project_subteam_id IN pa_project_subteams.project_subteam_id%TYPE,

99: p_project_subteam_party_row_id IN ROWID :=NULL,
100:
101: p_project_subteam_party_id IN pa_project_subteam_parties.project_subteam_party_id%TYPE,
102:
103: p_project_subteam_id IN pa_project_subteams.project_subteam_id%TYPE,
104:
105: -- p_object_type IN varchar2,
106:
107: -- p_object_id IN NUMBER := fnd_api.g_miss_num,

Line 186: -- PA_Error_Utils.Set_Error_Stack('PA_PROJECT_SUBTEAMS_PKG.Update_Row');

182: --
183: EXCEPTION
184: WHEN OTHERS THEN -- catch the exceptins here
185: -- Set the current program unit name in the error stack
186: -- PA_Error_Utils.Set_Error_Stack('PA_PROJECT_SUBTEAMS_PKG.Update_Row');
187: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
188: RAISE;
189: END Update_Row;
190: