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_MASS_ASGMT_TRX dependencies on PA_VARCHAR2_240_TBL_TYPE

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

95: ,p_duration_shift_type_code IN VARCHAR2 := FND_API.G_MISS_CHAR
96: ,p_duration_shift_unit_code IN VARCHAR2 := FND_API.G_MISS_CHAR
97: ,p_num_of_shift IN NUMBER := FND_API.G_MISS_NUM
98: ,p_approver1_id_tbl IN SYSTEM.pa_num_tbl_type := pa_empty_num_tbl
99: ,p_approver1_name_tbl IN SYSTEM.pa_varchar2_240_tbl_type := pa_empty_varchar2_240_tbl
100: ,p_approver2_id_tbl IN SYSTEM.pa_num_tbl_type := pa_empty_num_tbl
101: ,p_approver2_name_tbl IN SYSTEM.pa_varchar2_240_tbl_type := pa_empty_varchar2_240_tbl
102: ,p_appr_over_auth_flag IN VARCHAR2 := FND_API.G_MISS_CHAR
103: ,p_note_to_all_approvers IN VARCHAR2 := FND_API.G_MISS_CHAR

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

97: ,p_num_of_shift IN NUMBER := FND_API.G_MISS_NUM
98: ,p_approver1_id_tbl IN SYSTEM.pa_num_tbl_type := pa_empty_num_tbl
99: ,p_approver1_name_tbl IN SYSTEM.pa_varchar2_240_tbl_type := pa_empty_varchar2_240_tbl
100: ,p_approver2_id_tbl IN SYSTEM.pa_num_tbl_type := pa_empty_num_tbl
101: ,p_approver2_name_tbl IN SYSTEM.pa_varchar2_240_tbl_type := pa_empty_varchar2_240_tbl
102: ,p_appr_over_auth_flag IN VARCHAR2 := FND_API.G_MISS_CHAR
103: ,p_note_to_all_approvers IN VARCHAR2 := FND_API.G_MISS_CHAR
104: ,p_competence_id_tbl IN SYSTEM.pa_num_tbl_type := pa_empty_num_tbl
105: ,p_competence_name_tbl IN SYSTEM.pa_varchar2_240_tbl_type := pa_empty_varchar2_240_tbl

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

101: ,p_approver2_name_tbl IN SYSTEM.pa_varchar2_240_tbl_type := pa_empty_varchar2_240_tbl
102: ,p_appr_over_auth_flag IN VARCHAR2 := FND_API.G_MISS_CHAR
103: ,p_note_to_all_approvers IN VARCHAR2 := FND_API.G_MISS_CHAR
104: ,p_competence_id_tbl IN SYSTEM.pa_num_tbl_type := pa_empty_num_tbl
105: ,p_competence_name_tbl IN SYSTEM.pa_varchar2_240_tbl_type := pa_empty_varchar2_240_tbl
106: ,p_competence_alias_tbl IN SYSTEM.pa_varchar2_30_tbl_type := pa_empty_varchar2_30_tbl
107: ,p_rating_level_id_tbl IN SYSTEM.pa_num_tbl_type := pa_empty_num_tbl
108: ,p_mandatory_flag_tbl IN SYSTEM.pa_varchar2_1_tbl_type := pa_empty_varchar2_1_tbl
109: ,p_resolve_con_action_code IN VARCHAR2 := FND_API.G_MISS_CHAR

Line 140: l_approver1_name_tbl SYSTEM.pa_varchar2_240_tbl_type := SYSTEM.pa_varchar2_240_tbl_type();

136: l_err_stage VARCHAR2(2000);
137: l_err_stack VARCHAR2(2000);
138: l_object_id_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
139: l_approver1_id_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
140: l_approver1_name_tbl SYSTEM.pa_varchar2_240_tbl_type := SYSTEM.pa_varchar2_240_tbl_type();
141: l_approver2_id_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
142: l_approver2_name_tbl SYSTEM.pa_varchar2_240_tbl_type := SYSTEM.pa_varchar2_240_tbl_type();
143: l_project_id pa_projects_all.project_id%TYPE;
144: l_fcst_tp_amount_type_name VARCHAR2(80);

Line 142: l_approver2_name_tbl SYSTEM.pa_varchar2_240_tbl_type := SYSTEM.pa_varchar2_240_tbl_type();

138: l_object_id_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
139: l_approver1_id_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
140: l_approver1_name_tbl SYSTEM.pa_varchar2_240_tbl_type := SYSTEM.pa_varchar2_240_tbl_type();
141: l_approver2_id_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
142: l_approver2_name_tbl SYSTEM.pa_varchar2_240_tbl_type := SYSTEM.pa_varchar2_240_tbl_type();
143: l_project_id pa_projects_all.project_id%TYPE;
144: l_fcst_tp_amount_type_name VARCHAR2(80);
145: /* Commented for bug 9114634
146: ----Added following folloeing for bug 6199871 ------------------------

Line 1383: l_competence_name_tbl SYSTEM.pa_varchar2_240_tbl_type := SYSTEM.pa_varchar2_240_tbl_type();

1379: l_failure_assignments_link VARCHAR2(2000);
1380: l_assignment_duration NUMBER;
1381: l_competence_id_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
1382: l_competence_alias_tbl SYSTEM.pa_varchar2_30_tbl_type := SYSTEM.pa_varchar2_30_tbl_type();
1383: l_competence_name_tbl SYSTEM.pa_varchar2_240_tbl_type := SYSTEM.pa_varchar2_240_tbl_type();
1384: l_rating_level_id_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
1385: l_mandatory_flag_tbl SYSTEM.pa_varchar2_1_tbl_type := SYSTEM.pa_varchar2_1_tbl_type() ;
1386: l_extension_possible_meaning fnd_lookups.meaning%TYPE;
1387: l_mandatory_flag_meaning fnd_lookups.meaning%TYPE;

Line 2578: l_approver1_name_tbl SYSTEM.pa_varchar2_240_tbl_type := SYSTEM.pa_varchar2_240_tbl_type();

2574: l_mode VARCHAR2(30);
2575: l_action VARCHAR2(30);
2576: l_approver1_id_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
2577: l_approver2_id_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
2578: l_approver1_name_tbl SYSTEM.pa_varchar2_240_tbl_type := SYSTEM.pa_varchar2_240_tbl_type();
2579: l_approver2_name_tbl SYSTEM.pa_varchar2_240_tbl_type := SYSTEM.pa_varchar2_240_tbl_type();
2580: l_appr_over_auth_flag VARCHAR2(1);
2581: l_note_to_all_approvers VARCHAR2(2000);
2582: l_conflict_group_id NUMBER;

Line 2579: l_approver2_name_tbl SYSTEM.pa_varchar2_240_tbl_type := SYSTEM.pa_varchar2_240_tbl_type();

2575: l_action VARCHAR2(30);
2576: l_approver1_id_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
2577: l_approver2_id_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
2578: l_approver1_name_tbl SYSTEM.pa_varchar2_240_tbl_type := SYSTEM.pa_varchar2_240_tbl_type();
2579: l_approver2_name_tbl SYSTEM.pa_varchar2_240_tbl_type := SYSTEM.pa_varchar2_240_tbl_type();
2580: l_appr_over_auth_flag VARCHAR2(1);
2581: l_note_to_all_approvers VARCHAR2(2000);
2582: l_conflict_group_id NUMBER;
2583: l_return_status VARCHAR2(1);