DBA Data[Home] [Help]

APPS.ICX_CAT_STORE_ASSIGNMENT_PKG dependencies on FND_NEW_MESSAGES

Line 50: xMultipleMsg FND_NEW_MESSAGES.MESSAGE_TEXT%TYPE;

46: RETURN VARCHAR2 IS
47: xErrLoc INTEGER := 0;
48: xCount INTEGER := 0;
49: xStoreName ICX_CAT_SHOP_STORES_TL.NAME%TYPE;
50: xMultipleMsg FND_NEW_MESSAGES.MESSAGE_TEXT%TYPE;
51:
52: CURSOR store_assignments(p_contentType IN VARCHAR2,
53: p_contentId IN NUMBER) IS
54: SELECT

Line 80: FROM fnd_new_messages

76: RETURN xStoreName;
77: ELSE
78: SELECT message_text
79: INTO xMultipleMsg
80: FROM fnd_new_messages
81: WHERE message_name = 'ICX_POR_MULTIPLE'
82: AND language_code = USERENV('LANG');
83:
84: RETURN xMultipleMsg;