APPS.PA_ASSIGNMENT_APPROVAL_PUB dependencies on PA_VARCHAR2_240_TBL_TYPE

Line 25: prm_empty_varchar2_240_tbl SYSTEM.pa_varchar2_240_tbl_type := SYSTEM.pa_varchar2_240_tbl_type();

21: --Empty tables for mass assignment approval
22: prm_empty_num_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
23: prm_empty_varchar2_1_tbl SYSTEM.pa_varchar2_1_tbl_type := SYSTEM.pa_varchar2_1_tbl_type();
24: prm_empty_varchar2_30_tbl SYSTEM.pa_varchar2_30_tbl_type := SYSTEM.pa_varchar2_30_tbl_type();
25: prm_empty_varchar2_240_tbl SYSTEM.pa_varchar2_240_tbl_type := SYSTEM.pa_varchar2_240_tbl_type();
26:
27:
28: --Record for the PL/SQL table to store approvers
29: TYPE Asgmt_Approvers_Rec_Type

Line 302: ,p_approver1_name_tbl IN SYSTEM.pa_varchar2_240_tbl_type := prm_empty_varchar2_240_tbl

298: ,p_duration_shift_type_code IN VARCHAR2 := FND_API.G_MISS_CHAR
299: ,p_duration_shift_unit_code IN VARCHAR2 := FND_API.G_MISS_CHAR
300: ,p_num_of_shift IN NUMBER := FND_API.G_MISS_NUM
301: ,p_approver1_id_tbl IN SYSTEM.pa_num_tbl_type := prm_empty_num_tbl
302: ,p_approver1_name_tbl IN SYSTEM.pa_varchar2_240_tbl_type := prm_empty_varchar2_240_tbl
303: ,p_approver2_id_tbl IN SYSTEM.pa_num_tbl_type := prm_empty_num_tbl
304: ,p_approver2_name_tbl IN SYSTEM.pa_varchar2_240_tbl_type := prm_empty_varchar2_240_tbl
305: ,p_appr_over_auth_flag IN VARCHAR2 := 'N'
306: ,p_note_to_all_approvers IN VARCHAR2 := FND_API.G_MISS_CHAR

Line 304: ,p_approver2_name_tbl IN SYSTEM.pa_varchar2_240_tbl_type := prm_empty_varchar2_240_tbl

300: ,p_num_of_shift IN NUMBER := FND_API.G_MISS_NUM
301: ,p_approver1_id_tbl IN SYSTEM.pa_num_tbl_type := prm_empty_num_tbl
302: ,p_approver1_name_tbl IN SYSTEM.pa_varchar2_240_tbl_type := prm_empty_varchar2_240_tbl
303: ,p_approver2_id_tbl IN SYSTEM.pa_num_tbl_type := prm_empty_num_tbl
304: ,p_approver2_name_tbl IN SYSTEM.pa_varchar2_240_tbl_type := prm_empty_varchar2_240_tbl
305: ,p_appr_over_auth_flag IN VARCHAR2 := 'N'
306: ,p_note_to_all_approvers IN VARCHAR2 := FND_API.G_MISS_CHAR
307: ,p_competence_id_tbl IN SYSTEM.pa_num_tbl_type := prm_empty_num_tbl
308: ,p_competence_name_tbl IN SYSTEM.pa_varchar2_240_tbl_type := prm_empty_varchar2_240_tbl

Line 308: ,p_competence_name_tbl IN SYSTEM.pa_varchar2_240_tbl_type := prm_empty_varchar2_240_tbl

304: ,p_approver2_name_tbl IN SYSTEM.pa_varchar2_240_tbl_type := prm_empty_varchar2_240_tbl
305: ,p_appr_over_auth_flag IN VARCHAR2 := 'N'
306: ,p_note_to_all_approvers IN VARCHAR2 := FND_API.G_MISS_CHAR
307: ,p_competence_id_tbl IN SYSTEM.pa_num_tbl_type := prm_empty_num_tbl
308: ,p_competence_name_tbl IN SYSTEM.pa_varchar2_240_tbl_type := prm_empty_varchar2_240_tbl
309: ,p_competence_alias_tbl IN SYSTEM.pa_varchar2_30_tbl_type := prm_empty_varchar2_30_tbl
310: ,p_rating_level_id_tbl IN SYSTEM.pa_num_tbl_type := prm_empty_num_tbl
311: ,p_mandatory_flag_tbl IN SYSTEM.pa_varchar2_1_tbl_type := prm_empty_varchar2_1_tbl
312: ,p_resolve_con_action_code IN VARCHAR2 := FND_API.G_MISS_CHAR

Line 327: ,p_approver1_name_tbl IN SYSTEM.pa_varchar2_240_tbl_type := prm_empty_varchar2_240_tbl

323: ( p_project_id IN pa_project_assignments.project_id%TYPE := FND_API.G_MISS_NUM
324: ,p_mode IN VARCHAR2
325: ,p_assignment_id_tbl IN SYSTEM.pa_num_tbl_type := prm_empty_num_tbl
326: ,p_approver1_id_tbl IN SYSTEM.pa_num_tbl_type := prm_empty_num_tbl
327: ,p_approver1_name_tbl IN SYSTEM.pa_varchar2_240_tbl_type := prm_empty_varchar2_240_tbl
328: ,p_approver2_id_tbl IN SYSTEM.pa_num_tbl_type := prm_empty_num_tbl
329: ,p_approver2_name_tbl IN SYSTEM.pa_varchar2_240_tbl_type := prm_empty_varchar2_240_tbl
330: ,p_overriding_authority_flag IN VARCHAR2 := 'N'
331: ,p_submitter_user_id IN NUMBER := FND_API.G_MISS_NUM

Line 329: ,p_approver2_name_tbl IN SYSTEM.pa_varchar2_240_tbl_type := prm_empty_varchar2_240_tbl

325: ,p_assignment_id_tbl IN SYSTEM.pa_num_tbl_type := prm_empty_num_tbl
326: ,p_approver1_id_tbl IN SYSTEM.pa_num_tbl_type := prm_empty_num_tbl
327: ,p_approver1_name_tbl IN SYSTEM.pa_varchar2_240_tbl_type := prm_empty_varchar2_240_tbl
328: ,p_approver2_id_tbl IN SYSTEM.pa_num_tbl_type := prm_empty_num_tbl
329: ,p_approver2_name_tbl IN SYSTEM.pa_varchar2_240_tbl_type := prm_empty_varchar2_240_tbl
330: ,p_overriding_authority_flag IN VARCHAR2 := 'N'
331: ,p_submitter_user_id IN NUMBER := FND_API.G_MISS_NUM
332: ,p_note_to_all_approvers IN VARCHAR2 := FND_API.G_MISS_CHAR
333: ,p_conflict_group_id IN NUMBER := FND_API.G_MISS_NUM