eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PA_SCHEDULE_PVT dependencies on PA_PLSQL_DATATYPES

Line 5714: l_assignment_id_tbl PA_PLSQL_DATATYPES.NumTabTyp;

5710: SELECT resource_id, start_date, end_date
5711: FROM pa_project_assignments
5712: WHERE assignment_id = p_assignment_id;
5713:
5714: l_assignment_id_tbl PA_PLSQL_DATATYPES.NumTabTyp;
5715: l_resource_id NUMBER;
5716: l_start_date DATE;
5717: l_end_date DATE;
5718: l_self_conflict_flag VARCHAR2(1) := 'N';

Line 5901: l_assignment_id_tbl PA_PLSQL_DATATYPES.NumTabTyp;

5897:
5898: G_AVAILABILITY_CAL_PERIOD VARCHAR2(15) := FND_PROFILE.VALUE('PA_AVAILABILITY_CAL_PERIOD');
5899: G_OVERCOMMITMENT_PERCENTAGE NUMBER := FND_NUMBER.CANONICAL_TO_NUMBER(FND_PROFILE.VALUE('PA_OVERCOMMITMENT_PERCENTAGE'))/100;
5900:
5901: l_assignment_id_tbl PA_PLSQL_DATATYPES.NumTabTyp;
5902: l_conflict_group_id NUMBER := p_conflict_group_id;
5903: -- added for bug fix: 4537865
5904: l_new_conflict_group_id NUMBER;
5905: -- added for bug fix: 4537865

Line 6361: l_assignment_id_tbl PA_PLSQL_DATATYPES.IdTabTyp;

6357: l_cur_assignment_id NUMBER;
6358: l_cur_item_date DATE;
6359: l_cur_week_end_date DATE;
6360: l_cur_overcom_quantity NUMBER;
6361: l_assignment_id_tbl PA_PLSQL_DATATYPES.IdTabTyp;
6362: l_item_date_tbl PA_PLSQL_DATATYPES.DateTabTyp;
6363: l_week_end_date_tbl PA_PLSQL_DATATYPES.DateTabTyp;
6364: l_item_quantity_tbl PA_PLSQL_DATATYPES.NumTabTyp;
6365: l_overcom_quantity_tbl PA_PLSQL_DATATYPES.NumTabTyp;

Line 6362: l_item_date_tbl PA_PLSQL_DATATYPES.DateTabTyp;

6358: l_cur_item_date DATE;
6359: l_cur_week_end_date DATE;
6360: l_cur_overcom_quantity NUMBER;
6361: l_assignment_id_tbl PA_PLSQL_DATATYPES.IdTabTyp;
6362: l_item_date_tbl PA_PLSQL_DATATYPES.DateTabTyp;
6363: l_week_end_date_tbl PA_PLSQL_DATATYPES.DateTabTyp;
6364: l_item_quantity_tbl PA_PLSQL_DATATYPES.NumTabTyp;
6365: l_overcom_quantity_tbl PA_PLSQL_DATATYPES.NumTabTyp;
6366: l_work_pattern_tbl WorkPatternTabTyp;

Line 6363: l_week_end_date_tbl PA_PLSQL_DATATYPES.DateTabTyp;

6359: l_cur_week_end_date DATE;
6360: l_cur_overcom_quantity NUMBER;
6361: l_assignment_id_tbl PA_PLSQL_DATATYPES.IdTabTyp;
6362: l_item_date_tbl PA_PLSQL_DATATYPES.DateTabTyp;
6363: l_week_end_date_tbl PA_PLSQL_DATATYPES.DateTabTyp;
6364: l_item_quantity_tbl PA_PLSQL_DATATYPES.NumTabTyp;
6365: l_overcom_quantity_tbl PA_PLSQL_DATATYPES.NumTabTyp;
6366: l_work_pattern_tbl WorkPatternTabTyp;
6367: l_cur_work_pattern_tbl WorkPatternTabTyp;

Line 6364: l_item_quantity_tbl PA_PLSQL_DATATYPES.NumTabTyp;

6360: l_cur_overcom_quantity NUMBER;
6361: l_assignment_id_tbl PA_PLSQL_DATATYPES.IdTabTyp;
6362: l_item_date_tbl PA_PLSQL_DATATYPES.DateTabTyp;
6363: l_week_end_date_tbl PA_PLSQL_DATATYPES.DateTabTyp;
6364: l_item_quantity_tbl PA_PLSQL_DATATYPES.NumTabTyp;
6365: l_overcom_quantity_tbl PA_PLSQL_DATATYPES.NumTabTyp;
6366: l_work_pattern_tbl WorkPatternTabTyp;
6367: l_cur_work_pattern_tbl WorkPatternTabTyp;
6368:

Line 6365: l_overcom_quantity_tbl PA_PLSQL_DATATYPES.NumTabTyp;

6361: l_assignment_id_tbl PA_PLSQL_DATATYPES.IdTabTyp;
6362: l_item_date_tbl PA_PLSQL_DATATYPES.DateTabTyp;
6363: l_week_end_date_tbl PA_PLSQL_DATATYPES.DateTabTyp;
6364: l_item_quantity_tbl PA_PLSQL_DATATYPES.NumTabTyp;
6365: l_overcom_quantity_tbl PA_PLSQL_DATATYPES.NumTabTyp;
6366: l_work_pattern_tbl WorkPatternTabTyp;
6367: l_cur_work_pattern_tbl WorkPatternTabTyp;
6368:
6369: l_msg_index_out NUMBER;