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 2099: -- as is the case from the PA_TASK_PUB1.COPY_TASK() API, then we use the cursor get_dependency3 to

2095: -- passed into this API along with their destination task versions. The cursor get_dependency2
2096: -- is used to create the same dependencies among the dest_task_ver_ids as exists among
2097: -- the src_task_ver_ids.
2098: -- If only some src_task_ver_id and their corresponding dest_task_ver_id are passed into this API
2099: -- as is the case from the PA_TASK_PUB1.COPY_TASK() API, then we use the cursor get_dependency3 to
2100: -- get all the dependencies for each src_task_ver_id and create the same for the corresponding
2101: -- dest_task_ver_id.
2102:
2103: --debug messages added while fixing bug 5067296

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

3064: END IF;
3065: --
3066: IF (p_debug_mode = 'Y') THEN
3067: pa_debug.debug('Performing validations');
3068: pa_debug.debug('PA_TASK_PUB1.CREATE_TASK Src Proj Id => '||p_src_proj_id);
3069: pa_debug.debug('PA_TASK_PUB1.CREATE_TASK Src Structure Elem Id=> '||p_src_struc_elem_id);
3070: pa_debug.debug('PA_TASK_PUB1.CREATE_TASK Src Structure Elem Ver Id => '||p_src_struc_elem_ver_id);
3071: pa_debug.debug('Before PA_TASK_PUB1.CREATE_TASK Linking Task Name Number => '||p_lnk_task_name_number);
3072: END IF;

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

3065: --
3066: IF (p_debug_mode = 'Y') THEN
3067: pa_debug.debug('Performing validations');
3068: pa_debug.debug('PA_TASK_PUB1.CREATE_TASK Src Proj Id => '||p_src_proj_id);
3069: pa_debug.debug('PA_TASK_PUB1.CREATE_TASK Src Structure Elem Id=> '||p_src_struc_elem_id);
3070: pa_debug.debug('PA_TASK_PUB1.CREATE_TASK Src Structure Elem Ver Id => '||p_src_struc_elem_ver_id);
3071: pa_debug.debug('Before PA_TASK_PUB1.CREATE_TASK Linking Task Name Number => '||p_lnk_task_name_number);
3072: END IF;
3073: --

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

3066: IF (p_debug_mode = 'Y') THEN
3067: pa_debug.debug('Performing validations');
3068: pa_debug.debug('PA_TASK_PUB1.CREATE_TASK Src Proj Id => '||p_src_proj_id);
3069: pa_debug.debug('PA_TASK_PUB1.CREATE_TASK Src Structure Elem Id=> '||p_src_struc_elem_id);
3070: pa_debug.debug('PA_TASK_PUB1.CREATE_TASK Src Structure Elem Ver Id => '||p_src_struc_elem_ver_id);
3071: pa_debug.debug('Before PA_TASK_PUB1.CREATE_TASK Linking Task Name Number => '||p_lnk_task_name_number);
3072: END IF;
3073: --
3074: /* Creating linking task in the pa_proj_elements table*/

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

3067: pa_debug.debug('Performing validations');
3068: pa_debug.debug('PA_TASK_PUB1.CREATE_TASK Src Proj Id => '||p_src_proj_id);
3069: pa_debug.debug('PA_TASK_PUB1.CREATE_TASK Src Structure Elem Id=> '||p_src_struc_elem_id);
3070: pa_debug.debug('PA_TASK_PUB1.CREATE_TASK Src Structure Elem Ver Id => '||p_src_struc_elem_ver_id);
3071: pa_debug.debug('Before PA_TASK_PUB1.CREATE_TASK Linking Task Name Number => '||p_lnk_task_name_number);
3072: END IF;
3073: --
3074: /* Creating linking task in the pa_proj_elements table*/
3075: PA_TASK_PUB1.CREATE_TASK

Line 3075: PA_TASK_PUB1.CREATE_TASK

3071: pa_debug.debug('Before PA_TASK_PUB1.CREATE_TASK Linking Task Name Number => '||p_lnk_task_name_number);
3072: END IF;
3073: --
3074: /* Creating linking task in the pa_proj_elements table*/
3075: PA_TASK_PUB1.CREATE_TASK
3076: ( p_validate_only => FND_API.G_FALSE
3077: ,p_object_type => 'PA_TASKS'
3078: ,p_project_id => p_src_proj_id
3079: ,p_structure_id => p_src_struc_elem_id --Proj_element_id of the parent structure

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

3114: x_return_status:=FND_API.G_RET_STS_ERROR;
3115: END IF;
3116: --
3117: IF (p_debug_mode = 'Y') THEN
3118: pa_debug.debug('After Call To PA_TASK_PUB1.CREATE_TASK Return Status => '||x_return_status);
3119: pa_debug.debug('After Call To PA_TASK_PUB1.CREATE_TASK => '||x_lnk_task_elem_id);
3120: pa_debug.debug('PA_TASK_PUB1.CREATE_TASK_VERSION Src Structure Elem Id=> '||p_src_task_elem_ver_id);
3121: pa_debug.debug('PA_TASK_PUB1.CREATE_TASK_VERSION Linking Task Elem Id => '||x_lnk_task_elem_id);
3122: END IF;

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

3115: END IF;
3116: --
3117: IF (p_debug_mode = 'Y') THEN
3118: pa_debug.debug('After Call To PA_TASK_PUB1.CREATE_TASK Return Status => '||x_return_status);
3119: pa_debug.debug('After Call To PA_TASK_PUB1.CREATE_TASK => '||x_lnk_task_elem_id);
3120: pa_debug.debug('PA_TASK_PUB1.CREATE_TASK_VERSION Src Structure Elem Id=> '||p_src_task_elem_ver_id);
3121: pa_debug.debug('PA_TASK_PUB1.CREATE_TASK_VERSION Linking Task Elem Id => '||x_lnk_task_elem_id);
3122: END IF;
3123: --

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

3116: --
3117: IF (p_debug_mode = 'Y') THEN
3118: pa_debug.debug('After Call To PA_TASK_PUB1.CREATE_TASK Return Status => '||x_return_status);
3119: pa_debug.debug('After Call To PA_TASK_PUB1.CREATE_TASK => '||x_lnk_task_elem_id);
3120: pa_debug.debug('PA_TASK_PUB1.CREATE_TASK_VERSION Src Structure Elem Id=> '||p_src_task_elem_ver_id);
3121: pa_debug.debug('PA_TASK_PUB1.CREATE_TASK_VERSION Linking Task Elem Id => '||x_lnk_task_elem_id);
3122: END IF;
3123: --
3124: /* Creating linking task in the pa_proj_element_versions and pa_object_relationships table */

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

3117: IF (p_debug_mode = 'Y') THEN
3118: pa_debug.debug('After Call To PA_TASK_PUB1.CREATE_TASK Return Status => '||x_return_status);
3119: pa_debug.debug('After Call To PA_TASK_PUB1.CREATE_TASK => '||x_lnk_task_elem_id);
3120: pa_debug.debug('PA_TASK_PUB1.CREATE_TASK_VERSION Src Structure Elem Id=> '||p_src_task_elem_ver_id);
3121: pa_debug.debug('PA_TASK_PUB1.CREATE_TASK_VERSION Linking Task Elem Id => '||x_lnk_task_elem_id);
3122: END IF;
3123: --
3124: /* Creating linking task in the pa_proj_element_versions and pa_object_relationships table */
3125: /* This API call create task in pa_proj_element_versions and creates relationship between */

Line 3127: PA_TASK_PUB1.CREATE_TASK_VERSION

3123: --
3124: /* Creating linking task in the pa_proj_element_versions and pa_object_relationships table */
3125: /* This API call create task in pa_proj_element_versions and creates relationship between */
3126: /* linking task and its parent task in the pa_object_relationships table */
3127: PA_TASK_PUB1.CREATE_TASK_VERSION
3128: ( p_validate_only => FND_API.G_FALSE
3129: ,p_validation_level => 0
3130: ,p_ref_task_version_id => p_src_task_elem_ver_id
3131: ,p_peer_or_sub => 'SUB'

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

3149: RAISE FND_API.G_EXC_ERROR;
3150: END IF;
3151: --
3152: IF (p_debug_mode = 'Y') THEN
3153: pa_debug.debug('After Call To PA_TASK_PUB1.CREATE_TASK_VERSION Return Status => '||x_return_status);
3154: pa_debug.debug('After Call To PA_TASK_PUB1.CREATE_TASK_VERSION Linking Task Elem Id => '||x_lnk_task_elem_id);
3155: pa_debug.debug('After Call To PA_TASK_PUB1.CREATE_TASK_VERSION Linking Task Elem Ver Id=> '||x_lnk_task_elem_ver_id);
3156: pa_debug.debug('PA_TASK_PUB1.Create_Schedule_Version Linking Task Elem Ver Id=> '||x_lnk_task_elem_ver_id);
3157: END IF;

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

3150: END IF;
3151: --
3152: IF (p_debug_mode = 'Y') THEN
3153: pa_debug.debug('After Call To PA_TASK_PUB1.CREATE_TASK_VERSION Return Status => '||x_return_status);
3154: pa_debug.debug('After Call To PA_TASK_PUB1.CREATE_TASK_VERSION Linking Task Elem Id => '||x_lnk_task_elem_id);
3155: pa_debug.debug('After Call To PA_TASK_PUB1.CREATE_TASK_VERSION Linking Task Elem Ver Id=> '||x_lnk_task_elem_ver_id);
3156: pa_debug.debug('PA_TASK_PUB1.Create_Schedule_Version Linking Task Elem Ver Id=> '||x_lnk_task_elem_ver_id);
3157: END IF;
3158: --

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

3151: --
3152: IF (p_debug_mode = 'Y') THEN
3153: pa_debug.debug('After Call To PA_TASK_PUB1.CREATE_TASK_VERSION Return Status => '||x_return_status);
3154: pa_debug.debug('After Call To PA_TASK_PUB1.CREATE_TASK_VERSION Linking Task Elem Id => '||x_lnk_task_elem_id);
3155: pa_debug.debug('After Call To PA_TASK_PUB1.CREATE_TASK_VERSION Linking Task Elem Ver Id=> '||x_lnk_task_elem_ver_id);
3156: pa_debug.debug('PA_TASK_PUB1.Create_Schedule_Version Linking Task Elem Ver Id=> '||x_lnk_task_elem_ver_id);
3157: END IF;
3158: --
3159: --bug 4279634

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

3152: IF (p_debug_mode = 'Y') THEN
3153: pa_debug.debug('After Call To PA_TASK_PUB1.CREATE_TASK_VERSION Return Status => '||x_return_status);
3154: pa_debug.debug('After Call To PA_TASK_PUB1.CREATE_TASK_VERSION Linking Task Elem Id => '||x_lnk_task_elem_id);
3155: pa_debug.debug('After Call To PA_TASK_PUB1.CREATE_TASK_VERSION Linking Task Elem Ver Id=> '||x_lnk_task_elem_ver_id);
3156: pa_debug.debug('PA_TASK_PUB1.Create_Schedule_Version Linking Task Elem Ver Id=> '||x_lnk_task_elem_ver_id);
3157: END IF;
3158: --
3159: --bug 4279634
3160: --set chargeable to N

Line 3216: PA_TASK_PUB1.Create_Schedule_Version

3212: --end bug 4279634
3213:
3214: /* Create recrod into work pa_proj_elem_ver_schedule table for workplan structure only*/
3215: IF p_src_struc_wp_or_fin = 'WORKPLAN' THEN
3216: PA_TASK_PUB1.Create_Schedule_Version
3217: ( p_validate_only =>FND_API.G_FALSE
3218: ,p_element_version_id =>x_lnk_task_elem_ver_id --task version of linking task
3219: ,p_scheduled_start_date =>l_scheduled_start_date
3220: ,p_scheduled_end_date =>l_scheduled_finish_date

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

3223: ,x_msg_count =>x_msg_count
3224: ,x_msg_data =>x_msg_data
3225: );
3226: IF (p_debug_mode = 'Y') THEN
3227: pa_debug.debug('new workplan attr for task after call to PA_TASK_PUB1.Create_Schedule_Version=> '||x_pev_schedule_id);
3228: END IF;
3229: --
3230: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
3231: x_msg_count := FND_MSG_PUB.count_msg;

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

3243: END IF;
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);

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

4704: x_msg_data := 'PA_NO_RECORD_VERSION_NUMBER';
4705: RAISE FND_API.G_EXC_ERROR;
4706: END IF;
4707: --
4708: PA_TASK_PUB1.DELETE_TASK_VERSION(p_commit => 'N',
4709: p_debug_mode => p_debug_mode,
4710: p_task_version_id => get_lnk_info_rec.lnk_task_ver_id,
4711: p_record_version_number => get_rec_ver_num_rec.record_version_number,
4712: x_return_status => x_return_status,

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

4728: raise FND_API.G_EXC_ERROR;
4729: END IF;
4730: --
4731: IF (p_debug_mode = 'Y') THEN
4732: pa_debug.debug('Return status after call to PA_TASK_PUB1.DELETE_TASK_VERSION=> '||x_return_status);
4733: END IF;
4734: --
4735: CLOSE get_rec_ver_num;
4736: END LOOP;