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 1564: l_min_appr_sn eng_lifecycle_statuses.sequence_number%TYPE;

1560: l_chg_notice eng_engineering_changes.change_notice%TYPE;
1561: l_org_id eng_engineering_changes.organization_id%TYPE;
1562: l_request_id NUMBER;
1563:
1564: l_min_appr_sn eng_lifecycle_statuses.sequence_number%TYPE;
1565: l_doc_lc_object_flag BOOLEAN := FALSE ;
1566:
1567:
1568: BEGIN

Line 1986: l_curr_phase_sn eng_lifecycle_statuses.sequence_number%TYPE;

1982: l_msg_data VARCHAR2(2000);
1983:
1984: l_curr_status_code eng_engineering_changes.status_code%TYPE;
1985:
1986: l_curr_phase_sn eng_lifecycle_statuses.sequence_number%TYPE;
1987: l_new_phase_sn eng_lifecycle_statuses.sequence_number%TYPE;
1988: l_max_sn eng_lifecycle_statuses.sequence_number%TYPE;
1989: l_phase_sn eng_lifecycle_statuses.sequence_number%TYPE;
1990: -- bug 9577905

Line 1987: l_new_phase_sn eng_lifecycle_statuses.sequence_number%TYPE;

1983:
1984: l_curr_status_code eng_engineering_changes.status_code%TYPE;
1985:
1986: l_curr_phase_sn eng_lifecycle_statuses.sequence_number%TYPE;
1987: l_new_phase_sn eng_lifecycle_statuses.sequence_number%TYPE;
1988: l_max_sn eng_lifecycle_statuses.sequence_number%TYPE;
1989: l_phase_sn eng_lifecycle_statuses.sequence_number%TYPE;
1990: -- bug 9577905
1991: l_new_wf_status eng_lifecycle_statuses.workflow_status%TYPE;

Line 1988: l_max_sn eng_lifecycle_statuses.sequence_number%TYPE;

1984: l_curr_status_code eng_engineering_changes.status_code%TYPE;
1985:
1986: l_curr_phase_sn eng_lifecycle_statuses.sequence_number%TYPE;
1987: l_new_phase_sn eng_lifecycle_statuses.sequence_number%TYPE;
1988: l_max_sn eng_lifecycle_statuses.sequence_number%TYPE;
1989: l_phase_sn eng_lifecycle_statuses.sequence_number%TYPE;
1990: -- bug 9577905
1991: l_new_wf_status eng_lifecycle_statuses.workflow_status%TYPE;
1992: -- bug 9577905

Line 1989: l_phase_sn eng_lifecycle_statuses.sequence_number%TYPE;

1985:
1986: l_curr_phase_sn eng_lifecycle_statuses.sequence_number%TYPE;
1987: l_new_phase_sn eng_lifecycle_statuses.sequence_number%TYPE;
1988: l_max_sn eng_lifecycle_statuses.sequence_number%TYPE;
1989: l_phase_sn eng_lifecycle_statuses.sequence_number%TYPE;
1990: -- bug 9577905
1991: l_new_wf_status eng_lifecycle_statuses.workflow_status%TYPE;
1992: -- bug 9577905
1993:

Line 2029: l_ri_phase_sn eng_lifecycle_statuses.sequence_number%TYPE;

2025:
2026:
2027: l_ri_status_code eng_change_lines.status_code%TYPE;
2028: -- revItem's status_code's sequence_number
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;

Line 2750: Write_Debug('After updating eng_lifecycle_statuses.start_date and null completion_date.');

2746: AND entity_id1 = p_change_id
2747: AND status_code = p_status_code
2748: AND active_flag = 'Y';
2749: IF g_debug_flag THEN
2750: Write_Debug('After updating eng_lifecycle_statuses.start_date and null completion_date.');
2751: Write_Debug(' Row count = ' || SQL%ROWCOUNT);
2752: END IF;
2753:
2754: END IF;

Line 3152: l_curr_phase_sn eng_lifecycle_statuses.sequence_number%TYPE;

3148: l_return_status VARCHAR2(1);
3149: l_msg_count NUMBER;
3150: l_msg_data VARCHAR2(2000);
3151:
3152: l_curr_phase_sn eng_lifecycle_statuses.sequence_number%TYPE;
3153: l_new_phase_sn eng_lifecycle_statuses.sequence_number%TYPE;
3154:
3155: l_new_status_type eng_change_statuses.status_type%TYPE;
3156:

Line 3153: l_new_phase_sn eng_lifecycle_statuses.sequence_number%TYPE;

3149: l_msg_count NUMBER;
3150: l_msg_data VARCHAR2(2000);
3151:
3152: l_curr_phase_sn eng_lifecycle_statuses.sequence_number%TYPE;
3153: l_new_phase_sn eng_lifecycle_statuses.sequence_number%TYPE;
3154:
3155: l_new_status_type eng_change_statuses.status_type%TYPE;
3156:
3157: l_change_mgmt_type_code eng_engineering_changes.change_mgmt_type_code%TYPE;

Line 3202: l_ri_phase_sn eng_lifecycle_statuses.sequence_number%TYPE;

3198: WHERE change_id = p_change_id
3199: FOR UPDATE;
3200: l_ri_status_code eng_change_lines.status_code%TYPE;
3201: -- revItem's status_code's sequence_number
3202: l_ri_phase_sn eng_lifecycle_statuses.sequence_number%TYPE;
3203: l_ri_status_type eng_change_statuses.status_type%TYPE;
3204:
3205:
3206: l_base_cm_type_code VARCHAR2(30) ;

Line 3417: SELECT eng_lifecycle_statuses_s.nextval

3413: WHERE CURRENT OF c_lcStatuses;
3414:
3415: -- First get the new unique index id value for the new row (also save the old id)
3416: l_old_row_id := l_lcStatuses_row.change_lifecycle_status_id;
3417: SELECT eng_lifecycle_statuses_s.nextval
3418: INTO l_new_row_id
3419: FROM DUAL;
3420:
3421: -- Secondly get the new wf_route_id if needed

Line 3903: l_ri_phase_sn eng_lifecycle_statuses.sequence_number%TYPE;

3899: l_return_status VARCHAR2(1);
3900: l_msg_count NUMBER;
3901: l_msg_data VARCHAR2(2000);
3902:
3903: l_ri_phase_sn eng_lifecycle_statuses.sequence_number%TYPE;
3904: l_new_phase_sn eng_lifecycle_statuses.sequence_number%TYPE;
3905: l_max_sn eng_lifecycle_statuses.sequence_number%TYPE;
3906: l_phase_sn eng_lifecycle_statuses.sequence_number%TYPE;
3907:

Line 3904: l_new_phase_sn eng_lifecycle_statuses.sequence_number%TYPE;

3900: l_msg_count NUMBER;
3901: l_msg_data VARCHAR2(2000);
3902:
3903: l_ri_phase_sn eng_lifecycle_statuses.sequence_number%TYPE;
3904: l_new_phase_sn eng_lifecycle_statuses.sequence_number%TYPE;
3905: l_max_sn eng_lifecycle_statuses.sequence_number%TYPE;
3906: l_phase_sn eng_lifecycle_statuses.sequence_number%TYPE;
3907:
3908: l_last_imp_flag VARCHAR2(1) := 'N';

Line 3905: l_max_sn eng_lifecycle_statuses.sequence_number%TYPE;

3901: l_msg_data VARCHAR2(2000);
3902:
3903: l_ri_phase_sn eng_lifecycle_statuses.sequence_number%TYPE;
3904: l_new_phase_sn eng_lifecycle_statuses.sequence_number%TYPE;
3905: l_max_sn eng_lifecycle_statuses.sequence_number%TYPE;
3906: l_phase_sn eng_lifecycle_statuses.sequence_number%TYPE;
3907:
3908: l_last_imp_flag VARCHAR2(1) := 'N';
3909:

Line 3906: l_phase_sn eng_lifecycle_statuses.sequence_number%TYPE;

3902:
3903: l_ri_phase_sn eng_lifecycle_statuses.sequence_number%TYPE;
3904: l_new_phase_sn eng_lifecycle_statuses.sequence_number%TYPE;
3905: l_max_sn eng_lifecycle_statuses.sequence_number%TYPE;
3906: l_phase_sn eng_lifecycle_statuses.sequence_number%TYPE;
3907:
3908: l_last_imp_flag VARCHAR2(1) := 'N';
3909:
3910: l_new_status_type eng_change_statuses.status_type%TYPE;

Line 4281: l_new_phase_sn eng_lifecycle_statuses.sequence_number%TYPE;

4277: l_return_status VARCHAR2(1);
4278: l_msg_count NUMBER;
4279: l_msg_data VARCHAR2(2000);
4280:
4281: l_new_phase_sn eng_lifecycle_statuses.sequence_number%TYPE;
4282:
4283: l_new_status_type eng_change_statuses.status_type%TYPE;
4284:
4285: l_ri_status_code eng_change_lines.status_code%TYPE;

Line 4287: l_ri_phase_sn eng_lifecycle_statuses.sequence_number%TYPE;

4283: l_new_status_type eng_change_statuses.status_type%TYPE;
4284:
4285: l_ri_status_code eng_change_lines.status_code%TYPE;
4286: -- revItem's status_code's sequence_number
4287: l_ri_phase_sn eng_lifecycle_statuses.sequence_number%TYPE;
4288: l_ri_status_type eng_change_statuses.status_type%TYPE;
4289:
4290: l_curr_phase_sn eng_lifecycle_statuses.sequence_number%TYPE;
4291:

Line 4290: l_curr_phase_sn eng_lifecycle_statuses.sequence_number%TYPE;

4286: -- revItem's status_code's sequence_number
4287: l_ri_phase_sn eng_lifecycle_statuses.sequence_number%TYPE;
4288: l_ri_status_type eng_change_statuses.status_type%TYPE;
4289:
4290: l_curr_phase_sn eng_lifecycle_statuses.sequence_number%TYPE;
4291:
4292: BEGIN
4293: -- Standard Start of API savepoint
4294: SAVEPOINT Demote_Revised_Item;

Line 4981: l_min_appr_sn eng_lifecycle_statuses.sequence_number%TYPE;

4977: l_next_status_code NUMBER;
4978: l_last_status_code NUMBER;
4979:
4980: l_status_type NUMBER; -- status_type for p_status_code as incoming parameter
4981: l_min_appr_sn eng_lifecycle_statuses.sequence_number%TYPE;
4982:
4983: l_last_wf_route_id eng_lifecycle_statuses.change_wf_route_id%TYPE;
4984:
4985: l_curr_phase_sn eng_lifecycle_statuses.sequence_number%TYPE;

Line 4985: l_curr_phase_sn eng_lifecycle_statuses.sequence_number%TYPE;

4981: l_min_appr_sn eng_lifecycle_statuses.sequence_number%TYPE;
4982:
4983: l_last_wf_route_id eng_lifecycle_statuses.change_wf_route_id%TYPE;
4984:
4985: l_curr_phase_sn eng_lifecycle_statuses.sequence_number%TYPE;
4986: l_max_appr_phase_sn eng_lifecycle_statuses.sequence_number%TYPE;
4987: l_max_phase_sn eng_lifecycle_statuses.sequence_number%TYPE;
4988:
4989: l_nir_update_flag VARCHAR2(1) := 'F';

Line 4986: l_max_appr_phase_sn eng_lifecycle_statuses.sequence_number%TYPE;

4982:
4983: l_last_wf_route_id eng_lifecycle_statuses.change_wf_route_id%TYPE;
4984:
4985: l_curr_phase_sn eng_lifecycle_statuses.sequence_number%TYPE;
4986: l_max_appr_phase_sn eng_lifecycle_statuses.sequence_number%TYPE;
4987: l_max_phase_sn eng_lifecycle_statuses.sequence_number%TYPE;
4988:
4989: l_nir_update_flag VARCHAR2(1) := 'F';
4990:

Line 4987: l_max_phase_sn eng_lifecycle_statuses.sequence_number%TYPE;

4983: l_last_wf_route_id eng_lifecycle_statuses.change_wf_route_id%TYPE;
4984:
4985: l_curr_phase_sn eng_lifecycle_statuses.sequence_number%TYPE;
4986: l_max_appr_phase_sn eng_lifecycle_statuses.sequence_number%TYPE;
4987: l_max_phase_sn eng_lifecycle_statuses.sequence_number%TYPE;
4988:
4989: l_nir_update_flag VARCHAR2(1) := 'F';
4990:
4991: CURSOR c_lines IS

Line 5006: l_auto_demote_status eng_lifecycle_statuses.status_code%TYPE;

5002:
5003: l_imp_eco_flag VARCHAR2(1) := 'N';
5004:
5005: l_is_co_last_phase VARCHAR2(1);
5006: l_auto_demote_status eng_lifecycle_statuses.status_code%TYPE;
5007:
5008: l_flag_imp_failed VARCHAR2(1) := 'N';
5009:
5010: BEGIN

Line 6687: l_initial_phase_sn eng_lifecycle_statuses.sequence_number%TYPE;

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:
6689: l_status_code eng_lifecycle_statuses.status_code%TYPE;
6690: l_status_type eng_engineering_changes.status_type%TYPE;
6691: l_sequence_number eng_lifecycle_statuses.sequence_number%TYPE;

Line 6689: l_status_code eng_lifecycle_statuses.status_code%TYPE;

6685: l_bug_number NUMBER := 0;
6686:
6687: l_initial_phase_sn eng_lifecycle_statuses.sequence_number%TYPE;
6688:
6689: l_status_code eng_lifecycle_statuses.status_code%TYPE;
6690: l_status_type eng_engineering_changes.status_type%TYPE;
6691: l_sequence_number eng_lifecycle_statuses.sequence_number%TYPE;
6692: l_wf_route_id eng_lifecycle_statuses.change_wf_route_id%TYPE;
6693: -- bug 9577905

Line 6691: l_sequence_number eng_lifecycle_statuses.sequence_number%TYPE;

6687: l_initial_phase_sn eng_lifecycle_statuses.sequence_number%TYPE;
6688:
6689: l_status_code eng_lifecycle_statuses.status_code%TYPE;
6690: l_status_type eng_engineering_changes.status_type%TYPE;
6691: l_sequence_number eng_lifecycle_statuses.sequence_number%TYPE;
6692: l_wf_route_id eng_lifecycle_statuses.change_wf_route_id%TYPE;
6693: -- bug 9577905
6694: l_next_status_code eng_lifecycle_statuses.auto_promote_status%TYPE;
6695: l_workflow_status eng_lifecycle_statuses.workflow_status%TYPE;

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

6987: AND status_code = l_status_code
6988: AND active_flag = 'Y';
6989:
6990: IF g_debug_flag THEN
6991: Write_Debug('After updating eng_lifecycle_statuses.start_date.');
6992: Write_Debug(' Row count = ' || SQL%ROWCOUNT);
6993: END IF;
6994:
6995: IF g_debug_flag THEN

Line 7560: l_max_phase_sn eng_lifecycle_statuses.sequence_number%TYPE;

7556:
7557: l_next_status_code NUMBER;
7558: l_reset_status_code NUMBER;
7559: l_last_status_code NUMBER;
7560: l_max_phase_sn eng_lifecycle_statuses.sequence_number%TYPE;
7561: l_curr_status_type eng_engineering_changes.status_type%TYPE;
7562:
7563: -- l_last_imp_flag VARCHAR2(1) := 'N';
7564:

Line 8105: ENG_LIFECYCLE_STATUSES_S.NEXTVAL

8101: , ACTIVE_FLAG
8102: , CHANGE_WF_ROUTE_TEMPLATE_ID
8103: )
8104: SELECT
8105: ENG_LIFECYCLE_STATUSES_S.NEXTVAL
8106: , G_ENG_CHANGE
8107: , ch.CHANGE_ID
8108: , NULL -- ENTITY_ID2
8109: , NULL -- ENTITY_ID3

Line 8191: ENG_LIFECYCLE_STATUSES_S.NEXTVAL

8187: , ACTIVE_FLAG
8188: , CHANGE_WF_ROUTE_TEMPLATE_ID
8189: )
8190: SELECT
8191: ENG_LIFECYCLE_STATUSES_S.NEXTVAL
8192: , G_ENG_CHANGE
8193: , ch.CHANGE_ID
8194: , NULL -- ENTITY_ID2
8195: , NULL -- ENTITY_ID3