eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PA_TASK_PVT1 dependencies on PA_TASKS

Line 224: l_tk_attribute_category pa_tasks.attribute_category%TYPE;

220:
221: X_ROW_ID VARCHAR2(255);
222:
223: -- xxlu added task DFF attributes
224: l_tk_attribute_category pa_tasks.attribute_category%TYPE;
225: l_tk_attribute1 pa_tasks.attribute1%TYPE;
226: l_tk_attribute2 pa_tasks.attribute2%TYPE;
227: l_tk_attribute3 pa_tasks.attribute3%TYPE;
228: l_tk_attribute4 pa_tasks.attribute4%TYPE;

Line 225: l_tk_attribute1 pa_tasks.attribute1%TYPE;

221: X_ROW_ID VARCHAR2(255);
222:
223: -- xxlu added task DFF attributes
224: l_tk_attribute_category pa_tasks.attribute_category%TYPE;
225: l_tk_attribute1 pa_tasks.attribute1%TYPE;
226: l_tk_attribute2 pa_tasks.attribute2%TYPE;
227: l_tk_attribute3 pa_tasks.attribute3%TYPE;
228: l_tk_attribute4 pa_tasks.attribute4%TYPE;
229: l_tk_attribute5 pa_tasks.attribute5%TYPE;

Line 226: l_tk_attribute2 pa_tasks.attribute2%TYPE;

222:
223: -- xxlu added task DFF attributes
224: l_tk_attribute_category pa_tasks.attribute_category%TYPE;
225: l_tk_attribute1 pa_tasks.attribute1%TYPE;
226: l_tk_attribute2 pa_tasks.attribute2%TYPE;
227: l_tk_attribute3 pa_tasks.attribute3%TYPE;
228: l_tk_attribute4 pa_tasks.attribute4%TYPE;
229: l_tk_attribute5 pa_tasks.attribute5%TYPE;
230: l_tk_attribute6 pa_tasks.attribute6%TYPE;

Line 227: l_tk_attribute3 pa_tasks.attribute3%TYPE;

223: -- xxlu added task DFF attributes
224: l_tk_attribute_category pa_tasks.attribute_category%TYPE;
225: l_tk_attribute1 pa_tasks.attribute1%TYPE;
226: l_tk_attribute2 pa_tasks.attribute2%TYPE;
227: l_tk_attribute3 pa_tasks.attribute3%TYPE;
228: l_tk_attribute4 pa_tasks.attribute4%TYPE;
229: l_tk_attribute5 pa_tasks.attribute5%TYPE;
230: l_tk_attribute6 pa_tasks.attribute6%TYPE;
231: l_tk_attribute7 pa_tasks.attribute7%TYPE;

Line 228: l_tk_attribute4 pa_tasks.attribute4%TYPE;

224: l_tk_attribute_category pa_tasks.attribute_category%TYPE;
225: l_tk_attribute1 pa_tasks.attribute1%TYPE;
226: l_tk_attribute2 pa_tasks.attribute2%TYPE;
227: l_tk_attribute3 pa_tasks.attribute3%TYPE;
228: l_tk_attribute4 pa_tasks.attribute4%TYPE;
229: l_tk_attribute5 pa_tasks.attribute5%TYPE;
230: l_tk_attribute6 pa_tasks.attribute6%TYPE;
231: l_tk_attribute7 pa_tasks.attribute7%TYPE;
232: l_tk_attribute8 pa_tasks.attribute8%TYPE;

Line 229: l_tk_attribute5 pa_tasks.attribute5%TYPE;

225: l_tk_attribute1 pa_tasks.attribute1%TYPE;
226: l_tk_attribute2 pa_tasks.attribute2%TYPE;
227: l_tk_attribute3 pa_tasks.attribute3%TYPE;
228: l_tk_attribute4 pa_tasks.attribute4%TYPE;
229: l_tk_attribute5 pa_tasks.attribute5%TYPE;
230: l_tk_attribute6 pa_tasks.attribute6%TYPE;
231: l_tk_attribute7 pa_tasks.attribute7%TYPE;
232: l_tk_attribute8 pa_tasks.attribute8%TYPE;
233: l_tk_attribute9 pa_tasks.attribute9%TYPE;

Line 230: l_tk_attribute6 pa_tasks.attribute6%TYPE;

226: l_tk_attribute2 pa_tasks.attribute2%TYPE;
227: l_tk_attribute3 pa_tasks.attribute3%TYPE;
228: l_tk_attribute4 pa_tasks.attribute4%TYPE;
229: l_tk_attribute5 pa_tasks.attribute5%TYPE;
230: l_tk_attribute6 pa_tasks.attribute6%TYPE;
231: l_tk_attribute7 pa_tasks.attribute7%TYPE;
232: l_tk_attribute8 pa_tasks.attribute8%TYPE;
233: l_tk_attribute9 pa_tasks.attribute9%TYPE;
234: l_tk_attribute10 pa_tasks.attribute10%TYPE;

Line 231: l_tk_attribute7 pa_tasks.attribute7%TYPE;

227: l_tk_attribute3 pa_tasks.attribute3%TYPE;
228: l_tk_attribute4 pa_tasks.attribute4%TYPE;
229: l_tk_attribute5 pa_tasks.attribute5%TYPE;
230: l_tk_attribute6 pa_tasks.attribute6%TYPE;
231: l_tk_attribute7 pa_tasks.attribute7%TYPE;
232: l_tk_attribute8 pa_tasks.attribute8%TYPE;
233: l_tk_attribute9 pa_tasks.attribute9%TYPE;
234: l_tk_attribute10 pa_tasks.attribute10%TYPE;
235: -- end xxlu changes

Line 232: l_tk_attribute8 pa_tasks.attribute8%TYPE;

228: l_tk_attribute4 pa_tasks.attribute4%TYPE;
229: l_tk_attribute5 pa_tasks.attribute5%TYPE;
230: l_tk_attribute6 pa_tasks.attribute6%TYPE;
231: l_tk_attribute7 pa_tasks.attribute7%TYPE;
232: l_tk_attribute8 pa_tasks.attribute8%TYPE;
233: l_tk_attribute9 pa_tasks.attribute9%TYPE;
234: l_tk_attribute10 pa_tasks.attribute10%TYPE;
235: -- end xxlu changes
236:

Line 233: l_tk_attribute9 pa_tasks.attribute9%TYPE;

229: l_tk_attribute5 pa_tasks.attribute5%TYPE;
230: l_tk_attribute6 pa_tasks.attribute6%TYPE;
231: l_tk_attribute7 pa_tasks.attribute7%TYPE;
232: l_tk_attribute8 pa_tasks.attribute8%TYPE;
233: l_tk_attribute9 pa_tasks.attribute9%TYPE;
234: l_tk_attribute10 pa_tasks.attribute10%TYPE;
235: -- end xxlu changes
236:
237: -- Bug#3491609 : Workflow Chanegs FP M

Line 234: l_tk_attribute10 pa_tasks.attribute10%TYPE;

230: l_tk_attribute6 pa_tasks.attribute6%TYPE;
231: l_tk_attribute7 pa_tasks.attribute7%TYPE;
232: l_tk_attribute8 pa_tasks.attribute8%TYPE;
233: l_tk_attribute9 pa_tasks.attribute9%TYPE;
234: l_tk_attribute10 pa_tasks.attribute10%TYPE;
235: -- end xxlu changes
236:
237: -- Bug#3491609 : Workflow Chanegs FP M
238: l_wf_item_type pa_proj_elements.wf_item_type%TYPE;

Line 244: --Modified pa_tasks to pa_proj_elements in the following local variables Bug 3809523

240: l_wf_lead_days pa_proj_elements.wf_start_lead_days%TYPE;
241: l_wf_enabled_flag pa_proj_elements.enable_wf_flag%TYPE;
242: -- Bug#3491609 : Workflow Chanegs FP M
243:
244: --Modified pa_tasks to pa_proj_elements in the following local variables Bug 3809523
245: l_task_number pa_proj_elements.element_number%TYPE := p_task_number; --ADDED FOR BUG 3705333
246: la_task_name pa_proj_elements.name%TYPE := p_task_name; --ADDED FOR BUG 3705333
247:
248: cursor get_page_name(c_page_id NUMBER)

Line 299: CURSOR cur_chk_pa_tasks

295:
296: -- should be checking for tasks in pa_proj_elements table.
297:
298: /*4156271 : Performance Fix - Commented the following Query for Performance reasons
299: CURSOR cur_chk_pa_tasks
300: IS
301: SELECT 'x'
302: FROM pa_tasks pt, pa_proj_elements ppe
303: WHERE pt.project_id = p_project_id

Line 302: FROM pa_tasks pt, pa_proj_elements ppe

298: /*4156271 : Performance Fix - Commented the following Query for Performance reasons
299: CURSOR cur_chk_pa_tasks
300: IS
301: SELECT 'x'
302: FROM pa_tasks pt, pa_proj_elements ppe
303: WHERE pt.project_id = p_project_id
304: AND pt.task_id = ppe.proj_element_id
305: AND ppe.link_task_flag = 'N';
306: */

Line 307: /* 4156271 : Same Cursor cur_chk_pa_tasks with better performance follows */

303: WHERE pt.project_id = p_project_id
304: AND pt.task_id = ppe.proj_element_id
305: AND ppe.link_task_flag = 'N';
306: */
307: /* 4156271 : Same Cursor cur_chk_pa_tasks with better performance follows */
308: CURSOR cur_chk_pa_tasks
309: IS
310: SELECT 'x'
311: FROM pa_tasks pt

Line 308: CURSOR cur_chk_pa_tasks

304: AND pt.task_id = ppe.proj_element_id
305: AND ppe.link_task_flag = 'N';
306: */
307: /* 4156271 : Same Cursor cur_chk_pa_tasks with better performance follows */
308: CURSOR cur_chk_pa_tasks
309: IS
310: SELECT 'x'
311: FROM pa_tasks pt
312: WHERE pt.project_id = p_project_id

Line 311: FROM pa_tasks pt

307: /* 4156271 : Same Cursor cur_chk_pa_tasks with better performance follows */
308: CURSOR cur_chk_pa_tasks
309: IS
310: SELECT 'x'
311: FROM pa_tasks pt
312: WHERE pt.project_id = p_project_id
313: AND EXISTS(SELECT 1
314: FROM PA_PROJ_ELEMENTS ppe
315: WHERE ppe.link_task_flag = 'N'

Line 360: SELECT parent_task_id, top_task_id FROM pa_tasks

356: l_parent_task_id NUMBER;
357: l_top_task_id NUMBER;
358:
359: CURSOR get_parent_task_id( c_task_id NUMBER ) IS
360: SELECT parent_task_id, top_task_id FROM pa_tasks
361: WHERE project_id = p_project_id and task_id = c_task_id;
362:
363: --End Bug 2947492
364: --bug 3305199

Line 371: FROM pa_tasks

367: --Bug 3705333
368: CURSOR get_task_name_or_number(c_project_id NUMBER,c_task_id NUMBER )
369: IS
370: SELECT task_name, task_number
371: FROM pa_tasks
372: WHERE project_id = c_project_id
373: AND task_id = c_task_id;
374: --end bug 3705333
375:

Line 411: IF p_object_type <> 'PA_TASKS'

407: IF (p_debug_mode = 'Y') THEN
408: pa_debug.debug('Performing validations');
409: END IF;
410:
411: IF p_object_type <> 'PA_TASKS'
412: THEN
413: PA_UTILS.ADD_MESSAGE('PA', 'PA_PS_NOT_TASK_OBJECT');
414: l_msg_data := 'PA_PS_NOT_TASK_OBJECT';
415: END IF;

Line 463: ,p_object_type => 'PA_TASKS'

459: p_element_number => l_task_number --Bug 3705333 Changed from p_task_number to l_task_number
460: ,p_element_id => null
461: ,p_project_id => p_project_id
462: ,p_structure_id => p_parent_structure_id
463: ,p_object_type => 'PA_TASKS'
464: ) = 'N'
465: THEN
466: IF p_pm_product_code = 'MSPROJECT'
467: THEN

Line 595: --IF (p_TYPE_ID = PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM AND p_object_type = 'PA_TASKS') THEN

591: END IF;
592:
593: IF ( p_TYPE_ID = PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM OR p_TYPE_ID IS NULL )
594: THEN
595: --IF (p_TYPE_ID = PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM AND p_object_type = 'PA_TASKS') THEN
596: IF (p_object_type = 'PA_TASKS') THEN
597: l_TYPE_ID := PA_PROJ_ELEMENTS_UTILS.GET_DEFAULT_TASK_TYPE_ID;
598: ELSE
599: l_TYPE_ID := NULL;

Line 596: IF (p_object_type = 'PA_TASKS') THEN

592:
593: IF ( p_TYPE_ID = PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM OR p_TYPE_ID IS NULL )
594: THEN
595: --IF (p_TYPE_ID = PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM AND p_object_type = 'PA_TASKS') THEN
596: IF (p_object_type = 'PA_TASKS') THEN
597: l_TYPE_ID := PA_PROJ_ELEMENTS_UTILS.GET_DEFAULT_TASK_TYPE_ID;
598: ELSE
599: l_TYPE_ID := NULL;
600: END IF;

Line 1070: ,p_object_type => 'PA_TASKS'

1066: CLOSE get_page_name;
1067:
1068: PA_PROGRESS_REPORT_PUB.DEFINE_PROGRESS_REPORT_SETUP(
1069: p_object_id => x_task_id
1070: ,p_object_type => 'PA_TASKS'
1071: ,p_page_type_code => 'AI'
1072: ,p_page_id => l_task_progress_entry_page_id
1073: ,p_page_name => l_page_name
1074: ,x_return_status => l_return_status

Line 1168: open cur_chk_pa_tasks;

1164: --end changes
1165: --dbms_output.put_line( 'Before Existing Create_task API '||p_project_id );
1166:
1167: l_dummy_char := null;
1168: open cur_chk_pa_tasks;
1169: fetch cur_chk_pa_tasks INTO l_dummy_char;
1170: close cur_chk_pa_tasks;
1171:
1172: --dbms_output.put_line('<'||l_dummy_char||'>, null = pa task is empty');

Line 1169: fetch cur_chk_pa_tasks INTO l_dummy_char;

1165: --dbms_output.put_line( 'Before Existing Create_task API '||p_project_id );
1166:
1167: l_dummy_char := null;
1168: open cur_chk_pa_tasks;
1169: fetch cur_chk_pa_tasks INTO l_dummy_char;
1170: close cur_chk_pa_tasks;
1171:
1172: --dbms_output.put_line('<'||l_dummy_char||'>, null = pa task is empty');
1173:

Line 1170: close cur_chk_pa_tasks;

1166:
1167: l_dummy_char := null;
1168: open cur_chk_pa_tasks;
1169: fetch cur_chk_pa_tasks INTO l_dummy_char;
1170: close cur_chk_pa_tasks;
1171:
1172: --dbms_output.put_line('<'||l_dummy_char||'>, null = pa task is empty');
1173:
1174: l_dummy_char2 := null;

Line 1186: --Not a valid ref task. Tasks exists in pa_tasks

1182: IF ( p_ref_task_id IS NULL AND l_dummy_char IS NOT NULL ) OR
1183: ( p_ref_task_id IS NOT NULL AND l_dummy_char IS NULL )
1184: --( l_dummy_char2 IS NOT NULL ) --is a structure version id not a valid ref task id from pa_task
1185: THEN
1186: --Not a valid ref task. Tasks exists in pa_tasks
1187: --dbms_output.put_line('error with ref tsk');
1188: PA_UTILS.ADD_MESSAGE('PA', 'PA_PS_INV_REF_TASK_ID');
1189: l_msg_data := 'PA_PS_INV_REF_TASK_ID';
1190: -- start of bug 3459905

Line 1247: -- Also ,Truncated Description to 250 chars as PA_TASKS can hold

1243: -- date and transaction end date in case of financial tasks
1244: -- Bug 3810252 : Reverted the fix of Bug 3804265
1245:
1246: --Bug 3935874 : Changed SUBSTR to SUBSTRB for avoiding MLS problem
1247: -- Also ,Truncated Description to 250 chars as PA_TASKS can hold
1248: -- Only Description upto 250 chars (l_task_description can be upto 2000 chars)
1249: PA_TASKS_MAINT_PUB.CREATE_TASK
1250: (
1251: p_api_version => p_api_version

Line 1249: PA_TASKS_MAINT_PUB.CREATE_TASK

1245:
1246: --Bug 3935874 : Changed SUBSTR to SUBSTRB for avoiding MLS problem
1247: -- Also ,Truncated Description to 250 chars as PA_TASKS can hold
1248: -- Only Description upto 250 chars (l_task_description can be upto 2000 chars)
1249: PA_TASKS_MAINT_PUB.CREATE_TASK
1250: (
1251: p_api_version => p_api_version
1252: ,p_init_msg_list => p_init_msg_list
1253: ,p_commit => p_commit

Line 1663: l_tk_attribute_category pa_tasks.attribute_category%TYPE;

1659: l_wq_actual_entry_code PA_PROJ_ELEMENTS.wq_actual_entry_code%TYPE;
1660: l_task_progress_entry_page_id PA_PROJ_ELEMENTS.task_progress_entry_page_id%TYPE;
1661:
1662: -- xxlu added task DFF attributes
1663: l_tk_attribute_category pa_tasks.attribute_category%TYPE;
1664: l_tk_attribute1 pa_tasks.attribute1%TYPE;
1665: l_tk_attribute2 pa_tasks.attribute2%TYPE;
1666: l_tk_attribute3 pa_tasks.attribute3%TYPE;
1667: l_tk_attribute4 pa_tasks.attribute4%TYPE;

Line 1664: l_tk_attribute1 pa_tasks.attribute1%TYPE;

1660: l_task_progress_entry_page_id PA_PROJ_ELEMENTS.task_progress_entry_page_id%TYPE;
1661:
1662: -- xxlu added task DFF attributes
1663: l_tk_attribute_category pa_tasks.attribute_category%TYPE;
1664: l_tk_attribute1 pa_tasks.attribute1%TYPE;
1665: l_tk_attribute2 pa_tasks.attribute2%TYPE;
1666: l_tk_attribute3 pa_tasks.attribute3%TYPE;
1667: l_tk_attribute4 pa_tasks.attribute4%TYPE;
1668: l_tk_attribute5 pa_tasks.attribute5%TYPE;

Line 1665: l_tk_attribute2 pa_tasks.attribute2%TYPE;

1661:
1662: -- xxlu added task DFF attributes
1663: l_tk_attribute_category pa_tasks.attribute_category%TYPE;
1664: l_tk_attribute1 pa_tasks.attribute1%TYPE;
1665: l_tk_attribute2 pa_tasks.attribute2%TYPE;
1666: l_tk_attribute3 pa_tasks.attribute3%TYPE;
1667: l_tk_attribute4 pa_tasks.attribute4%TYPE;
1668: l_tk_attribute5 pa_tasks.attribute5%TYPE;
1669: l_tk_attribute6 pa_tasks.attribute6%TYPE;

Line 1666: l_tk_attribute3 pa_tasks.attribute3%TYPE;

1662: -- xxlu added task DFF attributes
1663: l_tk_attribute_category pa_tasks.attribute_category%TYPE;
1664: l_tk_attribute1 pa_tasks.attribute1%TYPE;
1665: l_tk_attribute2 pa_tasks.attribute2%TYPE;
1666: l_tk_attribute3 pa_tasks.attribute3%TYPE;
1667: l_tk_attribute4 pa_tasks.attribute4%TYPE;
1668: l_tk_attribute5 pa_tasks.attribute5%TYPE;
1669: l_tk_attribute6 pa_tasks.attribute6%TYPE;
1670: l_tk_attribute7 pa_tasks.attribute7%TYPE;

Line 1667: l_tk_attribute4 pa_tasks.attribute4%TYPE;

1663: l_tk_attribute_category pa_tasks.attribute_category%TYPE;
1664: l_tk_attribute1 pa_tasks.attribute1%TYPE;
1665: l_tk_attribute2 pa_tasks.attribute2%TYPE;
1666: l_tk_attribute3 pa_tasks.attribute3%TYPE;
1667: l_tk_attribute4 pa_tasks.attribute4%TYPE;
1668: l_tk_attribute5 pa_tasks.attribute5%TYPE;
1669: l_tk_attribute6 pa_tasks.attribute6%TYPE;
1670: l_tk_attribute7 pa_tasks.attribute7%TYPE;
1671: l_tk_attribute8 pa_tasks.attribute8%TYPE;

Line 1668: l_tk_attribute5 pa_tasks.attribute5%TYPE;

1664: l_tk_attribute1 pa_tasks.attribute1%TYPE;
1665: l_tk_attribute2 pa_tasks.attribute2%TYPE;
1666: l_tk_attribute3 pa_tasks.attribute3%TYPE;
1667: l_tk_attribute4 pa_tasks.attribute4%TYPE;
1668: l_tk_attribute5 pa_tasks.attribute5%TYPE;
1669: l_tk_attribute6 pa_tasks.attribute6%TYPE;
1670: l_tk_attribute7 pa_tasks.attribute7%TYPE;
1671: l_tk_attribute8 pa_tasks.attribute8%TYPE;
1672: l_tk_attribute9 pa_tasks.attribute9%TYPE;

Line 1669: l_tk_attribute6 pa_tasks.attribute6%TYPE;

1665: l_tk_attribute2 pa_tasks.attribute2%TYPE;
1666: l_tk_attribute3 pa_tasks.attribute3%TYPE;
1667: l_tk_attribute4 pa_tasks.attribute4%TYPE;
1668: l_tk_attribute5 pa_tasks.attribute5%TYPE;
1669: l_tk_attribute6 pa_tasks.attribute6%TYPE;
1670: l_tk_attribute7 pa_tasks.attribute7%TYPE;
1671: l_tk_attribute8 pa_tasks.attribute8%TYPE;
1672: l_tk_attribute9 pa_tasks.attribute9%TYPE;
1673: l_tk_attribute10 pa_tasks.attribute10%TYPE;

Line 1670: l_tk_attribute7 pa_tasks.attribute7%TYPE;

1666: l_tk_attribute3 pa_tasks.attribute3%TYPE;
1667: l_tk_attribute4 pa_tasks.attribute4%TYPE;
1668: l_tk_attribute5 pa_tasks.attribute5%TYPE;
1669: l_tk_attribute6 pa_tasks.attribute6%TYPE;
1670: l_tk_attribute7 pa_tasks.attribute7%TYPE;
1671: l_tk_attribute8 pa_tasks.attribute8%TYPE;
1672: l_tk_attribute9 pa_tasks.attribute9%TYPE;
1673: l_tk_attribute10 pa_tasks.attribute10%TYPE;
1674: -- end xxlu changes

Line 1671: l_tk_attribute8 pa_tasks.attribute8%TYPE;

1667: l_tk_attribute4 pa_tasks.attribute4%TYPE;
1668: l_tk_attribute5 pa_tasks.attribute5%TYPE;
1669: l_tk_attribute6 pa_tasks.attribute6%TYPE;
1670: l_tk_attribute7 pa_tasks.attribute7%TYPE;
1671: l_tk_attribute8 pa_tasks.attribute8%TYPE;
1672: l_tk_attribute9 pa_tasks.attribute9%TYPE;
1673: l_tk_attribute10 pa_tasks.attribute10%TYPE;
1674: -- end xxlu changes
1675:

Line 1672: l_tk_attribute9 pa_tasks.attribute9%TYPE;

1668: l_tk_attribute5 pa_tasks.attribute5%TYPE;
1669: l_tk_attribute6 pa_tasks.attribute6%TYPE;
1670: l_tk_attribute7 pa_tasks.attribute7%TYPE;
1671: l_tk_attribute8 pa_tasks.attribute8%TYPE;
1672: l_tk_attribute9 pa_tasks.attribute9%TYPE;
1673: l_tk_attribute10 pa_tasks.attribute10%TYPE;
1674: -- end xxlu changes
1675:
1676: --hsiu added for task status

Line 1673: l_tk_attribute10 pa_tasks.attribute10%TYPE;

1669: l_tk_attribute6 pa_tasks.attribute6%TYPE;
1670: l_tk_attribute7 pa_tasks.attribute7%TYPE;
1671: l_tk_attribute8 pa_tasks.attribute8%TYPE;
1672: l_tk_attribute9 pa_tasks.attribute9%TYPE;
1673: l_tk_attribute10 pa_tasks.attribute10%TYPE;
1674: -- end xxlu changes
1675:
1676: --hsiu added for task status
1677: l_task_status_changed varchar2(1);

Line 1680: -- Changed Pa_tasks to pa_proj_elements for Bug 3809523

1676: --hsiu added for task status
1677: l_task_status_changed varchar2(1);
1678: --end task status changes
1679:
1680: -- Changed Pa_tasks to pa_proj_elements for Bug 3809523
1681: l_task_number pa_proj_elements.element_number%TYPE := p_task_number; --ADDED FOR BUG 3705333
1682: la_task_name pa_proj_elements.name%TYPE := p_task_name; --ADDED FOR BUG 3705333
1683: cursor get_page_name(c_page_id NUMBER)
1684: IS

Line 1695: and object_type = 'PA_TASKS'

1691: IS
1692: SELECT object_page_layout_id, record_version_number
1693: from pa_object_page_layouts
1694: where object_id = c_object_id
1695: and object_type = 'PA_TASKS'
1696: and page_type_code = 'AI';
1697:
1698: l_opl_id NUMBER;
1699: l_page_name pa_page_layouts.page_name%TYPE;

Line 1873: FROM pa_tasks

1869: --Bug 3705333 start
1870: CURSOR get_task_name_or_number(c_project_id NUMBER,c_task_id NUMBER )
1871: IS
1872: SELECT task_name, task_number
1873: FROM pa_tasks
1874: WHERE project_id = c_project_id
1875: AND task_id = c_task_id;
1876: --Bug 3705333 end
1877: l_base_perc_comp_deriv_code VARCHAR2(30);

Line 2713: ,p_object_type => 'PA_TASKS'

2709: CLOSE get_current_page;
2710:
2711: PA_PROGRESS_REPORT_PUB.DEFINE_PROGRESS_REPORT_SETUP(
2712: p_object_id => p_task_id
2713: ,p_object_type => 'PA_TASKS'
2714: ,p_page_type_code => 'AI'
2715: ,p_page_id => l_task_progress_entry_page_id
2716: ,p_page_name => l_page_name
2717: ,p_object_page_layout_id => l_opl_id

Line 2776: ,X_OBJECT_TYPE => 'PA_TASKS'

2772: PA_PROJ_ELEMENTS_PKG.Update_Row(
2773: X_ROW_ID => v_cur_proj_elems_rec.rowid
2774: ,X_PROJ_ELEMENT_ID => p_task_id
2775: ,X_PROJECT_ID => v_cur_proj_elems_rec.PROJECT_ID
2776: ,X_OBJECT_TYPE => 'PA_TASKS'
2777: ,X_ELEMENT_NUMBER => l_task_number --Bug 3705333 changed from p_task_number to l_task_number
2778: ,X_NAME => la_task_name --Bug 3705333 changed from p_task_namer to la_task_name
2779: ,X_DESCRIPTION => l_task_DESCRIPTION
2780: ,X_STATUS_CODE => l_STATUS_CODE

Line 2882: --Since FORMS and AMG env. update pa_tasks explicity we do not need to

2878: END IF;
2879:
2880: CLOSE cur_proj_elems;
2881:
2882: --Since FORMS and AMG env. update pa_tasks explicity we do not need to
2883: --call this apis again.
2884: IF p_calling_module NOT IN ( 'FORMS', 'AMG' )
2885: THEN
2886: --Get the structure id

Line 2927: --The followig logic is added to support hierarchy change in PA_TASKS

2923: THEN
2924: -- IF NVL( l_published_version, 'N' ) = 'N'
2925: -- THEN
2926: --end changes
2927: --The followig logic is added to support hierarchy change in PA_TASKS
2928: IF p_ref_task_id <> PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM AND p_ref_task_id IS NOT NULL
2929: THEN
2930: sELECT wbs_level, parent_task_id, top_task_id
2931: INTO l_wbs_level, l_parent_task_id, l_top_task_id

Line 2932: FROM pa_tasks

2928: IF p_ref_task_id <> PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM AND p_ref_task_id IS NOT NULL
2929: THEN
2930: sELECT wbs_level, parent_task_id, top_task_id
2931: INTO l_wbs_level, l_parent_task_id, l_top_task_id
2932: FROM pa_tasks
2933: WHERE task_id = p_ref_task_id;
2934:
2935: IF p_peer_or_sub = 'SUB'
2936: THEN

Line 2954: -- is only 250 char in PA_TASKS Table ,whereas it can be upto 2000 char in pa_proj_elements

2950: -- xxlu added p_long_task_name
2951:
2952: -- avaithia ,Changed SUBSTR to SUBSTRB as SUBSTR doesnt provide Multi Language Support
2953: -- Included SUBSTRB for Task Description also ,because Task Description size
2954: -- is only 250 char in PA_TASKS Table ,whereas it can be upto 2000 char in pa_proj_elements
2955: -- These changes have been done for Bug 3935874
2956:
2957: PA_TASKS_MAINT_PUB.UPDATE_TASK
2958: (

Line 2957: PA_TASKS_MAINT_PUB.UPDATE_TASK

2953: -- Included SUBSTRB for Task Description also ,because Task Description size
2954: -- is only 250 char in PA_TASKS Table ,whereas it can be upto 2000 char in pa_proj_elements
2955: -- These changes have been done for Bug 3935874
2956:
2957: PA_TASKS_MAINT_PUB.UPDATE_TASK
2958: (
2959: p_project_id => l_project_id
2960: ,p_task_id => p_task_id
2961: ,p_task_number => SUBSTRB( l_task_number, 1, 25 ) --Bug 3705333 changed from p_task_number to l_task_number

Line 3011: -- Also Truncated Description to 250 chars as PA_TASKS can hold only upto 250 char description

3007: -- xxlu add task DFF attributes
3008: --bug 3690807
3009:
3010: -- Changed SUBSTR to SUBSTRB for 3935874
3011: -- Also Truncated Description to 250 chars as PA_TASKS can hold only upto 250 char description
3012: -- whereas l_task_description can be upto 2000 chars
3013: PA_TASKS_MAINT_PUB.UPDATE_TASK
3014: (
3015: p_project_id => l_project_id

Line 3013: PA_TASKS_MAINT_PUB.UPDATE_TASK

3009:
3010: -- Changed SUBSTR to SUBSTRB for 3935874
3011: -- Also Truncated Description to 250 chars as PA_TASKS can hold only upto 250 char description
3012: -- whereas l_task_description can be upto 2000 chars
3013: PA_TASKS_MAINT_PUB.UPDATE_TASK
3014: (
3015: p_project_id => l_project_id
3016: ,p_task_id => p_task_id
3017: ,p_task_number => SUBSTRB( l_task_NUMBER, 1, 25 ) --Bug 3705333 changed from p_task_number to l_task_number

Line 3094: ,p_object_type => 'PA_TASKS'

3090: p_task_status => p_STATUS_CODE
3091: ,p_project_id => l_project_id
3092: ,p_object_id => p_task_id
3093: ,p_object_version_id => l_latest_task_ver_rec.element_version_id
3094: ,p_object_type => 'PA_TASKS'
3095: ,x_return_status => l_return_status
3096: ,x_msg_count => l_msg_count
3097: ,x_msg_data => l_msg_data
3098: );

Line 3585: ELSIF v_cur_proj_elems_rec.object_type = 'PA_TASKS'

3581: l_structure_id_to := v_cur_proj_elems_rec.proj_element_id;
3582:
3583: --dbms_output.put_line( 'In IF condition' );
3584:
3585: ELSIF v_cur_proj_elems_rec.object_type = 'PA_TASKS'
3586: THEN
3587: --If the task version is not a top level within the structure version
3588:
3589: l_parent_struc_ver_id := v_cur_proj_elems_rec.parent_structure_version_id;

Line 3705: ,X_OBJECT_TYPE => 'PA_TASKS'

3701: PA_PROJ_ELEMENT_VERSIONS_PKG.Insert_Row(
3702: X_ROW_ID => X_row_id
3703: ,X_ELEMENT_VERSION_ID => x_task_version_id
3704: ,X_PROJ_ELEMENT_ID => p_task_id
3705: ,X_OBJECT_TYPE => 'PA_TASKS'
3706: ,X_PROJECT_ID => v_cur_proj_elems_rec.project_id
3707: ,X_PARENT_STRUCTURE_VERSION_ID => l_parent_struc_ver_id
3708: ,X_DISPLAY_SEQUENCE => l_DISPLAY_SEQUENCE
3709: ,X_WBS_LEVEL => l_WBS_LEVEL

Line 3747: /*IF v_cur_proj_elems_rec.object_type = 'PA_TASKS' THEN

3743: -- we are skipping updating display sequence and wbs numbers for performance
3744: -- Once all tasks are added, we re-order them just ONCE
3745: IF NVL(PA_PROJECT_PUB.G_MASS_ADD_TASKS,'N') = 'Y' THEN
3746: -- skkkoppul added if block for Huawei bug 13923366
3747: /*IF v_cur_proj_elems_rec.object_type = 'PA_TASKS' THEN
3748: Update PA_PROJ_ELEMENT_VERSIONS
3749: set display_sequence = l_ref_seq_no,
3750: last_updated_by = -ABS(FND_LOG_MESSAGES_S.NEXTVAL)
3751: where element_version_id = x_task_version_id;

Line 3755: IF v_cur_proj_elems_rec.object_type = 'PA_TASKS' THEN

3751: where element_version_id = x_task_version_id;
3752: END IF;*/
3753:
3754: --Sridhar Huawei 18-Sept start
3755: IF v_cur_proj_elems_rec.object_type = 'PA_TASKS' THEN
3756: PA_TASK_PVT1.DISP_SEQ_NUM_LEVEL_DEFER(
3757: p_project_id => v_cur_proj_elems_rec.project_id
3758: ,p_event_type => 'ADD'
3759: ,p_parent_struct_ver_id => l_parent_struc_ver_id

Line 3784: AND object_type = 'PA_TASKS'

3780: SET display_sequence = display_sequence + 1
3781: WHERE display_sequence > l_ref_seq_no
3782: AND element_version_id <> x_task_version_id
3783: AND parent_structure_version_id = v_cur_proj_elems_rec.parent_structure_version_id
3784: AND object_type = 'PA_TASKS'
3785: -- AND PA_PROJ_ELEMENTS_UTILS.link_flag ( proj_element_id ) = 'N' commenitng out for bug 4180390
3786: ;
3787: ELSE
3788: IF p_peer_or_sub = 'PEER' --Bug 4046026

Line 3795: AND object_type = 'PA_TASKS'

3791: SET display_sequence = display_sequence + 1
3792: WHERE display_sequence > l_ref_seq_no
3793: AND element_version_id <> x_task_version_id
3794: AND parent_structure_version_id = v_cur_proj_elems_rec.parent_structure_version_id
3795: AND object_type = 'PA_TASKS'
3796: --AND PA_PROJ_ELEMENTS_UTILS.link_flag ( proj_element_id ) = 'N' commenitng out for bug 4180390
3797: ;
3798: END IF;
3799: END IF; --Added for Bug 4046026 Commented for 4057190 /** Uncommented it again for BUg 4046026 **/

Line 4047: AND object_type = 'PA_TASKS';

4043: attribute6, attribute7, attribute8, attribute9, attribute10, attribute11, attribute12,
4044: attribute13, attribute14, attribute15, TASK_UNPUB_VER_STATUS_CODE
4045: FROM pa_proj_element_versions
4046: WHERE element_version_id = p_task_version_id
4047: AND object_type = 'PA_TASKS';
4048:
4049: CURSOR cur_child_tasks( c_task_version_id NUMBER )
4050: IS SELECT a.object_id_from1, a.object_id_to1, b.parent_structure_version_id, b.display_sequence
4051: FROM

Line 4149: and a.object_type_to = 'PA_TASKS'

4145: cursor get_task_weighting(c_task_version_id NUMBER) IS
4146: select a.object_id_from1, a.weighting_percentage
4147: from pa_object_relationships a
4148: where a.object_id_to1 = c_task_version_id
4149: and a.object_type_to = 'PA_TASKS'
4150: and a.relationship_type = 'S'
4151: and a.object_type_from IN ('PA_STRUCTURES', 'PA_TASKS');
4152: l_old_parent_id NUMBER;
4153:

Line 4151: and a.object_type_from IN ('PA_STRUCTURES', 'PA_TASKS');

4147: from pa_object_relationships a
4148: where a.object_id_to1 = c_task_version_id
4149: and a.object_type_to = 'PA_TASKS'
4150: and a.relationship_type = 'S'
4151: and a.object_type_from IN ('PA_STRUCTURES', 'PA_TASKS');
4152: l_old_parent_id NUMBER;
4153:
4154: -- anlee task weighting changes
4155: cursor get_sub_tasks(c_task_version_id NUMBER) IS

Line 4159: and object_type_from IN ('PA_TASKS', 'PA_STRUCTURES')

4155: cursor get_sub_tasks(c_task_version_id NUMBER) IS
4156: select '1'
4157: from pa_object_relationships
4158: where object_id_from1 = c_task_version_id
4159: and object_type_from IN ('PA_TASKS', 'PA_STRUCTURES')
4160: and relationship_type = 'S';
4161: l_dummy varchar2(1);
4162:
4163: l_version_from NUMBER;

Line 4255: AND pev.object_type = 'PA_TASKS'

4251: begin
4252: SELECT rel.object_id_from1 INTO l_parent_task_id
4253: FROM PA_PROJ_ELEMENT_VERSIONS pev, PA_OBJECT_RELATIONSHIPS rel
4254: WHERE pev.element_version_id = p_task_version_id
4255: AND pev.object_type = 'PA_TASKS'
4256: AND rel.object_id_to1 = pev.element_version_id
4257: AND rel.relationship_type = 'S'
4258: AND rel.object_type_from in ('PA_TASKS', 'PA_STRUCTURES');
4259:

Line 4258: AND rel.object_type_from in ('PA_TASKS', 'PA_STRUCTURES');

4254: WHERE pev.element_version_id = p_task_version_id
4255: AND pev.object_type = 'PA_TASKS'
4256: AND rel.object_id_to1 = pev.element_version_id
4257: AND rel.relationship_type = 'S'
4258: AND rel.object_type_from in ('PA_TASKS', 'PA_STRUCTURES');
4259:
4260: SELECT rel.object_id_from1 INTO l_ref_parent_task_id
4261: FROM PA_PROJ_ELEMENT_VERSIONS pev, PA_OBJECT_RELATIONSHIPS rel
4262: WHERE pev.element_version_id = p_ref_task_version_id

Line 4263: AND pev.object_type = 'PA_TASKS'

4259:
4260: SELECT rel.object_id_from1 INTO l_ref_parent_task_id
4261: FROM PA_PROJ_ELEMENT_VERSIONS pev, PA_OBJECT_RELATIONSHIPS rel
4262: WHERE pev.element_version_id = p_ref_task_version_id
4263: AND pev.object_type = 'PA_TASKS'
4264: AND rel.object_id_to1 = pev.element_version_id
4265: AND rel.relationship_type = 'S'
4266: AND rel.object_type_from in ('PA_TASKS', 'PA_STRUCTURES');
4267: EXCEPTION

Line 4266: AND rel.object_type_from in ('PA_TASKS', 'PA_STRUCTURES');

4262: WHERE pev.element_version_id = p_ref_task_version_id
4263: AND pev.object_type = 'PA_TASKS'
4264: AND rel.object_id_to1 = pev.element_version_id
4265: AND rel.relationship_type = 'S'
4266: AND rel.object_type_from in ('PA_TASKS', 'PA_STRUCTURES');
4267: EXCEPTION
4268: WHEN OTHERS then
4269: l_parent_task_id := null;
4270: l_ref_parent_task_id := null;

Line 4427: IF v_cur_ref_task_rec.object_type = 'PA_TASKS' --Moving under a task

4423:
4424: --dbms_output.put_line( 'p_action '|| p_action );
4425:
4426:
4427: IF v_cur_ref_task_rec.object_type = 'PA_TASKS' --Moving under a task
4428: THEN
4429: IF p_peer_or_sub = 'PEER'
4430: THEN
4431: l_wbs_level := v_cur_ref_task_rec.wbs_level; --wbs level of reference

Line 4997: WHERE rel.object_type_from = 'PA_TASKS'

4993: pev.display_sequence, rel.object_id_to1, rel.object_type_to,
4994: rel.relationship_type, rel.object_id_from1, rel.object_type_from
4995: FROM pa_proj_element_versions pev, pa_object_relationships rel,
4996: pa_proj_element_versions parent
4997: WHERE rel.object_type_from = 'PA_TASKS'
4998: AND rel.relationship_type = 'S'
4999: AND rel.object_type_to = 'PA_TASKS'
5000: AND rel.object_id_from1 = parent.element_version_id
5001: AND rel.object_id_to1 = pev.element_version_id

Line 4999: AND rel.object_type_to = 'PA_TASKS'

4995: FROM pa_proj_element_versions pev, pa_object_relationships rel,
4996: pa_proj_element_versions parent
4997: WHERE rel.object_type_from = 'PA_TASKS'
4998: AND rel.relationship_type = 'S'
4999: AND rel.object_type_to = 'PA_TASKS'
5000: AND rel.object_id_from1 = parent.element_version_id
5001: AND rel.object_id_to1 = pev.element_version_id
5002: AND pev.parent_structure_version_id = l_parent_struc_ver_id
5003: and parent.PARENT_STRUCTURE_VERSION_ID = l_parent_struc_ver_id

Line 5045: WHERE rel.object_type_from = 'PA_TASKS'

5041: pev.display_sequence, rel.object_id_to1, rel.object_type_to,
5042: rel.relationship_type, rel.object_id_from1, rel.object_type_from
5043: FROM pa_proj_element_versions pev, pa_object_relationships rel,
5044: pa_proj_element_versions parent
5045: WHERE rel.object_type_from = 'PA_TASKS'
5046: AND rel.relationship_type = 'S'
5047: AND rel.object_type_to = 'PA_TASKS'
5048: AND rel.object_id_from1 = parent.element_version_id
5049: AND rel.object_id_to1 = pev.element_version_id

Line 5047: AND rel.object_type_to = 'PA_TASKS'

5043: FROM pa_proj_element_versions pev, pa_object_relationships rel,
5044: pa_proj_element_versions parent
5045: WHERE rel.object_type_from = 'PA_TASKS'
5046: AND rel.relationship_type = 'S'
5047: AND rel.object_type_to = 'PA_TASKS'
5048: AND rel.object_id_from1 = parent.element_version_id
5049: AND rel.object_id_to1 = pev.element_version_id
5050: AND pev.parent_structure_version_id = l_parent_struc_ver_id
5051: and parent.PARENT_STRUCTURE_VERSION_ID = l_parent_struc_ver_id

Line 5398: CURSOR cur_pa_tasks( p_task_id NUMBER )

5394: FROM pa_proj_elem_ver_structure
5395: -- HY FROM pa_projects_all
5396: WHERE project_id = p_project_id;
5397:
5398: CURSOR cur_pa_tasks( p_task_id NUMBER )
5399: IS
5400: SELECT record_version_number
5401: FROM pa_tasks
5402: WHERE task_id = p_task_id;

Line 5401: FROM pa_tasks

5397:
5398: CURSOR cur_pa_tasks( p_task_id NUMBER )
5399: IS
5400: SELECT record_version_number
5401: FROM pa_tasks
5402: WHERE task_id = p_task_id;
5403:
5404: CURSOR cur_chk_vers( x_proj_element_id NUMBER, x_task_version NUMBER )
5405: IS

Line 5438: and a.object_type_to = 'PA_TASKS'

5434: pa_object_relationships b,
5435: pa_proj_element_versions c,
5436: pa_proj_elements d
5437: where a.object_id_to1 = p_task_version_id
5438: and a.object_type_to = 'PA_TASKS'
5439: and a.object_id_from1 = b.object_id_from1
5440: and a.object_type_from = b.object_type_from
5441: and b.object_type_to = 'PA_TASKS'
5442: and b.object_id_to1 <> p_task_version_id

Line 5441: and b.object_type_to = 'PA_TASKS'

5437: where a.object_id_to1 = p_task_version_id
5438: and a.object_type_to = 'PA_TASKS'
5439: and a.object_id_from1 = b.object_id_from1
5440: and a.object_type_from = b.object_type_from
5441: and b.object_type_to = 'PA_TASKS'
5442: and b.object_id_to1 <> p_task_version_id
5443: and a.relationship_type = 'S'
5444: and b.relationship_type = 'S'
5445: and b.object_id_to1 = c.element_version_id

Line 5458: and object_type_to = 'PA_TASKS'

5454: CURSOR get_parent_version_id IS
5455: select object_id_from1
5456: from pa_object_relationships
5457: where object_id_to1 = p_task_version_id
5458: and object_type_to = 'PA_TASKS'
5459: and relationship_type = 'S'
5460: and object_type_from IN ('PA_STRUCTURES', 'PA_TASKS');
5461: l_old_parent_ver_id NUMBER;
5462: --end task weighting changes

Line 5460: and object_type_from IN ('PA_STRUCTURES', 'PA_TASKS');

5456: from pa_object_relationships
5457: where object_id_to1 = p_task_version_id
5458: and object_type_to = 'PA_TASKS'
5459: and relationship_type = 'S'
5460: and object_type_from IN ('PA_STRUCTURES', 'PA_TASKS');
5461: l_old_parent_ver_id NUMBER;
5462: --end task weighting changes
5463:
5464: x_row_id VARCHAR2(255);

Line 5504: SELECT parent_task_id, top_task_id, record_version_number FROM pa_tasks

5500:
5501: l_Structure_Version_ID NUMBER; -- FP_M changes 3305199
5502:
5503: CURSOR get_parent_task_id( c_project_id NUMBER , c_task_id NUMBER ) IS
5504: SELECT parent_task_id, top_task_id, record_version_number FROM pa_tasks
5505: WHERE project_id = c_project_id and task_id = c_task_id;
5506:
5507: --End Bug 2947492
5508:

Line 5558: AND pors.object_type_from = 'PA_TASKS'

5554: AND pors1.relationship_type = 'S'
5555: --bug 4573340
5556: AND pors.relationship_type IN ('LW','LF')
5557: AND pors.object_id_from2 <> pors.object_id_to2
5558: AND pors.object_type_from = 'PA_TASKS'
5559: AND pors.object_type_to = 'PA_STRUCTURES';
5560: get_subproj_relation_rec get_subproj_relation%ROWTYPE;
5561:
5562: l_task_id NUMBER; --bug 4006401

Line 5570: and object_type_from = 'PA_TASKS'

5566: select object_id_to1 task_ver_id
5567: from pa_object_relationships pors
5568: start with object_id_from1 = c_task_version_id
5569: and relationship_type = 'S'
5570: and object_type_from = 'PA_TASKS'
5571: and object_type_to = 'PA_TASKS'
5572: connect by relationship_type = prior relationship_type
5573: and prior object_type_to = object_type_from
5574: and prior object_id_to1 = object_id_from1

Line 5571: and object_type_to = 'PA_TASKS'

5567: from pa_object_relationships pors
5568: start with object_id_from1 = c_task_version_id
5569: and relationship_type = 'S'
5570: and object_type_from = 'PA_TASKS'
5571: and object_type_to = 'PA_TASKS'
5572: connect by relationship_type = prior relationship_type
5573: and prior object_type_to = object_type_from
5574: and prior object_id_to1 = object_id_from1
5575: UNION

Line 5584: where object_type = 'PA_TASKS'

5580:
5581: --bug 4110957
5582: CURSOR get_tsk_cnt(c_struc_ver_id NUMBER) IS
5583: select count(1) from pa_proj_element_versions
5584: where object_type = 'PA_TASKS'
5585: and parent_structure_version_id = c_struc_ver_id;
5586: l_tsk_ver_cnt NUMBER;
5587: --end bug 4110957
5588:

Line 5651: PA_Tasks_Maint_Utils.Check_WorkPlan_Task_Exists (

5647: -- Tracking bug 3305199
5648: If p_Structure_Type = 'FINANCIAL' and
5649: PA_PROJECT_STRUCTURE_UTILS.get_Structure_sharing_code(l_Project_id )= 'SHARE_PARTIAL'
5650: then
5651: PA_Tasks_Maint_Utils.Check_WorkPlan_Task_Exists (
5652: p_api_version => p_api_version
5653: , p_calling_module => p_calling_module
5654: , p_debug_mode => p_debug_mode
5655: , p_task_version_id => p_task_version_id

Line 5846: --Since forms and AMG already deletes from pa_tasks we do not have to call the following api again.

5842: CLOSE get_parent_task_id;
5843:
5844: IF p_called_from_api <> 'MOVE_TASK_VERSION' AND
5845: p_calling_module NOT IN ( 'FORMS', 'AMG' ) --Added condition to call this api from forms and AMG apis.
5846: --Since forms and AMG already deletes from pa_tasks we do not have to call the following api again.
5847: THEN
5848: PA_TASKS_MAINT_PUB.DELETE_TASK(
5849: p_api_version => p_api_version
5850: ,p_init_msg_list => p_init_msg_list

Line 5848: PA_TASKS_MAINT_PUB.DELETE_TASK(

5844: IF p_called_from_api <> 'MOVE_TASK_VERSION' AND
5845: p_calling_module NOT IN ( 'FORMS', 'AMG' ) --Added condition to call this api from forms and AMG apis.
5846: --Since forms and AMG already deletes from pa_tasks we do not have to call the following api again.
5847: THEN
5848: PA_TASKS_MAINT_PUB.DELETE_TASK(
5849: p_api_version => p_api_version
5850: ,p_init_msg_list => p_init_msg_list
5851: ,p_commit => p_commit
5852: ,p_validate_only => p_validate_only

Line 6066: -- the tasks were not getting deleted from PA_TASKS

6062: --THEN
6063:
6064: -- Bug#3834117
6065: -- For a split case if task is deleted from SS page
6066: -- the tasks were not getting deleted from PA_TASKS
6067: -- table. In SPLIT case fin tasks should always get deleted
6068: -- from PA_TASKS table
6069: IF nvl(l_shared,'N') = 'N' THEN
6070: l_delete_flag := 'Y';

Line 6068: -- from PA_TASKS table

6064: -- Bug#3834117
6065: -- For a split case if task is deleted from SS page
6066: -- the tasks were not getting deleted from PA_TASKS
6067: -- table. In SPLIT case fin tasks should always get deleted
6068: -- from PA_TASKS table
6069: IF nvl(l_shared,'N') = 'N' THEN
6070: l_delete_flag := 'Y';
6071: ELSE
6072: SELECT proj_element_id INTO l_structure_id

Line 6133: -- OPEN cur_pa_tasks( l_proj_element_id );

6129: OPEN cur_pa_projs( x_project_id );
6130: FETCH cur_pa_projs INTO x_wbs_rec_version_number;
6131: CLOSE cur_pa_projs;
6132:
6133: -- OPEN cur_pa_tasks( l_proj_element_id );
6134: -- FETCH cur_pa_tasks INTO x_task_rec_version_number;
6135: -- CLOSE cur_pa_tasks; --commented out and merged with the cursor get_parent_task_id below for performance for bug 2947492
6136:
6137: --Bug 2947492

Line 6134: -- FETCH cur_pa_tasks INTO x_task_rec_version_number;

6130: FETCH cur_pa_projs INTO x_wbs_rec_version_number;
6131: CLOSE cur_pa_projs;
6132:
6133: -- OPEN cur_pa_tasks( l_proj_element_id );
6134: -- FETCH cur_pa_tasks INTO x_task_rec_version_number;
6135: -- CLOSE cur_pa_tasks; --commented out and merged with the cursor get_parent_task_id below for performance for bug 2947492
6136:
6137: --Bug 2947492
6138: --call plannable tasks api here. This will be executed whenever a task is deleted regardless from

Line 6135: -- CLOSE cur_pa_tasks; --commented out and merged with the cursor get_parent_task_id below for performance for bug 2947492

6131: CLOSE cur_pa_projs;
6132:
6133: -- OPEN cur_pa_tasks( l_proj_element_id );
6134: -- FETCH cur_pa_tasks INTO x_task_rec_version_number;
6135: -- CLOSE cur_pa_tasks; --commented out and merged with the cursor get_parent_task_id below for performance for bug 2947492
6136:
6137: --Bug 2947492
6138: --call plannable tasks api here. This will be executed whenever a task is deleted regardless from
6139: --which environement FORMS, Self Service or AMG.

Line 6186: --Since forms and AMG already deletes from pa_tasks we do not have to call the following api again.

6182:
6183: --dbms_output.put_line( 'before delete_task ' );
6184: IF p_called_from_api <> 'MOVE_TASK_VERSION' AND
6185: p_calling_module NOT IN ( 'FORMS', 'AMG' ) --Added condition to call this api from forms and AMG apis.
6186: --Since forms and AMG already deletes from pa_tasks we do not have to call the following api again.
6187: THEN
6188: PA_TASKS_MAINT_PUB.DELETE_TASK
6189: (
6190: p_api_version => p_api_version

Line 6188: PA_TASKS_MAINT_PUB.DELETE_TASK

6184: IF p_called_from_api <> 'MOVE_TASK_VERSION' AND
6185: p_calling_module NOT IN ( 'FORMS', 'AMG' ) --Added condition to call this api from forms and AMG apis.
6186: --Since forms and AMG already deletes from pa_tasks we do not have to call the following api again.
6187: THEN
6188: PA_TASKS_MAINT_PUB.DELETE_TASK
6189: (
6190: p_api_version => p_api_version
6191: ,p_init_msg_list => p_init_msg_list
6192: ,p_commit => p_commit

Line 6406: cursor alt_task_cur ( l_task_id pa_tasks.task_id%TYPE )

6402:
6403: Declare
6404: l_alt_task_Ids SYSTEM.pa_num_tbl_type := SYSTEM.PA_NUM_TBL_TYPE();
6405: l_valid_status_tbl SYSTEM.PA_VARCHAR2_1_TBL_TYPE := SYSTEM.PA_VARCHAR2_1_TBL_TYPE(); --bug#16461684
6406: cursor alt_task_cur ( l_task_id pa_tasks.task_id%TYPE )
6407: is
6408: select alt_task_id from pa_alternate_tasks
6409: where proj_element_id = l_task_id
6410: ;

Line 6615: SET display_sequence = PA_TASKS_MAINT_UTILS.REARRANGE_DISPLAY_SEQ(display_sequence, 0, l_task_cnt, 'DELETE', 'DOWN')

6611: IF NVL(PA_PROJECT_PUB.G_ROLLUP_DEFER,'N') = 'N' THEN
6612:
6613: BEGIN
6614: UPDATE PA_PROJ_ELEMENT_VERSIONS
6615: SET display_sequence = PA_TASKS_MAINT_UTILS.REARRANGE_DISPLAY_SEQ(display_sequence, 0, l_task_cnt, 'DELETE', 'DOWN')
6616: -- record_version_number = record_version_number + 1
6617: WHERE parent_structure_version_id = x_parent_struc_ver_id
6618: AND (display_sequence > l_selected_seq_num)
6619: AND PA_PROJ_ELEMENTS_UTILS.link_flag ( proj_element_id ) = 'N';

Line 7833: and ppru.object_type = 'PA_TASKS';

7829: and ppc.task_id = c_element_id
7830: and ppc.current_flag = 'Y'
7831: and ppc.project_Id = ppru.project_id
7832: and ppc.task_id = ppru.object_id
7833: and ppru.object_type = 'PA_TASKS';
7834:
7835: CURSOR get_info IS
7836: select proj_element_id, project_id
7837: from pa_proj_elem_ver_schedule

Line 8842: PA_TASKS_MAINT_UTILS.Check_Start_Date_EI(

8838: IF (PA_WORKPLAN_ATTR_UTILS.CHECK_AUTO_DATE_SYNC_ENABLED(l_proj_element_id_temp) = 'Y')
8839: THEN
8840:
8841: -- Check Scheduled Start Date against EI date
8842: PA_TASKS_MAINT_UTILS.Check_Start_Date_EI(
8843: p_project_id => cur_proj_elem_ver_sch_rec.project_id,
8844: p_task_id => cur_proj_elem_ver_sch_rec.proj_element_id,
8845: p_start_date => l_scheduled_start_date,
8846: x_return_status => l_return_status,

Line 8851: PA_TASKS_MAINT_UTILS.Check_End_Date_EI(

8847: x_msg_count => l_msg_count,
8848: x_msg_data => l_msg_data);
8849:
8850: -- Check Scheduled Finish Date against EI date
8851: PA_TASKS_MAINT_UTILS.Check_End_Date_EI(
8852: p_project_id => cur_proj_elem_ver_sch_rec.project_id,
8853: p_task_id => cur_proj_elem_ver_sch_rec.proj_element_id,
8854: p_end_date => l_scheduled_end_date,
8855: x_return_status => l_return_status,

Line 9123: and b.object_type_to = 'PA_TASKS'

9119: from pa_proj_element_versions a,
9120: pa_object_relationships b,
9121: pa_proj_elements c
9122: where b.object_id_to1 = p_task_version_id
9123: and b.object_type_to = 'PA_TASKS'
9124: and b.relationship_type = 'S'
9125: and b.object_type_from = 'PA_TASKS'
9126: and b.object_id_from1 = a.element_version_id
9127: and a.project_id = c.project_id

Line 9125: and b.object_type_from = 'PA_TASKS'

9121: pa_proj_elements c
9122: where b.object_id_to1 = p_task_version_id
9123: and b.object_type_to = 'PA_TASKS'
9124: and b.relationship_type = 'S'
9125: and b.object_type_from = 'PA_TASKS'
9126: and b.object_id_from1 = a.element_version_id
9127: and a.project_id = c.project_id
9128: and a.proj_element_id = c.proj_element_id;
9129: l_parent_type_attr_rec get_parent_task_type_attr%ROWTYPE;

Line 9317: and object_type_from IN ('PA_STRUCTURES', 'PA_TASKS')

9313: CURSOR get_weighting_sum IS
9314: select sum(weighting_percentage)
9315: from pa_object_relationships
9316: where object_id_from1 = p_task_version_id
9317: and object_type_from IN ('PA_STRUCTURES', 'PA_TASKS')
9318: and relationship_type = 'S';
9319:
9320: CURSOR get_child_weighting IS
9321: select object_relationship_id, weighting_percentage,

Line 9325: and object_type_from IN ('PA_STRUCTURES', 'PA_TASKS')

9321: select object_relationship_id, weighting_percentage,
9322: record_version_number, object_id_to1
9323: from pa_object_relationships
9324: where object_id_from1 = p_task_version_id
9325: and object_type_from IN ('PA_STRUCTURES', 'PA_TASKS')
9326: and relationship_type = 'S';
9327:
9328: l_sum NUMBER(17,2);
9329: l_weighting NUMBER(17,2);

Line 9500: and object_type_from = 'PA_TASKS'

9496: CURSOR get_task_versions IS
9497: select object_id_to1
9498: from pa_object_relationships
9499: where relationship_type = 'S'
9500: and object_type_from = 'PA_TASKS'
9501: and object_type_to = 'PA_TASKS'
9502: and relationship_type = 'S'
9503: start with object_id_to1 = p_task_version_id
9504: connect by prior object_id_to1 = object_id_from1

Line 9501: and object_type_to = 'PA_TASKS'

9497: select object_id_to1
9498: from pa_object_relationships
9499: where relationship_type = 'S'
9500: and object_type_from = 'PA_TASKS'
9501: and object_type_to = 'PA_TASKS'
9502: and relationship_type = 'S'
9503: start with object_id_to1 = p_task_version_id
9504: connect by prior object_id_to1 = object_id_from1
9505: and relationship_type = prior relationship_type --bug 3919266

Line 9634: CURSOR cur_pa_tasks( p_task_id NUMBER )

9630: FROM pa_proj_elem_ver_structure
9631: -- HY FROM pa_projects_all
9632: WHERE project_id = p_project_id;
9633:
9634: CURSOR cur_pa_tasks( p_task_id NUMBER )
9635: IS
9636: SELECT record_version_number
9637: FROM pa_tasks
9638: WHERE task_id = p_task_id;

Line 9637: FROM pa_tasks

9633:
9634: CURSOR cur_pa_tasks( p_task_id NUMBER )
9635: IS
9636: SELECT record_version_number
9637: FROM pa_tasks
9638: WHERE task_id = p_task_id;
9639:
9640: CURSOR cur_chk_vers( x_proj_element_id NUMBER, x_task_version NUMBER )
9641: IS

Line 9672: and a.object_type_to = 'PA_TASKS'

9668: select b.object_id_to1 object_id_to1
9669: from pa_object_relationships a,
9670: pa_object_relationships b
9671: where a.object_id_to1 = p_task_version_id
9672: and a.object_type_to = 'PA_TASKS'
9673: and a.object_id_from1 = b.object_id_from1
9674: and a.object_type_from = b.object_type_from
9675: and b.object_type_to = 'PA_TASKS'
9676: and b.object_id_to1 <> p_task_version_id

Line 9675: and b.object_type_to = 'PA_TASKS'

9671: where a.object_id_to1 = p_task_version_id
9672: and a.object_type_to = 'PA_TASKS'
9673: and a.object_id_from1 = b.object_id_from1
9674: and a.object_type_from = b.object_type_from
9675: and b.object_type_to = 'PA_TASKS'
9676: and b.object_id_to1 <> p_task_version_id
9677: and a.relationship_type = 'S'
9678: and b.relationship_type = 'S';
9679: c_get_peer_tasks get_peer_tasks%ROWTYPE;

Line 9688: and object_type_to = 'PA_TASKS'

9684: CURSOR get_parent_version_id IS
9685: select object_id_from1
9686: from pa_object_relationships
9687: where object_id_to1 = p_task_version_id
9688: and object_type_to = 'PA_TASKS'
9689: and relationship_type = 'S'
9690: and object_type_from IN ('PA_STRUCTURES', 'PA_TASKS');
9691: l_old_parent_ver_id NUMBER;
9692: --end task weighting changes

Line 9690: and object_type_from IN ('PA_STRUCTURES', 'PA_TASKS');

9686: from pa_object_relationships
9687: where object_id_to1 = p_task_version_id
9688: and object_type_to = 'PA_TASKS'
9689: and relationship_type = 'S'
9690: and object_type_from IN ('PA_STRUCTURES', 'PA_TASKS');
9691: l_old_parent_ver_id NUMBER;
9692: --end task weighting changes
9693:
9694: x_row_id VARCHAR2(255);

Line 9764: AND pors.object_type_from = 'PA_TASKS'

9760: AND pors1.relationship_type = 'S'
9761: --bug 4573340
9762: AND pors.relationship_type IN ('LW','LF')
9763: AND pors.object_id_from2 <> pors.object_id_to2
9764: AND pors.object_type_from = 'PA_TASKS'
9765: AND pors.object_type_to = 'PA_STRUCTURES'
9766: order by pors.object_id_to2; --order by clause is added for the Bug 14591859
9767: get_subproj_relation_rec get_subproj_relation%ROWTYPE;
9768: --

Line 9936: OPEN cur_pa_tasks( l_proj_element_id );

9932: OPEN cur_pa_projs( x_project_id );
9933: FETCH cur_pa_projs INTO x_wbs_rec_version_number;
9934: CLOSE cur_pa_projs;
9935:
9936: OPEN cur_pa_tasks( l_proj_element_id );
9937: FETCH cur_pa_tasks INTO x_task_rec_version_number;
9938: IF p_calling_module NOT IN ( 'FORMS', 'AMG' ) AND cur_pa_tasks%FOUND THEN
9939: --Added condition to call this api from forms and AMG apis.
9940: --Since forms and AMG already deletes from pa_tasks

Line 9937: FETCH cur_pa_tasks INTO x_task_rec_version_number;

9933: FETCH cur_pa_projs INTO x_wbs_rec_version_number;
9934: CLOSE cur_pa_projs;
9935:
9936: OPEN cur_pa_tasks( l_proj_element_id );
9937: FETCH cur_pa_tasks INTO x_task_rec_version_number;
9938: IF p_calling_module NOT IN ( 'FORMS', 'AMG' ) AND cur_pa_tasks%FOUND THEN
9939: --Added condition to call this api from forms and AMG apis.
9940: --Since forms and AMG already deletes from pa_tasks
9941: --we do not have to call the following api again.

Line 9938: IF p_calling_module NOT IN ( 'FORMS', 'AMG' ) AND cur_pa_tasks%FOUND THEN

9934: CLOSE cur_pa_projs;
9935:
9936: OPEN cur_pa_tasks( l_proj_element_id );
9937: FETCH cur_pa_tasks INTO x_task_rec_version_number;
9938: IF p_calling_module NOT IN ( 'FORMS', 'AMG' ) AND cur_pa_tasks%FOUND THEN
9939: --Added condition to call this api from forms and AMG apis.
9940: --Since forms and AMG already deletes from pa_tasks
9941: --we do not have to call the following api again.
9942:

Line 9940: --Since forms and AMG already deletes from pa_tasks

9936: OPEN cur_pa_tasks( l_proj_element_id );
9937: FETCH cur_pa_tasks INTO x_task_rec_version_number;
9938: IF p_calling_module NOT IN ( 'FORMS', 'AMG' ) AND cur_pa_tasks%FOUND THEN
9939: --Added condition to call this api from forms and AMG apis.
9940: --Since forms and AMG already deletes from pa_tasks
9941: --we do not have to call the following api again.
9942:
9943: --hsiu: bug 2800553: for deleteing structure performance improvement changes
9944: IF (p_calling_module = 'DEL_STRUCT') THEN

Line 9961: CLOSE cur_pa_tasks;

9957:
9958: If (l_err_code <> 0) THEN
9959: PA_UTILS.ADD_MESSAGE(p_app_short_name => 'PA',
9960: p_msg_name => substrb(l_err_stage,1,30)); --3935874 : Changed Substr to Substrb
9961: CLOSE cur_pa_tasks;
9962: raise FND_API.G_EXC_ERROR;
9963: END IF;
9964: END IF; --called_from_api chk.
9965: CLOSE cur_pa_tasks;

Line 9965: CLOSE cur_pa_tasks;

9961: CLOSE cur_pa_tasks;
9962: raise FND_API.G_EXC_ERROR;
9963: END IF;
9964: END IF; --called_from_api chk.
9965: CLOSE cur_pa_tasks;
9966:
9967: -- hsiu: bug 2800553: commented for performance improvement
9968: -- PA_TASKS_MAINT_PUB.DELETE_TASK(
9969: -- p_api_version => p_api_version

Line 9968: -- PA_TASKS_MAINT_PUB.DELETE_TASK(

9964: END IF; --called_from_api chk.
9965: CLOSE cur_pa_tasks;
9966:
9967: -- hsiu: bug 2800553: commented for performance improvement
9968: -- PA_TASKS_MAINT_PUB.DELETE_TASK(
9969: -- p_api_version => p_api_version
9970: -- ,p_init_msg_list => p_init_msg_list
9971: -- ,p_commit => p_commit
9972: -- ,p_validate_only => p_validate_only

Line 10270: SET display_sequence = PA_TASKS_MAINT_UTILS.REARRANGE_DISPLAY_SEQ(display_sequence, 0, l_task_cnt, 'DELETE', 'DOWN')

10266:
10267:
10268: BEGIN
10269: UPDATE PA_PROJ_ELEMENT_VERSIONS
10270: SET display_sequence = PA_TASKS_MAINT_UTILS.REARRANGE_DISPLAY_SEQ(display_sequence, 0, l_task_cnt, 'DELETE', 'DOWN')
10271: -- record_version_number = record_version_number + 1
10272: WHERE parent_structure_version_id = x_parent_struc_ver_id
10273: AND (display_sequence > l_selected_seq_num)
10274: AND PA_PROJ_ELEMENTS_UTILS.link_flag ( proj_element_id ) = 'N';

Line 10450: and c.object_type_to = 'PA_TASKS'

10446: where a.parent_structure_version_id = b.element_version_id
10447: and a.project_id = b.project_id
10448: and a.proj_element_id = p_task_id
10449: and a.element_version_id = c.object_id_to1
10450: and c.object_type_to = 'PA_TASKS'
10451: and c.relationship_type = 'S'
10452: and b.status_code <> 'STRUCTURE_PUBLISHED'
10453: and 1 = c_option
10454: UNION

Line 10463: and c.object_type_to = 'PA_TASKS'

10459: where a.parent_structure_version_id = b.element_version_id
10460: and a.project_id = b.project_id
10461: and a.proj_element_id = p_task_id
10462: and a.element_version_id = c.object_id_to1
10463: and c.object_type_to = 'PA_TASKS'
10464: and c.relationship_type = 'S'
10465: and b.status_code = 'STRUCTURE_PUBLISHED'
10466: and 2 = c_option;
10467: l_working_ver_id NUMBER;

Line 10505: and object_type_to = 'PA_TASKS';

10501: update pa_object_relationships
10502: set WEIGHTING_PERCENTAGE = p_weighting
10503: where object_id_to1 = l_working_ver_id
10504: and relationship_type = 'S'
10505: and object_type_to = 'PA_TASKS';
10506: --pro-rate peer task weightings
10507: PA_TASK_PVT1.RECALC_TASKS_WEIGHTING(
10508: p_task_version_id => l_working_parent_id
10509: ,x_return_status => x_return_status

Line 10558: AND object_type = 'PA_TASKS')

10554: FROM pa_proj_element_versions ppev
10555: WHERE ppev.proj_element_id = p_task_id
10556: AND ppev.parent_structure_version_id = c_parent_structure_version_id
10557: AND project_id = p_project_id
10558: AND object_type = 'PA_TASKS')
10559: connect by object_id_from1 = prior object_id_to1
10560: and relationship_type = prior relationship_type --bug 3919266
10561: and relationship_type = 'S'
10562: ) pobj

Line 10763: WHERE object_type_from IN ('PA_TASKS', 'PA_STRUCTURES')

10759: CURSOR cur_get_parent_tasks(c_elem_ver_id number)
10760: IS
10761: SELECT object_id_from1
10762: FROM pa_object_relationships
10763: WHERE object_type_from IN ('PA_TASKS', 'PA_STRUCTURES')
10764: AND object_type_to = 'PA_TASKS'
10765: AND relationship_type ='S'
10766: CONNECT BY PRIOR OBJECT_ID_FROM1 = OBJECT_ID_TO1
10767: AND PRIOR relationship_type = relationship_type --bug 3919266

Line 10764: AND object_type_to = 'PA_TASKS'

10760: IS
10761: SELECT object_id_from1
10762: FROM pa_object_relationships
10763: WHERE object_type_from IN ('PA_TASKS', 'PA_STRUCTURES')
10764: AND object_type_to = 'PA_TASKS'
10765: AND relationship_type ='S'
10766: CONNECT BY PRIOR OBJECT_ID_FROM1 = OBJECT_ID_TO1
10767: AND PRIOR relationship_type = relationship_type --bug 3919266
10768: AND relationship_type = 'S'

Line 10955: FROM pa_tasks a,

10951: b.element_version_id,
10952: b.display_sequence ,
10953: b.level_sequence,
10954: DECODE( b.element_version_id, P_ELEM_VER_ID , 1 , 0 )
10955: FROM pa_tasks a,
10956: pa_proj_element_versions b
10957: WHERE a.task_id = b.proj_element_id
10958: AND b.parent_structure_version_id = p_parent_struct_ver_id
10959: AND b.display_sequence = t_disp_seq;

Line 11038: AND por.object_type_to = 'PA_TASKS'

11034: pa_proj_elem_ver_schedule ppevs,
11035: pa_proj_elements ppe,
11036: pa_task_types ptt
11037: WHERE ppev.parent_structure_version_id = c_parent_struc_ver_id -- 377522
11038: AND por.object_type_to = 'PA_TASKS'
11039: AND por.relationship_type = 'S'
11040: AND por.object_type_from IN ('PA_STRUCTURES', 'PA_TASKS')
11041: AND ppev.element_version_id = por.object_id_to1
11042: AND ppev.proj_element_id = ppe.proj_element_id

Line 11040: AND por.object_type_from IN ('PA_STRUCTURES', 'PA_TASKS')

11036: pa_task_types ptt
11037: WHERE ppev.parent_structure_version_id = c_parent_struc_ver_id -- 377522
11038: AND por.object_type_to = 'PA_TASKS'
11039: AND por.relationship_type = 'S'
11040: AND por.object_type_from IN ('PA_STRUCTURES', 'PA_TASKS')
11041: AND ppev.element_version_id = por.object_id_to1
11042: AND ppev.proj_element_id = ppe.proj_element_id
11043: AND ppev.element_version_id = ppevs.element_version_id
11044: --AND ppe.project_id = 27049

Line 11046: AND ptt.object_type = 'PA_TASKS' ;

11042: AND ppev.proj_element_id = ppe.proj_element_id
11043: AND ppev.element_version_id = ppevs.element_version_id
11044: --AND ppe.project_id = 27049
11045: AND ppe.TYPE_ID = ptt.task_type_id
11046: AND ptt.object_type = 'PA_TASKS' ;
11047: l_index NUMBER ;
11048: l_parent_struc_ver_id NUMBER ;
11049: TYPE c_array
11050: IS

Line 11095: IF ( l_arr_elem_object_type(l_arr_elem_ver_id(i)) = 'PA_TASKS') THEN

11091: END LOOP;
11092: CLOSE c1;
11093: FOR i IN l_arr_elem_ver_id.first..l_arr_elem_ver_id.last
11094: LOOP
11095: IF ( l_arr_elem_object_type(l_arr_elem_ver_id(i)) = 'PA_TASKS') THEN
11096: IF l_arr_parent_sum_duration(l_arr_parent_ver_id(l_arr_elem_ver_id(i))) <> 0 THEN
11097: l_arr_elem_weight(l_arr_elem_ver_id(i)) := ( l_arr_elem_duration(l_arr_elem_ver_id(i)) / l_arr_parent_sum_duration(l_arr_parent_ver_id(l_arr_elem_ver_id(i)))) * 100;
11098: ELSE
11099: l_arr_elem_weight(l_arr_elem_ver_id(i)) := (1 / l_arr_parent_child_count(l_arr_parent_ver_id(l_arr_elem_ver_id(i))))* 100;

Line 11121: AND por.object_type_from IN ('PA_STRUCTURES', 'PA_TASKS') ;

11117: SET weighting_percentage = l_arr_elem_weight_02(i)
11118: -- SET weighting_percentage = ( l_arr_elem_duration(l_arr_elem_ver_id(i)) / l_arr_parent_sum_duration(l_arr_parent_ver_id(l_arr_elem_ver_id(i)))) * 100
11119: WHERE object_id_to1 = l_arr_elem_ver_id(i)
11120: AND por.relationship_type = 'S'
11121: AND por.object_type_from IN ('PA_STRUCTURES', 'PA_TASKS') ;
11122:
11123: IF (p_commit = FND_API.G_TRUE) THEN
11124: commit;
11125: END IF;