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_NUM_TBL_TYPE

Line 100: p_hours_table IN SYSTEM.PA_NUM_TBL_TYPE ,

96: p_asgn_end_date IN DATE := NULL ,
97: p_start_date IN DATE := NULL ,
98: -- p_end_date IN DATE := NULL ,
99: p_assignment_status_code IN VARCHAR2 := NULL ,
100: p_hours_table IN SYSTEM.PA_NUM_TBL_TYPE ,
101: p_prev_call_timeline_st_date IN DATE ,
102: p_prev_call_timeline_end_date IN DATE ,
103: x_call_timeline_st_date OUT NOCOPY DATE , --File.Sql.39 bug 4440895
104: x_call_timeline_end_date OUT NOCOPY DATE , --File.Sql.39 bug 4440895

Line 123: p_resource_id_tbl IN SYSTEM.PA_NUM_TBL_TYPE ,

119: -- Parameters :
120: --
121:
122: PROCEDURE populate_work_pattern_table(
123: p_resource_id_tbl IN SYSTEM.PA_NUM_TBL_TYPE ,
124: p_assgn_range_start_date IN DATE := NULL ,
125: p_assgn_range_end_date IN DATE := NULL ,
126: p_display_start_date IN DATE ,
127: p_status_code IN VARCHAR2 := NULL ,

Line 146: ,p_assignment_id_array IN SYSTEM.PA_NUM_TBL_TYPE := NULL

142: ,p_mass_update_flag IN VARCHAR2 := FND_API.G_FALSE
143: ,p_exception_type_code IN VARCHAR2
144: ,p_record_version_number IN NUMBER := NULL
145: ,p_assignment_id IN NUMBER := NULL
146: ,p_assignment_id_array IN SYSTEM.PA_NUM_TBL_TYPE := NULL
147: ,p_change_start_date IN DATE := NULL
148: ,p_change_end_date IN DATE := NULL
149: ,p_requirement_status_code IN VARCHAR2 := NULL
150: ,p_assignment_status_code IN VARCHAR2 := NULL

Line 171: ,p_monday_hours_tbl IN SYSTEM.PA_NUM_TBL_TYPE := NULL

167: ,p_number_of_shift IN NUMBER := NULL
168: ,p_last_row_flag IN VARCHAR2 := 'Y'
169: ,p_change_start_date_tbl IN SYSTEM.PA_DATE_TBL_TYPE := NULL
170: ,p_change_end_date_tbl IN SYSTEM.PA_DATE_TBL_TYPE := NULL
171: ,p_monday_hours_tbl IN SYSTEM.PA_NUM_TBL_TYPE := NULL
172: ,p_tuesday_hours_tbl IN SYSTEM.PA_NUM_TBL_TYPE := NULL
173: ,p_wednesday_hours_tbl IN SYSTEM.PA_NUM_TBL_TYPE := NULL
174: ,p_thursday_hours_tbl IN SYSTEM.PA_NUM_TBL_TYPE := NULL
175: ,p_friday_hours_tbl IN SYSTEM.PA_NUM_TBL_TYPE := NULL

Line 172: ,p_tuesday_hours_tbl IN SYSTEM.PA_NUM_TBL_TYPE := NULL

168: ,p_last_row_flag IN VARCHAR2 := 'Y'
169: ,p_change_start_date_tbl IN SYSTEM.PA_DATE_TBL_TYPE := NULL
170: ,p_change_end_date_tbl IN SYSTEM.PA_DATE_TBL_TYPE := NULL
171: ,p_monday_hours_tbl IN SYSTEM.PA_NUM_TBL_TYPE := NULL
172: ,p_tuesday_hours_tbl IN SYSTEM.PA_NUM_TBL_TYPE := NULL
173: ,p_wednesday_hours_tbl IN SYSTEM.PA_NUM_TBL_TYPE := NULL
174: ,p_thursday_hours_tbl IN SYSTEM.PA_NUM_TBL_TYPE := NULL
175: ,p_friday_hours_tbl IN SYSTEM.PA_NUM_TBL_TYPE := NULL
176: ,p_saturday_hours_tbl IN SYSTEM.PA_NUM_TBL_TYPE := NULL

Line 173: ,p_wednesday_hours_tbl IN SYSTEM.PA_NUM_TBL_TYPE := NULL

169: ,p_change_start_date_tbl IN SYSTEM.PA_DATE_TBL_TYPE := NULL
170: ,p_change_end_date_tbl IN SYSTEM.PA_DATE_TBL_TYPE := NULL
171: ,p_monday_hours_tbl IN SYSTEM.PA_NUM_TBL_TYPE := NULL
172: ,p_tuesday_hours_tbl IN SYSTEM.PA_NUM_TBL_TYPE := NULL
173: ,p_wednesday_hours_tbl IN SYSTEM.PA_NUM_TBL_TYPE := NULL
174: ,p_thursday_hours_tbl IN SYSTEM.PA_NUM_TBL_TYPE := NULL
175: ,p_friday_hours_tbl IN SYSTEM.PA_NUM_TBL_TYPE := NULL
176: ,p_saturday_hours_tbl IN SYSTEM.PA_NUM_TBL_TYPE := NULL
177: ,p_sunday_hours_tbl IN SYSTEM.PA_NUM_TBL_TYPE := NULL

Line 174: ,p_thursday_hours_tbl IN SYSTEM.PA_NUM_TBL_TYPE := NULL

170: ,p_change_end_date_tbl IN SYSTEM.PA_DATE_TBL_TYPE := NULL
171: ,p_monday_hours_tbl IN SYSTEM.PA_NUM_TBL_TYPE := NULL
172: ,p_tuesday_hours_tbl IN SYSTEM.PA_NUM_TBL_TYPE := NULL
173: ,p_wednesday_hours_tbl IN SYSTEM.PA_NUM_TBL_TYPE := NULL
174: ,p_thursday_hours_tbl IN SYSTEM.PA_NUM_TBL_TYPE := NULL
175: ,p_friday_hours_tbl IN SYSTEM.PA_NUM_TBL_TYPE := NULL
176: ,p_saturday_hours_tbl IN SYSTEM.PA_NUM_TBL_TYPE := NULL
177: ,p_sunday_hours_tbl IN SYSTEM.PA_NUM_TBL_TYPE := NULL
178: ,p_commit IN VARCHAR2 := FND_API.G_FALSE

Line 175: ,p_friday_hours_tbl IN SYSTEM.PA_NUM_TBL_TYPE := NULL

171: ,p_monday_hours_tbl IN SYSTEM.PA_NUM_TBL_TYPE := NULL
172: ,p_tuesday_hours_tbl IN SYSTEM.PA_NUM_TBL_TYPE := NULL
173: ,p_wednesday_hours_tbl IN SYSTEM.PA_NUM_TBL_TYPE := NULL
174: ,p_thursday_hours_tbl IN SYSTEM.PA_NUM_TBL_TYPE := NULL
175: ,p_friday_hours_tbl IN SYSTEM.PA_NUM_TBL_TYPE := NULL
176: ,p_saturday_hours_tbl IN SYSTEM.PA_NUM_TBL_TYPE := NULL
177: ,p_sunday_hours_tbl IN SYSTEM.PA_NUM_TBL_TYPE := NULL
178: ,p_commit IN VARCHAR2 := FND_API.G_FALSE
179: ,p_validate_only IN VARCHAR2 := FND_API.G_TRUE

Line 176: ,p_saturday_hours_tbl IN SYSTEM.PA_NUM_TBL_TYPE := NULL

172: ,p_tuesday_hours_tbl IN SYSTEM.PA_NUM_TBL_TYPE := NULL
173: ,p_wednesday_hours_tbl IN SYSTEM.PA_NUM_TBL_TYPE := NULL
174: ,p_thursday_hours_tbl IN SYSTEM.PA_NUM_TBL_TYPE := NULL
175: ,p_friday_hours_tbl IN SYSTEM.PA_NUM_TBL_TYPE := NULL
176: ,p_saturday_hours_tbl IN SYSTEM.PA_NUM_TBL_TYPE := NULL
177: ,p_sunday_hours_tbl IN SYSTEM.PA_NUM_TBL_TYPE := NULL
178: ,p_commit IN VARCHAR2 := FND_API.G_FALSE
179: ,p_validate_only IN VARCHAR2 := FND_API.G_TRUE
180: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895

Line 177: ,p_sunday_hours_tbl IN SYSTEM.PA_NUM_TBL_TYPE := NULL

173: ,p_wednesday_hours_tbl IN SYSTEM.PA_NUM_TBL_TYPE := NULL
174: ,p_thursday_hours_tbl IN SYSTEM.PA_NUM_TBL_TYPE := NULL
175: ,p_friday_hours_tbl IN SYSTEM.PA_NUM_TBL_TYPE := NULL
176: ,p_saturday_hours_tbl IN SYSTEM.PA_NUM_TBL_TYPE := NULL
177: ,p_sunday_hours_tbl IN SYSTEM.PA_NUM_TBL_TYPE := NULL
178: ,p_commit IN VARCHAR2 := FND_API.G_FALSE
179: ,p_validate_only IN VARCHAR2 := FND_API.G_TRUE
180: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
181: ,x_msg_count OUT NOCOPY NUMBER --File.Sql.39 bug 4440895

Line 230: ,p_assignment_id_array IN SYSTEM.PA_NUM_TBL_TYPE

226: --
227: PROCEDURE mass_update_schedule
228: ( p_project_id IN NUMBER
229: ,p_exception_type_code IN VARCHAR2
230: ,p_assignment_id_array IN SYSTEM.PA_NUM_TBL_TYPE
231: ,p_change_start_date IN DATE := NULL
232: ,p_change_end_date IN DATE := NULL
233: ,p_change_rqmt_status_code IN VARCHAR2 := NULL
234: ,p_change_asgmt_status_code IN VARCHAR2 := NULL

Line 237: ,p_monday_hours_tbl IN SYSTEM.PA_NUM_TBL_TYPE := NULL

233: ,p_change_rqmt_status_code IN VARCHAR2 := NULL
234: ,p_change_asgmt_status_code IN VARCHAR2 := NULL
235: ,p_change_start_date_tbl IN SYSTEM.PA_DATE_TBL_TYPE := NULL
236: ,p_change_end_date_tbl IN SYSTEM.PA_DATE_TBL_TYPE := NULL
237: ,p_monday_hours_tbl IN SYSTEM.PA_NUM_TBL_TYPE := NULL
238: ,p_tuesday_hours_tbl IN SYSTEM.PA_NUM_TBL_TYPE := NULL
239: ,p_wednesday_hours_tbl IN SYSTEM.PA_NUM_TBL_TYPE := NULL
240: ,p_thursday_hours_tbl IN SYSTEM.PA_NUM_TBL_TYPE := NULL
241: ,p_friday_hours_tbl IN SYSTEM.PA_NUM_TBL_TYPE := NULL

Line 238: ,p_tuesday_hours_tbl IN SYSTEM.PA_NUM_TBL_TYPE := NULL

234: ,p_change_asgmt_status_code IN VARCHAR2 := NULL
235: ,p_change_start_date_tbl IN SYSTEM.PA_DATE_TBL_TYPE := NULL
236: ,p_change_end_date_tbl IN SYSTEM.PA_DATE_TBL_TYPE := NULL
237: ,p_monday_hours_tbl IN SYSTEM.PA_NUM_TBL_TYPE := NULL
238: ,p_tuesday_hours_tbl IN SYSTEM.PA_NUM_TBL_TYPE := NULL
239: ,p_wednesday_hours_tbl IN SYSTEM.PA_NUM_TBL_TYPE := NULL
240: ,p_thursday_hours_tbl IN SYSTEM.PA_NUM_TBL_TYPE := NULL
241: ,p_friday_hours_tbl IN SYSTEM.PA_NUM_TBL_TYPE := NULL
242: ,p_saturday_hours_tbl IN SYSTEM.PA_NUM_TBL_TYPE := NULL

Line 239: ,p_wednesday_hours_tbl IN SYSTEM.PA_NUM_TBL_TYPE := NULL

235: ,p_change_start_date_tbl IN SYSTEM.PA_DATE_TBL_TYPE := NULL
236: ,p_change_end_date_tbl IN SYSTEM.PA_DATE_TBL_TYPE := NULL
237: ,p_monday_hours_tbl IN SYSTEM.PA_NUM_TBL_TYPE := NULL
238: ,p_tuesday_hours_tbl IN SYSTEM.PA_NUM_TBL_TYPE := NULL
239: ,p_wednesday_hours_tbl IN SYSTEM.PA_NUM_TBL_TYPE := NULL
240: ,p_thursday_hours_tbl IN SYSTEM.PA_NUM_TBL_TYPE := NULL
241: ,p_friday_hours_tbl IN SYSTEM.PA_NUM_TBL_TYPE := NULL
242: ,p_saturday_hours_tbl IN SYSTEM.PA_NUM_TBL_TYPE := NULL
243: ,p_sunday_hours_tbl IN SYSTEM.PA_NUM_TBL_TYPE := NULL

Line 240: ,p_thursday_hours_tbl IN SYSTEM.PA_NUM_TBL_TYPE := NULL

236: ,p_change_end_date_tbl IN SYSTEM.PA_DATE_TBL_TYPE := NULL
237: ,p_monday_hours_tbl IN SYSTEM.PA_NUM_TBL_TYPE := NULL
238: ,p_tuesday_hours_tbl IN SYSTEM.PA_NUM_TBL_TYPE := NULL
239: ,p_wednesday_hours_tbl IN SYSTEM.PA_NUM_TBL_TYPE := NULL
240: ,p_thursday_hours_tbl IN SYSTEM.PA_NUM_TBL_TYPE := NULL
241: ,p_friday_hours_tbl IN SYSTEM.PA_NUM_TBL_TYPE := NULL
242: ,p_saturday_hours_tbl IN SYSTEM.PA_NUM_TBL_TYPE := NULL
243: ,p_sunday_hours_tbl IN SYSTEM.PA_NUM_TBL_TYPE := NULL
244: ,p_non_working_day_flag IN VARCHAR2 := 'N'

Line 241: ,p_friday_hours_tbl IN SYSTEM.PA_NUM_TBL_TYPE := NULL

237: ,p_monday_hours_tbl IN SYSTEM.PA_NUM_TBL_TYPE := NULL
238: ,p_tuesday_hours_tbl IN SYSTEM.PA_NUM_TBL_TYPE := NULL
239: ,p_wednesday_hours_tbl IN SYSTEM.PA_NUM_TBL_TYPE := NULL
240: ,p_thursday_hours_tbl IN SYSTEM.PA_NUM_TBL_TYPE := NULL
241: ,p_friday_hours_tbl IN SYSTEM.PA_NUM_TBL_TYPE := NULL
242: ,p_saturday_hours_tbl IN SYSTEM.PA_NUM_TBL_TYPE := NULL
243: ,p_sunday_hours_tbl IN SYSTEM.PA_NUM_TBL_TYPE := NULL
244: ,p_non_working_day_flag IN VARCHAR2 := 'N'
245: ,p_change_hours_type_code IN VARCHAR2 := NULL

Line 242: ,p_saturday_hours_tbl IN SYSTEM.PA_NUM_TBL_TYPE := NULL

238: ,p_tuesday_hours_tbl IN SYSTEM.PA_NUM_TBL_TYPE := NULL
239: ,p_wednesday_hours_tbl IN SYSTEM.PA_NUM_TBL_TYPE := NULL
240: ,p_thursday_hours_tbl IN SYSTEM.PA_NUM_TBL_TYPE := NULL
241: ,p_friday_hours_tbl IN SYSTEM.PA_NUM_TBL_TYPE := NULL
242: ,p_saturday_hours_tbl IN SYSTEM.PA_NUM_TBL_TYPE := NULL
243: ,p_sunday_hours_tbl IN SYSTEM.PA_NUM_TBL_TYPE := NULL
244: ,p_non_working_day_flag IN VARCHAR2 := 'N'
245: ,p_change_hours_type_code IN VARCHAR2 := NULL
246: ,p_hrs_per_day IN NUMBER := NULL

Line 243: ,p_sunday_hours_tbl IN SYSTEM.PA_NUM_TBL_TYPE := NULL

239: ,p_wednesday_hours_tbl IN SYSTEM.PA_NUM_TBL_TYPE := NULL
240: ,p_thursday_hours_tbl IN SYSTEM.PA_NUM_TBL_TYPE := NULL
241: ,p_friday_hours_tbl IN SYSTEM.PA_NUM_TBL_TYPE := NULL
242: ,p_saturday_hours_tbl IN SYSTEM.PA_NUM_TBL_TYPE := NULL
243: ,p_sunday_hours_tbl IN SYSTEM.PA_NUM_TBL_TYPE := NULL
244: ,p_non_working_day_flag IN VARCHAR2 := 'N'
245: ,p_change_hours_type_code IN VARCHAR2 := NULL
246: ,p_hrs_per_day IN NUMBER := NULL
247: ,p_calendar_percent IN NUMBER := NULL

Line 257: ,x_success_assignment_id_tbl OUT NOCOPY SYSTEM.PA_NUM_TBL_TYPE /* Added NOCOPY for bug#2674619 */

253: ,p_number_of_shift IN NUMBER := NULL
254: ,p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE
255: ,p_validate_only IN VARCHAR2 := FND_API.G_TRUE
256: ,p_commit IN VARCHAR2 := FND_API.G_FALSE
257: ,x_success_assignment_id_tbl OUT NOCOPY SYSTEM.PA_NUM_TBL_TYPE /* Added NOCOPY for bug#2674619 */
258: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
259: ,x_msg_count OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
260: ,x_msg_data OUT NOCOPY VARCHAR2 ); --File.Sql.39 bug 4440895
261: