54: end;
55:
56: function cf_currency_format_maskformula(cf_legislation_code in varchar2) return varchar2 is
57:
58: v_currency_code fnd_currencies.currency_code%type;
59: v_format_mask varchar2(100) := null;
60: v_field_length number(3) := 14;
61:
62: cursor currency_format_mask
59: v_format_mask varchar2(100) := null;
60: v_field_length number(3) := 14;
61:
62: cursor currency_format_mask
63: (c_territory_code in fnd_currencies.issuing_territory_code%type) is
64: select currency_code,name
65: from fnd_currencies_vl
66: where issuing_territory_code = c_territory_code;
67:
61:
62: cursor currency_format_mask
63: (c_territory_code in fnd_currencies.issuing_territory_code%type) is
64: select currency_code,name
65: from fnd_currencies_vl
66: where issuing_territory_code = c_territory_code;
67:
68: begin
69: open currency_format_mask (cf_legislation_code);