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 2401: ,p_approver1_name_tbl IN SYSTEM.pa_varchar2_240_tbl_type := prm_empty_varchar2_240_tbl

2397: PROCEDURE validate_approver_name_id
2398: ( p_project_id IN NUMBER
2399: ,p_assignment_id_tbl IN SYSTEM.pa_num_tbl_type := prm_empty_num_tbl
2400: ,p_approver1_id_tbl IN SYSTEM.pa_num_tbl_type := prm_empty_num_tbl
2401: ,p_approver1_name_tbl IN SYSTEM.pa_varchar2_240_tbl_type := prm_empty_varchar2_240_tbl
2402: ,p_approver2_id_tbl IN SYSTEM.pa_num_tbl_type := prm_empty_num_tbl
2403: ,p_approver2_name_tbl IN SYSTEM.pa_varchar2_240_tbl_type := prm_empty_varchar2_240_tbl
2404: ,p_submitter_user_id IN NUMBER
2405: ,p_group_id IN NUMBER

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

2399: ,p_assignment_id_tbl IN SYSTEM.pa_num_tbl_type := prm_empty_num_tbl
2400: ,p_approver1_id_tbl IN SYSTEM.pa_num_tbl_type := prm_empty_num_tbl
2401: ,p_approver1_name_tbl IN SYSTEM.pa_varchar2_240_tbl_type := prm_empty_varchar2_240_tbl
2402: ,p_approver2_id_tbl IN SYSTEM.pa_num_tbl_type := prm_empty_num_tbl
2403: ,p_approver2_name_tbl IN SYSTEM.pa_varchar2_240_tbl_type := prm_empty_varchar2_240_tbl
2404: ,p_submitter_user_id IN NUMBER
2405: ,p_group_id IN NUMBER
2406: ,p_api_version IN NUMBER := 1.0
2407: ,p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE

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

2520: ,p_duration_shift_type_code IN VARCHAR2 := FND_API.G_MISS_CHAR
2521: ,p_duration_shift_unit_code IN VARCHAR2 := FND_API.G_MISS_CHAR
2522: ,p_num_of_shift IN NUMBER := FND_API.G_MISS_NUM
2523: ,p_approver1_id_tbl IN SYSTEM.pa_num_tbl_type := prm_empty_num_tbl
2524: ,p_approver1_name_tbl IN SYSTEM.pa_varchar2_240_tbl_type := prm_empty_varchar2_240_tbl
2525: ,p_approver2_id_tbl IN SYSTEM.pa_num_tbl_type := prm_empty_num_tbl
2526: ,p_approver2_name_tbl IN SYSTEM.pa_varchar2_240_tbl_type := prm_empty_varchar2_240_tbl
2527: ,p_appr_over_auth_flag IN VARCHAR2 := 'N'
2528: ,p_note_to_all_approvers IN VARCHAR2 := FND_API.G_MISS_CHAR

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

2522: ,p_num_of_shift IN NUMBER := FND_API.G_MISS_NUM
2523: ,p_approver1_id_tbl IN SYSTEM.pa_num_tbl_type := prm_empty_num_tbl
2524: ,p_approver1_name_tbl IN SYSTEM.pa_varchar2_240_tbl_type := prm_empty_varchar2_240_tbl
2525: ,p_approver2_id_tbl IN SYSTEM.pa_num_tbl_type := prm_empty_num_tbl
2526: ,p_approver2_name_tbl IN SYSTEM.pa_varchar2_240_tbl_type := prm_empty_varchar2_240_tbl
2527: ,p_appr_over_auth_flag IN VARCHAR2 := 'N'
2528: ,p_note_to_all_approvers IN VARCHAR2 := FND_API.G_MISS_CHAR
2529: ,p_competence_id_tbl IN SYSTEM.pa_num_tbl_type := prm_empty_num_tbl
2530: ,p_competence_name_tbl IN SYSTEM.pa_varchar2_240_tbl_type := prm_empty_varchar2_240_tbl

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

2526: ,p_approver2_name_tbl IN SYSTEM.pa_varchar2_240_tbl_type := prm_empty_varchar2_240_tbl
2527: ,p_appr_over_auth_flag IN VARCHAR2 := 'N'
2528: ,p_note_to_all_approvers IN VARCHAR2 := FND_API.G_MISS_CHAR
2529: ,p_competence_id_tbl IN SYSTEM.pa_num_tbl_type := prm_empty_num_tbl
2530: ,p_competence_name_tbl IN SYSTEM.pa_varchar2_240_tbl_type := prm_empty_varchar2_240_tbl
2531: ,p_competence_alias_tbl IN SYSTEM.pa_varchar2_30_tbl_type := prm_empty_varchar2_30_tbl
2532: ,p_rating_level_id_tbl IN SYSTEM.pa_num_tbl_type := prm_empty_num_tbl
2533: ,p_mandatory_flag_tbl IN SYSTEM.pa_varchar2_1_tbl_type := prm_empty_varchar2_1_tbl
2534: ,p_resolve_con_action_code IN VARCHAR2 := FND_API.G_MISS_CHAR

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

2815: ( p_project_id IN pa_project_assignments.project_id%TYPE := FND_API.G_MISS_NUM
2816: ,p_mode IN VARCHAR2
2817: ,p_assignment_id_tbl IN SYSTEM.pa_num_tbl_type := prm_empty_num_tbl
2818: ,p_approver1_id_tbl IN SYSTEM.pa_num_tbl_type := prm_empty_num_tbl
2819: ,p_approver1_name_tbl IN SYSTEM.pa_varchar2_240_tbl_type := prm_empty_varchar2_240_tbl
2820: ,p_approver2_id_tbl IN SYSTEM.pa_num_tbl_type := prm_empty_num_tbl
2821: ,p_approver2_name_tbl IN SYSTEM.pa_varchar2_240_tbl_type := prm_empty_varchar2_240_tbl
2822: ,p_overriding_authority_flag IN VARCHAR2 := 'N'
2823: ,p_submitter_user_id IN NUMBER := FND_API.G_MISS_NUM

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

2817: ,p_assignment_id_tbl IN SYSTEM.pa_num_tbl_type := prm_empty_num_tbl
2818: ,p_approver1_id_tbl IN SYSTEM.pa_num_tbl_type := prm_empty_num_tbl
2819: ,p_approver1_name_tbl IN SYSTEM.pa_varchar2_240_tbl_type := prm_empty_varchar2_240_tbl
2820: ,p_approver2_id_tbl IN SYSTEM.pa_num_tbl_type := prm_empty_num_tbl
2821: ,p_approver2_name_tbl IN SYSTEM.pa_varchar2_240_tbl_type := prm_empty_varchar2_240_tbl
2822: ,p_overriding_authority_flag IN VARCHAR2 := 'N'
2823: ,p_submitter_user_id IN NUMBER := FND_API.G_MISS_NUM
2824: ,p_note_to_all_approvers IN VARCHAR2 := FND_API.G_MISS_CHAR
2825: ,p_conflict_group_id IN NUMBER := FND_API.G_MISS_NUM

Line 2847: l_approver1_name_tbl SYSTEM.pa_varchar2_240_tbl_type;

2843: l_msg_data VARCHAR2(2000);
2844: l_data VARCHAR2(2000);
2845: l_assignment_status VARCHAR2(10) := PA_ASSIGNMENT_APPROVAL_PUB.g_submit_action;
2846: l_approver1_id_tbl SYSTEM.pa_num_tbl_type;
2847: l_approver1_name_tbl SYSTEM.pa_varchar2_240_tbl_type;
2848: l_approver2_id_tbl SYSTEM.pa_num_tbl_type;
2849: l_approver2_name_tbl SYSTEM.pa_varchar2_240_tbl_type;
2850: l_assignment_id_tbl SYSTEM.pa_num_tbl_type;
2851: l_apr1_res_auth VARCHAR2(1) := 'Y';

Line 2849: l_approver2_name_tbl SYSTEM.pa_varchar2_240_tbl_type;

2845: l_assignment_status VARCHAR2(10) := PA_ASSIGNMENT_APPROVAL_PUB.g_submit_action;
2846: l_approver1_id_tbl SYSTEM.pa_num_tbl_type;
2847: l_approver1_name_tbl SYSTEM.pa_varchar2_240_tbl_type;
2848: l_approver2_id_tbl SYSTEM.pa_num_tbl_type;
2849: l_approver2_name_tbl SYSTEM.pa_varchar2_240_tbl_type;
2850: l_assignment_id_tbl SYSTEM.pa_num_tbl_type;
2851: l_apr1_res_auth VARCHAR2(1) := 'Y';
2852: l_apr2_res_auth VARCHAR2(1) := 'Y';
2853: l_new_asgmt_flag VARCHAR2(1);

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

4106: PROCEDURE validate_approver_name_id
4107: ( p_project_id IN NUMBER
4108: ,p_assignment_id_tbl IN SYSTEM.pa_num_tbl_type := prm_empty_num_tbl
4109: ,p_approver1_id_tbl IN SYSTEM.pa_num_tbl_type := prm_empty_num_tbl
4110: ,p_approver1_name_tbl IN SYSTEM.pa_varchar2_240_tbl_type := prm_empty_varchar2_240_tbl
4111: ,p_approver2_id_tbl IN SYSTEM.pa_num_tbl_type := prm_empty_num_tbl
4112: ,p_approver2_name_tbl IN SYSTEM.pa_varchar2_240_tbl_type := prm_empty_varchar2_240_tbl
4113: ,p_submitter_user_id IN NUMBER
4114: ,p_group_id IN NUMBER

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

4108: ,p_assignment_id_tbl IN SYSTEM.pa_num_tbl_type := prm_empty_num_tbl
4109: ,p_approver1_id_tbl IN SYSTEM.pa_num_tbl_type := prm_empty_num_tbl
4110: ,p_approver1_name_tbl IN SYSTEM.pa_varchar2_240_tbl_type := prm_empty_varchar2_240_tbl
4111: ,p_approver2_id_tbl IN SYSTEM.pa_num_tbl_type := prm_empty_num_tbl
4112: ,p_approver2_name_tbl IN SYSTEM.pa_varchar2_240_tbl_type := prm_empty_varchar2_240_tbl
4113: ,p_submitter_user_id IN NUMBER
4114: ,p_group_id IN NUMBER
4115: ,p_api_version IN NUMBER := 1.0
4116: ,p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE