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:

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

157: END LOOP;
158: CLOSE c_first_status;
159:
160: IF stat_name IS NULL THEN
161: select status_name into stat_name FROM ENG_CHANGE_STATUSES_VL where status_code=1; -- 1 = Open
162: END IF;
163:
164:
165: select change_order_type, change_order_type_id