APPS.PA_MASS_ASGMT_TRX dependencies on PA_VARCHAR2_240_TBL_TYPE

Line 7: pa_empty_varchar2_240_tbl SYSTEM.pa_varchar2_240_tbl_type := SYSTEM.pa_varchar2_240_tbl_type();

3:
4: pa_empty_num_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
5: pa_empty_varchar2_1_tbl SYSTEM.pa_varchar2_1_tbl_type := SYSTEM.pa_varchar2_1_tbl_type();
6: pa_empty_varchar2_30_tbl SYSTEM.pa_varchar2_30_tbl_type := SYSTEM.pa_varchar2_30_tbl_type();
7: pa_empty_varchar2_240_tbl SYSTEM.pa_varchar2_240_tbl_type := SYSTEM.pa_varchar2_240_tbl_type();
8:
9:
10: G_MASS_ASGMT CONSTANT VARCHAR2(30) := 'MASS_ASGMT';
11: G_MASS_UPDATE_ASGMT_BASIC_INFO CONSTANT VARCHAR2(30) := 'MASS_UPDATE_ASGMT_BASIC_INFO';

Line 120: ,p_approver1_name_tbl IN SYSTEM.pa_varchar2_240_tbl_type := pa_empty_varchar2_240_tbl

116: ,p_duration_shift_type_code IN VARCHAR2 := FND_API.G_MISS_CHAR
117: ,p_duration_shift_unit_code IN VARCHAR2 := FND_API.G_MISS_CHAR
118: ,p_num_of_shift IN NUMBER := FND_API.G_MISS_NUM
119: ,p_approver1_id_tbl IN SYSTEM.pa_num_tbl_type := pa_empty_num_tbl
120: ,p_approver1_name_tbl IN SYSTEM.pa_varchar2_240_tbl_type := pa_empty_varchar2_240_tbl
121: ,p_approver2_id_tbl IN SYSTEM.pa_num_tbl_type := pa_empty_num_tbl
122: ,p_approver2_name_tbl IN SYSTEM.pa_varchar2_240_tbl_type := pa_empty_varchar2_240_tbl
123: ,p_appr_over_auth_flag IN VARCHAR2 := FND_API.G_MISS_CHAR
124: ,p_note_to_all_approvers IN VARCHAR2 := FND_API.G_MISS_CHAR

Line 122: ,p_approver2_name_tbl IN SYSTEM.pa_varchar2_240_tbl_type := pa_empty_varchar2_240_tbl

118: ,p_num_of_shift IN NUMBER := FND_API.G_MISS_NUM
119: ,p_approver1_id_tbl IN SYSTEM.pa_num_tbl_type := pa_empty_num_tbl
120: ,p_approver1_name_tbl IN SYSTEM.pa_varchar2_240_tbl_type := pa_empty_varchar2_240_tbl
121: ,p_approver2_id_tbl IN SYSTEM.pa_num_tbl_type := pa_empty_num_tbl
122: ,p_approver2_name_tbl IN SYSTEM.pa_varchar2_240_tbl_type := pa_empty_varchar2_240_tbl
123: ,p_appr_over_auth_flag IN VARCHAR2 := FND_API.G_MISS_CHAR
124: ,p_note_to_all_approvers IN VARCHAR2 := FND_API.G_MISS_CHAR
125: ,p_competence_id_tbl IN SYSTEM.pa_num_tbl_type := pa_empty_num_tbl
126: ,p_competence_name_tbl IN SYSTEM.pa_varchar2_240_tbl_type := pa_empty_varchar2_240_tbl

Line 126: ,p_competence_name_tbl IN SYSTEM.pa_varchar2_240_tbl_type := pa_empty_varchar2_240_tbl

122: ,p_approver2_name_tbl IN SYSTEM.pa_varchar2_240_tbl_type := pa_empty_varchar2_240_tbl
123: ,p_appr_over_auth_flag IN VARCHAR2 := FND_API.G_MISS_CHAR
124: ,p_note_to_all_approvers IN VARCHAR2 := FND_API.G_MISS_CHAR
125: ,p_competence_id_tbl IN SYSTEM.pa_num_tbl_type := pa_empty_num_tbl
126: ,p_competence_name_tbl IN SYSTEM.pa_varchar2_240_tbl_type := pa_empty_varchar2_240_tbl
127: ,p_competence_alias_tbl IN SYSTEM.pa_varchar2_30_tbl_type := pa_empty_varchar2_30_tbl
128: ,p_rating_level_id_tbl IN SYSTEM.pa_num_tbl_type := pa_empty_num_tbl
129: ,p_mandatory_flag_tbl IN SYSTEM.pa_varchar2_1_tbl_type := pa_empty_varchar2_1_tbl
130: ,p_resolve_con_action_code IN VARCHAR2 := FND_API.G_MISS_CHAR