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 831: psp_eff_report_details_s.nextval,

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

Line 895: update psp_eff_report_details set effort_report_id =

891: IF p_supercede_mode is not null THEN
892: 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 );
893:
894: FORALL i in 1..effort_det_lines_rec.effort_report_detail_id.count
895: update psp_eff_report_details set effort_report_id =
896: (select effort_report_id from psp_eff_reports where
897: person_id =effort_Det_lines_rec.person_id(i) and status_code = 'T'
898: and request_id = l_request_id ) where
899: effort_report_detail_id= effort_det_lines_rec.effort_report_detail_id(i) ;

Line 904: update psp_eff_report_details set effort_report_id =

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

Line 980: 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))

976:
977: hr_utility.trace('psp_create_eff_reports--> After getting sum');
978:
979: FORALL i in 1..person_rec.array_assignment_id.count
980: 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))
981: where effort_report_id = person_rec.array_effort_report_id(i)
982: and assignment_id = person_rec.array_assignment_id(i);
983:
984:

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

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

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

1013:
1014: --- fnd_file.put_line(fnd_file.log,' after getting sum ');
1015:
1016: FORALL i in 1..person_rec.array_effort_report_id.count
1017: -- update psp_Eff_report_details set payroll_percent = round(actual_salary_amt/person_rec.sum_tot(i),2)*100 where effort_report_id =
1018: -- person_rec.array_effort_report_id(i);
1019: -- check for zero sum , flag error if so
1020: 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 =
1021: person_rec.array_effort_report_id(i);

Line 1020: 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 =

1016: FORALL i in 1..person_rec.array_effort_report_id.count
1017: -- update psp_Eff_report_details set payroll_percent = round(actual_salary_amt/person_rec.sum_tot(i),2)*100 where effort_report_id =
1018: -- person_rec.array_effort_report_id(i);
1019: -- check for zero sum , flag error if so
1020: 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 =
1021: person_rec.array_effort_report_id(i);
1022:
1023: person_rec.array_effort_report_id.delete;
1024: person_rec.sum_tot.delete;

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

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

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

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