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 AUTHID CURRENT_USER as
2: /* $Header: PARGPVTS.pls 120.7.12010000.3 2009/08/23 19:55:51 vbkumar ship $ */
3: TempIDTab SYSTEM.PA_NUM_TBL_TYPE;
4:
5: TYPE WorkPatternRecord IS RECORD (
6: assignment_id NUMBER,
7: start_date DATE,

Line 254: p_task_assignment_id_tbl IN SYSTEM.PA_NUM_TBL_TYPE,

250: PROCEDURE get_periodic_start_end(
251: p_start_date IN DATE,
252: p_end_date IN DATE,
253: p_project_assignment_id IN NUMBER,
254: p_task_assignment_id_tbl IN SYSTEM.PA_NUM_TBL_TYPE,
255: x_min_start_date OUT NOCOPY DATE, --File.Sql.39 bug 4440895
256: x_max_end_date OUT NOCOPY DATE, --File.Sql.39 bug 4440895
257: p_project_id IN NUMBER,
258: p_budget_version_id IN NUMBER,

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

272: p_work_type_id IN NUMBER:=NULL,
273: p_task_id IN NUMBER:=NULL,
274: p_task_percentage IN NUMBER:=NULL,
275: p_sum_tasks_flag IN VARCHAR2,
276: p_task_assignment_id_tbl IN SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE(),
277: p_budget_version_id IN NUMBER:=NULL,
278: x_return_status OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
279: x_msg_count OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895
280: x_msg_data OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895

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

291: p_start_date IN DATE:=NULL,
292: p_end_date IN DATE := NULL,
293: p_assignment_status_code IN VARCHAR2:= NULL,
294: p_sum_tasks_flag IN VARCHAR2 default null,
295: p_task_assignment_id_tbl IN SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE(),
296: p_budget_version_id IN NUMBER:=NULL,
297: x_return_status OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
298: x_msg_count OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895
299: x_msg_data OUT NOCOPY VARCHAR2); --File.Sql.39 bug 4440895

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

316: p_work_type_id IN NUMBER,
317: p_task_id IN NUMBER,
318: p_task_percentage IN NUMBER,
319: p_sum_tasks_flag IN VARCHAR2 default null,
320: p_task_assignment_id_tbl IN SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE(),
321: p_budget_version_id IN NUMBER:=NULL,
322: x_return_status OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
323: x_msg_count OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895
324: x_msg_data OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895

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

413: ,p_requirement_status_code IN VARCHAR2 := NULL
414: ,p_assignment_status_code IN VARCHAR2 := NULL
415: ,p_start_date_tbl IN SYSTEM.PA_DATE_TBL_TYPE := NULL
416: ,p_end_date_tbl IN SYSTEM.PA_DATE_TBL_TYPE := NULL
417: ,p_monday_hours_tbl IN SYSTEM.PA_NUM_TBL_TYPE := NULL
418: ,p_tuesday_hours_tbl IN SYSTEM.PA_NUM_TBL_TYPE := NULL
419: ,p_wednesday_hours_tbl IN SYSTEM.PA_NUM_TBL_TYPE := NULL
420: ,p_thursday_hours_tbl IN SYSTEM.PA_NUM_TBL_TYPE := NULL
421: ,p_friday_hours_tbl IN SYSTEM.PA_NUM_TBL_TYPE := NULL

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

414: ,p_assignment_status_code IN VARCHAR2 := NULL
415: ,p_start_date_tbl IN SYSTEM.PA_DATE_TBL_TYPE := NULL
416: ,p_end_date_tbl IN SYSTEM.PA_DATE_TBL_TYPE := NULL
417: ,p_monday_hours_tbl IN SYSTEM.PA_NUM_TBL_TYPE := NULL
418: ,p_tuesday_hours_tbl IN SYSTEM.PA_NUM_TBL_TYPE := NULL
419: ,p_wednesday_hours_tbl IN SYSTEM.PA_NUM_TBL_TYPE := NULL
420: ,p_thursday_hours_tbl IN SYSTEM.PA_NUM_TBL_TYPE := NULL
421: ,p_friday_hours_tbl IN SYSTEM.PA_NUM_TBL_TYPE := NULL
422: ,p_saturday_hours_tbl IN SYSTEM.PA_NUM_TBL_TYPE := NULL

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

415: ,p_start_date_tbl IN SYSTEM.PA_DATE_TBL_TYPE := NULL
416: ,p_end_date_tbl IN SYSTEM.PA_DATE_TBL_TYPE := NULL
417: ,p_monday_hours_tbl IN SYSTEM.PA_NUM_TBL_TYPE := NULL
418: ,p_tuesday_hours_tbl IN SYSTEM.PA_NUM_TBL_TYPE := NULL
419: ,p_wednesday_hours_tbl IN SYSTEM.PA_NUM_TBL_TYPE := NULL
420: ,p_thursday_hours_tbl IN SYSTEM.PA_NUM_TBL_TYPE := NULL
421: ,p_friday_hours_tbl IN SYSTEM.PA_NUM_TBL_TYPE := NULL
422: ,p_saturday_hours_tbl IN SYSTEM.PA_NUM_TBL_TYPE := NULL
423: ,p_sunday_hours_tbl IN SYSTEM.PA_NUM_TBL_TYPE := NULL

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

416: ,p_end_date_tbl IN SYSTEM.PA_DATE_TBL_TYPE := NULL
417: ,p_monday_hours_tbl IN SYSTEM.PA_NUM_TBL_TYPE := NULL
418: ,p_tuesday_hours_tbl IN SYSTEM.PA_NUM_TBL_TYPE := NULL
419: ,p_wednesday_hours_tbl IN SYSTEM.PA_NUM_TBL_TYPE := NULL
420: ,p_thursday_hours_tbl IN SYSTEM.PA_NUM_TBL_TYPE := NULL
421: ,p_friday_hours_tbl IN SYSTEM.PA_NUM_TBL_TYPE := NULL
422: ,p_saturday_hours_tbl IN SYSTEM.PA_NUM_TBL_TYPE := NULL
423: ,p_sunday_hours_tbl IN SYSTEM.PA_NUM_TBL_TYPE := NULL
424: ,p_non_working_day_flag IN VARCHAR2 := 'N'

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

417: ,p_monday_hours_tbl IN SYSTEM.PA_NUM_TBL_TYPE := NULL
418: ,p_tuesday_hours_tbl IN SYSTEM.PA_NUM_TBL_TYPE := NULL
419: ,p_wednesday_hours_tbl IN SYSTEM.PA_NUM_TBL_TYPE := NULL
420: ,p_thursday_hours_tbl IN SYSTEM.PA_NUM_TBL_TYPE := NULL
421: ,p_friday_hours_tbl IN SYSTEM.PA_NUM_TBL_TYPE := NULL
422: ,p_saturday_hours_tbl IN SYSTEM.PA_NUM_TBL_TYPE := NULL
423: ,p_sunday_hours_tbl IN SYSTEM.PA_NUM_TBL_TYPE := NULL
424: ,p_non_working_day_flag IN VARCHAR2 := 'N'
425: ,p_change_hours_type_code IN VARCHAR2 := NULL

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

418: ,p_tuesday_hours_tbl IN SYSTEM.PA_NUM_TBL_TYPE := NULL
419: ,p_wednesday_hours_tbl IN SYSTEM.PA_NUM_TBL_TYPE := NULL
420: ,p_thursday_hours_tbl IN SYSTEM.PA_NUM_TBL_TYPE := NULL
421: ,p_friday_hours_tbl IN SYSTEM.PA_NUM_TBL_TYPE := NULL
422: ,p_saturday_hours_tbl IN SYSTEM.PA_NUM_TBL_TYPE := NULL
423: ,p_sunday_hours_tbl IN SYSTEM.PA_NUM_TBL_TYPE := NULL
424: ,p_non_working_day_flag IN VARCHAR2 := 'N'
425: ,p_change_hours_type_code IN VARCHAR2 := NULL
426: ,p_hrs_per_day IN NUMBER := NULL

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

419: ,p_wednesday_hours_tbl IN SYSTEM.PA_NUM_TBL_TYPE := NULL
420: ,p_thursday_hours_tbl IN SYSTEM.PA_NUM_TBL_TYPE := NULL
421: ,p_friday_hours_tbl IN SYSTEM.PA_NUM_TBL_TYPE := NULL
422: ,p_saturday_hours_tbl IN SYSTEM.PA_NUM_TBL_TYPE := NULL
423: ,p_sunday_hours_tbl IN SYSTEM.PA_NUM_TBL_TYPE := NULL
424: ,p_non_working_day_flag IN VARCHAR2 := 'N'
425: ,p_change_hours_type_code IN VARCHAR2 := NULL
426: ,p_hrs_per_day IN NUMBER := NULL
427: ,p_calendar_percent IN NUMBER := NULL

Line 594: p_task_assignments_tbl IN SYSTEM.PA_NUM_TBL_TYPE ,

590: -- new project schedule spanning from p_start_date to p_end_date
591: --Bug 5126919: Added parameter x_total_hours which will contain the total hours for which the x_schedule_tbl
592: --will be prepared.
593: PROCEDURE sum_task_assignments (
594: p_task_assignments_tbl IN SYSTEM.PA_NUM_TBL_TYPE ,
595: p_schedule_tbl IN PA_SCHEDULE_GLOB.ScheduleTabTyp ,
596: p_start_date IN DATE ,
597: p_end_date IN DATE ,
598: x_total_hours OUT NOCOPY NUMBER , -- Bug 5126919