APPS.PSP_SUM_TRANS dependencies on PSP_CREATE_EFF_REPORTS

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

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;
6222:
6223: -- create fresh ER for comparison
6224: hr_utility.trace( 'SandT_Supercede--> before call to psp_create_eff_reports.populate_eff_tables');
6225: for n in 1..t_template_id.count
6226: loop
6227: if t_template_id(n) = t_template_id(k) then
6228: hr_utility.trace('SandT_Supercede--> call CREATE_EFF params : superced_request='||

Line 6230: psp_create_eff_reports.populate_eff_tables(errBuf ,

6226: loop
6227: if t_template_id(n) = t_template_id(k) then
6228: hr_utility.trace('SandT_Supercede--> call CREATE_EFF params : superced_request='||
6229: t_request_id(n)||' , template_id = '||t_template_id(n));
6230: psp_create_eff_reports.populate_eff_tables(errBuf ,
6231: retCode,
6232: null,
6233: t_request_id(n),
6234: null,

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

6232: null,
6233: t_request_id(n),
6234: null,
6235: 'Y');
6236: hr_utility.trace('SandT_Supercede--> g_summarization_criteria = '|| PSP_CREATE_EFF_REPORTS.g_summarization_criteria);
6237:
6238: end if;
6239: end loop;
6240: hr_utility.trace( 'SandT_Supercede--> after call to psp_create_eff_reports.populate_eff_tables');

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

6236: hr_utility.trace('SandT_Supercede--> g_summarization_criteria = '|| PSP_CREATE_EFF_REPORTS.g_summarization_criteria);
6237:
6238: end if;
6239: end loop;
6240: hr_utility.trace( 'SandT_Supercede--> after call to psp_create_eff_reports.populate_eff_tables');
6241:
6242: if l_tolerance_amt <> -999 then --- tolerance_amt is not null then
6243: l_sql_string := ' begin
6244: select distinct er.request_id, er.person_id

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

6250: ('||''''||'S'||''''||','||''''||'R'||''''||')
6251: and er.request_id in ('||l_supercede_reqid_str||')
6252: and er.effort_report_id = erd.effort_report_id
6253: and gt.person_id = er.person_id
6254: group by er.request_id, er.person_id '|| PSP_CREATE_EFF_REPORTS.g_summarization_criteria ||
6255: ' having abs(sum(decode(er.status_code,'||''''|| 'T'||''''||',
6256: -erd.actual_salary_amt,
6257: erd.actual_salary_amt))) > :l_tolerance_amt;
6258: end;';

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

6304: ('||''''||'S'||''''||','||''''||'R'||''''||')
6305: and er.request_id in ('||l_supercede_reqid_str||')
6306: and gt.person_id = er.person_id
6307: and er.effort_report_id = erd.effort_report_id
6308: group by er.request_id, er.person_id '||PSP_CREATE_EFF_REPORTS.g_summarization_criteria ||
6309: ' having abs(sum(decode(er.status_code,'||''''|| 'T'||''''||',
6310: -erd.payroll_percent,
6311: erd.payroll_percent))) > :l_tolerance_percent;
6312: end;';