APPS.BSC_METADATA_DESC dependencies on BSC_SYS_PERIODICITIES_VL

Line 393: FROM BSC_SYS_PERIODICITIES_VL A

389: CURSOR c_SYS_Periodicity IS
390: SELECT A.NAME, A.PERIODICITY_TYPE, A.PERIOD_TYPE_ID, A.RECORD_TYPE_ID
391: , A.CALENDAR_ID
392: , B.NAME CALENDAR_NAME , B.FISCAL_YEAR
393: FROM BSC_SYS_PERIODICITIES_VL A
394: , BSC_SYS_CALENDARS_VL B
395: WHERE A.CALENDAR_ID (+) = B.CALENDAR_ID
396: AND A.PERIODICITY_ID = l_periodicity_id;
397:

Line 680: l_not_found_msg2 := '--> ERROR. Objective ID <' ||l_Kpi_Id || '> assigned to invalide periodicity in table BSC_KPI_PERIODICITIES. Periodicity Id <' ||l_periodicity_id || '> not exitst in table BSC_SYS_PERIODICITIES_VL' ;

676: l_not_found_msg := NULL;
677: put_line('-> PERIODICITY_ID is <'||bsc_cd.PERIODICITY_ID ||'> ' );
678: -------------- Sys Periodicites Information.
679: l_periodicity_id := bsc_cd.PERIODICITY_ID;
680: l_not_found_msg2 := '--> ERROR. Objective ID <' ||l_Kpi_Id || '> assigned to invalide periodicity in table BSC_KPI_PERIODICITIES. Periodicity Id <' ||l_periodicity_id || '> not exitst in table BSC_SYS_PERIODICITIES_VL' ;
681: FOR bsc_Per_cd IN c_SYS_Periodicity LOOP
682: l_not_found_msg2 := NULL;
683: put_line('.... PERIODICITY_NAME is <'||bsc_Per_cd.NAME ||'> ' );
684: put_line('.... PERIODICITY_TYPE is <'||bsc_Per_cd.PERIODICITY_TYPE ||'> ' );

Line 692: put_line('...... ERROR. Periodicity Id <'||l_periodicity_id||'> assigned to a invalide Calendar Id in table BSC_SYS_PERIODICITIES_VL . Calendar Id <' || bsc_Per_cd.CALENDAR_ID || '> does not exists IN TABLE BSC_SYS_CALENDARS_VL. ' );

688: IF bsc_Per_cd.CALENDAR_NAME IS NOT NULL THEN
689: put_line('...... CALENDAR_NAME is <'||bsc_Per_cd.CALENDAR_NAME ||'> ' );
690: put_line('...... FISCAL_YEAR is <'||bsc_Per_cd.FISCAL_YEAR ||'> ' );
691: ELSE
692: put_line('...... ERROR. Periodicity Id <'||l_periodicity_id||'> assigned to a invalide Calendar Id in table BSC_SYS_PERIODICITIES_VL . Calendar Id <' || bsc_Per_cd.CALENDAR_ID || '> does not exists IN TABLE BSC_SYS_CALENDARS_VL. ' );
693: END IF;
694: END LOOP;
695: IF (l_not_found_msg2 IS NOT NULL) THEN
696: put_line(l_not_found_msg2);