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

Line 85: ,p_assignment_id_tbl IN SYSTEM.pa_num_tbl_type

81:
82: PROCEDURE Mass_Exec_Process_Competences
83: ( p_asgn_update_mode IN VARCHAR2 := FND_API.G_MISS_CHAR
84: ,p_project_id IN pa_project_assignments.project_id%TYPE
85: ,p_assignment_id_tbl IN SYSTEM.pa_num_tbl_type
86: ,p_competence_id_tbl IN SYSTEM.pa_num_tbl_type
87: ,p_competence_name_tbl IN SYSTEM.pa_varchar2_240_tbl_type
88: ,p_competence_alias_tbl IN SYSTEM.pa_varchar2_30_tbl_type
89: ,p_rating_level_id_tbl IN SYSTEM.pa_num_tbl_type

Line 86: ,p_competence_id_tbl IN SYSTEM.pa_num_tbl_type

82: PROCEDURE Mass_Exec_Process_Competences
83: ( p_asgn_update_mode IN VARCHAR2 := FND_API.G_MISS_CHAR
84: ,p_project_id IN pa_project_assignments.project_id%TYPE
85: ,p_assignment_id_tbl IN SYSTEM.pa_num_tbl_type
86: ,p_competence_id_tbl IN SYSTEM.pa_num_tbl_type
87: ,p_competence_name_tbl IN SYSTEM.pa_varchar2_240_tbl_type
88: ,p_competence_alias_tbl IN SYSTEM.pa_varchar2_30_tbl_type
89: ,p_rating_level_id_tbl IN SYSTEM.pa_num_tbl_type
90: ,p_rating_level_value_tbl IN SYSTEM.pa_num_tbl_type

Line 89: ,p_rating_level_id_tbl IN SYSTEM.pa_num_tbl_type

85: ,p_assignment_id_tbl IN SYSTEM.pa_num_tbl_type
86: ,p_competence_id_tbl IN SYSTEM.pa_num_tbl_type
87: ,p_competence_name_tbl IN SYSTEM.pa_varchar2_240_tbl_type
88: ,p_competence_alias_tbl IN SYSTEM.pa_varchar2_30_tbl_type
89: ,p_rating_level_id_tbl IN SYSTEM.pa_num_tbl_type
90: ,p_rating_level_value_tbl IN SYSTEM.pa_num_tbl_type
91: ,p_mandatory_flag_tbl IN SYSTEM.pa_varchar2_1_tbl_type
92: ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
93: ,p_commit IN VARCHAR2 := FND_API.G_FALSE

Line 90: ,p_rating_level_value_tbl IN SYSTEM.pa_num_tbl_type

86: ,p_competence_id_tbl IN SYSTEM.pa_num_tbl_type
87: ,p_competence_name_tbl IN SYSTEM.pa_varchar2_240_tbl_type
88: ,p_competence_alias_tbl IN SYSTEM.pa_varchar2_30_tbl_type
89: ,p_rating_level_id_tbl IN SYSTEM.pa_num_tbl_type
90: ,p_rating_level_value_tbl IN SYSTEM.pa_num_tbl_type
91: ,p_mandatory_flag_tbl IN SYSTEM.pa_varchar2_1_tbl_type
92: ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
93: ,p_commit IN VARCHAR2 := FND_API.G_FALSE
94: ,p_validate_only IN VARCHAR2 := FND_API.G_TRUE

Line 103: p_assignment_tbl IN SYSTEM.pa_num_tbl_type,

99: );
100:
101: PROCEDURE Mass_Process_Competences
102: ( p_project_id IN pa_project_assignments.project_id%TYPE,
103: p_assignment_tbl IN SYSTEM.pa_num_tbl_type,
104: p_competence_id_tbl IN SYSTEM.pa_num_tbl_type,
105: p_competence_name_tbl IN SYSTEM.pa_varchar2_240_tbl_type,
106: p_competence_alias_tbl IN SYSTEM.pa_varchar2_30_tbl_type,
107: p_rating_level_id_tbl IN SYSTEM.pa_num_tbl_type,

Line 104: p_competence_id_tbl IN SYSTEM.pa_num_tbl_type,

100:
101: PROCEDURE Mass_Process_Competences
102: ( p_project_id IN pa_project_assignments.project_id%TYPE,
103: p_assignment_tbl IN SYSTEM.pa_num_tbl_type,
104: p_competence_id_tbl IN SYSTEM.pa_num_tbl_type,
105: p_competence_name_tbl IN SYSTEM.pa_varchar2_240_tbl_type,
106: p_competence_alias_tbl IN SYSTEM.pa_varchar2_30_tbl_type,
107: p_rating_level_id_tbl IN SYSTEM.pa_num_tbl_type,
108: p_mandatory_flag_tbl IN SYSTEM.pa_varchar2_1_tbl_type,

Line 107: p_rating_level_id_tbl IN SYSTEM.pa_num_tbl_type,

103: p_assignment_tbl IN SYSTEM.pa_num_tbl_type,
104: p_competence_id_tbl IN SYSTEM.pa_num_tbl_type,
105: p_competence_name_tbl IN SYSTEM.pa_varchar2_240_tbl_type,
106: p_competence_alias_tbl IN SYSTEM.pa_varchar2_30_tbl_type,
107: p_rating_level_id_tbl IN SYSTEM.pa_num_tbl_type,
108: p_mandatory_flag_tbl IN SYSTEM.pa_varchar2_1_tbl_type,
109: p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE,
110: p_validate_only IN VARCHAR2 := FND_API.G_TRUE,
111: p_commit IN VARCHAR2 := FND_API.G_FALSE,

Line 112: x_success_assignment_id_tbl OUT NOCOPY SYSTEM.pa_num_tbl_type, /* Added NOCOPY for bug#2674619 */

108: p_mandatory_flag_tbl IN SYSTEM.pa_varchar2_1_tbl_type,
109: p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE,
110: p_validate_only IN VARCHAR2 := FND_API.G_TRUE,
111: p_commit IN VARCHAR2 := FND_API.G_FALSE,
112: x_success_assignment_id_tbl OUT NOCOPY SYSTEM.pa_num_tbl_type, /* Added NOCOPY for bug#2674619 */
113: x_return_status OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
114: x_msg_count OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895
115: x_msg_data OUT NOCOPY VARCHAR2); --File.Sql.39 bug 4440895
116: