APPS.AS_SCORECARD_RULES_PVT dependencies on AS_SALES_LEAD_SCORECARDS

Line 432: SELECT AS_SALES_LEAD_SCORECARDS_S.NEXTVAL

428: := AS_SCORECARD_RULES_PUB.G_MISS_SCORECARD_REC,
429: X_SCORECARD_ID OUT NOCOPY NUMBER)
430: IS
431: CURSOR C_GET_SCORECARD_ID IS
432: SELECT AS_SALES_LEAD_SCORECARDS_S.NEXTVAL
433: FROM DUAL;
434: --
435: l_api_name CONSTANT VARCHAR2(30) := 'Create_ScoreCard';
436: l_api_version_number CONSTANT NUMBER := 2.0;

Line 516: AS_SALES_LEAD_SCORECARDS_PKG.Insert_Row(

512:
513: else -- valid Start and End Dates for the scorecard
514:
515: -- Invoke table handler(Sales_Lead_Insert_Row)
516: AS_SALES_LEAD_SCORECARDS_PKG.Insert_Row(
517: x_rowid => l_rowid
518: , x_scorecard_id => l_scorecard_id
519: , x_last_update_date => SYSDATE
520: , x_last_updated_by => FND_GLOBAL.USER_ID

Line 615: FROM AS_SALES_LEAD_SCORECARDS

611: DESCRIPTION,
612: ENABLED_FLAG,
613: START_DATE_ACTIVE,
614: END_DATE_ACTIVE
615: FROM AS_SALES_LEAD_SCORECARDS
616: WHERE SCORECARD_ID = IN_SCORECARD_ID
617: FOR UPDATE NOWAIT;
618:
619: CURSOR C_CHK_SCORECARD_FOR_DISABLE (IN_SCORECARD_ID NUMBER) IS

Line 819: AS_SALES_LEAD_SCORECARDS_PKG.Update_Row(

815: Close C_Chk_Scorecard_for_Disable;
816: END IF;
817:
818: -- Invoke table handler(Sales_Lead_ScoreCard_Update_Row)
819: AS_SALES_LEAD_SCORECARDS_PKG.Update_Row(
820: x_rowid => l_rowid
821: , x_scorecard_id => l_SALES_LEAD_SCORECARD_rec.scorecard_id
822: , x_last_update_date => SYSDATE
823: , x_last_updated_by => FND_GLOBAL.USER_ID

Line 889: /* Only Delete records from as_sales_lead_scorecards;

885: END Update_ScoreCard;
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,

Line 905: FROM AS_SALES_LEAD_SCORECARDS

901: IS
902: CURSOR C_GET_LEAD_SCORECARD (IN_SCORECARD_ID NUMBER) IS
903: SELECT
904: SCORECARD_ID
905: FROM AS_SALES_LEAD_SCORECARDS
906: WHERE SCORECARD_ID = IN_SCORECARD_ID;
907: --
908: CURSOR C_GET_CARD_RULE (IN_SCORECARD_ID NUMBER) IS
909: SELECT CARD_RULE_ID

Line 987: AS_SALES_LEAD_SCORECARDS_PKG.Delete_Row(

983: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
984: 'Calling _SCORECARD_Delete_Row');
985:
986: -- Invoke table handler
987: AS_SALES_LEAD_SCORECARDS_PKG.Delete_Row(
988: x_scorecard_ID => l_SCORECARD_ID);
989:
990: --
991: -- End of API body