APPS.FEM_WEBADI_MEMBER_UTILS_PVT dependencies on BNE_LAYOUTS_B

Line 1449: l_layout_code BNE_LAYOUTS_B.LAYOUT_CODE%TYPE;

1445: l_user_id NUMBER(15) := 2; -- (user name : initial setup)
1446: l_login_id NUMBER := NVL(Fnd_Global.Login_Id, 0);
1447:
1448: l_existed_flag VARCHAR2(1) := 'N';
1449: l_layout_code BNE_LAYOUTS_B.LAYOUT_CODE%TYPE;
1450: l_header_block_id BNE_LAYOUT_BLOCKS_B.BLOCK_ID%TYPE;
1451: l_line_block_id BNE_LAYOUT_BLOCKS_B.BLOCK_ID%TYPE;
1452: l_interface_seq_num BNE_LAYOUT_COLS.SEQUENCE_NUM%TYPE;
1453:

Line 1494: FROM BNE_LAYOUTS_B

1490:
1491: BEGIN
1492: SELECT 'Y'
1493: INTO l_existed_flag
1494: FROM BNE_LAYOUTS_B
1495: WHERE APPLICATION_ID = 274
1496: AND LAYOUT_CODE = l_layout_code;
1497: EXCEPTION
1498: WHEN NO_DATA_FOUND THEN NULL;

Line 1503: -- Create Layout in BNE_LAYOUTS_B and BNE_LAYOUTS_TL

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

Line 1505: INSERT INTO BNE_LAYOUTS_B

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
1508: , OBJECT_VERSION_NUMBER
1509: , STYLESHEET_APP_ID

Line 6126: SELECT layout_code FROM bne_layouts_b WHERE integrator_code = 'FEM_DIM_MEMBER_INTG';

6122: l_api_name CONSTANT VARCHAR2(30) := 'Delete_Fem_Webadi_Seed';
6123: l_api_version CONSTANT NUMBER := 1.0;
6124:
6125: CURSOR dimintg_lyts_csr IS
6126: SELECT layout_code FROM bne_layouts_b WHERE integrator_code = 'FEM_DIM_MEMBER_INTG';
6127:
6128: CURSOR dimintg_intfs_csr IS
6129: SELECT interface_code FROM bne_interfaces_b WHERE integrator_code = 'FEM_DIM_MEMBER_INTG'
6130: AND interface_code <> 'FEM_DIM_MEMBER_HEADER_INTF';

Line 6178: DELETE FROM bne_layouts_b WHERE integrator_code = 'FEM_DIM_MEMBER_INTG';

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:
6180: FEM_ENGINES_PKG.User_Message (
6181: p_app_name => 'FEM'
6182: ,p_msg_text => 'Deleted...');