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 1284: from pa_tasks

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

Line 1296: FROM pa_tasks t

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

Line 1306: FROM pa_tasks t

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

Line 1310: l_parent_TOP_TASK_ID pa_tasks.TOP_TASK_ID%type;

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

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

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

Line 1650: FROM pa_tasks

1646: BEGIN
1647: IF (l_task_in_rec.pa_task_id <> PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM) AND (l_task_in_rec.pa_task_id IS NOT NULL) THEN
1648: SELECT parent_task_id
1649: INTO l_pa_parent_task_id
1650: FROM pa_tasks
1651: WHERE task_id = l_task_in_rec.pa_task_id
1652: AND project_id =l_project_id;
1653: ELSE
1654: SELECT parent_task_id

Line 1656: FROM pa_tasks

1652: AND project_id =l_project_id;
1653: ELSE
1654: SELECT parent_task_id
1655: INTO l_pa_parent_task_id
1656: FROM pa_tasks
1657: WHERE task_number = l_task_in_rec.pa_task_number
1658: AND project_id =l_project_id;
1659: END IF;
1660: EXCEPTION -- Added exception as a part of bug 12379321

Line 1685: select adj_on_std_inv into l_adj_on_std_inv from pa_tasks where task_id =l_task_in_rec.pa_parent_task_id;

1681: end if;
1682:
1683: else
1684:
1685: select adj_on_std_inv into l_adj_on_std_inv from pa_tasks where task_id =l_task_in_rec.pa_parent_task_id;
1686:
1687: end if;
1688:
1689: /* Added for 12.2Payroll billing ER 11899223 */

Line 2033: p_desc_flex_name => 'PA_TASKS_DESC_FLEX'

2029: END IF;
2030:
2031: --bug 6153503 added below validation.
2032: pa_task_utils.validate_flex_fields(
2033: p_desc_flex_name => 'PA_TASKS_DESC_FLEX'
2034: ,p_attribute_category => l_attribute_category
2035: ,p_attribute1 => l_attribute1
2036: ,p_attribute2 => l_attribute2
2037: ,p_attribute3 => l_attribute3

Line 2154: p_desc_flex_name => 'PA_TASKS_DESC_FLEX'

2150: END IF;
2151:
2152: --bug 6153503 added below validation.
2153: pa_task_utils.validate_flex_fields(
2154: p_desc_flex_name => 'PA_TASKS_DESC_FLEX'
2155: ,p_attribute_category => l_attribute_category
2156: ,p_attribute1 => l_attribute1
2157: ,p_attribute2 => l_attribute2
2158: ,p_attribute3 => l_attribute3

Line 2436: SELECT pa_tasks_s.nextval

2432:
2433:
2434: --get the unique task id from the Oracle Sequence
2435:
2436: SELECT pa_tasks_s.nextval
2437: INTO l_task_id
2438: FROM DUAL;
2439: /* dbms_output.put_line('Task ID:'||l_task_id); */
2440:

Line 2553: INSERT INTO pa_tasks

2549: END IF;
2550:
2551: -- End of Addition for Bug 4378507.
2552:
2553: INSERT INTO pa_tasks
2554: ( task_id
2555: ,project_id
2556: ,pm_task_reference
2557: ,task_number

Line 2854: FROM pa_tasks t

2850: (p_project_id NUMBER
2851: ,p_pm_task_reference VARCHAR2)
2852: IS
2853: SELECT *
2854: FROM pa_tasks t
2855: WHERE t.project_id = p_project_id
2856: AND t.pm_task_reference = p_pm_task_reference;
2857:
2858: --*O

Line 2864: FROM pa_tasks t

2860: (p_project_id NUMBER
2861: ,p_task_id NUMBER)
2862: IS
2863: SELECT *
2864: FROM pa_tasks t
2865: WHERE t.project_id = p_project_id
2866: AND t.task_id = p_task_id;
2867:
2868:

Line 2915: (p_pa_task_id pa_tasks.task_id%type)

2911: FROM pa_projects p
2912: WHERE p.project_id = p_pa_project_id;
2913:
2914: CURSOR l_amg_task_csr
2915: (p_pa_task_id pa_tasks.task_id%type)
2916: IS
2917: SELECT task_number
2918: FROM pa_tasks p
2919: WHERE p.task_id = p_pa_task_id;

Line 2918: FROM pa_tasks p

2914: CURSOR l_amg_task_csr
2915: (p_pa_task_id pa_tasks.task_id%type)
2916: IS
2917: SELECT task_number
2918: FROM pa_tasks p
2919: WHERE p.task_id = p_pa_task_id;
2920:
2921: BEGIN
2922:

Line 3038: UPDATE PA_TASKS

3034: THEN l_task_in_rec.ready_to_distribute_flag := 'Y';
3035: END IF;
3036:
3037:
3038: UPDATE PA_TASKS
3039: SET
3040: wbs_level = l_wbs_level
3041: ,top_task_id = l_top_task_id
3042: ,parent_task_id = l_parent_task_id

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

3051: l_top_task_id := l_parent_task_rec.top_task_id;
3052: l_parent_task_id := l_parent_task_rec.task_id;
3053:
3054: select customer_id into l_customer_id
3055: from pa_tasks where task_id =l_parent_task_id; /* added for bug 7495993 */
3056:
3057: IF l_task_in_rec.service_type_code = PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
3058: OR l_task_in_rec.service_type_code IS NULL
3059: THEN

Line 3243: UPDATE PA_TASKS

3239: END IF;
3240:
3241: /* Patch ends for the bug # 878682 */
3242:
3243: UPDATE PA_TASKS
3244: SET
3245: wbs_level = l_wbs_level
3246: ,top_task_id = l_top_task_id
3247: ,parent_task_id = l_parent_task_id

Line 3278: UPDATE pa_tasks

3274:
3275: -- Update chargeable_flag for parent if chargeable_flag = 'Y' since
3276: -- we have now created a sub-task
3277: IF l_parent_task_rec.chargeable_flag = 'Y' THEN
3278: UPDATE pa_tasks
3279: SET chargeable_flag = 'N'
3280: WHERE task_id = l_parent_task_rec.task_id;
3281: END IF;
3282:

Line 3290: UPDATE pa_tasks

3286: --bug 4279634
3287: --if a lowest level task has sub-projects then make the chargeable flag to 'N'
3288: IF PA_RELATIONSHIP_UTILS.check_task_has_sub_proj(l_project_id,l_task_id,null) = 'Y'
3289: THEN
3290: UPDATE pa_tasks
3291: SET chargeable_flag = 'N'
3292: WHERE task_id = l_task_id;
3293: END IF;
3294: --end bug 4279634

Line 3302: CURSOR cur_pa_tasks

3298:
3299: IF p_create_task_structure <> 'N' THEN -- Performance changes. Bug 2931183
3300: -- Donot do any structures processing in bulk calling context ie from create_project.
3301: DECLARE
3302: CURSOR cur_pa_tasks
3303: IS
3304: SELECT task_number, long_task_name, description, --bug 2833194
3305: parent_task_id,carrying_out_organization_id,
3306: pm_task_reference, address_id, task_manager_person_id

Line 3307: FROM pa_tasks

3303: IS
3304: SELECT task_number, long_task_name, description, --bug 2833194
3305: parent_task_id,carrying_out_organization_id,
3306: pm_task_reference, address_id, task_manager_person_id
3307: FROM pa_tasks
3308: WHERE project_id = l_project_id
3309: AND task_id = l_task_id;
3310:
3311: l_pa_tasks_rec cur_pa_tasks%ROWTYPE;

Line 3311: l_pa_tasks_rec cur_pa_tasks%ROWTYPE;

3307: FROM pa_tasks
3308: WHERE project_id = l_project_id
3309: AND task_id = l_task_id;
3310:
3311: l_pa_tasks_rec cur_pa_tasks%ROWTYPE;
3312: v_task_id_above NUMBER;
3313: l_msg_count NUMBER ;
3314: l_msg_data VARCHAR2(2000);
3315: l_return_status VARCHAR2(1);

Line 3370: OPEN cur_pa_tasks;

3366: END IF;
3367:
3368: IF l_task_id IS NOT NULL
3369: THEN
3370: OPEN cur_pa_tasks;
3371: FETCH cur_pa_tasks INTO l_pa_tasks_rec;
3372: CLOSE cur_pa_tasks;
3373:
3374: --bug 6153503 added below code

Line 3371: FETCH cur_pa_tasks INTO l_pa_tasks_rec;

3367:
3368: IF l_task_id IS NOT NULL
3369: THEN
3370: OPEN cur_pa_tasks;
3371: FETCH cur_pa_tasks INTO l_pa_tasks_rec;
3372: CLOSE cur_pa_tasks;
3373:
3374: --bug 6153503 added below code
3375: IF l_task_in_rec.tasks_dff = 'Y' THEN

Line 3372: CLOSE cur_pa_tasks;

3368: IF l_task_id IS NOT NULL
3369: THEN
3370: OPEN cur_pa_tasks;
3371: FETCH cur_pa_tasks INTO l_pa_tasks_rec;
3372: CLOSE cur_pa_tasks;
3373:
3374: --bug 6153503 added below code
3375: IF l_task_in_rec.tasks_dff = 'Y' THEN
3376: l_validate_dff := 'N';

Line 3419: ,p_parent_task_id => l_pa_tasks_rec.parent_task_id

3415: PA_PROJ_TASK_STRUC_PUB.CREATE_TASK_STRUCTURE(
3416: p_calling_module => 'AMG'
3417: ,p_project_id => l_project_id
3418: ,p_task_id => l_task_id
3419: ,p_parent_task_id => l_pa_tasks_rec.parent_task_id
3420: ,p_ref_task_id => v_task_id_above
3421: ,p_task_number => l_pa_tasks_rec.task_number
3422: ,p_task_name => l_pa_tasks_rec.long_task_name --bug 2833194
3423: ,p_task_description => l_pa_tasks_rec.description

Line 3421: ,p_task_number => l_pa_tasks_rec.task_number

3417: ,p_project_id => l_project_id
3418: ,p_task_id => l_task_id
3419: ,p_parent_task_id => l_pa_tasks_rec.parent_task_id
3420: ,p_ref_task_id => v_task_id_above
3421: ,p_task_number => l_pa_tasks_rec.task_number
3422: ,p_task_name => l_pa_tasks_rec.long_task_name --bug 2833194
3423: ,p_task_description => l_pa_tasks_rec.description
3424: ,p_carrying_out_organization_id => l_pa_tasks_rec.carrying_out_organization_id
3425: ,p_structure_type => 'FINANCIAL'

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

3418: ,p_task_id => l_task_id
3419: ,p_parent_task_id => l_pa_tasks_rec.parent_task_id
3420: ,p_ref_task_id => v_task_id_above
3421: ,p_task_number => l_pa_tasks_rec.task_number
3422: ,p_task_name => l_pa_tasks_rec.long_task_name --bug 2833194
3423: ,p_task_description => l_pa_tasks_rec.description
3424: ,p_carrying_out_organization_id => l_pa_tasks_rec.carrying_out_organization_id
3425: ,p_structure_type => 'FINANCIAL'
3426: ,P_PM_SOURCE_CODE => nvl(l_task_in_rec.PM_SOURCE_CODE,p_project_rec.pm_product_code) -- Bug 13923366

Line 3423: ,p_task_description => l_pa_tasks_rec.description

3419: ,p_parent_task_id => l_pa_tasks_rec.parent_task_id
3420: ,p_ref_task_id => v_task_id_above
3421: ,p_task_number => l_pa_tasks_rec.task_number
3422: ,p_task_name => l_pa_tasks_rec.long_task_name --bug 2833194
3423: ,p_task_description => l_pa_tasks_rec.description
3424: ,p_carrying_out_organization_id => l_pa_tasks_rec.carrying_out_organization_id
3425: ,p_structure_type => 'FINANCIAL'
3426: ,P_PM_SOURCE_CODE => nvl(l_task_in_rec.PM_SOURCE_CODE,p_project_rec.pm_product_code) -- Bug 13923366
3427: ,P_PM_SOURCE_reference => l_pa_tasks_rec.pm_task_reference

Line 3424: ,p_carrying_out_organization_id => l_pa_tasks_rec.carrying_out_organization_id

3420: ,p_ref_task_id => v_task_id_above
3421: ,p_task_number => l_pa_tasks_rec.task_number
3422: ,p_task_name => l_pa_tasks_rec.long_task_name --bug 2833194
3423: ,p_task_description => l_pa_tasks_rec.description
3424: ,p_carrying_out_organization_id => l_pa_tasks_rec.carrying_out_organization_id
3425: ,p_structure_type => 'FINANCIAL'
3426: ,P_PM_SOURCE_CODE => nvl(l_task_in_rec.PM_SOURCE_CODE,p_project_rec.pm_product_code) -- Bug 13923366
3427: ,P_PM_SOURCE_reference => l_pa_tasks_rec.pm_task_reference
3428: ,p_location_id => l_pa_tasks_rec.address_id

Line 3427: ,P_PM_SOURCE_reference => l_pa_tasks_rec.pm_task_reference

3423: ,p_task_description => l_pa_tasks_rec.description
3424: ,p_carrying_out_organization_id => l_pa_tasks_rec.carrying_out_organization_id
3425: ,p_structure_type => 'FINANCIAL'
3426: ,P_PM_SOURCE_CODE => nvl(l_task_in_rec.PM_SOURCE_CODE,p_project_rec.pm_product_code) -- Bug 13923366
3427: ,P_PM_SOURCE_reference => l_pa_tasks_rec.pm_task_reference
3428: ,p_location_id => l_pa_tasks_rec.address_id
3429: ,p_manager_person_id => l_pa_tasks_rec.task_manager_person_id
3430: ,x_task_version_id => l_task_version_id
3431: ,x_task_id => l_new_task_id -- 4537865 Replaced l_task_id with l_new_task_id

Line 3428: ,p_location_id => l_pa_tasks_rec.address_id

3424: ,p_carrying_out_organization_id => l_pa_tasks_rec.carrying_out_organization_id
3425: ,p_structure_type => 'FINANCIAL'
3426: ,P_PM_SOURCE_CODE => nvl(l_task_in_rec.PM_SOURCE_CODE,p_project_rec.pm_product_code) -- Bug 13923366
3427: ,P_PM_SOURCE_reference => l_pa_tasks_rec.pm_task_reference
3428: ,p_location_id => l_pa_tasks_rec.address_id
3429: ,p_manager_person_id => l_pa_tasks_rec.task_manager_person_id
3430: ,x_task_version_id => l_task_version_id
3431: ,x_task_id => l_new_task_id -- 4537865 Replaced l_task_id with l_new_task_id
3432: --for shared structures

Line 3429: ,p_manager_person_id => l_pa_tasks_rec.task_manager_person_id

3425: ,p_structure_type => 'FINANCIAL'
3426: ,P_PM_SOURCE_CODE => nvl(l_task_in_rec.PM_SOURCE_CODE,p_project_rec.pm_product_code) -- Bug 13923366
3427: ,P_PM_SOURCE_reference => l_pa_tasks_rec.pm_task_reference
3428: ,p_location_id => l_pa_tasks_rec.address_id
3429: ,p_manager_person_id => l_pa_tasks_rec.task_manager_person_id
3430: ,x_task_version_id => l_task_version_id
3431: ,x_task_id => l_new_task_id -- 4537865 Replaced l_task_id with l_new_task_id
3432: --for shared structures
3433: ,p_OBLIGATION_START_DATE => l_task_in_rec.OBLIGATION_START_DATE

Line 3628: pa_tasks

3624:
3625: CURSOR c_task_csr IS
3626: SELECT task_id
3627: FROM
3628: pa_tasks
3629: WHERE project_id = p_pa_project_id
3630: AND pm_task_reference = p_pm_task_reference;
3631:
3632: l_task_rec c_task_csr%ROWTYPE;

Line 3831: FROM pa_tasks

3827:
3828: CURSOR l_task_id_csr
3829: IS
3830: SELECT 'X'
3831: FROM pa_tasks
3832: WHERE task_id = p_pa_task_id
3833: AND project_id = p_pa_project_id;
3834:
3835:

Line 4054: FROM pa_tasks

4050:
4051: CURSOR l_task_id_csr
4052: IS
4053: SELECT 'X'
4054: FROM pa_tasks
4055: WHERE task_id = p_pa_task_id
4056: AND project_id = p_pa_project_id;
4057:
4058: CURSOR l_proj_element_id_csr

Line 4079: AND OBJECT_TYPE = 'PA_TASKS';

4075: WHERE ppe.proj_element_id = ppst.proj_element_id
4076: AND ppe.project_id = p_pa_project_id
4077: AND ppst.structure_type_id = pst.structure_type_id
4078: AND pst.structure_type = p_structure_type)
4079: AND OBJECT_TYPE = 'PA_TASKS';
4080:
4081: l_api_name CONSTANT VARCHAR2(30) := 'Convert_pm_taskref_to_id_all';
4082: l_task_id NUMBER ;
4083: l_dummy VARCHAR2(1);

Line 4176: -- pa_tasks table which is the case when task is never published.

4172: --Added by rtarway, for BUG 3919800
4173: -- bug 8325536 - skkoppul : added SHARE_FULL structure_type condition. Update_task will
4174: -- always be called with structure_type as FINANCIAL in case of fully shared structure
4175: -- hence task_id needs to be validaetd against pa_proj_elements if it does not exist in
4176: -- pa_tasks table which is the case when task is never published.
4177: IF (l_project_sharing_type = 'SHARE_PARTIAL' OR l_project_sharing_type = 'SHARE_FULL')
4178: THEN
4179: OPEN l_proj_element_id_csr;
4180: FETCH l_proj_element_id_csr INTO l_dummy;

Line 4717: pa_tasks

4713: top_task_id,
4714: TASK_NAME,
4715: PM_TASK_REFERENCE
4716: FROM
4717: pa_tasks
4718: WHERE task_id = p_task_id;
4719:
4720: CURSOR l_get_lower_task_det_csr (l_project_id IN NUMBER,
4721: l_task_id IN NUMBER )

Line 4724: FROM pa_tasks

4720: CURSOR l_get_lower_task_det_csr (l_project_id IN NUMBER,
4721: l_task_id IN NUMBER )
4722: IS
4723: SELECT task_id
4724: FROM pa_tasks
4725: WHERE project_id = l_project_id
4726: AND parent_task_id = l_task_id;
4727:
4728: l_task_rec l_get_task_det_csr%ROWTYPE;

Line 4752: (p_pa_task_id pa_tasks.task_id%type)

4748: FROM pa_projects p
4749: WHERE p.project_id = p_pa_project_id;
4750:
4751: CURSOR l_amg_task_csr
4752: (p_pa_task_id pa_tasks.task_id%type)
4753: IS
4754: SELECT task_number
4755: FROM pa_tasks p
4756: WHERE p.task_id = p_pa_task_id;

Line 4755: FROM pa_tasks p

4751: CURSOR l_amg_task_csr
4752: (p_pa_task_id pa_tasks.task_id%type)
4753: IS
4754: SELECT task_number
4755: FROM pa_tasks p
4756: WHERE p.task_id = p_pa_task_id;
4757:
4758: BEGIN
4759:

Line 4823: UPDATE pa_tasks

4819: -- hence update all first line children as follows
4820: -- parent task id = the parent task id of the task that is
4821: -- being deleted
4822:
4823: UPDATE pa_tasks
4824: SET parent_task_id = l_task_rec.parent_task_id,
4825: wbs_level = Decode(wbs_level,1,1,wbs_level-1)
4826: WHERE project_id = l_task_rec.project_id
4827: AND parent_task_id = l_task_rec.task_id;

Line 4884: DELETE FROM pa_tasks WHERE task_id = p_task_id;

4880: DELETE FROM pa_project_asset_assignments WHERE task_id = p_task_id;
4881:
4882: DELETE FROM pa_percent_completes WHERE task_id = p_task_id;
4883:
4884: DELETE FROM pa_tasks WHERE task_id = p_task_id;
4885:
4886: p_return_status := FND_API.G_RET_STS_SUCCESS;
4887:
4888: EXCEPTION

Line 5294: FROM pa_tasks

5290:
5291: CURSOR l_task_rec_csr (l_project_id NUMBER ,l_task_id NUMBER)
5292: IS
5293: SELECT *
5294: FROM pa_tasks
5295: WHERE project_id = l_project_id
5296: AND task_id = l_task_id;
5297:
5298: CURSOR l_check_child_exists_csr (l_project_id NUMBER,l_task_id NUMBER )

Line 5301: PA_TASKS

5297:
5298: CURSOR l_check_child_exists_csr (l_project_id NUMBER,l_task_id NUMBER )
5299: IS
5300: SELECT 'x' FROM
5301: PA_TASKS
5302: WHERE project_id = l_project_id
5303: AND parent_task_id = l_task_id;
5304:
5305: CURSOR l_outer_child_dates_csr (l_project_id NUMBER,l_task_id NUMBER)

Line 5309: FROM pa_tasks

5305: CURSOR l_outer_child_dates_csr (l_project_id NUMBER,l_task_id NUMBER)
5306: IS
5307: SELECT MIN(TRUNC(start_date))
5308: , MAX(TRUNC(completion_date)) -- Bug Fix 4705139
5309: FROM pa_tasks
5310: WHERE project_id = l_project_id
5311: AND parent_task_id = l_task_id;
5312:
5313: CURSOR l_outer_parent_dates_csr (l_project_id NUMBER,l_task_id NUMBER)

Line 5317: FROM pa_tasks

5313: CURSOR l_outer_parent_dates_csr (l_project_id NUMBER,l_task_id NUMBER)
5314: IS
5315: SELECT MIN(TRUNC(start_date))
5316: , MAX(TRUNC(completion_date)) -- Bug Fix 4705139
5317: FROM pa_tasks
5318: WHERE project_id = l_project_id
5319: AND task_id = l_task_id;
5320:
5321: CURSOR l_project_date_csr (l_project_id NUMBER )

Line 5330: FROM pa_tasks

5326:
5327: CURSOR l_top_task_csr (p_task_id NUMBER)
5328: IS
5329: SELECT top_task_id
5330: FROM pa_tasks
5331: WHERE task_id = p_task_id;
5332:
5333: --needed to convert pm_parent_task_reference to parent_task_id
5334: --convert_pm_taskref_to_id can not be used because parent_id can be NULL

Line 5339: FROM pa_tasks

5335:
5336: CURSOR l_convert_pm_parent_to_id_csr( p_project_id NUMBER, p_pm_task_reference VARCHAR2 )
5337: IS
5338: SELECT task_id
5339: FROM pa_tasks
5340: WHERE pm_task_reference = p_pm_task_reference
5341: AND project_id = p_project_id;
5342:
5343: CURSOR l_parent_wbs_csr ( p_project_id NUMBER, p_pa_task_id NUMBER )

Line 5346: FROM pa_tasks

5342:
5343: CURSOR l_parent_wbs_csr ( p_project_id NUMBER, p_pa_task_id NUMBER )
5344: IS
5345: SELECT wbs_level
5346: FROM pa_tasks
5347: WHERE task_id = p_pa_task_id
5348: AND project_id = p_project_id;
5349:
5350: CURSOR l_validate_parent_id_csr( p_project_id NUMBER, p_task_id NUMBER)

Line 5353: FROM pa_tasks

5349:
5350: CURSOR l_validate_parent_id_csr( p_project_id NUMBER, p_task_id NUMBER)
5351: IS
5352: SELECT 'x'
5353: FROM pa_tasks
5354: WHERE task_id = p_task_id
5355: AND project_id = p_project_id;
5356:
5357: CURSOR l_lock_rows_csr( p_task_id NUMBER)

Line 5360: FROM pa_tasks

5356:
5357: CURSOR l_lock_rows_csr( p_task_id NUMBER)
5358: IS
5359: SELECT 'x'
5360: FROM pa_tasks
5361: WHERE task_id = p_task_id
5362: FOR UPDATE NOWAIT;
5363:
5364: -- Used when parent_id is changed, and the task (and it's children) is on a different wbs level

Line 5369: FROM pa_tasks

5365:
5366: CURSOR l_wbs_level_csr( p_task_id NUMBER)
5367: IS
5368: SELECT task_id
5369: FROM pa_tasks
5370: START WITH task_id=p_task_id
5371: CONNECT BY PRIOR task_id=parent_task_id
5372: FOR UPDATE NOWAIT;
5373:

Line 5380: FROM pa_tasks

5376:
5377: CURSOR l_chk_chlds_parent_id_csr( p_task_id NUMBER, p_new_parent_task_id NUMBER)
5378: IS
5379: SELECT 'x'
5380: FROM pa_tasks
5381: WHERE task_id=p_new_parent_task_id
5382: START WITH task_id=p_task_id
5383: CONNECT BY PRIOR task_id=parent_task_id
5384: FOR UPDATE NOWAIT;

Line 5433: (p_pa_task_id pa_tasks.task_id%type)

5429: FROM pa_projects p
5430: WHERE p.project_id = p_pa_project_id;
5431:
5432: CURSOR l_amg_task_csr
5433: (p_pa_task_id pa_tasks.task_id%type)
5434: IS
5435: SELECT task_number
5436: FROM pa_tasks p
5437: WHERE p.task_id = p_pa_task_id;

Line 5436: FROM pa_tasks p

5432: CURSOR l_amg_task_csr
5433: (p_pa_task_id pa_tasks.task_id%type)
5434: IS
5435: SELECT task_number
5436: FROM pa_tasks p
5437: WHERE p.task_id = p_pa_task_id;
5438:
5439: -- Fix for Bug # 1335417
5440: -- needed for update of Fixed Date( p_cost_ind_sch_fixed_date)

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

5984: END IF; -- end changes for bug 13923366
5985:
5986: -- Building the dynamic SQL statement
5987:
5988: l_statement := ' UPDATE PA_TASKS SET ';
5989:
5990: -- TASK REFERENCE
5991:
5992: IF p_pm_task_reference <> PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR

Line 6627: PA_TASKS_MAINT_UTILS.Check_Start_Date_EI(

6623: --bypass the date validation for the partially shared when source is workplan and msproject.
6624: l_project_sharing_type := PA_PROJ_TASK_STRUC_PUB.GET_SHARE_TYPE(l_project_id);
6625: IF ((l_project_sharing_type = 'SHARE_PARTIAL' AND p_pm_product_code <> 'MSPROJECT' AND p_pm_product_code <> 'WORKPLAN') OR (l_project_sharing_type <> 'SHARE_PARTIAL'))
6626: THEN
6627: PA_TASKS_MAINT_UTILS.Check_Start_Date_EI(
6628: p_project_id => l_project_id,
6629: p_task_id => l_task_id,
6630: p_start_date => p_task_start_date,
6631: x_return_status => l_return_status,

Line 6729: PA_TASKS_MAINT_UTILS.Check_End_Date_EI(

6725: --bypass the date validation for the partially shared when source is workplan and msproject.
6726: l_project_sharing_type := PA_PROJ_TASK_STRUC_PUB.GET_SHARE_TYPE(l_project_id);
6727: IF ((l_project_sharing_type = 'SHARE_PARTIAL' AND p_pm_product_code <> 'MSPROJECT' AND p_pm_product_code <> 'WORKPLAN') OR (l_project_sharing_type <> 'SHARE_PARTIAL'))
6728: THEN
6729: PA_TASKS_MAINT_UTILS.Check_End_Date_EI(
6730: p_project_id => l_project_id,
6731: p_task_id => l_task_id,
6732: p_end_date => p_task_completion_date,
6733: x_return_status => l_return_status,

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

6902: --The following code should be executed when a task's parent is modified
6903: --in a working version( with already existing a published ver ) and
6904: --then its published.
6905: --In other words the code is executed while publishing to sync up with
6906: --pa_tasks. In regular flow for updating parent of a task we call this api
6907: --from the wrapper process_task_structure_bulk api.
6908: --
6909: IF p_pm_product_code = 'WORKPLAN'
6910: THEN

Line 7089: UPDATE pa_tasks

7085: FETCH l_wbs_level_csr INTO l_wbs_change_task_id;
7086:
7087: WHILE l_wbs_level_csr%FOUND LOOP
7088:
7089: UPDATE pa_tasks
7090: SET wbs_level = wbs_level + l_delta_level
7091: WHERE task_id = l_wbs_change_task_id;
7092:
7093: FETCH l_wbs_level_csr INTO l_wbs_change_task_id;

Line 7276: FROM PA_TASKS

7272: SELECT PROJECT_TYPE
7273: INTO l_project_type2
7274: FROM PA_PROJECTS
7275: WHERE PROJECT_ID IN (SELECT PROJECT_ID
7276: FROM PA_TASKS
7277: WHERE TASK_ID = p_pa_task_id);
7278: END IF;
7279: EXCEPTION
7280: WHEN OTHERS THEN

Line 7295: p_desc_flex_name => 'PA_TASKS_DESC_FLEX'

7291: --BUG 3908013, rtarway, Validate for financial dff
7292: --bug 6153503
7293: IF l_project_type2 <> 'AWARD_PROJECT' THEN /* Bug 7403227*/
7294: pa_task_utils.validate_flex_fields(
7295: p_desc_flex_name => 'PA_TASKS_DESC_FLEX'
7296: ,p_attribute_category => l_attribute_category
7297: ,p_attribute1 => l_attribute1
7298: ,p_attribute2 => l_attribute2
7299: ,p_attribute3 => l_attribute3

Line 8973: UPDATE PA_TASKS SET customer_id = p_customer_id

8969: NVL(l_task_rec.customer_id, PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM) <> p_customer_id
8970: THEN
8971: IF l_task_rec.parent_task_id IS NULL THEN
8972: IF l_children_exist ='Y' THEN
8973: UPDATE PA_TASKS SET customer_id = p_customer_id
8974: WHERE top_task_id=l_task_rec.task_id AND not(task_id =l_task_rec.task_id);
8975: END IF;
8976: l_statement := l_statement || ' CUSTOMER_ID = :cust_id ,';
8977: l_cust_id_fg := 'Y';

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

9135: /* bug #5243018: Reverting the fix in bug 4120380.
9136: DBMS_SQL.BIND_VARIABLE(l_cursor, ':tk_num','-'||p_task_number); */
9137: DBMS_SQL.BIND_VARIABLE(l_cursor, ':tk_num', substrb(p_task_number,1,25)); --bug 5733285
9138: /** CODE CHANGE BY ADITI for Bug 4120380.This is to prefix task_number with '-' so that
9139: PA_TASKS_U2 constraint can be overcome.After updating all the tasks in the script,
9140: code again updates the task_number, trimming the '-' added.**/
9141: END IF;
9142:
9143: IF l_b_tk_st_dt_flag = 'Y' THEN

Line 9436: UPDATE pa_tasks

9432: --if a lowest level task has sub-projects then make the chargeable flag to 'N'
9433: --This should be indepenedent of the above update.
9434: IF PA_RELATIONSHIP_UTILS.check_task_has_sub_proj(l_project_id,l_task_id,null) = 'Y'
9435: THEN
9436: UPDATE pa_tasks
9437: SET chargeable_flag = 'N'
9438: WHERE task_id = l_task_id;
9439: END IF;
9440: --end bug 4279634

Line 9574: FROM pa_tasks

9570:
9571: CURSOR lock_tasks_csr ( p_task_id IN NUMBER )
9572: IS
9573: SELECT 'x'
9574: FROM pa_tasks
9575: START WITH task_id=p_task_id
9576: CONNECT BY PRIOR task_id=parent_task_id
9577: FOR UPDATE NOWAIT;
9578:

Line 9609: (p_pa_task_id pa_tasks.task_id%type)

9605: FROM pa_projects p
9606: WHERE p.project_id = p_pa_project_id;
9607:
9608: CURSOR l_amg_task_csr
9609: (p_pa_task_id pa_tasks.task_id%type)
9610: IS
9611: SELECT task_number
9612: FROM pa_tasks p
9613: WHERE p.task_id = p_pa_task_id;

Line 9612: FROM pa_tasks p

9608: CURSOR l_amg_task_csr
9609: (p_pa_task_id pa_tasks.task_id%type)
9610: IS
9611: SELECT task_number
9612: FROM pa_tasks p
9613: WHERE p.task_id = p_pa_task_id;
9614:
9615: -- 3801426 added local variable
9616: l_task_source_reference VARCHAR2(240);

Line 9619: l_task_id_out pa_tasks.task_id%TYPE;

9615: -- 3801426 added local variable
9616: l_task_source_reference VARCHAR2(240);
9617:
9618: -- 5263429 added local variable
9619: l_task_id_out pa_tasks.task_id%TYPE;
9620:
9621: BEGIN
9622:
9623:

Line 10008: --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.

10004: CLOSE lock_tasks_csr;
10005:
10006: --bug 2765115
10007:
10008: --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.
10009: PA_PROJ_TASK_STRUC_PUB.delete_task_structure
10010: (
10011: p_calling_module => 'AMG'
10012: ,p_task_id => l_task_id

Line 11113: FROM pa_tasks

11109:
11110: CURSOR l_tsk_lb_sch_type_task_csr(p_pa_project_id VARCHAR2,p_pa_task_id VARCHAR2)
11111: IS
11112: SELECT labor_sch_type
11113: FROM pa_tasks
11114: where project_id = p_pa_project_id
11115: and task_id= p_pa_task_id;
11116:
11117: CURSOR l_prj_nl_sch_type_csr(p_pa_project_id VARCHAR2)

Line 11126: FROM pa_tasks

11122:
11123: CURSOR l_tsk_nl_sch_type_task_csr(p_pa_project_id VARCHAR2,p_pa_task_id VARCHAR2)
11124: IS
11125: SELECT non_labor_sch_type
11126: FROM pa_tasks
11127: where project_id = p_pa_project_id
11128: and task_id = p_pa_task_id;
11129:
11130: CURSOR l_amg_project_csr(p_pa_project_id pa_projects.project_id%type)

Line 12280: SELECT 'Y' FROM pa_tasks

12276: x_msg_data OUT NOCOPY VARCHAR2 ) IS
12277:
12278: -- Bug 7255015
12279: cursor any_invalid_customer is
12280: SELECT 'Y' FROM pa_tasks
12281: WHERE project_id = p_project_id
12282: AND parent_task_id IS NULL
12283: AND nvl(customer_id, -1) NOT IN (select customer_id
12284: from pa_project_customers

Line 12531: FROM pa_tasks

12527:
12528: --This returns the parent task id when poj element id is passed
12529: Cursor Get_Parent_Task_Id(l_task_id NUMBER) IS
12530: SELECT parent_task_id
12531: FROM pa_tasks
12532: WHERE project_id=p_project_id and task_id=l_task_id;
12533:
12534: /*Cursor Get_Top_Task_Id IS
12535: Select top_task_id from PA_TASKS pt , PA_PROJ_ELEMENT_VERSIONS ppev

Line 12535: Select top_task_id from PA_TASKS pt , PA_PROJ_ELEMENT_VERSIONS ppev

12531: FROM pa_tasks
12532: WHERE project_id=p_project_id and task_id=l_task_id;
12533:
12534: /*Cursor Get_Top_Task_Id IS
12535: Select top_task_id from PA_TASKS pt , PA_PROJ_ELEMENT_VERSIONS ppev
12536: where pt.project_id=p_project_id and ppev.proj_element_id=pt.task_id
12537: and ppev.element_version_id=p_task_id and ppev.parent_structure_version_id=p_structure_version_id;*/
12538:
12539: --This returns the parent task id when element version id is passed

Line 12541: Select parent_task_id from PA_TASKS pt , PA_PROJ_ELEMENT_VERSIONS ppev

12537: and ppev.element_version_id=p_task_id and ppev.parent_structure_version_id=p_structure_version_id;*/
12538:
12539: --This returns the parent task id when element version id is passed
12540: Cursor get_parent_task(l_task_id NUMBER) IS
12541: Select parent_task_id from PA_TASKS pt , PA_PROJ_ELEMENT_VERSIONS ppev
12542: where pt.project_id=p_project_id and ppev.proj_element_id=pt.task_id
12543: and ppev.element_version_id=l_task_id and ppev.parent_structure_version_id=p_structure_version_id;
12544:
12545: BEGIN