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

Line 492: psp_eff_report_details erd

488: */
489: insert into psp_selected_persons_t (request_id, person_id, assignment_id)
490: select -1 * l_request_id, person_id, assignment_id
491: from psp_Eff_reports er,
492: psp_eff_report_details erd
493: where er.effort_Report_id = erd.effort_Report_id
494: and er.request_id = l_request_id
495: and er.status_code in ('N','A')
496: and er.person_id in (select person_id from psp_supercede_persons_gt where person_id > 0) ;

Line 775: -- fnd_file.put_line(fnd_file.log,' =====inserting in psp_eff_report_details ');

771:
772:
773: -- fnd_file.put_line(fnd_file.log,' before inserting into psp_report_details ');
774:
775: -- fnd_file.put_line(fnd_file.log,' =====inserting in psp_eff_report_details ');
776:
777: hr_utility.trace('psp_create_eff_reports--> before inserting into details ');
778:
779: FORALL i in 1..det_person_id.count

Line 780: insert into psp_eff_report_details(

776:
777: hr_utility.trace('psp_create_eff_reports--> before inserting into details ');
778:
779: FORALL i in 1..det_person_id.count
780: insert into psp_eff_report_details(
781: effort_report_detail_id,
782: effort_report_id,
783: object_version_number,
784: assignment_id,

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 974: from psp_eff_report_details where

970: IF l_HUNDRED_PCENT_EFF_AT_PER_ASG = 'A' then
971:
972: select sum(actual_salary_amt), effort_report_id, assignment_id bulk collect
973: into person_rec.sum_tot, person_rec.array_effort_report_id, person_rec.array_assignment_id
974: from psp_eff_report_details where
975: effort_report_id > min_effort_report_id group by effort_report_id, assignment_id;
976:
977: hr_utility.trace('psp_create_eff_reports--> After getting sum');
978:

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 992: from psp_eff_report_details where effort_report_id > min_effort_report_id group by effort_report_id , assignment_id;

988:
989:
990: select sum(payroll_percent), effort_report_id, assignment_id bulk collect
991: into person_rec.payroll_percent_tot, person_rec.array_effort_report_id, person_rec.array_assignment_id
992: from psp_eff_report_details where effort_report_id > min_effort_report_id group by effort_report_id , assignment_id;
993:
994:
995: hr_utility.trace('psp_create_eff_reports--> After sum payroll percent');
996:

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 1001: from psp_eff_report_details

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)
1003: and person_rec.payroll_percent_tot(i)<>0 and
1004: assignment_id = person_rec.array_assignment_id(i)
1005: ) ;

Line 1009: from psp_eff_report_details where

1005: ) ;
1006: ELSE
1007:
1008: select sum(actual_salary_amt), effort_report_id bulk collect into person_rec.sum_tot, person_rec.array_effort_report_id
1009: from psp_eff_report_details where
1010: effort_report_id > min_effort_report_id group by effort_report_id ;
1011:
1012: hr_utility.trace('psp_create_eff_reports--> After getting sum');
1013:

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 1029: from psp_eff_report_details where effort_report_id > min_effort_report_id group by effort_report_id ;

1025:
1026:
1027: select sum(payroll_percent), effort_report_id
1028: bulk collect into person_rec.payroll_percent_tot, person_rec.array_effort_report_id
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

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 1034: effort_report_detail_id in (select max(effort_report_detail_id) from psp_eff_report_details where

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:
1038: -- fnd_file.put_line(fnd_file.log,' after getting sum ');

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:

Line 1077: effort_report_detail_id in (select max(effort_report_detail_id) from psp_eff_report_details where

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:
1081:

Line 1083: not exists (select 1 from psp_eff_report_details perd where

1079: */
1080:
1081:
1082: delete from psp_eff_reports per where effort_report_id > min_effort_report_id and
1083: not exists (select 1 from psp_eff_report_details perd where
1084: perd.effort_report_id = per.effort_report_id);
1085:
1086: -- fnd_file.put_line(fnd_file.log,' after delete of orphan record ');
1087:

Line 1113: -- psp_eff_report_details_api.update_eff_report_details(l_request_id);

1109:
1110:
1111: -- get cost share info
1112:
1113: -- psp_eff_report_details_api.update_eff_report_details(l_request_id);
1114:
1115: --psp_eff_report_details_api.update_eff_report_details(p_validate , l_request_id, p_warning );
1116: /* for Bug fix 4089645 Added Person id check */
1117: -- fnd_file.put_line(fnd_file.log,' ===== Populate_error_table');

Line 1115: --psp_eff_report_details_api.update_eff_report_details(p_validate , l_request_id, p_warning );

1111: -- get cost share info
1112:
1113: -- psp_eff_report_details_api.update_eff_report_details(l_request_id);
1114:
1115: --psp_eff_report_details_api.update_eff_report_details(p_validate , l_request_id, p_warning );
1116: /* for Bug fix 4089645 Added Person id check */
1117: -- fnd_file.put_line(fnd_file.log,' ===== Populate_error_table');
1118:
1119:

Line 1165: -- fnd_file.put_line(fnd_file.log,' ===== psp_eff_report_details_api.update_eff_report_details');

1161: p_print_header=>FND_API.G_TRUE);
1162: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1163:
1164: END IF;
1165: -- fnd_file.put_line(fnd_file.log,' ===== psp_eff_report_details_api.update_eff_report_details');
1166:
1167:
1168: psp_xmlgen.update_grouping_category(l_start_person, l_end_person, l_request_id, l_return_status) ;
1169:

Line 1177: -- fnd_file.put_line(fnd_file.log,' ===== psp_eff_report_details_api.update_eff_report_details');

1173: p_print_header=>FND_API.G_TRUE);
1174: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1175: END IF;
1176:
1177: -- fnd_file.put_line(fnd_file.log,' ===== psp_eff_report_details_api.update_eff_report_details');
1178:
1179: psp_eff_report_details_api.update_eff_report_details(p_validate , l_request_id,l_start_person, l_end_person, p_warning );
1180:
1181: -- Check weather Project, Task, Award, Exp Org are valid or not

Line 1179: psp_eff_report_details_api.update_eff_report_details(p_validate , l_request_id,l_start_person, l_end_person, p_warning );

1175: END IF;
1176:
1177: -- fnd_file.put_line(fnd_file.log,' ===== psp_eff_report_details_api.update_eff_report_details');
1178:
1179: psp_eff_report_details_api.update_eff_report_details(p_validate , l_request_id,l_start_person, l_end_person, p_warning );
1180:
1181: -- Check weather Project, Task, Award, Exp Org are valid or not
1182:
1183: VALIDATE_PTAOE(p_start_person => l_start_person,

Line 1366: from psp_eff_reports er, psp_eff_report_details erd

1362: where person_id between p_start_person and p_end_person
1363: and request_id = p_request_id
1364: and (person_id, assignment_id) in
1365: (select er.person_id, erd.assignment_id
1366: from psp_eff_reports er, psp_eff_report_details erd
1367: where er.status_code in ('N', 'A')
1368: and er.effort_Report_id = erd.effort_report_id
1369: and g_psp_effort_end >= er.start_date
1370: and g_psp_effort_start <= er.end_date );

Line 1379: from psp_eff_reports er, psp_eff_report_details erd

1375: where person_id between p_start_person and p_end_person
1376: and request_id = p_request_id
1377: and person_id in
1378: (select er.person_id
1379: from psp_eff_reports er, psp_eff_report_details erd
1380: where er.status_code in ('N', 'A')
1381: and er.effort_Report_id = erd.effort_report_id
1382: and g_psp_effort_end >= er.start_date
1383: and g_psp_effort_start <= er.end_date

Line 1506: psp_eff_report_details perd

1502: select 1, per.person_id, perd.project_id, NVL(perd.project_name,'NOTFOUND'), perd.task_id, NVL(perd.task_name,'NOTFOUND'),
1503: perd.award_id, NVL(perd.AWARD_SHORT_NAME,'NOTFOUND'), EXPENDITURE_ORGANIZATION_ID ,NVL(perd.exp_org_name,'NOTFOUND'),
1504: perd.expenditure_type
1505: from psp_eff_reports per ,
1506: psp_eff_report_details perd
1507: where per.EFFORT_REPORT_ID = perd.EFFORT_REPORT_ID
1508: AND per.request_id = p_request_id
1509: AND person_id between p_start_person and p_end_person
1510: AND(( PROJECT_ID is not null AND PROJECT_NAME is NULL)

Line 1519: psp_eff_report_details perd

1515: select 2, per.person_id, perd.project_id, perd.project_name, perd.task_id, perd.task_name,
1516: perd.award_id, perd.AWARD_SHORT_NAME, EXPENDITURE_ORGANIZATION_ID ,perd.exp_org_name,
1517: perd.expenditure_type
1518: from psp_eff_reports per ,
1519: psp_eff_report_details perd
1520: where per.EFFORT_REPORT_ID = perd.EFFORT_REPORT_ID
1521: and per.request_id = p_request_id
1522: AND person_id between p_start_person and p_end_person
1523: AND PROJECT_ID is NULL

Line 1546: psp_eff_report_details perd

1542: SELECT DISTINCT per.person_id,
1543: perd.award_id,
1544: perd.award_number
1545: FROM psp_eff_reports per,
1546: psp_eff_report_details perd
1547: WHERE per.request_id = p_request_id
1548: AND per.effort_report_id = perd.effort_report_id
1549: AND per.person_id BETWEEN p_start_person AND p_end_person
1550: --AND perd.award_id IS NOT NULL Commented as part of UVA fix 4537063

Line 1558: psp_eff_report_details perd

1554: SELECT DISTINCT per.person_id,
1555: perd.project_id,
1556: perd.project_number
1557: FROM psp_eff_reports per,
1558: psp_eff_report_details perd
1559: WHERE per.request_id = p_request_id
1560: AND per.effort_report_id = perd.effort_report_id
1561: AND per.person_id BETWEEN p_start_person AND p_end_person
1562: AND perd.project_id IS NOT NULL

Line 1571: psp_eff_report_details perd

1567: perd.project_number,
1568: perd.task_id,
1569: perd.task_number
1570: FROM psp_eff_reports per,
1571: psp_eff_report_details perd
1572: WHERE per.request_id = p_request_id
1573: AND per.effort_report_id = perd.effort_report_id
1574: AND per.person_id BETWEEN p_start_person AND p_end_person
1575: AND perd.task_id IS NOT NULL

Line 1584: psp_eff_report_details perd,

1580: ppa.segment1,
1581: perd.task_id,
1582: perd.task_number
1583: FROM psp_eff_reports per,
1584: psp_eff_report_details perd,
1585: pa_tasks pt,
1586: pa_projects_all ppa
1587: WHERE per.request_id = p_request_id
1588: AND per.effort_report_id = perd.effort_report_id

Line 1598: psp_eff_report_details perd

1594:
1595: CURSOR check_project_number_cur IS
1596: SELECT COUNT(1)
1597: FROM psp_eff_reports per,
1598: psp_eff_report_details perd
1599: WHERE per.request_id = p_request_id
1600: AND per.person_id BETWEEN p_start_person AND p_end_person
1601: AND perd.task_id IS NOT NULL
1602: AND perd.project_id IS NULL