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_CALCULATIONS

Line 316: ln_axis_seq_low rg_report_calculations.axis_seq_low%TYPE;

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;
320: ln_operator_flag NUMBER;

Line 317: ln_axis_seq_high rg_report_calculations.axis_seq_high%TYPE;

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;
320: ln_operator_flag NUMBER;
321: lv_exit_flag VARCHAR2(1);

Line 318: lv_axis_name_low rg_report_calculations.axis_name_low%TYPE;

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;
320: ln_operator_flag NUMBER;
321: lv_exit_flag VARCHAR2(1);
322: ln_cal_axis_seq rg_report_axes.axis_seq%TYPE;

Line 319: lv_operator rg_report_calculations.operator%TYPE;

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;
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;

Line 323: ln_constant rg_report_calculations.constant%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);
327: lv_change_sign_flag VARCHAR2(1);

Line 341: ,rg_report_calculations rrc

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
345: AND rra.axis_seq=ln_axis_seq;

Line 356: rg_report_calculations

352: ,axis_seq_high
353: ,axis_name_low
354: ,constant
355: FROM
356: rg_report_calculations
357: WHERE application_id=ln_application_id
358: AND axis_set_id=ln_axis_set_id
359: AND axis_seq=ln_axis_seq
360: ORDER BY calculation_seq;

Line 391: rg_report_calculations rrc

387: OR
388: EXISTS (SELECT
389: rrc.axis_seq
390: FROM
391: rg_report_calculations rrc
392: WHERE rrc.application_id=rra.application_id
393: AND rra.axis_set_id=rrc.axis_set_id
394: AND rrc.axis_seq=rra.axis_seq
395: )

Line 437: --Retrive initial canculation lines from RG_REPORT_CALCULATIONS table for

433: ,'pn_axis_seq '||ln_axis_seq
434: );
435: END IF;
436:
437: --Retrive initial canculation lines from RG_REPORT_CALCULATIONS table for
438: --specify item(row) in FSG Row Set that have calculation definition.
439: --If a calculation line contain sequence number range that perform calculation,
440: --then split this calculation line to multiple calculation lines and each line only
441: --have one sequence number that perform calcluation, instead of a range.

Line 640: ,rg_report_calculations rrc

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
644: AND rrc.axis_seq<=ln_axis_seq;