APPS.ASN_METHODOLOGY_PVT SQL Statements

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

Line: 29

         SELECT sales_stage_id, template_id
         FROM AS_SALES_METH_STAGE_MAP
         WHERE sales_methodology_id = p_meth_id;

Line: 34

         SELECT section_id, display_sequence
         FROM ASO_SUP_TMPL_SECT_MAP
         WHERE template_id = p_template_id;

Line: 39

         SELECT AS_METH_STAGE_INSTANCES_S.nextval
         FROM DUAL;

Line: 46

         SELECT 1
         FROM AS_RELATIONSHIPS
         WHERE object_type_code = p_object_type_code
         AND object_id = p_object_id
         AND relationship_type_code = p_relationship_type
         AND related_object_type_code = p_related_object_type_code
         AND ROWNUM = 1;

Line: 55

         SELECT 1
         FROM AS_SALES_METHODOLOGY_B
         WHERE sales_methodology_id = p_meth_id;

Line: 60

         SELECT secomp.sect_comp_map_id
	    ,null
         ,secomp.default_response_id
	    ,'N'
         FROM ASO_SUP_TMPL_SECT_MAP tempsec,
              ASO_SUP_SECT_COMP_MAP secomp
         WHERE secomp.section_id = tempsec.SECTION_ID
         AND tempsec.TEMPLATE_ID = p_template_id
         AND secomp.default_response_id IS NOT NULL;

Line: 184

            insert into AS_METH_STAGE_INSTANCES
               (METH_STAGE_INSTANCE_ID,
                LAST_UPDATE_DATE,
                LAST_UPDATED_BY,
                CREATION_DATE,
                CREATED_BY,
                LAST_UPDATE_LOGIN,
                OBJECT_VERSION_NUMBER,
                SALES_METHODOLOGY_ID,
                SALES_STAGE_ID,
                COMPLETE_FLAG)
             values
                (l_meth_stage_instance_id,
                 SYSDATE,
                 G_USER_ID,
                 SYSDATE,
                 G_USER_ID,
                 G_LOGIN_ID,
                 1,
                 p_sales_methodology_id,
                 l_meth_stage_data.sales_stage_id,
                 'N');

Line: 208

              insert into as_relationships
                 (RELATIONSHIP_ID,
                  LAST_UPDATE_DATE,
                  LAST_UPDATED_BY,
                  CREATION_DATE,
                  CREATED_BY,
                  LAST_UPDATE_LOGIN,
                  OBJECT_VERSION_NUMBER,
                  OBJECT_TYPE_CODE,
                  OBJECT_ID,
                  RELATED_OBJECT_TYPE_CODE,
                  RELATED_OBJECT_ID,
                  RELATIONSHIP_TYPE_CODE)
              values
                 (as_relationships_s.nextval,
                  SYSDATE,
                  G_USER_ID,
                  SYSDATE,
                  G_USER_ID,
                  G_LOGIN_ID,
                  1,
                  p_object_type_code,
                  p_object_id,
                  'METH_STAGE_INSTANCE',
                  l_meth_stage_instance_id,
                  'SALES_CYCLE');

Line: 238

               insert into as_meth_step_instances
                  (METH_STEP_INSTANCE_ID,
                   LAST_UPDATE_DATE,
                   LAST_UPDATED_BY,
                   CREATION_DATE,
                   CREATED_BY,
                   LAST_UPDATE_LOGIN,
                   OBJECT_VERSION_NUMBER,
                   METH_STAGE_INSTANCE_ID,
                   TEMPLATE_ID,
                   SECTION_ID,
                   DISPLAY_SEQUENCE,
                   COMPLETE_FLAG)
                values
                   (as_meth_step_instances_s.nextval,
                    SYSDATE,
                    G_USER_ID,
                    SYSDATE,
                    G_USER_ID,
                    G_LOGIN_ID,
                    1,
                    l_meth_stage_instance_id,
                    l_template_id,
                    l_tmpl_sect_data.section_id,
                    l_tmpl_sect_data.display_sequence,
                    'N');