[Home] [Help]
9778: FND_MSG_PUB.Initialize;
9779: END IF;
9780:
9781: --bug 5513610
9782: /*DELETE FROM EGO_PAGE_ENTRIES_B
9783: WHERE ASSOCIATION_ID = p_association_id;*/
9784:
9785: UPDATE EGO_OBJ_AG_ASSOCS_B
9786: SET ENABLED_FLAG = p_enabled_flag,
10156:
10157: -- Finally, if we passed all checks, delete the records
10158: IF (l_is_ok_to_delete) THEN
10159: code_debug(l_api_name||' deleting association as conditions are met for assoc :'||cr.association_id);
10160: DELETE FROM EGO_PAGE_ENTRIES_B
10161: WHERE ASSOCIATION_ID = cr.association_id;
10162:
10163: DELETE FROM EGO_OBJ_AG_ASSOCS_B
10164: WHERE ASSOCIATION_ID = cr.association_id;
10580: IF FND_API.To_Boolean(p_init_msg_list) THEN
10581: FND_MSG_PUB.Initialize;
10582: END IF;
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;
10718:
10719:
10720: CURSOR page_region_csr (cp_association_id IN NUMBER) IS
10721: select display_name PAGE_DISPLAY_NAME from ego_pages_v
10722: where page_id in (select page_id from ego_page_entries_b
10723: where ASSOCIATION_ID = cp_association_id);
10724:
10725:
10726: BEGIN
10789: IF FND_API.To_Boolean(p_init_msg_list) THEN
10790: FND_MSG_PUB.Initialize;
10791: END IF;
10792:
10793: INSERT INTO EGO_PAGE_ENTRIES_B
10794: (
10795: PAGE_ID
10796: ,ASSOCIATION_ID
10797: ,SEQUENCE
10932: IF FND_API.To_Boolean(p_init_msg_list) THEN
10933: FND_MSG_PUB.Initialize;
10934: END IF;
10935:
10936: UPDATE EGO_PAGE_ENTRIES_B
10937: SET SEQUENCE = p_sequence,
10938: ASSOCIATION_ID = p_new_association_id, --2995435: Doesnt update association id
10939: LAST_UPDATED_BY = g_current_user_id,
10940: LAST_UPDATE_DATE = l_Sysdate,
11057: FND_MSG_PUB.Initialize;
11058: END IF;
11059:
11060: --Bug 3871440
11061: DELETE FROM EGO_PAGE_ENTRIES_B
11062: WHERE PAGE_ID = p_page_id
11063: AND ASSOCIATION_ID = p_association_id
11064: AND CLASSIFICATION_CODE = p_classification_code;
11065: