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 229: l_rule_id wms_rules_b.rule_id%TYPE := NULL;

225: OP_PKG_NAME VARCHAR2(255) := 'WMS_RULE_OP_PKG';
226: -- variables needed for dynamic SQL
227: l_cursor INTEGER;
228: l_rows INTEGER;
229: l_rule_id wms_rules_b.rule_id%TYPE := NULL;
230: l_type_code wms_rules_b.TYPE_CODE%TYPE := p_type_code;
231: l_package_name VARCHAR2(255);
232: l_if_cl VARCHAR2(10);
233: l_endif_cl VARCHAR2(255);

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

226: -- variables needed for dynamic SQL
227: l_cursor INTEGER;
228: l_rows INTEGER;
229: l_rule_id wms_rules_b.rule_id%TYPE := NULL;
230: l_type_code wms_rules_b.TYPE_CODE%TYPE := p_type_code;
231: l_package_name VARCHAR2(255);
232: l_if_cl VARCHAR2(10);
233: l_endif_cl VARCHAR2(255);
234: l_cur_ocl VARCHAR2(10) := '''' ||'OPEN' || '''';

Line 274: FROM WMS_RULES_B

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

Line 281: FROM WMS_RULES_B rl , all_objects obj

277: ORDER BY rule_weight DESC, creation_date;*/
278: -- modified by grao to exclude the invalid rules but status enabled
279: -- Fix for Bug 11907124. added leading hint /*+ leading(rl) */
280: SELECT /*+ leading(rl) */ rl.rule_id
281: FROM WMS_RULES_B rl , all_objects obj
282: WHERE rl.enabled_flag = 'Y'
283: AND rl.type_code = p_type_code
284: AND (obj.object_name = 'WMS_RULE_'|| to_char(rl.rule_id)
285: AND obj.object_type = 'PACKAGE BODY'

Line 1346: l_rule_id wms_rules_b.rule_id%TYPE;

1342: op_type NUMBER := 7;
1343: -- variables needed for dynamic SQL
1344: l_cursor INTEGER;
1345: l_rows INTEGER;
1346: l_rule_id wms_rules_b.rule_id%TYPE;
1347: l_type_code wms_rules_b.TYPE_CODE%TYPE;
1348: l_package_name VARCHAR2(255);
1349: l_pkg_stmt long;
1350: l_pkg_hdr long;

Line 1347: l_type_code wms_rules_b.TYPE_CODE%TYPE;

1343: -- variables needed for dynamic SQL
1344: l_cursor INTEGER;
1345: l_rows INTEGER;
1346: l_rule_id wms_rules_b.rule_id%TYPE;
1347: l_type_code wms_rules_b.TYPE_CODE%TYPE;
1348: l_package_name VARCHAR2(255);
1349: l_pkg_stmt long;
1350: l_pkg_hdr long;
1351: l_type_name VARCHAR2(40);