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_REVISED_ITEM_UTIL dependencies on ENG_REVISED_ITEMS

Line 13: * Purpose : Update the new_item_description column of the eng_revised_items table with the given value

9: /*****************************************************************************
10: * Added by vggarg on 09 Oct 2007
11: * Procedure : update_new_description
12: * Parameters IN : p_api_version, p_revised_item_sequence_id, p_new_description
13: * Purpose : Update the new_item_description column of the eng_revised_items table with the given value
14: *****************************************************************************/
15: PROCEDURE update_new_description
16: (
17: p_api_version IN NUMBER := 1.0

Line 23: UPDATE ENG_REVISED_ITEMS SET NEW_ITEM_DESCRIPTION = p_new_description WHERE REVISED_ITEM_SEQUENCE_ID = p_revised_item_sequence_id;

19: , p_new_description mtl_system_items_b.description%TYPE
20: ) IS
21:
22: BEGIN
23: UPDATE ENG_REVISED_ITEMS SET NEW_ITEM_DESCRIPTION = p_new_description WHERE REVISED_ITEM_SEQUENCE_ID = p_revised_item_sequence_id;
24: END;
25: -- Code changes for enhancement 6084027 end
26:
27: /*****************************************************************************

Line 77: from ENG_REVISED_ITEMS eri

73: and bor2.alternate_routing_designator is not null))
74: or
75: (bor.alternate_routing_designator is not null))
76: and not exists (select null
77: from ENG_REVISED_ITEMS eri
78: where eri.organization_id = bor.organization_id
79: and eri.bill_sequence_id = bor.routing_sequence_id
80: and eri.change_notice <> p_change_notice
81: );

Line 179: From eng_revised_items eri

175: Select 'x' dummy
176: From dual
177: Where not exists (
178: Select null
179: From eng_revised_items eri
180: Where eri.change_notice = p_change_notice
181: And eri.organization_id = p_organization_id
182: And eri.status_type not in (6, 5));
183:

Line 189: From eng_revised_items eri

185: Select 'x' dummy
186: From dual
187: Where exists (
188: Select null
189: From eng_revised_items eri
190: Where eri.change_notice = p_change_notice
191: And eri.organization_id = p_organization_id
192: And eri.status_type = 6);
193: BEGIN

Line 338: from ENG_REVISED_ITEMS eri

334: and mriv.change_notice is null))
335: or
336: (bor.alternate_routing_designator is not null))
337: and not exists (select null
338: from ENG_REVISED_ITEMS eri
339: where eri.organization_id = bor.organization_id
340: and eri.routing_sequence_id = bor.routing_sequence_id
341: and eri.revised_item_sequence_id <> rev_item_seq
342: and eri.status_type <> 5);

Line 374: from eng_revised_items I

370: where REVISED_ITEM_SEQUENCE_ID = rev_item_seq);*/
371: -- Added revision_id to where clause for performance bug 4251776
372: delete from MTL_ITEM_REVISIONS_TL
373: where revision_id IN (select new_item_revision_id
374: from eng_revised_items I
375: WHERE REVISED_ITEM_SEQUENCE_ID = rev_item_seq);
376: DELETE FROM MTL_ITEM_REVISIONS_B I
377: where revision_id IN (select new_item_revision_id
378: from eng_revised_items I

Line 378: from eng_revised_items I

374: from eng_revised_items I
375: WHERE REVISED_ITEM_SEQUENCE_ID = rev_item_seq);
376: DELETE FROM MTL_ITEM_REVISIONS_B I
377: where revision_id IN (select new_item_revision_id
378: from eng_revised_items I
379: WHERE REVISED_ITEM_SEQUENCE_ID = rev_item_seq);
380: /*WHERE REVISED_ITEM_SEQUENCE_ID = rev_item_seq;*/
381:
382:

Line 402: FROM ENG_REVISED_ITEMS R

398: AND B2.ASSEMBLY_ITEM_ID = B.ASSEMBLY_ITEM_ID
399: AND B2.ALTERNATE_BOM_DESIGNATOR IS NOT NULL))
400: OR
401: (NOT EXISTS (SELECT NULL
402: FROM ENG_REVISED_ITEMS R
403: WHERE R.ORGANIZATION_ID = B.ORGANIZATION_ID
404: AND R.BILL_SEQUENCE_ID = B.BILL_SEQUENCE_ID
405: AND R.REVISED_ITEM_SEQUENCE_ID <> rev_item_seq
406: AND R.STATUS_TYPE <> 5)));

Line 413: UPDATE ENG_REVISED_ITEMS R

409:
410: -- If bill was deleted, then unset the bill_sequence_id on the revised item
411:
412: if (SQL%ROWCOUNT > 0) then
413: UPDATE ENG_REVISED_ITEMS R
414: SET BILL_SEQUENCE_ID = ''
415: , cancel_comments = cancel_comments
416: , cancellation_date = SYSDATE
417: WHERE R.REVISED_ITEM_SEQUENCE_ID = rev_item_seq;

Line 510: FROM ENG_REVISED_ITEMS eri

506: AND bor2.ALTERNATE_ROUTING_DESIGNATOR IS NOT NULL))
507: OR
508: (bor1.ALTERNATE_ROUTING_DESIGNATOR IS NOT NULL
509: AND NOT EXISTS (SELECT NULL
510: FROM ENG_REVISED_ITEMS eri
511: WHERE eri.ORGANIZATION_ID = bor1.ORGANIZATION_ID
512: AND eri.ROUTING_SEQUENCE_ID = bor1.ROUTING_SEQUENCE_ID
513: AND eri.CHANGE_NOTICE <> change_order)));*/
514:

Line 521: UPDATE ENG_REVISED_ITEMS eri

517: -- If routing was deleted, then unset the routing_sequence_id on the revised item
518:
519: --if (SQL%ROWCOUNT > 0) then
520: IF (l_del_rtg_header = 1) THEN -- Bug 3668603
521: UPDATE ENG_REVISED_ITEMS eri
522: SET routing_sequence_id = ''
523: , cancel_comments = cancel_comments
524: , cancellation_date = SYSDATE
525: WHERE eri.REVISED_ITEM_SEQUENCE_ID = rev_item_seq;

Line 716: UPDATE ENG_REVISED_ITEMS

712: x_err_text => l_err_text);
713: END IF;
714: END IF;
715:
716: UPDATE ENG_REVISED_ITEMS
717: SET new_item_revision_id = l_new_item_rev_id,
718: new_lifecycle_state_id = l_new_life_cycle_state_id
719: WHERE REVISED_ITEM_SEQUENCE_ID = p_revised_item_seq_id;
720:

Line 790: UPDATE ENG_REVISED_ITEMS

786: p_control_rec.caller_type <> 'FORM'
787: THEN
788: BEGIN
789: l_stmt_num := 1;
790: UPDATE ENG_REVISED_ITEMS
791: SET CHANGE_NOTICE = p_revised_item_rec.eco_name
792: , ORGANIZATION_ID = p_rev_item_unexp_rec.organization_id
793: , REVISED_ITEM_ID = p_rev_item_unexp_rec.revised_item_id
794: , LAST_UPDATE_DATE = SYSDATE

Line 1013: ENG_REVISED_ITEMS_PKG.Delete_Item_Revisions

1009: -- exists
1010: IF Bom_Globals.Get_Debug = 'Y' THEN Error_Handler.Write_Debug('Deleting Item Revisions . . .'); END IF;
1011:
1012: l_stmt_num := 3;
1013: ENG_REVISED_ITEMS_PKG.Delete_Item_Revisions
1014: ( x_change_notice =>
1015: p_revised_item_rec.eco_name
1016: , x_organization_id =>
1017: p_rev_item_unexp_rec.organization_id

Line 1046: /* ENG_REVISED_ITEMS_PKG.Update_Item_Revisions

1042:
1043:
1044: l_stmt_num := 4;
1045:
1046: /* ENG_REVISED_ITEMS_PKG.Update_Item_Revisions
1047: ( x_revision =>
1048: p_revised_item_rec.updated_revised_item_revision
1049: -- , x_scheduled_date => p_revised_item_rec.new_effective_date
1050: , x_scheduled_date =>

Line 1145: ENG_REVISED_ITEMS_PKG.Insert_Item_Revisions

1141:
1142: IF Bom_Globals.Get_Debug = 'Y' THEN Error_Handler.Write_Debug('Inserting Item Revisions . . .'); END IF;
1143: l_stmt_num := 5;
1144: IF (p_revised_item_rec.new_effective_date is NULL) THEN
1145: ENG_REVISED_ITEMS_PKG.Insert_Item_Revisions
1146: ( x_inventory_item_id =>
1147: p_rev_item_unexp_rec.revised_item_id
1148: , x_organization_id =>
1149: p_rev_item_unexp_rec.organization_id

Line 1164: ENG_REVISED_ITEMS_PKG.Insert_Item_Revisions

1160: , x_revision_description =>
1161: p_revised_item_rec.new_revised_item_rev_desc
1162: );
1163: ELSE
1164: ENG_REVISED_ITEMS_PKG.Insert_Item_Revisions
1165: ( x_inventory_item_id =>
1166: p_rev_item_unexp_rec.revised_item_id
1167: , x_organization_id =>
1168: p_rev_item_unexp_rec.organization_id

Line 1336: ENG_REVISED_ITEMS_PKG.Update_Inventory_Components

1332: l_stmt_num := 6;
1333:
1334: IF Bom_Globals.Get_Debug = 'Y' THEN Error_Handler.Write_Debug('Updating effective daste for child rev comps . . .'); END IF;
1335:
1336: ENG_REVISED_ITEMS_PKG.Update_Inventory_Components
1337: ( x_change_notice =>
1338: p_revised_item_rec.eco_name
1339: , x_bill_sequence_id =>
1340: p_rev_item_unexp_rec.bill_sequence_id

Line 1636: INSERT INTO ENG_REVISED_ITEMS

1632: p_control_rec.validation_controller = 'MAIN_EFFECTS')
1633: OR
1634: p_control_rec.caller_type <> 'FORM'
1635: THEN
1636: INSERT INTO ENG_REVISED_ITEMS
1637: (
1638: CHANGE_NOTICE
1639: , ORGANIZATION_ID
1640: , REVISED_ITEM_ID

Line 1841: ENG_REVISED_ITEMS_PKG.Insert_Item_Revisions

1837: p_revised_item_rec.new_revised_item_revision <> FND_API.G_MISS_CHAR
1838: )
1839: THEN
1840: IF Bom_Globals.Get_Debug = 'Y' THEN Error_Handler.Write_Debug('Inserting item revisions . . . '); END IF;
1841: ENG_REVISED_ITEMS_PKG.Insert_Item_Revisions
1842: ( x_inventory_item_id =>
1843: p_rev_item_unexp_rec.revised_item_id
1844: , x_organization_id =>
1845: p_rev_item_unexp_rec.organization_id

Line 1942: ENG_REVISED_ITEMS_PKG.Create_BOM

1938: );
1939:
1940: IF Bom_Globals.Get_Debug = 'Y' THEN Error_Handler.Write_Debug('Creating Altenate BOM . . .'); END IF;
1941:
1942: ENG_REVISED_ITEMS_PKG.Create_BOM
1943: ( x_assembly_item_id =>
1944: p_rev_item_unexp_rec.revised_item_id
1945: , x_organization_id =>
1946: p_rev_item_unexp_rec.organization_id

Line 1966: UPDATE ENG_REVISED_ITEMS

1962:
1963: -- Added by MK on 02/15/2001 for Bug#1647352
1964: -- Set Bill Sequence Id to Revised Item table
1965: --
1966: UPDATE ENG_REVISED_ITEMS
1967: SET bill_sequence_id = p_rev_item_unexp_rec.bill_sequence_id
1968: , last_update_date = SYSDATE -- Last Update Date
1969: , last_updated_by = l_user_id -- Last Updated By
1970: , last_update_login = l_login_id -- Last Update Login

Line 2105: FROM eng_revised_items

2101:
2102: INTO l_change_notice, l_organization_id, l_revised_item_id,
2103: l_revised_item_sequence_id, l_bill_sequence_id
2104: , l_routing_sequence_id -- Added by MK
2105: FROM eng_revised_items
2106: WHERE revised_item_sequence_id = p_revised_item_sequence_id;
2107:
2108: DELETE FROM ENG_REVISED_ITEMS
2109: WHERE REVISED_ITEM_SEQUENCE_ID = p_revised_item_sequence_id;

Line 2108: DELETE FROM ENG_REVISED_ITEMS

2104: , l_routing_sequence_id -- Added by MK
2105: FROM eng_revised_items
2106: WHERE revised_item_sequence_id = p_revised_item_sequence_id;
2107:
2108: DELETE FROM ENG_REVISED_ITEMS
2109: WHERE REVISED_ITEM_SEQUENCE_ID = p_revised_item_sequence_id;
2110:
2111: x_return_status := FND_API.G_RET_STS_SUCCESS;
2112:

Line 2130: ENG_REVISED_ITEMS_PKG.Delete_Details

2126: RETURN;
2127: END;
2128:
2129: BEGIN
2130: ENG_REVISED_ITEMS_PKG.Delete_Details
2131: ( x_organization_id => l_organization_id
2132: , x_revised_item_id => l_revised_item_id
2133: , x_revised_item_sequence_id => p_revised_item_sequence_id
2134: , x_bill_sequence_id => l_bill_sequence_id

Line 2326: FROM ENG_REVISED_ITEMS

2322: , l_revised_item_rec.routing_comment
2323: , l_revised_item_rec.eco_for_production -- Added by MK on 10/06/00
2324: , l_rev_item_unexp_rec.CHANGE_ID --Added ON 12/12/02
2325: , l_rev_item_unexp_rec.status_code -- Added for bug 3618676
2326: FROM ENG_REVISED_ITEMS
2327: WHERE revised_item_id = p_revised_item_id
2328: AND organization_id = p_organization_id
2329: AND change_notice = p_change_notice
2330: AND NVL(new_item_revision, 'NONE') = NVL(p_new_item_revision, 'NONE')

Line 2488: FROM eng_revised_items

2484:
2485: CURSOR c_revised_item (cp_revised_item_sequence_id NUMBER) IS
2486: SELECT revised_item_id, bill_sequence_id, routing_sequence_id,
2487: change_notice, organization_id
2488: FROM eng_revised_items
2489: WHERE revised_item_sequence_id = cp_revised_item_sequence_id;
2490:
2491: l_rev_item c_revised_item%ROWTYPE;
2492: -- R12 Changes for common BOM

Line 2499: , cp_revised_item_seq_id eng_revised_items.revised_item_sequence_id%TYPE

2495: -- Cursor to Fetch all source bill's component changes that are being updated
2496: -- by reschedule
2497: CURSOR c_source_components(
2498: cp_change_notice eng_engineering_changes.change_notice%TYPE
2499: , cp_revised_item_seq_id eng_revised_items.revised_item_sequence_id%TYPE
2500: , cp_bill_sequence_id bom_structures_b.bill_sequence_id%TYPE) IS
2501: SELECT bcb.component_sequence_id
2502: FROM bom_components_b bcb
2503: WHERE bcb.CHANGE_NOTICE = cp_change_notice

Line 2682: FROM eng_revised_items

2678: CURSOR c_revised_item (cp_revised_item_sequence_id NUMBER) IS
2679: SELECT change_notice, organization_id, revised_item_id, disposition_type
2680: , early_schedule_date, status_type, bill_sequence_id, mrp_active
2681: , DESCRIPTIVE_TEXT, change_id, ALTERNATE_BOM_DESIGNATOR, status_code
2682: FROM eng_revised_items
2683: WHERE revised_item_sequence_id = cp_revised_item_sequence_id;
2684:
2685: l_old_revised_item_rec c_revised_item%ROWTYPE;
2686: l_revised_item_rec Eng_Eco_Pub.Revised_Item_Rec_Type;

Line 2705: SELECT eng_revised_items_s.NEXTVAL INTO x_new_revised_item_seq_id FROM dual;

2701: --
2702: -- Generate a sequence_number for the new revised item
2703: -- Copy only attributes required for creation of revised item context
2704: --
2705: SELECT eng_revised_items_s.NEXTVAL INTO x_new_revised_item_seq_id FROM dual;
2706: l_revised_item_rec.eco_name := l_old_revised_item_rec.change_notice;
2707: l_rev_item_unexp_rec.organization_id := l_old_revised_item_rec.organization_id;
2708: l_rev_item_unexp_rec.revised_item_id := l_old_revised_item_rec.revised_item_id;
2709: l_revised_item_rec.disposition_type := l_old_revised_item_rec.disposition_type;