DBA Data[Home] [Help]

APPS.WMS_RULE_GEN_PKGS dependencies on WMS_RULE_LIST_PACKAGE

Line 1671: FROM WMS_RULE_LIST_PACKAGE

1667: l_package_name_count NUMBER := NULL;
1668:
1669: cursor c1 is
1670: SELECT package_name_count
1671: FROM WMS_RULE_LIST_PACKAGE
1672: WHERE rule_type = p_rule_type for update;
1673:
1674: BEGIN
1675:

Line 1715: FROM WMS_RULE_LIST_PACKAGE

1711: l_package_name_count NUMBER := NULL;
1712:
1713: cursor c1 is
1714: SELECT package_name_count
1715: FROM WMS_RULE_LIST_PACKAGE
1716: WHERE rule_type = p_rule_type;
1717:
1718: BEGIN
1719:

Line 1747: UPDATE WMS_RULE_LIST_PACKAGE

1743: PROCEDURE update_count(
1744: p_rule_type IN VARCHAR2
1745: , p_count IN NUMBER ) IS
1746: BEGIN
1747: UPDATE WMS_RULE_LIST_PACKAGE
1748: SET PACKAGE_NAME_COUNT = p_count
1749: WHERE RULE_TYPE = p_rule_type;
1750: EXCEPTION
1751: WHEN OTHERS THEN