APPS.PA_COMPETENCE_PUB dependencies on PA_NUM_TBL_TYPE

Line 667: ,p_assignment_id_tbl IN SYSTEM.pa_num_tbl_type

663: -------------------------------------------------------------------- */
664: PROCEDURE Mass_Exec_Process_Competences
665: ( p_asgn_update_mode IN VARCHAR2 := FND_API.G_MISS_CHAR
666: ,p_project_id IN pa_project_assignments.project_id%TYPE
667: ,p_assignment_id_tbl IN SYSTEM.pa_num_tbl_type
668: ,p_competence_id_tbl IN SYSTEM.pa_num_tbl_type
669: ,p_competence_name_tbl IN SYSTEM.pa_varchar2_240_tbl_type
670: ,p_competence_alias_tbl IN SYSTEM.pa_varchar2_30_tbl_type
671: ,p_rating_level_id_tbl IN SYSTEM.pa_num_tbl_type

Line 668: ,p_competence_id_tbl IN SYSTEM.pa_num_tbl_type

664: PROCEDURE Mass_Exec_Process_Competences
665: ( p_asgn_update_mode IN VARCHAR2 := FND_API.G_MISS_CHAR
666: ,p_project_id IN pa_project_assignments.project_id%TYPE
667: ,p_assignment_id_tbl IN SYSTEM.pa_num_tbl_type
668: ,p_competence_id_tbl IN SYSTEM.pa_num_tbl_type
669: ,p_competence_name_tbl IN SYSTEM.pa_varchar2_240_tbl_type
670: ,p_competence_alias_tbl IN SYSTEM.pa_varchar2_30_tbl_type
671: ,p_rating_level_id_tbl IN SYSTEM.pa_num_tbl_type
672: ,p_rating_level_value_tbl IN SYSTEM.pa_num_tbl_type

Line 671: ,p_rating_level_id_tbl IN SYSTEM.pa_num_tbl_type

667: ,p_assignment_id_tbl IN SYSTEM.pa_num_tbl_type
668: ,p_competence_id_tbl IN SYSTEM.pa_num_tbl_type
669: ,p_competence_name_tbl IN SYSTEM.pa_varchar2_240_tbl_type
670: ,p_competence_alias_tbl IN SYSTEM.pa_varchar2_30_tbl_type
671: ,p_rating_level_id_tbl IN SYSTEM.pa_num_tbl_type
672: ,p_rating_level_value_tbl IN SYSTEM.pa_num_tbl_type
673: ,p_mandatory_flag_tbl IN SYSTEM.pa_varchar2_1_tbl_type
674: ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
675: ,p_commit IN VARCHAR2 := FND_API.G_FALSE

Line 672: ,p_rating_level_value_tbl IN SYSTEM.pa_num_tbl_type

668: ,p_competence_id_tbl IN SYSTEM.pa_num_tbl_type
669: ,p_competence_name_tbl IN SYSTEM.pa_varchar2_240_tbl_type
670: ,p_competence_alias_tbl IN SYSTEM.pa_varchar2_30_tbl_type
671: ,p_rating_level_id_tbl IN SYSTEM.pa_num_tbl_type
672: ,p_rating_level_value_tbl IN SYSTEM.pa_num_tbl_type
673: ,p_mandatory_flag_tbl IN SYSTEM.pa_varchar2_1_tbl_type
674: ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
675: ,p_commit IN VARCHAR2 := FND_API.G_FALSE
676: ,p_validate_only IN VARCHAR2 := FND_API.G_TRUE

Line 692: l_rating_level_id_tbl SYSTEM.pa_num_tbl_type := p_rating_level_id_tbl;

688: l_competence_id NUMBER;
689: l_rating_level_id NUMBER;
690: l_msg_index_out NUMBER;
691: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
692: l_rating_level_id_tbl SYSTEM.pa_num_tbl_type := p_rating_level_id_tbl;
693: l_rating_level_value_tbl SYSTEM.pa_num_tbl_type := p_rating_level_value_tbl;
694: l_competence_id_tbl SYSTEM.pa_num_tbl_type := p_competence_id_tbl;
695:
696: BEGIN

Line 693: l_rating_level_value_tbl SYSTEM.pa_num_tbl_type := p_rating_level_value_tbl;

689: l_rating_level_id NUMBER;
690: l_msg_index_out NUMBER;
691: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
692: l_rating_level_id_tbl SYSTEM.pa_num_tbl_type := p_rating_level_id_tbl;
693: l_rating_level_value_tbl SYSTEM.pa_num_tbl_type := p_rating_level_value_tbl;
694: l_competence_id_tbl SYSTEM.pa_num_tbl_type := p_competence_id_tbl;
695:
696: BEGIN
697:

Line 694: l_competence_id_tbl SYSTEM.pa_num_tbl_type := p_competence_id_tbl;

690: l_msg_index_out NUMBER;
691: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
692: l_rating_level_id_tbl SYSTEM.pa_num_tbl_type := p_rating_level_id_tbl;
693: l_rating_level_value_tbl SYSTEM.pa_num_tbl_type := p_rating_level_value_tbl;
694: l_competence_id_tbl SYSTEM.pa_num_tbl_type := p_competence_id_tbl;
695:
696: BEGIN
697:
698: --This API is only called to do standard validations

Line 815: p_assignment_tbl IN SYSTEM.pa_num_tbl_type,

811: -------------------------------------------------------------------- */
812:
813: PROCEDURE Mass_Process_Competences
814: ( p_project_id IN pa_project_assignments.project_id%TYPE,
815: p_assignment_tbl IN SYSTEM.pa_num_tbl_type,
816: p_competence_id_tbl IN SYSTEM.pa_num_tbl_type,
817: p_competence_name_tbl IN SYSTEM.pa_varchar2_240_tbl_type,
818: p_competence_alias_tbl IN SYSTEM.pa_varchar2_30_tbl_type,
819: p_rating_level_id_tbl IN SYSTEM.pa_num_tbl_type,

Line 816: p_competence_id_tbl IN SYSTEM.pa_num_tbl_type,

812:
813: PROCEDURE Mass_Process_Competences
814: ( p_project_id IN pa_project_assignments.project_id%TYPE,
815: p_assignment_tbl IN SYSTEM.pa_num_tbl_type,
816: p_competence_id_tbl IN SYSTEM.pa_num_tbl_type,
817: p_competence_name_tbl IN SYSTEM.pa_varchar2_240_tbl_type,
818: p_competence_alias_tbl IN SYSTEM.pa_varchar2_30_tbl_type,
819: p_rating_level_id_tbl IN SYSTEM.pa_num_tbl_type,
820: p_mandatory_flag_tbl IN SYSTEM.pa_varchar2_1_tbl_type,

Line 819: p_rating_level_id_tbl IN SYSTEM.pa_num_tbl_type,

815: p_assignment_tbl IN SYSTEM.pa_num_tbl_type,
816: p_competence_id_tbl IN SYSTEM.pa_num_tbl_type,
817: p_competence_name_tbl IN SYSTEM.pa_varchar2_240_tbl_type,
818: p_competence_alias_tbl IN SYSTEM.pa_varchar2_30_tbl_type,
819: p_rating_level_id_tbl IN SYSTEM.pa_num_tbl_type,
820: p_mandatory_flag_tbl IN SYSTEM.pa_varchar2_1_tbl_type,
821: p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE,
822: p_validate_only IN VARCHAR2 := FND_API.G_TRUE,
823: p_commit IN VARCHAR2 := FND_API.G_FALSE,

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

820: p_mandatory_flag_tbl IN SYSTEM.pa_varchar2_1_tbl_type,
821: p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE,
822: p_validate_only IN VARCHAR2 := FND_API.G_TRUE,
823: p_commit IN VARCHAR2 := FND_API.G_FALSE,
824: x_success_assignment_id_tbl OUT NOCOPY SYSTEM.pa_num_tbl_type, /* Added NOCOPY for bug#2674619 */
825: x_return_status OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
826: x_msg_count OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895
827: x_msg_data OUT NOCOPY VARCHAR2) --File.Sql.39 bug 4440895
828: IS