APPS.IMC_BOOKMARK_PUB dependencies on HZ_PARTY_PREFERENCES

Line 61: /* Get party name and category of user to be stored in HZ_PARTY_PREFERENCES */

57: BEGIN
58:
59: /* NEED TO CHECK IF BOOKMARK EXISTS BEFORE ADDING? */
60:
61: /* Get party name and category of user to be stored in HZ_PARTY_PREFERENCES */
62: SELECT party_name, party_type
63: INTO l_party_name, l_category
64: FROM hz_parties
65: WHERE party_id = p_bookmarked_party_id;

Line 82: FROM HZ_PARTY_PREFERENCES

78: /* Get current number of bookmarks and compare with the maximum allowed in
79: user profile */
80: SELECT count(*)
81: INTO l_bookmark_num
82: FROM HZ_PARTY_PREFERENCES
83: WHERE MODULE = G_MODLUE
84: AND CATEGORY = l_category
85: AND PREFERENCE_CODE = G_PREFERENCE_CODE
86: AND PARTY_ID = p_party_id;

Line 362: FROM HZ_PARTY_PREFERENCES

358: /* Check if bookmark type is valid */
359: IF p_bookmarked_party_type IN (G_CATEGORY_ORG, G_CATEGORY_PERSON, G_CATEGORY_REL) THEN
360: OPEN x_bookmarked_party_ids FOR
361: SELECT value_number
362: FROM HZ_PARTY_PREFERENCES
363: WHERE MODULE = G_MODLUE
364: AND CATEGORY = p_bookmarked_party_type
365: AND PREFERENCE_CODE = G_PREFERENCE_CODE
366: AND PARTY_ID = p_party_id;

Line 383: FROM HZ_PARTY_PREFERENCES

379: ELSE /* get all bookmarks for a user */
380:
381: OPEN x_bookmarked_party_ids FOR
382: SELECT value_number
383: FROM HZ_PARTY_PREFERENCES
384: WHERE MODULE = G_MODLUE
385: AND PREFERENCE_CODE = G_PREFERENCE_CODE
386: AND PARTY_ID = p_party_id;
387: