eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.OPI_DBI_CC_RPT_PKG dependencies on BIS_QUERY_ATTRIBUTES

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 63: l_custom_rec BIS_QUERY_ATTRIBUTES;

59: l_mv VARCHAR2 (30);
60:
61: l_aggregation_level_flag VARCHAR2(10);
62:
63: l_custom_rec BIS_QUERY_ATTRIBUTES;
64:
65: BEGIN
66:
67: -- initialization block

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 487: l_custom_rec BIS_QUERY_ATTRIBUTES;

483: l_mv VARCHAR2 (30);
484:
485: l_aggregation_level_flag VARCHAR2(10);
486:
487: l_custom_rec BIS_QUERY_ATTRIBUTES;
488:
489: BEGIN
490:
491: -- initialization block

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 681: l_custom_rec BIS_QUERY_ATTRIBUTES;

677: l_mv VARCHAR2 (30);
678:
679: l_aggregation_level_flag VARCHAR2(10);
680:
681: l_custom_rec BIS_QUERY_ATTRIBUTES;
682: BEGIN
683:
684: -- initialization block
685: l_aggregation_level_flag := '0';

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 993: l_custom_rec BIS_QUERY_ATTRIBUTES;

989: l_mv VARCHAR2 (30);
990:
991: l_aggregation_level_flag VARCHAR2(10);
992:
993: l_custom_rec BIS_QUERY_ATTRIBUTES;
994:
995: BEGIN
996:
997: -- initialization block

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 1334: l_custom_rec BIS_QUERY_ATTRIBUTES;

1330: l_mv VARCHAR2 (30);
1331:
1332: l_aggregation_level_flag VARCHAR2(10);
1333:
1334: l_custom_rec BIS_QUERY_ATTRIBUTES;
1335:
1336: BEGIN
1337:
1338: -- initialization block

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);