DBA Data[Home] [Help]

APPS.EGO_EXT_FWK_PUB dependencies on EGO_PAGES_B

Line 1075: FROM EGO_PAGES_B

1071:
1072: IF p_object_id IS NOT NULL THEN
1073: SELECT PAGE_ID
1074: INTO l_page_id
1075: FROM EGO_PAGES_B
1076: WHERE OBJECT_ID = p_object_id
1077: AND CLASSIFICATION_CODE = p_classification_code
1078: AND INTERNAL_NAME = p_page_internal_name;
1079: END IF;

Line 9303: INSERT INTO EGO_PAGES_B

9299: ELSE
9300: x_page_id := p_page_id;
9301: END IF;
9302:
9303: INSERT INTO EGO_PAGES_B
9304: (
9305: PAGE_ID
9306: ,OBJECT_ID
9307: ,CLASSIFICATION_CODE

Line 9439: UPDATE EGO_PAGES_B

9435: ELSE
9436:
9437: -- We only update this information if we are NOT in NLS mode
9438: -- (i.e., we don't update it if we are in NLS mode)
9439: UPDATE EGO_PAGES_B
9440: SET INTERNAL_NAME = p_internal_name,
9441: SEQUENCE = p_sequence,
9442: LAST_UPDATED_BY = g_current_user_id,
9443: LAST_UPDATE_DATE = l_Sysdate,

Line 9617: DELETE FROM EGO_PAGES_B

9613:
9614: DELETE FROM EGO_PAGE_ENTRIES_B
9615: WHERE PAGE_ID = p_page_id;
9616:
9617: DELETE FROM EGO_PAGES_B
9618: WHERE PAGE_ID = p_page_id;
9619:
9620: DELETE FROM EGO_PAGES_TL
9621: WHERE PAGE_ID = p_page_id;

Line 13543: from EGO_PAGES_B B

13539:
13540: delete from EGO_PAGES_TL T
13541: where not exists
13542: (select NULL
13543: from EGO_PAGES_B B
13544: where B.PAGE_ID = T.PAGE_ID
13545: );
13546:
13547: update EGO_PAGES_TL T set (