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.POA_DBI_UTIL_PKG dependencies on BIS_PMV_PARAMETERS_PUB

Line 989: l_custom_rec := BIS_PMV_PARAMETERS_PUB.INITIALIZE_QUERY_TYPE;

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:
991: if p_xtd not like 'RL%' then
992: l_custom_rec.attribute_name := BIS_PMV_PARAMETERS_PUB.VIEW_BY_VALUE;
993: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.View_By_Type;

Line 992: l_custom_rec.attribute_name := BIS_PMV_PARAMETERS_PUB.VIEW_BY_VALUE;

988:
989: l_custom_rec := BIS_PMV_PARAMETERS_PUB.INITIALIZE_QUERY_TYPE;
990:
991: if p_xtd not like 'RL%' then
992: l_custom_rec.attribute_name := BIS_PMV_PARAMETERS_PUB.VIEW_BY_VALUE;
993: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.View_By_Type;
994:
995: if(p_xtd = 'YTD') then
996: l_custom_rec.attribute_value := 'TIME+FII_TIME_ENT_YEAR';

Line 993: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.View_By_Type;

989: l_custom_rec := BIS_PMV_PARAMETERS_PUB.INITIALIZE_QUERY_TYPE;
990:
991: if p_xtd not like 'RL%' then
992: l_custom_rec.attribute_name := BIS_PMV_PARAMETERS_PUB.VIEW_BY_VALUE;
993: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.View_By_Type;
994:
995: if(p_xtd = 'YTD') then
996: l_custom_rec.attribute_value := 'TIME+FII_TIME_ENT_YEAR';
997: elsif(p_xtd = 'QTD') then

Line 1025: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;

1021: else
1022: l_custom_rec.attribute_value := 7;
1023: end if;
1024:
1025: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
1026: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.INTEGER_BIND;
1027: x_custom_output.EXTEND;
1028: x_custom_output(x_custom_output.COUNT) := l_custom_rec;
1029: end if;

Line 1026: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.INTEGER_BIND;

1022: l_custom_rec.attribute_value := 7;
1023: end if;
1024:
1025: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
1026: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.INTEGER_BIND;
1027: x_custom_output.EXTEND;
1028: x_custom_output(x_custom_output.COUNT) := l_custom_rec;
1029: end if;
1030:

Line 1033: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;

1029: end if;
1030:
1031: l_custom_rec.attribute_name := '&LAG';
1032: l_custom_rec.attribute_value := get_trend_lag(p_xtd, p_comparison_type);
1033: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
1034: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.INTEGER_BIND;
1035: x_custom_output.EXTEND;
1036: x_custom_output(x_custom_output.COUNT) := l_custom_rec;
1037:

Line 1034: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.INTEGER_BIND;

1030:
1031: l_custom_rec.attribute_name := '&LAG';
1032: l_custom_rec.attribute_value := get_trend_lag(p_xtd, p_comparison_type);
1033: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
1034: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.INTEGER_BIND;
1035: x_custom_output.EXTEND;
1036: x_custom_output(x_custom_output.COUNT) := l_custom_rec;
1037:
1038: l_custom_rec.attribute_name := '&SEC_ID';

Line 1040: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;

1036: x_custom_output(x_custom_output.COUNT) := l_custom_rec;
1037:
1038: l_custom_rec.attribute_name := '&SEC_ID';
1039: l_custom_rec.attribute_value := poa_dbi_util_pkg.get_sec_profile;
1040: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
1041: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.INTEGER_BIND;
1042: x_custom_output.EXTEND;
1043: x_custom_output(x_custom_output.COUNT) := l_custom_rec;
1044:

Line 1041: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.INTEGER_BIND;

1037:
1038: l_custom_rec.attribute_name := '&SEC_ID';
1039: l_custom_rec.attribute_value := poa_dbi_util_pkg.get_sec_profile;
1040: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
1041: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.INTEGER_BIND;
1042: x_custom_output.EXTEND;
1043: x_custom_output(x_custom_output.COUNT) := l_custom_rec;
1044:
1045: l_custom_rec.attribute_name := '&FND_USER_ID';

Line 1047: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;

1043: x_custom_output(x_custom_output.COUNT) := l_custom_rec;
1044:
1045: l_custom_rec.attribute_name := '&FND_USER_ID';
1046: l_custom_rec.attribute_value := poa_dbi_util_pkg.get_fnd_user_profile;
1047: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
1048: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.INTEGER_BIND;
1049: x_custom_output.EXTEND;
1050: x_custom_output(x_custom_output.COUNT) := l_custom_rec;
1051:

Line 1048: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.INTEGER_BIND;

1044:
1045: l_custom_rec.attribute_name := '&FND_USER_ID';
1046: l_custom_rec.attribute_value := poa_dbi_util_pkg.get_fnd_user_profile;
1047: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
1048: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.INTEGER_BIND;
1049: x_custom_output.EXTEND;
1050: x_custom_output(x_custom_output.COUNT) := l_custom_rec;
1051:
1052: l_custom_rec.attribute_name := '&FND_EMPLOYEE_ID';

Line 1054: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;

1050: x_custom_output(x_custom_output.COUNT) := l_custom_rec;
1051:
1052: l_custom_rec.attribute_name := '&FND_EMPLOYEE_ID';
1053: l_custom_rec.attribute_value := poa_dbi_util_pkg.get_fnd_employee_profile;
1054: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
1055: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.INTEGER_BIND;
1056: x_custom_output.EXTEND;
1057: x_custom_output(x_custom_output.COUNT) := l_custom_rec;
1058:

Line 1055: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.INTEGER_BIND;

1051:
1052: l_custom_rec.attribute_name := '&FND_EMPLOYEE_ID';
1053: l_custom_rec.attribute_value := poa_dbi_util_pkg.get_fnd_employee_profile;
1054: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
1055: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.INTEGER_BIND;
1056: x_custom_output.EXTEND;
1057: x_custom_output(x_custom_output.COUNT) := l_custom_rec;
1058:
1059: ---Begin MOAC changes

Line 1062: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;

1058:
1059: ---Begin MOAC changes
1060: l_custom_rec.attribute_name := '&ORG_ID';
1061: l_custom_rec.attribute_value := poa_dbi_util_pkg.get_ou_org_id;
1062: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
1063: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.INTEGER_BIND;
1064: x_custom_output.EXTEND;
1065: x_custom_output(x_custom_output.COUNT) := l_custom_rec;
1066: ---End MOAC changes

Line 1063: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.INTEGER_BIND;

1059: ---Begin MOAC changes
1060: l_custom_rec.attribute_name := '&ORG_ID';
1061: l_custom_rec.attribute_value := poa_dbi_util_pkg.get_ou_org_id;
1062: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
1063: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.INTEGER_BIND;
1064: x_custom_output.EXTEND;
1065: x_custom_output(x_custom_output.COUNT) := l_custom_rec;
1066: ---End MOAC changes
1067:

Line 1084: l_custom_rec.attribute_type := bis_pmv_parameters_pub.bind_type;

1080: end
1081: when 'RLY' then (365*4)-1
1082: else 0
1083: end;
1084: l_custom_rec.attribute_type := bis_pmv_parameters_pub.bind_type;
1085: l_custom_rec.attribute_data_type := bis_pmv_parameters_pub.integer_bind;
1086: x_custom_output.extend;
1087: x_custom_output(x_custom_output.count) := l_custom_rec;
1088:

Line 1085: l_custom_rec.attribute_data_type := bis_pmv_parameters_pub.integer_bind;

1081: when 'RLY' then (365*4)-1
1082: else 0
1083: end;
1084: l_custom_rec.attribute_type := bis_pmv_parameters_pub.bind_type;
1085: l_custom_rec.attribute_data_type := bis_pmv_parameters_pub.integer_bind;
1086: x_custom_output.extend;
1087: x_custom_output(x_custom_output.count) := l_custom_rec;
1088:
1089: l_custom_rec.attribute_name := '&RLX_ROWS_OFFSET';

Line 1102: l_custom_rec.attribute_type := bis_pmv_parameters_pub.bind_type;

1098: else -4
1099: end
1100: when 'RLY' then -4
1101: end;
1102: l_custom_rec.attribute_type := bis_pmv_parameters_pub.bind_type;
1103: l_custom_rec.attribute_data_type := bis_pmv_parameters_pub.integer_bind;
1104: x_custom_output.extend;
1105: x_custom_output(x_custom_output.count) := l_custom_rec;
1106:

Line 1103: l_custom_rec.attribute_data_type := bis_pmv_parameters_pub.integer_bind;

1099: end
1100: when 'RLY' then -4
1101: end;
1102: l_custom_rec.attribute_type := bis_pmv_parameters_pub.bind_type;
1103: l_custom_rec.attribute_data_type := bis_pmv_parameters_pub.integer_bind;
1104: x_custom_output.extend;
1105: x_custom_output(x_custom_output.count) := l_custom_rec;
1106:
1107: l_custom_rec.attribute_name := '&RLX_DAYS';

Line 1115: l_custom_rec.attribute_type := bis_pmv_parameters_pub.bind_type;

1111: when 'RLM' then 30
1112: when 'RLQ' then 90
1113: when 'RLY' then 365
1114: end;
1115: l_custom_rec.attribute_type := bis_pmv_parameters_pub.bind_type;
1116: l_custom_rec.attribute_data_type := bis_pmv_parameters_pub.integer_bind;
1117: x_custom_output.extend;
1118: x_custom_output(x_custom_output.count) := l_custom_rec;
1119:

Line 1116: l_custom_rec.attribute_data_type := bis_pmv_parameters_pub.integer_bind;

1112: when 'RLQ' then 90
1113: when 'RLY' then 365
1114: end;
1115: l_custom_rec.attribute_type := bis_pmv_parameters_pub.bind_type;
1116: l_custom_rec.attribute_data_type := bis_pmv_parameters_pub.integer_bind;
1117: x_custom_output.extend;
1118: x_custom_output(x_custom_output.count) := l_custom_rec;
1119:
1120: l_custom_rec.attribute_name := '&RLX_DAYS_TO_START';

Line 1129: l_custom_rec.attribute_type := bis_pmv_parameters_pub.bind_type;

1125: when 'RLM' then 29
1126: when 'RLQ' then 89
1127: when 'RLY' then 364
1128: end;
1129: l_custom_rec.attribute_type := bis_pmv_parameters_pub.bind_type;
1130: l_custom_rec.attribute_data_type := bis_pmv_parameters_pub.integer_bind;
1131: x_custom_output.extend;
1132: x_custom_output(x_custom_output.count) := l_custom_rec;
1133:

Line 1130: l_custom_rec.attribute_data_type := bis_pmv_parameters_pub.integer_bind;

1126: when 'RLQ' then 89
1127: when 'RLY' then 364
1128: end;
1129: l_custom_rec.attribute_type := bis_pmv_parameters_pub.bind_type;
1130: l_custom_rec.attribute_data_type := bis_pmv_parameters_pub.integer_bind;
1131: x_custom_output.extend;
1132: x_custom_output(x_custom_output.count) := l_custom_rec;
1133:
1134: end if;

Line 1149: l_custom_rec := BIS_PMV_PARAMETERS_PUB.INITIALIZE_QUERY_TYPE;

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:
1151: l_custom_rec.attribute_name := '&SEC_ID';
1152: l_custom_rec.attribute_value := poa_dbi_util_pkg.get_sec_profile;
1153: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;

Line 1153: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;

1149: l_custom_rec := BIS_PMV_PARAMETERS_PUB.INITIALIZE_QUERY_TYPE;
1150:
1151: l_custom_rec.attribute_name := '&SEC_ID';
1152: l_custom_rec.attribute_value := poa_dbi_util_pkg.get_sec_profile;
1153: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
1154: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.INTEGER_BIND;
1155: x_custom_output.EXTEND;
1156: x_custom_output(x_custom_output.COUNT) := l_custom_rec;
1157:

Line 1154: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.INTEGER_BIND;

1150:
1151: l_custom_rec.attribute_name := '&SEC_ID';
1152: l_custom_rec.attribute_value := poa_dbi_util_pkg.get_sec_profile;
1153: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
1154: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.INTEGER_BIND;
1155: x_custom_output.EXTEND;
1156: x_custom_output(x_custom_output.COUNT) := l_custom_rec;
1157:
1158: l_custom_rec.attribute_name := '&FND_USER_ID';

Line 1160: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;

1156: x_custom_output(x_custom_output.COUNT) := l_custom_rec;
1157:
1158: l_custom_rec.attribute_name := '&FND_USER_ID';
1159: l_custom_rec.attribute_value := poa_dbi_util_pkg.get_fnd_user_profile;
1160: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
1161: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.INTEGER_BIND;
1162: x_custom_output.EXTEND;
1163: x_custom_output(x_custom_output.COUNT) := l_custom_rec;
1164:

Line 1161: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.INTEGER_BIND;

1157:
1158: l_custom_rec.attribute_name := '&FND_USER_ID';
1159: l_custom_rec.attribute_value := poa_dbi_util_pkg.get_fnd_user_profile;
1160: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
1161: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.INTEGER_BIND;
1162: x_custom_output.EXTEND;
1163: x_custom_output(x_custom_output.COUNT) := l_custom_rec;
1164:
1165: l_custom_rec.attribute_name := '&FND_EMPLOYEE_ID';

Line 1167: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;

1163: x_custom_output(x_custom_output.COUNT) := l_custom_rec;
1164:
1165: l_custom_rec.attribute_name := '&FND_EMPLOYEE_ID';
1166: l_custom_rec.attribute_value := poa_dbi_util_pkg.get_fnd_employee_profile;
1167: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
1168: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.INTEGER_BIND;
1169: x_custom_output.EXTEND;
1170: x_custom_output(x_custom_output.COUNT) := l_custom_rec;
1171:

Line 1168: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.INTEGER_BIND;

1164:
1165: l_custom_rec.attribute_name := '&FND_EMPLOYEE_ID';
1166: l_custom_rec.attribute_value := poa_dbi_util_pkg.get_fnd_employee_profile;
1167: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
1168: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.INTEGER_BIND;
1169: x_custom_output.EXTEND;
1170: x_custom_output(x_custom_output.COUNT) := l_custom_rec;
1171:
1172: ---Begin MOAC changes

Line 1175: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;

1171:
1172: ---Begin MOAC changes
1173: l_custom_rec.attribute_name := '&ORG_ID';
1174: l_custom_rec.attribute_value := poa_dbi_util_pkg.get_ou_org_id;
1175: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
1176: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.INTEGER_BIND;
1177: x_custom_output.EXTEND;
1178: x_custom_output(x_custom_output.COUNT) := l_custom_rec;
1179: ---End MOAC changes

Line 1176: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.INTEGER_BIND;

1172: ---Begin MOAC changes
1173: l_custom_rec.attribute_name := '&ORG_ID';
1174: l_custom_rec.attribute_value := poa_dbi_util_pkg.get_ou_org_id;
1175: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
1176: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.INTEGER_BIND;
1177: x_custom_output.EXTEND;
1178: x_custom_output(x_custom_output.COUNT) := l_custom_rec;
1179: ---End MOAC changes
1180:

Line 1241: l_custom_rec := bis_pmv_parameters_pub.initialize_query_type;

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';
1244: l_custom_rec.attribute_value := to_char(fnd_date.displayDT_to_date(bis_collection_utilities.get_last_refresh_period(upper(p_balance_fact))),'dd/mm/yyyy');
1245: l_custom_rec.attribute_type := bis_pmv_parameters_pub.bind_type;

Line 1245: l_custom_rec.attribute_type := bis_pmv_parameters_pub.bind_type;

1241: l_custom_rec := bis_pmv_parameters_pub.initialize_query_type;
1242:
1243: l_custom_rec.attribute_name := '&LAST_COLLECTION';
1244: l_custom_rec.attribute_value := to_char(fnd_date.displayDT_to_date(bis_collection_utilities.get_last_refresh_period(upper(p_balance_fact))),'dd/mm/yyyy');
1245: l_custom_rec.attribute_type := bis_pmv_parameters_pub.bind_type;
1246: l_custom_rec.attribute_data_type := bis_pmv_parameters_pub.date_bind;
1247: p_custom_output.extend;
1248: p_custom_output(p_custom_output.count) := l_custom_rec;
1249:

Line 1246: l_custom_rec.attribute_data_type := bis_pmv_parameters_pub.date_bind;

1242:
1243: l_custom_rec.attribute_name := '&LAST_COLLECTION';
1244: l_custom_rec.attribute_value := to_char(fnd_date.displayDT_to_date(bis_collection_utilities.get_last_refresh_period(upper(p_balance_fact))),'dd/mm/yyyy');
1245: l_custom_rec.attribute_type := bis_pmv_parameters_pub.bind_type;
1246: l_custom_rec.attribute_data_type := bis_pmv_parameters_pub.date_bind;
1247: p_custom_output.extend;
1248: p_custom_output(p_custom_output.count) := l_custom_rec;
1249:
1250: -- Balance report in XTD Model

Line 1255: l_custom_rec.attribute_type := bis_pmv_parameters_pub.bind_type;

1251: IF(p_xtd IN ('DAY','WTD','MTD','QTD','YTD') )
1252: THEN
1253: l_custom_rec.attribute_name := '&YTD_NESTED_PATTERN';
1254: l_custom_rec.attribute_value := 1143;
1255: l_custom_rec.attribute_type := bis_pmv_parameters_pub.bind_type;
1256: l_custom_rec.attribute_data_type := bis_pmv_parameters_pub.integer_bind;
1257: p_custom_output.extend;
1258: p_custom_output(p_custom_output.count) := l_custom_rec;
1259: END IF;

Line 1256: l_custom_rec.attribute_data_type := bis_pmv_parameters_pub.integer_bind;

1252: THEN
1253: l_custom_rec.attribute_name := '&YTD_NESTED_PATTERN';
1254: l_custom_rec.attribute_value := 1143;
1255: l_custom_rec.attribute_type := bis_pmv_parameters_pub.bind_type;
1256: l_custom_rec.attribute_data_type := bis_pmv_parameters_pub.integer_bind;
1257: p_custom_output.extend;
1258: p_custom_output(p_custom_output.count) := l_custom_rec;
1259: END IF;
1260:

Line 1278: l_custom_rec := bis_pmv_parameters_pub.initialize_query_type;

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:
1280: l_custom_rec.attribute_name := '&RLX_NESTED_PATTERN';
1281: l_custom_rec.attribute_value := case p_xtd
1282: when 'RLW' then 1024

Line 1287: l_custom_rec.attribute_type := bis_pmv_parameters_pub.bind_type;

1283: when 'RLM' then 2048
1284: when 'RLQ' then 4096
1285: when 'RLY' then 8192
1286: end;
1287: l_custom_rec.attribute_type := bis_pmv_parameters_pub.bind_type;
1288: l_custom_rec.attribute_data_type := bis_pmv_parameters_pub.integer_bind;
1289: p_custom_output.extend;
1290: p_custom_output(p_custom_output.count) := l_custom_rec;
1291:

Line 1288: l_custom_rec.attribute_data_type := bis_pmv_parameters_pub.integer_bind;

1284: when 'RLQ' then 4096
1285: when 'RLY' then 8192
1286: end;
1287: l_custom_rec.attribute_type := bis_pmv_parameters_pub.bind_type;
1288: l_custom_rec.attribute_data_type := bis_pmv_parameters_pub.integer_bind;
1289: p_custom_output.extend;
1290: p_custom_output(p_custom_output.count) := l_custom_rec;
1291:
1292: END get_custom_rolling_binds;

Line 1372: l_custom_rec := BIS_PMV_PARAMETERS_PUB.INITIALIZE_QUERY_TYPE;

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:
1374: l_custom_rec.attribute_name := p_low;
1375: l_custom_rec.attribute_value := l_range_low;
1376: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;

Line 1376: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;

1372: l_custom_rec := BIS_PMV_PARAMETERS_PUB.INITIALIZE_QUERY_TYPE;
1373:
1374: l_custom_rec.attribute_name := p_low;
1375: l_custom_rec.attribute_value := l_range_low;
1376: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
1377: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.INTEGER_BIND;
1378: p_custom_output.extend;
1379: p_custom_output(p_custom_output.count) := l_custom_rec;
1380:

Line 1377: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.INTEGER_BIND;

1373:
1374: l_custom_rec.attribute_name := p_low;
1375: l_custom_rec.attribute_value := l_range_low;
1376: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
1377: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.INTEGER_BIND;
1378: p_custom_output.extend;
1379: p_custom_output(p_custom_output.count) := l_custom_rec;
1380:
1381: l_custom_rec.attribute_name := p_high;

Line 1383: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;

1379: p_custom_output(p_custom_output.count) := l_custom_rec;
1380:
1381: l_custom_rec.attribute_name := p_high;
1382: l_custom_rec.attribute_value := l_range_high;
1383: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
1384: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.INTEGER_BIND;
1385: p_custom_output.extend;
1386: p_custom_output(p_custom_output.count) := l_custom_rec;
1387:

Line 1384: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.INTEGER_BIND;

1380:
1381: l_custom_rec.attribute_name := p_high;
1382: l_custom_rec.attribute_value := l_range_high;
1383: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
1384: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.INTEGER_BIND;
1385: p_custom_output.extend;
1386: p_custom_output(p_custom_output.count) := l_custom_rec;
1387:
1388: end bind_low_high;

Line 1413: l_custom_rec := BIS_PMV_PARAMETERS_PUB.INITIALIZE_QUERY_TYPE;

1409: ELSIF (p_comparison_type = 'W') THEN
1410: l_prev_as_of_date := p_as_of_date-7;
1411: END IF;
1412:
1413: l_custom_rec := BIS_PMV_PARAMETERS_PUB.INITIALIZE_QUERY_TYPE;
1414:
1415: l_custom_rec.attribute_name := '&BIS_CURRENT_REPORT_START_DATE';
1416: l_custom_rec.attribute_value := to_char(p_as_of_date-6,'dd/mm/yyyy');
1417: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;

Line 1417: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;

1413: l_custom_rec := BIS_PMV_PARAMETERS_PUB.INITIALIZE_QUERY_TYPE;
1414:
1415: l_custom_rec.attribute_name := '&BIS_CURRENT_REPORT_START_DATE';
1416: l_custom_rec.attribute_value := to_char(p_as_of_date-6,'dd/mm/yyyy');
1417: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
1418: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.DATE_BIND;
1419: p_custom_output.EXTEND;
1420: p_custom_output(p_custom_output.COUNT) := l_custom_rec;
1421:

Line 1418: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.DATE_BIND;

1414:
1415: l_custom_rec.attribute_name := '&BIS_CURRENT_REPORT_START_DATE';
1416: l_custom_rec.attribute_value := to_char(p_as_of_date-6,'dd/mm/yyyy');
1417: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
1418: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.DATE_BIND;
1419: p_custom_output.EXTEND;
1420: p_custom_output(p_custom_output.COUNT) := l_custom_rec;
1421:
1422: l_custom_rec.attribute_name := '&BIS_PREVIOUS_REPORT_START_DATE';

Line 1424: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;

1420: p_custom_output(p_custom_output.COUNT) := l_custom_rec;
1421:
1422: l_custom_rec.attribute_name := '&BIS_PREVIOUS_REPORT_START_DATE';
1423: l_custom_rec.attribute_value := to_char(l_prev_as_of_date-6,'dd/mm/yyyy');
1424: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
1425: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.DATE_BIND;
1426: p_custom_output.EXTEND;
1427: p_custom_output(p_custom_output.COUNT) := l_custom_rec;
1428:

Line 1425: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.DATE_BIND;

1421:
1422: l_custom_rec.attribute_name := '&BIS_PREVIOUS_REPORT_START_DATE';
1423: l_custom_rec.attribute_value := to_char(l_prev_as_of_date-6,'dd/mm/yyyy');
1424: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
1425: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.DATE_BIND;
1426: p_custom_output.EXTEND;
1427: p_custom_output(p_custom_output.COUNT) := l_custom_rec;
1428:
1429: l_custom_rec.attribute_name := '&BIS_CURRENT_EFFECTIVE_END_DATE';

Line 1431: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;

1427: p_custom_output(p_custom_output.COUNT) := l_custom_rec;
1428:
1429: l_custom_rec.attribute_name := '&BIS_CURRENT_EFFECTIVE_END_DATE';
1430: l_custom_rec.attribute_value := to_char(p_as_of_date,'dd/mm/yyyy');
1431: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
1432: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.DATE_BIND;
1433: p_custom_output.EXTEND;
1434: p_custom_output(p_custom_output.COUNT) := l_custom_rec;
1435:

Line 1432: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.DATE_BIND;

1428:
1429: l_custom_rec.attribute_name := '&BIS_CURRENT_EFFECTIVE_END_DATE';
1430: l_custom_rec.attribute_value := to_char(p_as_of_date,'dd/mm/yyyy');
1431: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
1432: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.DATE_BIND;
1433: p_custom_output.EXTEND;
1434: p_custom_output(p_custom_output.COUNT) := l_custom_rec;
1435:
1436: l_custom_rec.attribute_name := '&BIS_PREVIOUS_EFFECTIVE_END_DATE';

Line 1438: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;

1434: p_custom_output(p_custom_output.COUNT) := l_custom_rec;
1435:
1436: l_custom_rec.attribute_name := '&BIS_PREVIOUS_EFFECTIVE_END_DATE';
1437: l_custom_rec.attribute_value := to_char(l_prev_as_of_date,'dd/mm/yyyy');
1438: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
1439: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.DATE_BIND;
1440: p_custom_output.EXTEND;
1441: p_custom_output(p_custom_output.COUNT) := l_custom_rec;
1442:

Line 1439: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.DATE_BIND;

1435:
1436: l_custom_rec.attribute_name := '&BIS_PREVIOUS_EFFECTIVE_END_DATE';
1437: l_custom_rec.attribute_value := to_char(l_prev_as_of_date,'dd/mm/yyyy');
1438: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
1439: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.DATE_BIND;
1440: p_custom_output.EXTEND;
1441: p_custom_output(p_custom_output.COUNT) := l_custom_rec;
1442:
1443: END get_custom_day_binds;