67: end;
68:
69: function cf_currency_format_maskformula(cf_legislation_code in varchar2) return varchar2 is
70:
71: v_currency_code fnd_currencies.currency_code%type;
72: v_format_mask varchar2(100) := null;
73: v_field_length number(3) := 15;
74:
75: cursor currency_format_mask
72: v_format_mask varchar2(100) := null;
73: v_field_length number(3) := 15;
74:
75: cursor currency_format_mask
76: (c_territory_code in fnd_currencies.issuing_territory_code%type) is
77: select currency_code
78: from fnd_currencies
79: where issuing_territory_code = c_territory_code;
80:
74:
75: cursor currency_format_mask
76: (c_territory_code in fnd_currencies.issuing_territory_code%type) is
77: select currency_code
78: from fnd_currencies
79: where issuing_territory_code = c_territory_code;
80:
81: begin
82: open currency_format_mask (cf_legislation_code);