DBA Data[Home] [Help]

APPS.XLA_THIRD_PARTY_MERGE dependencies on XLA_AE_LINES_GT

Line 1110: from xla_ae_lines_gt;

1106:
1107: CURSOR csr_set_linenum is
1108: select rowid, dense_rank() over (partition by ae_header_id
1109: order by line_hash_num, merge_index) ae_line_num
1110: from xla_ae_lines_gt;
1111:
1112: CURSOR csr_rounding_lines is
1113: SELECT max(xalg.rowid)
1114: ,rounding_class_code

Line 1123: FROM xla_ae_lines_gt xalg

1119: ,ae_header_id
1120: ,NVL(SUM(unrounded_entered_cr), 0)
1121: - NVL(SUM(unrounded_entered_dr), 0) unrounded_entered_amount
1122: ,entered_currency_mau
1123: FROM xla_ae_lines_gt xalg
1124: WHERE temp_line_num <> 0
1125: GROUP BY ledger_id, event_id, ae_header_id,
1126: rounding_class_code, document_rounding_level, ae_line_num
1127: ,entered_currency_mau

Line 1153: UPDATE xla_ae_lines_gt ael

1149: END LOOP;
1150:
1151: BEGIN
1152:
1153: UPDATE xla_ae_lines_gt ael
1154: set line_hash_num =
1155: DBMS_UTILITY.GET_HASH_VALUE
1156: (ae_header_id
1157: ||accounting_class_code

Line 1208: UPDATE xla_ae_lines_gt

1204: EXIT;
1205: END IF;
1206:
1207: FORALL i IN 1..l_array_rowid.count
1208: UPDATE xla_ae_lines_gt
1209: SET ae_line_num = l_array_ae_line_num(i)
1210: WHERE rowid = l_array_rowid(i);
1211: END LOOP;
1212: Close csr_set_linenum;

Line 1217: (p_msg => 'SQL - Update xla_ae_lines_gt 3'

1213:
1214: IF (C_LEVEL_STATEMENT >= g_log_level) THEN
1215:
1216: trace
1217: (p_msg => 'SQL - Update xla_ae_lines_gt 3'
1218: ,p_level => C_LEVEL_STATEMENT
1219: ,p_module => l_log_module);
1220:
1221: END IF;

Line 1257: (p_msg => 'SQL - Update xla_ae_lines_gt 6'

1253: EXIT;
1254: END IF;
1255: IF (C_LEVEL_STATEMENT >= g_log_level) THEN
1256: trace
1257: (p_msg => 'SQL - Update xla_ae_lines_gt 6'
1258: ,p_level => C_LEVEL_STATEMENT
1259: ,p_module => l_log_module);
1260: trace
1261: (p_msg => 'count:'||to_char(l_array_rounding_class_code.count)

Line 1360: update xla_ae_lines_gt

1356: l_array_rounding_entd_amt1(j) := l_curr_entd_rounding_amount;
1357: j:= j+1;
1358: IF (j> C_BULK_LIMIT) THEN
1359: FORALL i in 1..j-1
1360: update xla_ae_lines_gt
1361: set doc_rounding_acctd_amt = l_array_doc_rounding_amt1(i)
1362: ,doc_rounding_entered_amt = l_array_rounding_entd_amt1(i)
1363: where rowid = l_array_rowid1(i);
1364: j:=1;

Line 1459: (p_msg => 'SQL - Update xla_ae_lines_gt 7, j='||to_char(j)

1455: END IF;
1456:
1457: IF (C_LEVEL_STATEMENT >= g_log_level) THEN
1458: trace
1459: (p_msg => 'SQL - Update xla_ae_lines_gt 7, j='||to_char(j)
1460: ,p_level => C_LEVEL_STATEMENT
1461: ,p_module => l_log_module);
1462: END IF;
1463:

Line 1466: update xla_ae_lines_gt

1462: END IF;
1463:
1464: IF j>1 THEN
1465: FORALL i in 1..j-1
1466: update xla_ae_lines_gt
1467: set doc_rounding_acctd_amt = l_array_doc_rounding_amt1(i)
1468: ,doc_rounding_entered_amt = l_array_rounding_entd_amt1(i)
1469: where rowid = l_array_rowid1(i);
1470: END IF;

Line 1715: FROM xla_ae_lines_gt;

1711: , rounding_class_code
1712: , document_rounding_level
1713: , doc_rounding_acctd_amt
1714: , doc_rounding_entered_amt
1715: FROM xla_ae_lines_gt;
1716:
1717: IF (C_LEVEL_PROCEDURE >= g_log_level)
1718: THEN
1719: trace( p_msg => 'END - ' || v_function

Line 2236: FROM xla_ae_lines_gt lin

2232: , accounting_date
2233: , ledger_id
2234: , alt_segment1
2235: , accounting_entry_status_code
2236: FROM xla_ae_lines_gt lin
2237: WHERE ledger_id = p_array_ledger_id(i)
2238: AND ae_line_num is not NULL
2239: GROUP BY lin.ae_header_id
2240: , ae_line_num

Line 2708: INSERT INTO xla_ae_lines_gt

2704: , p_module => v_module);
2705: END IF;
2706:
2707: FORALL i in 1..p_array_ledger_id.count
2708: INSERT INTO xla_ae_lines_gt
2709: (ae_header_id
2710: ,temp_line_num
2711: ,event_id
2712: ,ref_ae_header_id

Line 2874: INSERT INTO xla_ae_lines_gt

2870: END IF;
2871:
2872:
2873: FORALL i in 1..p_array_ledger_id.count
2874: INSERT INTO xla_ae_lines_gt
2875: (ae_header_id
2876: ,temp_line_num
2877: ,event_id
2878: ,ref_ae_header_id

Line 3099: (select ledger_id from xla_ae_lines_gt);

3095: ,'Other'
3096: from dual
3097: where p_array_merge_option(i) = 'TRANSFER'
3098: AND p_array_ledger_id(i) in
3099: (select ledger_id from xla_ae_lines_gt);
3100:
3101: IF (C_LEVEL_STATEMENT>= g_log_level)
3102: THEN
3103: trace( p_msg => 'Header inserted'

Line 3108: UPDATE xla_ae_lines_gt xal

3104: , p_level => C_LEVEL_STATEMENT
3105: , p_module => v_module);
3106: END IF;
3107:
3108: UPDATE xla_ae_lines_gt xal
3109: set (ae_header_id, accounting_date) =(
3110: select ae_header_id, accounting_date
3111: from xla_ae_headers_gt xah
3112: where xah.ledger_id = xal.ledger_id);

Line 3182: INSERT INTO xla_ae_lines_gt

3178: , p_module => v_module);
3179: END IF;
3180:
3181: FORALL i in 1..p_array_ledger_id.count
3182: INSERT INTO xla_ae_lines_gt
3183: (ae_header_id
3184: ,temp_line_num
3185: ,event_id
3186: ,ref_ae_header_id

Line 3367: INSERT INTO xla_ae_lines_gt

3363: return 0;
3364: END IF;
3365:
3366: FORALL i in 1..p_array_ledger_id.count
3367: INSERT INTO xla_ae_lines_gt
3368: (ae_header_id
3369: ,temp_line_num
3370: ,event_id
3371: ,ref_ae_header_id

Line 3742: from xla_ae_lines_gt xalg

3738: IF(p_accounting_mode <> 'D') THEN
3739: UPDATE xla_ae_lines xal
3740: SET (merge_party_id, merge_party_site_id, merge_code_combination_id)
3741: = (select party_id, party_site_id, code_combination_id
3742: from xla_ae_lines_gt xalg
3743: where xalg.ref_ae_header_id = xal.ae_header_id
3744: AND xalg.ref_ae_line_num = xal.ae_line_num
3745: AND xalg.reversal_code in ('REBOOKING', 'TRANSFER_BALANCE')
3746: and rownum = 1)

Line 3750: from xla_ae_lines_gt xlg

3746: and rownum = 1)
3747: WHERE xal.application_id = p_application_id
3748: AND (ae_header_id, ae_line_num) in
3749: (select xlg.ref_ae_header_id, xlg.ref_ae_line_num
3750: from xla_ae_lines_gt xlg
3751: ,xla_ae_headers xah
3752: where xlg.reversal_code in ('REBOOKING', 'TRANSFER_BALANCE')
3753: -- Bug 5103972 MPA / Reversal of incomplete JE
3754: -- should not be stamped with merge party informtion

Line 4265: from xla_ae_lines_gt

4261: v_function VARCHAR2(240);
4262: v_module VARCHAR2(240);
4263: cursor c_null_ccid is
4264: select 1
4265: from xla_ae_lines_gt
4266: where code_combination_id is null;
4267: v_temp NUMBER;
4268: begin
4269: v_function := 'xla_third_party_merge.populate_ccid_to_gt';

Line 4280: update xla_ae_lines_gt xalg

4276: , p_level => C_LEVEL_PROCEDURE
4277: , p_module => v_module);
4278: END IF; -- IF (C_LEVEL_PROCEDURE >= g_log_level)
4279:
4280: update xla_ae_lines_gt xalg
4281: set code_combination_id =
4282: (select code_combination_id
4283: from gl_code_combinations gcc
4284: where gcc.chart_of_accounts_id = xalg.ccid_coa_id

Line 4325: update xla_ae_lines_gt temp

4321: , p_level => C_LEVEL_STATEMENT
4322: , p_module => v_module);
4323: END IF;
4324:
4325: update xla_ae_lines_gt temp
4326: SET code_combination_id =
4327: xla_ae_code_combination_pkg.GetCcid(
4328: temp.segment1
4329: ,temp.segment2

Line 4399: from xla_ae_lines_gt

4395: v_function VARCHAR2(240);
4396: v_module VARCHAR2(240);
4397: cursor c_null_ccid is
4398: select 1
4399: from xla_ae_lines_gt
4400: where code_combination_id is null;
4401: v_temp NUMBER;
4402: begin
4403: v_function := 'xla_third_party_merge.process_accounting_mapping';

Line 4414: update xla_ae_lines_gt xalg

4410: , p_level => C_LEVEL_PROCEDURE
4411: , p_module => v_module);
4412: END IF; -- IF (C_LEVEL_PROCEDURE >= g_log_level)
4413:
4414: update xla_ae_lines_gt xalg
4415: set ( code_combination_id
4416: ,ccid_coa_id
4417: ,segment1
4418: ,segment2

Line 4596: -- private procedure, populate xla_ae_lines_gt table

4592:
4593: END process_accounting_mapping;
4594:
4595:
4596: -- private procedure, populate xla_ae_lines_gt table
4597: -- for the purpose of account mapping
4598: FUNCTION populate_gt_for_mapping(
4599: p_application_id IN NUMBER
4600: ,p_event_id IN NUMBER

Line 4631: INSERT INTO xla_ae_lines_gt (

4627:
4628:
4629: IF(p_merge_type = 'PARTIAL_MERGE') THEN
4630: FORALL i IN 1..p_array_ledger_id.count
4631: INSERT INTO xla_ae_lines_gt (
4632: ae_header_id
4633: ,ae_line_num
4634: ,temp_line_num
4635: ,inherit_desc_flag

Line 4781: INSERT INTO xla_ae_lines_gt (

4777: END IF;
4778: ELSE
4779:
4780: FORALL i IN 1..p_array_ledger_id.count
4781: INSERT INTO xla_ae_lines_gt (
4782: ae_header_id
4783: ,ae_line_num
4784: ,temp_line_num
4785: ,inherit_desc_flag

Line 4952: from xla_ae_lines_gt

4948: v_function VARCHAR2(240);
4949: v_module VARCHAR2(240);
4950: cursor c_null_ccid is
4951: select 1
4952: from xla_ae_lines_gt
4953: where code_combination_id is null;
4954: v_row_count NUMBER;
4955: begin
4956: v_function := 'xla_third_party_merge.process_incomplete_acct_map';

Line 5007: FROM xla_ae_lines_gt xalg

5003:
5004: UPDATE
5005: (SELECT xalg.code_combination_id
5006: , xal.code_combination_id code_combination_id1
5007: FROM xla_ae_lines_gt xalg
5008: , xla_ae_lines xal
5009: WHERE xalg.ae_header_id = xal.ae_header_id
5010: AND xalg.ae_line_num = xal.ae_line_num
5011: AND xal.application_id = p_application_id

Line 5076: -- to be stamped on xla_ae_lines_gt

5072: , amb_context_code
5073: , budget_version_id
5074: -- 5103972
5075: -- Used at the end of this procedure to find ae header ids
5076: -- to be stamped on xla_ae_lines_gt
5077: , parent_header_id
5078: )
5079: (select xla_ae_headers_s.nextval
5080: ,p_accounting_mode

Line 5108: ,xla_ae_lines_gt xal

5104: , xah.balance_type_code
5105: , xal.ae_header_id
5106: , xal.ref_ae_header_id -- 5103972
5107: from xla_ae_headers xah
5108: ,xla_ae_lines_gt xal
5109: where xah.application_id = p_application_id
5110: and xah.ae_header_id =xal.ref_ae_header_id
5111: and xal.reversal_code = 'REBOOKING'));
5112:

Line 5151: UPDATE xla_ae_lines_gt xal

5147: , p_level => C_LEVEL_STATEMENT
5148: , p_module => v_module);
5149: END IF;
5150:
5151: UPDATE xla_ae_lines_gt xal
5152: SET (ae_header_id, accounting_date) =
5153: (SELECT ae_header_id, accounting_date
5154: FROM xla_ae_headers_gt xah
5155: WHERE xal.event_id = xah.event_id