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 PSP_EFF_REPORT_DETAILS_S

Line 833: psp_eff_report_details_s.nextval,

829: created_by,
830: creation_date)
831: values
832: (
833: psp_eff_report_details_s.nextval,
834: 1,
835: 1,
836: det_assignment_id(i),
837: det_segment1(i),

Line 897: update psp_eff_report_details set effort_report_id =

893: IF p_supercede_mode is not null THEN
894: hr_utility.trace(' psp_create_eff_reports--> updating erd count ='|| effort_det_lines_rec.effort_report_detail_id.count ||' min_effort_Report_id = '||min_effort_report_id );
895:
896: FORALL i in 1..effort_det_lines_rec.effort_report_detail_id.count
897: update psp_eff_report_details set effort_report_id =
898: (select effort_report_id from psp_eff_reports where
899: person_id =effort_Det_lines_rec.person_id(i) and status_code = 'T'
900: and request_id = l_request_id ) where
901: effort_report_detail_id= effort_det_lines_rec.effort_report_detail_id(i) ;

Line 906: update psp_eff_report_details set effort_report_id =

902:
903: ELSE
904:
905: FORALL i in 1..effort_det_lines_rec.effort_report_detail_id.count
906: update psp_eff_report_details set effort_report_id =
907: (select effort_report_id from psp_eff_reports where
908: person_id =effort_Det_lines_rec.person_id(i) and effort_report_id > min_effort_report_id ) where
909: effort_report_detail_id= effort_det_lines_rec.effort_report_detail_id(i) ;
910:

Line 982: update psp_Eff_report_details set payroll_percent = decode(person_rec.sum_tot(i),0,0,round( ((actual_salary_amt * 100) / person_rec.sum_tot(i)),2))

978:
979: hr_utility.trace('psp_create_eff_reports--> After getting sum');
980:
981: FORALL i in 1..person_rec.array_assignment_id.count
982: update psp_Eff_report_details set payroll_percent = decode(person_rec.sum_tot(i),0,0,round( ((actual_salary_amt * 100) / person_rec.sum_tot(i)),2))
983: where effort_report_id = person_rec.array_effort_report_id(i)
984: and assignment_id = person_rec.array_assignment_id(i);
985:
986:

Line 1000: update psp_eff_report_details set payroll_percent = payroll_percent + (100.00 - person_rec.payroll_percent_tot(i))

996:
997: hr_utility.trace('psp_create_eff_reports--> After sum payroll percent');
998:
999: FORALL i in 1..person_rec.array_assignment_id.count
1000: update psp_eff_report_details set payroll_percent = payroll_percent + (100.00 - person_rec.payroll_percent_tot(i))
1001: where effort_report_detail_id in (
1002: select max(effort_report_detail_id)
1003: from psp_eff_report_details
1004: where effort_report_id = person_rec.array_effort_report_id(i)

Line 1019: -- update psp_Eff_report_details set payroll_percent = round(actual_salary_amt/person_rec.sum_tot(i),2)*100 where effort_report_id =

1015:
1016: --- fnd_file.put_line(fnd_file.log,' after getting sum ');
1017:
1018: FORALL i in 1..person_rec.array_effort_report_id.count
1019: -- update psp_Eff_report_details set payroll_percent = round(actual_salary_amt/person_rec.sum_tot(i),2)*100 where effort_report_id =
1020: -- person_rec.array_effort_report_id(i);
1021: -- check for zero sum , flag error if so
1022: update psp_Eff_report_details set payroll_percent = decode(person_rec.sum_tot(i),0,0,round( ((actual_salary_amt * 100) / person_rec.sum_tot(i)),2)) where effort_report_id =
1023: person_rec.array_effort_report_id(i);

Line 1022: update psp_Eff_report_details set payroll_percent = decode(person_rec.sum_tot(i),0,0,round( ((actual_salary_amt * 100) / person_rec.sum_tot(i)),2)) where effort_report_id =

1018: FORALL i in 1..person_rec.array_effort_report_id.count
1019: -- update psp_Eff_report_details set payroll_percent = round(actual_salary_amt/person_rec.sum_tot(i),2)*100 where effort_report_id =
1020: -- person_rec.array_effort_report_id(i);
1021: -- check for zero sum , flag error if so
1022: update psp_Eff_report_details set payroll_percent = decode(person_rec.sum_tot(i),0,0,round( ((actual_salary_amt * 100) / person_rec.sum_tot(i)),2)) where effort_report_id =
1023: person_rec.array_effort_report_id(i);
1024:
1025: person_rec.array_effort_report_id.delete;
1026: person_rec.sum_tot.delete;

Line 1035: update psp_eff_report_details set payroll_percent = payroll_percent + (100.00 - person_rec.payroll_percent_tot(i)) where

1031: from psp_eff_report_details where effort_report_id > min_effort_report_id group by effort_report_id ;
1032:
1033:
1034: FORALL i in 1..person_rec.array_effort_report_id.count
1035: update psp_eff_report_details set payroll_percent = payroll_percent + (100.00 - person_rec.payroll_percent_tot(i)) where
1036: effort_report_detail_id in (select max(effort_report_detail_id) from psp_eff_report_details where
1037: effort_report_id = person_rec.array_effort_report_id(i) and person_rec.payroll_percent_tot(i)<>0) ;
1038: END IF;
1039:

Line 1078: update psp_eff_report_details set payroll_percent = payroll_percent + (100.00 - person_rec.payroll_percent_tot(i)) where

1074:
1075: -- OHSU Changes
1076: /*
1077: FORALL i in 1..person_rec.array_effort_report_id.count
1078: update psp_eff_report_details set payroll_percent = payroll_percent + (100.00 - person_rec.payroll_percent_tot(i)) where
1079: effort_report_detail_id in (select max(effort_report_detail_id) from psp_eff_report_details where
1080: effort_report_id = person_rec.array_effort_report_id(i) and person_rec.payroll_percent_tot(i)<>0) ;
1081: */
1082: