APPS.XLA_ACCOUNTING_ENGINE_PKG dependencies on XLA_AE_JOURNAL_ENTRY_PKG

Line 161: (array_legal_entity_id xla_ae_journal_entry_pkg.t_array_Num

157: +======================================================================*/
158: --
159: --
160: TYPE t_rec_array_event IS RECORD
161: (array_legal_entity_id xla_ae_journal_entry_pkg.t_array_Num
162: ,array_entity_id xla_ae_journal_entry_pkg.t_array_Num
163: ,array_entity_code xla_ae_journal_entry_pkg.t_array_V30L
164: ,array_transaction_num xla_ae_journal_entry_pkg.t_array_V240L
165: ,array_event_id xla_ae_journal_entry_pkg.t_array_Num

Line 162: ,array_entity_id xla_ae_journal_entry_pkg.t_array_Num

158: --
159: --
160: TYPE t_rec_array_event IS RECORD
161: (array_legal_entity_id xla_ae_journal_entry_pkg.t_array_Num
162: ,array_entity_id xla_ae_journal_entry_pkg.t_array_Num
163: ,array_entity_code xla_ae_journal_entry_pkg.t_array_V30L
164: ,array_transaction_num xla_ae_journal_entry_pkg.t_array_V240L
165: ,array_event_id xla_ae_journal_entry_pkg.t_array_Num
166: ,array_class_code xla_ae_journal_entry_pkg.t_array_V30L

Line 163: ,array_entity_code xla_ae_journal_entry_pkg.t_array_V30L

159: --
160: TYPE t_rec_array_event IS RECORD
161: (array_legal_entity_id xla_ae_journal_entry_pkg.t_array_Num
162: ,array_entity_id xla_ae_journal_entry_pkg.t_array_Num
163: ,array_entity_code xla_ae_journal_entry_pkg.t_array_V30L
164: ,array_transaction_num xla_ae_journal_entry_pkg.t_array_V240L
165: ,array_event_id xla_ae_journal_entry_pkg.t_array_Num
166: ,array_class_code xla_ae_journal_entry_pkg.t_array_V30L
167: ,array_event_type xla_ae_journal_entry_pkg.t_array_V30L

Line 164: ,array_transaction_num xla_ae_journal_entry_pkg.t_array_V240L

160: TYPE t_rec_array_event IS RECORD
161: (array_legal_entity_id xla_ae_journal_entry_pkg.t_array_Num
162: ,array_entity_id xla_ae_journal_entry_pkg.t_array_Num
163: ,array_entity_code xla_ae_journal_entry_pkg.t_array_V30L
164: ,array_transaction_num xla_ae_journal_entry_pkg.t_array_V240L
165: ,array_event_id xla_ae_journal_entry_pkg.t_array_Num
166: ,array_class_code xla_ae_journal_entry_pkg.t_array_V30L
167: ,array_event_type xla_ae_journal_entry_pkg.t_array_V30L
168: ,array_event_number xla_ae_journal_entry_pkg.t_array_Num

Line 165: ,array_event_id xla_ae_journal_entry_pkg.t_array_Num

161: (array_legal_entity_id xla_ae_journal_entry_pkg.t_array_Num
162: ,array_entity_id xla_ae_journal_entry_pkg.t_array_Num
163: ,array_entity_code xla_ae_journal_entry_pkg.t_array_V30L
164: ,array_transaction_num xla_ae_journal_entry_pkg.t_array_V240L
165: ,array_event_id xla_ae_journal_entry_pkg.t_array_Num
166: ,array_class_code xla_ae_journal_entry_pkg.t_array_V30L
167: ,array_event_type xla_ae_journal_entry_pkg.t_array_V30L
168: ,array_event_number xla_ae_journal_entry_pkg.t_array_Num
169: ,array_event_date xla_ae_journal_entry_pkg.t_array_Date

Line 166: ,array_class_code xla_ae_journal_entry_pkg.t_array_V30L

162: ,array_entity_id xla_ae_journal_entry_pkg.t_array_Num
163: ,array_entity_code xla_ae_journal_entry_pkg.t_array_V30L
164: ,array_transaction_num xla_ae_journal_entry_pkg.t_array_V240L
165: ,array_event_id xla_ae_journal_entry_pkg.t_array_Num
166: ,array_class_code xla_ae_journal_entry_pkg.t_array_V30L
167: ,array_event_type xla_ae_journal_entry_pkg.t_array_V30L
168: ,array_event_number xla_ae_journal_entry_pkg.t_array_Num
169: ,array_event_date xla_ae_journal_entry_pkg.t_array_Date
170: ,array_reference_num_1 xla_ae_journal_entry_pkg.t_array_Num

Line 167: ,array_event_type xla_ae_journal_entry_pkg.t_array_V30L

163: ,array_entity_code xla_ae_journal_entry_pkg.t_array_V30L
164: ,array_transaction_num xla_ae_journal_entry_pkg.t_array_V240L
165: ,array_event_id xla_ae_journal_entry_pkg.t_array_Num
166: ,array_class_code xla_ae_journal_entry_pkg.t_array_V30L
167: ,array_event_type xla_ae_journal_entry_pkg.t_array_V30L
168: ,array_event_number xla_ae_journal_entry_pkg.t_array_Num
169: ,array_event_date xla_ae_journal_entry_pkg.t_array_Date
170: ,array_reference_num_1 xla_ae_journal_entry_pkg.t_array_Num
171: ,array_reference_num_2 xla_ae_journal_entry_pkg.t_array_Num

Line 168: ,array_event_number xla_ae_journal_entry_pkg.t_array_Num

164: ,array_transaction_num xla_ae_journal_entry_pkg.t_array_V240L
165: ,array_event_id xla_ae_journal_entry_pkg.t_array_Num
166: ,array_class_code xla_ae_journal_entry_pkg.t_array_V30L
167: ,array_event_type xla_ae_journal_entry_pkg.t_array_V30L
168: ,array_event_number xla_ae_journal_entry_pkg.t_array_Num
169: ,array_event_date xla_ae_journal_entry_pkg.t_array_Date
170: ,array_reference_num_1 xla_ae_journal_entry_pkg.t_array_Num
171: ,array_reference_num_2 xla_ae_journal_entry_pkg.t_array_Num
172: ,array_reference_num_3 xla_ae_journal_entry_pkg.t_array_Num

Line 169: ,array_event_date xla_ae_journal_entry_pkg.t_array_Date

165: ,array_event_id xla_ae_journal_entry_pkg.t_array_Num
166: ,array_class_code xla_ae_journal_entry_pkg.t_array_V30L
167: ,array_event_type xla_ae_journal_entry_pkg.t_array_V30L
168: ,array_event_number xla_ae_journal_entry_pkg.t_array_Num
169: ,array_event_date xla_ae_journal_entry_pkg.t_array_Date
170: ,array_reference_num_1 xla_ae_journal_entry_pkg.t_array_Num
171: ,array_reference_num_2 xla_ae_journal_entry_pkg.t_array_Num
172: ,array_reference_num_3 xla_ae_journal_entry_pkg.t_array_Num
173: ,array_reference_num_4 xla_ae_journal_entry_pkg.t_array_Num

Line 170: ,array_reference_num_1 xla_ae_journal_entry_pkg.t_array_Num

166: ,array_class_code xla_ae_journal_entry_pkg.t_array_V30L
167: ,array_event_type xla_ae_journal_entry_pkg.t_array_V30L
168: ,array_event_number xla_ae_journal_entry_pkg.t_array_Num
169: ,array_event_date xla_ae_journal_entry_pkg.t_array_Date
170: ,array_reference_num_1 xla_ae_journal_entry_pkg.t_array_Num
171: ,array_reference_num_2 xla_ae_journal_entry_pkg.t_array_Num
172: ,array_reference_num_3 xla_ae_journal_entry_pkg.t_array_Num
173: ,array_reference_num_4 xla_ae_journal_entry_pkg.t_array_Num
174: ,array_reference_char_1 xla_ae_journal_entry_pkg.t_array_V240L

Line 171: ,array_reference_num_2 xla_ae_journal_entry_pkg.t_array_Num

167: ,array_event_type xla_ae_journal_entry_pkg.t_array_V30L
168: ,array_event_number xla_ae_journal_entry_pkg.t_array_Num
169: ,array_event_date xla_ae_journal_entry_pkg.t_array_Date
170: ,array_reference_num_1 xla_ae_journal_entry_pkg.t_array_Num
171: ,array_reference_num_2 xla_ae_journal_entry_pkg.t_array_Num
172: ,array_reference_num_3 xla_ae_journal_entry_pkg.t_array_Num
173: ,array_reference_num_4 xla_ae_journal_entry_pkg.t_array_Num
174: ,array_reference_char_1 xla_ae_journal_entry_pkg.t_array_V240L
175: ,array_reference_char_2 xla_ae_journal_entry_pkg.t_array_V240L

Line 172: ,array_reference_num_3 xla_ae_journal_entry_pkg.t_array_Num

168: ,array_event_number xla_ae_journal_entry_pkg.t_array_Num
169: ,array_event_date xla_ae_journal_entry_pkg.t_array_Date
170: ,array_reference_num_1 xla_ae_journal_entry_pkg.t_array_Num
171: ,array_reference_num_2 xla_ae_journal_entry_pkg.t_array_Num
172: ,array_reference_num_3 xla_ae_journal_entry_pkg.t_array_Num
173: ,array_reference_num_4 xla_ae_journal_entry_pkg.t_array_Num
174: ,array_reference_char_1 xla_ae_journal_entry_pkg.t_array_V240L
175: ,array_reference_char_2 xla_ae_journal_entry_pkg.t_array_V240L
176: ,array_reference_char_3 xla_ae_journal_entry_pkg.t_array_V240L

Line 173: ,array_reference_num_4 xla_ae_journal_entry_pkg.t_array_Num

169: ,array_event_date xla_ae_journal_entry_pkg.t_array_Date
170: ,array_reference_num_1 xla_ae_journal_entry_pkg.t_array_Num
171: ,array_reference_num_2 xla_ae_journal_entry_pkg.t_array_Num
172: ,array_reference_num_3 xla_ae_journal_entry_pkg.t_array_Num
173: ,array_reference_num_4 xla_ae_journal_entry_pkg.t_array_Num
174: ,array_reference_char_1 xla_ae_journal_entry_pkg.t_array_V240L
175: ,array_reference_char_2 xla_ae_journal_entry_pkg.t_array_V240L
176: ,array_reference_char_3 xla_ae_journal_entry_pkg.t_array_V240L
177: ,array_reference_char_4 xla_ae_journal_entry_pkg.t_array_V240L

Line 174: ,array_reference_char_1 xla_ae_journal_entry_pkg.t_array_V240L

170: ,array_reference_num_1 xla_ae_journal_entry_pkg.t_array_Num
171: ,array_reference_num_2 xla_ae_journal_entry_pkg.t_array_Num
172: ,array_reference_num_3 xla_ae_journal_entry_pkg.t_array_Num
173: ,array_reference_num_4 xla_ae_journal_entry_pkg.t_array_Num
174: ,array_reference_char_1 xla_ae_journal_entry_pkg.t_array_V240L
175: ,array_reference_char_2 xla_ae_journal_entry_pkg.t_array_V240L
176: ,array_reference_char_3 xla_ae_journal_entry_pkg.t_array_V240L
177: ,array_reference_char_4 xla_ae_journal_entry_pkg.t_array_V240L
178: ,array_reference_date_1 xla_ae_journal_entry_pkg.t_array_Date

Line 175: ,array_reference_char_2 xla_ae_journal_entry_pkg.t_array_V240L

171: ,array_reference_num_2 xla_ae_journal_entry_pkg.t_array_Num
172: ,array_reference_num_3 xla_ae_journal_entry_pkg.t_array_Num
173: ,array_reference_num_4 xla_ae_journal_entry_pkg.t_array_Num
174: ,array_reference_char_1 xla_ae_journal_entry_pkg.t_array_V240L
175: ,array_reference_char_2 xla_ae_journal_entry_pkg.t_array_V240L
176: ,array_reference_char_3 xla_ae_journal_entry_pkg.t_array_V240L
177: ,array_reference_char_4 xla_ae_journal_entry_pkg.t_array_V240L
178: ,array_reference_date_1 xla_ae_journal_entry_pkg.t_array_Date
179: ,array_reference_date_2 xla_ae_journal_entry_pkg.t_array_Date

Line 176: ,array_reference_char_3 xla_ae_journal_entry_pkg.t_array_V240L

172: ,array_reference_num_3 xla_ae_journal_entry_pkg.t_array_Num
173: ,array_reference_num_4 xla_ae_journal_entry_pkg.t_array_Num
174: ,array_reference_char_1 xla_ae_journal_entry_pkg.t_array_V240L
175: ,array_reference_char_2 xla_ae_journal_entry_pkg.t_array_V240L
176: ,array_reference_char_3 xla_ae_journal_entry_pkg.t_array_V240L
177: ,array_reference_char_4 xla_ae_journal_entry_pkg.t_array_V240L
178: ,array_reference_date_1 xla_ae_journal_entry_pkg.t_array_Date
179: ,array_reference_date_2 xla_ae_journal_entry_pkg.t_array_Date
180: ,array_reference_date_3 xla_ae_journal_entry_pkg.t_array_Date

Line 177: ,array_reference_char_4 xla_ae_journal_entry_pkg.t_array_V240L

173: ,array_reference_num_4 xla_ae_journal_entry_pkg.t_array_Num
174: ,array_reference_char_1 xla_ae_journal_entry_pkg.t_array_V240L
175: ,array_reference_char_2 xla_ae_journal_entry_pkg.t_array_V240L
176: ,array_reference_char_3 xla_ae_journal_entry_pkg.t_array_V240L
177: ,array_reference_char_4 xla_ae_journal_entry_pkg.t_array_V240L
178: ,array_reference_date_1 xla_ae_journal_entry_pkg.t_array_Date
179: ,array_reference_date_2 xla_ae_journal_entry_pkg.t_array_Date
180: ,array_reference_date_3 xla_ae_journal_entry_pkg.t_array_Date
181: ,array_reference_date_4 xla_ae_journal_entry_pkg.t_array_Date

Line 178: ,array_reference_date_1 xla_ae_journal_entry_pkg.t_array_Date

174: ,array_reference_char_1 xla_ae_journal_entry_pkg.t_array_V240L
175: ,array_reference_char_2 xla_ae_journal_entry_pkg.t_array_V240L
176: ,array_reference_char_3 xla_ae_journal_entry_pkg.t_array_V240L
177: ,array_reference_char_4 xla_ae_journal_entry_pkg.t_array_V240L
178: ,array_reference_date_1 xla_ae_journal_entry_pkg.t_array_Date
179: ,array_reference_date_2 xla_ae_journal_entry_pkg.t_array_Date
180: ,array_reference_date_3 xla_ae_journal_entry_pkg.t_array_Date
181: ,array_reference_date_4 xla_ae_journal_entry_pkg.t_array_Date
182: ,array_event_created_by xla_ae_journal_entry_pkg.t_array_V100L

Line 179: ,array_reference_date_2 xla_ae_journal_entry_pkg.t_array_Date

175: ,array_reference_char_2 xla_ae_journal_entry_pkg.t_array_V240L
176: ,array_reference_char_3 xla_ae_journal_entry_pkg.t_array_V240L
177: ,array_reference_char_4 xla_ae_journal_entry_pkg.t_array_V240L
178: ,array_reference_date_1 xla_ae_journal_entry_pkg.t_array_Date
179: ,array_reference_date_2 xla_ae_journal_entry_pkg.t_array_Date
180: ,array_reference_date_3 xla_ae_journal_entry_pkg.t_array_Date
181: ,array_reference_date_4 xla_ae_journal_entry_pkg.t_array_Date
182: ,array_event_created_by xla_ae_journal_entry_pkg.t_array_V100L
183: );

Line 180: ,array_reference_date_3 xla_ae_journal_entry_pkg.t_array_Date

176: ,array_reference_char_3 xla_ae_journal_entry_pkg.t_array_V240L
177: ,array_reference_char_4 xla_ae_journal_entry_pkg.t_array_V240L
178: ,array_reference_date_1 xla_ae_journal_entry_pkg.t_array_Date
179: ,array_reference_date_2 xla_ae_journal_entry_pkg.t_array_Date
180: ,array_reference_date_3 xla_ae_journal_entry_pkg.t_array_Date
181: ,array_reference_date_4 xla_ae_journal_entry_pkg.t_array_Date
182: ,array_event_created_by xla_ae_journal_entry_pkg.t_array_V100L
183: );
184: --

Line 181: ,array_reference_date_4 xla_ae_journal_entry_pkg.t_array_Date

177: ,array_reference_char_4 xla_ae_journal_entry_pkg.t_array_V240L
178: ,array_reference_date_1 xla_ae_journal_entry_pkg.t_array_Date
179: ,array_reference_date_2 xla_ae_journal_entry_pkg.t_array_Date
180: ,array_reference_date_3 xla_ae_journal_entry_pkg.t_array_Date
181: ,array_reference_date_4 xla_ae_journal_entry_pkg.t_array_Date
182: ,array_event_created_by xla_ae_journal_entry_pkg.t_array_V100L
183: );
184: --
185: --

Line 182: ,array_event_created_by xla_ae_journal_entry_pkg.t_array_V100L

178: ,array_reference_date_1 xla_ae_journal_entry_pkg.t_array_Date
179: ,array_reference_date_2 xla_ae_journal_entry_pkg.t_array_Date
180: ,array_reference_date_3 xla_ae_journal_entry_pkg.t_array_Date
181: ,array_reference_date_4 xla_ae_journal_entry_pkg.t_array_Date
182: ,array_event_created_by xla_ae_journal_entry_pkg.t_array_V100L
183: );
184: --
185: --
186: --

Line 207: g_array_error_flag xla_ae_journal_entry_pkg.t_array_V1L;

203: | |
204: | |
205: +======================================================================*/
206: --
207: g_array_error_flag xla_ae_journal_entry_pkg.t_array_V1L;
208: g_array_error_cache t_array_error;
209: g_event_err_Index BINARY_INTEGER;
210: g_hdr_rowcount NUMBER ;
211: g_line_rowcount NUMBER ;

Line 632: l_array_LR_incomplete_mpa XLA_AE_JOURNAL_ENTRY_PKG.t_array_ae_header_id;

628: PROCEDURE DeleteIncompleteMPA(p_application_id IN NUMBER)
629: IS
630:
631: l_log_module VARCHAR2(240);
632: l_array_LR_incomplete_mpa XLA_AE_JOURNAL_ENTRY_PKG.t_array_ae_header_id;
633: l_array_LR_ledger_id xla_accounting_cache_pkg.t_array_ledger_id;
634: l_array_LR_entity_id xla_ae_journal_entry_pkg.t_array_Num;
635: l_array_TR_incomplete_mpa XLA_AE_JOURNAL_ENTRY_PKG.t_array_ae_header_id;
636: l_array_TR_ledger_id xla_accounting_cache_pkg.t_array_ledger_id;

Line 634: l_array_LR_entity_id xla_ae_journal_entry_pkg.t_array_Num;

630:
631: l_log_module VARCHAR2(240);
632: l_array_LR_incomplete_mpa XLA_AE_JOURNAL_ENTRY_PKG.t_array_ae_header_id;
633: l_array_LR_ledger_id xla_accounting_cache_pkg.t_array_ledger_id;
634: l_array_LR_entity_id xla_ae_journal_entry_pkg.t_array_Num;
635: l_array_TR_incomplete_mpa XLA_AE_JOURNAL_ENTRY_PKG.t_array_ae_header_id;
636: l_array_TR_ledger_id xla_accounting_cache_pkg.t_array_ledger_id;
637: l_array_TR_entity_id xla_ae_journal_entry_pkg.t_array_Num;
638:

Line 635: l_array_TR_incomplete_mpa XLA_AE_JOURNAL_ENTRY_PKG.t_array_ae_header_id;

631: l_log_module VARCHAR2(240);
632: l_array_LR_incomplete_mpa XLA_AE_JOURNAL_ENTRY_PKG.t_array_ae_header_id;
633: l_array_LR_ledger_id xla_accounting_cache_pkg.t_array_ledger_id;
634: l_array_LR_entity_id xla_ae_journal_entry_pkg.t_array_Num;
635: l_array_TR_incomplete_mpa XLA_AE_JOURNAL_ENTRY_PKG.t_array_ae_header_id;
636: l_array_TR_ledger_id xla_accounting_cache_pkg.t_array_ledger_id;
637: l_array_TR_entity_id xla_ae_journal_entry_pkg.t_array_Num;
638:
639:

Line 637: l_array_TR_entity_id xla_ae_journal_entry_pkg.t_array_Num;

633: l_array_LR_ledger_id xla_accounting_cache_pkg.t_array_ledger_id;
634: l_array_LR_entity_id xla_ae_journal_entry_pkg.t_array_Num;
635: l_array_TR_incomplete_mpa XLA_AE_JOURNAL_ENTRY_PKG.t_array_ae_header_id;
636: l_array_TR_ledger_id xla_accounting_cache_pkg.t_array_ledger_id;
637: l_array_TR_entity_id xla_ae_journal_entry_pkg.t_array_Num;
638:
639:
640: BEGIN
641: --

Line 913: l_array_event_type xla_ae_journal_entry_pkg.t_array_V30L;

909: SELECT entity_id, event_id
910: FROM xla_ae_headers_gt
911: WHERE event_type_code = x_event_type;
912:
913: l_array_event_type xla_ae_journal_entry_pkg.t_array_V30L;
914: l_count INTEGER;
915: l_log_module VARCHAR2(240);
916: --
917: BEGIN

Line 939: SET accounting_entry_status_code = xla_ae_journal_entry_pkg.C_RELATED_INVALID

935: IF (l_array_event_type.COUNT > 0) THEN
936:
937: FORALL i IN 1..l_array_event_type.COUNT
938: UPDATE xla_ae_headers_gt
939: SET accounting_entry_status_code = xla_ae_journal_entry_pkg.C_RELATED_INVALID
940: ,event_status_code = 'I'
941: WHERE event_type_code = l_array_event_type(i);
942:
943: l_count := SQL%ROWCOUNT;

Line 1003: l_array_temp_events xla_ae_journal_entry_pkg.t_array_Num;

999: ,p_budgetary_control_mode IN VARCHAR2)
1000: RETURN NUMBER
1001: IS
1002: --
1003: l_array_temp_events xla_ae_journal_entry_pkg.t_array_Num;
1004: l_array_temp_status xla_ae_journal_entry_pkg.t_array_V30L;
1005: l_result NUMBER;
1006: l_log_module VARCHAR2(240);
1007: --

Line 1004: l_array_temp_status xla_ae_journal_entry_pkg.t_array_V30L;

1000: RETURN NUMBER
1001: IS
1002: --
1003: l_array_temp_events xla_ae_journal_entry_pkg.t_array_Num;
1004: l_array_temp_status xla_ae_journal_entry_pkg.t_array_V30L;
1005: l_result NUMBER;
1006: l_log_module VARCHAR2(240);
1007: --
1008:

Line 1166: INTO xla_ae_journal_entry_pkg.g_array_event_id

1162: AND gps.ledger_id = aeh.ledger_id
1163: AND gps.adjustment_period_flag = 'N'
1164: AND aeh.ACCOUNTING_DATE BETWEEN gps.start_date AND gps.end_date)
1165: RETURNING event_id, ledger_id, balance_type_code, header_num, ae_header_id BULK COLLECT -- 4262811
1166: INTO xla_ae_journal_entry_pkg.g_array_event_id
1167: ,xla_ae_journal_entry_pkg.g_array_ledger_id
1168: ,xla_ae_journal_entry_pkg.g_array_balance_type
1169: ,xla_ae_journal_entry_pkg.g_array_header_num -- 4262811
1170: ,xla_ae_journal_entry_pkg.g_array_ae_header_id;

Line 1167: ,xla_ae_journal_entry_pkg.g_array_ledger_id

1163: AND gps.adjustment_period_flag = 'N'
1164: AND aeh.ACCOUNTING_DATE BETWEEN gps.start_date AND gps.end_date)
1165: RETURNING event_id, ledger_id, balance_type_code, header_num, ae_header_id BULK COLLECT -- 4262811
1166: INTO xla_ae_journal_entry_pkg.g_array_event_id
1167: ,xla_ae_journal_entry_pkg.g_array_ledger_id
1168: ,xla_ae_journal_entry_pkg.g_array_balance_type
1169: ,xla_ae_journal_entry_pkg.g_array_header_num -- 4262811
1170: ,xla_ae_journal_entry_pkg.g_array_ae_header_id;
1171:

Line 1168: ,xla_ae_journal_entry_pkg.g_array_balance_type

1164: AND aeh.ACCOUNTING_DATE BETWEEN gps.start_date AND gps.end_date)
1165: RETURNING event_id, ledger_id, balance_type_code, header_num, ae_header_id BULK COLLECT -- 4262811
1166: INTO xla_ae_journal_entry_pkg.g_array_event_id
1167: ,xla_ae_journal_entry_pkg.g_array_ledger_id
1168: ,xla_ae_journal_entry_pkg.g_array_balance_type
1169: ,xla_ae_journal_entry_pkg.g_array_header_num -- 4262811
1170: ,xla_ae_journal_entry_pkg.g_array_ae_header_id;
1171:
1172: IF (C_LEVEL_STATEMENT >= g_log_level) THEN

Line 1169: ,xla_ae_journal_entry_pkg.g_array_header_num -- 4262811

1165: RETURNING event_id, ledger_id, balance_type_code, header_num, ae_header_id BULK COLLECT -- 4262811
1166: INTO xla_ae_journal_entry_pkg.g_array_event_id
1167: ,xla_ae_journal_entry_pkg.g_array_ledger_id
1168: ,xla_ae_journal_entry_pkg.g_array_balance_type
1169: ,xla_ae_journal_entry_pkg.g_array_header_num -- 4262811
1170: ,xla_ae_journal_entry_pkg.g_array_ae_header_id;
1171:
1172: IF (C_LEVEL_STATEMENT >= g_log_level) THEN
1173: trace

Line 1170: ,xla_ae_journal_entry_pkg.g_array_ae_header_id;

1166: INTO xla_ae_journal_entry_pkg.g_array_event_id
1167: ,xla_ae_journal_entry_pkg.g_array_ledger_id
1168: ,xla_ae_journal_entry_pkg.g_array_balance_type
1169: ,xla_ae_journal_entry_pkg.g_array_header_num -- 4262811
1170: ,xla_ae_journal_entry_pkg.g_array_ae_header_id;
1171:
1172: IF (C_LEVEL_STATEMENT >= g_log_level) THEN
1173: trace
1174: (p_msg => '# rows updated in xla_ae_headers_gt(1) ='||SQL%ROWCOUNT

Line 1269: SET accounting_entry_status_code = xla_ae_journal_entry_pkg.C_RELATED_INVALID

1265: ,p_max_event_date => p_max_event_date);
1266:
1267:
1268: UPDATE xla_ae_headers_gt a
1269: SET accounting_entry_status_code = xla_ae_journal_entry_pkg.C_RELATED_INVALID
1270: ,event_status_code = 'I'
1271: WHERE accounting_entry_status_code = xla_ae_journal_entry_pkg.C_VALID
1272: AND EXISTS
1273: (SELECT /*+ HASH_SJ */ '1'

Line 1271: WHERE accounting_entry_status_code = xla_ae_journal_entry_pkg.C_VALID

1267:
1268: UPDATE xla_ae_headers_gt a
1269: SET accounting_entry_status_code = xla_ae_journal_entry_pkg.C_RELATED_INVALID
1270: ,event_status_code = 'I'
1271: WHERE accounting_entry_status_code = xla_ae_journal_entry_pkg.C_VALID
1272: AND EXISTS
1273: (SELECT /*+ HASH_SJ */ '1'
1274: FROM xla_ae_headers_gt
1275: WHERE event_id = a.event_id

Line 1276: AND accounting_entry_status_code = xla_ae_journal_entry_pkg.C_INVALID);

1272: AND EXISTS
1273: (SELECT /*+ HASH_SJ */ '1'
1274: FROM xla_ae_headers_gt
1275: WHERE event_id = a.event_id
1276: AND accounting_entry_status_code = xla_ae_journal_entry_pkg.C_INVALID);
1277:
1278:
1279: IF (C_LEVEL_STATEMENT >= g_log_level) THEN
1280: trace

Line 1288: (p_msg => '--> CALL xla_ae_journal_entry_pkg.InsertJournalEntries'

1284: END IF;
1285:
1286: IF (C_LEVEL_STATEMENT >= g_log_level) THEN
1287: trace
1288: (p_msg => '--> CALL xla_ae_journal_entry_pkg.InsertJournalEntries'
1289: ,p_level => C_LEVEL_STATEMENT
1290: ,p_module => l_log_module);
1291: END IF;
1292:

Line 1294: l_result := xla_ae_journal_entry_pkg.InsertJournalEntries

1290: ,p_module => l_log_module);
1291: END IF;
1292:
1293:
1294: l_result := xla_ae_journal_entry_pkg.InsertJournalEntries
1295: (p_application_id => p_application_id
1296: ,p_accounting_batch_id => p_accounting_batch_id
1297: ,p_end_date => p_end_date -- 4262811
1298: ,p_accounting_mode => p_accounting_mode

Line 1361: xla_ae_journal_entry_pkg.UpdateResult(

1357:
1358:
1359: END IF;
1360:
1361: xla_ae_journal_entry_pkg.UpdateResult(
1362: p_old_status => l_result
1363: , p_new_status => xla_je_validation_pkg.balance_amounts
1364: (p_application_id => p_application_id
1365: ,p_end_date => p_end_date -- 4262811

Line 1658: l_array_null_event_ids xla_ae_journal_entry_pkg.t_array_Num;

1654: l_result NUMBER;
1655: l_je_result NUMBER;
1656: l_pad_package VARCHAR2(30);
1657: l_array_base_ledgers xla_accounting_cache_pkg.t_array_ledger_id;
1658: l_array_null_event_ids xla_ae_journal_entry_pkg.t_array_Num;
1659: l_array_null_event_status xla_ae_journal_entry_pkg.t_array_V1L;
1660: l_rec_array_event t_rec_array_event;
1661: l_rows NATURAL:=1000;
1662: Idx BINARY_INTEGER;

Line 1659: l_array_null_event_status xla_ae_journal_entry_pkg.t_array_V1L;

1655: l_je_result NUMBER;
1656: l_pad_package VARCHAR2(30);
1657: l_array_base_ledgers xla_accounting_cache_pkg.t_array_ledger_id;
1658: l_array_null_event_ids xla_ae_journal_entry_pkg.t_array_Num;
1659: l_array_null_event_status xla_ae_journal_entry_pkg.t_array_V1L;
1660: l_rec_array_event t_rec_array_event;
1661: l_rows NATURAL:=1000;
1662: Idx BINARY_INTEGER;
1663: EventIdx BINARY_INTEGER;

Line 2018: l_array_entity_id xla_ae_journal_entry_pkg.t_array_Num;

2014: ,p_max_date IN DATE
2015: ,p_aad_name IN VARCHAR2
2016: ,p_aad_owner IN VARCHAR2
2017: ,p_slam_name IN VARCHAR2) IS
2018: l_array_entity_id xla_ae_journal_entry_pkg.t_array_Num;
2019: l_array_event_id xla_ae_journal_entry_pkg.t_array_Num;
2020: l_log_module VARCHAR2(240);
2021: BEGIN
2022: IF g_log_enabled THEN

Line 2019: l_array_event_id xla_ae_journal_entry_pkg.t_array_Num;

2015: ,p_aad_name IN VARCHAR2
2016: ,p_aad_owner IN VARCHAR2
2017: ,p_slam_name IN VARCHAR2) IS
2018: l_array_entity_id xla_ae_journal_entry_pkg.t_array_Num;
2019: l_array_event_id xla_ae_journal_entry_pkg.t_array_Num;
2020: l_log_module VARCHAR2(240);
2021: BEGIN
2022: IF g_log_enabled THEN
2023: l_log_module := C_DEFAULT_MODULE||'.CatchErr_UncompliedAAD';

Line 2099: l_array_entity_id xla_ae_journal_entry_pkg.t_array_Num;

2095: ,p_max_aad_end_date IN DATE
2096: ,p_min_event_date IN DATE
2097: ,p_max_event_date IN DATE
2098: ,p_slam_name IN VARCHAR2) IS
2099: l_array_entity_id xla_ae_journal_entry_pkg.t_array_Num;
2100: l_array_event_id xla_ae_journal_entry_pkg.t_array_Num;
2101: l_application_name VARCHAR2(240);
2102: l_slam_owner VARCHAR2(240);
2103: l_log_module VARCHAR2(240);

Line 2100: l_array_event_id xla_ae_journal_entry_pkg.t_array_Num;

2096: ,p_min_event_date IN DATE
2097: ,p_max_event_date IN DATE
2098: ,p_slam_name IN VARCHAR2) IS
2099: l_array_entity_id xla_ae_journal_entry_pkg.t_array_Num;
2100: l_array_event_id xla_ae_journal_entry_pkg.t_array_Num;
2101: l_application_name VARCHAR2(240);
2102: l_slam_owner VARCHAR2(240);
2103: l_log_module VARCHAR2(240);
2104: BEGIN