APPS.BIC_SUMMARY_EXTRACT_PKG dependencies on BIC_MEASURE_BUCKETS

Line 518: from bic_measure_buckets

514: p_bucket_id in out NOCOPY number,
515: p_bucket_points in out NOCOPY number) as
516: cursor bucket_cur is
517: select bucket_id, bucket_points --into p_bucket_id, p_bucket_points
518: from bic_measure_buckets
519: where nvl(p_value,0) >= nvl(low_value,0)
520: and nvl(p_value,0) < nvl(high_value,p_value+2)
521: and measure_id = p_measure_id
522: order by low_value;

Line 562: x_bucket_points bic_measure_buckets.bucket_points % type;

558: for update of score, bucket_id;
559: x_value bic_customer_summary_all.value % type;
560: x_org_id bic_customer_summary_all.org_id % type;
561: x_measure_id bic_customer_summary_all.measure_id % type;
562: x_bucket_points bic_measure_buckets.bucket_points % type;
563: x_bucket_id bic_measure_buckets.bucket_id % type;
564: x_weight bic_measures_all.weight % type;
565: x_measure_code bic_measures_all.measure_code % type;
566: begin

Line 563: x_bucket_id bic_measure_buckets.bucket_id % type;

559: x_value bic_customer_summary_all.value % type;
560: x_org_id bic_customer_summary_all.org_id % type;
561: x_measure_id bic_customer_summary_all.measure_id % type;
562: x_bucket_points bic_measure_buckets.bucket_points % type;
563: x_bucket_id bic_measure_buckets.bucket_id % type;
564: x_weight bic_measures_all.weight % type;
565: x_measure_code bic_measures_all.measure_code % type;
566: begin
567: g_proc_name_old := g_proc_name;

Line 600: x_bucket_points bic_measure_buckets.bucket_points % type;

596: p_index varchar2 default null) as
597: x_measure_id bic_measures_all.measure_id % type;
598: x_bucket_id bic_customer_summary_all.bucket_id % type;
599: x_weight bic_measures_all.weight % type;
600: x_bucket_points bic_measure_buckets.bucket_points % type;
601: x_score bic_customer_summary_all.score % type;
602: x_dummy bic_measures_all.measure_code % type;
603: begin
604: -- do not insert ant record if value is null.

Line 694: x_bucket_points bic_measure_buckets.bucket_points % type;

690: x_customer_id bic_customer_summary_all.customer_id % type;
691: x_period_start_date bic_customer_summary_all.period_start_date % type;
692: x_value bic_customer_summary_all.value % type;
693: x_org_id bic_customer_summary_all.org_id % type;
694: x_bucket_points bic_measure_buckets.bucket_points % type;
695: x_weight bic_measures_all.weight % type;
696: x_measure_code bic_measures_all.measure_code % type;
697:
698: x_num number;

Line 2558: from bic_measure_buckets b, (' || x_stmnt2 || ') a

2554: ',sysdate
2555: ,sysdate
2556: ,' || to_char(g_created_by) || ',' ||
2557: to_char(g_last_updated_by) || '
2558: from bic_measure_buckets b, (' || x_stmnt2 || ') a
2559: where a.measure_id = b.measure_id(+)
2560: and nvl(a.value,0) >= nvl(b.low_value (+),0)
2561: and nvl(a.value,0) < nvl(b.high_value (+),
2562: nvl(a.value,0)+2) ';