1274:
1275: --bug 4045979, end
1276:
1277: l_tsk_progress_exists VARCHAR2(1);
1278: l_mapping_tasks_to_rollup_tab PA_PLSQL_DATATYPES.NumTabTyp;
1279:
1280: -- Bug 4242787 : Added Cursor cur_tree_rollup_dates
1281: CURSOR cur_tree_rollup_dates
1282: IS
9795: bl.txn_init_raw_cost is not null);
9796:
9797: cur_ppabpt_rec cur_ppabpt%ROWTYPE;
9798:
9799: I_PROJECT_ID PA_PLSQL_DATATYPES.Num15TabTyp;
9800: I_STRUCTURE_VERSION_ID PA_PLSQL_DATATYPES.Num15TabTyp;
9801: I_TASK_ID PA_PLSQL_DATATYPES.Num15TabTyp;
9802: I_RESOURCE_ASSIGNMENT_ID PA_PLSQL_DATATYPES.Num15TabTyp;
9803: I_ACTUAL_COST PA_PLSQL_DATATYPES.AmtTabTyp;
9796:
9797: cur_ppabpt_rec cur_ppabpt%ROWTYPE;
9798:
9799: I_PROJECT_ID PA_PLSQL_DATATYPES.Num15TabTyp;
9800: I_STRUCTURE_VERSION_ID PA_PLSQL_DATATYPES.Num15TabTyp;
9801: I_TASK_ID PA_PLSQL_DATATYPES.Num15TabTyp;
9802: I_RESOURCE_ASSIGNMENT_ID PA_PLSQL_DATATYPES.Num15TabTyp;
9803: I_ACTUAL_COST PA_PLSQL_DATATYPES.AmtTabTyp;
9804: I_ACTUAL_EFFORT PA_PLSQL_DATATYPES.QtyTabtyp;
9797: cur_ppabpt_rec cur_ppabpt%ROWTYPE;
9798:
9799: I_PROJECT_ID PA_PLSQL_DATATYPES.Num15TabTyp;
9800: I_STRUCTURE_VERSION_ID PA_PLSQL_DATATYPES.Num15TabTyp;
9801: I_TASK_ID PA_PLSQL_DATATYPES.Num15TabTyp;
9802: I_RESOURCE_ASSIGNMENT_ID PA_PLSQL_DATATYPES.Num15TabTyp;
9803: I_ACTUAL_COST PA_PLSQL_DATATYPES.AmtTabTyp;
9804: I_ACTUAL_EFFORT PA_PLSQL_DATATYPES.QtyTabtyp;
9805: I_PERIOD_NAME PA_PLSQL_DATATYPES.Char30TabTyp;
9798:
9799: I_PROJECT_ID PA_PLSQL_DATATYPES.Num15TabTyp;
9800: I_STRUCTURE_VERSION_ID PA_PLSQL_DATATYPES.Num15TabTyp;
9801: I_TASK_ID PA_PLSQL_DATATYPES.Num15TabTyp;
9802: I_RESOURCE_ASSIGNMENT_ID PA_PLSQL_DATATYPES.Num15TabTyp;
9803: I_ACTUAL_COST PA_PLSQL_DATATYPES.AmtTabTyp;
9804: I_ACTUAL_EFFORT PA_PLSQL_DATATYPES.QtyTabtyp;
9805: I_PERIOD_NAME PA_PLSQL_DATATYPES.Char30TabTyp;
9806: I_TXN_CURRENCY_CODE PA_PLSQL_DATATYPES.Char15TabTyp;
9799: I_PROJECT_ID PA_PLSQL_DATATYPES.Num15TabTyp;
9800: I_STRUCTURE_VERSION_ID PA_PLSQL_DATATYPES.Num15TabTyp;
9801: I_TASK_ID PA_PLSQL_DATATYPES.Num15TabTyp;
9802: I_RESOURCE_ASSIGNMENT_ID PA_PLSQL_DATATYPES.Num15TabTyp;
9803: I_ACTUAL_COST PA_PLSQL_DATATYPES.AmtTabTyp;
9804: I_ACTUAL_EFFORT PA_PLSQL_DATATYPES.QtyTabtyp;
9805: I_PERIOD_NAME PA_PLSQL_DATATYPES.Char30TabTyp;
9806: I_TXN_CURRENCY_CODE PA_PLSQL_DATATYPES.Char15TabTyp;
9807: I_ACTUAL_COST_PC PA_PLSQL_DATATYPES.AmtTabTyp;
9800: I_STRUCTURE_VERSION_ID PA_PLSQL_DATATYPES.Num15TabTyp;
9801: I_TASK_ID PA_PLSQL_DATATYPES.Num15TabTyp;
9802: I_RESOURCE_ASSIGNMENT_ID PA_PLSQL_DATATYPES.Num15TabTyp;
9803: I_ACTUAL_COST PA_PLSQL_DATATYPES.AmtTabTyp;
9804: I_ACTUAL_EFFORT PA_PLSQL_DATATYPES.QtyTabtyp;
9805: I_PERIOD_NAME PA_PLSQL_DATATYPES.Char30TabTyp;
9806: I_TXN_CURRENCY_CODE PA_PLSQL_DATATYPES.Char15TabTyp;
9807: I_ACTUAL_COST_PC PA_PLSQL_DATATYPES.AmtTabTyp;
9808: I_ACTUAL_COST_FC PA_PLSQL_DATATYPES.AmtTabTyp;
9801: I_TASK_ID PA_PLSQL_DATATYPES.Num15TabTyp;
9802: I_RESOURCE_ASSIGNMENT_ID PA_PLSQL_DATATYPES.Num15TabTyp;
9803: I_ACTUAL_COST PA_PLSQL_DATATYPES.AmtTabTyp;
9804: I_ACTUAL_EFFORT PA_PLSQL_DATATYPES.QtyTabtyp;
9805: I_PERIOD_NAME PA_PLSQL_DATATYPES.Char30TabTyp;
9806: I_TXN_CURRENCY_CODE PA_PLSQL_DATATYPES.Char15TabTyp;
9807: I_ACTUAL_COST_PC PA_PLSQL_DATATYPES.AmtTabTyp;
9808: I_ACTUAL_COST_FC PA_PLSQL_DATATYPES.AmtTabTyp;
9809: I_ACTUAL_RAWCOST PA_PLSQL_DATATYPES.AmtTabTyp;
9802: I_RESOURCE_ASSIGNMENT_ID PA_PLSQL_DATATYPES.Num15TabTyp;
9803: I_ACTUAL_COST PA_PLSQL_DATATYPES.AmtTabTyp;
9804: I_ACTUAL_EFFORT PA_PLSQL_DATATYPES.QtyTabtyp;
9805: I_PERIOD_NAME PA_PLSQL_DATATYPES.Char30TabTyp;
9806: I_TXN_CURRENCY_CODE PA_PLSQL_DATATYPES.Char15TabTyp;
9807: I_ACTUAL_COST_PC PA_PLSQL_DATATYPES.AmtTabTyp;
9808: I_ACTUAL_COST_FC PA_PLSQL_DATATYPES.AmtTabTyp;
9809: I_ACTUAL_RAWCOST PA_PLSQL_DATATYPES.AmtTabTyp;
9810: I_ACTUAL_RAWCOST_PC PA_PLSQL_DATATYPES.AmtTabTyp;
9803: I_ACTUAL_COST PA_PLSQL_DATATYPES.AmtTabTyp;
9804: I_ACTUAL_EFFORT PA_PLSQL_DATATYPES.QtyTabtyp;
9805: I_PERIOD_NAME PA_PLSQL_DATATYPES.Char30TabTyp;
9806: I_TXN_CURRENCY_CODE PA_PLSQL_DATATYPES.Char15TabTyp;
9807: I_ACTUAL_COST_PC PA_PLSQL_DATATYPES.AmtTabTyp;
9808: I_ACTUAL_COST_FC PA_PLSQL_DATATYPES.AmtTabTyp;
9809: I_ACTUAL_RAWCOST PA_PLSQL_DATATYPES.AmtTabTyp;
9810: I_ACTUAL_RAWCOST_PC PA_PLSQL_DATATYPES.AmtTabTyp;
9811: I_ACTUAL_RAWCOST_FC PA_PLSQL_DATATYPES.AmtTabTyp;
9804: I_ACTUAL_EFFORT PA_PLSQL_DATATYPES.QtyTabtyp;
9805: I_PERIOD_NAME PA_PLSQL_DATATYPES.Char30TabTyp;
9806: I_TXN_CURRENCY_CODE PA_PLSQL_DATATYPES.Char15TabTyp;
9807: I_ACTUAL_COST_PC PA_PLSQL_DATATYPES.AmtTabTyp;
9808: I_ACTUAL_COST_FC PA_PLSQL_DATATYPES.AmtTabTyp;
9809: I_ACTUAL_RAWCOST PA_PLSQL_DATATYPES.AmtTabTyp;
9810: I_ACTUAL_RAWCOST_PC PA_PLSQL_DATATYPES.AmtTabTyp;
9811: I_ACTUAL_RAWCOST_FC PA_PLSQL_DATATYPES.AmtTabTyp;
9812: I_RESOURCE_LIST_MEMBER_ID PA_PLSQL_DATATYPES.Num15TabTyp;
9805: I_PERIOD_NAME PA_PLSQL_DATATYPES.Char30TabTyp;
9806: I_TXN_CURRENCY_CODE PA_PLSQL_DATATYPES.Char15TabTyp;
9807: I_ACTUAL_COST_PC PA_PLSQL_DATATYPES.AmtTabTyp;
9808: I_ACTUAL_COST_FC PA_PLSQL_DATATYPES.AmtTabTyp;
9809: I_ACTUAL_RAWCOST PA_PLSQL_DATATYPES.AmtTabTyp;
9810: I_ACTUAL_RAWCOST_PC PA_PLSQL_DATATYPES.AmtTabTyp;
9811: I_ACTUAL_RAWCOST_FC PA_PLSQL_DATATYPES.AmtTabTyp;
9812: I_RESOURCE_LIST_MEMBER_ID PA_PLSQL_DATATYPES.Num15TabTyp;
9813: I_START_DATE PA_PLSQL_DATATYPES.DateTabTyp;
9806: I_TXN_CURRENCY_CODE PA_PLSQL_DATATYPES.Char15TabTyp;
9807: I_ACTUAL_COST_PC PA_PLSQL_DATATYPES.AmtTabTyp;
9808: I_ACTUAL_COST_FC PA_PLSQL_DATATYPES.AmtTabTyp;
9809: I_ACTUAL_RAWCOST PA_PLSQL_DATATYPES.AmtTabTyp;
9810: I_ACTUAL_RAWCOST_PC PA_PLSQL_DATATYPES.AmtTabTyp;
9811: I_ACTUAL_RAWCOST_FC PA_PLSQL_DATATYPES.AmtTabTyp;
9812: I_RESOURCE_LIST_MEMBER_ID PA_PLSQL_DATATYPES.Num15TabTyp;
9813: I_START_DATE PA_PLSQL_DATATYPES.DateTabTyp;
9814: I_END_DATE PA_PLSQL_DATATYPES.DateTabTyp;
9807: I_ACTUAL_COST_PC PA_PLSQL_DATATYPES.AmtTabTyp;
9808: I_ACTUAL_COST_FC PA_PLSQL_DATATYPES.AmtTabTyp;
9809: I_ACTUAL_RAWCOST PA_PLSQL_DATATYPES.AmtTabTyp;
9810: I_ACTUAL_RAWCOST_PC PA_PLSQL_DATATYPES.AmtTabTyp;
9811: I_ACTUAL_RAWCOST_FC PA_PLSQL_DATATYPES.AmtTabTyp;
9812: I_RESOURCE_LIST_MEMBER_ID PA_PLSQL_DATATYPES.Num15TabTyp;
9813: I_START_DATE PA_PLSQL_DATATYPES.DateTabTyp;
9814: I_END_DATE PA_PLSQL_DATATYPES.DateTabTyp;
9815:
9808: I_ACTUAL_COST_FC PA_PLSQL_DATATYPES.AmtTabTyp;
9809: I_ACTUAL_RAWCOST PA_PLSQL_DATATYPES.AmtTabTyp;
9810: I_ACTUAL_RAWCOST_PC PA_PLSQL_DATATYPES.AmtTabTyp;
9811: I_ACTUAL_RAWCOST_FC PA_PLSQL_DATATYPES.AmtTabTyp;
9812: I_RESOURCE_LIST_MEMBER_ID PA_PLSQL_DATATYPES.Num15TabTyp;
9813: I_START_DATE PA_PLSQL_DATATYPES.DateTabTyp;
9814: I_END_DATE PA_PLSQL_DATATYPES.DateTabTyp;
9815:
9816: l_index NUMBER := null;
9809: I_ACTUAL_RAWCOST PA_PLSQL_DATATYPES.AmtTabTyp;
9810: I_ACTUAL_RAWCOST_PC PA_PLSQL_DATATYPES.AmtTabTyp;
9811: I_ACTUAL_RAWCOST_FC PA_PLSQL_DATATYPES.AmtTabTyp;
9812: I_RESOURCE_LIST_MEMBER_ID PA_PLSQL_DATATYPES.Num15TabTyp;
9813: I_START_DATE PA_PLSQL_DATATYPES.DateTabTyp;
9814: I_END_DATE PA_PLSQL_DATATYPES.DateTabTyp;
9815:
9816: l_index NUMBER := null;
9817: i NUMBER := null;
9810: I_ACTUAL_RAWCOST_PC PA_PLSQL_DATATYPES.AmtTabTyp;
9811: I_ACTUAL_RAWCOST_FC PA_PLSQL_DATATYPES.AmtTabTyp;
9812: I_RESOURCE_LIST_MEMBER_ID PA_PLSQL_DATATYPES.Num15TabTyp;
9813: I_START_DATE PA_PLSQL_DATATYPES.DateTabTyp;
9814: I_END_DATE PA_PLSQL_DATATYPES.DateTabTyp;
9815:
9816: l_index NUMBER := null;
9817: i NUMBER := null;
9818:
11543:
11544: --bug 4045979, end
11545:
11546: l_tsk_progress_exists VARCHAR2(1);
11547: l_mapping_tasks_to_rollup_tab PA_PLSQL_DATATYPES.NumTabTyp;
11548:
11549: -- Bug 4242787 : Added Cursor cur_tree_rollup_dates
11550: CURSOR cur_tree_rollup_dates
11551: IS
14163:
14164:
14165: -- sridhar_rollup
14166:
14167: l_defer_arr_task_id PA_PLSQL_DATATYPES.NumTabTyp;
14168:
14169: -- Rollup Cases
14170: -- 1. Workplan Publsihed Version Rollup.
14171: -- 2. Workplan Working Version Rollup.
15104:
15105: --bug 4045979, end
15106:
15107: l_tsk_progress_exists VARCHAR2(1);
15108: l_mapping_tasks_to_rollup_tab PA_PLSQL_DATATYPES.NumTabTyp;
15109:
15110: -- Bug 4242787 : Added Cursor cur_tree_rollup_dates
15111: CURSOR cur_tree_rollup_dates
15112: IS