899: CLOSE cPeriods;
900:
901: If cRow1.TABLE_TYPE = 0 Then
902: --input table
903: NomPeriodicity := BSC_MO_DOC_PKG.GetPeriodicityName(cRow1.PERIODICITY_ID);
904: NomPeriodicity := NomPeriodicity || ' (' || BSC_MO_DOC_PKG.GetPeriodicityCalendarName(cRow1.PERIODICITY_ID) || ')';
905: NomCampoPeriod := BSC_MO_DB_PKG.GetPeriodColumnName(cRow1.PERIODICITY_ID);
906: MaxPeriod := BSC_MO_DOC_PKG.GetMaxPeriod(cRow1.PERIODICITY_ID);
907: NomCampoSubPeriod := BSC_MO_DB_PKG.GetSubperiodColumnName(cRow1.PERIODICITY_ID);
900:
901: If cRow1.TABLE_TYPE = 0 Then
902: --input table
903: NomPeriodicity := BSC_MO_DOC_PKG.GetPeriodicityName(cRow1.PERIODICITY_ID);
904: NomPeriodicity := NomPeriodicity || ' (' || BSC_MO_DOC_PKG.GetPeriodicityCalendarName(cRow1.PERIODICITY_ID) || ')';
905: NomCampoPeriod := BSC_MO_DB_PKG.GetPeriodColumnName(cRow1.PERIODICITY_ID);
906: MaxPeriod := BSC_MO_DOC_PKG.GetMaxPeriod(cRow1.PERIODICITY_ID);
907: NomCampoSubPeriod := BSC_MO_DB_PKG.GetSubperiodColumnName(cRow1.PERIODICITY_ID);
908: MaxSubPeriod := BSC_MO_DOC_PKG.GetMaxSubPeriodUsr(cRow1.PERIODICITY_ID);
902: --input table
903: NomPeriodicity := BSC_MO_DOC_PKG.GetPeriodicityName(cRow1.PERIODICITY_ID);
904: NomPeriodicity := NomPeriodicity || ' (' || BSC_MO_DOC_PKG.GetPeriodicityCalendarName(cRow1.PERIODICITY_ID) || ')';
905: NomCampoPeriod := BSC_MO_DB_PKG.GetPeriodColumnName(cRow1.PERIODICITY_ID);
906: MaxPeriod := BSC_MO_DOC_PKG.GetMaxPeriod(cRow1.PERIODICITY_ID);
907: NomCampoSubPeriod := BSC_MO_DB_PKG.GetSubperiodColumnName(cRow1.PERIODICITY_ID);
908: MaxSubPeriod := BSC_MO_DOC_PKG.GetMaxSubPeriodUsr(cRow1.PERIODICITY_ID);
909:
910: Else
904: NomPeriodicity := NomPeriodicity || ' (' || BSC_MO_DOC_PKG.GetPeriodicityCalendarName(cRow1.PERIODICITY_ID) || ')';
905: NomCampoPeriod := BSC_MO_DB_PKG.GetPeriodColumnName(cRow1.PERIODICITY_ID);
906: MaxPeriod := BSC_MO_DOC_PKG.GetMaxPeriod(cRow1.PERIODICITY_ID);
907: NomCampoSubPeriod := BSC_MO_DB_PKG.GetSubperiodColumnName(cRow1.PERIODICITY_ID);
908: MaxSubPeriod := BSC_MO_DOC_PKG.GetMaxSubPeriodUsr(cRow1.PERIODICITY_ID);
909:
910: Else
911: --system table
912: NomPeriodicity := BSC_MO_DOC_PKG.GetPeriodicityName(cRow1.PERIODICITY_ID) ;
908: MaxSubPeriod := BSC_MO_DOC_PKG.GetMaxSubPeriodUsr(cRow1.PERIODICITY_ID);
909:
910: Else
911: --system table
912: NomPeriodicity := BSC_MO_DOC_PKG.GetPeriodicityName(cRow1.PERIODICITY_ID) ;
913: NomPeriodicity := NomPeriodicity || ' (' || BSC_MO_DOC_PKG.GetPeriodicityCalendarName(cRow1.PERIODICITY_ID) || ')';
914: NomCampoPeriod := 'PERIOD';
915: MaxPeriod := BSC_MO_DOC_PKG.GetMaxPeriod(cRow1.PERIODICITY_ID);
916: NomCampoSubPeriod := null;
909:
910: Else
911: --system table
912: NomPeriodicity := BSC_MO_DOC_PKG.GetPeriodicityName(cRow1.PERIODICITY_ID) ;
913: NomPeriodicity := NomPeriodicity || ' (' || BSC_MO_DOC_PKG.GetPeriodicityCalendarName(cRow1.PERIODICITY_ID) || ')';
914: NomCampoPeriod := 'PERIOD';
915: MaxPeriod := BSC_MO_DOC_PKG.GetMaxPeriod(cRow1.PERIODICITY_ID);
916: NomCampoSubPeriod := null;
917: MaxSubPeriod := 0;
911: --system table
912: NomPeriodicity := BSC_MO_DOC_PKG.GetPeriodicityName(cRow1.PERIODICITY_ID) ;
913: NomPeriodicity := NomPeriodicity || ' (' || BSC_MO_DOC_PKG.GetPeriodicityCalendarName(cRow1.PERIODICITY_ID) || ')';
914: NomCampoPeriod := 'PERIOD';
915: MaxPeriod := BSC_MO_DOC_PKG.GetMaxPeriod(cRow1.PERIODICITY_ID);
916: NomCampoSubPeriod := null;
917: MaxSubPeriod := 0;
918: End If;
919: