APPS.PA_PROJECT_STRUCTURE_PVT1 dependencies on PA_STRUCT_TASK_ROLLUP_PUB

Line 3263: l_task_ver_ids_tbl PA_STRUCT_TASK_ROLLUP_PUB.pa_element_version_id_tbl_typ;

3259: l_login_id NUMBER := FND_GLOBAL.LOGIN_ID;
3260: --maansari
3261:
3262: --bug 3047602
3263: l_task_ver_ids_tbl PA_STRUCT_TASK_ROLLUP_PUB.pa_element_version_id_tbl_typ;
3264: cursor get_all_new_childs(c_new_struc_ver_id NUMBER) IS
3265: select element_version_id
3266: from pa_proj_element_versions
3267: where parent_structure_version_id = c_new_struc_ver_id

Line 3454: -- PA_STRUCT_TASK_ROLLUP_PUB.Tasks_Rollup(

3450: -- END LOOP;
3451: -- CLOSE get_linking_tasks;
3452: --
3453: -- IF (l_tasks_ver_ids.count > 0) THEN
3454: -- PA_STRUCT_TASK_ROLLUP_PUB.Tasks_Rollup(
3455: -- p_commit => FND_API.G_FALSE,
3456: -- p_element_versions => l_tasks_ver_ids,
3457: -- x_return_status => l_return_status,
3458: -- x_msg_count => l_msg_count,

Line 5217: PA_STRUCT_TASK_ROLLUP_PUB.Tasks_Rollup_Unlimited(

5213: /* --hsiu: no need to rollup since the copied structure version is already rolled-up
5214: IF l_task_ver_ids_tbl.count > 0 THEN
5215: --rollup dates for new published version
5216:
5217: PA_STRUCT_TASK_ROLLUP_PUB.Tasks_Rollup_Unlimited(
5218: p_commit => FND_API.G_FALSE,
5219: p_element_versions => l_task_ver_ids_tbl,
5220: x_return_status => l_return_status,
5221: x_msg_count => l_msg_count,

Line 5453: PA_STRUCT_TASK_ROLLUP_PUB.Task_Stat_Pushdown_Rollup(

5449: --bug 4019845
5450: /*
5451: --hsiu: task status
5452: --push down and rollup
5453: PA_STRUCT_TASK_ROLLUP_PUB.Task_Stat_Pushdown_Rollup(
5454: p_structure_version_id => l_new_struct_ver_id
5455: ,x_return_status => x_return_status
5456: ,x_msg_count => x_msg_count
5457: ,x_msg_data => x_msg_data

Line 9875: l_task_ver_ids_tbl PA_STRUCT_TASK_ROLLUP_PUB.pa_element_version_id_tbl_typ;

9871: l_object_type VARCHAR2(30);
9872: l_task_ver_id NUMBER;
9873: /* Bug 2790703 Begin */
9874: -- l_task_ver_ids PA_NUM_1000_NUM := PA_NUM_1000_NUM();
9875: l_task_ver_ids_tbl PA_STRUCT_TASK_ROLLUP_PUB.pa_element_version_id_tbl_typ;
9876: l_index number :=0 ;
9877: /* Bug 2790703 End */
9878:
9879: l_proj_start_Date DATE;

Line 10790: PA_STRUCT_TASK_ROLLUP_PUB.Tasks_Rollup_Unlimited(

10786:
10787: -- Bug 2790703 Begin
10788: IF (l_task_ver_ids_tbl.count > 0) THEN
10789: --rollup
10790: PA_STRUCT_TASK_ROLLUP_PUB.Tasks_Rollup_Unlimited(
10791: p_commit => FND_API.G_FALSE,
10792: p_element_versions => l_task_ver_ids_tbl,
10793: x_return_status => l_return_status,
10794: x_msg_count => l_msg_count,

Line 14226: l_task_ver_ids_tbl PA_STRUCT_TASK_ROLLUP_PUB.pa_element_version_id_tbl_typ;

14222: l_object_type VARCHAR2(30);
14223: l_task_ver_id NUMBER;
14224: /* Bug 2790703 Begin */
14225: -- l_task_ver_ids PA_NUM_1000_NUM := PA_NUM_1000_NUM();
14226: l_task_ver_ids_tbl PA_STRUCT_TASK_ROLLUP_PUB.pa_element_version_id_tbl_typ;
14227: l_index number :=0 ;
14228: /* Bug 2790703 End */
14229:
14230: l_proj_start_Date DATE;

Line 15510: PA_STRUCT_TASK_ROLLUP_PUB.Tasks_Rollup_Unlimited(

15506: CLOSE sel_struc_and_task_vers;
15507:
15508: IF (l_task_ver_ids_tbl.count > 0) THEN
15509: --rollup
15510: PA_STRUCT_TASK_ROLLUP_PUB.Tasks_Rollup_Unlimited(
15511: p_commit => FND_API.G_FALSE,
15512: p_element_versions => l_task_ver_ids_tbl,
15513: x_return_status => l_return_status,
15514: x_msg_count => l_msg_count,

Line 17499: PA_STRUCT_TASK_ROLLUP_PUB.Tasks_Rollup_Unlimited(

17495: CLOSE sel_struc_and_task_vers;
17496:
17497: IF (l_task_ver_ids_tbl.count > 0) THEN
17498: --rollup
17499: PA_STRUCT_TASK_ROLLUP_PUB.Tasks_Rollup_Unlimited(
17500: p_commit => FND_API.G_FALSE,
17501: p_element_versions => l_task_ver_ids_tbl,
17502: x_return_status => l_return_status,
17503: x_msg_count => l_msg_count,

Line 17891: PA_STRUCT_TASK_ROLLUP_PUB.Tasks_Rollup_Unlimited(

17887: CLOSE sel_struc_and_task_vers;
17888:
17889: IF (l_task_ver_ids_tbl.count > 0) THEN
17890: --rollup
17891: PA_STRUCT_TASK_ROLLUP_PUB.Tasks_Rollup_Unlimited(
17892: p_commit => FND_API.G_FALSE,
17893: p_element_versions => l_task_ver_ids_tbl,
17894: x_return_status => l_return_status,
17895: x_msg_count => l_msg_count,