APPS.XLA_JOURNAL_ENTRIES_PKG dependencies on XLA_AE_SEGMENT_VALUES

Line 1350: DELETE FROM xla_ae_segment_values

1346:
1347: IF (l_entry.ae_header_id IS NOT NULL) THEN
1348:
1349: FORALL k in 1..j
1350: DELETE FROM xla_ae_segment_values
1351: WHERE ae_header_id = l_ae_header_ids(k);
1352:
1353: FOR k in 1..j LOOP
1354: IF (NOT xla_analytical_criteria_pkg.single_update_detail_value

Line 6137: DELETE FROM xla_ae_segment_values

6133: WHERE ae_header_id = l_header_ids(j)
6134: AND application_id = p_application_id;
6135:
6136: FORALL j in 1..i
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

Line 7104: FROM xla_ae_segment_values

7100: ,p_action IN VARCHAR2)
7101: IS
7102: CURSOR c_seg IS
7103: SELECT ae_lines_count
7104: FROM xla_ae_segment_values
7105: WHERE segment_type_code = p_seg_type
7106: AND ae_header_id = p_ae_header_id
7107: AND segment_value = p_seg_value;
7108:

Line 7128: DELETE xla_ae_segment_values

7124: CLOSE c_seg;
7125:
7126: IF (p_action = C_ACTION_DEL) THEN
7127: IF (l_seg_count = 1) THEN
7128: DELETE xla_ae_segment_values
7129: WHERE ae_header_id = p_ae_header_id
7130: AND segment_type_code = p_seg_type
7131: AND segment_value = p_seg_value;
7132: ELSE

Line 7133: UPDATE xla_ae_segment_values

7129: WHERE ae_header_id = p_ae_header_id
7130: AND segment_type_code = p_seg_type
7131: AND segment_value = p_seg_value;
7132: ELSE
7133: UPDATE xla_ae_segment_values
7134: SET ae_lines_count = ae_lines_count - 1
7135: WHERE ae_header_id = p_ae_header_id
7136: AND segment_type_code = p_seg_type
7137: AND segment_value = p_seg_value;

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

7138: END IF;
7139:
7140: ELSIF(p_action = C_ACTION_ADD) THEN
7141: IF (l_seg_count IS NULL) THEN
7142: INSERT INTO xla_ae_segment_values(ae_header_id, segment_type_code, segment_value, ae_lines_count)
7143: VALUES(p_ae_header_id, p_seg_type, p_seg_value, 1);
7144: ELSE
7145: UPDATE xla_ae_segment_values
7146: SET ae_lines_count = ae_lines_count + 1

Line 7145: UPDATE xla_ae_segment_values

7141: IF (l_seg_count IS NULL) THEN
7142: INSERT INTO xla_ae_segment_values(ae_header_id, segment_type_code, segment_value, ae_lines_count)
7143: VALUES(p_ae_header_id, p_seg_type, p_seg_value, 1);
7144: ELSE
7145: UPDATE xla_ae_segment_values
7146: SET ae_lines_count = ae_lines_count + 1
7147: WHERE ae_header_id = p_ae_header_id
7148: AND segment_type_code = p_seg_type
7149: AND segment_value = p_seg_value;