539: l_coa_id NUMBER := P_COA_ID;
540: l_sob_coa_flag NUMBER;
541:
542: l_flag NUMBER;
543: l_book_name JA_CN_SYSTEM_PARAMETERS_ALL.BOOK_NAME%TYPE;
544: l_book_num JA_CN_SYSTEM_PARAMETERS_ALL.BOOK_NUM%TYPE;
545: l_com_name JA_CN_SYSTEM_PARAMETERS_ALL.COMPANY_NAME%TYPE;
546: l_org_id JA_CN_SYSTEM_PARAMETERS_ALL.ORGANIZATION_ID%TYPE;
547: l_ent_qty JA_CN_SYSTEM_PARAMETERS_ALL.ENT_QUALITY%TYPE;
540: l_sob_coa_flag NUMBER;
541:
542: l_flag NUMBER;
543: l_book_name JA_CN_SYSTEM_PARAMETERS_ALL.BOOK_NAME%TYPE;
544: l_book_num JA_CN_SYSTEM_PARAMETERS_ALL.BOOK_NUM%TYPE;
545: l_com_name JA_CN_SYSTEM_PARAMETERS_ALL.COMPANY_NAME%TYPE;
546: l_org_id JA_CN_SYSTEM_PARAMETERS_ALL.ORGANIZATION_ID%TYPE;
547: l_ent_qty JA_CN_SYSTEM_PARAMETERS_ALL.ENT_QUALITY%TYPE;
548: l_ent_ind JA_CN_SYSTEM_PARAMETERS_ALL.ENT_INDUSTRY%TYPE;
541:
542: l_flag NUMBER;
543: l_book_name JA_CN_SYSTEM_PARAMETERS_ALL.BOOK_NAME%TYPE;
544: l_book_num JA_CN_SYSTEM_PARAMETERS_ALL.BOOK_NUM%TYPE;
545: l_com_name JA_CN_SYSTEM_PARAMETERS_ALL.COMPANY_NAME%TYPE;
546: l_org_id JA_CN_SYSTEM_PARAMETERS_ALL.ORGANIZATION_ID%TYPE;
547: l_ent_qty JA_CN_SYSTEM_PARAMETERS_ALL.ENT_QUALITY%TYPE;
548: l_ent_ind JA_CN_SYSTEM_PARAMETERS_ALL.ENT_INDUSTRY%TYPE;
549: --l_acc_str JA_CN_SYSTEM_PARAMETERS_ALL..ACCOUNT_STRUCTURE_ID%TYPE;
542: l_flag NUMBER;
543: l_book_name JA_CN_SYSTEM_PARAMETERS_ALL.BOOK_NAME%TYPE;
544: l_book_num JA_CN_SYSTEM_PARAMETERS_ALL.BOOK_NUM%TYPE;
545: l_com_name JA_CN_SYSTEM_PARAMETERS_ALL.COMPANY_NAME%TYPE;
546: l_org_id JA_CN_SYSTEM_PARAMETERS_ALL.ORGANIZATION_ID%TYPE;
547: l_ent_qty JA_CN_SYSTEM_PARAMETERS_ALL.ENT_QUALITY%TYPE;
548: l_ent_ind JA_CN_SYSTEM_PARAMETERS_ALL.ENT_INDUSTRY%TYPE;
549: --l_acc_str JA_CN_SYSTEM_PARAMETERS_ALL..ACCOUNT_STRUCTURE_ID%TYPE;
550: --l_ent_flg JA_CN_SYSTEM_PARAMETERS_ALL.ENT_FLAG%TYPE;
543: l_book_name JA_CN_SYSTEM_PARAMETERS_ALL.BOOK_NAME%TYPE;
544: l_book_num JA_CN_SYSTEM_PARAMETERS_ALL.BOOK_NUM%TYPE;
545: l_com_name JA_CN_SYSTEM_PARAMETERS_ALL.COMPANY_NAME%TYPE;
546: l_org_id JA_CN_SYSTEM_PARAMETERS_ALL.ORGANIZATION_ID%TYPE;
547: l_ent_qty JA_CN_SYSTEM_PARAMETERS_ALL.ENT_QUALITY%TYPE;
548: l_ent_ind JA_CN_SYSTEM_PARAMETERS_ALL.ENT_INDUSTRY%TYPE;
549: --l_acc_str JA_CN_SYSTEM_PARAMETERS_ALL..ACCOUNT_STRUCTURE_ID%TYPE;
550: --l_ent_flg JA_CN_SYSTEM_PARAMETERS_ALL.ENT_FLAG%TYPE;
551:
544: l_book_num JA_CN_SYSTEM_PARAMETERS_ALL.BOOK_NUM%TYPE;
545: l_com_name JA_CN_SYSTEM_PARAMETERS_ALL.COMPANY_NAME%TYPE;
546: l_org_id JA_CN_SYSTEM_PARAMETERS_ALL.ORGANIZATION_ID%TYPE;
547: l_ent_qty JA_CN_SYSTEM_PARAMETERS_ALL.ENT_QUALITY%TYPE;
548: l_ent_ind JA_CN_SYSTEM_PARAMETERS_ALL.ENT_INDUSTRY%TYPE;
549: --l_acc_str JA_CN_SYSTEM_PARAMETERS_ALL..ACCOUNT_STRUCTURE_ID%TYPE;
550: --l_ent_flg JA_CN_SYSTEM_PARAMETERS_ALL.ENT_FLAG%TYPE;
551:
552: --Cursor to get General Information from table JA_CN_SYSTEM_PARAMETERS_ALL of current SOB.
545: l_com_name JA_CN_SYSTEM_PARAMETERS_ALL.COMPANY_NAME%TYPE;
546: l_org_id JA_CN_SYSTEM_PARAMETERS_ALL.ORGANIZATION_ID%TYPE;
547: l_ent_qty JA_CN_SYSTEM_PARAMETERS_ALL.ENT_QUALITY%TYPE;
548: l_ent_ind JA_CN_SYSTEM_PARAMETERS_ALL.ENT_INDUSTRY%TYPE;
549: --l_acc_str JA_CN_SYSTEM_PARAMETERS_ALL..ACCOUNT_STRUCTURE_ID%TYPE;
550: --l_ent_flg JA_CN_SYSTEM_PARAMETERS_ALL.ENT_FLAG%TYPE;
551:
552: --Cursor to get General Information from table JA_CN_SYSTEM_PARAMETERS_ALL of current SOB.
553: CURSOR c_general_info IS
546: l_org_id JA_CN_SYSTEM_PARAMETERS_ALL.ORGANIZATION_ID%TYPE;
547: l_ent_qty JA_CN_SYSTEM_PARAMETERS_ALL.ENT_QUALITY%TYPE;
548: l_ent_ind JA_CN_SYSTEM_PARAMETERS_ALL.ENT_INDUSTRY%TYPE;
549: --l_acc_str JA_CN_SYSTEM_PARAMETERS_ALL..ACCOUNT_STRUCTURE_ID%TYPE;
550: --l_ent_flg JA_CN_SYSTEM_PARAMETERS_ALL.ENT_FLAG%TYPE;
551:
552: --Cursor to get General Information from table JA_CN_SYSTEM_PARAMETERS_ALL of current SOB.
553: CURSOR c_general_info IS
554: SELECT BOOK_NAME,
548: l_ent_ind JA_CN_SYSTEM_PARAMETERS_ALL.ENT_INDUSTRY%TYPE;
549: --l_acc_str JA_CN_SYSTEM_PARAMETERS_ALL..ACCOUNT_STRUCTURE_ID%TYPE;
550: --l_ent_flg JA_CN_SYSTEM_PARAMETERS_ALL.ENT_FLAG%TYPE;
551:
552: --Cursor to get General Information from table JA_CN_SYSTEM_PARAMETERS_ALL of current SOB.
553: CURSOR c_general_info IS
554: SELECT BOOK_NAME,
555: BOOK_NUM,
556: COMPANY_NAME,
558: ENT_QUALITY,
559: ENT_INDUSTRY
560: --,ACCOUNT_STRUCTURE_ID
561: --,ENT_FLAG
562: FROM JA_CN_SYSTEM_PARAMETERS_ALL
563: WHERE LEGAL_ENTITY_ID = l_le_id;
564:
565: BEGIN
566: --log for debug