APPS.BIS_PMF_PORTLET_UTIL dependencies on BIS_USER_IND_SELECTIONS

Line 511: FROM bis_user_ind_selections

507: IS
508: l_num_rows INTEGER;
509: CURSOR c1 IS
510: SELECT COUNT(1)
511: FROM bis_user_ind_selections
512: WHERE plug_id = p_plug_id
513: AND USER_ID = p_user_id;
514:
515: CURSOR cPOwner IS

Line 626: -- rows in bis_user_ind_selections. Returns FALSE otherwise.

622: -- has_rows
623: --
624: -- PURPOSE
625: -- Returns TRUE if the owner of the portlet has customized
626: -- rows in bis_user_ind_selections. Returns FALSE otherwise.
627: -- PARAMETERS
628: --
629: -- HISTORY
630: -- 29-JAN-2002 juwang Created.

Line 642: bis_user_ind_selections bu

638: l_num_rows INTEGER;
639: CURSOR c1 IS
640: SELECT COUNT(1)
641: FROM
642: bis_user_ind_selections bu
643: ,ICX_PORTLET_CUSTOMIZATIONS ipc
644: WHERE ipc.plug_id = p_plug_id
645: AND bu.plug_id = ipc.plug_id
646: AND bu.user_id = ipc.user_id;

Line 691: FROM BIS_USER_IND_SELECTIONS

687:
688: BEGIN
689: -- deleting the non-existing target level id
690: DELETE
691: FROM BIS_USER_IND_SELECTIONS
692: WHERE PLUG_ID = p_plug_id
693: AND TARGET_LEVEL_ID = FND_API.G_MISS_NUM;
694:
695:

Line 697: FROM BIS_USER_IND_SELECTIONS

693: AND TARGET_LEVEL_ID = FND_API.G_MISS_NUM;
694:
695:
696: DELETE
697: FROM BIS_USER_IND_SELECTIONS
698: WHERE PLUG_ID = p_plug_id
699: AND TARGET_LEVEL_ID NOT IN
700: ( SELECT TARGET_LEVEL_ID
701: FROM BIS_TARGET_LEVELS