334:
335: -- Location within the program before the error was encountered.
336: l_loc VARCHAR2(100) ;
337:
338: -- Holds the truncated start and end dates from gl_periods
339: l_glpr_start_date DATE ;
340: l_glpr_end_date DATE ;
341:
342: -- Cusor declaration
444: -- Loop through all the periods
445: FOR rec_g_glpr_csr IN oki_utl_pvt.g_glpr_csr(
446: p_period_set_name, p_period_type, p_summary_build_date ) LOOP
447:
448: -- Get the truncated gl_periods start and end dates
449: l_glpr_start_date := trunc(rec_g_glpr_csr.start_date );
450: l_glpr_end_date := trunc(rec_g_glpr_csr.end_date );
451:
452: -- Re-initialize the amounts before calculating
601:
602: -- Location within the program before the error was encountered.
603: l_loc VARCHAR2(100) ;
604:
605: -- Holds the truncated start and end dates from gl_periods
606: l_glpr_start_date DATE ;
607: l_glpr_end_date DATE ;
608:
609: -- Cusor declaration
692: -- Loop through all the periods
693: FOR rec_g_glpr_csr IN oki_utl_pvt.g_glpr_csr(
694: p_period_set_name, p_period_type, p_summary_build_date ) LOOP
695:
696: -- Get the truncated gl_periods start and end dates
697: l_glpr_start_date := trunc(rec_g_glpr_csr.start_date );
698: l_glpr_end_date := trunc(rec_g_glpr_csr.end_date );
699:
700: -- Re-initialize the amounts before calculating
850:
851: -- Location within the program before the error was encountered.
852: l_loc VARCHAR2(100) ;
853:
854: -- Holds the truncated start and end dates from gl_periods
855: l_glpr_start_date DATE ;
856: l_glpr_end_date DATE ;
857:
858: -- Cusor declaration
938: -- Loop through all the periods
939: FOR rec_g_glpr_csr IN oki_utl_pvt.g_glpr_csr(
940: p_period_set_name, p_period_type, p_summary_build_date ) LOOP
941:
942: -- Get the truncated gl_periods start and end dates
943: l_glpr_start_date := trunc(rec_g_glpr_csr.start_date );
944: l_glpr_end_date := trunc(rec_g_glpr_csr.end_date );
945:
946: -- Re-initialize the amounts before calculating