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 9250: FROM ENG_CHANGE_LINES ecl

9246: SELECT ecl.change_line_id
9247: , ecl.route_id
9248: , ecr.wf_item_type
9249: , ecr.wf_process_name
9250: FROM ENG_CHANGE_LINES ecl
9251: , ENG_CHANGE_ROUTES ecr
9252: WHERE ( ecl.status_code <> Eng_Workflow_Util.G_CL_COMPLETED
9253: AND ecl.status_code <> Eng_Workflow_Util.G_CL_CANCELLED )
9254: AND ( ecl.approval_status_type <> Eng_Workflow_Util.G_APPROVED

Line 9393: FROM ENG_CHANGE_LINES ecl

9389: IS
9390: SELECT 'Non Approved Line Exists'
9391: FROM DUAL
9392: WHERE EXISTS ( SELECT null
9393: FROM ENG_CHANGE_LINES ecl
9394: WHERE ( ecl.status_code <> Eng_Workflow_Util.G_CL_COMPLETED
9395: AND ecl.status_code <> Eng_Workflow_Util.G_CL_CANCELLED )
9396: AND ecl.approval_status_type <> Eng_Workflow_Util.G_APPROVED
9397: AND ecl.change_type_id <> -1

Line 13939: l_attachment_entity_name := 'ENG_CHANGE_LINES' ;

13935: l_base_cm_type_code := GetBaseChangeMgmtTypeCode(p_change_id);
13936:
13937: ELSE
13938:
13939: l_attachment_entity_name := 'ENG_CHANGE_LINES' ;
13940: l_attachment_pk1value := TO_CHAR(l_change_line_id) ;
13941:
13942: END IF ;
13943:

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

14211: , p_debug_filename => p_debug_filename
14212: , x_return_status => l_return_status
14213: , x_msg_count => l_msg_count
14214: , x_msg_data => l_msg_data
14215: , p_entity_name => l_attachment_entity_name -- ENG_ENGINEERING_CHANGES or ENG_CHANGE_LINES
14216: , p_pk1value => l_attachment_pk1value -- CHANGE_ID or CHANGE_LINE_ID
14217: , p_pk2value => NULL
14218: , p_pk3value => NULL
14219: , p_pk4value => NULL

Line 14430: , ENG_CHANGE_LINES chg_line

14426: SELECT chg_line.CHANGE_ID
14427: , chg_line.CHANGE_LINE_ID
14428: , line_routes.ROUTE_ID
14429: FROM ENG_CHANGE_ROUTES line_routes
14430: , ENG_CHANGE_LINES chg_line
14431: WHERE line_routes.STATUS_CODE IN ( Eng_Workflow_Util.G_RT_REJECTED
14432: , Eng_Workflow_Util.G_RT_APPROVED
14433: , Eng_Workflow_Util.G_RT_COMPLETED
14434: , Eng_Workflow_Util.G_RT_TIME_OUT ) -- G_RT_ABORTED was taken care by ABORT WF

Line 14886: l_attachment_entity_name := 'ENG_CHANGE_LINES' ;

14882: l_attachment_entity_name := 'ENG_ENGINEERING_CHANGES' ;
14883: l_attachment_pk1value := TO_CHAR(l_change_id) ;
14884:
14885: ELSE
14886: l_attachment_entity_name := 'ENG_CHANGE_LINES' ;
14887: l_attachment_pk1value := TO_CHAR(l_change_line_id) ;
14888: END IF ;
14889:
14890: IF g_debug_flag THEN

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

15144: , p_debug_filename => p_debug_filename
15145: , x_return_status => l_return_status
15146: , x_msg_count => l_msg_count
15147: , x_msg_data => l_msg_data
15148: , p_entity_name => l_attachment_entity_name -- ENG_ENGINEERING_CHANGES or ENG_CHANGE_LINES
15149: , p_pk1value => l_attachment_pk1value -- CHANGE_ID or CHANGE_LINE_ID
15150: , p_pk2value => NULL
15151: , p_pk3value => NULL
15152: , p_pk4value => NULL