APPS.OTAFRUDT SQL Statements

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

Line: 8

PROCEDURE insert_table_data (P_BUSINESS_GROUP_ID_ITD	IN number,
			     P_LEGISLATION_CODE_ITD	IN varchar2,
			     P_APPLICATION_ID_ITD	IN number,
			     P_RANGE_OR_MATCH_ITD	IN varchar2,
			     P_USER_KEY_UNITS_ITD	IN varchar2,
			     P_USER_TABLE_NAME_ITD	IN varchar2,
			     P_USER_ROW_TITLE_ITD	IN varchar2)
IS
   v_table_rowid		varchar2(100);

Line: 19

   hr_utility.trace ('PROCEDURE insert_data entered.');

Line: 24

	PAY_USER_TABLES_PKG.INSERT_ROW
		(P_ROWID 		=> v_table_rowid,
		 P_USER_TABLE_ID	=> v_user_table_id,
		 P_BUSINESS_GROUP_ID	=> P_BUSINESS_GROUP_ID_ITD,
		 P_LEGISLATION_CODE	=> P_LEGISLATION_CODE_ITD,
		 P_LEGISLATION_SUBGROUP	=> NULL,
		 P_RANGE_OR_MATCH	=> P_RANGE_OR_MATCH_ITD,
		 P_USER_KEY_UNITS	=> P_USER_KEY_UNITS_ITD,
		 P_USER_TABLE_NAME	=> P_USER_TABLE_NAME_ITD,
		 P_USER_ROW_TITLE	=> P_USER_ROW_TITLE_ITD);

Line: 35

   hr_utility.trace ('PROCEDURE insert_data exiting.');

Line: 36

END insert_table_data;

Line: 53

   SELECT	user_table_name
   FROM		pay_user_tables
   WHERE	business_group_id = P_BUSINESS_GROUP_ID_CT
   AND		user_table_name = P_USER_TABLE_NAME_CT;

Line: 64

   SELECT 	legislation_code
   INTO		v_legislation_code
   FROM		per_business_groups
   WHERE	business_group_id = P_BUSINESS_GROUP_ID_CT;

Line: 73

      hr_utility.trace ('inserting data into '||P_USER_TABLE_NAME_CT||' from create_table.');

Line: 75

      insert_table_data (P_BUSINESS_GROUP_ID_ITD	=> P_BUSINESS_GROUP_ID_CT,
   		         P_LEGISLATION_CODE_ITD		=> v_legislation_code,
		         P_APPLICATION_ID_ITD		=> P_APPLICATION_ID_CT,
		         P_RANGE_OR_MATCH_ITD		=> P_RANGE_OR_MATCH_CT,
		         P_USER_KEY_UNITS_ITD		=> P_USER_KEY_UNITS_CT,
		         P_USER_TABLE_NAME_ITD		=> P_USER_TABLE_NAME_CT,
		         P_USER_ROW_TITLE_ITD		=> P_USER_ROW_TITLE_CT);

Line: 109

   SELECT 	user_column_id
   FROM		pay_user_columns
   WHERE 	user_table_id =
   		(SELECT 	user_table_id
   		 FROM		pay_user_tables
   		 WHERE		business_group_id = P_BUSINESS_GROUP_ID_CC
   		 AND		user_table_name = P_USER_TABLE_NAME_CC)
   AND		user_column_name = P_USER_COLUMN_NAME_CC;

Line: 121

   SELECT 	user_table_id
   INTO		v_user_table_id
   FROM		pay_user_tables
   WHERE	user_table_name = P_USER_TABLE_NAME_CC
   AND		business_group_id = P_BUSINESS_GROUP_ID_CC;

Line: 127

   SELECT 	legislation_code
   INTO		v_legislation_code
   FROM		per_business_groups
   WHERE	business_group_id = P_BUSINESS_GROUP_ID_CC;

Line: 136

      PAY_USER_COLUMNS_PKG.INSERT_ROW
         (P_ROWID			=> v_column_row_id,
   	  P_USER_COLUMN_ID		=> v_user_column_id,
   	  P_USER_TABLE_ID		=> v_user_table_id,
   	  P_BUSINESS_GROUP_ID		=> P_BUSINESS_GROUP_ID_CC,
   	  P_LEGISLATION_CODE		=> v_legislation_code,
   	  P_LEGISLATION_SUBGROUP	=> NULL,
   	  P_USER_COLUMN_NAME		=> P_USER_COLUMN_NAME_CC,
   	  P_FORMULA_ID			=> NULL);

Line: 178

   SELECT 	user_row_id
   FROM		pay_user_rows_f
   WHERE	user_table_id = (SELECT	user_table_id
   				 FROM 	pay_user_tables
   				 WHERE	user_table_name = P_USER_TABLE_NAME_CR
   				 AND	business_group_id = P_BUSINESS_GROUP_ID_CR)
   AND		 P_ROW_LOW_RANGE_OR_NAME_CR = row_low_range_or_name;

Line: 187

   SELECT	user_column_instance_id
   FROM		pay_user_column_instances_f
   WHERE	user_row_id = p_user_row_id
   AND		user_column_id = p_user_column_id;

Line: 195

   SELECT 	user_table_id, legislation_code
   INTO		v_user_table_id, v_legislation_code
   FROM		pay_user_tables
   WHERE	user_table_name = P_USER_TABLE_NAME_CR
   AND		business_group_id = P_BUSINESS_GROUP_ID_CR;

Line: 206

   	SELECT		pay_user_rows_s.nextval
	INTO		v_user_row_id
	FROM		dual;

Line: 210

   	-- this insertion creates the row

        hr_utility.trace ('Inserting row '||P_ROW_LOW_RANGE_OR_NAME_CR);

Line: 214

  	INSERT INTO pay_user_rows_f (user_row_id,
    				     effective_start_date,
    				     effective_end_date,
	    			     business_group_id,
    				     legislation_code,
    				     user_table_id,
    				     row_low_range_or_name,
    				     display_sequence,
    				     legislation_subgroup,
    				     row_high_range)

	VALUES		       	    (v_user_row_id,
   				     v_start_date,
   				     v_end_date,
				     P_BUSINESS_GROUP_ID_CR,
				     v_legislation_code,
				     v_user_table_id,
				     P_ROW_LOW_RANGE_OR_NAME_CR,
				     P_DISPLAY_SEQUENCE_CR,
				     NULL,
				     NULL);

Line: 248

   SELECT	user_column_id
   INTO		v_user_column_id
   FROM		pay_user_columns_v
   WHERE	user_column_name = P_USER_COLUMN_NAME_CR
   AND		user_table_id = v_user_table_id;

Line: 258

      hr_utility.set_location ('inserting instance', 10);

Line: 259

      PAY_USER_COLUMN_INSTANCES_PKG.INSERT_ROW
         (P_ROWID			=> v_column_instance_rowid
         ,P_USER_COLUMN_INSTANCE_ID	=> v_user_column_instance_id
         ,P_EFFECTIVE_START_DATE	=> v_start_date
         ,P_EFFECTIVE_END_DATE		=> v_end_date
         ,P_USER_ROW_ID			=> v_user_row_id
         ,P_USER_COLUMN_ID		=> v_user_column_id
         ,P_BUSINESS_GROUP_ID		=> P_BUSINESS_GROUP_ID_CR
         ,P_LEGISLATION_CODE		=> v_legislation_code
         ,P_LEGISLATION_SUBGROUP	=> NULL
         ,P_VALUE			=> P_VALUE_CR);

Line: 295

   SELECT	lookup_code, meaning
   FROM 	fnd_common_lookups
   WHERE	lookup_type = P_LOOKUP_TYPE;