[Home] [Help]
8808: FND_MSG_PUB.Initialize;
8809: END IF;
8810:
8811: --bug 5513610
8812: /*DELETE FROM EGO_PAGE_ENTRIES_B
8813: WHERE ASSOCIATION_ID = p_association_id;*/
8814:
8815: UPDATE EGO_OBJ_AG_ASSOCS_B
8816: SET ENABLED_FLAG = p_enabled_flag,
9186:
9187: -- Finally, if we passed all checks, delete the records
9188: IF (l_is_ok_to_delete) THEN
9189: code_debug(l_api_name||' deleting association as conditions are met for assoc :'||cr.association_id);
9190: DELETE FROM EGO_PAGE_ENTRIES_B
9191: WHERE ASSOCIATION_ID = cr.association_id;
9192:
9193: DELETE FROM EGO_OBJ_AG_ASSOCS_B
9194: WHERE ASSOCIATION_ID = cr.association_id;
9610: IF FND_API.To_Boolean(p_init_msg_list) THEN
9611: FND_MSG_PUB.Initialize;
9612: END IF;
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;
9748:
9749:
9750: CURSOR page_region_csr (cp_association_id IN NUMBER) IS
9751: select display_name PAGE_DISPLAY_NAME from ego_pages_v
9752: where page_id in (select page_id from ego_page_entries_b
9753: where ASSOCIATION_ID = cp_association_id);
9754:
9755:
9756: BEGIN
9819: IF FND_API.To_Boolean(p_init_msg_list) THEN
9820: FND_MSG_PUB.Initialize;
9821: END IF;
9822:
9823: INSERT INTO EGO_PAGE_ENTRIES_B
9824: (
9825: PAGE_ID
9826: ,ASSOCIATION_ID
9827: ,SEQUENCE
9962: IF FND_API.To_Boolean(p_init_msg_list) THEN
9963: FND_MSG_PUB.Initialize;
9964: END IF;
9965:
9966: UPDATE EGO_PAGE_ENTRIES_B
9967: SET SEQUENCE = p_sequence,
9968: ASSOCIATION_ID = p_new_association_id, --2995435: Doesnt update association id
9969: LAST_UPDATED_BY = g_current_user_id,
9970: LAST_UPDATE_DATE = l_Sysdate,
10087: FND_MSG_PUB.Initialize;
10088: END IF;
10089:
10090: --Bug 3871440
10091: DELETE FROM EGO_PAGE_ENTRIES_B
10092: WHERE PAGE_ID = p_page_id
10093: AND ASSOCIATION_ID = p_association_id
10094: AND CLASSIFICATION_CODE = p_classification_code;
10095: