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

Line 1122: l_bind_rec := BIS_PMV_PARAMETERS_PUB.INITIALIZE_QUERY_TYPE;

1118: l_bind_rec BIS_QUERY_ATTRIBUTES;
1119:
1120: BEGIN
1121: p_bind_output_table := BIS_QUERY_ATTRIBUTES_TBL();
1122: l_bind_rec := BIS_PMV_PARAMETERS_PUB.INITIALIZE_QUERY_TYPE;
1123: p_sql_output := p_sqlstmt;
1124: p_bind_output_table.EXTEND;
1125: l_bind_rec.attribute_name := ':VIEW_BY';
1126: l_bind_rec.attribute_value := to_char(p_view_by);

Line 1127: l_bind_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;

1123: p_sql_output := p_sqlstmt;
1124: p_bind_output_table.EXTEND;
1125: l_bind_rec.attribute_name := ':VIEW_BY';
1126: l_bind_rec.attribute_value := to_char(p_view_by);
1127: l_bind_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
1128: l_bind_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.VARCHAR2_BIND;
1129: p_bind_output_table(p_bind_output_table.COUNT) := l_bind_rec;
1130: p_bind_output_table.EXTEND;
1131: l_bind_rec.attribute_name := ':RECORD_TYPE_ID';

Line 1128: l_bind_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.VARCHAR2_BIND;

1124: p_bind_output_table.EXTEND;
1125: l_bind_rec.attribute_name := ':VIEW_BY';
1126: l_bind_rec.attribute_value := to_char(p_view_by);
1127: l_bind_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
1128: l_bind_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.VARCHAR2_BIND;
1129: p_bind_output_table(p_bind_output_table.COUNT) := l_bind_rec;
1130: p_bind_output_table.EXTEND;
1131: l_bind_rec.attribute_name := ':RECORD_TYPE_ID';
1132: l_bind_rec.attribute_value := to_char(p_record_type_id);

Line 1133: l_bind_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;

1129: p_bind_output_table(p_bind_output_table.COUNT) := l_bind_rec;
1130: p_bind_output_table.EXTEND;
1131: l_bind_rec.attribute_name := ':RECORD_TYPE_ID';
1132: l_bind_rec.attribute_value := to_char(p_record_type_id);
1133: l_bind_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
1134: l_bind_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.NUMERIC_BIND;
1135: p_bind_output_table(p_bind_output_table.COUNT) := l_bind_rec;
1136: p_bind_output_table.EXTEND;
1137: l_bind_rec.attribute_name := ':GID';

Line 1134: l_bind_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.NUMERIC_BIND;

1130: p_bind_output_table.EXTEND;
1131: l_bind_rec.attribute_name := ':RECORD_TYPE_ID';
1132: l_bind_rec.attribute_value := to_char(p_record_type_id);
1133: l_bind_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
1134: l_bind_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.NUMERIC_BIND;
1135: p_bind_output_table(p_bind_output_table.COUNT) := l_bind_rec;
1136: p_bind_output_table.EXTEND;
1137: l_bind_rec.attribute_name := ':GID';
1138: l_bind_rec.attribute_value := to_char(p_gid);

Line 1139: l_bind_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;

1135: p_bind_output_table(p_bind_output_table.COUNT) := l_bind_rec;
1136: p_bind_output_table.EXTEND;
1137: l_bind_rec.attribute_name := ':GID';
1138: l_bind_rec.attribute_value := to_char(p_gid);
1139: l_bind_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
1140: l_bind_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.NUMERIC_BIND;
1141: p_bind_output_table(p_bind_output_table.COUNT) := l_bind_rec;
1142: p_bind_output_table.EXTEND;
1143: l_bind_rec.attribute_name := ':SEC_ID';

Line 1140: l_bind_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.NUMERIC_BIND;

1136: p_bind_output_table.EXTEND;
1137: l_bind_rec.attribute_name := ':GID';
1138: l_bind_rec.attribute_value := to_char(p_gid);
1139: l_bind_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
1140: l_bind_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.NUMERIC_BIND;
1141: p_bind_output_table(p_bind_output_table.COUNT) := l_bind_rec;
1142: p_bind_output_table.EXTEND;
1143: l_bind_rec.attribute_name := ':SEC_ID';
1144: l_bind_rec.attribute_value := fii_pmv_util.get_sec_profile;

Line 1145: l_bind_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;

1141: p_bind_output_table(p_bind_output_table.COUNT) := l_bind_rec;
1142: p_bind_output_table.EXTEND;
1143: l_bind_rec.attribute_name := ':SEC_ID';
1144: l_bind_rec.attribute_value := fii_pmv_util.get_sec_profile;
1145: l_bind_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
1146: l_bind_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.INTEGER_BIND;
1147: p_bind_output_table(p_bind_output_table.COUNT) := l_bind_rec;
1148: p_bind_output_table.EXTEND;
1149: l_bind_rec.attribute_name := ':PERIOD_START';

Line 1146: l_bind_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.INTEGER_BIND;

1142: p_bind_output_table.EXTEND;
1143: l_bind_rec.attribute_name := ':SEC_ID';
1144: l_bind_rec.attribute_value := fii_pmv_util.get_sec_profile;
1145: l_bind_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
1146: l_bind_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.INTEGER_BIND;
1147: p_bind_output_table(p_bind_output_table.COUNT) := l_bind_rec;
1148: p_bind_output_table.EXTEND;
1149: l_bind_rec.attribute_name := ':PERIOD_START';
1150: l_bind_rec.attribute_value := to_char(p_period_start, 'DD-MM-YYYY');

Line 1151: l_bind_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;

1147: p_bind_output_table(p_bind_output_table.COUNT) := l_bind_rec;
1148: p_bind_output_table.EXTEND;
1149: l_bind_rec.attribute_name := ':PERIOD_START';
1150: l_bind_rec.attribute_value := to_char(p_period_start, 'DD-MM-YYYY');
1151: l_bind_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
1152: l_bind_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.VARCHAR2_BIND;
1153: p_bind_output_table(p_bind_output_table.COUNT) := l_bind_rec;
1154: p_bind_output_table.EXTEND;
1155: l_bind_rec.attribute_name := ':P_REPORT_START';

Line 1152: l_bind_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.VARCHAR2_BIND;

1148: p_bind_output_table.EXTEND;
1149: l_bind_rec.attribute_name := ':PERIOD_START';
1150: l_bind_rec.attribute_value := to_char(p_period_start, 'DD-MM-YYYY');
1151: l_bind_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
1152: l_bind_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.VARCHAR2_BIND;
1153: p_bind_output_table(p_bind_output_table.COUNT) := l_bind_rec;
1154: p_bind_output_table.EXTEND;
1155: l_bind_rec.attribute_name := ':P_REPORT_START';
1156: l_bind_rec.attribute_value := to_char(p_report_start, 'DD-MM-YYYY');

Line 1157: l_bind_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;

1153: p_bind_output_table(p_bind_output_table.COUNT) := l_bind_rec;
1154: p_bind_output_table.EXTEND;
1155: l_bind_rec.attribute_name := ':P_REPORT_START';
1156: l_bind_rec.attribute_value := to_char(p_report_start, 'DD-MM-YYYY');
1157: l_bind_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
1158: l_bind_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.VARCHAR2_BIND;
1159: p_bind_output_table(p_bind_output_table.COUNT) := l_bind_rec;
1160: p_bind_output_table.EXTEND;
1161: l_bind_rec.attribute_name := ':P_CUR_EFFECTIVE_NUM';

Line 1158: l_bind_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.VARCHAR2_BIND;

1154: p_bind_output_table.EXTEND;
1155: l_bind_rec.attribute_name := ':P_REPORT_START';
1156: l_bind_rec.attribute_value := to_char(p_report_start, 'DD-MM-YYYY');
1157: l_bind_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
1158: l_bind_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.VARCHAR2_BIND;
1159: p_bind_output_table(p_bind_output_table.COUNT) := l_bind_rec;
1160: p_bind_output_table.EXTEND;
1161: l_bind_rec.attribute_name := ':P_CUR_EFFECTIVE_NUM';
1162: l_bind_rec.attribute_value := TO_CHAR(p_cur_effective_num);

Line 1163: l_bind_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;

1159: p_bind_output_table(p_bind_output_table.COUNT) := l_bind_rec;
1160: p_bind_output_table.EXTEND;
1161: l_bind_rec.attribute_name := ':P_CUR_EFFECTIVE_NUM';
1162: l_bind_rec.attribute_value := TO_CHAR(p_cur_effective_num);
1163: l_bind_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
1164: l_bind_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.NUMERIC_BIND;
1165: p_bind_output_table(p_bind_output_table.COUNT) := l_bind_rec;
1166: p_bind_output_table.EXTEND;
1167: l_bind_rec.attribute_name := ':P_PERIOD_ID';

Line 1164: l_bind_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.NUMERIC_BIND;

1160: p_bind_output_table.EXTEND;
1161: l_bind_rec.attribute_name := ':P_CUR_EFFECTIVE_NUM';
1162: l_bind_rec.attribute_value := TO_CHAR(p_cur_effective_num);
1163: l_bind_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
1164: l_bind_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.NUMERIC_BIND;
1165: p_bind_output_table(p_bind_output_table.COUNT) := l_bind_rec;
1166: p_bind_output_table.EXTEND;
1167: l_bind_rec.attribute_name := ':P_PERIOD_ID';
1168: l_bind_rec.attribute_value := to_char(p_period_id);

Line 1169: l_bind_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;

1165: p_bind_output_table(p_bind_output_table.COUNT) := l_bind_rec;
1166: p_bind_output_table.EXTEND;
1167: l_bind_rec.attribute_name := ':P_PERIOD_ID';
1168: l_bind_rec.attribute_value := to_char(p_period_id);
1169: l_bind_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
1170: l_bind_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.NUMERIC_BIND;
1171: p_bind_output_table(p_bind_output_table.COUNT) := l_bind_rec;
1172: p_bind_output_table.EXTEND;
1173: --vkazhipu added for performance

Line 1170: l_bind_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.NUMERIC_BIND;

1166: p_bind_output_table.EXTEND;
1167: l_bind_rec.attribute_name := ':P_PERIOD_ID';
1168: l_bind_rec.attribute_value := to_char(p_period_id);
1169: l_bind_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
1170: l_bind_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.NUMERIC_BIND;
1171: p_bind_output_table(p_bind_output_table.COUNT) := l_bind_rec;
1172: p_bind_output_table.EXTEND;
1173: --vkazhipu added for performance
1174: --bug 4997442

Line 1177: l_bind_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;

1173: --vkazhipu added for performance
1174: --bug 4997442
1175: l_bind_rec.attribute_name := ':P_DATE_STRING';
1176: l_bind_rec.attribute_value := to_char(g_date_string,'DD-MM-YYYY');
1177: l_bind_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
1178: l_bind_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.DATE_BIND;
1179: p_bind_output_table(p_bind_output_table.COUNT) := l_bind_rec;
1180: p_bind_output_table.EXTEND;
1181:

Line 1178: l_bind_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.DATE_BIND;

1174: --bug 4997442
1175: l_bind_rec.attribute_name := ':P_DATE_STRING';
1176: l_bind_rec.attribute_value := to_char(g_date_string,'DD-MM-YYYY');
1177: l_bind_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
1178: l_bind_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.DATE_BIND;
1179: p_bind_output_table(p_bind_output_table.COUNT) := l_bind_rec;
1180: p_bind_output_table.EXTEND;
1181:
1182: END Local_Bind_Variable;