APPS.PA_PROJECT_SUBTEAM_PARTIES_PVT dependencies on PA_PROJECT_SUBTEAMS

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

17: p_debug_mode IN VARCHAR2 := 'N',
18:
19: p_max_msg_count IN NUMBER := FND_API.g_miss_num,
20:
21: p_project_subteam_id IN pa_project_subteams.Project_subteam_id%TYPE := FND_API.g_miss_num,
22:
23: p_object_type IN varchar2,
24:
25: p_object_id IN NUMBER := fnd_api.g_miss_num,

Line 74: -- FROM pa_project_subteams

70: PA_PROJECT_SUBTEAM_PARTIES_PVT.g_error_exists := FND_API.G_TRUE;
71: --ELSE
72: -- SELECT COUNT(*)
73: -- INTO l_name_count
74: -- FROM pa_project_subteams
75: -- WHERE project_subteam_id = p_project_subteam_id;
76:
77: -- IF l_name_count < 1 then
78: -- PA_UTILS.Add_Message( p_app_short_name => 'PA'

Line 238: p_record_version_number IN pa_project_subteams.record_version_number%TYPE := fnd_api.g_miss_num,

234: p_object_id IN NUMBER := fnd_api.g_miss_num,
235:
236: p_primary_subteam_flag IN VARCHAR2 := fnd_api.g_miss_char,
237:
238: p_record_version_number IN pa_project_subteams.record_version_number%TYPE := fnd_api.g_miss_num,
239:
240: x_return_status OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
241: x_record_version_number OUT NOCOPY NUMBER , --File.Sql.39 bug 4440895
242: x_msg_count OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895

Line 247: l_old_subteam_name pa_project_subteams.name%TYPE := FND_API.g_miss_char;

243: x_msg_data OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
244: ) IS
245:
246: l_count number;
247: l_old_subteam_name pa_project_subteams.name%TYPE := FND_API.g_miss_char;
248: l_name_count NUMBER;
249: l_msg_index_out NUMBER;
250: l_delete_flag NUMBER := 0;
251: l_record_version_number NUMBER;

Line 292: --FROM pa_project_subteams

288: l_delete_flag := 1;
289: --ELSE
290: --SELECT COUNT(*)
291: --INTO l_name_count
292: --FROM pa_project_subteams
293: --WHERE project_subteam_id =p_project_subteam_id;
294:
295: --IF l_name_count < 1 then
296: -- PA_UTILS.Add_Message( p_app_short_name => 'PA'

Line 483: p_record_version_number IN pa_project_subteams.record_version_number%TYPE := FND_API.G_MISS_NUM,

479: p_object_id IN NUMBER := fnd_api.g_miss_num,
480:
481: p_primary_subteam_flag IN VARCHAR2 := fnd_api.g_miss_char,
482:
483: p_record_version_number IN pa_project_subteams.record_version_number%TYPE := FND_API.G_MISS_NUM,
484:
485: p_get_subteam_party_id_flag IN VARCHAR2 := 'N',
486:
487: x_project_subteam_party_id OUT NOCOPY pa_project_subteam_parties.project_subteam_party_id%TYPE, --File.Sql.39 bug 4440895

Line 671: p_project_subteam_party_id IN pa_project_subteams.project_subteam_id%TYPE := fnd_api.g_miss_num,

667: p_max_msg_count IN NUMBER := FND_API.g_miss_num,
668:
669: p_project_subteam_party_row_id IN ROWID := NULL,
670:
671: p_project_subteam_party_id IN pa_project_subteams.project_subteam_id%TYPE := fnd_api.g_miss_num,
672:
673: p_record_version_number IN NUMBER := FND_API.G_MISS_NUM,
674:
675: x_return_status OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895

Line 792: -- p_project_subteam_party_id IN pa_project_subteams.project_subteam_id%TYPE := fnd_api.g_miss_num,

788: -- p_project_subteam_party_row_id IN ROWID := NULL,
789:
790: -- p_record_version_number IN NUMBER := FND_API.G_MISS_NUM,
791:
792: -- p_project_subteam_party_id IN pa_project_subteams.project_subteam_id%TYPE := fnd_api.g_miss_num,
793:
794: x_return_status OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
795: x_msg_count OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895
796: x_msg_data OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895

Line 807: --l_subteam_party_id pa_project_subteams.project_subteam_id%TYPE := fnd_api.g_miss_num;

803: FROM pa_project_subteam_parties
804: WHERE object_id = p_object_id
805: AND object_type = p_object_type;
806:
807: --l_subteam_party_id pa_project_subteams.project_subteam_id%TYPE := fnd_api.g_miss_num;
808:
809: l_subteam_party_id NUMBER := fnd_api.g_miss_num;
810:
811: l_row_id ROWID;