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.

[Home] [Help]

APPS.BEN_CWB_WEBADI_UTILS dependencies on BNE_LAYOUT_COLS

Line 207: FROM bne_layout_cols

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

Line 246: bne_layout_cols_pkg.insert_row

242: END IF;
243: END IF;
244:
245:
246: bne_layout_cols_pkg.insert_row
247: (x_rowid => l_rowid
248: ,x_application_id => l_layout_cols_row.application_id
249: ,x_layout_code => p_layout_code
250: ,x_block_id => l_layout_cols_row.block_id

Line 313: FROM bne_layout_cols blc

309: SELECT blc.application_id
310: ,blc.layout_code
311: ,blc.block_id
312: ,blc.sequence_num
313: FROM bne_layout_cols blc
314: WHERE blc.application_id = p_application_id
315: AND blc.layout_code = p_layout_code;
316:
317: BEGIN

Line 322: bne_layout_cols_pkg.delete_row

318: hr_utility.set_location('Entering '||l_proc,10);
319: For l_layout_col_rec In c_layout_cols
320: LOOP
321: hr_utility.set_location('Seq Num :'||l_layout_col_rec.sequence_num,25);
322: bne_layout_cols_pkg.delete_row
323: (x_application_id => l_layout_col_rec.application_id
324: ,x_layout_code => l_layout_col_rec.layout_code
325: ,x_block_id => l_layout_col_rec.block_id
326: ,x_sequence_num => l_layout_col_rec.sequence_num);

Line 1185: FROM bne_layout_cols blc

1181: ,blc.created_by
1182: ,blc.last_updated_by
1183: ,blc.last_update_login
1184: ,blc.read_only_flag
1185: FROM bne_layout_cols blc
1186: WHERE blc.application_id = p_application_id
1187: AND blc.layout_code = p_base_layout_code
1188: AND blc.interface_seq_num = p_inf_seq;
1189:

Line 1249: bne_layout_cols_pkg.insert_row

1245: l_read_only_flag := l_layout_cols_row.read_only_flag;
1246: END IF;
1247: END IF;
1248:
1249: bne_layout_cols_pkg.insert_row
1250: (x_rowid => l_rowid
1251: ,x_application_id => l_layout_cols_row.application_id
1252: ,x_layout_code => p_act_layout_code
1253: ,x_block_id => l_layout_cols_row.block_id

Line 1352: FROM bne_layout_cols blc

1348: SELECT blc.application_id
1349: ,blc.layout_code
1350: ,blc.block_id
1351: ,blc.sequence_num
1352: FROM bne_layout_cols blc
1353: WHERE blc.application_id = v_application_id
1354: AND blc.layout_code = v_layout_code;
1355:
1356: CURSOR c_layout_cols_row(

Line 1378: FROM bne_layout_cols blc

1374: ,blc.DEFAULT_VALUE
1375: ,blc.created_by
1376: ,blc.last_updated_by
1377: ,blc.last_update_login
1378: FROM bne_layout_cols blc
1379: WHERE blc.application_id = v_application_id
1380: AND blc.layout_code = v_layout_code
1381: AND blc.interface_seq_num = v_interface_seq;
1382:

Line 1427: bne_layout_cols_pkg.delete_row

1423: EXIT WHEN c_layout_cols%NOTFOUND;
1424:
1425: -- DBMS_OUTPUT.put_line('## Seq Num :'||l_layout_col_rec.sequence_num);
1426: hr_utility.set_location('Seq Num :'||l_layout_col_rec.sequence_num,25);
1427: bne_layout_cols_pkg.delete_row
1428: (x_application_id => l_layout_col_rec.application_id
1429: ,x_layout_code => l_layout_col_rec.layout_code
1430: ,x_block_id => l_layout_col_rec.block_id
1431: ,x_sequence_num => l_layout_col_rec.sequence_num);

Line 1542: bne_layout_cols_pkg.insert_row

1538:
1539: -- DBMS_OUTPUT.put_line('Sequence :'||LIST(k).p_sequence ||'Inf Seq :'|| l_layout_cols_row.interface_seq_num);
1540:
1541: hr_utility.set_location('Sequence :'||LIST(k).p_sequence||'Inf Seq : '||l_layout_cols_row.interface_seq_num ,50);
1542: bne_layout_cols_pkg.insert_row
1543: (x_rowid => l_rowid
1544: ,x_application_id => l_layout_cols_row.application_id
1545: ,x_layout_code => p_layout_code
1546: ,x_block_id => l_layout_cols_row.block_id

Line 1967: bne_layout_cols layCols,

1963: ,infCols.sequence_num inf_Seq_Num
1964: ,layCols.SEQUENCE_NUM Dis_Seq_Num
1965: From bne_interfaces_b inf,
1966: bne_interface_cols_b infCols,
1967: bne_layout_cols layCols,
1968: bne_layout_blocks_b layBlk
1969: Where inf.integrator_code = p_integrator_code
1970: And inf.integrator_app_id = 800
1971: And inf.interface_code = p_interface_code

Line 2002: from bne_layout_cols

1998:
1999: cursor do_not_disturb is
2000: select interface_seq_num inf_Seq_Num,
2001: 2000+rownum Dis_Seq_Num
2002: from bne_layout_cols
2003: where interface_seq_num in (130,131,132,133,134)
2004: and layout_code = p_base_layout_code
2005: and interface_code = p_interface_code
2006: and p_interface_code = 'BEN_CWB_WRK_SHT_INTF'

Line 2018: from bne_layout_cols col1,

2014: 5,5,
2015: 164,6
2016: ),
2017: col1.interface_seq_num inf_Seq_Num, col2.sequence_num Dis_Seq_Num
2018: from bne_layout_cols col1,
2019: bne_layout_cols col2
2020: where col1.interface_seq_num in (7,159,165,9,5,164)
2021: and col1.layout_code = p_base_layout_code
2022: and col1.interface_code = p_interface_code

Line 2019: bne_layout_cols col2

2015: 164,6
2016: ),
2017: col1.interface_seq_num inf_Seq_Num, col2.sequence_num Dis_Seq_Num
2018: from bne_layout_cols col1,
2019: bne_layout_cols col2
2020: where col1.interface_seq_num in (7,159,165,9,5,164)
2021: and col1.layout_code = p_base_layout_code
2022: and col1.interface_code = p_interface_code
2023: and p_interface_code = 'BEN_CWB_WRK_SHT_INTF'

Line 2038: from bne_layout_cols col1,

2034: 166,3,
2035: 27,4
2036: ),
2037: col1.interface_seq_num inf_Seq_Num, col2.sequence_num Dis_Seq_Num
2038: from bne_layout_cols col1,
2039: bne_layout_cols col2
2040: where col1.interface_seq_num in (25,160,166,27)
2041: and col1.layout_code = p_base_layout_code
2042: and col1.interface_code = col2.interface_code

Line 2039: bne_layout_cols col2

2035: 27,4
2036: ),
2037: col1.interface_seq_num inf_Seq_Num, col2.sequence_num Dis_Seq_Num
2038: from bne_layout_cols col1,
2039: bne_layout_cols col2
2040: where col1.interface_seq_num in (25,160,166,27)
2041: and col1.layout_code = p_base_layout_code
2042: and col1.interface_code = col2.interface_code
2043: and col2.interface_seq_num = 30

Line 2058: from bne_layout_cols col1,

2054: 167,3,
2055: 45,4
2056: ),
2057: col1.interface_seq_num inf_Seq_Num, col2.sequence_num Dis_Seq_Num
2058: from bne_layout_cols col1,
2059: bne_layout_cols col2
2060: where col1.interface_seq_num in (43,161,167,45)
2061: and col1.layout_code = p_base_layout_code
2062: and col1.interface_code = col2.interface_code

Line 2059: bne_layout_cols col2

2055: 45,4
2056: ),
2057: col1.interface_seq_num inf_Seq_Num, col2.sequence_num Dis_Seq_Num
2058: from bne_layout_cols col1,
2059: bne_layout_cols col2
2060: where col1.interface_seq_num in (43,161,167,45)
2061: and col1.layout_code = p_base_layout_code
2062: and col1.interface_code = col2.interface_code
2063: and col2.interface_seq_num = 48

Line 2078: from bne_layout_cols col1,

2074: 168,3,
2075: 63,4
2076: ),
2077: col1.interface_seq_num inf_Seq_Num, col2.sequence_num Dis_Seq_Num
2078: from bne_layout_cols col1,
2079: bne_layout_cols col2
2080: where col1.interface_seq_num in (61,162,168,63)
2081: and col1.layout_code = p_base_layout_code
2082: and col1.interface_code = col2.interface_code

Line 2079: bne_layout_cols col2

2075: 63,4
2076: ),
2077: col1.interface_seq_num inf_Seq_Num, col2.sequence_num Dis_Seq_Num
2078: from bne_layout_cols col1,
2079: bne_layout_cols col2
2080: where col1.interface_seq_num in (61,162,168,63)
2081: and col1.layout_code = p_base_layout_code
2082: and col1.interface_code = col2.interface_code
2083: and col2.interface_seq_num = 66

Line 2098: from bne_layout_cols col1,

2094: 169,3,
2095: 81,4
2096: ),
2097: col1.interface_seq_num inf_Seq_Num, col2.sequence_num Dis_Seq_Num
2098: from bne_layout_cols col1,
2099: bne_layout_cols col2
2100: where col1.interface_seq_num in (79,163,169,81)
2101: and col1.layout_code = p_base_layout_code
2102: and col1.interface_code = col2.interface_code

Line 2099: bne_layout_cols col2

2095: 81,4
2096: ),
2097: col1.interface_seq_num inf_Seq_Num, col2.sequence_num Dis_Seq_Num
2098: from bne_layout_cols col1,
2099: bne_layout_cols col2
2100: where col1.interface_seq_num in (79,163,169,81)
2101: and col1.layout_code = p_base_layout_code
2102: and col1.interface_code = col2.interface_code
2103: and col2.interface_seq_num = 84

Line 2116: from bne_layout_cols col1,

2112: select decode (col1.interface_seq_num, 125, 1,
2113: 197,2
2114: ),
2115: col1.interface_seq_num inf_Seq_Num, col2.sequence_num Dis_Seq_Num
2116: from bne_layout_cols col1,
2117: bne_layout_cols col2
2118: where col1.interface_seq_num in (125,197)
2119: and col1.layout_code = p_base_layout_code
2120: and col1.interface_code = col2.interface_code

Line 2117: bne_layout_cols col2

2113: 197,2
2114: ),
2115: col1.interface_seq_num inf_Seq_Num, col2.sequence_num Dis_Seq_Num
2116: from bne_layout_cols col1,
2117: bne_layout_cols col2
2118: where col1.interface_seq_num in (125,197)
2119: and col1.layout_code = p_base_layout_code
2120: and col1.interface_code = col2.interface_code
2121: and col2.interface_seq_num = 3

Line 2154: From bne_layout_cols

2150: 198,19,
2151: 188,20,
2152: 190,21
2153: ) order_in_layout
2154: From bne_layout_cols
2155: Where interface_code = p_interface_code
2156: And p_interface_code = 'BEN_CWB_WRK_SHT_INTF'
2157: 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)
2158: And layout_code = p_base_layout_code

Line 2164: From bne_layout_cols

2160: union
2161: (Select interface_seq_num inf_Seq_Num
2162: ,sequence_num Dis_Seq_Num
2163: , interface_seq_num order_in_layout
2164: From bne_layout_cols
2165: Where interface_code = p_interface_code
2166: And p_interface_code = 'BEN_CWB_BGT_SHT_INTF'
2167: And interface_seq_num in (37,40,41,42,43,44,45,46,47,48,49,50,51,52,53)
2168: And layout_code = p_base_layout_code

Line 2175: From bne_layout_cols

2171: union
2172: (Select interface_seq_num inf_Seq_Num
2173: ,sequence_num Dis_Seq_Num
2174: , interface_seq_num order_in_layout
2175: From bne_layout_cols
2176: Where interface_code = p_interface_code
2177: And p_interface_code = 'BEN_CWB_SUMM_DIR_REP_INTF'
2178: And interface_seq_num in (16,17,18,19,20,21,22,23,24,25,26,27,28,29,30)
2179: And layout_code = p_base_layout_code