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 RG_REPORT_AXES

Line 279: l_application_id rg_report_axes.application_id%TYPE;

275: IS
276: l_coa NUMBER := p_coa;
277: l_axis_set_id rg_report_axis_sets.axis_set_id%TYPE :=p_axis_set_id;
278: l_calculation_seq NUMBER;
279: l_application_id rg_report_axes.application_id%TYPE;
280: l_axis_seq rg_report_axes.axis_seq%TYPE;
281: l_axis_seq_low rg_report_calculations.axis_seq_low%TYPE;
282: l_axis_seq_high rg_report_calculations.axis_seq_high%TYPE;
283: l_axis_name_low rg_report_calculations.axis_name_low%TYPE;

Line 280: l_axis_seq rg_report_axes.axis_seq%TYPE;

276: l_coa NUMBER := p_coa;
277: l_axis_set_id rg_report_axis_sets.axis_set_id%TYPE :=p_axis_set_id;
278: l_calculation_seq NUMBER;
279: l_application_id rg_report_axes.application_id%TYPE;
280: l_axis_seq rg_report_axes.axis_seq%TYPE;
281: l_axis_seq_low rg_report_calculations.axis_seq_low%TYPE;
282: l_axis_seq_high rg_report_calculations.axis_seq_high%TYPE;
283: l_axis_name_low rg_report_calculations.axis_name_low%TYPE;
284: l_operator rg_report_calculations.operator%TYPE;

Line 287: l_cal_axis_seq rg_report_axes.axis_seq%TYPE;

283: l_axis_name_low rg_report_calculations.axis_name_low%TYPE;
284: l_operator rg_report_calculations.operator%TYPE;
285: l_operator_flag NUMBER;
286: l_exit_flag VARCHAR2(1);
287: l_cal_axis_seq rg_report_axes.axis_seq%TYPE;
288: l_constant rg_report_calculations.constant%TYPE;
289: l_type VARCHAR2(1);
290: l_display_flag VARCHAR2(1);
291: l_display_zero_flag VARCHAR2(1);

Line 294: l_calculated_axis_seq rg_report_axes.axis_seq%TYPE;

290: l_display_flag VARCHAR2(1);
291: l_display_zero_flag VARCHAR2(1);
292: l_change_sign_flag VARCHAR2(1);
293: l_calculated_row_count NUMBER;
294: l_calculated_axis_seq rg_report_axes.axis_seq%TYPE;
295:
296: -----FOR TEST
297: L_GT_COUNTS NUMBER:=-1;
298: l_gt_counts1 NUMBER:=-1;

Line 310: rg_report_axes rra

306: ,rra.display_flag
307: ,rra.display_zero_amount_flag
308: ,rra.change_sign_flag
309: FROM
310: rg_report_axes rra
311: ,rg_report_calculations rrc
312: WHERE rra.axis_set_id=l_axis_set_id
313: AND rra.axis_set_id=rrc.axis_set_id
314: AND rra.axis_seq=rrc.axis_seq;

Line 336: rg_report_axes rra

332: IS
333: SELECT
334: rra.axis_seq
335: FROM
336: rg_report_axes rra
337: WHERE rra.axis_set_id=l_axis_set_id
338: AND rra.axis_seq BETWEEN l_axis_seq_low AND l_axis_seq_high
339: --Fix bug# 7427067 begin
340: AND (EXISTS (SELECT

Line 375: rg_report_axes

371: IS
372: SELECT
373: axis_seq
374: FROM
375: rg_report_axes
376: WHERE application_id=l_application_id
377: AND axis_set_id=l_axis_set_id
378: AND axis_name=l_axis_name_low;
379:

Line 868: rg_report_axes rra

864: ,rra.display_zero_amount_flag
865: ,rra.change_sign_flag
866: ,rra.display_format
867: FROM
868: rg_report_axes rra
869: WHERE rra.axis_set_id=l_axis_set_id
870: AND EXISTS (SELECT
871: rrac.axis_seq
872: FROM

Line 891: ,rg_report_axes rra

887: ,rra.change_sign_flag
888: ,rra.display_format
889: FROM
890: ja_cn_cfs_assignments_all jccaa
891: ,rg_report_axes rra
892: WHERE jccaa.chart_of_accounts_id=l_coa
893: AND jccaa.axis_set_id=l_axis_set_id
894: AND rra.axis_set_id=jccaa.axis_set_id
895: AND jccaa.axis_seq=rra.axis_seq

Line 913: rg_report_axes rra

909: ,rra.display_zero_amount_flag
910: ,rra.change_sign_flag
911: ,rra.display_format
912: FROM
913: rg_report_axes rra
914: WHERE rra.axis_set_id=l_axis_set_id
915: AND NOT EXISTS(SELECT
916: crcg.axis_seq
917: FROM

Line 1220: l_axis_seq rg_report_axes.axis_seq%TYPE :=p_axis_seq;

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;
1222: l_amount NUMBER;
1223: l_period_count NUMBER;
1224: l_period_name VARCHAR2(15);

Line 1466: l_axis_seq rg_report_axes.axis_seq%TYPE;

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;
1468: l_lastyear_amount NUMBER;
1469: l_precision fnd_currencies.precision%TYPE;
1470: l_cal_axis_seq rg_report_axes.axis_seq%TYPE;

Line 1470: l_cal_axis_seq rg_report_axes.axis_seq%TYPE;

1466: l_axis_seq rg_report_axes.axis_seq%TYPE;
1467: l_amount NUMBER;
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;

Line 1804: l_axis_seq rg_report_axes.axis_seq%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);
1808: l_change_sign_flag VARCHAR2(1);