APPS.WMS_RULE_PVT dependencies on USER_OBJECTS

Line 6738: FROM user_objects

6734:
6735: --cursor used to determine if the rule package exists
6736: CURSOR l_pack_gen IS
6737: SELECT COUNT(object_name)
6738: FROM user_objects
6739: WHERE object_name = l_package_name;
6740:
6741: --cursor used to determine if suggestions should be minimized
6742: -- for this rule. This flag affects how the Pick UOM functionality

Line 12413: FROM user_objects

12409: l_error VARCHAR2(10);
12410:
12411: CURSOR c_package_status IS
12412: SELECT status
12413: FROM user_objects
12414: WHERE object_name = UPPER(p_package_name)
12415: AND object_type='PACKAGE'
12416: AND status <> 'VALID'
12417: AND rownum = 1;

Line 12421: FROM user_objects

12417: AND rownum = 1;
12418:
12419: CURSOR c_package_body_status IS
12420: SELECT status
12421: FROM user_objects
12422: WHERE object_name = UPPER(p_package_name)
12423: AND object_type = 'PACKAGE BODY'
12424: AND status <> 'VALID'
12425: AND rownum = 1;

Line 13945: FROM user_objects

13941:
13942: --cursor used to determine if the rule package exists
13943: CURSOR l_pack_gen IS
13944: SELECT COUNT(object_name)
13945: FROM user_objects
13946: WHERE object_name = l_package_name;
13947:
13948: -- Bug# 4587423: If a default outbound operation plan is not defined for the org,
13949: -- default to 1 (Locator and LPN Based Consolidation in Staging Lane)

Line 14307: FROM user_objects

14303:
14304: --cursor used to determine if the rule package exists
14305: CURSOR l_pack_gen IS
14306: SELECT COUNT(object_name)
14307: FROM user_objects
14308: WHERE object_name = l_package_name;
14309:
14310: -- Following Code is commented because now we need to get 2 more default task_type..MOISSUE and MOXFER
14311: /*CURSOR c_default_task_type IS

Line 14655: FROM user_objects

14651:
14652: --cursor used to determine if the rule package exists
14653: CURSOR l_pack_gen IS
14654: SELECT COUNT(object_name)
14655: FROM user_objects
14656: WHERE object_name = l_package_name;
14657:
14658: CURSOR l_default_label_curs IS
14659: SELECT label_format_id

Line 15877: FROM user_objects

15873:
15874: --cursor used to determine if the rule package exists
15875: CURSOR l_pack_gen IS
15876: SELECT COUNT(object_name)
15877: FROM user_objects
15878: WHERE object_name = l_package_name;
15879:
15880: --cursor used to determine if suggestions should be minimized
15881: -- for this rule. This flag affects how the Pick UOM functionality