eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.BSC_PERIODS_UTILITY_PKG dependencies on BSC_SYS_PERIODICITIES

Line 66: FROM BSC_SYS_PERIODICITIES_VL P

62: BEGIN
63: l_Count := 0;
64:
65: SELECT COUNT(1) INTO l_Count
66: FROM BSC_SYS_PERIODICITIES_VL P
67: WHERE P.CALENDAR_ID = p_Calendar_Id
68: AND UPPER(P.NAME) = UPPER(p_Periodicity_Name);
69:
70:

Line 131: FROM BSC_SYS_PERIODICITIES P

127: l_Count NUMBER;
128: BEGIN
129: SELECT COUNT(1)
130: INTO l_Count
131: FROM BSC_SYS_PERIODICITIES P
132: WHERE P.CALENDAR_ID = p_Calendar_Id
133: AND P.CUSTOM_CODE <> BSC_PERIODS_UTILITY_PKG.C_BASE_PERIODICITY_TYPE;
134:
135: RETURN l_Count;

Line 146: l_Custom_DB_Column BSC_SYS_PERIODICITIES.DB_COLUMN_NAME%TYPE;

142: FUNCTION Get_Next_Cust_Period_DB_Column (
143: p_Calendar_Id IN NUMBER
144: ) RETURN VARCHAR2 IS
145: l_Max_Custom_Id NUMBER;
146: l_Custom_DB_Column BSC_SYS_PERIODICITIES.DB_COLUMN_NAME%TYPE;
147: BEGIN
148: SELECT NVL(MAX(TO_NUMBER(SUBSTR(P.DB_COLUMN_NAME, LENGTH(C_CUSTOM_DB_COL_PREFIX)+1))), 0)
149: INTO l_Max_Custom_Id
150: FROM BSC_SYS_PERIODICITIES P

Line 150: FROM BSC_SYS_PERIODICITIES P

146: l_Custom_DB_Column BSC_SYS_PERIODICITIES.DB_COLUMN_NAME%TYPE;
147: BEGIN
148: SELECT NVL(MAX(TO_NUMBER(SUBSTR(P.DB_COLUMN_NAME, LENGTH(C_CUSTOM_DB_COL_PREFIX)+1))), 0)
149: INTO l_Max_Custom_Id
150: FROM BSC_SYS_PERIODICITIES P
151: WHERE P.CUSTOM_CODE > 0
152: AND P.CALENDAR_ID = P_CALENDAR_ID;
153:
154: l_Custom_DB_Column := C_CUSTOM_DB_COL_PREFIX || (l_Max_Custom_Id+1);

Line 179: FROM BSC_SYS_PERIODICITIES P;

175: EXCEPTION
176: WHEN OTHERS THEN
177: SELECT NVL(MAX(P.PERIODICITY_ID)+1, 0)
178: INTO l_Next_Number
179: FROM BSC_SYS_PERIODICITIES P;
180:
181: RETURN l_Next_Number;
182: END Get_Next_Periodicity_Id;
183:

Line 214: FROM BSC_SYS_PERIODICITIES B

210: l_Count NUMBER;
211: BEGIN
212: SELECT COUNT(1)
213: INTO l_Count
214: FROM BSC_SYS_PERIODICITIES B
215: WHERE B.PERIODICITY_ID = p_Periodicity_Id
216: AND B.CALENDAR_ID = p_Calendar_Id;
217:
218: IF (l_Count = 1) THEN

Line 234: l_Source_Column BSC_SYS_PERIODICITIES.SOURCE%TYPE;

230: FUNCTION Get_Periodicity_Source (
231: p_Periodicity_Id IN NUMBER
232: ) RETURN VARCHAR2
233: IS
234: l_Source_Column BSC_SYS_PERIODICITIES.SOURCE%TYPE;
235: BEGIN
236: SELECT B.SOURCE
237: INTO l_Source_Column
238: FROM BSC_SYS_PERIODICITIES B

Line 238: FROM BSC_SYS_PERIODICITIES B

234: l_Source_Column BSC_SYS_PERIODICITIES.SOURCE%TYPE;
235: BEGIN
236: SELECT B.SOURCE
237: INTO l_Source_Column
238: FROM BSC_SYS_PERIODICITIES B
239: WHERE B.PERIODICITY_ID = p_Periodicity_Id;
240:
241: RETURN l_Source_Column;
242:

Line 354: FROM bsc_sys_periodicities

350: l_Periodicity_Id NUMBER;
351: BEGIN
352: SELECT periodicity_type
353: INTO l_Periodicity_Id
354: FROM bsc_sys_periodicities
355: WHERE periodicity_id = p_Base_Periodicity_Id;
356:
357: IF(l_Periodicity_Id = 9) THEN
358: l_Is_Daily := TRUE;

Line 370: l_Short_Name BSC_SYS_PERIODICITIES.SHORT_NAME%TYPE;

366:
367: FUNCTION Get_Periodicity_Short_Name (
368: p_Periodicity_Id IN NUMBER
369: ) RETURN VARCHAR2 IS
370: l_Short_Name BSC_SYS_PERIODICITIES.SHORT_NAME%TYPE;
371: BEGIN
372: SELECT P.SHORT_NAME INTO l_Short_Name
373: FROM BSC_SYS_PERIODICITIES P
374: WHERE P.PERIODICITY_ID = p_Periodicity_Id;

Line 373: FROM BSC_SYS_PERIODICITIES P

369: ) RETURN VARCHAR2 IS
370: l_Short_Name BSC_SYS_PERIODICITIES.SHORT_NAME%TYPE;
371: BEGIN
372: SELECT P.SHORT_NAME INTO l_Short_Name
373: FROM BSC_SYS_PERIODICITIES P
374: WHERE P.PERIODICITY_ID = p_Periodicity_Id;
375:
376: RETURN l_Short_Name;
377:

Line 392: FROM BSC_SYS_PERIODICITIES

388: l_no_Periods NUMBER;
389: BEGIN
390: SELECT NUM_OF_PERIODS
391: INTO l_No_Periods
392: FROM BSC_SYS_PERIODICITIES
393: WHERE PERIODICITY_ID = p_Base_Periodicity_Id;
394:
395: RETURN l_No_Periods;
396: EXCEPTION

Line 445: l_Period_DB_Col BSC_SYS_PERIODICITIES.DB_COLUMN_NAME%TYPE;

441: , p_Period_id IN NUMBER
442: , p_Year IN NUMBER
443: ) RETURN DATE IS
444: l_Sql VARCHAR2(1000);
445: l_Period_DB_Col BSC_SYS_PERIODICITIES.DB_COLUMN_NAME%TYPE;
446: l_Date DATE;
447: l_Cal_Yr BSC_DB_CALENDAR.CALENDAR_YEAR%TYPE;
448: l_Cal_Mn BSC_DB_CALENDAR.CALENDAR_MONTH%TYPE;
449: l_Cal_Dy BSC_DB_CALENDAR.CALENDAR_DAY%TYPE;

Line 485: l_Period_DB_Col BSC_SYS_PERIODICITIES.DB_COLUMN_NAME%TYPE;

481: , p_Period_id IN NUMBER
482: , p_Year IN NUMBER
483: ) RETURN DATE IS
484: l_Sql VARCHAR2(1000);
485: l_Period_DB_Col BSC_SYS_PERIODICITIES.DB_COLUMN_NAME%TYPE;
486: l_Date DATE;
487: l_Cal_Yr BSC_DB_CALENDAR.CALENDAR_YEAR%TYPE;
488: l_Cal_Mn BSC_DB_CALENDAR.CALENDAR_MONTH%TYPE;
489: l_Cal_Dy BSC_DB_CALENDAR.CALENDAR_DAY%TYPE;

Line 520: l_Period_DB_Col BSC_SYS_PERIODICITIES.DB_COLUMN_NAME%TYPE;

516:
517: FUNCTION Get_Periodicity_Db_Col (
518: p_Periodicity_Id IN NUMBER
519: ) RETURN VARCHAR2 IS
520: l_Period_DB_Col BSC_SYS_PERIODICITIES.DB_COLUMN_NAME%TYPE;
521: BEGIN
522: SELECT P.DB_COLUMN_NAME
523: INTO l_Period_Db_Col
524: FROM BSC_SYS_PERIODICITIES P

Line 524: FROM BSC_SYS_PERIODICITIES P

520: l_Period_DB_Col BSC_SYS_PERIODICITIES.DB_COLUMN_NAME%TYPE;
521: BEGIN
522: SELECT P.DB_COLUMN_NAME
523: INTO l_Period_Db_Col
524: FROM BSC_SYS_PERIODICITIES P
525: WHERE P.PERIODICITY_ID = p_Periodicity_Id;
526:
527: RETURN l_Period_Db_Col;
528:

Line 564: l_Name BSC_SYS_PERIODICITIES_VL.NAME%TYPE;

560: -- added for Bug#4574115
561: FUNCTION Get_Periodicity_Name (
562: p_Periodicity_Id IN NUMBER
563: ) RETURN VARCHAR2 IS
564: l_Name BSC_SYS_PERIODICITIES_VL.NAME%TYPE;
565: BEGIN
566: SELECT B.NAME
567: INTO l_Name
568: FROM BSC_SYS_PERIODICITIES_VL B

Line 568: FROM BSC_SYS_PERIODICITIES_VL B

564: l_Name BSC_SYS_PERIODICITIES_VL.NAME%TYPE;
565: BEGIN
566: SELECT B.NAME
567: INTO l_Name
568: FROM BSC_SYS_PERIODICITIES_VL B
569: WHERE B.PERIODICITY_ID = p_Periodicity_Id;
570:
571: RETURN l_Name;
572:

Line 581: l_Periodicity_Short_Name BSC_SYS_PERIODICITIES_VL.SHORT_NAME%TYPE;

577:
578: FUNCTION Get_Daily_Periodicity_Sht_Name(
579: p_Calendar_Id IN NUMBER
580: ) RETURN VARCHAR2 IS
581: l_Periodicity_Short_Name BSC_SYS_PERIODICITIES_VL.SHORT_NAME%TYPE;
582:
583: CURSOR c_CalendarPeriodicities IS
584: SELECT PERIODICITY_ID,
585: SHORT_NAME

Line 586: FROM BSC_SYS_PERIODICITIES_VL

582:
583: CURSOR c_CalendarPeriodicities IS
584: SELECT PERIODICITY_ID,
585: SHORT_NAME
586: FROM BSC_SYS_PERIODICITIES_VL
587: WHERE CALENDAR_id = p_Calendar_Id;
588:
589: BEGIN
590: FOR prdcty IN c_CalendarPeriodicities LOOP

Line 616: l_Short_Name BSC_SYS_PERIODICITIES.SHORT_NAME%TYPE;

612: FUNCTION generate_Period_Short_Name (
613: p_Calendar_Id IN NUMBER
614: ,p_Period_Id IN NUMBER
615: )RETURN VARCHAR2 IS
616: l_Short_Name BSC_SYS_PERIODICITIES.SHORT_NAME%TYPE;
617: l_Flag BOOLEAN;
618: l_Temp_Var BIS_LEVELS.SHORT_NAME%TYPE;
619: l_Count NUMBER;
620: l_alias VARCHAR2(4);

Line 775: FROM BSC_SYS_PERIODICITIES_VL P

771: l_Data_Label VARCHAR2(100);
772:
773: CURSOR c_Get_Calendar_ID IS
774: SELECT P.CALENDAR_ID
775: FROM BSC_SYS_PERIODICITIES_VL P
776: WHERE P.SHORT_NAME = p_Dimension_Object_Short_Name;
777:
778: BEGIN
779: