APPS.POA_DBI_UTIL_PKG dependencies on BIS_QUERY_ATTRIBUTES_TBL

Line 977: , x_custom_output out nocopy bis_query_attributes_tbl

973:
974: PROCEDURE get_custom_trend_binds
975: ( p_xtd in varchar2
976: , p_comparison_type in varchar2
977: , x_custom_output out nocopy bis_query_attributes_tbl
978: , p_opening_balance in varchar2 := 'N'
979: )
980: IS
981:

Line 986: x_custom_output := bis_query_attributes_tbl();

982: l_custom_rec BIS_QUERY_ATTRIBUTES;
983:
984: BEGIN
985: if x_custom_output is null then
986: x_custom_output := bis_query_attributes_tbl();
987: end if;
988:
989: l_custom_rec := BIS_PMV_PARAMETERS_PUB.INITIALIZE_QUERY_TYPE;
990:

Line 1138: PROCEDURE get_custom_status_binds(x_custom_output IN OUT NOCOPY BIS_QUERY_ATTRIBUTES_TBL)

1134: end if;
1135:
1136: END get_custom_trend_binds;
1137:
1138: PROCEDURE get_custom_status_binds(x_custom_output IN OUT NOCOPY BIS_QUERY_ATTRIBUTES_TBL)
1139: IS
1140:
1141: l_custom_rec BIS_QUERY_ATTRIBUTES;
1142:

Line 1146: x_custom_output := bis_query_attributes_tbl();

1142:
1143: BEGIN
1144:
1145: if x_custom_output is null then
1146: x_custom_output := bis_query_attributes_tbl();
1147: end if;
1148:
1149: l_custom_rec := BIS_PMV_PARAMETERS_PUB.INITIALIZE_QUERY_TYPE;
1150:

Line 1228: ( p_custom_output in out nocopy bis_query_attributes_tbl

1224:
1225: END get_report_start_date;
1226:
1227: PROCEDURE get_custom_balance_binds
1228: ( p_custom_output in out nocopy bis_query_attributes_tbl
1229: , p_balance_fact in varchar2
1230: , p_xtd in varchar2 := null
1231: )
1232: IS

Line 1239: p_custom_output := bis_query_attributes_tbl();

1235:
1236: BEGIN
1237:
1238: if p_custom_output is null then
1239: p_custom_output := bis_query_attributes_tbl();
1240: end if;
1241: l_custom_rec := bis_pmv_parameters_pub.initialize_query_type;
1242:
1243: l_custom_rec.attribute_name := '&LAST_COLLECTION';

Line 1265: ( p_custom_output in out nocopy bis_query_attributes_tbl

1261:
1262: END get_custom_balance_binds;
1263:
1264: PROCEDURE get_custom_rolling_binds
1265: ( p_custom_output in out nocopy bis_query_attributes_tbl
1266: , p_xtd in varchar2
1267: )
1268: IS
1269:

Line 1275: p_custom_output := bis_query_attributes_tbl();

1271:
1272: BEGIN
1273:
1274: if p_custom_output is null then
1275: p_custom_output := bis_query_attributes_tbl();
1276: end if;
1277:
1278: l_custom_rec := bis_pmv_parameters_pub.initialize_query_type;
1279:

Line 1300: , p_custom_output in out nocopy bis_query_attributes_tbl

1296: , p_short_name in varchar2
1297: , p_dim_level in varchar2
1298: , p_low in varchar2
1299: , p_high in varchar2
1300: , p_custom_output in out nocopy bis_query_attributes_tbl
1301: )
1302: is
1303:
1304: l_range_low number;

Line 1369: p_custom_output := bis_query_attributes_tbl();

1365: end if;
1366: end if;
1367:
1368: if p_custom_output is null then
1369: p_custom_output := bis_query_attributes_tbl();
1370: end if;
1371:
1372: l_custom_rec := BIS_PMV_PARAMETERS_PUB.INITIALIZE_QUERY_TYPE;
1373:

Line 1390: PROCEDURE get_custom_day_binds(p_custom_output IN OUT NOCOPY BIS_QUERY_ATTRIBUTES_TBL,

1386: p_custom_output(p_custom_output.count) := l_custom_rec;
1387:
1388: end bind_low_high;
1389:
1390: PROCEDURE get_custom_day_binds(p_custom_output IN OUT NOCOPY BIS_QUERY_ATTRIBUTES_TBL,
1391: p_as_of_date IN DATE,
1392: p_comparison_type IN VARCHAR2)
1393: IS
1394: l_custom_rec BIS_QUERY_ATTRIBUTES;

Line 1402: p_custom_output := bis_query_attributes_tbl();

1398:
1399: RETURN ;
1400:
1401: if p_custom_output is null then
1402: p_custom_output := bis_query_attributes_tbl();
1403: end if;
1404:
1405: IF(p_comparison_type = 'S') THEN
1406: l_prev_as_of_date := p_as_of_date - 1;