DBA Data[Home] [Help]

APPS.CN_SCA_CRRULEATTR_PVT SQL Statements

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

Line: 274

L_LAST_UPDATE_DATE          DATE    := sysdate;
Line: 275

L_LAST_UPDATED_BY           NUMBER  := fnd_global.user_id;
Line: 278

L_LAST_UPDATE_LOGIN         NUMBER  := fnd_global.login_id;
Line: 348

SELECT count(*) into l_count from cn_sca_rule_attributes where
   TRANSACTION_SOURCE = l_credit_rule_attr_rec.transaction_source
   and ORG_ID = p_org_id     -- MOAC Change
   and ( SRC_COLUMN_NAME = l_credit_rule_attr_rec.destination_column OR upper(USER_COLUMN_NAME) = upper(trim(l_credit_rule_attr_rec.user_name)));
Line: 365

SELECT cn_sca_rule_attributes_s.nextval INTO l_sca_rule_attribute_id FROM sys.dual;
Line: 369

CN_SCA_CRRULEATTR_PKG.INSERT_ROW(

	 x_Rowid                       => L_ROWID,
         x_org_id                      => p_org_id,     -- MOAC Change
	 x_sca_rule_attribute_id       => l_sca_rule_attribute_id,
	 X_TRANSACTION_SOURCE            => l_credit_rule_attr_rec.transaction_source,
	 X_SRC_COLUMN_NAME     	 => l_credit_rule_attr_rec.destination_column,
	 X_DATATYPE                   => l_credit_rule_attr_rec.data_type,
	 X_VALUE_SET_ID		 => l_value_set_id,
	 X_TRX_SRC_COLUMN_NAME         => l_credit_rule_attr_rec.source_column,
	 X_ENABLED_FLAG         	 => l_credit_rule_attr_rec.enable_flag,
	 x_attribute_category    	 => l_credit_rule_attr_rec.attribute_category,
	 x_attribute1            	 => l_credit_rule_attr_rec.attribute1,
	 x_attribute2                  => l_credit_rule_attr_rec.attribute2,
	 x_attribute3                  => l_credit_rule_attr_rec.attribute3,
	 x_attribute4                  => l_credit_rule_attr_rec.attribute4,
	 x_attribute5                  => l_credit_rule_attr_rec.attribute5,
	 x_attribute6                  => l_credit_rule_attr_rec.attribute6,
	 x_attribute7                  => l_credit_rule_attr_rec.attribute7,
	 x_attribute8                  => l_credit_rule_attr_rec.attribute8,
	 x_attribute9                  => l_credit_rule_attr_rec.attribute9,
	 x_attribute10                 => l_credit_rule_attr_rec.attribute10,
	 x_attribute11                 => l_credit_rule_attr_rec.attribute11,
	 x_attribute12                 => l_credit_rule_attr_rec.attribute12,
	 x_attribute13                 => l_credit_rule_attr_rec.attribute13,
	 x_attribute14                 => l_credit_rule_attr_rec.attribute14,
	 x_attribute15                 => l_credit_rule_attr_rec.attribute15,
	 X_OBJECT_VERSION_NUMBER       =>  l_credit_rule_attr_rec.Object_Version_Number,
         X_SECURITY_GROUP_ID           => L_SECURITY_GROUP_ID,
         X_USER_COLUMN_NAME   	      => l_credit_rule_attr_rec.user_name,
 	 x_Creation_Date               => l_creation_date,
 	 x_Created_By                  => l_created_by,
	 x_Last_Update_Date            => l_last_update_date,
	 x_Last_Updated_By             => l_last_updated_by,
	 x_Last_Update_Login           => l_last_update_login
	 	);
Line: 407

  UPDATE cn_repositories
  SET sca_mapping_status = 'UNSYNC'
  WHERE org_id = p_org_id;  -- MOAC Change
Line: 475

PROCEDURE  Update_Credit_RuleAttr  (
     p_api_version                 IN NUMBER,
     p_init_msg_list               IN VARCHAR2 ,
     p_commit                    IN VARCHAR2,
     p_valdiation_level    IN VARCHAR2,
     p_org_id                      IN  cn_sca_rule_attributes.org_id%TYPE, -- MOAC Change
     p_credit_rule_attr_rec            IN  credit_rule_attr_rec,
--     p_old_credit_rule_attr_rec            IN  credit_rule_attr_rec,
     x_return_status               OUT NOCOPY VARCHAR2,
     x_msg_count                   OUT NOCOPY NUMBER,
     x_msg_data                    OUT NOCOPY VARCHAR2
     ) IS
L_PKG_NAME                  CONSTANT VARCHAR2(30) := 'CN_SCA_CRRULEATTR_PVT';
Line: 488

L_LAST_UPDATE_DATE          DATE    := sysdate;
Line: 489

L_LAST_UPDATED_BY           NUMBER  := fnd_global.user_id;
Line: 492

L_LAST_UPDATE_LOGIN         NUMBER  := fnd_global.login_id;
Line: 497

   l_api_name		CONSTANT VARCHAR2(30)  := 'Update_Credit_RuleAttr';
Line: 524

   SAVEPOINT    Update_Credit_RuleAttr;
Line: 548

 SELECT object_version_number  -- ,sca_rule_attribute_id
   INTO l_old_ovn              -- ,l_sca_rule_attribute_id
   FROM cn_sca_rule_attributes
   WHERE SCA_RULE_ATTRIBUTE_ID = l_credit_rule_attr_rec.sca_rule_attribute_id
     AND ORG_ID = p_org_id;  -- MOAC Change
Line: 588

  SELECT count(1) into l_count2
  FROM CN_SCA_CONDITIONS
  WHERE SCA_RULE_ATTRIBUTE_ID= l_credit_rule_attr_rec.sca_rule_attribute_id
    AND ORG_ID = p_org_id; -- MOAC Change
Line: 594

   CN_SCA_CRRULEATTR_PKG.DELETE_ROW(
      X_ORG_ID                    => p_org_id,  -- MOAC Change
      X_SCA_RULE_ATTRIBUTE_ID     => l_credit_rule_attr_rec.sca_rule_attribute_id)    ;
Line: 599

   update cn_repositories
      set sca_mapping_status = 'UNSYNC'
    where org_id = p_org_id;   -- MOAC Change
Line: 619

SELECT count(sca_rule_attribute_id) into l_count from cn_sca_rule_attributes where
   TRANSACTION_SOURCE = l_credit_rule_attr_rec.transaction_source
   and org_id = p_org_id -- MOAC Change
   and upper(USER_COLUMN_NAME) = upper(trim(l_credit_rule_attr_rec.user_name));
Line: 638

SELECT count(1) into l_count2 FROM CN_SCA_CONDITIONS WHERE
    SCA_RULE_ATTRIBUTE_ID= l_credit_rule_attr_rec.sca_rule_attribute_id
    and org_id = p_org_id;  -- MOAC Change
Line: 644

select trx_src_column_name
into l_trx_source_column
from cn_sca_rule_attributes
where sca_rule_attribute_id = l_credit_rule_attr_rec.sca_rule_attribute_id
  and org_id = p_org_id; -- MOAC Change
Line: 650

CN_SCA_CRRULEATTR_PKG.UPDATE_ROW(
         x_org_id                      => p_org_id,  -- MOAC Change
         x_sca_rule_attribute_id       => l_credit_rule_attr_rec.sca_rule_attribute_id,
         X_TRANSACTION_SOURCE            => l_credit_rule_attr_rec.transaction_source,
	 X_SRC_COLUMN_NAME     	 => l_credit_rule_attr_rec.destination_column,
	 X_DATATYPE                   => l_credit_rule_attr_rec.data_type,
	 X_VALUE_SET_ID		 => l_value_set_id,
	 X_TRX_SRC_COLUMN_NAME         => l_credit_rule_attr_rec.source_column,
	 X_ENABLED_FLAG         	 => l_credit_rule_attr_rec.enable_flag,
	 x_attribute_category    	 => l_credit_rule_attr_rec.attribute_category,
	 x_attribute1            	 => l_credit_rule_attr_rec.attribute1,
	 x_attribute2                  => l_credit_rule_attr_rec.attribute2,
	 x_attribute3                  => l_credit_rule_attr_rec.attribute3,
	 x_attribute4                  => l_credit_rule_attr_rec.attribute4,
	 x_attribute5                  => l_credit_rule_attr_rec.attribute5,
	 x_attribute6                  => l_credit_rule_attr_rec.attribute6,
	 x_attribute7                  => l_credit_rule_attr_rec.attribute7,
	 x_attribute8                  => l_credit_rule_attr_rec.attribute8,
	 x_attribute9                  => l_credit_rule_attr_rec.attribute9,
	 x_attribute10                 => l_credit_rule_attr_rec.attribute10,
	 x_attribute11                 => l_credit_rule_attr_rec.attribute11,
	 x_attribute12                 => l_credit_rule_attr_rec.attribute12,
	 x_attribute13                 => l_credit_rule_attr_rec.attribute13,
	 x_attribute14                 => l_credit_rule_attr_rec.attribute14,
	 x_attribute15                 => l_credit_rule_attr_rec.attribute15,
	 X_OBJECT_VERSION_NUMBER       =>  l_credit_rule_attr_rec.Object_Version_Number,
         X_SECURITY_GROUP_ID           => L_SECURITY_GROUP_ID ,
         X_USER_COLUMN_NAME   	      => l_credit_rule_attr_rec.user_name,
 	 x_Last_Update_Date            => l_last_update_date,
	 x_Last_Updated_By             => l_last_updated_by,
	 x_Last_Update_Login           => l_last_update_login

	);
Line: 687

   update cn_repositories
      set sca_mapping_status = 'UNSYNC'
    where org_id = p_org_id;
Line: 723

      ROLLBACK TO Update_Credit_RuleAttr;
Line: 732

      ROLLBACK TO Update_Credit_RuleAttr;
Line: 742

      ROLLBACK TO Update_Credit_RuleAttr;
Line: 755

END Update_Credit_RuleAttr;
Line: 769

L_LAST_UPDATE_DATE          DATE    := sysdate;
Line: 770

L_LAST_UPDATED_BY           NUMBER  := fnd_global.user_id;
Line: 773

L_LAST_UPDATE_LOGIN         NUMBER  := fnd_global.login_id;
Line: 814

 SELECT count(*) into l_count
   FROM CN_SCA_RULE_ATTRIBUTES
  WHERE TRANSACTION_SOURCE='CN'
    AND ORG_ID = p_org_id; -- MOAC Change
Line: 849

   update cn_repositories
     set sca_mapping_status='GENERATED'
     WHERE org_id = p_org_id; -- MOAC Change