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_CFSSE_CALCULATE_PKG dependencies on JA_CN_CFS_CALCULATE_PKG

Line 54: ,x_period_names OUT NOCOPY JA_CN_CFS_CALCULATE_PKG.G_PERIOD_NAME_TBL) IS

50: -- 03/22/2006 Jackey Li Created
51: --===========================================================================
52: PROCEDURE Populate_LastYear_Period_Names(p_ledger_id IN NUMBER
53: ,p_period_name IN VARCHAR2
54: ,x_period_names OUT NOCOPY JA_CN_CFS_CALCULATE_PKG.G_PERIOD_NAME_TBL) IS
55:
56: l_procedure_name VARCHAR2(30) := 'Populate_LastYear_Period_Names';
57: l_ledger_id gl_ledgers.ledger_id %TYPE := p_ledger_id;--updated by lyb
58: l_period_set_name gl_periods.period_set_name%TYPE;

Line 66: l_period_names JA_CN_CFS_CALCULATE_PKG.G_PERIOD_NAME_TBL;

62: l_last_period_year gl_periods.period_year%TYPE;
63: l_lastyear_period_name gl_periods.period_name%TYPE;
64:
65: l_period_idx NUMBER;
66: l_period_names JA_CN_CFS_CALCULATE_PKG.G_PERIOD_NAME_TBL;
67:
68: -- this cursor is
69: CURSOR c_period_set
70: IS

Line 205: l_period_names JA_CN_CFS_CALCULATE_PKG.G_PERIOD_NAME_TBL;

201: l_axis_set_id rg_report_axis_sets.axis_set_id%TYPE := p_axis_set_id;
202: l_rounding_option VARCHAR2(50) := p_rounding_option;
203: l_balance_type VARCHAR2(50) := p_balance_type;
204: --l_internal_trx_flag VARCHAR2(1) := p_internal_trx_flag;
205: l_period_names JA_CN_CFS_CALCULATE_PKG.G_PERIOD_NAME_TBL;
206: l_lastyear_period_names JA_CN_CFS_CALCULATE_PKG.G_PERIOD_NAME_TBL;
207: l_axis_seq rg_report_axes.axis_seq%TYPE;
208: l_type VARCHAR2(1);
209: l_calculation_flag VARCHAR2(1);

Line 206: l_lastyear_period_names JA_CN_CFS_CALCULATE_PKG.G_PERIOD_NAME_TBL;

202: l_rounding_option VARCHAR2(50) := p_rounding_option;
203: l_balance_type VARCHAR2(50) := p_balance_type;
204: --l_internal_trx_flag VARCHAR2(1) := p_internal_trx_flag;
205: l_period_names JA_CN_CFS_CALCULATE_PKG.G_PERIOD_NAME_TBL;
206: l_lastyear_period_names JA_CN_CFS_CALCULATE_PKG.G_PERIOD_NAME_TBL;
207: l_axis_seq rg_report_axes.axis_seq%TYPE;
208: l_type VARCHAR2(1);
209: l_calculation_flag VARCHAR2(1);
210: l_display_zero_amount_flag VARCHAR2(1);

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

335: l_format_mask := FND_CURRENCY.Get_Format_Mask(currency_code => l_func_currency_code,
336: field_length => 30);
337:
338: --Fix bug# 7481478 added begin
339: --Call the procedure 'JA_CN_CFS_CALCULATE_PKG.Populate_Fomula' to popluate most detailed
340: --calculation lines for FSG row with calculation.
341: JA_CN_CFS_CALCULATE_PKG.Populate_Formula(p_coa =>p_coa
342: ,p_axis_set_id =>l_axis_set_id
343: );

Line 341: JA_CN_CFS_CALCULATE_PKG.Populate_Formula(p_coa =>p_coa

337:
338: --Fix bug# 7481478 added begin
339: --Call the procedure 'JA_CN_CFS_CALCULATE_PKG.Populate_Fomula' to popluate most detailed
340: --calculation lines for FSG row with calculation.
341: JA_CN_CFS_CALCULATE_PKG.Populate_Formula(p_coa =>p_coa
342: ,p_axis_set_id =>l_axis_set_id
343: );
344: --Fix bug# 7481478 added end
345:

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

344: --Fix bug# 7481478 added end
345:
346: --FND_FILE.Put_Line(FND_FILE.LOG,
347: -- 'Categorize_Rows start');
348: --Call the procedure 'JA_CN_CFS_CALCULATE_PKG.Categorize_Rows' to categorize FSG row
349: JA_CN_CFS_CALCULATE_PKG.Categorize_Rows(p_coa => p_coa,
350: p_axis_set_id => l_axis_set_id);
351:
352: --FND_FILE.Put_Line(FND_FILE.LOG,

Line 349: JA_CN_CFS_CALCULATE_PKG.Categorize_Rows(p_coa => p_coa,

345:
346: --FND_FILE.Put_Line(FND_FILE.LOG,
347: -- 'Categorize_Rows start');
348: --Call the procedure 'JA_CN_CFS_CALCULATE_PKG.Categorize_Rows' to categorize FSG row
349: JA_CN_CFS_CALCULATE_PKG.Categorize_Rows(p_coa => p_coa,
350: p_axis_set_id => l_axis_set_id);
351:
352: --FND_FILE.Put_Line(FND_FILE.LOG,
353: -- 'Categorize_Rows end');

Line 360: '.call JA_CN_CFS_CALCULATE_PKG.Categorize_Rows',

356: IF (g_stmt_level >= g_dbg_level)
357: THEN
358: FND_LOG.STRING(g_stmt_level,
359: g_module_name || '.' || l_procedure_name ||
360: '.call JA_CN_CFS_CALCULATE_PKG.Categorize_Rows',
361: 'Successfully');
362: END IF; --( g_stmt_level >= g_dbg_level)
363:
364: --Call the procedure 'JA_CN_CFS_CALCULATE_PKG.Populate_Period_Names'

Line 364: --Call the procedure 'JA_CN_CFS_CALCULATE_PKG.Populate_Period_Names'

360: '.call JA_CN_CFS_CALCULATE_PKG.Categorize_Rows',
361: 'Successfully');
362: END IF; --( g_stmt_level >= g_dbg_level)
363:
364: --Call the procedure 'JA_CN_CFS_CALCULATE_PKG.Populate_Period_Names'
365: -- to populate qualified period names by 'period name' and
366: -- 'balance type' for calculation
367: --FND_FILE.Put_Line(FND_FILE.LOG,
368: -- 'Populate_Period_Names start');

Line 369: JA_CN_CFS_CALCULATE_PKG.Populate_Period_Names(p_ledger_id =>l_ledger_id,--updated by lyb

365: -- to populate qualified period names by 'period name' and
366: -- 'balance type' for calculation
367: --FND_FILE.Put_Line(FND_FILE.LOG,
368: -- 'Populate_Period_Names start');
369: JA_CN_CFS_CALCULATE_PKG.Populate_Period_Names(p_ledger_id =>l_ledger_id,--updated by lyb
370: p_period_name => l_period_name,
371: p_balance_type => l_balance_type,
372: x_period_names => l_period_names);
373: --FND_FILE.Put_Line(FND_FILE.LOG,

Line 381: '.call JA_CN_CFS_CALCULATE_PKG.Populate_Period_Names',

377: IF (g_stmt_level >= g_dbg_level)
378: THEN
379: FND_LOG.STRING(g_stmt_level,
380: g_module_name || '.' || l_procedure_name ||
381: '.call JA_CN_CFS_CALCULATE_PKG.Populate_Period_Names',
382: 'Successfully');
383: END IF; --( g_stmt_level >= g_dbg_level)
384:
385: --Call the procedure 'JA_CN_CFSSE_CALCULATE_PKG.Populate_LastYear_Period_Names'

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

393:
394: --FND_FILE.Put_Line(FND_FILE.LOG,
395: -- 'Populate_LastYear_Period_Names end');
396:
397: --Call the procedure 'JA_CN_CFS_CALCULATE_PKG.Calculate_Rows_Amount' to
398: --calculate amount for items in the main part of Cash Flow Statement
399: --FND_FILE.Put_Line(FND_FILE.LOG,
400: -- 'Calculate_Rows_Amount start');
401: JA_CN_CFS_CALCULATE_PKG.Calculate_Rows_Amount(p_legal_entity_id => l_legal_entity_id,

Line 401: JA_CN_CFS_CALCULATE_PKG.Calculate_Rows_Amount(p_legal_entity_id => l_legal_entity_id,

397: --Call the procedure 'JA_CN_CFS_CALCULATE_PKG.Calculate_Rows_Amount' to
398: --calculate amount for items in the main part of Cash Flow Statement
399: --FND_FILE.Put_Line(FND_FILE.LOG,
400: -- 'Calculate_Rows_Amount start');
401: JA_CN_CFS_CALCULATE_PKG.Calculate_Rows_Amount(p_legal_entity_id => l_legal_entity_id,
402: p_ledger_id => l_ledger_id,--updated by lyb
403: p_coa => l_coa,
404: p_axis_set_id => l_axis_set_id,
405: p_period_names => l_period_names,

Line 420: '.call JA_CN_CFS_CALCULATE_PKG.Calculate_Rows_Amount',

416: IF (g_stmt_level >= g_dbg_level)
417: THEN
418: FND_LOG.STRING(g_stmt_level,
419: g_module_name || '.' || l_procedure_name ||
420: '.call JA_CN_CFS_CALCULATE_PKG.Calculate_Rows_Amount',
421: 'Successfully');
422: END IF; --( g_stmt_level >= g_dbg_level)
423:
424: --To populate row count and line count for each row in the rowset