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.XLA_AE_CODE_COMBINATION_PKG dependencies on XLA_AE_LINES_GT

Line 25: | xla_ae_lines_gt |

21: | This package calls the static procedure |
22: | 19-APR-2003 K.Boussema Included Error messages |
23: | 12-MAI-2003 K.Boussema Updated Message code XLA_AP_CODE_COMBINATION |
24: | 13-MAI-2003 K.Boussema Renamed temporary table xla_je_lines_gt by |
25: | xla_ae_lines_gt |
26: | 27-MAI-2003 K.Boussema Renamed code_combination_status by |
27: | code_combination_status_flag |
28: | 17-JUL-2003 K.Boussema Reviewd the code |
29: | 24-JUL-2003 K.Boussema Updated the error messages |

Line 39: | 12-DEC-2003 K.Boussema Renamed target_coa_id in xla_ae_lines_gt |

35: | 27-SEP-2003 K.Boussema Added the error message XLA_AP_COA_INVALID |
36: | 13-NOV-2003 K.Boussema Changed to fix issue in bug3252058 |
37: | 26-NOV-2003 K.Boussema Added the cache of GL mapping information |
38: | 28-NOV-2003 K.Boussema Changed create_ccid call by create_ccidV2 |
39: | 12-DEC-2003 K.Boussema Renamed target_coa_id in xla_ae_lines_gt |
40: | by ccid_coa_id |
41: | 18-DEC-2003 K.Boussema Changed to fix bug 3042840,3307761,3268940 |
42: | 3310291 and 3320689 |
43: | 20-JAN-2004 K.Boussema Updated the message error XLA_AP_COA_INVALID |

Line 2554: FROM xla_ae_lines_gt temp,

2550: hdr.entity_id entity_id,
2551: hdr.ledger_id ledger_id,
2552: hdr.ae_header_id ae_header_id,
2553: temp.ae_line_num ae_line_num
2554: FROM xla_ae_lines_gt temp,
2555: xla_ae_headers_gt hdr
2556: WHERE temp.ae_header_id = hdr.ae_header_id
2557: AND temp.ccid_coa_id = p_chart_of_accounts_id
2558: AND nvl(temp.segment1 ,'#') = nvl(p_segment1,'#')

Line 2714: FROM xla_ae_lines_gt temp

2710: temp.segment28 segment28,
2711: temp.segment29 segment29,
2712: temp.segment30 segment30,
2713: temp.ccid_coa_id coa_id
2714: FROM xla_ae_lines_gt temp
2715: WHERE temp.code_combination_id = -1
2716: AND temp.code_combination_status_code = C_CREATED
2717: AND temp.balance_type_code <> 'X'
2718: )

Line 3146: (p_msg => 'Validate the accounting ccids: SQL - Update xla_ae_lines_gt '

3142: l_rowcount := 0;
3143:
3144: IF (C_LEVEL_STATEMENT >= g_log_level) THEN
3145: trace
3146: (p_msg => 'Validate the accounting ccids: SQL - Update xla_ae_lines_gt '
3147: ,p_level => C_LEVEL_STATEMENT
3148: ,p_module => l_log_module);
3149: END IF;
3150:

Line 3151: UPDATE xla_ae_lines_gt temp

3147: ,p_level => C_LEVEL_STATEMENT
3148: ,p_module => l_log_module);
3149: END IF;
3150:
3151: UPDATE xla_ae_lines_gt temp
3152: SET code_combination_status_code =
3153: CASE
3154: WHEN temp.code_combination_id IS NOT NULL
3155: AND temp.code_combination_status_code = C_NOT_PROCESSED

Line 3211: (p_msg => '# rows Updated in xla_ae_lines_gt (ccid + ALT ccid) ='||l_rowcount

3207: l_count:= l_count + l_rowcount;
3208:
3209: IF (C_LEVEL_STATEMENT >= g_log_level) THEN
3210: trace
3211: (p_msg => '# rows Updated in xla_ae_lines_gt (ccid + ALT ccid) ='||l_rowcount
3212: ,p_level => C_LEVEL_STATEMENT
3213: ,p_module => l_log_module);
3214: END IF;
3215:

Line 3236: FROM xla_ae_lines_gt lns,

3232: hdr.entity_id entity_id,
3233: hdr.ledger_id ledger_id,
3234: hdr.ae_header_id ae_header_id,
3235: lns.code_combination_id ccid
3236: FROM xla_ae_lines_gt lns,
3237: xla_ae_headers_gt hdr
3238: WHERE lns.ae_header_id = hdr.ae_header_id
3239: AND lns.code_combination_id <> -1
3240: AND lns.code_combination_status_code = C_INVALID

Line 3254: FROM xla_ae_lines_gt lns,

3250: hdr.entity_id entity_id,
3251: hdr.ledger_id ledger_id,
3252: hdr.ae_header_id ae_header_id,
3253: lns.alt_code_combination_id ccid
3254: FROM xla_ae_lines_gt lns,
3255: xla_ae_headers_gt hdr
3256: WHERE lns.ae_header_id = hdr.ae_header_id
3257: AND lns.alt_code_combination_id <> -1
3258: AND lns.alt_ccid_status_code = C_INVALID

Line 3349: (p_msg => 'Override the accounting ccid: SQL - Update xla_ae_lines_gt '

3345: l_rowcount := 0;
3346:
3347: IF (C_LEVEL_STATEMENT >= g_log_level) THEN
3348: trace
3349: (p_msg => 'Override the accounting ccid: SQL - Update xla_ae_lines_gt '
3350: ,p_level => C_LEVEL_STATEMENT
3351: ,p_module => l_log_module);
3352: END IF;
3353:

Line 3354: UPDATE xla_ae_lines_gt temp

3350: ,p_level => C_LEVEL_STATEMENT
3351: ,p_module => l_log_module);
3352: END IF;
3353:
3354: UPDATE xla_ae_lines_gt temp
3355: SET
3356: ( segment1
3357: , segment2
3358: , segment3

Line 3442: (p_msg => 'Override the accounting ALT ccid: SQL - Update xla_ae_lines_gt '

3438: ,p_level => C_LEVEL_STATEMENT
3439: ,p_module => l_log_module);
3440:
3441: trace
3442: (p_msg => 'Override the accounting ALT ccid: SQL - Update xla_ae_lines_gt '
3443: ,p_level => C_LEVEL_STATEMENT
3444: ,p_module => l_log_module);
3445:
3446: END IF;

Line 3449: UPDATE xla_ae_lines_gt temp

3445:
3446: END IF;
3447:
3448:
3449: UPDATE xla_ae_lines_gt temp
3450: SET
3451: ( alt_segment1
3452: , alt_segment2
3453: , alt_segment3

Line 3734: l_upd_stmt := 'UPDATE xla_ae_lines_gt temp

3730: END IF;
3731: --
3732: END LOOP;
3733:
3734: l_upd_stmt := 'UPDATE xla_ae_lines_gt temp
3735: SET code_combination_id =
3736: CASE
3737: WHEN temp.ccid_coa_id = :1
3738: AND temp.code_combination_status_code = :2

Line 3918: UPDATE xla_ae_lines_gt temp

3914: l_rowcount := 0;
3915: l_count := 0;
3916: g_error_exists := FALSE;
3917:
3918: UPDATE xla_ae_lines_gt temp
3919: SET code_combination_id =
3920: CASE
3921: WHEN temp.code_combination_id IS NULL
3922: AND temp.balance_type_code <> 'X'

Line 4199: UPDATE /+ dynamic_sampling(1) / xla_ae_lines_gt temp

4195:
4196: --
4197: -- get transaction ccid
4198: --
4199: UPDATE /*+ dynamic_sampling(1) */ xla_ae_lines_gt temp
4200: SET ( temp.code_combination_id
4201: ,temp.segment1
4202: ,temp.segment2
4203: ,temp.segment3

Line 4306: (p_msg => '# of rows updated into xla_ae_lines_gt(ccid) = '||to_char(l_rowcount)

4302: l_count := l_count + l_rowcount;
4303:
4304: IF (C_LEVEL_STATEMENT >= g_log_level) THEN
4305: trace
4306: (p_msg => '# of rows updated into xla_ae_lines_gt(ccid) = '||to_char(l_rowcount)
4307: ,p_level => C_LEVEL_STATEMENT
4308: ,p_module => l_log_module);
4309:
4310: END IF;

Line 4313: UPDATE /+ dynamic_sampling(1) / xla_ae_lines_gt temp

4309:
4310: END IF;
4311:
4312:
4313: UPDATE /*+ dynamic_sampling(1) */ xla_ae_lines_gt temp
4314: SET ( temp.alt_code_combination_id
4315: ,temp.alt_segment1
4316: ,temp.alt_segment2
4317: ,temp.alt_segment3

Line 4420: (p_msg => '# of rows updated into xla_ae_lines_gt(ALT ccid) = '||to_char(l_rowcount)

4416: l_count := l_count + l_rowcount;
4417:
4418: IF (C_LEVEL_STATEMENT >= g_log_level) THEN
4419: trace
4420: (p_msg => '# of rows updated into xla_ae_lines_gt(ALT ccid) = '||to_char(l_rowcount)
4421: ,p_level => C_LEVEL_STATEMENT
4422: ,p_module => l_log_module);
4423:
4424: END IF;

Line 4594: UPDATE xla_ae_lines_gt temp

4590: IF l_array_header_id.COUNT > 0 THEN
4591:
4592: FORALL i IN l_array_header_id.FIRST .. l_array_header_id.LAST
4593:
4594: UPDATE xla_ae_lines_gt temp
4595: SET ( temp.code_combination_id
4596: ,temp.segment1
4597: ,temp.segment2
4598: ,temp.segment3

Line 4703: (p_msg => '# of rows updated into xla_ae_lines_gt(ccid) = '||to_char(l_rowcount)

4699: l_count := l_count + l_rowcount;
4700:
4701: IF (C_LEVEL_STATEMENT >= g_log_level) THEN
4702: trace
4703: (p_msg => '# of rows updated into xla_ae_lines_gt(ccid) = '||to_char(l_rowcount)
4704: ,p_level => C_LEVEL_STATEMENT
4705: ,p_module => l_log_module);
4706:
4707: END IF;

Line 4778: UPDATE xla_ae_lines_gt temp

4774: IF l_array_alt_header_id.COUNT > 0 THEN
4775:
4776: FORALL i IN l_array_alt_header_id.FIRST .. l_array_alt_header_id.LAST
4777:
4778: UPDATE xla_ae_lines_gt temp
4779: SET ( temp.alt_code_combination_id
4780: ,temp.alt_segment1
4781: ,temp.alt_segment2
4782: ,temp.alt_segment3

Line 4888: (p_msg => '# of rows updated into xla_ae_lines_gt(ALT ccid) = '||to_char(l_rowcount)

4884: l_count := l_count + l_rowcount;
4885:
4886: IF (C_LEVEL_STATEMENT >= g_log_level) THEN
4887: trace
4888: (p_msg => '# of rows updated into xla_ae_lines_gt(ALT ccid) = '||to_char(l_rowcount)
4889: ,p_level => C_LEVEL_STATEMENT
4890: ,p_module => l_log_module);
4891:
4892: END IF;

Line 4918: ,xla_ae_lines_gt xjlg

4914: ,gami.from_ccid from_ccid
4915: ,xjlg.ccid_coa_id ccid_coa_id
4916: FROM gl_accts_map_int_gt gami
4917: ,xla_transaction_accts_gt xtag
4918: ,xla_ae_lines_gt xjlg
4919: WHERE xjlg.ae_header_id = xtag.ae_header_id
4920: AND xjlg.temp_line_num = xtag.temp_line_num
4921: AND xjlg.ledger_id = xtag.ledger_id
4922: AND xjlg.sl_coa_mapping_id = xtag.sl_coa_mapping_id

Line 4941: ,xla_ae_lines_gt xjlg

4937: ,gami.from_ccid from_ccid
4938: , xjlg.ccid_coa_id coa_id
4939: FROM gl_accts_map_int_gt gami
4940: ,xla_transaction_accts_gt xtag
4941: ,xla_ae_lines_gt xjlg
4942: WHERE xjlg.ae_header_id = xtag.ae_header_id
4943: AND xjlg.temp_line_num = xtag.temp_line_num
4944: AND xjlg.ledger_id = xtag.ledger_id
4945: AND xjlg.sl_coa_mapping_id = xtag.sl_coa_mapping_id

Line 5144: -- update xla_ae_lines_gt

5140: l_gl_error_code:='GL_BSV_MAP_MAPPING_ERROR';
5141: l_error :=TRUE;
5142: END;
5143:
5144: -- update xla_ae_lines_gt
5145:
5146: IF l_error THEN
5147:
5148: UPDATE xla_ae_lines_gt temp

Line 5148: UPDATE xla_ae_lines_gt temp

5144: -- update xla_ae_lines_gt
5145:
5146: IF l_error THEN
5147:
5148: UPDATE xla_ae_lines_gt temp
5149: SET temp.code_combination_id = -1
5150: ,temp.code_combination_status_code = C_INVALID
5151: WHERE temp.balance_type_code <> 'X'
5152: AND EXISTS (SELECT /*+ INDEX (t XLA_TRANSACTION_ACCTS_GT_N1) */ 'x' --bug7673701

Line 5171: (p_msg => '# of rows updated into xla_ae_lines_gt(error) = '||to_char(l_rowcount)

5167: l_rowcount:= SQL%ROWCOUNT;
5168:
5169: IF (C_LEVEL_STATEMENT >= g_log_level) THEN
5170: trace
5171: (p_msg => '# of rows updated into xla_ae_lines_gt(error) = '||to_char(l_rowcount)
5172: ,p_level => C_LEVEL_STATEMENT
5173: ,p_module => l_log_module);
5174:
5175: END IF;

Line 5213: UPDATE xla_ae_lines_gt temp

5209: l_array_entity_id.DELETE ;
5210: l_array_event_id.DELETE;
5211: l_array_ledger_id.DELETE;
5212:
5213: UPDATE xla_ae_lines_gt temp
5214: SET temp.alt_code_combination_id = -1
5215: ,temp.alt_ccid_status_code = C_INVALID
5216: WHERE temp.balance_type_code <> 'X'
5217: AND EXISTS (SELECT /*+ INDEX (t XLA_TRANSACTION_ACCTS_GT_N1) */ 'x' --bug7673701

Line 5237: (p_msg => '# of rows updated into xla_ae_lines_gt(error) = '||to_char(l_rowcount)

5233: l_count := l_count + l_rowcount;
5234:
5235: IF (C_LEVEL_STATEMENT >= g_log_level) THEN
5236: trace
5237: (p_msg => '# of rows updated into xla_ae_lines_gt(error) = '||to_char(l_rowcount)
5238: ,p_level => C_LEVEL_STATEMENT
5239: ,p_module => l_log_module);
5240:
5241: END IF;

Line 5269: -- copy converted qualifier value in the xla_ae_lines_gt table

5265:
5266:
5267: ELSE
5268: -- no error
5269: -- copy converted qualifier value in the xla_ae_lines_gt table
5270:
5271: UPDATE xla_ae_lines_gt temp
5272: SET ( temp.segment1
5273: ,temp.segment2

Line 5271: UPDATE xla_ae_lines_gt temp

5267: ELSE
5268: -- no error
5269: -- copy converted qualifier value in the xla_ae_lines_gt table
5270:
5271: UPDATE xla_ae_lines_gt temp
5272: SET ( temp.segment1
5273: ,temp.segment2
5274: ,temp.segment3
5275: ,temp.segment4

Line 5377: (p_msg => '# of rows updated into xla_ae_lines_gt(ccid) = '||to_char(l_rowcount)

5373:
5374: l_rowcount:= SQL%ROWCOUNT;
5375: IF (C_LEVEL_STATEMENT >= g_log_level) THEN
5376: trace
5377: (p_msg => '# of rows updated into xla_ae_lines_gt(ccid) = '||to_char(l_rowcount)
5378: ,p_level => C_LEVEL_STATEMENT
5379: ,p_module => l_log_module);
5380: END IF;
5381: l_count := l_count + l_rowcount;

Line 5382: --end insert into xla_ae_lines_gt(ccid)

5378: ,p_level => C_LEVEL_STATEMENT
5379: ,p_module => l_log_module);
5380: END IF;
5381: l_count := l_count + l_rowcount;
5382: --end insert into xla_ae_lines_gt(ccid)
5383:
5384:
5385: UPDATE xla_ae_lines_gt temp
5386: SET ( temp.alt_segment1

Line 5385: UPDATE xla_ae_lines_gt temp

5381: l_count := l_count + l_rowcount;
5382: --end insert into xla_ae_lines_gt(ccid)
5383:
5384:
5385: UPDATE xla_ae_lines_gt temp
5386: SET ( temp.alt_segment1
5387: ,temp.alt_segment2
5388: ,temp.alt_segment3
5389: ,temp.alt_segment4

Line 5491: (p_msg => '# of rows updated into xla_ae_lines_gt(ALT ccid) = '||to_char(l_rowcount)

5487:
5488: l_rowcount:= SQL%ROWCOUNT;
5489: IF (C_LEVEL_STATEMENT >= g_log_level) THEN
5490: trace
5491: (p_msg => '# of rows updated into xla_ae_lines_gt(ALT ccid) = '||to_char(l_rowcount)
5492: ,p_level => C_LEVEL_STATEMENT
5493: ,p_module => l_log_module);
5494: END IF;
5495: l_count := l_count + l_rowcount;

Line 5496: --end insert into xla_ae_lines_gt(ccid)

5492: ,p_level => C_LEVEL_STATEMENT
5493: ,p_module => l_log_module);
5494: END IF;
5495: l_count := l_count + l_rowcount;
5496: --end insert into xla_ae_lines_gt(ccid)
5497:
5498: END IF;
5499:
5500: END LOOP; --end loop qualifiers

Line 5654: FROM xla_ae_lines_gt xalg

5650:
5651: UPDATE xla_ae_headers_gt xahg
5652: SET xahg.accounting_entry_status_code = xla_ae_journal_entry_pkg.C_INVALID
5653: WHERE xahg.ae_header_id IN (SELECT xalg.ae_header_id
5654: FROM xla_ae_lines_gt xalg
5655: WHERE xalg.balance_type_code <> 'X'
5656: AND (xalg.code_combination_status_code <> C_CREATED
5657: OR xalg.code_combination_id = -1) and (nvl(xalg.gain_or_loss_flag,'N') = 'N' or nvl(xalg.calculate_g_l_amts_flag,'N') = 'N')*/
5658: /*

Line 5674: FROM xla_ae_lines_gt xalg

5670: UPDATE xla_ae_headers_gt xahg
5671: SET xahg.accounting_entry_status_code = xla_ae_journal_entry_pkg.C_INVALID
5672: WHERE (xahg.ae_header_id , NVL(xahg.header_num,0) , xahg.balance_type_code , xahg.ledger_id ) IN (
5673: SELECT xalg.ae_header_id , NVL(xalg.header_num, 0) , xalg.balance_type_code , xalg.ledger_id
5674: FROM xla_ae_lines_gt xalg
5675: WHERE xalg.balance_type_code <> 'X'
5676: AND (xalg.code_combination_status_code <> C_CREATED
5677: OR xalg.code_combination_id = -1) and (nvl(xalg.gain_or_loss_flag,'N') = 'N' or nvl (xalg.calculate_g_l_amts_flag,'N') = 'N')
5678: )