DBA Data[Home] [Help]

APPS.PA_PROJ_TASK_STRUC_PUB dependencies on PA_STRUCT_TASK_ROLLUP_PUB

Line 1675: PA_STRUCT_TASK_ROLLUP_PUB.Task_Status_Rollup(

1671: -- Bug 4067757 used l_versioned instead of calling Check_Wp_Versioning_Enabled multiple times
1672: /* (PA_WORKPLAN_ATTR_UTILS.Check_Wp_Versioning_Enabled(p_project_id) = 'N') AND */
1673: (l_versioned = 'N') AND
1674: (PA_PROJECT_STRUCTURE_UTILS.get_struc_type_for_structure(l_structure_id, 'WORKPLAN') = 'Y') THEN
1675: PA_STRUCT_TASK_ROLLUP_PUB.Task_Status_Rollup(
1676: p_structure_version_id => l_parent_struc_ver_id
1677: ,p_element_version_id => l_task_version_id
1678: ,x_return_status => l_return_status
1679: ,x_msg_count => l_msg_count

Line 6119: PA_STRUCT_TASK_ROLLUP_PUB.Tasks_Rollup(

6115: l_outline_level.extend;
6116: l_outline_level(l_outline_level.count) := null;
6117:
6118: /*--bug 2856033
6119: PA_STRUCT_TASK_ROLLUP_PUB.Tasks_Rollup(
6120: p_commit => FND_API.G_FALSE,
6121: p_element_versions => l_tasks_ver_ids,
6122: x_return_status => l_return_status,
6123: x_msg_count => l_msg_count,

Line 6203: PA_STRUCT_TASK_ROLLUP_PUB.Tasks_Rollup(

6199: l_outline_level.extend;
6200: l_outline_level(l_outline_level.count) := null;
6201:
6202: /*--bug 2856033
6203: PA_STRUCT_TASK_ROLLUP_PUB.Tasks_Rollup(
6204: p_commit => FND_API.G_FALSE,
6205: p_element_versions => l_tasks_ver_ids,
6206: x_return_status => l_return_status,
6207: x_msg_count => l_msg_count,

Line 13174: l_tasks_ver_ids PA_STRUCT_TASK_ROLLUP_PUB.pa_element_version_id_tbl_typ;

13170: ,x_return_status OUT NOCOPY VARCHAR2 ) IS --File.Sql.39 bug 4440895
13171:
13172: i NUMBER;
13173:
13174: l_tasks_ver_ids PA_STRUCT_TASK_ROLLUP_PUB.pa_element_version_id_tbl_typ;
13175: l_task_version_id NUMBER;
13176:
13177: l_msg_count NUMBER;
13178: l_return_status VARCHAR2(1);

Line 13227: PA_STRUCT_TASK_ROLLUP_PUB.TASKS_ROLLUP_UNLIMITED(

13223: ELSE
13224: l_tasks_ver_ids(1) := p_task_version_id;
13225: END IF;
13226:
13227: PA_STRUCT_TASK_ROLLUP_PUB.TASKS_ROLLUP_UNLIMITED(
13228: p_calling_module => 'AMG'
13229: ,p_element_versions => l_tasks_ver_ids
13230: ,x_return_status => l_return_status
13231: ,x_msg_count => l_msg_count

Line 16666: PA_STRUCT_TASK_ROLLUP_PUB.Task_Status_Rollup(

16662: pa_debug.g_err_stage := 'Calling API Task status rollup';
16663: pa_debug.write(l_module_name,pa_debug.g_err_stage,l_debug_level4);
16664: END IF;
16665:
16666: PA_STRUCT_TASK_ROLLUP_PUB.Task_Status_Rollup(
16667: p_structure_version_id => l_structure_version_id
16668: ,p_element_version_id => null
16669: ,x_return_status => x_return_status
16670: ,x_msg_count => x_msg_count

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

19357: AND element_version_id = l_pub_ver_id;
19358:
19359: --moved this code here from above for bugfix 4296915. This is required in order to pick the
19360: --published str version in tasks_rollup api after its status is set to published..
19361: --bug 4287813 --move the code in PA_STRUCT_TASK_ROLLUP_PUB.Program_Schedule_dates_rollup for
19362: --bug 4541039
19363:
19364: --this rollup call is require to rollup from a published structure of sub-project to this project
19365: --if the link is created but process updates is not run.

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

19376: THEN
19377:
19378: --call the dates rollup API for the structure version
19379: IF l_debug_mode = 'Y' THEN
19380: pa_debug.write(G_PKG_NAME, 'Before calling PA_STRUCT_TASK_ROLLUP_PUB.Program_Schedule_dates_rollup for entire grid in PUBLISH mode', 3);
19381: END IF;
19382:
19383: PA_STRUCT_TASK_ROLLUP_PUB.Program_Schedule_dates_rollup(
19384: p_project_id => p_project_id,

Line 19383: PA_STRUCT_TASK_ROLLUP_PUB.Program_Schedule_dates_rollup(

19379: IF l_debug_mode = 'Y' THEN
19380: pa_debug.write(G_PKG_NAME, 'Before calling PA_STRUCT_TASK_ROLLUP_PUB.Program_Schedule_dates_rollup for entire grid in PUBLISH mode', 3);
19381: END IF;
19382:
19383: PA_STRUCT_TASK_ROLLUP_PUB.Program_Schedule_dates_rollup(
19384: p_project_id => p_project_id,
19385: p_published_str_ver_id => l_pub_ver_id,
19386: x_return_status => x_return_status,
19387: x_msg_count => x_msg_count,

Line 19391: 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);

19387: x_msg_count => x_msg_count,
19388: x_msg_data => x_msg_data);
19389:
19390: IF l_debug_mode = 'Y' THEN
19391: 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);
19392: END IF;
19393:
19394: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
19395: RAISE Invalid_Arg_Exc_WP;

Line 19407: 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);

19403: ,p_link_type => 'WORKPLAN' ) = 'Y'
19404: IF PA_PROJECT_STRUCTURE_UTILS.Check_Subproject_Exists(l_project_id,l_pub_ver_id, 'WORKPLAN') = 'Y'
19405: THEN
19406: IF l_debug_mode = 'Y' THEN
19407: 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);
19408: END IF;
19409:
19410: PA_STRUCT_TASK_ROLLUP_PUB.Program_Schedule_dates_rollup(
19411: p_project_id => p_project_id,

Line 19410: PA_STRUCT_TASK_ROLLUP_PUB.Program_Schedule_dates_rollup(

19406: IF l_debug_mode = 'Y' THEN
19407: 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);
19408: END IF;
19409:
19410: PA_STRUCT_TASK_ROLLUP_PUB.Program_Schedule_dates_rollup(
19411: p_project_id => p_project_id,
19412: p_structure_version_id => l_pub_ver_id,
19413: x_return_status => x_return_status,
19414: x_msg_count => x_msg_count,

Line 19418: 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);

19414: x_msg_count => x_msg_count,
19415: x_msg_data => x_msg_data);
19416:
19417: IF l_debug_mode = 'Y' THEN
19418: 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);
19419: END IF;
19420:
19421: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
19422: RAISE Invalid_Arg_Exc_WP;

Line 19436: PA_STRUCT_TASK_ROLLUP_PUB.Task_Stat_Pushdown_Rollup(

19432: pa_debug.write(G_PKG_NAME, 'Calling Task_Stat_Pushdown_Rollup', 3);
19433: END IF;
19434:
19435: --push down and rollup
19436: PA_STRUCT_TASK_ROLLUP_PUB.Task_Stat_Pushdown_Rollup(
19437: p_structure_version_id => l_pub_ver_id
19438: ,x_return_status => x_return_status
19439: ,x_msg_count => x_msg_count
19440: ,x_msg_data => x_msg_data

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

20119: IF PA_RELATIONSHIP_UTILS.Check_link_exists( p_project_id => p_project_id
20120: ,p_link_type => 'WORKPLAN' ) = 'Y'
20121: THEN
20122: IF l_debug_mode = 'Y' THEN
20123: pa_debug.write(G_PKG_NAME, 'Before calling PA_STRUCT_TASK_ROLLUP_PUB.Program_Schedule_dates_rollup for entire grid in UPDATE mode', 3);
20124: END IF;
20125:
20126: PA_TASK_ASSIGNMENT_UTILS.g_apply_progress_flag := 'Y'; --although th
20127: PA_STRUCT_TASK_ROLLUP_PUB.Program_Schedule_dates_rollup(

Line 20127: PA_STRUCT_TASK_ROLLUP_PUB.Program_Schedule_dates_rollup(

20123: pa_debug.write(G_PKG_NAME, 'Before calling PA_STRUCT_TASK_ROLLUP_PUB.Program_Schedule_dates_rollup for entire grid in UPDATE mode', 3);
20124: END IF;
20125:
20126: PA_TASK_ASSIGNMENT_UTILS.g_apply_progress_flag := 'Y'; --although th
20127: PA_STRUCT_TASK_ROLLUP_PUB.Program_Schedule_dates_rollup(
20128: p_project_id => p_project_id,
20129: x_return_status => x_return_status,
20130: x_msg_count => x_msg_count,
20131: x_msg_data => x_msg_data);

Line 20134: 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);

20130: x_msg_count => x_msg_count,
20131: x_msg_data => x_msg_data);
20132:
20133: IF l_debug_mode = 'Y' THEN
20134: 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);
20135: END IF;
20136:
20137: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
20138: RAISE Invalid_Arg_Exc_WP;