DBA Data[Home] [Help]

APPS.JA_CN_ETC_CONC_PROG dependencies on JA_CN_SYSTEM_PARAMETERS_ALL

Line 543: l_book_name JA_CN_SYSTEM_PARAMETERS_ALL.BOOK_NAME%TYPE;

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;

Line 544: l_book_num JA_CN_SYSTEM_PARAMETERS_ALL.BOOK_NUM%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;

Line 545: l_com_name JA_CN_SYSTEM_PARAMETERS_ALL.COMPANY_NAME%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;

Line 546: l_org_id JA_CN_SYSTEM_PARAMETERS_ALL.ORGANIZATION_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;

Line 547: l_ent_qty JA_CN_SYSTEM_PARAMETERS_ALL.ENT_QUALITY%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:

Line 548: l_ent_ind JA_CN_SYSTEM_PARAMETERS_ALL.ENT_INDUSTRY%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:
552: --Cursor to get General Information from table JA_CN_SYSTEM_PARAMETERS_ALL of current SOB.

Line 549: --l_acc_str JA_CN_SYSTEM_PARAMETERS_ALL..ACCOUNT_STRUCTURE_ID%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.
553: CURSOR c_general_info IS

Line 550: --l_ent_flg JA_CN_SYSTEM_PARAMETERS_ALL.ENT_FLAG%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
554: SELECT BOOK_NAME,

Line 552: --Cursor to get General Information from table JA_CN_SYSTEM_PARAMETERS_ALL of current SOB.

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,

Line 562: FROM JA_CN_SYSTEM_PARAMETERS_ALL

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