APPS.HRI_BPL_FACT_ABS_SQL dependencies on STANDARD

Line 10: g_template_standard VARCHAR2(1000);

6: g_binds g_bind_rec_tab_type;
7: g_binds_reset g_bind_rec_tab_type;
8:
9: -- Templates for SELECT columns
10: g_template_standard VARCHAR2(1000);
11: g_template_abs_period VARCHAR2(1000);
12: g_template_bucket VARCHAR2(1000);
13:
14: g_rtn VARCHAR2(30) := '

Line 28: /* All columns have one of a few standard formats. Global variables store */

24: /* SELECT */
25: /* ------ */
26: /* For details of the SELECT column list see package header */
27: /* */
28: /* All columns have one of a few standard formats. Global variables store */
29: /* templates for these formats with tags in for swapping in and out parts */
30: /* of the template (such as measure column, bucket column, bucket value) */
31: /* */
32: /* The columns in the select clause are controlled by various fields in the */

Line 94: g_template_standard :=

90:
91: IF p_use_snapshot THEN
92:
93: /* Define generic select column */
94: g_template_standard :=
95: 'SUM(CASE WHEN absn.effective_date BETWEEN AND
96: THEN
97: ELSE 0
98: END)';

Line 119: g_template_standard :=

115:
116: ELSE
117:
118: /* Define generic select column */
119: g_template_standard :=
120: 'SUM(CASE WHEN absn.effective_date BETWEEN AND
121: THEN
122: ELSE 0
123: END)';

Line 371: p_template_standard IN VARCHAR2,

367: /******************************************************************************/
368: FUNCTION build_columns
369: (p_parameter_rec IN hri_oltp_pmv_util_param.HRI_PMV_PARAM_REC_TYPE,
370: p_abs_params IN abs_fact_param_type,
371: p_template_standard IN VARCHAR2,
372: p_template_bucket IN VARCHAR2,
373: p_measure_alias IN VARCHAR2)
374: RETURN VARCHAR2 IS
375:

Line 390: (p_column_string => p_template_standard

386:
387: /* Always get the column for the current period */
388: /************************************************/
389: l_column_list := l_column_list || format_column
390: (p_column_string => p_template_standard
391: ,p_start_date => g_binds('TIME_CURR_START_DATE')
392: ,p_end_date => g_binds('TIME_CURR_END_DATE')
393: ,p_bucket_id => NULL
394: ,p_column_alias => 'curr_' || p_measure_alias);

Line 400: (p_column_string => p_template_standard

396: /* Check for comparison period columns */
397: /***************************************/
398: IF (p_abs_params.include_comp = 'Y') THEN
399: l_column_list := l_column_list || format_column
400: (p_column_string => p_template_standard
401: ,p_start_date => g_binds('TIME_COMP_START_DATE')
402: ,p_end_date => g_binds('TIME_COMP_END_DATE')
403: ,p_bucket_id => NULL
404: ,p_column_alias => 'comp_' || p_measure_alias);

Line 533: p_template_standard => REPLACE(g_template_standard, '', 'abs_drtn_days'),

529: IF (p_abs_params.include_abs_drtn_days = 'Y') THEN
530: l_col_list := l_col_list || build_columns
531: (p_parameter_rec => p_parameter_rec,
532: p_abs_params => p_abs_params,
533: p_template_standard => REPLACE(g_template_standard, '', 'abs_drtn_days'),
534: p_template_bucket => REPLACE(g_template_bucket, '', 'abs_drtn_days'),
535: p_measure_alias => 'abs_drtn_days');
536: END IF;
537:

Line 543: p_template_standard => REPLACE(g_template_standard, '', 'abs_drtn_hrs'),

539: IF (p_abs_params.include_abs_drtn_hrs = 'Y') THEN
540: l_col_list := l_col_list || build_columns
541: (p_parameter_rec => p_parameter_rec,
542: p_abs_params => p_abs_params,
543: p_template_standard => REPLACE(g_template_standard, '', 'abs_drtn_hrs'),
544: p_template_bucket => REPLACE(g_template_bucket, '', 'abs_drtn_hrs'),
545: p_measure_alias => 'abs_drtn_hrs');
546: END IF;
547:

Line 556: p_template_standard => l_template_abs_period,

552: IF (p_abs_params.include_abs_in_period = 'Y') THEN
553: l_col_list := l_col_list || build_columns
554: (p_parameter_rec => p_parameter_rec,
555: p_abs_params => p_abs_params,
556: p_template_standard => l_template_abs_period,
557: p_template_bucket => REPLACE(g_template_bucket, '', 'abs_start_blnc + abs_nstart_blnc'),
558: p_measure_alias => 'abs_in_period');
559: END IF;
560:

Line 569: p_template_standard => l_template_abs_period,

565: IF (p_abs_params.include_abs_ntfctn_period = 'Y') THEN
566: l_col_list := l_col_list || build_columns
567: (p_parameter_rec => p_parameter_rec,
568: p_abs_params => p_abs_params,
569: p_template_standard => l_template_abs_period,
570: p_template_bucket => REPLACE(g_template_bucket, '', 'abs_ntfctn_days_start_blnc + abs_ntfctn_days_nstart_blnc'),
571: p_measure_alias => 'abs_ntfctn_period');
572: END IF;
573: