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 713: from dual;

709:
710: -- Select upg_batch_id
711: select xla_upg_batches_s.nextval
712: into l_upg_batch_id
713: from dual;
714:
715: -- Update table with event_id
716: FORALL l_count IN 1..l_event_id_tbl.count
717: update fa_trx_references trx

Line 900: from dual;

896: l_ae_line_num_tbl(j) := j;
897:
898: select xla_gl_sl_link_id_s.nextval
899: into l_xla_gl_sl_link_id_tbl(j)
900: from dual;
901:
902: END LOOP;
903:
904: select xla_ae_headers_s.nextval

Line 906: from dual;

902: END LOOP;
903:
904: select xla_ae_headers_s.nextval
905: into l_ae_header_id
906: from dual;
907:
908: l_line_num_tbl(1) := l_adj_line_id_tbl.count; -- Bug 6827893
909: l_ae_header_id_tbl(1) := l_ae_header_id; -- Bug 6827893
910:

Line 1321: from dual;

1317: l_ae_line_num_tbl(j) := j;
1318:
1319: select xla_gl_sl_link_id_s.nextval
1320: into l_xla_gl_sl_link_id_tbl(j)
1321: from dual;
1322: END LOOP;
1323:
1324: select xla_ae_headers_s.nextval
1325: into l_ae_header_id

Line 1326: from dual;

1322: END LOOP;
1323:
1324: select xla_ae_headers_s.nextval
1325: into l_ae_header_id
1326: from dual;
1327:
1328: l_line_num_tbl(k+1) := l_adj_line_id_tbl.count; -- Bug 6827893
1329: l_ae_header_id_tbl(k+1) := l_ae_header_id; -- Bug 6827893
1330:

Line 1735: from dual;

1731: l_ae_line_num_tbl(j) := j + l_line_num_tbl(1); -- Bug 6827893
1732:
1733: select xla_gl_sl_link_id_s.nextval
1734: into l_xla_gl_sl_link_id_tbl(j)
1735: from dual;
1736: END LOOP;
1737:
1738: -- Bug 6827893: No need to create new ae_hdr_id. Use same as src
1739: l_ae_header_id := l_ae_header_id_tbl(1);

Line 2032: from dual;

2028: l_ae_line_num_tbl(j) := j + l_line_num_tbl(k+1); -- Bug 6827893
2029:
2030: select xla_gl_sl_link_id_s.nextval
2031: into l_xla_gl_sl_link_id_tbl(j)
2032: from dual;
2033: END LOOP;
2034:
2035: -- Bug 6827893: No need to create new ae_hdr_id. Use same as src
2036: l_ae_header_id := l_ae_header_id_tbl(k+1);

Line 3221: from dual;

3217:
3218: -- Select upg_batch_id
3219: select xla_upg_batches_s.nextval
3220: into l_upg_batch_id
3221: from dual;
3222:
3223: FOR i IN 1..l_rowid_tbl.count LOOP
3224: select xla_events_s.nextval, xla_transaction_entities_s.nextval
3225: into l_event_id_tbl(i), l_entity_id_tbl(i)

Line 3226: from dual;

3222:
3223: FOR i IN 1..l_rowid_tbl.count LOOP
3224: select xla_events_s.nextval, xla_transaction_entities_s.nextval
3225: into l_event_id_tbl(i), l_entity_id_tbl(i)
3226: from dual;
3227: END LOOP;
3228:
3229: -- Update table with event_id
3230: FORALL l_count IN 1..l_event_id_tbl.count

Line 3408: from dual;

3404: l_ae_line_num_tbl(j) := j;
3405:
3406: select xla_gl_sl_link_id_s.nextval
3407: into l_xla_gl_sl_link_id_tbl(j)
3408: from dual;
3409: END LOOP;
3410:
3411: select xla_ae_headers_s.nextval
3412: into l_ae_header_id

Line 3413: from dual;

3409: END LOOP;
3410:
3411: select xla_ae_headers_s.nextval
3412: into l_ae_header_id
3413: from dual;
3414:
3415: -- Business Rules for xla_ae_headers
3416: -- * amb_context_code is DEFAULT
3417: -- * reference_date must be null

Line 3819: from dual;

3815: l_ae_line_num_tbl(j) := j;
3816:
3817: select xla_gl_sl_link_id_s.nextval
3818: into l_xla_gl_sl_link_id_tbl(j)
3819: from dual;
3820: END LOOP;
3821:
3822: select xla_ae_headers_s.nextval
3823: into l_ae_header_id

Line 3824: from dual;

3820: END LOOP;
3821:
3822: select xla_ae_headers_s.nextval
3823: into l_ae_header_id
3824: from dual;
3825:
3826: -- Business Rules for xla_ae_headers
3827: -- * amb_context_code is DEFAULT
3828: -- * reference_date must be null

Line 4274: from dual;

4270:
4271: -- Select upg_batch_id
4272: select xla_upg_batches_s.nextval
4273: into l_upg_batch_id
4274: from dual;
4275:
4276: -- Save value into a variable
4277: select description
4278: into l_bonus_deprn_rsv_desc

Line 5530: (select 1 adj_row from dual

5526: gl_sets_of_books glsob,
5527: fa_distribution_accounts da,
5528: fa_asset_history ah,
5529: fa_category_books cb,
5530: (select 1 adj_row from dual
5531: union all
5532: select 2 adj_row from dual
5533: union all
5534: select 3 adj_row from dual) mult

Line 5532: select 2 adj_row from dual

5528: fa_asset_history ah,
5529: fa_category_books cb,
5530: (select 1 adj_row from dual
5531: union all
5532: select 2 adj_row from dual
5533: union all
5534: select 3 adj_row from dual) mult
5535: where ev.event_id = he.event_id
5536: and bc.book_type_code = ev.book_type_code

Line 5534: select 3 adj_row from dual) mult

5530: (select 1 adj_row from dual
5531: union all
5532: select 2 adj_row from dual
5533: union all
5534: select 3 adj_row from dual) mult
5535: where ev.event_id = he.event_id
5536: and bc.book_type_code = ev.book_type_code
5537: and bc.set_of_books_id = glsob.set_of_books_id
5538: and bc.book_type_code = adj.book_type_code

Line 6449: (select 1 adj_row from dual

6445: gl_sets_of_books glsob,
6446: fa_distribution_accounts da,
6447: fa_asset_history ah,
6448: fa_category_books cb,
6449: (select 1 adj_row from dual
6450: union all
6451: select 2 adj_row from dual
6452: union all
6453: select 3 adj_row from dual) mult

Line 6451: select 2 adj_row from dual

6447: fa_asset_history ah,
6448: fa_category_books cb,
6449: (select 1 adj_row from dual
6450: union all
6451: select 2 adj_row from dual
6452: union all
6453: select 3 adj_row from dual) mult
6454: where ev.event_id = he.event_id
6455: and bc.book_type_code = ev.book_type_code

Line 6453: select 3 adj_row from dual) mult

6449: (select 1 adj_row from dual
6450: union all
6451: select 2 adj_row from dual
6452: union all
6453: select 3 adj_row from dual) mult
6454: where ev.event_id = he.event_id
6455: and bc.book_type_code = ev.book_type_code
6456: and bc.set_of_books_id = glsob.set_of_books_id
6457: and bc.book_type_code = adj.book_type_code

Line 6582: from dual;

6578:
6579: -- Select upg_batch_id
6580: select xla_upg_batches_s.nextval
6581: into l_upg_batch_id
6582: from dual;
6583:
6584: select lk_de.description
6585: into l_de_description
6586: from fa_lookups_tl lk_de

Line 8449: from dual;

8445: select xla_transaction_entities_s.nextval,
8446: xla_events_s.nextval
8447: into l_entity_id_tbl(i),
8448: l_event_id_tbl(i)
8449: from dual;
8450:
8451: END LOOP;
8452:
8453: -- Update fa_deferred_deprn table with event_id

Line 8503: from dual

8499: c_upgrade_bugno,
8500: sysdate,
8501: c_upgrade_bugno,
8502: c_upgrade_bugno
8503: from dual
8504: where not exists
8505: (
8506: select 'x'
8507: from fa_deferred_deprn_events

Line 8681: from dual;

8677: close c_detail;
8678:
8679: select xla_ae_headers_s.nextval
8680: into l_ae_header_id
8681: from dual;
8682:
8683: FOR j IN 1..l_distribution_id_tbl.count LOOP
8684:
8685: select xla_gl_sl_link_id_s.nextval

Line 8687: from dual;

8683: FOR j IN 1..l_distribution_id_tbl.count LOOP
8684:
8685: select xla_gl_sl_link_id_s.nextval
8686: into l_exp_xla_gl_sl_link_id_tbl(j)
8687: from dual;
8688:
8689: select xla_gl_sl_link_id_s.nextval
8690: into l_rsv_xla_gl_sl_link_id_tbl(j)
8691: from dual;

Line 8691: from dual;

8687: from dual;
8688:
8689: select xla_gl_sl_link_id_s.nextval
8690: into l_rsv_xla_gl_sl_link_id_tbl(j)
8691: from dual;
8692:
8693: l_line_num_tbl(j) := (j - 1) * 2;
8694: END LOOP;
8695:

Line 9316: from dual;

9312: close c_mc_detail;
9313:
9314: select xla_ae_headers_s.nextval
9315: into l_ae_header_id
9316: from dual;
9317:
9318: FOR j IN 1..l_distribution_id_tbl.count LOOP
9319:
9320: select xla_gl_sl_link_id_s.nextval

Line 9322: from dual;

9318: FOR j IN 1..l_distribution_id_tbl.count LOOP
9319:
9320: select xla_gl_sl_link_id_s.nextval
9321: into l_exp_xla_gl_sl_link_id_tbl(j)
9322: from dual;
9323:
9324: select xla_gl_sl_link_id_s.nextval
9325: into l_rsv_xla_gl_sl_link_id_tbl(j)
9326: from dual;

Line 9326: from dual;

9322: from dual;
9323:
9324: select xla_gl_sl_link_id_s.nextval
9325: into l_rsv_xla_gl_sl_link_id_tbl(j)
9326: from dual;
9327:
9328: l_line_num_tbl(j) := (j - 1) * 2;
9329: END LOOP;
9330: