APPS.AHL_PRD_SERN_CHANGE_PVT dependencies on FND_LOOKUPS

Line 142: l_lookup_code fnd_lookups.lookup_code%TYPE DEFAULT NULL;

138: AND meaning = p_lookup_meaning
139: AND TRUNC(SYSDATE) >= TRUNC(NVL(start_date_active, SYSDATE))
140: AND TRUNC(SYSDATE) < TRUNC(NVL(end_date_active, SYSDATE+1));
141:
142: l_lookup_code fnd_lookups.lookup_code%TYPE DEFAULT NULL;
143: l_return_val BOOLEAN DEFAULT TRUE;
144:
145: BEGIN
146:

Line 515: l_lookup_code fnd_lookups.lookup_code%TYPE;

511: l_serialnum_change_rec Sernum_Change_Rec_Type := p_serialnum_change_rec;
512: l_instance_dtls_rec c_instance_details%ROWTYPE;
513: l_get_workorder_rec get_workorder_csr%ROWTYPE;
514: l_mtl_system_items_rec mtl_system_items_csr%ROWTYPE;
515: l_lookup_code fnd_lookups.lookup_code%TYPE;
516: l_item_instance_id NUMBER;
517: l_return_val BOOLEAN;
518: l_attribute_value_id NUMBER;
519: l_object_version_number NUMBER;