DBA Data[Home] [Help]

APPS.PA_RELATIONSHIP_PVT dependencies on PA_OBJECT_RELATIONSHIPS_PKG

Line 478: PA_OBJECT_RELATIONSHIPS_PKG.INSERT_ROW(

474: --Assign new task as the linking object
475: l_id_from := l_task_version_id;
476: l_type_from := 'PA_TASKS';
477:
478: PA_OBJECT_RELATIONSHIPS_PKG.INSERT_ROW(
479: p_user_id => FND_GLOBAL.USER_ID
480: ,p_object_type_from => l_type_from
481: ,p_object_id_from1 => l_id_from
482: ,p_object_id_from2 => NULL

Line 549: PA_OBJECT_RELATIONSHIPS_PKG.INSERT_ROW(

545: ELSE
546: l_weighting_percentage := p_weighting_percentage;
547: END IF;
548:
549: PA_OBJECT_RELATIONSHIPS_PKG.INSERT_ROW(
550: p_user_id => FND_GLOBAL.USER_ID
551: ,p_object_type_from => l_type_from
552: ,p_object_id_from1 => l_id_from
553: ,p_object_id_from2 => NULL

Line 604: PA_OBJECT_RELATIONSHIPS_PKG.INSERT_ROW(

600: IF (p_task_version_id_to IS NOT NULL) THEN
601: l_id_to := p_task_version_id_to;
602: l_type_to := 'PA_TASKS';
603: END IF;
604: PA_OBJECT_RELATIONSHIPS_PKG.INSERT_ROW(
605: p_user_id => FND_GLOBAL.USER_ID
606: , p_object_type_from => l_type_from
607: , p_object_id_from1 => l_id_from
608: , p_object_id_from2 => NULL

Line 776: PA_OBJECT_RELATIONSHIPS_PKG.DELETE_ROW(

772: ELSE
773: l_weighting_percentage := p_weighting_percentage;
774: END IF;
775:
776: PA_OBJECT_RELATIONSHIPS_PKG.DELETE_ROW(
777: p_object_relationship_id => p_object_relationship_id
778: ,p_object_type_from => NULL
779: ,p_object_id_from1 => NULL
780: ,p_object_id_from2 => NULL

Line 803: PA_OBJECT_RELATIONSHIPS_PKG.INSERT_ROW(

799: RAISE FND_API.G_EXC_UNEXPECTED_ERROR; -- To go to WHEN OTHERS Block
800: END IF;
801: -- End 4537865
802:
803: PA_OBJECT_RELATIONSHIPS_PKG.INSERT_ROW(
804: p_user_id => FND_GLOBAL.USER_ID
805: ,p_object_type_from => l_type_from
806: ,p_object_id_from1 => l_id_from
807: ,p_object_id_from2 => NULL

Line 935: PA_OBJECT_RELATIONSHIPS_PKG.DELETE_ROW(

931: OPEN get_link_task_ver_id;
932: FETCH get_link_task_ver_id into l_link_task_ver;
933: CLOSE get_link_task_ver_id;
934:
935: PA_OBJECT_RELATIONSHIPS_PKG.DELETE_ROW(
936: p_object_relationship_id => p_object_relationship_id
937: ,p_object_type_from => NULL
938: ,p_object_id_from1 => NULL
939: ,p_object_id_from2 => NULL

Line 1252: PA_OBJECT_RELATIONSHIPS_PKG.INSERT_ROW(

1248: END;
1249: END IF;
1250:
1251: --Create record in relationships table.
1252: PA_OBJECT_RELATIONSHIPS_PKG.INSERT_ROW(
1253: p_user_id => FND_GLOBAL.USER_ID
1254: ,p_object_type_from => 'PA_TASKS'
1255: ,p_object_id_from1 => p_src_task_ver_id
1256: ,p_object_id_from2 => p_src_proj_id

Line 1357: PA_OBJECT_RELATIONSHIPS_PKG.INSERT_ROW(

1353: END IF;
1354: END IF;
1355:
1356: --Create record in relationships table.
1357: PA_OBJECT_RELATIONSHIPS_PKG.INSERT_ROW(
1358: p_user_id => FND_GLOBAL.USER_ID
1359: ,p_object_type_from => 'PA_TASKS'
1360: ,p_object_id_from1 => p_src_task_ver_id
1361: ,p_object_id_from2 => p_src_proj_id

Line 1543: PA_OBJECT_RELATIONSHIPS_PKG.UPDATE_ROW

1539: l_comments := p_comments;
1540:
1541: --update record in object relationships table
1542:
1543: PA_OBJECT_RELATIONSHIPS_PKG.UPDATE_ROW
1544: ( p_user_id => FND_GLOBAL.USER_ID
1545: ,p_object_relationship_id => l_obj_rel_rec.object_relationship_id
1546: ,p_relationship_type => l_obj_rel_rec.relationship_type
1547: ,p_relationship_subtype => l_rel_subtype

Line 1721: PA_OBJECT_RELATIONSHIPS_PKG.DELETE_ROW (

1717: RAISE FND_API.G_EXC_ERROR;
1718: END IF;
1719: END IF;
1720: --
1721: PA_OBJECT_RELATIONSHIPS_PKG.DELETE_ROW (
1722: p_object_relationship_id => cur_obj_rel_rec.object_relationship_id
1723: ,p_object_type_from => null
1724: ,p_object_id_from1 => null
1725: ,p_object_id_from2 => null

Line 2804: PA_Object_Relationships_PKG.Insert_Row(

2800: l_Lag_Days, l_Comments, l_Sub_Type;
2801: EXIT when Create_Proj_Depend%NOTFOUND;
2802:
2803: l_object_relationship_id := NULL;
2804: PA_Object_Relationships_PKG.Insert_Row(
2805: p_user_id => FND_GLOBAL.USER_ID
2806: ,p_object_type_from => 'PA_TASKS'
2807: ,p_object_id_from1 => l_src_task_ver_id
2808: ,p_object_id_from2 => l_src_proj_id

Line 2883: PA_Object_Relationships_PKG.Insert_Row(

2879: l_dest_proj_id := l_Obj_ID_To2;
2880: End IF;
2881: */
2882: l_object_relationship_id := NULL;
2883: PA_Object_Relationships_PKG.Insert_Row(
2884: p_user_id => FND_GLOBAL.USER_ID
2885: ,p_object_type_from => 'PA_TASKS'
2886: ,p_object_id_from1 => l_obj_id_from1
2887: ,p_object_id_from2 => l_obj_id_from2

Line 3248: pa_debug.debug('PA_OBJECT_RELATIONSHIPS_PKG.INSERT_ROW Linking Task Elem Ver Id => '||x_lnk_task_elem_ver_id);

3244: END IF;
3245: --
3246: IF (p_debug_mode = 'Y') THEN
3247: pa_debug.debug('After Call To PA_TASK_PUB1.Create_Schedule_Version Return Status => '||x_return_status);
3248: pa_debug.debug('PA_OBJECT_RELATIONSHIPS_PKG.INSERT_ROW Linking Task Elem Ver Id => '||x_lnk_task_elem_ver_id);
3249: pa_debug.debug('PA_OBJECT_RELATIONSHIPS_PKG.INSERT_ROW Src Proj Id=> '||p_src_proj_id);
3250: pa_debug.debug('PA_OBJECT_RELATIONSHIPS_PKG.INSERT_ROW Dest Struc Elem Ver Id=> '||p_dest_struc_elem_ver_id);
3251: pa_debug.debug('PA_OBJECT_RELATIONSHIPS_PKG.INSERT_ROW Dest Proj Id=> '||p_dest_proj_id);
3252: END IF;

Line 3249: pa_debug.debug('PA_OBJECT_RELATIONSHIPS_PKG.INSERT_ROW Src Proj Id=> '||p_src_proj_id);

3245: --
3246: IF (p_debug_mode = 'Y') THEN
3247: pa_debug.debug('After Call To PA_TASK_PUB1.Create_Schedule_Version Return Status => '||x_return_status);
3248: pa_debug.debug('PA_OBJECT_RELATIONSHIPS_PKG.INSERT_ROW Linking Task Elem Ver Id => '||x_lnk_task_elem_ver_id);
3249: pa_debug.debug('PA_OBJECT_RELATIONSHIPS_PKG.INSERT_ROW Src Proj Id=> '||p_src_proj_id);
3250: pa_debug.debug('PA_OBJECT_RELATIONSHIPS_PKG.INSERT_ROW Dest Struc Elem Ver Id=> '||p_dest_struc_elem_ver_id);
3251: pa_debug.debug('PA_OBJECT_RELATIONSHIPS_PKG.INSERT_ROW Dest Proj Id=> '||p_dest_proj_id);
3252: END IF;
3253: --

Line 3250: pa_debug.debug('PA_OBJECT_RELATIONSHIPS_PKG.INSERT_ROW Dest Struc Elem Ver Id=> '||p_dest_struc_elem_ver_id);

3246: IF (p_debug_mode = 'Y') THEN
3247: pa_debug.debug('After Call To PA_TASK_PUB1.Create_Schedule_Version Return Status => '||x_return_status);
3248: pa_debug.debug('PA_OBJECT_RELATIONSHIPS_PKG.INSERT_ROW Linking Task Elem Ver Id => '||x_lnk_task_elem_ver_id);
3249: pa_debug.debug('PA_OBJECT_RELATIONSHIPS_PKG.INSERT_ROW Src Proj Id=> '||p_src_proj_id);
3250: pa_debug.debug('PA_OBJECT_RELATIONSHIPS_PKG.INSERT_ROW Dest Struc Elem Ver Id=> '||p_dest_struc_elem_ver_id);
3251: pa_debug.debug('PA_OBJECT_RELATIONSHIPS_PKG.INSERT_ROW Dest Proj Id=> '||p_dest_proj_id);
3252: END IF;
3253: --
3254: /* This API call create relationship between linking task and destination structure vesion */

Line 3251: pa_debug.debug('PA_OBJECT_RELATIONSHIPS_PKG.INSERT_ROW Dest Proj Id=> '||p_dest_proj_id);

3247: pa_debug.debug('After Call To PA_TASK_PUB1.Create_Schedule_Version Return Status => '||x_return_status);
3248: pa_debug.debug('PA_OBJECT_RELATIONSHIPS_PKG.INSERT_ROW Linking Task Elem Ver Id => '||x_lnk_task_elem_ver_id);
3249: pa_debug.debug('PA_OBJECT_RELATIONSHIPS_PKG.INSERT_ROW Src Proj Id=> '||p_src_proj_id);
3250: pa_debug.debug('PA_OBJECT_RELATIONSHIPS_PKG.INSERT_ROW Dest Struc Elem Ver Id=> '||p_dest_struc_elem_ver_id);
3251: pa_debug.debug('PA_OBJECT_RELATIONSHIPS_PKG.INSERT_ROW Dest Proj Id=> '||p_dest_proj_id);
3252: END IF;
3253: --
3254: /* This API call create relationship between linking task and destination structure vesion */
3255: /* in the pa_object_relationships table */

Line 3256: PA_OBJECT_RELATIONSHIPS_PKG.INSERT_ROW(

3252: END IF;
3253: --
3254: /* This API call create relationship between linking task and destination structure vesion */
3255: /* in the pa_object_relationships table */
3256: PA_OBJECT_RELATIONSHIPS_PKG.INSERT_ROW(
3257: p_user_id => FND_GLOBAL.USER_ID
3258: ,p_object_type_from => 'PA_TASKS'
3259: ,p_object_id_from1 => x_lnk_task_elem_ver_id
3260: ,p_object_id_from2 => p_src_proj_id

Line 3387: pa_debug.debug('After Call To PA_OBJECT_RELATIONSHIPS_PKG.INSERT_ROW Return Status => '||x_return_status);

3383: RAISE FND_API.G_EXC_ERROR;
3384: END;
3385: --
3386: IF (p_debug_mode = 'Y') THEN
3387: pa_debug.debug('After Call To PA_OBJECT_RELATIONSHIPS_PKG.INSERT_ROW Return Status => '||x_return_status);
3388: END IF;
3389: --
3390: x_return_status := FND_API.G_RET_STS_SUCCESS;
3391: --

Line 4660: PA_OBJECT_RELATIONSHIPS_PKG.DELETE_ROW(

4656: END;
4657: --
4658:
4659: --PA_RELATIONSHIP_PUB.Delete_Relationship(porb.object_relationship_id);--table handler
4660: PA_OBJECT_RELATIONSHIPS_PKG.DELETE_ROW(
4661: p_object_relationship_id => get_lnk_info_rec.lnk_obj_rel_id
4662: ,p_object_type_from => NULL
4663: ,p_object_id_from1 => NULL
4664: ,p_object_id_from2 => NULL

Line 4695: pa_debug.debug('Return status after call to PA_OBJECT_RELATIONSHIPS_PKG.DELETE_ROW=> '||x_return_status);

4691: raise FND_API.G_EXC_ERROR;
4692: END IF;
4693: --
4694: IF (p_debug_mode = 'Y') THEN
4695: pa_debug.debug('Return status after call to PA_OBJECT_RELATIONSHIPS_PKG.DELETE_ROW=> '||x_return_status);
4696: END IF;
4697: --
4698: -- PA_TASK_PVT1.Delete_Task_Version(pora.object_id_to1);
4699: OPEN get_rec_ver_num(get_lnk_info_rec.lnk_task_ver_id);

Line 5002: PA_OBJECT_RELATIONSHIPS_PKG.INSERT_ROW(

4998: FETCH get_new_pub_lnk_task_ver_id INTO l_new_pub_lnk_task_ver_id;
4999: CLOSE get_new_pub_lnk_task_ver_id;
5000:
5001: IF (l_new_pub_lnk_task_ver_id IS NOT NULL) THEN
5002: PA_OBJECT_RELATIONSHIPS_PKG.INSERT_ROW(
5003: p_user_id => FND_GLOBAL.USER_ID
5004: ,p_object_type_from => 'PA_TASKS'
5005: ,p_object_id_from1 => l_new_pub_lnk_task_ver_id
5006: ,p_object_id_from2 => get_going_out_lnk_info_rec.object_id_from2

Line 5039: pa_debug.debug('Value of x_return_status after call to PA_OBJECT_RELATIONSHIPS_PKG INSERT_ROW=> '||x_return_status);

5035:
5036: IF (p_debug_mode = 'Y') THEN
5037: pa_debug.debug('Value of x_object_relationship_id=> '||l_object_relationship_id);
5038: pa_debug.debug('Value of l_new_pub_lnk_task_ver_id=> '||l_new_pub_lnk_task_ver_id);
5039: pa_debug.debug('Value of x_return_status after call to PA_OBJECT_RELATIONSHIPS_PKG INSERT_ROW=> '||x_return_status);
5040: END IF;
5041: --
5042: --Bug No 3450684
5043: BEGIN

Line 5253: PA_OBJECT_RELATIONSHIPS_PKG.INSERT_ROW(

5249: END IF;
5250: --For Task
5251: IF l_move_link_fl='Y' THEN
5252: x_object_relationship_id := NULL;
5253: PA_OBJECT_RELATIONSHIPS_PKG.INSERT_ROW(
5254: p_user_id => FND_GLOBAL.USER_ID
5255: ,p_object_type_from => 'PA_TASKS'
5256: ,p_object_id_from1 => get_coming_in_lnk_info_rec.object_id_from1
5257: ,p_object_id_from2 => get_coming_in_lnk_info_rec.object_id_from2

Line 5356: PA_OBJECT_RELATIONSHIPS_PKG.DELETE_ROW(

5352: p_error_text => SUBSTRB('PA_RELATIONSHIP_PUB.UPDATE_PROGRAM_GROUPS:'||SQLERRM,1,240));
5353: RAISE FND_API.G_EXC_ERROR;
5354: END;
5355: --
5356: PA_OBJECT_RELATIONSHIPS_PKG.DELETE_ROW(
5357: p_object_relationship_id => get_coming_in_lnk_info_rec.object_relationship_id
5358: ,p_object_type_from => NULL
5359: ,p_object_id_from1 => NULL
5360: ,p_object_id_from2 => NULL