DBA Data[Home] [Help]

APPS.POA_DBI_NEG_PKG dependencies on BIS_QUERY_ATTRIBUTES_TBL

Line 29: ,x_custom_output OUT NOCOPY BIS_QUERY_ATTRIBUTES_TBL)

25: */
26:
27: PROCEDURE status_sql(p_param in BIS_PMV_PAGE_PARAMETER_TBL
28: ,x_custom_sql OUT NOCOPY VARCHAR2
29: ,x_custom_output OUT NOCOPY BIS_QUERY_ATTRIBUTES_TBL)
30: IS
31: l_query varchar2(32000);
32: l_view_by varchar2(120);
33: l_view_by_col varchar2(120);

Line 321: ,x_custom_output OUT NOCOPY BIS_QUERY_ATTRIBUTES_TBL)

317: */
318:
319: PROCEDURE awd_status_sql(p_param in BIS_PMV_PAGE_PARAMETER_TBL
320: ,x_custom_sql OUT NOCOPY VARCHAR2
321: ,x_custom_output OUT NOCOPY BIS_QUERY_ATTRIBUTES_TBL)
322: IS
323: l_query varchar2(32000);
324: l_view_by varchar2(120);
325: l_view_by_col varchar2(120);

Line 546: ,x_custom_output OUT NOCOPY BIS_QUERY_ATTRIBUTES_TBL)

542: */
543:
544: PROCEDURE avg_cycle_time_sql(p_param in BIS_PMV_PAGE_PARAMETER_TBL
545: ,x_custom_sql OUT NOCOPY VARCHAR2
546: ,x_custom_output OUT NOCOPY BIS_QUERY_ATTRIBUTES_TBL)
547: IS
548: l_query varchar2(32000);
549: l_view_by varchar2(120);
550: l_view_by_col varchar2(120);

Line 776: ,x_custom_output OUT NOCOPY BIS_QUERY_ATTRIBUTES_TBL)

772: */
773:
774: PROCEDURE realized_status_sql(p_param in BIS_PMV_PAGE_PARAMETER_TBL
775: ,x_custom_sql OUT NOCOPY VARCHAR2
776: ,x_custom_output OUT NOCOPY BIS_QUERY_ATTRIBUTES_TBL)
777: IS
778: l_query varchar2(32000);
779: l_view_by varchar2(120);
780: l_view_by_col varchar2(120);

Line 1039: x_custom_output OUT NOCOPY BIS_QUERY_ATTRIBUTES_TBL)

1035: */
1036:
1037: PROCEDURE awd_trend_sql(p_param in BIS_PMV_PAGE_PARAMETER_TBL,
1038: x_custom_sql OUT NOCOPY VARCHAR2,
1039: x_custom_output OUT NOCOPY BIS_QUERY_ATTRIBUTES_TBL)
1040: IS
1041: l_query varchar2(32000);
1042: l_view_by varchar2(120);
1043: l_view_by_col varchar2(120);

Line 1130: x_custom_output OUT NOCOPY BIS_QUERY_ATTRIBUTES_TBL)

1126: */
1127:
1128: PROCEDURE avg_cycle_trend_sql(p_param in BIS_PMV_PAGE_PARAMETER_TBL,
1129: x_custom_sql OUT NOCOPY VARCHAR2,
1130: x_custom_output OUT NOCOPY BIS_QUERY_ATTRIBUTES_TBL)
1131: IS
1132: l_query varchar2(32000);
1133: l_view_by varchar2(120);
1134: l_view_by_col varchar2(120);

Line 1226: x_custom_output OUT NOCOPY BIS_QUERY_ATTRIBUTES_TBL)

1222: */
1223:
1224: PROCEDURE prj_svng_trend_sql(p_param in BIS_PMV_PAGE_PARAMETER_TBL,
1225: x_custom_sql OUT NOCOPY VARCHAR2,
1226: x_custom_output OUT NOCOPY BIS_QUERY_ATTRIBUTES_TBL)
1227: IS
1228: l_query varchar2(32000);
1229: l_view_by varchar2(120);
1230: l_view_by_col varchar2(120);

Line 1318: x_custom_output OUT NOCOPY BIS_QUERY_ATTRIBUTES_TBL)

1314: */
1315:
1316: PROCEDURE prj_svng_ln_trend_sql(p_param in BIS_PMV_PAGE_PARAMETER_TBL,
1317: x_custom_sql OUT NOCOPY VARCHAR2,
1318: x_custom_output OUT NOCOPY BIS_QUERY_ATTRIBUTES_TBL)
1319: IS
1320: l_query varchar2(32000);
1321: l_view_by varchar2(120);
1322: l_view_by_col varchar2(120);

Line 1414: x_custom_output OUT NOCOPY BIS_QUERY_ATTRIBUTES_TBL)

1410: */
1411:
1412: PROCEDURE real_svng_trend_sql(p_param in BIS_PMV_PAGE_PARAMETER_TBL,
1413: x_custom_sql OUT NOCOPY VARCHAR2,
1414: x_custom_output OUT NOCOPY BIS_QUERY_ATTRIBUTES_TBL)
1415: IS
1416: l_query varchar2(32000);
1417: l_view_by varchar2(120);
1418: l_view_by_col varchar2(120);

Line 1505: x_custom_output OUT NOCOPY BIS_QUERY_ATTRIBUTES_TBL)

1501: */
1502:
1503: PROCEDURE neg_po_trend_sql(p_param in BIS_PMV_PAGE_PARAMETER_TBL,
1504: x_custom_sql OUT NOCOPY VARCHAR2,
1505: x_custom_output OUT NOCOPY BIS_QUERY_ATTRIBUTES_TBL)
1506: IS
1507: l_query varchar2(32000);
1508: l_view_by varchar2(120);
1509: l_view_by_col varchar2(120);

Line 1606: x_custom_output OUT NOCOPY BIS_QUERY_ATTRIBUTES_TBL)

1602: */
1603:
1604: PROCEDURE dtl_sql(p_param in BIS_PMV_PAGE_PARAMETER_TBL,
1605: x_custom_sql OUT NOCOPY VARCHAR2,
1606: x_custom_output OUT NOCOPY BIS_QUERY_ATTRIBUTES_TBL)
1607: IS
1608: l_query varchar2(32000);
1609: l_cur_suffix varchar2(2);
1610: l_join_tbl poa_dbi_util_pkg.POA_DBI_JOIN_TBL;