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

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 417: FROM eng_lifecycle_statuses

413: -- Get the sequence_number of the last phase
414: -- Note that only phase of IMPLEMENT type can be the last phase
415: SELECT max(sequence_number)
416: INTO l_max_phase_sn
417: FROM eng_lifecycle_statuses
418: WHERE entity_name = G_ENG_CHANGE
419: AND entity_id1 = p_change_id
420: AND active_flag = 'Y';
421:

Line 425: FROM eng_lifecycle_statuses

421:
422: -- Get the sequence number of the last phase
423: SELECT status_code
424: INTO l_last_status_code
425: FROM eng_lifecycle_statuses
426: WHERE entity_name = G_ENG_CHANGE
427: AND entity_id1 = p_change_id
428: AND active_flag = 'Y'
429: AND sequence_number = l_max_phase_sn;

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 501: FROM eng_lifecycle_statuses

497: -- Get the sequence_number of the last phase
498: -- Note that only phase of IMPLEMENT type can be the last phase
499: SELECT max(sequence_number)
500: INTO l_max_phase_sn
501: FROM eng_lifecycle_statuses
502: WHERE entity_name = G_ENG_CHANGE
503: AND entity_id1 = p_change_id
504: AND active_flag = 'Y';
505:

Line 509: FROM eng_lifecycle_statuses

505:
506: -- Get the start_date of the last phase (to see if it's been used)
507: SELECT status_code, start_date
508: INTO x_last_status_code, l_start_date
509: FROM eng_lifecycle_statuses
510: WHERE entity_name = G_ENG_CHANGE
511: AND entity_id1 = p_change_id
512: AND active_flag = 'Y'
513: AND sequence_number = l_max_phase_sn

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 728: FROM eng_lifecycle_statuses

724:
725: -- Get the current phase's sequence number
726: SELECT sequence_number
727: INTO l_phase_sn
728: FROM eng_lifecycle_statuses
729: WHERE entity_name = G_ENG_CHANGE
730: AND entity_id1 = p_change_id
731: AND status_code = p_status_code
732: AND active_flag = 'Y'

Line 738: FROM eng_lifecycle_statuses lcs,

734:
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'

Line 1303: eng_lifecycle_statuses line_start_after,

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
1306: WHERE route.status_code = Eng_Workflow_Util.G_RT_NOT_STARTED
1307: AND route.route_id = line.route_id

Line 1304: eng_lifecycle_statuses new_status,

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
1306: WHERE route.status_code = Eng_Workflow_Util.G_RT_NOT_STARTED
1307: AND route.route_id = line.route_id
1308: AND s.status_type <> G_ENG_COMPLETED

Line 1305: eng_lifecycle_statuses cur_status

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
1306: WHERE route.status_code = Eng_Workflow_Util.G_RT_NOT_STARTED
1307: AND route.route_id = line.route_id
1308: AND s.status_type <> G_ENG_COMPLETED
1309: AND s.status_type <> G_ENG_IMPLEMENTED

Line 1556: l_wf_route_id eng_lifecycle_statuses.change_wf_route_id%TYPE;

1552: l_fnd_login_id NUMBER := TO_NUMBER(FND_PROFILE.VALUE('LOGIN_ID'));
1553:
1554: l_action_id eng_change_actions.action_id%TYPE;
1555:
1556: l_wf_route_id eng_lifecycle_statuses.change_wf_route_id%TYPE;
1557: l_wf_route_temp_id eng_lifecycle_statuses.change_wf_route_template_id%TYPE;
1558: l_wf_item_key wf_item_activity_statuses.item_key%TYPE := NULL;
1559:
1560: l_chg_notice eng_engineering_changes.change_notice%TYPE;

Line 1557: l_wf_route_temp_id eng_lifecycle_statuses.change_wf_route_template_id%TYPE;

1553:
1554: l_action_id eng_change_actions.action_id%TYPE;
1555:
1556: l_wf_route_id eng_lifecycle_statuses.change_wf_route_id%TYPE;
1557: l_wf_route_temp_id eng_lifecycle_statuses.change_wf_route_template_id%TYPE;
1558: l_wf_item_key wf_item_activity_statuses.item_key%TYPE := NULL;
1559:
1560: l_chg_notice eng_engineering_changes.change_notice%TYPE;
1561: l_org_id eng_engineering_changes.organization_id%TYPE;

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 1772: FROM eng_lifecycle_statuses

1768: END IF;
1769: -- Check if automatic wf start is needed
1770: SELECT change_wf_route_id, change_wf_route_template_id
1771: INTO l_wf_route_id, l_wf_route_temp_id
1772: FROM eng_lifecycle_statuses
1773: WHERE entity_name = G_ENG_CHANGE
1774: AND entity_id1 = p_change_id
1775: AND status_code = p_status_code
1776: AND active_flag = 'Y'

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 1991: l_new_wf_status eng_lifecycle_statuses.workflow_status%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:
1994: l_new_status_type eng_change_statuses.status_type%TYPE;
1995: l_ri_status_type eng_change_statuses.status_type%TYPE;

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 2089: l_wf_status eng_lifecycle_statuses.workflow_status%TYPE;

2085: l_request_id NUMBER := 0;
2086:
2087: l_action_id eng_change_actions.action_id%TYPE;
2088:
2089: l_wf_status eng_lifecycle_statuses.workflow_status%TYPE;
2090: l_wf_route_id eng_lifecycle_statuses.change_wf_route_id%TYPE;
2091: l_new_route_id eng_lifecycle_statuses.change_wf_route_id%TYPE;
2092:
2093: l_found_rev_item VARCHAR2(1) := 'N';

Line 2090: l_wf_route_id eng_lifecycle_statuses.change_wf_route_id%TYPE;

2086:
2087: l_action_id eng_change_actions.action_id%TYPE;
2088:
2089: l_wf_status eng_lifecycle_statuses.workflow_status%TYPE;
2090: l_wf_route_id eng_lifecycle_statuses.change_wf_route_id%TYPE;
2091: l_new_route_id eng_lifecycle_statuses.change_wf_route_id%TYPE;
2092:
2093: l_found_rev_item VARCHAR2(1) := 'N';
2094:

Line 2091: l_new_route_id eng_lifecycle_statuses.change_wf_route_id%TYPE;

2087: l_action_id eng_change_actions.action_id%TYPE;
2088:
2089: l_wf_status eng_lifecycle_statuses.workflow_status%TYPE;
2090: l_wf_route_id eng_lifecycle_statuses.change_wf_route_id%TYPE;
2091: l_new_route_id eng_lifecycle_statuses.change_wf_route_id%TYPE;
2092:
2093: l_found_rev_item VARCHAR2(1) := 'N';
2094:
2095: l_skip_wf VARCHAR2(1) := 'N';

Line 2107: FROM eng_lifecycle_statuses

2103: l_obj_id1 NUMBER := 0;
2104:
2105: CURSOR c_lifecyc IS
2106: SELECT change_wf_route_id
2107: FROM eng_lifecycle_statuses
2108: WHERE entity_name = G_ENG_CHANGE
2109: AND entity_id1 = p_change_id
2110: AND active_flag = 'Y'
2111: and change_wf_route_id is not null;

Line 2221: UPDATE eng_lifecycle_statuses

2217: Write_Debug('After: calling Refresh_WF_Route procedure: ' || l_return_status) ;
2218: END IF;
2219:
2220: -- Update the remaining columns of the phase row
2221: UPDATE eng_lifecycle_statuses
2222: SET start_date = null,
2223: completion_date = null,
2224: last_update_date = sysdate,
2225: last_updated_by = l_fnd_user_id,

Line 2239: FROM eng_lifecycle_statuses

2235:
2236: -- Get the sequence number for the current phase of the change header
2237: SELECT sequence_number, status_code
2238: INTO l_curr_phase_sn, l_curr_status_code
2239: FROM eng_lifecycle_statuses
2240: WHERE entity_name = G_ENG_CHANGE
2241: AND entity_id1 = p_change_id
2242: AND status_code = ( SELECT status_code
2243: FROM eng_engineering_changes

Line 2252: FROM eng_lifecycle_statuses

2248: -- Get the sequence number for the new phase of the change header
2249: -- bug 9577905, add param l_new_wf_status
2250: SELECT sequence_number, workflow_status
2251: INTO l_new_phase_sn, l_new_wf_status
2252: FROM eng_lifecycle_statuses
2253: WHERE entity_name = G_ENG_CHANGE
2254: AND entity_id1 = p_change_id
2255: AND status_code = p_status_code
2256: AND active_flag = 'Y'

Line 2269: FROM eng_lifecycle_statuses

2265:
2266: -- Get the max sequence number in the lifecycle
2267: SELECT max(sequence_number)
2268: INTO l_max_sn
2269: FROM eng_lifecycle_statuses
2270: WHERE entity_name = G_ENG_CHANGE
2271: AND entity_id1 = p_change_id
2272: AND active_flag = 'Y';
2273:

Line 2340: FROM eng_lifecycle_statuses

2336: --
2337: -- Get the sequence_number for line/task's complete_before_status_code
2338: SELECT sequence_number
2339: INTO l_phase_sn
2340: FROM eng_lifecycle_statuses
2341: WHERE entity_name = G_ENG_CHANGE
2342: AND entity_id1 = p_change_id
2343: AND status_code = l_status_code
2344: AND active_flag = 'Y'

Line 2539: UPDATE eng_lifecycle_statuses

2535: -- start_date of implement phase blank in case of CO promotion to
2536: -- implement phase
2537: /*
2538: -- Update start_date of the implement phase
2539: UPDATE eng_lifecycle_statuses
2540: SET start_date = sysdate,
2541: completion_date = null,
2542: last_update_date = sysdate,
2543: last_updated_by = l_fnd_user_id,

Line 2555: FROM eng_lifecycle_statuses

2551:
2552: -- If the CO's last implement type phase is already used, refresh its workflow id and status
2553: SELECT workflow_status, change_wf_route_id
2554: INTO l_wf_status, l_wf_route_id
2555: FROM eng_lifecycle_statuses
2556: WHERE entity_name = G_ENG_CHANGE
2557: AND entity_id1 = p_change_id
2558: AND status_code = p_status_code
2559: AND active_flag = 'Y'

Line 2575: UPDATE eng_lifecycle_statuses

2571: P_API_CALLER => p_api_caller
2572: );
2573:
2574: -- refresh imp phase row
2575: UPDATE eng_lifecycle_statuses
2576: SET change_wf_route_id = l_new_route_id,
2577: workflow_status = Eng_Workflow_Util.G_RT_NOT_STARTED,
2578: last_update_date = sysdate,
2579: last_updated_by = l_fnd_user_id,

Line 2623: UPDATE eng_lifecycle_statuses

2619:
2620: ELSE
2621: -- Normal phase promotion
2622: -- Complete the current phase
2623: UPDATE eng_lifecycle_statuses
2624: SET completion_date = sysdate,
2625: last_update_date = sysdate,
2626: last_updated_by = l_fnd_user_id,
2627: last_update_login = l_fnd_login_id

Line 2633: Write_Debug('After updating eng_lifecycle_statuses.completion_date.');

2629: AND entity_id1 = p_change_id
2630: AND status_code = l_curr_status_code
2631: AND active_flag = 'Y';
2632: IF g_debug_flag THEN
2633: Write_Debug('After updating eng_lifecycle_statuses.completion_date.');
2634: Write_Debug(' Row count = ' || SQL%ROWCOUNT);
2635: END IF;
2636: -- Sanity check, only one record can qualify the condition
2637: IF SQL%ROWCOUNT <> 1 THEN

Line 2705: FROM eng_lifecycle_statuses

2701: -- Note: moved this query inside this IF block because cancel
2702: -- status is not in the regular lifecycle phase definitions
2703: SELECT sequence_number
2704: INTO l_ri_phase_sn
2705: FROM eng_lifecycle_statuses
2706: WHERE entity_name = G_ENG_CHANGE
2707: AND entity_id1 = p_change_id
2708: AND status_code = l_ri_status_code
2709: AND active_flag = 'Y'

Line 2739: UPDATE eng_lifecycle_statuses

2735: END IF;
2736:
2737: -- Update the new phase's start_date
2738: -- Bug 13810488: In some cases, completion_date is not null and which is earlier than start_date
2739: UPDATE eng_lifecycle_statuses
2740: SET start_date = sysdate,
2741: completion_date = null, -- Bug 13810488
2742: last_update_date = sysdate,
2743: last_updated_by = l_fnd_user_id,

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 3162: FROM eng_lifecycle_statuses

3158:
3159: -- Cursor to get all lifecycle phases between (inclusive) [demotionStatus, currentStatus]
3160: CURSOR c_lcStatuses IS
3161: SELECT *
3162: FROM eng_lifecycle_statuses
3163: WHERE entity_name = G_ENG_CHANGE
3164: AND entity_id1 = p_change_id
3165: AND active_flag = 'Y'
3166: AND sequence_number >= l_new_phase_sn

Line 3176: FROM eng_lifecycle_statuses

3172:
3173: -- Cursor to get all lifecycle phases between (inclusive) [demotionStatus, maxStatus]
3174: CURSOR c_lcStatusesToMax IS
3175: SELECT *
3176: FROM eng_lifecycle_statuses
3177: WHERE entity_name = G_ENG_CHANGE
3178: AND entity_id1 = p_change_id
3179: AND active_flag = 'Y'
3180: AND sequence_number >= l_new_phase_sn

Line 3182: l_lcStatuses_row eng_lifecycle_statuses%ROWTYPE;

3178: AND entity_id1 = p_change_id
3179: AND active_flag = 'Y'
3180: AND sequence_number >= l_new_phase_sn
3181: FOR UPDATE;
3182: l_lcStatuses_row eng_lifecycle_statuses%ROWTYPE;
3183: l_old_iter_num eng_lifecycle_statuses.iteration_number%TYPE := -1;
3184: l_old_row_id NUMBER;
3185: l_new_row_id NUMBER;
3186: l_new_route_id NUMBER;

Line 3183: l_old_iter_num eng_lifecycle_statuses.iteration_number%TYPE := -1;

3179: AND active_flag = 'Y'
3180: AND sequence_number >= l_new_phase_sn
3181: FOR UPDATE;
3182: l_lcStatuses_row eng_lifecycle_statuses%ROWTYPE;
3183: l_old_iter_num eng_lifecycle_statuses.iteration_number%TYPE := -1;
3184: l_old_row_id NUMBER;
3185: l_new_row_id NUMBER;
3186: l_new_route_id NUMBER;
3187:

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 3217: FROM eng_lifecycle_statuses

3213: l_obj_id1 NUMBER := 0;
3214:
3215: CURSOR c_lifecyc IS
3216: SELECT change_wf_route_id
3217: FROM eng_lifecycle_statuses
3218: WHERE entity_name = G_ENG_CHANGE
3219: AND entity_id1 = p_change_id
3220: AND active_flag = 'Y'
3221: and change_wf_route_id is not null;

Line 3315: FROM eng_lifecycle_statuses

3311:
3312: -- Get the sequence number for the current phase of the change header
3313: SELECT sequence_number
3314: INTO l_curr_phase_sn
3315: FROM eng_lifecycle_statuses
3316: WHERE entity_name = G_ENG_CHANGE
3317: AND entity_id1 = p_change_id
3318: AND active_flag = 'Y'
3319: AND status_code = ( SELECT status_code

Line 3327: FROM eng_lifecycle_statuses

3323:
3324: -- Get the sequence number for the new phase of the change header
3325: SELECT sequence_number
3326: INTO l_new_phase_sn
3327: FROM eng_lifecycle_statuses
3328: WHERE entity_name = G_ENG_CHANGE
3329: AND entity_id1 = p_change_id
3330: AND status_code = p_status_code
3331: AND active_flag = 'Y'

Line 3346: UPDATE eng_lifecycle_statuses

3342: RAISE FND_API.G_EXC_ERROR;
3343: END IF;
3344:
3345: -- Finish the current phase before demotion
3346: UPDATE eng_lifecycle_statuses
3347: SET completion_date = sysdate,
3348: last_update_date = sysdate,
3349: last_updated_by = l_fnd_user_id,
3350: last_update_login = l_fnd_login_id

Line 3360: Write_Debug('After updating eng_lifecycle_statuses.completion_date.');

3356: WHERE change_id = p_change_id)
3357: AND sequence_number = l_curr_phase_sn
3358: AND rownum = 1;
3359: IF g_debug_flag THEN
3360: Write_Debug('After updating eng_lifecycle_statuses.completion_date.');
3361: Write_Debug(' Row count = ' || SQL%ROWCOUNT);
3362: END IF;
3363:
3364:

Line 3408: UPDATE eng_lifecycle_statuses

3404: l_has_approval_phase := 'T';
3405: END IF;
3406:
3407: -- Obsolete (but not delete) the old phase row
3408: UPDATE eng_lifecycle_statuses
3409: SET active_flag = 'N',
3410: last_update_date = sysdate,
3411: last_updated_by = l_fnd_user_id,
3412: last_update_login = l_fnd_login_id

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 3478: INSERT INTO eng_lifecycle_statuses

3474: END IF;
3475:
3476: -- Insert the new phase row
3477: /* Only Oracle 9.2+ supports this directly row insertion feature
3478: INSERT INTO eng_lifecycle_statuses
3479: VALUES l_lcStatuses_row;
3480: */
3481: INSERT INTO eng_lifecycle_statuses
3482: ( CHANGE_LIFECYCLE_STATUS_ID,

Line 3481: INSERT INTO eng_lifecycle_statuses

3477: /* Only Oracle 9.2+ supports this directly row insertion feature
3478: INSERT INTO eng_lifecycle_statuses
3479: VALUES l_lcStatuses_row;
3480: */
3481: INSERT INTO eng_lifecycle_statuses
3482: ( CHANGE_LIFECYCLE_STATUS_ID,
3483: ENTITY_NAME,
3484: ENTITY_ID1,
3485: ENTITY_ID2,

Line 3553: UPDATE eng_lifecycle_statuses

3549: END IF;
3550: l_old_iter_num := l_lcStatuses_row.iteration_number;
3551:
3552: -- Increment sequence number of the active phases
3553: UPDATE eng_lifecycle_statuses
3554: SET iteration_number = l_old_iter_num + 1,
3555: last_update_date = sysdate,
3556: last_updated_by = l_fnd_user_id,
3557: last_update_login = l_fnd_login_id

Line 3659: FROM eng_lifecycle_statuses

3655: -- Note: moved this query inside this IF block because cancel
3656: -- status is not in the regular lifecycle phase definitions
3657: SELECT sequence_number
3658: INTO l_ri_phase_sn
3659: FROM eng_lifecycle_statuses
3660: WHERE entity_name = G_ENG_CHANGE
3661: AND entity_id1 = p_change_id
3662: AND status_code = l_ri_status_code
3663: AND active_flag = 'Y'

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 3972: FROM eng_lifecycle_statuses

3968:
3969: -- Get the sequence number for the current phase of the revised item
3970: SELECT sequence_number, status_code
3971: INTO l_ri_phase_sn, l_ri_status_code
3972: FROM eng_lifecycle_statuses
3973: WHERE entity_name = G_ENG_CHANGE
3974: AND entity_id1 = p_change_id
3975: AND status_code = ( SELECT status_code
3976: FROM eng_revised_items

Line 3984: FROM eng_lifecycle_statuses

3980:
3981: -- Get the sequence number for the new phase of the revised item
3982: SELECT sequence_number
3983: INTO l_new_phase_sn
3984: FROM eng_lifecycle_statuses
3985: WHERE entity_name = G_ENG_CHANGE
3986: AND entity_id1 = p_change_id
3987: AND status_code = p_status_code
3988: AND active_flag = 'Y'

Line 4001: FROM eng_lifecycle_statuses

3997:
3998: -- Get the max sequence number in the lifecycle
3999: SELECT max(sequence_number)
4000: INTO l_max_sn
4001: FROM eng_lifecycle_statuses
4002: WHERE entity_name = G_ENG_CHANGE
4003: AND entity_id1 = p_change_id
4004: AND active_flag = 'Y';
4005:

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 4345: FROM eng_lifecycle_statuses

4341: -- Real code starts here -----------------------------------------------
4342: -- Get the sequence number for the current phase of the change header
4343: SELECT sequence_number, status_code
4344: INTO l_ri_phase_sn, l_ri_status_code
4345: FROM eng_lifecycle_statuses
4346: WHERE entity_name = G_ENG_CHANGE
4347: AND entity_id1 = p_change_id
4348: AND active_flag = 'Y'
4349: AND status_code = ( SELECT status_code

Line 4357: FROM eng_lifecycle_statuses

4353:
4354: -- Get the sequence number for the new phase of the change header
4355: SELECT sequence_number
4356: INTO l_new_phase_sn
4357: FROM eng_lifecycle_statuses
4358: WHERE entity_name = G_ENG_CHANGE
4359: AND entity_id1 = p_change_id
4360: AND status_code = p_status_code
4361: AND active_flag = 'Y'

Line 4428: FROM eng_lifecycle_statuses

4424:
4425: -- Get the sequence number for the current phase of the change header
4426: SELECT sequence_number
4427: INTO l_curr_phase_sn
4428: FROM eng_lifecycle_statuses
4429: WHERE entity_name = G_ENG_CHANGE
4430: AND entity_id1 = p_change_id
4431: AND active_flag = 'Y'
4432: AND status_code = ( SELECT status_code

Line 4593: l_wf_route_id eng_lifecycle_statuses.change_wf_route_id%TYPE;

4589: l_msg_data VARCHAR2(2000);
4590:
4591: l_curr_status_code eng_engineering_changes.status_code%TYPE;
4592: l_curr_status_type eng_engineering_changes.status_type%TYPE;
4593: l_wf_route_id eng_lifecycle_statuses.change_wf_route_id%TYPE;
4594: l_wf_status eng_lifecycle_statuses.workflow_status%TYPE;
4595: BEGIN
4596: -- Standard Start of API savepoint
4597: SAVEPOINT Change_Phase;

Line 4594: l_wf_status eng_lifecycle_statuses.workflow_status%TYPE;

4590:
4591: l_curr_status_code eng_engineering_changes.status_code%TYPE;
4592: l_curr_status_type eng_engineering_changes.status_type%TYPE;
4593: l_wf_route_id eng_lifecycle_statuses.change_wf_route_id%TYPE;
4594: l_wf_status eng_lifecycle_statuses.workflow_status%TYPE;
4595: BEGIN
4596: -- Standard Start of API savepoint
4597: SAVEPOINT Change_Phase;
4598: -- Standard call to check for call compatibility

Line 4648: FROM eng_lifecycle_statuses

4644:
4645: -- Get the workflow route id and status for the current phase
4646: SELECT change_wf_route_id, workflow_status
4647: INTO l_wf_route_id, l_wf_status
4648: FROM eng_lifecycle_statuses
4649: WHERE entity_name = G_ENG_CHANGE
4650: AND entity_id1 = p_change_id
4651: AND status_code = l_curr_status_code
4652: AND active_flag = 'Y'

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 4983: l_last_wf_route_id eng_lifecycle_statuses.change_wf_route_id%TYPE;

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;
4986: l_max_appr_phase_sn eng_lifecycle_statuses.sequence_number%TYPE;
4987: l_max_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 5113: FROM eng_lifecycle_statuses

5109:
5110: -- Get the current phase's sequence number
5111: SELECT sequence_number
5112: INTO l_curr_phase_sn
5113: FROM eng_lifecycle_statuses
5114: WHERE entity_name = G_ENG_CHANGE
5115: AND entity_id1 = p_change_id
5116: AND status_code = l_curr_status_code
5117: AND active_flag = 'Y'

Line 5124: FROM eng_lifecycle_statuses

5120: -- Get the sequence_number of the last phase
5121: -- Note that only phase of IMPLEMENT type can be the last phase
5122: SELECT max(sequence_number)
5123: INTO l_max_phase_sn
5124: FROM eng_lifecycle_statuses
5125: WHERE entity_name = G_ENG_CHANGE
5126: AND entity_id1 = p_change_id
5127: AND active_flag = 'Y';
5128:

Line 5132: FROM eng_lifecycle_statuses

5128:
5129: -- Get the sequence number of the last phase
5130: SELECT status_code, change_wf_route_id
5131: INTO l_last_status_code, l_last_wf_route_id
5132: FROM eng_lifecycle_statuses
5133: WHERE entity_name = G_ENG_CHANGE
5134: AND entity_id1 = p_change_id
5135: AND active_flag = 'Y'
5136: AND sequence_number = l_max_phase_sn;

Line 5153: UPDATE eng_lifecycle_statuses

5149: Write_Debug('In block: case (special) last implement phase of ECO: workflow completion.');
5150: END IF;
5151:
5152: -- Update the current phase's workflow status
5153: UPDATE eng_lifecycle_statuses
5154: SET workflow_status = p_route_status,
5155: completion_date = sysdate, -- newly added for 3479509 fix (launch wf after implementation)
5156: last_update_date = sysdate,
5157: last_updated_by = l_fnd_user_id,

Line 5165: Write_Debug('After updating eng_lifecycle_statuses.workflow_status.');

5161: AND status_code = l_next_status_code
5162: AND active_flag = 'Y'
5163: AND rownum = 1;
5164: IF g_debug_flag THEN
5165: Write_Debug('After updating eng_lifecycle_statuses.workflow_status.');
5166: Write_Debug(' Row count = ' || SQL%ROWCOUNT);
5167: END IF;
5168:
5169: -- Bug 5989058.

Line 5417: UPDATE eng_lifecycle_statuses

5413: Write_Debug('Case 1: no workflow or workflow is approved');
5414: END IF;
5415:
5416: -- Update the current phase's workflow status
5417: UPDATE eng_lifecycle_statuses
5418: SET workflow_status = p_route_status,
5419: last_update_date = sysdate,
5420: last_updated_by = l_fnd_user_id,
5421: last_update_login = l_fnd_login_id

Line 5428: Write_Debug('After updating eng_lifecycle_statuses.workflow_status.');

5424: AND status_code = l_curr_status_code
5425: AND active_flag = 'Y'
5426: AND rownum = 1;
5427: IF g_debug_flag THEN
5428: Write_Debug('After updating eng_lifecycle_statuses.workflow_status.');
5429: Write_Debug(' Row count = ' || SQL%ROWCOUNT);
5430: END IF;
5431:
5432: -- IF the current phase is the last one, also update its completion date

Line 5436: UPDATE eng_lifecycle_statuses

5432: -- IF the current phase is the last one, also update its completion date
5433: -- Otherwise leave it for promote_header and demote_header procedures
5434: -- to set the completion_date
5435: IF (l_curr_phase_sn = l_max_phase_sn) THEN
5436: UPDATE eng_lifecycle_statuses
5437: SET completion_date = sysdate,
5438: last_update_date = sysdate,
5439: last_updated_by = l_fnd_user_id,
5440: last_update_login = l_fnd_login_id

Line 5467: Write_Debug('After updating eng_lifecycle_statuses.completion_date.');

5463: NULL;
5464: END;
5465:
5466: IF g_debug_flag THEN
5467: Write_Debug('After updating eng_lifecycle_statuses.completion_date.');
5468: Write_Debug(' Row count = ' || SQL%ROWCOUNT);
5469: END IF;
5470: END IF;
5471:

Line 5522: FROM eng_lifecycle_statuses lcs,

5518:
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'

Line 5722: FROM eng_lifecycle_statuses

5718: Write_Debug('promote_status_code is NULL');
5719: END IF;
5720: SELECT auto_promote_status
5721: INTO l_next_status_code
5722: FROM eng_lifecycle_statuses
5723: WHERE entity_name = G_ENG_CHANGE
5724: AND entity_id1 = p_change_id
5725: AND status_code = l_curr_status_code
5726: AND active_flag = 'Y'

Line 5797: UPDATE eng_lifecycle_statuses

5793: Write_Debug('Case 2: workflow is rejected');
5794: END IF;
5795:
5796: -- Update lifecycle table
5797: UPDATE eng_lifecycle_statuses
5798: SET workflow_status = p_route_status,
5799: last_update_date = sysdate,
5800: last_updated_by = l_fnd_user_id,
5801: last_update_login = l_fnd_login_id

Line 5808: Write_Debug('After updating eng_lifecycle_statuses.workflow_status.');

5804: AND status_code = l_curr_status_code
5805: AND active_flag = 'Y'
5806: AND rownum = 1;
5807: IF g_debug_flag THEN
5808: Write_Debug('After updating eng_lifecycle_statuses.workflow_status.');
5809: Write_Debug(' Row count = ' || SQL%ROWCOUNT);
5810: END IF;
5811:
5812: IF g_debug_flag THEN

Line 5819: FROM eng_lifecycle_statuses

5815:
5816: -- Get the auto demotion phase for the current phase of the change header
5817: SELECT auto_demote_status
5818: INTO l_next_status_code
5819: FROM eng_lifecycle_statuses
5820: WHERE entity_name = G_ENG_CHANGE
5821: AND entity_id1 = p_change_id
5822: AND status_code = l_curr_status_code
5823: AND active_flag = 'Y'

Line 5960: UPDATE eng_lifecycle_statuses

5956: Write_Debug('Case 3: workflow ends with unexpected status');
5957: END IF;
5958:
5959: -- Update lifecycle table
5960: UPDATE eng_lifecycle_statuses
5961: SET workflow_status = p_route_status,
5962: last_update_date = sysdate,
5963: last_updated_by = l_fnd_user_id,
5964: last_update_login = l_fnd_login_id

Line 5971: Write_Debug('After updating eng_lifecycle_statuses.workflow_status.');

5967: AND status_code = l_curr_status_code
5968: AND active_flag = 'Y'
5969: AND rownum = 1;
5970: IF g_debug_flag THEN
5971: Write_Debug('After updating eng_lifecycle_statuses.workflow_status.');
5972: Write_Debug(' Row count = ' || SQL%ROWCOUNT);
5973: END IF;
5974:
5975:

Line 5988: Write_Debug('After updating eng_lifecycle_statuses.promote_status_code.');

5984: last_updated_by = l_fnd_user_id,
5985: last_update_login = l_fnd_login_id
5986: WHERE change_id = p_change_id;
5987: IF g_debug_flag THEN
5988: Write_Debug('After updating eng_lifecycle_statuses.promote_status_code.');
5989: Write_Debug(' Row count = ' || SQL%ROWCOUNT);
5990: END IF;
5991:
5992: IF g_debug_flag THEN

Line 6045: UPDATE eng_lifecycle_statuses

6041: FND_MSG_PUB.Add;
6042: RAISE FND_API.G_EXC_ERROR;
6043: END IF;
6044: -- update phase workflow status
6045: UPDATE eng_lifecycle_statuses
6046: SET workflow_status = p_route_status,
6047: last_update_date = sysdate,
6048: last_updated_by = l_fnd_user_id,
6049: last_update_login = l_fnd_login_id

Line 6055: Write_Debug('After updating eng_lifecycle_statuses.workflow_status.');

6051: AND entity_id1 = p_change_id
6052: AND status_code = p_status_code
6053: AND active_flag = 'Y';
6054: IF g_debug_flag THEN
6055: Write_Debug('After updating eng_lifecycle_statuses.workflow_status.');
6056: Write_Debug(' Row count = ' || SQL%ROWCOUNT);
6057: END IF;
6058:
6059: -- update header approval status to "submitted" if the p_status_code passed

Line 6443: FROM eng_lifecycle_statuses

6439: l_fnd_login_id NUMBER := TO_NUMBER(FND_PROFILE.VALUE('LOGIN_ID'));
6440:
6441: CURSOR c_currPhase IS
6442: SELECT *
6443: FROM eng_lifecycle_statuses
6444: WHERE entity_name = G_ENG_CHANGE
6445: AND entity_id1 = p_change_id
6446: AND status_code = p_status_code
6447: AND active_flag = 'Y'

Line 6450: l_phase_row eng_lifecycle_statuses%ROWTYPE;

6446: AND status_code = p_status_code
6447: AND active_flag = 'Y'
6448: FOR UPDATE;
6449: l_row_counter NUMBER := 0;
6450: l_phase_row eng_lifecycle_statuses%ROWTYPE;
6451: l_wf_route_id eng_lifecycle_statuses.change_wf_route_id%TYPE;
6452: l_wf_route_id_new eng_lifecycle_statuses.change_wf_route_id%TYPE;
6453: l_wf_status eng_lifecycle_statuses.workflow_status%TYPE;
6454:

Line 6451: l_wf_route_id eng_lifecycle_statuses.change_wf_route_id%TYPE;

6447: AND active_flag = 'Y'
6448: FOR UPDATE;
6449: l_row_counter NUMBER := 0;
6450: l_phase_row eng_lifecycle_statuses%ROWTYPE;
6451: l_wf_route_id eng_lifecycle_statuses.change_wf_route_id%TYPE;
6452: l_wf_route_id_new eng_lifecycle_statuses.change_wf_route_id%TYPE;
6453: l_wf_status eng_lifecycle_statuses.workflow_status%TYPE;
6454:
6455: BEGIN

Line 6452: l_wf_route_id_new eng_lifecycle_statuses.change_wf_route_id%TYPE;

6448: FOR UPDATE;
6449: l_row_counter NUMBER := 0;
6450: l_phase_row eng_lifecycle_statuses%ROWTYPE;
6451: l_wf_route_id eng_lifecycle_statuses.change_wf_route_id%TYPE;
6452: l_wf_route_id_new eng_lifecycle_statuses.change_wf_route_id%TYPE;
6453: l_wf_status eng_lifecycle_statuses.workflow_status%TYPE;
6454:
6455: BEGIN
6456: -- Standard Start of API savepoint

Line 6453: l_wf_status eng_lifecycle_statuses.workflow_status%TYPE;

6449: l_row_counter NUMBER := 0;
6450: l_phase_row eng_lifecycle_statuses%ROWTYPE;
6451: l_wf_route_id eng_lifecycle_statuses.change_wf_route_id%TYPE;
6452: l_wf_route_id_new eng_lifecycle_statuses.change_wf_route_id%TYPE;
6453: l_wf_status eng_lifecycle_statuses.workflow_status%TYPE;
6454:
6455: BEGIN
6456: -- Standard Start of API savepoint
6457: SAVEPOINT Refresh_WF_Route;

Line 6547: UPDATE eng_lifecycle_statuses

6543: P_USER_ID => l_fnd_user_id,
6544: P_API_CALLER => p_api_caller
6545: );
6546: -- Replace the old id with the new id
6547: UPDATE eng_lifecycle_statuses
6548: SET change_wf_route_id = l_wf_route_id_new,
6549: workflow_status = ENG_WORKFLOW_UTIL.G_RT_NOT_STARTED,
6550: last_update_date = sysdate,
6551: last_updated_by = l_fnd_user_id,

Line 6564: UPDATE eng_lifecycle_statuses

6560: ELSE
6561: IF g_debug_flag THEN
6562: Write_Debug('Branch: p_route_id is not null') ;
6563: END IF;
6564: UPDATE eng_lifecycle_statuses
6565: SET change_wf_route_id = p_wf_route_id,
6566: workflow_status = ENG_WORKFLOW_UTIL.G_RT_NOT_STARTED,
6567: last_update_date = sysdate,
6568: last_updated_by = l_fnd_user_id,

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 6692: l_wf_route_id eng_lifecycle_statuses.change_wf_route_id%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;
6696: l_next_status eng_lifecycle_statuses.workflow_status%TYPE;

Line 6694: l_next_status_code eng_lifecycle_statuses.auto_promote_status%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;
6696: l_next_status eng_lifecycle_statuses.workflow_status%TYPE;
6697: -- bug 9577905, end
6698:

Line 6695: l_workflow_status eng_lifecycle_statuses.workflow_status%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;
6696: l_next_status eng_lifecycle_statuses.workflow_status%TYPE;
6697: -- bug 9577905, end
6698:
6699: l_pls_block VARCHAR2(5000);

Line 6696: l_next_status eng_lifecycle_statuses.workflow_status%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;
6696: l_next_status eng_lifecycle_statuses.workflow_status%TYPE;
6697: -- bug 9577905, end
6698:
6699: l_pls_block VARCHAR2(5000);
6700: l_message_list Error_Handler.Error_Tbl_Type; --Bug 11825003

Line 6789: FROM eng_lifecycle_statuses

6785: -- Get the first phase from the change header's lifecycle definition
6786: -- In R12, added p_init_status_code condition here
6787: SELECT min(sequence_number)
6788: INTO l_initial_phase_sn
6789: FROM eng_lifecycle_statuses
6790: WHERE entity_name = G_ENG_CHANGE
6791: AND entity_id1 = p_change_id
6792: AND active_flag = 'Y'
6793: AND (status_code = p_init_status_code OR p_init_status_code IS NULL) ;

Line 6801: FROM eng_lifecycle_statuses lcs,

6797: begin
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'

Line 6841: FROM eng_lifecycle_statuses lcs

6837: END IF;
6838:
6839: SELECT lcs.workflow_status
6840: INTO l_next_status
6841: FROM eng_lifecycle_statuses lcs
6842: WHERE lcs.entity_name = G_ENG_CHANGE
6843: AND lcs.entity_id1 = p_change_id
6844: AND lcs.active_flag = 'Y'
6845: AND lcs.status_code = l_next_status_code;

Line 6931: FROM eng_lifecycle_statuses

6927:
6928: -- Get the sequence number for the current phase
6929: SELECT sequence_number, change_wf_route_id
6930: INTO l_sequence_number, l_wf_route_id
6931: FROM eng_lifecycle_statuses
6932: WHERE entity_name = G_ENG_CHANGE
6933: AND entity_id1 = p_change_id
6934: AND active_flag = 'Y'
6935: AND status_code = l_status_code;

Line 6961: UPDATE eng_lifecycle_statuses

6957: END IF;
6958: END IF;
6959:
6960: -- Initialize workflow_status for all phases that have workflows
6961: UPDATE eng_lifecycle_statuses
6962: SET workflow_status = Eng_Workflow_Util.G_RT_NOT_STARTED,
6963: last_update_date = sysdate,
6964: last_updated_by = l_fnd_user_id,
6965: last_update_login = l_fnd_login_id

Line 6971: Write_Debug('After updating eng_lifecycle_statuses.workflow_status.');

6967: AND entity_id1 = p_change_id
6968: AND active_flag = 'Y'
6969: AND change_wf_route_id IS NOT NULL;
6970: IF g_debug_flag THEN
6971: Write_Debug('After updating eng_lifecycle_statuses.workflow_status.');
6972: Write_Debug(' Row count = ' || SQL%ROWCOUNT);
6973: END IF;
6974:
6975: IF g_debug_flag THEN

Line 6980: UPDATE eng_lifecycle_statuses

6976: Write_Debug('After: Initialize workflow_status for all phases that have workflows');
6977: END IF;
6978:
6979: -- Update current phase row
6980: UPDATE eng_lifecycle_statuses
6981: SET start_date = sysdate,
6982: last_update_date = sysdate,
6983: last_updated_by = l_fnd_user_id,
6984: last_update_login = l_fnd_login_id

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 7684: -- FROM eng_lifecycle_statuses

7680: --
7681: -- Get the current phase's sequence number
7682: -- SELECT sequence_number
7683: -- INTO l_curr_phase_sn
7684: -- FROM eng_lifecycle_statuses
7685: -- WHERE entity_name = G_ENG_CHANGE
7686: -- AND entity_id1 = p_change_id
7687: -- AND status_code = l_reset_status_code
7688: -- AND active_flag = 'Y'

Line 8008: FROM eng_lifecycle_statuses

8004: , AUTO_DEMOTE_STATUS
8005: , CHANGE_EDITABLE_FLAG
8006: , CHANGE_WF_ROUTE_ID
8007: , ENTITY_ID1 CHANGE_TYPE_ID
8008: FROM eng_lifecycle_statuses
8009: WHERE entity_name = 'ENG_CHANGE_TYPE'
8010: AND entity_id1 = c_change_type_id
8011: ORDER BY SEQUENCE_NUMBER ASC ;
8012:

Line 8078: INSERT INTO ENG_LIFECYCLE_STATUSES

8074: END IF ;
8075:
8076: -- Insert the statuses data if it does not exists in change objects that have not gone past the phase
8077: -- and the phase does not exist in lifecycle of the change objects
8078: INSERT INTO ENG_LIFECYCLE_STATUSES
8079: ( CHANGE_LIFECYCLE_STATUS_ID
8080: , ENTITY_NAME
8081: , ENTITY_ID1
8082: , ENTITY_ID2

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 8130: , ENG_LIFECYCLE_STATUSES cur_phase

8126: , cur_phase.ITERATION_NUMBER
8127: , 'S'
8128: , change_type.CHANGE_WF_ROUTE_ID
8129: FROM ENG_ENGINEERING_CHANGES ch
8130: , ENG_LIFECYCLE_STATUSES cur_phase
8131: , ENG_LIFECYCLE_STATUSES change_type
8132: WHERE change_type.entity_id1 = p_change_type_id
8133: AND change_type.entity_name = 'ENG_CHANGE_TYPE'
8134: AND ch.CHANGE_ORDER_TYPE_ID = change_type.entity_id1

Line 8131: , ENG_LIFECYCLE_STATUSES change_type

8127: , 'S'
8128: , change_type.CHANGE_WF_ROUTE_ID
8129: FROM ENG_ENGINEERING_CHANGES ch
8130: , ENG_LIFECYCLE_STATUSES cur_phase
8131: , ENG_LIFECYCLE_STATUSES change_type
8132: WHERE change_type.entity_id1 = p_change_type_id
8133: AND change_type.entity_name = 'ENG_CHANGE_TYPE'
8134: AND ch.CHANGE_ORDER_TYPE_ID = change_type.entity_id1
8135: AND ch.STATUS_TYPE NOT IN (0, 5, 6, 11) -- exclude draft, cancel, implemented, completed

Line 8143: FROM ENG_LIFECYCLE_STATUSES change_lc_phase

8139: AND cur_phase.active_flag = 'Y'
8140: AND cur_phase.status_code = ch.STATUS_CODE
8141: AND cur_phase.SEQUENCE_NUMBER < change_type.SEQUENCE_NUMBER
8142: AND NOT EXISTS ( SELECT 'exists'
8143: FROM ENG_LIFECYCLE_STATUSES change_lc_phase
8144: WHERE change_lc_phase.entity_name = G_ENG_CHANGE
8145: AND change_lc_phase.entity_id1 = ch.CHANGE_ID
8146: AND change_lc_phase.active_flag = 'Y'
8147: AND change_lc_phase.status_code = change_type.STATUS_CODE

Line 8164: INSERT INTO ENG_LIFECYCLE_STATUSES

8160: Write_Debug(' Add LC Phase for Draft Change Objects. . .') ;
8161: END IF ;
8162:
8163: -- Add LC Phase for Draft Change Objects
8164: INSERT INTO ENG_LIFECYCLE_STATUSES
8165: ( CHANGE_LIFECYCLE_STATUS_ID
8166: , ENTITY_NAME
8167: , ENTITY_ID1
8168: , ENTITY_ID2

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

Line 8216: , ENG_LIFECYCLE_STATUSES change_type

8212: , 0 -- ITERATION_NUMBER
8213: , 'S' -- ACTIVE_FLAG
8214: , change_type.CHANGE_WF_ROUTE_ID
8215: FROM ENG_ENGINEERING_CHANGES ch
8216: , ENG_LIFECYCLE_STATUSES change_type
8217: WHERE change_type.entity_id1 = p_change_type_id
8218: AND change_type.entity_name = 'ENG_CHANGE_TYPE'
8219: AND ch.CHANGE_ORDER_TYPE_ID = change_type.entity_id1
8220: AND ch.STATUS_CODE = 0 -- DRAFT

Line 8222: FROM ENG_LIFECYCLE_STATUSES change_lc_phase

8218: AND change_type.entity_name = 'ENG_CHANGE_TYPE'
8219: AND ch.CHANGE_ORDER_TYPE_ID = change_type.entity_id1
8220: AND ch.STATUS_CODE = 0 -- DRAFT
8221: AND NOT EXISTS ( SELECT 'exists'
8222: FROM ENG_LIFECYCLE_STATUSES change_lc_phase
8223: WHERE change_lc_phase.entity_name = G_ENG_CHANGE
8224: AND change_lc_phase.entity_id1 = ch.CHANGE_ID
8225: AND change_lc_phase.active_flag = 'Y'
8226: AND change_lc_phase.status_code = change_type.STATUS_CODE

Line 8265: , ENG_LIFECYCLE_STATUSES lc_phase_setup

8261: , SYSDATE
8262: , l_fnd_user_id
8263: , l_fnd_login_id
8264: FROM ENG_STATUS_PROPERTIES phase_prop_setup
8265: , ENG_LIFECYCLE_STATUSES lc_phase_setup
8266: , ENG_LIFECYCLE_STATUSES lc_phase
8267: , ENG_ENGINEERING_CHANGES ch
8268: WHERE lc_phase_setup.entity_id1 = p_change_type_id
8269: AND lc_phase_setup.entity_name = 'ENG_CHANGE_TYPE'

Line 8266: , ENG_LIFECYCLE_STATUSES lc_phase

8262: , l_fnd_user_id
8263: , l_fnd_login_id
8264: FROM ENG_STATUS_PROPERTIES phase_prop_setup
8265: , ENG_LIFECYCLE_STATUSES lc_phase_setup
8266: , ENG_LIFECYCLE_STATUSES lc_phase
8267: , ENG_ENGINEERING_CHANGES ch
8268: WHERE lc_phase_setup.entity_id1 = p_change_type_id
8269: AND lc_phase_setup.entity_name = 'ENG_CHANGE_TYPE'
8270: AND phase_prop_setup.CHANGE_LIFECYCLE_STATUS_ID = lc_phase_setup.CHANGE_LIFECYCLE_STATUS_ID

Line 8306: UPDATE ENG_LIFECYCLE_STATUSES

8302: Write_Debug(' Removing a Phase. . .') ;
8303: END IF ;
8304:
8305:
8306: UPDATE ENG_LIFECYCLE_STATUSES
8307: SET ACTIVE_FLAG = 'D'
8308: WHERE CHANGE_LIFECYCLE_STATUS_ID IN (
8309: SELECT change_phase.CHANGE_LIFECYCLE_STATUS_ID
8310: FROM ENG_ENGINEERING_CHANGES ch

Line 8311: , ENG_LIFECYCLE_STATUSES cur_phase

8307: SET ACTIVE_FLAG = 'D'
8308: WHERE CHANGE_LIFECYCLE_STATUS_ID IN (
8309: SELECT change_phase.CHANGE_LIFECYCLE_STATUS_ID
8310: FROM ENG_ENGINEERING_CHANGES ch
8311: , ENG_LIFECYCLE_STATUSES cur_phase
8312: , ENG_LIFECYCLE_STATUSES change_phase
8313: WHERE ch.CHANGE_ORDER_TYPE_ID = p_change_type_id
8314: AND ch.STATUS_TYPE NOT IN (5, 6, 11) -- exclude cancel, implemented, completed
8315: AND cur_phase.entity_name = G_ENG_CHANGE

Line 8312: , ENG_LIFECYCLE_STATUSES change_phase

8308: WHERE CHANGE_LIFECYCLE_STATUS_ID IN (
8309: SELECT change_phase.CHANGE_LIFECYCLE_STATUS_ID
8310: FROM ENG_ENGINEERING_CHANGES ch
8311: , ENG_LIFECYCLE_STATUSES cur_phase
8312: , ENG_LIFECYCLE_STATUSES change_phase
8313: WHERE ch.CHANGE_ORDER_TYPE_ID = p_change_type_id
8314: AND ch.STATUS_TYPE NOT IN (5, 6, 11) -- exclude cancel, implemented, completed
8315: AND cur_phase.entity_name = G_ENG_CHANGE
8316: AND cur_phase.entity_id1 = ch.CHANGE_ID

Line 8324: FROM eng_lifecycle_statuses lc_phase_setup

8320: AND change_phase.entity_name = 'ENG_CHANGE'
8321: AND change_phase.entity_id1 = ch.CHANGE_ID
8322: AND change_phase.active_flag = 'Y'
8323: AND NOT EXISTS ( SELECT 'exists'
8324: FROM eng_lifecycle_statuses lc_phase_setup
8325: WHERE lc_phase_setup.entity_name = 'ENG_CHANGE_TYPE'
8326: AND lc_phase_setup.entity_id1 = ch.CHANGE_ORDER_TYPE_ID
8327: AND lc_phase_setup.SEQUENCE_NUMBER = change_phase.SEQUENCE_NUMBER
8328: AND lc_phase_setup.STATUS_CODE = change_phase.STATUS_CODE

Line 8333: , ENG_LIFECYCLE_STATUSES change_phase

8329: )
8330: UNION ALL
8331: SELECT change_phase.CHANGE_LIFECYCLE_STATUS_ID
8332: FROM ENG_ENGINEERING_CHANGES ch
8333: , ENG_LIFECYCLE_STATUSES change_phase
8334: WHERE ch.CHANGE_ORDER_TYPE_ID = p_change_type_id
8335: AND ch.STATUS_CODE = 0 -- DRAFT
8336: AND ch.STATUS_TYPE NOT IN (5, 6, 11) -- exclude cancel, implemented, completed
8337: AND change_phase.entity_name = G_ENG_CHANGE

Line 8341: FROM eng_lifecycle_statuses lc_phase_setup

8337: AND change_phase.entity_name = G_ENG_CHANGE
8338: AND change_phase.entity_id1 = ch.CHANGE_ID
8339: AND change_phase.active_flag = 'Y'
8340: AND NOT EXISTS ( SELECT 'exists'
8341: FROM eng_lifecycle_statuses lc_phase_setup
8342: WHERE lc_phase_setup.entity_name = 'ENG_CHANGE_TYPE'
8343: AND lc_phase_setup.entity_id1 = ch.CHANGE_ORDER_TYPE_ID
8344: AND lc_phase_setup.SEQUENCE_NUMBER = change_phase.SEQUENCE_NUMBER
8345: AND lc_phase_setup.STATUS_CODE = change_phase.STATUS_CODE

Line 8364: UPDATE ENG_LIFECYCLE_STATUSES lc_phase

8360: END IF ;
8361:
8362: -- 3. Mass Update Change LC Phases marked as 'S' in the above process of syncronization of newly added phase.
8363: -- to make them Activie
8364: UPDATE ENG_LIFECYCLE_STATUSES lc_phase
8365: SET lc_phase.ACTIVE_FLAG = 'Y'
8366: WHERE lc_phase.CHANGE_LIFECYCLE_STATUS_ID IN (
8367: SELECT added_change_phase.CHANGE_LIFECYCLE_STATUS_ID
8368: FROM ENG_ENGINEERING_CHANGES ch

Line 8369: , ENG_LIFECYCLE_STATUSES added_change_phase

8365: SET lc_phase.ACTIVE_FLAG = 'Y'
8366: WHERE lc_phase.CHANGE_LIFECYCLE_STATUS_ID IN (
8367: SELECT added_change_phase.CHANGE_LIFECYCLE_STATUS_ID
8368: FROM ENG_ENGINEERING_CHANGES ch
8369: , ENG_LIFECYCLE_STATUSES added_change_phase
8370: WHERE ch.CHANGE_ORDER_TYPE_ID = p_change_type_id
8371: AND ch.STATUS_TYPE NOT IN (5, 6, 11) -- exclude cancel, implemented, completed
8372: AND added_change_phase.entity_name = G_ENG_CHANGE
8373: AND added_change_phase.entity_id1 = ch.CHANGE_ID