DBA Data[Home] [Help]

APPS.EGO_EXT_FWK_PUB dependencies on EGO_PAGES_B

Line 1115: FROM EGO_PAGES_B

1111:
1112: IF p_object_id IS NOT NULL THEN
1113: SELECT PAGE_ID
1114: INTO l_page_id
1115: FROM EGO_PAGES_B
1116: WHERE OBJECT_ID = p_object_id
1117: AND CLASSIFICATION_CODE = p_classification_code
1118: AND INTERNAL_NAME = p_page_internal_name;
1119: END IF;

Line 10273: INSERT INTO EGO_PAGES_B

10269: ELSE
10270: x_page_id := p_page_id;
10271: END IF;
10272:
10273: INSERT INTO EGO_PAGES_B
10274: (
10275: PAGE_ID
10276: ,OBJECT_ID
10277: ,CLASSIFICATION_CODE

Line 10409: UPDATE EGO_PAGES_B

10405: ELSE
10406:
10407: -- We only update this information if we are NOT in NLS mode
10408: -- (i.e., we don't update it if we are in NLS mode)
10409: UPDATE EGO_PAGES_B
10410: SET INTERNAL_NAME = p_internal_name,
10411: SEQUENCE = p_sequence,
10412: LAST_UPDATED_BY = g_current_user_id,
10413: LAST_UPDATE_DATE = l_Sysdate,

Line 10587: DELETE FROM EGO_PAGES_B

10583:
10584: DELETE FROM EGO_PAGE_ENTRIES_B
10585: WHERE PAGE_ID = p_page_id;
10586:
10587: DELETE FROM EGO_PAGES_B
10588: WHERE PAGE_ID = p_page_id;
10589:
10590: DELETE FROM EGO_PAGES_TL
10591: WHERE PAGE_ID = p_page_id;

Line 14515: from EGO_PAGES_B B

14511:
14512: delete from EGO_PAGES_TL T
14513: where not exists
14514: (select NULL
14515: from EGO_PAGES_B B
14516: where B.PAGE_ID = T.PAGE_ID
14517: );
14518:
14519: update EGO_PAGES_TL T set (