DBA Data[Home] [Help]

APPS.QRM_PA_CALCULATION_P dependencies on QRM_PA_AGGREGATION_P

Line 1017: QRM_PA_AGGREGATION_P.calc_tb_start_end_dates (

1013: IF (p_settings.date_type = 'F') THEN
1014: IF (p_settings.style = 'X') THEN
1015: p_from_date := p_settings.start_date;
1016: p_to_date := p_settings.end_date;
1017: QRM_PA_AGGREGATION_P.calc_tb_start_end_dates (
1018: p_settings.analysis_name, p_ref_date, p_settings.tb_name,
1019: p_settings.tb_label, p_to_date,
1020: p_settings.end_date_ref, p_settings.end_date_offset,
1021: p_settings.end_offset_type, p_settings.date_type,

Line 1034: QRM_PA_AGGREGATION_P.calc_tb_start_end_dates (

1030: ELSIF (p_settings.date_type = 'R') THEN
1031: IF (p_settings.style = 'X') THEN
1032: p_from_date := p_settings.start_date;
1033: p_to_date := p_settings.end_date;
1034: QRM_PA_AGGREGATION_P.calc_tb_start_end_dates (
1035: p_settings.analysis_name, p_ref_date, p_settings.tb_name,
1036: p_settings.tb_label, p_to_date,
1037: p_settings.end_date_ref, p_settings.end_date_offset,
1038: p_settings.end_offset_type, p_settings.date_type,

Line 1044: p_from_date :=QRM_PA_AGGREGATION_P.calculate_relative_date(

1040: p_from_date, p_settings.start_date_ref,
1041: p_settings.start_date_offset, p_settings.start_offset_type,
1042: p_settings.analysis_type);
1043: ELSE
1044: p_from_date :=QRM_PA_AGGREGATION_P.calculate_relative_date(
1045: p_ref_date, p_settings.date_type, p_settings.start_date,
1046: p_settings.start_date_ref, p_settings.start_date_offset,
1047: p_settings.start_offset_type, p_settings.gl_calendar_id,
1048: p_settings.business_week);

Line 1050: p_to_date := QRM_PA_AGGREGATION_P.calculate_relative_date(

1046: p_settings.start_date_ref, p_settings.start_date_offset,
1047: p_settings.start_offset_type, p_settings.gl_calendar_id,
1048: p_settings.business_week);
1049:
1050: p_to_date := QRM_PA_AGGREGATION_P.calculate_relative_date(
1051: p_ref_date, p_settings.date_type, p_settings.end_date,
1052: p_settings.end_date_ref, p_settings.end_date_offset,
1053: p_settings.end_offset_type, p_settings.gl_calendar_id,
1054: p_settings.business_week);

Line 6554: p_agg_ok := QRM_PA_AGGREGATION_P.transform_and_save(p_analysis_name,

6550: IF (p_settings.style <> 'T' and retcode <> '5') THEN
6551: IF (g_proc_level>=g_debug_level) THEN
6552: XTR_RISK_DEBUG_PKG.dlog('run_analysis: ' || 'about to aggregate');
6553: END IF;
6554: p_agg_ok := QRM_PA_AGGREGATION_P.transform_and_save(p_analysis_name,
6555: p_ref_datetime, 'CONC');
6556:
6557: IF (p_agg_ok = 'F') THEN -- unhandled exception in aggregator
6558: IF (g_proc_level>=g_debug_level) THEN

Line 6651: WHEN QRM_PA_AGGREGATION_P.e_pagg_no_fxrate_found THEN

6647: XTR_RISK_DEBUG_PKG.dlog('EXCEPTION','QRM_ANA_RUN_IN_PROGRESS',
6648: 'QRM_PA_CALCULATIONS_P.RUN_ANALYSIS',
6649: g_error_level);
6650: END IF;
6651: WHEN QRM_PA_AGGREGATION_P.e_pagg_no_fxrate_found THEN
6652: -- clear previous warnings
6653: p_except_counter := 0;
6654: p_except_deal_no.DELETE;
6655: p_except_transaction_no.DELETE;

Line 6681: WHEN QRM_PA_AGGREGATION_P.e_pagg_no_timebuckets_found THEN

6677: XTR_RISK_DEBUG_PKG.dlog('EXCEPTION','QRM_CALC_NO_DEFAULT_SPOT_ERR',
6678: 'QRM_PA_CALCULATIONS_P.RUN_ANALYSIS',
6679: g_error_level);
6680: END IF;
6681: WHEN QRM_PA_AGGREGATION_P.e_pagg_no_timebuckets_found THEN
6682: -- clear previous warnings
6683: p_except_counter := 0;
6684: p_except_deal_no.DELETE;
6685: p_except_transaction_no.DELETE;

Line 6711: WHEN QRM_PA_AGGREGATION_P.e_pagg_no_setting_found THEN

6707: XTR_RISK_DEBUG_PKG.dlog('EXCEPTION','QRM_ANA_NO_TIMEBUCKETS',
6708: 'QRM_PA_CALCULATIONS_P.RUN_ANALYSIS',
6709: g_error_level);
6710: END IF;
6711: WHEN QRM_PA_AGGREGATION_P.e_pagg_no_setting_found THEN
6712: -- clear previous warnings
6713: p_except_counter := 0;
6714: p_except_deal_no.DELETE;
6715: p_except_transaction_no.DELETE;

Line 6737: XTR_RISK_DEBUG_PKG.dlog('EXCEPTION','QRM_PA_AGGREGATION_P.E_PAGG_NO_SETTING_FOUND',

6733: p_except_token_name(p_except_counter) := 'ANALYSIS_NAME';
6734: p_except_token_value(p_except_counter) := p_analysis_name;
6735: --bug 3236479
6736: IF (g_proc_level>=g_ERROR_level) THEN
6737: XTR_RISK_DEBUG_PKG.dlog('EXCEPTION','QRM_PA_AGGREGATION_P.E_PAGG_NO_SETTING_FOUND',
6738: 'QRM_PA_CALCULATIONS_P.RUN_ANALYSIS',
6739: g_error_level);
6740: END IF;
6741: WHEN others THEN