APPS.OPI_DBI_PTP_RPT_PKG dependencies on BIS_QUERY_ATTRIBUTES

Line 7: x_custom_output OUT NOCOPY BIS_QUERY_ATTRIBUTES_TBL

3:
4: PROCEDURE GET_TBL_SQL(
5: p_param IN BIS_PMV_PAGE_PARAMETER_TBL,
6: x_custom_sql OUT NOCOPY VARCHAR2,
7: x_custom_output OUT NOCOPY BIS_QUERY_ATTRIBUTES_TBL
8: ) IS
9: l_formula_sql VARCHAR2(4000) := '';
10: l_inner_sql VARCHAR2(8000) := '';
11: l_stmt VARCHAR2(10240) := '';

Line 25: l_custom_rec BIS_QUERY_ATTRIBUTES;

21: l_item_cat_flag NUMBER; -- 0 for item and 1 for inv. category
22: l_currency VARCHAR2(30) := '';
23: l_currency_code VARCHAR2(2) := 'B';
24: l_lang_code VARCHAR2(20) := NULL;
25: l_custom_rec BIS_QUERY_ATTRIBUTES;
26: l_curr_asof_date DATE;
27: l_prev_asof_date DATE;
28: l_nested_pattern NUMBER;
29:

Line 135: x_custom_output := BIS_QUERY_ATTRIBUTES_TBL();

131: l_item_cat_flag := 0; -- item
132: END IF;
133:
134: l_custom_rec := BIS_PMV_PARAMETERS_PUB.INITIALIZE_QUERY_TYPE;
135: x_custom_output := BIS_QUERY_ATTRIBUTES_TBL();
136:
137: l_formula_sql :='CURR_PLANNED_QUANTITY OPI_MEASURE1,
138: PREV_PLANNED_STANDARD_VALUE OPI_MEASURE2,
139: CURR_PLANNED_STANDARD_VALUE OPI_MEASURE3,

Line 377: x_custom_output OUT NOCOPY BIS_QUERY_ATTRIBUTES_TBL

373:
374: PROCEDURE GET_TRD_SQL(
375: p_param IN BIS_PMV_PAGE_PARAMETER_TBL,
376: x_custom_sql OUT NOCOPY VARCHAR2,
377: x_custom_output OUT NOCOPY BIS_QUERY_ATTRIBUTES_TBL
378: ) IS
379:
380: l_formula_sql VARCHAR2(4000) := '';
381: l_inner_sql VARCHAR2(6000) := '';

Line 396: l_custom_rec BIS_QUERY_ATTRIBUTES;

392: l_currency VARCHAR2(30) := '';
393: l_currency_code VARCHAR2(2) := 'B';
394: l_nested_pattern NUMBER;
395: l_period_id VARCHAR2(20);
396: l_custom_rec BIS_QUERY_ATTRIBUTES;
397: l_curr_asof_date DATE;
398: l_prev_asof_date DATE;
399: l_curr_rpt_start_date DATE;
400: l_prev_rpt_start_date DATE;

Line 506: x_custom_output := BIS_QUERY_ATTRIBUTES_TBL();

502: END IF;
503: END IF;
504:
505: l_custom_rec := BIS_PMV_PARAMETERS_PUB.INITIALIZE_QUERY_TYPE;
506: x_custom_output := BIS_QUERY_ATTRIBUTES_TBL();
507:
508: l_stmt :=
509: 'SELECT
510: fii.NAME VIEWBY,

Line 775: x_custom_output OUT NOCOPY BIS_QUERY_ATTRIBUTES_TBL

771:
772: PROCEDURE GET_CMLTV_TRD_SQL(
773: p_param IN BIS_PMV_PAGE_PARAMETER_TBL,
774: x_custom_sql OUT NOCOPY VARCHAR2,
775: x_custom_output OUT NOCOPY BIS_QUERY_ATTRIBUTES_TBL
776: ) IS
777: l_formula_sql VARCHAR2(4000) := '';
778: l_inner_sql VARCHAR2(6000) := '';
779: l_stmt VARCHAR2(8000) := '';

Line 794: l_custom_rec BIS_QUERY_ATTRIBUTES;

790: l_currency_code VARCHAR2(2) := 'B';
791: l_period_detail VARCHAR2(30);
792: l_nested_pattern NUMBER;
793: l_period_id VARCHAR2(20);
794: l_custom_rec BIS_QUERY_ATTRIBUTES;
795: l_pmv_nested_pattern NUMBER;
796: l_curr_asof_date DATE;
797: l_curr_eft_start_date DATE;
798: l_curr_eft_end_date DATE;

Line 932: x_custom_output := BIS_QUERY_ATTRIBUTES_TBL();

928: END IF;
929: END IF;
930:
931: l_custom_rec := BIS_PMV_PARAMETERS_PUB.INITIALIZE_QUERY_TYPE;
932: x_custom_output := BIS_QUERY_ATTRIBUTES_TBL();
933:
934: l_stmt :='SELECT fact.name VIEWBY,
935: CURR_ACTUAL_STANDARD_VALUE OPI_MEASURE1,
936: CURR_PLANNED_STANDARD_VALUE OPI_MEASURE2,