DBA Data[Home] [Help]

APPS.ENG_VAL_TO_ID dependencies on ENG_ENGINEERING_CHANGES

Line 320: FROM eng_engineering_changes

316: BEGIN
317:
318: SELECT change_order_type_id
319: INTO l_id
320: FROM eng_engineering_changes
321: WHERE change_notice = p_change_notice
322: AND organization_id = p_org_id;
323:
324: RETURN l_id;

Line 357: FROM eng_engineering_changes

353: BEGIN
354:
355: SELECT change_id, change_mgmt_type_code
356: INTO l_id, x_change_mgmt_type_code
357: FROM eng_engineering_changes
358: WHERE change_notice = p_change_notice
359: AND organization_id = p_org_id;
360:
361: RETURN l_id;

Line 2336: l_plm_or_erp_change eng_engineering_changes.plm_or_erp_change%type;

2332: l_source_type_code VARCHAR2(30) ;
2333: l_status_type NUMBER;
2334: l_approval_status_type NUMBER;
2335: l_status_code NUMBER;
2336: l_plm_or_erp_change eng_engineering_changes.plm_or_erp_change%type;
2337: BEGIN
2338: l_Return_Status := FND_API.G_RET_STS_SUCCESS;
2339: l_ECO_Unexp_Rec := p_ECO_Unexp_Rec;
2340: