APPS.QP_ADJUST_PRICELIST_PVT SQL Statements

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

Line: 58

l_update_stmt                 VARCHAR2(9000) := '';

Line: 59

l_select_stmt                 VARCHAR2(9000) := '';

Line: 61

l_where_select                VARCHAR2(9000) := '';

Line: 94

l_update_stmt := 'UPDATE qp_list_lines q

                 SET    q.operand = ';

Line: 98

l_select_stmt := 'SELECT NULL
                  FROM qp_list_lines q ';

Line: 101

l_where_select := 'AND q.operand + :chg < 0
                  AND rownum < 2 ';

Line: 116

      select rounding_factor
      into   l_rounding_factor
      from   qp_list_headers_b
      where  list_header_id = p_list_header_id;

Line: 129

         l_update_stmt := l_update_stmt ||
                 'ROUND((q.operand *(:chg/100) + q.operand),-1*:rf), ';

Line: 136

            l_update_stmt := l_update_stmt ||
                 'ROUND(((:chg) + q.operand),-1*:rf), ';

Line: 146

              l_update_stmt := l_update_stmt ||
                 'q.operand *(:chg/100) + q.operand, ';

Line: 152

              l_update_stmt := l_update_stmt ||
                 '(:chg) + q.operand, ';

Line: 159

l_update_stmt := l_update_stmt ||
    		'q.last_update_date  = :dat1,
    	  	 q.last_updated_by   = :usr,
    		 q.request_id        = :req,
    		 q.program_application_id = :app,
    		 q.program_id        = :pgm,
     	 q.program_update_date = :dat2,
    		 q.last_update_login = :lgn ';

Line: 174

	 (SELECT  DISTINCT a.list_line_id
	  FROM    qp_pricing_attributes a
	  WHERE   a.list_line_id = q.list_line_id ';

Line: 185

         (SELECT  a.list_line_id        --  7540916
          FROM    qp_pricing_attributes a
          WHERE   1 = 1 ';

Line: 212

    l_update_stmt := l_update_stmt ||
	 'AND     TO_NUMBER(a.product_attr_value) IN
    		( SELECT m.inventory_item_id
    		  FROM   mtl_system_items m
    		  WHERE  m.inventory_item_id = TO_NUMBER(a.product_attr_value) ';

Line: 225

	   (SELECT TO_CHAR(m.inventory_item_id)
         FROM  mtl_system_items m
	    WHERE  1=1 ';

Line: 247

                 ( SELECT ''x''			-- changes for 7540916
                   FROM   mtl_item_categories ic
                   WHERE  m.inventory_item_id = ic.inventory_item_id
                   AND    m.organization_id = ic.organization_id  ) ';

Line: 258

                 ( SELECT ''x''			-- changes for 7540916
                   FROM   mtl_item_categories ic
                   WHERE  m.inventory_item_id = ic.inventory_item_id
                   AND    m.organization_id = ic.organization_id
                   AND ic.category_set_id = :category_set_id ) ';

Line: 270

                 ( SELECT ''x''			-- changes for 7540916
                   FROM   mtl_item_categories ic
                   WHERE  m.inventory_item_id = ic.inventory_item_id
                   AND    m.organization_id = ic.organization_id
                   AND ic.category_set_id = :category_set_id
                   AND ic.category_id     = :category_id ) ';

Line: 287

		 ( SELECT ic.inventory_item_id
		   FROM   mtl_item_categories ic
		   WHERE  ic.inventory_item_id = m.inventory_item_id
		   AND    ic.organization_id   = m.organization_id
                   AND ic.organization_id = :org_id
                   AND ic.category_set_id = :category_set_id
		   AND ic.category_id     = :category_id ) ';

Line: 395

l_update_stmt := l_update_stmt || l_where_common || ' and     m.organization_id = :org_id ) )';

Line: 396

l_select_stmt := l_select_stmt || l_where_common || ' and     m.organization_id = :org_id ) )'||l_where_select ;

Line: 400

l_update_stmt := l_update_stmt || l_where_common || ' and     m.organization_id = :org_id )';

Line: 401

l_select_stmt := l_select_stmt || l_where_common || ' and     m.organization_id = :org_id )'||l_where_select ;

Line: 408

             EXECUTE IMMEDIATE l_select_stmt INTO dummy USING
   	     p_list_header_id, l_change;

Line: 412

               EXECUTE IMMEDIATE l_select_stmt INTO dummy USING
     	       p_list_header_id, p_org_id, l_change;

Line: 416

	       EXECUTE IMMEDIATE l_select_stmt INTO dummy USING
   	       p_list_header_id, p_org_id, p_category_set_id, l_change;

Line: 420

	       EXECUTE IMMEDIATE l_select_stmt INTO dummy USING
               p_list_header_id, p_org_id, p_category_set_id, p_category_id, l_change;

Line: 435

         EXECUTE IMMEDIATE l_update_stmt USING
         l_change,l_rounding_factor,l_sysdate, l_user_id,
         l_conc_request_id, l_conc_program_application_id,
         l_conc_program_id, l_sysdate, l_conc_login_id, p_list_header_id;

Line: 441

           EXECUTE IMMEDIATE l_update_stmt USING
           l_change,l_rounding_factor,l_sysdate, l_user_id,
           l_conc_request_id, l_conc_program_application_id,
           l_conc_program_id, l_sysdate, l_conc_login_id, p_list_header_id, p_org_id;

Line: 447

           EXECUTE IMMEDIATE l_update_stmt USING
           l_change,l_rounding_factor,l_sysdate, l_user_id,
           l_conc_request_id, l_conc_program_application_id,
           l_conc_program_id, l_sysdate, l_conc_login_id, p_list_header_id, p_org_id, p_category_set_id;

Line: 453

           EXECUTE IMMEDIATE l_update_stmt USING
           l_change,l_rounding_factor,l_sysdate, l_user_id,
           l_conc_request_id, l_conc_program_application_id,
           l_conc_program_id, l_sysdate, l_conc_login_id, p_list_header_id, p_org_id, p_category_set_id, p_category_id;

Line: 461

         EXECUTE IMMEDIATE l_update_stmt USING
         l_change,l_sysdate, l_user_id,
         l_conc_request_id, l_conc_program_application_id,
         l_conc_program_id, l_sysdate, l_conc_login_id, p_list_header_id;

Line: 467

           EXECUTE IMMEDIATE l_update_stmt USING
           l_change,l_sysdate, l_user_id,
           l_conc_request_id, l_conc_program_application_id,
           l_conc_program_id, l_sysdate, l_conc_login_id, p_list_header_id, p_org_id;

Line: 473

           EXECUTE IMMEDIATE l_update_stmt USING
           l_change,l_sysdate, l_user_id,
           l_conc_request_id, l_conc_program_application_id,
           l_conc_program_id, l_sysdate, l_conc_login_id, p_list_header_id, p_org_id, p_category_set_id;

Line: 479

           EXECUTE IMMEDIATE l_update_stmt USING
           l_change,l_sysdate, l_user_id,
           l_conc_request_id, l_conc_program_application_id,
           l_conc_program_id, l_sysdate, l_conc_login_id, p_list_header_id, p_org_id, p_category_set_id, p_category_id;