eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.XLA_00206_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 270: l_ledger_language := xla_ae_journal_entry_pkg.g_cache_ledgers_info.description_language;

266: ,p_level => C_LEVEL_PROCEDURE
267: ,p_module => l_log_module);
268: END IF;
269:
270: l_ledger_language := xla_ae_journal_entry_pkg.g_cache_ledgers_info.description_language;
271: l_component_type := 'AMB_DESCRIPTION';
272: l_component_code := 'LNS_HEADER_DESCRIPTION';
273: l_component_type_code := 'S';
274: l_component_appl_id := 206;

Line 409: l_ledger_language := xla_ae_journal_entry_pkg.g_cache_ledgers_info.description_language;

405: ,p_level => C_LEVEL_PROCEDURE
406: ,p_module => l_log_module);
407: END IF;
408:
409: l_ledger_language := xla_ae_journal_entry_pkg.g_cache_ledgers_info.description_language;
410: l_component_type := 'AMB_DESCRIPTION';
411: l_component_code := 'LNS_LINE_DESCRIPTION';
412: l_component_type_code := 'S';
413: l_component_appl_id := 206;

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

558: ,p_module => l_log_module);
559:
560: END IF;
561:
562: xla_ae_journal_entry_pkg.g_global_status := xla_ae_journal_entry_pkg.C_INVALID;
563: x_value_combination_id := null;
564: x_value_segment_code := null;
565: x_value_type_code := null;
566: l_output_value := null;

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

580: 'XLA_OWNER_TYPE'
581: ,l_component_type_code
582: )
583: ,p_token_3 => 'PAD_NAME'
584: ,p_value_3 => xla_ae_journal_entry_pkg.g_cache_pad.pad_session_name
585: ,p_token_4 => 'PAD_OWNER'
586: ,p_value_4 => xla_lookups_pkg.get_meaning(
587: 'XLA_OWNER_TYPE'
588: ,xla_ae_journal_entry_pkg.g_cache_pad.product_rule_type_code

Line 588: ,xla_ae_journal_entry_pkg.g_cache_pad.product_rule_type_code

584: ,p_value_3 => xla_ae_journal_entry_pkg.g_cache_pad.pad_session_name
585: ,p_token_4 => 'PAD_OWNER'
586: ,p_value_4 => xla_lookups_pkg.get_meaning(
587: 'XLA_OWNER_TYPE'
588: ,xla_ae_journal_entry_pkg.g_cache_pad.product_rule_type_code
589: )
590: ,p_entity_id => xla_ae_journal_entry_pkg.g_cache_event.entity_id
591: ,p_event_id => xla_ae_journal_entry_pkg.g_cache_event.event_id
592: ,p_ledger_id => xla_ae_journal_entry_pkg.g_cache_event.target_ledger_id

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

586: ,p_value_4 => xla_lookups_pkg.get_meaning(
587: 'XLA_OWNER_TYPE'
588: ,xla_ae_journal_entry_pkg.g_cache_pad.product_rule_type_code
589: )
590: ,p_entity_id => xla_ae_journal_entry_pkg.g_cache_event.entity_id
591: ,p_event_id => xla_ae_journal_entry_pkg.g_cache_event.event_id
592: ,p_ledger_id => xla_ae_journal_entry_pkg.g_cache_event.target_ledger_id
593: ,p_ae_header_id => NULL
594: );

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

587: 'XLA_OWNER_TYPE'
588: ,xla_ae_journal_entry_pkg.g_cache_pad.product_rule_type_code
589: )
590: ,p_entity_id => xla_ae_journal_entry_pkg.g_cache_event.entity_id
591: ,p_event_id => xla_ae_journal_entry_pkg.g_cache_event.event_id
592: ,p_ledger_id => xla_ae_journal_entry_pkg.g_cache_event.target_ledger_id
593: ,p_ae_header_id => NULL
594: );
595: RETURN l_output_value;

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

588: ,xla_ae_journal_entry_pkg.g_cache_pad.product_rule_type_code
589: )
590: ,p_entity_id => xla_ae_journal_entry_pkg.g_cache_event.entity_id
591: ,p_event_id => xla_ae_journal_entry_pkg.g_cache_event.event_id
592: ,p_ledger_id => xla_ae_journal_entry_pkg.g_cache_event.target_ledger_id
593: ,p_ae_header_id => NULL
594: );
595: RETURN l_output_value;
596: EXCEPTION

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

664: (p_msg => 'END of AcctDerRule_4(invalid)'
665: ,p_level => C_LEVEL_PROCEDURE
666: ,p_module => l_log_module);
667: END IF;
668: xla_ae_journal_entry_pkg.g_global_status := xla_ae_journal_entry_pkg.C_INVALID;
669: x_value_type_code := null;
670: l_output_value := null;
671: xla_accounting_err_pkg.build_message
672: (p_appli_s_name => 'XLA'

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

684: 'XLA_OWNER_TYPE'
685: ,l_component_type_code
686: )
687: ,p_token_3 => 'PAD_NAME'
688: ,p_value_3 => xla_ae_journal_entry_pkg.g_cache_pad.pad_session_name
689: ,p_token_4 => 'PAD_OWNER'
690: ,p_value_4 => xla_lookups_pkg.get_meaning(
691: 'XLA_OWNER_TYPE'
692: ,xla_ae_journal_entry_pkg.g_cache_pad.product_rule_type_code

Line 692: ,xla_ae_journal_entry_pkg.g_cache_pad.product_rule_type_code

688: ,p_value_3 => xla_ae_journal_entry_pkg.g_cache_pad.pad_session_name
689: ,p_token_4 => 'PAD_OWNER'
690: ,p_value_4 => xla_lookups_pkg.get_meaning(
691: 'XLA_OWNER_TYPE'
692: ,xla_ae_journal_entry_pkg.g_cache_pad.product_rule_type_code
693: )
694: ,p_entity_id => xla_ae_journal_entry_pkg.g_cache_event.entity_id
695: ,p_event_id => xla_ae_journal_entry_pkg.g_cache_event.event_id
696: ,p_ledger_id => xla_ae_journal_entry_pkg.g_cache_event.target_ledger_id

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

690: ,p_value_4 => xla_lookups_pkg.get_meaning(
691: 'XLA_OWNER_TYPE'
692: ,xla_ae_journal_entry_pkg.g_cache_pad.product_rule_type_code
693: )
694: ,p_entity_id => xla_ae_journal_entry_pkg.g_cache_event.entity_id
695: ,p_event_id => xla_ae_journal_entry_pkg.g_cache_event.event_id
696: ,p_ledger_id => xla_ae_journal_entry_pkg.g_cache_event.target_ledger_id
697: ,p_ae_header_id => NULL
698: );

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

691: 'XLA_OWNER_TYPE'
692: ,xla_ae_journal_entry_pkg.g_cache_pad.product_rule_type_code
693: )
694: ,p_entity_id => xla_ae_journal_entry_pkg.g_cache_event.entity_id
695: ,p_event_id => xla_ae_journal_entry_pkg.g_cache_event.event_id
696: ,p_ledger_id => xla_ae_journal_entry_pkg.g_cache_event.target_ledger_id
697: ,p_ae_header_id => NULL
698: );
699: RETURN l_output_value;

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

692: ,xla_ae_journal_entry_pkg.g_cache_pad.product_rule_type_code
693: )
694: ,p_entity_id => xla_ae_journal_entry_pkg.g_cache_event.entity_id
695: ,p_event_id => xla_ae_journal_entry_pkg.g_cache_event.event_id
696: ,p_ledger_id => xla_ae_journal_entry_pkg.g_cache_event.target_ledger_id
697: ,p_ae_header_id => NULL
698: );
699: RETURN l_output_value;
700: EXCEPTION

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

782: ,p_module => l_log_module);
783:
784: END IF;
785:
786: xla_ae_journal_entry_pkg.g_global_status := xla_ae_journal_entry_pkg.C_INVALID;
787: x_value_combination_id := null;
788: x_value_segment_code := null;
789: x_value_type_code := null;
790: l_output_value := null;

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

804: 'XLA_OWNER_TYPE'
805: ,l_component_type_code
806: )
807: ,p_token_3 => 'PAD_NAME'
808: ,p_value_3 => xla_ae_journal_entry_pkg.g_cache_pad.pad_session_name
809: ,p_token_4 => 'PAD_OWNER'
810: ,p_value_4 => xla_lookups_pkg.get_meaning(
811: 'XLA_OWNER_TYPE'
812: ,xla_ae_journal_entry_pkg.g_cache_pad.product_rule_type_code

Line 812: ,xla_ae_journal_entry_pkg.g_cache_pad.product_rule_type_code

808: ,p_value_3 => xla_ae_journal_entry_pkg.g_cache_pad.pad_session_name
809: ,p_token_4 => 'PAD_OWNER'
810: ,p_value_4 => xla_lookups_pkg.get_meaning(
811: 'XLA_OWNER_TYPE'
812: ,xla_ae_journal_entry_pkg.g_cache_pad.product_rule_type_code
813: )
814: ,p_entity_id => xla_ae_journal_entry_pkg.g_cache_event.entity_id
815: ,p_event_id => xla_ae_journal_entry_pkg.g_cache_event.event_id
816: ,p_ledger_id => xla_ae_journal_entry_pkg.g_cache_event.target_ledger_id

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

810: ,p_value_4 => xla_lookups_pkg.get_meaning(
811: 'XLA_OWNER_TYPE'
812: ,xla_ae_journal_entry_pkg.g_cache_pad.product_rule_type_code
813: )
814: ,p_entity_id => xla_ae_journal_entry_pkg.g_cache_event.entity_id
815: ,p_event_id => xla_ae_journal_entry_pkg.g_cache_event.event_id
816: ,p_ledger_id => xla_ae_journal_entry_pkg.g_cache_event.target_ledger_id
817: ,p_ae_header_id => NULL
818: );

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

811: 'XLA_OWNER_TYPE'
812: ,xla_ae_journal_entry_pkg.g_cache_pad.product_rule_type_code
813: )
814: ,p_entity_id => xla_ae_journal_entry_pkg.g_cache_event.entity_id
815: ,p_event_id => xla_ae_journal_entry_pkg.g_cache_event.event_id
816: ,p_ledger_id => xla_ae_journal_entry_pkg.g_cache_event.target_ledger_id
817: ,p_ae_header_id => NULL
818: );
819: RETURN l_output_value;

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

812: ,xla_ae_journal_entry_pkg.g_cache_pad.product_rule_type_code
813: )
814: ,p_entity_id => xla_ae_journal_entry_pkg.g_cache_event.entity_id
815: ,p_event_id => xla_ae_journal_entry_pkg.g_cache_event.event_id
816: ,p_ledger_id => xla_ae_journal_entry_pkg.g_cache_event.target_ledger_id
817: ,p_ae_header_id => NULL
818: );
819: RETURN l_output_value;
820: EXCEPTION

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

902: ,p_module => l_log_module);
903:
904: END IF;
905:
906: xla_ae_journal_entry_pkg.g_global_status := xla_ae_journal_entry_pkg.C_INVALID;
907: x_value_combination_id := null;
908: x_value_segment_code := null;
909: x_value_type_code := null;
910: l_output_value := null;

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

924: 'XLA_OWNER_TYPE'
925: ,l_component_type_code
926: )
927: ,p_token_3 => 'PAD_NAME'
928: ,p_value_3 => xla_ae_journal_entry_pkg.g_cache_pad.pad_session_name
929: ,p_token_4 => 'PAD_OWNER'
930: ,p_value_4 => xla_lookups_pkg.get_meaning(
931: 'XLA_OWNER_TYPE'
932: ,xla_ae_journal_entry_pkg.g_cache_pad.product_rule_type_code

Line 932: ,xla_ae_journal_entry_pkg.g_cache_pad.product_rule_type_code

928: ,p_value_3 => xla_ae_journal_entry_pkg.g_cache_pad.pad_session_name
929: ,p_token_4 => 'PAD_OWNER'
930: ,p_value_4 => xla_lookups_pkg.get_meaning(
931: 'XLA_OWNER_TYPE'
932: ,xla_ae_journal_entry_pkg.g_cache_pad.product_rule_type_code
933: )
934: ,p_entity_id => xla_ae_journal_entry_pkg.g_cache_event.entity_id
935: ,p_event_id => xla_ae_journal_entry_pkg.g_cache_event.event_id
936: ,p_ledger_id => xla_ae_journal_entry_pkg.g_cache_event.target_ledger_id

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

930: ,p_value_4 => xla_lookups_pkg.get_meaning(
931: 'XLA_OWNER_TYPE'
932: ,xla_ae_journal_entry_pkg.g_cache_pad.product_rule_type_code
933: )
934: ,p_entity_id => xla_ae_journal_entry_pkg.g_cache_event.entity_id
935: ,p_event_id => xla_ae_journal_entry_pkg.g_cache_event.event_id
936: ,p_ledger_id => xla_ae_journal_entry_pkg.g_cache_event.target_ledger_id
937: ,p_ae_header_id => NULL
938: );

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

931: 'XLA_OWNER_TYPE'
932: ,xla_ae_journal_entry_pkg.g_cache_pad.product_rule_type_code
933: )
934: ,p_entity_id => xla_ae_journal_entry_pkg.g_cache_event.entity_id
935: ,p_event_id => xla_ae_journal_entry_pkg.g_cache_event.event_id
936: ,p_ledger_id => xla_ae_journal_entry_pkg.g_cache_event.target_ledger_id
937: ,p_ae_header_id => NULL
938: );
939: RETURN l_output_value;

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

932: ,xla_ae_journal_entry_pkg.g_cache_pad.product_rule_type_code
933: )
934: ,p_entity_id => xla_ae_journal_entry_pkg.g_cache_event.entity_id
935: ,p_event_id => xla_ae_journal_entry_pkg.g_cache_event.event_id
936: ,p_ledger_id => xla_ae_journal_entry_pkg.g_cache_event.target_ledger_id
937: ,p_ae_header_id => NULL
938: );
939: RETURN l_output_value;
940: EXCEPTION

Line 1039: l_gl_dates xla_ae_journal_entry_pkg.t_array_date;

1035: l_tmp_amt NUMBER;
1036: l_acc_rev_natural_side_code VARCHAR2(1);
1037:
1038: l_num_entries NUMBER;
1039: l_gl_dates xla_ae_journal_entry_pkg.t_array_date;
1040: l_accted_amts xla_ae_journal_entry_pkg.t_array_num;
1041: l_entered_amts xla_ae_journal_entry_pkg.t_array_num;
1042: l_period_names xla_ae_journal_entry_pkg.t_array_V15L;
1043: l_recog_line_1 NUMBER;

Line 1040: l_accted_amts xla_ae_journal_entry_pkg.t_array_num;

1036: l_acc_rev_natural_side_code VARCHAR2(1);
1037:
1038: l_num_entries NUMBER;
1039: l_gl_dates xla_ae_journal_entry_pkg.t_array_date;
1040: l_accted_amts xla_ae_journal_entry_pkg.t_array_num;
1041: l_entered_amts xla_ae_journal_entry_pkg.t_array_num;
1042: l_period_names xla_ae_journal_entry_pkg.t_array_V15L;
1043: l_recog_line_1 NUMBER;
1044: l_recog_line_2 NUMBER;

Line 1041: l_entered_amts xla_ae_journal_entry_pkg.t_array_num;

1037:
1038: l_num_entries NUMBER;
1039: l_gl_dates xla_ae_journal_entry_pkg.t_array_date;
1040: l_accted_amts xla_ae_journal_entry_pkg.t_array_num;
1041: l_entered_amts xla_ae_journal_entry_pkg.t_array_num;
1042: l_period_names xla_ae_journal_entry_pkg.t_array_V15L;
1043: l_recog_line_1 NUMBER;
1044: l_recog_line_2 NUMBER;
1045:

Line 1042: l_period_names xla_ae_journal_entry_pkg.t_array_V15L;

1038: l_num_entries NUMBER;
1039: l_gl_dates xla_ae_journal_entry_pkg.t_array_date;
1040: l_accted_amts xla_ae_journal_entry_pkg.t_array_num;
1041: l_entered_amts xla_ae_journal_entry_pkg.t_array_num;
1042: l_period_names xla_ae_journal_entry_pkg.t_array_V15L;
1043: l_recog_line_1 NUMBER;
1044: l_recog_line_2 NUMBER;
1045:
1046: l_bflow_applied_to_amt_idx NUMBER; -- 5132302

Line 1048: l_bflow_applied_to_amts xla_ae_journal_entry_pkg.t_array_num; -- 5132302

1044: l_recog_line_2 NUMBER;
1045:
1046: l_bflow_applied_to_amt_idx NUMBER; -- 5132302
1047: l_bflow_applied_to_amt NUMBER; -- 5132302
1048: l_bflow_applied_to_amts xla_ae_journal_entry_pkg.t_array_num; -- 5132302
1049:
1050: l_event_id NUMBER; -- To handle MPA header Description: xla_ae_header_pkg.SetHdrDescription
1051:
1052: --l_rounding_ccy VARCHAR2(15); -- To handle MPA rounding 4262811b

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

1119: l_accrual_line_num := NULL; -- 4262811
1120: l_tmp_amt := NULL; -- 4262811
1121: --
1122:
1123: IF XLA_AE_JOURNAL_ENTRY_PKG.g_cache_event.target_ledger_id = XLA_AE_JOURNAL_ENTRY_PKG.g_cache_event.ledger_id OR
1124: l_balance_type_code <> 'B' THEN
1125: IF NVL(p_source_7,'
1126: ') = 'SUBSIDY' AND
1127: NVL(p_source_8,'

Line 1204: XLA_AE_JOURNAL_ENTRY_PKG.g_cache_event.target_ledger_id;

1200: --
1201: XLA_AE_LINES_PKG.g_rec_lines.array_balance_type_code(XLA_AE_LINES_PKG.g_LineNumber) := l_balance_type_code;
1202:
1203: XLA_AE_LINES_PKG.g_rec_lines.array_ledger_id(XLA_AE_LINES_PKG.g_LineNumber) :=
1204: XLA_AE_JOURNAL_ENTRY_PKG.g_cache_event.target_ledger_id;
1205:
1206: -- 4955764
1207: XLA_AE_LINES_PKG.g_rec_lines.array_gl_date(XLA_AE_LINES_PKG.g_LineNumber) :=
1208: XLA_AE_HEADER_PKG.g_rec_header_new.array_gl_date(g_array_event(p_event_id).array_value_num('header_index'));

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

1244: l_enc_upg_option := XLA_AE_LINES_PKG.g_rec_lines.array_enc_upg_option(XLA_AE_LINES_PKG.g_LineNumber);
1245:
1246: IF xla_accounting_cache_pkg.GetValueChar
1247: (p_source_code => 'LEDGER_CATEGORY_CODE'
1248: ,p_target_ledger_id => XLA_AE_JOURNAL_ENTRY_PKG.g_cache_event.target_ledger_id) IN ('PRIMARY','ALC')
1249: AND l_bflow_method_code = 'PRIOR_ENTRY'
1250: -- AND (l_actual_upg_option = 'Y' OR l_enc_upg_option = 'Y') Bug 4922099
1251: AND ( (NVL(l_actual_upg_option, 'N') IN ('Y', 'O')) OR
1252: (NVL(l_enc_upg_option, 'N') IN ('Y', 'O'))

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

1436: p_lookup_type => 'XLA_OWNER_TYPE'
1437: ,p_lookup_code => l_component_type_code
1438: )
1439: ,p_token_4 => 'PRODUCT_NAME'
1440: ,p_value_4 => XLA_AE_JOURNAL_ENTRY_PKG.g_cache_event.application_name
1441: ,p_entity_id => XLA_AE_JOURNAL_ENTRY_PKG.g_cache_event.entity_id
1442: ,p_event_id => XLA_AE_JOURNAL_ENTRY_PKG.g_cache_event.event_id
1443: ,p_ledger_id => XLA_AE_JOURNAL_ENTRY_PKG.g_cache_event.target_ledger_id
1444: ,p_ae_header_id => NULL

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

1437: ,p_lookup_code => l_component_type_code
1438: )
1439: ,p_token_4 => 'PRODUCT_NAME'
1440: ,p_value_4 => XLA_AE_JOURNAL_ENTRY_PKG.g_cache_event.application_name
1441: ,p_entity_id => XLA_AE_JOURNAL_ENTRY_PKG.g_cache_event.entity_id
1442: ,p_event_id => XLA_AE_JOURNAL_ENTRY_PKG.g_cache_event.event_id
1443: ,p_ledger_id => XLA_AE_JOURNAL_ENTRY_PKG.g_cache_event.target_ledger_id
1444: ,p_ae_header_id => NULL
1445: );

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

1438: )
1439: ,p_token_4 => 'PRODUCT_NAME'
1440: ,p_value_4 => XLA_AE_JOURNAL_ENTRY_PKG.g_cache_event.application_name
1441: ,p_entity_id => XLA_AE_JOURNAL_ENTRY_PKG.g_cache_event.entity_id
1442: ,p_event_id => XLA_AE_JOURNAL_ENTRY_PKG.g_cache_event.event_id
1443: ,p_ledger_id => XLA_AE_JOURNAL_ENTRY_PKG.g_cache_event.target_ledger_id
1444: ,p_ae_header_id => NULL
1445: );
1446:

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

1439: ,p_token_4 => 'PRODUCT_NAME'
1440: ,p_value_4 => XLA_AE_JOURNAL_ENTRY_PKG.g_cache_event.application_name
1441: ,p_entity_id => XLA_AE_JOURNAL_ENTRY_PKG.g_cache_event.entity_id
1442: ,p_event_id => XLA_AE_JOURNAL_ENTRY_PKG.g_cache_event.event_id
1443: ,p_ledger_id => XLA_AE_JOURNAL_ENTRY_PKG.g_cache_event.target_ledger_id
1444: ,p_ae_header_id => NULL
1445: );
1446:
1447: IF (C_LEVEL_ERROR>= g_log_level) THEN

Line 1474: XLA_AE_JOURNAL_ENTRY_PKG.UpdateJournalEntryStatus

1470: ----------------------------------------------------------------------------------
1471: -- 4219869 Business Flow
1472: -- Update journal entry status -- Need to generate this within IF
1473: ----------------------------------------------------------------------------------
1474: XLA_AE_JOURNAL_ENTRY_PKG.UpdateJournalEntryStatus
1475: (p_hdr_idx => g_array_event(p_event_id).array_value_num('header_index')
1476: ,p_balance_type_code => l_balance_type_code
1477: );
1478:

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

1515:
1516: --
1517: -- Depending on the Reversal Method setup, do a switch side or changes sign for the amounts
1518: --
1519: IF (XLA_AE_JOURNAL_ENTRY_PKG.g_cache_ledgers_info.ledger_reversal_option = 'SIDE') THEN
1520: XLA_AE_LINES_PKG.g_rec_lines.array_natural_side_code(XLA_AE_LINES_PKG.g_LineNumber) := l_acc_rev_natural_side_code;
1521: ELSE
1522: ---------------------------------------------------------------------------------------------------
1523: -- 4262811a Switch Sign

Line 1544: XLA_AE_JOURNAL_ENTRY_PKG.UpdateJournalEntryStatus

1540:
1541: XLA_AE_LINES_PKG.ValidateCurrentLine;
1542: XLA_AE_LINES_PKG.SetDebitCreditAmounts;
1543:
1544: XLA_AE_JOURNAL_ENTRY_PKG.UpdateJournalEntryStatus
1545: (p_hdr_idx => g_array_event(p_event_id).array_value_num('acc_rev_header_index')
1546: ,p_balance_type_code => l_balance_type_code);
1547:
1548: END IF;

Line 1665: l_gl_dates xla_ae_journal_entry_pkg.t_array_date;

1661: l_tmp_amt NUMBER;
1662: l_acc_rev_natural_side_code VARCHAR2(1);
1663:
1664: l_num_entries NUMBER;
1665: l_gl_dates xla_ae_journal_entry_pkg.t_array_date;
1666: l_accted_amts xla_ae_journal_entry_pkg.t_array_num;
1667: l_entered_amts xla_ae_journal_entry_pkg.t_array_num;
1668: l_period_names xla_ae_journal_entry_pkg.t_array_V15L;
1669: l_recog_line_1 NUMBER;

Line 1666: l_accted_amts xla_ae_journal_entry_pkg.t_array_num;

1662: l_acc_rev_natural_side_code VARCHAR2(1);
1663:
1664: l_num_entries NUMBER;
1665: l_gl_dates xla_ae_journal_entry_pkg.t_array_date;
1666: l_accted_amts xla_ae_journal_entry_pkg.t_array_num;
1667: l_entered_amts xla_ae_journal_entry_pkg.t_array_num;
1668: l_period_names xla_ae_journal_entry_pkg.t_array_V15L;
1669: l_recog_line_1 NUMBER;
1670: l_recog_line_2 NUMBER;

Line 1667: l_entered_amts xla_ae_journal_entry_pkg.t_array_num;

1663:
1664: l_num_entries NUMBER;
1665: l_gl_dates xla_ae_journal_entry_pkg.t_array_date;
1666: l_accted_amts xla_ae_journal_entry_pkg.t_array_num;
1667: l_entered_amts xla_ae_journal_entry_pkg.t_array_num;
1668: l_period_names xla_ae_journal_entry_pkg.t_array_V15L;
1669: l_recog_line_1 NUMBER;
1670: l_recog_line_2 NUMBER;
1671:

Line 1668: l_period_names xla_ae_journal_entry_pkg.t_array_V15L;

1664: l_num_entries NUMBER;
1665: l_gl_dates xla_ae_journal_entry_pkg.t_array_date;
1666: l_accted_amts xla_ae_journal_entry_pkg.t_array_num;
1667: l_entered_amts xla_ae_journal_entry_pkg.t_array_num;
1668: l_period_names xla_ae_journal_entry_pkg.t_array_V15L;
1669: l_recog_line_1 NUMBER;
1670: l_recog_line_2 NUMBER;
1671:
1672: l_bflow_applied_to_amt_idx NUMBER; -- 5132302

Line 1674: l_bflow_applied_to_amts xla_ae_journal_entry_pkg.t_array_num; -- 5132302

1670: l_recog_line_2 NUMBER;
1671:
1672: l_bflow_applied_to_amt_idx NUMBER; -- 5132302
1673: l_bflow_applied_to_amt NUMBER; -- 5132302
1674: l_bflow_applied_to_amts xla_ae_journal_entry_pkg.t_array_num; -- 5132302
1675:
1676: l_event_id NUMBER; -- To handle MPA header Description: xla_ae_header_pkg.SetHdrDescription
1677:
1678: --l_rounding_ccy VARCHAR2(15); -- To handle MPA rounding 4262811b

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

1745: l_accrual_line_num := NULL; -- 4262811
1746: l_tmp_amt := NULL; -- 4262811
1747: --
1748:
1749: IF XLA_AE_JOURNAL_ENTRY_PKG.g_cache_event.target_ledger_id = XLA_AE_JOURNAL_ENTRY_PKG.g_cache_event.ledger_id OR
1750: l_balance_type_code <> 'B' THEN
1751: IF NVL(p_source_7,'
1752: ') = 'SUBSIDY' AND
1753: NVL(p_source_8,'

Line 1825: XLA_AE_JOURNAL_ENTRY_PKG.g_cache_event.target_ledger_id;

1821: --
1822: XLA_AE_LINES_PKG.g_rec_lines.array_balance_type_code(XLA_AE_LINES_PKG.g_LineNumber) := l_balance_type_code;
1823:
1824: XLA_AE_LINES_PKG.g_rec_lines.array_ledger_id(XLA_AE_LINES_PKG.g_LineNumber) :=
1825: XLA_AE_JOURNAL_ENTRY_PKG.g_cache_event.target_ledger_id;
1826:
1827: -- 4955764
1828: XLA_AE_LINES_PKG.g_rec_lines.array_gl_date(XLA_AE_LINES_PKG.g_LineNumber) :=
1829: XLA_AE_HEADER_PKG.g_rec_header_new.array_gl_date(g_array_event(p_event_id).array_value_num('header_index'));

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

1865: l_enc_upg_option := XLA_AE_LINES_PKG.g_rec_lines.array_enc_upg_option(XLA_AE_LINES_PKG.g_LineNumber);
1866:
1867: IF xla_accounting_cache_pkg.GetValueChar
1868: (p_source_code => 'LEDGER_CATEGORY_CODE'
1869: ,p_target_ledger_id => XLA_AE_JOURNAL_ENTRY_PKG.g_cache_event.target_ledger_id) IN ('PRIMARY','ALC')
1870: AND l_bflow_method_code = 'PRIOR_ENTRY'
1871: -- AND (l_actual_upg_option = 'Y' OR l_enc_upg_option = 'Y') Bug 4922099
1872: AND ( (NVL(l_actual_upg_option, 'N') IN ('Y', 'O')) OR
1873: (NVL(l_enc_upg_option, 'N') IN ('Y', 'O'))

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

2057: p_lookup_type => 'XLA_OWNER_TYPE'
2058: ,p_lookup_code => l_component_type_code
2059: )
2060: ,p_token_4 => 'PRODUCT_NAME'
2061: ,p_value_4 => XLA_AE_JOURNAL_ENTRY_PKG.g_cache_event.application_name
2062: ,p_entity_id => XLA_AE_JOURNAL_ENTRY_PKG.g_cache_event.entity_id
2063: ,p_event_id => XLA_AE_JOURNAL_ENTRY_PKG.g_cache_event.event_id
2064: ,p_ledger_id => XLA_AE_JOURNAL_ENTRY_PKG.g_cache_event.target_ledger_id
2065: ,p_ae_header_id => NULL

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

2058: ,p_lookup_code => l_component_type_code
2059: )
2060: ,p_token_4 => 'PRODUCT_NAME'
2061: ,p_value_4 => XLA_AE_JOURNAL_ENTRY_PKG.g_cache_event.application_name
2062: ,p_entity_id => XLA_AE_JOURNAL_ENTRY_PKG.g_cache_event.entity_id
2063: ,p_event_id => XLA_AE_JOURNAL_ENTRY_PKG.g_cache_event.event_id
2064: ,p_ledger_id => XLA_AE_JOURNAL_ENTRY_PKG.g_cache_event.target_ledger_id
2065: ,p_ae_header_id => NULL
2066: );

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

2059: )
2060: ,p_token_4 => 'PRODUCT_NAME'
2061: ,p_value_4 => XLA_AE_JOURNAL_ENTRY_PKG.g_cache_event.application_name
2062: ,p_entity_id => XLA_AE_JOURNAL_ENTRY_PKG.g_cache_event.entity_id
2063: ,p_event_id => XLA_AE_JOURNAL_ENTRY_PKG.g_cache_event.event_id
2064: ,p_ledger_id => XLA_AE_JOURNAL_ENTRY_PKG.g_cache_event.target_ledger_id
2065: ,p_ae_header_id => NULL
2066: );
2067:

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

2060: ,p_token_4 => 'PRODUCT_NAME'
2061: ,p_value_4 => XLA_AE_JOURNAL_ENTRY_PKG.g_cache_event.application_name
2062: ,p_entity_id => XLA_AE_JOURNAL_ENTRY_PKG.g_cache_event.entity_id
2063: ,p_event_id => XLA_AE_JOURNAL_ENTRY_PKG.g_cache_event.event_id
2064: ,p_ledger_id => XLA_AE_JOURNAL_ENTRY_PKG.g_cache_event.target_ledger_id
2065: ,p_ae_header_id => NULL
2066: );
2067:
2068: IF (C_LEVEL_ERROR>= g_log_level) THEN

Line 2095: XLA_AE_JOURNAL_ENTRY_PKG.UpdateJournalEntryStatus

2091: ----------------------------------------------------------------------------------
2092: -- 4219869 Business Flow
2093: -- Update journal entry status -- Need to generate this within IF
2094: ----------------------------------------------------------------------------------
2095: XLA_AE_JOURNAL_ENTRY_PKG.UpdateJournalEntryStatus
2096: (p_hdr_idx => g_array_event(p_event_id).array_value_num('header_index')
2097: ,p_balance_type_code => l_balance_type_code
2098: );
2099:

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

2136:
2137: --
2138: -- Depending on the Reversal Method setup, do a switch side or changes sign for the amounts
2139: --
2140: IF (XLA_AE_JOURNAL_ENTRY_PKG.g_cache_ledgers_info.ledger_reversal_option = 'SIDE') THEN
2141: XLA_AE_LINES_PKG.g_rec_lines.array_natural_side_code(XLA_AE_LINES_PKG.g_LineNumber) := l_acc_rev_natural_side_code;
2142: ELSE
2143: ---------------------------------------------------------------------------------------------------
2144: -- 4262811a Switch Sign

Line 2165: XLA_AE_JOURNAL_ENTRY_PKG.UpdateJournalEntryStatus

2161:
2162: XLA_AE_LINES_PKG.ValidateCurrentLine;
2163: XLA_AE_LINES_PKG.SetDebitCreditAmounts;
2164:
2165: XLA_AE_JOURNAL_ENTRY_PKG.UpdateJournalEntryStatus
2166: (p_hdr_idx => g_array_event(p_event_id).array_value_num('acc_rev_header_index')
2167: ,p_balance_type_code => l_balance_type_code);
2168:
2169: END IF;

Line 2288: l_gl_dates xla_ae_journal_entry_pkg.t_array_date;

2284: l_tmp_amt NUMBER;
2285: l_acc_rev_natural_side_code VARCHAR2(1);
2286:
2287: l_num_entries NUMBER;
2288: l_gl_dates xla_ae_journal_entry_pkg.t_array_date;
2289: l_accted_amts xla_ae_journal_entry_pkg.t_array_num;
2290: l_entered_amts xla_ae_journal_entry_pkg.t_array_num;
2291: l_period_names xla_ae_journal_entry_pkg.t_array_V15L;
2292: l_recog_line_1 NUMBER;

Line 2289: l_accted_amts xla_ae_journal_entry_pkg.t_array_num;

2285: l_acc_rev_natural_side_code VARCHAR2(1);
2286:
2287: l_num_entries NUMBER;
2288: l_gl_dates xla_ae_journal_entry_pkg.t_array_date;
2289: l_accted_amts xla_ae_journal_entry_pkg.t_array_num;
2290: l_entered_amts xla_ae_journal_entry_pkg.t_array_num;
2291: l_period_names xla_ae_journal_entry_pkg.t_array_V15L;
2292: l_recog_line_1 NUMBER;
2293: l_recog_line_2 NUMBER;

Line 2290: l_entered_amts xla_ae_journal_entry_pkg.t_array_num;

2286:
2287: l_num_entries NUMBER;
2288: l_gl_dates xla_ae_journal_entry_pkg.t_array_date;
2289: l_accted_amts xla_ae_journal_entry_pkg.t_array_num;
2290: l_entered_amts xla_ae_journal_entry_pkg.t_array_num;
2291: l_period_names xla_ae_journal_entry_pkg.t_array_V15L;
2292: l_recog_line_1 NUMBER;
2293: l_recog_line_2 NUMBER;
2294:

Line 2291: l_period_names xla_ae_journal_entry_pkg.t_array_V15L;

2287: l_num_entries NUMBER;
2288: l_gl_dates xla_ae_journal_entry_pkg.t_array_date;
2289: l_accted_amts xla_ae_journal_entry_pkg.t_array_num;
2290: l_entered_amts xla_ae_journal_entry_pkg.t_array_num;
2291: l_period_names xla_ae_journal_entry_pkg.t_array_V15L;
2292: l_recog_line_1 NUMBER;
2293: l_recog_line_2 NUMBER;
2294:
2295: l_bflow_applied_to_amt_idx NUMBER; -- 5132302

Line 2297: l_bflow_applied_to_amts xla_ae_journal_entry_pkg.t_array_num; -- 5132302

2293: l_recog_line_2 NUMBER;
2294:
2295: l_bflow_applied_to_amt_idx NUMBER; -- 5132302
2296: l_bflow_applied_to_amt NUMBER; -- 5132302
2297: l_bflow_applied_to_amts xla_ae_journal_entry_pkg.t_array_num; -- 5132302
2298:
2299: l_event_id NUMBER; -- To handle MPA header Description: xla_ae_header_pkg.SetHdrDescription
2300:
2301: --l_rounding_ccy VARCHAR2(15); -- To handle MPA rounding 4262811b

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

2368: l_accrual_line_num := NULL; -- 4262811
2369: l_tmp_amt := NULL; -- 4262811
2370: --
2371:
2372: IF XLA_AE_JOURNAL_ENTRY_PKG.g_cache_event.target_ledger_id = XLA_AE_JOURNAL_ENTRY_PKG.g_cache_event.ledger_id OR
2373: l_balance_type_code <> 'B' THEN
2374: IF NVL(p_source_7,'
2375: ') = 'SUBSIDY' AND
2376: NVL(p_source_8,'

Line 2453: XLA_AE_JOURNAL_ENTRY_PKG.g_cache_event.target_ledger_id;

2449: --
2450: XLA_AE_LINES_PKG.g_rec_lines.array_balance_type_code(XLA_AE_LINES_PKG.g_LineNumber) := l_balance_type_code;
2451:
2452: XLA_AE_LINES_PKG.g_rec_lines.array_ledger_id(XLA_AE_LINES_PKG.g_LineNumber) :=
2453: XLA_AE_JOURNAL_ENTRY_PKG.g_cache_event.target_ledger_id;
2454:
2455: -- 4955764
2456: XLA_AE_LINES_PKG.g_rec_lines.array_gl_date(XLA_AE_LINES_PKG.g_LineNumber) :=
2457: XLA_AE_HEADER_PKG.g_rec_header_new.array_gl_date(g_array_event(p_event_id).array_value_num('header_index'));

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

2493: l_enc_upg_option := XLA_AE_LINES_PKG.g_rec_lines.array_enc_upg_option(XLA_AE_LINES_PKG.g_LineNumber);
2494:
2495: IF xla_accounting_cache_pkg.GetValueChar
2496: (p_source_code => 'LEDGER_CATEGORY_CODE'
2497: ,p_target_ledger_id => XLA_AE_JOURNAL_ENTRY_PKG.g_cache_event.target_ledger_id) IN ('PRIMARY','ALC')
2498: AND l_bflow_method_code = 'PRIOR_ENTRY'
2499: -- AND (l_actual_upg_option = 'Y' OR l_enc_upg_option = 'Y') Bug 4922099
2500: AND ( (NVL(l_actual_upg_option, 'N') IN ('Y', 'O')) OR
2501: (NVL(l_enc_upg_option, 'N') IN ('Y', 'O'))

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

2685: p_lookup_type => 'XLA_OWNER_TYPE'
2686: ,p_lookup_code => l_component_type_code
2687: )
2688: ,p_token_4 => 'PRODUCT_NAME'
2689: ,p_value_4 => XLA_AE_JOURNAL_ENTRY_PKG.g_cache_event.application_name
2690: ,p_entity_id => XLA_AE_JOURNAL_ENTRY_PKG.g_cache_event.entity_id
2691: ,p_event_id => XLA_AE_JOURNAL_ENTRY_PKG.g_cache_event.event_id
2692: ,p_ledger_id => XLA_AE_JOURNAL_ENTRY_PKG.g_cache_event.target_ledger_id
2693: ,p_ae_header_id => NULL

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

2686: ,p_lookup_code => l_component_type_code
2687: )
2688: ,p_token_4 => 'PRODUCT_NAME'
2689: ,p_value_4 => XLA_AE_JOURNAL_ENTRY_PKG.g_cache_event.application_name
2690: ,p_entity_id => XLA_AE_JOURNAL_ENTRY_PKG.g_cache_event.entity_id
2691: ,p_event_id => XLA_AE_JOURNAL_ENTRY_PKG.g_cache_event.event_id
2692: ,p_ledger_id => XLA_AE_JOURNAL_ENTRY_PKG.g_cache_event.target_ledger_id
2693: ,p_ae_header_id => NULL
2694: );

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

2687: )
2688: ,p_token_4 => 'PRODUCT_NAME'
2689: ,p_value_4 => XLA_AE_JOURNAL_ENTRY_PKG.g_cache_event.application_name
2690: ,p_entity_id => XLA_AE_JOURNAL_ENTRY_PKG.g_cache_event.entity_id
2691: ,p_event_id => XLA_AE_JOURNAL_ENTRY_PKG.g_cache_event.event_id
2692: ,p_ledger_id => XLA_AE_JOURNAL_ENTRY_PKG.g_cache_event.target_ledger_id
2693: ,p_ae_header_id => NULL
2694: );
2695:

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

2688: ,p_token_4 => 'PRODUCT_NAME'
2689: ,p_value_4 => XLA_AE_JOURNAL_ENTRY_PKG.g_cache_event.application_name
2690: ,p_entity_id => XLA_AE_JOURNAL_ENTRY_PKG.g_cache_event.entity_id
2691: ,p_event_id => XLA_AE_JOURNAL_ENTRY_PKG.g_cache_event.event_id
2692: ,p_ledger_id => XLA_AE_JOURNAL_ENTRY_PKG.g_cache_event.target_ledger_id
2693: ,p_ae_header_id => NULL
2694: );
2695:
2696: IF (C_LEVEL_ERROR>= g_log_level) THEN

Line 2723: XLA_AE_JOURNAL_ENTRY_PKG.UpdateJournalEntryStatus

2719: ----------------------------------------------------------------------------------
2720: -- 4219869 Business Flow
2721: -- Update journal entry status -- Need to generate this within IF
2722: ----------------------------------------------------------------------------------
2723: XLA_AE_JOURNAL_ENTRY_PKG.UpdateJournalEntryStatus
2724: (p_hdr_idx => g_array_event(p_event_id).array_value_num('header_index')
2725: ,p_balance_type_code => l_balance_type_code
2726: );
2727:

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

2764:
2765: --
2766: -- Depending on the Reversal Method setup, do a switch side or changes sign for the amounts
2767: --
2768: IF (XLA_AE_JOURNAL_ENTRY_PKG.g_cache_ledgers_info.ledger_reversal_option = 'SIDE') THEN
2769: XLA_AE_LINES_PKG.g_rec_lines.array_natural_side_code(XLA_AE_LINES_PKG.g_LineNumber) := l_acc_rev_natural_side_code;
2770: ELSE
2771: ---------------------------------------------------------------------------------------------------
2772: -- 4262811a Switch Sign

Line 2793: XLA_AE_JOURNAL_ENTRY_PKG.UpdateJournalEntryStatus

2789:
2790: XLA_AE_LINES_PKG.ValidateCurrentLine;
2791: XLA_AE_LINES_PKG.SetDebitCreditAmounts;
2792:
2793: XLA_AE_JOURNAL_ENTRY_PKG.UpdateJournalEntryStatus
2794: (p_hdr_idx => g_array_event(p_event_id).array_value_num('acc_rev_header_index')
2795: ,p_balance_type_code => l_balance_type_code);
2796:
2797: END IF;

Line 2914: l_gl_dates xla_ae_journal_entry_pkg.t_array_date;

2910: l_tmp_amt NUMBER;
2911: l_acc_rev_natural_side_code VARCHAR2(1);
2912:
2913: l_num_entries NUMBER;
2914: l_gl_dates xla_ae_journal_entry_pkg.t_array_date;
2915: l_accted_amts xla_ae_journal_entry_pkg.t_array_num;
2916: l_entered_amts xla_ae_journal_entry_pkg.t_array_num;
2917: l_period_names xla_ae_journal_entry_pkg.t_array_V15L;
2918: l_recog_line_1 NUMBER;

Line 2915: l_accted_amts xla_ae_journal_entry_pkg.t_array_num;

2911: l_acc_rev_natural_side_code VARCHAR2(1);
2912:
2913: l_num_entries NUMBER;
2914: l_gl_dates xla_ae_journal_entry_pkg.t_array_date;
2915: l_accted_amts xla_ae_journal_entry_pkg.t_array_num;
2916: l_entered_amts xla_ae_journal_entry_pkg.t_array_num;
2917: l_period_names xla_ae_journal_entry_pkg.t_array_V15L;
2918: l_recog_line_1 NUMBER;
2919: l_recog_line_2 NUMBER;

Line 2916: l_entered_amts xla_ae_journal_entry_pkg.t_array_num;

2912:
2913: l_num_entries NUMBER;
2914: l_gl_dates xla_ae_journal_entry_pkg.t_array_date;
2915: l_accted_amts xla_ae_journal_entry_pkg.t_array_num;
2916: l_entered_amts xla_ae_journal_entry_pkg.t_array_num;
2917: l_period_names xla_ae_journal_entry_pkg.t_array_V15L;
2918: l_recog_line_1 NUMBER;
2919: l_recog_line_2 NUMBER;
2920:

Line 2917: l_period_names xla_ae_journal_entry_pkg.t_array_V15L;

2913: l_num_entries NUMBER;
2914: l_gl_dates xla_ae_journal_entry_pkg.t_array_date;
2915: l_accted_amts xla_ae_journal_entry_pkg.t_array_num;
2916: l_entered_amts xla_ae_journal_entry_pkg.t_array_num;
2917: l_period_names xla_ae_journal_entry_pkg.t_array_V15L;
2918: l_recog_line_1 NUMBER;
2919: l_recog_line_2 NUMBER;
2920:
2921: l_bflow_applied_to_amt_idx NUMBER; -- 5132302

Line 2923: l_bflow_applied_to_amts xla_ae_journal_entry_pkg.t_array_num; -- 5132302

2919: l_recog_line_2 NUMBER;
2920:
2921: l_bflow_applied_to_amt_idx NUMBER; -- 5132302
2922: l_bflow_applied_to_amt NUMBER; -- 5132302
2923: l_bflow_applied_to_amts xla_ae_journal_entry_pkg.t_array_num; -- 5132302
2924:
2925: l_event_id NUMBER; -- To handle MPA header Description: xla_ae_header_pkg.SetHdrDescription
2926:
2927: --l_rounding_ccy VARCHAR2(15); -- To handle MPA rounding 4262811b

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

2994: l_accrual_line_num := NULL; -- 4262811
2995: l_tmp_amt := NULL; -- 4262811
2996: --
2997:
2998: IF XLA_AE_JOURNAL_ENTRY_PKG.g_cache_event.target_ledger_id = XLA_AE_JOURNAL_ENTRY_PKG.g_cache_event.ledger_id OR
2999: l_balance_type_code <> 'B' THEN
3000: IF NVL(p_source_7,'
3001: ') = 'SUBSIDY' AND
3002: NVL(p_source_8,'

Line 3074: XLA_AE_JOURNAL_ENTRY_PKG.g_cache_event.target_ledger_id;

3070: --
3071: XLA_AE_LINES_PKG.g_rec_lines.array_balance_type_code(XLA_AE_LINES_PKG.g_LineNumber) := l_balance_type_code;
3072:
3073: XLA_AE_LINES_PKG.g_rec_lines.array_ledger_id(XLA_AE_LINES_PKG.g_LineNumber) :=
3074: XLA_AE_JOURNAL_ENTRY_PKG.g_cache_event.target_ledger_id;
3075:
3076: -- 4955764
3077: XLA_AE_LINES_PKG.g_rec_lines.array_gl_date(XLA_AE_LINES_PKG.g_LineNumber) :=
3078: XLA_AE_HEADER_PKG.g_rec_header_new.array_gl_date(g_array_event(p_event_id).array_value_num('header_index'));

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

3114: l_enc_upg_option := XLA_AE_LINES_PKG.g_rec_lines.array_enc_upg_option(XLA_AE_LINES_PKG.g_LineNumber);
3115:
3116: IF xla_accounting_cache_pkg.GetValueChar
3117: (p_source_code => 'LEDGER_CATEGORY_CODE'
3118: ,p_target_ledger_id => XLA_AE_JOURNAL_ENTRY_PKG.g_cache_event.target_ledger_id) IN ('PRIMARY','ALC')
3119: AND l_bflow_method_code = 'PRIOR_ENTRY'
3120: -- AND (l_actual_upg_option = 'Y' OR l_enc_upg_option = 'Y') Bug 4922099
3121: AND ( (NVL(l_actual_upg_option, 'N') IN ('Y', 'O')) OR
3122: (NVL(l_enc_upg_option, 'N') IN ('Y', 'O'))

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

3306: p_lookup_type => 'XLA_OWNER_TYPE'
3307: ,p_lookup_code => l_component_type_code
3308: )
3309: ,p_token_4 => 'PRODUCT_NAME'
3310: ,p_value_4 => XLA_AE_JOURNAL_ENTRY_PKG.g_cache_event.application_name
3311: ,p_entity_id => XLA_AE_JOURNAL_ENTRY_PKG.g_cache_event.entity_id
3312: ,p_event_id => XLA_AE_JOURNAL_ENTRY_PKG.g_cache_event.event_id
3313: ,p_ledger_id => XLA_AE_JOURNAL_ENTRY_PKG.g_cache_event.target_ledger_id
3314: ,p_ae_header_id => NULL

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

3307: ,p_lookup_code => l_component_type_code
3308: )
3309: ,p_token_4 => 'PRODUCT_NAME'
3310: ,p_value_4 => XLA_AE_JOURNAL_ENTRY_PKG.g_cache_event.application_name
3311: ,p_entity_id => XLA_AE_JOURNAL_ENTRY_PKG.g_cache_event.entity_id
3312: ,p_event_id => XLA_AE_JOURNAL_ENTRY_PKG.g_cache_event.event_id
3313: ,p_ledger_id => XLA_AE_JOURNAL_ENTRY_PKG.g_cache_event.target_ledger_id
3314: ,p_ae_header_id => NULL
3315: );

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

3308: )
3309: ,p_token_4 => 'PRODUCT_NAME'
3310: ,p_value_4 => XLA_AE_JOURNAL_ENTRY_PKG.g_cache_event.application_name
3311: ,p_entity_id => XLA_AE_JOURNAL_ENTRY_PKG.g_cache_event.entity_id
3312: ,p_event_id => XLA_AE_JOURNAL_ENTRY_PKG.g_cache_event.event_id
3313: ,p_ledger_id => XLA_AE_JOURNAL_ENTRY_PKG.g_cache_event.target_ledger_id
3314: ,p_ae_header_id => NULL
3315: );
3316:

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

3309: ,p_token_4 => 'PRODUCT_NAME'
3310: ,p_value_4 => XLA_AE_JOURNAL_ENTRY_PKG.g_cache_event.application_name
3311: ,p_entity_id => XLA_AE_JOURNAL_ENTRY_PKG.g_cache_event.entity_id
3312: ,p_event_id => XLA_AE_JOURNAL_ENTRY_PKG.g_cache_event.event_id
3313: ,p_ledger_id => XLA_AE_JOURNAL_ENTRY_PKG.g_cache_event.target_ledger_id
3314: ,p_ae_header_id => NULL
3315: );
3316:
3317: IF (C_LEVEL_ERROR>= g_log_level) THEN

Line 3344: XLA_AE_JOURNAL_ENTRY_PKG.UpdateJournalEntryStatus

3340: ----------------------------------------------------------------------------------
3341: -- 4219869 Business Flow
3342: -- Update journal entry status -- Need to generate this within IF
3343: ----------------------------------------------------------------------------------
3344: XLA_AE_JOURNAL_ENTRY_PKG.UpdateJournalEntryStatus
3345: (p_hdr_idx => g_array_event(p_event_id).array_value_num('header_index')
3346: ,p_balance_type_code => l_balance_type_code
3347: );
3348:

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

3385:
3386: --
3387: -- Depending on the Reversal Method setup, do a switch side or changes sign for the amounts
3388: --
3389: IF (XLA_AE_JOURNAL_ENTRY_PKG.g_cache_ledgers_info.ledger_reversal_option = 'SIDE') THEN
3390: XLA_AE_LINES_PKG.g_rec_lines.array_natural_side_code(XLA_AE_LINES_PKG.g_LineNumber) := l_acc_rev_natural_side_code;
3391: ELSE
3392: ---------------------------------------------------------------------------------------------------
3393: -- 4262811a Switch Sign

Line 3414: XLA_AE_JOURNAL_ENTRY_PKG.UpdateJournalEntryStatus

3410:
3411: XLA_AE_LINES_PKG.ValidateCurrentLine;
3412: XLA_AE_LINES_PKG.SetDebitCreditAmounts;
3413:
3414: XLA_AE_JOURNAL_ENTRY_PKG.UpdateJournalEntryStatus
3415: (p_hdr_idx => g_array_event(p_event_id).array_value_num('acc_rev_header_index')
3416: ,p_balance_type_code => l_balance_type_code);
3417:
3418: END IF;

Line 3535: l_gl_dates xla_ae_journal_entry_pkg.t_array_date;

3531: l_tmp_amt NUMBER;
3532: l_acc_rev_natural_side_code VARCHAR2(1);
3533:
3534: l_num_entries NUMBER;
3535: l_gl_dates xla_ae_journal_entry_pkg.t_array_date;
3536: l_accted_amts xla_ae_journal_entry_pkg.t_array_num;
3537: l_entered_amts xla_ae_journal_entry_pkg.t_array_num;
3538: l_period_names xla_ae_journal_entry_pkg.t_array_V15L;
3539: l_recog_line_1 NUMBER;

Line 3536: l_accted_amts xla_ae_journal_entry_pkg.t_array_num;

3532: l_acc_rev_natural_side_code VARCHAR2(1);
3533:
3534: l_num_entries NUMBER;
3535: l_gl_dates xla_ae_journal_entry_pkg.t_array_date;
3536: l_accted_amts xla_ae_journal_entry_pkg.t_array_num;
3537: l_entered_amts xla_ae_journal_entry_pkg.t_array_num;
3538: l_period_names xla_ae_journal_entry_pkg.t_array_V15L;
3539: l_recog_line_1 NUMBER;
3540: l_recog_line_2 NUMBER;

Line 3537: l_entered_amts xla_ae_journal_entry_pkg.t_array_num;

3533:
3534: l_num_entries NUMBER;
3535: l_gl_dates xla_ae_journal_entry_pkg.t_array_date;
3536: l_accted_amts xla_ae_journal_entry_pkg.t_array_num;
3537: l_entered_amts xla_ae_journal_entry_pkg.t_array_num;
3538: l_period_names xla_ae_journal_entry_pkg.t_array_V15L;
3539: l_recog_line_1 NUMBER;
3540: l_recog_line_2 NUMBER;
3541:

Line 3538: l_period_names xla_ae_journal_entry_pkg.t_array_V15L;

3534: l_num_entries NUMBER;
3535: l_gl_dates xla_ae_journal_entry_pkg.t_array_date;
3536: l_accted_amts xla_ae_journal_entry_pkg.t_array_num;
3537: l_entered_amts xla_ae_journal_entry_pkg.t_array_num;
3538: l_period_names xla_ae_journal_entry_pkg.t_array_V15L;
3539: l_recog_line_1 NUMBER;
3540: l_recog_line_2 NUMBER;
3541:
3542: l_bflow_applied_to_amt_idx NUMBER; -- 5132302

Line 3544: l_bflow_applied_to_amts xla_ae_journal_entry_pkg.t_array_num; -- 5132302

3540: l_recog_line_2 NUMBER;
3541:
3542: l_bflow_applied_to_amt_idx NUMBER; -- 5132302
3543: l_bflow_applied_to_amt NUMBER; -- 5132302
3544: l_bflow_applied_to_amts xla_ae_journal_entry_pkg.t_array_num; -- 5132302
3545:
3546: l_event_id NUMBER; -- To handle MPA header Description: xla_ae_header_pkg.SetHdrDescription
3547:
3548: --l_rounding_ccy VARCHAR2(15); -- To handle MPA rounding 4262811b

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

3615: l_accrual_line_num := NULL; -- 4262811
3616: l_tmp_amt := NULL; -- 4262811
3617: --
3618:
3619: IF XLA_AE_JOURNAL_ENTRY_PKG.g_cache_event.target_ledger_id = XLA_AE_JOURNAL_ENTRY_PKG.g_cache_event.ledger_id OR
3620: l_balance_type_code <> 'B' THEN
3621: IF NVL(p_source_7,'
3622: ') <> 'SUBSIDY' AND
3623: NVL(p_source_8,'

Line 3700: XLA_AE_JOURNAL_ENTRY_PKG.g_cache_event.target_ledger_id;

3696: --
3697: XLA_AE_LINES_PKG.g_rec_lines.array_balance_type_code(XLA_AE_LINES_PKG.g_LineNumber) := l_balance_type_code;
3698:
3699: XLA_AE_LINES_PKG.g_rec_lines.array_ledger_id(XLA_AE_LINES_PKG.g_LineNumber) :=
3700: XLA_AE_JOURNAL_ENTRY_PKG.g_cache_event.target_ledger_id;
3701:
3702: -- 4955764
3703: XLA_AE_LINES_PKG.g_rec_lines.array_gl_date(XLA_AE_LINES_PKG.g_LineNumber) :=
3704: XLA_AE_HEADER_PKG.g_rec_header_new.array_gl_date(g_array_event(p_event_id).array_value_num('header_index'));

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

3740: l_enc_upg_option := XLA_AE_LINES_PKG.g_rec_lines.array_enc_upg_option(XLA_AE_LINES_PKG.g_LineNumber);
3741:
3742: IF xla_accounting_cache_pkg.GetValueChar
3743: (p_source_code => 'LEDGER_CATEGORY_CODE'
3744: ,p_target_ledger_id => XLA_AE_JOURNAL_ENTRY_PKG.g_cache_event.target_ledger_id) IN ('PRIMARY','ALC')
3745: AND l_bflow_method_code = 'PRIOR_ENTRY'
3746: -- AND (l_actual_upg_option = 'Y' OR l_enc_upg_option = 'Y') Bug 4922099
3747: AND ( (NVL(l_actual_upg_option, 'N') IN ('Y', 'O')) OR
3748: (NVL(l_enc_upg_option, 'N') IN ('Y', 'O'))

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

3891: p_lookup_type => 'XLA_OWNER_TYPE'
3892: ,p_lookup_code => l_component_type_code
3893: )
3894: ,p_token_4 => 'PRODUCT_NAME'
3895: ,p_value_4 => XLA_AE_JOURNAL_ENTRY_PKG.g_cache_event.application_name
3896: ,p_entity_id => XLA_AE_JOURNAL_ENTRY_PKG.g_cache_event.entity_id
3897: ,p_event_id => XLA_AE_JOURNAL_ENTRY_PKG.g_cache_event.event_id
3898: ,p_ledger_id => XLA_AE_JOURNAL_ENTRY_PKG.g_cache_event.target_ledger_id
3899: ,p_ae_header_id => NULL

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

3892: ,p_lookup_code => l_component_type_code
3893: )
3894: ,p_token_4 => 'PRODUCT_NAME'
3895: ,p_value_4 => XLA_AE_JOURNAL_ENTRY_PKG.g_cache_event.application_name
3896: ,p_entity_id => XLA_AE_JOURNAL_ENTRY_PKG.g_cache_event.entity_id
3897: ,p_event_id => XLA_AE_JOURNAL_ENTRY_PKG.g_cache_event.event_id
3898: ,p_ledger_id => XLA_AE_JOURNAL_ENTRY_PKG.g_cache_event.target_ledger_id
3899: ,p_ae_header_id => NULL
3900: );

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

3893: )
3894: ,p_token_4 => 'PRODUCT_NAME'
3895: ,p_value_4 => XLA_AE_JOURNAL_ENTRY_PKG.g_cache_event.application_name
3896: ,p_entity_id => XLA_AE_JOURNAL_ENTRY_PKG.g_cache_event.entity_id
3897: ,p_event_id => XLA_AE_JOURNAL_ENTRY_PKG.g_cache_event.event_id
3898: ,p_ledger_id => XLA_AE_JOURNAL_ENTRY_PKG.g_cache_event.target_ledger_id
3899: ,p_ae_header_id => NULL
3900: );
3901:

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

3894: ,p_token_4 => 'PRODUCT_NAME'
3895: ,p_value_4 => XLA_AE_JOURNAL_ENTRY_PKG.g_cache_event.application_name
3896: ,p_entity_id => XLA_AE_JOURNAL_ENTRY_PKG.g_cache_event.entity_id
3897: ,p_event_id => XLA_AE_JOURNAL_ENTRY_PKG.g_cache_event.event_id
3898: ,p_ledger_id => XLA_AE_JOURNAL_ENTRY_PKG.g_cache_event.target_ledger_id
3899: ,p_ae_header_id => NULL
3900: );
3901:
3902: IF (C_LEVEL_ERROR>= g_log_level) THEN

Line 3929: XLA_AE_JOURNAL_ENTRY_PKG.UpdateJournalEntryStatus

3925: ----------------------------------------------------------------------------------
3926: -- 4219869 Business Flow
3927: -- Update journal entry status -- Need to generate this within IF
3928: ----------------------------------------------------------------------------------
3929: XLA_AE_JOURNAL_ENTRY_PKG.UpdateJournalEntryStatus
3930: (p_hdr_idx => g_array_event(p_event_id).array_value_num('header_index')
3931: ,p_balance_type_code => l_balance_type_code
3932: );
3933:

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

3970:
3971: --
3972: -- Depending on the Reversal Method setup, do a switch side or changes sign for the amounts
3973: --
3974: IF (XLA_AE_JOURNAL_ENTRY_PKG.g_cache_ledgers_info.ledger_reversal_option = 'SIDE') THEN
3975: XLA_AE_LINES_PKG.g_rec_lines.array_natural_side_code(XLA_AE_LINES_PKG.g_LineNumber) := l_acc_rev_natural_side_code;
3976: ELSE
3977: ---------------------------------------------------------------------------------------------------
3978: -- 4262811a Switch Sign

Line 3999: XLA_AE_JOURNAL_ENTRY_PKG.UpdateJournalEntryStatus

3995:
3996: XLA_AE_LINES_PKG.ValidateCurrentLine;
3997: XLA_AE_LINES_PKG.SetDebitCreditAmounts;
3998:
3999: XLA_AE_JOURNAL_ENTRY_PKG.UpdateJournalEntryStatus
4000: (p_hdr_idx => g_array_event(p_event_id).array_value_num('acc_rev_header_index')
4001: ,p_balance_type_code => l_balance_type_code);
4002:
4003: END IF;

Line 4118: l_gl_dates xla_ae_journal_entry_pkg.t_array_date;

4114: l_tmp_amt NUMBER;
4115: l_acc_rev_natural_side_code VARCHAR2(1);
4116:
4117: l_num_entries NUMBER;
4118: l_gl_dates xla_ae_journal_entry_pkg.t_array_date;
4119: l_accted_amts xla_ae_journal_entry_pkg.t_array_num;
4120: l_entered_amts xla_ae_journal_entry_pkg.t_array_num;
4121: l_period_names xla_ae_journal_entry_pkg.t_array_V15L;
4122: l_recog_line_1 NUMBER;

Line 4119: l_accted_amts xla_ae_journal_entry_pkg.t_array_num;

4115: l_acc_rev_natural_side_code VARCHAR2(1);
4116:
4117: l_num_entries NUMBER;
4118: l_gl_dates xla_ae_journal_entry_pkg.t_array_date;
4119: l_accted_amts xla_ae_journal_entry_pkg.t_array_num;
4120: l_entered_amts xla_ae_journal_entry_pkg.t_array_num;
4121: l_period_names xla_ae_journal_entry_pkg.t_array_V15L;
4122: l_recog_line_1 NUMBER;
4123: l_recog_line_2 NUMBER;

Line 4120: l_entered_amts xla_ae_journal_entry_pkg.t_array_num;

4116:
4117: l_num_entries NUMBER;
4118: l_gl_dates xla_ae_journal_entry_pkg.t_array_date;
4119: l_accted_amts xla_ae_journal_entry_pkg.t_array_num;
4120: l_entered_amts xla_ae_journal_entry_pkg.t_array_num;
4121: l_period_names xla_ae_journal_entry_pkg.t_array_V15L;
4122: l_recog_line_1 NUMBER;
4123: l_recog_line_2 NUMBER;
4124:

Line 4121: l_period_names xla_ae_journal_entry_pkg.t_array_V15L;

4117: l_num_entries NUMBER;
4118: l_gl_dates xla_ae_journal_entry_pkg.t_array_date;
4119: l_accted_amts xla_ae_journal_entry_pkg.t_array_num;
4120: l_entered_amts xla_ae_journal_entry_pkg.t_array_num;
4121: l_period_names xla_ae_journal_entry_pkg.t_array_V15L;
4122: l_recog_line_1 NUMBER;
4123: l_recog_line_2 NUMBER;
4124:
4125: l_bflow_applied_to_amt_idx NUMBER; -- 5132302

Line 4127: l_bflow_applied_to_amts xla_ae_journal_entry_pkg.t_array_num; -- 5132302

4123: l_recog_line_2 NUMBER;
4124:
4125: l_bflow_applied_to_amt_idx NUMBER; -- 5132302
4126: l_bflow_applied_to_amt NUMBER; -- 5132302
4127: l_bflow_applied_to_amts xla_ae_journal_entry_pkg.t_array_num; -- 5132302
4128:
4129: l_event_id NUMBER; -- To handle MPA header Description: xla_ae_header_pkg.SetHdrDescription
4130:
4131: --l_rounding_ccy VARCHAR2(15); -- To handle MPA rounding 4262811b

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

4198: l_accrual_line_num := NULL; -- 4262811
4199: l_tmp_amt := NULL; -- 4262811
4200: --
4201:
4202: IF XLA_AE_JOURNAL_ENTRY_PKG.g_cache_event.target_ledger_id = XLA_AE_JOURNAL_ENTRY_PKG.g_cache_event.ledger_id OR
4203: l_balance_type_code <> 'B' THEN
4204: IF NVL(p_source_7,'
4205: ') <> 'SUBSIDY' AND
4206: NVL(p_source_8,'

Line 4278: XLA_AE_JOURNAL_ENTRY_PKG.g_cache_event.target_ledger_id;

4274: --
4275: XLA_AE_LINES_PKG.g_rec_lines.array_balance_type_code(XLA_AE_LINES_PKG.g_LineNumber) := l_balance_type_code;
4276:
4277: XLA_AE_LINES_PKG.g_rec_lines.array_ledger_id(XLA_AE_LINES_PKG.g_LineNumber) :=
4278: XLA_AE_JOURNAL_ENTRY_PKG.g_cache_event.target_ledger_id;
4279:
4280: -- 4955764
4281: XLA_AE_LINES_PKG.g_rec_lines.array_gl_date(XLA_AE_LINES_PKG.g_LineNumber) :=
4282: XLA_AE_HEADER_PKG.g_rec_header_new.array_gl_date(g_array_event(p_event_id).array_value_num('header_index'));

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

4318: l_enc_upg_option := XLA_AE_LINES_PKG.g_rec_lines.array_enc_upg_option(XLA_AE_LINES_PKG.g_LineNumber);
4319:
4320: IF xla_accounting_cache_pkg.GetValueChar
4321: (p_source_code => 'LEDGER_CATEGORY_CODE'
4322: ,p_target_ledger_id => XLA_AE_JOURNAL_ENTRY_PKG.g_cache_event.target_ledger_id) IN ('PRIMARY','ALC')
4323: AND l_bflow_method_code = 'PRIOR_ENTRY'
4324: -- AND (l_actual_upg_option = 'Y' OR l_enc_upg_option = 'Y') Bug 4922099
4325: AND ( (NVL(l_actual_upg_option, 'N') IN ('Y', 'O')) OR
4326: (NVL(l_enc_upg_option, 'N') IN ('Y', 'O'))

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

4469: p_lookup_type => 'XLA_OWNER_TYPE'
4470: ,p_lookup_code => l_component_type_code
4471: )
4472: ,p_token_4 => 'PRODUCT_NAME'
4473: ,p_value_4 => XLA_AE_JOURNAL_ENTRY_PKG.g_cache_event.application_name
4474: ,p_entity_id => XLA_AE_JOURNAL_ENTRY_PKG.g_cache_event.entity_id
4475: ,p_event_id => XLA_AE_JOURNAL_ENTRY_PKG.g_cache_event.event_id
4476: ,p_ledger_id => XLA_AE_JOURNAL_ENTRY_PKG.g_cache_event.target_ledger_id
4477: ,p_ae_header_id => NULL

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

4470: ,p_lookup_code => l_component_type_code
4471: )
4472: ,p_token_4 => 'PRODUCT_NAME'
4473: ,p_value_4 => XLA_AE_JOURNAL_ENTRY_PKG.g_cache_event.application_name
4474: ,p_entity_id => XLA_AE_JOURNAL_ENTRY_PKG.g_cache_event.entity_id
4475: ,p_event_id => XLA_AE_JOURNAL_ENTRY_PKG.g_cache_event.event_id
4476: ,p_ledger_id => XLA_AE_JOURNAL_ENTRY_PKG.g_cache_event.target_ledger_id
4477: ,p_ae_header_id => NULL
4478: );

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

4471: )
4472: ,p_token_4 => 'PRODUCT_NAME'
4473: ,p_value_4 => XLA_AE_JOURNAL_ENTRY_PKG.g_cache_event.application_name
4474: ,p_entity_id => XLA_AE_JOURNAL_ENTRY_PKG.g_cache_event.entity_id
4475: ,p_event_id => XLA_AE_JOURNAL_ENTRY_PKG.g_cache_event.event_id
4476: ,p_ledger_id => XLA_AE_JOURNAL_ENTRY_PKG.g_cache_event.target_ledger_id
4477: ,p_ae_header_id => NULL
4478: );
4479:

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

4472: ,p_token_4 => 'PRODUCT_NAME'
4473: ,p_value_4 => XLA_AE_JOURNAL_ENTRY_PKG.g_cache_event.application_name
4474: ,p_entity_id => XLA_AE_JOURNAL_ENTRY_PKG.g_cache_event.entity_id
4475: ,p_event_id => XLA_AE_JOURNAL_ENTRY_PKG.g_cache_event.event_id
4476: ,p_ledger_id => XLA_AE_JOURNAL_ENTRY_PKG.g_cache_event.target_ledger_id
4477: ,p_ae_header_id => NULL
4478: );
4479:
4480: IF (C_LEVEL_ERROR>= g_log_level) THEN

Line 4507: XLA_AE_JOURNAL_ENTRY_PKG.UpdateJournalEntryStatus

4503: ----------------------------------------------------------------------------------
4504: -- 4219869 Business Flow
4505: -- Update journal entry status -- Need to generate this within IF
4506: ----------------------------------------------------------------------------------
4507: XLA_AE_JOURNAL_ENTRY_PKG.UpdateJournalEntryStatus
4508: (p_hdr_idx => g_array_event(p_event_id).array_value_num('header_index')
4509: ,p_balance_type_code => l_balance_type_code
4510: );
4511:

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

4548:
4549: --
4550: -- Depending on the Reversal Method setup, do a switch side or changes sign for the amounts
4551: --
4552: IF (XLA_AE_JOURNAL_ENTRY_PKG.g_cache_ledgers_info.ledger_reversal_option = 'SIDE') THEN
4553: XLA_AE_LINES_PKG.g_rec_lines.array_natural_side_code(XLA_AE_LINES_PKG.g_LineNumber) := l_acc_rev_natural_side_code;
4554: ELSE
4555: ---------------------------------------------------------------------------------------------------
4556: -- 4262811a Switch Sign

Line 4577: XLA_AE_JOURNAL_ENTRY_PKG.UpdateJournalEntryStatus

4573:
4574: XLA_AE_LINES_PKG.ValidateCurrentLine;
4575: XLA_AE_LINES_PKG.SetDebitCreditAmounts;
4576:
4577: XLA_AE_JOURNAL_ENTRY_PKG.UpdateJournalEntryStatus
4578: (p_hdr_idx => g_array_event(p_event_id).array_value_num('acc_rev_header_index')
4579: ,p_balance_type_code => l_balance_type_code);
4580:
4581: END IF;

Line 4698: l_gl_dates xla_ae_journal_entry_pkg.t_array_date;

4694: l_tmp_amt NUMBER;
4695: l_acc_rev_natural_side_code VARCHAR2(1);
4696:
4697: l_num_entries NUMBER;
4698: l_gl_dates xla_ae_journal_entry_pkg.t_array_date;
4699: l_accted_amts xla_ae_journal_entry_pkg.t_array_num;
4700: l_entered_amts xla_ae_journal_entry_pkg.t_array_num;
4701: l_period_names xla_ae_journal_entry_pkg.t_array_V15L;
4702: l_recog_line_1 NUMBER;

Line 4699: l_accted_amts xla_ae_journal_entry_pkg.t_array_num;

4695: l_acc_rev_natural_side_code VARCHAR2(1);
4696:
4697: l_num_entries NUMBER;
4698: l_gl_dates xla_ae_journal_entry_pkg.t_array_date;
4699: l_accted_amts xla_ae_journal_entry_pkg.t_array_num;
4700: l_entered_amts xla_ae_journal_entry_pkg.t_array_num;
4701: l_period_names xla_ae_journal_entry_pkg.t_array_V15L;
4702: l_recog_line_1 NUMBER;
4703: l_recog_line_2 NUMBER;

Line 4700: l_entered_amts xla_ae_journal_entry_pkg.t_array_num;

4696:
4697: l_num_entries NUMBER;
4698: l_gl_dates xla_ae_journal_entry_pkg.t_array_date;
4699: l_accted_amts xla_ae_journal_entry_pkg.t_array_num;
4700: l_entered_amts xla_ae_journal_entry_pkg.t_array_num;
4701: l_period_names xla_ae_journal_entry_pkg.t_array_V15L;
4702: l_recog_line_1 NUMBER;
4703: l_recog_line_2 NUMBER;
4704:

Line 4701: l_period_names xla_ae_journal_entry_pkg.t_array_V15L;

4697: l_num_entries NUMBER;
4698: l_gl_dates xla_ae_journal_entry_pkg.t_array_date;
4699: l_accted_amts xla_ae_journal_entry_pkg.t_array_num;
4700: l_entered_amts xla_ae_journal_entry_pkg.t_array_num;
4701: l_period_names xla_ae_journal_entry_pkg.t_array_V15L;
4702: l_recog_line_1 NUMBER;
4703: l_recog_line_2 NUMBER;
4704:
4705: l_bflow_applied_to_amt_idx NUMBER; -- 5132302

Line 4707: l_bflow_applied_to_amts xla_ae_journal_entry_pkg.t_array_num; -- 5132302

4703: l_recog_line_2 NUMBER;
4704:
4705: l_bflow_applied_to_amt_idx NUMBER; -- 5132302
4706: l_bflow_applied_to_amt NUMBER; -- 5132302
4707: l_bflow_applied_to_amts xla_ae_journal_entry_pkg.t_array_num; -- 5132302
4708:
4709: l_event_id NUMBER; -- To handle MPA header Description: xla_ae_header_pkg.SetHdrDescription
4710:
4711: --l_rounding_ccy VARCHAR2(15); -- To handle MPA rounding 4262811b

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

4778: l_accrual_line_num := NULL; -- 4262811
4779: l_tmp_amt := NULL; -- 4262811
4780: --
4781:
4782: IF XLA_AE_JOURNAL_ENTRY_PKG.g_cache_event.target_ledger_id = XLA_AE_JOURNAL_ENTRY_PKG.g_cache_event.ledger_id OR
4783: l_balance_type_code <> 'B' THEN
4784: IF NVL(p_source_7,'
4785: ') <> 'SUBSIDY' AND
4786: NVL(p_source_8,'

Line 4863: XLA_AE_JOURNAL_ENTRY_PKG.g_cache_event.target_ledger_id;

4859: --
4860: XLA_AE_LINES_PKG.g_rec_lines.array_balance_type_code(XLA_AE_LINES_PKG.g_LineNumber) := l_balance_type_code;
4861:
4862: XLA_AE_LINES_PKG.g_rec_lines.array_ledger_id(XLA_AE_LINES_PKG.g_LineNumber) :=
4863: XLA_AE_JOURNAL_ENTRY_PKG.g_cache_event.target_ledger_id;
4864:
4865: -- 4955764
4866: XLA_AE_LINES_PKG.g_rec_lines.array_gl_date(XLA_AE_LINES_PKG.g_LineNumber) :=
4867: XLA_AE_HEADER_PKG.g_rec_header_new.array_gl_date(g_array_event(p_event_id).array_value_num('header_index'));

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

4903: l_enc_upg_option := XLA_AE_LINES_PKG.g_rec_lines.array_enc_upg_option(XLA_AE_LINES_PKG.g_LineNumber);
4904:
4905: IF xla_accounting_cache_pkg.GetValueChar
4906: (p_source_code => 'LEDGER_CATEGORY_CODE'
4907: ,p_target_ledger_id => XLA_AE_JOURNAL_ENTRY_PKG.g_cache_event.target_ledger_id) IN ('PRIMARY','ALC')
4908: AND l_bflow_method_code = 'PRIOR_ENTRY'
4909: -- AND (l_actual_upg_option = 'Y' OR l_enc_upg_option = 'Y') Bug 4922099
4910: AND ( (NVL(l_actual_upg_option, 'N') IN ('Y', 'O')) OR
4911: (NVL(l_enc_upg_option, 'N') IN ('Y', 'O'))

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

5054: p_lookup_type => 'XLA_OWNER_TYPE'
5055: ,p_lookup_code => l_component_type_code
5056: )
5057: ,p_token_4 => 'PRODUCT_NAME'
5058: ,p_value_4 => XLA_AE_JOURNAL_ENTRY_PKG.g_cache_event.application_name
5059: ,p_entity_id => XLA_AE_JOURNAL_ENTRY_PKG.g_cache_event.entity_id
5060: ,p_event_id => XLA_AE_JOURNAL_ENTRY_PKG.g_cache_event.event_id
5061: ,p_ledger_id => XLA_AE_JOURNAL_ENTRY_PKG.g_cache_event.target_ledger_id
5062: ,p_ae_header_id => NULL

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

5055: ,p_lookup_code => l_component_type_code
5056: )
5057: ,p_token_4 => 'PRODUCT_NAME'
5058: ,p_value_4 => XLA_AE_JOURNAL_ENTRY_PKG.g_cache_event.application_name
5059: ,p_entity_id => XLA_AE_JOURNAL_ENTRY_PKG.g_cache_event.entity_id
5060: ,p_event_id => XLA_AE_JOURNAL_ENTRY_PKG.g_cache_event.event_id
5061: ,p_ledger_id => XLA_AE_JOURNAL_ENTRY_PKG.g_cache_event.target_ledger_id
5062: ,p_ae_header_id => NULL
5063: );

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

5056: )
5057: ,p_token_4 => 'PRODUCT_NAME'
5058: ,p_value_4 => XLA_AE_JOURNAL_ENTRY_PKG.g_cache_event.application_name
5059: ,p_entity_id => XLA_AE_JOURNAL_ENTRY_PKG.g_cache_event.entity_id
5060: ,p_event_id => XLA_AE_JOURNAL_ENTRY_PKG.g_cache_event.event_id
5061: ,p_ledger_id => XLA_AE_JOURNAL_ENTRY_PKG.g_cache_event.target_ledger_id
5062: ,p_ae_header_id => NULL
5063: );
5064:

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

5057: ,p_token_4 => 'PRODUCT_NAME'
5058: ,p_value_4 => XLA_AE_JOURNAL_ENTRY_PKG.g_cache_event.application_name
5059: ,p_entity_id => XLA_AE_JOURNAL_ENTRY_PKG.g_cache_event.entity_id
5060: ,p_event_id => XLA_AE_JOURNAL_ENTRY_PKG.g_cache_event.event_id
5061: ,p_ledger_id => XLA_AE_JOURNAL_ENTRY_PKG.g_cache_event.target_ledger_id
5062: ,p_ae_header_id => NULL
5063: );
5064:
5065: IF (C_LEVEL_ERROR>= g_log_level) THEN

Line 5092: XLA_AE_JOURNAL_ENTRY_PKG.UpdateJournalEntryStatus

5088: ----------------------------------------------------------------------------------
5089: -- 4219869 Business Flow
5090: -- Update journal entry status -- Need to generate this within IF
5091: ----------------------------------------------------------------------------------
5092: XLA_AE_JOURNAL_ENTRY_PKG.UpdateJournalEntryStatus
5093: (p_hdr_idx => g_array_event(p_event_id).array_value_num('header_index')
5094: ,p_balance_type_code => l_balance_type_code
5095: );
5096:

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

5133:
5134: --
5135: -- Depending on the Reversal Method setup, do a switch side or changes sign for the amounts
5136: --
5137: IF (XLA_AE_JOURNAL_ENTRY_PKG.g_cache_ledgers_info.ledger_reversal_option = 'SIDE') THEN
5138: XLA_AE_LINES_PKG.g_rec_lines.array_natural_side_code(XLA_AE_LINES_PKG.g_LineNumber) := l_acc_rev_natural_side_code;
5139: ELSE
5140: ---------------------------------------------------------------------------------------------------
5141: -- 4262811a Switch Sign

Line 5162: XLA_AE_JOURNAL_ENTRY_PKG.UpdateJournalEntryStatus

5158:
5159: XLA_AE_LINES_PKG.ValidateCurrentLine;
5160: XLA_AE_LINES_PKG.SetDebitCreditAmounts;
5161:
5162: XLA_AE_JOURNAL_ENTRY_PKG.UpdateJournalEntryStatus
5163: (p_hdr_idx => g_array_event(p_event_id).array_value_num('acc_rev_header_index')
5164: ,p_balance_type_code => l_balance_type_code);
5165:
5166: END IF;

Line 5281: l_gl_dates xla_ae_journal_entry_pkg.t_array_date;

5277: l_tmp_amt NUMBER;
5278: l_acc_rev_natural_side_code VARCHAR2(1);
5279:
5280: l_num_entries NUMBER;
5281: l_gl_dates xla_ae_journal_entry_pkg.t_array_date;
5282: l_accted_amts xla_ae_journal_entry_pkg.t_array_num;
5283: l_entered_amts xla_ae_journal_entry_pkg.t_array_num;
5284: l_period_names xla_ae_journal_entry_pkg.t_array_V15L;
5285: l_recog_line_1 NUMBER;

Line 5282: l_accted_amts xla_ae_journal_entry_pkg.t_array_num;

5278: l_acc_rev_natural_side_code VARCHAR2(1);
5279:
5280: l_num_entries NUMBER;
5281: l_gl_dates xla_ae_journal_entry_pkg.t_array_date;
5282: l_accted_amts xla_ae_journal_entry_pkg.t_array_num;
5283: l_entered_amts xla_ae_journal_entry_pkg.t_array_num;
5284: l_period_names xla_ae_journal_entry_pkg.t_array_V15L;
5285: l_recog_line_1 NUMBER;
5286: l_recog_line_2 NUMBER;

Line 5283: l_entered_amts xla_ae_journal_entry_pkg.t_array_num;

5279:
5280: l_num_entries NUMBER;
5281: l_gl_dates xla_ae_journal_entry_pkg.t_array_date;
5282: l_accted_amts xla_ae_journal_entry_pkg.t_array_num;
5283: l_entered_amts xla_ae_journal_entry_pkg.t_array_num;
5284: l_period_names xla_ae_journal_entry_pkg.t_array_V15L;
5285: l_recog_line_1 NUMBER;
5286: l_recog_line_2 NUMBER;
5287:

Line 5284: l_period_names xla_ae_journal_entry_pkg.t_array_V15L;

5280: l_num_entries NUMBER;
5281: l_gl_dates xla_ae_journal_entry_pkg.t_array_date;
5282: l_accted_amts xla_ae_journal_entry_pkg.t_array_num;
5283: l_entered_amts xla_ae_journal_entry_pkg.t_array_num;
5284: l_period_names xla_ae_journal_entry_pkg.t_array_V15L;
5285: l_recog_line_1 NUMBER;
5286: l_recog_line_2 NUMBER;
5287:
5288: l_bflow_applied_to_amt_idx NUMBER; -- 5132302

Line 5290: l_bflow_applied_to_amts xla_ae_journal_entry_pkg.t_array_num; -- 5132302

5286: l_recog_line_2 NUMBER;
5287:
5288: l_bflow_applied_to_amt_idx NUMBER; -- 5132302
5289: l_bflow_applied_to_amt NUMBER; -- 5132302
5290: l_bflow_applied_to_amts xla_ae_journal_entry_pkg.t_array_num; -- 5132302
5291:
5292: l_event_id NUMBER; -- To handle MPA header Description: xla_ae_header_pkg.SetHdrDescription
5293:
5294: --l_rounding_ccy VARCHAR2(15); -- To handle MPA rounding 4262811b

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

5361: l_accrual_line_num := NULL; -- 4262811
5362: l_tmp_amt := NULL; -- 4262811
5363: --
5364:
5365: IF XLA_AE_JOURNAL_ENTRY_PKG.g_cache_event.target_ledger_id = XLA_AE_JOURNAL_ENTRY_PKG.g_cache_event.ledger_id OR
5366: l_balance_type_code <> 'B' THEN
5367: IF NVL(p_source_7,'
5368: ') <> 'SUBSIDY' AND
5369: NVL(p_source_8,'

Line 5441: XLA_AE_JOURNAL_ENTRY_PKG.g_cache_event.target_ledger_id;

5437: --
5438: XLA_AE_LINES_PKG.g_rec_lines.array_balance_type_code(XLA_AE_LINES_PKG.g_LineNumber) := l_balance_type_code;
5439:
5440: XLA_AE_LINES_PKG.g_rec_lines.array_ledger_id(XLA_AE_LINES_PKG.g_LineNumber) :=
5441: XLA_AE_JOURNAL_ENTRY_PKG.g_cache_event.target_ledger_id;
5442:
5443: -- 4955764
5444: XLA_AE_LINES_PKG.g_rec_lines.array_gl_date(XLA_AE_LINES_PKG.g_LineNumber) :=
5445: XLA_AE_HEADER_PKG.g_rec_header_new.array_gl_date(g_array_event(p_event_id).array_value_num('header_index'));

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

5481: l_enc_upg_option := XLA_AE_LINES_PKG.g_rec_lines.array_enc_upg_option(XLA_AE_LINES_PKG.g_LineNumber);
5482:
5483: IF xla_accounting_cache_pkg.GetValueChar
5484: (p_source_code => 'LEDGER_CATEGORY_CODE'
5485: ,p_target_ledger_id => XLA_AE_JOURNAL_ENTRY_PKG.g_cache_event.target_ledger_id) IN ('PRIMARY','ALC')
5486: AND l_bflow_method_code = 'PRIOR_ENTRY'
5487: -- AND (l_actual_upg_option = 'Y' OR l_enc_upg_option = 'Y') Bug 4922099
5488: AND ( (NVL(l_actual_upg_option, 'N') IN ('Y', 'O')) OR
5489: (NVL(l_enc_upg_option, 'N') IN ('Y', 'O'))

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

5632: p_lookup_type => 'XLA_OWNER_TYPE'
5633: ,p_lookup_code => l_component_type_code
5634: )
5635: ,p_token_4 => 'PRODUCT_NAME'
5636: ,p_value_4 => XLA_AE_JOURNAL_ENTRY_PKG.g_cache_event.application_name
5637: ,p_entity_id => XLA_AE_JOURNAL_ENTRY_PKG.g_cache_event.entity_id
5638: ,p_event_id => XLA_AE_JOURNAL_ENTRY_PKG.g_cache_event.event_id
5639: ,p_ledger_id => XLA_AE_JOURNAL_ENTRY_PKG.g_cache_event.target_ledger_id
5640: ,p_ae_header_id => NULL

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

5633: ,p_lookup_code => l_component_type_code
5634: )
5635: ,p_token_4 => 'PRODUCT_NAME'
5636: ,p_value_4 => XLA_AE_JOURNAL_ENTRY_PKG.g_cache_event.application_name
5637: ,p_entity_id => XLA_AE_JOURNAL_ENTRY_PKG.g_cache_event.entity_id
5638: ,p_event_id => XLA_AE_JOURNAL_ENTRY_PKG.g_cache_event.event_id
5639: ,p_ledger_id => XLA_AE_JOURNAL_ENTRY_PKG.g_cache_event.target_ledger_id
5640: ,p_ae_header_id => NULL
5641: );

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

5634: )
5635: ,p_token_4 => 'PRODUCT_NAME'
5636: ,p_value_4 => XLA_AE_JOURNAL_ENTRY_PKG.g_cache_event.application_name
5637: ,p_entity_id => XLA_AE_JOURNAL_ENTRY_PKG.g_cache_event.entity_id
5638: ,p_event_id => XLA_AE_JOURNAL_ENTRY_PKG.g_cache_event.event_id
5639: ,p_ledger_id => XLA_AE_JOURNAL_ENTRY_PKG.g_cache_event.target_ledger_id
5640: ,p_ae_header_id => NULL
5641: );
5642:

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

5635: ,p_token_4 => 'PRODUCT_NAME'
5636: ,p_value_4 => XLA_AE_JOURNAL_ENTRY_PKG.g_cache_event.application_name
5637: ,p_entity_id => XLA_AE_JOURNAL_ENTRY_PKG.g_cache_event.entity_id
5638: ,p_event_id => XLA_AE_JOURNAL_ENTRY_PKG.g_cache_event.event_id
5639: ,p_ledger_id => XLA_AE_JOURNAL_ENTRY_PKG.g_cache_event.target_ledger_id
5640: ,p_ae_header_id => NULL
5641: );
5642:
5643: IF (C_LEVEL_ERROR>= g_log_level) THEN

Line 5670: XLA_AE_JOURNAL_ENTRY_PKG.UpdateJournalEntryStatus

5666: ----------------------------------------------------------------------------------
5667: -- 4219869 Business Flow
5668: -- Update journal entry status -- Need to generate this within IF
5669: ----------------------------------------------------------------------------------
5670: XLA_AE_JOURNAL_ENTRY_PKG.UpdateJournalEntryStatus
5671: (p_hdr_idx => g_array_event(p_event_id).array_value_num('header_index')
5672: ,p_balance_type_code => l_balance_type_code
5673: );
5674:

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

5711:
5712: --
5713: -- Depending on the Reversal Method setup, do a switch side or changes sign for the amounts
5714: --
5715: IF (XLA_AE_JOURNAL_ENTRY_PKG.g_cache_ledgers_info.ledger_reversal_option = 'SIDE') THEN
5716: XLA_AE_LINES_PKG.g_rec_lines.array_natural_side_code(XLA_AE_LINES_PKG.g_LineNumber) := l_acc_rev_natural_side_code;
5717: ELSE
5718: ---------------------------------------------------------------------------------------------------
5719: -- 4262811a Switch Sign

Line 5740: XLA_AE_JOURNAL_ENTRY_PKG.UpdateJournalEntryStatus

5736:
5737: XLA_AE_LINES_PKG.ValidateCurrentLine;
5738: XLA_AE_LINES_PKG.SetDebitCreditAmounts;
5739:
5740: XLA_AE_JOURNAL_ENTRY_PKG.UpdateJournalEntryStatus
5741: (p_hdr_idx => g_array_event(p_event_id).array_value_num('acc_rev_header_index')
5742: ,p_balance_type_code => l_balance_type_code);
5743:
5744: END IF;

Line 6199: l_array_legal_entity_id XLA_AE_JOURNAL_ENTRY_PKG.t_array_Num;

6195:
6196: l_calculate_acctd_flag VARCHAR2(1) :='Y';
6197: l_calculate_g_l_flag VARCHAR2(1) :='Y';
6198: --
6199: l_array_legal_entity_id XLA_AE_JOURNAL_ENTRY_PKG.t_array_Num;
6200: l_array_entity_id XLA_AE_JOURNAL_ENTRY_PKG.t_array_Num;
6201: l_array_entity_code XLA_AE_JOURNAL_ENTRY_PKG.t_array_V30L;
6202: l_array_transaction_num XLA_AE_JOURNAL_ENTRY_PKG.t_array_V240L;
6203: l_array_event_id XLA_AE_JOURNAL_ENTRY_PKG.t_array_Num;

Line 6200: l_array_entity_id XLA_AE_JOURNAL_ENTRY_PKG.t_array_Num;

6196: l_calculate_acctd_flag VARCHAR2(1) :='Y';
6197: l_calculate_g_l_flag VARCHAR2(1) :='Y';
6198: --
6199: l_array_legal_entity_id XLA_AE_JOURNAL_ENTRY_PKG.t_array_Num;
6200: l_array_entity_id XLA_AE_JOURNAL_ENTRY_PKG.t_array_Num;
6201: l_array_entity_code XLA_AE_JOURNAL_ENTRY_PKG.t_array_V30L;
6202: l_array_transaction_num XLA_AE_JOURNAL_ENTRY_PKG.t_array_V240L;
6203: l_array_event_id XLA_AE_JOURNAL_ENTRY_PKG.t_array_Num;
6204: l_array_class_code XLA_AE_JOURNAL_ENTRY_PKG.t_array_V30L;

Line 6201: l_array_entity_code XLA_AE_JOURNAL_ENTRY_PKG.t_array_V30L;

6197: l_calculate_g_l_flag VARCHAR2(1) :='Y';
6198: --
6199: l_array_legal_entity_id XLA_AE_JOURNAL_ENTRY_PKG.t_array_Num;
6200: l_array_entity_id XLA_AE_JOURNAL_ENTRY_PKG.t_array_Num;
6201: l_array_entity_code XLA_AE_JOURNAL_ENTRY_PKG.t_array_V30L;
6202: l_array_transaction_num XLA_AE_JOURNAL_ENTRY_PKG.t_array_V240L;
6203: l_array_event_id XLA_AE_JOURNAL_ENTRY_PKG.t_array_Num;
6204: l_array_class_code XLA_AE_JOURNAL_ENTRY_PKG.t_array_V30L;
6205: l_array_event_type XLA_AE_JOURNAL_ENTRY_PKG.t_array_V30L;

Line 6202: l_array_transaction_num XLA_AE_JOURNAL_ENTRY_PKG.t_array_V240L;

6198: --
6199: l_array_legal_entity_id XLA_AE_JOURNAL_ENTRY_PKG.t_array_Num;
6200: l_array_entity_id XLA_AE_JOURNAL_ENTRY_PKG.t_array_Num;
6201: l_array_entity_code XLA_AE_JOURNAL_ENTRY_PKG.t_array_V30L;
6202: l_array_transaction_num XLA_AE_JOURNAL_ENTRY_PKG.t_array_V240L;
6203: l_array_event_id XLA_AE_JOURNAL_ENTRY_PKG.t_array_Num;
6204: l_array_class_code XLA_AE_JOURNAL_ENTRY_PKG.t_array_V30L;
6205: l_array_event_type XLA_AE_JOURNAL_ENTRY_PKG.t_array_V30L;
6206: l_array_event_number XLA_AE_JOURNAL_ENTRY_PKG.t_array_Num;

Line 6203: l_array_event_id XLA_AE_JOURNAL_ENTRY_PKG.t_array_Num;

6199: l_array_legal_entity_id XLA_AE_JOURNAL_ENTRY_PKG.t_array_Num;
6200: l_array_entity_id XLA_AE_JOURNAL_ENTRY_PKG.t_array_Num;
6201: l_array_entity_code XLA_AE_JOURNAL_ENTRY_PKG.t_array_V30L;
6202: l_array_transaction_num XLA_AE_JOURNAL_ENTRY_PKG.t_array_V240L;
6203: l_array_event_id XLA_AE_JOURNAL_ENTRY_PKG.t_array_Num;
6204: l_array_class_code XLA_AE_JOURNAL_ENTRY_PKG.t_array_V30L;
6205: l_array_event_type XLA_AE_JOURNAL_ENTRY_PKG.t_array_V30L;
6206: l_array_event_number XLA_AE_JOURNAL_ENTRY_PKG.t_array_Num;
6207: l_array_event_date XLA_AE_JOURNAL_ENTRY_PKG.t_array_Date;

Line 6204: l_array_class_code XLA_AE_JOURNAL_ENTRY_PKG.t_array_V30L;

6200: l_array_entity_id XLA_AE_JOURNAL_ENTRY_PKG.t_array_Num;
6201: l_array_entity_code XLA_AE_JOURNAL_ENTRY_PKG.t_array_V30L;
6202: l_array_transaction_num XLA_AE_JOURNAL_ENTRY_PKG.t_array_V240L;
6203: l_array_event_id XLA_AE_JOURNAL_ENTRY_PKG.t_array_Num;
6204: l_array_class_code XLA_AE_JOURNAL_ENTRY_PKG.t_array_V30L;
6205: l_array_event_type XLA_AE_JOURNAL_ENTRY_PKG.t_array_V30L;
6206: l_array_event_number XLA_AE_JOURNAL_ENTRY_PKG.t_array_Num;
6207: l_array_event_date XLA_AE_JOURNAL_ENTRY_PKG.t_array_Date;
6208: l_array_transaction_date XLA_AE_JOURNAL_ENTRY_PKG.t_array_Date;

Line 6205: l_array_event_type XLA_AE_JOURNAL_ENTRY_PKG.t_array_V30L;

6201: l_array_entity_code XLA_AE_JOURNAL_ENTRY_PKG.t_array_V30L;
6202: l_array_transaction_num XLA_AE_JOURNAL_ENTRY_PKG.t_array_V240L;
6203: l_array_event_id XLA_AE_JOURNAL_ENTRY_PKG.t_array_Num;
6204: l_array_class_code XLA_AE_JOURNAL_ENTRY_PKG.t_array_V30L;
6205: l_array_event_type XLA_AE_JOURNAL_ENTRY_PKG.t_array_V30L;
6206: l_array_event_number XLA_AE_JOURNAL_ENTRY_PKG.t_array_Num;
6207: l_array_event_date XLA_AE_JOURNAL_ENTRY_PKG.t_array_Date;
6208: l_array_transaction_date XLA_AE_JOURNAL_ENTRY_PKG.t_array_Date;
6209: l_array_reference_num_1 XLA_AE_JOURNAL_ENTRY_PKG.t_array_Num;

Line 6206: l_array_event_number XLA_AE_JOURNAL_ENTRY_PKG.t_array_Num;

6202: l_array_transaction_num XLA_AE_JOURNAL_ENTRY_PKG.t_array_V240L;
6203: l_array_event_id XLA_AE_JOURNAL_ENTRY_PKG.t_array_Num;
6204: l_array_class_code XLA_AE_JOURNAL_ENTRY_PKG.t_array_V30L;
6205: l_array_event_type XLA_AE_JOURNAL_ENTRY_PKG.t_array_V30L;
6206: l_array_event_number XLA_AE_JOURNAL_ENTRY_PKG.t_array_Num;
6207: l_array_event_date XLA_AE_JOURNAL_ENTRY_PKG.t_array_Date;
6208: l_array_transaction_date XLA_AE_JOURNAL_ENTRY_PKG.t_array_Date;
6209: l_array_reference_num_1 XLA_AE_JOURNAL_ENTRY_PKG.t_array_Num;
6210: l_array_reference_num_2 XLA_AE_JOURNAL_ENTRY_PKG.t_array_Num;

Line 6207: l_array_event_date XLA_AE_JOURNAL_ENTRY_PKG.t_array_Date;

6203: l_array_event_id XLA_AE_JOURNAL_ENTRY_PKG.t_array_Num;
6204: l_array_class_code XLA_AE_JOURNAL_ENTRY_PKG.t_array_V30L;
6205: l_array_event_type XLA_AE_JOURNAL_ENTRY_PKG.t_array_V30L;
6206: l_array_event_number XLA_AE_JOURNAL_ENTRY_PKG.t_array_Num;
6207: l_array_event_date XLA_AE_JOURNAL_ENTRY_PKG.t_array_Date;
6208: l_array_transaction_date XLA_AE_JOURNAL_ENTRY_PKG.t_array_Date;
6209: l_array_reference_num_1 XLA_AE_JOURNAL_ENTRY_PKG.t_array_Num;
6210: l_array_reference_num_2 XLA_AE_JOURNAL_ENTRY_PKG.t_array_Num;
6211: l_array_reference_num_3 XLA_AE_JOURNAL_ENTRY_PKG.t_array_Num;

Line 6208: l_array_transaction_date XLA_AE_JOURNAL_ENTRY_PKG.t_array_Date;

6204: l_array_class_code XLA_AE_JOURNAL_ENTRY_PKG.t_array_V30L;
6205: l_array_event_type XLA_AE_JOURNAL_ENTRY_PKG.t_array_V30L;
6206: l_array_event_number XLA_AE_JOURNAL_ENTRY_PKG.t_array_Num;
6207: l_array_event_date XLA_AE_JOURNAL_ENTRY_PKG.t_array_Date;
6208: l_array_transaction_date XLA_AE_JOURNAL_ENTRY_PKG.t_array_Date;
6209: l_array_reference_num_1 XLA_AE_JOURNAL_ENTRY_PKG.t_array_Num;
6210: l_array_reference_num_2 XLA_AE_JOURNAL_ENTRY_PKG.t_array_Num;
6211: l_array_reference_num_3 XLA_AE_JOURNAL_ENTRY_PKG.t_array_Num;
6212: l_array_reference_num_4 XLA_AE_JOURNAL_ENTRY_PKG.t_array_Num;

Line 6209: l_array_reference_num_1 XLA_AE_JOURNAL_ENTRY_PKG.t_array_Num;

6205: l_array_event_type XLA_AE_JOURNAL_ENTRY_PKG.t_array_V30L;
6206: l_array_event_number XLA_AE_JOURNAL_ENTRY_PKG.t_array_Num;
6207: l_array_event_date XLA_AE_JOURNAL_ENTRY_PKG.t_array_Date;
6208: l_array_transaction_date XLA_AE_JOURNAL_ENTRY_PKG.t_array_Date;
6209: l_array_reference_num_1 XLA_AE_JOURNAL_ENTRY_PKG.t_array_Num;
6210: l_array_reference_num_2 XLA_AE_JOURNAL_ENTRY_PKG.t_array_Num;
6211: l_array_reference_num_3 XLA_AE_JOURNAL_ENTRY_PKG.t_array_Num;
6212: l_array_reference_num_4 XLA_AE_JOURNAL_ENTRY_PKG.t_array_Num;
6213: l_array_reference_char_1 XLA_AE_JOURNAL_ENTRY_PKG.t_array_V240L;

Line 6210: l_array_reference_num_2 XLA_AE_JOURNAL_ENTRY_PKG.t_array_Num;

6206: l_array_event_number XLA_AE_JOURNAL_ENTRY_PKG.t_array_Num;
6207: l_array_event_date XLA_AE_JOURNAL_ENTRY_PKG.t_array_Date;
6208: l_array_transaction_date XLA_AE_JOURNAL_ENTRY_PKG.t_array_Date;
6209: l_array_reference_num_1 XLA_AE_JOURNAL_ENTRY_PKG.t_array_Num;
6210: l_array_reference_num_2 XLA_AE_JOURNAL_ENTRY_PKG.t_array_Num;
6211: l_array_reference_num_3 XLA_AE_JOURNAL_ENTRY_PKG.t_array_Num;
6212: l_array_reference_num_4 XLA_AE_JOURNAL_ENTRY_PKG.t_array_Num;
6213: l_array_reference_char_1 XLA_AE_JOURNAL_ENTRY_PKG.t_array_V240L;
6214: l_array_reference_char_2 XLA_AE_JOURNAL_ENTRY_PKG.t_array_V240L;

Line 6211: l_array_reference_num_3 XLA_AE_JOURNAL_ENTRY_PKG.t_array_Num;

6207: l_array_event_date XLA_AE_JOURNAL_ENTRY_PKG.t_array_Date;
6208: l_array_transaction_date XLA_AE_JOURNAL_ENTRY_PKG.t_array_Date;
6209: l_array_reference_num_1 XLA_AE_JOURNAL_ENTRY_PKG.t_array_Num;
6210: l_array_reference_num_2 XLA_AE_JOURNAL_ENTRY_PKG.t_array_Num;
6211: l_array_reference_num_3 XLA_AE_JOURNAL_ENTRY_PKG.t_array_Num;
6212: l_array_reference_num_4 XLA_AE_JOURNAL_ENTRY_PKG.t_array_Num;
6213: l_array_reference_char_1 XLA_AE_JOURNAL_ENTRY_PKG.t_array_V240L;
6214: l_array_reference_char_2 XLA_AE_JOURNAL_ENTRY_PKG.t_array_V240L;
6215: l_array_reference_char_3 XLA_AE_JOURNAL_ENTRY_PKG.t_array_V240L;

Line 6212: l_array_reference_num_4 XLA_AE_JOURNAL_ENTRY_PKG.t_array_Num;

6208: l_array_transaction_date XLA_AE_JOURNAL_ENTRY_PKG.t_array_Date;
6209: l_array_reference_num_1 XLA_AE_JOURNAL_ENTRY_PKG.t_array_Num;
6210: l_array_reference_num_2 XLA_AE_JOURNAL_ENTRY_PKG.t_array_Num;
6211: l_array_reference_num_3 XLA_AE_JOURNAL_ENTRY_PKG.t_array_Num;
6212: l_array_reference_num_4 XLA_AE_JOURNAL_ENTRY_PKG.t_array_Num;
6213: l_array_reference_char_1 XLA_AE_JOURNAL_ENTRY_PKG.t_array_V240L;
6214: l_array_reference_char_2 XLA_AE_JOURNAL_ENTRY_PKG.t_array_V240L;
6215: l_array_reference_char_3 XLA_AE_JOURNAL_ENTRY_PKG.t_array_V240L;
6216: l_array_reference_char_4 XLA_AE_JOURNAL_ENTRY_PKG.t_array_V240L;

Line 6213: l_array_reference_char_1 XLA_AE_JOURNAL_ENTRY_PKG.t_array_V240L;

6209: l_array_reference_num_1 XLA_AE_JOURNAL_ENTRY_PKG.t_array_Num;
6210: l_array_reference_num_2 XLA_AE_JOURNAL_ENTRY_PKG.t_array_Num;
6211: l_array_reference_num_3 XLA_AE_JOURNAL_ENTRY_PKG.t_array_Num;
6212: l_array_reference_num_4 XLA_AE_JOURNAL_ENTRY_PKG.t_array_Num;
6213: l_array_reference_char_1 XLA_AE_JOURNAL_ENTRY_PKG.t_array_V240L;
6214: l_array_reference_char_2 XLA_AE_JOURNAL_ENTRY_PKG.t_array_V240L;
6215: l_array_reference_char_3 XLA_AE_JOURNAL_ENTRY_PKG.t_array_V240L;
6216: l_array_reference_char_4 XLA_AE_JOURNAL_ENTRY_PKG.t_array_V240L;
6217: l_array_reference_date_1 XLA_AE_JOURNAL_ENTRY_PKG.t_array_Date;

Line 6214: l_array_reference_char_2 XLA_AE_JOURNAL_ENTRY_PKG.t_array_V240L;

6210: l_array_reference_num_2 XLA_AE_JOURNAL_ENTRY_PKG.t_array_Num;
6211: l_array_reference_num_3 XLA_AE_JOURNAL_ENTRY_PKG.t_array_Num;
6212: l_array_reference_num_4 XLA_AE_JOURNAL_ENTRY_PKG.t_array_Num;
6213: l_array_reference_char_1 XLA_AE_JOURNAL_ENTRY_PKG.t_array_V240L;
6214: l_array_reference_char_2 XLA_AE_JOURNAL_ENTRY_PKG.t_array_V240L;
6215: l_array_reference_char_3 XLA_AE_JOURNAL_ENTRY_PKG.t_array_V240L;
6216: l_array_reference_char_4 XLA_AE_JOURNAL_ENTRY_PKG.t_array_V240L;
6217: l_array_reference_date_1 XLA_AE_JOURNAL_ENTRY_PKG.t_array_Date;
6218: l_array_reference_date_2 XLA_AE_JOURNAL_ENTRY_PKG.t_array_Date;

Line 6215: l_array_reference_char_3 XLA_AE_JOURNAL_ENTRY_PKG.t_array_V240L;

6211: l_array_reference_num_3 XLA_AE_JOURNAL_ENTRY_PKG.t_array_Num;
6212: l_array_reference_num_4 XLA_AE_JOURNAL_ENTRY_PKG.t_array_Num;
6213: l_array_reference_char_1 XLA_AE_JOURNAL_ENTRY_PKG.t_array_V240L;
6214: l_array_reference_char_2 XLA_AE_JOURNAL_ENTRY_PKG.t_array_V240L;
6215: l_array_reference_char_3 XLA_AE_JOURNAL_ENTRY_PKG.t_array_V240L;
6216: l_array_reference_char_4 XLA_AE_JOURNAL_ENTRY_PKG.t_array_V240L;
6217: l_array_reference_date_1 XLA_AE_JOURNAL_ENTRY_PKG.t_array_Date;
6218: l_array_reference_date_2 XLA_AE_JOURNAL_ENTRY_PKG.t_array_Date;
6219: l_array_reference_date_3 XLA_AE_JOURNAL_ENTRY_PKG.t_array_Date;

Line 6216: l_array_reference_char_4 XLA_AE_JOURNAL_ENTRY_PKG.t_array_V240L;

6212: l_array_reference_num_4 XLA_AE_JOURNAL_ENTRY_PKG.t_array_Num;
6213: l_array_reference_char_1 XLA_AE_JOURNAL_ENTRY_PKG.t_array_V240L;
6214: l_array_reference_char_2 XLA_AE_JOURNAL_ENTRY_PKG.t_array_V240L;
6215: l_array_reference_char_3 XLA_AE_JOURNAL_ENTRY_PKG.t_array_V240L;
6216: l_array_reference_char_4 XLA_AE_JOURNAL_ENTRY_PKG.t_array_V240L;
6217: l_array_reference_date_1 XLA_AE_JOURNAL_ENTRY_PKG.t_array_Date;
6218: l_array_reference_date_2 XLA_AE_JOURNAL_ENTRY_PKG.t_array_Date;
6219: l_array_reference_date_3 XLA_AE_JOURNAL_ENTRY_PKG.t_array_Date;
6220: l_array_reference_date_4 XLA_AE_JOURNAL_ENTRY_PKG.t_array_Date;

Line 6217: l_array_reference_date_1 XLA_AE_JOURNAL_ENTRY_PKG.t_array_Date;

6213: l_array_reference_char_1 XLA_AE_JOURNAL_ENTRY_PKG.t_array_V240L;
6214: l_array_reference_char_2 XLA_AE_JOURNAL_ENTRY_PKG.t_array_V240L;
6215: l_array_reference_char_3 XLA_AE_JOURNAL_ENTRY_PKG.t_array_V240L;
6216: l_array_reference_char_4 XLA_AE_JOURNAL_ENTRY_PKG.t_array_V240L;
6217: l_array_reference_date_1 XLA_AE_JOURNAL_ENTRY_PKG.t_array_Date;
6218: l_array_reference_date_2 XLA_AE_JOURNAL_ENTRY_PKG.t_array_Date;
6219: l_array_reference_date_3 XLA_AE_JOURNAL_ENTRY_PKG.t_array_Date;
6220: l_array_reference_date_4 XLA_AE_JOURNAL_ENTRY_PKG.t_array_Date;
6221: l_array_event_created_by XLA_AE_JOURNAL_ENTRY_PKG.t_array_V100L;

Line 6218: l_array_reference_date_2 XLA_AE_JOURNAL_ENTRY_PKG.t_array_Date;

6214: l_array_reference_char_2 XLA_AE_JOURNAL_ENTRY_PKG.t_array_V240L;
6215: l_array_reference_char_3 XLA_AE_JOURNAL_ENTRY_PKG.t_array_V240L;
6216: l_array_reference_char_4 XLA_AE_JOURNAL_ENTRY_PKG.t_array_V240L;
6217: l_array_reference_date_1 XLA_AE_JOURNAL_ENTRY_PKG.t_array_Date;
6218: l_array_reference_date_2 XLA_AE_JOURNAL_ENTRY_PKG.t_array_Date;
6219: l_array_reference_date_3 XLA_AE_JOURNAL_ENTRY_PKG.t_array_Date;
6220: l_array_reference_date_4 XLA_AE_JOURNAL_ENTRY_PKG.t_array_Date;
6221: l_array_event_created_by XLA_AE_JOURNAL_ENTRY_PKG.t_array_V100L;
6222: l_array_budgetary_control_flag XLA_AE_JOURNAL_ENTRY_PKG.t_array_V30L;

Line 6219: l_array_reference_date_3 XLA_AE_JOURNAL_ENTRY_PKG.t_array_Date;

6215: l_array_reference_char_3 XLA_AE_JOURNAL_ENTRY_PKG.t_array_V240L;
6216: l_array_reference_char_4 XLA_AE_JOURNAL_ENTRY_PKG.t_array_V240L;
6217: l_array_reference_date_1 XLA_AE_JOURNAL_ENTRY_PKG.t_array_Date;
6218: l_array_reference_date_2 XLA_AE_JOURNAL_ENTRY_PKG.t_array_Date;
6219: l_array_reference_date_3 XLA_AE_JOURNAL_ENTRY_PKG.t_array_Date;
6220: l_array_reference_date_4 XLA_AE_JOURNAL_ENTRY_PKG.t_array_Date;
6221: l_array_event_created_by XLA_AE_JOURNAL_ENTRY_PKG.t_array_V100L;
6222: l_array_budgetary_control_flag XLA_AE_JOURNAL_ENTRY_PKG.t_array_V30L;
6223:

Line 6220: l_array_reference_date_4 XLA_AE_JOURNAL_ENTRY_PKG.t_array_Date;

6216: l_array_reference_char_4 XLA_AE_JOURNAL_ENTRY_PKG.t_array_V240L;
6217: l_array_reference_date_1 XLA_AE_JOURNAL_ENTRY_PKG.t_array_Date;
6218: l_array_reference_date_2 XLA_AE_JOURNAL_ENTRY_PKG.t_array_Date;
6219: l_array_reference_date_3 XLA_AE_JOURNAL_ENTRY_PKG.t_array_Date;
6220: l_array_reference_date_4 XLA_AE_JOURNAL_ENTRY_PKG.t_array_Date;
6221: l_array_event_created_by XLA_AE_JOURNAL_ENTRY_PKG.t_array_V100L;
6222: l_array_budgetary_control_flag XLA_AE_JOURNAL_ENTRY_PKG.t_array_V30L;
6223:
6224: l_event_id NUMBER;

Line 6221: l_array_event_created_by XLA_AE_JOURNAL_ENTRY_PKG.t_array_V100L;

6217: l_array_reference_date_1 XLA_AE_JOURNAL_ENTRY_PKG.t_array_Date;
6218: l_array_reference_date_2 XLA_AE_JOURNAL_ENTRY_PKG.t_array_Date;
6219: l_array_reference_date_3 XLA_AE_JOURNAL_ENTRY_PKG.t_array_Date;
6220: l_array_reference_date_4 XLA_AE_JOURNAL_ENTRY_PKG.t_array_Date;
6221: l_array_event_created_by XLA_AE_JOURNAL_ENTRY_PKG.t_array_V100L;
6222: l_array_budgetary_control_flag XLA_AE_JOURNAL_ENTRY_PKG.t_array_V30L;
6223:
6224: l_event_id NUMBER;
6225: l_previous_event_id NUMBER;

Line 6222: l_array_budgetary_control_flag XLA_AE_JOURNAL_ENTRY_PKG.t_array_V30L;

6218: l_array_reference_date_2 XLA_AE_JOURNAL_ENTRY_PKG.t_array_Date;
6219: l_array_reference_date_3 XLA_AE_JOURNAL_ENTRY_PKG.t_array_Date;
6220: l_array_reference_date_4 XLA_AE_JOURNAL_ENTRY_PKG.t_array_Date;
6221: l_array_event_created_by XLA_AE_JOURNAL_ENTRY_PKG.t_array_V100L;
6222: l_array_budgetary_control_flag XLA_AE_JOURNAL_ENTRY_PKG.t_array_V30L;
6223:
6224: l_event_id NUMBER;
6225: l_previous_event_id NUMBER;
6226: l_first_event_id NUMBER;

Line 6240: l_array_extract_line_num xla_ae_journal_entry_pkg.t_array_Num;

6236: l_event_class_name VARCHAR2(80) := 'Direct Loan';
6237: l_description VARCHAR2(4000);
6238: l_transaction_reversal NUMBER;
6239: l_ae_header_id NUMBER;
6240: l_array_extract_line_num xla_ae_journal_entry_pkg.t_array_Num;
6241: l_log_module VARCHAR2(240);
6242: --
6243: l_acct_reversal_source VARCHAR2(30);
6244: l_trx_reversal_source VARCHAR2(30);

Line 6560: XLA_AE_JOURNAL_ENTRY_PKG.set_event_info

6556:
6557: --
6558: -- set event info as cache for other routines to refer event attributes
6559: --
6560: XLA_AE_JOURNAL_ENTRY_PKG.set_event_info
6561: (p_application_id => p_application_id
6562: ,p_primary_ledger_id => p_primary_ledger_id
6563: ,p_base_ledger_id => p_base_ledger_id
6564: ,p_target_ledger_id => p_target_ledger_id

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

6589:
6590: --
6591: -- set the status of entry to C_VALID (0)
6592: --
6593: XLA_AE_JOURNAL_ENTRY_PKG.g_global_status := XLA_AE_JOURNAL_ENTRY_PKG.C_VALID;
6594:
6595: --
6596: -- initialize a row for ae header
6597: --

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

6624: --
6625: -- initilaize the status of ae headers for diffrent balance types
6626: -- the status is initialised to C_NOT_CREATED (2)
6627: --
6628: --g_array_event(l_event_id).array_value_num('actual_je_status') := XLA_AE_JOURNAL_ENTRY_PKG.C_NOT_CREATED;
6629: --g_array_event(l_event_id).array_value_num('budget_je_status') := XLA_AE_JOURNAL_ENTRY_PKG.C_NOT_CREATED;
6630: --g_array_event(l_event_id).array_value_num('encumbrance_je_status') := XLA_AE_JOURNAL_ENTRY_PKG.C_NOT_CREATED;
6631:
6632: --

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

6625: -- initilaize the status of ae headers for diffrent balance types
6626: -- the status is initialised to C_NOT_CREATED (2)
6627: --
6628: --g_array_event(l_event_id).array_value_num('actual_je_status') := XLA_AE_JOURNAL_ENTRY_PKG.C_NOT_CREATED;
6629: --g_array_event(l_event_id).array_value_num('budget_je_status') := XLA_AE_JOURNAL_ENTRY_PKG.C_NOT_CREATED;
6630: --g_array_event(l_event_id).array_value_num('encumbrance_je_status') := XLA_AE_JOURNAL_ENTRY_PKG.C_NOT_CREATED;
6631:
6632: --
6633: -- call api to validate and store accounting attributes for header

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

6626: -- the status is initialised to C_NOT_CREATED (2)
6627: --
6628: --g_array_event(l_event_id).array_value_num('actual_je_status') := XLA_AE_JOURNAL_ENTRY_PKG.C_NOT_CREATED;
6629: --g_array_event(l_event_id).array_value_num('budget_je_status') := XLA_AE_JOURNAL_ENTRY_PKG.C_NOT_CREATED;
6630: --g_array_event(l_event_id).array_value_num('encumbrance_je_status') := XLA_AE_JOURNAL_ENTRY_PKG.C_NOT_CREATED;
6631:
6632: --
6633: -- call api to validate and store accounting attributes for header
6634: --

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

6672: --
6673: l_trx_reversal_source := SUBSTR(NULL, 1,30);
6674:
6675: IF NVL(l_trx_reversal_source, 'N') NOT IN ('N','Y') THEN
6676: xla_ae_journal_entry_pkg.g_global_status := xla_ae_journal_entry_pkg.C_INVALID;
6677:
6678: xla_accounting_err_pkg.build_message
6679: (p_appli_s_name => 'XLA'
6680: ,p_msg_name => 'XLA_AP_INVALID_HDR_ATTR'

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

6680: ,p_msg_name => 'XLA_AP_INVALID_HDR_ATTR'
6681: ,p_token_1 => 'ACCT_ATTR_NAME'
6682: ,p_value_1 => xla_ae_sources_pkg.GetAccountingSourceName('TRX_ACCT_REVERSAL_OPTION')
6683: ,p_token_2 => 'PRODUCT_NAME'
6684: ,p_value_2 => xla_ae_journal_entry_pkg.g_cache_event.application_name
6685: ,p_entity_id => xla_ae_journal_entry_pkg.g_cache_event.entity_id
6686: ,p_event_id => xla_ae_journal_entry_pkg.g_cache_event.event_id
6687: ,p_ledger_id => xla_ae_journal_entry_pkg.g_cache_event.target_ledger_id);
6688:

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

6681: ,p_token_1 => 'ACCT_ATTR_NAME'
6682: ,p_value_1 => xla_ae_sources_pkg.GetAccountingSourceName('TRX_ACCT_REVERSAL_OPTION')
6683: ,p_token_2 => 'PRODUCT_NAME'
6684: ,p_value_2 => xla_ae_journal_entry_pkg.g_cache_event.application_name
6685: ,p_entity_id => xla_ae_journal_entry_pkg.g_cache_event.entity_id
6686: ,p_event_id => xla_ae_journal_entry_pkg.g_cache_event.event_id
6687: ,p_ledger_id => xla_ae_journal_entry_pkg.g_cache_event.target_ledger_id);
6688:
6689: ELSIF NVL(l_trx_reversal_source, 'N') = 'Y' THEN

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

6682: ,p_value_1 => xla_ae_sources_pkg.GetAccountingSourceName('TRX_ACCT_REVERSAL_OPTION')
6683: ,p_token_2 => 'PRODUCT_NAME'
6684: ,p_value_2 => xla_ae_journal_entry_pkg.g_cache_event.application_name
6685: ,p_entity_id => xla_ae_journal_entry_pkg.g_cache_event.entity_id
6686: ,p_event_id => xla_ae_journal_entry_pkg.g_cache_event.event_id
6687: ,p_ledger_id => xla_ae_journal_entry_pkg.g_cache_event.target_ledger_id);
6688:
6689: ELSIF NVL(l_trx_reversal_source, 'N') = 'Y' THEN
6690: --

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

6683: ,p_token_2 => 'PRODUCT_NAME'
6684: ,p_value_2 => xla_ae_journal_entry_pkg.g_cache_event.application_name
6685: ,p_entity_id => xla_ae_journal_entry_pkg.g_cache_event.entity_id
6686: ,p_event_id => xla_ae_journal_entry_pkg.g_cache_event.event_id
6687: ,p_ledger_id => xla_ae_journal_entry_pkg.g_cache_event.target_ledger_id);
6688:
6689: ELSIF NVL(l_trx_reversal_source, 'N') = 'Y' THEN
6690: --
6691: -- following sets the accounting attributes needed to reverse

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

6702: ----------------------------------------------------------------
6703: -- 4262811 - update the header statuses to invalid in need be
6704: ----------------------------------------------------------------
6705: --
6706: XLA_AE_JOURNAL_ENTRY_PKG.UpdateJournalEntryStatus (p_hdr_idx => hdr_idx);
6707:
6708:
6709: -----------------------------------------------
6710: -- No accrual reversal for the event class/type

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

6835: ,p_module => l_log_module);
6836: END IF;
6837:
6838: --
6839: -- set the XLA_AE_JOURNAL_ENTRY_PKG.g_global_status to C_VALID (0)
6840: --
6841: XLA_AE_JOURNAL_ENTRY_PKG.g_global_status := XLA_AE_JOURNAL_ENTRY_PKG.C_VALID;
6842: --
6843: -- set event info as cache for other routines to refer event attributes

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

6837:
6838: --
6839: -- set the XLA_AE_JOURNAL_ENTRY_PKG.g_global_status to C_VALID (0)
6840: --
6841: XLA_AE_JOURNAL_ENTRY_PKG.g_global_status := XLA_AE_JOURNAL_ENTRY_PKG.C_VALID;
6842: --
6843: -- set event info as cache for other routines to refer event attributes
6844: --
6845:

Line 6849: XLA_AE_JOURNAL_ENTRY_PKG.set_event_info

6845:
6846: IF l_event_id <> NVL(l_previous_event_id, -1) THEN
6847: l_previous_event_id := l_event_id;
6848:
6849: XLA_AE_JOURNAL_ENTRY_PKG.set_event_info
6850: (p_application_id => p_application_id
6851: ,p_primary_ledger_id => p_primary_ledger_id
6852: ,p_base_ledger_id => p_base_ledger_id
6853: ,p_target_ledger_id => p_target_ledger_id

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

6886: l_acct_reversal_source := SUBSTR(NULL, 1,30);
6887:
6888: IF l_continue_with_lines THEN
6889: IF NVL(l_acct_reversal_source, 'N') NOT IN ('N','Y','B') THEN
6890: xla_ae_journal_entry_pkg.g_global_status := xla_ae_journal_entry_pkg.C_INVALID;
6891:
6892: xla_accounting_err_pkg.build_message
6893: (p_appli_s_name => 'XLA'
6894: ,p_msg_name => 'XLA_AP_INVALID_REVERSAL_OPTION'

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

6894: ,p_msg_name => 'XLA_AP_INVALID_REVERSAL_OPTION'
6895: ,p_token_1 => 'LINE_NUMBER'
6896: ,p_value_1 => l_array_extract_line_num(Idx)
6897: ,p_token_2 => 'PRODUCT_NAME'
6898: ,p_value_2 => xla_ae_journal_entry_pkg.g_cache_event.application_name
6899: ,p_entity_id => xla_ae_journal_entry_pkg.g_cache_event.entity_id
6900: ,p_event_id => xla_ae_journal_entry_pkg.g_cache_event.event_id
6901: ,p_ledger_id => xla_ae_journal_entry_pkg.g_cache_event.target_ledger_id);
6902:

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

6895: ,p_token_1 => 'LINE_NUMBER'
6896: ,p_value_1 => l_array_extract_line_num(Idx)
6897: ,p_token_2 => 'PRODUCT_NAME'
6898: ,p_value_2 => xla_ae_journal_entry_pkg.g_cache_event.application_name
6899: ,p_entity_id => xla_ae_journal_entry_pkg.g_cache_event.entity_id
6900: ,p_event_id => xla_ae_journal_entry_pkg.g_cache_event.event_id
6901: ,p_ledger_id => xla_ae_journal_entry_pkg.g_cache_event.target_ledger_id);
6902:
6903: ELSIF NVL(l_acct_reversal_source, 'N') IN ('Y','B') THEN

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

6896: ,p_value_1 => l_array_extract_line_num(Idx)
6897: ,p_token_2 => 'PRODUCT_NAME'
6898: ,p_value_2 => xla_ae_journal_entry_pkg.g_cache_event.application_name
6899: ,p_entity_id => xla_ae_journal_entry_pkg.g_cache_event.entity_id
6900: ,p_event_id => xla_ae_journal_entry_pkg.g_cache_event.event_id
6901: ,p_ledger_id => xla_ae_journal_entry_pkg.g_cache_event.target_ledger_id);
6902:
6903: ELSIF NVL(l_acct_reversal_source, 'N') IN ('Y','B') THEN
6904: --

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

6897: ,p_token_2 => 'PRODUCT_NAME'
6898: ,p_value_2 => xla_ae_journal_entry_pkg.g_cache_event.application_name
6899: ,p_entity_id => xla_ae_journal_entry_pkg.g_cache_event.entity_id
6900: ,p_event_id => xla_ae_journal_entry_pkg.g_cache_event.event_id
6901: ,p_ledger_id => xla_ae_journal_entry_pkg.g_cache_event.target_ledger_id);
6902:
6903: ELSIF NVL(l_acct_reversal_source, 'N') IN ('Y','B') THEN
6904: --
6905: -- following sets the accounting attributes needed to reverse

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

7078:
7079: -- only execute it if calculate g/l flag is yes, and primary or secondary ledger
7080: -- or secondary ledger that has different currency with primary
7081: -- or alc that is calculated by sla
7082: IF (((l_calculate_g_l_flag = 'Y' AND XLA_AE_JOURNAL_ENTRY_PKG.g_cache_ledgers_info.ledger_category_code <> 'ALC') or
7083: (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'))
7084:
7085: -- IF((l_calculate_g_l_flag='Y' or XLA_AE_JOURNAL_ENTRY_PKG.g_cache_event.target_ledger_id <>
7086: -- XLA_AE_JOURNAL_ENTRY_PKG.g_cache_event.ledger_id)

Line 7083: (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'))

7079: -- only execute it if calculate g/l flag is yes, and primary or secondary ledger
7080: -- or secondary ledger that has different currency with primary
7081: -- or alc that is calculated by sla
7082: IF (((l_calculate_g_l_flag = 'Y' AND XLA_AE_JOURNAL_ENTRY_PKG.g_cache_ledgers_info.ledger_category_code <> 'ALC') or
7083: (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'))
7084:
7085: -- IF((l_calculate_g_l_flag='Y' or XLA_AE_JOURNAL_ENTRY_PKG.g_cache_event.target_ledger_id <>
7086: -- XLA_AE_JOURNAL_ENTRY_PKG.g_cache_event.ledger_id)
7087: AND (l_actual_flag = 'A')) THEN

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

7081: -- or alc that is calculated by sla
7082: IF (((l_calculate_g_l_flag = 'Y' AND XLA_AE_JOURNAL_ENTRY_PKG.g_cache_ledgers_info.ledger_category_code <> 'ALC') or
7083: (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'))
7084:
7085: -- IF((l_calculate_g_l_flag='Y' or XLA_AE_JOURNAL_ENTRY_PKG.g_cache_event.target_ledger_id <>
7086: -- XLA_AE_JOURNAL_ENTRY_PKG.g_cache_event.ledger_id)
7087: AND (l_actual_flag = 'A')) THEN
7088: XLA_AE_LINES_PKG.CreateGainOrLossLines(
7089: p_event_id => xla_ae_journal_entry_pkg.g_cache_event.event_id

Line 7086: -- XLA_AE_JOURNAL_ENTRY_PKG.g_cache_event.ledger_id)

7082: IF (((l_calculate_g_l_flag = 'Y' AND XLA_AE_JOURNAL_ENTRY_PKG.g_cache_ledgers_info.ledger_category_code <> 'ALC') or
7083: (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'))
7084:
7085: -- IF((l_calculate_g_l_flag='Y' or XLA_AE_JOURNAL_ENTRY_PKG.g_cache_event.target_ledger_id <>
7086: -- XLA_AE_JOURNAL_ENTRY_PKG.g_cache_event.ledger_id)
7087: AND (l_actual_flag = 'A')) THEN
7088: XLA_AE_LINES_PKG.CreateGainOrLossLines(
7089: p_event_id => xla_ae_journal_entry_pkg.g_cache_event.event_id
7090: ,p_application_id => p_application_id

Line 7089: p_event_id => xla_ae_journal_entry_pkg.g_cache_event.event_id

7085: -- IF((l_calculate_g_l_flag='Y' or XLA_AE_JOURNAL_ENTRY_PKG.g_cache_event.target_ledger_id <>
7086: -- XLA_AE_JOURNAL_ENTRY_PKG.g_cache_event.ledger_id)
7087: AND (l_actual_flag = 'A')) THEN
7088: XLA_AE_LINES_PKG.CreateGainOrLossLines(
7089: p_event_id => xla_ae_journal_entry_pkg.g_cache_event.event_id
7090: ,p_application_id => p_application_id
7091: ,p_amb_context_code => 'DEFAULT'
7092: ,p_entity_code => xla_ae_journal_entry_pkg.g_cache_event.entity_code
7093: ,p_event_class_code => C_EVENT_CLASS_CODE

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

7088: XLA_AE_LINES_PKG.CreateGainOrLossLines(
7089: p_event_id => xla_ae_journal_entry_pkg.g_cache_event.event_id
7090: ,p_application_id => p_application_id
7091: ,p_amb_context_code => 'DEFAULT'
7092: ,p_entity_code => xla_ae_journal_entry_pkg.g_cache_event.entity_code
7093: ,p_event_class_code => C_EVENT_CLASS_CODE
7094: ,p_event_type_code => C_EVENT_TYPE_CODE
7095:
7096: ,p_gain_ccid => -1

Line 7599: l_array_legal_entity_id XLA_AE_JOURNAL_ENTRY_PKG.t_array_Num;

7595:
7596: l_calculate_acctd_flag VARCHAR2(1) :='Y';
7597: l_calculate_g_l_flag VARCHAR2(1) :='Y';
7598: --
7599: l_array_legal_entity_id XLA_AE_JOURNAL_ENTRY_PKG.t_array_Num;
7600: l_array_entity_id XLA_AE_JOURNAL_ENTRY_PKG.t_array_Num;
7601: l_array_entity_code XLA_AE_JOURNAL_ENTRY_PKG.t_array_V30L;
7602: l_array_transaction_num XLA_AE_JOURNAL_ENTRY_PKG.t_array_V240L;
7603: l_array_event_id XLA_AE_JOURNAL_ENTRY_PKG.t_array_Num;

Line 7600: l_array_entity_id XLA_AE_JOURNAL_ENTRY_PKG.t_array_Num;

7596: l_calculate_acctd_flag VARCHAR2(1) :='Y';
7597: l_calculate_g_l_flag VARCHAR2(1) :='Y';
7598: --
7599: l_array_legal_entity_id XLA_AE_JOURNAL_ENTRY_PKG.t_array_Num;
7600: l_array_entity_id XLA_AE_JOURNAL_ENTRY_PKG.t_array_Num;
7601: l_array_entity_code XLA_AE_JOURNAL_ENTRY_PKG.t_array_V30L;
7602: l_array_transaction_num XLA_AE_JOURNAL_ENTRY_PKG.t_array_V240L;
7603: l_array_event_id XLA_AE_JOURNAL_ENTRY_PKG.t_array_Num;
7604: l_array_class_code XLA_AE_JOURNAL_ENTRY_PKG.t_array_V30L;

Line 7601: l_array_entity_code XLA_AE_JOURNAL_ENTRY_PKG.t_array_V30L;

7597: l_calculate_g_l_flag VARCHAR2(1) :='Y';
7598: --
7599: l_array_legal_entity_id XLA_AE_JOURNAL_ENTRY_PKG.t_array_Num;
7600: l_array_entity_id XLA_AE_JOURNAL_ENTRY_PKG.t_array_Num;
7601: l_array_entity_code XLA_AE_JOURNAL_ENTRY_PKG.t_array_V30L;
7602: l_array_transaction_num XLA_AE_JOURNAL_ENTRY_PKG.t_array_V240L;
7603: l_array_event_id XLA_AE_JOURNAL_ENTRY_PKG.t_array_Num;
7604: l_array_class_code XLA_AE_JOURNAL_ENTRY_PKG.t_array_V30L;
7605: l_array_event_type XLA_AE_JOURNAL_ENTRY_PKG.t_array_V30L;

Line 7602: l_array_transaction_num XLA_AE_JOURNAL_ENTRY_PKG.t_array_V240L;

7598: --
7599: l_array_legal_entity_id XLA_AE_JOURNAL_ENTRY_PKG.t_array_Num;
7600: l_array_entity_id XLA_AE_JOURNAL_ENTRY_PKG.t_array_Num;
7601: l_array_entity_code XLA_AE_JOURNAL_ENTRY_PKG.t_array_V30L;
7602: l_array_transaction_num XLA_AE_JOURNAL_ENTRY_PKG.t_array_V240L;
7603: l_array_event_id XLA_AE_JOURNAL_ENTRY_PKG.t_array_Num;
7604: l_array_class_code XLA_AE_JOURNAL_ENTRY_PKG.t_array_V30L;
7605: l_array_event_type XLA_AE_JOURNAL_ENTRY_PKG.t_array_V30L;
7606: l_array_event_number XLA_AE_JOURNAL_ENTRY_PKG.t_array_Num;

Line 7603: l_array_event_id XLA_AE_JOURNAL_ENTRY_PKG.t_array_Num;

7599: l_array_legal_entity_id XLA_AE_JOURNAL_ENTRY_PKG.t_array_Num;
7600: l_array_entity_id XLA_AE_JOURNAL_ENTRY_PKG.t_array_Num;
7601: l_array_entity_code XLA_AE_JOURNAL_ENTRY_PKG.t_array_V30L;
7602: l_array_transaction_num XLA_AE_JOURNAL_ENTRY_PKG.t_array_V240L;
7603: l_array_event_id XLA_AE_JOURNAL_ENTRY_PKG.t_array_Num;
7604: l_array_class_code XLA_AE_JOURNAL_ENTRY_PKG.t_array_V30L;
7605: l_array_event_type XLA_AE_JOURNAL_ENTRY_PKG.t_array_V30L;
7606: l_array_event_number XLA_AE_JOURNAL_ENTRY_PKG.t_array_Num;
7607: l_array_event_date XLA_AE_JOURNAL_ENTRY_PKG.t_array_Date;

Line 7604: l_array_class_code XLA_AE_JOURNAL_ENTRY_PKG.t_array_V30L;

7600: l_array_entity_id XLA_AE_JOURNAL_ENTRY_PKG.t_array_Num;
7601: l_array_entity_code XLA_AE_JOURNAL_ENTRY_PKG.t_array_V30L;
7602: l_array_transaction_num XLA_AE_JOURNAL_ENTRY_PKG.t_array_V240L;
7603: l_array_event_id XLA_AE_JOURNAL_ENTRY_PKG.t_array_Num;
7604: l_array_class_code XLA_AE_JOURNAL_ENTRY_PKG.t_array_V30L;
7605: l_array_event_type XLA_AE_JOURNAL_ENTRY_PKG.t_array_V30L;
7606: l_array_event_number XLA_AE_JOURNAL_ENTRY_PKG.t_array_Num;
7607: l_array_event_date XLA_AE_JOURNAL_ENTRY_PKG.t_array_Date;
7608: l_array_transaction_date XLA_AE_JOURNAL_ENTRY_PKG.t_array_Date;

Line 7605: l_array_event_type XLA_AE_JOURNAL_ENTRY_PKG.t_array_V30L;

7601: l_array_entity_code XLA_AE_JOURNAL_ENTRY_PKG.t_array_V30L;
7602: l_array_transaction_num XLA_AE_JOURNAL_ENTRY_PKG.t_array_V240L;
7603: l_array_event_id XLA_AE_JOURNAL_ENTRY_PKG.t_array_Num;
7604: l_array_class_code XLA_AE_JOURNAL_ENTRY_PKG.t_array_V30L;
7605: l_array_event_type XLA_AE_JOURNAL_ENTRY_PKG.t_array_V30L;
7606: l_array_event_number XLA_AE_JOURNAL_ENTRY_PKG.t_array_Num;
7607: l_array_event_date XLA_AE_JOURNAL_ENTRY_PKG.t_array_Date;
7608: l_array_transaction_date XLA_AE_JOURNAL_ENTRY_PKG.t_array_Date;
7609: l_array_reference_num_1 XLA_AE_JOURNAL_ENTRY_PKG.t_array_Num;

Line 7606: l_array_event_number XLA_AE_JOURNAL_ENTRY_PKG.t_array_Num;

7602: l_array_transaction_num XLA_AE_JOURNAL_ENTRY_PKG.t_array_V240L;
7603: l_array_event_id XLA_AE_JOURNAL_ENTRY_PKG.t_array_Num;
7604: l_array_class_code XLA_AE_JOURNAL_ENTRY_PKG.t_array_V30L;
7605: l_array_event_type XLA_AE_JOURNAL_ENTRY_PKG.t_array_V30L;
7606: l_array_event_number XLA_AE_JOURNAL_ENTRY_PKG.t_array_Num;
7607: l_array_event_date XLA_AE_JOURNAL_ENTRY_PKG.t_array_Date;
7608: l_array_transaction_date XLA_AE_JOURNAL_ENTRY_PKG.t_array_Date;
7609: l_array_reference_num_1 XLA_AE_JOURNAL_ENTRY_PKG.t_array_Num;
7610: l_array_reference_num_2 XLA_AE_JOURNAL_ENTRY_PKG.t_array_Num;

Line 7607: l_array_event_date XLA_AE_JOURNAL_ENTRY_PKG.t_array_Date;

7603: l_array_event_id XLA_AE_JOURNAL_ENTRY_PKG.t_array_Num;
7604: l_array_class_code XLA_AE_JOURNAL_ENTRY_PKG.t_array_V30L;
7605: l_array_event_type XLA_AE_JOURNAL_ENTRY_PKG.t_array_V30L;
7606: l_array_event_number XLA_AE_JOURNAL_ENTRY_PKG.t_array_Num;
7607: l_array_event_date XLA_AE_JOURNAL_ENTRY_PKG.t_array_Date;
7608: l_array_transaction_date XLA_AE_JOURNAL_ENTRY_PKG.t_array_Date;
7609: l_array_reference_num_1 XLA_AE_JOURNAL_ENTRY_PKG.t_array_Num;
7610: l_array_reference_num_2 XLA_AE_JOURNAL_ENTRY_PKG.t_array_Num;
7611: l_array_reference_num_3 XLA_AE_JOURNAL_ENTRY_PKG.t_array_Num;

Line 7608: l_array_transaction_date XLA_AE_JOURNAL_ENTRY_PKG.t_array_Date;

7604: l_array_class_code XLA_AE_JOURNAL_ENTRY_PKG.t_array_V30L;
7605: l_array_event_type XLA_AE_JOURNAL_ENTRY_PKG.t_array_V30L;
7606: l_array_event_number XLA_AE_JOURNAL_ENTRY_PKG.t_array_Num;
7607: l_array_event_date XLA_AE_JOURNAL_ENTRY_PKG.t_array_Date;
7608: l_array_transaction_date XLA_AE_JOURNAL_ENTRY_PKG.t_array_Date;
7609: l_array_reference_num_1 XLA_AE_JOURNAL_ENTRY_PKG.t_array_Num;
7610: l_array_reference_num_2 XLA_AE_JOURNAL_ENTRY_PKG.t_array_Num;
7611: l_array_reference_num_3 XLA_AE_JOURNAL_ENTRY_PKG.t_array_Num;
7612: l_array_reference_num_4 XLA_AE_JOURNAL_ENTRY_PKG.t_array_Num;

Line 7609: l_array_reference_num_1 XLA_AE_JOURNAL_ENTRY_PKG.t_array_Num;

7605: l_array_event_type XLA_AE_JOURNAL_ENTRY_PKG.t_array_V30L;
7606: l_array_event_number XLA_AE_JOURNAL_ENTRY_PKG.t_array_Num;
7607: l_array_event_date XLA_AE_JOURNAL_ENTRY_PKG.t_array_Date;
7608: l_array_transaction_date XLA_AE_JOURNAL_ENTRY_PKG.t_array_Date;
7609: l_array_reference_num_1 XLA_AE_JOURNAL_ENTRY_PKG.t_array_Num;
7610: l_array_reference_num_2 XLA_AE_JOURNAL_ENTRY_PKG.t_array_Num;
7611: l_array_reference_num_3 XLA_AE_JOURNAL_ENTRY_PKG.t_array_Num;
7612: l_array_reference_num_4 XLA_AE_JOURNAL_ENTRY_PKG.t_array_Num;
7613: l_array_reference_char_1 XLA_AE_JOURNAL_ENTRY_PKG.t_array_V240L;

Line 7610: l_array_reference_num_2 XLA_AE_JOURNAL_ENTRY_PKG.t_array_Num;

7606: l_array_event_number XLA_AE_JOURNAL_ENTRY_PKG.t_array_Num;
7607: l_array_event_date XLA_AE_JOURNAL_ENTRY_PKG.t_array_Date;
7608: l_array_transaction_date XLA_AE_JOURNAL_ENTRY_PKG.t_array_Date;
7609: l_array_reference_num_1 XLA_AE_JOURNAL_ENTRY_PKG.t_array_Num;
7610: l_array_reference_num_2 XLA_AE_JOURNAL_ENTRY_PKG.t_array_Num;
7611: l_array_reference_num_3 XLA_AE_JOURNAL_ENTRY_PKG.t_array_Num;
7612: l_array_reference_num_4 XLA_AE_JOURNAL_ENTRY_PKG.t_array_Num;
7613: l_array_reference_char_1 XLA_AE_JOURNAL_ENTRY_PKG.t_array_V240L;
7614: l_array_reference_char_2 XLA_AE_JOURNAL_ENTRY_PKG.t_array_V240L;

Line 7611: l_array_reference_num_3 XLA_AE_JOURNAL_ENTRY_PKG.t_array_Num;

7607: l_array_event_date XLA_AE_JOURNAL_ENTRY_PKG.t_array_Date;
7608: l_array_transaction_date XLA_AE_JOURNAL_ENTRY_PKG.t_array_Date;
7609: l_array_reference_num_1 XLA_AE_JOURNAL_ENTRY_PKG.t_array_Num;
7610: l_array_reference_num_2 XLA_AE_JOURNAL_ENTRY_PKG.t_array_Num;
7611: l_array_reference_num_3 XLA_AE_JOURNAL_ENTRY_PKG.t_array_Num;
7612: l_array_reference_num_4 XLA_AE_JOURNAL_ENTRY_PKG.t_array_Num;
7613: l_array_reference_char_1 XLA_AE_JOURNAL_ENTRY_PKG.t_array_V240L;
7614: l_array_reference_char_2 XLA_AE_JOURNAL_ENTRY_PKG.t_array_V240L;
7615: l_array_reference_char_3 XLA_AE_JOURNAL_ENTRY_PKG.t_array_V240L;

Line 7612: l_array_reference_num_4 XLA_AE_JOURNAL_ENTRY_PKG.t_array_Num;

7608: l_array_transaction_date XLA_AE_JOURNAL_ENTRY_PKG.t_array_Date;
7609: l_array_reference_num_1 XLA_AE_JOURNAL_ENTRY_PKG.t_array_Num;
7610: l_array_reference_num_2 XLA_AE_JOURNAL_ENTRY_PKG.t_array_Num;
7611: l_array_reference_num_3 XLA_AE_JOURNAL_ENTRY_PKG.t_array_Num;
7612: l_array_reference_num_4 XLA_AE_JOURNAL_ENTRY_PKG.t_array_Num;
7613: l_array_reference_char_1 XLA_AE_JOURNAL_ENTRY_PKG.t_array_V240L;
7614: l_array_reference_char_2 XLA_AE_JOURNAL_ENTRY_PKG.t_array_V240L;
7615: l_array_reference_char_3 XLA_AE_JOURNAL_ENTRY_PKG.t_array_V240L;
7616: l_array_reference_char_4 XLA_AE_JOURNAL_ENTRY_PKG.t_array_V240L;

Line 7613: l_array_reference_char_1 XLA_AE_JOURNAL_ENTRY_PKG.t_array_V240L;

7609: l_array_reference_num_1 XLA_AE_JOURNAL_ENTRY_PKG.t_array_Num;
7610: l_array_reference_num_2 XLA_AE_JOURNAL_ENTRY_PKG.t_array_Num;
7611: l_array_reference_num_3 XLA_AE_JOURNAL_ENTRY_PKG.t_array_Num;
7612: l_array_reference_num_4 XLA_AE_JOURNAL_ENTRY_PKG.t_array_Num;
7613: l_array_reference_char_1 XLA_AE_JOURNAL_ENTRY_PKG.t_array_V240L;
7614: l_array_reference_char_2 XLA_AE_JOURNAL_ENTRY_PKG.t_array_V240L;
7615: l_array_reference_char_3 XLA_AE_JOURNAL_ENTRY_PKG.t_array_V240L;
7616: l_array_reference_char_4 XLA_AE_JOURNAL_ENTRY_PKG.t_array_V240L;
7617: l_array_reference_date_1 XLA_AE_JOURNAL_ENTRY_PKG.t_array_Date;

Line 7614: l_array_reference_char_2 XLA_AE_JOURNAL_ENTRY_PKG.t_array_V240L;

7610: l_array_reference_num_2 XLA_AE_JOURNAL_ENTRY_PKG.t_array_Num;
7611: l_array_reference_num_3 XLA_AE_JOURNAL_ENTRY_PKG.t_array_Num;
7612: l_array_reference_num_4 XLA_AE_JOURNAL_ENTRY_PKG.t_array_Num;
7613: l_array_reference_char_1 XLA_AE_JOURNAL_ENTRY_PKG.t_array_V240L;
7614: l_array_reference_char_2 XLA_AE_JOURNAL_ENTRY_PKG.t_array_V240L;
7615: l_array_reference_char_3 XLA_AE_JOURNAL_ENTRY_PKG.t_array_V240L;
7616: l_array_reference_char_4 XLA_AE_JOURNAL_ENTRY_PKG.t_array_V240L;
7617: l_array_reference_date_1 XLA_AE_JOURNAL_ENTRY_PKG.t_array_Date;
7618: l_array_reference_date_2 XLA_AE_JOURNAL_ENTRY_PKG.t_array_Date;

Line 7615: l_array_reference_char_3 XLA_AE_JOURNAL_ENTRY_PKG.t_array_V240L;

7611: l_array_reference_num_3 XLA_AE_JOURNAL_ENTRY_PKG.t_array_Num;
7612: l_array_reference_num_4 XLA_AE_JOURNAL_ENTRY_PKG.t_array_Num;
7613: l_array_reference_char_1 XLA_AE_JOURNAL_ENTRY_PKG.t_array_V240L;
7614: l_array_reference_char_2 XLA_AE_JOURNAL_ENTRY_PKG.t_array_V240L;
7615: l_array_reference_char_3 XLA_AE_JOURNAL_ENTRY_PKG.t_array_V240L;
7616: l_array_reference_char_4 XLA_AE_JOURNAL_ENTRY_PKG.t_array_V240L;
7617: l_array_reference_date_1 XLA_AE_JOURNAL_ENTRY_PKG.t_array_Date;
7618: l_array_reference_date_2 XLA_AE_JOURNAL_ENTRY_PKG.t_array_Date;
7619: l_array_reference_date_3 XLA_AE_JOURNAL_ENTRY_PKG.t_array_Date;

Line 7616: l_array_reference_char_4 XLA_AE_JOURNAL_ENTRY_PKG.t_array_V240L;

7612: l_array_reference_num_4 XLA_AE_JOURNAL_ENTRY_PKG.t_array_Num;
7613: l_array_reference_char_1 XLA_AE_JOURNAL_ENTRY_PKG.t_array_V240L;
7614: l_array_reference_char_2 XLA_AE_JOURNAL_ENTRY_PKG.t_array_V240L;
7615: l_array_reference_char_3 XLA_AE_JOURNAL_ENTRY_PKG.t_array_V240L;
7616: l_array_reference_char_4 XLA_AE_JOURNAL_ENTRY_PKG.t_array_V240L;
7617: l_array_reference_date_1 XLA_AE_JOURNAL_ENTRY_PKG.t_array_Date;
7618: l_array_reference_date_2 XLA_AE_JOURNAL_ENTRY_PKG.t_array_Date;
7619: l_array_reference_date_3 XLA_AE_JOURNAL_ENTRY_PKG.t_array_Date;
7620: l_array_reference_date_4 XLA_AE_JOURNAL_ENTRY_PKG.t_array_Date;

Line 7617: l_array_reference_date_1 XLA_AE_JOURNAL_ENTRY_PKG.t_array_Date;

7613: l_array_reference_char_1 XLA_AE_JOURNAL_ENTRY_PKG.t_array_V240L;
7614: l_array_reference_char_2 XLA_AE_JOURNAL_ENTRY_PKG.t_array_V240L;
7615: l_array_reference_char_3 XLA_AE_JOURNAL_ENTRY_PKG.t_array_V240L;
7616: l_array_reference_char_4 XLA_AE_JOURNAL_ENTRY_PKG.t_array_V240L;
7617: l_array_reference_date_1 XLA_AE_JOURNAL_ENTRY_PKG.t_array_Date;
7618: l_array_reference_date_2 XLA_AE_JOURNAL_ENTRY_PKG.t_array_Date;
7619: l_array_reference_date_3 XLA_AE_JOURNAL_ENTRY_PKG.t_array_Date;
7620: l_array_reference_date_4 XLA_AE_JOURNAL_ENTRY_PKG.t_array_Date;
7621: l_array_event_created_by XLA_AE_JOURNAL_ENTRY_PKG.t_array_V100L;

Line 7618: l_array_reference_date_2 XLA_AE_JOURNAL_ENTRY_PKG.t_array_Date;

7614: l_array_reference_char_2 XLA_AE_JOURNAL_ENTRY_PKG.t_array_V240L;
7615: l_array_reference_char_3 XLA_AE_JOURNAL_ENTRY_PKG.t_array_V240L;
7616: l_array_reference_char_4 XLA_AE_JOURNAL_ENTRY_PKG.t_array_V240L;
7617: l_array_reference_date_1 XLA_AE_JOURNAL_ENTRY_PKG.t_array_Date;
7618: l_array_reference_date_2 XLA_AE_JOURNAL_ENTRY_PKG.t_array_Date;
7619: l_array_reference_date_3 XLA_AE_JOURNAL_ENTRY_PKG.t_array_Date;
7620: l_array_reference_date_4 XLA_AE_JOURNAL_ENTRY_PKG.t_array_Date;
7621: l_array_event_created_by XLA_AE_JOURNAL_ENTRY_PKG.t_array_V100L;
7622: l_array_budgetary_control_flag XLA_AE_JOURNAL_ENTRY_PKG.t_array_V30L;

Line 7619: l_array_reference_date_3 XLA_AE_JOURNAL_ENTRY_PKG.t_array_Date;

7615: l_array_reference_char_3 XLA_AE_JOURNAL_ENTRY_PKG.t_array_V240L;
7616: l_array_reference_char_4 XLA_AE_JOURNAL_ENTRY_PKG.t_array_V240L;
7617: l_array_reference_date_1 XLA_AE_JOURNAL_ENTRY_PKG.t_array_Date;
7618: l_array_reference_date_2 XLA_AE_JOURNAL_ENTRY_PKG.t_array_Date;
7619: l_array_reference_date_3 XLA_AE_JOURNAL_ENTRY_PKG.t_array_Date;
7620: l_array_reference_date_4 XLA_AE_JOURNAL_ENTRY_PKG.t_array_Date;
7621: l_array_event_created_by XLA_AE_JOURNAL_ENTRY_PKG.t_array_V100L;
7622: l_array_budgetary_control_flag XLA_AE_JOURNAL_ENTRY_PKG.t_array_V30L;
7623:

Line 7620: l_array_reference_date_4 XLA_AE_JOURNAL_ENTRY_PKG.t_array_Date;

7616: l_array_reference_char_4 XLA_AE_JOURNAL_ENTRY_PKG.t_array_V240L;
7617: l_array_reference_date_1 XLA_AE_JOURNAL_ENTRY_PKG.t_array_Date;
7618: l_array_reference_date_2 XLA_AE_JOURNAL_ENTRY_PKG.t_array_Date;
7619: l_array_reference_date_3 XLA_AE_JOURNAL_ENTRY_PKG.t_array_Date;
7620: l_array_reference_date_4 XLA_AE_JOURNAL_ENTRY_PKG.t_array_Date;
7621: l_array_event_created_by XLA_AE_JOURNAL_ENTRY_PKG.t_array_V100L;
7622: l_array_budgetary_control_flag XLA_AE_JOURNAL_ENTRY_PKG.t_array_V30L;
7623:
7624: l_event_id NUMBER;

Line 7621: l_array_event_created_by XLA_AE_JOURNAL_ENTRY_PKG.t_array_V100L;

7617: l_array_reference_date_1 XLA_AE_JOURNAL_ENTRY_PKG.t_array_Date;
7618: l_array_reference_date_2 XLA_AE_JOURNAL_ENTRY_PKG.t_array_Date;
7619: l_array_reference_date_3 XLA_AE_JOURNAL_ENTRY_PKG.t_array_Date;
7620: l_array_reference_date_4 XLA_AE_JOURNAL_ENTRY_PKG.t_array_Date;
7621: l_array_event_created_by XLA_AE_JOURNAL_ENTRY_PKG.t_array_V100L;
7622: l_array_budgetary_control_flag XLA_AE_JOURNAL_ENTRY_PKG.t_array_V30L;
7623:
7624: l_event_id NUMBER;
7625: l_previous_event_id NUMBER;

Line 7622: l_array_budgetary_control_flag XLA_AE_JOURNAL_ENTRY_PKG.t_array_V30L;

7618: l_array_reference_date_2 XLA_AE_JOURNAL_ENTRY_PKG.t_array_Date;
7619: l_array_reference_date_3 XLA_AE_JOURNAL_ENTRY_PKG.t_array_Date;
7620: l_array_reference_date_4 XLA_AE_JOURNAL_ENTRY_PKG.t_array_Date;
7621: l_array_event_created_by XLA_AE_JOURNAL_ENTRY_PKG.t_array_V100L;
7622: l_array_budgetary_control_flag XLA_AE_JOURNAL_ENTRY_PKG.t_array_V30L;
7623:
7624: l_event_id NUMBER;
7625: l_previous_event_id NUMBER;
7626: l_first_event_id NUMBER;

Line 7640: l_array_extract_line_num xla_ae_journal_entry_pkg.t_array_Num;

7636: l_event_class_name VARCHAR2(80) := 'Direct Loan';
7637: l_description VARCHAR2(4000);
7638: l_transaction_reversal NUMBER;
7639: l_ae_header_id NUMBER;
7640: l_array_extract_line_num xla_ae_journal_entry_pkg.t_array_Num;
7641: l_log_module VARCHAR2(240);
7642: --
7643: l_acct_reversal_source VARCHAR2(30);
7644: l_trx_reversal_source VARCHAR2(30);

Line 7957: XLA_AE_JOURNAL_ENTRY_PKG.set_event_info

7953:
7954: --
7955: -- set event info as cache for other routines to refer event attributes
7956: --
7957: XLA_AE_JOURNAL_ENTRY_PKG.set_event_info
7958: (p_application_id => p_application_id
7959: ,p_primary_ledger_id => p_primary_ledger_id
7960: ,p_base_ledger_id => p_base_ledger_id
7961: ,p_target_ledger_id => p_target_ledger_id

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

7986:
7987: --
7988: -- set the status of entry to C_VALID (0)
7989: --
7990: XLA_AE_JOURNAL_ENTRY_PKG.g_global_status := XLA_AE_JOURNAL_ENTRY_PKG.C_VALID;
7991:
7992: --
7993: -- initialize a row for ae header
7994: --

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

8021: --
8022: -- initilaize the status of ae headers for diffrent balance types
8023: -- the status is initialised to C_NOT_CREATED (2)
8024: --
8025: --g_array_event(l_event_id).array_value_num('actual_je_status') := XLA_AE_JOURNAL_ENTRY_PKG.C_NOT_CREATED;
8026: --g_array_event(l_event_id).array_value_num('budget_je_status') := XLA_AE_JOURNAL_ENTRY_PKG.C_NOT_CREATED;
8027: --g_array_event(l_event_id).array_value_num('encumbrance_je_status') := XLA_AE_JOURNAL_ENTRY_PKG.C_NOT_CREATED;
8028:
8029: --

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

8022: -- initilaize the status of ae headers for diffrent balance types
8023: -- the status is initialised to C_NOT_CREATED (2)
8024: --
8025: --g_array_event(l_event_id).array_value_num('actual_je_status') := XLA_AE_JOURNAL_ENTRY_PKG.C_NOT_CREATED;
8026: --g_array_event(l_event_id).array_value_num('budget_je_status') := XLA_AE_JOURNAL_ENTRY_PKG.C_NOT_CREATED;
8027: --g_array_event(l_event_id).array_value_num('encumbrance_je_status') := XLA_AE_JOURNAL_ENTRY_PKG.C_NOT_CREATED;
8028:
8029: --
8030: -- call api to validate and store accounting attributes for header

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

8023: -- the status is initialised to C_NOT_CREATED (2)
8024: --
8025: --g_array_event(l_event_id).array_value_num('actual_je_status') := XLA_AE_JOURNAL_ENTRY_PKG.C_NOT_CREATED;
8026: --g_array_event(l_event_id).array_value_num('budget_je_status') := XLA_AE_JOURNAL_ENTRY_PKG.C_NOT_CREATED;
8027: --g_array_event(l_event_id).array_value_num('encumbrance_je_status') := XLA_AE_JOURNAL_ENTRY_PKG.C_NOT_CREATED;
8028:
8029: --
8030: -- call api to validate and store accounting attributes for header
8031: --

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

8069: --
8070: l_trx_reversal_source := SUBSTR(NULL, 1,30);
8071:
8072: IF NVL(l_trx_reversal_source, 'N') NOT IN ('N','Y') THEN
8073: xla_ae_journal_entry_pkg.g_global_status := xla_ae_journal_entry_pkg.C_INVALID;
8074:
8075: xla_accounting_err_pkg.build_message
8076: (p_appli_s_name => 'XLA'
8077: ,p_msg_name => 'XLA_AP_INVALID_HDR_ATTR'

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

8077: ,p_msg_name => 'XLA_AP_INVALID_HDR_ATTR'
8078: ,p_token_1 => 'ACCT_ATTR_NAME'
8079: ,p_value_1 => xla_ae_sources_pkg.GetAccountingSourceName('TRX_ACCT_REVERSAL_OPTION')
8080: ,p_token_2 => 'PRODUCT_NAME'
8081: ,p_value_2 => xla_ae_journal_entry_pkg.g_cache_event.application_name
8082: ,p_entity_id => xla_ae_journal_entry_pkg.g_cache_event.entity_id
8083: ,p_event_id => xla_ae_journal_entry_pkg.g_cache_event.event_id
8084: ,p_ledger_id => xla_ae_journal_entry_pkg.g_cache_event.target_ledger_id);
8085:

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

8078: ,p_token_1 => 'ACCT_ATTR_NAME'
8079: ,p_value_1 => xla_ae_sources_pkg.GetAccountingSourceName('TRX_ACCT_REVERSAL_OPTION')
8080: ,p_token_2 => 'PRODUCT_NAME'
8081: ,p_value_2 => xla_ae_journal_entry_pkg.g_cache_event.application_name
8082: ,p_entity_id => xla_ae_journal_entry_pkg.g_cache_event.entity_id
8083: ,p_event_id => xla_ae_journal_entry_pkg.g_cache_event.event_id
8084: ,p_ledger_id => xla_ae_journal_entry_pkg.g_cache_event.target_ledger_id);
8085:
8086: ELSIF NVL(l_trx_reversal_source, 'N') = 'Y' THEN

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

8079: ,p_value_1 => xla_ae_sources_pkg.GetAccountingSourceName('TRX_ACCT_REVERSAL_OPTION')
8080: ,p_token_2 => 'PRODUCT_NAME'
8081: ,p_value_2 => xla_ae_journal_entry_pkg.g_cache_event.application_name
8082: ,p_entity_id => xla_ae_journal_entry_pkg.g_cache_event.entity_id
8083: ,p_event_id => xla_ae_journal_entry_pkg.g_cache_event.event_id
8084: ,p_ledger_id => xla_ae_journal_entry_pkg.g_cache_event.target_ledger_id);
8085:
8086: ELSIF NVL(l_trx_reversal_source, 'N') = 'Y' THEN
8087: --

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

8080: ,p_token_2 => 'PRODUCT_NAME'
8081: ,p_value_2 => xla_ae_journal_entry_pkg.g_cache_event.application_name
8082: ,p_entity_id => xla_ae_journal_entry_pkg.g_cache_event.entity_id
8083: ,p_event_id => xla_ae_journal_entry_pkg.g_cache_event.event_id
8084: ,p_ledger_id => xla_ae_journal_entry_pkg.g_cache_event.target_ledger_id);
8085:
8086: ELSIF NVL(l_trx_reversal_source, 'N') = 'Y' THEN
8087: --
8088: -- following sets the accounting attributes needed to reverse

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

8099: ----------------------------------------------------------------
8100: -- 4262811 - update the header statuses to invalid in need be
8101: ----------------------------------------------------------------
8102: --
8103: XLA_AE_JOURNAL_ENTRY_PKG.UpdateJournalEntryStatus (p_hdr_idx => hdr_idx);
8104:
8105:
8106: -----------------------------------------------
8107: -- No accrual reversal for the event class/type

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

8231: ,p_module => l_log_module);
8232: END IF;
8233:
8234: --
8235: -- set the XLA_AE_JOURNAL_ENTRY_PKG.g_global_status to C_VALID (0)
8236: --
8237: XLA_AE_JOURNAL_ENTRY_PKG.g_global_status := XLA_AE_JOURNAL_ENTRY_PKG.C_VALID;
8238: --
8239: -- set event info as cache for other routines to refer event attributes

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

8233:
8234: --
8235: -- set the XLA_AE_JOURNAL_ENTRY_PKG.g_global_status to C_VALID (0)
8236: --
8237: XLA_AE_JOURNAL_ENTRY_PKG.g_global_status := XLA_AE_JOURNAL_ENTRY_PKG.C_VALID;
8238: --
8239: -- set event info as cache for other routines to refer event attributes
8240: --
8241:

Line 8245: XLA_AE_JOURNAL_ENTRY_PKG.set_event_info

8241:
8242: IF l_event_id <> NVL(l_previous_event_id, -1) THEN
8243: l_previous_event_id := l_event_id;
8244:
8245: XLA_AE_JOURNAL_ENTRY_PKG.set_event_info
8246: (p_application_id => p_application_id
8247: ,p_primary_ledger_id => p_primary_ledger_id
8248: ,p_base_ledger_id => p_base_ledger_id
8249: ,p_target_ledger_id => p_target_ledger_id

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

8282: l_acct_reversal_source := SUBSTR(NULL, 1,30);
8283:
8284: IF l_continue_with_lines THEN
8285: IF NVL(l_acct_reversal_source, 'N') NOT IN ('N','Y','B') THEN
8286: xla_ae_journal_entry_pkg.g_global_status := xla_ae_journal_entry_pkg.C_INVALID;
8287:
8288: xla_accounting_err_pkg.build_message
8289: (p_appli_s_name => 'XLA'
8290: ,p_msg_name => 'XLA_AP_INVALID_REVERSAL_OPTION'

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

8290: ,p_msg_name => 'XLA_AP_INVALID_REVERSAL_OPTION'
8291: ,p_token_1 => 'LINE_NUMBER'
8292: ,p_value_1 => l_array_extract_line_num(Idx)
8293: ,p_token_2 => 'PRODUCT_NAME'
8294: ,p_value_2 => xla_ae_journal_entry_pkg.g_cache_event.application_name
8295: ,p_entity_id => xla_ae_journal_entry_pkg.g_cache_event.entity_id
8296: ,p_event_id => xla_ae_journal_entry_pkg.g_cache_event.event_id
8297: ,p_ledger_id => xla_ae_journal_entry_pkg.g_cache_event.target_ledger_id);
8298:

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

8291: ,p_token_1 => 'LINE_NUMBER'
8292: ,p_value_1 => l_array_extract_line_num(Idx)
8293: ,p_token_2 => 'PRODUCT_NAME'
8294: ,p_value_2 => xla_ae_journal_entry_pkg.g_cache_event.application_name
8295: ,p_entity_id => xla_ae_journal_entry_pkg.g_cache_event.entity_id
8296: ,p_event_id => xla_ae_journal_entry_pkg.g_cache_event.event_id
8297: ,p_ledger_id => xla_ae_journal_entry_pkg.g_cache_event.target_ledger_id);
8298:
8299: ELSIF NVL(l_acct_reversal_source, 'N') IN ('Y','B') THEN

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

8292: ,p_value_1 => l_array_extract_line_num(Idx)
8293: ,p_token_2 => 'PRODUCT_NAME'
8294: ,p_value_2 => xla_ae_journal_entry_pkg.g_cache_event.application_name
8295: ,p_entity_id => xla_ae_journal_entry_pkg.g_cache_event.entity_id
8296: ,p_event_id => xla_ae_journal_entry_pkg.g_cache_event.event_id
8297: ,p_ledger_id => xla_ae_journal_entry_pkg.g_cache_event.target_ledger_id);
8298:
8299: ELSIF NVL(l_acct_reversal_source, 'N') IN ('Y','B') THEN
8300: --

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

8293: ,p_token_2 => 'PRODUCT_NAME'
8294: ,p_value_2 => xla_ae_journal_entry_pkg.g_cache_event.application_name
8295: ,p_entity_id => xla_ae_journal_entry_pkg.g_cache_event.entity_id
8296: ,p_event_id => xla_ae_journal_entry_pkg.g_cache_event.event_id
8297: ,p_ledger_id => xla_ae_journal_entry_pkg.g_cache_event.target_ledger_id);
8298:
8299: ELSIF NVL(l_acct_reversal_source, 'N') IN ('Y','B') THEN
8300: --
8301: -- following sets the accounting attributes needed to reverse

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

8470:
8471: -- only execute it if calculate g/l flag is yes, and primary or secondary ledger
8472: -- or secondary ledger that has different currency with primary
8473: -- or alc that is calculated by sla
8474: IF (((l_calculate_g_l_flag = 'Y' AND XLA_AE_JOURNAL_ENTRY_PKG.g_cache_ledgers_info.ledger_category_code <> 'ALC') or
8475: (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'))
8476:
8477: -- IF((l_calculate_g_l_flag='Y' or XLA_AE_JOURNAL_ENTRY_PKG.g_cache_event.target_ledger_id <>
8478: -- XLA_AE_JOURNAL_ENTRY_PKG.g_cache_event.ledger_id)

Line 8475: (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'))

8471: -- only execute it if calculate g/l flag is yes, and primary or secondary ledger
8472: -- or secondary ledger that has different currency with primary
8473: -- or alc that is calculated by sla
8474: IF (((l_calculate_g_l_flag = 'Y' AND XLA_AE_JOURNAL_ENTRY_PKG.g_cache_ledgers_info.ledger_category_code <> 'ALC') or
8475: (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'))
8476:
8477: -- IF((l_calculate_g_l_flag='Y' or XLA_AE_JOURNAL_ENTRY_PKG.g_cache_event.target_ledger_id <>
8478: -- XLA_AE_JOURNAL_ENTRY_PKG.g_cache_event.ledger_id)
8479: AND (l_actual_flag = 'A')) THEN

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

8473: -- or alc that is calculated by sla
8474: IF (((l_calculate_g_l_flag = 'Y' AND XLA_AE_JOURNAL_ENTRY_PKG.g_cache_ledgers_info.ledger_category_code <> 'ALC') or
8475: (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'))
8476:
8477: -- IF((l_calculate_g_l_flag='Y' or XLA_AE_JOURNAL_ENTRY_PKG.g_cache_event.target_ledger_id <>
8478: -- XLA_AE_JOURNAL_ENTRY_PKG.g_cache_event.ledger_id)
8479: AND (l_actual_flag = 'A')) THEN
8480: XLA_AE_LINES_PKG.CreateGainOrLossLines(
8481: p_event_id => xla_ae_journal_entry_pkg.g_cache_event.event_id

Line 8478: -- XLA_AE_JOURNAL_ENTRY_PKG.g_cache_event.ledger_id)

8474: IF (((l_calculate_g_l_flag = 'Y' AND XLA_AE_JOURNAL_ENTRY_PKG.g_cache_ledgers_info.ledger_category_code <> 'ALC') or
8475: (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'))
8476:
8477: -- IF((l_calculate_g_l_flag='Y' or XLA_AE_JOURNAL_ENTRY_PKG.g_cache_event.target_ledger_id <>
8478: -- XLA_AE_JOURNAL_ENTRY_PKG.g_cache_event.ledger_id)
8479: AND (l_actual_flag = 'A')) THEN
8480: XLA_AE_LINES_PKG.CreateGainOrLossLines(
8481: p_event_id => xla_ae_journal_entry_pkg.g_cache_event.event_id
8482: ,p_application_id => p_application_id

Line 8481: p_event_id => xla_ae_journal_entry_pkg.g_cache_event.event_id

8477: -- IF((l_calculate_g_l_flag='Y' or XLA_AE_JOURNAL_ENTRY_PKG.g_cache_event.target_ledger_id <>
8478: -- XLA_AE_JOURNAL_ENTRY_PKG.g_cache_event.ledger_id)
8479: AND (l_actual_flag = 'A')) THEN
8480: XLA_AE_LINES_PKG.CreateGainOrLossLines(
8481: p_event_id => xla_ae_journal_entry_pkg.g_cache_event.event_id
8482: ,p_application_id => p_application_id
8483: ,p_amb_context_code => 'DEFAULT'
8484: ,p_entity_code => xla_ae_journal_entry_pkg.g_cache_event.entity_code
8485: ,p_event_class_code => C_EVENT_CLASS_CODE

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

8480: XLA_AE_LINES_PKG.CreateGainOrLossLines(
8481: p_event_id => xla_ae_journal_entry_pkg.g_cache_event.event_id
8482: ,p_application_id => p_application_id
8483: ,p_amb_context_code => 'DEFAULT'
8484: ,p_entity_code => xla_ae_journal_entry_pkg.g_cache_event.entity_code
8485: ,p_event_class_code => C_EVENT_CLASS_CODE
8486: ,p_event_type_code => C_EVENT_TYPE_CODE
8487:
8488: ,p_gain_ccid => -1

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

8602: ,p_level => C_LEVEL_PROCEDURE
8603: ,p_module => l_log_module);
8604: END IF;
8605:
8606: l_language := xla_ae_journal_entry_pkg.g_cache_ledgers_info.description_language;
8607: l_currency_code := xla_ae_journal_entry_pkg.g_cache_ledgers_info.currency_code;
8608: l_sla_ledger_id := xla_ae_journal_entry_pkg.g_cache_ledgers_info.sla_ledger_id;
8609:
8610: --

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

8603: ,p_module => l_log_module);
8604: END IF;
8605:
8606: l_language := xla_ae_journal_entry_pkg.g_cache_ledgers_info.description_language;
8607: l_currency_code := xla_ae_journal_entry_pkg.g_cache_ledgers_info.currency_code;
8608: l_sla_ledger_id := xla_ae_journal_entry_pkg.g_cache_ledgers_info.sla_ledger_id;
8609:
8610: --
8611: -- initialize array of lines with NULL

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

8604: END IF;
8605:
8606: l_language := xla_ae_journal_entry_pkg.g_cache_ledgers_info.description_language;
8607: l_currency_code := xla_ae_journal_entry_pkg.g_cache_ledgers_info.currency_code;
8608: l_sla_ledger_id := xla_ae_journal_entry_pkg.g_cache_ledgers_info.sla_ledger_id;
8609:
8610: --
8611: -- initialize array of lines with NULL
8612: --

Line 8804: xla_ae_journal_entry_pkg.SetProductAcctDefinition

8800: ,p_level => C_LEVEL_STATEMENT
8801: ,p_module => l_log_module);
8802: END IF;
8803: --
8804: xla_ae_journal_entry_pkg.SetProductAcctDefinition
8805: (p_product_rule_code => 'LNS_US_FEDERAL'
8806: ,p_product_rule_type_code => 'S'
8807: ,p_product_rule_version => ''
8808: ,p_product_rule_name => 'Loans US Federal'

Line 8813: xla_ae_journal_entry_pkg.GetAlternateCurrencyLedger

8809: ,p_amb_context_code => 'DEFAULT'
8810: );
8811:
8812: l_array_ledgers :=
8813: xla_ae_journal_entry_pkg.GetAlternateCurrencyLedger
8814: (p_base_ledger_id => p_base_ledger_id);
8815:
8816: FOR Idx IN 1 .. l_array_ledgers.COUNT LOOP
8817: l_temp_result :=

Line 8818: XLA_AE_JOURNAL_ENTRY_PKG.GetLedgersInfo

8814: (p_base_ledger_id => p_base_ledger_id);
8815:
8816: FOR Idx IN 1 .. l_array_ledgers.COUNT LOOP
8817: l_temp_result :=
8818: XLA_AE_JOURNAL_ENTRY_PKG.GetLedgersInfo
8819: (p_application_id => p_application_id
8820: ,p_base_ledger_id => p_base_ledger_id
8821: ,p_target_ledger_id => l_array_ledgers(Idx)
8822: ,p_primary_ledger_id => p_primary_ledger_id