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