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

Line 33: FII_PMV_Util.get_format_mask(l_date_mask);

29: l_date_mask VARCHAR2(240);
30:
31: BEGIN
32:
33: FII_PMV_Util.get_format_mask(l_date_mask);
34:
35: SELECT ' ('||fnd_message.get_string('FII','FII_AP_ASOF')||' '||to_char(TRUNC(last_refresh_date),l_date_mask)||')'
36: INTO l_last_update_date FROM bis_obj_properties
37: WHERE object_name = 'FII_AP_CURR_TOP_PDUE' AND object_type = 'REPORT';

Line 85: FII_PMV_UTIL.get_parameters(

81: BEGIN
82:
83: -- Read the parameters passed
84:
85: FII_PMV_UTIL.get_parameters(
86: p_page_parameter_tbl=>p_page_parameter_tbl,
87: p_as_of_date=>l_as_of_date,
88: p_operating_unit=>l_organization,
89: p_supplier=>l_supplier,

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

128: l_url_hold_history := 'AS_OF_DATE='||l_sysdate||'&pFunctionName=FII_AP_HOLD_HISTORY&pParamIds=Y&FII_AP_INVOICE_ID=FII_INVOICE_ID&FII_INVOICE=FII_INVOICE_NUM';
129: -- l_url_inv_detail:= 'AS_OF_DATE='||l_sysdate||'&pFunctionName=FII_AP_INV_DIST_DETAIL&pParamIds=Y&FII_INVOICE_ID=FII_INVOICE_ID&FII_INVOICE=FII_INVOICE_NUM';
130: l_url_inv_detail:= 'AS_OF_DATE='||l_sysdate||'&pFunctionName=FII_AP_INV_LINES_DETAIL&pParamIds=Y&FII_AP_INVOICE_ID=FII_INVOICE_ID&FII_INVOICE_NUM=FII_INVOICE_NUM';
131:
132: FII_PMV_Util.get_yes_no_msg(l_yes, l_no);
133:
134: /*
135: Added the following code to replace f.org_id with org.organization_id, due to
136: performance consciderations to make the table table hr_all_organization_units as the

Line 269: FII_PMV_UTIL.bind_variable(

265: &ORDER_BY_CLAUSE
266: ';
267:
268: -- Attach bind parameters
269: FII_PMV_UTIL.bind_variable(
270: p_sqlstmt=>sqlstmt,
271: p_page_parameter_tbl=>p_page_parameter_tbl,
272: p_sql_output=>inv_dtl_sql,
273: p_bind_output_table=>inv_dtl_output);

Line 318: FII_PMV_UTIL.get_parameters(

314: l_sysdate VARCHAR2(30);
315: BEGIN
316:
317: -- Read the parameters passed
318: FII_PMV_UTIL.get_parameters(
319: p_page_parameter_tbl=>p_page_parameter_tbl,
320: p_as_of_date=>l_as_of_date,
321: p_operating_unit=>l_organization,
322: p_supplier=>l_supplier,

Line 345: FII_PMV_UTIL.get_report_source (

341: END LOOP;
342: END IF;
343:
344:
345: FII_PMV_UTIL.get_report_source (
346: p_page_parameter_tbl=>p_page_parameter_tbl,
347: p_report_source=>l_report_source);
348:
349: l_record_type_id := 1143; -- no other value possible in this report

Line 350: l_discount_offered := FII_PMV_UTIL.get_base_curr_colname(l_curr_suffix, 'discount_offered');

346: p_page_parameter_tbl=>p_page_parameter_tbl,
347: p_report_source=>l_report_source);
348:
349: l_record_type_id := 1143; -- no other value possible in this report
350: l_discount_offered := FII_PMV_UTIL.get_base_curr_colname(l_curr_suffix, 'discount_offered');
351: l_discount_lost := FII_PMV_UTIL.get_base_curr_colname(l_curr_suffix, 'discount_lost');
352: l_discount_taken := FII_PMV_UTIL.get_base_curr_colname(l_curr_suffix, 'discount_taken');
353: l_discount_available := FII_PMV_UTIL.get_base_curr_colname(l_curr_suffix, 'discount_available');
354:

Line 351: l_discount_lost := FII_PMV_UTIL.get_base_curr_colname(l_curr_suffix, 'discount_lost');

347: p_report_source=>l_report_source);
348:
349: l_record_type_id := 1143; -- no other value possible in this report
350: l_discount_offered := FII_PMV_UTIL.get_base_curr_colname(l_curr_suffix, 'discount_offered');
351: l_discount_lost := FII_PMV_UTIL.get_base_curr_colname(l_curr_suffix, 'discount_lost');
352: l_discount_taken := FII_PMV_UTIL.get_base_curr_colname(l_curr_suffix, 'discount_taken');
353: l_discount_available := FII_PMV_UTIL.get_base_curr_colname(l_curr_suffix, 'discount_available');
354:
355: IF l_curr_suffix IS NOT NULL THEN

Line 352: l_discount_taken := FII_PMV_UTIL.get_base_curr_colname(l_curr_suffix, 'discount_taken');

348:
349: l_record_type_id := 1143; -- no other value possible in this report
350: l_discount_offered := FII_PMV_UTIL.get_base_curr_colname(l_curr_suffix, 'discount_offered');
351: l_discount_lost := FII_PMV_UTIL.get_base_curr_colname(l_curr_suffix, 'discount_lost');
352: l_discount_taken := FII_PMV_UTIL.get_base_curr_colname(l_curr_suffix, 'discount_taken');
353: l_discount_available := FII_PMV_UTIL.get_base_curr_colname(l_curr_suffix, 'discount_available');
354:
355: IF l_curr_suffix IS NOT NULL THEN
356: IF l_curr_suffix = '_prim_g' THEN

Line 353: l_discount_available := FII_PMV_UTIL.get_base_curr_colname(l_curr_suffix, 'discount_available');

349: l_record_type_id := 1143; -- no other value possible in this report
350: l_discount_offered := FII_PMV_UTIL.get_base_curr_colname(l_curr_suffix, 'discount_offered');
351: l_discount_lost := FII_PMV_UTIL.get_base_curr_colname(l_curr_suffix, 'discount_lost');
352: l_discount_taken := FII_PMV_UTIL.get_base_curr_colname(l_curr_suffix, 'discount_taken');
353: l_discount_available := FII_PMV_UTIL.get_base_curr_colname(l_curr_suffix, 'discount_available');
354:
355: IF l_curr_suffix IS NOT NULL THEN
356: IF l_curr_suffix = '_prim_g' THEN
357: l_invoice_amt_col := 'prim_amount';

Line 368: FII_PMV_UTIL.get_check_id(p_page_parameter_tbl, l_check_id);

364: l_unpaid_amt_col := 'amount_remaining_b';
365: END IF;
366: END IF;
367:
368: FII_PMV_UTIL.get_check_id(p_page_parameter_tbl, l_check_id);
369:
370: --Added for Bug 4309974
371: SELECT TO_CHAR(TRUNC(sysdate),'DD/MM/YYYY') INTO l_sysdate FROM dual;
372:

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

374: l_url_2 := 'AS_OF_DATE='||l_sysdate||'&pFunctionName=FII_AP_SCHED_PAY_DISCOUNT&pParamIds=Y&FII_AP_INVOICE_ID=FII_MEASURE2&FII_INVOICE=FII_MEASURE1';
375: l_url_3 := 'AS_OF_DATE='||l_sysdate||'&pFunctionName=FII_AP_HOLD_HISTORY&pParamIds=Y&FII_AP_INVOICE_ID=FII_MEASURE2&FII_INVOICE=FII_MEASURE1';
376: -- l_url_4 := 'AS_OF_DATE='||l_sysdate||'&pFunctionName=FII_AP_INV_DIST_DETAIL&pParamIds=Y&FII_INVOICE_ID=FII_MEASURE2&FII_INVOICE=FII_MEASURE1';
377: 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';
378: FII_PMV_Util.get_yes_no_msg(l_yes, l_no);
379: FII_PMV_Util.get_format_mask(l_date_mask);
380:
381: /*--------------------------------------------------------------+
382: | FII_MEASURE1 - Invoice Number |

Line 379: FII_PMV_Util.get_format_mask(l_date_mask);

375: l_url_3 := 'AS_OF_DATE='||l_sysdate||'&pFunctionName=FII_AP_HOLD_HISTORY&pParamIds=Y&FII_AP_INVOICE_ID=FII_MEASURE2&FII_INVOICE=FII_MEASURE1';
376: -- l_url_4 := 'AS_OF_DATE='||l_sysdate||'&pFunctionName=FII_AP_INV_DIST_DETAIL&pParamIds=Y&FII_INVOICE_ID=FII_MEASURE2&FII_INVOICE=FII_MEASURE1';
377: 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';
378: FII_PMV_Util.get_yes_no_msg(l_yes, l_no);
379: FII_PMV_Util.get_format_mask(l_date_mask);
380:
381: /*--------------------------------------------------------------+
382: | FII_MEASURE1 - Invoice Number |
383: | FII_MEASURE2 - Invoice ID |

Line 1708: FII_PMV_UTIL.bind_variable(

1704:
1705: END CASE;
1706:
1707: -- Attach bind parameters
1708: FII_PMV_UTIL.bind_variable(
1709: p_sqlstmt=>sqlstmt,
1710: p_page_parameter_tbl=>p_page_parameter_tbl,
1711: p_sql_output=>inv_dtl_sql,
1712: p_bind_output_table=>inv_dtl_output);