DBA Data[Home] [Help]

APPS.PSP_MATRIX_DRIVER2_PKG dependencies on PSP_GENERAL

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

97: EXIT WHEN sched_lines%NOTFOUND;
98: num:=dat.COUNT;
99: FOR i in 1 .. num LOOP
100: if ((sch_rec.sbd between dat(i) and last_day(dat(i))AND(sch_rec.sed>=last_day(dat(i)))))then
101: per:= sch_rec.sp*psp_general.business_days(sch_rec.sbd,last_day(dat(i)))/psp_general.business_days(dat(i),last_day(dat(i)));
102: elsif ((dat(i) between sch_rec.sbd and sch_rec.sed)AND(last_day(dat(i))>=sch_rec.sed))then
103: per:= sch_rec.sp*psp_general.business_days(dat(i),sch_rec.sed)/psp_general.business_days(dat(i),last_day(dat(i)));
104: elsif((sch_rec.sbd between dat(i) and last_day(dat(i)))and(sch_rec.sed<=last_day(dat(i))))then
105: per:= sch_rec.sp*psp_general.business_days(sch_rec.sbd,sch_rec.sed)/psp_general.business_days(dat(i),last_day(dat(i)));

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

99: FOR i in 1 .. num LOOP
100: if ((sch_rec.sbd between dat(i) and last_day(dat(i))AND(sch_rec.sed>=last_day(dat(i)))))then
101: per:= sch_rec.sp*psp_general.business_days(sch_rec.sbd,last_day(dat(i)))/psp_general.business_days(dat(i),last_day(dat(i)));
102: elsif ((dat(i) between sch_rec.sbd and sch_rec.sed)AND(last_day(dat(i))>=sch_rec.sed))then
103: per:= sch_rec.sp*psp_general.business_days(dat(i),sch_rec.sed)/psp_general.business_days(dat(i),last_day(dat(i)));
104: elsif((sch_rec.sbd between dat(i) and last_day(dat(i)))and(sch_rec.sed<=last_day(dat(i))))then
105: per:= sch_rec.sp*psp_general.business_days(sch_rec.sbd,sch_rec.sed)/psp_general.business_days(dat(i),last_day(dat(i)));
106: elsif ((dat(i) between sch_rec.sbd and sch_rec.sed)AND(last_day(dat(i))<=sch_rec.sed))then
107: per:= sch_rec.sp;

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

101: per:= sch_rec.sp*psp_general.business_days(sch_rec.sbd,last_day(dat(i)))/psp_general.business_days(dat(i),last_day(dat(i)));
102: elsif ((dat(i) between sch_rec.sbd and sch_rec.sed)AND(last_day(dat(i))>=sch_rec.sed))then
103: per:= sch_rec.sp*psp_general.business_days(dat(i),sch_rec.sed)/psp_general.business_days(dat(i),last_day(dat(i)));
104: elsif((sch_rec.sbd between dat(i) and last_day(dat(i)))and(sch_rec.sed<=last_day(dat(i))))then
105: per:= sch_rec.sp*psp_general.business_days(sch_rec.sbd,sch_rec.sed)/psp_general.business_days(dat(i),last_day(dat(i)));
106: elsif ((dat(i) between sch_rec.sbd and sch_rec.sed)AND(last_day(dat(i))<=sch_rec.sed))then
107: per:= sch_rec.sp;
108: else
109: per:=0;