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.

[Home] [Help]

APPS.PSP_CREATE_EFF_REPORTS dependencies on PSP_EFF_REPORT_DETAILS

Line 494: psp_eff_report_details erd

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

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

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

Line 782: insert into psp_eff_report_details(

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

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

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

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

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

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

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

Line 1011: from psp_eff_report_details where

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

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

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

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

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

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:

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

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

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

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

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

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

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

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

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

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

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

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

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

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

Line 1368: from psp_eff_reports er, psp_eff_report_details erd

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

Line 1381: from psp_eff_reports er, psp_eff_report_details erd

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

Line 1508: psp_eff_report_details perd

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

Line 1521: psp_eff_report_details perd

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

Line 1548: psp_eff_report_details perd

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

Line 1560: psp_eff_report_details perd

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

Line 1573: psp_eff_report_details perd

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

Line 1586: psp_eff_report_details perd,

1582: ppa.segment1,
1583: perd.task_id,
1584: perd.task_number
1585: FROM psp_eff_reports per,
1586: psp_eff_report_details perd,
1587: pa_tasks_expend_v pt, -- Bug : 16391366 (20/03/2013)
1588: pa_projects_all ppa
1589: WHERE per.request_id = p_request_id
1590: AND per.effort_report_id = perd.effort_report_id

Line 1600: psp_eff_report_details perd

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