DBA Data[Home] [Help]

APPS.WMS_RULE_GEN_PKGS dependencies on WMS_RULE_LIST_PACKAGE

Line 1664: FROM WMS_RULE_LIST_PACKAGE

1660: l_package_name_count NUMBER := NULL;
1661:
1662: cursor c1 is
1663: SELECT package_name_count
1664: FROM WMS_RULE_LIST_PACKAGE
1665: WHERE rule_type = p_rule_type for update;
1666:
1667: BEGIN
1668:

Line 1708: FROM WMS_RULE_LIST_PACKAGE

1704: l_package_name_count NUMBER := NULL;
1705:
1706: cursor c1 is
1707: SELECT package_name_count
1708: FROM WMS_RULE_LIST_PACKAGE
1709: WHERE rule_type = p_rule_type;
1710:
1711: BEGIN
1712:

Line 1740: UPDATE WMS_RULE_LIST_PACKAGE

1736: PROCEDURE update_count(
1737: p_rule_type IN VARCHAR2
1738: , p_count IN NUMBER ) IS
1739: BEGIN
1740: UPDATE WMS_RULE_LIST_PACKAGE
1741: SET PACKAGE_NAME_COUNT = p_count
1742: WHERE RULE_TYPE = p_rule_type;
1743: EXCEPTION
1744: WHEN OTHERS THEN