DBA Data[Home] [Help]

APPS.EGO_ICC_BULKLOAD_PVT dependencies on ENG_CHANGE_ORDER_TYPES

Line 3565: l_change_order_type ENG_CHANGE_ORDER_TYPES.change_order_type%TYPE := null;

3561: --
3562: l_entity_code VARCHAR2(30) := G_ENTITY_ICC_HEADER;
3563: l_token_table ERROR_HANDLER.Token_Tbl_Type;
3564:
3565: l_change_order_type ENG_CHANGE_ORDER_TYPES.change_order_type%TYPE := null;
3566: l_change_type_id NUMBER := NULL;
3567:
3568: FUNCTION Check_Change_OrderType ( p_change_order_type_id IN NUMBER DEFAULT NULL
3569: ,p_change_order_type_name IN VARCHAR2 DEFAULT NULL

Line 3578: FROM eng_change_order_types_vl

3574:
3575: CURSOR cur_cotype
3576: IS
3577: SELECT change_order_type_id
3578: FROM eng_change_order_types_vl
3579: where ( change_order_type_id = nvl(p_change_order_type_id, change_order_type_id)
3580: AND
3581: change_order_type = nvl(p_change_order_type_name, change_order_type)
3582: )