eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.BEN_CWB_WEBADI_UTILS dependencies on BNE_LAYOUT_COLS

Line 209: FROM bne_layout_cols

205: ,created_by
206: ,last_updated_by
207: ,last_update_login
208: ,read_only_flag
209: FROM bne_layout_cols
210: WHERE application_id = 800
211: AND layout_code = p_base_layout_code
212: ORDER BY block_id;
213:

Line 253: bne_layout_cols_pkg.insert_row

249: END IF;
250: END IF;
251:
252:
253: bne_layout_cols_pkg.insert_row
254: (x_rowid => l_rowid
255: ,x_application_id => l_layout_cols_row.application_id
256: ,x_layout_code => p_layout_code
257: ,x_block_id => l_layout_cols_row.block_id

Line 320: FROM bne_layout_cols blc

316: SELECT blc.application_id
317: ,blc.layout_code
318: ,blc.block_id
319: ,blc.sequence_num
320: FROM bne_layout_cols blc
321: WHERE blc.application_id = p_application_id
322: AND blc.layout_code = p_layout_code;
323:
324: BEGIN

Line 329: bne_layout_cols_pkg.delete_row

325: hr_utility.set_location('Entering '||l_proc,10);
326: For l_layout_col_rec In c_layout_cols
327: LOOP
328: hr_utility.set_location('Seq Num :'||l_layout_col_rec.sequence_num,25);
329: bne_layout_cols_pkg.delete_row
330: (x_application_id => l_layout_col_rec.application_id
331: ,x_layout_code => l_layout_col_rec.layout_code
332: ,x_block_id => l_layout_col_rec.block_id
333: ,x_sequence_num => l_layout_col_rec.sequence_num);

Line 1236: FROM bne_layout_cols blc

1232: ,blc.created_by
1233: ,blc.last_updated_by
1234: ,blc.last_update_login
1235: ,blc.read_only_flag
1236: FROM bne_layout_cols blc
1237: WHERE blc.application_id = p_application_id
1238: AND blc.layout_code = p_base_layout_code
1239: AND blc.interface_seq_num = p_inf_seq;
1240:

Line 1244: bne_layout_cols blc

1240:
1241: /*cursor csr_interface_cols_row is
1242: select bic.read_only_flag
1243: from bne_interface_cols_b bic,
1244: bne_layout_cols blc
1245: where blc.application_id = p_application_id
1246: and blc.layout_code = p_base_layout_code
1247: and blc.interface_seq_num = p_inf_seq
1248: and bic.sequence_num = p_inf_seq

Line 1253: FROM bne_layout_cols blc

1249: and blc.interface_code = bic.interface_code;*/
1250:
1251: cursor csr_layout_cols_promotion is
1252: select '1'
1253: FROM bne_layout_cols blc
1254: WHERE blc.application_id = p_application_id
1255: AND blc.layout_code = p_act_layout_code
1256: AND blc.interface_seq_num = p_inf_seq
1257: AND blc.interface_seq_num in (152,191,192,105,126);

Line 1339: bne_layout_cols_pkg.insert_row

1335: end if;*/
1336: END IF;
1337: END IF;
1338: hr_utility.set_location('p_inf_seq '||p_inf_seq||' l_read_only_flag '||l_read_only_flag,10);
1339: bne_layout_cols_pkg.insert_row
1340: (x_rowid => l_rowid
1341: ,x_application_id => l_layout_cols_row.application_id
1342: ,x_layout_code => p_act_layout_code
1343: ,x_block_id => l_layout_cols_row.block_id

Line 1449: FROM bne_layout_cols blc

1445: SELECT blc.application_id
1446: ,blc.layout_code
1447: ,blc.block_id
1448: ,blc.sequence_num
1449: FROM bne_layout_cols blc
1450: WHERE blc.application_id = v_application_id
1451: AND blc.layout_code = v_layout_code;
1452:
1453: CURSOR c_layout_cols_row(

Line 1475: FROM bne_layout_cols blc

1471: ,blc.DEFAULT_VALUE
1472: ,blc.created_by
1473: ,blc.last_updated_by
1474: ,blc.last_update_login
1475: FROM bne_layout_cols blc
1476: WHERE blc.application_id = v_application_id
1477: AND blc.layout_code = v_layout_code
1478: AND blc.interface_seq_num = v_interface_seq;
1479:

Line 1524: bne_layout_cols_pkg.delete_row

1520: EXIT WHEN c_layout_cols%NOTFOUND;
1521:
1522: -- DBMS_OUTPUT.put_line('## Seq Num :'||l_layout_col_rec.sequence_num);
1523: hr_utility.set_location('Seq Num :'||l_layout_col_rec.sequence_num,25);
1524: bne_layout_cols_pkg.delete_row
1525: (x_application_id => l_layout_col_rec.application_id
1526: ,x_layout_code => l_layout_col_rec.layout_code
1527: ,x_block_id => l_layout_col_rec.block_id
1528: ,x_sequence_num => l_layout_col_rec.sequence_num);

Line 1651: bne_layout_cols_pkg.insert_row

1647:
1648: -- DBMS_OUTPUT.put_line('Sequence :'||LIST(k).p_sequence ||'Inf Seq :'|| l_layout_cols_row.interface_seq_num);
1649:
1650: hr_utility.set_location('Sequence :'||LIST(k).p_sequence||'Inf Seq : '||l_layout_cols_row.interface_seq_num ,50);
1651: bne_layout_cols_pkg.insert_row
1652: (x_rowid => l_rowid
1653: ,x_application_id => l_layout_cols_row.application_id
1654: ,x_layout_code => p_layout_code
1655: ,x_block_id => l_layout_cols_row.block_id

Line 2096: bne_layout_cols layCols,

2092: ,infCols.sequence_num inf_Seq_Num
2093: ,layCols.SEQUENCE_NUM Dis_Seq_Num
2094: From bne_interfaces_b inf,
2095: bne_interface_cols_b infCols,
2096: bne_layout_cols layCols,
2097: bne_layout_blocks_b layBlk
2098: Where inf.integrator_code = p_integrator_code
2099: And inf.integrator_app_id = 800
2100: And inf.interface_code = p_interface_code

Line 2131: from bne_layout_cols

2127:
2128: cursor do_not_disturb is
2129: select interface_seq_num inf_Seq_Num,
2130: 2000+rownum Dis_Seq_Num
2131: from bne_layout_cols
2132: where interface_seq_num in (130,131,132,133,134)
2133: and layout_code = p_base_layout_code
2134: and interface_code = p_interface_code
2135: and (substr(p_interface_code,1,15) = 'BEN_CWB_WS_INTF'

Line 2148: from bne_layout_cols col1,

2144: 5,5,
2145: 164,6
2146: ),
2147: col1.interface_seq_num inf_Seq_Num, col2.sequence_num Dis_Seq_Num
2148: from bne_layout_cols col1,
2149: bne_layout_cols col2
2150: where col1.interface_seq_num in (7,159,165,9,5,164)
2151: and col1.layout_code = p_base_layout_code
2152: and col1.interface_code = p_interface_code

Line 2149: bne_layout_cols col2

2145: 164,6
2146: ),
2147: col1.interface_seq_num inf_Seq_Num, col2.sequence_num Dis_Seq_Num
2148: from bne_layout_cols col1,
2149: bne_layout_cols col2
2150: where col1.interface_seq_num in (7,159,165,9,5,164)
2151: and col1.layout_code = p_base_layout_code
2152: and col1.interface_code = p_interface_code
2153: and (substr(p_interface_code,1,15) = 'BEN_CWB_WS_INTF'

Line 2169: from bne_layout_cols col1,

2165: 166,3,
2166: 27,4
2167: ),
2168: col1.interface_seq_num inf_Seq_Num, col2.sequence_num Dis_Seq_Num
2169: from bne_layout_cols col1,
2170: bne_layout_cols col2
2171: where col1.interface_seq_num in (25,160,166,27)
2172: and col1.layout_code = p_base_layout_code
2173: and col1.interface_code = col2.interface_code

Line 2170: bne_layout_cols col2

2166: 27,4
2167: ),
2168: col1.interface_seq_num inf_Seq_Num, col2.sequence_num Dis_Seq_Num
2169: from bne_layout_cols col1,
2170: bne_layout_cols col2
2171: where col1.interface_seq_num in (25,160,166,27)
2172: and col1.layout_code = p_base_layout_code
2173: and col1.interface_code = col2.interface_code
2174: and col2.interface_seq_num = 30

Line 2190: from bne_layout_cols col1,

2186: 167,3,
2187: 45,4
2188: ),
2189: col1.interface_seq_num inf_Seq_Num, col2.sequence_num Dis_Seq_Num
2190: from bne_layout_cols col1,
2191: bne_layout_cols col2
2192: where col1.interface_seq_num in (43,161,167,45)
2193: and col1.layout_code = p_base_layout_code
2194: and col1.interface_code = col2.interface_code

Line 2191: bne_layout_cols col2

2187: 45,4
2188: ),
2189: col1.interface_seq_num inf_Seq_Num, col2.sequence_num Dis_Seq_Num
2190: from bne_layout_cols col1,
2191: bne_layout_cols col2
2192: where col1.interface_seq_num in (43,161,167,45)
2193: and col1.layout_code = p_base_layout_code
2194: and col1.interface_code = col2.interface_code
2195: and col2.interface_seq_num = 48

Line 2211: from bne_layout_cols col1,

2207: 168,3,
2208: 63,4
2209: ),
2210: col1.interface_seq_num inf_Seq_Num, col2.sequence_num Dis_Seq_Num
2211: from bne_layout_cols col1,
2212: bne_layout_cols col2
2213: where col1.interface_seq_num in (61,162,168,63)
2214: and col1.layout_code = p_base_layout_code
2215: and col1.interface_code = col2.interface_code

Line 2212: bne_layout_cols col2

2208: 63,4
2209: ),
2210: col1.interface_seq_num inf_Seq_Num, col2.sequence_num Dis_Seq_Num
2211: from bne_layout_cols col1,
2212: bne_layout_cols col2
2213: where col1.interface_seq_num in (61,162,168,63)
2214: and col1.layout_code = p_base_layout_code
2215: and col1.interface_code = col2.interface_code
2216: and col2.interface_seq_num = 66

Line 2232: from bne_layout_cols col1,

2228: 169,3,
2229: 81,4
2230: ),
2231: col1.interface_seq_num inf_Seq_Num, col2.sequence_num Dis_Seq_Num
2232: from bne_layout_cols col1,
2233: bne_layout_cols col2
2234: where col1.interface_seq_num in (79,163,169,81)
2235: and col1.layout_code = p_base_layout_code
2236: and col1.interface_code = col2.interface_code

Line 2233: bne_layout_cols col2

2229: 81,4
2230: ),
2231: col1.interface_seq_num inf_Seq_Num, col2.sequence_num Dis_Seq_Num
2232: from bne_layout_cols col1,
2233: bne_layout_cols col2
2234: where col1.interface_seq_num in (79,163,169,81)
2235: and col1.layout_code = p_base_layout_code
2236: and col1.interface_code = col2.interface_code
2237: and col2.interface_seq_num = 84

Line 2251: from bne_layout_cols col1,

2247: select decode (col1.interface_seq_num, 125, 1,
2248: 197,2
2249: ),
2250: col1.interface_seq_num inf_Seq_Num, col2.sequence_num Dis_Seq_Num
2251: from bne_layout_cols col1,
2252: bne_layout_cols col2
2253: where col1.interface_seq_num in (125,197)
2254: and col1.layout_code = p_base_layout_code
2255: and col1.interface_code = col2.interface_code

Line 2252: bne_layout_cols col2

2248: 197,2
2249: ),
2250: col1.interface_seq_num inf_Seq_Num, col2.sequence_num Dis_Seq_Num
2251: from bne_layout_cols col1,
2252: bne_layout_cols col2
2253: where col1.interface_seq_num in (125,197)
2254: and col1.layout_code = p_base_layout_code
2255: and col1.interface_code = col2.interface_code
2256: and col2.interface_seq_num = 3

Line 2271: from bne_layout_cols col1,

2267: 126,1,
2268: 105,2
2269: ),
2270: col1.interface_seq_num inf_Seq_Num, col2.sequence_num Dis_Seq_Num
2271: from bne_layout_cols col1,
2272: bne_layout_cols col2
2273: where col1.interface_seq_num in (105,126)
2274: and col1.layout_code = p_base_layout_code
2275: and col1.interface_code = col2.interface_code

Line 2272: bne_layout_cols col2

2268: 105,2
2269: ),
2270: col1.interface_seq_num inf_Seq_Num, col2.sequence_num Dis_Seq_Num
2271: from bne_layout_cols col1,
2272: bne_layout_cols col2
2273: where col1.interface_seq_num in (105,126)
2274: and col1.layout_code = p_base_layout_code
2275: and col1.interface_code = col2.interface_code
2276: and col2.interface_seq_num = 191

Line 2293: from bne_layout_cols col1,

2289: 126,1,
2290: 105,2
2291: ),
2292: col1.interface_seq_num inf_Seq_Num, col2.sequence_num Dis_Seq_Num
2293: from bne_layout_cols col1,
2294: bne_layout_cols col2
2295: where col1.interface_seq_num in (105,126)
2296: and col1.layout_code = p_base_layout_code
2297: and col1.interface_code = col2.interface_code

Line 2294: bne_layout_cols col2

2290: 105,2
2291: ),
2292: col1.interface_seq_num inf_Seq_Num, col2.sequence_num Dis_Seq_Num
2293: from bne_layout_cols col1,
2294: bne_layout_cols col2
2295: where col1.interface_seq_num in (105,126)
2296: and col1.layout_code = p_base_layout_code
2297: and col1.interface_code = col2.interface_code
2298: and col2.interface_seq_num = 152

Line 2314: from bne_layout_cols col1,

2310: 126,2,
2311: 105,3
2312: ),
2313: col1.interface_seq_num inf_Seq_Num, col2.sequence_num Dis_Seq_Num
2314: from bne_layout_cols col1,
2315: bne_layout_cols col2
2316: where col1.interface_seq_num in (105,152,126)
2317: and col1.layout_code = p_base_layout_code
2318: and col1.interface_code = col2.interface_code

Line 2315: bne_layout_cols col2

2311: 105,3
2312: ),
2313: col1.interface_seq_num inf_Seq_Num, col2.sequence_num Dis_Seq_Num
2314: from bne_layout_cols col1,
2315: bne_layout_cols col2
2316: where col1.interface_seq_num in (105,152,126)
2317: and col1.layout_code = p_base_layout_code
2318: and col1.interface_code = col2.interface_code
2319: and col2.interface_seq_num = 192

Line 2353: From bne_layout_cols

2349: 198,19,
2350: 188,20,
2351: 190,21
2352: ) order_in_layout
2353: From bne_layout_cols
2354: Where interface_code = p_interface_code
2355: and (substr(p_interface_code,1,15) = 'BEN_CWB_WS_INTF'
2356: OR p_interface_code = 'BEN_CWB_WRK_SHT_INTF')
2357: And interface_seq_num in (170,171,172,173,174,175,176,177,178,179,180,181,182,189,158,188,190,194,195,196,198)

Line 2364: From bne_layout_cols

2360: union
2361: (Select interface_seq_num inf_Seq_Num
2362: ,sequence_num Dis_Seq_Num
2363: , interface_seq_num order_in_layout
2364: From bne_layout_cols
2365: Where interface_code = p_interface_code
2366: And p_interface_code = 'BEN_CWB_BGT_SHT_INTF'
2367: And interface_seq_num in (37,40,41,42,43,44,45,46,47,48,49,50,51,52,53)
2368: And layout_code = p_base_layout_code

Line 2375: From bne_layout_cols

2371: union
2372: (Select interface_seq_num inf_Seq_Num
2373: ,sequence_num Dis_Seq_Num
2374: , interface_seq_num order_in_layout
2375: From bne_layout_cols
2376: Where interface_code = p_interface_code
2377: And p_interface_code = 'BEN_CWB_SUMM_DIR_REP_INTF'
2378: And interface_seq_num in (16,17,18,19,20,21,22,23,24,25,26,27,28,29,30)
2379: And layout_code = p_base_layout_code