APPS.QP_DELAYED_REQUESTS_UTIL dependencies on QP_LIMITS

Line 1462: FROM QP_LIMITS

1458: BEGIN
1459:
1460: SELECT COUNT(*)
1461: INTO l_Organization_Count
1462: FROM QP_LIMITS
1463: WHERE (limit_id = p_Limit_Id) AND
1464: (UPPER(ORGANIZATION_FLAG) = 'Y');
1465:
1466: SELECT COUNT(*)

Line 1468: FROM QP_LIMITS

1464: (UPPER(ORGANIZATION_FLAG) = 'Y');
1465:
1466: SELECT COUNT(*)
1467: INTO l_Customer_Attr_Count
1468: FROM QP_LIMITS
1469: WHERE ((limit_id = p_Limit_Id) AND
1470: ((MULTIVAL_ATTR1_TYPE IS NOT NULL) OR
1471: (MULTIVAL_ATTR1_CONTEXT IS NOT NULL) OR
1472: (MULTIVAL_ATTRIBUTE1 IS NOT NULL) OR

Line 1477: FROM QP_LIMITS

1473: (MULTIVAL_ATTR1_DATATYPE IS NOT NULL)));
1474:
1475: SELECT COUNT(*)
1476: INTO l_Product_Attr_Count
1477: FROM QP_LIMITS
1478: WHERE ((limit_id = p_Limit_Id) AND
1479: ((MULTIVAL_ATTR2_TYPE IS NOT NULL) OR
1480: (MULTIVAL_ATTR2_CONTEXT IS NOT NULL) OR
1481: (MULTIVAL_ATTRIBUTE2 IS NOT NULL) OR

Line 1494: FROM QP_LIMITS

1490: l_Product_Attr_Count + l_Limit_Attrs_Count;
1491:
1492: SELECT COUNT(*)
1493: INTO l_dummy
1494: FROM QP_LIMITS
1495: WHERE limit_id = p_Limit_Id;
1496:
1497: IF l_dummy > 0 -- LIMIT EXISTS
1498: THEN

Line 1502: UPDATE QP_LIMITS

1498: THEN
1499: IF (l_Organization_Count > 0) OR (l_Customer_Attr_Count > 0)
1500: OR (l_Product_Attr_Count > 0)
1501: THEN
1502: UPDATE QP_LIMITS
1503: SET EACH_ATTR_EXISTS = 'Y'
1504: WHERE limit_id = p_Limit_Id;
1505: ELSE
1506: UPDATE QP_LIMITS

Line 1506: UPDATE QP_LIMITS

1502: UPDATE QP_LIMITS
1503: SET EACH_ATTR_EXISTS = 'Y'
1504: WHERE limit_id = p_Limit_Id;
1505: ELSE
1506: UPDATE QP_LIMITS
1507: SET EACH_ATTR_EXISTS = 'N'
1508: WHERE limit_id = p_Limit_Id;
1509: END IF;
1510:

Line 1511: UPDATE QP_LIMITS

1507: SET EACH_ATTR_EXISTS = 'N'
1508: WHERE limit_id = p_Limit_Id;
1509: END IF;
1510:
1511: UPDATE QP_LIMITS
1512: SET NON_EACH_ATTR_COUNT = l_Limit_Attrs_Count
1513: WHERE limit_id = p_Limit_Id;
1514:
1515: UPDATE QP_LIMITS

Line 1515: UPDATE QP_LIMITS

1511: UPDATE QP_LIMITS
1512: SET NON_EACH_ATTR_COUNT = l_Limit_Attrs_Count
1513: WHERE limit_id = p_Limit_Id;
1514:
1515: UPDATE QP_LIMITS
1516: SET TOTAL_ATTR_COUNT = l_Total_Attr_Count
1517: WHERE limit_id = p_Limit_Id;
1518: END IF;
1519: