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 679: FROM eng_change_statuses

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

Line 737: eng_change_statuses chs

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

Line 1285: eng_change_statuses s,

1281: IS
1282: SELECT DISTINCT route.route_id wf_route_id
1283: , line.change_line_id
1284: FROM eng_change_routes route,
1285: eng_change_statuses s,
1286: eng_change_lines line,
1287: eng_lifecycle_statuses line_start_after,
1288: eng_lifecycle_statuses new_status,
1289: eng_lifecycle_statuses cur_status

Line 1968: l_new_status_type eng_change_statuses.status_type%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:
1971: l_skip_promotion VARCHAR2(1) := 'N';
1972:

Line 1969: l_ri_status_type eng_change_statuses.status_type%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:
1971: l_skip_promotion VARCHAR2(1) := 'N';
1972:
1973: -- Select status_type of all lines of the header

Line 1981: eng_change_statuses s,

1977: l.required_flag,
1978: l.change_type_id ,
1979: route.status_code wf_status_code
1980: FROM eng_change_routes route,
1981: eng_change_statuses s,
1982: eng_change_lines l
1983: WHERE s.status_code = l.status_code
1984: AND route.route_id(+) = l.route_id
1985: AND l.change_id = p_change_id ;

Line 1987: l_line_status_type eng_change_statuses.status_type%TYPE;

1983: WHERE s.status_code = l.status_code
1984: AND route.route_id(+) = l.route_id
1985: AND l.change_id = p_change_id ;
1986:
1987: l_line_status_type eng_change_statuses.status_type%TYPE;
1988: l_status_code eng_change_lines.complete_before_status_code%TYPE;
1989: l_required_flag eng_change_lines.required_flag%TYPE := NULL;
1990: l_change_type_id NUMBER ;
1991: l_wf_status_code eng_change_routes.status_code%TYPE;

Line 2205: FROM eng_change_statuses

2201:
2202: -- Get the status_type of the new phase
2203: SELECT status_type
2204: INTO l_new_status_type
2205: FROM eng_change_statuses
2206: WHERE status_code = p_status_code
2207: AND rownum = 1;
2208:
2209: -- Get the max sequence number in the lifecycle

Line 2608: FROM eng_change_statuses

2604:
2605: -- Get the status_type of the revised item phase
2606: SELECT status_type
2607: INTO l_ri_status_type
2608: FROM eng_change_statuses
2609: WHERE status_code = l_ri_status_code
2610: AND rownum = 1;
2611:
2612: -- Update only those which are open

Line 3064: l_new_status_type eng_change_statuses.status_type%TYPE;

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

Line 3112: l_ri_status_type eng_change_statuses.status_type%TYPE;

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

Line 3282: FROM eng_change_statuses

3278:
3279: -- Check existence of approval phase between curr and demotion phase
3280: SELECT status_type
3281: INTO l_temp_status_type
3282: FROM eng_change_statuses
3283: WHERE status_code = l_lcStatuses_row.STATUS_CODE;
3284: IF (l_temp_status_type = G_ENG_APPROVED)
3285: THEN
3286: l_has_approval_phase := 'T';

Line 3448: FROM eng_change_statuses

3444:
3445: -- Get the status_type of the new phase
3446: SELECT status_type
3447: INTO l_new_status_type
3448: FROM eng_change_statuses
3449: WHERE status_code = p_status_code;
3450:
3451: -- Demote change header record
3452: UPDATE eng_engineering_changes

Line 3529: FROM eng_change_statuses

3525:
3526: -- Get the status_type of the revised item phase
3527: SELECT status_type
3528: INTO l_ri_status_type
3529: FROM eng_change_statuses
3530: WHERE status_code = l_ri_status_code
3531: AND rownum = 1;
3532:
3533: IF (l_ri_status_type <> G_ENG_IMPLEMENTED

Line 3792: l_new_status_type eng_change_statuses.status_type%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;
3793: l_ri_status_code eng_change_lines.status_code%TYPE;
3794: l_ri_status_type eng_change_statuses.status_type%TYPE;
3795:
3796: l_chg_notice eng_engineering_changes.change_notice%TYPE;

Line 3794: l_ri_status_type eng_change_statuses.status_type%TYPE;

3790: l_last_imp_flag VARCHAR2(1) := 'N';
3791:
3792: l_new_status_type eng_change_statuses.status_type%TYPE;
3793: l_ri_status_code eng_change_lines.status_code%TYPE;
3794: l_ri_status_type eng_change_statuses.status_type%TYPE;
3795:
3796: l_chg_notice eng_engineering_changes.change_notice%TYPE;
3797: l_org_id eng_engineering_changes.organization_id%TYPE;
3798: l_request_id NUMBER;

Line 3876: FROM eng_change_statuses

3872:
3873: -- Get the status_type of the new phase
3874: SELECT status_type
3875: INTO l_new_status_type
3876: FROM eng_change_statuses
3877: WHERE status_code = p_status_code
3878: AND rownum = 1;
3879:
3880: -- Get the max sequence number in the lifecycle

Line 3933: FROM eng_change_statuses

3929: -- Make sure the revised item is not implemented or cancelled
3930: -- Get the status_type of the revised item phase
3931: SELECT status_type
3932: INTO l_ri_status_type
3933: FROM eng_change_statuses
3934: WHERE status_code = l_ri_status_code
3935: AND rownum = 1;
3936:
3937: -- Update only those which are still active

Line 4165: l_new_status_type eng_change_statuses.status_type%TYPE;

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

Line 4170: l_ri_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:
4174: BEGIN

Line 4260: FROM eng_change_statuses

4256:
4257: -- Get the status_type of the new phase
4258: SELECT status_type
4259: INTO l_new_status_type
4260: FROM eng_change_statuses
4261: WHERE status_code = p_status_code;
4262:
4263: -- Make sure the revised item is not implemented or cancelled
4264: -- Get the status_type of the revised item phase

Line 4267: FROM eng_change_statuses

4263: -- Make sure the revised item is not implemented or cancelled
4264: -- Get the status_type of the revised item phase
4265: SELECT status_type
4266: INTO l_ri_status_type
4267: FROM eng_change_statuses
4268: WHERE status_code = l_ri_status_code
4269: AND rownum = 1;
4270:
4271: -- Update only those which are still active

Line 4876: eng_change_statuses s

4872:
4873: CURSOR c_lines IS
4874: SELECT s.status_type
4875: FROM eng_change_lines l,
4876: eng_change_statuses s
4877: WHERE l.change_id = p_change_id
4878: AND s.status_code = l.status_code;
4879: l_line_status_type eng_change_statuses.status_type%TYPE;
4880:

Line 4879: l_line_status_type eng_change_statuses.status_type%TYPE;

4875: FROM eng_change_lines l,
4876: eng_change_statuses s
4877: WHERE l.change_id = p_change_id
4878: AND s.status_code = l.status_code;
4879: l_line_status_type eng_change_statuses.status_type%TYPE;
4880:
4881: l_chg_notice eng_engineering_changes.change_notice%TYPE;
4882: l_org_id eng_engineering_changes.organization_id%TYPE;
4883: l_request_id NUMBER;

Line 4985: FROM eng_change_statuses

4981:
4982: -- Get the current phase status_type
4983: SELECT status_type
4984: INTO l_curr_status_type
4985: FROM eng_change_statuses
4986: WHERE status_code = l_curr_status_code;
4987:
4988: -- Get the current phase's sequence number
4989: SELECT sequence_number

Line 5361: eng_change_statuses chs

5357: -- Get the sequence number of the last phase of type REVIEW/APPROVAL
5358: SELECT max(lcs.sequence_number)
5359: INTO l_max_appr_phase_sn
5360: FROM eng_lifecycle_statuses lcs,
5361: eng_change_statuses chs
5362: WHERE lcs.entity_name = G_ENG_CHANGE
5363: AND lcs.entity_id1 = p_change_id
5364: AND lcs.active_flag = 'Y'
5365: AND chs.status_code = lcs.status_code

Line 5686: FROM eng_change_statuses

5682:
5683: -- get phase type
5684: SELECT status_type
5685: INTO l_status_type
5686: FROM eng_change_statuses
5687: WHERE status_code = p_status_code;
5688: -- check if the phase type is APPROVAL
5689: IF ( l_status_type = G_ENG_APPROVED ) THEN
5690: IF g_debug_flag THEN

Line 5903: FROM eng_change_statuses

5899:
5900: -- get phase type
5901: SELECT status_type
5902: INTO l_status_type
5903: FROM eng_change_statuses
5904: WHERE status_code = p_status_code;
5905: -- check if the phase type is APPROVAL
5906: IF ( l_status_type = G_ENG_APPROVED ) THEN
5907: IF g_debug_flag THEN

Line 6628: eng_change_statuses ecs

6624:
6625: SELECT lcs.status_code, ecs.status_type
6626: INTO l_status_code, l_status_type
6627: FROM eng_lifecycle_statuses lcs,
6628: eng_change_statuses ecs
6629: WHERE lcs.entity_name = G_ENG_CHANGE
6630: AND lcs.entity_id1 = p_change_id
6631: AND lcs.active_flag = 'Y'
6632: AND lcs.sequence_number = l_initial_phase_sn

Line 7386: FROM eng_change_statuses

7382:
7383: -- Get the current phase status_type
7384: SELECT status_type
7385: INTO l_curr_status_type
7386: FROM eng_change_statuses
7387: WHERE status_code = l_reset_status_code;
7388:
7389: --
7390: -- Get the current phase's sequence number