DBA Data[Home] [Help]

APPS.PSP_MATRIX_DRIVER3_PKG dependencies on PSP_GENERAL

Line 267: per:= sch_rec.sp*psp_general.business_days(sch_rec.sbd,last_period_day(dat(i)))/psp_general.business_days(dat(i),last_period_day(dat(i)));

263: EXIT WHEN sched_lines%NOTFOUND;
264: num:=dat.COUNT;
265: FOR i in 1 .. num LOOP
266: if ((sch_rec.sbd between dat(i) and last_period_day(dat(i))AND(sch_rec.sed >= last_period_day(dat(i)))))then
267: per:= sch_rec.sp*psp_general.business_days(sch_rec.sbd,last_period_day(dat(i)))/psp_general.business_days(dat(i),last_period_day(dat(i)));
268: elsif ((dat(i) between sch_rec.sbd and sch_rec.sed)AND(last_period_day(dat(i)) >= sch_rec.sed))then
269: per:= sch_rec.sp*psp_general.business_days(dat(i),sch_rec.sed)/psp_general.business_days(dat(i),last_period_day(dat(i)));
270: elsif((sch_rec.sbd between dat(i) and last_period_day(dat(i)))and(sch_rec.sed <= last_period_day(dat(i))))then
271: per:= sch_rec.sp*psp_general.business_days(sch_rec.sbd,sch_rec.sed)/psp_general.business_days(dat(i),last_period_day(dat(i)));

Line 269: per:= sch_rec.sp*psp_general.business_days(dat(i),sch_rec.sed)/psp_general.business_days(dat(i),last_period_day(dat(i)));

265: FOR i in 1 .. num LOOP
266: if ((sch_rec.sbd between dat(i) and last_period_day(dat(i))AND(sch_rec.sed >= last_period_day(dat(i)))))then
267: per:= sch_rec.sp*psp_general.business_days(sch_rec.sbd,last_period_day(dat(i)))/psp_general.business_days(dat(i),last_period_day(dat(i)));
268: elsif ((dat(i) between sch_rec.sbd and sch_rec.sed)AND(last_period_day(dat(i)) >= sch_rec.sed))then
269: per:= sch_rec.sp*psp_general.business_days(dat(i),sch_rec.sed)/psp_general.business_days(dat(i),last_period_day(dat(i)));
270: elsif((sch_rec.sbd between dat(i) and last_period_day(dat(i)))and(sch_rec.sed <= last_period_day(dat(i))))then
271: per:= sch_rec.sp*psp_general.business_days(sch_rec.sbd,sch_rec.sed)/psp_general.business_days(dat(i),last_period_day(dat(i)));
272: elsif ((dat(i) between sch_rec.sbd and sch_rec.sed)AND(last_period_day(dat(i)) <= sch_rec.sed))then
273: per:= sch_rec.sp;

Line 271: per:= sch_rec.sp*psp_general.business_days(sch_rec.sbd,sch_rec.sed)/psp_general.business_days(dat(i),last_period_day(dat(i)));

267: per:= sch_rec.sp*psp_general.business_days(sch_rec.sbd,last_period_day(dat(i)))/psp_general.business_days(dat(i),last_period_day(dat(i)));
268: elsif ((dat(i) between sch_rec.sbd and sch_rec.sed)AND(last_period_day(dat(i)) >= sch_rec.sed))then
269: per:= sch_rec.sp*psp_general.business_days(dat(i),sch_rec.sed)/psp_general.business_days(dat(i),last_period_day(dat(i)));
270: elsif((sch_rec.sbd between dat(i) and last_period_day(dat(i)))and(sch_rec.sed <= last_period_day(dat(i))))then
271: per:= sch_rec.sp*psp_general.business_days(sch_rec.sbd,sch_rec.sed)/psp_general.business_days(dat(i),last_period_day(dat(i)));
272: elsif ((dat(i) between sch_rec.sbd and sch_rec.sed)AND(last_period_day(dat(i)) <= sch_rec.sed))then
273: per:= sch_rec.sp;
274: else
275: per:=0;