APPS.WMS_RULE_GEN_PKGS dependencies on WMS_RULES_B

Line 34: from wms_rules_b

30: Function get_rule_count( p_type_code in NUMBER ) return number is
31: l_rule_count number := 0;
32: begin
33: select count(rule_id) into l_rule_count
34: from wms_rules_b
35: where type_code = p_type_code
36: and enabled_flag = 'Y';
37:
38: return l_rule_count;

Line 223: l_rule_id wms_rules_b.rule_id%TYPE := NULL;

219: OP_PKG_NAME VARCHAR2(255) := 'WMS_RULE_OP_PKG';
220: -- variables needed for dynamic SQL
221: l_cursor INTEGER;
222: l_rows INTEGER;
223: l_rule_id wms_rules_b.rule_id%TYPE := NULL;
224: l_type_code wms_rules_b.TYPE_CODE%TYPE := p_type_code;
225: l_package_name VARCHAR2(255);
226: l_if_cl VARCHAR2(10);
227: l_endif_cl VARCHAR2(255);

Line 224: l_type_code wms_rules_b.TYPE_CODE%TYPE := p_type_code;

220: -- variables needed for dynamic SQL
221: l_cursor INTEGER;
222: l_rows INTEGER;
223: l_rule_id wms_rules_b.rule_id%TYPE := NULL;
224: l_type_code wms_rules_b.TYPE_CODE%TYPE := p_type_code;
225: l_package_name VARCHAR2(255);
226: l_if_cl VARCHAR2(10);
227: l_endif_cl VARCHAR2(255);
228: l_cur_ocl VARCHAR2(10) := '''' ||'OPEN' || '''';

Line 268: FROM WMS_RULES_B

264:
265: -- cursor for validation of input parameters and pre-requisites
266: CURSOR rule_curs IS
267: /*SELECT rule_id
268: FROM WMS_RULES_B
269: WHERE enabled_flag = 'Y'
270: AND type_code = p_type_code
271: ORDER BY rule_weight DESC, creation_date;*/
272: -- modified by grao to exclude the invalid rules but status enabled

Line 274: FROM WMS_RULES_B rl , all_objects obj

270: AND type_code = p_type_code
271: ORDER BY rule_weight DESC, creation_date;*/
272: -- modified by grao to exclude the invalid rules but status enabled
273: SELECT rl.rule_id
274: FROM WMS_RULES_B rl , all_objects obj
275: WHERE rl.enabled_flag = 'Y'
276: AND rl.type_code = p_type_code
277: AND (obj.object_name = 'WMS_RULE_'|| to_char(rl.rule_id)
278: AND obj.object_type = 'PACKAGE BODY'

Line 1339: l_rule_id wms_rules_b.rule_id%TYPE;

1335: op_type NUMBER := 7;
1336: -- variables needed for dynamic SQL
1337: l_cursor INTEGER;
1338: l_rows INTEGER;
1339: l_rule_id wms_rules_b.rule_id%TYPE;
1340: l_type_code wms_rules_b.TYPE_CODE%TYPE;
1341: l_package_name VARCHAR2(255);
1342: l_pkg_stmt long;
1343: l_pkg_hdr long;

Line 1340: l_type_code wms_rules_b.TYPE_CODE%TYPE;

1336: -- variables needed for dynamic SQL
1337: l_cursor INTEGER;
1338: l_rows INTEGER;
1339: l_rule_id wms_rules_b.rule_id%TYPE;
1340: l_type_code wms_rules_b.TYPE_CODE%TYPE;
1341: l_package_name VARCHAR2(255);
1342: l_pkg_stmt long;
1343: l_pkg_hdr long;
1344: l_type_name VARCHAR2(40);