APPS.XLA_ACCOUNTING_ENGINE_PKG dependencies on XLA_AE_JOURNAL_ENTRY_PKG

Line 157: (array_legal_entity_id xla_ae_journal_entry_pkg.t_array_Num

153: +======================================================================*/
154: --
155: --
156: TYPE t_rec_array_event IS RECORD
157: (array_legal_entity_id xla_ae_journal_entry_pkg.t_array_Num
158: ,array_entity_id xla_ae_journal_entry_pkg.t_array_Num
159: ,array_entity_code xla_ae_journal_entry_pkg.t_array_V30L
160: ,array_transaction_num xla_ae_journal_entry_pkg.t_array_V240L
161: ,array_event_id xla_ae_journal_entry_pkg.t_array_Num

Line 158: ,array_entity_id xla_ae_journal_entry_pkg.t_array_Num

154: --
155: --
156: TYPE t_rec_array_event IS RECORD
157: (array_legal_entity_id xla_ae_journal_entry_pkg.t_array_Num
158: ,array_entity_id xla_ae_journal_entry_pkg.t_array_Num
159: ,array_entity_code xla_ae_journal_entry_pkg.t_array_V30L
160: ,array_transaction_num xla_ae_journal_entry_pkg.t_array_V240L
161: ,array_event_id xla_ae_journal_entry_pkg.t_array_Num
162: ,array_class_code xla_ae_journal_entry_pkg.t_array_V30L

Line 159: ,array_entity_code xla_ae_journal_entry_pkg.t_array_V30L

155: --
156: TYPE t_rec_array_event IS RECORD
157: (array_legal_entity_id xla_ae_journal_entry_pkg.t_array_Num
158: ,array_entity_id xla_ae_journal_entry_pkg.t_array_Num
159: ,array_entity_code xla_ae_journal_entry_pkg.t_array_V30L
160: ,array_transaction_num xla_ae_journal_entry_pkg.t_array_V240L
161: ,array_event_id xla_ae_journal_entry_pkg.t_array_Num
162: ,array_class_code xla_ae_journal_entry_pkg.t_array_V30L
163: ,array_event_type xla_ae_journal_entry_pkg.t_array_V30L

Line 160: ,array_transaction_num xla_ae_journal_entry_pkg.t_array_V240L

156: TYPE t_rec_array_event IS RECORD
157: (array_legal_entity_id xla_ae_journal_entry_pkg.t_array_Num
158: ,array_entity_id xla_ae_journal_entry_pkg.t_array_Num
159: ,array_entity_code xla_ae_journal_entry_pkg.t_array_V30L
160: ,array_transaction_num xla_ae_journal_entry_pkg.t_array_V240L
161: ,array_event_id xla_ae_journal_entry_pkg.t_array_Num
162: ,array_class_code xla_ae_journal_entry_pkg.t_array_V30L
163: ,array_event_type xla_ae_journal_entry_pkg.t_array_V30L
164: ,array_event_number xla_ae_journal_entry_pkg.t_array_Num

Line 161: ,array_event_id xla_ae_journal_entry_pkg.t_array_Num

157: (array_legal_entity_id xla_ae_journal_entry_pkg.t_array_Num
158: ,array_entity_id xla_ae_journal_entry_pkg.t_array_Num
159: ,array_entity_code xla_ae_journal_entry_pkg.t_array_V30L
160: ,array_transaction_num xla_ae_journal_entry_pkg.t_array_V240L
161: ,array_event_id xla_ae_journal_entry_pkg.t_array_Num
162: ,array_class_code xla_ae_journal_entry_pkg.t_array_V30L
163: ,array_event_type xla_ae_journal_entry_pkg.t_array_V30L
164: ,array_event_number xla_ae_journal_entry_pkg.t_array_Num
165: ,array_event_date xla_ae_journal_entry_pkg.t_array_Date

Line 162: ,array_class_code xla_ae_journal_entry_pkg.t_array_V30L

158: ,array_entity_id xla_ae_journal_entry_pkg.t_array_Num
159: ,array_entity_code xla_ae_journal_entry_pkg.t_array_V30L
160: ,array_transaction_num xla_ae_journal_entry_pkg.t_array_V240L
161: ,array_event_id xla_ae_journal_entry_pkg.t_array_Num
162: ,array_class_code xla_ae_journal_entry_pkg.t_array_V30L
163: ,array_event_type xla_ae_journal_entry_pkg.t_array_V30L
164: ,array_event_number xla_ae_journal_entry_pkg.t_array_Num
165: ,array_event_date xla_ae_journal_entry_pkg.t_array_Date
166: ,array_reference_num_1 xla_ae_journal_entry_pkg.t_array_Num

Line 163: ,array_event_type xla_ae_journal_entry_pkg.t_array_V30L

159: ,array_entity_code xla_ae_journal_entry_pkg.t_array_V30L
160: ,array_transaction_num xla_ae_journal_entry_pkg.t_array_V240L
161: ,array_event_id xla_ae_journal_entry_pkg.t_array_Num
162: ,array_class_code xla_ae_journal_entry_pkg.t_array_V30L
163: ,array_event_type xla_ae_journal_entry_pkg.t_array_V30L
164: ,array_event_number xla_ae_journal_entry_pkg.t_array_Num
165: ,array_event_date xla_ae_journal_entry_pkg.t_array_Date
166: ,array_reference_num_1 xla_ae_journal_entry_pkg.t_array_Num
167: ,array_reference_num_2 xla_ae_journal_entry_pkg.t_array_Num

Line 164: ,array_event_number xla_ae_journal_entry_pkg.t_array_Num

160: ,array_transaction_num xla_ae_journal_entry_pkg.t_array_V240L
161: ,array_event_id xla_ae_journal_entry_pkg.t_array_Num
162: ,array_class_code xla_ae_journal_entry_pkg.t_array_V30L
163: ,array_event_type xla_ae_journal_entry_pkg.t_array_V30L
164: ,array_event_number xla_ae_journal_entry_pkg.t_array_Num
165: ,array_event_date xla_ae_journal_entry_pkg.t_array_Date
166: ,array_reference_num_1 xla_ae_journal_entry_pkg.t_array_Num
167: ,array_reference_num_2 xla_ae_journal_entry_pkg.t_array_Num
168: ,array_reference_num_3 xla_ae_journal_entry_pkg.t_array_Num

Line 165: ,array_event_date xla_ae_journal_entry_pkg.t_array_Date

161: ,array_event_id xla_ae_journal_entry_pkg.t_array_Num
162: ,array_class_code xla_ae_journal_entry_pkg.t_array_V30L
163: ,array_event_type xla_ae_journal_entry_pkg.t_array_V30L
164: ,array_event_number xla_ae_journal_entry_pkg.t_array_Num
165: ,array_event_date xla_ae_journal_entry_pkg.t_array_Date
166: ,array_reference_num_1 xla_ae_journal_entry_pkg.t_array_Num
167: ,array_reference_num_2 xla_ae_journal_entry_pkg.t_array_Num
168: ,array_reference_num_3 xla_ae_journal_entry_pkg.t_array_Num
169: ,array_reference_num_4 xla_ae_journal_entry_pkg.t_array_Num

Line 166: ,array_reference_num_1 xla_ae_journal_entry_pkg.t_array_Num

162: ,array_class_code xla_ae_journal_entry_pkg.t_array_V30L
163: ,array_event_type xla_ae_journal_entry_pkg.t_array_V30L
164: ,array_event_number xla_ae_journal_entry_pkg.t_array_Num
165: ,array_event_date xla_ae_journal_entry_pkg.t_array_Date
166: ,array_reference_num_1 xla_ae_journal_entry_pkg.t_array_Num
167: ,array_reference_num_2 xla_ae_journal_entry_pkg.t_array_Num
168: ,array_reference_num_3 xla_ae_journal_entry_pkg.t_array_Num
169: ,array_reference_num_4 xla_ae_journal_entry_pkg.t_array_Num
170: ,array_reference_char_1 xla_ae_journal_entry_pkg.t_array_V240L

Line 167: ,array_reference_num_2 xla_ae_journal_entry_pkg.t_array_Num

163: ,array_event_type xla_ae_journal_entry_pkg.t_array_V30L
164: ,array_event_number xla_ae_journal_entry_pkg.t_array_Num
165: ,array_event_date xla_ae_journal_entry_pkg.t_array_Date
166: ,array_reference_num_1 xla_ae_journal_entry_pkg.t_array_Num
167: ,array_reference_num_2 xla_ae_journal_entry_pkg.t_array_Num
168: ,array_reference_num_3 xla_ae_journal_entry_pkg.t_array_Num
169: ,array_reference_num_4 xla_ae_journal_entry_pkg.t_array_Num
170: ,array_reference_char_1 xla_ae_journal_entry_pkg.t_array_V240L
171: ,array_reference_char_2 xla_ae_journal_entry_pkg.t_array_V240L

Line 168: ,array_reference_num_3 xla_ae_journal_entry_pkg.t_array_Num

164: ,array_event_number xla_ae_journal_entry_pkg.t_array_Num
165: ,array_event_date xla_ae_journal_entry_pkg.t_array_Date
166: ,array_reference_num_1 xla_ae_journal_entry_pkg.t_array_Num
167: ,array_reference_num_2 xla_ae_journal_entry_pkg.t_array_Num
168: ,array_reference_num_3 xla_ae_journal_entry_pkg.t_array_Num
169: ,array_reference_num_4 xla_ae_journal_entry_pkg.t_array_Num
170: ,array_reference_char_1 xla_ae_journal_entry_pkg.t_array_V240L
171: ,array_reference_char_2 xla_ae_journal_entry_pkg.t_array_V240L
172: ,array_reference_char_3 xla_ae_journal_entry_pkg.t_array_V240L

Line 169: ,array_reference_num_4 xla_ae_journal_entry_pkg.t_array_Num

165: ,array_event_date xla_ae_journal_entry_pkg.t_array_Date
166: ,array_reference_num_1 xla_ae_journal_entry_pkg.t_array_Num
167: ,array_reference_num_2 xla_ae_journal_entry_pkg.t_array_Num
168: ,array_reference_num_3 xla_ae_journal_entry_pkg.t_array_Num
169: ,array_reference_num_4 xla_ae_journal_entry_pkg.t_array_Num
170: ,array_reference_char_1 xla_ae_journal_entry_pkg.t_array_V240L
171: ,array_reference_char_2 xla_ae_journal_entry_pkg.t_array_V240L
172: ,array_reference_char_3 xla_ae_journal_entry_pkg.t_array_V240L
173: ,array_reference_char_4 xla_ae_journal_entry_pkg.t_array_V240L

Line 170: ,array_reference_char_1 xla_ae_journal_entry_pkg.t_array_V240L

166: ,array_reference_num_1 xla_ae_journal_entry_pkg.t_array_Num
167: ,array_reference_num_2 xla_ae_journal_entry_pkg.t_array_Num
168: ,array_reference_num_3 xla_ae_journal_entry_pkg.t_array_Num
169: ,array_reference_num_4 xla_ae_journal_entry_pkg.t_array_Num
170: ,array_reference_char_1 xla_ae_journal_entry_pkg.t_array_V240L
171: ,array_reference_char_2 xla_ae_journal_entry_pkg.t_array_V240L
172: ,array_reference_char_3 xla_ae_journal_entry_pkg.t_array_V240L
173: ,array_reference_char_4 xla_ae_journal_entry_pkg.t_array_V240L
174: ,array_reference_date_1 xla_ae_journal_entry_pkg.t_array_Date

Line 171: ,array_reference_char_2 xla_ae_journal_entry_pkg.t_array_V240L

167: ,array_reference_num_2 xla_ae_journal_entry_pkg.t_array_Num
168: ,array_reference_num_3 xla_ae_journal_entry_pkg.t_array_Num
169: ,array_reference_num_4 xla_ae_journal_entry_pkg.t_array_Num
170: ,array_reference_char_1 xla_ae_journal_entry_pkg.t_array_V240L
171: ,array_reference_char_2 xla_ae_journal_entry_pkg.t_array_V240L
172: ,array_reference_char_3 xla_ae_journal_entry_pkg.t_array_V240L
173: ,array_reference_char_4 xla_ae_journal_entry_pkg.t_array_V240L
174: ,array_reference_date_1 xla_ae_journal_entry_pkg.t_array_Date
175: ,array_reference_date_2 xla_ae_journal_entry_pkg.t_array_Date

Line 172: ,array_reference_char_3 xla_ae_journal_entry_pkg.t_array_V240L

168: ,array_reference_num_3 xla_ae_journal_entry_pkg.t_array_Num
169: ,array_reference_num_4 xla_ae_journal_entry_pkg.t_array_Num
170: ,array_reference_char_1 xla_ae_journal_entry_pkg.t_array_V240L
171: ,array_reference_char_2 xla_ae_journal_entry_pkg.t_array_V240L
172: ,array_reference_char_3 xla_ae_journal_entry_pkg.t_array_V240L
173: ,array_reference_char_4 xla_ae_journal_entry_pkg.t_array_V240L
174: ,array_reference_date_1 xla_ae_journal_entry_pkg.t_array_Date
175: ,array_reference_date_2 xla_ae_journal_entry_pkg.t_array_Date
176: ,array_reference_date_3 xla_ae_journal_entry_pkg.t_array_Date

Line 173: ,array_reference_char_4 xla_ae_journal_entry_pkg.t_array_V240L

169: ,array_reference_num_4 xla_ae_journal_entry_pkg.t_array_Num
170: ,array_reference_char_1 xla_ae_journal_entry_pkg.t_array_V240L
171: ,array_reference_char_2 xla_ae_journal_entry_pkg.t_array_V240L
172: ,array_reference_char_3 xla_ae_journal_entry_pkg.t_array_V240L
173: ,array_reference_char_4 xla_ae_journal_entry_pkg.t_array_V240L
174: ,array_reference_date_1 xla_ae_journal_entry_pkg.t_array_Date
175: ,array_reference_date_2 xla_ae_journal_entry_pkg.t_array_Date
176: ,array_reference_date_3 xla_ae_journal_entry_pkg.t_array_Date
177: ,array_reference_date_4 xla_ae_journal_entry_pkg.t_array_Date

Line 174: ,array_reference_date_1 xla_ae_journal_entry_pkg.t_array_Date

170: ,array_reference_char_1 xla_ae_journal_entry_pkg.t_array_V240L
171: ,array_reference_char_2 xla_ae_journal_entry_pkg.t_array_V240L
172: ,array_reference_char_3 xla_ae_journal_entry_pkg.t_array_V240L
173: ,array_reference_char_4 xla_ae_journal_entry_pkg.t_array_V240L
174: ,array_reference_date_1 xla_ae_journal_entry_pkg.t_array_Date
175: ,array_reference_date_2 xla_ae_journal_entry_pkg.t_array_Date
176: ,array_reference_date_3 xla_ae_journal_entry_pkg.t_array_Date
177: ,array_reference_date_4 xla_ae_journal_entry_pkg.t_array_Date
178: ,array_event_created_by xla_ae_journal_entry_pkg.t_array_V100L

Line 175: ,array_reference_date_2 xla_ae_journal_entry_pkg.t_array_Date

171: ,array_reference_char_2 xla_ae_journal_entry_pkg.t_array_V240L
172: ,array_reference_char_3 xla_ae_journal_entry_pkg.t_array_V240L
173: ,array_reference_char_4 xla_ae_journal_entry_pkg.t_array_V240L
174: ,array_reference_date_1 xla_ae_journal_entry_pkg.t_array_Date
175: ,array_reference_date_2 xla_ae_journal_entry_pkg.t_array_Date
176: ,array_reference_date_3 xla_ae_journal_entry_pkg.t_array_Date
177: ,array_reference_date_4 xla_ae_journal_entry_pkg.t_array_Date
178: ,array_event_created_by xla_ae_journal_entry_pkg.t_array_V100L
179: );

Line 176: ,array_reference_date_3 xla_ae_journal_entry_pkg.t_array_Date

172: ,array_reference_char_3 xla_ae_journal_entry_pkg.t_array_V240L
173: ,array_reference_char_4 xla_ae_journal_entry_pkg.t_array_V240L
174: ,array_reference_date_1 xla_ae_journal_entry_pkg.t_array_Date
175: ,array_reference_date_2 xla_ae_journal_entry_pkg.t_array_Date
176: ,array_reference_date_3 xla_ae_journal_entry_pkg.t_array_Date
177: ,array_reference_date_4 xla_ae_journal_entry_pkg.t_array_Date
178: ,array_event_created_by xla_ae_journal_entry_pkg.t_array_V100L
179: );
180: --

Line 177: ,array_reference_date_4 xla_ae_journal_entry_pkg.t_array_Date

173: ,array_reference_char_4 xla_ae_journal_entry_pkg.t_array_V240L
174: ,array_reference_date_1 xla_ae_journal_entry_pkg.t_array_Date
175: ,array_reference_date_2 xla_ae_journal_entry_pkg.t_array_Date
176: ,array_reference_date_3 xla_ae_journal_entry_pkg.t_array_Date
177: ,array_reference_date_4 xla_ae_journal_entry_pkg.t_array_Date
178: ,array_event_created_by xla_ae_journal_entry_pkg.t_array_V100L
179: );
180: --
181: --

Line 178: ,array_event_created_by xla_ae_journal_entry_pkg.t_array_V100L

174: ,array_reference_date_1 xla_ae_journal_entry_pkg.t_array_Date
175: ,array_reference_date_2 xla_ae_journal_entry_pkg.t_array_Date
176: ,array_reference_date_3 xla_ae_journal_entry_pkg.t_array_Date
177: ,array_reference_date_4 xla_ae_journal_entry_pkg.t_array_Date
178: ,array_event_created_by xla_ae_journal_entry_pkg.t_array_V100L
179: );
180: --
181: --
182: --

Line 203: g_array_error_flag xla_ae_journal_entry_pkg.t_array_V1L;

199: | |
200: | |
201: +======================================================================*/
202: --
203: g_array_error_flag xla_ae_journal_entry_pkg.t_array_V1L;
204: g_array_error_cache t_array_error;
205: g_event_err_Index BINARY_INTEGER;
206: g_hdr_rowcount NUMBER ;
207: g_line_rowcount NUMBER ;

Line 627: l_array_LR_incomplete_mpa XLA_AE_JOURNAL_ENTRY_PKG.t_array_ae_header_id;

623: PROCEDURE DeleteIncompleteMPA(p_application_id IN NUMBER)
624: IS
625:
626: l_log_module VARCHAR2(240);
627: l_array_LR_incomplete_mpa XLA_AE_JOURNAL_ENTRY_PKG.t_array_ae_header_id;
628: l_array_LR_ledger_id xla_accounting_cache_pkg.t_array_ledger_id;
629: l_array_LR_entity_id xla_ae_journal_entry_pkg.t_array_Num;
630: l_array_TR_incomplete_mpa XLA_AE_JOURNAL_ENTRY_PKG.t_array_ae_header_id;
631: l_array_TR_ledger_id xla_accounting_cache_pkg.t_array_ledger_id;

Line 629: l_array_LR_entity_id xla_ae_journal_entry_pkg.t_array_Num;

625:
626: l_log_module VARCHAR2(240);
627: l_array_LR_incomplete_mpa XLA_AE_JOURNAL_ENTRY_PKG.t_array_ae_header_id;
628: l_array_LR_ledger_id xla_accounting_cache_pkg.t_array_ledger_id;
629: l_array_LR_entity_id xla_ae_journal_entry_pkg.t_array_Num;
630: l_array_TR_incomplete_mpa XLA_AE_JOURNAL_ENTRY_PKG.t_array_ae_header_id;
631: l_array_TR_ledger_id xla_accounting_cache_pkg.t_array_ledger_id;
632: l_array_TR_entity_id xla_ae_journal_entry_pkg.t_array_Num;
633:

Line 630: l_array_TR_incomplete_mpa XLA_AE_JOURNAL_ENTRY_PKG.t_array_ae_header_id;

626: l_log_module VARCHAR2(240);
627: l_array_LR_incomplete_mpa XLA_AE_JOURNAL_ENTRY_PKG.t_array_ae_header_id;
628: l_array_LR_ledger_id xla_accounting_cache_pkg.t_array_ledger_id;
629: l_array_LR_entity_id xla_ae_journal_entry_pkg.t_array_Num;
630: l_array_TR_incomplete_mpa XLA_AE_JOURNAL_ENTRY_PKG.t_array_ae_header_id;
631: l_array_TR_ledger_id xla_accounting_cache_pkg.t_array_ledger_id;
632: l_array_TR_entity_id xla_ae_journal_entry_pkg.t_array_Num;
633:
634:

Line 632: l_array_TR_entity_id xla_ae_journal_entry_pkg.t_array_Num;

628: l_array_LR_ledger_id xla_accounting_cache_pkg.t_array_ledger_id;
629: l_array_LR_entity_id xla_ae_journal_entry_pkg.t_array_Num;
630: l_array_TR_incomplete_mpa XLA_AE_JOURNAL_ENTRY_PKG.t_array_ae_header_id;
631: l_array_TR_ledger_id xla_accounting_cache_pkg.t_array_ledger_id;
632: l_array_TR_entity_id xla_ae_journal_entry_pkg.t_array_Num;
633:
634:
635: BEGIN
636: --

Line 891: l_array_event_type xla_ae_journal_entry_pkg.t_array_V30L;

887: SELECT entity_id, event_id
888: FROM xla_ae_headers_gt
889: WHERE event_type_code = x_event_type;
890:
891: l_array_event_type xla_ae_journal_entry_pkg.t_array_V30L;
892: l_count INTEGER;
893: l_log_module VARCHAR2(240);
894: --
895: BEGIN

Line 917: SET accounting_entry_status_code = xla_ae_journal_entry_pkg.C_RELATED_INVALID

913: IF (l_array_event_type.COUNT > 0) THEN
914:
915: FORALL i IN 1..l_array_event_type.COUNT
916: UPDATE xla_ae_headers_gt
917: SET accounting_entry_status_code = xla_ae_journal_entry_pkg.C_RELATED_INVALID
918: ,event_status_code = 'I'
919: WHERE event_type_code = l_array_event_type(i);
920:
921: l_count := SQL%ROWCOUNT;

Line 981: l_array_temp_events xla_ae_journal_entry_pkg.t_array_Num;

977: ,p_budgetary_control_mode IN VARCHAR2)
978: RETURN NUMBER
979: IS
980: --
981: l_array_temp_events xla_ae_journal_entry_pkg.t_array_Num;
982: l_array_temp_status xla_ae_journal_entry_pkg.t_array_V30L;
983: l_result NUMBER;
984: l_log_module VARCHAR2(240);
985: --

Line 982: l_array_temp_status xla_ae_journal_entry_pkg.t_array_V30L;

978: RETURN NUMBER
979: IS
980: --
981: l_array_temp_events xla_ae_journal_entry_pkg.t_array_Num;
982: l_array_temp_status xla_ae_journal_entry_pkg.t_array_V30L;
983: l_result NUMBER;
984: l_log_module VARCHAR2(240);
985: --
986:

Line 1140: INTO xla_ae_journal_entry_pkg.g_array_event_id

1136: AND gps.ledger_id = aeh.ledger_id
1137: AND gps.adjustment_period_flag = 'N'
1138: AND aeh.ACCOUNTING_DATE BETWEEN gps.start_date AND gps.end_date)
1139: RETURNING event_id, ledger_id, balance_type_code, header_num, ae_header_id BULK COLLECT -- 4262811
1140: INTO xla_ae_journal_entry_pkg.g_array_event_id
1141: ,xla_ae_journal_entry_pkg.g_array_ledger_id
1142: ,xla_ae_journal_entry_pkg.g_array_balance_type
1143: ,xla_ae_journal_entry_pkg.g_array_header_num -- 4262811
1144: ,xla_ae_journal_entry_pkg.g_array_ae_header_id;

Line 1141: ,xla_ae_journal_entry_pkg.g_array_ledger_id

1137: AND gps.adjustment_period_flag = 'N'
1138: AND aeh.ACCOUNTING_DATE BETWEEN gps.start_date AND gps.end_date)
1139: RETURNING event_id, ledger_id, balance_type_code, header_num, ae_header_id BULK COLLECT -- 4262811
1140: INTO xla_ae_journal_entry_pkg.g_array_event_id
1141: ,xla_ae_journal_entry_pkg.g_array_ledger_id
1142: ,xla_ae_journal_entry_pkg.g_array_balance_type
1143: ,xla_ae_journal_entry_pkg.g_array_header_num -- 4262811
1144: ,xla_ae_journal_entry_pkg.g_array_ae_header_id;
1145:

Line 1142: ,xla_ae_journal_entry_pkg.g_array_balance_type

1138: AND aeh.ACCOUNTING_DATE BETWEEN gps.start_date AND gps.end_date)
1139: RETURNING event_id, ledger_id, balance_type_code, header_num, ae_header_id BULK COLLECT -- 4262811
1140: INTO xla_ae_journal_entry_pkg.g_array_event_id
1141: ,xla_ae_journal_entry_pkg.g_array_ledger_id
1142: ,xla_ae_journal_entry_pkg.g_array_balance_type
1143: ,xla_ae_journal_entry_pkg.g_array_header_num -- 4262811
1144: ,xla_ae_journal_entry_pkg.g_array_ae_header_id;
1145:
1146: IF (C_LEVEL_STATEMENT >= g_log_level) THEN

Line 1143: ,xla_ae_journal_entry_pkg.g_array_header_num -- 4262811

1139: RETURNING event_id, ledger_id, balance_type_code, header_num, ae_header_id BULK COLLECT -- 4262811
1140: INTO xla_ae_journal_entry_pkg.g_array_event_id
1141: ,xla_ae_journal_entry_pkg.g_array_ledger_id
1142: ,xla_ae_journal_entry_pkg.g_array_balance_type
1143: ,xla_ae_journal_entry_pkg.g_array_header_num -- 4262811
1144: ,xla_ae_journal_entry_pkg.g_array_ae_header_id;
1145:
1146: IF (C_LEVEL_STATEMENT >= g_log_level) THEN
1147: trace

Line 1144: ,xla_ae_journal_entry_pkg.g_array_ae_header_id;

1140: INTO xla_ae_journal_entry_pkg.g_array_event_id
1141: ,xla_ae_journal_entry_pkg.g_array_ledger_id
1142: ,xla_ae_journal_entry_pkg.g_array_balance_type
1143: ,xla_ae_journal_entry_pkg.g_array_header_num -- 4262811
1144: ,xla_ae_journal_entry_pkg.g_array_ae_header_id;
1145:
1146: IF (C_LEVEL_STATEMENT >= g_log_level) THEN
1147: trace
1148: (p_msg => '# rows updated in xla_ae_headers_gt(1) ='||SQL%ROWCOUNT

Line 1243: SET accounting_entry_status_code = xla_ae_journal_entry_pkg.C_RELATED_INVALID

1239: ,p_max_event_date => p_max_event_date);
1240:
1241:
1242: UPDATE xla_ae_headers_gt a
1243: SET accounting_entry_status_code = xla_ae_journal_entry_pkg.C_RELATED_INVALID
1244: ,event_status_code = 'I'
1245: WHERE accounting_entry_status_code = xla_ae_journal_entry_pkg.C_VALID
1246: AND EXISTS
1247: (SELECT /*+ HASH_SJ */ '1'

Line 1245: WHERE accounting_entry_status_code = xla_ae_journal_entry_pkg.C_VALID

1241:
1242: UPDATE xla_ae_headers_gt a
1243: SET accounting_entry_status_code = xla_ae_journal_entry_pkg.C_RELATED_INVALID
1244: ,event_status_code = 'I'
1245: WHERE accounting_entry_status_code = xla_ae_journal_entry_pkg.C_VALID
1246: AND EXISTS
1247: (SELECT /*+ HASH_SJ */ '1'
1248: FROM xla_ae_headers_gt
1249: WHERE event_id = a.event_id

Line 1250: AND accounting_entry_status_code = xla_ae_journal_entry_pkg.C_INVALID);

1246: AND EXISTS
1247: (SELECT /*+ HASH_SJ */ '1'
1248: FROM xla_ae_headers_gt
1249: WHERE event_id = a.event_id
1250: AND accounting_entry_status_code = xla_ae_journal_entry_pkg.C_INVALID);
1251:
1252:
1253: IF (C_LEVEL_STATEMENT >= g_log_level) THEN
1254: trace

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

1258: END IF;
1259:
1260: IF (C_LEVEL_STATEMENT >= g_log_level) THEN
1261: trace
1262: (p_msg => '--> CALL xla_ae_journal_entry_pkg.InsertJournalEntries'
1263: ,p_level => C_LEVEL_STATEMENT
1264: ,p_module => l_log_module);
1265: END IF;
1266:

Line 1268: l_result := xla_ae_journal_entry_pkg.InsertJournalEntries

1264: ,p_module => l_log_module);
1265: END IF;
1266:
1267:
1268: l_result := xla_ae_journal_entry_pkg.InsertJournalEntries
1269: (p_application_id => p_application_id
1270: ,p_accounting_batch_id => p_accounting_batch_id
1271: ,p_end_date => p_end_date -- 4262811
1272: ,p_accounting_mode => p_accounting_mode

Line 1321: xla_ae_journal_entry_pkg.UpdateResult(

1317:
1318:
1319: END IF;
1320:
1321: xla_ae_journal_entry_pkg.UpdateResult(
1322: p_old_status => l_result
1323: , p_new_status => xla_je_validation_pkg.balance_amounts
1324: (p_application_id => p_application_id
1325: ,p_end_date => p_end_date -- 4262811

Line 1539: l_array_null_event_ids xla_ae_journal_entry_pkg.t_array_Num;

1535: l_result NUMBER;
1536: l_je_result NUMBER;
1537: l_pad_package VARCHAR2(30);
1538: l_array_base_ledgers xla_accounting_cache_pkg.t_array_ledger_id;
1539: l_array_null_event_ids xla_ae_journal_entry_pkg.t_array_Num;
1540: l_array_null_event_status xla_ae_journal_entry_pkg.t_array_V1L;
1541: l_rec_array_event t_rec_array_event;
1542: l_rows NATURAL:=1000;
1543: Idx BINARY_INTEGER;

Line 1540: l_array_null_event_status xla_ae_journal_entry_pkg.t_array_V1L;

1536: l_je_result NUMBER;
1537: l_pad_package VARCHAR2(30);
1538: l_array_base_ledgers xla_accounting_cache_pkg.t_array_ledger_id;
1539: l_array_null_event_ids xla_ae_journal_entry_pkg.t_array_Num;
1540: l_array_null_event_status xla_ae_journal_entry_pkg.t_array_V1L;
1541: l_rec_array_event t_rec_array_event;
1542: l_rows NATURAL:=1000;
1543: Idx BINARY_INTEGER;
1544: EventIdx BINARY_INTEGER;

Line 1899: l_array_entity_id xla_ae_journal_entry_pkg.t_array_Num;

1895: ,p_max_date IN DATE
1896: ,p_aad_name IN VARCHAR2
1897: ,p_aad_owner IN VARCHAR2
1898: ,p_slam_name IN VARCHAR2) IS
1899: l_array_entity_id xla_ae_journal_entry_pkg.t_array_Num;
1900: l_array_event_id xla_ae_journal_entry_pkg.t_array_Num;
1901: l_log_module VARCHAR2(240);
1902: BEGIN
1903: IF g_log_enabled THEN

Line 1900: l_array_event_id xla_ae_journal_entry_pkg.t_array_Num;

1896: ,p_aad_name IN VARCHAR2
1897: ,p_aad_owner IN VARCHAR2
1898: ,p_slam_name IN VARCHAR2) IS
1899: l_array_entity_id xla_ae_journal_entry_pkg.t_array_Num;
1900: l_array_event_id xla_ae_journal_entry_pkg.t_array_Num;
1901: l_log_module VARCHAR2(240);
1902: BEGIN
1903: IF g_log_enabled THEN
1904: l_log_module := C_DEFAULT_MODULE||'.CatchErr_UncompliedAAD';

Line 1979: l_array_entity_id xla_ae_journal_entry_pkg.t_array_Num;

1975: ,p_max_aad_end_date IN DATE
1976: ,p_min_event_date IN VARCHAR2
1977: ,p_max_event_date IN VARCHAR2
1978: ,p_slam_name IN VARCHAR2) IS
1979: l_array_entity_id xla_ae_journal_entry_pkg.t_array_Num;
1980: l_array_event_id xla_ae_journal_entry_pkg.t_array_Num;
1981: l_application_name VARCHAR2(240);
1982: l_slam_owner VARCHAR2(240);
1983: l_log_module VARCHAR2(240);

Line 1980: l_array_event_id xla_ae_journal_entry_pkg.t_array_Num;

1976: ,p_min_event_date IN VARCHAR2
1977: ,p_max_event_date IN VARCHAR2
1978: ,p_slam_name IN VARCHAR2) IS
1979: l_array_entity_id xla_ae_journal_entry_pkg.t_array_Num;
1980: l_array_event_id xla_ae_journal_entry_pkg.t_array_Num;
1981: l_application_name VARCHAR2(240);
1982: l_slam_owner VARCHAR2(240);
1983: l_log_module VARCHAR2(240);
1984: BEGIN