[Home] [Help]
2078:
2079: -- Added by MK on 02/15/2001
2080: IF ( l_rev_item_unexp_rec.bill_sequence_id IS NULL OR
2081: l_rev_item_unexp_rec.bill_sequence_id = FND_API.G_MISS_NUM ) AND
2082: (( p_revised_item_rec.transaction_type = ENG_GLOBALS.G_OPR_CREATE OR
2083: p_revised_item_rec.alternate_bom_code IS NOT NULL ) OR
2084: /* Added for Bug 2992001 */
2085: (p_revised_item_rec.transaction_type = ENG_GLOBALS.G_OPR_UPDATE))
2086: THEN
2081: l_rev_item_unexp_rec.bill_sequence_id = FND_API.G_MISS_NUM ) AND
2082: (( p_revised_item_rec.transaction_type = ENG_GLOBALS.G_OPR_CREATE OR
2083: p_revised_item_rec.alternate_bom_code IS NOT NULL ) OR
2084: /* Added for Bug 2992001 */
2085: (p_revised_item_rec.transaction_type = ENG_GLOBALS.G_OPR_UPDATE))
2086: THEN
2087:
2088: l_rev_item_unexp_rec.bill_sequence_id :=
2089: BOM_Val_To_Id.Bill_Sequence_Id
2102: END IF;
2103:
2104: IF ( l_rev_item_unexp_rec.routing_sequence_id IS NULL OR
2105: l_rev_item_unexp_rec.routing_sequence_id = FND_API.G_MISS_NUM ) AND
2106: ( p_revised_item_rec.transaction_type = ENG_GLOBALS.G_OPR_CREATE OR
2107: p_revised_item_rec.alternate_bom_code IS NOT NULL )
2108:
2109: THEN
2110:
2174:
2175: -- 11.5.10E
2176: -- Querying to find if the change is ERP or PLM change
2177: -- 'From Revision' changes are valid only for PLM changes
2178: l_eco_type := Eng_Globals.Get_PLM_Or_ERP_Change
2179: (p_revised_item_rec.eco_name,
2180: l_rev_item_unexp_rec.organization_id
2181: );
2182:
2188: IF (l_eco_type = 'PLM')
2189: THEN
2190: -- Changes to enable 'From Revision' for revised items.
2191: -- The from revision id is set from the revision label
2192: IF ( (p_revised_item_rec.transaction_type = ENG_GLOBALS.G_OPR_CREATE OR
2193: p_revised_item_rec.transaction_type = ENG_GLOBALS.G_OPR_UPDATE) AND
2194: p_revised_item_rec.from_item_revision IS NOT NULL)
2195: THEN
2196: l_rev_item_unexp_rec.from_item_revision_id := From_Revision_Id
2189: THEN
2190: -- Changes to enable 'From Revision' for revised items.
2191: -- The from revision id is set from the revision label
2192: IF ( (p_revised_item_rec.transaction_type = ENG_GLOBALS.G_OPR_CREATE OR
2193: p_revised_item_rec.transaction_type = ENG_GLOBALS.G_OPR_UPDATE) AND
2194: p_revised_item_rec.from_item_revision IS NOT NULL)
2195: THEN
2196: l_rev_item_unexp_rec.from_item_revision_id := From_Revision_Id
2197: ( p_assembly_item_id => l_rev_item_unexp_rec.revised_item_id
2226: END IF;
2227:
2228: -- The new revision reason, if provided is converted to the corresponding
2229: -- code.
2230: IF((p_revised_item_rec.transaction_type = ENG_GLOBALS.G_OPR_CREATE OR
2231: p_revised_item_rec.transaction_type = ENG_GLOBALS.G_OPR_UPDATE) AND
2232: p_revised_item_rec.New_Revised_Item_Revision IS NOT NULL AND
2233: p_revised_item_rec.new_revision_reason IS NOT NULL)
2234: THEN
2227:
2228: -- The new revision reason, if provided is converted to the corresponding
2229: -- code.
2230: IF((p_revised_item_rec.transaction_type = ENG_GLOBALS.G_OPR_CREATE OR
2231: p_revised_item_rec.transaction_type = ENG_GLOBALS.G_OPR_UPDATE) AND
2232: p_revised_item_rec.New_Revised_Item_Revision IS NOT NULL AND
2233: p_revised_item_rec.new_revision_reason IS NOT NULL)
2234: THEN
2235: l_rev_item_unexp_rec.new_revision_reason_code :=
2345: IF p_eco_rec.transaction_type = 'CREATE'
2346: THEN
2347: l_plm_or_erp_change := p_eco_rec.plm_or_erp_change;
2348: ELSE
2349: l_plm_or_erp_change := Eng_Globals.Get_PLM_Or_ERP_Change(
2350: p_ECO_Rec.eco_name
2351: , p_ECO_Unexp_Rec.organization_id);
2352: END IF;
2353: