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

Line 41: fii_pmv_util.get_parameters(

37: sqlstmt VARCHAR2(14000);
38: l_line_stmt VARCHAR2(1000);
39:
40: BEGIN
41: fii_pmv_util.get_parameters(
42: p_page_parameter_tbl,
43: l_as_of_date,
44: l_operating_unit,
45: l_supplier,

Line 74: fii_pmv_util.get_invoice_id(p_page_parameter_tbl, l_invoice_id);

70: else
71: l_line_stmt := ' AND aid.invoice_line_number = :LINE_NUMBER';
72: end if;
73:
74: fii_pmv_util.get_invoice_id(p_page_parameter_tbl, l_invoice_id);
75:
76: sqlstmt := '
77: SELECT aid.distribution_line_number FII_AP_DIST_NUM,
78: alc.displayed_field FII_AP_DIST_TYPE,

Line 94: fii_pmv_util.bind_variable(

90: &ORDER_BY_CLAUSE
91: ';
92:
93: -- R12 Added bind varaiable parameter p_line_number
94: fii_pmv_util.bind_variable(
95: p_sqlstmt => sqlstmt,
96: p_page_parameter_tbl => p_page_parameter_tbl,
97: p_sql_output => inv_dist_sql,
98: p_bind_output_table => inv_dist_output,

Line 129: FII_PMV_Util.Get_Parameters(

125: l_invoice_id NUMBER;
126:
127: BEGIN
128:
129: FII_PMV_Util.Get_Parameters(
130: p_page_parameter_tbl,
131: l_as_of_date,
132: l_operating_unit,
133: l_supplier,

Line 146: FII_PMV_Util.get_invoice_id(p_page_parameter_tbl, l_invoice_id);

142: l_org_where,
143: l_supplier_where
144: );
145:
146: FII_PMV_Util.get_invoice_id(p_page_parameter_tbl, l_invoice_id);
147:
148: /**************Description of Measures, Attributes returned to PMV *****
149: FII_MEASURE1 - Hold Name
150: FII_MEASURE2 - Hold Date

Line 178: FII_PMV_Util.bind_variable(

174: ';
175:
176:
177: /* Binding Section */
178: FII_PMV_Util.bind_variable(
179: p_sqlstmt=>sqlstmt,
180: p_page_parameter_tbl=>p_page_parameter_tbl,
181: p_sql_output=>hold_history_sql,
182: p_bind_output_table=>hold_history_output,

Line 222: FII_PMV_Util.Get_Parameters(

218:
219: l_date_mask VARCHAR2(240);
220: BEGIN
221:
222: FII_PMV_Util.Get_Parameters(
223: p_page_parameter_tbl,
224: l_as_of_date,
225: l_operating_unit,
226: l_supplier,

Line 239: FII_PMV_Util.get_invoice_id(p_page_parameter_tbl, l_invoice_id);

235: l_org_where,
236: l_supplier_where
237: );
238:
239: FII_PMV_Util.get_invoice_id(p_page_parameter_tbl, l_invoice_id);
240:
241: /**************Description of Measures, Attributes returned to PMV *****
242: FII_MEASURE1 - Action
243: FII_MEASURE2 - Date,

Line 261: FII_PMV_Util.get_format_mask(l_date_mask);

257: stmt8 := FND_MESSAGE.get_string('FII', 'FII_AP_PAYMT_STOP');
258: stmt9 := FND_MESSAGE.get_string('FII', 'FII_AP_PAYMT_RELEASE');
259:
260: /*get date mask */
261: FII_PMV_Util.get_format_mask(l_date_mask);
262:
263: /* Main SQL section */
264: sqlstmt := 'select action FII_MEASURE1,
265: action_date FII_MEASURE2,

Line 340: FII_PMV_Util.bind_variable(

336: stmt8 := FND_MESSAGE.get_string('FII', 'FII_AP_PAYMT_STOP');
337: stmt9 := FND_MESSAGE.get_string('FII', 'FII_AP_PAYMT_RELEASE');
338:
339: /* Binding Section */
340: FII_PMV_Util.bind_variable(
341: p_sqlstmt=>sqlstmt,
342: p_page_parameter_tbl=>p_page_parameter_tbl,
343: p_sql_output=>inv_act_sql,
344: p_bind_output_table=>inv_act_output,

Line 388: FII_PMV_Util.Get_Parameters(

384: l_yes VARCHAR2(240);
385: l_no VARCHAR2(240);
386: BEGIN
387:
388: FII_PMV_Util.Get_Parameters(
389: p_page_parameter_tbl,
390: l_as_of_date,
391: l_operating_unit,
392: l_supplier,

Line 405: FII_PMV_Util.get_invoice_id(p_page_parameter_tbl, l_invoice_id);

401: l_org_where,
402: l_supplier_where
403: );
404:
405: FII_PMV_Util.get_invoice_id(p_page_parameter_tbl, l_invoice_id);
406:
407: /**************Description of Measures, Attributes returned to PMV *****
408: FII_MEASURE1 - Payment Number
409: FII_MEASURE2 - Due Date

Line 422: FII_PMV_Util.get_format_mask(l_date_mask);

418: FII_MEASURE11 - Grand Total for Gross Amount
419: ***********************************************************************/
420:
421: /*get date mask */
422: FII_PMV_Util.get_format_mask(l_date_mask);
423:
424: /* get mls message for yes no */
425: FII_PMV_Util.get_yes_no_msg(l_yes, l_no);
426:

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

421: /*get date mask */
422: FII_PMV_Util.get_format_mask(l_date_mask);
423:
424: /* get mls message for yes no */
425: FII_PMV_Util.get_yes_no_msg(l_yes, l_no);
426:
427: /* Main SQL section */
428: sqlstmt := 'select a.Payment_Num FII_MEASURE1,
429: a.due_date FII_MEASURE2,

Line 446: FII_PMV_Util.bind_variable(

442: ;
443:
444:
445: /* Binding Section */
446: FII_PMV_Util.bind_variable(
447: p_sqlstmt=>sqlstmt,
448: p_page_parameter_tbl=>p_page_parameter_tbl,
449: p_sql_output=>sched_pay_sql,
450: p_bind_output_table=>sched_pay_output,

Line 483: fii_pmv_util.get_parameters(

479:
480: BEGIN
481:
482: -- To read parameters passed from the parent report
483: fii_pmv_util.get_parameters(
484: p_page_parameter_tbl,
485: l_as_of_date,
486: l_operating_unit,
487: l_supplier,

Line 501: fii_pmv_util.get_invoice_id(p_page_parameter_tbl, l_invoice_id);

497: l_supplier_where
498: );
499:
500: -- To get the invoice id
501: fii_pmv_util.get_invoice_id(p_page_parameter_tbl, l_invoice_id);
502:
503: l_url_line_amount := 'pFunctionName=FII_AP_INV_DIST_DETAIL&pParamIds=Y&FII_INVOICE_ID='|| l_invoice_id || '&FII_LINE_NUM=FII_AP_LINE_NUM';
504: l_url_po_number := 'pFunctionName=FII_EA_POA_DRILL&PoHeaderId='' || ail.po_header_id || ''&PoReleaseId='' || ail.po_release_id || ''&addBreadCrumb=Y&retainAM=Y';
505:

Line 542: fii_pmv_util.bind_variable(

538: AND rcvt.shipment_header_id = rcvsh.shipment_header_id(+)
539: AND ail.invoice_id = :INVOICE_ID
540: ORDER BY ail.line_number';
541:
542: fii_pmv_util.bind_variable(
543: p_sqlstmt => sqlstmt,
544: p_page_parameter_tbl => p_page_parameter_tbl,
545: p_sql_output => p_inv_lines_detail_sql,
546: p_bind_output_table => p_inv_lines_detail_output,