APPS.FA_CUA_HIERARCHY_PKG dependencies on FA_BOOK_CONTROLS

Line 382: from fa_book_controls

378: ,x_err_stack in out nocopy varchar2)
379: is
380: Cursor C is select FA_HIERARCHY_DIST_SET_S.nextval from dual;
381: Cursor C_CofA_id is select accounting_flex_structure
382: from fa_book_controls
383: where book_type_code = x_book_type_code;
384: l_CofA_id number;
385: l_old_err_stack varchar2(640);
386: I BINARY_INTEGER;

Line 757: v_book_class FA_BOOK_CONTROLS.book_class%TYPE;

753: l. Parent level is one level higher than the current level.
754: m. Node name cannot be null for Asset node
755: */
756: l_old_err_stack varchar2(640);
757: v_book_class FA_BOOK_CONTROLS.book_class%TYPE;
758: v_book_type_code FA_BOOK_CONTROLS.book_type_code%TYPE;
759: v_name FA_ASSET_HIERARCHY.name%TYPE;
760: dummy number;
761: l_book_type_code varchar2(15);

Line 758: v_book_type_code FA_BOOK_CONTROLS.book_type_code%TYPE;

754: m. Node name cannot be null for Asset node
755: */
756: l_old_err_stack varchar2(640);
757: v_book_class FA_BOOK_CONTROLS.book_class%TYPE;
758: v_book_type_code FA_BOOK_CONTROLS.book_type_code%TYPE;
759: v_name FA_ASSET_HIERARCHY.name%TYPE;
760: dummy number;
761: l_book_type_code varchar2(15);
762: v_mandatory_asset_flag varchar2(1);

Line 777: Select book_class from FA_BOOK_CONTROLS

773: INVALID_PURPOSE_ID EXCEPTION;
774: PURPOSE_NOT_EXISTS EXCEPTION;
775:
776: Cursor C_BOOK is
777: Select book_class from FA_BOOK_CONTROLS
778: where book_type_code = x_book_type_code;
779: Cursor C_PARENT is
780: select book_type_code from FA_ASSET_HIERARCHY_PURPOSE
781: where asset_hierarchy_purpose_id = (Select asset_hierarchy_purpose_id