39:
40: type effort_sum_criteria_type is record
41: (
42: array_sum_criteria t_varchar_30_type := t_varchar_30_type(NULL),
43: array_sum_order t_num_15_type := t_num_15_type(NULL),
44: array_criteria_value1 t_varchar_30_type := t_varchar_30_type(NULL),
45: array_criteria_value2 t_varchar_30_type := t_varchar_30_type(NULL)
46:
47: );
50:
51:
52: type person_rec_type is record
53: (
54: person_id t_num_15_type := t_num_15_type(NULL)
55:
56: );
57:
58: person_array person_rec_type;
67:
68:
69: type person_eff_rec_type is record
70: (
71: array_person_id t_num_15_type := t_num_15_type(NULL) ,
72: array_effort_report_id t_num_15_type := t_num_15_type(NULL) ,
73: sum_tot t_num_15_2_type := t_num_15_2_type(NULL) ,
74: payroll_percent_tot t_num_15_2_type := t_num_15_2_type(NULL) ,
75: array_assignment_id t_num_15_type := t_num_15_type(NULL)
68:
69: type person_eff_rec_type is record
70: (
71: array_person_id t_num_15_type := t_num_15_type(NULL) ,
72: array_effort_report_id t_num_15_type := t_num_15_type(NULL) ,
73: sum_tot t_num_15_2_type := t_num_15_2_type(NULL) ,
74: payroll_percent_tot t_num_15_2_type := t_num_15_2_type(NULL) ,
75: array_assignment_id t_num_15_type := t_num_15_type(NULL)
76: );
71: array_person_id t_num_15_type := t_num_15_type(NULL) ,
72: array_effort_report_id t_num_15_type := t_num_15_type(NULL) ,
73: sum_tot t_num_15_2_type := t_num_15_2_type(NULL) ,
74: payroll_percent_tot t_num_15_2_type := t_num_15_2_type(NULL) ,
75: array_assignment_id t_num_15_type := t_num_15_type(NULL)
76: );
77:
78: person_rec person_eff_rec_type;
79: type details_array_rec_type is record
79: type details_array_rec_type is record
80:
81: (
82:
83: effort_report_detail_id t_num_15_type := t_num_15_type(NULL) ,
84: effort_report_id t_num_15_type := t_num_15_type(NULL)
85: );
86:
87: details_array details_array_rec_type;
80:
81: (
82:
83: effort_report_detail_id t_num_15_type := t_num_15_type(NULL) ,
84: effort_report_id t_num_15_type := t_num_15_type(NULL)
85: );
86:
87: details_array details_array_rec_type;
88:
85: );
86:
87: details_array details_array_rec_type;
88:
89: det_effort_report_id t_num_15_type := t_num_15_type(NULL) ;
90: det_effort_report_detail_id t_num_15_type := t_num_15_type(NULL);
91: det_person_id t_num_15_type := t_num_15_type(NULL) ;
92: det_segment1 t_varchar_25_type := t_varchar_25_type(NULL) ;
93: det_segment2 t_varchar_25_type := t_varchar_25_type(NULL) ;
86:
87: details_array details_array_rec_type;
88:
89: det_effort_report_id t_num_15_type := t_num_15_type(NULL) ;
90: det_effort_report_detail_id t_num_15_type := t_num_15_type(NULL);
91: det_person_id t_num_15_type := t_num_15_type(NULL) ;
92: det_segment1 t_varchar_25_type := t_varchar_25_type(NULL) ;
93: det_segment2 t_varchar_25_type := t_varchar_25_type(NULL) ;
94: det_segment3 t_varchar_25_type := t_varchar_25_type(NULL) ;
87: details_array details_array_rec_type;
88:
89: det_effort_report_id t_num_15_type := t_num_15_type(NULL) ;
90: det_effort_report_detail_id t_num_15_type := t_num_15_type(NULL);
91: det_person_id t_num_15_type := t_num_15_type(NULL) ;
92: det_segment1 t_varchar_25_type := t_varchar_25_type(NULL) ;
93: det_segment2 t_varchar_25_type := t_varchar_25_type(NULL) ;
94: det_segment3 t_varchar_25_type := t_varchar_25_type(NULL) ;
95: det_segment4 t_varchar_25_type := t_varchar_25_type(NULL) ;
118: det_segment27 t_varchar_25_type := t_varchar_25_type(NULL) ;
119: det_segment28 t_varchar_25_type := t_varchar_25_type(NULL) ;
120: det_segment29 t_varchar_25_type := t_varchar_25_type(NULL) ;
121: det_segment30 t_varchar_25_type := t_varchar_25_type(NULL) ;
122: det_assignment_id t_num_15_type := t_num_15_type(NULL);
123: det_project_id t_num_15_type := t_num_15_type(NULL) ;
124: det_exp_org_id t_num_15_type := t_num_15_type(NULL) ;
125: det_expenditure_type t_varchar_30_type := t_varchar_30_type(NULL);
126: det_task_id t_num_15_type := t_num_15_type(NULL) ;
119: det_segment28 t_varchar_25_type := t_varchar_25_type(NULL) ;
120: det_segment29 t_varchar_25_type := t_varchar_25_type(NULL) ;
121: det_segment30 t_varchar_25_type := t_varchar_25_type(NULL) ;
122: det_assignment_id t_num_15_type := t_num_15_type(NULL);
123: det_project_id t_num_15_type := t_num_15_type(NULL) ;
124: det_exp_org_id t_num_15_type := t_num_15_type(NULL) ;
125: det_expenditure_type t_varchar_30_type := t_varchar_30_type(NULL);
126: det_task_id t_num_15_type := t_num_15_type(NULL) ;
127: det_award_id t_num_15_type := t_num_15_type(NULL) ;
120: det_segment29 t_varchar_25_type := t_varchar_25_type(NULL) ;
121: det_segment30 t_varchar_25_type := t_varchar_25_type(NULL) ;
122: det_assignment_id t_num_15_type := t_num_15_type(NULL);
123: det_project_id t_num_15_type := t_num_15_type(NULL) ;
124: det_exp_org_id t_num_15_type := t_num_15_type(NULL) ;
125: det_expenditure_type t_varchar_30_type := t_varchar_30_type(NULL);
126: det_task_id t_num_15_type := t_num_15_type(NULL) ;
127: det_award_id t_num_15_type := t_num_15_type(NULL) ;
128: det_distribution_amount t_num_15_2_type := t_num_15_2_type(NULL);
122: det_assignment_id t_num_15_type := t_num_15_type(NULL);
123: det_project_id t_num_15_type := t_num_15_type(NULL) ;
124: det_exp_org_id t_num_15_type := t_num_15_type(NULL) ;
125: det_expenditure_type t_varchar_30_type := t_varchar_30_type(NULL);
126: det_task_id t_num_15_type := t_num_15_type(NULL) ;
127: det_award_id t_num_15_type := t_num_15_type(NULL) ;
128: det_distribution_amount t_num_15_2_type := t_num_15_2_type(NULL);
129: det_sum_amount t_number_type := t_number_type(NULL) ;
130: det_dr_cr_flag t_varchar_1_type := t_varchar_1_type(NULL);
123: det_project_id t_num_15_type := t_num_15_type(NULL) ;
124: det_exp_org_id t_num_15_type := t_num_15_type(NULL) ;
125: det_expenditure_type t_varchar_30_type := t_varchar_30_type(NULL);
126: det_task_id t_num_15_type := t_num_15_type(NULL) ;
127: det_award_id t_num_15_type := t_num_15_type(NULL) ;
128: det_distribution_amount t_num_15_2_type := t_num_15_2_type(NULL);
129: det_sum_amount t_number_type := t_number_type(NULL) ;
130: det_dr_cr_flag t_varchar_1_type := t_varchar_1_type(NULL);
131: det_schedule_start_date t_date_type := t_date_type(NULL) ;
133:
134:
135: type eff_det_lines_type is record
136: (
137: effort_report_detail_id t_num_15_type := t_num_15_type(NULL) ,
138: person_id t_num_15_type := t_num_15_type(NULL)
139: );
140:
141: -- for supercede
134:
135: type eff_det_lines_type is record
136: (
137: effort_report_detail_id t_num_15_type := t_num_15_type(NULL) ,
138: person_id t_num_15_type := t_num_15_type(NULL)
139: );
140:
141: -- for supercede
142: g_summarization_criteria varchar2(2000);