APPS.CN_REVENUE_CLASS_PKG SQL Statements

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

Line: 37

    SELECT cn_revenue_classes_s.nextval
      INTO   X_revenue_class_id
      FROM   dual;

Line: 49

PROCEDURE insert_row
   (x_revenue_class_id          IN OUT NOCOPY NUMBER
    ,p_name                     VARCHAR2   := NULL
    ,p_description 		VARCHAR2   := NULL
    ,p_liability_account_id    NUMBER      := NULL
    ,p_expense_account_id      NUMBER      := NULL
    ,p_Created_By               NUMBER
    ,p_Creation_Date            DATE
    ,p_Last_Updated_By          NUMBER
    ,p_Last_Update_Date         DATE
    ,p_Last_Update_Login        NUMBER
    ,p_org_id	IN		NUMBER)
   IS
      l_dummy NUMBER;

Line: 68

     INSERT INTO cn_revenue_Classes
       ( ORG_ID
        ,revenue_class_id
        ,name
        ,DESCRIPTION
        ,liability_account_id
        ,expense_account_id
        ,object_version_number
 	,Created_By
	,Creation_Date
	,Last_Updated_By
	,Last_Update_Date
	,Last_Update_Login)
       VALUES
       ( p_org_id
        ,x_revenue_class_id
        ,p_name
        ,p_DESCRIPTION
        ,p_liability_account_id
        ,p_expense_account_id
        ,1
	,p_Created_By
	,p_Creation_Date
	,p_Last_Updated_By
	,p_Last_Update_Date
	,p_Last_Update_Login
	);

Line: 96

   END Insert_row;

Line: 104

PROCEDURE update_row
    (p_revenue_class_id         NUMBER
    ,p_name                     VARCHAR2
    ,p_description              VARCHAR2
    ,p_liability_account_id     NUMBER
    ,p_expense_account_id       NUMBER
    ,p_object_version_number    NUMBER
    ,p_Last_Updated_By          NUMBER
    ,p_Last_Update_Date         DATE
    ,p_Last_Update_Login        NUMBER ) IS


   l_revenue_class_id          cn_revenue_classes.revenue_class_id%TYPE;

Line: 123

	  SELECT *
	    FROM cn_revenue_classes
	    WHERE revenue_class_id = p_revenue_class_id
	    FOR UPDATE of revenue_class_id NOWAIT;

Line: 135

      fnd_message.Set_Name('FND', 'FORM_RECORD_DELETED');

Line: 141

   SELECT decode(p_revenue_class_id,
	     fnd_api.g_miss_num, oldrow.revenue_class_id,
	     p_revenue_class_id),
      decode(p_name,
	     fnd_api.g_miss_char, oldrow.name,
	     p_name),
      decode(p_description,
	     fnd_api.g_miss_char, oldrow.description,
	     p_description),
      decode(p_liability_account_id,
	     fnd_api.g_miss_num, oldrow.liability_account_id,
	     p_liability_account_id),
      decode(p_expense_account_id,
	     fnd_api.g_miss_num, oldrow.expense_account_id,
	     p_expense_account_id)
     INTO
      l_revenue_class_id,
      l_name             ,
      l_description      ,
      l_liability_account_id,
      l_expense_account_id
      FROM dual;

Line: 169

    UPDATE cn_revenue_classes
      SET
      revenue_class_id          =       l_revenue_class_id,
      object_version_number     =       nvl(p_object_version_number,0) + 1,
      name                      =       l_name,
      description               =       l_description,
      liability_account_id      =       l_liability_account_id,
      expense_account_id        =       l_expense_account_id,
      last_update_date	        =	p_Last_Update_Date,
      last_updated_by      	=     	p_Last_Updated_By,
      last_update_login    	=     	p_Last_Update_Login
      WHERE revenue_class_id    =       p_revenue_class_id;

Line: 184

    UPDATE cn_hierarchy_nodes  chn
      SET chn.name = l_name
    WHERE chn.external_id = l_revenue_class_id
      AND chn.dim_hierarchy_id IN (
        select dh.dim_hierarchy_id
          from cn_dimensions d,
            cn_obj_tables_v t,
            cn_head_hierarchies h,
            cn_dim_hierarchies dh
      where d.source_table_id = t.table_id
        and d.dimension_id = h.dimension_id
        and h.head_hierarchy_id = dh.header_dim_hierarchy_id
        and t.name = 'CN_REVENUE_CLASSES');

Line: 200

  END Update_row;

Line: 208

  PROCEDURE Delete_row( p_revenue_class_id     NUMBER ) IS
  BEGIN

     DELETE FROM cn_revenue_classes
       WHERE  revenue_class_id  = p_revenue_class_id ;

Line: 217

  END Delete_row;