DBA Data[Home] [Help]

APPS.PA_RELATIONSHIP_PVT dependencies on PA_TASK_PUB1

Line 365: PA_TASK_PUB1.CREATE_TASK

361: CLOSE Get_Parent_Struc_Ver_Id;
362:
363: --need to create a task under the from side.
364: --dbms_output.put_line('Pid = '||p_project_id_from||', l_struc_id = '||l_structure_id||', l_element_id = '||l_element_id||'number(name) = '||substr(l_task_name_number,0,25)||'('||substr(l_task_name_number,0,240)||')');
365: PA_TASK_PUB1.CREATE_TASK
366: ( p_validate_only => FND_API.G_FALSE
367: ,p_object_type => 'PA_TASKS'
368: ,p_project_id => p_project_id_from
369: ,p_structure_id => l_structure_id

Line 412: PA_TASK_PUB1.CREATE_TASK_VERSION

408: If (p_debug_mode = 'Y') THEN
409: pa_debug.debug('Create peer or sub => '||l_peer_or_sub);
410: END IF;
411:
412: PA_TASK_PUB1.CREATE_TASK_VERSION
413: ( p_validate_only => FND_API.G_FALSE
414: ,p_ref_task_version_id => l_id_from
415: ,p_peer_or_sub => l_peer_or_sub
416: ,p_task_id => l_task_id

Line 444: PA_TASK_PUB1.CREATE_SCHEDULE_VERSION

440: RAISE FND_API.G_EXC_ERROR;
441: end if;
442:
443: if PA_PROJECT_STRUCTURE_UTILS.GET_STRUC_TYPE_FOR_VERSION(p_structure_version_id_from, 'WORKPLAN') = 'Y' then
444: PA_TASK_PUB1.CREATE_SCHEDULE_VERSION
445: ( p_validate_only => FND_API.G_FALSE
446: ,p_element_version_id => l_task_version_id
447: ,p_scheduled_start_date => l_scheduled_start_date
448: ,p_scheduled_end_date => l_scheduled_finish_date

Line 969: PA_TASK_PUB1.DELETE_TASK_VERSION(p_commit => 'N',

965: into l_task_version_rvn
966: from pa_proj_element_versions
967: where element_version_id = l_link_task_ver.object_id_from1;
968:
969: PA_TASK_PUB1.DELETE_TASK_VERSION(p_commit => 'N',
970: p_debug_mode => p_debug_mode,
971: p_task_version_id => l_link_task_ver.object_id_from1,
972: p_record_version_number => l_task_version_rvn,
973: x_return_status => l_return_status,

Line 2091: -- as is the case from the PA_TASK_PUB1.COPY_TASK() API, then we use the cursor get_dependency3 to

2087: -- passed into this API along with their destination task versions. The cursor get_dependency2
2088: -- is used to create the same dependencies among the dest_task_ver_ids as exists among
2089: -- the src_task_ver_ids.
2090: -- If only some src_task_ver_id and their corresponding dest_task_ver_id are passed into this API
2091: -- as is the case from the PA_TASK_PUB1.COPY_TASK() API, then we use the cursor get_dependency3 to
2092: -- get all the dependencies for each src_task_ver_id and create the same for the corresponding
2093: -- dest_task_ver_id.
2094:
2095: --debug messages added while fixing bug 5067296

Line 3056: pa_debug.debug('PA_TASK_PUB1.CREATE_TASK Src Proj Id => '||p_src_proj_id);

3052: END IF;
3053: --
3054: IF (p_debug_mode = 'Y') THEN
3055: pa_debug.debug('Performing validations');
3056: pa_debug.debug('PA_TASK_PUB1.CREATE_TASK Src Proj Id => '||p_src_proj_id);
3057: pa_debug.debug('PA_TASK_PUB1.CREATE_TASK Src Structure Elem Id=> '||p_src_struc_elem_id);
3058: pa_debug.debug('PA_TASK_PUB1.CREATE_TASK Src Structure Elem Ver Id => '||p_src_struc_elem_ver_id);
3059: pa_debug.debug('Before PA_TASK_PUB1.CREATE_TASK Linking Task Name Number => '||p_lnk_task_name_number);
3060: END IF;

Line 3057: pa_debug.debug('PA_TASK_PUB1.CREATE_TASK Src Structure Elem Id=> '||p_src_struc_elem_id);

3053: --
3054: IF (p_debug_mode = 'Y') THEN
3055: pa_debug.debug('Performing validations');
3056: pa_debug.debug('PA_TASK_PUB1.CREATE_TASK Src Proj Id => '||p_src_proj_id);
3057: pa_debug.debug('PA_TASK_PUB1.CREATE_TASK Src Structure Elem Id=> '||p_src_struc_elem_id);
3058: pa_debug.debug('PA_TASK_PUB1.CREATE_TASK Src Structure Elem Ver Id => '||p_src_struc_elem_ver_id);
3059: pa_debug.debug('Before PA_TASK_PUB1.CREATE_TASK Linking Task Name Number => '||p_lnk_task_name_number);
3060: END IF;
3061: --

Line 3058: pa_debug.debug('PA_TASK_PUB1.CREATE_TASK Src Structure Elem Ver Id => '||p_src_struc_elem_ver_id);

3054: IF (p_debug_mode = 'Y') THEN
3055: pa_debug.debug('Performing validations');
3056: pa_debug.debug('PA_TASK_PUB1.CREATE_TASK Src Proj Id => '||p_src_proj_id);
3057: pa_debug.debug('PA_TASK_PUB1.CREATE_TASK Src Structure Elem Id=> '||p_src_struc_elem_id);
3058: pa_debug.debug('PA_TASK_PUB1.CREATE_TASK Src Structure Elem Ver Id => '||p_src_struc_elem_ver_id);
3059: pa_debug.debug('Before PA_TASK_PUB1.CREATE_TASK Linking Task Name Number => '||p_lnk_task_name_number);
3060: END IF;
3061: --
3062: /* Creating linking task in the pa_proj_elements table*/

Line 3059: pa_debug.debug('Before PA_TASK_PUB1.CREATE_TASK Linking Task Name Number => '||p_lnk_task_name_number);

3055: pa_debug.debug('Performing validations');
3056: pa_debug.debug('PA_TASK_PUB1.CREATE_TASK Src Proj Id => '||p_src_proj_id);
3057: pa_debug.debug('PA_TASK_PUB1.CREATE_TASK Src Structure Elem Id=> '||p_src_struc_elem_id);
3058: pa_debug.debug('PA_TASK_PUB1.CREATE_TASK Src Structure Elem Ver Id => '||p_src_struc_elem_ver_id);
3059: pa_debug.debug('Before PA_TASK_PUB1.CREATE_TASK Linking Task Name Number => '||p_lnk_task_name_number);
3060: END IF;
3061: --
3062: /* Creating linking task in the pa_proj_elements table*/
3063: PA_TASK_PUB1.CREATE_TASK

Line 3063: PA_TASK_PUB1.CREATE_TASK

3059: pa_debug.debug('Before PA_TASK_PUB1.CREATE_TASK Linking Task Name Number => '||p_lnk_task_name_number);
3060: END IF;
3061: --
3062: /* Creating linking task in the pa_proj_elements table*/
3063: PA_TASK_PUB1.CREATE_TASK
3064: ( p_validate_only => FND_API.G_FALSE
3065: ,p_object_type => 'PA_TASKS'
3066: ,p_project_id => p_src_proj_id
3067: ,p_structure_id => p_src_struc_elem_id --Proj_element_id of the parent structure

Line 3105: pa_debug.debug('After Call To PA_TASK_PUB1.CREATE_TASK Return Status => '||x_return_status);

3101: x_return_status:=FND_API.G_RET_STS_ERROR;
3102: END IF;
3103: --
3104: IF (p_debug_mode = 'Y') THEN
3105: pa_debug.debug('After Call To PA_TASK_PUB1.CREATE_TASK Return Status => '||x_return_status);
3106: pa_debug.debug('After Call To PA_TASK_PUB1.CREATE_TASK => '||x_lnk_task_elem_id);
3107: pa_debug.debug('PA_TASK_PUB1.CREATE_TASK_VERSION Src Structure Elem Id=> '||p_src_task_elem_ver_id);
3108: pa_debug.debug('PA_TASK_PUB1.CREATE_TASK_VERSION Linking Task Elem Id => '||x_lnk_task_elem_id);
3109: END IF;

Line 3106: pa_debug.debug('After Call To PA_TASK_PUB1.CREATE_TASK => '||x_lnk_task_elem_id);

3102: END IF;
3103: --
3104: IF (p_debug_mode = 'Y') THEN
3105: pa_debug.debug('After Call To PA_TASK_PUB1.CREATE_TASK Return Status => '||x_return_status);
3106: pa_debug.debug('After Call To PA_TASK_PUB1.CREATE_TASK => '||x_lnk_task_elem_id);
3107: pa_debug.debug('PA_TASK_PUB1.CREATE_TASK_VERSION Src Structure Elem Id=> '||p_src_task_elem_ver_id);
3108: pa_debug.debug('PA_TASK_PUB1.CREATE_TASK_VERSION Linking Task Elem Id => '||x_lnk_task_elem_id);
3109: END IF;
3110: --

Line 3107: pa_debug.debug('PA_TASK_PUB1.CREATE_TASK_VERSION Src Structure Elem Id=> '||p_src_task_elem_ver_id);

3103: --
3104: IF (p_debug_mode = 'Y') THEN
3105: pa_debug.debug('After Call To PA_TASK_PUB1.CREATE_TASK Return Status => '||x_return_status);
3106: pa_debug.debug('After Call To PA_TASK_PUB1.CREATE_TASK => '||x_lnk_task_elem_id);
3107: pa_debug.debug('PA_TASK_PUB1.CREATE_TASK_VERSION Src Structure Elem Id=> '||p_src_task_elem_ver_id);
3108: pa_debug.debug('PA_TASK_PUB1.CREATE_TASK_VERSION Linking Task Elem Id => '||x_lnk_task_elem_id);
3109: END IF;
3110: --
3111: /* Creating linking task in the pa_proj_element_versions and pa_object_relationships table */

Line 3108: pa_debug.debug('PA_TASK_PUB1.CREATE_TASK_VERSION Linking Task Elem Id => '||x_lnk_task_elem_id);

3104: IF (p_debug_mode = 'Y') THEN
3105: pa_debug.debug('After Call To PA_TASK_PUB1.CREATE_TASK Return Status => '||x_return_status);
3106: pa_debug.debug('After Call To PA_TASK_PUB1.CREATE_TASK => '||x_lnk_task_elem_id);
3107: pa_debug.debug('PA_TASK_PUB1.CREATE_TASK_VERSION Src Structure Elem Id=> '||p_src_task_elem_ver_id);
3108: pa_debug.debug('PA_TASK_PUB1.CREATE_TASK_VERSION Linking Task Elem Id => '||x_lnk_task_elem_id);
3109: END IF;
3110: --
3111: /* Creating linking task in the pa_proj_element_versions and pa_object_relationships table */
3112: /* This API call create task in pa_proj_element_versions and creates relationship between */

Line 3114: PA_TASK_PUB1.CREATE_TASK_VERSION

3110: --
3111: /* Creating linking task in the pa_proj_element_versions and pa_object_relationships table */
3112: /* This API call create task in pa_proj_element_versions and creates relationship between */
3113: /* linking task and its parent task in the pa_object_relationships table */
3114: PA_TASK_PUB1.CREATE_TASK_VERSION
3115: ( p_validate_only => FND_API.G_FALSE
3116: ,p_validation_level => 0
3117: ,p_ref_task_version_id => p_src_task_elem_ver_id
3118: ,p_peer_or_sub => 'SUB'

Line 3140: pa_debug.debug('After Call To PA_TASK_PUB1.CREATE_TASK_VERSION Return Status => '||x_return_status);

3136: RAISE FND_API.G_EXC_ERROR;
3137: END IF;
3138: --
3139: IF (p_debug_mode = 'Y') THEN
3140: pa_debug.debug('After Call To PA_TASK_PUB1.CREATE_TASK_VERSION Return Status => '||x_return_status);
3141: pa_debug.debug('After Call To PA_TASK_PUB1.CREATE_TASK_VERSION Linking Task Elem Id => '||x_lnk_task_elem_id);
3142: pa_debug.debug('After Call To PA_TASK_PUB1.CREATE_TASK_VERSION Linking Task Elem Ver Id=> '||x_lnk_task_elem_ver_id);
3143: pa_debug.debug('PA_TASK_PUB1.Create_Schedule_Version Linking Task Elem Ver Id=> '||x_lnk_task_elem_ver_id);
3144: END IF;

Line 3141: pa_debug.debug('After Call To PA_TASK_PUB1.CREATE_TASK_VERSION Linking Task Elem Id => '||x_lnk_task_elem_id);

3137: END IF;
3138: --
3139: IF (p_debug_mode = 'Y') THEN
3140: pa_debug.debug('After Call To PA_TASK_PUB1.CREATE_TASK_VERSION Return Status => '||x_return_status);
3141: pa_debug.debug('After Call To PA_TASK_PUB1.CREATE_TASK_VERSION Linking Task Elem Id => '||x_lnk_task_elem_id);
3142: pa_debug.debug('After Call To PA_TASK_PUB1.CREATE_TASK_VERSION Linking Task Elem Ver Id=> '||x_lnk_task_elem_ver_id);
3143: pa_debug.debug('PA_TASK_PUB1.Create_Schedule_Version Linking Task Elem Ver Id=> '||x_lnk_task_elem_ver_id);
3144: END IF;
3145: --

Line 3142: pa_debug.debug('After Call To PA_TASK_PUB1.CREATE_TASK_VERSION Linking Task Elem Ver Id=> '||x_lnk_task_elem_ver_id);

3138: --
3139: IF (p_debug_mode = 'Y') THEN
3140: pa_debug.debug('After Call To PA_TASK_PUB1.CREATE_TASK_VERSION Return Status => '||x_return_status);
3141: pa_debug.debug('After Call To PA_TASK_PUB1.CREATE_TASK_VERSION Linking Task Elem Id => '||x_lnk_task_elem_id);
3142: pa_debug.debug('After Call To PA_TASK_PUB1.CREATE_TASK_VERSION Linking Task Elem Ver Id=> '||x_lnk_task_elem_ver_id);
3143: pa_debug.debug('PA_TASK_PUB1.Create_Schedule_Version Linking Task Elem Ver Id=> '||x_lnk_task_elem_ver_id);
3144: END IF;
3145: --
3146: --bug 4279634

Line 3143: pa_debug.debug('PA_TASK_PUB1.Create_Schedule_Version Linking Task Elem Ver Id=> '||x_lnk_task_elem_ver_id);

3139: IF (p_debug_mode = 'Y') THEN
3140: pa_debug.debug('After Call To PA_TASK_PUB1.CREATE_TASK_VERSION Return Status => '||x_return_status);
3141: pa_debug.debug('After Call To PA_TASK_PUB1.CREATE_TASK_VERSION Linking Task Elem Id => '||x_lnk_task_elem_id);
3142: pa_debug.debug('After Call To PA_TASK_PUB1.CREATE_TASK_VERSION Linking Task Elem Ver Id=> '||x_lnk_task_elem_ver_id);
3143: pa_debug.debug('PA_TASK_PUB1.Create_Schedule_Version Linking Task Elem Ver Id=> '||x_lnk_task_elem_ver_id);
3144: END IF;
3145: --
3146: --bug 4279634
3147: --set chargeable to N

Line 3203: PA_TASK_PUB1.Create_Schedule_Version

3199: --end bug 4279634
3200:
3201: /* Create recrod into work pa_proj_elem_ver_schedule table for workplan structure only*/
3202: IF p_src_struc_wp_or_fin = 'WORKPLAN' THEN
3203: PA_TASK_PUB1.Create_Schedule_Version
3204: ( p_validate_only =>FND_API.G_FALSE
3205: ,p_element_version_id =>x_lnk_task_elem_ver_id --task version of linking task
3206: ,p_scheduled_start_date =>l_scheduled_start_date
3207: ,p_scheduled_end_date =>l_scheduled_finish_date

Line 3214: pa_debug.debug('new workplan attr for task after call to PA_TASK_PUB1.Create_Schedule_Version=> '||x_pev_schedule_id);

3210: ,x_msg_count =>x_msg_count
3211: ,x_msg_data =>x_msg_data
3212: );
3213: IF (p_debug_mode = 'Y') THEN
3214: pa_debug.debug('new workplan attr for task after call to PA_TASK_PUB1.Create_Schedule_Version=> '||x_pev_schedule_id);
3215: END IF;
3216: --
3217: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
3218: x_msg_count := FND_MSG_PUB.count_msg;

Line 3234: pa_debug.debug('After Call To PA_TASK_PUB1.Create_Schedule_Version Return Status => '||x_return_status);

3230: END IF;
3231: END IF;
3232: --
3233: IF (p_debug_mode = 'Y') THEN
3234: pa_debug.debug('After Call To PA_TASK_PUB1.Create_Schedule_Version Return Status => '||x_return_status);
3235: pa_debug.debug('PA_OBJECT_RELATIONSHIPS_PKG.INSERT_ROW Linking Task Elem Ver Id => '||x_lnk_task_elem_ver_id);
3236: pa_debug.debug('PA_OBJECT_RELATIONSHIPS_PKG.INSERT_ROW Src Proj Id=> '||p_src_proj_id);
3237: pa_debug.debug('PA_OBJECT_RELATIONSHIPS_PKG.INSERT_ROW Dest Struc Elem Ver Id=> '||p_dest_struc_elem_ver_id);
3238: pa_debug.debug('PA_OBJECT_RELATIONSHIPS_PKG.INSERT_ROW Dest Proj Id=> '||p_dest_proj_id);

Line 4690: PA_TASK_PUB1.DELETE_TASK_VERSION(p_commit => 'N',

4686: x_msg_data := 'PA_NO_RECORD_VERSION_NUMBER';
4687: RAISE FND_API.G_EXC_ERROR;
4688: END IF;
4689: --
4690: PA_TASK_PUB1.DELETE_TASK_VERSION(p_commit => 'N',
4691: p_debug_mode => p_debug_mode,
4692: p_task_version_id => get_lnk_info_rec.lnk_task_ver_id,
4693: p_record_version_number => get_rec_ver_num_rec.record_version_number,
4694: x_return_status => x_return_status,

Line 4714: pa_debug.debug('Return status after call to PA_TASK_PUB1.DELETE_TASK_VERSION=> '||x_return_status);

4710: raise FND_API.G_EXC_ERROR;
4711: END IF;
4712: --
4713: IF (p_debug_mode = 'Y') THEN
4714: pa_debug.debug('Return status after call to PA_TASK_PUB1.DELETE_TASK_VERSION=> '||x_return_status);
4715: END IF;
4716: --
4717: CLOSE get_rec_ver_num;
4718: END LOOP;