84: AND upper(parameters) like upper(c_pageName);
85:
86:
87: BEGIN
88: -- Get the FND user_id if the user_name is passed
89: IF p_user_name IS NOT NULL THEN
90: SELECT user_id INTO g_user_id FROM fnd_user
91: WHERE user_name = p_user_name;
92: END IF;
86:
87: BEGIN
88: -- Get the FND user_id if the user_name is passed
89: IF p_user_name IS NOT NULL THEN
90: SELECT user_id INTO g_user_id FROM fnd_user
91: WHERE user_name = p_user_name;
92: END IF;
93:
94: -- Find the reference paths corresponding to p_user_name, p_page_id
386:
387: END bulk_delete_attributes ;
388:
389: -- Note : 1. USER_ID IN wwpob_portlet_instance$ IS ACTUALLY THE USER_NAME
390: -- IN FND_USER
391: -- 2. This procedure has a PORTAL dependency. On the long run,
392: -- this should be replaced by a centralized BIA API that will
393: -- access the Portal schema
394: -- Fix for bug 3006533