APPS.PA_ASSIGNMENT_APPROVAL_PUB dependencies on PA_VARCHAR2_30_TBL_TYPE

Line 24: prm_empty_varchar2_30_tbl SYSTEM.pa_varchar2_30_tbl_type := SYSTEM.pa_varchar2_30_tbl_type();

20:
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

Line 309: ,p_competence_alias_tbl IN SYSTEM.pa_varchar2_30_tbl_type := prm_empty_varchar2_30_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
313: ,p_api_version IN NUMBER := 1.0

Line 349: ,p_approval_status_tbl IN SYSTEM.pa_varchar2_30_tbl_type := prm_empty_varchar2_30_tbl

345: PROCEDURE mass_process_approval_result
346: ( p_project_id IN pa_project_assignments.project_id%TYPE := FND_API.G_MISS_NUM
347: ,p_mode IN VARCHAR2
348: ,p_assignment_id_tbl IN SYSTEM.pa_num_tbl_type := prm_empty_num_tbl
349: ,p_approval_status_tbl IN SYSTEM.pa_varchar2_30_tbl_type := prm_empty_varchar2_30_tbl
350: ,p_group_id IN NUMBER
351: ,p_approver_group_id IN NUMBER
352: ,p_routing_order IN NUMBER
353: ,p_item_key IN NUMBER