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 GL_LEDGERS

Line 80: l_ledger_id gl_ledgers.ledger_id%TYPE :=p_ledger_id;

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;
82: l_accounted_period_type gl_periods.period_type%TYPE;
83: l_period_name gl_periods.period_name%TYPE :=p_period_name;
84: l_period_year gl_periods.period_year%TYPE;

Line 94: gl_ledgers

90: SELECT
91: period_set_name
92: ,accounted_period_type
93: FROM
94: gl_ledgers
95: WHERE ledger_id=l_ledger_id;
96:
97: CURSOR c_period_name_attribute
98: IS

Line 1216: l_ledger_id gl_ledgers.ledger_id%TYPE :=p_ledger_id;

1212: ,x_amount OUT NOCOPY NUMBER
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;

Line 1238: gl_ledgers

1234: fnd_currencies
1235: WHERE currency_code=(SELECT
1236: currency_code
1237: FROM
1238: gl_ledgers
1239: WHERE ledger_id=l_ledger_id
1240: );
1241:
1242:

Line 1261: FROM Gl_Ledgers Lg,

1257: )
1258: AND EXISTS
1259: (
1260: SELECT *
1261: FROM Gl_Ledgers Lg,
1262: Gl_Ledger_Relationships Rs,
1263: Gl_Ledger_Norm_Seg_Vals nbsv
1264: WHERE lg.bal_seg_value_option_code='I'
1265: AND Rs.Application_Id = 101

Line 1461: l_ledger_id gl_ledgers.ledger_id%TYPE :=p_ledger_id;

1457: --,p_internal_trx_flag IN VARCHAR2
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;

Line 1488: gl_ledgers

1484: fnd_currencies
1485: WHERE currency_code=(SELECT
1486: currency_code
1487: FROM
1488: gl_ledgers
1489: WHERE ledger_id=l_ledger_id
1490: );
1491:
1492: CURSOR c_detailed_cfs_rows

Line 1794: l_ledger_id gl_ledgers.ledger_id%TYPE :=p_ledger_id;

1790: l_thousands_separator_flag VARCHAR2(1);
1791: l_format_mask VARCHAR2(100);
1792: l_final_display_format VARCHAR2(30);
1793: l_legal_entity_id NUMBER :=p_legal_entity_id;
1794: l_ledger_id gl_ledgers.ledger_id%TYPE :=p_ledger_id;
1795: l_func_currency_code fnd_currencies.currency_code%TYPE;
1796: l_period_name gl_periods.period_name%TYPE :=p_period_name;
1797: l_axis_set_id rg_report_axis_sets.axis_set_id%TYPE :=p_axis_set_id;
1798: l_rounding_option VARCHAR2(50) :=p_rounding_option;

Line 1943: gl_ledgers

1939: currency_code
1940: INTO
1941: l_func_currency_code
1942: FROM
1943: gl_ledgers
1944: WHERE
1945: ledger_id=l_ledger_id ;
1946:
1947: l_format_mask:=FND_CURRENCY.Get_Format_Mask(currency_code => l_func_currency_code