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_ASSIGNMENT_APPROVAL_PUB dependencies on PA_NUM_TBL_TYPE

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

1139: ,p_requirement_status_code IN VARCHAR2 := NULL
1140: ,p_assignment_status_code IN VARCHAR2 := NULL
1141: ,p_start_date_tbl IN SYSTEM.PA_DATE_TBL_TYPE := NULL
1142: ,p_end_date_tbl IN SYSTEM.PA_DATE_TBL_TYPE := NULL
1143: ,p_monday_hours_tbl IN SYSTEM.PA_NUM_TBL_TYPE := NULL
1144: ,p_tuesday_hours_tbl IN SYSTEM.PA_NUM_TBL_TYPE := NULL
1145: ,p_wednesday_hours_tbl IN SYSTEM.PA_NUM_TBL_TYPE := NULL
1146: ,p_thursday_hours_tbl IN SYSTEM.PA_NUM_TBL_TYPE := NULL
1147: ,p_friday_hours_tbl IN SYSTEM.PA_NUM_TBL_TYPE := NULL

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

1140: ,p_assignment_status_code IN VARCHAR2 := NULL
1141: ,p_start_date_tbl IN SYSTEM.PA_DATE_TBL_TYPE := NULL
1142: ,p_end_date_tbl IN SYSTEM.PA_DATE_TBL_TYPE := NULL
1143: ,p_monday_hours_tbl IN SYSTEM.PA_NUM_TBL_TYPE := NULL
1144: ,p_tuesday_hours_tbl IN SYSTEM.PA_NUM_TBL_TYPE := NULL
1145: ,p_wednesday_hours_tbl IN SYSTEM.PA_NUM_TBL_TYPE := NULL
1146: ,p_thursday_hours_tbl IN SYSTEM.PA_NUM_TBL_TYPE := NULL
1147: ,p_friday_hours_tbl IN SYSTEM.PA_NUM_TBL_TYPE := NULL
1148: ,p_saturday_hours_tbl IN SYSTEM.PA_NUM_TBL_TYPE := NULL

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

1141: ,p_start_date_tbl IN SYSTEM.PA_DATE_TBL_TYPE := NULL
1142: ,p_end_date_tbl IN SYSTEM.PA_DATE_TBL_TYPE := NULL
1143: ,p_monday_hours_tbl IN SYSTEM.PA_NUM_TBL_TYPE := NULL
1144: ,p_tuesday_hours_tbl IN SYSTEM.PA_NUM_TBL_TYPE := NULL
1145: ,p_wednesday_hours_tbl IN SYSTEM.PA_NUM_TBL_TYPE := NULL
1146: ,p_thursday_hours_tbl IN SYSTEM.PA_NUM_TBL_TYPE := NULL
1147: ,p_friday_hours_tbl IN SYSTEM.PA_NUM_TBL_TYPE := NULL
1148: ,p_saturday_hours_tbl IN SYSTEM.PA_NUM_TBL_TYPE := NULL
1149: ,p_sunday_hours_tbl IN SYSTEM.PA_NUM_TBL_TYPE := NULL

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

1142: ,p_end_date_tbl IN SYSTEM.PA_DATE_TBL_TYPE := NULL
1143: ,p_monday_hours_tbl IN SYSTEM.PA_NUM_TBL_TYPE := NULL
1144: ,p_tuesday_hours_tbl IN SYSTEM.PA_NUM_TBL_TYPE := NULL
1145: ,p_wednesday_hours_tbl IN SYSTEM.PA_NUM_TBL_TYPE := NULL
1146: ,p_thursday_hours_tbl IN SYSTEM.PA_NUM_TBL_TYPE := NULL
1147: ,p_friday_hours_tbl IN SYSTEM.PA_NUM_TBL_TYPE := NULL
1148: ,p_saturday_hours_tbl IN SYSTEM.PA_NUM_TBL_TYPE := NULL
1149: ,p_sunday_hours_tbl IN SYSTEM.PA_NUM_TBL_TYPE := NULL
1150: ,p_non_working_day_flag IN VARCHAR2 := 'N'

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

1143: ,p_monday_hours_tbl IN SYSTEM.PA_NUM_TBL_TYPE := NULL
1144: ,p_tuesday_hours_tbl IN SYSTEM.PA_NUM_TBL_TYPE := NULL
1145: ,p_wednesday_hours_tbl IN SYSTEM.PA_NUM_TBL_TYPE := NULL
1146: ,p_thursday_hours_tbl IN SYSTEM.PA_NUM_TBL_TYPE := NULL
1147: ,p_friday_hours_tbl IN SYSTEM.PA_NUM_TBL_TYPE := NULL
1148: ,p_saturday_hours_tbl IN SYSTEM.PA_NUM_TBL_TYPE := NULL
1149: ,p_sunday_hours_tbl IN SYSTEM.PA_NUM_TBL_TYPE := NULL
1150: ,p_non_working_day_flag IN VARCHAR2 := 'N'
1151: ,p_change_hours_type_code IN VARCHAR2 := NULL

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

1144: ,p_tuesday_hours_tbl IN SYSTEM.PA_NUM_TBL_TYPE := NULL
1145: ,p_wednesday_hours_tbl IN SYSTEM.PA_NUM_TBL_TYPE := NULL
1146: ,p_thursday_hours_tbl IN SYSTEM.PA_NUM_TBL_TYPE := NULL
1147: ,p_friday_hours_tbl IN SYSTEM.PA_NUM_TBL_TYPE := NULL
1148: ,p_saturday_hours_tbl IN SYSTEM.PA_NUM_TBL_TYPE := NULL
1149: ,p_sunday_hours_tbl IN SYSTEM.PA_NUM_TBL_TYPE := NULL
1150: ,p_non_working_day_flag IN VARCHAR2 := 'N'
1151: ,p_change_hours_type_code IN VARCHAR2 := NULL
1152: ,p_hrs_per_day IN NUMBER := NULL

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

1145: ,p_wednesday_hours_tbl IN SYSTEM.PA_NUM_TBL_TYPE := NULL
1146: ,p_thursday_hours_tbl IN SYSTEM.PA_NUM_TBL_TYPE := NULL
1147: ,p_friday_hours_tbl IN SYSTEM.PA_NUM_TBL_TYPE := NULL
1148: ,p_saturday_hours_tbl IN SYSTEM.PA_NUM_TBL_TYPE := NULL
1149: ,p_sunday_hours_tbl IN SYSTEM.PA_NUM_TBL_TYPE := NULL
1150: ,p_non_working_day_flag IN VARCHAR2 := 'N'
1151: ,p_change_hours_type_code IN VARCHAR2 := NULL
1152: ,p_hrs_per_day IN NUMBER := NULL
1153: ,p_calendar_percent IN NUMBER := NULL

Line 1632: l_task_assignment_id_tbl system.pa_num_tbl_type;

1628: l_overcommitment_flag VARCHAR2(1);
1629: l_action_set_id NUMBER;
1630: l_return_status VARCHAR2(1);
1631:
1632: l_task_assignment_id_tbl system.pa_num_tbl_type;
1633: l_task_version_id_tbl system.pa_num_tbl_type := system.pa_num_tbl_type();
1634: l_budget_version_id_tbl system.pa_num_tbl_type := system.pa_num_tbl_type();
1635: l_struct_version_id_tbl system.pa_num_tbl_type := system.pa_num_tbl_type();
1636: l_cur_role_flag pa_res_formats_b.role_enabled_flag%TYPE;

Line 1633: l_task_version_id_tbl system.pa_num_tbl_type := system.pa_num_tbl_type();

1629: l_action_set_id NUMBER;
1630: l_return_status VARCHAR2(1);
1631:
1632: l_task_assignment_id_tbl system.pa_num_tbl_type;
1633: l_task_version_id_tbl system.pa_num_tbl_type := system.pa_num_tbl_type();
1634: l_budget_version_id_tbl system.pa_num_tbl_type := system.pa_num_tbl_type();
1635: l_struct_version_id_tbl system.pa_num_tbl_type := system.pa_num_tbl_type();
1636: l_cur_role_flag pa_res_formats_b.role_enabled_flag%TYPE;
1637:

Line 1634: l_budget_version_id_tbl system.pa_num_tbl_type := system.pa_num_tbl_type();

1630: l_return_status VARCHAR2(1);
1631:
1632: l_task_assignment_id_tbl system.pa_num_tbl_type;
1633: l_task_version_id_tbl system.pa_num_tbl_type := system.pa_num_tbl_type();
1634: l_budget_version_id_tbl system.pa_num_tbl_type := system.pa_num_tbl_type();
1635: l_struct_version_id_tbl system.pa_num_tbl_type := system.pa_num_tbl_type();
1636: l_cur_role_flag pa_res_formats_b.role_enabled_flag%TYPE;
1637:
1638:

Line 1635: l_struct_version_id_tbl system.pa_num_tbl_type := system.pa_num_tbl_type();

1631:
1632: l_task_assignment_id_tbl system.pa_num_tbl_type;
1633: l_task_version_id_tbl system.pa_num_tbl_type := system.pa_num_tbl_type();
1634: l_budget_version_id_tbl system.pa_num_tbl_type := system.pa_num_tbl_type();
1635: l_struct_version_id_tbl system.pa_num_tbl_type := system.pa_num_tbl_type();
1636: l_cur_role_flag pa_res_formats_b.role_enabled_flag%TYPE;
1637:
1638:
1639: CURSOR check_record_version IS

Line 2338: ,p_assignment_id_tbl IN SYSTEM.pa_num_tbl_type := prm_empty_num_tbl

2334: --BEGIN FORWARD DECLARATIONS
2335:
2336: PROCEDURE validate_approver_name_id
2337: ( p_project_id IN NUMBER
2338: ,p_assignment_id_tbl IN SYSTEM.pa_num_tbl_type := prm_empty_num_tbl
2339: ,p_approver1_id_tbl IN SYSTEM.pa_num_tbl_type := prm_empty_num_tbl
2340: ,p_approver1_name_tbl IN SYSTEM.pa_varchar2_240_tbl_type := prm_empty_varchar2_240_tbl
2341: ,p_approver2_id_tbl IN SYSTEM.pa_num_tbl_type := prm_empty_num_tbl
2342: ,p_approver2_name_tbl IN SYSTEM.pa_varchar2_240_tbl_type := prm_empty_varchar2_240_tbl

Line 2339: ,p_approver1_id_tbl IN SYSTEM.pa_num_tbl_type := prm_empty_num_tbl

2335:
2336: PROCEDURE validate_approver_name_id
2337: ( p_project_id IN NUMBER
2338: ,p_assignment_id_tbl IN SYSTEM.pa_num_tbl_type := prm_empty_num_tbl
2339: ,p_approver1_id_tbl IN SYSTEM.pa_num_tbl_type := prm_empty_num_tbl
2340: ,p_approver1_name_tbl IN SYSTEM.pa_varchar2_240_tbl_type := prm_empty_varchar2_240_tbl
2341: ,p_approver2_id_tbl IN SYSTEM.pa_num_tbl_type := prm_empty_num_tbl
2342: ,p_approver2_name_tbl IN SYSTEM.pa_varchar2_240_tbl_type := prm_empty_varchar2_240_tbl
2343: ,p_submitter_user_id IN NUMBER

Line 2341: ,p_approver2_id_tbl IN SYSTEM.pa_num_tbl_type := prm_empty_num_tbl

2337: ( p_project_id IN NUMBER
2338: ,p_assignment_id_tbl IN SYSTEM.pa_num_tbl_type := prm_empty_num_tbl
2339: ,p_approver1_id_tbl IN SYSTEM.pa_num_tbl_type := prm_empty_num_tbl
2340: ,p_approver1_name_tbl IN SYSTEM.pa_varchar2_240_tbl_type := prm_empty_varchar2_240_tbl
2341: ,p_approver2_id_tbl IN SYSTEM.pa_num_tbl_type := prm_empty_num_tbl
2342: ,p_approver2_name_tbl IN SYSTEM.pa_varchar2_240_tbl_type := prm_empty_varchar2_240_tbl
2343: ,p_submitter_user_id IN NUMBER
2344: ,p_group_id IN NUMBER
2345: ,p_api_version IN NUMBER := 1.0

Line 2351: ,x_assignment_id_tbl OUT NOCOPY SYSTEM.pa_num_tbl_type

2347: ,p_max_msg_count IN NUMBER := FND_API.G_MISS_NUM
2348: ,p_commit IN VARCHAR2 := FND_API.G_FALSE
2349: ,p_validate_only IN VARCHAR2 := FND_API.G_TRUE
2350: ,p_overriding_authority_flag IN VARCHAR2 := 'N'
2351: ,x_assignment_id_tbl OUT NOCOPY SYSTEM.pa_num_tbl_type
2352: ,x_approver1_id_tbl OUT NOCOPY SYSTEM.pa_num_tbl_type
2353: ,x_approver2_id_tbl OUT NOCOPY SYSTEM.pa_num_tbl_type
2354: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
2355: ,x_msg_count OUT NOCOPY NUMBER --File.Sql.39 bug 4440895

Line 2352: ,x_approver1_id_tbl OUT NOCOPY SYSTEM.pa_num_tbl_type

2348: ,p_commit IN VARCHAR2 := FND_API.G_FALSE
2349: ,p_validate_only IN VARCHAR2 := FND_API.G_TRUE
2350: ,p_overriding_authority_flag IN VARCHAR2 := 'N'
2351: ,x_assignment_id_tbl OUT NOCOPY SYSTEM.pa_num_tbl_type
2352: ,x_approver1_id_tbl OUT NOCOPY SYSTEM.pa_num_tbl_type
2353: ,x_approver2_id_tbl OUT NOCOPY SYSTEM.pa_num_tbl_type
2354: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
2355: ,x_msg_count OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
2356: ,x_msg_data OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895

Line 2353: ,x_approver2_id_tbl OUT NOCOPY SYSTEM.pa_num_tbl_type

2349: ,p_validate_only IN VARCHAR2 := FND_API.G_TRUE
2350: ,p_overriding_authority_flag IN VARCHAR2 := 'N'
2351: ,x_assignment_id_tbl OUT NOCOPY SYSTEM.pa_num_tbl_type
2352: ,x_approver1_id_tbl OUT NOCOPY SYSTEM.pa_num_tbl_type
2353: ,x_approver2_id_tbl OUT NOCOPY SYSTEM.pa_num_tbl_type
2354: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
2355: ,x_msg_count OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
2356: ,x_msg_data OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
2357: );

Line 2373: ,p_resource_id_tbl IN SYSTEM.pa_num_tbl_type := prm_empty_num_tbl

2369: ---------------------------------------------------------------
2370: PROCEDURE mass_submit_for_asgmt_aprvl
2371: (p_mode IN VARCHAR2
2372: ,p_action IN VARCHAR2
2373: ,p_resource_id_tbl IN SYSTEM.pa_num_tbl_type := prm_empty_num_tbl
2374: ,p_assignment_id_tbl IN SYSTEM.pa_num_tbl_type := prm_empty_num_tbl
2375: ,p_assignment_name IN pa_project_assignments.assignment_name%TYPE := FND_API.G_MISS_CHAR
2376: ,p_assignment_type IN pa_project_assignments.assignment_type%TYPE := FND_API.G_MISS_CHAR
2377: ,p_status_code IN pa_project_assignments.status_code%TYPE := FND_API.G_MISS_CHAR

Line 2374: ,p_assignment_id_tbl IN SYSTEM.pa_num_tbl_type := prm_empty_num_tbl

2370: PROCEDURE mass_submit_for_asgmt_aprvl
2371: (p_mode IN VARCHAR2
2372: ,p_action IN VARCHAR2
2373: ,p_resource_id_tbl IN SYSTEM.pa_num_tbl_type := prm_empty_num_tbl
2374: ,p_assignment_id_tbl IN SYSTEM.pa_num_tbl_type := prm_empty_num_tbl
2375: ,p_assignment_name IN pa_project_assignments.assignment_name%TYPE := FND_API.G_MISS_CHAR
2376: ,p_assignment_type IN pa_project_assignments.assignment_type%TYPE := FND_API.G_MISS_CHAR
2377: ,p_status_code IN pa_project_assignments.status_code%TYPE := FND_API.G_MISS_CHAR
2378: ,p_multiple_status_flag IN pa_project_assignments.multiple_status_flag%TYPE := FND_API.G_MISS_CHAR

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

2441: ,p_change_rqmt_status_code IN VARCHAR2 := FND_API.G_MISS_CHAR
2442: ,p_change_asgmt_status_code IN VARCHAR2 := FND_API.G_MISS_CHAR
2443: ,p_change_start_date_tbl IN SYSTEM.PA_DATE_TBL_TYPE := NULL
2444: ,p_change_end_date_tbl IN SYSTEM.PA_DATE_TBL_TYPE := NULL
2445: ,p_monday_hours_tbl IN SYSTEM.PA_NUM_TBL_TYPE := NULL
2446: ,p_tuesday_hours_tbl IN SYSTEM.PA_NUM_TBL_TYPE := NULL
2447: ,p_wednesday_hours_tbl IN SYSTEM.PA_NUM_TBL_TYPE := NULL
2448: ,p_thursday_hours_tbl IN SYSTEM.PA_NUM_TBL_TYPE := NULL
2449: ,p_friday_hours_tbl IN SYSTEM.PA_NUM_TBL_TYPE := NULL

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

2442: ,p_change_asgmt_status_code IN VARCHAR2 := FND_API.G_MISS_CHAR
2443: ,p_change_start_date_tbl IN SYSTEM.PA_DATE_TBL_TYPE := NULL
2444: ,p_change_end_date_tbl IN SYSTEM.PA_DATE_TBL_TYPE := NULL
2445: ,p_monday_hours_tbl IN SYSTEM.PA_NUM_TBL_TYPE := NULL
2446: ,p_tuesday_hours_tbl IN SYSTEM.PA_NUM_TBL_TYPE := NULL
2447: ,p_wednesday_hours_tbl IN SYSTEM.PA_NUM_TBL_TYPE := NULL
2448: ,p_thursday_hours_tbl IN SYSTEM.PA_NUM_TBL_TYPE := NULL
2449: ,p_friday_hours_tbl IN SYSTEM.PA_NUM_TBL_TYPE := NULL
2450: ,p_saturday_hours_tbl IN SYSTEM.PA_NUM_TBL_TYPE := NULL

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

2443: ,p_change_start_date_tbl IN SYSTEM.PA_DATE_TBL_TYPE := NULL
2444: ,p_change_end_date_tbl IN SYSTEM.PA_DATE_TBL_TYPE := NULL
2445: ,p_monday_hours_tbl IN SYSTEM.PA_NUM_TBL_TYPE := NULL
2446: ,p_tuesday_hours_tbl IN SYSTEM.PA_NUM_TBL_TYPE := NULL
2447: ,p_wednesday_hours_tbl IN SYSTEM.PA_NUM_TBL_TYPE := NULL
2448: ,p_thursday_hours_tbl IN SYSTEM.PA_NUM_TBL_TYPE := NULL
2449: ,p_friday_hours_tbl IN SYSTEM.PA_NUM_TBL_TYPE := NULL
2450: ,p_saturday_hours_tbl IN SYSTEM.PA_NUM_TBL_TYPE := NULL
2451: ,p_sunday_hours_tbl IN SYSTEM.PA_NUM_TBL_TYPE := NULL

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

2444: ,p_change_end_date_tbl IN SYSTEM.PA_DATE_TBL_TYPE := NULL
2445: ,p_monday_hours_tbl IN SYSTEM.PA_NUM_TBL_TYPE := NULL
2446: ,p_tuesday_hours_tbl IN SYSTEM.PA_NUM_TBL_TYPE := NULL
2447: ,p_wednesday_hours_tbl IN SYSTEM.PA_NUM_TBL_TYPE := NULL
2448: ,p_thursday_hours_tbl IN SYSTEM.PA_NUM_TBL_TYPE := NULL
2449: ,p_friday_hours_tbl IN SYSTEM.PA_NUM_TBL_TYPE := NULL
2450: ,p_saturday_hours_tbl IN SYSTEM.PA_NUM_TBL_TYPE := NULL
2451: ,p_sunday_hours_tbl IN SYSTEM.PA_NUM_TBL_TYPE := NULL
2452: ,p_non_working_day_flag IN VARCHAR2 := 'N'

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

2445: ,p_monday_hours_tbl IN SYSTEM.PA_NUM_TBL_TYPE := NULL
2446: ,p_tuesday_hours_tbl IN SYSTEM.PA_NUM_TBL_TYPE := NULL
2447: ,p_wednesday_hours_tbl IN SYSTEM.PA_NUM_TBL_TYPE := NULL
2448: ,p_thursday_hours_tbl IN SYSTEM.PA_NUM_TBL_TYPE := NULL
2449: ,p_friday_hours_tbl IN SYSTEM.PA_NUM_TBL_TYPE := NULL
2450: ,p_saturday_hours_tbl IN SYSTEM.PA_NUM_TBL_TYPE := NULL
2451: ,p_sunday_hours_tbl IN SYSTEM.PA_NUM_TBL_TYPE := NULL
2452: ,p_non_working_day_flag IN VARCHAR2 := 'N'
2453: ,p_change_hours_type_code IN VARCHAR2 := FND_API.G_MISS_CHAR

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

2446: ,p_tuesday_hours_tbl IN SYSTEM.PA_NUM_TBL_TYPE := NULL
2447: ,p_wednesday_hours_tbl IN SYSTEM.PA_NUM_TBL_TYPE := NULL
2448: ,p_thursday_hours_tbl IN SYSTEM.PA_NUM_TBL_TYPE := NULL
2449: ,p_friday_hours_tbl IN SYSTEM.PA_NUM_TBL_TYPE := NULL
2450: ,p_saturday_hours_tbl IN SYSTEM.PA_NUM_TBL_TYPE := NULL
2451: ,p_sunday_hours_tbl IN SYSTEM.PA_NUM_TBL_TYPE := NULL
2452: ,p_non_working_day_flag IN VARCHAR2 := 'N'
2453: ,p_change_hours_type_code IN VARCHAR2 := FND_API.G_MISS_CHAR
2454: ,p_hrs_per_day IN NUMBER := FND_API.G_MISS_NUM

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

2447: ,p_wednesday_hours_tbl IN SYSTEM.PA_NUM_TBL_TYPE := NULL
2448: ,p_thursday_hours_tbl IN SYSTEM.PA_NUM_TBL_TYPE := NULL
2449: ,p_friday_hours_tbl IN SYSTEM.PA_NUM_TBL_TYPE := NULL
2450: ,p_saturday_hours_tbl IN SYSTEM.PA_NUM_TBL_TYPE := NULL
2451: ,p_sunday_hours_tbl IN SYSTEM.PA_NUM_TBL_TYPE := NULL
2452: ,p_non_working_day_flag IN VARCHAR2 := 'N'
2453: ,p_change_hours_type_code IN VARCHAR2 := FND_API.G_MISS_CHAR
2454: ,p_hrs_per_day IN NUMBER := FND_API.G_MISS_NUM
2455: ,p_calendar_percent IN NUMBER := FND_API.G_MISS_NUM

Line 2462: ,p_approver1_id_tbl IN SYSTEM.pa_num_tbl_type := prm_empty_num_tbl

2458: ,p_change_calendar_id IN NUMBER := FND_API.G_MISS_NUM
2459: ,p_duration_shift_type_code IN VARCHAR2 := FND_API.G_MISS_CHAR
2460: ,p_duration_shift_unit_code IN VARCHAR2 := FND_API.G_MISS_CHAR
2461: ,p_num_of_shift IN NUMBER := FND_API.G_MISS_NUM
2462: ,p_approver1_id_tbl IN SYSTEM.pa_num_tbl_type := prm_empty_num_tbl
2463: ,p_approver1_name_tbl IN SYSTEM.pa_varchar2_240_tbl_type := prm_empty_varchar2_240_tbl
2464: ,p_approver2_id_tbl IN SYSTEM.pa_num_tbl_type := prm_empty_num_tbl
2465: ,p_approver2_name_tbl IN SYSTEM.pa_varchar2_240_tbl_type := prm_empty_varchar2_240_tbl
2466: ,p_appr_over_auth_flag IN VARCHAR2 := 'N'

Line 2464: ,p_approver2_id_tbl IN SYSTEM.pa_num_tbl_type := prm_empty_num_tbl

2460: ,p_duration_shift_unit_code IN VARCHAR2 := FND_API.G_MISS_CHAR
2461: ,p_num_of_shift IN NUMBER := FND_API.G_MISS_NUM
2462: ,p_approver1_id_tbl IN SYSTEM.pa_num_tbl_type := prm_empty_num_tbl
2463: ,p_approver1_name_tbl IN SYSTEM.pa_varchar2_240_tbl_type := prm_empty_varchar2_240_tbl
2464: ,p_approver2_id_tbl IN SYSTEM.pa_num_tbl_type := prm_empty_num_tbl
2465: ,p_approver2_name_tbl IN SYSTEM.pa_varchar2_240_tbl_type := prm_empty_varchar2_240_tbl
2466: ,p_appr_over_auth_flag IN VARCHAR2 := 'N'
2467: ,p_note_to_all_approvers IN VARCHAR2 := FND_API.G_MISS_CHAR
2468: ,p_competence_id_tbl IN SYSTEM.pa_num_tbl_type := prm_empty_num_tbl

Line 2468: ,p_competence_id_tbl IN SYSTEM.pa_num_tbl_type := prm_empty_num_tbl

2464: ,p_approver2_id_tbl IN SYSTEM.pa_num_tbl_type := prm_empty_num_tbl
2465: ,p_approver2_name_tbl IN SYSTEM.pa_varchar2_240_tbl_type := prm_empty_varchar2_240_tbl
2466: ,p_appr_over_auth_flag IN VARCHAR2 := 'N'
2467: ,p_note_to_all_approvers IN VARCHAR2 := FND_API.G_MISS_CHAR
2468: ,p_competence_id_tbl IN SYSTEM.pa_num_tbl_type := prm_empty_num_tbl
2469: ,p_competence_name_tbl IN SYSTEM.pa_varchar2_240_tbl_type := prm_empty_varchar2_240_tbl
2470: ,p_competence_alias_tbl IN SYSTEM.pa_varchar2_30_tbl_type := prm_empty_varchar2_30_tbl
2471: ,p_rating_level_id_tbl IN SYSTEM.pa_num_tbl_type := prm_empty_num_tbl
2472: ,p_mandatory_flag_tbl IN SYSTEM.pa_varchar2_1_tbl_type := prm_empty_varchar2_1_tbl

Line 2471: ,p_rating_level_id_tbl IN SYSTEM.pa_num_tbl_type := prm_empty_num_tbl

2467: ,p_note_to_all_approvers IN VARCHAR2 := FND_API.G_MISS_CHAR
2468: ,p_competence_id_tbl IN SYSTEM.pa_num_tbl_type := prm_empty_num_tbl
2469: ,p_competence_name_tbl IN SYSTEM.pa_varchar2_240_tbl_type := prm_empty_varchar2_240_tbl
2470: ,p_competence_alias_tbl IN SYSTEM.pa_varchar2_30_tbl_type := prm_empty_varchar2_30_tbl
2471: ,p_rating_level_id_tbl IN SYSTEM.pa_num_tbl_type := prm_empty_num_tbl
2472: ,p_mandatory_flag_tbl IN SYSTEM.pa_varchar2_1_tbl_type := prm_empty_varchar2_1_tbl
2473: ,p_resolve_con_action_code IN VARCHAR2 := FND_API.G_MISS_CHAR
2474: ,p_api_version IN NUMBER := 1.0
2475: ,p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE

Line 2502: l_approver1_id_tbl SYSTEM.pa_num_tbl_type;

2498: l_resource_type_id NUMBER;--Used in Name ID validation
2499: l_msg_index_out NUMBER;
2500:
2501: --These are the local copies of the approver ids used in Name ID validation
2502: l_approver1_id_tbl SYSTEM.pa_num_tbl_type;
2503: l_approver2_id_tbl SYSTEM.pa_num_tbl_type;
2504: l_project_id NUMBER;
2505:
2506: BEGIN

Line 2503: l_approver2_id_tbl SYSTEM.pa_num_tbl_type;

2499: l_msg_index_out NUMBER;
2500:
2501: --These are the local copies of the approver ids used in Name ID validation
2502: l_approver1_id_tbl SYSTEM.pa_num_tbl_type;
2503: l_approver2_id_tbl SYSTEM.pa_num_tbl_type;
2504: l_project_id NUMBER;
2505:
2506: BEGIN
2507:

Line 2756: ,p_assignment_id_tbl IN SYSTEM.pa_num_tbl_type := prm_empty_num_tbl

2752: ---------------------------------------------------------------------------
2753: PROCEDURE mass_assignment_approval
2754: ( p_project_id IN pa_project_assignments.project_id%TYPE := FND_API.G_MISS_NUM
2755: ,p_mode IN VARCHAR2
2756: ,p_assignment_id_tbl IN SYSTEM.pa_num_tbl_type := prm_empty_num_tbl
2757: ,p_approver1_id_tbl IN SYSTEM.pa_num_tbl_type := prm_empty_num_tbl
2758: ,p_approver1_name_tbl IN SYSTEM.pa_varchar2_240_tbl_type := prm_empty_varchar2_240_tbl
2759: ,p_approver2_id_tbl IN SYSTEM.pa_num_tbl_type := prm_empty_num_tbl
2760: ,p_approver2_name_tbl IN SYSTEM.pa_varchar2_240_tbl_type := prm_empty_varchar2_240_tbl

Line 2757: ,p_approver1_id_tbl IN SYSTEM.pa_num_tbl_type := prm_empty_num_tbl

2753: PROCEDURE mass_assignment_approval
2754: ( p_project_id IN pa_project_assignments.project_id%TYPE := FND_API.G_MISS_NUM
2755: ,p_mode IN VARCHAR2
2756: ,p_assignment_id_tbl IN SYSTEM.pa_num_tbl_type := prm_empty_num_tbl
2757: ,p_approver1_id_tbl IN SYSTEM.pa_num_tbl_type := prm_empty_num_tbl
2758: ,p_approver1_name_tbl IN SYSTEM.pa_varchar2_240_tbl_type := prm_empty_varchar2_240_tbl
2759: ,p_approver2_id_tbl IN SYSTEM.pa_num_tbl_type := prm_empty_num_tbl
2760: ,p_approver2_name_tbl IN SYSTEM.pa_varchar2_240_tbl_type := prm_empty_varchar2_240_tbl
2761: ,p_overriding_authority_flag IN VARCHAR2 := 'N'

Line 2759: ,p_approver2_id_tbl IN SYSTEM.pa_num_tbl_type := prm_empty_num_tbl

2755: ,p_mode IN VARCHAR2
2756: ,p_assignment_id_tbl IN SYSTEM.pa_num_tbl_type := prm_empty_num_tbl
2757: ,p_approver1_id_tbl IN SYSTEM.pa_num_tbl_type := prm_empty_num_tbl
2758: ,p_approver1_name_tbl IN SYSTEM.pa_varchar2_240_tbl_type := prm_empty_varchar2_240_tbl
2759: ,p_approver2_id_tbl IN SYSTEM.pa_num_tbl_type := prm_empty_num_tbl
2760: ,p_approver2_name_tbl IN SYSTEM.pa_varchar2_240_tbl_type := prm_empty_varchar2_240_tbl
2761: ,p_overriding_authority_flag IN VARCHAR2 := 'N'
2762: ,p_submitter_user_id IN NUMBER := FND_API.G_MISS_NUM
2763: ,p_note_to_all_approvers IN VARCHAR2 := FND_API.G_MISS_CHAR

Line 2785: l_approver1_id_tbl SYSTEM.pa_num_tbl_type;

2781: l_msg_count NUMBER;
2782: l_msg_data VARCHAR2(2000);
2783: l_data VARCHAR2(2000);
2784: l_assignment_status VARCHAR2(10) := PA_ASSIGNMENT_APPROVAL_PUB.g_submit_action;
2785: l_approver1_id_tbl SYSTEM.pa_num_tbl_type;
2786: l_approver1_name_tbl SYSTEM.pa_varchar2_240_tbl_type;
2787: l_approver2_id_tbl SYSTEM.pa_num_tbl_type;
2788: l_approver2_name_tbl SYSTEM.pa_varchar2_240_tbl_type;
2789: l_assignment_id_tbl SYSTEM.pa_num_tbl_type;

Line 2787: l_approver2_id_tbl SYSTEM.pa_num_tbl_type;

2783: l_data VARCHAR2(2000);
2784: l_assignment_status VARCHAR2(10) := PA_ASSIGNMENT_APPROVAL_PUB.g_submit_action;
2785: l_approver1_id_tbl SYSTEM.pa_num_tbl_type;
2786: l_approver1_name_tbl SYSTEM.pa_varchar2_240_tbl_type;
2787: l_approver2_id_tbl SYSTEM.pa_num_tbl_type;
2788: l_approver2_name_tbl SYSTEM.pa_varchar2_240_tbl_type;
2789: l_assignment_id_tbl SYSTEM.pa_num_tbl_type;
2790: l_apr1_res_auth VARCHAR2(1) := 'Y';
2791: l_apr2_res_auth VARCHAR2(1) := 'Y';

Line 2789: l_assignment_id_tbl SYSTEM.pa_num_tbl_type;

2785: l_approver1_id_tbl SYSTEM.pa_num_tbl_type;
2786: l_approver1_name_tbl SYSTEM.pa_varchar2_240_tbl_type;
2787: l_approver2_id_tbl SYSTEM.pa_num_tbl_type;
2788: l_approver2_name_tbl SYSTEM.pa_varchar2_240_tbl_type;
2789: l_assignment_id_tbl SYSTEM.pa_num_tbl_type;
2790: l_apr1_res_auth VARCHAR2(1) := 'Y';
2791: l_apr2_res_auth VARCHAR2(1) := 'Y';
2792: l_new_asgmt_flag VARCHAR2(1);
2793: x_aprvl_required VARCHAR2(1);

Line 2890: l_appr_asgmt_id_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();

2886: --If any assignment is submitted then flag is set to N
2887: l_error_flag VARCHAR2(1) := 'Y';
2888: l_error_count NUMBER;
2889:
2890: l_appr_asgmt_id_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
2891:
2892: l_privelege varchar2(30);
2893: l_resource_super_user varchar2(1);
2894:

Line 3757: ,p_assignment_id_tbl IN SYSTEM.pa_num_tbl_type := prm_empty_num_tbl

3753: ---------------------------------------------------------
3754: PROCEDURE mass_process_approval_result
3755: ( p_project_id IN pa_project_assignments.project_id%TYPE := FND_API.G_MISS_NUM
3756: ,p_mode IN VARCHAR2
3757: ,p_assignment_id_tbl IN SYSTEM.pa_num_tbl_type := prm_empty_num_tbl
3758: ,p_approval_status_tbl IN SYSTEM.pa_varchar2_30_tbl_type := prm_empty_varchar2_30_tbl
3759: ,p_group_id IN NUMBER
3760: ,p_approver_group_id IN NUMBER
3761: ,p_routing_order IN NUMBER

Line 4043: ,p_assignment_id_tbl IN SYSTEM.pa_num_tbl_type := prm_empty_num_tbl

4039: ----------------------------------------------------
4040: /* Added a new parameter p_overriding_authority_flag for the bug 3213509*/
4041: PROCEDURE validate_approver_name_id
4042: ( p_project_id IN NUMBER
4043: ,p_assignment_id_tbl IN SYSTEM.pa_num_tbl_type := prm_empty_num_tbl
4044: ,p_approver1_id_tbl IN SYSTEM.pa_num_tbl_type := prm_empty_num_tbl
4045: ,p_approver1_name_tbl IN SYSTEM.pa_varchar2_240_tbl_type := prm_empty_varchar2_240_tbl
4046: ,p_approver2_id_tbl IN SYSTEM.pa_num_tbl_type := prm_empty_num_tbl
4047: ,p_approver2_name_tbl IN SYSTEM.pa_varchar2_240_tbl_type := prm_empty_varchar2_240_tbl

Line 4044: ,p_approver1_id_tbl IN SYSTEM.pa_num_tbl_type := prm_empty_num_tbl

4040: /* Added a new parameter p_overriding_authority_flag for the bug 3213509*/
4041: PROCEDURE validate_approver_name_id
4042: ( p_project_id IN NUMBER
4043: ,p_assignment_id_tbl IN SYSTEM.pa_num_tbl_type := prm_empty_num_tbl
4044: ,p_approver1_id_tbl IN SYSTEM.pa_num_tbl_type := prm_empty_num_tbl
4045: ,p_approver1_name_tbl IN SYSTEM.pa_varchar2_240_tbl_type := prm_empty_varchar2_240_tbl
4046: ,p_approver2_id_tbl IN SYSTEM.pa_num_tbl_type := prm_empty_num_tbl
4047: ,p_approver2_name_tbl IN SYSTEM.pa_varchar2_240_tbl_type := prm_empty_varchar2_240_tbl
4048: ,p_submitter_user_id IN NUMBER

Line 4046: ,p_approver2_id_tbl IN SYSTEM.pa_num_tbl_type := prm_empty_num_tbl

4042: ( p_project_id IN NUMBER
4043: ,p_assignment_id_tbl IN SYSTEM.pa_num_tbl_type := prm_empty_num_tbl
4044: ,p_approver1_id_tbl IN SYSTEM.pa_num_tbl_type := prm_empty_num_tbl
4045: ,p_approver1_name_tbl IN SYSTEM.pa_varchar2_240_tbl_type := prm_empty_varchar2_240_tbl
4046: ,p_approver2_id_tbl IN SYSTEM.pa_num_tbl_type := prm_empty_num_tbl
4047: ,p_approver2_name_tbl IN SYSTEM.pa_varchar2_240_tbl_type := prm_empty_varchar2_240_tbl
4048: ,p_submitter_user_id IN NUMBER
4049: ,p_group_id IN NUMBER
4050: ,p_api_version IN NUMBER := 1.0

Line 4056: ,x_assignment_id_tbl OUT NOCOPY SYSTEM.pa_num_tbl_type

4052: ,p_max_msg_count IN NUMBER := FND_API.G_MISS_NUM
4053: ,p_commit IN VARCHAR2 := FND_API.G_FALSE
4054: ,p_validate_only IN VARCHAR2 := FND_API.G_TRUE
4055: ,p_overriding_authority_flag IN VARCHAR2 := 'N'
4056: ,x_assignment_id_tbl OUT NOCOPY SYSTEM.pa_num_tbl_type
4057: ,x_approver1_id_tbl OUT NOCOPY SYSTEM.pa_num_tbl_type
4058: ,x_approver2_id_tbl OUT NOCOPY SYSTEM.pa_num_tbl_type
4059: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
4060: ,x_msg_count OUT NOCOPY NUMBER --File.Sql.39 bug 4440895

Line 4057: ,x_approver1_id_tbl OUT NOCOPY SYSTEM.pa_num_tbl_type

4053: ,p_commit IN VARCHAR2 := FND_API.G_FALSE
4054: ,p_validate_only IN VARCHAR2 := FND_API.G_TRUE
4055: ,p_overriding_authority_flag IN VARCHAR2 := 'N'
4056: ,x_assignment_id_tbl OUT NOCOPY SYSTEM.pa_num_tbl_type
4057: ,x_approver1_id_tbl OUT NOCOPY SYSTEM.pa_num_tbl_type
4058: ,x_approver2_id_tbl OUT NOCOPY SYSTEM.pa_num_tbl_type
4059: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
4060: ,x_msg_count OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
4061: ,x_msg_data OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895

Line 4058: ,x_approver2_id_tbl OUT NOCOPY SYSTEM.pa_num_tbl_type

4054: ,p_validate_only IN VARCHAR2 := FND_API.G_TRUE
4055: ,p_overriding_authority_flag IN VARCHAR2 := 'N'
4056: ,x_assignment_id_tbl OUT NOCOPY SYSTEM.pa_num_tbl_type
4057: ,x_approver1_id_tbl OUT NOCOPY SYSTEM.pa_num_tbl_type
4058: ,x_approver2_id_tbl OUT NOCOPY SYSTEM.pa_num_tbl_type
4059: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
4060: ,x_msg_count OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
4061: ,x_msg_data OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
4062: )