APPS.AR_ADJVALIDATE_PUB dependencies on AR_SYSTEM_PARAMETERS

Line 286: l_set_of_books_id ar_system_parameters.set_of_books_id%type;

282:
283: PROCEDURE Cache_Gl_Periods (p_return_status IN OUT NOCOPY VARCHAR2 )
284: IS
285:
286: l_set_of_books_id ar_system_parameters.set_of_books_id%type;
287:
288: CURSOR l_periods_csr IS
289: SELECT trunc(g.start_date) start_date,
290: trunc(g.end_date) end_date

Line 314: FROM ar_system_parameters ;

310: p_return_status := FND_API.G_RET_STS_SUCCESS;
311:
312: SELECT set_of_books_id
313: INTO l_set_of_books_id
314: FROM ar_system_parameters ;
315:
316: l_index := 0 ;
317: FOR l_temp_rec IN l_periods_csr LOOP
318: l_index := l_index + 1;

Line 2135: l_set_of_books_id AR_SYSTEM_PARAMETERS.SET_OF_BOOKS_ID%TYPE ;

2131:
2132: l_index number;
2133: l_found_flag BOOLEAN;
2134: l_count number ;
2135: l_set_of_books_id AR_SYSTEM_PARAMETERS.SET_OF_BOOKS_ID%TYPE ;
2136:
2137: BEGIN
2138:
2139: IF PG_DEBUG in ('Y', 'C') THEN

Line 2203: from ar_system_parameters;

2199: THEN
2200:
2201: select set_of_books_id
2202: into l_set_of_books_id
2203: from ar_system_parameters;
2204:
2205: l_count := 0 ;
2206:
2207: SELECT count(*)