APPS.QPR_POLICY_EVAL dependencies on QPR_SR_UTIL

Line 42: if i_psg_id = qpr_sr_util.get_null_pk then

38: order by policy_measure_type_code, policy_type_code, vlb_level_value;
39: begin
40:
41: if i_policy_id is null then
42: if i_psg_id = qpr_sr_util.get_null_pk then
43: l_policy_id := fnd_profile.value('QPR_DEFAULT_POLICY');
44: else
45: select DEFAULT_POLICY_ID into l_policy_id
46: from qpr_pr_segments_b

Line 154: o_pr_segment_id := qpr_sr_util.get_null_pk;

150: where rownum < 2;
151:
152: exception
153: when NO_DATA_FOUND then
154: o_pr_segment_id := qpr_sr_util.get_null_pk;
155: o_pol_importance_code := null;
156: when OTHERS then
157: o_pr_segment_id := null;
158: o_pol_importance_code := null;

Line 484: l_med_sev_thre := to_number(nvl(qpr_sr_util.read_parameter(

480: end clean_policy_data;
481:
482: begin
483: log_debug('Start.. ');
484: l_med_sev_thre := to_number(nvl(qpr_sr_util.read_parameter(
485: 'QPR_DEVIATION_SEVERE_MED'),0));
486: l_high_sev_thre := to_number(nvl(qpr_sr_util.read_parameter(
487: 'QPR_DEVIATION_SEVERE_HIGH'),0));
488: open c_measures;

Line 486: l_high_sev_thre := to_number(nvl(qpr_sr_util.read_parameter(

482: begin
483: log_debug('Start.. ');
484: l_med_sev_thre := to_number(nvl(qpr_sr_util.read_parameter(
485: 'QPR_DEVIATION_SEVERE_MED'),0));
486: l_high_sev_thre := to_number(nvl(qpr_sr_util.read_parameter(
487: 'QPR_DEVIATION_SEVERE_HIGH'),0));
488: open c_measures;
489: loop
490: clean_meas_data;