DBA Data[Home] [Help]

APPS.ENG_ECO_PUB dependencies on ENG_CHANGE_ORDER_TYPES_TL

Line 926: l_change_type_name eng_change_order_types_tl.type_name%TYPE := NULL;

922: l_change_number eng_engineering_changes.CHANGE_NOTICE%TYPE := NULL;
923:
924: -- Added for Bug 3542172
925:
926: l_change_type_name eng_change_order_types_tl.type_name%TYPE := NULL;
927:
928: /* Cursor to fetch the change type name for change order based seeded category */
929: CURSOR c_change_order_cat_type IS
930: SELECT ecotv_in.type_name

Line 938: cp_change_type_name IN eng_change_order_types_tl.type_name%TYPE)

934:
935: -- End changes for Bug 3542172
936:
937: CURSOR c_change_type_detail(
938: cp_change_type_name IN eng_change_order_types_tl.type_name%TYPE)
939: IS
940: SELECT ecotv1.change_order_type_id change_mgmt_type_id,
941: ecotv2.change_order_type_id,
942: ecotv2.auto_numbering_method,