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_CHANGE_LINES

Line 452: FROM ENG_CHANGE_LINES

448:
449: CURSOR c_line (p_change_line_id NUMBER)
450: IS
451: SELECT change_id
452: FROM ENG_CHANGE_LINES
453: WHERE change_line_id = p_change_line_id ;
454: BEGIN
455:
456: FOR l_rec IN c_line(p_change_line_id => p_change_line_id)

Line 502: FROM ENG_CHANGE_LINES ecl

498:
499: CURSOR c_line (p_change_line_id NUMBER)
500: IS
501: SELECT ecl.sequence_number
502: FROM ENG_CHANGE_LINES ecl
503: WHERE ecl.change_line_id = p_change_line_id ;
504:
505: BEGIN
506:

Line 1588: FROM ENG_CHANGE_LINES ecl

1584: SELECT ecl.assignee_id
1585: , ecl.created_by
1586: INTO x_assignee_party_id
1587: , x_creator_user_id
1588: FROM ENG_CHANGE_LINES ecl
1589: WHERE ecl.change_line_id = p_change_line_id ;
1590:
1591: END GetChangeLineObjectParty ;
1592:

Line 3214: -- FROM ENG_CHANGE_LINES subject

3210: -- Modified for 115.10 Case Change
3211: -- SELECT TO_NUMBER(subject.pk2_value) organization_id
3212: -- , TO_NUMBER(subject.pk1_value) item_id
3213: -- , TO_NUMBER(subject.pk3_value) item_revision_id
3214: -- FROM ENG_CHANGE_LINES subject
3215: -- , FND_OBJECTS obj
3216: -- WHERE subject.pk1_value IS NOT NULL
3217: -- AND subject.pk2_value IS NOT NULL
3218: -- AND subject.sequence_number = -1

Line 3302: -- FROM ENG_CHANGE_LINES subject

3298: IS
3299: -- SELECT TO_NUMBER(subject.pk2_value) organization_id
3300: -- , TO_NUMBER(subject.pk1_value) item_id
3301: -- , TO_NUMBER(subject.pk3_value) item_revision_id
3302: -- FROM ENG_CHANGE_LINES subject
3303: -- , FND_OBJECTS obj
3304: -- WHERE subject.pk1_value IS NOT NULL
3305: -- AND subject.pk2_value IS NOT NULL
3306: -- AND subject.object_id = obj.object_id

Line 3640: ENG_CHANGE_LINES_VL ecl

3636: FROM FND_LOOKUPS dist_stat_flu,
3637: FND_LOOKUPS flu,
3638: MFG_LOOKUPS mlu,
3639: ENG_CHANGE_ROUTES line_wf,
3640: ENG_CHANGE_LINES_VL ecl
3641: WHERE line_wf.route_id (+)= ecl.route_id
3642: AND dist_stat_flu.lookup_code (+)= ecl.status_code
3643: AND dist_stat_flu.lookup_type (+)= 'ENG_DIST_LINE_STATUSES'
3644: AND flu.lookup_code (+)= ecl.status_code

Line 4166: UPDATE eng_change_lines

4162:
4163: IF p_new_appr_status_type = 5 THEN
4164:
4165: -- Approve Change Line
4166: UPDATE eng_change_lines
4167: SET approval_status_type = p_new_appr_status_type ,
4168: approval_date = sysdate ,
4169: request_id = l_request_id ,
4170: last_update_date = SYSDATE ,

Line 4182: -- UPDATE eng_change_lines

4178: -- ELSIF p_new_appr_status_type IN (4, 7, 8) THEN
4179:
4180:
4181: -- Reject ECO/Change Object or set Processing Error
4182: -- UPDATE eng_change_lines
4183: -- SET approval_status_type = p_new_appr_status_type ,
4184: -- approval_date = NULL ,
4185: -- request_id = l_request_id ,
4186: -- last_update_date = SYSDATE ,

Line 4196: UPDATE eng_change_lines

4192: -- Others
4193: ELSE
4194:
4195: -- Update Approval Status
4196: UPDATE eng_change_lines
4197: SET approval_status_type = p_new_appr_status_type,
4198: approval_date = NULL ,
4199: approval_request_date = DECODE(p_new_appr_status_type
4200: , Eng_Workflow_Util.G_REQUESTED

Line 4278: FROM ENG_CHANGE_LINES ecl

4274: --
4275: CURSOR c_lines (p_change_id NUMBER)
4276: IS
4277: SELECT ecl.change_line_id
4278: FROM ENG_CHANGE_LINES ecl
4279: -- , ENG_CHANGE_ROUTES ecr
4280: WHERE ( ecl.approval_status_type <> Eng_Workflow_Util.G_APPROVED
4281: AND ecl.approval_status_type <> Eng_Workflow_Util.G_REQUESTED )
4282: -- AND ( ecl.status_code <> Eng_Workflow_Util.G_CL_COMPLETED

Line 4480: update ENG_CHANGE_LINES set

4476:
4477:
4478: IF (p_change_line_id IS NOT NULL AND p_change_line_id > 0 )
4479: THEN
4480: update ENG_CHANGE_LINES set
4481: STATUS_CODE = l_dist_line_status_code ,
4482: LAST_UPDATE_DATE = SYSDATE,
4483: LAST_UPDATED_BY = p_wf_user_id,
4484: LAST_UPDATE_LOGIN = ''

Line 5040: ( p_data_object_code => 'ENG_CHANGE_LINES'

5036: THEN
5037:
5038: -- Get Change Line Notification Attachment Link Info
5039: GetNtfAttachmentLink
5040: ( p_data_object_code => 'ENG_CHANGE_LINES'
5041: , p_pk1_value => TO_CHAR(p_change_line_id)
5042: , x_ntf_attachment_link => l_line_attachments ) ;
5043:
5044: END IF ;

Line 6774: FROM ENG_CHANGE_LINES

6770:
6771: CURSOR c_lines (p_change_id NUMBER)
6772: IS
6773: SELECT change_line_id
6774: FROM ENG_CHANGE_LINES
6775: WHERE change_id = p_change_id
6776: AND change_type_id <> -1 -- excluding change task
6777: AND sequence_number <> -1 ;
6778:

Line 8103: FROM ENG_CHANGE_LINES ecl

8099: CURSOR c_line_route_wf (p_change_id NUMBER)
8100: IS
8101: SELECT wi.item_type
8102: , wi.item_key
8103: FROM ENG_CHANGE_LINES ecl
8104: , ENG_CHANGE_ROUTES ecr
8105: , WF_ITEMS wi
8106: WHERE wi.end_date IS NULL
8107: AND wi.item_key = ecr.wf_item_key

Line 9174: FROM ENG_CHANGE_LINES ecl

9170: SELECT ecl.change_line_id
9171: , ecl.route_id
9172: , ecr.wf_item_type
9173: , ecr.wf_process_name
9174: FROM ENG_CHANGE_LINES ecl
9175: , ENG_CHANGE_ROUTES ecr
9176: WHERE ( ecl.status_code <> Eng_Workflow_Util.G_CL_COMPLETED
9177: AND ecl.status_code <> Eng_Workflow_Util.G_CL_CANCELLED )
9178: AND ( ecl.approval_status_type <> Eng_Workflow_Util.G_APPROVED

Line 9317: FROM ENG_CHANGE_LINES ecl

9313: IS
9314: SELECT 'Non Approved Line Exists'
9315: FROM DUAL
9316: WHERE EXISTS ( SELECT null
9317: FROM ENG_CHANGE_LINES ecl
9318: WHERE ( ecl.status_code <> Eng_Workflow_Util.G_CL_COMPLETED
9319: AND ecl.status_code <> Eng_Workflow_Util.G_CL_CANCELLED )
9320: AND ecl.approval_status_type <> Eng_Workflow_Util.G_APPROVED
9321: AND ecl.change_type_id <> -1

Line 13794: l_attachment_entity_name := 'ENG_CHANGE_LINES' ;

13790: l_base_cm_type_code := GetBaseChangeMgmtTypeCode(p_change_id);
13791:
13792: ELSE
13793:
13794: l_attachment_entity_name := 'ENG_CHANGE_LINES' ;
13795: l_attachment_pk1value := TO_CHAR(l_change_line_id) ;
13796:
13797: END IF ;
13798:

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 14285: , ENG_CHANGE_LINES chg_line

14281: SELECT chg_line.CHANGE_ID
14282: , chg_line.CHANGE_LINE_ID
14283: , line_routes.ROUTE_ID
14284: FROM ENG_CHANGE_ROUTES line_routes
14285: , ENG_CHANGE_LINES chg_line
14286: WHERE line_routes.STATUS_CODE IN ( Eng_Workflow_Util.G_RT_REJECTED
14287: , Eng_Workflow_Util.G_RT_APPROVED
14288: , Eng_Workflow_Util.G_RT_COMPLETED
14289: , Eng_Workflow_Util.G_RT_TIME_OUT ) -- G_RT_ABORTED was taken care by ABORT WF

Line 14741: l_attachment_entity_name := 'ENG_CHANGE_LINES' ;

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' ;
14742: l_attachment_pk1value := TO_CHAR(l_change_line_id) ;
14743: END IF ;
14744:
14745: IF g_debug_flag THEN

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