eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PA_ASSIGNMENT_APPROVAL_PUB dependencies on PA_VARCHAR2_240_TBL_TYPE

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

2336: PROCEDURE validate_approver_name_id
2337: ( p_project_id IN NUMBER
2338: ,p_assignment_id_tbl IN SYSTEM.pa_num_tbl_type := prm_empty_num_tbl
2339: ,p_approver1_id_tbl IN SYSTEM.pa_num_tbl_type := prm_empty_num_tbl
2340: ,p_approver1_name_tbl IN SYSTEM.pa_varchar2_240_tbl_type := prm_empty_varchar2_240_tbl
2341: ,p_approver2_id_tbl IN SYSTEM.pa_num_tbl_type := prm_empty_num_tbl
2342: ,p_approver2_name_tbl IN SYSTEM.pa_varchar2_240_tbl_type := prm_empty_varchar2_240_tbl
2343: ,p_submitter_user_id IN NUMBER
2344: ,p_group_id IN NUMBER

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

2338: ,p_assignment_id_tbl IN SYSTEM.pa_num_tbl_type := prm_empty_num_tbl
2339: ,p_approver1_id_tbl IN SYSTEM.pa_num_tbl_type := prm_empty_num_tbl
2340: ,p_approver1_name_tbl IN SYSTEM.pa_varchar2_240_tbl_type := prm_empty_varchar2_240_tbl
2341: ,p_approver2_id_tbl IN SYSTEM.pa_num_tbl_type := prm_empty_num_tbl
2342: ,p_approver2_name_tbl IN SYSTEM.pa_varchar2_240_tbl_type := prm_empty_varchar2_240_tbl
2343: ,p_submitter_user_id IN NUMBER
2344: ,p_group_id IN NUMBER
2345: ,p_api_version IN NUMBER := 1.0
2346: ,p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE

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

2459: ,p_duration_shift_type_code IN VARCHAR2 := FND_API.G_MISS_CHAR
2460: ,p_duration_shift_unit_code IN VARCHAR2 := FND_API.G_MISS_CHAR
2461: ,p_num_of_shift IN NUMBER := FND_API.G_MISS_NUM
2462: ,p_approver1_id_tbl IN SYSTEM.pa_num_tbl_type := prm_empty_num_tbl
2463: ,p_approver1_name_tbl IN SYSTEM.pa_varchar2_240_tbl_type := prm_empty_varchar2_240_tbl
2464: ,p_approver2_id_tbl IN SYSTEM.pa_num_tbl_type := prm_empty_num_tbl
2465: ,p_approver2_name_tbl IN SYSTEM.pa_varchar2_240_tbl_type := prm_empty_varchar2_240_tbl
2466: ,p_appr_over_auth_flag IN VARCHAR2 := 'N'
2467: ,p_note_to_all_approvers IN VARCHAR2 := FND_API.G_MISS_CHAR

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

2461: ,p_num_of_shift IN NUMBER := FND_API.G_MISS_NUM
2462: ,p_approver1_id_tbl IN SYSTEM.pa_num_tbl_type := prm_empty_num_tbl
2463: ,p_approver1_name_tbl IN SYSTEM.pa_varchar2_240_tbl_type := prm_empty_varchar2_240_tbl
2464: ,p_approver2_id_tbl IN SYSTEM.pa_num_tbl_type := prm_empty_num_tbl
2465: ,p_approver2_name_tbl IN SYSTEM.pa_varchar2_240_tbl_type := prm_empty_varchar2_240_tbl
2466: ,p_appr_over_auth_flag IN VARCHAR2 := 'N'
2467: ,p_note_to_all_approvers IN VARCHAR2 := FND_API.G_MISS_CHAR
2468: ,p_competence_id_tbl IN SYSTEM.pa_num_tbl_type := prm_empty_num_tbl
2469: ,p_competence_name_tbl IN SYSTEM.pa_varchar2_240_tbl_type := prm_empty_varchar2_240_tbl

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

2465: ,p_approver2_name_tbl IN SYSTEM.pa_varchar2_240_tbl_type := prm_empty_varchar2_240_tbl
2466: ,p_appr_over_auth_flag IN VARCHAR2 := 'N'
2467: ,p_note_to_all_approvers IN VARCHAR2 := FND_API.G_MISS_CHAR
2468: ,p_competence_id_tbl IN SYSTEM.pa_num_tbl_type := prm_empty_num_tbl
2469: ,p_competence_name_tbl IN SYSTEM.pa_varchar2_240_tbl_type := prm_empty_varchar2_240_tbl
2470: ,p_competence_alias_tbl IN SYSTEM.pa_varchar2_30_tbl_type := prm_empty_varchar2_30_tbl
2471: ,p_rating_level_id_tbl IN SYSTEM.pa_num_tbl_type := prm_empty_num_tbl
2472: ,p_mandatory_flag_tbl IN SYSTEM.pa_varchar2_1_tbl_type := prm_empty_varchar2_1_tbl
2473: ,p_resolve_con_action_code IN VARCHAR2 := FND_API.G_MISS_CHAR

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

2754: ( p_project_id IN pa_project_assignments.project_id%TYPE := FND_API.G_MISS_NUM
2755: ,p_mode IN VARCHAR2
2756: ,p_assignment_id_tbl IN SYSTEM.pa_num_tbl_type := prm_empty_num_tbl
2757: ,p_approver1_id_tbl IN SYSTEM.pa_num_tbl_type := prm_empty_num_tbl
2758: ,p_approver1_name_tbl IN SYSTEM.pa_varchar2_240_tbl_type := prm_empty_varchar2_240_tbl
2759: ,p_approver2_id_tbl IN SYSTEM.pa_num_tbl_type := prm_empty_num_tbl
2760: ,p_approver2_name_tbl IN SYSTEM.pa_varchar2_240_tbl_type := prm_empty_varchar2_240_tbl
2761: ,p_overriding_authority_flag IN VARCHAR2 := 'N'
2762: ,p_submitter_user_id IN NUMBER := FND_API.G_MISS_NUM

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

2756: ,p_assignment_id_tbl IN SYSTEM.pa_num_tbl_type := prm_empty_num_tbl
2757: ,p_approver1_id_tbl IN SYSTEM.pa_num_tbl_type := prm_empty_num_tbl
2758: ,p_approver1_name_tbl IN SYSTEM.pa_varchar2_240_tbl_type := prm_empty_varchar2_240_tbl
2759: ,p_approver2_id_tbl IN SYSTEM.pa_num_tbl_type := prm_empty_num_tbl
2760: ,p_approver2_name_tbl IN SYSTEM.pa_varchar2_240_tbl_type := prm_empty_varchar2_240_tbl
2761: ,p_overriding_authority_flag IN VARCHAR2 := 'N'
2762: ,p_submitter_user_id IN NUMBER := FND_API.G_MISS_NUM
2763: ,p_note_to_all_approvers IN VARCHAR2 := FND_API.G_MISS_CHAR
2764: ,p_conflict_group_id IN NUMBER := FND_API.G_MISS_NUM

Line 2786: l_approver1_name_tbl SYSTEM.pa_varchar2_240_tbl_type;

2782: l_msg_data VARCHAR2(2000);
2783: l_data VARCHAR2(2000);
2784: l_assignment_status VARCHAR2(10) := PA_ASSIGNMENT_APPROVAL_PUB.g_submit_action;
2785: l_approver1_id_tbl SYSTEM.pa_num_tbl_type;
2786: l_approver1_name_tbl SYSTEM.pa_varchar2_240_tbl_type;
2787: l_approver2_id_tbl SYSTEM.pa_num_tbl_type;
2788: l_approver2_name_tbl SYSTEM.pa_varchar2_240_tbl_type;
2789: l_assignment_id_tbl SYSTEM.pa_num_tbl_type;
2790: l_apr1_res_auth VARCHAR2(1) := 'Y';

Line 2788: l_approver2_name_tbl SYSTEM.pa_varchar2_240_tbl_type;

2784: l_assignment_status VARCHAR2(10) := PA_ASSIGNMENT_APPROVAL_PUB.g_submit_action;
2785: l_approver1_id_tbl SYSTEM.pa_num_tbl_type;
2786: l_approver1_name_tbl SYSTEM.pa_varchar2_240_tbl_type;
2787: l_approver2_id_tbl SYSTEM.pa_num_tbl_type;
2788: l_approver2_name_tbl SYSTEM.pa_varchar2_240_tbl_type;
2789: l_assignment_id_tbl SYSTEM.pa_num_tbl_type;
2790: l_apr1_res_auth VARCHAR2(1) := 'Y';
2791: l_apr2_res_auth VARCHAR2(1) := 'Y';
2792: l_new_asgmt_flag VARCHAR2(1);

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

4041: PROCEDURE validate_approver_name_id
4042: ( p_project_id IN NUMBER
4043: ,p_assignment_id_tbl IN SYSTEM.pa_num_tbl_type := prm_empty_num_tbl
4044: ,p_approver1_id_tbl IN SYSTEM.pa_num_tbl_type := prm_empty_num_tbl
4045: ,p_approver1_name_tbl IN SYSTEM.pa_varchar2_240_tbl_type := prm_empty_varchar2_240_tbl
4046: ,p_approver2_id_tbl IN SYSTEM.pa_num_tbl_type := prm_empty_num_tbl
4047: ,p_approver2_name_tbl IN SYSTEM.pa_varchar2_240_tbl_type := prm_empty_varchar2_240_tbl
4048: ,p_submitter_user_id IN NUMBER
4049: ,p_group_id IN NUMBER

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

4043: ,p_assignment_id_tbl IN SYSTEM.pa_num_tbl_type := prm_empty_num_tbl
4044: ,p_approver1_id_tbl IN SYSTEM.pa_num_tbl_type := prm_empty_num_tbl
4045: ,p_approver1_name_tbl IN SYSTEM.pa_varchar2_240_tbl_type := prm_empty_varchar2_240_tbl
4046: ,p_approver2_id_tbl IN SYSTEM.pa_num_tbl_type := prm_empty_num_tbl
4047: ,p_approver2_name_tbl IN SYSTEM.pa_varchar2_240_tbl_type := prm_empty_varchar2_240_tbl
4048: ,p_submitter_user_id IN NUMBER
4049: ,p_group_id IN NUMBER
4050: ,p_api_version IN NUMBER := 1.0
4051: ,p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE