APPS.POA_DBI_NEG_PKG dependencies on POA_DBI_TEMPLATE_PKG

Line 124: poa_dbi_template_pkg.status_sql(l_mv,

120:
121: l_url := 'pFunctionName=POA_DBI_NEG_SUM_STATUS_RPT&VIEW_BY_NAME=VIEW_BY_ID&VIEW_BY=SUPPLIER+POA_SUPPLIERS&pParamIds=Y';
122:
123: l_query := get_status_sel_clause(l_view_by, l_view_by_col, l_url) || ' from ' ||
124: poa_dbi_template_pkg.status_sql(l_mv,
125: l_where_clause,
126: l_join_tbl,
127: p_use_windowing => 'Y',
128: p_col_name => l_col_tbl,

Line 396: poa_dbi_template_pkg.status_sql(l_mv,

392: ,p_to_date_type => l_to_date_type);
393: end if;
394:
395: l_query := get_awd_status_sel_clause(l_view_by, l_view_by_col) || ' from ' ||
396: poa_dbi_template_pkg.status_sql(l_mv,
397: l_where_clause,
398: l_join_tbl,
399: p_use_windowing => 'Y',
400: p_col_name => l_col_tbl,

Line 630: poa_dbi_template_pkg.status_sql(l_mv,

626: ,p_prior_code => 1);
627: end if;
628:
629: l_query := get_avg_cycle_time_sel_clause(l_view_by, l_view_by_col) || ' from ' ||
630: poa_dbi_template_pkg.status_sql(l_mv,
631: l_where_clause,
632: l_join_tbl,
633: p_use_windowing => 'Y',
634: p_col_name => l_col_tbl,

Line 848: poa_dbi_template_pkg.status_sql(l_mv,

844: end if;
845:
846:
847: l_query := get_realized_status_sel_clause(l_view_by, l_view_by_col) || ' from ' ||
848: poa_dbi_template_pkg.status_sql(l_mv,
849: l_where_clause,
850: l_join_tbl,
851: p_use_windowing => 'Y',
852: p_col_name => l_col_tbl,

Line 1092: || poa_dbi_template_pkg.trend_sql(

1088: poa_dbi_util_pkg.add_column(l_col_tbl, 'award_amt_' || l_cur_suffix, 'award_amt','N',3,p_to_date_type => l_to_date_type);
1089:
1090: l_query := get_awd_trend_sel_clause || '
1091: from '
1092: || poa_dbi_template_pkg.trend_sql(
1093: l_xtd,
1094: l_comparison_type,
1095: l_mv,
1096: l_where_clause,

Line 1187: || poa_dbi_template_pkg.trend_sql(

1183: poa_dbi_util_pkg.add_column(l_col_tbl, 'c_total', 'count','N',3,p_to_date_type => l_to_date_type);
1184:
1185: l_query := get_avg_cycle_trend_sel_clause || '
1186: from '
1187: || poa_dbi_template_pkg.trend_sql(
1188: l_xtd,
1189: l_comparison_type,
1190: l_mv,
1191: l_where_clause,

Line 1279: || poa_dbi_template_pkg.trend_sql(

1275: poa_dbi_util_pkg.add_column(l_col_tbl, 'proj_savings_amt_' || l_cur_suffix, 'proj_savings_amt','N',3,p_to_date_type => l_to_date_type);
1276:
1277: l_query := get_prj_svng_trend_sel_clause || '
1278: from '
1279: || poa_dbi_template_pkg.trend_sql(
1280: l_xtd,
1281: l_comparison_type,
1282: l_mv,
1283: l_where_clause,

Line 1372: || poa_dbi_template_pkg.trend_sql(

1368: poa_dbi_util_pkg.add_column(l_col_tbl, 'neg_lines_with_cp', 'neg_lines_with_cp','N',3,p_to_date_type => l_to_date_type);
1369:
1370: l_query := get_prj_ln_trend_sel_clause || '
1371: from '
1372: || poa_dbi_template_pkg.trend_sql(
1373: l_xtd,
1374: l_comparison_type,
1375: l_mv,
1376: l_where_clause,

Line 1467: || poa_dbi_template_pkg.trend_sql(

1463: poa_dbi_util_pkg.add_column(l_col_tbl, 'real_svngs_amt_' || l_cur_suffix, 'real_svngs_amt','N',3,p_to_date_type => l_to_date_type);
1464:
1465: l_query := get_real_svng_trend_sel_clause || '
1466: from '
1467: || poa_dbi_template_pkg.trend_sql(
1468: l_xtd,
1469: l_comparison_type,
1470: l_mv,
1471: l_where_clause,

Line 1559: || poa_dbi_template_pkg.trend_sql(

1555: poa_dbi_util_pkg.add_column(l_col_tbl, 'purchase_amt_' || l_cur_suffix, 'purchase_amt','N',3,p_to_date_type => l_to_date_type);
1556:
1557: l_query := get_neg_po_trend_sel_clause || '
1558: from '
1559: || poa_dbi_template_pkg.trend_sql(
1560: l_xtd,
1561: l_comparison_type,
1562: l_mv,
1563: l_where_clause,