APPS.QPR_DEAL_ETL dependencies on FND_PROFILE

Line 544: l_pocmrg_score_wt := nvl(fnd_profile.value('QPR_MRG_SCORE_WT'),0);

540: end if;
541:
542: log_debug('Invoice Price part of score: ' || l_inv_pr_score);
543:
544: l_pocmrg_score_wt := nvl(fnd_profile.value('QPR_MRG_SCORE_WT'),0);
545: l_invpr_score_wt := nvl(fnd_profile.value('QPR_INVPR_SCORE_WT'), 0);
546:
547: l_line_score := (l_pocmrg_score_wt * l_pocmrg_score +
548: l_invpr_score_wt * l_inv_pr_score)

Line 545: l_invpr_score_wt := nvl(fnd_profile.value('QPR_INVPR_SCORE_WT'), 0);

541:
542: log_debug('Invoice Price part of score: ' || l_inv_pr_score);
543:
544: l_pocmrg_score_wt := nvl(fnd_profile.value('QPR_MRG_SCORE_WT'),0);
545: l_invpr_score_wt := nvl(fnd_profile.value('QPR_INVPR_SCORE_WT'), 0);
546:
547: l_line_score := (l_pocmrg_score_wt * l_pocmrg_score +
548: l_invpr_score_wt * l_inv_pr_score)
549: / (l_pocmrg_score_wt + l_invpr_score_wt);

Line 1586: l_transf_group_id := to_number(nvl(fnd_profile.value(

1582: l_slope number;
1583: l_intercept number;
1584: begin
1585: log_debug('Determining prerequisites for line processing...');
1586: l_transf_group_id := to_number(nvl(fnd_profile.value(
1587: 'QPR_VOL_BAND_DEAL'),0));
1588:
1589: for c_int_header_rec in c_int_hdr loop
1590: for int_lines_rec in c_int_lines(c_int_header_rec.source_id) loop

Line 2423: l_transf_group_id := to_number(nvl(fnd_profile.value('QPR_VOL_BAND_DEAL'),0));

2419: else
2420: l_uom_conversion_odm := 0;
2421: end if;
2422:
2423: l_transf_group_id := to_number(nvl(fnd_profile.value('QPR_VOL_BAND_DEAL'),0));
2424:
2425: if l_uom_conversion_odm < 0 then
2426: l_vol_band := null;
2427: else