APPS.IBY_PMTDATES_PKG dependencies on IBY_BEPINFO

Line 17: procedure getPmtDates( i_bepid in iby_bepinfo.bepid%type,

13: ** next two dates are the ouput dates. First output date corresponds to the
14: ** schedule date of the payment and next out param is the earliest
15: ** settlement date possible.
16: */
17: procedure getPmtDates( i_bepid in iby_bepinfo.bepid%type,
18: i_settlement_date in date,
19: i_current_date in date,
20: io_schedule_date in out nocopy date,
21: io_earliest_sched_date in out nocopy date)

Line 23: l_bepname iby_bepinfo.name%type;

19: i_current_date in date,
20: io_schedule_date in out nocopy date,
21: io_earliest_sched_date in out nocopy date)
22: as
23: l_bepname iby_bepinfo.name%type;
24: l_leadtime iby_bepinfo.leadtime%type;
25: l_holidayfile iby_bepinfo.holidayfile%type;
26: l_blockstr varchar2(1000);
27: l_cursorId integer;

Line 24: l_leadtime iby_bepinfo.leadtime%type;

20: io_schedule_date in out nocopy date,
21: io_earliest_sched_date in out nocopy date)
22: as
23: l_bepname iby_bepinfo.name%type;
24: l_leadtime iby_bepinfo.leadtime%type;
25: l_holidayfile iby_bepinfo.holidayfile%type;
26: l_blockstr varchar2(1000);
27: l_cursorId integer;
28: l_dummy integer;

Line 25: l_holidayfile iby_bepinfo.holidayfile%type;

21: io_earliest_sched_date in out nocopy date)
22: as
23: l_bepname iby_bepinfo.name%type;
24: l_leadtime iby_bepinfo.leadtime%type;
25: l_holidayfile iby_bepinfo.holidayfile%type;
26: l_blockstr varchar2(1000);
27: l_cursorId integer;
28: l_dummy integer;
29: /*

Line 32: cursor bepinfo ( ci_bepid iby_bepinfo.bepid%type) is

28: l_dummy integer;
29: /*
30: ** Cursor to get the BEP name and leadtime.
31: */
32: cursor bepinfo ( ci_bepid iby_bepinfo.bepid%type) is
33: select name, leadtime, upper(holidayfile)
34: from iby_bepinfo
35: where bepid = ci_bepid;
36: begin

Line 34: from iby_bepinfo

30: ** Cursor to get the BEP name and leadtime.
31: */
32: cursor bepinfo ( ci_bepid iby_bepinfo.bepid%type) is
33: select name, leadtime, upper(holidayfile)
34: from iby_bepinfo
35: where bepid = ci_bepid;
36: begin
37: if ( bepinfo%isopen ) then
38: close bepinfo;