DBA Data[Home] [Help]

APPS.FA_SLA_EVENTS_UPG_PKG dependencies on XLA_GL_SL_LINK_ID_S

Line 851: select xla_gl_sl_link_id_s.nextval

847:
848: FOR j IN 1..l_adj_line_id_tbl.count LOOP
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:

Line 1264: select xla_gl_sl_link_id_s.nextval

1260:
1261: FOR j IN 1..l_adj_line_id_tbl.count LOOP
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:

Line 1672: select xla_gl_sl_link_id_s.nextval

1668:
1669: FOR j IN 1..l_adj_line_id_tbl.count LOOP
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:

Line 1968: select xla_gl_sl_link_id_s.nextval

1964:
1965: FOR j IN 1..l_adj_line_id_tbl.count LOOP
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:

Line 3312: select xla_gl_sl_link_id_s.nextval

3308:
3309: FOR j IN 1..l_adj_line_id_tbl.count LOOP
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:

Line 3723: select xla_gl_sl_link_id_s.nextval

3719:
3720: FOR j IN 1..l_adj_line_id_tbl.count LOOP
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:

Line 4728: xla_gl_sl_link_id_s.nextval, -- gl_sl_link_id

4724: line_desc1 || ' - ' ||
4725: to_char(cal_period_close_date, 'DD-MON-RR'),
4726: -- description
4727: accounting_class_code, -- accounting_class_code
4728: xla_gl_sl_link_id_s.nextval, -- gl_sl_link_id
4729: 'XLAJEL', -- gl_sl_link_table
4730: null, -- party_type_code
4731: null, -- party_id
4732: null, -- party_site_id

Line 4874: xla_gl_sl_link_id_s.currval, -- gl_sl_link_id

4870: null, -- reference_9
4871: null, -- reference_10
4872: null, -- subledger_doc_seq_id
4873: null, -- subledger_doc_seq_value
4874: xla_gl_sl_link_id_s.currval, -- gl_sl_link_id
4875: 'XLAJEL' -- gl_sl_link_table
4876: )
4877: when (adj_row = 2) then
4878: into xla_ae_lines (

Line 4942: xla_gl_sl_link_id_s.nextval, -- gl_sl_link_id

4938: line_desc2 || ' - ' ||
4939: to_char(cal_period_close_date, 'DD-MON-RR'),
4940: -- description
4941: 'ASSET', -- accounting_class_code
4942: xla_gl_sl_link_id_s.nextval, -- gl_sl_link_id
4943: 'XLAJEL', -- gl_sl_link_table
4944: null, -- party_type_code
4945: null, -- party_id
4946: null, -- party_site_id

Line 5089: xla_gl_sl_link_id_s.currval, -- gl_sl_link_id

5085: null, -- reference_9
5086: null, -- reference_10
5087: null, -- subledger_doc_seq_id
5088: null, -- subledger_doc_seq_value
5089: xla_gl_sl_link_id_s.currval, -- gl_sl_link_id
5090: 'XLAJEL' -- gl_sl_link_table
5091: )
5092: when (adj_row = 3) then
5093: into xla_ae_lines (

Line 5157: xla_gl_sl_link_id_s.nextval, -- gl_sl_link_id

5153: l_bonus_deprn_rsv_desc || ' - ' ||
5154: to_char(cal_period_close_date, 'DD-MON-RR'),
5155: -- description
5156: 'ASSET', -- accounting_class_code
5157: xla_gl_sl_link_id_s.nextval, -- gl_sl_link_id
5158: 'XLAJEL', -- gl_sl_link_table
5159: null, -- party_type_code
5160: null, -- party_id
5161: null, -- party_site_id

Line 5304: xla_gl_sl_link_id_s.currval, -- gl_sl_link_id

5300: null, -- reference_9
5301: null, -- reference_10
5302: null, -- subledger_doc_seq_id
5303: null, -- subledger_doc_seq_value
5304: xla_gl_sl_link_id_s.currval, -- gl_sl_link_id
5305: 'XLAJEL' -- gl_sl_link_table
5306: )
5307: select /*+ ordered index(adj, FA_ADJUSTMENTS_U1) use_nl(cb) index(cb, fa_category_books_u1) */
5308: adj.adjustment_line_id adj_line_id,

Line 5646: xla_gl_sl_link_id_s.nextval, -- gl_sl_link_id

5642: line_desc1 || ' - ' ||
5643: to_char(cal_period_close_date, 'DD-MON-RR'),
5644: -- description
5645: accounting_class_code, -- accounting_class_code
5646: xla_gl_sl_link_id_s.nextval, -- gl_sl_link_id
5647: 'XLAJEL', -- gl_sl_link_table
5648: null, -- party_type_code
5649: null, -- party_id
5650: null, -- party_site_id

Line 5792: xla_gl_sl_link_id_s.currval, -- gl_sl_link_id

5788: null, -- reference_9
5789: null, -- reference_10
5790: null, -- subledger_doc_seq_id
5791: null, -- subledger_doc_seq_value
5792: xla_gl_sl_link_id_s.currval, -- gl_sl_link_id
5793: 'XLAJEL' -- gl_sl_link_table
5794: )
5795: when (adj_row = 2) then
5796: into xla_ae_lines (

Line 5860: xla_gl_sl_link_id_s.nextval, -- gl_sl_link_id

5856: line_desc2 || ' - ' ||
5857: to_char(cal_period_close_date, 'DD-MON-RR'),
5858: -- description
5859: 'ASSET', -- accounting_class_code
5860: xla_gl_sl_link_id_s.nextval, -- gl_sl_link_id
5861: 'XLAJEL', -- gl_sl_link_table
5862: null, -- party_type_code
5863: null, -- party_id
5864: null, -- party_site_id

Line 6007: xla_gl_sl_link_id_s.currval, -- gl_sl_link_id

6003: null, -- reference_9
6004: null, -- reference_10
6005: null, -- subledger_doc_seq_id
6006: null, -- subledger_doc_seq_value
6007: xla_gl_sl_link_id_s.currval, -- gl_sl_link_id
6008: 'XLAJEL' -- gl_sl_link_table
6009: )
6010: when (adj_row = 3) then
6011: into xla_ae_lines (

Line 6075: xla_gl_sl_link_id_s.nextval, -- gl_sl_link_id

6071: l_bonus_deprn_rsv_desc || ' - ' ||
6072: to_char(cal_period_close_date, 'DD-MON-RR'),
6073: -- description
6074: 'ASSET', -- accounting_class_code
6075: xla_gl_sl_link_id_s.nextval, -- gl_sl_link_id
6076: 'XLAJEL', -- gl_sl_link_table
6077: null, -- party_type_code
6078: null, -- party_id
6079: null, -- party_site_id

Line 6222: xla_gl_sl_link_id_s.currval, -- gl_sl_link_id

6218: null, -- reference_9
6219: null, -- reference_10
6220: null, -- subledger_doc_seq_id
6221: null, -- subledger_doc_seq_value
6222: xla_gl_sl_link_id_s.currval, -- gl_sl_link_id
6223: 'XLAJEL' -- gl_sl_link_table
6224: )
6225: select /*+ ordered index(adj, FA_MC_ADJUSTMENTS_U1) use_nl(cb) index(cb, fa_category_books_u1) */
6226: adj.adjustment_line_id adj_line_id,

Line 7313: xla_gl_sl_link_id_s.nextval, -- gl_sl_link_id

7309: 3, 'EXPENSE',
7310: 4, 'ASSET',
7311: 5, 'EXPENSE',
7312: 6, 'ASSET'),
7313: xla_gl_sl_link_id_s.nextval, -- gl_sl_link_id
7314: 'XLAJEL', -- gl_sl_link_table
7315: null, -- party_type_code
7316: null, -- party_id
7317: null, -- party_site_id

Line 7488: xla_gl_sl_link_id_s.nextval, -- gl_sl_link_id

7484: null, -- reference_9
7485: null, -- reference_10
7486: null, -- subledger_doc_seq_id
7487: null, -- subledger_doc_seq_value
7488: xla_gl_sl_link_id_s.nextval, -- gl_sl_link_id
7489: 'XLAJEL' -- gl_sl_link_table
7490: )
7491: select /*+ leading(ev) index(dd, FA_DEPRN_DETAIL_N1) */
7492: ev.event_id event_id,

Line 7829: xla_gl_sl_link_id_s.nextval, -- gl_sl_link_id

7825: 3, 'EXPENSE',
7826: 4, 'ASSET',
7827: 5, 'EXPENSE',
7828: 6, 'ASSET'),
7829: xla_gl_sl_link_id_s.nextval, -- gl_sl_link_id
7830: 'XLAJEL', -- gl_sl_link_table
7831: null, -- party_type_code
7832: null, -- party_id
7833: null, -- party_site_id

Line 8004: xla_gl_sl_link_id_s.nextval, -- gl_sl_link_id

8000: null, -- reference_9
8001: null, -- reference_10
8002: null, -- subledger_doc_seq_id
8003: null, -- subledger_doc_seq_value
8004: xla_gl_sl_link_id_s.nextval, -- gl_sl_link_id
8005: 'XLAJEL' -- gl_sl_link_table
8006: )
8007: select /*+ leading(ev) index(dd, FA_MC_DEPRN_DETAIL_N1) */
8008: ev.event_id event_id,

Line 8604: select xla_gl_sl_link_id_s.nextval

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
8605: into l_exp_xla_gl_sl_link_id_tbl(j)
8606: from dual;
8607:
8608: select xla_gl_sl_link_id_s.nextval

Line 8608: select xla_gl_sl_link_id_s.nextval

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;
8611:
8612: l_line_num_tbl(j) := (j - 1) * 2;

Line 9239: select xla_gl_sl_link_id_s.nextval

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
9240: into l_exp_xla_gl_sl_link_id_tbl(j)
9241: from dual;
9242:
9243: select xla_gl_sl_link_id_s.nextval

Line 9243: select xla_gl_sl_link_id_s.nextval

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;
9246:
9247: l_line_num_tbl(j) := (j - 1) * 2;