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.FA_SLA_EVENTS_UPG_PKG dependencies on DUAL

Line 672: from dual;

668:
669: -- Select upg_batch_id
670: select xla_upg_batches_s.nextval
671: into l_upg_batch_id
672: from dual;
673:
674: -- Update table with event_id
675: FORALL l_count IN 1..l_event_id_tbl.count
676: update fa_transaction_headers th

Line 853: from dual;

849: l_ae_line_num_tbl(j) := j;
850:
851: select xla_gl_sl_link_id_s.nextval
852: into l_xla_gl_sl_link_id_tbl(j)
853: from dual;
854: END LOOP;
855:
856: select xla_ae_headers_s.nextval
857: into l_ae_header_id

Line 858: from dual;

854: END LOOP;
855:
856: select xla_ae_headers_s.nextval
857: into l_ae_header_id
858: from dual;
859:
860: -- Business Rules for xla_ae_headers
861: -- * amb_context_code is DEFAULT
862: -- * reference_date must be null

Line 1266: from dual;

1262: l_ae_line_num_tbl(j) := j;
1263:
1264: select xla_gl_sl_link_id_s.nextval
1265: into l_xla_gl_sl_link_id_tbl(j)
1266: from dual;
1267: END LOOP;
1268:
1269: select xla_ae_headers_s.nextval
1270: into l_ae_header_id

Line 1271: from dual;

1267: END LOOP;
1268:
1269: select xla_ae_headers_s.nextval
1270: into l_ae_header_id
1271: from dual;
1272:
1273: -- Business Rules for xla_ae_headers
1274: -- * amb_context_code is DEFAULT
1275: -- * reference_date must be null

Line 1674: from dual;

1670: l_ae_line_num_tbl(j) := j;
1671:
1672: select xla_gl_sl_link_id_s.nextval
1673: into l_xla_gl_sl_link_id_tbl(j)
1674: from dual;
1675: END LOOP;
1676:
1677: select xla_ae_headers_s.nextval
1678: into l_ae_header_id

Line 1679: from dual;

1675: END LOOP;
1676:
1677: select xla_ae_headers_s.nextval
1678: into l_ae_header_id
1679: from dual;
1680:
1681: -- Business Rules for xla_ae_lines
1682: -- * gl_transfer_mode_code:
1683: -- D: Detailed mode when transferred to GL

Line 1970: from dual;

1966: l_ae_line_num_tbl(j) := j;
1967:
1968: select xla_gl_sl_link_id_s.nextval
1969: into l_xla_gl_sl_link_id_tbl(j)
1970: from dual;
1971: END LOOP;
1972:
1973: select xla_ae_headers_s.nextval
1974: into l_ae_header_id

Line 1975: from dual;

1971: END LOOP;
1972:
1973: select xla_ae_headers_s.nextval
1974: into l_ae_header_id
1975: from dual;
1976:
1977: -- Business Rules for xla_ae_headers
1978: -- * amb_context_code is DEFAULT
1979: -- * reference_date must be null

Line 3127: from dual;

3123:
3124: -- Select upg_batch_id
3125: select xla_upg_batches_s.nextval
3126: into l_upg_batch_id
3127: from dual;
3128:
3129: FOR i IN 1..l_rowid_tbl.count LOOP
3130: select xla_events_s.nextval, xla_transaction_entities_s.nextval
3131: into l_event_id_tbl(i), l_entity_id_tbl(i)

Line 3132: from dual;

3128:
3129: FOR i IN 1..l_rowid_tbl.count LOOP
3130: select xla_events_s.nextval, xla_transaction_entities_s.nextval
3131: into l_event_id_tbl(i), l_entity_id_tbl(i)
3132: from dual;
3133: END LOOP;
3134:
3135: -- Update table with event_id
3136: FORALL l_count IN 1..l_event_id_tbl.count

Line 3314: from dual;

3310: l_ae_line_num_tbl(j) := j;
3311:
3312: select xla_gl_sl_link_id_s.nextval
3313: into l_xla_gl_sl_link_id_tbl(j)
3314: from dual;
3315: END LOOP;
3316:
3317: select xla_ae_headers_s.nextval
3318: into l_ae_header_id

Line 3319: from dual;

3315: END LOOP;
3316:
3317: select xla_ae_headers_s.nextval
3318: into l_ae_header_id
3319: from dual;
3320:
3321: -- Business Rules for xla_ae_headers
3322: -- * amb_context_code is DEFAULT
3323: -- * reference_date must be null

Line 3725: from dual;

3721: l_ae_line_num_tbl(j) := j;
3722:
3723: select xla_gl_sl_link_id_s.nextval
3724: into l_xla_gl_sl_link_id_tbl(j)
3725: from dual;
3726: END LOOP;
3727:
3728: select xla_ae_headers_s.nextval
3729: into l_ae_header_id

Line 3730: from dual;

3726: END LOOP;
3727:
3728: select xla_ae_headers_s.nextval
3729: into l_ae_header_id
3730: from dual;
3731:
3732: -- Business Rules for xla_ae_headers
3733: -- * amb_context_code is DEFAULT
3734: -- * reference_date must be null

Line 4179: from dual;

4175:
4176: -- Select upg_batch_id
4177: select xla_upg_batches_s.nextval
4178: into l_upg_batch_id
4179: from dual;
4180:
4181: -- Save value into a variable
4182: select description
4183: into l_bonus_deprn_rsv_desc

Line 5391: (select 1 adj_row from dual

5387: gl_sets_of_books glsob,
5388: fa_distribution_accounts da,
5389: fa_asset_history ah,
5390: fa_category_books cb,
5391: (select 1 adj_row from dual
5392: union all
5393: select 2 adj_row from dual
5394: union all
5395: select 3 adj_row from dual) mult

Line 5393: select 2 adj_row from dual

5389: fa_asset_history ah,
5390: fa_category_books cb,
5391: (select 1 adj_row from dual
5392: union all
5393: select 2 adj_row from dual
5394: union all
5395: select 3 adj_row from dual) mult
5396: where ev.event_id = he.event_id
5397: and bc.book_type_code = ev.book_type_code

Line 5395: select 3 adj_row from dual) mult

5391: (select 1 adj_row from dual
5392: union all
5393: select 2 adj_row from dual
5394: union all
5395: select 3 adj_row from dual) mult
5396: where ev.event_id = he.event_id
5397: and bc.book_type_code = ev.book_type_code
5398: and bc.set_of_books_id = glsob.set_of_books_id
5399: and bc.book_type_code = adj.book_type_code

Line 6310: (select 1 adj_row from dual

6306: gl_sets_of_books glsob,
6307: fa_distribution_accounts da,
6308: fa_asset_history ah,
6309: fa_category_books cb,
6310: (select 1 adj_row from dual
6311: union all
6312: select 2 adj_row from dual
6313: union all
6314: select 3 adj_row from dual) mult

Line 6312: select 2 adj_row from dual

6308: fa_asset_history ah,
6309: fa_category_books cb,
6310: (select 1 adj_row from dual
6311: union all
6312: select 2 adj_row from dual
6313: union all
6314: select 3 adj_row from dual) mult
6315: where ev.event_id = he.event_id
6316: and bc.book_type_code = ev.book_type_code

Line 6314: select 3 adj_row from dual) mult

6310: (select 1 adj_row from dual
6311: union all
6312: select 2 adj_row from dual
6313: union all
6314: select 3 adj_row from dual) mult
6315: where ev.event_id = he.event_id
6316: and bc.book_type_code = ev.book_type_code
6317: and bc.set_of_books_id = glsob.set_of_books_id
6318: and bc.book_type_code = adj.book_type_code

Line 6443: from dual;

6439:
6440: -- Select upg_batch_id
6441: select xla_upg_batches_s.nextval
6442: into l_upg_batch_id
6443: from dual;
6444:
6445: select lk_de.description
6446: into l_de_description
6447: from fa_lookups_tl lk_de

Line 8369: from dual;

8365: select xla_transaction_entities_s.nextval,
8366: xla_events_s.nextval
8367: into l_entity_id_tbl(i),
8368: l_event_id_tbl(i)
8369: from dual;
8370:
8371: END LOOP;
8372:
8373: -- Update fa_deferred_deprn table with event_id

Line 8423: from dual

8419: c_upgrade_bugno,
8420: sysdate,
8421: c_upgrade_bugno,
8422: c_upgrade_bugno
8423: from dual
8424: where not exists
8425: (
8426: select 'x'
8427: from fa_deferred_deprn_events

Line 8600: from dual;

8596: close c_detail;
8597:
8598: select xla_ae_headers_s.nextval
8599: into l_ae_header_id
8600: from dual;
8601:
8602: FOR j IN 1..l_distribution_id_tbl.count LOOP
8603:
8604: select xla_gl_sl_link_id_s.nextval

Line 8606: from dual;

8602: FOR j IN 1..l_distribution_id_tbl.count LOOP
8603:
8604: select xla_gl_sl_link_id_s.nextval
8605: into l_exp_xla_gl_sl_link_id_tbl(j)
8606: from dual;
8607:
8608: select xla_gl_sl_link_id_s.nextval
8609: into l_rsv_xla_gl_sl_link_id_tbl(j)
8610: from dual;

Line 8610: from dual;

8606: from dual;
8607:
8608: select xla_gl_sl_link_id_s.nextval
8609: into l_rsv_xla_gl_sl_link_id_tbl(j)
8610: from dual;
8611:
8612: l_line_num_tbl(j) := (j - 1) * 2;
8613: END LOOP;
8614:

Line 9235: from dual;

9231: close c_mc_detail;
9232:
9233: select xla_ae_headers_s.nextval
9234: into l_ae_header_id
9235: from dual;
9236:
9237: FOR j IN 1..l_distribution_id_tbl.count LOOP
9238:
9239: select xla_gl_sl_link_id_s.nextval

Line 9241: from dual;

9237: FOR j IN 1..l_distribution_id_tbl.count LOOP
9238:
9239: select xla_gl_sl_link_id_s.nextval
9240: into l_exp_xla_gl_sl_link_id_tbl(j)
9241: from dual;
9242:
9243: select xla_gl_sl_link_id_s.nextval
9244: into l_rsv_xla_gl_sl_link_id_tbl(j)
9245: from dual;

Line 9245: from dual;

9241: from dual;
9242:
9243: select xla_gl_sl_link_id_s.nextval
9244: into l_rsv_xla_gl_sl_link_id_tbl(j)
9245: from dual;
9246:
9247: l_line_num_tbl(j) := (j - 1) * 2;
9248: END LOOP;
9249: