[Home] [Help]
1059: SET event_date = p_gl_date
1060: WHERE application_id = p_application_id
1061: AND event_id = l_info.event_id;
1062:
1063: UPDATE xla_ae_lines
1064: SET accounting_date = p_gl_date
1065: WHERE application_id = p_application_id
1066: AND ae_header_id = p_ae_header_id;
1067: END IF;
1380: DELETE FROM xla_ae_header_acs
1381: WHERE ae_header_id = l_ae_header_ids(k);
1382:
1383: FORALL k in 1..j
1384: DELETE FROM xla_ae_lines
1385: WHERE application_id = p_application_id
1386: AND ae_header_id = l_ae_header_ids(k);
1387:
1388: FORALL k in 1..j
1493: l_unrounded_accted_dr NUMBER;
1494: l_unrounded_accted_cr NUMBER;
1495:
1496: CURSOR c IS SELECT max(ae_line_num)+1
1497: FROM xla_ae_lines
1498: WHERE application_id = p_application_id
1499: AND ae_header_id = p_ae_header_id;
1500:
1501: l_rounding_rule_code VARCHAR2(30);
1624:
1625: --
1626: -- Create journal entry line
1627: --
1628: INSERT INTO xla_ae_lines
1629: (ae_header_id
1630: ,displayed_line_number
1631: ,ae_line_num
1632: ,code_combination_id
1869: l_encumbrance_type_id INTEGER;
1870:
1871: CURSOR c_line IS
1872: SELECT code_combination_id
1873: FROM xla_ae_lines
1874: WHERE application_id = p_application_id
1875: AND ae_header_id = p_ae_header_id
1876: AND ae_line_num = p_ae_line_num;
1877:
2012:
2013: --
2014: -- Update journal entry line with modified information
2015: --
2016: UPDATE xla_ae_lines
2017: SET code_combination_id = p_code_combination_id
2018: ,displayed_line_number = p_displayed_line_number
2019: ,gl_transfer_mode_code = l_gl_transfer_mode
2020: ,party_id = p_party_id
2194: ,p_ae_header_id => p_ae_header_id
2195: ,p_ref_ae_header_id => p_ae_header_id
2196: ,p_temp_line_num => p_ae_line_num);
2197:
2198: DELETE xla_ae_lines
2199: WHERE ae_header_id = p_ae_header_id
2200: AND ae_line_num = p_ae_line_num
2201: AND application_id = p_application_id;
2202:
2375: l_ledger_ids(1) := l_info.ledger_id;
2376: l_ae_header_ids(1) := p_ae_header_id;
2377:
2378: IF (l_orig_status_code = C_AE_STATUS_INVALID) THEN
2379: DELETE FROM xla_ae_lines
2380: WHERE application_id = p_application_id
2381: AND ae_header_id = p_ae_header_id
2382: AND accounting_class_code IN ('ROUNDING', 'BALANCE', 'INTRA', 'INTER');
2383:
2670:
2671:
2672:
2673: FORALL i IN 1 .. l_ae_header_ids.COUNT
2674: UPDATE xla_ae_lines
2675: SET gl_sl_link_id = XLA_GL_SL_LINK_ID_S.nextval
2676: ,last_update_date = p_last_update_date
2677: ,last_updated_by = p_last_updated_by
2678: ,last_update_login = p_last_update_login
2705:
2706:
2707: IF (l_bal_update_mode IS NOT NULL) THEN
2708: --FORALL i IN 1 .. l_ae_header_ids.COUNT
2709: UPDATE xla_ae_lines l
2710: SET control_balance_flag =
2711: (SELECT DECODE(l.accounting_class_code,
2712: 'INTER', NULL,
2713: 'INTRA', NULL,
3545: ,p_msg_mode IN VARCHAR2 DEFAULT xla_exceptions_pkg.C_STANDARD_MESSAGE)
3546: IS
3547: CURSOR c IS
3548: SELECT ae_line_num
3549: FROM xla_ae_lines
3550: WHERE ae_header_id = p_header_id
3551: AND ae_line_num = p_line_num
3552: AND application_id = p_application_id;
3553:
3618: ,p_msg_mode IN VARCHAR2 DEFAULT xla_exceptions_pkg.C_STANDARD_MESSAGE)
3619: IS
3620: CURSOR c IS
3621: SELECT ae_line_num
3622: FROM xla_ae_lines
3623: WHERE ae_header_id = p_header_id
3624: AND ae_line_num <> nvl(p_line_num,-1)
3625: AND displayed_line_number = p_display_line_num
3626: AND application_id = p_application_id;
3699: RETURN INTEGER
3700: IS
3701: CURSOR c_line IS
3702: SELECT ae_line_num, accounting_class_code, gl_transfer_mode_code
3703: FROM xla_ae_lines
3704: WHERE ae_header_id = p_ae_header_id
3705: AND application_id = p_application_id;
3706:
3707: l_retcode INTEGER := 0;
4332:
4333: --
4334: -- Create journal entry lines for the reversal journal entry
4335: --
4336: INSERT INTO xla_ae_lines
4337: (application_id
4338: ,ae_header_id
4339: ,ae_line_num
4340: ,displayed_line_number
4450: ,NVL(mpa_accrual_entry_flag,'N')
4451: ,decode(analytical_balance_flag, 'Y', 'P'
4452: , 'P' , 'P'
4453: , null) analytical_balance_flag
4454: FROM xla_ae_lines
4455: WHERE application_id = p_info.application_id
4456: AND ae_header_id = l_mrc_header.ae_header_id;
4457:
4458: create_reversal_distr_link
4723:
4724: --
4725: -- Create journal entry lines for the reversal journal entry
4726: --
4727: INSERT INTO xla_ae_lines
4728: (application_id
4729: ,ae_header_id
4730: ,ae_line_num
4731: ,displayed_line_number
4838: ,gain_or_loss_flag
4839: ,p_info.ledger_id
4840: ,p_gl_date
4841: ,NVL(mpa_accrual_entry_flag,'N') -- 4262811 mpa_accrual_entry_flag
4842: FROM xla_ae_lines
4843: WHERE application_id = p_info.application_id
4844: AND ae_header_id = p_info.header_id;
4845:
4846:
4910: ,p_ae_header_id IN INTEGER)
4911: IS
4912: CURSOR c_lines IS
4913: SELECT ae_line_num
4914: FROM xla_ae_lines
4915: WHERE application_id = p_application_id
4916: AND ae_header_id = p_ae_header_id
4917: ORDER BY ae_line_num;
4918:
4957: p_level => C_LEVEL_EVENT);
4958: END IF;
4959:
4960: FORALL j in 1..i
4961: UPDATE xla_ae_lines
4962: set displayed_line_number = l_displayed_nums(j)
4963: WHERE application_id = p_application_id
4964: AND ae_header_id = p_ae_header_id
4965: AND ae_line_num = l_ae_line_nums(j);
5360: trunc(fc1.derive_effective)), -1, 'OTHER', 'EMU'), 'OTHER' ) to_type
5361: , decode( fc2.derive_type, 'EURO', 'EURO', 'EMU',
5362: decode( sign( trunc(nvl(xal.currency_conversion_date, xal.accounting_date)) -
5363: trunc(fc2.derive_effective)), -1, 'OTHER', 'EMU'), 'OTHER' ) primary_type
5364: FROM xla_ae_lines xal
5365: , fnd_currencies fc
5366: , fnd_currencies fc1
5367: , fnd_currencies fc2
5368: WHERE xal.ae_header_id = p_info.header_id
5808:
5809: --
5810: -- Create journal entry lines for the mrc entry
5811: --
5812: INSERT INTO xla_ae_lines
5813: (ae_header_id
5814: ,ae_line_num
5815: ,displayed_line_number
5816: ,application_id
6137: DELETE FROM xla_ae_segment_values
6138: WHERE ae_header_id = l_header_ids(j);
6139:
6140: FORALL j in 1..i
6141: DELETE FROM xla_ae_lines
6142: WHERE ae_header_id = l_header_ids(j)
6143: AND application_id = p_application_id;
6144:
6145: FORALL j in 1..i
6544: , nvl(sum(nvl(accounted_cr,0)),1)
6545: , nvl(sum(CASE WHEN accounted_dr IS NULL THEN 0 ELSE 1 end),0)
6546: , nvl(sum(CASE WHEN accounted_cr IS NULL THEN 0 ELSE 1 end),0)
6547: , nvl(sum(CASE WHEN currency_code = 'STAT' THEN 1 ELSE 0 end),0)
6548: FROM xla_ae_lines
6549: WHERE application_id = p_application_id
6550: AND ae_header_id = p_ae_header_id;
6551:
6552: l_total_acct_dr NUMBER := 0;
7412: ,accounted_cr
7413: ,currency_conversion_type conv_type
7414: ,currency_conversion_date conv_date
7415: ,currency_conversion_rate conv_rate
7416: FROM xla_ae_lines
7417: WHERE ae_header_id = p_ae_header_id
7418: AND application_id = p_application_id
7419: AND gain_or_loss_flag = 'N';
7420:
8092: -- check that lines exists
8093: -------------------------------------------
8094: SELECT count(*)
8095: INTO l_dummy
8096: FROM xla_ae_lines
8097: WHERE application_id = p_application_id
8098: AND ae_header_id = p_ae_header_id
8099: AND ae_line_num = p_ae_line_num;
8100:
8198: p_module => l_log_module,
8199: p_level => C_LEVEL_STATEMENT);
8200: END IF;
8201: IF p_item_name NOT IN (C_ITEM_HEADER_DESCRIPTION, C_ITEM_REFERENCE_DATE) THEN
8202: Update XLA_AE_LINES
8203: SET CODE_COMBINATION_ID = DECODE(p_item_name, C_ITEM_ACCOUNT, p_value_number, CODE_COMBINATION_ID)
8204: ,ACCOUNTED_DR = DECODE(p_item_name, C_ITEM_ACCOUNTED_DR, p_value_number, ACCOUNTED_DR)
8205: ,ACCOUNTED_CR = DECODE(p_item_name, C_ITEM_ACCOUNTED_CR, p_value_number, ACCOUNTED_CR)
8206: ,CURRENCY_CODE = DECODE(p_item_name, C_ITEM_CURRENCY_CODE, p_value_varchar2, CURRENCY_CODE)
8216: AND ae_header_id = p_ae_header_id
8217: AND ae_line_num = DECODE(p_item_name, C_ITEM_GL_DATE, ae_line_num, p_ae_line_num);
8218:
8219: --------------------------------------------------------------
8220: -- GL Date is stored in xla_ae_lines, need to audit all lines
8221: --------------------------------------------------------------
8222: IF p_item_name = 'GL_DATE' then
8223: xla_datafixes_pub.audit_datafix (p_application_id => p_application_id
8224: ,p_ae_header_id => p_ae_header_id);
8426: ,xal.unrounded_entered_cr
8427: ,xal.unrounded_accounted_dr
8428: ,xal.unrounded_accounted_cr
8429: FROM xla_ae_headers xah
8430: ,xla_ae_lines xal
8431: WHERE xah.application_id = p_application_id
8432: AND xah.ae_header_id = p_ae_header_id
8433: AND xal.application_id = xah.application_id
8434: AND xal.ae_header_id = xah.ae_header_id
8695: ,xal.unrounded_entered_cr
8696: ,xal.unrounded_accounted_dr
8697: ,xal.unrounded_accounted_cr
8698: FROM xla_ae_headers xah
8699: ,xla_ae_lines xal
8700: WHERE xah.application_id = p_application_id
8701: AND xah.ae_header_id = p_ae_header_id
8702: AND xal.application_id = xah.application_id
8703: AND xal.ae_header_id = xah.ae_header_id;