DBA Data[Home] [Help]

APPS.FRM_SECURITY_PKG dependencies on FRM_DOC_PUB_OPTIONS

Line 66: OR (DOC.DOCUMENT_ID IN (SELECT PUB.DOCUMENT_ID FROM FRM_DOC_PUB_OPTIONS PUB

62: INTO VN_DIRECTORY_ID
63: FROM FRM_DOCUMENTS_VL DOC
64: WHERE DOC.DOCUMENT_ID = P_MENU_ID
65: AND ((DOC.END_DATE IS NULL OR DOC.END_DATE > SYSDATE)
66: OR (DOC.DOCUMENT_ID IN (SELECT PUB.DOCUMENT_ID FROM FRM_DOC_PUB_OPTIONS PUB
67: WHERE PUB.DOCUMENT_ID = P_MENU_ID AND PUB.END_DATE > SYSDATE)));
68: ELSE
69:
70: VN_DIRECTORY_ID := P_MENU_ID;

Line 316: OR (DOC.DOCUMENT_ID IN (SELECT PUB.DOCUMENT_ID FROM FRM_DOC_PUB_OPTIONS PUB

312: INTO VN_DIRECTORY_ID
313: FROM FRM_DOCUMENTS_VL DOC
314: WHERE DOC.DOCUMENT_ID = P_MENU_ID
315: AND ((DOC.END_DATE IS NULL OR DOC.END_DATE > SYSDATE)
316: OR (DOC.DOCUMENT_ID IN (SELECT PUB.DOCUMENT_ID FROM FRM_DOC_PUB_OPTIONS PUB
317: WHERE PUB.DOCUMENT_ID = P_MENU_ID AND PUB.END_DATE > SYSDATE)));
318: ELSE
319:
320: SELECT DIR.PARENT_ID

Line 600: OR (DOC.DOCUMENT_ID IN (SELECT PUB.DOCUMENT_ID FROM FRM_DOC_PUB_OPTIONS PUB

596: INTO VN_MENU_ID
597: FROM FRM_DOCUMENTS_VL DOC
598: WHERE DOC.DOCUMENT_ID = P_MENU_ID
599: AND ((DOC.END_DATE IS NULL OR DOC.END_DATE > SYSDATE)
600: OR (DOC.DOCUMENT_ID IN (SELECT PUB.DOCUMENT_ID FROM FRM_DOC_PUB_OPTIONS PUB
601: WHERE PUB.DOCUMENT_ID = P_MENU_ID AND PUB.END_DATE > SYSDATE)));
602:
603: ELSE
604: