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_PERIODICITIES_PUB dependencies on BSC_SYS_PERIODICITIES

Line 471: l_Dim_Object_SN BSC_SYS_PERIODICITIES.SHORT_NAME%TYPE;

467: ,x_Return_Status OUT NOCOPY VARCHAR2
468: ,x_Msg_Count OUT NOCOPY NUMBER
469: ,x_Msg_Data OUT NOCOPY VARCHAR2
470: ) IS
471: l_Dim_Object_SN BSC_SYS_PERIODICITIES.SHORT_NAME%TYPE;
472: l_Dimension_SN BSC_SYS_CALENDARS_B.SHORT_NAME%TYPE;
473: l_Periodicity_View_Name VARCHAR2(30);
474: l_dim_name BSC_SYS_CALENDARS_VL.NAME%TYPE;
475: l_dim_obj_name BSC_SYS_PERIODICITIES_VL.NAME%TYPE;

Line 475: l_dim_obj_name BSC_SYS_PERIODICITIES_VL.NAME%TYPE;

471: l_Dim_Object_SN BSC_SYS_PERIODICITIES.SHORT_NAME%TYPE;
472: l_Dimension_SN BSC_SYS_CALENDARS_B.SHORT_NAME%TYPE;
473: l_Periodicity_View_Name VARCHAR2(30);
474: l_dim_name BSC_SYS_CALENDARS_VL.NAME%TYPE;
475: l_dim_obj_name BSC_SYS_PERIODICITIES_VL.NAME%TYPE;
476: l_regions VARCHAR2(32000);
477:
478: CURSOR c_Delete_View IS
479: SELECT L.LEVEL_VALUES_VIEW_NAME

Line 516: FROM bsc_sys_periodicities_vl c

512: WHERE c.short_name = l_Dimension_SN;
513:
514: SELECT c.name
515: INTO l_dim_obj_name
516: FROM bsc_sys_periodicities_vl c
517: WHERE c.short_name = l_Dim_Object_SN;
518:
519: FND_MESSAGE.SET_NAME('BIS','BIS_DIM_OBJ_RPTASSOC_ERROR');
520: FND_MESSAGE.SET_TOKEN('DIM_NAME', l_dim_obj_name);

Line 685: l_Periodicity_Name BSC_SYS_PERIODICITIES_TL.NAME%TYPE;

681: WHERE P.PERIODICITY_ID = p_Periodicities_Rec_Type.Periodicity_Id
682: AND K.INDICATOR = P.INDICATOR;
683:
684:
685: l_Periodicity_Name BSC_SYS_PERIODICITIES_TL.NAME%TYPE;
686: l_Is_Name_Unique VARCHAR2(1);
687: l_Max_Periodicities NUMBER;
688: l_Count NUMBER;
689: l_Is_Circular VARCHAR2(3);

Line 751: FROM BSC_SYS_PERIODICITIES P

747: END IF;
748:
749: -- Validation#2
750: SELECT COUNT(1) INTO l_Count
751: FROM BSC_SYS_PERIODICITIES P
752: WHERE P.PERIODICITY_ID = p_Periodicities_Rec_Type.Periodicity_id;
753:
754: IF (l_Count <> 0) THEN
755: FND_MESSAGE.SET_NAME('BSC','BSC_PERIODICITY_ID_UNIQUE');

Line 780: FROM BSC_SYS_PERIODICITIES_VL P

776:
777: IF (p_Action_Type = BSC_PERIODS_UTILITY_PKG.C_UPDATE) THEN
778:
779: SELECT COUNT(1) INTO l_Count
780: FROM BSC_SYS_PERIODICITIES_VL P
781: WHERE P.NAME = p_Periodicities_Rec_Type.Name
782: AND P.CALENDAR_ID = p_Periodicities_Rec_Type.Calendar_Id
783: AND P.PERIODICITY_ID <> p_Periodicities_Rec_Type.Periodicity_id;
784:

Line 800: FROM BSC_SYS_PERIODICITIES B

796:
797: -- Do not allow update of Base Periodicities .
798: -- Change Periodicity_Type to Custom_Code.
799: SELECT COUNT(1) INTO l_Count
800: FROM BSC_SYS_PERIODICITIES B
801: WHERE B.PERIODICITY_ID = p_Periodicities_Rec_Type.Periodicity_id
802: AND B.CALENDAR_ID = p_Periodicities_Rec_Type.Calendar_Id
803: AND B.PERIODICITY_TYPE <> 0;
804:

Line 827: FROM BSC_SYS_PERIODICITIES B

823: ELSIF (p_Action_Type = BSC_PERIODS_UTILITY_PKG.C_DELETE) THEN
824:
825: -- You cannot delete a BASE Periodicity
826: SELECT COUNT(1) INTO l_Count
827: FROM BSC_SYS_PERIODICITIES B
828: WHERE B.PERIODICITY_ID = p_Periodicities_Rec_Type.Periodicity_id
829: AND B.CALENDAR_ID = p_Periodicities_Rec_Type.Calendar_Id
830: AND B.PERIODICITY_TYPE <> 0;
831:

Line 844: FROM BSC_SYS_PERIODICITIES B

840:
841: IF(p_disable_period_val_flag=FND_API.G_FALSE)THEN
842:
843: SELECT COUNT(1) INTO l_Count
844: FROM BSC_SYS_PERIODICITIES B
845: WHERE TRIM(B.SOURCE) = TO_CHAR(p_Periodicities_Rec_Type.Periodicity_id);
846:
847: IF (l_Count <> 0) THEN
848: FND_MESSAGE.SET_NAME('BSC','BSC_NO_DEL_IS_BASE_PER');

Line 931: l_Base_Periodicity_Source BSC_SYS_PERIODICITIES.SOURCE%TYPE;

927: ,x_Msg_Data OUT NOCOPY VARCHAR2
928: ) IS
929:
930: l_Calendar_Id BSC_SYS_CALENDARS_B.CALENDAR_ID%TYPE;
931: l_Base_Periodicity_Source BSC_SYS_PERIODICITIES.SOURCE%TYPE;
932: BEGIN
933: FND_MSG_PUB.Initialize;
934: x_Return_Status := FND_API.G_RET_STS_SUCCESS;
935: x_Periodicities_Rec_Type := p_Periodicities_Rec_Type;

Line 1432: UPDATE bsc_sys_periodicities_tl

1428: ) IS
1429: BEGIN
1430: x_return_status := FND_API.G_RET_STS_SUCCESS;
1431:
1432: UPDATE bsc_sys_periodicities_tl
1433: SET name = NVL(p_Periodicities_Rec_Type.name,name)
1434: , source_lang = USERENV('LANG')
1435: WHERE USERENV('LANG') IN (LANGUAGE, SOURCE_LANG)
1436: AND periodicity_id = p_Periodicities_Rec_Type.Periodicity_Id;

Line 1455: l_name bsc_sys_periodicities_tl.name%TYPE;

1451: ,x_Msg_Count OUT NOCOPY NUMBER
1452: ,x_Msg_Data OUT NOCOPY VARCHAR2
1453: ) IS
1454: l_count NUMBER;
1455: l_name bsc_sys_periodicities_tl.name%TYPE;
1456: BEGIN
1457: x_return_status := FND_API.G_RET_STS_SUCCESS;
1458:
1459: UPDATE bsc_sys_periodicities

Line 1459: UPDATE bsc_sys_periodicities

1455: l_name bsc_sys_periodicities_tl.name%TYPE;
1456: BEGIN
1457: x_return_status := FND_API.G_RET_STS_SUCCESS;
1458:
1459: UPDATE bsc_sys_periodicities
1460: SET num_of_periods = p_Periodicities_Rec_Type.Num_Of_Periods,
1461: source = p_Periodicities_Rec_Type.Source,
1462: num_of_subperiods = p_Periodicities_Rec_Type.Num_Of_Subperiods,
1463: period_col_name = p_Periodicities_Rec_Type.Period_Col_Name,

Line 1474: INSERT INTO bsc_sys_periodicities(

1470: periodicity_type = p_Periodicities_Rec_Type.Periodicity_Type
1471: WHERE periodicity_id = p_Periodicities_Rec_Type.Periodicity_Id;
1472:
1473: IF (SQL%NOTFOUND) THEN
1474: INSERT INTO bsc_sys_periodicities(
1475: periodicity_id,
1476: num_of_periods,
1477: source,
1478: num_of_subperiods,

Line 1513: UPDATE bsc_sys_periodicities_tl

1509: l_name := p_Periodicities_Rec_Type.name;
1510:
1511: END IF;
1512:
1513: UPDATE bsc_sys_periodicities_tl
1514: SET name = l_name,
1515: SOURCE_LANG = userenv('LANG')
1516: WHERE periodicity_id = p_Periodicities_Rec_Type.Periodicity_Id
1517: AND userenv('LANG') IN (LANGUAGE, SOURCE_LANG);

Line 1520: INSERT INTO bsc_sys_periodicities_tl (

1516: WHERE periodicity_id = p_Periodicities_Rec_Type.Periodicity_Id
1517: AND userenv('LANG') IN (LANGUAGE, SOURCE_LANG);
1518:
1519: IF (SQL%NOTFOUND) THEN
1520: INSERT INTO bsc_sys_periodicities_tl (
1521: PERIODICITY_ID,
1522: NAME,
1523: LANGUAGE,
1524: SOURCE_LANG,

Line 1544: FROM bsc_sys_periodicities_tl t

1540: FROM FND_LANGUAGES L
1541: WHERE L.INSTALLED_FLAG in ('I', 'B')
1542: AND NOT EXISTS
1543: (SELECT NULL
1544: FROM bsc_sys_periodicities_tl t
1545: WHERE periodicity_id = p_Periodicities_Rec_Type.Periodicity_Id
1546: AND t.LANGUAGE = L.LANGUAGE_CODE);
1547:
1548: END IF;