412: l_lang VARCHAR2(50);
413:
414: CURSOR C1 IS
415: SELECT FDF.Folder_Id
416: FROM FND_DEFAULT_FOLDERS FDF, FND_FOLDERS FF
417: WHERE
418: FDF.OBJECT=p_order_folder_object
419: AND (FDF.USER_ID=l_user_id OR (FDF.APPLICATION_ID=l_folder_app_id
420: AND FDF.USER_ID=l_responsibility_id))
423: ORDER BY FDF.USER_ID DESC;
424:
425: CURSOR C2 IS
426: SELECT FDF.Folder_Id
427: FROM FND_DEFAULT_FOLDERS FDF, FND_FOLDERS FF
428: WHERE
429: FDF.OBJECT=p_line_folder_object
430: AND (FDF.USER_ID=l_user_id OR (FDF.APPLICATION_ID=l_folder_app_id
431: AND FDF.USER_ID=l_responsibility_id))