APPS.WMS_RULE_FORM_PKG dependencies on WMS_RULES

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 195: SELECT wms_rules_s.NEXTVAL INTO l_rule_id FROM dual;

191: if fnd_api.to_boolean( p_init_msg_list ) then
192: fnd_msg_pub.initialize;
193: end if;
194:
195: SELECT wms_rules_s.NEXTVAL INTO l_rule_id FROM dual;
196:
197: validate_input
198: (
199: x_return_status => l_return_status

Line 240: wms_rules_pkg.insert_row

236: l_user_id := fnd_global.user_id;
237: l_login_id := fnd_global.login_id;
238:
239: /* call the table handler to do the insert */
240: wms_rules_pkg.insert_row
241: (
242: x_rowid => l_row_id
243: ,x_rule_id => l_rule_id
244: ,x_organization_id => p_organization_id

Line 393: wms_rules_pkg.lock_row

389: elsif x_return_status = fnd_api.g_ret_sts_error then
390: raise fnd_api.g_exc_error;
391: end if;
392:
393: wms_rules_pkg.lock_row
394: (
395: x_rule_id => p_rule_id
396: ,x_organization_id => p_organization_id
397: ,x_type_code => p_type_code

Line 548: wms_rules_pkg.update_row

544: l_user_id := fnd_global.user_id;
545: l_login_id := fnd_global.login_id;
546:
547: /* call the table handler to do the update */
548: wms_rules_pkg.update_row
549: (
550: x_rule_id => p_rule_id
551: ,x_organization_id => p_organization_id
552: ,x_type_code => p_type_code

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 743: wms_rules_pkg.delete_row(p_rule_id);

739: /* we want to delete all restrictions and sort criteria records that tie to */
740: /* this rule */
741: wms_restriction_form_pkg.delete_restrictions(p_rule_id);
742: /* wms_sort_criteria_form_pkg.delete_sort_criteria(p_rule_id); */
743: wms_rules_pkg.delete_row(p_rule_id);
744:
745: x_return_status := l_return_status;
746:
747: EXCEPTION

Line 828: FROM wms_rules

824: ,description
825: ,TYPE_HDR_ID
826: ,RULE_WEIGHT
827: ,allocation_mode_id
828: FROM wms_rules
829: WHERE rule_id = p_orig_rule_id;
830:
831: l_rule_rec l_orig_rule_cur%ROWTYPE;
832:

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: