APPS.QP_DELAYED_REQUESTS_UTIL dependencies on QP_LIMITS

Line 1470: FROM QP_LIMITS

1466: BEGIN
1467:
1468: SELECT COUNT(*)
1469: INTO l_Organization_Count
1470: FROM QP_LIMITS
1471: WHERE (limit_id = p_Limit_Id) AND
1472: (UPPER(ORGANIZATION_FLAG) = 'Y');
1473:
1474: SELECT COUNT(*)

Line 1476: FROM QP_LIMITS

1472: (UPPER(ORGANIZATION_FLAG) = 'Y');
1473:
1474: SELECT COUNT(*)
1475: INTO l_Customer_Attr_Count
1476: FROM QP_LIMITS
1477: WHERE ((limit_id = p_Limit_Id) AND
1478: ((MULTIVAL_ATTR1_TYPE IS NOT NULL) OR
1479: (MULTIVAL_ATTR1_CONTEXT IS NOT NULL) OR
1480: (MULTIVAL_ATTRIBUTE1 IS NOT NULL) OR

Line 1485: FROM QP_LIMITS

1481: (MULTIVAL_ATTR1_DATATYPE IS NOT NULL)));
1482:
1483: SELECT COUNT(*)
1484: INTO l_Product_Attr_Count
1485: FROM QP_LIMITS
1486: WHERE ((limit_id = p_Limit_Id) AND
1487: ((MULTIVAL_ATTR2_TYPE IS NOT NULL) OR
1488: (MULTIVAL_ATTR2_CONTEXT IS NOT NULL) OR
1489: (MULTIVAL_ATTRIBUTE2 IS NOT NULL) OR

Line 1502: FROM QP_LIMITS

1498: l_Product_Attr_Count + l_Limit_Attrs_Count;
1499:
1500: SELECT COUNT(*)
1501: INTO l_dummy
1502: FROM QP_LIMITS
1503: WHERE limit_id = p_Limit_Id;
1504:
1505: IF l_dummy > 0 -- LIMIT EXISTS
1506: THEN

Line 1510: UPDATE QP_LIMITS

1506: THEN
1507: IF (l_Organization_Count > 0) OR (l_Customer_Attr_Count > 0)
1508: OR (l_Product_Attr_Count > 0)
1509: THEN
1510: UPDATE QP_LIMITS
1511: SET EACH_ATTR_EXISTS = 'Y'
1512: WHERE limit_id = p_Limit_Id;
1513: ELSE
1514: UPDATE QP_LIMITS

Line 1514: UPDATE QP_LIMITS

1510: UPDATE QP_LIMITS
1511: SET EACH_ATTR_EXISTS = 'Y'
1512: WHERE limit_id = p_Limit_Id;
1513: ELSE
1514: UPDATE QP_LIMITS
1515: SET EACH_ATTR_EXISTS = 'N'
1516: WHERE limit_id = p_Limit_Id;
1517: END IF;
1518:

Line 1519: UPDATE QP_LIMITS

1515: SET EACH_ATTR_EXISTS = 'N'
1516: WHERE limit_id = p_Limit_Id;
1517: END IF;
1518:
1519: UPDATE QP_LIMITS
1520: SET NON_EACH_ATTR_COUNT = l_Limit_Attrs_Count
1521: WHERE limit_id = p_Limit_Id;
1522:
1523: UPDATE QP_LIMITS

Line 1523: UPDATE QP_LIMITS

1519: UPDATE QP_LIMITS
1520: SET NON_EACH_ATTR_COUNT = l_Limit_Attrs_Count
1521: WHERE limit_id = p_Limit_Id;
1522:
1523: UPDATE QP_LIMITS
1524: SET TOTAL_ATTR_COUNT = l_Total_Attr_Count
1525: WHERE limit_id = p_Limit_Id;
1526: END IF;
1527: