DBA Data[Home] [Help]

APPS.PA_PROGRESS_PVT dependencies on PA_PLSQL_DATATYPES

Line 1273: l_mapping_tasks_to_rollup_tab PA_PLSQL_DATATYPES.NumTabTyp;

1269:
1270: --bug 4045979, end
1271:
1272: l_tsk_progress_exists VARCHAR2(1);
1273: l_mapping_tasks_to_rollup_tab PA_PLSQL_DATATYPES.NumTabTyp;
1274:
1275: -- Bug 4242787 : Added Cursor cur_tree_rollup_dates
1276: CURSOR cur_tree_rollup_dates
1277: IS

Line 9731: I_PROJECT_ID PA_PLSQL_DATATYPES.Num15TabTyp;

9727: bl.txn_init_raw_cost is not null);
9728:
9729: cur_ppabpt_rec cur_ppabpt%ROWTYPE;
9730:
9731: I_PROJECT_ID PA_PLSQL_DATATYPES.Num15TabTyp;
9732: I_STRUCTURE_VERSION_ID PA_PLSQL_DATATYPES.Num15TabTyp;
9733: I_TASK_ID PA_PLSQL_DATATYPES.Num15TabTyp;
9734: I_RESOURCE_ASSIGNMENT_ID PA_PLSQL_DATATYPES.Num15TabTyp;
9735: I_ACTUAL_COST PA_PLSQL_DATATYPES.AmtTabTyp;

Line 9732: I_STRUCTURE_VERSION_ID PA_PLSQL_DATATYPES.Num15TabTyp;

9728:
9729: cur_ppabpt_rec cur_ppabpt%ROWTYPE;
9730:
9731: I_PROJECT_ID PA_PLSQL_DATATYPES.Num15TabTyp;
9732: I_STRUCTURE_VERSION_ID PA_PLSQL_DATATYPES.Num15TabTyp;
9733: I_TASK_ID PA_PLSQL_DATATYPES.Num15TabTyp;
9734: I_RESOURCE_ASSIGNMENT_ID PA_PLSQL_DATATYPES.Num15TabTyp;
9735: I_ACTUAL_COST PA_PLSQL_DATATYPES.AmtTabTyp;
9736: I_ACTUAL_EFFORT PA_PLSQL_DATATYPES.QtyTabtyp;

Line 9733: I_TASK_ID PA_PLSQL_DATATYPES.Num15TabTyp;

9729: cur_ppabpt_rec cur_ppabpt%ROWTYPE;
9730:
9731: I_PROJECT_ID PA_PLSQL_DATATYPES.Num15TabTyp;
9732: I_STRUCTURE_VERSION_ID PA_PLSQL_DATATYPES.Num15TabTyp;
9733: I_TASK_ID PA_PLSQL_DATATYPES.Num15TabTyp;
9734: I_RESOURCE_ASSIGNMENT_ID PA_PLSQL_DATATYPES.Num15TabTyp;
9735: I_ACTUAL_COST PA_PLSQL_DATATYPES.AmtTabTyp;
9736: I_ACTUAL_EFFORT PA_PLSQL_DATATYPES.QtyTabtyp;
9737: I_PERIOD_NAME PA_PLSQL_DATATYPES.Char30TabTyp;

Line 9734: I_RESOURCE_ASSIGNMENT_ID PA_PLSQL_DATATYPES.Num15TabTyp;

9730:
9731: I_PROJECT_ID PA_PLSQL_DATATYPES.Num15TabTyp;
9732: I_STRUCTURE_VERSION_ID PA_PLSQL_DATATYPES.Num15TabTyp;
9733: I_TASK_ID PA_PLSQL_DATATYPES.Num15TabTyp;
9734: I_RESOURCE_ASSIGNMENT_ID PA_PLSQL_DATATYPES.Num15TabTyp;
9735: I_ACTUAL_COST PA_PLSQL_DATATYPES.AmtTabTyp;
9736: I_ACTUAL_EFFORT PA_PLSQL_DATATYPES.QtyTabtyp;
9737: I_PERIOD_NAME PA_PLSQL_DATATYPES.Char30TabTyp;
9738: I_TXN_CURRENCY_CODE PA_PLSQL_DATATYPES.Char15TabTyp;

Line 9735: I_ACTUAL_COST PA_PLSQL_DATATYPES.AmtTabTyp;

9731: I_PROJECT_ID PA_PLSQL_DATATYPES.Num15TabTyp;
9732: I_STRUCTURE_VERSION_ID PA_PLSQL_DATATYPES.Num15TabTyp;
9733: I_TASK_ID PA_PLSQL_DATATYPES.Num15TabTyp;
9734: I_RESOURCE_ASSIGNMENT_ID PA_PLSQL_DATATYPES.Num15TabTyp;
9735: I_ACTUAL_COST PA_PLSQL_DATATYPES.AmtTabTyp;
9736: I_ACTUAL_EFFORT PA_PLSQL_DATATYPES.QtyTabtyp;
9737: I_PERIOD_NAME PA_PLSQL_DATATYPES.Char30TabTyp;
9738: I_TXN_CURRENCY_CODE PA_PLSQL_DATATYPES.Char15TabTyp;
9739: I_ACTUAL_COST_PC PA_PLSQL_DATATYPES.AmtTabTyp;

Line 9736: I_ACTUAL_EFFORT PA_PLSQL_DATATYPES.QtyTabtyp;

9732: I_STRUCTURE_VERSION_ID PA_PLSQL_DATATYPES.Num15TabTyp;
9733: I_TASK_ID PA_PLSQL_DATATYPES.Num15TabTyp;
9734: I_RESOURCE_ASSIGNMENT_ID PA_PLSQL_DATATYPES.Num15TabTyp;
9735: I_ACTUAL_COST PA_PLSQL_DATATYPES.AmtTabTyp;
9736: I_ACTUAL_EFFORT PA_PLSQL_DATATYPES.QtyTabtyp;
9737: I_PERIOD_NAME PA_PLSQL_DATATYPES.Char30TabTyp;
9738: I_TXN_CURRENCY_CODE PA_PLSQL_DATATYPES.Char15TabTyp;
9739: I_ACTUAL_COST_PC PA_PLSQL_DATATYPES.AmtTabTyp;
9740: I_ACTUAL_COST_FC PA_PLSQL_DATATYPES.AmtTabTyp;

Line 9737: I_PERIOD_NAME PA_PLSQL_DATATYPES.Char30TabTyp;

9733: I_TASK_ID PA_PLSQL_DATATYPES.Num15TabTyp;
9734: I_RESOURCE_ASSIGNMENT_ID PA_PLSQL_DATATYPES.Num15TabTyp;
9735: I_ACTUAL_COST PA_PLSQL_DATATYPES.AmtTabTyp;
9736: I_ACTUAL_EFFORT PA_PLSQL_DATATYPES.QtyTabtyp;
9737: I_PERIOD_NAME PA_PLSQL_DATATYPES.Char30TabTyp;
9738: I_TXN_CURRENCY_CODE PA_PLSQL_DATATYPES.Char15TabTyp;
9739: I_ACTUAL_COST_PC PA_PLSQL_DATATYPES.AmtTabTyp;
9740: I_ACTUAL_COST_FC PA_PLSQL_DATATYPES.AmtTabTyp;
9741: I_ACTUAL_RAWCOST PA_PLSQL_DATATYPES.AmtTabTyp;

Line 9738: I_TXN_CURRENCY_CODE PA_PLSQL_DATATYPES.Char15TabTyp;

9734: I_RESOURCE_ASSIGNMENT_ID PA_PLSQL_DATATYPES.Num15TabTyp;
9735: I_ACTUAL_COST PA_PLSQL_DATATYPES.AmtTabTyp;
9736: I_ACTUAL_EFFORT PA_PLSQL_DATATYPES.QtyTabtyp;
9737: I_PERIOD_NAME PA_PLSQL_DATATYPES.Char30TabTyp;
9738: I_TXN_CURRENCY_CODE PA_PLSQL_DATATYPES.Char15TabTyp;
9739: I_ACTUAL_COST_PC PA_PLSQL_DATATYPES.AmtTabTyp;
9740: I_ACTUAL_COST_FC PA_PLSQL_DATATYPES.AmtTabTyp;
9741: I_ACTUAL_RAWCOST PA_PLSQL_DATATYPES.AmtTabTyp;
9742: I_ACTUAL_RAWCOST_PC PA_PLSQL_DATATYPES.AmtTabTyp;

Line 9739: I_ACTUAL_COST_PC PA_PLSQL_DATATYPES.AmtTabTyp;

9735: I_ACTUAL_COST PA_PLSQL_DATATYPES.AmtTabTyp;
9736: I_ACTUAL_EFFORT PA_PLSQL_DATATYPES.QtyTabtyp;
9737: I_PERIOD_NAME PA_PLSQL_DATATYPES.Char30TabTyp;
9738: I_TXN_CURRENCY_CODE PA_PLSQL_DATATYPES.Char15TabTyp;
9739: I_ACTUAL_COST_PC PA_PLSQL_DATATYPES.AmtTabTyp;
9740: I_ACTUAL_COST_FC PA_PLSQL_DATATYPES.AmtTabTyp;
9741: I_ACTUAL_RAWCOST PA_PLSQL_DATATYPES.AmtTabTyp;
9742: I_ACTUAL_RAWCOST_PC PA_PLSQL_DATATYPES.AmtTabTyp;
9743: I_ACTUAL_RAWCOST_FC PA_PLSQL_DATATYPES.AmtTabTyp;

Line 9740: I_ACTUAL_COST_FC PA_PLSQL_DATATYPES.AmtTabTyp;

9736: I_ACTUAL_EFFORT PA_PLSQL_DATATYPES.QtyTabtyp;
9737: I_PERIOD_NAME PA_PLSQL_DATATYPES.Char30TabTyp;
9738: I_TXN_CURRENCY_CODE PA_PLSQL_DATATYPES.Char15TabTyp;
9739: I_ACTUAL_COST_PC PA_PLSQL_DATATYPES.AmtTabTyp;
9740: I_ACTUAL_COST_FC PA_PLSQL_DATATYPES.AmtTabTyp;
9741: I_ACTUAL_RAWCOST PA_PLSQL_DATATYPES.AmtTabTyp;
9742: I_ACTUAL_RAWCOST_PC PA_PLSQL_DATATYPES.AmtTabTyp;
9743: I_ACTUAL_RAWCOST_FC PA_PLSQL_DATATYPES.AmtTabTyp;
9744: I_RESOURCE_LIST_MEMBER_ID PA_PLSQL_DATATYPES.Num15TabTyp;

Line 9741: I_ACTUAL_RAWCOST PA_PLSQL_DATATYPES.AmtTabTyp;

9737: I_PERIOD_NAME PA_PLSQL_DATATYPES.Char30TabTyp;
9738: I_TXN_CURRENCY_CODE PA_PLSQL_DATATYPES.Char15TabTyp;
9739: I_ACTUAL_COST_PC PA_PLSQL_DATATYPES.AmtTabTyp;
9740: I_ACTUAL_COST_FC PA_PLSQL_DATATYPES.AmtTabTyp;
9741: I_ACTUAL_RAWCOST PA_PLSQL_DATATYPES.AmtTabTyp;
9742: I_ACTUAL_RAWCOST_PC PA_PLSQL_DATATYPES.AmtTabTyp;
9743: I_ACTUAL_RAWCOST_FC PA_PLSQL_DATATYPES.AmtTabTyp;
9744: I_RESOURCE_LIST_MEMBER_ID PA_PLSQL_DATATYPES.Num15TabTyp;
9745: I_START_DATE PA_PLSQL_DATATYPES.DateTabTyp;

Line 9742: I_ACTUAL_RAWCOST_PC PA_PLSQL_DATATYPES.AmtTabTyp;

9738: I_TXN_CURRENCY_CODE PA_PLSQL_DATATYPES.Char15TabTyp;
9739: I_ACTUAL_COST_PC PA_PLSQL_DATATYPES.AmtTabTyp;
9740: I_ACTUAL_COST_FC PA_PLSQL_DATATYPES.AmtTabTyp;
9741: I_ACTUAL_RAWCOST PA_PLSQL_DATATYPES.AmtTabTyp;
9742: I_ACTUAL_RAWCOST_PC PA_PLSQL_DATATYPES.AmtTabTyp;
9743: I_ACTUAL_RAWCOST_FC PA_PLSQL_DATATYPES.AmtTabTyp;
9744: I_RESOURCE_LIST_MEMBER_ID PA_PLSQL_DATATYPES.Num15TabTyp;
9745: I_START_DATE PA_PLSQL_DATATYPES.DateTabTyp;
9746: I_END_DATE PA_PLSQL_DATATYPES.DateTabTyp;

Line 9743: I_ACTUAL_RAWCOST_FC PA_PLSQL_DATATYPES.AmtTabTyp;

9739: I_ACTUAL_COST_PC PA_PLSQL_DATATYPES.AmtTabTyp;
9740: I_ACTUAL_COST_FC PA_PLSQL_DATATYPES.AmtTabTyp;
9741: I_ACTUAL_RAWCOST PA_PLSQL_DATATYPES.AmtTabTyp;
9742: I_ACTUAL_RAWCOST_PC PA_PLSQL_DATATYPES.AmtTabTyp;
9743: I_ACTUAL_RAWCOST_FC PA_PLSQL_DATATYPES.AmtTabTyp;
9744: I_RESOURCE_LIST_MEMBER_ID PA_PLSQL_DATATYPES.Num15TabTyp;
9745: I_START_DATE PA_PLSQL_DATATYPES.DateTabTyp;
9746: I_END_DATE PA_PLSQL_DATATYPES.DateTabTyp;
9747:

Line 9744: I_RESOURCE_LIST_MEMBER_ID PA_PLSQL_DATATYPES.Num15TabTyp;

9740: I_ACTUAL_COST_FC PA_PLSQL_DATATYPES.AmtTabTyp;
9741: I_ACTUAL_RAWCOST PA_PLSQL_DATATYPES.AmtTabTyp;
9742: I_ACTUAL_RAWCOST_PC PA_PLSQL_DATATYPES.AmtTabTyp;
9743: I_ACTUAL_RAWCOST_FC PA_PLSQL_DATATYPES.AmtTabTyp;
9744: I_RESOURCE_LIST_MEMBER_ID PA_PLSQL_DATATYPES.Num15TabTyp;
9745: I_START_DATE PA_PLSQL_DATATYPES.DateTabTyp;
9746: I_END_DATE PA_PLSQL_DATATYPES.DateTabTyp;
9747:
9748: l_index NUMBER := null;

Line 9745: I_START_DATE PA_PLSQL_DATATYPES.DateTabTyp;

9741: I_ACTUAL_RAWCOST PA_PLSQL_DATATYPES.AmtTabTyp;
9742: I_ACTUAL_RAWCOST_PC PA_PLSQL_DATATYPES.AmtTabTyp;
9743: I_ACTUAL_RAWCOST_FC PA_PLSQL_DATATYPES.AmtTabTyp;
9744: I_RESOURCE_LIST_MEMBER_ID PA_PLSQL_DATATYPES.Num15TabTyp;
9745: I_START_DATE PA_PLSQL_DATATYPES.DateTabTyp;
9746: I_END_DATE PA_PLSQL_DATATYPES.DateTabTyp;
9747:
9748: l_index NUMBER := null;
9749: i NUMBER := null;

Line 9746: I_END_DATE PA_PLSQL_DATATYPES.DateTabTyp;

9742: I_ACTUAL_RAWCOST_PC PA_PLSQL_DATATYPES.AmtTabTyp;
9743: I_ACTUAL_RAWCOST_FC PA_PLSQL_DATATYPES.AmtTabTyp;
9744: I_RESOURCE_LIST_MEMBER_ID PA_PLSQL_DATATYPES.Num15TabTyp;
9745: I_START_DATE PA_PLSQL_DATATYPES.DateTabTyp;
9746: I_END_DATE PA_PLSQL_DATATYPES.DateTabTyp;
9747:
9748: l_index NUMBER := null;
9749: i NUMBER := null;
9750: