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_STATUSES

Line 523: FROM eng_change_statuses

519:
520: -- Get the status_type of the last phase
521: SELECT status_type
522: INTO x_last_status_type
523: FROM eng_change_statuses
524: WHERE status_code = x_last_status_code;
525:
526: END IF;
527:

Line 681: FROM eng_change_statuses

677:
678: -- get phase type
679: SELECT status_type
680: INTO l_status_type
681: FROM eng_change_statuses
682: WHERE status_code = p_status_code;
683:
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

Line 739: eng_change_statuses chs

735: -- Get the sequence number of the last phase of type APPROVAL
736: SELECT max(lcs.sequence_number)
737: INTO l_max_appr_phase_sn
738: FROM eng_lifecycle_statuses lcs,
739: eng_change_statuses chs
740: WHERE lcs.entity_name = G_ENG_CHANGE
741: AND lcs.entity_id1 = p_change_id
742: AND lcs.active_flag = 'Y'
743: AND chs.status_code = lcs.status_code

Line 1301: eng_change_statuses s,

1297: IS
1298: SELECT DISTINCT route.route_id wf_route_id
1299: , line.change_line_id
1300: FROM eng_change_routes route,
1301: eng_change_statuses s,
1302: eng_change_lines line,
1303: eng_lifecycle_statuses line_start_after,
1304: eng_lifecycle_statuses new_status,
1305: eng_lifecycle_statuses cur_status

Line 1994: l_new_status_type eng_change_statuses.status_type%TYPE;

1990: -- bug 9577905
1991: l_new_wf_status eng_lifecycle_statuses.workflow_status%TYPE;
1992: -- bug 9577905
1993:
1994: l_new_status_type eng_change_statuses.status_type%TYPE;
1995: l_ri_status_type eng_change_statuses.status_type%TYPE;
1996:
1997: l_skip_promotion VARCHAR2(1) := 'N';
1998:

Line 1995: l_ri_status_type eng_change_statuses.status_type%TYPE;

1991: l_new_wf_status eng_lifecycle_statuses.workflow_status%TYPE;
1992: -- bug 9577905
1993:
1994: l_new_status_type eng_change_statuses.status_type%TYPE;
1995: l_ri_status_type eng_change_statuses.status_type%TYPE;
1996:
1997: l_skip_promotion VARCHAR2(1) := 'N';
1998:
1999: -- Select status_type of all lines of the header

Line 2007: eng_change_statuses s,

2003: l.required_flag,
2004: l.change_type_id ,
2005: route.status_code wf_status_code
2006: FROM eng_change_routes route,
2007: eng_change_statuses s,
2008: eng_change_lines l
2009: WHERE s.status_code = l.status_code
2010: AND route.route_id(+) = l.route_id
2011: AND l.change_id = p_change_id ;

Line 2013: l_line_status_type eng_change_statuses.status_type%TYPE;

2009: WHERE s.status_code = l.status_code
2010: AND route.route_id(+) = l.route_id
2011: AND l.change_id = p_change_id ;
2012:
2013: l_line_status_type eng_change_statuses.status_type%TYPE;
2014: l_status_code eng_change_lines.complete_before_status_code%TYPE;
2015: l_required_flag eng_change_lines.required_flag%TYPE := NULL;
2016: l_change_type_id NUMBER ;
2017: l_wf_status_code eng_change_routes.status_code%TYPE;

Line 2262: FROM eng_change_statuses

2258:
2259: -- Get the status_type of the new phase
2260: SELECT status_type
2261: INTO l_new_status_type
2262: FROM eng_change_statuses
2263: WHERE status_code = p_status_code
2264: AND rownum = 1;
2265:
2266: -- Get the max sequence number in the lifecycle

Line 2691: FROM eng_change_statuses

2687:
2688: -- Get the status_type of the revised item phase
2689: SELECT status_type
2690: INTO l_ri_status_type
2691: FROM eng_change_statuses
2692: WHERE status_code = l_ri_status_code
2693: AND rownum = 1;
2694:
2695: -- Update only those which are open

Line 3155: l_new_status_type eng_change_statuses.status_type%TYPE;

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;
3158:
3159: -- Cursor to get all lifecycle phases between (inclusive) [demotionStatus, currentStatus]

Line 3203: l_ri_status_type eng_change_statuses.status_type%TYPE;

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) ;
3207: l_doc_lc_object_flag BOOLEAN := FALSE ;

Line 3400: FROM eng_change_statuses

3396:
3397: -- Check existence of approval phase between curr and demotion phase
3398: SELECT status_type
3399: INTO l_temp_status_type
3400: FROM eng_change_statuses
3401: WHERE status_code = l_lcStatuses_row.STATUS_CODE;
3402: IF (l_temp_status_type = G_ENG_APPROVED)
3403: THEN
3404: l_has_approval_phase := 'T';

Line 3566: FROM eng_change_statuses

3562:
3563: -- Get the status_type of the new phase
3564: SELECT status_type
3565: INTO l_new_status_type
3566: FROM eng_change_statuses
3567: WHERE status_code = p_status_code;
3568:
3569: -- Demote change header record
3570: UPDATE eng_engineering_changes

Line 3647: FROM eng_change_statuses

3643:
3644: -- Get the status_type of the revised item phase
3645: SELECT status_type
3646: INTO l_ri_status_type
3647: FROM eng_change_statuses
3648: WHERE status_code = l_ri_status_code
3649: AND rownum = 1;
3650:
3651: IF (l_ri_status_type <> G_ENG_IMPLEMENTED

Line 3910: l_new_status_type eng_change_statuses.status_type%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;
3911: l_ri_status_code eng_change_lines.status_code%TYPE;
3912: l_ri_status_type eng_change_statuses.status_type%TYPE;
3913:
3914: l_chg_notice eng_engineering_changes.change_notice%TYPE;

Line 3912: l_ri_status_type eng_change_statuses.status_type%TYPE;

3908: l_last_imp_flag VARCHAR2(1) := 'N';
3909:
3910: l_new_status_type eng_change_statuses.status_type%TYPE;
3911: l_ri_status_code eng_change_lines.status_code%TYPE;
3912: l_ri_status_type eng_change_statuses.status_type%TYPE;
3913:
3914: l_chg_notice eng_engineering_changes.change_notice%TYPE;
3915: l_org_id eng_engineering_changes.organization_id%TYPE;
3916: l_request_id NUMBER;

Line 3994: FROM eng_change_statuses

3990:
3991: -- Get the status_type of the new phase
3992: SELECT status_type
3993: INTO l_new_status_type
3994: FROM eng_change_statuses
3995: WHERE status_code = p_status_code
3996: AND rownum = 1;
3997:
3998: -- Get the max sequence number in the lifecycle

Line 4051: FROM eng_change_statuses

4047: -- Make sure the revised item is not implemented or cancelled
4048: -- Get the status_type of the revised item phase
4049: SELECT status_type
4050: INTO l_ri_status_type
4051: FROM eng_change_statuses
4052: WHERE status_code = l_ri_status_code
4053: AND rownum = 1;
4054:
4055: -- Update only those which are still active

Line 4283: l_new_status_type eng_change_statuses.status_type%TYPE;

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;
4286: -- revItem's status_code's sequence_number
4287: l_ri_phase_sn eng_lifecycle_statuses.sequence_number%TYPE;

Line 4288: l_ri_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:
4292: BEGIN

Line 4378: FROM eng_change_statuses

4374:
4375: -- Get the status_type of the new phase
4376: SELECT status_type
4377: INTO l_new_status_type
4378: FROM eng_change_statuses
4379: WHERE status_code = p_status_code;
4380:
4381: -- Make sure the revised item is not implemented or cancelled
4382: -- Get the status_type of the revised item phase

Line 4385: FROM eng_change_statuses

4381: -- Make sure the revised item is not implemented or cancelled
4382: -- Get the status_type of the revised item phase
4383: SELECT status_type
4384: INTO l_ri_status_type
4385: FROM eng_change_statuses
4386: WHERE status_code = l_ri_status_code
4387: AND rownum = 1;
4388:
4389: -- Update only those which are still active

Line 4994: eng_change_statuses s

4990:
4991: CURSOR c_lines IS
4992: SELECT s.status_type
4993: FROM eng_change_lines l,
4994: eng_change_statuses s
4995: WHERE l.change_id = p_change_id
4996: AND s.status_code = l.status_code;
4997: l_line_status_type eng_change_statuses.status_type%TYPE;
4998:

Line 4997: l_line_status_type eng_change_statuses.status_type%TYPE;

4993: FROM eng_change_lines l,
4994: eng_change_statuses s
4995: WHERE l.change_id = p_change_id
4996: AND s.status_code = l.status_code;
4997: l_line_status_type eng_change_statuses.status_type%TYPE;
4998:
4999: l_chg_notice eng_engineering_changes.change_notice%TYPE;
5000: l_org_id eng_engineering_changes.organization_id%TYPE;
5001: l_request_id NUMBER;

Line 5107: FROM eng_change_statuses

5103:
5104: -- Get the current phase status_type
5105: SELECT status_type
5106: INTO l_curr_status_type
5107: FROM eng_change_statuses
5108: WHERE status_code = l_curr_status_code;
5109:
5110: -- Get the current phase's sequence number
5111: SELECT sequence_number

Line 5172: l_next_status_type eng_change_statuses.status_type%TYPE;

5168:
5169: -- Bug 5989058.
5170: -- Set the implementation date if the status is completed or implemented
5171: DECLARE
5172: l_next_status_type eng_change_statuses.status_type%TYPE;
5173: BEGIN
5174:
5175: SELECT status_type INTO l_next_status_type FROM eng_change_statuses WHERE status_code = l_next_status_code;
5176:

Line 5175: SELECT status_type INTO l_next_status_type FROM eng_change_statuses WHERE status_code = l_next_status_code;

5171: DECLARE
5172: l_next_status_type eng_change_statuses.status_type%TYPE;
5173: BEGIN
5174:
5175: SELECT status_type INTO l_next_status_type FROM eng_change_statuses WHERE status_code = l_next_status_code;
5176:
5177: if( l_next_status_type = G_ENG_COMPLETED OR
5178: l_next_status_type = G_ENG_IMPLEMENTED ) THEN
5179: UPDATE eng_engineering_changes SET

Line 5450: l_next_status_type eng_change_statuses.status_type%TYPE;

5446:
5447: -- Bug 5989058.
5448: -- Set the implementation date if the status is completed or implemented
5449: DECLARE
5450: l_next_status_type eng_change_statuses.status_type%TYPE;
5451: BEGIN
5452:
5453: SELECT status_type INTO l_next_status_type FROM eng_change_statuses WHERE status_code = l_curr_status_code;
5454:

Line 5453: SELECT status_type INTO l_next_status_type FROM eng_change_statuses WHERE status_code = l_curr_status_code;

5449: DECLARE
5450: l_next_status_type eng_change_statuses.status_type%TYPE;
5451: BEGIN
5452:
5453: SELECT status_type INTO l_next_status_type FROM eng_change_statuses WHERE status_code = l_curr_status_code;
5454:
5455: if( l_next_status_type = G_ENG_COMPLETED OR
5456: l_next_status_type = G_ENG_IMPLEMENTED ) THEN
5457: UPDATE eng_engineering_changes SET

Line 5523: eng_change_statuses chs

5519: -- Get the sequence number of the last phase of type REVIEW/APPROVAL
5520: SELECT max(lcs.sequence_number)
5521: INTO l_max_appr_phase_sn
5522: FROM eng_lifecycle_statuses lcs,
5523: eng_change_statuses chs
5524: WHERE lcs.entity_name = G_ENG_CHANGE
5525: AND lcs.entity_id1 = p_change_id
5526: AND lcs.active_flag = 'Y'
5527: AND chs.status_code = lcs.status_code

Line 5848: FROM eng_change_statuses

5844:
5845: -- get phase type
5846: SELECT status_type
5847: INTO l_status_type
5848: FROM eng_change_statuses
5849: WHERE status_code = p_status_code;
5850: -- check if the phase type is APPROVAL
5851: IF ( l_status_type = G_ENG_APPROVED ) THEN
5852: IF g_debug_flag THEN

Line 6065: FROM eng_change_statuses

6061:
6062: -- get phase type
6063: SELECT status_type
6064: INTO l_status_type
6065: FROM eng_change_statuses
6066: WHERE status_code = p_status_code;
6067: -- check if the phase type is APPROVAL
6068: IF ( l_status_type = G_ENG_APPROVED ) THEN
6069: IF g_debug_flag THEN

Line 6802: eng_change_statuses ecs

6798: -- bug 9577905, add l_workflow_status, l_next_status_code
6799: SELECT lcs.status_code, ecs.status_type, lcs.workflow_status,lcs.auto_promote_status
6800: INTO l_status_code, l_status_type, l_workflow_status, l_next_status_code
6801: FROM eng_lifecycle_statuses lcs,
6802: eng_change_statuses ecs
6803: WHERE lcs.entity_name = G_ENG_CHANGE
6804: AND lcs.entity_id1 = p_change_id
6805: AND lcs.active_flag = 'Y'
6806: AND lcs.sequence_number = l_initial_phase_sn

Line 7677: FROM eng_change_statuses

7673:
7674: -- Get the current phase status_type
7675: SELECT status_type
7676: INTO l_curr_status_type
7677: FROM eng_change_statuses
7678: WHERE status_code = l_reset_status_code;
7679:
7680: --
7681: -- Get the current phase's sequence number