APPS.AR_FLEXBUILDER_WF_PKG SQL Statements

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

Line: 18

l_insert_if_new varchar2(10); -- Bug 1936354

Line: 19

l_insert_new boolean; -- Bug 1936354

Line: 64

		SELECT 	DYNAMIC_INSERTS_ALLOWED_FLAG
		INTO   	l_insert_if_new
		FROM 	fnd_id_flex_Structures ffs,
		       	ar_system_parameters asp,
     			gl_sets_of_books glsob
		WHERE   ffs.APPLICATION_ID = 101
		AND   	ffs.ID_FLEX_CODE = 'GL#'
		AND   	ffs.ID_FLEX_NUM = glsob.chart_of_accounts_id
		AND   	glsob.set_of_books_id = asp.set_of_books_id;

Line: 75

  			WHEN OTHERS THEN l_insert_if_new := 'N';

Line: 78

  IF l_insert_if_new = 'Y' THEN
       l_insert_new := TRUE;

Line: 81

       l_insert_new := FALSE;

Line: 86

                                          insert_if_new => l_insert_new,
                                          ccid => x_return_ccid,
                                          concat_segs => x_concat_segs,
                                          concat_ids => x_concat_ids,
                                          concat_descrs => x_concat_descrs,
                                          error_message => X_ARERROR,
                                          new_combination => l_new_combination
					  );