APPS.FII_AP_INV_ON_HOLD_DETAIL dependencies on FII_PMV_UTIL

Line 47: FII_PMV_Util.Get_Parameters(

43: BEGIN
44:
45: -- Retrieve parameter info
46:
47: FII_PMV_Util.Get_Parameters(
48: p_page_parameter_tbl,
49: l_as_of_date,
50: l_operating_unit,
51: l_supplier,

Line 64: FII_PMV_Util.Get_Report_Source(

60: l_org_where,
61: l_supplier_where
62: );
63:
64: FII_PMV_Util.Get_Report_Source(
65: p_page_parameter_tbl,
66: l_report_source
67: );
68:

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

84: END LOOP;
85: END IF;
86:
87:
88: l_discount_offered := FII_PMV_Util.get_base_curr_colname(l_currency, 'discount_offered');
89: l_discount_taken := FII_PMV_Util.get_base_curr_colname(l_currency, 'discount_taken');
90: l_discount_lost := FII_PMV_Util.get_base_curr_colname(l_currency, 'discount_lost');
91: l_discount_available := FII_PMV_Util.get_base_curr_colname(l_currency, 'discount_available');
92: l_amount_remaining := FII_PMV_Util.get_base_curr_colname(l_currency, 'amount_remaining');

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

85: END IF;
86:
87:
88: l_discount_offered := FII_PMV_Util.get_base_curr_colname(l_currency, 'discount_offered');
89: l_discount_taken := FII_PMV_Util.get_base_curr_colname(l_currency, 'discount_taken');
90: l_discount_lost := FII_PMV_Util.get_base_curr_colname(l_currency, 'discount_lost');
91: l_discount_available := FII_PMV_Util.get_base_curr_colname(l_currency, 'discount_available');
92: l_amount_remaining := FII_PMV_Util.get_base_curr_colname(l_currency, 'amount_remaining');
93:

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

86:
87:
88: l_discount_offered := FII_PMV_Util.get_base_curr_colname(l_currency, 'discount_offered');
89: l_discount_taken := FII_PMV_Util.get_base_curr_colname(l_currency, 'discount_taken');
90: l_discount_lost := FII_PMV_Util.get_base_curr_colname(l_currency, 'discount_lost');
91: l_discount_available := FII_PMV_Util.get_base_curr_colname(l_currency, 'discount_available');
92: l_amount_remaining := FII_PMV_Util.get_base_curr_colname(l_currency, 'amount_remaining');
93:
94: IF l_currency = '_prim_g' THEN

Line 91: l_discount_available := FII_PMV_Util.get_base_curr_colname(l_currency, 'discount_available');

87:
88: l_discount_offered := FII_PMV_Util.get_base_curr_colname(l_currency, 'discount_offered');
89: l_discount_taken := FII_PMV_Util.get_base_curr_colname(l_currency, 'discount_taken');
90: l_discount_lost := FII_PMV_Util.get_base_curr_colname(l_currency, 'discount_lost');
91: l_discount_available := FII_PMV_Util.get_base_curr_colname(l_currency, 'discount_available');
92: l_amount_remaining := FII_PMV_Util.get_base_curr_colname(l_currency, 'amount_remaining');
93:
94: IF l_currency = '_prim_g' THEN
95: l_invoice_amount := 'prim_amount';

Line 92: l_amount_remaining := FII_PMV_Util.get_base_curr_colname(l_currency, 'amount_remaining');

88: l_discount_offered := FII_PMV_Util.get_base_curr_colname(l_currency, 'discount_offered');
89: l_discount_taken := FII_PMV_Util.get_base_curr_colname(l_currency, 'discount_taken');
90: l_discount_lost := FII_PMV_Util.get_base_curr_colname(l_currency, 'discount_lost');
91: l_discount_available := FII_PMV_Util.get_base_curr_colname(l_currency, 'discount_available');
92: l_amount_remaining := FII_PMV_Util.get_base_curr_colname(l_currency, 'amount_remaining');
93:
94: IF l_currency = '_prim_g' THEN
95: l_invoice_amount := 'prim_amount';
96: ELSIF l_currency = '_sec_g' THEN

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

102:
103: l_record_type_id := 1143;
104:
105:
106: FII_PMV_Util.get_yes_no_msg(l_yes, l_no);
107:
108: FII_PMV_Util.get_format_mask(l_date_mask);
109:
110: /*--------------------------------------------------------------+

Line 108: FII_PMV_Util.get_format_mask(l_date_mask);

104:
105:
106: FII_PMV_Util.get_yes_no_msg(l_yes, l_no);
107:
108: FII_PMV_Util.get_format_mask(l_date_mask);
109:
110: /*--------------------------------------------------------------+
111: | VIEWBY - Either Operating Unit / Supplier |
112: | VIEWBYID - Either org_id / supplier_id |

Line 351: FII_PMV_Util.bind_variable(

347: &ORDER_BY_CLAUSE' ;
348:
349: -- Binding Section
350:
351: FII_PMV_Util.bind_variable(
352: p_sqlstmt=> sqlstmt,
353: p_page_parameter_tbl=>p_page_parameter_tbl,
354: p_sql_output=> get_inv_detail_sql,
355: p_bind_output_table=> get_inv_detail_output,