APPS.AD_PA_CREATE_ADVISOR_CRITERIA SQL Statements

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

Line: 4

Procedure insert_criteria(p_advisor_criteria_id           varchar2,
                p_advisor_criteria_description            varchar2,
                p_pre_seeded_flag                         varchar2,
                p_last_updated_by                         number,
                p_created_by                              number)
IS
  l_uid number;

Line: 12

  l_uid := p_last_updated_by;

Line: 19

    insert into AD_PA_CRITERIA
      (ADVISOR_CRITERIA_ID,ADVISOR_CRITERIA_DESCRIPTION,PRE_SEEDED_FLAG,
       CREATION_DATE,LAST_UPDATED_BY,CREATED_BY,LAST_UPDATE_DATE)
    values (p_advisor_criteria_id,p_advisor_criteria_description,
            p_pre_seeded_flag,sysdate,p_last_updated_by,p_created_by,sysdate);

Line: 28

                   'Attempting to insert a duplicate record '||
                   'into AD_PA_ADVISOR_CRITERIA advisor_criteria_id =  '||
                   p_advisor_criteria_id || ' and pre_seeded_flag '||
                   p_pre_seeded_flag);

Line: 34

END insert_criteria;

Line: 37

Procedure insert_criteria_prod(p_advisor_criteria_id       varchar2,
                p_product_abbreviation                     varchar2,
                p_product_family_abbreviation              varchar2,
                p_require_family_pack                      varchar2,
                p_require_mini_pack                        varchar2,
                p_require_high_priority                    varchar2,
                p_last_updated_by                          number,
                p_created_by                               number)
IS
  l_uid number;

Line: 48

  l_uid := p_last_updated_by;

Line: 55

    insert into AD_PA_CRITERIA_PRODUCTS
      (ADVISOR_CRITERIA_ID,PRODUCT_ABBREVIATION,PRODUCT_FAMILY_ABBREVIATION,
       REQUIRE_FAMILY_PACK,REQUIRE_MINI_PACK,REQUIRE_HIGH_PRIORITY,
       CREATION_DATE,LAST_UPDATED_BY,CREATED_BY,LAST_UPDATE_DATE)
     values (p_advisor_criteria_id,p_product_abbreviation,
             p_product_family_abbreviation,p_require_family_pack,
             p_require_mini_pack,p_require_high_priority,sysdate,
             p_last_updated_by,p_created_by,sysdate);

Line: 67

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

Line: 72

END insert_criteria_prod;