APPS.AD_PA_EDIT_ADVISOR_CRITERIA SQL Statements

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

Line: 11

  l_last_update_date date;

Line: 14

    select product_abbreviation,product_family_abbreviation,
           require_family_pack,require_mini_pack,require_high_priority
    from ad_pa_criteria_products
    where advisor_criteria_id =p_advisor_criteria_id
    and   product_abbreviation = p_product_abbreviation;

Line: 20

  l_last_update_date  := sysdate;

Line: 27

	 update  AD_PA_CRITERIA_products
	 set
	   require_family_pack  =p_require_family_pack,
	   require_mini_pack    =p_require_mini_pack,
	   REQUIRE_HIGH_PRIORITY=p_require_high_priority,
	   last_update_date = l_last_update_date
	 where advisor_criteria_id = p_advisor_criteria_id
	 and   product_abbreviation = p_product_abbreviation;

Line: 41

          'Attempting to insert a duplicate record '||
          'into AD_PA_ADVISOR_CRITERIA_PRODUCT advisor_criteria_id =  '||
          p_advisor_criteria_id || ' and product_abbreviation '||
          p_product_abbreviation);