DBA Data[Home] [Help]

APPS.PA_PROJECT_PUB dependencies on PA_PROJECT_CHECK_PVT

Line 4301: pa_project_check_pvt.check_manager_date_range(p_project_id => l_project_id

4297: /* Start of code for bug #2111806
4298: Call the check_manager_date_range to check if the Project
4299: Manager exists for the complete duration of the Project. */
4300:
4301: pa_project_check_pvt.check_manager_date_range(p_project_id => l_project_id
4302: ,p_return_status => l_return_status);
4303:
4304: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR
4305: THEN

Line 16868: pa_project_check_pvt.G_task_num_updated_index_tbl.delete;

16864: FETCH l_project_csr INTO l_project_rec;
16865: CLOSE l_project_csr;
16866:
16867:
16868: pa_project_check_pvt.G_task_num_updated_index_tbl.delete;
16869: pa_project_check_pvt.G_index_counter := 0;
16870: l_deferred_new_tasks_tbl.delete;
16871: l_deferred_tasks_count := 0;
16872: i := p_tasks_in.first;

Line 16869: pa_project_check_pvt.G_index_counter := 0;

16865: CLOSE l_project_csr;
16866:
16867:
16868: pa_project_check_pvt.G_task_num_updated_index_tbl.delete;
16869: pa_project_check_pvt.G_index_counter := 0;
16870: l_deferred_new_tasks_tbl.delete;
16871: l_deferred_tasks_count := 0;
16872: i := p_tasks_in.first;
16873:

Line 17491: IF pa_project_check_pvt.G_index_counter > 0 THEN

17487: v_first_index := p_tasks_in.first;
17488: v_last_index := p_tasks_in.last;
17489: --Project Structures
17490:
17491: IF pa_project_check_pvt.G_index_counter > 0 THEN
17492: IF pa_project_check_pvt.G_task_num_updated_index_tbl.EXISTS (1) THEN
17493: FOR i in 1..pa_project_check_pvt.G_task_num_updated_index_tbl.COUNT LOOP
17494: l_array_index :=
17495: pa_project_check_pvt.G_task_num_updated_index_tbl(i).task_index;

Line 17492: IF pa_project_check_pvt.G_task_num_updated_index_tbl.EXISTS (1) THEN

17488: v_last_index := p_tasks_in.last;
17489: --Project Structures
17490:
17491: IF pa_project_check_pvt.G_index_counter > 0 THEN
17492: IF pa_project_check_pvt.G_task_num_updated_index_tbl.EXISTS (1) THEN
17493: FOR i in 1..pa_project_check_pvt.G_task_num_updated_index_tbl.COUNT LOOP
17494: l_array_index :=
17495: pa_project_check_pvt.G_task_num_updated_index_tbl(i).task_index;
17496:

Line 17493: FOR i in 1..pa_project_check_pvt.G_task_num_updated_index_tbl.COUNT LOOP

17489: --Project Structures
17490:
17491: IF pa_project_check_pvt.G_index_counter > 0 THEN
17492: IF pa_project_check_pvt.G_task_num_updated_index_tbl.EXISTS (1) THEN
17493: FOR i in 1..pa_project_check_pvt.G_task_num_updated_index_tbl.COUNT LOOP
17494: l_array_index :=
17495: pa_project_check_pvt.G_task_num_updated_index_tbl(i).task_index;
17496:
17497: --Project Structures

Line 17495: pa_project_check_pvt.G_task_num_updated_index_tbl(i).task_index;

17491: IF pa_project_check_pvt.G_index_counter > 0 THEN
17492: IF pa_project_check_pvt.G_task_num_updated_index_tbl.EXISTS (1) THEN
17493: FOR i in 1..pa_project_check_pvt.G_task_num_updated_index_tbl.COUNT LOOP
17494: l_array_index :=
17495: pa_project_check_pvt.G_task_num_updated_index_tbl(i).task_index;
17496:
17497: --Project Structures
17498: for j in v_first_index..v_last_index loop
17499: IF pa_project_check_pvt.G_task_num_updated_index_tbl(i).task_id = p_tasks_in(j).pa_task_id AND

Line 17499: IF pa_project_check_pvt.G_task_num_updated_index_tbl(i).task_id = p_tasks_in(j).pa_task_id AND

17495: pa_project_check_pvt.G_task_num_updated_index_tbl(i).task_index;
17496:
17497: --Project Structures
17498: for j in v_first_index..v_last_index loop
17499: IF pa_project_check_pvt.G_task_num_updated_index_tbl(i).task_id = p_tasks_in(j).pa_task_id AND
17500: j > v_first_index
17501: THEN
17502: v_ref_task_id := p_tasks_in(j-1).pa_task_id;
17503: ELSE

Line 17523: pa_project_check_pvt.G_task_num_updated_index_tbl(i).task_id,

17519: p_return_status => l_return_status,
17520: p_pm_product_code => p_pm_product_code,
17521: p_pa_project_id => l_project_id,
17522: p_pa_task_id =>
17523: pa_project_check_pvt.G_task_num_updated_index_tbl(i).task_id,
17524: --Project Structures
17525: p_ref_task_id => v_ref_task_id,
17526: --Project STRUCTUres
17527: p_pm_task_reference =>

Line 17744: END IF; -- IF pa_project_check_pvt.G_task_num_updated_index_tbl.EXISTS (1)

17740: END IF;
17741: l_tasks_out(l_array_index).pa_task_id := l_out_pa_task_id;
17742: l_tasks_out(l_array_index).pm_task_reference := l_out_pm_task_reference;
17743: END LOOP;
17744: END IF; -- IF pa_project_check_pvt.G_task_num_updated_index_tbl.EXISTS (1)
17745: END IF; -- IF pa_project_check_pvt.G_index_counter > 0
17746:
17747: /** Code change begin by aditi for Bug 4120380 **/
17748: /** The code below will update the task_numbers of the tasks passed via update_project script

Line 17745: END IF; -- IF pa_project_check_pvt.G_index_counter > 0

17741: l_tasks_out(l_array_index).pa_task_id := l_out_pa_task_id;
17742: l_tasks_out(l_array_index).pm_task_reference := l_out_pm_task_reference;
17743: END LOOP;
17744: END IF; -- IF pa_project_check_pvt.G_task_num_updated_index_tbl.EXISTS (1)
17745: END IF; -- IF pa_project_check_pvt.G_index_counter > 0
17746:
17747: /** Code change begin by aditi for Bug 4120380 **/
17748: /** The code below will update the task_numbers of the tasks passed via update_project script
17749: back to their original value viz. it'll crop the '-' added to aviod the constraint check in

Line 19065: pa_project_check_pvt.check_manager_date_range(p_project_id => l_project_id

19061:
19062: /* Start of code for bug #2111806
19063: Call the check_manager_date_range to check if the Project
19064: Manager exists for the complete duration of the Project. */
19065: pa_project_check_pvt.check_manager_date_range(p_project_id => l_project_id
19066: ,p_return_status => l_return_status);
19067:
19068: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR
19069: THEN

Line 22299: pa_project_check_pvt.G_task_num_updated_index_tbl.delete;

22295:
22296: EXCEPTION
22297:
22298: WHEN FND_API.G_EXC_ERROR THEN
22299: pa_project_check_pvt.G_task_num_updated_index_tbl.delete;
22300: pa_project_check_pvt.G_index_counter := 0;
22301:
22302: p_return_status := FND_API.G_RET_STS_ERROR ;
22303: G_ParChildTsk_chks_deferred := 'N';

Line 22300: pa_project_check_pvt.G_index_counter := 0;

22296: EXCEPTION
22297:
22298: WHEN FND_API.G_EXC_ERROR THEN
22299: pa_project_check_pvt.G_task_num_updated_index_tbl.delete;
22300: pa_project_check_pvt.G_index_counter := 0;
22301:
22302: p_return_status := FND_API.G_RET_STS_ERROR ;
22303: G_ParChildTsk_chks_deferred := 'N';
22304:

Line 22347: pa_project_check_pvt.G_task_num_updated_index_tbl.delete;

22343:
22344:
22345: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
22346: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
22347: pa_project_check_pvt.G_task_num_updated_index_tbl.delete;
22348: pa_project_check_pvt.G_index_counter := 0;
22349: G_ParChildTsk_chks_deferred := 'N';
22350: ROLLBACK TO Update_project_pub;
22351:

Line 22348: pa_project_check_pvt.G_index_counter := 0;

22344:
22345: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
22346: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
22347: pa_project_check_pvt.G_task_num_updated_index_tbl.delete;
22348: pa_project_check_pvt.G_index_counter := 0;
22349: G_ParChildTsk_chks_deferred := 'N';
22350: ROLLBACK TO Update_project_pub;
22351:
22352: -- Begin Bug # 4582750.

Line 22421: pa_project_check_pvt.G_task_num_updated_index_tbl.delete;

22417: end if;
22418:
22419: -- End Bug # 4582750.
22420:
22421: pa_project_check_pvt.G_task_num_updated_index_tbl.delete;
22422: pa_project_check_pvt.G_index_counter := 0;
22423: G_ParChildTsk_chks_deferred := 'N';
22424: --4218977, rtarway, unset this global variable
22425: if (p_pm_product_code <> 'WORKPLAN') then

Line 22422: pa_project_check_pvt.G_index_counter := 0;

22418:
22419: -- End Bug # 4582750.
22420:
22421: pa_project_check_pvt.G_task_num_updated_index_tbl.delete;
22422: pa_project_check_pvt.G_index_counter := 0;
22423: G_ParChildTsk_chks_deferred := 'N';
22424: --4218977, rtarway, unset this global variable
22425: if (p_pm_product_code <> 'WORKPLAN') then
22426: G_OP_VALIDATE_FLAG := null;

Line 22473: pa_project_check_pvt.G_task_num_updated_index_tbl.delete;

22469: end if;
22470:
22471: -- End Bug # 4582750.
22472:
22473: pa_project_check_pvt.G_task_num_updated_index_tbl.delete;
22474: pa_project_check_pvt.G_index_counter := 0;
22475: G_ParChildTsk_chks_deferred := 'N';
22476:
22477: -- 4537865

Line 22474: pa_project_check_pvt.G_index_counter := 0;

22470:
22471: -- End Bug # 4582750.
22472:
22473: pa_project_check_pvt.G_task_num_updated_index_tbl.delete;
22474: pa_project_check_pvt.G_index_counter := 0;
22475: G_ParChildTsk_chks_deferred := 'N';
22476:
22477: -- 4537865
22478: p_workflow_started := NULL ;

Line 22529: pa_project_check_pvt.G_task_num_updated_index_tbl.delete;

22525:
22526: -- End Bug # 4582750.
22527:
22528: G_ParChildTsk_chks_deferred := 'N';
22529: pa_project_check_pvt.G_task_num_updated_index_tbl.delete;
22530: pa_project_check_pvt.G_index_counter := 0;
22531: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
22532: --4218977, rtarway, unset this global variable
22533: if (p_pm_product_code <> 'WORKPLAN') then

Line 22530: pa_project_check_pvt.G_index_counter := 0;

22526: -- End Bug # 4582750.
22527:
22528: G_ParChildTsk_chks_deferred := 'N';
22529: pa_project_check_pvt.G_task_num_updated_index_tbl.delete;
22530: pa_project_check_pvt.G_index_counter := 0;
22531: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
22532: --4218977, rtarway, unset this global variable
22533: if (p_pm_product_code <> 'WORKPLAN') then
22534: G_OP_VALIDATE_FLAG := null;

Line 25020: pa_project_check_pvt.Check_Delete_Task_OK_pvt

25016: RAISE FND_API.G_EXC_ERROR;
25017: END IF;
25018: END IF;
25019: --bug 2876703
25020: pa_project_check_pvt.Check_Delete_Task_OK_pvt
25021: (p_api_version_number => p_api_version_number
25022: ,p_init_msg_list => p_init_msg_list
25023: ,p_return_status => p_return_status
25024: ,p_msg_count => p_msg_count

Line 25125: pa_project_check_pvt.Check_Add_Subtask_OK_pvt

25121:
25122: -- 4537865 : Initialize return status to success
25123: p_return_status := FND_API.G_RET_STS_SUCCESS ;
25124:
25125: pa_project_check_pvt.Check_Add_Subtask_OK_pvt
25126: (p_api_version_number => p_api_version_number
25127: ,p_init_msg_list => p_init_msg_list
25128: ,p_return_status => p_return_status
25129: ,p_msg_count => p_msg_count

Line 25193: pa_project_check_pvt.Check_Unique_Task_Ref_pvt

25189:
25190: -- 4537865 : Initialize return status to success
25191: p_return_status := FND_API.G_RET_STS_SUCCESS ;
25192:
25193: pa_project_check_pvt.Check_Unique_Task_Ref_pvt
25194: (p_api_version_number => p_api_version_number
25195: ,p_init_msg_list => p_init_msg_list
25196: ,p_return_status => p_return_status
25197: ,p_msg_count => p_msg_count

Line 25258: pa_project_check_pvt.Check_Unique_Project_Ref_pvt

25254:
25255: -- 4537865 : Initialize return status to success
25256: p_return_status := FND_API.G_RET_STS_SUCCESS ;
25257:
25258: pa_project_check_pvt.Check_Unique_Project_Ref_pvt
25259: (p_api_version_number => p_api_version_number
25260: ,p_init_msg_list => p_init_msg_list
25261: ,p_return_status => p_return_status
25262: ,p_msg_count => p_msg_count

Line 25319: pa_project_check_pvt.Check_Delete_Project_OK_pvt

25315:
25316: -- 4537865 : Initialize return status to success
25317: p_return_status := FND_API.G_RET_STS_SUCCESS ;
25318:
25319: pa_project_check_pvt.Check_Delete_Project_OK_pvt
25320: (p_api_version_number => p_api_version_number
25321: ,p_init_msg_list => p_init_msg_list
25322: ,p_return_status => p_return_status
25323: ,p_msg_count => p_msg_count

Line 25384: pa_project_check_pvt.Check_Change_Parent_OK_pvt

25380:
25381: -- 4537865 : Initialize return status to success
25382: p_return_status := FND_API.G_RET_STS_SUCCESS ;
25383:
25384: pa_project_check_pvt.Check_Change_Parent_OK_pvt
25385: (p_api_version_number => p_api_version_number
25386: ,p_init_msg_list => p_init_msg_list
25387: ,p_return_status => p_return_status
25388: ,p_msg_count => p_msg_count

Line 25450: pa_project_check_pvt.Check_Change_Proj_Org_OK_pvt

25446:
25447: -- 4537865 : Initialize return status to success
25448: p_return_status := FND_API.G_RET_STS_SUCCESS ;
25449:
25450: pa_project_check_pvt.Check_Change_Proj_Org_OK_pvt
25451: (p_api_version_number => p_api_version_number
25452: ,p_init_msg_list => p_init_msg_list
25453: ,p_return_status => p_return_status
25454: ,p_msg_count => p_msg_count

Line 25513: pa_project_check_pvt.Check_Unique_Task_Number_pvt

25509:
25510: -- 4537865 : Initialize return status to success
25511: p_return_status := FND_API.G_RET_STS_SUCCESS ;
25512:
25513: pa_project_check_pvt.Check_Unique_Task_Number_pvt
25514: (p_api_version_number => p_api_version_number
25515: ,p_init_msg_list => p_init_msg_list
25516: ,p_return_status => p_return_status
25517: ,p_msg_count => p_msg_count

Line 25578: pa_project_check_pvt.Check_Task_Numb_Change_Ok_Pvt

25574:
25575: -- 4537865 : Initialize return status to success
25576: p_return_status := FND_API.G_RET_STS_SUCCESS ;
25577:
25578: pa_project_check_pvt.Check_Task_Numb_Change_Ok_Pvt
25579: (p_api_version_number => p_api_version_number
25580: ,p_init_msg_list => p_init_msg_list
25581: ,p_return_status => p_return_status
25582: ,p_msg_count => p_msg_count