[Home] [Help]
1: PACKAGE BODY XLA_FLEX_UTIL AS
2: /* $Header: xlauflex.pkb 120.1 2004/02/13 22:55:21 weshen noship $ */
3:
4: CURSOR flex_segments_csr(p_chart_of_accounts_id NUMBER)
5: IS
22: AND enabled_flag = 'Y'
23: AND id_flex_num = c_chartOfAccountsID
24: ORDER BY segment_num;
25:
26: l_segmentinfo XLA_FLEX_UTIL.t_segmentinfo;
27: l_rownum NUMBER;
28: BEGIN
29: l_rownum := 0;
30: FOR segment_rec IN c_getsegmentnum(p_chartofaccountsid) LOOP
464: app_exception.raise_exception;
465:
466: END get_segment_number;
467:
468: END XLA_FLEX_UTIL;