APPS.PA_MASS_ASGMT_TRX dependencies on PA_VARCHAR2_30_TBL_TYPE

Line 106: ,p_competence_alias_tbl IN SYSTEM.pa_varchar2_30_tbl_type := pa_empty_varchar2_30_tbl

102: ,p_appr_over_auth_flag IN VARCHAR2 := FND_API.G_MISS_CHAR
103: ,p_note_to_all_approvers IN VARCHAR2 := FND_API.G_MISS_CHAR
104: ,p_competence_id_tbl IN SYSTEM.pa_num_tbl_type := pa_empty_num_tbl
105: ,p_competence_name_tbl IN SYSTEM.pa_varchar2_240_tbl_type := pa_empty_varchar2_240_tbl
106: ,p_competence_alias_tbl IN SYSTEM.pa_varchar2_30_tbl_type := pa_empty_varchar2_30_tbl
107: ,p_rating_level_id_tbl IN SYSTEM.pa_num_tbl_type := pa_empty_num_tbl
108: ,p_mandatory_flag_tbl IN SYSTEM.pa_varchar2_1_tbl_type := pa_empty_varchar2_1_tbl
109: ,p_resolve_con_action_code IN VARCHAR2 := FND_API.G_MISS_CHAR
110: ,x_return_status OUT NOCOPY VARCHAR2 -- 4537865

Line 1382: l_competence_alias_tbl SYSTEM.pa_varchar2_30_tbl_type := SYSTEM.pa_varchar2_30_tbl_type();

1378: l_success_assignments_link VARCHAR2(2000);
1379: l_failure_assignments_link VARCHAR2(2000);
1380: l_assignment_duration NUMBER;
1381: l_competence_id_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
1382: l_competence_alias_tbl SYSTEM.pa_varchar2_30_tbl_type := SYSTEM.pa_varchar2_30_tbl_type();
1383: l_competence_name_tbl SYSTEM.pa_varchar2_240_tbl_type := SYSTEM.pa_varchar2_240_tbl_type();
1384: l_rating_level_id_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
1385: l_mandatory_flag_tbl SYSTEM.pa_varchar2_1_tbl_type := SYSTEM.pa_varchar2_1_tbl_type() ;
1386: l_extension_possible_meaning fnd_lookups.meaning%TYPE;