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

3614: -- Input parameters
3615: -- Parameters Type Required Description
3616: -- P_Start_Date DATE YES starting date of the open assignment
3617: -- P_End_Date DATE YES ending date of the open assignment
3618: -- p_task_assignment_id_tbl SYSTEM.PA_NUM_TBL_TYPE YES Table of resource_assignment_id's
3619:
3620:
3621: -- Procedure : get_periodic_start_end
3622: -- Purpose : Get min start date and max end date for working days in the schedule...

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

3623: -- Input parameters
3624: -- Parameters Type Required Description
3625: -- P_Start_Date DATE YES starting date of the open assignment
3626: -- P_End_Date DATE YES ending date of the open assignment
3627: -- p_task_assignment_id_tbl SYSTEM.PA_NUM_TBL_TYPE YES Table of resource_assignment_id's
3628:
3629: PROCEDURE get_periodic_start_end(
3630: p_start_date IN DATE,
3631: p_end_date IN DATE,

Line 3633: p_task_assignment_id_tbl IN SYSTEM.PA_NUM_TBL_TYPE,

3629: PROCEDURE get_periodic_start_end(
3630: p_start_date IN DATE,
3631: p_end_date IN DATE,
3632: p_project_assignment_id IN NUMBER,
3633: p_task_assignment_id_tbl IN SYSTEM.PA_NUM_TBL_TYPE,
3634: x_min_start_date OUT NOCOPY DATE, --File.Sql.39 bug 4440895
3635: x_max_end_date OUT NOCOPY DATE, --File.Sql.39 bug 4440895
3636: p_project_id IN NUMBER,
3637: p_budget_version_id IN NUMBER,

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

3730: -- P_Work_Type_Id NUMBER NO Id for the work type.
3731: -- P_Task_Id NUMBER NO Id for the tasa.
3732: -- P_Task_Percentage NUMBER NO Percentage of the corresponding task.
3733: -- p_sum_tasks_flag VARCHAR2 YES Indicates whether to sum task assignment periodic dates
3734: -- p_task_assignment_id_tbl SYSTEM.PA_NUM_TBL_TYPE REQUIRED Indicates the task assignments to choose.
3735:
3736:
3737:
3738: PROCEDURE create_opn_asg_schedule(p_project_id IN NUMBER,

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

3744: p_work_type_id IN NUMBER:=NULL,
3745: p_task_id IN NUMBER:=NULL,
3746: p_task_percentage IN NUMBER:=NULL,
3747: p_sum_tasks_flag IN VARCHAR2,
3748: p_task_assignment_id_tbl IN SYSTEM.PA_NUM_TBL_TYPE:=SYSTEM.PA_NUM_TBL_TYPE(),
3749: p_budget_version_id IN NUMBER:= NULL,
3750: x_return_status OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
3751: x_msg_count OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895
3752: x_msg_data OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895

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

3932: -- P_Start_Date DATE NO starting date of the open assignment
3933: -- P_End_Date DATE NO ending date of the open assignment
3934: -- P_Assignment_Status_Code VARCHAR2 NO Status of the assignment e.g OPEN/CONFIRM/PROVISIONAL
3935: -- p_sum_tasks_flag VARCHAR2 NO Indicates whether to sum task assignment periodic dates
3936: -- p_task_assignment_id_tbl SYSTEM.PA_NUM_TBL_TYPE NO Indicates the task assignments to choose.
3937:
3938:
3939: PROCEDURE create_opn_asg_schedule(p_project_id IN NUMBER :=NULL,
3940: p_asgn_creation_mode IN VARCHAR2 := NULL, /* Added for Bug 6145532 */

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

3944: p_start_date IN DATE:=NULL,
3945: p_end_date IN DATE := NULL,
3946: p_assignment_status_code IN VARCHAR2:= NULL,
3947: p_sum_tasks_flag IN VARCHAR2 default null,
3948: p_task_assignment_id_tbl IN SYSTEM.PA_NUM_TBL_TYPE:=SYSTEM.PA_NUM_TBL_TYPE(),
3949: p_budget_version_id IN NUMBER:= NULL,
3950: x_return_status OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
3951: x_msg_count OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895
3952: x_msg_data OUT NOCOPY VARCHAR2) IS --File.Sql.39 bug 4440895

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

4241: -- P_Work_Type_Id NUMBER NO Id for the work type.
4242: -- P_Task_Id NUMBER NO Id for the tasa.
4243: -- P_Task_Percentage NUMBER NO Percentage of the corresponding task.
4244: -- p_sum_tasks_flag VARCHAR2 NO Indicates whether to sum task assignment periodic dates
4245: -- p_task_assignment_id_tbl SYSTEM.PA_NUM_TBL_TYPE NO Indicates the task assignments to choose.
4246:
4247:
4248: PROCEDURE create_stf_asg_schedule(p_project_id IN NUMBER,
4249: p_schedule_basis_flag IN VARCHAR2,

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

4258: p_work_type_id IN NUMBER,
4259: p_task_id IN NUMBER,
4260: p_task_percentage IN NUMBER,
4261: p_sum_tasks_flag IN VARCHAR2 default null,
4262: p_task_assignment_id_tbl IN SYSTEM.PA_NUM_TBL_TYPE:=SYSTEM.PA_NUM_TBL_TYPE(),
4263: p_budget_version_id IN NUMBER:= NULL,
4264: x_return_status OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
4265: x_msg_count OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895
4266: x_msg_data OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895

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

5363: ,p_requirement_status_code IN VARCHAR2 := NULL
5364: ,p_assignment_status_code IN VARCHAR2 := NULL
5365: ,p_start_date_tbl IN SYSTEM.PA_DATE_TBL_TYPE := NULL
5366: ,p_end_date_tbl IN SYSTEM.PA_DATE_TBL_TYPE := NULL
5367: ,p_monday_hours_tbl IN SYSTEM.PA_NUM_TBL_TYPE := NULL
5368: ,p_tuesday_hours_tbl IN SYSTEM.PA_NUM_TBL_TYPE := NULL
5369: ,p_wednesday_hours_tbl IN SYSTEM.PA_NUM_TBL_TYPE := NULL
5370: ,p_thursday_hours_tbl IN SYSTEM.PA_NUM_TBL_TYPE := NULL
5371: ,p_friday_hours_tbl IN SYSTEM.PA_NUM_TBL_TYPE := NULL

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

5364: ,p_assignment_status_code IN VARCHAR2 := NULL
5365: ,p_start_date_tbl IN SYSTEM.PA_DATE_TBL_TYPE := NULL
5366: ,p_end_date_tbl IN SYSTEM.PA_DATE_TBL_TYPE := NULL
5367: ,p_monday_hours_tbl IN SYSTEM.PA_NUM_TBL_TYPE := NULL
5368: ,p_tuesday_hours_tbl IN SYSTEM.PA_NUM_TBL_TYPE := NULL
5369: ,p_wednesday_hours_tbl IN SYSTEM.PA_NUM_TBL_TYPE := NULL
5370: ,p_thursday_hours_tbl IN SYSTEM.PA_NUM_TBL_TYPE := NULL
5371: ,p_friday_hours_tbl IN SYSTEM.PA_NUM_TBL_TYPE := NULL
5372: ,p_saturday_hours_tbl IN SYSTEM.PA_NUM_TBL_TYPE := NULL

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

5365: ,p_start_date_tbl IN SYSTEM.PA_DATE_TBL_TYPE := NULL
5366: ,p_end_date_tbl IN SYSTEM.PA_DATE_TBL_TYPE := NULL
5367: ,p_monday_hours_tbl IN SYSTEM.PA_NUM_TBL_TYPE := NULL
5368: ,p_tuesday_hours_tbl IN SYSTEM.PA_NUM_TBL_TYPE := NULL
5369: ,p_wednesday_hours_tbl IN SYSTEM.PA_NUM_TBL_TYPE := NULL
5370: ,p_thursday_hours_tbl IN SYSTEM.PA_NUM_TBL_TYPE := NULL
5371: ,p_friday_hours_tbl IN SYSTEM.PA_NUM_TBL_TYPE := NULL
5372: ,p_saturday_hours_tbl IN SYSTEM.PA_NUM_TBL_TYPE := NULL
5373: ,p_sunday_hours_tbl IN SYSTEM.PA_NUM_TBL_TYPE := NULL

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

5366: ,p_end_date_tbl IN SYSTEM.PA_DATE_TBL_TYPE := NULL
5367: ,p_monday_hours_tbl IN SYSTEM.PA_NUM_TBL_TYPE := NULL
5368: ,p_tuesday_hours_tbl IN SYSTEM.PA_NUM_TBL_TYPE := NULL
5369: ,p_wednesday_hours_tbl IN SYSTEM.PA_NUM_TBL_TYPE := NULL
5370: ,p_thursday_hours_tbl IN SYSTEM.PA_NUM_TBL_TYPE := NULL
5371: ,p_friday_hours_tbl IN SYSTEM.PA_NUM_TBL_TYPE := NULL
5372: ,p_saturday_hours_tbl IN SYSTEM.PA_NUM_TBL_TYPE := NULL
5373: ,p_sunday_hours_tbl IN SYSTEM.PA_NUM_TBL_TYPE := NULL
5374: ,p_non_working_day_flag IN VARCHAR2 := 'N'

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

5367: ,p_monday_hours_tbl IN SYSTEM.PA_NUM_TBL_TYPE := NULL
5368: ,p_tuesday_hours_tbl IN SYSTEM.PA_NUM_TBL_TYPE := NULL
5369: ,p_wednesday_hours_tbl IN SYSTEM.PA_NUM_TBL_TYPE := NULL
5370: ,p_thursday_hours_tbl IN SYSTEM.PA_NUM_TBL_TYPE := NULL
5371: ,p_friday_hours_tbl IN SYSTEM.PA_NUM_TBL_TYPE := NULL
5372: ,p_saturday_hours_tbl IN SYSTEM.PA_NUM_TBL_TYPE := NULL
5373: ,p_sunday_hours_tbl IN SYSTEM.PA_NUM_TBL_TYPE := NULL
5374: ,p_non_working_day_flag IN VARCHAR2 := 'N'
5375: ,p_change_hours_type_code IN VARCHAR2 := NULL

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

5368: ,p_tuesday_hours_tbl IN SYSTEM.PA_NUM_TBL_TYPE := NULL
5369: ,p_wednesday_hours_tbl IN SYSTEM.PA_NUM_TBL_TYPE := NULL
5370: ,p_thursday_hours_tbl IN SYSTEM.PA_NUM_TBL_TYPE := NULL
5371: ,p_friday_hours_tbl IN SYSTEM.PA_NUM_TBL_TYPE := NULL
5372: ,p_saturday_hours_tbl IN SYSTEM.PA_NUM_TBL_TYPE := NULL
5373: ,p_sunday_hours_tbl IN SYSTEM.PA_NUM_TBL_TYPE := NULL
5374: ,p_non_working_day_flag IN VARCHAR2 := 'N'
5375: ,p_change_hours_type_code IN VARCHAR2 := NULL
5376: ,p_hrs_per_day IN NUMBER := NULL

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

5369: ,p_wednesday_hours_tbl IN SYSTEM.PA_NUM_TBL_TYPE := NULL
5370: ,p_thursday_hours_tbl IN SYSTEM.PA_NUM_TBL_TYPE := NULL
5371: ,p_friday_hours_tbl IN SYSTEM.PA_NUM_TBL_TYPE := NULL
5372: ,p_saturday_hours_tbl IN SYSTEM.PA_NUM_TBL_TYPE := NULL
5373: ,p_sunday_hours_tbl IN SYSTEM.PA_NUM_TBL_TYPE := NULL
5374: ,p_non_working_day_flag IN VARCHAR2 := 'N'
5375: ,p_change_hours_type_code IN VARCHAR2 := NULL
5376: ,p_hrs_per_day IN NUMBER := NULL
5377: ,p_calendar_percent IN NUMBER := NULL

Line 7726: p_task_assignments_tbl IN SYSTEM.PA_NUM_TBL_TYPE ,

7722: --
7723: --Bug 5126919: Added parameter x_total_hours which will contain the total hours for which the x_schedule_tbl
7724: --will be prepared.
7725: PROCEDURE sum_task_assignments (
7726: p_task_assignments_tbl IN SYSTEM.PA_NUM_TBL_TYPE ,
7727: p_schedule_tbl IN PA_SCHEDULE_GLOB.ScheduleTabTyp ,
7728: p_start_date IN DATE ,
7729: p_end_date IN DATE ,
7730: x_total_hours OUT NOCOPY NUMBER , -- Bug 5126919