586: FROM fa_category_books
587: WHERE book_type_code = p_book_type_code
588: AND category_id = p_category_id ;
589:
590: CURSOR fnd_application_cur IS
591: SELECT application_short_name
592: FROM fnd_application
593: WHERE application_id = 101 ; --GL
594:
588: AND category_id = p_category_id ;
589:
590: CURSOR fnd_application_cur IS
591: SELECT application_short_name
592: FROM fnd_application
593: WHERE application_id = 101 ; --GL
594:
595: CURSOR fa_category_kfv_cur (l_category_id IN NUMBER) IS
596: SELECT concatenated_segments
661: l_error_message := fnd_message.get;
662: RAISE fnd_api.g_exc_error;
663: END IF ;
664:
665: OPEN fnd_application_cur ;
666: FETCH fnd_application_cur INTO l_app_short_name ;
667: CLOSE fnd_application_cur ;
668:
669: IF fnd_flex_ext.get_segments(
662: RAISE fnd_api.g_exc_error;
663: END IF ;
664:
665: OPEN fnd_application_cur ;
666: FETCH fnd_application_cur INTO l_app_short_name ;
667: CLOSE fnd_application_cur ;
668:
669: IF fnd_flex_ext.get_segments(
670: application_short_name => l_app_short_name,
663: END IF ;
664:
665: OPEN fnd_application_cur ;
666: FETCH fnd_application_cur INTO l_app_short_name ;
667: CLOSE fnd_application_cur ;
668:
669: IF fnd_flex_ext.get_segments(
670: application_short_name => l_app_short_name,
671: key_flex_code => l_flex_code,