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_CALCULATE_PKG

Line 1: PACKAGE BODY JA_CN_CFS_CALCULATE_PKG AS

1: PACKAGE BODY JA_CN_CFS_CALCULATE_PKG AS
2: --$Header: JACNCCEB.pls 120.1.12010000.3 2009/01/04 06:29:44 shyan ship $
3: --+=======================================================================+
4: --| Copyright (c) 2006 Oracle Corporation
5: --| Redwood Shores, CA, USA

Line 41: l_module_prefix VARCHAR2(100):='JA_CN_CFS_CALCULATE_PKG';

37: -- 14-Oct-2008 Chaoqun Wu Fix bug# 7481516
38: --| 16-Dec-2008 Shujuan Yan Fix bug 7626489
39: --+======================================================================*/
40:
41: l_module_prefix VARCHAR2(100):='JA_CN_CFS_CALCULATE_PKG';
42:
43:
44: --==========================================================================
45: -- PROCEDURE NAME:

Line 77: ,x_period_names OUT NOCOPY JA_CN_CFS_CALCULATE_PKG.G_PERIOD_NAME_TBL

73: PROCEDURE Populate_Period_Names
74: (p_ledger_id IN NUMBER
75: ,p_period_name IN VARCHAR2
76: ,p_balance_type IN VARCHAR2
77: ,x_period_names OUT NOCOPY JA_CN_CFS_CALCULATE_PKG.G_PERIOD_NAME_TBL
78: )
79: IS
80: l_ledger_id gl_ledgers.ledger_id%TYPE :=p_ledger_id;
81: l_period_set_name gl_periods.period_set_name%TYPE;

Line 134: l_period_names JA_CN_CFS_CALCULATE_PKG.G_PERIOD_NAME_TBL;

130: AND period_num<=l_period_num;
131:
132: l_period_idx NUMBER;
133: l_curr_period_name gl_periods.period_name%TYPE;
134: l_period_names JA_CN_CFS_CALCULATE_PKG.G_PERIOD_NAME_TBL;
135:
136: l_dbg_level NUMBER :=FND_LOG.G_Current_Runtime_Level;
137: l_proc_level NUMBER :=FND_LOG.Level_Procedure;
138: l_proc_name VARCHAR2(100) :='Populate_Period_Names';

Line 1208: ,p_period_names IN JA_CN_CFS_CALCULATE_PKG.G_PERIOD_NAME_TBL

1204: ,p_ledger_id IN NUMBER
1205: ,p_coa IN NUMBER --added by lyb
1206: ,p_axis_set_id IN NUMBER
1207: ,p_axis_seq IN NUMBER
1208: ,p_period_names IN JA_CN_CFS_CALCULATE_PKG.G_PERIOD_NAME_TBL
1209: ,p_rounding_option IN VARCHAR2
1210: ,p_balancing_segment_value IN VARCHAR2 --added for CNAO Enhancement
1211: --,p_internal_trx_flag IN VARCHAR2
1212: ,x_amount OUT NOCOPY NUMBER

Line 1217: l_period_names JA_CN_CFS_CALCULATE_PKG.G_PERIOD_NAME_TBL :=p_period_names;

1213: )
1214: IS
1215: l_legal_entity_id NUMBER :=p_legal_entity_id;
1216: l_ledger_id gl_ledgers.ledger_id%TYPE :=p_ledger_id;
1217: l_period_names JA_CN_CFS_CALCULATE_PKG.G_PERIOD_NAME_TBL :=p_period_names;
1218: l_rounding_option VARCHAR2(50) :=p_rounding_option;
1219: l_axis_set_id rg_report_axis_sets.axis_set_id%TYPE :=p_axis_set_id;
1220: l_axis_seq rg_report_axes.axis_seq%TYPE :=p_axis_seq;
1221: l_amount_per_period NUMBER;

Line 1453: ,p_period_names IN JA_CN_CFS_CALCULATE_PKG.G_PERIOD_NAME_TBL

1449: (p_legal_entity_id IN NUMBER
1450: ,p_ledger_id IN NUMBER
1451: ,p_coa IN NUMBER
1452: ,p_axis_set_id IN NUMBER
1453: ,p_period_names IN JA_CN_CFS_CALCULATE_PKG.G_PERIOD_NAME_TBL
1454: ,p_lastyear_period_names IN JA_CN_CFS_CALCULATE_PKG.G_PERIOD_NAME_TBL
1455: ,p_rounding_option IN VARCHAR2
1456: ,p_segment_override IN VARCHAR2 --added for CNAO Enhancement
1457: --,p_internal_trx_flag IN VARCHAR2

Line 1454: ,p_lastyear_period_names IN JA_CN_CFS_CALCULATE_PKG.G_PERIOD_NAME_TBL

1450: ,p_ledger_id IN NUMBER
1451: ,p_coa IN NUMBER
1452: ,p_axis_set_id IN NUMBER
1453: ,p_period_names IN JA_CN_CFS_CALCULATE_PKG.G_PERIOD_NAME_TBL
1454: ,p_lastyear_period_names IN JA_CN_CFS_CALCULATE_PKG.G_PERIOD_NAME_TBL
1455: ,p_rounding_option IN VARCHAR2
1456: ,p_segment_override IN VARCHAR2 --added for CNAO Enhancement
1457: --,p_internal_trx_flag IN VARCHAR2
1458: )

Line 1462: l_period_names JA_CN_CFS_CALCULATE_PKG.G_PERIOD_NAME_TBL :=p_period_names;

1458: )
1459: IS
1460: l_legal_entity_id NUMBER :=p_legal_entity_id;
1461: l_ledger_id gl_ledgers.ledger_id%TYPE :=p_ledger_id;
1462: l_period_names JA_CN_CFS_CALCULATE_PKG.G_PERIOD_NAME_TBL :=p_period_names;
1463: l_lastyear_period_names JA_CN_CFS_CALCULATE_PKG.G_PERIOD_NAME_TBL :=p_lastyear_period_names;
1464: l_rounding_option VARCHAR2(50) :=p_rounding_option;
1465: l_axis_set_id rg_report_axis_sets.axis_set_id%TYPE :=p_axis_set_id;
1466: l_axis_seq rg_report_axes.axis_seq%TYPE;

Line 1463: l_lastyear_period_names JA_CN_CFS_CALCULATE_PKG.G_PERIOD_NAME_TBL :=p_lastyear_period_names;

1459: IS
1460: l_legal_entity_id NUMBER :=p_legal_entity_id;
1461: l_ledger_id gl_ledgers.ledger_id%TYPE :=p_ledger_id;
1462: l_period_names JA_CN_CFS_CALCULATE_PKG.G_PERIOD_NAME_TBL :=p_period_names;
1463: l_lastyear_period_names JA_CN_CFS_CALCULATE_PKG.G_PERIOD_NAME_TBL :=p_lastyear_period_names;
1464: l_rounding_option VARCHAR2(50) :=p_rounding_option;
1465: l_axis_set_id rg_report_axis_sets.axis_set_id%TYPE :=p_axis_set_id;
1466: l_axis_seq rg_report_axes.axis_seq%TYPE;
1467: l_amount NUMBER;

Line 1629: JA_CN_CFS_CALCULATE_PKG.Calculate_Row_Amount(p_legal_entity_id => l_legal_entity_id

1625: FOR l_detailed_cfs_row IN c_detailed_cfs_rows
1626: LOOP
1627: l_amount:=0;
1628: l_lastyear_amount:=0;
1629: JA_CN_CFS_CALCULATE_PKG.Calculate_Row_Amount(p_legal_entity_id => l_legal_entity_id
1630: ,p_ledger_id => l_ledger_id
1631: ,p_coa => p_coa --added by lyb
1632: ,p_axis_set_id => l_axis_set_id
1633: ,p_axis_seq => l_detailed_cfs_row.axis_seq

Line 1651: JA_CN_CFS_CALCULATE_PKG.Calculate_Row_Amount(p_legal_entity_id => l_legal_entity_id

1647: --If the parameter l_lastyear_period_names is not null, then calculate last year amount for current row
1648: IF l_lastyear_period_names IS NOT NULL
1649: THEN
1650:
1651: JA_CN_CFS_CALCULATE_PKG.Calculate_Row_Amount(p_legal_entity_id => l_legal_entity_id
1652: ,p_ledger_id => l_ledger_id
1653: ,p_coa => p_coa --added by lyb
1654: ,p_axis_set_id => l_axis_set_id
1655: ,p_axis_seq => l_detailed_cfs_row.axis_seq

Line 1802: l_period_names JA_CN_CFS_CALCULATE_PKG.G_PERIOD_NAME_TBL;

1798: l_rounding_option VARCHAR2(50) :=p_rounding_option;
1799: l_balance_type VARCHAR2(50) :=p_balance_type ;
1800: l_segment_override VARCHAR2(100) :=p_segment_override; --addded for CNAO Enhancement
1801: --l_internal_trx_flag VARCHAR2(1) :=p_internal_trx_flag ;
1802: l_period_names JA_CN_CFS_CALCULATE_PKG.G_PERIOD_NAME_TBL;
1803: l_lastyear_period_names JA_CN_CFS_CALCULATE_PKG.G_PERIOD_NAME_TBL;
1804: l_axis_seq rg_report_axes.axis_seq%TYPE;
1805: l_type VARCHAR2(1);
1806: l_calculation_flag VARCHAR2(1);

Line 1803: l_lastyear_period_names JA_CN_CFS_CALCULATE_PKG.G_PERIOD_NAME_TBL;

1799: l_balance_type VARCHAR2(50) :=p_balance_type ;
1800: l_segment_override VARCHAR2(100) :=p_segment_override; --addded for CNAO Enhancement
1801: --l_internal_trx_flag VARCHAR2(1) :=p_internal_trx_flag ;
1802: l_period_names JA_CN_CFS_CALCULATE_PKG.G_PERIOD_NAME_TBL;
1803: l_lastyear_period_names JA_CN_CFS_CALCULATE_PKG.G_PERIOD_NAME_TBL;
1804: l_axis_seq rg_report_axes.axis_seq%TYPE;
1805: l_type VARCHAR2(1);
1806: l_calculation_flag VARCHAR2(1);
1807: l_display_zero_amount_flag VARCHAR2(1);

Line 1953: --Call the procedure 'JA_CN_CFS_CALCULATE_PKG.Populate_Fomula' to popluate most detailed

1949: );
1950:
1951:
1952:
1953: --Call the procedure 'JA_CN_CFS_CALCULATE_PKG.Populate_Fomula' to popluate most detailed
1954: --calculation lines for FSG row with calculation.
1955: JA_CN_CFS_CALCULATE_PKG.Populate_Formula(p_coa =>l_coa --Fix bug# 7427067 begin
1956: ,p_axis_set_id =>l_axis_set_id
1957: );

Line 1955: JA_CN_CFS_CALCULATE_PKG.Populate_Formula(p_coa =>l_coa --Fix bug# 7427067 begin

1951:
1952:
1953: --Call the procedure 'JA_CN_CFS_CALCULATE_PKG.Populate_Fomula' to popluate most detailed
1954: --calculation lines for FSG row with calculation.
1955: JA_CN_CFS_CALCULATE_PKG.Populate_Formula(p_coa =>l_coa --Fix bug# 7427067 begin
1956: ,p_axis_set_id =>l_axis_set_id
1957: );
1958:
1959: --Call the procedure 'JA_CN_CFS_CALCULATE_PKG.Categorize_Rows' to categorize FSG row

Line 1959: --Call the procedure 'JA_CN_CFS_CALCULATE_PKG.Categorize_Rows' to categorize FSG row

1955: JA_CN_CFS_CALCULATE_PKG.Populate_Formula(p_coa =>l_coa --Fix bug# 7427067 begin
1956: ,p_axis_set_id =>l_axis_set_id
1957: );
1958:
1959: --Call the procedure 'JA_CN_CFS_CALCULATE_PKG.Categorize_Rows' to categorize FSG row
1960: JA_CN_CFS_CALCULATE_PKG.Categorize_Rows(p_coa =>l_coa
1961: ,p_axis_set_id =>l_axis_set_id
1962: );
1963:

Line 1960: JA_CN_CFS_CALCULATE_PKG.Categorize_Rows(p_coa =>l_coa

1956: ,p_axis_set_id =>l_axis_set_id
1957: );
1958:
1959: --Call the procedure 'JA_CN_CFS_CALCULATE_PKG.Categorize_Rows' to categorize FSG row
1960: JA_CN_CFS_CALCULATE_PKG.Categorize_Rows(p_coa =>l_coa
1961: ,p_axis_set_id =>l_axis_set_id
1962: );
1963:
1964: --Call the procedure 'JA_CN_CFS_CALCULATE_PKG.Populate_Period_Names' to populate qualified period names

Line 1964: --Call the procedure 'JA_CN_CFS_CALCULATE_PKG.Populate_Period_Names' to populate qualified period names

1960: JA_CN_CFS_CALCULATE_PKG.Categorize_Rows(p_coa =>l_coa
1961: ,p_axis_set_id =>l_axis_set_id
1962: );
1963:
1964: --Call the procedure 'JA_CN_CFS_CALCULATE_PKG.Populate_Period_Names' to populate qualified period names
1965: --by 'period name' and 'balance type' for calculation
1966: JA_CN_CFS_CALCULATE_PKG.Populate_Period_Names(p_ledger_id => l_ledger_id
1967: ,p_period_name => l_period_name
1968: ,p_balance_type => l_balance_type

Line 1966: JA_CN_CFS_CALCULATE_PKG.Populate_Period_Names(p_ledger_id => l_ledger_id

1962: );
1963:
1964: --Call the procedure 'JA_CN_CFS_CALCULATE_PKG.Populate_Period_Names' to populate qualified period names
1965: --by 'period name' and 'balance type' for calculation
1966: JA_CN_CFS_CALCULATE_PKG.Populate_Period_Names(p_ledger_id => l_ledger_id
1967: ,p_period_name => l_period_name
1968: ,p_balance_type => l_balance_type
1969: ,x_period_names => l_period_names
1970: );

Line 1973: --Call the procedure 'JA_CN_CFS_CALCULATE_PKG.Calculate_Rows_Amount' to

1969: ,x_period_names => l_period_names
1970: );
1971:
1972:
1973: --Call the procedure 'JA_CN_CFS_CALCULATE_PKG.Calculate_Rows_Amount' to
1974: --calculate amount for items in the main part of Cash Flow Statement
1975: JA_CN_CFS_CALCULATE_PKG.Calculate_Rows_Amount(p_legal_entity_id =>l_legal_entity_id
1976: ,p_ledger_id =>l_ledger_id
1977: ,p_coa =>p_coa

Line 1975: JA_CN_CFS_CALCULATE_PKG.Calculate_Rows_Amount(p_legal_entity_id =>l_legal_entity_id

1971:
1972:
1973: --Call the procedure 'JA_CN_CFS_CALCULATE_PKG.Calculate_Rows_Amount' to
1974: --calculate amount for items in the main part of Cash Flow Statement
1975: JA_CN_CFS_CALCULATE_PKG.Calculate_Rows_Amount(p_legal_entity_id =>l_legal_entity_id
1976: ,p_ledger_id =>l_ledger_id
1977: ,p_coa =>p_coa
1978: ,p_axis_set_id =>l_axis_set_id
1979: ,p_period_names =>l_period_names

Line 2312: END JA_CN_CFS_CALCULATE_PKG;

2308: END IF; --(l_proc_level >= l_dbg_level)
2309: END Generate_Cfs_Xml;
2310:
2311:
2312: END JA_CN_CFS_CALCULATE_PKG;