[Home] [Help]
78: l_type_id NUMBER;
79: l_auto_number_method eng_change_order_types.AUTO_NUMBERING_METHOD%TYPE;
80: l_change_number eng_engineering_changes.CHANGE_NOTICE%TYPE := NULL;
81:
82: l_change_type_name eng_change_order_types_tl.type_name%TYPE := NULL;
83: l_hist_rec_row_id VARCHAR2(100);
84: l_change_mgmt_type_id eng_change_order_types_tl.change_order_type_id%TYPE;
85:
86: CURSOR c_change_type_detail(l_change_order_type_id IN NUMBER)
80: l_change_number eng_engineering_changes.CHANGE_NOTICE%TYPE := NULL;
81:
82: l_change_type_name eng_change_order_types_tl.type_name%TYPE := NULL;
83: l_hist_rec_row_id VARCHAR2(100);
84: l_change_mgmt_type_id eng_change_order_types_tl.change_order_type_id%TYPE;
85:
86: CURSOR c_change_type_detail(l_change_order_type_id IN NUMBER)
87: IS
88: SELECT ecotv1.change_order_type_id change_mgmt_type_id,
106: WHERE eng_change.change_notice = p_change_notice
107: AND eng_change.organization_id = org_param.organization_id
108: AND org_param.organization_code = p_org_code;
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
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
135:
136: OPEN c_first_status(l_change_mgmt_type_id);
137: LOOP