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 2109: -- Can insert a revision into MTL_RTG_ITEM_REVISIONS only

2105: , p_organization_id => l_rev_item_unexp_rec.organization_id
2106: , p_revision_date => SYSDATE
2107: );
2108:
2109: -- Can insert a revision into MTL_RTG_ITEM_REVISIONS only
2110: -- if it is not the same as the Current Revision
2111: -- Bug 4311691: Modified the if clause to check for l_rtg_rev_already_exists
2112: IF l_revised_item_rec.new_routing_revision <> l_current_rtg_revision AND
2113: l_rtg_rev_already_exists = 0

Line 2150: -- MTL_RTG_ITEM_REVISIONS

2146: FND_API.G_MISS_CHAR
2147: THEN
2148: --
2149: -- Insert updated routing revision information into
2150: -- MTL_RTG_ITEM_REVISIONS
2151: IF l_revised_item_rec.new_routing_revision IS NULL OR
2152: l_revised_item_rec.new_routing_revision
2153: = l_current_rtg_revision -- Added by MK on 02/13/2001
2154: THEN

Line 2162: -- MTL_RTG_ITEM_REVISIONS

2158: ELSE
2159: --
2160: -- Modified by MK on 10/24/00
2161: -- Update new routing revision information into
2162: -- MTL_RTG_ITEM_REVISIONS
2163: --
2164: IF Bom_Globals.Get_Debug = 'Y' THEN Error_Handler.Write_Debug('Rtg Revision set for Update. . .'); END IF;
2165:
2166: G_DEL_UPD_INS_RTG_REV := 2 ;

Line 2191: -- MTL_RTG_ITEM_REVISIONS

2187: ELSIF l_rtg_rev_already_exists = 1 AND
2188: l_revised_item_rec.updated_routing_revision <> l_current_revision
2189: THEN
2190: -- Update new routing revision information in
2191: -- MTL_RTG_ITEM_REVISIONS
2192:
2193: IF Bom_Globals.Get_Debug = 'Y' THEN Error_Handler.Write_Debug('Rtg Revision set for Update. . .'); END IF;
2194: G_DEL_UPD_INS_RTG_REV := 2;
2195: