APPS.CN_RULEATTRIBUTE_PUB SQL Statements

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

Line: 7

G_LAST_UPDATE_DATE     DATE 		     := Sysdate;

Line: 8

G_LAST_UPDATED_BY      NUMBER 		     := fnd_global.user_id;

Line: 11

G_LAST_UPDATE_LOGIN    NUMBER		     := fnd_global.login_id;

Line: 69

     SELECT rule_id
       FROM cn_rules
       WHERE ruleset_id = p_ruleset_id
       AND name = p_ruleattribute_rec.rule_name
       AND org_id=p_org_id;

Line: 102

   x_loading_status := 'CN_INSERTED';

Line: 226

   SELECT object_id
     INTO l_object_id
     FROM cn_objects
     WHERE name = l_RuleAttribute_rec.object_name
     AND table_id = -11803 and
     org_id=l_RuleAttribute_rec.org_id;

Line: 233

   SELECT cn_attribute_rules_s.NEXTVAL
     INTO l_ruleattribute_rec_pvt.attribute_rule_id
     FROM dual;

Line: 237

   SELECT count(1)
     INTO l_count
     FROM cn_rulesets
     WHERE name = l_ruleattribute_rec.ruleset_name
     AND start_date = l_ruleattribute_rec.start_date
     AND end_date = l_ruleattribute_rec.end_date
     and org_id=l_RuleAttribute_rec.org_id;

Line: 256

      SELECT ruleset_id
	INTO l_ruleattribute_rec_pvt.ruleset_id
	FROM cn_rulesets
	WHERE name = l_ruleattribute_rec.ruleset_name
	AND start_date = l_ruleattribute_rec.start_date
	AND end_date = l_ruleattribute_rec.end_date and
	org_id=l_RuleAttribute_rec.org_id;

Line: 503

PROCEDURE Update_RuleAttribute
( p_api_version           	IN	NUMBER,
  p_init_msg_list		IN	VARCHAR2 := FND_API.G_FALSE,
  p_commit	    		IN  	VARCHAR2 := FND_API.G_FALSE,
  p_validation_level		IN  	NUMBER	 := FND_API.G_VALID_LEVEL_FULL,
  x_return_status	 OUT NOCOPY VARCHAR2,
  x_msg_count		 OUT NOCOPY NUMBER,
  x_msg_data		 OUT NOCOPY VARCHAR2,
  x_loading_status              OUT NOCOPY     VARCHAR2,
  p_old_RuleAttribute_rec   	IN      CN_RuleAttribute_PUB.RuleAttribute_rec_type,
  p_RuleAttribute_rec       	IN      CN_RuleAttribute_PUB.RuleAttribute_rec_type
) IS

       l_api_name		CONSTANT VARCHAR2(30)	:= 'Update_RuleAttribute';

Line: 537

     SELECT rule_id
       FROM cn_rules
       WHERE ruleset_id = p_ruleset_id
       AND name = p_rule_name and
       org_id=p_org_id;

Line: 547

	SELECT attribute_rule_id
	  FROM cn_attribute_rules
	  WHERE rule_id = p_rule_id
	  AND column_id = p_column_id and
	  org_id=p_org_id;

Line: 556

   SAVEPOINT Update_RuleAttribute;

Line: 574

   x_loading_status := 'CN_UPDATED';

Line: 590

				'UPDATE_RULEATTRIBUTE',
				'B',
				'C')
   THEN
     cn_ruleattribute_pub_cuhk.update_ruleattribute_pre
     (p_api_version           	=> p_api_version,
      p_init_msg_list           => p_init_msg_list,
      p_commit	    		=> p_commit,
      p_validation_level	=> p_validation_level,
      x_return_status		=> x_return_status,
      x_msg_count		=> x_msg_count,
      x_msg_data		=> x_msg_data,
      x_loading_status          => x_loading_status,
      p_ruleattribute_rec       => l_ruleattribute_rec,
      p_old_RuleAttribute_rec   => l_old_RuleAttribute_rec);

Line: 617

				'UPDATE_RULEATTRIBUTE',
				'B',
				'V')
   THEN
     cn_ruleattribute_pub_vuhk.update_ruleattribute_pre
    (p_api_version           	=> p_api_version,
      p_init_msg_list           => p_init_msg_list,
      p_commit	    		=> p_commit,
      p_validation_level	=> p_validation_level,
      x_return_status		=> x_return_status,
      x_msg_count		=> x_msg_count,
      x_msg_data		=> x_msg_data,
      x_loading_status          => x_loading_status,
      p_ruleattribute_rec       => l_ruleattribute_rec,
      p_old_RuleAttribute_rec   => l_old_RuleAttribute_rec);

Line: 759

   SELECT object_id
     INTO l_old_object_id
     FROM cn_objects
     WHERE name = l_old_RuleAttribute_rec.object_name
     AND table_id = -11803;

Line: 766

   SELECT object_id
     INTO l_object_id
     FROM cn_objects
     WHERE name = l_RuleAttribute_rec.object_name
     AND table_id = -11803;

Line: 774

   SELECT count(1)
     INTO l_count
     FROM cn_rulesets
     WHERE name = l_ruleattribute_rec.ruleset_name
     AND start_date = l_ruleattribute_rec.start_date
     AND end_date = l_ruleattribute_rec.end_date;

Line: 792

      SELECT ruleset_id
	INTO l_ruleattribute_rec_pvt.ruleset_id
	FROM cn_rulesets
	WHERE name = l_ruleattribute_rec.ruleset_name
	AND start_date = l_ruleattribute_rec.start_date
	AND end_date = l_ruleattribute_rec.end_date;

Line: 802

   SELECT count(1)
     INTO l_count
     FROM cn_rulesets
     WHERE name = l_old_ruleattribute_rec.ruleset_name
     AND start_date = l_old_ruleattribute_rec.start_date
     AND end_date = l_old_ruleattribute_rec.end_date;

Line: 820

      SELECT ruleset_id
	INTO l_old_ruleattribute_rec_pvt.ruleset_id
	FROM cn_rulesets
	WHERE name = l_old_ruleattribute_rec.ruleset_name
	AND start_date = l_old_ruleattribute_rec.start_date
	AND end_date = l_old_ruleattribute_rec.end_date and
	org_id=l_old_ruleattribute_rec.org_id;

Line: 853

	-- giving error as multiple records are found with a single select below

	/*
	SELECT attribute_rule_id
	  INTO l_ruleattribute_rec_pvt.attribute_rule_id
	  FROM cn_attribute_rules
	  WHERE rule_id = i.rule_id
	  AND column_id = l_object_id;

Line: 862

	SELECT attribute_rule_id
	  INTO l_old_ruleattribute_rec_pvt.attribute_rule_id
	  FROM cn_attribute_rules
	  WHERE rule_id = i.rule_id
	  AND column_id = l_old_object_id;

Line: 874

	cn_ruleattribute_pvt.update_ruleattribute
	  (p_api_version           	=> p_api_version,
	   p_init_msg_list              => p_init_msg_list,
	   p_commit	    		=> p_commit,
	   p_validation_level     	=> p_validation_level,
	   x_return_status		=> x_return_status,
	   x_msg_count		        => x_msg_count,
	   x_msg_data		        => x_msg_data,
	   x_loading_status             => x_loading_status,
	   p_ruleattribute_rec          => l_ruleattribute_rec_pvt,
	   p_old_ruleattribute_rec      => l_old_ruleattribute_rec_pvt);

Line: 908

				'UPDATE_RULEATTRIBUTE',
				'A',
				'V')
   THEN
     cn_ruleattribute_pub_vuhk.update_ruleattribute_post
    (p_api_version           	=> p_api_version,
      p_init_msg_list           => p_init_msg_list,
      p_commit	    		=> p_commit,
      p_validation_level	=> p_validation_level,
      x_return_status		=> x_return_status,
      x_msg_count		=> x_msg_count,
      x_msg_data		=> x_msg_data,
      x_loading_status          => x_loading_status,
      p_ruleattribute_rec       => l_ruleattribute_rec,
      p_old_RuleAttribute_rec   => l_old_RuleAttribute_rec);

Line: 936

				'UPDATE_RULEATTRIBUTE',
				'A',
				'C')
   THEN
     cn_ruleattribute_pub_cuhk.update_ruleattribute_post
     (p_api_version           	=> p_api_version,
      p_init_msg_list           => p_init_msg_list,
      p_commit	    		=> p_commit,
      p_validation_level	=> p_validation_level,
      x_return_status		=> x_return_status,
      x_msg_count		=> x_msg_count,
      x_msg_data		=> x_msg_data,
      x_loading_status          => x_loading_status,
      p_ruleattribute_rec       => l_ruleattribute_rec,
      p_old_RuleAttribute_rec   => l_old_RuleAttribute_rec);

Line: 965

				'UPDATE_RULEATTRIBUTE',
				'M',
				'M')
     THEN
      IF  cn_ruleattribute_pub_cuhk.ok_to_generate_msg
	 (p_ruleattribute_rec     => l_ruleattribute_rec)
	THEN
	 -- Clear bind variables
--	 XMLGEN.clearBindValues;

Line: 1036

      ROLLBACK TO Update_RuleAttribute;

Line: 1044

      ROLLBACK TO Update_RuleAttribute;

Line: 1053

      ROLLBACK TO Update_RuleAttribute;

Line: 1110

PROCEDURE Delete_RuleAttribute
( p_api_version           	IN	NUMBER,
  p_init_msg_list		IN	VARCHAR2 := FND_API.G_FALSE,
  p_commit	    		IN  	VARCHAR2 := FND_API.G_FALSE,
  p_validation_level		IN  	NUMBER	 := FND_API.G_VALID_LEVEL_FULL,
  x_return_status	 OUT NOCOPY VARCHAR2,
  x_msg_count		 OUT NOCOPY NUMBER,
  x_msg_data		 OUT NOCOPY VARCHAR2,
  x_loading_status              OUT NOCOPY     VARCHAR2,
  p_ruleattribute_rec   	IN	CN_RuleAttribute_PUB.ruleattribute_rec_type
) IS


  l_api_name			CONSTANT VARCHAR2(30)	:= 'Delete_RuleAttribute';

Line: 1133

	SELECT rule_id
	  FROM cn_rules
	  WHERE ruleset_id = p_ruleset_id
	  AND name = p_rule_name
	  AND org_id = p_org_id;

Line: 1142

	SELECT attribute_rule_id,object_version_number
	  FROM cn_attribute_rules
	  WHERE rule_id = p_rule_id
	  AND column_id = p_column_id
	  AND org_id = p_org_id;

Line: 1159

  SAVEPOINT Delete_RuleAttribute;

Line: 1191

				'DELETE_RULEATTRIBUTE',
				'B',
				'C')
   THEN
     cn_ruleattribute_pub_cuhk.delete_ruleattribute_pre
     (p_api_version           	=> p_api_version,
      p_init_msg_list           => p_init_msg_list,
      p_commit	    		=> p_commit,
      p_validation_level	=> p_validation_level,
      x_return_status		=> x_return_status,
      x_msg_count		=> x_msg_count,
      x_msg_data		=> x_msg_data,
      x_loading_status          => x_loading_status,
      p_ruleattribute_rec       => l_ruleattribute_rec);

Line: 1217

				'DELETE_RULEATTRIBUTE',
				'B',
				'V')
   THEN
     cn_ruleattribute_pub_vuhk.delete_ruleattribute_pre
     (p_api_version           	=> p_api_version,
      p_init_msg_list           => p_init_msg_list,
      p_commit	    		=> p_commit,
      p_validation_level	=> p_validation_level,
      x_return_status		=> x_return_status,
      x_msg_count		=> x_msg_count,
      x_msg_data		=> x_msg_data,
      x_loading_status          => x_loading_status,
      p_ruleattribute_rec       => l_ruleattribute_rec);

Line: 1301

   SELECT object_id
     INTO l_object_id
     FROM cn_objects
     WHERE name = l_RuleAttribute_rec.object_name
     AND table_id = -11803
     and org_id = l_RuleAttribute_rec.org_id;

Line: 1310

   SELECT count(1)
     INTO l_count
     FROM cn_rulesets
     WHERE name = l_ruleattribute_rec.ruleset_name
     AND start_date = l_ruleattribute_rec.start_date
     AND end_date = l_ruleattribute_rec.end_date;

Line: 1328

      SELECT ruleset_id
	INTO l_ruleattribute_rec_pvt.ruleset_id
	FROM cn_rulesets
	WHERE name = l_ruleattribute_rec.ruleset_name
	AND start_date = l_ruleattribute_rec.start_date
	AND end_date = l_ruleattribute_rec.end_date;

Line: 1350

	-- giving error as multiple records are found with a single select below

     /*
	SELECT attribute_rule_id
	  INTO l_ruleattribute_rec_pvt.attribute_rule_id
	  FROM cn_attribute_rules
	  WHERE rule_id = i.rule_id
	  AND column_id = l_object_id;

Line: 1364

	cn_ruleattribute_pvt.delete_ruleattribute
	  (p_api_version           	=> p_api_version,
	   p_init_msg_list              => p_init_msg_list,
	   p_commit	    		=> p_commit,
	   p_validation_level     	=> p_validation_level,
	   x_return_status		=> x_return_status,
	   x_msg_count		        => x_msg_count,
	   x_msg_data		        => x_msg_data,
	   x_loading_status             => x_loading_status,
	   p_ruleset_id                 => l_ruleattribute_rec_pvt.ruleset_id,
	   p_rule_id                    => l_ruleattribute_rec_pvt.rule_id,
	   p_object_version_number      => l_ruleattribute_rec_pvt.object_version_number,
	   p_attribute_rule_id          => l_ruleattribute_rec_pvt.attribute_rule_id);

Line: 1401

				'DELETE_RULEATTRIBUTE',
				'A',
				'V')
   THEN
     cn_ruleattribute_pub_vuhk.delete_ruleattribute_pre
     (p_api_version           	=> p_api_version,
      p_init_msg_list           => p_init_msg_list,
      p_commit	    		=> p_commit,
      p_validation_level	=> p_validation_level,
      x_return_status		=> x_return_status,
      x_msg_count		=> x_msg_count,
      x_msg_data		=> x_msg_data,
      x_loading_status          => x_loading_status,
      p_ruleattribute_rec       => l_ruleattribute_rec);

Line: 1427

				'DELETE_RULEATTRIBUTE',
				'A',
				'C')
   THEN
     cn_ruleattribute_pub_cuhk.delete_ruleattribute_pre
     (p_api_version           	=> p_api_version,
      p_init_msg_list           => p_init_msg_list,
      p_commit	    		=> p_commit,
      p_validation_level	=> p_validation_level,
      x_return_status		=> x_return_status,
      x_msg_count		=> x_msg_count,
      x_msg_data		=> x_msg_data,
      x_loading_status          => x_loading_status,
      p_ruleattribute_rec       => l_ruleattribute_rec);

Line: 1453

				'DELETE_RULEATTRIBUTE',
				'M',
				'M')
     THEN
      IF  cn_ruleattribute_pub_cuhk.ok_to_generate_msg
	 (p_ruleattribute_rec => l_ruleattribute_rec)
	THEN
	 -- Clear bind variables
--	 XMLGEN.clearBindValues;

Line: 1524

		ROLLBACK TO Delete_RuleAttribute;

Line: 1531

		ROLLBACK TO Delete_RuleAttribute;

Line: 1540

		ROLLBACK TO Delete_RuleAttribute;