DBA Data[Home] [Help]

APPS.PA_PROGRESS_PVT dependencies on PA_PLSQL_DATATYPES

Line 1278: l_mapping_tasks_to_rollup_tab PA_PLSQL_DATATYPES.NumTabTyp;

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

Line 9799: I_PROJECT_ID PA_PLSQL_DATATYPES.Num15TabTyp;

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;

Line 9800: I_STRUCTURE_VERSION_ID PA_PLSQL_DATATYPES.Num15TabTyp;

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;

Line 9801: I_TASK_ID PA_PLSQL_DATATYPES.Num15TabTyp;

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;

Line 9802: I_RESOURCE_ASSIGNMENT_ID PA_PLSQL_DATATYPES.Num15TabTyp;

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;

Line 9803: I_ACTUAL_COST PA_PLSQL_DATATYPES.AmtTabTyp;

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;

Line 9804: I_ACTUAL_EFFORT PA_PLSQL_DATATYPES.QtyTabtyp;

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;

Line 9805: I_PERIOD_NAME PA_PLSQL_DATATYPES.Char30TabTyp;

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;

Line 9806: I_TXN_CURRENCY_CODE PA_PLSQL_DATATYPES.Char15TabTyp;

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;

Line 9807: I_ACTUAL_COST_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;

Line 9808: I_ACTUAL_COST_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;

Line 9809: I_ACTUAL_RAWCOST PA_PLSQL_DATATYPES.AmtTabTyp;

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;

Line 9810: I_ACTUAL_RAWCOST_PC PA_PLSQL_DATATYPES.AmtTabTyp;

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;

Line 9811: I_ACTUAL_RAWCOST_FC PA_PLSQL_DATATYPES.AmtTabTyp;

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:

Line 9812: I_RESOURCE_LIST_MEMBER_ID PA_PLSQL_DATATYPES.Num15TabTyp;

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;

Line 9813: I_START_DATE PA_PLSQL_DATATYPES.DateTabTyp;

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;

Line 9814: I_END_DATE PA_PLSQL_DATATYPES.DateTabTyp;

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:

Line 11547: l_mapping_tasks_to_rollup_tab PA_PLSQL_DATATYPES.NumTabTyp;

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

Line 14167: l_defer_arr_task_id PA_PLSQL_DATATYPES.NumTabTyp;

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.

Line 15108: l_mapping_tasks_to_rollup_tab PA_PLSQL_DATATYPES.NumTabTyp;

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