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 3904: -- p_task_assignment_id_tbl SYSTEM.PA_NUM_TBL_TYPE YES Table of resource_assignment_id's

3900: -- Input parameters
3901: -- Parameters Type Required Description
3902: -- P_Start_Date DATE YES starting date of the open assignment
3903: -- P_End_Date DATE YES ending date of the open assignment
3904: -- p_task_assignment_id_tbl SYSTEM.PA_NUM_TBL_TYPE YES Table of resource_assignment_id's
3905:
3906:
3907: -- Procedure : get_periodic_start_end
3908: -- Purpose : Get min start date and max end date for working days in the schedule...

Line 3913: -- p_task_assignment_id_tbl SYSTEM.PA_NUM_TBL_TYPE YES Table of resource_assignment_id's

3909: -- Input parameters
3910: -- Parameters Type Required Description
3911: -- P_Start_Date DATE YES starting date of the open assignment
3912: -- P_End_Date DATE YES ending date of the open assignment
3913: -- p_task_assignment_id_tbl SYSTEM.PA_NUM_TBL_TYPE YES Table of resource_assignment_id's
3914:
3915: PROCEDURE get_periodic_start_end(
3916: p_start_date IN DATE,
3917: p_end_date IN DATE,

Line 3919: p_task_assignment_id_tbl IN SYSTEM.PA_NUM_TBL_TYPE,

3915: PROCEDURE get_periodic_start_end(
3916: p_start_date IN DATE,
3917: p_end_date IN DATE,
3918: p_project_assignment_id IN NUMBER,
3919: p_task_assignment_id_tbl IN SYSTEM.PA_NUM_TBL_TYPE,
3920: x_min_start_date OUT NOCOPY DATE, --File.Sql.39 bug 4440895
3921: x_max_end_date OUT NOCOPY DATE, --File.Sql.39 bug 4440895
3922: p_project_id IN NUMBER,
3923: p_budget_version_id IN NUMBER,

Line 4020: -- p_task_assignment_id_tbl SYSTEM.PA_NUM_TBL_TYPE REQUIRED Indicates the task assignments to choose.

4016: -- P_Work_Type_Id NUMBER NO Id for the work type.
4017: -- P_Task_Id NUMBER NO Id for the tasa.
4018: -- P_Task_Percentage NUMBER NO Percentage of the corresponding task.
4019: -- p_sum_tasks_flag VARCHAR2 YES Indicates whether to sum task assignment periodic dates
4020: -- p_task_assignment_id_tbl SYSTEM.PA_NUM_TBL_TYPE REQUIRED Indicates the task assignments to choose.
4021:
4022:
4023:
4024: PROCEDURE create_opn_asg_schedule(p_project_id IN NUMBER,

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

4030: p_work_type_id IN NUMBER:=NULL,
4031: p_task_id IN NUMBER:=NULL,
4032: p_task_percentage IN NUMBER:=NULL,
4033: p_sum_tasks_flag IN VARCHAR2,
4034: p_task_assignment_id_tbl IN SYSTEM.PA_NUM_TBL_TYPE:=SYSTEM.PA_NUM_TBL_TYPE(),
4035: p_budget_version_id IN NUMBER:= NULL,
4036: x_return_status OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
4037: x_msg_count OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895
4038: x_msg_data OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895

Line 4222: -- p_task_assignment_id_tbl SYSTEM.PA_NUM_TBL_TYPE NO Indicates the task assignments to choose.

4218: -- P_Start_Date DATE NO starting date of the open assignment
4219: -- P_End_Date DATE NO ending date of the open assignment
4220: -- P_Assignment_Status_Code VARCHAR2 NO Status of the assignment e.g OPEN/CONFIRM/PROVISIONAL
4221: -- p_sum_tasks_flag VARCHAR2 NO Indicates whether to sum task assignment periodic dates
4222: -- p_task_assignment_id_tbl SYSTEM.PA_NUM_TBL_TYPE NO Indicates the task assignments to choose.
4223:
4224:
4225: PROCEDURE create_opn_asg_schedule(p_project_id IN NUMBER :=NULL,
4226: p_asgn_creation_mode IN VARCHAR2 := NULL, /* Added for Bug 6145532 */

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

4230: p_start_date IN DATE:=NULL,
4231: p_end_date IN DATE := NULL,
4232: p_assignment_status_code IN VARCHAR2:= NULL,
4233: p_sum_tasks_flag IN VARCHAR2 default null,
4234: p_task_assignment_id_tbl IN SYSTEM.PA_NUM_TBL_TYPE:=SYSTEM.PA_NUM_TBL_TYPE(),
4235: p_budget_version_id IN NUMBER:= NULL,
4236: x_return_status OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
4237: x_msg_count OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895
4238: x_msg_data OUT NOCOPY VARCHAR2) IS --File.Sql.39 bug 4440895

Line 4531: -- p_task_assignment_id_tbl SYSTEM.PA_NUM_TBL_TYPE NO Indicates the task assignments to choose.

4527: -- P_Work_Type_Id NUMBER NO Id for the work type.
4528: -- P_Task_Id NUMBER NO Id for the tasa.
4529: -- P_Task_Percentage NUMBER NO Percentage of the corresponding task.
4530: -- p_sum_tasks_flag VARCHAR2 NO Indicates whether to sum task assignment periodic dates
4531: -- p_task_assignment_id_tbl SYSTEM.PA_NUM_TBL_TYPE NO Indicates the task assignments to choose.
4532:
4533:
4534: PROCEDURE create_stf_asg_schedule(p_project_id IN NUMBER,
4535: p_schedule_basis_flag IN VARCHAR2,

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

4544: p_work_type_id IN NUMBER,
4545: p_task_id IN NUMBER,
4546: p_task_percentage IN NUMBER,
4547: p_sum_tasks_flag IN VARCHAR2 default null,
4548: p_task_assignment_id_tbl IN SYSTEM.PA_NUM_TBL_TYPE:=SYSTEM.PA_NUM_TBL_TYPE(),
4549: p_budget_version_id IN NUMBER:= NULL,
4550: x_return_status OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
4551: x_msg_count OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895
4552: x_msg_data OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895

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

5649: ,p_requirement_status_code IN VARCHAR2 := NULL
5650: ,p_assignment_status_code IN VARCHAR2 := NULL
5651: ,p_start_date_tbl IN SYSTEM.PA_DATE_TBL_TYPE := NULL
5652: ,p_end_date_tbl IN SYSTEM.PA_DATE_TBL_TYPE := NULL
5653: ,p_monday_hours_tbl IN SYSTEM.PA_NUM_TBL_TYPE := NULL
5654: ,p_tuesday_hours_tbl IN SYSTEM.PA_NUM_TBL_TYPE := NULL
5655: ,p_wednesday_hours_tbl IN SYSTEM.PA_NUM_TBL_TYPE := NULL
5656: ,p_thursday_hours_tbl IN SYSTEM.PA_NUM_TBL_TYPE := NULL
5657: ,p_friday_hours_tbl IN SYSTEM.PA_NUM_TBL_TYPE := NULL

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

5650: ,p_assignment_status_code IN VARCHAR2 := NULL
5651: ,p_start_date_tbl IN SYSTEM.PA_DATE_TBL_TYPE := NULL
5652: ,p_end_date_tbl IN SYSTEM.PA_DATE_TBL_TYPE := NULL
5653: ,p_monday_hours_tbl IN SYSTEM.PA_NUM_TBL_TYPE := NULL
5654: ,p_tuesday_hours_tbl IN SYSTEM.PA_NUM_TBL_TYPE := NULL
5655: ,p_wednesday_hours_tbl IN SYSTEM.PA_NUM_TBL_TYPE := NULL
5656: ,p_thursday_hours_tbl IN SYSTEM.PA_NUM_TBL_TYPE := NULL
5657: ,p_friday_hours_tbl IN SYSTEM.PA_NUM_TBL_TYPE := NULL
5658: ,p_saturday_hours_tbl IN SYSTEM.PA_NUM_TBL_TYPE := NULL

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

5651: ,p_start_date_tbl IN SYSTEM.PA_DATE_TBL_TYPE := NULL
5652: ,p_end_date_tbl IN SYSTEM.PA_DATE_TBL_TYPE := NULL
5653: ,p_monday_hours_tbl IN SYSTEM.PA_NUM_TBL_TYPE := NULL
5654: ,p_tuesday_hours_tbl IN SYSTEM.PA_NUM_TBL_TYPE := NULL
5655: ,p_wednesday_hours_tbl IN SYSTEM.PA_NUM_TBL_TYPE := NULL
5656: ,p_thursday_hours_tbl IN SYSTEM.PA_NUM_TBL_TYPE := NULL
5657: ,p_friday_hours_tbl IN SYSTEM.PA_NUM_TBL_TYPE := NULL
5658: ,p_saturday_hours_tbl IN SYSTEM.PA_NUM_TBL_TYPE := NULL
5659: ,p_sunday_hours_tbl IN SYSTEM.PA_NUM_TBL_TYPE := NULL

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

5652: ,p_end_date_tbl IN SYSTEM.PA_DATE_TBL_TYPE := NULL
5653: ,p_monday_hours_tbl IN SYSTEM.PA_NUM_TBL_TYPE := NULL
5654: ,p_tuesday_hours_tbl IN SYSTEM.PA_NUM_TBL_TYPE := NULL
5655: ,p_wednesday_hours_tbl IN SYSTEM.PA_NUM_TBL_TYPE := NULL
5656: ,p_thursday_hours_tbl IN SYSTEM.PA_NUM_TBL_TYPE := NULL
5657: ,p_friday_hours_tbl IN SYSTEM.PA_NUM_TBL_TYPE := NULL
5658: ,p_saturday_hours_tbl IN SYSTEM.PA_NUM_TBL_TYPE := NULL
5659: ,p_sunday_hours_tbl IN SYSTEM.PA_NUM_TBL_TYPE := NULL
5660: ,p_non_working_day_flag IN VARCHAR2 := 'N'

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

5653: ,p_monday_hours_tbl IN SYSTEM.PA_NUM_TBL_TYPE := NULL
5654: ,p_tuesday_hours_tbl IN SYSTEM.PA_NUM_TBL_TYPE := NULL
5655: ,p_wednesday_hours_tbl IN SYSTEM.PA_NUM_TBL_TYPE := NULL
5656: ,p_thursday_hours_tbl IN SYSTEM.PA_NUM_TBL_TYPE := NULL
5657: ,p_friday_hours_tbl IN SYSTEM.PA_NUM_TBL_TYPE := NULL
5658: ,p_saturday_hours_tbl IN SYSTEM.PA_NUM_TBL_TYPE := NULL
5659: ,p_sunday_hours_tbl IN SYSTEM.PA_NUM_TBL_TYPE := NULL
5660: ,p_non_working_day_flag IN VARCHAR2 := 'N'
5661: ,p_change_hours_type_code IN VARCHAR2 := NULL

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

5654: ,p_tuesday_hours_tbl IN SYSTEM.PA_NUM_TBL_TYPE := NULL
5655: ,p_wednesday_hours_tbl IN SYSTEM.PA_NUM_TBL_TYPE := NULL
5656: ,p_thursday_hours_tbl IN SYSTEM.PA_NUM_TBL_TYPE := NULL
5657: ,p_friday_hours_tbl IN SYSTEM.PA_NUM_TBL_TYPE := NULL
5658: ,p_saturday_hours_tbl IN SYSTEM.PA_NUM_TBL_TYPE := NULL
5659: ,p_sunday_hours_tbl IN SYSTEM.PA_NUM_TBL_TYPE := NULL
5660: ,p_non_working_day_flag IN VARCHAR2 := 'N'
5661: ,p_change_hours_type_code IN VARCHAR2 := NULL
5662: ,p_hrs_per_day IN NUMBER := NULL

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

5655: ,p_wednesday_hours_tbl IN SYSTEM.PA_NUM_TBL_TYPE := NULL
5656: ,p_thursday_hours_tbl IN SYSTEM.PA_NUM_TBL_TYPE := NULL
5657: ,p_friday_hours_tbl IN SYSTEM.PA_NUM_TBL_TYPE := NULL
5658: ,p_saturday_hours_tbl IN SYSTEM.PA_NUM_TBL_TYPE := NULL
5659: ,p_sunday_hours_tbl IN SYSTEM.PA_NUM_TBL_TYPE := NULL
5660: ,p_non_working_day_flag IN VARCHAR2 := 'N'
5661: ,p_change_hours_type_code IN VARCHAR2 := NULL
5662: ,p_hrs_per_day IN NUMBER := NULL
5663: ,p_calendar_percent IN NUMBER := NULL

Line 8019: p_task_assignments_tbl IN SYSTEM.PA_NUM_TBL_TYPE ,

8015: --
8016: --Bug 5126919: Added parameter x_total_hours which will contain the total hours for which the x_schedule_tbl
8017: --will be prepared.
8018: PROCEDURE sum_task_assignments (
8019: p_task_assignments_tbl IN SYSTEM.PA_NUM_TBL_TYPE ,
8020: p_schedule_tbl IN PA_SCHEDULE_GLOB.ScheduleTabTyp ,
8021: p_start_date IN DATE ,
8022: p_end_date IN DATE ,
8023: x_total_hours OUT NOCOPY NUMBER , -- Bug 5126919