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_NUM_TBL_TYPE

Line 3: TempIDTab SYSTEM.PA_NUM_TBL_TYPE;

1: PACKAGE PA_SCHEDULE_PVT as
2: /* $Header: PARGPVTS.pls 120.7 2007/10/23 08:40:18 sugupta ship $ */
3: TempIDTab SYSTEM.PA_NUM_TBL_TYPE;
4:
5: TYPE WorkPatternRecord IS RECORD (
6: assignment_id NUMBER,
7: start_date DATE,

Line 239: p_task_assignment_id_tbl IN SYSTEM.PA_NUM_TBL_TYPE,

235: PROCEDURE get_periodic_start_end(
236: p_start_date IN DATE,
237: p_end_date IN DATE,
238: p_project_assignment_id IN NUMBER,
239: p_task_assignment_id_tbl IN SYSTEM.PA_NUM_TBL_TYPE,
240: x_min_start_date OUT NOCOPY DATE, --File.Sql.39 bug 4440895
241: x_max_end_date OUT NOCOPY DATE, --File.Sql.39 bug 4440895
242: p_project_id IN NUMBER,
243: p_budget_version_id IN NUMBER,

Line 261: p_task_assignment_id_tbl IN SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE(),

257: p_work_type_id IN NUMBER:=NULL,
258: p_task_id IN NUMBER:=NULL,
259: p_task_percentage IN NUMBER:=NULL,
260: p_sum_tasks_flag IN VARCHAR2,
261: p_task_assignment_id_tbl IN SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE(),
262: p_budget_version_id IN NUMBER:=NULL,
263: x_return_status OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
264: x_msg_count OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895
265: x_msg_data OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895

Line 280: p_task_assignment_id_tbl IN SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE(),

276: p_start_date IN DATE:=NULL,
277: p_end_date IN DATE := NULL,
278: p_assignment_status_code IN VARCHAR2:= NULL,
279: p_sum_tasks_flag IN VARCHAR2 default null,
280: p_task_assignment_id_tbl IN SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE(),
281: p_budget_version_id IN NUMBER:=NULL,
282: x_return_status OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
283: x_msg_count OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895
284: x_msg_data OUT NOCOPY VARCHAR2); --File.Sql.39 bug 4440895

Line 305: p_task_assignment_id_tbl IN SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE(),

301: p_work_type_id IN NUMBER,
302: p_task_id IN NUMBER,
303: p_task_percentage IN NUMBER,
304: p_sum_tasks_flag IN VARCHAR2 default null,
305: p_task_assignment_id_tbl IN SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE(),
306: p_budget_version_id IN NUMBER:=NULL,
307: x_return_status OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
308: x_msg_count OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895
309: x_msg_data OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895

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

398: ,p_requirement_status_code IN VARCHAR2 := NULL
399: ,p_assignment_status_code IN VARCHAR2 := NULL
400: ,p_start_date_tbl IN SYSTEM.PA_DATE_TBL_TYPE := NULL
401: ,p_end_date_tbl IN SYSTEM.PA_DATE_TBL_TYPE := NULL
402: ,p_monday_hours_tbl IN SYSTEM.PA_NUM_TBL_TYPE := NULL
403: ,p_tuesday_hours_tbl IN SYSTEM.PA_NUM_TBL_TYPE := NULL
404: ,p_wednesday_hours_tbl IN SYSTEM.PA_NUM_TBL_TYPE := NULL
405: ,p_thursday_hours_tbl IN SYSTEM.PA_NUM_TBL_TYPE := NULL
406: ,p_friday_hours_tbl IN SYSTEM.PA_NUM_TBL_TYPE := NULL

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

399: ,p_assignment_status_code IN VARCHAR2 := NULL
400: ,p_start_date_tbl IN SYSTEM.PA_DATE_TBL_TYPE := NULL
401: ,p_end_date_tbl IN SYSTEM.PA_DATE_TBL_TYPE := NULL
402: ,p_monday_hours_tbl IN SYSTEM.PA_NUM_TBL_TYPE := NULL
403: ,p_tuesday_hours_tbl IN SYSTEM.PA_NUM_TBL_TYPE := NULL
404: ,p_wednesday_hours_tbl IN SYSTEM.PA_NUM_TBL_TYPE := NULL
405: ,p_thursday_hours_tbl IN SYSTEM.PA_NUM_TBL_TYPE := NULL
406: ,p_friday_hours_tbl IN SYSTEM.PA_NUM_TBL_TYPE := NULL
407: ,p_saturday_hours_tbl IN SYSTEM.PA_NUM_TBL_TYPE := NULL

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

400: ,p_start_date_tbl IN SYSTEM.PA_DATE_TBL_TYPE := NULL
401: ,p_end_date_tbl IN SYSTEM.PA_DATE_TBL_TYPE := NULL
402: ,p_monday_hours_tbl IN SYSTEM.PA_NUM_TBL_TYPE := NULL
403: ,p_tuesday_hours_tbl IN SYSTEM.PA_NUM_TBL_TYPE := NULL
404: ,p_wednesday_hours_tbl IN SYSTEM.PA_NUM_TBL_TYPE := NULL
405: ,p_thursday_hours_tbl IN SYSTEM.PA_NUM_TBL_TYPE := NULL
406: ,p_friday_hours_tbl IN SYSTEM.PA_NUM_TBL_TYPE := NULL
407: ,p_saturday_hours_tbl IN SYSTEM.PA_NUM_TBL_TYPE := NULL
408: ,p_sunday_hours_tbl IN SYSTEM.PA_NUM_TBL_TYPE := NULL

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

401: ,p_end_date_tbl IN SYSTEM.PA_DATE_TBL_TYPE := NULL
402: ,p_monday_hours_tbl IN SYSTEM.PA_NUM_TBL_TYPE := NULL
403: ,p_tuesday_hours_tbl IN SYSTEM.PA_NUM_TBL_TYPE := NULL
404: ,p_wednesday_hours_tbl IN SYSTEM.PA_NUM_TBL_TYPE := NULL
405: ,p_thursday_hours_tbl IN SYSTEM.PA_NUM_TBL_TYPE := NULL
406: ,p_friday_hours_tbl IN SYSTEM.PA_NUM_TBL_TYPE := NULL
407: ,p_saturday_hours_tbl IN SYSTEM.PA_NUM_TBL_TYPE := NULL
408: ,p_sunday_hours_tbl IN SYSTEM.PA_NUM_TBL_TYPE := NULL
409: ,p_non_working_day_flag IN VARCHAR2 := 'N'

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

402: ,p_monday_hours_tbl IN SYSTEM.PA_NUM_TBL_TYPE := NULL
403: ,p_tuesday_hours_tbl IN SYSTEM.PA_NUM_TBL_TYPE := NULL
404: ,p_wednesday_hours_tbl IN SYSTEM.PA_NUM_TBL_TYPE := NULL
405: ,p_thursday_hours_tbl IN SYSTEM.PA_NUM_TBL_TYPE := NULL
406: ,p_friday_hours_tbl IN SYSTEM.PA_NUM_TBL_TYPE := NULL
407: ,p_saturday_hours_tbl IN SYSTEM.PA_NUM_TBL_TYPE := NULL
408: ,p_sunday_hours_tbl IN SYSTEM.PA_NUM_TBL_TYPE := NULL
409: ,p_non_working_day_flag IN VARCHAR2 := 'N'
410: ,p_change_hours_type_code IN VARCHAR2 := NULL

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

403: ,p_tuesday_hours_tbl IN SYSTEM.PA_NUM_TBL_TYPE := NULL
404: ,p_wednesday_hours_tbl IN SYSTEM.PA_NUM_TBL_TYPE := NULL
405: ,p_thursday_hours_tbl IN SYSTEM.PA_NUM_TBL_TYPE := NULL
406: ,p_friday_hours_tbl IN SYSTEM.PA_NUM_TBL_TYPE := NULL
407: ,p_saturday_hours_tbl IN SYSTEM.PA_NUM_TBL_TYPE := NULL
408: ,p_sunday_hours_tbl IN SYSTEM.PA_NUM_TBL_TYPE := NULL
409: ,p_non_working_day_flag IN VARCHAR2 := 'N'
410: ,p_change_hours_type_code IN VARCHAR2 := NULL
411: ,p_hrs_per_day IN NUMBER := NULL

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

404: ,p_wednesday_hours_tbl IN SYSTEM.PA_NUM_TBL_TYPE := NULL
405: ,p_thursday_hours_tbl IN SYSTEM.PA_NUM_TBL_TYPE := NULL
406: ,p_friday_hours_tbl IN SYSTEM.PA_NUM_TBL_TYPE := NULL
407: ,p_saturday_hours_tbl IN SYSTEM.PA_NUM_TBL_TYPE := NULL
408: ,p_sunday_hours_tbl IN SYSTEM.PA_NUM_TBL_TYPE := NULL
409: ,p_non_working_day_flag IN VARCHAR2 := 'N'
410: ,p_change_hours_type_code IN VARCHAR2 := NULL
411: ,p_hrs_per_day IN NUMBER := NULL
412: ,p_calendar_percent IN NUMBER := NULL

Line 579: p_task_assignments_tbl IN SYSTEM.PA_NUM_TBL_TYPE ,

575: -- new project schedule spanning from p_start_date to p_end_date
576: --Bug 5126919: Added parameter x_total_hours which will contain the total hours for which the x_schedule_tbl
577: --will be prepared.
578: PROCEDURE sum_task_assignments (
579: p_task_assignments_tbl IN SYSTEM.PA_NUM_TBL_TYPE ,
580: p_schedule_tbl IN PA_SCHEDULE_GLOB.ScheduleTabTyp ,
581: p_start_date IN DATE ,
582: p_end_date IN DATE ,
583: x_total_hours OUT NOCOPY NUMBER , -- Bug 5126919