eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.ENG_CHANGE_LIFECYCLE_UTIL dependencies on ENG_CHANGE_ORDER_TYPES

Line 312: ENG_CHANGE_ORDER_TYPES ChangeCategory,

308: eec.change_mgmt_type_code ,
309: changecategory.base_change_mgmt_type_code,
310: type_appl.application_id
311: FROM ENG_ENGINEERING_CHANGES eec,
312: ENG_CHANGE_ORDER_TYPES ChangeCategory,
313: ENG_CHANGE_TYPE_APPLICATIONS type_appl
314: WHERE type_appl.change_type_id = ChangeCategory.change_order_type_id
315: and type_appl.application_id = p_appl_id
316: AND ChangeCategory.type_classification = 'CATEGORY'

Line 351: l_base_cm_type_code eng_change_order_types.BASE_CHANGE_MGMT_TYPE_CODE%TYPE;

347: l_fnd_user_id NUMBER := TO_NUMBER(FND_PROFILE.VALUE('USER_ID'));
348: l_fnd_login_id NUMBER := TO_NUMBER(FND_PROFILE.VALUE('LOGIN_ID'));
349:
350: l_cm_type_code eng_engineering_changes.CHANGE_MGMT_TYPE_CODE%TYPE;
351: l_base_cm_type_code eng_change_order_types.BASE_CHANGE_MGMT_TYPE_CODE%TYPE;
352:
353: l_next_status_code NUMBER;
354:
355: --l_curr_status_code NUMBER;

Line 399: eng_change_order_types ecot

395: ecot.base_change_mgmt_type_code
396: INTO l_cm_type_code, l_next_status_code, --l_curr_status_code
397: l_base_cm_type_code
398: FROM eng_engineering_changes eec,
399: eng_change_order_types ecot
400: WHERE eec.change_id = p_change_id
401: AND ecot.change_order_type_id = eec.change_order_type_id;
402:
403: --x_curr_status_code := l_curr_status_code;

Line 464: l_base_cm_type_code eng_change_order_types.BASE_CHANGE_MGMT_TYPE_CODE%TYPE;

460: ,x_last_status_code OUT NOCOPY NUMBER
461: )
462: IS
463: l_cm_type_code eng_engineering_changes.CHANGE_MGMT_TYPE_CODE%TYPE;
464: l_base_cm_type_code eng_change_order_types.BASE_CHANGE_MGMT_TYPE_CODE%TYPE;
465: l_max_phase_sn eng_lifecycle_statuses.sequence_number%TYPE;
466: l_start_date eng_lifecycle_statuses.start_date%TYPE;
467: BEGIN
468: -- Standard Start of API savepoint

Line 491: eng_change_order_types ecot

487: -- Get the change header's cm type, and promote_status_code
488: SELECT eec.change_mgmt_type_code, ecot.base_change_mgmt_type_code
489: INTO l_cm_type_code, l_base_cm_type_code
490: FROM eng_engineering_changes eec,
491: eng_change_order_types ecot
492: WHERE eec.change_id = p_change_id
493: AND ecot.change_order_type_id = eec.change_order_type_id;
494:
495: IF (l_base_cm_type_code = G_ENG_ECO) THEN

Line 615: l_base_cm_type_code eng_change_order_types.BASE_CHANGE_MGMT_TYPE_CODE%TYPE;

611:
612: l_wf_item_key wf_item_activity_statuses.item_key%TYPE := NULL;
613:
614: l_cm_type_code eng_engineering_changes.change_mgmt_type_code%TYPE;
615: l_base_cm_type_code eng_change_order_types.BASE_CHANGE_MGMT_TYPE_CODE%TYPE;
616:
617: l_param_list WF_PARAMETER_LIST_T := WF_PARAMETER_LIST_T();
618:
619: l_appl_id NUMBER ;

Line 688: eng_change_order_types ecot

684: -- Select cm type and base type code for upcoming API calls
685: SELECT eec.change_mgmt_type_code, ecot.base_change_mgmt_type_code
686: INTO l_cm_type_code, l_base_cm_type_code
687: FROM eng_engineering_changes eec,
688: eng_change_order_types ecot
689: WHERE eec.change_id = p_change_id
690: AND ecot.change_order_type_id = eec.change_order_type_id;
691:
692: l_doc_lc_object_flag := ENG_DOCUMENT_UTIL.Is_Dom_Document_Lifecycle

Line 822: eng_change_order_types ecot

818: -- Select cm type and base type code for upcoming API calls
819: /*SELECT eec.change_mgmt_type_code, ecot.base_change_mgmt_type_code
820: INTO l_cm_type_code, l_base_cm_type_code
821: FROM eng_engineering_changes eec,
822: eng_change_order_types ecot
823: WHERE eec.change_id = p_change_id
824: AND ecot.change_order_type_id = eec.change_order_type_id;*/
825:
826:

Line 2033: l_base_cm_type_code eng_change_order_types.BASE_CHANGE_MGMT_TYPE_CODE%TYPE;

2029: l_ri_phase_sn eng_lifecycle_statuses.sequence_number%TYPE;
2030:
2031: l_last_imp_flag VARCHAR2(1) := 'N';
2032: l_cm_type_code eng_engineering_changes.CHANGE_MGMT_TYPE_CODE%TYPE;
2033: l_base_cm_type_code eng_change_order_types.BASE_CHANGE_MGMT_TYPE_CODE%TYPE;
2034: l_imp_eco_flag VARCHAR2(1) := 'N';
2035:
2036: --l_co_type_id eng_engineering_changes.CHANGE_ORDER_TYPE_ID%TYPE;
2037: l_auto_prop_flag eng_type_org_properties.AUTO_PROPAGATE_FLAG%TYPE;

Line 2404: eng_change_order_types ecot

2400: -- Get the change header's cm type and base cm type
2401: SELECT eec.change_mgmt_type_code, ecot.base_change_mgmt_type_code, eec.approval_status_type
2402: INTO l_cm_type_code, l_base_cm_type_code, l_eco_approval_status
2403: FROM eng_engineering_changes eec,
2404: eng_change_order_types ecot
2405: WHERE eec.change_id = p_change_id
2406: AND ecot.change_order_type_id = eec.change_order_type_id;
2407:
2408: -- If there are still open lines or mandatory tasks, raise error message

Line 4973: l_base_cm_type_code eng_change_order_types.BASE_CHANGE_MGMT_TYPE_CODE%TYPE;

4969: l_chg_appr_status eng_engineering_changes.approval_status_type%TYPE;
4970: l_curr_appr_status eng_engineering_changes.approval_status_type%TYPE;
4971:
4972: l_cm_type_code eng_engineering_changes.change_mgmt_type_code%TYPE;
4973: l_base_cm_type_code eng_change_order_types.BASE_CHANGE_MGMT_TYPE_CODE%TYPE;
4974:
4975: l_curr_status_code NUMBER;
4976: l_curr_status_type NUMBER;
4977: l_next_status_code NUMBER;

Line 5100: eng_change_order_types ecot

5096: ecot.base_change_mgmt_type_code
5097: INTO l_curr_status_code, l_next_status_code, l_cm_type_code,
5098: l_base_cm_type_code
5099: FROM eng_engineering_changes eec,
5100: eng_change_order_types ecot
5101: WHERE eec.change_id = p_change_id
5102: AND ecot.change_order_type_id = eec.change_order_type_id;
5103:
5104: -- Get the current phase status_type

Line 5643: eng_change_order_types ecot

5639: ecot.base_change_mgmt_type_code
5640: INTO l_cm_type_code, l_chg_notice, l_org_id,
5641: l_base_cm_type_code
5642: FROM eng_engineering_changes eec,
5643: eng_change_order_types ecot
5644: WHERE eec.change_id = p_change_id
5645: AND ecot.change_order_type_id = eec.change_order_type_id;
5646:
5647: -- Complete attachment approval if needed

Line 6684: l_base_cm_type_code eng_change_order_types.BASE_CHANGE_MGMT_TYPE_CODE%TYPE;

6680: l_fnd_user_id NUMBER := TO_NUMBER(FND_PROFILE.VALUE('USER_ID'));
6681: l_fnd_login_id NUMBER := TO_NUMBER(FND_PROFILE.VALUE('LOGIN_ID'));
6682:
6683: l_cm_type_code eng_engineering_changes.change_mgmt_type_code%TYPE;
6684: l_base_cm_type_code eng_change_order_types.BASE_CHANGE_MGMT_TYPE_CODE%TYPE;
6685: l_bug_number NUMBER := 0;
6686:
6687: l_initial_phase_sn eng_lifecycle_statuses.sequence_number%TYPE;
6688:

Line 7071: eng_change_order_types ecot

7067: -- Select cm type and base type code for upcoming API calls
7068: SELECT eec.change_mgmt_type_code, ecot.base_change_mgmt_type_code
7069: INTO l_cm_type_code, l_base_cm_type_code
7070: FROM eng_engineering_changes eec,
7071: eng_change_order_types ecot
7072: WHERE eec.change_id = p_change_id
7073: AND ecot.change_order_type_id = eec.change_order_type_id;
7074:
7075: -- for nir set all included item approval status to submitted for approval

Line 7555: l_base_cm_type_code eng_change_order_types.BASE_CHANGE_MGMT_TYPE_CODE%TYPE;

7551:
7552: l_doc_lc_object_flag BOOLEAN := FALSE ;
7553:
7554: l_cm_type_code eng_engineering_changes.CHANGE_MGMT_TYPE_CODE%TYPE;
7555: l_base_cm_type_code eng_change_order_types.BASE_CHANGE_MGMT_TYPE_CODE%TYPE;
7556:
7557: l_next_status_code NUMBER;
7558: l_reset_status_code NUMBER;
7559: l_last_status_code NUMBER;

Line 7575: eng_change_order_types ecot

7571: , eec.promote_status_code
7572: , eec.change_mgmt_type_code
7573: , ecot.base_change_mgmt_type_code
7574: FROM eng_engineering_changes eec,
7575: eng_change_order_types ecot
7576: WHERE eec.change_id = c_change_id
7577: AND ecot.change_order_type_id = eec.change_order_type_id ;
7578:
7579: