APPS.ENG_WORKFLOW_API_PKG dependencies on ENG_ENGINEERING_CHANGES

Line 308: eng_engineering_changes eec

304: X_task_id,
305: X_project_id
306: FROM per_people_f mev,
307: eng_change_order_types_vl ecot,
308: eng_engineering_changes eec
309: WHERE eec.organization_id = X_org_id
310: AND eec.change_notice = X_change_notice
311: AND eec.requestor_id = mev.party_id(+)--mev.person_id(+) -- Bug 4644000
312: AND eec.change_order_type_id = ecot.change_order_type_id

Line 322: FROM wf_roles r, eng_engineering_changes eec, eng_ecn_approval_lists al

318: /*
319: OLD CODE, removed for performance bug 3666795
320: SELECT r.name
321: INTO X_approval_list_name
322: FROM wf_roles r, eng_engineering_changes eec, eng_ecn_approval_lists al
323: WHERE eec.approval_list_id = al.approval_list_id
324: AND eec.organization_id = X_org_id
325: AND eec.change_notice = X_change_notice
326: AND al.approval_list_name = r.display_name ;

Line 336: FROM eng_ecn_approval_lists al, eng_engineering_changes eec

332: select r.name
333: INTO X_approval_list_name
334: from wf_local_roles r
335: where r.display_name in (SELECT al.approval_list_name
336: FROM eng_ecn_approval_lists al, eng_engineering_changes eec
337: WHERE eec.approval_list_id = al.approval_list_id
338: AND eec.organization_id = X_org_id
339: AND eec.change_notice = X_change_notice) ;
340: Exception

Line 560: UPDATE eng_engineering_changes

556: actid => actid,
557: funcmode => funcmode,
558: result => X_eco_result);
559:
560: UPDATE eng_engineering_changes
561: SET approval_status_type = 5,
562: approval_date = sysdate
563: WHERE organization_id = X_org_id
564: AND change_notice = X_change_notice;

Line 574: UPDATE eng_engineering_changes

570: AND organization_id = X_org_id
571: AND status_type = 1; /* Rev Item Status = Open */
572:
573: --bug 2307416
574: UPDATE eng_engineering_changes
575: SET status_type = 4
576: ,status_code = 4 --Bug 3526627: Changes for 11.5.10, set the status_code also
577: WHERE change_notice = X_change_notice
578: AND organization_id = X_org_id

Line 638: UPDATE eng_engineering_changes

634: itemkey => itemkey,
635: actid => actid,
636: funcmode => funcmode,
637: result => X_eco_result);
638: UPDATE eng_engineering_changes
639: SET approval_status_type = 4,
640: approval_date = null
641: WHERE organization_id = X_org_id
642: AND change_notice = X_change_notice;

Line 708: UPDATE eng_engineering_changes

704: itemkey => X_itemkey,
705: actid => actid,
706: funcmode => funcmode,
707: result => X_eco_result);
708: UPDATE eng_engineering_changes
709: SET approval_status_type = 7,
710: approval_date = ''
711: WHERE organization_id = X_org_id
712: AND change_notice = X_change_notice;

Line 1275: FROM eng_engineering_changes eec

1271: SELECT
1272: eec.change_id
1273: INTO
1274: X_change_id
1275: FROM eng_engineering_changes eec
1276: WHERE eec.organization_id = X_org_id
1277: AND eec.change_notice = X_change_notice;
1278:
1279: l_requester_name := FND_GLOBAL.USER_NAME;

Line 1295: avalue => 'FND:entity=ENG_ENGINEERING_CHANGES'||'&'||'pk1name=CHANGE_ID'||'&'||'pk1value='||X_change_id);

1291: -- Attachments hookup calls
1292: wf_engine.setitemattrtext(itemtype => itemtype,
1293: itemkey => itemkey,
1294: aname => '#ATTACHMENTS',
1295: avalue => 'FND:entity=ENG_ENGINEERING_CHANGES'||'&'||'pk1name=CHANGE_ID'||'&'||'pk1value='||X_change_id);
1296:
1297:
1298: /* Generate XML form business event*/
1299: