eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.JA_CN_EAB_EXPORT_PKG dependencies on JA_CN_SYSTEM_PARAMETERS_ALL

Line 33: g_book_num JA_CN_SYSTEM_PARAMETERS_ALL.BOOK_NUM%TYPE;

29: g_dbg_level NUMBER := FND_LOG.G_Current_Runtime_Level;
30: g_proc_level NUMBER := FND_LOG.Level_Procedure;
31: g_stmt_level NUMBER := FND_LOG.Level_Statement;
32: g_ledger_id GL_LEDGERS.Ledger_Id%TYPE;
33: g_book_num JA_CN_SYSTEM_PARAMETERS_ALL.BOOK_NUM%TYPE;
34: g_book_name JA_CN_SYSTEM_PARAMETERS_ALL.BOOK_NAME%TYPE;
35: g_company_name JA_CN_SYSTEM_PARAMETERS_ALL.COMPANY_NAME%TYPE;
36: g_organization_id JA_CN_SYSTEM_PARAMETERS_ALL.ORGANIZATION_ID%TYPE;
37: g_ent_quality JA_CN_SYSTEM_PARAMETERS_ALL.ENT_QUALITY%TYPE;

Line 34: g_book_name JA_CN_SYSTEM_PARAMETERS_ALL.BOOK_NAME%TYPE;

30: g_proc_level NUMBER := FND_LOG.Level_Procedure;
31: g_stmt_level NUMBER := FND_LOG.Level_Statement;
32: g_ledger_id GL_LEDGERS.Ledger_Id%TYPE;
33: g_book_num JA_CN_SYSTEM_PARAMETERS_ALL.BOOK_NUM%TYPE;
34: g_book_name JA_CN_SYSTEM_PARAMETERS_ALL.BOOK_NAME%TYPE;
35: g_company_name JA_CN_SYSTEM_PARAMETERS_ALL.COMPANY_NAME%TYPE;
36: g_organization_id JA_CN_SYSTEM_PARAMETERS_ALL.ORGANIZATION_ID%TYPE;
37: g_ent_quality JA_CN_SYSTEM_PARAMETERS_ALL.ENT_QUALITY%TYPE;
38: g_ent_industry JA_CN_SYSTEM_PARAMETERS_ALL.ENT_INDUSTRY%TYPE;

Line 35: g_company_name JA_CN_SYSTEM_PARAMETERS_ALL.COMPANY_NAME%TYPE;

31: g_stmt_level NUMBER := FND_LOG.Level_Statement;
32: g_ledger_id GL_LEDGERS.Ledger_Id%TYPE;
33: g_book_num JA_CN_SYSTEM_PARAMETERS_ALL.BOOK_NUM%TYPE;
34: g_book_name JA_CN_SYSTEM_PARAMETERS_ALL.BOOK_NAME%TYPE;
35: g_company_name JA_CN_SYSTEM_PARAMETERS_ALL.COMPANY_NAME%TYPE;
36: g_organization_id JA_CN_SYSTEM_PARAMETERS_ALL.ORGANIZATION_ID%TYPE;
37: g_ent_quality JA_CN_SYSTEM_PARAMETERS_ALL.ENT_QUALITY%TYPE;
38: g_ent_industry JA_CN_SYSTEM_PARAMETERS_ALL.ENT_INDUSTRY%TYPE;
39: g_account_structure VARCHAR2(2000);

Line 36: g_organization_id JA_CN_SYSTEM_PARAMETERS_ALL.ORGANIZATION_ID%TYPE;

32: g_ledger_id GL_LEDGERS.Ledger_Id%TYPE;
33: g_book_num JA_CN_SYSTEM_PARAMETERS_ALL.BOOK_NUM%TYPE;
34: g_book_name JA_CN_SYSTEM_PARAMETERS_ALL.BOOK_NAME%TYPE;
35: g_company_name JA_CN_SYSTEM_PARAMETERS_ALL.COMPANY_NAME%TYPE;
36: g_organization_id JA_CN_SYSTEM_PARAMETERS_ALL.ORGANIZATION_ID%TYPE;
37: g_ent_quality JA_CN_SYSTEM_PARAMETERS_ALL.ENT_QUALITY%TYPE;
38: g_ent_industry JA_CN_SYSTEM_PARAMETERS_ALL.ENT_INDUSTRY%TYPE;
39: g_account_structure VARCHAR2(2000);
40: g_functional_currency VARCHAR2(1000) := NULL;

Line 37: g_ent_quality JA_CN_SYSTEM_PARAMETERS_ALL.ENT_QUALITY%TYPE;

33: g_book_num JA_CN_SYSTEM_PARAMETERS_ALL.BOOK_NUM%TYPE;
34: g_book_name JA_CN_SYSTEM_PARAMETERS_ALL.BOOK_NAME%TYPE;
35: g_company_name JA_CN_SYSTEM_PARAMETERS_ALL.COMPANY_NAME%TYPE;
36: g_organization_id JA_CN_SYSTEM_PARAMETERS_ALL.ORGANIZATION_ID%TYPE;
37: g_ent_quality JA_CN_SYSTEM_PARAMETERS_ALL.ENT_QUALITY%TYPE;
38: g_ent_industry JA_CN_SYSTEM_PARAMETERS_ALL.ENT_INDUSTRY%TYPE;
39: g_account_structure VARCHAR2(2000);
40: g_functional_currency VARCHAR2(1000) := NULL;
41: g_software_name VARCHAR2(100) := NULL;

Line 38: g_ent_industry JA_CN_SYSTEM_PARAMETERS_ALL.ENT_INDUSTRY%TYPE;

34: g_book_name JA_CN_SYSTEM_PARAMETERS_ALL.BOOK_NAME%TYPE;
35: g_company_name JA_CN_SYSTEM_PARAMETERS_ALL.COMPANY_NAME%TYPE;
36: g_organization_id JA_CN_SYSTEM_PARAMETERS_ALL.ORGANIZATION_ID%TYPE;
37: g_ent_quality JA_CN_SYSTEM_PARAMETERS_ALL.ENT_QUALITY%TYPE;
38: g_ent_industry JA_CN_SYSTEM_PARAMETERS_ALL.ENT_INDUSTRY%TYPE;
39: g_account_structure VARCHAR2(2000);
40: g_functional_currency VARCHAR2(1000) := NULL;
41: g_software_name VARCHAR2(100) := NULL;
42: g_software_version VARCHAR2(100) := NULL;

Line 50: -- the 'JA_CN_SYSTEM_PARAMETERS_ALL' table

46: -- Query_Account_Structure Private
47: --
48: -- DESCRIPTION:
49: -- This procedure is used to parse the account structure defined in
50: -- the 'JA_CN_SYSTEM_PARAMETERS_ALL' table
51: --
52: -- PARAMETERS:
53: -- N/A
54: --

Line 119: -- from the 'JA_CN_SYSTEM_PARAMETERS_ALL' table

115: -- Query_System_Options Private
116: --
117: -- DESCRIPTION:
118: -- This procedure is used to fetch data
119: -- from the 'JA_CN_SYSTEM_PARAMETERS_ALL' table
120: --
121: -- PARAMETERS:
122: -- In: p_le_id legal entity ID
123: -- In:P_COA_ID chart of accounts id

Line 143: l_le_id JA_CN_SYSTEM_PARAMETERS_ALL.LEGAL_ENTITY_ID%TYPE := p_le_id;

139:
140: JA_CN_MISSING_BOOK_INFO exception;
141: l_msg_miss_book_info varchar2(2000);
142:
143: l_le_id JA_CN_SYSTEM_PARAMETERS_ALL.LEGAL_ENTITY_ID%TYPE := p_le_id;
144: l_coa_id JA_CN_SUB_ACC_SOURCES_ALL.Chart_Of_Accounts_Id%TYPE := P_COA_ID;
145: BEGIN
146: --log for debug
147: IF (g_proc_level >= g_dbg_level)

Line 154: -- fetch data from the 'JA_CN_SYSTEM_PARAMETERS_ALL' table

150: g_module_name || '.' || l_procedure_name || '.begin',
151: 'begin procedure');
152: END IF; --( g_proc_level >= g_dbg_level)
153:
154: -- fetch data from the 'JA_CN_SYSTEM_PARAMETERS_ALL' table
155: SELECT jcsp.BOOK_NAME
156: ,jcsp.COMPANY_NAME
157: ,jcsp.book_num
158: ,jcsp.ORGANIZATION_ID

Line 167: FROM JA_CN_SYSTEM_PARAMETERS_ALL jcsp

163: ,g_book_num
164: ,g_organization_id
165: ,g_ent_quality
166: ,g_ent_industry
167: FROM JA_CN_SYSTEM_PARAMETERS_ALL jcsp
168: WHERE jcsp.legal_entity_id = l_le_id ;
169:
170: select sasc.accounting_struct_id
171: into l_account_structure_id

Line 436: -- to get information from the table JA_CN_SYSTEM_PARAMETERS_ALL

432: '.p_fiscal_year is',
433: p_fiscal_year);
434: END IF; --( g_proc_level >= g_dbg_level)
435:
436: -- to get information from the table JA_CN_SYSTEM_PARAMETERS_ALL
437: Query_System_Options(p_le_id,P_COA_ID);
438:
439: -- Get account structure from the Source Form
440: Query_Account_Structure(P_COA_ID);