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_PUB dependencies on PA_DATE_TBL_TYPE

Line 65: TYPE PA_DATE_TBL_TBL_TYPE IS TABLE OF SYSTEM.PA_DATE_TBL_TYPE INDEX BY BINARY_INTEGER;

61: TYPE WORK_PATTERN_TAB_TYPE IS TABLE OF WORK_PATTERN_REC_TYPE
62: INDEX BY BINARY_INTEGER;
63:
64: /* 7693634 start */
65: TYPE PA_DATE_TBL_TBL_TYPE IS TABLE OF SYSTEM.PA_DATE_TBL_TYPE INDEX BY BINARY_INTEGER;
66: TYPE PA_NUM_TBL_TBL_TYPE IS TABLE OF SYSTEM.PA_NUM_TBL_TYPE INDEX BY BINARY_INTEGER;
67: /* 7693634 end */
68:
69: G_update_schedule_bulk_call varchar2(1) := 'N'; -- Bug 8233045

Line 176: ,p_change_start_date_tbl IN SYSTEM.PA_DATE_TBL_TYPE := NULL

172: ,p_duration_shift_type_code IN VARCHAR2 := NULL
173: ,p_duration_shift_unit_code IN VARCHAR2 := NULL
174: ,p_number_of_shift IN NUMBER := NULL
175: ,p_last_row_flag IN VARCHAR2 := 'Y'
176: ,p_change_start_date_tbl IN SYSTEM.PA_DATE_TBL_TYPE := NULL
177: ,p_change_end_date_tbl IN SYSTEM.PA_DATE_TBL_TYPE := NULL
178: ,p_monday_hours_tbl IN SYSTEM.PA_NUM_TBL_TYPE := NULL
179: ,p_tuesday_hours_tbl IN SYSTEM.PA_NUM_TBL_TYPE := NULL
180: ,p_wednesday_hours_tbl IN SYSTEM.PA_NUM_TBL_TYPE := NULL

Line 177: ,p_change_end_date_tbl IN SYSTEM.PA_DATE_TBL_TYPE := NULL

173: ,p_duration_shift_unit_code IN VARCHAR2 := NULL
174: ,p_number_of_shift IN NUMBER := NULL
175: ,p_last_row_flag IN VARCHAR2 := 'Y'
176: ,p_change_start_date_tbl IN SYSTEM.PA_DATE_TBL_TYPE := NULL
177: ,p_change_end_date_tbl IN SYSTEM.PA_DATE_TBL_TYPE := NULL
178: ,p_monday_hours_tbl IN SYSTEM.PA_NUM_TBL_TYPE := NULL
179: ,p_tuesday_hours_tbl IN SYSTEM.PA_NUM_TBL_TYPE := NULL
180: ,p_wednesday_hours_tbl IN SYSTEM.PA_NUM_TBL_TYPE := NULL
181: ,p_thursday_hours_tbl IN SYSTEM.PA_NUM_TBL_TYPE := NULL

Line 203: ,p_change_start_date_tbl IN SYSTEM.PA_DATE_TBL_TYPE := NULL

199: ,p_exception_type_code_tbl IN SYSTEM.PA_VARCHAR2_2000_TBL_TYPE
200: ,p_record_version_number_tbl IN SYSTEM.PA_NUM_TBL_TYPE := NULL
201: ,p_assignment_id_tbl IN SYSTEM.PA_NUM_TBL_TYPE := NULL
202: -- ,p_assignment_id_array_tbl IN PA_NUM_TBL_TBL_TYPE --:= NULL
203: ,p_change_start_date_tbl IN SYSTEM.PA_DATE_TBL_TYPE := NULL
204: ,p_change_end_date_tbl IN SYSTEM.PA_DATE_TBL_TYPE := NULL
205: ,p_requirement_status_code_tbl IN SYSTEM.PA_VARCHAR2_2000_TBL_TYPE := NULL
206: ,p_assignment_status_code_tbl IN SYSTEM.PA_VARCHAR2_2000_TBL_TYPE := NULL
207: ,p_last_row_flag_tbl IN SYSTEM.PA_VARCHAR2_2000_TBL_TYPE -- := 'Y'

Line 204: ,p_change_end_date_tbl IN SYSTEM.PA_DATE_TBL_TYPE := NULL

200: ,p_record_version_number_tbl IN SYSTEM.PA_NUM_TBL_TYPE := NULL
201: ,p_assignment_id_tbl IN SYSTEM.PA_NUM_TBL_TYPE := NULL
202: -- ,p_assignment_id_array_tbl IN PA_NUM_TBL_TBL_TYPE --:= NULL
203: ,p_change_start_date_tbl IN SYSTEM.PA_DATE_TBL_TYPE := NULL
204: ,p_change_end_date_tbl IN SYSTEM.PA_DATE_TBL_TYPE := NULL
205: ,p_requirement_status_code_tbl IN SYSTEM.PA_VARCHAR2_2000_TBL_TYPE := NULL
206: ,p_assignment_status_code_tbl IN SYSTEM.PA_VARCHAR2_2000_TBL_TYPE := NULL
207: ,p_last_row_flag_tbl IN SYSTEM.PA_VARCHAR2_2000_TBL_TYPE -- := 'Y'
208: ,p_commit_tbl IN SYSTEM.PA_VARCHAR2_2000_TBL_TYPE -- := FND_API.G_FALSE

Line 225: ,p_change_start_date_tbl IN SYSTEM.PA_DATE_TBL_TYPE := NULL

221: ,p_exception_type_code_tbl IN SYSTEM.PA_VARCHAR2_2000_TBL_TYPE
222: ,p_record_version_number_tbl IN SYSTEM.PA_NUM_TBL_TYPE := NULL
223: ,p_assignment_id_tbl IN SYSTEM.PA_NUM_TBL_TYPE := NULL
224: -- ,p_assignment_id_array_tbl IN PA_NUM_TBL_TBL_TYPE --:= NULL
225: ,p_change_start_date_tbl IN SYSTEM.PA_DATE_TBL_TYPE := NULL
226: ,p_change_end_date_tbl IN SYSTEM.PA_DATE_TBL_TYPE := NULL
227: ,p_requirement_status_code_tbl IN SYSTEM.PA_VARCHAR2_2000_TBL_TYPE := NULL
228: ,p_assignment_status_code_tbl IN SYSTEM.PA_VARCHAR2_2000_TBL_TYPE := NULL
229: ,p_last_row_flag_tbl IN SYSTEM.PA_VARCHAR2_2000_TBL_TYPE -- := 'Y'

Line 226: ,p_change_end_date_tbl IN SYSTEM.PA_DATE_TBL_TYPE := NULL

222: ,p_record_version_number_tbl IN SYSTEM.PA_NUM_TBL_TYPE := NULL
223: ,p_assignment_id_tbl IN SYSTEM.PA_NUM_TBL_TYPE := NULL
224: -- ,p_assignment_id_array_tbl IN PA_NUM_TBL_TBL_TYPE --:= NULL
225: ,p_change_start_date_tbl IN SYSTEM.PA_DATE_TBL_TYPE := NULL
226: ,p_change_end_date_tbl IN SYSTEM.PA_DATE_TBL_TYPE := NULL
227: ,p_requirement_status_code_tbl IN SYSTEM.PA_VARCHAR2_2000_TBL_TYPE := NULL
228: ,p_assignment_status_code_tbl IN SYSTEM.PA_VARCHAR2_2000_TBL_TYPE := NULL
229: ,p_last_row_flag_tbl IN SYSTEM.PA_VARCHAR2_2000_TBL_TYPE -- := 'Y'
230: ,p_commit_tbl IN SYSTEM.PA_VARCHAR2_2000_TBL_TYPE -- := FND_API.G_FALSE

Line 295: ,p_change_start_date_tbl IN SYSTEM.PA_DATE_TBL_TYPE := NULL

291: ,p_change_start_date IN DATE := NULL
292: ,p_change_end_date IN DATE := NULL
293: ,p_change_rqmt_status_code IN VARCHAR2 := NULL
294: ,p_change_asgmt_status_code IN VARCHAR2 := NULL
295: ,p_change_start_date_tbl IN SYSTEM.PA_DATE_TBL_TYPE := NULL
296: ,p_change_end_date_tbl IN SYSTEM.PA_DATE_TBL_TYPE := NULL
297: ,p_monday_hours_tbl IN SYSTEM.PA_NUM_TBL_TYPE := NULL
298: ,p_tuesday_hours_tbl IN SYSTEM.PA_NUM_TBL_TYPE := NULL
299: ,p_wednesday_hours_tbl IN SYSTEM.PA_NUM_TBL_TYPE := NULL

Line 296: ,p_change_end_date_tbl IN SYSTEM.PA_DATE_TBL_TYPE := NULL

292: ,p_change_end_date IN DATE := NULL
293: ,p_change_rqmt_status_code IN VARCHAR2 := NULL
294: ,p_change_asgmt_status_code IN VARCHAR2 := NULL
295: ,p_change_start_date_tbl IN SYSTEM.PA_DATE_TBL_TYPE := NULL
296: ,p_change_end_date_tbl IN SYSTEM.PA_DATE_TBL_TYPE := NULL
297: ,p_monday_hours_tbl IN SYSTEM.PA_NUM_TBL_TYPE := NULL
298: ,p_tuesday_hours_tbl IN SYSTEM.PA_NUM_TBL_TYPE := NULL
299: ,p_wednesday_hours_tbl IN SYSTEM.PA_NUM_TBL_TYPE := NULL
300: ,p_thursday_hours_tbl IN SYSTEM.PA_NUM_TBL_TYPE := NULL