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_PAID_INV_DETAIL dependencies on FII_PMV_UTIL

Line 38: FII_PMV_Util.Get_Parameters(

34: stmt8 VARCHAR2(240);
35:
36: l_date_mask VARCHAR2(240);
37: BEGIN
38: FII_PMV_Util.Get_Parameters(
39: p_page_parameter_tbl,
40: l_as_of_date,
41: l_operating_unit,
42: l_supplier,

Line 55: FII_PMV_Util.get_check_id(p_page_parameter_tbl, l_check_id);

51: l_org_where,
52: l_supplier_where
53: );
54:
55: FII_PMV_Util.get_check_id(p_page_parameter_tbl, l_check_id);
56:
57: /**************Description of Measures, Attributes returned to PMV *****
58: FII_MEASURE1 - Action,
59: FII_MEASURE2 - Date,

Line 75: FII_PMV_Util.get_format_mask(l_date_mask);

71: stmt7 := FND_MESSAGE.get_string('FII', 'FII_AP_UNCLEARED');
72: stmt8 := FND_MESSAGE.get_string('FII', 'FII_AP_VOIDED');
73:
74: /*get date mask */
75: FII_PMV_Util.get_format_mask(l_date_mask);
76:
77:
78: /* Main SQL section */
79:

Line 154: FII_PMV_Util.bind_variable(

150: Where a.by_whom = usr.user_id
151: &ORDER_BY_CLAUSE';
152:
153: /* Binding Section */
154: FII_PMV_Util.bind_variable(
155: p_sqlstmt=>sqlstmt,
156: p_page_parameter_tbl=>p_page_parameter_tbl,
157: p_sql_output=>pay_act_sql,
158: p_bind_output_table=>pay_act_output,

Line 221: FII_PMV_Util.Get_Parameters(

217: l_id_column VARCHAR2(240);
218: l_sysdate VARCHAR2(30);
219:
220: BEGIN
221: FII_PMV_Util.Get_Parameters(
222: p_page_parameter_tbl,
223: l_as_of_date,
224: l_operating_unit,
225: l_supplier,

Line 238: FII_PMV_Util.Get_Report_Source(p_page_parameter_tbl, l_report_source);

234: l_org_where,
235: l_supplier_where
236: );
237:
238: FII_PMV_Util.Get_Report_Source(p_page_parameter_tbl, l_report_source);
239:
240: l_discount_offered := FII_PMV_Util.get_base_curr_colname(l_currency, 'discount_offered');
241:
242: l_late_payment_amt := FII_PMV_Util.get_base_curr_colname(l_currency, 'late_payment_amt');

Line 240: l_discount_offered := FII_PMV_Util.get_base_curr_colname(l_currency, 'discount_offered');

236: );
237:
238: FII_PMV_Util.Get_Report_Source(p_page_parameter_tbl, l_report_source);
239:
240: l_discount_offered := FII_PMV_Util.get_base_curr_colname(l_currency, 'discount_offered');
241:
242: l_late_payment_amt := FII_PMV_Util.get_base_curr_colname(l_currency, 'late_payment_amt');
243:
244: l_payment_amount := FII_PMV_Util.get_base_curr_colname(l_currency, 'payment_amount');

Line 242: l_late_payment_amt := FII_PMV_Util.get_base_curr_colname(l_currency, 'late_payment_amt');

238: FII_PMV_Util.Get_Report_Source(p_page_parameter_tbl, l_report_source);
239:
240: l_discount_offered := FII_PMV_Util.get_base_curr_colname(l_currency, 'discount_offered');
241:
242: l_late_payment_amt := FII_PMV_Util.get_base_curr_colname(l_currency, 'late_payment_amt');
243:
244: l_payment_amount := FII_PMV_Util.get_base_curr_colname(l_currency, 'payment_amount');
245:
246: l_on_time_payment_amt := FII_PMV_Util.get_base_curr_colname(l_currency, 'on_time_payment_amt');

Line 244: l_payment_amount := FII_PMV_Util.get_base_curr_colname(l_currency, 'payment_amount');

240: l_discount_offered := FII_PMV_Util.get_base_curr_colname(l_currency, 'discount_offered');
241:
242: l_late_payment_amt := FII_PMV_Util.get_base_curr_colname(l_currency, 'late_payment_amt');
243:
244: l_payment_amount := FII_PMV_Util.get_base_curr_colname(l_currency, 'payment_amount');
245:
246: l_on_time_payment_amt := FII_PMV_Util.get_base_curr_colname(l_currency, 'on_time_payment_amt');
247:
248: l_discount_taken := FII_PMV_Util.get_base_curr_colname(l_currency, 'discount_taken');

Line 246: l_on_time_payment_amt := FII_PMV_Util.get_base_curr_colname(l_currency, 'on_time_payment_amt');

242: l_late_payment_amt := FII_PMV_Util.get_base_curr_colname(l_currency, 'late_payment_amt');
243:
244: l_payment_amount := FII_PMV_Util.get_base_curr_colname(l_currency, 'payment_amount');
245:
246: l_on_time_payment_amt := FII_PMV_Util.get_base_curr_colname(l_currency, 'on_time_payment_amt');
247:
248: l_discount_taken := FII_PMV_Util.get_base_curr_colname(l_currency, 'discount_taken');
249:
250: l_discount_lost := FII_PMV_Util.get_base_curr_colname(l_currency, 'discount_lost');

Line 248: l_discount_taken := FII_PMV_Util.get_base_curr_colname(l_currency, 'discount_taken');

244: l_payment_amount := FII_PMV_Util.get_base_curr_colname(l_currency, 'payment_amount');
245:
246: l_on_time_payment_amt := FII_PMV_Util.get_base_curr_colname(l_currency, 'on_time_payment_amt');
247:
248: l_discount_taken := FII_PMV_Util.get_base_curr_colname(l_currency, 'discount_taken');
249:
250: l_discount_lost := FII_PMV_Util.get_base_curr_colname(l_currency, 'discount_lost');
251:
252: If l_currency = '_prim_g' then

Line 250: l_discount_lost := FII_PMV_Util.get_base_curr_colname(l_currency, 'discount_lost');

246: l_on_time_payment_amt := FII_PMV_Util.get_base_curr_colname(l_currency, 'on_time_payment_amt');
247:
248: l_discount_taken := FII_PMV_Util.get_base_curr_colname(l_currency, 'discount_taken');
249:
250: l_discount_lost := FII_PMV_Util.get_base_curr_colname(l_currency, 'discount_lost');
251:
252: If l_currency = '_prim_g' then
253: l_invoice_amount := 'prim_amount';
254: Elsif l_currency = '_sec_g' then

Line 260: FII_PMV_Util.get_check_id(p_page_parameter_tbl, l_check_id);

256: Elsif l_currency = '_b' then
257: l_invoice_amount := 'base_amount';
258: End if;
259:
260: FII_PMV_Util.get_check_id(p_page_parameter_tbl, l_check_id);
261:
262: FII_PMV_Util.Get_Period_Strt(
263: p_page_parameter_tbl,
264: l_period_start,

Line 262: FII_PMV_Util.Get_Period_Strt(

258: End if;
259:
260: FII_PMV_Util.get_check_id(p_page_parameter_tbl, l_check_id);
261:
262: FII_PMV_Util.Get_Period_Strt(
263: p_page_parameter_tbl,
264: l_period_start,
265: l_days_into_period,
266: l_cur_period,

Line 312: FII_PMV_Util.get_yes_no_msg(l_yes, l_no);

308: l_url_4 := 'AS_OF_DATE='||l_sysdate||'&pFunctionName=FII_AP_INV_LINES_DETAIL&pParamIds=Y&FII_AP_INVOICE_ID=FII_MEASURE2&FII_INVOICE_NUM=FII_MEASURE1'
309: ;
310:
311: /* get mls message for yes no */
312: FII_PMV_Util.get_yes_no_msg(l_yes, l_no);
313:
314: /*get date mask */
315: FII_PMV_Util.get_format_mask(l_date_mask);
316:

Line 315: FII_PMV_Util.get_format_mask(l_date_mask);

311: /* get mls message for yes no */
312: FII_PMV_Util.get_yes_no_msg(l_yes, l_no);
313:
314: /*get date mask */
315: FII_PMV_Util.get_format_mask(l_date_mask);
316:
317: /* Performance Tuning
318: 1.removed period type id = 1
319: 2.Implemented start/end index.

Line 1118: FII_PMV_Util.bind_variable(

1114: END IF;
1115:
1116:
1117: /* Binding Section */
1118: FII_PMV_Util.bind_variable(
1119: p_sqlstmt=>sqlstmt,
1120: p_page_parameter_tbl=>p_page_parameter_tbl,
1121: p_sql_output=>paid_inv_sql,
1122: p_bind_output_table=>paid_inv_output,

Line 1163: FII_PMV_Util.Get_Parameters(

1159:
1160: l_date_mask VARCHAR2(240);
1161: l_curr VARCHAR2(240);
1162: BEGIN
1163: FII_PMV_Util.Get_Parameters(
1164: p_page_parameter_tbl,
1165: l_as_of_date,
1166: l_operating_unit,
1167: l_supplier,

Line 1181: FII_PMV_Util.Get_Period_Strt(

1177: l_supplier_where
1178: );
1179:
1180:
1181: FII_PMV_Util.Get_Period_Strt(
1182: p_page_parameter_tbl,
1183: l_period_start,
1184: l_days_into_period,
1185: l_cur_period,

Line 1221: FII_PMV_Util.get_format_mask(l_date_mask);

1217: l_url_4 := 'pFunctionName=FII_AP_PAY_ACTIVITY_HISTORY&pParamIds=Y&FII_CHECK_ID=FII_MEASURE2&FII_CHECK=FII_MEASURE1'
1218: ;
1219:
1220: /*get date mask */
1221: FII_PMV_Util.get_format_mask(l_date_mask);
1222:
1223: l_supplier_where := replace(l_supplier_where, 'supplier', 'vendor');
1224:
1225: --Added for fix of bug 4327606

Line 1293: FII_PMV_Util.bind_variable(

1289: f.currency_code, asp.base_currency_code, f.base_amount
1290: &ORDER_BY_CLAUSE ';
1291:
1292: /* Binding Section */
1293: FII_PMV_Util.bind_variable(
1294: p_sqlstmt=>sqlstmt,
1295: p_page_parameter_tbl=>p_page_parameter_tbl,
1296: p_sql_output=>pay_detail_sql,
1297: p_bind_output_table=>pay_detail_output,