APPS.IGI_ITR SQL Statements

The following lines contain the word 'select', 'insert', 'update' or 'delete':

Line: 44

    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
           );

Line: 111

SELECT *
FROM IGI_itr_charge_lines
WHERE it_header_id = p_it_header_id
  AND status_flag is null
  AND posting_flag is null;

Line: 119

    SELECT submit_flag into m_submit_flag
    FROM IGI_itr_charge_headers
    WHERE it_header_id = p_it_header_id;

Line: 123

    SELECT * into R_igi_itr_charge_headers
    FROM IGI_itr_charge_headers
    WHERE it_header_id = p_it_header_id;

Line: 127

    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;

Line: 131

    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;

Line: 136

	SELECT gl_journal_import_s.nextval
	INTO interface_group_id
	FROM dual;

Line: 139

	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
		);

Line: 187

		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
			);

Line: 234

SELECT gl_journal_import_s.nextval
INTO interface_sequence_num
FROM dual;

Line: 238

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
		);

Line: 298

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
	        );

Line: 341

	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
		);

Line: 386

	select * into R_header
	from IGI_itr_charge_headers
	where it_header_id  = p_it_header_id;

Line: 390

	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;

Line: 395

	select user_je_source_name into m_user_je_source_name
	from gl_je_sources
	where je_source_name = R_header.it_source;

Line: 399

	select user_je_category_name into m_user_je_category_name
        from gl_je_categories
	where je_category_name = R_header.it_category;

Line: 438

	select * into R_header
	from IGI_itr_charge_headers
	where it_header_id  = p_it_header_id;

Line: 442

	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;

Line: 447

	select user_je_source_name into m_user_je_source_name
	from gl_je_sources
	where je_source_name = R_header.it_source;

Line: 451

	select user_je_category_name into m_user_je_category_name
        from gl_je_categories
	where je_category_name = R_header.it_category;

Line: 455

	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
	        );

Line: 498

	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
		);

Line: 560

select je_header_id
from gl_je_headers
where je_batch_id = c_batch_id
  and je_source = 'Internal Trading';

Line: 566

is select reference_1,reference_2
from gl_je_lines
where je_header_id = c_header_id;

Line: 571

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;

Line: 582

           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;

Line: 587

                select 1 into a from IGI_itr_charge_headers
		where it_header_id = current_line.reference_1;

Line: 602

            UPDATE IGI_itr_charge_headers
            SET    submit_flag = 'F'
            WHERE  it_header_id = current_line.reference_1;

Line: 606

            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;

Line: 612

	 DELETE gl_je_lines where je_header_id IN
		 ( SELECT je_header_id
                   FROM   gl_je_headers
		   WHERE  je_batch_id = p_batch_id
                 );

Line: 617

	 DELETE gl_je_headers WHERE je_batch_id = p_batch_id;

Line: 618

	 DELETE gl_je_batches WHERE je_batch_id = p_batch_id;

Line: 627

            UPDATE IGI_itr_charge_headers
            SET submit_flag = 'D'
            WHERE it_header_id = current_line.reference_1;

Line: 631

            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;

Line: 637

      DELETE gl_je_lines where je_header_id IN
              (SELECT je_header_id
               FROM gl_je_headers
               WHERE je_batch_id = p_batch_id);

Line: 641

      delete gl_je_headers where je_batch_id = p_batch_id;

Line: 642

      delete gl_je_batches where je_batch_id = p_batch_id;

Line: 651

            UPDATE IGI_itr_charge_headers
            SET    submit_flag = 'O'
            WHERE  it_header_id = current_line.reference_1;

Line: 655

            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;

Line: 661

/*	 DELETE gl_je_lines where je_header_id IN
		 ( SELECT je_header_id
                   FROM   gl_je_headers
		   WHERE  je_batch_id = p_batch_id
                 );

Line: 666

	 DELETE gl_je_headers WHERE je_batch_id = p_batch_id;

Line: 667

	 DELETE gl_je_batches WHERE je_batch_id = p_batch_id;

Line: 673

            UPDATE IGI_itr_charge_headers
            SET    submit_flag = 'D'
            WHERE  it_header_id = current_line.reference_1;

Line: 677

            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;

Line: 683

	 DELETE gl_je_lines where je_header_id IN
		 ( SELECT je_header_id
                   FROM   gl_je_headers
		   WHERE  je_batch_id = p_batch_id
                 );

Line: 688

	 DELETE gl_je_headers WHERE je_batch_id = p_batch_id;

Line: 689

	 DELETE gl_je_batches WHERE je_batch_id = p_batch_id;

Line: 695

            UPDATE IGI_itr_charge_headers
            SET    submit_flag = 'O'
            WHERE  it_header_id = current_line.reference_1;

Line: 699

            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;

Line: 712

         UPDATE IGI_itr_charge_headers
         SET    submit_flag = 'P'
         WHERE  it_header_id = current_line.reference_1;

Line: 718

         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;

Line: 723

	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';