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.PSP_CREATE_EFF_REPORTS dependencies on T_NUM_15_TYPE

Line 43: array_sum_order t_num_15_type := t_num_15_type(NULL),

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: );

Line 54: person_id t_num_15_type := t_num_15_type(NULL)

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;

Line 71: array_person_id t_num_15_type := t_num_15_type(NULL) ,

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)

Line 72: array_effort_report_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: );

Line 75: array_assignment_id t_num_15_type := t_num_15_type(NULL)

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

Line 83: effort_report_detail_id t_num_15_type := t_num_15_type(NULL) ,

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;

Line 84: effort_report_id t_num_15_type := t_num_15_type(NULL)

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:

Line 89: det_effort_report_id t_num_15_type := t_num_15_type(NULL) ;

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) ;

Line 90: det_effort_report_detail_id t_num_15_type := t_num_15_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) ;

Line 91: det_person_id t_num_15_type := t_num_15_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) ;

Line 122: det_assignment_id t_num_15_type := t_num_15_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) ;

Line 123: det_project_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) ;

Line 124: det_exp_org_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);

Line 126: det_task_id t_num_15_type := t_num_15_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);

Line 127: det_award_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);
131: det_schedule_start_date t_date_type := t_date_type(NULL) ;

Line 137: effort_report_detail_id t_num_15_type := t_num_15_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

Line 138: person_id t_num_15_type := t_num_15_type(NULL)

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);