APPS.PA_PROJECT_STRUCTURE_PVT1 dependencies on PA_STRUCT_TASK_ROLLUP_PUB

Line 3233: l_task_ver_ids_tbl PA_STRUCT_TASK_ROLLUP_PUB.pa_element_version_id_tbl_typ;

3229: l_login_id NUMBER := FND_GLOBAL.LOGIN_ID;
3230: --maansari
3231:
3232: --bug 3047602
3233: l_task_ver_ids_tbl PA_STRUCT_TASK_ROLLUP_PUB.pa_element_version_id_tbl_typ;
3234: cursor get_all_new_childs(c_new_struc_ver_id NUMBER) IS
3235: select element_version_id
3236: from pa_proj_element_versions
3237: where parent_structure_version_id = c_new_struc_ver_id

Line 3394: -- PA_STRUCT_TASK_ROLLUP_PUB.Tasks_Rollup(

3390: -- END LOOP;
3391: -- CLOSE get_linking_tasks;
3392: --
3393: -- IF (l_tasks_ver_ids.count > 0) THEN
3394: -- PA_STRUCT_TASK_ROLLUP_PUB.Tasks_Rollup(
3395: -- p_commit => FND_API.G_FALSE,
3396: -- p_element_versions => l_tasks_ver_ids,
3397: -- x_return_status => l_return_status,
3398: -- x_msg_count => l_msg_count,

Line 5157: PA_STRUCT_TASK_ROLLUP_PUB.Tasks_Rollup_Unlimited(

5153: /* --hsiu: no need to rollup since the copied structure version is already rolled-up
5154: IF l_task_ver_ids_tbl.count > 0 THEN
5155: --rollup dates for new published version
5156:
5157: PA_STRUCT_TASK_ROLLUP_PUB.Tasks_Rollup_Unlimited(
5158: p_commit => FND_API.G_FALSE,
5159: p_element_versions => l_task_ver_ids_tbl,
5160: x_return_status => l_return_status,
5161: x_msg_count => l_msg_count,

Line 5393: PA_STRUCT_TASK_ROLLUP_PUB.Task_Stat_Pushdown_Rollup(

5389: --bug 4019845
5390: /*
5391: --hsiu: task status
5392: --push down and rollup
5393: PA_STRUCT_TASK_ROLLUP_PUB.Task_Stat_Pushdown_Rollup(
5394: p_structure_version_id => l_new_struct_ver_id
5395: ,x_return_status => x_return_status
5396: ,x_msg_count => x_msg_count
5397: ,x_msg_data => x_msg_data

Line 9503: l_task_ver_ids_tbl PA_STRUCT_TASK_ROLLUP_PUB.pa_element_version_id_tbl_typ;

9499: l_object_type VARCHAR2(30);
9500: l_task_ver_id NUMBER;
9501: /* Bug 2790703 Begin */
9502: -- l_task_ver_ids PA_NUM_1000_NUM := PA_NUM_1000_NUM();
9503: l_task_ver_ids_tbl PA_STRUCT_TASK_ROLLUP_PUB.pa_element_version_id_tbl_typ;
9504: l_index number :=0 ;
9505: /* Bug 2790703 End */
9506:
9507: l_proj_start_Date DATE;

Line 10418: PA_STRUCT_TASK_ROLLUP_PUB.Tasks_Rollup_Unlimited(

10414:
10415: -- Bug 2790703 Begin
10416: IF (l_task_ver_ids_tbl.count > 0) THEN
10417: --rollup
10418: PA_STRUCT_TASK_ROLLUP_PUB.Tasks_Rollup_Unlimited(
10419: p_commit => FND_API.G_FALSE,
10420: p_element_versions => l_task_ver_ids_tbl,
10421: x_return_status => l_return_status,
10422: x_msg_count => l_msg_count,

Line 13852: l_task_ver_ids_tbl PA_STRUCT_TASK_ROLLUP_PUB.pa_element_version_id_tbl_typ;

13848: l_object_type VARCHAR2(30);
13849: l_task_ver_id NUMBER;
13850: /* Bug 2790703 Begin */
13851: -- l_task_ver_ids PA_NUM_1000_NUM := PA_NUM_1000_NUM();
13852: l_task_ver_ids_tbl PA_STRUCT_TASK_ROLLUP_PUB.pa_element_version_id_tbl_typ;
13853: l_index number :=0 ;
13854: /* Bug 2790703 End */
13855:
13856: l_proj_start_Date DATE;

Line 15134: PA_STRUCT_TASK_ROLLUP_PUB.Tasks_Rollup_Unlimited(

15130: CLOSE sel_struc_and_task_vers;
15131:
15132: IF (l_task_ver_ids_tbl.count > 0) THEN
15133: --rollup
15134: PA_STRUCT_TASK_ROLLUP_PUB.Tasks_Rollup_Unlimited(
15135: p_commit => FND_API.G_FALSE,
15136: p_element_versions => l_task_ver_ids_tbl,
15137: x_return_status => l_return_status,
15138: x_msg_count => l_msg_count,

Line 17123: PA_STRUCT_TASK_ROLLUP_PUB.Tasks_Rollup_Unlimited(

17119: CLOSE sel_struc_and_task_vers;
17120:
17121: IF (l_task_ver_ids_tbl.count > 0) THEN
17122: --rollup
17123: PA_STRUCT_TASK_ROLLUP_PUB.Tasks_Rollup_Unlimited(
17124: p_commit => FND_API.G_FALSE,
17125: p_element_versions => l_task_ver_ids_tbl,
17126: x_return_status => l_return_status,
17127: x_msg_count => l_msg_count,

Line 17515: PA_STRUCT_TASK_ROLLUP_PUB.Tasks_Rollup_Unlimited(

17511: CLOSE sel_struc_and_task_vers;
17512:
17513: IF (l_task_ver_ids_tbl.count > 0) THEN
17514: --rollup
17515: PA_STRUCT_TASK_ROLLUP_PUB.Tasks_Rollup_Unlimited(
17516: p_commit => FND_API.G_FALSE,
17517: p_element_versions => l_task_ver_ids_tbl,
17518: x_return_status => l_return_status,
17519: x_msg_count => l_msg_count,