DBA Data[Home] [Help]

APPS.ENG_ECO_PUB dependencies on ENG_CHANGE_ORDER_TYPES_TL

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

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

Line 941: cp_change_type_name IN eng_change_order_types_tl.type_name%TYPE)

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