DBA Data[Home] [Help]

APPS.WMS_RULE_FORM_PKG dependencies on WMS_RULES_B

Line 12: CURSOR c IS SELECT rule_id FROM wms_rules_b

8: FUNCTION check_existence
9: (
10: p_rule_id IN NUMBER
11: ) RETURN BOOLEAN IS
12: CURSOR c IS SELECT rule_id FROM wms_rules_b
13: WHERE rule_id = p_rule_id;
14: l_rule_id NUMBER;
15: l_exist BOOLEAN;
16: BEGIN

Line 622: FROM wms_rules_b

618: l_api_name constant varchar2(30) := 'Find_Rule';
619:
620: CURSOR l_cur IS
621: SELECT 'Y'
622: FROM wms_rules_b
623: WHERE rule_id = p_rule_id;
624:
625: l_dummy VARCHAR2(1);
626: BEGIN

Line 1234: from wms_rules_b

1230: BEGIN
1231: BEGIN
1232: select 1
1233: into l_exist
1234: from wms_rules_b
1235: where type_hdr_id = p_std_operation_id
1236: and type_code = 3
1237: and rownum < 2 ;
1238: