APPS.JA_CN_CFS_CALCULATE_PKG dependencies on RG_REPORT_CALCULATIONS

Line 281: l_axis_seq_low rg_report_calculations.axis_seq_low%TYPE;

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;
285: l_operator_flag NUMBER;

Line 282: l_axis_seq_high rg_report_calculations.axis_seq_high%TYPE;

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;
285: l_operator_flag NUMBER;
286: l_exit_flag VARCHAR2(1);

Line 283: l_axis_name_low rg_report_calculations.axis_name_low%TYPE;

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;
285: l_operator_flag NUMBER;
286: l_exit_flag VARCHAR2(1);
287: l_cal_axis_seq rg_report_axes.axis_seq%TYPE;

Line 284: l_operator rg_report_calculations.operator%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;
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;

Line 288: l_constant rg_report_calculations.constant%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);
292: l_change_sign_flag VARCHAR2(1);

Line 311: ,rg_report_calculations rrc

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

Line 325: rg_report_calculations

321: ,axis_seq_high
322: ,axis_name_low
323: ,constant
324: FROM
325: rg_report_calculations
326: WHERE application_id=l_application_id
327: AND axis_set_id=l_axis_set_id
328: AND axis_seq=l_axis_seq
329: ORDER BY calculation_seq;

Line 361: rg_report_calculations rrc

357: OR
358: EXISTS (SELECT
359: rrc.axis_seq
360: FROM
361: rg_report_calculations rrc
362: WHERE rrc.application_id=rra.application_id
363: AND rra.axis_set_id=rrc.axis_set_id
364: AND rrc.axis_seq=rra.axis_seq
365: )

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

454: ,'p_axis_set_id '||p_axis_set_id
455: );
456: END IF; --(l_proc_level >= l_dbg_level)
457:
458: --Retrive initial canculation lines from RG_REPORT_CALCULATIONS table for
459: --each item in FSG Row Set that have calculation definition,
460: --if a calculation line contain sequence number range that perform calculation,
461: --then split this calculation line to multiple calculation lines and each line only
462: --have one sequence number that perform calcluation, instead of a range.