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_LIFECYCLE_STATUSES_S

Line 358: l_max_phase_sn eng_lifecycle_statuses.sequence_number%TYPE;

354:
355: --l_curr_status_code NUMBER;
356:
357: l_last_status_code NUMBER;
358: l_max_phase_sn eng_lifecycle_statuses.sequence_number%TYPE;
359:
360: l_last_imp_flag VARCHAR2(1) := 'N';
361:
362:

Line 465: l_max_phase_sn eng_lifecycle_statuses.sequence_number%TYPE;

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
469: --SAVEPOINT Is_CO_Last_Imp_Phase_Used;

Line 466: l_start_date eng_lifecycle_statuses.start_date%TYPE;

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
469: --SAVEPOINT Is_CO_Last_Imp_Phase_Used;
470:

Line 607: l_phase_sn eng_lifecycle_statuses.sequence_number%TYPE;

603: l_fnd_login_id NUMBER := TO_NUMBER(FND_PROFILE.VALUE('LOGIN_ID'));
604:
605: l_updated BOOLEAN := FALSE ;
606:
607: l_phase_sn eng_lifecycle_statuses.sequence_number%TYPE;
608: l_max_appr_phase_sn eng_lifecycle_statuses.sequence_number%TYPE;
609:
610: l_status_type eng_engineering_changes.status_type%TYPE;
611:

Line 608: l_max_appr_phase_sn eng_lifecycle_statuses.sequence_number%TYPE;

604:
605: l_updated BOOLEAN := FALSE ;
606:
607: l_phase_sn eng_lifecycle_statuses.sequence_number%TYPE;
608: l_max_appr_phase_sn eng_lifecycle_statuses.sequence_number%TYPE;
609:
610: l_status_type eng_engineering_changes.status_type%TYPE;
611:
612: l_wf_item_key wf_item_activity_statuses.item_key%TYPE := NULL;

Line 1548: l_min_appr_sn eng_lifecycle_statuses.sequence_number%TYPE;

1544: l_chg_notice eng_engineering_changes.change_notice%TYPE;
1545: l_org_id eng_engineering_changes.organization_id%TYPE;
1546: l_request_id NUMBER;
1547:
1548: l_min_appr_sn eng_lifecycle_statuses.sequence_number%TYPE;
1549: l_doc_lc_object_flag BOOLEAN := FALSE ;
1550:
1551:
1552: BEGIN

Line 1963: l_curr_phase_sn eng_lifecycle_statuses.sequence_number%TYPE;

1959: l_msg_data VARCHAR2(2000);
1960:
1961: l_curr_status_code eng_engineering_changes.status_code%TYPE;
1962:
1963: l_curr_phase_sn eng_lifecycle_statuses.sequence_number%TYPE;
1964: l_new_phase_sn eng_lifecycle_statuses.sequence_number%TYPE;
1965: l_max_sn eng_lifecycle_statuses.sequence_number%TYPE;
1966: l_phase_sn eng_lifecycle_statuses.sequence_number%TYPE;
1967:

Line 1964: l_new_phase_sn eng_lifecycle_statuses.sequence_number%TYPE;

1960:
1961: l_curr_status_code eng_engineering_changes.status_code%TYPE;
1962:
1963: l_curr_phase_sn eng_lifecycle_statuses.sequence_number%TYPE;
1964: l_new_phase_sn eng_lifecycle_statuses.sequence_number%TYPE;
1965: l_max_sn eng_lifecycle_statuses.sequence_number%TYPE;
1966: l_phase_sn eng_lifecycle_statuses.sequence_number%TYPE;
1967:
1968: l_new_status_type eng_change_statuses.status_type%TYPE;

Line 1965: l_max_sn eng_lifecycle_statuses.sequence_number%TYPE;

1961: l_curr_status_code eng_engineering_changes.status_code%TYPE;
1962:
1963: l_curr_phase_sn eng_lifecycle_statuses.sequence_number%TYPE;
1964: l_new_phase_sn eng_lifecycle_statuses.sequence_number%TYPE;
1965: l_max_sn eng_lifecycle_statuses.sequence_number%TYPE;
1966: l_phase_sn eng_lifecycle_statuses.sequence_number%TYPE;
1967:
1968: l_new_status_type eng_change_statuses.status_type%TYPE;
1969: l_ri_status_type eng_change_statuses.status_type%TYPE;

Line 1966: l_phase_sn eng_lifecycle_statuses.sequence_number%TYPE;

1962:
1963: l_curr_phase_sn eng_lifecycle_statuses.sequence_number%TYPE;
1964: l_new_phase_sn eng_lifecycle_statuses.sequence_number%TYPE;
1965: l_max_sn eng_lifecycle_statuses.sequence_number%TYPE;
1966: l_phase_sn eng_lifecycle_statuses.sequence_number%TYPE;
1967:
1968: l_new_status_type eng_change_statuses.status_type%TYPE;
1969: l_ri_status_type eng_change_statuses.status_type%TYPE;
1970:

Line 2003: l_ri_phase_sn eng_lifecycle_statuses.sequence_number%TYPE;

1999:
2000:
2001: l_ri_status_code eng_change_lines.status_code%TYPE;
2002: -- revItem's status_code's sequence_number
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;

Line 2665: Write_Debug('After updating eng_lifecycle_statuses.start_date.');

2661: AND entity_id1 = p_change_id
2662: AND status_code = p_status_code
2663: AND active_flag = 'Y';
2664: IF g_debug_flag THEN
2665: Write_Debug('After updating eng_lifecycle_statuses.start_date.');
2666: Write_Debug(' Row count = ' || SQL%ROWCOUNT);
2667: END IF;
2668:
2669: END IF;

Line 3061: l_curr_phase_sn eng_lifecycle_statuses.sequence_number%TYPE;

3057: l_return_status VARCHAR2(1);
3058: l_msg_count NUMBER;
3059: l_msg_data VARCHAR2(2000);
3060:
3061: l_curr_phase_sn eng_lifecycle_statuses.sequence_number%TYPE;
3062: l_new_phase_sn eng_lifecycle_statuses.sequence_number%TYPE;
3063:
3064: l_new_status_type eng_change_statuses.status_type%TYPE;
3065:

Line 3062: l_new_phase_sn eng_lifecycle_statuses.sequence_number%TYPE;

3058: l_msg_count NUMBER;
3059: l_msg_data VARCHAR2(2000);
3060:
3061: l_curr_phase_sn eng_lifecycle_statuses.sequence_number%TYPE;
3062: l_new_phase_sn eng_lifecycle_statuses.sequence_number%TYPE;
3063:
3064: l_new_status_type eng_change_statuses.status_type%TYPE;
3065:
3066: l_change_mgmt_type_code eng_engineering_changes.change_mgmt_type_code%TYPE;

Line 3111: l_ri_phase_sn eng_lifecycle_statuses.sequence_number%TYPE;

3107: WHERE change_id = p_change_id
3108: FOR UPDATE;
3109: l_ri_status_code eng_change_lines.status_code%TYPE;
3110: -- revItem's status_code's sequence_number
3111: l_ri_phase_sn eng_lifecycle_statuses.sequence_number%TYPE;
3112: l_ri_status_type eng_change_statuses.status_type%TYPE;
3113:
3114:
3115: l_base_cm_type_code VARCHAR2(30) ;

Line 3299: SELECT eng_lifecycle_statuses_s.nextval

3295: WHERE CURRENT OF c_lcStatuses;
3296:
3297: -- First get the new unique index id value for the new row (also save the old id)
3298: l_old_row_id := l_lcStatuses_row.change_lifecycle_status_id;
3299: SELECT eng_lifecycle_statuses_s.nextval
3300: INTO l_new_row_id
3301: FROM DUAL;
3302:
3303: -- Secondly get the new wf_route_id if needed

Line 3785: l_ri_phase_sn eng_lifecycle_statuses.sequence_number%TYPE;

3781: l_return_status VARCHAR2(1);
3782: l_msg_count NUMBER;
3783: l_msg_data VARCHAR2(2000);
3784:
3785: l_ri_phase_sn eng_lifecycle_statuses.sequence_number%TYPE;
3786: l_new_phase_sn eng_lifecycle_statuses.sequence_number%TYPE;
3787: l_max_sn eng_lifecycle_statuses.sequence_number%TYPE;
3788: l_phase_sn eng_lifecycle_statuses.sequence_number%TYPE;
3789:

Line 3786: l_new_phase_sn eng_lifecycle_statuses.sequence_number%TYPE;

3782: l_msg_count NUMBER;
3783: l_msg_data VARCHAR2(2000);
3784:
3785: l_ri_phase_sn eng_lifecycle_statuses.sequence_number%TYPE;
3786: l_new_phase_sn eng_lifecycle_statuses.sequence_number%TYPE;
3787: l_max_sn eng_lifecycle_statuses.sequence_number%TYPE;
3788: l_phase_sn eng_lifecycle_statuses.sequence_number%TYPE;
3789:
3790: l_last_imp_flag VARCHAR2(1) := 'N';

Line 3787: l_max_sn eng_lifecycle_statuses.sequence_number%TYPE;

3783: l_msg_data VARCHAR2(2000);
3784:
3785: l_ri_phase_sn eng_lifecycle_statuses.sequence_number%TYPE;
3786: l_new_phase_sn eng_lifecycle_statuses.sequence_number%TYPE;
3787: l_max_sn eng_lifecycle_statuses.sequence_number%TYPE;
3788: l_phase_sn eng_lifecycle_statuses.sequence_number%TYPE;
3789:
3790: l_last_imp_flag VARCHAR2(1) := 'N';
3791:

Line 3788: l_phase_sn eng_lifecycle_statuses.sequence_number%TYPE;

3784:
3785: l_ri_phase_sn eng_lifecycle_statuses.sequence_number%TYPE;
3786: l_new_phase_sn eng_lifecycle_statuses.sequence_number%TYPE;
3787: l_max_sn eng_lifecycle_statuses.sequence_number%TYPE;
3788: l_phase_sn eng_lifecycle_statuses.sequence_number%TYPE;
3789:
3790: l_last_imp_flag VARCHAR2(1) := 'N';
3791:
3792: l_new_status_type eng_change_statuses.status_type%TYPE;

Line 4163: l_new_phase_sn eng_lifecycle_statuses.sequence_number%TYPE;

4159: l_return_status VARCHAR2(1);
4160: l_msg_count NUMBER;
4161: l_msg_data VARCHAR2(2000);
4162:
4163: l_new_phase_sn eng_lifecycle_statuses.sequence_number%TYPE;
4164:
4165: l_new_status_type eng_change_statuses.status_type%TYPE;
4166:
4167: l_ri_status_code eng_change_lines.status_code%TYPE;

Line 4169: l_ri_phase_sn eng_lifecycle_statuses.sequence_number%TYPE;

4165: l_new_status_type eng_change_statuses.status_type%TYPE;
4166:
4167: l_ri_status_code eng_change_lines.status_code%TYPE;
4168: -- revItem's status_code's sequence_number
4169: l_ri_phase_sn eng_lifecycle_statuses.sequence_number%TYPE;
4170: l_ri_status_type eng_change_statuses.status_type%TYPE;
4171:
4172: l_curr_phase_sn eng_lifecycle_statuses.sequence_number%TYPE;
4173:

Line 4172: l_curr_phase_sn eng_lifecycle_statuses.sequence_number%TYPE;

4168: -- revItem's status_code's sequence_number
4169: l_ri_phase_sn eng_lifecycle_statuses.sequence_number%TYPE;
4170: l_ri_status_type eng_change_statuses.status_type%TYPE;
4171:
4172: l_curr_phase_sn eng_lifecycle_statuses.sequence_number%TYPE;
4173:
4174: BEGIN
4175: -- Standard Start of API savepoint
4176: SAVEPOINT Demote_Revised_Item;

Line 4863: l_min_appr_sn eng_lifecycle_statuses.sequence_number%TYPE;

4859: l_next_status_code NUMBER;
4860: l_last_status_code NUMBER;
4861:
4862: l_status_type NUMBER; -- status_type for p_status_code as incoming parameter
4863: l_min_appr_sn eng_lifecycle_statuses.sequence_number%TYPE;
4864:
4865: l_last_wf_route_id eng_lifecycle_statuses.change_wf_route_id%TYPE;
4866:
4867: l_curr_phase_sn eng_lifecycle_statuses.sequence_number%TYPE;

Line 4867: l_curr_phase_sn eng_lifecycle_statuses.sequence_number%TYPE;

4863: l_min_appr_sn eng_lifecycle_statuses.sequence_number%TYPE;
4864:
4865: l_last_wf_route_id eng_lifecycle_statuses.change_wf_route_id%TYPE;
4866:
4867: l_curr_phase_sn eng_lifecycle_statuses.sequence_number%TYPE;
4868: l_max_appr_phase_sn eng_lifecycle_statuses.sequence_number%TYPE;
4869: l_max_phase_sn eng_lifecycle_statuses.sequence_number%TYPE;
4870:
4871: l_nir_update_flag VARCHAR2(1) := 'F';

Line 4868: l_max_appr_phase_sn eng_lifecycle_statuses.sequence_number%TYPE;

4864:
4865: l_last_wf_route_id eng_lifecycle_statuses.change_wf_route_id%TYPE;
4866:
4867: l_curr_phase_sn eng_lifecycle_statuses.sequence_number%TYPE;
4868: l_max_appr_phase_sn eng_lifecycle_statuses.sequence_number%TYPE;
4869: l_max_phase_sn eng_lifecycle_statuses.sequence_number%TYPE;
4870:
4871: l_nir_update_flag VARCHAR2(1) := 'F';
4872:

Line 4869: l_max_phase_sn eng_lifecycle_statuses.sequence_number%TYPE;

4865: l_last_wf_route_id eng_lifecycle_statuses.change_wf_route_id%TYPE;
4866:
4867: l_curr_phase_sn eng_lifecycle_statuses.sequence_number%TYPE;
4868: l_max_appr_phase_sn eng_lifecycle_statuses.sequence_number%TYPE;
4869: l_max_phase_sn eng_lifecycle_statuses.sequence_number%TYPE;
4870:
4871: l_nir_update_flag VARCHAR2(1) := 'F';
4872:
4873: CURSOR c_lines IS

Line 4888: l_auto_demote_status eng_lifecycle_statuses.status_code%TYPE;

4884:
4885: l_imp_eco_flag VARCHAR2(1) := 'N';
4886:
4887: l_is_co_last_phase VARCHAR2(1);
4888: l_auto_demote_status eng_lifecycle_statuses.status_code%TYPE;
4889:
4890: l_flag_imp_failed VARCHAR2(1) := 'N';
4891:
4892: BEGIN

Line 6523: l_initial_phase_sn eng_lifecycle_statuses.sequence_number%TYPE;

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:
6525: l_status_code eng_lifecycle_statuses.status_code%TYPE;
6526: l_status_type eng_engineering_changes.status_type%TYPE;
6527: l_sequence_number eng_lifecycle_statuses.sequence_number%TYPE;

Line 6525: l_status_code eng_lifecycle_statuses.status_code%TYPE;

6521: l_bug_number NUMBER := 0;
6522:
6523: l_initial_phase_sn eng_lifecycle_statuses.sequence_number%TYPE;
6524:
6525: l_status_code eng_lifecycle_statuses.status_code%TYPE;
6526: l_status_type eng_engineering_changes.status_type%TYPE;
6527: l_sequence_number eng_lifecycle_statuses.sequence_number%TYPE;
6528: l_wf_route_id eng_lifecycle_statuses.change_wf_route_id%TYPE;
6529:

Line 6527: l_sequence_number eng_lifecycle_statuses.sequence_number%TYPE;

6523: l_initial_phase_sn eng_lifecycle_statuses.sequence_number%TYPE;
6524:
6525: l_status_code eng_lifecycle_statuses.status_code%TYPE;
6526: l_status_type eng_engineering_changes.status_type%TYPE;
6527: l_sequence_number eng_lifecycle_statuses.sequence_number%TYPE;
6528: l_wf_route_id eng_lifecycle_statuses.change_wf_route_id%TYPE;
6529:
6530: l_pls_block VARCHAR2(5000);
6531:

Line 6726: Write_Debug('After updating eng_lifecycle_statuses.start_date.');

6722: AND status_code = l_status_code
6723: AND active_flag = 'Y';
6724:
6725: IF g_debug_flag THEN
6726: Write_Debug('After updating eng_lifecycle_statuses.start_date.');
6727: Write_Debug(' Row count = ' || SQL%ROWCOUNT);
6728: END IF;
6729:
6730: IF g_debug_flag THEN

Line 7269: l_max_phase_sn eng_lifecycle_statuses.sequence_number%TYPE;

7265:
7266: l_next_status_code NUMBER;
7267: l_reset_status_code NUMBER;
7268: l_last_status_code NUMBER;
7269: l_max_phase_sn eng_lifecycle_statuses.sequence_number%TYPE;
7270: l_curr_status_type eng_engineering_changes.status_type%TYPE;
7271:
7272: -- l_last_imp_flag VARCHAR2(1) := 'N';
7273:

Line 7814: ENG_LIFECYCLE_STATUSES_S.NEXTVAL

7810: , ACTIVE_FLAG
7811: , CHANGE_WF_ROUTE_TEMPLATE_ID
7812: )
7813: SELECT
7814: ENG_LIFECYCLE_STATUSES_S.NEXTVAL
7815: , G_ENG_CHANGE
7816: , ch.CHANGE_ID
7817: , NULL -- ENTITY_ID2
7818: , NULL -- ENTITY_ID3

Line 7900: ENG_LIFECYCLE_STATUSES_S.NEXTVAL

7896: , ACTIVE_FLAG
7897: , CHANGE_WF_ROUTE_TEMPLATE_ID
7898: )
7899: SELECT
7900: ENG_LIFECYCLE_STATUSES_S.NEXTVAL
7901: , G_ENG_CHANGE
7902: , ch.CHANGE_ID
7903: , NULL -- ENTITY_ID2
7904: , NULL -- ENTITY_ID3