DBA Data[Home] [Help]

APPS.CN_SCA_CRRULEATTR_PVT dependencies on CN_SCA_CRRULEATTR_PKG

Line 369: CN_SCA_CRRULEATTR_PKG.INSERT_ROW(

365: SELECT cn_sca_rule_attributes_s.nextval INTO l_sca_rule_attribute_id FROM sys.dual;
366: -- API body
367:
368:
369: CN_SCA_CRRULEATTR_PKG.INSERT_ROW(
370:
371: x_Rowid => L_ROWID,
372: x_org_id => p_org_id, -- MOAC Change
373: x_sca_rule_attribute_id => l_sca_rule_attribute_id,

Line 594: CN_SCA_CRRULEATTR_PKG.DELETE_ROW(

590: WHERE SCA_RULE_ATTRIBUTE_ID= l_credit_rule_attr_rec.sca_rule_attribute_id
591: AND ORG_ID = p_org_id; -- MOAC Change
592:
593: IF l_count2 = 0 THEN
594: CN_SCA_CRRULEATTR_PKG.DELETE_ROW(
595: X_ORG_ID => p_org_id, -- MOAC Change
596: X_SCA_RULE_ATTRIBUTE_ID => l_credit_rule_attr_rec.sca_rule_attribute_id) ;
597:
598: IF l_credit_rule_attr_rec.transaction_source = 'CN' THEN

Line 650: CN_SCA_CRRULEATTR_PKG.UPDATE_ROW(

646: from cn_sca_rule_attributes
647: where sca_rule_attribute_id = l_credit_rule_attr_rec.sca_rule_attribute_id
648: and org_id = p_org_id; -- MOAC Change
649:
650: CN_SCA_CRRULEATTR_PKG.UPDATE_ROW(
651: x_org_id => p_org_id, -- MOAC Change
652: x_sca_rule_attribute_id => l_credit_rule_attr_rec.sca_rule_attribute_id,
653: X_TRANSACTION_SOURCE => l_credit_rule_attr_rec.transaction_source,
654: X_SRC_COLUMN_NAME => l_credit_rule_attr_rec.destination_column,