APPS.XLA_SEQUENCE_DATAFIX_PKG dependencies on XLA_AE_HEADERS

Line 80: l_entry_status_code xla_ae_headers.accounting_entry_status_code%TYPE;

76: , p_ae_header_id IN NUMBER
77: , p_period_name IN VARCHAR2
78: , p_seq_ver_id IN NUMBER) is
79: l_seq_ver_id NUMBER;
80: l_entry_status_code xla_ae_headers.accounting_entry_status_code%TYPE;
81: l_start_date DATE := null;
82: l_result NUMBER:=0;
83: l_request_id NUMBER;
84: l_seq_context_value fun_seq_batch.context_value_tbl_type;

Line 122: FROM xla_ae_headers

118:
119: IF(p_ae_header_id is not null) THEN
120: SELECT accounting_entry_status_code, completion_acct_seq_version_id, completed_date
121: INTO l_entry_status_code, l_seq_ver_id, l_start_date
122: FROM xla_ae_headers
123: WHERE ae_header_id = p_ae_header_id
124: AND application_id = p_application_id;
125:
126: IF (l_entry_status_code <> 'F') THEN

Line 186: ,p_table_name => 'XLA_AE_HEADERS'

182: l_request_id := fnd_global.conc_request_id;
183:
184: l_seq_context_value(1) := p_ledger_id;
185: fun_seq_batch.Batch_init(p_application_id => 602
186: ,p_table_name => 'XLA_AE_HEADERS'
187: ,p_event_code => 'COMPLETION'
188: ,p_context_type => 'LEDGER_AND_CURRENCY'
189: ,p_context_value_tbl =>l_seq_context_value
190: ,p_request_id => l_request_id

Line 230: FROM xla_ae_headers

226: ,'a'
227: ,'a'
228: ,sysdate
229: ,'U'
230: FROM xla_ae_headers
231: WHERE completion_acct_seq_version_id = l_seq_ver_id
232: AND ledger_id = p_ledger_id
233: AND application_id = p_application_id
234: AND accounting_entry_status_code = 'F'

Line 262: FROM xla_ae_headers

258: ,'a'
259: ,'a'
260: ,sysdate
261: ,'U'
262: FROM xla_ae_headers
263: WHERE ledger_id = p_ledger_id
264: AND application_id = p_application_id
265: AND accounting_entry_status_code = 'F'
266: AND (completed_date >= l_start_date or completed_date is null);

Line 360: FROM xla_ae_headers

356: l_seq_ver_id NUMBER:=null;
357:
358: cursor c_seq_ver is
359: SELECT min(completion_acct_seq_value), completion_acct_seq_version_id
360: FROM xla_ae_headers
361: WHERE ledger_id = p_ledger_id
362: AND application_id = p_application_id
363: AND (completed_date >= p_start_date or completed_date is null)
364: AND accounting_entry_status_code = 'F'

Line 368: l_entry_status_code xla_ae_headers.accounting_entry_status_code%TYPE;

364: AND accounting_entry_status_code = 'F'
365: --AND completion_acct_seq_version_id is not null
366: GROUP BY completion_acct_seq_version_id;
367:
368: l_entry_status_code xla_ae_headers.accounting_entry_status_code%TYPE;
369: l_start_date DATE := null;
370: l_log_module VARCHAR2(240);
371:
372: BEGIN

Line 388: FROM xla_ae_headers

384:
385: IF(p_seq_ver_id is not null) THEN
386: SELECT min(completion_acct_seq_value)
387: INTO l_seq_value
388: FROM xla_ae_headers
389: WHERE ledger_id = p_ledger_id
390: AND application_id = p_application_id
391: AND accounting_entry_status_code = 'F'
392: AND completed_date >= p_start_date

Line 406: UPDATE xla_ae_headers

402:
403: IF(l_seq_value is not null) THEN
404: fun_seq.reset(p_seq_version_id => p_seq_ver_id
405: ,p_sequence_number => l_seq_value - 1 );
406: UPDATE xla_ae_headers
407: SET completion_acct_seq_version_id = null
408: ,completion_acct_seq_value = null
409: ,completion_acct_seq_assign_id = null
410: ,completed_date = null

Line 446: UPDATE xla_ae_headers

442: (p_msg => 'end the loop to reset the seq'
443: ,p_level => C_LEVEL_STATEMENT
444: ,p_module => l_log_module);
445: END IF;
446: UPDATE xla_ae_headers
447: SET completion_acct_seq_version_id = null
448: ,completion_acct_seq_value = null
449: ,completion_acct_seq_assign_id = null
450: ,completed_date = null