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_SUM_TRANS dependencies on PSP_SUPERCEDE_PERSONS_GT

Line 5289: And per.request_id in ( select -person_id from psp_supercede_persons_gt where person_id < 0)

5285: From psp_adjustment_lines_history pal,
5286: Psp_eff_reports per,
5287: Psp_payroll_controls ppc
5288: Where pal.distribution_date between per.start_date and per.end_date
5289: And per.request_id in ( select -person_id from psp_supercede_persons_gt where person_id < 0)
5290: And ppc.run_id = p_run_id
5291: And pal.person_id = per.person_id
5292: And ppc.payroll_control_id = pal.payroll_control_id
5293: And per.status_code not in ('S','R')

Line 5321: And per.request_id in (select -person_id from psp_supercede_persons_gt where person_id < 0)

5317: From psp_pre_gen_dist_lines_history pregen,
5318: Psp_eff_reports per,
5319: Psp_payroll_controls ppc
5320: Where pregen.distribution_date between per.start_date and per.end_date
5321: And per.request_id in (select -person_id from psp_supercede_persons_gt where person_id < 0)
5322: And ppc.run_id = p_run_id
5323: And pregen.person_id = per.person_id
5324: And ppc.payroll_control_id = pregen.payroll_control_id
5325: And per.status_code not in ('S','R')

Line 5359: And per.request_id in (select -person_id from psp_supercede_persons_gt where person_id < 0)

5355: Psp_payroll_controls ppc,
5356: psp_payroll_sub_lines psub,
5357: psp_payroll_lines ppl
5358: Where dlh.payroll_sub_line_id = psub.payroll_sub_line_id
5359: And per.request_id in (select -person_id from psp_supercede_persons_gt where person_id < 0)
5360: And psub.payroll_line_id = ppl.payroll_line_id
5361: And ppl.person_id = per.person_id
5362: And dlh.distribution_date between per.start_date and per.end_date
5363: And ppc.run_id = p_run_id

Line 5403: And per.request_id in (select -person_id from psp_supercede_persons_gt)

5399: Psp_payroll_controls ppc,
5400: psp_payroll_sub_lines psub,
5401: psp_payroll_lines ppl
5402: Where dlh.payroll_sub_line_id = psub.payroll_sub_line_id
5403: And per.request_id in (select -person_id from psp_supercede_persons_gt)
5404: And psub.payroll_line_id = ppl.payroll_line_id
5405: And ppl.person_id = per.person_id
5406: And dlh.distribution_date between per.start_date and per.end_date
5407: And ppc.run_id = p_run_id

Line 5439: And per.request_id in ( select -person_id from psp_supercede_persons_gt )

5435: From psp_pre_gen_dist_lines_history pregen,
5436: Psp_eff_reports per,
5437: Psp_payroll_controls ppc
5438: Where pregen.distribution_date between per.start_date and per.end_date
5439: And per.request_id in ( select -person_id from psp_supercede_persons_gt )
5440: And ppc.run_id = p_run_id
5441: And pregen.person_id = per.person_id
5442: And ppc.payroll_control_id = pregen.payroll_control_id
5443: And per.status_code not in ('S','R')

Line 5479: And per.request_id in ( select -person_id from psp_supercede_persons_gt where person_id < 0)

5475: psp_eff_report_details perd
5476: Where pal.distribution_date between per.start_date and per.end_date
5477: and perd.effort_report_id = per.effort_report_id
5478: and perd.assignment_id = pal.assignment_id
5479: And per.request_id in ( select -person_id from psp_supercede_persons_gt where person_id < 0)
5480: And ppc.run_id = p_run_id
5481: And pal.person_id = per.person_id
5482: And ppc.payroll_control_id = pal.payroll_control_id
5483: And per.status_code not in ('S','R')

Line 5514: And per.request_id in (select -person_id from psp_supercede_persons_gt where person_id < 0)

5510: psp_eff_report_details perd
5511: Where pregen.distribution_date between per.start_date and per.end_date
5512: and perd.effort_report_id = per.effort_report_id
5513: and perd.assignment_id = pregen.assignment_id
5514: And per.request_id in (select -person_id from psp_supercede_persons_gt where person_id < 0)
5515: And ppc.run_id = p_run_id
5516: And pregen.person_id = per.person_id
5517: And ppc.payroll_control_id = pregen.payroll_control_id
5518: And per.status_code not in ('S','R')

Line 5555: And per.request_id in (select -person_id from psp_supercede_persons_gt where person_id < 0)

5551: psp_eff_report_details perd
5552: Where dlh.payroll_sub_line_id = psub.payroll_sub_line_id
5553: and perd.effort_report_id = per.effort_report_id
5554: and perd.assignment_id = ppl.assignment_id
5555: And per.request_id in (select -person_id from psp_supercede_persons_gt where person_id < 0)
5556: And psub.payroll_line_id = ppl.payroll_line_id
5557: And ppl.person_id = per.person_id
5558: And dlh.distribution_date between per.start_date and per.end_date
5559: And ppc.run_id = p_run_id

Line 5603: And per.request_id in (select -person_id from psp_supercede_persons_gt)

5599: psp_eff_report_details perd
5600: Where dlh.payroll_sub_line_id = psub.payroll_sub_line_id
5601: and perd.effort_report_id = per.effort_report_id
5602: and perd.assignment_id = ppl.assignment_id
5603: And per.request_id in (select -person_id from psp_supercede_persons_gt)
5604: And psub.payroll_line_id = ppl.payroll_line_id
5605: And ppl.person_id = per.person_id
5606: And dlh.distribution_date between per.start_date and per.end_date
5607: And ppc.run_id = p_run_id

Line 5642: And per.request_id in ( select -person_id from psp_supercede_persons_gt )

5638: psp_eff_report_details perd
5639: Where pregen.distribution_date between per.start_date and per.end_date
5640: and perd.effort_report_id = per.effort_report_id
5641: and perd.assignment_id = pregen.assignment_id
5642: And per.request_id in ( select -person_id from psp_supercede_persons_gt )
5643: And ppc.run_id = p_run_id
5644: And pregen.person_id = per.person_id
5645: And ppc.payroll_control_id = pregen.payroll_control_id
5646: And per.status_code not in ('S','R')

Line 5681: from psp_supercede_persons_gt

5677: where run_id = p_run_id)
5678: and rownum = 1
5679: and per.request_id in
5680: (select abs(person_id)
5681: from psp_supercede_persons_gt
5682: where person_id < 0);
5683: l_emp_overlap_count integer;
5684:
5685: -- uva isue, supercede for matching asg option

Line 5689: where request_id in ( select -person_id from psp_supercede_persons_gt )

5685: -- uva isue, supercede for matching asg option
5686: cursor check_emp_match_option is
5687: select count(*)
5688: from psp_report_templates_h
5689: where request_id in ( select -person_id from psp_supercede_persons_gt )
5690: and selection_match_level = 'EMP';
5691:
5692: l_count_emp_match integer;
5693:

Line 5763: from psp_supercede_persons_gt

5759: and dtl.criteria_lookup_type = 'PSP_SELECTION_CRITERIA'
5760: and dtl.criteria_lookup_code = 'FRP'
5761: and dtl.request_id = h.request_id
5762: and h.request_id in ( select -person_id
5763: from psp_supercede_persons_gt
5764: where person_id < 0)
5765: and h.final_recip_notified_flag = 'Y';
5766:
5767: cursor get_init_wf_names is

Line 5775: from psp_supercede_persons_gt

5771: psp_report_templates_h h
5772: where wf.orig_system = 'PER'
5773: and wf.orig_system_id = h.initiator_person_id
5774: and h.request_id in ( select -person_id
5775: from psp_supercede_persons_gt
5776: where person_id < 0)
5777: and exists (select 1 from psp_eff_reports per
5778: where per.request_id = h.request_id
5779: and per.superceding_request_id = p_SandT_reqid);

Line 5792: from psp_supercede_persons_gt

5788: and wf.orig_system_id = er.person_id
5789: and h.request_id = er.request_id
5790: and h.initiator_accept_flag = 'Y'
5791: and er.request_id in ( select -person_id
5792: from psp_supercede_persons_gt
5793: where person_id < 0)
5794: and er.superceding_request_id = p_SandT_reqid;
5795:
5796: cursor get_app_wf_names is

Line 5804: and er.request_id in ( select -person_id from psp_supercede_persons_gt where person_id < 0 )

5800: psp_eff_reports er,
5801: psp_report_templates_h h
5802: where erd.effort_report_detail_id = era.effort_report_detail_id
5803: and erd.effort_report_id = er.effort_report_id
5804: and er.request_id in ( select -person_id from psp_supercede_persons_gt where person_id < 0 )
5805: and er.superceding_request_id = p_SandT_reqid
5806: and era.approval_status <> 'R'
5807: and er.request_id = h.request_id
5808: and h.initiator_accept_flag = 'Y';

Line 6094: tabname => 'PSP_SUPERCEDE_PERSONS_GT');

6090: fnd_signon.set_session(to_char(sysdate,'dd-mon-yyyy'));
6091: p_return_status := fnd_api.g_ret_sts_success;
6092: l_S_and_T_reqid := fnd_global.conc_request_id;
6093: fnd_stats.gather_table_stats(ownname => 'PSP',
6094: tabname => 'PSP_SUPERCEDE_PERSONS_GT');
6095: open check_er_template_h;
6096: fetch check_er_template_h bulk collect into t_template_id, t_request_id;
6097: close check_er_template_h;
6098:

Line 6107: delete psp_supercede_persons_gt;

6103: hr_utility.trace( 'SandT_Supercede--> template_id.count='||t_template_id.count);
6104:
6105: l_supercede_reqid_str := null;
6106:
6107: delete psp_supercede_persons_gt;
6108: for k in 1..t_template_id.count
6109: loop
6110: if t_template_id.count = k or --- supercede for distinct template
6111: (t_template_id.count > k and t_template_id(k) <> t_template_id(k+1)) then

Line 6117: insert into psp_supercede_persons_gt

6113: l_supercede_reqid_str := t_request_id(k);
6114: else
6115: l_supercede_reqid_str := l_supercede_reqid_str ||', '|| t_request_id(k);
6116: end if;
6117: insert into psp_supercede_persons_gt
6118: (person_id)
6119: values ( -t_request_id(k));
6120:
6121: open check_emp_overlap;

Line 6217: insert into psp_supercede_persons_gt

6213: else -- tolerance set to non null value
6214: --- load session temp table
6215: hr_utility.trace( 'SandT_Supercede--> purge GT table - 1');
6216: forall i in 1..t_person_table.count
6217: insert into psp_supercede_persons_gt
6218: (person_id)
6219: values (t_person_table(i));
6220: hr_utility.trace( 'SandT_Supercede--> insert into GT potential persons Number of recodrs=' ||t_person_table.count||'person_id =' ||t_person_table(1));
6221: savepoint populate_er_tables;

Line 6247: psp_supercede_persons_gt gt,

6243: l_sql_string := ' begin
6244: select distinct er.request_id, er.person_id
6245: bulk collect into :reqtable, :pertable
6246: from psp_eff_report_details erd,
6247: psp_supercede_persons_gt gt,
6248: psp_eff_reports er
6249: where er.status_code not in
6250: ('||''''||'S'||''''||','||''''||'R'||''''||')
6251: and er.request_id in ('||l_supercede_reqid_str||')

Line 6301: psp_supercede_persons_gt gt,

6297: l_sql_string := ' begin
6298: select distinct er.request_id, er.person_id
6299: bulk collect into :reqtable, :pertable
6300: from psp_eff_report_details erd,
6301: psp_supercede_persons_gt gt,
6302: psp_eff_reports er
6303: where er.status_code not in
6304: ('||''''||'S'||''''||','||''''||'R'||''''||')
6305: and er.request_id in ('||l_supercede_reqid_str||')

Line 6410: delete psp_supercede_persons_gt where person_id > 0;

6406: end loop;
6407: end if; --- non zero tolerance persons count > 0
6408: end if; -- tolerance = 0
6409: --- delete persons .. retain -persons_ids.. the request_ids.
6410: delete psp_supercede_persons_gt where person_id > 0;
6411: if l_superceded_flag then
6412: -- send superceding notifications
6413: send_notifications(l_supercede_reqid_str,
6414: t_template_id(k),

Line 6424: delete psp_supercede_persons_gt;

6420: l_superceded_flag := false;
6421: end if;
6422: end if; -- supercede persons count > 0
6423: l_supercede_reqid_str := null;
6424: delete psp_supercede_persons_gt;
6425: else
6426: l_supercede_reqid_str := null;
6427: delete psp_supercede_persons_gt;
6428: end if; --- only if s_and_t processes emps in er

Line 6427: delete psp_supercede_persons_gt;

6423: l_supercede_reqid_str := null;
6424: delete psp_supercede_persons_gt;
6425: else
6426: l_supercede_reqid_str := null;
6427: delete psp_supercede_persons_gt;
6428: end if; --- only if s_and_t processes emps in er
6429: else --- more than on reqid for Template_id
6430: insert into psp_supercede_persons_gt (person_id) values ( -t_request_id(k));
6431: if l_supercede_reqid_str is null then

Line 6430: insert into psp_supercede_persons_gt (person_id) values ( -t_request_id(k));

6426: l_supercede_reqid_str := null;
6427: delete psp_supercede_persons_gt;
6428: end if; --- only if s_and_t processes emps in er
6429: else --- more than on reqid for Template_id
6430: insert into psp_supercede_persons_gt (person_id) values ( -t_request_id(k));
6431: if l_supercede_reqid_str is null then
6432: l_supercede_reqid_str := t_request_id(k);
6433: else
6434: l_supercede_reqid_str := l_supercede_reqid_str ||', '|| t_request_id(k);

Line 6438: delete psp_supercede_persons_gt;

6434: l_supercede_reqid_str := l_supercede_reqid_str ||', '|| t_request_id(k);
6435: end if;
6436: end if; -- new template
6437: end loop;
6438: delete psp_supercede_persons_gt;
6439: t_person_table := t_num_15_type(null);
6440: t_efforts_table := t_num_15_type(null);
6441: t_sum_line_id := t_num_15_type(null);
6442: t_person_table.delete;