APPS.OPI_DBI_CC_RPT_PKG dependencies on BIS_QUERY_ATTRIBUTES_TBL

Line 45: x_custom_output OUT NOCOPY BIS_QUERY_ATTRIBUTES_TBL)

41: Cycle Count Accuracy Report Function
42: ----------------------------------------*/
43: PROCEDURE get_tbl_sql (p_param IN BIS_PMV_PAGE_PARAMETER_TBL,
44: x_custom_sql OUT NOCOPY VARCHAR2,
45: x_custom_output OUT NOCOPY BIS_QUERY_ATTRIBUTES_TBL)
46: IS
47: l_query VARCHAR2(32767);
48: l_view_by VARCHAR2(120);
49: l_view_by_col VARCHAR2 (120);

Line 145: x_custom_output := BIS_QUERY_ATTRIBUTES_TBL();

141: p_generate_viewby => 'Y',
142: p_in_join_tables => NULL);
143:
144: -- prepare output for bind variables
145: x_custom_output := BIS_QUERY_ATTRIBUTES_TBL();
146: l_custom_rec := BIS_PMV_PARAMETERS_PUB.INITIALIZE_QUERY_TYPE;
147:
148: -- set the basic bind variables for the status SQL
149: poa_dbi_util_pkg.get_custom_status_binds (x_custom_output);

Line 469: BIS_QUERY_ATTRIBUTES_TBL)

465: ----------------------------------------*/
466: PROCEDURE get_trd_sql (p_param IN BIS_PMV_PAGE_PARAMETER_TBL,
467: x_custom_sql OUT NOCOPY VARCHAR2,
468: x_custom_output OUT NOCOPY
469: BIS_QUERY_ATTRIBUTES_TBL)
470: IS
471: l_query VARCHAR2(32767);
472: l_view_by VARCHAR2(120);
473: l_view_by_col VARCHAR2 (120);

Line 567: x_custom_output := BIS_QUERY_ATTRIBUTES_TBL();

563: p_use_grpid => 'N');
564:
565:
566: -- Prepare PMV bind variables
567: x_custom_output := BIS_QUERY_ATTRIBUTES_TBL();
568: l_custom_rec := BIS_PMV_PARAMETERS_PUB.INITIALIZE_QUERY_TYPE;
569:
570: -- get all the basic binds used by POA queries
571: -- Do this before adding any of our binds, since the procedure

Line 662: x_custom_output OUT NOCOPY BIS_QUERY_ATTRIBUTES_TBL

658:
659: PROCEDURE get_hm_tbl_sql(
660: p_param IN BIS_PMV_PAGE_PARAMETER_TBL,
661: x_custom_sql OUT NOCOPY VARCHAR2,
662: x_custom_output OUT NOCOPY BIS_QUERY_ATTRIBUTES_TBL
663: )
664: IS
665: l_query VARCHAR2(32767);
666: l_view_by VARCHAR2(120);

Line 757: x_custom_output := BIS_QUERY_ATTRIBUTES_TBL();

753: p_generate_viewby => 'Y',
754: p_in_join_tables => NULL);
755:
756: -- prepare output for bind variables
757: x_custom_output := BIS_QUERY_ATTRIBUTES_TBL();
758: l_custom_rec := BIS_PMV_PARAMETERS_PUB.INITIALIZE_QUERY_TYPE;
759:
760: -- set the basic bind variables for the status SQL
761: poa_dbi_util_pkg.get_custom_status_binds (x_custom_output);

Line 974: x_custom_output OUT NOCOPY BIS_QUERY_ATTRIBUTES_TBL

970: ----------------------------------------*/
971: PROCEDURE get_adj_tbl_sql(
972: p_param IN BIS_PMV_PAGE_PARAMETER_TBL,
973: x_custom_sql OUT NOCOPY VARCHAR2,
974: x_custom_output OUT NOCOPY BIS_QUERY_ATTRIBUTES_TBL
975: )
976: IS
977: l_query VARCHAR2(32767);
978: l_view_by VARCHAR2(120);

Line 1096: x_custom_output := BIS_QUERY_ATTRIBUTES_TBL();

1092: p_generate_viewby => 'Y',
1093: p_in_join_tables => NULL);
1094:
1095: -- prepare output for bind variables
1096: x_custom_output := BIS_QUERY_ATTRIBUTES_TBL();
1097: l_custom_rec := BIS_PMV_PARAMETERS_PUB.INITIALIZE_QUERY_TYPE;
1098:
1099: -- set the basic bind variables for the status SQL
1100: poa_dbi_util_pkg.get_custom_status_binds (x_custom_output);

Line 1316: x_custom_output OUT NOCOPY BIS_QUERY_ATTRIBUTES_TBL)

1312: Cycle Count Adjustment Detail Report Function
1313: ----------------------------------------*/
1314: PROCEDURE get_adj_dtl_sql (p_param IN BIS_PMV_PAGE_PARAMETER_TBL,
1315: x_custom_sql OUT NOCOPY VARCHAR2,
1316: x_custom_output OUT NOCOPY BIS_QUERY_ATTRIBUTES_TBL)
1317: IS
1318: l_query VARCHAR2(32767);
1319: l_view_by VARCHAR2(120);
1320: l_view_by_col VARCHAR2 (120);

Line 1446: x_custom_output := BIS_QUERY_ATTRIBUTES_TBL();

1442: p_generate_viewby => 'Y',
1443: p_in_join_tables => NULL);
1444:
1445: -- prepare output for bind variables
1446: x_custom_output := BIS_QUERY_ATTRIBUTES_TBL();
1447: l_custom_rec := BIS_PMV_PARAMETERS_PUB.INITIALIZE_QUERY_TYPE;
1448:
1449: -- set the basic bind variables for the status SQL
1450: poa_dbi_util_pkg.get_custom_status_binds (x_custom_output);