APPS.AP_WEB_DISC_PKG SQL Statements

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

Line: 1537

		-- Exptype is already selected.
		-- But don't want to complain if they just entered the same
	        -- thing twice.
		------------------------------------------
		if (p_receipts(rec_count).parameter_id <> l_xtype_code) then
		 ------------------------------------------
		 -- Record multiple exptype error.
		 ------------------------------------------
		 debug_info := 'reporting multi expense type error';

Line: 1768

  	 SELECT award_id
 	 INTO p_receipts(rec_count).award_id
 	 FROM GMS_AWARDS
 	 WHERE award_number = p_receipts(rec_count).award_number;

Line: 1912

        p_DataDefaultedUpdateable	IN OUT NOCOPY BOOLEAN)
IS
  l_receipts_with_errors_core   BINARY_INTEGER;

Line: 2108

			       p_DataDefaultedUpdateable,
			       TRUE, -- Calling from disconnected
                               p_cust_meals_amount => l_temp_array,
                               p_cust_accommodation_amount => l_temp_array,
                               p_cust_night_rate_amount => l_temp_array,
                               p_cust_pdm_rate => l_temp_array);

Line: 2118

     l_temp_array.delete; -- bug 5358186

Line: 2598

  	P_DataDefaultedUpdateable   OUT NOCOPY BOOLEAN,
	p_errors 	 OUT NOCOPY AP_WEB_UTILITIES_PKG.expError,
	p_receipt_errors OUT NOCOPY AP_WEB_UTILITIES_PKG.receipt_error_stack,
        p_error_type            OUT NOCOPY VARCHAR2,                   -- Setup/data/no errors encountered
        p_techstack             IN  VARCHAR2 DEFAULT C_OldStack -- Old or new tech stack
) IS
  l_exp			LONG := p_exp;

Line: 2917

                                                      P_DataDefaultedUpdateable);

Line: 2931

                                                      P_DataDefaultedUpdateable);

Line: 3553

        select  ATTRIBUTE_LABEL_LONG,ATTRIBUTE_CODE
        from    AK_REGION_ITEMS_VL
        where   REGION_CODE = p_reg_code
        order by DISPLAY_SEQUENCE;