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_PROJECT_PVT dependencies on PA_TASKS

Line 1282: from pa_tasks

1278:
1279: CURSOR get_gen_etc_source_code (l_task_id NUMBER, l_project_id NUMBER)
1280: IS
1281: select gen_etc_source_code
1282: from pa_tasks
1283: where
1284: task_id = l_task_id
1285: and project_id = l_project_id ;
1286: --End BUG 3924597, added by rtarway for etc source default

Line 1294: FROM pa_tasks t

1290: (p_project_id NUMBER
1291: ,p_pm_task_reference VARCHAR2)
1292: IS
1293: SELECT t.TOP_TASK_ID
1294: FROM pa_tasks t
1295: WHERE t.project_id = p_project_id
1296: AND t.pm_task_reference = p_pm_task_reference;
1297:
1298:

Line 1304: FROM pa_tasks t

1300: (p_project_id NUMBER
1301: ,p_task_id NUMBER)
1302: IS
1303: SELECT t.TOP_TASK_ID
1304: FROM pa_tasks t
1305: WHERE t.project_id = p_project_id
1306: AND t.task_id = p_task_id;
1307:
1308: l_parent_TOP_TASK_ID pa_tasks.TOP_TASK_ID%type;

Line 1308: l_parent_TOP_TASK_ID pa_tasks.TOP_TASK_ID%type;

1304: FROM pa_tasks t
1305: WHERE t.project_id = p_project_id
1306: AND t.task_id = p_task_id;
1307:
1308: l_parent_TOP_TASK_ID pa_tasks.TOP_TASK_ID%type;
1309: --End of addition for 4378507
1310: -- Added for bug# 4689326
1311: CURSOR l_customer_parent_task (l_p_parent_task_id NUMBER) IS
1312: SELECT customer_id FROM pa_tasks WHERE task_id=l_p_parent_task_id;

Line 1312: SELECT customer_id FROM pa_tasks WHERE task_id=l_p_parent_task_id;

1308: l_parent_TOP_TASK_ID pa_tasks.TOP_TASK_ID%type;
1309: --End of addition for 4378507
1310: -- Added for bug# 4689326
1311: CURSOR l_customer_parent_task (l_p_parent_task_id NUMBER) IS
1312: SELECT customer_id FROM pa_tasks WHERE task_id=l_p_parent_task_id;
1313:
1314: BEGIN
1315:
1316: -- Standard begin of API savepoint

Line 1986: p_desc_flex_name => 'PA_TASKS_DESC_FLEX'

1982: END IF;
1983:
1984: --bug 6153503 added below validation.
1985: pa_task_utils.validate_flex_fields(
1986: p_desc_flex_name => 'PA_TASKS_DESC_FLEX'
1987: ,p_attribute_category => l_attribute_category
1988: ,p_attribute1 => l_attribute1
1989: ,p_attribute2 => l_attribute2
1990: ,p_attribute3 => l_attribute3

Line 2267: SELECT pa_tasks_s.nextval

2263:
2264:
2265: --get the unique task id from the Oracle Sequence
2266:
2267: SELECT pa_tasks_s.nextval
2268: INTO l_task_id
2269: FROM DUAL;
2270: /* dbms_output.put_line('Task ID:'||l_task_id); */
2271:

Line 2384: INSERT INTO pa_tasks

2380: END IF;
2381:
2382: -- End of Addition for Bug 4378507.
2383:
2384: INSERT INTO pa_tasks
2385: ( task_id
2386: ,project_id
2387: ,pm_task_reference
2388: ,task_number

Line 2661: FROM pa_tasks t

2657: (p_project_id NUMBER
2658: ,p_pm_task_reference VARCHAR2)
2659: IS
2660: SELECT *
2661: FROM pa_tasks t
2662: WHERE t.project_id = p_project_id
2663: AND t.pm_task_reference = p_pm_task_reference;
2664:
2665: --*O

Line 2671: FROM pa_tasks t

2667: (p_project_id NUMBER
2668: ,p_task_id NUMBER)
2669: IS
2670: SELECT *
2671: FROM pa_tasks t
2672: WHERE t.project_id = p_project_id
2673: AND t.task_id = p_task_id;
2674:
2675:

Line 2722: (p_pa_task_id pa_tasks.task_id%type)

2718: FROM pa_projects p
2719: WHERE p.project_id = p_pa_project_id;
2720:
2721: CURSOR l_amg_task_csr
2722: (p_pa_task_id pa_tasks.task_id%type)
2723: IS
2724: SELECT task_number
2725: FROM pa_tasks p
2726: WHERE p.task_id = p_pa_task_id;

Line 2725: FROM pa_tasks p

2721: CURSOR l_amg_task_csr
2722: (p_pa_task_id pa_tasks.task_id%type)
2723: IS
2724: SELECT task_number
2725: FROM pa_tasks p
2726: WHERE p.task_id = p_pa_task_id;
2727:
2728: BEGIN
2729:

Line 2845: UPDATE PA_TASKS

2841: THEN l_task_in_rec.ready_to_distribute_flag := 'Y';
2842: END IF;
2843:
2844:
2845: UPDATE PA_TASKS
2846: SET
2847: wbs_level = l_wbs_level
2848: ,top_task_id = l_top_task_id
2849: ,parent_task_id = l_parent_task_id

Line 2862: from pa_tasks where task_id =l_parent_task_id; /* added for bug 7495993 */

2858: l_top_task_id := l_parent_task_rec.top_task_id;
2859: l_parent_task_id := l_parent_task_rec.task_id;
2860:
2861: select customer_id into l_customer_id
2862: from pa_tasks where task_id =l_parent_task_id; /* added for bug 7495993 */
2863:
2864: IF l_task_in_rec.service_type_code = PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
2865: OR l_task_in_rec.service_type_code IS NULL
2866: THEN

Line 3050: UPDATE PA_TASKS

3046: END IF;
3047:
3048: /* Patch ends for the bug # 878682 */
3049:
3050: UPDATE PA_TASKS
3051: SET
3052: wbs_level = l_wbs_level
3053: ,top_task_id = l_top_task_id
3054: ,parent_task_id = l_parent_task_id

Line 3085: UPDATE pa_tasks

3081:
3082: -- Update chargeable_flag for parent if chargeable_flag = 'Y' since
3083: -- we have now created a sub-task
3084: IF l_parent_task_rec.chargeable_flag = 'Y' THEN
3085: UPDATE pa_tasks
3086: SET chargeable_flag = 'N'
3087: WHERE task_id = l_parent_task_rec.task_id;
3088: END IF;
3089:

Line 3097: UPDATE pa_tasks

3093: --bug 4279634
3094: --if a lowest level task has sub-projects then make the chargeable flag to 'N'
3095: IF PA_RELATIONSHIP_UTILS.check_task_has_sub_proj(l_project_id,l_task_id,null) = 'Y'
3096: THEN
3097: UPDATE pa_tasks
3098: SET chargeable_flag = 'N'
3099: WHERE task_id = l_task_id;
3100: END IF;
3101: --end bug 4279634

Line 3109: CURSOR cur_pa_tasks

3105:
3106: IF p_create_task_structure <> 'N' THEN -- Performance changes. Bug 2931183
3107: -- Donot do any structures processing in bulk calling context ie from create_project.
3108: DECLARE
3109: CURSOR cur_pa_tasks
3110: IS
3111: SELECT task_number, long_task_name, description, --bug 2833194
3112: parent_task_id,carrying_out_organization_id,
3113: pm_task_reference, address_id, task_manager_person_id

Line 3114: FROM pa_tasks

3110: IS
3111: SELECT task_number, long_task_name, description, --bug 2833194
3112: parent_task_id,carrying_out_organization_id,
3113: pm_task_reference, address_id, task_manager_person_id
3114: FROM pa_tasks
3115: WHERE project_id = l_project_id
3116: AND task_id = l_task_id;
3117:
3118: l_pa_tasks_rec cur_pa_tasks%ROWTYPE;

Line 3118: l_pa_tasks_rec cur_pa_tasks%ROWTYPE;

3114: FROM pa_tasks
3115: WHERE project_id = l_project_id
3116: AND task_id = l_task_id;
3117:
3118: l_pa_tasks_rec cur_pa_tasks%ROWTYPE;
3119: v_task_id_above NUMBER;
3120: l_msg_count NUMBER ;
3121: l_msg_data VARCHAR2(2000);
3122: l_return_status VARCHAR2(1);

Line 3177: OPEN cur_pa_tasks;

3173: END IF;
3174:
3175: IF l_task_id IS NOT NULL
3176: THEN
3177: OPEN cur_pa_tasks;
3178: FETCH cur_pa_tasks INTO l_pa_tasks_rec;
3179: CLOSE cur_pa_tasks;
3180:
3181: --bug 6153503 added below code

Line 3178: FETCH cur_pa_tasks INTO l_pa_tasks_rec;

3174:
3175: IF l_task_id IS NOT NULL
3176: THEN
3177: OPEN cur_pa_tasks;
3178: FETCH cur_pa_tasks INTO l_pa_tasks_rec;
3179: CLOSE cur_pa_tasks;
3180:
3181: --bug 6153503 added below code
3182: IF l_task_in_rec.tasks_dff = 'Y' THEN

Line 3179: CLOSE cur_pa_tasks;

3175: IF l_task_id IS NOT NULL
3176: THEN
3177: OPEN cur_pa_tasks;
3178: FETCH cur_pa_tasks INTO l_pa_tasks_rec;
3179: CLOSE cur_pa_tasks;
3180:
3181: --bug 6153503 added below code
3182: IF l_task_in_rec.tasks_dff = 'Y' THEN
3183: l_validate_dff := 'N';

Line 3226: ,p_parent_task_id => l_pa_tasks_rec.parent_task_id

3222: PA_PROJ_TASK_STRUC_PUB.CREATE_TASK_STRUCTURE(
3223: p_calling_module => 'AMG'
3224: ,p_project_id => l_project_id
3225: ,p_task_id => l_task_id
3226: ,p_parent_task_id => l_pa_tasks_rec.parent_task_id
3227: ,p_ref_task_id => v_task_id_above
3228: ,p_task_number => l_pa_tasks_rec.task_number
3229: ,p_task_name => l_pa_tasks_rec.long_task_name --bug 2833194
3230: ,p_task_description => l_pa_tasks_rec.description

Line 3228: ,p_task_number => l_pa_tasks_rec.task_number

3224: ,p_project_id => l_project_id
3225: ,p_task_id => l_task_id
3226: ,p_parent_task_id => l_pa_tasks_rec.parent_task_id
3227: ,p_ref_task_id => v_task_id_above
3228: ,p_task_number => l_pa_tasks_rec.task_number
3229: ,p_task_name => l_pa_tasks_rec.long_task_name --bug 2833194
3230: ,p_task_description => l_pa_tasks_rec.description
3231: ,p_carrying_out_organization_id => l_pa_tasks_rec.carrying_out_organization_id
3232: ,p_structure_type => 'FINANCIAL'

Line 3229: ,p_task_name => l_pa_tasks_rec.long_task_name --bug 2833194

3225: ,p_task_id => l_task_id
3226: ,p_parent_task_id => l_pa_tasks_rec.parent_task_id
3227: ,p_ref_task_id => v_task_id_above
3228: ,p_task_number => l_pa_tasks_rec.task_number
3229: ,p_task_name => l_pa_tasks_rec.long_task_name --bug 2833194
3230: ,p_task_description => l_pa_tasks_rec.description
3231: ,p_carrying_out_organization_id => l_pa_tasks_rec.carrying_out_organization_id
3232: ,p_structure_type => 'FINANCIAL'
3233: ,P_PM_SOURCE_CODE => p_project_rec.pm_product_code

Line 3230: ,p_task_description => l_pa_tasks_rec.description

3226: ,p_parent_task_id => l_pa_tasks_rec.parent_task_id
3227: ,p_ref_task_id => v_task_id_above
3228: ,p_task_number => l_pa_tasks_rec.task_number
3229: ,p_task_name => l_pa_tasks_rec.long_task_name --bug 2833194
3230: ,p_task_description => l_pa_tasks_rec.description
3231: ,p_carrying_out_organization_id => l_pa_tasks_rec.carrying_out_organization_id
3232: ,p_structure_type => 'FINANCIAL'
3233: ,P_PM_SOURCE_CODE => p_project_rec.pm_product_code
3234: ,P_PM_SOURCE_reference => l_pa_tasks_rec.pm_task_reference

Line 3231: ,p_carrying_out_organization_id => l_pa_tasks_rec.carrying_out_organization_id

3227: ,p_ref_task_id => v_task_id_above
3228: ,p_task_number => l_pa_tasks_rec.task_number
3229: ,p_task_name => l_pa_tasks_rec.long_task_name --bug 2833194
3230: ,p_task_description => l_pa_tasks_rec.description
3231: ,p_carrying_out_organization_id => l_pa_tasks_rec.carrying_out_organization_id
3232: ,p_structure_type => 'FINANCIAL'
3233: ,P_PM_SOURCE_CODE => p_project_rec.pm_product_code
3234: ,P_PM_SOURCE_reference => l_pa_tasks_rec.pm_task_reference
3235: ,p_location_id => l_pa_tasks_rec.address_id

Line 3234: ,P_PM_SOURCE_reference => l_pa_tasks_rec.pm_task_reference

3230: ,p_task_description => l_pa_tasks_rec.description
3231: ,p_carrying_out_organization_id => l_pa_tasks_rec.carrying_out_organization_id
3232: ,p_structure_type => 'FINANCIAL'
3233: ,P_PM_SOURCE_CODE => p_project_rec.pm_product_code
3234: ,P_PM_SOURCE_reference => l_pa_tasks_rec.pm_task_reference
3235: ,p_location_id => l_pa_tasks_rec.address_id
3236: ,p_manager_person_id => l_pa_tasks_rec.task_manager_person_id
3237: ,x_task_version_id => l_task_version_id
3238: ,x_task_id => l_new_task_id -- 4537865 Replaced l_task_id with l_new_task_id

Line 3235: ,p_location_id => l_pa_tasks_rec.address_id

3231: ,p_carrying_out_organization_id => l_pa_tasks_rec.carrying_out_organization_id
3232: ,p_structure_type => 'FINANCIAL'
3233: ,P_PM_SOURCE_CODE => p_project_rec.pm_product_code
3234: ,P_PM_SOURCE_reference => l_pa_tasks_rec.pm_task_reference
3235: ,p_location_id => l_pa_tasks_rec.address_id
3236: ,p_manager_person_id => l_pa_tasks_rec.task_manager_person_id
3237: ,x_task_version_id => l_task_version_id
3238: ,x_task_id => l_new_task_id -- 4537865 Replaced l_task_id with l_new_task_id
3239: --for shared structures

Line 3236: ,p_manager_person_id => l_pa_tasks_rec.task_manager_person_id

3232: ,p_structure_type => 'FINANCIAL'
3233: ,P_PM_SOURCE_CODE => p_project_rec.pm_product_code
3234: ,P_PM_SOURCE_reference => l_pa_tasks_rec.pm_task_reference
3235: ,p_location_id => l_pa_tasks_rec.address_id
3236: ,p_manager_person_id => l_pa_tasks_rec.task_manager_person_id
3237: ,x_task_version_id => l_task_version_id
3238: ,x_task_id => l_new_task_id -- 4537865 Replaced l_task_id with l_new_task_id
3239: --for shared structures
3240: ,p_OBLIGATION_START_DATE => l_task_in_rec.OBLIGATION_START_DATE

Line 3435: pa_tasks

3431:
3432: CURSOR c_task_csr IS
3433: SELECT task_id
3434: FROM
3435: pa_tasks
3436: WHERE project_id = p_pa_project_id
3437: AND pm_task_reference = p_pm_task_reference;
3438:
3439: l_task_rec c_task_csr%ROWTYPE;

Line 3638: FROM pa_tasks

3634:
3635: CURSOR l_task_id_csr
3636: IS
3637: SELECT 'X'
3638: FROM pa_tasks
3639: WHERE task_id = p_pa_task_id
3640: AND project_id = p_pa_project_id;
3641:
3642:

Line 3861: FROM pa_tasks

3857:
3858: CURSOR l_task_id_csr
3859: IS
3860: SELECT 'X'
3861: FROM pa_tasks
3862: WHERE task_id = p_pa_task_id
3863: AND project_id = p_pa_project_id;
3864:
3865: CURSOR l_proj_element_id_csr

Line 3886: AND OBJECT_TYPE = 'PA_TASKS';

3882: WHERE ppe.proj_element_id = ppst.proj_element_id
3883: AND ppe.project_id = p_pa_project_id
3884: AND ppst.structure_type_id = pst.structure_type_id
3885: AND pst.structure_type = p_structure_type)
3886: AND OBJECT_TYPE = 'PA_TASKS';
3887:
3888: l_api_name CONSTANT VARCHAR2(30) := 'Convert_pm_taskref_to_id_all';
3889: l_task_id NUMBER ;
3890: l_dummy VARCHAR2(1);

Line 4520: pa_tasks

4516: top_task_id,
4517: TASK_NAME,
4518: PM_TASK_REFERENCE
4519: FROM
4520: pa_tasks
4521: WHERE task_id = p_task_id;
4522:
4523: CURSOR l_get_lower_task_det_csr (l_project_id IN NUMBER,
4524: l_task_id IN NUMBER )

Line 4527: FROM pa_tasks

4523: CURSOR l_get_lower_task_det_csr (l_project_id IN NUMBER,
4524: l_task_id IN NUMBER )
4525: IS
4526: SELECT task_id
4527: FROM pa_tasks
4528: WHERE project_id = l_project_id
4529: AND parent_task_id = l_task_id;
4530:
4531: l_task_rec l_get_task_det_csr%ROWTYPE;

Line 4555: (p_pa_task_id pa_tasks.task_id%type)

4551: FROM pa_projects p
4552: WHERE p.project_id = p_pa_project_id;
4553:
4554: CURSOR l_amg_task_csr
4555: (p_pa_task_id pa_tasks.task_id%type)
4556: IS
4557: SELECT task_number
4558: FROM pa_tasks p
4559: WHERE p.task_id = p_pa_task_id;

Line 4558: FROM pa_tasks p

4554: CURSOR l_amg_task_csr
4555: (p_pa_task_id pa_tasks.task_id%type)
4556: IS
4557: SELECT task_number
4558: FROM pa_tasks p
4559: WHERE p.task_id = p_pa_task_id;
4560:
4561: BEGIN
4562:

Line 4626: UPDATE pa_tasks

4622: -- hence update all first line children as follows
4623: -- parent task id = the parent task id of the task that is
4624: -- being deleted
4625:
4626: UPDATE pa_tasks
4627: SET parent_task_id = l_task_rec.parent_task_id,
4628: wbs_level = Decode(wbs_level,1,1,wbs_level-1)
4629: WHERE project_id = l_task_rec.project_id
4630: AND parent_task_id = l_task_rec.task_id;

Line 4687: DELETE FROM pa_tasks WHERE task_id = p_task_id;

4683: DELETE FROM pa_project_asset_assignments WHERE task_id = p_task_id;
4684:
4685: DELETE FROM pa_percent_completes WHERE task_id = p_task_id;
4686:
4687: DELETE FROM pa_tasks WHERE task_id = p_task_id;
4688:
4689: p_return_status := FND_API.G_RET_STS_SUCCESS;
4690:
4691: EXCEPTION

Line 5096: FROM pa_tasks

5092:
5093: CURSOR l_task_rec_csr (l_project_id NUMBER ,l_task_id NUMBER)
5094: IS
5095: SELECT *
5096: FROM pa_tasks
5097: WHERE project_id = l_project_id
5098: AND task_id = l_task_id;
5099:
5100: CURSOR l_check_child_exists_csr (l_project_id NUMBER,l_task_id NUMBER )

Line 5103: PA_TASKS

5099:
5100: CURSOR l_check_child_exists_csr (l_project_id NUMBER,l_task_id NUMBER )
5101: IS
5102: SELECT 'x' FROM
5103: PA_TASKS
5104: WHERE project_id = l_project_id
5105: AND parent_task_id = l_task_id;
5106:
5107: CURSOR l_outer_child_dates_csr (l_project_id NUMBER,l_task_id NUMBER)

Line 5111: FROM pa_tasks

5107: CURSOR l_outer_child_dates_csr (l_project_id NUMBER,l_task_id NUMBER)
5108: IS
5109: SELECT MIN(TRUNC(start_date))
5110: , MAX(TRUNC(completion_date)) -- Bug Fix 4705139
5111: FROM pa_tasks
5112: WHERE project_id = l_project_id
5113: AND parent_task_id = l_task_id;
5114:
5115: CURSOR l_outer_parent_dates_csr (l_project_id NUMBER,l_task_id NUMBER)

Line 5119: FROM pa_tasks

5115: CURSOR l_outer_parent_dates_csr (l_project_id NUMBER,l_task_id NUMBER)
5116: IS
5117: SELECT MIN(TRUNC(start_date))
5118: , MAX(TRUNC(completion_date)) -- Bug Fix 4705139
5119: FROM pa_tasks
5120: WHERE project_id = l_project_id
5121: AND task_id = l_task_id;
5122:
5123: CURSOR l_project_date_csr (l_project_id NUMBER )

Line 5132: FROM pa_tasks

5128:
5129: CURSOR l_top_task_csr (p_task_id NUMBER)
5130: IS
5131: SELECT top_task_id
5132: FROM pa_tasks
5133: WHERE task_id = p_task_id;
5134:
5135: --needed to convert pm_parent_task_reference to parent_task_id
5136: --convert_pm_taskref_to_id can not be used because parent_id can be NULL

Line 5141: FROM pa_tasks

5137:
5138: CURSOR l_convert_pm_parent_to_id_csr( p_project_id NUMBER, p_pm_task_reference VARCHAR2 )
5139: IS
5140: SELECT task_id
5141: FROM pa_tasks
5142: WHERE pm_task_reference = p_pm_task_reference
5143: AND project_id = p_project_id;
5144:
5145: CURSOR l_parent_wbs_csr ( p_project_id NUMBER, p_pa_task_id NUMBER )

Line 5148: FROM pa_tasks

5144:
5145: CURSOR l_parent_wbs_csr ( p_project_id NUMBER, p_pa_task_id NUMBER )
5146: IS
5147: SELECT wbs_level
5148: FROM pa_tasks
5149: WHERE task_id = p_pa_task_id
5150: AND project_id = p_project_id;
5151:
5152: CURSOR l_validate_parent_id_csr( p_project_id NUMBER, p_task_id NUMBER)

Line 5155: FROM pa_tasks

5151:
5152: CURSOR l_validate_parent_id_csr( p_project_id NUMBER, p_task_id NUMBER)
5153: IS
5154: SELECT 'x'
5155: FROM pa_tasks
5156: WHERE task_id = p_task_id
5157: AND project_id = p_project_id;
5158:
5159: CURSOR l_lock_rows_csr( p_task_id NUMBER)

Line 5162: FROM pa_tasks

5158:
5159: CURSOR l_lock_rows_csr( p_task_id NUMBER)
5160: IS
5161: SELECT 'x'
5162: FROM pa_tasks
5163: WHERE task_id = p_task_id
5164: FOR UPDATE NOWAIT;
5165:
5166: -- Used when parent_id is changed, and the task (and it's children) is on a different wbs level

Line 5171: FROM pa_tasks

5167:
5168: CURSOR l_wbs_level_csr( p_task_id NUMBER)
5169: IS
5170: SELECT task_id
5171: FROM pa_tasks
5172: START WITH task_id=p_task_id
5173: CONNECT BY PRIOR task_id=parent_task_id
5174: FOR UPDATE NOWAIT;
5175:

Line 5182: FROM pa_tasks

5178:
5179: CURSOR l_chk_chlds_parent_id_csr( p_task_id NUMBER, p_new_parent_task_id NUMBER)
5180: IS
5181: SELECT 'x'
5182: FROM pa_tasks
5183: WHERE task_id=p_new_parent_task_id
5184: START WITH task_id=p_task_id
5185: CONNECT BY PRIOR task_id=parent_task_id
5186: FOR UPDATE NOWAIT;

Line 5235: (p_pa_task_id pa_tasks.task_id%type)

5231: FROM pa_projects p
5232: WHERE p.project_id = p_pa_project_id;
5233:
5234: CURSOR l_amg_task_csr
5235: (p_pa_task_id pa_tasks.task_id%type)
5236: IS
5237: SELECT task_number
5238: FROM pa_tasks p
5239: WHERE p.task_id = p_pa_task_id;

Line 5238: FROM pa_tasks p

5234: CURSOR l_amg_task_csr
5235: (p_pa_task_id pa_tasks.task_id%type)
5236: IS
5237: SELECT task_number
5238: FROM pa_tasks p
5239: WHERE p.task_id = p_pa_task_id;
5240:
5241: -- Fix for Bug # 1335417
5242: -- needed for update of Fixed Date( p_cost_ind_sch_fixed_date)

Line 5696: l_statement := ' UPDATE PA_TASKS SET ';

5692: CLOSE l_check_child_exists_csr;
5693:
5694: -- Building the dynamic SQL statement
5695:
5696: l_statement := ' UPDATE PA_TASKS SET ';
5697:
5698: -- TASK REFERENCE
5699:
5700: IF p_pm_task_reference <> PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR

Line 6318: PA_TASKS_MAINT_UTILS.Check_Start_Date_EI(

6314: END IF;
6315: END IF; -- End if pa_project_pub.G_ParChildTsk_chks_deferred
6316:
6317: --BUG 4081329 rtarway, validate for EI date also
6318: PA_TASKS_MAINT_UTILS.Check_Start_Date_EI(
6319: p_project_id => l_project_id,
6320: p_task_id => l_task_id,
6321: p_start_date => p_task_start_date,
6322: x_return_status => l_return_status,

Line 6414: PA_TASKS_MAINT_UTILS.Check_End_Date_EI(

6410:
6411: --BUG 4081329, rtarway
6412: -- Validate for END EI dates too
6413:
6414: PA_TASKS_MAINT_UTILS.Check_End_Date_EI(
6415: p_project_id => l_project_id,
6416: p_task_id => l_task_id,
6417: p_end_date => p_task_completion_date,
6418: x_return_status => l_return_status,

Line 6584: --pa_tasks. In regular flow for updating parent of a task we call this api

6580: --The following code should be executed when a task's parent is modified
6581: --in a working version( with already existing a published ver ) and
6582: --then its published.
6583: --In other words the code is executed while publishing to sync up with
6584: --pa_tasks. In regular flow for updating parent of a task we call this api
6585: --from the wrapper process_task_structure_bulk api.
6586: --
6587: IF p_pm_product_code = 'WORKPLAN'
6588: THEN

Line 6767: UPDATE pa_tasks

6763: FETCH l_wbs_level_csr INTO l_wbs_change_task_id;
6764:
6765: WHILE l_wbs_level_csr%FOUND LOOP
6766:
6767: UPDATE pa_tasks
6768: SET wbs_level = wbs_level + l_delta_level
6769: WHERE task_id = l_wbs_change_task_id;
6770:
6771: FETCH l_wbs_level_csr INTO l_wbs_change_task_id;

Line 6948: FROM PA_TASKS

6944: SELECT PROJECT_TYPE
6945: INTO l_project_type2
6946: FROM PA_PROJECTS
6947: WHERE PROJECT_ID IN (SELECT PROJECT_ID
6948: FROM PA_TASKS
6949: WHERE TASK_ID = p_pa_task_id);
6950: END IF;
6951: EXCEPTION
6952: WHEN OTHERS THEN

Line 6966: p_desc_flex_name => 'PA_TASKS_DESC_FLEX'

6962: --BUG 3908013, rtarway, Validate for financial dff
6963: --bug 6153503
6964: IF l_project_type2 <> 'AWARD_PROJECT' THEN /* Bug 7403227*/
6965: pa_task_utils.validate_flex_fields(
6966: p_desc_flex_name => 'PA_TASKS_DESC_FLEX'
6967: ,p_attribute_category => l_attribute_category
6968: ,p_attribute1 => l_attribute1
6969: ,p_attribute2 => l_attribute2
6970: ,p_attribute3 => l_attribute3

Line 8633: UPDATE PA_TASKS SET customer_id = p_customer_id

8629: NVL(l_task_rec.customer_id, PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM) <> p_customer_id
8630: THEN
8631: IF l_task_rec.parent_task_id IS NULL THEN
8632: IF l_children_exist ='Y' THEN
8633: UPDATE PA_TASKS SET customer_id = p_customer_id
8634: WHERE top_task_id=l_task_rec.task_id AND not(task_id =l_task_rec.task_id);
8635: END IF;
8636: l_statement := l_statement || ' CUSTOMER_ID = :cust_id ,';
8637: l_cust_id_fg := 'Y';

Line 8799: PA_TASKS_U2 constraint can be overcome.After updating all the tasks in the script,

8795: /* bug #5243018: Reverting the fix in bug 4120380.
8796: DBMS_SQL.BIND_VARIABLE(l_cursor, ':tk_num','-'||p_task_number); */
8797: DBMS_SQL.BIND_VARIABLE(l_cursor, ':tk_num', substrb(p_task_number,1,25)); --bug 5733285
8798: /** CODE CHANGE BY ADITI for Bug 4120380.This is to prefix task_number with '-' so that
8799: PA_TASKS_U2 constraint can be overcome.After updating all the tasks in the script,
8800: code again updates the task_number, trimming the '-' added.**/
8801: END IF;
8802:
8803: IF l_b_tk_st_dt_flag = 'Y' THEN

Line 9096: UPDATE pa_tasks

9092: --if a lowest level task has sub-projects then make the chargeable flag to 'N'
9093: --This should be indepenedent of the above update.
9094: IF PA_RELATIONSHIP_UTILS.check_task_has_sub_proj(l_project_id,l_task_id,null) = 'Y'
9095: THEN
9096: UPDATE pa_tasks
9097: SET chargeable_flag = 'N'
9098: WHERE task_id = l_task_id;
9099: END IF;
9100: --end bug 4279634

Line 9234: FROM pa_tasks

9230:
9231: CURSOR lock_tasks_csr ( p_task_id IN NUMBER )
9232: IS
9233: SELECT 'x'
9234: FROM pa_tasks
9235: START WITH task_id=p_task_id
9236: CONNECT BY PRIOR task_id=parent_task_id
9237: FOR UPDATE NOWAIT;
9238:

Line 9269: (p_pa_task_id pa_tasks.task_id%type)

9265: FROM pa_projects p
9266: WHERE p.project_id = p_pa_project_id;
9267:
9268: CURSOR l_amg_task_csr
9269: (p_pa_task_id pa_tasks.task_id%type)
9270: IS
9271: SELECT task_number
9272: FROM pa_tasks p
9273: WHERE p.task_id = p_pa_task_id;

Line 9272: FROM pa_tasks p

9268: CURSOR l_amg_task_csr
9269: (p_pa_task_id pa_tasks.task_id%type)
9270: IS
9271: SELECT task_number
9272: FROM pa_tasks p
9273: WHERE p.task_id = p_pa_task_id;
9274:
9275: -- 3801426 added local variable
9276: l_task_source_reference VARCHAR2(240);

Line 9279: l_task_id_out pa_tasks.task_id%TYPE;

9275: -- 3801426 added local variable
9276: l_task_source_reference VARCHAR2(240);
9277:
9278: -- 5263429 added local variable
9279: l_task_id_out pa_tasks.task_id%TYPE;
9280:
9281: BEGIN
9282:
9283:

Line 9668: --only deletes from pa_proj_elements. There is a check in pa_task_pvt1.delete_task_version api not to delete from pa_tasks if called from AMG.

9664: CLOSE lock_tasks_csr;
9665:
9666: --bug 2765115
9667:
9668: --only deletes from pa_proj_elements. There is a check in pa_task_pvt1.delete_task_version api not to delete from pa_tasks if called from AMG.
9669: PA_PROJ_TASK_STRUC_PUB.delete_task_structure
9670: (
9671: p_calling_module => 'AMG'
9672: ,p_task_id => l_task_id

Line 10763: FROM pa_tasks

10759:
10760: CURSOR l_tsk_lb_sch_type_task_csr(p_pa_project_id VARCHAR2,p_pa_task_id VARCHAR2)
10761: IS
10762: SELECT labor_sch_type
10763: FROM pa_tasks
10764: where project_id = p_pa_project_id
10765: and task_id= p_pa_task_id;
10766:
10767: CURSOR l_prj_nl_sch_type_csr(p_pa_project_id VARCHAR2)

Line 10776: FROM pa_tasks

10772:
10773: CURSOR l_tsk_nl_sch_type_task_csr(p_pa_project_id VARCHAR2,p_pa_task_id VARCHAR2)
10774: IS
10775: SELECT non_labor_sch_type
10776: FROM pa_tasks
10777: where project_id = p_pa_project_id
10778: and task_id = p_pa_task_id;
10779:
10780: CURSOR l_amg_project_csr(p_pa_project_id pa_projects.project_id%type)

Line 11917: SELECT 'Y' FROM pa_tasks

11913: x_msg_data OUT NOCOPY VARCHAR2 ) IS
11914:
11915: -- Bug 7255015
11916: cursor any_invalid_customer is
11917: SELECT 'Y' FROM pa_tasks
11918: WHERE project_id = p_project_id
11919: AND parent_task_id IS NULL
11920: AND nvl(customer_id, -1) NOT IN (select customer_id
11921: from pa_project_customers