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_WORKFLOW_UTIL dependencies on ENG_ENGINEERING_CHANGES

Line 476: FROM ENG_ENGINEERING_CHANGES

472:
473: CURSOR c_change (p_change_id NUMBER)
474: IS
475: SELECT change_notice
476: FROM ENG_ENGINEERING_CHANGES
477: WHERE change_id = p_change_id;
478:
479: BEGIN
480:

Line 1568: FROM ENG_ENGINEERING_CHANGES eec

1564: , eec.created_by
1565: INTO x_assignee_party_id
1566: , x_requestor_party_id
1567: , x_creator_user_id
1568: FROM ENG_ENGINEERING_CHANGES eec
1569: WHERE eec.change_id = p_change_id ;
1570:
1571: END GetChangeObjectParty ;
1572:

Line 1682: ENG_ENGINEERING_CHANGES eec

1678: -- Modified sql for 115.10 case change, also need additional changes
1679: SELECT 'Y' AS enable_rev_items_flag -- ecmt.enable_rev_items_flag
1680: , 'Y' AS enable_tasks_flag -- ecmt.enable_tasks_flag
1681: FROM ENG_CHANGE_MGMT_TYPES ecmt,
1682: ENG_ENGINEERING_CHANGES eec
1683: WHERE ecmt.change_mgmt_type_code = eec.change_mgmt_type_code
1684: AND eec.change_id = p_change_id ;
1685:
1686: -- SELECT 'Y' AS enable_rev_items_flag -- ecmt.enable_rev_items_flag

Line 1689: -- ENG_ENGINEERING_CHANGES eec

1685:
1686: -- SELECT 'Y' AS enable_rev_items_flag -- ecmt.enable_rev_items_flag
1687: -- , 'Y' AS enable_tasks_flag -- ecmt.enable_tasks_flag
1688: -- FROM ENG_CHANGE_ORDER_TYPES ecmt,
1689: -- ENG_ENGINEERING_CHANGES eec
1690: -- WHERE ecmt.change_mgmt_type_code = eec.change_mgmt_type_code
1691: -- AND type_classification = 'CATEGORY'
1692: -- AND eec.change_id = p_change_id ;
1693:

Line 1763: -- FND:entity=ENG_ENGINEERING_CHANGES&pk1name=CHANGE_ID&pk1value=9999

1759: -- Get Attachment Link Info from FND_DOCUMENT_ENTITIES
1760: -- then construct Ntf Attachmet Link for the standard
1761: -- FND:entity= &pk1name=&pk1value=
1762: -- e.g.
1763: -- FND:entity=ENG_ENGINEERING_CHANGES&pk1name=CHANGE_ID&pk1value=9999
1764: --
1765: FOR doc_entity_rec IN c_doc_entity (p_data_object_code => p_data_object_code)
1766: LOOP
1767:

Line 2279: ENG_ENGINEERING_CHANGES EngChange

2275: IS
2276: SELECT TempLCStatus.WF_SIG_POLICY
2277: FROM ENG_LIFECYCLE_STATUSES TempLCStatus,
2278: ENG_CHANGE_ROUTES Route,
2279: ENG_ENGINEERING_CHANGES EngChange
2280: WHERE TempLCStatus.ENTITY_NAME = 'ENG_CHANGE_TYPE'
2281: AND TempLCStatus.ENTITY_ID1 = EngChange.CHANGE_ORDER_TYPE_ID
2282: AND TO_CHAR(TempLCStatus.STATUS_CODE) = Route.CLASSIFICATION_CODE
2283: AND EngChange.CHANGE_ID = Route.OBJECT_ID1

Line 2443: FROM ENG_ENGINEERING_CHANGES EngineeringChangeEO,

2439:
2440: CURSOR c_base_cm_code(p_change_id NUMBER)
2441: IS
2442: SELECT ChangeCategory.BASE_CHANGE_MGMT_TYPE_CODE
2443: FROM ENG_ENGINEERING_CHANGES EngineeringChangeEO,
2444: ENG_CHANGE_ORDER_TYPES ChangeCategory
2445: WHERE ChangeCategory.type_classification = 'CATEGORY'
2446: AND ChangeCategory.change_mgmt_type_code = EngineeringChangeEO.change_mgmt_type_code
2447: AND EngineeringChangeEO.change_id = p_change_id ;

Line 3492: ENG_ENGINEERING_CHANGES eec

3488: HR_ORGANIZATION_UNITS hou,
3489: ENG_CHANGE_ORDER_TYPES ecmt,
3490: ENG_CHANGE_ORDER_TYPES_TL ecmt_tl,
3491: -- ENG_CHANGE_ORDER_TYPES_VL ecmt,
3492: ENG_ENGINEERING_CHANGES eec
3493: WHERE eec.change_order_type_id = ecot.change_order_type_id
3494: AND ecot.language = userenv('LANG')
3495: -- AND eec.priority_code = priority.eng_change_priority_code(+)
3496: -- AND priority.organization_id(+)= -1

Line 3554: ENG_ENGINEERING_CHANGES eec

3550: ENG_CHANGE_STATUSES_TL ecs,
3551: MFG_LOOKUPS mlu,
3552: HR_ORGANIZATION_UNITS hou,
3553: ENG_CHANGE_MGMT_TYPES_TL ecmt,
3554: ENG_ENGINEERING_CHANGES eec
3555: WHERE eec.change_order_type_id = ecot.change_order_type_id
3556: -- AND eec.priority_code = priority.eng_change_priority_code(+)
3557: -- AND priority.organization_id(+)= -1
3558: -- AND eec.reason_code = reason.eng_change_reason_code(+)

Line 4047: UPDATE eng_engineering_changes

4043:
4044: IF p_new_appr_status_type = 5 THEN
4045:
4046: -- Approve ECO/Change Object
4047: UPDATE eng_engineering_changes
4048: SET approval_status_type = p_new_appr_status_type ,
4049: approval_date = sysdate ,
4050: request_id = l_request_id ,
4051: last_update_date = SYSDATE ,

Line 4082: UPDATE eng_engineering_changes

4078: AND status_type = 1; -- Rev Item Status: Open
4079:
4080:
4081: -- If ECO is Open, Set Status to Scheduled (bug 2307416)
4082: UPDATE eng_engineering_changes
4083: SET status_type = 4 , -- Scheduled
4084: request_id = l_request_id ,
4085: last_update_date = SYSDATE ,
4086: last_updated_by = l_user_id ,

Line 4100: -- UPDATE eng_engineering_changes

4096: -- ELSIF p_new_appr_status_type IN (4, 7, 8) THEN
4097:
4098:
4099: -- Reject ECO/Change Object or set Processing Error
4100: -- UPDATE eng_engineering_changes
4101: -- SET approval_status_type = p_new_appr_status_type ,
4102: -- approval_date = NULL ,
4103: -- request_id = l_request_id ,
4104: -- last_update_date = SYSDATE ,

Line 4114: UPDATE eng_engineering_changes

4110: -- Others
4111: ELSE
4112:
4113: -- Update Approval Status
4114: UPDATE eng_engineering_changes
4115: SET approval_status_type = p_new_appr_status_type,
4116: approval_date = NULL ,
4117: approval_request_date = DECODE(p_new_appr_status_type
4118: , Eng_Workflow_Util.G_REQUESTED

Line 5027: ( p_data_object_code => 'ENG_ENGINEERING_CHANGES'

5023: AND l_base_cm_type_code <> 'ATTACHMENT_REVIEW'
5024: THEN
5025:
5026: GetNtfAttachmentLink
5027: ( p_data_object_code => 'ENG_ENGINEERING_CHANGES'
5028: , p_pk1_value => TO_CHAR(l_change_id)
5029: , x_ntf_attachment_link => l_attachments ) ;
5030:
5031: END IF ;

Line 8087: FROM ENG_ENGINEERING_CHANGES eec

8083: CURSOR c_header_route_wf (p_change_id NUMBER)
8084: IS
8085: SELECT wi.item_type
8086: , wi.item_key
8087: FROM ENG_ENGINEERING_CHANGES eec
8088: , ENG_CHANGE_ROUTES ecr
8089: , WF_ITEMS wi
8090: WHERE wi.end_date IS NULL
8091: AND wi.item_key = ecr.wf_item_key

Line 10464: , ENG_ENGINEERING_CHANGES eec

10460: IS
10461: SELECT ecr.wf_item_type parent_item_type
10462: , ecr.wf_item_key parent_item_key
10463: FROM ENG_CHANGE_ROUTES ecr
10464: , ENG_ENGINEERING_CHANGES eec
10465: , WF_ITEMS wi
10466: WHERE wi.item_type = ecr.wf_item_type
10467: AND wi.item_key = ecr.wf_item_key
10468: AND wi.end_date IS NULL

Line 13788: l_attachment_entity_name := 'ENG_ENGINEERING_CHANGES' ;

13784: IF l_change_line_id IS NULL OR l_change_line_id <= 0
13785: THEN
13786: l_change_line_id := -1 ;
13787:
13788: l_attachment_entity_name := 'ENG_ENGINEERING_CHANGES' ;
13789: l_attachment_pk1value := TO_CHAR(l_change_id) ;
13790: l_base_cm_type_code := GetBaseChangeMgmtTypeCode(p_change_id);
13791:
13792: ELSE

Line 14070: , p_entity_name => l_attachment_entity_name -- ENG_ENGINEERING_CHANGES or ENG_CHANGE_LINES

14066: , p_debug_filename => p_debug_filename
14067: , x_return_status => l_return_status
14068: , x_msg_count => l_msg_count
14069: , x_msg_data => l_msg_data
14070: , p_entity_name => l_attachment_entity_name -- ENG_ENGINEERING_CHANGES or ENG_CHANGE_LINES
14071: , p_pk1value => l_attachment_pk1value -- CHANGE_ID or CHANGE_LINE_ID
14072: , p_pk2value => NULL
14073: , p_pk3value => NULL
14074: , p_pk4value => NULL

Line 14737: l_attachment_entity_name := 'ENG_ENGINEERING_CHANGES' ;

14733: THEN
14734:
14735: l_change_line_id := -1 ;
14736:
14737: l_attachment_entity_name := 'ENG_ENGINEERING_CHANGES' ;
14738: l_attachment_pk1value := TO_CHAR(l_change_id) ;
14739:
14740: ELSE
14741: l_attachment_entity_name := 'ENG_CHANGE_LINES' ;

Line 15003: , p_entity_name => l_attachment_entity_name -- ENG_ENGINEERING_CHANGES or ENG_CHANGE_LINES

14999: , p_debug_filename => p_debug_filename
15000: , x_return_status => l_return_status
15001: , x_msg_count => l_msg_count
15002: , x_msg_data => l_msg_data
15003: , p_entity_name => l_attachment_entity_name -- ENG_ENGINEERING_CHANGES or ENG_CHANGE_LINES
15004: , p_pk1value => l_attachment_pk1value -- CHANGE_ID or CHANGE_LINE_ID
15005: , p_pk2value => NULL
15006: , p_pk3value => NULL
15007: , p_pk4value => NULL