APPS.PA_STRUCT_TASK_ROLLUP_PUB dependencies on PA_PROJECT_PUB

Line 1418: IF PA_PROJECT_PUB.G_MASS_ADD_TASKS = 'Y' THEN

1414:
1415: -- Added IF condition for Huawei enhancement bug 13923366 by skkoppul
1416: -- During bulk add tasks mode, get just the parent details of each of the nodes
1417: -- that are being added instead of getting all parents nodes in the branch
1418: IF PA_PROJECT_PUB.G_MASS_ADD_TASKS = 'Y' THEN
1419: l_sql := ' select distinct a.project_id, a.element_version_id, '||
1420: ' a.object_type, b.PLANNED_EFFORT, '||
1421: ' nvl(a.wbs_level,0), b.scheduled_start_date, '||
1422: ' b.scheduled_finish_date, c.object_id_from1, '||

Line 1583: pa_debug.g_err_stage := 'Value of G_OP_VALIDATE_flag'||PA_PROJECT_PUB.G_OP_VALIDATE_FLAG ;

1579:
1580: close l_cur;
1581: --Added by rtarway, 4218977
1582: IF l_debug_mode = 'Y' THEN
1583: pa_debug.g_err_stage := 'Value of G_OP_VALIDATE_flag'||PA_PROJECT_PUB.G_OP_VALIDATE_FLAG ;
1584: pa_debug.write(g_module_name,pa_debug.g_err_stage,3);
1585: END IF;
1586: --If Added by rtarway, BUG 4218977
1587: --Added null condition, for BUG 4226832

Line 1588: if (PA_PROJECT_PUB.G_OP_VALIDATE_FLAG is null OR PA_PROJECT_PUB.G_OP_VALIDATE_FLAG = 'Y' ) then

1584: pa_debug.write(g_module_name,pa_debug.g_err_stage,3);
1585: END IF;
1586: --If Added by rtarway, BUG 4218977
1587: --Added null condition, for BUG 4226832
1588: if (PA_PROJECT_PUB.G_OP_VALIDATE_FLAG is null OR PA_PROJECT_PUB.G_OP_VALIDATE_FLAG = 'Y' ) then
1589:
1590: PA_SCHEDULE_OBJECTS_PVT.GENERATE_SCHEDULE(
1591: p_debug_mode => 'N',
1592: p_data_structure => l_rollup_table,

Line 1740: if (PA_PROJECT_PUB.G_OP_VALIDATE_FLAG is null OR PA_PROJECT_PUB.G_OP_VALIDATE_FLAG = 'Y' ) then

1736: DBMS_SQL.CLOSE_CURSOR(l_CursorId);
1737: RAISE;
1738: END;
1739: */
1740: if (PA_PROJECT_PUB.G_OP_VALIDATE_FLAG is null OR PA_PROJECT_PUB.G_OP_VALIDATE_FLAG = 'Y' ) then
1741:
1742: FOR i IN l_rollup_table.first..l_rollup_table.last LOOP
1743: l_sch_start_date_tbl(i) := l_rollup_table(i).start_date1;
1744: l_sch_finish_date_tbl(i) := l_rollup_table(i).finish_date1;

Line 2407: if PA_PROJECT_PUB.G_MASS_ADD_TASKS = 'Y' then

2403: --begin rollup
2404:
2405: l_cnt := 0;
2406: -- Added below if conidition and logic for Huawei enhancemnet - bug 13923366
2407: if PA_PROJECT_PUB.G_MASS_ADD_TASKS = 'Y' then
2408: OPEN get_task_version_details;
2409: LOOP
2410: l_cnt := l_cnt + 1;
2411: FETCH get_task_version_details into l_task_version_details_rec;

Line 2470: END IF; -- END for if PA_PROJECT_PUB.G_MASS_ADD_TASKS = 'Y' - bug 13923366

2466: l_rollup_table(l_cnt).TASK_STATUS1 := l_get_task_ver_id_rec.PROJECT_STATUS_WEIGHT;
2467: l_rollup_table(l_cnt).TASK_STATUS2 := l_get_task_ver_id_rec.PROJECT_STATUS_WEIGHT;
2468: END LOOP;
2469: CLOSE get_task_version_id;
2470: END IF; -- END for if PA_PROJECT_PUB.G_MASS_ADD_TASKS = 'Y' - bug 13923366
2471:
2472: -- hsiu: bug 2800553: added for performance improvement
2473: IF (p_element_version_id IS NULL) THEN
2474: l_partial_flag := 'N';