APPS.OKI_LOAD_SGR_PVT dependencies on GL_PERIODS

Line 429: -- Holds the truncated start and end dates from gl_periods

425:
426: -- Location within the program before the error was encountered.
427: l_loc VARCHAR2(200) ;
428:
429: -- Holds the truncated start and end dates from gl_periods
430: -- Holds the quarter start and end dates
431: l_glpr_qtr_start_date DATE ;
432: l_glpr_qtr_end_date DATE ;
433: -- Holds the prior year summary build date

Line 627: -- Get the truncated gl_periods start and end dates

623: -- Loop through all the periods
624: FOR rec_g_glpr_csr IN oki_utl_pvt.g_glpr_csr(
625: p_period_set_name, p_period_type, p_summary_build_date ) LOOP
626:
627: -- Get the truncated gl_periods start and end dates
628: l_glpr_qtr_start_date := trunc(rec_g_glpr_csr.quarter_start_date) ;
629: l_glpr_qtr_end_date := ADD_MONTHS(l_glpr_qtr_start_date, 3) - 1 ;
630:
631: -- Set the prior year summary build date

Line 1511: -- Holds the truncated start and end dates from gl_periods

1507:
1508: -- Location within the program before the error was encountered.
1509: l_loc VARCHAR2(200) ;
1510:
1511: -- Holds the truncated start and end dates from gl_periods
1512: -- Holds the quarter start and end dates
1513: l_glpr_qtr_start_date DATE ;
1514: l_glpr_qtr_end_date DATE ;
1515: -- Holds the prior year summary build date

Line 1709: -- set the quarter and year gl_periods start and end dates

1705: -- Loop through all the periods
1706: FOR rec_g_glpr_csr IN oki_utl_pvt.g_glpr_csr(
1707: p_period_set_name, p_period_type, p_summary_build_date ) LOOP
1708:
1709: -- set the quarter and year gl_periods start and end dates
1710: l_glpr_qtr_start_date := trunc(rec_g_glpr_csr.quarter_start_date) ;
1711: l_glpr_qtr_end_date := ADD_MONTHS(l_glpr_qtr_start_date, 3) - 1 ;
1712:
1713: -- Set the prior year summary build date

Line 2589: -- Holds the truncated start and end dates from gl_periods

2585:
2586: -- Location within the program before the error was encountered.
2587: l_loc VARCHAR2(200) ;
2588:
2589: -- Holds the truncated start and end dates from gl_periods
2590: -- Holds the quarter start and end dates
2591: l_glpr_qtr_start_date DATE ;
2592: l_glpr_qtr_end_date DATE ;
2593: -- Holds the year start and end dates

Line 2622: -- set the quarter and year gl_periods start and end dates

2618: -- Loop through all the periods
2619: FOR rec_g_glpr_csr IN oki_utl_pvt.g_glpr_csr(
2620: p_period_set_name, p_period_type, p_summary_build_date ) LOOP
2621:
2622: -- set the quarter and year gl_periods start and end dates
2623: l_glpr_qtr_start_date := trunc(rec_g_glpr_csr.quarter_start_date) ;
2624: l_glpr_qtr_end_date := ADD_MONTHS(l_glpr_qtr_start_date, 3) - 1 ;
2625: l_glpr_year_start_date := TRUNC(rec_g_glpr_csr.year_start_date) ;
2626: l_glpr_year_end_date := ADD_MONTHS(TRUNC(rec_g_glpr_csr.year_start_date), 12) - 1 ;

Line 3536: -- Holds the truncated start and end dates from gl_periods

3532:
3533: -- Location within the program before the error was encountered.
3534: l_loc VARCHAR2(200) ;
3535:
3536: -- Holds the truncated start and end dates from gl_periods
3537: -- Holds the quarter start and end dates
3538: l_glpr_qtr_start_date DATE ;
3539: l_glpr_qtr_end_date DATE ;
3540: -- Holds the prior year summary build date

Line 3697: -- set the quarter and year gl_periods start and end dates

3693: -- Loop through all the periods
3694: FOR rec_g_glpr_csr IN oki_utl_pvt.g_glpr_csr(
3695: p_period_set_name, p_period_type, p_summary_build_date ) LOOP
3696:
3697: -- set the quarter and year gl_periods start and end dates
3698: l_glpr_qtr_start_date := trunc(rec_g_glpr_csr.quarter_start_date) ;
3699: l_glpr_qtr_end_date := ADD_MONTHS(l_glpr_qtr_start_date, 3) - 1 ;
3700:
3701: -- Set the prior year summary build date