1627: OPEN get_coa_id(l_set_of_books_id);
1628: FETCH get_coa_id INTO l_coa_id;
1629: CLOSE get_coa_id;
1630:
1631: IF fnd_flex_apis.get_qualifier_segnum
1632: (
1633: appl_id => 101
1634: ,key_flex_code => 'GL#'
1635: ,structure_number => l_coa_id
1637: ,segment_number => l_segnum
1638: )
1639: THEN
1640:
1641: IF fnd_flex_apis.get_segment_info
1642: (
1643: x_application_id => 101
1644: ,x_id_flex_code => 'GL#'
1645: ,x_id_flex_num => l_coa_id
1862: BEGIN
1863:
1864: coa_id := get_chart_of_accounts_id(p_org_id);
1865:
1866: IF fnd_flex_apis.get_qualIFier_segnum (
1867: 101, 'GL#', coa_id, 'FA_COST_CTR', segnum ) THEN
1868:
1869: IF fnd_flex_apis.get_segment_info (
1870: 101, 'GL#', coa_id, segnum,
1865:
1866: IF fnd_flex_apis.get_qualIFier_segnum (
1867: 101, 'GL#', coa_id, 'FA_COST_CTR', segnum ) THEN
1868:
1869: IF fnd_flex_apis.get_segment_info (
1870: 101, 'GL#', coa_id, segnum,
1871: appcol_name, seg_name, prompt, value_set_name ) THEN
1872:
1873: RETURN appcol_name;