APPS.XLA_JOURNAL_ENTRIES_PKG dependencies on XLA_AE_SEGMENT_VALUES

Line 1330: DELETE FROM xla_ae_segment_values

1326:
1327: IF (l_entry.ae_header_id IS NOT NULL) THEN
1328:
1329: FORALL k in 1..j
1330: DELETE FROM xla_ae_segment_values
1331: WHERE ae_header_id = l_ae_header_ids(k);
1332:
1333: FOR k in 1..j LOOP
1334: IF (NOT xla_analytical_criteria_pkg.single_update_detail_value

Line 5918: DELETE FROM xla_ae_segment_values

5914: WHERE ae_header_id = l_header_ids(j)
5915: AND application_id = p_application_id;
5916:
5917: FORALL j in 1..i
5918: DELETE FROM xla_ae_segment_values
5919: WHERE ae_header_id = l_header_ids(j);
5920:
5921: FORALL j in 1..i
5922: DELETE FROM xla_ae_lines

Line 6884: FROM xla_ae_segment_values

6880: ,p_action IN VARCHAR2)
6881: IS
6882: CURSOR c_seg IS
6883: SELECT ae_lines_count
6884: FROM xla_ae_segment_values
6885: WHERE segment_type_code = p_seg_type
6886: AND ae_header_id = p_ae_header_id
6887: AND segment_value = p_seg_value;
6888:

Line 6908: DELETE xla_ae_segment_values

6904: CLOSE c_seg;
6905:
6906: IF (p_action = C_ACTION_DEL) THEN
6907: IF (l_seg_count = 1) THEN
6908: DELETE xla_ae_segment_values
6909: WHERE ae_header_id = p_ae_header_id
6910: AND segment_type_code = p_seg_type
6911: AND segment_value = p_seg_value;
6912: ELSE

Line 6913: UPDATE xla_ae_segment_values

6909: WHERE ae_header_id = p_ae_header_id
6910: AND segment_type_code = p_seg_type
6911: AND segment_value = p_seg_value;
6912: ELSE
6913: UPDATE xla_ae_segment_values
6914: SET ae_lines_count = ae_lines_count - 1
6915: WHERE ae_header_id = p_ae_header_id
6916: AND segment_type_code = p_seg_type
6917: AND segment_value = p_seg_value;

Line 6922: INSERT INTO xla_ae_segment_values(ae_header_id, segment_type_code, segment_value, ae_lines_count)

6918: END IF;
6919:
6920: ELSIF(p_action = C_ACTION_ADD) THEN
6921: IF (l_seg_count IS NULL) THEN
6922: INSERT INTO xla_ae_segment_values(ae_header_id, segment_type_code, segment_value, ae_lines_count)
6923: VALUES(p_ae_header_id, p_seg_type, p_seg_value, 1);
6924: ELSE
6925: UPDATE xla_ae_segment_values
6926: SET ae_lines_count = ae_lines_count + 1

Line 6925: UPDATE xla_ae_segment_values

6921: IF (l_seg_count IS NULL) THEN
6922: INSERT INTO xla_ae_segment_values(ae_header_id, segment_type_code, segment_value, ae_lines_count)
6923: VALUES(p_ae_header_id, p_seg_type, p_seg_value, 1);
6924: ELSE
6925: UPDATE xla_ae_segment_values
6926: SET ae_lines_count = ae_lines_count + 1
6927: WHERE ae_header_id = p_ae_header_id
6928: AND segment_type_code = p_seg_type
6929: AND segment_value = p_seg_value;