APPS.PA_ASSIGNMENTS_PVT dependencies on PA_PROJECT_SUBTEAM_PARTIES

Line 32: l_project_subteam_party_id pa_project_subteam_parties.project_subteam_party_id%TYPE;

28: )
29: IS
30:
31: l_assignment_rec PA_ASSIGNMENTS_PUB.Assignment_Rec_Type;
32: l_project_subteam_party_id pa_project_subteam_parties.project_subteam_party_id%TYPE;
33: l_return_status VARCHAR2(10);
34: l_row_id ROWID;
35: l_msg_count NUMBER;
36: l_msg_data VARCHAR2(4000);

Line 52: FROM pa_project_subteam_parties

48:
49: CURSOR get_subteam_id IS
50: SELECT project_subteam_id,
51: primary_subteam_flag
52: FROM pa_project_subteam_parties
53: WHERE object_type = 'PA_PROJECT_ASSIGNMENTS'
54: AND object_id = l_assignment_rec.source_assignment_id;
55:
56: BEGIN

Line 241: PA_PROJECT_SUBTEAM_PARTIES_PVT.Create_Subteam_Party

237: ,x_msg => 'Calling Create Assignment'
238: ,x_log_level => 5);
239: END IF;
240:
241: PA_PROJECT_SUBTEAM_PARTIES_PVT.Create_Subteam_Party
242: ( p_validate_only => p_validate_only
243: ,p_project_subteam_id => p_project_subteam_id
244: ,p_object_type => 'PA_PROJECT_ASSIGNMENTS'
245: ,p_object_id => PA_ASSIGNMENTS_PUB.g_assignment_id_tbl(i).assignment_id

Line 273: PA_PROJECT_SUBTEAM_PARTIES_PVT.Create_Subteam_Party

269: ,x_msg => 'Calling Create Assignment'
270: ,x_log_level => 5);
271: END IF;
272:
273: PA_PROJECT_SUBTEAM_PARTIES_PVT.Create_Subteam_Party
274: ( p_validate_only => p_validate_only
275: ,p_project_subteam_id => get_subteam_id_rec.project_subteam_id
276: ,p_object_type => 'PA_PROJECT_ASSIGNMENTS'
277: ,p_object_id => PA_ASSIGNMENTS_PUB.g_assignment_id_tbl(i).assignment_id

Line 374: ,p_project_subteam_party_id IN pa_project_subteam_parties.project_subteam_party_id%TYPE := FND_API.G_MISS_NUM

370:
371: PROCEDURE Update_Assignment
372: ( p_assignment_rec IN PA_ASSIGNMENTS_PUB.Assignment_Rec_Type
373: ,p_project_subteam_id IN pa_project_subteams.project_subteam_id%TYPE := FND_API.G_MISS_NUM
374: ,p_project_subteam_party_id IN pa_project_subteam_parties.project_subteam_party_id%TYPE := FND_API.G_MISS_NUM
375: ,p_location_city IN pa_locations.city%TYPE := FND_API.G_MISS_CHAR
376: ,p_location_region IN pa_locations.region%TYPE := FND_API.G_MISS_CHAR
377: ,p_location_country_code IN pa_locations.country_code%TYPE := FND_API.G_MISS_CHAR
378: ,p_commit IN VARCHAR2 := FND_API.G_FALSE

Line 384: l_project_subteam_party_id pa_project_subteam_parties.project_subteam_party_id%TYPE;

380: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
381: )
382: IS
383:
384: l_project_subteam_party_id pa_project_subteam_parties.project_subteam_party_id%TYPE;
385: l_return_status VARCHAR2(10);
386: l_record_version_number NUMBER;
387: l_msg_count NUMBER;
388: l_msg_data VARCHAR2(4000);

Line 432: PA_PROJECT_SUBTEAM_PARTIES_PVT.Update_SPT_Assgn

428: PA_DEBUG.write_log (x_module => 'pa.plsql.PA_ASSIGNMENTS_PVT.Update_Assignment.update_subteam_party'
429: ,x_msg => 'Calling Update_SPT_Assgn for subteam party.'
430: ,x_log_level => 5);
431: END IF;
432: PA_PROJECT_SUBTEAM_PARTIES_PVT.Update_SPT_Assgn
433: ( p_validate_only => p_validate_only
434: ,p_project_subteam_party_id => p_project_subteam_party_id
435: ,p_project_subteam_id => p_project_subteam_id
436: ,p_object_type => 'PA_PROJECT_ASSIGNMENTS'

Line 658: PA_PROJECT_SUBTEAM_PARTIES_PVT.Delete_SubteamParty_By_Obj

654: PA_DEBUG.write_log (x_module => 'pa.plsql.PA_ASSIGNMENTS_PVT.Delete_Assignment.delete_subteam_party'
655: ,x_msg => 'Deleting subteam party'
656: ,x_log_level => 5);
657: END IF;
658: PA_PROJECT_SUBTEAM_PARTIES_PVT.Delete_SubteamParty_By_Obj
659: ( p_validate_only => p_validate_only
660: ,p_object_type => 'PA_PROJECT_ASSIGNMENTS'
661: ,p_object_id => p_assignment_id
662: ,p_init_msg_list => FND_API.G_FALSE -- Added for bug 5130421