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_FSG_FORMULA_EXTRACT_PKG dependencies on RG_REPORT_AXES

Line 64: ln_axis_seq rg_report_axes.axis_seq%TYPE :=pn_axis_seq;

60: IS
61: ln_coa Number :=pn_coa;
62: ln_axis_set_id rg_report_axis_sets.axis_set_id%TYPE :=pn_axis_set_id;
63:
64: ln_axis_seq rg_report_axes.axis_seq%TYPE :=pn_axis_seq;
65: lv_type VARCHAR2(1);
66: lv_change_sign_flag VARCHAR2(1);
67: ln_row_count NUMBER;
68: lv_rowcnt VARCHAR2(50);

Line 78: ln_axis_seq_update rg_report_axes.axis_seq%TYPE;

74: lv_formula VARCHAR2(4000);
75:
76: --The following variables are added by Jianchao Chi on 28-Jan-2011 to fix bug 11675682
77: lv_seq_tag VARCHAR2(10) :='N';
78: ln_axis_seq_update rg_report_axes.axis_seq%TYPE;
79:
80: --Added by Jianchao Chi on 28-Jan-2011 to fix bug 11675682
81: CURSOR c_axis_seq
82: IS

Line 312: ln_axis_seq rg_report_axes.axis_seq%TYPE :=pn_axis_seq;

308: )
309: IS
310: ln_coa NUMBER := pn_coa;
311: ln_axis_set_id rg_report_axis_sets.axis_set_id%TYPE :=pn_axis_set_id;
312: ln_axis_seq rg_report_axes.axis_seq%TYPE :=pn_axis_seq;
313:
314: ln_calculation_seq NUMBER;
315: ln_application_id rg_report_axes.application_id%TYPE;
316: ln_axis_seq_low rg_report_calculations.axis_seq_low%TYPE;

Line 315: ln_application_id rg_report_axes.application_id%TYPE;

311: ln_axis_set_id rg_report_axis_sets.axis_set_id%TYPE :=pn_axis_set_id;
312: ln_axis_seq rg_report_axes.axis_seq%TYPE :=pn_axis_seq;
313:
314: ln_calculation_seq NUMBER;
315: ln_application_id rg_report_axes.application_id%TYPE;
316: ln_axis_seq_low rg_report_calculations.axis_seq_low%TYPE;
317: ln_axis_seq_high rg_report_calculations.axis_seq_high%TYPE;
318: lv_axis_name_low rg_report_calculations.axis_name_low%TYPE;
319: lv_operator rg_report_calculations.operator%TYPE;

Line 322: ln_cal_axis_seq rg_report_axes.axis_seq%TYPE;

318: lv_axis_name_low rg_report_calculations.axis_name_low%TYPE;
319: lv_operator rg_report_calculations.operator%TYPE;
320: ln_operator_flag NUMBER;
321: lv_exit_flag VARCHAR2(1);
322: ln_cal_axis_seq rg_report_axes.axis_seq%TYPE;
323: ln_constant rg_report_calculations.constant%TYPE;
324: lv_type VARCHAR2(1);
325: lv_display_flag VARCHAR2(1);
326: lv_display_zero_flag VARCHAR2(1);

Line 340: rg_report_axes rra

336: ,rra.display_flag
337: ,rra.display_zero_amount_flag
338: ,rra.change_sign_flag
339: FROM
340: rg_report_axes rra
341: ,rg_report_calculations rrc
342: WHERE rra.axis_set_id=ln_axis_set_id
343: AND rra.axis_set_id=rrc.axis_set_id
344: AND rra.axis_seq=rrc.axis_seq

Line 367: rg_report_axes rra

363: IS
364: SELECT
365: rra.axis_seq
366: FROM
367: rg_report_axes rra
368: WHERE rra.axis_set_id=ln_axis_set_id
369: AND rra.axis_seq BETWEEN ln_axis_seq_low AND ln_axis_seq_high
370: AND (EXISTS (SELECT
371: rrac.axis_seq

Line 403: rg_report_axes

399: IS
400: SELECT
401: axis_seq
402: FROM
403: rg_report_axes
404: WHERE application_id=ln_application_id
405: AND axis_set_id=ln_axis_set_id
406: AND axis_name=lv_axis_name_low;
407:

Line 639: rg_report_axes rra

635: --Get the sequence of current row in it's row set
636: SELECT COUNT(DISTINCT rra.axis_seq)
637: INTO ln_row_count
638: FROM
639: rg_report_axes rra
640: ,rg_report_calculations rrc
641: WHERE rra.axis_set_id=ln_axis_set_id
642: AND rra.axis_set_id=rrc.axis_set_id
643: AND rra.axis_seq=rrc.axis_seq