DBA Data[Home] [Help]

APPS.PA_PROJ_TASK_STRUC_PUB dependencies on PA_STRUCT_TASK_ROLLUP_PUB

Line 1891: PA_STRUCT_TASK_ROLLUP_PUB.Task_Status_Rollup(

1887: -- Bug 4067757 used l_versioned instead of calling Check_Wp_Versioning_Enabled multiple times
1888: /* (PA_WORKPLAN_ATTR_UTILS.Check_Wp_Versioning_Enabled(p_project_id) = 'N') AND */
1889: (l_versioned = 'N') AND NVL(PA_PROJECT_PUB.G_ROLLUP_DEFER, 'N') = 'N' AND -- Check roll up flag to defer roll ups 14556729
1890: (PA_PROJECT_STRUCTURE_UTILS.get_struc_type_for_structure(l_structure_id, 'WORKPLAN') = 'Y') THEN
1891: PA_STRUCT_TASK_ROLLUP_PUB.Task_Status_Rollup(
1892: p_structure_version_id => l_parent_struc_ver_id
1893: ,p_element_version_id => l_task_version_id
1894: ,x_return_status => l_return_status
1895: ,x_msg_count => l_msg_count

Line 6368: PA_STRUCT_TASK_ROLLUP_PUB.Tasks_Rollup(

6364: l_outline_level.extend;
6365: l_outline_level(l_outline_level.count) := null;
6366:
6367: /*--bug 2856033
6368: PA_STRUCT_TASK_ROLLUP_PUB.Tasks_Rollup(
6369: p_commit => FND_API.G_FALSE,
6370: p_element_versions => l_tasks_ver_ids,
6371: x_return_status => l_return_status,
6372: x_msg_count => l_msg_count,

Line 6452: PA_STRUCT_TASK_ROLLUP_PUB.Tasks_Rollup(

6448: l_outline_level.extend;
6449: l_outline_level(l_outline_level.count) := null;
6450:
6451: /*--bug 2856033
6452: PA_STRUCT_TASK_ROLLUP_PUB.Tasks_Rollup(
6453: p_commit => FND_API.G_FALSE,
6454: p_element_versions => l_tasks_ver_ids,
6455: x_return_status => l_return_status,
6456: x_msg_count => l_msg_count,

Line 13503: l_tasks_ver_ids PA_STRUCT_TASK_ROLLUP_PUB.pa_element_version_id_tbl_typ;

13499: ,x_return_status OUT NOCOPY VARCHAR2 ) IS --File.Sql.39 bug 4440895
13500:
13501: i NUMBER;
13502:
13503: l_tasks_ver_ids PA_STRUCT_TASK_ROLLUP_PUB.pa_element_version_id_tbl_typ;
13504: l_task_version_id NUMBER;
13505:
13506: l_msg_count NUMBER;
13507: l_return_status VARCHAR2(1);

Line 13556: PA_STRUCT_TASK_ROLLUP_PUB.TASKS_ROLLUP_UNLIMITED(

13552: ELSE
13553: l_tasks_ver_ids(1) := p_task_version_id;
13554: END IF;
13555:
13556: PA_STRUCT_TASK_ROLLUP_PUB.TASKS_ROLLUP_UNLIMITED(
13557: p_calling_module => 'AMG'
13558: ,p_element_versions => l_tasks_ver_ids
13559: ,x_return_status => l_return_status
13560: ,x_msg_count => l_msg_count

Line 17314: PA_STRUCT_TASK_ROLLUP_PUB.Task_Status_Rollup(

17310: pa_debug.g_err_stage := 'Calling API Task status rollup';
17311: pa_debug.write(l_module_name,pa_debug.g_err_stage,l_debug_level4);
17312: END IF;
17313:
17314: PA_STRUCT_TASK_ROLLUP_PUB.Task_Status_Rollup(
17315: p_structure_version_id => l_structure_version_id
17316: ,p_element_version_id => null
17317: ,x_return_status => x_return_status
17318: ,x_msg_count => x_msg_count

Line 20144: --bug 4287813 --move the code in PA_STRUCT_TASK_ROLLUP_PUB.Program_Schedule_dates_rollup for

20140:
20141:
20142: --moved this code here from above for bugfix 4296915. This is required in order to pick the
20143: --published str version in tasks_rollup api after its status is set to published..
20144: --bug 4287813 --move the code in PA_STRUCT_TASK_ROLLUP_PUB.Program_Schedule_dates_rollup for
20145: --bug 4541039
20146:
20147: --this rollup call is require to rollup from a published structure of sub-project to this project
20148: --if the link is created but process updates is not run.

Line 20163: pa_debug.write(G_PKG_NAME, 'Before calling PA_STRUCT_TASK_ROLLUP_PUB.Program_Schedule_dates_rollup for entire grid in PUBLISH mode', 3);

20159: THEN
20160:
20161: --call the dates rollup API for the structure version
20162: IF l_debug_mode = 'Y' THEN
20163: pa_debug.write(G_PKG_NAME, 'Before calling PA_STRUCT_TASK_ROLLUP_PUB.Program_Schedule_dates_rollup for entire grid in PUBLISH mode', 3);
20164: END IF;
20165:
20166: PA_STRUCT_TASK_ROLLUP_PUB.Program_Schedule_dates_rollup(
20167: p_project_id => p_project_id,

Line 20166: PA_STRUCT_TASK_ROLLUP_PUB.Program_Schedule_dates_rollup(

20162: IF l_debug_mode = 'Y' THEN
20163: pa_debug.write(G_PKG_NAME, 'Before calling PA_STRUCT_TASK_ROLLUP_PUB.Program_Schedule_dates_rollup for entire grid in PUBLISH mode', 3);
20164: END IF;
20165:
20166: PA_STRUCT_TASK_ROLLUP_PUB.Program_Schedule_dates_rollup(
20167: p_project_id => p_project_id,
20168: p_published_str_ver_id => l_pub_ver_id,
20169: x_return_status => x_return_status,
20170: x_msg_count => x_msg_count,

Line 20174: pa_debug.write(G_PKG_NAME, 'After calling PA_STRUCT_TASK_ROLLUP_PUB.Program_Schedule_dates_rollup for entire grid in PUBLISH mode x_return_status='||x_return_status, 3);

20170: x_msg_count => x_msg_count,
20171: x_msg_data => x_msg_data);
20172:
20173: IF l_debug_mode = 'Y' THEN
20174: pa_debug.write(G_PKG_NAME, 'After calling PA_STRUCT_TASK_ROLLUP_PUB.Program_Schedule_dates_rollup for entire grid in PUBLISH mode x_return_status='||x_return_status, 3);
20175: END IF;
20176:
20177: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
20178: RAISE Invalid_Arg_Exc_WP;

Line 20202: pa_debug.write(G_PKG_NAME, 'Before calling PA_STRUCT_TASK_ROLLUP_PUB.Program_Schedule_dates_rollup for published structure verison in PUBLISH mode', 3);

20198: ,p_link_type => 'WORKPLAN' ) = 'Y'
20199: IF PA_PROJECT_STRUCTURE_UTILS.Check_Subproject_Exists(l_project_id,l_pub_ver_id, 'WORKPLAN') = 'Y'
20200: THEN
20201: IF l_debug_mode = 'Y' THEN
20202: pa_debug.write(G_PKG_NAME, 'Before calling PA_STRUCT_TASK_ROLLUP_PUB.Program_Schedule_dates_rollup for published structure verison in PUBLISH mode', 3);
20203: END IF;
20204:
20205: PA_STRUCT_TASK_ROLLUP_PUB.Program_Schedule_dates_rollup(
20206: p_project_id => p_project_id,

Line 20205: PA_STRUCT_TASK_ROLLUP_PUB.Program_Schedule_dates_rollup(

20201: IF l_debug_mode = 'Y' THEN
20202: pa_debug.write(G_PKG_NAME, 'Before calling PA_STRUCT_TASK_ROLLUP_PUB.Program_Schedule_dates_rollup for published structure verison in PUBLISH mode', 3);
20203: END IF;
20204:
20205: PA_STRUCT_TASK_ROLLUP_PUB.Program_Schedule_dates_rollup(
20206: p_project_id => p_project_id,
20207: p_structure_version_id => l_pub_ver_id,
20208: x_return_status => x_return_status,
20209: x_msg_count => x_msg_count,

Line 20213: pa_debug.write(G_PKG_NAME, 'After calling PA_STRUCT_TASK_ROLLUP_PUB.Program_Schedule_dates_rollup for published structure version in PUBLISH mode x_return_status='||x_return_status, 3);

20209: x_msg_count => x_msg_count,
20210: x_msg_data => x_msg_data);
20211:
20212: IF l_debug_mode = 'Y' THEN
20213: pa_debug.write(G_PKG_NAME, 'After calling PA_STRUCT_TASK_ROLLUP_PUB.Program_Schedule_dates_rollup for published structure version in PUBLISH mode x_return_status='||x_return_status, 3);
20214: END IF;
20215:
20216: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
20217: RAISE Invalid_Arg_Exc_WP;

Line 20231: PA_STRUCT_TASK_ROLLUP_PUB.Task_Stat_Pushdown_Rollup(

20227: pa_debug.write(G_PKG_NAME, 'Calling Task_Stat_Pushdown_Rollup', 3);
20228: END IF;
20229:
20230: --push down and rollup
20231: PA_STRUCT_TASK_ROLLUP_PUB.Task_Stat_Pushdown_Rollup(
20232: p_structure_version_id => l_pub_ver_id
20233: ,x_return_status => x_return_status
20234: ,x_msg_count => x_msg_count
20235: ,x_msg_data => x_msg_data

Line 20918: pa_debug.write(G_PKG_NAME, 'Before calling PA_STRUCT_TASK_ROLLUP_PUB.Program_Schedule_dates_rollup for entire grid in UPDATE mode', 3);

20914: IF PA_RELATIONSHIP_UTILS.Check_link_exists( p_project_id => p_project_id
20915: ,p_link_type => 'WORKPLAN' ) = 'Y'
20916: THEN
20917: IF l_debug_mode = 'Y' THEN
20918: pa_debug.write(G_PKG_NAME, 'Before calling PA_STRUCT_TASK_ROLLUP_PUB.Program_Schedule_dates_rollup for entire grid in UPDATE mode', 3);
20919: END IF;
20920:
20921: PA_TASK_ASSIGNMENT_UTILS.g_apply_progress_flag := 'Y'; --although th
20922: PA_STRUCT_TASK_ROLLUP_PUB.Program_Schedule_dates_rollup(

Line 20922: PA_STRUCT_TASK_ROLLUP_PUB.Program_Schedule_dates_rollup(

20918: pa_debug.write(G_PKG_NAME, 'Before calling PA_STRUCT_TASK_ROLLUP_PUB.Program_Schedule_dates_rollup for entire grid in UPDATE mode', 3);
20919: END IF;
20920:
20921: PA_TASK_ASSIGNMENT_UTILS.g_apply_progress_flag := 'Y'; --although th
20922: PA_STRUCT_TASK_ROLLUP_PUB.Program_Schedule_dates_rollup(
20923: p_project_id => p_project_id,
20924: x_return_status => x_return_status,
20925: x_msg_count => x_msg_count,
20926: x_msg_data => x_msg_data);

Line 20929: pa_debug.write(G_PKG_NAME, 'After calling PA_STRUCT_TASK_ROLLUP_PUB.Program_Schedule_dates_rollup for entire grid in UPDATE mode x_return_status='||x_return_status, 3);

20925: x_msg_count => x_msg_count,
20926: x_msg_data => x_msg_data);
20927:
20928: IF l_debug_mode = 'Y' THEN
20929: pa_debug.write(G_PKG_NAME, 'After calling PA_STRUCT_TASK_ROLLUP_PUB.Program_Schedule_dates_rollup for entire grid in UPDATE mode x_return_status='||x_return_status, 3);
20930: END IF;
20931:
20932: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
20933: RAISE Invalid_Arg_Exc_WP;