DBA Data[Home] [Help]

APPS.PA_TASK_PVT1 dependencies on PA_RELATIONSHIP_PUB

Line 3812: PA_RELATIONSHIP_PUB.Create_Relationship

3808: --my_error_msg( 'In create_task_version pvt API Stage 5' );
3809:
3810:
3811: --create new relationship
3812: PA_RELATIONSHIP_PUB.Create_Relationship
3813: (
3814: p_api_version => p_api_version
3815: ,p_init_msg_list => p_init_msg_list
3816: ,p_commit => p_commit

Line 6243: pa_debug.write('PA_TASK_PVT1.DELETE_TASK_VERSION', 'Before PA_RELATIONSHIP_PUB.Delete_SubProject_Association get_subproj_relation_rec.object_relationship_id='

6239: FETCH get_subproj_relation INTO get_subproj_relation_rec;
6240: IF get_subproj_relation%FOUND --bug 4573340
6241: THEN
6242: IF l_debug_mode = 'Y' THEN
6243: pa_debug.write('PA_TASK_PVT1.DELETE_TASK_VERSION', 'Before PA_RELATIONSHIP_PUB.Delete_SubProject_Association get_subproj_relation_rec.object_relationship_id='
6244: ||get_subproj_relation_rec.object_relationship_id, 3);
6245: pa_debug.write('PA_TASK_PVT1.DELETE_TASK_VERSION', 'Before PA_RELATIONSHIP_PUB.Delete_SubProject_Association get_subproj_relation_rec.record_version_number='
6246: ||get_subproj_relation_rec.record_version_number, 3);
6247:

Line 6245: pa_debug.write('PA_TASK_PVT1.DELETE_TASK_VERSION', 'Before PA_RELATIONSHIP_PUB.Delete_SubProject_Association get_subproj_relation_rec.record_version_number='

6241: THEN
6242: IF l_debug_mode = 'Y' THEN
6243: pa_debug.write('PA_TASK_PVT1.DELETE_TASK_VERSION', 'Before PA_RELATIONSHIP_PUB.Delete_SubProject_Association get_subproj_relation_rec.object_relationship_id='
6244: ||get_subproj_relation_rec.object_relationship_id, 3);
6245: pa_debug.write('PA_TASK_PVT1.DELETE_TASK_VERSION', 'Before PA_RELATIONSHIP_PUB.Delete_SubProject_Association get_subproj_relation_rec.record_version_number='
6246: ||get_subproj_relation_rec.record_version_number, 3);
6247:
6248: END IF;
6249:

Line 6250: PA_RELATIONSHIP_PUB.Delete_SubProject_Association --bug 4573340 replaced the call with delete_subproject

6246: ||get_subproj_relation_rec.record_version_number, 3);
6247:
6248: END IF;
6249:
6250: PA_RELATIONSHIP_PUB.Delete_SubProject_Association --bug 4573340 replaced the call with delete_subproject
6251: (
6252: p_init_msg_list => p_init_msg_list
6253: ,p_commit => p_commit
6254: ,p_validate_only => p_validate_only

Line 6267: pa_debug.write('PA_TASK_PVT1.DELETE_TASK_VERSION', 'After PA_RELATIONSHIP_PUB.Delete_SubProject_Association l_return_status='||l_return_status, 3);

6263: ,x_msg_data => l_msg_data
6264: );
6265:
6266: IF l_debug_mode = 'Y' THEN
6267: pa_debug.write('PA_TASK_PVT1.DELETE_TASK_VERSION', 'After PA_RELATIONSHIP_PUB.Delete_SubProject_Association l_return_status='||l_return_status, 3);
6268: END IF;
6269:
6270: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
6271: x_msg_count := FND_MSG_PUB.count_msg;

Line 6288: PA_RELATIONSHIP_PUB.Delete_Relationship

6284: END IF; --4573340
6285: CLOSE get_subproj_relation;
6286:
6287:
6288: PA_RELATIONSHIP_PUB.Delete_Relationship
6289: (
6290: p_api_version => p_api_version
6291: ,p_init_msg_list => p_init_msg_list
6292: ,p_commit => p_commit

Line 10021: pa_debug.write('PA_TASK_PVT1.DELETE_TASK_VER_WO_VAL', 'Before PA_RELATIONSHIP_PUB.Delete_SubProject_Association get_subproj_relation_rec.object_relationship_id='

10017: --Bug 14591859: One task can have multiple projects linked to it. So need to delete all the sub-projects associated to it.
10018: l_dest_proj_id:=null; --Added for the Bug 14591859
10019: FOR get_subproj_relation_rec in get_subproj_relation(cur_child_tasks_rec.object_id_to1) LOOP --Added for the Bug 14591859
10020: IF l_debug_mode = 'Y' THEN
10021: pa_debug.write('PA_TASK_PVT1.DELETE_TASK_VER_WO_VAL', 'Before PA_RELATIONSHIP_PUB.Delete_SubProject_Association get_subproj_relation_rec.object_relationship_id='
10022: ||get_subproj_relation_rec.object_relationship_id, 3);
10023: pa_debug.write('PA_TASK_PVT1.DELETE_TASK_VER_WO_VAL', 'Before PA_RELATIONSHIP_PUB.Delete_SubProject_Association get_subproj_relation_rec.record_version_number='
10024: ||get_subproj_relation_rec.record_version_number, 3);
10025:

Line 10023: pa_debug.write('PA_TASK_PVT1.DELETE_TASK_VER_WO_VAL', 'Before PA_RELATIONSHIP_PUB.Delete_SubProject_Association get_subproj_relation_rec.record_version_number='

10019: FOR get_subproj_relation_rec in get_subproj_relation(cur_child_tasks_rec.object_id_to1) LOOP --Added for the Bug 14591859
10020: IF l_debug_mode = 'Y' THEN
10021: pa_debug.write('PA_TASK_PVT1.DELETE_TASK_VER_WO_VAL', 'Before PA_RELATIONSHIP_PUB.Delete_SubProject_Association get_subproj_relation_rec.object_relationship_id='
10022: ||get_subproj_relation_rec.object_relationship_id, 3);
10023: pa_debug.write('PA_TASK_PVT1.DELETE_TASK_VER_WO_VAL', 'Before PA_RELATIONSHIP_PUB.Delete_SubProject_Association get_subproj_relation_rec.record_version_number='
10024: ||get_subproj_relation_rec.record_version_number, 3);
10025:
10026: END IF;
10027:

Line 10030: PA_RELATIONSHIP_PUB.Delete_SubProject_Association --bug 4573340 replaced the call with delete_subproject

10026: END IF;
10027:
10028: IF l_dest_proj_id is null or l_dest_proj_id<>get_subproj_relation_rec.object_id_to2 then --Added for the Bug 14591859
10029: l_dest_proj_id:=get_subproj_relation_rec.object_id_to2; --Added for the Bug 14591859
10030: PA_RELATIONSHIP_PUB.Delete_SubProject_Association --bug 4573340 replaced the call with delete_subproject
10031: (
10032: p_init_msg_list => p_init_msg_list
10033: ,p_commit => p_commit
10034: ,p_validate_only => p_validate_only

Line 10047: pa_debug.write('PA_TASK_PVT1.DELETE_TASK_VER_WO_VAL', 'After PA_RELATIONSHIP_PUB.Delete_SubProject_Association l_return_status='||l_return_status, 3);

10043: ,x_msg_data => l_msg_data
10044: );
10045:
10046: IF l_debug_mode = 'Y' THEN
10047: pa_debug.write('PA_TASK_PVT1.DELETE_TASK_VER_WO_VAL', 'After PA_RELATIONSHIP_PUB.Delete_SubProject_Association l_return_status='||l_return_status, 3);
10048: END IF;
10049:
10050:
10051: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN

Line 10071: PA_RELATIONSHIP_PUB.Delete_Relationship (

10067: -- END IF; --4573340 -- Commented for the Bug 14591859
10068: -- CLOSE get_subproj_relation; -- Commented for the Bug 14591859
10069: END LOOP; --Added for the Bug 14591859
10070: l_dest_proj_id :=null; --Added for the Bug 14591859
10071: PA_RELATIONSHIP_PUB.Delete_Relationship (
10072: p_api_version => p_api_version
10073: ,p_init_msg_list => p_init_msg_list
10074: ,p_commit => p_commit
10075: ,p_validate_only => p_validate_only