[Home] [Help]
160: begin
161: delete from BNE_CONTENT_COLS_TL T
162: where not exists
163: (select NULL
164: from BNE_CONTENT_COLS_B B
165: where B.APPLICATION_ID = T.APPLICATION_ID
166: and B.CONTENT_CODE = T.CONTENT_CODE
167: and B.SEQUENCE_NUM = T.SEQUENCE_NUM
168: ) and t.application_id=274 and t.content_code not in ('FEM_BALANCES_CNT','FEM_DIM_MEMBER_CNT','FEM_HIERARCHY_CNT');
537: P_USER_ID => 2);
538:
539: ---- Update content ----------------------------------
540: -- We say update content because as an when we create an integrator, a corresponding row is populated in bne_contents_b / tl. This procedure call will simply update some fields
541: -- for that already populated row. Moreover this makes a new row entry in the bne_content_cols_b / tl.
542:
543: BNE_CONTENT_UTILS.CREATE_CONTENT_STORED_SQL(
544: P_APPLICATION_ID => 274,
545: P_OBJECT_CODE => p_object_code,
2843:
2844: delete from bne_content_cols_tl where application_id = 274
2845: and content_code not in ('FEM_BALANCES_CNT');
2846:
2847: delete from bne_content_cols_b where application_id = 274
2848: and content_code not in ('FEM_BALANCES_CNT');
2849:
2850: delete from bne_contents_tl where application_id = 274
2851: and content_code not in ('FEM_BALANCES_CNT');