APPS.OKI_LOAD_SGR_PVT dependencies on OKI_UTL_PVT

Line 624: FOR rec_g_glpr_csr IN oki_utl_pvt.g_glpr_csr(

620:
621: l_loc := 'Looping through valid periods.' ;
622: << g_glpr_csr_loop >>
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) ;

Line 1706: FOR rec_g_glpr_csr IN oki_utl_pvt.g_glpr_csr(

1702:
1703: l_loc := 'Looping through valid periods.' ;
1704: << g_glpr_csr_loop >>
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) ;

Line 2619: FOR rec_g_glpr_csr IN oki_utl_pvt.g_glpr_csr(

2615: l_retcode := '0';
2616:
2617: << g_glpr_csr_loop >>
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) ;

Line 3694: FOR rec_g_glpr_csr IN oki_utl_pvt.g_glpr_csr(

3690:
3691: l_loc := 'Looping through valid periods.' ;
3692: << g_glpr_csr_loop >>
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) ;