[Home] [Help]
The following lines contain the word 'select', 'insert', 'update' or 'delete':
delete_seq_requests (p_request_id => null);
delete_seq_requests (p_request_id => null);
delete_seq_requests (p_request_id => p_request_id);
UPDATE fun_seq_versions
SET current_value = l_current_value
WHERE seq_version_id = l_seq_ver_id_tbl(i);
END IF; -- Update the Last Used Number or Not
SELECT jh.ledger_id,
bg.source_id,
jh.actual_flag,
jh.je_source,
jh.je_category,
jh.default_effective_date
BULK COLLECT
INTO l_ledger_id_tbl,
l_je_header_id_tbl,
l_actual_flag_tbl,
l_je_source_tbl,
l_je_category_tbl,
l_gl_date_tbl
FROM fun_seq_batch_gt bg,
gl_je_headers jh
WHERE bg.source_id = jh.je_header_id;
UPDATE fun_seq_batch_gt
SET assignment_id = l_assign_id_tbl(i),
seq_version_id = l_seq_ver_id_tbl(i),
status_code = l_error_code_tbl(i)
WHERE source_id = l_je_header_id_tbl(i);
SELECT bg.source_id,
bg.seq_version_id,
bg.assignment_id
BULK COLLECT
INTO l_source_id_tbl,
l_seq_ver_id_tbl,
l_assign_id_tbl
FROM fun_seq_batch_gt bg,
gl_je_headers jh
WHERE jh.je_header_id =bg.source_id and
bg.status_code = 'SEQ_VER_FOUND'
ORDER BY bg.seq_version_id,
bg.assignment_id,
jh.default_effective_date;
SELECT source_id,
seq_version_id,
assignment_id
BULK COLLECT
INTO l_source_id_tbl,
l_seq_ver_id_tbl,
l_assign_id_tbl
FROM fun_seq_batch_gt
WHERE status_code = 'SEQ_VER_FOUND'
ORDER BY seq_version_id,
assignment_id;
UPDATE fun_seq_batch_gt gt
SET gt.seq_version_id = l_seq_ver_id_tbl(i),
gt.assignment_id = l_assign_id_tbl(i),
gt.seq_value = l_seq_value_tbl(i)
WHERE gt.source_id = l_source_id_tbl(i);
delete_seq_requests(p_request_id => p_request_id);
INSERT INTO fun_seq_requests (
request_id,
source_type,
source_id,
last_update_date,
last_updated_by,
creation_date,
created_by,
last_update_login)
VALUES (
p_request_id,
'C',
p_seq_context_id,
sysdate,
l_user_id,
sysdate,
l_user_id,
l_login_id);
SELECT sa.seq_header_id
BULK COLLECT
INTO l_seq_headers
FROM fun_seq_assignments sa
WHERE sa.seq_context_id = p_seq_context_id
AND sa.use_status_code IN ('NEW','USED');
INSERT INTO fun_seq_requests(
request_id,
source_type,
source_id,
last_update_date,
last_updated_by,
creation_date,
created_by,
last_update_login)
VALUES (
p_request_id,
'S',
l_seq_headers(i),
sysdate,
l_user_id,
sysdate,
l_user_id,
l_login_id);
PROCEDURE Delete_Seq_Requests (
p_request_id IN NUMBER) IS
l_phase VARCHAR2(30);
SELECT request_id
BULK COLLECT
INTO l_req_id_tbl
FROM fun_seq_requests;
select distinct phase_code into l_phase_code from fnd_concurrent_requests
where parent_request_id= p_request_id;
delete from fun_seq_requests where request_id=p_request_id;
delete from fun_seq_requests where request_id=p_request_id;
DELETE
FROM fun_seq_requests
WHERE request_id = l_comp_req_id_tbl(i);
END Delete_Seq_Requests;
SELECT ae_header_id,
ledger_id,
balance_type_code,
je_source_name,
je_category_name,
doc_category_code,
application_id ||'.'|| accounting_event_type_code,
accounting_entry_type_code,
gl_date
BULK COLLECT INTO
l_ae_header_id_tbl,
l_ledger_id_tbl,
l_balance_type_code_tbl,
l_je_source_name_tbl,
l_je_category_name_tbl,
l_doc_category_code_tbl,
l_acct_event_type_code_tbl,
l_acct_entry_type_code_tbl,
l_gl_date_tbl
FROM XLA_ACCT_PROG_SEQ_V
WHERE completion_acct_seq_assign_id IS NULL
AND completion_acct_seq_version_id IS NULL
AND completion_acct_seq_value IS NULL;
UPDATE xla_acct_prog_seq_v
SET completion_acct_seq_assign_id = l_sorted_assign_id_tbl(i),
completion_acct_seq_version_id = l_sorted_seq_ver_id_tbl(i),
completion_acct_seq_value = l_sorted_seq_value_tbl(i),
completion_date = l_sorted_seq_date_tbl(i)
WHERE ae_header_id = l_sorted_ae_header_id_tbl(i);
SELECT ae_header_id,
application_id,
DECODE(application_id,602,'XLA_AE_HEADERS',
101,'GL_JE_HEADERS',
null),
ledger_id,
je_source_name,
je_category_name,
gl_date,
reference_date,
completion_posted_date
BULK COLLECT INTO
l_ae_header_id_tbl,
l_application_id_tbl,
l_table_name_tbl,
l_ledger_id_tbl,
l_je_source_name_tbl,
l_je_category_name_tbl,
l_gl_date_tbl,
l_reference_date_tbl,
l_completion_date_tbl
FROM xla_seq_je_headers_gt
WHERE sequence_assign_id IS NULL
AND sequence_version_id IS NULL
AND sequence_value IS NULL;
UPDATE xla_seq_je_headers_gt
SET sequence_assign_id = l_sorted_assign_id_tbl(i),
sequence_version_id = l_sorted_seq_ver_id_tbl(i),
sequence_value = l_sorted_seq_value_tbl(i)
WHERE application_id = l_sorted_application_id_tbl(i)
AND ae_header_id = l_sorted_ae_header_id_tbl(i);
SELECT name
INTO l_context_name
FROM fun_seq_contexts WHERE
context_type=l_context_type AND
context_value=l_context_value AND
application_id=l_application_id AND
table_name=l_table_name AND
event_code='PERIOD_CLOSE';
SELECT sqtmp.source_id,
sqtmp.assignment_id,
sqtmp.seq_version_id
-- Don't need sorting key for the Completion event
BULK COLLECT
INTO x_ae_header_id_tbl,
x_assign_id_tbl,
x_seq_ver_id_tbl
FROM THE (SELECT CAST( l_temp_tab as fun_seq_bt_tbl_type)
FROM dual ) sqtmp
ORDER BY
sqtmp.seq_version_id,
sqtmp.sorting_key;
SELECT sqtmp.application_id,
sqtmp.source_id,
sqtmp.assignment_id,
sqtmp.seq_version_id
BULK COLLECT
INTO x_application_id_tbl,
x_ae_header_id_tbl,
x_assign_id_tbl,
x_seq_ver_id_tbl
FROM THE (SELECT CAST( l_temp_tab as fun_seq_bt_tbl_type)
FROM dual ) sqtmp
ORDER BY
sqtmp.seq_version_id,
sqtmp.sorting_key;