[Home] [Help]
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);
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;
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
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);
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,
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;