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

Line 356: ,x_new_assignment_id_tbl OUT NOCOPY system.pa_num_tbl_type --File.Sql.39 bug 4440895

352: ,p_search_exp_start_org_id IN pa_project_assignments.search_exp_start_org_id%TYPE := FND_API.G_MISS_NUM
353: ,p_search_min_candidate_score IN pa_project_assignments.search_min_candidate_score%TYPE := FND_API.G_MISS_NUM
354: ,p_enable_auto_cand_nom_flag IN pa_project_assignments.enable_auto_cand_nom_flag%TYPE := FND_API.G_MISS_CHAR
355: -- 5130421 End
356: ,x_new_assignment_id_tbl OUT NOCOPY system.pa_num_tbl_type --File.Sql.39 bug 4440895
357: ,x_new_assignment_id OUT NOCOPY pa_project_assignments.assignment_id%TYPE --File.Sql.39 bug 4440895
358: ,x_assignment_number OUT NOCOPY pa_project_assignments.assignment_number%TYPE --File.Sql.39 bug 4440895
359: ,x_assignment_row_id OUT NOCOPY ROWID --File.Sql.39 bug 4440895
360: ,x_resource_id OUT NOCOPY pa_resources.resource_id%TYPE --File.Sql.39 bug 4440895

Line 1312: ,p_resource_id_tbl IN system.pa_num_tbl_type := NULL

1308: ,p_project_id IN pa_project_assignments.project_id%TYPE := FND_API.G_MISS_NUM
1309: ,p_assignment_template_id IN pa_project_assignments.assignment_template_id%TYPE := FND_API.G_MISS_NUM
1310: ,p_project_role_id IN pa_project_assignments.project_role_id%TYPE := FND_API.G_MISS_NUM
1311: ,p_role_list_id IN pa_role_lists.role_list_id%TYPE := FND_API.G_MISS_NUM
1312: ,p_resource_id_tbl IN system.pa_num_tbl_type := NULL
1313: ,p_resource_name_tbl IN system.pa_varchar2_240_tbl_type := NULL
1314: ,p_resource_source_id_tbl IN system.pa_num_tbl_type := NULL
1315: ,p_project_subteam_id IN pa_project_subteams.project_subteam_id%TYPE := FND_API.G_MISS_NUM
1316: ,p_description IN pa_project_assignments.description%TYPE := FND_API.G_MISS_CHAR

Line 1314: ,p_resource_source_id_tbl IN system.pa_num_tbl_type := NULL

1310: ,p_project_role_id IN pa_project_assignments.project_role_id%TYPE := FND_API.G_MISS_NUM
1311: ,p_role_list_id IN pa_role_lists.role_list_id%TYPE := FND_API.G_MISS_NUM
1312: ,p_resource_id_tbl IN system.pa_num_tbl_type := NULL
1313: ,p_resource_name_tbl IN system.pa_varchar2_240_tbl_type := NULL
1314: ,p_resource_source_id_tbl IN system.pa_num_tbl_type := NULL
1315: ,p_project_subteam_id IN pa_project_subteams.project_subteam_id%TYPE := FND_API.G_MISS_NUM
1316: ,p_description IN pa_project_assignments.description%TYPE := FND_API.G_MISS_CHAR
1317: ,p_start_date IN pa_project_assignments.start_date%TYPE := FND_API.G_MISS_DATE
1318: ,p_end_date IN pa_project_assignments.end_date%TYPE := FND_API.G_MISS_DATE

Line 1399: ,p_resource_id_tbl IN system.pa_num_tbl_type

1395: ,p_project_id IN pa_project_assignments.project_id%TYPE := FND_API.G_MISS_NUM
1396: ,p_assignment_template_id IN pa_project_assignments.assignment_template_id%TYPE := FND_API.G_MISS_NUM
1397: ,p_project_role_id IN pa_project_assignments.project_role_id%TYPE := FND_API.G_MISS_NUM
1398: ,p_role_list_id IN pa_role_lists.role_list_id%TYPE := FND_API.G_MISS_NUM
1399: ,p_resource_id_tbl IN system.pa_num_tbl_type
1400: ,p_project_subteam_id IN pa_project_subteams.project_subteam_id%TYPE := FND_API.G_MISS_NUM
1401: ,p_description IN pa_project_assignments.description%TYPE := FND_API.G_MISS_CHAR
1402: ,p_start_date IN pa_project_assignments.start_date%TYPE := FND_API.G_MISS_DATE
1403: ,p_end_date IN pa_project_assignments.end_date%TYPE := FND_API.G_MISS_DATE

Line 1466: ,x_success_assignment_id_tbl OUT NOCOPY system.pa_num_tbl_type -- For 1159 mandate changes bug#2674619

1462: ,p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE
1463: ,p_commit IN VARCHAR2 := FND_API.G_FALSE
1464: ,p_validate_only IN VARCHAR2 := FND_API.G_TRUE
1465: ,p_max_msg_count IN NUMBER := FND_API.G_MISS_NUM
1466: ,x_success_assignment_id_tbl OUT NOCOPY system.pa_num_tbl_type -- For 1159 mandate changes bug#2674619
1467: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
1468: ,x_msg_count OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
1469: ,x_msg_data OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
1470: );

Line 1476: ,p_assignment_id_tbl IN system.pa_num_tbl_type

1472:
1473:
1474: PROCEDURE Mass_Exec_Update_Assignments
1475: ( p_asgn_update_mode IN VARCHAR2 := FND_API.G_MISS_CHAR
1476: ,p_assignment_id_tbl IN system.pa_num_tbl_type
1477: ,p_assignment_type IN pa_project_assignments.assignment_type%TYPE := FND_API.G_MISS_CHAR
1478: ,p_assignment_name IN pa_project_assignments.assignment_name%TYPE := FND_API.G_MISS_CHAR
1479: ,p_staffing_priority_code IN pa_project_assignments.staffing_priority_code%TYPE := FND_API.G_MISS_CHAR
1480: ,p_project_id IN pa_project_assignments.project_id%TYPE := FND_API.G_MISS_NUM

Line 1556: ,p_assignment_id_tbl IN system.pa_num_tbl_type

1552:
1553:
1554: PROCEDURE Mass_Update_Assignments
1555: ( p_update_mode IN VARCHAR2 := FND_API.G_MISS_CHAR
1556: ,p_assignment_id_tbl IN system.pa_num_tbl_type
1557: ,p_assignment_type IN pa_project_assignments.assignment_type%TYPE := FND_API.G_MISS_CHAR
1558: ,p_assignment_name IN pa_project_assignments.assignment_name%TYPE := FND_API.G_MISS_CHAR
1559: ,p_staffing_priority_code IN pa_project_assignments.staffing_priority_code%TYPE := FND_API.G_MISS_CHAR
1560: ,p_project_id IN pa_project_assignments.project_id%TYPE := FND_API.G_MISS_NUM

Line 1627: ,x_success_assignment_id_tbl OUT NOCOPY system.pa_num_tbl_type -- For 1159 mandate changes bug#2674619

1623: ,p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE
1624: ,p_commit IN VARCHAR2 := FND_API.G_FALSE
1625: ,p_validate_only IN VARCHAR2 := FND_API.G_TRUE
1626: ,p_max_msg_count IN NUMBER := FND_API.G_MISS_NUM
1627: ,x_success_assignment_id_tbl OUT NOCOPY system.pa_num_tbl_type -- For 1159 mandate changes bug#2674619
1628: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
1629: ,x_msg_count OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
1630: ,x_msg_data OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
1631: );