DBA Data[Home] [Help]

APPS.ENG_NEW_ITEM_REQ_UTIL dependencies on ENG_ENGINEERING_CHANGES

Line 80: l_change_number eng_engineering_changes.CHANGE_NOTICE%TYPE := NULL;

76: stat_name varchar2(80);
77:
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;

Line 105: , eng_engineering_changes eng_change

101: CURSOR c_change_id (p_change_notice IN VARCHAR2, p_org_code IN VARCHAR2)
102: IS
103: SELECT CHANGE_ID
104: FROM mtl_parameters org_param
105: , eng_engineering_changes eng_change
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: