The following lines contain the word 'select', 'insert', 'update' or 'delete':
INSERT INTO gl_interface_control ( je_source_name
, status
, interface_run_id
, group_id
, set_of_books_id
)
VALUES ( 'Internal Trading'
, 'S'
, p_interface_run_id
, p_group_id
, p_set_of_books_id
);
SELECT *
FROM IGI_itr_charge_lines
WHERE it_header_id = p_it_header_id
AND status_flag is null
AND posting_flag is null;
SELECT submit_flag into m_submit_flag
FROM IGI_itr_charge_headers
WHERE it_header_id = p_it_header_id;
SELECT * into R_igi_itr_charge_headers
FROM IGI_itr_charge_headers
WHERE it_header_id = p_it_header_id;
SELECT user_je_source_name into m_user_je_source_name
FROM gl_je_sources
WHERE je_source_name = R_igi_itr_charge_headers.it_source;
SELECT user_je_category_name into m_user_je_category_name
FROM gl_je_categories
WHERE je_category_name = R_igi_itr_charge_headers.it_category;
SELECT gl_journal_import_s.nextval
INTO interface_group_id
FROM dual;
INSERT INTO gl_interface
(status
,entered_dr
,entered_cr
,set_of_books_id
,user_je_source_name
,user_je_category_name
,accounting_date
,currency_code
,date_created
,created_by
,actual_flag
,encumbrance_type_id
,code_combination_id
,reference1
,reference4
,reference5
,reference10
,reference21
,reference22
,group_id
)
VALUES ('NEW'
,R_igi_itr_charge_headers.entered_dr
,R_igi_itr_charge_headers.entered_cr
,R_igi_itr_charge_headers.set_of_books_id
,m_user_je_source_name
,m_user_je_category_name
,R_igi_itr_charge_headers.gl_date
,R_igi_itr_charge_headers.currency_code
,R_igi_itr_charge_headers.creation_date
,R_igi_itr_charge_headers.created_by
,'E'
,R_igi_itr_charge_headers.encumbrance_type_id
,R_igi_itr_charge_headers.code_combination_id
,R_igi_itr_charge_headers.name
,R_igi_itr_charge_headers.name
,R_igi_itr_charge_headers.description
,R_igi_itr_charge_headers.description
,R_igi_itr_charge_headers.it_header_id
,NULL
,interface_group_id
);
INSERT INTO gl_interface
(status
,entered_dr
,entered_cr
,set_of_books_id
,user_je_source_name
,user_je_category_name
,accounting_date
,currency_code
,date_created
,created_by
,actual_flag
,encumbrance_type_id
,code_combination_id
,reference1
,reference4
,reference5
,reference10
,reference21
,reference22
,group_id
)
VALUES ('NEW'
,R_igi_itr_charge_lines.entered_dr
,R_igi_itr_charge_lines.entered_cr
,R_igi_itr_charge_lines.set_of_books_id
,m_user_je_source_name
,m_user_je_category_name
,R_igi_itr_charge_headers.gl_date
,R_igi_itr_charge_headers.currency_code
,R_igi_itr_charge_lines.creation_date
,R_igi_itr_charge_lines.created_by
,'E'
,R_igi_itr_charge_headers.encumbrance_type_id
,R_igi_itr_charge_lines.code_combination_id
,R_igi_itr_charge_headers.name
,R_igi_itr_charge_headers.name
,R_igi_itr_charge_headers.description
,R_igi_itr_charge_lines.description
,R_igi_itr_charge_headers.it_header_id
,R_igi_itr_charge_lines.it_line_num
,interface_group_id
);
SELECT gl_journal_import_s.nextval
INTO interface_sequence_num
FROM dual;
INSERT INTO gl_interface_control
(je_source_name
,status
,interface_run_id
,group_id
,set_of_books_id)
VALUES
('Internal Trading'
,'S'
,interface_sequence_num
,interface_group_id
,R_igi_itr_charge_headers.set_of_books_id
);
insert into gl_interface
(status
,entered_dr
,entered_cr
,set_of_books_id
,user_je_source_name
,user_je_category_name
,accounting_date
,currency_code
,date_created
,created_by
,actual_flag
,encumbrance_type_id
,code_combination_id
,reference1
,reference4
,reference5
,reference10
,reference21
,reference22
,group_id
)
values ('NEW'
,R_line.entered_dr
,R_line.entered_cr
,R_line.set_of_books_id
,m_user_je_source_name
,m_user_je_category_name
,R_header.gl_date
,R_header.currency_code
,R_line.creation_date
,R_line.created_by
,'A'
,null
,R_line.code_combination_id
,R_header.name
,R_header.name
,R_header.description
,R_line.description
,p_it_header_id
,p_it_line_num
,p_group_id
);
insert into gl_interface
(status
,entered_dr
,entered_cr
,set_of_books_id
,user_je_source_name
,user_je_category_name
,accounting_date
,currency_code
,date_created
,created_by
,actual_flag
,encumbrance_type_id
,code_combination_id
,reference1
,reference4
,reference5
,reference10
,reference21
,reference22
,group_id
)
values ('NEW'
,R_line.entered_cr
,R_line.entered_dr
,R_header.set_of_books_id
,m_user_je_source_name
,m_user_je_category_name
,R_header.gl_date
,R_header.currency_code
,R_header.creation_date
,R_header.created_by
,'A'
,null
,R_header.code_combination_id
,R_header.name
,R_header.name
,R_header.description
,R_header.description
,p_it_header_id
,p_it_line_num
,p_group_id
);
select * into R_header
from IGI_itr_charge_headers
where it_header_id = p_it_header_id;
select * into R_line
from IGI_itr_charge_lines
where it_header_id = p_it_header_id
and it_line_num = p_it_line_num;
select user_je_source_name into m_user_je_source_name
from gl_je_sources
where je_source_name = R_header.it_source;
select user_je_category_name into m_user_je_category_name
from gl_je_categories
where je_category_name = R_header.it_category;
select * into R_header
from IGI_itr_charge_headers
where it_header_id = p_it_header_id;
select * into R_line
from IGI_itr_charge_lines
where it_header_id = p_it_header_id
and it_line_num = p_it_line_num;
select user_je_source_name into m_user_je_source_name
from gl_je_sources
where je_source_name = R_header.it_source;
select user_je_category_name into m_user_je_category_name
from gl_je_categories
where je_category_name = R_header.it_category;
insert into gl_interface
(status
,entered_dr
,entered_cr
,set_of_books_id
,user_je_source_name
,user_je_category_name
,accounting_date
,currency_code
,date_created
,created_by
,actual_flag
,encumbrance_type_id
,code_combination_id
,reference1
,reference4
,reference5
,reference10
,reference21
,reference22
,group_id
)
values ('NEW'
,R_line.entered_cr
,R_line.entered_dr
,R_line.set_of_books_id
,m_user_je_source_name
,m_user_je_category_name
,R_header.gl_date
,R_header.currency_code
,R_line.creation_date
,R_line.created_by
,'E'
,R_header.encumbrance_type_id
,R_line.code_combination_id
,R_header.name
,R_header.name
,R_header.description
,R_line.description
,p_it_header_id
,p_it_line_num
,p_group_id
);
insert into gl_interface
(status
,entered_dr
,entered_cr
,set_of_books_id
,user_je_source_name
,user_je_category_name
,accounting_date
,currency_code
,date_created
,created_by
,actual_flag
,encumbrance_type_id
,code_combination_id
,reference1
,reference4
,reference5
,reference10
,reference21
,reference22
,group_id
)
values ('NEW'
,R_line.entered_dr
,R_line.entered_cr
,R_header.set_of_books_id
,m_user_je_source_name
,m_user_je_category_name
,R_header.gl_date
,R_header.currency_code
,R_header.creation_date
,R_header.created_by
,'E'
,R_header.encumbrance_type_id
,R_header.code_combination_id
,R_header.name
,R_header.name
,R_header.description
,R_header.description
,p_it_header_id
,p_it_line_num
,p_group_id
);
select je_header_id
from gl_je_headers
where je_batch_id = c_batch_id
and je_source = 'Internal Trading';
is select reference_1,reference_2
from gl_je_lines
where je_header_id = c_header_id;
select budgetary_control_status, status,actual_flag into
b_budgetary_control_status, b_status_flag , b_actual_flag
from gl_je_batches
where je_batch_id = p_batch_id;
select status_flag, posting_flag into l_status_flag, l_posting_flag
from IGI_itr_charge_lines
where it_header_id = current_line.reference_1 and
it_line_num = current_line.reference_2;
select 1 into a from IGI_itr_charge_headers
where it_header_id = current_line.reference_1;
UPDATE IGI_itr_charge_headers
SET submit_flag = 'F'
WHERE it_header_id = current_line.reference_1;
UPDATE IGI_itr_charge_lines
SET posting_flag = 'F'
WHERE it_header_id = current_line.reference_1
AND it_line_num = current_line.reference_2;
DELETE gl_je_lines where je_header_id IN
( SELECT je_header_id
FROM gl_je_headers
WHERE je_batch_id = p_batch_id
);
DELETE gl_je_headers WHERE je_batch_id = p_batch_id;
DELETE gl_je_batches WHERE je_batch_id = p_batch_id;
UPDATE IGI_itr_charge_headers
SET submit_flag = 'D'
WHERE it_header_id = current_line.reference_1;
UPDATE IGI_itr_charge_lines
SET posting_flag = 'D'
WHERE it_header_id = current_line.reference_1
AND it_line_num = current_line.reference_2;
DELETE gl_je_lines where je_header_id IN
(SELECT je_header_id
FROM gl_je_headers
WHERE je_batch_id = p_batch_id);
delete gl_je_headers where je_batch_id = p_batch_id;
delete gl_je_batches where je_batch_id = p_batch_id;
UPDATE IGI_itr_charge_headers
SET submit_flag = 'O'
WHERE it_header_id = current_line.reference_1;
UPDATE IGI_itr_charge_lines
SET posting_flag = 'O'
WHERE it_header_id = current_line.reference_1
AND it_line_num = current_line.reference_2;
/* DELETE gl_je_lines where je_header_id IN
( SELECT je_header_id
FROM gl_je_headers
WHERE je_batch_id = p_batch_id
);
DELETE gl_je_headers WHERE je_batch_id = p_batch_id;
DELETE gl_je_batches WHERE je_batch_id = p_batch_id;
UPDATE IGI_itr_charge_headers
SET submit_flag = 'D'
WHERE it_header_id = current_line.reference_1;
UPDATE IGI_itr_charge_lines
SET posting_flag = 'D'
WHERE it_header_id = current_line.reference_1
AND it_line_num = current_line.reference_2;
DELETE gl_je_lines where je_header_id IN
( SELECT je_header_id
FROM gl_je_headers
WHERE je_batch_id = p_batch_id
);
DELETE gl_je_headers WHERE je_batch_id = p_batch_id;
DELETE gl_je_batches WHERE je_batch_id = p_batch_id;
UPDATE IGI_itr_charge_headers
SET submit_flag = 'O'
WHERE it_header_id = current_line.reference_1;
UPDATE IGI_itr_charge_lines
SET posting_flag = 'O'
WHERE it_header_id = current_line.reference_1
AND it_line_num = current_line.reference_2;
UPDATE IGI_itr_charge_headers
SET submit_flag = 'P'
WHERE it_header_id = current_line.reference_1;
UPDATE IGI_itr_charge_lines
SET posting_flag = 'P'
WHERE it_header_id = current_line.reference_1
AND it_line_num = current_line.reference_2;
UPDATE IGI_itr_charge_headers
set submit_flag = 'C' where
it_header_id = current_line.reference_1
and ('A','P') =all (select status_flag,posting_flag
from IGI_itr_charge_lines
where it_header_id = current_line.reference_1)
AND b_actual_flag = 'A';