1499: END;
1500:
1501: IF (l_existed_flag = 'N') THEN
1502: ---------------------------------------------------------------------------
1503: -- Create Layout in BNE_LAYOUTS_B and BNE_LAYOUTS_TL
1504: ---------------------------------------------------------------------------
1505: INSERT INTO BNE_LAYOUTS_B
1506: ( APPLICATION_ID
1507: , LAYOUT_CODE
1544: , NULL
1545: , NULL
1546: );
1547:
1548: INSERT INTO BNE_LAYOUTS_TL
1549: ( APPLICATION_ID
1550: , LAYOUT_CODE
1551: , USER_NAME
1552: , CREATED_BY
6171:
6172:
6173: FOR dimintg_lyts_csr_rec IN dimintg_lyts_csr
6174: LOOP
6175: DELETE FROM bne_layouts_tl WHERE layout_code = dimintg_lyts_csr_rec.layout_code;
6176: END LOOP;
6177:
6178: DELETE FROM bne_layouts_b WHERE integrator_code = 'FEM_DIM_MEMBER_INTG';
6179: