13: */
14: PROCEDURE get_account_number(p_chart_of_accounts_id IN NUMBER,
15: p_ccid IN NUMBER, p_account_number OUT NOCOPY VARCHAR2) IS
16:
17: CURSOR get_segments_used(coa_id NUMBER,c_flex_code fnd_id_flex_segments.id_flex_code%TYPE ) IS
18: SELECT segment_num, application_column_name
19: FROM fnd_id_flex_segments
20: WHERE id_flex_num = coa_id
21: AND id_flex_code = c_flex_code
15: p_ccid IN NUMBER, p_account_number OUT NOCOPY VARCHAR2) IS
16:
17: CURSOR get_segments_used(coa_id NUMBER,c_flex_code fnd_id_flex_segments.id_flex_code%TYPE ) IS
18: SELECT segment_num, application_column_name
19: FROM fnd_id_flex_segments
20: WHERE id_flex_num = coa_id
21: AND id_flex_code = c_flex_code
22: ORDER BY segment_num;
23: