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 6002: l_assignment_id_tbl PA_PLSQL_DATATYPES.NumTabTyp;

5998: SELECT resource_id, start_date, end_date
5999: FROM pa_project_assignments
6000: WHERE assignment_id = p_assignment_id;
6001:
6002: l_assignment_id_tbl PA_PLSQL_DATATYPES.NumTabTyp;
6003: l_resource_id NUMBER;
6004: l_start_date DATE;
6005: l_end_date DATE;
6006: l_self_conflict_flag VARCHAR2(1) := 'N';

Line 6194: l_assignment_id_tbl PA_PLSQL_DATATYPES.NumTabTyp;

6190:
6191: G_AVAILABILITY_CAL_PERIOD VARCHAR2(15) := FND_PROFILE.VALUE('PA_AVAILABILITY_CAL_PERIOD');
6192: G_OVERCOMMITMENT_PERCENTAGE NUMBER := FND_NUMBER.CANONICAL_TO_NUMBER(FND_PROFILE.VALUE('PA_OVERCOMMITMENT_PERCENTAGE'))/100;
6193:
6194: l_assignment_id_tbl PA_PLSQL_DATATYPES.NumTabTyp;
6195: l_conflict_group_id NUMBER := p_conflict_group_id;
6196: -- added for bug fix: 4537865
6197: l_new_conflict_group_id NUMBER;
6198: -- added for bug fix: 4537865

Line 6654: l_assignment_id_tbl PA_PLSQL_DATATYPES.IdTabTyp;

6650: l_cur_assignment_id NUMBER;
6651: l_cur_item_date DATE;
6652: l_cur_week_end_date DATE;
6653: l_cur_overcom_quantity NUMBER;
6654: l_assignment_id_tbl PA_PLSQL_DATATYPES.IdTabTyp;
6655: l_item_date_tbl PA_PLSQL_DATATYPES.DateTabTyp;
6656: l_week_end_date_tbl PA_PLSQL_DATATYPES.DateTabTyp;
6657: l_item_quantity_tbl PA_PLSQL_DATATYPES.NumTabTyp;
6658: l_overcom_quantity_tbl PA_PLSQL_DATATYPES.NumTabTyp;

Line 6655: l_item_date_tbl PA_PLSQL_DATATYPES.DateTabTyp;

6651: l_cur_item_date DATE;
6652: l_cur_week_end_date DATE;
6653: l_cur_overcom_quantity NUMBER;
6654: l_assignment_id_tbl PA_PLSQL_DATATYPES.IdTabTyp;
6655: l_item_date_tbl PA_PLSQL_DATATYPES.DateTabTyp;
6656: l_week_end_date_tbl PA_PLSQL_DATATYPES.DateTabTyp;
6657: l_item_quantity_tbl PA_PLSQL_DATATYPES.NumTabTyp;
6658: l_overcom_quantity_tbl PA_PLSQL_DATATYPES.NumTabTyp;
6659: l_work_pattern_tbl WorkPatternTabTyp;

Line 6656: l_week_end_date_tbl PA_PLSQL_DATATYPES.DateTabTyp;

6652: l_cur_week_end_date DATE;
6653: l_cur_overcom_quantity NUMBER;
6654: l_assignment_id_tbl PA_PLSQL_DATATYPES.IdTabTyp;
6655: l_item_date_tbl PA_PLSQL_DATATYPES.DateTabTyp;
6656: l_week_end_date_tbl PA_PLSQL_DATATYPES.DateTabTyp;
6657: l_item_quantity_tbl PA_PLSQL_DATATYPES.NumTabTyp;
6658: l_overcom_quantity_tbl PA_PLSQL_DATATYPES.NumTabTyp;
6659: l_work_pattern_tbl WorkPatternTabTyp;
6660: l_cur_work_pattern_tbl WorkPatternTabTyp;

Line 6657: l_item_quantity_tbl PA_PLSQL_DATATYPES.NumTabTyp;

6653: l_cur_overcom_quantity NUMBER;
6654: l_assignment_id_tbl PA_PLSQL_DATATYPES.IdTabTyp;
6655: l_item_date_tbl PA_PLSQL_DATATYPES.DateTabTyp;
6656: l_week_end_date_tbl PA_PLSQL_DATATYPES.DateTabTyp;
6657: l_item_quantity_tbl PA_PLSQL_DATATYPES.NumTabTyp;
6658: l_overcom_quantity_tbl PA_PLSQL_DATATYPES.NumTabTyp;
6659: l_work_pattern_tbl WorkPatternTabTyp;
6660: l_cur_work_pattern_tbl WorkPatternTabTyp;
6661:

Line 6658: l_overcom_quantity_tbl PA_PLSQL_DATATYPES.NumTabTyp;

6654: l_assignment_id_tbl PA_PLSQL_DATATYPES.IdTabTyp;
6655: l_item_date_tbl PA_PLSQL_DATATYPES.DateTabTyp;
6656: l_week_end_date_tbl PA_PLSQL_DATATYPES.DateTabTyp;
6657: l_item_quantity_tbl PA_PLSQL_DATATYPES.NumTabTyp;
6658: l_overcom_quantity_tbl PA_PLSQL_DATATYPES.NumTabTyp;
6659: l_work_pattern_tbl WorkPatternTabTyp;
6660: l_cur_work_pattern_tbl WorkPatternTabTyp;
6661:
6662: l_msg_index_out NUMBER;