APPS.ENG_ECO_PUB dependencies on ENG_CHANGE_ORDER_TYPES

Line 924: l_auto_number_method eng_change_order_types.AUTO_NUMBERING_METHOD%TYPE;

920: P_CHANGE_ORDER_TYPE IN VARCHAR2)
921: RETURN VARCHAR2 IS
922:
923: l_type_id NUMBER;
924: l_auto_number_method eng_change_order_types.AUTO_NUMBERING_METHOD%TYPE;
925: l_change_number eng_engineering_changes.CHANGE_NOTICE%TYPE := NULL;
926:
927: -- Added for Bug 3542172
928:

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 934: FROM eng_change_order_types_vl ecotv_in

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
934: FROM eng_change_order_types_vl ecotv_in
935: WHERE ecotv_in.change_mgmt_type_code = 'CHANGE_ORDER'
936: AND ecotv_in.type_classification='CATEGORY';
937:
938: -- End changes for Bug 3542172

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,

Line 947: FROM eng_change_order_types_vl ecotv1, eng_change_order_types_vl ecotv2

943: SELECT ecotv1.change_order_type_id change_mgmt_type_id,
944: ecotv2.change_order_type_id,
945: ecotv2.auto_numbering_method,
946: ecotv1.auto_numbering_method change_mgmt_method
947: FROM eng_change_order_types_vl ecotv1, eng_change_order_types_vl ecotv2
948: WHERE ecotv1.type_name = cp_change_type_name
949: AND ecotv1.TYPE_CLASSIFICATION= 'CATEGORY'
950: AND ecotv1.change_mgmt_type_code = ecotv2.change_mgmt_type_code
951: AND ecotv2.type_name = p_CHANGE_ORDER_TYPE