APPS.AS_SCORECARD_RULES_PVT dependencies on AS_CARD_RULE_QUAL_VALUES

Line 1054: SELECT AS_CARD_RULE_QUAL_VALUES_S.NEXTVAL

1050: p_CardRule_Qual_rec IN AS_SCORECARD_RULES_PUB.CARDRULE_QUAL_REC_TYPE,
1051: x_qual_value_id OUT NOCOPY NUMBER)
1052: IS
1053: CURSOR C_GET_QUAL_VALUE_ID IS
1054: SELECT AS_CARD_RULE_QUAL_VALUES_S.NEXTVAL
1055: FROM DUAL;
1056:
1057: l_api_name CONSTANT VARCHAR2(30) := 'Create_CardRule_QUAL';
1058: l_api_version_number CONSTANT NUMBER := 2.0;

Line 1139: AS_CARD_RULE_QUAL_VALUES_PKG.Insert_Row(

1135: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
1136: 'Calling CARDRULE_QUAL_Insert_Row');
1137:
1138: -- Invoke table handler(CARDRULE_QUAL_Insert_Row)
1139: AS_CARD_RULE_QUAL_VALUES_PKG.Insert_Row(
1140: x_rowid => l_rowid
1141: , x_qual_value_id => l_qual_value_id
1142: , x_last_update_date => SYSDATE
1143: , x_last_updated_by => FND_GLOBAL.USER_ID

Line 1241: FROM AS_CARD_RULE_QUAL_VALUES

1237: CURSOR C_GET_CARDRULE_QUAL (IN_QUAL_VALUE_ID NUMBER) IS
1238: SELECT
1239: rowid,
1240: QUAL_VALUE_ID
1241: FROM AS_CARD_RULE_QUAL_VALUES
1242: WHERE QUAL_VALUE_ID = IN_QUAL_VALUE_ID
1243: FOR UPDATE NOWAIT;
1244: --
1245: l_api_name CONSTANT VARCHAR2(30) := 'Update_CARDRULE_QUAL';

Line 1409: AS_CARD_RULE_QUAL_VALUES_PKG.Update_Row(

1405: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
1406: 'Calling _CARDRULE_QUAL_Update_Row');
1407:
1408: -- Invoke table handler(CARDRULE_QUAL_Update_Row)
1409: AS_CARD_RULE_QUAL_VALUES_PKG.Update_Row(
1410: x_rowid => l_rowid
1411: , x_qual_value_id => l_CARDRULE_QUAL_rec.qual_value_id
1412: , x_last_update_date => SYSDATE
1413: , x_last_updated_by => FND_GLOBAL.USER_ID

Line 1504: FROM AS_CARD_RULE_QUAL_VALUES

1500: IS
1501: CURSOR C_GET_CARDRULE_QUAL (IN_QUAL_VALUE_ID NUMBER) IS
1502: SELECT
1503: QUAL_VALUE_ID
1504: FROM AS_CARD_RULE_QUAL_VALUES
1505: WHERE QUAL_VALUE_ID = IN_QUAL_VALUE_ID
1506: FOR UPDATE NOWAIT;
1507: --
1508: l_api_name CONSTANT VARCHAR2(30) := 'Delete_CARDRULE_QUAL';

Line 1581: AS_CARD_RULE_QUAL_VALUES_PKG.Delete_Row(

1577: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
1578: 'Calling _CARDRULE_QUAL_Delete_Row');
1579:
1580: -- Invoke table handler
1581: AS_CARD_RULE_QUAL_VALUES_PKG.Delete_Row(
1582: x_QUAL_VALUE_ID => l_QUAL_VALUE_ID);
1583:
1584: --
1585: -- End of API body