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_ENGINEERING_CHANGES

Line 311: FROM ENG_ENGINEERING_CHANGES eec,

307: SELECT eec.change_id,
308: eec.change_mgmt_type_code ,
309: changecategory.base_change_mgmt_type_code,
310: type_appl.application_id
311: FROM ENG_ENGINEERING_CHANGES eec,
312: ENG_CHANGE_ORDER_TYPES ChangeCategory,
313: ENG_CHANGE_TYPE_APPLICATIONS type_appl
314: WHERE type_appl.change_type_id = ChangeCategory.change_order_type_id
315: and type_appl.application_id = p_appl_id

Line 350: l_cm_type_code eng_engineering_changes.CHANGE_MGMT_TYPE_CODE%TYPE;

346:
347: l_fnd_user_id NUMBER := TO_NUMBER(FND_PROFILE.VALUE('USER_ID'));
348: l_fnd_login_id NUMBER := TO_NUMBER(FND_PROFILE.VALUE('LOGIN_ID'));
349:
350: l_cm_type_code eng_engineering_changes.CHANGE_MGMT_TYPE_CODE%TYPE;
351: l_base_cm_type_code eng_change_order_types.BASE_CHANGE_MGMT_TYPE_CODE%TYPE;
352:
353: l_next_status_code NUMBER;
354:

Line 398: FROM eng_engineering_changes eec,

394: SELECT eec.change_mgmt_type_code, eec.promote_status_code, --eec.status_code
395: ecot.base_change_mgmt_type_code
396: INTO l_cm_type_code, l_next_status_code, --l_curr_status_code
397: l_base_cm_type_code
398: FROM eng_engineering_changes eec,
399: eng_change_order_types ecot
400: WHERE eec.change_id = p_change_id
401: AND ecot.change_order_type_id = eec.change_order_type_id;
402:

Line 463: l_cm_type_code eng_engineering_changes.CHANGE_MGMT_TYPE_CODE%TYPE;

459: ,x_last_status_type OUT NOCOPY NUMBER
460: ,x_last_status_code OUT NOCOPY NUMBER
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

Line 490: FROM eng_engineering_changes eec,

486:
487: -- Get the change header's cm type, and promote_status_code
488: SELECT eec.change_mgmt_type_code, ecot.base_change_mgmt_type_code
489: INTO l_cm_type_code, l_base_cm_type_code
490: FROM eng_engineering_changes eec,
491: eng_change_order_types ecot
492: WHERE eec.change_id = p_change_id
493: AND ecot.change_order_type_id = eec.change_order_type_id;
494:

Line 610: l_status_type eng_engineering_changes.status_type%TYPE;

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;
613:
614: l_cm_type_code eng_engineering_changes.change_mgmt_type_code%TYPE;

Line 614: l_cm_type_code eng_engineering_changes.change_mgmt_type_code%TYPE;

610: l_status_type eng_engineering_changes.status_type%TYPE;
611:
612: l_wf_item_key wf_item_activity_statuses.item_key%TYPE := NULL;
613:
614: l_cm_type_code eng_engineering_changes.change_mgmt_type_code%TYPE;
615: l_base_cm_type_code eng_change_order_types.BASE_CHANGE_MGMT_TYPE_CODE%TYPE;
616:
617: l_param_list WF_PARAMETER_LIST_T := WF_PARAMETER_LIST_T();
618:

Line 687: FROM eng_engineering_changes eec,

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
686: INTO l_cm_type_code, l_base_cm_type_code
687: FROM eng_engineering_changes eec,
688: eng_change_order_types ecot
689: WHERE eec.change_id = p_change_id
690: AND ecot.change_order_type_id = eec.change_order_type_id;
691:

Line 705: UPDATE eng_engineering_changes

701: END IF;
702:
703: -- update header approval status
704: IF (p_appr_status = G_ENG_APPR_REQUESTED ) THEN
705: UPDATE eng_engineering_changes
706: SET approval_status_type = p_appr_status,
707: approval_request_date = sysdate,
708: approval_date = null,
709: last_update_date = sysdate,

Line 715: Write_Debug('After updating eng_engineering_changes.approval_* columns.');

711: last_update_login = l_fnd_login_id
712: WHERE change_id = p_change_id;
713: l_updated := TRUE;
714: IF g_debug_flag THEN
715: Write_Debug('After updating eng_engineering_changes.approval_* columns.');
716: Write_Debug(' Row count = ' || SQL%ROWCOUNT);
717: END IF;
718: IF g_debug_flag THEN
719: Write_Debug('After: updating header approval columns FOR APPROVAL REQUESTED');

Line 755: UPDATE eng_engineering_changes

751: IF g_debug_flag THEN
752: Write_Debug('Current phase is the last of such type');
753: END IF;
754:
755: UPDATE eng_engineering_changes
756: SET approval_status_type = p_appr_status,
757: approval_date = sysdate,
758: last_update_date = sysdate,
759: last_updated_by = l_fnd_user_id,

Line 764: Write_Debug('After updating eng_engineering_changes.approval_* columns.');

760: last_update_login = l_fnd_login_id
761: WHERE change_id = p_change_id;
762: l_updated := TRUE;
763: IF g_debug_flag THEN
764: Write_Debug('After updating eng_engineering_changes.approval_* columns.');
765: Write_Debug(' Row count = ' || SQL%ROWCOUNT);
766: END IF;
767: IF g_debug_flag THEN
768: Write_Debug('After: updating header approval columns FOR APPROVED');

Line 776: UPDATE eng_engineering_changes

772: ELSIF ( p_appr_status = G_ENG_APPR_REJECTED
773: OR p_appr_status = G_ENG_APPR_PROC_ERR
774: OR p_appr_status = G_ENG_APPR_TIME_OUT)
775: THEN
776: UPDATE eng_engineering_changes
777: SET approval_status_type = p_appr_status,
778: approval_date = null,
779: last_update_date = sysdate,
780: last_updated_by = l_fnd_user_id,

Line 785: Write_Debug('After updating eng_engineering_changes.approval_* columns.');

781: last_update_login = l_fnd_login_id
782: WHERE change_id = p_change_id;
783: l_updated := TRUE;
784: IF g_debug_flag THEN
785: Write_Debug('After updating eng_engineering_changes.approval_* columns.');
786: Write_Debug(' Row count = ' || SQL%ROWCOUNT);
787: END IF;
788: IF g_debug_flag THEN
789: Write_Debug('After: updating header approval columns FOR REJECTED, PROC_ERR, TIME_OUT');

Line 796: UPDATE eng_engineering_changes

792: ELSIF (l_doc_lc_object_flag AND l_status_type = G_ENG_REVIEWED)
793: THEN
794: l_updated := TRUE;
795: ELSE
796: UPDATE eng_engineering_changes
797: SET approval_status_type = p_appr_status,
798: approval_request_date = null,
799: approval_date = null,
800: last_update_date = sysdate,

Line 806: Write_Debug('After updating eng_engineering_changes.approval_* columns.');

802: last_update_login = l_fnd_login_id
803: WHERE change_id = p_change_id;
804: l_updated := TRUE;
805: IF g_debug_flag THEN
806: Write_Debug('After updating eng_engineering_changes.approval_* columns.');
807: Write_Debug(' Row count = ' || SQL%ROWCOUNT);
808: END IF;
809: IF g_debug_flag THEN
810: Write_Debug('After: updating header approval columns FOR other approval types');

Line 821: FROM eng_engineering_changes eec,

817: THEN
818: -- Select cm type and base type code for upcoming API calls
819: /*SELECT eec.change_mgmt_type_code, ecot.base_change_mgmt_type_code
820: INTO l_cm_type_code, l_base_cm_type_code
821: FROM eng_engineering_changes eec,
822: eng_change_order_types ecot
823: WHERE eec.change_id = p_change_id
824: AND ecot.change_order_type_id = eec.change_order_type_id;*/
825:

Line 1560: l_chg_notice eng_engineering_changes.change_notice%TYPE;

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

Line 1561: l_org_id eng_engineering_changes.organization_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;
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 ;

Line 1984: l_curr_status_code eng_engineering_changes.status_code%TYPE;

1980: l_return_status VARCHAR2(1);
1981: l_msg_count NUMBER;
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;

Line 2032: l_cm_type_code eng_engineering_changes.CHANGE_MGMT_TYPE_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;
2034: l_imp_eco_flag VARCHAR2(1) := 'N';
2035:
2036: --l_co_type_id eng_engineering_changes.CHANGE_ORDER_TYPE_ID%TYPE;

Line 2036: --l_co_type_id eng_engineering_changes.CHANGE_ORDER_TYPE_ID%TYPE;

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;
2034: l_imp_eco_flag VARCHAR2(1) := 'N';
2035:
2036: --l_co_type_id eng_engineering_changes.CHANGE_ORDER_TYPE_ID%TYPE;
2037: l_auto_prop_flag eng_type_org_properties.AUTO_PROPAGATE_FLAG%TYPE;
2038: l_change_notice eng_engineering_changes.change_notice%TYPE;
2039: l_hierarchy_name per_organization_structures.name%TYPE;
2040: l_org_name org_organization_definitions.organization_name%TYPE;

Line 2038: l_change_notice eng_engineering_changes.change_notice%TYPE;

2034: l_imp_eco_flag VARCHAR2(1) := 'N';
2035:
2036: --l_co_type_id eng_engineering_changes.CHANGE_ORDER_TYPE_ID%TYPE;
2037: l_auto_prop_flag eng_type_org_properties.AUTO_PROPAGATE_FLAG%TYPE;
2038: l_change_notice eng_engineering_changes.change_notice%TYPE;
2039: l_hierarchy_name per_organization_structures.name%TYPE;
2040: l_org_name org_organization_definitions.organization_name%TYPE;
2041: l_row_cnt NUMBER := 0;
2042:

Line 2052: eng_engineering_changes ec,

2048: ec.change_notice,
2049: pos.name,
2050: ood.name organization_name
2051: FROM eng_type_org_properties op,
2052: eng_engineering_changes ec,
2053: per_organization_structures pos,
2054: hr_all_organization_units_tl ood
2055: WHERE ec.change_id = p_change_id
2056: --AND ec.PLM_OR_ERP_CHANGE = 'PLM'

Line 2243: FROM eng_engineering_changes

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
2244: WHERE change_id = p_change_id)
2245: AND active_flag = 'Y'
2246: AND rownum = 1;
2247:

Line 2387: UPDATE eng_engineering_changes

2383: -- bug 9899944
2384: -- if the last approval workflow is skipped, the approval status
2385: -- is still in 'Approval Request' provided multiple workflow defined for the change type
2386: -- Hence need to set the approval status from 'Approval request' to 'Approved' before it's get implemented
2387: UPDATE eng_engineering_changes
2388: SET approval_status_type = G_ENG_APPR_APPROVED,
2389: approval_date = sysdate,
2390: last_update_date = sysdate,
2391: last_updated_by = l_fnd_user_id,

Line 2403: FROM eng_engineering_changes eec,

2399: -- Fix for bug 3731977
2400: -- Get the change header's cm type and base cm type
2401: SELECT eec.change_mgmt_type_code, ecot.base_change_mgmt_type_code, eec.approval_status_type
2402: INTO l_cm_type_code, l_base_cm_type_code, l_eco_approval_status
2403: FROM eng_engineering_changes eec,
2404: eng_change_order_types ecot
2405: WHERE eec.change_id = p_change_id
2406: AND ecot.change_order_type_id = eec.change_order_type_id;
2407:

Line 2522: UPDATE eng_engineering_changes

2518: l_imp_eco_flag := 'Y';
2519: l_skip_wf := 'Y'; -- fix for bug 3479509 design change of launching wf after concurrent program
2520:
2521: -- save new phase into header's promote_status_code column
2522: UPDATE eng_engineering_changes
2523: SET promote_status_code = p_status_code,
2524: last_update_date = sysdate,
2525: last_updated_by = l_fnd_user_id,
2526: last_update_login = l_fnd_login_id

Line 2647: UPDATE eng_engineering_changes

2643: Write_Debug('After: Completing the current phase and promote to the next phase');
2644: END IF;
2645:
2646: -- Promote change header to the new phase
2647: UPDATE eng_engineering_changes
2648: SET status_code = p_status_code,
2649: promote_status_code = null,
2650: status_type = l_new_status_type,
2651: last_update_date = sysdate,

Line 2660: UPDATE eng_engineering_changes SET

2656: -- Bug 5989058.
2657: -- Set the implementation date if the status is completed or implemented
2658: if( l_new_status_type = G_ENG_COMPLETED OR
2659: l_new_status_type = G_ENG_IMPLEMENTED ) THEN
2660: UPDATE eng_engineering_changes SET
2661: completion_date = SYSDATE
2662: WHERE change_id = p_change_id;
2663: END IF;
2664:

Line 2666: Write_Debug('After updating eng_engineering_changes.');

2662: WHERE change_id = p_change_id;
2663: END IF;
2664:
2665: IF g_debug_flag THEN
2666: Write_Debug('After updating eng_engineering_changes.');
2667: Write_Debug(' Row count = ' || SQL%ROWCOUNT);
2668: END IF;
2669:
2670: IF g_debug_flag THEN

Line 3141: l_curr_appr_status eng_engineering_changes.approval_status_type%TYPE;

3137:
3138: l_fnd_user_id NUMBER := TO_NUMBER(FND_PROFILE.VALUE('USER_ID'));
3139: l_fnd_login_id NUMBER := TO_NUMBER(FND_PROFILE.VALUE('LOGIN_ID'));
3140:
3141: l_curr_appr_status eng_engineering_changes.approval_status_type%TYPE;
3142:
3143: l_is_imp_phase_used VARCHAR2(1) := 'F';
3144:
3145: l_last_status_type NUMBER;

Line 3157: l_change_mgmt_type_code eng_engineering_changes.change_mgmt_type_code%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]
3160: CURSOR c_lcStatuses IS
3161: SELECT *

Line 3225: select status_type, status_code into l_old_status_code, l_old_status_type from eng_engineering_changes where change_id = p_change_id;

3221: and change_wf_route_id is not null;
3222: -- Bug 6695079 End
3223:
3224: BEGIN
3225: select status_type, status_code into l_old_status_code, l_old_status_type from eng_engineering_changes where change_id = p_change_id;
3226: -- Standard Start of API savepoint
3227: SAVEPOINT Demote_Header;
3228: -- Standard call to check for call compatibility
3229: IF NOT FND_API.Compatible_API_Call ( l_api_version

Line 3291: FROM eng_engineering_changes

3287: -- Bug 6695079 end
3288: -- Get the current header approval status
3289: SELECT approval_status_type
3290: INTO l_curr_appr_status
3291: FROM eng_engineering_changes
3292: where change_id = p_change_id;
3293:
3294: -- First check if the header is CO and last implement phase has been used
3295: Is_CO_Last_Imp_Phase_Used

Line 3304: UPDATE eng_engineering_changes

3300: );
3301:
3302: -- If so, adjust header phase to implemented phase before demotion
3303: IF ( l_is_imp_phase_used = 'T' ) THEN
3304: UPDATE eng_engineering_changes
3305: SET status_type = l_last_status_type,
3306: status_code = l_last_status_code,
3307: promote_status_code = NULL
3308: WHERE change_id = p_change_id;

Line 3320: FROM eng_engineering_changes

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
3320: FROM eng_engineering_changes
3321: WHERE change_id = p_change_id)
3322: AND rownum = 1;
3323:
3324: -- Get the sequence number for the new phase of the change header

Line 3355: FROM eng_engineering_changes

3351: WHERE entity_name = G_ENG_CHANGE
3352: AND entity_id1 = p_change_id
3353: AND active_flag = 'Y'
3354: AND status_code = ( SELECT status_code
3355: FROM eng_engineering_changes
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

Line 3570: UPDATE eng_engineering_changes

3566: FROM eng_change_statuses
3567: WHERE status_code = p_status_code;
3568:
3569: -- Demote change header record
3570: UPDATE eng_engineering_changes
3571: SET status_code = p_status_code,
3572: promote_status_code = null,
3573: status_type = l_new_status_type,
3574: last_update_date = sysdate,

Line 3579: Write_Debug('After updating eng_engineering_changes.');

3575: last_updated_by = l_fnd_user_id,
3576: last_update_login = l_fnd_login_id
3577: WHERE change_id = p_change_id;
3578: IF g_debug_flag THEN
3579: Write_Debug('After updating eng_engineering_changes.');
3580: Write_Debug(' Row count = ' || SQL%ROWCOUNT);
3581: END IF;
3582:
3583: -- Fix for bug 3775865: Reset header approval status

Line 3914: l_chg_notice eng_engineering_changes.change_notice%TYPE;

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;
3917:
3918: l_row_cnt NUMBER := 0;

Line 3915: l_org_id eng_engineering_changes.organization_id%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;
3917:
3918: l_row_cnt NUMBER := 0;
3919: BEGIN

Line 4069: FROM eng_engineering_changes

4065:
4066:
4067: SELECT change_notice, organization_id
4068: INTO l_chg_notice, l_org_id
4069: FROM eng_engineering_changes
4070: WHERE change_id = p_change_id;
4071: -- If so, submit concurrent program to implement the eco and all its revised items
4072: -- as the lifecycle has already reach the last phase for implementation
4073: IF g_debug_flag THEN

Line 4433: FROM eng_engineering_changes

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
4433: FROM eng_engineering_changes
4434: WHERE change_id = p_change_id)
4435: AND rownum = 1;
4436:
4437: IF g_debug_flag THEN

Line 4591: l_curr_status_code eng_engineering_changes.status_code%TYPE;

4587: l_return_status VARCHAR2(1);
4588: l_msg_count NUMBER;
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

Line 4592: l_curr_status_type eng_engineering_changes.status_type%TYPE;

4588: l_msg_count NUMBER;
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

Line 4642: FROM eng_engineering_changes

4638: IF (p_object_name = G_ENG_CHANGE) THEN
4639: -- Get the current phase of the change header
4640: SELECT status_code, status_type
4641: INTO l_curr_status_code, l_curr_status_type
4642: FROM eng_engineering_changes
4643: WHERE change_id = p_change_id;
4644:
4645: -- Get the workflow route id and status for the current phase
4646: SELECT change_wf_route_id, workflow_status

Line 4969: l_chg_appr_status eng_engineering_changes.approval_status_type%TYPE;

4965: l_api_caller VARCHAR2(2) := NULL;
4966:
4967: l_action_id eng_change_actions.action_id%TYPE;
4968:
4969: l_chg_appr_status eng_engineering_changes.approval_status_type%TYPE;
4970: l_curr_appr_status eng_engineering_changes.approval_status_type%TYPE;
4971:
4972: l_cm_type_code eng_engineering_changes.change_mgmt_type_code%TYPE;
4973: l_base_cm_type_code eng_change_order_types.BASE_CHANGE_MGMT_TYPE_CODE%TYPE;

Line 4970: l_curr_appr_status eng_engineering_changes.approval_status_type%TYPE;

4966:
4967: l_action_id eng_change_actions.action_id%TYPE;
4968:
4969: l_chg_appr_status eng_engineering_changes.approval_status_type%TYPE;
4970: l_curr_appr_status eng_engineering_changes.approval_status_type%TYPE;
4971:
4972: l_cm_type_code eng_engineering_changes.change_mgmt_type_code%TYPE;
4973: l_base_cm_type_code eng_change_order_types.BASE_CHANGE_MGMT_TYPE_CODE%TYPE;
4974:

Line 4972: l_cm_type_code eng_engineering_changes.change_mgmt_type_code%TYPE;

4968:
4969: l_chg_appr_status eng_engineering_changes.approval_status_type%TYPE;
4970: l_curr_appr_status eng_engineering_changes.approval_status_type%TYPE;
4971:
4972: l_cm_type_code eng_engineering_changes.change_mgmt_type_code%TYPE;
4973: l_base_cm_type_code eng_change_order_types.BASE_CHANGE_MGMT_TYPE_CODE%TYPE;
4974:
4975: l_curr_status_code NUMBER;
4976: l_curr_status_type NUMBER;

Line 4999: l_chg_notice eng_engineering_changes.change_notice%TYPE;

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;
5002:
5003: l_imp_eco_flag VARCHAR2(1) := 'N';

Line 5000: l_org_id eng_engineering_changes.organization_id%TYPE;

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;
5002:
5003: l_imp_eco_flag VARCHAR2(1) := 'N';
5004:

Line 5099: FROM eng_engineering_changes eec,

5095: SELECT eec.status_code, eec.promote_status_code, eec.change_mgmt_type_code,
5096: ecot.base_change_mgmt_type_code
5097: INTO l_curr_status_code, l_next_status_code, l_cm_type_code,
5098: l_base_cm_type_code
5099: FROM eng_engineering_changes eec,
5100: eng_change_order_types ecot
5101: WHERE eec.change_id = p_change_id
5102: AND ecot.change_order_type_id = eec.change_order_type_id;
5103:

Line 5179: UPDATE eng_engineering_changes SET

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
5180: completion_date = SYSDATE
5181: WHERE change_id = p_change_id;
5182: END IF;
5183: EXCEPTION

Line 5205: FROM eng_engineering_changes

5201:
5202: -- Get the required parameters before calling concurrent program for implementing ECO
5203: SELECT change_notice, organization_id
5204: INTO l_chg_notice, l_org_id
5205: FROM eng_engineering_changes
5206: WHERE change_id = p_change_id;
5207:
5208: -- If so, submit concurrent program to implement the eco and all its revised items
5209: -- as the lifecycle has already reach the last phase for implementation

Line 5248: UPDATE eng_engineering_changes

5244: END IF;
5245:
5246: -- ATG Project
5247: -- Putting the request id flag in the implementation_req_id field
5248: UPDATE eng_engineering_changes
5249: SET implementation_req_id = l_request_id
5250: WHERE change_id = p_change_id;
5251: END IF;
5252:

Line 5261: UPDATE eng_engineering_changes

5257: l_flag_imp_failed := 'Y';
5258:
5259: IF (p_api_caller = 'WF') THEN
5260: -- Log implementation failure message
5261: UPDATE eng_engineering_changes
5262: SET status_type = G_ENG_IMP_FAILED,
5263: last_update_date = sysdate,
5264: last_updated_by = l_fnd_user_id,
5265: last_update_login = l_fnd_login_id

Line 5341: UPDATE eng_engineering_changes

5337: Write_Debug('l_request_id : ' || l_request_id );
5338: END IF;
5339:
5340: -- Update change header status_type
5341: UPDATE eng_engineering_changes
5342: SET status_type = G_ENG_IMP_IN_PROGRESS,
5343: last_update_date = sysdate,
5344: last_updated_by = l_fnd_user_id,
5345: last_update_login = l_fnd_login_id

Line 5457: UPDATE eng_engineering_changes SET

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
5458: completion_date = SYSDATE
5459: WHERE change_id = p_change_id;
5460: END IF;
5461: EXCEPTION

Line 5492: FROM eng_engineering_changes

5488: -- Check if the change category is NIR, phase is on last implement phase
5489: -- and header approval status has not been set to APPROVED
5490: SELECT approval_status_type
5491: INTO l_curr_appr_status
5492: FROM eng_engineering_changes
5493: where change_id = p_change_id;
5494:
5495: IF ( l_base_cm_type_code = G_ENG_NEW_ITEM_REQ
5496: AND l_curr_phase_sn = l_max_phase_sn

Line 5642: FROM eng_engineering_changes eec,

5638: SELECT eec.change_mgmt_type_code, eec.change_notice, eec.organization_id,
5639: ecot.base_change_mgmt_type_code
5640: INTO l_cm_type_code, l_chg_notice, l_org_id,
5641: l_base_cm_type_code
5642: FROM eng_engineering_changes eec,
5643: eng_change_order_types ecot
5644: WHERE eec.change_id = p_change_id
5645: AND ecot.change_order_type_id = eec.change_order_type_id;
5646:

Line 5712: FROM eng_engineering_changes

5708: -- Find the promotion phase in the order of the following priority
5709: -- 1. promote_status_code in the change header (saved by promote action)
5710: SELECT promote_status_code
5711: INTO l_next_status_code
5712: FROM eng_engineering_changes
5713: WHERE change_id = p_change_id;
5714:
5715: -- 2. auto_promote_status in the lifecycle table
5716: IF ( l_next_status_code IS NULL ) THEN

Line 5827: UPDATE eng_engineering_changes

5823: AND active_flag = 'Y'
5824: AND rownum = 1;
5825:
5826: -- Reset promotion_status_code for the change header
5827: UPDATE eng_engineering_changes
5828: SET promote_status_code = NULL,
5829: last_update_date = sysdate,
5830: last_updated_by = l_fnd_user_id,
5831: last_update_login = l_fnd_login_id

Line 5834: Write_Debug('After updating eng_engineering_changes.');

5830: last_updated_by = l_fnd_user_id,
5831: last_update_login = l_fnd_login_id
5832: WHERE change_id = p_change_id;
5833: IF g_debug_flag THEN
5834: Write_Debug('After updating eng_engineering_changes.');
5835: Write_Debug(' Row count = ' || SQL%ROWCOUNT);
5836: END IF;
5837:
5838: IF g_debug_flag THEN

Line 5981: UPDATE eng_engineering_changes

5977: Write_Debug('After updating the current phase');
5978: END IF;
5979:
5980: -- Reset promotion_status_code for the change header
5981: UPDATE eng_engineering_changes
5982: SET promote_status_code = NULL,
5983: last_update_date = sysdate,
5984: last_updated_by = l_fnd_user_id,
5985: last_update_login = l_fnd_login_id

Line 6124: UPDATE eng_engineering_changes

6120: Write_Debug('Case 6: Concurrent Program Failure');
6121: END IF;
6122:
6123: -- Log implementation failure message
6124: UPDATE eng_engineering_changes
6125: SET status_type = G_ENG_IMP_FAILED,
6126: promote_status_code = NULL,
6127: last_update_date = sysdate,
6128: last_updated_by = l_fnd_user_id,

Line 6216: UPDATE eng_engineering_changes

6212: l_next_status_code := l_auto_demote_status;
6213:
6214: -- must set header phase to last implement phase before demotion
6215: -- just to make the CO implement phase demotion as a normal demotion
6216: UPDATE eng_engineering_changes
6217: SET status_type = G_ENG_IMPLEMENTED,
6218: status_code = l_last_status_code,
6219: last_update_date = sysdate,
6220: last_updated_by = l_fnd_user_id,

Line 6266: UPDATE eng_engineering_changes

6262: ELSE -- no auto demotion for implement phase, set to previous phase
6263:
6264: NULL;
6265: /*
6266: UPDATE eng_engineering_changes
6267: SET status_type = p_status_code, --G_ENG_IMP_FAILED
6268: promote_status_code = NULL,
6269: last_update_date = sysdate,
6270: last_updated_by = l_fnd_user_id,

Line 6683: l_cm_type_code eng_engineering_changes.change_mgmt_type_code%TYPE;

6679:
6680: l_fnd_user_id NUMBER := TO_NUMBER(FND_PROFILE.VALUE('USER_ID'));
6681: l_fnd_login_id NUMBER := TO_NUMBER(FND_PROFILE.VALUE('LOGIN_ID'));
6682:
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;

Line 6690: l_status_type eng_engineering_changes.status_type%TYPE;

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
6694: l_next_status_code eng_lifecycle_statuses.auto_promote_status%TYPE;

Line 6704: l_change_notice eng_engineering_changes.change_notice%TYPE;

6700: l_message_list Error_Handler.Error_Tbl_Type; --Bug 11825003
6701:
6702: -- for auto-propagation if it's defined for first phase
6703: l_auto_prop_flag eng_type_org_properties.AUTO_PROPAGATE_FLAG%TYPE;
6704: l_change_notice eng_engineering_changes.change_notice%TYPE;
6705: l_hierarchy_name per_organization_structures.name%TYPE;
6706: l_org_name org_organization_definitions.organization_name%TYPE;
6707: l_row_cnt NUMBER := 0;
6708: CURSOR c_orgProp IS

Line 6714: eng_engineering_changes ec,

6710: ec.change_notice,
6711: pos.name,
6712: ood.name organization_name
6713: FROM eng_type_org_properties op,
6714: eng_engineering_changes ec,
6715: per_organization_structures pos,
6716: hr_all_organization_units_tl ood
6717: WHERE ec.change_id = p_change_id
6718: --AND ec.PLM_OR_ERP_CHANGE = 'PLM'

Line 6905: -- and set it in the eng_engineering_changes table

6901: IF g_debug_flag THEN
6902: Write_Debug('After: getting first phase from lifecycle definitions');
6903: END IF;
6904:
6905: -- and set it in the eng_engineering_changes table
6906: UPDATE eng_engineering_changes
6907: SET status_code = l_status_code,
6908: status_type = l_status_type,
6909: initiation_date = sysdate

Line 6906: UPDATE eng_engineering_changes

6902: Write_Debug('After: getting first phase from lifecycle definitions');
6903: END IF;
6904:
6905: -- and set it in the eng_engineering_changes table
6906: UPDATE eng_engineering_changes
6907: SET status_code = l_status_code,
6908: status_type = l_status_type,
6909: initiation_date = sysdate
6910: WHERE change_id = p_change_id;

Line 6920: FROM eng_engineering_changes

6916: /*
6917: -- Get the current phase from change header
6918: SELECT status_code, status_type
6919: INTO l_status_code, l_status_type
6920: FROM eng_engineering_changes
6921: WHERE change_id = p_change_id;
6922:
6923: IF g_debug_flag THEN
6924: Write_Debug('After: getting current phase from change header');

Line 7070: FROM eng_engineering_changes eec,

7066: -- raise business event for SUBMIT action
7067: -- Select cm type and base type code for upcoming API calls
7068: SELECT eec.change_mgmt_type_code, ecot.base_change_mgmt_type_code
7069: INTO l_cm_type_code, l_base_cm_type_code
7070: FROM eng_engineering_changes eec,
7071: eng_change_order_types ecot
7072: WHERE eec.change_id = p_change_id
7073: AND ecot.change_order_type_id = eec.change_order_type_id;
7074:

Line 7554: l_cm_type_code eng_engineering_changes.CHANGE_MGMT_TYPE_CODE%TYPE;

7550: l_msg_data VARCHAR2(2000);
7551:
7552: l_doc_lc_object_flag BOOLEAN := FALSE ;
7553:
7554: l_cm_type_code eng_engineering_changes.CHANGE_MGMT_TYPE_CODE%TYPE;
7555: l_base_cm_type_code eng_change_order_types.BASE_CHANGE_MGMT_TYPE_CODE%TYPE;
7556:
7557: l_next_status_code NUMBER;
7558: l_reset_status_code NUMBER;

Line 7561: l_curr_status_type eng_engineering_changes.status_type%TYPE;

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:
7565:

Line 7574: FROM eng_engineering_changes eec,

7570: SELECT eec.status_code
7571: , eec.promote_status_code
7572: , eec.change_mgmt_type_code
7573: , ecot.base_change_mgmt_type_code
7574: FROM eng_engineering_changes eec,
7575: eng_change_order_types ecot
7576: WHERE eec.change_id = c_change_id
7577: AND ecot.change_order_type_id = eec.change_order_type_id ;
7578:

Line 8129: FROM ENG_ENGINEERING_CHANGES ch

8125: , l_fnd_login_id
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'

Line 8215: FROM ENG_ENGINEERING_CHANGES ch

8211: , l_fnd_login_id
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

Line 8267: , ENG_ENGINEERING_CHANGES ch

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
8271: AND ch.CHANGE_ORDER_TYPE_ID = lc_phase_setup.ENTITY_ID1

Line 8310: FROM ENG_ENGINEERING_CHANGES ch

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
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

Line 8332: FROM ENG_ENGINEERING_CHANGES ch

8328: AND lc_phase_setup.STATUS_CODE = change_phase.STATUS_CODE
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

Line 8368: FROM ENG_ENGINEERING_CHANGES ch

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
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