DBA Data[Home] [Help]

APPS.PER_PERSADIS_XMLP_PKG dependencies on FND_CURRENCIES

Line 41: V_CURRENCY_CODE FND_CURRENCIES.CURRENCY_CODE%TYPE;

37: RETURN V_LEGISLATION_CODE;
38: END CF_LEGISLATION_CODEFORMULA;
39:
40: FUNCTION CF_CURRENCY_FORMAT_MASKFORMULA(CF_LEGISLATION_CODE IN VARCHAR2) RETURN VARCHAR2 IS
41: V_CURRENCY_CODE FND_CURRENCIES.CURRENCY_CODE%TYPE;
42: V_FORMAT_MASK VARCHAR2(100) := NULL;
43: V_FIELD_LENGTH NUMBER(3) := 14;
44: CURSOR CURRENCY_FORMAT_MASK(C_TERRITORY_CODE IN FND_CURRENCIES.ISSUING_TERRITORY_CODE%TYPE) IS
45: SELECT

Line 44: CURSOR CURRENCY_FORMAT_MASK(C_TERRITORY_CODE IN FND_CURRENCIES.ISSUING_TERRITORY_CODE%TYPE) IS

40: FUNCTION CF_CURRENCY_FORMAT_MASKFORMULA(CF_LEGISLATION_CODE IN VARCHAR2) RETURN VARCHAR2 IS
41: V_CURRENCY_CODE FND_CURRENCIES.CURRENCY_CODE%TYPE;
42: V_FORMAT_MASK VARCHAR2(100) := NULL;
43: V_FIELD_LENGTH NUMBER(3) := 14;
44: CURSOR CURRENCY_FORMAT_MASK(C_TERRITORY_CODE IN FND_CURRENCIES.ISSUING_TERRITORY_CODE%TYPE) IS
45: SELECT
46: CURRENCY_CODE
47: FROM
48: FND_CURRENCIES

Line 48: FND_CURRENCIES

44: CURSOR CURRENCY_FORMAT_MASK(C_TERRITORY_CODE IN FND_CURRENCIES.ISSUING_TERRITORY_CODE%TYPE) IS
45: SELECT
46: CURRENCY_CODE
47: FROM
48: FND_CURRENCIES
49: WHERE ISSUING_TERRITORY_CODE = C_TERRITORY_CODE;
50: BEGIN
51: OPEN CURRENCY_FORMAT_MASK(CF_LEGISLATION_CODE);
52: FETCH CURRENCY_FORMAT_MASK