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_CFS_CALCULATE_PKG dependencies on JA_CN_CFS_ACTIVITIES_ALL

Line 16: --| program and stored in JA_CN_CFS_ACTIVITIES_ALL table, and rules defined

12: --|
13: --| This package contains the following PL/SQL tables/procedures/functions
14: --| to implement calculation for main part of cash flow statement according
15: --| to data that collected by 'Cash Flow Statement - Data Collection'
16: --| program and stored in JA_CN_CFS_ACTIVITIES_ALL table, and rules defined
17: --| in Cash Flow Statement Assignments form and Calculation window in FSG
18: --| Row Set.
19: --|
20: --| TYPE LIEST

Line 1172: -- cash flow item in the table 'JA_CN_CFS_ACTIVITIES_ALL'.

1168: --
1169: -- The procedure 'Calculate_Row_Amount' is used to calculate amount for a
1170: -- specific cash flow item in the main part of cash flow statement according
1171: -- to assignment in the table 'JA_CN_CFS_ASSIGNMENTS_ALL' and amount of detailed
1172: -- cash flow item in the table 'JA_CN_CFS_ACTIVITIES_ALL'.
1173: --
1174: -- PARAMETERS:
1175: -- In: p_legal_entity_id Identifier of legal entity
1176: -- p_set_of_bks_id Identifier of GL set of book, a required

Line 1249: ja_cn_cfs_activities_all

1245: IS
1246: SELECT
1247: nvl(SUM(round(func_amount,decode(l_rounding_option,'R',l_precision,50))),0)
1248: FROM
1249: ja_cn_cfs_activities_all
1250: WHERE period_name=l_period_name
1251: AND legal_entity_id=l_legal_entity_id
1252: -- added for CNAO Enhancement begin
1253: AND (

Line 1367: --in the 'JA_CN_CFS_ACTIVITIES_ALL' and amount of detailed cash flow items that are populated by

1363: FETCH c_precision INTO l_precision;
1364: CLOSE c_precision;
1365:
1366: --Calculate amount for a specific cash flow item according to assignment of detailed cash flow items
1367: --in the 'JA_CN_CFS_ACTIVITIES_ALL' and amount of detailed cash flow items that are populated by
1368: --'Cash flow Statment - collection' program
1369:
1370: --Initialize variable
1371: l_amount:=0;

Line 1472: l_balancing_segment_value JA_CN_CFS_ACTIVITIES_ALL.BALANCING_SEGMENT%TYPE; --added for CNAO Enhancement

1468: l_lastyear_amount NUMBER;
1469: l_precision fnd_currencies.precision%TYPE;
1470: l_cal_axis_seq rg_report_axes.axis_seq%TYPE;
1471: l_segment_override VARCHAR2(100) := p_segment_override; --added for CNAO Enhancement
1472: l_balancing_segment_value JA_CN_CFS_ACTIVITIES_ALL.BALANCING_SEGMENT%TYPE; --added for CNAO Enhancement
1473: --l_internal_trx_flag VARCHAR2(1);
1474: l_cal_seq_amount NUMBER;
1475: l_cal_seq_lastyear_amount NUMBER;
1476: l_period_count NUMBER;