APPS.ENG_DEFAULT_REVISED_ITEM dependencies on MTL_RTG_ITEM_REVISIONS

Line 1160: * at the mtl_rtg_item_revisions table and return the revision that

1156: * Paramters IN : Revised itemid
1157: * Organization ID
1158: * Revision Date
1159: * Purpose : Function will return the current item revision by looking
1160: * at the mtl_rtg_item_revisions table and return the revision that
1161: * has implementation date NOT NULL and is currently effective.
1162: ******************************************************************************/
1163: FUNCTION Get_Current_Rtg_Revision
1164: ( p_revised_item_id IN NUMBER

Line 1173: FROM MTL_RTG_ITEM_REVISIONS

1169: l_current_revision VARCHAR2(3) := NULL;
1170:
1171: CURSOR NO_ECO_ROUTING_REV IS
1172: SELECT process_revision
1173: FROM MTL_RTG_ITEM_REVISIONS
1174: WHERE INVENTORY_ITEM_ID = p_revised_item_id
1175: AND ORGANIZATION_ID = p_organization_id
1176: AND EFFECTIVITY_DATE <= p_revision_date
1177: AND IMPLEMENTATION_DATE IS NOT NULL

Line 1190: FROM MTL_RTG_ITEM_REVISIONS

1186: INTO l_current_revision
1187: FROM MTL_PARAMETERS mp
1188: WHERE mp.organization_id = p_organization_id
1189: AND NOT EXISTS( SELECT NULL
1190: FROM MTL_RTG_ITEM_REVISIONS
1191: WHERE implementation_date IS NOT NULL
1192: AND organization_id = p_organization_id
1193: AND inventory_item_id = p_revised_item_id
1194: ) ;

Line 1406: FROM MTL_RTG_ITEM_REVISIONS

1402: l_current_rtg_revision VARCHAR2(3) := 999;
1403:
1404: CURSOR c_Rtg_CheckRevision ( p_revision VARCHAR2) IS
1405: SELECT 1
1406: FROM MTL_RTG_ITEM_REVISIONS
1407: WHERE inventory_item_id = p_rev_item_unexp_rec.revised_item_id
1408: AND organization_id = p_rev_item_unexp_rec.organization_id
1409: AND process_revision = p_revision;
1410:

Line 2125: -- Can insert a revision into MTL_RTG_ITEM_REVISIONS only

2121: , p_organization_id => l_rev_item_unexp_rec.organization_id
2122: , p_revision_date => SYSDATE
2123: );
2124:
2125: -- Can insert a revision into MTL_RTG_ITEM_REVISIONS only
2126: -- if it is not the same as the Current Revision
2127: -- Bug 4311691: Modified the if clause to check for l_rtg_rev_already_exists
2128: IF l_revised_item_rec.new_routing_revision <> l_current_rtg_revision AND
2129: l_rtg_rev_already_exists = 0

Line 2166: -- MTL_RTG_ITEM_REVISIONS

2162: FND_API.G_MISS_CHAR
2163: THEN
2164: --
2165: -- Insert updated routing revision information into
2166: -- MTL_RTG_ITEM_REVISIONS
2167: IF l_revised_item_rec.new_routing_revision IS NULL OR
2168: l_revised_item_rec.new_routing_revision
2169: = l_current_rtg_revision -- Added by MK on 02/13/2001
2170: THEN

Line 2178: -- MTL_RTG_ITEM_REVISIONS

2174: ELSE
2175: --
2176: -- Modified by MK on 10/24/00
2177: -- Update new routing revision information into
2178: -- MTL_RTG_ITEM_REVISIONS
2179: --
2180: IF Bom_Globals.Get_Debug = 'Y' THEN Error_Handler.Write_Debug('Rtg Revision set for Update. . .'); END IF;
2181:
2182: G_DEL_UPD_INS_RTG_REV := 2 ;

Line 2207: -- MTL_RTG_ITEM_REVISIONS

2203: ELSIF l_rtg_rev_already_exists = 1 AND
2204: l_revised_item_rec.updated_routing_revision <> l_current_revision
2205: THEN
2206: -- Update new routing revision information in
2207: -- MTL_RTG_ITEM_REVISIONS
2208:
2209: IF Bom_Globals.Get_Debug = 'Y' THEN Error_Handler.Write_Debug('Rtg Revision set for Update. . .'); END IF;
2210: G_DEL_UPD_INS_RTG_REV := 2;
2211: