APPS.AR_ADJVALIDATE_PVT dependencies on AR_SYSTEM_PARAMETERS

Line 226: l_set_of_books_id ar_system_parameters.set_of_books_id%type;

222:
223: PROCEDURE Cache_Gl_Periods (p_return_status IN OUT NOCOPY VARCHAR2 )
224: IS
225:
226: l_set_of_books_id ar_system_parameters.set_of_books_id%type;
227:
228: CURSOR l_periods_csr IS
229: SELECT trunc(g.start_date) start_date,
230: trunc(g.end_date) end_date

Line 255: FROM ar_system_parameters ;

251:
252: BEGIN
253: SELECT set_of_books_id
254: INTO l_set_of_books_id
255: FROM ar_system_parameters ;
256: EXCEPTION
257: WHEN NO_DATA_FOUND THEN
258: IF PG_DEBUG in ('Y', 'C') THEN
259: arp_util.debug('Cache_Gl_Periods: ' || 'No Open/Future Enterable GL periods exist',G_MSG_HIGH);

Line 2588: l_set_of_books_id AR_SYSTEM_PARAMETERS.SET_OF_BOOKS_ID%TYPE ;

2584:
2585: l_index number;
2586: l_found_flag BOOLEAN;
2587: l_count number ;
2588: l_set_of_books_id AR_SYSTEM_PARAMETERS.SET_OF_BOOKS_ID%TYPE ;
2589:
2590: BEGIN
2591:
2592: IF PG_DEBUG in ('Y', 'C') THEN

Line 2654: from ar_system_parameters;

2650: THEN
2651:
2652: select set_of_books_id
2653: into l_set_of_books_id
2654: from ar_system_parameters;
2655:
2656: l_count := 0 ;
2657:
2658: SELECT count(*)