APPS.OPI_DBI_INV_CURR_RPT_PKG dependencies on BIS_QUERY_ATTRIBUTES

Line 103: BIS_QUERY_ATTRIBUTES_TBL)

99: */
100: PROCEDURE get_curr_inv_exp_stat_sql (p_param IN BIS_PMV_PAGE_PARAMETER_TBL,
101: x_custom_sql OUT NOCOPY VARCHAR2,
102: x_custom_output OUT NOCOPY
103: BIS_QUERY_ATTRIBUTES_TBL)
104: IS
105: -- {
106: l_query VARCHAR2 (32767);
107:

Line 121: l_custom_rec BIS_QUERY_ATTRIBUTES;

117: l_mv VARCHAR2 (30);
118:
119: l_aggr_level_flag VARCHAR2(1);
120:
121: l_custom_rec BIS_QUERY_ATTRIBUTES;
122:
123: l_cur_suffix VARCHAR2 (5);
124:
125: l_filter_clause VARCHAR2 (20000);

Line 131: x_custom_output := BIS_QUERY_ATTRIBUTES_TBL ();

127: BEGIN
128: -- {
129: -- initialization block
130: x_custom_sql := NULL;
131: x_custom_output := BIS_QUERY_ATTRIBUTES_TBL ();
132: l_custom_rec := BIS_PMV_PARAMETERS_PUB.INITIALIZE_QUERY_TYPE;
133: l_query := NULL;
134: l_view_by := NULL;
135: l_view_by_col := NULL;

Line 458: BIS_QUERY_ATTRIBUTES_TBL)

454: */
455: PROCEDURE get_inv_days_onh_sql (p_param IN BIS_PMV_PAGE_PARAMETER_TBL,
456: x_custom_sql OUT NOCOPY VARCHAR2,
457: x_custom_output OUT NOCOPY
458: BIS_QUERY_ATTRIBUTES_TBL)
459: IS
460: -- {
461: l_query VARCHAR2 (32767);
462:

Line 490: l_custom_rec BIS_QUERY_ATTRIBUTES;

486: l_onh_aggr_level_flag VARCHAR2(1);
487: l_prod_aggr_level_flag VARCHAR2(1);
488: l_ship_aggr_level_flag VARCHAR2(1);
489:
490: l_custom_rec BIS_QUERY_ATTRIBUTES;
491:
492: l_filter_clause VARCHAR2 (20000);
493:
494: l_unionall_tbl poa_dbi_util_pkg.POA_DBI_MV_TBL;

Line 502: x_custom_output := BIS_QUERY_ATTRIBUTES_TBL ();

498: BEGIN
499: -- {
500: -- initialization block
501: x_custom_sql := NULL;
502: x_custom_output := BIS_QUERY_ATTRIBUTES_TBL ();
503: l_custom_rec := BIS_PMV_PARAMETERS_PUB.INITIALIZE_QUERY_TYPE;
504: l_query := NULL;
505: l_view_by := NULL;
506: l_view_by_col := NULL;

Line 1133: BIS_QUERY_ATTRIBUTES_TBL)

1129: */
1130: PROCEDURE get_curr_inv_stat_sql (p_param IN BIS_PMV_PAGE_PARAMETER_TBL,
1131: x_custom_sql OUT NOCOPY VARCHAR2,
1132: x_custom_output OUT NOCOPY
1133: BIS_QUERY_ATTRIBUTES_TBL)
1134: IS
1135: -- {
1136: l_query VARCHAR2 (32767);
1137:

Line 1153: l_custom_rec BIS_QUERY_ATTRIBUTES;

1149: l_mv VARCHAR2 (30);
1150:
1151: l_aggr_level_flag VARCHAR2(1);
1152:
1153: l_custom_rec BIS_QUERY_ATTRIBUTES;
1154:
1155: l_cur_suffix VARCHAR2 (5);
1156:
1157: l_filter_clause VARCHAR2 (20000);

Line 1172: x_custom_output := BIS_QUERY_ATTRIBUTES_TBL ();

1168: BEGIN
1169: -- {
1170: -- initialization block
1171: x_custom_sql := NULL;
1172: x_custom_output := BIS_QUERY_ATTRIBUTES_TBL ();
1173: l_custom_rec := BIS_PMV_PARAMETERS_PUB.INITIALIZE_QUERY_TYPE;
1174: l_query := NULL;
1175: l_view_by := NULL;
1176: l_view_by_col := NULL;