DBA Data[Home] [Help]

APPS.XLA_00275_AAD_S_000004_BC_PKG dependencies on XLA_AE_JOURNAL_ENTRY_PKG

Line 24: (array_legal_entity_id XLA_AE_JOURNAL_ENTRY_PKG.t_array_Num

20: +=======================================================================*/
21: --
22: --
23: TYPE t_rec_array_event IS RECORD
24: (array_legal_entity_id XLA_AE_JOURNAL_ENTRY_PKG.t_array_Num
25: ,array_entity_id XLA_AE_JOURNAL_ENTRY_PKG.t_array_Num
26: ,array_entity_code XLA_AE_JOURNAL_ENTRY_PKG.t_array_V30L
27: ,array_transaction_num XLA_AE_JOURNAL_ENTRY_PKG.t_array_V240L
28: ,array_event_id xla_number_array_type --XLA_AE_JOURNAL_ENTRY_PKG.t_array_Num

Line 25: ,array_entity_id XLA_AE_JOURNAL_ENTRY_PKG.t_array_Num

21: --
22: --
23: TYPE t_rec_array_event IS RECORD
24: (array_legal_entity_id XLA_AE_JOURNAL_ENTRY_PKG.t_array_Num
25: ,array_entity_id XLA_AE_JOURNAL_ENTRY_PKG.t_array_Num
26: ,array_entity_code XLA_AE_JOURNAL_ENTRY_PKG.t_array_V30L
27: ,array_transaction_num XLA_AE_JOURNAL_ENTRY_PKG.t_array_V240L
28: ,array_event_id xla_number_array_type --XLA_AE_JOURNAL_ENTRY_PKG.t_array_Num
29: ,array_class_code XLA_AE_JOURNAL_ENTRY_PKG.t_array_V30L

Line 26: ,array_entity_code XLA_AE_JOURNAL_ENTRY_PKG.t_array_V30L

22: --
23: TYPE t_rec_array_event IS RECORD
24: (array_legal_entity_id XLA_AE_JOURNAL_ENTRY_PKG.t_array_Num
25: ,array_entity_id XLA_AE_JOURNAL_ENTRY_PKG.t_array_Num
26: ,array_entity_code XLA_AE_JOURNAL_ENTRY_PKG.t_array_V30L
27: ,array_transaction_num XLA_AE_JOURNAL_ENTRY_PKG.t_array_V240L
28: ,array_event_id xla_number_array_type --XLA_AE_JOURNAL_ENTRY_PKG.t_array_Num
29: ,array_class_code XLA_AE_JOURNAL_ENTRY_PKG.t_array_V30L
30: ,array_event_type XLA_AE_JOURNAL_ENTRY_PKG.t_array_V30L

Line 27: ,array_transaction_num XLA_AE_JOURNAL_ENTRY_PKG.t_array_V240L

23: TYPE t_rec_array_event IS RECORD
24: (array_legal_entity_id XLA_AE_JOURNAL_ENTRY_PKG.t_array_Num
25: ,array_entity_id XLA_AE_JOURNAL_ENTRY_PKG.t_array_Num
26: ,array_entity_code XLA_AE_JOURNAL_ENTRY_PKG.t_array_V30L
27: ,array_transaction_num XLA_AE_JOURNAL_ENTRY_PKG.t_array_V240L
28: ,array_event_id xla_number_array_type --XLA_AE_JOURNAL_ENTRY_PKG.t_array_Num
29: ,array_class_code XLA_AE_JOURNAL_ENTRY_PKG.t_array_V30L
30: ,array_event_type XLA_AE_JOURNAL_ENTRY_PKG.t_array_V30L
31: ,array_event_number XLA_AE_JOURNAL_ENTRY_PKG.t_array_Num

Line 28: ,array_event_id xla_number_array_type --XLA_AE_JOURNAL_ENTRY_PKG.t_array_Num

24: (array_legal_entity_id XLA_AE_JOURNAL_ENTRY_PKG.t_array_Num
25: ,array_entity_id XLA_AE_JOURNAL_ENTRY_PKG.t_array_Num
26: ,array_entity_code XLA_AE_JOURNAL_ENTRY_PKG.t_array_V30L
27: ,array_transaction_num XLA_AE_JOURNAL_ENTRY_PKG.t_array_V240L
28: ,array_event_id xla_number_array_type --XLA_AE_JOURNAL_ENTRY_PKG.t_array_Num
29: ,array_class_code XLA_AE_JOURNAL_ENTRY_PKG.t_array_V30L
30: ,array_event_type XLA_AE_JOURNAL_ENTRY_PKG.t_array_V30L
31: ,array_event_number XLA_AE_JOURNAL_ENTRY_PKG.t_array_Num
32: ,array_event_date XLA_AE_JOURNAL_ENTRY_PKG.t_array_Date

Line 29: ,array_class_code XLA_AE_JOURNAL_ENTRY_PKG.t_array_V30L

25: ,array_entity_id XLA_AE_JOURNAL_ENTRY_PKG.t_array_Num
26: ,array_entity_code XLA_AE_JOURNAL_ENTRY_PKG.t_array_V30L
27: ,array_transaction_num XLA_AE_JOURNAL_ENTRY_PKG.t_array_V240L
28: ,array_event_id xla_number_array_type --XLA_AE_JOURNAL_ENTRY_PKG.t_array_Num
29: ,array_class_code XLA_AE_JOURNAL_ENTRY_PKG.t_array_V30L
30: ,array_event_type XLA_AE_JOURNAL_ENTRY_PKG.t_array_V30L
31: ,array_event_number XLA_AE_JOURNAL_ENTRY_PKG.t_array_Num
32: ,array_event_date XLA_AE_JOURNAL_ENTRY_PKG.t_array_Date
33: ,array_reference_num_1 XLA_AE_JOURNAL_ENTRY_PKG.t_array_Num

Line 30: ,array_event_type XLA_AE_JOURNAL_ENTRY_PKG.t_array_V30L

26: ,array_entity_code XLA_AE_JOURNAL_ENTRY_PKG.t_array_V30L
27: ,array_transaction_num XLA_AE_JOURNAL_ENTRY_PKG.t_array_V240L
28: ,array_event_id xla_number_array_type --XLA_AE_JOURNAL_ENTRY_PKG.t_array_Num
29: ,array_class_code XLA_AE_JOURNAL_ENTRY_PKG.t_array_V30L
30: ,array_event_type XLA_AE_JOURNAL_ENTRY_PKG.t_array_V30L
31: ,array_event_number XLA_AE_JOURNAL_ENTRY_PKG.t_array_Num
32: ,array_event_date XLA_AE_JOURNAL_ENTRY_PKG.t_array_Date
33: ,array_reference_num_1 XLA_AE_JOURNAL_ENTRY_PKG.t_array_Num
34: ,array_reference_num_2 XLA_AE_JOURNAL_ENTRY_PKG.t_array_Num

Line 31: ,array_event_number XLA_AE_JOURNAL_ENTRY_PKG.t_array_Num

27: ,array_transaction_num XLA_AE_JOURNAL_ENTRY_PKG.t_array_V240L
28: ,array_event_id xla_number_array_type --XLA_AE_JOURNAL_ENTRY_PKG.t_array_Num
29: ,array_class_code XLA_AE_JOURNAL_ENTRY_PKG.t_array_V30L
30: ,array_event_type XLA_AE_JOURNAL_ENTRY_PKG.t_array_V30L
31: ,array_event_number XLA_AE_JOURNAL_ENTRY_PKG.t_array_Num
32: ,array_event_date XLA_AE_JOURNAL_ENTRY_PKG.t_array_Date
33: ,array_reference_num_1 XLA_AE_JOURNAL_ENTRY_PKG.t_array_Num
34: ,array_reference_num_2 XLA_AE_JOURNAL_ENTRY_PKG.t_array_Num
35: ,array_reference_num_3 XLA_AE_JOURNAL_ENTRY_PKG.t_array_Num

Line 32: ,array_event_date XLA_AE_JOURNAL_ENTRY_PKG.t_array_Date

28: ,array_event_id xla_number_array_type --XLA_AE_JOURNAL_ENTRY_PKG.t_array_Num
29: ,array_class_code XLA_AE_JOURNAL_ENTRY_PKG.t_array_V30L
30: ,array_event_type XLA_AE_JOURNAL_ENTRY_PKG.t_array_V30L
31: ,array_event_number XLA_AE_JOURNAL_ENTRY_PKG.t_array_Num
32: ,array_event_date XLA_AE_JOURNAL_ENTRY_PKG.t_array_Date
33: ,array_reference_num_1 XLA_AE_JOURNAL_ENTRY_PKG.t_array_Num
34: ,array_reference_num_2 XLA_AE_JOURNAL_ENTRY_PKG.t_array_Num
35: ,array_reference_num_3 XLA_AE_JOURNAL_ENTRY_PKG.t_array_Num
36: ,array_reference_num_4 XLA_AE_JOURNAL_ENTRY_PKG.t_array_Num

Line 33: ,array_reference_num_1 XLA_AE_JOURNAL_ENTRY_PKG.t_array_Num

29: ,array_class_code XLA_AE_JOURNAL_ENTRY_PKG.t_array_V30L
30: ,array_event_type XLA_AE_JOURNAL_ENTRY_PKG.t_array_V30L
31: ,array_event_number XLA_AE_JOURNAL_ENTRY_PKG.t_array_Num
32: ,array_event_date XLA_AE_JOURNAL_ENTRY_PKG.t_array_Date
33: ,array_reference_num_1 XLA_AE_JOURNAL_ENTRY_PKG.t_array_Num
34: ,array_reference_num_2 XLA_AE_JOURNAL_ENTRY_PKG.t_array_Num
35: ,array_reference_num_3 XLA_AE_JOURNAL_ENTRY_PKG.t_array_Num
36: ,array_reference_num_4 XLA_AE_JOURNAL_ENTRY_PKG.t_array_Num
37: ,array_reference_char_1 XLA_AE_JOURNAL_ENTRY_PKG.t_array_V240L

Line 34: ,array_reference_num_2 XLA_AE_JOURNAL_ENTRY_PKG.t_array_Num

30: ,array_event_type XLA_AE_JOURNAL_ENTRY_PKG.t_array_V30L
31: ,array_event_number XLA_AE_JOURNAL_ENTRY_PKG.t_array_Num
32: ,array_event_date XLA_AE_JOURNAL_ENTRY_PKG.t_array_Date
33: ,array_reference_num_1 XLA_AE_JOURNAL_ENTRY_PKG.t_array_Num
34: ,array_reference_num_2 XLA_AE_JOURNAL_ENTRY_PKG.t_array_Num
35: ,array_reference_num_3 XLA_AE_JOURNAL_ENTRY_PKG.t_array_Num
36: ,array_reference_num_4 XLA_AE_JOURNAL_ENTRY_PKG.t_array_Num
37: ,array_reference_char_1 XLA_AE_JOURNAL_ENTRY_PKG.t_array_V240L
38: ,array_reference_char_2 XLA_AE_JOURNAL_ENTRY_PKG.t_array_V240L

Line 35: ,array_reference_num_3 XLA_AE_JOURNAL_ENTRY_PKG.t_array_Num

31: ,array_event_number XLA_AE_JOURNAL_ENTRY_PKG.t_array_Num
32: ,array_event_date XLA_AE_JOURNAL_ENTRY_PKG.t_array_Date
33: ,array_reference_num_1 XLA_AE_JOURNAL_ENTRY_PKG.t_array_Num
34: ,array_reference_num_2 XLA_AE_JOURNAL_ENTRY_PKG.t_array_Num
35: ,array_reference_num_3 XLA_AE_JOURNAL_ENTRY_PKG.t_array_Num
36: ,array_reference_num_4 XLA_AE_JOURNAL_ENTRY_PKG.t_array_Num
37: ,array_reference_char_1 XLA_AE_JOURNAL_ENTRY_PKG.t_array_V240L
38: ,array_reference_char_2 XLA_AE_JOURNAL_ENTRY_PKG.t_array_V240L
39: ,array_reference_char_3 XLA_AE_JOURNAL_ENTRY_PKG.t_array_V240L

Line 36: ,array_reference_num_4 XLA_AE_JOURNAL_ENTRY_PKG.t_array_Num

32: ,array_event_date XLA_AE_JOURNAL_ENTRY_PKG.t_array_Date
33: ,array_reference_num_1 XLA_AE_JOURNAL_ENTRY_PKG.t_array_Num
34: ,array_reference_num_2 XLA_AE_JOURNAL_ENTRY_PKG.t_array_Num
35: ,array_reference_num_3 XLA_AE_JOURNAL_ENTRY_PKG.t_array_Num
36: ,array_reference_num_4 XLA_AE_JOURNAL_ENTRY_PKG.t_array_Num
37: ,array_reference_char_1 XLA_AE_JOURNAL_ENTRY_PKG.t_array_V240L
38: ,array_reference_char_2 XLA_AE_JOURNAL_ENTRY_PKG.t_array_V240L
39: ,array_reference_char_3 XLA_AE_JOURNAL_ENTRY_PKG.t_array_V240L
40: ,array_reference_char_4 XLA_AE_JOURNAL_ENTRY_PKG.t_array_V240L

Line 37: ,array_reference_char_1 XLA_AE_JOURNAL_ENTRY_PKG.t_array_V240L

33: ,array_reference_num_1 XLA_AE_JOURNAL_ENTRY_PKG.t_array_Num
34: ,array_reference_num_2 XLA_AE_JOURNAL_ENTRY_PKG.t_array_Num
35: ,array_reference_num_3 XLA_AE_JOURNAL_ENTRY_PKG.t_array_Num
36: ,array_reference_num_4 XLA_AE_JOURNAL_ENTRY_PKG.t_array_Num
37: ,array_reference_char_1 XLA_AE_JOURNAL_ENTRY_PKG.t_array_V240L
38: ,array_reference_char_2 XLA_AE_JOURNAL_ENTRY_PKG.t_array_V240L
39: ,array_reference_char_3 XLA_AE_JOURNAL_ENTRY_PKG.t_array_V240L
40: ,array_reference_char_4 XLA_AE_JOURNAL_ENTRY_PKG.t_array_V240L
41: ,array_reference_date_1 XLA_AE_JOURNAL_ENTRY_PKG.t_array_Date

Line 38: ,array_reference_char_2 XLA_AE_JOURNAL_ENTRY_PKG.t_array_V240L

34: ,array_reference_num_2 XLA_AE_JOURNAL_ENTRY_PKG.t_array_Num
35: ,array_reference_num_3 XLA_AE_JOURNAL_ENTRY_PKG.t_array_Num
36: ,array_reference_num_4 XLA_AE_JOURNAL_ENTRY_PKG.t_array_Num
37: ,array_reference_char_1 XLA_AE_JOURNAL_ENTRY_PKG.t_array_V240L
38: ,array_reference_char_2 XLA_AE_JOURNAL_ENTRY_PKG.t_array_V240L
39: ,array_reference_char_3 XLA_AE_JOURNAL_ENTRY_PKG.t_array_V240L
40: ,array_reference_char_4 XLA_AE_JOURNAL_ENTRY_PKG.t_array_V240L
41: ,array_reference_date_1 XLA_AE_JOURNAL_ENTRY_PKG.t_array_Date
42: ,array_reference_date_2 XLA_AE_JOURNAL_ENTRY_PKG.t_array_Date

Line 39: ,array_reference_char_3 XLA_AE_JOURNAL_ENTRY_PKG.t_array_V240L

35: ,array_reference_num_3 XLA_AE_JOURNAL_ENTRY_PKG.t_array_Num
36: ,array_reference_num_4 XLA_AE_JOURNAL_ENTRY_PKG.t_array_Num
37: ,array_reference_char_1 XLA_AE_JOURNAL_ENTRY_PKG.t_array_V240L
38: ,array_reference_char_2 XLA_AE_JOURNAL_ENTRY_PKG.t_array_V240L
39: ,array_reference_char_3 XLA_AE_JOURNAL_ENTRY_PKG.t_array_V240L
40: ,array_reference_char_4 XLA_AE_JOURNAL_ENTRY_PKG.t_array_V240L
41: ,array_reference_date_1 XLA_AE_JOURNAL_ENTRY_PKG.t_array_Date
42: ,array_reference_date_2 XLA_AE_JOURNAL_ENTRY_PKG.t_array_Date
43: ,array_reference_date_3 XLA_AE_JOURNAL_ENTRY_PKG.t_array_Date

Line 40: ,array_reference_char_4 XLA_AE_JOURNAL_ENTRY_PKG.t_array_V240L

36: ,array_reference_num_4 XLA_AE_JOURNAL_ENTRY_PKG.t_array_Num
37: ,array_reference_char_1 XLA_AE_JOURNAL_ENTRY_PKG.t_array_V240L
38: ,array_reference_char_2 XLA_AE_JOURNAL_ENTRY_PKG.t_array_V240L
39: ,array_reference_char_3 XLA_AE_JOURNAL_ENTRY_PKG.t_array_V240L
40: ,array_reference_char_4 XLA_AE_JOURNAL_ENTRY_PKG.t_array_V240L
41: ,array_reference_date_1 XLA_AE_JOURNAL_ENTRY_PKG.t_array_Date
42: ,array_reference_date_2 XLA_AE_JOURNAL_ENTRY_PKG.t_array_Date
43: ,array_reference_date_3 XLA_AE_JOURNAL_ENTRY_PKG.t_array_Date
44: ,array_reference_date_4 XLA_AE_JOURNAL_ENTRY_PKG.t_array_Date

Line 41: ,array_reference_date_1 XLA_AE_JOURNAL_ENTRY_PKG.t_array_Date

37: ,array_reference_char_1 XLA_AE_JOURNAL_ENTRY_PKG.t_array_V240L
38: ,array_reference_char_2 XLA_AE_JOURNAL_ENTRY_PKG.t_array_V240L
39: ,array_reference_char_3 XLA_AE_JOURNAL_ENTRY_PKG.t_array_V240L
40: ,array_reference_char_4 XLA_AE_JOURNAL_ENTRY_PKG.t_array_V240L
41: ,array_reference_date_1 XLA_AE_JOURNAL_ENTRY_PKG.t_array_Date
42: ,array_reference_date_2 XLA_AE_JOURNAL_ENTRY_PKG.t_array_Date
43: ,array_reference_date_3 XLA_AE_JOURNAL_ENTRY_PKG.t_array_Date
44: ,array_reference_date_4 XLA_AE_JOURNAL_ENTRY_PKG.t_array_Date
45: ,array_event_created_by XLA_AE_JOURNAL_ENTRY_PKG.t_array_V100L

Line 42: ,array_reference_date_2 XLA_AE_JOURNAL_ENTRY_PKG.t_array_Date

38: ,array_reference_char_2 XLA_AE_JOURNAL_ENTRY_PKG.t_array_V240L
39: ,array_reference_char_3 XLA_AE_JOURNAL_ENTRY_PKG.t_array_V240L
40: ,array_reference_char_4 XLA_AE_JOURNAL_ENTRY_PKG.t_array_V240L
41: ,array_reference_date_1 XLA_AE_JOURNAL_ENTRY_PKG.t_array_Date
42: ,array_reference_date_2 XLA_AE_JOURNAL_ENTRY_PKG.t_array_Date
43: ,array_reference_date_3 XLA_AE_JOURNAL_ENTRY_PKG.t_array_Date
44: ,array_reference_date_4 XLA_AE_JOURNAL_ENTRY_PKG.t_array_Date
45: ,array_event_created_by XLA_AE_JOURNAL_ENTRY_PKG.t_array_V100L
46: );

Line 43: ,array_reference_date_3 XLA_AE_JOURNAL_ENTRY_PKG.t_array_Date

39: ,array_reference_char_3 XLA_AE_JOURNAL_ENTRY_PKG.t_array_V240L
40: ,array_reference_char_4 XLA_AE_JOURNAL_ENTRY_PKG.t_array_V240L
41: ,array_reference_date_1 XLA_AE_JOURNAL_ENTRY_PKG.t_array_Date
42: ,array_reference_date_2 XLA_AE_JOURNAL_ENTRY_PKG.t_array_Date
43: ,array_reference_date_3 XLA_AE_JOURNAL_ENTRY_PKG.t_array_Date
44: ,array_reference_date_4 XLA_AE_JOURNAL_ENTRY_PKG.t_array_Date
45: ,array_event_created_by XLA_AE_JOURNAL_ENTRY_PKG.t_array_V100L
46: );
47: --

Line 44: ,array_reference_date_4 XLA_AE_JOURNAL_ENTRY_PKG.t_array_Date

40: ,array_reference_char_4 XLA_AE_JOURNAL_ENTRY_PKG.t_array_V240L
41: ,array_reference_date_1 XLA_AE_JOURNAL_ENTRY_PKG.t_array_Date
42: ,array_reference_date_2 XLA_AE_JOURNAL_ENTRY_PKG.t_array_Date
43: ,array_reference_date_3 XLA_AE_JOURNAL_ENTRY_PKG.t_array_Date
44: ,array_reference_date_4 XLA_AE_JOURNAL_ENTRY_PKG.t_array_Date
45: ,array_event_created_by XLA_AE_JOURNAL_ENTRY_PKG.t_array_V100L
46: );
47: --
48: type t_array_value_num is table of number index by varchar2(30);

Line 45: ,array_event_created_by XLA_AE_JOURNAL_ENTRY_PKG.t_array_V100L

41: ,array_reference_date_1 XLA_AE_JOURNAL_ENTRY_PKG.t_array_Date
42: ,array_reference_date_2 XLA_AE_JOURNAL_ENTRY_PKG.t_array_Date
43: ,array_reference_date_3 XLA_AE_JOURNAL_ENTRY_PKG.t_array_Date
44: ,array_reference_date_4 XLA_AE_JOURNAL_ENTRY_PKG.t_array_Date
45: ,array_event_created_by XLA_AE_JOURNAL_ENTRY_PKG.t_array_V100L
46: );
47: --
48: type t_array_value_num is table of number index by varchar2(30);
49: type t_array_value_char is table of varchar2(240) index by varchar2(30);

Line 162: xla_ae_journal_entry_pkg.g_global_status := xla_ae_journal_entry_pkg.C_INVALID;

158:
159: END IF;
160:
161: IF p_lookup_code IS NOT NULL AND p_meaning IS NULL THEN
162: xla_ae_journal_entry_pkg.g_global_status := xla_ae_journal_entry_pkg.C_INVALID;
163: xla_accounting_err_pkg. build_message
164: (p_appli_s_name => 'XLA'
165: ,p_msg_name => 'XLA_AP_NO_LOOKUP_MEANING'
166: ,p_token_1 => 'SOURCE_NAME'

Line 177: ,p_value_4 => xla_ae_journal_entry_pkg.g_cache_event.application_name

173: ,p_value_2 => p_lookup_code
174: ,p_token_3 => 'LOOKUP_TYPE'
175: ,p_value_3 => p_lookup_type
176: ,p_token_4 => 'PRODUCT_NAME'
177: ,p_value_4 => xla_ae_journal_entry_pkg.g_cache_event.application_name
178: ,p_entity_id => xla_ae_journal_entry_pkg.g_cache_event.entity_id
179: ,p_event_id => xla_ae_journal_entry_pkg.g_cache_event.event_id
180: ,p_ledger_id => xla_ae_journal_entry_pkg.g_cache_event.target_ledger_id
181: );

Line 178: ,p_entity_id => xla_ae_journal_entry_pkg.g_cache_event.entity_id

174: ,p_token_3 => 'LOOKUP_TYPE'
175: ,p_value_3 => p_lookup_type
176: ,p_token_4 => 'PRODUCT_NAME'
177: ,p_value_4 => xla_ae_journal_entry_pkg.g_cache_event.application_name
178: ,p_entity_id => xla_ae_journal_entry_pkg.g_cache_event.entity_id
179: ,p_event_id => xla_ae_journal_entry_pkg.g_cache_event.event_id
180: ,p_ledger_id => xla_ae_journal_entry_pkg.g_cache_event.target_ledger_id
181: );
182:

Line 179: ,p_event_id => xla_ae_journal_entry_pkg.g_cache_event.event_id

175: ,p_value_3 => p_lookup_type
176: ,p_token_4 => 'PRODUCT_NAME'
177: ,p_value_4 => xla_ae_journal_entry_pkg.g_cache_event.application_name
178: ,p_entity_id => xla_ae_journal_entry_pkg.g_cache_event.entity_id
179: ,p_event_id => xla_ae_journal_entry_pkg.g_cache_event.event_id
180: ,p_ledger_id => xla_ae_journal_entry_pkg.g_cache_event.target_ledger_id
181: );
182:
183: IF (C_LEVEL_ERROR >= g_log_level) THEN

Line 180: ,p_ledger_id => xla_ae_journal_entry_pkg.g_cache_event.target_ledger_id

176: ,p_token_4 => 'PRODUCT_NAME'
177: ,p_value_4 => xla_ae_journal_entry_pkg.g_cache_event.application_name
178: ,p_entity_id => xla_ae_journal_entry_pkg.g_cache_event.entity_id
179: ,p_event_id => xla_ae_journal_entry_pkg.g_cache_event.event_id
180: ,p_ledger_id => xla_ae_journal_entry_pkg.g_cache_event.target_ledger_id
181: );
182:
183: IF (C_LEVEL_ERROR >= g_log_level) THEN
184: trace

Line 294: xla_ae_journal_entry_pkg.g_global_status := xla_ae_journal_entry_pkg.C_INVALID;

290: (p_msg => 'END of AcctDerRule_1(invalid)'
291: ,p_level => C_LEVEL_PROCEDURE
292: ,p_module => l_log_module);
293: END IF;
294: xla_ae_journal_entry_pkg.g_global_status := xla_ae_journal_entry_pkg.C_INVALID;
295: x_value_type_code := null;
296: l_output_value := null;
297: xla_accounting_err_pkg.build_message
298: (p_appli_s_name => 'XLA'

Line 314: ,p_value_3 => xla_ae_journal_entry_pkg.g_cache_pad.pad_session_name

310: 'XLA_OWNER_TYPE'
311: ,l_component_type_code
312: )
313: ,p_token_3 => 'PAD_NAME'
314: ,p_value_3 => xla_ae_journal_entry_pkg.g_cache_pad.pad_session_name
315: ,p_token_4 => 'PAD_OWNER'
316: ,p_value_4 => xla_lookups_pkg.get_meaning(
317: 'XLA_OWNER_TYPE'
318: ,xla_ae_journal_entry_pkg.g_cache_pad.product_rule_type_code

Line 318: ,xla_ae_journal_entry_pkg.g_cache_pad.product_rule_type_code

314: ,p_value_3 => xla_ae_journal_entry_pkg.g_cache_pad.pad_session_name
315: ,p_token_4 => 'PAD_OWNER'
316: ,p_value_4 => xla_lookups_pkg.get_meaning(
317: 'XLA_OWNER_TYPE'
318: ,xla_ae_journal_entry_pkg.g_cache_pad.product_rule_type_code
319: )
320: ,p_entity_id => xla_ae_journal_entry_pkg.g_cache_event.entity_id
321: ,p_event_id => xla_ae_journal_entry_pkg.g_cache_event.event_id
322: ,p_ledger_id => xla_ae_journal_entry_pkg.g_cache_event.target_ledger_id

Line 320: ,p_entity_id => xla_ae_journal_entry_pkg.g_cache_event.entity_id

316: ,p_value_4 => xla_lookups_pkg.get_meaning(
317: 'XLA_OWNER_TYPE'
318: ,xla_ae_journal_entry_pkg.g_cache_pad.product_rule_type_code
319: )
320: ,p_entity_id => xla_ae_journal_entry_pkg.g_cache_event.entity_id
321: ,p_event_id => xla_ae_journal_entry_pkg.g_cache_event.event_id
322: ,p_ledger_id => xla_ae_journal_entry_pkg.g_cache_event.target_ledger_id
323: ,p_ae_header_id => NULL
324: );

Line 321: ,p_event_id => xla_ae_journal_entry_pkg.g_cache_event.event_id

317: 'XLA_OWNER_TYPE'
318: ,xla_ae_journal_entry_pkg.g_cache_pad.product_rule_type_code
319: )
320: ,p_entity_id => xla_ae_journal_entry_pkg.g_cache_event.entity_id
321: ,p_event_id => xla_ae_journal_entry_pkg.g_cache_event.event_id
322: ,p_ledger_id => xla_ae_journal_entry_pkg.g_cache_event.target_ledger_id
323: ,p_ae_header_id => NULL
324: );
325: RETURN l_output_value;

Line 322: ,p_ledger_id => xla_ae_journal_entry_pkg.g_cache_event.target_ledger_id

318: ,xla_ae_journal_entry_pkg.g_cache_pad.product_rule_type_code
319: )
320: ,p_entity_id => xla_ae_journal_entry_pkg.g_cache_event.entity_id
321: ,p_event_id => xla_ae_journal_entry_pkg.g_cache_event.event_id
322: ,p_ledger_id => xla_ae_journal_entry_pkg.g_cache_event.target_ledger_id
323: ,p_ae_header_id => NULL
324: );
325: RETURN l_output_value;
326: EXCEPTION

Line 421: l_gl_dates xla_ae_journal_entry_pkg.t_array_date;

417: l_tmp_amt NUMBER;
418: l_acc_rev_natural_side_code VARCHAR2(1);
419:
420: l_num_entries NUMBER;
421: l_gl_dates xla_ae_journal_entry_pkg.t_array_date;
422: l_accted_amts xla_ae_journal_entry_pkg.t_array_num;
423: l_entered_amts xla_ae_journal_entry_pkg.t_array_num;
424: l_period_names xla_ae_journal_entry_pkg.t_array_V15L;
425: l_recog_line_1 NUMBER;

Line 422: l_accted_amts xla_ae_journal_entry_pkg.t_array_num;

418: l_acc_rev_natural_side_code VARCHAR2(1);
419:
420: l_num_entries NUMBER;
421: l_gl_dates xla_ae_journal_entry_pkg.t_array_date;
422: l_accted_amts xla_ae_journal_entry_pkg.t_array_num;
423: l_entered_amts xla_ae_journal_entry_pkg.t_array_num;
424: l_period_names xla_ae_journal_entry_pkg.t_array_V15L;
425: l_recog_line_1 NUMBER;
426: l_recog_line_2 NUMBER;

Line 423: l_entered_amts xla_ae_journal_entry_pkg.t_array_num;

419:
420: l_num_entries NUMBER;
421: l_gl_dates xla_ae_journal_entry_pkg.t_array_date;
422: l_accted_amts xla_ae_journal_entry_pkg.t_array_num;
423: l_entered_amts xla_ae_journal_entry_pkg.t_array_num;
424: l_period_names xla_ae_journal_entry_pkg.t_array_V15L;
425: l_recog_line_1 NUMBER;
426: l_recog_line_2 NUMBER;
427:

Line 424: l_period_names xla_ae_journal_entry_pkg.t_array_V15L;

420: l_num_entries NUMBER;
421: l_gl_dates xla_ae_journal_entry_pkg.t_array_date;
422: l_accted_amts xla_ae_journal_entry_pkg.t_array_num;
423: l_entered_amts xla_ae_journal_entry_pkg.t_array_num;
424: l_period_names xla_ae_journal_entry_pkg.t_array_V15L;
425: l_recog_line_1 NUMBER;
426: l_recog_line_2 NUMBER;
427:
428: l_bflow_applied_to_amt_idx NUMBER; -- 5132302

Line 430: l_bflow_applied_to_amts xla_ae_journal_entry_pkg.t_array_num; -- 5132302

426: l_recog_line_2 NUMBER;
427:
428: l_bflow_applied_to_amt_idx NUMBER; -- 5132302
429: l_bflow_applied_to_amt NUMBER; -- 5132302
430: l_bflow_applied_to_amts xla_ae_journal_entry_pkg.t_array_num; -- 5132302
431:
432: l_event_id NUMBER; -- To handle MPA header Description: xla_ae_header_pkg.SetHdrDescription
433:
434: --l_rounding_ccy VARCHAR2(15); -- To handle MPA rounding 4262811b

Line 505: IF XLA_AE_JOURNAL_ENTRY_PKG.g_cache_event.target_ledger_id = XLA_AE_JOURNAL_ENTRY_PKG.g_cache_event.ledger_id OR

501: l_accrual_line_num := NULL; -- 4262811
502: l_tmp_amt := NULL; -- 4262811
503: --
504:
505: IF XLA_AE_JOURNAL_ENTRY_PKG.g_cache_event.target_ledger_id = XLA_AE_JOURNAL_ENTRY_PKG.g_cache_event.ledger_id OR
506: l_balance_type_code <> 'B' THEN
507: IF NVL(p_source_2,'
508: ') = 'C' AND
509: NVL(p_source_3,'

Line 579: XLA_AE_JOURNAL_ENTRY_PKG.g_cache_event.target_ledger_id;

575: --
576: XLA_AE_LINES_PKG.g_rec_lines.array_balance_type_code(XLA_AE_LINES_PKG.g_LineNumber) := l_balance_type_code;
577:
578: XLA_AE_LINES_PKG.g_rec_lines.array_ledger_id(XLA_AE_LINES_PKG.g_LineNumber) :=
579: XLA_AE_JOURNAL_ENTRY_PKG.g_cache_event.target_ledger_id;
580:
581: -- 4955764
582: XLA_AE_LINES_PKG.g_rec_lines.array_gl_date(XLA_AE_LINES_PKG.g_LineNumber) :=
583: XLA_AE_HEADER_PKG.g_rec_header_new.array_gl_date(g_array_event(p_event_id).array_value_num('header_index'));

Line 643: ,p_target_ledger_id => XLA_AE_JOURNAL_ENTRY_PKG.g_cache_event.target_ledger_id) IN ('PRIMARY','ALC')

639: l_enc_upg_option := XLA_AE_LINES_PKG.g_rec_lines.array_enc_upg_option(XLA_AE_LINES_PKG.g_LineNumber);
640:
641: IF xla_accounting_cache_pkg.GetValueChar
642: (p_source_code => 'LEDGER_CATEGORY_CODE'
643: ,p_target_ledger_id => XLA_AE_JOURNAL_ENTRY_PKG.g_cache_event.target_ledger_id) IN ('PRIMARY','ALC')
644: AND l_bflow_method_code = 'PRIOR_ENTRY'
645: -- AND (l_actual_upg_option = 'Y' OR l_enc_upg_option = 'Y') Bug 4922099
646: AND ( (NVL(l_actual_upg_option, 'N') IN ('Y', 'O')) OR
647: (NVL(l_enc_upg_option, 'N') IN ('Y', 'O'))

Line 743: ,p_value_4 => XLA_AE_JOURNAL_ENTRY_PKG.g_cache_event.application_name

739: p_lookup_type => 'XLA_OWNER_TYPE'
740: ,p_lookup_code => l_component_type_code
741: )
742: ,p_token_4 => 'PRODUCT_NAME'
743: ,p_value_4 => XLA_AE_JOURNAL_ENTRY_PKG.g_cache_event.application_name
744: ,p_entity_id => XLA_AE_JOURNAL_ENTRY_PKG.g_cache_event.entity_id
745: ,p_event_id => XLA_AE_JOURNAL_ENTRY_PKG.g_cache_event.event_id
746: ,p_ledger_id => XLA_AE_JOURNAL_ENTRY_PKG.g_cache_event.target_ledger_id
747: ,p_ae_header_id => NULL

Line 744: ,p_entity_id => XLA_AE_JOURNAL_ENTRY_PKG.g_cache_event.entity_id

740: ,p_lookup_code => l_component_type_code
741: )
742: ,p_token_4 => 'PRODUCT_NAME'
743: ,p_value_4 => XLA_AE_JOURNAL_ENTRY_PKG.g_cache_event.application_name
744: ,p_entity_id => XLA_AE_JOURNAL_ENTRY_PKG.g_cache_event.entity_id
745: ,p_event_id => XLA_AE_JOURNAL_ENTRY_PKG.g_cache_event.event_id
746: ,p_ledger_id => XLA_AE_JOURNAL_ENTRY_PKG.g_cache_event.target_ledger_id
747: ,p_ae_header_id => NULL
748: );

Line 745: ,p_event_id => XLA_AE_JOURNAL_ENTRY_PKG.g_cache_event.event_id

741: )
742: ,p_token_4 => 'PRODUCT_NAME'
743: ,p_value_4 => XLA_AE_JOURNAL_ENTRY_PKG.g_cache_event.application_name
744: ,p_entity_id => XLA_AE_JOURNAL_ENTRY_PKG.g_cache_event.entity_id
745: ,p_event_id => XLA_AE_JOURNAL_ENTRY_PKG.g_cache_event.event_id
746: ,p_ledger_id => XLA_AE_JOURNAL_ENTRY_PKG.g_cache_event.target_ledger_id
747: ,p_ae_header_id => NULL
748: );
749:

Line 746: ,p_ledger_id => XLA_AE_JOURNAL_ENTRY_PKG.g_cache_event.target_ledger_id

742: ,p_token_4 => 'PRODUCT_NAME'
743: ,p_value_4 => XLA_AE_JOURNAL_ENTRY_PKG.g_cache_event.application_name
744: ,p_entity_id => XLA_AE_JOURNAL_ENTRY_PKG.g_cache_event.entity_id
745: ,p_event_id => XLA_AE_JOURNAL_ENTRY_PKG.g_cache_event.event_id
746: ,p_ledger_id => XLA_AE_JOURNAL_ENTRY_PKG.g_cache_event.target_ledger_id
747: ,p_ae_header_id => NULL
748: );
749:
750: IF (C_LEVEL_ERROR>= g_log_level) THEN

Line 777: XLA_AE_JOURNAL_ENTRY_PKG.UpdateJournalEntryStatus

773: ----------------------------------------------------------------------------------
774: -- 4219869 Business Flow
775: -- Update journal entry status -- Need to generate this within IF
776: ----------------------------------------------------------------------------------
777: XLA_AE_JOURNAL_ENTRY_PKG.UpdateJournalEntryStatus
778: (p_hdr_idx => g_array_event(p_event_id).array_value_num('header_index')
779: ,p_balance_type_code => l_balance_type_code
780: );
781:

Line 822: IF (XLA_AE_JOURNAL_ENTRY_PKG.g_cache_ledgers_info.ledger_reversal_option = 'SIDE') THEN

818:
819: --
820: -- Depending on the Reversal Method setup, do a switch side or changes sign for the amounts
821: --
822: IF (XLA_AE_JOURNAL_ENTRY_PKG.g_cache_ledgers_info.ledger_reversal_option = 'SIDE') THEN
823: XLA_AE_LINES_PKG.g_rec_lines.array_natural_side_code(XLA_AE_LINES_PKG.g_LineNumber) := l_acc_rev_natural_side_code;
824: ELSE
825: ---------------------------------------------------------------------------------------------------
826: -- 4262811a Switch Sign

Line 847: XLA_AE_JOURNAL_ENTRY_PKG.UpdateJournalEntryStatus

843:
844: XLA_AE_LINES_PKG.ValidateCurrentLine;
845: XLA_AE_LINES_PKG.SetDebitCreditAmounts;
846:
847: XLA_AE_JOURNAL_ENTRY_PKG.UpdateJournalEntryStatus
848: (p_hdr_idx => g_array_event(p_event_id).array_value_num('acc_rev_header_index')
849: ,p_balance_type_code => l_balance_type_code);
850:
851: END IF;

Line 966: l_gl_dates xla_ae_journal_entry_pkg.t_array_date;

962: l_tmp_amt NUMBER;
963: l_acc_rev_natural_side_code VARCHAR2(1);
964:
965: l_num_entries NUMBER;
966: l_gl_dates xla_ae_journal_entry_pkg.t_array_date;
967: l_accted_amts xla_ae_journal_entry_pkg.t_array_num;
968: l_entered_amts xla_ae_journal_entry_pkg.t_array_num;
969: l_period_names xla_ae_journal_entry_pkg.t_array_V15L;
970: l_recog_line_1 NUMBER;

Line 967: l_accted_amts xla_ae_journal_entry_pkg.t_array_num;

963: l_acc_rev_natural_side_code VARCHAR2(1);
964:
965: l_num_entries NUMBER;
966: l_gl_dates xla_ae_journal_entry_pkg.t_array_date;
967: l_accted_amts xla_ae_journal_entry_pkg.t_array_num;
968: l_entered_amts xla_ae_journal_entry_pkg.t_array_num;
969: l_period_names xla_ae_journal_entry_pkg.t_array_V15L;
970: l_recog_line_1 NUMBER;
971: l_recog_line_2 NUMBER;

Line 968: l_entered_amts xla_ae_journal_entry_pkg.t_array_num;

964:
965: l_num_entries NUMBER;
966: l_gl_dates xla_ae_journal_entry_pkg.t_array_date;
967: l_accted_amts xla_ae_journal_entry_pkg.t_array_num;
968: l_entered_amts xla_ae_journal_entry_pkg.t_array_num;
969: l_period_names xla_ae_journal_entry_pkg.t_array_V15L;
970: l_recog_line_1 NUMBER;
971: l_recog_line_2 NUMBER;
972:

Line 969: l_period_names xla_ae_journal_entry_pkg.t_array_V15L;

965: l_num_entries NUMBER;
966: l_gl_dates xla_ae_journal_entry_pkg.t_array_date;
967: l_accted_amts xla_ae_journal_entry_pkg.t_array_num;
968: l_entered_amts xla_ae_journal_entry_pkg.t_array_num;
969: l_period_names xla_ae_journal_entry_pkg.t_array_V15L;
970: l_recog_line_1 NUMBER;
971: l_recog_line_2 NUMBER;
972:
973: l_bflow_applied_to_amt_idx NUMBER; -- 5132302

Line 975: l_bflow_applied_to_amts xla_ae_journal_entry_pkg.t_array_num; -- 5132302

971: l_recog_line_2 NUMBER;
972:
973: l_bflow_applied_to_amt_idx NUMBER; -- 5132302
974: l_bflow_applied_to_amt NUMBER; -- 5132302
975: l_bflow_applied_to_amts xla_ae_journal_entry_pkg.t_array_num; -- 5132302
976:
977: l_event_id NUMBER; -- To handle MPA header Description: xla_ae_header_pkg.SetHdrDescription
978:
979: --l_rounding_ccy VARCHAR2(15); -- To handle MPA rounding 4262811b

Line 1050: IF XLA_AE_JOURNAL_ENTRY_PKG.g_cache_event.target_ledger_id = XLA_AE_JOURNAL_ENTRY_PKG.g_cache_event.ledger_id OR

1046: l_accrual_line_num := NULL; -- 4262811
1047: l_tmp_amt := NULL; -- 4262811
1048: --
1049:
1050: IF XLA_AE_JOURNAL_ENTRY_PKG.g_cache_event.target_ledger_id = XLA_AE_JOURNAL_ENTRY_PKG.g_cache_event.ledger_id OR
1051: l_balance_type_code <> 'B' THEN
1052: IF NVL(p_source_3,'
1053: ') = 'E' AND
1054: NVL(p_source_16,'

Line 1124: XLA_AE_JOURNAL_ENTRY_PKG.g_cache_event.target_ledger_id;

1120: --
1121: XLA_AE_LINES_PKG.g_rec_lines.array_balance_type_code(XLA_AE_LINES_PKG.g_LineNumber) := l_balance_type_code;
1122:
1123: XLA_AE_LINES_PKG.g_rec_lines.array_ledger_id(XLA_AE_LINES_PKG.g_LineNumber) :=
1124: XLA_AE_JOURNAL_ENTRY_PKG.g_cache_event.target_ledger_id;
1125:
1126: -- 4955764
1127: XLA_AE_LINES_PKG.g_rec_lines.array_gl_date(XLA_AE_LINES_PKG.g_LineNumber) :=
1128: XLA_AE_HEADER_PKG.g_rec_header_new.array_gl_date(g_array_event(p_event_id).array_value_num('header_index'));

Line 1188: ,p_target_ledger_id => XLA_AE_JOURNAL_ENTRY_PKG.g_cache_event.target_ledger_id) IN ('PRIMARY','ALC')

1184: l_enc_upg_option := XLA_AE_LINES_PKG.g_rec_lines.array_enc_upg_option(XLA_AE_LINES_PKG.g_LineNumber);
1185:
1186: IF xla_accounting_cache_pkg.GetValueChar
1187: (p_source_code => 'LEDGER_CATEGORY_CODE'
1188: ,p_target_ledger_id => XLA_AE_JOURNAL_ENTRY_PKG.g_cache_event.target_ledger_id) IN ('PRIMARY','ALC')
1189: AND l_bflow_method_code = 'PRIOR_ENTRY'
1190: -- AND (l_actual_upg_option = 'Y' OR l_enc_upg_option = 'Y') Bug 4922099
1191: AND ( (NVL(l_actual_upg_option, 'N') IN ('Y', 'O')) OR
1192: (NVL(l_enc_upg_option, 'N') IN ('Y', 'O'))

Line 1288: ,p_value_4 => XLA_AE_JOURNAL_ENTRY_PKG.g_cache_event.application_name

1284: p_lookup_type => 'XLA_OWNER_TYPE'
1285: ,p_lookup_code => l_component_type_code
1286: )
1287: ,p_token_4 => 'PRODUCT_NAME'
1288: ,p_value_4 => XLA_AE_JOURNAL_ENTRY_PKG.g_cache_event.application_name
1289: ,p_entity_id => XLA_AE_JOURNAL_ENTRY_PKG.g_cache_event.entity_id
1290: ,p_event_id => XLA_AE_JOURNAL_ENTRY_PKG.g_cache_event.event_id
1291: ,p_ledger_id => XLA_AE_JOURNAL_ENTRY_PKG.g_cache_event.target_ledger_id
1292: ,p_ae_header_id => NULL

Line 1289: ,p_entity_id => XLA_AE_JOURNAL_ENTRY_PKG.g_cache_event.entity_id

1285: ,p_lookup_code => l_component_type_code
1286: )
1287: ,p_token_4 => 'PRODUCT_NAME'
1288: ,p_value_4 => XLA_AE_JOURNAL_ENTRY_PKG.g_cache_event.application_name
1289: ,p_entity_id => XLA_AE_JOURNAL_ENTRY_PKG.g_cache_event.entity_id
1290: ,p_event_id => XLA_AE_JOURNAL_ENTRY_PKG.g_cache_event.event_id
1291: ,p_ledger_id => XLA_AE_JOURNAL_ENTRY_PKG.g_cache_event.target_ledger_id
1292: ,p_ae_header_id => NULL
1293: );

Line 1290: ,p_event_id => XLA_AE_JOURNAL_ENTRY_PKG.g_cache_event.event_id

1286: )
1287: ,p_token_4 => 'PRODUCT_NAME'
1288: ,p_value_4 => XLA_AE_JOURNAL_ENTRY_PKG.g_cache_event.application_name
1289: ,p_entity_id => XLA_AE_JOURNAL_ENTRY_PKG.g_cache_event.entity_id
1290: ,p_event_id => XLA_AE_JOURNAL_ENTRY_PKG.g_cache_event.event_id
1291: ,p_ledger_id => XLA_AE_JOURNAL_ENTRY_PKG.g_cache_event.target_ledger_id
1292: ,p_ae_header_id => NULL
1293: );
1294:

Line 1291: ,p_ledger_id => XLA_AE_JOURNAL_ENTRY_PKG.g_cache_event.target_ledger_id

1287: ,p_token_4 => 'PRODUCT_NAME'
1288: ,p_value_4 => XLA_AE_JOURNAL_ENTRY_PKG.g_cache_event.application_name
1289: ,p_entity_id => XLA_AE_JOURNAL_ENTRY_PKG.g_cache_event.entity_id
1290: ,p_event_id => XLA_AE_JOURNAL_ENTRY_PKG.g_cache_event.event_id
1291: ,p_ledger_id => XLA_AE_JOURNAL_ENTRY_PKG.g_cache_event.target_ledger_id
1292: ,p_ae_header_id => NULL
1293: );
1294:
1295: IF (C_LEVEL_ERROR>= g_log_level) THEN

Line 1322: XLA_AE_JOURNAL_ENTRY_PKG.UpdateJournalEntryStatus

1318: ----------------------------------------------------------------------------------
1319: -- 4219869 Business Flow
1320: -- Update journal entry status -- Need to generate this within IF
1321: ----------------------------------------------------------------------------------
1322: XLA_AE_JOURNAL_ENTRY_PKG.UpdateJournalEntryStatus
1323: (p_hdr_idx => g_array_event(p_event_id).array_value_num('header_index')
1324: ,p_balance_type_code => l_balance_type_code
1325: );
1326:

Line 1367: IF (XLA_AE_JOURNAL_ENTRY_PKG.g_cache_ledgers_info.ledger_reversal_option = 'SIDE') THEN

1363:
1364: --
1365: -- Depending on the Reversal Method setup, do a switch side or changes sign for the amounts
1366: --
1367: IF (XLA_AE_JOURNAL_ENTRY_PKG.g_cache_ledgers_info.ledger_reversal_option = 'SIDE') THEN
1368: XLA_AE_LINES_PKG.g_rec_lines.array_natural_side_code(XLA_AE_LINES_PKG.g_LineNumber) := l_acc_rev_natural_side_code;
1369: ELSE
1370: ---------------------------------------------------------------------------------------------------
1371: -- 4262811a Switch Sign

Line 1392: XLA_AE_JOURNAL_ENTRY_PKG.UpdateJournalEntryStatus

1388:
1389: XLA_AE_LINES_PKG.ValidateCurrentLine;
1390: XLA_AE_LINES_PKG.SetDebitCreditAmounts;
1391:
1392: XLA_AE_JOURNAL_ENTRY_PKG.UpdateJournalEntryStatus
1393: (p_hdr_idx => g_array_event(p_event_id).array_value_num('acc_rev_header_index')
1394: ,p_balance_type_code => l_balance_type_code);
1395:
1396: END IF;

Line 1509: l_gl_dates xla_ae_journal_entry_pkg.t_array_date;

1505: l_tmp_amt NUMBER;
1506: l_acc_rev_natural_side_code VARCHAR2(1);
1507:
1508: l_num_entries NUMBER;
1509: l_gl_dates xla_ae_journal_entry_pkg.t_array_date;
1510: l_accted_amts xla_ae_journal_entry_pkg.t_array_num;
1511: l_entered_amts xla_ae_journal_entry_pkg.t_array_num;
1512: l_period_names xla_ae_journal_entry_pkg.t_array_V15L;
1513: l_recog_line_1 NUMBER;

Line 1510: l_accted_amts xla_ae_journal_entry_pkg.t_array_num;

1506: l_acc_rev_natural_side_code VARCHAR2(1);
1507:
1508: l_num_entries NUMBER;
1509: l_gl_dates xla_ae_journal_entry_pkg.t_array_date;
1510: l_accted_amts xla_ae_journal_entry_pkg.t_array_num;
1511: l_entered_amts xla_ae_journal_entry_pkg.t_array_num;
1512: l_period_names xla_ae_journal_entry_pkg.t_array_V15L;
1513: l_recog_line_1 NUMBER;
1514: l_recog_line_2 NUMBER;

Line 1511: l_entered_amts xla_ae_journal_entry_pkg.t_array_num;

1507:
1508: l_num_entries NUMBER;
1509: l_gl_dates xla_ae_journal_entry_pkg.t_array_date;
1510: l_accted_amts xla_ae_journal_entry_pkg.t_array_num;
1511: l_entered_amts xla_ae_journal_entry_pkg.t_array_num;
1512: l_period_names xla_ae_journal_entry_pkg.t_array_V15L;
1513: l_recog_line_1 NUMBER;
1514: l_recog_line_2 NUMBER;
1515:

Line 1512: l_period_names xla_ae_journal_entry_pkg.t_array_V15L;

1508: l_num_entries NUMBER;
1509: l_gl_dates xla_ae_journal_entry_pkg.t_array_date;
1510: l_accted_amts xla_ae_journal_entry_pkg.t_array_num;
1511: l_entered_amts xla_ae_journal_entry_pkg.t_array_num;
1512: l_period_names xla_ae_journal_entry_pkg.t_array_V15L;
1513: l_recog_line_1 NUMBER;
1514: l_recog_line_2 NUMBER;
1515:
1516: l_bflow_applied_to_amt_idx NUMBER; -- 5132302

Line 1518: l_bflow_applied_to_amts xla_ae_journal_entry_pkg.t_array_num; -- 5132302

1514: l_recog_line_2 NUMBER;
1515:
1516: l_bflow_applied_to_amt_idx NUMBER; -- 5132302
1517: l_bflow_applied_to_amt NUMBER; -- 5132302
1518: l_bflow_applied_to_amts xla_ae_journal_entry_pkg.t_array_num; -- 5132302
1519:
1520: l_event_id NUMBER; -- To handle MPA header Description: xla_ae_header_pkg.SetHdrDescription
1521:
1522: --l_rounding_ccy VARCHAR2(15); -- To handle MPA rounding 4262811b

Line 1593: IF XLA_AE_JOURNAL_ENTRY_PKG.g_cache_event.target_ledger_id = XLA_AE_JOURNAL_ENTRY_PKG.g_cache_event.ledger_id OR

1589: l_accrual_line_num := NULL; -- 4262811
1590: l_tmp_amt := NULL; -- 4262811
1591: --
1592:
1593: IF XLA_AE_JOURNAL_ENTRY_PKG.g_cache_event.target_ledger_id = XLA_AE_JOURNAL_ENTRY_PKG.g_cache_event.ledger_id OR
1594: l_balance_type_code <> 'B' THEN
1595: IF NVL(p_source_2,'
1596: ') = 'R'
1597: THEN

Line 1665: XLA_AE_JOURNAL_ENTRY_PKG.g_cache_event.target_ledger_id;

1661: --
1662: XLA_AE_LINES_PKG.g_rec_lines.array_balance_type_code(XLA_AE_LINES_PKG.g_LineNumber) := l_balance_type_code;
1663:
1664: XLA_AE_LINES_PKG.g_rec_lines.array_ledger_id(XLA_AE_LINES_PKG.g_LineNumber) :=
1665: XLA_AE_JOURNAL_ENTRY_PKG.g_cache_event.target_ledger_id;
1666:
1667: -- 4955764
1668: XLA_AE_LINES_PKG.g_rec_lines.array_gl_date(XLA_AE_LINES_PKG.g_LineNumber) :=
1669: XLA_AE_HEADER_PKG.g_rec_header_new.array_gl_date(g_array_event(p_event_id).array_value_num('header_index'));

Line 1729: ,p_target_ledger_id => XLA_AE_JOURNAL_ENTRY_PKG.g_cache_event.target_ledger_id) IN ('PRIMARY','ALC')

1725: l_enc_upg_option := XLA_AE_LINES_PKG.g_rec_lines.array_enc_upg_option(XLA_AE_LINES_PKG.g_LineNumber);
1726:
1727: IF xla_accounting_cache_pkg.GetValueChar
1728: (p_source_code => 'LEDGER_CATEGORY_CODE'
1729: ,p_target_ledger_id => XLA_AE_JOURNAL_ENTRY_PKG.g_cache_event.target_ledger_id) IN ('PRIMARY','ALC')
1730: AND l_bflow_method_code = 'PRIOR_ENTRY'
1731: -- AND (l_actual_upg_option = 'Y' OR l_enc_upg_option = 'Y') Bug 4922099
1732: AND ( (NVL(l_actual_upg_option, 'N') IN ('Y', 'O')) OR
1733: (NVL(l_enc_upg_option, 'N') IN ('Y', 'O'))

Line 1829: ,p_value_4 => XLA_AE_JOURNAL_ENTRY_PKG.g_cache_event.application_name

1825: p_lookup_type => 'XLA_OWNER_TYPE'
1826: ,p_lookup_code => l_component_type_code
1827: )
1828: ,p_token_4 => 'PRODUCT_NAME'
1829: ,p_value_4 => XLA_AE_JOURNAL_ENTRY_PKG.g_cache_event.application_name
1830: ,p_entity_id => XLA_AE_JOURNAL_ENTRY_PKG.g_cache_event.entity_id
1831: ,p_event_id => XLA_AE_JOURNAL_ENTRY_PKG.g_cache_event.event_id
1832: ,p_ledger_id => XLA_AE_JOURNAL_ENTRY_PKG.g_cache_event.target_ledger_id
1833: ,p_ae_header_id => NULL

Line 1830: ,p_entity_id => XLA_AE_JOURNAL_ENTRY_PKG.g_cache_event.entity_id

1826: ,p_lookup_code => l_component_type_code
1827: )
1828: ,p_token_4 => 'PRODUCT_NAME'
1829: ,p_value_4 => XLA_AE_JOURNAL_ENTRY_PKG.g_cache_event.application_name
1830: ,p_entity_id => XLA_AE_JOURNAL_ENTRY_PKG.g_cache_event.entity_id
1831: ,p_event_id => XLA_AE_JOURNAL_ENTRY_PKG.g_cache_event.event_id
1832: ,p_ledger_id => XLA_AE_JOURNAL_ENTRY_PKG.g_cache_event.target_ledger_id
1833: ,p_ae_header_id => NULL
1834: );

Line 1831: ,p_event_id => XLA_AE_JOURNAL_ENTRY_PKG.g_cache_event.event_id

1827: )
1828: ,p_token_4 => 'PRODUCT_NAME'
1829: ,p_value_4 => XLA_AE_JOURNAL_ENTRY_PKG.g_cache_event.application_name
1830: ,p_entity_id => XLA_AE_JOURNAL_ENTRY_PKG.g_cache_event.entity_id
1831: ,p_event_id => XLA_AE_JOURNAL_ENTRY_PKG.g_cache_event.event_id
1832: ,p_ledger_id => XLA_AE_JOURNAL_ENTRY_PKG.g_cache_event.target_ledger_id
1833: ,p_ae_header_id => NULL
1834: );
1835:

Line 1832: ,p_ledger_id => XLA_AE_JOURNAL_ENTRY_PKG.g_cache_event.target_ledger_id

1828: ,p_token_4 => 'PRODUCT_NAME'
1829: ,p_value_4 => XLA_AE_JOURNAL_ENTRY_PKG.g_cache_event.application_name
1830: ,p_entity_id => XLA_AE_JOURNAL_ENTRY_PKG.g_cache_event.entity_id
1831: ,p_event_id => XLA_AE_JOURNAL_ENTRY_PKG.g_cache_event.event_id
1832: ,p_ledger_id => XLA_AE_JOURNAL_ENTRY_PKG.g_cache_event.target_ledger_id
1833: ,p_ae_header_id => NULL
1834: );
1835:
1836: IF (C_LEVEL_ERROR>= g_log_level) THEN

Line 1863: XLA_AE_JOURNAL_ENTRY_PKG.UpdateJournalEntryStatus

1859: ----------------------------------------------------------------------------------
1860: -- 4219869 Business Flow
1861: -- Update journal entry status -- Need to generate this within IF
1862: ----------------------------------------------------------------------------------
1863: XLA_AE_JOURNAL_ENTRY_PKG.UpdateJournalEntryStatus
1864: (p_hdr_idx => g_array_event(p_event_id).array_value_num('header_index')
1865: ,p_balance_type_code => l_balance_type_code
1866: );
1867:

Line 1908: IF (XLA_AE_JOURNAL_ENTRY_PKG.g_cache_ledgers_info.ledger_reversal_option = 'SIDE') THEN

1904:
1905: --
1906: -- Depending on the Reversal Method setup, do a switch side or changes sign for the amounts
1907: --
1908: IF (XLA_AE_JOURNAL_ENTRY_PKG.g_cache_ledgers_info.ledger_reversal_option = 'SIDE') THEN
1909: XLA_AE_LINES_PKG.g_rec_lines.array_natural_side_code(XLA_AE_LINES_PKG.g_LineNumber) := l_acc_rev_natural_side_code;
1910: ELSE
1911: ---------------------------------------------------------------------------------------------------
1912: -- 4262811a Switch Sign

Line 1933: XLA_AE_JOURNAL_ENTRY_PKG.UpdateJournalEntryStatus

1929:
1930: XLA_AE_LINES_PKG.ValidateCurrentLine;
1931: XLA_AE_LINES_PKG.SetDebitCreditAmounts;
1932:
1933: XLA_AE_JOURNAL_ENTRY_PKG.UpdateJournalEntryStatus
1934: (p_hdr_idx => g_array_event(p_event_id).array_value_num('acc_rev_header_index')
1935: ,p_balance_type_code => l_balance_type_code);
1936:
1937: END IF;

Line 2355: l_array_legal_entity_id XLA_AE_JOURNAL_ENTRY_PKG.t_array_Num;

2351:
2352: l_calculate_acctd_flag VARCHAR2(1) :='N';
2353: l_calculate_g_l_flag VARCHAR2(1) :='N';
2354: --
2355: l_array_legal_entity_id XLA_AE_JOURNAL_ENTRY_PKG.t_array_Num;
2356: l_array_entity_id XLA_AE_JOURNAL_ENTRY_PKG.t_array_Num;
2357: l_array_entity_code XLA_AE_JOURNAL_ENTRY_PKG.t_array_V30L;
2358: l_array_transaction_num XLA_AE_JOURNAL_ENTRY_PKG.t_array_V240L;
2359: l_array_event_id XLA_AE_JOURNAL_ENTRY_PKG.t_array_Num;

Line 2356: l_array_entity_id XLA_AE_JOURNAL_ENTRY_PKG.t_array_Num;

2352: l_calculate_acctd_flag VARCHAR2(1) :='N';
2353: l_calculate_g_l_flag VARCHAR2(1) :='N';
2354: --
2355: l_array_legal_entity_id XLA_AE_JOURNAL_ENTRY_PKG.t_array_Num;
2356: l_array_entity_id XLA_AE_JOURNAL_ENTRY_PKG.t_array_Num;
2357: l_array_entity_code XLA_AE_JOURNAL_ENTRY_PKG.t_array_V30L;
2358: l_array_transaction_num XLA_AE_JOURNAL_ENTRY_PKG.t_array_V240L;
2359: l_array_event_id XLA_AE_JOURNAL_ENTRY_PKG.t_array_Num;
2360: l_array_class_code XLA_AE_JOURNAL_ENTRY_PKG.t_array_V30L;

Line 2357: l_array_entity_code XLA_AE_JOURNAL_ENTRY_PKG.t_array_V30L;

2353: l_calculate_g_l_flag VARCHAR2(1) :='N';
2354: --
2355: l_array_legal_entity_id XLA_AE_JOURNAL_ENTRY_PKG.t_array_Num;
2356: l_array_entity_id XLA_AE_JOURNAL_ENTRY_PKG.t_array_Num;
2357: l_array_entity_code XLA_AE_JOURNAL_ENTRY_PKG.t_array_V30L;
2358: l_array_transaction_num XLA_AE_JOURNAL_ENTRY_PKG.t_array_V240L;
2359: l_array_event_id XLA_AE_JOURNAL_ENTRY_PKG.t_array_Num;
2360: l_array_class_code XLA_AE_JOURNAL_ENTRY_PKG.t_array_V30L;
2361: l_array_event_type XLA_AE_JOURNAL_ENTRY_PKG.t_array_V30L;

Line 2358: l_array_transaction_num XLA_AE_JOURNAL_ENTRY_PKG.t_array_V240L;

2354: --
2355: l_array_legal_entity_id XLA_AE_JOURNAL_ENTRY_PKG.t_array_Num;
2356: l_array_entity_id XLA_AE_JOURNAL_ENTRY_PKG.t_array_Num;
2357: l_array_entity_code XLA_AE_JOURNAL_ENTRY_PKG.t_array_V30L;
2358: l_array_transaction_num XLA_AE_JOURNAL_ENTRY_PKG.t_array_V240L;
2359: l_array_event_id XLA_AE_JOURNAL_ENTRY_PKG.t_array_Num;
2360: l_array_class_code XLA_AE_JOURNAL_ENTRY_PKG.t_array_V30L;
2361: l_array_event_type XLA_AE_JOURNAL_ENTRY_PKG.t_array_V30L;
2362: l_array_event_number XLA_AE_JOURNAL_ENTRY_PKG.t_array_Num;

Line 2359: l_array_event_id XLA_AE_JOURNAL_ENTRY_PKG.t_array_Num;

2355: l_array_legal_entity_id XLA_AE_JOURNAL_ENTRY_PKG.t_array_Num;
2356: l_array_entity_id XLA_AE_JOURNAL_ENTRY_PKG.t_array_Num;
2357: l_array_entity_code XLA_AE_JOURNAL_ENTRY_PKG.t_array_V30L;
2358: l_array_transaction_num XLA_AE_JOURNAL_ENTRY_PKG.t_array_V240L;
2359: l_array_event_id XLA_AE_JOURNAL_ENTRY_PKG.t_array_Num;
2360: l_array_class_code XLA_AE_JOURNAL_ENTRY_PKG.t_array_V30L;
2361: l_array_event_type XLA_AE_JOURNAL_ENTRY_PKG.t_array_V30L;
2362: l_array_event_number XLA_AE_JOURNAL_ENTRY_PKG.t_array_Num;
2363: l_array_event_date XLA_AE_JOURNAL_ENTRY_PKG.t_array_Date;

Line 2360: l_array_class_code XLA_AE_JOURNAL_ENTRY_PKG.t_array_V30L;

2356: l_array_entity_id XLA_AE_JOURNAL_ENTRY_PKG.t_array_Num;
2357: l_array_entity_code XLA_AE_JOURNAL_ENTRY_PKG.t_array_V30L;
2358: l_array_transaction_num XLA_AE_JOURNAL_ENTRY_PKG.t_array_V240L;
2359: l_array_event_id XLA_AE_JOURNAL_ENTRY_PKG.t_array_Num;
2360: l_array_class_code XLA_AE_JOURNAL_ENTRY_PKG.t_array_V30L;
2361: l_array_event_type XLA_AE_JOURNAL_ENTRY_PKG.t_array_V30L;
2362: l_array_event_number XLA_AE_JOURNAL_ENTRY_PKG.t_array_Num;
2363: l_array_event_date XLA_AE_JOURNAL_ENTRY_PKG.t_array_Date;
2364: l_array_transaction_date XLA_AE_JOURNAL_ENTRY_PKG.t_array_Date;

Line 2361: l_array_event_type XLA_AE_JOURNAL_ENTRY_PKG.t_array_V30L;

2357: l_array_entity_code XLA_AE_JOURNAL_ENTRY_PKG.t_array_V30L;
2358: l_array_transaction_num XLA_AE_JOURNAL_ENTRY_PKG.t_array_V240L;
2359: l_array_event_id XLA_AE_JOURNAL_ENTRY_PKG.t_array_Num;
2360: l_array_class_code XLA_AE_JOURNAL_ENTRY_PKG.t_array_V30L;
2361: l_array_event_type XLA_AE_JOURNAL_ENTRY_PKG.t_array_V30L;
2362: l_array_event_number XLA_AE_JOURNAL_ENTRY_PKG.t_array_Num;
2363: l_array_event_date XLA_AE_JOURNAL_ENTRY_PKG.t_array_Date;
2364: l_array_transaction_date XLA_AE_JOURNAL_ENTRY_PKG.t_array_Date;
2365: l_array_reference_num_1 XLA_AE_JOURNAL_ENTRY_PKG.t_array_Num;

Line 2362: l_array_event_number XLA_AE_JOURNAL_ENTRY_PKG.t_array_Num;

2358: l_array_transaction_num XLA_AE_JOURNAL_ENTRY_PKG.t_array_V240L;
2359: l_array_event_id XLA_AE_JOURNAL_ENTRY_PKG.t_array_Num;
2360: l_array_class_code XLA_AE_JOURNAL_ENTRY_PKG.t_array_V30L;
2361: l_array_event_type XLA_AE_JOURNAL_ENTRY_PKG.t_array_V30L;
2362: l_array_event_number XLA_AE_JOURNAL_ENTRY_PKG.t_array_Num;
2363: l_array_event_date XLA_AE_JOURNAL_ENTRY_PKG.t_array_Date;
2364: l_array_transaction_date XLA_AE_JOURNAL_ENTRY_PKG.t_array_Date;
2365: l_array_reference_num_1 XLA_AE_JOURNAL_ENTRY_PKG.t_array_Num;
2366: l_array_reference_num_2 XLA_AE_JOURNAL_ENTRY_PKG.t_array_Num;

Line 2363: l_array_event_date XLA_AE_JOURNAL_ENTRY_PKG.t_array_Date;

2359: l_array_event_id XLA_AE_JOURNAL_ENTRY_PKG.t_array_Num;
2360: l_array_class_code XLA_AE_JOURNAL_ENTRY_PKG.t_array_V30L;
2361: l_array_event_type XLA_AE_JOURNAL_ENTRY_PKG.t_array_V30L;
2362: l_array_event_number XLA_AE_JOURNAL_ENTRY_PKG.t_array_Num;
2363: l_array_event_date XLA_AE_JOURNAL_ENTRY_PKG.t_array_Date;
2364: l_array_transaction_date XLA_AE_JOURNAL_ENTRY_PKG.t_array_Date;
2365: l_array_reference_num_1 XLA_AE_JOURNAL_ENTRY_PKG.t_array_Num;
2366: l_array_reference_num_2 XLA_AE_JOURNAL_ENTRY_PKG.t_array_Num;
2367: l_array_reference_num_3 XLA_AE_JOURNAL_ENTRY_PKG.t_array_Num;

Line 2364: l_array_transaction_date XLA_AE_JOURNAL_ENTRY_PKG.t_array_Date;

2360: l_array_class_code XLA_AE_JOURNAL_ENTRY_PKG.t_array_V30L;
2361: l_array_event_type XLA_AE_JOURNAL_ENTRY_PKG.t_array_V30L;
2362: l_array_event_number XLA_AE_JOURNAL_ENTRY_PKG.t_array_Num;
2363: l_array_event_date XLA_AE_JOURNAL_ENTRY_PKG.t_array_Date;
2364: l_array_transaction_date XLA_AE_JOURNAL_ENTRY_PKG.t_array_Date;
2365: l_array_reference_num_1 XLA_AE_JOURNAL_ENTRY_PKG.t_array_Num;
2366: l_array_reference_num_2 XLA_AE_JOURNAL_ENTRY_PKG.t_array_Num;
2367: l_array_reference_num_3 XLA_AE_JOURNAL_ENTRY_PKG.t_array_Num;
2368: l_array_reference_num_4 XLA_AE_JOURNAL_ENTRY_PKG.t_array_Num;

Line 2365: l_array_reference_num_1 XLA_AE_JOURNAL_ENTRY_PKG.t_array_Num;

2361: l_array_event_type XLA_AE_JOURNAL_ENTRY_PKG.t_array_V30L;
2362: l_array_event_number XLA_AE_JOURNAL_ENTRY_PKG.t_array_Num;
2363: l_array_event_date XLA_AE_JOURNAL_ENTRY_PKG.t_array_Date;
2364: l_array_transaction_date XLA_AE_JOURNAL_ENTRY_PKG.t_array_Date;
2365: l_array_reference_num_1 XLA_AE_JOURNAL_ENTRY_PKG.t_array_Num;
2366: l_array_reference_num_2 XLA_AE_JOURNAL_ENTRY_PKG.t_array_Num;
2367: l_array_reference_num_3 XLA_AE_JOURNAL_ENTRY_PKG.t_array_Num;
2368: l_array_reference_num_4 XLA_AE_JOURNAL_ENTRY_PKG.t_array_Num;
2369: l_array_reference_char_1 XLA_AE_JOURNAL_ENTRY_PKG.t_array_V240L;

Line 2366: l_array_reference_num_2 XLA_AE_JOURNAL_ENTRY_PKG.t_array_Num;

2362: l_array_event_number XLA_AE_JOURNAL_ENTRY_PKG.t_array_Num;
2363: l_array_event_date XLA_AE_JOURNAL_ENTRY_PKG.t_array_Date;
2364: l_array_transaction_date XLA_AE_JOURNAL_ENTRY_PKG.t_array_Date;
2365: l_array_reference_num_1 XLA_AE_JOURNAL_ENTRY_PKG.t_array_Num;
2366: l_array_reference_num_2 XLA_AE_JOURNAL_ENTRY_PKG.t_array_Num;
2367: l_array_reference_num_3 XLA_AE_JOURNAL_ENTRY_PKG.t_array_Num;
2368: l_array_reference_num_4 XLA_AE_JOURNAL_ENTRY_PKG.t_array_Num;
2369: l_array_reference_char_1 XLA_AE_JOURNAL_ENTRY_PKG.t_array_V240L;
2370: l_array_reference_char_2 XLA_AE_JOURNAL_ENTRY_PKG.t_array_V240L;

Line 2367: l_array_reference_num_3 XLA_AE_JOURNAL_ENTRY_PKG.t_array_Num;

2363: l_array_event_date XLA_AE_JOURNAL_ENTRY_PKG.t_array_Date;
2364: l_array_transaction_date XLA_AE_JOURNAL_ENTRY_PKG.t_array_Date;
2365: l_array_reference_num_1 XLA_AE_JOURNAL_ENTRY_PKG.t_array_Num;
2366: l_array_reference_num_2 XLA_AE_JOURNAL_ENTRY_PKG.t_array_Num;
2367: l_array_reference_num_3 XLA_AE_JOURNAL_ENTRY_PKG.t_array_Num;
2368: l_array_reference_num_4 XLA_AE_JOURNAL_ENTRY_PKG.t_array_Num;
2369: l_array_reference_char_1 XLA_AE_JOURNAL_ENTRY_PKG.t_array_V240L;
2370: l_array_reference_char_2 XLA_AE_JOURNAL_ENTRY_PKG.t_array_V240L;
2371: l_array_reference_char_3 XLA_AE_JOURNAL_ENTRY_PKG.t_array_V240L;

Line 2368: l_array_reference_num_4 XLA_AE_JOURNAL_ENTRY_PKG.t_array_Num;

2364: l_array_transaction_date XLA_AE_JOURNAL_ENTRY_PKG.t_array_Date;
2365: l_array_reference_num_1 XLA_AE_JOURNAL_ENTRY_PKG.t_array_Num;
2366: l_array_reference_num_2 XLA_AE_JOURNAL_ENTRY_PKG.t_array_Num;
2367: l_array_reference_num_3 XLA_AE_JOURNAL_ENTRY_PKG.t_array_Num;
2368: l_array_reference_num_4 XLA_AE_JOURNAL_ENTRY_PKG.t_array_Num;
2369: l_array_reference_char_1 XLA_AE_JOURNAL_ENTRY_PKG.t_array_V240L;
2370: l_array_reference_char_2 XLA_AE_JOURNAL_ENTRY_PKG.t_array_V240L;
2371: l_array_reference_char_3 XLA_AE_JOURNAL_ENTRY_PKG.t_array_V240L;
2372: l_array_reference_char_4 XLA_AE_JOURNAL_ENTRY_PKG.t_array_V240L;

Line 2369: l_array_reference_char_1 XLA_AE_JOURNAL_ENTRY_PKG.t_array_V240L;

2365: l_array_reference_num_1 XLA_AE_JOURNAL_ENTRY_PKG.t_array_Num;
2366: l_array_reference_num_2 XLA_AE_JOURNAL_ENTRY_PKG.t_array_Num;
2367: l_array_reference_num_3 XLA_AE_JOURNAL_ENTRY_PKG.t_array_Num;
2368: l_array_reference_num_4 XLA_AE_JOURNAL_ENTRY_PKG.t_array_Num;
2369: l_array_reference_char_1 XLA_AE_JOURNAL_ENTRY_PKG.t_array_V240L;
2370: l_array_reference_char_2 XLA_AE_JOURNAL_ENTRY_PKG.t_array_V240L;
2371: l_array_reference_char_3 XLA_AE_JOURNAL_ENTRY_PKG.t_array_V240L;
2372: l_array_reference_char_4 XLA_AE_JOURNAL_ENTRY_PKG.t_array_V240L;
2373: l_array_reference_date_1 XLA_AE_JOURNAL_ENTRY_PKG.t_array_Date;

Line 2370: l_array_reference_char_2 XLA_AE_JOURNAL_ENTRY_PKG.t_array_V240L;

2366: l_array_reference_num_2 XLA_AE_JOURNAL_ENTRY_PKG.t_array_Num;
2367: l_array_reference_num_3 XLA_AE_JOURNAL_ENTRY_PKG.t_array_Num;
2368: l_array_reference_num_4 XLA_AE_JOURNAL_ENTRY_PKG.t_array_Num;
2369: l_array_reference_char_1 XLA_AE_JOURNAL_ENTRY_PKG.t_array_V240L;
2370: l_array_reference_char_2 XLA_AE_JOURNAL_ENTRY_PKG.t_array_V240L;
2371: l_array_reference_char_3 XLA_AE_JOURNAL_ENTRY_PKG.t_array_V240L;
2372: l_array_reference_char_4 XLA_AE_JOURNAL_ENTRY_PKG.t_array_V240L;
2373: l_array_reference_date_1 XLA_AE_JOURNAL_ENTRY_PKG.t_array_Date;
2374: l_array_reference_date_2 XLA_AE_JOURNAL_ENTRY_PKG.t_array_Date;

Line 2371: l_array_reference_char_3 XLA_AE_JOURNAL_ENTRY_PKG.t_array_V240L;

2367: l_array_reference_num_3 XLA_AE_JOURNAL_ENTRY_PKG.t_array_Num;
2368: l_array_reference_num_4 XLA_AE_JOURNAL_ENTRY_PKG.t_array_Num;
2369: l_array_reference_char_1 XLA_AE_JOURNAL_ENTRY_PKG.t_array_V240L;
2370: l_array_reference_char_2 XLA_AE_JOURNAL_ENTRY_PKG.t_array_V240L;
2371: l_array_reference_char_3 XLA_AE_JOURNAL_ENTRY_PKG.t_array_V240L;
2372: l_array_reference_char_4 XLA_AE_JOURNAL_ENTRY_PKG.t_array_V240L;
2373: l_array_reference_date_1 XLA_AE_JOURNAL_ENTRY_PKG.t_array_Date;
2374: l_array_reference_date_2 XLA_AE_JOURNAL_ENTRY_PKG.t_array_Date;
2375: l_array_reference_date_3 XLA_AE_JOURNAL_ENTRY_PKG.t_array_Date;

Line 2372: l_array_reference_char_4 XLA_AE_JOURNAL_ENTRY_PKG.t_array_V240L;

2368: l_array_reference_num_4 XLA_AE_JOURNAL_ENTRY_PKG.t_array_Num;
2369: l_array_reference_char_1 XLA_AE_JOURNAL_ENTRY_PKG.t_array_V240L;
2370: l_array_reference_char_2 XLA_AE_JOURNAL_ENTRY_PKG.t_array_V240L;
2371: l_array_reference_char_3 XLA_AE_JOURNAL_ENTRY_PKG.t_array_V240L;
2372: l_array_reference_char_4 XLA_AE_JOURNAL_ENTRY_PKG.t_array_V240L;
2373: l_array_reference_date_1 XLA_AE_JOURNAL_ENTRY_PKG.t_array_Date;
2374: l_array_reference_date_2 XLA_AE_JOURNAL_ENTRY_PKG.t_array_Date;
2375: l_array_reference_date_3 XLA_AE_JOURNAL_ENTRY_PKG.t_array_Date;
2376: l_array_reference_date_4 XLA_AE_JOURNAL_ENTRY_PKG.t_array_Date;

Line 2373: l_array_reference_date_1 XLA_AE_JOURNAL_ENTRY_PKG.t_array_Date;

2369: l_array_reference_char_1 XLA_AE_JOURNAL_ENTRY_PKG.t_array_V240L;
2370: l_array_reference_char_2 XLA_AE_JOURNAL_ENTRY_PKG.t_array_V240L;
2371: l_array_reference_char_3 XLA_AE_JOURNAL_ENTRY_PKG.t_array_V240L;
2372: l_array_reference_char_4 XLA_AE_JOURNAL_ENTRY_PKG.t_array_V240L;
2373: l_array_reference_date_1 XLA_AE_JOURNAL_ENTRY_PKG.t_array_Date;
2374: l_array_reference_date_2 XLA_AE_JOURNAL_ENTRY_PKG.t_array_Date;
2375: l_array_reference_date_3 XLA_AE_JOURNAL_ENTRY_PKG.t_array_Date;
2376: l_array_reference_date_4 XLA_AE_JOURNAL_ENTRY_PKG.t_array_Date;
2377: l_array_event_created_by XLA_AE_JOURNAL_ENTRY_PKG.t_array_V100L;

Line 2374: l_array_reference_date_2 XLA_AE_JOURNAL_ENTRY_PKG.t_array_Date;

2370: l_array_reference_char_2 XLA_AE_JOURNAL_ENTRY_PKG.t_array_V240L;
2371: l_array_reference_char_3 XLA_AE_JOURNAL_ENTRY_PKG.t_array_V240L;
2372: l_array_reference_char_4 XLA_AE_JOURNAL_ENTRY_PKG.t_array_V240L;
2373: l_array_reference_date_1 XLA_AE_JOURNAL_ENTRY_PKG.t_array_Date;
2374: l_array_reference_date_2 XLA_AE_JOURNAL_ENTRY_PKG.t_array_Date;
2375: l_array_reference_date_3 XLA_AE_JOURNAL_ENTRY_PKG.t_array_Date;
2376: l_array_reference_date_4 XLA_AE_JOURNAL_ENTRY_PKG.t_array_Date;
2377: l_array_event_created_by XLA_AE_JOURNAL_ENTRY_PKG.t_array_V100L;
2378: l_array_budgetary_control_flag XLA_AE_JOURNAL_ENTRY_PKG.t_array_V30L;

Line 2375: l_array_reference_date_3 XLA_AE_JOURNAL_ENTRY_PKG.t_array_Date;

2371: l_array_reference_char_3 XLA_AE_JOURNAL_ENTRY_PKG.t_array_V240L;
2372: l_array_reference_char_4 XLA_AE_JOURNAL_ENTRY_PKG.t_array_V240L;
2373: l_array_reference_date_1 XLA_AE_JOURNAL_ENTRY_PKG.t_array_Date;
2374: l_array_reference_date_2 XLA_AE_JOURNAL_ENTRY_PKG.t_array_Date;
2375: l_array_reference_date_3 XLA_AE_JOURNAL_ENTRY_PKG.t_array_Date;
2376: l_array_reference_date_4 XLA_AE_JOURNAL_ENTRY_PKG.t_array_Date;
2377: l_array_event_created_by XLA_AE_JOURNAL_ENTRY_PKG.t_array_V100L;
2378: l_array_budgetary_control_flag XLA_AE_JOURNAL_ENTRY_PKG.t_array_V30L;
2379:

Line 2376: l_array_reference_date_4 XLA_AE_JOURNAL_ENTRY_PKG.t_array_Date;

2372: l_array_reference_char_4 XLA_AE_JOURNAL_ENTRY_PKG.t_array_V240L;
2373: l_array_reference_date_1 XLA_AE_JOURNAL_ENTRY_PKG.t_array_Date;
2374: l_array_reference_date_2 XLA_AE_JOURNAL_ENTRY_PKG.t_array_Date;
2375: l_array_reference_date_3 XLA_AE_JOURNAL_ENTRY_PKG.t_array_Date;
2376: l_array_reference_date_4 XLA_AE_JOURNAL_ENTRY_PKG.t_array_Date;
2377: l_array_event_created_by XLA_AE_JOURNAL_ENTRY_PKG.t_array_V100L;
2378: l_array_budgetary_control_flag XLA_AE_JOURNAL_ENTRY_PKG.t_array_V30L;
2379:
2380: l_event_id NUMBER;

Line 2377: l_array_event_created_by XLA_AE_JOURNAL_ENTRY_PKG.t_array_V100L;

2373: l_array_reference_date_1 XLA_AE_JOURNAL_ENTRY_PKG.t_array_Date;
2374: l_array_reference_date_2 XLA_AE_JOURNAL_ENTRY_PKG.t_array_Date;
2375: l_array_reference_date_3 XLA_AE_JOURNAL_ENTRY_PKG.t_array_Date;
2376: l_array_reference_date_4 XLA_AE_JOURNAL_ENTRY_PKG.t_array_Date;
2377: l_array_event_created_by XLA_AE_JOURNAL_ENTRY_PKG.t_array_V100L;
2378: l_array_budgetary_control_flag XLA_AE_JOURNAL_ENTRY_PKG.t_array_V30L;
2379:
2380: l_event_id NUMBER;
2381: l_previous_event_id NUMBER;

Line 2378: l_array_budgetary_control_flag XLA_AE_JOURNAL_ENTRY_PKG.t_array_V30L;

2374: l_array_reference_date_2 XLA_AE_JOURNAL_ENTRY_PKG.t_array_Date;
2375: l_array_reference_date_3 XLA_AE_JOURNAL_ENTRY_PKG.t_array_Date;
2376: l_array_reference_date_4 XLA_AE_JOURNAL_ENTRY_PKG.t_array_Date;
2377: l_array_event_created_by XLA_AE_JOURNAL_ENTRY_PKG.t_array_V100L;
2378: l_array_budgetary_control_flag XLA_AE_JOURNAL_ENTRY_PKG.t_array_V30L;
2379:
2380: l_event_id NUMBER;
2381: l_previous_event_id NUMBER;
2382: l_first_event_id NUMBER;

Line 2396: l_array_extract_line_num xla_ae_journal_entry_pkg.t_array_Num;

2392: l_event_class_name VARCHAR2(80) := 'Budget';
2393: l_description VARCHAR2(4000);
2394: l_transaction_reversal NUMBER;
2395: l_ae_header_id NUMBER;
2396: l_array_extract_line_num xla_ae_journal_entry_pkg.t_array_Num;
2397: l_log_module VARCHAR2(240);
2398: --
2399: l_acct_reversal_source VARCHAR2(30);
2400: l_trx_reversal_source VARCHAR2(30);

Line 2671: XLA_AE_JOURNAL_ENTRY_PKG.set_event_info

2667:
2668: --
2669: -- set event info as cache for other routines to refer event attributes
2670: --
2671: XLA_AE_JOURNAL_ENTRY_PKG.set_event_info
2672: (p_application_id => p_application_id
2673: ,p_primary_ledger_id => p_primary_ledger_id
2674: ,p_base_ledger_id => p_base_ledger_id
2675: ,p_target_ledger_id => p_target_ledger_id

Line 2704: XLA_AE_JOURNAL_ENTRY_PKG.g_global_status := XLA_AE_JOURNAL_ENTRY_PKG.C_VALID;

2700:
2701: --
2702: -- set the status of entry to C_VALID (0)
2703: --
2704: XLA_AE_JOURNAL_ENTRY_PKG.g_global_status := XLA_AE_JOURNAL_ENTRY_PKG.C_VALID;
2705:
2706: --
2707: -- initialize a row for ae header
2708: --

Line 2733: --g_array_event(l_event_id).array_value_num('actual_je_status') := XLA_AE_JOURNAL_ENTRY_PKG.C_NOT_CREATED;

2729: --
2730: -- initilaize the status of ae headers for diffrent balance types
2731: -- the status is initialised to C_NOT_CREATED (2)
2732: --
2733: --g_array_event(l_event_id).array_value_num('actual_je_status') := XLA_AE_JOURNAL_ENTRY_PKG.C_NOT_CREATED;
2734: --g_array_event(l_event_id).array_value_num('budget_je_status') := XLA_AE_JOURNAL_ENTRY_PKG.C_NOT_CREATED;
2735: --g_array_event(l_event_id).array_value_num('encumbrance_je_status') := XLA_AE_JOURNAL_ENTRY_PKG.C_NOT_CREATED;
2736:
2737: --

Line 2734: --g_array_event(l_event_id).array_value_num('budget_je_status') := XLA_AE_JOURNAL_ENTRY_PKG.C_NOT_CREATED;

2730: -- initilaize the status of ae headers for diffrent balance types
2731: -- the status is initialised to C_NOT_CREATED (2)
2732: --
2733: --g_array_event(l_event_id).array_value_num('actual_je_status') := XLA_AE_JOURNAL_ENTRY_PKG.C_NOT_CREATED;
2734: --g_array_event(l_event_id).array_value_num('budget_je_status') := XLA_AE_JOURNAL_ENTRY_PKG.C_NOT_CREATED;
2735: --g_array_event(l_event_id).array_value_num('encumbrance_je_status') := XLA_AE_JOURNAL_ENTRY_PKG.C_NOT_CREATED;
2736:
2737: --
2738: -- call api to validate and store accounting attributes for header

Line 2735: --g_array_event(l_event_id).array_value_num('encumbrance_je_status') := XLA_AE_JOURNAL_ENTRY_PKG.C_NOT_CREATED;

2731: -- the status is initialised to C_NOT_CREATED (2)
2732: --
2733: --g_array_event(l_event_id).array_value_num('actual_je_status') := XLA_AE_JOURNAL_ENTRY_PKG.C_NOT_CREATED;
2734: --g_array_event(l_event_id).array_value_num('budget_je_status') := XLA_AE_JOURNAL_ENTRY_PKG.C_NOT_CREATED;
2735: --g_array_event(l_event_id).array_value_num('encumbrance_je_status') := XLA_AE_JOURNAL_ENTRY_PKG.C_NOT_CREATED;
2736:
2737: --
2738: -- call api to validate and store accounting attributes for header
2739: --

Line 2771: xla_ae_journal_entry_pkg.g_global_status := xla_ae_journal_entry_pkg.C_INVALID;

2767: --
2768: l_trx_reversal_source := SUBSTR(NULL, 1,30);
2769:
2770: IF NVL(l_trx_reversal_source, 'N') NOT IN ('N','Y') THEN
2771: xla_ae_journal_entry_pkg.g_global_status := xla_ae_journal_entry_pkg.C_INVALID;
2772:
2773: xla_accounting_err_pkg.build_message
2774: (p_appli_s_name => 'XLA'
2775: ,p_msg_name => 'XLA_AP_INVALID_HDR_ATTR'

Line 2779: ,p_value_2 => xla_ae_journal_entry_pkg.g_cache_event.application_name

2775: ,p_msg_name => 'XLA_AP_INVALID_HDR_ATTR'
2776: ,p_token_1 => 'ACCT_ATTR_NAME'
2777: ,p_value_1 => xla_ae_sources_pkg.GetAccountingSourceName('TRX_ACCT_REVERSAL_OPTION')
2778: ,p_token_2 => 'PRODUCT_NAME'
2779: ,p_value_2 => xla_ae_journal_entry_pkg.g_cache_event.application_name
2780: ,p_entity_id => xla_ae_journal_entry_pkg.g_cache_event.entity_id
2781: ,p_event_id => xla_ae_journal_entry_pkg.g_cache_event.event_id
2782: ,p_ledger_id => xla_ae_journal_entry_pkg.g_cache_event.target_ledger_id);
2783:

Line 2780: ,p_entity_id => xla_ae_journal_entry_pkg.g_cache_event.entity_id

2776: ,p_token_1 => 'ACCT_ATTR_NAME'
2777: ,p_value_1 => xla_ae_sources_pkg.GetAccountingSourceName('TRX_ACCT_REVERSAL_OPTION')
2778: ,p_token_2 => 'PRODUCT_NAME'
2779: ,p_value_2 => xla_ae_journal_entry_pkg.g_cache_event.application_name
2780: ,p_entity_id => xla_ae_journal_entry_pkg.g_cache_event.entity_id
2781: ,p_event_id => xla_ae_journal_entry_pkg.g_cache_event.event_id
2782: ,p_ledger_id => xla_ae_journal_entry_pkg.g_cache_event.target_ledger_id);
2783:
2784: ELSIF NVL(l_trx_reversal_source, 'N') = 'Y' THEN

Line 2781: ,p_event_id => xla_ae_journal_entry_pkg.g_cache_event.event_id

2777: ,p_value_1 => xla_ae_sources_pkg.GetAccountingSourceName('TRX_ACCT_REVERSAL_OPTION')
2778: ,p_token_2 => 'PRODUCT_NAME'
2779: ,p_value_2 => xla_ae_journal_entry_pkg.g_cache_event.application_name
2780: ,p_entity_id => xla_ae_journal_entry_pkg.g_cache_event.entity_id
2781: ,p_event_id => xla_ae_journal_entry_pkg.g_cache_event.event_id
2782: ,p_ledger_id => xla_ae_journal_entry_pkg.g_cache_event.target_ledger_id);
2783:
2784: ELSIF NVL(l_trx_reversal_source, 'N') = 'Y' THEN
2785: --

Line 2782: ,p_ledger_id => xla_ae_journal_entry_pkg.g_cache_event.target_ledger_id);

2778: ,p_token_2 => 'PRODUCT_NAME'
2779: ,p_value_2 => xla_ae_journal_entry_pkg.g_cache_event.application_name
2780: ,p_entity_id => xla_ae_journal_entry_pkg.g_cache_event.entity_id
2781: ,p_event_id => xla_ae_journal_entry_pkg.g_cache_event.event_id
2782: ,p_ledger_id => xla_ae_journal_entry_pkg.g_cache_event.target_ledger_id);
2783:
2784: ELSIF NVL(l_trx_reversal_source, 'N') = 'Y' THEN
2785: --
2786: -- following sets the accounting attributes needed to reverse

Line 2801: XLA_AE_JOURNAL_ENTRY_PKG.UpdateJournalEntryStatus (p_hdr_idx => hdr_idx);

2797: ----------------------------------------------------------------
2798: -- 4262811 - update the header statuses to invalid in need be
2799: ----------------------------------------------------------------
2800: --
2801: XLA_AE_JOURNAL_ENTRY_PKG.UpdateJournalEntryStatus (p_hdr_idx => hdr_idx);
2802:
2803:
2804: -----------------------------------------------
2805: -- No accrual reversal for the event class/type

Line 2934: -- set the XLA_AE_JOURNAL_ENTRY_PKG.g_global_status to C_VALID (0)

2930: ,p_module => l_log_module);
2931: END IF;
2932:
2933: --
2934: -- set the XLA_AE_JOURNAL_ENTRY_PKG.g_global_status to C_VALID (0)
2935: --
2936: XLA_AE_JOURNAL_ENTRY_PKG.g_global_status := XLA_AE_JOURNAL_ENTRY_PKG.C_VALID;
2937: --
2938: -- set event info as cache for other routines to refer event attributes

Line 2936: XLA_AE_JOURNAL_ENTRY_PKG.g_global_status := XLA_AE_JOURNAL_ENTRY_PKG.C_VALID;

2932:
2933: --
2934: -- set the XLA_AE_JOURNAL_ENTRY_PKG.g_global_status to C_VALID (0)
2935: --
2936: XLA_AE_JOURNAL_ENTRY_PKG.g_global_status := XLA_AE_JOURNAL_ENTRY_PKG.C_VALID;
2937: --
2938: -- set event info as cache for other routines to refer event attributes
2939: --
2940:

Line 2944: XLA_AE_JOURNAL_ENTRY_PKG.set_event_info

2940:
2941: IF l_event_id <> NVL(l_previous_event_id, -1) THEN
2942: l_previous_event_id := l_event_id;
2943:
2944: XLA_AE_JOURNAL_ENTRY_PKG.set_event_info
2945: (p_application_id => p_application_id
2946: ,p_primary_ledger_id => p_primary_ledger_id
2947: ,p_base_ledger_id => p_base_ledger_id
2948: ,p_target_ledger_id => p_target_ledger_id

Line 2985: xla_ae_journal_entry_pkg.g_global_status := xla_ae_journal_entry_pkg.C_INVALID;

2981: l_acct_reversal_source := SUBSTR(l_array_source_4(Idx), 1,30);
2982:
2983: IF l_continue_with_lines THEN
2984: IF NVL(l_acct_reversal_source, 'N') NOT IN ('N','Y','B') THEN
2985: xla_ae_journal_entry_pkg.g_global_status := xla_ae_journal_entry_pkg.C_INVALID;
2986:
2987: xla_accounting_err_pkg.build_message
2988: (p_appli_s_name => 'XLA'
2989: ,p_msg_name => 'XLA_AP_INVALID_REVERSAL_OPTION'

Line 2993: ,p_value_2 => xla_ae_journal_entry_pkg.g_cache_event.application_name

2989: ,p_msg_name => 'XLA_AP_INVALID_REVERSAL_OPTION'
2990: ,p_token_1 => 'LINE_NUMBER'
2991: ,p_value_1 => l_array_extract_line_num(Idx)
2992: ,p_token_2 => 'PRODUCT_NAME'
2993: ,p_value_2 => xla_ae_journal_entry_pkg.g_cache_event.application_name
2994: ,p_entity_id => xla_ae_journal_entry_pkg.g_cache_event.entity_id
2995: ,p_event_id => xla_ae_journal_entry_pkg.g_cache_event.event_id
2996: ,p_ledger_id => xla_ae_journal_entry_pkg.g_cache_event.target_ledger_id);
2997:

Line 2994: ,p_entity_id => xla_ae_journal_entry_pkg.g_cache_event.entity_id

2990: ,p_token_1 => 'LINE_NUMBER'
2991: ,p_value_1 => l_array_extract_line_num(Idx)
2992: ,p_token_2 => 'PRODUCT_NAME'
2993: ,p_value_2 => xla_ae_journal_entry_pkg.g_cache_event.application_name
2994: ,p_entity_id => xla_ae_journal_entry_pkg.g_cache_event.entity_id
2995: ,p_event_id => xla_ae_journal_entry_pkg.g_cache_event.event_id
2996: ,p_ledger_id => xla_ae_journal_entry_pkg.g_cache_event.target_ledger_id);
2997:
2998: ELSIF NVL(l_acct_reversal_source, 'N') IN ('Y','B') THEN

Line 2995: ,p_event_id => xla_ae_journal_entry_pkg.g_cache_event.event_id

2991: ,p_value_1 => l_array_extract_line_num(Idx)
2992: ,p_token_2 => 'PRODUCT_NAME'
2993: ,p_value_2 => xla_ae_journal_entry_pkg.g_cache_event.application_name
2994: ,p_entity_id => xla_ae_journal_entry_pkg.g_cache_event.entity_id
2995: ,p_event_id => xla_ae_journal_entry_pkg.g_cache_event.event_id
2996: ,p_ledger_id => xla_ae_journal_entry_pkg.g_cache_event.target_ledger_id);
2997:
2998: ELSIF NVL(l_acct_reversal_source, 'N') IN ('Y','B') THEN
2999: --

Line 2996: ,p_ledger_id => xla_ae_journal_entry_pkg.g_cache_event.target_ledger_id);

2992: ,p_token_2 => 'PRODUCT_NAME'
2993: ,p_value_2 => xla_ae_journal_entry_pkg.g_cache_event.application_name
2994: ,p_entity_id => xla_ae_journal_entry_pkg.g_cache_event.entity_id
2995: ,p_event_id => xla_ae_journal_entry_pkg.g_cache_event.event_id
2996: ,p_ledger_id => xla_ae_journal_entry_pkg.g_cache_event.target_ledger_id);
2997:
2998: ELSIF NVL(l_acct_reversal_source, 'N') IN ('Y','B') THEN
2999: --
3000: -- following sets the accounting attributes needed to reverse

Line 3152: IF (((l_calculate_g_l_flag = 'Y' AND XLA_AE_JOURNAL_ENTRY_PKG.g_cache_ledgers_info.ledger_category_code <> 'ALC') or

3148:
3149: -- only execute it if calculate g/l flag is yes, and primary or secondary ledger
3150: -- or secondary ledger that has different currency with primary
3151: -- or alc that is calculated by sla
3152: IF (((l_calculate_g_l_flag = 'Y' AND XLA_AE_JOURNAL_ENTRY_PKG.g_cache_ledgers_info.ledger_category_code <> 'ALC') or
3153: (XLA_AE_JOURNAL_ENTRY_PKG.g_cache_ledgers_info.ledger_category_code in ('ALC', 'SECONDARY') AND XLA_AE_JOURNAL_ENTRY_PKG.g_cache_ledgers_info.calculate_amts_flag='Y'))
3154:
3155: -- IF((l_calculate_g_l_flag='Y' or XLA_AE_JOURNAL_ENTRY_PKG.g_cache_event.target_ledger_id <>
3156: -- XLA_AE_JOURNAL_ENTRY_PKG.g_cache_event.ledger_id)

Line 3153: (XLA_AE_JOURNAL_ENTRY_PKG.g_cache_ledgers_info.ledger_category_code in ('ALC', 'SECONDARY') AND XLA_AE_JOURNAL_ENTRY_PKG.g_cache_ledgers_info.calculate_amts_flag='Y'))

3149: -- only execute it if calculate g/l flag is yes, and primary or secondary ledger
3150: -- or secondary ledger that has different currency with primary
3151: -- or alc that is calculated by sla
3152: IF (((l_calculate_g_l_flag = 'Y' AND XLA_AE_JOURNAL_ENTRY_PKG.g_cache_ledgers_info.ledger_category_code <> 'ALC') or
3153: (XLA_AE_JOURNAL_ENTRY_PKG.g_cache_ledgers_info.ledger_category_code in ('ALC', 'SECONDARY') AND XLA_AE_JOURNAL_ENTRY_PKG.g_cache_ledgers_info.calculate_amts_flag='Y'))
3154:
3155: -- IF((l_calculate_g_l_flag='Y' or XLA_AE_JOURNAL_ENTRY_PKG.g_cache_event.target_ledger_id <>
3156: -- XLA_AE_JOURNAL_ENTRY_PKG.g_cache_event.ledger_id)
3157: AND (l_actual_flag = 'A')) THEN

Line 3155: -- IF((l_calculate_g_l_flag='Y' or XLA_AE_JOURNAL_ENTRY_PKG.g_cache_event.target_ledger_id <>

3151: -- or alc that is calculated by sla
3152: IF (((l_calculate_g_l_flag = 'Y' AND XLA_AE_JOURNAL_ENTRY_PKG.g_cache_ledgers_info.ledger_category_code <> 'ALC') or
3153: (XLA_AE_JOURNAL_ENTRY_PKG.g_cache_ledgers_info.ledger_category_code in ('ALC', 'SECONDARY') AND XLA_AE_JOURNAL_ENTRY_PKG.g_cache_ledgers_info.calculate_amts_flag='Y'))
3154:
3155: -- IF((l_calculate_g_l_flag='Y' or XLA_AE_JOURNAL_ENTRY_PKG.g_cache_event.target_ledger_id <>
3156: -- XLA_AE_JOURNAL_ENTRY_PKG.g_cache_event.ledger_id)
3157: AND (l_actual_flag = 'A')) THEN
3158: XLA_AE_LINES_PKG.CreateGainOrLossLines(
3159: p_event_id => xla_ae_journal_entry_pkg.g_cache_event.event_id

Line 3156: -- XLA_AE_JOURNAL_ENTRY_PKG.g_cache_event.ledger_id)

3152: IF (((l_calculate_g_l_flag = 'Y' AND XLA_AE_JOURNAL_ENTRY_PKG.g_cache_ledgers_info.ledger_category_code <> 'ALC') or
3153: (XLA_AE_JOURNAL_ENTRY_PKG.g_cache_ledgers_info.ledger_category_code in ('ALC', 'SECONDARY') AND XLA_AE_JOURNAL_ENTRY_PKG.g_cache_ledgers_info.calculate_amts_flag='Y'))
3154:
3155: -- IF((l_calculate_g_l_flag='Y' or XLA_AE_JOURNAL_ENTRY_PKG.g_cache_event.target_ledger_id <>
3156: -- XLA_AE_JOURNAL_ENTRY_PKG.g_cache_event.ledger_id)
3157: AND (l_actual_flag = 'A')) THEN
3158: XLA_AE_LINES_PKG.CreateGainOrLossLines(
3159: p_event_id => xla_ae_journal_entry_pkg.g_cache_event.event_id
3160: ,p_application_id => p_application_id

Line 3159: p_event_id => xla_ae_journal_entry_pkg.g_cache_event.event_id

3155: -- IF((l_calculate_g_l_flag='Y' or XLA_AE_JOURNAL_ENTRY_PKG.g_cache_event.target_ledger_id <>
3156: -- XLA_AE_JOURNAL_ENTRY_PKG.g_cache_event.ledger_id)
3157: AND (l_actual_flag = 'A')) THEN
3158: XLA_AE_LINES_PKG.CreateGainOrLossLines(
3159: p_event_id => xla_ae_journal_entry_pkg.g_cache_event.event_id
3160: ,p_application_id => p_application_id
3161: ,p_amb_context_code => 'DEFAULT'
3162: ,p_entity_code => xla_ae_journal_entry_pkg.g_cache_event.entity_code
3163: ,p_event_class_code => C_EVENT_CLASS_CODE

Line 3162: ,p_entity_code => xla_ae_journal_entry_pkg.g_cache_event.entity_code

3158: XLA_AE_LINES_PKG.CreateGainOrLossLines(
3159: p_event_id => xla_ae_journal_entry_pkg.g_cache_event.event_id
3160: ,p_application_id => p_application_id
3161: ,p_amb_context_code => 'DEFAULT'
3162: ,p_entity_code => xla_ae_journal_entry_pkg.g_cache_event.entity_code
3163: ,p_event_class_code => C_EVENT_CLASS_CODE
3164: ,p_event_type_code => C_EVENT_TYPE_CODE
3165:
3166: ,p_gain_ccid => -1

Line 3284: l_language := xla_ae_journal_entry_pkg.g_cache_ledgers_info.description_language;

3280: ,p_level => C_LEVEL_PROCEDURE
3281: ,p_module => l_log_module);
3282: END IF;
3283:
3284: l_language := xla_ae_journal_entry_pkg.g_cache_ledgers_info.description_language;
3285: l_currency_code := xla_ae_journal_entry_pkg.g_cache_ledgers_info.currency_code;
3286: l_sla_ledger_id := xla_ae_journal_entry_pkg.g_cache_ledgers_info.sla_ledger_id;
3287:
3288: --

Line 3285: l_currency_code := xla_ae_journal_entry_pkg.g_cache_ledgers_info.currency_code;

3281: ,p_module => l_log_module);
3282: END IF;
3283:
3284: l_language := xla_ae_journal_entry_pkg.g_cache_ledgers_info.description_language;
3285: l_currency_code := xla_ae_journal_entry_pkg.g_cache_ledgers_info.currency_code;
3286: l_sla_ledger_id := xla_ae_journal_entry_pkg.g_cache_ledgers_info.sla_ledger_id;
3287:
3288: --
3289: -- initialize array of lines with NULL

Line 3286: l_sla_ledger_id := xla_ae_journal_entry_pkg.g_cache_ledgers_info.sla_ledger_id;

3282: END IF;
3283:
3284: l_language := xla_ae_journal_entry_pkg.g_cache_ledgers_info.description_language;
3285: l_currency_code := xla_ae_journal_entry_pkg.g_cache_ledgers_info.currency_code;
3286: l_sla_ledger_id := xla_ae_journal_entry_pkg.g_cache_ledgers_info.sla_ledger_id;
3287:
3288: --
3289: -- initialize array of lines with NULL
3290: --

Line 3448: xla_ae_journal_entry_pkg.SetProductAcctDefinition

3444: ,p_level => C_LEVEL_STATEMENT
3445: ,p_module => l_log_module);
3446: END IF;
3447: --
3448: xla_ae_journal_entry_pkg.SetProductAcctDefinition
3449: (p_product_rule_code => 'PA_STANDARD_ACCOUNTING'
3450: ,p_product_rule_type_code => 'S'
3451: ,p_product_rule_version => ''
3452: ,p_product_rule_name => 'Projects Standard Accounting'

Line 3457: xla_ae_journal_entry_pkg.GetAlternateCurrencyLedger

3453: ,p_amb_context_code => 'DEFAULT'
3454: );
3455:
3456: l_array_ledgers :=
3457: xla_ae_journal_entry_pkg.GetAlternateCurrencyLedger
3458: (p_base_ledger_id => p_base_ledger_id);
3459:
3460: FOR Idx IN 1 .. l_array_ledgers.COUNT LOOP
3461: l_temp_result :=

Line 3462: XLA_AE_JOURNAL_ENTRY_PKG.GetLedgersInfo

3458: (p_base_ledger_id => p_base_ledger_id);
3459:
3460: FOR Idx IN 1 .. l_array_ledgers.COUNT LOOP
3461: l_temp_result :=
3462: XLA_AE_JOURNAL_ENTRY_PKG.GetLedgersInfo
3463: (p_application_id => p_application_id
3464: ,p_base_ledger_id => p_base_ledger_id
3465: ,p_target_ledger_id => l_array_ledgers(Idx)
3466: ,p_primary_ledger_id => p_primary_ledger_id