APPS.ENG_NEW_ITEM_REQ_UTIL dependencies on ENG_CHANGE_STATUSES_VL

Line 113: FROM eng_change_statuses_vl a, eng_lifecycle_statuses b

109:
110: CURSOR c_first_status (cp_change_mgmt_type_id IN eng_change_order_types_tl.change_order_type_id%TYPE)
111: IS
112: SELECT a.status_name INTO stat_name
113: FROM eng_change_statuses_vl a, eng_lifecycle_statuses b
114: WHERE a.status_code = b.status_code
115: AND b.entity_name='ENG_CHANGE_TYPE'
116: AND b.entity_id1 = cp_change_mgmt_type_id
117: ORDER BY b.sequence_number;

Line 130: -- select status_name into stat_name FROM ENG_CHANGE_STATUSES_VL where status_code=1; -- 1 = Open

126: l_eco_rec.description := change_name;
127: l_eco_rec.change_type_code := change_type_code;
128:
129: -- Bug : 5140579 Removed the hardcoding and getting following values from database. Priority need not be hardcoded.
130: -- select status_name into stat_name FROM ENG_CHANGE_STATUSES_VL where status_code=1; -- 1 = Open
131:
132: -- Bug : 5282713 We need to get the first status of this change type.
133: select change_order_type_id into l_change_mgmt_type_id from eng_change_order_types_tl where type_name = change_type_code and language = userenv('LANG');
134: -- Get the first phase

Line 148: select status_name into stat_name FROM ENG_CHANGE_STATUSES_VL where status_code=1; -- 1 = Open

144: END LOOP;
145: CLOSE c_first_status;
146:
147: IF stat_name IS NULL THEN
148: select status_name into stat_name FROM ENG_CHANGE_STATUSES_VL where status_code=1; -- 1 = Open
149: END IF;
150:
151:
152: select change_order_type, change_order_type_id