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 2399: ,p_assignment_id_tbl IN SYSTEM.pa_num_tbl_type := prm_empty_num_tbl

2395: --BEGIN FORWARD DECLARATIONS
2396:
2397: PROCEDURE validate_approver_name_id
2398: ( p_project_id IN NUMBER
2399: ,p_assignment_id_tbl IN SYSTEM.pa_num_tbl_type := prm_empty_num_tbl
2400: ,p_approver1_id_tbl IN SYSTEM.pa_num_tbl_type := prm_empty_num_tbl
2401: ,p_approver1_name_tbl IN SYSTEM.pa_varchar2_240_tbl_type := prm_empty_varchar2_240_tbl
2402: ,p_approver2_id_tbl IN SYSTEM.pa_num_tbl_type := prm_empty_num_tbl
2403: ,p_approver2_name_tbl IN SYSTEM.pa_varchar2_240_tbl_type := prm_empty_varchar2_240_tbl

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

2396:
2397: PROCEDURE validate_approver_name_id
2398: ( p_project_id IN NUMBER
2399: ,p_assignment_id_tbl IN SYSTEM.pa_num_tbl_type := prm_empty_num_tbl
2400: ,p_approver1_id_tbl IN SYSTEM.pa_num_tbl_type := prm_empty_num_tbl
2401: ,p_approver1_name_tbl IN SYSTEM.pa_varchar2_240_tbl_type := prm_empty_varchar2_240_tbl
2402: ,p_approver2_id_tbl IN SYSTEM.pa_num_tbl_type := prm_empty_num_tbl
2403: ,p_approver2_name_tbl IN SYSTEM.pa_varchar2_240_tbl_type := prm_empty_varchar2_240_tbl
2404: ,p_submitter_user_id IN NUMBER

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

2398: ( p_project_id IN NUMBER
2399: ,p_assignment_id_tbl IN SYSTEM.pa_num_tbl_type := prm_empty_num_tbl
2400: ,p_approver1_id_tbl IN SYSTEM.pa_num_tbl_type := prm_empty_num_tbl
2401: ,p_approver1_name_tbl IN SYSTEM.pa_varchar2_240_tbl_type := prm_empty_varchar2_240_tbl
2402: ,p_approver2_id_tbl IN SYSTEM.pa_num_tbl_type := prm_empty_num_tbl
2403: ,p_approver2_name_tbl IN SYSTEM.pa_varchar2_240_tbl_type := prm_empty_varchar2_240_tbl
2404: ,p_submitter_user_id IN NUMBER
2405: ,p_group_id IN NUMBER
2406: ,p_api_version IN NUMBER := 1.0

Line 2412: ,x_assignment_id_tbl OUT NOCOPY SYSTEM.pa_num_tbl_type

2408: ,p_max_msg_count IN NUMBER := FND_API.G_MISS_NUM
2409: ,p_commit IN VARCHAR2 := FND_API.G_FALSE
2410: ,p_validate_only IN VARCHAR2 := FND_API.G_TRUE
2411: ,p_overriding_authority_flag IN VARCHAR2 := 'N'
2412: ,x_assignment_id_tbl OUT NOCOPY SYSTEM.pa_num_tbl_type
2413: ,x_approver1_id_tbl OUT NOCOPY SYSTEM.pa_num_tbl_type
2414: ,x_approver2_id_tbl OUT NOCOPY SYSTEM.pa_num_tbl_type
2415: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
2416: ,x_msg_count OUT NOCOPY NUMBER --File.Sql.39 bug 4440895

Line 2413: ,x_approver1_id_tbl OUT NOCOPY SYSTEM.pa_num_tbl_type

2409: ,p_commit IN VARCHAR2 := FND_API.G_FALSE
2410: ,p_validate_only IN VARCHAR2 := FND_API.G_TRUE
2411: ,p_overriding_authority_flag IN VARCHAR2 := 'N'
2412: ,x_assignment_id_tbl OUT NOCOPY SYSTEM.pa_num_tbl_type
2413: ,x_approver1_id_tbl OUT NOCOPY SYSTEM.pa_num_tbl_type
2414: ,x_approver2_id_tbl OUT NOCOPY SYSTEM.pa_num_tbl_type
2415: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
2416: ,x_msg_count OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
2417: ,x_msg_data OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895

Line 2414: ,x_approver2_id_tbl OUT NOCOPY SYSTEM.pa_num_tbl_type

2410: ,p_validate_only IN VARCHAR2 := FND_API.G_TRUE
2411: ,p_overriding_authority_flag IN VARCHAR2 := 'N'
2412: ,x_assignment_id_tbl OUT NOCOPY SYSTEM.pa_num_tbl_type
2413: ,x_approver1_id_tbl OUT NOCOPY SYSTEM.pa_num_tbl_type
2414: ,x_approver2_id_tbl OUT NOCOPY SYSTEM.pa_num_tbl_type
2415: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
2416: ,x_msg_count OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
2417: ,x_msg_data OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
2418: );

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

2430: ---------------------------------------------------------------
2431: PROCEDURE mass_submit_for_asgmt_aprvl
2432: (p_mode IN VARCHAR2
2433: ,p_action IN VARCHAR2
2434: ,p_resource_id_tbl IN SYSTEM.pa_num_tbl_type := prm_empty_num_tbl
2435: ,p_assignment_id_tbl IN SYSTEM.pa_num_tbl_type := prm_empty_num_tbl
2436: ,p_assignment_name IN pa_project_assignments.assignment_name%TYPE := FND_API.G_MISS_CHAR
2437: ,p_assignment_type IN pa_project_assignments.assignment_type%TYPE := FND_API.G_MISS_CHAR
2438: ,p_status_code IN pa_project_assignments.status_code%TYPE := FND_API.G_MISS_CHAR

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

2431: PROCEDURE mass_submit_for_asgmt_aprvl
2432: (p_mode IN VARCHAR2
2433: ,p_action IN VARCHAR2
2434: ,p_resource_id_tbl IN SYSTEM.pa_num_tbl_type := prm_empty_num_tbl
2435: ,p_assignment_id_tbl IN SYSTEM.pa_num_tbl_type := prm_empty_num_tbl
2436: ,p_assignment_name IN pa_project_assignments.assignment_name%TYPE := FND_API.G_MISS_CHAR
2437: ,p_assignment_type IN pa_project_assignments.assignment_type%TYPE := FND_API.G_MISS_CHAR
2438: ,p_status_code IN pa_project_assignments.status_code%TYPE := FND_API.G_MISS_CHAR
2439: ,p_multiple_status_flag IN pa_project_assignments.multiple_status_flag%TYPE := FND_API.G_MISS_CHAR

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

2502: ,p_change_rqmt_status_code IN VARCHAR2 := FND_API.G_MISS_CHAR
2503: ,p_change_asgmt_status_code IN VARCHAR2 := FND_API.G_MISS_CHAR
2504: ,p_change_start_date_tbl IN SYSTEM.PA_DATE_TBL_TYPE := NULL
2505: ,p_change_end_date_tbl IN SYSTEM.PA_DATE_TBL_TYPE := NULL
2506: ,p_monday_hours_tbl IN SYSTEM.PA_NUM_TBL_TYPE := NULL
2507: ,p_tuesday_hours_tbl IN SYSTEM.PA_NUM_TBL_TYPE := NULL
2508: ,p_wednesday_hours_tbl IN SYSTEM.PA_NUM_TBL_TYPE := NULL
2509: ,p_thursday_hours_tbl IN SYSTEM.PA_NUM_TBL_TYPE := NULL
2510: ,p_friday_hours_tbl IN SYSTEM.PA_NUM_TBL_TYPE := NULL

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

2503: ,p_change_asgmt_status_code IN VARCHAR2 := FND_API.G_MISS_CHAR
2504: ,p_change_start_date_tbl IN SYSTEM.PA_DATE_TBL_TYPE := NULL
2505: ,p_change_end_date_tbl IN SYSTEM.PA_DATE_TBL_TYPE := NULL
2506: ,p_monday_hours_tbl IN SYSTEM.PA_NUM_TBL_TYPE := NULL
2507: ,p_tuesday_hours_tbl IN SYSTEM.PA_NUM_TBL_TYPE := NULL
2508: ,p_wednesday_hours_tbl IN SYSTEM.PA_NUM_TBL_TYPE := NULL
2509: ,p_thursday_hours_tbl IN SYSTEM.PA_NUM_TBL_TYPE := NULL
2510: ,p_friday_hours_tbl IN SYSTEM.PA_NUM_TBL_TYPE := NULL
2511: ,p_saturday_hours_tbl IN SYSTEM.PA_NUM_TBL_TYPE := NULL

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

2504: ,p_change_start_date_tbl IN SYSTEM.PA_DATE_TBL_TYPE := NULL
2505: ,p_change_end_date_tbl IN SYSTEM.PA_DATE_TBL_TYPE := NULL
2506: ,p_monday_hours_tbl IN SYSTEM.PA_NUM_TBL_TYPE := NULL
2507: ,p_tuesday_hours_tbl IN SYSTEM.PA_NUM_TBL_TYPE := NULL
2508: ,p_wednesday_hours_tbl IN SYSTEM.PA_NUM_TBL_TYPE := NULL
2509: ,p_thursday_hours_tbl IN SYSTEM.PA_NUM_TBL_TYPE := NULL
2510: ,p_friday_hours_tbl IN SYSTEM.PA_NUM_TBL_TYPE := NULL
2511: ,p_saturday_hours_tbl IN SYSTEM.PA_NUM_TBL_TYPE := NULL
2512: ,p_sunday_hours_tbl IN SYSTEM.PA_NUM_TBL_TYPE := NULL

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

2505: ,p_change_end_date_tbl IN SYSTEM.PA_DATE_TBL_TYPE := NULL
2506: ,p_monday_hours_tbl IN SYSTEM.PA_NUM_TBL_TYPE := NULL
2507: ,p_tuesday_hours_tbl IN SYSTEM.PA_NUM_TBL_TYPE := NULL
2508: ,p_wednesday_hours_tbl IN SYSTEM.PA_NUM_TBL_TYPE := NULL
2509: ,p_thursday_hours_tbl IN SYSTEM.PA_NUM_TBL_TYPE := NULL
2510: ,p_friday_hours_tbl IN SYSTEM.PA_NUM_TBL_TYPE := NULL
2511: ,p_saturday_hours_tbl IN SYSTEM.PA_NUM_TBL_TYPE := NULL
2512: ,p_sunday_hours_tbl IN SYSTEM.PA_NUM_TBL_TYPE := NULL
2513: ,p_non_working_day_flag IN VARCHAR2 := 'N'

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

2506: ,p_monday_hours_tbl IN SYSTEM.PA_NUM_TBL_TYPE := NULL
2507: ,p_tuesday_hours_tbl IN SYSTEM.PA_NUM_TBL_TYPE := NULL
2508: ,p_wednesday_hours_tbl IN SYSTEM.PA_NUM_TBL_TYPE := NULL
2509: ,p_thursday_hours_tbl IN SYSTEM.PA_NUM_TBL_TYPE := NULL
2510: ,p_friday_hours_tbl IN SYSTEM.PA_NUM_TBL_TYPE := NULL
2511: ,p_saturday_hours_tbl IN SYSTEM.PA_NUM_TBL_TYPE := NULL
2512: ,p_sunday_hours_tbl IN SYSTEM.PA_NUM_TBL_TYPE := NULL
2513: ,p_non_working_day_flag IN VARCHAR2 := 'N'
2514: ,p_change_hours_type_code IN VARCHAR2 := FND_API.G_MISS_CHAR

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

2507: ,p_tuesday_hours_tbl IN SYSTEM.PA_NUM_TBL_TYPE := NULL
2508: ,p_wednesday_hours_tbl IN SYSTEM.PA_NUM_TBL_TYPE := NULL
2509: ,p_thursday_hours_tbl IN SYSTEM.PA_NUM_TBL_TYPE := NULL
2510: ,p_friday_hours_tbl IN SYSTEM.PA_NUM_TBL_TYPE := NULL
2511: ,p_saturday_hours_tbl IN SYSTEM.PA_NUM_TBL_TYPE := NULL
2512: ,p_sunday_hours_tbl IN SYSTEM.PA_NUM_TBL_TYPE := NULL
2513: ,p_non_working_day_flag IN VARCHAR2 := 'N'
2514: ,p_change_hours_type_code IN VARCHAR2 := FND_API.G_MISS_CHAR
2515: ,p_hrs_per_day IN NUMBER := FND_API.G_MISS_NUM

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

2508: ,p_wednesday_hours_tbl IN SYSTEM.PA_NUM_TBL_TYPE := NULL
2509: ,p_thursday_hours_tbl IN SYSTEM.PA_NUM_TBL_TYPE := NULL
2510: ,p_friday_hours_tbl IN SYSTEM.PA_NUM_TBL_TYPE := NULL
2511: ,p_saturday_hours_tbl IN SYSTEM.PA_NUM_TBL_TYPE := NULL
2512: ,p_sunday_hours_tbl IN SYSTEM.PA_NUM_TBL_TYPE := NULL
2513: ,p_non_working_day_flag IN VARCHAR2 := 'N'
2514: ,p_change_hours_type_code IN VARCHAR2 := FND_API.G_MISS_CHAR
2515: ,p_hrs_per_day IN NUMBER := FND_API.G_MISS_NUM
2516: ,p_calendar_percent IN NUMBER := FND_API.G_MISS_NUM

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

2519: ,p_change_calendar_id IN NUMBER := FND_API.G_MISS_NUM
2520: ,p_duration_shift_type_code IN VARCHAR2 := FND_API.G_MISS_CHAR
2521: ,p_duration_shift_unit_code IN VARCHAR2 := FND_API.G_MISS_CHAR
2522: ,p_num_of_shift IN NUMBER := FND_API.G_MISS_NUM
2523: ,p_approver1_id_tbl IN SYSTEM.pa_num_tbl_type := prm_empty_num_tbl
2524: ,p_approver1_name_tbl IN SYSTEM.pa_varchar2_240_tbl_type := prm_empty_varchar2_240_tbl
2525: ,p_approver2_id_tbl IN SYSTEM.pa_num_tbl_type := prm_empty_num_tbl
2526: ,p_approver2_name_tbl IN SYSTEM.pa_varchar2_240_tbl_type := prm_empty_varchar2_240_tbl
2527: ,p_appr_over_auth_flag IN VARCHAR2 := 'N'

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

2521: ,p_duration_shift_unit_code IN VARCHAR2 := FND_API.G_MISS_CHAR
2522: ,p_num_of_shift IN NUMBER := FND_API.G_MISS_NUM
2523: ,p_approver1_id_tbl IN SYSTEM.pa_num_tbl_type := prm_empty_num_tbl
2524: ,p_approver1_name_tbl IN SYSTEM.pa_varchar2_240_tbl_type := prm_empty_varchar2_240_tbl
2525: ,p_approver2_id_tbl IN SYSTEM.pa_num_tbl_type := prm_empty_num_tbl
2526: ,p_approver2_name_tbl IN SYSTEM.pa_varchar2_240_tbl_type := prm_empty_varchar2_240_tbl
2527: ,p_appr_over_auth_flag IN VARCHAR2 := 'N'
2528: ,p_note_to_all_approvers IN VARCHAR2 := FND_API.G_MISS_CHAR
2529: ,p_competence_id_tbl IN SYSTEM.pa_num_tbl_type := prm_empty_num_tbl

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

2525: ,p_approver2_id_tbl IN SYSTEM.pa_num_tbl_type := prm_empty_num_tbl
2526: ,p_approver2_name_tbl IN SYSTEM.pa_varchar2_240_tbl_type := prm_empty_varchar2_240_tbl
2527: ,p_appr_over_auth_flag IN VARCHAR2 := 'N'
2528: ,p_note_to_all_approvers IN VARCHAR2 := FND_API.G_MISS_CHAR
2529: ,p_competence_id_tbl IN SYSTEM.pa_num_tbl_type := prm_empty_num_tbl
2530: ,p_competence_name_tbl IN SYSTEM.pa_varchar2_240_tbl_type := prm_empty_varchar2_240_tbl
2531: ,p_competence_alias_tbl IN SYSTEM.pa_varchar2_30_tbl_type := prm_empty_varchar2_30_tbl
2532: ,p_rating_level_id_tbl IN SYSTEM.pa_num_tbl_type := prm_empty_num_tbl
2533: ,p_mandatory_flag_tbl IN SYSTEM.pa_varchar2_1_tbl_type := prm_empty_varchar2_1_tbl

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

2528: ,p_note_to_all_approvers IN VARCHAR2 := FND_API.G_MISS_CHAR
2529: ,p_competence_id_tbl IN SYSTEM.pa_num_tbl_type := prm_empty_num_tbl
2530: ,p_competence_name_tbl IN SYSTEM.pa_varchar2_240_tbl_type := prm_empty_varchar2_240_tbl
2531: ,p_competence_alias_tbl IN SYSTEM.pa_varchar2_30_tbl_type := prm_empty_varchar2_30_tbl
2532: ,p_rating_level_id_tbl IN SYSTEM.pa_num_tbl_type := prm_empty_num_tbl
2533: ,p_mandatory_flag_tbl IN SYSTEM.pa_varchar2_1_tbl_type := prm_empty_varchar2_1_tbl
2534: ,p_resolve_con_action_code IN VARCHAR2 := FND_API.G_MISS_CHAR
2535: ,p_api_version IN NUMBER := 1.0
2536: ,p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE

Line 2563: l_approver1_id_tbl SYSTEM.pa_num_tbl_type;

2559: l_resource_type_id NUMBER;--Used in Name ID validation
2560: l_msg_index_out NUMBER;
2561:
2562: --These are the local copies of the approver ids used in Name ID validation
2563: l_approver1_id_tbl SYSTEM.pa_num_tbl_type;
2564: l_approver2_id_tbl SYSTEM.pa_num_tbl_type;
2565: l_project_id NUMBER;
2566:
2567: BEGIN

Line 2564: l_approver2_id_tbl SYSTEM.pa_num_tbl_type;

2560: l_msg_index_out NUMBER;
2561:
2562: --These are the local copies of the approver ids used in Name ID validation
2563: l_approver1_id_tbl SYSTEM.pa_num_tbl_type;
2564: l_approver2_id_tbl SYSTEM.pa_num_tbl_type;
2565: l_project_id NUMBER;
2566:
2567: BEGIN
2568:

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

2813: ---------------------------------------------------------------------------
2814: PROCEDURE mass_assignment_approval
2815: ( p_project_id IN pa_project_assignments.project_id%TYPE := FND_API.G_MISS_NUM
2816: ,p_mode IN VARCHAR2
2817: ,p_assignment_id_tbl IN SYSTEM.pa_num_tbl_type := prm_empty_num_tbl
2818: ,p_approver1_id_tbl IN SYSTEM.pa_num_tbl_type := prm_empty_num_tbl
2819: ,p_approver1_name_tbl IN SYSTEM.pa_varchar2_240_tbl_type := prm_empty_varchar2_240_tbl
2820: ,p_approver2_id_tbl IN SYSTEM.pa_num_tbl_type := prm_empty_num_tbl
2821: ,p_approver2_name_tbl IN SYSTEM.pa_varchar2_240_tbl_type := prm_empty_varchar2_240_tbl

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

2814: PROCEDURE mass_assignment_approval
2815: ( p_project_id IN pa_project_assignments.project_id%TYPE := FND_API.G_MISS_NUM
2816: ,p_mode IN VARCHAR2
2817: ,p_assignment_id_tbl IN SYSTEM.pa_num_tbl_type := prm_empty_num_tbl
2818: ,p_approver1_id_tbl IN SYSTEM.pa_num_tbl_type := prm_empty_num_tbl
2819: ,p_approver1_name_tbl IN SYSTEM.pa_varchar2_240_tbl_type := prm_empty_varchar2_240_tbl
2820: ,p_approver2_id_tbl IN SYSTEM.pa_num_tbl_type := prm_empty_num_tbl
2821: ,p_approver2_name_tbl IN SYSTEM.pa_varchar2_240_tbl_type := prm_empty_varchar2_240_tbl
2822: ,p_overriding_authority_flag IN VARCHAR2 := 'N'

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

2816: ,p_mode IN VARCHAR2
2817: ,p_assignment_id_tbl IN SYSTEM.pa_num_tbl_type := prm_empty_num_tbl
2818: ,p_approver1_id_tbl IN SYSTEM.pa_num_tbl_type := prm_empty_num_tbl
2819: ,p_approver1_name_tbl IN SYSTEM.pa_varchar2_240_tbl_type := prm_empty_varchar2_240_tbl
2820: ,p_approver2_id_tbl IN SYSTEM.pa_num_tbl_type := prm_empty_num_tbl
2821: ,p_approver2_name_tbl IN SYSTEM.pa_varchar2_240_tbl_type := prm_empty_varchar2_240_tbl
2822: ,p_overriding_authority_flag IN VARCHAR2 := 'N'
2823: ,p_submitter_user_id IN NUMBER := FND_API.G_MISS_NUM
2824: ,p_note_to_all_approvers IN VARCHAR2 := FND_API.G_MISS_CHAR

Line 2846: l_approver1_id_tbl SYSTEM.pa_num_tbl_type;

2842: l_msg_count NUMBER;
2843: l_msg_data VARCHAR2(2000);
2844: l_data VARCHAR2(2000);
2845: l_assignment_status VARCHAR2(10) := PA_ASSIGNMENT_APPROVAL_PUB.g_submit_action;
2846: l_approver1_id_tbl SYSTEM.pa_num_tbl_type;
2847: l_approver1_name_tbl SYSTEM.pa_varchar2_240_tbl_type;
2848: l_approver2_id_tbl SYSTEM.pa_num_tbl_type;
2849: l_approver2_name_tbl SYSTEM.pa_varchar2_240_tbl_type;
2850: l_assignment_id_tbl SYSTEM.pa_num_tbl_type;

Line 2848: l_approver2_id_tbl SYSTEM.pa_num_tbl_type;

2844: l_data VARCHAR2(2000);
2845: l_assignment_status VARCHAR2(10) := PA_ASSIGNMENT_APPROVAL_PUB.g_submit_action;
2846: l_approver1_id_tbl SYSTEM.pa_num_tbl_type;
2847: l_approver1_name_tbl SYSTEM.pa_varchar2_240_tbl_type;
2848: l_approver2_id_tbl SYSTEM.pa_num_tbl_type;
2849: l_approver2_name_tbl SYSTEM.pa_varchar2_240_tbl_type;
2850: l_assignment_id_tbl SYSTEM.pa_num_tbl_type;
2851: l_apr1_res_auth VARCHAR2(1) := 'Y';
2852: l_apr2_res_auth VARCHAR2(1) := 'Y';

Line 2850: l_assignment_id_tbl SYSTEM.pa_num_tbl_type;

2846: l_approver1_id_tbl SYSTEM.pa_num_tbl_type;
2847: l_approver1_name_tbl SYSTEM.pa_varchar2_240_tbl_type;
2848: l_approver2_id_tbl SYSTEM.pa_num_tbl_type;
2849: l_approver2_name_tbl SYSTEM.pa_varchar2_240_tbl_type;
2850: l_assignment_id_tbl SYSTEM.pa_num_tbl_type;
2851: l_apr1_res_auth VARCHAR2(1) := 'Y';
2852: l_apr2_res_auth VARCHAR2(1) := 'Y';
2853: l_new_asgmt_flag VARCHAR2(1);
2854: x_aprvl_required VARCHAR2(1);

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

2947: --If any assignment is submitted then flag is set to N
2948: l_error_flag VARCHAR2(1) := 'Y';
2949: l_error_count NUMBER;
2950:
2951: l_appr_asgmt_id_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
2952:
2953: l_privelege varchar2(30);
2954: l_resource_super_user varchar2(1);
2955:

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

3818: ---------------------------------------------------------
3819: PROCEDURE mass_process_approval_result
3820: ( p_project_id IN pa_project_assignments.project_id%TYPE := FND_API.G_MISS_NUM
3821: ,p_mode IN VARCHAR2
3822: ,p_assignment_id_tbl IN SYSTEM.pa_num_tbl_type := prm_empty_num_tbl
3823: ,p_approval_status_tbl IN SYSTEM.pa_varchar2_30_tbl_type := prm_empty_varchar2_30_tbl
3824: ,p_group_id IN NUMBER
3825: ,p_approver_group_id IN NUMBER
3826: ,p_routing_order IN NUMBER

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

4104: ----------------------------------------------------
4105: /* Added a new parameter p_overriding_authority_flag for the bug 3213509*/
4106: PROCEDURE validate_approver_name_id
4107: ( p_project_id IN NUMBER
4108: ,p_assignment_id_tbl IN SYSTEM.pa_num_tbl_type := prm_empty_num_tbl
4109: ,p_approver1_id_tbl IN SYSTEM.pa_num_tbl_type := prm_empty_num_tbl
4110: ,p_approver1_name_tbl IN SYSTEM.pa_varchar2_240_tbl_type := prm_empty_varchar2_240_tbl
4111: ,p_approver2_id_tbl IN SYSTEM.pa_num_tbl_type := prm_empty_num_tbl
4112: ,p_approver2_name_tbl IN SYSTEM.pa_varchar2_240_tbl_type := prm_empty_varchar2_240_tbl

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

4105: /* Added a new parameter p_overriding_authority_flag for the bug 3213509*/
4106: PROCEDURE validate_approver_name_id
4107: ( p_project_id IN NUMBER
4108: ,p_assignment_id_tbl IN SYSTEM.pa_num_tbl_type := prm_empty_num_tbl
4109: ,p_approver1_id_tbl IN SYSTEM.pa_num_tbl_type := prm_empty_num_tbl
4110: ,p_approver1_name_tbl IN SYSTEM.pa_varchar2_240_tbl_type := prm_empty_varchar2_240_tbl
4111: ,p_approver2_id_tbl IN SYSTEM.pa_num_tbl_type := prm_empty_num_tbl
4112: ,p_approver2_name_tbl IN SYSTEM.pa_varchar2_240_tbl_type := prm_empty_varchar2_240_tbl
4113: ,p_submitter_user_id IN NUMBER

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

4107: ( p_project_id IN NUMBER
4108: ,p_assignment_id_tbl IN SYSTEM.pa_num_tbl_type := prm_empty_num_tbl
4109: ,p_approver1_id_tbl IN SYSTEM.pa_num_tbl_type := prm_empty_num_tbl
4110: ,p_approver1_name_tbl IN SYSTEM.pa_varchar2_240_tbl_type := prm_empty_varchar2_240_tbl
4111: ,p_approver2_id_tbl IN SYSTEM.pa_num_tbl_type := prm_empty_num_tbl
4112: ,p_approver2_name_tbl IN SYSTEM.pa_varchar2_240_tbl_type := prm_empty_varchar2_240_tbl
4113: ,p_submitter_user_id IN NUMBER
4114: ,p_group_id IN NUMBER
4115: ,p_api_version IN NUMBER := 1.0

Line 4121: ,x_assignment_id_tbl OUT NOCOPY SYSTEM.pa_num_tbl_type

4117: ,p_max_msg_count IN NUMBER := FND_API.G_MISS_NUM
4118: ,p_commit IN VARCHAR2 := FND_API.G_FALSE
4119: ,p_validate_only IN VARCHAR2 := FND_API.G_TRUE
4120: ,p_overriding_authority_flag IN VARCHAR2 := 'N'
4121: ,x_assignment_id_tbl OUT NOCOPY SYSTEM.pa_num_tbl_type
4122: ,x_approver1_id_tbl OUT NOCOPY SYSTEM.pa_num_tbl_type
4123: ,x_approver2_id_tbl OUT NOCOPY SYSTEM.pa_num_tbl_type
4124: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
4125: ,x_msg_count OUT NOCOPY NUMBER --File.Sql.39 bug 4440895

Line 4122: ,x_approver1_id_tbl OUT NOCOPY SYSTEM.pa_num_tbl_type

4118: ,p_commit IN VARCHAR2 := FND_API.G_FALSE
4119: ,p_validate_only IN VARCHAR2 := FND_API.G_TRUE
4120: ,p_overriding_authority_flag IN VARCHAR2 := 'N'
4121: ,x_assignment_id_tbl OUT NOCOPY SYSTEM.pa_num_tbl_type
4122: ,x_approver1_id_tbl OUT NOCOPY SYSTEM.pa_num_tbl_type
4123: ,x_approver2_id_tbl OUT NOCOPY SYSTEM.pa_num_tbl_type
4124: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
4125: ,x_msg_count OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
4126: ,x_msg_data OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895

Line 4123: ,x_approver2_id_tbl OUT NOCOPY SYSTEM.pa_num_tbl_type

4119: ,p_validate_only IN VARCHAR2 := FND_API.G_TRUE
4120: ,p_overriding_authority_flag IN VARCHAR2 := 'N'
4121: ,x_assignment_id_tbl OUT NOCOPY SYSTEM.pa_num_tbl_type
4122: ,x_approver1_id_tbl OUT NOCOPY SYSTEM.pa_num_tbl_type
4123: ,x_approver2_id_tbl OUT NOCOPY SYSTEM.pa_num_tbl_type
4124: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
4125: ,x_msg_count OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
4126: ,x_msg_data OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
4127: )