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_ER_WORKFLOW dependencies on PSP_EFF_REPORT_DETAILS

Line 222: psp_eff_report_details erd

218: psp_wf_item_key_s.nextval
219: from (select era.wf_role_name
220: from psp_eff_report_approvals era,
221: psp_eff_reports er,
222: psp_eff_report_details erd
223: where erd.effort_report_id = er.effort_report_id
224: and erd.effort_report_detail_id = era.effort_report_detail_id
225: and era.approval_status = 'P'
226: and era.approver_order_num = 1

Line 305: psp_eff_report_details erd

301: where wf_role_name = wf_rname_array(k)
302: and effort_report_detail_id in
303: (select erd.effort_report_detail_id
304: from psp_eff_reports er,
305: psp_eff_report_details erd
306: where erd.effort_report_id = er.effort_report_id
307: and er.request_id = l_request_id
308: and er.status_code = 'N');
309: k := 1;

Line 458: from psp_eff_report_details

454: aname => 'REQUEST_ID');
455: delete psp_eff_report_approvals
456: where effort_report_detail_id in
457: (select effort_report_detail_id
458: from psp_eff_report_details
459: where effort_report_id in
460: (select effort_report_id
461: from psp_eff_reports
462: where request_id = l_request_id));

Line 464: delete psp_eff_report_details

460: (select effort_report_id
461: from psp_eff_reports
462: where request_id = l_request_id));
463:
464: delete psp_eff_report_details
465: where effort_report_id in
466: (select effort_report_id
467: from psp_eff_reports
468: where request_id = l_request_id);

Line 491: FROM psp_eff_report_details perd

487: fnd_documents_vl fdl
488: WHERE fad.pk1_value IN (SELECT wf_item_key
489: FROM psp_eff_report_approvals pera
490: WHERE pera.effort_report_detail_id IN (SELECT perd.effort_report_detail_id
491: FROM psp_eff_report_details perd
492: WHERE perd.effort_report_id IN (SELECT per.effort_report_id
493: FROM psp_eff_reports per
494: WHERE per.request_id = l_request_id)))
495: AND fdl.document_id = fad.document_id

Line 577: from psp_eff_report_details erd

573: and approver_order_num = 1;
574:
575: cursor ame_txn_id_cur is
576: select distinct erd.ame_transaction_id
577: from psp_eff_report_details erd
578: where erd.effort_report_detail_id in
579: (select era.effort_report_detail_id
580: from psp_eff_report_approvals era
581: where wf_item_key = itemkey

Line 658: from psp_eff_report_details erd,

654: er.last_updated_by = fnd_global.user_id
655: where er.status_code = 'N'
656: and er.effort_report_id in
657: (select erd.effort_report_id
658: from psp_eff_report_details erd,
659: psp_eff_report_approvals era
660: where era.effort_report_detail_id = erd.effort_report_detail_id
661: and era.wf_item_key = itemkey)
662: and not exists

Line 665: psp_eff_report_details erd

661: and era.wf_item_key = itemkey)
662: and not exists
663: (select 1
664: from psp_eff_report_approvals era,
665: psp_eff_report_details erd
666: where era.effort_report_detail_id = erd.effort_report_detail_id
667: and erd.effort_report_id = er.effort_report_id
668: and era.approval_status <> 'A');
669: result := 'COMPLETE:NOTFOUND';

Line 737: from psp_eff_report_details erd

733: sysdate,
734: l_user_id,
735: l_next_approver(1).display_name,
736: 1
737: from psp_eff_report_details erd
738: where erd.ame_transaction_id = ame_txn_id_array(i)
739: and erd.effort_report_id in
740: (select er.effort_report_id
741: from psp_eff_reports er

Line 776: psp_eff_report_details erd

772: where A1.approver_order_num = l_approver_order_num and
773: A1.effort_report_detail_id in
774: (select erd.effort_report_detail_id
775: from psp_eff_reports er,
776: psp_eff_report_details erd
777: where er.request_id = l_request_id
778: and er.effort_report_id = erd.effort_report_id
779: and erd.ame_transaction_id = ame_txn_id_array(i)
780: and er.status_code = 'N');

Line 797: from psp_eff_report_details erd,

793: er.last_updated_by = fnd_global.user_id
794: where er.status_code = 'N'
795: and er.effort_report_id in
796: (select erd.effort_report_id
797: from psp_eff_report_details erd,
798: psp_eff_report_approvals era
799: where era.effort_report_detail_id = erd.effort_report_detail_id
800: and era.wf_item_key = itemkey)
801: and not exists

Line 804: psp_eff_report_details erd

800: and era.wf_item_key = itemkey)
801: and not exists
802: (select 1
803: from psp_eff_report_approvals era,
804: psp_eff_report_details erd
805: where era.effort_report_detail_id = erd.effort_report_detail_id
806: and erd.effort_report_id = er.effort_report_id
807: and era.approval_status <> 'A');
808: end if;

Line 906: from psp_eff_report_details

902: select effort_report_id
903: from psp_eff_reports
904: where effort_report_id in
905: (select effort_report_id
906: from psp_eff_report_details
907: where effort_report_detail_id in
908: (select effort_report_detail_id
909: from psp_eff_report_approvals
910: where wf_item_key = itemkey

Line 918: psp_eff_report_details erd,

914: --- partial approval by 2 approvers.
915: cursor past_approvers_cur is
916: select distinct era.wf_role_name
917: from psp_eff_reports er,
918: psp_eff_report_details erd,
919: psp_eff_report_approvals era,
920: fnd_user fu -- Bug 6641216
921: where era.effort_report_detail_id = erd.effort_report_detail_id
922: and erd.effort_report_id = er.effort_report_id

Line 930: from psp_eff_report_details

926: (select effort_report_id
927: from psp_eff_reports
928: where effort_report_id in
929: (select effort_report_id
930: from psp_eff_report_details
931: where effort_report_detail_id in
932: (select effort_report_detail_id
933: from psp_eff_report_approvals
934: where wf_item_key = itemkey

Line 949: from psp_eff_report_details erd,

945: where request_id = l_request_id);
946:
947: cursor get_txn_id_cur is
948: select distinct ame_transaction_id
949: from psp_eff_report_details erd,
950: psp_eff_report_approvals era
951: where erd.effort_report_detail_id = era.effort_report_detail_id
952: and era.wf_item_key = itemkey
953: and era.approval_status = 'P'

Line 1028: from psp_eff_report_details erd,

1024: where era.wf_item_key = itemkey
1025: and era.wf_role_name = l_rname
1026: and exists
1027: ( select erd.effort_report_detail_id
1028: from psp_eff_report_details erd,
1029: psp_eff_reports er
1030: where er.effort_report_id = erd.effort_report_id
1031: and erd.effort_report_detail_id = era.effort_report_detail_id
1032: and er.status_code = 'S' );

Line 1045: from psp_eff_report_details erd,

1041: where era.wf_item_key = itemkey
1042: and era.wf_role_name = l_rname
1043: and not exists
1044: ( select erd.effort_report_detail_id
1045: from psp_eff_report_details erd,
1046: psp_eff_reports er
1047: where er.effort_report_id = erd.effort_report_id
1048: and erd.effort_report_detail_id = era.effort_report_detail_id
1049: and er.status_code = 'S' );

Line 1142: from psp_eff_report_details erd,

1138: and wf_role_name = l_rname;
1139:
1140: cursor get_txn_id_cur is
1141: select distinct ame_transaction_id
1142: from psp_eff_report_details erd,
1143: psp_eff_report_approvals era
1144: where erd.effort_report_detail_id = era.effort_report_detail_id
1145: and era.wf_item_key = itemkey
1146: and era.approval_status = 'A'

Line 1180: from psp_eff_report_details erd,

1176: and era.wf_orig_system = l_orig_system
1177: and era.approval_status = 'P'
1178: and exists
1179: ( select erd.effort_report_detail_id
1180: from psp_eff_report_details erd,
1181: psp_eff_reports er
1182: where er.effort_report_id = erd.effort_report_id
1183: and erd.effort_report_detail_id = era.effort_report_detail_id
1184: and er.status_code = 'S' );

Line 1200: from psp_eff_report_details erd,

1196: and era.wf_orig_system = l_orig_system
1197: and era.approval_status = 'P'
1198: and not exists
1199: ( select erd.effort_report_detail_id
1200: from psp_eff_report_details erd,
1201: psp_eff_reports er
1202: where er.effort_report_id = erd.effort_report_id
1203: and erd.effort_report_detail_id = era.effort_report_detail_id
1204: and er.status_code = 'S' );

Line 1271: from psp_eff_report_details erd,

1267: and wf_role_name = l_rname;
1268:
1269: cursor get_txn_id_cur is
1270: select distinct ame_transaction_id
1271: from psp_eff_report_details erd,
1272: psp_eff_report_approvals era
1273: where erd.effort_report_detail_id = era.effort_report_detail_id
1274: and era.wf_item_key = itemkey
1275: and era.approval_status = 'P'

Line 1312: psp_eff_report_details perd,

1308: SELECT distinct prth.hundred_pcent_eff_at_per_asg, per.start_date,
1309: per.end_date, per.person_id, perd.assignment_id, per.full_name, perd.assignment_number
1310: FROM psp_report_templates_h prth,
1311: psp_eff_reports per,
1312: psp_eff_report_details perd,
1313: psp_eff_report_approvals prea
1314: WHERE prth.request_id = per.request_id
1315: AND per.effort_report_id = perd.effort_report_id
1316: AND perd.effort_report_detail_id = prea.effort_report_detail_id

Line 1325: psp_eff_report_details perd,

1321:
1322: CURSOR is_person_last_approver_csr IS
1323: SELECT 1
1324: FROM psp_eff_reports per,
1325: psp_eff_report_details perd,
1326: psp_eff_report_approvals prea
1327: WHERE per.effort_report_id = perd.effort_report_id
1328: AND perd.effort_report_detail_id = prea.effort_report_detail_id
1329: AND per.person_id = l_person_id

Line 1340: psp_eff_report_details perd,

1336:
1337: CURSOR is_asg_last_approver_csr IS
1338: SELECT 1
1339: FROM psp_eff_reports per,
1340: psp_eff_report_details perd,
1341: psp_eff_report_approvals prea
1342: WHERE per.effort_report_id = perd.effort_report_id
1343: AND perd.effort_report_detail_id = prea.effort_report_detail_id
1344: AND perd.assignment_id = l_assignment_id

Line 1356: psp_eff_report_details perd,

1352:
1353: CURSOR person_percent_csr IS
1354: SELECT sum(nvl(overwritten_effort_percent,payroll_percent))
1355: FROM psp_eff_reports per,
1356: psp_eff_report_details perd,
1357: psp_eff_report_approvals prea
1358: WHERE per.effort_report_id = perd.effort_report_id
1359: AND perd.effort_report_detail_id = prea.effort_report_detail_id
1360: AND per.person_id = l_person_id

Line 1370: psp_eff_report_details perd,

1366:
1367: CURSOR assignment_percent_csr IS
1368: SELECT sum(nvl(overwritten_effort_percent,payroll_percent))
1369: FROM psp_eff_reports per,
1370: psp_eff_report_details perd,
1371: psp_eff_report_approvals prea
1372: WHERE per.effort_report_id = perd.effort_report_id
1373: AND perd.effort_report_detail_id = prea.effort_report_detail_id
1374: AND perd.assignment_id = l_assignment_id

Line 1591: from psp_eff_report_details

1587: select person_id
1588: from psp_eff_reports
1589: where effort_report_id in
1590: (select effort_report_id
1591: from psp_eff_report_details
1592: where request_id = l_request_id
1593: and effort_report_detail_id in
1594: (select effort_report_detail_id
1595: from psp_eff_report_approvals