[Home] [Help]
7: g_binds g_bind_rec_tab_type;
8: g_binds_reset g_bind_rec_tab_type;
9:
10: -- Templates for SELECT columns
11: g_template_standard VARCHAR2(1000);
12: g_template_bucket VARCHAR2(1000);
13: g_template_total VARCHAR2(1000);
14: g_template_total_bucket VARCHAR2(1000);
15:
29: /* */
30: /* Note: Snapshot MVs have a different column format and are handled by */
31: /* a different set of functions */
32: /* */
33: /* All columns have one of a few standard formats. Global variables store */
34: /* templates for these formats with tags in for swapping in and out parts */
35: /* of the template (such as measure column, bucket column, bucket value) */
36: /* */
37: /* The columns in the select clause are controlled by various fields in the */
97:
98: BEGIN
99:
100: /* Define generic select column */
101: g_template_standard :=
102: 'SUM(CASE WHEN effective_date =
103: THEN
104: ELSE 0
105: END)';
674: l_template_total_bucket := g_template_total_bucket;
675: l_template_total := g_template_total;
676: ELSE
677: l_template_total_bucket := g_template_bucket;
678: l_template_total := g_template_standard;
679: END IF;
680:
681: /* Set bucket column if applicable */
682: IF (p_wrkfc_params.bucket_dim IS NOT NULL) THEN
701: p_wrkfc_total => 'N',
702: p_include_comp => p_wrkfc_params.include_comp,
703: p_include_start => l_include_start,
704: p_bucket_dim => p_wrkfc_params.bucket_dim,
705: p_select_template => g_template_standard,
706: p_bucket_template => l_template_bucket,
707: p_measure_alias => p_measure_alias)
708: || build_columns
709: (p_parameter_rec => p_parameter_rec,
1394: p_fact_conditions => l_fact_conditions);
1395:
1396: ELSE
1397:
1398: /* Build SQL statement using standard procedure */
1399: l_return_sql := build_sql
1400: (p_parameter_rec => p_parameter_rec,
1401: p_wrkfc_params => p_wrkfc_params,
1402: p_fact_table => l_fact_table,