DBA Data[Home] [Help]

APPS.FA_SLA_EVENTS_UPG_PKG dependencies on XLA_GL_SL_LINK_ID_S

Line 898: select xla_gl_sl_link_id_s.nextval

894:
895: FOR j IN 1..l_adj_line_id_tbl.count LOOP
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;

Line 1319: select xla_gl_sl_link_id_s.nextval

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

Line 1733: select xla_gl_sl_link_id_s.nextval

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

Line 2030: select xla_gl_sl_link_id_s.nextval

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

Line 3406: select xla_gl_sl_link_id_s.nextval

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

Line 3817: select xla_gl_sl_link_id_s.nextval

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

Line 4866: xla_gl_sl_link_id_s.nextval, -- gl_sl_link_id

4862: line_desc1 || ' - ' ||
4863: to_char(cal_period_close_date, 'DD-MON-RR'),
4864: -- description
4865: accounting_class_code, -- accounting_class_code
4866: xla_gl_sl_link_id_s.nextval, -- gl_sl_link_id
4867: 'XLAJEL', -- gl_sl_link_table
4868: null, -- party_type_code
4869: null, -- party_id
4870: null, -- party_site_id

Line 5012: xla_gl_sl_link_id_s.currval, -- gl_sl_link_id

5008: null, -- reference_9
5009: null, -- reference_10
5010: null, -- subledger_doc_seq_id
5011: null, -- subledger_doc_seq_value
5012: xla_gl_sl_link_id_s.currval, -- gl_sl_link_id
5013: 'XLAJEL' -- gl_sl_link_table
5014: )
5015: when (adj_row = 2) then
5016: into xla_ae_lines (

Line 5080: xla_gl_sl_link_id_s.nextval, -- gl_sl_link_id

5076: line_desc2 || ' - ' ||
5077: to_char(cal_period_close_date, 'DD-MON-RR'),
5078: -- description
5079: 'ASSET', -- accounting_class_code
5080: xla_gl_sl_link_id_s.nextval, -- gl_sl_link_id
5081: 'XLAJEL', -- gl_sl_link_table
5082: null, -- party_type_code
5083: null, -- party_id
5084: null, -- party_site_id

Line 5227: xla_gl_sl_link_id_s.currval, -- gl_sl_link_id

5223: null, -- reference_9
5224: null, -- reference_10
5225: null, -- subledger_doc_seq_id
5226: null, -- subledger_doc_seq_value
5227: xla_gl_sl_link_id_s.currval, -- gl_sl_link_id
5228: 'XLAJEL' -- gl_sl_link_table
5229: )
5230: when (adj_row = 3) then
5231: into xla_ae_lines (

Line 5295: xla_gl_sl_link_id_s.nextval, -- gl_sl_link_id

5291: l_bonus_deprn_rsv_desc || ' - ' ||
5292: to_char(cal_period_close_date, 'DD-MON-RR'),
5293: -- description
5294: 'ASSET', -- accounting_class_code
5295: xla_gl_sl_link_id_s.nextval, -- gl_sl_link_id
5296: 'XLAJEL', -- gl_sl_link_table
5297: null, -- party_type_code
5298: null, -- party_id
5299: null, -- party_site_id

Line 5442: xla_gl_sl_link_id_s.currval, -- gl_sl_link_id

5438: null, -- reference_9
5439: null, -- reference_10
5440: null, -- subledger_doc_seq_id
5441: null, -- subledger_doc_seq_value
5442: xla_gl_sl_link_id_s.currval, -- gl_sl_link_id
5443: 'XLAJEL' -- gl_sl_link_table
5444: )
5445: -- Bug 7498880: Added hint to use FA_ASSET_HISTORY_N2 index
5446: select /*+ ordered index(adj, FA_ADJUSTMENTS_U1) use_nl(cb) index(cb, fa_category_books_u1) index(AH FA_ASSET_HISTORY_N2)*/

Line 5785: xla_gl_sl_link_id_s.nextval, -- gl_sl_link_id

5781: line_desc1 || ' - ' ||
5782: to_char(cal_period_close_date, 'DD-MON-RR'),
5783: -- description
5784: accounting_class_code, -- accounting_class_code
5785: xla_gl_sl_link_id_s.nextval, -- gl_sl_link_id
5786: 'XLAJEL', -- gl_sl_link_table
5787: null, -- party_type_code
5788: null, -- party_id
5789: null, -- party_site_id

Line 5931: xla_gl_sl_link_id_s.currval, -- gl_sl_link_id

5927: null, -- reference_9
5928: null, -- reference_10
5929: null, -- subledger_doc_seq_id
5930: null, -- subledger_doc_seq_value
5931: xla_gl_sl_link_id_s.currval, -- gl_sl_link_id
5932: 'XLAJEL' -- gl_sl_link_table
5933: )
5934: when (adj_row = 2) then
5935: into xla_ae_lines (

Line 5999: xla_gl_sl_link_id_s.nextval, -- gl_sl_link_id

5995: line_desc2 || ' - ' ||
5996: to_char(cal_period_close_date, 'DD-MON-RR'),
5997: -- description
5998: 'ASSET', -- accounting_class_code
5999: xla_gl_sl_link_id_s.nextval, -- gl_sl_link_id
6000: 'XLAJEL', -- gl_sl_link_table
6001: null, -- party_type_code
6002: null, -- party_id
6003: null, -- party_site_id

Line 6146: xla_gl_sl_link_id_s.currval, -- gl_sl_link_id

6142: null, -- reference_9
6143: null, -- reference_10
6144: null, -- subledger_doc_seq_id
6145: null, -- subledger_doc_seq_value
6146: xla_gl_sl_link_id_s.currval, -- gl_sl_link_id
6147: 'XLAJEL' -- gl_sl_link_table
6148: )
6149: when (adj_row = 3) then
6150: into xla_ae_lines (

Line 6214: xla_gl_sl_link_id_s.nextval, -- gl_sl_link_id

6210: l_bonus_deprn_rsv_desc || ' - ' ||
6211: to_char(cal_period_close_date, 'DD-MON-RR'),
6212: -- description
6213: 'ASSET', -- accounting_class_code
6214: xla_gl_sl_link_id_s.nextval, -- gl_sl_link_id
6215: 'XLAJEL', -- gl_sl_link_table
6216: null, -- party_type_code
6217: null, -- party_id
6218: null, -- party_site_id

Line 6361: xla_gl_sl_link_id_s.currval, -- gl_sl_link_id

6357: null, -- reference_9
6358: null, -- reference_10
6359: null, -- subledger_doc_seq_id
6360: null, -- subledger_doc_seq_value
6361: xla_gl_sl_link_id_s.currval, -- gl_sl_link_id
6362: 'XLAJEL' -- gl_sl_link_table
6363: )
6364: select /*+ ordered index(adj, FA_MC_ADJUSTMENTS_U1) use_nl(cb) index(cb, fa_category_books_u1) */
6365: adj.adjustment_line_id adj_line_id,

Line 7387: xla_gl_sl_link_id_s.nextval, -- gl_sl_link_id

7383: 3, 'EXPENSE',
7384: 4, 'ASSET',
7385: 5, 'EXPENSE',
7386: 6, 'ASSET'),
7387: xla_gl_sl_link_id_s.nextval, -- gl_sl_link_id
7388: 'XLAJEL', -- gl_sl_link_table
7389: null, -- party_type_code
7390: null, -- party_id
7391: null, -- party_site_id

Line 7562: xla_gl_sl_link_id_s.currval, -- gl_sl_link_id : Bug 6811548

7558: null, -- reference_9
7559: null, -- reference_10
7560: null, -- subledger_doc_seq_id
7561: null, -- subledger_doc_seq_value
7562: xla_gl_sl_link_id_s.currval, -- gl_sl_link_id : Bug 6811548
7563: 'XLAJEL' -- gl_sl_link_table
7564: )
7565: select /*+ leading(ev) index(dd, FA_DEPRN_DETAIL_N1) */
7566: ev.event_id event_id,

Line 7909: xla_gl_sl_link_id_s.nextval, -- gl_sl_link_id

7905: 3, 'EXPENSE',
7906: 4, 'ASSET',
7907: 5, 'EXPENSE',
7908: 6, 'ASSET'),
7909: xla_gl_sl_link_id_s.nextval, -- gl_sl_link_id
7910: 'XLAJEL', -- gl_sl_link_table
7911: null, -- party_type_code
7912: null, -- party_id
7913: null, -- party_site_id

Line 8084: xla_gl_sl_link_id_s.currval, -- gl_sl_link_id : Bug 6811548

8080: null, -- reference_9
8081: null, -- reference_10
8082: null, -- subledger_doc_seq_id
8083: null, -- subledger_doc_seq_value
8084: xla_gl_sl_link_id_s.currval, -- gl_sl_link_id : Bug 6811548
8085: 'XLAJEL' -- gl_sl_link_table
8086: )
8087: select /*+ leading(ev) index(dd, FA_MC_DEPRN_DETAIL_N1) */
8088: ev.event_id event_id,

Line 8685: select xla_gl_sl_link_id_s.nextval

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
8686: into l_exp_xla_gl_sl_link_id_tbl(j)
8687: from dual;
8688:
8689: select xla_gl_sl_link_id_s.nextval

Line 8689: select xla_gl_sl_link_id_s.nextval

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

Line 9320: select xla_gl_sl_link_id_s.nextval

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
9321: into l_exp_xla_gl_sl_link_id_tbl(j)
9322: from dual;
9323:
9324: select xla_gl_sl_link_id_s.nextval

Line 9324: select xla_gl_sl_link_id_s.nextval

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