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 686: eng_change_order_types ecot

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

Line 820: eng_change_order_types ecot

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

Line 2007: l_base_cm_type_code eng_change_order_types.BASE_CHANGE_MGMT_TYPE_CODE%TYPE;

2003: l_ri_phase_sn eng_lifecycle_statuses.sequence_number%TYPE;
2004:
2005: l_last_imp_flag VARCHAR2(1) := 'N';
2006: l_cm_type_code eng_engineering_changes.CHANGE_MGMT_TYPE_CODE%TYPE;
2007: l_base_cm_type_code eng_change_order_types.BASE_CHANGE_MGMT_TYPE_CODE%TYPE;
2008: l_imp_eco_flag VARCHAR2(1) := 'N';
2009:
2010: --l_co_type_id eng_engineering_changes.CHANGE_ORDER_TYPE_ID%TYPE;
2011: l_auto_prop_flag eng_type_org_properties.AUTO_PROPAGATE_FLAG%TYPE;

Line 2331: eng_change_order_types ecot

2327: -- Get the change header's cm type and base cm type
2328: SELECT eec.change_mgmt_type_code, ecot.base_change_mgmt_type_code, eec.approval_status_type
2329: INTO l_cm_type_code, l_base_cm_type_code, l_eco_approval_status
2330: FROM eng_engineering_changes eec,
2331: eng_change_order_types ecot
2332: WHERE eec.change_id = p_change_id
2333: AND ecot.change_order_type_id = eec.change_order_type_id;
2334:
2335: -- If there are still open lines or mandatory tasks, raise error message

Line 4855: l_base_cm_type_code eng_change_order_types.BASE_CHANGE_MGMT_TYPE_CODE%TYPE;

4851: l_chg_appr_status eng_engineering_changes.approval_status_type%TYPE;
4852: l_curr_appr_status eng_engineering_changes.approval_status_type%TYPE;
4853:
4854: l_cm_type_code eng_engineering_changes.change_mgmt_type_code%TYPE;
4855: l_base_cm_type_code eng_change_order_types.BASE_CHANGE_MGMT_TYPE_CODE%TYPE;
4856:
4857: l_curr_status_code NUMBER;
4858: l_curr_status_type NUMBER;
4859: l_next_status_code NUMBER;

Line 4978: eng_change_order_types ecot

4974: ecot.base_change_mgmt_type_code
4975: INTO l_curr_status_code, l_next_status_code, l_cm_type_code,
4976: l_base_cm_type_code
4977: FROM eng_engineering_changes eec,
4978: eng_change_order_types ecot
4979: WHERE eec.change_id = p_change_id
4980: AND ecot.change_order_type_id = eec.change_order_type_id;
4981:
4982: -- Get the current phase status_type

Line 5481: eng_change_order_types ecot

5477: ecot.base_change_mgmt_type_code
5478: INTO l_cm_type_code, l_chg_notice, l_org_id,
5479: l_base_cm_type_code
5480: FROM eng_engineering_changes eec,
5481: eng_change_order_types ecot
5482: WHERE eec.change_id = p_change_id
5483: AND ecot.change_order_type_id = eec.change_order_type_id;
5484:
5485: -- Complete attachment approval if needed

Line 6520: l_base_cm_type_code eng_change_order_types.BASE_CHANGE_MGMT_TYPE_CODE%TYPE;

6516: l_fnd_user_id NUMBER := TO_NUMBER(FND_PROFILE.VALUE('USER_ID'));
6517: l_fnd_login_id NUMBER := TO_NUMBER(FND_PROFILE.VALUE('LOGIN_ID'));
6518:
6519: l_cm_type_code eng_engineering_changes.change_mgmt_type_code%TYPE;
6520: l_base_cm_type_code eng_change_order_types.BASE_CHANGE_MGMT_TYPE_CODE%TYPE;
6521: l_bug_number NUMBER := 0;
6522:
6523: l_initial_phase_sn eng_lifecycle_statuses.sequence_number%TYPE;
6524:

Line 6806: eng_change_order_types ecot

6802: -- Select cm type and base type code for upcoming API calls
6803: SELECT eec.change_mgmt_type_code, ecot.base_change_mgmt_type_code
6804: INTO l_cm_type_code, l_base_cm_type_code
6805: FROM eng_engineering_changes eec,
6806: eng_change_order_types ecot
6807: WHERE eec.change_id = p_change_id
6808: AND ecot.change_order_type_id = eec.change_order_type_id;
6809:
6810: -- for nir set all included item approval status to submitted for approval

Line 7264: l_base_cm_type_code eng_change_order_types.BASE_CHANGE_MGMT_TYPE_CODE%TYPE;

7260:
7261: l_doc_lc_object_flag BOOLEAN := FALSE ;
7262:
7263: l_cm_type_code eng_engineering_changes.CHANGE_MGMT_TYPE_CODE%TYPE;
7264: l_base_cm_type_code eng_change_order_types.BASE_CHANGE_MGMT_TYPE_CODE%TYPE;
7265:
7266: l_next_status_code NUMBER;
7267: l_reset_status_code NUMBER;
7268: l_last_status_code NUMBER;

Line 7284: eng_change_order_types ecot

7280: , eec.promote_status_code
7281: , eec.change_mgmt_type_code
7282: , ecot.base_change_mgmt_type_code
7283: FROM eng_engineering_changes eec,
7284: eng_change_order_types ecot
7285: WHERE eec.change_id = c_change_id
7286: AND ecot.change_order_type_id = eec.change_order_type_id ;
7287:
7288: