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 1325: l_competence_alias_tbl SYSTEM.pa_varchar2_30_tbl_type := SYSTEM.pa_varchar2_30_tbl_type();

1321: l_success_assignments_link VARCHAR2(2000);
1322: l_failure_assignments_link VARCHAR2(2000);
1323: l_assignment_duration NUMBER;
1324: l_competence_id_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
1325: l_competence_alias_tbl SYSTEM.pa_varchar2_30_tbl_type := SYSTEM.pa_varchar2_30_tbl_type();
1326: l_competence_name_tbl SYSTEM.pa_varchar2_240_tbl_type := SYSTEM.pa_varchar2_240_tbl_type();
1327: l_rating_level_id_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
1328: l_mandatory_flag_tbl SYSTEM.pa_varchar2_1_tbl_type := SYSTEM.pa_varchar2_1_tbl_type() ;
1329: l_extension_possible_meaning fnd_lookups.meaning%TYPE;