APPS.ENG_ECO_PUB dependencies on ENG_CHANGE_ORDER_TYPES

Line 921: l_auto_number_method eng_change_order_types.AUTO_NUMBERING_METHOD%TYPE;

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

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

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

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,

Line 944: FROM eng_change_order_types_vl ecotv1, eng_change_order_types_vl ecotv2

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