APPS.PSP_SUM_TRANS dependencies on PSP_CREATE_EFF_REPORTS

Line 6651: hr_utility.trace( 'SandT_Supercede--> before call to psp_create_eff_reports.populate_eff_tables');

6647: hr_utility.trace( 'SandT_Supercede--> insert into GT potential persons Number of recodrs=' ||t_person_table.count||'person_id =' ||t_person_table(1));
6648: savepoint populate_er_tables;
6649:
6650: -- create fresh ER for comparison
6651: hr_utility.trace( 'SandT_Supercede--> before call to psp_create_eff_reports.populate_eff_tables');
6652: for n in 1..t_template_id.count
6653: loop
6654: if t_template_id(n) = t_template_id(k) then
6655: hr_utility.trace('SandT_Supercede--> call CREATE_EFF params : superced_request='||

Line 6657: psp_create_eff_reports.populate_eff_tables(errBuf ,

6653: loop
6654: if t_template_id(n) = t_template_id(k) then
6655: hr_utility.trace('SandT_Supercede--> call CREATE_EFF params : superced_request='||
6656: t_request_id(n)||' , template_id = '||t_template_id(n));
6657: psp_create_eff_reports.populate_eff_tables(errBuf ,
6658: retCode,
6659: null,
6660: t_request_id(n),
6661: null,

Line 6663: hr_utility.trace('SandT_Supercede--> g_summarization_criteria = '|| PSP_CREATE_EFF_REPORTS.g_summarization_criteria);

6659: null,
6660: t_request_id(n),
6661: null,
6662: 'Y');
6663: hr_utility.trace('SandT_Supercede--> g_summarization_criteria = '|| PSP_CREATE_EFF_REPORTS.g_summarization_criteria);
6664:
6665: end if;
6666: end loop;
6667: hr_utility.trace( 'SandT_Supercede--> after call to psp_create_eff_reports.populate_eff_tables');

Line 6667: hr_utility.trace( 'SandT_Supercede--> after call to psp_create_eff_reports.populate_eff_tables');

6663: hr_utility.trace('SandT_Supercede--> g_summarization_criteria = '|| PSP_CREATE_EFF_REPORTS.g_summarization_criteria);
6664:
6665: end if;
6666: end loop;
6667: hr_utility.trace( 'SandT_Supercede--> after call to psp_create_eff_reports.populate_eff_tables');
6668:
6669: if l_tolerance_amt <> -999 then --- tolerance_amt is not null then
6670: l_sql_string := ' begin
6671: select distinct er.request_id, er.person_id

Line 6681: group by er.request_id, er.person_id '|| PSP_CREATE_EFF_REPORTS.g_summarization_criteria ||

6677: ('||''''||'S'||''''||','||''''||'R'||''''||')
6678: and er.request_id in ('||l_supercede_reqid_str||')
6679: and er.effort_report_id = erd.effort_report_id
6680: and gt.person_id = er.person_id
6681: group by er.request_id, er.person_id '|| PSP_CREATE_EFF_REPORTS.g_summarization_criteria ||
6682: ' having abs(sum(decode(er.status_code,'||''''|| 'T'||''''||',
6683: -erd.actual_salary_amt,
6684: erd.actual_salary_amt))) > :l_tolerance_amt;
6685: end;';

Line 6735: group by er.request_id, er.person_id '||PSP_CREATE_EFF_REPORTS.g_summarization_criteria ||

6731: ('||''''||'S'||''''||','||''''||'R'||''''||')
6732: and er.request_id in ('||l_supercede_reqid_str||')
6733: and gt.person_id = er.person_id
6734: and er.effort_report_id = erd.effort_report_id
6735: group by er.request_id, er.person_id '||PSP_CREATE_EFF_REPORTS.g_summarization_criteria ||
6736: ' having abs(sum(decode(er.status_code,'||''''|| 'T'||''''||',
6737: -erd.payroll_percent,
6738: erd.payroll_percent))) > :l_tolerance_percent;
6739: end;';