APPS.BSC_MO_DOC_PKG dependencies on BSC_SYS_PERIODICITIES

Line 24: , BSC_SYS_PERIODICITIES_VL per

20: PROCEDURE InitializePerCalMap IS
21: CURSOR perCal is
22: SELECT periodicity_id, per.name periodicity_name, cal.calendar_id, cal.NAME calendar_name
23: FROM BSC_SYS_CALENDARS_VL cal
24: , BSC_SYS_PERIODICITIES_VL per
25: WHERE per.CALENDAR_ID = cal.calendar_id
26: order by periodicity_id;
27: --TYPE l_record IS perCal%ROWTYPE;
28: TYPE l_table IS TABLE OF perCal%ROWTYPE;

Line 201: SELECT NAME FROM BSC_SYS_PERIODICITIES_VL

197: -- Periodicity: periodicity code
198: --****************************************************************************
199: Function GetPeriodicityName(Periodicity IN NUMBER) RETURN VARCHAR2 IS
200: CURSOR c1 IS
201: SELECT NAME FROM BSC_SYS_PERIODICITIES_VL
202: WHERE PERIODICITY_ID = Periodicity;
203: l_name varchar2(100) := null ;
204:
205: BEGIN

Line 235: FROM BSC_SYS_PERIODICITIES_VL

231: CURSOR c1 (p1 NUMBER) IS
232: SELECT NAME FROM BSC_SYS_CALENDARS_VL
233: WHERE CALENDAR_ID = (
234: SELECT CALENDAR_ID
235: FROM BSC_SYS_PERIODICITIES_VL
236: WHERE PERIODICITY_ID = p1);
237:
238: l_name VARCHAR2(100);
239: BEGIN

Line 520: -- It is read from BSC_SYS_PERIODICITIES table

516: -- GetMaxSubPeriodUsr
517: --
518: -- DESCRIPTION:
519: -- Returns the number of subperiods of the given periodicity.
520: -- It is read from BSC_SYS_PERIODICITIES table
521: --
522: -- PARAMETERS:
523: -- Periodicity: Periodicity code
524: --****************************************************************************

Line 529: FROM BSC_SYS_PERIODICITIES

525: Function GetMaxSubPeriodUsr(Periodicity IN NUMBER) RETURN NUMBER IS
526:
527: CURSOR c1 IS
528: SELECT NUM_OF_SUBPERIODS
529: FROM BSC_SYS_PERIODICITIES
530: WHERE PERIODICITY_ID = Periodicity;
531: l_num NUMBER := null;
532: BEGIn
533: OPEN c1;

Line 553: -- It is read from BSC_SYS_PERIODICITIES table

549: -- GetMaxPeriod
550: --
551: -- DESCRIPTION:
552: -- Return the number of periods of the given periodicity.
553: -- It is read from BSC_SYS_PERIODICITIES table
554: --
555: -- PARAMETERS:
556: -- Periodicity: Periodicity code
557: --****************************************************************************

Line 561: FROM BSC_SYS_PERIODICITIES

557: --****************************************************************************
558: Function GetMaxPeriod(Periodicity IN NUMBER) RETURN NUMBER IS
559: CURSOR c1 IS
560: SELECT NUM_OF_PERIODS
561: FROM BSC_SYS_PERIODICITIES
562: WHERE PERIODICITY_ID = Periodicity;
563: l_num NUMBER;
564: BEGIN
565: OPEN c1;