886:
887:
888:
889: /* Only Delete records from as_sales_lead_scorecards;
890: not delete records from as_sales_lead_card_rules;
891: */
892: Procedure Delete_ScoreCard (
893: p_api_version IN NUMBER := 2.0,
894: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
906: WHERE SCORECARD_ID = IN_SCORECARD_ID;
907: --
908: CURSOR C_GET_CARD_RULE (IN_SCORECARD_ID NUMBER) IS
909: SELECT CARD_RULE_ID
910: FROM AS_SALES_LEAD_CARD_RULES
911: WHERE SCORECARD_ID = IN_SCORECARD_ID;
912: --
913: l_api_name CONSTANT VARCHAR2(30) := 'Delete_ScoreCard';
914: l_api_version_number CONSTANT NUMBER := 2.0;