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 2545: FROM xla_ae_lines_gt temp,

2541: hdr.event_id event_id,
2542: hdr.entity_id entity_id,
2543: hdr.ledger_id ledger_id,
2544: hdr.ae_header_id ae_header_id
2545: FROM xla_ae_lines_gt temp,
2546: xla_ae_headers_gt hdr
2547: WHERE temp.ae_header_id = hdr.ae_header_id
2548: AND temp.ccid_coa_id = p_chart_of_accounts_id
2549: AND nvl(temp.segment1 ,'#') = nvl(p_segment1,'#')

Line 2704: FROM xla_ae_lines_gt temp

2700: temp.segment28 segment28,
2701: temp.segment29 segment29,
2702: temp.segment30 segment30,
2703: temp.ccid_coa_id coa_id
2704: FROM xla_ae_lines_gt temp
2705: WHERE temp.code_combination_id = -1
2706: AND temp.code_combination_status_code = C_CREATED
2707: AND temp.balance_type_code <> 'X'
2708: )

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

3132: l_rowcount := 0;
3133:
3134: IF (C_LEVEL_STATEMENT >= g_log_level) THEN
3135: trace
3136: (p_msg => 'Validate the accounting ccids: SQL - Update xla_ae_lines_gt '
3137: ,p_level => C_LEVEL_STATEMENT
3138: ,p_module => l_log_module);
3139: END IF;
3140:

Line 3141: UPDATE xla_ae_lines_gt temp

3137: ,p_level => C_LEVEL_STATEMENT
3138: ,p_module => l_log_module);
3139: END IF;
3140:
3141: UPDATE xla_ae_lines_gt temp
3142: SET code_combination_status_code =
3143: CASE
3144: WHEN temp.code_combination_id IS NOT NULL
3145: AND temp.code_combination_status_code = C_NOT_PROCESSED

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

3197: l_count:= l_count + l_rowcount;
3198:
3199: IF (C_LEVEL_STATEMENT >= g_log_level) THEN
3200: trace
3201: (p_msg => '# rows Updated in xla_ae_lines_gt (ccid + ALT ccid) ='||l_rowcount
3202: ,p_level => C_LEVEL_STATEMENT
3203: ,p_module => l_log_module);
3204: END IF;
3205:

Line 3226: FROM xla_ae_lines_gt lns,

3222: hdr.entity_id entity_id,
3223: hdr.ledger_id ledger_id,
3224: hdr.ae_header_id ae_header_id,
3225: lns.code_combination_id ccid
3226: FROM xla_ae_lines_gt lns,
3227: xla_ae_headers_gt hdr
3228: WHERE lns.ae_header_id = hdr.ae_header_id
3229: AND lns.code_combination_id <> -1
3230: AND lns.code_combination_status_code = C_INVALID

Line 3244: FROM xla_ae_lines_gt lns,

3240: hdr.entity_id entity_id,
3241: hdr.ledger_id ledger_id,
3242: hdr.ae_header_id ae_header_id,
3243: lns.alt_code_combination_id ccid
3244: FROM xla_ae_lines_gt lns,
3245: xla_ae_headers_gt hdr
3246: WHERE lns.ae_header_id = hdr.ae_header_id
3247: AND lns.alt_code_combination_id <> -1
3248: AND lns.alt_ccid_status_code = C_INVALID

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

3335: l_rowcount := 0;
3336:
3337: IF (C_LEVEL_STATEMENT >= g_log_level) THEN
3338: trace
3339: (p_msg => 'Override the accounting ccid: SQL - Update xla_ae_lines_gt '
3340: ,p_level => C_LEVEL_STATEMENT
3341: ,p_module => l_log_module);
3342: END IF;
3343:

Line 3344: UPDATE xla_ae_lines_gt temp

3340: ,p_level => C_LEVEL_STATEMENT
3341: ,p_module => l_log_module);
3342: END IF;
3343:
3344: UPDATE xla_ae_lines_gt temp
3345: SET
3346: ( segment1
3347: , segment2
3348: , segment3

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

3428: ,p_level => C_LEVEL_STATEMENT
3429: ,p_module => l_log_module);
3430:
3431: trace
3432: (p_msg => 'Override the accounting ALT ccid: SQL - Update xla_ae_lines_gt '
3433: ,p_level => C_LEVEL_STATEMENT
3434: ,p_module => l_log_module);
3435:
3436: END IF;

Line 3439: UPDATE xla_ae_lines_gt temp

3435:
3436: END IF;
3437:
3438:
3439: UPDATE xla_ae_lines_gt temp
3440: SET
3441: ( alt_segment1
3442: , alt_segment2
3443: , alt_segment3

Line 3724: l_upd_stmt := 'UPDATE xla_ae_lines_gt temp

3720: END IF;
3721: --
3722: END LOOP;
3723:
3724: l_upd_stmt := 'UPDATE xla_ae_lines_gt temp
3725: SET code_combination_id =
3726: CASE
3727: WHEN temp.ccid_coa_id = :1
3728: AND temp.code_combination_status_code = :2

Line 3908: UPDATE xla_ae_lines_gt temp

3904: l_rowcount := 0;
3905: l_count := 0;
3906: g_error_exists := FALSE;
3907:
3908: UPDATE xla_ae_lines_gt temp
3909: SET code_combination_id =
3910: CASE
3911: WHEN temp.code_combination_id IS NULL
3912: AND temp.balance_type_code <> 'X'

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

4182:
4183: --
4184: -- get transaction ccid
4185: --
4186: UPDATE /*+ dynamic_sampling(1) */ xla_ae_lines_gt temp
4187: SET ( temp.code_combination_id
4188: ,temp.segment1
4189: ,temp.segment2
4190: ,temp.segment3

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

4289: l_count := l_count + l_rowcount;
4290:
4291: IF (C_LEVEL_STATEMENT >= g_log_level) THEN
4292: trace
4293: (p_msg => '# of rows updated into xla_ae_lines_gt(ccid) = '||to_char(l_rowcount)
4294: ,p_level => C_LEVEL_STATEMENT
4295: ,p_module => l_log_module);
4296:
4297: END IF;

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

4296:
4297: END IF;
4298:
4299:
4300: UPDATE /*+ dynamic_sampling(1) */ xla_ae_lines_gt temp
4301: SET ( temp.alt_code_combination_id
4302: ,temp.alt_segment1
4303: ,temp.alt_segment2
4304: ,temp.alt_segment3

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

4403: l_count := l_count + l_rowcount;
4404:
4405: IF (C_LEVEL_STATEMENT >= g_log_level) THEN
4406: trace
4407: (p_msg => '# of rows updated into xla_ae_lines_gt(ALT ccid) = '||to_char(l_rowcount)
4408: ,p_level => C_LEVEL_STATEMENT
4409: ,p_module => l_log_module);
4410:
4411: END IF;

Line 4578: UPDATE xla_ae_lines_gt temp

4574: IF l_array_header_id.COUNT > 0 THEN
4575:
4576: FORALL i IN l_array_header_id.FIRST .. l_array_header_id.LAST
4577:
4578: UPDATE xla_ae_lines_gt temp
4579: SET ( temp.code_combination_id
4580: ,temp.segment1
4581: ,temp.segment2
4582: ,temp.segment3

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

4683: l_count := l_count + l_rowcount;
4684:
4685: IF (C_LEVEL_STATEMENT >= g_log_level) THEN
4686: trace
4687: (p_msg => '# of rows updated into xla_ae_lines_gt(ccid) = '||to_char(l_rowcount)
4688: ,p_level => C_LEVEL_STATEMENT
4689: ,p_module => l_log_module);
4690:
4691: END IF;

Line 4762: UPDATE xla_ae_lines_gt temp

4758: IF l_array_alt_header_id.COUNT > 0 THEN
4759:
4760: FORALL i IN l_array_alt_header_id.FIRST .. l_array_alt_header_id.LAST
4761:
4762: UPDATE xla_ae_lines_gt temp
4763: SET ( temp.alt_code_combination_id
4764: ,temp.alt_segment1
4765: ,temp.alt_segment2
4766: ,temp.alt_segment3

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

4867: l_count := l_count + l_rowcount;
4868:
4869: IF (C_LEVEL_STATEMENT >= g_log_level) THEN
4870: trace
4871: (p_msg => '# of rows updated into xla_ae_lines_gt(ALT ccid) = '||to_char(l_rowcount)
4872: ,p_level => C_LEVEL_STATEMENT
4873: ,p_module => l_log_module);
4874:
4875: END IF;

Line 4898: ,xla_ae_lines_gt xjlg

4894: ,xahg.entity_id entity_id
4895: ,gami.from_ccid from_ccid
4896: ,xjlg.ccid_coa_id ccid_coa_id
4897: FROM gl_accts_map_int_gt gami
4898: ,xla_ae_lines_gt xjlg
4899: ,xla_ae_headers_gt xahg
4900: ,xla_transaction_accts_gt xtag
4901: WHERE xjlg.ae_header_id = xahg.ae_header_id
4902: AND xjlg.event_id = xahg.event_id

Line 4924: ,xla_ae_lines_gt xjlg

4920: ,xahg.entity_id entity_id
4921: ,gami.from_ccid from_ccid
4922: , xjlg.ccid_coa_id coa_id
4923: FROM gl_accts_map_int_gt gami
4924: ,xla_ae_lines_gt xjlg
4925: ,xla_ae_headers_gt xahg
4926: ,xla_transaction_accts_gt xtag
4927: WHERE xjlg.ae_header_id = xahg.ae_header_id
4928: AND xjlg.event_id = xahg.event_id

Line 5126: -- update xla_ae_lines_gt

5122: l_gl_error_code:='GL_BSV_MAP_MAPPING_ERROR';
5123: l_error :=TRUE;
5124: END;
5125:
5126: -- update xla_ae_lines_gt
5127:
5128: IF l_error THEN
5129:
5130: UPDATE xla_ae_lines_gt temp

Line 5130: UPDATE xla_ae_lines_gt temp

5126: -- update xla_ae_lines_gt
5127:
5128: IF l_error THEN
5129:
5130: UPDATE xla_ae_lines_gt temp
5131: SET temp.code_combination_id = -1
5132: ,temp.code_combination_status_code = C_INVALID
5133: WHERE temp.balance_type_code <> 'X'
5134: AND EXISTS (SELECT 'x'

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

5149: l_rowcount:= SQL%ROWCOUNT;
5150:
5151: IF (C_LEVEL_STATEMENT >= g_log_level) THEN
5152: trace
5153: (p_msg => '# of rows updated into xla_ae_lines_gt(error) = '||to_char(l_rowcount)
5154: ,p_level => C_LEVEL_STATEMENT
5155: ,p_module => l_log_module);
5156:
5157: END IF;

Line 5195: UPDATE xla_ae_lines_gt temp

5191: l_array_entity_id.DELETE ;
5192: l_array_event_id.DELETE;
5193: l_array_ledger_id.DELETE;
5194:
5195: UPDATE xla_ae_lines_gt temp
5196: SET temp.alt_code_combination_id = -1
5197: ,temp.alt_ccid_status_code = C_INVALID
5198: WHERE temp.balance_type_code <> 'X'
5199: AND EXISTS (SELECT 'x'

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

5215: l_count := l_count + l_rowcount;
5216:
5217: IF (C_LEVEL_STATEMENT >= g_log_level) THEN
5218: trace
5219: (p_msg => '# of rows updated into xla_ae_lines_gt(error) = '||to_char(l_rowcount)
5220: ,p_level => C_LEVEL_STATEMENT
5221: ,p_module => l_log_module);
5222:
5223: END IF;

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

5247:
5248:
5249: ELSE
5250: -- no error
5251: -- copy converted qualifier value in the xla_ae_lines_gt table
5252:
5253: UPDATE xla_ae_lines_gt temp
5254: SET ( temp.segment1
5255: ,temp.segment2

Line 5253: UPDATE xla_ae_lines_gt temp

5249: ELSE
5250: -- no error
5251: -- copy converted qualifier value in the xla_ae_lines_gt table
5252:
5253: UPDATE xla_ae_lines_gt temp
5254: SET ( temp.segment1
5255: ,temp.segment2
5256: ,temp.segment3
5257: ,temp.segment4

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

5355:
5356: l_rowcount:= SQL%ROWCOUNT;
5357: IF (C_LEVEL_STATEMENT >= g_log_level) THEN
5358: trace
5359: (p_msg => '# of rows updated into xla_ae_lines_gt(ccid) = '||to_char(l_rowcount)
5360: ,p_level => C_LEVEL_STATEMENT
5361: ,p_module => l_log_module);
5362: END IF;
5363: l_count := l_count + l_rowcount;

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

5360: ,p_level => C_LEVEL_STATEMENT
5361: ,p_module => l_log_module);
5362: END IF;
5363: l_count := l_count + l_rowcount;
5364: --end insert into xla_ae_lines_gt(ccid)
5365:
5366:
5367: UPDATE xla_ae_lines_gt temp
5368: SET ( temp.alt_segment1

Line 5367: UPDATE xla_ae_lines_gt temp

5363: l_count := l_count + l_rowcount;
5364: --end insert into xla_ae_lines_gt(ccid)
5365:
5366:
5367: UPDATE xla_ae_lines_gt temp
5368: SET ( temp.alt_segment1
5369: ,temp.alt_segment2
5370: ,temp.alt_segment3
5371: ,temp.alt_segment4

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

5469:
5470: l_rowcount:= SQL%ROWCOUNT;
5471: IF (C_LEVEL_STATEMENT >= g_log_level) THEN
5472: trace
5473: (p_msg => '# of rows updated into xla_ae_lines_gt(ALT ccid) = '||to_char(l_rowcount)
5474: ,p_level => C_LEVEL_STATEMENT
5475: ,p_module => l_log_module);
5476: END IF;
5477: l_count := l_count + l_rowcount;

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

5474: ,p_level => C_LEVEL_STATEMENT
5475: ,p_module => l_log_module);
5476: END IF;
5477: l_count := l_count + l_rowcount;
5478: --end insert into xla_ae_lines_gt(ccid)
5479:
5480: END IF;
5481:
5482: END LOOP; --end loop qualifiers

Line 5631: FROM xla_ae_lines_gt xalg

5627:
5628: UPDATE xla_ae_headers_gt xahg
5629: SET xahg.accounting_entry_status_code = xla_ae_journal_entry_pkg.C_INVALID
5630: WHERE xahg.ae_header_id IN (SELECT xalg.ae_header_id
5631: FROM xla_ae_lines_gt xalg
5632: WHERE xalg.balance_type_code <> 'X'
5633: AND (xalg.code_combination_status_code <> C_CREATED
5634: 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')
5635: /*