DBA Data[Home] [Help]

APPS.ARP_AUTOAPPLY_API dependencies on AR_CASH_RECOS_S

Line 203: * Generates the recommendation id from sequence ar_cash_recos_s *

199: /*===========================================================================+
200: * FUNCTION *
201: * GET_NEXT_RECO_ID() *
202: * DESCRIPTION *
203: * Generates the recommendation id from sequence ar_cash_recos_s *
204: * SCOPE - LOCAL *
205: * ARGUMENTS *
206: * IN : p_reco_num - Recommendation Number *
207: * RETURNS NUMBER *

Line 222: SELECT ar_cash_recos_s.nextval

218: RETURN NUMBER IS
219: l_reco_id NUMBER;
220: BEGIN
221: IF p_reco_num = 1 AND NVL(g_prev_reco_num, -1) <> 1 THEN
222: SELECT ar_cash_recos_s.nextval
223: INTO l_reco_id
224: FROM DUAL;
225: g_next_reco_id := l_reco_id;
226: g_prev_reco_num := p_reco_num;

Line 4129: SELECT ar_cash_recos_s.nextval

4125: BEGIN
4126: IF (PG_DEBUG IN ('Y', 'C')) THEN
4127: log('process_single_reco()+');
4128: END IF;
4129: SELECT ar_cash_recos_s.nextval
4130: INTO l_recommendation_id
4131: FROM dual;
4132: l_recommendation_reason := 'AR_AM_INV_THRESHOLD';
4133: l_use_matching_date := p_current_reco(1).use_matching_date;